CREATE TABLE `Iopx` ( `ID` INT NOT NULL AUTO_INCREMENT , `Stnumber` TINYTEXT NOT NULL , `Stname` TINYTEXT NOT NULL , `Suite` TINYTEXT NOT NULL , `City` TINYTEXT NOT NULL , `State` TINYTEXT NOT NULL , `Zip` TINYTEXT NOT NULL , `Salesagent` TINYTEXT NOT NULL , `Salesmgr` TINYTEXT NOT NULL , `Regmgr` TINYTEXT NOT NULL , `Unit` TINYTEXT NOT NULL , `Order` TINYTEXT NOT NULL , `Notes` TINYTEXT NOT NULL , `Maplink` TINYTEXT NOT NULL , `Lat` TINYTEXT NOT NULL , `Long` TINYTEXT NOT NULL , `Date` DATE NOT NULL , `Status` TINYTEXT NOT NULL , `Contact` TINYTEXT NOT NULL , `Email` TINYTEXT NOT NULL , `Phone` TINYTEXT NOT NULL , `Fax` TINYTEXT NOT NULL , `Website` TINYTEXT NOT NULL , `Bookinglink` TINYTEXT NOT NULL , `Agency` TINYTEXT NOT NULL , `Folder` TINYTEXT NOT NULL , `Bg` TINYTEXT NOT NULL , `Floor1` TINYTEXT NOT NULL , `Floorplan1` TINYTEXT NOT NULL , `Floor2` TINYTEXT NOT NULL , `Floorplan2` TINYTEXT NOT NULL , `Floor3` TINYTEXT NOT NULL , `Floorplan3` TINYTEXT NOT NULL , `Video` TINYTEXT NOT NULL , `Living` TINYTEXT NOT NULL , `Livingsp` TINYTEXT NOT NULL , `Livingvt` TINYTEXT NOT NULL , `Living2` TINYTEXT NOT NULL , `Living2sp` TINYTEXT NOT NULL , `Living2vt` TINYTEXT NOT NULL , `Dining` TINYTEXT NOT NULL , `Diningsp` TINYTEXT NOT NULL , `Diningvt` TINYTEXT NOT NULL , `Dining2` TINYTEXT NOT NULL , `Dining2sp` TINYTEXT NOT NULL , `Dining2vt` TINYTEXT NOT NULL , `Family` TINYTEXT NOT NULL , `Familysp` TINYTEXT NOT NULL , `Familyvt` TINYTEXT NOT NULL , `Great` TINYTEXT NOT NULL , `Greatsp` TINYTEXT NOT NULL , `Greatvt` TINYTEXT NOT NULL , `Den` TINYTEXT NOT NULL , `Densp` TINYTEXT NOT NULL , `Denvt` TINYTEXT NOT NULL , `Sun` TINYTEXT NOT NULL , `Sunsp` TINYTEXT NOT NULL , `Sunvt` TINYTEXT NOT NULL , `Study` TINYTEXT NOT NULL , `Studysp` TINYTEXT NOT NULL , `Studyvt` TINYTEXT NOT NULL , `Media` TINYTEXT NOT NULL , `Mediasp` TINYTEXT NOT NULL , `Mediavt` TINYTEXT NOT NULL , `Game` TINYTEXT NOT NULL , `Gamesp` TINYTEXT NOT NULL , `Gamevt` TINYTEXT NOT NULL , `Kitchen` TINYTEXT NOT NULL , `Kitchensp` TINYTEXT NOT NULL , `Kitchenvt` TINYTEXT NOT NULL , `Kitchen2` TINYTEXT NOT NULL , `Kitchen2sp` TINYTEXT NOT NULL , `Kitchen2vt` TINYTEXT NOT NULL , `Br1` TINYTEXT NOT NULL , `Br1sp` TINYTEXT NOT NULL , `Br1vt` TINYTEXT NOT NULL , `Br2` TINYTEXT NOT NULL , `Br2sp` TINYTEXT NOT NULL , `Br2vt` TINYTEXT NOT NULL , `Br3` TINYTEXT NOT NULL , `Br3sp` TINYTEXT NOT NULL , `Br3vt` TINYTEXT NOT NULL , `Br4` TINYTEXT NOT NULL , `Br4sp` TINYTEXT NOT NULL , `Br4vt` TINYTEXT NOT NULL , `Br5` TINYTEXT NOT NULL , `Br5sp` TINYTEXT NOT NULL , `Br5vt` TINYTEXT NOT NULL , `Br6` TINYTEXT NOT NULL , `Br6sp` TINYTEXT NOT NULL , `Br6vt` TINYTEXT NOT NULL , `Br7` TINYTEXT NOT NULL , `Br7sp` TINYTEXT NOT NULL , `Br7vt` TINYTEXT NOT NULL , `Br8` TINYTEXT NOT NULL , `Br8sp` TINYTEXT NOT NULL , `Br8vt` TINYTEXT NOT NULL , `Br9` TINYTEXT NOT NULL , `Br9sp` TINYTEXT NOT NULL , `Br9vt` TINYTEXT NOT NULL , `Br10` TINYTEXT NOT NULL , `Br10sp` TINYTEXT NOT NULL , `Br10vt` TINYTEXT NOT NULL , `Br11` TINYTEXT NOT NULL , `Br11sp` TINYTEXT NOT NULL , `Br11vt` TINYTEXT NOT NULL , `Br12` TINYTEXT NOT NULL , `Br12sp` TINYTEXT NOT NULL , `Br12vt` TINYTEXT NOT NULL , `Ba1` TINYTEXT NOT NULL , `Ba1sp` TINYTEXT NOT NULL , `Ba1vt` TINYTEXT NOT NULL , `Ba2` TINYTEXT NOT NULL , `Ba2sp` TINYTEXT NOT NULL , `Ba2vt` TINYTEXT NOT NULL , `Ba3` TINYTEXT NOT NULL , `Ba3sp` TINYTEXT NOT NULL , `Ba3vt` TINYTEXT NOT NULL , `Ba4` TINYTEXT NOT NULL , `Ba4sp` TINYTEXT NOT NULL , `Ba4vt` TINYTEXT NOT NULL , `V1` TINYTEXT NOT NULL , `V1sp` TINYTEXT NOT NULL , `V1vt` TINYTEXT NOT NULL , `V2` TINYTEXT NOT NULL , `V2sp` TINYTEXT NOT NULL , `V2vt` TINYTEXT NOT NULL , `V3` TINYTEXT NOT NULL , `V3sp` TINYTEXT NOT NULL , `V3vt` TINYTEXT NOT NULL , `V4` TINYTEXT NOT NULL , `V4sp` TINYTEXT NOT NULL , `V4vt` TINYTEXT NOT NULL , `V5` TINYTEXT NOT NULL , `V5sp` TINYTEXT NOT NULL , `V5vt` TINYTEXT NOT NULL , `V6` TINYTEXT NOT NULL , `V6sp` TINYTEXT NOT NULL , `V6vt` TINYTEXT NOT NULL , `V7` TINYTEXT NOT NULL , `V7sp` TINYTEXT NOT NULL , `V7vt` TINYTEXT NOT NULL , `V8` TINYTEXT NOT NULL , `V8sp` TINYTEXT NOT NULL , `V8vt` TINYTEXT NOT NULL , `V9` TINYTEXT NOT NULL , `V9sp` TINYTEXT NOT NULL , `V9vt` TINYTEXT NOT NULL , `V10` TINYTEXT NOT NULL , `V10sp` TINYTEXT NOT NULL , `V10vt` TINYTEXT NOT NULL , `V11` TINYTEXT NOT NULL , `V11sp` TINYTEXT NOT NULL , `V11vt` TINYTEXT NOT NULL , `V12` TINYTEXT NOT NULL , `V12sp` TINYTEXT NOT NULL , `V12vt` TINYTEXT NOT NULL , `V13` TINYTEXT NOT NULL , `V13sp` TINYTEXT NOT NULL , `V13vt` TINYTEXT NOT NULL , `V14` TINYTEXT NOT NULL , `V14sp` TINYTEXT NOT NULL , `V14vt` TINYTEXT NOT NULL , `V15` TINYTEXT NOT NULL , `V15sp` TINYTEXT NOT NULL , `V15vt` TINYTEXT NOT NULL , `V16` TINYTEXT NOT NULL , `V16sp` TINYTEXT NOT NULL , `V16vt` TINYTEXT NOT NULL , `Cmt01` TINYTEXT NOT NULL , `Cmt02` TINYTEXT NOT NULL , `Cmt03` TINYTEXT NOT NULL , `Cmt04` TINYTEXT NOT NULL , `Cmt05` TINYTEXT NOT NULL , `Cmt06` TINYTEXT NOT NULL , `Cmt07` TINYTEXT NOT NULL , `Cmt08` TINYTEXT NOT NULL , `Cmt09` TINYTEXT NOT NULL , `Cmt10` TINYTEXT NOT NULL , `Cmt11` TINYTEXT NOT NULL , `Cmt12` TINYTEXT NOT NULL , `Cmt13` TINYTEXT NOT NULL , `Cmt14` TINYTEXT NOT NULL , `Cmt15` TINYTEXT NOT NULL , PRIMARY KEY (`ID`) ); INSERT INTO `Iopx` (`Stnumber`, `Stname`, `Suite`, `City`, `State`, `Zip`, `Salesagent`, `Salesmgr`, `Regmgr`, `Unit`, `Order`, `Notes`, `Maplink`, `Lat`, `Long`, `Date`, `Status`, `Contact`, `Email`, `Phone`, `Fax`, `Website`, `Bookinglink`, `Agency`, `Folder`, `Bg`, `Floor1`, `Floorplan1`, `Floor2`, `Floorplan2`, `Floor3`, `Floorplan3`, `Video`, `Living`, `Livingsp`, `Livingvt`, `Living2`, `Living2sp`, `Living2vt`, `Dining`, `Diningsp`, `Diningvt`, `Dining2`, `Dining2sp`, `Dining2vt`, `Family`, `Familysp`, `Familyvt`, `Great`, `Greatsp`, `Greatvt`, `Den`, `Densp`, `Denvt`, `Sun`, `Sunsp`, `Sunvt`, `Study`, `Studysp`, `Studyvt`, `Media`, `Mediasp`, `Mediavt`, `Game`, `Gamesp`, `Gamevt`, `Kitchen`, `Kitchensp`, `Kitchenvt`, `Kitchen2`, `Kitchen2sp`, `Kitchen2vt`, `Br1`, `Br1sp`, `Br1vt`, `Br2`, `Br2sp`, `Br2vt`, `Br3`, `Br3sp`, `Br3vt`, `Br4`, `Br4sp`, `Br4vt`, `Br5`, `Br5sp`, `Br5vt`, `Br6`, `Br6sp`, `Br6vt`, `Br7`, `Br7sp`, `Br7vt`, `Br8`, `Br8sp`, `Br8vt`, `Br9`, `Br9sp`, `Br9vt`, `Br10`, `Br10sp`, `Br10vt`, `Br11`, `Br11sp`, `Br11vt`, `Br12`, `Br12sp`, `Br12vt`, `Ba1`, `Ba1sp`, `Ba1vt`, `Ba2`, `Ba2sp`, `Ba2vt`, `Ba3`, `Ba3sp`, `Ba3vt`, `Ba4`, `Ba4sp`, `Ba4vt`, `V1`, `V1sp`, `V1vt`, `V2`, `V2sp`, `V2vt`, `V3`, `V3sp`, `V3vt`, `V4`, `V4sp`, `V4vt`, `V5`, `V5sp`, `V5vt`, `V6`, `V6sp`, `V6vt`, `V7`, `V7sp`, `V7vt`, `V8`, `V8sp`, `V8vt`, `V9`, `V9sp`, `V9vt`, `V10`, `V10sp`, `V10vt`, `V11`, `V11sp`, `V11vt`, `V12`, `V12sp`, `V12vt`, `V13`, `V13sp`, `V13vt`, `V14`, `V14sp`, `V14vt`, `V15`, `V15sp`, `V15vt`, `V16`, `V16sp`, `V16vt`, `Cmt01`, `Cmt02`, `Cmt03`, `Cmt04`, `Cmt05`, `Cmt06`, `Cmt07`, `Cmt08`, `Cmt09`, `Cmt10`, `Cmt11`, `Cmt12`, `Cmt13`, `Cmt14`, `Cmt15`) VALUES ('917', 'Ocean Blvd', '', 'Isle of Palms', 'SC', '29451', '', '', '', 'OceanBlvd_917', '', '', 'http://maps.google.com/maps?f=q&hl=en&geocode=&q=917+Ocean+Blvd+Isle+Of+Palms+29451&sll=32.784483,-79.791421&sspn=0.003464,0.003937&ie=UTF8&ll=32.784686,-79.791062&spn=0.006927,0.007875&t=h&z=17&om=1', '32.784686', '-79.791062', '1901-12-07 00:00:00', 'A', 'Shelly Miles', 'iopexclusive@aol.com', '843.886.ISLE', '', 'http://www.charlestonscvacationrentals.com', 'http://www.charlestonscvacationrentals.com/', 'IOP Exclusive Rentals', 'iopx', '96cbf7', 'Floor 1', 'OceanBlvd_917_1', 'Floor 2', 'OceanBlvd_917_2', '', '', '', 'Living', '4441_0707', '9537_0707', '', '', '', 'Dining', '4438_0707', '9538_0707', 'Dining', '4439_0707', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Kitchen', '4440_0707', '9536_0707', '', '', '', 'Bedroom 1', '4420_0707', '9529_0707', 'Bedroom 2', '4408_0707', '9522_0707', 'Bedroom 3', '4418_0707', '9528_0707', 'Bedroom 4', '4409_0707', '9524_0707', 'Bedroom 5', '4415_0707', '9527_0707', 'Bedroom 6', '4412_0707', '9525_0707', 'Bedroom 7', '4444_0707', '9540_0707', 'Bedroom 8', '4442_0707', '9539_0707', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Front', '4403_0707', '', 'Front', '4404_0707', '', 'Front Porch 1st', '4405_0707', '9521a_0707', 'Front Porch 1st', '4406_0707', '', 'Front Porch 2nd', '4429_0707', '9534_0707', 'View', '4431_0707', '', 'View', '4432_0707', '', 'Back', '4428_0707', '9532_0707', 'Back Porch', '4421_0707', '9531_0707', 'View', '4424_0707', '', 'View', '4425_0707', '', 'Back Porch 2nd', '4433_0707', '', 'Back Porch 2nd', '4435_0707', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `Iopx` (`Stnumber`, `Stname`, `Suite`, `City`, `State`, `Zip`, `Salesagent`, `Salesmgr`, `Regmgr`, `Unit`, `Order`, `Notes`, `Maplink`, `Lat`, `Long`, `Date`, `Status`, `Contact`, `Email`, `Phone`, `Fax`, `Website`, `Bookinglink`, `Agency`, `Folder`, `Bg`, `Floor1`, `Floorplan1`, `Floor2`, `Floorplan2`, `Floor3`, `Floorplan3`, `Video`, `Living`, `Livingsp`, `Livingvt`, `Living2`, `Living2sp`, `Living2vt`, `Dining`, `Diningsp`, `Diningvt`, `Dining2`, `Dining2sp`, `Dining2vt`, `Family`, `Familysp`, `Familyvt`, `Great`, `Greatsp`, `Greatvt`, `Den`, `Densp`, `Denvt`, `Sun`, `Sunsp`, `Sunvt`, `Study`, `Studysp`, `Studyvt`, `Media`, `Mediasp`, `Mediavt`, `Game`, `Gamesp`, `Gamevt`, `Kitchen`, `Kitchensp`, `Kitchenvt`, `Kitchen2`, `Kitchen2sp`, `Kitchen2vt`, `Br1`, `Br1sp`, `Br1vt`, `Br2`, `Br2sp`, `Br2vt`, `Br3`, `Br3sp`, `Br3vt`, `Br4`, `Br4sp`, `Br4vt`, `Br5`, `Br5sp`, `Br5vt`, `Br6`, `Br6sp`, `Br6vt`, `Br7`, `Br7sp`, `Br7vt`, `Br8`, `Br8sp`, `Br8vt`, `Br9`, `Br9sp`, `Br9vt`, `Br10`, `Br10sp`, `Br10vt`, `Br11`, `Br11sp`, `Br11vt`, `Br12`, `Br12sp`, `Br12vt`, `Ba1`, `Ba1sp`, `Ba1vt`, `Ba2`, `Ba2sp`, `Ba2vt`, `Ba3`, `Ba3sp`, `Ba3vt`, `Ba4`, `Ba4sp`, `Ba4vt`, `V1`, `V1sp`, `V1vt`, `V2`, `V2sp`, `V2vt`, `V3`, `V3sp`, `V3vt`, `V4`, `V4sp`, `V4vt`, `V5`, `V5sp`, `V5vt`, `V6`, `V6sp`, `V6vt`, `V7`, `V7sp`, `V7vt`, `V8`, `V8sp`, `V8vt`, `V9`, `V9sp`, `V9vt`, `V10`, `V10sp`, `V10vt`, `V11`, `V11sp`, `V11vt`, `V12`, `V12sp`, `V12vt`, `V13`, `V13sp`, `V13vt`, `V14`, `V14sp`, `V14vt`, `V15`, `V15sp`, `V15vt`, `V16`, `V16sp`, `V16vt`, `Cmt01`, `Cmt02`, `Cmt03`, `Cmt04`, `Cmt05`, `Cmt06`, `Cmt07`, `Cmt08`, `Cmt09`, `Cmt10`, `Cmt11`, `Cmt12`, `Cmt13`, `Cmt14`, `Cmt15`) VALUES ('3400', 'Palm Blvd', '', 'Isle of Palms', 'SC', '29451', '', '', '', 'PalmBlvd_3400', '', '', 'http://maps.google.com/maps?f=q&hl=en&geocode=&q=3400+Palm+Blvd+Isle+Of+Palms+29451&sll=32.784686,-79.79103&sspn=0.006927,0.007929&ie=UTF8&ll=32.795148,-79.766557&spn=0.003463,0.003964&t=h&z=18&om=1', '32.7949', '-79.7664', '1901-12-07 00:00:00', 'A', 'Shelly Miles', 'iopexclusive@aol.com', '843.886.ISLE', '', 'http://www.charlestonscvacationrentals.com', 'http://www.charlestonscvacationrentals.com/', 'IOP Exclusive Rentals', 'iopx', '96cbf7', 'Floor 1', 'PalmBlvd_3400_1', 'Floor 2', 'PalmBlvd_3400_2', '', '', '', 'Living', '4491_0707', '9552_0707', 'Living', '4484_0707', '', 'Dining', '4488_0707', '9553_0707', 'Dining', '4485_0707', '9554_0707', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Media', '4524_0707', '9566_0707', '', '', '', 'Kitchen', '4493_0707', '9555_0707', 'Kitchen', '4494_0707', '', 'Bedroom 1', '4481_0707', '9550_0707', 'Bedroom 2', '4496_0707', '9556_0707', 'Bedroom 3', '4477_0707', '9549_0707', 'Bedroom 4', '4499_0707', '9557_0707', 'Bedroom 5', '4474_0707', '9548_0707', 'Bedroom 6', '4501_0707', '9558_0707', 'Bedroom 7', '4506_0707', '9560_0707', 'Bedroom 8', '4507_0707', '9561_0707', 'Bedroom 9', '4509_0707', '9562_0707', 'Bedroom 10', '4503_0707', '9559_0707', 'Bedroom 11', '4511_0707', '9563_0707', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Front', '4445_0707', '', 'Front Porch', '4447_0707', '9543a_0707', 'Back', '4465_0707', '', 'Back', '4460_0707', '', 'Back Porch', '4472_0707', '9544a_0707', 'Back Porch', '4469_0707', '9546a_0707', 'Porch 2nd', '4514_0707', '9564_0707', 'Pool', '4449_0707', '', 'Pool', '4450_0707', '', 'View', '4457_0707', '', 'View', '4461_0707', '', 'View', '4512_0707', '', 'View', '4513_0707', '9567_0707', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `Iopx` (`Stnumber`, `Stname`, `Suite`, `City`, `State`, `Zip`, `Salesagent`, `Salesmgr`, `Regmgr`, `Unit`, `Order`, `Notes`, `Maplink`, `Lat`, `Long`, `Date`, `Status`, `Contact`, `Email`, `Phone`, `Fax`, `Website`, `Bookinglink`, `Agency`, `Folder`, `Bg`, `Floor1`, `Floorplan1`, `Floor2`, `Floorplan2`, `Floor3`, `Floorplan3`, `Video`, `Living`, `Livingsp`, `Livingvt`, `Living2`, `Living2sp`, `Living2vt`, `Dining`, `Diningsp`, `Diningvt`, `Dining2`, `Dining2sp`, `Dining2vt`, `Family`, `Familysp`, `Familyvt`, `Great`, `Greatsp`, `Greatvt`, `Den`, `Densp`, `Denvt`, `Sun`, `Sunsp`, `Sunvt`, `Study`, `Studysp`, `Studyvt`, `Media`, `Mediasp`, `Mediavt`, `Game`, `Gamesp`, `Gamevt`, `Kitchen`, `Kitchensp`, `Kitchenvt`, `Kitchen2`, `Kitchen2sp`, `Kitchen2vt`, `Br1`, `Br1sp`, `Br1vt`, `Br2`, `Br2sp`, `Br2vt`, `Br3`, `Br3sp`, `Br3vt`, `Br4`, `Br4sp`, `Br4vt`, `Br5`, `Br5sp`, `Br5vt`, `Br6`, `Br6sp`, `Br6vt`, `Br7`, `Br7sp`, `Br7vt`, `Br8`, `Br8sp`, `Br8vt`, `Br9`, `Br9sp`, `Br9vt`, `Br10`, `Br10sp`, `Br10vt`, `Br11`, `Br11sp`, `Br11vt`, `Br12`, `Br12sp`, `Br12vt`, `Ba1`, `Ba1sp`, `Ba1vt`, `Ba2`, `Ba2sp`, `Ba2vt`, `Ba3`, `Ba3sp`, `Ba3vt`, `Ba4`, `Ba4sp`, `Ba4vt`, `V1`, `V1sp`, `V1vt`, `V2`, `V2sp`, `V2vt`, `V3`, `V3sp`, `V3vt`, `V4`, `V4sp`, `V4vt`, `V5`, `V5sp`, `V5vt`, `V6`, `V6sp`, `V6vt`, `V7`, `V7sp`, `V7vt`, `V8`, `V8sp`, `V8vt`, `V9`, `V9sp`, `V9vt`, `V10`, `V10sp`, `V10vt`, `V11`, `V11sp`, `V11vt`, `V12`, `V12sp`, `V12vt`, `V13`, `V13sp`, `V13vt`, `V14`, `V14sp`, `V14vt`, `V15`, `V15sp`, `V15vt`, `V16`, `V16sp`, `V16vt`, `Cmt01`, `Cmt02`, `Cmt03`, `Cmt04`, `Cmt05`, `Cmt06`, `Cmt07`, `Cmt08`, `Cmt09`, `Cmt10`, `Cmt11`, `Cmt12`, `Cmt13`, `Cmt14`, `Cmt15`) VALUES ('2405', 'Palm Blvd', '', 'Isle of Palms', 'SC', '29451', '', '', '', 'PalmBlvd_2405', '', '', 'http://maps.google.com/maps?f=q&hl=en&geocode=&q=2405+Palm+Blvd+Isle+of+Palms+SC+29451&sll=32.23139,-80.881348&sspn=3.568298,4.059448&ie=UTF8&ll=32.790815,-79.779384&spn=0.003463,0.003964&t=h&z=18&om=1', '32.7908', '-79.779', '1901-12-07 00:00:00', 'A', 'Shelly Miles', 'iopexclusive@aol.com', '843.886.ISLE', '', 'http://www.charlestonscvacationrentals.com', 'http://www.charlestonscvacationrentals.com/', 'IOP Exclusive Rentals', 'iopx', '96cbf7', 'Floor 1', 'PalmBlvd_2405_1', 'Floor 2', 'PalmBlvd_2405_2', '', '', '', 'Living', '6617_0801', '6604_0801', 'Living', '6612_0801', '', 'Dining', '6615_0801', '6605_0801', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Media', '6623_0801', '6624_0801', '', '', '', 'Kitchen', '6618_0801', '6603_0801', 'Kitchen', '6619_0801', '', 'Bedroom 1', '6621_0801', '6625_0801', 'Bedroom 2', '4547_0707', '4566_0707', 'Bedroom 3', '6620_0801', '6626_0801', 'Bedroom 4', '4546_0707', '4570_0707', 'Bedroom 5', '6595_0801', '6600_0801', 'Bedroom 5 Sitting', '6597_0801', '6601_0801', 'Bedroom 6', '6599_0801', '6602_0801', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Bath4a', '4537_0707', '4562_0707', 'Bath4b', '4538_0707', '4563_0707', '', '', '', '', '', '', 'Front', '4574_0707', '', 'Front', '4575_0707', '', '', '', '', 'Porch 2nd', '6608_0801', '6606a_0801', '', '', '', 'View', '4542_0707', '', 'View', '6609_0801', '', 'View', '4544_0707', '', 'Pool', '4552_0707', '4569_0707', 'Pool', '4553_0707', '', 'Pool', '4554_0707', '', 'Side Yard', '6628_0801', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO `Iopx` (`Stnumber`, `Stname`, `Suite`, `City`, `State`, `Zip`, `Salesagent`, `Salesmgr`, `Regmgr`, `Unit`, `Order`, `Notes`, `Maplink`, `Lat`, `Long`, `Date`, `Status`, `Contact`, `Email`, `Phone`, `Fax`, `Website`, `Bookinglink`, `Agency`, `Folder`, `Bg`, `Floor1`, `Floorplan1`, `Floor2`, `Floorplan2`, `Floor3`, `Floorplan3`, `Video`, `Living`, `Livingsp`, `Livingvt`, `Living2`, `Living2sp`, `Living2vt`, `Dining`, `Diningsp`, `Diningvt`, `Dining2`, `Dining2sp`, `Dining2vt`, `Family`, `Familysp`, `Familyvt`, `Great`, `Greatsp`, `Greatvt`, `Den`, `Densp`, `Denvt`, `Sun`, `Sunsp`, `Sunvt`, `Study`, `Studysp`, `Studyvt`, `Media`, `Mediasp`, `Mediavt`, `Game`, `Gamesp`, `Gamevt`, `Kitchen`, `Kitchensp`, `Kitchenvt`, `Kitchen2`, `Kitchen2sp`, `Kitchen2vt`, `Br1`, `Br1sp`, `Br1vt`, `Br2`, `Br2sp`, `Br2vt`, `Br3`, `Br3sp`, `Br3vt`, `Br4`, `Br4sp`, `Br4vt`, `Br5`, `Br5sp`, `Br5vt`, `Br6`, `Br6sp`, `Br6vt`, `Br7`, `Br7sp`, `Br7vt`, `Br8`, `Br8sp`, `Br8vt`, `Br9`, `Br9sp`, `Br9vt`, `Br10`, `Br10sp`, `Br10vt`, `Br11`, `Br11sp`, `Br11vt`, `Br12`, `Br12sp`, `Br12vt`, `Ba1`, `Ba1sp`, `Ba1vt`, `Ba2`, `Ba2sp`, `Ba2vt`, `Ba3`, `Ba3sp`, `Ba3vt`, `Ba4`, `Ba4sp`, `Ba4vt`, `V1`, `V1sp`, `V1vt`, `V2`, `V2sp`, `V2vt`, `V3`, `V3sp`, `V3vt`, `V4`, `V4sp`, `V4vt`, `V5`, `V5sp`, `V5vt`, `V6`, `V6sp`, `V6vt`, `V7`, `V7sp`, `V7vt`, `V8`, `V8sp`, `V8vt`, `V9`, `V9sp`, `V9vt`, `V10`, `V10sp`, `V10vt`, `V11`, `V11sp`, `V11vt`, `V12`, `V12sp`, `V12vt`, `V13`, `V13sp`, `V13vt`, `V14`, `V14sp`, `V14vt`, `V15`, `V15sp`, `V15vt`, `V16`, `V16sp`, `V16vt`, `Cmt01`, `Cmt02`, `Cmt03`, `Cmt04`, `Cmt05`, `Cmt06`, `Cmt07`, `Cmt08`, `Cmt09`, `Cmt10`, `Cmt11`, `Cmt12`, `Cmt13`, `Cmt14`, `Cmt15`) VALUES ('411', 'Ocean Blvd', '', 'Isle of Palms', 'SC', '29451', '', '', '', 'OceanBlvd_411', '', '', 'http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=411+Ocean+Blvd,+Isle+of+palms+SC+29451&sll=37.509726,-95.712891&sspn=48.582311,65.566406&ie=UTF8&ll=32.779314,-79.801603&spn=0.001594,0.002001&t=h&z=19', '32.7793', '-79.8016', '1902-06-23 00:00:00', 'A', 'Shelly Miles', 'iopexclusive@aol.com', '843.886.ISLE', '', 'http://www.charlestonscvacationrentals.com', 'http://www.charlestonscvacationrentals.com/', 'IOP Exclusive Rentals', 'iopx', '96cbf7', 'Floor 1', 'OceanBlvd_411_1', 'Floor 2', 'OceanBlvd_411_2', 'Floor 3', 'OceanBlvd_411_3', '', 'Living', '2853_0905', '2847_0905', 'Living', '2852_0905', '', 'Dining', '2854_0905', '2848_0905', '', '', '', '', '', '', '', '', '', 'Den', '2826_0905', '2836_0905', '', '', '', '', '', '', '', '', '', '', '', '', 'Kitchen', '2859_0905', '2861_0905', 'Kitchen', '2860_0905', '', 'Bedroom 1', '2851_0905', '2846_0905', 'Bedroom 2', '2830_0905', '2839_0905', 'Bedroom 3', '2832_0905', '2840_0905', 'Bedroom 4', '2827_0905', '2837_0905', 'Bedroom 5', '2828_0905', '2838_0905', 'Bedroom 6', '2825_0905', '2835_0905', 'Bedroom 7', '2855_0905', '2849_0905', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Bath 1', '2858_0905', '2844_0905', '1/2 Ba', '2856_0905', '', '', '', '', '', '', '', 'Front', '2885_0905', '', 'Front', '2883_0905', '', 'Porch & Pool', '2875_0905', '2880a_0905', 'Porch & Pool', '2878_0905', '2882_0905', 'Porch & Pool', '2876_0905', '', 'Porch & Pool', '2877_0905', '', 'View', '2879_0905', '', 'Back Porch 1st', '2833_0905', '2843a_0905', 'Porch 2nd', '2871_0905', '2863a_0905', 'View', '2873_0905', '', 'View', '2872_0905', '', 'Back Porch 2nd', '2874_0905', '2864_0905', 'Widow\'s Walk', '2866_0905', '2865_0905', 'View', '2869_0905', '', 'View', '2870_0905', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');