{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 343690,
"site_id": 6,
"cat_id": 39,
"priority": 2,
"url": "https://advancedsprinklerrepair.com/",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 94385,
"approve_dt": null,
"source": null,
"submit_dt": "2025-03-12T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 4,
"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": 288,
"d_url": null,
"approved": null,
"logo_ext": "jpg",
"screen_ext": "png",
"pack_id": null,
"uuid": "55e1aebc-ff1b-11ef-a909-b66e99367f32",
"subdate": "Mar 12, 2025",
"subcategory": "Home And Garden",
"request_types": "",
"visitcount": 14
},
"visits": {
"storefront": 14,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 2,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "For over 40 years, Advanced Sprinkler & Drainage Repair has been San Diego's go-to lawn sprinkler system contractor. We provide expert sprinkler system repairs, drainage solutions, and outdoor lighting services. As a fully licensed and insured contractor, we are committed to delivering exceptional service and using only the highest quality materials and equipment. From irrigation design to erosion control, we've got you covered. Contact us today for all your outdoor system needs!",
"service1": "Sprinklers & Irrigation Systems",
"service2": "Drainage Systems & Erosion Control",
"service3": "Exterior Lighting",
"service4": "",
"service5": "",
"service6": "",
"service7": "",
"submit_dt": "2025-03-12 08:23:54"
},
"location": {
"uuid": "55e1aebc-ff1b-11ef-a909-b66e99367f32",
"link_id": 343690,
"account_id": 94385,
"company": "Advanced Sprinkler & Drainage Repair",
"sid": 6,
"country": 277,
"countrycode": "US",
"state": 5,
"city": "2452",
"zip": "92111",
"address": "8260 Engineer Rd",
"phone": "(858) 573 5128",
"fax": null,
"email": "advancesprink@brite-email.com",
"name": "Advanced Sprinkler & Drainage Repair",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "32.8250414",
"lon": "-117.1478916",
"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": ""
}
all our featured social media
