NOT LISTED FOR SALE

37315 N 24th St Phoenix, AZ 85086

Estimated Value: $1,696,037 - $2,104,000

4 Beds
3.5 Baths
4,851 Sq Ft
$375/Sq Ft Est. Value

Last Sold December 08, 2017

Last sale price $1,225,000 $253 Per Sq Ft

Est. 49% increase in value since last sale

Current estimated payment $10,257/month

4 Days on Market

Highlights

  • Guest House
  • Heated Spa
  • Solar Power System
  • Desert Mountain Middle School Rated A-
  • RV Garage
  • Gated Parking

About This Home

As of December 2017

Extremely Rare Car Collectors Private Compound on 2.26 acres enclosed by 1226 Linear ft perimeter block wall w/2, 32ft electric gates. Sprawling Home + Casita, 4 car garage, 10,260 sq ft Detached Garage includes 7919 sq showroom, 1800 sq ft air-conditioned shop (includes 2 car lifts, tool cabinets and forklift) & 325 sq ft private office, 216 sq ft private storage area + resort style back yard oasis w/beach bar, BBQ, 650 sq ft heated pool w/slide, grotto, heated spa (see photos). Property has 67 mature palm trees. Enter this masterpiece through gates to over 20,000 sq ft of pavers. Owner has taken excellent care of this property & just installed a brand new foam roof. Solar panels were installed to help keep electric costs low & property conveys w/ a 2000/mo car storage tenant... This home and grounds have been developed and remodeled extensively since main house was built. The owner is willing to carry the mortgage for up to 5 years with a minimum of $200,000 down payment at low interest rate. Most of the furnishings including furniture, pool table, slot machines are available on separate bill of sale. This is a once in a lifetime opportunity. There is no other property like this, not even close at this price. Call for an appointment to schedule a private showing (24 hour min notice.)

Last Agent to Sell the Property

Rebecca Palmer

Re/Max Fine Properties License #SA535644000 Listed on: 10/13/2017

Re/Max Fine Properties

Last Buyer's Agent

Jeff & Lisa Armbruster

Russ Lyon Sotheby's International Realty License #SA637151000

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,065

Year Built

  • Built in 1996

Lot Details

  • 2.26 Acre Lot
  • Desert faces the front and back of the property
  • Block Wall Fence
  • Corner Lot
  • Front and Back Yard Sprinklers

Parking

  • 25 Car Detached Garage
  • 50 Open Parking Spaces
  • Garage ceiling height seven feet or more
  • Tandem Parking
  • Garage Door Opener
  • Circular Driveway
  • Gated Parking
  • RV Garage

Home Design

  • Wood Frame Construction
  • Foam Roof
  • Stucco

Interior Spaces

  • 4,851 Sq Ft Home
  • 1-Story Property
  • Wet Bar
  • Furnished
  • Vaulted Ceiling
  • Skylights
  • 2 Fireplaces
  • Two Way Fireplace
  • Gas Fireplace
  • Double Pane Windows
  • Low Emissivity Windows
  • Solar Screens
  • Mountain Views

Kitchen

  • Breakfast Bar
  • Gas Cooktop
  • Built-In Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops

Flooring

  • Carpet
  • Stone

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Remodeled Bathroom
  • Primary Bathroom is a Full Bathroom
  • 3.5 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Hydromassage or Jetted Bathtub
  • Bathtub With Separate Shower Stall

Laundry

  • Dryer
  • Washer

Pool

  • Heated Spa
  • Heated Pool

Outdoor Features

  • Covered Patio or Porch
  • Fire Pit
  • Built-In Barbecue

Schools

  • Desert Mountain Elementary
  • Boulder Creek High School

Utilities

  • Refrigerated Cooling System
  • Heating Available
  • Propane
  • Septic Tank
  • High Speed Internet

Additional Features

  • Solar Power System
  • Guest House

Community Details

  • No Home Owners Association
  • Metes And Bounds Subdivision

Listing and Financial Details

  • Tax Lot 211-67-013G
  • Assessor Parcel Number 211-67-013-G

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,065

Year Built

Built in 1996

Lot Details

0

Parking

25

Listing Details

  • Cross Street: 24th Street and Carefree Hwy
  • Legal Info Range: 3E
  • 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: 2015
  • Updated Kitchen: Partial
  • Items Updated Kitchen Yr Updated: 2014
  • Updated Plumbing: Partial
  • Items Updated Plmbg Yr Updated: 2015
  • Updated Roof: Full
  • Items Updated Roof Yr Updated: 2017
  • Parking Spaces Slab Parking Spaces: 50.0
  • Parking Spaces Total Covered Spaces: 25.0
  • Separate Den Office Sep Den Office: Y
  • Year Built: 1996
  • Spa Private: Yes
  • Tax Year: 2017
  • Directions: Go north on 24th street past Maddock to property on the east side. Look for double gated entrance
  • Property Sub Type: Single Family - Detached
  • Lot Size Acres: 2.26
  • Subdivision Name: Metes and bounds
  • Architectural Style: Ranch
  • Efficiency: Solar Panels, Sunscreen(s)
  • Property Attached Yn: No
  • Tax Parcel Letter: G
  • ResoBuildingAreaSource: Assessor
  • Dining Area:Breakfast Bar: Yes
  • Windows:Dual Pane: Yes
  • Laundry:Washer Included: Yes
  • Laundry:Dryer Included: Yes
  • Technology:High Speed Internet Available: Yes
  • Windows:Low-E: Yes
  • Utilities Butane Propane: Yes
  • Special Features: None

