My Color Magic Painting

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348220,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.mycolormagicpainting.com/",
      "title": "My Color Magic Painting",
      "description": "My Color Magic Painting is a licensed, fully insured, OSHA-trained, and certified contractor that understands our clients' needs and takes them into account to produce a high-quality result that everyone, especially the customer, can be proud of. We consistently communicate with our clients throughout the entire project to reach your vision as closely as possible, even as that vision evolves over time. With over 7 years of experience, we are ready to paint your house or facility with a high level of skill and professionalism. When you work with us, you'll find that we're prompt, courteous, and ready to provide you with quality service at every step of your project.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 98915,
      "approve_dt": "2025-07-16T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-05T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 21,
      "city_id": 10115,
      "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": 5875,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "fb10fc5f-41e8-11f0-a909-b66e99367f32",
      "subdate": "Jun 05, 2025",
      "subcategory": "Painting Contractors",
      "request_types": "",
      "visitcount": 41
   },
   "visits": {
      "storefront": 41,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 10,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "My Color Magic Painting is a professional painting company with over 7 years of experience satisfying the needs of both residential and commercial clients, committed to delivering a satisfying customer experience and high-quality paint jobs that clients can be proud of. Their dedication to excellence ensures that every building project receives expert craftsmanship and attention to detail, creating beautiful and lasting results for homes and businesses alike.",
      "service1": "residential painting",
      "service2": " commercial painting",
      "service3": " interior painting",
      "service4": " exterior painting",
      "service5": " building restoration",
      "service6": " color consultation",
      "service7": " professional paint application",
      "submit_dt": "2025-06-05 08:42:14"
   },
   "location": {
      "uuid": "fb10fc5f-41e8-11f0-a909-b66e99367f32",
      "link_id": 348220,
      "account_id": 98915,
      "company": "My Color Magic Painting",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 21,
      "city": "10115",
      "zip": "02472",
      "address": "49 Clarendon St",
      "phone": "(781) 530-6324",
      "fax": null,
      "email": "mycolormgic@mail-burst.com",
      "name": "My Color Magic Painting",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "42.3651171",
      "lon": "-71.1536025",
      "cityname": "Watertown",
      "statename": "Massachusetts"
   },
   "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": ""
}