
Seller's Agent in 2022
Tsutsumi Lambrecht
Realty Executives
(480) 695-8807
1 in this area
45 Total Sales
Estimated Value: $4,023,000 - $4,185,287
AN EXQUISTE SINGLE LEVEL HOME FOR THE DISCRIMATING BUYERS SEEKING EXCEPTIONAL QUALITY OF CONSTRUCTION, UNSURPASSED ARCHITECTURAL DETAILS & ONLY THE FINEST FINISHES. IN EXCLUSIVE LADERA VISTA GATED COMMUNITY AT END OF CUL DE SAC FOR PRIVACY & UNOBSTRUCTED VIEWS OF PINNACLE PEAK, TROON MOUNTAIN, THE McDOWELL MOUNTAINS SOUTH FACING TOWARDS CAMELBACK & MUMMY MOUNTAIN. THE KITCHEN & BATHROOMS WERE REMODELED IN 2019. HOWEVER, THE DISTRESSED HARD WOOD FLOORS, THE RECLAIMED WOOD CEILINGS & DOORS, THE STAMPED COPPER CEILING IN THE OFFICE, THE STONE ACCENTS IN THE ALCOVE & CAVE BAR HAVE NOT BEEN CHANGED GIVING THE HOME AN AUTHENTICITY & UNIQUENESS THAT IS RARELY SEEN. THIS HOME HAS EVERY AMENITY TO SPOIL FAMILY & FRIENDS. IT'S AN ENTERTAINER.S DREAM HOME BOASTING A STUNNING PRIVATE BIG BACKYARD WITH LARGE HEATED POOL, REAL GRASS AND PLENTY OF ROOM FOR CHILDREN & PETS TO ROMP. A SEPARATE GUEST CASITA FEATURING SOUTHWESTERN DECOR FOR THOSE OUT OF STATE VISITORS.
THE GOURMET KITCHEN WAS REMODELED REMOVING THE RAISED ISLAND COUNTER TO OPEN THE KITCHEN TO THE GREAT ROOM. THE BUTCHER BLOCK ISLAND WAS SANDED & REINSTALLED, IT LOOKS BRAND NEW. THERE ARE TWO DISHWASHERS & A GENEROUS WALK-IN PANTRY.
THE CAVE BAR IS SOMETHING YOUR GUESTS & FAMILY WILL NEVER FORGET. THE STAIN GLASS WINDOW OPENS TO ALSO SERVE OUTDOOR REFRESHMENTS, A TV DROPS FROM THE CEILING & THERE IS A WINE COOLER BEHIND THE DISCRETE WOOD DOOR.
CHILDREN WILL BE DELIGHTED TO SEE THE BUNK ROOM WITH SPARKLING STAR LITE CEILING & BEDS TO SLEEP 8. GREAT FOR OVERFLOW GUESTS & SLEEPOVERS. OR IT CAN BE CONVERTED BACK TO A STAR LITE THEATER.
THIS IS A HOME UNLIKE NO OTHER IN THE SOUTHWEST AND WOULD BE EXTREMELY COSTLY TO DUPICATE.
THIS WORK OF ART IS BEYOND ANY PHOTOGRAPHY OR VIDEO THAT ATTEMPTS TO DEPICT IT. IT A TRUE M-U-S-T SEE!
Last Agent to Sell the Property
Realty Executives Arizona Territory License #SA523667000 Listed on: 04/22/2022
Date | Buyer | Sale Price | Title Company |
---|---|---|---|
Schodde Allen | $4,300,000 | Premier Title | |
Gehre Charles Ernie | $2,100,000 | First American Title Ins Co | |
Hingston Michael | $450,000 | Chicago Title Insurance Co | |
Katz Peter | -- | Security Title |
Date | Status | Borrower | Loan Amount |
---|---|---|---|
Open | Schodde Allen | $2,798,000 | |
Previous Owner | Gehre Charles Ernie | $645,000 | |
Previous Owner | Gehre Charles Ernie | $1,680,000 | |
Previous Owner | Hingston Michael R | $246,971 | |
Previous Owner | Hingston Michael R | $250,000 | |
Previous Owner | Hingston Michael R | $125,000 | |
Previous Owner | Hingston Michael R | $1,650,000 | |
Previous Owner | Hingston Michael | $400,000 | |
Previous Owner | Hingston Michael R | $1,650,000 | |
Previous Owner | Hingston Michael | $1,455,000 | |
Previous Owner | Hingston Michael | $405,000 | |
Previous Owner | Katz Peter | $172,000 |
Date | Event | Price | Change | Sq Ft Price |
---|---|---|---|---|
06/22/2022 06/22/22 | Sold | $4,300,000 | -4.3% | $756 / Sq Ft |
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 |
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 | -- | -- |
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,887 | $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 2022
Tsutsumi Lambrecht
Realty Executives
(480) 695-8807
1 in this area
45 Total Sales
Buyer's Agent in 2022
Garrett Shinoskie
RETSY
(480) 585-7070
2 in this area
23 Total Sales
K
Seller's Agent in 2017
Kerry Ellis
Realty One Group
S
Buyer's Agent in 2017
Steven Lambrecht
Steven A Lambrecht, LLC
(602) 686-2501
20 Total Sales
Seller's Agent in 2012
Terry Ray
Berkshire Hathaway HomeServices Arizona Properties
(480) 473-4900
3 in this area
46 Total Sales
Seller Co-Listing Agent in 2012
Lesley McGee
SERHANT.
(480) 203-6949
3 in this area
56 Total Sales
Source: Arizona Regional Multiple Listing Service (ARMLS)
MLS Number: 6388450
APN: 217-06-123