Executed Queries

SQL: select * from `posts` where `site_id` = ? and `slug` = ? limit 1
Bindings: ["1","12-days-cre-christmas"]
Time: 1.13 ms
SQL: select `categories`.*, `category_pivot`.`post_id` as `pivot_post_id`, `category_pivot`.`categories_id` as `pivot_categories_id`, `category_pivot`.`created_at` as `pivot_created_at`, `category_pivot`.`updated_at` as `pivot_updated_at` from `categories` inner join `category_pivot` on `categories`.`id` = `category_pivot`.`categories_id` where `category_pivot`.`post_id` in (23123)
Bindings: []
Time: 8.74 ms
SQL: select `users`.*, `user_pivot`.`post_id` as `pivot_post_id`, `user_pivot`.`user_id` as `pivot_user_id` from `users` inner join `user_pivot` on `users`.`id` = `user_pivot`.`user_id` where `user_pivot`.`post_id` in (23123)
Bindings: []
Time: 1.63 ms
SQL: select `tags`.*, `tag_pivot`.`post_id` as `pivot_post_id`, `tag_pivot`.`tag_id` as `pivot_tag_id`, `tag_pivot`.`created_at` as `pivot_created_at`, `tag_pivot`.`updated_at` as `pivot_updated_at` from `tags` inner join `tag_pivot` on `tags`.`id` = `tag_pivot`.`tag_id` where `tag_pivot`.`post_id` in (23123)
Bindings: []
Time: 6.58 ms
SQL: select `locations`.*, `location_pivot`.`post_id` as `pivot_post_id`, `location_pivot`.`location_id` as `pivot_location_id`, `location_pivot`.`created_at` as `pivot_created_at`, `location_pivot`.`updated_at` as `pivot_updated_at` from `locations` inner join `location_pivot` on `locations`.`id` = `location_pivot`.`location_id` where `location_pivot`.`post_id` in (23123)
Bindings: []
Time: 3.48 ms
SQL: select * from `attachments` where `attachments`.`id` in (14228)
Bindings: []
Time: 0.27 ms
SQL: select * from `categories` where `categories`.`id` in (51)
Bindings: []
Time: 0.2 ms
SQL: select * from `tags` where `tags`.`id` in (230)
Bindings: []
Time: 0.19 ms
SQL: select * from `locations` where `locations`.`id` in (47)
Bindings: []
Time: 0.19 ms
SQL: select * from `columns` where `columns`.`id` in (66)
Bindings: []
Time: 0.2 ms
SQL: select * from `users` where `users`.`id` in (13)
Bindings: []
Time: 0.23 ms

The Saskatchewan Edge

"The Saskatchewan Edge" Columnists

Kelly Macsymic Business Manager, Stuart Commercial Inc., Sales Associate, ICR Commercial Real Estate

Barry Stuart Managing Partner and Senior Sales Associate , ICR Commercial Real Estate

Recent

Vancouver's retail market thrives, despite multiple challenges

James Glen Commercial Retail Metro Vancouver Oct. 2 2024

Oxford's resort, urban hotel portfolio continues to blossom

Steve McLean Commercial Hotels and Resorts Jasper Oct. 2 2024

John Nicola to step down as Nicola Wealth CEO at end of 2025

RENX Staff Commercial CEOs Metro Vancouver Oct. 1 2024

Mixed-use multires a growing sector for Canada's developers

Steve McLean Residential Mixed-Use National Oct. 1 2024

The 12 Days of a CRE Christmas

“On the first day of Christmas my broker sent to me . . . A qualified tenant for occupancy On the...

Kelly Macsymic Commercial Brokers National Dec. 21 2018

Kelly Macsymic Business Manager, Stuart Commercial Inc., Sales Associate, ICR Commercial Real Estate

“On the first day of Christmas my broker sent to me . . .

A qualified tenant for occupancy

On the second day of Christmas my broker sent to me . . .

Two executed leases
And a qualified tenant for occupancy

On the third day of Christmas my broker sent to me . . .

Three retail anchors
Two executed leases
And a qualified tenant for occupancy

On the fourth day of Christmas my broker sent to me . . .

