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-08T18:42:59.883' ,`MLSNumber` = '24213674' ,`ListAgentFullName` = 'Maria Rodriguez' ,`ListOfficeName` = 'CENTURY 21 Western Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.624821' ,`Longitude` = '-95.013467' ,`PhotoCount` = '14' ,`PostalCode` = '77571' ,`RoomCount` = '9' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Bay Oaks' ,`StreetNumber` = '226' ,`StreetSuffix` = 'Drive' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1362' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t wait to check out this darling home! The property is just minute away from the ocean. Enjoy the extra large lot space.' ,`Acres` = '0.3352' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 18 19 & 20 BLK 8 BAY OAKS' ,`LotDesciption` = 'Other' ,`LotSize` = '14600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'BAYSHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Oaks' ,`TaxAmount` = '4145' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106536' WHERE `Matrix_Unique_ID` = '211420380' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-08T18:27:56.733' ,`MLSNumber` = '40017106' ,`ListAgentFullName` = 'Robert Johnson' ,`ListOfficeName` = 'Century 21 Olympian Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472173' ,`Longitude` = '-95.048809' ,`PhotoCount` = '19' ,`PostalCode` = '77539' ,`RoomCount` = '6' ,`ListPrice` = '234990.00' ,`Status` = 'Active' ,`StreetName` = 'Acorn' ,`StreetNumber` = '3212' ,`StreetSuffix` = 'Circle' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1337' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic house for a Family or Investment! Newly renovated! Includes state of the art tech as well as great updates! This one has an amazing new Kitchen, Master Bathroom, Security Cameras, A.C. and much more! Professional landscaping and a huge deck outside for entertaining and BBQ. This one won’t last long! Set up your appointment to view today!' ,`Acres` = '0.2093' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 19 PERRY & AUSTIN SUR LOT 19 BLK 2 EDGEWOOD SUB' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9115' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SILBERNAGEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Edgewood' ,`TaxAmount` = '4600' ,`TaxRate` = '2.1168' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106537' WHERE `Matrix_Unique_ID` = '214637571' --> 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','215148258','1675106537','215148258','2023-01-08T18:21:22.470','71146489','Sean Randall','Deborah Villarreal','','','29.516416','-95.751486','27','77469','4','370000.00','Active','Pointe Hollow','6618','Lane','Richmond','3','0','4','2347','Single-Family','','0.2284','30','','','Electric Dryer Connections','','Mud,Sellers Disclosure','1','','','Fort Bend South/Richmond','Central Electric','0','ROSEHAVEN SEC 1, BLOCK 3, LOT 5, R/P','Corner','9947','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','THOMAS ELEMENTARY SCHOOL (LAMAR)','RANDLE HIGH SCHOOL','WRIGHT JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox','Appraisal District','1','Contemporary/Modern','Rosehaven Sec 1','6819','2.5848','Public Sewer,Public Water,Water District','2011','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','215705366','1675106537','215705366','2023-01-08T18:21:03.423','12537494','Feiyun Cheng','RE/MAX Fine Properties','','','29.695519','-95.641047','42','77083','9','299000.00','Active','Empanada','14602','Drive','Houston','2','1','3','2054','Single-Family','Lovely 2-story, 3 bedrooms, 2.5 baths, 2-car garage in Terra Del Sol community. Open floor plan featuring dining room and a study off the entry. Spacious, and bright family room. Kitchen opens to the family room and equipped with granite counters, tile backsplash, 42\' cabinets and stainless steel appliances. Primary bedroom located on 2nd floor with private bath with double sinks, separate shower, soaking tub, and a large walk-in closet. Also upstairs are a large game room, 2 secondary bedrooms and 2nd full bathroom. Refrigerator, washer and dryer included. Private resident driveway in the rear of the house with 2-car detached garage. Easy access to Hwy 6 and Westpark Toll Way, and conveniently located to shopping and just about everything. Low tax rate and HOA fees.','0.0924','28','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Alief','Central Gas','1','LT 93 BLK 3 TERRA DEL SOL SEC 4','Subdivision Lot','4025','Appraisal District','','558','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','2 - Alief','HICKS ELEMENTARY SCHOOL (ALIEF)','AISD DRAW','ALBRIGHT MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied','Appraisal District','2','Traditional','Terra Del Sol Sec 4','7071','2.5785','Water District','2014','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','215752074','1675106537','215752074','2023-01-08T17:33:31.340','46530888','Deborah Tatham','Douglas Elliman Real Estate','','','29.767503','-95.488785','10','77024','15','8500000.00','Active','Shasta','108','Drive','Hunters Creek Village','9','4','7','14130','Single-Family','Nestled on 3+ acres at the end of a quiet cul-de-sac in sought-after Hunters Creek Village, this 14,000+ sqft custom home offers plenty of space for entertaining and an abundance of privacy. Floor to ceiling windows present dramatic views of mature trees, the infinity edge pool, cabana and spa. The first floor primary suite includes a fireplace, a sunken shower with garden views, his/her dressing areas, and a private staircase that leads to a stunning 2nd floor home office. Five bedrooms, a handsome game room, and a media room are also located upstairs.\r\nStep outside and stroll down to the vast green space situated alongside Buffalo Bayou. Bonus - the 17th hole of Houston Country Club\'s golf course is located directly across the bayou. Separate quarters w/full bath and kitchen are located over the 4 car garage. \r\nAn amazing opportunity for a luxury remodel!','','23','Jeff Griffis','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','0','Gaslog Fireplace,Wood Burning Fireplace','3','Memorial Villages','Central Gas,Zoned','1','TR 28A & 28B BLK 1 MEMORIAL DRIVE MANOR R/P','Cul-De-Sac,Subdivision Lot,Waterfront','136793','Appraisal District','','100','0','','4','','1','Heated,In Ground','','','','Slate','49 - Spring Branch','HUNTERS CREEK ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (SPRING BRANCH)','SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)','Accompany,Appointment Required','Appraisal','2','Contemporary/Modern,Other Style','Memorial Drive Manor R/P','128527','2.1111','Public Sewer,Public Water','1998','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','216098141','1675106537','216098141','2023-01-08T17:52:10.687','94774503','Kelly Le','5th Stream Realty','','','29.606526','-95.258535','24','77075','4','299000.00','Active','Dove','9123','Way','Houston','2','0','4','2007','Single-Family','Welcome to NEW REMODELED HOME, CONVENIENT LOCATION! LOW TAX, NO HOA. Brand-new paint exterior and interior the house also with new floor through. NEW Roof, AC compressor, Water heater, Countertops, Sinks, Faucets, and Brand NEW APPLIANCES(stove, dish washer, microwave). READY TO MOVE IN 4 baths, 2 baths perfect family home boasts a large master bedroom with plenty of space for sitting area, walking closet. Walk in the home with the formal dinning room connected the kitchen area has many windows for getting natural light. Large the cover patio is very ideal for gathering party together. Zoned with the excellent school district. Easy access to Beltway 8, 288, I-45 freeway. NEVER FLOODING !Make your appointment today to see this beauty!','0.1548','3','','','','','No Disclosures','1','','1','Southbelt/Ellington','Central Gas','0','LT 17 BLK 3 BRIDGEGATE SEC 5','Subdivision Lot','6743','Appraisal District','','','0','','2','','0','','','','','Composition','41 - Pasadena','BUSH ELEMENTARY SCHOOL','DOBIE HIGH SCHOOL','BEVERLYHILLS INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Lockbox Right Side,Supra Keybox','Appraisal District','1','Traditional','Bridgegate Sec 05','6768','2.6863','Public Sewer,Public Water','2003','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','216189372','1675106537','216189372','2023-01-08T17:48:58.797','49329045','Will Puente','SavvyWay Realty, Inc.','','','30.058717','-95.235732','30','77339','4','339000.00','Active','Grand Lancelot','21844','Drive','Kingwood','3','1','4','2878','Single-Family','Well maintained remodeled 2 story Home in Kings Manor. 4Bed / 3.5Baths with open floor plan. Highlight includes Laminate flooring no carpet throughout, granite countertop in kitchen, solar screen on windows all around, extended covered patio with A/c for kids zone, new metal stair baluster and rails, gas chimney, recent updated 2 water heaters and A/C system, sprinkler system, new fence in backyard, storm door and much more. Not in a flood zone.','0.1515','40','','','','','Sellers Disclosure','','','1','Kingwood West','Central Electric','1','S642710 - KINGS MANOR 10, BLOCK 1, LOT 4','Cleared','6601','Appraisal District','','','0','','2','','0','','','','','Composition','39 - New Caney','KINGS MANOR ELEMENTARY SCHOOL','PORTER HIGH SCHOOL (NEW CANEY)','WOODRIDGE FOREST MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Kings Manor 10','7078','2.7631','Public Sewer,Public Water','2003','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','216189777','1675106537','216189777','2023-01-08T18:40:54.433','27828351','Heather Lange','RE/MAX One','','','29.964464','-94.023871','20','77627','5','300000.00','Active','Green','8010','Avenue','Nederland','1','0','2','1044','Single-Family','This 1 1/2 acre property would make a great investment property as a remodel or for a residential developer. An up and coming neighborhood of new builds and a prime amount of land in Nederland ISD. \r\n\r\nThe buyer will have to turn on temporary utilities for inspection purposes.','1.4555','51','','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','','','1','','Central Gas','0','LTS 66 & 67 PLEASANT HOME REPLAT','Cleared','63401','Appraisal District','','','0','','1','Gas Oven','0','','','Gas Range','','Composition','152 - Nederland','HELENA PARK ELEMENTARY SCHOOL','NEDERLAND HIGH SCHOOL','WILSON MIDDLE SCHOOL (NEDERLAND)','Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Traditional','Pleasant Home Rep','3865','2.3638','Public Sewer,Public Water','1962','Appraisal District'); --> New record created successfully