NOT LISTED FOR SALE

4770 Gertrude Dr Fremont, CA 94536

Glenmoor Neighborhood

Estimated Value: $1,745,000 - $2,055,327

4 Beds
2 Baths
2,037 Sq Ft
$923/Sq Ft Est. Value

Last Sold February 09, 2024

Last sale price $1,860,000 $913 Per Sq Ft

Est. 1% increase in value since last sale

Current estimated payment $12,068/month

7 Days on Market

Highlights

  • Updated Kitchen
  • Fireplace in Primary Bedroom
  • Solid Surface Countertops
  • Tom Maloney Elementary School Rated A
  • Contemporary Architecture
  • No HOA

About This Home

As of February 2024

Owner was one of the engineers of Monterey Bay Aquarium and designed the unique expansion of this bright semi-custom home. First time available in 51 years. Huge great room. Large peaceful primary bedroom with fireplace and en-suite with eave windows. Oversize dual-pane windows. Breakfast nook with skylight. Shows as a 3 bedroom plus office, plus loft. Newer high-efficiency furnace. Close to schools, parks, pools, shops and dining. Easy access to 880 and 680 freeways, near 84 and BART, Lake Elizabeth, New Park Mall, Pacific Commons! Close to Fremont Hub, Whole Foods, Trader Joe’s, several grocery stores, restaurants, movie theaters. 12.5 miles to Facebook. 4.8 miles to Tesla. 20.4miles to Apple. Many included features... ask your agent.

Last Agent to Sell the Property

Anthony Marinelli

Compass License #01026943 Listed on: 01/03/2024

Compass

Co-Listed By

Charles Herrmann

Compass License #02192906

Last Buyer's Agent

Andrew Sturtevant Sturtevant

License #01775165

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $21,890

Year Built

  • Built in 1960

Lot Details

  • 6,119 Sq Ft Lot
  • Fenced
  • Rectangular Lot
  • Front Yard

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Home Design

  • Contemporary Architecture
  • Wood Siding
  • Stucco

Interior Spaces

  • 1-Story Property
  • Skylights
  • Wood Burning Fireplace
  • Gas Fireplace
  • Double Pane Windows
  • Living Room with Fireplace
  • 2 Fireplaces
  • Fire and Smoke Detector

Kitchen

  • Updated Kitchen
  • Breakfast Area or Nook
  • Built-In Oven
  • Microwave
  • Plumbed For Ice Maker
  • Dishwasher
  • Solid Surface Countertops

Flooring

  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Fireplace in Primary Bedroom
  • 2 Full Bathrooms

Laundry

  • Laundry in Garage
  • Dryer
  • Washer

Utilities

  • Cooling Available
  • Forced Air Heating System
  • Gas Water Heater

Community Details

  • No Home Owners Association
  • Bay East Association
  • Built by Mor Crest Glen
  • Glenmoor Subdivision, Expanded Floorplan

Listing and Financial Details

  • Assessor Parcel Number 50164116

Home Details

Home Type

Single Family

Est. Annual Taxes

$21,890

Year Built

Built in 1960

Lot Details

0

Parking

2

Listing Details

  • Stories: 1
  • Year Built: 1960
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Lot Size Acres: 0.14
  • Co List Office Mls Id: SHGM15
  • Subdivision Name: GLENMOOR
  • Directions: Glenview to Gertrude
  • Architectural Style: Contemporary
  • Carport Y N: No
  • Garage Yn: Yes
  • Unit Levels: One Story
  • New Construction: No
  • ResoPropertyType: Residential
  • ResoBuildingAreaSource: PublicRecords
  • Special Features: None

Interior Features

  • Flooring: Tile, Carpet
  • Appliances: Dishwasher, Plumbed For Ice Maker, Microwave, Oven, Refrigerator, Dryer, Washer, Gas Water Heater
  • Full Bathrooms: 2
  • Total Bedrooms: 4
  • Fireplace Features: Gas, Gas Starter, Living Room, Master Bedroom, Wood Burning
  • Fireplaces: 2
  • Fireplace: Yes
  • Interior Amenities: Breakfast Nook, Counter - Solid Surface, Updated Kitchen
  • Window Features: Double Pane Windows, Skylight(s)
  • Room Kitchen Features: Breakfast Nook, Counter - Solid Surface, Dishwasher, Ice Maker Hookup, Microwave, Oven Built-in, Refrigerator, Skylight(s), Updated Kitchen

Exterior Features

  • Fencing: Fenced
  • Lot Features: Level, Regular
  • Pool Features: None
  • Pool Private: No
  • Builder Name: Mor Crest Glen
  • Construction Type: Wood Siding, Siding - Stucco
  • Exterior Features: Front Yard
  • Property Condition: Existing

Garage/Parking

  • Garage Spaces: 2
  • Attached Garage: Yes
  • Covered Parking Spaces: 2
  • Parking Features: Attached, Enclosed, Garage Door Opener

