• Instagram
Phone310-963-9826
Login or sign up for new accountLogin / Register
Email MeEmail Me
  • Search Listings
    • Residential
    • Lease
  • Previous Sales
  •   Buyers
    • Renting vs. buying
    • How much can I afford?
    • Why work with a real estate agent
    • Finding your home
    • What do you want in a home?
    • Submitting an offer
    • After the offer is accepted
    • Moving
  •     Sellers
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Transaction management
    • Moving
  •     Services
    • Onepoint
    • Home Financing
    • Insurance
    • Escrow
    • Title
    • Home Warranty
    • PRESALE/STAGING
    • Relocation
  •     About
    • Leadership Team
    • About Us
    • Globally Respected
    • The Charitable Foundation
    • Diversity & Inclusion
    • Doyle
    • Agents Only
Menu
Berkshire Hathaway HomeServices California Properties Berkshire Hathaway HomeServices California Properties
Any Price
-
  • 0
  • $100,000+
  • $250,000+
  • $500,000+
  • $750,000+
  • $1,000,000+
0+ Beds
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
0+ Baths
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
Property Type
Other
VIRTUAL TOUR
  • Home
  • 515 Ofarrell St

515 Ofarrell St, San Francisco, CA 94102

$7,000,000 Approx. USD 0 beds, 0 baths

Save My Notes
Share
  • Copy Link
  • Facebook
  • Twitter
  • Pinterest
Source MLS Verified
MORE INFO
BrochureBrochure

Photo of Melissa Ellis

Melissa Ellis Manager 310-963-9826 m
310-829-0629 o
Lic#: 01905986
NRDS ID: 175524822
MelissaEllis@bhhscal.com
Text Me
Call My Cell
Call My Office
Lic#: 01905986
NRDS ID: 175524822
MelissaEllis@bhhscal.com
Santa Monica Office
3130 Wilshire Blvd, Suite 100
Santa Monica, CA 90403
Phone: 310-829-0629
Fax: 310-829-7541
Santa Monica 3130 Wilshire Blvd, Suite 100
Santa Monica, CA 90403
Call Branch Office
Fax: 310-829-7541
Mortgage Calculator
GET PRE-APPROVED
Interested in This Property? Your message will be sent to Melissa.
By submitting your information, you consent to be contacted by email, SMS message, and/or phone call. You may opt out at any time per our Privacy Policy.
  • Save
  • My Notes

Listing Agent


Aida Molina-Polle | aida.polle@theagencyre.com
Lic#: 01423725
Broker: Courtesy of The Agency
Phone: 510-871-0177

Co Listing Agent


Hector Rosas | hector@hhrosas.com
Lic#: 01846925
Broker: Courtesy of NOVO
Phone: 650-274-3213

Agent Remarks

Significant Price Reduction! First time on the market in 49 years, this 46-unit mixed-use flagship trophy asset offers an outstanding investment opportunity in San Francisco's core corridor. Delivering an 8.37% actual in-place cap rate, the property is offered at approximately $152,174 per unit and $270 per square foot, well below estimated replacement cost. The 100% occupied asset consists of 45 studio apartments, one ground-floor commercial space, and seven garage spaces. The high-rise fire sprinkler upgrade is approximately 90% complete, with the balance to be completed prior to close of escrow. Additional value includes approximately $190,000 in annual rental upside, $46,947 in documented banked rent increases, Fannie Mae and Freddie Mac approved, no mandatory soft-story retrofit, located within a Federal New Markets Tax Credit (NMTC) Census Tract. Ideally situated near Union Square, Powell BART/MUNI, and major hotels. Offering Memorandum available upon request.

Listing Details

Property type: (Multi-Family)
Status: Active
MLS# 41128295
List price is $7,000,000 Reduced by $3,500,000 on 8/3/2026
Price: $7,000,000
HOA Fee is $0.00
Beds: 0
Baths: 0
Built in 1926
0.10 acres
Lot size: 0.1041
Subdivision: CIVIC CENTER
County: San Francisco
Zoning: RC4
Construction: Concrete
Heating/cooling: None
Heating description: Wall Furnace

Last Updated: 8/10/2026

 Days On Market (DOM): 141

 Find more San Francisco homes and real estate

 Find more homes in 94102 zip code

 Find more homes in the CIVIC CENTER subdivision

Lat/Long: 37.785507, -122.413306.
Find nearby listings

