MLS Data Cleanliness Report

MSSQL (IDC) vs RESO DD 2.0 — March 13, 2026

11
Total MLS Sources
2,200
Total Matched Listings
1,224
Fields OK
314
Fields Divergent
0
Value Mismatches
226
Fields Missing

Coverage Ranking

CodeMLSCoverage BarStrictExistsOK / Div / Bad / Miss
glvLas Vegas
80.3%98.3%143 / 27 / 0 / 3
mfrStellar MLS
79.2%97.4%152 / 29 / 0 / 5
nnrNorthern Nevada
80.1%95.9%137 / 20 / 0 / 7
armArizona Regional
66.7%90.9%132 / 41 / 0 / 18
harHouston
66.9%88.3%103 / 26 / 0 / 18
mcoREColorado
74.7%87.9%130 / 18 / 0 / 21
fmlFMLS
71.7%83.9%129 / 15 / 0 / 29
trdTriad MLS
72.6%82.3%90 / 7 / 0 / 22
brtBright MLS
40.1%82.2%79 / 77 / 0 / 35
barBAREIS
48.3%79.3%56 / 31 / 0 / 24
smtSmartMLS
50.3%69.7%73 / 23 / 0 / 44
OKDivergentValue MismatchMissing

Per-MLS Detail

Las Vegas (glv)143 OK· 27 Div· 0 Bad· 3 Miss80.3% strict
MSSQL Columns620Name-Mapped490Val-Discovered4MSSQL-Only126Matched200 listings
Value Mismatches
None
Divergent Fields
RESO FieldMSSQL ColumnMatch RateMethod
Countrycountry0.0%synonym
HorseAmenitieshorseamenities0.0%case_match
OnMarketTimestamponmarkettimestamp0.0%case_match
OriginatingSystemNameoriginatingsystemname0.0%synonym
ParkingFeaturesparkingdesc0.0%synonym
DocumentsCountdocumentscount0.5%case_match
InteriorFeaturesinteriorfeatures0.5%synonym
StoriesTotalstoriestotal0.5%synonym
LotFeatureslotfeatures0.6%synonym
Disclosuresdisclosures4.5%case_match
PropertyConditionpropertycondition8.6%case_match
CarportSpacescarportspaces9.7%case_match
Heatingheatingdesc10.1%synonym
GreenEnergyGenerationgreenenergygeneration10.5%case_match
Electricelectric10.9%case_match
ExteriorFeaturesexteriorfeatures14.5%synonym
WindowFeatureswindowfeatures17.2%synonym
AccessibilityFeaturesaccessibilityfeatures17.6%synonym
Coolingcoolingdesc28.1%synonym
OnMarketDateonmarketdate29.7%synonym
BathroomsHalfbathshalf37.2%synonym
CommunityFeaturescommunityfeatures44.6%synonym
FireplacesTotalfireplacestotal50.8%case_match
Flooringflooring57.9%synonym
SpaFeaturesspafeatures60.9%case_match
PetsAllowedpetsallowed65.0%case_match
ConstructionMaterialsconstructionmaterials65.6%synonym
Missing (fill ≥ 50%)
None above 50% fill
Stellar MLS (mfr)152 OK· 29 Div· 0 Bad· 5 Miss79.2% strict
MSSQL Columns638Name-Mapped321Val-Discovered10MSSQL-Only307Matched200 listings
Value Mismatches
None
Divergent Fields
RESO FieldMSSQL ColumnMatch RateMethod
CoListAgentFirstNamecolistagentfirstname0.0%case_match
CoListAgentLastNamecolistagentlastname0.0%case_match
CoolingYNcoolingyn0.0%case_match
DevelopmentStatusdevelopmentstatus0.0%case_match
HeatingYNheatingyn0.0%case_match
ListAgentFirstNamelistagentfirstname0.0%case_match
ListAgentLastNamelistagentlastname0.0%case_match
ListAgentMiddleNamelistagentmiddlename0.0%case_match
ListAgentPreferredPhonelistagentpreferredphone0.0%case_match
OnMarketTimestamponmarkettimestamp0.0%case_match
OriginatingSystemNameoriginatingsystemname0.0%synonym
StoriesTotalstories0.0%synonym
PropertyConditionpropertycondition1.5%case_match
AssociationFeeIncludesassociationfeeincludes4.1%case_match
DaysOnMarketmlsdom5.0%synonym
InteriorFeaturesinteriorfeatures6.9%synonym
ParkingFeaturesparkingdesc12.1%synonym
CumulativeDaysOnMarketcdom16.5%synonym
PoolFeaturespooldesc20.7%synonym
LotFeatureslotfeatures21.5%synonym
CommunityFeaturescommunityfeatures24.7%synonym
BathroomsHalfbathshalf24.8%synonym
ExteriorFeaturesexteriorfeatures26.0%synonym
WaterfrontFeatureswaterfrontfeatures28.6%case_match
Utilitiesutilities42.7%case_match
Viewviews44.8%synonym
WindowFeatureswindowfeatures51.1%synonym
OwnerPaysownerpays54.5%case_match
CarportSpacescarportspaces67.9%case_match
Missing (fill ≥ 50%)
RESO FieldUpstream Fill %
IDXYN100.0%
Custom466.0%
Custom158.0%
Northern Nevada (nnr)137 OK· 20 Div· 0 Bad· 7 Miss80.1% strict
MSSQL Columns368Name-Mapped285Val-Discovered3MSSQL-Only80Matched200 listings
Value Mismatches
None
Divergent Fields
RESO FieldMSSQL ColumnMatch RateMethod
Basementbasement0.0%synonym
Flooringfloordesc0.0%synonym
OnMarketTimestamponmarkettimestamp0.0%case_match
OriginatingSystemNameoriginatingsystemname0.0%synonym
SpecialListingConditionsspeciallistingconditions0.0%case_match
ConstructionMaterialsconstruction1.2%synonym
VideosCountvideoscount9.0%case_match
FireplaceFeaturesfireplacedesc9.7%synonym
LaundryFeatureslaundryfeatures18.5%synonym
Utilitiesutilities20.6%case_match
WindowFeatureswindowfeatures25.5%synonym
SpaFeaturesspafeatures26.7%case_match
MajorChangeTypemajorchangetype28.0%case_match
BathroomsHalfbathshalf40.7%synonym
Roofroofdesc41.5%synonym
FoundationDetailsfoundationdetails42.7%synonym
InteriorFeaturesinteriorfeatures47.2%synonym
SecurityFeaturessecurityfeatures52.6%case_match
RoadFrontageTyperoadfrontagetype57.4%case_match
ExteriorFeaturesexteriorfeatures65.5%synonym
Missing (fill ≥ 50%)
RESO FieldUpstream Fill %
DelayedMarketingYN100.0%
RentControlYN80.5%
Arizona Regional (arm)132 OK· 41 Div· 0 Bad· 18 Miss66.7% strict
MSSQL Columns328Name-Mapped254Val-Discovered4MSSQL-Only70Matched200 listings
Value Mismatches
None
Divergent Fields
RESO FieldMSSQL ColumnMatch RateMethod
AccessibilityFeaturesaccessibilityfeatures0.0%synonym
BathroomsTotalIntegerbaths0.0%synonym
Countrycountry0.0%synonym
OnMarketTimestamponmarkettimestamp0.0%case_match
OriginatingSystemNameoriginatingsystemname0.0%synonym
ParkingTotalnoofparking0.0%synonym
PatioAndPorchFeaturespatioandporchfeatures0.0%synonym
SeniorCommunityYNseniorcommunityyn0.0%synonym
StoriesTotalstories0.0%synonym
VirtualTourURLUnbrandedvirtualtoururl0.0%synonym
GarageYNgarageyn0.6%synonym
WaterSourcewaterdesc2.5%synonym
ConstructionMaterialsconstruction3.7%synonym
InteriorFeaturesinteriorfeatures4.3%synonym
LotSizeArealotsize5.6%synonym
LotFeatureslotdesc5.9%synonym
Utilitiesutilities6.8%case_match
CommunityFeaturescommunityfeatures7.8%synonym
PoolFeaturespooldesc8.5%synonym
RentIncludesrentincludes10.0%case_match
WindowFeatureswindowfeatures12.7%synonym
CarportSpacescarportspaces16.0%case_match
VideosCountvideoscount18.0%case_match
Appliancesappliances26.6%synonym
AssociationFeeIncludesassociationfeeincludes30.9%case_match
BathroomsHalfbathshalf33.2%synonym
CommonWallscommonwalls33.3%case_match
DevelopmentStatusdevelopmentstatus33.3%case_match
RoadResponsibilityroadresponsibility36.4%case_match
PropertyConditionpropertycondition37.5%case_match
ParkingFeaturesparkingdesc37.8%synonym
LaundryFeatureslaundryfeatures49.1%synonym
ExteriorFeaturesexteriorfeatures49.5%synonym
CurrentFinancingcurrentfinancing54.9%case_match
CoListAgentURLcolistagenturl59.0%case_match
ListOfficeURLlistofficeurl60.3%case_match
OtherStructuresotherstructures60.7%synonym
FireplaceFeaturesfireplacedesc64.2%synonym
AttachedGarageYNattachedgarageyn64.5%synonym
Electricelectric64.5%case_match
Coolingcoolingdesc64.6%synonym
Missing (fill ≥ 50%)
RESO FieldUpstream Fill %
DelayedMarketingYN100.0%
ListAgentAOR100.0%
HorseYN96.0%
LotSizeAcres95.0%
PoolPrivateYN93.5%
SpaYN93.5%
OpenParkingSpaces56.0%
Houston (har)103 OK· 26 Div· 0 Bad· 18 Miss66.9% strict
MSSQL Columns252Name-Mapped209Val-Discovered3MSSQL-Only39Matched200 listings
Value Mismatches
None
Divergent Fields
RESO FieldMSSQL ColumnMatch RateMethod
AccessibilityFeaturesaccessibilityfeatures0.0%synonym
CoListAgentFirstNamecolistagentfirstname0.0%case_match
CoListAgentLastNamecolistagentlastname0.0%case_match
ListAgentFirstNamelistagentfirstname0.0%case_match
ListAgentLastNamelistagentlastname0.0%case_match
OriginatingSystemNameoriginatingsystemname0.0%synonym
RoomsTotalnoofrooms0.0%synonym
SeniorCommunityYNseniorcommunityyn0.0%synonym
InteriorFeaturesinteriorfeatures1.5%synonym
CommunityFeaturescommunityfeatures4.8%synonym
Viewviewdesc6.2%synonym
ExteriorFeaturesexteriorfeatures12.3%synonym
LotFeatureslotdesc25.7%synonym
YearBuiltSourceyearbuiltsource28.6%case_match
PatioAndPorchFeaturespatioandporchfeatures29.2%synonym
WindowFeatureswindowfeatures35.3%synonym
WaterfrontFeatureswaterfrontfeatures37.5%case_match
BathroomsHalfbathshalf38.8%synonym
GreenEnergyEfficientgreenenergyefficient49.3%case_match
RoadSurfaceTyperoadsurfacetype51.2%case_match
Utilitiesutilities53.1%case_match
PropertySubTypepropertytype57.5%synonym
LeaseTermleaseterm61.0%case_match
Appliancesappliances62.7%synonym
PoolFeaturespooldesc66.7%synonym
WaterSourcewaterdesc66.7%synonym
Missing (fill ≥ 50%)
RESO FieldUpstream Fill %
DocumentsCount100.0%
IDXYN100.0%
ListAgentEmail100.0%
PrivateRemarks93.0%
ParkingTotal82.5%
PublicSurveySection71.0%
ListingTerms55.5%
MapCoordinate51.5%
REColorado (mco)130 OK· 18 Div· 0 Bad· 21 Miss74.7% strict
MSSQL Columns459Name-Mapped238Val-Discovered5MSSQL-Only216Matched200 listings
Value Mismatches
None
Divergent Fields
RESO FieldMSSQL ColumnMatch RateMethod
RoadFrontageTyperoadfrontagetype4.1%case_match
ParkingFeaturesparkingdesc13.0%synonym
Electricelectric13.6%case_match
Possessionpossession19.5%synonym
LotSizeArealotsize23.4%synonym
Fencingfencing25.8%synonym
Utilitiesutilities29.9%case_match
AssociationFeeIncludesassociationfeeincludes30.1%case_match
InteriorFeaturesinteriorfeatures30.1%synonym
Vegetationvegetation40.0%case_match
BathroomsHalfbathshalf46.0%synonym
Coolingcoolingdesc47.7%synonym
CurrentUsecurrentuse52.9%case_match
LotFeatureslotdesc55.0%synonym
LivingAreasqft58.1%synonym
MainLevelBedroomsmainlevelbeds62.2%synonym
SecurityFeaturessecurityfeatures62.2%case_match
BelowGradeFinishedAreabelowgradefinishedarea69.4%case_match
Missing (fill ≥ 50%)
RESO FieldUpstream Fill %
IDXYN100.0%
ListAOR100.0%
ListAgentAOR100.0%
ListAgentFirstName100.0%
ListAgentLastName100.0%
OriginatingSystemID100.0%
InternetAutomatedValuationDisplayYN95.5%
HeatingYN94.5%
CoolingYN91.5%
LotSizeAcres82.5%
GarageYN82.0%
FireplaceYN53.5%
FMLS (fml)129 OK· 15 Div· 0 Bad· 29 Miss71.7% strict
MSSQL Columns325Name-Mapped198Val-Discovered5MSSQL-Only121Matched200 listings
Value Mismatches
None
Divergent Fields
RESO FieldMSSQL ColumnMatch RateMethod
CountyOrParishcounty0.0%synonym
InteriorFeaturesinteriorfeatures7.7%synonym
PropertyConditionpropertycondition15.4%case_match
CommunityFeaturescommunityfeatures18.3%synonym
Electricelectric19.4%case_match
AccessibilityFeaturesaccessibilityfeatures40.0%synonym
LivingAreasqft43.6%synonym
ListOfficeURLlistofficeurl47.2%case_match
Basementbasement50.0%synonym
BathroomsHalfbathshalf50.8%synonym
MainLevelBedroomsmainlevelbeds60.5%synonym
ConstructionMaterialsconstruction63.6%synonym
MainLevelBathroomsmainlevelbaths63.6%synonym
DaysOnMarketmlsdom66.5%synonym
SecurityFeaturessecurityfeatures66.7%case_match
Missing (fill ≥ 50%)
RESO FieldUpstream Fill %
ListAgentEmail100.0%
ListAgentFirstName100.0%
ListAgentLastName100.0%
OnMarketTimestamp100.0%
OriginatingSystemID100.0%
OriginatingSystemName100.0%
ViewYN100.0%
CoolingYN97.5%
Custom397.5%
HeatingYN97.5%
StoriesTotal95.5%
LotSizeAcres94.0%
BuildingAreaTotal93.0%
BasementYN90.5%
Custom187.0%
GarageYN74.0%
FireplaceYN73.5%
AttributionContact67.0%
RoadResponsibility51.0%
Triad MLS (trd)90 OK· 7 Div· 0 Bad· 22 Miss72.6% strict
MSSQL Columns302Name-Mapped171Val-Discovered2MSSQL-Only129Matched200 listings
Value Mismatches
None
Divergent Fields
RESO FieldMSSQL ColumnMatch RateMethod
PropertySubTypepropertytype9.0%synonym
AccessibilityFeaturesaccessibilityfeatures9.1%synonym
InteriorFeaturesinteriorfeatures11.1%synonym
LaundryFeatureslaundryfeatures17.6%synonym
BathroomsHalfbathshalf49.5%synonym
FireplacesTotalfireplacestotal53.8%case_match
Coolingcoolingdesc62.1%synonym
Missing (fill ≥ 50%)
RESO FieldUpstream Fill %
AttachedGarageYN100.0%
BasementYN100.0%
ContractStatusChangeDate100.0%
Country100.0%
DocumentsCount100.0%
IDXYN100.0%
ListAgentFirstName100.0%
ListAgentLastName100.0%
Custom1293.0%
CoolingYN91.5%
HeatingYN91.5%
DocumentsChangeTimestamp81.0%
GarageYN71.0%
Bright MLS (brt)79 OK· 77 Div· 0 Bad· 35 Miss40.1% strict
MSSQL Columns560Name-Mapped291Val-Discovered3MSSQL-Only266Matched200 listings
Value Mismatches
None
Divergent Fields
RESO FieldMSSQL ColumnMatch RateMethod
AccessibilityFeaturesaccessibilityfeatures0.0%synonym
Appliancesappliances0.0%synonym
AssociationFeeassofee0.0%synonym
AssociationFee2Frequencyassofee2frequency0.0%synonym
AssociationFeeFrequencyassofeefrequency0.0%synonym
AssociationNameassoname0.0%synonym
AssociationName2assoname20.0%synonym
AttachedGarageYNattachedgarageyn0.0%synonym
AvailabilityDateavailabilitydate0.0%case_match
BuilderModelbuildermodel0.0%case_match
BuilderNamebuildername0.0%case_match
BuildingAreaSourcebuildingareasrc0.0%synonym
CoListAgentOfficePhonecolistagentofficephone0.0%case_match
CoListAgentPreferredPhonecolistagentpreferredph0.0%synonym
ConstructionMaterialsconstruction0.0%synonym
CoolingYNcoolingyn0.0%case_match
CountyOrParishcounty0.0%synonym
CrossStreetcrossstreet0.0%case_match
Directionsdirections0.0%synonym
DoorFeaturesdoorfeatures0.0%case_match
EntryLevelentrylevel0.0%case_match
Exclusionsexclusions0.0%case_match
ExteriorFeaturesexteriorfeatures0.0%synonym
Fencingfencing0.0%synonym
FireplaceFeaturesfireplacedesc0.0%synonym
FireplacesTotalfireplaces0.0%synonym
Flooringfloordesc0.0%synonym
FoundationDetailsfoundationdetails0.0%synonym
Furnishedfurnished0.0%case_match
GarageSpacesgaragespace0.0%synonym
GarageYNgarageyn0.0%synonym
HorseYNhorseyn0.0%case_match
Inclusionsinclusions0.0%case_match
InteriorFeaturesinteriorfeatures0.0%synonym
InternetAutomatedValuationDisplayYNinternetautovaldisplayyn0.0%synonym
InternetConsumerCommentYNinternetconscommtyn0.0%synonym
LeaseConsideredYNleaseconsideredyn0.0%case_match
Levelslevels0.0%synonym
ListAgentPreferredPhonelistagentpreferredph0.0%synonym
ListingAgreementlistingagreement0.0%case_match
ListingServicelistingservice0.0%case_match
LivingAreaSourcelivingareasource0.0%case_match
LotFeatureslotdesc0.0%synonym
LotSizeSourcelotsizesource0.0%case_match
LotSizeUnitslotsizeunits0.0%case_match
MainLevelBedroomsmainlevelbeds0.0%synonym
MlsStatusdftstatus0.0%dft_known
OriginatingSystemNameoriginatingsystemname0.0%synonym
OtherEquipmentotherequipment0.0%case_match
OtherStructuresotherstructures0.0%synonym
ParcelNumberparcelnumber0.0%synonym
ParkingFeaturesparkingdesc0.0%synonym
ParkingTotalnoofparking0.0%synonym
PatioAndPorchFeaturespatioandporchfeatures0.0%synonym
PetsAllowedpetsallowed0.0%case_match
PoolFeaturespooldesc0.0%synonym
Possessionpossession0.0%synonym
Roofroofdesc0.0%synonym
SeniorCommunityYNseniorcommunityyn0.0%synonym
Sewersewerdesc0.0%synonym
SpecialListingConditionsspeciallistingconditions0.0%case_match
Storiesnoofstories0.0%synonym
StructureTypestructuredesigntype0.0%synonym
Utilitiesutilities0.0%case_match
ViewYNviewyn0.0%case_match
VirtualTourURLUnbrandedvirtualtourunbranded0.0%synonym
WaterSourcewaterdesc0.0%synonym
WaterfrontFeatureswaterfrontfeatures0.0%case_match
WindowFeatureswindowfeatures0.0%synonym
YearBuiltEffectiveyearbuilteffective0.0%case_match
YearBuiltSourceyearbuiltsource0.0%case_match
Zoningzoning0.0%synonym
PropertySubTypepropertytype1.0%synonym
Coolingcoolingdesc1.5%synonym
Heatingheatingdesc2.0%synonym
Basementbasement20.4%synonym
Viewviewdesc57.4%synonym
Missing (fill ≥ 50%)
RESO FieldUpstream Fill %
Custom12100.0%
Custom4100.0%
SchoolDistrict100.0%
StandardStatus100.0%
Custom1997.0%
Custom395.0%
ListAgentStateLicense92.0%
TaxAssessedValue88.5%
LotSizeAcres78.5%
LaundryFeatures59.0%
Custom1755.0%
MainLevelBathrooms54.0%
BAREIS (bar)56 OK· 31 Div· 0 Bad· 24 Miss48.3% strict
MSSQL Columns253Name-Mapped138Val-Discovered4MSSQL-Only111Matched200 listings
Value Mismatches
None
Divergent Fields
RESO FieldMSSQL ColumnMatch RateMethod
AccessibilityFeaturesaccessibilityfeatures0.0%synonym
CommunityFeaturescommunityfeatures0.0%synonym
NewConstructionYNnewconstructionyn0.0%synonym
OriginatingSystemNameoriginatingsystemname0.0%synonym
PoolFeaturespooldesc0.0%synonym
PropertyConditionpropertycondition0.0%case_match
SubdivisionNamesubdivision0.0%synonym
InteriorFeaturesinteriorfeatures0.8%synonym
LotFeatureslotdesc1.0%synonym
Utilitiesutilities2.6%case_match
Viewviewdesc2.7%synonym
Appliancesappliances3.1%synonym
NumberOfUnitsTotalnoofunits5.5%synonym
CarportSpacescarportspaces7.7%case_match
Coolingcoolingdesc8.1%synonym
ParkingFeaturesparkingdesc9.4%synonym
SeniorCommunityYNseniorcommunityyn9.6%synonym
AssociationAmenitiesassociationamenities9.7%case_match
RoomsTotalnoofrooms15.7%synonym
PoolPrivateYNpoolyn22.9%synonym
ConstructionMaterialsconstruction30.0%synonym
FireplaceFeaturesfireplacedesc30.7%synonym
BathroomsHalfbathshalf31.8%synonym
FoundationDetailsfoundation32.1%synonym
AssociationFeehoafee36.2%synonym
AssociationYNhoayn36.2%synonym
ExteriorFeaturesexteriorfeatures46.9%synonym
FireplacesTotalfireplaces49.7%synonym
OtherStructuresotherstructures59.1%synonym
ListAgentFullNamedftlistagentname60.5%dft_known
Heatingheatingdesc65.6%synonym
Missing (fill ≥ 50%)
RESO FieldUpstream Fill %
CityRegion100.0%
Country100.0%
InternetAutomatedValuationDisplayYN100.0%
OnMarketTimestamp100.0%
PhotosChangeTimestamp99.5%
StreetNumberNumeric99.5%
BuildingAreaTotal92.0%
SpaYN85.5%
HeatingYN82.5%
GarageYN74.0%
CoolingYN72.0%
AttachedGarageYN56.5%
SecurityFeatures50.0%
SmartMLS (smt)73 OK· 23 Div· 0 Bad· 44 Miss50.3% strict
MSSQL Columns322Name-Mapped117Val-Discovered5MSSQL-Only200Matched200 listings
Value Mismatches
None
Divergent Fields
RESO FieldMSSQL ColumnMatch RateMethod
MajorChangeTypelastchangetype0.0%synonym
OwnerNameownername0.0%case_match
PoolFeaturespooldesc0.0%synonym
PropertyTypedftpropertytype0.0%dft_known
RoomsTotalroomcount0.0%synonym
StreetDirPrefixstreetdirectionprefix0.0%synonym
TaxAnnualAmountpropertytax0.0%synonym
Sewersewerdesc0.5%synonym
ExteriorFeaturesexteriorfeatures1.0%synonym
WaterSourcewaterdesc1.0%synonym
LotFeatureslotdesc2.1%synonym
AssociationFeeIncludesassociationfeeincludes2.5%case_match
Heatingheatingdesc3.6%synonym
AssociationAmenitiesassociationamenities6.2%case_match
InteriorFeaturesinteriorfeatures11.0%synonym
ConstructionMaterialsconstructiondesc11.8%synonym
PropertySubTypepropertytype17.9%synonym
Appliancesappliancesincluded24.4%synonym
BathroomsHalfbathshalf41.9%synonym
Basementbasementdescription48.8%synonym
FireplacesTotalfireplacestotal50.6%case_match
Coolingcoolingdesc60.5%synonym
LivingAreasqft61.5%synonym
Missing (fill ≥ 50%)
RESO FieldUpstream Fill %
Country100.0%
DocumentsCount100.0%
IDXYN100.0%
InternetAutomatedValuationDisplayYN100.0%
InternetConsumerCommentYN100.0%
ListAgentFirstName100.0%
ListAgentLastName100.0%
ListAgentMobilePhone100.0%
ListingService100.0%
OriginatingSystemName100.0%
StandardStatus100.0%
ZoningDescription100.0%
CoolingYN96.5%
HeatingYN94.5%
ListAgentPreferredPhone92.5%
BasementYN87.5%
LockBoxType70.0%
ParkingFeatures53.5%
Roof52.0%
FoundationDetails51.0%

