NOT LISTED FOR SALE

Estimated Value: $7,754,000 - $8,225,000

5 Beds
7 Baths
7,623 Sq Ft
$1,042/Sq Ft Est. Value

Last Sold August 29, 2024

Last sale price $7,900,000 $1,036 Per Sq Ft

Est. 7% increase in value since last sale

Current estimated payment $47,884/month

129 Days on Market

Highlights

  • Heated Pool
  • Gated Parking
  • Mountain View
  • Cherokee Elementary School Rated A
  • 1.27 Acre Lot
  • Fireplace in Primary Bedroom

About This Home

As of August 2024

This spectacular Modern Contemporary style home designed for entertaining, has everything you've been searching for. Soaring 16 ft ceilings in the kitchen and great room. Large Butler's Pantry with its own sink and refrigerator that gives you that perfect spot to stage for dinners in your gorgeous open concept dining room. Chefs' kitchen with all the latest high-end appliances, luxurious cabinetry, countertops, 2 giant islands, open floor plan. Elegant Fireplace and stunning temperature-controlled wine wall decorate your great room. Windows galore offering endless natural lighting, overlooking a truly resort style back yard including enormous glass pocket door that opens the full length of the great room making your indoor and outdoor areas become one! A teen room is featured in the guest room wing of the home allowing your guests their own private retreat right outside their rooms. Your own private Bohemian chic gym overlooking your park like back yard will motivate everyone to work out! Movie night will never be the same in your new state of the art personal movie theater. Wrapping up your inside entertainment area and located right off the great room is a stylish game room with wet bar and corner pocket doors overlooking this magnificent back yard. The game room also features an attached casita with separate entrance and its own single car garage. The exquisite master suite features beautiful fireplace, corner pocket doors again bringing the outside and inside together as one. 2 huge fully built out closets. Luxurious spa like master bath with oversized soaking tub, enormous shower with every possible fixture, chandeliers, dual water closets, the list goes on and on! When you finally walk out the back door of the home and immerse yourself in this lush custom landscaped yard which features massive 1,000 sq ft plus covered patio, outdoor kitchen, dual sided fireplace, modern style pool, sunken firepit and hot tub with sunken ramada, swim up bar and an enormous roof top deck with amazing mountain views you finally realize just how truly amazing this home is!

Last Agent to Sell the Property

Daniel Yonker

Griggs's Group Powered by The Altman Brothers License #SA643028000 Listed on: 04/02/2024

Griggs's Group Powered by The Altman Brothers

Co-Listed By

Brandon Lespron

Griggs's Group Powered by The Altman Brothers License #SA668156000

Last Buyer's Agent

Kendra Wellman

Walt Danley Local Luxury Christie's International Real Estate License #SA674502000

Walt Danley Local Luxury Christie's International Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,610

Year Built

  • Built in 2023

Lot Details

  • 1.27 Acre Lot
  • Wrought Iron Fence
  • Block Wall Fence
  • Artificial Turf
  • Front and Back Yard Sprinklers
  • Sprinklers on Timer
  • Private Yard

Parking

  • 5 Car Direct Access Garage
  • Electric Vehicle Home Charger
  • Garage Door Opener
  • Circular Driveway
  • Gated Parking

Home Design

  • Designed by L.R. Nelson Architects
  • Contemporary Architecture
  • Wood Frame Construction
  • Spray Foam Insulation
  • Foam Roof

Interior Spaces

  • 7,623 Sq Ft Home
  • 1-Story Property
  • Wet Bar
  • Vaulted Ceiling
  • Ceiling Fan
  • Double Pane Windows
  • Living Room with Fireplace
  • 3 Fireplaces
  • Mountain Views

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Built-In Microwave
  • Kitchen Island
  • Granite Countertops

Flooring

  • Wood
  • Carpet
  • Stone
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Fireplace in Primary Bedroom
  • Primary Bathroom is a Full Bathroom
  • 7 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Bathtub With Separate Shower Stall

Home Security

  • Security System Owned
  • Smart Home

