Search -

51555 Madison Street, La Quinta, CA 92253

$4,600,000

Property Type: Residential Bedrooms: 3 Baths: 3 Square Footage: 6,194 Lot Size (sq. ft.): 402,930 Status: Closed

Current Price: $4,600,000 List Date: 9/19/2023 Last Modified: 12/10/2024

Overview

Description

(Listing for Comp Purpose Only). You will experience mind blowing 360° unobstructed views overlooking the polo grounds, olive orchard and surrounding mountains. An entertainer's dream, this spectacularly remodeled villa includes smart home tech, custom cabinetry from Italy, and the finest quality appliances. Dine at a BBQ for 20, swim in the 40ft romanesque pool, indulge in the jacuzzi for 10+, all bordered by majestic 100 foot palms, a 20ft fire-pit and a soothing show of water features. Two additional guest houses ready for you to make this remarkable 9.25 acre estate your own.

Listing Details MLS# 219100096

General Property Information

Total Bedrooms: 3
Full Baths: 3
Approx SqFt: 6194
Total Baths: 3
SqFt Source: Builder
Fireplace: Yes
Total Fireplaces: Yes
Pool: Yes
Garage: No
Sprinklers: Yes
Building # of Stories: Yes
Lot Acres: 9.25
Lot Size Source: Assessor
Year Built: 1950
Furnished: Unfurnished
Cross Streets: Madison Street

Property Features

Sale Type: Standard Listing Terms: Cash to New Loan Possession: Close Plus 2 Days Lot Description: Agricultural; Automatic Gate; Horse Property; Landscaped; Level; Private Lot Location: Private Road View Type: Mountain(s); Orchard; Panoramic; Pool Other Structures: Barn(s); Guest House/Casita Other Structural Features: Premium Lot Other Equipment: Satellite Dish Irrigation: Drip System; Sprinkler System; Sprinkler Timer Fencing: Block; Fenced Disclosures: Property As Is Casita Features: Kitchen Community Features: Equestrian Center; Trailer Storage Available Building Style: Hacienda; Mediterranean; Mid Century; Ranch Levels: Ground Entry Location: Ground Level - No Steps Unit Location: Ground Floor Appliances: Antenna; Bar Ice Maker; Convection Oven; Dishwasher; Dryer; Electric Cooktop; Ice Maker - Standalone; Microwave Oven; Refrigerator; Washer; Water Line to Refrigerator; Water Purifier Kitchen Features: Island; Kitchenette; Quartz Counters; Remodeled Eating Areas: Dining Area; Formal Dining Room; Kitchen Island Bedroom Features: 2 Primary Bedrooms; All Bedrooms Down; Walk In Closet Bathroom Features: Bidet; Double Vanity(s); Remodeled; Shower & Tub; Sunken Tub Doors: Double Door Entry; French Doors; Sliding Doors Exterior Construction: Stucco Foundation: Slab Flooring: Terrazzo; Other Cooling Type: Air Conditioning; Central Air Pool Location: Private Pool Accessories: Fountain; Waterfall Pool Construction: In Ground; Tile Pool Description: Heated; In Ground; Private; Other Heating: Central; Fireplace(s); Zoned Heating Fuel: Propane Gas Fireplace Location: Great Room; Patio Fireplace Features: Propane; Wood Rooms: Bonus Room; Casita - Guest House; Dining Area; Dining Room; Formal Entry; Great Room; Other Interior Features: Beamed Ceilings; Brick Walls; Built-In Features; Hi-Speed Data Wiring; High Ceilings (9 Ft+); Recessed Lighting; Storage; Surround Sound Wired Laundry: Individual Room Security Safety: Automatic Gate; Card/Code Access; Closed Circuit Camera(s); Exterior Security Lights; Security System Owned Disability Access: No Interior Steps Window Treatments: Custom Window Covering; Low Emissivity Windows Sewer: Septic Tank Water: Private; Storage Tank(s); Well; Other Parking: Detached Carport; RV Access/Parking Land Lease Type: Fee Simple

Listing Location and Property Info

APN: 777030006
Original List Price: 4600000
Property Sub-Type: Single Family Residence
Street #: 51555
Street Name: Madison
Street Suffix: Street
County: Riverside
State: CA
Zip Code: 92253
Area: 313 -La Quinta South of HWY 111
Country: US

Listing Info

Exclusions of Sale: Sold Unfurnished. Brand New Roche Bubois (tags still on most pieces & many pieces still in unopened boxes) furniture available outside of escrow.
Short Term Rentals: Yes
Will Consider Lease: No

Tax Info

Tax Mello Roos: No

Property Info

Entry Floor Number: Yes
Golf Course Within Development: No
Senior Community: No
Gated Community: Yes
PUD Y/N: No
View: Yes
Total Monthly Association Fees: 0

