meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='374206' 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, 1710586618
ffd_listing_title, 2170 Harrison Street #6, San Francisco, CA, 94110
ffd_mls_id, 424006573
ffd_salesforce_id, a0EUd00000158xHMAQ
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 8
address2__c, 2170 Harrison Street #6, San Francisco, CA, 94110
pba__address_pb__c, 2170 Harrison Street #6, San Francisco, CA, 94110
agent_only_remarks__c, Please DO NOT text for showings. Showing instructions can be found here: https://calendly.com/2170harrisonst6/showings Please review disclosures: https://app.glide.com/share/4pXPHPRNpKyRp9L5GfmcRI/ Showings are available from 8am-7pm and are limited to 30 minutes. Escrow is opened with [email protected]. All buyers to use the most current 8-page SFAR contract. If needed, one will be provided. *All info herein is not guaranteed. Prospective purchasers are advised to independently verify accuracy and to review any disclosure information before submitting offers.*
appliances__c, Dishwasher;Gas Water Heater;Microwave;Disposal;Built-In Gas Range;Free Standing Refrigerator
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1997
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Yesenia Rogers
pba__contingentdate__c, 2024-02-19
cooling__c, Ceiling Fan(s)
ffd_createddate, 2024-02-09T01:47:06.000+0000
days_on_market__c, 37
dom__c, 11
ffd_description_pb, An architect designed top-floor, end-unit loft, with a private rooftop deck in the Inner Mission. 1-bed, 1.5-bath with a bonus room, live/work space, an ideal escape from city living with all the essentials at your doorstep. The open-concept kitchen/living area features double-height ceilings and floor-to-ceiling windows. Custom details include leather tile walls and unique repurposed light fixtures. The kitchen shines with quartz countertops and stainless steel appliances. A versatile bonus room awaits your personal touch, ideal as a guest bedroom or an office. Retreat upstairs to the primary ensuite bedroom with a luxurious double shower. The pinnacle of the home is the exclusive rooftop deck, with panoramic city views. Utmost convenience with a Walkscore of 99, dedicated parking, and reasonable HOA dues. Near BART, 101, and local favorites like Flour + Water, True Laurel, Trick Dog, and Gus's Market at the corner. Embrace the energy of San Francisco.
district__c, SF District 9
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
hoa_fee_includes__c, Common Areas,Insurance on Structure,Maintenance Exterior,Management,Trash,Water
pba__hoafees__c, 585
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 2170 Harrison Street Lofts Homeowners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Wall Furnace
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2024-03-16T10:46:59.000+0000
pba__latitude_pb__c, 37.762556
pba__latitude_property__c, 37.762556
laundry_features__c, Laundry Closet;Washer Included;Dryer Included
listed_date__c, 2024-02-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ruth
pba__listing_agent_lastname__c, Krishnan
listing_agent_mls_id__c, 400593
ffd_listingagentname, Ruth Krishnan
listing_agent_number__c, 1019790
listing_co_agent_mls_id__c, 813900
listing_co_agent_number__c, 1063314
listing_co_office_mls_id__c, COMP2
listing_co_office_name__c, Compass
listing_co_office_number__c, 27341
listing_office_mls_id__c, COMP41
listing_office_name__c, Compass
listing_office_number__c, 27887
pba__listingprice_pb__c, 1095000
pba__listingtype__c, Sale
pba__listing_website__c, https://ruthkrishnan.com/property-listings/2170-harrison-st-6-inner-mission/
pba__longitude_pb__c, -122.4132098
mls_id__c, 424006573
main_level__c, Partial Bath(s);Kitchen;Living Room
master_bathroom_features__c, Multiple Shower Heads
master_property__c, a0O1I000004VY43UAG
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-02-08
original_price__c, 1095000
overall_days_on_market__c, -81852
parking_access__c, Side by Side
parking_features__c, Assigned,Attached,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Roof Deck
pba__pendingdate__c, 2024-02-19
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-03-15T13:21:09.000+0000
price_per_square_foot__c, 928.32
pba__propertytype__c, Condominium
ListingId, a0EUd00000158xHMAQ
room_type__c, Bonus Room;Loft;Living Room;Primary Bedroom
sale_date__c, 2024-03-15
sale_price__c, 1075000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 811632
selling_agent_number__c, 1052818
selling_co_agent_mls_id__c, 816156
selling_co_agent_number__c, 1075140
selling_co_office_mls_id__c, COMP12
selling_co_office_name__c, Compass
selling_co_office_number__c, 28739
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1158
size__c, 1158
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Harrison
subdist__c, The Mission
ffd_name, 2170 Harrison Street #6, San Francisco, CA, 94110
view__c, City;Sutro Tower
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1997
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530729602-1.jpg