My Office's Listings

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

Newark Area Single Family Home

Active

5984 Fair Ave Newark, CA 94560

3 Bed
2 Baths
1431 sqft
MLS# 41144877
Virtual Tour
Presenting this beautifully updated Newark home, perfectly situated on a spacious lot of approximately 6,000 square feet. This property offers 3 bedrooms and 2 full bathrooms plus and attached ADU, that can be opened up to enlarge the house square footage. The well-designed floor plan features a generous family room with recessed lighting, a sliding glass door to the backyard covered deck, and a charming fireplace, creating a welcoming space to relax and unwind. The adjoining dining area is ideal for family meals or casual gatherings with friends, making this home both functional and inviting. The updated kitchen is bright and efficient, featuring upgraded shaker style cabinetry with granite counter, smooth top electric stove with vent hood, stainless-steel sink with view window, updated stainless-steel appliances, and breakfast nook. Both bathrooms have been tastefully remodeled with updated vanity, sink, plumbing and lighting fixtures, shower surround, and glass shower enclosure. Additional improvements include new interior luxury flooring, split system AC in living room and bedroom, dual pane windows and sliding door, new entryway door, fresh interior paint, upgraded baseboards, new interior raised panel doors, and leased solar electrical giving the home a modern and move-in-ready feel. The ADU with dual pane windows and AC system features a well-designed kitchen with quarts counter tops, maple cabinets, smooth top electric stove, and recessed lighting. The ADU is completed with an updated bathroom with shower over tub, onyx surround, upgraded plumbing and electrical fixtures, vanity and sink, inside laundry and closet. Enjoy spacious front and back yards with plenty of room to garden, play, or entertain. This home’s location adds to its appeal, with shops, local eateries, parks, sports courts, Mayhews Landing Park, Newpark Mall, and nearby schools just minutes away. Easy connections to Interstate 880, the 84/Dumbarton Bridge, and BART make it simple to reach Silicon Valley, San Francisco, and beyond.
Listing Courtesy of bridgeMLS / Listed By: Joe Schembri, Coldwell Banker Realty
$1,328,000 (USD)
Active

Niles Area Single Family Home

Active

312 Rivercreek Dr Fremont, CA 94536

3 Bed
3 Baths
1416 sqft
MLS# 41144727
Virtual Tour
Presenting this beautifully updated North West-facing single-family detached home nestled in a sought-after North Fremont neighborhood. Thoughtfully designed for comfortable living, this inviting home offers vaulted ceilings, fresh interior paint, new luxury flooring downstairs, new quality carpeting in the bedrooms and stairs, recessed lighting, 2.5 newly remodeled bathrooms, a newly remodeled custom kitchen, newly landscaped front and backyard with patio and mature trees, and no HOA. The bright and modern floor plan welcomes you with a spacious front living room featuring dramatic vaulted ceilings, a charming bay window, abundant natural light, and a newly refaced fireplace. Adjacent, the formal dining area provides an elegant setting for dinners and special gatherings. A separate family room offers additional space for relaxing, entertaining, and everyday living. The newly remodeled kitchen features all-new cabinetry with soft-close drawers, quartz countertops, new stainless-steel appliances, and a casual breakfast area with a sliding glass door opening to the backyard patio, creating an easy connection to outdoor living. Upstairs, the generous primary suite boasts high ceilings, a bay window, a walk-in closet, and an elegant newly remodeled bathroom. The additional bedrooms provide versatile space for family, guests, or a home office. Outside, enjoy the newly landscaped backyard with a custom slate patio and mature trees, ideal for outdoor dining, entertaining, or simply relaxing. A lovely neighborhood park is located just a few homes away, adding to the appeal of this desirable North Fremont location. This move-in-ready home is in the top-ranked Niles Elementary School, Centerville Middle School and Washington High School attendance area. Close to parks, historic Niles, shops. Easy access to 880 and 84/Dumbarton Bridge for a convenient commute to Silicon Valley, Peninsula, and San Francisco.
Listing Courtesy of bridgeMLS / Listed By: Joe Schembri, Coldwell Banker Realty
$1,198,000 (USD)
Active

Newark Area Single Family Home

Active

6649 Mayhews Landing Rd Newark, CA 94560

