DROP TABLE IF EXISTS `retblbathrooms`;
CREATE TABLE `retblbathrooms`(`Bathrooms` VARCHAR(50) ,`BathroomsID` INT AUTO_INCREMENT,PRIMARY KEY (`BathroomsID`));
DROP TABLE IF EXISTS `retblbedrooms`;
CREATE TABLE `retblbedrooms`(`Bedrooms` VARCHAR(50) ,`BedroomsID` INT AUTO_INCREMENT,PRIMARY KEY (`BedroomsID`));
DROP TABLE IF EXISTS `retblcooling`;
CREATE TABLE `retblcooling`(`Cooling` VARCHAR(50) ,`CoolingID` INT AUTO_INCREMENT,PRIMARY KEY (`CoolingID`));
DROP TABLE IF EXISTS `retblgarage`;
CREATE TABLE `retblgarage`(`Garage` VARCHAR(50) ,`GarageID` INT AUTO_INCREMENT,PRIMARY KEY (`GarageID`));
DROP TABLE IF EXISTS `retblheating`;
CREATE TABLE `retblheating`(`Heating` VARCHAR(50) ,`HeatingID` INT AUTO_INCREMENT,PRIMARY KEY (`HeatingID`));
DROP TABLE IF EXISTS `reusers`;
CREATE TABLE `reusers`(`Password` VARCHAR(50) ,`UserId` INT AUTO_INCREMENT,`Username` VARCHAR(50) ,`UserType` VARCHAR(50) ,PRIMARY KEY (`UserId`));
DROP TABLE IF EXISTS `retblresults`;
CREATE TABLE `retblresults`(`s1/2Baths` INT ,`s3/4Baths` INT ,`Acres` INT ,`Amusement_Room` TINYINT(2) ,`Amusement_Room_Dimension1` INT ,`Amusement_Room_Dimension2` INT ,`Apartment/Unit` VARCHAR(50) ,`Basement` TINYINT(2) ,`Bathrooms` INT ,`Bedrooms` INT ,`City` VARCHAR(50) ,`Cooktop` TINYINT(2) ,`Cooling` INT ,`Country` VARCHAR(50) ,`Daylight/Lookout_Windows` TINYINT(2) ,`Den` TINYINT(2) ,`Den_Dimension1` INT ,`Den_Dimension2` INT ,`Dinning_Room` TINYINT(2) ,`Dinning_Room_Dimension1` INT ,`Dinning_Room_Dimension2` INT ,`Dishwasher` TINYINT(2) ,`Disposal` TINYINT(2) ,`Drain_Tiled` TINYINT(2) ,`Dryer` TINYINT(2) ,`Eat_In_Kitchen` TINYINT(2) ,`Exhaust_Fan/Hood` TINYINT(2) ,`Family_Room` TINYINT(2) ,`Family_Room_Dimension1` INT ,`Family_Room_Dimension2` INT ,`Finished_Basement` TINYINT(2) ,`Fireplaces` INT ,`Foundation` INT ,`Foyer` TINYINT(2) ,`Foyer_Dimension1` INT ,`Foyer_Dimension2` INT ,`FullBaths` INT ,`Garage` INT ,`Gas_Burning_Fireplace` TINYINT(2) ,`Heating` INT ,`House_Number` INT ,`Kitchen` TINYINT(2) ,`Kitchen/Dining_Room` TINYINT(2) ,`Kitchen_Dimension1` INT ,`Kitchen_Dimension2` INT ,`Living_Room` TINYINT(2) ,`Living_Room_Dimension1` INT ,`Living_Room_Dimension2` INT ,`Loft` TINYINT(2) ,`Loft_Dimension1` INT ,`Loft_Dimension2` INT ,`Lot` TINYINT(2) ,`Lot_Dimension1` INT ,`Lot_Dimension2` INT ,`Lot_Dimension3` INT ,`Lot_Dimension4` INT ,`Lot_Dimension5` INT ,`Lot_Dimension6` INT ,`Lot_Dimension7` INT ,`Lot_Dimension8` INT ,`Microwave` TINYINT(2) ,`MLS_Number` INT ,`Office` TINYINT(2) ,`Office_Dimension1` INT ,`Office_Dimension2` INT ,`Photo1` VARCHAR(50) ,`Photo10` 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) ,`PhotoListing` VARCHAR(50) ,`Price` DECIMAL ,`PropertyID` INT AUTO_INCREMENT,`Range` TINYINT(2) ,`Rec_Room` TINYINT(2) ,`Rec_Room_Dimension1` INT ,`Rec_Room_Dimension2` INT ,`Refrigerator` TINYINT(2) ,`Remarks` LONGTEXT ,`Separate/Formal_Dining_Room` TINYINT(2) ,`Sq_Ft` INT ,`State` VARCHAR(50) ,`Street_Name` VARCHAR(50) ,`Study_Room` TINYINT(2) ,`Study_Room_Dimension1` INT ,`Study_Room_Dimension2` INT ,`Style` INT ,`Sum_Pump` TINYINT(2) ,`Sun_Room` TINYINT(2) ,`Sun_Room_Dimension1` INT ,`Sun_Room_Dimension2` INT ,`Tax_Amount` DECIMAL ,`Tax_Year` INT ,`sType` INT ,`Walkout` TINYINT(2) ,`Wall_Oven` TINYINT(2) ,`Water_Softener` TINYINT(2) ,`Wood_Burning_Fireplace` TINYINT(2) ,`Year` INT ,`Zip` VARCHAR(50) ,PRIMARY KEY (`PropertyID`));
DROP TABLE IF EXISTS `retblstyle`;
CREATE TABLE `retblstyle`(`Style` VARCHAR(50) ,`StyleID` INT AUTO_INCREMENT,PRIMARY KEY (`StyleID`));
DROP TABLE IF EXISTS `retbltype`;
CREATE TABLE `retbltype`(`sType` VARCHAR(50) ,`TypeID` INT AUTO_INCREMENT,PRIMARY KEY (`TypeID`));
INSERT INTO `retblbathrooms`(`BathroomsID`,`Bathrooms`) VALUES(1,'1');
INSERT INTO `retblbathrooms`(`BathroomsID`,`Bathrooms`) VALUES(2,'2');
INSERT INTO `retblbathrooms`(`BathroomsID`,`Bathrooms`) VALUES(3,'3');
INSERT INTO `retblbathrooms`(`BathroomsID`,`Bathrooms`) VALUES(4,'4');
INSERT INTO `retblbathrooms`(`BathroomsID`,`Bathrooms`) VALUES(5,'5');
INSERT INTO `retblbathrooms`(`BathroomsID`,`Bathrooms`) VALUES(6,'6');
INSERT INTO `retblbedrooms`(`BedroomsID`,`Bedrooms`) VALUES(1,'1');
INSERT INTO `retblbedrooms`(`BedroomsID`,`Bedrooms`) VALUES(2,'2');
INSERT INTO `retblbedrooms`(`BedroomsID`,`Bedrooms`) VALUES(3,'3');
INSERT INTO `retblbedrooms`(`BedroomsID`,`Bedrooms`) VALUES(4,'4');
INSERT INTO `retblbedrooms`(`BedroomsID`,`Bedrooms`) VALUES(5,'5');
INSERT INTO `retblbedrooms`(`BedroomsID`,`Bedrooms`) VALUES(6,'6');
INSERT INTO `retblbedrooms`(`BedroomsID`,`Bedrooms`) VALUES(7,'7');
INSERT INTO `retblbedrooms`(`BedroomsID`,`Bedrooms`) VALUES(8,'8');
INSERT INTO `retblbedrooms`(`BedroomsID`,`Bedrooms`) VALUES(9,'9');
INSERT INTO `retblbedrooms`(`BedroomsID`,`Bedrooms`) VALUES(10,'10');
INSERT INTO `retblcooling`(`CoolingID`,`Cooling`) VALUES(1,'Central');
INSERT INTO `retblcooling`(`CoolingID`,`Cooling`) VALUES(2,'Window AC');
INSERT INTO `retblgarage`(`GarageID`,`Garage`) VALUES(1,'0');
INSERT INTO `retblgarage`(`GarageID`,`Garage`) VALUES(2,'1');
INSERT INTO `retblgarage`(`GarageID`,`Garage`) VALUES(3,'2');
INSERT INTO `retblgarage`(`GarageID`,`Garage`) VALUES(4,'3');
INSERT INTO `retblgarage`(`GarageID`,`Garage`) VALUES(5,'4');
INSERT INTO `retblheating`(`HeatingID`,`Heating`) VALUES(1,'Forced Air');
INSERT INTO `retblheating`(`HeatingID`,`Heating`) VALUES(2,'Hot Water');
INSERT INTO `reusers`(`UserType`,`Username`,`Password`,`UserId`) VALUES('admin','admin','admin',1);
INSERT INTO `reusers`(`UserType`,`Username`,`Password`,`UserId`) VALUES('user','user','user',2);
INSERT INTO `retblresults`(`PropertyID`,`MLS_Number`,`House_Number`,`Street_Name`,`Apartment/Unit`,`City`,`State`,`Zip`,`Country`,`Price`,`sType`,`Style`,`Bedrooms`,`Bathrooms`,`Year`,`Foundation`,`Sq_Ft`,`Garage`,`Acres`,`Kitchen`,`Kitchen_Dimension1`,`Kitchen_Dimension2`,`Living_Room`,`Living_Room_Dimension1`,`Living_Room_Dimension2`,`Family_Room`,`Family_Room_Dimension1`,`Family_Room_Dimension2`,`Rec_Room`,`Rec_Room_Dimension1`,`Rec_Room_Dimension2`,`Study_Room`,`Study_Room_Dimension1`,`Study_Room_Dimension2`,`Sun_Room`,`Sun_Room_Dimension1`,`Sun_Room_Dimension2`,`Loft`,`Loft_Dimension1`,`Loft_Dimension2`,`Dinning_Room`,`Dinning_Room_Dimension1`,`Dinning_Room_Dimension2`,`Amusement_Room`,`Amusement_Room_Dimension1`,`Amusement_Room_Dimension2`,`Foyer`,`Foyer_Dimension1`,`Foyer_Dimension2`,`Office`,`Office_Dimension1`,`Office_Dimension2`,`Den`,`Den_Dimension1`,`Den_Dimension2`,`FullBaths`,`s3/4Baths`,`s1/2Baths`,`Fireplaces`,`Wood_Burning_Fireplace`,`Gas_Burning_Fireplace`,`Range`,`Cooktop`,`Dishwasher`,`Disposal`,`Dryer`,`Exhaust_Fan/Hood`,`Microwave`,`Refrigerator`,`Wall_Oven`,`Water_Softener`,`Eat_In_Kitchen`,`Kitchen/Dining_Room`,`Separate/Formal_Dining_Room`,`Basement`,`Finished_Basement`,`Drain_Tiled`,`Sum_Pump`,`Walkout`,`Daylight/Lookout_Windows`,`Cooling`,`Heating`,`Lot`,`Lot_Dimension1`,`Lot_Dimension2`,`Lot_Dimension3`,`Lot_Dimension4`,`Lot_Dimension5`,`Lot_Dimension6`,`Lot_Dimension7`,`Lot_Dimension8`,`Tax_Amount`,`Tax_Year`,`Remarks`,`PhotoListing`,`Photo1`,`Photo2`,`Photo3`,`Photo4`,`Photo5`,`Photo6`,`Photo7`,`Photo8`,`Photo9`,`Photo10`) VALUES(1,10135441,5125,'Green View Lane N','303','Plymouth','MN','55446','USA',151000.000000,1,12,3,1,1985,NULL,965,2,NULL,-1,9,12,-1,22,18,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,-1,10,12,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,1,0,0,2,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,2,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1050.000000,2006,'Third Floor Gem in Trenton Place! SW Corner Unit w/ 2 screened/carpeted balconies. Sunny interior all day long! Priv master full bath - spacious bedrooms-each w/2 closets! Outdoor Pool, tennis, sauna, hot tub, walking trails - so much to come home to!','condo1-20070108-232154.jpg','condo1-20070108-232154.jpg','condo2-20070108-232130.jpg','condo3-20070108-232133.jpg','condo4-20070108-232137.jpg','condo5-20070108-232139.jpg','condo6-20070108-232142.jpg','condo7-20070108-232146.jpg','condo8-20070108-232149.jpg','condo9-20070108-232151.jpg','');
INSERT INTO `retblresults`(`PropertyID`,`MLS_Number`,`House_Number`,`Street_Name`,`Apartment/Unit`,`City`,`State`,`Zip`,`Country`,`Price`,`sType`,`Style`,`Bedrooms`,`Bathrooms`,`Year`,`Foundation`,`Sq_Ft`,`Garage`,`Acres`,`Kitchen`,`Kitchen_Dimension1`,`Kitchen_Dimension2`,`Living_Room`,`Living_Room_Dimension1`,`Living_Room_Dimension2`,`Family_Room`,`Family_Room_Dimension1`,`Family_Room_Dimension2`,`Rec_Room`,`Rec_Room_Dimension1`,`Rec_Room_Dimension2`,`Study_Room`,`Study_Room_Dimension1`,`Study_Room_Dimension2`,`Sun_Room`,`Sun_Room_Dimension1`,`Sun_Room_Dimension2`,`Loft`,`Loft_Dimension1`,`Loft_Dimension2`,`Dinning_Room`,`Dinning_Room_Dimension1`,`Dinning_Room_Dimension2`,`Amusement_Room`,`Amusement_Room_Dimension1`,`Amusement_Room_Dimension2`,`Foyer`,`Foyer_Dimension1`,`Foyer_Dimension2`,`Office`,`Office_Dimension1`,`Office_Dimension2`,`Den`,`Den_Dimension1`,`Den_Dimension2`,`FullBaths`,`s3/4Baths`,`s1/2Baths`,`Fireplaces`,`Wood_Burning_Fireplace`,`Gas_Burning_Fireplace`,`Range`,`Cooktop`,`Dishwasher`,`Disposal`,`Dryer`,`Exhaust_Fan/Hood`,`Microwave`,`Refrigerator`,`Wall_Oven`,`Water_Softener`,`Eat_In_Kitchen`,`Kitchen/Dining_Room`,`Separate/Formal_Dining_Room`,`Basement`,`Finished_Basement`,`Drain_Tiled`,`Sum_Pump`,`Walkout`,`Daylight/Lookout_Windows`,`Cooling`,`Heating`,`Lot`,`Lot_Dimension1`,`Lot_Dimension2`,`Lot_Dimension3`,`Lot_Dimension4`,`Lot_Dimension5`,`Lot_Dimension6`,`Lot_Dimension7`,`Lot_Dimension8`,`Tax_Amount`,`Tax_Year`,`Remarks`,`PhotoListing`,`Photo1`,`Photo2`,`Photo3`,`Photo4`,`Photo5`,`Photo6`,`Photo7`,`Photo8`,`Photo9`,`Photo10`) VALUES(2,16574798,87925,'Orchard Park Dr',NULL,'Eden Prairie','MN','55347','USA',375900.000000,1,3,3,3,2004,1950,2750,3,0,-1,14,17,-1,14,15,-1,18,15,0,NULL,NULL,0,NULL,NULL,-1,10,10,0,NULL,NULL,0,NULL,NULL,-1,23,18,0,NULL,NULL,-1,12,14,0,NULL,NULL,2,1,NULL,1,0,-1,-1,0,-1,-1,-1,-1,-1,-1,0,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,1,1,-1,105,135,98,135,NULL,NULL,NULL,NULL,3500.000000,2006,'Stately 2 story on spacious lot in great area close to award winning schools! Immaculate! Something for everyone - Large kitchen, main floor family room with built-ins & fireplace, formal LR & DR,huge Laundry/hobby rm,3 season porch,4 BRs up & finished LL.','img_1865b-20070109-001133.jpg','img_1865b-20070109-001133.jpg','','','','','','','','','');
INSERT INTO `retblresults`(`PropertyID`,`MLS_Number`,`House_Number`,`Street_Name`,`Apartment/Unit`,`City`,`State`,`Zip`,`Country`,`Price`,`sType`,`Style`,`Bedrooms`,`Bathrooms`,`Year`,`Foundation`,`Sq_Ft`,`Garage`,`Acres`,`Kitchen`,`Kitchen_Dimension1`,`Kitchen_Dimension2`,`Living_Room`,`Living_Room_Dimension1`,`Living_Room_Dimension2`,`Family_Room`,`Family_Room_Dimension1`,`Family_Room_Dimension2`,`Rec_Room`,`Rec_Room_Dimension1`,`Rec_Room_Dimension2`,`Study_Room`,`Study_Room_Dimension1`,`Study_Room_Dimension2`,`Sun_Room`,`Sun_Room_Dimension1`,`Sun_Room_Dimension2`,`Loft`,`Loft_Dimension1`,`Loft_Dimension2`,`Dinning_Room`,`Dinning_Room_Dimension1`,`Dinning_Room_Dimension2`,`Amusement_Room`,`Amusement_Room_Dimension1`,`Amusement_Room_Dimension2`,`Foyer`,`Foyer_Dimension1`,`Foyer_Dimension2`,`Office`,`Office_Dimension1`,`Office_Dimension2`,`Den`,`Den_Dimension1`,`Den_Dimension2`,`FullBaths`,`s3/4Baths`,`s1/2Baths`,`Fireplaces`,`Wood_Burning_Fireplace`,`Gas_Burning_Fireplace`,`Range`,`Cooktop`,`Dishwasher`,`Disposal`,`Dryer`,`Exhaust_Fan/Hood`,`Microwave`,`Refrigerator`,`Wall_Oven`,`Water_Softener`,`Eat_In_Kitchen`,`Kitchen/Dining_Room`,`Separate/Formal_Dining_Room`,`Basement`,`Finished_Basement`,`Drain_Tiled`,`Sum_Pump`,`Walkout`,`Daylight/Lookout_Windows`,`Cooling`,`Heating`,`Lot`,`Lot_Dimension1`,`Lot_Dimension2`,`Lot_Dimension3`,`Lot_Dimension4`,`Lot_Dimension5`,`Lot_Dimension6`,`Lot_Dimension7`,`Lot_Dimension8`,`Tax_Amount`,`Tax_Year`,`Remarks`,`PhotoListing`,`Photo1`,`Photo2`,`Photo3`,`Photo4`,`Photo5`,`Photo6`,`Photo7`,`Photo8`,`Photo9`,`Photo10`) VALUES(3,15684651,7816,'Eden Str',NULL,'Bloomington','MN','55448','USA',329000.000000,1,10,3,4,2006,1015,2490,3,NULL,-1,9,9,-1,24,14,-1,16,14,0,NULL,NULL,0,NULL,NULL,-1,9,9,-1,10,10,-1,10,8,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,3,0,NULL,1,0,-1,-1,0,-1,-1,-1,0,-1,-1,0,-1,-1,-1,0,-1,-1,-1,-1,-1,0,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3600.000000,2006,'New Construction Townhome. Price reduced by $10,000. Spectacular views!','misc 012-20070109-003253.jpg','misc 012-20070109-003253.jpg','misc 015-20070109-002626.jpg','misc 020-20070109-002651.jpg','misc 032-20070109-002655.jpg','misc 039-20070109-002701.jpg','misc 041-20070109-002709.jpg','misc 044-20070109-002712.jpg','home13-20070109-002717.jpg','home 003-20070109-002720.jpg',NULL);
INSERT INTO `retblresults`(`PropertyID`,`MLS_Number`,`House_Number`,`Street_Name`,`Apartment/Unit`,`City`,`State`,`Zip`,`Country`,`Price`,`sType`,`Style`,`Bedrooms`,`Bathrooms`,`Year`,`Foundation`,`Sq_Ft`,`Garage`,`Acres`,`Kitchen`,`Kitchen_Dimension1`,`Kitchen_Dimension2`,`Living_Room`,`Living_Room_Dimension1`,`Living_Room_Dimension2`,`Family_Room`,`Family_Room_Dimension1`,`Family_Room_Dimension2`,`Rec_Room`,`Rec_Room_Dimension1`,`Rec_Room_Dimension2`,`Study_Room`,`Study_Room_Dimension1`,`Study_Room_Dimension2`,`Sun_Room`,`Sun_Room_Dimension1`,`Sun_Room_Dimension2`,`Loft`,`Loft_Dimension1`,`Loft_Dimension2`,`Dinning_Room`,`Dinning_Room_Dimension1`,`Dinning_Room_Dimension2`,`Amusement_Room`,`Amusement_Room_Dimension1`,`Amusement_Room_Dimension2`,`Foyer`,`Foyer_Dimension1`,`Foyer_Dimension2`,`Office`,`Office_Dimension1`,`Office_Dimension2`,`Den`,`Den_Dimension1`,`Den_Dimension2`,`FullBaths`,`s3/4Baths`,`s1/2Baths`,`Fireplaces`,`Wood_Burning_Fireplace`,`Gas_Burning_Fireplace`,`Range`,`Cooktop`,`Dishwasher`,`Disposal`,`Dryer`,`Exhaust_Fan/Hood`,`Microwave`,`Refrigerator`,`Wall_Oven`,`Water_Softener`,`Eat_In_Kitchen`,`Kitchen/Dining_Room`,`Separate/Formal_Dining_Room`,`Basement`,`Finished_Basement`,`Drain_Tiled`,`Sum_Pump`,`Walkout`,`Daylight/Lookout_Windows`,`Cooling`,`Heating`,`Lot`,`Lot_Dimension1`,`Lot_Dimension2`,`Lot_Dimension3`,`Lot_Dimension4`,`Lot_Dimension5`,`Lot_Dimension6`,`Lot_Dimension7`,`Lot_Dimension8`,`Tax_Amount`,`Tax_Year`,`Remarks`,`PhotoListing`,`Photo1`,`Photo2`,`Photo3`,`Photo4`,`Photo5`,`Photo6`,`Photo7`,`Photo8`,`Photo9`,`Photo10`) VALUES(4,16984514,26987,'West Broadway',NULL,'Bloomington','MN','55448','USA',1449500.000000,1,3,5,4,1999,3350,7450,5,2,-1,18,14,-1,26,15,-1,22,20,-1,25,16,0,NULL,NULL,-1,15,14,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,-1,6,6,-1,10,10,0,NULL,NULL,2,1,NULL,1,0,-1,-1,0,-1,-1,-1,0,-1,-1,-1,0,-1,-1,-1,-1,-1,-1,-1,-1,0,1,1,-1,400,365,390,350,NULL,NULL,NULL,NULL,10200.000000,2006,'This 5BR/4BA home features a gorg. kit, 1st floor FR w/fplc., vault. ceilings on the main level & an open & spacious flr plan. LL is finished & features 2BR & FR rm. 02 home painted,new gar doors,new carpet LL FR.03 new furnace/AC,2 water htrs,water soft','141661-20070117-234055.jpg','141661-20070117-234055.jpg','140428-20070117-233908.jpg',NULL,'142449-20070117-233921.jpg','142452-20070117-233931.jpg',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `retblresults`(`PropertyID`,`MLS_Number`,`House_Number`,`Street_Name`,`Apartment/Unit`,`City`,`State`,`Zip`,`Country`,`Price`,`sType`,`Style`,`Bedrooms`,`Bathrooms`,`Year`,`Foundation`,`Sq_Ft`,`Garage`,`Acres`,`Kitchen`,`Kitchen_Dimension1`,`Kitchen_Dimension2`,`Living_Room`,`Living_Room_Dimension1`,`Living_Room_Dimension2`,`Family_Room`,`Family_Room_Dimension1`,`Family_Room_Dimension2`,`Rec_Room`,`Rec_Room_Dimension1`,`Rec_Room_Dimension2`,`Study_Room`,`Study_Room_Dimension1`,`Study_Room_Dimension2`,`Sun_Room`,`Sun_Room_Dimension1`,`Sun_Room_Dimension2`,`Loft`,`Loft_Dimension1`,`Loft_Dimension2`,`Dinning_Room`,`Dinning_Room_Dimension1`,`Dinning_Room_Dimension2`,`Amusement_Room`,`Amusement_Room_Dimension1`,`Amusement_Room_Dimension2`,`Foyer`,`Foyer_Dimension1`,`Foyer_Dimension2`,`Office`,`Office_Dimension1`,`Office_Dimension2`,`Den`,`Den_Dimension1`,`Den_Dimension2`,`FullBaths`,`s3/4Baths`,`s1/2Baths`,`Fireplaces`,`Wood_Burning_Fireplace`,`Gas_Burning_Fireplace`,`Range`,`Cooktop`,`Dishwasher`,`Disposal`,`Dryer`,`Exhaust_Fan/Hood`,`Microwave`,`Refrigerator`,`Wall_Oven`,`Water_Softener`,`Eat_In_Kitchen`,`Kitchen/Dining_Room`,`Separate/Formal_Dining_Room`,`Basement`,`Finished_Basement`,`Drain_Tiled`,`Sum_Pump`,`Walkout`,`Daylight/Lookout_Windows`,`Cooling`,`Heating`,`Lot`,`Lot_Dimension1`,`Lot_Dimension2`,`Lot_Dimension3`,`Lot_Dimension4`,`Lot_Dimension5`,`Lot_Dimension6`,`Lot_Dimension7`,`Lot_Dimension8`,`Tax_Amount`,`Tax_Year`,`Remarks`,`PhotoListing`,`Photo1`,`Photo2`,`Photo3`,`Photo4`,`Photo5`,`Photo6`,`Photo7`,`Photo8`,`Photo9`,`Photo10`) VALUES(5,17547405,1874,'81st street',NULL,'Plymouth','MN','55446','USA',180000.000000,1,2,2,2,1978,960,1750,2,0,-1,12,10,-1,15,13,-1,16,12,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,1,NULL,NULL,1,-1,0,-1,0,-1,-1,-1,0,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,1,1,-1,80,90,80,90,NULL,NULL,NULL,NULL,2100.000000,2006,'Cozy house in quiet neighborhood. Large deck, south side, big trees.','p5230071-20070117-233438.jpg','p5230071-20070117-233438.jpg','P5230082-20070117-233423.jpg','p1010147-20070117-233427.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `retblresults`(`PropertyID`,`MLS_Number`,`House_Number`,`Street_Name`,`Apartment/Unit`,`City`,`State`,`Zip`,`Country`,`Price`,`sType`,`Style`,`Bedrooms`,`Bathrooms`,`Year`,`Foundation`,`Sq_Ft`,`Garage`,`Acres`,`Kitchen`,`Kitchen_Dimension1`,`Kitchen_Dimension2`,`Living_Room`,`Living_Room_Dimension1`,`Living_Room_Dimension2`,`Family_Room`,`Family_Room_Dimension1`,`Family_Room_Dimension2`,`Rec_Room`,`Rec_Room_Dimension1`,`Rec_Room_Dimension2`,`Study_Room`,`Study_Room_Dimension1`,`Study_Room_Dimension2`,`Sun_Room`,`Sun_Room_Dimension1`,`Sun_Room_Dimension2`,`Loft`,`Loft_Dimension1`,`Loft_Dimension2`,`Dinning_Room`,`Dinning_Room_Dimension1`,`Dinning_Room_Dimension2`,`Amusement_Room`,`Amusement_Room_Dimension1`,`Amusement_Room_Dimension2`,`Foyer`,`Foyer_Dimension1`,`Foyer_Dimension2`,`Office`,`Office_Dimension1`,`Office_Dimension2`,`Den`,`Den_Dimension1`,`Den_Dimension2`,`FullBaths`,`s3/4Baths`,`s1/2Baths`,`Fireplaces`,`Wood_Burning_Fireplace`,`Gas_Burning_Fireplace`,`Range`,`Cooktop`,`Dishwasher`,`Disposal`,`Dryer`,`Exhaust_Fan/Hood`,`Microwave`,`Refrigerator`,`Wall_Oven`,`Water_Softener`,`Eat_In_Kitchen`,`Kitchen/Dining_Room`,`Separate/Formal_Dining_Room`,`Basement`,`Finished_Basement`,`Drain_Tiled`,`Sum_Pump`,`Walkout`,`Daylight/Lookout_Windows`,`Cooling`,`Heating`,`Lot`,`Lot_Dimension1`,`Lot_Dimension2`,`Lot_Dimension3`,`Lot_Dimension4`,`Lot_Dimension5`,`Lot_Dimension6`,`Lot_Dimension7`,`Lot_Dimension8`,`Tax_Amount`,`Tax_Year`,`Remarks`,`PhotoListing`,`Photo1`,`Photo2`,`Photo3`,`Photo4`,`Photo5`,`Photo6`,`Photo7`,`Photo8`,`Photo9`,`Photo10`) VALUES(6,15354165,1547,'Sunshine Drive',NULL,'Cross Lakes','MN','55227','USA',369000.000000,1,3,4,3,1998,1350,3450,3,0,-1,15,15,-1,18,20,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,-1,13,11,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,-1,7,8,0,13,10,0,NULL,NULL,2,1,NULL,1,-1,0,-1,0,-1,-1,-1,0,-1,-1,-1,0,-1,-1,0,-1,-1,-1,-1,-1,0,1,1,-1,100,80,100,80,NULL,NULL,NULL,NULL,3200.000000,2006,'4bdr, 3 bath beautiful home in northern Minnesota setting. Perfect for weekend getaways and family vacations.','ioghouseexterior-20070118-000129.jpg','ioghouseexterior-20070118-000129.jpg','ioghousekitchen-20070118-000007.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `retblresults`(`PropertyID`,`MLS_Number`,`House_Number`,`Street_Name`,`Apartment/Unit`,`City`,`State`,`Zip`,`Country`,`Price`,`sType`,`Style`,`Bedrooms`,`Bathrooms`,`Year`,`Foundation`,`Sq_Ft`,`Garage`,`Acres`,`Kitchen`,`Kitchen_Dimension1`,`Kitchen_Dimension2`,`Living_Room`,`Living_Room_Dimension1`,`Living_Room_Dimension2`,`Family_Room`,`Family_Room_Dimension1`,`Family_Room_Dimension2`,`Rec_Room`,`Rec_Room_Dimension1`,`Rec_Room_Dimension2`,`Study_Room`,`Study_Room_Dimension1`,`Study_Room_Dimension2`,`Sun_Room`,`Sun_Room_Dimension1`,`Sun_Room_Dimension2`,`Loft`,`Loft_Dimension1`,`Loft_Dimension2`,`Dinning_Room`,`Dinning_Room_Dimension1`,`Dinning_Room_Dimension2`,`Amusement_Room`,`Amusement_Room_Dimension1`,`Amusement_Room_Dimension2`,`Foyer`,`Foyer_Dimension1`,`Foyer_Dimension2`,`Office`,`Office_Dimension1`,`Office_Dimension2`,`Den`,`Den_Dimension1`,`Den_Dimension2`,`FullBaths`,`s3/4Baths`,`s1/2Baths`,`Fireplaces`,`Wood_Burning_Fireplace`,`Gas_Burning_Fireplace`,`Range`,`Cooktop`,`Dishwasher`,`Disposal`,`Dryer`,`Exhaust_Fan/Hood`,`Microwave`,`Refrigerator`,`Wall_Oven`,`Water_Softener`,`Eat_In_Kitchen`,`Kitchen/Dining_Room`,`Separate/Formal_Dining_Room`,`Basement`,`Finished_Basement`,`Drain_Tiled`,`Sum_Pump`,`Walkout`,`Daylight/Lookout_Windows`,`Cooling`,`Heating`,`Lot`,`Lot_Dimension1`,`Lot_Dimension2`,`Lot_Dimension3`,`Lot_Dimension4`,`Lot_Dimension5`,`Lot_Dimension6`,`Lot_Dimension7`,`Lot_Dimension8`,`Tax_Amount`,`Tax_Year`,`Remarks`,`PhotoListing`,`Photo1`,`Photo2`,`Photo3`,`Photo4`,`Photo5`,`Photo6`,`Photo7`,`Photo8`,`Photo9`,`Photo10`) VALUES(7,1465451,89871,'Blue Earth Road',NULL,'Blue Earth','WI','53072','USA',745000.000000,1,4,3,2,1958,950,1950,3,50,-1,13,13,-1,14,16,-1,15,10,0,NULL,NULL,0,NULL,NULL,-1,20,12,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,0,NULL,NULL,1,1,NULL,1,-1,0,-1,0,-1,-1,-1,-1,-1,-1,0,0,-1,-1,0,0,0,0,0,0,0,1,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4500.000000,2006,'Cozy house on 50 acres of land. Perfect for new development. Close to cities. ','kilcrohane-caher-main-20070117-235545.jpg','kilcrohane-caher-main-20070117-235545.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `retblstyle`(`StyleID`,`Style`) VALUES(1,'One Story');
INSERT INTO `retblstyle`(`StyleID`,`Style`) VALUES(2,'One and Half Stories');
INSERT INTO `retblstyle`(`StyleID`,`Style`) VALUES(3,'Two Story');
INSERT INTO `retblstyle`(`StyleID`,`Style`) VALUES(4,'Modified Two Stories');
INSERT INTO `retblstyle`(`StyleID`,`Style`) VALUES(5,'More Than Two Stories');
INSERT INTO `retblstyle`(`StyleID`,`Style`) VALUES(6,'Split Entry (Bi-Level)');
INSERT INTO `retblstyle`(`StyleID`,`Style`) VALUES(7,'Three Level Split');
INSERT INTO `retblstyle`(`StyleID`,`Style`) VALUES(8,'4 or More Level Split');
INSERT INTO `retblstyle`(`StyleID`,`Style`) VALUES(9,'Other');
INSERT INTO `retblstyle`(`StyleID`,`Style`) VALUES(10,'Townhome');
INSERT INTO `retblstyle`(`StyleID`,`Style`) VALUES(11,'Twinhome');
INSERT INTO `retblstyle`(`StyleID`,`Style`) VALUES(12,'Condominium');
INSERT INTO `retblstyle`(`StyleID`,`Style`) VALUES(13,'sdsa');
INSERT INTO `retbltype`(`TypeID`,`sType`) VALUES(1,'Single Family');
INSERT INTO `retbltype`(`TypeID`,`sType`) VALUES(2,'Multi-Family');
INSERT INTO `retbltype`(`TypeID`,`sType`) VALUES(3,'Commercial');
INSERT INTO `retbltype`(`TypeID`,`sType`) VALUES(4,'Lots & Land');
INSERT INTO `retbltype`(`TypeID`,`sType`) VALUES(5,'Rental');
INSERT INTO `retbltype`(`TypeID`,`sType`) VALUES(6,'Vacation');