NOT LISTED FOR SALE

Estimated Value: $5,863,751

5 Beds
10 Baths
13,286 Sq Ft
$441/Sq Ft Est. Value

Last Sold July 25, 2024

Last sale price $4,480,000 $337 Per Sq Ft

Est. 31% increase in value since last sale

Current estimated payment $33,243/month

28 Days on Market

Highlights

  • Golf Course Community
  • Above Ground Spa
  • Gated Parking
  • Hopi Elementary School Rated A
  • RV Garage
  • 1.1 Acre Lot

About This Home

As of July 2024

AUCTION - Seller offering property via online auction. Bid online beginning Monday, June 24th with a starting bid of $2M. THE luxury value-add OPPORTUNITY OF THE YEAR awaits your finishing touches to create the ultimate dream home! Designed by award-winning Scottsdale based architect Wil Wetterland on one of the Valleys most desirable sites, the southern base of iconic Camelback Mountain, this Grand Gated Estate is inspired by Old World European charm and elegance but built with New World technology. Experience the spectacular views and moods of Camelback Mtn through IMAX sized windows or myriad stone accented gathering spaces and verandas. The Rooftop Spa deck offers ON-DEMAND instagramable panoramas of the brimming downtown skyline & South Mountain. World class location surrounded by world class amenities! Restaurants, Shopping, Galleries, Golf, Hotels and everything else the 5th largest city in the nation has to offer! Other highlights: Resplendent rosewood hardwood floors, Cherrywood Hydraulic Elevator (operator not included) 12-CAR RV Garage, circular drive can accommodate 15+ cars (or just valet) Separate Privacy Vault, commercial grade kitchen, all 5 bedrooms are en-suite, 7 fireplaces, 8 AC units, Sweeping Rosewood staircase with filigreed iron railing (for when you need to make THAT entrance), expansive game room, CRESTRON SMART HOME SYSTEM - massive tech infrastructure throughout - home theater (all components pre-wired) all bedrooms wired for surround sound and so much more! Additional Notes: beds/baths - 5 full baths and 5 half baths. Tax Records indicate home built 2008. Certificate of Occupancy obtained 2010.

Last Agent to Sell the Property

David Elton

Arizona Best Real Estate License #SA531628000 Listed on: 05/28/2024

Arizona Best Real Estate

Co-Listed By

Rick Elton

Arizona Best Real Estate License #BR107850000

Last Buyer's Agent

Kristine Camandona

Esplanade License #BR575645000

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $28,734

Year Built

  • Built in 2008

Lot Details

  • 1.1 Acre Lot
  • Wrought Iron Fence

Parking

  • 12 Car Detached Garage
  • 15 Open Parking Spaces
  • 2 Carport Spaces
  • Garage ceiling height seven feet or more
  • Garage Door Opener
  • Circular Driveway
  • Gated Parking
  • RV Garage

Home Design

  • Wood Frame Construction
  • Spray Foam Insulation
  • Tile Roof
  • Block Exterior
  • Low Volatile Organic Compounds (VOC) Products or Finishes
  • Stone Exterior Construction
  • Stucco

Interior Spaces

  • 13,286 Sq Ft Home
  • 2-Story Property
  • Elevator
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Gas Fireplace
  • Triple Pane Windows
  • Low Emissivity Windows
  • Wood Frame Window
  • Family Room with Fireplace
  • 3 Fireplaces
  • Living Room with Fireplace
  • Partial Basement
  • Washer and Dryer Hookup

Kitchen

  • Gas Cooktop
  • Kitchen Island

Flooring

  • Wood
  • Stone
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Primary Bedroom on Main
  • Fireplace in Primary Bedroom
  • Primary Bathroom is a Full Bathroom
  • 10 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Hydromassage or Jetted Bathtub
  • Bathtub With Separate Shower Stall

Home Security

  • Security System Owned
  • Smart Home

Eco-Friendly Details

  • ENERGY STAR Qualified Equipment

Outdoor Features

  • Above Ground Spa
  • Balcony
  • Covered Patio or Porch
  • Playground

Schools

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

Utilities

  • Ducts Professionally Air-Sealed
  • Zoned Heating and Cooling System
  • Heating System Uses Natural Gas
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Tax Lot 22
  • Assessor Parcel Number 172-19-022

