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` = '4' and `BedroomsTotal` = '1' and ListingID!=27740890 having distance <= 11 order by distance limit 3
- ©MLS R2950661
- Area 1413 sq ft
- Bedrooms 4
- Bathrooms 1
- Parkings 2
Description
Updated single-family home on a LARGE 11,762 sq/ft LOT in the beautiful community of Aldergrove. This cozy rancher with basement is zoned as Residential Zone R-2 (with an Active rezone application to Community Care Facility Zone P-2R to facilitate a group children's daycare), and features a beautifully renovated kitchen, updated flooring, fresh paint, a functional layout, and an incredible backyard. Convenient location - close to schools, restaurants, shops, transit, recreation centre, Otter Co-op Outdoor Water Park and Abbotsford Airport. Easy access to Hwy 1 and the US border. Excellent investment property. (id:48970) Show More
Details
- Age: 74 Years
- Property Type: Single Family
- Type: House
- Architectural Style: Ranch
Features
- Washer
- Dryer
- Refrigerator
- Stove
- Dishwasher
- 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
