This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
$509,999
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
Property Description
Ready Now !!! Below Market Rate with Builder's Pref Lender, Brand-new home in hidden oasis, nestled on an 8,190 sf sq. homesite with 13ft between neighbors for added privacy. This thoughtfully designed 1-story home features 3 beds + flex space, 2.5 baths, and 3-car tandem garage. Perfect for entertaining or unwinding. The chef-inspired kitchen includes a large island, quartz countertops, 42'' upper cabinets, a wall oven/micro combo, cushion-close drawers, and walk-in pantry. Spacious dining and living areas create an inviting atmosphere. Each bedroom offers a walk-in closet, while the flex space adapts to your needs - office, media hub, gym, or playroom. The primary suite boasts a tiled shower and walk-in closet.
Full Property Details
Full Property Details for 28958 N 174th
General
- Sold For: $509,999
- HOA FEE: $110/month
- Taxes: $426 (2024)
- Status: Closed
- Type: Single Family
- Source: ARMLS_Arizona_MLS_Phoenix_Area
- MLS ID: 6835077
- Added to Site: 309 day(s) ago
Interior
- Interior Features: Double Vanity, Eat-in Kitchen, Breakfast Bar, 9+ Flat Ceilings, Soft Water Loop, Kitchen Island, Pantry, 3/4 Bath Master Bdrm
- Fireplace(s): None
- Flooring: Carpet, Tile
Rooms
Bathrooms
- Total Bathrooms: 3
Bedrooms
- Total Bedrooms: 3
Other Rooms
- Laundry: Engy Star (See Rmks), Wshr/Dry HookUp Only
Parking
- Garage: Yes
- Garage Spaces: 3
- Parking Features: Tandem Garage, Garage Door Opener
Location
- County: Maricopa
- Township: 5N
- Subdivision: Tierra Vistoso PARCEL B
- 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
- Utility Description: SW Gas
Structural Information
- 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: 2024
- Property Condition: Under Construction
Manufactured Home
- Model: Burgundy
Lot Features
- Lot Size (Acres): 0.19
- Lot Size (Sq. Ft.): 8,190
- Lot Size Source: Builder
- Lot Features: Sprinklers In Front, Desert Front
- Fencing (Description): Block
Green Features
- Energy Efficient: Energy Audit, ENERGY STAR Light Fixture
Financial Considerations
- Association Fee: $110
- Assoc Fee Freq.: Monthly
- Tax Amount: $426
- Tax Year: 2024
- 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-790
- Range: 2W
- Section: 26
- Lot Number: 78
Listed by Mattamy Arizona, LLC
Sold by Non-MLS Office
Get Pre-Approved Today
Schools
Schools serving 28958 N 174th
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 28958 N 174th
Date
Details
Price
Change
Source
8/22/2025
Sold
$509,999
—
MLS
5/08/2025
Price Reduced
$509,999
-7.11%
MLS
3/27/2025
Price Reduced
$549,046
-0.9%
MLS
3/13/2025
Listed
$554,046
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
28958 N 174th, Surprise, AZ 85387 (MLS# 6835077) is a Single Family property that was sold at $509,999 on August 22, 2025. Want to learn more about 28958 N 174th? 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.

