S.P. Home Improvement
{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 308053,
"site_id": 76,
"cat_id": 11,
"priority": 0,
"url": "http://sphomeimprovement.com",
"title": "S.P. Home Improvement",
"description": "S.P Home Improvement offers top notch service for you home or business, we are specialized in basement renovation, carpentry and woodwork, we will give your bathroom or kitchen renovation a better look with our tile service, replacing your roof with us will save you a lot of money, our basement finish professional will turn your basement into something special.We’re Springfield’s home improvement and renovation pros.",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 59289,
"approve_dt": "2014-02-26T00:00:00.000Z",
"source": null,
"submit_dt": "2014-02-24T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 3653,
"referrals": null,
"country": 277,
"countrycode": "US",
"loc_id": 277,
"state_id": 0,
"city_id": 0,
"ltop": "",
"facebook": "http://www.facebook.com/Sphomeimprovement?ref=hl",
"tiktok": "",
"linkedin": "",
"twitter": "https://twitter.com/SPHomeImprove_",
"googleplus": "https://plus.google.com/+SPHomeImprovementSpringfield/about",
"youtube_channel": "",
"youtube": "",
"youtube_title": "",
"pinterest": "",
"yelp": "",
"foursquare": "",
"instagram": "",
"tripadvisor": null,
"trustpilot": null,
"blog_link": "",
"ss_exchange": 0,
"googlebot": 0,
"yahoobot": 0,
"msnbot": 0,
"author_id": 0,
"subcat_id": 5878,
"d_url": "",
"approved": {
"type": "Buffer",
"data": [
49
]
},
"logo_ext": "jpg",
"screen_ext": "jpg",
"pack_id": null,
"uuid": "94b3db58-56da-11ed-b77c-b66e99367f32",
"subdate": "Feb 24, 2014",
"subcategory": "Renovations",
"request_types": "",
"visitcount": 4044
},
"visits": {
"storefront": 4044,
"articles": 0,
"videos": 0,
"reviews": 33,
"coupons": 0,
"products": 0,
"social": 11,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "S.P Home Improvement offers top notch service for you home or business, we are specialized in basement renovation, carpentry and woodwork, we will give your bathroom or kitchen renovation a better look with our tile service, replacing your roof with us will save you a lot of money, our basement finish professional will turn your basement into something special.Were Springfields home improvement and renovation pros.",
"service1": "Basement Renovation",
"service2": "Bathroom Remodeling",
"service3": "Kitchen Remodeling",
"service4": "Roofing Contractor",
"service5": "Tile Contractor",
"service6": "",
"service7": "",
"submit_dt": "2014-02-24 03:20:49"
},
"location": {
"uuid": "94b3db58-56da-11ed-b77c-b66e99367f32",
"link_id": 308053,
"account_id": 59289,
"company": "S.P. Home Improvement",
"sid": 76,
"country": 277,
"countrycode": "US",
"state": 0,
"city": "",
"zip": "01103",
"address": "1242 Main St #402, Springfield, MA",
"phone": "",
"fax": "",
"email": "",
"name": "",
"status": "hide",
"start_dt": "2024-08-08T00:00:00.000Z",
"end_dt": "2124-08-08T00:00:00.000Z",
"lat": "41.2919171",
"lon": "-73.9140924"
},
"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
