NOT LISTED FOR SALE

Estimated Value: $2,132,000 - $2,472,000

4 Beds
4 Baths
3,081 Sq Ft
$758/Sq Ft Est. Value

Last Sold October 29, 2024

Last sale price $2,425,000 $787 Per Sq Ft

Est. 4% decrease in value since last sale

Current estimated payment $12,719/month

31 Days on Market

Highlights

  • Mountain View
  • Wood Flooring
  • 3 Fireplaces
  • Hopi Elementary School Rated A
  • Hydromassage or Jetted Bathtub
  • Corner Lot

About This Home

As of October 2024

This is the perfect modern farmhouse that everyone is searching for. Built in 2023 with impeccable taste, not a detail was overlooked. From the moment you arrive, you'll be taken with the fantastic curb appeal and courtyard entry that leads to a home loaded with fresh finishes. The split bedroom, open floor plan is home to a gorgeous island kitchen with an oversized 60'' side by side refrigerator/freezer, double ovens, double dishwashers, exposed brick accents, marble countertops and custom cabinetry. All the bedrooms and baths have their own special flair including an impressive primary suite with a huge closet and exquisite bath. The bonus room is an exceptional space perfect for a playroom, man cave or teen getaway, and the great room is the center of it all with soaring ceilings, wood beams, floor to ceiling brick fireplace, and sliding glass doors that lead to the beautiful backyard with a spacious patio, built-in concrete bar with beverage fridge and beer tap, gas firepit and impeccable mountain views. Wood flooring, marble countertops, wainscoting, designer lighting, oversized picture windows and a custom bar with Scotsman icemaker and wine fridge are just a sampling of the outstanding design elements. This is a phenomenal custom home on an exceptional street in Hopi school district and walking distance from LGO and Ingos in a highly coveted area of Arcadia Lite!

Last Agent to Sell the Property

Jonah Joffe

Compass License #SA687192000 Listed on: 08/22/2024

Compass

Co-Listed By

Robert Joffe

Compass License #BR029057000

Last Buyer's Agent

Non-MLS Agent

Non-MLS Office

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,662

Year Built

  • Built in 2023

Lot Details

  • 9,744 Sq Ft Lot
  • Desert faces the back of the property
  • Block Wall Fence
  • Artificial Turf
  • Corner Lot
  • Front and Back Yard Sprinklers
  • Sprinklers on Timer
  • Private Yard

Parking

  • 2 Car Direct Access Garage
  • Garage Door Opener

Home Design

  • Wood Frame Construction
  • Composition Roof
  • Stucco

Interior Spaces

  • 3,081 Sq Ft Home
  • 1-Story Property
  • 3 Fireplaces
  • Double Pane Windows
  • ENERGY STAR Qualified Windows
  • Solar Screens
  • Wood Flooring
  • Mountain Views

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Built-In Microwave
  • ENERGY STAR Qualified Appliances
  • Kitchen Island

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bathroom is a Full Bathroom
  • 4 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Bidet
  • Hydromassage or Jetted Bathtub
  • Bathtub With Separate Shower Stall

Accessible Home Design

  • No Interior Steps

Outdoor Features

  • Balcony
  • Covered Patio or Porch
  • Outdoor Storage

Schools

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

Utilities

  • Central Air
  • Heating Available
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Association fees include no fees
  • Built by CUSTOM
  • Hacienda Granada 4 Subdivision

Listing and Financial Details

  • Tax Lot 225
  • Assessor Parcel Number 171-19-111

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,662

Year Built

Built in 2023

Lot Details

0

Parking

2

