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!=26768991 having distance <= 11 order by distance limit 3
- ©MLS 10310325
- Area 1435 sq ft
- Bedrooms 3
- Bathrooms 2
- Parkings 2
Description
Brand new home under construction, located in the beautiful community of Parker Cove on the shores of Okanagan Lake. Quality built by Scotland Homes, the Aspen is the premier plan featuring 3 beds/2 baths. Open concept living flooded with natural daylight awaits. Step into the bright and spacious foyer with great office or 3rd bed located at the front of the home. Large chef's kitchen with quartz surround countertops, oversized island, and ceiling height cabinetry set the stage for entertaining. Large dining area and living room with propane fireplace, sliding doors to back patio for seamless indoor outdoor living. Full bath, dedicated laundry room off of the attached two car garage. The primary bedroom is located at the rear of the home and features a large walk in closet/built ins and spacious ensuite/large shower. A third good size bedroom and full bath round off the living areas. Parker Cove offers endless recreational options - enjoy your days at the community beach featuring over 2000' of shared waterfront on Okanagan Lake. Community playground and ball diamonds, great picnic areas and outdoor living await. 575 Meadowlark features a secure registered lease extending to 2056. Experience affordable waterfront community living and the Okanagan Lifestyle. Home is under construction and ready Fall 2024. Builder upgrades are available. 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