Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$589,900 Just Listed

  • For Sale
  • Active
  • Single Family
  • 3 Beds
  • 2 Full Baths
  • 1,663 Sq. Ft.
  • 2 Car Garage
  • Updated 2 days ago
See This Home
Save This Home
See This Home
Save This Home
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!

Full Property Details for 2087 Fountain Square Ave

General

  • Price: $589,900
  • Status: Active
  • Type: Single Family
  • Source: METROLIST_Cali
  • MLS ID: 226130810
  • Updated: 10/22/2026
  • Added to Site: 2 day(s) ago

Interior

  • Rooms/Areas: Primary Bathroom, Primary Bedroom, Dining Room, Family Room, Kitchen, Laundry, Living Room
  • Fireplace: Yes
  • Number of Fireplaces: 2
  • Fireplace(s): Brick, Gas Starter
  • Appliances: Free Standing Gas Range, Dishwasher, Disposal, Microwave
  • Flooring: Laminate

Rooms

Bathrooms

  • Total Bathrooms: 2
  • Full Bathrooms: 2

Bedrooms

  • Total Bedrooms: 3
  • Optional Bedroom: 4

Other Rooms

  • Kitchen: Granite Counter, Island, Island w/Sink
  • Dining Room: Dining/Family Combo
  • Laundry: Cabinets, Inside Room

Parking

  • Garage: Yes
  • Garage Spaces: 2
  • Parking: Garage Door Opener, Garage Facing Front

Location

  • County: San Joaquin
  • Cross Streets: Main
  • Driving Directions: Main Street / Woodward, South on Main, East on Pear Tree, S on Fountain Square

School Information

  • School District: San Joaquin
  • Elem School District: Manteca Unified
  • Midd School District: Manteca Unified
  • High School District: Manteca Unified

Heating & Cooling

  • Cooling Type: Central
  • Heating Type: Central
  • Heating Fuel: Central

Utilities

  • Sewer: Public Sewer
  • Water: Public
  • Utility Description: Sewer Connected & Paid, Electric, Natural Gas Connected

Structural Information

  • Construction: Stucco, Wood Siding
  • Basement: Yes
  • Foundation: Slab
  • Roof: Shingle
  • Stories/Levels: 1
  • Square Feet: 1,663
  • Sq. Ft. Source: Assessor Auto-Fill
  • Year Built: 2001

Lot Features

  • Lot Size (Acres): 0.1286
  • Lot Size (Sq. Ft.): 5,602
  • Irrigation System: None
  • Zoning: R1
  • Lot Description: Curb(s)/Gutter(s)
  • Fencing (Description): Back Yard

Disclosures and Reports

  • Special Conditions: None
  • APN: 224-130-53

Listed by Real Brokerage Technologies

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agent

— 2087 Fountain Square Ave —

  • Real Brokerage Technologies

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 2087 Fountain Square Ave

School District:Manteca Unified School District
NameGradesDistance
Walter Woodward Elementary School
575 Tannehill Drive, Manteca, CA 95337
K-80.3 mi
Manteca High School
450 East Yosemite Avenue, Manteca, CA 95336
9-121.7 mi
Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 2087 Fountain Square Ave Get Price Alerts and Save Property

Date
Details
Price
Change
Source
10/22/2026
Listed
$589,900
26.86%
MLS
6/24/2026
Sold
$465,000
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 2087 Fountain Square Ave

Year
Property Taxes
Change
Tax Assessment
Change
2026
$6,841
-8%
$586,700
-5%
2024
$7,429
1%
$616,267
2%
2023
$7,346
1%
$604,184
2%
2022
$7,246
22%
$592,338
26%
2021
$5,922
17%
$469,500
16%
2020
$5,048
-1%
$404,500
—
2019
$5,076
2%
$404,500
2%
2018
$4,987
8%
$395,000
10%
2017
$4,610
—
$359,000
—
2016
$4,591
10%
$359,000
13%
2015
$4,169
56%
$317,000
4%
2013
$2,678
—
$304,000
56%
2013
$2,678
—
$195,000
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 2087 Fountain Square Ave

$
Down Payment
%
$
%

$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by Real Brokerage Technologies

Similar Properties near 2087 Fountain Square Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

1711 Eagle River Ave, Manteca, CA 95337 - Photo 1
$589,000

1711 Eagle River Ave  Manteca, CA 95337

  • Single Family
  • Active
  • Updated 8 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,733
    Sq. Ft.
Listed by Mertitage Homes
923 Shortland Cir, Manteca, CA 95337 - Photo 1
$599,000

923 Shortland Cir  Manteca, CA 95337

  • Single Family
  • Active
  • 3
    Beds
  • 2
    Total Baths
  • 1,837
    Sq. Ft.
Listed by RE/MAX Executive
1691 Davis St, Ripon, CA 95366 - Photo 1
$599,500

1691 Davis St  Ripon, CA 95366

  • Single Family
  • Active
  • 3
    Beds
  • 2
    Total Baths
  • 1,828
    Sq. Ft.
