meta_query='key:subdist__c;value:Marina|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212815' 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, 3741 Broderick Street, San Francisco, CA, 94123
ffd_mls_id, 499914
ffd_salesforce_id, a0E1I00000SKdwZUAT
num_of_fireplaces__c, 2
num_of_rooms__c, 10
of_units__c, 0
address2__c, 3741 Broderick Street, San Francisco, CA, 94123
pba__address_pb__c, 3741 Broderick Street, San Francisco, CA, 94123
agent_only_remarks__c, Please schedule a showing through Calendly using the link below: https://calendly.com/helena7x7/3741-broderick-st-appointment-showing-schedule www.MarinaModernHome.com
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Hood Over Range;Double Oven;Freezer
architectural_style__c, Contemporary;Craftsman;Art Deco
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub;Remodeled;Marble;Tile
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 5
year_build_text__c, 1939
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-09-20
ffd_createddate, 2020-06-19T10:47:16.000+0000
days_on_market__c, 1125
dom__c, 105
ffd_description_pb, Handsome street presence, exquisite design features and Bay Views are the hallmarks of this custom-built home steps away the Marina Green. Spanning four levels connected by an elevator and offering 5 bedrooms, 3 baths and 2 powder rooms, sky lounge and a proliferation of smart home features this residence is primed for modern family living. Prominent window span with Marina Bay views from living, master bedroom and sky lounge. Renovated top to bottom in 2018 including new foundation and best-in class systems including an elevator to all levels; McGriff Architects + Moroso Construction. Gracious living room w/custom marble fireplace. Open kitchen with large island, built in casual dining, deck, pantry and temperature controlled wine cellar. Master suite with resort-like spa bath and phenomenal custom closets, 4 adtl. bedrooms - 2 on 1st level & 2 on master level; Top floor sky lounge with stunning Bay views custom built-in bar, seating and massive deck for entertaining.
district__c, SF District 7
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Radiant
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-01-25T15:25:14.000+0000
pba__latitude_pb__c, 37.80496
pba__latitude_property__c, 37.80496
laundry_features__c, Washer/Dryer Included
listed_date__c, 2020-02-24
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Helena
pba__listing_agent_lastname__c, Zaludova
listing_agent_mls_id__c, 804652
ffd_listingagentname, Helena Zaludova
listing_agent_number__c, 166014293
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7PAR
listing_office_name__c, Compass SF
listing_office_number__c, 27677
pba__listingprice_pb__c, 9300000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.44584
pba__lotsize_pb__c, 0.06
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 499914
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-06-19
original_price__c, 9300000
overall_days_on_market__c, 195
parking__c, Garage
parking_features__c, Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-10-03
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1754.39
pba__propertytype__c, Single Family Residence
id, a0E1I00000SKdwZUAT
sale_date__c, 2020-10-20
sale_price__c, 8800000
security_features__c, Fire Alarm;Fire Suppression System
selling_agent_mls_id__c, 808802
selling_agent_name__c, Amanda Z. Mulholland
selling_agent_number__c, 1037619
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass SF
pba__status__c, Closed
pba__totalarea_pb__c, 5016
size__c, 5016
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Broderick
subdist__c, Marina
ffd_name, 3741 Broderick Street, San Francisco, CA, 94123
view__c, Marina;Bay;Water;San Francisco;Golden Gate Bridge
website_property_type__c, Single Family Home
window_features__c, Window Coverings
pba__yearbuilt_pb__c, 1939
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/364884-1.jpg
ListingId, a0E1I00000SKdwZUAT