Community Details

Overview

  • No Home Owners Association
  • Association fees include no fees
  • Built by Jeffrey W Lamb
  • Camelback Mountain Estates Plat 1 Subdivision, Custom Floorplan

Recreation

  • Golf Course Community
  • Bike Trail

Home Details

Home Type

Single Family

Est. Annual Taxes

$28,734

Year Built

Built in 2008

Lot Details

0

Parking

12

Listing Details

  • Cross Street: Camelback & Arcadia
  • Property Type: Residential
  • Ownership: Fee Simple
  • Association Fees Land Lease Fee: N
  • Basement: Y
  • Parking Spaces Slab Parking Spaces: 15.0
  • Parking Spaces Total Covered Spaces: 14.0
  • Separate Den Office Sep Den Office: Y
  • Year Built: 2008
  • Tax Year: 2023
  • Master Model: CUSTOM
  • Property Sub Type: Single Family Residence
  • Horses: No
  • Lot Size Acres: 1.1
  • Co List Office Mls Id: best08
  • Co List Office Phone: 480-948-4711
  • Subdivision Name: CAMELBACK MOUNTAIN ESTATES PLAT 1
  • Architectural Style: Other
  • Efficiency: Multi-Zones
  • Property Attached Yn: No
  • General Property Description:PriceSqFt: 337.19
  • Cooling:Ceiling Fan(s): Yes
  • Technology:Cable TV Avail: Yes
  • Windows:Low-E: Yes
  • Cooling ENERGY STAR Qualified Equipment: Yes
  • Cooling:Central Air: Yes
  • Water Source City Water: Yes
  • Fireplace Features Fireplace Living Rm: Yes
  • Fireplace Features Fireplace Family Rm: Yes
  • Fireplace Features Gas Fireplace: Yes
  • Fireplace Features Fireplace Master Bdr: Yes
  • Kitchen Features:Gas Cooktop: Yes
  • Technology:High Speed Internet: Yes
  • Technology:Smart Home: Yes
  • Special Features: Auction

Interior Features

  • Basement: Partial
  • Flooring: Stone, Tile, Wood
  • Basement YN: Yes
  • Spa Features: Above Ground
  • Appliances: Gas Cooktop
  • Total Bedrooms: 5
  • Fireplace Features: Other, 3+ Fireplace, Family Room, Living Room, Master Bedroom, Gas
  • Fireplace: Yes
  • Interior Amenities: High Speed Internet, Smart Home, Double Vanity, Master Downstairs, Upstairs, 9+ Flat Ceilings, Elevator, Kitchen Island, Full Bth Master Bdrm, Separate Shwr & Tub, Tub with Jets
  • Living Area: 13286.0
  • Stories: 2
  • Window Features: Low-Emissivity Windows, Triple Pane Windows, Wood Frames
  • Kitchen Features:RangeOven Elec: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Master Bathroom:Double Sinks: Yes
  • Community Features:BikingWalking Path: Yes
  • Other Rooms:Great Room: Yes
  • Other Rooms:Family Room: Yes
  • Kitchen Features:Walk-in Pantry: Yes
  • Other Rooms:BonusGame Room: Yes
  • Other Rooms:Loft: Yes
  • Kitchen Features:Multiple Ovens: Yes
  • Other Rooms:Separate Workshop: Yes
  • Other Rooms:Media Room: Yes
  • Other Rooms:ExerciseSauna Room: Yes
  • Basement Description:Partial: Yes
  • KitchenFeatures:Refrigerator: Yes
  • Community Features:Golf: Yes

