California On-Site Welding

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 345065,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.californiaonsitewelding.com/",
      "title": "California On-Site Welding",
      "description": "California On-Site Welding provides expert AWS-certified welding services across Riverside, San Bernardino, Orange County, San Diego, and Los Angeles. With over 40 years of experience, we specialize in structural welding, pipe welding, steel welding, column repair, and heavy equipment welding. Our mobile welding service is available 24/7, ensuring fast, reliable solutions for industrial, commercial, and residential clients. Whether you need emergency repairs or precision welding, trust our expertise to get the job done right.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95760,
      "approve_dt": "2025-10-15T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-04-10T00: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": 5,
      "city_id": 1755,
      "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": 288,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "a5d4b20b-15ce-11f0-a909-b66e99367f32",
      "subdate": "Apr 10, 2025",
      "subcategory": "Home And Garden",
      "request_types": "",
      "visitcount": 19
   },
   "visits": {
      "storefront": 19,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 7,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "California On-Site Welding delivers AWS-certified mobile welding services across Orange County, Riverside, and San Diego County with over 40 years of proven expertise. Trusted by building contractors, municipalities, property managers, and major clients like Home Depot and Riverside Water District, we provide superior craftsmanship at competitive prices. From emergency repairs to large-scale commercial projects, our experienced team brings reliable, high-quality welding directly to your location.",
      "service1": "Mobile Welding",
      "service2": " Pipe Welding",
      "service3": " Structural & Column Repair",
      "service4": " Equipment Repair & Emergency Welding",
      "service5": " Plasma Arc Cutting",
      "service6": " Machinery Welding",
      "service7": " Commercial & Industrial Welding",
      "submit_dt": "2025-04-10 05:42:53"
   },
   "location": {
      "uuid": "a5d4b20b-15ce-11f0-a909-b66e99367f32",
      "link_id": 345065,
      "account_id": 95760,
      "company": "California On-Site Welding",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "1755",
      "zip": "92587",
      "address": "Canyon Lake, CA",
      "phone": "(909) 208-2179",
      "fax": null,
      "email": "caonsitewelding@gmail.com",
      "name": "California On-Site Welding",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "33.6850215",
      "lon": "-117.2730931",
      "cityname": "Canyon Lake",
      "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": ""
}