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` = '2' and `BedroomsTotal` = '1' and ListingID!=27731138 having distance <= 11 order by distance limit 3
- ©MLS R2950037
- Area 1237 sq ft
- Bedrooms 2
- Bathrooms 1
- Parkings 2
Description
Welcome to Langley Grove Estates, a serene community nestled in a tranquil park setting surrounded by mature trees and beautifully gardens. This charming home offers a peaceful retreat while being conveniently located near all essential amenities. With ample parking and no age restrictions, this property is perfect for anyone looking for a comfortable and flexible living space. Pet lovers will appreciate the pet-friendly policy, allowing up to two small pets (up to 7 inches). Enjoy the best of both worlds-relaxation and convenience-in this lovely, welcoming community. (id:48970) Show More
Details
- Age: 53 Years
- Property Type: Single Family
- Type: Manufactured Home
- Architectural Style: Other
Ammenities + Nearby
- Clubhouse
- Recreation Centre
- Whirlpool
Features
- Washer
- Dryer
- Refrigerator
- Stove
- Dishwasher
- Storage Shed
- Baseboard heaters
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
