NOT LISTED FOR SALE

Estimated Value: $4,176,000 - $5,484,943

5 Beds
4.5 Baths
5,992 Sq Ft
$829/Sq Ft Est. Value

Last Sold October 11, 2024

Last sale price $4,100,000 $684 Per Sq Ft

Est. 21% increase in value since last sale

Current estimated payment $28,144/month

336 Days on Market

Highlights

  • Guest House
  • Private Pool
  • Mountain View
  • Hopi Elementary School Rated A
  • 0.71 Acre Lot
  • Outdoor Fireplace

About This Home

As of October 2024

Unobstructed views of Camelback at this large lot high bone Santa Barbara transitional in Arcadia proper. Split floorplan with generous master amenities and office on one side, kids wing with kids living all en-suite with large closets and separate guest. Wine room, formal dining and game room in addition to open indoor outdoor formal living. Front home can be sold in conjunction with second guest house home and adjoining lot off 54th. Quiet street with no power lines, no alley and huge eat in kitchen and bar. Front yard al fresco dining and outdoor fireplace, back yard large north facing patios and resort style pool. Ideal entertaining home. Grass and turf details, lookout deck, newer build.

Last Agent to Sell the Property

Katrina Barrett

Walt Danley Local Luxury Christie's International Real Estate Brokerage Phone: 520-403-5270 License #BR578628000 Listed on: 10/06/2023

Walt Danley Local Luxury Christie's International Real Estate

Last Buyer's Agent

Joelle Addante

Compass License #SA653506000

Compass

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $21,505

Year Built

  • Built in 2013

Lot Details

  • 0.71 Acre Lot
  • Cul-De-Sac
  • Block Wall Fence
  • Front and Back Yard Sprinklers

Parking

  • 4 Car Garage

Home Design

  • Santa Barbara Architecture
  • Wood Frame Construction
  • Tile Roof
  • Foam Roof
  • Stone Exterior Construction
  • Stucco

Interior Spaces

  • 5,992 Sq Ft Home
  • 1-Story Property
  • Wet Bar
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • 3 Fireplaces
  • Gas Fireplace
  • Mountain Views

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Kitchen Island

Flooring

  • Carpet
  • Stone

Bedrooms and Bathrooms

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

Pool

  • Private Pool
  • Diving Board

Outdoor Features

  • Balcony
  • Covered Patio or Porch
  • Outdoor Fireplace

Additional Homes

  • Guest House

Schools

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

Utilities

  • Zoned Heating and Cooling System
  • High Speed Internet

Community Details

  • No Home Owners Association
  • Association fees include no fees
  • Royal Terrace Amd Subdivision

Listing and Financial Details

  • Tax Lot 8
  • Assessor Parcel Number 172-33-037

Home Details

Home Type

Single Family

Est. Annual Taxes

$21,505

Year Built

Built in 2013

Lot Details

0

Parking

4

Listing Details

  • Cross Street: Camelback Rd & 54th st.
  • Legal Info Range: 4E
  • Property Type: Residential
  • Ownership: Fee Simple
  • Association Fees Land Lease Fee: N
  • Basement: N
  • Parking Spaces Total Covered Spaces: 4.0
  • Separate Den Office Sep Den Office: Y
  • Year Built: 2013
  • Tax Year: 2022
  • Property Sub Type: Single Family Residence
  • Horses: No
  • Lot Size Acres: 0.71
  • Subdivision Name: ROYAL TERRACE AMD
  • Architectural Style: Santa Barbara/Tuscan
  • Efficiency: Multi-Zones
  • Property Attached Yn: No
  • General Property Description:PriceSqFt: 684.24
  • Dining Area:Breakfast Bar: Yes
  • Cooling:Ceiling Fan(s): Yes
  • Cooling:Central Air: Yes
  • Water Source City Water: Yes
  • Fireplace Features Gas Fireplace: Yes
  • Technology:High Speed Internet: Yes
  • Special Features: None

Interior Features

  • Flooring: Carpet, Stone
  • Basement YN: No
  • Spa Features: None
  • Total Bedrooms: 5
  • Fireplace Features: 3+ Fireplace, Exterior Fireplace, Gas
  • Fireplace: Yes
  • Interior Amenities: High Speed Internet, Double Vanity, Eat-in Kitchen, Breakfast Bar, 9+ Flat Ceilings, Wet Bar, Kitchen Island, Pantry, Full Bth Master Bdrm, Separate Shwr & Tub, Tub with Jets
  • Living Area: 5992.0
  • Stories: 1
  • Kitchen Features:Kitchen Island: Yes
  • Master Bathroom:Double Sinks: Yes
  • Kitchen Features Pantry: Yes
  • Other Rooms:Great Room: Yes
  • Other Rooms:BonusGame Room: Yes
  • Other Rooms:Guest Qtrs-Sep Entrn: Yes
  • KitchenFeatures:Refrigerator: Yes

Exterior Features

  • Fencing: Block
  • Exterior Features: Balcony
  • Lot Features: Sprinklers In Rear, Sprinklers In Front, Cul-De-Sac
  • Pool Features: Diving Pool, Private
  • View: Mountain(s)
  • Disclosures: Agency Discl Req, Seller Discl Avail
  • Construction Type: Stucco, Wood Frame, Stone
  • Other Structures: Separate Guest House
  • Patio And Porch Features: Covered Patio(s), Patio
  • Roof: Tile, Foam
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Patio: Yes
  • Exterior Features:Balcony: Yes
  • Exterior Features:Separate Guest House: Yes
  • Fireplace Features Exterior Fireplace: Yes

