meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='211005' posts_per_page=4 post_type=property
int(1)
Array
(
[ID] => 15603
[post_author] => 4
[post_date] => 2018-11-02 02:29:53
[post_date_gmt] => 2018-11-02 02:29:53
[post_content] => Liberty Hill. The sweet, sweet homes surrounding Dolores Park. Gaze at the downtown skyline after a walk through Dolores Park with the pooch. Not quite Noe Valley or the Castro and rising above Mission Dolores, Dolores Heights is home to some of central San Francisco's most expensive real estate.
[post_title] => Dolores Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => dolores-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 13:49:28
[post_modified_gmt] => 2024-03-19 20:49:28
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15603
[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, 39 Seward Street, San Francisco, CA, 94114
ffd_mls_id, 506451
ffd_salesforce_id, a0E1I00000TTNLaUAP
vacant__c, 1
num_of_rooms__c, 0
of_units__c, 3
address2__c, 39 Seward Street, San Francisco, CA, 94114
pba__address_pb__c, 39 Seward Street, San Francisco, CA, 94114
agent_only_remarks__c, Six parking spaces.
appliances__c, Dishwasher;Disposal;Free Standing Refrigerator;Free Standing Oven/Range
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 5
year_build_text__c, 1973
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-03-11
ffd_createddate, 2020-10-20T16:46:54.000+0000
days_on_market__c, 1002
dom__c, 156
ffd_description_pb, Three unit building nestled in the heart of Eureka Valley. Approximately 3,000 square feet of total living area. Upper floor owners residence delivered vacant and ready for the discerning buyer. Large residence three bedrooms and two bathrooms, superior spacious kitchen, considerable counters, center island and substantial cabinets. Open floor plan enables a modern lifestyle. Exceptional views. Two lower level one bedroom & bathroom units are remodeled and attractive flats.
district__c, SF District 5
est_total_expenses__c, 0
external_listing__c, 1
pba__floortype_pb__c, Bamboo;Carpet;Tile;Wood;Simulated Wood
gross_annual_income__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Baseboard;Central;Wall Furnace;Fireplace(s)
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T13:32:18.000+0000
pba__latitude_pb__c, 37.75784
pba__latitude_property__c, 37.75784
laundry_features__c, In Common Area
listed_date__c, 2020-09-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, Kirkpatrick
listing_agent_mls_id__c, 802848
ffd_listingagentname, John M Kirkpatrick
listing_agent_number__c, 802848
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12PUI
listing_office_name__c, Compass
listing_office_number__c, 27690
pba__listingprice_pb__c, 2750000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/470144526
pba__longitude_pb__c, -122.439984
pba__lotsize_pb__c, 0.06
mls_id__c, 506451
master_property__c, a0O8W00000DaF5fUAF
parkingspaces__c, 6
on_market_date__c, 2020-10-20
original_price__c, 3000000
overall_days_on_market__c, 223
parking__c, Attached,Garage,Auto Door,Interior Access
parking_features__c, Attached,Garage,Garage Door Opener,Interior Access
patio_and_porch_features__c, Patio(s);Balcony/Deck
pba__pendingdate__c, 2021-03-25
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 884.47
pba__propertytype__c, Triplex
id, a0E1I00000TTNLaUAP
roof__c, Foam
sale_date__c, 2021-04-07
sale_price__c, 2637500
security_features__c, Fire Suppression System
selling_agent_mls_id__c, 809688
selling_agent_number__c, 1042733
selling_co_agent_mls_id__c, 803037
selling_co_agent_number__c, 803037
selling_co_office_mls_id__c, VANG02
selling_co_office_name__c, Vanguard Properties
selling_co_office_number__c, 166013449
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 2982
size__c, 2982
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Seward
style__c, Contemporary
subdist__c, The Castro - Dolores Heights
ffd_name, 39 Seward Street, San Francisco, CA, 94114
type__c, Apartments,2 Story
view__c, City Lights;Garden/Greenbelt;Bay;Downtown;San Francisco;Hills;Mountains;Woods;Valley;Forest
website_property_type__c, Triplex
window_features__c, Window Coverings;Dual Pane;Greenhouse Window(s);Window Screens
pba__yearbuilt_pb__c, 1973
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/372517-1.jpg
ListingId, a0E1I00000TTNLaUAP