More Information

Status Change Info

Status Change Date: 2023-09-19
Pending Date: 2023-09-19
Closed Date: 2023-09-19
Closed Price: 4600000

Parking SpacesInformation

Total Carport Spaces: 3
Total Parking Spaces: 3

HOA Information

HOA: No

Listing, Location and Property Info

Entry Date: 2023-09-19
Land Type: Fee

Community Features

Equestrian Center: Yes
Trailer Storage Available: Yes

Fencing

Block: Yes
Fenced: Yes

Sale Type

Standard: Yes

Listing Terms

Cash to New Loan: Yes

Possession

Close Plus 2 Days: Yes

Parking Spaces/Information

Total Covered Spaces: 0
Total Uncovered/Assigned Spaces: 0

Lot Description

Agricultural: Yes
Automatic Gate: Yes
Horse Property: Yes
Landscaped: Yes
Level: Yes
Private: Yes

Lot Location

Private Road: Yes

View Type

Mountain(s): Yes
Orchard: Yes
Panoramic: Yes
Pool: Yes

Other Structures

Barn(s): Yes
Guest House/Casita: Yes

Other Structural Features

Premium Lot: Yes

Other Equipment

Satellite Dish: Yes

Irrigation

Drip System: Yes
Sprinkler System: Yes
Sprinkler Timer: Yes

Disclosures

Property As Is: Yes

Casita Features

Kitchen: Yes

Building Style

Hacienda: Yes
Mediterranean: Yes
Mid Century: Yes
Ranch: Yes

Levels

Ground: Yes

Entry Location

Ground Level - No Steps: Yes

Unit Location

Ground Floor: Yes

Appliances

Antenna: Yes
Bar Ice Maker: Yes
Convection Oven: Yes
Dishwasher: Yes
Dryer: Yes
Electric Cooktop: Yes
Ice Maker - Standalone: Yes
Microwave Oven: Yes
Refrigerator: Yes
Washer: Yes
Water Line to Refrigerator: Yes
Water Purifier: Yes

Kitchen Features

Island: Yes
Kitchenette: Yes
Quartz Counters: Yes
Remodeled: Yes

Eating Areas

Dining Area: Yes
Formal Dining Room: Yes
Kitchen Island: Yes

Bedroom Features

2 Primary Bedrooms: Yes
All Bedrooms Down: Yes
Walk In Closet: Yes

Bathroom Features

Bidet: Yes
Double Vanity(s): Yes
Remodeled: Yes
Shower & Tub: Yes
Sunken Tub: Yes

Doors

Double Door Entry: Yes
French Doors: Yes
Sliding Doors: Yes

Exterior Construction

Stucco: Yes

Foundation

Slab: Yes

Flooring

Terrazzo: Yes
Other: Yes

Cooling Type

Air Conditioning: Yes
Central Air: Yes

Pool Location

Private: Yes

Pool Accessories

Fountain: Yes
Waterfall: Yes

Pool Construction

In Ground: Yes
Tile: Yes

Pool Description

Heated: Yes
In Ground: Yes
Private: Yes
Other: Yes

Spa/Hot Tub Construction

Gunite: Yes
In Ground: Yes
Tile: Yes

Spa/Hot Tub Description

Heated: Yes
Private: Yes

Heating

Central: Yes
Fireplace(s): Yes
Zoned: Yes

Heating Fuel

Propane Gas: Yes

Fireplace Location

Great Room: Yes
Patio: Yes

Fireplace Features

Propane: Yes
Wood: Yes

Rooms

Bonus Room: Yes
Casita - Guest House: Yes
Dining Area: Yes
Dining Room: Yes
Formal Entry: Yes
Great Room: Yes
Other: Yes

Interior Features

Beamed Ceilings: Yes
Brick Walls: Yes
Built-In Features: Yes
Hi-Speed Data Wiring: Yes
High Ceilings (9 Ft+): Yes
Recessed Lighting: Yes
Storage: Yes
Surround Sound Wired: Yes

Laundry

Individual Room: Yes

Security Safety

Automatic Gate: Yes
Card/Code Access: Yes
Closed Circuit Camera(s): Yes
Exterior Security Lights: Yes
Security System Owned: Yes

Disability Access

No Interior Steps: Yes

Window Treatments

Custom Window Covering: Yes
Low Emissivity Windows: Yes

Sewer

Septic Tank: Yes

Water

Private: Yes
Storage Tank(s): Yes
Well: Yes
Other: Yes

Parking

Detached Carport: Yes
RV Access/Parking: Yes

Land Lease Type

Fee Simple: Yes

Listing Office: Regency Residential

Listing Agent: Patricia Eppelheimer

Last Updated: December - 10 - 2024

Information deemed reliable but not guaranteed.

760.799.7770