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` = '4' and `BedroomsTotal` = '3' and ListingID!=27743657 having distance <= 11 order by distance limit 3
- ©MLS 10330483
- Area 2475 sq ft
- Bedrooms 4
- Bathrooms 3
- Parkings 4
Description
Discover the ultimate family home in the picturesque Okanagan! This exceptional home features a seamless open-concept design on the main floor with brand new vinyl flooring throughout, complete with vaulted ceilings and expansive windows that frame stunning mountain views. The kitchen is equipped with ample storage and sleek stainless steel appliances. Enjoy dining al fresco on the deck adjacent to the kitchen, or unwind on the front deck. The main level also includes a generously-sized primary bedroom with a walk-in closet and ensuite bathroom, plus two additional spacious bedrooms and another full bathroom. The lower level offers versatile options with a fourth bedroom (or office) for visitors, a half bath that can be easily converted back to full bath with a shower or tub, and a separate entrance, ideal for converting into a suite or utilizing as a large rec room or entertainment space. Step outside to a low-maintenance yard featuring an in-ground pool and synthetic lawn, perfect for children and pets with its secure fencing. Embrace the Okanagan lifestyle with this ready-to-enjoy home! (id:48970) Show More
Details
- Constructed Date: 2010
- Property Type: Single Family
- Type: House
- Neighbourhood: East Hill
- Pool Type: Inground pool, Outdoor pool, Pool
Ammenities + Nearby
- Golf Nearby
- Schools
- Shopping
- Golf Nearby
- Schools
- Shopping
Features
- Level lot
- Corner Site
- Two Balconies
- Family Oriented
- Mountain view
- Refrigerator
- Dishwasher
- Dryer
- Range - Electric
- Washer
- Central air conditioning
- Forced air
- See remarks
Rooms Details For 1501 15th Avenue
Type | Level | Dimension |
---|---|---|
2pc Bathroom | Basement | 8' x 5' |
Laundry room | Basement | 8'10'' x 5' |
Den | Basement | 12'2'' x 14'9'' |
Recreation room | Basement | 27' x 18'9'' |
Bedroom | Basement | 11'6'' x 10'4'' |
4pc Ensuite bath | Main level | 6' x 8'4'' |
Full bathroom | Main level | 8'8'' x 5'0'' |
Bedroom | Main level | 12'2'' x 13'4'' |
Bedroom | Main level | 12'3'' x 9'2'' |
Primary Bedroom | Main level | 15'1'' x 19'7'' |
Dining room | Main level | 12'6'' x 11'6'' |
Kitchen | Main level | 12'6'' x 12'6'' |
Living room | Main level | 17'8'' x 15'1'' |
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