meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='327318' 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, 349 Mississippi 351 Street, San Francisco, CA, 94107
ffd_mls_id, 423718381
ffd_salesforce_id, a0E8W00000bFRJnUAO
num_of_rooms__c, 9
of_units__c, 2
address2__c, 349 Mississippi 351 Street, San Francisco, CA, 94107
pba__address_pb__c, 349 Mississippi 351 Street, San Francisco, CA, 94107
agent_only_remarks__c, Upper unit tenant occupied. Scheduling private showings for both units. Disclosure package available. Upper unit tenant occupied at $4250/month with a lease April 30, 2023. Seller will not need a rent-back.
appliances__c, Dishwasher
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 4
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-03-10T11:52:03.000+0000
days_on_market__c, 12
dom__c, 11
ffd_description_pb, Don't miss this perfectly charming Victorian two-unit building. The lower unit is an owner-occupied 2bed/2bath flat with a wonderful soapstone kitchen, 2 fireplaces, with living room and dining space that enjoy views of the lush and tranquil garden, which features an infrared sauna. The upper unit is a tenant-occupied 2bed/2bath flat that boasts lofty ceilings, 2 fireplaces, 7 skylights and a quartz kitchen. The views from the back are even better, with a spiral to the attic for additional storage and laundry. The full basement is shared with room for systems and storage! The North Slope location is just around the corner from the heart of the Hill, which if you're not familiar with Potrero Hill, you should check out. Shops, restaurants, other businesses and long-time locations line both sides of 18th St. Street parking in Potrero Hill is notoriously abundant, not to mention the microclimate that keeps the Hill warm and sunny even when fog covers much of the City. Call me with questions and for showings.
district__c, SF District 9
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Skylight(s);Storage Area(s);Vaulted Ceiling(s)
ffd_lastmodifieddate, 2023-03-21T20:49:03.000+0000
pba__latitude_pb__c, 37.761766
pba__latitude_property__c, 37.761766
laundry_features__c, In Each Unit;Washer/Dryer Owned
listed_date__c, 2023-01-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Michelle
pba__listing_agent_lastname__c, Stephens
listing_agent_mls_id__c, 540107
ffd_listingagentname, Michelle R Stephens
listing_agent_number__c, 540107
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 1800000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.cbhometour.com/349---351-Mississippi-Street-San-Francisco-CA-94107/mlsindex.html
pba__longitude_pb__c, -122.394192
mls_id__c, 423718381
parkingspaces__c, 0
on_market_date__c, 2023-03-10
open_house_end__c, 2023-03-21T16:00:00.000+0000
open_house_start__c, 2023-03-21T14:00:00.000+0000
original_price__c, 1800000
overall_days_on_market__c, -81517
patio_and_porch_features__c, Enclosed Patio;Uncovered Patio
pba__pendingdate__c, 1800-01-01
price_per_square_foot__c, 867.05
pba__propertytype__c, Duplex
ListingId, a0E8W00000bFRJnUAO
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 2076
size__c, 2076
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Mississippi
subdist__c, Potrero Hill
ffd_name, 349 Mississippi 351 Street, San Francisco, CA, 94107
view__c, City;City Lights;Bay;Water;Downtown;Bay Bridge;San Francisco;Hills
website_property_type__c, Duplex
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530575827-1.jpg