My Office's Listings

Some or all of the listings below are provided by the Fremont office.
$2,888,000 (USD)
Pending

Mission San Jose Area Single Family Home

Pending

644 Mission Creek Ct Fremont, CA 94539

4 Bed
3 Baths
2226 sqft
MLS# 41139116
Virtual Tour
Location, location, location! Nestled on a premium 8,424 square foot lot in the sought after Golden Triangle of Mission San Jose schools, this beautiful 4 bedrooms, 2.5 bathrooms west-facing home features thoughtful upgrades throughout. A double front entry door welcomes you into the elegant foyer leading to the formal front living room with vaulted ceilings and the separate formal dining area. The generous family room features an elegant fireplace and a sliding glass door to the backyard patio. The remodeled kitchen is equipped with custom wood cabinets, quartz countertops, stainless-steel sink with garden window, Wolf microwave, Wolf electric stove, Maytag dishwasher, and built-in Thermador oven. Additional features include newly installed premium luxury flooring, LED recessed lighting throughout, interior and exterior paint, window blinds, updated dual paned windows throughout, and an inside laundry room. All bathrooms have been remodeled with elegant quartz countertops and custom cabinetry. Comfort and efficiency are ensured by an updated Lennox HVAC system and a newer water heater. The outdoor space features a huge backyard with a patio, partial new fence, and mature fruit trees maintained by dedicated drip systems. This property provides access to top tier Mission San Jose schools including Chadbourne Elementary School, Hopkins Junior High School, and Mission San Jose High School just blocks away. Amazing location close to library, restaurants, shopping, sport courts, and Lake Elizabeth Central Park. Easy access to HWY 680, 880 Freeways, BART station, Facebook, Google and Apple.
Listing Courtesy of bridgeMLS / Listed By: Joe Schembri, Coldwell Banker Realty
$2,548,000 (USD)
Active

Stonebrae Country Club Area Single Family Home

Active

65 Stonebrae Rd Hayward, CA 94542

4 Bed
5 Baths
3420 sqft
MLS# 41143404
Exquisite and seldom available single-story residence in the prestigious Stonebrae Golf Club community, one of the East Bay's most desirable neighborhoods, offering spectacular panoramic views stretching from San Francisco to the South Bay. This exceptional home showcases extensive high-end upgrades and features 4 bedrooms, 4.5 bathrooms, two luxurious primary suites, and a spacious 3-car garage. The private secondary suite, complete with its own bedroom and separate living area, is ideal for extended family, guests, or multigenerational living. The bright, open floor plan with soaring ceilings welcomes you with an elegant foyer, a formal dining room, and an impressive great room with a fireplace. The gourmet kitchen features premium Viking appliances, a walk-in pantry, an oversized island with breakfast bar, designer lighting, custom cabinetry, granite countertops, a wine cooler, and a generous breakfast area with a fully retractable glass wall opening to the covered California room. Complete with a charming fireplace, this inviting outdoor living space seamlessly extends the home's entertaining areas. The awe-inspiring backyard is thoughtfully designed for year-round enjoyment, offering multiple seating areas, custom granite slab tile, a spa, architectural lighting, water features, and a charming arbor. An exceptional outdoor kitchen elevates the experience with two 40-inch barbecues (one natural gas and one charcoal), a 2-burner stove top, sink, two refrigerators, and two built-in ice bins, creating the perfect setting for memorable gatherings. Additional highlights include hardwood flooring, sound system inside and outside, recessed LED lighting, tankless water heater, a well-appointed laundry room with built-in cabinetry and a utility sink, and a 3-car garage wired for EV. Residents enjoy the peace of mind of a gated community with 24-hour guarded security, along with optional country club memberships that provide access to championship golf, tennis courts, a fitness center, and a resort-style pool. Ideally located with convenient access to Highways 92, 880, and 580, the home is approximately 30 minutes from all three major Bay Area airports.
Listing Courtesy of bridgeMLS / Listed By: Joe Schembri, Coldwell Banker Realty
$2,388,000 (USD)
Active

Mission Area Single Family Home

Active

40374 San Sebastian Pl Fremont, CA 94539