Interior Features

  • Flooring: Carpet, Stone
  • Spa Features: Heated, Private
  • Possible Bedrooms: 6
  • Total Bedrooms: 4
  • Fireplace Features: 2 Fireplace, Two Way Fireplace, Fire Pit, Gas
  • Fireplace: Yes
  • Interior Amenities: Walk-In Closet(s), Breakfast Bar, 9+ Flat Ceilings, Furnished(See Rmrks), Vaulted Ceiling(s), Wet Bar, Kitchen Island, Double Vanity, Full Bth Master Bdrm, Separate Shwr & Tub, Tub with Jets, High Speed Internet, Granite Counters
  • Living Area: 4851.0
  • Stories: 1
  • Window Features: Skylight(s), Double Pane Windows, Low Emissivity 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
  • Master Bathroom:Double Sinks: Yes
  • Kitchen Features:Disposal2: Yes
  • Kitchen Features:Refrigerator2: Yes
  • Other Rooms:Great Room: Yes
  • Fireplace:_two_ Fireplace: Yes
  • Fireplace:Gas Fireplace: Yes
  • Kitchen Features:Walk-in Pantry: Yes
  • Other Rooms:BonusGame Room: Yes
  • Kitchen Features:Cook Top Gas: Yes
  • Fireplace:Firepit: Yes
  • Other Rooms:Guest Qtrs-Sep Entrn: Yes
  • Kitchen Features:Multiple Ovens: Yes
  • Other Rooms:Separate Workshop: Yes
  • Fireplace:Two Way Fireplace: Yes

Exterior Features

  • Fencing: Block
  • Exterior Features: Circular Drive, Covered Patio(s), Patio, Built-in Barbecue
  • Lot Features: Sprinklers In Rear, Sprinklers In Front, Corner Lot, Desert Back, Desert Front
  • Pool Features: Heated, Private
  • View: Mountain(s)
  • Disclosures: Seller Discl Avail
  • Construction Type: Painted, Stucco, Frame - Wood
  • Other Structures: Guest House
  • Roof: Foam
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Built-in BBQ: Yes
  • Exterior Features:Circular Drive: Yes
  • Exterior Features:Patio: Yes
  • Exterior Features:Separate Guest House: Yes

Garage/Parking

  • Total Covered Spaces: 25.0
  • Parking Features: Attch'd Gar Cabinets, Electric Door Opener, Extnded Lngth Garage, Over Height Garage, RV Gate, Separate Strge Area, Detached, Tandem, RV Access/Parking, Gated, RV Garage
  • Attached Garage: No
  • Garage Spaces: 25.0
  • Open Parking Spaces: 50.0
  • Parking Features:Electric Door Opener: Yes
  • Parking Features:Attch_squote_d Gar Cabinets: Yes
  • Parking Features:RV Gate: Yes
  • Parking Features:Extnded Lngth Garage: Yes
  • Parking Features:RV Parking: Yes
  • Parking Features:Gated Parking: Yes
  • Parking Features:Separate Strge Area: Yes
  • Parking Features:Detached: Yes
  • Parking Features:Tandem Garage: Yes
  • Parking Features:Over Height Garage: Yes
  • Parking Features:RV Garage: Yes

Utilities

  • Utilities: Propane
  • Cooling: Refrigeration
  • Heating: Electric
  • Laundry Features: Dryer Included, Washer Included
  • Water Source: City Water
  • Heating:Electric: Yes
  • Sewer Septic Tank: 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: Desert Mountain Elementary
  • High School: Boulder Creek High School
  • Middle Or Junior School: Desert Mountain Elementary

Lot Info

  • Land Lease: No
  • Lot Size Sq Ft: 98383.0
  • Parcel #: 211-67-013-G
  • ResoLotSizeUnits: SquareFeet

Building Info

  • Builder Name: Unknown

Tax Info

  • Tax Annual Amount: 6065.0
  • Tax Book Number: 211.00
  • Tax Lot: 211-67-013G
  • Tax Map Number: 67.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Oct 27, 2020
Sold by
Kennedy Jerry
Bought by
Kennedy Jerry L and Jerry Kennedy 2009 Trust
Current Estimated Value
$1,819,509

Purchase Details

