FrontDoor

Real Estate Feed Upload Format

Author: Anthony Caccese
Download: XML Sample or Text Sample (pipe delimited)
Created: October 15, 2007
Updated: February 6, 2008 (Change Log)

March 26, 2008: Updated "Address" and "AddrDisplay" fields with clarification of their use

February 6, 2008: Added "IdAccount" field to Field Layout, XML Sample and Text Sample

Getting started
Loading Schedule
Field Layout (Listings)
Code Dictionary
Multimedia

Getting started

Files should be sent in either xml or delimited text file format
If information is not available, please leave field blank, but include a node (ex. if no data available for "AddrCrossStreet" field please send as <AddrCrossStreet/>
For XML - Please include <![CDATA[ ]]> in the following nodes to avoid special character errors during loading
- Address
- AddrDisplay
- AddrCrossStreet
- AddrNeighborhood
- AddrCity
- Subdivision
- SchoolElementary
- SchoolMiddle
- SchoolHigh
- CommentsShort
- CommentsLong
- BuildingName
- All Multimedia Caption Fields

Loading Schedule (Listings)

Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
	2pm	2pm	2pm	2pm	2pm

Field Layout (Listings)

(Highlighted = Required Field)

Field Name	Type	Length	Description
IdWeb	varchar	50	Your unique listing identifier
IdAccount	int		Your IdAccount supplied by FrontDoor
IdCommunity	int
Address	varchar	150	The actual address of your listing. This info will be used to figure out lat/lon values (if not already supplied) for your lisitng in order to give it a proper location on our maps
AddrDisplay	varchar	150	The address you wish to display to users of site in place of the real address for the listing.
AddrCrossStreet	varchar	150
AddrNeighborhood	varchar	150
AddrCity	varchar	150
Subdivision	varchar	100
AddrCounty	varchar	150
AddrState	varchar	50
AddrZip	varchar	12	5 digit zipcode only
AddrCountry	varchar	3	ISO 3166-1 alpha-3 codes. Please see Wikipedia for accepted values. If left blank we will assume USA.
Latitude	float		If not supplied, we will geocode using CASS certified geocoding
Longitude	float		If not supplied, we will geocode using CASS certified geocoding
SchoolDistrictId	varchar	50
SchoolElementary	varchar	50
SchoolMiddle	varchar	50
SchoolHigh	varchar	50
CodeBasement	bigint		Please refer to CodeBasement in the Code Dictonary section for available values
CodeConstructionType	bigint		Please refer to CodeConstructionType in the Code Dictonary section for available values
CodeCoolingType	bigint		Please refer to CodeCoolingType in the Code Dictonary section for available values
CodeFeatured	bit		0 or 1
CodeListingType	bigint		Please refer to CodeListingType in the Code Dictonary section for available values
CodeLotFeature	bigint		Please refer to CodeLotFeature in the Code Dictonary section for available values
CodeMarketStatus	bigint		Please refer to CodeMarketStatus in the Code Dictonary section for available values
CodeParking	bigint		Please refer to CodeParking in the Code Dictonary section for available values
CodePets	bigint		Please refer to CodePets in the Code Dictonary section for available values
CodePopularFeature	bigint		Please refer to CodePopularFeature in the Code Dictonary section for available values
CodePropertyType	bigint		Please refer to CodePropertyType in the Code Dictonary section for available values
CodeStyle	bigint		Please refer to CodeStyle in the Code Dictonary section for available values
NewConstruction	bit		0 or 1
CommentsShort	varchar	250	We may construct these from "CommentsLong"
CommentsLong	varchar	max
DateNewSource	smalldatetime
BuiltYear	varchar	16
MonthlyCCMaintainence	money
PriceMin	money
Price	money
PriceDisplay	varchar	20
RealEstateTaxAnnual	money
RealEstateTaxYear	varchar	4
BathsFull	int
BathsPartial	int
Bedroom	int
SqFootAveragePrice	money
LotAcreage	decimal	18,2
LotSizeDisplay	varchar	50
RoomsTotal	decimal	18,2
SqFeetInterior	int
SqFeetInteriorDisplay	varchar	50
Stories	int
BuildingName	varchar	50
BuildingFloorsTotal	decimal	18,2
BuildingUnitsTotal	int
UnitAptId	varchar	50
Photo1	varchar	127
Photo1Caption	varchar	200
Photo2	varchar	127
Photo2Caption	varchar	200
Photo3	varchar	127
Photo3Caption	varchar	200
Photo4	varchar	127
Photo4Caption	varchar	200
Photo5	varchar	127
Photo5Caption	varchar	200
Photo6	varchar	127
Photo6Caption	varchar	200
Photo7	varchar	127
Photo7Caption	varchar	200
Photo8	varchar	127
Photo8Caption	varchar	200
Photo9	varchar	127
Photo9Caption	varchar	200
Photo10	varchar	127
Photo10Caption	varchar	200
Photo11	varchar	127
Photo11Caption	varchar	200
Photo12	varchar	127
Photo12Caption	varchar	200
Photo13	varchar	127
Photo13Caption	varchar	200
Photo14	varchar	127
Photo14Caption	varchar	200
Photo15	varchar	127
Photo15Caption	varchar	200
Photo16	varchar	127
Photo16Caption	varchar	200
Photo17	varchar	127
Photo17Caption	varchar	200
Photo18	varchar	127
Photo18Caption	varchar	200
Photo19	varchar	127
Photo19Caption	varchar	200
Photo20	varchar	127
Photo20Caption	varchar	200
Floorplan1	varchar	127
Floorplan1Caption	varchar	200
Floorplan2	varchar	127
Floorplan2Caption	varchar	200
Floorplan3	varchar	127
Floorplan3Caption	varchar	200
Floorplan4	varchar	127
Floorplan4Caption	varchar	200
Floorplan5	varchar	127
Floorplan5Caption	varchar	200
VirtualTour	varchar	127
VideoTour	varchar	127
AdvertiserHomePageURL	varchar	172
AdvertiserListingURL	varchar	172
AdvertiserLogo	varchar	100
AdvertiserName	varchar	70
Agent1Id	varchar	30
Agent1Name	varchar	50
Agent1Email	varchar	70
Agent1PhonePrimary	varchar	20
Agent1Photo	varchar	150
Agent1Logo	varchar	150
Agent2Id	varchar	30
Agent2Name	varchar	50
Agent2Email	varchar	70
Agent2PhonePrimary	varchar	20
Agent2Photo	varchar	150
Agent2Logo	varchar	150

Open Houses

To include open house dates and times on your listing details pages the following fields must be filled out in your broker's listing feed. Contact your IT manager or webmaster to add this information.

Field Name	Type	Length
OpenHouse1Date	datetime
OpenHouse1Time	varchar	50
OpenHouse2Date	datetime
OpenHouse2Time	varchar	50

Code Dictonary

CodeBasement
Value	Definition
1	Cellar
2	Crawl Space
4	Finished
8	Full
16	Half
32	None
64	Partial
128	Slab
256	Unfinished
512	Walk-out
1024	Yes

CodeConstructionType
Value	Definition
1	Aluminum
2	Brick & Frame
4	Brick 3 sides
8	Brick 4 sides
16	Brick front
32	Cedar
64	Concrete siding
128	Frame
256	Log
512	Rough Sawn
1024	Shingle
2048	Stone
4096	Stucco
8192	Vinyl

CodeCoolingType
Value	Definition
1	A/C

CodeListingType
Value	Definition
1	New Construction
2	Luxury
4	Vacation
8	Retirement

CodeLotFeature
Value	Definition
1	Golf Course
2	Waterfront

CodeMarketStatus
Value	Definition
1	Available
2	In Contract
4	Price Reduced
8	Rented
16	Sold
32	Back on Market
64	Pre-foreclosure
128	Auction
256	Bank owned/REO

CodeParking
Value	Definition
1	1 Car Garage
2	2 Car Garage
4	3 Car Garage
8	4 Car Garage
16	5 Car Garage
32	6+ Car Garage
64	Carport

CodePets
Value	Definition
1	Pets Allowed
2	Cats Only
4	No Pets

CodePopularFeature
Value	Definition
1	Fireplace
2	Swimming Pool
4	Deck/Patio
8	New Construction
16	Retirement

CodePropertyType
Value	Definition
1	Single Family
2	Multi Family
4	Condo
8	Land
16	Townhouse
32	Other

CodeStyle
Value	Definition
1	1 Story
2	2 Story
4	3 Story
8	4 Story
16	Brick
32	CapeCod
64	Colonial
128	Contemporary
256	Custom
512	Mediterranean
1024	Raised Ranch
2048	Ranch
4096	Spanish
8192	Split Foyer
16384	Split Level
32768	Stucco
65536	Townhouse
131072	Traditional
262144	Victorian

Multimedia

Field 116 & Field 122 - Agent1Photo & Agent2Photo
- What is it - Photo of the agent listing the property
- File Type - JPG
- Dimensions - prefered 4:3 ratio and in portrait layout
- Naming - File can be named anything you wish. Please no spaces or special characters.
- Format for feed - full path (ex. http://www.yoursite.com/picture.jpg)

Fields 56 to 95 - Photo1 to Photo20 and associated caption fields
- What is it - Listing Photos
- File Type - JPG
- Dimensions - prefered 4:3 ratio
- Naming - File can be named anything you wish. Please no spaces or special characters.
- Format for feed - full path (ex. http://www.yoursite.com/picture.jpg)
- Captions - short description of the current photo

Fields 96 to 105 - Floorplan1 to Floorplan5 and associated caption fields
- What is it - Floorplans of the property
- File Type - JPG, GIF
- Dimensions - can be any size (recommended is 640w x 450h)
- Naming - File can be named anything you wish. Please no spaces or special characters.
- Format for feed - full path (ex. http://www.yoursite.com/florplan.jpg)
- Captions - short description of the current floorplan

Field 106 - VirtualTour
- What is it - VirtualTour for the property
- Format for feed - full path (ex. http://www.yoursite.com/virtualtour.html)

Field 107 - VideoTour
- What is it - VideoTour for the property
- Format for feed - full path (ex. http://www.yoursite.com/video.html)

FrontDoor

Real Estate Feed Upload Format

Contents

Getting started

Loading Schedule (Listings)

Field Layout (Listings)

(Highlighted = Required Field)

Open Houses

To include open house dates and times on your listing details pages the following fields must be filled out in your broker's listing feed. Contact your IT manager or webmaster to add this information.

Code Dictonary

Multimedia