meta_query='key:subdist__c;value:Marina|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='385659' 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
(
)
)
_yoast_indexnow_last_ping, 1725879144
ffd_listing_title, 3300 Baker Street, San Francisco, CA, 94123
ffd_mls_id, 424010541
ffd_salesforce_id, a0EUd00000329qTMAQ
num_of_fireplaces__c, 1
num_of_rooms__c, 9
of_units__c, 0
address2__c, 3300 Baker Street, San Francisco, CA, 94123
pba__address_pb__c, 3300 Baker Street, San Francisco, CA, 94123
agent_only_remarks__c, Successor Trustee Sale, offered As-Is. All knob & tube wiring removed and new electrical system installed; new flat roof; new sewer lateral; new kitchen; new landscaping and irrigation. Square footage is per floor plan tech; neither broker nor seller warrants; buyers are advised to investigate to their own satisfaction. Please use SFAR Purchase Agreement; Kelley Kish at First American Title has worked extensively with the trust.
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Range;Built-In Refrigerator
architectural_style__c, Mediterranean
bath_features__c, Shower Stall(s);Tile;Low-Flow Toilet(s);Low-Flow Shower(s);Window;Closet
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1939
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-09-05T10:49:23.000+0000
days_on_market__c, 4
dom__c, 4
ffd_description_pb, Captivating Views and Neighborhood Gems: From this charming home's living room, primary suite and terrace, the iconic Palace of Fine Arts is on view - a masterpiece framed by your windows, day & night. Step outside, and the Marina unfolds - the verdant Marina Green, the windswept beauty of Crissy Field, and the majestic San Francisco Bay. For several decades, this home has cradled memories, passed down through family ties. Now, with loving care, it has been rejuvenated. New electric, a pristine roof, a new kitchen that beckons culinary adventures all speak to the reverence for its heritage. We welcome its next discerning stewards. The home is fully detached, enjoys superb natural light, hardwood floors and curated light fixtures. Main level: LR, DR, kitchen, breakfast room, half bath. Upper level: 3BR, 2BA, interior stairs to flat roof. Lower level: 2 finished rooms for possible au pair, home gym, yoga, family, office, full bath, large garage, laundry area. Successor Trustee Sale.
district__c, SF District 7
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-09-09T10:47:45.000+0000
pba__latitude_pb__c, 37.8016165
pba__latitude_property__c, 37.8016165
laundry_features__c, In Garage;Washer/Dryer Stacked Included;Ground Floor;Sink
listed_date__c, 2024-02-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Rebecca
pba__listing_agent_lastname__c, Schumacher
listing_agent_mls_id__c, 805929
ffd_listingagentname, Rebecca Schumacher
listing_agent_number__c, 166016017
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 3800000
pba__listingtype__c, Sale
pba__listing_website__c, https://schumacherproperties.com/property-detail/366
pba__longitude_pb__c, -122.446387
lower_level__c, Family Room,Full Bath(s),Garage,Retreat
mls_id__c, 424010541
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Shower Stall(s);Tub;Low-Flow Toilet(s);Tile;Window
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-09-05
open_house_end__c, 2024-09-10T12:00:00.000+0000
open_house_start__c, 2024-09-10T10:00:00.000+0000
original_price__c, 3800000
overall_days_on_market__c, -82062
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener,Garage Facing Side,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Covered Deck
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1453.15
pba__propertytype__c, Single Family Residence
ListingId, a0EUd00000329qTMAQ
roof__c, Bitumen;Spanish Tile
room_type__c, Bonus Room;Kitchen;Living Room;Baths Other;Dining Room;Family Room;Primary Bathroom;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 2615
size__c, 2615
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Baker
subdist__c, Marina
ffd_name, 3300 Baker Street, San Francisco, CA, 94123
view__c, City;Park;San Francisco;Other
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
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/530832750-1.jpg