Skip to main content

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

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.

More Information MLS# 219100096

Listing, Location and Property Info

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

General Property Information

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

Listing Info

Short Term Rentals: Yes Will Consider Lease: No 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.

Tax Info

Tax Mello Roos: No

Property Info

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

Community Features

Equestrian Center: 1 Trailer Storage Available: 1

Fencing

Block: 1 Fenced: 1

Sale Type

Standard: 1

Listing Terms

Cash to New Loan: 1

Possession

Close Plus 2 Days: 1

Parking Spaces/Information

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

Lot Description

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

Lot Location

Private Road: 1

View Type

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

Other Structures

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

Other Structural Features

Premium Lot: 1

Other Equipment

Satellite Dish: 1

Irrigation

Drip System: 1 Sprinkler System: 1 Sprinkler Timer: 1

Disclosures

Property As Is: 1

Casita Features

Kitchen: 1

Building Style

Hacienda: 1 Mediterranean: 1 Mid Century: 1 Ranch: 1

Levels

Ground: 1

Entry Location

Ground Level - No Steps: 1

Unit Location

Ground Floor: 1

Appliances

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

Kitchen Features

Island: 1 Kitchenette: 1 Quartz Counters: 1 Remodeled: 1

Eating Areas

Dining Area: 1 Formal Dining Room: 1 Kitchen Island: 1

Bedroom Features

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

Bathroom Features

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

Doors

Double Door Entry: 1 French Doors: 1 Sliding Doors: 1

Exterior Construction

Stucco: 1

Foundation

Slab: 1

Flooring

Terrazzo: 1 Other: 1

Cooling Type

Air Conditioning: 1 Central Air: 1

Pool Location

Private: 1

Pool Accessories

Fountain: 1 Waterfall: 1

Pool Construction

In Ground: 1 Tile: 1

Pool Description

Heated: 1 In Ground: 1 Private: 1 Other: 1

Spa/Hot Tub Construction

Gunite: 1 In Ground: 1 Tile: 1

Spa/Hot Tub Description

Heated: 1 Private: 1

Heating

Central: 1 Fireplace(s): 1 Zoned: 1

Heating Fuel

Propane Gas: 1

Fireplace Location

Great Room: 1 Patio: 1

Fireplace Features

Propane: 1 Wood: 1

Rooms

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

Interior Features

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

Laundry

Individual Room: 1

Security Safety

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

Disability Access

No Interior Steps: 1

Window Treatments

Custom Window Covering: 1 Low Emissivity Windows: 1

Sewer

Septic Tank: 1

Water

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

Parking

Detached Carport: 1 RV Access/Parking: 1

HOA Information

HOA: No

Land Lease Type

Fee Simple: 1

Listing Location and Property Info

APN: 777030006 Status: Closed Listing Date: 2023-07-13 Original List Price: 4600000 Sold Price: $4,600,000 Current Price: $4,600,000 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

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

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 Office: Regency Residential
Listing Agent: Patricia Eppelheimer
Last Updated: December - 10 - 2024
Information deemed reliable but not guaranteed.

Hand Wave

Contact Darlene

Hi, I'm Darlene Harwick and I provide real estate service to buyers and sellers in the Palm Springs area.

Darlene Harwick
Contact Agent