Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T03:23:48.063' ,`MLSNumber` = '5842093' ,`ListAgentFullName` = 'Kiki Baker' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.658434' ,`Longitude` = '-95.455456' ,`PhotoCount` = '18' ,`PostalCode` = '77035' ,`RoomCount` = '3' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Kingfisher' ,`StreetNumber` = '4621' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1461' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this remodeled Willowbrook home on Kingfisher with a flexible wide open space to welcome you in. A completely upgraded kitchen with gracious dining area overlooking the backyard. In the backyard you will find a covered patio with plenty of room for seating and plenty of yard for playing. The play structure can stay or go per Buyer preference (condition cannot be guaranteed). The primary suite is in the rear of the home, also completely updated with designer tile. Two more bedrooms in the home share a hall bath as well. Every appointment must be with a Realtor! If you do not have an agent helping in your search, we are happy to make a match. Flood Zone X (lowest risk) and low tax rate.' ,`Acres` = '0.1728' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 16 WILLOWBROOK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7525' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Willowbrook' ,`TaxAmount` = '5809' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664533008' WHERE `Matrix_Unique_ID` = '211001515'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T02:11:44.977' ,`MLSNumber` = '97339020' ,`ListAgentFullName` = 'Jasmyne Castillo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.145819' ,`Longitude` = '-95.413265' ,`PhotoCount` = '25' ,`PostalCode` = '77385' ,`RoomCount` = '5' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Dorrington Estates' ,`StreetNumber` = '23980' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3154' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home offers 5-6 bedrooms with the owner\'s suite on the first floor. The sixth bedroom can easily turn into any luxury amenity of your liking. We are offering you top-notch stainless steel appliances included in the sale price. There is a theater room located on the first floor perfect for family time. This home also offers a ground pool with lounge space and a wet bar. The home is still occupied by the owner so please schedule showings 24 hours in advance.' ,`Acres` = '0.2166' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'IMPERIAL OAKS ESTATES 02, BLOCK 2, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9435' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '785' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks Estates 02' ,`TaxAmount` = '7839' ,`TaxRate` = '2.4827' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664533008' WHERE `Matrix_Unique_ID` = '212383824'  --> Updated record success<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212661706','1664533009','212661706','2022-09-30T03:05:39.303','64239367','Jacqueline Dang','Texas United Realty','','','29.679934','-95.598865','18','77099','5','310000.00','Active','MAGNOLIA CANYON','12534','Canyon','Houston','3','1','5','2944','Single-Family','NO FLOODING IN HURRICANE HARVEY!!! CORNER HOUSE WITH 5 OVERSIZED BEDROOMS AND 3.5 BATHS.  MASTER BEDROOM, FORMAL LIVING ROOM DOWNSTAIRS WITH KITCHEN INCLUDING BREAKFAST BAR ON THE TILE FLOOR. SPACIOUS GAMEROOM UPSTAIRS BETWEEN THE 4 BEDROOMS WITH 2 FULL BATHS ON THE LAMINATE FLOOR. A SITTING AREA IN THE SECOND BATHROOM USED AS A VANITY IS CONVENIENT FOR THE SECOND AND THE THIRD BEDROOM .\r\n\r\nTHIS HOUSE IS FEW MINUTES TO SCHOOLS, RESTAURANTS AND SUPERMARKETS. EASY ACCESS TO BELTWAY 8, WEST PARK TOLLWAY AND FREEWAY 59.','0.1447','28','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Alief','Central Gas','1','LT 12 BLK 2 REGENTS VILLAGE','Corner','6301','Appraisal District','','372','0','','2','Gas Oven','0','','','Gas Range','','Composition','2 - Alief','ALEXANDER ELEMENTARY SCHOOL (ALIEF)','AISD DRAW','HOLUB MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Traditional','REGENTS VILLAGE','5232','2.7537','Public Sewer,Public Water','2006','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T03:31:34.577' ,`MLSNumber` = '75309976' ,`ListAgentFullName` = 'Kiki Baker' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.669206' ,`Longitude` = '-95.740429' ,`PhotoCount` = '24' ,`PostalCode` = '77407' ,`RoomCount` = '7' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Fieldstone' ,`StreetNumber` = '5330' ,`StreetSuffix` = 'Terrace' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2239' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FIRST SHOWINGS AT OPEN HOUSE SUNDAY. Seller occupied and work from home so please request future private appointments with plenty of notice and keep all appointments on time. A rare find — four bedrooms on a single story in Fieldstone. Former model home with only one other in the subdivision. Pride of ownership shows! Look for thoughtful touches and upgrades, including custom holiday lighting package to stay. Great neighbors, convenient location. Moments to groceries, dining, freeways; zoned to Fort Bend acclaimed schools including Travis High. ASK YOUR AGENT for the full feature sheet to view the entire brag list! Please note: Live Camera Surveillance.' ,`Acres` = '0.1766' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FIELDSTONE SEC 5, BLOCK 3, LOT 42' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7691' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '687' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OAKLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fieldstone' ,`TaxAmount` = '7026' ,`TaxRate` = '2.8429' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664533009' WHERE `Matrix_Unique_ID` = '212796645'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T02:09:10.880' ,`MLSNumber` = '57578200' ,`ListAgentFullName` = 'Linh Pham' ,`ListOfficeName` = 'V-Pro Realtors' ,`SellingAgentFullName` = 'Claudine Blackshire' ,`SellingOfficeName` = 'RE/MAX East' ,`Latitude` = '29.805072' ,`Longitude` = '-95.145422' ,`PhotoCount` = '25' ,`PostalCode` = '77530' ,`RoomCount` = '6' ,`ListPrice` = '225000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Peachmeadow' ,`StreetNumber` = '15211' ,`StreetSuffix` = 'Lane' ,`City` = 'Channelview' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1542' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1 story house with NEW FLOOR of TILES and LAMINATE WOODS, NEW PAINT, NEW WINDOW TREATMENT, NEW light fixture in Dining Room, NEW REMODELED OVERSIZED SHOWER in second BATHROOM. A/C UNIT is 2 years of age. Stainless Steel microwave, Stainless Steel oven and range/stove. Granite countertops in kitchen and bathrooms.' ,`Acres` = '0.132' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'E 25 FT OF LT 30 & W 25 FT OF LT 31 BLK 1 STERLING GREEN SEC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '270' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'Brown Elementary School (Channelview)' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'AGUIRRE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Green Sec 09' ,`TaxAmount` = '4264' ,`TaxRate` = '2.518' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664533009' WHERE `Matrix_Unique_ID` = '212803052'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-30T02:40:58.960' ,`MLSNumber` = '94793769' ,`ListAgentFullName` = 'Sharlene Mercier' ,`ListOfficeName` = 'Soho Realty & Mtg Lending, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.507410' ,`Longitude` = '-95.411317' ,`PhotoCount` = '32' ,`PostalCode` = '77578' ,`RoomCount` = '4' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Desert Willow' ,`StreetNumber` = '9' ,`StreetSuffix` = 'Court' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2513' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.132' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RODEO PALMS THE COLONY SEC 4 (A0299 HT&BRR)(MANVEL) BLK 1 LO' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rodeo Palms, The Colony Sec 4' ,`TaxAmount` = '9284' ,`TaxRate` = '3.6694' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664533009' WHERE `Matrix_Unique_ID` = '213038215'  --> Updated record success<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213119585','1664533009','213119585','2022-09-30T02:07:56.093','86140820','Joseph Landes','Directed Realty LLC','','','29.514296','-95.039858','50','77573','9','390000.00','Active','Dawn Sky','863','Lane','League City','2','1','4','2326','Single-Family','South Shore Harbor house can be yours if you hurry!! This Perry Home located on a quiet and friendly cul-de-sac has lots to offer. It comes with 4 beds, 2.5 baths, 2 car oversized garage, formal dining room, breakfast room, family room, large laundry room and upstairs gameroom. The first floor will capture your attention with towering high ceilings and large windows with views of the back patio that allow a lot of natural light. The kitchen offers lots of cabinet and counter space and a large pantry, plus easy flow from living to breakfast to dining and entryway. The primary room downstairs comes complete with an oversized closet and a primary bath coupled with a toilet room, his/her sinks, jetted tub and stand-up shower. The family can enjoy three large bedrooms and a gameroom upstairs. Don’t miss any memories in this large backyard with your own tiki-style deck, great for entertaining, with room left for a pool. Also, AWESOME CCISD Schools. This is an enchanting home. DON\'T DELAY!!','0.19','33','Perry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','','','League City','Central Gas','1','SOUTH SHORE HARBOUR SEC SF 50-4 (2005) ABST 18, BLOCK 2, LOT','Cul-De-Sac,In Golf Course Community','8411','Appraisal District','','489','0','','2','Convection Oven','0','','','Electric Range','','Composition','9 - Clear Creek','HYDE ELEMENTARY SCHOOL','CLEAR FALLS HIGH SCHOOL','BAYSIDE INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','South Shore Harbour','7396','2.4521','Public Sewer,Public Water,Water District','2006','Appraisal District');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213134062','1664533009','213134062','2022-09-30T02:01:14.697','67729298','Linh Pham','V-Pro Realtors','','','29.864004','-95.622250','23','77041','8','275000.00','Active','Pago','6310','','Houston','2','0','4','1914','Single-Family','BEAUTIFUL ONE-STORY 3/4 BEDROOMS with DINING ROOM, OFFICE, BREAKFAST ROOM. Primary Bathroom has DOUBLE SINKS, BATHTUB, SHOWER.  Granite counter tops in ALL bathrooms. Beautiful tiles throughout the floors. High ceiling. CEILING FANS in ALL bedrooms. Beautiful DEN room with double French doors that can turn into a bedroom. Formal Dining Room can turn into a game room or extra office. Nice COVERED PATIO. Easy access to Hwy6, 290, Beltway 8, and I10. Convenient to all the major arteries, shopping and restaurants. Award winning Cy-Fair ISD and great Catholic schools. Nice neighborhood with large PLAYGROUND and Subdivision beautiful swimming pool. Room measurements are approximated. VARIOUS FIXTURES Upgrade. Good ROOF with Warranty REPLACED 2020, FURNACE REPLACED 2018. NO CARPET. ALL TILES FLOOR.','','8','Kimball Hills Home','','Electric Dryer Connections,Gas Dryer Connections','','No Disclosures,Sellers Disclosure','1','Gas Connections','1','Eldridge North','Central Gas','1','LT 32 BLK 1','Subdivision Lot','6325','Appraisal District','','370','0','','2','Electric Oven','0','','','Electric Range','','Composition','13 - Cypress-Fairbanks','LEE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS FALLS HIGH SCHOOL','TRUITT MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Concord Bridge','4614','','Public Sewer,Public Water','1996','Appraisal District');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213139822','1664533009','213139822','2022-09-30T02:58:18.173','60502988','Ashley Martins','Martins Realty','','','29.696613','-95.768943','50','77407','11','409990.00','Active','Lakewind Park','23503','Lane','Richmond','2','1','4','3051','Single-Family','Take a closer look at this deceptively sizeable 1.5 story home with Lakefront and two beautiful fountains in the back.  Stone elevation upfront with side loaded garage.  Plush greenery yard with two trees.  Great backyard with covered patio for the cool summer lake breeze.  Step into a well appointed kitchen with upgraded appliances, with an island.  \r\n\r\nAll spaces are quite big, but no disappointment in the oversized master bedroom with it\'s own living space for a couch and TV, or private work area.  Master closet is huge.  The gameroom upstairs can be used as 5th bedroom.  The metal fence in the backyard allows for unobstructed view of a gorgeous lake.  You have arrived home at last.','0.1865','37','First Texas Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Fort Bend County North/Richmond','Central Gas','1','PARKWAY LAKES SEC 1, BLOCK 2, LOT 32','Subdivision Lot,Water View,Waterfront','8125','Appraisal District','','950','0','','2','','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','HUBENAK ELEMENTARY SCHOOL','FOSTER HIGH SCHOOL','WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1.5','Contemporary/Modern,Ranch','Parkway Lakes Sec 1','7879','2.7615','Public Sewer,Public Water','2004','Appraisal District');  --> New record created successfully<br />