Featured Properties

$20,000,000
Active

Mountain View Area Multi-Family Home

Active

2483-2491 Whitney Drive Mountain View, CA 94043

40 Bed
0 Baths
37904 sqft
MLS# 425045432
The Mayfield Apartments located at 2483-2491 Whitney Dr. in Mountain View, CA is a superb opportunity for the savvy multifamily investor. The approximately 1.446 acre property is comprised of 4 parcels boasting 2 one story buildings and 2 two story buildings built in 1959/60. The buildings contain 40 apartments with a unit mix of 6 two bedroom units, 28 one bedroom units, and 6 studio units. Many of the units have private back patios or little front gardens, lovely vaulted wood ceilings, and luxury vinyl plank flooring. The units have been updated to varying extents, but most have upgraded bathrooms and kitchens. The units are separately metered and equipped with electric stoves, gas wall heaters, and individual fuse boxes. The property boasts a communal pool, 52 parking spaces, including 40 carport spaces and 12 uncovered spaces, ample storage, and 3 laundry rooms with Seller owned app operated machines (4 washers/4 dryers). Located directly adjacent to over 500,000 square feet of Google office and R&D space, the property benefits from proximity to major employers and strong rental demand. Overall, the property presents a rare opportunity to acquire a residential investment asset in a severely supply constrained market with incredible development potential.
Listing Courtesy of San Francisco Association Of Realtors / Coldwell Banker Realty / Dan McGue
$11,000,000
Active

San Mateo Area Detached Single Family

Active

830 Bromfield Road San Mateo, CA 94402

4 Bed
6 Baths
6079 sqft
MLS# ML82009113
Virtual Tour
Magnificent estate represents the epitome of luxury. Flexible spaces both inside and out make this an intimate home for relaxation and entertaining. Sought-after street in San Mateo Park. Nestled among oaks and redwoods creating an oasis of serenity. Ground-up build, concrete podium construction, completed in 2023. Unrivaled quality. Meticulous details. Step inside and experience the sheer scale and grandeur. Soothing palette of colors flowing harmoniously. Two double ovens. Two dishwashers. 36-inch refrigerator and 36-inch freezer. Two six-foot wine coolers. A pristine quartz slab adorns the 15-foot island. Wake up to the sunrise in the dreamy primary suite, with a seating area and a truly unbelievable walk-in closet. Sensuous bathroom is the perfect place to indulge in a pampering journey. Pool. Cabana. Shaded pergola. Over 1,000 square foot limestone patio with a fireplace. Outdoor living is further enriched with the outdoor kitchen, BBQ and a 12-foot raised bar. A bench perfect for quiet reflection that captures unforgettable sunsets over the spa, all to nourish the body, mind, and spirit. Magical garden. Gym. Wine tasting room. Wine cellar framed with a stone entrance. Expansive cocktail bar. Billiards room. A very rare offering in one of the area's most desirable enclaves!
Listing Courtesy of MLSlistings Inc. / Coldwell Banker Realty / Margaret Duffy
$2,998,000
Active

Canyon Heights Area Single Family Home

Active

190 Pickering Ave Fremont, CA 94536

6 Bed
7 Baths
5608 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. 5600 sq ft boasts 5 or 6 bedrooms, 6.5 bathrooms plus a 2 bedroom 1 bathroom ADU (not included in the square footage). 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