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!=27717709 having distance <= 11 order by distance limit 3
- ©MLS R2949055
- Area 668 sq ft
- Bedrooms 1
- Bathrooms 1
- Parkings 2
Description
Rare to find ground floor corner unit with 2 parking spots and (bonus) 2 storage lockers. Desirable location with a patio ready for your BBQ. Open kitchen with granite countertops, deluxe gas oven and stainless refrigerator. Pets and rentals allowed. Walking distance to the future Skytrain station, public transit, shopping, recreation and restaurants. (id:48970) Show More
Details
- Age: 9 Years
- Property Type: Single Family
- Type: Apartment
- Architectural Style: Other
- Maintenance Fee: 323.27/Monthly
Ammenities + Nearby
- Laundry - In Suite
- Recreation Centre
- Storage - Locker
Features
- Pets Allowed With Restrictions
- Rentals Allowed
- Washer
- Dryer
- Refrigerator
- Stove
- Dishwasher
- 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
