Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>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)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-17T08:40:38.033' ,`MLSNumber` = '17358358' ,`ListAgentFullName` = 'Christina Boston' ,`ListOfficeName` = 'Boston Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.956006' ,`Longitude` = '-95.631336' ,`PhotoCount` = '35' ,`PostalCode` = '77429' ,`RoomCount` = '3' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Huffmeister' ,`StreetNumber` = '12523' ,`StreetSuffix` = 'Road' ,`City` = 'Cypress' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1266' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique unrestricted home situated on just under a half on an acre, it\'s both secluded & private yet properly poised with excellent frontage if a business is your desire. This cozy home has been well cared for and owner occupied while Cypress grew up around it. Zoned to exceptional CFISD Schools this truly is a great place to live/work or live/small farm, live/store your RV, or whatever you can imagine. Having an unrestricted property is a lovely freedom. This home has never flooded in its structure and the property/well/utility house only took in water during Harvey *per the Seller, who also notes that the well was replaced after Harvey. **Do not disturb occupant for any reason** Appointments must be made through licensed Realtors with advance approval only so schedule your appointment today for a private viewing of this one-of-a-kind property that\'s close to the city but feels like you\'re in the country!' ,`Acres` = '0.4449' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 3 BLK 1 CYPRESS CREEK PLAZA' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '19378' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Cypress Creek Plaza' ,`TaxAmount` = '2386' ,`TaxRate` = '2.091' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675092055' WHERE `Matrix_Unique_ID` = '206176891'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-17T08:26:16.953' ,`MLSNumber` = '87842453' ,`ListAgentFullName` = 'Arnold Magana' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.759439' ,`Longitude` = '-95.217525' ,`PhotoCount` = '35' ,`PostalCode` = '77015' ,`RoomCount` = '6' ,`ListPrice` = '168000.00' ,`Status` = 'Active' ,`StreetName` = 'Strick' ,`StreetNumber` = '12405' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1375' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedroom 2 bath home ready for your updates. Nice Corner lot. Large covered patio in the front of the home. Large dining room/kitchen with side entry. Tile throughout entire home. Utility room outside at rear of home. Extra driveway and parking. Sold As Is (seller will make no repairs). A new elementary school to be completed by 2023 is being built around the corner from this location. ' ,`Acres` = '0.1594' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 36 BLK 10 WOODLAND ACRES ANNEX SEC 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6944' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'PYBURN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GALENA PARK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODLAND ACRES MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Acres Annex Sec 05' ,`TaxAmount` = '3501' ,`TaxRate` = '2.7702' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675092056' WHERE `Matrix_Unique_ID` = '208255821'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-17T07:36:30.357' ,`MLSNumber` = '80800384' ,`ListAgentFullName` = 'Tirath Khera' ,`ListOfficeName` = 'Khera Interest, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780463' ,`Longitude` = '-95.358918' ,`PhotoCount` = '28' ,`PostalCode` = '77009' ,`RoomCount` = '11' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = 'Fulton' ,`StreetNumber` = '2112' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '1722' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT OPPORTUNITY HOME, IN THE CENTER OF HOUSTON, MINUTES FROM DOWNTOWN, WALKING DISTANCE FROM THE METRO RAIL, ONE OF THE BIGGEST LOTS IN THE NEIGHBORHOOD, TWO-BUILDING, THE FRONT BUILDING IS A TWO-UNIT APARTMENT WITH TWO BEDROOMS AND 1 BATH EACH UNIT, TWO ELECTRICAL METERS, UNIT ON THE REAR IS A TWO BEDROOMS, BUILT IN 2002, CENTRAL AIR AND HEAT, TWO CAR GARAGE, AND 1 BATH.' ,`Acres` = '0.1722' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 58-B ALLEN A C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KETELSEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Allen A C' ,`TaxAmount` = '5386' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675092056' WHERE `Matrix_Unique_ID` = '208329967'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-17T08:19:28.697' ,`MLSNumber` = '44567604' ,`ListAgentFullName` = 'Toi Glover' ,`ListOfficeName` = 'MJR Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.992384' ,`Longitude` = '-95.582125' ,`PhotoCount` = '19' ,`PostalCode` = '77422' ,`RoomCount` = '3' ,`ListPrice` = '164900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 510f' ,`StreetNumber` = '20310' ,`StreetSuffix` = '' ,`City` = 'Brazoria' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1236' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly Renovated home with 3 bedrooms 1 1/2 Baths and a BONUS room!!! NEW CARPET THROUGHOUT! FRESH INTERIOR PAINT! KITCHEN CONSISTS OF NEW BUTCHER BLOCK COUNTERTOPS AND PAINTED CABINETS! NEW TILE IN RESTROOMS/BONUS ROOM! NEW DISHWASHER AND WATER HEATER!! NEW LIGHT FIXTURES THROUGHOUT! NICE SIZED LOT WITH NO RESTRICTIONS!! COME CHECK IT OUT!!' ,`Acres` = '0.1791' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HOLIDAY SHORES (A0092 JNO MCNELL), BLOCK 29, LOT 1 SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7802' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Holiday Shores' ,`TaxAmount` = '1265' ,`TaxRate` = '1.6567' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675092056' WHERE `Matrix_Unique_ID` = '211161200'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-17T08:33:40.667' ,`MLSNumber` = '39633597' ,`ListAgentFullName` = 'Kiesha Youens' ,`ListOfficeName` = 'Van Slyke Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.640015' ,`Longitude` = '-96.891193' ,`PhotoCount` = '45' ,`PostalCode` = '78956' ,`RoomCount` = '4' ,`ListPrice` = '2500000.00' ,`Status` = 'Active' ,`StreetName` = 'Vacek Loop' ,`StreetNumber` = '2434' ,`StreetSuffix` = '' ,`City` = 'Schulenburg' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2988' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare Find for Fayette County, turn key one story Custom Home amongst century old Live Oak trees! \r\nThis 50 acre Ranch has 30x44 Workshop/ Barn, Large Pond, Views for Miles, and ag exemption in place. \r\nThe Home sits down its own private road hidden from the entrance and perfectly placed on the ranch to watch the abundance of wildlife, sunrises and sunsets.\r\nThe Home has been meticulously maintained by the original owners and is being sold with all appliances and most furniture (if desired). The 4 bedroom 3.5 bath home is a split floorplan with  the Huge master suite on one side with the other bedrooms on the other side.  The large open floor plan  living/kitchen has windows and french doors so that the views on this amazing property can be admired from everywhere.\r\nThis Ranch is less than 10 minutes from Interstate 10 , providing easy access to Houston, Austin or San Antonio (approx 1.5 hours away)' ,`Acres` = '' ,`Area` = '69' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '-ABS A096 TAYLOR T LG,.5 ACRES,HSE, GAR,PMPHSEABS A0' ,`LotDesciption` = 'Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '207 - Schulenburg' ,`SchoolElementary` = 'SCHULENBURG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCHULENBURG SECONDARY SCHOOL' ,`SchoolMiddle` = 'SCHULENBURG SECONDARY SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Schulenburg' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675092056' WHERE `Matrix_Unique_ID` = '211761853'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-17T08:10:56.657' ,`MLSNumber` = '16805725' ,`ListAgentFullName` = 'Alejandro Ortiz' ,`ListOfficeName` = 'RE/ImageProperties and Investm' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.081668' ,`Longitude` = '-95.777497' ,`PhotoCount` = '35' ,`PostalCode` = '77447' ,`RoomCount` = '4' ,`ListPrice` = '314000.00' ,`Status` = 'Active' ,`StreetName` = 'Baltic Rain' ,`StreetNumber` = '21111' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Price to sell! Home sits on over 12,000 sqft lot, spacious 4 bedrooms and 2.5 baths. Kitchen over looks living area. Kitchen features granite countertop, beautiful backsplash, and new appliances.' ,`Acres` = '0.2819' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 4 BAUER LANDING SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '12279' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bauer Landing' ,`TaxAmount` = '7075' ,`TaxRate` = '2.8556' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675092057' WHERE `Matrix_Unique_ID` = '212281960'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-17T08:10:29.297' ,`MLSNumber` = '2916882' ,`ListAgentFullName` = 'Alejandro Ortiz' ,`ListOfficeName` = 'RE/ImageProperties and Investm' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.915704' ,`Longitude` = '-95.065374' ,`PhotoCount` = '32' ,`PostalCode` = '77532' ,`RoomCount` = '10' ,`ListPrice` = '318900.00' ,`Status` = 'Active' ,`StreetName` = 'Pequin' ,`StreetNumber` = '410' ,`StreetSuffix` = 'Road' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2513' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home features high ceiling, game room, a study, large kitchen with 42\" birch cabinetry, master walk-in closet and dual sinks.  Beautiful home not to be missed.' ,`Acres` = '0.1136' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 3 CROSBY VILLAGE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Crosby Village' ,`TaxAmount` = '5450' ,`TaxRate` = '2.5468' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675092057' WHERE `Matrix_Unique_ID` = '212653380'  --> Updated record success<br />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','215613310','1675092057','215613310','2022-12-17T07:35:51.857','79370237','Jeremiah Nassif','Advantage Realty','','','29.483415','-95.216480','20','77546','8','589900.00','Active','Daytona','2402','Court','Friendswood','3','1','5','3626','Single-Family','Located off of 528 in the highly desirable Boca Raton subdivision in FISD. Enjoy the view all around from the many windows in this 5 bedroom, 3.5 bath, 2-story home. Completely renovated home with new windows, A/C, roof, water heaters, kitchen cabinets, farm house sink, SS appliances, paint, Wood Plank Tiles, Carpet, walk-in shower, and fences. Huge backyard with a Large pool that was just re-plastered, makes it easy to throw a party or relax after work.','0.4146','33','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Friendswood','Central Gas','1','ABST 645 G PATTERSON SUR LOT 7 BLK 1 BOCA RATON SEC 1','Cul-De-Sac,Subdivision Lot','18060','Appraisal District','','180','0','','3','','1','Gunite,In Ground','','','','Composition','20 - Friendswood','CLINE ELEMENTARY SCHOOL','FRIENDSWOOD HIGH SCHOOL','FRIENDSWOOD JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Contemporary/Modern','Boca Raton Sec 1 93','11290','2.2025','Public Sewer,Public Water','1993','Appraisal District');  --> New record created successfully<br />