meta_query='key:subdist__c;value:Ingleside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='376801' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12158
[post_author] => 4
[post_date] => 2018-10-29 01:19:09
[post_date_gmt] => 2018-10-29 01:19:09
[post_content] => Ingleside is a lot more down-to-earth than some of its swankier neighbors on the north end of town, and it's also a lot more affordable. Homes tend to be modest, some in the same family for generations. Unexpected views of downtown add to the attraction of this more-affordable neighborhood, which also has great public transit options and easy freeway access.
[post_title] => Ingleside
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => ingleside
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-25 13:49:10
[post_modified_gmt] => 2024-11-25 21:49:10
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12158
[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, 1735681080
ffd_listing_title, 284 Jules Avenue, San Francisco, CA, 94112
ffd_mls_id, 424013961
ffd_salesforce_id, a0EUd000001NZhGMAW
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 284 Jules Avenue, San Francisco, CA, 94112
pba__address_pb__c, 284 Jules Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Vacant and easy to show by appointment - please schedule using the ShowingTime app. Offers reviewed Wednesday, 3/20, at noon. Please submit offers via HomeLight Listing Management. If obtaining a loan, please include a Letter of Pre-Approval; if offering all cash, please submit Proof of Funds. Contact Eddie O'Sullivan with any questions. Pre-escrow #0216038852-MS opened with Old Republic Title - contact Maria Smith, Escrow Officer, at [email protected] or 415.570.0872. Property disclosures available - use this link to access documents: https://app.disclosures.io/link/284-Jules-Avenue-b6rtkv2l. www.284jules.com
appliances__c, Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
bath_features__c, Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1923
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Blanca Aguirre
pba__contingentdate__c, 2024-03-23
ffd_createddate, 2024-03-07T19:47:13.000+0000
days_on_market__c, 299
dom__c, 42
ffd_description_pb, Welcome to 284 Jules Ave in the bustling Ingleside neighborhood! A short one block walk opens to the many fantastic shops and restaurants on Ocean Ave including Whole Foods, A-1 Bakery, Philz Coffee and Beep's Burgers. The Ingleside Branch library is nearby as is 24-Hour Fitness, City College of San Francisco and San Francisco State University. Enjoy weekends at Lake Merced Park, hiking through Fort Funston or feeding the animals at the San Francisco Zoo. So much to do starting from your single family home base on Jules! This unique home features a charming front entry porch providing entry into the spacious living room. The home offers two bedrooms, one full bath (with direct access from each bedroom) and eat-in kitchen. Enjoy refinished hardwood floors throughout and Quartz countertops in the kitchen with four-burner gas range. The home is completed with one-car garage parking with abundant storage and laundry facilities. Scores: Walk=86; Transit=78; Bike=79.
district__c, SF District 3
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Full
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-04-30T10:47:23.000+0000
pba__latitude_pb__c, 37.7234862
pba__latitude_property__c, 37.7234862
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2024-02-09
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Edmond
pba__listing_agent_lastname__c, O'Sullivan
listing_agent_mls_id__c, 804421
ffd_listingagentname, Eddie O'Sullivan
listing_agent_number__c, 166013970
listing_co_agent_mls_id__c, 301983
listing_co_agent_number__c, 301983
listing_co_office_mls_id__c, KWADVSF
listing_co_office_name__c, KW Advisors
listing_co_office_number__c, 28861
listing_office_mls_id__c, ELEVATE
listing_office_name__c, Elevation Real Estate
listing_office_number__c, 27424
pba__listingprice_pb__c, 599000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.zillow.com/view-imx/4475415f-d92d-4caa-a6ab-eee9ae4053a0?setAttribution=mls&wl=true&initialViewType=pano&utm_source=dashboard
pba__longitude_pb__c, -122.4610923
mls_id__c, 424013961
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Street Entrance
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-03-07
original_price__c, 599000
overall_days_on_market__c, -81880
parking_access__c, Independent
parking_features__c, Attached
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Front Porch
pba__pendingdate__c, 2024-04-18
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-04-29T15:35:28.000+0000
price_per_square_foot__c, 994.22
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001NZhGMAW
road_surface_type__c, Asphalt
room_type__c, Kitchen;Living Room;Guest Quarters;Baths Other;Primary Bedroom
sale_date__c, 2024-04-29
sale_price__c, 688000
security_features__c, Security Gate
selling_agent_mls_id__c, 816151
selling_agent_number__c, 1075135
selling_co_agent_mls_id__c, 816768
selling_co_agent_number__c, 1075708
selling_co_office_mls_id__c, KWADVSF
selling_co_office_name__c, KW Advisors
selling_co_office_number__c, 28861
selling_office_name__c, KW Advisors
pba__status__c, Closed
pba__totalarea_pb__c, 692
size__c, 692
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Jules
subdist__c, Ingleside
ffd_name, 284 Jules Avenue, San Francisco, CA, 94112
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1923
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530741300-1.jpg