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

211 2nd Street For Sale

vernon, British Columbia V1H1Z1
$ 434,500
$ 330 / Sq. Ft.
  • ©MLS 10324385
  • Area 1316 sq ft
  • Bedrooms 2
  • Bathrooms 2
  • Parkings 2

Description

Great value at Desert Cove. Estate sale and priced to go. Desirable and unique plan with huge carport and an an abundance of parking. Affordable adult living with an active resort lifestyle. Great, amenities including indoor pool, RV parking, outdoor social and recreation areas, spacious clubhouse with full function kitchen, hobby room, library, gym and lots more. Lease is pre-paid to 2055. Vacant and quick possession available. (id:48970) Show More

Details

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

Features

  • Level lot
  • Seniors Oriented
  • Central air conditioning
  • Forced air
  • See remarks

Rooms Details For 211 2nd Street

Type Level Dimension
Other Main level 8'0'' x 8'0''
Other Main level 22'0'' x 13'6''
Other Main level 28'0'' x 15'0''
Foyer Main level 12'3'' x 11'4''
Laundry room Main level 8'0'' x 13'4''
Full bathroom Main level 5'0'' x 8'0''
3pc Ensuite bath Main level 5'0'' x 11'0''
Bedroom Main level 8'9'' x 11'4''
Primary Bedroom Main level 11'10'' x 13'3''
Kitchen Main level 910'0'' x 8'0''
Dining room Main level 9'0'' x 8'4''
Living room Main level 18'5'' x 16'8''

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