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