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!=27534381 having distance <= 11 order by distance limit 3
Desert Cove Estates - voted BC Best Adult Community located just outside Vernon. Desret Cove backs onto the beautiful Spallumcheen 27 hole golf course, plus is a 10 minute ride to Okanagan Lake which is just down the road. This 2 year old, semi-custom home with a double garage, looks onto a large green space across the street. This property is completely finished for a lock and leave down south lifestyle or enjoy the fabulous on-site amenities of Okanagan living all year long. Main floor consists of 1519 sq ft with an open concept kitchen, living & dining room making entertaining easy. Relax on the outdoor patio or sit out front on the deck & enjoy quiet evenings. Along with 3 bedrooms on the main, the primary bed has a large custom shower & sliding doors leading out back to the private hot tub. A bonus putting green along with a zeroscape landscaped yard makes everything low maintenance. Upgrades include; custom garage door, exposed aggregate concrete driveway & patios, black stainless steel appliances & custom butler's pantry. Monthly maintenance fee includes full access to the complex recreation centre which has an indoor salt water pool, hot tub, library, pool table room, craft & exercise rooms along with a large hall & kitchen for dances & community events. Outdoors find a bocce & horseshoe pit with picnic tables. Snow plowing, water, garbage & recycle is also included in the monthly fee. Must be 40+, pets allowed with restrictions. Book your 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®)
