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

309 Arrowleaf Rise For Sale

coldstream, British Columbia V1B1W2
$ 819,000
$ 397 / Sq. Ft.
  • ©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

©️ Hybrid Real Estate Plugin For CREA DDF

The trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. The trademark DDF® is owned by The Canadian Real Estate Association (CREA) and identifies CREA's Data Distribution Facility (DDF®)