meta_query='key:subdist__c;value:North Waterfront|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212528' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15720
[post_author] => 4
[post_date] => 2018-11-02 19:54:37
[post_date_gmt] => 2018-11-02 19:54:37
[post_content] => Not quite Telegraph Hill. Definitely not North Beach. Home of Fisherman's Wharf (although locals don't discuss this, we just spend the tax revenue). It flies underneath the radar yet is walkable to downtown. Adjacent to all that an Embarcadero rebuilt after Loma Prieta now has to offer.
[post_title] => North Waterfront
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => north-waterfront
[to_ping] =>
[pinged] =>
[post_modified] => 2021-12-01 19:32:50
[post_modified_gmt] => 2021-12-02 03:32:50
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15720
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
_wp_page_template PropertyDetails.php
ListingId a0E1I000002wNBWUA2
pba__address_pb__c 152 Lombard #401, San Francisco, CA, 94111
pba__city_pb__c San Francisco
pba__fullbathrooms_pb__c 2
pba__bedrooms_pb__c 2
days_on_market__c 1468
mls_id__c 472929
pba__totalarea_pb__c 1112
pba__latitude_pb__c 37.804451
pba__longitude_pb__c -122.404175
pba__state_pb__c CA
pba__status__c Sold
pba__street_pb__c Lombard
listed_date__c 2018-05-10
sale_date__c 2018-06-20
pba__propertytype__c Condominium
pba__listingprice_pb__c 934000
pba__listingtype__c Sale
sale_price__c 934000
pba__lotsize_pb__c 0
address2__c 152 Lombard #401, San Francisco, CA, 94111
pba__listing_agent_firstname__c Par
pba__listing_agent_lastname__c Hanji
pba__floor__c 0
pba__halfbathrooms_pb__c 0
parkingspaces__c 1
pba__postalcode_pb__c 94111
year_build_text__c 0
size__c 1112
subdist__c North Waterfront
listing_agent_mls_id__c 804371
selling_agent_mls_id__c 810859
hoa_dues__c 1054.53
listing_co_office_mls_id__c PARA
listing_co_office_name__c Compass SF
listing_co_office_number__c 2865
listing_co_agent_mls_id__c 803877
listing_office_number__c 2865
listing_office_name__c Compass SF
listing_office_mls_id__c PARA
unit_number__c 401
district__c SF District 8
selling_agent_number__c 1048512
selling_co_agent_number__c 0
selling_co_office_number__c 0
overall_days_on_market__c 1468
dom__c 0
hoa_name__c Telegraph Landing North
laundry_appliances__c In Closet
monthly_parking_fees__c 0
listing_co_agent_number__c 166013230
price_per_square_foot__c 839.93
selling_office_name__c Vanguard Properties
parking_type__c Mapped On Site
transportation__c 1 Block
original_price__c 934000
agent_only_remarks__c Agents: bathrooms and kitchen were last updated about 10 years ago and place has carpet through-out. Square footage is from tax record.
pba__yearbuilt_pb__c 0
external_listing__c 1
pba__latitude_property__c 37.804451
listing_agent_number__c 166013908
on_market_date__c 2018-06-20
selling_agent_name__c Derek M. Jackson
master_property__c a0O1I000001yxU1UAI
website_property_type__c Condominium
ListingUpdateDate 2022-06-28T04:20:56