meta_query='key:subdist__c;value:Yerba Buena|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218515' 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 #602, San Francisco, CA, 94105
ffd_mls_id, 421540772
ffd_salesforce_id, a0E1I00000USDNJUA5
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 18
address2__c, 69 Clementina Street #602, San Francisco, CA, 94105
pba__address_pb__c, 69 Clementina Street #602, 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-602?month=2021-04 3. Please send PEAD to [email protected] prior to showing 4. Disclosure Package: https://app.disclosures.io/link/69-Clementina-Street-602-gkyrjxh8 (5.) Escrow Officer: Nick Shanta @ First American Title, [email protected] 6. All COVID precautions to be strictly followed - visitors to supply own Personal Protective Equipment. www.69ClementinaUnits.com. Please Note - photos are virtually staged
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator;Wine Refrigerator
architectural_style__c, Modern/High Tech
bath_features__c, Shower Stall(s);Tile;Stone
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, 7
ffd_description_pb, Bright and airy with a large living and dining area with hardwood floors throughout is this single level condo. A fantastic gourmet kitchen with premium stainless appliances, wine storage and granite counters. The spacious bedrooms offer ample closet space. The primary bedroom is ensuite. 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, 498
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 69 Clementina Homeowners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
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, 899000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.69ClementinaUnits.com/mls
pba__longitude_pb__c, -122.396372
mls_id__c, 421540772
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub w/Shower Over;Tile;Stone
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, 899000
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-04-30
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 780.59
pba__propertytype__c, Condominium
id, a0E1I00000USDNJUA5
sale_date__c, 2021-06-04
sale_price__c, 925000
security_features__c, Security System Prewired
selling_agent_mls_id__c, MLSL5075091
selling_agent_number__c, 981226134
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Pacificwide Real Estate & Mortgage
pba__status__c, Closed
pba__totalarea_pb__c, 1185
size__c, 1185
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Clementina
subdist__c, Yerba Buena
ffd_name, 69 Clementina Street #602, San Francisco, CA, 94105
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/530225267-1.jpg
ListingId, a0E1I00000USDNJUA5