Big Bully Turf

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348523,
      "site_id": 69,
      "cat_id": 65,
      "priority": 2,
      "url": "https://bigbullyturf.com/locations/scottsdale/",
      "title": "Big Bully Turf",
      "description": "At Big Bully Turf, it's not just about providing turf; it's about crafting an experience tailored for you. From the bustling city to the serene outskirts, Southern California, Las Vegas, Dallas, Phoenix and Scottsdale are places of contrasts, and the weather? Oh, each is a world of its own. We've understood that and made sure our offerings are not just unique but apt for these climates. Our expertise across diverse environments ensures you get the perfect artificial turf solution that thrives in your specific location's conditions.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 99218,
      "approve_dt": "2025-07-13T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-11T00: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": 3,
      "city_id": 1026,
      "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": 5192,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "4d38b6d6-46b6-11f0-a909-b66e99367f32",
      "subdate": "Jun 11, 2025",
      "subcategory": "Garden Landscaping",
      "request_types": "",
      "visitcount": 43
   },
   "visits": {
      "storefront": 43,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 16,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "At Big Bully Turf, it's not just about providing turf; it's about crafting an experience tailored for you. From the bustling city to the serene outskirts, Southern California and Las Vegas are places of contrasts, and the weather? Oh, it's a world of its own. We've understood that and made sure our offerings are not just unique but apt for these climates.\n
",
      "service1": "Climate-Specific Turf Installation",
      "service2": " Residential Artificial Grass",
      "service3": " Commercial Turf Solutions",
      "service4": " Custom Landscape Design",
      "service5": " Turf Maintenance Services",
      "service6": " Pet-Friendly Turf Systems",
      "service7": " Sports Field Installation",
      "submit_dt": "2025-06-11 11:22:04"
   },
   "location": {
      "uuid": "4d38b6d6-46b6-11f0-a909-b66e99367f32",
      "link_id": 348523,
      "account_id": 99218,
      "company": "Big Bully Turf",
      "sid": 69,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "1026",
      "zip": "85251",
      "address": "6900 East Camelback Rd, Unit 840",
      "phone": "602-671-3272",
      "fax": null,
      "email": "bigbullyturfaz@outlook.com",
      "name": "Big Bully Turf",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "33.5027295",
      "lon": "-111.932221",
      "cityname": "Scottsdale",
      "statename": "Arizona"
   },
   "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": ""
}