NOT LISTED FOR SALE

4557 Mayfield Ct Fremont, CA 94536

Glenmoor Neighborhood

Estimated Value: $1,899,000 - $2,608,667

3 Beds
2.5 Baths
2,263 Sq Ft
$1,049/Sq Ft Est. Value

Last Sold June 07, 2023

Last sale price $2,350,000 $1,038 Per Sq Ft

Est. 2% increase in value since last sale

Current estimated payment $15,463/month

6 Days on Market

Highlights

  • In Ground Pool
  • Updated Kitchen
  • Wood Flooring
  • Glenmoor Elementary School Rated A
  • Dining Room with Fireplace
  • 3-minute walk to Meyer Park Playground

About This Home

As of June 2023

A JOURNEY’S END GLENMOOR HOME! This amazing open-concept court location Glenmoor you will want to call your own! Very large, high-end Kitchen, with custom walnut cabinetry and stainless-steel appliances, is only the beginning. Floor-to-Ceiling windows with beautiful views of a modern salt-water pool (with safety cover). Extra-Large Family Room and large Formal Dining Room. Two fireplaces, central air conditioning and an inside Laundry Room (w/ sink & cabinets). Located in a highly sought-after, deep in Glenmoor, court location. Please view Property Website, which includes Showcase Video, Floorplan Diagram and more.

Last Agent to Sell the Property

Everett Eslinger

Coldwell Banker Realty License #00335018 Listed on: 05/10/2023

Coldwell Banker Realty

Last Buyer's Agent

Sunil Sethi

License #01173766

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $27,973

Year Built

  • Built in 1954

Lot Details

  • 10,200 Sq Ft Lot
  • Wood Fence
  • Landscaped
  • Front and Back Yard Sprinklers
  • Back Yard Fenced and Front Yard

HOA Fees

  • $21 Monthly HOA Fees

Parking

  • 2 Car Direct Access Garage
  • Front Facing Garage
  • Garage Door Opener

Home Design

  • Brick Exterior Construction
  • Raised Foundation
  • Shake Roof
  • Stucco

Interior Spaces

  • 1-Story Property
  • Wood Burning Fireplace
  • Brick Fireplace
  • Window Screens
  • Family Room with Fireplace
  • Dining Room with Fireplace
  • 2 Fireplaces
  • Formal Dining Room

Kitchen

  • Updated Kitchen
  • Breakfast Bar
  • Double Oven
  • Built-In Range
  • Dishwasher
  • Kitchen Island
  • Stone Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Pool

  • In Ground Pool
  • Gas Heated Pool
  • Outdoor Pool
  • Spa
  • Pool Cover
  • Pool Sweep

Utilities

  • Forced Air Heating and Cooling System

Listing and Financial Details

  • Assessor Parcel Number 50166714

Community Details

Overview

  • Association fees include common area maintenance
  • Glenmoor Gardens HOA, Phone Number (510) 797-7600
  • Glenmoor Subdivision
  • Greenbelt

Amenities

  • Community Barbecue Grill
  • Picnic Area

Recreation

  • Tennis Courts
  • Outdoor Game Court
  • Community Pool
  • Pool Membership Available
  • Park

Home Details

Home Type

Single Family

Est. Annual Taxes

$27,973

Year Built

Built in 1954

Lot Details

0

HOA Fees

$21 per month

Parking

2

Listing Details

  • Stories: 1
  • Year Built: 1954
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Lot Size Acres: 0.23
  • Subdivision Name: GLENMOOR
  • Directions: Mowry - Blacow - Eggers - Glenmoor - Mayfield Ct
  • Architectural Style: Ranch
  • Carport Y N: No
  • Garage Yn: Yes
  • Unit Levels: One Story
  • New Construction: No
  • ResoPropertyType: Residential
  • ResoBuildingAreaSource: PublicRecords
  • Special Features: VirtualTour

Interior Features

  • Flooring: Carpet, Hardwood, Other, Tile
  • Basement: Crawl Space
  • Appliances: Dishwasher, Double Oven, Disposal, Gas Range, Range, Refrigerator
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • Fireplace Features: Brick, Dining Room, Family Room, Wood Burning
  • Fireplaces: 2
  • Fireplace: Yes
  • Interior Amenities: Family Room, Formal Dining Room, Breakfast Bar, Stone Counters, Kitchen Island, Updated Kitchen
  • Window Features: Screens
  • Room Kitchen Features: Breakfast Bar, Counter - Stone, Dishwasher, Double Oven, Garbage Disposal, Gas Range/Cooktop, Island, Other, Range/Oven Built-in, Refrigerator, Updated Kitchen

Exterior Features

  • Roof: Shake
  • Fencing: Fenced, Back Yard, Wood
  • Lot Features: Court, Front Yard, Landscape Back, Landscape Front, Pool Site
  • Pool Features: Gas Heat, In Ground, Membership (Optional), Pool Cover, Pool Sweep, Other, Outdoor Pool
  • Pool Private: Yes
  • Construction Type: Brick, Stucco
  • Exterior Features: Backyard, Back Yard, Front Yard, Side Yard, Sprinklers Automatic, Sprinklers Back, Sprinklers Front, Entry Gate, Landscape Back, Landscape Front
  • Foundation Details: Raised
  • Property Condition: Existing

