R&RPlumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 329712,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://murrieta-plumber.com/",
      "title": "R&RPlumbing",
      "description": "R&R Murrieta Plumbing offers professional and affordable 5-STAR Murrieta plumbing services. Our master plumbers have experience with all your residential or commercial plumbing problems. We are a 15-hour-a-day, seven-day-a-week plumber. We offer slab leak detection, water heater installation, and drain cleaning. We also provide sewer repairs, leak detection, and general plumbing repairs. We are Licensed and insured to offer plumbing for Murrieta, CA, and all of Riverside County.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 80525,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-04-06T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 24,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2265,
      "ltop": "",
      "facebook": "https://www.facebook.com/randrplumbingservice/",
      "tiktok": null,
      "linkedin": "https://www.linkedin.com/in/ryan-ruch-4327134a",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "https://www.instagram.com/rrplumbingservices/",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 5026,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "8df74281-f46c-11ee-8344-b66e99367f32",
      "subdate": "Apr 06, 2024",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 91
   },
   "visits": {
      "storefront": 91,
      "articles": 0,
      "videos": 0,
      "reviews": 16,
      "coupons": 0,
      "products": 0,
      "social": 6,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "R&R Murrieta Plumbing offers professional and affordable 5-STAR Murrieta plumbing services. Our master plumbers have experience with all your residential or commercial plumbing problems. We are a 15-hour-a-day, seven-day-a-week plumber. We offer slab leak detection, water heater installation, and drain cleaning. We also provide sewer repairs, leak detection, and general plumbing repairs. We are Licensed and insured to offer plumbing for Murrieta, CA, and all of Riverside County.",
      "service1": "Slab Leak Repair",
      "service2": "Garbage Disposal Repair",
      "service3": "Clogged Drain Repair",
      "service4": "Bathroom Remodeling",
      "service5": "Water Heater Replacement",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-04-06 23:22:37"
   },
   "location": {
      "uuid": "8df74281-f46c-11ee-8344-b66e99367f32",
      "link_id": 329712,
      "account_id": 80525,
      "company": "R&R Plumbing",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2265",
      "zip": "92562",
      "address": "26398 Deere Ct, Unit 102",
      "phone": "(951) 234-7223",
      "fax": null,
      "email": "rrplumbing@mail-burst.com",
      "name": "R&R Plumbing",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.5321547",
      "lon": "-117.1819788",
      "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": ""
}