Ritter General Contracting

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 337317,
      "site_id": 65,
      "cat_id": 76,
      "priority": 2,
      "url": "https://rittergc.com",
      "title": "Ritter General Contracting",
      "description": "Ritter General Contracting stands as a recognized leader in residential and commercial construction, specializing in custom homes, general contracting services, and restoration solutions. Leveraging over two decades of industry expertise, Ritter''s team is poised to bring any construction vision to life, adhering to a philosophy centered around customer satisfaction, excellence in craftsmanship, and an unwavering commitment to detail. The company caters to a wide range of construction needs, including innovative custom homes, comprehensive general contracting services for both residential and commercial projects, and specialized restoration services for properties affected by disaster. Furthermore, Ritter''s commitment to integrating the latest design trends, technology, and a keen understanding of local codes and regulations ensures each project not only meets but exceeds client expectations. With a wide service area spanning several major counties and cities within Michigan, Ritter General Contracting embodies a premium choice for discerning clients looking to embark on their next construction or renovation journey.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 88048,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-10-26T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 13,
      "city_id": 5120,
      "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": 4936,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "e6b485c3-93c2-11ef-ab46-b66e99367f32",
      "subdate": "Oct 26, 2024",
      "subcategory": "Bird Control",
      "request_types": "",
      "visitcount": 23
   },
   "visits": {
      "storefront": 23,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 6,
      "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-10-26 17:51:17"
   },
   "location": {
      "uuid": "e6b485c3-93c2-11ef-ab46-b66e99367f32",
      "link_id": 337317,
      "account_id": 88048,
      "company": "Ritter General Contracting",
      "sid": 65,
      "country": 277,
      "countrycode": "US",
      "state": 13,
      "city": "5120",
      "zip": "48083",
      "address": "1470 Souter Boulevard, Suite C, Troy, MI 48083",
      "phone": "",
      "fax": null,
      "email": "UFsFbr5C.directory@usestyle.ai",
      "name": "Ritter General Contracting",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "42.5477228",
      "lon": "-83.1287649",
      "cityname": "Aviston",
      "statename": "Illinois"
   },
   "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": ""
}