Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T07:28:41.417' ,`MLSNumber` = '62205953' ,`ListAgentFullName` = 'Victor Burks' ,`ListOfficeName` = 'Buyer First Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.671415' ,`Longitude` = '-95.350735' ,`PhotoCount` = '14' ,`PostalCode` = '77033' ,`RoomCount` = '4' ,`ListPrice` = '360990.00' ,`Status` = 'Active' ,`StreetName` = 'Bricker' ,`StreetNumber` = '5041' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'To be built Contemporary Home. 4/2.5/2. Construction completed. Has custom flooring, cabinets, and countertops. New homes being built in the area. Elevation and home interior pictures are not exact but approximate. Seller is accepting pre-construction contract offers. Potential buyer may select exterior and interior paint, flooring and countertops.' ,`Acres` = '0.0982' ,`Area` = '3' ,`BuilderName` = 'TBD' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 BRICKER STREET HOMES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '4278' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BASTIAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bricker Street Homes' ,`TaxAmount` = '517' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675264977' WHERE `Matrix_Unique_ID` = '205472041' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T08:03:39.743' ,`MLSNumber` = '43283254' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.832312' ,`Longitude` = '-95.863288' ,`PhotoCount` = '39' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '409000.00' ,`Status` = 'Active' ,`StreetName` = 'Marisol Bay' ,`StreetNumber` = '843' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2389' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 1.5 story homes welcomes you with a grand\r\nentrance and a very open concept floorpan. Offering 3\r\nbedrooms, 2.5 bathrooms plus.a bonus game room; there is\r\nplenty of space for everyone. Relax In the evening in the\r\nprimary suite or take a dip in the soaking tub. You can also\r\nenjoy a nice evening on the covered patio as you relax in the\r\ncomfort of your new home. Come see us in Sunterra today to\r\nview this beautiful home. It won\'t last long.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5, Block 2, Section 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.5' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675264977' WHERE `Matrix_Unique_ID` = '206110752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T08:04:50.860' ,`MLSNumber` = '48653032' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.832312' ,`Longitude` = '-95.863288' ,`PhotoCount` = '41' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Sarasota Shore' ,`StreetNumber` = '855' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2543' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to our sprawling one-story Victoria floorplan offering four bedrooms plus a study and an oversized garage. The open main living space includes a gorgeous fireplace and semi-vaulted ceilings. Designer interior selections include painted cabinetry, a beautiful kitchen backsplash, and a wood mantel over the fireplace. The spacious primary bedroom is tucked away for privacy and has a huge walk-in closet and garden tub complemented with a luxury shower. With over 1,039 acres and a 3.5-acre crystal lagoon, a home in Sunterra is where vacation never ends. This expansive master-planned community is also home to an 8,000 sq. ft. clubhouse, several white-sand beaches, hammocks and celebration lawns, grotto with a waterfall and swimming pool. A home in Sunterra means never having to leave your home for a vacation while also living in your exceptionally built Empire Home! Don\'t miss out on this beautiful home.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 19, Block 1, Section 8' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675264977' WHERE `Matrix_Unique_ID` = '208427054' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T08:02:48.513' ,`MLSNumber` = '15672915' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.832312' ,`Longitude` = '-95.863288' ,`PhotoCount` = '42' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '435000.00' ,`Status` = 'Active' ,`StreetName` = 'Ocean Palms' ,`StreetNumber` = '713' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2293' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Wilcox is one of the most popular 2 stories plans that Empire offers. This spacious home includes 4 bedrooms, 2.5 bathrooms, a game room, and a covered back patio. Enter through the covered porch to be drawn into this beautiful light and bright open concept home. The eat-in kitchen includes an oversized island with granite countertops, a gas range, GE stainless steel appliances, and an abundant amount of cabinetry with a grey and white palette. This plan adds a powder room to the first floor to accommodate guests, a laundry room that has plenty of extra space to fit an additional fridge or freezer, and a luxury primary bedroom you can call your personal oasis. Primary bathroom and feel relaxed in your own spa-like area that includes dual vanities, a built-in garden tub, a separate stand-up shower, and a large walk-in closet. As a Sunterra resident, you\'ll have access to an abundance of amenities including a crystal clear lagoon, white sand beaches, hammocks, pool and much more.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4, Block 1, Section 7' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675264977' WHERE `Matrix_Unique_ID` = '209300198' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T08:01:38.253' ,`MLSNumber` = '63662261' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.832312' ,`Longitude` = '-95.863288' ,`PhotoCount` = '35' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Ocean Palms' ,`StreetNumber` = '745' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1983' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 1.5 story welcomes you in with an outstanding entryway that leads into the kitchen. An open concept floor plan for great entertainment. The kitchen offers beautiful granite countertops with 42inch upper and lower cabinets, great for the chef of the family. The primary suite offers a relaxing garden tub with a luxury shower. The half-floor upstairs has a powder bath which is great for a game room. Do not miss out on this home, schedule your visit today.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12, Block 1, Section 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675264978' WHERE `Matrix_Unique_ID` = '209316174' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T08:06:11.323' ,`MLSNumber` = '22567228' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.832312' ,`Longitude` = '-95.863288' ,`PhotoCount` = '44' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Bahia Bay' ,`StreetNumber` = '800' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2974' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to our gorgeous Baker floorplan. This home features two bedrooms down and three bedrooms up plus a spacious game room! The living room is a perfect blend of cozy and family-friendly styles. Designer selections throughout include 42” painted cabinetry and quartz countertops. Wind down in your spacious primary bedroom featuring semi-vaulted ceilings, a garden tub, and a stone mosaic mud set shower. This home is an entertainer’s dream with its huge game room and oversized covered patio!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12, Block 2, Section 8' ,`LotDesciption` = 'Corner,Subdivision Lot,Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675264978' WHERE `Matrix_Unique_ID` = '209318309' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T08:42:42.733' ,`MLSNumber` = '10206023' ,`ListAgentFullName` = 'Mark Dimas' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072166' ,`Longitude` = '-95.091106' ,`PhotoCount` = '50' ,`PostalCode` = '77336' ,`RoomCount` = '5' ,`ListPrice` = '244990.00' ,`Status` = 'Active' ,`StreetName` = 'Teton Hollow' ,`StreetNumber` = '24707' ,`StreetSuffix` = 'Trail' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1267' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home built by Cyrene Homes! Spacious floor plans! This beautiful new build boasts a kitchen with granite countertops, recessed lighting, & stainless steel appliances! Designer finishes! Oversized homes available! Zoned to Huffman ISD! Walking distance from the nearby elementary school! Moments from Lake Houston Marina! Enjoy the lake breezes! Within proximity to TX-99, I-69, and Alt 90!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Cyrene Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675264978' WHERE `Matrix_Unique_ID` = '210912902' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T08:43:12.637' ,`MLSNumber` = '78689432' ,`ListAgentFullName` = 'Mark Dimas' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.026043' ,`Longitude` = '-95.084261' ,`PhotoCount` = '45' ,`PostalCode` = '77336' ,`RoomCount` = '5' ,`ListPrice` = '262990.00' ,`Status` = 'Active' ,`StreetName` = 'Teton Hollow' ,`StreetNumber` = '24715' ,`StreetSuffix` = 'Trail' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1597' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home built by Cyrene Homes! Spacious floor plans! This beautiful new build boasts a kitchen with granite countertops, recessed lighting, & stainless steel appliances! Designer finishes! Oversized homes available! Zoned to Huffman ISD! Walking distance from the nearby elementary school! Moments from Lake Houston Marina! Enjoy the lake breezes! Within proximity to TX-99, I-69, and Alt 90!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Cyrene Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675264978' WHERE `Matrix_Unique_ID` = '210916630' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T08:41:44.220' ,`MLSNumber` = '51274904' ,`ListAgentFullName` = 'Mark Dimas' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.029413' ,`Longitude` = '-95.111383' ,`PhotoCount` = '50' ,`PostalCode` = '77336' ,`RoomCount` = '5' ,`ListPrice` = '262990.00' ,`Status` = 'Active' ,`StreetName` = 'Emerald Thicket' ,`StreetNumber` = '310' ,`StreetSuffix` = 'Lane' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1597' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home built by Cyrene Homes! Spacious floor plans! This beautiful new build boasts a kitchen with granite countertops, recessed lighting, & stainless steel appliances! Designer finishes! Oversized homes available! Zoned to Huffman ISD! Walking distance from the nearby elementary school! Moments from Lake Houston Marina! Enjoy the lake breezes! Within proximity to TX-99, I-69, and Alt 90!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Cyrene Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675264979' WHERE `Matrix_Unique_ID` = '210916759' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T08:43:02.340' ,`MLSNumber` = '52700924' ,`ListAgentFullName` = 'Mark Dimas' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.026043' ,`Longitude` = '-95.084261' ,`PhotoCount` = '49' ,`PostalCode` = '77336' ,`RoomCount` = '6' ,`ListPrice` = '265990.00' ,`Status` = 'Active' ,`StreetName` = 'Teton Hollow' ,`StreetNumber` = '24713' ,`StreetSuffix` = 'Trail' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1689' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home built by Cyrene Homes! Spacious floor plans! This beautiful new build boasts a kitchen with granite countertops, recessed lighting, & stainless steel appliances! Designer finishes! Oversized homes available! Zoned to Huffman ISD! Walking distance from the nearby elementary school! Moments from Lake Houston Marina! Enjoy the lake breezes! Within proximity to TX-99, I-69, and Alt 90!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Cyrene Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675264979' WHERE `Matrix_Unique_ID` = '210917005' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T08:41:55.980' ,`MLSNumber` = '76884090' ,`ListAgentFullName` = 'Mark Dimas' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.029413' ,`Longitude` = '-95.111383' ,`PhotoCount` = '49' ,`PostalCode` = '77336' ,`RoomCount` = '6' ,`ListPrice` = '268990.00' ,`Status` = 'Active' ,`StreetName` = 'Emerald Thicket' ,`StreetNumber` = '314' ,`StreetSuffix` = 'Lane' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1689' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home built by Cyrene Homes! Spacious floor plans! This beautiful new build boasts a kitchen with granite countertops, recessed lighting, & stainless steel appliances! Designer finishes! Oversized homes available! Zoned to Huffman ISD! Walking distance from the nearby elementary school! Moments from Lake Houston Marina! Enjoy the lake breezes! Within proximity to TX-99, I-69, and Alt 90!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Cyrene Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675264979' WHERE `Matrix_Unique_ID` = '210917263' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T08:42:51.920' ,`MLSNumber` = '64956426' ,`ListAgentFullName` = 'Mark Dimas' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.026043' ,`Longitude` = '-95.084261' ,`PhotoCount` = '49' ,`PostalCode` = '77336' ,`RoomCount` = '5' ,`ListPrice` = '241990.00' ,`Status` = 'Active' ,`StreetName` = 'Teton Hollow' ,`StreetNumber` = '24711' ,`StreetSuffix` = 'Trail' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1243' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home built by Cyrene Homes! Spacious floor plans! This beautiful new build boasts a kitchen with granite countertops, recessed lighting, & stainless steel appliances! Designer finishes! Oversized homes available! Zoned to Huffman ISD! Walking distance from the nearby elementary school! Moments from Lake Houston Marina! Enjoy the lake breezes! Within proximity to TX-99, I-69, and Alt 90!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Cyrene Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675264979' WHERE `Matrix_Unique_ID` = '210917413' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T08:42:06.073' ,`MLSNumber` = '3061565' ,`ListAgentFullName` = 'Mark Dimas' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.029413' ,`Longitude` = '-95.111383' ,`PhotoCount` = '50' ,`PostalCode` = '77336' ,`RoomCount` = '5' ,`ListPrice` = '241990.00' ,`Status` = 'Active' ,`StreetName` = 'Emerald Thicket' ,`StreetNumber` = '330' ,`StreetSuffix` = 'Trail' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1243' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home built by Cyrene Homes! Spacious floor plans! This beautiful new build boasts a kitchen with granite countertops, recessed lighting, & stainless steel appliances! Designer finishes! Oversized homes available! Zoned to Huffman ISD! Walking distance from the nearby elementary school! Moments from Lake Houston Marina! Enjoy the lake breezes! Within proximity to TX-99, I-69, and Alt 90!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Cyrene Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675264979' WHERE `Matrix_Unique_ID` = '210917678' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T08:42:24.870' ,`MLSNumber` = '43961247' ,`ListAgentFullName` = 'Mark Dimas' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.029413' ,`Longitude` = '-95.111383' ,`PhotoCount` = '37' ,`PostalCode` = '77336' ,`RoomCount` = '5' ,`ListPrice` = '258740.00' ,`Status` = 'Active' ,`StreetName` = 'Emerald Thicket' ,`StreetNumber` = '332' ,`StreetSuffix` = 'Lane' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1427' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home built by Cyrene Homes! Spacious floor plans! This beautiful new build boasts a kitchen with granite countertops, recessed lighting, & stainless steel appliances! Designer finishes! Oversized homes available! Zoned to Huffman ISD! Walking distance from the nearby elementary school! Moments from Lake Houston Marina! Enjoy the lake breezes! Within proximity to TX-99, I-69, and Alt 90!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Cyrene Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675264980' WHERE `Matrix_Unique_ID` = '210918005' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T08:41:25.297' ,`MLSNumber` = '96579387' ,`ListAgentFullName` = 'Pamela Smartt' ,`ListOfficeName` = 'Keller Williams Realty - Memor' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.641634' ,`Longitude` = '-98.114337' ,`PhotoCount` = '21' ,`PostalCode` = '78130' ,`RoomCount` = '10' ,`ListPrice` = '359900.00' ,`Status` = 'Active' ,`StreetName` = 'Legend' ,`StreetNumber` = '4047' ,`StreetSuffix` = 'Meadows' ,`City` = 'New Braunfels' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1997' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller for this beautiful home with price reduction, buyer concession of $5000 and move in ready! This 4 bed 2 bath GEHAN Home features a private master bedroom with an extended walk in closet, large walk in shower, upgraded flooring throughout home, a large family room and open floor concept. The gourmet kitchen has an island, granite countertops, walk in pantry, convection oven, gas range and 42\" cabinets. The exterior is landscaped, with privacy fence and charming covered patio in back to relax after a long day. Call today and make this your new home!' ,`Acres` = '0.14' ,`Area` = '83' ,`BuilderName` = 'Gehan' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LEGEND POND-LEGEND MEADOW PH #4 BLOCK 18 LOT 26 .14 AC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6098' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '315' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '142 - New Braunfels' ,`SchoolElementary` = 'KLEIN ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEW BRAUNFELS HIGH SCHOOL' ,`SchoolMiddle` = 'NEW BRAUNFELS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Legend Pond-Legend Mdw Ph 4' ,`TaxAmount` = '7728' ,`TaxRate` = '2.0531' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675264980' WHERE `Matrix_Unique_ID` = '211357684' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T07:39:23.227' ,`MLSNumber` = '38133925' ,`ListAgentFullName` = 'Jaimie Harvey' ,`ListOfficeName` = 'United Country JW Realty andAuction Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.339656' ,`Longitude` = '-94.187878' ,`PhotoCount` = '37' ,`PostalCode` = '77656' ,`RoomCount` = '3' ,`ListPrice` = '115000.00' ,`Status` = 'Active' ,`StreetName` = 'Durdin' ,`StreetNumber` = '475' ,`StreetSuffix` = 'Drive' ,`City` = 'Silsbee' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1288' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The home is a 3 bedroom 2 bath with a cast iron claw foot tub, enjoy long baths as you are able to relax in this soaker tub. Large yard with Mature Pine trees, new porches, and cement for parking under the covered carport. Cement Sidewalk leading to front and back porches 8x10 front porch, 10x12 back porch, new 23 x 20 driveway, and a new 20x21x6 carport. New Central air and Heat with a 10 year warranty. \r\n\r\nIf you are looking to move to the country and be close to schools take a look at this property it has a lot to offer.' ,`Acres` = '0.51' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 160 E CHANCE RENT PROPERTY P# 160-39' ,`LotDesciption` = 'Cleared' ,`LotSize` = '22216' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '252 - Silsbee' ,`SchoolElementary` = 'SILSBEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SILSBEE HIGH SCHOOL' ,`SchoolMiddle` = 'EDWARDS-JOHNSON MEMORIAL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'n/a' ,`TaxAmount` = '1313' ,`TaxRate` = '2.3756' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1923' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675264980' WHERE `Matrix_Unique_ID` = '211783822' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T07:47:16.923' ,`MLSNumber` = '93492094' ,`ListAgentFullName` = 'Suzanne Corbin' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices' ,`SellingAgentFullName` = 'Dustin Young' ,`SellingOfficeName` = 'Compean Group' ,`Latitude` = '29.266008' ,`Longitude` = '-94.839109' ,`PhotoCount` = '34' ,`PostalCode` = '77551' ,`RoomCount` = '10' ,`ListPrice` = '579900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Colony Park' ,`StreetNumber` = '10' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3062' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Impressive Home w/Porte Cochere, Pool, & Large Covered Patio f/Outdoor Living Area In Colony Park, One of Galveston\'s Best Neighborhoods! This Nicely Renovated 3 Bedroom, 3 Bath, 3 Car Garage Home w/Circular Drive & So Many Extra Features! Double-Sided, Wood-Burning Fireplace Greets You in the Enormous Gallery-Style \r\nEntry. Arched Wrought-Iron Gates Lead to the Massive Den w/Cathedral Ceiling & Tucked Away Wet-Bar Area That Can Be Hidden Behind Closed Doors. Spacious Primary Bedroom Accommodates Large Furnishings-Complete w/En-Suite Bath w/Both Shower & Over-Sized Tub. Additional Guest Bedroom & Bath-Located on 1st Floor. Up the Stairs, a Wrap-Around Balcony Area w/Library Over-Looking the Grand Den. 3rd Bedroom w/Bath is Located on the 2nd Floor. Beautiful Block Wood Paneling Gives an Elegant & Warm Feel to the Over-All Decor. Amazing, Copious Closets & Storage Throughout. Large Lot-Maintained w/Sprinkler System-Stunning Pool & Grassy Areas. Owner Licensed Agent is Not Listing Agent' ,`Acres` = '0.2918' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Near West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 23 BLK 4 COLONY PARK SEC 2' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12711' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Colony Park 2' ,`TaxAmount` = '5565' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675264980' WHERE `Matrix_Unique_ID` = '212086061' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T07:05:39.903' ,`MLSNumber` = '54994735' ,`ListAgentFullName` = 'Ashly Singletary' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.815202' ,`Longitude` = '-95.383411' ,`PhotoCount` = '8' ,`PostalCode` = '77022' ,`RoomCount` = '4' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = '32nd' ,`StreetNumber` = '1212' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1338' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Please verify all room dimensions. This home is located in a prime location. Minutes from downtown, 45 and 290. Get your showing scheduled before it is gone. Home has great potential and ready for you to make it your own. Gorgeous fencing around the front, with a nice porch to enjoy your morning coffee. Laundry is located in the garage. Home being sold AS IS.' ,`Acres` = '0.0918' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 3 AIRLINE HEIGHTS' ,`LotDesciption` = 'Other' ,`LotSize` = '4000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURRUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Airline Heights' ,`TaxAmount` = '3027' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675264981' WHERE `Matrix_Unique_ID` = '212422137' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T08:00:47.977' ,`MLSNumber` = '48559253' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.832312' ,`Longitude` = '-95.863288' ,`PhotoCount` = '3' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Ocean Palms' ,`StreetNumber` = '704' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1857' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well suited to a variety of lifestyle needs, this Richmond is a 4 bedroom, 2.5 bathroom home that\'s spacious and functional, with an open-concept kitchen and great room and sizable primary bedroom complete with a large walk in closet and spalike ensuite. Enjoy all this the Richmond has to offer plus a walkin kitchen pantry, luxury vinyl plank throughout the great room, and a large, covered patio with a ceiling fan to beat the Texas heat.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 32, Block 1, Section 7' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675264981' WHERE `Matrix_Unique_ID` = '212878311' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T08:07:17.857' ,`MLSNumber` = '84979769' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.832312' ,`Longitude` = '-95.863288' ,`PhotoCount` = '47' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = 'Sarasota Shore' ,`StreetNumber` = '800' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2579' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Cameron floor plan is designed to impress. With its open concept family room on the main level, which flows seamlessly onto a covered patio, the opportunities for design are endless. A spacious owner\'s suite is located towards the back of the home, fitted with a walk-in closet, luxurious ensuite and large walk-in closet. As you make your way up to the second floor, you\'ll notice the central games room, perfect for families with children or for those who love to entertain. The Sunterra crystal clear lagoon is the hottest place to be in Texas and a unique staycation destination. Come in to see this beautiful home.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1, Block 1, Section 8' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot,Water View' ,`LotSize` = '7272' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675264981' WHERE `Matrix_Unique_ID` = '212879052' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T07:04:43.963' ,`MLSNumber` = '46240997' ,`ListAgentFullName` = 'Patricia Grijalva' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = 'Paula Wehring' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '30.391671' ,`Longitude` = '-95.622978' ,`PhotoCount` = '49' ,`PostalCode` = '77356' ,`RoomCount` = '8' ,`ListPrice` = '495000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wood Harbour' ,`StreetNumber` = '12906' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3105' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PLEASE NOTE THAT THIS HOUSE IS BUILT ON TWO LOTS, WITH A TOTAL OF 20,649 SQFT\r\n This is a One of kind opportunity, to have this house on the best location of the Walden Golf Course. With breathtaking views of the 18th hole of The Walden Golf Course,\r\nThis house is built on two lots, features 4 bedrooms and 3.5 baths. Enjoy a beautiful and private pool and amazing views from every angle of the house and the back yard. Don’t miss out on this amazing opportunity' ,`Acres` = '0.2413' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALDEN 09, BLOCK 53, LOT 2' ,`LotDesciption` = 'In Golf Course Community,On Golf Course' ,`LotSize` = '20649' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden on Lake Conroe' ,`TaxAmount` = '6579' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675264981' WHERE `Matrix_Unique_ID` = '212970756' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T08:20:53.900' ,`MLSNumber` = '92330696' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.081317' ,`Longitude` = '-95.386010' ,`PhotoCount` = '34' ,`PostalCode` = '77373' ,`RoomCount` = '9' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Laurel Green' ,`StreetNumber` = '25310' ,`StreetSuffix` = 'Street' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2148' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fall in love with this wonderful 3-bedroom, 2.5-bathroom home in Lexington Woods, which boasts a brick exterior, tile flooring, crown molding, formal dining room, game room, open great room, and a gazebo in the spacious backyard. Impress your guests in the kitchen, fully equipped with granite countertops, tile backsplash, gas cooktop, breakfast bar, and dining nook. The spa-like primary suite features a walk-in closet, dual vanities, a soaking tub, and a separate shower. Residents enjoy tennis courts, a swimming pool, and walking trails. Commuters enjoy quick access to the Grand Parkway, I-45, and the Hardy Toll Road. Residents are only a short distance from a variety of shopping, dining, and entertainment, including Old Town Spring, Pundt Park, and The Woodlands Mall. Zoned to the recognized Spring ISD.' ,`Acres` = '0.1389' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 1 LEXINGTON WOODS SEC 8' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'JOHN WINSHIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lexington Woods' ,`TaxAmount` = '4992' ,`TaxRate` = '2.2769' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675264982' WHERE `Matrix_Unique_ID` = '213274809' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T08:35:04.933' ,`MLSNumber` = '66039336' ,`ListAgentFullName` = 'Karen Vizena' ,`ListOfficeName` = 'Evans and Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.839134' ,`Longitude` = '-95.156219' ,`PhotoCount` = '47' ,`PostalCode` = '77360' ,`RoomCount` = '7' ,`ListPrice` = '364900.00' ,`Status` = 'Active' ,`StreetName` = 'Sumac' ,`StreetNumber` = '148' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1661' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updates throughout this 4/2 home near Lake Livingston! 3 large lots, fenced backyard, & no side neighbors. Sellers installed all new vinyl windows +2 new windows for natural lighting & an exterior side door. The home has fresh new paint throughout, new light fixtures, faucets, ceiling fans, thermostat controlled attic fan & upgraded electrical box. Living room is highlighted by a tray ceiling & picture window. Kitchen has freshly painted cabinets & granite counter tops. Split floorplan provides privacy for owners & their guests or family. Outside is a new 30x40 metal building w/electricity, 2 oversized garage doors w/automatic openers, 2 man doors, a 3rd roll up door, double wide cement drive, french drain, and plumbing has been roughed in for an addl bathroom for convenience when outside. 2 carports & RV/boat cover. The above ground pool is surrounded by beautiful & spacious decking. Creekside Estates has a private boat ramp, pavilion, & walking trails. Don\'t let this one get away!!!' ,`Acres` = '0.7713' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CREEKSIDE SECTION 2 BLK 10 LOT 19, 20 & 21' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '33600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekside Sec 2' ,`TaxAmount` = '3746' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675264982' WHERE `Matrix_Unique_ID` = '213307950' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T07:59:02.100' ,`MLSNumber` = '9573233' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empir