Walsh's Remodeling

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 353408,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "http://walshsremodeling.com/",
      "title": "Walsh's Remodeling",
      "description": "Walsh's Remodeling is a Charlottesville, VA home remodeling company specializing in kitchen remodeling, bathroom remodeling, basement finishing, and whole home renovations. Our team delivers full-service residential remodeling, handling design, planning, and construction with a focus on quality craftsmanship and clear communication. From custom kitchens to modern bathroom upgrades, each project is tailored to your goals. Known for reliable service and clean job sites, Walsh's Remodeling creates functional, high-value living spaces that enhance comfort and increase home value.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 104193,
      "approve_dt": "2026-05-11T00:00:00.000Z",
      "source": null,
      "submit_dt": "2026-05-11T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 45,
      "city_id": 23204,
      "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": 5878,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "6598c8e7-4cd6-11f1-bb42-b66e99367f32",
      "subdate": "May 11, 2026",
      "subcategory": "Renovations",
      "request_types": "",
      "visitcount": 1
   },
   "visits": {
      "storefront": 1,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 0,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Business Hours:

\nMon: 09:00 - 16:30
\nTue: 09:00 - 16:30
\nWed: 09:00 - 16:30
\nThu: 09:00 - 16:30
\nFri: 09:00 - 16:30
\nSat: Closed 
\nSun: Closed
\n

\nFor more information, please contact us with the details below:
\n

\nContact Telephone:
\n+1 434-207-8788
\n

",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2026-05-11 01:11:53"
   },
   "location": {
      "uuid": "6598c8e7-4cd6-11f1-bb42-b66e99367f32",
      "link_id": 353408,
      "account_id": 104193,
      "company": "Walsh's Remodeling",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 45,
      "city": "23204",
      "zip": "22901",
      "address": "1147 River Road",
      "phone": "(434) 207-8788",
      "fax": null,
      "email": "walshsremodling@brite-post.com",
      "name": "Luxury Home Remodeling in Charlottesville & Albemarle County",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Charlottesville",
      "statename": "Virginia"
   },
   "socialmedia": [
      {
         "title": "Facebook",
         "ptype_id": 29,
         "dbtable": "links_socialmedia",
         "item": "Facebook",
         "cnt": null
      },
      {
         "title": "Instagram",
         "ptype_id": 30,
         "dbtable": "links_socialmedia",
         "item": "Instagram",
         "cnt": null
      },
      {
         "title": "Youtube",
         "ptype_id": 31,
         "dbtable": "links_socialmedia",
         "item": "Youtube Video",
         "cnt": null
      },
      {
         "title": "LinkedIn",
         "ptype_id": 32,
         "dbtable": "links_socialmedia",
         "item": "LinkedIn",
         "cnt": null
      },
      {
         "title": "TikTok",
         "ptype_id": 33,
         "dbtable": "links_socialmedia",
         "item": "TikTok",
         "cnt": null
      },
      {
         "title": "Twitter",
         "ptype_id": 34,
         "dbtable": "links_socialmedia",
         "item": "Twitter",
         "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": ""
}