Featured Properties

Some or all of the listings below are provided by the Fremont office.
$2,998,000
Pending

Canyon Heights Area Single Family Home

Pending

190 Pickering Ave Fremont, CA 94536

6 Bed
7 Baths
5281 sqft
MLS# 41098613
Virtual Tour
Stunning residence built in 2006 with hundreds of thousands of dollars of custom upgrades! Tucked away in a quiet court with private access, in a peaceful Millwood neighborhood with gorgeous hill views. This magnificent home of approx. 5,281 sq ft boasts 5 or 6 bedrooms, 6.5 bathrooms plus a 2 bedroom 1 bathroom guest house (not included in the sq ft). A beautiful marble flooring entryway opens to the formal living and dining rooms. The gourmet kitchen includes commercial grade Jenair gas stove, double oven, microwave and a double drawer dishwasher, maple wood cabinetry and beautiful custom island. One bedroom and 1 full bathroom conveniently located downstairs. Upstairs, there are 4 bedrooms with 4 elegant bathrooms. Also upstairs, a spacious library and a separate media room or a 6th bedroom. Other fine features include exquisite marble flooring throughout downstairs, marble finishes in all bathrooms, custom crown molding and baseboards, recessed light throughout, elegant dual staircase with Brazilian cherrywood flooring and custom wrought iron railing, dual zone HVAC system and 4-car garage offers 3 EV charger connections. Solar is owned. Conveniently located near BART station, 84/Dumbarton Bridge & 880 (via Niles Canyon) for easy commute to San Francisco and Silicon Valley.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Joe Schembri
$2,238,000
Active

Mission San Jose Area Single Family Home

Active

43148 Calle Sagrada Fremont, CA 94539

4 Bed
3 Baths
2381 sqft
MLS# 41093061
Virtual Tour
Hard to find two-story home with partial hill views in The Abbey at Palmdale Estates community, an esteemed neighborhood with private access to a lush and serene 4.5-acre park, and a children's play area! Located in top-performing Mission San Jose schools! Only 5 years new with over $100K in upgrades. Offering 4 bedrooms, 3 full bathrooms of luxury living. 1 bedroom & 1 full bathroom downstairs. Formal dining area & great room. Gourmet kitchen with custom shaker cabinets, pull-out shelves, soft-close drawers, high-end Viking stainless steel appliances, quartz slab countertops & spacious pantry. Upstairs: 3 bedrooms & a loft/media room. Master suite with high ceilings, walk-in closet with built-in organizer. Spectacular master bathroom with Kohler dual sink vanity, marble flooring, large standing shower with mosaic tile floor & high-end clear glass shower, door and a separate tub. Upstairs hall bathroom has Kohler dual sink vanity, travertine flooring & stainless-steel water fixtures. Laundry room with sink, cabinetry, travertine flooring, built-in quartz counters and newer washer & dryer. Other features include custom oak wood flooring throughout, solid core wood doors, and custom Hunter Douglas blinds thought. Fully finished 2 car garage with epoxy flooring and custom closets.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Joe Schembri
$1,888,888
Active

Palomares Canyon Area Single Family Home

Active

30063 Palomares Rd Castro Valley, CA 94552

5 Bed
4 Baths
2600 sqft
MLS# 41074815
Virtual Tour
Peaceful Country Living Estate W/Hillside Views! Nestled in the Castro Valley hills is this wonderful move-in ready 4 bedroom, 3 bath home, approximately 2200 SQFT, on a large 2.72 acre lot with beautiful hillside views and a 400+ sqft ADU. Country living but conveniently located just minutes to downtown dining, shopping, and freeway! Enjoy the comfort of the large family room which offers wall of glass views overlooking the 2024 deck & the spacious living room w/formal dining area. Many wonderful upgrades & features includes a gallery, interior laundry, central heating/air, freshly painted, abundance of natural lighting, metal tile fire resistant roof, & beautifully refinished hardwood floors. The large rear of the home offers additional parking (former tennis court), an 8x8 backyard studio, & animal stable. 1180 SQFT detached structure includes 2 car garage, storage/tool room, & feed room. ADU offers a 1 bed studio w/loft, private kitchen & 1 bathroom. Additional features of the property includes a covered patio, picnic area, a fire pit, 60 Foot private well; and mature fruit trees. Located at the 3-mile marker, this home offers an easy commute to 580 Freeway, downtown Castro Valley, Pleasanton, & Fremont. Minutes to local schools, dining, and shopping. Open House Sat 6/14 1-4p
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Jacqueline Roberts
$1,699,900
Active

Glenmoor Area Single Family Home

Active

38411 Dennis Ct Fremont, CA 94536

3 Bed
2 Baths
1344 sqft
MLS# 41096765
Virtual Tour
Tucked away on a cul-de-sac in the desirable Glenmoor area sits a gorgeous single-story home! Designed to entertain, the customized floor plan has light and bright living spaces with quality upgrades around every corner. This layout includes a picturesque living room, open-concept kitchen, large dining room and spacious bedrooms. Beautifully remodeled kitchen has elegant quartz counters, shaker-style cabinetry, stainless steel Kitchen-Aid appliances and an expansive island with storage & bar seating. Enticing features include updated bathrooms, copper plumbing, quality flooring throughout, recessed lighting, dual pane windows, updated electrical wiring, new roof & much more! Primary suite includes a private bathroom and ample closet space. It’s easy to imagine hosting friends on the patio shaded by a pergola, playing on the lush lawn on warm days and relaxing in the hot tub on chilly nights. The rare lot also includes generous side yards, offering additional space for garden beds, play area - even a potential expansion or a future ADU (Accessory Dwelling Unit). Perfect for commuters, nearby 880, Dumbarton Bridge, BART & Centerville Train Station. Walking distance to great schools, shopping centers & beloved local eateries! You’re sure to love all this stunning home has to offer!
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Lester Belliveau