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!=26886487 having distance <= 11 order by distance limit 3
- ©MLS 10313818
- Area 1500 sq ft
- Bedrooms 3
- Bathrooms 2
Description
This represents an excellent beginning in the countryside. Situated on 104 acres with boundaries along both the Old and New Alaska Highway. The property features a blend of cleared and cultivated areas, along with ample bush. The 1,500 sq ft three-bedroom modular residence offers a spacious kitchen/eating area that seamlessly flows into the living room complimented by two bathrooms and laundry. The foundation is steel I-Beams spaced at 6' centres. With everything in place, you can devote your attention to enjoying the great outdoors. (id:48970) Show More
Details
- Constructed Date: 1978
- Property Type: Single Family
- Type: Manufactured Home
- Architectural Style: Ranch
- Neighbourhood: Dawson Creek Rural
Features
- Private setting
- Rural Setting
- Refrigerator
- Dryer
- Range - Electric
- Washer
- Forced air
- See remarks
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