Accessible Home Design

  • Roll-in Shower
  • Accessible Hallway
  • No Interior Steps
  • Stepless Entry

Eco-Friendly Details

  • ENERGY STAR Qualified Equipment for Heating

Pool

  • Heated Pool
  • Pool Pump
  • Heated Spa

Outdoor Features

  • Covered patio or porch
  • Outdoor Fireplace
  • Fire Pit
  • Outdoor Storage
  • Built-In Barbecue

Schools

  • Cherokee Elementary School
  • Cocopah Middle School
  • Chaparral High School

Utilities

  • Ducts Professionally Air-Sealed
  • Mini Split Air Conditioners
  • Zoned Heating and Cooling System
  • Heating System Uses Natural Gas
  • Tankless Water Heater
  • Water Softener
  • High Speed Internet

Community Details

  • No Home Owners Association
  • Association fees include no fees
  • Built by Yonker Construction
  • Tatum Garden Estates Unit 2 Subdivision

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Tax Lot 5
  • Assessor Parcel Number 168-28-007

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,610

Year Built

Built in 2023

Lot Details

0

Parking

5

Listing Details

  • Cross Street: Tatum & Doubletree Ranch
  • Legal Info Range: 4E
  • Property Type: Residential
  • Ownership: Fee Simple
  • Architect Architect: L.R. Nelson
  • Association Fees Land Lease Fee: N
  • Basement: N
  • Cooling HVAC SEER Rating: 15
  • Parking Spaces Slab Parking Spaces: 5.0
  • Parking Spaces Total Covered Spaces: 5.0
  • Separate Den Office Sep Den Office: Y
  • Year Built: 2023
  • Spa Private: Yes
  • Tax Year: 2022
  • Directions: Head East on Shea Blvd, Turn South on Tatum Blvd, Turn East on Berneil, Home is located on your left.
  • Property Sub Type: Single Family Residence
  • Horses: No
  • Lot Size Acres: 1.27
  • Co List Office Mls Id: ggpb001
  • Co List Office Phone: 480-788-0929
  • Subdivision Name: TATUM GARDEN ESTATES UNIT 2
  • Architectural Style: Other, Contemporary
  • New Construction: No
  • Efficiency: Multi-Zones
  • Property Attached Yn: No
  • Dining Area:Breakfast Bar: Yes
  • Windows:Dual Pane: Yes
  • Cooling:Ceiling Fan(s): Yes
  • Cooling:Central Air: Yes
  • Water Source City Water: Yes
  • Fireplace Features Fireplace Living Rm: Yes
  • Fireplace Features Fireplace Master Bdr: Yes
  • Technology:High Speed Internet: Yes
  • Technology:Smart Home: Yes
  • Special Features: NewHome

Interior Features

  • Flooring: Carpet, Stone, Tile, Wood
  • Basement YN: No
  • Possible Use: None
  • Spa Features: Heated, Private
  • Accessibility Features: Zero-Grade Entry, Bath Roll-In Shower, Accessible Hallway(s)
  • Possible Bedrooms: 7
  • Total Bedrooms: 5
  • Fireplace Features: Fire Pit, 3+ Fireplace, Exterior Fireplace, Living Room, Master Bedroom
  • Fireplace: Yes
  • Interior Amenities: High Speed Internet, Smart Home, Granite Counters, Double Vanity, Eat-in Kitchen, Breakfast Bar, 9+ Flat Ceilings, No Interior Steps, Soft Water Loop, Vaulted Ceiling(s), Wet Bar, Kitchen Island, Pantry, Full Bth Master Bdrm, Separate Shwr & Tub
  • Living Area: 7623.0
  • Stories: 1
  • Window Features: Dual Pane
  • Kitchen Features:RangeOven Gas: Yes
  • Kitchen Features:Built-in Microwave: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Master Bathroom:Double Sinks: Yes
  • Kitchen Features Pantry: Yes
  • Other Rooms:Great Room: Yes
  • Other Rooms:Family Room: Yes
  • Kitchen Features:Wall Oven(s): Yes
  • Kitchen Features:Walk-in Pantry: Yes
  • Other Rooms:BonusGame Room: Yes
  • Kitchen Features:Gas Stub for Range: Yes
  • Other Rooms:Guest Qtrs-Sep Entrn: Yes
  • Kitchen Features:Multiple Ovens: Yes
  • Other Rooms:Media Room: Yes
  • Other Rooms:ExerciseSauna Room: Yes
  • KitchenFeatures:Refrigerator: Yes
  • Fireplace Features:Fire Pit: Yes
  • Kitchen Features:Granite Counters: Yes

