meta_query='key:subdist__c;value:Sunnyside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='349617' 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, 1705147013
ffd_listing_title, 207 Flood Avenue, San Francisco, CA, 94112
ffd_mls_id, 423904882
ffd_salesforce_id, a0E8W00000cqQgWUAU
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 207 Flood Avenue, San Francisco, CA, 94112
pba__address_pb__c, 207 Flood Avenue, San Francisco, CA, 94112
agent_only_remarks__c, For showings, disclosures, or questions please contact Tori Andrews (650.269.1357, [email protected]). *1 car parking in the garage and 2nd in the driveway. ** 4th bedroom does not have a closet. ***We have multiple square footage measurements. Buyer is advised to investigate to their own satisfaction. Graphic Artist (2023): 1,700 sqft, Tax Records: 1,403 sqft, MLS (2010, per appraiser): 1,501 sqft.
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1922
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-09-07T17:46:54.000+0000
days_on_market__c, 128
dom__c, 103
ffd_description_pb, Nestled in the charming Sunnyside neighborhood, 207 Flood Ave is flooded with incredible natural light through the many windows and skylights and enjoys beautiful hardwood floors throughout. The living room is centered around a fireplace and flows to the spacious dining room, which acts as the heart of the home. The adjacent kitchen is appointed with a gas range, a breakfast area, and direct access to the south-facing deck. Completing the main level are two bedrooms and a full bath. On the lower level are two additional bedrooms, both with direct access out to the garden. The south-facing garden is the perfect retreat with mature landscaping, a flat usable lawn, and patio. The bathroom has been thoughtfully remodeled with a walk-in shower, radiant floor heating, a towel warmer, and skylight. The laundry/mudroom has incredible storage and side-by-side washer/dryer. Ideally located near the restaurants and shops in Glen Park, Bart, Whole Foods, Safeway, Balboa Park, Sunnyside Playground, and easy freeway access.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-01-13T11:47:33.000+0000
pba__latitude_pb__c, 37.7297102
pba__latitude_property__c, 37.7297102
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2023-09-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tori
pba__listing_agent_lastname__c, Andrews
listing_agent_mls_id__c, 808858
ffd_listingagentname, Tori Andrews
listing_agent_number__c, 1038063
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 1575000
pba__listingtype__c, Sale
pba__listing_website__c, http://207flood.com
pba__longitude_pb__c, -122.4445207
mls_id__c, 423904882
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-09-07
original_price__c, 1675000
overall_days_on_market__c, -81698
parking_access__c, Tandem
parking_features__c, Attached,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck;Uncovered Patio
pba__pendingdate__c, 2023-12-19
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 926.47
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000cqQgWUAU
room_type__c, Office;Laundry
sale_date__c, 2024-01-12
sale_price__c, 1575000
security_features__c, Security Gate
selling_agent_mls_id__c, 810756
selling_agent_number__c, 1047830
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, 1700
size__c, 1700
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Flood
subdist__c, Sunnyside
ffd_name, 207 Flood Avenue, San Francisco, CA, 94112
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1922
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530672607-1.jpg