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-15T22:47:30.323' ,`MLSNumber` = '52456182' ,`ListAgentFullName` = 'Nancy Betancourt' ,`ListOfficeName` = 'Southern Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.861667' ,`Longitude` = '-95.315131' ,`PhotoCount` = '14' ,`PostalCode` = '77320' ,`RoomCount` = '5' ,`ListPrice` = '303900.00' ,`Status` = 'Active' ,`StreetName` = 'OAKDALE' ,`StreetNumber` = '101' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Lake Livingston! ONE-OF-A-KIND NEW double wide Mobile Home perfect weekend getaway, investment property, or permanent home! Enjoy peace and calm in lakeside village subdivision. Property is divided in 4 Lots by the city, perfect for investment. Residents and their guests can enjoy the main boat ramp that is right on the trinity river only about 5 minutes from the property. The subdivision amenities includes a covered area for picnics, a fishing dock and boat ramp.\r\nLakeside Village is located at the northern of San Jacinto County on FM 980.\r\nConroe, Woodlands and Spring are only 1 hour away.' ,`Acres` = '1.3' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 453,454,455, 456 of lakeside village #3' ,`LotDesciption` = 'Other' ,`LotSize` = '60000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '89' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'LAKESIDE VILLAGE' ,`TaxAmount` = '' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675156417' WHERE `Matrix_Unique_ID` = '210430429' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-15T22:41:50.473' ,`MLSNumber` = '3909162' ,`ListAgentFullName` = 'Sandra Membreno' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.937103' ,`Longitude` = '-95.275041' ,`PhotoCount` = '20' ,`PostalCode` = '77396' ,`RoomCount` = '7' ,`ListPrice` = '228500.00' ,`Status` = 'Active' ,`StreetName` = 'Leaftex' ,`StreetNumber` = '7506' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1463' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly renovated one-story home ready to move in. Open floor plan with fresh paint and new waterproof vinyl plank flooring. New 25 year shingles. New A/C Unit. New sheetrock throughout the whole house. The beautiful kitchen features Granite countertop and new light fixtures throughout the house. 12ft pool, ready for outdoor entertaining or just hanging out with friends and family! Easy access to Beltway 8 and Highway 59. Schedule your showing today!' ,`Acres` = '0.1641' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 19 EASTEX OAKS VILLAGE 3 R/P A' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'NORTH BELT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Eastex Oaks Village 03 R/P A' ,`TaxAmount` = '2670' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675156417' WHERE `Matrix_Unique_ID` = '214076994' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-15T22:22:20.600' ,`MLSNumber` = '84037063' ,`ListAgentFullName` = 'Raul Quintanilla' ,`ListOfficeName` = 'Jose Garza Agency' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.341906' ,`Longitude` = '-95.285905' ,`PhotoCount` = '11' ,`PostalCode` = '77328' ,`RoomCount` = '4' ,`ListPrice` = '239999.00' ,`Status` = 'Active' ,`StreetName` = 'Walker' ,`StreetNumber` = '2547' ,`StreetSuffix` = 'Road' ,`City` = 'Cleveland' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1328' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 2547 N.Walker. Completely unrestricted property with just a little under 3 acres. Opportunities are endless here\r\n2 rooms and one bathroom with an additional double wide that only needs connection to the home so that it can add more rooms and living space to the current home. Cleared and cleaned only and fence for privacy. Book your showing now with your favorite Realtor.' ,`Acres` = '2.27' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0088 - BARTON H, TRACT 11, ACRES 2.27' ,`LotDesciption` = 'Cleared' ,`LotSize` = '98881' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Hail Barton Surv Abs # 88' ,`TaxAmount` = '2877' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675156417' WHERE `Matrix_Unique_ID` = '214683592' --> 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','215498980','1675156418','215498980','2023-01-15T22:54:43.603','57099921','Anxin Ren','KingFay Inc','','','29.895079','-95.668023','35','77095','9','370000.00','Active','Timberline Run','7847','Lane','Houston','2','1','4','2675','Single-Family','Wonderful home located on a large cul-de-sac lot nestled in Copperfield Southcreek Village subdivision. This 2 story home features 4 bedrooms and 2.5 bathrooms, detached garage with covered walkway. Downstairs offers formal dining, home study/office, laundry room, half bath and large family room with lots of windows facing the backyard. Breakfast room is located off of the brightly lit kitchen. Primary bedroom downstairs with front bay window. Primary bathroom features a garden tub, separate shower and large closets. Three carpeted bedrooms, second bathroom, and a loft/game room are located upstairs. Enjoy the covered patio and large fenced in back yard that offers plenty of room for entertaining, gardening. Per Seller: Home features a tankless water heater, luxury vinyl flooring downstairs installed 2022, A/C installed 2014, and new Windows installed 2019. Microwave and oven installed 2022.','0.291','8','','','','','Sellers Disclosure','1','Gaslog Fireplace','1','Copperfield Area','Central Gas','1','LT 18 BLK 1 COPPERFIELD SOUTHCREEK VILLAGE SEC 11','Cul-De-Sac,Subdivision Lot','12692','Appraisal District','','705','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','LOWERY ELEMENTARY SCHOOL','LANGHAM CREEK HIGH SCHOOL','ARAGON MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Copperfield Southcreek Village','6268','2.537','Public Sewer,Water District','1990','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','216117783','1675156418','216117783','2023-01-15T22:24:07.113','98916397','Shani Daigle','Champions Realty, LLC','','','30.051655','-94.137695','11','77705','6','335000.00','Active','Pierre','4275','Drive','Beaumont','2','0','3','2100','Single-Family','Gorgeous new construction home located off Blossom and within 2 minutes of I-10. This home has a split open floorplan, study, covered patio, tile floors, granite counters, and gas starter fireplace. The microwave, stove and dishwasher is included.','0.2479','51','Rami Homes','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','','Central Electric','0','FLEETWOOD L3 ALL & E40 OF L2 BLK 7','Cleared','10800','Appraisal District','','','1','Never Lived In','2','','0','','','Electric Range','','Composition','143 - Beaumont','FEHL-PRICE ELEMENTARY SCHOOL','BEAUMONT UNITED HIGH SCHOOL','VINCENT MIDDLE SCHOOL','Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Builder','1','Traditional','Fleetwood','276','2.6134','Public Sewer,Public Water','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','216389292','1675156418','216389292','2023-01-15T22:14:31.960','96381917','Patrick Lalezari','Summit Realty','','','29.653103','-95.492966','49','77035','7','369000.00','Active','Dunlap','11527','Street','Houston','2','1','3','2841','Single-Family','Flagship home of the neighborhood on a large corner lot. Property has never flooded. Double pane PELLA/Jeld-wen windows with high end plantation shutters throughout. Open the entry door and your greeted with a beautiful spiral staircase and crystal chandelier in the foyer. Hardwood and tile flooring. Updated bathrooms with intricate stonework in the master. Walk-in cedar closets. Granite kitchen countertops with high end stainless steel appliances...take a look at that 48 inch 6 burner gas cooktop! Lots of custom shelving and built-ins for storage. Great open layout and floor plan perfect for entertaining. Two sets of double French doors leads to the massive backyard. Wood and brick pergola perfect for backyard cook outs and gatherings. Storage shed and dog/chicken coop with tall privacy fence all around, pull into your driveway with remote controlled gate parking. Brand new tankless water heater and fresh paint Make your appointment today. Owner/Agent','0.2342','20','','','','','Owner/Agent','','','','Brays Oaks','Central Gas','0','LT 1 BLK 85 PARKWEST SEC 3','Corner','10200','Appraisal District','','','0','','0','','0','','','','','Tile','27 - Houston','ANDERSON ELEMENTARY SCHOOL (HOUSTON)','WESTBURY HIGH SCHOOL','FONDREN MIDDLE SCHOOL','Lockbox Front','Appraisal District','2','Colonial','Parkwest Sec 03','6618','2.3307','Public Sewer,Public Water','1965','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','216418728','1675156418','216418728','2023-01-15T22:14:44.780','95899001','Nadia Colon','Next Generation Real Estate','','','29.692789','-95.241852','9','77017','5','189900.00','Active','Ahrens','902','Street','Houston','1','0','2','1035','Single-Family','Check out this super cute, two bedroom, one bath house. Brand new roof was just put on two months ago and new window at the front of the house was installed January 2023. This property has great potential after a few cosmetic repairs and adding your own personal touch. Perfect starter home. Large backyard is fully fenced and the perfect play area for kids. This lovely home is across the street from an elementary school.','0.196','3','','','','','Sellers Disclosure','','','','Hobby Area','Central Gas','0','LT 15 BLK 4 OAK MEADOWS SEC 1','Corner','8537','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','RUCKER ELEMENTARY SCHOOL','CHAVEZ HIGH SCHOOL','STEVENSON MIDDLE SCHOOL (HOUSTON)','Temporarily No Showings','Appraisal District','1','Traditional','Oak Meadows Sec 01','2286','2.3307','Public Sewer,Public Water','1952','Appraisal District'); --> New record created successfully