meta_query='key:subdist__c;value:Sunnyside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='420014' 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, 1731031087
ffd_listing_title, 134 Detroit Street, San Francisco, CA, 94131
ffd_mls_id, 424070302
ffd_salesforce_id, a0EUd000003QWCDMA4
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 134 Detroit Street, San Francisco, CA, 94131
pba__address_pb__c, 134 Detroit Street, San Francisco, CA, 94131
agent_only_remarks__c, Escrow is open with ORTC. Contact Carla Williams at (415) 248-7153 or [email protected]. Per the appraisal, the GLA is 889 sq. ft. Disclosures: https://app.disclosures.io/link/134-Detroit-Street-h8h0n24u Text (415) 309-9139 with any questions.
architectural_style__c, Spanish;Bungalow
bath_features__c, Tub w/Shower Over;Low-Flow Toilet(s)
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1925
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-10-23T10:48:20.000+0000
days_on_market__c, 15
dom__c, 15
ffd_description_pb, Welcome to this charming 2-bedroom, 1-bath starter home in the sought-after Sunnyside neighborhood, offering beautiful city views and boundless potential. This cozy residence, featuring approximately 889 sq. ft. of living space, presents a unique opportunity for first-time homebuyers or savvy investors. With its original condition, the home is a blank canvas, ready for you to bring your vision to lifewhether through remodeling or expanding. The location offers convenient access to parks, schools, shops, and public transportation, with the added benefit of quick highway access for easy commuting. This property is ideal for those looking to customize and create their dream home in a vibrant, well-connected neighborhood.
district__c, SF District 4
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Vinyl;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Fireplace(s)
ffd_lastmodifieddate, 2024-11-08T01:47:03.000+0000
pba__latitude_pb__c, 37.7286994
pba__latitude_property__c, 37.7286994
laundry_features__c, In Garage;Hookups Only
listed_date__c, 2024-10-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Teressa
pba__listing_agent_lastname__c, Martichonok
listing_agent_mls_id__c, 806399
ffd_listingagentname, Teressa Martichonok
listing_agent_number__c, 166016886
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, MANH
listing_office_name__c, Manhattan Realty Group
listing_office_number__c, 166013793
pba__listingprice_pb__c, 998000
pba__listingtype__c, Sale
pba__listing_website__c, https://openhouse.propertypath.com/properties/373935
pba__longitude_pb__c, -122.4441082
mls_id__c, 424070302
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-10-23
open_house_end__c, 2024-11-09T16:00:00.000+0000
open_house_start__c, 2024-11-09T14:00:00.000+0000
original_price__c, 998000
overall_days_on_market__c, -82110
parking_access__c, Independent
parking_features__c, Attached,Garage Facing Front
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
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, 1122.61
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000003QWCDMA4
roof__c, Tar/Gravel
sale_date__c, 1800-01-01
sale_price__c, 0
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, 889
size__c, 889
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Detroit
subdist__c, Sunnyside
ffd_name, 134 Detroit Street, San Francisco, CA, 94131
view__c, City;San Francisco
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1925
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530855939-1.jpg