Bay City, Michigan 48706
Front Page 10/20/2021 21:30 Log-IN About us
Home Sports Community Business Schools Government Economy - Local
Downtown The Scene History Contests BOXING KA$H FOR KARAOKE Politics
Issue 1358 November 6, 2011
(Prior Story)   Ask The Experts ArTicle 06686   (Next Story)


Sheriff John Miller

CRIME! ROBBERIES, DRUGS, HUMAN ABUSE AND WORST OF ALL, MURDER!

January 29, 2012       Leave a Comment
By: Jean Ann DeShano

Printer Friendly Story View

Click to play PODCAST:    
 
This week I interviewed Sheriff John Miller -- Living in a high crime area effects the value of your home more than a poor economy. Sheriff John Miller has some great ideas to help protect you and your personal property.




The following chart is for Bay County sales only.


THIS WEEK IN REAL ESTATE -- WEEKLY STATS

AREA # OF NEW LISTINGS PRICE RANGES

  • AREA 10 HAD 3 NEW LISTINGS RANGING FROM $16,000 TO $300,000
  • AREA 20 HAD 2 NEW LISTINGS RANGING FROM $4,900 TO $112,000
  • AREA 30 HAD 8 NEW LISTINGS RANGING FROM $10,000 TO $349,000
  • AREA 40 HAD 4 NEW LISTINGS RANGING FROM $28,000 TO $104,900
  • AREA 50 HAD 1 NEW LISTINGS FOR $159,900
  • AREA 60 HAD NO NEW LISTINGS
  • AREA 70 HAD 5 NEW LISTINGS RANGING FROM $27,500 TO $114,900
  • AREA 80 HAD 2 NEW LISTINGS RANGING FROM $49,900 TO $144,900
  • AREA 90 HAD 1 NEW LISTINGS FOR $78,000
  • AREA 97 HAD 3 NEW LISTINGS RANGING FROM $79,950 TO $309,900
  • AREA 98 HAD 3 NEW LISTINGS RANGING FROM $39,900 TO $259,900

    AREA # OF SOLD LISTINGS PRICE RANGES

  • AREA 10 HAD NO SOLD LISTINGS
  • AREA 20 HAD 3 SOLD LISTINGS RANGING FROM $44,900 TO $243,500
  • AREA 30 HAD 3 SOLD LISTINGS RANGING FROM $22,525 TO $93,496
  • AREA 40 HAD NO SOLD LISTINGS
  • AREA 50 HAD NO SOLD LISTINGS
  • AREA 60 HAD 3 SOLD LISTINGS RANGING FROM $55,000 TO $122,000
  • AREA 70 HAD 3 SOLD LISTINGS RANGING FROM $135,000 TO $225,000
  • AREA 80 HAD 1 SOLD LISTING FOR $115,500
  • AREA 90 HAD 1 SOLD LISTING FOR $29,500
  • AREA 97 HAD 4 SOLD LISTINGS RANGING FROM $50,000 TO $277,000
  • AREA 98 HAD 2 SOLD LISTINGS RANGING FROM $23,000 TO $141,120

    TOTAL PENDING LISTINGS:
    THERE ARE 33 LISTING PENDING.


    QUESTION CORNER: IF YOU HAVE A QUESTION ABOUT REAL ESTATE PLEASE SUBMIT IT HERE AND I WILL ANSWER IT IN THE NEXT COLUMN. YOUR NAME AND E-MAIL ADDRESS WILL NOT BE PUBLISHED. SUBMIT YOUR QUESTIONS TO:
    Click Here to E-Mail Jean Ann DeShano

    Or Contact Jean Ann DeShano at:
    414 Gies St., Bay City, MI 48706
    (989) 233-8380

    To search for a home . . .
    or get more info about buying/selling a home
    Visit www.baycityhomes.net


    Disclaimer: All of the sold, new listing, and stats in this column are from The Bay County Realtor Association web site.


    Printer Friendly Story View
    Prior Article

    February 10, 2020
    by: Rachel Reh
    Family Winter Fun Fest is BACC Hot Spot for 2/10/2020
    Next Article

    February 2, 2020
    by: Kathy Rupert-Mathews
    MOVIE REVIEW: "Just Mercy" ... You Will Shed Tears, or at Least You Should
    Agree? or Disagree?


    Jean Ann DeShano

    Jean Ann is a Full Time Real Estate Professional at Remax Results
    Contact Jean Ann at jeanann@remaxresults.org

    More from Jean Ann DeShano

    Send This Story to a Friend!       Letter to the editor       Link to this Story
    Printer-Friendly Story View


    --- Advertisments ---
         


  • 0200 Nd: 10-16-2021 d 4 cpr 1






    12/31/2020 P3v3-0200-Ad.cfm

    SPONSORED LINKS



    12/31/2020 drop ads P3v3-0200-Ad.cfm


    Designed at OJ Advertising, Inc. (V3) (v3) Software by Mid-Michigan Computer Consultants
    Bay City, Michigan USA
    All Photographs and Content Copyright © 1998 - 2021 by OJA/MMCC. They may be used by permission only.
    P3V3-0200 (1) 0   ID:Default   UserID:Default   Type:reader   R:x   PubID:mbC   NewspaperID:1358
      pid:1560   pd:11-18-2012   nd:2021-10-16   ax:2021-10-20   Site:5   ArticleID:06686   MaxA: 999999   MaxAA: 999999
    CCBot/2.0 (https://commoncrawl.org/faq/)


    Debugging Information
    ColdFusion Server Enterprise 2021,0,0,323925
    Template /scripts/P3_V2/P3V3-0200.cfm
    Time Stamp 20-Oct-21 09:30 PM
    Locale English (US)
    User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
    Remote IP 3.236.51.151
    Host Name 3.236.51.151


    Execution Time

    Total Time Avg Time Count Template
    500 ms 500 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/scripts/P3_V2/P3V3-0200.cfm
    234 ms 234 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V2-Body.cfm
    94 ms 94 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-t010.cfm
    47 ms 47 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-CategoryBox.cfm
    47 ms 47 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/scripts/P3_V2/Application.cfm
    31 ms 31 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-BannerTop.cfm
    16 ms 16 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V2-LogStoryView.cfm
    16 ms 16 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-LogBox.cfm
    16 ms 16 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-LogBox2.cfm
    15 ms 15 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-0200-Story.cfm
    15 ms 8 ms 2 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-Banner.cfm
    15 ms 8 ms 2 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-BannerInit.cfm
    15 ms 15 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-BannerTopInit.cfm
    0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-0200-Ad.cfm
    0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-0200-Podcast.cfm
    0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-AuthorBlock.cfm
    0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-BannerCatSpon.cfm
    0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-BannerCatSponInit.cfm
    0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-BannerSubDate.cfm
    0 ms 0 ms 3 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-BannerWide.cfm
    0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-BannerWideInit.cfm
    0 ms 0 ms 2 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-FacebookLink.cfm
    0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-Feedback-AList.cfm
    0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-Feedback.cfm
    0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-GOAD.cfm
    0 ms 0 ms 2 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-GOAD2.cfm
    0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-GoogleAnalytics.cfm
    0 ms 0 ms 7 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-MBCcolor.cfm
    0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-MenuBox.cfm
    0 ms 0 ms 2 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-Set-Prior-Next.cfm
    0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-SitePal.cfm
    0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-t900.cfm
    0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/_Configuration.cfm
    0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
    547 ms  TOTAL EXECUTION TIME
    red = over 250 ms average execution time


    SQL Queries

    MBC_GetUser (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\scripts\p3_v2\Application.cfm @ 21:30:07.007
    SELECT * FROM 	authors
    	WHERE	AuthorUsername	 = 'xxx-xxx'
    P3Q_CurrPaper (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\scripts\P3_V2\P3V3-0200.cfm @ 21:30:07.007
    SELECT *
    	FROM Newspapers 
    	WHERE NPR_PublicationID = 'mbC' and NPR_AutoPub		=   '4' and NewspaperID		=   '1'
    P3_Article (Datasource=MyBayCity, Time=78ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\scripts\P3_V2\P3V3-0200.cfm @ 21:30:07.007
    SELECT *
    	FROM articles
    	WHERE ArticleID = '06686'
    P3_Author (Datasource=MyBayCity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\scripts\P3_V2\P3V3-0200.cfm @ 21:30:07.007
    SELECT *
    	FROM authors
    	WHERE AuthorUsername = 'DeShano'
    P3_Category (Datasource=MyBayCity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\scripts\P3_V2\P3V3-0200.cfm @ 21:30:07.007
    SELECT *
    	FROM categories
    	WHERE CategoryID = '90'
    P3_FeedbackCount (Datasource=MyBayCity, Time=47ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\scripts\P3_V2\P3V3-0200.cfm @ 21:30:07.007
    SELECT *
    	FROM p3_tFeedback
    	WHERE tFB_ArticleID = '06686'
    P3_CurrentPaper (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-t010.cfm @ 21:30:07.007
    SELECT *
    	FROM Newspapers
    	WHERE NewspaperID = '1358'
    P3_PublicationDef (Datasource=MyBayCity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-t010.cfm @ 21:30:07.007
    SELECT *
    	FROM P3_tPublications
    	WHERE PUB_PublicationID = 'mbC'
    P3_Get_SiteInfo (Datasource=Advertising, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-t010.cfm @ 21:30:07.007
    SELECT *
    	FROM Sites
    	WHERE Name LIKE '%MyBayCity.com%'
    P3_PriorPaper (Datasource=mybaycity, Time=16ms, Records=2) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-t010.cfm @ 21:30:07.007
    SELECT *
    	FROM Newspapers
    	WHERE ActivatedDate IS NOT NULL
    	AND NPR_PublicationID = 'mbC'
    	ORDER BY NewspaperID DESC
    P3q_CurrSubscriber (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-t010.cfm @ 21:30:07.007
    SELECT * from Subscribers
    		WHERE subscriberid ='9191919'
    P3_AvailableBanners (Datasource=Advertising, Time=15ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerTopInit.cfm @ 21:30:07.007
    SELECT	* FROM Banners
    		WHERE ExpDate > '2021-10-20'
    		  AND Banner_Type = 'W'
    		ORDER BY StartDate
    P3_GetBanner (Datasource=Advertising, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerTop.cfm @ 21:30:07.007
    SELECT	*
    		FROM Banners
    		WHERE BannerUserName = 'freedom'
    P3_ReadLog (Datasource=mybaycity, Time=16ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerTop.cfm @ 21:30:07.007
    SELECT * FROM P3_tLog
    	WHERE tLOG_RecordType	 = 'A'
    	  and tLOG_ItemID 		 = 'freedom'
    	  and tLOG_PublicationID = 'mbC'
    	  and tLOG_Date			 = '2021-10-20'
    P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 21:30:07.007
    SELECT *
    		FROM Categories
    		WHERE CategoryID = '001'
    P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 21:30:07.007
    SELECT *
    		FROM Categories
    		WHERE CategoryID = '002'
    P3_CategoryQuery (Datasource=mybaycity, Time=15ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 21:30:07.007
    SELECT *
    		FROM Categories
    		WHERE CategoryID = '004'
    P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 21:30:07.007
    SELECT *
    		FROM Categories
    		WHERE CategoryID = '006'
    P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 21:30:07.007
    SELECT *
    		FROM Categories
    		WHERE CategoryID = '009'
    P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 21:30:07.007
    SELECT *
    		FROM Categories
    		WHERE CategoryID = '011'
    P3_CategoryQuery (Datasource=mybaycity, Time=16ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 21:30:07.007
    SELECT *
    		FROM Categories
    		WHERE CategoryID = '012'
    P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 21:30:07.007
    SELECT *
    		FROM Categories
    		WHERE CategoryID = '014'
    P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 21:30:07.007
    SELECT *
    		FROM Categories
    		WHERE CategoryID = '020'
    P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 21:30:07.007
    SELECT *
    		FROM Categories
    		WHERE CategoryID = '048'
    P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 21:30:07.007
    SELECT *
    		FROM Categories
    		WHERE CategoryID = '051'
    P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 21:30:07.007
    SELECT *
    		FROM Categories
    		WHERE CategoryID = '072'
    P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 21:30:07.007
    SELECT *
    		FROM Categories
    		WHERE CategoryID = '046'
    P3q_CurrCategory (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V2-Body.cfm @ 21:30:07.007
    SELECT * FROM Categories
    	WHERE CategoryID = '90'
    P3_Body (Datasource=MyBayCity, Time=234ms, Records=12) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V2-Body.cfm @ 21:30:07.007
    SELECT *
    	FROM bodytext
    	WHERE ArticleID = '06686'
    	ORDER BY BodyIndex
    P3_LSVReadLog (Datasource=mybaycity, Time=16ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V2-LogStoryView.cfm @ 21:30:07.007
    SELECT * FROM P3_tLog
    	WHERE tLOG_RecordType = 'S' and tLOG_ItemID = '006686' and tLOG_PublicationID = 'mbC' and tLOG_Date	= '2021-10-20'
    P3_AvailableBanners (Datasource=Advertising, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerCatSponInit.cfm @ 21:30:07.007
    SELECT	*
    		FROM Banners
    		WHERE ExpDate > '2021-10-20'
    		ORDER BY StartDate
    P3_GetBanner (Datasource=Advertising, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerCatSpon.cfm @ 21:30:07.007
    SELECT	*
    		FROM Banners
    		WHERE BannerUserName = 'xxxxxx'
    P3q_PriorArticle (Datasource=MyBayCity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-Set-Prior-Next.cfm @ 21:30:07.007
    SELECT *
    		FROM articles
    		WHERE ArticleID = '11594'
    P3q_NextArticle (Datasource=MyBayCity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-Set-Prior-Next.cfm @ 21:30:07.007
    SELECT *
    		FROM articles
    		WHERE ArticleID = '11593'
    P3q_TempAuthor (Datasource=MyBayCity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-Set-Prior-Next.cfm @ 21:30:07.007
    SELECT *
    				FROM authors
    				WHERE AuthorUsername = 'Great'
    P3q_TempAuthor (Datasource=MyBayCity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-Set-Prior-Next.cfm @ 21:30:07.007
    SELECT *
    				FROM authors
    				WHERE AuthorUsername = 'Kathy'
    P3_FeedbackList (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-Feedback-AList.cfm @ 21:30:07.007
    SELECT *
    	FROM p3_tFeedback
    	WHERE tFB_ArticleID = '06686'
    	ORDER BY  tFB_CommentID
    P3_AvailableBanners (Datasource=Advertising, Time=15ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerInit.cfm @ 21:30:07.007
    SELECT	*
    		FROM Banners
    		WHERE ExpDate > '2021-10-20'	
    		  AND Banner_Type != 'W'
    		
    		ORDER BY StartDate
    P3_GetBanner (Datasource=Advertising, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-Banner.cfm @ 21:30:07.007
    SELECT	*
    		FROM Banners
    		WHERE BannerUserName = 'xxx'
    P3_ReadLog (Datasource=mybaycity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-Banner.cfm @ 21:30:07.007
    SELECT * FROM P3_tLog
    	WHERE tLOG_RecordType	 = 'A'
    	  and tLOG_ItemID 		 = ''
    	  and tLOG_PublicationID = 'mbC'
    	  and tLOG_Date			 = '2021-10-20'
    P3_AvailableBanners (Datasource=Advertising, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerInit.cfm @ 21:30:07.007
    SELECT	*
    		FROM Banners
    		WHERE ExpDate > '2021-10-20'	
    		  AND Banner_Type != 'W'
    		
    		ORDER BY StartDate
    P3_GetBanner (Datasource=Advertising, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-Banner.cfm @ 21:30:07.007
    SELECT	*
    		FROM Banners
    		WHERE BannerUserName = 'xxx'
    P3_ReadLog (Datasource=mybaycity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-Banner.cfm @ 21:30:07.007
    SELECT * FROM P3_tLog
    	WHERE tLOG_RecordType	 = 'A'
    	  and tLOG_ItemID 		 = ''
    	  and tLOG_PublicationID = 'mbC'
    	  and tLOG_Date			 = '2021-10-20'
    P3_AvailableBanners (Datasource=Advertising, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerWideInit.cfm @ 21:30:07.007
    SELECT	*
    		FROM Banners
    		WHERE ExpDate > '2021-10-20'	
    		  AND Banner_Type = 'W'
    		ORDER BY StartDate
    P3_GetBanner (Datasource=Advertising, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerWide.cfm @ 21:30:07.007
    SELECT	*
    		FROM Banners
    		WHERE BannerUserName = 'xxxxxx'
    P3_ReadLog (Datasource=mybaycity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerWide.cfm @ 21:30:07.007
    SELECT * FROM P3_tLog
    	WHERE tLOG_RecordType	 = 'A'
    	  and tLOG_ItemID 		 = ''
    	  and tLOG_PublicationID = 'mbC'
    	  and tLOG_Date			 = '2021-10-20'
    P3_GetBanner (Datasource=Advertising, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerWide.cfm @ 21:30:07.007
    SELECT	*
    		FROM Banners
    		WHERE BannerUserName = 'xxxxxx'
    P3_ReadLog (Datasource=mybaycity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerWide.cfm @ 21:30:07.007
    SELECT * FROM P3_tLog
    	WHERE tLOG_RecordType	 = 'A'
    	  and tLOG_ItemID 		 = ''
    	  and tLOG_PublicationID = 'mbC'
    	  and tLOG_Date			 = '2021-10-20'
    P3_GetBanner (Datasource=Advertising, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerWide.cfm @ 21:30:07.007
    SELECT	*
    		FROM Banners
    		WHERE BannerUserName = 'xxxxxx'
    P3_ReadLog (Datasource=mybaycity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerWide.cfm @ 21:30:07.007
    SELECT * FROM P3_tLog
    	WHERE tLOG_RecordType	 = 'A'
    	  and tLOG_ItemID 		 = ''
    	  and tLOG_PublicationID = 'mbC'
    	  and tLOG_Date			 = '2021-10-20'
    P3_LogThesePubs (Datasource=MyBayCity, Time=0ms, Records=6) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox.cfm @ 21:30:07.007
    SELECT *
    	FROM P3_tPublications
    	ORDER BY PUB_PublicationID
    P3_LogThesePubs (Datasource=MyBayCity, Time=0ms, Records=6) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 21:30:07.007
    SELECT *
    	FROM P3_tPublications
    	ORDER BY PUB_PublicationID
    P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 21:30:07.007
    SELECT * FROM P3_tLog
    		WHERE tLOG_RecordType = 'P'
    		  and tLOG_PublicationID = 'Frankenmuth'
    		  and tLOG_Date = '2021-10-19'
    P3_Pub30DayLog (Datasource=MyBayCity, Time=16ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 21:30:07.007
    SELECT * FROM P3_tLog
    			WHERE tLOG_RecordType = 'P'
    			  and tLOG_PublicationID = 'Frankenmuth'
    			  and tLOG_Date >= '2021-09-18'
    P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 21:30:07.007
    SELECT * FROM P3_tLog
    		WHERE tLOG_RecordType = 'P'
    		  and tLOG_PublicationID = 'Freeland'
    		  and tLOG_Date = '2021-10-19'
    P3_Pub30DayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 21:30:07.007
    SELECT * FROM P3_tLog
    			WHERE tLOG_RecordType = 'P'
    			  and tLOG_PublicationID = 'Freeland'
    			  and tLOG_Date >= '2021-09-18'
    P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 21:30:07.007
    SELECT * FROM P3_tLog
    		WHERE tLOG_RecordType = 'P'
    		  and tLOG_PublicationID = 'Gower'
    		  and tLOG_Date = '2021-10-19'
    P3_Pub30DayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 21:30:07.007
    SELECT * FROM P3_tLog
    			WHERE tLOG_RecordType = 'P'
    			  and tLOG_PublicationID = 'Gower'
    			  and tLOG_Date >= '2021-09-18'
    P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 21:30:07.007
    SELECT * FROM P3_tLog
    		WHERE tLOG_RecordType = 'P'
    		  and tLOG_PublicationID = 'MBC'
    		  and tLOG_Date = '2021-10-19'
    P3_Pub30DayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 21:30:07.007
    SELECT * FROM P3_tLog
    			WHERE tLOG_RecordType = 'P'
    			  and tLOG_PublicationID = 'MBC'
    			  and tLOG_Date >= '2021-09-18'
    P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 21:30:07.007
    SELECT * FROM P3_tLog
    		WHERE tLOG_RecordType = 'P'
    		  and tLOG_PublicationID = 'MTCN'
    		  and tLOG_Date = '2021-10-19'
    P3_Pub30DayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 21:30:07.007
    SELECT * FROM P3_tLog
    			WHERE tLOG_RecordType = 'P'
    			  and tLOG_PublicationID = 'MTCN'
    			  and tLOG_Date >= '2021-09-18'
    P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 21:30:07.007
    SELECT * FROM P3_tLog
    		WHERE tLOG_RecordType = 'P'
    		  and tLOG_PublicationID = 'Pinconning'
    		  and tLOG_Date = '2021-10-19'
    P3_Pub30DayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 21:30:07.007
    SELECT * FROM P3_tLog
    			WHERE tLOG_RecordType = 'P'
    			  and tLOG_PublicationID = 'Pinconning'
    			  and tLOG_Date >= '2021-09-18'
    P3_PubCurrentLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox.cfm @ 21:30:07.007
    SELECT *
    	FROM P3_tLog
    	WHERE tLOG_RecordType = 'P'
    	  and tLOG_Date = '2021-10-19'


    Scope Variables

    CGI Variables:
    AUTH_PASSWORD=
    AUTH_TYPE=
    AUTH_USER=
    CERT_COOKIE=
    CERT_FLAGS=
    CERT_ISSUER=
    CERT_KEYSIZE=
    CERT_SECRETKEYSIZE=
    CERT_SERIALNUMBER=
    CERT_SERVER_ISSUER=
    CERT_SERVER_SUBJECT=
    CERT_SUBJECT=
    CF_TEMPLATE_PATH=D:\Websites\bcra-mlscom\mybaycity.com\scripts\P3_V2\P3V3-0200.cfm
    CONTENT_LENGTH=0
    CONTENT_TYPE=
    CONTEXT_PATH=
    GATEWAY_INTERFACE=CGI/1.1
    HTTPS=off
    HTTPS_KEYSIZE=
    HTTPS_SECRETKEYSIZE=
    HTTPS_SERVER_ISSUER=
    HTTPS_SERVER_SUBJECT=
    HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    HTTP_ACCEPT_ENCODING=br,gzip
    HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
    HTTP_CONNECTION=Keep-Alive
    HTTP_COOKIE=
    HTTP_HOST=mybaycity.com
    HTTP_REFERER=
    HTTP_URL=/scripts/P3_V2/P3V3-0200.cfm?P3_NewspaperID=1358&P3_articleID=06686
    HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
    LOCAL_ADDR=192.168.162.152
    PATH_INFO=
    PATH_TRANSLATED=D:\Websites\bcra-mlscom\mybaycity.com\scripts\P3_V2\P3V3-0200.cfm
    QUERY_STRING=P3_NewspaperID=1358&P3_articleID=06686
    REMOTE_ADDR=3.236.51.151
    REMOTE_HOST=3.236.51.151
    REMOTE_USER=
    REQUEST_METHOD=GET
    SCRIPT_NAME=/scripts/P3_V2/P3V3-0200.cfm
    SERVER_NAME=mybaycity.com
    SERVER_PORT=80
    SERVER_PORT_SECURE=0
    SERVER_PROTOCOL=HTTP/1.1
    SERVER_SOFTWARE=Microsoft-IIS/10.0
    WEB_SERVER_API=
    
    Cookie Variables:
    CFID=9682266
    CFTOKEN=5170bd6650a095fa-44B22296-DEFA-7794-F92C3A40799BE7D3
    
    Session Variables:
    authortype=unknown
    cfid=9682266
    cftoken=5170bd6650a095fa-44B22296-DEFA-7794-F92C3A40799BE7D3
    login_role=x
    login_status=firsttime
    login_type=reader
    login_userid=Default
    loginid=Default
    p3_priornewspaperdate=2012-11-18 00:00:00.0
    p3_priornewspaperid=1560
    p3v2_home=mybaycity.com
    p3v2_privdiag=0
    p3v2_publication=mbC
    sessionid=P3V2SYS_9682266_5170bd6650a095fa-44B22296-DEFA-7794-F92C3A40799BE7D3
    urltoken=CFID=9682266&CFTOKEN=5170bd6650a095fa-44B22296-DEFA-7794-F92C3A40799BE7D3
    
    URL Parameters:
    P3_NewspaperID=1358
    P3_articleID=06686
    
    Debug Rendering Time: 16 ms