Roseville Concrete Company

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 336679,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "http://rosevilleconcretecompany.com",
      "title": "Roseville Concrete Company",
      "description": "Enhance your outdoor and indoor spaces with our expert concrete installation services. Specializing in stained concrete for vibrant, customized finishes and stamped concrete for elegant, textured designs, we deliver durable and aesthetically pleasing solutions. Whether you''re looking to elevate your driveway, patio, or flooring, our team ensures top-quality craftsmanship that stands the test of time. Contact us for reliable and professional concrete services today! Know more http://rosevilleconcretecompany.com",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 87412,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-10-12T00: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": 0,
      "city_id": 0,
      "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": 261,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "3270ef83-887d-11ef-ab46-b66e99367f32",
      "subdate": "Oct 12, 2024",
      "subcategory": "Consultants",
      "request_types": "",
      "visitcount": 14
   },
   "visits": {
      "storefront": 14,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Enhance your outdoor and indoor spaces with our expert concrete installation services. Specializing in stained concrete for vibrant, customized finishes and stamped concrete for elegant, textured designs, we deliver durable and aesthetically pleasing solutions. Whether you're looking to elevate your driveway, patio, or flooring, our team ensures top-quality craftsmanship that stands the test of time. Contact us for reliable and professional concrete services today! Know more http://rosevilleconcretecompany.com",
      "service1": "Concrete Pouring",
      "service2": "Concrete Installation",
      "service3": "Stamped Concrete",
      "service4": "Finish Concrete",
      "service5": "Stained Concrete",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-10-12 09:34:37"
   },
   "location": {
      "uuid": "3270ef83-887d-11ef-ab46-b66e99367f32",
      "link_id": 336679,
      "account_id": 87412,
      "company": "Roseville Concrete Company",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 0,
      "city": "",
      "zip": "95678",
      "address": "54 Atlantic St, Roseville, CA 95678",
      "phone": "(916) 500-7957 ",
      "fax": null,
      "email": "rosevilleconcretecompany0@gmail.com",
      "name": "Roseville Concrete Company",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "38.7491024",
      "lon": "-121.284824"
   },
   "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": ""
}