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-09-22T05:24:38.260' ,`MLSNumber` = '93075024' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.181049' ,`Longitude` = '-95.554898' ,`PhotoCount` = '34' ,`PostalCode` = '77382' ,`RoomCount` = '4' ,`ListPrice` = '561000.00' ,`Status` = 'Active' ,`StreetName` = 'Culverdale' ,`StreetNumber` = '14' ,`StreetSuffix` = 'Place' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3018' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this charming 4-bedroom home now on the market! The kitchen is equipped with updated countertops, tile backsplash, and ample cabinets. Entertaining is a breeze with this great floor plan complete with a cozy fireplace. Primary bathroom features dual sinks and a walk-in closet. Step outside to your sparkling pool, host the next gathering here! Don\'t miss this incredible opportunity.\r\n\r\nThis home has been virtually staged to illustrate its potential.' ,`Acres` = '0.1864' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WDLNDS VIL INDIAN SPRG 23, BLOCK 1, LOT 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8118' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'TOUGH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Indian Sprg 23' ,`TaxAmount` = '9847' ,`TaxRate` = '2.1319' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663849896' WHERE `Matrix_Unique_ID` = '205588252' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-22T05:02:04.240' ,`MLSNumber` = '76354224' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.724613' ,`Longitude` = '-95.661023' ,`PhotoCount` = '22' ,`PostalCode` = '77082' ,`RoomCount` = '3' ,`ListPrice` = '247000.00' ,`Status` = 'Active' ,`StreetName` = 'Honey Creek' ,`StreetNumber` = '3207' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1562' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your dream home is waiting just for you in Houston! Enjoy cooking in this stylish kitchen with white cabinets, tiled-backsplash and stainless steel appliances, great for food preparation. Entertaining is a breeze with this great floor plan complete with a cozy fireplace. The primary bedroom features a walk-in closet and a private bathroom with dual sinks. Relax with your favourite drink in the backyard with a patio and lush grass. Don\'t wait! Make this beautiful home yours today.\r\n\r\nThis home has been virtually staged to illustrate its potential' ,`Acres` = '0.161' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 6 FORESTVIEW SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7015' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '159' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'REES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forestview Sec 01' ,`TaxAmount` = '4030' ,`TaxRate` = '2.4927' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663849896' WHERE `Matrix_Unique_ID` = '206518756' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-22T05:01:43.087' ,`MLSNumber` = '8476902' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.856656' ,`Longitude` = '-95.655109' ,`PhotoCount` = '22' ,`PostalCode` = '77084' ,`RoomCount` = '3' ,`ListPrice` = '253000.00' ,`Status` = 'Active' ,`StreetName` = 'Cairnleigh' ,`StreetNumber` = '5415' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1828' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your dream home is waiting just for you in Channelview! Enjoy preparing meals in this impressive kitchen equipped with ample cabinets and generous counter space. Entertaining is a breeze with this great floor plan complete with a cozy fireplace. Primary bathroom features a separate tub and dual sinks. Lush green landscape surrounds this beautiful house. Don\'t wait! Make this beautiful home yours today. \r\nThis home has been virtually staged to illustrate its potential.' ,`Acres` = '0.1446' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 24 GLENCAIRN SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LIEDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glencairn Sec 06' ,`TaxAmount` = '4190' ,`TaxRate` = '2.375' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663849896' WHERE `Matrix_Unique_ID` = '208149399' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-22T05:01:22.120' ,`MLSNumber` = '94038870' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.027756' ,`Longitude` = '-95.615173' ,`PhotoCount` = '35' ,`PostalCode` = '77377' ,`RoomCount` = '4' ,`ListPrice` = '293000.00' ,`Status` = 'Active' ,`StreetName` = 'Eganville' ,`StreetNumber` = '18118' ,`StreetSuffix` = 'Circle' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2348' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous neighborhood! Terrific 4 bedroom and 2.5 bath home with a two car garage. The impeccable kitchen has beautiful updated counters and stainless steel appliances. \r\nFlow into the living room featuring a cozy fireplace, perfect for entertaining.\r\nA luxurious primary suite, complete with a walk-in closet, and an en-suite bathroom with double sinks.\r\nLush green landscape surrounds this beautiful house.\r\nDon\'t miss this incredible opportunity. This home has been virtually staged to illustrate its potential' ,`Acres` = '0.1515' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 50 BLK 5 WESTBOURNE SEC 2 PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'WILLOW CREEK ELEMENTARY SCHOOL (TOMBALL)' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbourne Sec 02 Prcl R/P' ,`TaxAmount` = '5667' ,`TaxRate` = '2.5764' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663849897' WHERE `Matrix_Unique_ID` = '209460940' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-22T05:01:42.387' ,`MLSNumber` = '35186465' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.545170' ,`Longitude` = '-95.182675' ,`PhotoCount` = '32' ,`PostalCode` = '77546' ,`RoomCount` = '3' ,`ListPrice` = '297000.00' ,`Status` = 'Active' ,`StreetName` = 'Heritage Falls' ,`StreetNumber` = '15706' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1547' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this charming 3 bedroom and 2 bathroom home now on the market! The kitchen is equipped with white cabinets, breakfast bar and generous counter space. Flow into the living room featuring a cozy fireplace, perfect for entertaining. The primary bedroom features plush carpet, a spacious closet and a private bathroom with dual sinks. Relax with your favorite drink in the fenced backyard with lush grass. Don\'t wait! Make this beautiful home yours today.\r\nThis home has been virtually staged to illustrate its potential' ,`Acres` = '0.1446' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 3 HERITAGE PARK SEC 8 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '378' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'WEDGEWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Park Sec 8 R/P' ,`TaxAmount` = '4516' ,`TaxRate` = '2.166' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663849897' WHERE `Matrix_Unique_ID` = '209654949' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-22T05:01:52.493' ,`MLSNumber` = '3179470' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.582537' ,`Longitude` = '-95.194258' ,`PhotoCount` = '35' ,`PostalCode` = '77089' ,`RoomCount` = '3' ,`ListPrice` = '313000.00' ,`Status` = 'Active' ,`StreetName` = 'Carmel Dale' ,`StreetNumber` = '12407' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2364' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this charming 3 bedroom, 2.5 bathroom home now on the market! You’ll enjoy preparing meals in the gorgeous kitchen with sleek counters, tiled backsplash, stainless appliances. Flow into the living room featuring a cozy fireplace, perfect for entertaining. The primary bedroom features plush carpet, a spacious closet, and a private bathroom with dual sinks. Relax with your favorite drink in the fenced in backyard with lush grass. Hurry, this won’t last long!\r\n\r\nThis home has been Virtually Staged to illustrate its potential.' ,`Acres` = '0.1205' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 4 COLLEGE PLACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'NORTH POINTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'WESTBROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'COLLEGE PLACE SEC 2' ,`TaxAmount` = '6648' ,`TaxRate` = '2.6399' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663849897' WHERE `Matrix_Unique_ID` = '209684264' --> 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','209898212','1663849897','209898212','2022-09-22T05:10:22.577','43765103','Thomas Stallings','McCallum Realty','','','29.599479','-95.537261','34','77489','10','289900.00','Active','Hickory Glen','1924','Drive','Missouri City','2','1','5','2536','Single-Family','Located in Hunters Green in Missouri City is this incredible 5-bedroom home. Resting on a spacious corner lot, the 2-story home has a lot to offer! Featuring wood-like laminate and tile flooring throughout the home you\'ll never have to worry about carpet cleaning. An abundance of natural light filters through open blinds in all rooms of the house. A comfortable living room includes a gas fireplace for cool winter evenings. It opens to a spacious galley-style kitchen that features plenty of cabinets and tons of counter space. The breakfast room is nestled between large windows that offer a view of the backyard. The 2nd floor reveals the bedrooms and bathrooms. An enviable primary suite offers room for a large bed and still has room for a sitting area. An extended covered patio in the backyard is the perfect spot to relax and enjoy the outdoors. There\'s plenty of space for outdoor seating and a grill. Don\'t wait to make your offer!','0.1384','38','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Missouri City Area','Central Gas','1','HUNTERS GREEN, BLOCK 6, LOT 70','Corner,Subdivision Lot','6027','Appraisal District','','354','0','','2','Freestanding Oven,Gas Oven','0','','','Gas Range','','Composition','19 - Fort Bend','EDGAR GLOVER JR ELEMENTARY SCHOOL','MARSHALL HIGH SCHOOL (FORT BEND)','MISSOURI CITY MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Hunters Green','5469','2.5525','Public Sewer,Public Water','1995','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-22T05:02:01.277' ,`MLSNumber` = '28556188' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.896169' ,`Longitude` = '-95.529060' ,`PhotoCount` = '30' ,`PostalCode` = '77040' ,`RoomCount` = '4' ,`ListPrice` = '337000.00' ,`Status` = 'Active' ,`StreetName` = 'Outview' ,`StreetNumber` = '8802' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2084' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous neighborhood! Terrific 4 bedroom and 3 bath home with a 2 car garage. You’ll enjoy preparing meals in the gorgeous kitchen with sleek counters, tiled backsplash, stainless appliances, and beautiful spacious cabinetry. Flow into the living room featuring a cozy fireplace, perfect for entertaining. The main bedroom boasts a private ensuite with a separate tub and shower. Other bedrooms offer hardwood floors and ceiling fans. Relax with your favorite drink in the fenced in backyard with a patio and lush grass. Don\'t miss this incredible opportunity. This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.1148' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 7 ROLLING FORK SEC 5 R/P' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'REED ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'DEAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rolling Fork Sec 05 R/P' ,`TaxAmount` = '5861' ,`TaxRate` = '2.571' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663849897' WHERE `Matrix_Unique_ID` = '210088845' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-22T05:01:32.637' ,`MLSNumber` = '51473949' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.965884' ,`Longitude` = '-95.215453' ,`PhotoCount` = '35' ,`PostalCode` = '77396' ,`RoomCount` = '4' ,`ListPrice` = '291000.00' ,`Status` = 'Active' ,`StreetName` = 'Liles' ,`StreetNumber` = '16807' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous neighborhood! Terrific 4 bedroom and 2.5 bath home with a 2 car garage. The kitchen boasts generous counter space and a breakfast bar, making cooking and entertaining a delight. Entertaining is a breeze with this great floor plan complete with a cozy fireplace. Relax in your primary suite, complete with a walk-in closet, and an en-suite bathroom with double sinks. 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.2507' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 2 ATASCOCITA FOREST SEC 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10919' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '430' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WHISPERING PINES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita Forest Sec 12' ,`TaxAmount` = '5355' ,`TaxRate` = '2.773' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663849897' WHERE `Matrix_Unique_ID` = '210634979' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-22T04:45:49.097' ,`MLSNumber` = '68313673' ,`ListAgentFullName` = 'Jasmine Brown' ,`ListOfficeName` = 'Sapphire Realty' ,`SellingAgentFullName` = 'Jasmine Brown' ,`SellingOfficeName` = 'Sapphire Realty' ,`Latitude` = '29.565501' ,`Longitude` = '-95.406379' ,`PhotoCount` = '44' ,`PostalCode` = '77584' ,`RoomCount` = '13' ,`ListPrice` = '430000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Galleon Point' ,`StreetNumber` = '2409' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3539' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful family home on a corner lot in a cul-de-sac, is situated in a beautiful neighborhood in one of the best school districts. This home features 4 bedrooms and 4 bathrooms, in addition a formal dining room and an office at the front of the house. The Master bedroom features a large master bathroom with a shower and a tub. The kitchen is open and large and features custom cabinets and beautiful granite counter tops. The living room is spacious with newly installed laminate wood floors. Upstairs you\'ll find a game room and a half bathroom. The backyard is massive and has one of the largest backyards in the neighborhood, it also has an amazing view of the lake. Schedule a showing, this home won\'t last long!' ,`Acres` = '0.2876' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF12 (PEARLAND), BLOCK 1, LOT 28' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '12528' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'BROTHERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MCNAIR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Shadow Creek Ranch Sf1-Sf2-Sf3' ,`TaxAmount` = '10910' ,`TaxRate` = '2.9209' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663849897' WHERE `Matrix_Unique_ID` = '210718525' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-22T05:01:32.213' ,`MLSNumber` = '51590437' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.691670' ,`Longitude` = '-95.755205' ,`PhotoCount` = '25' ,`PostalCode` = '77407' ,`RoomCount` = '3' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Guldan' ,`StreetNumber` = '7726' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1749' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your dream home is waiting just for you in Richmond! Enjoy preparing meals in this impressive kitchen equipped with ample cabinets and generous counter space. Lighting, ceiling fans, and fixtures flow throughout. Primary bathroom features a separate tub and shower, dual sinks and a spacious closet. Head to the backyard for the perfect private area to enjoy the outdoors. Don\'t wait! Make this beautiful home yours today.\r\n\r\nThis home has been virtually staged to illustrate its potential' ,`Acres` = '0.1458' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOST CREEK SEC 5, BLOCK 1, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '726' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ADOLPHUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lost Creek Sec 5' ,`TaxAmount` = '5684' ,`TaxRate` = '2.7615' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663849898' WHERE `Matrix_Unique_ID` = '210750595' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-22T05:02:02.557' ,`MLSNumber` = '93587221' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.770670' ,`Longitude` = '-95.742818' ,`PhotoCount` = '32' ,`PostalCode` = '77450' ,`RoomCount` = '4' ,`ListPrice` = '306000.00' ,`Status` = 'Active' ,`StreetName` = 'Park Downe' ,`StreetNumber` = '21403' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2379' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic 4 bedroom home in sought after Katy location. Enjoy preparing meals in this impressive kitchen equipped with ample cabinets and generous counter space. Entertaining is a breeze with this great floor plan complete with a cozy fireplace. The primary bedroom features plush carpet, a spacious closet, and a private bathroom. Relax with your favorite drink in the fenced in backyard. Don\'t miss this incredible opportunity.\r\n\r\nThis home has been virtually staged to illustrate its potential.' ,`Acres` = '0.1777' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 58 BLK 8 MEMORIAL PARKWAY SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7740' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MEMORIAL PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MEMORIAL PARKWAY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Pkwy Sec 02' ,`TaxAmount` = '4711' ,`TaxRate` = '2.3283' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663849898' WHERE `Matrix_Unique_ID` = '210751951' --> 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','211737180','1663849898','211737180','2022-09-22T05:49:12.943','13573687','Thomas Stallings','McCallum Realty','','','29.988246','-95.596423','36','77070','12','719900.00','Active','Quail Creek','11762','Drive','Houston','4','2','4','5827','Single-Family','Located on a vast corner lot, this stunning Colonial-style home is sure to impress! Enjoy every aspect from the manicured outdoors to the high ceilings, plantation shutters, and natural light accenting the interior. A grand foyer reveals a sweeping staircase and a view of the formal living room featuring 1 of 4 fireplaces in the home. It opens to a quiet veranda overlooking an outdoor sanctuary. A formal dining room connects to an island kitchen that offers plenty of cabinets and gorgeous countertops. It overlooks the living room and wet bar. Knotty pine is the backdrop for the private 1st-floor study. A luxurious primary suite features a large sitting area with a fireplace and private patio access. The primary bath boasts a jetted tub, dual vanities, & a separate shower. The 2nd floor is home to a game room and secondary bedrooms & baths. A tranquil pool & spa, an outdoor kitchen, and picturesque landscaping make up the backyard. All of this plus a 3-car garage means THIS is the one!','0.285','10','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Reports Available,Sellers Disclosure','1','Gaslog Fireplace','4','Cypress North','Central Gas,Zoned','1','LT 7 BLK 4 LAKEWOOD FOREST SEC 12','Corner,Subdivision Lot','12413','Appraisal District','','655','0','','3','Double Oven','1','Gunite,Heated,In Ground','','Electric Cooktop','','Composition','13 - Cypress-Fairbanks','MOORE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS CREEK HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Lakewood Forest Sec 12','12892','2.3988','Public Sewer,Water District','1988','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-22T05:01:53.600' ,`MLSNumber` = '45877782' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.943760' ,`Longitude` = '-95.609392' ,`PhotoCount` = '31' ,`PostalCode` = '77065' ,`RoomCount` = '3' ,`ListPrice` = '286000.00' ,`Status` = 'Active' ,`StreetName` = 'Bexhill' ,`StreetNumber` = '12503' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Houston one-story home offers granite countertops, and a two-car garage. This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.2259' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 22 BARWOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9840' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ADAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Barwood Sec 01' ,`TaxAmount` = '4283' ,`TaxRate` = '2.381' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663849898' WHERE `Matrix_Unique_ID` = '211753833' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-22T05:40:25.793' ,`MLSNumber` = '94952367' ,`ListAgentFullName` = 'Corina Robertson' ,`ListOfficeName` = 'Corina Robertson, Broker' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.160181' ,`Longitude` = '-95.447094' ,`PhotoCount` = '32' ,`PostalCode` = '77385' ,`RoomCount` = '9' ,`ListPrice` = '359900.00' ,`Status` = 'Active' ,`StreetName` = 'KANE' ,`StreetNumber` = '27125' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2207' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BONUS! NO HOA, VILLAGE POOL MAINTAINED BY CITY, EASY ON/OFF I45. BEAUTIFUL NEIGHBORHOOD.\r\nMINUTES FROM WOODLANDS MALL AND OTHER SHOPPING. VERY OPEN AND LIGHT FLOOR PLAN. LUSH LANDSCAPING WITH A SPRINKLER SYSTEM. SCREENED BREEZEWAY TO GARAGE.. DOUBLE GATE BY GARAGE COULD STORE YOUR BOAT. ALSO, HALLWAYS ARE WIDE ENOUGH FOR A WHEELCHAIR.\r\nROOF REPLACED 2016. SEE LIST IN HOUSE FOR IMPROVEMENTS IN LAST 17 YEARS. VERY LOW TAX RATE (2.32)\r\nFULLY FENCED. LOTS OF UPDATES. BEAUTIFUL HOME. PLANTATION SHUTTERS. CORIAN COUNTERS IN KITCHEN. RECENT FLOORING THROUGHOUT. BATHS REMODELED. WINDOWS REPLACED.' ,`Acres` = '0.261708' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'OAK RIDGE NORTH 07, BLOCK 14, LOT 28' ,`LotDesciption` = 'Corner,Wooded' ,`LotSize` = '11400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`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,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'OAK RIDGE NORTH' ,`TaxAmount` = '' ,`TaxRate` = '2.321' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663849898' WHERE `Matrix_Unique_ID` = '212006310' --> 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','212174316','1663849898','212174316','2022-09-22T05:17:13.320','19073315','Thomas Stallings','McCallum Realty','','','29.531016','-95.469378','34','77545','8','264900.00','Active','Magnolia Dale','1022','Drive','Fresno','2','0','4','1811','Single-Family','Built in 2003, this charming 4 bed, 2 bath home located in the Estates of Teal Run in Fresno is nestled on a lovely neighborhood street. High ceilings and arched openings connect the rooms in a spacious, comfortable floor plan. As you enter, the formal dining room is on the left. It connects to the kitchen making meal service easy. Engineered wood floors connect the main living areas seamlessly. Step into a spacious living room under a vaulted ceiling that offers a gas fireplace as a decorative focal point and large windows with a backyard view. It opens to the kitchen that features stainless steel appliances and warm wood-toned cabinets. Adjacent is a cozy breakfast room with access to the backyard. The primary bedroom suite rests under a tray ceiling. It includes a large walk-in closet as well as a bath that offers a garden tub, separate shower, and separate vanity areas. Enjoy relaxing in a fabulous backyard with plenty of space to relax or host a summer barbecue. A must-see!','0.1618','38','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Missouri City Area','Central Gas','1','ESTATES OF TEAL RUN SEC 3, BLOCK 3, LOT 18','Subdivision Lot','7050','Appraisal District','','450','0','','2','Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','19 - Fort Bend','GOODMAN ELEMENTARY SCHOOL (FORT BEND)','HIGHTOWER HIGH SCHOOL','LAKE OLYMPIA MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Estates Of Teal Run Sec 3','4496','2.4829','Public Sewer,Water District','2003','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-22T05:49:39.430' ,`MLSNumber` = '68739294' ,`ListAgentFullName` = 'Christina Pizzitola' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.689881' ,`Longitude` = '-95.480095' ,`PhotoCount` = '50' ,`PostalCode` = '77096' ,`RoomCount` = '13' ,`ListPrice` = '1475000.00' ,`Status` = 'Active' ,`StreetName` = 'Edith' ,`StreetNumber` = '5411' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5353' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '5411 Edith Street has everything you have been looking for, and more! This beautiful 2007(per HCAD) Brookstone Home situated on a 10,500 square foot lot (per HCAD) features 5-bedrooms, 4.5-bathrooms, TWO utility rooms and a game room! Upon entry into this 5,353 square foot house (Per HCAD), you’ll find the gorgeous office/library with newly installed windows, formal dining room, and the perfect wine room for entertaining! The Kitchen features a large island & breakfast area, which then opens to the Family Room where you will enjoy looking out onto the expansive backyard and gated pool. The large Primary Suite features a separate sitting area and Primary Bathroom which offers dual vanity sinks, a walk-in shower, soaking tub, and a walk-in closet with built-ins. The property has a two-car garage, and a two-car porte-cochere. Near Meyerland Shopping, Downtown and the Medical Center! Come see this fabulous home today!All info per seller' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = 'BROOKSTONE HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 2 BRAES VIEW TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed,Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Braes View Terrace' ,`TaxAmount` = '22934' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663849898' WHERE `Matrix_Unique_ID` = '212421136' --> 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','212527417','1663849899','212527417','2022-09-22T04:54:16.557','95365192','Treva Christopher','The Christopher Dynasty Real Estate Group','','','30.002917','-95.789227','39','77447','8','335000.00','Active','Kailua','31502','Drive','Hockley','2','0','4','2062','Single-Family','Charming one story home in Stone Creek Ranch! Only 2 years young, this captivating home features four bedrooms and two bathrooms and a study. Chef’s dream kitchen includes gorgeous granite countertops with island, beautiful subway tile backsplash, lots of dark wood cabinetry for storage, stainless appliances, and a walk-in pantry. Off the kitchen is a spacious area for a breakfast nook. This inviting open floor plan offers views of the living room from the kitchen. The Massive living room features high ceilings, beautiful flooring, and big windows. The spectacular primary bedroom provides a lot of space and a private en suite. This lavish primary bathroom presents a garden bathtub, separate standing shower, numerous amount of countertop space with dual sinks, and a walk-in closet. The backyard is private and features a covered patio and is large enough for outdoor activities and social gatherings! Corner Lot!','0.1508','25','','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Cypress South','Central Gas','1','LT 17 BLK 4 STONE CREEK RANCH SEC 9 R/P','Corner','6571','Appraisal District','','950','0','','2','Gas Oven','0','','','Gas Range','','Composition','55 - Waller','ROBERTS ROAD ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','WALLER JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Appraisal District','1','Traditional','Stone Crk Ranch Sec 9 Rep #','8029','3.1924','Water District','2020','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','212585090','1663849899','212585090','2022-09-22T04:45:20.237','43958038','Jennifer Doring','Styled Real Estate','','','29.996894','-95.794414','27','77447','10','399000.00','Active','Eric Trail','16018','Drive','Hockley','2','0','3','2270','Single-Family','Gorgeous MOVE-IN ready home in Stone Creek Ranch! Welcome to a beautiful 3-4 bedroom 2 bathroom home located on an oversized corner lot on a cul-de-sac in Stone Creek Ranch in Hockley, TX. The Glenwood floor plan by CastleRock offers a split floor plan with 2 bedrooms & a full bath immediately to the right as you enter the home. The primary bedroom w/en-suite is located at the rear of the home off of the kitchen/dining/family room area. There is a FLEX space located off of the kitchen area currently being used as a home office, but could be a 4th bedroom, 2nd living, etc. Open concept living with a spacious kitchen with breakfast bar open to the dining & family room. High ceilings. Natural light. Plenty of storage in this home. Covered patio off of the family room at the back of the home. A large side yard w/room for a pool. No flooding. Close to restaurants & shopping at 99/290. Stone Creek Ranch offers a neighborhood pool, park, clubhouse, & walking path around the lake.','0.1805','25','CastleRock','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Cypress South','Central Gas','1','LT 52 BLK 2 STONE CREEK RANCH SEC 3','Corner,Cul-De-Sac,Subdivision Lot','7861','Appraisal District','','950','0','','2','Freestanding Oven,Single Oven','0','','','Gas Range','','Composition','55 - Waller','ROBERTS ROAD ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','WALLER JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Stone Creek Ranch','7866','3.1924','Water District','2016','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-22T05:21:18.957' ,`MLSNumber` = '81880111' ,`ListAgentFullName` = 'James Bollig' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.065528' ,`Longitude` = '-95.138098' ,`PhotoCount` = '49' ,`PostalCode` = '77336' ,`RoomCount` = '11' ,`ListPrice` = '920000.00' ,`Status` = 'Active' ,`StreetName` = 'Monterey Cliff' ,`StreetNumber` = '28403' ,`StreetSuffix` = 'Lane' ,`City` = 'Huffman' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3825' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxurious Lake Houston Living! Stunning 2015 Elara custom home located in the beautiful Waterway Section of The Commons of Lake Houston. This 3,748 sq ft home features 4 bedrooms, 3 full baths & 2 half baths, study, formal dining room, game room, 3 car garage, and an exquisite pool & spa on a spacious 1.67 acre lot (2 lots) on the water with TWO private boat docks for your boat & jet ski! The home boasts custom cabinetry throughout, travertine flooring, granite counters, lighted tray ceilings, a fabulous primary bathroom with a jetted soaking tub and a walkthrough multi-head shower! The covered porch, private pool & spa, and firepit overlook the water and provide a relaxing and peaceful experience. The private boat docks provide quick & easy access to the lake for your boating entertainment. The Commons also features miles of hiking/biking trails, two private lakeside parks with boat ramps, and vast wildlife. Be sure to watch the beautiful video tour! Fall in love with The Commons!' ,`Acres` = '1.6711' ,`Area` = '32' ,`BuilderName` = 'Elara Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'LTS 55 & 56 BLK 2 COMMONS WATERWAY SEC 4' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '72793' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Craftsman' ,`Subdivision` = 'Commons Waterway Sec 4' ,`TaxAmount` = '22912' ,`TaxRate` = '3.2592' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663849899' WHERE `Matrix_Unique_ID` = '212659608' --> 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','212708328','1663849899','212708328','2022-09-22T04:16:31.697','19669631','Frank Crianza','Keller Williams Elite','','','29.807426','-94.839906','29','77523','10','340000.00','Active','Veranda','7702','Drive','Cove','2','0','4','1871','Single-Family','Beautiful home in Barbers Hill ISD, Ideally located on an oversized 0.404 acre lot with no back neighbors! Primary bedroom features tray ceiling with spacious en-suite equipped with garden tub and separate shower with spacious his and hers walk-in closets. Second bathroom has double vanities. Kitchen boasts maple cabinets and granite countertops as well as a breakfast bar that opens up to the large family room. Front bedroom currently used as an office with double door access and large closet. 2-car garage with immaculate terrazzo flooring is the perfect space for anyone looking to upgrade their garage aesthetic. ALL furniture and appliances are included with the sale, including the large TV in the living room. Large back yard that backs up to Cotton Bayou that has been professionally graded and sodded to resist erosion. Attic A/C System was replaced this year (8/12/2022) and 10 year parts/1 year labor warranty conveys upon purchase. HOME HAS NEVER FLOODED !','0.404','53','Eagle Point Homes','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Chambers County West','Central Electric','0','LT 54 VERANDA S/D SEC 1','Subdivision Lot','17598','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox','Appraisal District','1','Traditional','Veranda S/D','4225','1.7058','Public Sewer,Public Water','2015','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-22T04:19:44.090' ,`MLSNumber` = '66728097' ,`ListAgentFullName` = 'Jackie Zehl' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.669164' ,`Longitude` = '-95.491668' ,`PhotoCount` = '50' ,`PostalCode` = '77096' ,`RoomCount` = '14' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Wigton' ,`StreetNumber` = '5835' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2598' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Smartly Updated Never Flooded* Traditional Style Home, positioned on a Landscaped Lot of a Cul-de-Sac Street, in the Close-in Maplewood South Neighborhood! Stylish Appointments include Polished Travertine Tile Floors,Pella Windows,Newly Installed Engineered Hardwood Floors, & Crown Molding. Kitchen touts Corian Counters,White Tile Backsplash,CustomStyle White-Washed Cabinets (w/Glass Front),Kohler Porcelain Sink, G.E. Profile 4 Burner Cooktop, SS Dble Ovens,SS Blt-in Microwave, & SS Refrigerator. White Painted Block Panelled Walls are Showcased in the Breakfast Rm & the Den. Inviting Den offers a Brick Fireplace, w/Brick Hearth & Wood Mantle. Rustic Lodge Style Sunroom boasts Knotty Finished Wood, Cathedral Ceiling,& Skylights! Expansive Primary Suite features 2 Closets, Dual Sinks, & Walk-in Shower, w/Tile Surround. Secondary Bedrms Up & Hall Bath w/Stacked Stone, Shaker Style Cabinets,& Full Tub/Shower. Gated Drive + 2 Car Carport.*Per Seller' ,`Acres` = '0.1818' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 7 MAPLEWOOD SOUTH SEC 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Maplewood South' ,`TaxAmount` = '7404' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663849899' WHERE `Matrix_Unique_ID` = '212736616' --> 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','212748334','1663849899','212748334','2022-09-22T05:43:44.847','41465823','Tina Powers','JLA Realty','','','30.026107','-95.635382','47','77377','11','639990.00','Active','Hardy Trace','18506','Drive','Tomball','3','1','4','3738','Single-Family','Immaculately maintained home with easy access to 99 and Hwy 249. This gorgeous home has everything you could ask for located in the prestigious gated Wildwood at Northpointe. Located on a cul-de-sac, the lush green yard has amazing landscaping & outdoor lighting. Entering the home you have a formal dining area and a beautiful iron spindle staircase leading up to 3 bedrooms, media room, gameroom and a balcony with breathtaking views of the private lake. For the exercise enthusiasts, it is a 1.1 mile walk around the lake. Downstairs you will find an amazing primary bedroom with lake view, large en suite, dual sinks, seamless shower, garden tub and a large walk in closet. You will love entertaining in the fantastic kitchen with granite counter tops, tons of cabinet space, farm sink, walk in pantry and under counter lighting. Looking into the den you will see a gorgeous wall of windows and a cast stone gas fireplace. Book your appt today to see this incredible home!!!','0.2238','35','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Tomball South/Lakewood','Central Gas','1','LT 9 BLK 1 WILDWOOD AT NORTHPOINTE SEC 7','Cleared,Cul-De-Sac,Greenbelt,Water View','9750','Appraisal District','','1435','0','','3','Gas Oven','0','','','Gas Range','','Composition','53 - Tomball','WILDWOOD ELEMENTARY SCHOOL','TOMBALL MEMORIAL H S','GRAND LAKES JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Wildwood/Northpointe','12990','3.0564','Public Sewer,Water District','2014','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','212758528','1663849899','212758528','2022-09-22T05:02:38.170','18405985','Kerry Duncan','Texas Premier Realty','','','29.809630','-95.841792','34','77493','7','390000.00','Active','Goldstrum','6927','Way','Katy','2','0','3','2003','Single-Family','Great location in one of the smaller sections in Cane Island! A Library/Study with French doors set at entry and front of the home. Island Kitchen is open to the Dining Room and Family Room which features a back wall of windows. The spacious Master Bedroom also has a wall of windows. The Master bath includes a corner garden tub, a separate glass-enclosed shower and a walk-in closet. Mud room is right off the garage, and the Utility Room has plenty of room for a second fridge. The Covered Patio is also screened-in. There is also a Warming Tray in the kitchen below the ovens.','0.1421','25','Perry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Katy - Old Towne','Central Gas','1','S422385 CANE ISLAND SECTION 25 BLK 2 LOT 4','Subdivision Lot','6189','Appraisal District','','1200','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','KATY JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Cane Island Sec 25','10800','3.4077','Public Sewer,Public Water','2019','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','212796803','1663849899','212796803','2022-09-22T05:43:15.333','31396853','Kayla Sorrell','Pop Realty','','','29.579816','-95.050709','47','77586','4','420000.00','Active','Drift Wood','127','Drive','Taylor Lake Village','2','1','4','2395','Single-Family','If quiet tree-lined streets with sprawling Oaks and friendly neighbors is what you\'re looking for - this home is for you! Nestled in the very desirable subdivision of Timber Cove, home to several Gemini and Apollo astronauts. You won\'t find a more immaculate remodeled 4 beds, 2.5 bath home on an oversized lot. Upon entering the home, you\'ll find a formal living & formal dining room. The formal dining room leads to the kitchen which is open to the breakfast room & family room. If you want a home with STORAGE, this is the one! The laundry room has floor-to-ceiling cabinets. Lush backyard and extra room attached to the garage can be a fantastic game room, man cave, art studio, or secluded office. Timber Cove is loaded w/ perks - relax & cool off at the Mercury capsule-shaped community pool, get some exercise on the walking trail or one of the largest disc golf courses in Clear Lake, fish from the fishing dock or use the private boat ramp to take a ride through Taylor Lake.','0.2812','7','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Clear Lake Area','Central Gas','1','LT 11 BLK 8 TIMBER COVE SEC 2','Subdivision Lot','12248','Appraisal District','','122','0','','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','9 - Clear Creek','ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)','CLEAR LAKE HIGH SCHOOL','SEABROOK INTERMEDIATE SCHOOL','Appointment Required','Appraisal District','1','Contemporary/Modern,Ranch','Timber Cove Sec 02','6580','2.279','Water District','1961','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','212803224','1663849899','212803224','2022-09-22T05:33:48.823','87452096','Vuong-Vu Bui','eXp Realty, LLC','','','29.483850','-95.523962','42','77459','10','599900.00','Active','2627 Lazy Vine Ln','2627','Lane','Missouri City','3','1','4','3241','Single-Family','WELCOME HOME to this stunning 4 bedroom, 3.5 bath dwelling located in the highly coveted, master-planned community of SIENNA, boasting a spacious, open floor plan, and NO BACK NEIGHBORS! Features include upgraded stone and brick elevation, well-manicured landscaping, wrought iron spindles, study with French doors, dining area with built-in storage, living room with 2-story ceiling, large GAME ROOM, extended COVERED PATIO for outdoor entertaining, and 3-CAR GARAGE. The gourmet kitchen features an oversized island with ample seating, granite countertops, mosaic tile backsplash, and Frigidaire stainless steel appliances. Primary suite includes a sitting area, walk-in closet, dual vanities, and large walk-in shower. Enjoy nearby neighborhood amenities, including 100+ acres of parks, miles of walking trails, waterparks, Sienna Golf Club + Grille, Sienna Stables, Camp Sienna Sports Park, Club Sienna, and many more. Zoned to highly rated RIDGE POINT HIGH SCHOOL. COME AND SEE!!','0.2116','38','','','','','Mud,Sellers Disclosure','','','','Sienna Area','Central Gas','1','SIENNA VILLAGE OF DESTREHAN SEC 5, BLOCK 1, LOT 23','Cul-De-Sac','9216','Appraisal District','','1200','0','','3','','0','','','','','Composition','19 - Fort Bend','LEONETTI ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','THORNTON MIDDLE SCHOOL (FORT BEND)','Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox','Appraisal District','2','Craftsman,Other Style','Sienna Village Of Destrehan','13332','3.1629','Public Sewer,Water District','2016','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','212808622','1663849899','212808622','2022-09-22T05:50:32.393','11909819','Jojuana Cleveland','Ultima Real Estate','','','29.559080','-95.292688','28','77584','4','320000.00','Active','Cypress Bend','4706','Court','Pearland','2','0','4','2252','Single-Family','Pride in ownership is apparent here! This beautiful former Ryland home is an entertainers dream. Rich hardwood floors welcome you at the entry, hallways and formal living room. The formal dining area is open making mingling easy. The large family room has a see through fireplace that is wood burning with a gas starter. The open kitchen features a nice island, a stove that is electric but has plumbing in place for gas, Corian countertops , breakfast bar and eat in kitchen. The spacious owners retreat has his and her closets, a garden tub with separate shower and a linen closet. The secondary bedrooms are split for privacy and the floor plan is flexible so that the 4th bedroom can easily be used as an office. The backyard oasis features a lovely water fountain and fire pit perfect for relaxing. There is a community park with slides and swings right around the corner. Come take a look today!','0.1515','5','','','','','Mud,Sellers Disclosure','','Gas Connections,Wood Burning Fireplace','1','Pearland','Central Gas','1','PARKS AT WALNUT BEND SEC 1 (A0239 HT&BRR) , BLOCK 1, LOT 12','Subdivision Lot','6599','Appraisal District','','315','0','','2','Electric Oven','0','','','Electric Range','','Composition','42 - Pearland','C J HARRIS ELEMENTARY SCHOOL','PEARLAND HIGH SCHOOL','PEARLAND JUNIOR HIGH EAST','Accompany,Appointment Required','Appraisal District','1','Traditional','Parks At Walnut Bend Sec 1-2','7651','2.8851','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','212809793','1663849899','212809793','2022-09-22T05:42:38.440','35610544','Feras Rachid','Opendoor Brokerage, LLC','','','29.930319','-95.396602','34','77060','3','236000.00','Active','Sulky Trail','362','Street','Houston','2','0','3','1803','Single-Family','This Houston one-story home offers a patio, and a two-car garage.','0.1742','34','','','','','Sellers Disclosure','1','','1','Aldine Area','Central Gas','1','LT 4 BLK 17 IMPERIAL VALLEY SEC 5','Subdivision Lot','7588','Appraisal District','','164','0','','2','','0','','','','','Other','1 - Aldine','BLACK ELEMENTARY SCHOOL (ALDINE)','ALDINE HIGH SCHOOL','LEWIS MIDDLE SCHOOL','Appointment Required,No Supra Keybox','Seller','1','Traditional','Imperial Valley Sec 05','3571','2.5119','Public Water','1970','Seller'); --> 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','212809852','1663849899','212809852','2022-09-22T05:45:01.113','80653901','Feras Rachid','Opendoor Brokerage, LLC','','','29.511749','-95.030371','18','77573','3','240000.00','Active','Whitesail','3216','Drive','League City','2','0','3','1397','Single-Family','This League City one-story cul-de-sac home offers a two-car garage.','0.2096','33','','','','','Sellers Disclosure','','','0','League City','Central Gas','0','ABST 32 R BASQUEZ SUR LOT 35 BLK 1 BAY RIDGE SUB','Cul-De-Sac,Subdivision Lot','9130','Appraisal District','','','0','','2','','0','','','','','Composition','9 - Clear Creek','SANDRA MOSSMAN ELEMENTARY SCHOOL','CLEAR FALLS HIGH SCHOOL','BAYSIDE INTERMEDIATE SCHOOL','Appointment Required,No Supra Keybox','Seller','1','Traditional','Bay Ridge','2442','2.0697','Public Water','1977','Seller'); --> New record created successfully