Featured Properties

Some or all of the listings below are provided by the Fremont office.
$1,285,000 (USD)
Active

Newark Area Single Family Home

Active

36005 Rosewood Dr Newark, CA 94560

3 Bed
2 Baths
1579 sqft
MLS# 41131306
Virtual Tour
**Open house Thurs 10-1pm; Sat 4/25 & Sun 4/26 12-3pm** Location! Charm! Convenience! Designed for both everyday living & entertainment! This beautifully maintained Newark home offers a perfect blend of comfort, versatility, & outdoor charm. This inviting home features 3 bedrooms, 2 bathrooms, approximately 1399 sqft of living space on a 6000 sqft lot, w/living room, separate family room (great possible fourth bedroom), enclosed sunroom (approximately 180 sqft not included in square footage), interior laundry, & relaxing mature landscape. The spacious eat-in kitchen is thoughtfully appointed w/granite counters, a six-burner gas cooktop, dishwasher, large tile floors, movable island, & sky light. The bright living room showcases pleasant views of the front yard, recessed lighting, laminate floors, & cozy tile surround gas fireplace. The separate family room offers a brick surround stove fireplace, recessed lighting, laminate floors, closet, & is a great option for a potential 4th bedroom. The sunroom provides flexible space ideal as a family fun room, lounge, or home office. Additional highlights of the home features abundance of natural lighting, dual pane windows, leased solar panels, central heating, central air conditioning (updated in 2021), a 2025 main/sub panel replacement & 2 car garage. Step outside to enjoy the beautifully landscaped setting featuring a fenced garden in front, drip irrigation system, automatic sprinklers, pavers back patio, artificial grass, a tool shed, multiple fruit trees, & mature landscaping including roses, hibiscus, grapes, mandarin oranges, mint, & more. Ideally located w/easy access to Highway 84 (Dumbarton bridge) & interstate 880 this home is close to dining, shopping, entertainment, Lakeshore Park & Lake as well as within walking distance to Newark Community Center & Park. A wonderful opportunity to own a versatile & well-appointed home in a convenient & desirable location.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Jacqueline Martinez-Roberts
$1,398,888 (USD)
Active

Sunnyvale Area Townhome

Active

377 S Bernardo Ave Sunnyvale, CA 94086

2 Bed
3 Baths
1653 sqft
MLS# 41130950
Virtual Tour
Rare Tudor Manor End Unit Townhouse | Fully Remodeled | Prime Sunnyvale Location Rarely available Tudor Manor end unit townhouse, fully remodeled in 2026, offering modern upgrades, exceptional natural light, and a highly desirable floor plan. This two story end unit features high ceilings, recessed lighting, and stylish laminate flooring throughout, creating a bright and elegant living environment. The open concept layout includes a spacious living room flowing seamlessly into a formal dining area, perfect for entertaining. The family room opens to a private patio/backyard, ideal for enjoying morning coffee, outdoor dining, or an herb garden. Upstairs, a versatile nook provides the perfect home office or work from home space. The luxurious primary suite boasts a spa inspired bathroom with an expansive walk in shower, double sinks, vanity, and a large walk in closet. The second en suite bedroom is spacious and features its own private balcony, offering privacy and outdoor enjoyment. Located in a highly sought after Sunnyvale neighborhood, just minutes to Downtown Sunnyvale (5 minute drive) and Downtown Mountain View (6 minute drive). Low $250 HOA. Excellent commute location near major tech companies with easy access to Highways 85, 101, and 237. Situated in the Homestead High School district. This move in ready townhouse is a rare opportunity—don’t miss this exceptional home!
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Moni Shah
$3,999,999 (USD)
Pending

Mission Area Single Family Home

Pending

41473 Pelham Ct Fremont, CA 94539

