DROP TABLE IF EXISTS `vacareas`;
CREATE TABLE `vacareas`(`Area` VARCHAR(50) ,`AreaID` INT AUTO_INCREMENT,PRIMARY KEY (`AreaID`));
DROP TABLE IF EXISTS `vacbathrooms`;
CREATE TABLE `vacbathrooms`(`bathrooms` INT ,`bathroomsID` INT AUTO_INCREMENT,PRIMARY KEY (`bathroomsID`));
DROP TABLE IF EXISTS `vacbedrooms`;
CREATE TABLE `vacbedrooms`(`bedrooms` INT ,`bedroomsID` INT AUTO_INCREMENT,PRIMARY KEY (`bedroomsID`));
DROP TABLE IF EXISTS `vaclocations`;
CREATE TABLE `vaclocations`(`Location` VARCHAR(50) ,`LocationID` INT AUTO_INCREMENT,PRIMARY KEY (`LocationID`));
DROP TABLE IF EXISTS `vacusers`;
CREATE TABLE `vacusers`(`email` VARCHAR(50) ,`group` VARCHAR(50) ,`ID` INT AUTO_INCREMENT,`password` VARCHAR(50) ,`username` VARCHAR(50) ,PRIMARY KEY (`ID`));
DROP TABLE IF EXISTS `vacproperties`;
CREATE TABLE `vacproperties`(`AddressNumber` INT ,`AirConditioning` TINYINT(2) ,`Area` VARCHAR(50) ,`bathrooms` INT ,`BedLinensProvided` TINYINT(2) ,`bedrooms` INT ,`CableTV` TINYINT(2) ,`City` VARCHAR(50) ,`CommunityClubHouse` TINYINT(2) ,`CommunityFacilities` TINYINT(2) ,`CommunityPool` TINYINT(2) ,`CommunityTennisCourts` TINYINT(2) ,`Country` VARCHAR(50) ,`Description` LONGTEXT ,`Dishwasher` TINYINT(2) ,`DVDVCR` TINYINT(2) ,`Elevator` TINYINT(2) ,`EnclosedOutsideShower` TINYINT(2) ,`Fireplace` TINYINT(2) ,`FromPrice` INT ,`GameRoom` TINYINT(2) ,`Golf` TINYINT(2) ,`Grill` TINYINT(2) ,`HandicapFriendly` TINYINT(2) ,`HeatedPool` TINYINT(2) ,`HighSpeedInternet` TINYINT(2) ,`HotTub` TINYINT(2) ,`Kitchen` TINYINT(2) ,`ListingDescription` LONGTEXT ,`ListingPhoto` VARCHAR(50) ,`Location` VARCHAR(50) ,`Microwave` TINYINT(2) ,`Name` VARCHAR(50) ,`NonSmoking` TINYINT(2) ,`PetsAllowed` TINYINT(2) ,`Photo1` VARCHAR(50) ,`Photo10` VARCHAR(50) ,`Photo11` VARCHAR(50) ,`Photo12` VARCHAR(50) ,`Photo13` VARCHAR(50) ,`Photo14` VARCHAR(50) ,`Photo15` VARCHAR(50) ,`Photo2` VARCHAR(50) ,`Photo3` VARCHAR(50) ,`Photo4` VARCHAR(50) ,`Photo5` VARCHAR(50) ,`Photo6` VARCHAR(50) ,`Photo7` VARCHAR(50) ,`Photo8` VARCHAR(50) ,`Photo9` VARCHAR(50) ,`PoolTable` TINYINT(2) ,`PrivatePool` TINYINT(2) ,`PropertyID` INT AUTO_INCREMENT,`ScreenedPorch` TINYINT(2) ,`State` VARCHAR(50) ,`Street` VARCHAR(50) ,`Type` VARCHAR(50) ,`WasherDryer` TINYINT(2) ,PRIMARY KEY (`PropertyID`));
DROP TABLE IF EXISTS `vacpropertytype`;
CREATE TABLE `vacpropertytype`(`propertytype` VARCHAR(50) ,`propertytypeID` INT AUTO_INCREMENT,PRIMARY KEY (`propertytypeID`));
DROP TABLE IF EXISTS `vacreservations`;
CREATE TABLE `vacreservations`(`FromDate` VARCHAR(50) ,`PropertyID` INT ,`RentersAddress` VARCHAR(50) ,`RentersName` VARCHAR(50) ,`RentersPhoneNumber` VARCHAR(50) ,`ReservationID` INT AUTO_INCREMENT,`status` INT ,`ToDate` VARCHAR(50) ,PRIMARY KEY (`ReservationID`));
DROP TABLE IF EXISTS `vacstates`;
CREATE TABLE `vacstates`(`State` VARCHAR(50) ,`StateAbbreviation` VARCHAR(50) ,`StateID` INT AUTO_INCREMENT, PRIMARY KEY (`StateID`));
DROP TABLE IF EXISTS `vacstatus`;
CREATE TABLE `vacstatus`(`status` VARCHAR(50) ,`ID` INT AUTO_INCREMENT,PRIMARY KEY (`ID`));
INSERT INTO `vacareas`(`AreaID`,`Area`) VALUES(1,'Corolla');
INSERT INTO `vacareas`(`AreaID`,`Area`) VALUES(2,'Kill Devil Hills');
INSERT INTO `vacareas`(`AreaID`,`Area`) VALUES(3,'Kitty Hawk');
INSERT INTO `vacareas`(`AreaID`,`Area`) VALUES(4,'Nags Head');
INSERT INTO `vacareas`(`AreaID`,`Area`) VALUES(5,'South Nags Head');
INSERT INTO `vacareas`(`AreaID`,`Area`) VALUES(6,'Southern Shores');
INSERT INTO `vacbathrooms`(`bathroomsID`,`bathrooms`) VALUES(1,1);
INSERT INTO `vacbathrooms`(`bathroomsID`,`bathrooms`) VALUES(2,2);
INSERT INTO `vacbathrooms`(`bathroomsID`,`bathrooms`) VALUES(3,3);
INSERT INTO `vacbathrooms`(`bathroomsID`,`bathrooms`) VALUES(4,4);
INSERT INTO `vacbathrooms`(`bathroomsID`,`bathrooms`) VALUES(5,5);
INSERT INTO `vacbathrooms`(`bathroomsID`,`bathrooms`) VALUES(6,6);
INSERT INTO `vacbathrooms`(`bathroomsID`,`bathrooms`) VALUES(7,7);
INSERT INTO `vacbathrooms`(`bathroomsID`,`bathrooms`) VALUES(8,8);
INSERT INTO `vacbathrooms`(`bathroomsID`,`bathrooms`) VALUES(9,9);
INSERT INTO `vacbathrooms`(`bathroomsID`,`bathrooms`) VALUES(10,10);
INSERT INTO `vacbedrooms`(`bedroomsID`,`bedrooms`) VALUES(1,1);
INSERT INTO `vacbedrooms`(`bedroomsID`,`bedrooms`) VALUES(2,2);
INSERT INTO `vacbedrooms`(`bedroomsID`,`bedrooms`) VALUES(3,3);
INSERT INTO `vacbedrooms`(`bedroomsID`,`bedrooms`) VALUES(4,4);
INSERT INTO `vacbedrooms`(`bedroomsID`,`bedrooms`) VALUES(5,5);
INSERT INTO `vacbedrooms`(`bedroomsID`,`bedrooms`) VALUES(6,6);
INSERT INTO `vacbedrooms`(`bedroomsID`,`bedrooms`) VALUES(7,7);
INSERT INTO `vacbedrooms`(`bedroomsID`,`bedrooms`) VALUES(8,8);
INSERT INTO `vacbedrooms`(`bedroomsID`,`bedrooms`) VALUES(9,9);
INSERT INTO `vacbedrooms`(`bedroomsID`,`bedrooms`) VALUES(10,10);
INSERT INTO `vacbedrooms`(`bedroomsID`,`bedrooms`) VALUES(11,0);
INSERT INTO `vaclocations`(`LocationID`,`Location`) VALUES(1,'Golf course');
INSERT INTO `vaclocations`(`LocationID`,`Location`) VALUES(2,'Oceanfront');
INSERT INTO `vaclocations`(`LocationID`,`Location`) VALUES(3,'Oceanview');
INSERT INTO `vaclocations`(`LocationID`,`Location`) VALUES(4,'Semi-Oceanfront');
INSERT INTO `vaclocations`(`LocationID`,`Location`) VALUES(5,'Semi-Oceanview');
INSERT INTO `vaclocations`(`LocationID`,`Location`) VALUES(6,'Soundside');
INSERT INTO `vacusers`(`ID`,`username`,`password`,`group`,`email`) VALUES(1,'admin','admin','admin',NULL);
INSERT INTO `vacproperties`(`PropertyID`,`Name`,`AddressNumber`,`Street`,`City`,`State`,`Country`,`Type`,`Area`,`Location`,`FromPrice`,`ListingDescription`,`Description`,`bedrooms`,`bathrooms`,`Kitchen`,`AirConditioning`,`Dishwasher`,`Microwave`,`WasherDryer`,`ScreenedPorch`,`BedLinensProvided`,`Fireplace`,`PoolTable`,`HighSpeedInternet`,`CableTV`,`DVDVCR`,`PrivatePool`,`HeatedPool`,`HotTub`,`Grill`,`EnclosedOutsideShower`,`GameRoom`,`Elevator`,`PetsAllowed`,`NonSmoking`,`CommunityFacilities`,`CommunityPool`,`CommunityTennisCourts`,`CommunityClubHouse`,`Golf`,`HandicapFriendly`,`ListingPhoto`,`Photo1`,`Photo2`,`Photo3`,`Photo4`,`Photo5`,`Photo6`,`Photo7`,`Photo8`,`Photo9`,`Photo10`,`Photo11`,`Photo12`,`Photo13`,`Photo14`,`Photo15`) VALUES(2,'Sunset',8793,'S. Virginia DareTrail MP: 16.3','Nags Head','NC','USA','House','Nags Head','Semi-Oceanfront',795,'From Sunrise to Sunset & All Times in between, this Outstanding Semi-Oceanfront will be Sure to Please Your Entire Group! Centrally Located Close to Area Dining, Shopping, Fishing, & Family Entertainment, & the Beach is Just Minutes Away (Beach Access is 50\' Across Beach Road).','<H3><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Rental Description</FONT></H3><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>From Sunrise to Sunset &amp; All Times in between, this Outstanding Semi-Oceanfront will be Sure to Please Your Entire Group! Centrally Located Close to Area Dining, Shopping, Fishing, &amp; Family Entertainment, &amp; the Beach is Just Minutes Away (Beach Access is 50\' Across Beach Road). This Home is Loaded w/All the Extras &amp; has Ocean to Sound Views.</FONT></P><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><U><B><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Ground Level:</FONT></U></B><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1> <B>Rec. Room w/Full Size Pool Table</B>, CATV, Queen Sleep Sofa, Laundry, Bedroom w/Queen, Full Bath, &amp; Access to the Pool Patio Area w/Picnic Table, <B>Private Swimming Pool, Hot Tub</B> (Closed Nov 1, 2006 to April 1, 2007), Enclosed Outside Shower, &amp; Park Grill.</FONT></P><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><U><B><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Mid Level:</FONT></U></B><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1> 4 bedrooms (1 Master Suite w/King &amp; Full Bath w/Jacuzzi, 2 w/Queens, &amp; 1 w/Duo Bunk &amp; Single), 2 Full Baths, &amp; Covered Deck.</FONT></P><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><U><B><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Top Level:</FONT></U></B><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1> Living/Dining/Kitchen Area, TV Entertainment System, Gas Fireplace, Half Bath, Sun Deck, &amp; Master Suite w/King &amp; Full Bath w/Jacuzzi.</FONT></P><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\"><FONT size=1><U>Features include:</U> C/AC &amp; Heat, Washer/Dryer, Dishwasher, Microwave, Phone, 4 CATV\'s, 4 VCR\'s, Stereo w/CD, Wireless Internet Access, Baby Equipment (High Chair, Baby Gate, &amp; Pac-N-Play), Pool &amp; Deck Furniture, &amp; Ocean Views. No Pets. This is a Non-Smoking Unit. </FONT></FONT></P><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Optional Bed Linens 125.00, Optional Bed Linens &amp; Towels 225.00</FONT></P><H3><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Rates - Sunday Check-in.</FONT></H3><CENTER><TABLE class=ratestable style=\"WIDTH: 484px; HEIGHT: 505px\" cellPadding=4 border=1><TBODY><TR><TH class=rateheads><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Start Date</FONT></TH><TH class=rateheads><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>End Date</FONT></TH><TH class=rateheads><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Rate</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>12/31/2006</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>05/05/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 795.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>05/06/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>05/19/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 950.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>05/20/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/02/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 1,195.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/03/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/09/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 1,995.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/10/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/16/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 2,895.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/17/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/30/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 3,295.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>07/01/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/11/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 3,995.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/12/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/18/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 3,295.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/19/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/25/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 2,895.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/26/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>09/01/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 1,995.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>09/02/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>09/15/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 1,195.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>09/16/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>10/13/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 950.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>10/14/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>11/17/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 795.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>11/18/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>11/24/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 950.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>11/25/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>01/05/2008</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 795.00/wk.</FONT></TH></TR></TBODY></TABLE><CENTER><SPAN class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\"><FONT size=1><B>Security Deposit:</B> $300</FONT></FONT></SPAN></CENTER></CENTER>',6,4,-1,-1,-1,-1,-1,0,0,-1,-1,-1,-1,-1,-1,0,-1,-1,-1,-1,0,0,-1,-1,-1,-1,0,0,-1,'sun-1-20070419-212743.jpg','sun-1-20070419-212743.jpg','sun-2-20070419-212747.jpg','sun-3-20070419-212750.jpg','sun-4-20070419-212752.jpg','sun-5-20070419-212756.jpg','sun-6-20070419-212759.jpg','sun-7-20070419-212802.jpg','sun-8-20070419-212806.jpg','sun-9-20070419-212809.jpg','sun-10-20070419-212811.jpg',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `vacproperties`(`PropertyID`,`Name`,`AddressNumber`,`Street`,`City`,`State`,`Country`,`Type`,`Area`,`Location`,`FromPrice`,`ListingDescription`,`Description`,`bedrooms`,`bathrooms`,`Kitchen`,`AirConditioning`,`Dishwasher`,`Microwave`,`WasherDryer`,`ScreenedPorch`,`BedLinensProvided`,`Fireplace`,`PoolTable`,`HighSpeedInternet`,`CableTV`,`DVDVCR`,`PrivatePool`,`HeatedPool`,`HotTub`,`Grill`,`EnclosedOutsideShower`,`GameRoom`,`Elevator`,`PetsAllowed`,`NonSmoking`,`CommunityFacilities`,`CommunityPool`,`CommunityTennisCourts`,`CommunityClubHouse`,`Golf`,`HandicapFriendly`,`ListingPhoto`,`Photo1`,`Photo2`,`Photo3`,`Photo4`,`Photo5`,`Photo6`,`Photo7`,`Photo8`,`Photo9`,`Photo10`,`Photo11`,`Photo12`,`Photo13`,`Photo14`,`Photo15`) VALUES(3,'Fay\'s Sunny Daze',9602,'S. Old Oregon Inlet Rd. MP: 19.5','South Nags Head','NC','USA','House','South Nags Head','Semi-Oceanview',750,'This gorgeous South Nags Head vacation home was completely remodeled in 2006 and is a wonderful choice for your families Outer Banks retreat.rTHE PRIVATE SWIMMING POOL WILL BE OPEN STARTING APRIL 1, 2007! ','<P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\"><FONT size=1><B>THE PRIVATE SWIMMING POOL WILL BE OPEN STARTING APRIL 1, 2007! CAN BE HEATED FOR $150.00 PER WEEK.</B> </FONT></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\"><FONT size=1>This gorgeous South Nags Head vacation home was completely remodeled in 2006 and is a wonderful choice for your families Outer Banks retreat. You will enjoy lovely Ocean Views from the Great Room and marvel at the Spectacular Sunsets &amp; Views over Ponds, Pines, &amp; the Roanoke Sound from the Dining Area &amp; Sun Deck. The Ocean is Just a Minutes Walk Away Across the Beach Road (Only 400 Ft. to Beach w/Direct Access). Your family will love spending time on the Beach, playing in the <B>Large 20 x 40 Private Swimming Pool</B> or Relaxing in the <B>Hot Tub</B>. Located in South Creek Acres, this home offers Access to a <B>Community Swimming Pool &amp; Tennis Courts.</B></FONT></FONT></P><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><B><U><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Ground Level:</FONT></B></U><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1> Parking for 4 Cars, Basketball Hoop, Enclosed Outside Shower, <B>Hot Tub, Private Swimming Pool</B> (Can be Heated for $150.00 Per Week), &amp; Gas Grill.</FONT></P><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><B><U><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Mid Level:</FONT></B></U><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1> 3 bedrooms (Master Suite w/Queen &amp; Full Bath &amp; 2 w/Duo Bunks w/Trundles), 1 Shared Full Bath, <B>Small Rec. Room w/Foosball</B>, &amp; 2 Covered Decks.</FONT></P><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><B><U><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Top Level:</FONT></B></U><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1> Nicely Decorated &amp; Very Comfortable Living/Dining/Kitchen Area w/ Ocean to Sound Views, CATV/VCR/DVD, Gas Fireplace, Bedroom w/Queen, CATV/DVD, Full Bath, Covered Deck, &amp; Sun Deck.</FONT></P><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\"><FONT size=1><U>Features include:</U> C/AC &amp; Heat, Washer/Dryer, Dishwasher, Microwave, Phone, CATV\'s, DVD/VCR Combo, Baby Equipment (High Chair), &amp; Deck &amp; Pool Furniture. No Pets. This is a Non-Smoking Unit. Optional Bed Linens 95.00, Optional Bed Linens &amp; Towels 170.00</FONT></FONT></P><H3><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Rates - Saturday Check-in.</FONT></H3><CENTER><TABLE class=ratestable style=\"WIDTH: 475px; HEIGHT: 392px\" cellPadding=4 border=1><TBODY><TR><TH class=rateheads><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Start Date</FONT></TH><TH class=rateheads><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>End Date</FONT></TH><TH class=rateheads><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Rate</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>12/30/2006</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>05/04/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 750.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>05/05/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>05/18/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 995.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>05/19/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/01/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 1,095.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/02/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/08/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 1,295.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/09/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/15/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 1,795.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/16/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/29/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 2,350.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/30/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/10/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 2,795.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/11/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/17/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 2,695.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/18/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/24/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 2,295.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/25/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/31/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 1,895.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>09/01/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>09/14/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 995.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>09/15/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>10/12/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 895.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>10/13/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>11/16/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 795.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>11/17/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>11/23/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 795.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>11/24/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>01/04/2008</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 795.00/wk.</FONT></TH></TR></TBODY></TABLE><CENTER><SPAN class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\"><FONT size=1><B>Security Deposit:</B> $300</FONT></FONT></SPAN></CENTER></CENTER>',4,3,-1,-1,-1,-1,-1,0,0,0,0,-1,-1,0,-1,0,0,-1,-1,-1,0,0,-1,0,-1,-1,-1,0,0,'fay-1-20070410-140659.jpg','fay-1-20070410-140659.jpg','fay-2-20070410-140702.jpg','fay-3-20070410-140706.jpg','fay-4-20070410-140710.jpg','fay-5-20070410-140855.jpg','fay-6-20070410-140859.jpg','fay-7-20070410-140902.jpg','fay-8-20070410-140906.jpg','fay-9-20070410-140909.jpg','fay-10-20070410-140911.jpg','fay-11-20070410-140915.jpg','fay-12-20070410-140918.jpg','fay-13-20070410-140921.jpg','fay-14-20070410-140926.jpg',NULL);
INSERT INTO `vacproperties`(`PropertyID`,`Name`,`AddressNumber`,`Street`,`City`,`State`,`Country`,`Type`,`Area`,`Location`,`FromPrice`,`ListingDescription`,`Description`,`bedrooms`,`bathrooms`,`Kitchen`,`AirConditioning`,`Dishwasher`,`Microwave`,`WasherDryer`,`ScreenedPorch`,`BedLinensProvided`,`Fireplace`,`PoolTable`,`HighSpeedInternet`,`CableTV`,`DVDVCR`,`PrivatePool`,`HeatedPool`,`HotTub`,`Grill`,`EnclosedOutsideShower`,`GameRoom`,`Elevator`,`PetsAllowed`,`NonSmoking`,`CommunityFacilities`,`CommunityPool`,`CommunityTennisCourts`,`CommunityClubHouse`,`Golf`,`HandicapFriendly`,`ListingPhoto`,`Photo1`,`Photo2`,`Photo3`,`Photo4`,`Photo5`,`Photo6`,`Photo7`,`Photo8`,`Photo9`,`Photo10`,`Photo11`,`Photo12`,`Photo13`,`Photo14`,`Photo15`) VALUES(4,'Octopus\'s Garden',1731,'Bobby Lee Trail MP: 07.0','Kill Devil Hills','NC','USA','House','Kill Devil Hills','Semi-Oceanview',895,'Built in 2003, this Fabulous Home (Just 1 Block from Beach) will be your Family\'s Favorite Vacation Get-A-Way for Years.','<P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Built in 2003, this Fabulous Home (Just 1 Block from Beach) will be your Family\'s Favorite Vacation Get-A-Way for Years. Located on a Quiet Cul-de-Sac, Octopus\'s Garden offers a Short Walk to the Beach &amp; Lots of Amenities, including 5 Master Suites, a <B>Private Pool, Hot Tub, Game Room w/Pool Table</B>, Basketball Goal, Horseshoe Pits, 2 Dishwashers, 2 Microwaves, 2 Refrigerators, &amp; a Fax Machine. With Something for Everyone, this Cottage is the Ideal Spot for Holidays, Family Gatherings, Weddings, &amp; even Business Retreats. This Spacious, Non-Smoking, Pet Free Cottage is the Perfect Place to Relax &amp; Enjoy the Charm of the Outer Banks.</FONT></P><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><B><U><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Ground Level:</FONT></B></U><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1> 3 bedrooms (Master Suite w/Queen &amp; Full Bath, 1 w/2 Bunk Sets, &amp; 1 w/Duo Bunk), 2 Full Baths, Game Room w/Pool Table, Wet Bar w/Full Size Refrigerator, CATV Entertainment Center &amp; Access to the Pool Patio area.</FONT></P><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><B><U><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Middle Level:</FONT></B></U><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1> 4 Master Suites w/Private Baths (2 w/Kings, 2 w/Queens), &amp; 2 Covered Decks (one w/Hot Tub).</FONT></P><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\"><FONT size=1><B><U>Top Floor:</U></B> Huge Living/Dining/Kitchen Area w/2 Sitting areas, Large Kitchen w/Breakfast Bar.</FONT></FONT></P><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\"><FONT size=1><U>Features include:</U> C/AC &amp; Heat, Washer/Dryer, 2 Ice Makers, 6 Phone\'s, 9 CATV\'s, 7 CATV/VCR\'s, 2 VCR/DVD\'s, 2 Stereo\'S, 7 Ceiling Fans, Wet Bar, Gas Fireplace, Baby Equipment (High Chair, Baby Gate, &amp; Pac-N-Play), Pool &amp; Deck Furniture, Outside Shower, Enclosed Outside Shower, &amp; Park Grill. No Pets. This is a Non-Smoking Unit!</FONT></FONT></P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Optional Bed Linens 135.00, Optional Bed Linens &amp; Towels 240.00 </FONT><P></P><H3><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Brochure Corrections</FONT></H3><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>2007 Security deposit is listed incorrectly. Prices for Sept 15 thru Oct 13 are incorrect.</FONT></P><H3><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Rates - Saturday Check-in.</FONT></H3><CENTER><TABLE class=ratestable style=\"WIDTH: 486px; HEIGHT: 502px\" cellPadding=4 border=1><TBODY><TR><TH class=rateheads><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Start Date</FONT></TH><TH class=rateheads><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>End Date</FONT></TH><TH class=rateheads><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Rate</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>12/30/2006</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>05/04/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 895.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>05/05/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>05/18/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 995.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>05/19/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/01/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 1,295.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/02/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/08/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 2,195.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/09/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/15/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 2,995.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/16/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/29/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 3,495.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/30/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/10/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 3,895.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/11/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/17/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 3,495.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/18/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/24/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 2,795.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/25/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/31/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 1,995.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>09/01/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>09/14/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 1,295.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>09/15/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>10/12/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 1,150.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>10/13/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>11/16/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 895.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>11/17/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>11/23/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 1,150.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>11/24/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>01/04/2008</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 895.00/wk.</FONT></TH></TR></TBODY></TABLE><CENTER><SPAN class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\"><FONT size=1><B>Security Deposit:</B> $400</FONT></FONT></SPAN></CENTER></CENTER>',7,6,-1,-1,-1,-1,-1,-1,0,-1,-1,-1,-1,-1,-1,0,-1,-1,-1,-1,0,0,-1,0,0,0,0,0,0,'oct-1-20070409-081802.jpg','oct-1-20070409-081802.jpg','oct-2-20070409-081833.jpg','oct-3-20070409-081835.jpg','oct-4-20070409-081846.jpg','oct-5-20070409-081849.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `vacproperties`(`PropertyID`,`Name`,`AddressNumber`,`Street`,`City`,`State`,`Country`,`Type`,`Area`,`Location`,`FromPrice`,`ListingDescription`,`Description`,`bedrooms`,`bathrooms`,`Kitchen`,`AirConditioning`,`Dishwasher`,`Microwave`,`WasherDryer`,`ScreenedPorch`,`BedLinensProvided`,`Fireplace`,`PoolTable`,`HighSpeedInternet`,`CableTV`,`DVDVCR`,`PrivatePool`,`HeatedPool`,`HotTub`,`Grill`,`EnclosedOutsideShower`,`GameRoom`,`Elevator`,`PetsAllowed`,`NonSmoking`,`CommunityFacilities`,`CommunityPool`,`CommunityTennisCourts`,`CommunityClubHouse`,`Golf`,`HandicapFriendly`,`ListingPhoto`,`Photo1`,`Photo2`,`Photo3`,`Photo4`,`Photo5`,`Photo6`,`Photo7`,`Photo8`,`Photo9`,`Photo10`,`Photo11`,`Photo12`,`Photo13`,`Photo14`,`Photo15`) VALUES(11,'Twisted Fish',9531,'S. Old Oregon Inlet Rd. MP: 19.5','South Nags Head','NC','USA','House','South Nags Head','Oceanfront',1995,'You are invited to enjoy this Paradise in the Sand! This home offers you everything Imaginable for a Fabulous Vacation Retreat! It is Large enough to accommodate a Magical Family Reunion, yet Spacious enough to allow Family & Friends the chance for Privacy & a Peaceful Vacation Get-A-Way. ','<P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>You are invited to enjoy this Paradise in the Sand! This home offers you everything Imaginable for a Fabulous Vacation Retreat! It is Large enough to accommodate a Magical Family Reunion, yet Spacious enough to allow Family &amp; Friends the chance for Privacy &amp; a Peaceful Vacation Get-A-Way. </FONT></P><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>The Twisted Fish is only a few steps away from the Magnificent Atlantic Ocean and the views are Spectacular!. This home is located directly in front of a Life Guarded Beach. The Dune Top Deck features a storage locker loaded w/Buckets, Shovels, &amp; other must haves for Fun in the Sun and Sand. You will also find a Shower/Foot Wash Station on this Deck Area. </FONT></P><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>The Ramped Walkway leads you to the <B>18 x 30 Private Pool</B> (Can Be Heated for $400.00 Per Week), there is a Video Monitor which covers the entire Pool Area, &amp; also 2 Outside Showers along w/Outdoor Speakers &amp; a Gas Grill on the lower Deck Area.</FONT></P><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Inside the Home on the 1st Floor is a Well Equipped Kitchenette w/Wet Bar, Bar Seating, Dishwasher, Microwave, &amp; Full Size Refrigerator w/Ice Maker, a <B>Game Room w/Pool Table</B>, Large Screen CATV w/Surround Sound, Game Table, Washer/Dryer Unit, Powder Room, Master Suite w/King, TV/VCR and Full Bath, 1 w/2 Bunk Sets, TV/VCR &amp; 1 w/Duo Bunk w/Trundle and a shared Full Bath. From the Game Room you will access to Pool Patio aera.</FONT></P><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>The 2nd Floor offers 2 Oceanfront Master Suites w/Kings, TVs and Full Baths (1 is Handicapped Accessible), 1 w/Queen and TV/VCR, 1 w/2 Singles and TV, 1 w/Duo Bunk w/Trundle, Full Hallway Bath, Washer/Dryer, Linen Closet and 2 Covered Decks. A Hot Tub is located on the Oceanfront Deck where you can relax and enjoy the Ocean Views.</FONT></P><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>A Magnificent Great Room on the 3rd floor greets you endless Ocean Views, Sun Deck w/Picnic Table and furniture, Gas Fireplace, DVD, VHS, Game Library Cabinet, Reading Library, Computer w/Wireless High Speed Internet Access, Fax Machine, Big Screen CATV, Surround Sound, Wet Bar w/Icemaker, Dining Area w/Tile Floors, Extraordinary Kitchen w/2 Dishwashers, 2 Sink areas, 2 Range Ovens, Refrigerator, Large Pantry Closet, Bar Area w/Seating for 6, a Master Suite w/King w/Completely Tiled 2 Person Shower, 1 w/Queen, &amp; Full Bath.</FONT></P><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>South Nags Head is a Perfect Location for Your Next Outer Banks Vacation. It offers the Peace &amp; Quite of a Residential Neighborhood, but the Convenience of Close Proximity to Restaurants, Shopping, Miniature Golf, Jet Ski Rentals, Charter Fishing, Manteo Attractions, 18 Hole Golf, &amp; So Very Much More.</FONT></P><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\"><FONT size=1><U>Features Include:</U> <B>Elevator</B>, C/AC &amp; Heat, 3 Ice Makers, Chest Freezer, 8 Phones, Nintendo Game Cube w/Games, 11 CATV\'s, 8 Ceiling Fans, Bean Bag/Video Rockers, Baby Equipment (High Chair, Baby Gates, Port-A-Crib, &amp; Umbrella Stroller), Sun Decks, Covered Decks, Extensive Deck &amp; Pool Furniture, Gas Grill, Park Grill, Basketball Goal, &amp; Picnic Tables. No Pets. This is a Non-Smoking Unit! </FONT></FONT></P><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1></FONT><P><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Bed Linens &amp; Towels Provided (Beds Not Made) w/Full Week Rental</FONT></P><H3><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Rates - Saturday Check-in.</FONT></H3><CENTER><TABLE class=ratestable style=\"WIDTH: 516px; HEIGHT: 509px\" cellPadding=4 border=1><TBODY><TR><TH class=rateheads><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Start Date</FONT></TH><TH class=rateheads><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>End Date</FONT></TH><TH class=rateheads><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>Rate</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>12/30/2006</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>05/04/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 1,995.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>05/05/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>05/18/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 2,295.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>05/19/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/01/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 3,995.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/02/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/08/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 4,995.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/09/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/15/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 6,995.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/16/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/29/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 9,695.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>06/30/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/10/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 10,195.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/11/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/17/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 8,495.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/18/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/24/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 6,995.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/25/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>08/31/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 5,495.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>09/01/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>09/14/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 3,795.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>09/15/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>10/12/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 2,795.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>10/13/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>11/16/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 1,995.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>11/17/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>11/23/2007</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 3,295.00/wk.</FONT></TH></TR><TR><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>11/24/2007</FONT></TD><TD class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>01/04/2008</FONT></TD><TH class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\" size=1>$ 1,995.00/wk.</FONT></TH></TR></TBODY></TABLE><CENTER><SPAN class=rates><FONT face=\"Verdana, Arial, Helvetica, sans-serif\"><FONT size=1><B>Security Deposit:</B> $500</FONT></FONT></SPAN></CENTER></CENTER>',10,7,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,-1,0,0,0,0,0,0,'tf-1-20070419-211958.jpg','tf-1-20070419-211958.jpg','tf-2-20070419-212001.jpg','tf-3-20070419-212003.jpg','tf-4-20070419-212008.jpg','tf-5-20070419-212011.jpg','tf-6-20070419-212050.jpg','tf-7-20070419-212055.jpg','tf-8-20070419-212059.jpg','tf-9-20070419-212110.jpg','tf-10-20070419-212114.jpg','tf-11-20070419-212117.jpg','tf-12-20070419-212121.jpg','tf-13-20070419-212125.jpg','tf-14-20070419-212129.jpg',NULL);
INSERT INTO `vacpropertytype`(`propertytypeID`,`propertytype`) VALUES(1,'Condominium');
INSERT INTO `vacpropertytype`(`propertytypeID`,`propertytype`) VALUES(2,'House');
INSERT INTO `vacpropertytype`(`propertytypeID`,`propertytype`) VALUES(3,'Room');
INSERT INTO `vacpropertytype`(`propertytypeID`,`propertytype`) VALUES(4,'Townhome');
INSERT INTO `vacpropertytype`(`propertytypeID`,`propertytype`) VALUES(5,'Twinhome');
INSERT INTO `vacpropertytype`(`propertytypeID`,`propertytype`) VALUES(6,'Hotel Room');
INSERT INTO `vacpropertytype`(`propertytypeID`,`propertytype`) VALUES(7,'Studio');
INSERT INTO `vacreservations`(`ReservationID`,`PropertyID`,`FromDate`,`ToDate`,`RentersName`,`RentersAddress`,`RentersPhoneNumber`,`status`) VALUES(1,2,'2007-6-9','2007-6-16','John Adams','1234 Woodland Dr, Maple Grove, MN 55311','763-123-4565',3);
INSERT INTO `vacreservations`(`ReservationID`,`PropertyID`,`FromDate`,`ToDate`,`RentersName`,`RentersAddress`,`RentersPhoneNumber`,`status`) VALUES(2,2,'2007-4-14','2007-4-21','Sam Kesler','45981 Village Rd, Herndon, VA','777-111-1515',2);
INSERT INTO `vacreservations`(`ReservationID`,`PropertyID`,`FromDate`,`ToDate`,`RentersName`,`RentersAddress`,`RentersPhoneNumber`,`status`) VALUES(3,3,'2007-7-1','2007-7-8','Emy Mollins','154 Smith Ave, Bloomington, WA',NULL,1);
INSERT INTO `vacreservations`(`ReservationID`,`PropertyID`,`FromDate`,`ToDate`,`RentersName`,`RentersAddress`,`RentersPhoneNumber`,`status`) VALUES(4,4,'2007-8-18','2007-8-25','Jenny Hockins','987 15th street n, Wwooddale, PA ',NULL,2);
INSERT INTO `vacreservations`(`ReservationID`,`PropertyID`,`FromDate`,`ToDate`,`RentersName`,`RentersAddress`,`RentersPhoneNumber`,`status`) VALUES(5,11,'2007-5-12','2007-5-19','Michael Olson','9615 West Knollwood dr, Duluth, ND',NULL,3);
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(1,'ALABAMA','AL');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(2,'ALASKA','AK');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(3,'ARIZONA ','AZ');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(4,'ARKANSAS','AR');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(5,'CALIFORNIA ','CA');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(6,'COLORADO ','CO');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(7,'CONNECTICUT','CT');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(8,'DELAWARE','DE');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(9,'DISTRICT OF COLUMBIA','DC');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(10,'FLORIDA','FL');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(11,'GEORGIA','GA');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(12,'HAWAII','HI');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(13,'IDAHO','ID');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(14,'ILLINOIS','IL');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(15,'INDIANA','IN');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(16,'IOWA','IA');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(17,'KANSAS','KS');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(18,'KENTUCKY','KY');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(19,'LOUISIANA','LA');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(20,'MAINE','ME');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(21,'MARYLAND','MD');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(22,'MASSACHUSETTS','MA');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(23,'MICHIGAN','MI');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(24,'MINNESOTA','MN');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(25,'MISSISSIPPI','MS');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(26,'MISSOURI','MO');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(27,'MONTANA','MT');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(28,'NEBRASKA','NE');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(29,'NEVADA','NV');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(30,'NEW HAMPSHIRE','NH');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(31,'NEW JERSEY','NJ');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(32,'NEW MEXICO','NM');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(33,'NEW YORK','NY');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(34,'NORTH CAROLINA','NC');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(35,'NORTH DAKOTA','ND');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(36,'OHIO','OH');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(37,'OKLAHOMA','OK');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(38,'OREGON','OR');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(39,'PENNSYLVANIA','PA');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(40,'RHODE ISLAND','RI');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(41,'SOUTH CAROLINA','SC');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(42,'SOUTH DAKOTA','SD');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(43,'TENNESSEE','TN');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(44,'TEXAS','TX');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(45,'UTAH','UT');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(46,'VERMONT','VT');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(47,'VIRGINIA ','VA');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(48,'WASHINGTON','WA');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(49,'WEST VIRGINIA','WV');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(50,'WISCONSIN','WI');
INSERT INTO `vacstates`(`StateID`,`State`,`StateAbbreviation`) VALUES(51,'WYOMING','WY');
INSERT INTO `vacstatus`(`ID`,`status`) VALUES(1,'No payment received');
INSERT INTO `vacstatus`(`ID`,`status`) VALUES(2,'Deposit received');
INSERT INTO `vacstatus`(`ID`,`status`) VALUES(3,'Paid in full');
INSERT INTO `vacstatus`(`ID`,`status`) VALUES(4,'Deposit returned');