Welcome to your waterfront oasis! From the moment you arrive, you'll be captivated by the stunning curb appeal featuring two large synthetic grass areas, beautifully complemented by desert-friendly landscaping with mature cactus, palms, and trees. The freshly painted exterior is highlighted by gorgeous rock accents, giving this home a warm yet upscale presence.
Step inside to discover newly updated wood plank tile flooring that flows seamlessly throughout, paired with fresh interior paint that creates a bright and inviting atmosphere. Large windows fill the home with natural light and are enhanced with elegant vinyl shutters, while 9-foot ceilings add to the open, spacious feel.
As a former Hacienda model home, this residence offers a perfect blend of style, comfort, and thoughtful design--setting the stage for the exceptional living experience that continues throughout.
As you walk through the main hallway or pass through the elegant butler's pantry, you'll arrive at the true heart of the home--an impressive, fully remodeled kitchen, dining area, and family room highlighted by soaring 20+ foot ceilings. Expansive windows surround the space, flooding it with natural light and creating a bright, open atmosphere that's perfect for both everyday living and entertaining. The kitchen is beautifully appointed with nearly new 36" cabinetry, sleek stainless steel appliances, and an abundance of quartz countertops that provide generous workspace and gathering areas. The butler's pantry adds both function and style, offering additional cabinetry and quartz surfaces--ideal for hosting dinner parties or creating a sophisticated bar setup.
An elegant switchback staircase with iron railing and natural wood accents leads you to the second floor, where 9-foot ceilings continue the home's spacious feel and enhance airflow throughout. At the top of the stairs, you'll find a well-sized laundry room complete with a sink, countertop space, and a solar tube that fills the room with soft natural light. A nearby hallway offers additional upper and lower cabinetry with counter space--perfect for folding laundry or displaying décor.
Two generously sized secondary bedrooms are thoughtfully positioned and separated by a full bathroom. Features include dual sinks and a separate area with tub shower combo and glass enclosure. The rear-facing room offers stunning views of the lake and nearby park.
On the opposite side of the home, a fourth bedroom also enjoys peaceful lake views. Just beyond, double doors lead you into the expansive primary suite--a true retreat. Surrounded by windows that invite in natural light, the space still offers ample wall area for furnishings and design. A convenient wet bar with sink, cabinetry, and mini fridge makes it perfect for a morning coffee station or evening unwind.
The luxurious en suite bathroom is designed for relaxation, featuring separate vanities with abundant counter space and storage, a large walk-in shower with a new glass enclosure, and a beautiful garden-style soaking tub framed by windows on three sides for natural light and ventilation. The suite is completed by an oversized walk-in closet spacious enough to rival a bedroom. Step outside to your breathtaking backyard oasis. A large covered patio provides the perfect setting to relax while overlooking the infinity-edge pool that visually blends into the serene lake beyond. With additional space ready for your personal touch--whether it's an outdoor kitchen with existing gas stub, expanded seating, or synthetic turf for play--this backyard is a true extension of the home's luxury living.Store your vehicles and toys in this 3 car garage with direct access to the back yard.
Built with 2x6 construction for enhanced energy efficiency and comfort, and extensively remodeled just 2½ years ago, this home offers the feel of nearly new construction. Waterfront luxury like this is rare--and it won't last long.
Professional photos coming May 2nd
For sale
Price cut: $9.6K (7/4)
$574,900
40817 W RIO GRANDE Drive W, Maricopa, AZ 85138
4beds
2,899sqft
Single Family Residence
Built in 2007
7,176 Square Feet Lot
$-- Zestimate®
$198/sqft
$91/mo HOA
What's special
Freshly painted exteriorGorgeous rock accentsSleek stainless steel appliancesElegant vinyl shuttersBreathtaking backyard oasisStunning curb appeal
- 63 days |
- 534 |
- 53 |
Zillow last checked:
Listing updated:
Listed by:
Jesse Martinez 480-352-4516,
Realty ONE Group
Source: ARMLS,MLS#: 7020198

