Skip main navigation
Off market
  • $1,019,100

    247 Sycamore St, Fremont, CA 94536

    2beds
    1,036sqft
    SingleFamily
    Built in 1904
    5,066 Square Feet Lot
    $1,019,100 Zestimate®
    $984/sqft
    $3,072 Estimated rent

    Home value

    $1,019,100

    $968,000 - $1.08M

    $3,072/mo

    Zestimate® history
    Loading...

    Owner options

    List your home for rent

    $3,072/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

    $3,072/mo

    Rent Zestimate®

    Refinance and save

    $6,369/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

    $6,369/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Beautifully updated Cottage Next to the Serene Niles Creek with Amazing Views of the Rolling Hills and Canyon. This 2 Bedroom Starter home Features High Ceilings with New Flooring throughout, New Tile In Kitchen, New Baseboards, New Dual Pane Windows, New Kitchen Appliances, New Paint in and out, Inside Laundry with High Efficiency Tankless Water Heater, French Doors to Japanese Style Garden and Direct Access to the Creek and Walking Trails. Great Neighborhood and Walking Distance to the Elementary School. High School Rated 9 out of 10

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 2
    • Bathrooms: 1
    • Full bathrooms: 1
    Cooling
    • None
    Appliances
    • Included: Dishwasher, Microwave, Range / Oven
    • Laundry: Gas Hookup, Inside, Electricity Hookup (220V)
    Interior area
    • Total interior livable area: 1,036 sqft

    Property

    Parking
    • Parking features: Carport
    Lot
    • Size: 5,066 sqft
    Details
    • Parcel number: 50764547

    Construction

    Type & style
    • Home type: SingleFamily
    Materials
    • wood frame
    • Roof: Composition
    Condition
    • Year built: 1904

    Utilities & green energy

    • Utilities for property: Public Utilities

    Community & neighborhood

    Location
    • Region: Fremont

    Other

    Other facts
    • Amenities Misc.: High Ceiling, Walk-in Closet, Skylight, Garden Window
    • Building Type: Detached
    • Listing Class: Residential
    • Foundation: Concrete Perimeter
    • Lot Size Area Maximum Units: Square Feet
    • Lot Size Area Minimum Units: Square Feet
    • Roof: Composition
    • Structure SqFt Source: Assessor
    • Kitchen: Microwave, Dishwasher, Pantry, Oven Range - Gas, Cooktop - Gas
    • Family Room: Separate Family Room
    • Water: Public
    • Dining Room: Breakfast Bar
    • Listing Type: Exclusive Agency
    • Heating: Wall Furnace
    • Utilities: Public Utilities
    • Sewer Septic: Sewer - Public
    • Garage Parking Features: Parking Area, Carport
    • HOA Exist Y/N: 0
    • Additional Listing Info: Not Applicable
    • Laundry: Gas Hookup, Inside, Electricity Hookup (220V)

    Price history

    DateEventPrice
    3/23/2020Sold$775,000+0%$748/sqft
    Source: MLSListings Inc #ML81782502 Report a problem
    2/20/2020Listed for sale$774,900$748/sqft
    Source: Intero Real Estate Services #ML81782502 Report a problem
    2/20/2020Pending sale$774,900$748/sqft
    Source: Intero Real Estate Services #ML81782502 Report a problem
    2/13/2020Listed for sale$774,900+25%$748/sqft
    Source: Intero Real Estate Services #ML81782502 Report a problem
    12/20/2019Sold$620,000+12.7%$598/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025-- $901,463 +8.5%
    2024$10,234 +2.7%$830,947 +2%
    2023$9,961 +1.3%$814,656 +2%

    Find assessor info on the county website

    Neighborhood: Niles

    Nearby schools

    GreatSchools rating
    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
    $1,019,100
    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
    $1,019,100