meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217961' 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, 876 Potrero Avenue, San Francisco, CA, 94110
ffd_mls_id, 421532825
ffd_salesforce_id, a0E1I00000TxKiXUAV
num_of_fireplaces__c, 1
num_of_rooms__c, 3
of_units__c, 2
address2__c, 876 Potrero Avenue, San Francisco, CA, 94110
pba__address_pb__c, 876 Potrero Avenue, San Francisco, CA, 94110
agent_only_remarks__c, Please send PEAD to confirm showing appointments. Backyard access belongs to 2nd unit. Garage belongs to 2nd unit.
appliances__c, Dishwasher;Microwave;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator;Ice Maker
architectural_style__c, Contemporary;Victorian;Traditional
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-03-27T19:29:10.000+0000
days_on_market__c, 844
dom__c, 57
ffd_description_pb, Charming Inner Mission home awaits new owners. This tastefully update house-like condo preserves it's original 1900's Victorian accents and charm while providing the daily comforts of modern luxurious living. Sun-filled home features soaring ceilings throughout, fresh paint, hardwood floors, updated kitchen with stainless steel appliances, dual pain windows, updated master bath. Open floor plan concept with an abundance of storage makes this condo feel like a house. The spacious master bedroom has a large private patio deck overlooking the backyard below. Just steps to restaurants, cafes, Wholefoods, retail, the hospital and easy access to the 101 and 280. This home has it all!
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk,Shared Driveway
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Back Yard;Fenced
fireplace_features__c, Living Room;Wood Burning;Other
pba__floortype_pb__c, Wood
pba__hoafees__c, 300
pba__hoafrequency_pb__c, See Remarks
hoa_name__c, 874 & 876 Potrero Owners
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-01-25T15:48:21.000+0000
pba__latitude_pb__c, 37.758169
pba__latitude_property__c, 37.758169
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2021-03-27
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Pablo
pba__listing_agent_lastname__c, Cela
listing_agent_mls_id__c, 812271
ffd_listingagentname, Pablo M Cela
listing_agent_number__c, 1055926
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, SKYBOX
listing_office_name__c, Skybox Realty
listing_office_number__c, 191002105
pba__listingprice_pb__c, 890000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.407173
mls_id__c, 421532825
master_bathroom_features__c, Tub w/Shower Over;Granite
master_property__c, a0O1I00000COKC0UAP
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2021-03-27
original_price__c, 920000
overall_days_on_market__c, 122
parking_features__c, Other
patio_and_porch_features__c, Uncovered Deck;Uncovered Patio
pba__pendingdate__c, 2021-05-23
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1000
pba__propertytype__c, Condominium
id, a0E1I00000TxKiXUAV
sale_date__c, 2021-06-22
sale_price__c, 850000
security_features__c, Security Fence
selling_agent_mls_id__c, 815319
selling_agent_number__c, 1072193
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 850
size__c, 850
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Potrero
subdist__c, The Mission
ffd_name, 876 Potrero Avenue, San Francisco, CA, 94110
website_property_type__c, Condominium
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530207818-1.jpg
ListingId, a0E1I00000TxKiXUAV