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-11-23T21:20:34.317' ,`MLSNumber` = '54118730' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.655556' ,`Longitude` = '-95.476238' ,`PhotoCount` = '30' ,`PostalCode` = '77035' ,`RoomCount` = '3' ,`ListPrice` = '296000.00' ,`Status` = 'Active' ,`StreetName` = 'Endicott' ,`StreetNumber` = '11511' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1832' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedroom, 2 bathroom stunner in Houston! The kitchen boasts generous counter space and a breakfast bar, making cooking and entertaining a delight. Discover a bright interior with neutral floors and plush carpet in all the right places. The primary bedroom features plush carpet, a spacious closet, and a private bathroom. Lush green landscape surrounds this beautiful house. Hurry, this won’t last long!\r\n\r\nThis home has been virtually staged to illustrate its potential.' ,`Acres` = '0.2642' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 54 WESTBURY SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11510' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbury Sec 03' ,`TaxAmount` = '5949' ,`TaxRate` = '2.4994' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669641810' WHERE `Matrix_Unique_ID` = '201032058' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T21:21:14.780' ,`MLSNumber` = '66328659' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.717878' ,`Longitude` = '-95.663481' ,`PhotoCount` = '17' ,`PostalCode` = '77082' ,`RoomCount` = '3' ,`ListPrice` = '256000.00' ,`Status` = 'Active' ,`StreetName` = 'Manfield' ,`StreetNumber` = '15822' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1928' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic home in sought after Houston location. Fully equipped eat-in kitchen includes ample cabinets, breakfast bar and generous counter space. Flow into the living room featuring a cozy fireplace, perfect for entertaining. The primary bedroom features a plush carpet, sizable closet and a private bathroom. Lush green landscape surrounds this beautiful house. A must see!\r\nThis home has been virtually staged to illustrate its potential.' ,`Acres` = '0.2211' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 3 FORESTVIEW SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9630' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '97' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'REES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forestview Sec 03' ,`TaxAmount` = '4202' ,`TaxRate` = '2.4343' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669641810' WHERE `Matrix_Unique_ID` = '201199299' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T21:19:32.590' ,`MLSNumber` = '766733' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.595207' ,`Longitude` = '-95.112399' ,`PhotoCount` = '17' ,`PostalCode` = '77059' ,`RoomCount` = '3' ,`ListPrice` = '237000.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory Knoll' ,`StreetNumber` = '16218' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming 3 bedroom, 2 bathroom home is now on the market! Fully equipped eat-in kitchen includes updated counters, and white cabinets. Entertaining is a breeze with this great floor plan complete with cozy fireplace. Relax in your primary suite, complete with a walk-in closet, and an en-suite bathroom with double sinks. Relax with your favorite drink in the fenced in backyard with a patio, lush grass, and great potential for adding personal touches. Don\'t miss this incredible opportunity. Call today!\r\n\r\nThis home has been virtually staged to illustrate its potential.' ,`Acres` = '0.1708' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 59 MIDDLEBROOK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '445' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ARMAND BAYOU ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Middlebrook Sec 01' ,`TaxAmount` = '5127' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669641810' WHERE `Matrix_Unique_ID` = '203895727' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T21:20:54.190' ,`MLSNumber` = '55888816' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.672259' ,`Longitude` = '-95.738607' ,`PhotoCount` = '38' ,`PostalCode` = '77407' ,`RoomCount` = '5' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Gemstone Park' ,`StreetNumber` = '5531' ,`StreetSuffix` = 'Road' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2789' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this charming home now on the market! The kitchen is equipped with ample cabinets, center island, breakfast bar and generous counter space. Entertaining is a breeze with this great floor plan complete with a cozy fireplace, Relax in your primary suite, complete with a sizable closet and an en-suite bathroom with dual sinks. Relax with your favorite drink in the fenced in backyard. Hurry, this won’t last long! This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.1669' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FIELDSTONE SEC 2, BLOCK 1, LOT 42' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7273' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OAKLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fieldstone Sec 2' ,`TaxAmount` = '7495' ,`TaxRate` = '2.8429' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669641811' WHERE `Matrix_Unique_ID` = '204946805' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T21:20:13.710' ,`MLSNumber` = '46370191' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.844156' ,`Longitude` = '-95.476444' ,`PhotoCount` = '27' ,`PostalCode` = '77092' ,`RoomCount` = '3' ,`ListPrice` = '303000.00' ,`Status` = 'Active' ,`StreetName` = 'Spruce Forest' ,`StreetNumber` = '5838' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1701' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic home in sought after Houston location. Fully equipped eat-in kitchen includes white cabinets, breakfast bar and generous counter space. Step inside this beautiful interior with neutral floors, plenty of natural light and neutral palette. The primary bedroom features plush carpet, a spacious closet and a private bathroom with dual sinks. Head to the backyard for the perfect private area to enjoy the outdoors. A must see! This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.1641' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 86 BLK 4 FOREST WEST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7148' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '197' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest West Sec 01' ,`TaxAmount` = '6807' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669641811' WHERE `Matrix_Unique_ID` = '205182480' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T21:19:52.713' ,`MLSNumber` = '10860432' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812610' ,`Longitude` = '-95.732242' ,`PhotoCount` = '36' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '309000.00' ,`Status` = 'Active' ,`StreetName` = 'Fort Stockton' ,`StreetNumber` = '3019' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2470' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your dream home is waiting just for you in Katy! The kitchen boasts generous counter space and a breakfast bar, making cooking and entertaining a delight. Flow into the living room featuring a cozy fireplace, perfect for entertaining. The primary bedroom features plush carpet, a spacious closet, and a private bathroom with dual sinks. Head to the backyard for the perfect private area to enjoy the outdoors. A must see! This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.1475' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 5 SUNDOWN GLEN SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6425' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '264' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'STEPHENS ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MORTON RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sundown Glen Sec 02 R/P' ,`TaxAmount` = '6541' ,`TaxRate` = '2.9983' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669641811' WHERE `Matrix_Unique_ID` = '205458664' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T21:52:31.500' ,`MLSNumber` = '85443912' ,`ListAgentFullName` = 'Lori Barnett' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Brandy Campbell' ,`SellingOfficeName` = 'RE/MAX Elite Properties' ,`Latitude` = '29.942850' ,`Longitude` = '-95.724496' ,`PhotoCount` = '31' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '430000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Paynes Creek' ,`StreetNumber` = '16814' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME to this 1-story craftsman-style David Weekley home located in the highly desirable Lakeland Heights subdivision of Bridgeland! High ceilings throughout with an open concept main living space. Primary suite is located at the front of the home with a water view! Kitchen has granite countertops, a large island, and lots of cabinets for storage! There is a home office/study, a multi-purpose area/space between the 2nd and 3rd bedrooms, and a large laundry room. This home has solar panels and an EV charger in the garage. There’s an amenity center with a new gym, tennis courts, a pool and water slides as well as parks, restaurants, and shops all within walking distance. Schedule your showing today!' ,`Acres` = '0.1463' ,`Area` = '25' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Solar Assisted' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 LAKELAND HEIGHTS SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1305' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Lakeland Heights Sec 03' ,`TaxAmount` = '10299' ,`TaxRate` = '3.4329' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641811' WHERE `Matrix_Unique_ID` = '209282487' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T22:20:19.200' ,`MLSNumber` = '49829275' ,`ListAgentFullName` = 'Jennifer Zweiacker' ,`ListOfficeName` = 'Zweiacker & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.702995' ,`Longitude` = '-96.297146' ,`PhotoCount` = '44' ,`PostalCode` = '77808' ,`RoomCount` = '16' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Raven' ,`StreetNumber` = '9' ,`StreetSuffix` = 'Drive' ,`City` = 'Bryan' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3213' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home built for one owner located in Ravenwood. Exterior landscape showcases night lighting. Designer kitchen is the heart of this meticulously cared for home & features breakfast area, granite counters, gas cooktop, eating bar, wall oven, large corner pantry. Immense living room enjoys abundant light, raised ceiling & gas log fireplace. Hardwood floors, transom windows & raised panel wainscoting highlight the formal dining room. The primary bedroom has double tray ceiling, sitting area & double sided gas log fireplace. The en suite bath features double vanities, garden tub, separate walk-in shower & huge walk-in closet. 3 guest bedrooms share a Jack/Jill bath. Spacious bonus room w/ private bath. The lush backyard has resort-like in-ground pool w/ fountains, waterfalls & wrap-around patio. Enjoy breezes on the shaded wooden deck that complements the natural flora of this country setting. Metal building with garage & 2 air conditioned workspaces, perfect for any hobbyist.' ,`Acres` = '1' ,`Area` = '61' ,`BuilderName` = 'Kevin Brown Custom H' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'RAVENWOOD, LOT 3, ACRES 1.00' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'SAM HOUSTON ELEMENTARY SCHOOL (BRYAN)' ,`SchoolHigh` = 'JAMES EARL RUDDER HIGH SCHOOL' ,`SchoolMiddle` = 'ARTHUR L. DAVILA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ravenwood' ,`TaxAmount` = '9718' ,`TaxRate` = '1.7488' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641811' WHERE `Matrix_Unique_ID` = '209737501' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T22:57:44.397' ,`MLSNumber` = '90860192' ,`ListAgentFullName` = 'Chelsea Tucker' ,`ListOfficeName` = 'Krueger Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.149367' ,`Longitude` = '-95.637470' ,`PhotoCount` = '13' ,`PostalCode` = '77354' ,`RoomCount` = '5' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Hardin Store' ,`StreetNumber` = '26146' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous, sprawling 1.5-acre country lot is teeming with potential. Land is situated on a large corner lot with no deed restrictions! Property includes the 2-story home with large garage, secondary storage building/garage, and custom-made iron front gate. Home will be cleared by sellers prior to close of sale. HVAC is 7 years old and has been serviced annually. Water pump is 1 year old and water heater was recently replaced. Located in a quickly developing popular area only minutes away from the Woodlands, Tomball, and Magnolia.' ,`Acres` = '1.5' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0343 MURY BARTLEY, TRACT 28, ACRES 1.500' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '65340' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'MURY BARTLEY (Southeast Magnolia)' ,`TaxAmount` = '4119' ,`TaxRate` = '1.9215' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641812' WHERE `Matrix_Unique_ID` = '212861195' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T21:57:36.347' ,`MLSNumber` = '68240703' ,`ListAgentFullName` = 'Gloria Nino' ,`ListOfficeName` = 'Nino Properties' ,`SellingAgentFullName` = 'Shahin Naghavi' ,`SellingOfficeName` = 'Madison Fine Properties' ,`Latitude` = '29.744282' ,`Longitude` = '-95.420023' ,`PhotoCount` = '48' ,`PostalCode` = '77019' ,`RoomCount` = '12' ,`ListPrice` = '2150000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Reba' ,`StreetNumber` = '3023' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3460' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'River Oaks area 4-Bedroom/3.5 Bath + Garage Apartment w/Bedroom, Living, Dining, Kitchenette & lots of storage w/Full Bath. Spacious outdoor space! Roof replaced November 2022, HVAC recently replaced; home thoughtfully updated throughout the years. Beautiful entertaining flow whether small cozy or large gatherings. Zoned to award winning River Oaks Elementary. Home exudes warm welcome to all who enter. Wonderful opportunity to renovate to fit lifestyle OR build dream home now or later on rare oversized 11,670 sq. ft. (per HCAD). Oak floors throughout, lots of natural light, beautiful craftsmanship throughout home. Spacious 1st floor home office, formals and family room; 2nd floor living, interior laundry w/soaking sink + add\'l laundry in garage. Premiere luxury location; new construction and beautifully renovated homes in area. Minutes from DT, Med Ctr, Galleria & Greenway business districts. Walk to parks, fabulous restaurants and shopping.' ,`Acres` = '0.2679' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 & TRS 5 & 7A BLK C AVALON PLACE SEC 2' ,`LotDesciption` = 'Wooded' ,`LotSize` = '11670' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Avalon Place Sec 02' ,`TaxAmount` = '33506' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1935' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641812' WHERE `Matrix_Unique_ID` = '213071327' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T21:10:29.973' ,`MLSNumber` = '71386068' ,`ListAgentFullName` = 'Gary Bisha' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.645844' ,`Longitude` = '-95.656045' ,`PhotoCount` = '25' ,`PostalCode` = '77498' ,`RoomCount` = '10' ,`ListPrice` = '332000.00' ,`Status` = 'Active' ,`StreetName` = 'Peachwood Lake' ,`StreetNumber` = '11715' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in the Village of Oak Lakes Estates subdivision, this delightful house has all you are looking for in a home. As you enter, there is a dining room off the foyer that can also be used as an office. The spacious kitchen, w/ a gas range, a microwave, & a dishwasher, opens to a convenient breakfast/dining area. A comfortable living room boasts 18-foot ceilings & two skylights, w/ the upstairs balcony overlooking it. The primary bedroom is on the first floor, w/ high ceilings & an ensuite bathroom equipped w/ a newly remodeled shower, a garden tub & Italian tile flooring. There is a walk-in laundry room & half bath in the hallway. Upstairs you will find a full bath w/ double sinks and the other three bedrooms- one of which is large enough for a game room- w/ ceiling fans in all rooms. New carpet upstairs, while the downstairs has bamboo wood & tile. The home is accentuated by an extra large backyard with a deck & patio. Sprinklers in front & back. New AC in 2021. Roof is 7 yrs old.' ,`Acres` = '0.2205' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'OAK LAKE ESTATES SEC 3, BLOCK 2, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9606' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`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,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Lake Estates' ,`TaxAmount` = '5234' ,`TaxRate` = '2.2529' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641812' WHERE `Matrix_Unique_ID` = '213599969' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T21:10:35.077' ,`MLSNumber` = '82393707' ,`ListAgentFullName` = 'Kaleb Monroe' ,`ListOfficeName` = 'Real Broker, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.485275' ,`Longitude` = '-95.064037' ,`PhotoCount` = '38' ,`PostalCode` = '77573' ,`RoomCount` = '3' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Virginia' ,`StreetNumber` = '3008' ,`StreetSuffix` = 'Avenue' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1828' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Go GREEN & come HOME!! Check out this UPGRADED spacious 3 Bedroom 2 Bathrooms home sitting on a 6,500 sqft. If your family is looking for an upgraded home that will help you save some electric money, then we have a home for you! This home comes with its all NEW solar panel roofing system already installed and ready to use! You enter this home to a HUGE open kitchen-living room concept with a dining room great for hosting dinner parties! The eat-in kitchen comes equipped with NEW granite countertops, plenty of cabinet storage, and plenty space for pantry storage as well! This home also includes brand NEW modern light fixtures as well as high tray ceilings all throughout the home. There is wooden flooring in the living room and carpet in all bedrooms of the house overflowing with tons of upgrades! Located in League City TX, this home is NOW on the market! Best of all it has only one side neighbor!! Come check out this beauty for yourself!' ,`Acres` = '0.1492' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 19 PERRY & AUSTIN SUR LOT 3 BLK 106 DICKINSON TOWNSITE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SILBERNAGEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Dickinson Townsite' ,`TaxAmount` = '6209' ,`TaxRate` = '2.4697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641812' WHERE `Matrix_Unique_ID` = '213813707' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T21:09:55.577' ,`MLSNumber` = '41446703' ,`ListAgentFullName` = 'Daphne Brown' ,`ListOfficeName` = 'Beyond the Home Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.449181' ,`Longitude` = '-95.445616' ,`PhotoCount` = '27' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Penfield' ,`StreetNumber` = '9203' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1510' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This beautiful one story home is situated on a corner lot in the Master Planned Community of Sterling Lakes. This home features three bedrooms, two full bathrooms, and light and bright finishes throughout! It\'s ideally located in close proximity to Sanchez Elementary School, Neighborhood HEB, and the coming soon, Crystal Lagoon Development. The kitchen features granite countertops, stainless steel appliances, & a breakfast bar. It opens to the living room to make entertaining & enjoying the house a breeze. The primary bedroom features an en-suite bath with a double vanity, and two walk in closets. Enjoy the outdoors by taking evening walks around the neighborhood, and kicking back in your very own backyard which features a beautiful and cozy covered patio, perfect for having dinner or just being outside. Residents are allowed to utilize Sierra Vista & Sterling Lakes amenities.' ,`Acres` = '0.1421' ,`Area` = '5' ,`BuilderName` = 'Censeo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'STERLING LAKES AT IOWA COLONY SEC 13 (A0289 HT&B) BLK 5 LOT' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6325' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sterling Lks/Iowa Colony Sec 1' ,`TaxAmount` = '7496' ,`TaxRate` = '3.5607' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641813' WHERE `Matrix_Unique_ID` = '214015228' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T21:21:14.110' ,`MLSNumber` = '41786976' ,`ListAgentFullName` = 'Reina Conde' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.718049' ,`Longitude` = '-95.619931' ,`PhotoCount` = '50' ,`PostalCode` = '77082' ,`RoomCount` = '8' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Parkridge Glen' ,`StreetNumber` = '3710' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Schedule your appointment to this gorgeous 3 bedroom/ 2 Bath home in an excellent location. Short distance to hospital, restaurants, and shopping . Large family room with fireplace and living room. Nice back yard with concrete patio. Close access to schools and freeways including Westpark tollway which provides shortcut to medical Center and Galleria Area.' ,`Acres` = '0.1446' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 5 PARKRIDGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HEFLIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkridge Sec 01' ,`TaxAmount` = '4390' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641813' WHERE `Matrix_Unique_ID` = '214051204' --> 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','214457170','1669641813','214457170','2022-11-23T21:18:39.690','84095426','Daphne Brown','Beyond the Home Realty, LLC','','','30.009925','-95.538344','35','77379','9','390000.00','Active','Burwood Park','8322','Drive','Spring','2','1','4','2585','Single-Family','With charming curb appeal and a great floor plan, this Champion Forest beauty is a true STAND OUT! Lots of built-ins, updates, and crown molding that give this home character. The family room is huge, and is anchored by a fireplace flanked by bookcases and built- ins. This home has been remodeled through-out including stylishly remodeled bathrooms, engineered hardwood flooring, completely remodeled primary bathroom including rectangular ceramic tile and quartz counter tops, spa-like shower, carpeting, stainless steel appliances, granite counter tops in kitchen, 2013 HVAC and 2022 roof replacement.\r\n\r\nThis home is truly turnkey!!! Located on a quiet street in established Champions Forest with trademark mature trees, you\'ll have convenient access to I-45, 249 and The Grand Parkway!!! You\'ll be surrounded by amenities such as Vintage Park and Willowbrook Mall for shopping at it\'s finest and of course world class dining, both causal and fine. Also located in highly popular Klein ISD.','0.1768','13','','','Electric Dryer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Champions Area','Central Gas','1','LT 33 BLK 2 017*C2915074-004-002-033 CHAMPION FOREST SEC 4','Subdivision Lot','7700','Appraisal District','','250','0','','2','Electric Oven','0','','','Electric Range','','Composition','32 - Klein','BRILL ELEMENTARY SCHOOL','KLEIN HIGH SCHOOL','KLEB INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Champion Forest Sec 04','5060','2.3465','Public Sewer,Public Water','1981','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T21:04:14.260' ,`MLSNumber` = '66424606' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = 'James Morales' ,`SellingOfficeName` = 'Results Real Estate' ,`Latitude` = '29.501171' ,`Longitude` = '-95.513403' ,`PhotoCount` = '50' ,`PostalCode` = '77459' ,`RoomCount` = '12' ,`ListPrice` = '561000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Caleb' ,`StreetNumber` = '3615' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4156' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous 4-bedroom, 4.5-bathroom home in Sienna Steep Bank Village has so much to offer! This home boasts a beautiful brick exterior, high ceilings, wood flooring, a gas log fireplace, study, game room, formal dining and living rooms, a covered patio, and a glistening swimming pool in the spacious backyard. No recipe is a challenge in the island kitchen, fully equipped with granite countertops, tile backsplash, a butler pantry, gas cooktop, double oven, glass-fronted cabinets, breakfast bar, dining nook, pendant lighting, and undercabinet lighting. The spa-like primary suite features a walk-in closet, dual vanities, jetted tub, and a separate shower. Residents of Sienna enjoy a swimming pool, a park, a playground, and walking trails. Situated off Hwy 6, residents are close to shopping and dining at the First Colony Mall, Sugar Land Town Center, and Kitty Hollow Park. Zoned to Fort Bend ISD.' ,`Acres` = '0.2381' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA STEEP BANK VILLAGE SEC 6B, BLOCK 4, LOT 29' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10372' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SIENNA CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Steep Bank Village' ,`TaxAmount` = '11076' ,`TaxRate` = '2.5729' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641813' WHERE `Matrix_Unique_ID` = '214554345' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T21:44:01.100' ,`MLSNumber` = '13668423' ,`ListAgentFullName` = 'Naseem Panjwani' ,`ListOfficeName` = 'MIH REALTY, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.586015' ,`Longitude` = '-95.746770' ,`PhotoCount` = '24' ,`PostalCode` = '77406' ,`RoomCount` = '7' ,`ListPrice` = '519100.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Barrel Run' ,`StreetNumber` = '1210' ,`StreetSuffix` = '' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2267' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW. *WATER FRONT* Simgle Story HOME Energy-Efficient built in 2022! Cozy Huge master with bay window and huge closet. Secondary Suite with private bathroom. 4 bedroom, Flex /gameroom & 3 full bathroom. Sip your morning coffee at the convenient kitchen island overlooking the dining and family rooms. In the primary suite, elegant sloped ceilings complement the sizeable space, including ensuite with dual sinks and large walk-in closet. Make long commutes a thing of the past thanks to major road improvements on US-90 and FM 359. The kids will love attending school in the sought-after Lamar Consolidated ISD and the area offers an affordably low tax rate. Downtown Richmond is home to many new boutiques, restaurants, and longstanding businesses. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills--' ,`Acres` = '' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric,Central Gas,Other Heating' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0164 Plan L404C' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LONG ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mandola Farms' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641813' WHERE `Matrix_Unique_ID` = '214657368' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T22:16:31.540' ,`MLSNumber` = '57809960' ,`ListAgentFullName` = 'Barbara Kobza' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.936068' ,`Longitude` = '-96.960014' ,`PhotoCount` = '50' ,`PostalCode` = '78945' ,`RoomCount` = '3' ,`ListPrice` = '800000.00' ,`Status` = 'Active' ,`StreetName` = 'Muzny' ,`StreetNumber` = '741' ,`StreetSuffix` = 'Lane' ,`City` = 'La Grange' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2105' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 741 Muzzy Lane! From the moment you set eyes on this property you can tell that it has been well-loved and well-maintained. Set back from the end of the street, you\'ll experience the utmost privacy and serenity. Property includes 6 tracts totaling over 20 acres, a 3/2 single-family home, greenhouse, workshop, two-car metal detached garage with garage apartment, and storage building. Would make a great horse ranch! Primary bedroom is 13x20 with an additional 5x6 dressing area and 6.5x11 sitting area. 400 sf addition built in 1992 with large family room and additional eating area. Outdoor grill area with enclosed kitchen, plus numerous outdoor seating areas to enjoy the peace and quiet!' ,`Acres` = '21.5' ,`Area` = '69' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABS A030 CASTLEMAN A LG,1.0 ACRES,HSE, C/PORT, FARM BLDGS--L' ,`LotDesciption` = 'Cleared' ,`LotSize` = '936279' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '205 - La Grange' ,`SchoolElementary` = 'HERMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA GRANGE HIGH SCHOOL' ,`SchoolMiddle` = 'LA GRANGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Castleman' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641814' WHERE `Matrix_Unique_ID` = '214736671' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T21:41:16.070' ,`MLSNumber` = '75464328' ,`ListAgentFullName` = 'Gary Bisha' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.464156' ,`Longitude` = '-95.064375' ,`PhotoCount` = '24' ,`PostalCode` = '77539' ,`RoomCount` = '6' ,`ListPrice` = '287500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Ash' ,`StreetNumber` = '3106' ,`StreetSuffix` = 'Drive' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1725' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new build with many updates and luxury finishes. No detail is overlooked in this modern, open-concept home. Features include a chef\'s kitchen with new stainless steel appliances and quartz countertops that sparkle in the abundance of natural light. Great opportunity for a new build! Whether you are looking to entertain a large crowd or have a private dinner, this home provides the perfect space with its custom cozy details. Call to schedule a showing today!' ,`Acres` = '0.2061' ,`Area` = '33' ,`BuilderName` = 'Boritex Solutions' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ROLON NO TWO SUB (2017) ABST 19, LOT 2, ACRES 0.194' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8976' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'CALDER ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rolon Two Sub' ,`TaxAmount` = '5076' ,`TaxRate` = '2.5214' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641814' WHERE `Matrix_Unique_ID` = '214751789' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-23T22:34:38.533' ,`MLSNumber` = '68657731' ,`ListAgentFullName` = 'Renae Gibson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Patrick King' ,`SellingOfficeName` = 'Realty Kings Properties' ,`Latitude` = '29.787762' ,`Longitude` = '-95.587196' ,`PhotoCount` = '25' ,`PostalCode` = '77043' ,`RoomCount` = '4' ,`ListPrice` = '425000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Forest' ,`StreetNumber` = '1227' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2834' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED. Grand entrance with vaulted ceilings. Living room is the perfect place to entertain large group and friend gatherings. Cozy fireplace for those cold winter nights. Island Kitchen has tons of cabinets and counter space. Spacious breakfast room adjoins and massive formal Dining or Study is just off the kitchen. Laundry room located downstairs. Tons of windows and natural light pouring in. All bedrooms are up. No carpet in this home. Secluded, low traffic part of the energy corridor. 2 minute walk to Private Clubhouse, Community Swimming Pool, Tennis Courts and fenced Playground. Low maintenance landscaping. Close proximity to bicycle and paved walking path. Only minutes to Terry Hershey Park and Westside Tennis Club. Easy access to I-10. Great home in a great location for a great price.' ,`Acres` = '0.1396' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 7 WESTWICK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'THORNWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwick Sec 01' ,`TaxAmount` = '9457' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641814' WHERE `Matrix_Unique_ID` = '214837711' --> 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','214838735','1669641814','214838735','2022-11-23T21:35:22.697','16793453','Melanie White','RE/MAX Signature','','','29.817928','-95.715689','32','77449','8','265000.00','Active','Tynemeadow','3210','Court','Katy','2','0','4','1881','Single-Family','Traditional one story home on cul-de-sac street in Westfield. Great floor plan with 4 bedrooms or 3 bedrooms and a study, 2 full baths, large family room, high ceilings and open floor plan. Primary bedroom is tucked away by itself and has a large primary bath with double sinks, 2 closets and tub/shower. Kitchen has lots of storage, gas range and charming breakfast room. Light and bright family room with vaulted ceiling open to dining room and has brick fireplace and door to the back yard. Secondary bedrooms are connected through a wonderful guest bathroom and study has french doors and a closet. Quiet backyard perfect is for entertaining! Great curb appeal and wonderful close-in Katy location.','0.1447','25','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace,Wood Burning Fireplace','1','Katy - North','Central Gas','1','LT 35 BLK 7 WESTFIELD SEC 1','Subdivision Lot','6304','Appraisal District','','480','0','','2','Electric Oven,Single Oven','0','','','Gas Range','','Composition','30 - Katy','MCROBERTS ELEMENTARY SCHOOL','MAYDE CREEK HIGH SCHOOL','CARDIFF JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Westfield Sec 01','4136','2.387','Water District','1983','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','215043954','1669641814','215043954','2022-11-23T21:22:27.880','79473647','Sharon Wright','Radius Agent LLC','','','29.609287','-95.722445','14','77406','7','299500.00','Active','Country Place','2707','Drive','Richmond','2','1','3','2027','Single-Family','This immaculate 2 story home is located in the very popular Pecan Grove. Home has incredible upgrades throughout, 3 bedroom 2 1/2 bath and a game room! The over sized Mud Room is large enough to add a work station utility room and more. Truly a home for great entertaining.','0.1566','37','','','Electric Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Fort Bend County North/Richmond','Central Gas','1','THE GROVE SEC 4, BLOCK 10, LOT 88, R/P','Subdivision Lot','6820','Appraisal District','','281','0','','2','Electric Oven','0','','','Electric Range','','Composition','33 - Lamar Consolidated','AUSTIN ELEMENTARY SCHOOL (LAMAR)','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Other Style','The Grove Sec 4','5228','2.3298','Water District','1983','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','215045158','1669641814','215045158','2022-11-23T21:31:21.323','49816100','Karina Contreras','REALM Real Estate Professional','','','29.831520','-95.489694','17','77092','3','215000.00','Active','Barney','6618','Road','Houston','2','0','3','925','Single-Family','Lovely home in the growing Spring Branch area. This home features many upgrades including a gourmet kitchen with granite counter tops and custom designed cabinets with an open concept floor plan. Wood flooring recently stained with a beautiful dark brown color to match the custom cabinets. A second full bathroom was added into the home. Also, the main full bathroom was upgraded. The back yard has lots of space with endless possibilities. Perfect starter home, schedule your appointment today! Easy access to I-10 and 290. Never flooded!! No HOA Call listing agent for Title information. Thank you for showing ','0.1389','24','','','','','Sellers Disclosure','1','','','Spring Branch','Central Electric','0','LT 16 BLK 13 LANGWOOD SEC 1','Other,Subdivision Lot','6050','Appraisal District','','','0','','0','Gas Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','27 - Houston','BENBROOK ELEMENTARY SCHOOL (HOUSTON)','SCARBOROUGH HIGH SCHOOL','CLIFTON MIDDLE SCHOOL (HOUSTON)','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Langwood Sec 01','3267','2.3307','Other Water/Sewer','1954','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','215048219','1669641814','215048219','2022-11-23T22:37:44.793','73080283','Catherine Reilly','HomeSmart','','','29.702497','-95.780361','17','77494','9','344500.00','Active','Cansfield','23503','Way','Katy','2','0','3','2225','Single-Family','LOCATION, LOT SIZE and VALUE for excellent rated KATY ISD Schools. Hickory Creek is located within Seven Meadows area with quick access to 1093 and Westpark Tollway. Enjoy this split floorplan with updates including, new stove, dishwasher, master bathroom, paint throughout, carpet, sprinkler system, fixtures, VIVINT Security System, new electric panels with new breakers, all new switches, purifying AC with new motor and ductwork replaced throughout, No BACK NEIGHBORS and with this BIG LOT it\'s pool worthy and will still have plenty of yard left over for green space. Enjoy every moment and come see all this home has to offer. WELCOME HOME TO KATY!','0.2628','36','','','Electric Dryer Connections','','Mud,No Disclosures','1','Wood Burning Fireplace','1','Katy - Southwest','Central Gas','1','HICKORY CREEK SEC 1, BLOCK 1, LOT 4, R/P','Cul-De-Sac,Subdivision Lot','11448','Appraisal District','','212','0','','2','Electric Oven,Single Oven','0','','','Gas Range','','Composition','30 - Katy','HOLLAND ELEMENTARY SCHOOL (KATY)','SEVEN LAKES HIGH SCHOOL','BECKENDORFF JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Seller','1','Traditional','Hickory Creek Sec 1','7871','2.5145','Water District','1986','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','215048246','1669641814','215048246','2022-11-23T21:42:37.580','85300581','Eric Broussard','Real Estate Concepts','','','29.569861','-95.264749','45','77581','9','325000.00','Active','Creek Falls','2988','Court','Pearland','2','0','4','1965','Single-Family','Very nice one story 4 bedroom, 2 bath home in Creekside. Pearland ISD. Beautifull well established landscaping. Large front and back yards. Cul-de-sac street. Laminate flooring in bedrooms, tile in kitchen, family room, baths, and utility room. Large eat-in kitchen with breakfast bar, and island. Schedule your private showing soon. Call anytime if you have questions.','0.1875','5','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Freestanding,Gas Connections,Wood Burning Fireplace','1','Pearland','Central Gas','1','CREEKSIDE SEC 2 (A0076 & A0233) (PEARLAND) BLK 3 LOT 5','Subdivision Lot','8168','Appraisal District','','400','0','','2','Gas Oven','0','','','Gas Range','','Composition','42 - Pearland','C J HARRIS ELEMENTARY SCHOOL','PEARLAND HIGH SCHOOL','PEARLAND JUNIOR HIGH WEST','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Creekside Sec 2','8948','3.3751','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','215049153','1669641814','215049153','2022-11-23T21:09:49.430','8698049','Melissa Pompa','Vive Realty LLC','','','29.658380','-95.165045','42','77505','3','264900.00','Active','Misty','5006','Lane','Pasadena','2','0','3','1652','Single-Family','Beautiful home is in secluded Whitney Estates. Home is on a large corner lot and ready for move in! Immediate access to Beltway 8 and close proximity to restaurants and shopping centers! This one will not last long so make your appointment today!','0.1824','6','','','','','Sellers Disclosure','','','1','Pasadena','Central Gas','0','LT 15 BLK 1 WHITNEY ESTATES SEC 2 AMEND','Subdivision Lot','7947','Appraisal District','','','0','','2','','0','','','','','Composition','41 - Pasadena','GOLDEN ACRES ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (PASADENA)','BONDY INTERMEDIATE SCHOOL','Appointment Required,Lockbox Left Side,Vacant/Unoccupied','Appraisal District','1','Traditional','Whitney Estates Sec 02 Amd','5259','2.6514','Public Sewer,Public Water','2001','Appraisal District'); --> New record created successfully