WOW!! Look no further. This charming home with NO HOA is GORGEOUS, turn-key ready, & was totally remodeled in 2023. The 1,152 sq. ft. home features 3 bedrooms & 2 bathrooms. It has a fantastic open-concept floorplan, a gourmet kitchen with new stainless steel appliances, plenty of new shaker cabinets & new counter tops, and a cozy lg. The primary suite has an en-suite w/soaking tub and a walk-in closet. The home exudes luxury and comfort, with all new upgrades: laminate flooring, paint, doors, double-pane windows, new A/C and Evap, and much more. This home is on a 1/3-acre corner lot and is on an elevated pad with a block retaining wall, lush landscaping, a private fenced-in area, great for kids or pets, & RV parking. YOU WILL LOVE THIS PLACE< located between Prescott & Phoenix. MUST SEE!
Pending
$264,000
17186 E Trails End Rd, Mayer, AZ 86333
3beds
1,153sqft
Manufactured Home
Built in 1982
0.32 Acres Lot
$255,800 Zestimate®
$229/sqft
$-- HOA
What's special
Rv parkingElevated padOpen-concept floorplanLush landscapingPrimary suitePrivate fenced-in areaBlock retaining wall
- 427 days |
- 7 |
- 0 |
Zillow last checked: 7 hours ago
Listing updated: July 09, 2025 at 02:42pm
Listed by:
Tammie Malone 602-750-7737,
West USA Realty, Inc.
Source: PAAR as distributed by MLS GRID,MLS#: 1070337
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
Heating
- Natural Gas
Cooling
- Ceiling Fan(s), Central Air, Evaporative Cooling
Appliances
- Included: Dishwasher, Gas Range, Microwave, Refrigerator
- Laundry: Wash/Dry Connection
Features
- Ceiling Fan(s), Formal Dining, Soaking Tub, Kit/Din Combo, Live on One Level, Walk-In Closet(s)
- Flooring: Laminate
- Windows: Double Pane Windows, Tinted Windows, Blinds
- Basement: None
- Has fireplace: No
Interior area
- Total structure area: 1,153
- Total interior livable area: 1,153 sqft
Property
Parking
- Parking features: Driveway Gravel
- Has uncovered spaces: Yes
Features
- Patio & porch: Covered
- Exterior features: Dog Run, Landscaping-Front
- Fencing: Partial
Lot
- Size: 0.32 Acres
- Topography: Corner Lot
Details
- Parcel number: 684
- Zoning: R1-10
Construction
Type & style
- Home type: MobileManufactured
- Property subtype: Manufactured Home
Materials
- Frame
- Roof: Composition
Condition
- Year built: 1982
Details
- Builder name: Cavco
Utilities & green energy
- Sewer: Septic Conv
- Water: Public
- Utilities for property: Cable Available, Electricity Available, Natural Gas Available
Community & HOA
Community
- Security: Smoke Detector(s)
- Subdivision: None
HOA
- Has HOA: No
Location
- Region: Mayer
Financial & listing details
- Price per square foot: $229/sqft
- Tax assessed value: $39,717
- Annual tax amount: $280
- Date on market: 2/1/2025
- Cumulative days on market: 264 days
- Electric utility on property: Yes
- Road surface type: Paved
- Body type: Double Wide
Estimated market value
$255,800
$225,000 - $292,000
$1,485/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 2/5/2025 | Pending sale | $264,000$229/sqft |
Source:  PAAR as distributed by MLS GRID #1070337 Report a problem | ||
| 1/15/2025 | Price change | $264,000-0.2%$229/sqft |
Source:  ARMLS #6794659 Report a problem | ||
| 12/15/2024 | Listed for sale | $264,500$229/sqft |
Source: ARMLS #6794659 Report a problem | ||
| 12/14/2024 | Listing removed | $264,500$229/sqft |
Source: ARMLS #6743146 Report a problem | ||
| 11/19/2024 | Price change | $264,500-1.7%$229/sqft |
Source: ARMLS #6743146 Report a problem | ||
| 9/5/2024 | Price change | $269,000-2.2%$233/sqft |
Source: ARMLS #6743146 Report a problem | ||
| 8/13/2024 | Listed for sale | $275,000-1.4%$239/sqft |
Source: ARMLS #6743146 Report a problem | ||
| 7/22/2024 | Listing removed | -- |
Source: PAAR as distributed by MLS GRID #1061023 Report a problem | ||
| 6/4/2024 | Price change | $279,000-1.7%$242/sqft |
Source: PAAR as distributed by MLS GRID #1061023 Report a problem | ||
| 4/29/2024 | Price change | $283,900-0.2%$246/sqft |
Source: PAAR as distributed by MLS GRID #1061023 Report a problem | ||
| 4/8/2024 | Listed for sale | $284,400$247/sqft |
Source: PAAR as distributed by MLS GRID #1061023 Report a problem | ||
| 4/1/2024 | Contingent | $284,400$247/sqft |
Source: PAAR as distributed by MLS GRID #1061023 Report a problem | ||
| 3/16/2024 | Listed for sale | $284,400$247/sqft |
Source: PAAR as distributed by MLS GRID #1061023 Report a problem | ||
| 3/7/2024 | Contingent | $284,400$247/sqft |
Source: PAAR as distributed by MLS GRID #1061023 Report a problem | ||
| 2/13/2024 | Price change | $284,400-0.2%$247/sqft |
Source: PAAR as distributed by MLS GRID #1061023 Report a problem | ||
| 12/15/2023 | Listed for sale | $284,900$247/sqft |
Source: PAAR as distributed by MLS GRID #1061023 Report a problem | ||
| 12/12/2023 | Listing removed | -- |
Source: Owner Report a problem | ||
| 11/16/2023 | Price change | $284,900-1.7%$247/sqft |
Source: ARMLS #6631076 Report a problem | ||
| 11/6/2023 | Listed for sale | $289,900+92.8%$251/sqft |
Source: Owner Report a problem | ||
| 6/27/2023 | Sold | $150,400+0.3%$130/sqft |
Source: ARMLS #6566972 Report a problem | ||
| 6/10/2023 | Listed for sale | $149,900+130.6%$130/sqft |
Source: ARMLS #6566972 Report a problem | ||
| 12/10/2019 | Sold | $65,000$56/sqft |
Source: PAAR as distributed by MLS GRID #1025223 Report a problem | ||
| 11/19/2019 | Pending sale | $65,000$56/sqft |
Source: Keller Williams Northern Az #1025223 Report a problem | ||
| 11/15/2019 | Listed for sale | $65,000$56/sqft |
Source: Keller Williams Northern Az #1025223 Report a problem | ||
| 11/7/2019 | Pending sale | $65,000$56/sqft |
Source: Keller Williams Northern Az #1025223 Report a problem | ||
| 10/29/2019 | Listed for sale | $65,000+26.5%$56/sqft |
Source: Keller Williams Northern Az #1025223 Report a problem | ||
| 1/29/1998 | Sold | $51,397$45/sqft |
Source: PAAR as distributed by MLS GRID #337974 Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $280 +17.8% | $2,670 +5% |
| 2024 | $238 +2.9% | $2,543 -47.6% |
| 2023 | $231 -4.5% | $4,851 +13.6% |
| 2022 | $242 +3.8% | $4,271 +8.5% |
| 2021 | $233 -12.7% | $3,938 +25.4% |
| 2020 | $267 +1.8% | $3,141 |
| 2019 | $262 | -- |
| 2018 | -- | -- |
| 2017 | -- | -- |
| 2016 | -- | -- |
| 2015 | -- | -- |
| 2014 | -- | -- |
| 2013 | -- | -- |
| 2012 | -- | -- |
| 2011 | $320 | $2,484 |
| 2010 | -- | -- |
| 2009 | $313 -1.8% | -- |
| 2008 | $319 | -- |
| 2007 | -- | -- |
| 2006 | -- | -- |
| 2005 | -- | -- |
| 2004 | -- | -- |
| 2003 | -- | -- |
| 2002 | -- | -- |
| 2001 | -- | -- |
Find assessor info on the county website
Monthly payment
Estimated monthly payment
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 86333
Nearby schools
GreatSchools rating
- 2/10Mayer Elementary SchoolGrades: PK-8Distance: 6.1 mi
- 5/10Mayer High SchoolGrades: 9-12Distance: 0.3 mi
Local experts in 86333
- Arizona
- Yavapai County
- Mayer
- 86333
- 17186 E Trails End Rd
Nearby cities
Nearby zip codes
Other Mayer Topics
