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!=27215070 having distance <= 11 order by distance limit 3
- ©MLS R2907434
- Area 991 sq ft
- Bedrooms 2
- Bathrooms 2
- Parkings 1
Description
Welcome to ICON! Another masterpiece by the renowned developer: Whitetail Homes. This charming special 2 bed 2 bath unit is the largest available in the building with ~1000 sqft of inviting layout. Enjoy yearlong sunlight with south-facing windows and patio. Best location in Langley with all amenities such as Willowbrook Mall, major grocery stores, and restaurants within walking distance. Furthermore seamless access to highway 1 via 200 makes your commute a breeze. Most importantly, having skytrain at your doorstep makes your trip downtown effortless. The building offers impressive amenities including, but not limited to, a gym, expansive rooftop patio, storage, a garden, and a yoga studio. 2-5-10 WARRANTY. Whether you are looking for your next home or the perfect investment, look no further. This modern architectural gem has it all. (id:48970) Show More
Details
- Constructed Date: 2024
- Property Type: Single Family
- Type: Apartment
- Architectural Style: Other
- Maintenance Fee: 486.84/Monthly
Ammenities + Nearby
- Exercise Centre
- Laundry - In Suite
- Storage - Locker
Features
- Pets Allowed With Restrictions
- Rentals Allowed
- 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