BMIE BluFoodies Market Intelligence Engine

← Listings · Market 94133

Red Window Open

500 Columbus Ave, San Francisco, CA 94133

Listing

BMIE id5961F3A148BB4184
CategoriesBar (primary)
CuisinesSpanish / tapas (primary)
Brand / chainIndependent or not stated
Phone+14157570600
Websitetheredwindow.com
Coordinates37.799805, -122.409294 (source)
Last verified2026-09-05 11:55:45 by Overture Maps Places
Record versions kept1

As published by the source

AttributeValueSource
Category as published by the sourcetapas_barOverture Maps Places · 2026-09-05
Category hierarchy as publishedfood_and_drink>casual_eatery>tapas_barOverture Maps Places · 2026-09-05
Source confidence0.9722Overture Maps Places · 2026-09-05
Operating status (source)openOverture Maps Places · 2026-09-05

Map

Location as published by Overture Maps Places. Basemap © OpenStreetMap contributors.

Its market: 94133

CountySan Francisco County, California
Population (ACS)23,804
Median household income$87,191
Restaurants (Census count) / listings on file200 / —
BMIE Market Score49

Nearest listings (within 1 mile)

NameAddressDistance
The Oak Room Restaurant335 Powell St0.84 mi
Clock Bar335 Powell St0.84 mi
Chateau Montelena335 Powell St0.84 mi
Owl Tree601 Post St0.85 mi
Joy's Place611 Post St0.85 mi
French Club414 Mason St0.85 mi
ENO Wine Bar320 Geary St0.85 mi
Anju550 Taylor St0.85 mi
ZZAN Korean Restaurant643 Post St0.86 mi
Kyu Sushi & Robata639 Post St0.86 mi
Benjamin Cooper398 Geary St0.86 mi
Rove Kitchen678 Post St0.86 mi
L'Costa398 Geary St0.87 mi
Ayala398 Geary St0.87 mi
Christophe Restaurant405 Mason St # 17050.87 mi

History

No lifecycle events recorded yet. Openings, closures and changes are appended as sources report them.

Where this listing comes from

SourceRecordMatched byFirst seenLast seenLicence
Overture Maps Places2aa77ff6-4f57-4f35-855c-32c579e38da6source_id 100%2026-09-052026-09-05CDLA-Permissive-2.0