WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-2ddd9-8ff0.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_wflivetraffichuman`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-2ddd9-8ff1.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_wflivetraffichuman`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-2ddd9-8ff2.MAI' (Errcode: 30 "Read-only file system")]
SELECT DZl3SCX_posts.* FROM DZl3SCX_posts INNER JOIN DZl3SCX_postmeta ON ( DZl3SCX_posts.ID = DZl3SCX_postmeta.post_id ) INNER JOIN DZl3SCX_postmeta AS mt1 ON ( DZl3SCX_posts.ID = mt1.post_id ) INNER JOIN DZl3SCX_postmeta AS mt2 ON ( DZl3SCX_posts.ID = mt2.post_id ) INNER JOIN DZl3SCX_postmeta AS mt3 ON ( DZl3SCX_posts.ID = mt3.post_id ) WHERE 1=1 AND ( ( DZl3SCX_postmeta.meta_key = 'wpcb_enabled' AND DZl3SCX_postmeta.meta_value = '1' ) AND ( mt1.meta_key = 'wpcb_run_type' AND mt1.meta_value = 'always' ) AND (( mt2.meta_key = 'wpcb_where_to_run' AND mt2.meta_value = 'custom' ) OR ( mt3.meta_key = 'wpcb_code_type' AND mt3.meta_value != 'php' ) )) AND DZl3SCX_posts.post_type = 'wpcb_snippet_post' GROUP BY DZl3SCX_posts.ID ORDER BY DZl3SCX_posts.menu_order

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-2ddd9-8ff3.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_postmeta`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-2ddd9-8ff4.MAI' (Errcode: 30 "Read-only file system")]
SELECT DZl3SCX_posts.* FROM DZl3SCX_posts INNER JOIN DZl3SCX_postmeta ON ( DZl3SCX_posts.ID = DZl3SCX_postmeta.post_id ) WHERE 1=1 AND ( ( DZl3SCX_postmeta.meta_key = 'elementskit_template_activation' AND DZl3SCX_postmeta.meta_value = 'yes' ) ) AND DZl3SCX_posts.post_type = 'elementskit_template' AND ((DZl3SCX_posts.post_status = 'publish')) GROUP BY DZl3SCX_posts.ID ORDER BY DZl3SCX_posts.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-2ddd9-8ff5.MAI' (Errcode: 30 "Read-only file system")]
SELECT DZl3SCX_posts.* FROM DZl3SCX_posts INNER JOIN DZl3SCX_postmeta ON ( DZl3SCX_posts.ID = DZl3SCX_postmeta.post_id ) INNER JOIN DZl3SCX_postmeta AS mt1 ON ( DZl3SCX_posts.ID = mt1.post_id ) WHERE 1=1 AND ( ( DZl3SCX_postmeta.meta_key = '_seopress_redirections_enabled_regex' AND DZl3SCX_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 DZl3SCX_posts.post_type = 'seopress_404' AND ((DZl3SCX_posts.post_status = 'publish')) GROUP BY DZl3SCX_posts.ID ORDER BY DZl3SCX_posts.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-2ddd9-8ff6.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_posts`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-2ddd9-8ff7.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_wflivetraffichuman`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-2ddd9-8ff8.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_wflivetraffichuman`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-2ddd9-8ff9.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_mls_on_the_fly_cache`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-2ddd9-8ffa.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_mls_on_the_fly_cache`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-2ddd9-8ffb.MAI' (Errcode: 30 "Read-only file system")]
SHOW COLUMNS FROM `DZl3SCX_wpl_properties`

Residential For Sale - - 5 Bedrooms - 4 Bathrooms - Price $1,100,000 - 10386937
$1,100,000
British Columbia,Kamloops 5208 TRANS CANADA Highway, Kamloops, British Columbia V1S2A5
  • 5
  • 4
  • 3,594 Sqft
Basic Details
Property Type:
Residential
Listing Type:
For Sale
Listing ID:
10386937
Price:
$1,100,000
Bedrooms:
5
Bathrooms:
4
Square Footage:
3,594 Sqft
Year Built:
1960
Roof:
  • Asphalt shingle
  • Unknown
Office Key:
293926
Features
Heating System:
  • Forced air
  • In Floor Heating
  • Heat Pump
  • See remarks
Basement:
Full
Fence:
Fence
Fireplace:
  • Stove
  • Pellet
Parking:
See Remarks
Architectural Style:
Multi-level
Exterior Features:
Wood siding
Flooring:
Mixed Flooring
Fireplaces Total:
3
Address Map
Country:
CA
State:
British Columbia
City:
Kamloops
Zipcode:
V1S2A5
Street:
TRANS CANADA
Street Number:
5208
1-877-888-3131 / 10807-124 Street Edmonton AB, T5M 0H4
© 2025 ComFree Realty Inc. All rights reserved.

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-2ddd9-8ffc.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_options`