78840 Lima, La Quinta, CA 92253
Property image
Property image
OFF MARKET

78840 Lima
La Quinta, CA 92253

  • 4 Beds
  • 1.5 Baths
  • 3,770 sqft (on 0.32 acres)

$1,562,500

Trulia Estimate
as of Jul 5, 2026
Est. Refi. Payment $9,441/mo*

$1,562,500

Trulia Estimate
as of Jul 5, 2026
Est. Refi. Payment $9,441/mo*
4 Beds
1.5 Baths
3,770 sqft
(on 0.32 acres)

Local Information

  • Map ViewExplore the area around 78840 Lima.
  • Schools1 Elementary School1 Middle School1 High School
  • Shop & Eat
-- mins to
Commute Destination

Description

A gem in the heart of the Citrus Country Club, located on the 5th fairways of the Pete Dye Course.This custom home is taking advantage of the South West and North East exposure: The guest bedroom and the double room casita open directly onto the courtyard with its beautiful salt water pool, SPA and fountain. The courtyard has a built-in BBQ and faces South, offering a panoramic view on the Santa Rosa Mountain. You enter the main home through a custom made frosted glass door. The large living room area opens on both sides: the patio on the golf course, and the courtyard. The patio gives you all the shade you need after a long outdoor day in the sun. The gourmet kitchen with its gas cooktop, built-in fridge, centered island is well located between a dining area facing the courtyard and a formal dining room facing the golf course. The primary bedroom has a very large bathroom, with shower and soaking tub, an extra large walk in closet. It faces the golf course. The house has two bedrooms with en-suite bathroom, and your guests will love the double room casita with its Jack and Jill bathroom. The 3 car garage has an epoxy floor and lots of storage cabinets. This amazing home with its perfect layout maximizing the sun exposure and the views is sold partially furnished,
78840 Lima, La Quinta, CA 92253 is a 4 bedroom, 2 bathroom, 3,770 sqft single-family home built in 1997. It last sold for $1,600,000 on Apr 19, 2023. More recently, it was listed as a rental in July 2024 with an asking price of $18,600 per month. That rental listing was removed on March 26, 2026. It is currently off market. The Trulia Estimate is $1,562,500, with a rent estimate of $5,182/month.

Home Highlights

Parking
Garage
Outdoor
Patio, Pool
A/C
Heating & Cooling
HOA
None
Price/Sqft
No Info
Listed
Less than a day ago

Home Details for 78840 Lima

Interior Features

Heating & Cooling
Heating: Forced AirAir ConditioningCooling System: CentralHeating Fuel: Forced Air
Levels, Entrance, & Accessibility
Stories: 1Floors: Tile
Interior Details
Types of Rooms: Walk In Closet, Dining Room, Laundry Room, Pantry
Appliances & Utilities
Cable ReadyDishwasherMicrowave
Fireplace & Spa
Fireplace

Exterior Features

Exterior Home Features
Roof: TilePatio
Pool
Pool
Parking & Garage
GarageParking Spaces: 3Parking: Garage Attached

Property Information

Year Built
Year Built: 1997
Property Type / Style
Property Type: Single Family Home

Community

Units in Building: 1

Lot Information

Lot Area: 0.32 acres

Price History for 78840 Lima

DatePriceEventSource
03/26/2026$30,000ListingRemovedCRMLS #OC24146665
03/11/2026$30,000PriceChange
CRMLS #OC24146665
11/12/2025$25,000PriceChange
CRMLS #OC24146665
07/16/2025$15,000PriceChange
CRMLS #OC24146665
03/13/2025$30,000PriceChange
CRMLS #OC24146665
11/20/2024$25,000PriceChange
CRMLS #OC24146665
10/08/2024$20,000PriceChange
CRMLS #OC24146665
08/19/2024$15,000PriceChange
CRMLS #OC24146665
07/25/2024$18,600Listed For RentCRMLS #OC24146665
04/19/2023$1,600,000Sold
CDAR/ Desert Area MLS #219090748
04/07/2023$1,750,000PendingCRMLS #219090748DA
03/27/2023$1,750,000ContingentCRMLS #219090748DA
03/01/2023$1,750,000PendingToActiveCRMLS #219090748DA
02/26/2023$1,800,000ContingentCRMLS #219090748DA
02/11/2023$1,800,000Listed For SaleCDAR/ Desert Area MLS #219090748
12/17/2010$725,000Sold
CDAR/ Desert Area MLS #21410370
11/12/2010$725,000PriceChange
Agent Provided
09/02/2010$700,000PriceChange
Agent Provided
08/21/2010$749,000PriceChange
Agent Provided
01/07/2010$849,000PriceChange
Agent Provided
11/27/2009$925,000PriceChange
Agent Provided
11/25/2009$1,050,000PriceChange
Agent Provided
10/13/2009$925,000PriceChange
Agent Provided
04/07/2009$1,050,000PriceChange
Agent Provided
02/26/2009$1,199,000Listed For SaleAgent Provided
05/31/1996$140,000Sold
N/A

