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` = '6' and `BedroomsTotal` = '4' and ListingID!=27462609 having distance <= 11 order by distance limit 3
This lovely residence is situated in the highly sought-after Auguston Community, making it an ideal choice for families. The house boasts an abundance of fantastic living areas, including four bedrooms on the upper level and an additional two in the Basement. On the main floor, you'll find a generously sized open concept plan, with a well-appointed kitchen that offers ample cabinet space and a large island. The kitchen seamlessly flows into the family room, creating a wonderful space for entertaining friends and loved ones. The large south-facing windows flood the area with natural light, creating a warm and inviting atmosphere. The home also features a separate living room and a dining room, providing the perfect setting for formal gatherings. Schedule a private viewing today. (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®)
