Back to Saved Search
Listing 12 out of 1,006
$1,750,000 For Sale

54038 Avenida Bermudas
La Quinta, CA 92253

5 beds, 4 full, 2 partial baths | Single Family Home
7,696 sq ft; lot: 0.75 acres - MLS# 218022102
Property Photo
1/43

Description

One-Of-A-Kind Property! Artistically UNIQUE, this 7, 696 sq. ft. estate elegantly greets the iconic Santa Rosas high in the La Quinta Cove on 32, 670 sq. ft. Interior features include 5 BD + (including casita) + office, 4 full BA & 2 half BA, spacious gourmet kitchen w/ casual dining area, library, spectacular wine cellar, full custom bar, detached casita w/ kitchenette & 5-car garage. A one-of-a-kind stained-glass masterpiece, granite countertops & expressive imported flooring & finishes adorn this sprawling hideaway. Impressive features include opulent sliding glass walls, 2-story ceilings, captivating wood burning fireplace & expansive entertaining areas. And, a paid-for solar energy system w/ 95 panels. Your outdoor sanctuary offers a sparkling infinity pool, spa, garden, spectacular foliage & artistic pieces thru-out. This distinctive home offers incredible architecture and design. MUST SEE to appreciate all this estate has to offer! Inquire about short-term rental income potential.

Features

  • Property Type: Single Family Home
  • Sub Type: Single Family Detach
  • Listing Status: Active
  • County/Area: Riverside County
  • Zip Code: 92253
  • Year Built: 2005
  • Sq.Ft.: 7,696 sq ft
  • Bedrooms: 5
  • Full Baths: 4
  • Half Baths: 2
  • Garage: 5-Car Attached
  • # of Parking Spaces: 5
  • Fireplace: Yes Electric, Wood Metal, Other Dining Room, Kitchen, Living Room 2
  • Lot Size: 0.75 acres
  • Baths: 5 baths
  • Pool or Spa: In Ground Pool-Heated Private Pool
  • View: Desert View, Mountain View, Panoramic View, Pond View, Pool View Yes
  • Appliances: Dishwasher, Elec Dryer Hookup, Garbage Disposal, Refrigerator
  • Bathroom Features: Double Vanity(s), Shower Over Tub, Shower Stall, Tub - Soaking, Tub 2 Person, Tub With Jets
  • Bedroom Features: Master Retreat, Walk In Closet
  • Built-in BBQ: Propane
  • Casita/Guesthouse: Detached
  • Cook Top: Electric
  • Cooling Type: Air Conditioning, Zoned A/C
  • Doors: Double Door Entry, French Doors, Sliding Glass Dr(s)
  • Eating Areas: Breakfast Room, Dining Area, Eat In Kitchen
  • Entry Location: Foyer
  • Ext Construction: Stone, Stucco
  • Fencing: Stucco Wall, Wrought Iron
  • Flooring: Hardwood, Tile
  • Foundation: Concrete Slab
  • Heating Fuel: Electric, Solar
  • Heating Type: Fireplace, Forced Air, Zoned
  • Interior Features: Bar-Wet, Built-Ins, Cathedral/Vaulted, High Ceilings, Recessed Lighting, Storage Space, Track Lighting
  • Kitchen Features: Counter-Tile, Gourmet Kitchen, Island, Pantry
  • Land: Fee
  • Laundry Locations: Individual Room, Inside
  • Lot Description: 2 - 4 Lots, Automatic Gate, Back Yard, Curbs, Fenced, Front Yard, Landscaped, Lawn, Lot Shape-Irregular, Street Paved, Utilitiesunderground, Yard
  • Lot Location: Corner Lot
  • Lot Measurement: SqFt
  • Lot Size Source: (Assessor)
  • Lot Square Footage: 32670.00
  • Microwave Oven: Built-in
  • Other Prop Features: Custom Built, Premium Lot, Solar System Owned, Other
  • Other Structures: Accessory Bldgs, Gazebo
  • Oven: Electric
  • Parking: Circular Driveway, Direct Garage Access, Driveway, On Street, Parking for Guests
  • Patio Features: Awning, Brick, Concrete Slab, Covered
  • Property Orientation: FrontDoor FacesSouth, Leisure Faces East
  • Range Hood: Yes
  • Roofing: Tile
  • Rooms: Dining Room, Entry, Guest Room, Library, Living Room, Loft, Office, Utility Room, Walk In Pantry, Wine Cellar
  • Security/Safety: Automatic Gate, Card/Code Access, Fire & Smoke Det Sys
  • Sewer: In, Connected & Paid
  • Spa/Hot Tub: Yes
  • Spa/Hot Tub Const.: In Ground
  • Spa/Hot Tub Desc.: Spa-Heated
  • Special Conditions Details: Standard Sale
  • Sprinklers: Yes
  • Sprinklers Desc.: Drip System, Sprinkler System, Sprinkler Timer
  • Square Footage Source: Assessor
  • Warmer Oven Drawer: Yes
  • Water: Water District
  • Water District: Coachella Valley Water Dist.
  • Water Htr Features: Electric
  • Window Treatments: Custom Covering, Double Pane
Courtesy of Exp Realty Of California, Inc., Brad Schmett Real Estate Group

VIEW DESERT LISTINGS... FIRST!

This Competitive is a Market - DON'T MISS A NEW LISTING AGAIN! Register with us to access advanced, custom search tools to help you stay one step ahead of other buyers. NO WEBSITE OFFERS MORE IN THE DESERT! 

Save a search with your parameters (# of bedrooms, price range, Subdivision etc.) and our Advanced Search Technologies will email alerts to you with new listings matching your criteria, so you can see the latest homes before your competition does!

Register Now
Already registered? Login

-- It's 100% Free To Register (Cancel Anytime)**Your Information Will Never Be Shared or Disclosed** --

Desert Relocation Guide

Learn more about the Coachella Valley. This comprehensive 80 page guide is a helpful resource to learn more about the Palm Springs area. Discover the diversity of various Coachella Valley communities, demographics, statistics, activities, jobs and much more. Plus, we are available to answer any questions or lookup additional community information for you.
Link to More Information

Subscribe to Our Newsletter

Desert Luxury Living - Desert Dreams Come True Real Estate Magazine - Receive the latest issue of our e-newsletter, which contains Real Estate Trends, Sales information, Lifestyle of the Southern California Desert, helpful real estate articles, tips and more. 



* fields are required

Desert Dreams Come True Is Your Source for Local News and Real Estate 

Desert Dreams Come True is all about living in our local communities: Palm Desert, La Quinta, Indio, Rancho Mirage, Indian Wells, Bermuda Dunes and Palm Springs. We'll tell you about popular events, attractions and activities, and some off-the-beaten-path suggestions as well.

This site offers the most complete and intuitive real estate search tools available. The data you want are here, accurate and updated. Use our powerful "suggestive" search bar to refine your search. Browse sold properties. Whether you're looking to buy, sell, or just research market activity, you'll quickly see the power that this site puts in your hands.

Denise DeCaro & Kim Jones | 760-425-4403 | Contact Us
47060 Washington Street #5101 - La Quinta, CA 92253
Copyright © 2018, All Rights Reserved

Browse Communities:Retirement Communities, Golf Communities, Condo Communities, Luxury Home Communities

Real Estate Websites by iHOUSEweb iconiHOUSEweb | Admin Menu