Brown Concrete and Backhoe

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 344678,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.brownconcreteandbackhoe.com/",
      "title": "Brown Concrete and Backhoe",
      "description": "Brown Concrete & Backhoe Inc.—Your Trusted Septic and Excavating Contractor\r\nFor over 30 years Brown Concrete & Backhoe Inc. has served the Cedar Rapids and Iowa City area with superior septic and excavating services. We take a common-sense approach to find our customers a cost-effective solution. Our goal is to exceed your expectations on every job, every day. Fair pricing and excellent service set us apart from our competitors. Our certified staff uses the most up-to-date equipment to complete your project on time with minimal disruption and inconvenience.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95373,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-04-02T00: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": 15,
      "city_id": 7112,
      "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": 5883,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "8f847054-0f9b-11f0-a909-b66e99367f32",
      "subdate": "Apr 02, 2025",
      "subcategory": "Septic Tanks",
      "request_types": "",
      "visitcount": 35
   },
   "visits": {
      "storefront": 35,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 13,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Brown Concrete&Backhoe Inc."Your Trusted Septic and Excavating Contractor\r
For over 30 years Brown Concrete&Backhoe Inc. has served the Cedar Rapids and Iowa City area with superior septic and excavating services. We take a common-sense approach to find our customers a cost-effective solution. Our goal is to exceed your expectations on every job, every day. Fair pricing and excellent service set us apart from our competitors. Our certified staff uses the most up-to-date equipment to complete your project on time with minimal disruption and inconvenience.",
      "service1": "septic system installation",
      "service2": "septic system maintenance and pumping",
      "service3": "excavating service",
      "service4": "commercial excavating services",
      "service5": "residential excavating services",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-04-02 08:22:05"
   },
   "location": {
      "uuid": "8f847054-0f9b-11f0-a909-b66e99367f32",
      "link_id": 344678,
      "account_id": 95373,
      "company": "Brown Concrete and Backhoe",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 15,
      "city": "7112",
      "zip": "52404",
      "address": "2885 120th Street Northeast",
      "phone": "+1 319-848-4222",
      "fax": null,
      "email": "brownconcretebh@brite-post.com",
      "name": "Brown Concrete and Backhoe",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "41.8474719",
      "lon": "-91.6482893",
      "cityname": "Cedar Rapids",
      "statename": "Iowa"
   },
   "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": ""
}