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": "Indulge in luxury remodeling that elevates your everyday living with our complete in-house architectural design, interior design, and construction services. We bring transformative expertise to every project, creating stunning spaces tailored to your unique vision and budget. From concept through completion, our integrated approach ensures seamless execution, sophisticated results, and exceptional craftsmanship that turns your home into the extraordinary living environment you deserve.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95706,
      "approve_dt": "2025-10-16T00:00:00.000Z",
      "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": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "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": 36
   },
   "visits": {
      "storefront": 36,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 15,
      "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.\n
\n
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": "MainStreet Design Build",
      "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": ""
}