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!=27706728 having distance <= 11 order by distance limit 3
- ©MLS R2948627
- Area 582 sq ft
- Bedrooms 1
- Bathrooms 1
- Parkings 1
Description
Welcome Home to your own Varsity home in the heart of Langley City. A beautiful bright open concept corner unit with tall windows complimented with stainless steel appliances, granite countertops, soft close cabinets and elevated ground floor patio. Just steps away from everything that Langley has to offer including the mall, shops, restaurants and schools. Future potential for Sky Train Station only a short walk away. Pets are allowed and 1 locker and 1 under ground parking. (id:48970) Show More
Details
- Age: 12 Years
- Property Type: Single Family
- Type: Apartment
- Architectural Style: Other
- Maintenance Fee: 346.06/Monthly
Ammenities + Nearby
- Laundry - In Suite
- Recreation Centre
- Storage - Locker
Features
- No Smoking Home
- Pets Allowed With Restrictions
- Baseboard heaters
- Storage
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
