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` = '3' and ListingID!=27358099 having distance <= 11 order by distance limit 3
- ©MLS 10323179
- Area 1691 sq ft
- Bedrooms 3
- Bathrooms 3
- Parkings 4
Description
OPEN HOUSE THIS SUN 11AM-1PM. BRAND NEW duplex home built by Carriage Signature Homes available for immediate occupancy in the vibrant new community of Morningview on Middleton Mountain in Coldstream/Vernon. Fabulous 3 bedroom, 3 bathroom home, with approx. 2,426 sq.ft. with 1,691 sq.ft. of beautifully crafted living space, an ADDITIONAL UNDEVELOPED BASEMENT of 735 sq.ft. and double car garage. Okanagan inspired Lakeside interior colour palette mixes soft whites with natural wood tones. This home’s luxury finishings and functional design features an open concept main floor with 9’ ceilings, SS kitchen appliances, Quartz island, walk-through pantry and mudroom and built-in bench with cubbies. Second floor has 3 bedrooms, large laundry room and walk-in closets in all bedrooms. Ensuite has double sinks, spacious vanity, and shower with glass door. This home is fully landscaped and includes appliances, a fence, and covered rear deck with privacy screen. UNDEVELOPED walkout basement offers buyers the ability to customize this space to their needs. Comes with new home warranty insurance. Conveniently located in Coldstream, an outdoor enthusiasts dream rich in hiking and bike trails, a district known for its great schools, only 7 mins from Kalamalka Lake and Kal Beach, and 30 mins to the airport and SilverStar Ski Resort. GST NOT INCLUDED. A PLEASURE TO SHOW. (id:48970) Show More
Details
- Constructed Date: 2024
- Property Type: Single Family
- Type: Duplex
- Architectural Style: Other
- Neighbourhood: Mun of Coldstream
Features
- Central island
- Balcony
- One Balcony
- Pets Allowed
- Mountain view
- Valley view
- View (panoramic)
- Range
- Refrigerator
- Dishwasher
- Hood Fan
- Washer & Dryer
- Central air conditioning
- Controlled entry
- Smoke Detector Only
- Forced air
Rooms Details For 353 Arrowleaf Rise
| Type | Level | Dimension |
|---|---|---|
| Loft | Second level | 10'7'' x 6'4'' |
| Bedroom | Second level | 10'2'' x 10'4'' |
| Bedroom | Second level | 10'1'' x 10'4'' |
| 3pc Bathroom | Second level | Measurements not available |
| Laundry room | Second level | 8'7'' x 6'1'' |
| Other | Second level | 8'7'' x 5'8'' |
| 4pc Ensuite bath | Second level | Measurements not available |
| Primary Bedroom | Second level | 11'8'' x 12'7'' |
| Other | Main level | 17'6'' x 20'0'' |
| Mud room | Main level | 9'11'' x 3'6'' |
| 2pc Bathroom | Main level | Measurements not available |
| Dining nook | Main level | 8'5'' x 12'1'' |
| Living room | Main level | 12'4'' x 12'7'' |
| Kitchen | Main level | 12'9'' x 9'6'' |
| Foyer | Main level | 7'6'' x 8'9'' |
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
