412 Houses

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 324337,
      "site_id": 24,
      "cat_id": 80,
      "priority": 2,
      "url": "https://www.412houses.com/",
      "title": "412 Houses",
      "description": "412 Houses is a real estate investment company, we are local Pittsburgh cash home buyers. We buy houses in and around Pittsburgh, regardless of its condition and promise to close quickly. You dont have to worry about repairs or renovations. No matter how bad the condition is, we buy houses quickly. You can leave your house AS-IS. You dont have to pay for closing costs or commissions. We will take care of everything. Fill out the online form to get an offer for your house today. Call 412-513-7204. Visit https://www.412houses.com/",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 75357,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-03-10T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 54,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 37,
      "city_id": 18846,
      "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": 2624,
      "subcat_id": 1404,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "47d421fa-bf3a-11ed-b5b4-b66e99367f32",
      "subdate": "Mar 10, 2023",
      "subcategory": "Commercial Buyers Agent",
      "request_types": "",
      "visitcount": 109
   },
   "visits": {
      "storefront": 109,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We Buy Houses In Pittsburgh In Any Condition\r
\r
Cash Home buyer Pittsburgh, cash home buyers pittsburgh, We Buy Houses Pittsburgh, sell house fast pittsburgh, sell my house fast pittsburgh, Need to sell my house fast\r
",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2023-03-10 11:54:15"
   },
   "location": {
      "uuid": "47d421fa-bf3a-11ed-b5b4-b66e99367f32",
      "link_id": 324337,
      "account_id": 75357,
      "company": "",
      "sid": 24,
      "country": 277,
      "countrycode": "US",
      "state": 37,
      "city": "18846",
      "zip": "15102",
      "address": "5225 Library Road, #136",
      "phone": "412-346-0523",
      "fax": null,
      "email": "webuyhousepa@gmail.com",
      "name": "412 Houses",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.3330932",
      "lon": "-80.0229479",
      "cityname": "Bethel Park",
      "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": ""
}