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-11-29T08:08:21.243' ,`MLSNumber` = '65627659' ,`ListAgentFullName` = 'John Mai' ,`ListOfficeName` = 'Altus Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.132990' ,`Longitude` = '-95.058215' ,`PhotoCount` = '24' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '819000.00' ,`Status` = 'Active' ,`StreetName` = 'Miramar' ,`StreetNumber` = '22903' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3214' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Customer built with open premium floor plan and Lots of personal upgrades! Vacation Home!!!Private walking staircase to main floor. Two lots combine premium existing lot!! The house is fully furnished with all appliances, TV, and furnitures. Huge master bedroom with private balcony and wood fired place. 14 feet above ground, exquisite cargo lift and spiral staircase to go up first floor. Custom cat5 every room, Pre-wired entertainment in living room and security throughout house. premium trex decking throughout house to view beach side and bay side. Subdivision has private public pool, fishing, and outdoor boat ramp! Soaring crown molding ceiling with chandelier and custom granite counters, water softener, 5 tons energy efficiency A/C. Private security surround house included. Agent is related owner. Ready to move in !!' ,`Acres` = '0.2838' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOTS 140 & 141 (141-0) TERRAMAR BE' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '12362' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Terramar Sec 7' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675085278' WHERE `Matrix_Unique_ID` = '211236706'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T08:50:56.653' ,`MLSNumber` = '80924885' ,`ListAgentFullName` = 'Kimberly Capps-Rumfield' ,`ListOfficeName` = 'Keller Williams Realty-FM' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.417900' ,`Longitude` = '-96.827082' ,`PhotoCount` = '33' ,`PostalCode` = '75165' ,`RoomCount` = '7' ,`ListPrice` = '338000.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Roan' ,`StreetNumber` = '204' ,`StreetSuffix` = 'Drive' ,`City` = 'Waxahachie' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2297' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '$2000 offered by sellers to help buyers with interest rate buydown, fresh paint or whatever they desire. This great three bedroom two bath is located in a great neighborhood and is close to everything. All bedrooms are upstairs with a large open living area. Downstairs features a space for either formal dining or study with an open floor plan from the living room to the kitchen. Waxahachie is a growing community but still holding on to that small town charm.' ,`Acres` = '0.18' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 2 BLK C MUSTANG CREEK PH I 0.18 AC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7841' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1014 - Waxahachie' ,`SchoolElementary` = 'SHACKELFORD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WAXAHACHIE HIGH SCHOOL' ,`SchoolMiddle` = 'EDDIE FINLEY SR SEVENTH GRADE CENTER' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mustang Creek Ph I' ,`TaxAmount` = '5006' ,`TaxRate` = '2.3435' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085278' WHERE `Matrix_Unique_ID` = '211370805'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T08:47:52.813' ,`MLSNumber` = '77137132' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.452055' ,`Longitude` = '-95.298523' ,`PhotoCount` = '12' ,`PostalCode` = '77511' ,`RoomCount` = '6' ,`ListPrice` = '322990.00' ,`Status` = 'Active' ,`StreetName` = 'Riesling' ,`StreetNumber` = '414' ,`StreetSuffix` = 'Drive' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1857' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom and 2 baths, three car garage one story home with granite kitchen countertops and oversized upper kitchen cabinets awesome location. exceptional design elements, high ceilings,  fantastic curb appeal with rear covered patio with no back neighbors. Alvin ISD, close to medical centers, and great dining, and shopping centers.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23, Block 1, Section 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HOOD-CASE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Accompany,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Martha\'s Vineyard' ,`TaxAmount` = '' ,`TaxRate` = '3.74' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675085278' WHERE `Matrix_Unique_ID` = '211505204'  --> 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','215131901','1675085279','215131901','2022-11-29T08:03:28.113','14508957','Connie Vallone','Park West Real Estate Inc','','','29.643352','-95.123864','45','77505','18','499000.00','Active','Timberline','7418','Drive','Pasadena','3','1','6','3985','Single-Family','Welcome home to this big, beautiful home in Village Grove East.  6 full bedrooms plus home office, huge game room, dining, and extra space upstairs.  Large primary suite downstairs with plenty of room for a sitting area.  Primary bath with jetted tub, separate shower and HUGE walk-in closet. Covered patio over looks sparkling pool with waterfall is nice & quiet with no back neighbors.  3 car garage and extra wide driveway.   Island Kitchen with granite tops, gas range remodeled in 2016 opens to living area & breakfast with views to the backyard oasis.  All rooms with generous closets this home has tons of storage.  No flooding per seller.  Tankless water heater 2019, full system AC replacement downstairs 2022 upstairs 2012.  Pool pump 2020.  Beautiful front door with wrought iron inset 2022 & Roof 10/2022.','0.2075','6','Brighton Homes','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Pasadena','Central Gas,Zoned','1','LT 8 BLK 2 VILLAGE GROVE EAST SEC 4','Greenbelt,Subdivision Lot','9040','Appraisal District','','525','0','','3','Gas Oven','1','Gunite,Heated,In Ground','','Gas Range','','Composition','16 - Deer Park','JP DABBS ELEMENTARY SCHOOL','DEER PARK HIGH SCHOOL','FAIRMONT JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox','Appraisal','2','Traditional','Village Grove East Sec 04','10206','2.8798','Public Sewer,Public Water','2001','Appraisal');  --> 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','215151197','1675085279','215151197','2022-11-29T07:08:36.017','33180654','Cyndi Kornegay','Gatehouse Properties','','','29.978997','-95.740845','6','77433','10','549994.00','Active','Via Toluca','13831','Trail','Cypress','3','0','4','2747','Single-Family','This gorgeous one-story home features 4 bedrooms, 3 bathrooms, a spacious study, and a 3-car garage. The open concept kitchen features modern appliances with tons of storage and a spacious island overlooking the family room and casual dining room. The separate game room is a great space for kids to play and lounge while you retreat to your luxurious primary suite, which features an oversized walk-in closet, shower with seat, and a garden tub. Enjoy spending your days in the backyard with an extensive covered patio. Don’t miss out on this incredible home!','','25','Coventry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','','0','Cypress South','Central Gas','1','Lot 21 Block 1','Greenbelt','6426','Survey','','1000','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','AULT ELEMENTARY SCHOOL','BRIDGELAND HIGH SCHOOL','SALYARDS MIDDLE SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','1','Traditional','Dunham Pointe','','3.4','Water District','2022','Builder');  --> 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','215152063','1675085279','215152063','2022-11-29T08:38:26.207','55921003','Wen-Ching Muzzarelli','JLA Realty','','','30.078175','-95.173867','38','77345','10','325000.00','Active','Windy Gorge','2914','Court','Houston','2','0','3','2312','Single-Family','Lovely single-story home located on a cul-de-sac in upfront Woodstream in Kingwood.  Home features an open floor plan with 3 bedrooms, formal dining, and a study (or 4th bedroom).  Unique architectural details including archways, tray ceiling, crown molding and much more.  The living room features a gas-log fireplace and plenty of windows to bring in natural light.  Kitchen has granite countertops and is open to living room.  Spacious primary features an en-suite bathroom with dual vanities, garden soaking bathtub & separate shower, and large walk-in closet. Two additional secondary bedrooms and a fabulous Jack-N-Jill bath to share.  Freshly painted inside. Never flooded.','0.2202','32','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Kingwood East','Central Gas','1','LT 20 BLK 3 MILLS CREEK VLG SEC 1 PAR R/P','Corner,Cul-De-Sac,In Golf Course Community','9592','Appraisal District','','500','0','','2','Single Oven','0','','','Gas Cooktop','','Composition','29 - Humble','SHADOW FOREST ELEMENTARY SCHOOL','KINGWOOD HIGH SCHOOL','RIVERWOOD MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Woodstream','6437','2.5839','Public Sewer,Public Water','1995','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','215153192','1675085279','215153192','2022-11-29T08:55:17.213','35347830','Justin Dickey','Keller Williams Professionals','','','29.832916','-95.855864','32','77493','8','478670.00','Active','Acapulco Mist','5334','Drive','Katy','3','1','4','2922','Single-Family','This gorgeous Colina Home has amazing offerings! When you walk through the front door you will feel right at home. This home offers 4bedrooms,3.5bathrooms, dining & 3car garage! The living room, kitchen, area are open to each other with high ceilings. The kitchen features oversized island with seating,42\" cabinetry, & spacious walk-in pantry. The primary bedroom is tucked away in the back of home with a spacious en suite bathroom & walk in closet. There is a Huge covered back patio great for grilling and fun, Lakes & Parks. Crystal Lagoon coming soon!','','25','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Katy - Old Towne','Central Gas','1','Lot 7 Block 4 Sec 40','Subdivision Lot','7500','Survey','','1300','1','To Be Built/Under Construction','3','Gas Oven','0','','','Gas Cooktop','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Accompany,Leave Business Card','Builder','2','Contemporary/Modern','Sunterra','','','Public Sewer,Public Water','2023','Builder');  --> New record created successfully<br />