51555 Madison St

6,194 Sq. Ft.
$743 / Sq. Ft.
6,194
Sq. Ft.
$743
per Sq. Ft.

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...(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.
  1. Listed by Patricia Eppelheimer • DRE #01762487 • Regency Residential
  2. Listed by Bob Hurwitz • DRE #00526195 • Hurwitz James Company

Property Details for 51555 Madison Street

Architectural Style
Hacienda, Mediterranean, Mid Century, Ranch
Subdivision Name
Not Applicable-1
Carport Spaces
3.00
Garage Spaces
.00
View
Mountain(s), Pool, Panoramic, Orchard
Furnished
Unfurnished
Cross Street
Madison Street
LISTING UPDATED: 12/10/2024 09:49 AM

Property Details for 51555 Madison Street

StatusClosed
MLS #219100096
Days on Market1
Taxes-
HOA Fees-
Condo/Co-op Fees-
Compass TypeSingle Family
MLS TypeResidential / Single Family Residence
Year Built1950
Lot Size9.25 AC / 402,930 SF
CountyRiverside County

Location

Listing Courtesy of Regency Residential, Patricia Eppelheimer, DRE #01762487; Hurwitz James Company, Bob Hurwitz, DRE #00526195

Sold By Fiv Realty Co, Brandi Pratt, DRE #01968872

Add your commute

Building Information for 51555 Madison Street

Stories1Year Built1950Building Size-Lot Size9.25 AC / 402,930 SF

Payment Calculator

Get preapproved with
OriginPoint Mortgage or Rocket Mortgage1

$27,343 per month

30 year fixed, 6.15% Interest

Principal and Interest

$22,420

Property Taxes

$4,923

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 51555 Madison Street

Summary
Location and General Information
  • Accessibility Features: No Interior Steps
  • Building Area Source: Builder
  • Community Features: Equestrian Center, RV Access/Parking, Trailer Storage Available
  • City: La Quinta
  • Country: US
  • Directions: Follow GPS. Discreet Private Main Estate Gate is located on west side of Madison St. directly across from Polo Fields. Call Listing Agent -Tricia (760) 802-5548 for more details if needed. Cross Street: Madison Street.
  • Levels: Ground
  • Area: 313 -La Quinta South of HWY 111
  • Postal Code Plus4: 7516
  • Senior Community: No
  • Unparsed Address: 51555 Madison Street, La Quinta, CA 92253
  • Walk Score: 0
Parking
  • Attached Garage: No
  • Parking Features: Detached Carport
Taxes and HOA Information
  • Association Fee: $.00
  • Tax Legal Description: 9.25 ACRES NET IN LOT 3 MB 088/042 TR 6682
Virtual Tour
  • Videos Count: 0
Property
Lot Information
  • Lot Features: Premium Lot, Agricultural, Landscaped, Level, Private
  • Lot Size Acres: 9.25
  • Lot Size Square Feet: 402,930.00
  • Lot Size Area: 402,930.00
  • Lot Size Source: Assessor
  • Property Type: Residential, Single Family Residence
  • Property Sub Type: Single Family Residence
Property and Assessments
  • Documents Count: 0
  • Exclusions: Sold Unfurnished. Brand New Roche Bubois (tags still on most pieces & many pieces still in unopened boxes) furniture available outside of escrow.
  • Year Built Source: Assessor
Utilities
  • Cooling: Central Air
  • Cooling: Yes
  • Sewer: Septic Tank
  • Utilities: TV Satellite Dish
  • Water Source: Private, Storage Tank(s), Well, Other
Interior and Exterior Features
Exterior Features
  • Construction Materials: Stucco
  • Fencing: Block
  • Foundation Details: Slab
  • Other Structures: Guest House/Casita, Barn(s)
  • Pool Features: Heated, In Ground, Private, Fountain, Other, Waterfall, Tile
  • Pool Private: Yes
  • Pool: Yes
  • Security Features: Automatic Gate, Card/Code Access, Closed Circuit Camera(s), Exterior Security Lights, Security System Owned
  • Spa Features: Heated, Private, Gunite, In Ground, Tile
  • Spa: Yes
  • Stories Total: 1
Interior Features
  • Appliances: Ice Maker, Electric Cooktop, Microwave, Convection Oven, Water Purifier, Water Line to Refrigerator, Refrigerator, Dishwasher
  • Bathrooms Full: 3
  • Bathrooms One Quarter: 0
  • Bathrooms Three Quarter: 0
  • Total Bathrooms: 3
  • Door Features: Double Door Entry, French Doors, Sliding Doors
  • Fireplace Features: Propane, Patio
  • Fireplace: Yes
  • Fireplaces Total: 1
  • Flooring: Terrazzo
  • Heating: Central, Zoned, Fireplace(s), Propane
  • Heating: Yes
  • Interior Features: 2 Master Bedrooms, All Bedrooms Down, Walk In Closet, Bidet, Quartz Counters, Beamed Ceilings, Built-in Features, Recessed Lighting, Storage
  • Laundry Features: Individual Room
  • Living Area: 6,194.00
  • Other Equipment: Drip System
  • View: Yes
  • Window Features: Custom Window Covering, Low Emissivity Windows
Multi Family
Multi-Family Information
  • Special Listing Conditions: Standard

Property History for 51555 Madison Street

DateEvent & SourcePriceAppreciation
Sep 19, 2023

Sold

GPSMLS #219100096

$4,600,000
Sep 19, 2023

Sold

CRMLS #219100096DA

$4,600,000
Sep 19, 2023

Pending

GPSMLS #219100096

Sep 19, 2023

Listed (Active)

CRMLS #219100096DA

$4,600,000
Sep 19, 2023

Listed (Active)

GPSMLS #219100096

$4,600,000
Jul 19, 2023

Sold (Public Record)

Public Record #1518134246

$4,600,000
Jul 19, 2023

Sold (Public Record)

Public Record #1518134205

$4,600,000
Sep 1, 2022

Expired

CRMLS #219078621DA

Aug 31, 2022

Expired

GPSMLS #219078621

$4,875,000
Aug 17, 2022

Hold

CRMLS #219078621DA

Aug 17, 2022

Hold

GPSMLS #219078621

$4,875,000
May 12, 2022

Listed (Active)

CRMLS #219078621DA

$4,875,000
May 12, 2022

Listed (Active)

GPSMLS #219078621

$4,875,000
May 2, 2022

Expired

CRMLS #219068523DA

May 1, 2022

Expired

GPSMLS #219068523

$4,875,000
Oct 5, 2021

Listed (Active)

GPSMLS #219068523

$4,875,000
Oct 5, 2021

Listed (Active)

CRMLS #219068523DA

$4,875,000
Sep 27, 2021

Withdrawn / Cancelled

GPSMLS #219063754

$4,900,000
Sep 27, 2021

Withdrawn / Cancelled

CRMLS #219063754DA

$4,900,000
Jun 19, 2021

Price Change

GPSMLS #219063754

$5,500,000
Jun 19, 2021

Listed (Active)

GPSMLS #219063754

$4,900,000
Jun 18, 2021

Listed (Active)

CRMLS #219063754DA

$5,500,000
May 20, 2021

Withdrawn / Cancelled

GPSMLS #219055073

$7,500,000
May 20, 2021

Withdrawn / Cancelled

CRMLS #219055073DA

$7,500,000
Jan 2, 2021

Listed (Active)

GPSMLS #219055073

$7,500,000
Jan 2, 2021

Listed (Active)

CRMLS #219055073DA

$7,500,000
Dec 3, 2020

Expired

CRMLS #219048970DA

$7,500,000
Dec 2, 2020

Expired

GPSMLS #219048970

$7,500,000
Sep 3, 2020

Listed (Active)

GPSMLS #219048970

$7,500,000
Sep 3, 2020

Listed (Active)

CRMLS #219048970DA

$7,500,000
DateEvent & SourcePrice
09/19/2023

Sold

GPSMLS #219100096

$4,600,000
09/19/2023

Sold

CRMLS #219100096DA

$4,600,000
09/19/2023

Pending

GPSMLS #219100096

09/19/2023

Listed (Active)

CRMLS #219100096DA

$4,600,000
09/19/2023

Listed (Active)

GPSMLS #219100096

$4,600,000
07/19/2023

Sold (Public Record)

Public Record #1518134246

$4,600,000
07/19/2023

Sold (Public Record)

Public Record #1518134205

$4,600,000
09/01/2022

Expired

CRMLS #219078621DA

08/31/2022

Expired

GPSMLS #219078621

$4,875,000
08/17/2022

Hold

CRMLS #219078621DA

08/17/2022

Hold

GPSMLS #219078621

$4,875,000
05/12/2022

Listed (Active)

CRMLS #219078621DA

$4,875,000
05/12/2022

Listed (Active)

GPSMLS #219078621

$4,875,000
05/02/2022

Expired

CRMLS #219068523DA

05/01/2022

Expired

GPSMLS #219068523

$4,875,000
10/05/2021

Listed (Active)

GPSMLS #219068523

$4,875,000
10/05/2021

Listed (Active)

CRMLS #219068523DA

$4,875,000
09/27/2021

Withdrawn / Cancelled

GPSMLS #219063754

$4,900,000
09/27/2021

Withdrawn / Cancelled

CRMLS #219063754DA

$4,900,000
06/19/2021

Price Change

GPSMLS #219063754

$5,500,000
06/19/2021

Listed (Active)

GPSMLS #219063754

$4,900,000
06/18/2021

Listed (Active)

CRMLS #219063754DA

$5,500,000
05/20/2021

Withdrawn / Cancelled

GPSMLS #219055073

$7,500,000
05/20/2021

Withdrawn / Cancelled

CRMLS #219055073DA

$7,500,000
01/02/2021

Listed (Active)

GPSMLS #219055073

$7,500,000
01/02/2021

Listed (Active)

CRMLS #219055073DA

$7,500,000
12/03/2020

Expired

CRMLS #219048970DA

$7,500,000
12/02/2020

Expired

GPSMLS #219048970

$7,500,000
09/03/2020

Listed (Active)

GPSMLS #219048970

$7,500,000
09/03/2020

Listed (Active)

CRMLS #219048970DA

$7,500,000

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 51555 Madison Street

Taxable ValueLand$3,467,184Additions$1,224,816Total$4,692,000
Tax Record2025$59,082 ($4,923 / month)
Home Facts
Beds3Baths2Total Finished SqFt828 SqFtAbove Grade Finished SqFt828 SqFtStories1Lot Size402,930 SqFtStyleMiscellaneous ResidentialYear Built1950Year Renovated1964ZoningW2CountyRIVERSIDEAPN777-030-006Fireplace TypeHas Fireplace

Schools near 51555 Madison Street

This home is within Coachella Valley Unified School District.
Rating
School
Type
Grades
Distance
Public - K to 6
Public - 7 to 8
Public - 9 to 12
Public - 10 to 12
Rating
School
Distance
Mountain Vista Elementary School
PublicK to 6

Cahuilla Desert Academy Junior High
Public7 to 8

Coachella Valley High School
Public9 to 12

La Familia Continuation High School
Public10 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Similar Sold Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Regency Residential, Patricia Eppelheimer, DRE #01762487; Hurwitz James Company, Bob Hurwitz, DRE #00526195

Based on information from one of the following Multiple Listing Services: CRMLS, CLAW, I-Tech, ROWMLS, GPSMLS, SDMLS, VCRDS/PFAR, Idyllwild Association of Realtors, Ojai Valley Board of REALTORS and/or AVMLS. Information being provided is for the visitor’s personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by CRMLS, CLAW, I-Tech, ROWMLS, GPSMLS, SDMLS, VCRDS/PFAR, Idyllwild Association of Realtors, Ojai Valley Board of REALTORS and/or AVMLS is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.