meta_query='key:subdist__c;value:Mission Bay|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='376692' 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
(
)
)
_yoast_indexnow_last_ping, 1716029930
ffd_listing_title, 718 Long Bridge Street #900, San Francisco, CA, 94158
ffd_mls_id, 423758907
ffd_salesforce_id, a0EUd000001rFRlMAM
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 267
address2__c, 718 Long Bridge Street #900, San Francisco, CA, 94158
pba__address_pb__c, 718 Long Bridge Street #900, San Francisco, CA, 94158
agent_only_remarks__c, Call/text Nini Gueco with questions and/or showing requests 650-291-4409. DO NOT USE SHOWING TIME. Minimum 24 hours notice for showings. OFFERS: Please use most recent SFAR Purchase Agreement, provide pre-approval/POF and signed disclosures with any offer. Pre-escrow opened with Mijael Mike Schmidt at First American. *Buyer to pay MB transfer fee (0.25% of the selling price) at COE. MB is a Master Plan community. In addition to Arden HOA, there is an additional approx. $39.13 monthly fee paid to MB Maintenance Corporation. Seller reserves the right to accept, counter, or reject any offer. Disclosures: https://app.disclosures.io/link/718-Long-Bridge-Street-900-09ez1swd
appliances__c, Dishwasher;Hood Over Range;Built-In Gas Range;Built-In Gas Oven;Built-In Refrigerator
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, Kevin Gueco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2024-04-26T21:46:58.000+0000
days_on_market__c, 22
dom__c, 22
ffd_description_pb, Step into a world of contemporary elegance at Arden, where luxury amenities and exquisite finishes abound. Corner unit 900 is a split 2 bedroom, 2 bath modern masterpiece, boasting a spacious open floor plan with extra high ceilings that promotes a sense of freedom and airiness. Indulge in the gourmet kitchen (complete with large pantry), spa-inspired bathrooms, and floor-to-ceiling south facing windows that allow for bright light throughout the day. For a truly serene experience, the secluded viewing deck offers breathtaking views of Mission Bay. Arden offers world-class amenities including 24/7 front desk, a resort-style pool and hot tub, fitness center, rooftop gardens, and a social lounge with library. The coveted location in the heart of Mission Bay provides an array of attractions, from outdoor trails to dining options, all easily accessible via Caltrain, Muni Light Rail, I80, and I280. Unit 900 at Arden is the epitome of comfort, luxury, and convenience.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__hoafees__c, 1383
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Arden HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-05-18T10:47:31.000+0000
pba__latitude_pb__c, 37.771641
pba__latitude_property__c, 37.771641
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2023-07-26
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Charlene
pba__listing_agent_lastname__c, Gueco
listing_agent_mls_id__c, 812593
ffd_listingagentname, Charlene T Gueco
listing_agent_number__c, 1057212
listing_co_agent_mls_id__c, 806744
listing_co_agent_number__c, 199019155
listing_co_office_mls_id__c, KINOKO
listing_co_office_name__c, Kinoko
listing_co_office_number__c, 27835
listing_office_mls_id__c, KINOKO
listing_office_name__c, Kinoko
listing_office_number__c, 27835
pba__listingprice_pb__c, 1749000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.zillow.com/view-imx/ca389e85-9bc5-45e2-9d73-bbc14f0f8336?wl=true&setAttribution=mls&initialViewType=pano
pba__longitude_pb__c, -122.394536
mls_id__c, 423758907
master_property__c, a0O1I000001VhlGUAS
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-04-26
open_house_end__c, 2024-05-19T12:30:00.000+0000
open_house_start__c, 2024-05-19T11:30:00.000+0000
original_price__c, 1749000
overall_days_on_market__c, -81930
parking_access__c, Side by Side
parking_features__c, Assigned,Attached,Garage Door Opener
parking_type__c, On Site - Assigned (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, 1319
pba__propertytype__c, Condominium
ListingId, a0EUd000001rFRlMAM
room_type__c, Storage
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, 1326
size__c, 1326
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Long Bridge
subdist__c, Mission Bay
ffd_name, 718 Long Bridge Street #900, San Francisco, CA, 94158
website_property_type__c, Condominium
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/530652324-1.jpg