DISCLAIMER: There is NO WARRANTY, expressed or implied, for the accuracy of this information or its applicability to your financial situation. Please consult your financial and/or tax advisor. GET PRE-APPROVED The loan's interest rate will depend upon the specific characteristics of the loan transaction and credit profile up to the time of closing.

94102 Area Map

Demographics

Schools

CLICK TO VIEW MAP

Similar Listings

Next Listing
303 Lee St VIRTUAL TOUR
303 Lee St ,
$6,995,000 Approx. USD

List Date: 3/11/2026
Status: Active
MLS #: 41126787

My Notes Save
Listing courtesy of
5499 Claremont Ave VIRTUAL TOUR
5499 Claremont Ave ,
$7,152,000 Approx. USD

List Date: 3/13/2026
Status: Active
MLS #: 41127059

My Notes Save
Listing courtesy of
1739 Spruce Street VIRTUAL TOUR
1739 Spruce Street ,
$6,500,000 Approx. USD

List Date: 7/20/2026
Status: Pending
MLS #: 41142220

My Notes Save
Listing courtesy of
2501 Rose Walk VIRTUAL TOUR
2501 Rose Walk ,
$5,995,000 Approx. USD

List Date: 3/2/2026
Status: Active
MLS #: 41120200

My Notes Save
Listing courtesy of
1183 Saranap Ave VIRTUAL TOUR
1183 Saranap Ave ,
$7,995,000 Approx. USD

List Date: 7/16/2026
Status: Pending
MLS #: 41141927

My Notes Save
Listing courtesy of
585 Old Canyon Rd VIRTUAL TOUR
585 Old Canyon Rd ,
$5,995,000 Approx. USD

List Date: 5/24/2026
Status: Active
MLS #: 41135884

My Notes Save
Listing courtesy of
1703 East Cliff Drive VIRTUAL TOUR
1703 East Cliff Drive ,
$6,999,000 Approx. USD

List Date: 5/7/2026
Status: Active
MLS #: ML82046156

My Notes Save
Listing courtesy of
1600 Santa Barbara Street VIRTUAL TOUR
1600 Santa Barbara Street ,
$6,750,000 Approx. USD

List Date: 10/30/2025
Status: Active
MLS #: 25-3995

My Notes Save
Listing courtesy of
1018 Garden Street VIRTUAL TOUR
1018 Garden Street ,
$7,600,000 Approx. USD

List Date: 5/13/2026
Status: Active
MLS #: 26-1585

My Notes Save
Listing courtesy of
1107-1111 E Cota St VIRTUAL TOUR
1107-1111 E Cota St ,
$6,500,000 Approx. USD

List Date: 4/14/2026
Status: Active
MLS #: 26-1193

My Notes Save
Listing courtesy of
Previous Listing
  • Search
    • My Previous Sales
    • Residential
    • Lease
    • Open Houses
    • Commercial
    • New Homes
    • Luxury
  • Buyers
    • Renting vs. buying
    • How much can I afford?
    • Why work with a real estate agent
    • Finding your home
    • What do you want in a home?
    • Submitting an offer
    • After the offer is accepted
    • Moving
  • Sellers
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Transaction management
    • Moving
  • Services
    • Prosperity Home Mortgage
    • HomeServices Relocation
    • HomeServices Insurance Agency
    • Pickford Escrow
    • California Title Company
    • American Home Shield
    • PINNACLE
    • myNHD
  • About
    • Leadership Team
    • About Us
    • Globally Respected
    • The Charitable Foundation
    • Diversity & Inclusion
    • Doyle
    • Agents Only

Photo of Melissa Ellis

Melissa Ellis Manager 310-963-9826 m
310-829-0629 o
Lic#: 01905986
NRDS ID: 175524822
MelissaEllis@bhhscal.com
Text Me
Call My Cell
Call My Office
Lic#: 01905986
NRDS ID: 175524822
MelissaEllis@bhhscal.com

Santa Monica Office
3130 Wilshire Blvd, Suite 100
Santa Monica, CA 90403
hsoa-logo
  • Instagram

© 2026 BHH Affiliates, LLC. An independently operated subsidiary of HomeServices of America, Inc., a Berkshire Hathaway affiliate, and a franchisee of BHH Affiliates, LLC. Berkshire Hathaway HomeServices and the Berkshire Hathaway HomeServices symbol are registered service marks of Columbia Insurance Company, a Berkshire Hathaway affiliate. Equal Housing Opportunity.
Lic#: 01317331

Photo of Equal Housing Opportunity Privacy Policy - California Privacy Notice - Terms of Use - Accessibility
Do Not Sell My Personal Information DMCA.com Protection Status