SF Marble Granite

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 330346,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://sfmarbleandgraniteinc.com/",
      "title": "SF Marble Granite",
      "description": "We are all tempted by natural stone countertops in our kitchen to increase aesthetics. There is no doubt that marble and granite countertops are expensive and easily stand any stain or exertion, but a minor scratch quickly sabotages their beauty.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 81155,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-04-29T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 8,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 21,
      "city_id": 9999,
      "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": 2854,
      "subcat_id": 5867,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "4d8da087-065b-11ef-8344-b66e99367f32",
      "subdate": "Apr 29, 2024",
      "subcategory": "Interior Designers",
      "request_types": "",
      "visitcount": 42
   },
   "visits": {
      "storefront": 42,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 7,
      "services": 16,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We are all tempted by natural stone countertops in our kitchen to increase aesthetics. There is no doubt that marble and granite countertops are expensive and easily stand any stain or exertion, but a minor scratch quickly sabotages their beauty.\r
",
      "service1": "Granite installation",
      "service2": "Granite Repair",
      "service3": "Marble",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-04-29 19:04:28"
   },
   "location": {
      "uuid": "4d8da087-065b-11ef-8344-b66e99367f32",
      "link_id": 330346,
      "account_id": 81155,
      "company": "SF Marble Granite",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 21,
      "city": "9999",
      "zip": "01854",
      "address": "755 Dutton St. Lowell- 0185MA4",
      "phone": "9784595823",
      "fax": null,
      "email": "sfmarbleangranite@gmail.com",
      "name": "SF Marble Granite",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "42.6409059",
      "lon": "-71.3212481",
      "cityname": "Lowell",
      "statename": "Massachusetts"
   },
   "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": 1
      },
      {
         "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": ""
}