WordPress database error: [Disk got full writing 'information_schema.(temporary)' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_options`

WordPress database error: [Table 'wp_gpns_unsubscribes' already exists]
CREATE TABLE wp_gpns_unsubscribes ( id bigint(20) unsigned auto_increment, email varchar(100) not null, form_id mediumint(10) unsigned, notification_id varchar(20), scope varchar(20) default 'all', timestamp_gmt datetime not null, PRIMARY KEY (id), KEY email (email), KEY email_scope (email, scope) )

WordPress database error: [Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = '_seopress_redirections_enabled_regex' AND wp_postmeta.meta_value = 'yes' ) AND ( ( mt1.meta_key = '_seopress_redirections_logged_status' AND mt1.meta_value = 'only_not_logged_in' ) OR ( mt1.meta_key = '_seopress_redirections_logged_status' AND mt1.meta_value = 'both' ) ) ) AND wp_posts.post_type = 'seopress_404' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC

71-85 King Avenue E, Clarington (Newcastle), Ontario L1C 1R2 (29423079) | The Stanway Team

WordPress database error: [Disk got full writing 'information_schema.(temporary)' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_options`

WordPress database error: [Disk got full writing 'information_schema.(temporary)' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_options`

WordPress database error: [Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = '_elementor_priority' AND ( ( mt1.meta_key = '_elementor_location' AND mt1.meta_value = 'elementor_head' ) ) ) AND wp_posts.post_type = 'elementor_snippet' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 ASC

WordPress database error: [Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = '_elementor_priority' AND ( ( mt1.meta_key = '_elementor_location' AND mt1.meta_value = 'elementor_body_start' ) ) ) AND wp_posts.post_type = 'elementor_snippet' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 ASC

WordPress database error: [Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (5) ) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC

71-85 King Avenue E Clarington, Ontario L1C 1R2

2 Bathroom 12,000 ft2
Fully Air Conditioned Forced Air

$3,375,000

Solid Investment Opportunity @ Prime Location in the Heart of Newcastle Village Surrounded by National Retail Anchors like LCBO, No Frills, CIBC, Shoppers Drugmart. Mixed-Use building with flexible zoning: includes 6000 SQFT commercial & 11 Apartments including both 1 bedroom and 2 bedroom options. All Commercial Tenants on NET leases, and all Residential Tenants Pay Separate Utilities! Building in great condition with many recent upgrades like electrical, roof, fire escape, etc. Great upside potential in Renewal Rates! (id:57557)

Business

Business Type Retail and Wholesale
Business Sub Type Retail misc.

Property Details

MLS® Number E12841596
Property Type Retail
Community Name Newcastle
Amenities Near By Highway, Public Transit

Building

Bathroom Total 2
Cooling Type Fully Air Conditioned
Heating Fuel Natural Gas
Heating Type Forced Air
Size Interior 12,000 Ft2
Utility Water Municipal Water

Land

Acreage No
Land Amenities Highway, Public Transit
Size Depth 165 Ft
Size Frontage 82 Ft
Size Irregular 0.319
Size Total 0.319 Ac
Size Total Text 0.319 Ac
Zoning Description Commercial C-133

https://www.realtor.ca/real-estate/29423079/71-85-king-avenue-e-clarington-newcastle-newcastle

WordPress database error: [Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (479) ) AND wp_posts.post_type = 'wp_template' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC

WordPress database error: [Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = '_elementor_priority' AND ( ( mt1.meta_key = '_elementor_location' AND mt1.meta_value = 'elementor_body_end' ) ) ) AND wp_posts.post_type = 'elementor_snippet' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 ASC