meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='338532' 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, 2914 Folsom Street, San Francisco, CA, 94110
ffd_mls_id, 423909385
ffd_salesforce_id, a0E8W00000dSVpDUAW
num_of_fireplaces__c, 2
num_of_rooms__c, 11
of_units__c, 0
address2__c, 2914 Folsom Street, San Francisco, CA, 94110
pba__address_pb__c, 2914 Folsom Street, San Francisco, CA, 94110
agent_only_remarks__c, Offer date confirmed - Wed. Sept. 27th @ 11am. Please note we are requesting 48-hour response time - see DP instructions in package. www.2914Folsom.com, Matterport virtual tour on website for front and rear buildings. 1st time on market in decades-Escrow opened with Chicago Title-Michael Yip Escrow #3552002292. Contact listing agents for any questions. Disclosures available upon request.
appliances__c, Dishwasher;Hood Over Range;Tankless Water Heater;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Contemporary;Victorian
bath_features__c, Shower Stall(s);Tile
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Callista C Shepherd
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-09-15T10:47:55.000+0000
days_on_market__c, 5
dom__c, 5
ffd_description_pb, New on the market - Not one to miss! Located on the west side of Folsom just south of 25th street in the vibrant and trendy Inner Mission district, this vintage Victorian home is one of seven single-family homes designed in the early Italianate styles (cc.1875) that have been referred to as The Folsom Ladies''. A landscaped front yard featuring mature boxwoods, olive and camelia plantings welcomes you into a formal entry foyer opening into an east facing front parlor with custom cabinetry and fireplace, and an adjoining gracious sunny formal dining room with outlooks to the sun-drenched rear garden. An updated kitchen features stainless appliances including a Wolf 6-burner range with Cavalier hood and warming tray, Bosch dishwasher, custom laminated cabinetry with ample storage and composite counters - perfect for the home chef. A spacious sunroom off the kitchen with laundry and closet provides direct access to a private landscaped rear yard with brick patio, built-in Hastybake charcoal grill with adjacent stainless counter with a custom caja china roaster underneath. Delight in the sun drenched private garden with mature plantings including boxwood, hydrangea, topiary ball, rose bush canes, a couple citrus trees and cannas - a haven for guest entertainment.
district__c, SF District 9
entry_level__c, 0
exterior_features__c, BBQ Built-In
external_listing__c, 1
fencing__c, Back Yard;Wood
fireplace_features__c, Living Room;Decorative Only;Dining Room
pba__floortype_pb__c, Laminate;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Natural Gas
ffd_lastmodifieddate, 2023-09-21T00:46:43.000+0000
pba__latitude_pb__c, 37.750569
pba__latitude_property__c, 37.750569
laundry_features__c, Inside Room;Washer/Dryer Stacked Included;Washer Included;Dryer Included
listed_date__c, 2023-07-10
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ric
pba__listing_agent_lastname__c, Rocchiccioli
listing_agent_mls_id__c, 284109
ffd_listingagentname, RicRoc Rocchiccioli
listing_agent_number__c, 284109
listing_co_agent_mls_id__c, 807044
listing_co_agent_number__c, 166018105
listing_co_office_mls_id__c, COMP7
listing_co_office_name__c, Compass
listing_co_office_number__c, 28751
listing_office_mls_id__c, COMP7
listing_office_name__c, Compass
listing_office_number__c, 28751
pba__listingprice_pb__c, 1895000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=spE45KQeTe6&brand=0
pba__longitude_pb__c, -122.414237
mls_id__c, 423909385
main_level__c, Full Bath(s);Kitchen;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Tub w/Shower Over;Window
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-09-15
open_house_end__c, 2023-09-20T18:00:00.000+0000
open_house_start__c, 2023-09-20T16:00:00.000+0000
original_price__c, 1895000
overall_days_on_market__c, -81706
parking_access__c, Independent
parking_features__c, Detached,Garage Door Opener,Garage Facing Rear,Interior Access,Side-by-Side
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, 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, 865.69
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000dSVpDUAW
road_surface_type__c, Asphalt
roof__c, Composition;Shingle;Flat
room_type__c, Office;Kitchen;Living Room;Baths Other;Dining Room;Family Room;Wine Storage Area;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
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, 2189
size__c, 2189
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Folsom
subdist__c, The Mission
ffd_name, 2914 Folsom Street, San Francisco, CA, 94110
website_property_type__c, Single Family Home
window_features__c, Window Coverings
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/530676516-1.jpg