Green Restoration of Westchester County

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 328782,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://www.gogreenrestoration.com/westchester-county",
      "title": "Green Restoration of Westchester County",
      "description": "Green Restoration of Westchester County proudly stands as your premier damage restoration contractor, dedicated to serving Mamaroneck, NY, and the wider Westchester area. Our extensive suite of services encompasses meticulous Water Damage Restoration, comprehensive Fire Damage Restoration, thorough Mold Removal, specialized Air Duct Cleaning, and effective Odor Removal. With a steadfast commitment to excellence, we utilize cutting-edge technology and industry-leading techniques to deliver unparalleled restoration solutions tailored to your specific needs. Count on Green Restoration to swiftly restore your property and ensure a safe, clean, and healthy environment for you and your loved ones.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 79611,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-02-29T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 26,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 31,
      "city_id": 15156,
      "ltop": "",
      "facebook": "https://www.facebook.com/greenrestorationgroup",
      "tiktok": null,
      "linkedin": "https://www.linkedin.com/company/greenrestorationgroup/",
      "twitter": "https://twitter.com/GreenRestoratio",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "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": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "86e73a60-d702-11ee-8344-b66e99367f32",
      "subdate": "Feb 29, 2024",
      "subcategory": "Water Restoration And Damage",
      "request_types": "",
      "visitcount": 85
   },
   "visits": {
      "storefront": 85,
      "articles": 0,
      "videos": 0,
      "reviews": 20,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Green Restoration of Westchester County proudly stands as your premier damage restoration contractor, dedicated to serving Mamaroneck, NY, and the wider Westchester area. Our extensive suite of services encompasses meticulous Water Damage Restoration, comprehensive Fire Damage Restoration, thorough Mold Removal, specialized Air Duct Cleaning, and effective Odor Removal. With a steadfast commitment to excellence, we utilize cutting-edge technology and industry-leading techniques to deliver unparalleled restoration solutions tailored to your specific needs. Count on Green Restoration to swiftly restore your property and ensure a safe, clean, and healthy environment for you and your loved ones.",
      "service1": "Water damage restoration service",
      "service2": "Air duct cleaning service",
      "service3": "Fire damage restoration service",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-02-29 13:00:34"
   },
   "location": {
      "uuid": "86e73a60-d702-11ee-8344-b66e99367f32",
      "link_id": 328782,
      "account_id": 79611,
      "company": "Green Restoration of Westchester County",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 31,
      "city": "15156",
      "zip": "10543",
      "address": "1163 Mamaroneck Ave",
      "phone": "9145592694",
      "fax": null,
      "email": "Gomamaroneck@outlook.com",
      "name": "Green Restoration of Westchester County",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.9627153",
      "lon": "-73.7359147",
      "cityname": "Mamaroneck",
      "statename": "New York"
   },
   "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": ""
}