Cross-MLS Field Heatmap

Fields missing or with bad name maps in 3 or more MLSes. 26 fields shown, sorted by problem count.

RESO Fieldglvmfrnnrarmharmcofmltrdbrtbarsmt#Bad
ViewYNOKMISSOKMISSMISSMISSMISS--DIVMISSMISS7
IDXYN--MISS----MISSMISS--MISS----MISS5
CoolingYNOKDIVOKOKOKMISSMISSMISSDIVMISSMISS5
HeatingYNOKDIVOKOKOKMISSMISSMISSOKMISSMISS5
FireplaceYNOKOKOKOKOKMISSMISSMISSOKMISSMISS5
GarageYNOKOKOKDIVOKMISSMISSMISSDIVMISSMISS5
AssociationFeeIncludesMISSDIVMISSDIVMISSDIVMISS--MISS--DIV5
ListAgentLastNameOKDIVOKOKDIVMISSMISSMISSOKOKMISS4
LotSizeAcresOKOKOKMISSOKMISSMISSOKMISSOKOK4
ListAgentFirstNameOKDIVOKOKDIVMISSMISSMISSOKOKMISS4
AttachedGarageYNOKOKOKDIVOKOKMISSMISSDIVMISSMISS4
SecurityFeaturesOKOKDIVOKMISSDIVDIVOKMISSMISSMISS4
SpaYNOKOKOKMISSOKMISS----MISSMISS--4
BasementYN----MISSOK--OKMISSMISSOK--MISS4
CoListAgentLastName--DIVOKOKDIVMISSMISSMISSOK--MISS4
CoListAgentFirstName--DIVOKOKDIVMISSMISSMISSOK--MISS4
PatioAndPorchFeaturesOKOKOKDIVDIVOKOKMISSDIVMISSMISS3
AssociationFee2OK--OKMISS--MISS----MISS----3
PropertyConditionDIVDIVMISSDIVMISSOKDIVMISS--DIV--3
PetsAllowedDIVOK--MISSMISSOKOK--DIV--MISS3
AssociationPhoneOKOK--OKMISSOKOKMISSMISS----3
Custom1--MISS--------MISS--MISS--OK3
CarportYNOKOKOKMISSOK--MISS----MISS--3
InternetAutomatedValuationDisplayYNOKOKOKOKOKMISS--OKDIVMISSMISS3
DocumentsCountDIV--OK--MISS--OKMISS--OKMISS3
CountryDIVOKOKDIVOKOKOKMISSOKMISSMISS3
OKDivergentBad MapMissingNot Checked

