NOT LISTED FOR SALE

Estimated Value: $1,891,000 - $2,324,000

5 Beds
3 Baths
4,488 Sq Ft
$488/Sq Ft Est. Value

Last Sold April 09, 2020

Last sale price $1,275,000 $284 Per Sq Ft

Est. 72% increase in value since last sale

Current estimated payment $12,912/month

26 Days on Market

Highlights

  • Private Pool
  • RV Gated
  • Mountain View
  • Sequoya Elementary School Rated A
  • 0.81 Acre Lot
  • Fireplace in Primary Bedroom

About This Home

As of April 2020

REMODELED ORANGE TREE ESTATES HOME SITUATED ON A PARK-LIKE 35130 SQUARE FOOT LOT. GREAT FAMILY HOME WITH FIVE BEDROOMS,UPDATED GOURMET KITCHEN WITH GRANITE ISLAND/COUNTERS,STAINLESS STEEL APPLIANCES(SUB-ZERO FRIDGE),CUSTOM CABINETRY AND LARGE WALK IN PANTRY. ALL BATHROOMS HAVE BEEN REMODELED, MASTER SUITE HAS FP, VIEWS OF THE BACKYARD AND A HUGE WALK IN CLOSET WITH MANY BUILT INS. 3 CAR GARAGE(LOTS OF STORAGE),RV GATE AND CIRCULAR DRIVEWAY FOR LOTS OF EXTRA PARKING. PRIVATE BACKYARD IS A MINI DISNEYLAND-SPORT COURT IS IDEAL FOR VOLLEYBALL OR BASKETBALL,FENCED POOL WITH WATERFALL,GAZEBO,LOTS OF TREES AND GRASS. ROOM FOR 100 OF YOUR CLOSEST FRIENDS. HOME IS ALMOST WALKING DISTANCE TO BRAND NEW MOUNTAIN GYM AND EASY ACCESS TO ALL AREAS OF TOWN. LOTS OF CLOSE BY RESTAURANTS AND SHOPPING.

Last Agent to Sell the Property

Bobby Lieb

HomeSmart License #BR007861000 Listed on: 01/18/2020

HomeSmart

Last Buyer's Agent

Devin Guerrero

Realty ONE Group License #SA649849000

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,411

Year Built

  • Built in 1983

Lot Details

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

Parking

  • 3 Car Garage
  • 6 Open Parking Spaces
  • Garage Door Opener
  • Circular Driveway
  • RV Gated

Home Design

  • Wood Frame Construction
  • Tile Roof
  • Foam Roof
  • Stucco

Interior Spaces

  • 4,488 Sq Ft Home
  • 1-Story Property
  • Vaulted Ceiling
  • Skylights
  • Double Pane Windows
  • Family Room with Fireplace
  • 2 Fireplaces
  • Mountain Views
  • Security System Owned

Kitchen

  • Eat-In Kitchen
  • Built-In Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Fireplace in Primary Bedroom
  • Walk-In Closet
  • Remodeled Bathroom
  • Primary Bathroom is a Full Bathroom
  • 3 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Bathtub With Separate Shower Stall

Laundry

  • Laundry in unit
  • Dryer
  • Washer

Accessible Home Design

  • No Interior Steps

Pool

  • Private Pool
  • Fence Around Pool
  • Diving Board

Outdoor Features

  • Covered patio or porch
  • Playground

Schools

  • Sequoya Elementary School
  • Cocopah Middle School
  • Chaparral High School

Utilities

  • Refrigerated Cooling System
  • Zoned Heating
  • Water Filtration System
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Built by CUSTOM
  • Orange Tree Estates Lot 1 23 Subdivision

Listing and Financial Details

  • Tax Lot 12
  • Assessor Parcel Number 167-77-026

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,411

Year Built

Built in 1983

Lot Details

0

Parking

3

