meta_query='key:subdist__c;value:Mission Bay|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='328061' 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-03-09 10:09:41
[post_modified_gmt] => 2023-03-09 18:09:41
[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 #415, San Francisco, CA, 94158
ffd_mls_id, 423728044
ffd_salesforce_id, a0E8W00000bFvXvUAK
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 267
address2__c, 708 Long Bridge Street #415, San Francisco, CA, 94158
pba__address_pb__c, 708 Long Bridge Street #415, San Francisco, CA, 94158
agent_only_remarks__c, Easy to Show, Call text at 415-988-4373 or email. Showing by appointment only. Text David 415-988-4373 for questions or appt. Sellers reserve the right to accept, reject or counter any/all offers. For disclosure packets email at [email protected]il.com or text 415-988-4373. Please submit any offers on SFAR contract & include POF, Pre-Approval Letter and signed disclosure cover sheet, Disclosures and AVID signed within 24hrs of acceptance. Seller has right to accept or reject any offer. Pre-escrow opened at Doma Title Company w/Maryann Bunnel.
appliances__c, Dishwasher;Hood Over Range;Built-In Gas Range;Built-In Refrigerator
architectural_style__c, Modern/High Tech
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2016
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-03-18T10:49:14.000+0000
days_on_market__c, 8
dom__c, 8
ffd_description_pb, Arden, the apex of luxury living! 2Bd 2Ba plus Office/Den Mission Bay indoor/outdoor living. Light-Saturated condo is accentuated with stunning views of downtown skyline and Mission Creek. Spacious open living, dining and kitchen layout perfect for entertaining with expansive floor to ceiling windows and incredible views. Kitchen with Thermador appliances, custom cabinetry, a work peninsula, and ceasarstone counters. The primary bedroom is carpeted and features dual closets.. The en-suite features dual sinks set in quartz counters, Grohe fixtures, deep bathtub, and walk-in shower. The second bedroom and bath offer similar luxury finishes. In Unit Washer Dryer included! Available all the luxury amenities--24/7 front desk, gym, pool, clubhouse, and 1-car parking! Located close to, UCSF, Spark Social, the Embarcadero, FIDI, Ferry Building, Farmers Market, MOMA, Yerba Buena Gardens, the Metreon, SF Centre, World-Class Restaurants, Oracle Park, Chase Center, Muni, CalTrain,101, 280 & 80 freeways.
district__c, SF District 9
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
pba__floortype_pb__c, Carpet;Tile;Wood
hoa_fee_includes__c, Common Areas,Door Person,Elevator,Insurance,Maintenance Exterior,Maintenance Grounds,Management,Pool,Recreation Facility,Sewer,Trash,Water
pba__hoafees__c, 1385
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2023-03-25T10:48:47.000+0000
pba__latitude_pb__c, 37.771806
pba__latitude_property__c, 37.771806
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2023-03-17
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, David
pba__listing_agent_lastname__c, Poulsen
listing_agent_mls_id__c, 809572
ffd_listingagentname, David Poulsen
listing_agent_number__c, 1049895
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, EXPRE
listing_office_name__c, eXp Realty of California, Inc
listing_office_number__c, 26334
pba__listingprice_pb__c, 1700000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.394187
mls_id__c, 423728044
master_bathroom_features__c, Shower Stall(s);Tub;Low-Flow Toilet(s)
master_property__c, a0O1I000005iohJUAQ
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-03-17
open_house_end__c, 2023-03-25T16:00:00.000+0000
open_house_start__c, 2023-03-25T14:00:00.000+0000
original_price__c, 1700000
overall_days_on_market__c, -81524
parking_access__c, Independent
parking_features__c, EV Charging,Garage Door Opener
parking_type__c, On Site - Assigned (Condo Only);On Site - Lease Available (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, 1230.1
pba__propertytype__c, Condominium
ListingId, a0E8W00000bFvXvUAK
room_type__c, Kitchen
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, 1382
size__c, 1382
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Long Bridge
subdist__c, Mission Bay
ffd_name, 708 Long Bridge Street #415, 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/530592431-1.jpg
