INSERT INTO `locations` (`dis_id`, `re_id`, `location_name`) VALUES (7, 17, 224, 'Missoula Montana'),
(17, 85, 'san diego'),
(17, 224, 'Loveland Colorado'),

INSERT INTO `activities` (`PropertyID`, `shopping`, `closetonightlife`, `golf`, `horsebackriding`, `scuba`, `restaurants`, `nearbycasino`, `closetogrocerystore`, `jetskiing`, `tennis`, `whitewaterrafting`, `deepseafishing`, `hiking`, `biking`, `boating`, `skiing`, `closetoairport`) VALUES (96, 10471229, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(XXXXXXXX , 'on', 'on', 'on', '', '', '', '', '', '', '', '', '', '', '', '', 'on', '');

INSERT INTO `advancedpropertydetails` (`PropertyID`, `longdescription`, `oceanfront`, `beachfront`, `nearbeach`, `mountainview`, `waterview`, `gardenview`, `privatepool`, `communitypool`, `indoordining`, `outdoordining`, `patio`, `deck`, `gatedcommunity`, `terrace`, `balcony`, `walkwaytowater`, `whirlpool`, `hottub`, `jacuzzi`, `kingbeds`, `numberofkingbeds`, `queenbeds`, `numberofqueenbeds`, `bunkbeds`, `numberofbunkbeds`, `wheelchairaccessible`, `nonsmokingonly`, `allowpets`) VALUES (64, 10471229, 'more information upon request', 'on', 'on', 'on', 'on', 'on', 'on', 'on', '', '', '', '', '', '', '', '', '', '', '', '', 'on', '3', 'on', '5', 'on', '32', 'on', 'on', 'on'),
XXXXXXXX , 'Beautiful home near Denver and the ski slopes.', '', '', '', 'on', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'on', '2', 'on', '3', '', '', '', '', '');

INSERT INTO `amenities` (`PropertyID`, `tv`, `stereo`, `cd`, `dvd`, `loungechairs`, `beachtowels`, `bbq`, `gasgrill`, `blender`, `microwave`, `refrigerator`, `freezer`, `dishwasher`, `clotheswasher`, `clothesdryer`, `coffeemaker`, `toaster`, `ironingboard`, `fitnessroom`, `hairdryer`, `airconditioning`, `safe`, `satellitecable`, `ceilingfans`, `cookinguntensils`, `stove`, `securedparking`, `childshighchair`, `childsstroller`, `gameroom`, `alarmclock`, `filteredwater`, `basicsoaps`, `toiletpaper`, `linensprovided`, `babycrib`) VALUES (97, 10471229, 'on', 'on', 'on', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(XXXXXXXX , 'on', 'on', 'on', 'on', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'on', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'on');


INSERT INTO `attractions` (`PropertyID`, `waterparks`, `amusementpark`, `museums`, `horsebacktours`, `boatingtours`) VALUES (97, 10471229, '', '', '', '', ''),
(XXXXXXXX , '', '', 'on', '', '');


INSERT INTO `communication` (`PropertyID`, `telephone`, `wifiaccess`, `broadbandaccess`, `internetcafe`, `copierfax`) VALUES (97, 10471229, 'on', 'on', 'on', 'on', 'on'),
(XXXXXXXX , 'on', 'on', '', '', '');



INSERT INTO `minpropertyinfo` (`propertytitle`, `PropertyID`, `ListingID`, `propertytype`, `numberbeds`, `numberbaths`, `minprice`, `maxprice`, `description`, `dis_id`, `re_id`, `loc_id`) VALUES (88, 'California Beach home', 10471229, 1, 'Condo', '5', '4', '199', '2000', 'this is the best', 17, 224, 9),
('Loveland Colorado', XXXXXXXX, QQQQQQQQ, 'Home', '5', '2', '250', '500', 'Great Colorado home near the slopes.', 17, 224, 13);

INSERT INTO `propertypictures` (`counter`, `PropertyID`, `piclocation`) VALUES (35, 10471229, 'picuploads/110471229/example1.jpg'),
(XXXXXXXX , 'GGGGGGGG/example2.thumb.jpg'),
(XXXXXXXX , 'GGGGGGGG/example3.jpg'),


INSERT INTO `propertyrates` (`propertyid`, `begindate`, `enddate`, `rate`, `currency`) VALUES (1, '10295328', '01/01/2010', '12/31/2010', '25000', 'USD'),
('XXXXXXXX ', '01/05/2010', '01/10/2010', '100', 'USD'),