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` = '2' and `BedroomsTotal` = '3' and ListingID!=26900374 having distance <= 11 order by distance limit 3
- ©MLS 10313928
- Area 1122 sq ft
- Bedrooms 2
- Bathrooms 3
- Parkings 6
Description
One of Parker Cove's best values! Oversized tandem garage is perfect for the recreational owner who needs tons of space for toys or for the owner who needs both covered parking and a workshop. The space won't disappoint. Upstairs you'll find an open concept great room with bright windows facing the lake. Sip your morning coffee on the covered deck and enjoy the view. Two bedrooms, one with ensuite, are found at the other end of the house. Additionally there's a main bath and separate laundry room. Fresh neutral paint, quality construction materials, tons of storage & parking space for cars and RV, a fenced yard with garden space AND location just one row off the beach make this a fantastic property to make your home. What makes it even better? A registered lease that goes to 2056 at only $378.13/month...that's what!! Don't skip past this property...its value placement in the Parker Cove community is spectacular. Call today!! (id:48970) Show More
Details
- Constructed Date: 2015
- Property Type: Single Family
- Type: House
- Access Type: Easy access
- Neighbourhood: Okanagan North
- Maintenance Fee: 75.00/Monthly
Ammenities + Nearby
- Park
- Recreation
- Park
- Recreation
Features
- Level lot
- Rent With Restrictions
- Lake view
- Mountain view
- View (panoramic)
- Refrigerator
- Dishwasher
- Dryer
- Range - Electric
- Washer
- Window air conditioner
- Baseboard heaters
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