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 6 out of 68
$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
  • New Construction: Y
  • 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, Mstr Bdr Walkin Clst, Other Bdrm Split, Othr Bdr Walkin Clst, Separate Bdrm Exit
  • 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, Garbage Collection, Street Maint
  • Bedrooms Plus: 5.00
  • Builder Name: Hd Hannah Development, Llc
  • Community Features: Community Pool Htd, Guarded Entry, Gated Community, On-Site Guard, Golf Course, Concierge, Comm Tennis Court(S), Biking/Walking Path, Clubhouse/Rec Room, Community Media Room, Workout Facility
  • Const - Finish: Painted, Stucco, Stone
  • 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), Patio, Built-In Bbq
  • Exterior Stories: 1
  • Features: 9+ Flat Ceilings, Drink Wtr Filter Sys, Fire Sprinklers, No Interior Steps, Vaulted Ceiling(s), Wet Bar(s), Water Softener Owned
  • Fencing: Block, View/Wrought Iron
  • Fireplace Features: 2 Fireplace, Exterior Fireplace, Fireplace Family Rm, Fireplace Master Bdr, Gas Fireplace, Two Way Fireplace
  • Flooring: Carpet, Stone, Tile, Wood
  • Gated Community: Community Pool Htd, Guarded Entry, Gated Community, On-Site Guard, Golf Course, Concierge, Comm Tennis Court(S), Biking/Walking Path, Clubhouse/Rec Room, Community Media Room, Workout Facility
  • Heating: Gas Heat
  • High School Dist #: 093 - Cave Creek Unified District
  • Kitchen Features: Disposal, Dishwasher, Refrigerator, Kitchen Island, Pantry, Range/Oven Gas, Cook Top Gas, Built-In Microwave, Reverse Osmosis, Wall Oven(S), Multiple Ovens, Walk-In Pantry, Granite Countertops
  • Landscaping: Yrd Wtring Sys Back, Desert Back, Desert Front, Auto Timer H2O Front, Auto Timer H2O Back, Irrigation Front, Irrigation Back
  • Laundry: Inside Laundry, Wshr/Dry HookUp Only, Gas Dryer Hookup
  • Marketing Name: The Boulders
  • Master Bathroom: 2 Master Baths, Double Sinks, Full Bth Master Bdrm, Separate Shwr & Tub, Private Toilet Room
  • Master Bedroom: Downstairs, Split
  • Model: Custom
  • Other Rooms: Family Room, Guest Qtrs-Sep Entrn, Great Room
  • Parking Features: Electric Door Opener, Golf Cart Garage, Dir Entry Frm Garage
  • Parking Spaces: Slab Parking Spaces: 2.00
  • Plumbing: Gas Hot Water Heater, Low Flow Fixtures, Gas Hot Wtr - Tnklss
  • Pool Features: Spa - Heated, Spa - Private, Heated Pool, Pool - Private, Both Private & Community
  • Property Description: Cul-De-Sac Lot, Golf Course Lot, Mountain View(s), North/South Exposure, Waterfront Lot
  • Roofing: Concrete, Foam, Partial Tile
  • 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, HighSpd Intrnt Aval, Smart Home System
  • 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