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!=26593641 having distance <= 11 order by distance limit 3

574 Meadowlark Avenue For Sale

vernon, British Columbia V1H2A1
$ 399,700
$ 305 / Sq. Ft.
  • ©MLS 10306301
  • Area 1310 sq ft
  • Bedrooms 3
  • Bathrooms 2
  • Parkings 2

Description

The Juniper - Under construction brand new ranch style home in the beautiful lakeside community of Parker Cove. Quality built by Scotland Homes, the Juniper is a level entry rancher featuring 3 beds and 2 baths. Step inside to discover the open concept layout with spacious living room featuring propane fireplace and sliding glass doors onto the covered back deck, offering seamless indoor-outdoor living. A large dining room is just off of the fantastic chef's kitchen with ample cabinets, oversized entertainer's island and quartz surround countertops. The primary bedroom is flooded in daylight, and features large ensuite with generous size shower and walk in closet/built ins. Two additional bedrooms, full bath, and laundry round off the living areas. Attached two car garage. Parker Cove provides a myriad of recreational activities - Enjoy sunny days at the beach, take a dip in the swimming area, enjoy the community playground and ball diamonds. Parker Cove is a leasehold community, 574 Meadowlark features a secure registered lease extending to 2056. Experience affordable waterfront living and the Okanagan lifestyle at Parker Cove. Construction underway, estimated completion August 2024. Parker Cove is located 30 minutes from Vernon. Builder upgrades are available. (id:48970) Show More

Details

  • Constructed Date: 2024
  • Property Type: Single Family
  • Type: House
  • Architectural Style: Ranch
  • Neighbourhood: Okanagan North

Features

  • Pets Allowed
  • 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®)