meta_query='key:subdist__c;value:Mission Bay|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214286' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15715
[post_author] => 4
[post_date] => 2018-11-02 19:54:29
[post_date_gmt] => 2018-11-02 19:54:29
[post_content] => Master-planned masterpiece or mid-rise suburban-esque stucco nightmare? Welcome to San Francisco's newest neighborhood, redeveloped from former railroad land and anchored by UCSF's Mission Bay campus. Sunny weather, new to newer construction, 47 acres of parks, and an arena for the Warriors.
[post_title] => Mission Bay
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => mission-bay
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-07 14:08:53
[post_modified_gmt] => 2024-03-07 22:08:53
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15715
[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, 300 Berry Street #614, San Francisco, CA, 94158
ffd_mls_id, 504486
ffd_salesforce_id, a0E1I00000TG3AiUAL
num_of_fireplaces__c, 0
num_of_rooms__c, 3
of_units__c, 269
address2__c, 300 Berry Street #614, San Francisco, CA, 94158
pba__address_pb__c, 300 Berry Street #614, San Francisco, CA, 94158
agent_only_remarks__c, Please schedule showings here: https://calendly.com/nick-hazelton/request-a-private-showing-for-300-berry-614 Buyer to pay 0.25% Mission Bay community enhancement transfer tax; please write that in the contract under additional terms. Monthly Mission Bay HOA Dues $36.23 per month. First Republic & Bank of the West among others can lend during the building litigation, let Nick know if you need an intro to a lender.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator
architectural_style__c, Contemporary;Modern/High Tech
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 2009
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Sara Werner Costa
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-08-25T10:46:59.000+0000
days_on_market__c, 1059
dom__c, 114
ffd_description_pb, Welcome to Arterra, San Francisco's most dynamic, eco friendly high-rise community. Residence 614 is a light filled serene home with courtyard and partial Mission Creek views. Enter to the kitchen with stainless steel appliances including gas range, which flows seamlessly into the open dining and living space. The spacious bedroom has generously sized closets with built-ins, along with in-unit laundry. This home comes with exclusive storage outside of the unit, as well. The building includes amenities galore such as a fitness center, guest suite, 24/7 attended lobby with concierge, rooftop deck with panoramic views and barbecue area, and bike racks. The location is a commuter's heaven nearby 280/101, CalTrain and Muni. The Bay Bridge, Embarcadero, downtown and shuttles are all within a few blocks, as well!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floor__c, 0
pba__floortype_pb__c, Carpet;Wood
hoa_dues__c, 572.51
hoa_fee_includes__c, Management,Door Person,Maintenance Exterior,Trash,Maintenance Grounds,Water
pba__hoafees__c, 572
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Electric
ffd_lastmodifieddate, 2022-01-25T15:32:07.000+0000
pba__latitude_pb__c, 37.77393
pba__latitude_property__c, 37.77393
laundry_appliances__c, Washer/Dryer,In Closet
laundry_features__c, Laundry Closet;Washer/Dryer Included
listed_date__c, 2020-08-17
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Franck
pba__listing_agent_lastname__c, Costa
listing_agent_mls_id__c, 807197
ffd_listingagentname, Franck Costa
listing_agent_number__c, 166018406
listing_co_agent_mls_id__c, 806154
listing_co_agent_number__c, 166016364
listing_co_office_mls_id__c, VANG02
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 166013449
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 720000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.396241
pba__lotsize_pb__c, 0
mls_id__c, 504486
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
master_property__c, a0O1I000001Vhi1UAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-08-24
original_price__c, 795000
overall_days_on_market__c, 174
parking_access__c, Independent
parking_features__c, Enclosed,Interior Access,Mechanical Lift,Garage
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2020-12-16
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1069.28
pba__propertytype__c, Condominium
id, a0E1I00000TG3AiUAL
sale_date__c, 2021-01-22
sale_price__c, 710000
selling_agent_mls_id__c, 812053
selling_agent_number__c, 1054601
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, City Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 664
size__c, 664
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Berry
subdist__c, Mission Bay
ffd_name, 300 Berry Street #614, San Francisco, CA, 94158
transportation__c, 1 Block
unit_number__c, 614
view__c, Partial
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2009
pba__postalcode_pb__c, 94158
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/368964-1.jpg
ListingId, a0E1I00000TG3AiUAL