Midtown Craftsmen LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 338143,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.mtcrestoration.com/",
      "title": "Midtown Craftsmen LLC",
      "description": "Midtown Craftsmen specializes in historic restoration, providing expert services to preserve and revitalize historic properties. With a focus on craftsmanship and attention to detail, their skilled team is dedicated to maintaining the architectural integrity and historical significance of buildings. We offer a range of services, including structural repairs, custom millwork, and restoration of original features. Committed to sustainability and using historically accurate materials, they ensure that each project meets the highest standards. Whether it''s a landmark building or a cherished home, Midtown Craftsmen is your trusted partner for revitalizing historic properties while honoring their rich heritage.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 88862,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-11-22T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 2,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 22,
      "city_id": 10371,
      "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": 262,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "c8a4f692-a8eb-11ef-a909-b66e99367f32",
      "subdate": "Nov 22, 2024",
      "subcategory": "Social Services",
      "request_types": "",
      "visitcount": 44
   },
   "visits": {
      "storefront": 44,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 14,
      "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-11-22 16:06:50"
   },
   "location": {
      "uuid": "c8a4f692-a8eb-11ef-a909-b66e99367f32",
      "link_id": 338143,
      "account_id": 88862,
      "company": "Midtown Craftsmen LLC",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 22,
      "city": "10371",
      "zip": "49507",
      "address": "1600 Marshall Ave SE Suite A West Grand Rapids, MI 49507, USA",
      "phone": "616-245-5970",
      "fax": null,
      "email": "midtowncraftsmen06@gmail.com",
      "name": "Midtown Craftsmen LLC",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "42.9343473",
      "lon": "-85.6461531",
      "cityname": "Grand Rapids",
      "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": ""
}