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

13 6211 W BOUNDARY DRIVE For Sale

surrey, British Columbia V3X3G7
$ 974,900
$ 452 / Sq. Ft.
  • ©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

©️ Hybrid Real Estate Plugin For CREA DDF

The trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. The trademark DDF® is owned by The Canadian Real Estate Association (CREA) and identifies CREA's Data Distribution Facility (DDF®)