WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '* pi()/180) * COS(Latitude * pi()/180) * POWER(SIN(( - Longitude) * pi()/18...' at line 1]SELECT * , (3956 * 2 * ASIN(SQRT( POWER(SIN(( - Latitude) * pi()/180 / 2), 2) +COS( * pi()/180) * COS(Latitude * pi()/180) * POWER(SIN(( - Longitude) * pi()/180 / 2), 2) ))) as distance from wp_phl_property where `property_id`>0 and `Sold` != '1' and `TransactionType` = 'For sale' and `BedroomsTotal` = '3' and `BedroomsTotal` = '2' and ListingID!=27560083 having distance <= 11 order by distance limit 3
- ©MLS R2936593
- Area 882 sq ft
- Bedrooms 3
- Bathrooms 2
Description
Welcome to this beautifully designed 3-bedroom, 2-bathroom condo in the heart of Fleetwood! Located at 504-15848 Fraser Highway, this 890 sqft home by Dawson and Sawyer offers a perfect blend of comfort and style. The open-concept layout maximizes space and natural light, creating a warm and inviting atmosphere. The modern kitchen features sleek appliances and ample storage, making it ideal for both cooking and entertaining. Each bedroom is thoughtfully designed, providing plenty of room for relaxation. Enjoy the convenience of in-suite laundry and a prime location close to parks, schools, shopping, and transit options. This condo is perfect for families, first-time buyers, or investors seeking a vibrant community. Don't miss this opportunity to own a piece of Fleetwood! (id:48970) Show More
Details
- Age: 1 Years
- Property Type: Single Family
- Type: Apartment
- Architectural Style: 5 Level, Other
- Maintenance Fee: 402.87/Monthly
Ammenities + Nearby
- Clubhouse
- Daycare
- Exercise Centre
- Laundry - In Suite
- Storage - Locker
Features
- Rentals Allowed
- Playground
- Washer
- Dryer
- Refrigerator
- Stove
- Dishwasher
- Intercom
- Microwave
- Smoke Detectors
- Sprinkler System-Fire
- Baseboard heaters
- Storage
Location
This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Fraser Valley Real Estate Board