Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T03:59:05.870' ,`MLSNumber` = '52664968' ,`ListAgentFullName` = 'Trinh Tran' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.839008' ,`Longitude` = '-95.682217' ,`PhotoCount` = '19' ,`PostalCode` = '77084' ,`RoomCount` = '4' ,`ListPrice` = '323000.00' ,`Status` = 'Active' ,`StreetName` = 'Oakhampton' ,`StreetNumber` = '18307' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2465' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW ROOF 10/2022!  Nice and cozy 4 bedrooms with primary room downstairs.  2 bathrooms upgraded 2021.  House painted and new carpet replaced 2021.   Plenty spaces with long driveway to detached garage for parking spaces.  Hug room for outdoor party in the backyard.  This house won’t last long!   Call agent today to make appointment.' ,`Acres` = '0.2066' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 40 DEERFIELD VILLAGE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deerfield Village Sec 04' ,`TaxAmount` = '5115' ,`TaxRate` = '2.251' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667133511' WHERE `Matrix_Unique_ID` = '207160295'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T02:23:17.910' ,`MLSNumber` = '58590890' ,`ListAgentFullName` = 'Diana Laughlin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780441' ,`Longitude` = '-95.420226' ,`PhotoCount` = '30' ,`PostalCode` = '77007' ,`RoomCount` = '3' ,`ListPrice` = '477900.00' ,`Status` = 'Active' ,`StreetName` = 'Petty' ,`StreetNumber` = '5501' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2302' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A GREAT LOCATION IS ESSENTIAL! Corner property At Cottage Grove Neighborhood / Petty Street Townhomes with direct access to hip new M-K-T Heights with nearby restaurants and retail, connected to the Heights Hike & Bike Trails and White Oak Trail. This 3 bedroom & 3.5 bath home features a two-car garage, a CORNER lot, TWO primary bedrooms, a private entrance to the first-floor PRIMARY bedroom. w/ access to Patio, an open family room with TWO private balconies w/ access via Kitchen and Living Room, a fireplace, BUILT-IN stainless steel appliances, a gourmet kitchen with granite countertops, plenty of cabinet space, beautiful built in pantry cabinets wall,  SOARING ceilings,  LOTS of natural lighting, LOTS of windows in every floor level. NEW AC installed in 2022, NO carpet, WD and fridge included in the sale. To schedule a private tour, call TODAY.' ,`Acres` = '0.0404' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cottage Grove' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 PETTY STREET TOWNHOMES' ,`LotDesciption` = 'Corner' ,`LotSize` = '1759' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Petty Street Twnhms' ,`TaxAmount` = '7769' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667133511' WHERE `Matrix_Unique_ID` = '212125779'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T03:00:36.377' ,`MLSNumber` = '27754989' ,`ListAgentFullName` = 'Clarissa Castleberry' ,`ListOfficeName` = 'Surge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804386' ,`Longitude` = '-95.358419' ,`PhotoCount` = '36' ,`PostalCode` = '77009' ,`RoomCount` = '4' ,`ListPrice` = '699000.00' ,`Status` = 'Active' ,`StreetName` = 'Moody' ,`StreetNumber` = '917' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2450' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 917 Moody, a beautifully crafted, newly constructed home that offers 4 bed, 3.5 bath. Located only minutes from downtown in the highly sought after Lindale Park neighborhood, this home boasts of high ceiling and natural light. The open concept kitchen, family and dining rooms make this home ideal for entertaining or family gatherings. The downstairs bedroom with an ensuite bath can serve perfectly as a home office or guest bedroom. Upstairs, you\'ll enjoy another living space for your family\'s needs, a sizable laundry room, and a thoughtful primary suite. Enjoy spending time in your spacious backyard, that\'s ready to be customized to it\'s owners desires and needs.Schedule your showing today! (Home comes with builders warranty. Further customizations negotiable) *SELLER CAN CONTRIBUTE TO LOWER RATE*' ,`Acres` = '0.1159' ,`Area` = '9' ,`BuilderName` = 'Forthright Construct' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 37 BLK 25 LINDALE PARK SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOOSCAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lindale Park Sec 03' ,`TaxAmount` = '4317' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667133511' WHERE `Matrix_Unique_ID` = '212583262'  --> Updated record success<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212767935','1667133512','212767935','2022-10-30T02:58:22.420','4521979','Joe Ann Green','Westchase Realty Services','','','30.009628','-95.293959','26','77338','6','228000.00','Active','Orchard Ridge','8631','Lane','Humble','2','0','3','1636','Single-Family','Charming one-story, offering formal dining and breakfast with an open kitchen. Light and bright open large living area for oversized furniture. Sitting on an oversized corner lot. Large fenced backyard.','0.1692','12','','','','','Mud,Sellers Disclosure','','','1','Humble Area West','Central Electric','1','LT 21 BLK 2 KENSWICK SEC 3','Corner','7370','Appraisal District','','300','0','','2','','0','','','','','Composition','1 - Aldine','JONES ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','JONES MIDDLE SCHOOL (ALDINE)','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Kenswick Sec 03','4519','2.7433','Public Sewer,Public Water','1981','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T03:59:54.590' ,`MLSNumber` = '98565951' ,`ListAgentFullName` = 'Telma Garcia' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.968115' ,`Longitude` = '-95.193799' ,`PhotoCount` = '30' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Kobuk Valley' ,`StreetNumber` = '17239' ,`StreetSuffix` = 'Circle' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1851' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This fantastic one-story home combines desirable location, an open floor plan, and modern updates into one attractive package. Featuring 10-foot ceilings and hardwood or tile floors throughout(No Carpet!). This home also offers a newly remodeled stunning primary bathroom ! New fabulous custom closet!  Recent new A/C and Water heater units. New fence in 2021, Exterior painted 2022. The open living and kitchen area includes energy-efficient s.s. appliances and plenty of room for cooking or entertaining. The large backyard and covered patio make grilling with the family a breeze. Never flooded. Located in the master planned community of Eagle Springs and situated in a family-friendly cul-de-sac, this perfect home is also conveniently close to Atascocita, Humble, Beltway and Hwy 59. Neighborhood amenities include 24-hour fitness center, resort style pools, sports fields, splash pad, several parks, and seasonal events! Schedule your private showing before this home is gone!' ,`Acres` = '0.1515' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 1 EAGLE SPRINGS SEC 19' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6598' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ATASCOCITA SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Springs' ,`TaxAmount` = '5905' ,`TaxRate` = '2.913' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667133512' WHERE `Matrix_Unique_ID` = '213393823'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T03:02:56.230' ,`MLSNumber` = '8793073' ,`ListAgentFullName` = 'Chinonso Ochi-Okorie' ,`ListOfficeName` = 'The Goldstein Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.673809' ,`Longitude` = '-95.360641' ,`PhotoCount` = '41' ,`PostalCode` = '77051' ,`RoomCount` = '8' ,`ListPrice` = '555117.00' ,`Status` = 'Active' ,`StreetName` = 'Niagara' ,`StreetNumber` = '1217' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2675' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'An ideal location near med center, Dwntwn Houston,& Galleria. 4 bed 3.5 bath home w/2 bedrooms & 2.5 baths 1st floor w/ huge 2nd floor den on 12k sqft lot ready for pool-spa/pool house/pergola in the back yard for Airbnb. Home features: Open concept floor plan, custom brick/stone elevation, int/ext LED lighting pkg, 3x LED fireplaces, pre-wired for solar/EV charging w/240v plug in the garage, prewired for int 5.1 surround sound & ext speakers, quartz counter tops w/waterfall, stainless steel appliances, spray foam insulation, double stacked custom cabinets w/glass/soft close doors w/smart LED lighting, apron sink, pot filler, 5 light Iron front door, Matte black fixtures/hardware, 8ft int doors, architectural fence w/wrought iron gate, remote security system & camera\'s, stained hardwood ceilings in patio/porch, & more. NO HOA NO MUD NOT IN A FLOOD ZONE. Deed restricted (NO NEW MULTI-FAMILY DEV ALLOWED). ALL REASONABLE OFFERS WILL BE CONSIDERED TO INTEREST RATE CONDITIONS!' ,`Acres` = '0.27' ,`Area` = '3' ,`BuilderName` = 'GENERATIONAL HOME BU' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 6 BLK N BROOKHAVEN R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'YOUNG ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Brookhaven R/P' ,`TaxAmount` = '1251' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667133512' WHERE `Matrix_Unique_ID` = '213456443'  --> Updated record success<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214190742','1667133512','214190742','2022-10-30T02:01:00.787','21761531','Troy Cothran','Victory Properties, Inc.','','','29.603444','-95.112734','50','77059','7','450000.00','Active','Cedar Ridge','4311','Trail','Houston','3','0','4','3171','Single-Family','Beautiful home in the Pine Brook Neighborhood, Great location close to wonderful restraunts and shopping. Very spacious with a open view of the main living areas, Nice size den and a really big kitchen for those special events, split formal dining/ living area, Primary bedroom has a sitting area to enjoy while you enjoy you morning coffee and relax before your busy day. Primary bedroom is also very roomy with garden tub and seperate shower.\r\nRoom sizes are appx at this time so please measure fore yourself if needed,','0.218','7','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','1','Clear Lake Area','Central Gas','1','LT 20 BLK 5','Subdivision Lot','9498','Appraisal District','','580','0','','2','','0','','','','','Composition','9 - Clear Creek','BROOKWOOD ELEMENTARY SCHOOL','CLEAR LAKE HIGH SCHOOL','SPACE CENTER INTERMEDIATE SCHOOL','Supra Keybox','Appraisal District','1','Traditional','Pine Brook','9087','2.5769','Public Sewer,Public Water','1996','Appraisal District');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214202692','1667133512','214202692','2022-10-30T02:18:48.003','92341767','Brianna Sharum','United Real Estate','','','29.737780','-95.548813','18','77042','6','624900.00','Active','Locke','10006','Lane','Houston','3','0','4','2784','Single-Family','Lovely 4 bed, 3 bath home in Briargrove Park just a short walk from shopping and restaurants! The home has granite countertops, travertine and hardwood floors, and a covered backyard seating area. The primary bedroom features two closets, and the fourth bedroom could also double as a game room. The neighborhood is quiet and secluded with peacocks roaming free. The Briargrove Park pool and tennis courts are only a couple of streets over from the house. The Galleria, Town and Country Shopping Center, Memorial City Mall, and Terry Hershey Park are within a few minutes’ drive.','0.1809','22','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Briargrove Park/Walnutbend','Central Electric','1','LT 40 & TR 41A BLK 2 BRIARGROVE PARK SEC 1','Subdivision Lot','7881','Appraisal District','','685','0','','2','','0','','','','','Composition','27 - Houston','WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)','WESTSIDE HIGH SCHOOL','REVERE MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern,Traditional','Briargrove Park Sec 01','12943','2.3307','Public Sewer','1974','Appraisal District');  --> New record created successfully<br />