Request More Info
Schedule a Showing
Share
Print
|
|
Reduced again! A dramatic study in color and texture, Casa Piedra (House of Stone), with its traditional Mexican ambiance, delivers a powerful and masterful effect. Hand-painted distressed wood beamed ceilings high above wideplank flooring combined with authentic stonework delivers a tour de force second to none. Incredibly detailed. A must see. Seller's membership at Tradition Golf Club is available with the property purchase (outside of escrow) at ''better than market'' pricing as an added incentive for Buyer of this property. Furnished per inventory list.
| Last Updated | 4/30/2012 | Tract | The Tradition |
|---|---|---|---|
| Year Built | 2006 | Community | La Quinta South Of Hwy 111 |
| Garage Spaces | 4.0 | County | Riverside |
| Total Parking | 4 |
 Walk Score ®
|
14
|
Schools
| School District | Desert Sands Unified |
|---|
Price History
| Prior to Apr 17, '11 | $3,100,000 |
|---|---|
| Apr 17, '11 - Aug 23, '11 | $2,995,000 |
| Aug 23, '11 - Feb 28, '12 | $2,595,000 |
| Feb 28, '12 - Today | $2,495,000 |
Additional Details
| Appliances | Dishwasher, Dryer, Freezer, Garbage Disposal, None, Refrigerator, Washer |
|---|---|
| Association Amenities | Golf, Golf - Par 3 |
| Bath Full | 4 |
| Bath Half | 1 |
| Bath One Quarter | 0 |
| Bath Three Quarter | 0 |
| Bedroom Features | Main Floor Master Bedroom, Master Suite, WalkInCloset |
| Builders Tract Name | The Tradition |
| Building Size | 4418 |
| Building Structure Style | Hacienda, Mission, Spanish Colonial |
| CARETS Listing Status | Active |
| Carport Spaces Total | 0 |
| Common Walls | Detached/No Common Walls |
| Cooking Appliances | Built-In BBQ, Microwave |
| Cooling Type | Air Conditioning, Central A/C |
| Covered Spaces Total | 0 |
| Cross Streets | WASHINGTON 52 |
| Eating Areas | Breakfast Counter / Bar, Breakfast Nook, Dining Ell, Family Kitchen, Formal Dining Rm, In Kitchen |
| Entry Floor Number | 0 |
| Fence | Block Wall |
| Fireplace Rooms | Exterior, Great Room, Master Bedroom, Other |
| Floor Material | Hardwood |
| Foundation Details | Foundation - Concrete Slab |
| Garage Spaces Total | 4, 4 |
| Heating Type | Forced Air |
| HOAFee1 | 400.0 |
| HOAFee2 | 0.0 |
| Interior Features | Cathedral-Vaulted Ceilings |
| Land Lease Amount Per Year | 0 |
| Land Lease Type | Fee |
| Laundry Locations | Individual Room |
| Legal Disclosures | CC and R |
| Levels | One Level |
| Listing Terms | Cash, Cash To New Loan |
| ListingAgreement | Exclusive Right To Sell/Lease |
| Lot Description | Gated with Guard |
| Lot Location | Cul-De-Sac, Lake Front |
| Lot Size Source | Public Records |
| Number Of Remote Controls | 0 |
| Open Other Spaces Total | 0 |
| Other Structural Features | Barbecue Private, Custom Built |
| Other Structures | GuestHouse |
| Parking Features | Driveway, Garage Door Opener |
| Parking Spaces Total | 0 |
| Parking Type | Garage - Four Door, Garage Is Attached |
| Patio Features | Covered |
| Pool Construction | In Ground |
| Pool Descriptions | Private Pool |
| Roofing | Spanish Clay Tile |
| Rooms | Den/Ofc, Entry, Great Room |
| Security Safety | Security System - Owned or Leased |
| Sewer | Connected & Paid, In |
| Spa Construction | In Ground |
| Spa Descriptions | Private Spa |
| Sprinklers | Sprinkler Timer |
| Square Footage Source | Public Records |
| Tax Mello Roos | No |
| Tax Parcel Number | 770340035 |
| Total Floors | 0 |
| TVServices | Cable TV |
| Unit Location | Ground Flr |
| Units Total In Complex | 0 |
| View | Lake Front View, Mountain View, Panoramic View, Water View |
| Water | Water District |
| Will Consider Lease YN | N |
| Year Built Source | Assessor |
Location
Bird's Eye
Listed with Mike Leon DRE# 01411995, Traditions Properties - Onsite
Contact us about this Property
| / | |
| We respect your online privacy and will never spam you. By submitting this form with your telephone number you are consenting for HausAngeles to contact you even if your name is on a Federal or State "Do not call List". | |
The information being provided by CARETS (CLAW, CRISNet MLS, DAMLS, CRMLS, i-Tech MLS, and/or VCRDS) is for the visitor's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing.
Any information relating to a property referenced on this web site comes from the Internet Data Exchange (IDX) program of CARETS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site.
The accuracy of all information, regardless of source, including but not limited to square footages and lot sizes, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals. The data contained herein is copyrighted by CARETS, CLAW, CRISNet MLS, DAMLS, CRMLS, i-Tech MLS and/or VCRDS and is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited.
CARETS, California Real Estate Technology Services, is a consolidated MLS property listing data feed comprised of CLAW (Combined LA/Westside MLS), CRISNet MLS (Southland Regional AOR), DAMLS (Desert Area MLS), CRMLS (California Regional MLS), i-Tech MLS (Glendale AOR/Pasadena Foothills AOR) and VCRDS (Ventura County Regional Data Share).
Date last updated: 5/22/12 6:18 PM PDT
This IDX solution is (c) Diverse Solutions 2012.
Twitter
Facebook
Dwellicious
Email
