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` = '8' and ListingID!=26429202 having distance <= 11 order by distance limit 3
- ©MLS R2842836
- Area 8526 sq ft
- Bedrooms 5
- Bathrooms 8
- Parkings 7
Description
Upon entering the custom Tree of Life gate at Sunset Ridge you'll notice how the mature landscaping provides privacy. Raymond Bonter designed and Nathan Construction built this Georgian estate on 1.27 acres, with pool, hot-tub and an EXCLUSIVE PRIVATE DOCK on the river. Finishings include Travertine tile, radiant in floor heating, extensive millwork and oversized Euroline windows framing the views of the pool, gardens, River, OCEAN, city lights and SUNSETS! The gourmet kitchen is outfitted with an AGA range, 2 islands, gas cooktop, Sub-zero fridge-freezer, built in steam and microwave ovens, and lots of storage. Your new master suite boasts 2 w/i closets, dual sinks, 2 person jetted tub, and steam shower. All bedrooms are ensuited. Below is a perfect in-law, guest or nanny suite. (id:48970) Show More
Details
- Age: 24 Years
- Property Type: Single Family
- Type: House
- Architectural Style: 2 Level
Ammenities + Nearby
- Storage - Locker
- Whirlpool
Features
- City view
- Mountain view
- View of water
- Washer
- Dryer
- Refrigerator
- Stove
- Dishwasher
- Hot Tub
- Microwave
- Range
- Central Vacuum
- 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