Seller's Agent in 2025
Tamra Lee Ulmer
Arizona Resource Realty
(928) 474-2550
322 Total Sales
15515 N 174th Ave Surprise, AZ 85388
Estimated Value: $511,000 - $574,000
5
Beds
3
Baths
3,166
Sq Ft
$169/Sq Ft
Est. Value
Highlights
- Play Pool
- RV Gated
- Granite Countertops
- Canyon Ridge Rated A-
- Wood Flooring
- 5-minute walk to Dick McComb / Surprise Farms Community Park
About This Home
As of September 2025Gorgeous Family Home with a TON of added Features; Ceramic Tile Flooring 5 Bedrooms and 3 bathrooms with a huge Loft area Upstairs, Huge Master Bedroom w Double Sinks in Bathroom. Kitchen Boast plenty of Upgraded Maple Cabinets, Corian Counter Tops, Gas Stove, Double Ovens and Microwave. Out Back Enjoy your Resort Like Back Yard, Full Covered Patio, with Pool Fence, Pebble Tec Pool w/ Rock Water Feature, Family Fun Ready! RV Gate, Fresh Exterior Paint. Nice Quiet Park right across the street. Refrigerator can be purchased outside of escrow, shed on north side does not convey.
Last Agent to Sell the Property
Arizona Resource Realty License #BR518926000 Listed on: 07/24/2025
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $1,756
Year Built
- Built in 2005
Lot Details
- 6,578 Sq Ft Lot
- Desert faces the front of the property
- Artificial Turf
- Misting System
- Front and Back Yard Sprinklers
- Sprinklers on Timer
- Private Yard
HOA Fees
- $96 Monthly HOA Fees
Parking
- 3 Car Direct Access Garage
- RV Gated
Home Design
- Wood Frame Construction
- Tile Roof
- Stucco
Interior Spaces
- 3,166 Sq Ft Home
- 2-Story Property
- Ceiling Fan
- Family Room with Fireplace
Kitchen
- Eat-In Kitchen
- Breakfast Bar
- Built-In Gas Oven
- Gas Cooktop
- Built-In Microwave
- ENERGY STAR Qualified Appliances
- Granite Countertops
Flooring
- Wood
- Carpet
- Laminate
- Tile
Bedrooms and Bathrooms
- 5 Bedrooms
- Primary Bathroom is a Full Bathroom
- 3 Bathrooms
- Bathtub With Separate Shower Stall
Pool
- Play Pool
- Fence Around Pool
Schools
- Western Peaks Elementary
- Willow Canyon High School
Utilities
- Cooling Available
- Heating System Uses Natural Gas
Additional Features
- ENERGY STAR Qualified Equipment
- Covered Patio or Porch
Community Details
- Association fees include ground maintenance, street maintenance
- First Services Resid Association, Phone Number (480) 551-4300
- Surprise Farms Phase 1B South Parcel 11 Subdivision
Listing and Financial Details
- Tax Lot 104
- Assessor Parcel Number 502-84-104
Ownership 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
Name
Owned For
Owner Type
Purchase Details
Listed on
Jul 24, 2025
Closed on
Sep 19, 2025
Sold by
Bought by
Seller's Agent
Tamra Lee Ulmer
Arizona Resource Realty
Buyer's Agent
Cassandra Salamone
W and Partners, LLC
List Price
$535,000
Sold Price
$535,000
Views
26
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
$257
Avg. Annual Appreciation
0.06%
Original Mortgage
$508,250
Interest Rate
0.0571%
Mortgage Type
New Conventional
Purchase Details
Listed on
Apr 30, 2021
Closed on
May 21, 2021
Sold by
Bought by
Seller's Agent
Marlene Cerreta
Cerreta Real Estate
Buyer's Agent
Melissa Dierks
eXp Realty
List Price
$499,000
Sold Price
$499,000
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
1.62%
Original Mortgage
$399,000
Interest Rate
0.03%
Mortgage Type
New Conventional
Purchase Details
Listed on
Sep 9, 2015
Closed on
Mar 21, 2016
Sold by
Bought by
Seller's Agent
Danny Lopez
Real Broker
Buyer's Agent
Samir Rafeedie
Realty Ambassadors LLC
List Price
$325,000
Sold Price
$295,000
Premium/Discount to List
-$30,000
-9.23%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
10.66%
Original Mortgage
$236,000
Interest Rate
0.0372%
Mortgage Type
New Conventional
Purchase Details
Listed on
Sep 9, 2015
Closed on
Mar 17, 2016
Sold by
Bought by
Seller's Agent
Danny Lopez
Real Broker
Buyer's Agent
Samir Rafeedie
Realty Ambassadors LLC
List Price
$325,000
Sold Price
$295,000
Premium/Discount to List
-$30,000
-9.23%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$236,000
Interest Rate
0.0372%
Mortgage Type
New Conventional
Purchase Details
Closed on
Aug 15, 2005
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$225,922
Interest Rate
0.057%
Mortgage Type
Fannie Mae Freddie Mac
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 |
|---|---|---|---|
| $535,000 | Teema Title & Escrow Agency | ||
| $499,000 | Fidelity Natl Ttl Agcy Inc | ||
| -- | Dhi Title Agency | ||
| $295,000 | Dhi Title Agency | ||
| $242,900 | Fidelity National Title |
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 |
|---|---|---|---|
| Closed | $508,250 | ||
| Closed | $399,000 | ||
| Closed | $55,000 | ||
| Closed | $236,000 | ||
| Closed | $204,550 | ||
| Closed | $225,922 |
Source: Public Records
Property 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 | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 01/02/2026 01/02/26 | Off Market | $295,000 | -- | -- | |
| 09/24/2025 09/24/25 | Sold | $535,000 | 0.0% | $169 / Sq Ft | |
| 08/13/2025 08/13/25 | Pending | -- | -- | -- | |
| 07/24/2025 07/24/25 | For Sale | $535,000 | +7.2% | $169 / Sq Ft | |
| 05/28/2021 05/28/21 | Sold | $499,000 | 0.0% | $158 / Sq Ft | View Prior Sale |
| 05/03/2021 05/03/21 | Pending | -- | -- | -- | |
| 04/30/2021 04/30/21 | For Sale | $499,000 | +69.2% | $158 / Sq Ft | |
| 03/22/2016 03/22/16 | Sold | $295,000 | 0.0% | $93 / Sq Ft | View Prior Sale |
| 02/24/2016 02/24/16 | Pending | -- | -- | -- | |
| 02/19/2016 02/19/16 | Price Changed | $295,000 | -1.7% | $93 / Sq Ft | |
| 01/15/2016 01/15/16 | Price Changed | $300,000 | -3.2% | $95 / Sq Ft | |
| 10/02/2015 10/02/15 | Price Changed | $310,000 | -4.6% | $98 / Sq Ft | |
| 09/09/2015 09/09/15 | For Sale | $325,000 | 0.0% | $103 / Sq Ft | |
| 09/16/2013 09/16/13 | Rented | $1,595 | -4.8% | -- | |
| 08/30/2013 08/30/13 | Under Contract | -- | -- | -- | |
| 07/15/2013 07/15/13 | For Rent | $1,675 | -- | -- |
Source: Arizona Regional Multiple Listing Service (ARMLS)
Tax 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.
| 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 | $2,525 | $25,154 | -- | -- |
| 2024 | $2,035 | $23,956 | -- | -- |
| 2023 | $2,035 | $39,480 | $7,890 | $31,590 |
| 2022 | $1,948 | $28,870 | $5,770 | $23,100 |
| 2021 | $2,054 | $27,210 | $5,440 | $21,770 |
| 2020 | $2,033 | $26,030 | $5,200 | $20,830 |
| 2019 | $1,978 | $24,010 | $4,800 | $19,210 |
| 2018 | $1,940 | $23,400 | $4,680 | $18,720 |
| 2017 | $1,854 | $20,500 | $4,100 | $16,400 |
| 2016 | $1,619 | $20,460 | $4,090 | $16,370 |
| 2015 | $1,925 | $18,930 | $3,780 | $15,150 |
Source: Public Records
Agents Affiliated with this Home
-
Tamra Lee Ulmer
-
Cassandra Salamone
Buyer's Agent in 2025
Cassandra Salamone
W and Partners, LLC
(602) 402-8387
50 Total Sales
-
Marlene Cerreta
Seller's Agent in 2021
Marlene Cerreta
Cerreta Real Estate
(602) 617-8935
153 Total Sales
-
Melissa Dierks
Buyer's Agent in 2021
Melissa Dierks
eXp Realty
(623) 229-0154
165 Total Sales
-
Danny Lopez
Seller's Agent in 2016
Danny Lopez
Real Broker
(623) 738-4894
14 Total Sales
-
S
Buyer's Agent in 2016
Samir Rafeedie
Realty Ambassadors LLC
Map
Source: Arizona Regional Multiple Listing Service (ARMLS)
MLS Number: 6897543
APN: 502-84-104
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
- 17520 W Caribbean Ln
- 15140 N 174th Dr
- 17239 W Ironwood St
- 15109 N 175th Dr
- 17169 W Ironwood St
- 16014 N 174th Ave
- 15039 N 172nd Ln
- 17636 W Maui Ln
- 15410 N 170th Ln
- 17538 W Marshall Ln
- 14921 N 172nd Ln
- 16029 N 171st Dr
- 17615 W Rimrock St
- 15016 N 176th Ln
- 17013 W Marconi Ave
- 16155 N 171st Dr
- 17002 W Marconi Ave
- 16964 W Marconi Ave
- 17519 W Lisbon Ln
- 17646 W Statler Dr
- 15521 N 174th Ave
- 15533 N 174th Ave
- 15514 N 173rd Ln
- 15520 N 173rd Ln
- 17323 W Ivy Ln
- 17317 W Ivy Ln
- 15522 N 174th Ave
- 15532 N 173rd Ln
- 15539 N 174th Ave
- 15534 N 174th Ave
- 17311 W Ivy Ln
- 15538 N 173rd Ln
- 15540 N 174th Ave
- 15605 N 174th Ave
- 17322 W Carmen Dr
- 17328 W Carmen Dr
- 15604 N 173rd Ln
- 15606 N 174th Ave
- 17316 W Carmen Dr
- 15517 N 174th Ln
Your Personal Tour Guide
Ask me questions while you tour the home.