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` = '2' and `BedroomsTotal` = '2' and ListingID!=27010473 having distance <= 11 order by distance limit 3

628 6th Avenue For Sale

vernon, British Columbia V1H1Z1
$ 495,000
$ 321 / Sq. Ft.
  • ©MLS 10315702
  • Area 1540 sq ft
  • Bedrooms 2
  • Bathrooms 2
  • Parkings 4

Description

Welcome to Desert Cove and this lovely well kept 2 Bed 2 Bath Rancher with a bonus flex space as well as additional storage space off the laundry room. Bright kitchen, newer appliances with attached family room or creative space. Desert Cove offers a full event schedule, and exercise program in clubhouse along with pool, hot tub, rec hall, library and work out space. Spoiler alert: you will need a 3rd arm to wave at the friendly folks who walk, run and golf cart to enjoy the scenery in this community :) (id:48970) Show More

Details

  • Constructed Date: 1994
  • Property Type: Single Family
  • Type: House
  • Community: Desert Cove Estates
  • Neighbourhood: Swan Lake West

Features

  • Jacuzzi bath-tub
  • Rentals Allowed
  • Seniors Oriented
  • Refrigerator
  • Dishwasher
  • Range - Electric
  • Microwave
  • Hood Fan
  • Washer/Dryer Stack-Up
  • Water softener
  • Central air conditioning
  • See remarks

Rooms Details For 628 6th Avenue

Type Level Dimension
Full bathroom Main level 7' x 6'
Full ensuite bathroom Main level 7' x 6'
Family room Main level 12' x 10'
Bedroom Main level 12' x 9'
Dining room Main level 12' x 11'
Primary Bedroom Main level 13' x 13'
Living room Main level 16' x 15'
Kitchen Main level 10' x 9'

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