Skip main navigation
Off market
  • $1,188,700

    5999 Show Ter, Fremont, CA 94555

    3beds
    1,839sqft
    Single Family Residence
    Built in ----
    -- sqft lot
    $1,188,700 Zestimate®
    $646/sqft
    $4,177 Estimated rent

    Home value

    $1,188,700

    $1.06M - $1.33M

    $4,177/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $4,177/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,177/mo

    Rent Zestimate®

    Refinance and save

    $7,597/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

    $7,597/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

    Brand new luxury carpetFamily room with fireplaceFamily roomEat in kitchenIndoor laundry room

    Welcome to 5999 Show Terrace, Fremont! This beautiful home has it all: 3 bedrooms 2.5 baths, living room, family room, dining area in living room, eat in kitchen, family room with fireplace! Indoor laundry room; washer and dryer included. 3 spacious bedrooms, primary suite with jacuzzi and standing shower! Single sink vanity in hallway bathroom. Forced air heating, 2 car attached garage, pleasant rear yard with fruit trees! Close to Ardenwood Elementary School! Baths are remodeled. Brand New luxury carpet, Brand New dual Pane windows and doors. No smoking, No pets; Rental Insurance required. Tenant pays water, PGE, Garbage and Gardener. HOA is Included in rent. -Walking distance to Facebook, Google employee shuttle stop. Close to new Facebook and Tesla Campus in Ardenwood. -Conveniently located with SAFEWAY, Sprouts, CVS, Ranch 99, CHASE, CITI and Wells Fargo within 5 mins driving. -Adjacent to the KARL NORDVIK park with children playground, basketball and football courts. Kid friendly neighborhood. Community Pool. Superb location! Close to 84/880 commute. Close to shopping, restaurants, parks Available by 12/01/25. Tenant pays: water, electricity, gas and garbage. Gardener and HOA included. Tenant pays water, electricity, gas and garbage. Minimum 1 year lease required. Strictly No Pets/smoking. If interested for 18 month we can negotiate the rent price. Please go ahead and submit the application if you are interested in this property. Filling an application is mandatory. Tenant pays: water, electricity, gas and garbage.

    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.

    Zillow last checked:

    Listing updated:

    Source: Zillow Rentals

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 3
    • Full bathrooms: 2
    • 1/2 bathrooms: 1
    Heating
    • Forced Air
    Appliances
    • Included: Dishwasher, Dryer, Freezer, Microwave, Oven, Refrigerator, Washer
    • Laundry: In Unit
    Features
    • Flooring: Carpet, Hardwood, Tile
    Interior area
    • Total interior livable area: 1,839 sqft

    Property

    Parking
    • Parking features: Attached
    • Has attached garage: Yes
    • Details: Contact manager
    Features
    • Exterior features: Electricity not included in rent, Garbage not included in rent, Gas not included in rent, Heating system: Forced Air, Water not included in rent
    Details
    • Parcel number: 543450213

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence

    Community & neighborhood

    Location
    • Region: Fremont

    HOA & financial

    Other fees
    • Deposit fee: $4,200

    Other

    Other facts
    • Available date: 12/01/2025

    Price history

    DateEventPrice
    11/1/2025Listing removed$4,200$2/sqft
    Source: Zillow Rentals Report a problem
    10/15/2025Listed for rent$4,200$2/sqft
    Source: Zillow Rentals Report a problem
    11/10/2024Listing removed$4,200$2/sqft
    Source: Zillow Rentals Report a problem
    10/24/2024Listed for rent$4,200+7.7%$2/sqft
    Source: Zillow Rentals Report a problem
    10/3/2024Listing removed$3,900$2/sqft
    Source: Zillow Rentals Report a problem
    9/18/2024Listed for rent$3,900$2/sqft
    Source: Zillow Rentals Report a problem
    1/27/2011Sold$605,000+12%$329/sqft
    Source: Agent Provided Report a problem
    11/25/2003Sold$540,000+11.3%$294/sqft
    Source: Bay East AOR #11207275 Report a problem
    8/11/2000Sold$485,000+91.7%$264/sqft
    Source: Bay East AOR #11057345 Report a problem
    10/28/1994Sold$253,000$138/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025-- $85,321 +2%
    2024$1,083 +2.3%$83,648 +2%
    2023$1,059 +0.8%$82,008 +2%
    2022$1,050 +2.4%$80,400 +2%
    2021$1,026 -1.3%$78,824 +1%
    2020$1,039 +3.7%$78,016 +2%
    2019$1,002 +4%$76,487 +2%
    2018$964 $74,988 +2%
    2017$964 +2.6%$73,518 +2%
    2016$939 +4.6%$72,077 +1.5%
    2015$897 $70,995 +2%
    2014$897 $69,604 +0.5%
    2013-- $69,290 +2%
    2012-- $67,932 -33.7%
    2011-- $102,400 +2.4%
    2010-- $100,000

    Find assessor info on the county website

    Neighborhood: Ardenwood

    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,188,700
    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,188,700