Blues Crews Roofing & Gutters

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 345538,
      "site_id": 67,
      "cat_id": 81,
      "priority": 2,
      "url": "https://thebluescrews.com/",
      "title": "Blues Crews Roofing & Gutters",
      "description": "Blues Crews Roofing %38 Gutters is your go-to source for quality roofing solutions in San Antonio, Texas. Our skilled team specializes in san antonio roof replacement, ensuring that every project meets the highest standards of craftsmanship and durability. We understand that your home is a significant investment, and we are committed to providing top-notch service that protects this investment. With our expertise in the San Antonio climate, we tailor our roofing options to withstand local weather conditions, giving you peace of mind no matter what Mother Nature throws your way. Whether it''s time for a new roof or an upgrade to your gutter system, trust Blues Crews Roofing %38 Gutters to deliver exceptional results with professionalism and efficiency.Services: RoofingHours: Mon-Sat: 08:00-20:00",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 96233,
      "approve_dt": "2025-09-15T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-04-17T00: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": 42,
      "city_id": 22482,
      "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": 5103,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "d5519a94-1ba9-11f0-a909-b66e99367f32",
      "subdate": "Apr 17, 2025",
      "subcategory": "Roofers",
      "request_types": "",
      "visitcount": 15
   },
   "visits": {
      "storefront": 15,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 4,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Blue Crews Roofing provides trusted, high-quality roofing services for homes and businesses across San Antonio and nearby areas. Built on a foundation of craftsmanship and community, they deliver durable solutions designed to protect your property and give you peace of mind.",
      "service1": "Roof Inspections",
      "service2": " Roof Repairs",
      "service3": " Roof Replacements",
      "service4": " New Roof Installation",
      "service5": " Commercial Roofing Services",
      "service6": " Emergency Roofing Repairs",
      "service7": " Preventative Roof Maintenance",
      "submit_dt": "2025-04-17 16:34:29"
   },
   "location": {
      "uuid": "d5519a94-1ba9-11f0-a909-b66e99367f32",
      "link_id": 345538,
      "account_id": 96233,
      "company": "Blues Crews Roofing & Gutters",
      "sid": 67,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "22482",
      "zip": "78258",
      "address": "18911 Hardy Oak Blvd Suite 107",
      "phone": "830-445-2583",
      "fax": null,
      "email": "BluesCrewsRoofing@outlook.com",
      "name": "Blues Crews Roofing & Gutters",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "29.6183814",
      "lon": "-98.4767158",
      "cityname": "San Antonio",
      "statename": "Texas"
   },
   "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": ""
}