B
Seller's Agent in 2023
Brittany Palma
1st Heritage Realty
5175 N Glencoe Rd Tucson, AZ 85749
Estimated Value: $1,014,000 - $1,101,509
3
Beds
3.5
Baths
3,046
Sq Ft
$345/Sq Ft
Est. Value
Highlights
- New Construction
- Panoramic View
- 3.42 Acre Lot
- Agua Caliente Elementary School Rated A
- Gated Community
- Modern Architecture
About This Home
As of December 2023New Construction, Acacia floorplan in gated community by Fairfield Homes sprawled across 3.4 acres. Mesmerizing mountain views and city lights frame this architectural masterpiece. Thoughtfully designed split floorplan features lavish bedroom en-suites, while the gourmet kitchen boasts a capacious walk-in pantry. Revel in the grandeur of 12' ceilings gracing the living spaces, adorned with walk-in closets, a warm fireplace, and a seamless flow to the generous patio, showcasing panoramic mountain views through expansive glass doors. Your oasis of refinement awaits. Privacy and luxury combined!
Last Agent to Sell the Property
Brittany Palma
1st Heritage Realty Listed on: 08/21/2023
Co-Listed By
Kenneth Hutson
1st Heritage Realty
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $2,142
Year Built
- Built in 2022 | New Construction
Lot Details
- 3.42 Acre Lot
- Gated Home
- Block Wall Fence
- Native Plants
- Paved or Partially Paved Lot
- Hillside Location
- Property is zoned Pima County - SR
Property Views
- Panoramic
- City
- Mountain
Home Design
- Modern Architecture
- Built-Up Roof
- Stucco Exterior
Interior Spaces
- 3,046 Sq Ft Home
- 1-Story Property
- Ceiling height of 9 feet or more
- Gas Fireplace
- Double Pane Windows
- Garden Windows
- Entrance Foyer
- Great Room with Fireplace
- Dining Area
- Home Office
- Ceramic Tile Flooring
Kitchen
- Walk-In Pantry
- Electric Oven
- Gas Cooktop
- Microwave
- Dishwasher
- Stainless Steel Appliances
- Disposal
Bedrooms and Bathrooms
- 3 Bedrooms
- Split Bedroom Floorplan
- Walk-In Closet
- Powder Room
- Dual Vanity Sinks in Primary Bathroom
- Bathtub with Shower
Laundry
- Laundry Room
- Sink Near Laundry
Home Security
- Carbon Monoxide Detectors
- Fire and Smoke Detector
- Fire Sprinkler System
Parking
- 3 Car Garage
- Garage Door Opener
- Driveway
Accessible Home Design
- No Interior Steps
- Smart Technology
Schools
- Agua Caliente Elementary School
- Emily Gray Middle School
- Tanque Verde High School
Utilities
- Forced Air Zoned Cooling and Heating System
- Heating System Uses Natural Gas
- Natural Gas Water Heater
- Septic System
Additional Features
- North or South Exposure
- Covered Patio or Porch
Community Details
Overview
- Property has a Home Owners Association
- Association fees include common area maintenance, gated community
- Built by FH Stone Canyon Cons
- Mira Vista Estates Subdivision
- The community has rules related to deed restrictions
Security
- Gated Community
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Aug 21, 2023
Closed on
Dec 12, 2023
Sold by
Glencoe Road Llc
Bought by
Marcotte Matthew Robert
Seller's Agent
Brittany Palma
1st Heritage Realty
Buyer's Agent
Matt Marcotte
Tierra Antigua Realty
List Price
$1,275,000
Sold Price
$1,045,000
Premium/Discount to List
-$230,000
-18.04%
Views
58
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$6,503
Avg. Annual Appreciation
0.30%
Original Mortgage
$766,550
Outstanding Balance
$751,208
Interest Rate
7.5%
Mortgage Type
New Conventional
Estimated Equity
$300,295
Purchase Details
Listed on
Aug 21, 2023
Closed on
Dec 1, 2023
Sold by
Desert Squirrel Land Hldg Llc
Bought by
Glencoe Road Llc
Seller's Agent
Brittany Palma
1st Heritage Realty
Buyer's Agent
Matt Marcotte
Tierra Antigua Realty
List Price
$1,275,000
Sold Price
$1,045,000
Premium/Discount to List
-$230,000
-18.04%
Views
58
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$766,550
Outstanding Balance
$751,208
Interest Rate
7.5%
Mortgage Type
New Conventional
Estimated Equity
$300,295
Purchase Details
Closed on
Sep 15, 2021
Sold by
Mastroberte Stephen and Mastroberte Anna
Bought by
Desert Squirrel Land Holdings Llc
Purchase Details
Listed on
Mar 3, 2016
Closed on
Oct 11, 2019
Sold by
Hammond Aaron S and Hammond Anna M
Bought by
Mastroberte Stephen and Mastroberte Anna
Seller's Agent
Rick Sack
Long Realty
Buyer's Agent
David Williamson
Fairfield Homes
List Price
$91,500
Sold Price
$91,500
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
48.17%
Purchase Details
Closed on
Feb 4, 2011
Sold by
Young Irwin M and Young Adrienne
Bought by
Hammond Aaron S and Hammond Anna M
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$220,000
Interest Rate
4.84%
Mortgage Type
New Conventional
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
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Marcotte Matthew Robert | $1,045,000 | Pioneer Title | |
| Glencoe Road Llc | -- | Pioneer Title | |
| Glencoe Road Llc | -- | Pioneer Title | |
| Desert Squirrel Land Holdings Llc | $236,650 | Signature Ttl Agcy Of Az Llc | |
| Desert Squirrel Land Holdings Llc | $236,650 | Signature Ttl Agcy Of Az Llc | |
| Mastroberte Stephen | $91,500 | Signature Ttl Agcy Of Az Llc | |
| Hammond Aaron S | $140,000 | Tstti |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Marcotte Matthew Robert | $766,550 | |
| Previous Owner | Hammond Aaron S | $220,000 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 12/21/2023 12/21/23 | Sold | $1,045,000 | +4.5% | $343 / Sq Ft | |
| 12/11/2023 12/11/23 | Pending | -- | -- | -- | |
| 11/06/2023 11/06/23 | Price Changed | $999,999 | -21.6% | $328 / Sq Ft | |
| 08/21/2023 08/21/23 | For Sale | $1,275,000 | +1293.4% | $419 / Sq Ft | |
| 11/12/2019 11/12/19 | Sold | $91,500 | 0.0% | $1 / Sq Ft | View Prior Sale |
| 10/13/2019 10/13/19 | Pending | -- | -- | -- | |
| 03/03/2016 03/03/16 | For Sale | $91,500 | -- | $1 / Sq Ft |
Source: MLS of Southern Arizona
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 |
|---|---|---|---|---|
| 2026 | $7,081 | $71,283 | -- | -- |
| 2025 | $7,081 | $67,889 | -- | -- |
| 2024 | $6,744 | $20,316 | -- | -- |
| 2023 | $2,241 | $19,349 | $0 | $0 |
| 2022 | $2,142 | $18,428 | $0 | $0 |
| 2021 | $2,176 | $17,550 | $0 | $0 |
| 2020 | $2,204 | $17,550 | $0 | $0 |
| 2019 | $2,285 | $17,550 | $0 | $0 |
| 2018 | $2,659 | $22,500 | $0 | $0 |
| 2017 | $3,116 | $22,500 | $0 | $0 |
| 2016 | $2,966 | $22,500 | $0 | $0 |
| 2015 | $3,200 | $24,000 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
-
K
Seller Co-Listing Agent in 2023
Kenneth Hutson
1st Heritage Realty
-
Matt Marcotte
M
Buyer's Agent in 2023
Matt Marcotte
Tierra Antigua Realty
(520) 909-6985
2 in this area
14 Total Sales
-
Rick Sack
Seller's Agent in 2019
Rick Sack
Long Realty
(520) 529-8619
13 in this area
155 Total Sales
-
D
Buyer's Agent in 2019
David Williamson
Fairfield Homes
Map
Source: MLS of Southern Arizona
MLS Number: 22317965
APN: 205-30-013K
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.
The data relating to real estate listings on this website comes in part from the Internet Data Exchange (IDX) program of Multiple Listing Service of Southern Arizona. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Listings provided by brokerages other than Ten-X are identified with the MLSSAZ IDX Logo. All Information Is Deemed Reliable But Is Not Guaranteed Accurate. Listing information Copyright 2026 MLS of Southern Arizona. All Rights Reserved.
Nearby Homes
- 12526 E Mira Vista Canyon Place Unit 19
- 12493 E Mira Vista Canyon Place Unit 17
- 5231 N Winnetka Ct
- 12550 E Horsehead Rd
- 12130 E Quesada Place
- 12165 E Quesada Place Unit 33
- 12989 E Cabeza de Vaca St Unit Lot B
- 12969 E Cabeza de Vaca St Unit Lot D
- 13013 E Cabeza de Vaca St Unit Lot C
- 12979 E Cabeza de Vaca St Unit Lot E
- TBD E Cabeza de Vaca St
- 12959 E Cabeza de Vaca St Unit Lot A
- 12959 E Cabeza de Vaca St
- 11878 E Ponce de Leon
- 11900 E Ponce de Leon
- 11665 E Balboa Place Unit 18
- 12600 E Thunderbird Trail Unit 8
- 11200 E Camino Del Sahuaro
- 11175 E Sunrise Ranch Place
- 3898 N Camino Ojo de Agua
- 5175 N Glencoe Rd Unit Lot 13K
- 5175 N Glencoe Rd Unit Lot 35
- 5120 N Indian Horse Trail
- 5101 N Glencoe Rd
- 5050 N Indian Horse Trail
- 5100 N Glencoe Rd
- 5245 N Glencoe Rd
- 5240 N Glencoe Rd
- 12525 E Horsehead Rd
- 5189 N Glencoe Rd
- 12496 E Mira Vista Canyon Place
- 5130 N Silver Dr
- 12336 E Mira Vista Canyon Place
- 5120 N Silver Dr
- 5000 N Indian Horse Trail
- 12499 E Horsehead Rd
- 5277 N Falcon Crest Place
- 5250 N Winnetka Ct
- 12526 E Mira Vista Canyon Place
- 12431 E Horsehead Rd