meta_query='key:subdist__c;value:Mission Bay|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='238132' 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, 708 Long Bridge Street #515, San Francisco, CA, 94158
ffd_mls_id, 422679231
ffd_salesforce_id, a0E8W00000YYTuoUAH
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 267
address2__c, 708 Long Bridge Street #515, San Francisco, CA, 94158
pba__address_pb__c, 708 Long Bridge Street #515, San Francisco, CA, 94158
agent_only_remarks__c, Please contact agent, Myrick Tantiado at 415.596.3405 or [email protected]. Unit #514 (next door) sold for $2.9M ($1481/sq ft) on 1/19/21. Square footage from developer's (Bosa) floor plan is 1436; tax records state 1383. Square footage and bedroom count is not verified or guaranteed by either Seller or Listing Agent. Buyer advised to measure and investigate to satisfy concerns. Pre-escrow opened with Joanne Kung at Chicago Title. Buyer to pay Mission Bay Community Transfer Fee of 0.25% of the purchase price. Mission Bay is a Master Plan community. Mission Bay approximate monthly fee of $35 paid to MB Maintenance Corp in addition to the monthly HOA fee.
appliances__c, Dishwasher;Microwave;Disposal;Built-In Gas Range;Ice Maker;Built-In Refrigerator;Gas Cook Top;Built-In Freezer
architectural_style__c, Contemporary;Modern/High Tech
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2016
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Christiane Gigas
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2022-08-18T18:47:35.000+0000
days_on_market__c, 335
dom__c, 15
ffd_description_pb, Experience the best in indoor/outdoor living at this luxe 2 bedroom, 2 bathroom condo at Arden in Mission Bay. This light-filled condo is located on the coveted 5th floor with stunning views of the downtown city skyline and Mission Creek. The spacious open living, dining and kitchen layout is perfect for entertaining, boasting an expansive Ceasarstone kitchen island counter. There's also a large, exclusive-use, wrap-around terrace off the living space ideal for outdoor entertaining in this sunny & warm microclimate. This home is well-appointed with hardwood floors, full-size washer and dryer, energy-efficient heating and AC, pre-wired with USB port and fiber optic cable. This corner-unit condo is situated on the desired 5th floor, with ease of access to hotel-inspired amenities such as the rooftop lap pool & spa, fitness studio, social lounge & BBQ. This 24 hour doorman building is just steps to shops, dining, cafes, parks & transportation.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Door Person,Elevator,Maintenance Exterior,Maintenance Grounds,Management,Organized Activities,Security,Trash,Water
pba__hoafees__c, 1269
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, 2023-07-13T17:23:06.000+0000
pba__latitude_pb__c, 37.771806
pba__latitude_property__c, 37.771806
laundry_features__c, Inside Room;Washer/Dryer Stacked Included
listed_date__c, 2022-07-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Myrick
pba__listing_agent_lastname__c, Tantiado
listing_agent_mls_id__c, 807341
ffd_listingagentname, Myrick Tantiado
listing_agent_number__c, 1016143
listing_co_agent_mls_id__c, 804817
listing_co_agent_number__c, 166014506
listing_co_office_mls_id__c, STHB
listing_co_office_name__c, Sotheby's International Realty
listing_co_office_number__c, 2050
listing_office_mls_id__c, SFDWELL
listing_office_name__c, SF DWELL
listing_office_number__c, 28517
pba__listingprice_pb__c, 2150000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/740483448
pba__longitude_pb__c, -122.394187
mls_id__c, 422679231
master_bathroom_features__c, Shower Stall(s);Tub;Double Sinks
master_property__c, a0O1I000005iohJUAQ
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-08-18
original_price__c, 2150000
overall_days_on_market__c, -81313
parking_access__c, Independent
parking_features__c, Enclosed
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Wrap Around Porch
pba__pendingdate__c, 2022-09-02
pba__pool_pb__c, 1
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1497.21
pba__propertytype__c, Condominium
ListingId, a0E8W00000YYTuoUAH
sale_date__c, 2022-09-16
sale_price__c, 2150000
security_features__c, Secured Access
selling_agent_mls_id__c, 802344
selling_agent_number__c, 802344
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Coldwell Banker Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1436
size__c, 1436
spa__c, 1
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Long Bridge
subdist__c, Mission Bay
ffd_name, 708 Long Bridge Street #515, San Francisco, CA, 94158
view__c, Water;Downtown;San Francisco
website_property_type__c, Condominium
window_features__c, Dual Pane Full;Window Coverings
pba__yearbuilt_pb__c, 2016
pba__postalcode_pb__c, 94158
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530498086-1.jpg
