Featured Properties

Some or all of the listings below are provided by the Fremont office.
$1,299,880 (USD)
Pending

Niles Area Townhome

Pending

159 Quincy Ter Fremont, CA 94536

4 Bed
3 Baths
1690 sqft
MLS# 41134037
Virtual Tour
Presenting this stunning never-lived-in Lennar property on a corner location, just one year new and featuring large picture windows. Nestled in the vibrant Niles neighborhood, this energy-efficient home offers 4 spacious bedrooms and 2.5 modern bathrooms. The open-concept floor plan features a seamless flow between the bright great room, dining area and kitchen. The custom kitchen with contemporary high-end finishes boasts abundant cabinetry, sleek quartz countertops with full backsplash, large center island with sink and breakfast bar, pantry, and high-quality appliances. Upstairs, the primary suite has a private balcony overlooking the green belt, and a generous walk-in closet. The en-suite bathroom features dual-sink vanity, step-in shower with clear glass enclosure, and separate soaking tub. The 3 additional bedrooms are also generously sized. Other highlights include luxury laminate flooring throughout the main living area on the first floor, quality carpeting upstairs, tile flooring in the bathrooms, LED recessed lighting throughout, dual-pane picture windows, and inside laundry room. Enjoy modern comfort with solar panels for heat and electricity, tankless water heater, EV charger, and battery storage. This move-in-ready home is in the attendance area of top-ranked Niles Elementary. The community offers private access to the Alameda Creek Trail, with miles of scenic walking and biking paths. Close to downtown historic Niles district, Niles Community Park with playground, tennis courts and picnic area, and Quarry Lake Regional Park. Close to 880, 84 and BART station for convenient commute.
Listing Courtesy of bridgeMLS / Listed By: Joe Schembri, Coldwell Banker Realty
$1,299,000 (USD)
Pending

Sunnyvale Area Townhome

Pending

377 S Bernardo Ave Sunnyvale, CA 94086

2 Bed
3 Baths
1653 sqft
MLS# 41130950
Virtual Tour
Rate buy down option available. Great school attendance area. This rarely available Tudor Manor end unit has been fully remodeled in 2026 and is priced to move in today's market. At just $250 per month in HOA fees, your monthly costs in a neighborhood where HOA fees routinely run $400–$600/month, this is a genuine financial advantage that adds up to thousands in annual savings. This two-story end unit delivers the privacy and natural light that interior units simply can't match. The fully redesigned interior features high ceilings, recessed lighting, and contemporary laminate flooring throughout — move-in ready. The open-concept main level flows from a spacious living room into a formal dining area, with a family room that opens directly to a private patio and backyard — your own outdoor retreat for morning coffee, al fresco dining, or a kitchen garden. Upstairs, a versatile nook serves as a dedicated home office — ideal for hybrid and remote workers. The primary suite is a true sanctuary, featuring a spa-inspired bathroom with an oversized walk-in shower, double vanity sinks, and a generous walk-in closet. The second en-suite bedroom offers its own private balcony — a rare touch that gives guests or family members their own outdoor space. Location is unbeatable: five minutes to Downtown Sunnyvale and six minutes to Downtown Mountain View, with easy access to Highways 85, 101, and 237. Walking distance to tech shuttles and minutes from Apple, Google, and LinkedIn campuses. Zoned to the highly regarded Homestead High School district. With a newly reduced price, a 2026 full remodel, and a $250/month HOA that is among the lowest in Sunnyvale, this is the rare combination of value, quality, and location that rarely comes available.
Listing Courtesy of bridgeMLS / Listed By: Moni Shah, Coldwell Banker Realty
$1,299,000 (USD)
Active

Centerville Area Single Family Home

Active

4747 Hansen Ave Fremont, CA 94536

3 Bed
3 Baths
2230 sqft
MLS# 41145543
PRICE TO SELL! EXPANDED AND EXTENSIVELY REMODELED IN 2008! Introducing this beautiful central Fremont property situated on a premium 10,000 sq ft lot with wonderful indoor and outdoor living. This spacious home offers 3 bedrooms, 3 full bathrooms with the primary bedroom and en-suite bathroom downstairs. The inviting front living and dining room offers Brazilian cherrywood hardwood flooring and a fireplace with beautiful custom mantel, while the separate family room features a second fireplace and a sliding glass door opening to the backyard patio. The beautiful custom kitchen boasts cherrywood cabinetry, granite countertops, quality GE Monogram appliances, gas cooktop, Zephyr exhaust hood, tile backsplash, recessed lighting, and breakfast nook. Unwind in the generous downstairs primary suite with direct access to the backyard and a custom bathroom with dual-sink vanity and tile shower. Upstairs, 2 spacious bedrooms provide comfortable and versatile living space and an updated bathroom with travertine flooring, bathtub, and skylight. Additional features include dual pane windows, custom crown molding and baseboards, raised-panel doors throughout, recessed lighting, forced-air heating, tankless water heater, ceiling fans two skylights upstairs, and an abundance of windows for natural light. Enjoy the expansive backyard with a large patio, sprawling lawn, mature fruit trees, flower garden, and a separate workshop, offering plenty of space for entertaining, gardening, playing, or build an ADU and/or a garage. This exceptional home close to shopping, restaurants, and everyday conveniences. Commuters will appreciate easy access to Highways 880 and 84, BART, Silicon Valley, and major employers throughout the Bay Area.
Listing Courtesy of bridgeMLS / Listed By: Joe Schembri, 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
$1,219,000 (USD)
Active

Sunnyvale Area Townhome

Active

115 Maidenhair Ter Sunnyvale, CA 94086

2 Bed
3 Baths
1313 sqft
MLS# 41144973
Virtual Tour
Well-maintained, move-in ready & built in 2017, this stylish 2 Bedroom 2.5 Bath Sunnyvale home offers 1,313 sqft of thoughtfully designed living space, with low HOA dues of just $385/month! Step inside & you’ll immediately appreciate the bright, open layout & beautiful engineered hardwood floors. At the heart of the home is a spacious kitchen made for gathering, featuring Espresso shaker cabinetry, sparkling quartz countertops, full-tile backsplash, stainless steel appliances, a gas range & oversized breakfast bar island—perfect for morning coffee, casual meals or entertaining friends. Step outside onto the covered balcony overlooking the quiet courtyard for a little fresh air & relaxation. Upstairs, both bedrooms feature their own private full baths, offering comfort & privacy for owners, guests or a roommate, with full-size side-by-side laundry unit conveniently located in between. Dual-zone heating & A/C, dual-pane windows/sliders, tankless water heater & Ring doorbell add everyday comfort & convenience. The attached 2-car garage features upgraded epoxy flooring, fully painted walls, additional side storage space & 220V Prewired for EV Charger, plus additional owner & guest parking opportunity in the community. Enjoy a beautiful courtyard, clubhouse, playground & dog park, while monthly HOA dues also cover trash, exterior maintenance, roof, insurance & landscaping. Just minutes from Downtown Sunnyvale & Caltrain, with Whole Foods, Target, AMC, Farmers Market & Historic Murphy Avenue close by, plus easy access to major tech employers & commute routes. Modern living, thoughtful upgrades, low HOA & a location that puts Silicon Valley at your fingertips—come see why this home stands out before it’s gone!
Listing Courtesy of bridgeMLS / Listed By: Sudie Hsu, 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