28788 N 174TH Lane, Surprise, AZ 85387

$514,999
Property Type: Residential Bedrooms: 3 Baths: 3 Square Footage: 2,236 Lot Size (sq. ft.): 8,190 Status: Active
Current Price: $514,999 Last Modified: 4/05/2026

Overview

Description

This gorgeous Desert Modern home is on an end, so only 1 neighbor, none behind you and open space on one side with a single level next to you, the entire community is single level. This 2200 + Has a beautify gourmet kitchen with tile back splash, mud set owners shower, 8' interior doors throughout, soft water loop and gas stub at backyard. Come see this remarkable home plan.

Listing Details MLS# 6977259

Location, Tax & Legal

House Number
28788
Compass
N
Street Name
174TH
St Suffix
Lane
City/Town Code
Surprise
State/Province
AZ
Zip Code
85387
Zip4
2441
County Code
Maricopa
Assessor Number
503-63-781
Subdivision
Tierra Vistoso - 2069
Tax Year
2026
Assessor's Map #
63
Legal Description (Abbrev)
LOT 72 TIERRA RICO PARCEL B MCR 162835
Assessor's Parcel #
781
Tax Municipality
Surprise
Taxes
0

Contract Information

Type
Exclusive Right To Sell
Ownership
Fee Simple
Co-Ownership (Fractional) Agreement YN
No

General Property Description

Dwelling Type
Single Family Residence
Dwelling Styles
Detached
Exterior Stories
Yes
# of Interior Levels
Yes
# Bedrooms
3
Full Bathrooms
2
Half Bathrooms
Yes
Total Bathrooms
3
Approx SQFT
2236
Price/SqFt
230.32
Horses
N
Model
Apple
Builder Name
Mattamy Homes
Year Built
2026
Approx Lot SqFt
8190
Approx Lot Acres
0.188
Flood Zone
No
Community Pool Y/N
No
Private Pool Y/N
No
Fireplace YN
No
Planned Comm Name
Tierra Vistoso
Marketing Name
Tierra Vistoso
Elementary School District
Nadaburg Unified School District
High School District
Nadaburg Unified School District
Elementary School
Desert Oasis Elementary School
Jr. High School
Desert Oasis Elementary School
High School
Mountainside High School

Remarks Misc

Cross Street
Jomax & 171st Ave.
Directions
From US-60, head North on 163rd Avenue. Turn Left onto Jomax Rd. Turn Right onto 171st Ave. Turn Left onto Dale Ln, Turn Right into the community on N 172nd Dr.

Legal Info

Township
5N
Range
2W
Section
26
Lot Number
2069

Basement

Basement Y/N
N

More Information

Parking Spaces

Garage Spaces
3
Slab Parking Spaces
2
Total Covered Spaces
3

Showing Notification Methods

Showing Service
Non-MLS Showing Service - See Private Remarks

Contact Info

List Agent Home Phn
480-771-8329

Special Listing Cond

N/A
Yes

Construction

Wood Frame
Yes

Const - Finish

Painted
Yes
Stucco
Yes
Low VOC Paint
Yes

Construction Status

Complete Spec Home
Yes

Roofing

Tile
Yes
Concrete
Yes

Association & Fees

HOA Y/N
Y
HOA Disclosure/Addendum Affirmation
Yes
HOA Transfer Fee
100
HOA Fee
110
HOA Paid Frequency
Monthly
HOA Name
Tierra Vistoso HOA
HOA Telephone
602-957-9191
HOA Management Company
Trestle Management
HOA Management Phone
480-422-0888
Special Assessment HOA
No
HOA 2 Y/N
N
PAD Fee Y/N
N
Cap Improvement/Impact Fee
220
Cap Improvement/Impact Fee $/%
$
Prepaid Association Fees HOA
220
Disclosure Fees HOA
220
Other Fees HOA
100
Other Fees Description
New Home Administration Fee
Land Lease Fee Y/N
N
Rec Center Fee Y/N
N
Ttl Mthly Fee Equiv
110

Lockbox Type

See Private Remarks
Yes
None
Yes

Architecture

Other
Yes

Master Bathroom

3/4 Bath Master Bdrm
Yes
Double Vanity
Yes
Private Toilet Room
Yes

Master Bedroom

Split
Yes

Additional Bedroom

Master Bedroom Walk-in Closet
Yes

Flooring

Carpet
Yes
Tile
Yes

Window Features

