4009 E LA ULTIMA PIEDRA -- $2,750,000

    Close

    4009 E LA ULTIMA PIEDRA -- Carefree, AZ 85377

    • 4 Beds
    • 5 Baths
    • 4,750 sq.ft.
    • Single Family
    MLS# 5829484 | Active
    Days On Market: 320 18 Views
    Add to Favorites Share

    Go Tour This Home

    Schedule A Showing

    Property Details

    CONSTRUCTION STARTING SOON By Luxury Bordeaux Builders! Floor Plan Offers Flexible Size Options 4500-5500 SF With Pre-Construction Deposit. Spectacular Custom Warm Contemporary With Lake Frontage. Tee to Green 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, Dacor or Signature Appliances, Optional Wet Bar, Wine Storage & Outdoor Kitchen. Hardwood Flooring In All Open Areas, Wool Carpet or Tile in Bedrooms. Tiled Laundry Room and Baths. Fully Landscaped With Pool/Spa. Optional Infinity Edge. Indoor & Outdoor Fireplaces/Pits. Three Car Garage. Optional Guest House or Additional Garage Space Available. Optional Screened Patio .

    • General Features
      • Assessor Book # 216.00
      • Assessor Map # 33.00
      • Assessor Number 216-33-816
      • Assessor Parcel # 816.00
      • Association & Fees: Cap Improvement Impact Fee no
      • Association & Fees: HOA Fee 495.00
      • Association & Fees: HOA Fee Frequency Quarterly
      • Association & Fees: HOA Name CCMC
      • Association & Fees: HOA Telephone 480-488-7526
      • Association & Fees: HOA Transfer Fee 400.00
      • Association & Fees: HOA Y/N Y
      • Association & Fees: Land Lease Fee Y/N N
      • Association & Fees: PAD Fee Y/N N
      • Association & Fees: Rec Center Fee Y/N N
      • Association & Fees: Title Monthly Fee Equivalent 165.00
      • Association Fee Includes Common Area Maint, Garbage Collection, Street Maint
      • Association Rules Club, Membership Opt,Pets OK (See Rmrks),Prof Managed
      • Bathrooms 4.50
      • Bedrooms 4
      • County Maricopa
      • Covered Parking Spcs 4.00
      • Cross Street Carefree Highway and Tom Darlington/Scottsdale Rd
      • Directions North on Scottsdale Rd past Carefree Highway to The Boulders Resort Guard Gate. First Left on Boulder Pass, Right on North Boulders Drive, Left on La Ultima Piedra.Lake Lot at the end of Cul de Sac.
      • Dwelling Type Single Family - Detached
      • List Date 2018-10-05
      • Marketing Name The Boulders
      • Model CUSTOM
      • New Financing Cash, Conventional
      • Special Listing Conditions N/A
      • Subdivision The Boulders
      • Tax Municipality Carefree
      • Tax Year 2018
      • Taxes $3,438
      • Type ER
      • Uncvrd Parking Spcs 0.00
      • Year Built 2020
    • Building Features
      • Approx SqFt 4750.00
      • Approx SqFt Range 5001+
      • Architecture Contemporary
      • Basement Y/N N
      • Bedrooms Plus 5.00
      • Const - Finish Painted, Stucco, Stone
      • Construction Frame - Metal
      • Construction Status Complete Spec Home, To Be Built
      • Exterior Stories 1
      • Flooring Carpet, Stone, Tile, Wood
      • Master Bedroom Downstairs, Split
      • Number of Interior Levels 1
      • Other Rooms Family Room, Guest Qtrs-Sep Entrn, Great Room
      • Technology Cable TV Avail, HighSpd Intrnt Aval, Smart Home System
      • Builder Bordeaux
      • Energy Features Multi-Zones
      • Features 9+ Flat Ceilings, Drink Wtr Filter Sys, Fire Sprinklers, No Interior Steps, Vaulted Ceiling(s), Wet Bar(s), Water Softener Owned
      • Fireplace 2 Fireplace, Exterior Fireplace, Fireplace Family Rm, Fireplace Master Bdr, Gas Fireplace, Two Way Fireplace
      • Heating Gas Heat
      • Laundry Inside Laundry, Wshr/Dry HookUp Only, Gas Dryer Hookup
      • Roofing Concrete, Foam, Partial Tile
      • Unit Style All on One Level
    • Room Features
      • Master Bathroom 2 Master Baths, Double Sinks, Full Bth Master Bdrm, Separate Shwr and Tub
      • Additional Bedroom 2 Master Bdrms, Mstr Bdr Walkin Clst, Other Bdrm Split, Othr Bdr Walkin Clst, Separate Bdrm Exit
      • Dining Area Breakfast Bar, Formal
      • Kitchen Features Disposal, Dishwasher, Refrigerator, Kitchen Island, Pantry
    • Property Features
      • Apx Lot Size Range 1 - 1.9 Acres
      • Approx Lot SqFt 86087.00
      • 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
      • Dwelling Styles Detached
      • Ownership Fee Simple
      • Legal Info: Township 2
      • Legal Info: Range 4E
      • Legal Info: Lot Number 11
      • Landscaping Yrd Wtring Sys Back, Desert Back, Desert Front, Auto Timer H2O Front, Auto Timer H2O Back, Irrigation Front, Irrigation Back
      • Parking Spaces: Garage Spaces 4.00
      • Exterior Features Covered Patio(s), Patio, Built-in BBQ
      • Fencing Block, View/Wrought Iron
      • Parking Electric Door Opener, Golf Cart Garage, Dir Entry frm Garage
      • Pool Private Heated Pool, Pool - Private
      • Property Description Cul-De-Sac Lot, Golf Course Lot, Mountain View(s), North/South Exposure, Waterfront Lot
      • Sewer Sewer - Private, Sewer in and Cnctd
      • Spa Spa - Heated, Spa - Private
      • Utilities APS, SW Gas
      • Water City Water
    • Schools
      • Elementary School Black Mountain Elementary School
      • High School Cactus Shadows High School
      • Middle School Sonoran Trails Middle School
      • School District 093 - Cave Creek Unified District

    Contact

    Lorelei Carter

    Professional Real Estate Sales Agent

    Scottsdale Office

    Cell: 708-334-0206

    Neighborhood

    85377 (Carefree) Demographics

    65Median Age
    373Population Density (per sq. mile)
    69%College Educated
    $82,340 Estimated Median Income
    1,323Estimated Total Home Owners
    336Estimated Total Renters
    80% / 20%Estimated Owner / Renter Divide
    2Estimated Average Household Size
    3,160Total Population
    Community data courtesy of LiveBy, Inc.

    Market Last 30 Days

    $699,000 Median Sales Price
    9 Homes Sold
    8 New On Market

    Average Days on Market

      Properties for Sale

        Property History

        Date Event Price Percent Change
        -- Current Price Source New Value: $2,750,000 -14.06%
        10/5/2018 12:40:00 PM New in Database Source New Value: $3,200,000

        Payment Calculator

        $0 per month
        Year Fixed, Interest
        Principal and Interest
        $0
        Property Taxes
        Homeowners' Insurance

        Home Price
        Down Payment
        Copyright 2019 Arizona Regional Multiple Listing Service, Inc. All rights reserved. Information Deemed Reliable But Not Guaranteed. Data last updated 8/22/2019 9:10:33 AM. The ARMLS logo indicates a property listed by a real estate brokerage other than Berkshire Hathaway HomeServices Arizona Properties.