meta_query='key:subdist__c;value:Yerba Buena|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='383751' 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
(
)
)
_yoast_indexnow_last_ping, 1723496094
ffd_listing_title, 301 Mission Street #PH1, San Francisco, CA, 94105
ffd_mls_id, 423924497
ffd_salesforce_id, a0EUd000000I6tNMAS
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 419
address2__c, 301 Mission Street #PH1, San Francisco, CA, 94105
pba__address_pb__c, 301 Mission Street #PH1, San Francisco, CA, 94105
appliances__c, Dishwasher;Built-In Refrigerator;Gas Cook Top;Built-In Electric Oven
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2009
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Denise L Paulson
pba__contingentdate__c, 2024-07-20
cooling__c, Central
ffd_createddate, 2023-11-28T23:47:04.000+0000
days_on_market__c, 258
dom__c, 246
ffd_description_pb, Perched atop City Residences, the 11-story complement to Millennium Tower and host to most of the Millennium complex's superb amenities (concierge, club level which includes a private dining room and bar, movie theater, wine locker room, gym, pool, valet parking, and more), this penthouse has wonderful features. Expansive (over 1900 square feet) the condo features floor-to-ceiling windows, a large study that can become a second bedroom, professional grade appliances, and great top-floor privacy. The large master bath with dual sinks, soaking tub, and oversized shower compartment serves the spacious master bedroom. This penthouse is a treasure you must see to believe.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 2888
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-08-12T20:47:37.000+0000
pba__latitude_pb__c, 37.79077
pba__latitude_property__c, 37.79077
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2023-11-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Joseph
pba__listing_agent_lastname__c, Silva Gonsalves
listing_agent_mls_id__c, 814010
ffd_listingagentname, Joseph C Silva Gonsalves
listing_agent_number__c, 1063918
listing_co_agent_mls_id__c, 802017
listing_co_agent_number__c, 802017
listing_co_office_mls_id__c, COMP38
listing_co_office_name__c, Compass
listing_co_office_number__c, 27890
listing_office_mls_id__c, COMP38
listing_office_name__c, Compass
listing_office_number__c, 27890
pba__listingprice_pb__c, 1299000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.395754
mls_id__c, 423924497
master_property__c, a0O1I000001VhhvUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-11-28
original_price__c, 1659000
overall_days_on_market__c, -81780
parking_access__c, Side by Side
parking_features__c, Valet
parking_type__c, On Site - Unassigned (Condo Only)
pba__pendingdate__c, 2024-07-31
pba__pool_pb__c, 1
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-08-12T07:43:30.000+0000
price_per_square_foot__c, 640.04
pba__propertytype__c, Condominium
ListingId, a0EUd000000I6tNMAS
sale_date__c, 2024-08-09
sale_price__c, 1250000
security_features__c, Secured Access
selling_agent_mls_id__c, 802017
selling_agent_number__c, 802017
selling_co_agent_mls_id__c, 814010
selling_co_agent_number__c, 1063918
selling_co_office_mls_id__c, COMP38
selling_co_office_name__c, Compass
selling_co_office_number__c, 27890
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1953
size__c, 1953
spa__c, 1
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Mission
subdist__c, Yerba Buena
ffd_name, 301 Mission Street #PH1, San Francisco, CA, 94105
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2009
pba__postalcode_pb__c, 94105
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530707781-1.jpg