Hoffman’s Concrete Construction

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 324720,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://hoffmansconcreteca.com",
      "title": "Hoffman’s Concrete Construction",
      "description": "Hoffmans Concrete Construction Inc., located in Murrieta, California, provides all your custom concrete needs. You can count on our versatile team to work with speed and accuracy. Our crew will work in a synchronized and conscientious manner that ensures precision. Our team understands the importance of completing stone and mortar projects correctly the first time, and we are just as dedicated to your project as you are.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 75722,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-04-27T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 32,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2265,
      "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": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "439a0a54-e4dc-11ed-b5b4-b66e99367f32",
      "subdate": "Apr 27, 2023",
      "subcategory": "Concrete Contractors",
      "request_types": "",
      "visitcount": 88
   },
   "visits": {
      "storefront": 88,
      "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": "Hoffmans Concrete Construction Inc., located in Murrieta, California, provides all your custom concrete needs. You can count on our versatile team to work with speed and accuracy. Our crew will work in a synchronized and conscientious manner that ensures precision. Our team understands the importance of completing stone and mortar projects correctly the first time, and we are just as dedicated to your project as you are.",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2023-04-27 09:16:59"
   },
   "location": {
      "uuid": "439a0a54-e4dc-11ed-b5b4-b66e99367f32",
      "link_id": 324720,
      "account_id": 75722,
      "company": "Hoffman’s Concrete Construction",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2265",
      "zip": "92563",
      "address": "39148 Via Pamplona",
      "phone": "951-698-8672",
      "fax": null,
      "email": "hoffmansconcreteca1@gmail.com",
      "name": "Hoffman’s Concrete Construction",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.5803152",
      "lon": "-117.1783791",
      "cityname": "Murrieta",
      "statename": "California"
   },
   "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": ""
}