• LinkedIn
Phone949-212-2023
Login or sign up for new accountLogin / Register
Email MeEmail Me
  • Search Listings
    • Residential
    • Lease
  • Previous Sales
  •   Buyers
    • Renting vs. buying
    • How much can I afford?
    • Why work with a real estate agent
    • What do you want in a home?
    • Finding your home
    • Submitting an offer
    • After the offer is accepted
    • Moving
  •     Sellers
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Transaction management
    • Moving
  •     Services
    • Closing Services
    • Home Financing
    • Relocation
    • Insurance
    • Escrow
    • Title
    • Home Warranty
    • PINNACLE
  •     About
    • About Us
    • Leadership Team
    • Globally Respected
    • Diversity & Inclusion
    • The Charitable Foundation
    • Doyle
    • Agents Only
Menu
Berkshire Hathaway HomeServices California Properties Berkshire Hathaway HomeServices California Properties
Any Price
-
  • 0
  • $100,000+
  • $250,000+
  • $500,000+
  • $750,000+
  • $1,000,000+
0+ Beds
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
0+ Baths
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
Property Type
Other
VIRTUAL TOUR
78895 Via Trieste La Quinta, CA 92253
$799,000 4 beds, 3 baths
2, 591 sqft
Save My Notes
 

Photo of Jimmy Harmantzis

Jimmy Harmantzis REALTORĀ® - Broker Associate 949-212-2023 m
949-212-2023 o
Lic#: 01234982
NRDS ID: 641526390
JimmyHarmantzis@bhhscal.com
Text Me
Call My Cell
Call My Office
Lic#: 01234982
NRDS ID: 641526390
JimmyHarmantzis@bhhscal.com
Mission Viejo Office
23120 Alicia Parkway, Suite 100
Mission Viejo, CA 92692
Phone: 949-768-1000
Fax: 949-587-0915
Mission Viejo 23120 Alicia Parkway, Suite 100
Mission Viejo, CA 92692
Call Branch Office
Fax: 949-587-0915
Interested in This Property? Your message will be sent to Jimmy.
By submitting your information, you consent to be contacted by email, SMS message, and/or phone call. You may opt out at any time per our Privacy Policy.
  • Save
  • My Notes

Agent Remarks

This stunning Lake La Quinta home stands out as one of the few properties in the exclusive, guard-gated community that features a fully detached casita. Entering through an impressive courtyard with epoxy stone floors that extend seamlessly across the entire yard and driveway, you are welcomed by double glass-paneled doors that reveal a grand formal living room accented by vaulted ceilings and a striking custom stack stone fireplace. The gourmet kitchen is a chef's dream, outfitted with brand-new stainless steel appliances including a double oven, dishwasher, and wine fridge along side a large butcher block island that promises delightful culinary experiences. An elegant formal dining room with its own cozy stack stone fireplace and a series of French doors throughout the home enhance the connection to the outdoors, leading you to a super-private, south-facing backyard. Here, you can savor breathtaking mountain views while enjoying a pebble tech salt water pool and spa, with the spacious master bedroom offering direct access to this serene outdoor retreat. Recent upgrades, such as energy-efficient windows, newer air conditioning units, and a hot water heater installed just last month, ensure modern comfort and efficiency. Residents also benefit from exclusive access to a 25-acre lake perfect for electric boating, fishing, and kayaking as well as a 3-acre park complete with tennis courts, a community pool, and picnic areas. Conveniently located near grocery stores, restaurants, a modern movie theater, world-class golf courses, shopping, dining, and seasonal events, this home is the ideal choice whether you're seeking a winter getaway or a peaceful retreat to embrace the best of desert living.

Listing Details

Property type: Single Family Residence (Single Family)
Status: Active Under Contract
MLS# 25490515
List price is $799,000 Reduced by $8,950 on 4/7/2025
HOA Fee is $499.00
Beds: 4
Baths: 3 (3 full)
Dining Room fireplaces
Built in 1998
2,591 sqft
1 story
0.18 acres
Lot size: 0.1800
Subdivision: Lake La Quinta
County: Riverside
Construction: Stucco
Interior features: Ceiling Fan(s),Separate/Formal Dining Room,Walk-In Closet(s)
Appliances: Dishwasher,Electric Oven,Gas Cooktop,Disposal,Microwave,Refrigerator,Dryer,Washer
Parking description: Door-Multi,Garage
Heating/cooling: Central Air
Heating description: Central,Fireplace(s),Natural Gas
MLS area: 313 - La Quinta South of HWY 111
Furnished: Furnished Or Unfurnished

Last Updated: 5/7/2025

 Find more La Quinta homes and real estate

 Find more homes in 92253 zip code

This listing belongs to the 313 - La Quinta South of HWY 111 MLS area

 Find more homes in the Lake La Quinta subdivision

Lat/Long: 33.700320, -116.288933.
Find nearby listings


Listing Agent: Fatima Nordquist
Lic#: 01234982
Office Name: Mission Viejo

Area Map

Nearby Schools

No schools were found in the area

Area Overview

Total population of , which has changed by % since 1990.
The median age of the population is , while the median age of dwellings is .
Out of households, are families.

Community Characteristics:

Occupancy Type

White/Blue Collar Jobs

Population by Gender

Hispanic/Non-Hispanic Population

Compared to National:

  • Search
    • My Previous Sales
    • Residential
    • Lease
    • Open Houses
    • Commercial
    • New Homes
    • Luxury
  • Buyers
    • Renting vs. buying
    • How much can I afford?
    • Why work with a real estate agent
    • What do you want in a home?
    • Finding your home
    • Submitting an offer
    • After the offer is accepted
    • Moving
  • Sellers
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Transaction management
    • Moving
  • Services
    • Prosperity Home Mortgage
    • HomeServices Relocation
    • HomeServices Insurance Agency
    • Pickford Escrow
    • California Title Company
    • American Home Shield
    • PINNACLE
    • myNHD
  • About
    • About Us
    • Leadership Team
    • Globally Respected
    • Diversity & Inclusion
    • The Charitable Foundation
    • Doyle
    • Agents Only

Photo of Jimmy Harmantzis

Jimmy Harmantzis REALTORĀ® - Broker Associate 949-212-2023 m
949-212-2023 o
Lic#: 01234982
NRDS ID: 641526390
JimmyHarmantzis@bhhscal.com
Text Me
Call My Cell
Call My Office
Lic#: 01234982
NRDS ID: 641526390
JimmyHarmantzis@bhhscal.com

Mission Viejo Office
23120 Alicia Parkway, Suite 100
Mission Viejo, CA 92692
  • LinkedIn

© 2025 Berkshire Hathaway HomeServices California Properties (BHHSCP) is a member of the franchise system of BHH Affiliates LLC. BHHS and the BHHS symbol are registered service marks of Columbia Insurance Company, a Berkshire Hathaway affiliate. BHH Affiliates LLC and BHHSCP do not guarantee accuracy of all data including measurements, conditions, and features of property. Information is obtained from various sources and will not be verified by broker or MLS. Buyer is advised to independently verify the accuracy of that information.
Lic#: 01317331

Photo of Equal Housing Opportunity Privacy Policy - California Privacy Notice - Terms of Use - Accessibility
Do Not Sell My Personal Information DMCA.com Protection Status