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` = '2' and ListingID!=27470469 having distance <= 11 order by distance limit 3
- ©MLS 10325029
- Area 1653 sq ft
- Bedrooms 3
- Bathrooms 2
- Parkings 4
Description
This stunning 2025 build half-duplex showcases a contemporary design, offering 3 bedrooms and 2.5 bathrooms. The well-thought-out floor plan clearly defines spaces for entertaining and relaxation, with the main level dedicated to living and dining areas, while all bedrooms are conveniently situated upstairs. The primary suite features a luxurious 5-piece ensuite with dual sinks, a soaking tub, and a separate glass-enclosed shower, alongside a spacious walk-in closet. Designed with practicality in mind, the home offers ample storage, including multiple walk-in closets. Located in the scenic community of Middleton Mountain, this property offers easy access to nearly 30 acres of natural beauty and extensive trails at Middleton Mountain Park. Situated in Coldstream, known for its friendly community and excellent schools, the area is ideal for families. Just a short drive away, Vernon provides a vibrant blend of urban amenities and small-town charm. The region is a paradise for outdoor enthusiasts, with top-tier ski resorts, renowned wineries, and picturesque beaches. Crafted with precision and care, this home exemplifies the quality and attention to detail that Gibson Custom Homes is known for. Please note, the images displayed are artistic renderings for illustrative purposes only and may include features that are not standard in base models. Project specifications, finishes, and features are subject to change. (id:48970) Show More
Details
- Constructed Date: 2025
- Property Type: Single Family
- Type: Duplex
- Architectural Style: Contemporary, Split level entry
- Neighbourhood: Middleton Mountain Coldstream
Features
- Central island
- Balcony
- Pets Allowed
- Rentals Allowed
- Refrigerator
- Dishwasher
- Dryer
- Range - Gas
- Washer
- Central air conditioning
- Controlled entry
- Smoke Detector Only
- Forced air
Rooms Details For 345 Arrowleaf Rise
Type | Level | Dimension |
---|---|---|
Bedroom | Second level | 10'10'' x 11'1'' |
Bedroom | Second level | 9'9'' x 11'7'' |
Laundry room | Second level | 9'5'' x 6'5'' |
5pc Ensuite bath | Second level | 11'3'' x 10'1'' |
Primary Bedroom | Second level | 11'11'' x 14'2'' |
Storage | Basement | 19'4'' x 3'6'' |
Foyer | Main level | 15'3'' x 8'2'' |
2pc Bathroom | Main level | 7'9'' x 3'6'' |
Dining room | Main level | 12'4'' x 9'7'' |
Kitchen | Main level | 11'6'' x 9'0'' |
Living room | Main level | 13'11'' x 16'8'' |
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