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 ListingID!=27038736 having distance <= 11 order by distance limit 3
- ©MLS 10316949
Description
Very special property. 4 unit lodge with larger owners suite. Each lodge suite is one bedroom with queen bed and fold out sofa . Small kitchen area with fridge and microwave. Full internet and TV. Full shower, Laundry and extra fridge/storage space for longer term rentals. Each room is ultra insulated and sound proofed. There is a large BBQ and games area for the guests at the east end of the building . Snowmobile and ATV right from the parking lot into the Pasayton Valley. The entire building is wired to WiFi - you can control all electronic door locks, power, hot water tanks ect, cameras, lights from your phone . There is propane powered Generac back up power system. Great water from the well onsite. Owners suite is 1 bedroom with a full kitchen and bath and separate laundry and a good sized living room. Owners space at west end of building is private and has a firepit , bbq area, 2 sea cans for storage and a wood storage area. Building has metal roof and finished with Hardy board. (id:48970) Show More
Details
- Constructed Date: 2011
- Property Type: Hospitality
- Type: Other
- Neighbourhood: Princeton Rural
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