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-10-14T05:17:12.623' ,`MLSNumber` = '16944113' ,`ListAgentFullName` = 'Kay Harris' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.433252' ,`Longitude` = '-95.437777' ,`PhotoCount` = '47' ,`PostalCode` = '77583' ,`RoomCount` = '12' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Sill Prairie' ,`StreetNumber` = '10402' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2769' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your new home awaits in the highly sought after gated community, Sierra Vista! This amazing home has 4 bedrooms, all generous in size, 2.5 bathrooms & a 3 car garage! The primary bedroom is downstairs & includes a custom paneled accent wall, french doors that lead into the en suite bathroom w/ his/her sinks, a large soaking tub & separate shower, & enormous closet. The Island kitchen is a chef\'s dream & includes stainless steel appliances, granite countertops & 42\" expresso cabinets. There\'s also a computer nook, laundry room w/ custom built-in cabinets & half bath just off the kitchen. The rounded dining area is surrounded by a gorgeous, soaring accent wall w/ art niches. The living room has a 2 story ceiling w/ windows that showcase plenty of natural lighting & the covered patio has an extended concrete slab that can fit an outdoor living room set. Upstairs you\'ll find 3 huge bedrooms, full bathroom w/ dual sinks & a spacious game room. Come and see this beautiful home for yourself!' ,`Acres` = '0.1616' ,`Area` = '5' ,`BuilderName` = 'Castlerock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA SEC 2 (A0288 HT&BRR) BLK 8 LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7039' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista Sec 2' ,`TaxAmount` = '10649' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764572' WHERE `Matrix_Unique_ID` = '212276449' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T05:23:35.817' ,`MLSNumber` = '54196486' ,`ListAgentFullName` = 'Edward McClintick' ,`ListOfficeName` = 'Joseph Walter Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.554591' ,`Longitude` = '-95.077496' ,`PhotoCount` = '16' ,`PostalCode` = '77058' ,`RoomCount` = '6' ,`ListPrice` = '209000.00' ,`Status` = 'Active' ,`StreetName` = 'Starboard' ,`StreetNumber` = '18020' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '2298' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.0689' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 5 BAL HARBOUR COVE R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '3000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '48' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bal Harbour Cove R/P' ,`TaxAmount` = '4929' ,`TaxRate` = '2.4882' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1665764572' WHERE `Matrix_Unique_ID` = '212549613' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T05:11:18.600' ,`MLSNumber` = '57044487' ,`ListAgentFullName` = 'Veronica Alarcon' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Sahar Khatib' ,`SellingOfficeName` = 'Keller Williams Realty -SW' ,`Latitude` = '30.008388' ,`Longitude` = '-95.298847' ,`PhotoCount` = '25' ,`PostalCode` = '77338' ,`RoomCount` = '8' ,`ListPrice` = '220000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Heaton Hall' ,`StreetNumber` = '8311' ,`StreetSuffix` = 'Street' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1360' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Older home with tons of character and updated to fit a modern boho vibe! Sellers have spent a lot of time and money in making this home feel new and updated! Ask your realtor for the list of updates in attachments! Comes see this gorgeous gem on a large corner lot! The sky is the limit with what you can do with this space!! Long Living room and huge backyard! Community Pool and tennis courts. Schedule a tour today!!\r\n**Room sizes to be verified by buyer** 2019 Water Heater replaced / 2020 AC Unit replaced / 2021 New Roof installed (full updates available in attachments).' ,`Acres` = '0.2166' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 KENSWICK SEC 1 R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '9433' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JONES ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kenswick Sec 01 R/P' ,`TaxAmount` = '3504' ,`TaxRate` = '2.7433' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764572' WHERE `Matrix_Unique_ID` = '212625735' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T05:05:37.230' ,`MLSNumber` = '22222528' ,`ListAgentFullName` = 'Alma Chavez' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.915514' ,`Longitude` = '-95.159173' ,`PhotoCount` = '34' ,`PostalCode` = '77044' ,`RoomCount` = '12' ,`ListPrice` = '394900.00' ,`Status` = 'Active' ,`StreetName` = 'Slate Mountain' ,`StreetNumber` = '13710' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3197' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Meticulously well-maintained home on a quiet cul-de-sac lot that backs to Duessen Park, tons of trails, & quick access to Lake Houston & SH Toll. The curb appeal begins w/ a low-maintenance lawn, fresh landscaping, solar attic fan, cozy covered porch, & stylish brick/stone elevation. Inside find an open floor plan layout that features tile flooring, high ceilings, crown molding, & stunning archways throughout. A dedicated home office w/ wood floors & a half bath lead into the large eat-in kitchen w/ TONS of cabinet storage, granite counters, SS appliances, water softener & a Closets By Design pantry. Next, find the dining area that opens to the inviting living room w/ a fireplace. The 1st-floor primary includes a dual vanity en-suite bath & walk-in closet. Upstairs find a NEW carpet/flooring, study nook, game room, & 3 additional bedrooms & a full bath. Don\'t forget to check out the private, fully fenced backyard w/ a covered patio & all the space you need for outdoor entertaining.' ,`Acres` = '0.1697' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 55 BLK 2 SUMMERWOOD SEC 24 AMEND' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7394' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '927' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Summerwood' ,`TaxAmount` = '8700' ,`TaxRate` = '2.8532' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764572' WHERE `Matrix_Unique_ID` = '212693355' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T04:48:33.130' ,`MLSNumber` = '44905470' ,`ListAgentFullName` = 'Janet White' ,`ListOfficeName` = 'Alliance Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766430' ,`Longitude` = '-94.968581' ,`PhotoCount` = '40' ,`PostalCode` = '77521' ,`RoomCount` = '9' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Briarclift' ,`StreetNumber` = '601' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1843' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on the market and move-in ready! Recently remodeled 3-2-2 home in well established neighborhood. Kitchen remodeled in 2021 with open concept and large walk-in pantry. Oversized laundry room has in-the-wall ironing board and plenty of room for sewing machine or other crafts. Cathedral ceiling in den with double french-doors gives access to covered back patio. Primary bath has beautiful large shower complete with modern tile, bench seat and rain-shower head. Pex water lines, A/C ducts and hot water heater all replaced in 2021. Back sidewalk and extended patio recently added and finished with stamped concrete. Extra driveway/parking area on south side of garage provides plenty of room for all your vehicles and toys. Outside freshly painted. Fence recently replaced beside garage with new double wide gate. Home is complete with granite in kitchen and bathrooms. Two attic storage areas are included, one in the house and one in the garage. Storage building remains.' ,`Acres` = '0.1977' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 5 ALLENBROOK SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'English' ,`Subdivision` = 'Allenbrook Sec 03' ,`TaxAmount` = '4982' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764573' WHERE `Matrix_Unique_ID` = '213042646' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T05:49:56.283' ,`MLSNumber` = '34413332' ,`ListAgentFullName` = 'Kirsten Abney' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.739669' ,`Longitude` = '-95.363603' ,`PhotoCount` = '36' ,`PostalCode` = '77004' ,`RoomCount` = '11' ,`ListPrice` = '464900.00' ,`Status` = 'Active' ,`StreetName` = 'Hutchins' ,`StreetNumber` = '2520' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2808' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This well-designed patio home is privately situated in a small & well maintained, gated community. The home features high ceilings, amazing natural light, neutral finishes, & spacious rooms. A 2nd floor open concept living space offers hardwood floors & can accommodate multiple arrangements w/ oversized furniture. The well-appointed kitchen features granite counters, a large island w/ breakfast bar & built-in sink, stainless steel appliances, great counter space, ample storage, & a walk-in pantry. An oversized primary retreat, located on the 3rd floor, offers high ceilings, & great natural light. The spa-like primary bath features granite counters, dual sinks, walk-in shower, soaking tub, a private water closet, & large walk-in closet. The 1st & 4th floors include guest bedrooms w/ ensuite baths & walk-in closets. A loft area completes the 4th floor space. Conveniently located to downtown, this home is close to many of the best dining & entertainment venues Houston has to offer.' ,`Acres` = '0.0327' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 HUTCHINS STREET VILLAS' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1425' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'Traditional' ,`Subdivision` = 'Hutchins Street Villas' ,`TaxAmount` = '8969' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764573' WHERE `Matrix_Unique_ID` = '213060401' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T05:44:10.340' ,`MLSNumber` = '40662358' ,`ListAgentFullName` = 'Diana Macedo' ,`ListOfficeName` = 'MRG Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816079' ,`Longitude` = '-95.508407' ,`PhotoCount` = '48' ,`PostalCode` = '77080' ,`RoomCount` = '6' ,`ListPrice` = '540000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Kolbe' ,`StreetNumber` = '8734' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 8734 Oak Kolbe Ln! A beautiful lush 2-story home with an open concept living area that flows effortlessly to your stunning new kitchen with tons of gorgeous quartzite countertop space and Shiloh cabinets (soft close). The high ceilings and the Low-E windows throughout the house provide you with the right amount of natural light. The sprawling primary suite includes a large custom walk-in closet by California Closets, a spacious ensuite bathroom with a resort style tub and double vanity. Enjoy relaxed evenings in your private master bedroom balcony. Home is situated in a prime location within the community near the lake with jogging and walking trails. There is nothing like Kolbe Farms – Urban Farmhouse Architecture! Community amenities include adult and kids pool, dog park, jogging and walking trails. Contact us today for your private tour!' ,`Acres` = '0.0478' ,`Area` = '24' ,`BuilderName` = 'InTown Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 4 KOLBE FARMS' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '2080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'EDGEWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Ranch,Traditional' ,`Subdivision` = 'Kolbe Farms Sub' ,`TaxAmount` = '9885' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764573' WHERE `Matrix_Unique_ID` = '213266677' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T05:30:38.697' ,`MLSNumber` = '92551061' ,`ListAgentFullName` = 'Nhan Vu' ,`ListOfficeName` = 'Kinh Do Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.906498' ,`Longitude` = '-95.545062' ,`PhotoCount` = '50' ,`PostalCode` = '77064' ,`RoomCount` = '9' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Daisy Cove' ,`StreetNumber` = '9211' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2672' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2-story home features 4 bedrooms, 3 full baths,1 half bath located in cy-fair schools, low taxes and HOA. It has 2 primary bedrooms (1 downstair, 1 upstairs), large family room with high ceilings and tons of natural light and formal dining. The upstairs are 3 bedrooms, two full bathrooms and a spacious game room. The kitchen with granite countertops and stainless steel appliances open to family room. Sprinkler system, fresh paint throughout, new carpet and primary bathroom with dual sinks, separate tub and shower. You will enjoy with a relaxing front porch, covered back patio and garage with AC unit plus epoxy flooring. One owner, well maintained and NEVER FLOOD. Easy access to Beltway8, hwy290 and 249, shopping malls and super markets. Schedule your showing today.' ,`Acres` = '0.1263' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 3 WESTWOOD GARDENS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'GLEASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Gardens 1' ,`TaxAmount` = '6854' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764573' WHERE `Matrix_Unique_ID` = '213474390' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T05:38:55.020' ,`MLSNumber` = '7257099' ,`ListAgentFullName` = 'Kerri Canales' ,`ListOfficeName` = '316 Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072408' ,`Longitude` = '-95.406509' ,`PhotoCount` = '9' ,`PostalCode` = '77373' ,`RoomCount` = '4' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Foxbriar' ,`StreetNumber` = '25507' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1868' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home has been well cared for over the years and has many upgrades. The roof was replaced in 2017, new A/C in 2020, all windows replaced with energy efficient double pane windows, gutters installed, and kitchen remodeled. Kitchen remodel includes new cabinets with quartz countertops, and new appliances including gas line installed for gas cooktop. The bathrooms have been remodeled and house was freshly painted in 2020. Laundry room is in the house. This beautiful home has all the amenities of city living tuck away in a quiet neighborhood. Pack your bags this house is a move in ready!' ,`Acres` = '0.2101' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 5 LEXINGTON WOODS SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '395' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'JOHN WINSHIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lexington Woods Sec 01' ,`TaxAmount` = '3438' ,`TaxRate` = '2.2769' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764573' WHERE `Matrix_Unique_ID` = '213557209' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T04:34:33.550' ,`MLSNumber` = '17002884' ,`ListAgentFullName` = 'Lee Kaplan' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.711370' ,`Longitude` = '-95.422926' ,`PhotoCount` = '46' ,`PostalCode` = '77005' ,`RoomCount` = '10' ,`ListPrice` = '2450000.00' ,`Status` = 'Active' ,`StreetName` = 'Brompton' ,`StreetNumber` = '6443' ,`StreetSuffix` = 'Road' ,`City` = 'West University Place' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5970' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous West University home on a 9,000 sf lot (HCAD) on a prime block on beautiful Brompton! Desirable 6400 block. Luxurious pool and backyard oasis with holly trees, and veranda. Rare five bedroom floor plan, gameroom, study, formals, gorgeous Chef\'s Kitchen open to Den with French doors and pool views. Beautiful Primary Suite, remodeled marble bath; bedroom connects to Private Study. Clay tile roof, recent hardwoods, 2019-2021 HVAC, so many seller updates/upgrades. Don\'t miss this special home with everything on your wish list!' ,`Acres` = '0.2066' ,`Area` = '17' ,`BuilderName` = 'Heritage' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 1D & 2B BLK 19 WEST UNIVERSITY PLACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'West University Place Sec 01' ,`TaxAmount` = '42228' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665764573' WHERE `Matrix_Unique_ID` = '213590520' --> 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','213636561','1665764574','213636561','2022-10-14T05:57:25.667','28206384','Sarah Steinkopf','JLA Realty','','','29.820287','-94.981131','19','77521','9','259900.00','Active','Taro','8323','Lane','Baytown','2','1','4','2702','Single-Family','PRICED TO SELL QUICKLY!! This beautiful property WON\'T LAST LONG! The primary bedroom is downstairs, along with a half bath, laundry room, and more. All other bedrooms are upstairs, along with the HUGE game room and a full bath. NEW ROOF installed July 2022, home has been kept in immaculate condition! It\'s a blank slate ready for it\'s new home owners to make it their own! This neighborhood has a park with walking trails around the lake. Easy access to i-10, and has NEVER FLOODED!','0.1584','2','','','','','Mud,Sellers Disclosure','1','','1','Baytown/Harris County','Central Gas','1','LT 19 SPRINGFIELD ESTATES SEC 1 AMND','Subdivision Lot','6900','Appraisal District','','340','0','','2','Single Oven','0','','','','','Composition','23 - Goose Creek Consolidated','VICTORIA WALKER ELEMENTARY SCHOOL','GOOSE CREEK MEMORIAL','HIGHLANDS JUNIOR HIGH SCHOOL','Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Springfield Estates Sec 01','6854','3.095','Public Sewer,Public Water','2005','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','213637291','1665764574','213637291','2022-10-14T05:48:59.517','5361158','Jovany Trujillo','RE/MAX RESULTS','','','29.388803','-94.976297','12','77591','3','120000.00','Active','Woodrow','5714','Street','Texas City','1','0','3','1024','Single-Family','Great fixer-upper 3 Bedroom 2 bath ready for you to make it your own!!! This property has a great location and could be a great flip or first home for some one!!! Schedule your private showing today!!!','0.1263','33','','','','','Sellers Disclosure','','','','Texas City','No Heating','0','ABST 125 T W JOHNSON SUR LOT 10 NORTH OAK SUB','Subdivision Lot','5500','Appraisal District','','','0','','0','','0','','','','','Composition','52 - Texas City','SIMMS ELEMENTARY SCHOOL','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL (TEXAS CITY)','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','North Oak','2948','2.582','Public Sewer,Public Water,Water District','1980','Appraisal District'); --> New record created successfully