meta_query='key:subdist__c;value:Yerba Buena|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218516' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15736
[post_author] => 4
[post_date] => 2018-11-02 20:00:55
[post_date_gmt] => 2018-11-02 20:00:55
[post_content] => Cultural haven. Home to that high-rise. If any SF neighborhood comes remotely close to vaguely feeling like Manhattan, the hustle and bustle of Yerba Buena probably comes closest. Yes, you are south of Market. But this is Yerba Buena.
[post_title] => Yerba Buena
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => yerba-buena
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-17 08:01:07
[post_modified_gmt] => 2024-04-17 15:01:07
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15736
[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, 69 Clementina Street #801, San Francisco, CA, 94105
ffd_mls_id, 421540878
ffd_salesforce_id, a0E1I00000USDNKUA5
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 18
address2__c, 69 Clementina Street #801, San Francisco, CA, 94105
pba__address_pb__c, 69 Clementina Street #801, San Francisco, CA, 94105
agent_only_remarks__c, 1. Property is vacant and may be shown per COVID19 regulations. 2. Please sign up directly for an appointment through: https://calendly.com/mollie-poe-properties/69-clementina-unit-801?month=2021-04 3. Disclosure Package: https://app.disclosures.io/link/69-Clementina-Street-801-xi3nadh1 (4.) Escrow Officer: Nick Shanta @ First American Title, [email protected] 4. All COVID precautions to be strictly followed - visitors to supply own Personal Protective Equipment. www.69ClementinaUnits.com Please Note - these photos are virtually staged. Seller has agreed to credit $20k towards #801 future HOA fees.
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator;Wine Refrigerator
architectural_style__c, Modern/High Tech
bath_features__c, Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2006
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Declan J Hickey
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-04-23T22:47:14.000+0000
days_on_market__c, 817
dom__c, 74
ffd_description_pb, Incredible floor to ceiling windows adorn the large living space in this top floor, two level townhome - like condo. Functional kitchen with wine fridge, premium stainless steel appliances and a skylight. Private balcony off this top floor as well as a half bath. Downstairs you'll find two large bedrooms and two bathrooms. In unit W/D plus one car parking included. 69 Clementina is an 18 unit boutique elevator building designed by Ian Birchall & Associates. Nestled on a quiet street amongst all the action in downtown and South Beach, this building is steps away to great cafes, bars and restaurants and the Embarcadero, shops and parks! Easy access to public transportation, 101, 280, the Bay Bridge as well as walking distance to Bart and Caltrain. Elegant and contemporary, this urban unit offers a fantastic platform from which to enjoy all the amazing offerings of San Francisco!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Insurance on Structure,Maintenance Grounds,Sewer,Trash,Water
pba__hoafees__c, 499
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 69 Clementina Homeowners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
interior_features__c, Skylight Tube
ffd_lastmodifieddate, 2022-01-25T15:50:42.000+0000
pba__latitude_pb__c, 37.786413
pba__latitude_property__c, 37.786413
laundry_features__c, Washer Included;Dryer Included;Stacked Only
listed_date__c, 2021-04-20
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Mollie
pba__listing_agent_lastname__c, Poe
listing_agent_mls_id__c, 802851
ffd_listingagentname, Mollie W Poe
listing_agent_number__c, 802851
listing_co_agent_mls_id__c, 808252
listing_co_agent_number__c, 1032461
listing_co_office_mls_id__c, INDIGO
listing_co_office_name__c, Indigo Real Estate
listing_co_office_number__c, 28648
listing_office_mls_id__c, INDIGO
listing_office_name__c, Indigo Real Estate
listing_office_number__c, 28648
pba__listingprice_pb__c, 1049000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.396372
lower_level__c, Bedroom(s),Full Bath(s),Master Bedroom
mls_id__c, 421540878
main_level__c, Partial Bath(s);Kitchen;Living Room
master_bathroom_features__c, Tub w/Shower Over;Tile
master_property__c, a0O1I000001VhqtUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-04-23
original_price__c, 1049000
overall_days_on_market__c, 88
parking_access__c, Independent
parking_features__c, Assigned
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2021-07-06
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 812.08
pba__propertytype__c, Condominium
id, a0E1I00000USDNKUA5
sale_date__c, 2021-07-15
sale_price__c, 968000
security_features__c, Security System Prewired
selling_agent_mls_id__c, 804859
selling_agent_number__c, 166014556
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 1192
size__c, 1192
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Clementina
subdist__c, Yerba Buena
ffd_name, 69 Clementina Street #801, San Francisco, CA, 94105
view__c, San Francisco
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2006
pba__postalcode_pb__c, 94105
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530225278-1.jpg
ListingId, a0E1I00000USDNKUA5