meta_query='key:subdist__c;value:Sunnyside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='235977' 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
(
)
)
ffd_listing_title, 225 Detroit Street, San Francisco, CA, 94131
ffd_mls_id, 422640996
ffd_salesforce_id, a0E8W00000WgwSKUAZ
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 225 Detroit Street, San Francisco, CA, 94131
pba__address_pb__c, 225 Detroit Street, San Francisco, CA, 94131
agent_only_remarks__c, Please call/text Suna at: 415-516-3273. NOT on lockbox. Very easy to access. Link to disclosure packet here: https://app.disclosures.io/link/225-Detroit-Street-auy8t5sw Tax records: 1,170 sq ft. Graphic artist measured 1,363 sq ft. OFFER DATE: 4/20 at noon.
appliances__c, Dishwasher
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-04-11T10:48:18.000+0000
days_on_market__c, 464
dom__c, 9
ffd_description_pb, This finely crafted, handsome home on a flat, oversized lot is the private retreat in a convenient location not to be missed! The hardwood floors with inlay and calmly painted walls throughout the home are flooded with natural light from windows on all sides. Enjoy verdant views through spacious living room windows, entertain guests in the classic dining room (with an adjacent half bath), and cook for loved ones in the stainless steel-clad kitchen with a charming breakfast nook, all on the main level. The upper level is reserved for the full bathroom and the two generous sized bedrooms with built-in storage and beautiful outlooks. The vast walkout deck overlooking the enchanting yard, provides seamless indoor/outdoor living. A garage the length of the house allows multiple car parking and ample storage. A bonus, detached garage provides unlimited options to explore. Just blocks from 280/101 freeway, Glen Park BART, Tech shuttles, Balboa Park, Muni, Safeway and the Detroit Steps.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fencing__c, Wood
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-05-18T02:46:33.000+0000
pba__latitude_pb__c, 37.729545
pba__latitude_property__c, 37.729545
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2022-03-19
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Suna Akmese
pba__listing_agent_lastname__c, Mullins
listing_agent_mls_id__c, 814014
ffd_listingagentname, Suna Mullins
listing_agent_number__c, 1063963
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB5
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 28396
pba__listingprice_pb__c, 1395000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=N5VJ384SAwJ
pba__longitude_pb__c, -122.44443
mls_id__c, 422640996
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2022-04-11
original_price__c, 1395000
overall_days_on_market__c, -81184
parking_access__c, Tandem
parking_features__c, Attached,Covered,Enclosed
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2022-04-20
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-05-17T13:02:40.000+0000
price_per_square_foot__c, 1602.56
pba__propertytype__c, Single Family Residence
id, a0E8W00000WgwSKUAZ
sale_date__c, 2022-05-17
sale_price__c, 1875000
selling_agent_mls_id__c, 981493
selling_agent_number__c, 981493
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, 1170
size__c, 1170
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Detroit
subdist__c, Sunnyside
ffd_name, 225 Detroit Street, San Francisco, CA, 94131
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530433332-1.jpg
ListingId, a0E8W00000WgwSKUAZ