$4,873,500
SOLD AUG 25, 2025
4 Beds
4.5 Baths
5,682 Sq Ft
0.81 Acres

Recently Sold

$858 Per Sq Ft

Highlights

  • Private Pool
  • 0.81 Acre Lot
  • Contemporary Architecture
  • Hopi Elementary School Rated A
  • Mountain View
  • Living Room with Fireplace

About This Home

As of August 2025

This fabulous estate property sits on a magnificent lot with exquisite views of Camelback Mountain. From the moment you arrive, you'll be struck by the impressive curb appeal, and once you enter through the beautiful foyer, you'll enjoy unique design and exceptional quality. The gourmet kitchen has a huge custom island that's a fantastic gathering space for family and friends with loads of room to prep, serve and entertain. The kitchen seamlessly flows to both formal and informal dining areas and into the huge great room where a lovely fireplace is the focal point of the open concept floor plan where retractable glass doors create flawless indoor/outdoor living. The private office is an impressive space for those who work from home, there's a second workspace great for the kids, and all the oversized bedrooms are terrific including a magnificent primary suite with a spa-like bath. The character of the home is highlighted by wide plank wood flooring, exposed wood beams, custom cabinetry, dramatic lighting, high end surfaces, and sleek bathroom design, and the highly manicured grounds feature an amazing outdoor living room, gorgeous pool and spa, custom ramada and full outdoor kitchen. This impeccable home is grand yet inviting, elegant yet comfortable, and calls for entertaining on any scale!

Last Agent to Sell the Property

Robert Joffe

Compass License #BR029057000 Listed on: 05/08/2025

Compass

Co-Listed By

Jonah Joffe

Compass License #SA687192000

Last Buyer's Agent

Robert Joffe

Compass License #BR029057000 Listed on: 05/08/2025

Compass

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $13,704

Year Built

  • Built in 2017

Lot Details

  • 0.81 Acre Lot
  • Cul-De-Sac
  • Block Wall Fence
  • Front and Back Yard Sprinklers
  • Sprinklers on Timer
  • Grass Covered Lot

Parking

  • 4 Car Direct Access Garage
  • 10 Open Parking Spaces
  • Garage Door Opener

Home Design

  • Designed by Brimley Development Architects
  • Contemporary Architecture
  • Santa Barbara Architecture
  • Wood Frame Construction
  • Concrete Roof
  • Stucco

Interior Spaces

  • 5,682 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Ceiling Fan
  • Skylights
  • Gas Fireplace
  • Double Pane Windows
  • ENERGY STAR Qualified Windows
  • Living Room with Fireplace
  • 3 Fireplaces
  • Mountain Views

Kitchen

  • Eat-In Kitchen
  • Kitchen Island
  • Granite Countertops

Flooring

  • Wood
  • Carpet
  • Stone

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom on Main
  • Primary Bathroom is a Full Bathroom
  • 4.5 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Bathtub With Separate Shower Stall

Home Security

  • Security System Owned
  • Smart Home

Outdoor Features

  • Private Pool
  • Covered Patio or Porch
  • Outdoor Fireplace
  • Built-In Barbecue
  • Playground

Schools

  • Hopi Elementary School
  • Ingleside Middle School
  • Arcadia High School

Utilities

  • Zoned Heating and Cooling System
  • Heating System Uses Natural Gas
  • Water Purifier
  • Water Softener
  • High Speed Internet
  • Cable TV Available

Additional Features

  • Accessible Hallway
  • ENERGY STAR Qualified Equipment

Community Details

  • No Home Owners Association
  • Association fees include no fees
  • Hacienda Allenada Subdivision

Listing and Financial Details

  • Tax Lot 13
  • Assessor Parcel Number 172-31-022-A

Home Details

Home Type

Single Family

Est. Annual Taxes

$13,704

Year Built

Built in 2017

Lot Details

0

Parking

4

