meta_query='key:subdist__c;value:Ingleside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='216845' 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
(
)
)
ffd_listing_title, 254 Jules Avenue, San Francisco, CA, 94112
ffd_mls_id, 515147
ffd_salesforce_id, a0E1I00000TvuzCUAR
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 254 Jules Avenue, San Francisco, CA, 94112
pba__address_pb__c, 254 Jules Avenue, San Francisco, CA, 94112
agent_only_remarks__c, No public open house. Owner occupied. Rooms & Bath down-legality not guaranteed. Buyer(s) to pay for inspections and recommended work. Disclosures will be ready soon. Pre-sale escrow opened w/ Christine Lin @ Old Republic Title. Appointment instruction: Viewing is to follow the advised health safety protocols when entering the property. Please provide you and your clients face masks and gloves. Please send signed Coronavirus Property Entry Advisory and Declaration (C.A.R Form PEAD, 4/20) Appt must be confirmed. Text listing agent @ (415)992-2582 with questions and disclosures. Be safe, be healthy!
appliances__c, Microwave;Hood Over Range
bath_features__c, Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1922
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-02-08
ffd_createddate, 2021-02-16T00:21:41.000+0000
days_on_market__c, 1433
dom__c, 32
ffd_description_pb, This spacious Ingleside home blends modern conveniences with historic appeal in San Francisco. To be sold As-Is. Main floor has large living room, 3Bd 1BA. Perfect for a large family or investor. Built in 1922, same owner over 30 years, this home has unlimited possibilities. Solar panels installed on the roof. Will deliver vacant. 1-car parking, can also park another car in the driveway. Large backyard. Excellent location, walk to Ocean Ave, near Stonestown shopping center, schools, parks, restaurants, local businesses, the freeway, and public transportation. Don't miss it!
district__c, SF District 3
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
electric__c, See Remarks
entry_level__c, 0
external_listing__c, 1
fencing__c, Wood
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-01-25T15:43:41.000+0000
pba__latitude_pb__c, 37.7228439
pba__latitude_property__c, 37.7228439
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2021-01-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ken
pba__listing_agent_lastname__c, Yan
listing_agent_mls_id__c, 807001
ffd_listingagentname, Ken Yan
listing_agent_number__c, 166018033
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, PRIME
listing_office_name__c, Prime Metropolis Prop., Inc.
listing_office_number__c, 25594
pba__listingprice_pb__c, 1195000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4610591
lower_level__c, Garage,Street Entrance
mls_id__c, 515147
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-01-28
original_price__c, 1195000
overall_days_on_market__c, 152
parking_access__c, Tandem
parking_features__c, Attached,Garage Door Opener,Garage Facing Front
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-03-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1200
pba__propertytype__c, Single Family Residence
id, a0E1I00000TvuzCUAR
road_surface_type__c, Paved
roof__c, Shingle
room_type__c, Living Room
sale_date__c, 2021-03-10
sale_price__c, 1140000
selling_agent_mls_id__c, 805322
selling_agent_number__c, 166015212
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Mosaik Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 950
size__c, 950
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Jules
subdist__c, Ingleside
ffd_name, 254 Jules Avenue, San Francisco, CA, 94112
website_property_type__c, Single Family Home
window_features__c, Dual Pane Partial
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/530174704-1.jpg
ListingId, a0E1I00000TvuzCUAR
_yoast_indexnow_last_ping, 1735663899