Dual Pane
Yes
ENERGY STAR Qualified Windows
Yes
Low-Emissivity Windows
Yes
Vinyl Frame
Yes

Community Features

Biking/Walking Path
Yes
Children's Playgrnd
Yes

Dining Area

Eat-in Kitchen
Yes
Breakfast Bar
Yes
Dining in LR/GR
Yes

Heating

Natural Gas
Yes
ENERGY STAR Qualified Equipment
Yes

Kitchen Features

Built In Recycling
Yes
Dishwasher
Yes
Disposal
Yes
Engy Star (See Rmks)
Yes
Kitchen Island
Yes
Built-in Microwave
Yes
Non-laminate Counter
Yes
Pantry
Yes
Walk-in Pantry
Yes
Gas Cooktop
Yes

Cooling

ENERGY STAR Qualified Equipment
Yes
Programmable Thmstat
Yes
Central Air
Yes

Interior Features

9+ Flat Ceilings
Yes

Laundry

Washer Hookup
Yes
Inside
Yes

Other Rooms

Great Room
Yes

Separate Den/Office

Sep Den/Office Y/N
Y

Fencing

Block
Yes

Water Source

City Water
Yes

Spa

None
Yes

Sewer

Sewer - Public
Yes

Parking Features

Tandem Garage
Yes
Direct Access
Yes
Garage Door Opener
Yes

New Financing

Cash
Yes
VA
Yes
Conventional
Yes
FHA
Yes
1031 Exchange
Yes

Energy/Green Feature

Energy Audit
Yes
ENERGY STAR Light Fixture
Yes

Green/Energy Cert

Energy Star Cert
Yes

Green/Engy Cert Year

Green/Engy Cert Year
2024

Utilities

APS
Yes
SW Gas
Yes

Existing 1st Loan

Treat as Free&Clear
Yes

Property Description

North/South Exposure
Yes

Landscaping

Dirt Back
Yes
Desert Front
Yes
Yrd Wtring Sys Front
Yes

Services

City Services
Yes

Unit Style

All on One Level
Yes

Disclosures

Agency Discl Req
Yes

Possession

Close of Escrow
Yes

Association Fee Incl

Common Area Maint
Yes

Assoc Rules/Info

Pets OK (See Rmrks)
Yes
No Visible Truck Trailer RV Boat
Yes
Rental OK (See Rmks)
Yes
FHA Approved Prjct
Yes
VA Approved Prjct
Yes
Prof Managed
Yes

Property Features

Special Listing Cond: N/A Architecture: Other Master Bathroom: 3/4 Bath Master Bdrm; Double Vanity; Private Toilet Room Master Bedroom: Split Additional Bedroom: Master Bedroom Walk-in Closet Flooring: Carpet; Tile Window Features: Dual Pane; ENERGY STAR Qualified Windows; Low-Emissivity Windows; Vinyl Frame Spa: None Community Features: Biking/Walking Path; Children's Playgrnd Dining Area: Eat-in Kitchen; Breakfast Bar; Dining in LR/GR Kitchen Features: Gas Cooktop; Disposal; Dishwasher; Built-in Microwave; Engy Star (See Rmks); Built In Recycling; Pantry; Walk-in Pantry; Non-laminate Counter; Kitchen Island Laundry: Washer Hookup; Inside Other Rooms: Great Room Interior Features: 9+ Flat Ceilings Parking Features: Direct Access; Garage Door Opener; Tandem Garage Construction: Wood Frame Const - Finish: Painted; Stucco; Low VOC Paint Construction Status: Complete Spec Home Roofing: Tile; Concrete Cooling: Central Air; Programmable Thmstat; ENERGY STAR Qualified Equipment Heating: Natural Gas; ENERGY STAR Qualified Equipment Utilities: APS; SW Gas Water Source: City Water Sewer: Sewer - Public Services: City Services Fencing: Block Property Description: North/South Exposure Landscaping: Dirt Back; Desert Front; Yrd Wtring Sys Front Lockbox Type: See Private Remarks; None Possession: Close of Escrow Unit Style: All on One Level Association Fee Incl: Common Area Maint Existing 1st Loan: Treat as Free&Clear New Financing: Cash; VA; FHA; Conventional; 1031 Exchange Disclosures: Agency Discl Req
Listing Office: Mattamy Arizona, LLC
IDX
Last Updated: April - 05 - 2026
Copyright 2026 Arizona Regional Multiple Listing Service, Inc. All rights reserved. Information Not Guaranteed and Must Be Confirmed by End User. Site contains live data.