New Rüf

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 334566,
      "site_id": 67,
      "cat_id": 81,
      "priority": 2,
      "url": "https://newruf.com/",
      "title": "New Rüf",
      "description": "Located in the heart of Round Rock, TX, New Rf Roofing & Restoration sets the gold standard for roofing services in the region. From meticulous roof repairs to comprehensive roof replacements, we have you covered. Our services include roof design, repair, replacement, and expert inspection in Round Rock and the surrounding areas. As a licensed and fully insured company, we place the utmost importance on transparency, honesty, and dedication with every job. With thousands of successful projects under our belt, our reputation for quality roofing services and integrity speaks volumes.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 85321,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-08-26T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 3,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 22461,
      "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": 5047,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "1d342490-63d6-11ef-ab46-b66e99367f32",
      "subdate": "Aug 26, 2024",
      "subcategory": "Roofing Contractor",
      "request_types": "",
      "visitcount": 11
   },
   "visits": {
      "storefront": 11,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 1,
      "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-08-26 18:07:53"
   },
   "location": {
      "uuid": "1d342490-63d6-11ef-ab46-b66e99367f32",
      "link_id": 334566,
      "account_id": 85321,
      "company": "New Rüf",
      "sid": 67,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "22461",
      "zip": "78665",
      "address": "1100 N A W Grimes Blvd, Round Rock, TX 78665",
      "phone": "(512) 642-6005",
      "fax": null,
      "email": "newrufmarketing@gmail.com",
      "name": "New Rüf",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "30.530691",
      "lon": "-97.652976",
      "cityname": "Round Rock",
      "statename": "Texas"
   },
   "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": ""
}