https://www.gogreenrestoration.com/orange

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 330361,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://www.gogreenrestoration.com/orange",
      "title": "https://www.gogreenrestoration.com/orange",
      "description": "Green Restoration of Orange is here to provide reliable, fast and cost-effective damage restoration and cleaning solutions to Orange, CT and New Haven County. Offering 30+ years combined experience, we are locally owned/operated, and whether you need water damage or storm damage restoration, hurricane damage or flood damage restoration, mold remediation, fire damage or smoke damage restoration, biohazard clean up, air duct cleaning or air quality control services, we’ve got your back! We’ll take immediate action to restore your property to its original state as quickly as possible. Green Restoration of Orange is doing our part to ‘right the wrong’ and reverse the path of destruction. We pride ourselves on the use of renewable energy. Contact us today!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 81170,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-04-30T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 3,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 7,
      "city_id": 3123,
      "ltop": "",
      "facebook": "https://www.facebook.com/greenrestorationgroup",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "https://www.youtube.com/@greenrestoration4553",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "https://www.instagram.com/greenrestoration/",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 6468,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "e0260df6-06a4-11ef-8344-b66e99367f32",
      "subdate": "Apr 30, 2024",
      "subcategory": "Water Restoration And Damage",
      "request_types": "",
      "visitcount": 28
   },
   "visits": {
      "storefront": 28,
      "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": "Green Restoration of Orange is here to provide reliable, fast and cost-effective damage restoration and cleaning solutions to Orange, CT and New Haven County. Offering 30+ years combined experience, we are locally owned/operated, and whether you need water damage or storm damage restoration, hurricane damage or flood damage restoration, mold remediation, fire damage or smoke damage restoration, biohazard clean up, air duct cleaning or air quality control services, weve got your back! Well take immediate action to restore your property to its original state as quickly as possible. Green Restoration of Orange is doing our part to right the wrong and reverse the path of destruction. We pride ourselves on the use of renewable energy. Contact us today!",
      "service1": "air duct cleaning",
      "service2": "asbestos removal",
      "service3": "mold removal",
      "service4": "mold remediation",
      "service5": "fire damage restoration",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-04-30 03:51:07"
   },
   "location": {
      "uuid": "e0260df6-06a4-11ef-8344-b66e99367f32",
      "link_id": 330361,
      "account_id": 81170,
      "company": "Green Restoration of Orange ",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 7,
      "city": "3123",
      "zip": "06477",
      "address": "",
      "phone": "2034933677",
      "fax": null,
      "email": "Gogreenorange@outlook.com",
      "name": "Green Restoration of Orange ",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": null,
      "lon": null,
      "cityname": "Orange",
      "statename": "Connecticut"
   },
   "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": ""
}