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

1581 20th Street NE Unit# 37 For Sale

salmon arm, British Columbia V1E0A7
$ 889,500
$ 276 / Sq. Ft.
  • ©MLS 10314171
  • Area 3220 sq ft
  • Bedrooms 3
  • Bathrooms 3
  • Parkings 4

Description

Stunning custom built Rancher with daylight walkout basement in the popular Willow Cove subdivision, a quiet bare land strata close to amenities. This homes many features include; large open floor plan, 9 ft ceiling and lots of natural light, large custom kitchen, loads of cupboards, soft drawer closing, granite counters & pantry. Large Primary bedroom, spacious ensuite with double sinks, shower & soaker tub, walk in closet, N/G fireplace, laundry and den complete the main floor. Oak hardwood flooring throughout with ceramic tile in kitchen, bathrooms and foyer. Covered tiled deck off kitchen with Gas BBQ hookup, covered deck off dining area to sit and enjoy the view. Downstairs has large 2 bedrooms, full bath, family room, large storage room, lots of windows with great walk out covered patio. Custom wooden blinds throughout house. This house shows like brand new. A must see. Call before its gone!! (id:48970) Show More

Details

  • Constructed Date: 2008
  • Property Type: Single Family
  • Type: House
  • Architectural Style: Ranch
  • Community: WILLOW COVE
  • Neighbourhood: NE Salmon Arm
  • Maintenance Fee: 79.00/Monthly

Features

  • Irregular lot size
  • One Balcony
  • Pets Allowed
  • Mountain view
  • Refrigerator
  • Dishwasher
  • Dryer
  • Range - Gas
  • Washer
  • Central air conditioning
  • Heat Pump
  • Security system
  • Smoke Detector Only
  • Forced air
  • Heat Pump
  • See remarks

Rooms Details For 1581 20th Street NE Unit# 37

Type Level Dimension
Storage Basement 12'9'' x 18'6''
Other Basement 12'9'' x 5'2''
Bedroom Basement 12'0'' x 12'10''
Utility room Basement 10'6'' x 6'10''
3pc Bathroom Basement 8'8'' x 6'11''
Recreation room Basement 23'4'' x 33'8''
Bedroom Basement 16'7'' x 13'8''
Den Main level 12'0'' x 10'10''
Other Main level 18'11'' x 18'10''
Other Main level 7'11'' x 6'9''
5pc Ensuite bath Main level 12'6'' x 11'3''
Primary Bedroom Main level 15'11'' x 13'4''
Laundry room Main level 8'7'' x 6'10''
Kitchen Main level 13'0'' x 14'6''
Dining room Main level 12'1'' x 11'6''
Living room Main level 24'2'' x 18'11''
2pc Bathroom Main level 6'1'' x 5'4''
Foyer Main level 11'0'' x 14'11''

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