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-04T23:54:59.847' ,`MLSNumber` = '6861526' ,`ListAgentFullName` = 'Stuart Scholer' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809813' ,`Longitude` = '-95.407653' ,`PhotoCount` = '50' ,`PostalCode` = '77008' ,`RoomCount` = '8' ,`ListPrice` = '985000.00' ,`Status` = 'Active' ,`StreetName` = 'W 26th' ,`StreetNumber` = '540' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3159' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t Miss This Immaculate Home with an ELEVATOR in the Heart of The Heights! 4 Bedrooms (or 3 Bedrooms Plus a Study or Media Room), 3.5 Baths and a Game Room with a Wet Bar and a Covered Outdoor Terrace. The Family Room Overlooks the Picturesque Backyard with Room for Your Outdoor Kitchen and Pool. The Primary Suite is Designed Like a Hotel Suite with a Foyer, Coffee Bar, Lavish Bath with a Soaking Tub & Huge Walk-in Shower and Custom Closet. Over $150,000 in Custom Upgrades Including an ELEVATOR! This Amazing Home Also Showcases Hardwood Floors, Custom Iron Doors, 48\" Thermador Appliance Package, an Extended Kitchen Island, Soft Close Cabinets and Drawers, Data Smart and Built in Speakers, Lush Backyard Landscaping with Uplighting and Sprinkler System.' ,`Acres` = '0.0752' ,`Area` = '9' ,`BuilderName` = 'TITAN HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 32 HOUSTON HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3275' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Houston Hts' ,`TaxAmount` = '17931' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675104901' WHERE `Matrix_Unique_ID` = '213217458' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T23:22:45.173' ,`MLSNumber` = '34679083' ,`ListAgentFullName` = 'Pilar Salinas' ,`ListOfficeName` = 'Realty Associates - Baytown' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.820038' ,`Longitude` = '-95.070772' ,`PhotoCount` = '42' ,`PostalCode` = '77562' ,`RoomCount` = '7' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Hampton' ,`StreetNumber` = '322' ,`StreetSuffix` = 'Court' ,`City` = 'Highlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME TO THIS IMMACULATE 2 STORY HOUSE IN A QUIET AND ESTABLISHED NEIGHBORHOOD WITH GREAT CURB APPEAL AND CUL-DE-SAC LOCATION. IMPRESSIVE ADJOINING FORMALS, STATELY STACKED STONE COLUMNS AND DECORATIVE CROWN MILLWORK & CHAIR RAIL! HARDWOOD STAIRCASE WITH IRON SPINDLES. GREAT FAMILY ROOM, FORMAL LIVING ROOM, FORMAL DINING ROOM, BREAKFAST AREA WITH A BAY WINDOW OVERLOOKING BACKYARD. GAS RANGE/STOVE, BUILT IN MICROWAVE, STAINLESS DISHWASHER. SPACIOUS MASTER SUITE WITH AN IMPRESSIVE AND GORGEOUS BATH WITH HIS AND HERS SINKS, BIG WALK-IN CLOSET! GREAT SIZE SECONDARY BEDROOMS. HUGE BACKYARD WITH PATIO AND FIRE PIT READY TO ENTERTAIN FAMILY AND FRIENDS. INCLUDING A 24 X 12 STORAGE BUILDING. ENERGY EFFICIENT SOLAR SCREENS. GREAT NEIGHBORHOOD WITH SIDEWALKS & BOAT LAUNCH, WITHIN WALKING DISTANCE TO PARK, COMMUNITY CENTER & LIBRARY. MINUTES AWAY FROM I-10 AND SHOPPING CENTERS. WON\'T LAST LONG. CALL ME FOR YOUR PRIVATE TOUR!\r\n\r\nREADY TO MOVE IN.' ,`Acres` = '0.1584' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 4 HIGHLAND WOODS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '212' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Woods Sec 02' ,`TaxAmount` = '5639' ,`TaxRate` = '2.575' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675104901' WHERE `Matrix_Unique_ID` = '213260195' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-05T00:29:19.690' ,`MLSNumber` = '3227101' ,`ListAgentFullName` = 'Lyndsey Le' ,`ListOfficeName` = 'Platinum K Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748906' ,`Longitude` = '-95.592238' ,`PhotoCount` = '43' ,`PostalCode` = '77077' ,`RoomCount` = '9' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Sugar Springs' ,`StreetNumber` = '12018' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2441' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BACK ON MARKET WITH ALMOST $100K PRICE REDUCTION! HURRY! Don\'t miss out on this complete remodeled single-story home, featuring 3-4 bedrooms and 2.5-baths, such a beautiful, transitional gem with modern, open concept styles! Energy Corridor living at its finest tucked away on a quiet, mature tree-lined streets. Magnificence abounds in this classic yet modern contemporary showpiece home, fully renovated with quality, high-end detail at every turns. Don\'t forget the flex room (additional SF not reflected in HCAD records) that can be used as a media room or 4th bedroom! Enjoy the spacious backyard with mature trees, a sparkling pool, perfect for entertaining or hours of family fun. NEW GUTTERS, NEW LANDSCAPING, NEW GARAGE DOOR! Incredible location with convenient access to I-10, Beltway 8, and Westpark Tollway. You are also just minutes from all of the great restaurants, shopping, parks, and more located on Westheimer. Make your appointment and end your search today!' ,`Acres` = '0.1928' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 9 ASHFORD VILLAGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`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` = '27 - Houston' ,`SchoolElementary` = 'ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Ashford Village Sec 01' ,`TaxAmount` = '6897' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675104902' WHERE `Matrix_Unique_ID` = '215066729' --> 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','216041357','1675104902','216041357','2023-01-04T23:37:30.260','53646484','Quynh Luong','Coldwell Banker Realty, Cy-Fair Office','','','29.930890','-95.572659','21','77064','3','258000.00','Active','Autumn Harvest','10106','Drive','Houston','2','0','3','1654','Single-Family','Completely remodeled 1-story home located in proximity to Beltway 8, FM 1960, and minutes from Willowbrook mall. The property is ready for move-in with fresh new paint, new laminate flooring, granite countertops and new stainless steel appliances. New white shaker style, soft close cabinets in the kitchen and bathrooms. High ceiling with lots of sunlight shining into a huge living room. New standing tile shower w glass door in the primary bath. Huge back yard w new covered patio decking and side yard which will be suitable for a swimming pool. New light fixtures and hardware throughout the house. Great starter home in a cozy neighborhood.','0.1607','10','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Willowbrook South','Central Electric','1','LT 66 BLK 6 HARVEST BEND SEC 1','Cul-De-Sac','7000','Appraisal District','','407','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','13 - Cypress-Fairbanks','FRANCONE ELEMENTARY SCHOOL','CYPRESS RIDGE HIGH SCHOOL','CAMPBELL MIDDLE SCHOOL','Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Harvest Bend','4913','2.5587','Public Sewer,Public Water','1979','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','216079494','1675104902','216079494','2023-01-05T00:12:50.490','17577510','Tod Franklin','DFWCityhomes','','','29.882751','-95.786439','38','77493','9','699900.00','Active','Greengrass Meadows','7514','Lane','Katy','3','1','4','3403','Single-Family','Welcome home to this stunning One-Story Lake Front View Smart Home with spacious 4 bedroom 3.5 bath, 2 offices areas, media room, high ceilings, and plenty more. This better-than-new construction home is located in the highly, friendly, and beautiful way of life set among the wildflower on 3,600 acres. Miles of trails connect distinctive, masterfully crafted homes to budding parks and scenic stretches of open space.','0.223','25','','','','','Home Protection Plan','','Gaslog Fireplace','1','Katy - Old Towne','Central Electric,Zoned','1','LT 9 BLK 2 ELYSON SEC 28','Waterfront','9713','Appraisal District','','1344','0','','3','','0','','','','','Composition','30 - Katy','MCELWAIN ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','STOCKDICK JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox','Builder','1','Other Style','Elyson Sec 28','19541','3.4957','Public Sewer,Public Water,Septic Tank,Water District','2021','Builder'); --> New record created successfully