54038 Avenida Bermudas, La Quinta, CA 92253 (MLS# 219062646)

54038 Avenida Bermudas, La Quinta, CA 92253

$1,700,000

Welcome your Guests through beautifully carved Wood Doors

Note the 95 (fully paid for) SOLAR PANELS

Adorable Blue Door welcomes to you to the Casita

Looking from back of yard towards the Tiki Bar

Horse Sculpture looking South on Avenida Bermudas

Stairway to Nowhere - Could possibly make a roof-top deck?

Great chandelier over the (8 seat) Dining Table that is included

Little (tasting?) room that leads in to the wine cellar

Note the turquoise awning over the patio area

2nd Master - gorgeous wooden carved door

Big Colored Glass knobs on double shower doors

2nd Master Bath - Has 2 separate water closets

Unique and Fun bathroom sinks & vanities

2nd Horse Sculpture on the hill (lit up at night)

Hard to tell, but there is a pump to create a waterfall to the left of the Palm

Lovely sink & mirror in (one of the 2) Powder Rooms

"Gallery Hallway" that leads from the kitchen/dining to the open space living area

One of Two sinks for convenient prepping & washing

Master Bath is Bright & Modern with big soaking tub

Walk In shower. 2 x water closets (1 with bidet)

Canopies outside Living Room retractable doors

The bar under the mirror has a sink and plenty of storage, with a fridge

That's an 85" TV mounted on the wall, to give you an idea of the space

Shot looking from the bar towards the "Art Hallway"

Property Type: Residential Bedrooms: 5 Baths: 7 Square Footage: 7,696 Status: Closed

Current Price: $1,700,000 List Date: 5/26/2021 Last Modified: 7/14/2025

Overview

Description

All the Superlative Buzz Words (''Exceptional, Unique, One-of-a-Kind, Spectacular, Uncommon, Extraordinary!'') cannot truly describe this Amazing, PRIVATE Retreat in La Quinta. Spacious -7,000 sq. ft. - 5 Bed / 7 Bath (4 en-suite bedrooms in main house, plus Casita) Huge kitchen (with ginormous Island), 2 Dishwashers & 2 Sinks. Sitting on almost an acre of beautifully landscaped grounds, with Unique Pool & Spa, Tiki-Bar and even a Waterfall! Not to mention the 2 Horse Sculptures on the Hillside. BONUS! 95 Solar Panels (paid for), No HOA (so no Dues or Rules), 5-car Garage, Down the street from the great La Quinta Trail system. You feel like you are in your private world, yet minutes away is Fantastic Dining, Entertainment, Farmers Market in Old Town La Quinta, Great Golf, Indian Wells Tennis Gardens, Polo Fields and Convenient Shopping and Services.

Listing Details MLS# 219062646

General Property Information

Total Bedrooms: 5
Full Baths: 3
3/4 Baths: 2
Half Baths: 2
Approx SqFt: 7696
Total Baths: 7
SqFt Source: Assessor
Fireplace: No
Pool: Yes
Garage: Yes
Garage Description: Attached
Sprinklers: Yes
Building # of Stories: Yes
Lot Size Source: Assessor
Year Built: 2005
Furnished: Unfurnished
Cross Streets: Calle Chillon

Property Features

Sale Type: Standard Listing Terms: Cash; Conventional; FHA Possession: Close Of Escrow Lot Description: Automatic Gate; Back Yard; Landscaped; Private; Street Public; Utilities - Overhead; Yard View Type: Mountain(s) Property Orientation Faces: Front Door Faces West Other Structures: Guest House/Casita Other Structural Features: Energy Efficient; Premium Lot; Solar System Owned Irrigation: Sprinkler Timer Fencing: Chain Link; Fenced; Stucco Wall; Wood Disclosures: Easements Community Features: Curbs; Street Lighting Levels: Ground Entry Location: Ground Level - No Steps Appliances: Convection Oven; Dishwasher; Disposal; Dryer; Electric Cooktop; Electric Oven; Electric Range; Exhaust Fan; Ice Maker; Microwave Oven; Refrigerator; Self Cleaning Oven; Washer; Water Line to Refrigerator Built-In BBQ: Propane Range Hood: Yes Warmer Oven Drawer: Yes Kitchen Features: Granite Slab Counters; Island; Pantry Eating Areas: Breakfast Nook; Dining Area Bedroom Features: 2 Primary Bedrooms; All Bedrooms Down; Main Floor Primary Bedroom; Primary Retreat; Primary Suite; Walk In Closet Bathroom Features: 2 Primary Baths; Bidet; Double Shower; Double Vanity(s); Fiberglass Shower; Low Flow Toilet(s); Powder Room; Shower & Tub; Shower Over Tub; Shower Stall; Sunken Tub; Tub With Jets Doors: Double Door Entry; French Doors; Sliding Doors Exterior Construction: Stucco Flooring: Ceramic Tile; Mixed Cooling Type: Air Conditioning; Ceiling Fan(s); Central Air; Electric; Zoned Pool Location: Private Pool Construction: In Ground Pool Description: In Ground; Private Heating: Central; Zoned Heating Fuel: Electric; Solar Rooms: Bar; Bonus Room; Breakfast; Casita - Guest House; Dining Area; Library; Living Room; Loft; Walk In Pantry; Wine Cellar Interior Features: Bar; Hi-Speed Data Wiring; High Ceilings (9 Ft+); Recessed Lighting; Storage; Surround Sound Wired; Track Lighting; Vaulted Ceiling(s); Wet Bar TV Services: Cable TV Laundry: Electric Dryer Hookup; Individual Room Security Safety: Automatic Gate Window Treatments: Blinds; Skylight(s); Stained Glass Patio Features: Awning(s); Brick - Tile Sewer: In, Connected and Paid Water: Water District Water Heater Feature: Electric Parking: Circular Driveway; Direct Entrance; Driveway; Garage Door Opener; On Street; Oversized Road Surface Type: Paved Contingent Upon: Inspection Land Lease Type: Fee Simple

Listing Location and Property Info

APN: 774225019
Original List Price: 220000000
Property Sub-Type: Single Family Residence
Street #: 54038
Street Name: Avenida Bermudas
County: Riverside
State: CA
Zip Code: 92253
Area: 313 -La Quinta South of HWY 111
Country: US

Listing Info

Exclusions of Sale: Art Work in Hallway, and a few other pieces are available for sale
Short Term Rentals: Unknown
Rental Restrictions: Yes
Will Consider Lease: No
School District: Desert Sands Unified

Tax Info

Tax Mello Roos: No

Property Info

Entry Floor Number: Yes
Green Features: No
Golf Course Within Development: No
Additional Parcel: No
Senior Community: No
Gated Community: No
PUD Y/N: No

More Information

Status Change Info

Status Change Date: 2021-09-20
Pending Date: 2021-09-16
Closed Date: 2021-09-20
Closed Price: 1700000

Water

Water District Name: CVWD

Parking SpacesInformation

Total Garage Spaces: 5
Total Parking Spaces: 7

HOA Information

HOA: No

Listing Office: HomeSmart

Listing Agent: Wendy Lapham

Last Updated: July - 14 - 2025

Information deemed reliable but not guaranteed.