54444 Avenida Herrera, La Quinta, CA 92253

FOR SALE
  • $649,000
  • 157 Days on site
  • Est: $2,404/month
  • Mortgage Center
  • Beds: 4
  • Baths: 5 Full
  • Single Family Home
  • 2,942 sq ft
X

Description

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. Click here to learn more about this listing.

  • MLS ID# 216020184
  • Year Built: 2004
  • 157 Days on site
  • Single Family Home
  • Beds: 4
  • Baths: 5 Full

Want More Information?

Bennion Deville Homes
(760) 770-6801

* required fields

Listing Details

Kitchen
Yes
Dining Area
Yes
Family Room
Yes
Laundry Room
Dryer
Recreation
Yes
Appliances
Dishwasher, Disposal, Icemaker, Refrigerator
Flooring
Carpeted, Ceramic
Lot Features
Mountain View
Lot Size
Approximately 10018 Square Feet
Parking
Parking Space (3)
Roof
Composition Roof
Cooling
Central Air, Central Cooling
Heating
Forced Air
Assessed Taxable Amount
$506,916
Tax Amount
$6,620
Last Transaction Date
02/20/2008
Last Transaction Purchase Price
$607,750
Property Type
Single Family Residence
Bedrooms
4
Bathrooms
3
Floors
1
Home Size (Sqft)
2,942
Lot Size (Sqft)
10,019
Lot Size (Acres)
0.23
Year Built
2004
Units
1
Pool
Yes
Fireplace
Yes
Parking
Garage
Heating System
Central
Cooling System
Central Air

Public Facts: As provided by County Assessor and Recorder offices. May not reflect recent additions or improvements. If you see any errors, the best way to get the records updated is to contact your local county records office. If any of the information in this section conflicts with property information provided by a listing agent or broker, agent-provided information should be deemed more reliable.

Local Info

Population
46,519
Median Household Income
$64,982
Median Years In Residence
7
Median Homeowner Age
35
Households with Children
47.61%
Percent of Homes Rented
15.82%

Nearby Elementary Schools

77800 Calle Tampico
50800 Desert Club Dr
50800 Calle Paloma

Nearby Middle Schools

50800 Calle Paloma
78900 Avenue 50
82489 Avenue 52

Nearby High Schools

79255 Westward Ho Dr
43330 Palm Royale Dr
43330 Palm Royale Dr

These are the closest schools to your requested location. Proximity does not guarantee enrollment eligibility. Please consult your real estate agent or school district to confirm the schools you are zoned to attend.

Mortgage Rates

Loading rates...

Property Contact Info

Broker Logo
Listing Provided By: Bennion Deville Homes
(760) 770-6801
Listing Agent: Roger Joles

Need More Information?

Please fill out this form to request more photos or more information regarding this property.

We guarantee 100% privacy. Your information will not be shared with additional third parties.