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` = '2' and ListingID!=27183229 having distance <= 11 order by distance limit 3
- ©MLS R2906847
- Area 980 sq ft
- Bedrooms 2
- Bathrooms 2
- Parkings 1
Description
Own a modern architectural gem by Langley's top developer. This 2-bedroom, 2-bathroom home features a spacious layout with 9 ft ceilings, an open-concept design, a kitchen with a U shaped island, quartz countertops, stainless steel appliances, and a balcony off the living room. Ideally located near the upcoming Langley/Surrey Skytrain station, rapid bus line, Willowbrook Mall, Downtown Langley, restaurants, cafes, parks, and schools. Amenities include a gym, yoga studio, rooftop terrace, lounge, 1 parking space, 1 storage unit, and laminate flooring throughout. With east access to Highway #1, this prime location offers unmatched convenience and connectivity. Secure your future home today! (id:48970) Show More
Details
- Constructed Date: 2024
- Property Type: Single Family
- Type: Apartment
- Architectural Style: Other
- Maintenance Fee: 505.80/Monthly
Ammenities + Nearby
- Laundry - In Suite
- Storage - Locker
Features
- Pets Allowed
- Pets Allowed With Restrictions
- Rentals Allowed
- City view
- 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