Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
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)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'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','211295697','1665222328','211295697','2022-10-08T03:06:41.493','74125868','Adrian Wiltz','Adrian Wiltz Properties','','','29.534434','-95.719391','16','77469','5','295000.00','Active','Atwood Ridge','9222','Lane','Richmond','2','0','3','1711','Single-Family','Beautiful Beazer Home Baxter Plan Home Movie In Ready All Appliances Included! This home features Granite Counter Tops, Beautiful Back splash, 42\" Cabinets, Under Counter Fluorescent Lights, Under mount Kitchen Sink, Tile and Carpet Flooring, Both Executive Master Bath and 2nd Bath with Granite Counters and Tile, Walk-in Closets, High Ceilings, All Kitchen Appliances Black, Covered Porch, Covered Patio, Wood Privacy Fencing, Auto Garage Opener W/2 Remotes, GFI Outlet in the Garage, Washer/Dryer Included!','0.1515','30','Beazer','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Fort Bend South/Richmond','Central Gas','1','BONBROOK PLANTATION NORTH SEC 6, BLOCK 1, LOT 6','Subdivision Lot','6600','Appraisal District','','700','0','','','Freestanding Oven,Gas Oven','0','','','','','Composition','33 - Lamar Consolidated','CARTER ELEMENTARY SCHOOL','GEORGE RANCH HIGH SCHOOL','RYON/READING JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Bonbrook Plantation North Sec 6','5503','2.6948','Water District','2014','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T03:31:22.387' ,`MLSNumber` = '5992660' ,`ListAgentFullName` = 'Jessica Phillips' ,`ListOfficeName` = 'Red Shoe Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.578599' ,`Longitude` = '-95.428179' ,`PhotoCount` = '28' ,`PostalCode` = '77584' ,`RoomCount` = '8' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Emerald Trace' ,`StreetNumber` = '1831' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3233' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome! Gorgeous & gently lived in home that is perfect for entertaining or simply living. Located in the desired and established community of Shadow Creek Ranch. This home features a stunning entry way & foyer w/a 14’ ceiling. At the front of the house is a formal dining room & cozy study adorned w/ beautiful French doors. Kitchen is complete w/a walk-in pantry, 2 large bars which allow for additional seating, granite countertops, tile backsplash, island, gas cook top and plenty of storage & counter space. Open to the breakfast nook and living area, a wall lined w/large windows allow for lots of natural light. Two secondary bedrooms, each w/walk-in closets. A half bath for guests. Primary suite features dual vanities, separate glass enclosed shower, garden tub & bonus space that can be utilized as a customizable walk-in closet, second office, man cave or lady\'s lair (See photos for seller\'s prior customization). The possibilities are endless! Schedule your private tour today!' ,`Acres` = '0.1719' ,`Area` = '38' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-63B, BLOCK 1, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7487' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf-63b' ,`TaxAmount` = '11276' ,`TaxRate` = '3.2123' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665222328' WHERE `Matrix_Unique_ID` = '211902329' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T02:17:34.157' ,`MLSNumber` = '45047515' ,`ListAgentFullName` = 'Barbara DiBlasi Marlin' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.657223' ,`Longitude` = '-95.593906' ,`PhotoCount` = '32' ,`PostalCode` = '77477' ,`RoomCount` = '7' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadowhollow' ,`StreetNumber` = '12214' ,`StreetSuffix` = 'Drive' ,`City` = 'Meadows Place' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1914' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic location in the unique municipality of The City of Meadows Place. This lovingly updated\r\none story home features a huge Family room with vaulted ceiling. Kitchen has been redesigned and is\r\n open to the entertainment areas. You will enjoy the warmth of the Cast stone gas powered fireplace\r\n and fire glass. Vinyl plank flooring and tile throughout the house. Contemporary lighting fixtures\r\n accent the kitchen, dining room and family room. The primary bedroom is large and is located in\r\nthe back of the home for privacy. Two additional bedrooms, a hall bath and a cedar closet complete\r\nthe east side of the house. Utility room is inside near the Primary Bedroom. The City of Meadows\r\nPlace has always been considered a great neighborhood which includes community parks, police\r\ndepartment, and its own elementary school. Now an explosion of restaurants and entertainment\r\noptions have elevated its popularity. Easy access to commuter roads.' ,`Acres` = '0.1625' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'THE MEADOWS SEC 4, BLOCK 31, LOT 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7079' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MEADOWS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'The Meadows' ,`TaxAmount` = '4995' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665222328' WHERE `Matrix_Unique_ID` = '212817220' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T03:07:01.103' ,`MLSNumber` = '50606315' ,`ListAgentFullName` = 'Jonathan Licea Rojas' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.040025' ,`Longitude` = '-95.331085' ,`PhotoCount` = '24' ,`PostalCode` = '77373' ,`RoomCount` = '5' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Bridgegate' ,`StreetNumber` = '6502' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1384' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for an adorable home, then look no further. Featuring well-maintained 1 story , 3 bedrooms, 2 bath home that has a large living room with cathedral ceiling and cozy wood burning fireplace. Kitchen has plenty of counter space with breakfast bar, freshly painted white cabinets and stainless steel appliances. The secondary bedroom has good size closets and has easy access to the secondary bathroom. Freshly painted inside and outside. Recent water heater, new light fixtures and carpet in all 3 bedrooms. Lots of windows bringing in natural light with a great backyard. Did Not Flood!! Don\'t miss the opportunity to give you a place to call HOME.' ,`Acres` = '0.1377' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 29 GREENGATE PLACE SEC 5 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '315' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greengate Place Sec 05 R/P' ,`TaxAmount` = '3980' ,`TaxRate` = '2.6867' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665222329' WHERE `Matrix_Unique_ID` = '213111292' --> Updated record success
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','213172171','1665222329','213172171','2022-10-08T03:34:56.493','10083955','Sandy Perez','RE/MAX Eastside','','','29.744746','-95.242249','17','77547','2','199999.00','Active','17th','2009','Street','Galena Park','2','0','3','1606','Single-Family','Welcome home to this charming home. Well maintained by previous owners. Host your holidays in the formal dining room. Custom kitchen cabinets with granite counter tops and kitchen bar as well. Split floor plan. Primary bedroom has it\'s own private bathroom and walk-in closet. This house boasts ceramic tile throughout. New roof installed in 2022. Home has been freshly painted in and out. Large double driveway and french doors that lead out to carport perfect for bbq\'s. Enjoy your fenced private backyard with separate side entrance. Appliance package included, stainless steel refrigerator, stove with double oven, washer & dryer. Move in ready! Home is equipped with Nest package available for purchase: 5 outdoor security cameras with motion detection, doorbell with AC converter motion detection & facial recognition capabilities, floodlight, smoke alarm, thermostat and temperature sensor for an additional room, August wifi smart door lock. Don\'t miss out. This one will not last long!','0.1419','2','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','','','','North Channel','Central Gas','0','LT 558 WOODLAND SEC 5','Cul-De-Sac','6181','Other','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','21 - Galena Park','MACARTHUR ELEMENTARY SCHOOL','GALENA PARK HIGH SCHOOL','GALENA PARK MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front','Appraisal','1','Other Style','Woodland Sec 05','2318','3.22','Public Water','1945','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T02:18:19.970' ,`MLSNumber` = '20731245' ,`ListAgentFullName` = 'Ariana Lopez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.846734' ,`Longitude` = '-95.792068' ,`PhotoCount` = '23' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '389999.00' ,`Status` = 'Active' ,`StreetName` = 'Brewcastle' ,`StreetNumber` = '5003' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2473' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing 4 bedrooms, 3.1 baths two story home located on a large corner lot in King Crossing, Katy. Upon entering is a space originally design as an office/study space that the current home owners have decide to use as their formal dining area. The kitchen features stainless steel appliances, designer backsplash, recessed lighting, great size island with a set of pendant above and breakfast bar followed by a large living area. This property features beautiful ceramic wood tile all through the first floor. \r\n\r\nThe primary suite is located on the first floor offering a very generous size soaking tub along with a standing shower, dual sink vanity and walk in closet. Large game room to be found on the second floor and secondary bedrooms. \r\n\r\nMinutes from 99 grand parkway, Legacy stadium, Water parks, grocery stores, Katy mills mall, Katy ISD elementary school and high school.' ,`Acres` = '0.1476' ,`Area` = '25' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 4 KING CROSSING SEC 11' ,`LotDesciption` = 'Corner' ,`LotSize` = '6430' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Photos/No Videos,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'King Xing Sec 11' ,`TaxAmount` = '9142' ,`TaxRate` = '3.4768' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665222329' WHERE `Matrix_Unique_ID` = '213350801' --> Updated record success
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','213436079','1665222329','213436079','2022-10-08T02:42:10.070','43947193','Dena Day','RE/MAX Fine Properties','','','29.504714','-95.428822','45','77583','8','379900.00','Active','Tara Oaks','5411','Court','Rosharon','2','1','3','2534','Single-Family','Looking for the perfect home, well bring your buyer to this gorgeous one story located in Lakes of Savannah. Dream home waiting for a new owner. Large room sizes and plenty of space. This home features 3 large bedrooms, 2 full and 1 half bath, high ceilings and is in mint condition. These owners truly loved their home and you can tell from the minute you walk in, all the care and love put into this home. If you are looking for move in ready, this home is for you.','0.1669','5','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Alvin North','Central Gas','1','SAVANNAH BEND SEC 2 (A0562 H T & B) BLK 2 LOT 6','Subdivision Lot','7270','Appraisal District','','670','0','','2','Gas Oven','0','','','Gas Range','','Composition','3 - Alvin','SAVANNAH LAKES ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','MANVEL JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card','Appraisal District','1','Traditional','LAKES OF SAVANNAH','8414','3.1908','Public Sewer,Public Water,Water District','2013','Appraisal District'); --> New record created successfully
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','213451744','1665222329','213451744','2022-10-08T03:26:18.173','21645117','Liliana Valencia','HOUSTON TOP REALTY','','','29.719245','-95.618290','20','77082','4','230000.00','Active','Ensley Wood','13110','Drive','Houston','2','0','4','1567','Single-Family','Won\'t last long!!!!\r\ncame and take a look at this property nice and quiet neighborhood.','0.1433','28','','','','','Sellers Disclosure','','','1','Alief','Central Electric','1','LT 43 BLK 2 PARKRIDGE SEC 1','Cleared','6240','Appraisal District','','450','0','','2','','0','','','','','Composition','2 - Alief','HEFLIN ELEMENTARY SCHOOL','AISD DRAW','O\'DONNELL MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Parkridge Sec 01','3543','2.4411','Public Sewer,Public Water','1979','Appraisal District'); --> New record created successfully