--
-- Host: localhost    Database: perryestatepro
-- ------------------------------------------------------


--
-- Table structure for table `image`
--

CREATE TABLE `image` (
  `k_image` int(11) NOT NULL AUTO_INCREMENT,
  `fk_property` int(11) NOT NULL DEFAULT '0',
  `imageType` varchar(50) NOT NULL DEFAULT '',
  `displayOrder` int(11) NOT NULL DEFAULT '0',
  `filename` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`k_image`)
) ENGINE=InnoDB AUTO_INCREMENT=1123 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `image`
--

INSERT INTO `image` VALUES (115,12,'Main_Small',0,'12_Main_Small.jpg'),(116,12,'Main_Medium',0,'12_Main_Medium.jpg'),(117,12,'Main_Large',0,'12_Main_Large.jpg'),(118,12,'Additional_Small',1,'12_Additional_Small_1.jpg'),(119,12,'Additional_Medium',1,'12_Additional_Medium_1.jpg'),(120,12,'Additional_Large',1,'12_Additional_Large_1.jpg'),(121,12,'Additional_Small',2,'12_Additional_Small_2.jpg'),(122,12,'Additional_Medium',2,'12_Additional_Medium_2.jpg'),(123,12,'Additional_Large',2,'12_Additional_Large_2.jpg'),(124,12,'Additional_Small',3,'12_Additional_Small_3.jpg'),(125,12,'Additional_Medium',3,'12_Additional_Medium_3.jpg'),(126,12,'Additional_Large',3,'12_Additional_Large_3.jpg'),(127,12,'Additional_Small',4,'12_Additional_Small_4.jpg'),(128,12,'Additional_Medium',4,'12_Additional_Medium_4.jpg'),(129,12,'Additional_Large',4,'12_Additional_Large_4.jpg'),(130,12,'Additional_Small',5,'12_Additional_Small_5.jpg'),(131,12,'Additional_Medium',5,'12_Additional_Medium_5.jpg'),(132,12,'Additional_Large',5,'12_Additional_Large_5.jpg'),(211,20,'Additional_Small',2,'20_Additional_Small_2.jpg'),(212,20,'Additional_Medium',2,'20_Additional_Medium_2.jpg'),(213,20,'Additional_Large',2,'20_Additional_Large_2.jpg'),(214,20,'Additional_Small',3,'20_Additional_Small_3.jpg'),(215,20,'Additional_Medium',3,'20_Additional_Medium_3.jpg'),(216,20,'Additional_Large',3,'20_Additional_Large_3.jpg'),(217,20,'Additional_Small',4,'20_Additional_Small_4.jpg'),(218,20,'Additional_Medium',4,'20_Additional_Medium_4.jpg'),(219,20,'Additional_Large',4,'20_Additional_Large_4.jpg'),(226,21,'Main_Small',0,'21_Main_Small.jpg'),(227,21,'Main_Medium',0,'21_Main_Medium.jpg'),(228,21,'Main_Large',0,'21_Main_Large.jpg'),(229,21,'Additional_Small',1,'21_Additional_Small_1.jpg'),(230,21,'Additional_Medium',1,'21_Additional_Medium_1.jpg'),(231,21,'Additional_Large',1,'21_Additional_Large_1.jpg'),(232,21,'Additional_Small',2,'21_Additional_Small_2.jpg'),(233,21,'Additional_Medium',2,'21_Additional_Medium_2.jpg'),(234,21,'Additional_Large',2,'21_Additional_Large_2.jpg'),(238,21,'Additional_Small',3,'21_Additional_Small_3.jpg'),(239,21,'Additional_Medium',3,'21_Additional_Medium_3.jpg'),(240,21,'Additional_Large',3,'21_Additional_Large_3.jpg'),(241,21,'Additional_Small',4,'21_Additional_Small_4.jpg'),(242,21,'Additional_Medium',4,'21_Additional_Medium_4.jpg'),(243,21,'Additional_Large',4,'21_Additional_Large_4.jpg'),(244,21,'Additional_Small',5,'21_Additional_Small_5.jpg'),(245,21,'Additional_Medium',5,'21_Additional_Medium_5.jpg'),(246,21,'Additional_Large',5,'21_Additional_Large_5.jpg'),(250,20,'Main_Small',0,'20_Main_Small.jpg'),(251,20,'Main_Medium',0,'20_Main_Medium.jpg'),(252,20,'Main_Large',0,'20_Main_Large.jpg'),(253,20,'Additional_Small',5,'20_Additional_Small_5.jpg'),(254,20,'Additional_Medium',5,'20_Additional_Medium_5.jpg'),(255,20,'Additional_Large',5,'20_Additional_Large_5.jpg'),(274,23,'Main_Small',0,'23_Main_Small.jpg'),(275,23,'Main_Medium',0,'23_Main_Medium.jpg'),(276,23,'Main_Large',0,'23_Main_Large.jpg'),(277,23,'Additional_Small',1,'23_Additional_Small_1.jpg'),(278,23,'Additional_Medium',1,'23_Additional_Medium_1.jpg'),(279,23,'Additional_Large',1,'23_Additional_Large_1.jpg'),(280,23,'Additional_Small',2,'23_Additional_Small_2.jpg'),(281,23,'Additional_Medium',2,'23_Additional_Medium_2.jpg'),(282,23,'Additional_Large',2,'23_Additional_Large_2.jpg'),(283,23,'Additional_Small',3,'23_Additional_Small_3.jpg'),(284,23,'Additional_Medium',3,'23_Additional_Medium_3.jpg'),(285,23,'Additional_Large',3,'23_Additional_Large_3.jpg'),(286,23,'Additional_Small',4,'23_Additional_Small_4.jpg'),(287,23,'Additional_Medium',4,'23_Additional_Medium_4.jpg'),(288,23,'Additional_Large',4,'23_Additional_Large_4.jpg'),(292,23,'Additional_Small',6,'23_Additional_Small_6.jpg'),(293,23,'Additional_Medium',6,'23_Additional_Medium_6.jpg'),(294,23,'Additional_Large',6,'23_Additional_Large_6.jpg'),(295,24,'Main_Small',0,'24_Main_Small.jpg'),(296,24,'Main_Medium',0,'24_Main_Medium.jpg'),(297,24,'Main_Large',0,'24_Main_Large.jpg'),(310,22,'Additional_Small',9,'22_Additional_Small_9.jpg'),(311,22,'Additional_Medium',9,'22_Additional_Medium_9.jpg'),(312,22,'Additional_Large',9,'22_Additional_Large_9.jpg'),(313,22,'Additional_Small',10,'22_Additional_Small_10.jpg'),(314,22,'Additional_Medium',10,'22_Additional_Medium_10.jpg'),(315,22,'Additional_Large',10,'22_Additional_Large_10.jpg'),(316,22,'Additional_Small',11,'22_Additional_Small_11.jpg'),(317,22,'Additional_Medium',11,'22_Additional_Medium_11.jpg'),(318,22,'Additional_Large',11,'22_Additional_Large_11.jpg'),(322,22,'Main_Small',0,'22_Main_Small.jpg'),(323,22,'Main_Medium',0,'22_Main_Medium.jpg'),(324,22,'Main_Large',0,'22_Main_Large.jpg'),(325,22,'Additional_Small',12,'22_Additional_Small_12.jpg'),(326,22,'Additional_Medium',12,'22_Additional_Medium_12.jpg'),(327,22,'Additional_Large',12,'22_Additional_Large_12.jpg'),(328,22,'Additional_Small',13,'22_Additional_Small_13.jpg'),(329,22,'Additional_Medium',13,'22_Additional_Medium_13.jpg'),(330,22,'Additional_Large',13,'22_Additional_Large_13.jpg'),(343,25,'Main_Small',0,'25_Main_Small.jpg'),(344,25,'Main_Medium',0,'25_Main_Medium.jpg'),(345,25,'Main_Large',0,'25_Main_Large.jpg'),(595,11,'Main_Small',0,'11_Main_Small.jpg'),(596,11,'Main_Medium',0,'11_Main_Medium.jpg'),(597,11,'Main_Large',0,'11_Main_Large.jpg'),(604,11,'Main_Small',0,'11_Main_Small.jpg'),(605,11,'Main_Medium',0,'11_Main_Medium.jpg'),(606,11,'Main_Large',0,'11_Main_Large.jpg'),(631,11,'Additional_Small',1,'11_Additional_Small_1.jpg'),(632,11,'Additional_Medium',1,'11_Additional_Medium_1.jpg'),(633,11,'Additional_Large',1,'11_Additional_Large_1.jpg'),(637,11,'Additional_Small',3,'11_Additional_Small_3.jpg'),(638,11,'Additional_Medium',3,'11_Additional_Medium_3.jpg'),(639,11,'Additional_Large',3,'11_Additional_Large_3.jpg'),(736,11,'Main_Small',0,'11_Main_Small.jpg'),(737,11,'Main_Medium',0,'11_Main_Medium.jpg'),(738,11,'Main_Large',0,'11_Main_Large.jpg'),(739,11,'Main_Small',0,'11_Main_Small.jpg'),(740,11,'Main_Medium',0,'11_Main_Medium.jpg'),(741,11,'Main_Large',0,'11_Main_Large.jpg'),(742,11,'Main_Small',0,''),(743,11,'Main_Medium',0,''),(744,11,'Main_Large',0,''),(745,11,'Main_Small',0,''),(746,11,'Main_Medium',0,''),(747,11,'Main_Large',0,''),(763,11,'Main_Small',0,'11_Main_Small.jpg'),(764,11,'Main_Medium',0,'11_Main_Medium.jpg'),(765,11,'Main_Large',0,'11_Main_Large.jpg'),(766,11,'Main_Small',0,'11_Main_Small.jpg'),(767,11,'Main_Medium',0,'11_Main_Medium.jpg'),(768,11,'Main_Large',0,'11_Main_Large.jpg'),(775,25,'Main_Small',0,'25_Main_Small.jpg'),(776,25,'Main_Medium',0,'25_Main_Medium.jpg'),(777,25,'Main_Large',0,'25_Main_Large.jpg'),(781,26,'Main_Small',0,'26_Main_Small.jpg'),(782,26,'Main_Medium',0,'26_Main_Medium.jpg'),(784,26,'Additional_Small',1,'26_Additional_Small_1.jpg'),(785,26,'Additional_Medium',1,'26_Additional_Medium_1.jpg'),(786,26,'Additional_Large',1,'26_Additional_Large_1.jpg'),(787,26,'Additional_Small',2,'26_Additional_Small_2.jpg'),(788,26,'Additional_Medium',2,'26_Additional_Medium_2.jpg'),(789,26,'Additional_Large',2,'26_Additional_Large_2.jpg'),(790,26,'Additional_Small',3,'26_Additional_Small_3.jpg'),(791,26,'Additional_Medium',3,'26_Additional_Medium_3.jpg'),(792,26,'Additional_Large',3,'26_Additional_Large_3.jpg'),(799,26,'Additional_Small',6,'26_Additional_Small_6.jpg'),(800,26,'Additional_Medium',6,'26_Additional_Medium_6.jpg'),(801,26,'Additional_Large',6,'26_Additional_Large_6.jpg'),(802,27,'Main_Small',0,'27_Main_Small.jpg'),(803,27,'Main_Medium',0,'27_Main_Medium.jpg'),(804,27,'Main_Large',0,'27_Main_Large.jpg'),(805,27,'Main_Small',0,'27_Main_Small.jpg'),(806,27,'Main_Medium',0,'27_Main_Medium.jpg'),(807,27,'Main_Large',0,'27_Main_Large.jpg'),(808,27,'Additional_Small',1,'27_Additional_Small_1.jpg'),(809,27,'Additional_Medium',1,'27_Additional_Medium_1.jpg'),(810,27,'Additional_Large',1,'27_Additional_Large_1.jpg'),(811,27,'Main_Small',0,'27_Main_Small.jpg'),(812,27,'Main_Medium',0,'27_Main_Medium.jpg'),(813,27,'Main_Large',0,'27_Main_Large.jpg'),(814,27,'Additional_Small',2,'27_Additional_Small_2.jpg'),(815,27,'Additional_Medium',2,'27_Additional_Medium_2.jpg'),(816,27,'Additional_Large',2,'27_Additional_Large_2.jpg'),(817,27,'Additional_Small',3,'27_Additional_Small_3.jpg'),(818,27,'Additional_Medium',3,'27_Additional_Medium_3.jpg'),(819,27,'Additional_Large',3,'27_Additional_Large_3.jpg'),(820,27,'Additional_Small',4,'27_Additional_Small_4.jpg'),(821,27,'Additional_Medium',4,'27_Additional_Medium_4.jpg'),(822,27,'Additional_Large',4,'27_Additional_Large_4.jpg'),(823,27,'Additional_Small',5,'27_Additional_Small_5.jpg'),(824,27,'Additional_Medium',5,'27_Additional_Medium_5.jpg'),(825,27,'Additional_Large',5,'27_Additional_Large_5.jpg'),(826,27,'Additional_Small',6,'27_Additional_Small_6.jpg'),(827,27,'Additional_Medium',6,'27_Additional_Medium_6.jpg'),(828,27,'Additional_Large',6,'27_Additional_Large_6.jpg'),(829,27,'Additional_Small',7,'27_Additional_Small_7.jpg'),(830,27,'Additional_Medium',7,'27_Additional_Medium_7.jpg'),(831,27,'Additional_Large',7,'27_Additional_Large_7.jpg'),(832,27,'Additional_Small',8,'27_Additional_Small_8.jpg'),(833,27,'Additional_Medium',8,'27_Additional_Medium_8.jpg'),(834,27,'Additional_Large',8,'27_Additional_Large_8.jpg'),(835,28,'Main_Small',0,'28_Main_Small.jpg'),(836,28,'Main_Medium',0,'28_Main_Medium.jpg'),(837,28,'Main_Large',0,'28_Main_Large.jpg'),(838,28,'Additional_Small',1,'28_Additional_Small_1.jpg'),(839,28,'Additional_Medium',1,'28_Additional_Medium_1.jpg'),(840,28,'Additional_Large',1,'28_Additional_Large_1.jpg'),(841,28,'Additional_Small',2,'28_Additional_Small_2.jpg'),(842,28,'Additional_Medium',2,'28_Additional_Medium_2.jpg'),(843,28,'Additional_Large',2,'28_Additional_Large_2.jpg'),(847,28,'Additional_Small',4,'28_Additional_Small_4.jpg'),(848,28,'Additional_Medium',4,'28_Additional_Medium_4.jpg'),(849,28,'Additional_Large',4,'28_Additional_Large_4.jpg'),(850,28,'Additional_Small',5,'28_Additional_Small_5.jpg'),(851,28,'Additional_Medium',5,'28_Additional_Medium_5.jpg'),(852,28,'Additional_Large',5,'28_Additional_Large_5.jpg'),(853,28,'Additional_Small',6,'28_Additional_Small_6.jpg'),(854,28,'Additional_Medium',6,'28_Additional_Medium_6.jpg'),(855,28,'Additional_Large',6,'28_Additional_Large_6.jpg'),(856,29,'Main_Small',0,'29_Main_Small.jpg'),(857,29,'Main_Medium',0,'29_Main_Medium.jpg'),(858,29,'Main_Large',0,'29_Main_Large.jpg'),(859,29,'Main_Small',0,'29_Main_Small.jpg'),(860,29,'Main_Medium',0,'29_Main_Medium.jpg'),(861,29,'Main_Large',0,'29_Main_Large.jpg'),(877,29,'Main_Small',0,'29_Main_Small.jpg'),(878,29,'Main_Medium',0,'29_Main_Medium.jpg'),(879,29,'Main_Large',0,'29_Main_Large.jpg'),(880,29,'Main_Small',0,'29_Main_Small.jpg'),(881,29,'Main_Medium',0,'29_Main_Medium.jpg'),(882,29,'Main_Large',0,'29_Main_Large.jpg'),(883,29,'Additional_Small',1,'29_Additional_Small_1.jpg'),(884,29,'Additional_Medium',1,'29_Additional_Medium_1.jpg'),(885,29,'Additional_Large',1,'29_Additional_Large_1.jpg'),(886,29,'Additional_Small',2,'29_Additional_Small_2.jpg'),(887,29,'Additional_Medium',2,'29_Additional_Medium_2.jpg'),(888,29,'Additional_Large',2,'29_Additional_Large_2.jpg'),(889,29,'Additional_Small',3,'29_Additional_Small_3.jpg'),(890,29,'Additional_Medium',3,'29_Additional_Medium_3.jpg'),(891,29,'Additional_Large',3,'29_Additional_Large_3.jpg'),(892,29,'Additional_Small',4,'29_Additional_Small_4.jpg'),(893,29,'Additional_Medium',4,'29_Additional_Medium_4.jpg'),(894,29,'Additional_Large',4,'29_Additional_Large_4.jpg'),(895,29,'Additional_Small',5,'29_Additional_Small_5.jpg'),(896,29,'Additional_Medium',5,'29_Additional_Medium_5.jpg'),(897,29,'Additional_Large',5,'29_Additional_Large_5.jpg'),(898,30,'Main_Small',0,'30_Main_Small.jpg'),(899,30,'Main_Medium',0,'30_Main_Medium.jpg'),(900,30,'Main_Large',0,'30_Main_Large.jpg'),(901,30,'Main_Small',0,'30_Main_Small.jpg'),(902,30,'Main_Medium',0,'30_Main_Medium.jpg'),(903,30,'Main_Large',0,'30_Main_Large.jpg'),(904,30,'Additional_Small',1,'30_Additional_Small_1.jpg'),(905,30,'Additional_Medium',1,'30_Additional_Medium_1.jpg'),(906,30,'Additional_Large',1,'30_Additional_Large_1.jpg'),(907,30,'Additional_Small',2,'30_Additional_Small_2.jpg'),(908,30,'Additional_Medium',2,'30_Additional_Medium_2.jpg'),(909,30,'Additional_Large',2,'30_Additional_Large_2.jpg'),(910,30,'Additional_Small',3,'30_Additional_Small_3.jpg'),(911,30,'Additional_Medium',3,'30_Additional_Medium_3.jpg'),(912,30,'Additional_Large',3,'30_Additional_Large_3.jpg'),(913,30,'Additional_Small',4,'30_Additional_Small_4.jpg'),(914,30,'Additional_Medium',4,'30_Additional_Medium_4.jpg'),(915,30,'Additional_Large',4,'30_Additional_Large_4.jpg'),(916,30,'Additional_Small',5,'30_Additional_Small_5.jpg'),(917,30,'Additional_Medium',5,'30_Additional_Medium_5.jpg'),(918,30,'Additional_Large',5,'30_Additional_Large_5.jpg'),(919,31,'Main_Small',0,'31_Main_Small.jpg'),(920,31,'Main_Medium',0,'31_Main_Medium.jpg'),(921,31,'Main_Large',0,'31_Main_Large.jpg'),(922,32,'Main_Small',0,'32_Main_Small.jpg'),(923,32,'Main_Medium',0,'32_Main_Medium.jpg'),(924,32,'Main_Large',0,'32_Main_Large.jpg'),(925,32,'Main_Small',0,'32_Main_Small.jpg'),(926,32,'Main_Medium',0,'32_Main_Medium.jpg'),(927,32,'Main_Large',0,'32_Main_Large.jpg'),(928,32,'Additional_Small',1,'32_Additional_Small_1.jpg'),(929,32,'Additional_Medium',1,'32_Additional_Medium_1.jpg'),(930,32,'Additional_Large',1,'32_Additional_Large_1.jpg'),(931,32,'Additional_Small',2,'32_Additional_Small_2.jpg'),(932,32,'Additional_Medium',2,'32_Additional_Medium_2.jpg'),(933,32,'Additional_Large',2,'32_Additional_Large_2.jpg'),(934,32,'Additional_Small',3,'32_Additional_Small_3.jpg'),(935,32,'Additional_Medium',3,'32_Additional_Medium_3.jpg'),(936,32,'Additional_Large',3,'32_Additional_Large_3.jpg'),(937,32,'Additional_Small',4,'32_Additional_Small_4.jpg'),(938,32,'Additional_Medium',4,'32_Additional_Medium_4.jpg'),(939,32,'Additional_Large',4,'32_Additional_Large_4.jpg'),(940,32,'Additional_Small',5,'32_Additional_Small_5.jpg'),(941,32,'Additional_Medium',5,'32_Additional_Medium_5.jpg'),(942,32,'Additional_Large',5,'32_Additional_Large_5.jpg'),(943,33,'Main_Small',0,'33_Main_Small.jpg'),(944,33,'Main_Medium',0,'33_Main_Medium.jpg'),(945,33,'Main_Large',0,'33_Main_Large.jpg'),(946,33,'Main_Small',0,'33_Main_Small.jpg'),(947,33,'Main_Medium',0,'33_Main_Medium.jpg'),(948,33,'Main_Large',0,'33_Main_Large.jpg'),(1018,33,'Additional_Small',1,'33_Additional_Small_1.jpg'),(1019,33,'Additional_Medium',1,'33_Additional_Medium_1.jpg'),(1020,33,'Additional_Large',1,'33_Additional_Large_1.jpg'),(1021,33,'Additional_Small',2,'33_Additional_Small_2.jpg'),(1022,33,'Additional_Medium',2,'33_Additional_Medium_2.jpg'),(1023,33,'Additional_Large',2,'33_Additional_Large_2.jpg'),(1024,33,'Additional_Small',3,'33_Additional_Small_3.jpg'),(1025,33,'Additional_Medium',3,'33_Additional_Medium_3.jpg'),(1026,33,'Additional_Large',3,'33_Additional_Large_3.jpg'),(1027,33,'Additional_Small',4,'33_Additional_Small_4.jpg'),(1028,33,'Additional_Medium',4,'33_Additional_Medium_4.jpg'),(1029,33,'Additional_Large',4,'33_Additional_Large_4.jpg'),(1030,33,'Additional_Small',5,'33_Additional_Small_5.jpg'),(1031,33,'Additional_Medium',5,'33_Additional_Medium_5.jpg'),(1032,33,'Additional_Large',5,'33_Additional_Large_5.jpg'),(1033,33,'Additional_Small',6,'33_Additional_Small_6.jpg'),(1034,33,'Additional_Medium',6,'33_Additional_Medium_6.jpg'),(1035,33,'Additional_Large',6,'33_Additional_Large_6.jpg'),(1036,33,'Additional_Small',7,'33_Additional_Small_7.jpg'),(1037,33,'Additional_Medium',7,'33_Additional_Medium_7.jpg'),(1038,33,'Additional_Large',7,'33_Additional_Large_7.jpg'),(1039,33,'Additional_Small',8,'33_Additional_Small_8.jpg'),(1040,33,'Additional_Medium',8,'33_Additional_Medium_8.jpg'),(1041,33,'Additional_Large',8,'33_Additional_Large_8.jpg'),(1042,33,'Additional_Small',9,'33_Additional_Small_9.jpg'),(1043,33,'Additional_Medium',9,'33_Additional_Medium_9.jpg'),(1044,33,'Additional_Large',9,'33_Additional_Large_9.jpg'),(1045,33,'Additional_Small',10,'33_Additional_Small_10.jpg'),(1046,33,'Additional_Medium',10,'33_Additional_Medium_10.jpg'),(1047,33,'Additional_Large',10,'33_Additional_Large_10.jpg'),(1048,33,'Additional_Small',11,'33_Additional_Small_11.jpg'),(1049,33,'Additional_Medium',11,'33_Additional_Medium_11.jpg'),(1050,33,'Additional_Large',11,'33_Additional_Large_11.jpg'),(1051,33,'Additional_Small',12,'33_Additional_Small_12.jpg'),(1052,33,'Additional_Medium',12,'33_Additional_Medium_12.jpg'),(1053,33,'Additional_Large',12,'33_Additional_Large_12.jpg'),(1054,33,'Additional_Small',13,'33_Additional_Small_13.jpg'),(1055,33,'Additional_Medium',13,'33_Additional_Medium_13.jpg'),(1056,33,'Additional_Large',13,'33_Additional_Large_13.jpg'),(1057,33,'Additional_Small',14,'33_Additional_Small_14.jpg'),(1058,33,'Additional_Medium',14,'33_Additional_Medium_14.jpg'),(1059,33,'Additional_Large',14,'33_Additional_Large_14.jpg'),(1060,33,'Additional_Small',15,'33_Additional_Small_15.jpg'),(1061,33,'Additional_Medium',15,'33_Additional_Medium_15.jpg'),(1062,33,'Additional_Large',15,'33_Additional_Large_15.jpg'),(1063,33,'Additional_Small',16,'33_Additional_Small_16.jpg'),(1064,33,'Additional_Medium',16,'33_Additional_Medium_16.jpg'),(1065,33,'Additional_Large',16,'33_Additional_Large_16.jpg'),(1066,33,'Additional_Small',17,'33_Additional_Small_17.jpg'),(1067,33,'Additional_Medium',17,'33_Additional_Medium_17.jpg'),(1068,33,'Additional_Large',17,'33_Additional_Large_17.jpg'),(1069,33,'Additional_Small',18,'33_Additional_Small_18.jpg'),(1070,33,'Additional_Medium',18,'33_Additional_Medium_18.jpg'),(1071,33,'Additional_Large',18,'33_Additional_Large_18.jpg'),(1072,34,'Main_Small',0,'34_Main_Small.jpg'),(1073,34,'Main_Medium',0,'34_Main_Medium.jpg'),(1074,34,'Main_Large',0,'34_Main_Large.jpg'),(1075,34,'Additional_Small',1,'34_Additional_Small_1.jpg'),(1076,34,'Additional_Medium',1,'34_Additional_Medium_1.jpg'),(1077,34,'Additional_Large',1,'34_Additional_Large_1.jpg'),(1078,34,'Additional_Small',2,'34_Additional_Small_2.jpg'),(1079,34,'Additional_Medium',2,'34_Additional_Medium_2.jpg'),(1080,34,'Additional_Large',2,'34_Additional_Large_2.jpg'),(1081,34,'Additional_Small',3,'34_Additional_Small_3.jpg'),(1082,34,'Additional_Medium',3,'34_Additional_Medium_3.jpg'),(1083,34,'Additional_Large',3,'34_Additional_Large_3.jpg'),(1084,34,'Additional_Small',4,'34_Additional_Small_4.jpg'),(1085,34,'Additional_Medium',4,'34_Additional_Medium_4.jpg'),(1086,34,'Additional_Large',4,'34_Additional_Large_4.jpg'),(1087,34,'Additional_Small',5,'34_Additional_Small_5.jpg'),(1088,34,'Additional_Medium',5,'34_Additional_Medium_5.jpg'),(1089,34,'Additional_Large',5,'34_Additional_Large_5.jpg'),(1090,34,'Additional_Small',6,'34_Additional_Small_6.jpg'),(1091,34,'Additional_Medium',6,'34_Additional_Medium_6.jpg'),(1092,34,'Additional_Large',6,'34_Additional_Large_6.jpg'),(1093,34,'Additional_Small',7,'34_Additional_Small_7.jpg'),(1094,34,'Additional_Medium',7,'34_Additional_Medium_7.jpg'),(1095,34,'Additional_Large',7,'34_Additional_Large_7.jpg'),(1096,34,'Additional_Small',8,'34_Additional_Small_8.jpg'),(1097,34,'Additional_Medium',8,'34_Additional_Medium_8.jpg'),(1098,34,'Additional_Large',8,'34_Additional_Large_8.jpg'),(1111,34,'Additional_Small',9,'34_Additional_Small_9.jpg'),(1112,34,'Additional_Medium',9,'34_Additional_Medium_9.jpg'),(1113,34,'Additional_Large',9,'34_Additional_Large_9.jpg'),(1114,34,'Additional_Small',10,'34_Additional_Small_10.jpg'),(1115,34,'Additional_Medium',10,'34_Additional_Medium_10.jpg'),(1116,34,'Additional_Large',10,'34_Additional_Large_10.jpg'),(1117,34,'Additional_Small',11,'34_Additional_Small_11.jpg'),(1118,34,'Additional_Medium',11,'34_Additional_Medium_11.jpg'),(1119,34,'Additional_Large',11,'34_Additional_Large_11.jpg'),(1120,35,'Main_Small',0,'35_Main_Small.jpg'),(1121,35,'Main_Medium',0,'35_Main_Medium.jpg'),(1122,35,'Main_Large',0,'35_Main_Large.jpg');

