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-09-08T07:56:58.383' ,`MLSNumber` = '11868464' ,`ListAgentFullName` = 'Dao Vo' ,`ListOfficeName` = 'Intercontinental Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.096627' ,`Longitude` = '-95.498606' ,`PhotoCount` = '14' ,`PostalCode` = '77389' ,`RoomCount` = '5' ,`ListPrice` = '278600.00' ,`Status` = 'Active' ,`StreetName` = 'Sherioaks' ,`StreetNumber` = '22815' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1774' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home 2 stories, all bedrooms in up-floor ; Kitchen open to  breakfast area, wide back door go out large back yard with a patio. Down floor tile, and Up-floor carpet; Ceiling lights can change to connect fan /light; New AC unit 2021, Never flooding, neither has storm damages.....A warm home in good neighborhood, good school.' ,`Acres` = '0.1025' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 5 FOXHOLLOW SOUTH SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4463' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '286' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'ZWINK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Foxhollow South Sec 01' ,`TaxAmount` = '4970' ,`TaxRate` = '3.0041' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708128' WHERE `Matrix_Unique_ID` = '211090507'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T07:19:29.603' ,`MLSNumber` = '65158187' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.183036' ,`Longitude` = '-95.147473' ,`PhotoCount` = '10' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '358990.00' ,`Status` = 'Active' ,`StreetName` = 'Titus' ,`StreetNumber` = '3007' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2035' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING NEW DR HORTON HOME!! Over 26,000 square foot wooded lot and 3 car garage! This is a 4 bedroom 3 full bathroom, with a study one story.  The open kitchen features shaker cabinets, granite countertops and stainless-steel appliances. Spacious Primary Suite is tucked away for your own private retreat with separate shower and garden tub. The home has front sprinklers, and a home automation system. You will appreciate the great storage and energy efficient features throughout.   Hurry and call today!!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 7 Block 13 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '26378' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates at Roman Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708128' WHERE `Matrix_Unique_ID` = '211107596'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T06:27:14.960' ,`MLSNumber` = '10588128' ,`ListAgentFullName` = 'Philip Tack Sr.' ,`ListOfficeName` = 'Lions Gate Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.207821' ,`Longitude` = '-95.584782' ,`PhotoCount` = '18' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '398900.00' ,`Status` = 'Active' ,`StreetName` = 'Miller' ,`StreetNumber` = '8631' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2013' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a Great house with a 29000 square foot property great quiet location close to everything, Just minutes from 1488 and the Woodlands. House has totally been redone, A/C replaced including all duct work, brought natural gas to the house so new heating unit is gas, and stove. All new appliances, complete remodel opened all the kitchen, living and dining together. New closet and Primary beautiful shower, all new luxury vinyl flooring.\r\nREADY to move in Awesome property!!!!' ,`Acres` = '0.668' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S949502 - WESTWOOD 02, BLOCK 2, LOT 3' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '29100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '208' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood 02' ,`TaxAmount` = '4043' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708128' WHERE `Matrix_Unique_ID` = '211167447'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T07:48:42.947' ,`MLSNumber` = '86253913' ,`ListAgentFullName` = 'Tiesha Gay' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.817392' ,`Longitude` = '-95.074503' ,`PhotoCount` = '39' ,`PostalCode` = '77562' ,`RoomCount` = '6' ,`ListPrice` = '345253.00' ,`Status` = 'Active' ,`StreetName` = 'Clear Lake' ,`StreetNumber` = '1214' ,`StreetSuffix` = 'Road' ,`City` = 'Highlands' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2678' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Look at this Beautiful fully renovated Farmhouse country style home. This beauty has a main house as well as a guest house with its own separate entry. The Main house has 3 bedrooms with 3 Full baths. The guest house includes another full bedroom, full bathroom and private kitchen. This is the perfect setup. Guest house can be used for the in-laws, college student, or rental income. This gem sits on a 1/2 acre with a gorgeous extended back porch that already has 3 ceiling fans installed where you can enjoy your morning coffee. This home includes Brand-new stainless-steel appliances, Farmhouse sink, wood cabinets, with granite countertops. Brand new flooring throughout the entire home with recess lighting. This neighborhood has no deed restrictions and has plenty of room for your pets or toys. Minutes away from San Jacinto River and the San Jacinto Monument. Everything is brand new in this home. Come See what this Gem has to offer.' ,`Acres` = '0.6887' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 3A & LT 3A BLK 46 HIGHLAND TOWNSITE ABST 83 J WHITE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '30000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Highland Townsite' ,`TaxAmount` = '3337' ,`TaxRate` = '2.575' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708128' WHERE `Matrix_Unique_ID` = '211642314'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T07:58:09.143' ,`MLSNumber` = '68549801' ,`ListAgentFullName` = 'Jennifer Voskuhl' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = 'Kumud Sinha' ,`SellingOfficeName` = 'Sinha Global Realty' ,`Latitude` = '29.686651' ,`Longitude` = '-95.789679' ,`PhotoCount` = '50' ,`PostalCode` = '77406' ,`RoomCount` = '12' ,`ListPrice` = '1800000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Lago Verde' ,`StreetNumber` = '11418' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '7352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Dream Home has 5 br, 6 bath & 4 car garage. Enter through the custom iron double doors into the Large foyer with chandeliers, a winding staircase, Formal sitting room with large double sided fireplace next to the formal dining area with wine bar.  The kitchen area has Hard wood flooring, 2 large islands with 2 sinks and a large family room all overlooking the pool. 4 burner gas cooktop plus a large griddle, exotic granite countertops, beautiful custom cabinets with storage drawers & pantry room with a coffee bar & microwave. The wet bar has a fridge and ice maker. Every major room overlooks the beautifully landscaped pool/spa and outdoor kitchen. The wood paneled Study & Theater are on 1st floor. Back stairs lead to 3 BR, game room,  gym/bedroom, & many air conditioned storage rooms. 2nd Floor suite has a  grand bathroom W/ large walk-in closet. 3 balconies overlooking the backyard pool and lake with large fountains.' ,`Acres` = '0.3717' ,`Area` = '37' ,`BuilderName` = 'M&M Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LAKES OF BELLA TERRA SEC 7, BLOCK 1, LOT 24' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '16193' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUBENAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes Of Bella Terra' ,`TaxAmount` = '40601' ,`TaxRate` = '3.0848' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663708129' WHERE `Matrix_Unique_ID` = '211722331'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T06:36:00.267' ,`MLSNumber` = '15056988' ,`ListAgentFullName` = 'Ashly Singletary' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.081577' ,`Longitude` = '-95.361550' ,`PhotoCount` = '29' ,`PostalCode` = '77386' ,`RoomCount` = '3' ,`ListPrice` = '396000.00' ,`Status` = 'Active' ,`StreetName` = 'Aspen Horizon' ,`StreetNumber` = '28126' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2479' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful  Lennar home located in the Master-Planned living in Harmony Village! Zoned to highly acclaimed Conroe ISD schools.  This home is conveniently located with easy access to the Grand Parkway and  I-45, also many fine dining restaurants and shopping in The Woodlands! This home is on a larger lot and loaded with upgrades.  It comes with the technology and smart home capabilities.  New sliding glass doors that open into the backyard, overhead racks installed in the garage - the upgrade list goes on and on.  Open concept kitchen with a perfect size island with granite countertops and stainless steel appliances.  This home has 3 large bedrooms and great size closets, with easy access to attic space.  Upstairs features a gameroom space with additional closets for plenty of storage.  Harmony subdivision has 2 pools, 2 splash pads, 3 parks, gym, tennis and basketballs courts, as well as many walking trails.  See list of all of the upgrades and in attachments.' ,`Acres` = '0.1774' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S571210 - HARMONY VILLAGE 10, BLOCK 3, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7727' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BROADWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harmony Village 10' ,`TaxAmount` = '7862' ,`TaxRate` = '2.9587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708129' WHERE `Matrix_Unique_ID` = '211788546'  --> 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','212237307','1663708129','212237307','2022-09-08T06:33:43.737','28948129','Donya McLaurin','Keller Williams SoutheastTexas','','','30.395763','-94.630200','19','77374','5','100000.00','Active','Hwy 787','27119','','Thicket','1','0','2','1168','Single-Family','Wonderful fixer upper oozing with character.  Original hard wood floors, glass door knobs, original light fixtures are just some of the things that make this home worth seeing.  The dining room has 2 built in corner cabinets.  French doors separate the living area from the dining room. There is a small room at the back of the home that could be used for another bedroom if needed.  There is also an inside utility room. The home sits on 6.5 acres of partially cleared property.  There are some fruit trees on the property.  If you are wanting a home in the country away from the hustle and bustle of the city this is the home for you.','6.5','49','','','','','No Disclosures','','','','','Central Electric','0','AB 200 T R EDMONDSON P# 200-9 I# 1100/215','Other','283140','Appraisal District','','','0','','0','','0','','','','','Composition','182 - West Hardin County Consolidated','WEST HARDIN ELEMENTARY SCHOOL','WEST HARDIN HIGH SCHOOL','WEST HARDIN MIDDLE SCHOOL','Appointment Required,Lockbox Back,Vacant/Unoccupied','Appraisal District','1','Craftsman','NA','1137','1.6971','Septic Tank,Water District','1923','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','212254768','1663708129','212254768','2022-09-08T07:17:51.403','85489669','Eric Folkerts','REALM Real Estate Professional','','','29.850317','-95.811014','37','77493','7','350000.00','Active','Laird Knoll','25250','Street','Katy','2','1','3','2127','Single-Family','The curb appeal of this one is stunning. Barely lived in and combining a brick elevation, tile flooring, and an open floor plan, this home will exceed all your expectations. Tons of upgrades you can’t get any longer at this price!! Dream up culinary masterpieces in the chef’s kitchen, featuring granite countertops, 42” cabinets, and stainless steel Energy Star appliances. Spend a quiet evening relaxing in the lavish master bathroom, featuring dual vanities, a 42” Kohler Master Windward tub, and a separate shower. Other features include 9 foot ceilings and 8 foot doors, no carpet down, no back neighbors, security system stays, a media package, full house gutters, and a covered patio. Sprinkler system keeps everything beautiful! Garage fridge and Washer/Dryer stay with the property. Zoned to KATYISD schools and the 5A Division 1 State Champion Paetow Panthers Football team!!','0.1312','25','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Katy - Old Towne','Central Gas','1','LT 9 BLK 1 KATY MANOR SEC 5','Cul-De-Sac','5713','Appraisal District','','495','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','30 - Katy','MCELWAIN ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Leave Business Card,Request Online Appointment','Appraisal District','2','Traditional','Katy Manor Sec 5','7809','3.4768','Water District','2020','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','212289224','1663708129','212289224','2022-09-08T07:45:59.883','41343967','Charles Schrader','Coldwell Banker Realty','','','29.491991','-95.763160','22','77469','6','525000.00','Active','Mourning Dove','5026','Drive','Richmond','2','1','4','2912','Single-Family','Amazing custom built home on just over and acre of land.  Home features a large open concept living and dining room, a galley style kitchen, 2 large bedrooms upstairs with 2 full baths, 2 bedrooms down stairs with a half bath, tons of storage, drive through garage doors, and a fully functioning shop. Downstairs is designed to be converted into a 2 bedroom 1 bath completed unit if needed.','1.151','30','','','','','Sellers Disclosure','','','','Fort Bend South/Richmond','Central Gas,Propane','0','DOVE MEADOWS SEC 3, LOT 33 (PT), ACRES 1.151','Cleared','50138','Appraisal District','','','0','','4','','0','','','Grill','','Composition','33 - Lamar Consolidated','MEYER ELEMENTARY SCHOOL (LAMAR)','RANDLE HIGH SCHOOL','WRIGHT JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Dove Meadows Sec 3','3054','1.7948','Aerobic,Well','2005','Appraisal District');  --> New record created successfully<br />