Sparklez Jewelry & Loan

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 325176,
      "site_id": 55,
      "cat_id": 63,
      "priority": 2,
      "url": "https://www.sparklez.com/",
      "title": "Sparklez Jewelry & Loan",
      "description": "Established in 1986, Sparklez Jewelry and  Loan is a family owned and operated, full service jewelry store. We carry fashion jewelry, estate, vintage and antique jewelry, diamonds, watches and coins. In Pittsburgh, see the pros at Sparklez Jewelery and Loan whenever buying or selling jewelry. Unlike ordinary jewelry stores and gold buyers, we can also make loans on jewelry and other items of value. We have a reputation for straight talk, honesty confidentiality and professional integrity. We are also known for our low prices. To know more, visit our website today.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 76143,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-06-23T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 31,
      "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": 3879,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "7b090837-11a3-11ee-b5b4-b66e99367f32",
      "subdate": "Jun 23, 2023",
      "subcategory": "Jewelry Stores",
      "request_types": "",
      "visitcount": 85
   },
   "visits": {
      "storefront": 85,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Established in 1986, Sparklez Jewelry and  Loan is a family owned and operated, full service jewelry store. We carry fashion jewelry, estate, vintage and antique jewelry, diamonds, watches and coins. In Pittsburgh, see the pros at Sparklez Jewelery and Loan whenever buying or selling jewelry. Unlike ordinary jewelry stores and gold buyers, we can also make loans on jewelry and other items of value. We have a reputation for straight talk, honesty confidentiality and professional integrity. We are also known for our low prices. To know more, visit our website today.",
      "service1": "Pawn Shops",
      "service2": "Jewelry Pawn Shop",
      "service3": "Estate Jewelry",
      "service4": "Buy Engagement Rings",
      "service5": "Jewelry Store",
      "service6": "Jewelry & watches",
      "service7": "Diamond Jewelry",
      "submit_dt": "2023-06-23 08:53:53"
   },
   "location": {
      "uuid": "7b090837-11a3-11ee-b5b4-b66e99367f32",
      "link_id": 325176,
      "account_id": 76143,
      "company": "Sparklez Jewelry & Loan",
      "sid": 55,
      "country": 277,
      "countrycode": "US",
      "state": 37,
      "city": "19714",
      "zip": "15234",
      "address": "475 Mt Lebanon Blvd",
      "phone": "(412) 835-8805",
      "fax": null,
      "email": "Sparklezllc15@gmail.com",
      "name": "Sparklez Jewelry & Loan",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.3697035",
      "lon": "-80.0313417",
      "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": ""
}