meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='375869' 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, 1713005913
ffd_listing_title, 336 Missouri Street, San Francisco, CA, 94107
ffd_mls_id, 424017670
ffd_salesforce_id, a0EUd000001WHrZMAW
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 2
address2__c, 336 Missouri Street, San Francisco, CA, 94107
pba__address_pb__c, 336 Missouri Street, San Francisco, CA, 94107
agent_only_remarks__c, Contact Eric for appointments and offer instructions. No preemptive offers will be presented or reviewed until offers are due. Presale escrow opened with Paula Siegel, Fidelity National Title. Offers are to be written on the SFAR purchase contract. No formal HOA dues collected; bills paid as they come in. Dues shown in MLS are an estimated based on 2024 proforma expense budget. Please have your client see the unit before requesting disclosures. Offer date Tues. 4/2/24.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator;Wine Refrigerator;Ice Maker
architectural_style__c, Victorian
bath_features__c, Tub w/Shower Over;Split Bath;Jetted Tub
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1908
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-03-21T19:47:23.000+0000
days_on_market__c, 23
dom__c, 14
ffd_description_pb, You'll feel like the queen/king of the hill in this elegant condo, conveniently located at the center of Potrero Hill's village life. Part of a two-unit Victorian building built in 1908, the flat enjoys generous rooms, ample closets, and period detail, which includes tall ceilings, big windows and well-maintained woodwork. The versatile floorplan can be used like a two bedroom, or a one bedroom with dining room. Occupied by the same owner for nearly 40 years, the flat has been lovingly maintained and upgraded, including a well-equipped kitchen with Viking stove and wine fridge, and a split bathroom with jetted tub. There is a sunroom adjacent to the kitchen with a city view and access to an exclusive use deck and a charming, shared garden. Other common area amenities include shared laundry, extra storage and tandem parking. HOA expenses paid as received; no formal dues.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Fenced
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Common Areas,Insurance on Structure,Water
pba__hoafees__c, 350
pba__hoafrequency_pb__c, See Remarks
hoa_name__c, 336-338 Homeowners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Natural Gas
ffd_lastmodifieddate, 2024-04-13T10:47:27.000+0000
pba__latitude_pb__c, 37.762023
pba__latitude_property__c, 37.762023
listed_date__c, 2024-03-19
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Eric
pba__listing_agent_lastname__c, Castongia
listing_agent_mls_id__c, 393127
ffd_listingagentname, Eric Castongia
listing_agent_number__c, 393127
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CIP
listing_office_name__c, Corcoran Icon Properties
listing_office_number__c, 28936
pba__listingprice_pb__c, 1179000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.396783
mls_id__c, 424017670
master_property__c, a0OUd0000057LmQMAU
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-03-21
original_price__c, 1179000
overall_days_on_market__c, -81894
parking_access__c, Tandem
parking_features__c, Tandem Garage
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2024-04-04
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-04-12T18:41:04.000+0000
price_per_square_foot__c, 1123.19
pba__propertytype__c, Condominium
ListingId, a0EUd000001WHrZMAW
room_type__c, Sun Room
sale_date__c, 2024-04-12
sale_price__c, 1240000
selling_agent_mls_id__c, 810357
selling_agent_number__c, 1045827
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1104
size__c, 1104
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Missouri
subdist__c, Potrero Hill
ffd_name, 336 Missouri Street, San Francisco, CA, 94107
view__c, City;Twin Peaks
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1908
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530748493-1.jpg