


























Description
- Listed by Mike Carey • DRE #01055545 • Investment Real Estate • 925-963-0569
- Listed by Joe Armtrout • DRE #01900074 • Investment Real Estate
Property Details for 554 Chestnut Avenue
Property Details for 554 Chestnut Avenue
| Status | Pending |
|---|---|
| MLS # | 41133724 |
| Days on Compass | 8 |
| Taxes | - |
| HOA Fees | - |
| Condo/Co-op Fees | - |
| Property Type | Single Family |
| MLS Type | Residential / Detached |
| Year Built | 1980 |
| Lot Size | 0.12 AC / 5,069 SF |
| County | San Joaquin County |
Location
Building Information for 554 Chestnut Avenue
Payment Calculator
$2,676 per month
30 year fixed, 6.36% Interest
$2,482
$194
$0
Property Information for 554 Chestnut Avenue
- Fireplaces: 0
- FIREPLACES: None
- Flooring: Engineered Wood
- Garage: Yes
- Laundry: Hookups Only, In Garage
- Pool Type: None
- Pool: No
- Rooms Total: 8
- Additional Rooms: Bonus / Hobby Room
- Kitchen Features: Breakfast Nook, Stone Counters, Dishwasher, Eat-in Kitchen, Range/Oven Free Standing, Refrigerator, Updated Kitchen
- Bedrooms Count: 3
- Bathrooms Total Count: 2.0
- Room Additional: BonusRoom
- BATH NON-PRMY INCLUDE: Shower Over Tub, Updated Baths
- BATH-PRIMARY INCLUDES: Stall Shower, Tile, Updated Baths
- Bathrooms Half: 0
- Cooling: Ceiling Fan(s)
- Heating: No Heat
- Solar: None
- HOA: No
- Additional Equipment: None
- City Transfer Tax: No
- Construction Status: Existing
- Exterior: Stucco
- Foundation: Slab
- Lot Description: Level, Premium Lot, RectangularLot
- Lot Sq Ft Apx: 5069
- Lot Size Square Feet: 5069.0
- Roof: Composition Shingles
- Sq Ft Apx: 1406
- Stories: One Story
- Street Level: 3 Bedrooms, 2 Baths
- Yard Description: Back Yard, Front Yard
- Year Built: 1980
- Acres: 0.12
- Directions to Property: Cypress Dr > N Hickory Ave > Birch Dr > Chestnut Ave
- FIPS Code: 06077
- Parcel Number: 234-150-290-000
- Printed Neighborhood Rpt: No
- Board ID: BAY EAST
- Fireplace: No
Property History for 554 Chestnut Avenue
| Date | Event & Source | Price | Appreciation |
|---|---|---|---|
| May 14, 2026 | Pending MLSListings #BE41133724 | — | |
| May 14, 2026 | Pending EBRD #41133724 | — | |
| May 13, 2026 | Pending CRMLS #41133724 | — | |
| May 6, 2026 | Listed (Active) EBRD #41133724 | $498,000 | — |
| May 6, 2026 | Withdrawn EBRD #41131467 | — | |
| May 6, 2026 | Listed (Active) MLSListings #BE41133724 | $498,000 | — |
| May 6, 2026 | Withdrawn MLSListings #BE41131467 | $510,000 | — |
| May 6, 2026 | Listed (Active) CRMLS #41133724 | $498,000 | — |
| May 5, 2026 | Withdrawn CRMLS #41131467 | $510,000 | — |
| Apr 17, 2026 | Listed (Active) CRMLS #41131467 | $510,000 | — |
| Apr 17, 2026 | Listed (Active) MLSListings #BE41131467 | $510,000 | — |
| Apr 17, 2026 | Listed (Active) EBRD #41131467 | $510,000 | — |
| Jul 17, 2007 | Expired RESFAR #40242335 | $399,000 | — |
| Jul 17, 2007 | Expired METROLIST #70014041 | $399,000 | — |
| Jul 17, 2007 | Expired RESFAR #70014041 | $399,000 | — |
| Jul 2, 2007 | Withdrawn RESFAR #80453415 | — | |
| Jul 2, 2007 | Expired METROLIST #70014041 | — | |
| Jul 2, 2007 | Withdrawn MLSListings #ML80453415 | — | |
| Feb 9, 2007 | Price Change RESFAR #70014041 | $410,000 | — |
| Feb 9, 2007 | Price Change RESFAR #70014041 | $399,000 | — |
| Feb 9, 2007 | Listed (Active) METROLIST #70014041 | $410,000 | — |
| Feb 2, 2007 | Listed (Active) RESFAR #80453415 | $399,000 | — |
| Feb 2, 2007 | Price Change RESFAR #40242335 | $410,000 | — |
| Feb 2, 2007 | Listed (Active) MLSListings #ML80453415 | $399,000 | — |
| Feb 2, 2007 | Listed (Active) RESFAR #40242335 | $399,000 | — |
| Jun 12, 1997 | Sold RESFAR #27591077 | $117,500 | — |
| Jun 3, 1997 | Pending RESFAR #27591077 | — | |
| Mar 12, 1997 | Price Change RESFAR #27591077 | $125,000 | — |
| Mar 12, 1997 | Listed (Active) RESFAR #27591077 | $119,950 | — |
| Date | Event & Source | Price |
|---|---|---|
| 05/14/2026 | Pending MLSListings #BE41133724 | — |
| 05/14/2026 | Pending EBRD #41133724 | — |
| 05/13/2026 | Pending CRMLS #41133724 | — |
| 05/06/2026 | Listed (Active) EBRD #41133724 | $498,000 |
| 05/06/2026 | Withdrawn EBRD #41131467 | — |
| 05/06/2026 | Listed (Active) MLSListings #BE41133724 | $498,000 |
| 05/06/2026 | Withdrawn MLSListings #BE41131467 | $510,000 |
| 05/06/2026 | Listed (Active) CRMLS #41133724 | $498,000 |
| 05/05/2026 | Withdrawn CRMLS #41131467 | $510,000 |
| 04/17/2026 | Listed (Active) CRMLS #41131467 | $510,000 |
| 04/17/2026 | Listed (Active) MLSListings #BE41131467 | $510,000 |
| 04/17/2026 | Listed (Active) EBRD #41131467 | $510,000 |
| 07/17/2007 | Expired RESFAR #40242335 | $399,000 |
| 07/17/2007 | Expired METROLIST #70014041 | $399,000 |
| 07/17/2007 | Expired RESFAR #70014041 | $399,000 |
| 07/02/2007 | Withdrawn RESFAR #80453415 | — |
| 07/02/2007 | Expired METROLIST #70014041 | — |
| 07/02/2007 | Withdrawn MLSListings #ML80453415 | — |
| 02/09/2007 | Price Change RESFAR #70014041 | $410,000 |
| 02/09/2007 | Price Change RESFAR #70014041 | $399,000 |
| 02/09/2007 | Listed (Active) METROLIST #70014041 | $410,000 |
| 02/02/2007 | Listed (Active) RESFAR #80453415 | $399,000 |
| 02/02/2007 | Price Change RESFAR #40242335 | $410,000 |
| 02/02/2007 | Listed (Active) MLSListings #ML80453415 | $399,000 |
| 02/02/2007 | Listed (Active) RESFAR #40242335 | $399,000 |
| 06/12/1997 | Sold RESFAR #27591077 | $117,500 |
| 06/03/1997 | Pending RESFAR #27591077 | — |
| 03/12/1997 | Price Change RESFAR #27591077 | $125,000 |
| 03/12/1997 | Listed (Active) RESFAR #27591077 | $119,950 |
For completeness, we often displays two records for one sale: the MLS record and the public record.
Public Records for 554 Chestnut Avenue
Schools near 554 Chestnut Avenue
Rating | School | Type | Grades | Distance |
|---|---|---|---|---|
| Public - | K to 5 | |||
| Public - | 6 to 8 | |||
| Public - | 9 to 12 | |||
| Public - | 9 to 12 |
Rating | School | Distance |
|---|---|---|
Louis J. Villalovoz Elementary School PublicK to 5 | ||
Earle E. Williams Middle School Public6 to 8 | ||
Merrill F. West High School Public9 to 12 | ||
George And Evelyn Stein Continuation School Public9 to 12 |
School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.
Similar Homes
Explore Nearby Homes
- Alden Glen Homes for Sale
- California Collections Homes for Sale
- Downtown Tracy Homes for Sale
- Eastlake Homes for Sale
- Glenbriar Estates Homes for Sale
- Hearthstone Homes for Sale
- Larch Clover Homes for Sale
- Muirfield Homes for Sale
- Victoria Park Homes for Sale
- Elissagaray Ranch Homes for Sale
- Ellis Homes for Sale
- Edgewood Homes for Sale
- Tracy Hills Homes for Sale
- River Islands Homes for Sale
- Cordes Homes for Sale
- Tracy Homes for Sale
- Lathrop Homes for Sale
- Mountain House Homes for Sale
- Manteca Homes for Sale
- French Camp Homes for Sale
- Stockton Homes for Sale
- Byron Homes for Sale
- Vernalis Homes for Sale
- Discovery Bay Homes for Sale
- Holt Homes for Sale
- Livermore Homes for Sale
- Ripon Homes for Sale
- Mount Hamilton Homes for Sale
- Knightsen Homes for Sale
- Salida Homes for Sale
- 95304 Homes for Sale
- 95377 Homes for Sale
- 95330 Homes for Sale
- 95206 Homes for Sale
- 95391 Homes for Sale
- 95337 Homes for Sale
- 94514 Homes for Sale
- 94550 Homes for Sale
- 94505 Homes for Sale
- 94551 Homes for Sale
- 95231 Homes for Sale
- 95385 Homes for Sale
- 95336 Homes for Sale
- 95387 Homes for Sale
- 95358 Homes for Sale
No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.
Listing Courtesy of Investment Real Estate, Mike Carey, DRE #01055545; Investment Real Estate, Joe Armtrout, DRE #01900074
Based on information from one of the following Multiple Listing Services: San Francisco Association of Realtors, the MLSListings MLS, the BAREIS MLS, the EBRD MLS, Shasta Association of REALTORS® Information being provided is for the visitor’s personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by San Francisco Association of Realtors, the MLSListings MLS, the BAREIS MLS, the EBRD MLS, Shasta Association of REALTORS® is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.



























1