NYC Roofing Construction - GreenTree Construction, Inc.

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 313003,
      "site_id": 67,
      "cat_id": 81,
      "priority": 2,
      "url": "http://greentreenyc.com/ ",
      "title": "NYC Roofing Construction - GreenTree Construction, Inc.",
      "description": "Greentree Construction was formed by contractors who come from generations of remodeling experience. Whether it is a brand new construction or even additional construction to existing structures, we have the experience to complete the job.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 64235,
      "approve_dt": "2017-01-29T00:00:00.000Z",
      "source": null,
      "submit_dt": "2017-01-29T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 1864,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 31,
      "city_id": 25389,
      "ltop": "",
      "facebook": "https://www.facebook.com/GreentreeConstructionInc/",
      "tiktok": null,
      "linkedin": "https://www.linkedin.com/in/greentree-construction-4b1bbb6a",
      "twitter": "https://twitter.com/greentreenyc",
      "googleplus": "https://plus.google.com/104248849565981854804/about ",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "https://www.instagram.com/greentree_construction_nyc/",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 5047,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "jpg",
      "pack_id": null,
      "uuid": "9558d092-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jan 29, 2017",
      "subcategory": "Roofing Contractor",
      "request_types": "",
      "visitcount": 2194
   },
   "visits": {
      "storefront": 2194,
      "articles": 0,
      "videos": 0,
      "reviews": 12,
      "coupons": 0,
      "products": 259,
      "social": 27,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "At GreenTree Construction our approach is to give the customer the most cost-effective solution to the project, making sure the construction is meeting our high standards and that the needs of our client are being met. Whether it is a brand new construction or even additional construction to existing structures, we have the manpower, the experience and the expertise to complete the job efficiently and quickly. \n

\nOur professional team of trained construction specialists can offer you excellent consultation on all your projects, whether it is an idea you have been interested in or a design that you finally want implemented. Quality construction means delivering a final superior product and working in a professional way.",
      "service1": "Basement Construction",
      "service2": "Bathroom Construction",
      "service3": "Window Installation",
      "service4": "Kitchen Construction",
      "service5": "Siding Installation",
      "service6": "Roofing Construction",
      "service7": "",
      "submit_dt": "2017-01-29 05:49:35"
   },
   "location": {
      "uuid": "9558d092-56da-11ed-b77c-b66e99367f32",
      "link_id": 313003,
      "account_id": 64235,
      "company": "GreenTree Construction, Inc.",
      "sid": 67,
      "country": 277,
      "countrycode": "US",
      "state": 31,
      "city": "25389",
      "zip": "11362",
      "address": "54-50 Little Neck Parkway, Suite 2,",
      "phone": "(888) 619-2677",
      "fax": null,
      "email": "victoria@greentreenyc.com",
      "name": "GreenTree Construction, Inc.",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.7657037",
      "lon": "-73.7251194",
      "cityname": "Little Neck",
      "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": 2
      },
      {
         "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": ""
}