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 13 out of 75
$1,595,000 UCB (Under Contract-Backups)

4012 La Ultima Piedra
Carefree, AZ 85377

4 beds, 4 full, 1 partial baths | Single Family Home
4,041 sq ft; lot: 1.7854 acres - MLS# 5845733
Property Photo
1/47

Description

Amazing mountain views from this new custom home with N/S exposure on 1.77 acres at end of cut-de-sac. The winding paver driveway leads to large paver entry courtyard with gas fire pit. Enter through custom entry door to great room with telescoping glass doors opening to beautifully landscaped back yard with pool, spa, synthetic turf lawn, built in BBQ, and incredible mountain views. Entertainers kitchen with custom cabinets, extra large island, granite counters, Sub Zero and Wolf appliances. Tile plank floors except for upgraded carpet and pads in bedrooms. Large master bath with floor to ceiling glass shower and huge closet with custom cabinets. Extra large 4 car garage with epoxy floor. Too many other upgrades to list here so come see this unique new build in The Boulders!

Features

  • Property Type: Single Family Home
  • Sub Type: Single Family - Detached
  • Listing Status: UCB (Under Contract-Backups)
  • County/Area: Maricopa County
  • Zip Code: 85377
  • Year Built: 2018
  • Subdivision/Neighborhood: Boulders Parcel 31
  • 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,041 sq ft
  • Stories: 1
  • Bedrooms: 4
  • Full Baths: 4
  • Half Baths: 1
  • Garage: 4-Car
  • # of Parking Spaces: 4
  • Fireplace: Firepit, Fireplace Living Rm, Gas Fireplace
  • Lot Size: 1.7854 acres
  • Baths: 5
  • Golf Course: Golf Course, See Community Features
  • Pool or Spa: Spa - Heated, Play Pool, Pool - Private, Variable Speed Pump, Private Only
  • View: Yes, See Property Description
  • Additional Bedroom: Mstr Bdr Walkin Clst, Othr Bdr Walkin Clst, Separate Bdrm Exit
  • Approx Lot SqFt: 77771.00
  • Approx SqFt Range: 4, 001 - 4, 500
  • Apx Lot Size Range: 1 - 1.9 Acres
  • Association & Fees: Ttl Mthly Fee Equiv: 165.00
  • Association Fee Incl: Common Area Maint, Garbage Collection, Street Maint
  • Bedrooms Plus: 4.00
  • Builder Name: Ajf Custom Homes, Llc
  • Community Features: Guarded Entry, Gated Community, On-Site Guard, Golf Course
  • Const - Finish: Painted, Stucco, Stone
  • Construction: Frame - Wood, Spray Foam Insulatn
  • Construction Status: Complete Spec Home
  • Cooling: Refrigeration, Ceiling Fan(s), Programmable Thmstat
  • Cooling: HVAC SEER Rating: 14
  • Dining Area: Breakfast Bar, Eat-in Kitchen, Formal
  • Dwelling Styles: Detached
  • Energy/Green Feature: Multi-Zones, Solar Tubes
  • Exterior Features: Covered Patio(S), Patio, Pvt Yrd(S)/Crtyrd(S), Built-In Bbq
  • Exterior Stories: 1
  • Features: 9+ Flat Ceilings, Central Vacuum, Drink Wtr Filter Sys, Fire Sprinklers, No Interior Steps, Water Softener Owned
  • Fencing: Block
  • Flooring: Carpet, Tile
  • Gated Community: Guarded Entry, Gated Community, On-Site Guard, Golf Course
  • Heating: Electric Heat
  • High School Dist #: 093 - Cave Creek Unified District
  • Kitchen Features: Disposal, Dishwasher, Refrigerator, Kitchen Island, Pantry, Range/Oven Gas, Built-In Microwave, Reverse Osmosis, Wall Oven(S), Multiple Ovens, Walk-In Pantry, Granite Countertops, Engy Star (See Rmks)
  • Landscaping: Yrd Wtring Sys Back, Yrd Wtring Sys Front, Desert Back, Desert Front, Gravel/Stone Front, Gravel/Stone Back, Synthetic Grass Back, Auto Timer H2O Front, Auto Timer H2O Back
  • Laundry: Inside Laundry, Wshr/Dry HookUp Only
  • Master Bathroom: Double Sinks, Full Bth Master Bdrm, Separate Shwr & Tub, Private Toilet Room
  • Master Bedroom: Split
  • Parking Features: Electric Door Opener, Extnded Lngth Garage, Over Height Garage, Side Vehicle Entry, RV Gate, RV Parking, Dir Entry Frm Garage
  • Parking Spaces: Slab Parking Spaces: 8.00
  • Planned Comm Name: The Boulders
  • Plumbing: Recirculation Pump, Gas Hot Water Heater, Dual Flush Toilet, Engy Star Ht Wtr Htr
  • Property Description: Cul-De-Sac Lot, Mountain View(s), North/South Exposure
  • Roofing: Foam, Partial Tile
  • Services: City Services
  • Sewer: Sewer - Public
  • Source Apx Lot SqFt: County Assessor
  • Source of SqFt: Builder
  • Technology: 3+ Exist Tele Lines, Cable TV Avail, HighSpd Intrnt Aval, Ntwrk Wrng Multi Rms, Pre-Wire Sat Dish, Pre-Wire Srnd Snd
  • UCB or CCBS: UCB (Under Contract-Backups)
  • Utilities: APS, SW Gas
  • Water: City Water
  • Windows: Dual Pane, Low-E
Courtesy of Coldwell Banker Residential Brokerage

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