meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214983' 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, 961 San Bruno Avenue, San Francisco, CA, 94110
ffd_mls_id, 505700
ffd_salesforce_id, a0E1I00000TTRVjUAP
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 961 San Bruno Avenue, San Francisco, CA, 94110
pba__address_pb__c, 961 San Bruno Avenue, San Francisco, CA, 94110
agent_only_remarks__c, Transparent pricing! Hurry & Buy-it-now! For viewings, please book appointments through Calendly (copy and paste following link into your web browser): https://calendly.com/sfdwell/charming-mission-home?month=2020-10 Please provide PEAD to confirm appointment prior to any showings and follow all COVID-19 protocol. Large garage w/expansion potential (check w/architect and City). Garage may accommodate 2 compact cars parked in tandem. Driveway may accommodate a 3rd, full-size car. Buyer should test parking to satisfy any concerns. Property website: missiondwell.com
architectural_style__c, Traditional
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1927
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-10-26T10:45:55.000+0000
days_on_market__c, 996
dom__c, 63
ffd_description_pb, $100k Price Reduction! Charming, move-in ready, light-filled home has a quaint & secluded backyard w/low-maintenance deck perfect for outdoor lounging, dining, & home workouts. The renovated kitchen boasts beautiful quartz counters and Northstar retro appliances. Period details throughout include original wood-burning fireplace & wainscoting. Both principal suite and second bedroom have views of the east-facing, private yard while the living area has west-facing vistas of gorgeous sunsets and surrounding hills. A large garage with Tesla wall car charger & plenty of storage round out this gem. You're just steps away from many exceptional outdoor dining options throughout the highly sought after Mission District. Standouts include Flour + Water, Farmhouse Kitchen, True Laurel, Universal Cafe, Spice Jar, to name a few. Freeway, 24th St BART, 22nd St Caltrain are all conveniently nearby. Enjoy the best of the Inner Mission - steps from Potrero Hill. Hurry, this won't last!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Wood Burning
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-01-25T15:35:23.000+0000
pba__latitude_pb__c, 37.7574335
pba__latitude_property__c, 37.7574335
listed_date__c, 2020-09-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Myrick
pba__listing_agent_lastname__c, Tantiado
listing_agent_mls_id__c, 807341
ffd_listingagentname, Myrick Tantiado
listing_agent_number__c, 1016143
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, SFDWELL
listing_office_name__c, SF DWELL
listing_office_number__c, 28517
pba__listingprice_pb__c, 1295000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/471061105
pba__longitude_pb__c, -122.4045391
pba__lotsize_pb__c, 0.04
mls_id__c, 505700
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2020-10-26
original_price__c, 1195000
overall_days_on_market__c, 318
parking__c, Garage
parking_features__c, Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s)
pba__pendingdate__c, 2020-12-28
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 989.3
pba__propertytype__c, Single Family Residence
id, a0E1I00000TTRVjUAP
sale_date__c, 2021-02-04
sale_price__c, 1295000
selling_agent_mls_id__c, 812657
selling_agent_number__c, 1057652
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Park North Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1309
size__c, 1309
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, San Bruno
subdist__c, The Mission
ffd_name, 961 San Bruno Avenue, San Francisco, CA, 94110
transportation__c, 1 Block
view__c, City Lights
website_property_type__c, Single Family Home
window_features__c, Dual Pane
pba__yearbuilt_pb__c, 1927
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/370871-1.jpg
ListingId, a0E1I00000TTRVjUAP