meta_query='key:subdist__c;value:Marina|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214887' 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-2
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-28 08:36:17
[post_modified_gmt] => 2024-03-28 15:36:17
[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
(
)
)
ffd_listing_title, 2070 Beach Street, San Francisco, CA, 94123
ffd_mls_id, 505303
ffd_salesforce_id, a0E1I00000THlRLUA1
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 0
address2__c, 2070 Beach Street, San Francisco, CA, 94123
pba__address_pb__c, 2070 Beach Street, San Francisco, CA, 94123
agent_only_remarks__c, Easy to show (per all local and CAR Co-vid requirements). Contact Tyler via TEXT (415)519-2434 or Mette (415)420-2009 to schedule. Hand sanitizer, soap and towels at property. Please email PEAD to [email protected] and [email protected]. Full disclosures available! Seller occupied but easy to show! Visit www.2070beachst.com for floor plans and more photos!
appliances__c, Dishwasher;Gas Water Heater;Gas Range;Disposal;Refrigerator
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub;Tile
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1926
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-09-20T10:46:20.000+0000
days_on_market__c, 1033
dom__c, 10
ffd_description_pb, 2070 Beach is the Marina home of Brian Wilson's dreams. With 4 generous bedrooms, 3.5 baths, light-flooded formal and informal living and dining rooms, and a breakfast nook, this home is an amazing sanctuary for sheltering in place and also will be an entertainer's dream when cocktail parties come back! The oversized flat turf yard, hot tub, and two expansive decks provide ample outdoor space for the days you do not want to walk the few blocks to Marina Green. Working from home and can't get to the gym? The downstairs bonus room has plenty of space for your Peloton and yoga mat. Stay fit, healthy, and happy at this Marina Paradise.
district__c, SF District 7
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry;Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:35:04.000+0000
pba__latitude_pb__c, 37.803999
pba__latitude_property__c, 37.803999
laundry_features__c, Inside Room;Washer/Dryer Included
listed_date__c, 2020-09-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tyler
pba__listing_agent_lastname__c, Stewart
listing_agent_mls_id__c, 809622
ffd_listingagentname, Tyler Stewart
listing_agent_number__c, 1050585
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG09
listing_office_name__c, Vanguard Properties
listing_office_number__c, 27196
pba__listingprice_pb__c, 3250000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.443143
pba__lotsize_pb__c, 0.06
lower_level__c, Partial Bath(s)
mls_id__c, 505303
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c, Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-09-19
original_price__c, 3250000
overall_days_on_market__c, 178
parking__c, Garage,Auto Door,Interior Access
parking_features__c, Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s);Patio(s);Covered Patio
pba__pendingdate__c, 2020-11-18
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1235.06
pba__propertytype__c, Single Family Residence
id, a0E1I00000THlRLUA1
roof__c, Bitumen;Shingle
room_type__c, Storage;Bonus Room;Laundry
sale_date__c, 2020-12-18
sale_price__c, 3100000
security_features__c, Smoke Detector;Security Gate;Security Alarm(s)
selling_agent_mls_id__c, 803274
selling_agent_name__c, Gina M. Nibbi
selling_agent_number__c, 803274
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2510
size__c, 2510
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Beach
subdist__c, Marina
ffd_name, 2070 Beach Street, San Francisco, CA, 94123
transportation__c, 1 Block
view__c, City Lights
website_property_type__c, Single Family Home
window_features__c, Dual Pane
pba__yearbuilt_pb__c, 1926
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/370672-1.jpg
ListingId, a0E1I00000THlRLUA1