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!=27132641 having distance <= 11 order by distance limit 3
Welcome to Desert Cove Estates! Embrace retirement and the Okanagan lifestyle in this exceptional gated community exclusively for adults aged 40 and over! This well-kept 2-bedroom, 2-bath level entry home retains its new feel, thanks to the meticulous maintenance by its original owners. Featuring an open modern concept and luminous living space. The kitchen provides an excellent area for cooking and hosting, featuring a spacious island conveniently located near the dining area and living room. The basement features newer flooring and awaits your creative touch for finishing or can serve as ample storage space.. Enjoy easy access to the beautifully maintained backyard with garden area, pond and a spacious covered outdoor sunshade room! This well kept adult community offers a range of amenities including a community center, saltwater pool, library, exercise room, craft room, pool tables. With golf nearby and Vernon just a 10-minute drive away, (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®)
