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!=27702957 having distance <= 11 order by distance limit 3
Discover the perfect blend of modern living and serene surroundings at 9 Hibiscus Court. Currently under construction and scheduled for completion in early to mid-2025, this stunning family home will offer over 3,000 sq/ft of thoughtfully designed space. The 5-bedroom, 3-bath layout is tailored for growing families, with an open-concept main living area that welcomes natural light and seamless flow. The lower level provides the potential to develop a suite—ideal for extended family, guests, or rental income. Nestled in a brand-new subdivision just minutes from town, this home is also a stone’s throw from Haynes Point, where outdoor adventures and waterfront views await. This location combines convenience and tranquillity in perfect harmony. Secure your spot in this sought-after neighbourhood. Act now to customize finishes and make this house truly your own! (Currently under-construction finishes and pricing subject to change without notice) (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®)
