TerrarevoBuilders

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 333285,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.terrarevo.com/",
      "title": "TerrarevoBuilders",
      "description": "Terra Revo is a premier general contractor specializing in home remodels and additions for homeowners in San Jose, Campbell, Los Gatos, Saratoga, Cupertino, Los Altos, Menlo Park, Palo Alto, Woodside, Emerald Hills, and surrounding areas.As an experienced general contractor serving the San Francisco Bay Area, Terra Revo provides top-notch home remodeling services to transform your living space. From kitchen and bathroom renovations to room additions and whole-home remodels.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 84062,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-07-22T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 17,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2463,
      "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": 6285,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "267c7b16-47db-11ef-8344-b66e99367f32",
      "subdate": "Jul 22, 2024",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 33
   },
   "visits": {
      "storefront": 33,
      "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": "Terra Revo is a premier general contractor specializing in home remodels and additions for homeowners in San Jose, Campbell, Los Gatos, Saratoga, Cupertino, Los Altos, Menlo Park, Palo Alto, Woodside, Emerald Hills, and surrounding areas.\r
As an experienced general contractor serving the San Francisco Bay Area, Terra Revo provides top-notch home remodeling services to transform your living space. From kitchen and bathroom renovations to room additions and whole-home remodels.",
      "service1": "Residential General Contractor",
      "service2": "Remodels",
      "service3": "Home additions",
      "service4": "New Home Construction",
      "service5": "Whole House Remodel",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-07-22 03:33:25"
   },
   "location": {
      "uuid": "267c7b16-47db-11ef-8344-b66e99367f32",
      "link_id": 333285,
      "account_id": 84062,
      "company": "Terrarevo Builders",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2463",
      "zip": "95125",
      "address": "1279 Clark Way",
      "phone": "(408) 316-6899",
      "fax": null,
      "email": "terrarevobuild@brite-email.com",
      "name": "Terrarevo Builders",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "37.29355",
      "lon": "-121.8968825",
      "cityname": "San Jose",
      "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": 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": ""
}