Listing Details

  • Cross Street: 40th Street & Campbell
  • Legal Info Range: 4E
  • Property Type: Residential
  • Ownership: Fee Simple
  • Association Fees Land Lease Fee: N
  • Basement: N
  • Parking Spaces Slab Parking Spaces: 2.0
  • Parking Spaces Total Covered Spaces: 2.0
  • Separate Den Office Sep Den Office: Y
  • Year Built: 2023
  • Tax Year: 2023
  • Property Sub Type: Single Family Residence
  • Horses: No
  • Lot Size Acres: 0.22
  • Co List Office Mls Id: laun001
  • Co List Office Phone: 480-776-1555
  • Subdivision Name: HACIENDA GRANADA 4
  • Architectural Style: Ranch
  • Property Attached Yn: No
  • General Property Description:PriceSqFt: 787.08
  • Dining Area:Breakfast Bar: Yes
  • Windows:Dual Pane: Yes
  • Technology:Cable TV Avail: Yes
  • Cooling:Central Air: Yes
  • Windows:Solar Screens: Yes
  • Water Source City Water: Yes
  • Technology:High Speed Internet: Yes
  • Special Features: NewHome

Interior Features

  • Flooring: Wood
  • Basement YN: No
  • Spa Features: None
  • Total Bedrooms: 4
  • Fireplace Features: 3+ Fireplace, None
  • Fireplace: No
  • Interior Amenities: High Speed Internet, Double Vanity, Eat-in Kitchen, Breakfast Bar, No Interior Steps, Kitchen Island, Pantry, Bidet, Full Bth Master Bdrm, Separate Shwr & Tub, Tub with Jets
  • Living Area: 3081.0
  • Stories: 1
  • Window Features: Solar Screens, Dual Pane, ENERGY STAR Qualified Windows
  • 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
  • Kitchen Features:Non-laminate Counter: Yes
  • Other Rooms:Family Room: Yes
  • Kitchen Features:Walk-in Pantry: Yes
  • Other Rooms:BonusGame Room: Yes
  • KitchenFeatures:Refrigerator: Yes

Exterior Features

  • Fencing: Block
  • Exterior Features: Balcony, Private Yard, Storage
  • Lot Features: Sprinklers In Rear, Sprinklers In Front, Corner Lot, Desert Back, Synthetic Grass Frnt, Synthetic Grass Back, Auto Timer H2O Front, Auto Timer H2O Back
  • Pool Features: None
  • View: Mountain(s)
  • Disclosures: Agency Discl Req, Seller Discl Avail
  • Construction Type: Synthetic Stucco, Stucco, Wood Frame, Painted
  • Patio And Porch Features: Covered Patio(s), Patio
  • Roof: Composition
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Patio: Yes
  • Exterior Features:Pvt Yrd(s)Crtyrd(s): Yes
  • Exterior Features:Balcony: Yes
  • Exterior Features:Storage: Yes

Garage/Parking

  • Total Covered Spaces: 2.0
  • Parking Features: Garage Door Opener, Direct Access, Separate Strge Area
  • Attached Garage: No
  • Garage Spaces: 2.0
  • Open Parking Spaces: 2.0
  • Parking Features:Separate Strge Area: Yes
  • Parking Features:Garage Door Opener: Yes
  • Parking Features:Direct Access: Yes

Utilities

  • Cooling: Central Air
  • Heating: Electric
  • Laundry Features: Engy Star (See Rmks)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: City Water
  • Heating:Electric: 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: 9744.0
  • Parcel #: 171-19-111

Building Info

  • Builder Name: CUSTOM

Tax Info

  • Tax Annual Amount: 5662.0
  • Tax Book Number: 171.00
  • Tax Lot: 225
  • Tax Map Number: 19.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 22, 2024
Closed on
Oct 25, 2024
Sold by
Joffe Jonah
Bought by
Bates Streator Philip and Bates Alison
Seller's Agent
Jonah Joffe
Compass
Buyer's Agent
Non-MLS Agent
Non-MLS Office
List Price
$2,599,000
Sold Price
$2,425,000
Premium/Discount to List
-$174,000
-6.69%
Views
12
Current Estimated Value
$2,335,278

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$89,722
Avg. Annual Appreciation
-3.14%
Original Mortgage
$750,000
Outstanding Balance
$739,380
Interest Rate
6.09%
Mortgage Type
New Conventional
Estimated Equity
$1,595,898

