She Sells Scottsdale

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 335104,
      "site_id": 24,
      "cat_id": 80,
      "priority": 2,
      "url": "https://shesellsscottsdale.com/",
      "title": "She Sells Scottsdale",
      "description": "Pam Torgrimson is a luxury Scottsdale, AZ real estate agent for Realty ONE Group International. Pam also specializes in the real estate needs of McCormick Ranch, Paradise Valley, Gainey Ranch, Arcadia, and more. She has a true passion for helping people find the home of their dreams, whether they're first-time homebuyers, growing families, retirees looking to downsize, a luxury property, or snowbirds looking for a \"getaway\" home in Arizona to escape the cold. Contact Pam Torgrimson today!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 85849,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-09-08T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 3,
      "city_id": 1026,
      "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": 1433,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "0f24650a-6e3c-11ef-ab46-b66e99367f32",
      "subdate": "Sep 08, 2024",
      "subcategory": "Real Estate Agents",
      "request_types": "",
      "visitcount": 9
   },
   "visits": {
      "storefront": 9,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 5,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Pam Torgrimson is a luxury Scottsdale, AZ real estate agent for Realty ONE Group International. Pam also specializes in the real estate needs of McCormick Ranch, Paradise Valley, Gainey Ranch, Arcadia, and more. She has a true passion for helping people find the home of their dreams, whether they're first-time homebuyers, growing families, retirees looking to downsize, a luxury property, or snowbirds looking for a \"getaway\" home in Arizona to escape the cold. Contact Pam Torgrimson today!",
      "service1": "McCormick Ranch Real Estate",
      "service2": "Paradise Valley Real Estate",
      "service3": "Scottsdale Ranch Real Estate",
      "service4": "Old Town Scottsdale Real Estate",
      "service5": "Gainey Ranch Real Estate",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-09-08 23:42:50"
   },
   "location": {
      "uuid": "0f24650a-6e3c-11ef-ab46-b66e99367f32",
      "link_id": 335104,
      "account_id": 85849,
      "company": "She Sells Scottsdale",
      "sid": 24,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "1026",
      "zip": "85258",
      "address": "7975 N Hayden Rd, A101",
      "phone": "(602) 803-6904",
      "fax": null,
      "email": "shesellsscottsdale@brite-mail.com",
      "name": "She Sells Scottsdale",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "33.5531107",
      "lon": "-111.8974317",
      "cityname": "Scottsdale",
      "statename": "Arizona"
   },
   "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