Stamped Concrete Miami

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 321057,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.miamistampedconcrete.com",
      "title": "Stamped Concrete Miami",
      "description": "Stamped Concrete Miami is a contracting service that specializes in residential and commercial flooring products like stamped concrete, concrete pouring, patio installation, and driveway installation. We have established ourselves over many years as the leading service in Miami, we strive to provide the absolute best service and quality of the finished product for our customers that time after time leaves our customers wowed by the standard of our work.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 72249,
      "approve_dt": "2021-08-10T00:00:00.000Z",
      "source": null,
      "submit_dt": "2021-07-29T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 348,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 9,
      "city_id": 3739,
      "ltop": "",
      "facebook": "https://www.facebook.com/Stamped-Concrete-Miami-637894546689650/",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "https://www.youtube.com/channel/UCK9vdTTqDk-HZijPrD9qJzA",
      "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": 6646,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9582f007-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jul 29, 2021",
      "subcategory": "Construction",
      "request_types": "",
      "visitcount": 457
   },
   "visits": {
      "storefront": 457,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 5,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Stamped Concrete Miami is a contracting service that specializes in residential and commercial flooring products like stamped concrete, concrete pouring, patio installation and driveway installation. We have established ourselves over many years as the leading service in Miami, we strive to provide the absolute best service and quality of the finished product for our customers that time after time leaves our customers wowed by the standard of our work.",
      "service1": "Concrete Washing and Sealing",
      "service2": "Concrete Patios",
      "service3": "Concrete Driveways",
      "service4": "Stamped Concrete",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2021-07-29 03:58:53"
   },
   "location": {
      "uuid": "9582f007-56da-11ed-b77c-b66e99367f32",
      "link_id": 321057,
      "account_id": 72249,
      "company": "Stamped Concrete Miami",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 9,
      "city": "3739",
      "zip": "33145",
      "address": "3079 SW 18th St",
      "phone": "(786) 460-5197",
      "fax": null,
      "email": "lgant9393@gmail.com",
      "name": "Stamped Concrete Miami",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "25.7549565",
      "lon": "-80.244091",
      "cityname": "Miami",
      "statename": "Florida"
   },
   "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": ""
}