- Listings

Puller is storing all RETS listings in Elasticseach under separate index for every Subscription.

  • ES Cluster: listings.rets.ci
  • ES path: https://listings.rets.ci:gtfzviidkrlfofiu@api.wpcloud.io:19100/
  • ES index/type: {subscription_id}

Where subscription_id is ES ID of Subscriptions

Object:

{
  // Elasticsearch index
  "_esIndex": "rets-avfcj9xvz1otsxehdlcr",
  // Client ID
  "_instanceID": "avfcj9xvz1otsxehdlcr",
  // RETS Provider ID
  "_providerID": "53f046133acc697e33b7ca9b085bec12",
  // RETS Class
  "_class": "RESI",
  // When the listing was updated by Poller last time
  "_modified": "2016-12-27T15:01:31+0000",
  // When the listing was added to Elasticsearch
  "_created": "2016-12-27T15:01:31+0000",
  // System Geo Data
  "_geo": {
    // Google Address
    "google": {
      "formattedAddress": "91-1139 Puamaeole St, Ewa Beach, HI 96706, USA",
      "latitude": 21.3444809,
      "longitude": -158.028274,
      "extra": {
        "googlePlaceId": "ChIJEVm4SYxkAHwRZyZsZJp6zb8",
        "confidence": 1,
        "premise": null,
        "subpremise": null,
        "neighborhood": "Ewa",
        "establishment": null
      },
      "administrativeLevels": {
        "level2long": "Honolulu County",
        "level2short": "Honolulu County",
        "level1long": "Hawaii",
        "level1short": "HI"
      },
      "streetNumber": "91-1139",
      "streetName": "Puamaeole Street",
      "city": "Ewa Beach",
      "country": "United States",
      "countryCode": "US",
      "zipcode": "96706",
      "provider": "google"
    },
    // Walkscore
    "walkscore": {
      "status": 1,
      "walkscore": 8,
      "description": "Car-Dependent",
      "updated": "2016-09-28 13:26:55.030190",
      "logo_url": "https://cdn.walk.sc/images/api-logo.png",
      "more_info_icon": "https://cdn.walk.sc/images/api-more-info.gif",
      "more_info_link": "https://www.redfin.com/how-walk-score-works",
      "ws_link": "https://www.walkscore.com/score/loc/lat=21.3444809/lng=-158.028274/?utm_source=usabilitydynamics.com&utm_medium=ws_api&utm_campaign=ws_api",
      "help_link": "https://www.redfin.com/how-walk-score-works",
      "snapped_lat": 21.345,
      "snapped_lon": -158.028
    }
  },

  // All required mapped fields
  "uniqueID": "10544441",
  "mlsID": "201618847",
  "entryDateTime": "2016-07-18T16:47:32.033",
  "modifiedDateTime": "2016-12-12T15:27:13.710",
  "latitude": null,
  "longitude": null,
  "streetNumber": "91-1139",
  "streetDirPrefix": "",
  "streetPrefix": null,
  "streetDirSuffix": "",
  "streetSuffix": "Street",
  "streetName": "Puamaeole",
  "city": "Ewa Beach",
  "stateOrProvince": "HI",
  "postalCode": "96706",

  // Images
  "media": [
    {
      "id": "10544441",
      "order": "1",
      "url": "https://d2qhmlip1wd1md.cloudfront.net/cdn.rets.ci/10544441/6911383c4730c7f5db5f70fb6a622cc5"
    },
    {
      "id": "10544441",
      "order": "2",
      "url": "https://d2qhmlip1wd1md.cloudfront.net/cdn.rets.ci/10544441/786e92a0597c1b1f75a40422ace79350"
    }
  ],

  // RAW RETS Object
  "raw": {
    "BathsFull": "1",
    "BathsHalf": "1",
    "BathsTotal": "1.01",
    "BedsTotal": "2",
    "BuildingName": "Palm Villas",
    "BuyerFinancing": "VA",
    "City": "Ewa Beach",
    "CloseDate": "2016-11-23T00:00:00.000",
    "ClosePrice": "291000.00",
    "CondoParkingUnit": "-",
    "ConstructionMaterials": "Concrete",
    "CountyOrParish": "Oahu",
    "CurrentPrice": "291000.00",
    "Disclosures": "Property Disclosure Stmt",
    "DOM": "128",
    "DownPaymentResourceYN": "1",
    "DualVariableCompensationYN": "0",
    "ElementarySchool": "Ewa Beach",
    "HighSchool": "Campbell",
    "LandRecorded": "Dual Systems",
    "LandTenure": "FS - Fee Simple",
    "ListAgent_MUI": "3473720",
    "ListAgentDirectWorkPhone": "(808) 676-8858",
    "ListAgentEmail": "agentmarcie1@cs.com",
    "ListAgentFullName": "Marcelina M Silvester-Thomas",
    "ListAgentMLSID": "20243",
    "ListingAgreement": "Exclusive Rights",
    "ListingContractDate": "2016-07-18T00:00:00.000",
    "ListingFinancing": "Cash,Conventional",
    "ListingService": "Full Service",
    "ListOffice_MUI": "3485689",
    "ListOfficeMLSID": "WORI",
    "ListOfficeName": "West Oahu Realty, Inc.",
    "ListOfficePhone": "(808) 676-8858",
    "ListPrice": "298000.00",
    "LockBoxYN": "0",
    "MaintenanceExpense": "322.00",
    "ManagementCompanyName": "Certified Mgmt",
    "ManagementCompanyPhone": "836-0911",
    "Matrix_Unique_ID": "10544441",
    "MatrixModifiedDT": "2016-12-12T15:27:13.710",
    "MiddleOrJuniorSchool": "Ewa Makai",
    "MLS": "HI Central",
    "MLSAreaMajor": "Ewaplain",
    "MLSNumber": "201618847",
    "Neighbourhood": "EWA GEN SODA CREEK",
    "NewDevelopmentConstructionYN": "0",
    "OccupantType": "Tenant",
    "OffMarketDate": "2016-11-23T00:00:00.000",
    "OriginalEntryTimestamp": "2016-07-18T16:47:32.033",
    "OriginalListPrice": "299000.00",
    "OwnerOccupancyPercentage": "25",
    "PhotoModificationTimestamp": "2016-07-20T11:08:21.003",
    "Possession": "45 Days or More,At Closing",
    "PostalCode": "96706",
    "PriceChangeTimestamp": "2016-09-10T16:46:26.837",
    "PrivateRemarks": "Tenant occupied until December",
    "PropertyCondition": "Average",
    "PropertyFrontage": "Other",
    "PropertyType": "Condo/Townhouse",
    "PublicRemarks": "OPEN SUNDAY 9/11/16 2-4PM   HERES YOUR CHANCE!!!",
    "SecurityFeatures": "Security Patrol",
    "SellingAgent_MUI": "3482527",
    "SellingAgentDirectWorkPhone": "(808) 596-2888",
    "SellingAgentEmail": "admin@tonggpartners.com",
    "SellingAgentFullName": "Charlene Tongg",
    "SellingAgentMLSID": "41096",
    "SellingOffice_MUI": "8991040",
    "SellingOfficeMLSID": "KWPP",
    "SellingOfficeName": "Keller Williams Honolulu",
    "SellingOfficePhone": "(808) 596-2888",
    "ShowingInstructions": "Two Day Notice Reqd,Listor Must Be Present",
    "SpecialListingConditions": "None",
    "SQFTRoofedLiving": "717",
    "SqftTotal": "717",
    "StateOrProvince": "HI",
    "Status": "Sold",
    "StatusChangeTimestamp": "2016-11-23T16:59:12.387",
    "StatusContractualSearchDate": "2016-11-23T00:00:00.000",
    "StoriesType": "One",
    "StreetName": "Puamaeole",
    "StreetNumber": "91-1139",
    "StreetSuffix": "Street",
    "SubAgencyCompensation": "2",
    "UnitFeatures": "Bedroom on 1st Level,Corner/End",
    "UnitNumber": "21C",
    "View": "Garden",
    "YearBuilt": "1989",
    "Zoning": "11 - A-1 Low Density Apartment"
  }
}

Feedback and Knowledge Base