5 Bed
4 Baths
3876 sqft
MLS# 41130705
Virtual Tour
Experience unparalleled privacy and modern luxury in this one-of-a-kind, 3,876 sq. ft. custom residence. Situated on a massive 15,985 sq. ft. premium court lot, this NE-facing home has been meticulously transformed with over $130,000 in recent designer upgrades. The seamless, no-step interior features a light-filled open layout with soaring picture windows offering a large formal front living room with picture windows and a signature floor-to-ceiling Carmel stone fireplace, a formal dining room, and a generous family room. The heart of the home is the chef’s kitchen, boasting newly installed quartz countertops, a full backsplash, a wine cooler, and high-end stainless appliances. Key Highlights: • Modern Interiors: Newly installed luxury flooring, fresh interior/exterior paint, and matte black hardware throughout. • Spa-Like Baths: All 3.5 bathrooms are newly updated with designer vanities, mirrors, and LED lighting. • Outdoor Oasis: A private retreat featuring a custom pool with red brick coping, aggregate decking, and professionally landscaped grounds. • Rare Perks: Oversized garage with new epoxy floors, a gated long driveway (parking for 8+ vehicles), and significant space for a potential ADU. • Location: Ideally located within the Golden Triangle, just one mile from top-rated Mission San Jose schools.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Joe Schembri
$2,788,000 (USD)
Active

Stonebrae Country Club Area Single Family Home

Active

128 Dunfirth Ct Hayward, CA 94542

5 Bed
5 Baths
4678 sqft
MLS# 41129475
Virtual Tour
Exquisite home in prestigious Stonebrae Golf Club community, one of the most idyllic East Bay locations with spectacular views from San Francisco to South Bay. This luxury residence offers 5 bedrooms plus office, bonus room and 4.5 bathrooms, including a primary suite downstairs. The home boasts coffered ceilings, crown molding, and wainscoting. The formal dining room provides the ideal space for memorable dinners, while the open-concept kitchen and family room are ideal for gatherings. The gourmet kitchen is equipped with high-end appliances, a walk-in pantry, and a center island. A fully collapsible sliding door connects the kitchen to the outdoor California room with fireplace and STUNNING BAY VIEWS. Upstairs, the expansive master suite offers a private balcony that provides breathtaking vistas and features an expansive walk-in closet, dual vanities, oversized tub, and a sit-down vanity area. Additional highlights include hardwood flooring, upgraded sound system in the great room, and laundry room with cabinets and a sink. The private backyard offers a covered patio with built-in BBQ, stamped concrete walkway, a putting green & a bocce court. The guarded community has 24-hour security and optional country club memberships with access to a gym, golf, tennis courts and pool.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Joe Schembri
$1,975,900 (USD)
Active

Twin Creek Views Area Single Family Home

Active

2481 Palmira Pl San Ramon, CA 94583

4 Bed
3 Baths
2760 sqft
MLS# 41130264
Welcome to 2481 Palmira Place in the exclusive Twin Creek View neighborhood. This beautifully maintained and updated home offers over 2760 ft of livable space on a 14,500+ foot lot. The owner spared no expense on the upgrades. The home features Brazilian hardwood floors throughout the first floor and the stair case, Milgard windows and an Andersen sliding door The formal living room and dining room are perfect for the holiday gatherings, the dining room has a lit coffered ceiling. The kitchen is all set for the chef to create masterful meals, featuring a Wolfe range, cherry cabinets, granite counters, a Fisher/Paykel dishwasher, and a wine refrigerator. The family room offers a gas fireplace and a Minka fan. There is a bonus room downstairs that could possibly be converted to a game room, office, craft room or a 5th bedroom! Head upstairs to the primary suite and 3 bedrooms. The primary bedroom has loads of closet space. The primary bath has been updated with dual sinks and a jetted shower. The front yard is neatly manicured. The backyard, which has many fruit trees, side access for a boat or RV, a storage shed and still space for an ADU, is awaiting your finishing touches. Oversized 3 car garage with a back storage room. Open house Sat 4/11 and Sun 4/12 from 1-4pm.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Anthony Bruno