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!=27495064 having distance <= 11 order by distance limit 3
- ©MLS R2931618
- Area 1016 sq ft
- Bedrooms 2
- Bathrooms 2
- Parkings 2
Description
From Yaletown to South Surrey, this stunning LOFT offers 12' high ceilings and over 1,000 sq.ft. of open-concept living! Brimming with character, it features exposed brick, barnwood accents, industrial lighting, European plank flooring, custom millwork, and two office workstations. This is more than just a 2 bed, 2 bath, top-floor corner unit with 2 parking spots and a locker-it's a lifestyle! The signature Club House has it all: pool, hot tub, fire pit, BBQ area, theatre, gym, and more. Plus, easy access to Hwy 99, schools, shopping, golf, and trails. Pet lovers rejoice-bring up to 2 dogs or cats, no size restrictions! (id:48970) Show More
Details
- Age: 8 Years
- Property Type: Single Family
- Type: Apartment
- Architectural Style: Penthouse
- Maintenance Fee: 450.00/Monthly
Ammenities + Nearby
- Laundry - In Suite
- Storage - Locker
Features
- No Smoking Home
- Pets Allowed With Restrictions
- Rent 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
