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` = '2023-01-27T01:22:35.210' ,`MLSNumber` = '92191762' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.192798' ,`Longitude` = '-95.407920' ,`PhotoCount` = '6' ,`PostalCode` = '77515' ,`RoomCount` = '6' ,`ListPrice` = '345336.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Bend' ,`StreetNumber` = '181' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1848' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Bayou Bend! Anglia Homes presents the Wetherby floor plan. This is a one story home with 3 bedrooms, 2 bathrooms and an optional 4th bedroom or office/home study. The kitchen opens up to the family room. The primary bedroom has a large walk-in closet. Call today for your private showing.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 19 Block 1 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bayou Bend' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675264128' WHERE `Matrix_Unique_ID` = '208781981' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T02:49:32.573' ,`MLSNumber` = '12233316' ,`ListAgentFullName` = 'Juan Badillo' ,`ListOfficeName` = 'Berkshire Hathaway Home Svs.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.874418' ,`Longitude` = '-95.636735' ,`PhotoCount` = '35' ,`PostalCode` = '77084' ,`RoomCount` = '6' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Falmouth' ,`StreetNumber` = '15206' ,`StreetSuffix` = 'Avenue' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two stories well maintained home is ready for a Family. House is ready to Move in and can obtain a fast-closing period. This house is very well located in the west side of Houston. Minutes from major shopping areas Home Depot and Lowes are down the street from the neighborhood. Great restaurants and shopping centers nearby. This home is located in the cy-fairs school district. This home is a gorgeous 3 bedroom 2 and half baths. Home has been newly updated with flooring, threw out the entire house and newly installed roof in 2021. Schedule you\'re showing today... You won\'t be disappointed! this home is ready to move in and enjoy.in multiple offers' ,`Acres` = '0.1249' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 4 MAPLE TRACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5442' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Maple Trace Sec 01' ,`TaxAmount` = '5556' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675264128' WHERE `Matrix_Unique_ID` = '211678006' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T01:22:35.210' ,`MLSNumber` = '95332651' ,`ListAgentFullName` = 'Rhonda Surovec' ,`ListOfficeName` = 'RE/MAX East' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.329723' ,`Longitude` = '-94.939698' ,`PhotoCount` = '49' ,`PostalCode` = '77563' ,`RoomCount` = '9' ,`ListPrice` = '589000.00' ,`Status` = 'Active' ,`StreetName` = 'Tarpon' ,`StreetNumber` = '104' ,`StreetSuffix` = 'Street' ,`City` = 'Bayou Vista' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2589' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous waterfront home in Hitchcock! Boasting 4 bedrooms, 3 bathrooms, 2 living areas, and an impressive outdoor space, this Bayou Vista home exudes relaxation vibes. Embark on an aquatic excursion with the on-site boat slip, cast your line from the fishing dock, or experience the excitement of Galveston just a few miles away. After a day spent exploring attractions, fire up the grill for true Texan BBQ or cozy up indoors for family game night!\r\nLighted photos or virtual enhanced.' ,`Acres` = '0.1688' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bayou Vista' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 7 PAGE 7 LOT 104 NEW BAYOU VISTA ADDN 2' ,`LotDesciption` = 'Water View' ,`LotSize` = '7354' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Bayou Vista 2' ,`TaxAmount` = '13091' ,`TaxRate` = '2.635' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675264128' WHERE `Matrix_Unique_ID` = '214934403' --> 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','215274657','1675264129','215274657','2023-01-27T01:22:35.210','9126459','Tammie Bell','TBT Real Estate','','','29.176249','-95.428441','11','77515','3','175000.00','Active','Lorrain','604','Street','Angleton','2','0','3','1163','Single-Family','LOOKS AND FEELS NEW, almost is! The open floor plan welcomes you into this fully remodeled 3-bedroom, 2 bathroom, 1 carport home with a tastefully new designed kitchen. Attention to detail throughout just completed with fresh paint, floors, cabinets, light fixtures, windows, and gutters that come with a transferable warranty. The master bathroom is a nice place for the day to end in the custom-built oversized shower complete a modern frameless glass door. Oversized mudroom / laundry room has endless opportunities for additional use to fit your needs. Extra storage, playroom, or a comfortable place for outdoor pets on cold days, to name a few. Get new home feel in an established neighborhood today.','0.1858','5','','','Washer Connections','','Sellers Disclosure','','','','Angleton','Central Electric','0','K & S PLAZA (ANGLETON), BLOCK 2, LOT 2-W/2.5\' LT 3','Subdivision Lot','8093','Appraisal District','','','0','','1','','0','','','','','Composition','5 - Angleton','NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)','ANGLETON HIGH SCHOOL','ANGLETON MIDDLE SCHOOL','Appointment Required,Leave Business Card','Appraisal','1','Traditional','K & S Plaza Angleton','2256','2.6102','Public Sewer,Public Water','1972','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','215667398','1675264129','215667398','2023-01-27T01:22:35.210','31748909','Denise Ashby','Keller Williams RealtyNortheast','','','30.370145','-95.639352','50','77316','9','1198000.00','Active','Blue Heron','244','Drive','Montgomery','3','1','3','3775','Single-Family','Serene waterfront estate on a wooded hilltop acre. Located in the gated Blue Heron Bay section of Lake Conroe on a secluded cove that’s just a short boat ride to open water. Has a covered Polywood boat dock with lift and kayak launch. Parklike setting with natural stone waterfall feature in the back. The home has wonderful architectural details: stacked stone and stucco exterior, wall of butted joint windows, sculpted stair railing, curved walls, all bedrooms down with a large open bonus room upstairs with full bath and private veranda overlooking the lake. Oversized three car garage with an enclosed shop area that could easily be converted to a forth bedroom. The acre consists of three lots and one lot could easily be sold off. Sit back and enjoy the many birds that are on the property and watch the fireflies in Spring.','1.15','39','','','','','Mud,Sellers Disclosure','1','Freestanding,Gas Connections,Gaslog Fireplace','1','Lake Conroe Area','Central Gas','1','S263502 - BLUE HERON BAY 02, BLOCK 1, LOT 5, 6, 7','Cleared,Corner,Subdivision Lot,Waterfront','50094','Appraisal District','','1250','0','','3','Double Oven','0','','','Gas Cooktop','','Composition','37 - Montgomery','STEWART CREEK ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required,Controlled Access,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Blue Heron Bay 02','22360','2.4542','Water District','1999','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','215923967','1675264129','215923967','2023-01-27T02:34:36.397','56662396','Christina Thurlow','Texas Legacy Properties','Albert Yanez','Texas Legacy Properties','30.054128','-95.358198','28','77373','6','248000.00','Option Pending','Goodfellow','23627','Drive','Spring','2','0','3','1454','Single-Family','Gorgeous 1 story., better than new. Completed the end of May. Tons of upgrades. Granite countertops. Great floorplan. Large Primary suite, double sinks. Separate tub/shower. Large Walk-in closet. High ceilings. Open Floorplan. Double paned windows. Professionally landscaped. Ready for move in. Exceptional home. Only 1 story available in this area. Don\'t miss out. . .','0.0918','12','Legend','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Spring East','Central Electric','1','LT 52 BLK 6 CYPRESSWOOD LANDING SEC 1','Subdivision Lot','4000','Appraisal District','','400','0','','2','Freestanding Oven,Gas Oven','0','','','Gas Range','','Composition','48 - Spring','CHET BURCHETT ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','DUEITT MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox','Appraisal District','1','Contemporary/Modern','Cypresswood Landing','1578','2.1367','Water District','2021','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','216283310','1675264129','216283310','2023-01-27T01:52:01.393','81349299','JaVon Martin','eXp Realty, LLC','','','30.523734','-94.803088','25','77351','3','90000.00','Active','Hillbilly Heaven','428','Road','Livingston','2','0','3','1786','Single-Family','Over 1 acre ready for you! This is an investment opportunity located in Wild Country Lakes Estates subdivision in Polk County. Wooded and semi secluded without any restrictions for your future investments! This house sits on one lot of three that can be divided or cleared out for your plans.','1.0284','44','','','','','Real Estate Owned','','','','Livingston Area','Central Electric,No Heating,Other Heating','0','WILD COUNTRY LAKES ESTATES SECTION 6 LOT 116 THRU 122','Other,Wooded','44795','Appraisal District','','','0','','0','','0','','','','','Aluminum','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','2','Other Style','Wild Country Lakes Estates Sec','1445','1.8745','Public Sewer,Public Water','1995','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','216517879','1675264129','216517879','2023-01-27T02:04:06.350','71231825','Jared Turner','Turner Mangum,LLC','','','29.472120','-95.468080','36','77583','4','336990.00','Active','Murciana','9843','Drive','Rosharon','3','0','4','2175','Single-Family','Stunning New D. R. Horton Two Story Ranch Home! The Midland Plan! Upgraded Brick & Stucco Elevation with Large Covered Patio! Grand Entry with Amazing luxury Vinyl Floors throughout! The Outstanding Family Area has a Wall of Windows looking out to your Backyard, High Ceilings all that flows into the Gourmet Kitchen & Casual Dining Area! Gourmet Kitchen has Beautiful Tall Shaker Cabinets, Tile Backsplash, Stainless Steel Appliances, Huge Eat in Island, Gorgeous Silestone Quartz Counters, Undermount Sink, Side full irrigation and full Blinds throughout! Owner\'s Suite tucked away from all Guest Bedrooms Features High Ceilings, Plush Carpet, Luxurious Bathroom with His & Her Private Undermount Sinks, Quartz Countertops, Seamless Glass Shower, Huge Walk in Closet! 3 Guest Bedrooms tucked away; 1 guest room downstairs & Full Bathroom W/Quartz Countertops & More! No Flooding! Amenity Center w/Pool, Lap Pool, Water Slides, Pavilion, Playground, Soccer Fields & more!','0.179','38','D.R. Horton','','Electric Dryer Connections,Gas Dryer Connections','','Mud','1','','','Sienna Area','Central Gas','1','NA','Subdivision Lot','','','','850','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','19 - Fort Bend','HERITAGE ROSE ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','THORNTON MIDDLE SCHOOL (FORT BEND)','Appointment Required','Appraisal District','2','Traditional','Caldwell Ranch','','3.2629','Water District','2023','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','216527532','1675264129','216527532','2023-01-27T02:06:05.623','63643197','Jared Turner','Turner Mangum,LLC','','','29.472120','-95.468080','35','77583','4','338990.00','Active','Tall Shire','907','Court','Rosharon','3','0','4','2175','Single-Family','Stunning New D. R. Horton The Midland Plan! Upgraded Brick & Stucco Elevation with Large Covered Patio! 2 story home with 3 full baths and a Grand Entry with Amazing luxury Vinyl Floors throughout! The Outstanding Family Area has a Wall of Windows looking out to your Backyard, High Ceilings all that flows into the Gourmet Kitchen & Casual Dining Area! Gourmet Kitchen has Beautiful Tall Shaker Cabinets, Tile Backsplash, Stainless Steel Appliances, Huge Eat in Island, Gorgeous Silestone Quartz Counters, Undermount Sink, Side full irrigation and full Blinds throughout! Owner\'s Suite tucked away from all Guest Bedrooms Features High Ceilings, Plush Carpet, Luxurious Bathroom with His & Her Private Undermount Sinks, Quartz Countertops, Seamless Glass Shower, Huge Walk in Closet! 3 Guest Bedrooms tucked away & Full Bathroom W/Quartz Countertops & More! No Flooding! Amenity Center w/Pool, Lap Pool, Water Slides, Pavilion, Playground, Soccer Fields & more!','0.179','38','D.R. Horton','','Electric Dryer Connections,Gas Dryer Connections','','Mud','1','','','Sienna Area','Central Gas','1','NA','Subdivision Lot','','','','850','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','19 - Fort Bend','HERITAGE ROSE ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','THORNTON MIDDLE SCHOOL (FORT BEND)','Appointment Required','Appraisal District','2','Traditional','Caldwell Ranch','','3.2629','Water District','2023','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','216624014','1675264129','216624014','2023-01-27T01:06:33.513','34263213','Wanda Chen','General Realty','Victor Zhou','CitiQuest Properties','29.670349','-95.587875','27','77099','9','240000.00','Option Pending','Spring Grove','11850','Drive','Houston','2','1','3','1833','Single-Family','GREAT FAMILY HOME WITH ALL THE UPGRADES! This wonderful 3 bed, 2 bath, 1,833 sq.ft home has been meticulously updated from top to bottom. As you enter the home, you’ll notice the open floor plan, high ceilings, and huge gourmet kitchen with all new appliances, soft-close cabinets, and quartz countertops. All new flooring and recessed lighting plus home was painted, both inside and outside. Both bathrooms were remodeled highlighted by vanities topped with quartz countertops. Private cedar fenced courtyard with wrought iron gate lends extra privacy. Detached two-car garage. No need to worry about sweating through another hot summer with your brand new Carrier HVAC unit and new air ducts. Freezing weather? No worries there either as all of the old metal plumbing has been replaced with Oponor PEX which means your pipes won\'t break in the winter. Conveniently located near great shopping, grocery stores, and parks plus easy access to Beltway 8 or 59 Freeway. Never flooded.','0.101','28','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','Freestanding,Gas Connections','1','Stafford Area','Central Electric,Central Gas','1','LT 2 BLK 1 KEEGANS GLEN SEC 6 R/P','Subdivision Lot','4400','Appraisal District','','310','0','','1','Double Oven','0','','','Gas Cooktop','','Composition','2 - Alief','CUMMINGS ELEMENTARY SCHOOL','AISD DRAW','HOLUB MIDDLE SCHOOL','Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Keegans Glen Sec 06 R/P','3932','2.4258','Public Sewer,Public Water,Water District','1982','Appraisal District'); --> New record created successfully