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

20 Cottonwood Road Lot# A For Sale

westbridge, British Columbia V0H1Y0
$ 525,000
$ 438 / Sq. Ft.
  • ©MLS 10320289
  • Area 1200 sq ft
  • Bedrooms 3
  • Bathrooms 1

Description

Just under 2 flat acres boarding crown land. Newer rancher built in 2018. 3 bedrooms. Open concept with efficient wood stove in middle. Window air + ductless wall air unit. Green house, pergola for entertaining. Very private and quiet, yet several neighbor's are in area. (id:48970) Show More

Details

  • Constructed Date: 2018
  • Property Type: Single Family
  • Type: House
  • Access Type: Highway access
  • Architectural Style: Ranch
  • Neighbourhood: Beaverdell/Carmi

Features

  • Private setting
  • Rural Setting
  • Wall unit
  • Window air conditioner
  • Baseboard heaters
  • See remarks

Rooms Details For 20 Cottonwood Road Lot# A

Type Level Dimension
3pc Bathroom Main level 6' x 7'
Laundry room Main level 3' x 3'
Primary Bedroom Main level 10' x 14'
Bedroom Main level 8' x 10'
Bedroom Main level 12' x 8'6''
Living room Main level 16' x 14'
Dining room Main level 10' x 14'
Kitchen Main level 12' x 13'

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