{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 337785,
"site_id": 76,
"cat_id": 11,
"priority": 2,
"url": "https://stayofftheroof.com/queen-creek/",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 88506,
"approve_dt": null,
"source": null,
"submit_dt": "2024-11-14T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 9,
"referrals": null,
"country": 277,
"countrycode": "US",
"loc_id": 277,
"state_id": 3,
"city_id": 1002,
"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": 5871,
"d_url": null,
"approved": null,
"logo_ext": "jpg",
"screen_ext": "png",
"pack_id": null,
"uuid": "cd2a2810-a236-11ef-a909-b66e99367f32",
"subdate": "Nov 14, 2024",
"subcategory": "Lighting Consultants",
"request_types": "",
"visitcount": 31
},
"visits": {
"storefront": 31,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 7,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "Brighten your Queen Creek, AZ property with our expert outdoor lighting solutions! We specialize in permanent holiday lights, custom landscape lighting, and charming bistro lighting to enhance any outdoor space. Our team designs and installs energy-efficient, low-voltage systems that bring beauty, safety, and ambiance to your home year-round. Trust us for a tailored lighting experience that transforms your outdoors into a welcoming retreat. Licensed, Bonded, and Insured with great reviews!",
"service1": "Landscape Lighting",
"service2": "Landscape lighting Install",
"service3": "Permanent Holiday Lighting",
"service4": "",
"service5": "",
"service6": "",
"service7": "",
"submit_dt": "2024-11-14 03:16:13"
},
"location": {
"uuid": "cd2a2810-a236-11ef-a909-b66e99367f32",
"link_id": 337785,
"account_id": 88506,
"company": "Stay Off The Roof",
"sid": 76,
"country": 277,
"countrycode": "US",
"state": 3,
"city": "1002",
"zip": "85142",
"address": "18625 S 187th Pl, Suite A108",
"phone": "(480) 420-3811",
"fax": null,
"email": "stayofftheroofaz@brite-post.com",
"name": "Stay Off The Roof",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "50.2648919",
"lon": "19.0237815",
"cityname": "Queen Creek",
"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": ""
}
all our featured social media
