Interested in touring this property?
Virtual Tour
1/46
Listing Courtesy Of:
Wah Hing Corp., Peter Lai
Listing Sold By:
Sequoia Real Estate
Local Realty Services Provided By:
KW Advisors
4154 Lombard Ave, Fremont, CA 94536
Estimation provided by Keller Williams Realty Inc.
Property Description
GREAT INVESTMENT OPPORTUNITY! Duplex in Glenmoor neighborhood. Large lot. Live in one side and rent out the other . Utilize your passive income to pay down your mortgage. Or, let the investment stand alone in this desirable neighborhood. You will find this home very versatile. Both sides have 2 bedrooms and 1 bath. Garages with both 240v and gas access (EV with a gas dryer anyone?). The roof was recently replaced with 50-year asphalt shingles. Termite work done 2020. Custom paver/cement work, as well as drought tolerant landscaping. Unit A remodeled before list (update list in disclosures) with SS appliances. Unit B has a big juicy Mexican lime tree in the backyard. Great location for commuters with easy access to I-880 and 84/Dumbarton Bridge. Conveniently located to shopping and all public amenities. Buyers to participate in 1031 exchange with no cost to the buyer. The virtual tour can be found here: https://my.matterport.com/show/?m=wPKCpMDrjfT
Property Details
Compare This Home
Overview
Property Type
Duplex
Property Size
Year Built
1964
Days on Site
962 Days
HVAC
Forced Air, Ceiling Fan(s)
Parking
2 Parking Spaces
Margaret Apple | Real Estate Salesperson | Keller Williams Silicon Valley
Keller Williams Silicon Valley
DRE # 01199883
Activity History
VIEWS
SAVES
SHARES
Data provided by Keller Williams Realty, Inc.
Upcoming Open Houses
(Local time)
No open houses are currently scheduled for this property. Don't worry - you can always schedule a tour, or get additional help from your agent.
Estimated Monthly Payment
Purchase Price:
$1,400,000
Principal + Interest
Property Tax
Home Insurance
HOA/Condo Fee
Mortgage Insurance
Monthly Payment
$6,056
Monthly Payment
This calculator is just an estimate. Contact Keller Williams for full and accurate assessment.
Save thousands on your next home loan.
Clarity, transparency & ease in homeowner’s insurance.
Price & Tax History
Date
Event
Price
08/12/2022
Listed
No Tax History Data
There are no tax history data available for this property at this time. Please consult with your agent if you have any questions.
The Property History data displayed is obtained from public records and/or MLS feeds from the local jurisdiction in which the applicable property is located. As kw.com cannot guarantee that all public records and MLS data is accurate and error-free, it is important that you contact your agent directly in order to obtain the most up-to-date information available.
Explore Glenmoor
market snapshot
Nearby Schools
8/10
Glenmoor Elementary School
K-6th Grade
Student-Teacher Ratio:
25:1
9/10
Centerville Junior High School
7th-8th Grade
Student-Teacher Ratio:
22:1
9/10
Washington High School
9th-12th Grade
Student-Teacher Ratio:
24:1
N/A
Grade
Student-Teacher Ratio:
No data to show right now.
N/A
Prince Of Peace Lutheran School
N/A Grade
Student-Teacher Ratio:
14:1
N/A
Scribbles Montessori School
N/A Grade
Student-Teacher Ratio:
7:1
N/A
Holy Spirit School
N/A Grade
Student-Teacher Ratio:
21:1
N/A
Fremont Christian School
N/A Grade
Student-Teacher Ratio:
18:1
N/A
New Horizons School
N/A Grade
Student-Teacher Ratio:
12:1
N/A
Stellar Academy
N/A Grade
Student-Teacher Ratio:
14:1
N/A
Grade
Student-Teacher Ratio:
No data to show right now.
Show 3 More
Show Less
Disclaimer: This information is provided by
Precisely
and subject to change.
Please check the applicable school district.
Transit & Commute
Estimated commute times from Glenmoor
72%
Car-Dependent
Walkable
Very Walkable
Margaret Apple | Real Estate Salesperson | Keller Williams Silicon Valley
Keller Williams Silicon Valley
DRE # 01199883
Similar Properties
Properties with similar features, attributes, and price to this current listing
Featured Properties
Nearby Properties
Nearest properties to this current listing
Sourced By:
Data Source Origin: bridgeMLS/CCAR/Bay East
Equal Housing Opportunity. Data last updated 3/31/2025, 4:41:19 AM EST Bay East Copyright 2025. CCAR Copyright 2025. EBRDI Copyright 2025. Information deemed reliable but not guaranteed. This information is being provided by the Bay East MLS or the CCAR MLS or the EBRD MLS. The listings presented here may or may not be listed by the Broker/Agent operating this website.