meta_query='key:subdist__c;value:Mission Bay|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='220459' 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, 718 Long Bridge Street #1204, San Francisco, CA, 94158
ffd_mls_id, 421585227
ffd_salesforce_id, a0E1I00000UWFqLUAX
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 267
address2__c, 718 Long Bridge Street #1204, San Francisco, CA, 94158
pba__address_pb__c, 718 Long Bridge Street #1204, San Francisco, CA, 94158
agent_only_remarks__c, In Person Showings by Appointment. HOA CCRs do not allow Open House showings. Please contact Jane Hopkins at 415-307-4300. Buyer to pay Mission Bay .025% Transfer Tax Fee and $35.37/mo to the Mission Bay Community Fund. Escrow Pre-opened with Ms. Sam Chiang at First American Title.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Ice Maker;Self/Cont Clean Oven;Built-In Refrigerator;Plumbed For Ice Maker
architectural_style__c, Modern/High Tech
bath_features__c, Tub w/Shower Over;Dual Flush Toilet;Quartz
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2015
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2021-08-24T10:49:23.000+0000
days_on_market__c, 695
dom__c, 0
ffd_description_pb, Arden 1204 is an amazing 2BR/2BA with sweeping city skyline views from every room. The entertainer's dream home with an open chef's kitchen, living and dining space separating 2 en-suite bedrooms. The floor plan flows well with floor-to-ceiling windows inviting you to the spacious covered balcony overlooking Mission Creek and the charming houseboats with the pool below. Extensive custom cabinetry has been thoughtfully added in the living area, the master bedroom and the kitchen to enhance your living experience. Recessed lighting throughout, a full size washer and dryer, A/C and 2nd floor parking with a storage locker complete the offering. With luxury resort style amenities plan to make this your next destination. Easy access to 101 and 280, Cal Train, UC Medical Center, Oracle Park and the Chase Center for the Warriors. Children's playground and dog park across the street.
district__c, SF District 9
entry_level__c, 14
external_listing__c, 1
pba__floortype_pb__c, Carpet;Tile;Wood
hoa_fee_includes__c, Door Person,Gas,Homeowners Insurance,Maintenance Grounds,Management,Pool,Security,Trash,Water
pba__hoafees__c, 1201
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Arden Owners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:59:15.000+0000
pba__latitude_pb__c, 37.771806
pba__latitude_property__c, 37.771806
laundry_features__c, Laundry Closet
listed_date__c, 2021-07-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jane
pba__listing_agent_lastname__c, Hopkins
listing_agent_mls_id__c, 805895
ffd_listingagentname, Jane E Hopkins
listing_agent_number__c, 166015974
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, MXRE
listing_office_name__c, MaxReal
listing_office_number__c, 166014386
pba__listingprice_pb__c, 2218000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.394187
mls_id__c, 421585227
master_bathroom_features__c, Shower Stall(s);Low-Flow Toilet(s);Quartz;Double Sinks;Tile;Low-Flow Shower(s);Dual Flush Toilet
master_property__c, a0O1I000001VhlGUAS
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-08-23
original_price__c, 2218000
overall_days_on_market__c, 76
parking_access__c, Side by Side
parking_features__c, Attached,Garage Door Opener,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2021-08-23
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1479.59
pba__propertytype__c, Condominium
id, a0E1I00000UWFqLUAX
sale_date__c, 2021-09-17
sale_price__c, 2175000
selling_agent_mls_id__c, 812593
selling_agent_number__c, 1057212
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Kinoko
pba__status__c, Closed
pba__totalarea_pb__c, 1470
size__c, 1470
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Long Bridge
subdist__c, Mission Bay
ffd_name, 718 Long Bridge Street #1204, San Francisco, CA, 94158
view__c, Park;Panoramic;City Lights;Water;Downtown;Bay Bridge;San Francisco;Twin Peaks;Hills
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2015
pba__postalcode_pb__c, 94158
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530305323-1.jpg
ListingId, a0E1I00000UWFqLUAX