- 4 beds
- 4 baths
- 2,784 sqft
- ~1/2 acre lot
- $386 per sqft
- 2007 build
- – on site
A rare and exceptional Trilogy at La Quinta Mesquite Model Pool and Spa Retreat. At 2,784 SQ FT the property boasts two Casitas on a beautifully landscaped 16,553 SQ FT estate-sized lot, just across from the Trilogy Golf Course. A hidden gem, the park-like sanctuary features lawns and pathways that wind around the home offering a variety of covered and open areas from which to play, relax and entertain. With 4-bedrooms, 4- baths, a great room, formal dining room, large office, gourmet kitchen, multiple covered patios, a two-car plus additional single-vehicle garage, the home offers plenty of room for all your most desired lifestyle needs. Guest will love the privacy of the detached Casita with full bath and kitchenette with mini-frig, sink and upper and lower cabinets with a microwave. The additional attached Casita also has a privacy entry off the courtyard, but is an extension of the main home. The property features an extraordinary backyard retreat, with mature palms, custom pavers, an oasis styled salt water pool and spa with rock waterfalls, a professional BBQ station with a bar and seating area for dining and entertaining, all wrapped into a park-like setting of brightly colored and textured desert flowers and trees. Behind the tall solid-wood front entry door, is a stone and stucco foyer that leads you to a private expansive open-air courtyard with a Pergola cover that extends between the detached Casita and main home for comfy year-round outdoor living. The main home foyer opens to a spacious great room with lofty 10-foot ceilings, arched doorways, tile on-point, crown molding, and picture windows with plantation shutters open to the backyard's park-like views. The elegant great room features handsome wood-crafted built-ins with a gas-log fireplace and surround sound for a movie theater experience. A spacious gourmet kitchen showcases quality stainless appliances, including a double-oven, an abundance of cabinet and countertop space topped with slab granite and a custom tile backsplash, a center-island with seating and pendant lighting, and a bright breakfast area. The formal dining room features a built-in breakfront with lots of storage, and is the perfect place for making new memories. A separate office off the great room is perfect for telecommuting or as a library or study. The guest bedrooms and baths are located in a separate wing from the primary bedroom.
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Jun 14, 2025
•
MLS# 219131413DA —
This home is listed in more than one place. See it here.
The Building
-
Year Built:2007
-
Year Built Source:Assessor
-
New Construction:No
-
Construction Materials:Stucco, Stone
-
Builder Name:Shea Homes
-
Builder Model:Mesquite W/Casita
-
Roof:Tile
-
Exterior Features:Barbecue Private
-
Stories Total:1
-
Patio And Porch Features:Covered
-
Patio:1
Interior
-
Features:Built-in Features, Tray Ceiling(s), Wired for Sound, Recessed Lighting, Open Floorplan, High Ceilings, Crown Molding
-
Levels:One
-
Kitchen Features:Granite Counters, Kitchen Island
-
Eating Area:Breakfast Nook, Breakfast Counter / Bar, Dining Room
-
Door Features:French Doors, Sliding Doors
-
Window Features:Shutters, Double Pane Windows
-
Flooring:Carpet, Tile
-
Room Type:Den, Guest/Maid's Quarters, Great Room, Entry, Dressing Area, Walk-In Closet, Retreat
-
Living Area Source:Assessor
-
Fireplace:Yes
-
Fireplace:Gas, See Through, Great Room
-
Laundry:Individual Room
-
Laundry:1
Room Dimensions
-
Living Area:2784.00
Financial & Terms
-
Disclosures:CC And R's, Pet Restrictions, Homeowners Association
Location
-
Directions:Enter Trilogy on 60th, first left onto Desert Willow, 2nd right onto Fire Barrel. Home on the left hand side. Cross Street: Fire Barrel Drive.
-
Latitude:33.60029700
-
Longitude:-116.23398900
The Property
-
Property Type:Residential
-
Subtype:Single Family Residence
-
Lot Features:Back Yard, Yard, Level, Landscaped, Lawn, Front Yard, Sprinklers Drip System, Sprinklers Timer, Sprinkler System, Planned Unit Development
-
Lot Size Area:16553.0000
-
Lot Size Acres:0.3800
-
Lot Size SqFt:16553.00
-
Lot Size Source:Assessor
-
Fencing:Block
-
Fence:Yes
-
Sprinklers:Yes
-
Security Features:24 Hour Security, Resident Manager, Gated Community, Automatic Gate
-
Other Structures:Guest House
-
Land Lease:No
-
Lease Considered:No
Listing Agent
- Contact info:
- No listing contact info available
Beds
-
Total Bedrooms:4
Baths
-
Total Baths:4
-
Bathroom Features:Vanity area, Shower in Tub, Separate tub and shower, Linen Closet/Storage
-
Full & Three Quarter Baths:4
-
Full Baths:4
The Listing
-
Special Listing Conditions:Standard
-
Parcel Number:764550023
Heating & Cooling
-
Heating:1
-
Heating:Fireplace(s), Forced Air, Natural Gas
-
Cooling:Yes
-
Cooling:Gas, Central Air
Utilities
-
Utilities:Cable Available
-
Electric:220 Volts in Laundry
Appliances
-
Appliances:Gas Cooktop, Microwave, Convection Oven, Self Cleaning Oven, Electric Oven, Vented Exhaust Fan, Water Line to Refrigerator, Refrigerator, Disposal, Dishwasher, Gas Water Heater, Water Heater
-
Included:Yes
The Community
-
Subdivision:Trilogy
-
Subdivision:Trilogy
-
Features:Golf
-
Association Amenities:Barbecue, Tennis Court(s), Recreation Room, Pet Rules, Management, Meeting Room, Maintenance Grounds, Lake or Pond, Golf Course, Fire Pit, Gym/Ex Room, Card Room, Clubhouse, Billiard Room, Banquet Facilities, Bocce Ball Court, Security, Cable TV, Concierge, Clubhouse Paid
-
Association:Trilogy at La Quinta Maintenance Assn
-
Association:Yes
-
Association Fee:$595
-
Association Fee Frequency:Monthly
-
Pool:Waterfall, In Ground, Pebble, Electric Heat, Salt Water, Private
-
Senior Community:Yes
-
Private Pool:Yes
-
Spa Features:Heated, Private, In Ground
-
Assessments:No
Parking
-
Parking:Yes
-
Parking:Golf Cart Garage, Driveway, Garage Door Opener, Direct Garage Access, Side by Side
-
Parking Spaces:3.00
-
Attached Garage:Yes
-
Garage Spaces:3.00
Monthly cost estimate

Asking price
$1,075,000
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$5,756
|
Taxes | N/A |
Insurance | $295 |
HOA fees | $595 |
Utilities | $244 See report |
Total | $6,890/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
6/12/25
Jun 12, 2025
|
Listed / Active | CRMLS_CA | $1,075,000 | -2.3% (-0.8% / YR) |
3/24/25
Mar 24, 2025
|
Price Changed | CRMLS_CA | ||
3/2/25
Mar 2, 2025
|
Price Changed | CRMLS_CA |