Residential Remodeling Covina

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 323827,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://ashbyremodeling.com/contacts/",
      "title": "Residential Remodeling Covina",
      "description": "You''ve come to the perfect place if you''re thinking of remodelling your house. We are a full-service remodelling business that focuses in Residential Remodeling Covina, Kitchen Remodeling Covina, Bathroom Remodeling Covina, Home Remodeling Covina, Basement Remodeling Covina, and Countertops Installation Covina. We are dedicated to providing the highest quality work and customer service to our clients. Call us right now to arrange a no-cost consultation.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 74875,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-01-06T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 312,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 1825,
      "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": 2595,
      "subcat_id": 5844,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "d1b5ccd8-8d93-11ed-b5b4-b66e99367f32",
      "subdate": "Jan 06, 2023",
      "subcategory": "Bathroom Remodeling",
      "request_types": "",
      "visitcount": 479
   },
   "visits": {
      "storefront": 479,
      "articles": 132,
      "videos": 0,
      "reviews": 0,
      "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": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2023-01-06 07:29:13"
   },
   "location": {
      "uuid": "d1b5ccd8-8d93-11ed-b5b4-b66e99367f32",
      "link_id": 323827,
      "account_id": 74875,
      "company": "Residential Remodeling Covina",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "1825",
      "zip": "91722",
      "address": "Covina CA 91722",
      "phone": "626-364-1524",
      "fax": null,
      "email": "nokoli2236@prolug.com",
      "name": "Residential Remodeling Covina",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "34.0948204",
      "lon": "-117.9073244",
      "cityname": "Covina",
      "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": 1
      },
      {
         "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": ""
}