meta_query='key:subdist__c;value:Corona Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='331883' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15601
[post_author] => 4
[post_date] => 2018-11-02 02:29:46
[post_date_gmt] => 2018-11-02 02:29:46
[post_content] => Above it all but still in the thick of it, with a great neighborhood dog run, park, and community museum/center. Winding curves, steep hills, jaw-dropping views, sudden changes in direction. You aren't lost. You're in Corona Heights.
[post_title] => Corona Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => corona-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 13:40:29
[post_modified_gmt] => 2024-03-19 20:40:29
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15601
[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, 278 States Street, San Francisco, CA, 94114
ffd_mls_id, 422696021
ffd_salesforce_id, a0E8W00000ZKGaiUAH
num_of_rooms__c, 33
of_units__c, 8
address2__c, 278 States Street, San Francisco, CA, 94114
pba__address_pb__c, 278 States Street, San Francisco, CA, 94114
agent_only_remarks__c, un-warranted, top floor, view studio with private deck is NOT a part of the income. Potential for lot split and to legalize to 9 units.
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 0
year_build_text__c, 1960
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Matthew J Healy
pba__contingentdate__c, 2023-02-09
ffd_createddate, 2022-09-22T18:48:24.000+0000
days_on_market__c, 303
dom__c, 170
ffd_description_pb, 278 States Street is a charming property that consists of 2 buildings on one lot at the top of the Corona Heights neighborhood. The property consists of 8 residential units plus a vacant (unwarranted) unit.The building is comprised of all 2-bedroom and 1-bathroom units, and most units have excellent light and views. Electrical service is 400 amps, and the units are all separately metered for gas and electricity. The apartments are built on a sturdy concrete foundation that includes a parking garage for four cars on States Street and tuck under parking for four cars on Roosevelt Way. There is a shared laundry room in the building as well. The Roosevelt Way structure has two apartments, a large storage room, a laundry room, and a vacant, un-warranted studio unit on the roof. This studio offers a new buyer the potential to legalize a 9th unit which has stunning views and a private deck. The States Street structure has six units and four car parking. Connected via a lrg deck
district__c, SF District 5
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2023-05-19T10:51:57.000+0000
pba__latitude_pb__c, 37.7649178
pba__latitude_property__c, 37.7649178
listed_date__c, 2022-09-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Clinton
pba__listing_agent_lastname__c, Textor
listing_agent_mls_id__c, 901152
ffd_listingagentname, Clinton C Textor
listing_agent_number__c, 901152
listing_co_agent_mls_id__c, 813178
listing_co_agent_number__c, 1059901
listing_co_office_mls_id__c, M&ML
listing_co_office_name__c, Marcus & Millichap
listing_co_office_number__c, 1464
listing_office_mls_id__c, M&ML
listing_office_name__c, Marcus & Millichap
listing_office_number__c, 1464
pba__listingprice_pb__c, 3725000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.441697
mls_id__c, 422696021
parkingspaces__c, 7
on_market_date__c, 2022-09-19
original_price__c, 3900000
overall_days_on_market__c, -81345
parking_features__c, Carport,Garage
pba__pendingdate__c, 2023-03-22
price_per_square_foot__c, 443.73
pba__propertytype__c, 5 or More Unit
ListingId, a0E8W00000ZKGaiUAH
roof__c, Flat
sale_date__c, 2023-05-18
sale_price__c, 3225000
selling_agent_mls_id__c, 901152
selling_agent_number__c, 901152
selling_co_agent_mls_id__c, 813178
selling_co_agent_number__c, 1059901
selling_co_office_mls_id__c, M&ML
selling_co_office_name__c, Marcus & Millichap
selling_co_office_number__c, 1464
selling_office_name__c, Marcus & Millichap
pba__status__c, Closed
pba__totalarea_pb__c, 7268
size__c, 7268
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, States
subdist__c, Corona Heights
ffd_name, 278 States Street, San Francisco, CA, 94114
view__c, City;Bay
website_property_type__c, 5 or More Unit
pba__yearbuilt_pb__c, 1960
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530532241-1.jpg