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

345 Arrowleaf Rise For Sale

coldstream, British Columbia V1B2H8
$ 720,000
$ 436 / Sq. Ft.
  • ©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

©️ 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®)