NOT LISTED FOR SALE

Estimated Value: $2,181,000 - $2,458,000

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

Sale Details

Date Sold: October 29, 2024

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

Est. 5% decrease in value since last sale

Current estimated payment $12,870 / mo

31 Days on Market

Highlights

  • Mountain View
  • Wood Flooring
  • 3 Fireplaces
  • Hopi Elementary School Rated A
  • Jettted Tub and Separate Shower in Primary Bathroom
  • Bonus Room

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

Home Design

  • Wood Frame Construction
  • Composition Roof
  • Synthetic Stucco Exterior

Interior Spaces

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

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Walk-In Pantry
  • Gas Oven
  • Gas Range
  • Built-In Microwave
  • Dishwasher
  • ENERGY STAR Qualified Appliances
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Split Bedroom Floorplan
  • Primary Bathroom is a Full Bathroom
  • Double Vanity
  • Bidet
  • Jettted Tub and Separate Shower in Primary Bathroom
  • Hydromassage or Jetted Bathtub
  • Bathtub With Separate Shower Stall

Laundry

  • Laundry in unit
  • Dryer
  • Washer

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

Additional Features

  • No Interior Steps
  • North or South Exposure

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

9,744 Sq Ft Lot

Parking

2

Listing Details

  • Cross Street: 40th Street & Campbell
  • Property Type: Residential
  • Ownership: Fee Simple
  • 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
  • Special Features: None

Interior Features

  • Flooring: Wood
  • Basement YN: No
  • Spa Features: None
  • Appliances: Dishwasher, Disposal, Refrigerator, Microwave, Gas Oven, Gas Range, Washer, Dryer
  • Total Bedrooms: 4
  • Fireplaces: 3
  • Fireplace: No
  • Interior Amenities: Full Bth Master Bdrm, Separate Shwr & Tub, Double Vanity, Tub with Jets, Bidet, Eat-in Kitchen, Breakfast Bar, Pantry, Kitchen Island, Walk-in Pantry, Non-laminate Counter, High Speed Internet, No Interior Steps
  • Living Area: 3081.0
  • Stories: 1
  • Window Features: Solar Screens, ENERGY STAR Qualified Windows, Dual Pane

Exterior Features

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

Garage/Parking

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

Utilities

  • Cooling: Central Air
  • Heating: Electric
  • Laundry Features: Engy Star (See Rmks), Inside
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: Public

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Association Fees:PAD Fee YN2: N

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.0
  • Tax Lot: 225
  • Tax Map Number: 19.0

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,315,704

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$109,296
Avg. Annual Appreciation
-3.13%
Original Mortgage
$750,000
Outstanding Balance
$739,380
Interest Rate
6.09%
Mortgage Type
New Conventional
Estimated Equity
$1,576,324

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

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

Your Personal Tour Guide

Ask me questions while you tour the home.