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` = '3' and ListingID!=27548436 having distance <= 11 order by distance limit 3
- ©MLS R2936208
- Area 2156 sq ft
- Bedrooms 3
- Bathrooms 3
- Parkings 2
Description
Welcome to your dream retirement home in Panorama Ridge! This 55+ luxury end unit townhouse is ideal for downsizers seeking spacious living. 2150 sq. ft, offers a blend of style, functionality & plenty of natural light. The entranceway w/vaulted ceilings create an open & airy feel. 3 generous bedrms & 3 bath have plenty of space for guests & family. Kitchen has new appliances, eating area & a full dining rm space. Potential to add in an elevator for comfort & convenience. A side-by-side garage w/workbench & shelves offers space for parking & storage. Warm up by one of the 3 gas fireplaces in the winter. Updates inc PEX plumbing, new appliances, hot water tank, flooring & paint. The backyard is a gardener's paradise. Plus, it's walking distance to Boundary Park's picturesque lake & trails. (id:48970) Show More
Details
- Age: 34 Years
- Property Type: Single Family
- Type: Row / Townhouse
- Architectural Style: 2 Level, Other
- Maintenance Fee: 483.23/Monthly
Ammenities + Nearby
- Clubhouse
- Laundry - In Suite
Features
- Age Restrictions
- Pets Allowed With Restrictions
- Washer
- Dryer
- Refrigerator
- Stove
- Dishwasher
- Garage door opener
- Alarm System - Roughed In
- Central Vacuum
- Unknown
- Smoke Detectors
- Forced air
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