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!=27779920 having distance <= 11 order by distance limit 3
- ©MLS R2953937
- Area 914 sq ft
- Bedrooms 2
- Bathrooms 2
- Parkings 1
Description
Charming 2 Bed, 2 Bath Unit at Watermark! Welcome to this renovated & extremely well maintained 914 sqft corner unit, a perfect blend of style, comfort, & convenience. Well designed & meticulously updated with new flooring, stainless steel appliances, new blinds, & fresh paint, giving it a contemporary, move-in-ready feel. The primary bedroom offers a walk-in closet & a ensuite featuring a double vanity sink. With the bedrooms strategically positioned on opposite sides of the unit, you'll enjoy maximum privacy. Ideally beside the staircase and elevators providing easy access. Enjoy the prime location with many amenities at your doorstep- shops, cafes, & restaurants. Close to public transportation, White Rock, & the US border. Don't miss the chance to own this quality unit! (id:48970) Show More
Details
- Age: 16 Years
- Property Type: Single Family
- Type: Apartment
- Maintenance Fee: 497.00/Monthly
Ammenities + Nearby
- Exercise Centre
- Laundry - In Suite
- Restaurant
Features
- Pets Allowed With Restrictions
- Washer
- Dryer
- Refrigerator
- Stove
- Dishwasher
- Smoke Detectors
- 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
