Twitter
Facebook
Email
|
Luxury and Natural Beauty! A rare Trilogy at La Quinta grand pool retreat. Whether for personal enjoyment or as an investment, this Mesquite 2,789 SQ FT model home rests on a large 12,632 SQ FT lot, with 4 bedrooms (one a massive primary retreat, detached and attached Casitas, both with baths, have access to the center courtyard, and an additional separate guest bedroom and full bath), a gourmet kitchen, office, formal dining room, multiple covered outdoor patios, two garages that combined fit three full-sized cars. Hidden from the street behind a stand-alone stone entry and large wooden door is a wonderland of extraordinary amenities, the perfect property to live, entertain and enjoy with family and friends. Once behind the door, you arrive at a large courtyard and a beautifully crafted pergola covering a raised stone firepit, large outdoor big screen TV, and plenty of seating for hosting unforgettable gatherings. On warm days, the Cool Fog misting system envelops much of the home's exterior in a fine mist that cools the temperature by as much as 15 degrees. Adjacent to the courtyard and surrounded by exquisite Phoenix Roebelenii palms and brilliant tropical flora, is a spectacular resort-style Pebble-Tec salt water pool, with towering rock waterfalls cascading over three-tiers into the spa and pool below. At the far end of the pool is a raised deck from which to take in the calming views of the pool and gardens. Pathways meander throughout the entire property that lead to several recreational areas, including, a play area of artificial turf under an umbrella of trees, a three-hole putting green, a sunken professional barbecue station with dining counters, multiple covered patios, and an area for growing fresh vegetables, fruit, and herbs. Inside, the home is open with ten-foot ceilings, crown molding, tile floors in the main living areas. The great room has a built-in media center with surround sound speakers in the ceiling. The gas-log fireplace keeps you warm while streaming your favorite shows on cool winter nights. The kitchen is outfitted premium stainless steel appliances, six-burner cooktop, double-oven, and dishwasher. A center island with pendant lighting, abundant cabinetry, built-in pantry, smooth granite slab countertops and stone backsplash, make cooking easy and convenient.
| DAYS ON MARKET | 18 | LAST UPDATED | 9/1/2025 |
|---|---|---|---|
| TRACT | Trilogy | YEAR BUILT | 2007 |
| COMMUNITY | 313 - La Quinta South of HWY 111 | GARAGE SPACES | 3.0 |
| COUNTY | Riverside | STATUS | Active |
| PROPERTY TYPE(S) | Single Family |
| ADDITIONAL DETAILS | |
| ADULT COMMUNITY | Yes |
|---|---|
| AIR | Central Air, Electric |
| AIR CONDITIONING | Yes |
| APPLIANCES | Convection Oven, Dishwasher, Disposal, Electric Oven, Gas Cooktop, Gas Water Heater, Ice Maker, Microwave, Refrigerator, Self Cleaning Oven, Vented Exhaust Fan, Water Heater |
| AREA | 313 - La Quinta South of HWY 111 |
| CONSTRUCTION | Stucco |
| EXTERIOR | Barbecue, Fire Pit |
| FIREPLACE | Yes |
| GARAGE | Attached Garage, Yes |
| HEAT | Central, Fireplace(s), Forced Air, Natural Gas |
| HOA DUES | 595|Monthly |
| INTERIOR | Breakfast Bar, Built-in Features, Crown Molding, High Ceilings, Recessed Lighting, Walk-In Closet(s) |
| LOT | 0.29 acre(s) |
| LOT DESCRIPTION | Back Yard, Front Yard, Irregular Lot, Landscaped, Level |
| PARKING | Attached, Driveway, Golf Cart Garage, Oversized, Side By Side |
| POOL | Yes |
| POOL DESCRIPTION | Private, Electric Heat, In Ground, Salt Water, Waterfall |
| STORIES | 1 |
| SUBDIVISION | Trilogy |
| UTILITIES | Cable Available |
TOTAL MONTHLY PAYMENT
| SATELLITE VIEW |
| / | |
The multiple listing data appearing on this website, or contained in reports produced therefrom, is owned and copyrighted by California Regional Multiple Listing Service, Inc. ("CRMLS") and is protected by all applicable copyright laws. Information provided is for viewer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties the viewer may be interested in purchasing. All listing data, including but not limited to square footage and lot size is believed to be accurate, but the listing Agent, listing Broker and CRMLS and its affiliates do not warrant or guarantee such accuracy. The viewer should independently verify the listed data prior to making any decisions based on such information by personal inspection and/or contacting a real estate professional.
Based on information from California Regional Multiple Listing Service, Inc. as of 9/19/25 6:40 AM PDT and /or other sources. 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
This IDX solution is (c) Diverse Solutions 2025.