meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='381824' 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
(
)
)
_yoast_indexnow_last_ping, 1720608947
ffd_listing_title, 3241 21st Street, San Francisco, CA, 94110
ffd_mls_id, 424029829
ffd_salesforce_id, a0EUd000002FZYzMAO
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 2
address2__c, 3241 21st Street, San Francisco, CA, 94110
pba__address_pb__c, 3241 21st Street, San Francisco, CA, 94110
agent_only_remarks__c, Escrow opened with Heather Shiffer @ First American Title Co. All buyers to use the most current SFAR contract. Buyers advised to independently verify accuracy of all information provided. Please Call/text/email Dana Cohen @ (415) 305-3539, [email protected] or Priya Agrawal @ (617) 513-7795, [email protected] with any questions.
appliances__c, Dishwasher;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1890
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-06-07T19:48:21.000+0000
days_on_market__c, 33
dom__c, 14
ffd_description_pb, Nestled on a prime block between the vibrant Valencia and Mission corridors, this bright and airy top-floor home boasts a striking Victorian facade. This remarkable condo showcases soaring ceilings, huge windows & a skylight, which bathe the home in sunshine. Meticulously maintained details abound, including beautiful softwood floors, picture rails and moldings, built-in cabinetry, and pocket doors. The expansive living room includes a gorgeous bay window with treetop views, an elegant stone mantel, and built-in shelving. An ample dining room, with charming built-in cabinetry, leads into the airy kitchen with abundant storage, a pantry nook, and an eat-in breakfast area. Large doors through the laundry room with custom millwork and stacked washer/dryer open to a walkout deck. The pergola and custom bench seating here are perfect for barbecuing and enjoying the warm Mission sunshine while overlooking the sunny shared yard. Three bedrooms and two full baths, incl. a primary bedroom w/ an ensuite bathroom, complete the home. A separate lower-level bonus room with wet bar & wine fridge offers an ideal WFH space. Amenities incl. two-car parking with EV charging capability. A+ location in a thriving neighborhood steps to world-class dining & nightlife, and many public transit options.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 475
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2024-07-10T10:49:23.000+0000
pba__latitude_pb__c, 37.756775
pba__latitude_property__c, 37.756775
laundry_features__c, Inside Room;Washer/Dryer Stacked Included;Cabinets
listed_date__c, 2024-06-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Priya
pba__listing_agent_lastname__c, Agrawal
listing_agent_mls_id__c, 810564
ffd_listingagentname, Priya Agrawal
listing_agent_number__c, 1047032
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, RIVET
listing_office_name__c, Rivet Real Estate
listing_office_number__c, 28789
pba__listingprice_pb__c, 1450000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.MissionVictorian.com
pba__longitude_pb__c, -122.419713
mls_id__c, 424029829
master_property__c, a0OUd0000087DIoMAM
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-06-07
original_price__c, 1450000
overall_days_on_market__c, -81972
parking_access__c, Independent
parking_features__c, Enclosed,Garage Door Opener
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2024-06-21
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-07-09T16:31:42.000+0000
price_per_square_foot__c, 986.56
pba__propertytype__c, Condominium
ListingId, a0EUd000002FZYzMAO
sale_date__c, 2024-07-09
sale_price__c, 1615000
selling_agent_mls_id__c, 808937
selling_agent_number__c, 1038623
selling_co_agent_mls_id__c, 808971
selling_co_agent_number__c, 1038794
selling_co_office_mls_id__c, COMP
selling_co_office_name__c, Compass
selling_co_office_number__c, 26293
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1637
size__c, 1637
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 21st
subdist__c, The Mission
ffd_name, 3241 21st Street, San Francisco, CA, 94110
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1890
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530791403-1.jpg