meta_query='key:subdist__c;value:Sunnyside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='374775' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15556
[post_author] => 4
[post_date] => 2018-11-01 21:53:52
[post_date_gmt] => 2018-11-01 21:53:52
[post_content] => Not always sunny, shameless neighborhood self-promotion aside. Within walking distance to Glen Park BART, mostly single-family homes, bisected by Monterey Ave. Above, Sunnyside on a hill with some great southern views. Below, Sunnyside flatlands bounded by I-280 and City College to the south.
[post_title] => Sunnyside
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => sunnyside
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 13:31:56
[post_modified_gmt] => 2024-03-19 20:31:56
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15556
[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, 1713437951
ffd_listing_title, 448 judson Avenue, San Francisco, CA, 94112
ffd_mls_id, 424018753
ffd_salesforce_id, a0EUd000001Yn8zMAC
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 448 judson Avenue, San Francisco, CA, 94112
pba__address_pb__c, 448 judson Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Circumstances have changed as this listing has progressed. Last tenant has moved out. Seller intends to refresh'' the property. We are in that process now. When the property is available to show we will have new paint, newly refinished floors, modestly renewed Kitchen and Bath, and frankly a new price. Call Tim on or after April 25th for updates and timeline for open house, lock box entry and other particulars.
appliances__c, Free Standing Gas Range;Free Standing Refrigerator
bath_features__c, Shower Stall(s)
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 0
year_build_text__c, 1941
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-03-26T15:46:37.000+0000
days_on_market__c, 23
dom__c, 23
ffd_description_pb, Full-5 Sunnyside Home: 2-Bedrooms, 1 Bath, Living Room, Dining Room, Kitchen. Property currently being refreshed. One car garage parking. This a court-ordered sale. There is no court confirmation required, no overbidding required. Showings are STRICTLY by appointment after full discussion with Listing Agent. Consult Listing Agent for all details.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Wood
pba__floortype_pb__c, Linoleum;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-04-18T10:47:13.000+0000
pba__latitude_pb__c, 37.7285491
pba__latitude_property__c, 37.7285491
laundry_features__c, In Garage;Hookups Only
listed_date__c, 2024-03-26
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tim
pba__listing_agent_lastname__c, Curran
listing_agent_mls_id__c, 244894
ffd_listingagentname, Tim Curran
listing_agent_number__c, 244894
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP41
listing_office_name__c, Compass
listing_office_number__c, 27887
pba__listingprice_pb__c, 898000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4519634
mls_id__c, 424018753
main_level__c, Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-03-26
original_price__c, 898000
overall_days_on_market__c, -81899
parking_access__c, Independent
parking_features__c, Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 623.18
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001Yn8zMAC
road_surface_type__c, Asphalt
roof__c, Elastomeric
room_type__c, Storage
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 1441
size__c, 1441
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, judson
subdist__c, Sunnyside
ffd_name, 448 judson Avenue, San Francisco, CA, 94112
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1941
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530750609-1.jpg
