Andrew Piane, REALTOR| HomeSmart

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348719,
      "site_id": 24,
      "cat_id": 80,
      "priority": 2,
      "url": "https://www.bestwestagent.com/",
      "title": "Andrew Piane, REALTOR| HomeSmart",
      "description": "Andrew Piane, REALTOR® is a Top 3% REALTOR® in Arizona out of approximately 54,000 REALTORS®, with nearly two decades of sales experience and a passion for helping clients with one of the biggest purchases of their lives. As a HomeSmart agent serving the greater Phoenix area, Andrew treats every property purchase or listing as if it were his own, combining 18 years of sales and marketing experience with 13 years of proven ad campaign management. His goal is always to maximize profits while creating a stress-free, smooth experience, backed by a 5-star Google rating and comprehensive support from plumbers to contractors.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 99413,
      "approve_dt": "2025-07-10T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-16T00: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": 0,
      "city_id": 0,
      "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": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "d02f031f-4a80-11f0-a909-b66e99367f32",
      "subdate": "Jun 16, 2025",
      "subcategory": "Real Estate Agents",
      "request_types": "",
      "visitcount": 29
   },
   "visits": {
      "storefront": 29,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 6,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Top 3% 5-Star Rated Real Estate Agent and licensed Realtor with HomeSmart. Expert Buyer's and Seller's Agent with 18 years of sales and marketing experience. Specializing in residential real estate, home buying, home selling, and property investments. Former Mortgage Loan Officer with 3 years of experience and 14 years of expertise in social media and pay-per-click marketing. Providing professional home valuations, market analysis, and personalized real estate services to maximize your property's value. Trusted, local real estate professional dedicated to client satisfaction.",
      "service1": "Buyer's agent services",
      "service2": " Seller's agent services",
      "service3": " Comprehensive home valuations",
      "service4": " Professional listing photography",
      "service5": " Social media marketing campaigns",
      "service6": " Home tour video production",
      "service7": " Repair and upgrade team coordination",
      "submit_dt": "2025-06-16 07:09:15"
   },
   "location": {
      "uuid": "d02f031f-4a80-11f0-a909-b66e99367f32",
      "link_id": 348719,
      "account_id": 99413,
      "company": "Andrew Piane, REALTOR| HomeSmart",
      "sid": 24,
      "country": 277,
      "countrycode": "US",
      "state": 0,
      "city": "0",
      "zip": "85395",
      "address": "13166 W. McDowell Rd., Suite B, Goodyear, Arizona",
      "phone": "(623) 261-4088",
      "fax": null,
      "email": "andrewpiane@mail-burst.com",
      "name": "Andrew Piane, REALTOR| HomeSmart",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "33.4648327",
      "lon": "-112.3423701",
      "cityname": "",
      "statename": ""
   },
   "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": ""
}