meta_query='key:subdist__c;value:Pacific Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='321110' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15724
[post_author] => 4
[post_date] => 2018-11-02 19:54:44
[post_date_gmt] => 2018-11-02 19:54:44
[post_content] => The grand estates of San Francisco. Commanding views. Lavishly large lots. Neighbors that you could name drop, but that's not your style. Pacific Heights says it all, without saying a word.
[post_title] => Pacific Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => pacific-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-28 07:08:05
[post_modified_gmt] => 2024-03-28 14:08:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15724
[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, 2563 Clay Street, San Francisco, CA, 94115
ffd_mls_id, 422695785
ffd_salesforce_id, a0E8W00000YZybcUAD
num_of_rooms__c, 20
of_units__c, 9
address2__c, 2563 Clay Street, San Francisco, CA, 94115
pba__address_pb__c, 2563 Clay Street, San Francisco, CA, 94115
agent_only_remarks__c, Please visit 2563ClayStreet.com
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 0
year_build_text__c, 1905
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Jessica Grimes
pba__contingentdate__c, 2022-10-24
ffd_createddate, 2022-09-19T19:49:37.000+0000
days_on_market__c, 303
dom__c, 56
ffd_description_pb, If you agree that the first three rules of real estate investing are Location, Location, Location, then 2563 Clay Street, in the heart of Pacific Heights, may well be the finest investment opportunity available in San Francisco today. Alta Plaza is just one-half block to the west, while the Fillmore Shopping District is just one-half block to the east. The architecturally appealing Edwardian building consists of eight quaint studio apartments (one will be delivered vacant), plus a two bedroom Owners' garden apartment (will be delivered vacant). The property has been thoughtfully maintained and upgraded by the current owners, making it an extremely attractive acquisition opportunity for savvy investors or first-time buyers. This is your chance to help your clients purchase a legacy Pacific Heights apartment building worthy of being passed down from generation to generation. Please contact your favorite agent for more details.
district__c, SF District 7
exterior_features__c, Yard Space
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Electric;Gas;Separate
ffd_lastmodifieddate, 2022-12-23T03:46:29.000+0000
pba__latitude_pb__c, 37.7903787
pba__latitude_property__c, 37.7903787
laundry_features__c, Coin Operated;In Common Area
listed_date__c, 2022-09-17
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Steven
pba__listing_agent_lastname__c, Mavromihalis
listing_agent_mls_id__c, 197832
ffd_listingagentname, Steven Mavromihalis
listing_agent_number__c, 197832
listing_co_agent_mls_id__c, 817145
listing_co_agent_number__c, 1076042
listing_co_office_mls_id__c, COMP12
listing_co_office_name__c, Compass
listing_co_office_number__c, 28739
listing_office_mls_id__c, COMP12
listing_office_name__c, Compass
listing_office_number__c, 28739
pba__listingprice_pb__c, 3750000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.2563ClayStreet.com/
pba__longitude_pb__c, -122.4352113
mls_id__c, 422695785
parkingspaces__c, 2
on_market_date__c, 2022-09-19
original_price__c, 3750000
overall_days_on_market__c, -81345
parking_features__c, Attached,Covered,Garage,Tandem Garage
pba__pendingdate__c, 2022-11-14
price_per_square_foot__c, 810.88
pba__propertytype__c, 5 or More Unit
ListingId, a0E8W00000YZybcUAD
sale_date__c, 2022-12-22
sale_price__c, 3413000
security_features__c, Fire Alarm;Fire Suppression System;Fire Extinguisher;Double Strapped Water Heater
selling_agent_mls_id__c, 808089
selling_agent_number__c, 1030601
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, 4209
size__c, 4209
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Clay
subdist__c, Pacific Heights
ffd_name, 2563 Clay Street, San Francisco, CA, 94115
website_property_type__c, 5 or More Unit
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1905
pba__postalcode_pb__c, 94115
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530530629-1.jpg