meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='345980' 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, 1700698389
ffd_listing_title, 1875 Mission Street #308, San Francisco, CA, 94103
ffd_mls_id, 423911455
ffd_salesforce_id, a0E8W00000dTgXdUAK
num_of_fireplaces__c, 0
num_of_rooms__c, 3
of_units__c, 39
address2__c, 1875 Mission Street #308, San Francisco, CA, 94103
pba__address_pb__c, 1875 Mission Street #308, San Francisco, CA, 94103
agent_only_remarks__c, For private showings, call Kate Stephenson at 415.370.6531. Pre-escrow opened with Michael Gaffney Fidelity National Title.
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 2014
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Kate Stephenson
pba__contingentdate__c, 2023-10-18
cooling__c, Room Air,Other
ffd_createddate, 2023-09-22T16:46:54.000+0000
days_on_market__c, 61
dom__c, 45
ffd_description_pb, Transparent Pricing, come see this weekend! Set in the heart of the vibrant Mission District in a modern boutique condo building showcasing the work of renowned San Francisco architect Stanley Saitowitz, and chic designer Rusty Wadatz, with a luxurious roof top with sparkling city views, a heated pool, lounge area and a dog run (all included in the HOA with high-speed internet). Residence 308 is a beautiful modern light-filled condo which boasts high-end design features for comfortable city living. The unit, which has been freshly painted throughout, includes wide plank oak floors with Nest controlled radian heat and an open kitchen with custom cabinetry for ample storage in addition to a Bertazzoni range, Bosch Dishwasher, Liebherr fridge, quartz countertops, and elegant gold-flecked glass backsplash. Conveniently located near trendy shopping, restaurants, great nightlife, tech shuttles, and 16th BART station. One of SF's most vibrant neighborhoods just 1 block off Valencia. 97 Walk Score, 100 Transit, 99 Bike. Perfect city place to call home. AC is currently being added to all units.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
hoa_fee_includes__c, Common Areas,Elevator,Homeowners Insurance,Internet,Management,Pool,Trash
pba__hoafees__c, 640
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 1875 Mission Street Owners' Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2023-11-22T23:47:06.000+0000
pba__latitude_pb__c, 37.767101
pba__latitude_property__c, 37.767101
listed_date__c, 2023-09-21
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Trecia
pba__listing_agent_lastname__c, Knapp
listing_agent_mls_id__c, 803964
ffd_listingagentname, Trecia Knapp
listing_agent_number__c, 166013343
listing_co_agent_mls_id__c, 811268
listing_co_agent_number__c, 1050714
listing_co_office_mls_id__c, STHB4
listing_co_office_name__c, Sotheby's International Realty
listing_co_office_number__c, 28397
listing_office_mls_id__c, STHB4
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 28397
pba__listingprice_pb__c, 575000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.419446
mls_id__c, 423911455
master_property__c, a0O1I000001VhmLUAS
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2023-09-22
original_price__c, 649000
overall_days_on_market__c, -81713
pba__pendingdate__c, 2023-11-06
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 922.95
pba__propertytype__c, Condominium
ListingId, a0E8W00000dTgXdUAK
sale_date__c, 2023-11-20
sale_price__c, 575000
selling_agent_mls_id__c, 804251
selling_agent_number__c, 166013752
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 623
size__c, 623
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Mission
subdist__c, The Mission
ffd_name, 1875 Mission Street #308, San Francisco, CA, 94103
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2014
pba__postalcode_pb__c, 94103
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530681404-1.jpg