Exterior Features

  • Fencing: Block, Wrought Iron
  • Exterior Features: Private Yard, Storage, Built-in Barbecue
  • Lot Features: Sprinklers In Rear, Sprinklers In Front, Gravel/Stone Front, Gravel/Stone Back, Synthetic Grass Frnt, Synthetic Grass Back, Auto Timer H2O Front, Auto Timer H2O Back, Irrigation Front, Irrigation Back
  • Pool Features: Variable Speed Pump, Heated, Private
  • View: Mountain(s)
  • Disclosures: Agency Discl Req, Seller Discl Avail
  • Home Warranty: Yes
  • Construction Type: Spray Foam Insulation, Synthetic Stucco, Wood Frame, Painted, Ducts Professionally Air-Sealed
  • Other Structures: Gazebo
  • Patio And Porch Features: Covered Patio(s), Patio
  • Property Condition: Complete Spec Home
  • Roof: Foam
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Built-in BBQ: Yes
  • Exterior Features:Patio: Yes
  • Exterior Features:Pvt Yrd(s)Crtyrd(s): Yes
  • Exterior Features:Storage: Yes
  • Construction Status:Complete Spec Home: Yes
  • Exterior Features:GazeboRamada: Yes
  • Construction:Ducts Professionally Air-Sealed: Yes
  • Construction:Spray Foam Insulatn: Yes
  • Fireplace Features Exterior Fireplace: Yes

Garage/Parking

  • Total Covered Spaces: 5.0
  • Parking Features: Gated, Garage Door Opener, Direct Access, Circular Driveway, Separate Strge Area, Electric Vehicle Charging Station(s)
  • Attached Garage: No
  • Garage Spaces: 5.0
  • Open Parking Spaces: 5.0
  • Parking Features:Separate Strge Area: Yes
  • Parking Features:Electric Vehicle Charging Station(s): Yes
  • Parking Features:Garage Door Opener: Yes
  • Parking Features:Direct Access: Yes
  • Parking Features:Circular Drive: Yes
  • Parking Features:Gated2: Yes

Utilities

  • Electric: 220 Volts in Kitchen
  • Cooling: Central Air, Ceiling Fan(s), Mini Split, Programmable Thmstat
  • Heating: ENERGY STAR Qualified Equipment, Natural Gas
  • Laundry Features: See Remarks
  • Security: Fire Sprinkler System, Security System Owned
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: City Water
  • Heating:Natural Gas: Yes
  • Heating:ENERGY STAR Qualified Equipment2: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Association Fees:HOA YN2: N
  • Association Fees:PAD Fee YN2: N
  • Association Fee Incl:No Fees: Yes

Fee Information

  • Association Fee Includes: No Fees

Schools

  • Elementary School: Cherokee Elementary School
  • High School: Chaparral High School
  • Junior High Dist: Scottsdale Unified District
  • Middle Or Junior School: Cocopah Middle School

Lot Info

  • Land Lease: No
  • Lot Size Sq Ft: 55376.0
  • Parcel #: 168-28-007

Green Features

  • Green Water Conservation: Tankless Ht Wtr Heat, Recirculation Pump

Building Info

  • Builder Name: Yonker Construction

Tax Info

  • Tax Annual Amount: 5610.0
  • Tax Book Number: 168.00
  • Tax Lot: 5
  • Tax Map Number: 28.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 2, 2024