Listing Details

  • Cross Street: 56th and Camelback Road
  • Legal Info Range: 4E
  • Property Type: Residential
  • Ownership: Fee Simple
  • Architect Architect: Brimley Development
  • Association Fees Land Lease Fee: N
  • Basement: N
  • Cooling HVAC SEER Rating: 17
  • Parking Spaces Slab Parking Spaces: 10.0
  • Parking Spaces Total Covered Spaces: 4.0
  • Separate Den Office Sep Den Office: Y
  • Year Built: 2017
  • Tax Year: 2024
  • Directions: Camelback to Camino Allenada - south to home
  • Property Sub Type: Single Family Residence
  • Horses: No
  • Lot Size Acres: 0.81
  • Co List Office Mls Id: laun001
  • Co List Office Phone: 480-776-1555
  • Subdivision Name: HACIENDA ALLENADA
  • Architectural Style: Other, Contemporary, Santa Barbara/Tuscan
  • Efficiency: Multi-Zones
  • Property Attached Yn: No
  • Tax Parcel Letter: A
  • Windows:Dual Pane: Yes
  • Cooling:Ceiling Fan(s): Yes
  • Technology:Cable TV Avail: Yes
  • Cooling ENERGY STAR Qualified Equipment: Yes
  • Cooling:Central Air: Yes
  • Features:Water Purifier: Yes
  • Water Source City Water: Yes
  • Fireplace Features Fireplace Living Rm: Yes
  • Fireplace Features Gas Fireplace: Yes
  • Technology:High Speed Internet: Yes
  • Technology:Smart Home: Yes
  • Special Features: None

Interior Features

  • Flooring: Carpet, Stone, Wood
  • Basement YN: No
  • Spa Features: None
  • Appliances: Water Purifier
  • Accessibility Features: Accessible Hallway(s)
  • Possible Bedrooms: 6
  • Total Bedrooms: 4
  • Fireplace Features: 3+ Fireplace, Exterior Fireplace, Living Room, Gas
  • Fireplace: Yes
  • Interior Amenities: High Speed Internet, Smart Home, Granite Counters, Double Vanity, Master Downstairs, Eat-in Kitchen, Soft Water Loop, Wet Bar, Kitchen Island, Pantry, Full Bth Master Bdrm, Separate Shwr & Tub
  • Living Area: 5682.0
  • Stories: 2
  • Window Features: Skylight(s), Dual Pane, ENERGY STAR Qualified Windows
  • Kitchen Features:RangeOven Gas: 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
  • Kitchen Features:Multiple Ovens: Yes
  • Other Rooms:Library-Blt-in Bkcse: Yes
  • KitchenFeatures:Refrigerator: Yes
  • Kitchen Features:Granite Counters: Yes

Exterior Features

  • Fencing: Block
  • Exterior Features: Playground, Built-in Barbecue
  • Lot Features: Sprinklers In Rear, Sprinklers In Front, Cul-De-Sac, Grass Back, Auto Timer H2O Front, Auto Timer H2O Back, Irrigation Front, Irrigation Back
  • Pool Private: Yes
  • View: Mountain(s)
  • Disclosures: Agency Discl Req, Seller Discl Avail
  • Construction Type: Stucco, Wood Frame, Painted
  • Patio And Porch Features: Covered Patio(s)
  • Roof: Concrete
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Built-in BBQ: Yes
  • Exterior Features:Childrens Play Area: Yes
  • Fireplace Features Exterior Fireplace: Yes

Garage/Parking

  • Total Covered Spaces: 4.0
  • Parking Features: Garage Door Opener, Direct Access
  • Attached Garage: No
  • Garage Spaces: 4.0
  • Open Parking Spaces: 10.0
  • Parking Features:Garage Door Opener: Yes
  • Parking Features:Direct Access: Yes

Utilities

  • Cooling: Central Air, Ceiling Fan(s), ENERGY STAR Qualified Equipment, Programmable Thmstat
  • Heating: Natural Gas
  • Security: Fire Sprinkler System, Security System Owned
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: City Water
  • Heating:Natural Gas: 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: Hopi Elementary School
  • High School: Arcadia High School
  • Junior High Dist: Scottsdale Unified District
  • Middle Or Junior School: Ingleside Middle School

