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` = '1' and `BedroomsTotal` = '1' and ListingID!=27574836 having distance <= 11 order by distance limit 3
- ©MLS R2938472
- Area 463 sq ft
- Bedrooms 1
- Bathrooms 1
- Parkings 3
Description
Welcome to your dream mobile home! The stunning property features modern stainless steel appliances, perfect for any home chef. Enjoy cozy by the gas fireplace and appreciate the spacious feel of high ceilings throughout. Step outside to a detached shop, ideal for hobbies or extra, Located in a vibrant gated community , you'll have access to fantastic amenities including a refreshing pool, relaxing hot tub, gym, well-stocked library, games room convenient laundry facility, and a clubhouse for social gatherings, an exclusive fenced in dog park for members of the community. Plus, take advantage of the boat launch for all your water adventures. Don't miss out on this incredible opportunity to live in comfort and style! (id:48970) Show More
Details
- Age: 17 Years
- Property Type: Single Family
- Type: Manufactured Home/Mobile
- Road: Paved road
- Architectural Style: Other
- Maintenance Fee: 193.00/Monthly
Ammenities + Nearby
- Air Conditioning
- Clubhouse
- Exercise Centre
- Laundry - In Suite
- Whirlpool
Features
- Pets Allowed With Restrictions
- Rentals Allowed
- Mountain view
- Washer
- Dryer
- Microwave
- Refrigerator
- Storage Shed
- Stove
- Smoke Detectors
- Forced air
Location
This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Fraser Valley Real Estate Board
