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!=26836419 having distance <= 11 order by distance limit 3
- ©MLS 10312831
- Area 1421 sq ft
- Bedrooms 3
- Bathrooms 2
- Parkings 3
Description
Welcome to 459 Ibis Avenue in Parker Cove. An attractive 3 bedroom 2 bathroom home tucked away in the trees and overlooking dedicated greenspace. The main floor has an open plan main living area with a mix of slate tile & hickory hardwood flooring and vaulted ceilings. The kitchen offers a generous amount of cabinets and counter space. The main floor also has a bedroom, a full 4 piece bath, the laundry and stairs down to a full 4 foot crawlspace which provides tons of storage. On the upper level is a spacious loft with two skylights, two bedrooms and a 3 piece bath. Other features include an electric forced air furnace, central air conditioning, attached single car garage, u/g sprinkler system, covered front patio and low maintenance landscaping. This home is just a few minutes walk away from the private beach. The lease is registered until January 2043 and the current annual lease payment is $3970.49. (id:48970) Show More
Details
- Constructed Date: 2009
- Property Type: Single Family
- Type: House
- Access Type: Easy access
- Architectural Style: Other
- Neighbourhood: Okanagan North
Ammenities + Nearby
- Park
- Recreation
- Park
- Recreation
Features
- Rent With Restrictions
- Mountain view
- View (panoramic)
- Refrigerator
- Dishwasher
- Dryer
- Range - Electric
- Microwave
- Washer
- Central air conditioning
- Forced air
Rooms Details For 459 Ibis Avenue
Type | Level | Dimension |
---|---|---|
Loft | Second level | 18'0'' x 9'6'' |
3pc Bathroom | Second level | 5'0'' x 8'0'' |
Bedroom | Second level | 13'3'' x 8'8'' |
Primary Bedroom | Second level | 12'2'' x 12'2'' |
Other | Main level | 24'0'' x 9'7'' |
4pc Bathroom | Main level | 8'0'' x 6'0'' |
Bedroom | Main level | 10'3'' x 12'3'' |
Living room | Main level | 14'6'' x 15'3'' |
Dining room | Main level | 11'0'' x 11'0'' |
Kitchen | Main level | 10'0'' x 10'0'' |
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