81804 Prism Drive, La Quinta, CA 92253

$677,000
Property Type: Residential Bedrooms: 2 Baths: 3 Square Footage: 2,170 Status: Closed
Current Price: $677,000 List Date: 8/04/2025 Last Modified: 9/09/2026

Overview

Description

Raised above the 10th green, this stone and stucco beauty features a luxurious stamped concrete driveway and custom courtyard entry. A Oreas with 2,170 SQ FT the home is complete with a two-car plus separate golf cart garage, new HVAC system, and hot water heater. The back patio is raised above the golf course for exceptional views of the 10th fairway, green, north and west mountains. The patio itself is expansive and exudes quality with stamped concrete flooring, custom tile edging, lush mature landscape and palms with uplighting, a substantial pergola, built-in gas BBQ, and counter. Inside, the soaring 10-ft ceilings, cool custom tile floors, expansive entry and great room make the home feel much larger. Once through the front door your eyes are drawn to the big picture windows that frame the lovely views beyond. The great room is big and open with built-ins and a media center with surround-sound. It offers a flexible floorplan with two additional rooms to meet all your needs. For ex ...

Listing Details MLS# 219133559

General Property Information

Total Bedrooms
2
Full Baths
2
Half Baths
Yes
Approx SqFt
2170
Total Baths
3
SqFt Source
Assessor
Fireplace
No
Pool
No
Garage
Yes
Garage Description
Attached
Sprinklers
Yes
Building # of Stories
Yes
Lot Size Source
Assessor
Year Built
2004
Furnished
Unfurnished
Cross Streets
Avenue 60

Property Features

Sale Type: Standard Listing Terms: Cash; Conventional; VA Loan Possession: Close Of Escrow Lot Description: Back Yard; Front Yard; Landscaped; Lawn; Level; Single Lot; Utilities Underground; Yard Lot Location: On Golf Course View Type: Golf Course; Mountain(s); Panoramic Other Structural Features: Barbeque Private; Premium Lot Irrigation: Drip System; Sprinkler System; Sprinkler Timer Fencing: Block Disclosures: CC & R; Homeowners Association; Pet Restrictions; Planned Development Community Features: Community Mailbox; Curbs; Golf Course Within Development; Pickle Ball Courts; Sidewalks; Street Lighting Levels: Ground Level, No Unit Above Entry Location: Ground Level - No Steps Appliances: Dishwasher; Disposal; Dryer; Electric Oven; Exhaust Fan; Gas Cooktop; Ice Maker; Microwave Oven; Refrigerator; Self Cleaning Oven; Water Line to Refrigerator Built-In BBQ: Gas Kitchen Features: Gourmet Kitchen; Granite Slab Counters; Island; Pantry Eating Areas: Breakfast Counter/Bar; Breakfast Nook; Formal Dining Room; Kitchen Island Bedroom Features: All Bedrooms Down; Primary Suite; Walk In Closet Bathroom Features: Double Vanity(s); Linen Closet; Shower & Tub; Shower Over Tub; Tile Shower Exterior Construction: Stone; Stucco Flooring: Carpet; Tile Cooling Type: Air Conditioning; Ceiling Fan(s); Central Air Heating: Central; Forced Air Heating Fuel: Natural Gas Rooms: Den - Study; Dining Room; Entry; Great Room Interior Features: Built-In Features; High Ceilings (9 Ft+); Open Floorplan; Recessed Lighting; Surround Sound Wired TV Services: Cable TV Laundry: Electric Dryer Hookup; Gas Dryer Hookup; Individual Room Volt 220 Location: In Laundry Security Safety: 24 Hour Security; Automatic Gate; Community; Gated Community Disability Access: No Interior Steps Window Treatments: Custom Window Covering; Low Emissivity Windows; Screens Roofing: Tile Patio Features: Concrete Slab; Covered Sewer: In, Connected and Paid Water: Water District Water Heater Feature: Gas; Water Heater Unit Parking: Driveway; Garage Door Opener; Golf Cart Garage; Side By Side Road Surface Type: Paved Association 1 Frequency: Monthly Association Amenities: Banquet Facilities; Barbecue; Billiard Room; Bocce Ball Court; Card Room; Clubhouse; Controlled Access; Elevator(s); Fire Pit; Fitness Center; Golf Course; Lake or Pond; Maintenance Grounds; Management; Meeting Room; Pet Rules; Recreation Room; Tennis Courts Association Fees Include: Cable TV; Clubhouse; Concierge; Security Association Pet Rules: Assoc Pet Rules; Call Contingent Upon: Inspection Land Lease Type: Fee Simple

Listing Location and Property Info

APN
764360071
Original List Price
680000
Property Sub-Type
Single Family Residence
Street #
81804
Street Name
Prism
Street Suffix
Drive
County
Riverside
State
CA
Zip Code
92253
Area
313 -La Quinta South of HWY 111
Country
US

Listing Info

Exclusions of Sale
Washer and dryer
Short Term Rentals
No
Will Consider Lease
No

Tax Info

Tax Mello Roos
No

Property Info

Golf Course Within Development
Yes
Senior Community
Yes
Gated Community
Yes
PUD Y/N
Yes
Total Monthly Association Fees
595
View
Yes

More Information

Status Change Info

Status Change Date
2025-09-23
Pending Date
2025-09-22
Closed Date
2025-09-23
Closed Price
677000

