meta_query='key:subdist__c;value:Mission Bay|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='297345' 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 a0E1I000001JZ5PUAW
pba__address_pb__c 718 Long Bridge Street #321, San Francisco, CA, 94158
pba__city_pb__c San Francisco
pba__fullbathrooms_pb__c 2
pba__bedrooms_pb__c 2
days_on_market__c 1789
mls_id__c 460727
pba__totalarea_pb__c 1217
pba__latitude_pb__c 37.771507
pba__longitude_pb__c -122.394356
pba__state_pb__c CA
pba__status__c Sold
pba__street_pb__c Long Bridge
listed_date__c 2017-08-04
sale_date__c 2017-09-20
pba__propertytype__c Condominium
pba__listingprice_pb__c 1299000
pba__listingtype__c Sale
sale_price__c 1350000
pba__lotsize_pb__c 0
address2__c 718 Long Bridge Street #321, San Francisco, CA, 94158
pba__listing_agent_firstname__c Vincent
pba__listing_agent_lastname__c Heung
pba__floor__c 0
pba__halfbathrooms_pb__c 0
parkingspaces__c 1
pba__postalcode_pb__c 94158
year_build_text__c 2016
size__c 1217
subdist__c Mission Bay
listing_agent_mls_id__c 807560
selling_agent_mls_id__c 808101
hoa_dues__c 937.89
listing_co_office_mls_id__c JODI
listing_co_office_name__c JODI Group
listing_co_office_number__c 15618
listing_co_agent_mls_id__c 809830
listing_office_number__c 15618
listing_office_name__c JODI Group
listing_office_mls_id__c JODI
unit_number__c 321
district__c SF District 9
selling_agent_number__c 1030763
selling_co_agent_number__c 0
selling_co_office_number__c 0
overall_days_on_market__c 1789
dom__c 46
laundry_appliances__c Washer/Dryer,In Closet
monthly_parking_fees__c 0
listing_co_agent_number__c 1043592
price_per_square_foot__c 1109.29
selling_office_name__c Skybox Realty
parking_type__c Designated On Site
transportation__c 2 Blocks
original_price__c 1299000
agent_only_remarks__c For private showing, please contact listing agent, Vincent Heung at 650.690.2238 or 510.220.0188. In addition to HOA, there is $33.75 monthly fee paid to Mission Bay Maintenance Corporation. Escrow is with Pauline Thach, Chicago Title Company.
pba__yearbuilt_pb__c 2016
external_listing__c 1
pba__latitude_property__c 37.771507
listing_agent_number__c 1021645
on_market_date__c 2017-08-04
selling_agent_name__c Vi N. Pavlicevich
master_property__c a0O1I000001VhlGUAS
website_property_type__c Condominium
media Array
ListingUpdateDate 2022-06-29T05:41:10