meta_query='key:subdist__c;value:Yerba Buena|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='410063' 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, 1727232998
ffd_listing_title, 181 Fremont #54A, San Francisco, CA, 94105
ffd_mls_id, 424065814
ffd_salesforce_id, a0EUd0000037AoxMAE
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 67
address2__c, 181 Fremont #54A, San Francisco, CA, 94105
pba__address_pb__c, 181 Fremont #54A, San Francisco, CA, 94105
agent_only_remarks__c, Call 415-282-0888 to schedule a showing. Showings by appointment Mon-Sun. 55 residences + 12 accessory suites.
appliances__c, Dishwasher;Disposal;Hood Over Range;Built-In Gas Range;ENERGY STAR Qualified Appliances;Built-In Refrigerator
architectural_style__c, Contemporary;Modern/High Tech
bath_features__c, Shower Stall(s);Tile;Stone
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 2018
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, MultiZone
ffd_createddate, 2024-09-15T21:46:50.000+0000
days_on_market__c, 11
dom__c, 11
ffd_description_pb, Step into a world of elevated living at 181 Fremont, where sophistication meets comfort in this exquisite junior one-bedroom home. Perched over 500 feet above San Francisco, Atelier Suite 54A offers stunning city views. Every inch of this home has been designed with the utmost attention to detail, boasting top-tier finishes that define true luxury. From sleek Miele and Liebherr appliances to the timeless elegance of French oak floors, every feature has been thoughtfully curated to enhance your living experience. Beyond the residence, indulge in exclusive amenities that set 181 Fremont apart. The private, full-floor Residents' Club offers a 360-degree open-air terrace perfect for soaking in panoramic views. Enjoy direct access to Salesforce Park via the skybridge and immerse yourself in a world-class art program designed to enrich your everyday. Now available for immediate occupancy. Note that 2024 HOA's are based on net-effective HOA with builder incentives. Call for more details on this incentive. This home is virtually staged.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Door Person,Earthquake Insurance,Gas,Homeowners Insurance,Maintenance Exterior,Security,Trash,Water
pba__hoafees__c, 1874
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 181 Fremont HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, MultiZone
ffd_lastmodifieddate, 2024-09-25T02:46:54.000+0000
pba__latitude_pb__c, 37.7896479
pba__latitude_property__c, 37.7896479
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2024-09-13
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, 937000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.3953713
mls_id__c, 424065814
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
master_property__c, a0O1I0000054hyBUAQ
monthly_parking_fees__c, 575
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-09-13
open_house_end__c, 2024-09-29T16:00:00.000+0000
open_house_start__c, 2024-09-29T14:00:00.000+0000
original_price__c, 937000
overall_days_on_market__c, -82070
parking_access__c, Side by Side
parking_features__c, Valet
parking_type__c, On Site - Unassigned (Condo Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1912.24
pba__propertytype__c, Condominium
ListingId, a0EUd0000037AoxMAE
sale_date__c, 1800-01-01
sale_price__c, 0
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, 490
size__c, 490
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Fremont
subdist__c, Yerba Buena
ffd_name, 181 Fremont #54A, San Francisco, CA, 94105
view__c, City Lights;Downtown;San Francisco
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/530842478-1.jpg
