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!=27573824 having distance <= 11 order by distance limit 3
- ©MLS R2938332
- Area 1332 sq ft
- Bedrooms 2
- Bathrooms 2
- Parkings 1
Description
OCEAN VIEW 2 bedroom/2 bath condo w/huge, wrap around patio perfect for gardening & entertaining. Spacious open plan living space w/cozy glass fireplace extends to your sunny, private patio. Bright & airy south facing living room & dining room features 180 degree southern exposure. Kitchen opens to expansive family room. Primary bedroom w/ensuite bathroom & large glass shower, walk-in closet & covered patio. 2nd bedroom w/murphy bed. 2nd bathroom w/shower. Radiant h/w in-floor heat. Laminate & tile floors. Stacking in suite w/d. Some photos virtually staged. Well maintained, boutique building w/2 units per floor. Common area room w/pool table/fitness area. Common workshop/garden shed. 1 large parking stall, huge storage locker included. Perfect location, ideal for 55+. Walk to 5 Corners, shopping, bus & beach. OPEN HOUSE Saturday, Nov 16th 1-4pm (id:48970) Show More
Details
- Age: 34 Years
- Property Type: Single Family
- Type: Apartment
- Architectural Style: Other
- Maintenance Fee: 555.84/Monthly
Ammenities + Nearby
- Laundry - In Suite
- Storage - Locker
Features
- No Smoking Home
- Age Restrictions
- Pets not Allowed
- Rent With Restrictions
- Workshop
- Ocean view
- View of water
- Washer
- Dryer
- Refrigerator
- Stove
- Dishwasher
- Garage door opener
- Microwave
- Alarm System - Roughed In
- Unknown
- Smoke Detectors
- Hot Water
- Radiant heat
- 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