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!=27662444 having distance <= 11 order by distance limit 3
OPPORTUNITY OF A LIFETIME - BRAND NEW 1500+ SQFT GREAT PRICE RANCHER HOME COMING SOON! Introducing the well laid out 3 bedroom, 2 bathroom with 9ft vaulted ceilings, open concept, energy efficient home with the security of the new build Warranty! This beautiful home has large inviting space with vinyl plank flooring throughout, very spacious primary bedroom featuring a large walk through closet and ensuite bathroom. With a bright and airy “L” shaped kitchen with quartz counter island and plenty of cupboards and gas stove! Step out of sliding doors out of the living room and also the master bedroom, relax while entertaining friends and family in your private back yard! This beautiful mountain view patio features stamped concrete patio, and gas BBQ outlet perfect for summer dinners! Additionally this home features a fully heated deep single car garage with roughed in EV charger and additional outdoor parking. This beautiful development is only 5 minutes from downtown Oliver shopping, restaurants, recreation, the best wineries, parks and schools and more! Fairview Mountain Golf Course and driving range is just around the corner with Area 27 Raceway Park only a few km away for those car enthusiasts! Low bare land strata fee of $99/mo. GST is applicable. All measurements should be verified if important. Inquire 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®)
