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-05T19:45:07.793' ,`MLSNumber` = '20119831' ,`ListAgentFullName` = 'Vamshi Kyatham' ,`ListOfficeName` = 'All City Real Estate, Ltd. Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.569013' ,`Longitude` = '-95.585074' ,`PhotoCount` = '33' ,`PostalCode` = '77479' ,`RoomCount` = '9' ,`ListPrice` = '489200.00' ,`Status` = 'Active' ,`StreetName` = 'Nassau' ,`StreetNumber` = '4514' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2929' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTORS ONLY - TENANT OCCUPIED Great North facing 4/2.5/2 home with gleaming pool on a large backyard. This freshly painted home has beautiful hardwood and tile flooring that runs through the entryway, formal dining room, family room & master bedroom. The family room boasts a pretty fireplace and has great views overlooking the backyard and pool. The Island kitchen has new Granite countertops and new tile floor, which opens to the breakfast and family room. This home\'s floorplan is perfect for hosting gatherings and celebrations year-round, and the location couldn\'t be any better. This updated home in the heart of Sugar Land is conveniently located near Hwy 6 with plenty of restaurants, groceries, and big stores. Zoned to highly rated FBISD\'s premier schools including the exemplary Clements High School. Nestled within the tree lined streets of Lakes of Austin Park and enjoy the amenities provided by First Colony including pools, aquatic center, trails, tennis courts, and playgrounds.' ,`Acres` = '0.2206' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKES OF AUSTIN PARK SEC 1 R/P, BLOCK 8, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9611' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '799' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'AUSTIN PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Lakes Of Austin Park Sec 1 R/P' ,`TaxAmount` = '7698' ,`TaxRate` = '2.1594' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105259' WHERE `Matrix_Unique_ID` = '210658226' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-05T20:07:20.337' ,`MLSNumber` = '2159048' ,`ListAgentFullName` = 'Kristen Novicke' ,`ListOfficeName` = 'Texas Trust Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780982' ,`Longitude` = '-96.161741' ,`PhotoCount` = '24' ,`PostalCode` = '77474' ,`RoomCount` = '6' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = '2nd' ,`StreetNumber` = '622' ,`StreetSuffix` = 'Street' ,`City` = 'Sealy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1462' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautifully and completely remodeled home is located right in the heart of Old Sealy! 3 Bedrooms and 2 baths, spacious living and kitchen with new cabinets, large bedrooms, all with very versatile design choices for the remodel. Beautiful new luxury vinyl floors, tile, granite countertops, and paint colors. New siding, paint, electrical and plumbing have also been added. Brand new windows, insulation and exterior paint along with a new water heater and HVAC system. This home is like NEW! The large entryway which leads to the living spaces has so many decorating possibilities. This perfect home is situated near downtown Sealy, schools, churches and city parks. Don\'t miss out on the opportunity to see this home in person!!' ,`Acres` = '0.2135' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SEALY LANDS BLOCK 37 LOT 10 (WEST 1/2 & NORTH 1/2 OF LOT 10)' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SELMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Sealy Lands' ,`TaxAmount` = '2245' ,`TaxRate` = '2.149' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105259' WHERE `Matrix_Unique_ID` = '213279816' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-05T19:48:34.173' ,`MLSNumber` = '47436421' ,`ListAgentFullName` = 'Fred McDaniel' ,`ListOfficeName` = 'Realty ONE Group Iconic' ,`SellingAgentFullName` = 'Tami Shipley Govreau' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '30.801130' ,`Longitude` = '-95.063398' ,`PhotoCount` = '18' ,`PostalCode` = '77351' ,`RoomCount` = '6' ,`ListPrice` = '209000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bluebonnet' ,`StreetNumber` = '176' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don’t miss out on the opportunity to own a great home in the gated neighborhood Cedar Point at Lake Livingston. Never lived in and move in ready! Open floorplan but still cozy. The master suite has double sinks and a walk-in closet. Upgraded kitchen with granite countertops and stainless-steel appliances including refrigerator. Take advantage of the neighborhood amenities: boat launch access to the lake, private fishing pier, pavilion, and community pool! Give us a call today for a private showing.' ,`Acres` = '0.1418' ,`Area` = '44' ,`BuilderName` = 'Century' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'THE MEADOWS SECTION 1 BLK 40 LOT 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '566' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Point' ,`TaxAmount` = '' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675105259' WHERE `Matrix_Unique_ID` = '214067901' --> 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','215160199','1675105260','215160199','2023-01-05T19:53:53.793','7755124','Sherry Capps','Wyatt Real Estate','','','29.402773','-94.907434','26','77590','10','203000.00','Active','19th','901','Avenue','Texas City','3','0','5','2531','Single-Family','Lots of Space! This home features 5 bedrooms, 3 baths with large upstairs game room. Two of the bedrooms have attached baths, one upstairs, one downstairs. Inside large size utility room with washer/dryer hookups. Large corner lot with mature trees in the heart of Texas city. Detached 2 car garage with alley access, front porch, side covered area with lots of room for entertaining.','0.1928','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Texas City','Central Electric','0','ABST 167 D RICHARDSON SUR LOT 10 & E 20 FT OF LOT 9 BLK 458','Corner,Subdivision Lot','8400','Appraisal District','','','0','','2','','0','','','','','Composition','52 - Texas City','ROOSEVELT-WILSON ELEMENTARY SCHOOL','TEXAS CITY HIGH SCHOOL','BLOCKER MIDDLE SCHOOL','Appointment Required','Appraisal District','1.5','Traditional','Texas City','3218','2.5335','Public Sewer,Public Water','1942','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','216073347','1675105260','216073347','2023-01-05T20:05:47.503','61443156','Dolores Quiroga','Prime Realty Group','','','29.826951','-95.283475','30','77028','6','279900.00','Active','Safebuy','7924','Street','Houston','2','0','3','1424','Single-Family','Centrally located near 610 loop, 288 Medical Center, and Downtown for quick commute. Never lived-in new construction. Spacious 3 bedroom 2 full bath. Gas stove included. Breathtaking breakfast bar/granite countertop designed for entertaining. Super clean, modern archways. Recessed can lighting. Pristine tiled showers. Move-in ready. Privacy wood panel fence lines the rear and both sides. Plush yard large enough to host parties or get togethers. Barbecue ready. Manicured lawn boasts picturesque landscaping. Call your agent to book a tour today!','','2','Owner','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Northeast Houston','Central Gas','0','Lot 2 BLK 3 Liberty Road Manor Sec 22 U/R','Subdivision Lot','4000','Appraisal District','','','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','ELMORE ELEMENTARY SCHOOL','KASHMERE HIGH SCHOOL','KEY MIDDLE SCHOOL','Appointment Required,Vacant/Unoccupied','Appraisal District','1','Traditional','Liberty Road Manor','','','Public Sewer,Public Water','2021','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216103988','1675105260','216103988','2023-01-05T20:06:24.537','69806708','Maria Miao','JLA Realty','','','29.555547','-95.619175','50','77479','11','987000.00','Active','Oakville','5403','Court','Sugar Land','5','1','5','5409','Single-Family','This is an absolutely amazing custom designed house located in a cozy cul-de-sac with best schools in Sugar Land: Clements High School, Fort Settlement Middle School and Commonwealth Elementary School. \r\nThe roof and the fence were replaced recently. Two primary bedrooms with spacious bathrooms and large walk-in closets. Beautiful main kitchen with custom hand painted cabinets plus additional kitchen with gas cook top combined with laundry area. There are built-in cabinets for additional clothing and shoes storage which were specially ordered for this house. Stunning staircase lead to the second floor game room with the covered balcony facing back yard. Flooring includes unique marble, tiles, carpets and wood. Crown moldings, base boards, crystal chandeliers, wired sound and recessed lightning in some rooms make this house unique. Dont miss this gorgeous house in one of the finest cozy communities Avalon Meadows of Sugar Land!','0.1468','29','','','Electric Dryer Connections','','Levee District,Sellers Disclosure','1','Gaslog Fireplace','2','Sugar Land South','Central Gas,Zoned','1','AVALON MEADOWS OF AVALON SEC 1, BLOCK 5, LOT 5','Cul-De-Sac','6393','Appraisal District','','1990','0','','3','Electric Oven','0','','','Electric Cooktop','','Composition','19 - Fort Bend','COMMONWEALTH ELEMENTARY SCHOOL','CLEMENTS HIGH SCHOOL','FORT SETTLEMENT MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Contemporary/Modern','Avalon Meadows Of Avalon Sec 1','18651','2.1244','Water District','2004','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','216114866','1675105260','216114866','2023-01-05T19:00:56.350','15022349','Sherry Morris','Compass RE Texas, LLC','','','29.777384','-95.511067','42','77024','28','5750000.00','Active','Beinhorn','11117','Road','Houston','9','3','9','15148','Single-Family','Meticulously designed Classic Mediterranean estate with utmost sophistication and luxury situated on 3/4 acre lot in the heart of Piney Point Village! Step through the dramatic double hand forged iron Cantera doors into a breathtaking formal living room with soaring ceilings with dramatic views of the massive pool through beautifully appointed picture windows. Great for entertaining on a grand scale with its dramatic formal areas, open kitchen/catering kitchen/breakfast and informal tv room that easily flow into a billiard room and outside veranda with a generous summer kitchen. The first floor primary room boasts a sitting area and fireplace, beautifully appointed spa like bathroom with his and hers large walk-in closets. Large secondary room on the first floor and an additional mix use room. Upstairs you will find 7 en-suite secondary bedrooms with additional luxury living spaces that includes a large den with kitchenette, theater, gym, party room, library and nursery/craft room.','0.6763','23','Black Mountain Co.','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','4','Memorial Villages','Central Gas','0','LT 5 GRECIAN WAY','Corner','29460','Appraisal District','','','0','','4','Convection Oven,Double Oven,Gas Oven','1','Gunite,Heated,In Ground','','Gas Cooktop,Gas Range','','Tile','49 - Spring Branch','MEMORIAL DRIVE ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (SPRING BRANCH)','SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)','Accompany,Appointment Required','Builder','2','Mediterranean','Grecian Way','110253','2.1721','Public Sewer,Public Water','2011','Appraisal District'); --> New record created successfully