meta_query='key:subdist__c;value:Ingleside Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214013' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70658
[post_author] => 4
[post_date] => 2018-11-30 20:30:32
[post_date_gmt] => 2018-11-30 20:30:32
[post_content] => Ingleside is a lot more down-to-earth than some of its swankier neighbors to the north, 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 Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => ingleside-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2023-10-31 09:32:49
[post_modified_gmt] => 2023-10-31 16:32:49
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70658
[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, 54 Kempton Avenue, San Francisco, CA, 94132
ffd_mls_id, 503733
ffd_salesforce_id, a0E1I00000S12ldUAB
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 54 Kempton Avenue, San Francisco, CA, 94132
pba__address_pb__c, 54 Kempton Avenue, San Francisco, CA, 94132
agent_only_remarks__c, 3% to Selling Agent! Please call Mila Gelman to schedule showings. 415 867-6979. Great pride of ownership home. Showings by appointment with Covid 19 precautions. Escrow opened with Michelle Patterson at Frst American Title. Email agents for disclosures. Property video: https://youtu.be/z6RejQoP1go
appliances__c, Dishwasher;Gas Water Heater;Gas Range;Disposal;Refrigerator;Hood Over Range
bath_features__c, Shower Stall(s);Tub;Remodeled;Tile;Low-Flow Toilet(s);Skylight/Solar Tube;Radiant Heat;Low-Flow Shower(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1946
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Bernard Katzmann
pba__contingentdate__c, 2020-09-14
ffd_createddate, 2020-08-13T17:45:35.000+0000
days_on_market__c, 1070
dom__c, 41
ffd_description_pb, Wonderful remodeled 3BR, 2BA home on quiet cul-de-sac. Recently extensively renovated chef's kitchen and BA's. Exc attention to detail, gorgeous hardwood floors, designer lighting. Main level features entry foyer, bright, spacious living room with refinished hardwood flrs, woodburning fireplace w/ marble hearth. Spacious dining room with skylight. Remodeled eat-in kitchen w/ quartz counters, ample cabinets, stainless sink,Hansgrohe faucet, custom backsplash, stainless Bosch appliances incl 5-burner gas range, dishwasher, French door refrigerator. 2 large bedrooms both with large closets overlook the garden, . Remod main level bath with deep spa tub, rain shower, custom tile, heated floors, skylight. Lower level bedroom suite with sitting area, bath with oversized shower, custom tile. Large patio and landscaped garden, sprinkler system. Laundry, 1 car garage, storage. Exc location convenient to Lake Merced, SF State University, Stonestown, Westlake Village, MUNI, 101 and 280 freeways
district__c, SF District 3
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry;Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:31:03.000+0000
pba__latitude_pb__c, 37.7115983
pba__latitude_property__c, 37.7115983
laundry_features__c, Washer/Dryer Included
listed_date__c, 2020-06-09
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Michael
pba__listing_agent_lastname__c, Shaw
listing_agent_mls_id__c, 800323
ffd_listingagentname, Michael H Shaw
listing_agent_number__c, 800323
listing_co_agent_mls_id__c, 263622
listing_co_agent_number__c, 263622
listing_co_office_mls_id__c, VANG03
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 1228
listing_office_mls_id__c, VANG03
listing_office_name__c, Vanguard Properties
listing_office_number__c, 1228
pba__listingprice_pb__c, 1335000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.54kempton.com/
pba__longitude_pb__c, -122.4686395
pba__lotsize_pb__c, 0.06
lower_level__c, Bedroom(s),Full Bath(s),Master Bedroom
mls_id__c, 503733
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-08-13
original_price__c, 1335000
overall_days_on_market__c, 118
parking__c, Attached,Auto Door
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Patio(s)
pba__pendingdate__c, 2020-09-23
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 824.21
pba__propertytype__c, Single Family Residence
id, a0E1I00000S12ldUAB
roof__c, Tar/Gravel
sale_date__c, 2020-10-13
sale_price__c, 1280000
security_features__c, Smoke Detector
selling_agent_mls_id__c, MLSL5082585
selling_agent_number__c, 981348119
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Redfin
pba__status__c, Closed
pba__totalarea_pb__c, 1553
size__c, 1553
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Kempton
subdist__c, Ingleside Heights
ffd_name, 54 Kempton Avenue, San Francisco, CA, 94132
transportation__c, 1 Block
view__c, Garden/Greenbelt
website_property_type__c, Single Family Home
window_features__c, Window Coverings
pba__yearbuilt_pb__c, 1946
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/368250-1.jpg
ListingId, a0E1I00000S12ldUAB