meta_query='key:subdist__c;value:Yerba Buena|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='349789' 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, 1720141172
ffd_listing_title, 301 Mission Street #PH6, San Francisco, CA, 94105
ffd_mls_id, 423925474
ffd_salesforce_id, a0EUd000000q3rTMAQ
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 419
address2__c, 301 Mission Street #PH6, San Francisco, CA, 94105
pba__address_pb__c, 301 Mission Street #PH6, San Francisco, CA, 94105
agent_only_remarks__c, For more information or to schedule a private tour, please contact Caleb Bennett-Waugh at [email protected] or 925.257.0323 CityResidencesPH6.com Please view our property website above and share with your clients.
appliances__c, Dishwasher;Disposal;Hood Over Range;Built-In Gas Range;Built-In Gas Oven;Wine Refrigerator;Built-In Refrigerator
architectural_style__c, Modern/High Tech
bath_features__c, Shower Stall(s);Tile;Low-Flow Toilet(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 1
year_build_text__c, 2009
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2024-01-16T22:46:43.000+0000
days_on_market__c, 170
dom__c, 170
ffd_description_pb, This City Residence Penthouse is a contemporary masterpiece featuring oversized floor-to-ceiling windows offering views of the Transbay Rooftop Park & city skyline! With 1,633 Sq.Ft. of living space, this condo combines an open layout, luxurious materials, & natural light. The state-of-the-art kitchen with full-slab marble & two baths are designed to impress while natural beech wide hardwood floors are understated & elegant. The large bedroom suite includes a walk-in closet and palatial, spa-inspired bath with a glass shower box & stand-alone tub. 301 Mission rates as one of the top hospitality centers in San Francisco! Amenities include 24/7 friendly arrival team (door staff, desk attendant, security, porters, and valet parkers) and an enormous amenities floor housing a 20,000 square feet fitness and Pilates center, saline lap pool, screening room, owners' lounge, landscaped outdoor terrace with multiple firepits, wine storage, private dining room, & children's playroom. Enjoy the curated residents' social program! Pampered by their 5-star-trained staff, 301 Mission residents enjoy the daily benefits of living in a hotel, without the guests. Following multiple years of construction, 301 Mission is now connected to bedrock.
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Marble;Wood
hoa_fee_includes__c, Common Areas,Door Person,Elevator,Homeowners Insurance,Insurance on Structure,Maintenance Exterior,Management,Organized Activities,Recreation Facility,Roof,Security,Sewer,Trash,Water
pba__hoafees__c, 3035
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Millennium Tower
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-07-05T00:48:21.000+0000
pba__latitude_pb__c, 37.79077
pba__latitude_property__c, 37.79077
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2023-11-20
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Gregg
pba__listing_agent_lastname__c, Lynn
listing_agent_mls_id__c, 804728
ffd_listingagentname, Gregg Lynn
listing_agent_number__c, 166014390
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 1249000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.CityResidencesPH6.com
pba__longitude_pb__c, -122.395754
mls_id__c, 423925474
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Street Entrance;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Low-Flow Toilet(s);Double Sinks;Tile;Bidet;Soaking Tub;Marble;Multiple Shower Heads
master_property__c, a0O1I000001VhhvUAC
monthly_parking_fees__c, 427
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-01-16
original_price__c, 1495000
overall_days_on_market__c, -81829
parking_access__c, Side by Side
parking_features__c, Enclosed,Valet
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-07-04T10:23:12.000+0000
price_per_square_foot__c, 764.85
price_reduced__c, 1
pba__propertytype__c, Condominium
ListingId, a0EUd000000q3rTMAQ
room_type__c, Kitchen;Living Room;Baths Other;Great Room;Primary Bathroom;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Secured Access
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, 1633
size__c, 1633
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Mission
subdist__c, Yerba Buena
ffd_name, 301 Mission Street #PH6, San Francisco, CA, 94105
view__c, City;Park;Downtown;San Francisco
website_property_type__c, Condominium
window_features__c, Window Coverings
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/530720401-1.jpg
_edit_lock, 1711735856:1564
_edit_last, 1564
_price_reduced__c, field_61ce1b15d3a3f
_has_3d_tour__c, field_61ce1b4cd3a40
_ListingId, field_62bf231ba1405
_pba__latitude_pb__c, field_62c436cc3ee02
_pba__longitude_pb__c, field_62c436f43ee03
_yoast_wpseo_content_score, 30
_yoast_wpseo_focuskeywords, []
_yoast_wpseo_keywordsynonyms, [""]
_yoast_wpseo_estimated-reading-time-minutes, 1
_yoast_wpseo_canonical, https://jacksonfuller.com/property/301-mission-street-ph6-san-francisco-ca-94105/