Garage/Parking

  • Garage Spaces: 2
  • Attached Garage: Yes
  • Covered Parking Spaces: 2
  • Parking Features: Attached, Garage, Int Access From Garage, Enclosed, Garage Faces Front, Side Yard Access, Garage Door Opener
  • Total Parking Spaces: 2

Utilities

  • Heating: Fireplace(s), Forced Air
  • Utilities: All Public Utilities
  • Cooling: Ceiling Fan(s), Central Air
  • Laundry Features: Cabinets, Laundry Room, Sink
  • Security: Carbon Monoxide Detector(s), Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electric: No Solar
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • Amenities: BBQ Area, Greenbelt, Playground, Pool, Game Court Exterior, Park, Picnic Area, Spa/Hot Tub, Tennis Court(s)
  • Association Fee: 250
  • Association Fee Frequency: Annually
  • Association Name: GLENMOOR GARDENS HOA
  • Phone: 510-797-7600
  • Association: Yes
  • Pets Allowed: Yes
  • ResoAssociationFeeFrequency: Annually

Fee Information

  • Association Fee Includes: Common Area Maint

Schools

  • Senior High School District: Fremont (510) 657-2350

Lot Info

  • Lot Size Sq Ft: 10200
  • Parcel Number: 50166714
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Sep 12, 1997
Sold by
Mcelwain Lester S
Bought by
Myers James P and Myers John
Current Estimated Value
$2,394,697

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$20,000
Interest Rate
7.54%
Mortgage Type
Unknown

Purchase Details

Closed on
Sep 11, 1997
Sold by
Ahmad Shirley B Mcmurphy and Myers James P
Bought by
Haug Robert D and Haug Mary

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$20,000
Interest Rate
7.54%
Mortgage Type
Unknown

Purchase Details

Closed on
May 29, 1997
Sold by
Mcelwain Lester S
Bought by
Ahmad Shirley B Mcmurphy and Myers John

Purchase Details

Closed on
Mar 8, 1996
Sold by
Mcelwain Lester S
Bought by
Ahmad Shirley B Mcmurphy and Myers John

Purchase Details

Closed on
Dec 28, 1995
Sold by
Mcelwain Lester S
Bought by
Mcmurphy Shirley B and Myers John
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
Myers James P -- American Title Co
Haug Robert D -- American Title Co
Ahmad Shirley B Mcmurphy -- --
Ahmad Shirley B Mcmurphy -- --
Mcmurphy Shirley B -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Haug Mary $745,000
Closed Haug Mary $672,000
Closed Haug Mary $669,000
Closed Haug Mary $670,000
Closed Haug Mary $590,000
Closed Haug Robert D $536,250
Previous Owner Haug Robert D $525,000
Previous Owner Haug Robert D $20,000
Previous Owner Myers James P $58,500
Previous Owner Haug Robert D $312,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/04/2025 02/04/25 Off Market $2,350,000 -- --
06/07/2023 06/07/23 Sold $2,350,000 -1.7% $1,038 / Sq Ft
05/17/2023 05/17/23 Pending -- -- --
05/10/2023 05/10/23 For Sale $2,389,950 -- $1,056 / 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 $27,973 $2,584,040 $858,330 $1,725,710
2024 $27,973 $2,397,000 $841,500 $1,555,500
2023 $7,815 $631,333 $179,557 $451,776
2022 $7,706 $611,955 $176,037 $442,918
2021 $7,518 $599,819 $172,585 $434,234
2020 $7,515 $600,599 $170,816 $429,783
2019 $7,430 $588,825 $167,467 $421,358
2018 $6,932 $547,282 $164,184 $383,098
2017 $6,758 $536,553 $160,966 $375,587
2016 $6,638 $526,035 $157,810 $368,225
2015 $6,545 $518,134 $155,440 $362,694
2014 $6,429 $507,986 $152,396 $355,590
Source: Public Records

Agents Affiliated with this Home

  • Everett Eslinger

    Seller's Agent in 2023

    Everett Eslinger

    Coldwell Banker Realty

    (510) 608-7636

    50 in this area

    86 Total Sales

    Section Image
  • Sunil Sethi

    Buyer's Agent in 2023

    Sunil Sethi

    (510) 388-2436

    2 in this area

    62 Total Sales

    Section Image
See All Agents

Map

Source: Bay East Association of REALTORS®

MLS Number: 41026651

Bay East Association of REALTORS®

APN: 501-0667-014-00

California Alameda County Fremont 94536 Glenmoor

4557 Mayfield Ct, Fremont, CA

This home is located at 4557 Mayfield Ct, Fremont, CA 94536 since 10 May 2023 and is currently estimated at $2,374,917, approximately $1,049 per square foot. This property was built in 1954. 4557 Mayfield Ct is a home located in Alameda County with nearby schools including Glenmoor 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