Professional Sidewalk Repair Contractors in Queens

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 328580,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.sidewalkrepairqueens.com/",
      "title": "Professional Sidewalk Repair Contractors in Queens",
      "description": "Sidewalk Repair Queens is a locally owned and operated business providing sidewalk repair services to the community for over 20 years. We pride our work and guarantee that your sidewalk will be repaired to your satisfaction. The sidewalk is an essential part of the community. It provides a safe and convenient way for pedestrians to get around. However, sidewalks can quickly become damaged by weather and wear and tear. When this happens, it''s important to have a sidewalk repair company that you can rely on. Contact us today for a free quote.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 79415,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-02-22T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 18,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 31,
      "city_id": 15261,
      "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": 5851,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "85576469-d155-11ee-8344-b66e99367f32",
      "subdate": "Feb 22, 2024",
      "subcategory": "Concrete Contractors",
      "request_types": "",
      "visitcount": 76
   },
   "visits": {
      "storefront": 76,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 15,
      "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-02-22 07:39:33"
   },
   "location": {
      "uuid": "85576469-d155-11ee-8344-b66e99367f32",
      "link_id": 328580,
      "account_id": 79415,
      "company": "Professional Sidewalk Repair Contractors in Queens",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 31,
      "city": "15261",
      "zip": "11361",
      "address": "34-16 Clearview Expy Bayside",
      "phone": "7185446411",
      "fax": null,
      "email": "elizzaellia@gmail.com",
      "name": "Professional Sidewalk Repair Contractors in Queens",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.7677115",
      "lon": "-73.7825576",
      "cityname": "New York",
      "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": ""
}