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

4210 MOLE ROAD Unavailable

burton, British Columbia V0G1R0
  • ©MLS 2479820
  • Area 2140 sq ft
  • Bedrooms 3
  • Bathrooms 2

Description

This property is unfortunately not available anymore. It may be sold, expired, withdrawn, terminated, or out of market. To know more about this property and what happened to that, or to see other available options, please feel free to contact us by using the message box on right side. Show More

Details

  • Constructed Date: 2004
  • Property Type: Single Family
  • Type: House
  • Construction Material: Log, Wood frame
  • Community: Nakusp Rural

Ammenities + Nearby

  • Recreation Nearby
  • Recreation
  • Recreation Nearby
  • Recreation

Features

  • Private setting
  • Rural Setting
  • Mountain view
  • Lake view
  • Dryer
  • Microwave
  • Refrigerator
  • Washer
  • Dishwasher
  • Stove
  • Heat Pump
  • In Floor Heating
  • Stove
  • Electric baseboard units
  • Heat Pump

Rooms Details For 4210 MOLE ROAD

Type Level Dimension
Bedroom Above 12'8 x 12
Bedroom Lower level 10'10 x 11'8
Full bathroom Lower level Measurements not available
Family room Lower level 25'10 x 21
Laundry room Lower level 6'6 x 6'4
Other Lower level 4 x 5'10
Kitchen Main level 10'3 x 10'6
Dining room Main level 13'6 x 21
Living room Main level 11'9 x 21
Bedroom Main level 10 x 12
Full bathroom Main level Measurements not available
Foyer Main level 5'6 x 6'8

Location



This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Kootenay 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®)