NOT LISTED FOR SALE

Estimated Value: $3,220,000 - $4,061,000

6 Beds
7 Baths
5,088 Sq Ft
$728/Sq Ft Est. Value

Last Sold April 15, 2022

Last sale price $3,295,400 $648 Per Sq Ft

Est. 12% increase in value since last sale

Current estimated payment $20,412/month

7 Days on Market

Highlights

  • Private Pool
  • 0.9 Acre Lot
  • Wood Flooring
  • Hopi Elementary School Rated A
  • Fireplace in Primary Bedroom
  • Main Floor Primary Bedroom

About This Home

As of April 2022

This home is so unique, so special, so charming and so incredibly beautiful. It perfectly couples rustic farmhouse living with up to the moment modern amenities. Warmth fuels every room, including a fantastic kitchen with a butcher block island, top of the line Viking appliances and farmhouse sink, a great room with a river rock fireplace that serves as an impressive focal point, a beautiful bonus room, and an exquisite primary retreat with a remarkable stone fireplace and a very pretty bathroom. Wide plank wood flooring, exposed brick, sleek marble, subway tile, impressive lighting and fixtures, and tongue and groove ceilings are just a hint of the home's exceptional finishes, and the grounds are simply stunning with stone walkways, lush landscape, vine covered walls, numerous verandas and patios, swimming pool, spa, fireplace, and built-in barbecue. Hidden behind a gracious gated entrance for ultimate privacy, it's very simple to picture this uncommon home overlooking a lake, in the middle of the pines, or as it sits in the heart of Arcadia amongst gorgeous Camelback Mountain views. The six bedrooms, including guest quarters, and seven bathrooms make this home perfect for a large family or empty nesters who love to entertain overnight guests. This sprawling residence is loaded with charisma!

Last Agent to Sell the Property

Robert Joffe

Compass License #BR029057000 Listed on: 02/17/2022

Compass

Co-Listed By

Jonah Joffe

Compass License #SA687192000

Last Buyer's Agent

Robert Joffe

ARJ Investments LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,021

Year Built

  • Built in 1915

Lot Details

  • 0.9 Acre Lot
  • Block Wall Fence
  • Private Yard
  • Grass Covered Lot

Parking

  • 3 Car Garage
  • Garage Door Opener

Home Design

  • Wood Frame Construction
  • Composition Roof
  • Stucco

Interior Spaces

  • 5,088 Sq Ft Home
  • 2-Story Property
  • Gas Fireplace
  • Family Room with Fireplace
  • 3 Fireplaces
  • Security System Owned

Kitchen

  • Eat-In Kitchen
  • Gas Cooktop

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Primary Bedroom on Main
  • Fireplace in Primary Bedroom
  • Primary Bathroom is a Full Bathroom
  • 7 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Hydromassage or Jetted Bathtub

Outdoor Features

  • Private Pool
  • Covered Patio or Porch
  • Outdoor Fireplace
  • Built-In Barbecue
  • Playground

Schools

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

Utilities

  • Central Air
  • Heating System Uses Natural Gas
  • High Speed Internet

Community Details

  • No Home Owners Association
  • Association fees include no fees
  • Arcadian Terrace Subdivision

Listing and Financial Details

  • Tax Lot 1
  • Assessor Parcel Number 128-04-074-A

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,021

Year Built

Built in 1915

Lot Details

0

Parking

3

Listing Details

  • Cross Street: Lafayette & Arcadia Drive
  • Property Type: Residential
  • Ownership: Fee Simple
  • Association Fees Land Lease Fee: N
  • Basement: N
  • Parking Spaces Total Covered Spaces: 3.0
  • Separate Den Office Sep Den Office: Y
  • Year Built: 1915
  • Tax Year: 9166
  • Directions: Arcadia Drive to Lafayette - east to property.
  • Property Sub Type: Single Family Residence
  • Horses: No
  • Lot Size Acres: 0.9
  • Co List Office Mls Id: laun001
  • Co List Office Phone: 480-776-1555
  • Subdivision Name: Arcadian Terrace
  • Architectural Style: Ranch
  • Property Attached Yn: No
  • Tax Parcel Letter: A
  • Cooling:Central Air: Yes
  • Water Source City Water: 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
  • Special Features: None

