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` = '1' and `BedroomsTotal` = '1' and ListingID!=27521479 having distance <= 11 order by distance limit 3
- ©MLS R2933931
- Area 569 sq ft
- Bedrooms 1
- Bathrooms 1
- Parkings 1
Description
Cozy 1 Bed 1 Bath, west facing condo offers a warm, homey feel with its open-plan gourmet kitchen featuring elegant granite countertops, stainless steel appliances, and a gas range. The spacious bedroom includes custom walk-thru closets and a full cheater ensuite. Relax on your covered balcony with a sunset view and gas connection. Pet-friendly with no size limit and a nearby dog park. Enjoy the convenience of being close to parks, Willowbrook Shopping, Costco, restaurants, transit, major routes, and the future Skytrain line. An excellent investment opportunity! (id:48970) Show More
Details
- Age: 9 Years
- Property Type: Single Family
- Type: Apartment
- Architectural Style: Other
- Maintenance Fee: 276.35/Monthly
Ammenities + Nearby
- Laundry - In Suite
- Recreation Centre
Features
- Pets Allowed With Restrictions
- Washer
- Dryer
- Refrigerator
- Stove
- Dishwasher
- Microwave
- Baseboard heaters
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