Listed on
Oct 13, 2017
Closed on
Nov 29, 2017
Sold by
Ebert David and The Ebert Living Trust
Bought by
Kennedy Jerry
Seller's Agent
Rebecca Palmer
Re/Max Fine Properties
Buyer's Agent
Jeff & Lisa Armbruster
Russ Lyon Sotheby's International Realty
List Price
$1,249,900
Sold Price
$1,225,000
Premium/Discount to List
-$24,900
-1.99%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.21%
Original Mortgage
$925,000
Interest Rate
3.94%
Mortgage Type
Seller Take Back

Purchase Details

Closed on
May 31, 2017
Sold by
Ebert David Carl and Ebert David
Bought by
Ebert David and Ebert Living Trust

Purchase Details

Closed on
Jul 1, 2014
Sold by
Schwichtenberg Deborah M and Schwichtenbrg Alan J
Bought by
Schwichtenberg Alan J

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$141,000
Interest Rate
4.07%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
Mar 14, 2014
Sold by
Ebert David
Bought by
Ebert David C

Home Financials for this Owner

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

Purchase Details

Closed on
Jun 18, 2012
Sold by
Ebert Michelle
Bought by
Ebert David

Home Financials for this Owner

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

Purchase Details

Closed on
Jun 7, 2012
Sold by
Schwichtenberg Alan J
Bought by
Ebert David

Home Financials for this Owner

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

Purchase Details

Closed on
Feb 15, 2006
Sold by
Sandford James A
Bought by
Schwichtenberg Alan J

Home Financials for this Owner

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

Purchase Details

Closed on
Feb 14, 2006
Sold by
Schwichtenberg Debbie
Bought by
Schwichtenberg Alan J

Home Financials for this Owner

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

Purchase Details

Closed on
Sep 21, 2005
Sold by
Matthews Merrily
Bought by
Sandford James A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$630,000
Interest Rate
7.85%
Mortgage Type
Fannie Mae Freddie Mac

Purchase Details

Closed on
Aug 16, 2005
Sold by
Jennings John
Bought by
37315 N 24Th Street Trust

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$630,000
Interest Rate
7.85%
Mortgage Type
Fannie Mae Freddie Mac

Purchase Details

Closed on
May 7, 2003
Sold by
Oglesby Scot and Oglesby Lori
Bought by
Jennings John

Home Financials for this Owner

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

Purchase Details

Closed on
Nov 8, 1995
Sold by
Stillman Justin B
Bought by
Oglesby Scot and Oglesby Lori

Purchase Details

Closed on
Mar 5, 1994
Sold by
Morgan Elmer L
Bought by
Stillman Justin B

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$25,000
Interest Rate
7.59%
Mortgage Type
Seller Take Back
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
Kennedy Jerry L -- None Available
Kennedy Jerry $1,225,000 Fidelity National Title Agen
Ebert David -- None Available
Ebert David -- None Available
Schwichtenberg Alan J -- Grand Canyon Title Agency In
Ebert David C -- Great American Title Agency
Ebert David -- Great American Title Agency
Ebert David $950,000 Great American Title Agency
Schwichtenberg Alan J $700,000 Netco
Schwichtenberg Alan J -- Netco
Sandford James A -- Netco Title
Sandford James A -- Netco Title
37315 N 24Th Street Trust -- Netco Title
Jennings John -- Netco Title
Jennings John $457,000 Land Title Agency Of Az Inc
Oglesby Scot $35,000 Grand Canyon Title Agency In
Stillman Justin B $30,000 Security Title Agency
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Kennedy Jerry L $700,000
Closed Kennedy Jerry $925,000
Previous Owner Ebert David C $141,000
Previous Owner Ebert David C $417,000
Previous Owner Ebert David $700,000
Previous Owner Schwichtenberg Alan J $250,000
Previous Owner Schwichtenberg Alan J $400,000
Previous Owner Schwichtenberg Alan J $400,000
Previous Owner Sandford James A $630,000
Previous Owner Jennings John $50,000
Previous Owner Jennings John $99,000
Previous Owner Jennings John $365,600
Previous Owner Jennings John $91,400
Previous Owner Stillman Justin B $25,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/08/2017 12/08/17 Sold $1,225,000 -2.0% $253 / Sq Ft
10/13/2017 10/13/17 For Sale $1,249,900 +2.0% $258 / Sq Ft
10/13/2017 10/13/17 Off Market $1,225,000 -- --
10/12/2017 10/12/17 For Sale $1,249,900 -- $258 / 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 $6,757 $90,344 -- --
2024 $6,681 $86,042 -- --
2023 $6,681 $95,130 $19,020 $76,110
2022 $6,449 $80,050 $16,010 $64,040
2021 $6,754 $75,930 $15,180 $60,750
2020 $6,667 $71,970 $14,390 $57,580
2019 $6,486 $74,450 $14,890 $59,560
2018 $6,279 $72,070 $14,410 $57,660
2017 $6,065 $70,260 $14,050 $56,210
2016 $5,713 $71,270 $14,250 $57,020
2015 $5,181 $64,080 $12,810 $51,270
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: 5673639

Arizona Regional Multiple Listing Service (ARMLS)

APN: 211-67-013G