Home | Alameda County | Union City | 94587 | 34794 Williams Way
MLS: ML82029620 | Status: Sold | Price: $3,005,000
Beds/Baths: 5 / 4 /1
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 5 | 4 /1 | 3,642 | 6,500 | 2003 |
Beautifully updated home offering 5 BD and 4.5 BA, introduced w/ the gentle presence of the Queen of the Nights, often cherished as a symbol of good fortune and new beginnings. The soaring volume ceilings & a sweeping curved staircase that sets a refined tone throughout the home. The gourmet kitchen features high-end appliances including a Sub-Zero fridge, abundant cabinetry, & a generous island ideal for cooking and gathering. Light-filled living spaces showcase hardwood floors across the main level. A desirable floor plan offers 1BD & 1.5 BA on the main level, perfect for guests or extended family. Upstairs bedrooms include multiple private suites, a remodeled Jack-and-Jill w/ 2 vanities, & a spacious primary suite w/ a large walk-in closet & oversized spa-style bathroom. Additional upgrades include remodeled baths, a whole-house fan for cooling and efficiently venting cooking aromas, and fragrant Queen of the Nights planted along the side yard. The backyard has been thoughtfully upgraded w/ lifetime-guaranteed pavers, a covered pergola for year-round outdoor living, & mature landscaping that enhances privacy and serenity. A 3-car garage with epoxy floors and two EV chargers. 1 car garage has Bose surround sound system. Close proximity to Oak, SFO, SJC airports
| Field | Value |
|---|---|
| MLS # | ML82029620 |
| MLS Source | MLSListings, Inc. |
| Feature | Details |
|---|---|
| Bathrooms | Shower over Tub - 1, Solid Surface, Stall Shower, Tile, Tub w/Jets, Updated Bath(s) |
| Kitchen | Countertop - Stone, Hookups - Ice Maker, Island, Pantry |
| Appliances | Dishwasher, Garbage Disposal, Microwave, Oven - Double, Oven Range - Gas, Refrigerator |
| Dining Room | Breakfast Nook, Formal Dining Room |
| Family Room | Separate Family Room |
| Fireplace | Family Room, Gas Starter |
| Flooring | Carpet, Concrete, Hardwood, Tile |
| Laundry | In Utility Room |
| Cooling | Central Forced Air, Whole House Fan |
| Heating | Central Forced Air |
| Feature | Details |
|---|---|
| Roof | Composition |
| Foundation | Slab |
| Feature | Details |
|---|---|
| Garage/Parking | Attached Garage, Gate/Door Opener, Garage: 3 Car(s) |
| Elementary District | New Haven Unified |
| High School District | New Haven Unified |
| Sewer | Public Sewer |
| Water | Public |
| Zoning | r1 |
Wen Guo RE Group
KW Advisors
License #: 01353370
Phone: (650) 776-4085
©2026 MLSListings Inc. All rights reserved. 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. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from MLSListings Inc.
Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.
This listing information is up-to-date as of February 07, 2026. For the most current information, please contact Wen Guo RE Group, (650) 776-4085.