Geoff Hollands Geoff Hollands


Open House: Mar 18, 2018 1:30 PM - 4:30 PM

38043 Stenhammer DR


Beds: 5
Baths: 4
Sq. Ft.: 2,884
Listing #ML81692641
Beautiful Niles Canyon home in very quiet setting.A perfect home for a growing family.FIVE BED W/FOUR BATHS,THREE FIREPLACES, New Flooring, Totally Remodeled Kitchen with Stainless Steel Appliances, Soft Close Kitchen Cabinets, All Bathrooms remodeled, Paint, Light Fixtures , Carpet, New Roof With Solar Solar Edge, New Deck, Remodeled Shed / Workout Room, NEW Water Heater, New Heater. New Ejector Pump,, New installed outdoor Security cameras and More ... Nestled in beautiful Fremont Hills, walking distance to well-reputed Fremont Unified School. Great neighbors. Very short driving distance to Tesla, Facebook all major freeways and 84. Walking distance to many hiking paths. A serene getaway you can still call home.
Property Features
Location Information
County: Alameda
Neighborhood: Union City
MLS Area: 3500
Cross Street: 2454 Benchmark Ave
Interior Features
Dining Room Description: Other
Has Family Room: yes
Family Room Description: Other
Kitchen Description: 220 Volt Outlet, Countertop - Tile, Dishwasher, Oven Range - Built-In
Amenities: Skylight
Has Fireplace: yes
Fireplace Description: Family Room, Living Room, Master Bedroom
Heating: Forced Air, Wall Furnace
Cooling: Window / Wall Unit
Exterior Features
Style: Craftsman
Foundation: Crawl Space
Roof: Composition
Septic or Sewer: Sewer - Public
Water: Public
Utilities: Public Utilities
Parking Description: Gate / Door Opener, Off-Street Parking
Garage Spaces: 1
Yard: Back Yard, Deck
Is a Horse Property: No
Lot Size in Acres: 0.139
Lot Size in Sq. Ft.: 6, 048
Zoning: R1
Has View: No
Additional Information
Property Type: SFR
Property SubType: Detached Single Family
Year Built: 1980

$ per month
Year Fixed. % Interest Rate.
Principal + Interest: $
Monthly Tax: $
Monthly Insurance: $
Interest Rate
Down Payment
List Price:
Based on a fully amortized fixed rate loan. Ask your agent for the tax rates in your area. Insurance estimate is based on an average cost, your final premium cost will be determined by the type of coverage you select. This program only provides an estimate.
Seller's Representative: John Ou, Coldwell Banker The Professional Group
© 2018 MLSListings Inc. All rights reserved.
The data relating to real estate for sale on this website comes in part from the Internet Data Exchange (IDX) program of the MLSListings™ MLS system. Real estate listings held by brokerage firms other than Coldwell Banker-Los Gatos are marked with the IDX icon (a stylized house inside a circle) and detailed information about them includes the names of the listing brokers and listing agents. Based on information from MLSListings MLS as of the date shown below. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Some properties appearing for sale on this website may subsequently have sold and may no longer be available.
MLSListings data last updated at March 18, 2018 7:03 AM PT