Rose City Solutions

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348232,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://rosecitysolutions.com/",
      "title": "Rose City Solutions",
      "description": "We are Rose City Solutions.Keeping you at your online best.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 98927,
      "approve_dt": "2025-07-16T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-05T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 36,
      "city_id": 18635,
      "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": 6458,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "fe866755-41f4-11f0-a909-b66e99367f32",
      "subdate": "Jun 05, 2025",
      "subcategory": "Information Technology",
      "request_types": "",
      "visitcount": 57
   },
   "visits": {
      "storefront": 57,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 20,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Rose City Solutions is a corporate networking solutions provider serving small to medium businesses throughout the Willamette Valley, Boise Idaho, and surrounding areas with highly trained IT staff ranging from new graduates in the latest technologies to seasoned personnel with years of field experience. They help businesses reduce IT costs and increase ROI by providing comprehensive technology solutions and expert support tailored to meet diverse business technology needs.",
      "service1": "corporate networking solutions",
      "service2": " IT support services",
      "service3": " technology consulting",
      "service4": " network management",
      "service5": " cost reduction strategies",
      "service6": " ROI optimization",
      "service7": " business technology solutions",
      "submit_dt": "2025-06-05 10:08:14"
   },
   "location": {
      "uuid": "fe866755-41f4-11f0-a909-b66e99367f32",
      "link_id": 348232,
      "account_id": 98927,
      "company": "Rose City Solutions",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 36,
      "city": "18635",
      "zip": "",
      "address": "1002A N Springbrook Rd, #200",
      "phone": "503-821-7000",
      "fax": null,
      "email": "rosecitysolutions@proton.me",
      "name": "Rose City Solutions",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "45.307281",
      "lon": "-122.9463282",
      "cityname": "Newberg",
      "statename": "Oregon"
   },
   "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": ""
}