 |
  
|
Latest Videos
Justin Bieber Hit with Water Bottle and a Bachelor Pad Fight – The Toast
Plus, Katy Perry's New Video
About The Author:
Got a story you want to share, or just need someone to talk to? Email Me!I have a penchant for pizza, a love of books, and a strong cup of coffee always makes me smile. When I'm not writing for ToastedRav I like long walks on concrete sidewalks, hanging-lamp lit dinners, and a good bottle of Shiraz.
Indluge Your Nesting Notion: Win Tickets to the Home & Garden Show
This archived news story is available only for your personal, non-commercial use. Information in the story may be outdated or superseded by additional information. Reading or replying the story in its archived form does not constitute a re-publiccation of the story.
It only takes a few months married life to put you in serious nesting mode. I was hardly back from our honeymoon before I started remodeling our whole kitchen and upstairs bathroom in my mind. With the economy on the fritz and a jam-packed schedule the call of granite counter tops and cherry wood cabinets is still but a nesting notion. With the current housing market selling the farm and buying our dream home isn't in the cards for many of us either. Our chance to the best of what we've got and turning our current home base into a place that even Hef could love is just two weeks away at the 32nd Annual St. Louis Home and Garden Show.
When: March 5 through 7 from 10am-9pm and March 8 from 10am-5pm
Where: America's Center and The Edward Jones Dome
What: More that 600 local home improvement, gardening and building gurus will be on hand to show you their goods, offer discounts and give you advice for your home projects. Plus there will be live music, and a demonstration on how to make home repiars with a can of Coke, Miracle Whip and Kool-Aid (no joke) by Joey Green "The Pantry Professor."Tickets are $9 for adults, $4 for kiddos ages 6-12 and free for the small-fries under 5. ToastedRav readers have a chance to win one of ten free VIP passes for the show, just click the tab.
Everyone has their home improvement wish list that they are dying to start tackling, and spring is the perfect time to get started. With enough time and resources you can find the best deal on those kitchen upgrades or learn how to turn your deck into a tiki palace yourself to make your current home your dream home without draining a single college fund.
|
SELECT blogPost.id, blogPost.blog_id, blogPost.slug, blogPost.member_id, blogPost.title, blogPost.votes, blogPost.comments, blogPost.body, blogPost.photo_id, blogPost.photo_width, blogPost.photo_position, blogPost.body_type, p1.origName as photo_name, p1.extension as photo_extension, p1.width as photo_size_width, if_comments, start_publish, end_publish, updated, blogPost.created, blogPost.display, member.screenname, member.first, member.last, member.signature, CONCAT(member.photo_id,'.',p2.extension) as photo, COUNT(DISTINCT blogPostPhoto.id) as gallery_count, blogCategory.id as category_id, blogCategory.name as category, blogCategory.link as category_url, blog.name as blog_name, blog.title as blog_title, blog.url as blog_url, blogPost.sticky
FROM blogPost
LEFT JOIN photo as p1 on (blogPost.photo_id=p1.id)
LEFT JOIN member on (blogPost.member_id=member.id)
LEFT JOIN blogPostPhoto on (blogPostPhoto.blogPost_id=blogPost.id)
LEFT JOIN photo as p2 on (member.photo_id=p2.id)
LEFT JOIN blogCategory on (blogPost.blogCategory_id=blogCategory.id)
LEFT JOIN blog on (blogPost.blog_id=blog.id)
WHERE blogPost.id='6940'
AND blogPost.start_publish < now() AND (blogPost.end_publish = '0000-00-00 00:00:00' OR blogPost.end_publish > now()) AND blogPost.display = 'Y'
GROUP BY blogPost.id
What do you think?
We want to hear from you! Take five seconds to join ToastedRav.com or log in.