Interior Features

  • Flooring: Carpet, Wood
  • Basement YN: No
  • Spa Features: None
  • Appliances: Gas Cooktop
  • Possible Bedrooms: 8
  • Total Bedrooms: 6
  • Fireplace Features: 3+ Fireplace, Exterior Fireplace, Family Room, Master Bedroom, Gas
  • Fireplace: Yes
  • Interior Amenities: High Speed Internet, Double Vanity, Master Downstairs, Eat-in Kitchen, Pantry, Full Bth Master Bdrm, Tub with Jets
  • Living Area: 5088.0
  • Stories: 2
  • Kitchen Features:RangeOven Gas: Yes
  • Master Bathroom:Double Sinks: Yes
  • Kitchen Features Pantry: Yes
  • Other Rooms:Great Room: 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: Playground, Private Yard, Built-in Barbecue
  • Lot Features: Grass Front, Grass Back
  • Pool Features: Private
  • Disclosures: Seller Discl Avail
  • Construction Type: 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:Built-in BBQ: Yes
  • Exterior Features:Childrens Play Area: Yes
  • Exterior Features:Patio: Yes
  • Exterior Features:Pvt Yrd(s)Crtyrd(s): Yes
  • Fireplace Features Exterior Fireplace: Yes

Garage/Parking

  • Total Covered Spaces: 3.0
  • Parking Features: Garage Door Opener
  • Attached Garage: No
  • Garage Spaces: 3.0
  • Parking Features:Garage Door Opener: Yes

Utilities

  • Cooling: Central Air
  • Heating: Natural Gas
  • Security: Security System Owned
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: City Water
  • Heating:Natural Gas: 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: 39135.0
  • Parcel #: 128-04-074-A

Building Info

  • Builder Name: Unknown

Tax Info

  • Tax Annual Amount: 2021.0
  • Tax Book Number: 128.00
  • Tax Lot: 1
  • Tax Map Number: 4.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 17, 2022
Closed on
Apr 7, 2022
Sold by
Trachtenberg Family Trust
Bought by
Lind Revocable Trust
Seller's Agent
Robert Joffe
Compass
Buyer's Agent
Robert Joffe
Compass
List Price
$3,195,000
Sold Price
$3,295,400
Premium/Discount to List
$100,400
3.14%
Current Estimated Value
$3,701,667

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$406,267
Avg. Annual Appreciation
3.41%
Original Mortgage
$2,471,550
Outstanding Balance
$2,285,263
Interest Rate
2.88%
Mortgage Type
New Conventional
Estimated Equity
$1,416,404

Purchase Details

Closed on
Aug 9, 2012
Sold by
Trachtenberg Geoffey M
Bought by
Trachtenberg Geoffrey M and Trachtenberg Family Trust

Purchase Details

Closed on
Mar 24, 2011
Sold by
Trachtenberg Geoffrey M
Bought by
Trachtenberg Geoffrey Mark

Purchase Details

Closed on
Apr 15, 2009
Sold by
Fratt Peter and Fratt Margaret
Bought by
Trachtenberg Geoffrey M

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
5.17%
Mortgage Type
New Conventional

Purchase Details

Closed on
Oct 19, 2004
Sold by
Lorch Gerald J and Lorch Francoise M
Bought by
Fratt Peter and Fratt Margaret A

Home Financials for this Owner

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

Purchase Details

Closed on
Apr 2, 2003
Sold by
Lorch Gerald J and Lorch Francoise M
Bought by
Lorch Gerald J and Lorch Francoise M
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
Lind Revocable Trust $3,295,400 Wfg National Title Insurance C
Trachtenberg Geoffrey M -- None Available
Trachtenberg Geoffrey M -- None Available
Trachtenberg Geoffrey Mark -- None Available
Trachtenberg Geoffrey M $1,100,000 Greystone Title Agency
Fratt Peter $895,000 Russ Lyon Title Llc
Lorch Gerald J -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Lind Revocable Trust $2,471,550
Previous Owner Trachtenberg Geoffrey M $417,000
Previous Owner Fratt Peter $500,000
Closed Fratt Peter $175,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/15/2022 04/15/22 Sold $3,295,400 +3.1% $648 / Sq Ft
02/22/2022 02/22/22 Pending -- -- --
02/15/2022 02/15/22 For Sale $3,195,000 -- $628 / 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 $9,426 $127,564 -- --
2024 $9,225 $121,490 -- --
2023 $9,225 $205,810 $41,160 $164,650
2022 $8,823 $155,970 $31,190 $124,780
2021 $9,166 $153,960 $30,790 $123,170
2020 $9,022 $138,400 $27,680 $110,720
2019 $8,662 $142,080 $28,410 $113,670
2018 $8,306 $122,510 $24,500 $98,010
2017 $8,556 $108,200 $21,640 $86,560
2016 $8,320 $96,950 $19,390 $77,560
2015 $7,577 $95,580 $19,110 $76,470
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: 6355848

Arizona Regional Multiple Listing Service (ARMLS)

APN: 128-04-074A