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` = '5' and `BedroomsTotal` = '3' and ListingID!=27720121 having distance <= 11 order by distance limit 3
- ©MLS R2949182
- Area 2496 sq ft
- Bedrooms 5
- Bathrooms 3
- Parkings 5
Description
This beautifully renovated home is ideally located near Sunshine Hills Elementary (French Immersion), Seaquam Secondary (IB Program), and Water Shed Park. It features good size 5 bedrooms, updated floors, finishes, lighting, windows, and a modern kitchen with high-end cabinetry and granite countertops. The open living space boasts vaulted ceilings, a functional layout, and a 4 ft crawl space for storage. Enjoy outdoor entertaining with a wrap-around 443 sq ft deck and an expansive 301 sq ft covered patio. Perfect for year-round BBQs and gatherings! (id:48970) Show More
Details
- Age: 63 Years
- Property Type: Single Family
- Type: House
- Architectural Style: 3 Level
Features
- Washer
- Dryer
- Refrigerator
- Stove
- Dishwasher
- Microwave
- Forced air
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