4 Bed
3 Baths
1914 sqft
MLS# 41141206
Virtual Tour
Location, Location, Location. Nestled in a tranquil and quiet court location in the highly coveted Gomes neighborhood, this residence is close to award-winning Gomes Elementary and charming Gomes Park. This stunning NW-facing home offers 4 bedrooms and 3 full bathrooms, with one bedroom and one full bathroom downstairs, offering great flexibility. A custom cherry wood front door opens to an elegant tile entryway, leading into a thoughtfully designed interior featuring a formal living room with vaulted ceilings, a formal dining room, and a cozy family room. The kitchen is updated with white solid wood cabinetry, slab granite countertops, a gas Viking stovetop with a high-end vent hood, and serene views from the kitchen. Additional fine interior details include custom hardwood flooring, new interior paint, new recessed lighting, double-pane windows throughout, central heating, fully paid-off solar panels for all electrical, a water softener, a metal roof, a car charger in the garage, an earthquake-safe gas line, and an LG washer. Extremely low PG&E bill because of solar systems. The outside is a true oasis, featuring a sparkling pool with a solar heating system, low-maintenance front and back yards, new exterior paint, and breathtaking views of Mission Peak from the upstairs main bedroom. This property falls under Gomes Elementary, Hopkins Jr High, and Mission San Jose High School attendance area. This home is very close to Lake Elizabeth Central Park with multiple attractions, shops, and local eateries. Easy access to 680 and 880, makes for a convenient commute to Silicon Valley.
Listing Courtesy of bridgeMLS / Listed By: Joe Schembri, Coldwell Banker Realty
$1,799,998 (USD)
Active

Sunnyvale Area Townhome

Active

332 Harcot Ter Sunnyvale, CA 94085

4 Bed
4 Baths
1916 sqft
MLS# 41143387
Located in the heart of Silicon Valley within walking distance to major employers, Caltrain, and Downtown Sunnyvale, this luxury three-story home is a former Toll Brothers model home featuring designer finishes throughout. The ground floor offers a private suite with a spacious bedroom and en-suite bathroom showcasing a quartz countertop and stall shower — perfect for multi-generational living, or as a dedicated home office for those who work remotely.The second level showcases a light-filled, open-concept floor plan with expansive windows on three walls, recessed lighting, and abundant natural light throughout. The inviting living room opens to a private balcony — a great space to entertain family and friends. The gourmet kitchen features a large island, quartz countertops, stainless steel appliances, ample cabinetry, and a separate pantry. A convenient half bathroom is tucked at the stair landing. The third floor is home to the primary suite, offering a spacious bedroom with large windows and an en-suite bathroom with double-vanity quartz countertops, a stall shower, and a walk-in closet. Two additional bedrooms are ideal for family or guests, complemented by a hallway bathroom with a quartz countertop and a shower-over-tub. Laundry with washer and dryer is conveniently located on the same level. Notable upgrades include custom Lutron motorized blinds and drapery — turning daylight into a dynamic design element throughout the home — a SkyBell video doorbell for anytime front-door access with an alarm system, an EV charger, and an attached two-car garage to name a few. Close to Downtown Sunnyvale, parks, restaurants, grocery stores, and shopping, with easy access to Caltrain, Highways 101 and 237, and a short commute to major tech companies. Don't miss this rare opportunity!
Listing Courtesy of bridgeMLS / Listed By: Moni Shah, Coldwell Banker Realty
$1,799,000 (USD)
Active

Glenmoor Area Single Family Home

Active

5353 Sayre Ave Fremont, CA 94536

4 Bed
2 Baths
1811 sqft
MLS# 41144014
Virtual Tour
Filled with natural light and thoughtfully designed for comfortable everyday living, this beautifully updated single-story home offers generous gathering spaces, quality improvements and all the charm of the Glenmoor neighborhood. The versatile floor plan features a welcoming living room, separate dining area and an expansive family room with soaring vaulted ceilings. Open to the family room, the custom kitchen is designed for both cooking and gathering with rich wood cabinetry, granite countertops, a skylight and stainless steel appliances including a built-in gas cooktop. Beautiful hardwood flooring, recessed lighting and built-in speakers extend throughout the home, creating a polished and cohesive feel from room to room. The private bedroom wing includes four bedrooms and two gorgeously remodeled bathrooms, each featuring a spacious stall shower and striking contemporary finishes. Sun tunnels bring additional natural light into the hallway and bathrooms. Additional highlights include central A/C, dual-pane windows, custom window coverings, smart switches, a whole-house fan, owned solar panels and updated waste lines. Recent improvements include a roof replaced in 2023 and a water heater replaced in 2024. The finished two-car garage offers extensive built-in cabinetry and exceptional storage. Paver hardscaping enhances both the front and backyard, where a covered deck, spacious lawn, storage shed and mature persimmon, orange and lemon trees create an inviting setting to relax or entertain. Ideally situated near Glenmoor’s parks, pools, tennis courts, schools, shopping and convenient commuter routes, this distinctive home brings together flexible living spaces, thoughtful upgrades and an unmistakably Glenmoor setting.
Listing Courtesy of bridgeMLS / Listed By: Lester Belliveau, Coldwell Banker Realty
$1,688,000 (USD)
Pending

Northgate Area Single Family Home

Pending

34455 Helston Pl Fremont, CA 94555

