B
Seller's Agent in 2017
Brian Bair
OfferPad Brokerage, LLC
3315 N 88th Place Mesa, AZ 85207
Desert Uplands NeighborhoodEstimated Value: $2,272,000 - $2,556,000
5
Beds
4.5
Baths
7,011
Sq Ft
$348/Sq Ft
Est. Value
Highlights
- Guest House
- Play Pool
- City Lights View
- Franklin at Brimhall Elementary School Rated A
- RV Access or Parking
- 1.15 Acre Lot
About This Home
As of November 2017Spectacular custom home with stunning panoramic mountain and city views situated on over 1 acre. This sprawling 5 bedroom custom estate includes guest house, theater room, formal dining room, game room, stylish architecture w/circular family room, wet bar and over-sized 5-car garage. Recent upgrades include brand new designer interior and exterior paint and new HVAC units. Gourmet kitchen showcases high grade granite counters with stone backsplash, Wolf range, SubZero fridge and wet bar. Master retreat highlights include fireplace, separate balcony exit, his-and-her closets, dual vanities and large jetted tub. Breathtaking rooftop patio views overlook amazing backyard complete with gazebo covered fireplace, sparkling blue pool and lush green grass! Make your appointment today. Be sure to check out video.
Last Agent to Sell the Property
Brian Bair
OfferPad Brokerage, LLC License #SA569401000 Listed on: 06/09/2017
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $9,141
Year Built
- Built in 2007
Lot Details
- 1.15 Acre Lot
- Desert faces the front of the property
- Private Streets
- Wrought Iron Fence
- Front and Back Yard Sprinklers
- Sprinklers on Timer
- Hillside Location
- Private Yard
- Grass Covered Lot
Parking
- 5 Car Direct Access Garage
- Garage ceiling height seven feet or more
- Side or Rear Entrance to Parking
- Garage Door Opener
- Circular Driveway
- RV Access or Parking
Property Views
- City Lights
- Mountain
Home Design
- Santa Barbara Architecture
- Tile Roof
- Built-Up Roof
- Foam Roof
- Stone Exterior Construction
- Stucco
Interior Spaces
- 7,011 Sq Ft Home
- 2-Story Property
- Wet Bar
- Central Vacuum
- Vaulted Ceiling
- Ceiling Fan
- Gas Fireplace
- Living Room with Fireplace
- 3 Fireplaces
- Security System Owned
- Washer and Dryer Hookup
Kitchen
- Eat-In Kitchen
- Breakfast Bar
- Gas Cooktop
- Built-In Microwave
- Kitchen Island
- Granite Countertops
Flooring
- Carpet
- Stone
Bedrooms and Bathrooms
- 5 Bedrooms
- Fireplace in Primary Bedroom
- Primary Bathroom is a Full Bathroom
- 4.5 Bathrooms
- Dual Vanity Sinks in Primary Bathroom
- Hydromassage or Jetted Bathtub
- Bathtub With Separate Shower Stall
Outdoor Features
- Play Pool
- Balcony
- Covered Patio or Porch
- Outdoor Fireplace
Additional Homes
- Guest House
Schools
- Las Sendas Elementary School
- Fremont Junior High School
- Red Mountain High School
Utilities
- Zoned Heating and Cooling System
- Propane
- Shared Well
- Septic Tank
- High Speed Internet
- Cable TV Available
Community Details
- No Home Owners Association
- Association fees include no fees
- Built by Custom
- County Island To Be Provided In Escrow Subdivision
Listing and Financial Details
- Assessor Parcel Number 219-24-214-F
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
Dec 15, 2025
Sold by
Bodrero Daniel G and Bodrero Suzanne
Bought by
Bodrero Living Trust and Bodrero
Current Estimated Value
Purchase Details
Listed on
Jun 9, 2017
Closed on
Oct 5, 2017
Sold by
First International Bank & Trust
Bought by
Bodrero Daniel G and Bodrero Suzanne
Seller's Agent
Brian Bair
OfferPad Brokerage, LLC
Buyer's Agent
Christine Anthony
Russ Lyon Sotheby's International Realty
List Price
$1,600,000
Sold Price
$1,420,000
Premium/Discount to List
-$180,000
-11.25%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.59%
Original Mortgage
$720,000
Interest Rate
3.85%
Mortgage Type
New Conventional
Purchase Details
Closed on
May 13, 2015
Sold by
Millington Terrance
Bought by
Millington Terrance and Watwood Millington Rebecca
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,360,000
Interest Rate
5.75%
Mortgage Type
Adjustable Rate Mortgage/ARM
Purchase Details
Listed on
Dec 11, 2013
Closed on
Mar 18, 2014
Sold by
Diamond Tamara
Bought by
Hagan Donald L
Seller's Agent
Mario Espinoza
Scottsdale Luxury Properties
Buyer's Agent
Tony Martin
Long Realty Company
List Price
$1,699,000
Sold Price
$1,400,000
Premium/Discount to List
-$299,000
-17.6%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.71%
Original Mortgage
$800,000
Interest Rate
4.32%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Listed on
Dec 11, 2013
Closed on
Feb 25, 2014
Sold by
Diamond Tamara B
Bought by
Hagan Donald L
Seller's Agent
Mario Espinoza
Scottsdale Luxury Properties
Buyer's Agent
Tony Martin
Long Realty Company
List Price
$1,699,000
Sold Price
$1,400,000
Premium/Discount to List
-$299,000
-17.6%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$800,000
Interest Rate
4.32%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Aug 23, 2011
Sold by
Diamond Tamara K Blin
Bought by
Diamond Tamara B and Tamara Blin Trust
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$480,000
Interest Rate
4.43%
Mortgage Type
New Conventional
Purchase Details
Closed on
May 23, 2007
Sold by
Diamond Tamara and Diamond Gus
Bought by
Diamond Gus T and Diamond Tamara B
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
6.37%
Mortgage Type
New Conventional
Purchase Details
Closed on
May 13, 2004
Sold by
Anasazi Financial Corp
Bought by
Diamond Gus and Diamond Tamara
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$40,000
Interest Rate
5.77%
Mortgage Type
Seller Take Back
Purchase Details
Closed on
Mar 24, 2003
Sold by
Boa Sorte Lp
Bought by
Anasazi Financial Corp
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
Average Home Value in this Area
Purchase History
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 |
|---|---|---|---|
| Bodrero Living Trust | -- | None Listed On Document | |
| Bodrero Daniel G | $1,420,000 | First American Title Insuran | |
| Millington Terrance | -- | Accommodation | |
| Millington Terrance | -- | Driggs Title Agency Inc | |
| Millington Terrance | $1,700,000 | Driggs Title Agency Inc | |
| Hagan Donald L | -- | Accommodation | |
| Hagan Donald L | $1,400,000 | First American Title Ins Co | |
| Diamond Tamara B | -- | Stewart Title & Trust Of Pho | |
| Diamond Tamara K Blin | -- | Stewart Title & Trust Of Pho | |
| Diamond Gus T | -- | Grand Canyon Title Agency In | |
| Diamond Gus | $200,000 | Transnation Title | |
| Anasazi Financial Corp | $265,000 | Capital Title Agency Inc | |
| Anasazi Financial Corp | $267,000 | Capital Title Agency Inc |
Source: Public Records
Mortgage History
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 |
|---|---|---|---|
| Previous Owner | Bodrero Daniel G | $720,000 | |
| Previous Owner | Millington Terrance | $1,360,000 | |
| Previous Owner | Hagan Donald L | $800,000 | |
| Previous Owner | Diamond Tamara K Blin | $480,000 | |
| Previous Owner | Diamond Gus T | $500,000 | |
| Previous Owner | Diamond Gus | $40,000 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 11/16/2017 11/16/17 | Sold | $1,420,000 | -11.3% | $203 / Sq Ft | |
| 10/04/2017 10/04/17 | Pending | -- | -- | -- | |
| 06/09/2017 06/09/17 | For Sale | $1,600,000 | +14.3% | $228 / Sq Ft | |
| 04/11/2014 04/11/14 | Sold | $1,400,000 | -12.4% | $194 / Sq Ft | View Prior Sale |
| 02/24/2014 02/24/14 | Pending | -- | -- | -- | |
| 01/22/2014 01/22/14 | Price Changed | $1,599,000 | -5.9% | $222 / Sq Ft | |
| 12/11/2013 12/11/13 | For Sale | $1,699,000 | -- | $235 / Sq Ft |
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 | $9,797 | $121,556 | -- | -- |
| 2024 | $10,483 | $115,767 | -- | -- |
| 2023 | $10,483 | $150,960 | $30,190 | $120,770 |
| 2022 | $10,219 | $113,420 | $22,680 | $90,740 |
| 2021 | $10,192 | $107,580 | $21,510 | $86,070 |
| 2020 | $10,105 | $103,470 | $20,690 | $82,780 |
| 2019 | $9,319 | $103,330 | $20,660 | $82,670 |
| 2018 | $9,072 | $110,850 | $22,170 | $88,680 |
| 2017 | $9,336 | $110,280 | $22,050 | $88,230 |
| 2016 | $9,141 | $107,120 | $21,420 | $85,700 |
| 2015 | $8,540 | $99,020 | $19,800 | $79,220 |
Source: Public Records
Agents Affiliated with this Home
-
-
Christine Anthony
Buyer's Agent in 2017
Christine Anthony
Russ Lyon Sotheby's International Realty
(480) 200-0972
4 in this area
80 Total Sales
-
Renee Merritt
Buyer Co-Listing Agent in 2017
Renee Merritt
Keller Williams Arizona Realty
(480) 522-6135
56 Total Sales
-
R
Buyer Co-Listing Agent in 2017
Renee' Merritt
Keller Williams Arizona Realty
-
M
Seller's Agent in 2014
Mario Espinoza
Scottsdale Luxury Properties
-
T
Buyer's Agent in 2014
Tony Martin
Long Realty Company
Map
Source: Arizona Regional Multiple Listing Service (ARMLS)
MLS Number: 5618061
APN: 219-24-214F
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
All information should be verified by the recipient and none is guaranteed as accurate by ARMLS
Listing Information presented by local MLS brokerage: Ten-X, local REALTOR®- Arlene Richardson - (888)-952-6393
Nearby Homes
- 8925 E Rosedale Cir
- 8540 E Mcdowell Rd Unit 117
- 8540 E Mcdowell Rd Unit 122
- 8540 E Mcdowell Rd Unit 10
- 8540 E Mcdowell Rd Unit 116
- 8812 E Palm Ln
- 9113 E Odessa St
- 3506 N Crystal Peak Cir
- 3215 N 83rd St
- 8315 E Palm Ln
- 8721 E Nance St
- 2703 N 90th St
- 0 N Hawes Rd Unit 6781292
- 8157 E Sierra Morena St Unit 127
- 8430 E Teton Cir Unit 2
- 3404 N 82nd Place
- 8315 E Echo Canyon St Unit 104
- 0 N 91st Place Unit B
- 85XX E Culver St
- 8445 E Culver St
- 3323 N 88th Place
- 3309 N 88th Place
- 8800 E Quill St Unit none
- 8800 E Quill St
- 3326 N 88th Place Unit GH
- 3326 N 88th Place Unit G
- 3325 N 88th Place
- 3314 N 88th Place
- 8829 E Quill St Unit H
- 3308 N 88th Place Unit E
- 3308 N 88th Place
- 8835 E Quill St
- 0 N 88th H Place Unit H
- 3340 N 89th Place
- 8831 E Quill St
- 3324 N 88th Place Unit H
- 3324 N 88th Place Unit G
- 8827 E Quill St Unit 1
- 8827 E Quill St
- 8827 E Quill St
Your Personal Tour Guide
Ask me questions while you tour the home.