Ask Your Question

Feature Array

asked 2016-04-12 13:37:31 -0600

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Previously when I downloaded the listings file with the FTP, there was a field that had all the features of a home listed in one field. Each feature corresponded to value that represented if it was the power company, the water company, type of roof, parking, etc.. With RETS, each of these are a different field. Is there an option that would allow me to obtain this info similar to the way before without needing a database field for each feature?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2016-04-12 14:45:59 -0600

updated 2016-04-15 06:29:12 -0600

No. RETS doesn't have a single field. Each "LFD_*" field in RETS corresponds to a specific feature category attached to the listing and each category can have multiple selections.

If you do need them all as one, you would have to combine the contents of each "LFD_*" field in your client.

You would have to list each individual field. You can't use wildcards in a select. I was just pointing out that the individual fields used for features all start with "LFD_". Also, the field names are different for each property class and MLS.

So for example with the RE_1 class you would take the results from the following fields and combine them to get your one long value: LFD_Occupant_1, LFD_Showinginstructions_2, LFD_Location_3, LFD_Access_4, LFD_Landusetopography_5, LFD_Possession_6, LFD_Specialitems_7, LFD_Assocfeeincludes_8, LFD_Documentsonfile_9, LFD_Utilitiesavailable_10, LFD_Water_11, LFD_Sewer_12, LFD_GasCompany_13, LFD_ElectricCompany_14, LFD_WaterCompany_15, LFD_TVCable_16, LFD_Style_17, LFD_Construction_18, LFD_Foundation_19, LFD_Exteriorfinish_20, LFD_Roof_21, LFD_Garagetype_22, LFD_Heating_23, LFD_Cooling_24, LFD_Waterheater_25, LFD_Attic_26, LFD_Walls_27, LFD_DoorsAndwindows_28, LFD_Basement_29, LFD_Laundrylocation_30, LFD_Diningkitchen_31, LFD_Appliances_32, LFD_Bathfeatures_33, LFD_Floorcovering_34, LFD_Fireplacewoodstove_35, LFD_Interiorfeatures_36, LFD_Exteriorfeatures_37, LFD_Extras_38, LFD_Restrictions_39, LFD_Easements_40, LFD_Specialconditions_41

If you want the field lookup LongValue returned you would search with Format=COMPACT-DECODED if you want the Value returned (the numeric value for the features) you would set Format=COMPACT. The values are returned as a comma separated list.

edit flag offensive delete link more


One more question along this line. I can't find a way to use a wildcard in a SELECT option. Is it correct that a wildcard cannot be used to SELECT all LFD_* fields in a search? I need to specify each LFD_ field?


bildun gravatar imagebildun ( 2016-04-14 21:56:50 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-04-12 13:37:31 -0600

Seen: 1,233 times

Last updated: Apr 15 '16