Exterior Features

  • Fencing: See Remarks, Wrought Iron
  • Exterior Features: Playground, Other, Balcony
  • Lot Features: Dirt Back, Gravel/Stone Front
  • Pool Features: None
  • Disclosures: Agency Discl Req, Seller Discl Avail
  • Construction Type: Spray Foam Insulation, Stucco, Steel Frame, Wood Frame, Low VOC Wood Products, Painted, Stone, Block, Ducts Professionally Air-Sealed
  • Other Structures: Gazebo
  • Patio And Porch Features: Covered Patio(s), Patio
  • Roof: Tile
  • Construction:Frame - Wood: Yes
  • Construction:Block: Yes
  • Construction:Frame - Metal: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Childrens Play Area: Yes
  • Exterior Features:Patio: Yes
  • Exterior Features:Balcony: Yes
  • Exterior Features:GazeboRamada: Yes
  • Construction:Ducts Professionally Air-Sealed: Yes
  • Construction:Spray Foam Insulatn: Yes
  • Construction:Low VOC Wood Products: Yes
  • Exterior Features:Other6: Yes

Garage/Parking

  • Total Covered Spaces: 14.0
  • Parking Features: RV Access/Parking, Gated, Garage Door Opener, Circular Driveway, Over Height Garage, Separate Strge Area, Detached, RV Garage
  • Attached Garage: No
  • Carport Spaces: 2.0
  • Garage Spaces: 12.0
  • Open Parking Spaces: 15.0
  • Parking Features:Separate Strge Area: Yes
  • Parking Features:Detached: Yes
  • Parking Features:Over Height Garage: Yes
  • Parking Features:RV Garage: Yes
  • Parking Features:Garage Door Opener: Yes
  • Parking Features:Circular Drive: Yes
  • Parking Features:RV AccessParking: Yes
  • Parking Features:Gated2: Yes

Utilities

  • Electric: 220 Volts in Kitchen
  • Cooling: Central Air, Ceiling Fan(s), ENERGY STAR Qualified Equipment, Programmable Thmstat
  • Heating: See Remarks, Electric, Natural Gas
  • Laundry Features: Other, Wshr/Dry HookUp Only
  • Security: Security System Owned
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: City Water
  • Heating:Natural Gas: Yes
  • Heating:Electric: Yes

Condo/Co-op/Association

  • Community Features: Golf, Biking/Walking Path
  • 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: 47768.0
  • Parcel #: 172-19-022

Green Features

  • Green Water Conservation: Recirculation Pump

Building Info

  • Builder Name: Jeffrey W Lamb

Tax Info

  • Tax Annual Amount: 28734.0
  • Tax Book Number: 172.00
  • Tax Lot: 22
  • Tax Map Number: 19.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 28, 2024
Closed on
Jul 25, 2024
Sold by
Lamb Jeffrey W
Bought by
4937 Rockridge Road Llc
Seller's Agent
David Elton
Arizona Best Real Estate
Buyer's Agent
Kristine Camandona
Esplanade
List Price
$7,900,000
Sold Price
$4,480,000
Premium/Discount to List
-$3,420,000
-43.29%
Views
49
Current Estimated Value
$5,863,751

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$1,383,751
Avg. Annual Appreciation
20.40%

Purchase Details

Closed on
Dec 28, 2001
Sold by
Sucato Helen R
Bought by
Lamb Jeffrey W

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$696,000
Interest Rate
6.25%
Mortgage Type
New Conventional
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
4937 Rockridge Road Llc $4,480,000 Arizona Premier Title
Lamb Jeffrey W $870,000 Century Title Agency Inc
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Lamb Jeffrey W $696,000
Closed Lamb Jeffrey W $87,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
07/25/2024 07/25/24 Sold $4,480,000 -35.1% $337 / Sq Ft
06/26/2024 06/26/24 Pending -- -- --
06/18/2024 06/18/24 Price Changed $6,900,000 -12.7% $519 / Sq Ft
05/28/2024 05/28/24 For Sale $7,900,000 -- $595 / 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 $31,345 $380,879 -- --
2024 $28,734 $362,742 -- --
2023 $28,734 $406,430 $81,280 $325,150
2022 $27,535 $346,750 $69,350 $277,400
2021 $28,560 $313,350 $62,670 $250,680
2020 $28,737 $327,100 $65,420 $261,680
2019 $27,639 $313,550 $62,710 $250,840
2018 $26,555 $276,410 $55,280 $221,130
2017 $25,570 $264,050 $52,810 $211,240
2016 $25,375 $256,210 $51,240 $204,970
2015 $24,028 $271,010 $54,200 $216,810
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 6711152

Arizona Regional Multiple Listing Service (ARMLS)

APN: 172-19-022