Builders Information

Builder's Name
Shea Homes
Builder's Model Name
Oreas w/golf garage

Water

Water District Name
Coachella Valley Water District
Water District
Yes

Parking SpacesInformation

Total Garage Spaces
3
Total Parking Spaces
3

HOA Information

HOA
Yes
HOA Fee 1
595

Association Information

Association Name
Trilogy at La Quinta Maintenance Assn
Association Phone Number
750-777-6059

DPR

DPR Eligible
Yes

Listing, Location and Property Info

Entry Date
2025-08-03
Land Type
Fee
Subdivision
Trilogy

Community Features

Community Mailbox
Yes
Curbs
Yes
Golf Course Within Development
Yes
Pickle Ball Courts
Yes
Sidewalks
Yes
Street Lighting
Yes

Fencing

Block
Yes

Sale Type

Standard
Yes

Road Surface Type

Paved
Yes

Listing Terms

Cash
Yes
Conventional
Yes
VA Loan
Yes

Possession

Close Of Escrow
Yes

Parking Spaces/Information

RV
None
Total Covered Spaces
0
Total Uncovered/Assigned Spaces
0

Lot Description

Back Yard
Yes
Front Yard
Yes
Landscaped
Yes
Lawn
Yes
Level
Yes
Single Lot
Yes
Utilities Underground
Yes
Yard
Yes

Lot Location

On Golf Course
Yes

View Type

Golf Course
Yes
Mountain(s)
Yes
Panoramic
Yes

Other Structural Features

Barbeque Private
Yes
Premium Lot
Yes

Irrigation

Drip System
Yes
Sprinkler System
Yes
Sprinkler Timer
Yes

Disclosures

CC & R
Yes
Homeowners Association
Yes
Pet Restrictions
Yes
Planned Development
Yes

Levels

Ground Level, No Unit Above
Yes

Entry Location

Ground Level - No Steps
Yes

Appliances

Dishwasher
Yes
Disposal
Yes
Dryer
Yes
Electric Oven
Yes
Exhaust Fan
Yes
Gas Cooktop
Yes
Ice Maker
Yes
Microwave Oven
Yes
Refrigerator
Yes
Self Cleaning Oven
Yes
Water Line to Refrigerator
Yes

Built-In BBQ

Gas
Yes

Kitchen Features

Gourmet Kitchen
Yes
Granite Slab Counters
Yes
Island
Yes
Pantry
Yes

Eating Areas

Breakfast Counter/Bar
Yes
Breakfast Nook
Yes
Formal Dining Room
Yes
Kitchen Island
Yes

Bedroom Features

All Bedrooms Down
Yes
Primary Suite
Yes
Walk In Closet
Yes

Bathroom Features

Double Vanity(s)
Yes
Linen Closet
Yes
Shower & Tub
Yes
Shower Over Tub
Yes
Tile Shower
Yes

Exterior Construction

Stone
Yes
Stucco
Yes

Flooring

Carpet
Yes
Tile
Yes

Cooling Type

Air Conditioning
Yes
Ceiling Fan(s)
Yes
Central Air
Yes
Electric
Yes

Heating

Central
Yes
Forced Air
Yes

Heating Fuel

Natural Gas
Yes

Rooms

Den - Study
Yes
Dining Room
Yes
Entry
Yes
Great Room
Yes

Interior Features

Built-In Features
Yes
High Ceilings (9 Ft+)
Yes
Open Floorplan
Yes
Recessed Lighting
Yes
Surround Sound Wired
Yes

TV Services

Cable TV
Yes

Laundry

Electric Dryer Hookup
Yes
Gas Dryer Hookup
Yes
Individual Room
Yes

Volt 220 Location

In Laundry
Yes

Security Safety

24 Hour Security
Yes
Automatic Gate
Yes
Community
Yes
Gated Community
Yes

Disability Access

No Interior Steps
Yes

Window Treatments

Custom Window Covering
Yes
Low Emissivity Windows
Yes
Screens
Yes

Roofing

Tile
Yes

Patio Features

Concrete Slab
Yes
Covered
Yes

Sewer

In, Connected and Paid
Yes

Water Heater Feature

Gas
Yes
Water Heater Unit
Yes

Parking

Driveway
Yes
Garage Door Opener
Yes
Golf Cart Garage
Yes
Side By Side
Yes

Association Amenities

Banquet Facilities
Yes
Barbecue
Yes
Billiard Room
Yes
Bocce Ball Court
Yes
Card Room
Yes
Clubhouse
Yes
Controlled Access
Yes
Elevator(s)
Yes
Fire Pit
Yes
Fitness Center
Yes
Golf Course
Yes
Lake or Pond
Yes
Maintenance Grounds
Yes
Management
Yes
Meeting Room
Yes
Pet Rules
Yes
Recreation Room
Yes
Tennis Courts
Yes

Association 1 Frequency

Monthly
Yes

Association Fees Include

Cable TV
Yes
Clubhouse
Yes
Concierge
Yes
Security
Yes

Association Pet Rules

Assoc Pet Rules
Yes
Call
Yes

Contingent Upon

Inspection
Yes

Land Lease Type

Fee Simple
Yes
Listing Office: Equity Union
Listing Agent: Donna Ambrose
Last Updated: September - 09 - 2026
Information deemed reliable but not guaranteed.

Compare listings

Compare