{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 340079,
"site_id": 76,
"cat_id": 11,
"priority": 2,
"url": "https://www.djfisherconstruction.com",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 90780,
"approve_dt": null,
"source": null,
"submit_dt": "2025-01-03T00: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": 46,
"city_id": 23925,
"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": 5844,
"d_url": null,
"approved": null,
"logo_ext": "jpg",
"screen_ext": "png",
"pack_id": null,
"uuid": "945d4a26-c9aa-11ef-a909-b66e99367f32",
"subdate": "Jan 03, 2025",
"subcategory": "Bathroom Remodeling",
"request_types": "",
"visitcount": 43
},
"visits": {
"storefront": 43,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 15,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "Fisher Construction, LLC, based in Yakima, WA, has nearly two decades of professional expertise in the realm of home construction, renovation, and repair. Specializing in building and remodeling projects, we bring dreams to life. Our services include bathroom remodeling, kitchen transformations, and home additions such as decks, ensuring the highest return on your investments. Along with this, we also offer ICF Construction services, helping clients construct sustainable, energy-efficient homes.",
"service1": "",
"service2": "",
"service3": "",
"service4": "",
"service5": "",
"service6": "",
"service7": "",
"submit_dt": "2025-01-03 08:13:14"
},
"location": {
"uuid": "945d4a26-c9aa-11ef-a909-b66e99367f32",
"link_id": 340079,
"account_id": 90780,
"company": "",
"sid": 76,
"country": 277,
"countrycode": "US",
"state": 46,
"city": "23925",
"zip": "98942",
"address": "161 Winquest Lane",
"phone": "509-517-6504",
"fax": null,
"email": "djfisherconstruction@brite-email.com",
"name": "Fisher Construction",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "46.6778841",
"lon": "-120.5135295",
"cityname": "Selah",
"statename": "Washington"
},
"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