1 Bed
2 Baths
1167 sqft
MLS# 41144705
Virtual Tour
Step into this one-of-a-kind, storybook-inspired 1-bedroom, 1.5-bath home that beautifully blends timeless character with thoughtful modern updates. Filled with warmth and personality, this charming residence features an inviting oversized family room surrounded by abundant updated windows that flood the space with natural light. Built-in cabinetry provides both style and function, showcasing a dedicated office nook, bookshelves, and ample storage. High-end features include crown molding, hardwood flooring, and built-in surround sound speakers. A standout feature is the impressive 960 sq. ft. detached garage/shop offering endless possibilities for hobbies, storage, workspace, or creative pursuits, with a flexible layout ideal for a workshop, home gym, studio, collector’s space, additional storage, or potential future conversion to separate living space or an ADU. The updated kitchen features beautiful concrete countertops, a breakfast bar with pendant lighting, vintage 1935 Wedgewood 4-burner gas stove in working condition, Fisher & Paykel double-drawer dishwasher, and built-in oven and microwave. The adjacent dining area provides a comfortable space for everyday meals with flexibility to expand for larger gatherings. The spacious bedroom offers cedar-lined built-in closets and French doors opening directly to the peaceful backyard, creating a seamless indoor-outdoor retreat. The versatile laundry room serves double duty as an entertaining space, easily converting to a bar with extensive cabinetry, wet bar sink, and backyard access. Outside, discover a private garden oasis featuring a built-in spa surrounded by mature shrubs. Beautifully landscaped grounds include 10 mature fruit trees, raised garden beds, lush greenery, and a garden shed for tools and outdoor storage. A huge composite deck provides exceptional outdoor living space with a natural gas fire table, gas hookup for your grill, and exterior half-bathroom, making it perfect for entertaining, relaxing, and enjoying the tranquil surroundings. A cobblestone paver driveway leads to a two-car carport featuring an automatic garage door, EV charging outlet, and additional raised planter beds. Additional highlights include owned 9.6 kW solar with valuable NEM 2.0 benefits, offering significant long-term energy savings. This truly special property offers an unmatched blend of vintage charm, modern conveniences, and exceptional outdoor living.
Listing Courtesy of bridgeMLS / Listed By: Brooke Crossland, Coldwell Banker Realty
$788,800 (USD)
Active

Warm Springs Area Condominium

Active

46776 Fernald St Fremont, CA 94539

3 Bed
2 Baths
1271 sqft
MLS# 41144223
Virtual Tour
Nestled in the highly sought-after Warm Springs neighborhood, this beautiful townhouse-style condo offers privacy, comfort, and picturesque surroundings. Featuring a north-facing entrance, an inviting private patio, and breathtaking views of Mission Peak and the surrounding hills, this home provides a peaceful setting in a prime location. Offering approximately 1,270 square feet of living space, the home features 3 bedrooms, 1.5 bathrooms, an attached 2-car garage with direct access to the home, and a functional two-story floor plan. Recent updates include updated kitchen and bathrooms, fresh interior paint and new flooring, making this home truly move-in ready. One of the home's standout features is its exceptional location—within walking distance to both James Leitch Elementary School and Warm Springs Elementary School, providing excellent convenience for families.Enjoy a low HOA of just $375 per month, which covers water, garbage, roof and exterior maintenance, common area landscaping, pest control, and fencing. In addition to the attached 2-car garage, the community also offers approximately 10 shared guest parking spaces, providing ample parking for visitors. Ideally located with convenient access to I-680, I-880, and Highway 237, this home is just minutes from shopping, restaurants, parks, and the Warm Springs/South Fremont BART station. Served by highly acclaimed schools: Warm Springs Elementary, Horner Junior High, and Irvington High School.
Listing Courtesy of bridgeMLS / Listed By: Aimee Ran Song, Coldwell Banker Realty
$1,249,900 (USD)
Active

Newark Area Townhome

Active

8540 Tailwind Ave Newark, CA 94560

4 Bed
4 Baths
2060 sqft
MLS# 41144024
Virtual Tour
Introducing a stunning end-unit townhouse tucked away in Newark’s desirable Bayshores community. Filled with natural light, this gorgeously updated home offers the perfect blend of contemporary style, comfort and functionality across three thoughtfully designed levels. The ground floor features an attached two-car garage, a bedroom and a beautifully remodeled full bathroom, offering excellent flexibility for guest accommodations or a separate retreat. The main level is designed for effortless everyday living and entertaining with high ceilings, abundant windows and spacious family and dining areas. At the heart of the home is a gorgeous gourmet kitchen featuring custom cabinetry and quartzite countertops, plus an expansive island with bar seating and stainless steel appliances, including a gas range. Step outside onto the private covered balcony overlooking the landscaped community greenbelt and playground, an inviting setting for morning coffee or simply unwinding at the end of the day. The upper level offers a luxurious primary suite and spacious secondary bedrooms, while every bathroom throughout the home has been tastefully remodeled. Additional highlights include central heat and air conditioning, engineered wood flooring, recessed lighting and dual-pane windows. Ideally situated near local parks and walking trails, multiple shopping centers and beloved local eateries, with convenient access to the Dumbarton Bridge, I-880 and Silicon Valley shuttle stops. Come experience the thoughtful design, exceptional upgrades and picturesque neighborhood setting that make this Bayshores home truly stand apart.
Listing Courtesy of bridgeMLS / Listed By: Lester Belliveau, Coldwell Banker Realty
$2,478,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
Virtual Tour
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. The house is also wired for solar. 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
$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