Purchase Details

Closed on
Dec 22, 2022
Sold by
Joffe Jonah and Joffe Robert E
Bought by
Joffe Jonah

Home Financials for this Owner

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

Purchase Details

Closed on
Dec 14, 2022
Sold by
Joffe Jonah
Bought by
Joffe Jonah and Joffe Erica Elizabeth

Home Financials for this Owner

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

Purchase Details

Closed on
Feb 19, 2021
Sold by
Heller Andrew
Bought by
Joffe Robert E and Joffe Amy M

Home Financials for this Owner

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

Purchase Details

Closed on
Nov 17, 2008
Sold by
Heller Andrew
Bought by
Heller Andrew

Home Financials for this Owner

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

Purchase Details

Closed on
Dec 21, 2004
Sold by
Horn Eric Z
Bought by
Heller Andrew

Home Financials for this Owner

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

Purchase Details

Closed on
Nov 12, 2004
Sold by
Heller Stephanie
Bought by
Heller Andrew

Home Financials for this Owner

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

Purchase Details

Closed on
Jan 5, 1999
Sold by
Ryan Jerome A and Ryan Patti C
Bought by
Horn Eric Z

Home Financials for this Owner

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

Purchase Details

Closed on
Sep 11, 1998
Sold by
Beeh Edward F and Beeh Beth Ann
Bought by
Ryan Jerome A and Ryan Patti C
Source: Public Records
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
Bates Streator Philip $2,425,000 Wfg National Title Insurance C
Joffe Jonah -- Wfg National Title Insurance C
Joffe Jonah -- --
Joffe Robert E $735,000 Wfg National Title Ins Co
Heller Andrew -- Fidelity National Title Ins
Heller Andrew $434,000 Equity Title Agency Inc
Heller Andrew -- Equity Title Agency Inc
Horn Eric Z $240,000 Equity Title Agency
Ryan Jerome A $220,000 Chicago Title Insurance Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Bates Streator Philip $750,000
Previous Owner Joffe Jonah $1,175,000
Previous Owner Joffe Jonah $1,175,000
Previous Owner Joffe Robert E $548,250
Previous Owner Heller Andrew $372,000
Previous Owner Heller Andrew $333,700
Previous Owner Horn Eric Z $228,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
10/29/2024 10/29/24 Sold $2,425,000 0.0% $787 / Sq Ft
09/22/2024 09/22/24 Pending -- -- --
08/28/2024 08/28/24 Off Market $2,425,000 -- --
08/22/2024 08/22/24 For Sale $2,599,000 0.0% $844 / Sq Ft
07/27/2019 07/27/19 Rented $2,800 0.0% --
07/02/2019 07/02/19 Under Contract -- -- --
06/21/2019 06/21/19 Price Changed $2,800 -6.7% $2 / Sq Ft
06/19/2019 06/19/19 Price Changed $3,000 -6.3% $2 / Sq Ft
06/13/2019 06/13/19 For Rent $3,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 $6,091 $80,472 -- --
2024 $5,662 $76,640 -- --
2023 $5,662 $132,710 $26,540 $106,170
2022 $3,271 $56,050 $11,210 $44,840
2021 $3,424 $51,260 $10,250 $41,010
2020 $3,370 $49,320 $9,860 $39,460
2019 $3,209 $46,630 $9,320 $37,310
2018 $3,107 $44,980 $8,990 $35,990
2017 $2,948 $43,820 $8,760 $35,060
2016 $2,868 $38,870 $7,770 $31,100
2015 $2,636 $36,370 $7,270 $29,100
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 6747439

Arizona Regional Multiple Listing Service (ARMLS)

APN: 171-19-111