meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='320574' 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, 2828 Bryant Street, San Francisco, CA, 94110
ffd_mls_id, 422696769
ffd_salesforce_id, a0E8W00000ZKKcJUAX
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 3
address2__c, 2828 Bryant Street, San Francisco, CA, 94110
pba__address_pb__c, 2828 Bryant Street, San Francisco, CA, 94110
agent_only_remarks__c, Offer date set for Monday, October 3rd 11am. Please contact the listing agents with any questions Tanya @ 415-531-6779 or Neil @ 510-388-2956. Disclosure package link: https://app.disclosures.io/link/2820-2830-Bryant-Street-y98l90fz www.BryantSt.com
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Edwardian
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tile;Low-Flow Toilet(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1926
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Neil H Bui
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-09-24T00:47:15.000+0000
days_on_market__c, 299
dom__c, 10
ffd_description_pb, Exquisite Mission District top floor 3 bedroom / 2 bathroom TIC Unit. All units in the building delivered vacant. Last on the market over 12 years ago, this unit checks all the boxes. Wonderful hillside views, recent updates with modern fixtures, turn key condition, large tranquil backyard with mature plants and impeccable stone and wood landscaping, garage parking, and ample storage. Owner will provide legal Tenancy in Common Agreement for execution at close of escrow.
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2023-07-13T17:50:11.000+0000
pba__latitude_pb__c, 37.749082
pba__latitude_property__c, 37.749082
laundry_features__c, Inside Area
listed_date__c, 2022-09-23
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tanya
pba__listing_agent_lastname__c, Dzhibrailova
listing_agent_mls_id__c, 804560
ffd_listingagentname, Tanya S Dzhibrailova
listing_agent_number__c, 183503881
listing_co_agent_mls_id__c, 817040
listing_co_agent_number__c, 1075948
listing_co_office_mls_id__c, NHBR
listing_co_office_name__c, NHB Real Estate, Inc.
listing_co_office_number__c, 28887
listing_office_mls_id__c, NHBR
listing_office_name__c, NHB Real Estate, Inc.
listing_office_number__c, 28887
pba__listingprice_pb__c, 1395000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.409095
mls_id__c, 422696769
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Low-Flow Toilet(s);Tile;Low-Flow Shower(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-09-23
original_price__c, 1395000
overall_days_on_market__c, -81349
parking_access__c, Independent
parking_features__c, EV Charging
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2022-10-03
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 945.76
pba__propertytype__c, Tenancy In Common
ListingId, a0E8W00000ZKKcJUAX
room_type__c, Living Room;Baths Other;Dining Room;Primary Bathroom;Primary Bedroom
sale_date__c, 2022-12-08
sale_price__c, 1395000
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector
selling_agent_mls_id__c, 804623
selling_agent_number__c, 191006143
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Global Living
pba__status__c, Closed
pba__totalarea_pb__c, 1475
size__c, 1475
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Bryant
subdist__c, The Mission
ffd_name, 2828 Bryant Street, San Francisco, CA, 94110
view__c, Hills
website_property_type__c, Tenancy In Common
pba__yearbuilt_pb__c, 1926
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530533377-1.jpg