meta_query='key:subdist__c;value:Marina|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='319173' 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, 3521 Webster Street, San Francisco, CA, 94123
ffd_mls_id, 422697197
ffd_salesforce_id, a0E8W00000ZKJUPUA5
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 0
address2__c, 3521 Webster Street, San Francisco, CA, 94123
pba__address_pb__c, 3521 Webster Street, San Francisco, CA, 94123
agent_only_remarks__c, Broker's note: Seller reserves the right to accept or reject any & all offers. Buyers should verify all Sq Ft, disclosures, and permit history and bed and bath count and legality for themselves. Buyers should get any and all inspections they deem necessary.
architectural_style__c, Tudor
bath_features__c, Shower Stall(s);Tub
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1932
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-10-07
ffd_createddate, 2022-09-23T15:47:56.000+0000
days_on_market__c, 299
dom__c, 17
ffd_description_pb, This rare Marina 3BD/1.5BA Center-Patio Tudor with a highly-functional floor plan, ample bonus spaces ripe for expansion AND an incredible location is on the market for only the 1st time since built! 3521 Webster greets visitors with a grand formal entry, a stately FLR w/FP, vaulted ceilings & big East-facing windows, a FDR w/box-beamed ceilings & French doors to a charming center patio, and a kitchen w/B-fast rm & patio access. Two ample BDs, one w/a Romeo balcony AND a split BA completes the main level. Upstairs is a private 3rd BD w/French doors to the roof ripe for a possible roof-deck. The ground floor boasts bonus rooms w/half BA, PLUS a multi-car garage w/laundry & storage. Warm wd flrs, period charm AND opportunities for the next owner's finishing touches run thru-out. A charming rear yard ready for gardening, entertainment & play completes this rare offering. Incredible location, just steps to the Marina Green, Moscone Park, Safeway, Chestnut/Union St. & much more!
district__c, SF District 7
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
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
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry;Skylight(s);Cathedral Ceiling;Open Beam Ceiling
ffd_lastmodifieddate, 2023-07-13T17:48:50.000+0000
pba__latitude_pb__c, 37.803186
pba__latitude_property__c, 37.803186
laundry_features__c, In Garage
listed_date__c, 2022-09-23
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Andrew
pba__listing_agent_lastname__c, de Vries
listing_agent_mls_id__c, 803319
ffd_listingagentname, Andrew de Vries
listing_agent_number__c, 803319
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, BHFP
listing_office_name__c, Berkshire Hathaway-Franciscan
listing_office_number__c, 1665
pba__listingprice_pb__c, 2349000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=KecUEnATSs2
pba__longitude_pb__c, -122.435337
lower_level__c, Family Room,Partial Bath(s),Street Entrance
mls_id__c, 422697197
main_level__c, Full Bath(s);Bedroom(s);Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-09-23
original_price__c, 2349000
overall_days_on_market__c, -81349
parking_access__c, Tandem
parking_features__c, Attached,Enclosed,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-10-10
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1268.12
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000ZKJUPUA5
roof__c, Bitumen;Tar/Gravel
room_type__c, Storage;Bonus Room;Kitchen;Living Room;Baths Other;Dining Room;Family Room
sale_date__c, 2022-10-31
sale_price__c, 2625000
selling_agent_mls_id__c, 257381
selling_agent_number__c, 257381
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 2070
size__c, 2070
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Webster
subdist__c, Marina
ffd_name, 3521 Webster Street, San Francisco, CA, 94123
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1932
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530532845-1.jpg