Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T10:11:54.550' ,`MLSNumber` = '54681955' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.556659' ,`Longitude` = '-94.388793' ,`PhotoCount` = '17' ,`PostalCode` = '75670' ,`RoomCount` = '4' ,`ListPrice` = '66999.00' ,`Status` = 'Active' ,`StreetName` = 'Madam Queen' ,`StreetNumber` = '1407' ,`StreetSuffix` = 'Street' ,`City` = 'Marshall' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A cute little home sitting on ALMOST A WHOLE ACRE! An investor special that requires a little bit of work and then it can be your dream home. This home features a wide porch perfect for outdoor lounging and plenty of yard space for all kinds of outdoor activities. Easy access to HWY 390 & HWY 80. Literally minutes away from East Texas Baptist University. A prime location surrounded by many dining and shopping options! AS IS!' ,`Acres` = '0.972' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ACRES: 0.972, LOT: 3-6 & 12, BLK: 1, SUBD: HARLEM NORTH 2ND,' ,`LotDesciption` = 'Other' ,`LotSize` = '42340' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '99 - Other' ,`SchoolElementary` = 'J H MOORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (MARSHALL)' ,`SchoolMiddle` = 'MARSHALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Harlem North 2nd' ,`TaxAmount` = '594' ,`TaxRate` = '2.157' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091712' WHERE `Matrix_Unique_ID` = '192041006' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T10:13:48.960' ,`MLSNumber` = '40582896' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.542859' ,`Longitude` = '-94.386845' ,`PhotoCount` = '22' ,`PostalCode` = '75670' ,`RoomCount` = '6' ,`ListPrice` = '66999.00' ,`Status` = 'Active' ,`StreetName` = 'Acorn' ,`StreetNumber` = '110' ,`StreetSuffix` = 'Drive' ,`City` = 'Marshall' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a home that needs your DIY skills? This property has so much to offer that it feels like home when you drive up. This home is just waiting for the right person to come in update and customize it.' ,`Acres` = '0.296' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ACRES: 0.296, LOT: 14 N/PT 17, BLK: 1, SUBD: WEST OAKS, HSE' ,`LotDesciption` = 'Other' ,`LotSize` = '12894' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '99 - Other' ,`SchoolElementary` = 'G W CARVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (MARSHALL)' ,`SchoolMiddle` = 'MARSHALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'West Oaks' ,`TaxAmount` = '749' ,`TaxRate` = '2.157' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1925' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091712' WHERE `Matrix_Unique_ID` = '192048472' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T09:12:11.117' ,`MLSNumber` = '82987101' ,`ListAgentFullName` = 'Mark Coyle' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.296131' ,`Longitude` = '-94.816654' ,`PhotoCount` = '14' ,`PostalCode` = '77550' ,`RoomCount` = '7' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = '44th' ,`StreetNumber` = '712' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Take advantage of this pre-construction sale of this New home that will be approximately 1000 square feet to be completed Mid 2022. Make this home your own if you buy before February 28, 2022 you can select all paint colors, decors and miscellaneous build out items. The location is conveniently located close to the Strand, shopping, UTMB, beach, and great access to Broadway/45 and Harborside drive. The home has an open concept to kitchen, living, and dining with vaulted ceilings. Great for entertaining and family events. The floor plan is nicely laid out to save space and flows well. Bedrooms, Kitchen, Bathroom, & Utility rooms all have 9\' ceilings. There also is a wonderful front porch for entertaining or watching sunsets. The lower level includes a garage and shop/storage area. Also the property is located in an AE Flood Zone!!!!' ,`Acres` = '0.0367' ,`Area` = '33' ,`BuilderName` = 'Maerz' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Harborside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR S PT OF LOTS 1,2 & N 1/2 OF ADJ ALLE' ,`LotDesciption` = 'Corner' ,`LotSize` = '1600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '114' ,`TaxRate` = '2.262' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675091712' WHERE `Matrix_Unique_ID` = '203742707' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T10:50:00.963' ,`MLSNumber` = '76926878' ,`ListAgentFullName` = 'Cari Goeke' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.699550' ,`Longitude` = '-95.966854' ,`PhotoCount` = '25' ,`PostalCode` = '77457' ,`RoomCount` = '3' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 251' ,`StreetNumber` = '1509' ,`StreetSuffix` = '' ,`City` = 'Matagorda' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2086' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location, are you looking for nearby beach property, here it is! Well maintained and recently updated home in Matagorda is ready for you! Offering 3 bedrooms, 3 bathrooms, this home has plenty of space for entertaining with an open-concept kitchen, dining, and living room. Recent upgrades include A/C, both water heaters replaced in 2020, and new paint/updates in the kitchen, living and dining room in 2021. As you step outside, you\'ll find a completely fenced yard for your four-legged family members along with a full one acre to expand if you need. Did we mention the best part? A 40 x 30 metal building to house your boat, lawnmower, or other valuables. Along with both an attached and detached carport, this property has it all! Come take a look for yourself, this one won\'t last long!' ,`Acres` = '1.072' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WIGHTMAN MATAGORDA OUTLOTS AB 101 PT OUTLOT 12 1.072 AC (TR' ,`LotDesciption` = 'Cleared' ,`LotSize` = '46696' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '170 - Matagorda' ,`SchoolElementary` = 'MATAGORDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'MATAGORDA ELEMENTARY SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Matagorda Townsite' ,`TaxAmount` = '4482' ,`TaxRate` = '1.7637' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091712' WHERE `Matrix_Unique_ID` = '204865891' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T09:24:18.383' ,`MLSNumber` = '46055288' ,`ListAgentFullName` = 'Kirby Smith' ,`ListOfficeName` = 'Kirby Smith Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.055258' ,`Longitude` = '-94.256177' ,`PhotoCount` = '41' ,`PostalCode` = '77713' ,`RoomCount` = '8' ,`ListPrice` = '464900.00' ,`Status` = 'Active' ,`StreetName` = 'South Pine Island' ,`StreetNumber` = '2275' ,`StreetSuffix` = 'Road' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2325' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Kinsmen Homes Shea Plan!This is a must see country craftsman exterior, split floor plan with large owner\'s retreat that includes a master bath with his/her vanities & walk-in closet. Large family room with fireplace is open to the gourmet kitchen that boasts granite counter tops, stainless steel appliances, oversized range. Interior has both breakfast room off kitchen and separate dining room -- great for those large gatherings! The exterior offers an oversized front porch and covered back patio -- perfect for relaxing with a cold drink in your hand!' ,`Acres` = '' ,`Area` = '51' ,`BuilderName` = 'Kinsmen Homes LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 6 The Crossing at Pine Island Phase I' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'CHINA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Crossing at Pine Island' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Septic Tank,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091713' WHERE `Matrix_Unique_ID` = '209354787' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T09:04:05.953' ,`MLSNumber` = '90087597' ,`ListAgentFullName` = 'Kelli Owens' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.710812' ,`Longitude` = '-95.094300' ,`PhotoCount` = '35' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '155540.00' ,`Status` = 'Active' ,`StreetName` = 'Anns' ,`StreetNumber` = '135' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'URGENT - The seller is about to begin the rehab on this property. If you are looking for a deal, now is the time to act. Once rehab begins, price will change. Investors or handyman special. This home needs some TLC. Owner carryback is available. The home is sitting on .6233 acres and has access to the subdivision\'s fishing pier. Home has new electrical and pex plumbing already completed.' ,`Acres` = '0.6233' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'NUGENT\'S COVE SECTION 2 BLK 9 LOT 1, 2 & 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '27150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Nugents Cove Sec 2' ,`TaxAmount` = '672' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Septic Tank' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091713' WHERE `Matrix_Unique_ID` = '209964063' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T09:17:25.027' ,`MLSNumber` = '50432671' ,`ListAgentFullName` = 'Karim Shoraka' ,`ListOfficeName` = 'American Champions Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.739317' ,`Longitude` = '-95.528332' ,`PhotoCount` = '9' ,`PostalCode` = '77063' ,`RoomCount` = '6' ,`ListPrice` = '769000.00' ,`Status` = 'Active' ,`StreetName` = 'Shady Lane' ,`StreetNumber` = '9307' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3652' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remodeled and updated House with covered pool in a very nice and quiet Gated Community.' ,`Acres` = '0.1848' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 SHADY LANE ESTATES AMENDED' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'EMERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial,Other Style' ,`Subdivision` = 'Shady Lane Estates Amd' ,`TaxAmount` = '15674' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091713' WHERE `Matrix_Unique_ID` = '212212120' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T10:36:02.813' ,`MLSNumber` = '30626080' ,`ListAgentFullName` = 'Michelle Marek' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.153003' ,`Longitude` = '-95.679756' ,`PhotoCount` = '14' ,`PostalCode` = '77362' ,`RoomCount` = '10' ,`ListPrice` = '867943.00' ,`Status` = 'Active' ,`StreetName` = 'Groveton Ridge' ,`StreetNumber` = '1022' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4347' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy resort-style living in the master planned community of Woodtrace, including the 23-acre Lake and recreation center with pool, clubhouse and five miles of wooded greenbelt trails. The brand-new Comal II plan features a traditional painted brick exterior, 4 bedrooms, 4 full, 2 half bathrooms and 3-car garage. Chef\'s kitchen has Quartz countertops, sliding glass doors in breakfast area, SS upgraded appliances, double-ovens, beverage cooler and custom cabinetry. It is the perfect home for entertaining with an open concept floor plan and covered patio with outdoor kitchen. Primary suite features a spa-like bathroom with dual sinks, a separate bathtub and signature walk-through shower with designer tile. Upstairs features two bedrooms with ensuite baths, media, and large game room w/ balcony overlooking backyard. Smart home features included with white glove service after closing. J. Patrick Homes recently awarded the GHBA Prism Awards - Volume Builder of the Year Grand Award.' ,`Acres` = '0.2428' ,`Area` = '15' ,`BuilderName` = 'J Patrick Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S959491 - WOODTRACE 08-B, BLOCK 1, LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10577' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodtrace' ,`TaxAmount` = '1734' ,`TaxRate` = '3.2015' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091713' WHERE `Matrix_Unique_ID` = '213489340' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T10:08:23.567' ,`MLSNumber` = '46782554' ,`ListAgentFullName` = 'Elizabeth Boles' ,`ListOfficeName` = 'One10 Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.477369' ,`Longitude` = '-94.575310' ,`PhotoCount` = '45' ,`PostalCode` = '77650' ,`RoomCount` = '11' ,`ListPrice` = '2400000.00' ,`Status` = 'Active' ,`StreetName` = 'Smiths' ,`StreetNumber` = '3450' ,`StreetSuffix` = 'Point' ,`City` = 'Crystal Beach' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This coastal living dream home combines supreme quality with sophisticated style and breathtaking views of the Gulf of Mexico. This custom-built oceanfront haven offers a true sense of ‘living the dream’! The expansive kitchen is sure to inspire your inner chef with its stainless steel appliances, sleek oven, refrigerated drawers, and sub-zero refrigerator. Entertaining is made easy with a wet bar and a spacious great room that showcases ocean vistas & opens onto a large terrace with a screened-in porch. The generous primary wing was designed for privacy and space, & features an ocean view, double vanities, walk-in closets, & a large walk-in shower. The three guest rooms come complete with en suite baths & plenty of closet space. This spectacular beachfront home is equipped with a 3-stop personal elevator, attached garage, fenced yard, air conditioned sunroom, media room, & electric storm shutters. Experience lack of crowds on the quiet part of Bolivar Peninsula' ,`Acres` = '0.808' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SEA BREEZE WEST SEC 2 (2016) ABST 65, LOT 7 & PT OF PRVT R.O' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '35197' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sea Breeze West' ,`TaxAmount` = '17616' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091714' WHERE `Matrix_Unique_ID` = '213770400' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T10:11:53.740' ,`MLSNumber` = '40814628' ,`ListAgentFullName` = 'Kimberly Pena' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.222901' ,`Longitude` = '-95.517638' ,`PhotoCount` = '23' ,`PostalCode` = '77382' ,`RoomCount` = '3' ,`ListPrice` = '393000.00' ,`Status` = 'Active' ,`StreetName` = 'Hollylaurel' ,`StreetNumber` = '180' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1824' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 180 S. Hollylaurel. Gorgeous curb appeal. Well maintained 2 story home that features the primary downstairs and 2 bedrooms upstairs in addition to a loft area. Tile and wood throughout the home. Recently updated 2022 built in Microwave. Take a dip and cool down in the POOL. Recently updated pool motor replaced summer of 2021 and Polaris 360 pool cleaner updated 2022. Recent upgraded sprinkler system 2022. 2 car garage. Don\'t miss out on this gorgeous home, schedule a showing today.' ,`Acres` = '0.1629' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WDLNDS VIL ALDEN BR 16, BLOCK 1, LOT 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '7094' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Wdlnds Village Alden Br 16' ,`TaxAmount` = '6845' ,`TaxRate` = '2.1811' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091714' WHERE `Matrix_Unique_ID` = '213806716' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T10:48:17.973' ,`MLSNumber` = '77641940' ,`ListAgentFullName` = 'Kristy Pennetta' ,`ListOfficeName` = 'Real Property Management Prefe' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.007491' ,`Longitude` = '-95.188239' ,`PhotoCount` = '32' ,`PostalCode` = '77346' ,`RoomCount` = '9' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Big Timber' ,`StreetNumber` = '19703' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2674' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'JUST REDUCED!!!!\r\nBright and Spacious 4 Bedroom 3 Baths and a half in the Oaks Of Atascocita. Located off Beltway 8 and 59 with easy access to George Bush Airport. Zoned to Humble ISD. Enjoy an open floor plan, high ceilings and a cozy fireplace. Kitchen comes with plenty of cabinets and counter space. Make your appointment today!!' ,`Acres` = '0.2146' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 93 BLK 14 OAKS OF ATASCOCITA SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oaks Atascocita Sec 03' ,`TaxAmount` = '5193' ,`TaxRate` = '2.613' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091714' WHERE `Matrix_Unique_ID` = '214020640' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T10:47:20.367' ,`MLSNumber` = '83674719' ,`ListAgentFullName` = 'Kristy Pennetta' ,`ListOfficeName` = 'Real Property Management Prefe' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.988778' ,`Longitude` = '-95.170972' ,`PhotoCount` = '28' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Fuchsia' ,`StreetNumber` = '7014' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2471' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'JUST REDUCED!!\r\nCharming Two story 4 Bedrooms 2 Baths Located in the Atascocita Subdivision! Spacious living room with a cozy fireplace. Kitchen comes with plenty of storage and countertops. Spacious master bedroom with a large Walk-in closet and dual sinks. Easy access to 59 and IAH Airport. Make your appointment today!!' ,`Acres` = '0.1515' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 22 ATASCOCITA SOUTH SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '430' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'TIMBERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita South Sec 03' ,`TaxAmount` = '5114' ,`TaxRate` = '2.3974' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091714' WHERE `Matrix_Unique_ID` = '214022690' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T09:13:49.050' ,`MLSNumber` = '26261908' ,`ListAgentFullName` = 'Rosalinda Swartz' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.852085' ,`Longitude` = '-95.679320' ,`PhotoCount` = '30' ,`PostalCode` = '77084' ,`RoomCount` = '9' ,`ListPrice` = '264900.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Bend' ,`StreetNumber` = '18123' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1708' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well-maintained single-story home w/ a perfectly sized backyard & upgrades throughout located in the Windsong community offering wonderful amenities, & quick access to Cy-Fairbank schools, shopping & dining. Outside, the home features a manicured lawn & landscaping, & a two-car garage. Inside, find an open floorplan design w/ high ceilings, updated finishes, LED lighting, engineered wood flooring, & an abundance of windows throughout. The vast living space is perfect for entertaining & includes a brick fireplace and opens to the dining area w/ decorative lighting & backyard access. The updated kitchen boasts SS appliances, granite counters, ample cabinet storage, pantry, & a breakfast nook. The spacious primary bedroom offers a window seat, & an en-suite bath w/ dual vanities, jetted tub/shower, & a walk-in closet. 2 additional well-sized bedrooms that share a full bath completes this home. Before you leave, check out the cozy covered back patio, & fully fenced landscaped yard.' ,`Acres` = '0.2032' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 22 WINDSONG SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '430' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Windsong' ,`TaxAmount` = '4787' ,`TaxRate` = '2.5618' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091715' WHERE `Matrix_Unique_ID` = '214781867' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-16T10:05:34.297' ,`MLSNumber` = '46373643' ,`ListAgentFullName` = 'Steven Montgomery' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.925150' ,`Longitude` = '-95.278566' ,`PhotoCount` = '32' ,`PostalCode` = '77396' ,`RoomCount` = '10' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Lynnbrook Falls' ,`StreetNumber` = '7419' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2588' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You are going to love the Texas charm of this beautiful stucco and stone home in the much desired neighborhood of Fall Creek. This open concept home has been meticulously cared for and features rich wood flooring in the bedrooms, a warm and cozy gas log FIREPLACE in the living room, formal dining, and a large utility room...The family chef will love the amazing bright lighting in the kitchen! Upstairs a HUGE GAMEROOM and a separate MEDIA ROOM with everything you need for movie night! Lush landscaping outside and RECENT PAINT with RECENT CARPET indoors make this home turn-key/MOVE IN READY! Enjoy the great outdoors at Fall Creek with dog parks, a fitness center and a sports complex containing pools, water park, tennis courts, parks, sand volleyball courts, little league sized baseball fields, and soccer fields or enjoy a walk on the trails around the park area and nature preserve! With easy access to IAH airport and major highways this home has it all!' ,`Acres` = '0.1377' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fall Creek Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 1 FALL CREEK SEC 27' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FALL CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Fall Crk' ,`TaxAmount` = '8033' ,`TaxRate` = '2.9973' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091715' WHERE `Matrix_Unique_ID` = '214802876' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215076251','1675091715','215076251','2022-12-16T10:43:41.800','61931269','Brenda Klushin','Realty Pros of Texas','','','29.735815','-95.761123','39','77450','11','650000.00','Active','Sail Harbour','22527','Court','Katy','4','0','5','3065','Single-Family','Nestled at the end of a quiet cul-de-sac, this recently updated 3065 sq. ft, 5-bedroom, 4-bathroom, 4+ car garage home is located in the heart of Cinco Ranch! Inside this warm and welcoming one owner home, you’ll find an open-concept floor plan with high ceilings and wood flooring in the main living areas. There’s so much more… This multi-generational 1-story home includes a separate guest suite with full kitchen, as well as a pool house/ pool bath that is currently used as a gameroom w/ kitchenette. Both spaces are HC accessible and also have W/D connections. Outside, you’ll find an oversized backyard with a pool featuring zero entry and full length ramp ledge. The spacious 4+ car garage is 1125 sqft and has built in shelving. Located steps away from South Lake and the Beach Club! ***Please note: Landscaping is in progress and there is NO SIGN in the front yard!','0.3018','36','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Owner/Agent,Sellers Disclosure','','Gaslog Fireplace','1','Katy - Southeast','Central Gas','1','CINCO RANCH SOUTH LAKE VILLAGE SEC 6, BLOCK 1, LOT 14','Cul-De-Sac','13145','Appraisal District','','1115','0','','4','Electric Oven','1','Gunite,In Ground','','Gas Cooktop','','Composition','30 - Katy','WILLIAMS ELEMENTARY SCHOOL (KATY)','CINCO RANCH HIGH SCHOOL','BECK JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Appraisal District','1','Traditional','Cinco Ranch South Lake Village Sec 6','11057','2.4395','Water District','2002','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215480810','1675091715','215480810','2022-12-16T09:37:14.913','41652409','Kait Chavez','Walzel Properties','','','30.029009','-94.948503','42','77535','4','465000.00','Active','County Road 6053','729','','Dayton','3','0','4','2370','Single-Family','The front of the home does not have a concrete sidewalk, the home also has other details to be completed before the end of December 2022. New Construction home 2022! All appliances are electric, except for the stove. The stove is the only thing that has gas connection to the backyard LP Tank. Backyard patio is covered! 3 full baths, 1 restroom is a jack-jill connecting bath which connect to bedroom 2 & 3, each side has a sink of their own.\r\n1.77 acres, NO RESTRICTIONS! NEAR HIGHWAY 99! Aerobic (Spray) Septic!\r\nAll appointments need to be approved since sellers are occupying the residence.\r\nNEVER FLOODED!','1.77','52','Owner','','Electric Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','','','','Dayton','Central Electric','0','FAIRFIELD-4, BLOCK 6, LOT 18, ACRES 1.77','Cleared','77101','Appraisal District','','','1','To Be Built/Under Construction','2','','0','','','','','Composition','74 - Dayton','RICHTER ELEMENTARY SCHOOL','DAYTON HIGH SCHOOL','WOODROW WILSON JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox','Builder','1','Other Style,Spanish,Traditional','Fairfield','1522','1.693','Aerobic,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215597889','1675091715','215597889','2022-12-16T09:58:57.570','70528416','Cheryl Knight','Full Stringer Realty','','','28.766110','-95.639769','30','77414','3','280000.00','Active','County Road 202','699','','Sargent','2','0','3','768','Single-Family','GREAT LOCATION JUST MINUTES FROM ICW!!! 3/2 ON 2 LOTS. COMES WITH CARPORT AND STORAGE BUILDING W/LOFT. THERE IS AN RV PLUG AT STORAGE BUILDING. MUD WATER AND SEWER. HOUSE IN ON PILINGS WITH CONCRETE SLAB. DOWNSTAIRS BEDROOM WITH BATH,UTILITY ROOM AND HOT TUB. 2/1 UPSTAIRS WITH OPEN LIVING/DINING/KITCHEN. COVERED PORCH AND DECK ON CANAL SIDE. COMES MOSTLY FURNSHED. THERE IS ALSO A BOAT STORAGE COVER AT CANAL NEEDING WORK. CIRCULAR DRIVE FOR EASY ACCESS.','0.2755','54','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','','','0','','Other Heating','1','DOWNEY CANEY CREEK SEC 12, LOT 70 & 71','Subdivision Lot,Water View,Waterfront','12001','Appraisal District','','30','0','','0','Double Oven','0','','','','','Composition','134 - Van Vleck','VAN VLECK ELEMENTARY SCHOOL','VAN VLECK HIGH SCHOOL','O H HERMAN MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card','Appraisal District','2','Other Style','Downey Caney Creek','4179','2.325','Public Sewer,Water District','1975','Appraisal District'); --> New record created successfully