Featured Properties

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

Brookvale Area Single Family Home

Active

35939 Ashton Pl Fremont, CA 94536

3 Bed
2 Baths
1576 sqft
MLS# 41134027
OH 5/9 & 5/10 1-4pm*You’re going to love this one! This beautifully updated home offers style, comfort, and quality throughout, with numerous recent upgrades that truly set it apart. From the moment you arrive, the elegant front door with leaded and etched glass side panels creates a warm and inviting first impression. Inside, you’ll find gleaming, recently renovated and expanded hardwood flooring that flows seamlessly throughout the home. The fully remodeled kitchen is a standout feature, showcasing granite slab countertops, a full backsplash, updated cabinetry with soft-close drawers, newer appliances, and recessed lighting—ideal for both everyday living and entertaining. The spacious primary suite offers a relaxing retreat with a walk-in closet, vanity area, and a beautifully remodeled bathroom. Two dual-pane sliding glass doors open to a beautifully maintained backyard, complete with a sparkling swimming pool—one from the primary bedroom and another from the family room—enhancing indoor-outdoor living. Additional improvements include two tastefully remodeled bathrooms, six-panel interior doors with upgraded hardware, dual-pane windows, recessed lighting, a recently installed furnace, and fresh interior and exterior paint. The finished garage adds even more value with epoxy flooring and additional storage space. Located in the highly sought-after American High School attendance area (buyer to verify), this home combines location, upgrades, and overall appeal. A fantastic opportunity you won’t want to miss!
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Jerry Jacques
$1,299,880 (USD)
Active

Niles Area Townhome

Active

159 Quincy Ter Fremont, CA 94536

4 Bed
3 Baths
1690 sqft
MLS# 41134037
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 / Coldwell Banker Realty / Joe Schembri
$769,000 (USD)
Active

The Colony Area Single Family Home

Active

4231 Dubhe Ct Concord, CA 94521

4 Bed
3 Baths
1661 sqft
MLS# 41133535
OH 5/9 1-4pm*Showcasing true pride of ownership, this beautifully maintained home features luxurious upgrades throughout, creating a warm, inviting atmosphere with both comfort and privacy. Ideally tucked away in the heart of the development, it offers a serene and highly desirable setting. Step into the spacious living room with vaulted ceilings, a cozy gas fireplace, plantation shutters, and a custom stair railing—an impressive introduction to the home. The remodeled chef’s kitchen sits at the center of it all, thoughtfully designed with modern appliances, stone slab countertops, a decorative tile backsplash, soft-close cabinetry, recessed and pendant lighting, and a convenient island workstation—perfect for everyday living and entertaining. A highly desirable fourth bedroom on the main level provides excellent flexibility for guests, extended family, or a private home office. Upstairs, the primary suite features cathedral ceilings, a generous closet, and a beautifully remodeled en-suite bathroom, accessed through a charming barn-style door. Additional highlights include dual-pane windows, upgraded solid-core doors, central A/C, a whole house attic fan, closet organizers, updated bathrooms, modern lighting fixtures, and French doors from the kitchen leading to the inviting backyard. The backyard is equally impressive, offering paver walkways, ornamental shrubs, planter boxes, and a trellis-covered seating area—creating a private, park-like setting ideal for relaxing or entertaining. A truly special home that seamlessly blends comfort, style, and functionality. With so many upgrades throughout, this is a must-see opportunity!
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Jerry Jacques
$2,468,000 (USD)
Pending

Mission Lakes Area Single Family Home

Pending

35621 Beeching Ln Fremont, CA 94536

