meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='338561' 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] => 2023-06-23 10:52:55
[post_modified_gmt] => 2023-06-23 17:52:55
[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, 1214 York Street, San Francisco, CA, 94110
ffd_mls_id, 423908677
ffd_salesforce_id, a0E8W00000dSWWPUA4
num_of_fireplaces__c, 0
num_of_rooms__c, 7
of_units__c, 0
address2__c, 1214 York Street, San Francisco, CA, 94110
pba__address_pb__c, 1214 York Street, San Francisco, CA, 94110
agent_only_remarks__c, SQFT: There are multiple square footage numbers from a variety of resources. Cottage and Garden Level Bonus Room is included in the Square Footage. Buyers & buyer's agents shall conduct their own research into the total sq footage and legality of room downstairs.
appliances__c, Dishwasher;Hood Over Range;Built-In Gas Range;Built-In Gas Oven;Free Standing Refrigerator
architectural_style__c, Victorian;Cottage
bath_features__c, Tub w/Shower Over;Tile;Low-Flow Toilet(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1912
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-09-15T16:46:26.000+0000
days_on_market__c, 0
dom__c, 0
ffd_description_pb, Vibrant 3BR Inner Mission Victorian Retreat with Garden Cottage and the sunniest yard -- steps to everything! Period details blend with modern amenities in a bright, flexible floor plan. Main level has LR/DR with soaring ceilings and hardwood floors, eat-in bar area, remodelled kitchen with deco tile floors and Thermador and Bosch appliances, a stylish BA, and 2 bedrooms separated from the primary with a lovely garden window seat. Step outside to your cozy deck, with stairs to a tranquil yard with colorful plants (bougainvillea, magnolia, lavender+) and fruit trees, wrap-around bench seating, outdoor shower, large faux-grassy play area and tiled patio, all perfect for entertaining and California living. The detached, charming cottage is at the back of the lot with a loft, LR, BA and Eat-in-kitchen, ideal for guests, in-laws or au pair quarters. BONUS: many usable spaces at garden level, including informal media/LR, abundant storage/flex space, a lounge/yoga area, laundry room and 1-car garage with workbench. Centrally located on a great block of York, steps to cafes', restaurants, boutiques and parks. Easy access to fwy, Muni and BART. A true urban retreat - come experience for yourself!
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway
electric__c, 220 Volts
entry_level__c, 0
exterior_features__c, Uncovered Courtyard
external_listing__c, 1
fencing__c, Fenced
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Wet Bar
ffd_lastmodifieddate, 2023-09-15T22:46:30.000+0000
pba__latitude_pb__c, 37.75236
pba__latitude_property__c, 37.75236
laundry_features__c, In Garage;Inside Area
listed_date__c, 2023-08-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tiffany
pba__listing_agent_lastname__c, Hickenbottom
listing_agent_mls_id__c, 807832
ffd_listingagentname, Tiffany Hickenbottom
listing_agent_number__c, 1027421
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP2
listing_office_name__c, Compass
listing_office_number__c, 27341
pba__listingprice_pb__c, 1795000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.408421
lower_level__c, Family Room,Full Bath(s),Garage,Kitchen,Living Room,Loft,Retreat,Street Entrance
mls_id__c, 423908677
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-09-15
open_house_end__c, 2023-09-16T14:00:00.000+0000
open_house_start__c, 2023-09-16T12:00:00.000+0000
original_price__c, 1795000
overall_days_on_market__c, -81706
parking_access__c, Independent
parking_features__c, Attached
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck;Uncovered Patio
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1017
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000dSWWPUA4
room_type__c, Storage;Bonus Room;Kitchen;Living Room;Dining Room;Great Room;Workshop;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 1765
size__c, 1765
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, York
subdist__c, The Mission
ffd_name, 1214 York Street, San Francisco, CA, 94110
website_property_type__c, Single Family Home
window_features__c, Window Coverings;Bay Window(s);Dual Pane Partial
pba__yearbuilt_pb__c, 1912
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530675398-1.jpg