meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='376325' 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, 1714733960
ffd_listing_title, 555 Bartlett Street #306, San Francisco, CA, 94110
ffd_mls_id, 424025617
ffd_salesforce_id, a0EUd000001nVTYMA2
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 63
address2__c, 555 Bartlett Street #306, San Francisco, CA, 94110
pba__address_pb__c, 555 Bartlett Street #306, San Francisco, CA, 94110
agent_only_remarks__c, 5% down loans with no MI available for the building. This was originally a model-unit and shows beautifully. Motivated Seller and great Price - Seller bought it at $1,175,000 and selling at 25% loss. Lowest price 2-bedroom unit in the building since 2011. Comp: Neighbor's unit at 308 (identical) sold in Nov 2023 for $900,000. Please keep escrow with Michael Yip at Chicago Title. Easy to show, please text or call Saba 415-316-3286 for showing instructions. Please call Saba for questions regarding the unit and offers.
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2010
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-04-20T15:46:24.000+0000
days_on_market__c, 13
dom__c, 13
ffd_description_pb, 5% down with no mortgage insurance available from Citi Bank!! Located in the heart of San Francisco, this beautiful condo embodies contemporary living at its finest. Originally the model unit, the upgrades in this condo are apparent with custom closets in both bedrooms, gleaming oak flooring and a high-end appliance package with quiet closing drawers, designer tile and stone surface counters plus an in-unit W/D, among other desirable features. Both of the generously sized bedrooms offer ample closet space and breathtaking views extending to the picturesque Bernal Heights and beyond. 555 Bartlett stands as a testament to luxurious condominium living, offering a peaceful common roof deck for relaxation and enjoyment. This unit includes a dedicated parking space plus extra storage within the building. Conveniently located close to BART, 280 & 101 freeways, The condo is a 2 minute walk to the 24th Street BART station and an easy 20 minute ride to downtown or SFO. Walkable to La Taqueria, Tartine Bakery, Flour + Water, Foreign Cinema, and Delfina. This place is a must-see!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__hoafees__c, 692
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_monthly_parking_fees__c, 1
ffd_lastmodifieddate, 2024-05-03T10:47:17.000+0000
pba__latitude_pb__c, 37.748497
pba__latitude_property__c, 37.748497
listed_date__c, 2024-04-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Saba
pba__listing_agent_lastname__c, Shoaeioskouei
listing_agent_mls_id__c, 810732
ffd_listingagentname, Saba Shoaeioskouei
listing_agent_number__c, 1047664
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP29
listing_office_name__c, Compass
listing_office_number__c, 27895
pba__listingprice_pb__c, 895000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.418662
mls_id__c, 424025617
master_property__c, a0O1I000001VhnXUAS
monthly_parking_fees__c, 74
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-04-20
open_house_end__c, 2024-05-04T13:30:00.000+0000
open_house_start__c, 2024-05-04T11:00:00.000+0000
original_price__c, 895000
overall_days_on_market__c, -81924
parking_access__c, Side by Side
parking_features__c, Assigned,Attached,Garage Door Opener,Interior Access
parking_type__c, On Site - Assigned (Condo Only)
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, 958.24
pba__propertytype__c, Condominium
ListingId, a0EUd000001nVTYMA2
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, 934
size__c, 934
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Bartlett
subdist__c, The Mission
ffd_name, 555 Bartlett Street #306, San Francisco, CA, 94110
view__c, City;Hills
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2010
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530764664-1.jpg