Four acres to develop
Three retail anchors
Two executed leases
And a qualified tenant for occupancy

On the fifth day of Christmas my broker sent to me . . .

Five turnkey offices
Four acres to develop
Three retail anchors
Two executed leases
And a qualified tenant for occupancy

On the sixth day of Christmas my broker sent to me . . .

Six rent rolls
Five turnkey offices
Four acres to develop
Three retail anchors
Two executed leases
And a qualified tenant for occupancy

On the seventh day of Christmas my broker sent to me . . .

Seven eager buyers
Six rent rolls
Five turnkey offices
Four acres to develop
Three retail anchors
Two executed leases
And a qualified tenant for occupancy

On the eighth day of Christmas my broker sent to me . . .

Eight high appraisals
Seven eager buyers
Six rent rolls
Five turnkey offices
Four acres to develop
Three retail anchors
Two executed leases
And a qualified tenant for occupancy

On the ninth day of Christmas my broker sent to me . . .

Nine T.I. quotes
Seven eager buyers
Six rent rolls
Five turnkey offices
Four acres to develop
Three retail anchors
Two executed leases
And a qualified tenant for occupancy

On the tenth day of Christmas my broker sent to me . . .

Ten floor calls
Nine T.I. quotes
Seven eager buyers
Six rent rolls
Five turnkey offices
Four acres to develop
Three retail anchors
Two executed leases
And a qualified tenant for occupancy

On the eleventh day of Christmas my broker sent to me . . .

Eleven parking stalls
Ten floor calls
Nine T.I. quotes
Seven eager buyers
Six rent rolls
Five turnkey offices
Four acres to develop
Three retail anchors
Two executed leases
And a qualified tenant for occupancy

On the twelfth day of Christmas my broker sent to me . . .

Twelve happy landlords
Eleven parking stalls
Ten floor calls
Nine T.I. quotes
Seven eager buyers
Six rent rolls
Five turnkey offices
Four acres to develop
Three retail anchors
Two executed leases
And a qualified tenant for occupancy”

Category: Commercial

Tags: Brokers Leasing Human Resources

Location : National

Kelly Macsymic Business Manager, Stuart Commercial Inc., Sales Associate, ICR Commercial Real Estate

I am a gal of all trades and wear a few hats at my current job though nothing quite as esteemed as my 1996 Unity Western Days Rodeo Queen crowned cowboy hat. I spend my time as a sales and leasing agent at ICR Commercial Real Estate (ICR), in addition to my other gig as general sidekick and business manager for Barry Stuart at Stuart Commercial. Inc. I started my journey in the small town of Unity, SK. My grandmother encouraged me to create mock newspapers which I, like any good keener, produced in abundance. My early publication days came to a quick end when I broke the news in one of these homemade papers with word of a surprise birthday party for my grandfather, and proudly presented it to him. Undaunted, I pursued the news bug all the way to Lethbridge College and was gainfully employed for several years in weekly papers in rural Saskatchewan. After a few adventures at the University of Regina and abroad in England, opportunity knocked and I accepted the chance to move to Saskatoon. I landed at Barry’s doorstep and have since been taken under his wing. He’s shown me the ropes at ICR through his most capable hands as one of ICR’s top producers. We are a dynamic team. I relish the challenges (most of the time) he throws at me daily. My other commitments include BPW (Business and Professional Women) Saskatoon in addition to volunteering as president of the Holliston Community Association.

Industry Events

MIPIM: The Global Urban Festival Mar 11 2025 to Mar 14 2025

Palais des Festivals, Cannes, France

Executed Queries

"The Saskatchewan Edge" Columnists

Recent

Vancouver's retail market thrives, despite multiple challenges

Oxford's resort, urban hotel portfolio continues to blossom

John Nicola to step down as Nicola Wealth CEO at end of 2025

Mixed-use multires a growing sector for Canada's developers

The 12 Days of a CRE Christmas

“On the first day of Christmas my broker sent to me . . . A qualified tenant for occupancy On the...

Industry Events

Subscribe to our newsletter

Follow us on Social Media

Advertise with Squall