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!=27572331 having distance <= 11 order by distance limit 3
Welcome to spacious 3-bed, 2-bath townhouse, ideal for a growing family. The main level boasts an open concept floor plan with a generously sized living and dining area. The bright kitchen includes a separate eating nook, which opens directly to a private backyard patio - perfect for barbecuing and gardening. Situated away from traffic noise, offers peace and quiet within the complex. Conveniently located near transit, with easy access to Highway 1 and Highway 17, and across the street from the Surrey Sport & Aquatic Centre and Baselines Pub. Plus, the upcoming SkyTrain extension is already under construction, adding even more value to the area! The two-car garage provides ample storage space, with the potential for a workshop or home office. This is a must-see property in a prime location (id:48970) Show More
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®)
