meta_query='key:subdist__c;value:Mission Bay|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='297285' 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] => 2022-01-05 13:04:38
[post_modified_gmt] => 2022-01-05 21:04:38
[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
(
)
)
_wp_page_template PropertyDetails.php
ListingId a0E1I000001xKEAUA2
pba__address_pb__c 718 Long Bridge Street #302, San Francisco, CA, 94158
pba__city_pb__c San Francisco
pba__fullbathrooms_pb__c 2
pba__bedrooms_pb__c 2
days_on_market__c 1500
mls_id__c 468738
pba__totalarea_pb__c 1290
pba__latitude_pb__c 37.771628
pba__longitude_pb__c -122.394089
pba__state_pb__c CA
pba__status__c Sold
pba__street_pb__c Long Bridge
listed_date__c 2018-03-17
sale_date__c 2018-09-20
pba__propertytype__c Condominium
pba__listingprice_pb__c 1395000
pba__listingtype__c Sale
sale_price__c 1390000
pba__lotsize_pb__c 0
address2__c 718 Long Bridge Street #302, San Francisco, CA, 94158
pba__listing_agent_firstname__c Edmund
pba__listing_agent_lastname__c Leung
pba__floor__c 0
pba__halfbathrooms_pb__c 0
parkingspaces__c 1
pba__postalcode_pb__c 94158
year_build_text__c 2016
size__c 1290
subdist__c Mission Bay
listing_agent_mls_id__c 302044
selling_agent_mls_id__c 981678
hoa_dues__c 954.36
listing_co_office_number__c 0
listing_office_number__c 875
listing_office_name__c Coldwell Banker Res. R.E. Svcs
listing_office_mls_id__c COLD03
unit_number__c 302
district__c SF District 9
selling_agent_number__c 1017282
selling_co_agent_number__c 0
selling_co_office_number__c 0
overall_days_on_market__c 1500
dom__c 107
laundry_appliances__c Washer/Dryer
monthly_parking_fees__c 0
listing_co_agent_number__c 0
price_per_square_foot__c 1077.52
selling_office_name__c Compass
parking_type__c Designated On Site
transportation__c 2 Blocks
original_price__c 1460000
agent_only_remarks__c Back on the market with no fault on property. Buyer was having financial issue. Buyer to pay Mission Bay Community Enhancement Fee at COE(.25% of selling price). There is additional Mission Bay monthly HOA fee of ~$33. Living area is 1,290 sqft per builder but 1,227 per tax record. Escrow opened with Cornerstone Title. No open houses. By appointment only per HOA requirement. Tentative offer date to be Wednesday 06.06.18.
pba__yearbuilt_pb__c 2016
external_listing__c 1
pba__latitude_property__c 37.771628
listing_agent_number__c 302044
on_market_date__c 2018-05-23
selling_agent_name__c Justin Goldberg
master_property__c a0O1I000001VhlGUAS
pba__listing_website__c http://www.vrguild.net/c/star.pl?Q=1805221750439003
website_property_type__c Condominium
media Array
ListingUpdateDate 2022-07-01T11:35:37