Lot Info

  • Land Lease: No
  • Lot Size Sq Ft: 35098.0
  • Parcel #: 172-31-022-A

Green Features

  • Green Water Conservation: Recirculation Pump

Building Info

  • Builder Name: Unknown

Tax Info

  • Tax Annual Amount: 13704.0
  • Tax Book Number: 172.00
  • Tax Lot: 13
  • Tax Map Number: 31.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 8, 2025
Closed on
Aug 19, 2025
Sold by
Oak Tree Llc
Bought by
Turbow Family Trust and Turbow
Seller's Agent
Robert Joffe
Compass
Buyer's Agent
Robert Joffe
Compass
Sold Price
$4,873,500

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
30.40%
Original Mortgage
$750,000
Outstanding Balance
$750,000
Interest Rate
6.13%
Mortgage Type
New Conventional
Estimated Equity
$4,241,315

Purchase Details

Listed on
Aug 11, 2021
Closed on
Sep 1, 2021
Sold by
Ormsbee Terrence D and Coles Francine Linda
Bought by
Oak Tree Llc
Seller's Agent
Jan Kabbani
Russ Lyon Sotheby's International Realty
Buyer's Agent
Robert Joffe
Compass
List Price
$4,250,000
Sold Price
$4,285,000
Premium/Discount to List
$35,000
0.82%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.30%
Original Mortgage
$2,875,250
Interest Rate
2.8%
Mortgage Type
Future Advance Clause Open End Mortgage

Purchase Details

Closed on
Apr 1, 2015
Sold by
Ormsbee Terrence D and Ormsbee Revocable T Terrence D
Bought by
Ormsbee Terrence D and Coles Francine Linda

Purchase Details

Closed on
Jun 29, 2010
Sold by
Curtis Scott T
Bought by
Catalina Homes Inc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$403,000
Interest Rate
4.82%
Mortgage Type
Seller Take Back

Purchase Details

Closed on
Mar 20, 2007
Sold by
Joffe Robert E and Choules Eric T
Bought by
Curtis Scott T

Home Financials for this Owner

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

Purchase Details

Closed on
Mar 19, 2007
Sold by
Curtis Victoria B
Bought by
Curtis Scott T

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,020,000
Interest Rate
6.31%
Mortgage Type
Purchase Money Mortgage
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 Type Sale Price Title Company
Warranty Deed $4,873,500 Wfg National Title Insurance C
Warranty Deed $4,285,000 Magnus Title Agency Llc
Interfamily Deed Transfer -- Metropolitan Title Agency Ll
Cash Sale Deed $765,000 Metropolitan Title Agency Ll
Special Warranty Deed $400,000 The Talon Group Home Office
Warranty Deed $1,275,000 Camelback Title Agency Llc
Interfamily Deed Transfer -- Camelback Title Agency Llc
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $750,000 New Conventional
Previous Owner $2,875,250 Future Advance Clause Open End Mortgage
Previous Owner $403,000 Seller Take Back
Previous Owner $1,020,000 Purchase Money Mortgage
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/25/2025 08/25/25 Sold $4,873,500 +13.7% $858 / Sq Ft
04/26/2025 04/26/25 Pending -- -- --
09/09/2021 09/09/21 Sold $4,285,000 +0.8% $754 / Sq Ft
08/09/2021 08/09/21 Pending -- -- --
07/30/2021 07/30/21 For Sale $4,250,000 -- $748 / Sq Ft
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 $13,704 $181,996 -- --
2024 $13,417 $173,330 -- --
2023 $13,417 $295,120 $59,020 $236,100
2022 $12,844 $231,480 $46,290 $185,190
2021 $13,333 $225,730 $45,140 $180,590
2020 $13,128 $200,950 $40,190 $160,760
2019 $12,614 $198,270 $39,650 $158,620
2018 $12,107 $155,295 $155,295 $0
2017 $4,993 $145,080 $145,080 $0
2016 $4,864 $117,525 $117,525 $0
2015 $4,756 $105,408 $105,408 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 6856524

Arizona Regional Multiple Listing Service (ARMLS)

APN: 172-31-022A