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,640,000 For Sale

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: Active
  • 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, Gas Fireplace, Fireplace Living Rm
  • Lot Size: 1.7854 acres
  • Baths: 5
  • Golf Course: Golf Course, See Community Features
  • Pool or Spa: Spa - Heated, Play Pool, Variable Speed Pump, Pool - Private, Private Only
  • View: Yes, See Property Description
  • Additional Bedroom: Mstr Bdr Walkin Clst, Separate Bdrm Exit, Othr Bdr Walkin Clst
  • 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, Street Maint, Garbage Collection
  • Bedrooms Plus: 4.00
  • Builder Name: Ajf Custom Homes, Llc
  • Community Features: Guarded Entry, Golf Course, On-Site Guard, Gated Community
  • Const - Finish: Painted, Stone, Stucco
  • Construction: Frame - Wood, Spray Foam Insulatn
  • Construction Status: Complete Spec Home
  • Cooling: Refrigeration, Programmable Thmstat, Ceiling Fan(s)
  • Cooling: HVAC SEER Rating: 14
  • Dining Area: Breakfast Bar, Formal, Eat-in Kitchen
  • Dwelling Styles: Detached
  • Energy/Green Feature: Multi-Zones, Solar Tubes
  • Exterior Features: Covered Patio(S), Built-In Bbq, Pvt Yrd(S)/Crtyrd(S), Patio
  • Exterior Stories: 1
  • Features: 9+ Flat Ceilings, Water Softener Owned, No Interior Steps, Fire Sprinklers, Drink Wtr Filter Sys, Central Vacuum
  • Fencing: Block
  • Flooring: Carpet, Tile
  • Gated Community: Guarded Entry, Golf Course, On-Site Guard, Gated Community
  • Heating: Electric Heat
  • High School Dist #: 093 - Cave Creek Unified District
  • Kitchen Features: Disposal, Range/Oven Gas, Engy Star (See Rmks), 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, Gravel/Stone Front, Auto Timer H2O Back, Auto Timer H2O Front, Synthetic Grass Back, Gravel/Stone Back, Desert Front, Desert Back, Yrd Wtring Sys Front
  • Laundry: Inside Laundry, Wshr/Dry HookUp Only
  • Master Bathroom: Double Sinks, Private Toilet Room, Separate Shwr & Tub, Full Bth Master Bdrm
  • Master Bedroom: Split
  • Parking Features: Electric Door Opener, Dir Entry Frm Garage, RV Parking, RV Gate, Side Vehicle Entry, Over Height Garage, Extnded Lngth Garage
  • Parking Spaces: Slab Parking Spaces: 8.00
  • Planned Comm Name: The Boulders
  • Plumbing: Recirculation Pump, Engy Star Ht Wtr Htr, Dual Flush Toilet, Gas Hot Water Heater
  • Property Description: Cul-De-Sac Lot, North/South Exposure, Mountain View(s)
  • 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, Pre-Wire Srnd Snd, Pre-Wire Sat Dish, Ntwrk Wrng Multi Rms, HighSpd Intrnt Aval, Cable TV Avail
  • 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