meta_query='key:subdist__c;value:Telegraph Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='382890' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15718
[post_author] => 4
[post_date] => 2018-11-02 19:54:34
[post_date_gmt] => 2018-11-02 19:54:34
[post_content] => Tourists flock to WPA murals that grace a monument to firefighters while parrots flock to whatever neighborhood park feels nice. Looking for a front row seat to sunrises and sunsets on the San Francisco Bay from your own slice of the hill? You've arrived, so sit back and enjoy the show.
[post_title] => Telegraph Hill
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => telegraph-hill-2
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 14:22:20
[post_modified_gmt] => 2024-03-19 21:22:20
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15718
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
_yoast_indexnow_last_ping, 1722077875
ffd_listing_title, 33 Midway Street #304, San Francisco, CA, 94133
ffd_mls_id, 424032430
ffd_salesforce_id, a0EUd000001zyQ7MAI
num_of_fireplaces__c, 1
num_of_rooms__c, 4
of_units__c, 9
address2__c, 33 Midway Street #304, San Francisco, CA, 94133
pba__address_pb__c, 33 Midway Street #304, San Francisco, CA, 94133
agent_only_remarks__c, escrow with Chicago title- Pauline Thatch please. Show by appointment only.
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1980
pba__city_pb__c, San Francisco
listing_co_agent_name__c, David B Bellings
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-05-11T19:47:18.000+0000
days_on_market__c, 77
dom__c, 51
ffd_description_pb, Fabulous 2 bedroom top floor condo in sought after Telegraph Hill location. This light filled unit has water views of the bay from living room, perfectly located in a quiet small street walking distance to cafes, North Beach, Waterfront, landmarks and other conveniences. This home offers the convenience of assigned parking in garage, ensuring effortless city living, with an elevator for easy access. Stunning shared roof deck has expansive views of the city. Charming common backyard is fantastic for entertaining. This unit has it all!
district__c, SF District 8
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Other
hoa_fee_includes__c, Common Areas,Elevator
pba__hoafees__c, 724
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 33 Midway Street Home Owner Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2024-07-27T10:48:23.000+0000
pba__latitude_pb__c, 37.805628
pba__latitude_property__c, 37.805628
listed_date__c, 2024-05-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Lauren
pba__listing_agent_lastname__c, Lai Bellings
listing_agent_mls_id__c, 308732
ffd_listingagentname, Lauren Lai Bellings
listing_agent_number__c, 308732
listing_co_agent_mls_id__c, 215754
listing_co_agent_number__c, 215754
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 995000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.409574
mls_id__c, 424032430
master_bathroom_features__c, Tub w/Shower Over
master_property__c, a0O1I000004VXVKUA4
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-05-11
original_price__c, 995000
overall_days_on_market__c, -81945
parking_access__c, Independent
parking_features__c, Assigned,Covered,Enclosed,Garage Door Opener,Interior Access,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Roof Deck
pba__pendingdate__c, 2024-07-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-07-26T15:35:48.000+0000
price_per_square_foot__c, 1045.2
pba__propertytype__c, Condominium
ListingId, a0EUd000001zyQ7MAI
sale_date__c, 2024-07-22
sale_price__c, 925000
selling_agent_mls_id__c, 805814
selling_agent_number__c, 166015866
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Coldwell Banker Realty
pba__status__c, Closed
pba__totalarea_pb__c, 885
size__c, 885
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Midway
subdist__c, Telegraph Hill
ffd_name, 33 Midway Street #304, San Francisco, CA, 94133
view__c, Bay
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1980
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530776761-1.jpg