Seller's Agent in 2026
Tsutsumi Lambrecht
Realty Executives Arizona Territory
(480) 695-8807
1 in this area
9 Total Sales
Estimated Value: $4,797,744 - $5,712,000
An Exquisite single level home for the discriminating buyers seeking exceptional quality of construction, unsurpassed architectural details and only the finest finishes. The Kitchen and bathrooms were remodeled, however a 100+ year old CO Barn was disassembled and masterfully repurposed for the wood beam ceilings, the distressed reclaimed hardwood floors, flawless 2nd bedroom reclaimed wood walls. This, along with the stamped copper ceiling in the office, the stone accents in the alcove, the massive rock fireplace, the real antler chandeliers and remarkable one of kind Cave Den Bar give this home an 1800's AZ authenticity & uniqueness that cannot be duplicated. It is an entertainer's dream home with every amenity to spoil family & friends. The stunning super private backyard has Dream Home with every amenity to spoil family & friends. The stunning super private backyard has breathtaking mountain views everywhere, large heated pool, BBQ, fireplace, firepit and multiple lounging & forever green grass areas for pets and children to romp. Your guests will enjoy the generous separate casita with Views, Euro-Kitchen, walk-in closet & washer/dryer. The current Bunk Bedroom has a magical star-lite ceiling, sleeps eight, terrific for sleep-overs & grandchildren. It can be converted back to a star-lite theater. The current owner has upgraded and/or replaced most everything mechanical, including the roof in 2023 with 10 Year Warranty, HVAC's in 2023, Tank-less water heaters in 2022, all new Crestron System 2024-2025, New Jandy 400 BTU Pool Heater & Water Feature pump in 2024 & MUCH more making this an all but new functioning home (SEE HOME SELLER'S HOME EXTENSIVE IMPROVEMENT LIST IN "DOCUMENTS". Two Plus Acre parcel leaves plenty of room to expand garages &/Or home. This One-Off Authentic Hacienda is a work of art like no other. In Scottsdale's gated Ladera Vista community. This home checks every box. Bring your Cowboy Boots!
Last Agent to Sell the Property
Realty Executives Arizona Territory License #SA523667000 Listed on: 08/14/2025
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $5,500,000 | Great American Title Agency | ||
| $4,300,000 | Premier Title | ||
| $2,100,000 | First American Title Ins Co | ||
| $450,000 | Chicago Title Insurance Co | ||
| -- | Security Title |
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Closed | $2,798,000 | ||
| Previous Owner | $645,000 | ||
| Previous Owner | $1,680,000 | ||
| Previous Owner | $246,971 | ||
| Previous Owner | $250,000 | ||
| Previous Owner | $125,000 | ||
| Previous Owner | $1,650,000 | ||
| Previous Owner | $400,000 | ||
| Previous Owner | $1,650,000 | ||
| Previous Owner | $1,455,000 | ||
| Previous Owner | $405,000 |
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 01/15/2026 01/15/26 | Sold | $5,500,000 | 0.0% | $967 / Sq Ft | |
| 10/06/2025 10/06/25 | For Sale | $5,500,000 | 0.0% | $967 / Sq Ft | |
| 10/06/2025 10/06/25 | Off Market | $5,500,000 | -- | -- | |
| 08/14/2025 08/14/25 | For Sale | $5,500,000 | +27.9% | $967 / Sq Ft | |
| 06/22/2022 06/22/22 | Sold | $4,300,000 | -4.3% | $756 / Sq Ft | View Prior Sale |
| 04/22/2022 04/22/22 | For Sale | $4,495,000 | +114.0% | $791 / Sq Ft | |
| 02/10/2017 02/10/17 | Sold | $2,100,000 | -11.9% | $369 / Sq Ft | View Prior Sale |
| 11/04/2016 11/04/16 | For Sale | $2,385,000 | 0.0% | $420 / Sq Ft | |
| 05/15/2012 05/15/12 | Rented | $7,900 | -6.0% | -- | |
| 04/13/2012 04/13/12 | Under Contract | -- | -- | -- | |
| 01/12/2012 01/12/12 | For Rent | $8,400 | -- | -- |
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| 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 | $4,937 | $103,790 | ||
| 2024 | $7,225 | $98,848 | ||
| 2023 | $7,225 | $176,950 | $35,390 | $141,560 |
| 2022 | $6,984 | $131,850 | $26,370 | $105,480 |
| 2021 | $8,824 | $131,760 | $26,350 | $105,410 |
| 2020 | $9,096 | $131,680 | $26,330 | $105,350 |
| 2019 | $9,203 | $130,810 | $26,160 | $104,650 |
| 2018 | $9,224 | $128,710 | $25,740 | $102,970 |
| 2017 | $8,883 | $122,280 | $24,450 | $97,830 |
| 2016 | $8,478 | $127,770 | $25,550 | $102,220 |
| 2015 | $7,963 | $120,970 | $24,190 | $96,780 |
Seller's Agent in 2026
Tsutsumi Lambrecht
Realty Executives Arizona Territory
(480) 695-8807
1 in this area
9 Total Sales
Buyer's Agent in 2026
Rob Madden
HomeSmart
(480) 888-1234
1 in this area
36 Total Sales
L
Buyer Co-Listing Agent in 2026
Laura Robinson
HomeSmart
(928) 300-4726
1 in this area
6 Total Sales
T
Seller's Agent in 2022
Tsutsumi Herrera-Lambrecht
Realty Executives
Buyer's Agent in 2022
Garrett Shinoskie
RETSY
(480) 585-7070
3 in this area
20 Total Sales
K
Seller's Agent in 2017
Kerry Ellis
Realty One Group
Source: Arizona Regional Multiple Listing Service (ARMLS)
MLS Number: 6915918
APN: 217-06-123
Ask me questions while you tour the home.