Valley & Aetna Building Supplies Hartford

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 338089,
      "site_id": 67,
      "cat_id": 81,
      "priority": 2,
      "url": "https://valleybuilding.net/",
      "title": "Valley & Aetna Building Supplies Hartford",
      "description": "Valley & Aetna Building Products is a trusted wholesale distributor of building materials and roofing supplies in Hartford, CT. We offer a wide range of products including Atlas roofing, siding, windows, doors, decking, PVC trim, and railing to meet the needs of contractors and homeowners. With years of experience, our team provides high-quality materials and excellent customer service, making us a reliable choice for all your building and roofing needs in Hartford.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 88808,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-11-21T00: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": 7,
      "city_id": 3077,
      "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": 5046,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "45e68598-a818-11ef-a909-b66e99367f32",
      "subdate": "Nov 21, 2024",
      "subcategory": "Roofing",
      "request_types": "",
      "visitcount": 35
   },
   "visits": {
      "storefront": 35,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 13,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-11-21 14:52:47"
   },
   "location": {
      "uuid": "45e68598-a818-11ef-a909-b66e99367f32",
      "link_id": 338089,
      "account_id": 88808,
      "company": "Valley & Aetna Building Supplies Hartford",
      "sid": 67,
      "country": 277,
      "countrycode": "US",
      "state": 7,
      "city": "3077",
      "zip": "06108",
      "address": "225 Prospect Street",
      "phone": "860-528-9552",
      "fax": null,
      "email": "valleyaetnahartford@burst-email.com",
      "name": "Valley & Aetna Building Supplies Hartford",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "41.7758015",
      "lon": "-72.645395",
      "cityname": "East Hartford",
      "statename": "Connecticut"
   },
   "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": ""
}