4 Bed
2 Baths
1504 sqft
MLS# 41141468
Virtual Tour
Introducing this beautifully updated single-level home on a quiet court in Fremont's sought-after Northgate neighborhood. Located within the attendance area of top-rated Warwick Elementary, Thornton Junior High, and American High School, this desirable residence offers a spacious open floor plan with a formal living room, dining area, and family room with fireplace and sliding glass door to the backyard. The custom remodeled kitchen features quartz slab countertops, designer glass mosaic tile backsplash, custom white shaker cabinetry, a spacious center island with breakfast bar seating, pantry storage, stainless-steel appliances, and a window overlooking the front yard. Both bathrooms have been tastefully remodeled with modern finishes. Additional highlights include luxury laminate flooring throughout, LED recessed lighting, and an updated entry door with decorative leaded-glass inserts. The private, low-maintenance backyard is designed for outdoor enjoyment, featuring a large stamped concrete patio with abundant space for gatherings, outdoor dining, and recreation, along with a charming pergola that provides a shaded retreat. Conveniently located near neighborhood parks, Alameda Creek Trail, shopping, dining, major commute routes including Highways 880 and 84, and major employers such as Meta, this exceptional Northgate home combines stylish updates with an outstanding location.
Listing Courtesy of bridgeMLS / Listed By: Joe Schembri, Coldwell Banker Realty
$1,680,000 (USD)
Active

Lake Area Single Family Home

Active

35791 Scarborough Dr Newark, CA 94560

3 Bed
3 Baths
1794 sqft
MLS# 41141478
Virtual Tour
Welcome to Newark Lake, one of Newark's most sought-after communities. This rare lakefront home offers exceptional privacy with breathtaking, unobstructed lake views from nearly every window and only one adjacent neighbor. The spacious living room showcases soaring vaulted ceilings that create a bright, open, and airy atmosphere, while the vaulted ceiling in the primary bedroom enhances the sense of space and comfort. The primary suite also features a private balcony, offering a peaceful retreat to enjoy beautiful lake views, morning coffee, or evening sunsets. Enjoy peaceful outdoor living in your private backyard with direct access to scenic walking trails surrounding the lake—perfect for morning walks, evening sunsets, and year-round relaxation. Beautifully renovated in 2016, the home features Viking dual-pane windows and French doors, granite countertops, a KitchenAid built-in oven and microwave, a Bosch dishwasher, and a Thermador gas cooktop. The dining area is filled with natural light from two large skylights, creating a bright and inviting space for everyday living and entertaining. Additional highlights include a 60-bottle wine refrigerator, a cozy gas fireplace, central heating and air conditioning, and washer/dryer hookups in both the home and garage. Outdoor upgrades include Belgard pavers (2021) and a three-zone irrigation system for effortless landscape maintenance. Ideally located with convenient access to Highways 880, 680, and 101, the Dumbarton Bridge, and just minutes from Meta, Tesla, Apple, Silicon Valley, and San Francisco, this home perfectly combines convenience with tranquil lakefront living. A rare opportunity to own one of Newark's finest lakefront properties. Don't miss your chance to make this exceptional home yours!
Listing Courtesy of bridgeMLS / Listed By: Aimee Ran Song, Coldwell Banker Realty
$1,640,000 (USD)
Pending

Eden Shores Area Single Family Home

Pending

29014 Jetty Way Hayward, CA 94545

4 Bed
3 Baths
2453 sqft
MLS# 41142354
Virtual Tour
Welcome to your dream home! Perfectly situated in the heart of the desirable Eden Shores community, this exquisite property pairs an ideal central location with undeniable curb appeal, showcasing a striking front facade and freshly updated, low-maintenance artificial turf. Step inside to discover a bright, open floor plan highlighted by soaring ceilings, newly installed carpet, and upgraded laminate flooring that creates an immediate sense of warmth and modern luxury. The main level thoughtfully includes a highly sought-after bedroom and full bathroom, offering the perfect private setup for guests, extended family, or in-laws. At the center of the home, the chef-inspired kitchen boasts premium granite slab countertops, a large island workstation, and abundant cabinetry, flowing effortlessly into an inviting family room anchored by a cozy fireplace. The upper level expands your living space with a highly versatile bonus loft that can easily be transformed into a fifth bedroom to suit your evolving needs. Retreat to the spacious primary suite, featuring a sprawling walk-in closet with custom organizers and a spa-like bathroom complete with an oval soaking tub and a separate stall shower. The additional upstairs bedrooms are equally generous in size and come equipped with built-in closet organizers for effortless storage. Throughout the property, intentional upgrades elevate everyday living, including sleek contemporary light fixtures, six-panel doors with updated hardware, and a crisp palette of fresh interior and exterior paint. Engineered for the future, the home features energy-efficient solar panels, a fresh epoxy painted garage equipped with a dedicated EV charger and a Tesla Powerwall. Outside, the meticulously designed backyard serves as a private oasis, boasting custom paver walkways, an elegant patio, stone accent walls, and synthetic turf optimized for easy entertaining. This turnkey residence truly has it all, offering immediate access to local shopping, dining, scenic walking trails, commuter bridges, and major freeways.
Listing Courtesy of bridgeMLS / Listed By: Jerry Jacques, Coldwell Banker Realty