Market trends in La Quinta

Last updated May 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
$887K
$27.25K
MoM
Sale-to-List Price
97.0%
0.4%
MoM
Price per sq ft
$406
$5
MoM
Available listings
585
11
MoM
Skip to last item
  • Results are loading
Skip to first item

Property Tax and Assessment

Year2025
Tax$21,389
Assessment$1,664,639
Home facts updated by county records

Comparable Sales for 78840 Lima

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
0.08
Single-Family Home
$2,355,000
09/26/25
4
4.5
4,794
0.08
Single-Family Home
$2,480,000
01/29/26
4
4.5
4,303
0.31
Single-Family Home
$925,000
04/30/26
4
2.5
3,386
0.29
Single-Family Home
$1,039,500
08/05/25
4
4
3,060
0.33
Single-Family Home
$1,800,000
11/13/25
3
3.5
3,364
0.53
Single-Family Home
$1,555,000
03/09/26
3
3
3,100
0.23
Single-Family Home
$947,500
05/08/26
3
3.5
2,756
0.44
Single-Family Home
$1,000,000
06/22/26
4
4.5
3,441
0.25
Single-Family Home
$3,895,000
10/16/25
4
4.5
3,324
0.61
Single-Family Home
$1,610,000
06/30/26
4
4.5
3,840

Nearby homes

Get a sense of prices in the area by checking nearby homes.
Skip to last item
Skip to first item

What Locals Say about La Quinta

At least 297 Trulia users voted on each feature.
  • 90 % Say parking is easy

  • 87 % Say it's dog friendly

  • 86 % Say car is needed

  • 78 % Say it's quiet

  • 73 % Say there's holiday spirit

  • 71 % Say yards are well-kept

  • 67 % Say people would walk alone at night

  • 64 % Say they plan to stay for at least 5 years

  • 50 % Say neighbors are friendly

  • 50 % Say there are sidewalks

  • 46 % Say it's walkable to restaurants

  • 45 % Say kids play outside

  • 37 % Say there's wildlife

  • 35 % Say it's walkable to grocery stores

  • 33 % Say streets are well-lit

  • 31 % Say there are community events

