meta_query='key:subdist__c;value:Yerba Buena|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='374124' 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, 1711736984
ffd_listing_title, 181 Fremont Street #67C, San Francisco, CA, 94105
ffd_mls_id, 424002861
ffd_salesforce_id, a0EUd000000raK1MAI
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 67
address2__c, 181 Fremont Street #67C, San Francisco, CA, 94105
pba__address_pb__c, 181 Fremont Street #67C, San Francisco, CA, 94105
agent_only_remarks__c, Call 415-282-0888 to schedule a showing. Showings by appointment Mon-Sun. 55 residences + 12 Atelier Suites.
appliances__c, Dishwasher;Disposal;Hood Over Range;ENERGY STAR Qualified Appliances;Free Standing Refrigerator;Wine Refrigerator;Double Oven;Self/Cont Clean Oven
architectural_style__c, Contemporary;Modern/High Tech
bath_features__c, Shower Stall(s);Tub
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2018
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, MultiZone
ffd_createddate, 2024-01-18T21:48:00.000+0000
days_on_market__c, 57
dom__c, 11
ffd_description_pb, This extraordinary two-bedroom, two-and-a-half-bathroom home includes 1,748 square feet of luxurious downtown living. At just over 600 feet in the sky, the north and west facing views from this elegantly appointed home include nearly every city landmark - from the Golden Gate Bridge to the Transamerica Pyramid, Twin Peaks, City Hall, Salesforce Park, and the San Francisco Bay. This one of a kind home includes interiors designed by world renowned Mass Beverly. It features some of the world's finest materials hand-selected from around the globe including French oak hardwood floors, a spa-like primary bath wrapped in Arabescato Corchia marble and a kitchen with Miele and Sub-Zero appliances. Beyond exceptional privacy and unrivaled views, 181 Fremont boasts 5-star services, world-class art program, private full-floor Residents' Club with a 360-degree open-air terrace, skybridge access to Salesforce Park, and more.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood;Stone
hoa_fee_includes__c, Door Person,Earthquake Insurance,Gas,Homeowners Insurance,Maintenance Exterior,Security,Trash,Water
pba__hoafees__c, 3860
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 181 Fremont HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, MultiZone
ffd_lastmodifieddate, 2024-03-15T10:47:18.000+0000
pba__latitude_pb__c, 37.78684567
pba__latitude_property__c, 37.78684567
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2024-01-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Carmen
pba__listing_agent_lastname__c, Legarda
listing_agent_mls_id__c, 812992
ffd_listingagentname, Carmen Legarda
listing_agent_number__c, 1058921
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 4500000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.39216733
mls_id__c, 424002861
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Tub;Double Sinks;Soaking Tub;Marble;Window;Radiant Heat;Stone
master_property__c, a0O1I0000054hyBUAQ
monthly_parking_fees__c, 575
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-01-18
original_price__c, 4500000
overall_days_on_market__c, -81831
parking_access__c, Side by Side
parking_features__c, Enclosed,Mechanical Lift,Side-by-Side,Valet
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2024-01-29
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-03-14T17:14:46.000+0000
price_per_square_foot__c, 2431.35
pba__propertytype__c, Condominium
ListingId, a0EUd000000raK1MAI
room_type__c, Storage
sale_date__c, 2024-03-14
sale_price__c, 4250000
selling_agent_mls_id__c, 806360
selling_agent_number__c, 166016816
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, JODI Group
pba__status__c, Closed
pba__totalarea_pb__c, 1748
size__c, 1748
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Fremont
subdist__c, Yerba Buena
ffd_name, 181 Fremont Street #67C, San Francisco, CA, 94105
view__c, Ocean;Park;Panoramic;City Lights;Bay;Water;Downtown;San Francisco;Golden Gate Bridge;Twin Peaks
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2018
pba__postalcode_pb__c, 94105
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530721300-1.jpg
_edit_lock, 1711736853: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, 60
_yoast_wpseo_focuskeywords, []
_yoast_wpseo_keywordsynonyms, [""]
_yoast_wpseo_estimated-reading-time-minutes, 1
_yoast_wpseo_canonical, https://jacksonfuller.com/property/181-fremont-street-67c-san-francisco-ca-94105/