5 Bed
3 Baths
2675 sqft
MLS# 41132559
Virtual Tour
Presenting this beautifully appointed two-story home with lovely views of the hills in the sought-after Mission Lake community. This stunning residence offers 4 bedrooms, 1 bonus room/5th bedroom and 3 full bathrooms. A full bedroom and bathroom are conveniently located on the main level. The spacious open floor plan features a light-filled formal living room with vaulted ceilings. The generous family room with fireplace opens seamlessly to the remodeled kitchen and dining area, creating an ideal space for everyday living and entertaining. The custom remodeled kitchen offers granite countertops with full backsplash, abundant cabinetry, a center island, and top-of-the-line stainless steel appliances. The upper-level features 3 more large bedrooms, a bonus room with closet that can serve as a 5th bedroom, and 2 full bathrooms. Upstairs, the elegant primary suite with vaulted ceiling and walk-in closet includes a beautifully updated en-suite bathroom with dual-sink vanity, large soaking tub and a separate shower with clear glass enclosure. All bathrooms are beautifully updated. Additional highlights include refinished Brazilian Cherry hardwood flooring downstairs and upstairs hallway, quality carpeting in the bedrooms, new interior paint, updated windows with plantation shutters, beautiful double entry door with glass inserts, new LED lighting, tankless water heater, central vacuum system, and laundry room. Enjoy professionally landscaped front and backyards with paver decking, built-in BBQ, fire pit, and shade. Top-ranked schools include Brookvale Elementary School and American High School. Close to restaurants, shopping, Alameda Creek Trail, Quarry Lakes, BART, and easy access to 880 and 84. No HOA dues.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Joe Schembri
$1,788,000 (USD)
Active

Berryessa Area Single Family Home

Active

3051 Knights Bridge Rd San Jose, CA 95132

4 Bed
2 Baths
1598 sqft
MLS# 41129987
Virtual Tour
Welcome to this thoughtfully updated home nestled in the highly desirable Berryessa neighborhood, served by the top-ranked schools Majestic Way Elementary, Sierramont Middle, and Piedmont Hills High. Boasting approximately $181,000 in upgrades, this single-story 4-bedroom, 2-full-bathroom home offers a convenient floor plan featuring a formal living room and a separate family room with fireplace and sliding glass door to the backyard deck. The updated kitchen showcases custom wood cabinetry with granite counters and full decorative stone backsplash, updated stainless-steel appliances, and a generous breakfast nook. Elegant touches throughout include a beautiful entry door with decorative glass insert and sidelight, newly installed luxury flooring, fresh interior and exterior paint, newly remodeled bathrooms, new LED lighting, and sun tunnels in the living and family rooms. Modern comforts abound with updated Milgard dual-pane windows, a central heating and air conditioning system, updated furnace, and copper pipes. The professionally landscaped front yard features a cement aggregate walkway leading to the front door. The backyard offers a cement patio, a decorative pergola, and a deck creating a lovely setting for outdoor relaxation and entertaining. All this in a quiet, well-established neighborhood close to parks, shopping, and dining, and just minutes from the Light Rail, Milpitas BART station, and the Great Mall. Easy access to Highways 880 and 280/680 provides a smooth commute to Silicon Valley tech hubs and beyond.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Joe Schembri
$1,849,900 (USD)
Active

Glenmoor Gardens Area Single Family Home

Active

37933 Granville Dr Fremont, CA 94536

4 Bed
2 Baths
1890 sqft
MLS# 41132889
Virtual Tour
Located in the sought-after Glenmoor neighborhood, this beautiful home offers modern upgrades and the timeless charm you’ve been looking for. Step inside to find a customized single-level layout that flows seamlessly from room to room. You’ll find thoughtful updates throughout including hardwood flooring, recessed lighting, dual-pane windows, copper plumbing and crown molding. The gorgeous open-concept kitchen features elegant granite countertops, custom cabinetry, a center island and sleek black appliances including a gas stove and refrigerator. The expanded layout continues beyond the kitchen into a welcoming dining area and living space. Through charming barn doors, a spacious family room showcases vaulted ceilings and an abundance of natural light- ideal for gatherings or relaxed everyday living. The primary suite offers direct access to the backyard and an updated private bathroom with a stall shower and new vanity with cultured marble. The backyard retreat features a lush lawn, concrete patio, pergola, built-in firepit with gas line, two large sheds and a hot tub- perfect for relaxing or entertaining. Additional highlights include central A/C, owned solar panels and a beautifully remodeled hall bathroom with a marble-topped vanity and subway tile shower walls. Ideally located within walking distance to parks, shopping, local eateries and nearby schools. Glenmoor residents can enjoy access to community parks, pools, tennis courts, basketball court, playgrounds and seasonal activities. Perfect for commuters, with convenient access to 880, 680, Dumbarton Bridge, BART and Centerville Station. Don’t miss your chance to call this rare Glenmoor gem home!
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Lester Belliveau