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` = '2023-01-10T21:07:39.800' ,`MLSNumber` = '78310458' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS                       ' ,`Latitude` = '29.509548' ,`Longitude` = '-95.714462' ,`PhotoCount` = '34' ,`PostalCode` = '77469' ,`RoomCount` = '17' ,`ListPrice` = '658957.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Moonstone' ,`StreetNumber` = '1602' ,`StreetSuffix` = 'Circle' ,`City` = 'Rosenberg' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4299' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE IN READY!! Westin Homes NEW Construction (Jaxson, Elevation A) Two story cul-de-sac lot. 4 bedrooms, 4.5 baths. Primary suite with large double walk-in closets and private bath. Additional bedroom with private bath on first floor as well. Spacious island kitchen with breakfast area open to family room. Formal dining room and study. Spacious game room and media room upstairs with two secondary bedrooms. Covered Patio and attached 4-car tandem garage. This growing community is already a comfortable home to many who appreciate its state-of-the-art amenities and calming landscape. Outside Stone Creek Estates is the flourishing suburb of Rosenberg, Texas. Shopping is around the corner, there are multiple five-star restaurants, and most importantly is the access to the highly recognized Lamar Consolidated ISD. Stop by the Westin Homes model to learn more about Stone Creek Estates!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 25 BLK 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12373' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stonecreek Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675112950' WHERE `Matrix_Unique_ID` = '207841259'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T21:05:37.140' ,`MLSNumber` = '7607891' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Kelvin Okunonke' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '29.509527' ,`Longitude` = '-95.713651' ,`PhotoCount` = '34' ,`PostalCode` = '77469' ,`RoomCount` = '17' ,`ListPrice` = '584557.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Glass Peak' ,`StreetNumber` = '6031' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3509' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE IN READY!! Westin Homes NEW Construction (Preston V, Elevation P) Two Story. 5 bedrooms, 4.5 baths. Private Primary Suite with large walk-in closet. Spacious kitchen open to Family Room. Dining Room and Study. Game Room, 4 bedrooms, and 3 bathrooms upstairs. Covered patio and 3 car attached garage. This growing community is already a comfortable home to many who appreciate its state-of-the-art amenities and calming landscape. Outside Stone Creek Estates is the flourishing suburb of Rosenberg, Texas. Shopping is around the corner, there are multiple five-star restaurants, and most importantly is the access to the highly recognized Lamar Consolidated ISD. Stop by the Westin Homes model to learn more about Stone Creek Estates!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 3 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9448' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stonecreek Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675112950' WHERE `Matrix_Unique_ID` = '208855717'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T21:10:16.577' ,`MLSNumber` = '93143439' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.509440' ,`Longitude` = '-95.713405' ,`PhotoCount` = '6' ,`PostalCode` = '77469' ,`RoomCount` = '16' ,`ListPrice` = '634857.00' ,`Status` = 'Active' ,`StreetName` = 'Glass Peak' ,`StreetNumber` = '6035' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3987' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Ashton, Elevation A) CURRENTLY BEING BUILT. Two Story. 4 bedrooms, 3.5 baths. Private Primary Suite with spacious double walk-in closets downstairs. Secondary bedroom with attached bathroom as well as Study on first floor. Spacious Kitchen and breakfast area open to Family Room and Formal Dining Room. Spacious Game Room upstairs with private Media Room. Covered patio and attached 3 car tandem garage. This growing community is already a comfortable home to many who appreciate its state-of-the-art amenities and calming landscape. Outside Stone Creek Estates is the flourishing suburb of Rosenberg, Texas. Shopping is around the corner, there are multiple five-star restaurants, and most importantly is the access to the highly recognized Lamar Consolidated ISD. Stop by the Westin Homes model to learn more about Stone Creek Estates!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 4 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9448' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stonecreek Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675112950' WHERE `Matrix_Unique_ID` = '211326915'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T21:04:41.780' ,`MLSNumber` = '51991062' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Carlyle Locke' ,`SellingOfficeName` = 'Keller Williams HoustonCentral' ,`Latitude` = '29.505078' ,`Longitude` = '-95.714639' ,`PhotoCount` = '7' ,`PostalCode` = '77469' ,`RoomCount` = '17' ,`ListPrice` = '624527.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Deep Lapis' ,`StreetNumber` = '1606' ,`StreetSuffix` = 'Circle' ,`City` = 'Rosenberg' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston V, Elevation B) CURRENTLY BEING BUILT. Two Story. 5 bedrooms, 4.5 baths. Private Primary Suite with large walk-in closet. Spacious kitchen open to Family Room. Dining Room and Study. Game Room, 4 bedrooms, and 3 bathrooms upstairs. Covered patio and 3 car attached garage. This growing community is already a comfortable home to many who appreciate its state-of-the-art amenities and calming landscape. Outside Stone Creek Estates is the flourishing suburb of Rosenberg, Texas. Shopping is around the corner, there are multiple five-star restaurants, and most importantly is the access to the highly recognized Lamar Consolidated ISD. Stop by the Westin Homes model to learn more about Stone Creek Estates!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 20 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11420' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stonecreek Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675112950' WHERE `Matrix_Unique_ID` = '211690225'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T21:31:05.803' ,`MLSNumber` = '43186237' ,`ListAgentFullName` = 'David James' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.089982' ,`Longitude` = '-95.550800' ,`PhotoCount` = '26' ,`PostalCode` = '77375' ,`RoomCount` = '9' ,`ListPrice` = '1900000.00' ,`Status` = 'Active' ,`StreetName` = 'Dowdell' ,`StreetNumber` = '8819' ,`StreetSuffix` = 'Road' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A rare find of a home on 10.5 acres in Spring, TX. Are you looking for that home that can also be your workplace, if so you have found it. A 4-bedroom home that has huge rooms, a room that can be an office for your business, 24 self-storage units to bring instant income, and warehouse building to do your business. Property offers multi-purpose opportunities as well a great homestead.' ,`Acres` = '10.37' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 39B ABST 70 E SMITH' ,`LotDesciption` = 'Other,Wooded' ,`LotSize` = '451717' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'SCHULTZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NA' ,`TaxAmount` = '10269' ,`TaxRate` = '2.0766' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675112951' WHERE `Matrix_Unique_ID` = '213782237'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T22:19:56.930' ,`MLSNumber` = '55126585' ,`ListAgentFullName` = 'Jennifer Medrano' ,`ListOfficeName` = 'Red Door Realty & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.954914' ,`Longitude` = '-95.180855' ,`PhotoCount` = '26' ,`PostalCode` = '77044' ,`RoomCount` = '6' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Mainstay Place Lane' ,`StreetNumber` = '12802' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2241' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '** Showings available starting 11/04/2022** Enjoy this charming 2 story contemporary home with 4 bedroom and  2.5 bathrooms. Downstairs are the formal dining with  an open concept kitchen leading into the living area with tons of natural light. Plus your primary bedroom with on-suite bathroom. Upstairs you have the flex area ( game room/ office etc.) with three bedrooms and one full bathroom. And lets not forget the large backyard, perfect to add a patio, outdoor kitchen and pool. Do not let this  opportunity pass you by, call myself or your favorite realtor today for a private tour.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 5 LAKESHORE SEC 05' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9845' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '924' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'LAKESHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lakeshore Sec' ,`TaxAmount` = '5582' ,`TaxRate` = '2.863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675112951' WHERE `Matrix_Unique_ID` = '214144110'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T21:02:06.390' ,`MLSNumber` = '14554920' ,`ListAgentFullName` = 'Kenneth Purswell' ,`ListOfficeName` = 'Kenneth Purswell - Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.043249' ,`Longitude` = '-95.427197' ,`PhotoCount` = '50' ,`PostalCode` = '77566' ,`RoomCount` = '12' ,`ListPrice` = '294900.00' ,`Status` = 'Active' ,`StreetName` = 'Rose Trail' ,`StreetNumber` = '103' ,`StreetSuffix` = 'Trail' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2051' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remarkable Remodel/Refurbish, Flooring, Painting, Fixtures, Counters, Cabinets, Bath Shower, Pool,' ,`Acres` = '0.254' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'KINGSWOOD ESTATES (LAKE JACKSON) BLK 2 LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11064' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BEUTEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Kingswood Estates Lake Jackson' ,`TaxAmount` = '4759' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675112951' WHERE `Matrix_Unique_ID` = '214613844'  --> 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','215517220','1675112951','215517220','2023-01-10T21:33:24.827','21542227','Allison Lee','RE/MAX Genesis','','','31.723384','-96.147459','24','75840','3','215000.00','Active','Commerce','657','Street','Fairfield','2','0','3','1320','Single-Family','Completely renovated like new!!!Open and spacious 3/2 with brick storage shed/carport situated on .361 ac lot. \r\nThe pier and beam was leveled, walls were insulated, and new sheetrock installed, sub-flooring and beautiful vinyl flooring throughout. From there let\'s start with a new roof, replaced all windows and doors, electrical with new wiring and breaker boxes, plumping repaired or replaced with PEX, and installation of central electric HVAC/Heat. The kitchen, bathrooms, and laundry room renovated with new cabinetry, granite, and new fixtures. Kitchen features pantry with all new oven, dishwasher, and microwave.  The list could go on you will have to come take a look for yourself!','0.361','74','','','Electric Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','1','','','Freestone County','Central Electric','0','R GAINOR A-12','Cleared,Other','15739','Survey','','','0','','0','Electric Oven','0','','','Freestanding Range','','Composition','226 - Fairfield','FAIRFIELD ELEMENTARY SCHOOL','FAIRFIELD HIGH SCHOOL','FAIRFIELD JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Left Side','Appraisal District','1','Traditional','NA','2897','2.0363','Public Sewer,Public Water','1935','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','215698733','1675112952','215698733','2023-01-10T21:58:34.270','705439','Damaris Gonzalez','Rose Above Realty','','','29.685501','-95.198282','25','77502','10','259900.00','Active','Pasadena','1731','Boulevard','Pasadena','2','0','3','1640','Single-Family','Welcome to this beautiful 3 bedrooms 2 bathrooms home, located right in the heart of Pasadena. Conveniently located on the corner right next to Pasadena Blvd. Has not one, but TWO living bedrooms, as well as a breakfast dining room and a formal dining area. Kitchen and bathrooms has been beautifully renovated. This house won\'t last long on the market! Come schedule your showing today!','0.2456','6','','','','','Sellers Disclosure','1','','','Pasadena','Central Gas','0','LT 287 BLK 10 SOUTH PASADENA VILLAS','Corner','10700','Appraisal District','','','0','','1','','0','','','','','Wood Shingle','41 - Pasadena','GARDENS ELEMENTARY SCHOOL','SAM RAYBURN HIGH SCHOOL','JACKSON INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front','Seller','1','Traditional','South Pasadena Villas','4677','2.6514','Public Sewer,Public Water','1953','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','216123802','1675112952','216123802','2023-01-10T22:03:47.777','52475661','Bradley Tiffan','Legend Home Corporation','','','30.014277','-95.412789','36','77073','6','267530.00','Active','King Heights','22106','Lane','Houston','2','1','4','1940','Single-Family','Love where you live in Imperial Heights in Houston, TX! The Devonhurst floor plan is a spacious 2-story home with 4 bedrooms, 2.5 baths, and 2-car garage. This home has it all, including blinds! The first floor offers the perfect space for entertaining with a peninsula kitchen open to both the living and dining areas! The gourmet kitchen is sure to please with 42\" cabinetry, granite countertops, and stainless-steel appliances! Upstairs offers a private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring a separate tub and shower and walk-in closet! Enjoy the great outdoors with full sod and a covered patio! Don’t miss your opportunity to call Imperial Heights home, schedule a visit today!','','12','Legend Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Aldine Area','Central Gas','1','Lot 69 Block 2 Section 1','Subdivision Lot','3541','Survey','','425','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','48 - Spring','CAROLEE BOOKER ELEMENTARY SCHOOL','ANDY DEKANEY H S','RICKY C BAILEY M S','Accompany,Appointment Required,No Supra Keybox','Builder','2','Traditional','Imperial Heights','','2.73','Water District','2023','Builder');  --> 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','216126400','1675112952','216126400','2023-01-10T22:05:38.550','38480563','Bradley Tiffan','Legend Home Corporation','','','30.014396','-95.412800','24','77073','6','264905.00','Active','King Heights','22110','Lane','Houston','2','1','3','2094','Single-Family','Love where you live in Imperial Heights in Houston, TX! The Shannon floor plan is a spacious 2-story home with 3 bedrooms, 2.5 bathrooms and a 2-car garage. This home has it all, including a flex room on the first floor! With an open kitchen, dining, and family room, you\'ll love entertaining in this home! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless-steel appliances. Upstairs offers a private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring a separate tub and shower and walk-in closet. Enjoy the great outdoors with full sod and a covered patio! Don’t miss your opportunity to call Imperial Heights home, schedule a visit today!','','12','Legend Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Aldine Area','Central Gas','1','Lot 68 Block 9 Section 1','Subdivision Lot','3508','Survey','','425','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','48 - Spring','CAROLEE BOOKER ELEMENTARY SCHOOL','ANDY DEKANEY H S','RICKY C BAILEY M S','Accompany,Appointment Required,No Supra Keybox','Builder','2','Traditional','Imperial Heights','','2.73','Water District','2023','Builder');  --> 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','216246487','1675112952','216246487','2023-01-10T22:20:06.897','82357279','Romana Nasir','eXp Realty, LLC','','','29.645266','-95.373344','9','77051','3','164900.00','Active','Fairland','10517','Drive','Houston','1','0','3','1140','Single-Family','3 Bed 1 Bath home off Airport. No restrictions!. Property is in excellent condition and has many upgrades. New roof, fence, floors and paint. All appliances included. Home includes separate dining and living room as well as a utility room. Minutes from the Medical center, HWY 288/Hwy 610. Great for an investment property! Call or request your showing today!','0.1263','3','','','','','No Disclosures','','','','Medical Center South','Central Electric','0','LT 15 BLK 24 BLUERIDGE SEC 2','Subdivision Lot','5500','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','REYNOLDS ELEMENTARY SCHOOL (HOUSTON)','WORTHING HIGH SCHOOL','ATTUCKS MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Blueridge Add Sec 02','3171','2.3307','Public Sewer,Public Water','1955','Appraisal District');  --> New record created successfully<br />