My Office's Listings

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

Creekside Area Single Family Home

Active

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
$2,988,000
Pending

Ardenwood Area Single Family Home

Pending

34011 Stetson Way Fremont, CA 94555

4 Bed
4 Baths
3105 sqft
MLS# 41062374
Virtual Tour
Welcome to this beautifully designed North East facing executive home in the coveted Patterson Ranch development of North Fremont. The light-filled open floorplan w/ high ceilings features a large formal living room and dining room with dramatic high ceilings and 2 beautiful chandeliers. The large chef's dream kitchen boasts gorgeous granite slab counters, an oversized island with dual-sink and breakfast bar, lots of wood cabinetry, stainless steel appliances and a spacious pantry room. Spacious approx. 20x20 family room. Relax in the large master suite with dual sink vanity, soaking tub, separate shower with clear glass enclosure. Other fine features include large ceramic tile and new quality carpeting flooring, recessed LED lighting throughout, air conditioning system, crown molding throughout large laundry room with cabinetry. Enjoy the professionally landscaped backyard with a custom stamped concrete patio with custom arbor, and stone planters. HOA amenities include a farmhouse style clubhouse, tennis and basketball courts, playground and manicured walkways. Excellent Fremont schools - American High, Thornton Jr High & Patterson Elem. Close to Facebook & Tesla and offers easy access to 880, 84/Dumbarton Bridge. Adjacent to Coyote Hills Regional Park & Alameda Creek Trails.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Joe Schembri
$2,499,000
Pending

Mission Area Single Family Home

Pending

41871 Via San Miguel Fremont, CA 94539

3 Bed
2 Baths
1949 sqft
MLS# 41062923
Virtual Tour
This stunning N-facing single-family home is nestled in a highly desirable Mission Highlands neighborhood within the Mission San Jose Golden Triangle area. The property boasts a huge 12,000-square-foot private lot perfect for living space and ADU extension. It is within walking distance to top-rated schools - Chadbourne Elementary, Hopkins Junior High, and Mission San Jose High School, making it ideal for growing families. It has 1,949 Sq Ft living space, including a formal living room, dining room, separate family room, kitchen, 3 bedrooms, and 2 bathrooms. The spacious gourmet kitchen features abundant maple cabinets, Corian countertops, a built-in refrigerator, and a professional free-standing gas stove with an oven. The large master suite includes a fully upgraded bath with a double sink vanity, a stall shower, and a walk-in closet with a closet organizer. Additional Features: Recessed lights; ceiling fan with light, closet organizer, mirror closet door in each bedroom; central heating and AC; double-pane windows with plantation shutters; and a picturesque view of Mission Hills from the kitchen. The huge backyard of this property is a true highlight, offering a Basketball/Sports Court, a variety of fruit trees, beautiful flowers, raised vegetable beds, and a storage shed.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Aimee Ran Song