meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='329011' 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] => 2018-11-02 19:54:27
[post_modified_gmt] => 2018-11-02 19:54:27
[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
(
)
)
ffd_listing_title, 609 San Bruno Avenue, San Francisco, CA, 94107
ffd_mls_id, 423717720
ffd_salesforce_id, a0E8W00000a86IiUAI
num_of_fireplaces__c, 1
num_of_rooms__c, 12
of_units__c, 0
address2__c, 609 San Bruno Avenue, San Francisco, CA, 94107
pba__address_pb__c, 609 San Bruno Avenue, San Francisco, CA, 94107
agent_only_remarks__c, For showings please call/txt Derek or Scott. Fully renovation including new foundation recently completed. Main House 3005 sq ft per graphic artist, historic cottage at rear of lot is additional 470 sq ft- raw space w/ power, water, sewer lines in place for easy expansion, perfect for buyers who need secondary, separate space.
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 1906
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Scott E Morton
pba__contingentdate__c, 2023-02-09
ffd_createddate, 2023-01-27T17:45:55.000+0000
days_on_market__c, 63
dom__c, 42
ffd_description_pb, This Victorian Grand Dame has been ushered into the 21st century with a masterful renovation from head to toe. Behind the ornate period trim and dual pane curved bay windows, this elegant home offers an open and functional floor plan for comfortable modern living. Friends and family will be dazzled with the abundant natural light and graceful flow from the open concept kitchen, dining, and living area that spills out into the private manicured backyard. Pop up to the upper terrace to soak up some sun and skyline vistas. Enjoy an amazing day of BBQing in SF's best micro-climate, then retreat to the fully detached historic 2 story carriage house in the backyard for well deserved me time. 3 Zone Radiant heat throughout, 2 EV chargers in garage, fire sprinkler system, and alarm system. San Bruno Avenue is just 5 minute walk to Whole Foods, hosts two community gardens, and easy walking access to the Mission District via the Fallen Bridge foot path.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2023-03-31T10:49:32.000+0000
pba__latitude_pb__c, 37.761672
pba__latitude_property__c, 37.761672
listed_date__c, 2023-01-22
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Derek
pba__listing_agent_lastname__c, Jackson
listing_agent_mls_id__c, 810859
ffd_listingagentname, Derek M Jackson
listing_agent_number__c, 1048512
listing_co_agent_mls_id__c, 804736
listing_co_agent_number__c, 166014407
listing_co_office_mls_id__c, VANG02
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 166013449
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 3699000
pba__listingtype__c, Sale
pba__listing_website__c, https://youtu.be/1R_F5voVNT4
pba__longitude_pb__c, -122.404871
mls_id__c, 423717720
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-01-27
original_price__c, 3699000
overall_days_on_market__c, -81475
parking_access__c, Independent
parking_features__c, Enclosed,EV Charging,Garage Door Opener
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-03-10
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-03-30T16:42:45.000+0000
price_per_square_foot__c, 1150.08
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000a86IiUAI
sale_date__c, 2023-03-27
sale_price__c, 3456000
selling_agent_mls_id__c, 807124
selling_agent_number__c, 166018264
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, KW Advisors
pba__status__c, Closed
pba__totalarea_pb__c, 3005
size__c, 3005
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, San Bruno
subdist__c, Potrero Hill
ffd_name, 609 San Bruno Avenue, San Francisco, CA, 94107
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1906
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530572748-1.jpg
