94123 Homes with Mixed Use Subtype

Welcome to the vibrant heart of San Francisco, where the zip code 94123 embodies the perfect blend of urban living and coastal charm. Nestled in the picturesque Marina District, this area offers stunning views of the Golden Gate Bridge and the serene waters of the Bay. Residents enjoy a lively atmosphere, complete with trendy boutiques, gourmet restaurants, and lush parks, all within walking distance.

The homes in this zip code feature a unique mixed-use subtype, allowing for an exciting lifestyle that combines residential comfort with commercial convenience. Imagine living in a beautifully designed apartment that is just steps away from your favorite café or boutique. This innovative approach to urban living not only enhances your daily experience but also creates a vibrant community where neighbors become friends.

The architecture in 94123 is a delightful mix of classic San Francisco charm and modern design, with many buildings showcasing stunning bay windows and inviting outdoor spaces. Whether you’re looking for a chic loft, a spacious townhouse, or a cozy condo, the diverse real estate options cater to a variety of lifestyles and preferences.

Outdoor enthusiasts will appreciate the proximity to the waterfront, where you can stroll along the Marina Green or enjoy a picnic at Crissy Field. With easy access to public transportation and major thoroughfares, commuting to other parts of the city is a breeze.

In 94123, you’re not just buying a home; you’re investing in a lifestyle filled with culture, community, and endless possibilities. Experience the best of San Francisco living in this dynamic and desirable neighborhood!

Newest 94123 Homes with Mixed Use Subtype

$2,450,000

WS26104871 MLS ⋅ Active Status

Wonderful investment opportunity to acquire the fee simple interest in a two-unit mixed-use commercial property in San Francisco, West of Van Ness Submarket. Nestled in the heart of San Francisco’s coveted Marina District, 3230-3232 Scott Street presents a rare mixed-use investment opportunity in one of the city's most affluent and high-demand neighborhoods. This two-unit storefront retail and residential property offers a strong tenant base, stable cash flow, and annual rent escalations, making it an attractive addition to any portfolio. • Highly Desirable Location: Situated in the Marina District, one of San Francisco’s most vibrant and walkable neighborhoods, known for its high-end retail, waterfront views, and strong residential demand. • Mixed-Use Composition: Two-unit property with ground-floor retail and residential/commercial office space above, catering to both commercial and residential tenants. • Stable Tenancy & Income: Fully leased with annual rental income of $156,600, plus built-in rent escalations. • Favorable Lease Terms: Leases extending into 2028 and 2026, providing long-term income stability. • Investment Potential: With an estimated NOI of $108,279, this asset offers a 4.42% cap rate with strong appreciation potential in a prime retail and residential corridor. • See OM in Supplements for more info

3230 Scott, San Francisco

$4,975,000

ML81985495 MLS ⋅ Active Status

Welcome to 3548 Pierce Street, an impeccably maintained and newly renovated multifamily building nestled in the heart of San Francisco. This property boasts six units, including two spacious 1-bedroom, 1-bathroom units and four luxurious 2-bedroom, 2-bathroom units, all freshly upgraded to condo-quality standards. In addition to the 6 units, the garage spaces have been cleared out and there is potential for an ADU. Each 2-bedroom unit offers a modern and stylish living space with premium finishes, perfect for discerning tenants. With all 2-bedroom units currently vacant, this property presents a unique opportunity for investors or those seeking multigenerational living in an unbeatable location. Recent updates include a brand-new heating system, a state-of the-art intercom system, and a completely renovated lobby that offers a warm welcome to residents and guests. Additionally, new water heaters have been installed, ensuring comfort and convenience throughout the building. Situated in a walker's paradise with a phenomenal 97 Walk Score, this property is mere steps from vibrant shopping, dining, and entertainment options. 3548 Pierce Street is a rare gem that combines pristine condition, contemporary upgrades, and an outstanding location.

3548 Pierce Street, San Francisco

Start Your Search

Based on information from California Regional Multiple Listing Service, Inc. as of . This information is for your personal, non-commercial use and may not be used for any purpose other than to identify prospective properties you may be interested in purchasing. Display of MLS data is usually deemed reliable but is NOT guaranteed accurate by the MLS. Buyers are responsible for verifying the accuracy of all information and should investigate the data themselves or retain appropriate professionals. Information from sources other than the Listing Agent may have been included in the MLS data. Unless otherwise specified in writing, Broker/Agent has not and will not verify any information obtained from other sources. The Broker/Agent providing the information contained herein may or may not have been the Listing and/or Selling Agent.