meta_query='key:subdist__c;value:Marina|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='312779' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15725
[post_author] => 4
[post_date] => 2018-11-02 19:54:46
[post_date_gmt] => 2018-11-02 19:54:46
[post_content] => Where Biff met Buffy and they rented their first apartment so they could jog to Crossfit together. Marina Green, yacht clubs, Ft. Mason, and front-row views from the Golden Gate Bridge to Alcatraz and the East Bay. This is as north as San Francisco goes.
[post_title] => Marina
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => marina
[to_ping] =>
[pinged] =>
[post_modified] => 2021-12-01 19:34:51
[post_modified_gmt] => 2021-12-02 03:34:51
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15725
[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 a0E8W00000WjXelUAF
pba__address_pb__c 1557 Francisco 1559 Street, San Francisco, CA, 94123
pba__city_pb__c San Francisco
pba__fullbathrooms_pb__c 6
pba__bedrooms_pb__c 6
days_on_market__c 37
mls_id__c 422660732
pba__totalarea_pb__c 6350
pba__latitude_pb__c 37.802193
pba__longitude_pb__c -122.430683
pba__state_pb__c CA
pba__status__c Active
pba__street_pb__c Francisco
listed_date__c 2022-05-12
sale_date__c 1800-01-01
pba__propertytype__c Single Family Residence
pba__listingprice_pb__c 9830000
pba__listingtype__c Sale
sale_price__c 0
address2__c 1557 Francisco 1559 Street, San Francisco, CA, 94123
pba__listing_agent_firstname__c Karen
pba__listing_agent_lastname__c Lum
view__c Water;Golden Gate Bridge
pba__halfbathrooms_pb__c 3
parkingspaces__c 3
pba__postalcode_pb__c 94123
year_build_text__c 1927
size__c 6350
subdist__c Marina
listing_agent_mls_id__c 802104
listing_co_office_mls_id__c FCSR
listing_co_office_name__c Focus Realty
listing_co_office_number__c 1058
listing_co_agent_mls_id__c 811645
listing_office_number__c 1058
listing_office_name__c Focus Realty
listing_office_mls_id__c FCSR
of_units__c 0
district__c SF District 7
selling_agent_number__c 0
selling_co_agent_number__c 0
selling_co_office_number__c 0
overall_days_on_market__c -81224
dom__c 35
monthly_parking_fees__c 0
listing_co_agent_number__c 1052872
price_per_square_foot__c 1548.03
parking_type__c On Site (Single Family Only)
original_price__c 9830000
agent_only_remarks__c Disclosures available at: https://app.disclosures.io/link/15571559-Francisco-Street-2mj6xld4 Presale escrow opened with Clare Lau of the Fidelity National Title Company on Ocean Ave. Escrow No. 1072200651 This home has everything your clients are looking for; Nestled just minutes away from Fort Mason and steps away from the most vibrant Chestnut Street with library, diverse cultural restaurants, banks. local cafes, tennis court, dog social area, filled with energy.View of GG Bridge, Palace of Fine Art and Bay views. This home is NOT IN LIQUEFACTION ZONE, per JCP report. Down to the studs rebuilt with control 4 home automation system, prewire motorized for shades, Elevator, Bianco Carrara Riserva slabs in walk in wet room for the main master ensuite, Radiant Heat flooring, Eurostone Italian quartz countertops, Calacatta Arabescato Marble, Miele, Sub-Zero & Wolf Appliances. Speakers throughout. Call or text Karen 415 812 0978 or Heidi 415 689 0684 for showings or questions.
pba__yearbuilt_pb__c 1927
pba__listing_agent_email__c [email protected]
monthlyrent__c 0
external_listing__c 1
pba__latitude_property__c 37.802193
listing_agent_number__c 802104
listing_co_agent_name__c Heidi Hoi Y Lam
on_market_date__c 2022-05-21
open_house_start__c 2022-06-26T14:00:00.000+0000
open_house_end__c 2022-06-26T16:00:00.000+0000
pba__listing_website__c https://vimeo.com/711272000
website_property_type__c Single Family Home
media Array
ListingUpdateDate 2022-06-27T08:05:14