Skip main navigation
Sold for $2,350,000 on 06/07/23
  • $2,350,000

    4557 Mayfield Ct, Fremont, CA 94536

    3beds
    2,263sqft
    Residential, Single Family Residence
    Built in 1954
    10,018.8 Square Feet Lot
    $2,494,000 Zestimate®
    $1,038/sqft
    $4,603 Estimated rent

    Owner options

    List your home for rent

    $4,603/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $4,603/mo

    Rent Zestimate®

    Refinance and save

    $15,076/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $15,076/mo

    Est. payment

    What's special

    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.

    Zillow last checked: 8 hours ago

    Listing updated: August 25, 2023 at 09:43am

    Listed by:

    Everett Eslinger DRE #00335018 510-714-7652,

    Coldwell Banker Realty

    Bought with:

    Sunil Sethi, DRE #01173766

    Sunil Sethi Real Estate

    Source: Bay East AOR,MLS#: 41026651MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 3
    • Full bathrooms: 2
    • Partial bathrooms: 1
    Bathroom
    • Features: Stall Shower, Tile, Updated Baths, Window, Shower Over Tub, Double Vanity
    Kitchen
    • Features: Breakfast Bar, Counter - Stone, Dishwasher, Double Oven, Garbage Disposal, Gas Range/Cooktop, Island, Range/Oven Built-in, Refrigerator, Updated Kitchen, Other
    Heating
    • Forced Air, Fireplace(s)
    Cooling
    • Ceiling Fan(s)
    Appliances
    • Included: Dishwasher, Double Oven, Gas Range, Range, Refrigerator
    • Laundry: Cabinets, Sink, Common Area
    Features
    • Formal Dining Room, Breakfast Bar, Updated Kitchen
    • Flooring: Tile, Carpet, Other
    • Windows: Screens
    • Basement: Crawl Space
    • Number of fireplaces: 2
    • Fireplace features: Brick, Dining Room, Family Room, Wood Burning
    Interior area
    • Total structure area: 2,263
    • Total interior livable area: 2,263 sqft

    Property

    Parking
    • Total spaces: 2
    • Parking features: Direct Access, Side Yard Access, Garage Faces Front, Garage Door Opener
    • Attached garage spaces: 2
    Features
    • Levels: One
    • Stories: 1
    • Patio & porch: Patio, Front Porch, Porch Steps
    • Exterior features: Entry Gate
    • Has private pool: Yes
    • Pool features: Gas Heat, In Ground, Membership (Optional), Pool Cover, Pool Sweep, Other, Outdoor Pool
    • Fencing: Fenced,Wood
    Lot
    • Size: 10,018 sqft
    • Features: Court, Front Yard, Pool Site, Back Yard, Side Yard, Landscape Back, Landscape Front
    Details
    • Parcel number: 50166714
    • Special conditions: Standard
    • Other equipment: Irrigation Equipment

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Ranch
    • Property subtype: Residential, Single Family Residence
    Materials
    • Brick, Stucco
    • Foundation: Raised
    Condition
    • Existing
    • New construction: No
    • Year built: 1954

    Utilities & green energy

    • Electric: No Solar

    Community & neighborhood

    Security
    • Security features: Carbon Monoxide Detector(s)
    Location
    • Region: Fremont
    • Subdivision: Glenmoor

    HOA & financial

    HOA
    • Has HOA: Yes
    • HOA fee: $250 annually
    • Amenities included: Greenbelt, Playground, Pool, Tennis Court(s), BBQ Area, Game Court Exterior, Park, Picnic Area
    • Services included: Common Area Maint
    • Association name: GLENMOOR GARDENS HOA
    • Association phone: 510-797-7600

    Other

    Other facts
    • Listing agreement: Excl Right
    • Listing terms: Cash,Conventional
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $2,494,000