NYTimes & Great Homes

Real Estate Feed Upload Format (USA & Canada Listings Only)

Created: January 5, 2009
Download: Text Sample (tab delimited) or Text Sample (pipe delimited)
Updated: January 27, 2009 (Change Log)

April 23, 2009
Added Clarifications on fields and new spec for Listings outside of the USA and Canada

Contents

  1. Getting started
  2. Loading Schedule
  3. Field Layout (Listings)
  4. Code Dictionary
  5. Multimedia

Getting started


Loading Schedule Start/End (Listings)

Sunday Monday Tuesday Wednesday Thursday Friday Saturday
6:30am/9:30am
9am/12pm
3pm/6pm
6:30am/9:30am
9am/12pm
3pm/6pm
6:30am/9:30am
9am/12pm
3pm/6pm
6:30am/9:30am
9am/12pm
3pm/6pm
6:30am/9:30am
9am/12pm
3pm/6pm
6:30am/9:30am
9am/12pm
3pm/6pm
6:30am/9:30am
9am/12pm
3pm/6pm

Field Layout (Listings)

(Highlighted = Required Field)
Field # Field Name Type Length Description
IdWeb varchar 40

Your unique listing identifier

May only contain the following characters - Letters, Numbers, Underscore, Hyphen

IdForeignKey varchar 50

If your listing has a secondary ID from another source (such as an MLS) please populate it in this field

IdAccount int

Your IdAccount supplied by NYTimes

IdCommunity int
DateNewSource smalldatetime

The date a listing was put on the market

Address varchar 150

The actual address of your listing. This info will be used to determine lat/lon values for your listing in order to assign it a proper location on our maps. It will not be displayed to users UNLESS 1) There is no value entered in the "AddrDisplay" field (below) or 2) The listing is advertising an upcoming open house.

AddrDisplay varchar 150

The value entered within this field will be displayed to all users. This is the field to include headline information (e.g. Fabulous NYC Condo!, etc.). Please note that the value in this field will not be displayed if the listing is advertising an upcoming open house. The address information listed in the "Address" field (above) will be displayed automatically when an open house is advertised.

AddrCrossStreet varchar 150
AddrNeighborhood varchar 150

NOTE: At this time the data for this field will be calculated from the geocoded location of your listing against the neighborhood boundaries in use on the site.
Neighborhood Taxonomy Definitions

AddrCity varchar 150

Please provide a city name recognized by the USPS. If the city name that you provide is not recognized, then NYT will attempt to assign a city match during data processing based on the zip code that you provided (USA and Canada only).

Subdivision varchar 100
AddrCounty varchar 150
AddrState varchar 2

Please provide the appropriate 2 letter state abbreviation recognized by the USPS.

AddrZip varchar 6

Please provide the appropriate Zip/Postal code recognized. For listings in the USA, please only provide the first 5 zip code numbers as NYT will only use the first 5 numbers even if all 9 are provided. Please note that this field is not required unless a City and State are NOT provided.

AddrCountry varchar 3

Please leave this field blank if you are advertising a listing in the United States. If you are advertising a listing in Canada, please enter the following country code: CAN

UnitAptId varchar 50

The unit# of a listing.

Latitude float

At this time Latitude/Longitude is calculated based off of the address sent for a listing

Longitude float

At this time Latitude/Longitude is calculated based off of the address sent for a listing

Price money

Please provide the appropriate price of your listing in this field. Please note that all prices must be entered in US dollars. We feature a currency converter module on all of our listing detail pages for users that wish to calculate the listing's price in a different currency.

PriceDisplay varchar 20

Must be provided in US dollars.

PriceMin money

Must be provided in US dollars.

MonthlyCCMaintainence money

Must be provided in US dollars.

Bedroom int
BathsFull int
BathsPartial int
LotAcreage decimal 18,2

Lot size must be entered in United States customary units (acres).

LotSizeDisplay varchar 50

Lot size must be entered in United States customary units (acres).

RoomsTotal decimal 18,2
Stories int

Number of floors

BuiltYear int 4
SqFeetInterior int

Square Feet must be entered in United States customary units.

SqFeetInteriorDisplay varchar 50

