Property
Beds
4
Full Baths
2
1/2 Baths
None
Year Built
2007
Sq.Footage
2,789
Luxury and Natural Beauty! A rare Trilogy at La Quinta grand pool retreat. Whether for personal enjoyment or as an investment, this Mesquite 2,789 SQ FT model home rests on a large 12,632 SQ FT lot, with 4 bedrooms (one a massive primary retreat, detached and attached Casitas, both with baths, have access to the center courtyard, and an additional separate guest bedroom and full bath), a gourmet kitchen, office, formal dining room, multiple covered outdoor patios, two garages that combined fit three full-sized cars. Hidden from the street behind a stand-alone stone entry and large wooden door is a wonderland of extraordinary amenities, the perfect property to live, entertain and enjoy with family and friends. Once behind the door, you arrive at a large courtyard and a beautifully crafted pergola covering a raised stone firepit, large outdoor big screen TV, and plenty of seating for hosting unforgettable gatherings. On warm days, the Cool Fog misting system envelops much of the home's exterior in a fine mist that cools the temperature by as much as 15 degrees. Adjacent to the courtyard and surrounded by exquisite Phoenix Roebelenii palms and brilliant tropical flora, is a spectacular resort-style Pebble-Tec salt water pool, with towering rock waterfalls cascading over three-tiers into the spa and pool below. At the far end of the pool is a raised deck from which to take in the calming views of the pool and gardens. Pathways meander throughout the entire property that lead to several recreational areas, including, a play area of artificial turf under an umbrella of trees, a three-hole putting green, a sunken professional barbecue station with dining counters, multiple covered patios, and an area for growing fresh vegetables, fruit, and herbs. Inside, the home is open with ten-foot ceilings, crown molding, tile floors in the main living areas. The great room has a built-in media center with surround sound speakers in the ceiling. The gas-log fireplace keeps you warm while streaming your favorite shows on cool winter nights. The kitchen is outfitted premium stainless steel appliances, six-burner cooktop, double-oven, and dishwasher. A center island with pendant lighting, abundant cabinetry, built-in pantry, smooth granite slab countertops and stone backsplash, make cooking easy and convenient.
Features & Amenities
Interior
-
Other Interior Features
Breakfast Bar, Built-in Features, Crown Molding, High Ceilings, Recessed Lighting, Walk-In Closet(s)
-
Total Bedrooms
4
-
Bathrooms
2
-
Cooling YN
YES
-
Cooling
Central Air, Electric
-
Fireplace YN
YES
-
Heating YN
YES
-
Heating
Central, Forced Air, Fireplace(s), Natural Gas
-
Pet friendly
N/A
Exterior
-
Garage
Yes
-
Garage spaces
3
-
Construction Materials
Stucco
-
Other Exterior Features
Barbecue, Fire Pit
-
Parking
Attached, Driveway, Golf Cart Garage, Oversized, Side By Side
-
Patio and Porch Features
Covered
-
Pool
Yes
-
Pool Features
Private, Electric Heat, In Ground, Salt Water, Waterfall
Area & Lot
-
Lot Features
Back Yard, Front Yard, Irregular Lot, Landscaped, Level
-
Lot Size(acres)
0.29
-
Property Type
Residential
-
Property Sub Type
Single Family Residence
Price
-
Sales Price
$1,295,000
-
Sq. Footage
2, 789
-
Price/SqFt
$464
HOA
-
Association
YES
-
Association Fee
$595
-
Association Fee Frequency
Monthly
-
Association Fee Includes
N/A
School District
-
Elementary School
N/A
-
Middle School
N/A
-
High School
N/A
Property Features
-
Stories
1
-
Association Amenities
Billiard Room, Clubhouse, Fitness Center, Golf Course, Maintenance Grounds, Game Room, Meeting Room, Management, Barbecue, Recreation Room, Security, Tennis Court(s), Cable TV
-
Senior Community YN
YES
Schedule a Showing
Showing scheduled successfully.
Mortgage calculator
Estimate your monthly mortgage payment, including the principal and interest, property taxes, and HOA. Adjust the values to generate a more accurate rate.
Your payment
Principal and Interest:
$
Property taxes:
$
HOA fees:
$
Total loan payment:
$
Total interest amount:
$
Location
County
Riverside
Elementary School
Middle School
High School
Listing Courtesy of Donna Ambrose , Equity Union
RealHub Information is provided exclusively for consumers' personal, non-commercial use, and it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. RealHub website owner shall not be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless.

FOUNDER
LinaMirza
Call Lina today to schedule a private showing.

* Listings on this website come from the FMLS IDX Compilation and may be held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request.© 2024 FMLS.
