Created: April 23, 2009
Download: Text Sample (tab delimited) or Text Sample (pipe delimited)
| 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 # | 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. Beautiful London Flat!, 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 | N/A. Please leave blank as this field does not apply to listings located outside of the U.S. |
|
| AddrCity | varchar | 150 | Please provide the appropriate international city name based on NYT's international location taxonomy. Click here to obtain a complete list of international city names currently available within the NYT international location taxonomy. |
|
| Subdivision | varchar | 100 | ||
| AddrCounty | varchar | 150 | ||
| AddrState | varchar | 2 | N/A. Please leave blank as this field does not apply to listings located outside of the U.S and Canada. |
|
| AddrZip | varchar | 6 | N/A. Please leave blank as this field does not apply to listings located outside of the U.S and Canada. |
|
| AddrCountry | varchar | 3 | ISO 3166-1 alpha-3 codes. Please click here for a list of accepted values. If left blank the system will assume USA. |
|
| 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 who 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 | ||
| LotSizeDisplay | varchar | 50 | Lot size must be entered in United States customary units (acres). Conversion tools like the following: http://www.amadeus.net/home/converters/en/area_en.htm are accessible on the web for free if you need assistance |
|
| RoomsTotal | decimal | 18,2 | ||
| Stories | int | Number of floors |
||
| BuiltYear | int | 4 | ||
| SqFeetInterior | int | Square Feet must be entered in United States customary units. Conversion tools like the following: http://www.amadeus.net/home/converters/en/area_en.htm are accessible on the web for free if you need assistance |
||
| SqFeetInteriorDisplay | varchar | 50 | Square Feet must be entered in United States customary units. Conversion tools like the following: http://www.amadeus.net/home/converters/en/area_en.htm are accessible on the web for free if you need assistance |
|
| SqFootAveragePrice | money | Average price per square foot must be entered in United States customary units. Conversion tools like the following: http://www.amadeus.net/home/converters/en/area_en.htm are accessible on the web for free if you need assistance |
||
| 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:
Text:
Links:
Lists:
Text Alignment: |
|
| 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 | Please include the appropriate country code if outside the U.S. and Canada |
|
| Agent1Photo | varchar | 150 | ||
| Agent1Logo | varchar | 150 | ||
| Agent2Id | varchar | 30 | ||
| Agent2Name | varchar | 50 | ||
| Agent2Email | varchar | 70 | ||
| Agent2PhonePrimary | varchar | 20 | Please include the appropriate country code if outside the U.S. and Canada |
|
| 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 |
| Value | Definition |
|---|---|
| 1 | Finished |
| 2 | Partial |
| 3 | Yes |
| 4 | Cellar |
| 5 | Crawl Space |
| 6 | Full |
| 7 | Half |
| 8 | Slab |
| 9 | Unfinished |
| 10 | Walk-out |
| 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 |
| Value | Definition |
|---|---|
| 1 | Central A/C |
| 2 | Electric |
| 3 | Gas |
| 4 | Oil |
| Value | Definition |
|---|---|
| S | Sales |
| R | Rentals |
| Value | Definition |
|---|---|
| 1 | New Construction |
| 2 | Luxury |
| 4 | Vacation |
| 8 | Retirement |
| 16 | Open House |
| 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 |
| 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 |
| Value | Definition |
|---|---|
| 1 | Garage |
| 2 | Carport |
| 3 | Off Street Available |
| Value | Definition |
|---|---|
| 1 | Pets Allowed |
| 2 | Cats Only |
| 3 | No Pets |
| 4 | Small Dogs |
| 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 |
| 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 |
| 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 |