This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/3
$575,153 Just Listed
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/3
Full Property Details
Full Property Details for 28917 N 174th Ave
General
- Price: $575,153
- HOA FEE: $110/month
- Taxes: (2026)
- Status: Active
- Type: Single Family
- Source: ARMLS_Arizona_MLS_Phoenix_Area
- MLS ID: 6971877
- Updated: Today (1/21/2026)
- Added to Site: Today
Interior
- Interior Features: Double Vanity, Eat-in Kitchen, Breakfast Bar, 9+ Flat Ceilings, Kitchen Island, Pantry, 3/4 Bath Master Bdrm
- Appliances: Gas Cooktop
- Flooring: Carpet, Tile
Rooms
Bathrooms
- Total Bathrooms: 4
- Full Bathrooms: 3
- Half Bathrooms: 1
Bedrooms
- Total Bedrooms: 4
Other Rooms
- Laundry: Engy Star (See Rmks), Wshr/Dry HookUp Only
Parking
- Garage: Yes
- Garage Spaces: 3
- Parking Features: Garage Door Opener, Direct Access
Location
- County: Maricopa
- Township: 5N
- Subdivision: Tierra Vistoso
- Cross Streets: Jomax & 171st Ave.
Community
- Association: Yes
- Assoc. Name: Tierra Vistoso HOA
- Assoc. Fees Include: Maintenance Grounds
Heating & Cooling
- Central air: Yes
- Air Conditioning: Yes
- Cooling Type: Central Air, ENERGY STAR Qualified Equipment, Programmable Thermostat
- Heating Type: ENERGY STAR Qualified Equipment, Natural Gas
Utilities
- Water: City Water
Structural Information
- Architectural Style: Spanish,
- Builder: Mattamy Homes
- Exterior Const.: Stucco, Wood Frame, Low VOC Paint, Painted
- Roof: Tile, Concrete
- Windows: Low-Emissivity Windows, Dual Pane, ENERGY STAR Qualified Windows, Vinyl Frame
- Sq. Ft. Source: Builder
- Year Built: 2026
- Property Condition: Under Construction
Manufactured Home
- Model: Garnet
Lot Features
- Lot Size (Acres): 0.18
- Lot Size (Sq. Ft.): 7,718
- Lot Size Source: Builder
- Lot Features: Sprinklers In Front, Corner Lot, Desert Front, Dirt Back
Green Features
- Energy Efficient: Energy Audit, ENERGY STAR Light Fixture
Financial Considerations
- Association Fee: $110
- Assoc Fee Freq.: Monthly
- Tax Year: 2026
- Terms: Cash, Conventional, 1031 Exchange, FHA, VA Loan
Disclosures and Reports
- Ownership: Fee Simple
- Legal Description: LOT 78 TIERRA RICO PARCEL B MCR 162835
- Property ID: 503-63-720
- Range: 2W
- Section: 26
- Lot Number: 2008
Listed by Mattamy Arizona, LLC
Get Pre-Approved Today
Schools
Schools serving 28917 N 174th Ave
School District:Nadaburg Unified School District
| Name | Grades | Distance |
|---|---|---|
Desert Oasis Elementary School, Surprise, AZ 17161 West Bajada Road, Surprise, AZ 85387 | PK-8 | 1.2 mi |
Disclaimer:
School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 28917 N 174th Ave
Date
Details
Price
Change
Source
1/21/2026
Listed
$575,153
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Tax History
Tax History for 28917 N 174th Ave
Year
Property Taxes
Change
Tax Assessment
Change
2025
$63
-85%
$16,965
2075%
2024
$416
-30%
$780
-81%
2023
$598
1028%
$4,200
100%
2022
$53
—
—
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Estimate the Cost
Estimate the Cost for 28917 N 174th Ave
28917 N 174th Avenue, Surprise, AZ 85387 (MLS# 6971877) is a Single Family property with 4 bedrooms and 3 full bathrooms. 28917 N 174th Avenue is currently listed for $575,153 and was received on January 21, 2026. Want to learn more about 28917 N 174th Avenue? Do you have questions about finding other Single Family real estate for sale in Surprise? You can browse all Surprise real estate or contact a Coldwell Banker agent to request more information.

