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

575 Meadowlark Avenue For Sale

vernon, British Columbia V1H2A1
$ 409,700
$ 286 / Sq. Ft.
  • ©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

©️ Hybrid Real Estate Plugin For CREA DDF

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®)