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` = '5' and `BedroomsTotal` = '3' and ListingID!=27720121 having distance <= 11 order by distance limit 3
This beautifully renovated home is ideally located near Sunshine Hills Elementary (French Immersion), Seaquam Secondary (IB Program), and Water Shed Park. It features good size 5 bedrooms, updated floors, finishes, lighting, windows, and a modern kitchen with high-end cabinetry and granite countertops. The open living space boasts vaulted ceilings, a functional layout, and a 4 ft crawl space for storage. Enjoy outdoor entertaining with a wrap-around 443 sq ft deck and an expansive 301 sq ft covered patio. Perfect for year-round BBQs and gatherings! (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®)
