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!=27254668 having distance <= 11 order by distance limit 3
- ©MLS 10321237
- Area 1570 sq ft
- Bedrooms 3
- Bathrooms 2
- Parkings 5
Description
Welcome to your dream sanctuary nestled in the heart of Desert Cove—a prestigious 40+ community where luxury and tranquility harmonize. This exquisitely maintained 3-bedroom, 2-bathroom haven stands as a testament to elegance and comfort. Step inside and be greeted by a spacious open-concept layout that flows effortlessly, bathed in natural light that dances through every corner. The heart of this home is a gourmet kitchen adorned with top-of-the-line appliances, sleek countertops, and ample cabinetry—a true culinary delight. The inviting primary suite is a retreat unto itself, featuring a generous walk-in closet and a spa-like ensuite bathroom, perfect for unwinding after a day of leisure. The charm continues outside where a covered patio offers stunning golf course views, setting the stage for serene mornings and enchanting evenings. The meticulously landscaped yard, bursting with vibrant blooms and lush trees, creates a private oasis for relaxation and entertainment. This home is brimming with thoughtful details, including an expansive garage designed to accommodate all your toys and hobbies, and a cozy wine room—ideal for intimate gatherings and savoring your favorite vintages. Desert Cove living extends beyond your doorstep with access to the community's Rec Hall amenities. Dive into the saltwater pool, soak in the hot tub, or engage in a variety of recreational activities designed to enrich your lifestyle. (id:48970) Show More
Details
- Constructed Date: 2001
- Property Type: Single Family
- Type: House
- Community: Desert Cove
- Neighbourhood: Swan Lake West
- Maintenance Fee: 345.97/Monthly
Features
- Central island
- Seniors Oriented
- Mountain view
- View (panoramic)
- Refrigerator
- Dishwasher
- Range - Gas
- Microwave
- Washer & Dryer
- Water softener
- Central air conditioning
- Forced air
- See remarks
Rooms Details For 648 6TH Avenue
Type | Level | Dimension |
---|---|---|
Wine Cellar | Basement | 10'7'' x 10'10'' |
Storage | Main level | 5'10'' x 9'0'' |
Laundry room | Main level | 10'1'' x 8'0'' |
4pc Bathroom | Main level | 5'5'' x 9'0'' |
Bedroom | Main level | 9'7'' x 9'5'' |
Bedroom | Main level | 9'11'' x 10'10'' |
Other | Main level | 5'5'' x 5'11'' |
3pc Ensuite bath | Main level | 8'3'' x 7'8'' |
Primary Bedroom | Main level | 11'9'' x 17'9'' |
Dining room | Main level | 10'8'' x 11'10'' |
Kitchen | Main level | 12'4'' x 11'10'' |
Living room | Main level | 13'3'' x 18'7'' |
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