Sourced by Trulia users. Learn more about our methodology.
  • Trulia User
    "Great neighborhood! Highly recommend for anyone looking to live in a nice, friendly, safe environment. Worth checking out!"
  • Vanessa Rubenstein
    "Love it because it’s paradise compared to any other places I lived. Safe, beautiful and peaceful with great entertainment events."
  • Josh
    "Great area and the cove is like its own little town. We have just about everything we need. It’s a quiet area for the most part."
  • Sarah Post
    "Quiet and near nature. I love the community and how family centered La Quinta is. It’s very activity oriented "
  • Lorena Nicolao
    "Love the trails and the Santa Rosa mountains! We’ve lived in the cove for 13 years. The city of La Quinta truly is a beautiful gem and a beautiful place to live. "
  • Vanessa Block-rubenstein
    "Awesome neighborhood with a private dog park as big as a football field. Large homes with big lots and great people."
  • Trills
    "It's a quiet and clean neighborhood. Maybe not the most diverse but people are kind and kind their business. There's not much to do around here, lots of retirees but it's safe and peaceful. Everywhere you look is like a postcard. Maybe boring sometimes but it's peaceful and serene. "
  • Sarah Post
    "No sidewalks for dogs. But, there is a great nature trail that my dogs love to walk along and smell all the smells"
  • Trulia User
    "La Quinta cove is a very safe community, lots of houses are being renovated, and the cove sits between three mountains. Love it."
  • Vanessa Block-rubenstein
    "Compare to Los Angeles it’s heaven! Love living here. Great neighborhood and beautiful area. It’s hot during summer though."
  • Brittany Kuhn
    "Hiking trails and good neighbors make this community what it is. There is a farmers market in Old Town as well."
  • Jennifer Gresham
    "They would love it. Restaurants, shops, outdoor areas dog friendly. Cool trails within neighborhoods. ."
  • Tonya.ochuk
    "There is a local public pool with movie nights, and pickle ball tournaments are very popular at the community park."
  • Lyle McLaren
    "It is safe for kids and everyone in this community to live and enjoy life. We love it here as the people are so nice."
  • Paigesells24seven
    "I have lived in my neighborhood for 9 years. It’s a very clean and quiet neighborhood which I love. The only thing I would change is having more children in the neighborhood because we have kids and it feels like there are no children around here."
  • Moonhee J.
    "l live la quinta six month. I love town and neighborhood . I like to live longer for my lifetime quiete and classic and lots of golfing courses and hiking mountain. etc"
  • Carlos F.
    "Dog owners and dogs are very common along with businesses that cater to dog owners in and around all commercial areas"
  • Nicole C.
    "Art show, the cove, the trails, tacos and beer festival all the restaurants, nice walking area, beautiful mountains, friendly people, pickle ball courts and tennis courts, dog park, markets everywhere, fresh food at the farmers market "
  • Podeschi
    "Lots of dogs here. Very pet friendly. Dog parks are here as well as dog stations. Owners keep pets on leashes. Pets are treated like family members here and I see during quarantine many walking their dogs on the golf course. "
  • Kristoher S.
    "it only takes eight minutes for me to arrive at work since I work close by. Why does this require one hundred characters?"
  • Kim M.
    "people walk their dogs in the early morning hours due to the heat. dog owners need to watch for coyotes. "
  • Sarah.olayo2
    "I think the tennis tournaments are for sure the most unique things about our community here in LQ. Also the shields date garden is pretty great and I recommend it to anyone who is new to LQ."
  • Veronica C.
    "Me and all the shoppingnear me. Great stores target, ULTA, home goods, walmart, Habitburgers, soup plantation. Etc..."
  • I.heart.offbeat
    "We have a very friendly neighborhood. Everyone says "hi" whenever they walk their dogs and we always feel safe at home and within the environment."
  • Achmsons
    "Great family area, good parks and activities for young children and family. Also neighbors are pretty nice and helpful. "
  • Mom
    "Carlsbad, ca. Or Oceanside, is the best place to rent for the summer, I am looking in that area. 2 bedrooms : have a small well mannered service dog. Would like pool"
  • Uilani M. .
    "there are no community events in my neighborhood but old town la quinta is close by and has lots of things happening "
  • Shawn
    "some days are busier than others traffic wise but a smooth drive all the way out. la quinta has a lot of quick stop shops if you know the backroads really well. helps cut time."
  • Rosanna F.
    "Great location. Walk to schools, parks, grocery store. 3 minute drive to department stores, more grocery stores, theater, and restaurants."
  • Lisa L.
    "I am retired so if commuting to the club house, to play golf, to the gym or friends houses we just hop in the golf cart. La Quinta is a wonderful small town."
  • Mrsluzdavis
    "We’ve lived here for 2 years, nice area, nice neighbors, we look out for each other’s property. House and landscape always looks nice."
  • Margarita L.
    "Safe. Pretty. Quiet. I have the best neighbors on both sides of me. Centrally located near all stores. "

LGBTQ Local Legal Protections

Apartments for Rent

Skip to last item
Skip to first item

Explore by feature - Pet Friendly

Explore by feature - Garage

Explore by feature - Air Conditioning

Explore by feature - Pool

Explore by feature - Washer/dryer

Explore by feature - Outdoor Space

Homes for sale near 78840 Lima

Skip to last item
Skip to first item

Off Market Homes Near 78840 Lima

Skip to last item
Skip to first item