Francis Renovations Inc

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 335249,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://francisrenovations.com/",
      "title": "Francis Renovations Inc",
      "description": "Since 2004, Francis Renovations has been assisting homeowners in Southeastern Pennsylvania in creating the spaces they desire (and need). As a family-owned business, we recognize the value of bringing people together and encouraging one another.\r\nThat is why, for us, it is more than just upgrading your spaces. Our main objective is to provide our customers with long-lasting and personalized designs. We warranty all of our work and have established our company on delivering the best service possible so that you never have to utilize those warranties.\r\nWe'll provide you with all of the resources to help you realize your idea and bring it to life. We recognize that having work done on your house can be stressful, hence we aim to make this procedure as simple as possible for you. Our experienced design team will assist and empower you throughout the process so that you may fall in love with every element, no matter how tiny.\r\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 85994,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-09-11T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 5,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 37,
      "city_id": 19350,
      "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": 4148,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "930ab246-700b-11ef-ab46-b66e99367f32",
      "subdate": "Sep 11, 2024",
      "subcategory": "Home Remodels",
      "request_types": "",
      "visitcount": 33
   },
   "visits": {
      "storefront": 33,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 9,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-09-11 07:00:48"
   },
   "location": {
      "uuid": "930ab246-700b-11ef-ab46-b66e99367f32",
      "link_id": 335249,
      "account_id": 85994,
      "company": "Francis Renovations Inc",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 37,
      "city": "19350",
      "zip": "19406",
      "address": "808 N Henderson Rd. #230 King of Prussia, Pennsylvania 19406, USA",
      "phone": "",
      "fax": null,
      "email": "francisrenovations7@gmail.com",
      "name": "Francis Renovations Inc",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "40.1136376",
      "lon": "-75.3771415",
      "cityname": "King of Prussia",
      "statename": "Pennsylvania"
   },
   "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": ""
}