My Office's Listings

Some or all of the listings below are provided by the Fremont office.
$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,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
$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
$1,888,000
Pending

Millwood Area Single Family Home

Pending

39005 Zacate Ave Fremont, CA 94539

4 Bed
2 Baths
1937 sqft
MLS# 41062558
Virtual Tour
Beautifully updated single-story Millwood home in a charming location. This property offers 4 bedrooms, 2 full baths & a modern floorplan w/vaulted ceilings. The custom entry door w/stained glass insert leads to the formal front living room. Beautifully refinished hardwood flooring covers the rest of the living space including the formal dining room w/a custom built-in bar & the spacious family room w/gas fireplace. Custom gourmet kitchen w/solid wood cabinetry, Corian counters w/custom edging, recessed ceiling w/recessed lighting, large window over sink & top-quality stainless-steel appliances. Expanded remodeled hall bathroom w/large double shower heads w/custom travertine shower floors&walls, jacuzzi tub & custom vanity w/granite counter. Other features include newly painted interior, elegant pocket French doors w/beveled glass, high-end French windows w/custom wood casings, new LED lights throughout, quality crown molding & high baseboard, new attic insulation, new carpeting in bedrooms & living room, newer presidential composition roof. Beautifully landscaped yards w/custom brick front walkways, covered front porch, custom backyard patio w/red brick inlays & arbor, gunite pool w/solar heating & 2 waterfalls, planters, fruit trees. Easy access to 680, 880, & Silicon Valley.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Joe Schembri