Featured Properties

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

San Jose Area Condominium

Contingent

1053 Dewberry Place 304 San Jose, CA 95131

4 Bed
3 Baths
2147 sqft
MLS# ML82041568
Rare find: a single-level condo with a private elevator in the award-winning Orchard Park community. Largest unit in the community, boasting an impressive 2,147 sq ft of living space. It features a private elevator, a secure and convenient accessideal for multi-generational living. As a desirable corner unit, it enjoys extra windows that fill the home with abundant natural light, along with a premium setting that offers open views and no directly facing neighbors. The open floor plan features a spacious, high-ceiling great room that flows seamlessly to a generous balcony for indoor-outdoor living.The gourmet kitchen is equipped with quartz countertops, a large island with sink, gas cooktop, range hood, dishwasher, and ample cabinetry. While the home is finished with a tasteful combination of tile and carpet flooring, Central HVAC system, Attached first-floor two car garage with storage area. The community offering exceptional convenience with supermarkets, restaurants, and Google shuttle stops all within walking distance. Three shopping centers are nearby, and San Jose Municipal Golf Course is right across the street. With easy access to Highways 880 and 101, Orchard Park truly offers the perfect blend of comfort, convenience lifestyle for residents of all ages.
Listed by MLSlistings Inc. / Coldwell Banker Realty / Xiaoxiao "Michelle" Lin
$2,488,000 (USD)
Active

Quail Run Area Single Family Home

Active

33646 Whimbrel Rd Fremont, CA 94555

4 Bed
3 Baths
2598 sqft
MLS# 41129714
Virtual Tour
Welcome to this beautiful Shapell home in the sought-after Quail Run Community! This prestigious neighborhood is known for its peaceful setting and resort-style amenities - a swimming pool, tennis courts, clubhouse, and playground. Located within top-rated school districts—American High School, Thornton Middle, Warwick Elementary. It offers 4 beds and 3 baths, including a convenient downstairs bedroom and full bath. With 2598 sq ft of living space, 8250 sq ft lot, sits on a quiet street. The thoughtfully designed floor plan features formal living and dining rooms at the front. Toward the back, the modern kitchen, breakfast nook, and family room flow seamlessly together, providing an ideal space for everyday living and entertaining, with access to the backyard. Upstairs, the spacious primary suite offers a retreat area with a cozy fireplace, soaring ceilings, and a private balcony. The luxurious primary bathroom includes dual vanities, dual closets, and a separate shower. Step outside to a generous backyard complete with a patio deck—perfect for entertaining, gardening, and enjoying fruit-bearing trees. Conveniently located near dining, shopping, local parks, BART, major freeways, and corporate shuttles, this home truly offers comfort, convenience, and an exceptional lifestyle.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Aimee Ran Song