My Company's Active Listings

$2,299,900 (USD)
Active

Mission Area Multi-Family Home

Active

43677 Ellsworth St Fremont, CA 94539

Bed
0 Baths
3746 sqft
MLS# 41146445
Virtual Tour
Rare opportunity to own a fourplex in Fremont’s highly sought-after Mission San Jose neighborhood, one of the Bay Area’s most desirable communities known for its top-rated schools, strong rental demand and exceptional long-term investment potential. Situated on a 7,500± SF lot, this approximately 3,746± SF multifamily property consists of four spacious 2-bedroom, 1.5-bath units with functional two-story floor plans. Each residence features a comfortable living area, kitchen, half bath, and convenient in-unit laundry on the main level, with two bedrooms and a full bath upstairs. Units 1 and 2 showcase tasteful updates including durable laminate flooring, remodeled kitchens with custom shaker-style cabinetry, subway tile backsplash, stainless steel appliances, updated bathrooms and fresh interior paint in Unit 1. The property also offers four covered carport parking spaces plus additional uncovered parking spaces, providing ample off-street parking for residents. Perfectly positioned near award-winning Mission San Jose schools, Ohlone College, Mission Peak Regional Preserve, shopping, dining and everyday conveniences, this location also provides easy access to BART, I-680, I-880, and major Silicon Valley employers. Whether you’re looking to expand your investment portfolio or secure a well-located multifamily asset in one of Fremont’s premier neighborhoods, this is an exceptional opportunity with lasting upside.
Listing Courtesy of bridgeMLS / Listed By: Lester Belliveau, Coldwell Banker Realty
$2,299,000 (USD)
Active

Rescue Area Single Family Home

Active

5110 Broken Bow Lane Rescue, CA 95672

4 Bed
3 Baths
2905 sqft
MLS# 226133926
Virtual Tour
Whether you're looking for multi-generational living, expanding your farm, or simply added privacy this country estate offers endless opportunities and BREATHTAKING VIEWS! Offered as two adjoining parcels totaling 9.99 acres with one functioning Well AND another drilled Well on the separate parcel. Discover an extraordinary country lifestyle perched atop a hill at the end of a private gated road. This stunning custom single-story home captures stunning sunsets, sweeping views of Folsom Lake, downtown Sacramento, and the coastal mountains. A remarkable blend of luxury, comfort, and country living; this exceptional property offers a peaceful retreat while also having convenient access to shopping, dining and town within minutes. Designed for effortless indoor/outdoor living, the home features a luxurious backyard oasis with a large saltwater pool featuring built-in seating, Cabo shelf, multiple umbrella openings and a concrete bar top; complemented by a 12-person spa. An expansive California room with Milgard pocket glass doors and a power screen seamlessly extends the living space, creating an ideal setting for year-round entertaining. Additional outdoor amenities include an in-ground trampoline, outdoor shower, master shower gray water irrigation system and much more. The oversized, fully insulated four-car garage with a drive-through rear garage door provides exceptional space for vehicles, recreational toys and storage. Beyond solar and central HVAC, a wood-burning furnace in the garage provides an additional source of heat throughout the entire home. Thoughtful features include a dual shower head walk-in master shower, gas fireplace, whole-house fan, hot water recirculating system, wide hallways, and emergency generator connection. Designed with fire-conscious features, the home showcases low-maintenance rock, cement board siding, a stone tile roof, a whole-house interior sprinkler system and a private drafting fire hydrant. Embrace the hobby-farm lifestyle with approximately one acre of 6-foot animal fenced land, a small barn, and a spacious deer-fenced garden. A truly special property offering the perfect balance of seclusion, recreation and convenience. Come tour your dream home.
Listing Courtesy of Metrolist / Listed By: Patricia Seide, Coldwell Banker Realty
$2,295,000 (USD)
Active

San Francisco Area Multi-Family Home

Active

247-249 29th Street San Francisco, CA 94131

4 Bed
2 Baths
2268 sqft
MLS# 426175215
Fantastic mid-block location between Dolores and Church close to Noe Valley Recreation Center (volleyball, gym, tennis, baseball field and dog walk) and the Gothic St. Paul's historic church. This charming, fully vacant Mid-Century duplex offers two spacious flats with similar, well-designed floor plans. Each features two bedrooms, one bathroom, a generous living room with traditional fireplace, and a sizeable kitchen with adjoining dining area. Wonderful features include elegant crown moldings, beautifully refinished parquet floors, wood burning fireplaces and extra large lot. The ground level features a spacious two-car side-by-side garage and a sunny paneled room and full bath on the garden level offering work space or as a private retreat. A beautifully landscaped backyard with lush greenery and inviting seating areas provides a peaceful urban sanctuary, enhanced by picturesque views of the iconic twin spires of St. Paul's Church. Freshly painted inside and out, this distinctive property blends classic San Francisco charm with modern-day convenience. Just moments from Noe Valley's popular cafs, boutique shops, restaurants, and Mission Dolores Park. Conveniently located near Muni, Silicon Valley commuter bus stops at 29th and Mission, and the J-Church rambles through the Noe Village offering access to downtown under 20 minutes. A wonderful opportunity for owner-occupiers, multi-generational living, or investors to enjoy the distinctive charm and vibrant lifestyle of Noe Valley.
Listing Courtesy of San Francisco Association Of Realtors / Listed By: Edmund Leung, Coldwell Banker Realty