---
listing_id: CR219152475DA
status: Active
price: 2000000
beds: 4
baths_full: 4
baths_half: 1
sqft_living: 3707
sqft_lot: 13939
lot_acres: 0.32
year_built: 1997
property_type: Residential
property_subtype: Single Family Residence
address: "78840 Lima"
city: La Quinta
state: CA
zip: 92253
county: "Riverside County"
lat: 33.6766109
lng: -116.2878852
days_on_market: 64
hoa_fee: 463
hoa_frequency: Monthly
garage_spaces: 3
list_agent: "Craig Chorpenning"
list_office: "Desert Sotheby's International Realty"
list_agent_phone: "(760) 777-2389"
list_agent_license: 01887862
mls_source: CRMLS
modified: 2026-11-11
transaction_type: buy
---

Home | Riverside County | La Quinta | 92253 | 78840 Lima

78840 Lima, La Quinta, CA 92253

MLS: CR219152475DA | Status: Active | Price: $2,000,000
Beds/Baths: 4 / 4 /1
Property Type: Residential

Quick Facts

Beds Baths Sq Ft Acres Lot Yr Built
4 4 /1 3,707 0.32 1997

Upcoming Open Houses

Date Time Hosted By
Sunday, November 15 12:00 pm - 3:30 pm Craig Chorpenning

Remarks

A beautiful expression of desert living, this inviting residence at The Citrus Club unfolds around two distinct outdoor experiences: an intimate, south-facing courtyard with pool, spa, and Santa Rosa Mountain views, and an expansive golf-course setting overlooking the 5th fairway of the Pete Dye course. Beyond the frosted-glass entry, light-filled interiors reveal generous proportions and an effortless connection to the outdoors. At the heart of the home, the great room makes a striking impression with its dramatic fireplace wall, built-in display niches, and multiple sets of doors opening to covered patios on either side. The result is a wonderfully fluid living environment where courtyard mornings, afternoons by the pool, and evenings overlooking the fairway become part of the home's rhythm. Designed for entertaining, the residence offers multiple gathering and dining spaces, each with its own relationship to the surrounding landscape. The private courtyard creates a resort-like centerpiece with a saltwater pool and spa, fountain, lush landscaping, and mountain views, while the golf course patio offers a completely different perspective; open, peaceful, and beautifully positioned for enjoying the desert scenery. The primary suite is a serene retreat with generous scale and dir

MLS Listing Information

Field Value
MLS # CR219152475DA
MLS Source California Regional MLS
Days on Site 64

Features

Interior Features

Feature Details
Bedrooms Ground Floor Bedroom, Primary Suite/Retreat
Kitchen Other
Appliances Dishwasher, Microwave, Other, Refrigerator
Dining Room Breakfast Bar, Formal Dining Room
Fireplace Gas Burning, Living Room
Laundry In Laundry Room
Cooling Central Forced Air
Heating Forced Air

Exterior Features

Feature Details
Pool Heated, In Ground, Pool - Yes, Spa - Private

Parking, School, and Other Information

Feature Details
Garage/Parking Gate/Door Opener, Golf Cart, Other, Garage: 3 Car(s)
HOA Fee $463
HOA Fee Frequency Monthly
Complex Amenities Golf Course

Contact Information

Craig Chorpenning
Desert Sotheby's International Realty
License #: 01887862
Phone: (760) 777-2389

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
Harry S. Truman Elementary School public K-5 0.69 mi 5
John Adams Early Childhood Learning Center public KG,1 0.77 mi N/A
La Quinta Middle School public 6-8 0.78 mi 4
Benjamin Franklin Elementary School public K-5 1.06 mi 6
Mountain Vista Elementary School public K-6 2.51 mi 4
La Quinta High School public 9-12 2.58 mi 7
Amelia Earhart Elementary School Of International Studies public K-5 3.09 mi 6
John Glenn Middle School Of International Studies public 6-8 3.12 mi 6
James Madison Elementary School public K-5 3.23 mi 3
Cahuilla Desert Academy Junior High public 7-8 3.69 mi 3
Dr. Reynaldo J. Carreon Jr. Academy public K-5 3.71 mi 6
Gerald R. Ford Elementary School public K-5 3.80 mi 9
Indio Middle School public 6-8 3.80 mi 1
Indio High School public 9-12 3.80 mi 4
Desert Sands Adult public UG 3.93 mi N/A
Colonel Mitchell Paige Middle School public 6-8 3.94 mi 2
Horizon School public K-12 4.00 mi 4
Summit High (Continuation) School public 10-12 4.00 mi 2
John F. Kennedy Elementary School public K-5 4.03 mi 1
Westside Elementary School public K-6 4.12 mi 7

Nearby Homes

Address Price Beds Baths Sq Ft Status
48788 Cascade $1,750,000 6 4 3,182 PendingDoNotShow
51005 Mandarina $1,650,000 3 3 3,069 Active
47710 via Montigo $1,610,000 4 3/1 3,018 Active
48801 San Isidro St $1,899,000 3 3/1 2,757 Active

Disclosures

©2026 California Regional MLS. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from California Regional MLS.

Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.

This listing information is up-to-date as of November 11, 2026. For the most current information, please contact Craig Chorpenning, (760) 777-2389.