4005 E LA ULTIMA PIEDRA Road, Carefree, AZ 85377

$1,995,000
Property Type: Residential Bedrooms: 4 Baths: 5 Square Footage: 4,917 Lot Size (sq. ft.): 60,231 Status: Closed
Current Price: $1,995,000 Last Modified: 9/08/2026

Overview

Description

Single level custom home built in 2008. Elegant, spacious, modern design on an estate size lot (1.38 acre). 4 full bedroom suites w/ new carpet, walk-in closets and private baths. Expansive great room w/ cantera stone gas fireplace, family room w/ new, rich hardwood floors, formal dining room & butler pantry. Gourmet kitchen w/ alder cabs, granite counters, Viking appliances, & island. Travertine floors. Master bd features a sitting room, 2 huge walk-in closets. Indoor-outdoor living at its best w/ glass doors to the gated front courtyard w/ gas fireplace, mtn views and remarkable sunsets & glass doors to a PRIVATE resort backyard w/ pool, spa, custom firepit, & BBQ. Paver driveway, large 4 car garage, lush desert landscaping, custom night lighting. HVAC replaced w/ Trane system in 2014.

Listing Details MLS# 5891031

Location, Tax & Legal

Map Code/Grid
G37
House Number
4005
Compass
E
Street Name
LA ULTIMA PIEDRA
St Suffix
Road
City/Town Code
Carefree
State/Province
AZ
Zip Code
85377
Country
US
County Code
Maricopa
Assessor Number
216-33-806
Subdivision
BOULDERS PARCEL 31 Lot 1
Tax Year
2018

Contract Information

Type
Exclusive Right To Sell
Ownership
Fee Simple

General Property Description

Dwelling Type
Single Family Residence
Dwelling Styles
Detached
Exterior Stories
Yes
# of Interior Levels
Yes
# Bedrooms
4
Total Bathrooms
5
Approx SQFT
4917
Price/SqFt
405.73
Horses
N
Model
Custom
Builder Name
Pinnacle Builders
Year Built
2008
Approx Lot SqFt
60231
Community Pool Y/N
Yes
Private Pool Y/N
Yes
Fireplace YN
Yes
Fireplaces Total
2
Planned Comm Name
The Boulders
Marketing Name
La Ultima Piedra
Elementary School District
Cave Creek Unified District
High School District
Cave Creek Unified District
Elementary School
Black Mountain Elementary School
Jr. High School
Sonoran Trails Middle School
High School
Cactus Shadows High School

Remarks Misc

Cross Street
Tom Darlington & Carefree Hwy
Directions
N. on Tom Darlington to the Boulders Resort guard gate on rt. Proceed to Boulder Pass turn left to stop sign at Boulder Drive turn right and follow to La Ultima Piedras and turn left.

Status Change Info

Off Market Date
2019-12-25
Under Contract Date
2019-11-29
Close of Escrow Date
2019-12-27

Legal Info

Township
5N
Range
4E
Section
2
Lot Number
Yes

More Information

Basement

Basement Y/N
N

Items Updated

Ht/Cool Yr Updated
2014
Ht/Cool Partial/Full
Full

Parking Spaces

Garage Spaces
4
Total Covered Spaces
4

Miscellaneous

Home Warranty
Yes

Contact Info

List Agent Home Phn
602-908-9155

Sold Info

Loan Type
Cash
Payment Type
Other
Closing Cost Split
Normal - N
Buyer Concession $/%
$
Seller Concession $/%
$

Property Features

Special Listing Cond: N/A View: Mountain(s) Master Bathroom: Full Bth Master Bdrm; Separate Shwr & Tub; Double Vanity; Private Toilet Room; 2 Master Baths; Tub with Jets; Bidet Master Bedroom: Split Additional Bedroom: Separate Bedroom Exit; Master Bedroom Walk-in Closet; Other Bedroom Walk-in Closet; Master Bedroom Sitting Room Fireplace Features: Fireplace Living Rm; Gas Fireplace; Exterior Fireplace; Fire Pit Flooring: Carpet; Stone; Wood Private Pool Features: Heated; Variable Speed Pump Community Pool Features: Heated Spa: Private; Heated Community Features: Community Spa Htd; Gated; Golf; Guarded Entry; On-Site Guard Dining Area: Formal; Breakfast Bar; Breakfast Room Kitchen Features: Gas Cooktop; Disposal; Dishwasher; Built-in Microwave; Refrigerator; Reverse Osmosis; Wall Oven(s); Multiple Ovens; Pantry; Walk-in Pantry; Granite Counters; Kitchen Island Laundry: Washer Included; Dryer Included; Inside Other Rooms: Family Room; Great Room Interior Features: 9+ Flat Ceilings; Fire Sprinkler System; No Interior Steps; Water Softener Owned; Water Purifier Technology: Cable TV Avail; High Speed Internet; Security System Owned Exterior Features: Built-in BBQ; Covered Patio(s); Patio; Private Street(s); Pvt Yrd(s)/Crtyrd(s) Parking Features: Direct Access; Extended Length Garage; Garage Door Opener; Side Vehicle Entry Construction: Wood Frame Const - Finish: Painted; Stucco Roofing: Built-Up; Tile; Reflective Coating Cooling: Central Air Heating: Natural Gas Plumbing: Tankless Ht Wtr Heat; Gas Hot Wtr – Tnklss Utilities: APS; SW Gas Water Source: City Water Sewer: Sewer - Private Services: City Services Fencing: Wrought Iron Property Description: Corner Lot; North/South Exposure; Borders Common Area Landscaping: Desert Front; Desert Back; Yrd Wtring Sys Front; Yrd Wtring Sys Back; Auto Timer H2O Front; Auto Timer H2O Back Showing Notification Methods: Phone Call Lockbox Type: None Possession: Close of Escrow Association Fee Incl: Garbage Collection; Common Area Maint; Street Maint Existing 1st Loan: Treat as Free&Clear Existing 1st Loan Terms: Non Assumable New Financing: Cash; Conventional Disclosures: Seller Discl Avail; Agency Discl Req
IDX
Listing Office: RE/MAX Excalibur
Office Phone: 480-850-5000
Office Email: azgreenacre@gmail.com
Last Updated: September - 08 - 2026
Copyright 2026 Arizona Regional Multiple Listing Service, Inc. All rights reserved. Information Not Guaranteed and Must Be Confirmed by End User. Site contains live data.

Connect With Our Financial Experts

Let's have a chat