meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215821' 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, 713 York Street, San Francisco, CA, 94110
ffd_mls_id, 508907
ffd_salesforce_id, a0E1I00000TUwLAUA1
num_of_fireplaces__c, 0
num_of_rooms__c, 7
of_units__c, 0
address2__c, 713 York Street, San Francisco, CA, 94110
pba__address_pb__c, 713 York Street, San Francisco, CA, 94110
agent_only_remarks__c, Photos were pared down significantly at the request of buyers and floorplans removed. Email me if you need this for a comp. Legality of rooms on ground floor is is not known or represented by Seller or Agent; Buyer to investigate to their satisfaction.
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-11-11
ffd_createddate, 2020-10-30T10:46:40.000+0000
days_on_market__c, 993
dom__c, 14
ffd_description_pb, Location and lifestyle define this remodeled Stick Vicorian home. Indoor/outdoor entertaining + access to the coolest outdoor dining & hangouts in the City make this the choice for 2020 and beyond. The front of the home is occupied by an over-sized living room and convenient front entry hall. Flowing from the front hall, the open dining room and oversized chef's kitchen open straight onto the deck that leads to the rear garden through folding glass doors that slide entirely out of the way. The dining deck is just a few steps above the flagstone patio surrounded by beautifully planted beds with mature citrus trees. The upper floor also has two bedrooms with en suite full baths. Both baths were recently renovated with new penny tile floors, marble subway tile shower surrounds and high-end Delta fixtures. An open staircase leads downstairs to the laundry/mud room perfect for projects, a 3rd bedroom with en-suite bath that features its own entrance and the 2-car garage.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-01-25T15:39:04.000+0000
pba__latitude_pb__c, 37.759975
pba__latitude_property__c, 37.759975
listed_date__c, 2020-10-09
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jennifer
pba__listing_agent_lastname__c, Rosdail
listing_agent_mls_id__c, 803029
ffd_listingagentname, Jennifer Rosdail
listing_agent_number__c, 803029
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, KWRSF
listing_office_name__c, Keller Williams San Francisco
listing_office_number__c, 26158
pba__listingprice_pb__c, 1698000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.SunnyMission.com
pba__longitude_pb__c, -122.408671
pba__lotsize_pb__c, 0.06
lower_level__c, Bedroom(s)
mls_id__c, 508907
main_level__c, Bedroom(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-10-29
original_price__c, 1698000
overall_days_on_market__c, 162
parking__c, Garage
parking_features__c, Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-11-12
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1107.9
pba__propertytype__c, Single Family Residence
id, a0E1I00000TUwLAUA1
sale_date__c, 2020-12-11
sale_price__c, 1900049
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, 1715
size__c, 1715
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, York
subdist__c, The Mission
ffd_name, 713 York Street, San Francisco, CA, 94110
website_property_type__c, Single Family Home
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/373069-1.jpg
ListingId, a0E1I00000TUwLAUA1