Square Feet must be entered in United States customary units.

SqFootAveragePrice money

Average price per square foot must be entered in United States customary units.

RealEstateTaxMonthly money

The monthly property taxes for a listing should be entered in this field (US dollars only).

RealEstateTaxYear int 4

The year that "RealEstateTaxMonthly" data was recorded should be entered in this field.

BuildingName varchar 50

If a listing is in a building please indicate the name of that building in this field.

BuildingUnitsTotal int

The total number of units in the building that a listing is in.

BuildingFloorsTotal int

The total number of floors of the building that a listing is located in.

CommentsLong varchar 8000

The Description of the Listing:
Any comments you want to display along with Listing. Brokers may use limited HTML wich includes but is not limited to bold, italic, underline tags. Also <a> linking tags, lists, buttons and other useful pieces of HTML.

Text:

To make a word or series of words bold suround desired text with <strong></strong>. For example <strong>Apples</strong> will yield; Apples.

To make a word or series of words italicized suround desired text with <em></em>. For example <em>Apples</em> will yield; Apples.

To make a word or series of words underlined suround desired text with <u></u>. For example <u>Apples</u> will yield; Apples.

You can combine tags as well ... <strong><em><u>Apples</u></em></strong>
will yield; Apples.

More @ w3schools.

Links:
To create a hyperlink you can use the <a></a> tag. When text is surrounded by this tag, it will be an "anchor" and can receive attributes that will execute specific operations. One common and useful attribute is the "href" attribute. When implemented it looks like:
<a href="http://realestate.nytimes.com">New York Times Real Estate</a> will yield;
New York Times Real Estate
More @ w3schools.

Lists:
Lists are VERY useful HTML objects that can take many forms. The most common is the unordred list. There are a couple of tags required to create a list, and it's items. First you must open a <ul>, you then create list items with <li></li>, and finaly close the list with </ul>. So a sample list may look like...
<ul>
<li>Apples</li>
<li>Peaches</li>
<li>Pears</li>
<li>Bananas</li>
</ul>
This would render in a browser like this...

  • Apples
  • Peaches
  • Pears
  • Bananas
more @ w3schools

Text Alignment:
To center align a block of text please use: <div style="text-align:center">your text here</div>
To right align a block of text please use: <div style="text-align:right">your text here</div>
*Text is left aligned by default
more @ w3schools

OpenHouse1Date datetime
OpenHouse1Time varchar 50
OpenHouse2Date datetime
OpenHouse2Time varchar 50
SchoolDistrictId varchar 50
SchoolElementary varchar 50
SchoolMiddle varchar 50
SchoolHigh varchar 50
Photo1 varchar 300
Photo2 varchar 300
Photo3 varchar 300
Photo4 varchar 300
Photo5 varchar 300
Photo6 varchar 300
Photo7 varchar 300
Photo8 varchar 300
Photo9 varchar 300
Photo10 varchar 300
Photo11 varchar 300
Photo12 varchar 300
Photo13 varchar 300
Photo14 varchar 300
Photo15 varchar 300
Photo16 varchar 300
Photo17 varchar 300
Photo18 varchar 300
Photo19 varchar 300
Photo20 varchar 300
Floorplan1 varchar 300
Floorplan2 varchar 300
Floorplan3 varchar 300
Floorplan4 varchar 300
Floorplan5 varchar 300
VirtualTour varchar 210
VideoTour varchar 210
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
CodeFeatured bit

0 » "Not Featured"

1 » "Featured"

CodeBasement varchar

The type of basement available for a listing

Please send single value from CodeBasement definitions

CodeConstructionType varchar

The construction material a listing is made of

Please send single value from CodeConstructionType definition

CodeCoolingType varchar

Types of cooling/heating features available for a listing

You may send multiple values from CodeCoolingType definition separated by comma

Example format: 1,3 » Means a listing has Central A/C and Gas Heating

CodeListingType varchar

Determines what section of the site a listing should appear in

Please send single value from CodeListingType definition

CodeAdditionalListingType varchar

Determines what subsection a listing should appear in

Please refer to CodeAdditionalListingType for available values