Listing Details

  • Cross Street: SHEA/54TH ST
  • Legal Info Range: 4E
  • Property Type: Residential
  • Association Fees Land Lease Fee: N
  • Recreation Center Fee 2: N
  • Recreation Center Fee: N
  • Basement: N
  • Updated Partial or Full Bathrooms: Full
  • Bathrooms Year Updated: 2014
  • Updated Floors: Partial
  • Items Updated Floor Yr Updated: 2014
  • Updated Heating or Cooling Units: Full
  • Items Updated Ht Cool Yr Updated: 2014
  • Updated Kitchen: Full
  • Items Updated Kitchen Yr Updated: 2014
  • Updated Pool: Partial
  • Items Updated Pool Yr Updated: 2018
  • Updated Roof: Full
  • Items Updated Roof Yr Updated: 2013
  • Parking Spaces Slab Parking Spaces: 6.0
  • Parking Spaces Total Covered Spaces: 3.0
  • Separate Den Office Sep Den Office: N
  • Year Built: 1983
  • Tax Year: 2019
  • Directions: NORTH ON 54TH STREET TO SAHUARO..EAST TO 55TH ST..NORTH TO HOME
  • Property Sub Type: Single Family - Detached
  • Lot Size Acres: 0.81
  • Subdivision Name: ORANGE TREE ESTATES LOT 1-23
  • Efficiency: Multi-Zones
  • Property Attached Yn: No
  • ResoBuildingAreaSource: Assessor
  • Special Features: None

Interior Features

  • Flooring: Carpet, Tile, Wood
  • Spa Features: None
  • Possible Bedrooms: 5
  • Total Bedrooms: 5
  • Fireplace Features: 2 Fireplace, Family Room, Master Bedroom
  • Fireplace: Yes
  • Interior Amenities: Walk-In Closet(s), Eat-in Kitchen, Drink Wtr Filter Sys, No Interior Steps, Vaulted Ceiling(s), Kitchen Island, Double Vanity, Full Bth Master Bdrm, Separate Shwr & Tub, High Speed Internet, Granite Counters
  • Living Area: 4488.0
  • Stories: 1
  • Window Features: Skylight(s), Double Pane Windows
  • Kitchen Features:RangeOven Elec: Yes
  • Kitchen Features:Dishwasher2: Yes
  • Kitchen Features:Built-in Microwave: Yes
  • Kitchen Features:Granite Countertops: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Kitchen Features:Disposal2: Yes
  • Kitchen Features:Refrigerator2: Yes
  • Fireplace:_two_ Fireplace: Yes
  • Fireplace:Fireplace Family Rm: Yes
  • Other Rooms:Family Room: Yes
  • Kitchen Features:Cook Top Elec: Yes
  • Kitchen Features:Multiple Ovens: Yes
  • Fireplace:Fireplace Master Bdr: Yes

Exterior Features

  • Fencing: Block
  • Exterior Features: Circular Drive, Covered Patio(s), Playground
  • Lot Features: Sprinklers In Rear, Sprinklers In Front, Grass Front, Grass Back, Auto Timer H2O Front, Auto Timer H2O Back
  • Pool Features: Diving Pool, Fenced, Private
  • View: Mountain(s)
  • Disclosures: Seller Discl Avail
  • Construction Type: Painted, Stucco, Frame - Wood
  • Roof: Tile, Foam
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Childrens Play Area: Yes
  • Exterior Features:Circular Drive: Yes

Garage/Parking

  • Total Covered Spaces: 3.0
  • Parking Features: Electric Door Opener, RV Gate, Separate Strge Area, RV Access/Parking
  • Attached Garage: No
  • Garage Spaces: 3.0
  • Open Parking Spaces: 6.0
  • Parking Features:Electric Door Opener: Yes
  • Parking Features:RV Gate: Yes
  • Parking Features:RV Parking: Yes
  • Parking Features:Separate Strge Area: Yes

Utilities

  • Cooling: Refrigeration
  • Heating: Electric
  • Laundry Features: Dryer Included, Inside, Washer Included
  • Security: Security System Owned
  • Water Source: City Water
  • Heating:Electric: Yes

Condo/Co-op/Association

  • Amenities: None
  • Association: No

Association/Amenities

  • Association Fees:HOA YN2: N
  • Association Fees:PAD Fee YN2: N
  • Association Fees:Cap ImprovementImpact Fee _percent_: %
  • Association Fees:Cap ImprovementImpact Fee 2 _percent_: %
  • Association Fee Incl:No Fees: Yes

Schools

  • Elementary School: Sequoya Elementary School
  • High School: Chaparral High School
  • Middle Or Junior School: Cocopah Middle School

Lot Info

  • Land Lease: No
  • Lot Size Sq Ft: 35130.0
  • Parcel #: 167-77-026
  • ResoLotSizeUnits: SquareFeet

Building Info

  • Builder Name: CUSTOM

Tax Info

  • Tax Annual Amount: 7411.0
  • Tax Book Number: 167.00
  • Tax Lot: 12
  • Tax Map Number: 77.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Sep 8, 2023
Sold by
Lamm Christopher and Lamm Mayuli
Bought by
Christopher M Lamm And Mayuli B Lamm Trust and Lamm
Total Days on Market
26
Current Estimated Value
$2,188,590