--
-- Table structure for table `property`
--

CREATE TABLE `property` (
  `k_property` int(11) NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` int(11) NOT NULL DEFAULT '0',
  `propertyType` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`k_property`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `property`
--

INSERT INTO `property` VALUES (11,'2005-12-19 08:38:31',0,'residential'),(12,'2006-01-17 14:28:40',0,'residential'),(20,'2007-09-03 14:29:21',0,'residential'),(21,'2008-01-10 14:16:45',0,'residential'),(22,'2008-05-17 13:29:21',0,'residential'),(23,'2008-05-17 13:52:02',0,'residential'),(24,'2008-05-17 14:03:16',0,'residential'),(25,'2008-06-18 12:19:54',0,'residential'),(26,'2008-07-15 11:32:28',0,'residential'),(27,'2008-08-22 11:51:28',0,'residential'),(28,'2008-08-22 12:00:53',0,'residential'),(29,'2008-09-16 12:41:40',0,'residential'),(30,'2008-10-19 14:48:58',1,'residential'),(31,'2008-12-04 11:45:58',0,'residential'),(32,'2009-02-03 13:07:32',0,'residential'),(33,'2009-02-28 12:17:50',0,'residential'),(34,'2009-08-05 14:36:03',0,'residential'),(35,'2009-08-05 14:43:43',0,'residential');

--
-- Table structure for table `propertyAttribute`
--

CREATE TABLE `propertyAttribute` (
  `k_propertyAttribute` int(11) NOT NULL AUTO_INCREMENT,
  `fk_property` int(11) NOT NULL DEFAULT '0',
  `fk_propertyAttributeDef` int(11) NOT NULL DEFAULT '0',
  `value` text NOT NULL,
  PRIMARY KEY (`k_propertyAttribute`)
) ENGINE=InnoDB AUTO_INCREMENT=3793 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `propertyAttribute`
--

INSERT INTO `propertyAttribute` VALUES (721,11,1,'3457 White Rose Way, Encino 91436'),(722,11,2,'Set on private, gated one plus acre knoll with views in every direction, this fabulous newer custom built 6BR, 8.5BA Italian villa estate with lighted tennis court, pool, spa & enchanting professionally lanscaped grounds affords the finest in California living. Enormous granite chef\'s kitchen, great Master w FP & terrace, half-pipe skate park, eat-in wine cellart, media room with wet bar, high ceilings & french doors. Superb craftsmanship. Convenient to all.'),(723,11,3,'$ 5,950,000'),(724,11,4,'3'),(725,11,5,'8,250/OW'),(726,11,6,'45,302/AS'),(727,11,7,'6'),(728,11,8,'8.5'),(729,11,9,'(26) San Fernando Valley'),(730,11,10,''),(731,11,11,''),(732,11,12,''),(733,11,13,''),(734,11,14,'Villa'),(735,11,15,'Bar, Breakfast, Dining, Family, Library/Study, Living, Media, Pantry, Patio Covered, Patio Open, Powder, Wine Cellar'),(736,11,16,'Carpet, Hardwood, Marble, Stone'),(737,11,17,'Family Room, Living Room, Master Bedroom'),(738,11,18,'Canyon, City Lights, Mountains'),(739,11,19,''),(740,11,20,'Private'),(741,11,21,''),(742,11,22,'Heated, Private'),(743,11,23,'Tile'),(744,11,24,'Private'),(937,12,1,'6400 E. Cactus Wren Rd., Paradise Valley'),(938,12,2,'PICCOLO MONDO-Gated Private Estate, set in a magical setting of over 5 flat acres of park like grounds with Palms,Cactus & Rose Gardens,patios w/fireplaces and lawns that seem to go forever; is truly SPECTACULAR and one of a kind in all of Phoenix. Located within the COMPOUND is a Swimmer\'s Pool,T.C, Gazebo, G.H. & Miniture Golf Course. Great for ENTERAINING a few friends or 500 guests. A long driveway leads to a large motorcourt and a RESIDENCE that is so special it must be seen to be appreciated. Magnificent views of P.V., Scottsdale & Camelback Mtn. further document this unique one and only of a kind ESTATE.'),(939,12,3,'$ 14,000,000'),(940,12,4,'Single level'),(941,12,5,'7600'),(942,12,6,'5-9.9 Acres'),(943,12,7,'4'),(944,12,8,'5'),(945,12,9,''),(946,12,10,''),(947,12,11,''),(948,12,12,''),(949,12,13,''),(950,12,14,''),(951,12,15,''),(952,12,16,''),(953,12,17,'3+'),(954,12,18,''),(955,12,19,''),(956,12,20,''),(957,12,21,''),(958,12,22,'Private Pool'),(959,12,23,'All Tile Roof'),(960,12,24,'Above Ground Spa'),(1657,20,1,'Arizona Biltmore\'s Bilmore Villas II -----------6186 North 28th Place Phoenix 85016'),(1658,20,2,'Located in the gated community of the Arizona Biltmore Villas 2, this beautiful home has a terrific floor plan with an oversized living room. \r\n\r\nThis remodelled villa boasts new amenities in the bathroom and kitchen areas. Everything is here, from the Sub Zero and KitchenAid stainless appliances, to the granite countertops and saltillo tile throughout.\r\n\r\n A wonderful outdoor patio leads to a desert landscaped garden with a golf course view. You will love coming home to your resort like retreat on the 14th hole of the Biltmore Links Golf Course.\r\n\r\nShown by appointment only.\r\n\r\nPlease call Leon Dang at 602-571-6121'),(1659,20,3,'SOLD!!!!!!!!!!'),(1660,20,4,'1'),(1661,20,5,'1919'),(1662,20,6,'1-7500 sqft'),(1663,20,7,'3'),(1664,20,8,'3'),(1665,20,9,'206'),(1666,20,10,''),(1667,20,11,''),(1668,20,12,''),(1669,20,13,''),(1670,20,14,''),(1671,20,15,''),(1672,20,16,'Satillo tile throughout'),(1673,20,17,'Wood burning'),(1674,20,18,'Mountain and golf course'),(1675,20,19,''),(1676,20,20,'HOA Maintained'),(1677,20,21,''),(1678,20,22,'N/A'),(1679,20,23,'Tile'),(1680,20,24,''),(1729,21,1,'Soon to be Gated community of Dos Puertas- 4328 North 40th Street Phoenix 85018'),(1730,21,2,'Hidden away in the private enclave of Dos Puertas, this jewel is just a hop, skip and a jump from everything. \r\n\r\nTake a walk to La Grande Orange for morning coffee. Enjoy Biltmore, Arcadia and Scottsdale shopping, restaurants or golf. Come back to a cozy 2bed/2bath home boasting a spacious floor plan with a grand fireplace and a redesigned kitchen w/stainless appliances. \r\n\r\n\r\nAppointed with skylights, carved wood beams, large walk-in closets, full size laundry, park-like common areas w/community pool, and a sporty garage w/epoxy floors and built in cabs. Just minutes from airport, downtown, and freeway access.\r\n\r\nSeller has paid for Gate assesment.\r\n\r\nThis beautiful townhome shown by appointment only.\r\n\r\nPlease call Leon Dang at 602-571-6121'),(1731,21,3,'Offered at $680,000'),(1732,21,4,'1'),(1733,21,5,'2033'),(1734,21,6,'1-7500'),(1735,21,7,'2'),(1736,21,8,'2'),(1737,21,9,'206'),(1738,21,10,''),(1739,21,11,''),(1740,21,12,''),(1741,21,13,''),(1742,21,14,'Spanish'),(1743,21,15,''),(1744,21,16,'Satillo/Carpet'),(1745,21,17,'Gas'),(1746,21,18,'Mountain/Park-like setting'),(1747,21,19,''),(1748,21,20,''),(1749,21,21,''),(1750,21,22,'Community-heated'),(1751,21,23,''),(1752,21,24,''),(2929,23,1,'SOLD-AZ BiltmoreGolf Course Home-6196 North 28th Place Phoenix 85016'),(2930,23,2,'Located in the Heart of the Arizona Biltmore, your future home will provide you with resort like amenities. Private pool/spa, golf course and mountain views,BBQ island and covered patio w/misters are all an entertainers\' dream. \r\n\r\nBe invited inside your home by wood floors, soaring beams, bright expansive ceiling height windows, and a cozy fireplace. Finished with a modern kitchen, and a nice master suite....what more could you ask for? Shopping? Restaurants? Easy access to Freeways? Being minutes from the airport? Ok, you got it.\r\n\r\nViewings by appointment only. \r\nPlease call Leon Dang at (602) 571-6121'),(2931,23,3,'Offered at - SOLD'),(2932,23,4,'1'),(2933,23,5,'1822'),(2934,23,6,'6143'),(2935,23,7,'3'),(2936,23,8,'2'),(2937,23,9,'206'),(2938,23,10,''),(2939,23,11,''),(2940,23,12,''),(2941,23,13,''),(2942,23,14,'Spanish'),(2943,23,15,''),(2944,23,16,'Hardwood'),(2945,23,17,'Wood burning'),(2946,23,18,'Golf and Mountain Views'),(2947,23,19,'Security - Owned'),(2948,23,20,'Community'),(2949,23,21,''),(2950,23,22,'Private/Heated'),(2951,23,23,''),(2952,23,24,'Private/Heated'),(3049,25,1,'Charming Arcadia Ranch for Lease -------------------4415 East Piccadilly Road 85018'),(3050,25,2,'This 3 bed home located aroudn the corner from Arcadia High School comes with wood, tile, and carpet in all the right places...Withing walking distance to shopping, restaurants, and schools.\r\nJust minutes from freeways, downtown,and the airport...Landscaping care included in lease.\r\nPETS WELCOME!\r\n\r\nPlease contact Leon Dang c(602) 571-6121'),(3051,25,3,'Offered at  LEASED'),(3052,25,4,'1'),(3053,25,5,''),(3054,25,6,''),(3055,25,7,'3'),(3056,25,8,'1.75'),(3057,25,9,'206'),(3058,25,10,'$1350'),(3059,25,11,''),(3060,25,12,''),(3061,25,13,''),(3062,25,14,''),(3063,25,15,''),(3064,25,16,''),(3065,25,17,''),(3066,25,18,''),(3067,25,19,''),(3068,25,20,''),(3069,25,21,''),(3070,25,22,''),(3071,25,23,''),(3072,25,24,''),(3337,31,1,'IMPROVED LOT----------------------------------------11571 West Mountain Shadows'),(3338,31,2,'BUILDER/INVESTMENT OPPORTUNITY.  IMPROVED LOT in Casa Grande.Own this hillside property with forever views. Great seclusion, but yet, just minutes from freeway access. Once you visit make sure to check out the mountain reserve views just NE of property. 1.07 acres'),(3339,31,3,'PRICE REDUCTION - Offered $69,500'),(3340,31,4,''),(3341,31,5,''),(3342,31,6,''),(3343,31,7,''),(3344,31,8,''),(3345,31,9,''),(3346,31,10,''),(3347,31,11,''),(3348,31,12,''),(3349,31,13,''),(3350,31,14,''),(3351,31,15,''),(3352,31,16,''),(3353,31,17,''),(3354,31,18,''),(3355,31,19,''),(3356,31,20,''),(3357,31,21,''),(3358,31,22,''),(3359,31,23,''),(3360,31,24,''),(3361,29,1,'CASA GRANDE view lot ----------------------------11906 W Sweet Acacia DR'),(3362,29,2,'Don\'t miss the opportunity to own this mountain view lot. Ample seclusion and privacy, but yet just minutes away from necesity shopping and freeway access. Build the home of your dreams on this North/South lot in the up and coming Casa Grande area. Do yourself a favor and visit the property at sunset. You won\'t regret it.'),(3363,29,3,'PRICE REDUCTION - Offered at $97,500'),(3364,29,4,''),(3365,29,5,''),(3366,29,6,'1.87 ACRES'),(3367,29,7,''),(3368,29,8,''),(3369,29,9,''),(3370,29,10,''),(3371,29,11,''),(3372,29,12,''),(3373,29,13,''),(3374,29,14,''),(3375,29,15,''),(3376,29,16,''),(3377,29,17,''),(3378,29,18,''),(3379,29,19,''),(3380,29,20,''),(3381,29,21,''),(3382,29,22,''),(3383,29,23,''),(3384,29,24,''),(3385,32,1,'ARCADIA REMODEL---------------------------------------6345 East Michell Drive'),(3386,32,2,'RARE 5 BEDROOM home. Enjoy the bright and wide open spaces created by the owners\' thoughtful renovation. Follow the split floor plan lined with oak wood floors, travertine tile, and slate. Notice the amount of light that is allowed in by multiple sets of French doors placed around the home. The master suite could provide a spa like experience, and the oversize back patio/pool area is to die for. Fifth Bed being used as office has it\'s own separate exit.'),(3387,32,3,'Offered at $760,000'),(3388,32,4,'1'),(3389,32,5,'3000 by owner'),(3390,32,6,'.23 acres'),(3391,32,7,'5'),(3392,32,8,'3'),(3393,32,9,'p36'),(3394,32,10,''),(3395,32,11,''),(3396,32,12,''),(3397,32,13,''),(3398,32,14,''),(3399,32,15,''),(3400,32,16,'Wood/Travertine/Slate'),(3401,32,17,'1 Fireplace'),(3402,32,18,''),(3403,32,19,''),(3404,32,20,''),(3405,32,21,''),(3406,32,22,'Lap Pool'),(3407,32,23,''),(3408,32,24,''),(3481,27,1,'Rancho Mirada Condominiums------------------3845 East Greenway Road #108'),(3482,27,2,'Welcome to the luxury homes of Rancho Mirada where you\'ll find condo living at it\'s best. Experience the many amenities including beautiful kitchens and baths, fireplaces, modern flooring, wall finishes and cabinetry. Centrally located...convenient freeway access will allow you to travel to destinations such as downtown and the airport within minutes. Enjoy the community offerings poolside or get a workout at the fitness room. Close location for PV students or hospital employees wanting to be closer to work. We have several one and two bedroom homes available. PHOTOS REPRESENT THE STAGED MODEL'),(3483,27,3,'PRICE REDUCTIONS - 1 bed/1bath $115,000 2bed/2bath $150,000'),(3484,27,4,'1'),(3485,27,5,'702 - Builder'),(3486,27,6,''),(3487,27,7,'1'),(3488,27,8,'1'),(3489,27,9,'L35'),(3490,27,10,''),(3491,27,11,''),(3492,27,12,''),(3493,27,13,''),(3494,27,14,''),(3495,27,15,''),(3496,27,16,''),(3497,27,17,'Great room Fireplace'),(3498,27,18,''),(3499,27,19,'Gated Community'),(3500,27,20,''),(3501,27,21,''),(3502,27,22,'Community'),(3503,27,23,''),(3504,27,24,''),(3505,28,1,'Rancho Mirada Condominiums--------------3845 East Greenway Road #206'),(3506,28,2,'Luxury loft style condos in quiet, gated community near SR-51 and 101,hospital,PVCC, churches, library, excellent shopping at Desert Ridge, PV Mall and the Kierlands. Amazing kitchen has maple cabinetry, new appliances and custom finishes. Open floor plan for dining and living room. Nicely sized master bedroom with walkin closet. Plush carpet in all the right areas. Living room features fireplace and walkout to patio. FHA approved.'),(3507,28,3,'PRICE REDUCTIONS - ALL 1bed/1bath $115,000.  ALL 2bed/2bath $150,000'),(3508,28,4,'2'),(3509,28,5,'1075 - Builder'),(3510,28,6,''),(3511,28,7,'2'),(3512,28,8,'2'),(3513,28,9,'L35'),(3514,28,10,''),(3515,28,11,''),(3516,28,12,''),(3517,28,13,''),(3518,28,14,''),(3519,28,15,''),(3520,28,16,''),(3521,28,17,'Great Room Fireplace'),(3522,28,18,''),(3523,28,19,'Gated Community'),(3524,28,20,''),(3525,28,21,''),(3526,28,22,'Community Pool'),(3527,28,23,''),(3528,28,24,''),(3553,33,1,'Biltmore Hillside CUSTOM HOME--------------------------------6537 North 29th Street'),(3554,33,2,'One of a kind custom home. Original owner requested  that a special designed home be created on a most spectacular mountain view lot. This floor plan was never offered by the Builder.'),(3555,33,3,'$1,499,000'),(3556,33,4,'1'),(3557,33,5,'3500'),(3558,33,6,''),(3559,33,7,'3'),(3560,33,8,'3'),(3561,33,9,'n35'),(3562,33,10,''),(3563,33,11,''),(3564,33,12,''),(3565,33,13,''),(3566,33,14,''),(3567,33,15,''),(3568,33,16,'Stone/Carpet'),(3569,33,17,'Hand fabricated stone 3 side'),(3570,33,18,'Spectacular Mountain Views'),(3571,33,19,''),(3572,33,20,''),(3573,33,21,''),(3574,33,22,'Water fall/Play'),(3575,33,23,'Concrete'),(3576,33,24,''),(3577,26,1,'Stetson Hills------------------------------------------25401 North 42nd Drive 85083'),(3578,26,2,'Beautifully upgraded home sitting on a premium prefered lot, in Stetson Hills, a picturesque community with 96 acres of sprawling parks, washes & common areas.\r\n\r\nPlease contact Leon Dang c(602) 571-6121'),(3579,26,3,'Offered at SOLD'),(3580,26,4,'1'),(3581,26,5,'2250'),(3582,26,6,'10000'),(3583,26,7,'4'),(3584,26,8,'2.5'),(3585,26,9,'202'),(3586,26,10,''),(3587,26,11,''),(3588,26,12,''),(3589,26,13,''),(3590,26,14,''),(3591,26,15,''),(3592,26,16,''),(3593,26,17,''),(3594,26,18,''),(3595,26,19,''),(3596,26,20,''),(3597,26,21,''),(3598,26,22,''),(3599,26,23,''),(3600,26,24,''),(3625,22,1,'Located in the heart of Sun City-----------10616 West Deanne Drive Sun City 85351'),(3626,22,2,'Thoughtfully redesigned & fully remodeled home seeks owner to complete it. Neutral toned home offers a large list of amenities which includes rich wood floors, a modern kitchen with updated corian counters/appliances highlighted w/cherry stained wood cabinets,& a floor plan that makes entertaining a cinch.  Custom paint on exterior/interior. New foam roof \'07. \r\n\r\nOpening the bright Arizona room has provided a great flow through the home and easy access to the built-in breakfast bar & nook. \r\n\r\nDon\'t miss the opportunity to own this very turnkey home.\r\n\r\nPlease call Debbie Liu at(602)840-1003.'),(3627,22,3,'Offered at SOLD'),(3628,22,4,'1'),(3629,22,5,'1758'),(3630,22,6,'2840'),(3631,22,7,'2'),(3632,22,8,'1.75'),(3633,22,9,'318'),(3634,22,10,''),(3635,22,11,''),(3636,22,12,''),(3637,22,13,''),(3638,22,14,''),(3639,22,15,''),(3640,22,16,'Manufactured wood, newer neutral carpet'),(3641,22,17,'None'),(3642,22,18,''),(3643,22,19,''),(3644,22,20,''),(3645,22,21,''),(3646,22,22,'Community'),(3647,22,23,'New foam roof in \'07, 20 year warranty'),(3648,22,24,''),(3673,24,1,'BILTMORE AREA RENOVATED LEASE                              4808 North 29th Place, Phoenix, 85016'),(3674,24,2,'Large family 4b/3b split floor plan. Kitchen-done, bathrooms-done, roof-done, Airconditioning-done... Tile flooring througout...Pool and landscaping cared for............Other amenities include a full laundry and a master suite sitting room with a separate exit. \r\n\r\nLocated in the middle of everything...shopping, sports, downtown, and restaurants. \r\n\r\n**Please call Listing Agent regarding pets.\r\nContact Leon Dang at (602) 571-6121'),(3675,24,3,'Leased'),(3676,24,4,'1'),(3677,24,5,'2172'),(3678,24,6,'16000'),(3679,24,7,'4'),(3680,24,8,'3'),(3681,24,9,'206'),(3682,24,10,'12 month minimum'),(3683,24,11,''),(3684,24,12,''),(3685,24,13,''),(3686,24,14,'Ranch'),(3687,24,15,''),(3688,24,16,'Tile Throughout'),(3689,24,17,'None'),(3690,24,18,''),(3691,24,19,''),(3692,24,20,''),(3693,24,21,''),(3694,24,22,'Private'),(3695,24,23,''),(3696,24,24,''),(3697,34,1,'5018 East Cambridge Ave'),(3698,34,2,'Thoughtful and well planned updates to this home will make every day living & entertaining a breeze. Step into the open living space highlighted by the oversize picture window and french doors that lead into your new office. Don\'t miss the modern touches that have been added in the kitchen and baths - tile, fixtures, granite, recessed lighting, etc. Your entertainers\' covered/misted patio awaits the next family BBQ and automation will make lighting and watering the beautifully landscaped front and back yards a snap. Hidden away in St Theresa Park...this is a Jewel that is tastefully done & well worth finding.'),(3699,34,3,'$245,000'),(3700,34,4,'1'),(3701,34,5,'1600'),(3702,34,6,''),(3703,34,7,'3'),(3704,34,8,'2'),(3705,34,9,''),(3706,34,10,''),(3707,34,11,''),(3708,34,12,''),(3709,34,13,''),(3710,34,14,''),(3711,34,15,''),(3712,34,16,''),(3713,34,17,''),(3714,34,18,''),(3715,34,19,''),(3716,34,20,''),(3717,34,21,''),(3718,34,22,''),(3719,34,23,''),(3720,34,24,''),(3721,35,1,'Biltmore Area Lease -------------------------------4822 North 29th Place'),(3722,35,2,'Beautiful home with modern conveniences and a perfect location. 2 bed/2 bath, 2300 sq ft of livable space sits on a lot just short of 1/2 acre. Impeccably maintained home will be ready to rent by August 20th. Satillo tile throughout. RARE 2 CAR GARAGE/circle driveway. White washed cabs w/corian counters. Front load washer/dryer incl. Huge master bedroom with custom walk-in closet...glass walled shower. Shutters throughout home. Partially furnished with an LG flat screen TV, dining table, and a few occasional tables (this not negotiable). Built-in bbq island sits on tiled patio. Regular landscaping, pest control, and irrigation included. Home has built-in alarm (BUT OPTIONAL SUBSCRIPTION TO BE PAID BY TENANT). Landlord requests NO CATS.'),(3723,35,3,'$1800/month'),(3724,35,4,''),(3725,35,5,'2300'),(3726,35,6,''),(3727,35,7,'2'),(3728,35,8,'2'),(3729,35,9,''),(3730,35,10,''),(3731,35,11,''),(3732,35,12,''),(3733,35,13,''),(3734,35,14,''),(3735,35,15,''),(3736,35,16,''),(3737,35,17,''),(3738,35,18,''),(3739,35,19,''),(3740,35,20,''),(3741,35,21,''),(3742,35,22,'No Pool'),(3743,35,23,''),(3744,35,24,''),(3769,30,1,'El Caro Condominiums ----------------------------------------------8214 N 21st Drive Unit A108, Phoenix, AZ  85021'),(3770,30,2,'Move-In Ready! This sharp unit shows well, tiled atrium invites you into meticulously maintained and cared for FURNISHED Corporate home. Upgrades incl Corian Countertops & sink, Tile backsplash, GE Appliances, 18x18 Tile flooring in kitchen, entry & laundry room. Cozy Eat-in kitchen, Fireplace in Living Room adding just the right amount of Charm. 1 Car Garage PLUS 1 covered spot for Parking. Community amenities include Clubhouse, 2 Pools, 1 Enclosed Heated Spa, Tennis, etc..PLUS Guest Quarters are Available upon request. Perfect for First-Time Buyer or Retirees. This Home has it all! Come see for yourself!Great Location.Mins to Downtown & Centrally located. Once again,Furniture & Fixtures included in this great price!\r\n\r\nCall Debbie 602-471-8308 for more information.'),(3771,30,3,'Excellent value at $95,000'),(3772,30,4,'1'),(3773,30,5,'1300'),(3774,30,6,'1974'),(3775,30,7,'2'),(3776,30,8,'1.75'),(3777,30,9,'M33'),(3778,30,10,''),(3779,30,11,''),(3780,30,12,''),(3781,30,13,''),(3782,30,14,'Condominium'),(3783,30,15,'6'),(3784,30,16,'18 x 18 tile in atrium, kitchen, hallways and laundry, neutral carpet in bedrooms'),(3785,30,17,'Wood burning, Ceramic Tile Backsplash'),(3786,30,18,'Located next to Greenbelt, Access to Shopping, Medical Facilities'),(3787,30,19,'Alarm System - Owned'),(3788,30,20,'Amenities include tennis courts'),(3789,30,21,''),(3790,30,22,'2 Community Pools'),(3791,30,23,'Built- Up, Tile'),(3792,30,24,'Community Heated Spa');

--
-- Table structure for table `propertyAttributeDef`
--

CREATE TABLE `propertyAttributeDef` (
  `k_propertyAttributeDef` int(11) NOT NULL AUTO_INCREMENT,
  `propertyType` varchar(50) NOT NULL DEFAULT '',
  `attributeSection` varchar(50) NOT NULL DEFAULT '',
  `displayOrder` int(11) NOT NULL DEFAULT '0',
  `name` text NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`k_propertyAttributeDef`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `propertyAttributeDef`
--

INSERT INTO `propertyAttributeDef` VALUES (1,'residential','other',1,'Property Address',''),(2,'residential','other',2,'Property Description',''),(3,'residential','other',3,'Price',''),(4,'residential','generalInfo',2,'Stories',''),(5,'residential','generalInfo',3,'APX SF',''),(6,'residential','generalInfo',4,'Lot Size',''),(7,'residential','generalInfo',5,'Bedrooms',''),(8,'residential','generalInfo',6,'Bathrooms',''),(9,'residential','generalInfo',7,'Area',''),(10,'residential','generalInfo',8,'Lease',''),(11,'residential','generalInfo',9,'Guest House',''),(12,'residential','generalInfo',10,'Maid\'s Bedrooms',''),(13,'residential','generalInfo',11,'Maid\'s Bathrooms',''),(14,'residential','propertyDetails',1,'Style',''),(15,'residential','propertyDetails',2,'Rooms',''),(16,'residential','propertyDetails',3,'Floor Cover',''),(17,'residential','propertyDetails',4,'Fireplace',''),(18,'residential','propertyDetails',5,'View',''),(19,'residential','propertyDetails',6,'Security',''),(20,'residential','propertyDetails',7,'Tennis',''),(21,'residential','propertyDetails',8,'Waterfront',''),(22,'residential','propertyDetails',9,'Pool',''),(23,'residential','propertyDetails',10,'Roof Type',''),(24,'residential','propertyDetails',11,'Spa','');

--
-- Table structure for table `userRole`
--

CREATE TABLE `userRole` (
  `username` varchar(50) NOT NULL DEFAULT '',
  `role` varchar(50) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userRole`
--

INSERT INTO `userRole` VALUES ('mlbaker','admin'),('perryestates','admin'),('anders','admin');

--
-- Dumping events for database 'perryestatepro'
--

--
-- Dumping routines for database 'perryestatepro'
--


