---
listing_id: ME226130810
status: Active
price: 589900
beds: 3
baths_full: 2
baths_half: 0
sqft_living: 1663
sqft_lot: 5602
lot_acres: 
year_built: 
property_type: Residential
property_subtype: Single Family Residence
address: "2087 Fountain Square Ave"
city: Manteca
state: CA
zip: 95337
county: "San Joaquin County"
lat: 37.7718589
lng: -121.2139073
days_on_market: 0
hoa_fee: 
hoa_frequency: 
garage_spaces: 2
list_agent: "Austin Hartman"
list_office: "Real Brokerage Technologies"
list_agent_phone: "(559) 932-0029"
list_agent_license: 01990527
mls_source: REMTRO
modified: 2026-10-22
transaction_type: buy
---

Home | San Joaquin County | Manteca | 95337 | 2087 Fountain Square Ave

2087 Fountain Square Ave, Manteca, CA 95337

MLS: ME226130810 | Status: Active | Price: $589,900
Beds/Baths: 3 / 2
Property Type: Residential

Quick Facts

Beds Baths Sq Ft Sq Ft Lot Yr Built
3 2 1,663 5,602 –

Remarks

Welcome to 2087 Fountain Square Avenue, located in the well established Woodward neighborhood! This 3 bedroom, 2 bath residence has been thoughtfully reimagined with designer touches and countless upgrades, it features two living spaces offering the perfect move-in-ready home. Step inside to find open, light-filled spaces highlighted by LED lighting and warm, earthy tones. The stunning kitchen features oak cabinetry, granite countertops, and stainless steel appliances an ideal setting for both everyday living and entertaining. The primary suite is designed with attention to every detail including a walk-in closet and a bathroom design that spares no expense. The property also features an additional bonus room that can be utilized as a 4th bedroom! In addition, the property includes a well-maintained lot. The possibilities are endless. Priced to sell, this home combines function, beauty, and opportunity. Schedule your showing today before it's gone!

MLS Listing Information

Field Value
MLS # ME226130810
MLS Source MetroList Services, Inc.
Days on Site 0

Features

Interior Features

Feature Details
Bedrooms Primary Bath, Primary Suite/Retreat
Bathrooms Updated Bath(s)
Kitchen Countertop - Granite, Island, Island with Sink, Other
Appliances Dishwasher, Garbage Disposal, Microwave, Other, Oven Range - Gas
Dining Room Dining Area in Family Room, Other
Family Room Other
Fireplace Brick, Gas Starter
Flooring Laminate
Laundry Cabinets, In Laundry Room, Laundry - Yes
Cooling Central Forced Air
Heating Central Forced Air

Exterior Features

Feature Details
Roof Shingle
Foundation Slab, Concrete Perimeter and Slab
Pool Pool - No
Style Tract

Parking, School, and Other Information

Feature Details
Garage/Parking Facing Front, Gate/Door Opener, Garage: 2 Car(s)
Elementary District Manteca Unified
High School District Manteca Unified
Sewer Public Sewer
Water Public
Zoning R1

Contact Information

Austin Hartman
Real Brokerage Technologies
License #: 01990527
Phone: (559) 932-0029

Property Units

# Buildings # Leased Units # Total Units
0 – –

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
Walter Woodward Elementary School public K-8 0.34 mi 5
Veritas Elementary School public K-8 0.96 mi 6
Sequoia Elementary School public K-8 1.43 mi 2
Brock Elliott Elementary School public K-8 1.69 mi 5
Manteca High School public 9-12 1.75 mi 5
Nile Garden Elementary School public K-8 1.78 mi 9
Lincoln Elementary School public K-8 1.78 mi 1
Manteca Community Day (7-12) School public 7-12 1.95 mi 3
Manteca Community Day (K-6) School public K-6 1.95 mi N/A
Sierra High School public 9-12 2.17 mi 6
Shasta Elementary School public K-8 2.47 mi 4
Calla High School public 9-12 2.59 mi 2
Golden West Elementary School public K-8 2.64 mi 2
Joshua Cowell Elementary School public K-8 2.80 mi 3
Stella Brockman Elementary School public K-8 3.09 mi 3
Neil Hafley Elementary School public K-8 3.49 mi 3
Manteca Adult public UG 3.64 mi N/A
East Union High School public 9-12 3.64 mi 4
George McParland Elementary School public K-8 3.80 mi 6
New Haven Elementary School public K-8 4.16 mi 4

Nearby Homes

Address Price Beds Baths Sq Ft Status
1320 Camilla St $495,000 3 2 1,547 PendingDoNotShow
1765 W Woodward Ave $564,999 3 2/1 2,016 Active
2217 Hearth Dr $639,950 4 2/1 2,694 Active
1409 Peach $619,000 3 2 1,668 Active
2814 Sunbeam Ln $599,990 4 3 2,142 PendingDoNotShow

Disclosures

©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 October 22, 2026. For the most current information, please contact Austin Hartman, (559) 932-0029.