meta_query='key:subdist__c;value:Ingleside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212687' 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-04-09 11:47:15
[post_modified_gmt] => 2024-04-09 18:47:15
[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, 4 Lee Avenue, San Francisco, CA, 94112
ffd_mls_id, 499313
ffd_salesforce_id, a0E1I00000SKbRfUAL
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 0
address2__c, 4 Lee Avenue, San Francisco, CA, 94112
pba__address_pb__c, 4 Lee Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Pending, No more showings. View Virtual Video first. If further interest, Agent & Buyer(s) sign required (PEAD) form. Email [email protected] . Return Signed form and email or call/text BUD 408-710-4205 for showing time and lockbox location. Home is vacant so we cannot wipe down as stated in PEAD 4E7. Buyer to wipe touched surfaces before leaving. Home, Roof, Pest/termite inspection complete, Disclosures ready. Will be in escrow quick. Pre-escrow open prefer to use Old Republic Title, Amy Freitas, this is a trust sale, NO Court Approval Needed. Prefer C.A.R. forms used with SFAR required forms.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator
architectural_style__c, Traditional
bath_features__c, Tub w/Shower Over;Remodeled;Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1941
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-06-12T14:45:38.000+0000
days_on_market__c, 1132
dom__c, 7
ffd_description_pb, Stunning Renovated Ingleside Home! This single family home has been thoughtfully renovated to fit modern day needs, turnkey ready for the next few generations! New modern kitchen, new cabinetry, New Marble counter tops, stainless appliances, dining area, 2 Bedrooms, Bonus area, Large Family room area with expansion or in-law area possibilities, 1.5 bathrooms. Some windows new, Roof recently replaced, Nice backyard area and Deck. Small basement storage area. Walking distance to Whole Foods, Philz Coffee, eateries & other shops on Ocean Ave, BART station, MUNI buses, parks and many more. Fast access to HWY 280 & 101. This is not a must see, this is a must have!
district__c, SF District 3
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room;Wood Burning;Brick
pba__floortype_pb__c, Carpet;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-25T15:24:54.000+0000
pba__latitude_pb__c, 37.718268
pba__latitude_property__c, 37.718268
laundry_features__c, In Garage;Hookups Only
listed_date__c, 2020-02-23
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Harold
pba__listing_agent_lastname__c, Meacham
listing_agent_mls_id__c, 810241
ffd_listingagentname, Bud Meacham
listing_agent_number__c, 1045141
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, DECOR1
listing_office_name__c, Renovation Realty
listing_office_number__c, 25679
pba__listingprice_pb__c, 1088000
pba__listingtype__c, Sale
pba__listing_website__c, https://4LeeAve94112mls.f8re.com/
pba__longitude_pb__c, -122.453795
pba__lotsize_pb__c, 0.06
mls_id__c, 499313
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-06-12
original_price__c, 1088000
overall_days_on_market__c, 164
parking__c, Attached,Garage,Auto Door
parking_access__c, Tandem
parking_features__c, Attached,Garage Door Opener,Tandem Garage,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s);Patio(s)
pba__pendingdate__c, 2020-06-19
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 748.85
pba__propertytype__c, Single Family Residence
id, a0E1I00000SKbRfUAL
roof__c, Bitumen;Shingle
room_type__c, Storage;Den
sale_date__c, 2020-07-21
sale_price__c, 1140500
security_features__c, Smoke Detector
selling_agent_mls_id__c, 803117
selling_agent_name__c, Danielle H. Lazier
selling_agent_number__c, 803117
selling_co_agent_mls_id__c, 809927
selling_co_agent_name__c, Joshua Ortiz
selling_co_agent_number__c, 1044191
selling_co_office_mls_id__c, COMP2
selling_co_office_name__c, Compass
selling_co_office_number__c, 27341
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1523
size__c, 1523
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Lee
subdist__c, Ingleside
ffd_name, 4 Lee Avenue, San Francisco, CA, 94112
view__c, City Lights;Partial
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1941
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/364658-1.jpg
ListingId, a0E1I00000SKbRfUAL
_wp_old_slug, 4-lee-avenue-san-francisco-ca-94112-2