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` = '3' and `BedroomsTotal` = '4' and ListingID!=27297147 having distance <= 11 order by distance limit 3
- ©MLS 10322030
- Area 2064 sq ft
- Bedrooms 3
- Bathrooms 4
- Parkings 4
Description
Welcome to your ideal family home in Morningview On Middleton! This three-level duplex offers spacious living with 3 bedrooms and 3.5 bathrooms, including 2 primary bedrooms for ultimate comfort and convenience. Step outside through your walk-out basement and discover the expansive backyard, perfect for outdoor gatherings or simply enjoying the breathtaking valley views that stretch out before you. Imagine relaxing on your deck or patio as you soak in the beauty of the surrounding landscape. Convenience is key, with shopping, lakes, and a trail system all within close proximity. Whether you're stocking up on essentials, enjoying water activities at the nearby lakes, or exploring the great outdoors on the extensive trail network, there's something for everyone to enjoy. As an added incentive, Everton Homes is offering price reductions up to $40k for a limited time, conditions apply. (id:48970) Show More
Details
- Constructed Date: 2024
- Property Type: Single Family
- Type: Duplex
- Neighbourhood: Mun of Coldstream
Features
- Central island
- Balcony
- Pets Allowed
- Refrigerator
- Dishwasher
- Range - Gas
- Microwave
- Hood Fan
- Central air conditioning
- Forced air
- See remarks
Rooms Details For 309 Arrowleaf Rise
Type | Level | Dimension |
---|---|---|
4pc Bathroom | Second level | Measurements not available |
4pc Ensuite bath | Second level | Measurements not available |
Bedroom | Second level | 10'9'' x 10' |
Primary Bedroom | Second level | 12' x 13'6'' |
Bedroom | Lower level | 10' x 11'11'' |
4pc Bathroom | Lower level | Measurements not available |
Kitchen | Main level | 14' x 10' |
2pc Bathroom | Main level | Measurements not available |
Dining room | Main level | 10' x 12' |
Great room | Main level | 13' x 13' |
Location
This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Okanagan-Mainline Real Estate Board