Featured Properties

Some or all of the listings below are provided by the Fremont office.
$1,498,888
Pending

Creekside Area Single Family Home

Pending

34712 Lilac Street Union City, CA 94587

4 Bed
2 Baths
1569 sqft
MLS# 41067070
WOW!!!OVER $200K of high end upgrades in the past 5 years! This highly upgraded home has a sleek Tesla glass solar roof with 2 Tesla powerwalls that are incorporated into the grid w/PG&E and an EV charger. The open floorplan boasts a gourmet kitchen featuring commercial grade SS appliances, farm sink, island work station (seating for 8), dry bar with 2 wine cellars & pendant lighting. Notable improvements include 2 luxurious remodeled bathrooms, 6 panel doors, dp windows, plantation shutters, smart home devices, A/C unit, gas burning fireplace, recessed lighting, 2 sets of interior French doors, expanded hardwood flooring & more. The grounds are right out of Sunset Magazine. As you open the interior French doors that lead to the backyard’s expanded decking, you will be transported into your own urban oasis w/lush vegetation, a grilling station set under a pergola, expanded decking & imported Portuguese custom wood burning pizza oven. The extra wide lot has double gated side yard access which is RV friendly & boasts a concrete pad approx 50’x20’. There are manicured grounds, multiple water features & 3 storage sheds. With close proximity to BART, tennis courts, parks, shopping centers, and easy access to freeways and bridges, it's a total package. Don't miss this opportunity!
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Jerry Jacques
$1,999,000
Active

Union City Area Single Family Home

Active

4336 Pickerel Dr Union City, CA 94587

5 Bed
3 Baths
2298 sqft
MLS# 41066743
Virtual Tour
Welcome to highly desired Neighborhood*Award winning Union City Schools*Playgrounds and Parks nearby for kids to enjoy*Walking rail*Union Landing for shopping*Five Bedrooms*Three full baths*Two car garage*Front, back and side yard*Modern, Executive stunning home with custom features throughout the house*Newly painted exterior and interior*Welcoming living room with soaring ceiling, recessed lighting, mirrors and wood flooring*Fully renovated, custom kitchen with amazing stylish granite counter and backslash and high end appliances*Gas Stove*Refrigerator*Center island*Pantry and lots of cabinets for storage in Kitchen*75 smart TV and Bose surround sound (5.1 Dolby) system in the family room is a bonus*All three bathrooms have been recently renovated with custom vanities and toilets*Two separate fiber optic internet lines* Recessed lighting throughout the house* AC with Nest control* Plantation shutters throughout the house*Garage with custom built cabinets*Manicured front and backyard with tall trees*Come, enjoy and relax and make this home your before it's too! The house is conveniently located with easy access to Dumbarton & San Mateo bridges, 880 and 84 freeways It is also only a few minutes away from Meta, Tesla, Amazon, Stanford Healthcare and more! OH 7//27 & 7/28 2 to 4 pm
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Charo Bhatt