Utilities

  • Heating: Forced Air
  • Utilities: Natural Gas Connected
  • Cooling: Ceiling Fan(s)
  • Laundry Features: Dryer, Gas Dryer Hookup, In Garage, Washer
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electric: No Solar
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • Association Name: BAY EAST
  • Association: No

Lot Info

  • Lot Size Sq Ft: 6119
  • Parcel Number: 50164116
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 3, 2024
Closed on
Jan 30, 2024
Sold by
Barbara Lugo Revocable Trust
Bought by
Hsu Diana and Xiong Yanil
Seller's Agent
Anthony Marinelli
Compass
Buyer's Agent
Andrew Sturtevant Sturtevant
List Price
$1,750,000
Sold Price
$1,860,000
Premium/Discount to List
$110,000
6.29%
Views
299
Current Estimated Value
$1,880,082

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$20,082
Avg. Annual Appreciation
0.07%
Original Mortgage
$1,302,000
Outstanding Balance
$1,290,494
Interest Rate
6.61%
Mortgage Type
New Conventional
Estimated Equity
$571,611

Purchase Details

Closed on
Aug 4, 2023
Sold by
Lugo Living Trust
Bought by
Barbara Lugo Revocable Trust and Lugo

Purchase Details

Closed on
Aug 21, 2014
Sold by
Lugo Leroy H and Lugo Barbara S
Bought by
Lugo Living Trust

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$938,250
Interest Rate
4.1%
Mortgage Type
FHA

Purchase Details

Closed on
Jun 18, 2003
Sold by
Lugo Leroy H and Lugo Barbara S
Bought by
Lugo Leroy H and Lugo Barbara S

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$225,000
Interest Rate
5.37%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Nov 10, 1993
Sold by
Lugo Leroy H and Lugo Barbara S
Bought by
Lugo Leroy H and Lugo Barbara S
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Hsu Diana $1,860,000 Old Republic Title Company
Barbara Lugo Revocable Trust -- None Listed On Document
Lugo Living Trust -- Placer Title Company
Lugo Leroy H -- Fidelity National Title
Lugo Leroy H -- Fidelity National Title
Lugo Leroy H -- --
Lugo Leroy H -- --
Lugo Leroy H -- --
Lugo Leroy H -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Hsu Diana $1,302,000
Previous Owner Lugo Living Trust $938,250
Previous Owner Lugo Leroy H $150,000
Previous Owner Lugo Leroy H $298,600
Previous Owner Lugo Leroy H $231,000
Previous Owner Lugo Leroy H $231,000
Previous Owner Lugo Leroy H $225,000
Previous Owner Lugo Leroy H $228,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/04/2025 02/04/25 Off Market $1,860,000 -- --
02/09/2024 02/09/24 Sold $1,860,000 +6.3% $913 / Sq Ft
01/10/2024 01/10/24 Pending -- -- --
01/03/2024 01/03/24 For Sale $1,750,000 -- $859 / Sq Ft
Source: Bay East Association of REALTORS®

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $21,890 $1,890,200 $569,160 $1,328,040
2024 $21,890 $1,860,000 $650,000 $1,210,000
2023 $2,031 $111,199 $23,799 $94,400
2022 $1,976 $108,881 $23,332 $92,549
2021 $1,934 $106,609 $22,875 $90,734
2020 $1,848 $112,444 $22,640 $89,804
2019 $1,831 $110,240 $22,196 $88,044
2018 $1,790 $108,079 $21,761 $86,318
2017 $1,827 $105,959 $21,334 $84,625
2016 $1,782 $103,882 $20,916 $82,966
2015 $1,745 $102,322 $20,602 $81,720
2014 $1,706 $100,317 $20,198 $80,119
Source: Public Records

Agents Affiliated with this Home

  • Anthony Marinelli

    Seller's Agent in 2024

    Anthony Marinelli

    Compass

    (510) 427-7565

    13 in this area

    95 Total Sales

    Section Image

  • C

    Seller Co-Listing Agent in 2024

    Charles Herrmann

    Compass

  • A

    Buyer's Agent in 2024

    Andrew Sturtevant Sturtevant

See All Agents

Map

Source: Bay East Association of REALTORS®

MLS Number: 41046643

Bay East Association of REALTORS®

APN: 501-0641-016-00

California Alameda County Fremont 94536 Glenmoor

4770 Gertrude Dr, Fremont, CA

This home is located at 4770 Gertrude Dr, Fremont, CA 94536 since 03 January 2024 and is currently estimated at $1,880,082, approximately $922 per square foot. This property was built in 1960. 4770 Gertrude Dr is a home located in Alameda County with nearby schools including Tom Maloney Elementary School, Centerville Junior High School, and Washington High School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Bay East Association of REALTORS® Bay East ©2025. CCAR ©2025. bridgeMLS ©2025. Information Deemed Reliable But Not Guaranteed. This information is being provided by the Bay East MLS, or CCAR MLS, or bridgeMLS. The listings presented here may or may not be listed by the Broker/Agent operating this website. This information is intended for the personal use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Nearby Homes