Garage/Parking

  • Total Covered Spaces: 4.0
  • Garage Spaces: 4.0

Utilities

  • Cooling: Central Air, Ceiling Fan(s)
  • Heating: Electric
  • Security: Fire Sprinkler System
  • 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: 30714.0
  • Parcel #: 172-33-037

Building Info

  • Builder Name: Unknown

Tax Info

  • Tax Annual Amount: 21505.0
  • Tax Book Number: 172.00
  • Tax Lot: 8
  • Tax Map Number: 33.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Aug 28, 2025
Sold by
Carreon Michael
Bought by
Carreon Michael and Felicioni Rachel
Current Estimated Value
$4,965,981

Purchase Details

Listed on
Oct 6, 2023
Closed on
Oct 4, 2024
Sold by
Jmmal Mariposa Llc
Bought by
Carreon Michael Ward
Seller's Agent
Katrina Barrett
Walt Danley Local Luxury Christie's International Real Estate
Buyer's Agent
Joelle Addante
Compass
List Price
$4,500,000
Sold Price
$4,100,000
Premium/Discount to List
-$400,000
-8.89%
Views
156

Home Financials for this Owner

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

Purchase Details

Closed on
Jan 31, 2020
Sold by
Larmore Jonathan M
Bought by
Jmmal Mariposa Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$2,137,500
Interest Rate
4%
Mortgage Type
New Conventional

Purchase Details

Closed on
Dec 20, 2019
Sold by
Larmore Michelle A and Larmore Jonathan M
Bought by
Larmore Jonathan M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$2,137,500
Interest Rate
4%
Mortgage Type
New Conventional

Purchase Details

Closed on
Feb 27, 2019
Sold by
Larmore Jonathan M
Bought by
Jmmal Mariposa Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$2,250,000
Interest Rate
5.62%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Feb 11, 2019
Sold by
Larmore Michelle A and Larmore Jonathan M
Bought by
Larmore Jonathan M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$2,250,000
Interest Rate
5.62%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
May 16, 2014
Sold by
Larmore Jonathan M
Bought by
Jmmal Mariposa Llc

Home Financials for this Owner

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

Purchase Details

Closed on
Nov 15, 2012
Sold by
Csl Investments Llc
Bought by
Jmmal Mariposa Llc

Home Financials for this Owner

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

Purchase Details

Closed on
Jun 26, 2008
Sold by
Larmore Jonathan M and Larmore Michelle A
Bought by
Csl Investments Llc

Purchase Details

Closed on
Jan 5, 2005
Sold by
Hoecker Thomas R and Hoecker V
Bought by
Larmore Jonahan M and Larmore Michelle A

Home Financials for this Owner

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

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
Carreon Michael -- Accommodation/Courtesy Recordi
Carreon Michael Ward $4,100,000 Magnus Title Agency
Jmmal Mariposa Llc -- None Available
Larmore Jonathan M -- First American Title Ins Co
Larmore Jonathan M -- First American Title Ins Co
Jmmal Mariposa Llc -- None Available
Larmore Jonathan M -- Premier Title Agency Uninsur
Larmore Jonathan M -- Premier Title Agency Uninsur
Jmmal Mariposa Llc -- Accommodation
Larmore Jonathan M -- Lawyers Title Of Arizona Inc
Larmore Jonathan M -- Lawyers Title Of Arizona Inc
Jmmal Mariposa Llc -- First American Title
Csl Investments Llc $1,050,000 None Available
Larmore Jonahan M $1,050,000 Lawyers Title Ins
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Carreon Michael Ward $3,000,000
Previous Owner Larmore Jonathan M $2,137,500
Previous Owner Larmore Jonathan M $2,250,000
Previous Owner Larmore Jonathan M $1,900,000
Previous Owner Jmmal Mariposa Llc $1,300,000
Previous Owner Larmore Jonahan M $840,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
10/11/2024 10/11/24 Sold $4,100,000 -3.5% $684 / Sq Ft
09/03/2024 09/03/24 Price Changed $4,250,000 -5.6% $709 / Sq Ft
06/25/2024 06/25/24 Price Changed $4,500,000 0.0% $751 / Sq Ft
06/25/2024 06/25/24 For Sale $4,500,000 0.0% $751 / Sq Ft
06/18/2024 06/18/24 Price Changed $4,500,000 0.0% $751 / Sq Ft
06/18/2024 06/18/24 For Sale $4,500,000 0.0% $751 / Sq Ft
04/26/2024 04/26/24 Price Changed $4,500,000 -10.0% $751 / Sq Ft
03/08/2024 03/08/24 Price Changed $5,000,000 -16.7% $834 / Sq Ft
10/06/2023 10/06/23 For Sale $6,000,000 -- $1,001 / 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 $23,959 $291,131 -- --
2024 $22,422 $277,268 -- --
2023 $22,422 $370,830 $74,160 $296,670
2022 $21,505 $284,730 $56,940 $227,790
2021 $22,289 $287,780 $57,550 $230,230
2020 $21,960 $260,260 $52,050 $208,210
2019 $21,138 $244,770 $48,950 $195,820
2018 $20,327 $215,550 $43,110 $172,440
2017 $19,529 $210,270 $42,050 $168,220
2016 $19,026 $196,420 $39,280 $157,140
2015 $17,441 $191,280 $38,250 $153,030
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 6614650

Arizona Regional Multiple Listing Service (ARMLS)

APN: 172-33-037