meta_query='key:subdist__c;value:Sunnyside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='328015' 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] => 2018-11-01 21:53:52
[post_modified_gmt] => 2018-11-01 21:53:52
[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, 538 Joost Avenue, San Francisco, CA, 94127
ffd_mls_id, 423724821
ffd_salesforce_id, a0E8W00000bFueGUAS
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 538 Joost Avenue, San Francisco, CA, 94127
pba__address_pb__c, 538 Joost Avenue, San Francisco, CA, 94127
agent_only_remarks__c, Easy to show! Lockbox is on the railing at the top of the stairs. Disclosures here: https://app.disclosures.io/link/538-Joost-Avenue-le5g20co. Offers, if any, will be reviewed Monday, March 27 at 12n. Call with questions!
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Range;Gas Plumbed
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1924
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-03-17T20:48:39.000+0000
days_on_market__c, 6
dom__c, 5
ffd_description_pb, This adorable home sits on a fabulous wooded lot with mature oak and redwood trees in the rear. You enter the home through a small entryway and to your left is a sun drenched, south facing living room, with built in bookshelves, a fireplace and tray ceiling. On your right is the formal dining room with a skylight, tray ceilings and built in cabinetry. The dining room opens up to the kitchen which features 3 skylights, walk in pantry, built in office nook and lots of storage. At the rear of the house is the updated bathroom and the 2 bedrooms overlooking the tranquil backyard. The home has newly refinished hard wood floors throughout except beautiful hexagonal tiles in the bathroom. Downstairs has bonus room and bath, one car garage and loads of extra space and storage.
district__c, SF District 4
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Wood
fireplace_features__c, Living Room;Brick
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2023-03-23T00:48:34.000+0000
pba__latitude_pb__c, 37.7325114
pba__latitude_property__c, 37.7325114
laundry_features__c, In Garage;Washer Included;Dryer Included;Cabinets
listed_date__c, 2023-01-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Kat
pba__listing_agent_lastname__c, Rains
listing_agent_mls_id__c, 813352
ffd_listingagentname, Kat F Rains
listing_agent_number__c, 1060995
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, BARBCO
listing_office_name__c, BarbCo
listing_office_number__c, 28297
pba__listingprice_pb__c, 1245000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4475074
mls_id__c, 423724821
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-03-17
open_house_end__c, 2023-03-25T16:00:00.000+0000
open_house_start__c, 2023-03-25T14:00:00.000+0000
original_price__c, 1245000
overall_days_on_market__c, -81524
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Back Porch
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, 1182.34
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bFueGUAS
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, 1053
size__c, 1053
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Joost
subdist__c, Sunnyside
ffd_name, 538 Joost Avenue, San Francisco, CA, 94127
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1924
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530586839-1.jpg
