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!=27501658 having distance <= 11 order by distance limit 3
Welcome to 922 9th Avenue, located in the desirable & friendly community of Desert Cove!Embrace retirement & the Okanagan lifestyle in this gated community for adults aged 40 & over! This immaculate 2 Bed, 2 Bath Rancher with basement features an open modern concept.The kitchen provides an excellent area for cooking & hosting, the bright kitchen boasts SS appliances, Quartz counter tops, soft close drawers & 6ft island with breakfast bar.The open great room/living room & dining room are warm & cozy with an electric F/P. There is easy access to backyard through sliding doors off the dining room. Enjoy the beautifully maintained & manicured backyard. The partially covered concrete patio is perfect for outdoor living, enjoy the benefits of a low-maintenance yard, featuring a fully xeriscaped design with an efficient drip irrigation system.The primary bedroom is a generous size with 4 pc en-suite & w/i closet.There is a second bedroom, bathroom, & laundry on the main floor.The basement is partially finished with family/tv room & a very spacious storage/mechanical area.This home provides access to a wealth of community amenities & activities. Desert Cove Community offers a swimming pool, hot tub, library, exercise room, sewing room, & more fun activities to enjoy & maintain an active lifestyle.Convenient location only a short drive from Vernon, close to golf, lakes, skiing & amenities.Contact your agent today to schedule a viewing & experience this beautiful home for yourself! (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®)