Loading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Heating
- Heat Pump, Forced Air, Natural Gas
Cooling
- Central Air, Ceiling Fan(s), Programmable Thmstat
Appliances
- Included: Reverse Osmosis, Built-in Microwave, Dishwasher, Disposal, Gas Range, Electric Oven, Water Purifier
- Laundry: Upper Level, Gas Dryer Hookup
Features
- Non-laminate Counter, Quartz Countertops, Double Vanity, See Remarks, Upstairs, Eat-in Kitchen, Breakfast Bar, 9+ Flat Ceilings, Wet Bar, Kitchen Island, Full Bth Master Bdrm, Separate Shwr & Tub
- Flooring: Carpet, Tile
- Windows: Skylight(s), Solar Screens, Double Pane Windows
- Has basement: No
- Has fireplace: No
Interior area
- Total structure area: 2,899
- Total interior livable area: 2,899 sqft
Property
Parking
- Total spaces: 5
- Parking features: Tandem Garage, Garage Door Opener, Direct Access
- Garage spaces: 3
- Uncovered spaces: 2
Features
- Stories: 2
- Patio & porch: Covered
- Has private pool: Yes
- Pool features: Outdoor Pool, Play Pool
- Spa features: None
- Fencing: Block,Wrought Iron
- Has view: Yes
- View description: Lake, Mountain(s)
- Has water view: Yes
- Water view: Lake
- Waterfront features: Waterfront
Lot
- Size: 7,176 Square Feet
- Features: North/South Exposure, Waterfront, Sprinklers In Rear, Sprinklers In Front, Desert Back, Desert Front, Gravel/Stone Front, Gravel/Stone Back, Synthetic Grass Frnt, Auto Timer H2O Front, Auto Timer H2O Back, Irrigation Front, Irrigation Back
Details
- Parcel number: 51245578
- Special conditions: Owner/Agent
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Other
- Property subtype: Single Family Residence
Materials
- Stucco, Wood Frame, Blown Cellulose, Painted, Stone
- Foundation: Slab
- Roof: Tile
Condition
- Year built: 2007
Details
- Builder name: Hacienda
Utilities & green energy
- Sewer: Public Sewer
- Water: Pvt Water Company
Green energy
- Energy efficient items: Solar Tubes, Multi-Zones
Community & HOA
Community
- Features: Lake, Playground, Biking/Walking Path
- Security: Security System Owned
- Subdivision: RANCHO EL DORADO PHASE III PARCEL 37
HOA
- Has HOA: Yes
- Services included: Maintenance Grounds
- HOA fee: $91 monthly
- HOA name: The Lakes @ RED
- HOA phone: 480-417-2514
Location
- Region: Maricopa
Financial & listing details
- Price per square foot: $198/sqft
- Tax assessed value: $414,482
- Annual tax amount: $3,534
- Date on market: 5/1/2026
- Cumulative days on market: 63 days
- Listing terms: Cash,Conventional,1031 Exchange,FHA,VA Loan
- Ownership: Fee Simple
- Road surface type: Asphalt
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 7/4/2026 | Price change | $574,900-1.6%$198/sqft |
Source: | ||
| 5/8/2026 | Price change | $584,500-3.3%$202/sqft |
Source: | ||
| 5/1/2026 | Listed for sale | $604,500+2.6%$209/sqft |
Source: | ||
| 12/20/2024 | Listing removed | $589,450$203/sqft |
Source: | ||
| 11/23/2024 | Price change | $589,450-1.7%$203/sqft |
Source: | ||
| 10/20/2024 | Listed for sale | $599,900+50%$207/sqft |
Source: | ||
| 10/14/2024 | Listing removed | $2,600$1/sqft |
Source: Zillow Rentals Report a problem | ||
| 12/21/2023 | Listing removed | -- |
Source: Zillow Rentals Report a problem | ||
| 12/10/2023 | Price change | $2,600-5.5%$1/sqft |
Source: Zillow Rentals Report a problem | ||
| 11/27/2023 | Price change | $2,750-5.2%$1/sqft |
Source: Zillow Rentals Report a problem | ||
| 11/22/2023 | Listed for rent | $2,900$1/sqft |
Source: Zillow Rentals Report a problem | ||
| 11/15/2023 | Sold | $400,000$138/sqft |
Source: | ||
| 2/17/2023 | Pending sale | $400,000$138/sqft |
Source: | ||
| 2/9/2023 | Listed for sale | $400,000+3.2%$138/sqft |
Source: | ||
| 9/23/2020 | Sold | $387,500+68.5%$134/sqft |
Source: | ||
| 12/30/2009 | Sold | $230,000$79/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | $3,534 -2.2% | $41,447 +2.6% |
| 2025 | $3,614 +29.6% | $40,392 -12.9% |
| 2024 | $2,789 +2.9% | $46,348 +20.5% |
| 2023 | $2,709 +4.7% | $38,467 -6.3% |
| 2022 | $2,586 +4.8% | $41,047 +7.6% |
| 2021 | $2,469 +4% | $38,160 +21.7% |
| 2020 | $2,374 +1.3% | $31,344 +62.2% |
| 2019 | $2,343 +5% | $19,323 +12.4% |
| 2018 | $2,232 +11.1% | $17,187 -1.7% |
| 2017 | $2,009 +4% | $17,476 |
| 2016 | $1,933 -0.6% | -- |
| 2014 | $1,944 | $12,787 |
| 2013 | -- | -- |
| 2012 | -- | -- |
| 2011 | -- | $12,302 -16.5% |
| 2010 | -- | $14,737 |
| 2009 | -- | -- |
Find assessor info on the county website
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: Rancho el Dorado
Nearby schools
GreatSchools rating
- 5/10Santa Rosa Elementary SchoolGrades: PK-6Distance: 1.3 mi
- 4/10Maricopa High SchoolGrades: 6-12Distance: 3 mi
- 2/10Desert Wind Middle SchoolGrades: 6-8Distance: 3.7 mi
Schools provided by the listing agent
- Elementary: Maricopa Elementary School
- Middle: Maricopa Elementary School
- High: Maricopa High School
- District: Maricopa Unified School District
Source: ARMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
- Arizona
- Pinal County
- Maricopa
- 85138
- Rancho el Dorado
- 40817 W RIO GRANDE Drive W







