Description
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.
Property Type
ResidentialCounty
RiversideStyle
ResidentialAD ID
50165089
Sell a home like this and save $64,001 Find Out How
Property Details
-
Interior Features
Bedroom Information
- Total Bedrooms : 4
Bathroom Information
- Total Baths: 4
- Full Baths: 4
- Half Baths: 0
Interior Features
- Roof : Tile
- Exterior Property Features : Barbecue
- Interior Features: Breakfast Bar,Built-in Features,Breakfast Area,Tray Ceiling(s),Crown Molding,Separate/Formal Dining Room,High Ceilings,Open Floorplan,Recessed Lighting,Wired for Sound,Dressing Area,Walk-In Closet(s)
- Windows: Double Pane Windows,Shutters
- Property Appliances: Convection Oven,Dishwasher,Electric Oven,Gas Cooktop,Disposal,Gas Water Heater,Microwave,Refrigerator,Self Cleaning Oven,Vented Exhaust Fan,Water To Refrigerator,Water Heater
- Fireplace: Gas,Great Room,See Through
- Flooring: Carpet,Tile
Cooling Features
- Central Air,Gas
- Air Conditioning
Heating Source
- Forced Air,Fireplace(s),Natural Gas
- Has Heating
Fireplace
- Fireplace Features: Gas,Great Room,See Through
- Has Fireplace: 1
-
Exterior Features
Building Information
- Year Built: 2007
- Construction: Stone,Stucco
- Roof: Tile
Exterior Features
- Barbecue
Security Features
- Security Gate,Gated Community,24 Hour Security,Resident Manager
Pool Features
- Electric Heat,In Ground,Pebble,Private,Salt Water,Waterfall
Laundry Features
- Laundry Room
Patio And Porch
- Covered
Fencing
- Block
-
Property / Lot Details
Lot Details
- Lot Dimensions Source: Vendor Enhanced
- Lot Size Acres: 0.38
- Lot Size Source: Assessor
- Lot Size Square Feet: 16553
-
Listing Information
Listing Price Information
- Original List Price: 1,075,000
- Listing Contract Date: 2025-06-12
Lease Information
- Listing Agreement: Seller Reserved
-
Taxes / Assessments
Tax Information
- Parcel Number: 764550023
-
Virtual Tour, Parking, Multi-Unit Information & Homeowners Association
Garage and Parking
- Garage Description: Direct Access,Driveway,Garage,Golf Cart Garage,Garage Door Opener,Side By Side
- Attached Garage: Yes
Homeowners Association
- Association: Yes
- Association Amenities: Bocce Court,Billiard Room,Clubhouse,Fitness Center,Fire Pit,Golf Course,Maintenance Grounds,Game Room,Lake or Pond,Meeting Room,Management,Meeting/Banquet/Party Room,Barbecue,Pet Restrictions,Recreation Room,Security,Tennis Court(s),Cable TV
- Association Fee: 595
- AssociationFee Frequency: Monthly
- Calculated Total Monthly Association Fees: 595
Rental Info
- Lease Term: Negotiable
-
School, Utilities & Location Details
Other Property Info
- Source Listing Status: Active
- Source Neighborhood: 313 - La Quinta South of HWY 111
- Postal Code Plus 4: 7982
- 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.
- Source Property Type: Residential
- Area: 313 - La Quinta South of HWY 111
- Property SubType: Single Family Residence
Building and Construction
- Property Age: 18
- Structure Type: Single Family Residence
- Year Built Source: Assessor
- Total Square Feet Living: 2784
- Levels or Stories: One
- Building Total Stories: 1
Statistics Bottom Ads 2

Sidebar Ads 1

Learn More about this Property
Sidebar Ads 2

Sidebar Ads 2

Copyright © 2025 by the Multiple Listing Service of the California Regional MLS®. This information is believed to be accurate but is not guaranteed. Subject to verification by all parties. This data is copyrighted and may not be transmitted, retransmitted, copied, framed, repurposed, or altered in any way for any other site, individual and/or purpose without the express written permission of the Multiple Listing Service of the California Regional MLS®. Information Deemed Reliable But Not Guaranteed. Any use of search facilities of data on this site, other than by a consumer looking to purchase real estate, is prohibited.
BuyOwner last updated this listing 07/01/2025 @ 06:22
- MLS: 219131413DA
- LISTING PROVIDED COURTESY OF: ,
- SOURCE: CRMLS
is a Home, with 4 bedrooms which is for sale, it has 2,784 sqft, 16,553 sized lot, and 3 parking. are nearby neighborhoods.