Fireplace sales and service

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 346313,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.royalfireplace.biz/",
      "title": "Fireplace sales and service",
      "description": "Royal Fireplace & Chimney is the best choice for fireplace and chimney services in the San Gabriel Valley. We install and service fireplaces/fireboxes, clean barbecues, and inspect, repair, and sweep chimneys. At our beautiful showroom, youll find an extensive selection of premium fireplace glass doors, fireboxes, mantels, gas logs, firepits, bbq grills, gas heaters, mailboxes, and fireplace accessories, such as chimney caps, meshes, screens, chimney pipes, dampers, and more. We are a small, family-owned company with over 30 years of experience and an excellent reputation. Visit us today. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 97008,
      "approve_dt": "2025-08-13T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-02T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2337,
      "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": 5732,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "e92b1973-274e-11f0-a909-b66e99367f32",
      "subdate": "May 02, 2025",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 7
   },
   "visits": {
      "storefront": 7,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 4,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "San Gabriel Valley's premier fireplace, chimney, and BBQ grill experts with over 30 years of family-owned experience serving Pasadena, La Canada, Arcadia, Alhambra, and surrounding cities. Royal Fireplace & Chimney provides honest guidance and expert recommendations, featuring the largest selection of trusted brands like Rasmussen, Real Fyre, Fire Magic, and Napoleon in their beautiful Pasadena showroom.",
      "service1": "fireplace installation and repair",
      "service2": " chimney sweeping and cleaning",
      "service3": " chimney inspection and smoke testing",
      "service4": " BBQ grill installation and service",
      "service5": " custom fireplace mantel design",
      "service6": " gas log and firebox installation",
      "service7": " chimney cap and damper replacement",
      "submit_dt": "2025-05-02 12:13:52"
   },
   "location": {
      "uuid": "e92b1973-274e-11f0-a909-b66e99367f32",
      "link_id": 346313,
      "account_id": 97008,
      "company": "Fireplace sales and service",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2337",
      "zip": "91106",
      "address": "1766 E. Colorado Blvd. Pasadena, CA 91106",
      "phone": "626) 795-2100",
      "fax": null,
      "email": "royalfireplacemktg@gmail.com",
      "name": "Fireplace sales and service",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "34.1457826",
      "lon": "-118.1139983",
      "cityname": "Pasadena",
      "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": ""
}