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 10 out of 101
$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/56

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.

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, Gas Fireplace, Fireplace Living Rm, Firepit, Exterior Fireplace
  • Lot Size: 1.3827 acres
  • Baths: 5
  • Golf Course: Golf Course, See Community Features
  • Open House: 03-22-2019 1:30 PM - 3:30 PM
  • Pool or Spa: Yes, See Pool Features
  • View: Yes, See Property Description
  • Additional Bedroom: Mstr Bdrm Sitting Rm, Separate Bdrm Exit, Othr Bdr Walkin Clst, Mstr Bdr Walkin Clst
  • 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, Street Maint, Garbage Collection
  • Bedrooms Plus: 5.00
  • Builder Name: Pinnacle Builders
  • Community Features: Community Pool Htd, Guarded Entry, Golf Course, On-Site Guard, Gated Community, Community Spa Htd
  • Const - Finish: Painted, Stucco
  • Construction: Frame - Wood
  • Cooling: Refrigeration
  • Dining Area: Breakfast Bar, Formal, Breakfast Room
  • Dwelling Styles: Detached
  • Energy/Green Feature: Multi-Zones
  • Exterior Features: Covered Patio(S), Built-In Bbq, Pvt Yrd(S)/Crtyrd(S), Private Street(S), Patio
  • Exterior Stories: 1
  • Features: 9+ Flat Ceilings, Water Softener Owned, No Interior Steps, Fire Sprinklers, Drink Wtr Filter Sys
  • Fencing: View/Wrought Iron
  • Flooring: Carpet, Wood, Stone
  • Gated Community: Community Pool Htd, Guarded Entry, Golf Course, On-Site Guard, Gated Community, Community Spa Htd
  • 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, Cook Top Gas, Granite Countertops, Walk-In Pantry, Multiple Ovens, Wall Oven(S), Reverse Osmosis, Built-In Microwave, Pantry, Kitchen Island, Refrigerator, Dishwasher
  • Landscaping: Yrd Wtring Sys Back, Auto Timer H2O Front, Auto Timer H2O Back, Desert Back, Desert Front, Yrd Wtring Sys Front
  • Laundry: Dryer Included, Washer Included, Inside Laundry
  • Master Bathroom: 2 Master Baths, Private Toilet Room, Tub with Jets, Separate Shwr & Tub, Full Bth Master Bdrm, Double Sinks, Bidet
  • Master Bedroom: Split
  • Miscellaneous: Home Warranty
  • Model: Custom
  • Other Rooms: Family Room, Great Room
  • Parking Features: Electric Door Opener, Dir Entry Frm Garage, Side Vehicle Entry, Extnded Lngth Garage
  • Planned Comm Name: The Boulders
  • Plumbing: Tankless Ht Wtr Heat, Gas Hot Wtr - Tnklss
  • Pool Features: Spa - Heated, Spa - Private, Heated Pool, Variable Speed Pump, Pool - Private, Both Private & Community
  • Property Description: Borders Common Area, North/South Exposure, Mountain View(s), Corner Lot
  • Roofing: Built-Up, Reflective Coating, Partial Tile
  • 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, Security Sys Owned, HighSpd Intrnt Aval
  • 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