Home | Alameda County | Fremont | 94536 | 2789 Harrisburg Ave
MLS: ML81981896 | Status: Sold | Price: $2,450,000
Beds/Baths: 4 / 3
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 4 | 3 | 2,383 | 5,000 | 1987 |
Welcome to this beautiful and highly sought-after Mission Lake Home! This 2-story magnificent single-family home offers a spacious and versatile layout, featuring 4 BDS, 3 BAS, and over 2300 sq ft of living space in the Mission Lake community. Upon entering, you'll be captivated by the high ceilings and crystal chandelier, large windows offering brunch of natural light. The main level boasts a spacious living room, dining room next to the heart of the home kitchen, and cozy family room, guest room and full bathroom, walk through from the laundry room access to an attached Two-car garage. The top floor offers 3BD, 2BA, a grand primary suite, spacious walk-in closet. Enjoy the convenience of being minutes away from Rainbow Lake and Trails, Quarry Lakes Regional Recreation Area. Situated within a good school district with easy access to highways! Don't miss this great opportunity!
| Field | Value |
|---|---|
| MLS # | ML81981896 |
| MLS Source | MLSListings, Inc. |
| Feature | Details |
|---|---|
| Dining Room | Dining Area |
| Family Room | Separate Family Room |
| Fireplace | Family Room |
| Cooling | None |
| Heating | Central Forced Air - Gas |
| Feature | Details |
|---|---|
| Roof | Shingle |
| Foundation | Crawl Space |
| Feature | Details |
|---|---|
| Garage/Parking | Attached Garage, Garage: 2 Car(s) |
| Elementary District | Fremont Unified |
| High School District | Fremont Unified |
| Sewer | Public Sewer |
| Water | Public |
| Zoning | R |
| Listing Agent | Co-Listing Agent |
|---|---|
| Jinying Su | Cindy Wang |
| BQ Realty | BQ Realty |
| License #: 01941681 | License #: 02104795 |
| Phone: (415) 860-8996 | Phone: (650) 618-9666 |
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| Brookvale Elementary School | public | TK,KG,1,2,3,4,5 | 0.38 mi | 7 |
| American High School | public | 9-12 | 0.61 mi | 10 |
| Oliveira Elementary School | public | TK,KG,1,2,3,4,5 | 0.96 mi | 7 |
| Warwick Elementary School | public | TK,KG,1,2,3,4,5 | 0.98 mi | 8 |
| Thornton Middle School | public | 6-8 | 1.21 mi | 9 |
| Patterson Elementary School | public | TK,KG,1,2,3,4,5 | 1.30 mi | 8 |
| James Logan High School | public | 9-12 | 1.32 mi | 8 |
| New Haven Adult | public | UG | 1.33 mi | N/A |
| Centerville Middle School | public | 6-8 | 1.40 mi | 8 |
| Niles Elementary School | public | TK,KG,1,2,3,4,5 | 1.57 mi | 8 |
| Cabrillo Elementary School | public | K-5 | 1.65 mi | 4 |
| Searles Elementary School | public | K-5 | 1.66 mi | 5 |
| Washington High School | public | 9-12 | 1.78 mi | 9 |
| Parkmont Elementary School | public | TK,KG,1,2,3,4,5 | 1.87 mi | 8 |
| Guy Jr. Emanuele Elementary School | public | K-5 | 1.88 mi | 7 |
| Glenmoor Elementary School | public | K-6 | 2.05 mi | 7 |
| Newark Adult | public | UG | 2.09 mi | N/A |
| Tom Maloney Elementary School | public | TK,KG,1,2,3,4,5 | 2.11 mi | 7 |
| Crossroads High (Alternative) School | public | K-12 | 2.11 mi | 5 |
| Bridgepoint High (Continuation) School | public | 9-12 | 2.11 mi | 1 |
©2026 MLSListings 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 MLSListings 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 February 02, 2026. For the most current information, please contact Jinying Su, (415) 860-8996.