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-25T20:25:45.217' ,`MLSNumber` = '33712850' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '33.916177' ,`Longitude` = '-98.474621' ,`PhotoCount` = '12' ,`PostalCode` = '76301' ,`RoomCount` = '3' ,`ListPrice` = '29279.00' ,`Status` = 'Active' ,`StreetName` = 'Tulsa' ,`StreetNumber` = '814' ,`StreetSuffix` = 'Street' ,`City` = 'Wichita' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '824' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute as a button! If you\'re a first time buyer, don\'t look past this one without seeing it in person. Located near the medical district, restaurants, and shopping on the East side of Wichita Falls. As is! This is a great fixer upper opportunity! Easy seller terms!' ,`Acres` = '0.1263' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 8 BLK 5 HOMEWOOD HEIGHT' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1036 - Wichita Falls' ,`SchoolElementary` = 'WASHINGTON-JACKSON ELEMENTARY MAGNET' ,`SchoolHigh` = 'HIRSCHI HIGH SCHOOL' ,`SchoolMiddle` = 'KIRBY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Homewood Heights' ,`TaxAmount` = '164' ,`TaxRate` = '2.5537' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1925' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675257637' WHERE `Matrix_Unique_ID` = '192039477' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-25T20:33:28.523' ,`MLSNumber` = '73861855' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.528015' ,`Longitude` = '-95.551606' ,`PhotoCount` = '18' ,`PostalCode` = '77459' ,`RoomCount` = '4' ,`ListPrice` = '301000.00' ,`Status` = 'Active' ,`StreetName` = 'Sonoma' ,`StreetNumber` = '5723' ,`StreetSuffix` = 'Ridge' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2196' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Home was just updated in November, 2022 including: Kitchen renovated with granite counters, stainless steel appliances and freshly painted cabinets.Your dream home is waiting just for you in Missouri City! Enjoy preparing meals in this impressive kitchen equipped with ample cabinets, a breakfast bar and generous counter space. Discover a bright interior with neutral floors and plush carpet in all the right places. The primary bedroom features plush carpet, a spacious closet, and a private bathroom. Relax with your favorite drink in the fenced in backyard with a lush grass. Don\'t miss this incredible opportunity.\r\n\r\nThis home has been virtually staged to illustrate its potential.' ,`Acres` = '0.0861' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA VILLAGE OF ANDERSON SPRINGS SEC 5-A, BLOCK 9, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SCHIFF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Village Of Anderson Spgs Sec 5-A' ,`TaxAmount` = '5369' ,`TaxRate` = '2.8129' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675257637' WHERE `Matrix_Unique_ID` = '204149343' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-25T20:29:55.603' ,`MLSNumber` = '94243199' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.139296' ,`Longitude` = '-95.652350' ,`PhotoCount` = '29' ,`PostalCode` = '77362' ,`RoomCount` = '4' ,`ListPrice` = '307000.00' ,`Status` = 'Active' ,`StreetName` = 'Maureens' ,`StreetNumber` = '11922' ,`StreetSuffix` = 'Way' ,`City` = 'Pinehurst' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1762' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous neighborhood! Terrific 4 bedroom and 2 bath home with a 2 car garage. You’ll enjoy preparing meals in the gorgeous kitchen with sleek counters, included appliances, and beautiful spacious cabinetry. Picture evenings by the fireplace and mornings having coffee out on the patio in the backyard. Relax in your primary suite, complete with a walk-in closet, and an en-suite bathroom. Relax with your favorite drink in the fenced in backyard with a patio, an in-ground pool, and great potential for adding personal touches. Don\'t miss this incredible opportunity.\r\nThis home has been virtually staged to illustrate its potential' ,`Acres` = '0.1452' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'DECKER OAKS ESTATES 03, BLOCK 2, LOT 9, ACRES 0.1452' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Decker Oaks Estates 03' ,`TaxAmount` = '4106' ,`TaxRate` = '1.9215' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675257637' WHERE `Matrix_Unique_ID` = '207137194' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-25T20:30:23.280' ,`MLSNumber` = '52226382' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518357' ,`Longitude` = '-95.015097' ,`PhotoCount` = '17' ,`PostalCode` = '77573' ,`RoomCount` = '3' ,`ListPrice` = '429000.00' ,`Status` = 'Active' ,`StreetName` = 'Nogalas' ,`StreetNumber` = '2118' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2765' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this charming 3 bedroom, 2.5 bathroom home now on the market! Enjoy cooking in this stylish kitchen with stainless appliances and a center island, great for food preparation. Flow into the living room featuring a cozy fireplace, perfect for entertaining. The main bedroom boasts a private ensuite. Other bedrooms offer plenty of natural light and ceiling fans. Relax with your favorite drink in the fenced in backyard with lush grass and great opportunity to add personal touches. Don\'t wait! Make this beautiful home yours today. This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.2296' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MAR BELLA SEC 11-B (2015) ABST 32, BLOCK 2, LOT 2, ACRES 0.2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10003' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2165' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'SANDRA MOSSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mar Bella Sec 11-B' ,`TaxAmount` = '11049' ,`TaxRate` = '2.7997' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675257638' WHERE `Matrix_Unique_ID` = '207918849' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-25T20:14:03.720' ,`MLSNumber` = '16752829' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.213594' ,`Longitude` = '-95.433420' ,`PhotoCount` = '31' ,`PostalCode` = '77385' ,`RoomCount` = '3' ,`ListPrice` = '224000.00' ,`Status` = 'Active' ,`StreetName` = 'Gleneagle' ,`StreetNumber` = '16907' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1635' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your dream home is waiting just for you in Conroe! The kitchen boasts generous counter space, ample cabinets and a breakfast nook, making cooking and entertaining a delight. Entertaining is a breeze with this great floor plan complete with a cozy fireplace. The primary bedroom features a spacious closet, and a private bathroom with a single sink. Relax with your favorite drink in the fenced in backyard with a patio and lush grass. Don\'t wait! Make this beautiful home yours today. This home has been virtually staged to illustrate its potential' ,`Acres` = '0.1937' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GLENEAGLES 01, LOT 218' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8438' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '215' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'OAK RIDGE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gleneagles 01' ,`TaxAmount` = '3587' ,`TaxRate` = '2.6088' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675257638' WHERE `Matrix_Unique_ID` = '208048599' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-25T20:29:30.660' ,`MLSNumber` = '56268986' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.973198' ,`Longitude` = '-95.536555' ,`PhotoCount` = '32' ,`PostalCode` = '77069' ,`RoomCount` = '4' ,`ListPrice` = '372000.00' ,`Status` = 'Active' ,`StreetName` = 'Jessica' ,`StreetNumber` = '13415' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3244' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 bedroom, 3 full and 1 half bathroom stunner in Houston! The kitchen is equipped with stainless appliances, white cabinets, tile backsplash, a breakfast bar and a center island. Discover a bright interior with neutral tile floors and plush carpet in all the right places. Relax in your primary suite, complete with a walk-in closet, and an en-suite bathroom with double sinks. Step outside to your sparkling pool, host the next gathering here! Hurry, this won’t last long!\r\nThis home has been virtually staged to illustrate its potential.' ,`Acres` = '0.202' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 50 BLK 3 CHAMPIONS PARK R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '546' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Champions Park R/P' ,`TaxAmount` = '8279' ,`TaxRate` = '2.5156' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675257638' WHERE `Matrix_Unique_ID` = '208098030' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-25T20:35:11.463' ,`MLSNumber` = '96854633' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.693740' ,`Longitude` = '-95.799440' ,`PhotoCount` = '34' ,`PostalCode` = '77406' ,`RoomCount` = '5' ,`ListPrice` = '414000.00' ,`Status` = 'Active' ,`StreetName` = 'Giovanni' ,`StreetNumber` = '11750' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2779' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 5-bedroom, 3.5-bathroom Richmond home is a must-see. The spacious kitchen offers sleek dark cabinetry, granite countertops, and stainless steel appliances. In the living room, enjoy plush carpet and a cozy fireplace. The neutral color palette continues throughout the home and into the primary bedroom, where you’ll find vaulted ceilings and a luxurious en-suite bathroom. Outside, the fenced-in backyard is perfect for entertaining or relaxing. Hurry, this won’t last long! This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.1245' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKES OF BELLA TERRA SEC 21, BLOCK 1, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5423' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUBENAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes Of Bella Terra Sec 21' ,`TaxAmount` = '9627' ,`TaxRate` = '3.0848' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675257638' WHERE `Matrix_Unique_ID` = '208460970' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-25T20:27:26.630' ,`MLSNumber` = '59444088' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.354014' ,`Longitude` = '-95.538926' ,`PhotoCount` = '16' ,`PostalCode` = '77304' ,`RoomCount` = '3' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'La Salle' ,`StreetNumber` = '2929' ,`StreetSuffix` = 'Avenue' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this newly renovated, charming 3 bedroom, 2 bathroom stunning home within close proximity to beautiful Lake Conroe! The kitchen boasts generous newly installed granite counter tops with ample counter space and a breakfast bar; making cooking and entertaining a delight. Entertaining is a breeze with this great open floor plan. The primary bedroom features plush carpet, a spacious closet, and a private bathroom with granite counters as well. Relax with your favorite drink in huge backyard complete with a large covered patio, hot tub, lush grass, and great opportunities for personal touches. Don\'t wait! Make this beautiful home yours today.' ,`Acres` = '0.2945' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LA SALLE CROSSING 01 (WESTLAKE), BLOCK 5, LOT 36' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12830' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'La Salle Crossing 01 Westlake' ,`TaxAmount` = '5134' ,`TaxRate` = '2.8638' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675257638' WHERE `Matrix_Unique_ID` = '208692084' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-25T20:32:15.673' ,`MLSNumber` = '52860373' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.874854' ,`Longitude` = '-95.633700' ,`PhotoCount` = '28' ,`PostalCode` = '77084' ,`RoomCount` = '4' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Green Stone' ,`StreetNumber` = '6710' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2497' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this charming home now on the market! Home was just updated in November, 2022 including: Kitchen renovated with granite counters, updated cabinets. This home has fresh interior paint and partial flooring replacement. Discover a bright and open interior with plenty of natural light and a neutral color palate, complimented by a fireplace. This kitchen has everything you need! A center island, walk in pantry, and stylish backsplash accent will have you looking forward to cooking. Relax in your primary suite with a walk in closet included. Extra bedrooms add nice flex space for your everyday needs. The primary bathroom is fully equipped with a separate tub and shower, double sinks, and plenty of under sink storage. Take it easy in the fenced in back yard. The sitting area makes it great for BBQs! Don\'t wait! Make this beautiful home yours today.' ,`Acres` = '0.1512' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 2 HEARTHSTONE SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6585' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hearthstone Sec 09' ,`TaxAmount` = '5772' ,`TaxRate` = '2.501' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675257639' WHERE `Matrix_Unique_ID` = '208865547' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-25T20:30:57.177' ,`MLSNumber` = '32947286' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.494138' ,`Longitude` = '-95.713578' ,`PhotoCount` = '15' ,`PostalCode` = '77469' ,`RoomCount` = '3' ,`ListPrice` = '276000.00' ,`Status` = 'Active' ,`StreetName` = 'Glenridge' ,`StreetNumber` = '7111' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1638' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic home in sought after location! Home was recently updated as of December 2022 including: Freshly painted kitchen cabinets. This home has fresh interior paint and partial flooring replacement. Windows create a light filled interior with well placed neutral accents. The kitchen is ready for cooking with ample counter space and cabinets for storage. You won’t want to leave the serene primary suite, the perfect space to relax. Additional bedrooms provide nice living or office space. In the primary bathroom you\'ll find a separate tub and shower, plus plenty of under sink storage. Take it easy in the fenced in back yard. The sitting area makes it great for BBQs! Like what you hear? Come see it for yourself!' ,`Acres` = '0.1713' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUNRISE MEADOW SEC 8, BLOCK 3, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7461' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunrise Meadow Sec 8' ,`TaxAmount` = '5274' ,`TaxRate` = '2.8148' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675257639' WHERE `Matrix_Unique_ID` = '209463756' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-25T20:29:00.680' ,`MLSNumber` = '37283115' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.394960' ,`Longitude` = '-95.697678' ,`PhotoCount` = '31' ,`PostalCode` = '77356' ,`RoomCount` = '4' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Liberty' ,`StreetNumber` = '14640' ,`StreetSuffix` = 'Street' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2333' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your dream home is waiting just for you in Houston! You’ll enjoy preparing meals in the gorgeous kitchen with sleek counters, tiled backsplash, stainless appliances, and beautiful spacious cabinetry. Lighting, ceiling fans, and fixtures flow throughout. A luxurious primary suite, complete with a sizable closet, and an en-suite bathroom with double sinks. Relax with your favorite drink in the fenced in backyard with lush grass. Don\'t wait! Make this beautiful home yours today.This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.57' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0008 - CORNER JOHN, TRACT 16, ACRES 0.57' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '24829' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'John Corner Surv Abs 8' ,`TaxAmount` = '5905' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675257639' WHERE `Matrix_Unique_ID` = '209715142' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-25T20:34:10.407' ,`MLSNumber` = '72106673' ,`ListAgentFullName` = 'Maria Williams' ,`ListOfficeName` = 'Texcom Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194179' ,`Longitude` = '-95.134531' ,`PhotoCount` = '17' ,`PostalCode` = '77372' ,`RoomCount` = '8' ,`ListPrice` = '574000.00' ,`Status` = 'Active' ,`StreetName` = 'Saba' ,`StreetNumber` = '17114' ,`StreetSuffix` = '' ,`City` = 'Splendora' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2697' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Another beautiful 4 bedrooms/3 bath/3 car garage home by Garan Builders. The truly exceptional open-design floor plan features a warm, welcoming interior and comes equipped with a home office, good-sized living room and well-proportioned rooms. Make memories in this custom-built kitchen, which includes granite countertops and a tile backsplash. Sized for spacious comfort, the king-sized main bedroom provides a spacious bathrooms and his-and-hers walk-in closets. Adding to the home\'s charm are tile floors throughout the main living spaces. The expansive backyard features a covered patio. A wonderful space for fun. Perfectly positioned in a quiet section of Montgomery County. Live the outdoor lifestyle you\'ve dreamed of! A rare opportunity. Schedule your showing before it’s gone.' ,`Acres` = '1.1' ,`Area` = '40' ,`BuilderName` = 'Garan Builders, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'S827600 - RIO VISTA, BLOCK 2, LOT 34, ACRES 1.1' ,`LotDesciption` = 'Wooded' ,`LotSize` = '47916' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Rio Vista' ,`TaxAmount` = '1008' ,`TaxRate` = '2.2341' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675257639' WHERE `Matrix_Unique_ID` = '209913668' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-25T20:33:07.340' ,`MLSNumber` = '85686002' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.032856' ,`Longitude` = '-95.493633' ,`PhotoCount` = '35' ,`PostalCode` = '77379' ,`RoomCount` = '4' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Alamosa' ,`StreetNumber` = '5230' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2926' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 bedroom 2.5 bathroom stunner in Spring! Home was just updated in December, 2022 including: Kitchen renovated with new stainless steel appliances, freshly painted cabinets. The kitchen is equipped with updated countertops, tile backsplash, and ample cabinets. Discover a bright interior with neutral tile floors and plush carpet in all the right places. Primary bathroom features a tub and shower, dual sinks and a walk-in closet. Entertain on the covered back patio, perfect for barbecues. A must see!' ,`Acres` = '0.2296' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 1 TERRANOVA SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9997' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '603' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BENFER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Terranova Sec 01' ,`TaxAmount` = '5179' ,`TaxRate` = '2.3266' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675257640' WHERE `Matrix_Unique_ID` = '209993172' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-25T20:46:01.093' ,`MLSNumber` = '19226843' ,`ListAgentFullName` = 'Jill Warren' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.073436' ,`Longitude` = '-93.896917' ,`PhotoCount` = '50' ,`PostalCode` = '77630' ,`RoomCount` = '5' ,`ListPrice` = '585000.00' ,`Status` = 'Active' ,`StreetName` = 'Town Lake' ,`StreetNumber` = '3615' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Orange' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2882' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A picture is often said to be worth a thousand words, but that is not enough to describe the Huerta Home’s display of architectural brilliance. Michaelangelo had the Sistine Chapel, Da Vinci the Mona Lisa, and two years of hard work has brought David Huerta’s own masterful vision. Enter this gorgeous, custom, masterpiece and relax in the soaking tub knowing that you are in a once-in-a-lifetime space. A modern, sleek and graceful home complete with enough space for your wildest dreams. Beautifully lit interiors, and a lovely outdoor view let you live royally. Complete with a primary oasis, ensuite, and spacious closets, this luxurious space is beyond imagination. Bask in the wonderful view near any of the well-placed windows, or take some time out in the fresh air near the stunning man-made lake. Happiness is always near with this palatial craftsmanship, so fix your eyes on a timeless design that is sure to bring you one step closer to a life you deserve.' ,`Acres` = '0.67' ,`Area` = '50' ,`BuilderName` = 'HUERTA HOMES INC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TWIN LAKE ESTATES PHASE 1 LOT 38, ACRES 0.67' ,`LotDesciption` = 'Corner' ,`LotSize` = '29185' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '277 - Orangefield' ,`SchoolElementary` = 'ORANGEFIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ORANGEFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'ORANGEFIELD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Twin Lake Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675257640' WHERE `Matrix_Unique_ID` = '210050792' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-25T20:33:01.333' ,`MLSNumber` = '18394812' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.258755' ,`Longitude` = '-95.518802' ,`PhotoCount` = '18' ,`PostalCode` = '77384' ,`RoomCount` = '3' ,`ListPrice` = '319000.00' ,`Status` = 'Active' ,`StreetName` = 'Glacier Bay' ,`StreetNumber` = '14215' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this charming 3 bedroom and 2 bathroom home now on the market! Home was just updated in December, 2022 including: Kitchen renovated with granite counters, home interior repainted throughout. The kitchen is equipped with ample cabinets, breakfast bar, center island, stainless steel appliances and generous counter space. Step inside this beautiful interior with neutral floors, plenty of natural light and neutral palette. The primary bedroom features a spacious closet and a private bathroom with dual sinks. Relax with your favorite drink in the fenced in backyard. A must see!' ,`Acres` = '0.1377' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S516418 - FOSTERS RIDGE 18, BLOCK 1, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fosters Ridge 18' ,`TaxAmount` = '6555' ,`TaxRate` = '3.1488' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675257640' WHERE `Matrix_Unique_ID` = '210193098' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-25T20:14:37.587' ,`MLSNumber` = '39650176' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.076386' ,`Longitude` = '-95.200034' ,`PhotoCount` = '35' ,`PostalCode` = '77339' ,`RoomCount` = '3' ,`ListPrice` = '247000.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Glen' ,`StreetNumber` = '3014' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2165' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous neighbourhood! Terrific 3 bedroom and 2 bathroom home with a double car garage. The kitchen boasts updated counters, white cabinets and a breakfast bar, making cooking and entertaining a delight. Entertaining is a breeze with this great floor plan complete with a cozy fireplace. A luxurious primary suite, complete with a spacious closet and an en-suite bathroom with double sinks. Head to the backyard for the perfect private area to enjoy the outdoors. A must see!}\r\n\r\nThis home has been virtually staged to illustrate its potential' ,`Acres` = '0.2459' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 16 ELM GROVE VILLAGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '96' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ELM GROVE ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elm Grove Village Sec 02' ,`TaxAmount` = '4505' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675257640' WHERE `Matrix_Unique_ID` = '210198571' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-25T20:25:06.577' ,`MLSNumber` = '20305730' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName`