meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='418503' 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] => 2024-03-19 14:08:25
    [post_modified_gmt] => 2024-03-19 21:08:25
    [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
        (
        )

)

_yoast_indexnow_last_ping, 1728161699

ffd_listing_title, 717 San Bruno Avenue, San Francisco, CA, 94107

ffd_mls_id, 424069783

ffd_salesforce_id, a0EUd000003Ed1OMAS

num_of_fireplaces__c, 0

num_of_rooms__c, 6

of_units__c, 0

address2__c, 717 San Bruno Avenue, San Francisco, CA, 94107

pba__address_pb__c, 717 San Bruno Avenue, San Francisco, CA, 94107

pba__fullbathrooms_pb__c, 2

pba__bedrooms_pb__c, 3

year_build_text__c, 1900

pba__city_pb__c, San Francisco

listing_co_agent_name__c, Christian Elbeck

pba__contingentdate__c, 1800-01-01

ffd_createddate, 2024-09-30T16:48:15.000+0000

days_on_market__c, 5

dom__c, 5

ffd_description_pb, Enjoy sweeping, unencumbered Bay and City views from this expansive, newly remodeled Potrero Hill home. Set high atop the apex of Potrero Hill, this majestic property enjoys breathtaking views from each room in this meticulously executed masterpiece, creating a captivating ambiance fit to rival the finest homes in San Francisco. Spread over 2,000 square feet of sumptuous interior spaces, the property seamlessly blends modern design features with stunning outdoor spaces, resulting in a perfectly curated indoor/outdoor living experience. A recent studs-down remodel combines modern, technology driven features with original pre-war aesthetics, resulting in the perfect balance of old world charm and modern-day luxury. Additionally, over $350K was invested in actively permitted expansion plans, for those who may be interested in reimagining the property on an even grander scale.

district__c, SF District 9

entry_level__c, 0

external_listing__c, 1

pba__hoafees__c, 0

hoa__c, No

pba__halfbathrooms_pb__c, 0

ffd_lastmodifieddate, 2024-10-05T20:47:20.000+0000

pba__latitude_pb__c, 37.7602583

pba__latitude_property__c, 37.7602583

listed_date__c, 2024-09-30

pba__listing_agent_email__c, [email protected]

pba__listing_agent_firstname__c, John

pba__listing_agent_lastname__c, Murphy

listing_agent_mls_id__c, 814555

ffd_listingagentname, Jack Murphy

listing_agent_number__c, 1067076

listing_co_agent_mls_id__c, 815055

listing_co_agent_number__c, 1070419

listing_co_office_mls_id__c, COMP12

listing_co_office_name__c, Compass

listing_co_office_number__c, 28739

listing_office_mls_id__c, COMP

listing_office_name__c, Compass

listing_office_number__c, 26293

pba__listingprice_pb__c, 2495000

pba__listingtype__c, Sale

pba__listing_website__c, http://