tedeschiplumbing.com

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 335123,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.tedeschiplumbing.com",
      "title": "tedeschiplumbing.com",
      "description": "Tedeschi Plumbing Service, LLC. is a full service residential plumbing service company. We pride ourselves on providing efficient, professional and neat work to our customers. Our company services the greater Pittsburgh area.Sewer line repairs and replacementSewer video inspectionsWaterline repairFaucet repair replace installFrench drains interior & exteriorPlumbing inspectionLaundry tubs and boxesBathroom & kitchen rough-insToilet repairs replace installVideo inspect sewer and locateDrain cleaning, repair & installSnakingRepair replace hot water tanksInstall tankless water tanksGas and water line repair & installationDye testSump pumpsFrench DrainsHose bibsThawing Frozen PipesPressure Reducing ValvesThermal expansion tanksDual check valvesIsolation valvesDownspout drainsTub & shower valves & drainsPressure booster pumpsGarbage disposal replacementAll general plumbing",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 85868,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-09-09T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 7,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 37,
      "city_id": 19714,
      "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": 5018,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "692d48cf-6e71-11ef-ab46-b66e99367f32",
      "subdate": "Sep 09, 2024",
      "subcategory": "General Plumbing",
      "request_types": "",
      "visitcount": 36
   },
   "visits": {
      "storefront": 36,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 14,
      "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-09-09 06:04:44"
   },
   "location": {
      "uuid": "692d48cf-6e71-11ef-ab46-b66e99367f32",
      "link_id": 335123,
      "account_id": 85868,
      "company": "tedeschiplumbing.com",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 37,
      "city": "19714",
      "zip": "15101",
      "address": "3812 William Flynn Hwy ",
      "phone": "(412) 486-1299",
      "fax": null,
      "email": "Tedeschiplumbingservices0@gmail.com",
      "name": "tedeschiplumbing.com",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "40.5568743",
      "lon": "-79.9581064",
      "cityname": "Pittsburgh",
      "statename": "Pennsylvania"
   },
   "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": ""
}