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,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
$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//20 & 7/21 1 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