54444 Avenida Herrera
La Quinta, CA 92253


Beds: 4
Baths: 5
Sq. Ft.: 2,942
Type: Single Family Home
1 / 1
Listing #216020184
LUXURIOUS Custom Pool Home! This Spectacular Private entertainers delight features: 4 Bedrooms, 5 bathrooms, separate casita with private entrance, formal living, dining, family room w/sunken large bar. Completely turnkey furnished with all the amenities you would be looking for in an upscale custom home. Completely enclosed by a block wall can only be entered through the driveways remote/panel controlled electronic gate or front walkway gate. As you enter the private property, you will find the main outdoor entertainment area. There is a built in BBQ with covered seating, a sparkling saltwater pool with waterfalls and a spa, a gazebo with a lounge bed, and a Fire & Ice fire pit, all which is encompassed by lush tropical landscaping and putting green in back. Gourmet kitchen with granite counter tops and Viking appliances! This home is nothing short of phenomenal! Perfect Vacation rental or personal residence close to all shopping, restaurants, hiking trails and golf courses.
Property Features
Location Information
County: Riverside
MLS Area: La Quinta South of H
Latitude: 33.653034
Longitude: -116.309532
Property Location: Riverside
Subdivision: La Quinta Cove
Directions: Washington, to R on Avenue 52, L on Avenida Bermudas, R on Avenida Madrid, go across Eisenhower (traffic does not stop here), L on Avenida Herrera to address on L, almost at end of Cove.
Interior Features
Has Dining Room: yes
Dining Room Description: Eat In Kitchen, Formal Dining Rm
Has Family Room: yes
Has Fireplace: yes
Fireplace Features: Raised Hearth
Exterior Features
Style: Contemporary
Stories: One Level/Story
Has Garage: yes
Garage Spaces: 3
Has a Pool: yes
Pool Description: Pool-Heated/Gas
Lot Size in Acres: 0.23
Lot Size in Sq. Ft.: 10, 019
Has View: yes
Is One Story: yes
School District: Desert Sands USD
Additional Information
Land Lease Amount (Annual): 0.00
Land Lease Exp (Year): 0
Property Type: SFR
Property SubType: Single Family Detach
Year Built: 2004
APN: 774251028
Status: Active
HOA Fee: 0

$ per month
Year Fixed. % Interest Rate.
Principal + Interest: $
Monthly Tax: $
Monthly Insurance: $
Interest Rate
Down Payment
List Price:
Based on a fully amortized fixed rate loan. Ask your agent for the tax rates in your area. Insurance estimate is based on an average cost, your final premium cost will be determined by the type of coverage you select. This program only provides an estimate.
This listing is courtesy of Roger Joles Bennion Deville Homes
©2017 Desert Area MLS (DAMLS)®. All Rights Reserved.
IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All data is deemed reliable but is not guaranteed accurate. Source MLSs include Desert Area MLS (DAMLS).
DAMLS data last updated at November 23, 2017 4:06 PM PT