A bright and airy 2/2 condo in the gated community with a lakefront view. Whole house with freshly new interior paint. New hinges and doorknobs. Updated kitchen ceiling with recessed lights. New mirrors, lights, exhaust fans, and new SPC flooring in both bathrooms. The new flooring also cover the primary room hallway & walk-in closet. New stall shower in the primary bathroom. The new range/oven and dishwasher are on the way. Close to shopping, restaurants, Hi-Tech companies. Easy access to HWY 880, Dumbarton Bridge, Train station, and BART. Open House Sun 5/5/24 from 1:00 to 4:00 PM.
CondoProperty Type
1973Year Built
2.81 acresLot Size
$542Est. Price/Sq.Ft.
Listed by Helen Liu•DRE #00970382• Intero Real Estate Services
Bought with Abby Chin•DRE #01148568• MRL Group, Inc.
bridgeMLS, Bay East AOR, or Contra Costa AOR #41057218
Jun 7, 2024
Sold
$595,000
$567/sq ft
May 8, 2024
Pending
—
Apr 24, 2024
Listed
$598,000
$570/sq ft
bridgeMLS, Bay East AOR, or Contra Costa AOR #40423303
Oct 14, 2009
Sold
$175,500
$167/sq ft
Aug 31, 2009
Listing Removed
—
Aug 6, 2009
Listed
$219,000
$209/sq ft
2nd floor unit overlooks beautiful lagoon, refreshing trees and green belt. Kitchen includes semi-new fridge, range & interior laundry hook-ups. Master bedroom includes an en-suite bath and walk-in closet . Many upgrades to kitchen and bathrooms.READY TO MOVE IN.
bridgeMLS, Bay East AOR, or Contra Costa AOR #40410002
Jul 16, 2009
Listing Removed
—
bridgeMLS, Bay East AOR, or Contra Costa AOR #40115801
Dec 9, 2005
Sold
$389,000
$370/sq ft
Oct 26, 2005
Listing Removed
—
Oct 5, 2005
Listed
$389,950
$371/sq ft
bridgeMLS, Bay East AOR, or Contra Costa AOR #11197365
Oct 13, 2003
Sold
$270,000
$257/sq ft
Aug 17, 2003
Listing Removed
—
Jul 16, 2003
Listed
$260,000
$248/sq ft
MLSListings #ML80340461
Oct 16, 2003
Sold
$270,000
$257/sq ft
Aug 30, 2003
Listing Removed
—
Jul 16, 2003
Listed
$260,000
$248/sq ft
Public Records
Oct 21, 1997
Sold
$113,500
$108/sq ft
bridgeMLS, Bay East AOR, or Contra Costa AOR #10500462
Oct 21, 1997
Sold
$113,488
$108/sq ft
Sep 7, 1997
Listed
$113,488
$108/sq ft
bridgeMLS, Bay East AOR, or Contra Costa AOR #27500462
Oct 21, 1997
Sold
$113,488
$108/sq ft
Sep 18, 1997
Listing Removed
—
Sep 7, 1997
Listed
$113,488
$108/sq ft
Public Records
Apr 26, 1989
Sold
$67,000
$64/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$7,795 (+140.9%)
$185,711 + $433,326
$619,037
2024
$3,235 (+3.2%)
$182,070 + $424,830
$606,900
2023
$3,135 (+2.0%)
$66,561 + $155,521
$222,082
2022
$3,075 (+2.1%)
$63,977 + $149,483
$213,460
2021
$3,012 (+2.3%)
$63,977 + $149,483
$213,460
2020
$2,944 (+1.0%)
$62,723 + $146,553
$209,276
2019
$2,914 (+2.0%)
$62,080 + $145,051
$207,131
2018
$2,855 (+2.5%)
$60,863 + $142,207
$203,070
2017
$2,785 (+2.2%)
$58,500 + $136,686
$195,186
2016
$2,726 (+1.8%)
$58,500 + $136,686
$195,186
2015
$2,677 (+1.7%)
$57,353 + $134,007
$191,360
2014
$2,631 (+5.3%)
$55,386 + $129,411
$184,797
2013
$2,499 (+2.6%)
$55,386 + $129,411
$184,797
2012
$2,437 (+1.7%)
$55,136 + $128,827
$183,963
2011
$2,396 (+6.0%)
$54,055 + $126,301
$180,356
2010
$2,261 (−22.5%)
$52,996 + $123,825
$176,821
2009
$2,917 (−31.3%)
$52,600 + $122,900
$175,500
2008
$4,245
$70,800 + $165,200
$236,000
Tax history for 4538 Merced Cmn
Year
Property tax
Land + Additions
Assessment*
2025
$7,795 (+140.9%)
$185,711 + $433,326
$619,037
2024
$3,235 (+3.2%)
$182,070 + $424,830
$606,900
2023
$3,135 (+2.0%)
$66,561 + $155,521
$222,082
2022
$3,075 (+2.1%)
$63,977 + $149,483
$213,460
2021
$3,012 (+2.3%)
$63,977 + $149,483
$213,460
2020
$2,944 (+1.0%)
$62,723 + $146,553
$209,276
2019
$2,914 (+2.0%)
$62,080 + $145,051
$207,131
2018
$2,855 (+2.5%)
$60,863 + $142,207
$203,070
2017
$2,785 (+2.2%)
$58,500 + $136,686
$195,186
2016
$2,726 (+1.8%)
$58,500 + $136,686
$195,186
2015
$2,677 (+1.7%)
$57,353 + $134,007
$191,360
2014
$2,631 (+5.3%)
$55,386 + $129,411
$184,797
2013
$2,499 (+2.6%)
$55,386 + $129,411
$184,797
2012
$2,437 (+1.7%)
$55,136 + $128,827
$183,963
2011
$2,396 (+6.0%)
$54,055 + $126,301
$180,356
2010
$2,261 (−22.5%)
$52,996 + $123,825
$176,821
2009
$2,917 (−31.3%)
$52,600 + $122,900
$175,500
2008
$4,245
$70,800 + $165,200
$236,000
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Permits
Beds
2
Baths
2
Stories
—
Lot width
—
Lot depth
—
Lot size
—
Year renovated
1973
Sq. Ft.
1,050
Year built
1973
Style
Condo/Co-op
County
Alameda County
APN
501 045610500
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 16, 2026.
R-G-29
Garden Residential District
To maintain and provide for developments constructed prior to the adoption of the R-3 multifamily residential district on July 22, 2003. No additional property is envisioned to be redesignated to this district. Property developed in this district is distinguished by ample garden/open space areas. District standards are maintained to ensure that developments are not considered nonconforming while providing for property improvements to meet sustainability goals of the general plan. The district may also incorporate service uses and limited commercial uses.
Permitted uses
Include but are not limited to:
Agriculture-Other
Housing-Multiple units
Housing-Senior
Housing-Other
Jun 30, 2017 • Final
Building
Perform plumbing work to remove and replace a water heater in the same location.
Plumbing
Water heater
Jun 30, 2017 • Final
Building
Remove and replace a support beam for an existing concrete landing with a new beam of the same specifications.
Remodel
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Parking
Parking Information
Has Carport
Parking Features: Carport, Parking Spaces, No Garage
Interior
Virtual Tour
Bathroom Information
# of Bathrooms Total: 2
# of Bathrooms Full: 2
Interior Features
Interior Features: No Additional Rooms, Stone Counters
Appliances: Dishwasher, Electric Range, Disposal, Refrigerator, Dryer, Washer
Home facts updated by county records on Sep 16, 2026
Around this home
Schools
Oliveira Elementary School
Public Tk-5 • Assigned • 0.6mi
8/10
Thornton Middle School
Public 6-8 • Assigned • 0.4mi
9/10
American High School
Public 9-12 • Assigned • 0.8mi
10/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Local insights from Redfin agents
Fremont’s housing market is cooling, with median sale prices down 6.5% year over year to $1.37 million in Sep 2026, desirable homes attract competition. Buyers find more negotiating opportunities as inventory rises, sellers should price competitively...
Fremont’s median sale price is approximately $1.37M, down 6.5% year over year. Homes sell in a median of 21 days, with a 101% sale-to-list ratio. Softer prices create opportunities for buyers, while sellers should focus on strategic pricing and...
Buyer demand in Fremont is keeping the market aggressive. Homes frequently receive multiple offers and go pending in about 20 days. With many properties closing above asking price, well-priced, move-in-ready homes offer sellers a distinct advantage...
Fremont's fall market offers clear buyer opportunities. Median prices hold steady around $1.4M with homes averaging three weeks on market. While move-in-ready homes draw quick competitive offers, properties needing cosmetic updates give you room to...
Property information provided by bridgeMLS, Bay East AOR, or Contra Costa AOR when last listed in 2024. This data may not match public records. Learn more.