meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214788' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15716
[post_author] => 4
[post_date] => 2018-11-02 19:54:31
[post_date_gmt] => 2018-11-02 19:54:31
[post_content] => Ground zero for gentrification arguments in almost every housing cycle. Flat streets, sunny weather, historical cultural institutions, and colorful street life. Welcome to the Mission, where hipsters zoom down Valencia on tomorrow's transport idea while humble housekeepers hustle hard with their heads down.
[post_title] => The Mission
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => the-mission
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 14:14:15
[post_modified_gmt] => 2024-03-19 21:14:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15716
[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, 1420 Alabama Street, San Francisco, CA, 94110
ffd_mls_id, 506024
ffd_salesforce_id, a0E1I00000THkbYUAT
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 1420 Alabama Street, San Francisco, CA, 94110
pba__address_pb__c, 1420 Alabama Street, San Francisco, CA, 94110
agent_only_remarks__c, Showings by appointment only. Send PEAD form prior to appointment per COVID-19 protocols. Please email Amelia to schedule appointment and for link to disclosures.io Email to: [email protected]. Thank you!
appliances__c, Dishwasher;Gas Range;Refrigerator;Freestanding Range
architectural_style__c, Edwardian
bath_features__c, Tub w/Shower Over;Split Bath
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1910
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Edward R Deleski
pba__contingentdate__c, 2020-09-25
ffd_createddate, 2020-09-17T19:46:24.000+0000
days_on_market__c, 1035
dom__c, 22
ffd_description_pb, Charming single-family home in the heart of the sunny Mission District offers the perfect floor plan and outdoor space for today's living. Inviting front porch and formal entry lead to a gracious main living level, featuring a double parlor living and family rooms, a bedroom or home office, full split bathroom, a spacious kitchen with a utility room, and a formal dining room with French doors opening to a deck and a deep landscaped garden for the ideal indoor-outdoor living experience. Upstairs offers three bedrooms with a full bathroom, whereas the lower level boasts a large garage with a workshop, laundry and ample space for possible development and expansion of your living space. This is an amazing location just a couple of blocks to the heart of 24th Street eateries, cafes, restaurants and shops, a number of parks and kids' playgrounds, a Rec & Parks community pool, and within close proximity to 24th and Mission Bart, and access to area freeways.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Decorative Only
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-25T15:34:35.000+0000
pba__latitude_pb__c, 37.749147
pba__latitude_property__c, 37.749147
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-09-14
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jean-Paul
pba__listing_agent_lastname__c, Samaha
listing_agent_mls_id__c, 804997
ffd_listingagentname, Jean-Paul Samaha
listing_agent_number__c, 166014752
listing_co_agent_mls_id__c, 807512
listing_co_agent_number__c, 1020319
listing_co_office_mls_id__c, VANG02
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 166013449
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 1695000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.410903
pba__lotsize_pb__c, 0.06
mls_id__c, 506024
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, 2
on_market_date__c, 2020-09-17
original_price__c, 1695000
overall_days_on_market__c, 148
parking__c, Attached,Garage
parking_features__c, Attached,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s)
pba__pendingdate__c, 2020-10-09
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 943.85
pba__propertytype__c, Single Family Residence
id, a0E1I00000THkbYUAT
sale_date__c, 2020-10-22
sale_price__c, 1765000
selling_agent_mls_id__c, 808886
selling_agent_name__c, Valentina Cabrera-Stagno
selling_agent_number__c, 1038244
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Cabrera-Stagno, Valentina
pba__status__c, Closed
pba__totalarea_pb__c, 1870
size__c, 1870
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Alabama
subdist__c, The Mission
ffd_name, 1420 Alabama Street, San Francisco, CA, 94110
transportation__c, 1 Block
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1910
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/370329-1.jpg
ListingId, a0E1I00000THkbYUAT