Description
Welcome to the only juniper floorplan in trilogy la quinta with a detached guest casita--an exceptional and rare offering in this premier 55+ active adult community. situated on an elevated 12,632 sq. ft. premium lot overlooking the 5th tees of the championship golf course, this beautifully upgraded 2,979 sq. ft. home features four bedrooms and 4.5 bathrooms, including a private detached casita perfect for guests, multigenerational living, or a home office. the open-concept design features a spacious great room, an elegant dining area, and a gourmet kitchen, ideal for both everyday comfort and entertaining. step outside to a resort-style backyard with a private pool and spa, built-in bbq, and cozy fire pit--all positioned to capture panoramic fairway and mountain views and stunning desert sunsets. the expansive covered patio and lush landscaping create a serene retreat for relaxing or entertaining under the stars. inside, enjoy upscale finishes, a luxurious primary suite with a spa-inspired bath, and a 3-car garage offering ample storage. located on a quiet cul-de-sac, this home provides easy access to trilogy's top-tier amenities, including golf, tennis, pickleball, a fitness center, resort-style pool, on-site dining, and an active calendar of events and social clubs. this one-of-a-kind property offers the perfect blend of privacy, luxury, and community--an unmatched opportunity to enjoy the very best of desert living.
Property Type
ResidentialCounty
RiversideStyle
ResidentialAD ID
50327160
Sell a home like this and save $89,501 Find Out How
Property Details
-
Interior Features
Bedroom Information
- Total Bedrooms : 4
Bathroom Information
- Total Baths: 5
- Full Baths: 4
- Half Baths: 1
Interior Features
- Roof : Tile
- Exterior Property Features : Barbecue
- Interior Features: Breakfast Bar,Built-in Features,Breakfast Area,Tray Ceiling(s),Separate/Formal Dining Room,High Ceilings,Open Floorplan,Recessed Lighting,Primary Suite,Walk-In Pantry,Walk-In Closet(s)
- Windows: Double Pane Windows,Shutters
- Property Appliances: Dishwasher,Gas Cooktop,Disposal,Gas Water Heater,Microwave,Refrigerator,Vented Exhaust Fan,Water To Refrigerator
- Fireplace: Gas,Gas Starter,Living Room,See Through
- Flooring: Carpet,Tile
Cooling Features
- Central Air
- Air Conditioning
Heating Source
- Central,Fireplace(s),Natural Gas
- Has Heating
Fireplace
- Fireplace Features: Gas,Gas Starter,Living Room,See Through
- Has Fireplace: 1
-
Exterior Features
Building Information
- Year Built: 2009
- Construction: Stone,Stucco
- Roof: Tile
Exterior Features
- Barbecue
Foundation
- Slab
Security Features
- Gated Community,24 Hour Security
Pool Features
- Community,Electric Heat,In Ground,Pebble,Private,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.29
- Lot Size Source: Builder
- Lot Size Square Feet: 12632
-
Listing Information
Listing Price Information
- Original List Price: 1,500,000
- Listing Contract Date: 2025-07-02
Lease Information
- Listing Agreement: Exclusive Right To Sell
-
Taxes / Assessments
Tax Information
- Parcel Number: 764770042
-
Virtual Tour, Parking, Multi-Unit Information & Homeowners Association
Garage and Parking
- Garage Description: Direct Access,Garage,Garage Door Opener,Oversized,Side By Side
- Attached Garage: Yes
Homeowners Association
- Association: Yes
- Association Amenities: Bocce Court,Billiard Room,Clubhouse,Sport Court,Golf Course,Maintenance Grounds,Game Room,Meeting Room,Meeting/Banquet/Party Room,Other Courts,Barbecue,Racquetball,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: 8240
- Directions: Thru main gate to stop sign, left onto Desert Rose, right onto Ulrich, left onto Living Stone, left onto Cantor Court. Cross Street: Madison / Ave 60.
- Source Property Type: Residential
- Area: 313 - La Quinta South of HWY 111
- Property SubType: Single Family Residence
Building and Construction
- Property Age: 16
- Structure Type: Single Family Residence
- Year Built Source: Builder
- Total Square Feet Living: 2979
- 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/04/2025 @ 13:02
- MLS: 219132239DA
- LISTING PROVIDED COURTESY OF: ,
- SOURCE: CRMLS
is a Home, with 4 bedrooms which is for sale, it has 2,979 sqft, 12,632 sized lot, and 3 parking. are nearby neighborhoods.