Listed by RE/MAX Executive
1522 Kiwi Ct, Ripon, CA 95366 - Photo 1
$599,900

1522 Kiwi Ct  Ripon, CA 95366

  • Single Family
  • Active
  • 3
    Beds
  • 2
    Total Baths
  • 1,731
    Sq. Ft.
Listed by Hype Real Estate

Just Listed near 2087 Fountain Square Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

S Harlan Rd, Lathrop, CA 95330 - Photo 1 Just Listed
$69,900

S Harlan Rd  #3  Lathrop, CA 95330

  • Single Family
  • Active
  • Updated 5 days ago
  • 2
    Beds
  • 1
    Total Bath
  • 768
    Sq. Ft.
Listed by Century 21 Select Real Estate
3163 Scott Edwards Ln, Lathrop, CA 95330 - Photo 1 Just Listed
$798,900
Open House

3163 Scott Edwards Ln  Lathrop, CA 95330

  • Single Family
  • Active
  • Updated 3 days ago
  • 4
    Beds
  • 4
    Total Baths
  • 2,617
    Sq. Ft.
Listed by TRI Pointe Homes Bay Area, Jennifer Younathan
2978 Mulholland Dr, Lathrop, CA 95330 - Photo 1 Just Listed
$999,998
Open House

2978 Mulholland Dr  Lathrop, CA 95330

  • Single Family
  • Active
  • Updated 11 hours ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,683
    Sq. Ft.
Listed by KW Central Valley
2406 Garden Farms Ave, Lathrop, CA 95330 - Photo 1 Just Listed
$479,990

2406 Garden Farms Ave  Lathrop, CA 95330

  • Condo
  • Active
  • Updated 23 hours ago
  • 3
    Beds
  • 2
    Total Baths
Listed by Fred Valverde, Broker, Fred Valverde

Price Reduced near 2087 Fountain Square Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

1504 Balfour Dr, Lathrop, CA 95330 - Photo 1 Price Reduced
-$10,001 (-0.99%)
$999,999
Open House

1504 Balfour Dr  Lathrop, CA 95330

  • Single Family
  • Active
  • Updated 2 days ago
  • 5
    Beds
  • 5
    Total Baths
  • 2,807
    Sq. Ft.
Listed by Keller Williams Tri Valley Realty and Keller Williams Realty
16127 Purdy Ct, Lathrop, CA 95330 - Photo 1 Price Reduced
-$10,000 (-1.12%)
$879,000

16127 Purdy Ct  Lathrop, CA 95330

  • Single Family
  • Active
  • Updated 3 days ago
  • 5
    Beds
  • 5
    Total Baths
Listed by Kiper Development, Inc., John Kiper
3684 Darnoch Ave, Lathrop, CA 95330 - Photo 1 Price Reduced
-$6,000 (-0.73%)
$819,000

3684 Darnoch Ave  Lathrop, CA 95330

  • Single Family
  • Active
  • Updated 3 days ago
  • 5
    Beds
  • 5
    Total Baths
Listed by Kiper Development, Inc., John Kiper
831 Sugar Pine Dr, Lathrop, CA 95330 - Photo 1 Price Reduced
-$15,500 (-3.01%)
$499,500
Open House

831 Sugar Pine Dr  Lathrop, CA 95330

  • Single Family
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,383
    Sq. Ft.
Listed by HomeSmart PV and Associates

Recent Sales near 2087 Fountain Square Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

250 Fragrance St, Manteca, CA 95337 - Photo 1 Sold
$659,000

250 Fragrance St  Manteca, CA 95337

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 2,387
    Sq. Ft.
Listed by PMZ Real Estate
Sold by Union Strong Homeowners, Inc.
164 Legacy St, Manteca, CA 95337 - Photo 1 Sold
$662,500

164 Legacy St  Manteca, CA 95337

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 2,344
    Sq. Ft.
Listed by Redfin Corporation
Sold by Compass
2386 Stephen Robert Ln, Manteca, CA 95337 - Photo 1 Sold
$645,000

2386 Stephen Robert Ln  Manteca, CA 95337

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 2,472
    Sq. Ft.
Listed by PropertySourced
Sold by KW Central Valley
2519 Ava Julianna Way, Manteca, CA 95337 - Photo 1 Sold
$635,000

2519 Ava Julianna Way  Manteca, CA 95337

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 2,229
    Sq. Ft.
Listed by Real Broker Technologies
Sold by Compass

2087 Fountain Square Avenue, Manteca, CA 95337 (MLS# 226130810) is a Single Family property with 3 bedrooms and 2 full bathrooms. 2087 Fountain Square Avenue is currently listed for $589,900 and was received on October 22, 2026. Want to learn more about 2087 Fountain Square Avenue? Do you have questions about finding other Single Family real estate for sale in Manteca? You can browse all Manteca real estate or contact a Coldwell Banker agent to request more information.

Tour this property