Closed on
Aug 29, 2024
Sold by
4902 E Berneil Dr Llc
Bought by
Loyalty Trust
Seller's Agent
Daniel Yonker
Griggs's Group Powered by The Altman Brothers
Buyer's Agent
Kendra Wellman
Walt Danley Local Luxury Christie's International Real Estate
List Price
$8,385,000
Sold Price
$7,900,000
Premium/Discount to List
-$485,000
-5.78%
Views
363
Current Estimated Value
$8,483,549

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$583,549
Avg. Annual Appreciation
0.63%
Original Mortgage
$5,530,000
Outstanding Balance
$5,496,235
Interest Rate
6.77%
Mortgage Type
New Conventional
Estimated Equity
$2,450,640

Purchase Details

Closed on
Jan 11, 2022
Sold by
John And Marie Foltz Family Trust
Bought by
Dfa Properties Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,581,000
Interest Rate
3.05%
Mortgage Type
New Conventional

Purchase Details

Closed on
Nov 30, 2015
Sold by
Foltz John and Foltz Marie D
Bought by
Foltz John E and Foltz Marie D

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$246,500
Interest Rate
3.76%
Mortgage Type
New Conventional

Purchase Details

Closed on
Feb 9, 2010
Sold by
Primacy Closing Corporation
Bought by
Foltz John and Foltz Marie

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$340,000
Interest Rate
5.02%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Oct 24, 2009
Sold by
Tayrien Richard B
Bought by
Primacy Closing Corporation
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Loyalty Trust $7,900,000 Wfg National Title Insurance C
Dfa Properties Llc $1,550,000 Chicago Title
Foltz John E -- Security Title Agency Inc
Foltz John -- Security Title Agency Inc
Foltz John $651,000 Old Republic Title Agency
Primacy Closing Corporation $680,000 None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Loyalty Trust $5,530,000
Previous Owner 4902 E Berneil Dr Llc $4,911,273
Previous Owner 4902 E Barneil Dr Llc $3,825,000
Previous Owner Dfa Properties Llc $1,581,000
Previous Owner Foltz John $246,500
Previous Owner Foltz John $340,000
Previous Owner Tayrien Richard B $803,000
Previous Owner Tayrien Richard B $417,700
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/29/2024 08/29/24 Sold $7,900,000 -3.5% $1,036 / Sq Ft
08/11/2024 08/11/24 Pending -- -- --
06/06/2024 06/06/24 Price Changed $8,185,000 -2.4% $1,074 / Sq Ft
04/03/2024 04/03/24 For Sale $8,385,000 0.0% $1,100 / Sq Ft
04/01/2020 04/01/20 Rented $4,500 0.0% --
02/05/2020 02/05/20 For Rent $4,500 +12.5% --
12/15/2017 12/15/17 Rented $4,000 0.0% --
10/26/2017 10/26/17 Price Changed $4,000 -5.9% $1 / Sq Ft
10/06/2017 10/06/17 Price Changed $4,250 -5.6% $1 / Sq Ft
09/15/2017 09/15/17 For Rent $4,500 +12.5% --
07/01/2016 07/01/16 Rented $4,000 0.0% --
05/13/2016 05/13/16 Price Changed $4,000 -9.1% $1 / Sq Ft
04/28/2016 04/28/16 For Rent $4,400 +10.0% --
08/15/2014 08/15/14 Rented $4,000 -4.8% --
08/14/2014 08/14/14 Under Contract -- -- --
08/13/2014 08/13/14 For Rent $4,200 -- --
Source: Arizona Regional Multiple Listing Service (ARMLS)

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $12,371 $305,800 -- --
2024 $5,235 $200,420 -- --
2023 $5,235 $174,270 $174,270 $0
2022 $5,610 $93,800 $18,760 $75,040
2021 $5,964 $87,300 $17,460 $69,840
2020 $5,926 $85,080 $17,010 $68,070
2019 $5,721 $80,210 $16,040 $64,170
2018 $5,509 $78,970 $15,790 $63,180
2017 $5,292 $77,760 $15,550 $62,210
2016 $5,182 $80,310 $16,060 $64,250
2015 $4,916 $80,310 $16,060 $64,250
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 6685836

Arizona Regional Multiple Listing Service (ARMLS)

APN: 168-28-007