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` = '2022-12-12T08:35:45.440' ,`MLSNumber` = '20495179' ,`ListAgentFullName` = 'Monique Burks' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.651353' ,`Longitude` = '-95.671106' ,`PhotoCount` = '24' ,`PostalCode` = '77498' ,`RoomCount` = '4' ,`ListPrice` = '318900.00' ,`Status` = 'Active' ,`StreetName` = 'Ginger Run' ,`StreetNumber` = '16315' ,`StreetSuffix` = 'Way' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2373' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious 4 bedroom. All bedrooms up have plenty of room with a large upstairs master and bath. Home has large kitchen with eat in breakfast. Plenty of cabinets for storage in kitchen and granite counter tops. Kitchen has a large window seat. Kichen is open to family room that has a fireplace. There is a full bath with shower only and a laundry area that is by garage door. Outlets for washer and dryer were turned to be in garage can be modified back to indoor laundry space, presently used as closet. Home has formal living and dining with high ceilings. Back has a large, covered patio and a shed. Plenty of space in backyard for gardening. Home is located on a cul-de-sac and is near Oyster Creek Elementary, Austin High School, Aliana, shops, restaurants and so much more. Easy access to Hwy 6, 59, I-10. This Sugar Land home is great for a family and ready to be yours.' ,`Acres` = '0.1462' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VILLAGE OF OAK LAKE R/P, BLOCK 3, LOT 51' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6368' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '462' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OYSTER CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Of Oak Lake R/P' ,`TaxAmount` = '4885' ,`TaxRate` = '2.2529' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090173' WHERE `Matrix_Unique_ID` = '210080589' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T07:47:57.403' ,`MLSNumber` = '18236929' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Alfredo Sabal' ,`SellingOfficeName` = 'Krueger Real Estate' ,`Latitude` = '29.773000' ,`Longitude` = '-94.682696' ,`PhotoCount` = '16' ,`PostalCode` = '77514' ,`RoomCount` = '11' ,`ListPrice` = '294990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Big Sandy' ,`StreetNumber` = '137' ,`StreetSuffix` = 'Lane' ,`City` = 'Anahuac' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning New D. R. Horton One Story Ranch Home Under Construction! The Cali Plan! Upgraded Brick Elevation on a Huge Lot! Large Covered Patio! Grand Entry with High Ceilings! Amazing Carefree Vinyl Like Wood Floors throughout! The Outstanding Family Area has a Wall of Windows looking out to your Patio, High Ceilings all that flows into the Gourmet Kitchen & Casual Dining Area! Gourmet Kitchen has Beautiful Tall Cabinets, Tile Backsplash, Stainless Steel Appliances, Huge Eat In Working Station Island, Gorgeous Granite Counters, Undermount Sink, Walk In Pantry & More! Primary Suite tucked away from all Guest Bedrooms Features High Ceilings, Plush Carpet, Luxurious Bathroom with His & Her Private Sink Vanity, Granite Countertops, Soaker Tub, Seamless Glass Shower, Huge Walk In Closet! Two Guest Bedrooms tucked away & Full Bathroom W/Granite Countertops & More! Low Tax Rate! No Flooding! Close to the Bay, & along the banks of the Trinity River for all your Outdoor Water Fun & More!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Cypress Point: lot 9 /Block 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '15360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '4 - Anahuac' ,`SchoolElementary` = 'ANAHUAC ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANAHUAC HIGH SCHOOL' ,`SchoolMiddle` = 'ANAHUAC MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Cypress Point' ,`TaxAmount` = '' ,`TaxRate` = '2.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090173' WHERE `Matrix_Unique_ID` = '210706269' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T07:48:19.693' ,`MLSNumber` = '18225519' ,`ListAgentFullName` = 'Angela Angers' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.261206' ,`Longitude` = '-95.133525' ,`PhotoCount` = '49' ,`PostalCode` = '77372' ,`RoomCount` = '8' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'King Oak' ,`StreetNumber` = '12760' ,`StreetSuffix` = 'Drive' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large 5-bedroom open concept house w/pool that sits on 1.071 acres in Splendora ISD. Amazing for entertaining. HUGE front porch welcomes you to large living area w/rock fireplace that is open to kitchen. There is large island in kitchen w/ 9 bar stools that stay, new double oven, & new dishwasher. Crown molding throughout. Back patio w/big above ground pool. Primary bedroom has built-in shelving and ensuite bathroom w/double sinks & separate tub & shower, & large closet. There is a hookup and septic for RV or can be used for building or small business since property does not have restrictions against having a business. Separate building used currently as a man cave/she shed w/ sink, AC, 16x10 porch. Newer carpet, newer AC unit & duct work warrantied until 2026. spray foam under the home, floors are all plywood and newer laminate in some rooms. The yard has been landscaped and meticulously maintained. Alarm system currently leased through ADT that can stay, security lights all around,' ,`Acres` = '1.071' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S889300 - SOUTHERN CROSSING 01, LOT 12-B, 13, SERIAL # HOTX0' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '46653' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'GREENLEAF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southern Crossing 01' ,`TaxAmount` = '1695' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090174' WHERE `Matrix_Unique_ID` = '211414440' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T07:57:54.163' ,`MLSNumber` = '66593631' ,`ListAgentFullName` = 'Dan Harvey' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.198649' ,`Longitude` = '-94.381368' ,`PhotoCount` = '27' ,`PostalCode` = '77625' ,`RoomCount` = '3' ,`ListPrice` = '149500.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 421' ,`StreetNumber` = '15543' ,`StreetSuffix` = 'Road' ,`City` = 'Kountze' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make the 2 acre property your retreat from the hustle and bustle of the city. Located just outside of Sour Lake, this home is ready to be made your own with a remodel of the homestead. Great opportunity for an investment or a rehab and occupy.' ,`Acres` = '2' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'AB 508 WC RR P# 508-40-A I# 1426/238' ,`LotDesciption` = 'Other' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'SOUR LAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'n/a' ,`TaxAmount` = '1138' ,`TaxRate` = '1.8384' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090174' WHERE `Matrix_Unique_ID` = '213633177' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T08:26:02.190' ,`MLSNumber` = '95027572' ,`ListAgentFullName` = 'Brandy Mayr' ,`ListOfficeName` = 'RE/MAX Universal Northwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.243018' ,`Longitude` = '-95.896447' ,`PhotoCount` = '32' ,`PostalCode` = '77484' ,`RoomCount` = '3' ,`ListPrice` = '739000.00' ,`Status` = 'Active' ,`StreetName` = 'Round Up' ,`StreetNumber` = '17752' ,`StreetSuffix` = '' ,`City` = 'Waller' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2835' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning custom built home is tucked away on 1 acre and features beautiful mature trees. A countryside residence is your escape that provides the privacy you are looking for. This one story Austin Limestone/brick home is the perfect residence for family living and/or entertainment. The home features custom-made cabinets and built ins throughout. The spacious kitchen is a dream with granite countertops, stainless steel appliances, farmhouse sinks, huge island and a double oven. Open floorplan into the the main living room with it\'s high ceiling, beautiful wood beam and fireplace. Lots of large windows/natural light looking towards backyard. Barn doors lead into the study. The very private Primary Bed/bath is AMAZING. The large walk-in shower is extraordinary as is the beautiful separate bathtub. Granite countertops and built ins in primary closet. Enjoy outdoor country living year round on large covered back patio. This residence/property in Waller, TX is one of a kind!' ,`Acres` = '' ,`Area` = '60' ,`BuilderName` = 'Rvision Homes Ltd' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Plantersville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S7644 - SADDLE CREEK FOREST SEC. 4, BLOCK 6, LOT 6, ACRES 1.' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '65340' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '775' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'HIGH POINT ELEMENTARY SCHOOL (Navasota)' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'SADDLE CREEK FOREST' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090174' WHERE `Matrix_Unique_ID` = '213793518' --> 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','215008321','1675090174','215008321','2022-12-12T08:22:01.083','67537593','Pamela Brooks','Paula Mutina Properties','','','29.180631','-95.421364','9','77515','3','199900.00','Active','Wimberly','1000','Street','Angleton','2','0','3','1671','Single-Family','Fantastic 3-2-2 close to everything. This home features disability access from all entrances to the home and has special modifications in the primary bathroom for disabled access. Home has a large primary bedroom and an open living and kitchen area, second living room, covered patio and large fenced back yard. Convenient to schools, post office, police department and shopping.','0.1848','5','','','Electric Dryer Connections','','Sellers Disclosure','1','','0','Angleton','Central Electric','0','CHEVY CHASE #3 (ANGLETON) BLK 2 LOT 25','Subdivision Lot','8050','Appraisal District','','','0','','','Electric Oven','0','','','Electric Range','','Composition','5 - Angleton','NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)','ANGLETON HIGH SCHOOL','ANGLETON MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Chevy Chase #3 Angleton','4413','2.6102','Public Sewer,Public Water','1951','Appraisal District'); --> New record created successfully