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!=26651048 having distance <= 11 order by distance limit 3
The Birch - Ready Now! 3 bed 2 bath Ranch style home located in the beautiful lakeside community of Parker Cove. The Birch model by Scotland Homes offers open concept, one level living, flooded with natural daylight. The home opens into a large foyer, with guest bed or office off the entrance. The hub of the home features fantastic chef's kitchen, ample cabinet space, quartz surround countertops, large island perfect for entertaining. The large living/dining area is graced with a propane fireplace, sliding glass doors into backyard/patio area, tray ceiling. The spacious primary bedroom features large walk in closet/built ins, and full ensuite/generous size shower and beautiful finishes. A third good size bedroom and full bath round off the living areas. A separate dedicated laundry room offers access into the attached two car garage. Parker Cove provides multiple recreational activities - Enjoy sunny days at the community beach on the shores of Okanagan Lake. Enjoy the community greenspaces featuring ball diamonds, playground and picnic areas. Parker Cove is a leasehold community, 577 Meadowlark features a secure registered lease to 2056. Experience affordable waterfront living and the Okanagan Lifestyle. Home features builder upgrades including full appliance package, heated floors in ensuite bath and landscaping. Only 30 mins to Vernon. (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®)
