meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218491' 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, 2546 Folsom Street, San Francisco, CA, 94110
ffd_mls_id, 421541670
ffd_salesforce_id, a0E1I00000USCoOUAX
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 2
address2__c, 2546 Folsom Street, San Francisco, CA, 94110
pba__address_pb__c, 2546 Folsom Street, San Francisco, CA, 94110
agent_only_remarks__c, For showing requests, follow this link. Access instructions will be provided on your Calendly confirmation. https://calendly.com/paytonbinnings/2546-folsom-viewing All showings must comply with SFAR's most recent COVID-compliance guidelines. Refer to SFAR communications. HOA is pay-as-you-go, please refer to disclosure package for full breakdown. Home is a 50% TIC interest in the 2-unit building, which is eligible for lottery bypass. Parking is tandem w/ upstairs neighbor. Notes regarding parking are in the disclosures.
appliances__c, Dishwasher;Disposal;Hood Over Range;Built-In Gas Oven;Free Standing Refrigerator;Wine Refrigerator;Ice Maker
architectural_style__c, Edwardian
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tile;Double Sinks
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Payton R Stiewe
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-04-23T17:47:16.000+0000
days_on_market__c, 817
dom__c, 9
ffd_description_pb, Welcome to 2546 Folsom in SF's sunny & vibrant Mission District! This sprawling full-floor flat offers 3 huge bedrooms, 2.5 baths, 1-car parking, in-unit laundry, & a lovely garden. This quintessential home has been thoughtfully updated for modern-day living, offering an open, entertainment-style layout with kitchen, dining, & living rooms all adjacent. The main living space opens to the garden, the perfect place to relax outdoors and take advantage of the amazing microclimate. Recently renovated Chef's kitchen w/ stainless appliances including gas range, refrigerator, & built-in oven, all by Bosch. Chef's triangle layout w/ quartz counters, custom cabinets, tiled backsplash, warming drawers, bev/wine cooler, & breakfast bar. Bowers & Wilkins speakers, CAT6, Nest, and 2 wireless access points. Three very spacious bedrooms, including a primary bedroom with dual closets with built-in Elfa systems, & spa-like en-suite bath w/dual vanities & marble tiles. Tons of storage & A+ location!
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Decorative Only
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:50:32.000+0000
pba__latitude_pb__c, 37.756507
pba__latitude_property__c, 37.756507
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2021-03-09
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Arrian
pba__listing_agent_lastname__c, Binnings
listing_agent_mls_id__c, 806705
ffd_listingagentname, Arrian C Binnings
listing_agent_number__c, 166017483
listing_co_agent_mls_id__c, 802841
listing_co_agent_number__c, 802841
listing_co_office_mls_id__c, ARTEMIS
listing_co_office_name__c, Artemis Real Estate
listing_co_office_number__c, 28502
listing_office_mls_id__c, ARTEMIS
listing_office_name__c, Artemis Real Estate
listing_office_number__c, 28502
pba__listingprice_pb__c, 1495000
pba__listingtype__c, Sale
pba__listing_website__c, http://2546folsom.com
pba__longitude_pb__c, -122.414812
mls_id__c, 421541670
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub w/Shower Over;Tile
master_property__c, a0O1I000004VXZzUAO
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-04-23
original_price__c, 1495000
overall_days_on_market__c, 139
parking_access__c, Tandem
parking_features__c, Tandem Garage,Uncovered Parking Space
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2021-05-02
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 909.09
pba__propertytype__c, Tenancy In Common
id, a0E1I00000USCoOUAX
room_type__c, Kitchen;Living Room;Master Bathroom;Dining Room;Master Bedroom
sale_date__c, 2021-05-04
sale_price__c, 1800000
selling_agent_mls_id__c, 389338
selling_agent_number__c, 389338
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, 1980
size__c, 1980
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Folsom
subdist__c, The Mission
ffd_name, 2546 Folsom Street, San Francisco, CA, 94110
website_property_type__c, Tenancy In Common
window_features__c, Bay Window(s)
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/530224891-1.jpg
ListingId, a0E1I00000USCoOUAX