meta_query='key:subdist__c;value:Mission Bay|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='336202' 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] => 2023-06-23 10:34:13
[post_modified_gmt] => 2023-06-23 17:34:13
[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 #445, San Francisco, CA, 94158
ffd_mls_id, 423759949
ffd_salesforce_id, a0E8W00000coNgVUAU
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 269
address2__c, 300 Berry Street #445, San Francisco, CA, 94158
pba__address_pb__c, 300 Berry Street #445, San Francisco, CA, 94158
agent_only_remarks__c, Sellers motivated with significant price reduction. Easy to show! Please text/Call Rochelle for all showings: 415.730.5899 Escrow with Old Republic Title - Sharon Chan. Tax records show 2 bed 2 bath - clients used Den as bedroom for their daughter. Truly phenomenal property at a great price! Buyer will agree to pay the Mission Bay Community Enhancement Fee (.25% of the purchase price, due @ COE) and the Mission Bay Maintenance Corporation Fee of $37.45/month.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Oven;Wine Refrigerator;Built-In Refrigerator
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 2009
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-08-02T10:48:59.000+0000
days_on_market__c, 50
dom__c, 34
ffd_description_pb, PRICE REDUCED! Large 2 bedroom Plus Den/office and 2 bathrooms available at Arterra - Mission Bay's premier LEED certified Luxury residential high rise. This fabulous Townhome residence offers a spacious house-like floor plan with high ceilings, large windows, a private porch and 1 deeded parking spot. Beautifully upgraded with Studio Becker cabinetry, hardwood floors throughout, a built-in wine fridge, stainless steel appliances, tile backsplash, custom closets, modern window treatments and frosted interior doors to reflect a sophisticated look. Additional amenities include a 24/7 Doorperson, gym, guest suite & community room, herb garden & 10th floor roof deck with BBQ Area. Walking distance to Caltrain, Whole Foods, Philz Coffee, Mission Creek Channel, dog runs, Oracle park, Chase Center and plenty of entertainment and dining options.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Common Areas,Door Person,Elevator,Homeowners Insurance,Maintenance Grounds,Management,Security,Trash
pba__hoafees__c, 785
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Action Property Management
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Electric
interior_features__c, Cathedral Ceiling
ffd_lastmodifieddate, 2023-09-21T20:46:33.000+0000
pba__latitude_pb__c, 37.77393
pba__latitude_property__c, 37.77393
laundry_features__c, Washer/Dryer Stacked Included;Washer Included;Dryer Included
listed_date__c, 2023-07-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Rochelle
pba__listing_agent_lastname__c, Vandermerwe
listing_agent_mls_id__c, 811241
ffd_listingagentname, Rochelle Vandermerwe
listing_agent_number__c, 1050646
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, ARTEMIS
listing_office_name__c, Artemis Real Estate
listing_office_number__c, 28502
pba__listingprice_pb__c, 1325000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.396241
lower_level__c, Full Bath(s),Primary Bedroom,Retreat
mls_id__c, 423759949
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O1I000001Vhi1UAC
monthly_parking_fees__c, 25
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-08-02
open_house_end__c, 2023-09-23T17:00:00.000+0000
open_house_start__c, 2023-09-23T14:30:00.000+0000
original_price__c, 1389000
overall_days_on_market__c, -81662
parking_access__c, Independent
parking_features__c, Enclosed,Garage Door Opener,Side-by-Side
parking_type__c, On Site - Mapped (Condo Only)
patio_and_porch_features__c, Front Porch
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-09-17T06:59:58.000+0000
price_per_square_foot__c, 1073.74
price_reduced__c, 1
pba__propertytype__c, Condominium
ListingId, a0E8W00000coNgVUAU
room_type__c, Den
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Carbon Mon Detector
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, 1234
size__c, 1234
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Berry
subdist__c, Mission Bay
ffd_name, 300 Berry Street #445, San Francisco, CA, 94158
website_property_type__c, Condominium
window_features__c, Dual Pane Full
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/530654364_d9b5c342-ca2e-4ecc-a7c4-4ce7f6c41889.jpg