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-14T08:27:40.723' ,`MLSNumber` = '10485625' ,`ListAgentFullName` = 'John Newsom' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801049' ,`Longitude` = '-95.888083' ,`PhotoCount` = '9' ,`PostalCode` = '77493' ,`RoomCount` = '12' ,`ListPrice` = '899999.00' ,`Status` = 'Active' ,`StreetName` = 'Winding Canyon' ,`StreetNumber` = '1634' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'House is in the process of many updates and renovations, 2 new A/C units, paint inside and outside, upstairs and downstairs carpet being replaced, new gas cook top, new ceiling fans. Please contact agent for full list.' ,`Acres` = '1.4263' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S733104 REMINGTON TRAILS 4 BLK 2 LOT 3 ACRES 1.4263' ,`LotDesciption` = 'Cleared,Greenbelt,Subdivision Lot' ,`LotSize` = '62130' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Remington Trails 4' ,`TaxAmount` = '10986' ,`TaxRate` = '2.1293' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675132509' WHERE `Matrix_Unique_ID` = '212117562' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T08:57:01.933' ,`MLSNumber` = '2845195' ,`ListAgentFullName` = 'Mimi Tanner' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.123753' ,`Longitude` = '-95.546056' ,`PhotoCount` = '29' ,`PostalCode` = '77389' ,`RoomCount` = '8' ,`ListPrice` = '324295.00' ,`Status` = 'Active' ,`StreetName` = 'Aughton' ,`StreetNumber` = '25118' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Huge price reduction! Adorable one story waiting for your family to call home! If you are looking for an extremely well maintained home that\'s move in ready, this is it! The entry leads you to an open foyer with sightlines to the back of the house. A private office near the front of the house also can be additional bedroom. The great room is open to the formal dining room. A bright & open chefs kitchen updated in 2010 has tons of cabinet space, gorgeous gas stove, high ceilings & granite countertops, ready for friends & family! The private primary suite has access to the large deck in the back & a barn door leads you to a beautiful private bath (updated 2020) with a frameless shower, granite countertops & soaking tub. Two other bedrooms share a full bathroom. A generous back deck provides fantastic shaded outdoor living! NEW AC 9/2022, well cared for home! Convenient location to Woodlands Creekside Park shopping, Grand Parkway access. Neighborhood pool, tennis courts, park and more!' ,`Acres` = '0.1653' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 14 017*L5911553-002-014-013 LONDONDERRY SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'METZLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Londonderry' ,`TaxAmount` = '5876' ,`TaxRate` = '2.834' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675132509' WHERE `Matrix_Unique_ID` = '212950979' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T08:28:55.070' ,`MLSNumber` = '33966443' ,`ListAgentFullName` = 'Kelly Jackson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.498743' ,`Longitude` = '-95.527507' ,`PhotoCount` = '47' ,`PostalCode` = '77459' ,`RoomCount` = '12' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Erin' ,`StreetNumber` = '3515' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3742' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This handsome 2 Story home has the best location...tucked away on a cul-de-sac with no back neighbors, and views of the golf course and the 11th tee box. Outside, take note of the great curb appeal and inviting front porch. The main level features an open concept floor plan, cathedral ceilings and updated light fixtures. The spacious gourmet kitchen is sure to impress with white cabinets, updated quartz counter tops, stainless appliances, island with cooktop and griddle, all overlooking the den with cozy fireplace. This home is perfect for entertaining. There is new carpet and fresh paint throughout the home. The main level primary suite features en suite bath and walk in closet. Upstairs there are ample sized secondary bedrooms and an inviting gameroom. Host summer gatherings in the fenced yard with covered patio and Olympic sized pool, with views of the golf course. The 3-car tandem garage is perfect for cars and \"toys\". Close to elementary school and neighborhood amenities. Must See' ,`Acres` = '0.234' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA VILLAGE OF WATERS LAKE SEC 4, BLOCK 1, LOT 7' ,`LotDesciption` = 'Cul-De-Sac,On Golf Course,Subdivision Lot' ,`LotSize` = '10193' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SCANLAN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Village Of Waters Lake Sec 4' ,`TaxAmount` = '10686' ,`TaxRate` = '2.5729' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675132510' WHERE `Matrix_Unique_ID` = '214455714' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T08:37:32.633' ,`MLSNumber` = '51412222' ,`ListAgentFullName` = 'Alicia Reader' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.916617' ,`Longitude` = '-95.478409' ,`PhotoCount` = '16' ,`PostalCode` = '77086' ,`RoomCount` = '13' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Stirring Winds' ,`StreetNumber` = '6038' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2654' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1416' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 3 NORTHWEST PARK PLACE SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '6166' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'SHOTWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northwest Park Place Sec 03' ,`TaxAmount` = '4695' ,`TaxRate` = '2.4283' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675132510' WHERE `Matrix_Unique_ID` = '214730921' --> 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','215135182','1675132510','215135182','2023-01-14T08:33:59.167','91938316','Carla Melendez','The Yarborough Group','','','29.603391','-95.207681','25','77089','8','268900.00','Active','Sagewood','11211','Drive','Houston','2','0','4','1767','Single-Family','Come see this beautifully renovated 4 bedroom 2 bath home in Sagemont ! Home has been freshly painted inside and out, New Roof installed Sept. 2022, kitchen cabinets painted, kitchen back splash, Completely new bathrooms, New fixtures throughout the home, New Carpet and new double pane windows to be installed within a week. Home is conveniently located near the intersection of Sam Houston Tollway and I-45, minutes away from restaurants and shopping centers! Schedule to view this home Today before it\'s too late !','0.1768','3','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','Mock Fireplace','1','Southbelt/Ellington','Central Gas','1','LT 3 BLK 1 SAGEMONT SEC 1','Subdivision Lot','7700','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','41 - Pasadena','STUCHBERY ELEMENTARY SCHOOL','DOBIE HIGH SCHOOL','THOMPSON INTERMEDIATE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Sagemont Sec 01','4567','2.6863','Public Sewer,Public Water','1964','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','215395583','1675132510','215395583','2023-01-14T07:30:42.330','34790175','John Simms','Legacy Homes & Properties, LLC','Victor Moreno','Styled Real Estate','30.047865','-95.237797','41','77339','5','414900.00','Pending Continue to Show','Southern Hills','1211','Road','Houston','2','1','4','2672','Single-Family','Location, Land and Updates! Welcome to this beautiful home in the heart of Kingwood that has NEVER FLOODED, is fully updated and sits on nearly an acre! This home has a unique floor plan that allows for hosting and living space on the 1st floor and bedrooms and storage on the 2nd floor. The 1st floor has plenty of space with formal living and dining areas, family room with a brick fireplace and a custom mantle. The kitchen includes custom cabinetry, quartz countertops and beautiful tile work with a farmhouse sink, Stainless appliances, under cabinet lighting and a beautiful vent hood. The counter peninsula and breakfast nook ensure plenty of seating to this open floor plan. The second floor hosts the primary bedroom and 3 additional bedrooms, all with walk-in closets. Enjoy your backyard oasis under a large, covered patio with double ceiling fans on a quiet and peaceful lot. Come see today and live in Kingwood tomorrow!','0.8815','32','','','','','Sellers Disclosure','1','','1','Kingwood West','Central Gas','1','LT 6 BLK 49 FOREST COVE COUNTRY CLUB ESTATES SEC 4','Subdivision Lot','38400','Appraisal District','','125','0','','2','','0','','','','','Composition','29 - Humble','FOSTER ELEMENTARY SCHOOL (HUMBLE)','KINGWOOD PARK HIGH SCHOOL','KINGWOOD MIDDLE SCHOOL','Leave Business Card,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Traditional','Estates Sec 04','9465','2.5839','Public Sewer,Public Water','1969','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','216028448','1675132510','216028448','2023-01-14T08:48:22.677','74738961','Jack Lipar','LGI Homes','','','29.866465','-95.880720','9','77493','9','277900.00','Active','Bosworth Bay','405','Drive','Katy','2','0','3','1570','Single-Family','The Maple by LGI Homes. This upgraded one-story home showcases three bedrooms and two bathrooms in addition to an open kitchen with a sprawling breakfast bar, a spacious family room and a private dining room. A spacious covered patio and fully fenced backyard extends the entertaining space outdoors. Designer extras include a full suite of Whirlpool brand kitchen appliances, granite countertops, a programmable thermostat, a finished garage with WiFi-enabled garage door opener, and much more!','','26','LGI HOMES','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures','1','','','Brookshire','Central Gas','1','KTY SEC4 BLOCK8 LOT2 of Freeman Ranch','Subdivision Lot','','','','348','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','44 - Royal','ROYAL ELEMENTARY SCHOOL','ROYAL HIGH SCHOOL','ROYAL JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Freeman Ranch','','','Other Water/Sewer','2022','Builder'); --> 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','216036032','1675132510','216036032','2023-01-14T08:49:03.997','26026972','Swapna Patel','Keller Williams Premier RealtyKaty','','','29.399580','-94.947677','14','77590','4','130000.00','Active','Palm','3408','Avenue','Texas City','2','0','4','1338','Single-Family','Investor Special! Handyman Special! Check out this fix and flip or rental opportunity in the heart of Texas City! Good accessibility to local shopping and commute to local industry. House needs some TLC and is sold \"As-is Where Is\" with no disclosures or guarantees from the seller. This one will go quickly!','0.1553','33','','','','','No Disclosures,Sellers Disclosure','','','','Texas City','Butane,Central Electric','0','ABST 63 H FERGUSON SUR LOTS 27 & 28 BLK 6 HEIGHTS ANNEX REPL','Subdivision Lot','6764','Appraisal District','','','0','','0','','0','','','','','Composition','52 - Texas City','SIMMS ELEMENTARY SCHOOL','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL (TEXAS CITY)','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Craftsman','Heights Annex','3541','2.445','Public Sewer,Public Water','1974','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','216038626','1675132510','216038626','2023-01-14T08:16:53.763','32834940','Nga Tran','5th Stream Realty','Nga Tran','5th Stream Realty','29.902475','-95.461888','6','77038','3','265000.00','Pending Continue to Show','Quinn Ridge','11639','Way','Houston','2','0','3','2028','Single-Family','Beautiful 3 beds, 2 bath home with front and back porch. Conveniently located close to 249 and beltway 8. Home is very spacious and open, it has new ac system, granite countertops, new appliances, new flooring throughout and fresh paint. This one is move in ready.','0.1263','11','','','','','Sellers Disclosure','','','1','Aldine Area','Central Gas','0','LT 24 BLK 2 WILLOW SPRINGS SEC 4','Other','5500','Appraisal District','','','0','','2','','0','','','','','Composition','1 - Aldine','CARTER ACADEMY','EISENHOWER HIGH SCHOOL','SHOTWELL MIDDLE SCHOOL','No Supra Keybox','Appraisal District','1','Other Style','Willow Spgs','8234','3.4553','Public Sewer,Public Water,Water District','2007','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','216253615','1675132510','216253615','2023-01-14T08:51:50.793','68722812','Jared Turner','LennarVillageBldr-JaredTurner','','','29.518559','-95.783973','10','77471','8','320000.00','Active','Falling Moon','3723','Lane','Rosenberg','2','0','4','1922','Single-Family','NEW! Lennar Wildflower Collection \"Brenham II\" Plan with Elevation \"C\" in Sendero! This spacious, single-story home features a large family room, a kitchen with a center island and an adjoining breakfast space that overlooks a covered patio. The owner’s suite enjoys a large walk-in closet and a private entry that leads to a second walk-in closet and a laundry room. *HOME ESTIMATED TO BE COMPLETE, April, 2023*','','30','Lennar','','','','Mud,Other Disclosures','1','','0','Fort Bend South/Richmond','Central Gas','1','SEC 0006 BLK 003 LOT 014','Subdivision Lot','','','','756','1','To Be Built/Under Construction','2','','0','','','','','Composition','33 - Lamar Consolidated','MEYER ELEMENTARY SCHOOL (LAMAR)','RANDLE HIGH SCHOOL','WRIGHT JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Sendero','','3.09','Water District','2023','Builder'); --> 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','216254199','1675132510','216254199','2023-01-14T08:52:22.007','35350864','Jared Turner','LennarVillageBldr-JaredTurner','','','29.518521','-95.783994','10','77471','9','315000.00','Active','Falling Moon','3720','Lane','Rosenberg','2','0','4','1932','Single-Family','NEW! Lennar Wildflower Collection \"Clover II\" Plan with Elevation \"B\" in Sendero! This beautiful single-story home showcases a generous open floorplan shared between the family room, dining room and kitchen, leading directly to a covered patio for seamless indoor-outdoor living. A flex room off the foyer is perfect as a home office/study or bonus room. Four bedrooms complete this home. *HOME ESTIMATED TO BE COMPLETE, April, 2023*','','30','Lennar','','','','Mud,Other Disclosures','1','','0','Fort Bend South/Richmond','Central Gas','1','SEC 0006 BLK 001 LOT 019','Subdivision Lot','','','','756','1','To Be Built/Under Construction','2','','0','','','','','Composition','33 - Lamar Consolidated','MEYER ELEMENTARY SCHOOL (LAMAR)','RANDLE HIGH SCHOOL','WRIGHT JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Sendero','','3.09','Water District','2023','Builder'); --> New record created successfully