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` = '2' and `BedroomsTotal` = '2' and ListingID!=27422441 having distance <= 11 order by distance limit 3
Step into your NEW 2024 home! It's just the right size Rancher in Sicamous! 2 spacious bedrooms and 2 full bathrooms, this property includes modern amenities such as Central A/C and an attached garage. Great location! Take a leisurely stroll to the city park with its ball diamonds and complimentary outdoor gym, while picturesque hiking and biking trails await just around the corner. The local school is conveniently situated a short distance away. Embrace the idyllic four-season lifestyle in this community, with activities such as boating on the expansive surrounding lake, biking, sledding, and off-road adventures. Municipal water and sewer services are covered, and a monthly bare land strata fee of $55.00 provides road snow removal, street cleaning, garbage disposal, management, and a contingency fund. There are no age restrictions, and long term rentals are allowed. Bonus: Bring your (2) furry companions. Don't miss out! (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®)