Quick Search


view all


Any

Any

No Min.

No Max.



Bob Pfeiffer
Coldwell Banker
33765 N. Scottsdale Rd - Bldg A-101

Scottsdale, AZ 85266
Phone: (480) 766-0509

Email Bob

DON'T MISS A NEW LISTING AGAIN!

Register Now
Already registered? 
Login

FREE AUTOMATED EMAIL UPDATES
Sign in to take advantage of all this site has to offer. Save your favorite listings and searches – also receive email updates when listings you like come on the market for free!
*Contact Information is NOT Shared*

Back to Saved Search
Listing 25 out of 100
Open House Monday Jul 22, 9:30am–11:30am
$2,200,000 For Sale

4005 E La Ultima Piedra Road
Carefree, AZ 85377

4 beds, 5 baths | Single Family Home
4,917 sq ft; lot: 1.3827 acres - MLS# 5891031
Property Photo
1/55

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.

Open House

  • Monday Jul 22, 9:30am–11:30am

Features

  • Property Type: Single Family Home
  • Sub Type: Single Family - Detached
  • Listing Status: Active
  • County/Area: Maricopa County
  • Zip Code: 85377
  • Year Built: 2008
  • Subdivision/Neighborhood: Boulders Parcel 31 Lot 1
  • School District: 093 - Cave Creek Unified District
  • Elementary School: Black Mountain Elementary School
  • Middle School: Sonoran Trails Middle School
  • High School: Cactus Shadows High School
  • Sq.Ft.: 4,917 sq ft
  • Stories: 1
  • Bedrooms: 4
  • Full Baths: 5
  • Garage: 4-Car
  • # of Parking Spaces: 4
  • Fireplace: 2 Fireplace, Exterior Fireplace, Firepit, Fireplace Living Rm, Gas Fireplace
  • Lot Size: 1.3827 acres
  • Baths: 5
  • Golf Course: Golf Course, See Community Features
  • Open House: 07-21-2019 10:00 AM - 12:00 PM
  • Pool or Spa: Yes, See Pool Features
  • View: Yes, See Property Description
  • Additional Bedroom: Mstr Bdrm Sitting Rm, Mstr Bdr Walkin Clst, Othr Bdr Walkin Clst, Separate Bdrm Exit
  • Approx Lot SqFt: 60231.00
  • Approx SqFt Range: 4, 501 - 5, 000
  • Apx Lot Size Range: 1 - 1.9 Acres
  • Association & Fees: Ttl Mthly Fee Equiv: 191.33
  • Association Fee Incl: Common Area Maint, Garbage Collection, Street Maint
  • Bedrooms Plus: 5.00
  • Builder Name: Pinnacle Builders
  • Community Features: Community Pool Htd, Community Spa Htd, Guarded Entry, Gated Community, On-Site Guard, Golf Course
  • Const - Finish: Painted, Stucco
  • Construction: Frame - Wood
  • Cooling: Refrigeration
  • Dining Area: Breakfast Bar, Breakfast Room, Formal
  • Dwelling Styles: Detached
  • Energy/Green Feature: Multi-Zones
  • Exterior Features: Covered Patio(S), Patio, Private Street(S), Pvt Yrd(S)/Crtyrd(S), Built-In Bbq
  • Exterior Stories: 1
  • Features: 9+ Flat Ceilings, Drink Wtr Filter Sys, Fire Sprinklers, No Interior Steps, Water Softener Owned
  • Fencing: View/Wrought Iron
  • Flooring: Carpet, Stone, Wood
  • Gated Community: Community Pool Htd, Community Spa Htd, Guarded Entry, Gated Community, On-Site Guard, Golf Course
  • Heating: Gas Heat
  • High School Dist #: 093 - Cave Creek Unified District
  • Items Updated: Ht/Cool Partial/Full: Full
  • Items Updated: Ht/Cool Yr Updated: 2014
  • Kitchen Features: Disposal, Dishwasher, Refrigerator, Kitchen Island, Pantry, Cook Top Gas, Built-In Microwave, Reverse Osmosis, Wall Oven(S), Multiple Ovens, Walk-In Pantry, Granite Countertops
  • Landscaping: Yrd Wtring Sys Back, Yrd Wtring Sys Front, Desert Back, Desert Front, Auto Timer H2O Front, Auto Timer H2O Back
  • Laundry: Dryer Included, Inside Laundry, Washer Included
  • Master Bathroom: 2 Master Baths, Bidet, Double Sinks, Full Bth Master Bdrm, Separate Shwr & Tub, Tub with Jets, Private Toilet Room
  • Master Bedroom: Split
  • Miscellaneous: Home Warranty
  • Model: Custom
  • Other Rooms: Family Room, Great Room
  • Parking Features: Electric Door Opener, Extnded Lngth Garage, Side Vehicle Entry, Dir Entry Frm Garage
  • Planned Comm Name: The Boulders
  • Plumbing: Tankless Ht Wtr Heat, Gas Hot Wtr - Tnklss
  • Pool Features: Spa - Heated, Spa - Private, Heated Pool, Pool - Private, Variable Speed Pump, Both Private & Community
  • Property Description: Borders Common Area, Corner Lot, Mountain View(s), North/South Exposure
  • Roofing: Built-Up, Partial Tile, Reflective Coating
  • Separate Den/Office: Sep Den/Office Y/N: Yes
  • Services: City Services
  • Sewer: Sewer - Private
  • Source Apx Lot SqFt: County Assessor
  • Source of SqFt: County Assessor
  • Technology: Cable TV Avail, HighSpd Intrnt Aval, Security Sys Owned
  • Utilities: APS, SW Gas
  • Water: City Water
Courtesy of RE/MAX Excalibur

Bob Pfeiffer | 480-766-0509 | Contact Me
33765 N. Scottsdale Road - Bldg A-101, Scottsdale, AZ 85266
Copyright © 2017, All Rights Reserved

Real Estate Websites by iHOUSEweb iconiHOUSEweb | Admin Menu