Home | Merced County | Gustine | 95322 | 649 Sycamore Ave
MLS: ME225087173 | Status: PendingDoNotShow | Price: $410,000
Beds/Baths: 3 / 2
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 3 | 2 | 1,520 | 6,752 | – |
It is sold as is, It has an extra room separated from the house, it has fruit trees, Good condition ready to move.
| Field | Value |
|---|---|
| MLS # | ME225087173 |
| MLS Source | MetroList Services, Inc. |
| Feature | Details |
|---|---|
| Kitchen | Countertop - Granite, Countertop - Tile, Kitchen/Family Room Combo |
| Appliances | Dishwasher, Hood Over Range |
| Dining Room | Dining Area in Family Room |
| Fireplace | Family Room, Living Room, Raised Hearth, Stone |
| Flooring | Laminate, Wood |
| Laundry | Laundry Area |
| Cooling | Ceiling Fan, Central Forced Air |
| Heating | Central Forced Air, Fireplace |
| Feature | Details |
|---|---|
| Roof | Shingle |
| Foundation | Slab, Concrete Perimeter and Slab |
| Pool | Pool - No |
| Style | Tract |
| Feature | Details |
|---|---|
| Garage/Parking | Attached Garage, Detached, Facing Front, Garage: 2 Car(s) |
| Elementary District | Gustine Unified |
| High School District | Gustine Unified |
| Sewer | Public Sewer |
| Water | Public |
| Zoning | R-1 |
Miguel Gomez
California Residential Homes
License #: 01764449
Phone: (209) 482-0070
| # Buildings | # Leased Units | # Total Units |
|---|---|---|
| 0 | – | – |
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| Pioneer Headstart | public | UG | 0.41 mi | N/A |
| Gustine Elementary School | public | K-5 | 0.45 mi | 2 |
| Gustine High School | public | 9-12 | 0.71 mi | 5 |
| Pioneer High (Continuation) School | public | 9-12 | 0.71 mi | N/A |
| Gustine Middle School | public | 6-8 | 0.76 mi | 2 |
| Von Renner Elementary School | public | K-5 | 4.08 mi | 3 |
| Yolo Junior High School | public | 6-8 | 4.45 mi | 4 |
| Hunt Elementary School | public | K-5 | 4.80 mi | 5 |
| Newman-Crows Landing Adult | public | UG | 4.82 mi | N/A |
| Newman-Crows Landing Independent Study School | public | K-12 | 4.82 mi | 3 |
| Foothill Community Day School | public | 7-12 | 4.85 mi | N/A |
| Hurd Barrington Elementary | public | K-5 | 4.92 mi | 6 |
| Orestimba High School | public | 9-12 | 4.99 mi | 6 |
| Address | Price | Beds | Baths | Sq Ft | Status |
|---|---|---|---|---|---|
| 1460 Portsmouth Ln | $459,999 | 4 | 2/1 | 1,750 | Active |
| 131 5th St | $375,000 | 3 | 2 | 1,307 | Contingent |
| 381 Wallis Ave | $420,000 | 3 | 2 | 1,768 | Active |
©2026 MetroList Services, Inc. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from MetroList Services, Inc.
Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.
This listing information is up-to-date as of March 14, 2026. For the most current information, please contact Miguel Gomez, (209) 482-0070.