MainStreet Design Build

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 345011,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://mainstreetdesignbuild.com/",
      "title": "MainStreet Design Build",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95706,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-04-09T00: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": 22,
      "city_id": 10201,
      "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": 5844,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "0862e89b-1519-11f0-a909-b66e99367f32",
      "subdate": "Apr 09, 2025",
      "subcategory": "Bathroom Remodeling",
      "request_types": "",
      "visitcount": 24
   },
   "visits": {
      "storefront": 24,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "MainStreet Design Build stands as Michigan's premier design-build firm, with its headquarters nestled in Birmingham, MI. Our expertise spans Whole House Remodels, Room Additions, Kitchen&Bath Remodeling, Exterior Renovations, and Interior Design Services.\r
\r
When you remodel with MainStreet, your vision is trusted to an integrated team of architects, designers, interior designers, and skilled craftspeople collaborating harmoniously to craft your ideal remodel, ensuring transparent communication, timely delivery, and budget-friendly.",
      "service1": "Exterior Renovations",
      "service2": "Bathroom Remodeling",
      "service3": "Kitchen Remodeling",
      "service4": "Interior Design",
      "service5": "Interior Remodeling",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-04-09 08:02:50"
   },
   "location": {
      "uuid": "0862e89b-1519-11f0-a909-b66e99367f32",
      "link_id": 345011,
      "account_id": 95706,
      "company": "",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 22,
      "city": "10201",
      "zip": "48009",
      "address": "555 South Old Woodward Avenue",
      "phone": "+1 248-644-6330",
      "fax": null,
      "email": "mainstreetdesign@brite-post.com",
      "name": "",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "42.5426627",
      "lon": "-83.2099785",
      "cityname": "Birmingham",
      "statename": "Michigan"
   },
   "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": ""
}