Purchase Details

Listed on
Jan 18, 2020
Closed on
Mar 27, 2020
Sold by
Hauptman Ronald J and Hauptman Valerie J
Bought by
Lamm Christopher and Lamm Mayuli
Seller's Agent
Bobby Lieb
HomeSmart
Buyer's Agent
Devin Guerrero
Realty ONE Group
List Price
$1,350,000
Sold Price
$1,275,000
Premium/Discount to List
-$75,000
-5.56%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
11.30%
Original Mortgage
$825,000
Interest Rate
3.4%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jan 7, 2009
Sold by
Hauptman Ronald J and Hauptman Valerie J
Bought by
Hauptman Ronald J and Hauptman Valerie J

Purchase Details

Closed on
Jun 30, 2003
Sold by
Smith W Michael G and Smith Sally E
Bought by
Hauptman Ronald J and Hauptman Valerie J

Home Financials for this Owner

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

Purchase Details

Closed on
May 24, 1999
Sold by
Sherf David A and Sherf Elizabeth C
Bought by
Smith W Michael G and Smith Sally E

Home Financials for this Owner

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

Similar Homes in Scottsdale, AZ

  • 12210 N 67th St, Scottsdale, AZ 85254

    $2,480,000

    • 4 Beds
    • 3 Baths
    • 3,015 Sq Ft
    • 12210 N 67th St
    • Scottsdale, AZ

    2023 FULL UPDATE! AWESOME CACTUS CORRIDOR ( SCOTTSDALE-CACTUS AA++LOCATION-1 ACRE- 4 BED 3 BATH-3015 SQ FEET-5 CAR GARAGE CUSTOM POOL, SPORT COURT( FOR RENT UNFURNISHED AT $8500 MONTH ( NO HOA! ON QUIET STREET ONLY 5 MINUTES TO KIERLAND-QUARTER-100+ RESTURANTS AND 5 MINUTES TO FREEWAY ( new wood plank flooring ( no carpet) new counter-doors-hardware- VAULTED CEILINGS-POOL- -ROOM FOR

    Brent Langbehn Realty ONE Group

    Section Image
  • 5926 E Hartford Ave, Scottsdale, AZ 85254

    $2,499,000

    • 5 Beds
    • 4 Baths
    • 3,910 Sq Ft
    • 5926 E Hartford Ave
    • Scottsdale, AZ

    Updated farmhouse-style home in a sought-after 85254 community, minutes from top Scottsdale shopping and dining. Major exterior upgrades from 2020-2024 include smooth stucco, paver drive, solar panels, and a 2022 saltwater pool/spa. Inside, enjoy vaulted ceilings with wood beams, custom built-ins, and an open floorplan. The chef's kitchen features quartz counters, tile backsplash, large island

    Jeffrey Sibbach eXp Realty

    Section Image
  • 7678 E Cactus Wren Rd, Scottsdale, AZ 85250

    $1,750,000

    • 3 Beds
    • 3.5 Baths
    • 2,700 Sq Ft
    • 7678 E Cactus Wren Rd
    • Scottsdale, AZ

    Welcome to Cactus Wren,a completely new, fully re-done home from top to bottom, no expenses spared only the finest materials, on THE BEST lot in 7600 Lincoln. Walk in, enjoy the sights and smells of a brand new home, handmade custom cabinetry, designer flooring/accents, hunter Douglass shades, completely redone pool and outdoor area, everything here IS NEW. Single level with soaring ceilings

    Alexander Prewitt Real Broker

    Section Image
  • 9869 E Davenport Dr Unit 70, Scottsdale, AZ 85260

    $2,199,000

    • 6 Beds
    • 4.5 Baths
    • 5,357 Sq Ft
    • 9869 E Davenport Dr
    • Unit 70
    • Scottsdale, AZ

    Nestled in the heart of Scottsdale this stunning 6-bedroom, 4.5-bathroom, + bonus room basement home offers over 5,300 square feet of luxurious living space. Beautifully designed floor plan features an open and spacious layout, perfect for both family living and entertaining w/high-end finishes, soaring ceilings, and an abundance of natural light. Upgrades throughout including granite tops

    Darren Tackett eXp Realty

    Section Image
  • 10179 E Camelot Ct, Scottsdale, AZ 85255

    $2,399,000

    • 3 Beds
    • 3.5 Baths
    • 3,499 Sq Ft
    • 10179 E Camelot Ct
    • Scottsdale, AZ

    Modern farmhouse charm meets functional luxury in this beautifully finished single-level home backing to the McDowell Mountain Golf Club golf course. Originally built as a showcase model in 2020 and carefully maintained since, the home features warm wood flooring throughout, 8'' baseboards, and farmhouse-inspired designer touches in every corner.The kitchen is a true standout with white shaker

    Don Matheson RE/MAX Fine Properties

    Section Image
  • 9845 E Edgestone Dr, Scottsdale, AZ 85255

    $1,700,000

    • 3 Beds
    • 2.5 Baths
    • 3,175 Sq Ft
    • 9845 E Edgestone Dr
    • Scottsdale, AZ

    Welcome to 9845 E Edgestone Dr, securely nestled in the guard-gated community of Windgate Ranch. This split floorplan features 3 bedrooms, 2.5 bathrooms, a versatile loft, plus a den. The light-filled great room seamlessly flows into the chef's kitchen, with white cabinetry, granite counters, stainless appliances, and ample storage including a walk-in pantry. The open-concept layout makes for

    Jeff Barchi RE/MAX Fine Properties

    Section Image
  • 9353 N 113th Way, Scottsdale, AZ 85259

    $1,775,000

    • 5 Beds
    • 3 Baths
    • 4,027 Sq Ft
    • 9353 N 113th Way
    • Scottsdale, AZ

    Stunning & impeccably maintained home in Stonegate's sought after ''Retreat''. This gorgeous home sits on a private N/S lot backing to a desert wash with walking path & horse trail. And for tennis lovers, the home sits directly adjacent to tennis courts. 5 BR's, 3 BA's. 3 Car Gar. Stunning wrought iron front door, polished porcelain tile flooring t/o with the exception of beautiful wood flooring

    Chase Reynolds Ventana Fine Properties

    Section Image
  • 11415 E Dreyfus Ave, Scottsdale, AZ 85259

    $2,775,000

    • 4 Beds
    • 4.5 Baths
    • 5,612 Sq Ft
    • 11415 E Dreyfus Ave
    • Scottsdale, AZ

    Modern luxury audiophile home perched high on a rare hillside Ancala lot nestled into the luxurious hills of North Scottsdale's most sought-after golf community. From your negative edge pool, enjoy the cool sunset breeze, and watch the twinkle of the city lights blend with the desert starscape. Impress friends & family with a functional & fun floorplan, room for 3 cars, fine finishes,

    Geoffrey Adams Realty ONE Group

    Section Image
  • 8502 E Santa Catalina Dr, Scottsdale, AZ 85255

    $2,350,000

    • 4 Beds
    • 3.5 Baths
    • 4,189 Sq Ft
    • 8502 E Santa Catalina Dr
    • Scottsdale, AZ

    This beautifully updated residence sits on a sprawling 1-acre lot, offering sweeping mountain views and stunning city light vistas. Completely renovated in 2017, the home has been transformed with sleek, modern finishes and luxurious touches throughout, blending style and comfort. Step inside to discover a spacious, floor plan highlighted by a family room where the centerpiece is a massive stone

    Allen Studebaker Compass

    Section Image

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
Christopher M Lamm And Mayuli B Lamm Trust -- --
Lamm Christopher $1,275,000 Premier Title Agency
Hauptman Ronald J -- None Available
Hauptman Ronald J $750,000 Transnation Title Ins Co
Smith W Michael G $610,000 Old Republic Title Agency
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Lamm Christopher $825,000
Previous Owner Hauptman Ronald J $250,000
Previous Owner Hauptman Ronald J $322,700
Previous Owner Smith W Michael G $390,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/09/2020 04/09/20 Sold $1,275,000 -5.6% $284 / Sq Ft
02/13/2020 02/13/20 Pending -- -- --
01/18/2020 01/18/20 For Sale $1,350,000 -- $301 / 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 $8,072 $110,334 -- --
2024 $7,898 $105,080 -- --
2023 $7,898 $137,970 $27,590 $110,380
2022 $7,550 $104,000 $20,800 $83,200
2021 $7,847 $96,420 $19,280 $77,140
2020 $7,722 $91,520 $18,300 $73,220
2019 $7,411 $87,980 $17,590 $70,390
2018 $7,103 $82,860 $16,570 $66,290
2017 $6,801 $79,620 $15,920 $63,700
2016 $6,611 $77,420 $15,480 $61,940
2015 $6,010 $74,150 $14,830 $59,320
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: 6025728

Arizona Regional Multiple Listing Service (ARMLS)

APN: 167-77-026