Off Market


Call For Address, Fremont, CA 94539


This custom Mission Hills/Weibel residence with stunning views is located in the prestigious Vineyards/Avalon neighborhoods of Fremont and is located on a sprawling premium beautifully landscaped property of over half an acre, and boasts an elegant design and luxurious amenities. Spanning approximately 4,598 sq ft, the home features 4 bedrooms, 3.5 bathrooms, a separate in-law unit, a 3-car garage, and a picturesque park-like yard. The double wooden doors lead to a formal entry with hardwood floors. The spectacular formal living room boasts vaulted ceilings, an expansive balcony, decorative lighting, and beautiful stained-glass windows. The formal dining room is adorned with a crystal chandelier and a built-in bar. The generous family room with vaulted ceiling features a gas fireplace with updated mantel. The kitchen is a culinary delight with custom cabinetry, a large walk-in pantry, granite counters with backsplash, a refrigerator, and a breakfast nook offering scenic views. The master bedroom is a retreat with a walk-in closet, sitting area, and stunning views. Its accompanying bathroom features dual sinks, a vanity area, a stall shower with glass enclosure, a skylight, and additional sitting space with cabinets. The functional laundry room contains a washer, dryer, broom cupboard, and ample cabinetry. Each bedroom has a walk-in closet, with one bedroom offering a sliding door to a private balcony with impressive views. Downstairs, a built-in cabinet setup makes an ideal office space. The in-law unit, with a separate entrance, includes a kitchen, a built-in temperature-controlled wine cellar, tile flooring, a large walk-in closet, and a full bathroom. The park-like backyard is an entertainer's paradise with an expansive custom-covered patio featuring new B&W speakers, recessed lighting, stone pavers, and breathtaking views of the Bay and Mission Peak. The yard is beautifully landscaped with mature trees, artificial grass, and a fountain with a pond. Additional notable features include Acacia hardwood flooring, crown molding, dual pane windows, fresh interior paint, abundant storage, a high-efficiency HVAC system, and an epoxy-floored garage. This residence is located in a prestigious neighborhood, served by top-ranked schools Weibel Elementary, Horner Junior High, and Irvington High School. Conveniently situated for commuting, it is minutes from highways 680 and 880, the BART station, and the heart of Silicon Valley, home to leading tech companies like Google, Apple, and Facebook.



4,598 Sq.Ft. LIVING AREA

22,837 Sq.Ft. lot

Joe Schembri

Joe Schembri

Features & Amenities


  • total bedrooms5
  • Total bathrooms3.5
  • full bathrooms3
  • half bathroom1

Area & Lot

  • Status Off Market
  • Living Area4,598 Sq.Ft.
  • Lot Area22,837 Sq.Ft.
  • NeighborhoodWeibel
  • Elementary SchoolWeibel Elementary
  • Middle SchoolHorner Middle School
  • High SchoolIrvington High School
  • School DistrictFremont Unified


  • Sales Price$3,998,000

Schedule a Showing

We would love to show you our beautiful property. Please select your preferred date and time below. An agent will be in touch shortly to confirm your appointment.

Schedule a Showing

We would love to show you our beautiful property. Please select your preferred date and time below. An agent will be in touch shortly to confirm your appointment.
Thank you for your interest in Call For Address, Fremont, CA 94539. We are reviewing your request and will be in touch shortly!

Mortgage Calculator

Estimate your monthly mortgage payment, including the principal and interest, property taxes, and HOA. Adjust the values to generate a more accurate rate.
$0,000 Your Payment 20 15 65
$0,000 Your Payment




Joe Schembri has been the leader in selling real estate in Fremont and surrounding areas for over two decades. He has a diverse background in marketing, sales, negotiation and customer service. His number one priority has always been to provide people with the highest quality of service and results.

Follow Us on Instagram