Featured Properties

Some or all of the listings below are provided by the Fremont office.
$1,999,000
Active

Union City Area Single Family Home

Active

4336 Pickerel Dr Union City, CA 94587

5 Bed
3 Baths
2298 sqft
MLS# 41066743
Virtual Tour
Welcome to highly desired Neighborhood*Award winning Union City Schools*Playgrounds and Parks nearby for kids to enjoy*Walking rail*Union Landing for shopping*Five Bedrooms*Three full baths*Two car garage*Front, back and side yard*Modern, Executive stunning home with custom features throughout the house*Newly painted exterior and interior*Welcoming living room with soaring ceiling, recessed lighting, mirrors and wood flooring*Fully renovated, custom kitchen with amazing stylish granite counter and backslash and high end appliances*Gas Stove*Refrigerator*Center island*Pantry and lots of cabinets for storage in Kitchen*75 smart TV and Bose surround sound (5.1 Dolby) system in the family room is a bonus*All three bathrooms have been recently renovated with custom vanities and toilets*Two separate fiber optic internet lines* Recessed lighting throughout the house* AC with Nest control* Plantation shutters throughout the house*Garage with custom built cabinets*Manicured front and backyard with tall trees*Come, enjoy and relax and make this home your before it's too! The house is conveniently located with easy access to Dumbarton & San Mateo bridges, 880 and 84 freeways It is also only a few minutes away from Meta, Tesla, Amazon, Stanford Healthcare and more! OH 7//27 & 7/28 2 to 4 pm
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Charo Bhatt
$1,888,000
Pending

Millwood Area Single Family Home

Pending

39005 Zacate Ave Fremont, CA 94539

4 Bed
2 Baths
1937 sqft
MLS# 41062558
Virtual Tour
Beautifully updated single-story Millwood home in a charming location. This property offers 4 bedrooms, 2 full baths & a modern floorplan w/vaulted ceilings. The custom entry door w/stained glass insert leads to the formal front living room. Beautifully refinished hardwood flooring covers the rest of the living space including the formal dining room w/a custom built-in bar & the spacious family room w/gas fireplace. Custom gourmet kitchen w/solid wood cabinetry, Corian counters w/custom edging, recessed ceiling w/recessed lighting, large window over sink & top-quality stainless-steel appliances. Expanded remodeled hall bathroom w/large double shower heads w/custom travertine shower floors&walls, jacuzzi tub & custom vanity w/granite counter. Other features include newly painted interior, elegant pocket French doors w/beveled glass, high-end French windows w/custom wood casings, new LED lights throughout, quality crown molding & high baseboard, new attic insulation, new carpeting in bedrooms & living room, newer presidential composition roof. Beautifully landscaped yards w/custom brick front walkways, covered front porch, custom backyard patio w/red brick inlays & arbor, gunite pool w/solar heating & 2 waterfalls, planters, fruit trees. Easy access to 680, 880, & Silicon Valley.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Joe Schembri
$1,625,000
Pending

Orchards Area Single Family Home

Pending

720 Ridgeview Ter Fremont, CA 94536

3 Bed
3 Baths
1638 sqft
MLS# 41060575
Virtual Tour
This sophisticated Single-Family home is in the upscale ORCHARDS community. Over 150K premium upgrades including front-backyard landscaping. This spacious 3 beds, 2.5 baths, 1638 sqft, two-story home has vaulted ceilings at the entry with a bridge connecting the bedrooms and recessed lights throughout; Newly painted interior; Upgraded kitchen with powerful hood, granite counter-tops and filtration system, and expanded cabinets; Durable hardwood floors throughout; Double pane windows; Air conditioning; Newer composition roof; Upgraded baths upstairs and downstairs; The expansive master bedroom has high ceilings and two walk-in closets with organizers, double sinks in master bath, tile floors; The hall bath has a tile shower over the tub, tile floors, and extended vanity. High-end custom-designed closets are installed in all the bedrooms. The garage has a high-end insulated roll-up garage door with an opener, epoxy on floors, lots of shelving. The washer and dryer stay as does the refrigerator. Solar-powered attic fan. Paver in back yard with patio cover, 2 orange trees, one lemon, 9 rose bushes and sprinkler system. The front yard has a palm tree, ground cover, rock cover, Paver, sprinkler system, and low-voltage walkway lights. HOA $90/month includes 2 community pools and Spas.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Aimee Ran Song