Featured Properties

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,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