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` = '6' and `BedroomsTotal` = '4' and ListingID!=27462609 having distance <= 11 order by distance limit 3
- ©MLS R2929503
- Area 3016 sq ft
- Bedrooms 6
- Bathrooms 4
- Parkings 4
Description
This lovely residence is situated in the highly sought-after Auguston Community, making it an ideal choice for families. The house boasts an abundance of fantastic living areas, including four bedrooms on the upper level and an additional two in the Basement. On the main floor, you'll find a generously sized open concept plan, with a well-appointed kitchen that offers ample cabinet space and a large island. The kitchen seamlessly flows into the family room, creating a wonderful space for entertaining friends and loved ones. The large south-facing windows flood the area with natural light, creating a warm and inviting atmosphere. The home also features a separate living room and a dining room, providing the perfect setting for formal gatherings. Schedule a private viewing today. (id:48970) Show More
Details
- Age: 23 Years
- Property Type: Single Family
- Type: House
- Architectural Style: 2 Level
Features
- 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