Values can be added together to denote that a listing should appear in muliple subsections. For example a value of 10 means that a listing should be in both the Retirement and Luxury subsections

CodeLotFeature varchar

Describes the available features for the surrounding lot of a listing

You may send multiple values from CodeLotFeature definition separated by comma

Example format: 5,9 » Means a listing has access to a Beach and Tennis Courts

CodeMarketStatus varchar

Defines the current status of a listing

Please send single value from CodeMarketStatus definition

CodeParking varchar

Describes the parking options available for a listing

You may send multiple values from CodeParking definition separated by comma

Example format: 1,3 » Means a listing has a Garage and Off Street Available

CodePets varchar

Describes the pets options available for a listing

Please send single value from CodePets definition

CodePopularFeature varchar

Defines the amenities available for a listing

You may send multiple values from CodePopularFeature definition separated by comma

Example format: 1,3 » Means a listing has a Fireplace and a Deck

CodePropertyType varchar

Defines the "property type" of a listing

Please send single value from CodePropertyType definition

CodeStyle varchar

Defines the housing style of a listing

Please send single value from CodeStyle definition


Code Dictonary

CodeBasement
Value Definition
1 Finished
2 Partial
3 Yes
4 Cellar
5 Crawl Space
6 Full
7 Half
8 Slab
9 Unfinished
10 Walk-out
CodeConstructionType
Value Definition
1 Aluminum
2 Brick & Frame
3 Brick 3 sides
4 Brick 4 sides
5 Brick front
6 Cedar
7 Concrete siding
8 Frame
9 Log
10 Rough Sawn
11 Shingle
12 Stone
13 Stucco
14 Vinyl
CodeCoolingType
Value Definition
1 Central A/C
2 Electric
3 Gas
4 Oil
CodeListingType
Value Definition
S Sales
R Rentals
CodeAdditionalListingType
Value Definition
1 New Construction
2 Luxury
4 Vacation
8 Retirement
16 Open House
CodeLotFeature
Value Definition
1 Golf Course
2 Waterfront
3 Mountain
4 Metro Area
5 Beach
6 Resort
7 Ski
8 Near Public Transportation
9 Tennis Courts
10 Park/Playground
11 Bike Paths
12 Controlled Access
13 Retirement Community
14 Adult Community
15 Corporate Apartment
CodeMarketStatus
Value Definition
1 Available
2 In Contract
3 Price Reduced
4 Rented
5 Sold
6 Back on Market
7 Pre-foreclosure
8 Auction
9 Bank owned/REO
CodeParking
Value Definition
1 Garage
2 Carport
3 Off Street Available
CodePets
Value Definition
1 Pets Allowed
2 Cats Only
3 No Pets
4 Small Dogs
CodePopularFeature
Value Definition
1 Fireplace
2 Swimming Pool
3 Deck
4 Dining Room
5 Balcony
6 Doorman
7 Elevator
8 Fitness Center
9 Furnished
10 Garden/Patio
11 Live/Work
12 Loft
13 Multi-Level
14 Pre-War
15 Terrace
16 Washer/Dryer in Bldg
17 Washer/Dryer in Unit
18 Alarm
19 Cable/Satellite TV
20 High Speed Internet
21 Green Building
22 Carpeted Floors
23 Dishwasher
24 Garbage Disposal
25 Hardwood Floors
26 Wheelchair Access
27 Spa/Jacuzzi
28 No Fee
29 Outdoor Space
30 New Construction
31 Investment Property
CodePropertyType
Value Definition
1 Single Family House
2 Single Family Townhouse
3 Multi Family House
4 Multi Family Townhouse
5 Condo
6 Co-op
7 Co-op/Condo
8 Land
9 Rental
10 Apartment
11 Share/Roomate
12 Room
13 Exchange
14 Time Share
15 Sublet
16 Other
CodeStyle
Value Definition
1 1 Story
2 2 Story
3 3 Story
4 4 Story
5 Brick
6 CapeCod
7 Colonial
8 Contemporary
9 Custom
10 Mediterranean
11 Raised Ranch
12 Ranch
13 Spanish
14 Split Foyer
15 Split Level
16 Stucco
17 Townhouse
18 Traditional
19 Victorian

Multimedia