LandscapeGardens

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348371,
      "site_id": 69,
      "cat_id": 65,
      "priority": 2,
      "url": "https://www.landscape-gardens.com/",
      "title": "LandscapeGardens",
      "description": "Landscape Gardens is a full-service, turn-key landscaping company in Bloomfield that provides comprehensive outdoor solutions from design through maintenance. Their professional team combines skilled landscape architects, experienced crews, and dedicated project managers to deliver precision work with clear communication and attention to detail. They specialize in creating seamless, professional experiences that transform outdoor spaces to match clients' visions without the frustration of typical contractor issues.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 99066,
      "approve_dt": "2025-07-14T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-09T00: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": 22,
      "city_id": 10715,
      "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": 5190,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "c3ace40f-450a-11f0-a909-b66e99367f32",
      "subdate": "Jun 09, 2025",
      "subcategory": "Landscape Contractors",
      "request_types": "",
      "visitcount": 60
   },
   "visits": {
      "storefront": 60,
      "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": "At Landscape Gardens, we do things differently. As your full-service, turn-key landscaping partner in Bloomfield, we bring together professional landscape architects, skilled crews, and dedicated project managers. From design to build to maintenance, we handle every phase with precision, clear communication, and care-so you can enjoy a seamless, professional experience from start to finish.",
      "service1": "Landscape Design",
      "service2": "Landscape Construction",
      "service3": "Outdoor Living",
      "service4": "Landscaping",
      "service5": "Pool Design build",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-06-09 08:21:38"
   },
   "location": {
      "uuid": "c3ace40f-450a-11f0-a909-b66e99367f32",
      "link_id": 348371,
      "account_id": 99066,
      "company": "Landscape Gardens",
      "sid": 69,
      "country": 277,
      "countrycode": "US",
      "state": 22,
      "city": "10715",
      "zip": "48083",
      "address": "1328 Wheaton Avenue",
      "phone": "+1 248-364-3900",
      "fax": null,
      "email": "landscapegardens@brite-email.com",
      "name": "Landscape Gardens",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "42.5571676",
      "lon": "-83.1234284",
      "cityname": "Troy",
      "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": ""
}