WordPress database error: [The table '1c_postmeta' is full]
INSERT INTO `1c_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES (306902, '_divi_dynamic_assets_cached_modules', 'a:2:{s:6:\"blocks\";a:7:{i:0;s:12:\"divi/section\";i:1;s:8:\"divi/row\";i:2;s:11:\"divi/column\";i:3;s:10:\"divi/blurb\";i:4;s:11:\"divi/button\";i:5;s:9:\"divi/menu\";i:6;s:9:\"divi/text\";}s:10:\"shortcodes\";a:0:{}}')

The Screamery
Add Restaurant

The Screamery

by | Feb 1, 2026

WordPress database error: [The table '1c_postmeta' is full]
INSERT INTO `1c_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES (306902, '_divi_dynamic_assets_canvases_used', 'a:5:{s:17:\"canvas_portal_ids\";a:0:{}s:14:\"appended_above\";a:0:{}s:14:\"appended_below\";a:0:{}s:19:\"interaction_targets\";a:0:{}s:19:\"all_canvas_metadata\";a:0:{}}')

WordPress database error: [The table '1c_options' is full]
INSERT INTO `1c_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_timeout_drts__settings__1f603f4aedeb059a0c2fa8e71163805c', '1783005823', 'off') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

WordPress database error: [The table '1c_options' is full]
INSERT INTO `1c_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_drts__settings__1f603f4aedeb059a0c2fa8e71163805c', 'a:3:{s:10:\"hide_empty\";b:1;s:9:\"load_view\";s:7:\"default\";s:7:\"_entity\";O:70:\"SabaiApps\\Directories\\Component\\WordPressContent\\EntityType\\PostEntity\":4:{i:0;s:19:\"restaurants_dir_ltg\";i:1;s:18:\"directory__listing\";i:2;a:9:{s:11:\"post_author\";i:0;s:14:\"post_published\";i:1769931519;s:13:\"post_modified\";i:1769931519;s:7:\"post_id\";i:306902;s:10:\"post_title\";s:13:\"The Screamery\";s:11:\"post_status\";s:7:\"publish\";s:9:\"post_slug\";s:13:\"the-screamery\";s:12:\"post_content\";s:330:\"The Screamery is the first Tucson creamery that pasteurizes on site. This one of a kind handcrafted ice cream is made with the freshest natural ingredients. Grass fed cows whole milk, cream, sugar and eggs are infused with natural flavors in the pasteurizer on-site. This unique process makes for a creamy and delicious ice cream.\";s:11:\"post_parent\";i:0;}i:3;s:5:\"post_\";}}', 'off') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

WordPress database error: [The table '1c_options' is full]
INSERT INTO `1c_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_timeout_drts__settings__0faae6e7ad7c9130f4dd76c1f6ecb051', '1783005823', 'off') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

WordPress database error: [The table '1c_options' is full]
INSERT INTO `1c_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_drts__settings__0faae6e7ad7c9130f4dd76c1f6ecb051', 'a:4:{s:10:\"hide_empty\";b:1;s:9:\"load_view\";s:7:\"default\";s:13:\"view_settings\";a:2:{s:5:\"query\";a:1:{s:6:\"fields\";a:1:{s:22:\"field_related_listings\";i:306902;}}s:5:\"other\";a:1:{s:3:\"add\";a:2:{s:22:\"entity_reference_field\";s:22:\"field_related_listings\";s:19:\"entity_reference_id\";i:306902;}}}s:7:\"_entity\";O:70:\"SabaiApps\\Directories\\Component\\WordPressContent\\EntityType\\PostEntity\":4:{i:0;s:19:\"restaurants_dir_ltg\";i:1;s:18:\"directory__listing\";i:2;a:9:{s:11:\"post_author\";i:0;s:14:\"post_published\";i:1769931519;s:13:\"post_modified\";i:1769931519;s:7:\"post_id\";i:306902;s:10:\"post_title\";s:13:\"The Screamery\";s:11:\"post_status\";s:7:\"publish\";s:9:\"post_slug\";s:13:\"the-screamery\";s:12:\"post_content\";s:330:\"The Screamery is the first Tucson creamery that pasteurizes on site. This one of a kind handcrafted ice cream is made with the freshest natural ingredients. Grass fed cows whole milk, cream, sugar and eggs are infused with natural flavors in the pasteurizer on-site. This unique process makes for a creamy and delicious ice cream.\";s:11:\"post_parent\";i:0;}i:3;s:5:\"post_\";}}', 'off') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

0.00
Feautures
Takes Reservations
Accepts Credit Cards
Apple Pay
Delivery
Outdoor Seating
Good for Kids
Good for Groups
Waiter Service
Take-out
Wheelchair Accessible
Has TV
Dogs Allowed
Sells Gift Certificates
Alcohol
Has Music
Karaoke
Parking Lot
Valet Parking
Free Wifi
Smoking Allowed
Shower
Contact Information
5920 W Arizona Pavilions Dr Ste 100, Tucson, AZ 85743, United States
(520) 328-8145
corporate@thescreamery.com
Detailed Information

The Screamery is the first Tucson creamery that pasteurizes on site. This one of a kind handcrafted ice cream is made with the freshest natural ingredients. Grass fed cows whole milk, cream, sugar and eggs are infused with natural flavors in the pasteurizer on-site. This unique process makes for a creamy and delicious ice cream.

Location Address
5920 W Arizona Pavilions Dr Ste 100, Tucson, AZ 85743, United States
Facebook
X (Twitter)
Pinterest
fb-share-icon
WhatsApp
Reddit

WordPress database error: [The table '1c_postmeta' is full]
INSERT INTO `1c_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES (306902, '_divi_dynamic_assets_cached_feature_used', 'a:22:{s:18:\"excerpt_content_on\";a:0:{}s:25:\"media_embedded_in_content\";a:1:{i:0;b:1;}s:15:\"animation_style\";a:1:{i:0;b:1;}s:20:\"interactions_enabled\";a:0:{}s:13:\"gutter_widths\";a:0:{}s:14:\"icon_font_divi\";a:0:{}s:12:\"icon_font_fa\";a:1:{i:0;b:1;}s:8:\"lightbox\";a:0:{}s:26:\"fullscreen_section_enabled\";a:0:{}s:22:\"scroll_effects_enabled\";a:0:{}s:24:\"section_dividers_enabled\";a:0:{}s:12:\"link_enabled\";a:0:{}s:21:\"split_testing_enabled\";a:0:{}s:28:\"social_follow_icon_font_divi\";a:0:{}s:26:\"social_follow_icon_font_fa\";a:0:{}s:17:\"specialty_section\";a:0:{}s:23:\"sticky_position_enabled\";a:1:{i:0;b:1;}s:16:\"global_color_ids\";a:5:{i:0;s:20:\"gcid-secondary-color\";i:1;s:18:\"gcid-primary-color\";i:2;s:18:\"gcid-heading-color\";i:3;s:15:\"gcid-body-color\";i:4;s:15:\"gcid-link-color\";}s:23:\"css_grid_layout_enabled\";a:0:{}s:19:\"flex_layout_enabled\";a:1:{i:0;b:1;}s:20:\"block_layout_enabled\";a:1:{i:0;b:1;}s:15:\"block_mode_blog\";a:0:{}}')

WordPress database error: [The table '1c_postmeta' is full]
INSERT INTO `1c_postmeta` (`post_id`, `meta_key`, `meta_value`) VALUES (306902, 'et_enqueued_post_fonts', 'a:3:{s:6:\"family\";a:1:{i:0;s:94:\"Open+Sans:300,regular,500,600,700,800,300italic,italic,500italic,600italic,700italic,800italic\";}s:6:\"subset\";a:2:{i:0;s:5:\"latin\";i:1;s:9:\"latin-ext\";}s:9:\"cache_key\";s:72:\"{\"gph\":-1,\"divi\":\"5.5.2\",\"wp\":\"7.0\",\"enable_all_character_sets\":\"false\"}\";}')