Laurence Smith Window and Door

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 335252,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://windowanddoorcenter.com/",
      "title": "Laurence Smith Window and Door",
      "description": "Laurence Smith Window & Door is dedicated to the installation of high quality windows and doors in Bay City, Michigan. We have worked hard to earn the trust and respect of homeowners and communities weve had the pleasure to work with. We take pride in the fact that we ensure that the products we install in your home are top quality. Clients know our products are chosen and selected by experts in the field. With over 75 years of expertise, we have served residential, commercial, and contractor clients. Our crew is always available to assist you in choosing the best windows and doors for your home. Contact us now!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 85997,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-09-11T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 3,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 22,
      "city_id": 10179,
      "ltop": "",
      "facebook": "",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 4148,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "35235983-7012-11ef-ab46-b66e99367f32",
      "subdate": "Sep 11, 2024",
      "subcategory": "Home Remodels",
      "request_types": "",
      "visitcount": 31
   },
   "visits": {
      "storefront": 31,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 10,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-09-11 07:48:17"
   },
   "location": {
      "uuid": "35235983-7012-11ef-ab46-b66e99367f32",
      "link_id": 335252,
      "account_id": 85997,
      "company": "Laurence Smith Window and Door",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 22,
      "city": "10179",
      "zip": "48706",
      "address": "3605 S. Huron Road Bay City, MI 48706, USA",
      "phone": "",
      "fax": null,
      "email": "windowanddoorcenter05@gmail.com",
      "name": "Laurence Smith Window and Door",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "43.6364196",
      "lon": "-83.922158",
      "cityname": "Bay City",
      "statename": "Michigan"
   },
   "socialmedia": [
      {
         "title": "Facebook",
         "ptype_id": 29,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Instagram",
         "ptype_id": 30,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Youtube",
         "ptype_id": 31,
         "dbtable": "links_socialmedia",
         "item": "Youtube Video",
         "cnt": null
      },
      {
         "title": "LinkedIn",
         "ptype_id": 32,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "TikTok",
         "ptype_id": 33,
         "dbtable": "links_socialmedia",
         "item": "Videos",
         "cnt": null
      },
      {
         "title": "Twitter",
         "ptype_id": 34,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Reddit",
         "ptype_id": 37,
         "dbtable": "links_socialmedia",
         "item": "Reddit",
         "cnt": null
      },
      {
         "title": "SnapChat",
         "ptype_id": 38,
         "dbtable": "links_socialmedia",
         "item": "SnapChat",
         "cnt": null
      }
   ],
   "promos": [
      {
         "item": "article",
         "cnt": 0
      },
      {
         "item": "video",
         "cnt": 0
      },
      {
         "item": "product",
         "cnt": 0
      },
      {
         "item": "coupon",
         "cnt": 0
      },
      {
         "item": "service",
         "cnt": 0
      },
      {
         "item": "article_external",
         "cnt": 0
      },
      {
         "item": "video_external",
         "cnt": 0
      },
      {
         "item": "product_external",
         "cnt": 0
      },
      {
         "item": "coupon_external",
         "cnt": 0
      },
      {
         "item": "service_external",
         "cnt": 0
      }
   ],
   "featuredproduct": ""
}