meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212217' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15714
[post_author] => 4
[post_date] => 2018-11-02 19:54:27
[post_date_gmt] => 2018-11-02 19:54:27
[post_content] => Meet Potrero Hill, where you can check out but you can never really leave. Sunny weather, jaw-dropping views of the downtown skyline and San Francisco Bay. Friendly, charming, and filled with more than you'd expect, it's a hill unto itself.
[post_title] => Potrero Hill
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => potrero-hill
[to_ping] =>
[pinged] =>
[post_modified] => 2021-12-01 19:32:08
[post_modified_gmt] => 2021-12-02 03:32:08
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15714
[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 a0E1I000001JaHYUA0
pba__address_pb__c 871 Rhode Island 873 Street, San Francisco, CA, 94107
pba__city_pb__c San Francisco
days_on_market__c 1705
mls_id__c 463590
pba__totalarea_pb__c 2160
pba__latitude_pb__c 37.758770
pba__longitude_pb__c -122.401779
pba__state_pb__c CA
pba__status__c Sold
pba__street_pb__c Rhode Island
listed_date__c 2017-10-26
sale_date__c 2017-12-06
pba__propertytype__c 2 Unit
pba__listingprice_pb__c 1795000
pba__listingtype__c Sale
sale_price__c 1800000
pba__lotsize_pb__c 0.06
address2__c 871 Rhode Island 873 Street, San Francisco, CA, 94107
pba__listing_agent_firstname__c David
pba__listing_agent_lastname__c Ayerdi
parkingspaces__c 1
pba__postalcode_pb__c 94107
year_build_text__c 1911
size__c 2160
subdist__c Potrero Hill
listing_agent_mls_id__c 809742
selling_agent_mls_id__c 810859
listing_co_office_mls_id__c MCGU
listing_co_office_name__c McGuire Real Estate
listing_co_office_number__c 1497
listing_co_agent_mls_id__c 215760
listing_office_number__c 1497
listing_office_name__c McGuire Real Estate
listing_office_mls_id__c MCGU
of_units__c 2
vacant__c 0
district__c SF District 9
selling_co_office_name__c Vanguard Properties
selling_co_agent_mls_id__c 804736
selling_co_office_mls_id__c VANG02
selling_agent_number__c 1048512
selling_co_agent_number__c 166014407
selling_co_office_number__c 166013449
overall_days_on_market__c 1705
dom__c 22
parking__c Attached,Garage,Interior Access
listing_co_agent_number__c 215760
price_per_square_foot__c 833.33
selling_office_name__c Vanguard Properties
original_price__c 1795000
agent_only_remarks__c Also co-listed with Robert Callan Jr., McGuire Real Estate, 415.351.4645. The square footage of the in-law garden studio is 455 square feet per floorplan artist. This unwarranted square footage is not included in the total square footage of the building. Lingruen pest inspection report and Erik Kaul contractor's inspection report available. Please contact listing agents for a disclosure package. Thank You.
pba__yearbuilt_pb__c 1911
style__c Traditional,Edwardian
type__c Duplex
gross_annual_income__c 0
est_total_expenses__c 0
external_listing__c 1
pba__latitude_property__c 37.758770
listing_agent_number__c 1043069
on_market_date__c 2017-10-26
selling_agent_name__c Derek M. Jackson
selling_co_agent_name__c Scott E. Morton
pba__listing_website__c http://www.871-873RhodeIsland.com
website_property_type__c 2 Unit
media Array
ListingUpdateDate 2022-06-28T04:08:04