meta_query='key:subdist__c;value:Sunnyside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='423708' 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-11-22 11:37:36
[post_modified_gmt] => 2024-11-22 19:37:36
[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, 1739154071
ffd_listing_title, 626 Joost Avenue, San Francisco, CA, 94127
ffd_mls_id, 425006992
ffd_salesforce_id, a0EUd000004BBAuMAO
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 0
pba__address_pb__c, 626 Joost Avenue, San Francisco, CA, 94127
address2__c, 626 Joost Avenue, San Francisco, CA, 94127
agent_only_remarks__c, Offer Date to be Thurs, Feb 13th by Noon. Schedule an appointment through ShowingTime and access instructions will be sent to you. One or more of the ultimate owners of the seller is a licensed real estate professional in California. No buyer letters please per sellers request. *Electrical Panel has been updated* Seller will consider buyer offers asking for concessions. Some photos are virtually enhanced. Square footage on Tax Records shows 970sqft and Floorplan Draft shows 944 sqft - Buyers to confirm to their satisfaction. Escrow opened with Lynn Chan at Fidelity. Disclosure Package Link: https://app.disclosures.io/link/626-Joost-Avenue-s3jn4azt
appliances__c, Dishwasher;Microwave;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Contemporary;Edwardian
bath_features__c, Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1926
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Peter H Fong
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2025-01-31T11:48:25.000+0000
days_on_market__c, 9
dom__c, 9
ffd_description_pb, Nestled in the charming Sunnyside neighborhood, 626 Joost Avenue blends 1920s Edwardian craftsmanship with modern comforts. This sunlit home features original hardwood floors, new main-level windows, and a beautifully updated kitchen with stone countertops, modern cabinetry, and a stylish backsplash. Main level opes up to a spacious deck leading to a vast yard, perfect for relaxation or gardening - indoor/outdoor living at its finest. The home offers two spacious bedrooms, a remodeled bathroom, a full basement with ample storage, a two-car garage, laundry access, and a generous driveway. Conveniently located near Monterey Blvd shopping, Miraloma Park, Glen Park, and Sunnyside Playground, it also provides easy transit and freeway access. Nearby top-rated schools include CAIS, Lick Wilmerding, Riordan, Stratford, Waldorf, Lowell, and Sunnyside. This residence is a must-see for those seeking timeless elegance and urban convenience.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fencing__c, Wood
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2025-02-10T01:46:38.000+0000
pba__latitude_pb__c, 37.7324576
pba__latitude_property__c, 37.7324576
laundry_features__c, Hookups Only;In Basement
listed_date__c, 2025-01-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Timothy
pba__listing_agent_lastname__c, Fong
listing_agent_mls_id__c, 400313
ffd_listingagentname, Timothy G Fong
listing_agent_number__c, 400313
listing_co_agent_mls_id__c, 039902
listing_co_agent_number__c, 39902
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1099000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4495852
mls_id__c, 425006992
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2025-01-31
open_house_end__c, 2025-02-09T13:00:00.000+0000
open_house_start__c, 2025-02-09T11:00:00.000+0000
original_price__c, 1099000
overall_days_on_market__c, -82210
parking_access__c, Tandem
parking_features__c, 24'+ Deep Garage,Garage Door Opener,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, 1132.99
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000004BBAuMAO
room_type__c, Kitchen;Living Room;Baths Other;Dining Room
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, 970
size__c, 970
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Joost
subdist__c, Sunnyside
ffd_name, 626 Joost Avenue, San Francisco, CA, 94127
view__c, City;Hills
website_property_type__c, Single Family Home
window_features__c, Dual Pane Partial
pba__yearbuilt_pb__c, 1926
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530938348-1.jpg