My Office's Listings

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
$2,998,000
Active

Quail Run Area Single Family Home

Active

3480 Oriole Pl Fremont, CA 94555

4 Bed
3 Baths
2670 sqft
MLS# 41065755
Virtual Tour
HOA has 3 TENNIS COURTS, POOL & JACUZZI! Premium cul-de-sac Shapell home in the coveted Quail Run community on a 10K sq ft lot! 1 large bedroom + permitted ADI & 1 full bathroom downstairs. All 3 bathrooms are newly remodeled. Custom kitchen with high-end stainless steel appliances, soft close drawers, custom cherry wood cabinets w/under cabinet lighting, quartz counters w/full backsplash, Bay window, recessed ceiling with LED recessed lighting & new water fixtures. Luxury vinyl flooring in living room, downstairs bath & all throughout upstairs. Updated ceramic tile flooring for the rest of downstairs. Large formal living room & dining room w/recessed lighting. Family room w/wood burning fireplace, radiant heat flooring & large French door.Master bedroom with French door access to balcony. Other features include dual pane windows, plantation shutters, new interior doors, custom baseboards throughout, new int&ext paint,metal railing in living/dining room,new water heater,3-car garage w/new sink, faucet & garage door opener, newer high quality tile roof. Backyard oasis w/custom cement patio, new deck, space for ADU, newer fence & lots of new plants. Close to high-rated Warwick Elementary. Short stroll to Alameda Creek w/access to Coyote Hills & Quarry Lakes.Close to 880, 84 & more.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Joe Schembri