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'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T00:08:42.773' ,`MLSNumber` = '64596991' ,`ListAgentFullName` = 'Angela DeDear' ,`ListOfficeName` = 'Designed Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.683443' ,`Longitude` = '-95.030990' ,`PhotoCount` = '21' ,`PostalCode` = '77351' ,`RoomCount` = '2' ,`ListPrice` = '137000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodmont' ,`StreetNumber` = '129' ,`StreetSuffix` = 'Circle' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is your chance to be close to the water and enjoy everything beautiful Lake Livingston has to offer. 2 Full bedrooms and 2 full baths. This mobile home sits on 2 lots for a total of .59 of an acre. The home is an open concept , family room with adjoining kitchen/dining and breakfast bar. Just across the street from waterfront access to Lake Livingston! Private boat ramp and pavilion. A wonderful place to spend your weekends or would make a great rental. Book your showing now' ,`Acres` = '0.4396' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'OAK TERRACE ESTATES SECTION 11 LOT 24 & 23' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '19306' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '75' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Terrace Estates Sec 11' ,`TaxAmount` = '36' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096792' WHERE `Matrix_Unique_ID` = '211024996' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T23:21:51.627' ,`MLSNumber` = '91924842' ,`ListAgentFullName` = 'Vera Mitrofanova' ,`ListOfficeName` = 'VAM Real Estate Solutions' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.760756' ,`Longitude` = '-95.763894' ,`PhotoCount` = '39' ,`PostalCode` = '77450' ,`RoomCount` = '9' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Lamplight Trail' ,`StreetNumber` = '1427' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2378' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hidden gem of Cinco Ranch! Beautiful spacious corner house with high vaulted ceiling with tons of natural light, formal living room with fireplace to cozy up during cold days, huge den with dining area. 4 bedrooms, the 4th bedroom can be used as an office, if need be. Freshly painted throughout all house. Only the primary bedroom has recently installed carpet, the rest of the house has hard flooring. The primary bathroom has shower, tub and double sinks. The kitchen has a plethora of cabinets and storage. Bathrooms and breakfast area have recent light fixtures. The side street does not go through. Perfect for extra parking or extra play areas for kids. A good sized backyard is ready for family gatherings and barbeque. Enjoy recreation amenities including multiple parks, tennis courts, swimming pools of Cinco Ranch. Welcome Home!!!' ,`Acres` = '0.1765' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 4 CINCO RANCH MEADOW PLACE SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7688' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1115' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'FIELDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch Meadow Place Sec 0' ,`TaxAmount` = '6983' ,`TaxRate` = '2.6083' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096792' WHERE `Matrix_Unique_ID` = '213578923' --> 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','214583641','1675096792','214583641','2022-12-28T23:04:40.667','85874953','Harley Hedgpeth','Coldwell Banker Realty','','','29.823400','-95.444112','24','77018','6','465000.00','Active','Chippendale','1741','Road','Houston','2','0','3','1400','Single-Family','Welcome to Oak Forest East. Great Location and highly desirable, close to Spring Branch, The Heights and Galleria. This charming home has recently updated baths and kitchen with a split floor plan for privacy or roommate situation. The spacious backyard has large patio for entertaining guests or relaxing and hosting that special Bar-B-Que. The home is furnished with all appliances, new gas range with air fryer built in, washer, dryer and microwave The new kitchen refrigerator is excluded but can be purchased from the Seller. Gas Cooking and Central Heating as well as Central AC were recently replace.. \r\n\r\n****** PLEASE INDEPENDENTLY VERIFY ALL ROOM DIMENSIONS, TAXES AND SCHOOLS**********','0.1653','9','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Oak Forest East Area','Central Gas','0','LT 48 BLK 49 OAK FOREST SEC 6','Subdivision Lot','7200','Appraisal District','','','0','','0','Convection Oven,Electric Oven,Single Oven','0','','','Freestanding Range,Gas Range','','Composition','27 - Houston','STEVENS ELEMENTARY SCHOOL','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox','Appraisal District','1','Ranch,Traditional','Oak Forest Sec 06','','','Public Sewer,Public Water','1949','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','215522808','1675096792','215522808','2022-12-28T23:37:28.753','54271022','Rose Searcy','Anchor Realty Assoc., Inc.','','','29.767947','-94.984369','23','77521','8','359500.00','Active','Waterwood','4218','Drive','Baytown','3','1','3','3051','Single-Family','COME AND SEE THIS STUNNING 4 SIDED BRICK ONE STORY HOUSE.STEP INSIDE AND FALL IN LOVE WITH THIS 3/4 BEDROOMS HOUSE ,HIGH CEILINGS,WOOD FLOORING ,3.5 BATHS AND OPEN FLOOR PLAN ARE JUST A FEW FEATURES OF THIS BEAUTEOUS HOME.A PERFECT HOME TO HAVE THEIR OWN BATHROOM.SELLER JUST PAINT THE ENTIRE INSIDE OF THE HOUSE ,NEW WATER HEATER,AND SPENT HUGE AMOUNT OF DOLLARS FOR REPLACING THE ENTIRE ROOF.THE FABULOUS GOURMET KITCHEN HAS GRANITE COUNTERTOPS,LOTS OF STORAGE CABINETS AND NICE STAINLESS REFRIGERATOR. A NATURAL LIGHT FLOWS INTO EVERY ROOM WITH LARGE BRIGHT WINDOWS.HOW ABOUT CHECKING YOUR MONSTROUS MASTER SUITE WITH DUAL VANITY,HUGE JETTED TUB AND SEPARATE SHOWER.THE ENORMOUS WALK IN CLOSET IS IMPRESSIVE.SEE THE FULLY FENCED BACKYARD TO ENJOY QUIET SOLITUDE WHILE ONLY A SHORT DRIVE TO THE SHOPPING AREAS AND FINE DININGS. EASY TO COMMUTE TO 1/10,AND HWY 146.THIS IS A GREAT FIND IN THE HEART OF BAYTOWN THIS HOME IS IMMACULATE SHAPE AND WAITING FOR A NEW OWNER.CALL NOW','0.2204','2','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Baytown/Harris County','Central Gas','1','LT 11 COUNTRY CLUB ESTATES SEC 1','Subdivision Lot','9600','Appraisal District','','478','0','','2','Gas Oven','0','','','Gas Range','','Composition','23 - Goose Creek Consolidated','TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)','LEE HIGH SCHOOL (GOOSE CREEK)','BAYTOWN JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Country Club Estates Sec 01','9195','2.97','Public Sewer,Public Water,Water District','2000','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','215792906','1675096792','215792906','2022-12-29T00:37:17.227','73038630','Jenny Trieu','Seeto Realty','','','30.021982','-95.311210','11','77338','6','219000.00','Active','Linden House','21230','Court','Humble','2','0','3','1296','Single-Family','Great home for investment! There is a tenant currently occupied until February 2023, no showings until a contract is in place.','0.0964','12','','','','','Tenant Occupied','','','','Humble Area West','Central Gas','1','LT 17 BLK 1 KENSWICK MEADOWS AMEND','Subdivision Lot','4200','Appraisal District','','240','0','','1','','0','','','','','Composition','1 - Aldine','CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','JONES MIDDLE SCHOOL (ALDINE)','Appointment Required,Request Online Appointment','Appraisal District','1','Traditional','Kenswick Mdws Sec 01','4985','2.7433','Public Sewer,Public Water','2006','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','215834042','1675096792','215834042','2022-12-29T00:36:52.283','62904511','Jenny Trieu','Seeto Realty','','','29.878055','-95.704792','18','77449','3','235000.00','Active','Strathmore Place','19335','Lane','Katy','2','0','3','1154','Single-Family','Great home for investment, there is currently a tenant occupied until July 2023.','0.0885','25','','','','','Mud,Tenant Occupied','','','','Bear Creek South','Central Electric','1','LT 29 BLK 1 STRATHMORE PARK','Subdivision Lot','3854','Appraisal District','','306','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','JOWELL ELEMENTARY SCHOOL','CYPRESS SPRINGS HIGH SCHOOL','KAHLA MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Strathmore Park','5288','2.69','Water District','2004','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','215904980','1675096792','215904980','2022-12-29T00:21:47.713','41411592','Mark Sonnier','George E. Johnson Properties','','','29.675343','-95.356258','20','77051','5','205000.00','Active','Edfield','4562','Street','Houston','2','0','3','1110','Single-Family','Finishes include luxury wood look vinyl floors throughout, granite countertops in kitchen, mosaic backsplash, private small patio off master, ceramic tile surrounds and granite vanity tops in both bathrooms. Home located in Sunnyside area - minutes from downtown amenities, Medical Center, Pearland, Galleria and Midtown to name a few.','0.1228','3','','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','0','Medical Center South','Central Gas','0','LT 16 BLK 25 EAST SUNNYSIDE COURT OURT SEC 2','Subdivision Lot','5350','Appraisal District','','','0','','0','Gas Oven,Single Oven','0','','','Gas Range','','Composition','27 - Houston','YOUNG ELEMENTARY SCHOOL (HOUSTON)','WORTHING HIGH SCHOOL','ATTUCKS MIDDLE SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Traditional','JM SWISHER','4213','2.3307','Public Sewer,Public Water','2018','Appraisal'); --> New record created successfully