Created: January 5, 2009
Download: Text Sample (tab delimited) or Text Sample (pipe delimited)
Updated: January 27, 2009 (Change Log)
| 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. 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. |
|
| 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:
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 | ||
| 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 |
| 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 |