Key Patterns

PropertyType — Universal Value Mismatch
Mapped in all 11 MLSes but near-zero match rates in 1 of them. Each MLS uses proprietary enum values that do not conform to RESO standard enumerations (e.g., "Residential" vs "Single Family Residence"). Requires per-MLS enum translation tables.
glv
98%
mfr
100%
nnr
100%
arm
98%
har
100%
mco
100%
fml
100%
trd
100%
brt
99%
bar
96%
smt
0%
UnparsedAddress — Address Formatting Divergence
Present in all 11 MLSes but only 11 pass value matching. 0 are flagged as bad maps due to formatting differences (punctuation, state abbreviation style, unit designator placement). 0 sources are missing the field entirely. Normalization is required before cross-MLS address comparison.
glv
100%
mfr
99%
nnr
100%
arm
99%
har
97%
mco
100%
fml
100%
trd
94%
brt
99%
bar
95%
smt
100%
*desc Suffix Pattern — Description Field Mappings
15 RESO fields are mapped to MSSQL columns ending in "desc" (e.g., coolingdesc, interiorfeaturesdesc). These are typically free-text descriptions storing comma-separated feature lists. Match rates vary because source systems format these differently — normalization strategies differ per MLS.
RESO FieldMSSQL Patternglvmfrnnrarmharmcofmltrdbrtbarsmt
AdditionalParcelsDescriptionaddparceldescOK--------------------
ConstructionMaterialsconstructiondesc--------------------DIV
CoolingcoolingdescDIVOKOKDIVOKDIVOKDIVDIVDIVDIV
FireplaceFeaturesfireplacedesc----DIVDIVOKOKOK--DIVDIV--
Flooringfloordesc--OKDIVOKOKOKOK--DIVOK--
HeatingheatingdescDIVOKOKOKOKOKOKOKDIVDIVDIV
LotFeatureslotdesc------DIVDIVDIVOK--DIVDIVDIV
ParkingFeaturesparkingdescDIVDIV--DIVOKDIVOK--DIVDIV--
PatioAndPorchFeaturespatioandporchdesc--OK------------------
PoolFeaturespooldesc--DIVOKDIVDIV--OK--DIVDIVDIV
Roofroofdesc--OKDIVOKOKOKOK--DIVOK--
Sewersewerdesc--OKOKOKOKOKOKOKDIVOKDIV
TaxLegalDescriptiontaxlegaldesc--OK------------------
Viewviewdesc----OKOKDIV--OK--DIVDIV--
WaterSourcewaterdesc----OKDIVDIV--OK--DIV--DIV