Big Bully Turf

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 341389,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://bigbullyturf.com/locations/san-diego",
      "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 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.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 92084,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-01-25T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 3,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2452,
      "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": 4201,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "aa60c662-daef-11ef-a909-b66e99367f32",
      "subdate": "Jan 25, 2025",
      "subcategory": "Landscaping",
      "request_types": "",
      "visitcount": 18
   },
   "visits": {
      "storefront": 18,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 5,
      "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.",
      "service1": "Artificial Grass",
      "service2": "Artificial Grass Installation",
      "service3": "Artificial Turf",
      "service4": "Turf Installation",
      "service5": "Hardscape",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-01-25 07:40:36"
   },
   "location": {
      "uuid": "aa60c662-daef-11ef-a909-b66e99367f32",
      "link_id": 341389,
      "account_id": 92084,
      "company": "Big Bully Turf",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2452",
      "zip": "92101",
      "address": "350 Tenth Ave, Suite 820",
      "phone": "619-371-9870",
      "fax": null,
      "email": "bigbullyturfsandiego@gmail.com",
      "name": "Big Bully Turf",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "32.7088676",
      "lon": "-117.1560246",
      "cityname": "San Diego",
      "statename": "California"
   },
   "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": ""
}