meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='381029' 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, 1719018513
ffd_listing_title, 358 Missouri Street, San Francisco, CA, 94107
ffd_mls_id, 424030073
ffd_salesforce_id, a0EUd000001vTzCMAU
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 3
address2__c, 358 Missouri Street, San Francisco, CA, 94107
pba__address_pb__c, 358 Missouri Street, San Francisco, CA, 94107
agent_only_remarks__c, Showings by appt after first weekend of open houses. Contact Cynthia 415.317.0589. Sirkin TIC Agreement in place. 34% interest. 1 leased private parking (no storage) space available 2 blocks away, paid through November, $300/mo Disclosures: https://app.disclosures.io/link/358-Missouri-Street-0223pyrv
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 4
year_build_text__c, 1906
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-05-03T22:47:41.000+0000
days_on_market__c, 49
dom__c, 26
ffd_description_pb, Located atop a stunning Victorian building, 358 Missouri is a gem in a prime location. This full-floor flat, part of a well-maintained three-unit building, offers panoramic views from every room. Sunlight floods the space, ensuring bright, uplifting days, while the evening city lights transform into a personal gallery of urban art. This home features a versatile layout with three to four bedrooms and one and a half bathrooms, recently enhanced with permitted updates including a new half bath, a laundry closet, and upgrades to electrical and plumbing systems. The newly remodeled kitchen shines with a playful yet sophisticated cabinet color, beautifully matched stone surfaces, and a touch of glamour with gold hardware, all set against new stainless steel appliances. The elegant dining room, overlooking downtown San Francisco, sets the stage for unforgettable entertaining with family and friends. Situated in one of the city's finest neighborhoods, the location is just steps away from popular spots like Chez Maman, Mochica, Farley's, and Plow. Commuting is convenient with easy access to the 280 freeway and multiple transit options nearby. According to WalkScore.com...96 walk score, 72 transit score, 66 bike score making it highly accessible and desirable. Welcome Home!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Vinyl
pba__hoafees__c, 250
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 358-362 Missouri
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-06-22T00:50:23.000+0000
pba__latitude_pb__c, 37.761818
pba__latitude_property__c, 37.761818
laundry_features__c, Laundry Closet;Hookups Only
listed_date__c, 2024-02-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Cynthia
pba__listing_agent_lastname__c, Pagan
listing_agent_mls_id__c, 809151
ffd_listingagentname, Cynthia M Pagan
listing_agent_number__c, 1040801
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, PACEDGE
listing_office_name__c, Pacific Edge
listing_office_number__c, 28507
pba__listingprice_pb__c, 1195000
pba__listingtype__c, Sale
pba__listing_website__c, https://TopFloorMissouri.com/mls
pba__longitude_pb__c, -122.396763
mls_id__c, 424030073
monthly_parking_fees__c, 300
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-05-03
original_price__c, 1195000
overall_days_on_market__c, -81937
parking_access__c, Independent
parking_features__c, Garage Door Opener,Private,See Remarks
parking_type__c, Other
pba__pendingdate__c, 2024-05-29
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-06-21T10:46:30.000+0000
price_per_square_foot__c, 822.12
pba__propertytype__c, Tenancy In Common
ListingId, a0EUd000001vTzCMAU
room_type__c, Storage;Office;Laundry;Kitchen;Living Room;Dining Room
sale_date__c, 2024-06-20
sale_price__c, 1100000
selling_agent_mls_id__c, 516376
selling_agent_number__c, 516376
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Park North Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1338
size__c, 1338
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Missouri
subdist__c, Potrero Hill
ffd_name, 358 Missouri Street, San Francisco, CA, 94107
website_property_type__c, Tenancy In Common
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/530772365-1.jpg