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 20 out of 73
$3,200,000 For Sale

4009 E La Ultima Piedra
Carefree, AZ 85377

4 beds, 4 full, 1 partial baths | Single Family Home
5,491 sq ft; lot: 1.9763 acres - MLS# 5829484
Property Photo
1/6

Description

CONSTRUCTION STARTING SOON! Spectacular Custom Designed Warm Contemporary With Lake Frontage. Lake, Tee to Green Unobstructed Golf Course & Mountain Views.Open, But Defined Floor Plan. Truly Custom Quality Materials & Finishes. 3 En Suite Bedrooms plus Executive Office or 4th En Suite Bedroom. Indoor and Outdoor Fireplaces, Viking Appliances, Wet Bar, Wine Storage. Hardwood Flooring In All Open Areas, Wool Carpet or Tile in Bedrooms. Tiled Laundry Room and Baths. Fully Landscaped With Infinity Edge Pool/Spa. Indoor and Outdoor Fireplaces/Pits. Four Car Garage. Optional Guest House or Additional Garage Space Available. Plans & Design Materials Available For Review.

Features

  • Property Type: Single Family Home
  • Sub Type: Single Family - Detached
  • Listing Status: Active
  • County/Area: Maricopa County
  • Zip Code: 85377
  • Year Built: 2019
  • Subdivision/Neighborhood: The Boulders
  • 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.: 5,491 sq ft
  • Style: Contemporary
  • Stories: 1
  • Bedrooms: 4
  • Full Baths: 4
  • Half Baths: 1
  • Garage: 4-Car
  • # of Parking Spaces: 4
  • Fireplace: Yes, See Fireplace Features
  • Lot Size: 1.9763 acres
  • Baths: 5
  • Golf Course: Golf Course, See Community Features
  • Pool or Spa: Yes, See Pool Features
  • View: Yes, See Property Description
  • Waterfront: Yes, See Property Description
  • Additional Bedroom: 2 Master Bdrms, Separate Bdrm Exit, Othr Bdr Walkin Clst, Other Bdrm Split, Mstr Bdr Walkin Clst
  • Approx Lot SqFt: 86087.00
  • Approx SqFt Range: 5, 001+
  • 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: 5.00
  • Builder Name: Hd Hannah Development, Llc
  • Community Features: Community Pool Htd, Community Media Room, Workout Facility, Guarded Entry, Clubhouse/Rec Room, Biking/Walking Path, Comm Tennis Court(S), Concierge, Golf Course, On-Site Guard, Gated Community
  • Const - Finish: Painted, Stone, Stucco
  • Construction: Frame - Metal
  • Construction Status: Complete Spec Home, To Be Built
  • Cooling: Programmable Thmstat
  • Cooling: HVAC SEER Rating: 14
  • Dining Area: Breakfast Bar, Formal
  • Dwelling Styles: Detached
  • Energy/Green Feature: Multi-Zones
  • Exterior Features: Covered Patio(S), Built-In Bbq, Patio
  • Exterior Stories: 1
  • Features: 9+ Flat Ceilings, Water Softener Owned, Wet Bar(s), Vaulted Ceiling(s), No Interior Steps, Fire Sprinklers, Drink Wtr Filter Sys
  • Fencing: Block, View/Wrought Iron
  • Fireplace Features: 2 Fireplace, Two Way Fireplace, Gas Fireplace, Fireplace Master Bdr, Fireplace Family Rm, Exterior Fireplace
  • Flooring: Carpet, Wood, Tile, Stone
  • Gated Community: Community Pool Htd, Community Media Room, Workout Facility, Guarded Entry, Clubhouse/Rec Room, Biking/Walking Path, Comm Tennis Court(S), Concierge, Golf Course, On-Site Guard, Gated Community
  • Heating: Gas Heat
  • High School Dist #: 093 - Cave Creek Unified District
  • Kitchen Features: Disposal, Range/Oven Gas, Granite Countertops, Walk-In Pantry, Multiple Ovens, Wall Oven(S), Reverse Osmosis, Built-In Microwave, Cook Top Gas, Pantry, Kitchen Island, Refrigerator, Dishwasher
  • Landscaping: Yrd Wtring Sys Back, Auto Timer H2O Front, Irrigation Back, Irrigation Front, Auto Timer H2O Back, Desert Back, Desert Front
  • Laundry: Inside Laundry, Gas Dryer Hookup, Wshr/Dry HookUp Only
  • Marketing Name: The Boulders
  • Master Bathroom: 2 Master Baths, Private Toilet Room, Separate Shwr & Tub, Full Bth Master Bdrm, Double Sinks
  • Master Bedroom: Downstairs, Split
  • Model: Custom
  • Other Rooms: Family Room, Great Room, Guest Qtrs-Sep Entrn
  • Parking Features: Electric Door Opener, Dir Entry Frm Garage, Golf Cart Garage
  • Parking Spaces: Slab Parking Spaces: 2.00
  • Plumbing: Gas Hot Water Heater, Gas Hot Wtr - Tnklss, Low Flow Fixtures
  • Pool Features: Spa - Heated, Spa - Private, Heated Pool, Pool - Private, Both Private & Community
  • Property Description: Cul-De-Sac Lot, Waterfront Lot, North/South Exposure, Mountain View(s), Golf Course Lot
  • Roofing: Concrete, Partial Tile, Foam
  • Separate Den/Office: Sep Den/Office Y/N: Yes
  • Sewer: Sewer - Private, Sewer in & Cnctd
  • Source Apx Lot SqFt: County Assessor
  • Source of SqFt: Architect
  • Technology: Cable TV Avail, Smart Home System, HighSpd Intrnt Aval
  • Unit Style: All on One Level
  • Utilities: APS, SW Gas
  • Water: City Water
  • Windows: Dual Pane, Low-E
Courtesy of Russ Lyon Sotheby's International Realty

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