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
- ©MLS 10307628
- Area 1435 sq ft
- Bedrooms 3
- Bathrooms 2
- Parkings 2
Description
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
Details
- Constructed Date: 2024
- Property Type: Single Family
- Type: House
- Architectural Style: Ranch
- Neighbourhood: Okanagan North
Features
- Mountain view
- Heat Pump
- Heat Pump
- Waterfront nearby
Location
This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Okanagan-Mainline Real Estate Board