Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T12:37:17.080' ,`MLSNumber` = '8044858' ,`ListAgentFullName` = 'Matthew Krenek' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.734965' ,`Longitude` = '-96.163156' ,`PhotoCount` = '28' ,`PostalCode` = '77474' ,`RoomCount` = '11' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = 'FM 3013' ,`StreetNumber` = '1619' ,`StreetSuffix` = '' ,`City` = 'Sealy' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3992' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy country living in this spacious home (3,992 SqFt) that sits on approximately 1.41 acres in Sealy, Texas. Great for entertaining, this home features living room, family room, game room, formal dining room, and breakfast area. On the first floor, you\'ll find primary suite, two secondary bedrooms, and office/study. Upstairs includes two additional secondary bedrooms, game room and bathroom. Oversized covered patio is great for relaxing. 10\' x 15\' Storage Shed included. Located conveniently to I-10. Zoned to Sealy ISD. Room sizes to be independently verified.' ,`Acres` = '1.412' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SEALY SUB BLOCK 19 LOT 4' ,`LotDesciption` = 'Corner' ,`LotSize` = '61507' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SELMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sealy Sub' ,`TaxAmount` = '6752' ,`TaxRate` = '1.8832' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086092' WHERE `Matrix_Unique_ID` = '210035256'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T11:45:18.447' ,`MLSNumber` = '76821287' ,`ListAgentFullName` = 'John Chambers' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.718886' ,`Longitude` = '-95.363958' ,`PhotoCount` = '37' ,`PostalCode` = '77004' ,`RoomCount` = '10' ,`ListPrice` = '429000.00' ,`Status` = 'Active' ,`StreetName` = 'Wentworth' ,`StreetNumber` = '3306' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2755' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Seller is offering a 2 for 1 Buy Down of Rate with reasonable offer.  This offer will save the buyer $500 plus off of monthly payment in year 1 and just under $300 in year 2*****You are sure to appreciate this luxury retreat that is perfect as a luxury vacation rental, Airbnb or single family residence. This four bedroom, three bathroom home is located in Haden Terrace and is just minutes from Downtown, the Museum District, the Medical District, the Zoo, The University of Houston, Texas Southern University and NRG Stadium.  A large den, living room, game room, wet bar and a bonus room that houses an indoor hot tub and sauna room with connected shower and bathroom make this an entertainers paradise.  The home is complete with stainless steal appliances, granite countertops, new paint, and new wood vinyl flooring. PROPERTY COMES FULLY FURNISHED! Washer, dryer and refrigerator convey. Art work in secondary bedrooms does not convey' ,`Acres` = '0.1515' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 27 BLK 2 HADEN TERRACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Haden Terrace 1' ,`TaxAmount` = '7540' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086093' WHERE `Matrix_Unique_ID` = '212112400'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T11:04:33.547' ,`MLSNumber` = '2632428' ,`ListAgentFullName` = 'William Phillips' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.920304' ,`Longitude` = '-95.391325' ,`PhotoCount` = '36' ,`PostalCode` = '77060' ,`RoomCount` = '8' ,`ListPrice` = '229500.00' ,`Status` = 'Active' ,`StreetName` = 'Hummingbird' ,`StreetNumber` = '446' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1844' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Tremendous residential/commercial opportunity with exceptional location. Strategically located less than 5 minutes from I 45, Hardy Toll Road and Sam Houston Tollway. This charming cottage has amazing potential and sits on an over-sized, cul de sac lot with large workshop and extended detached garage. Highly sought after community. Property and improvements/structures did not flood from Harvey, per sellers.' ,`Acres` = '0.2809' ,`Area` = '34' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas,Wall Heater,Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 32 SWEA GARDENS ESTATES U/R' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '12236' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ODOM ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'ALDINE HIGH SCHOOL' ,`SchoolMiddle` = 'ALDINE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Swea Gardens Estates U/R' ,`TaxAmount` = '2977' ,`TaxRate` = '2.1528' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086093' WHERE `Matrix_Unique_ID` = '212764248'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T12:08:28.290' ,`MLSNumber` = '93996796' ,`ListAgentFullName` = 'Angela Chiang' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.003693' ,`Longitude` = '-95.642060' ,`PhotoCount` = '33' ,`PostalCode` = '77429' ,`RoomCount` = '14' ,`ListPrice` = '825000.00' ,`Status` = 'Active' ,`StreetName` = 'Nathan Ridge' ,`StreetNumber` = '13830' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4925' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Desirable cul-de-sac custom home in Rock Creek with 5 bedrooms, 5/1 baths plus media room (adds approx. 285 sqft to the 4925 sqft), office, game room, pool and 3 car garage. Sought after layout with a primary AND guest suite on the first floor. Gorgeous chandeliers, dramatic high ceilings with intricate tray ceiling detail are sure to wow guests. Covered patio with cool decking overlooks the heated pool with waterfalls and hot tub spa- a true backyard oasis. Updates in the past two years includes: new chandeliers, LED lighting, interior paint, carpet, built in speakers, double washers and dryers, custom dog washing station and built in kennels, resurfaced pool with polished PebbleTec and new pool parts, dishwasher, landscape lighting, double sided fence and so much more. The coveted Rock Creek community includes many amenities: trails, fitness center, pool, splash pad, tennis, basketball and pickleball courts—perfect for those seeking an active, social and healthy lifestyle.' ,`Acres` = '0.2835' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 ROCK CREEK SEC 11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BLACK ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rock Creek' ,`TaxAmount` = '18712' ,`TaxRate` = '2.82' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086093' WHERE `Matrix_Unique_ID` = '213159968'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T12:31:54.310' ,`MLSNumber` = '3336550' ,`ListAgentFullName` = 'Colby Walters' ,`ListOfficeName` = 'Swede\'s Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.463937' ,`Longitude` = '-94.613166' ,`PhotoCount` = '16' ,`PostalCode` = '77650' ,`RoomCount` = '1' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Clara' ,`StreetNumber` = '951' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '1026' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here is your chance to own real estate on the Bolivar Peninsula at a price point unlike any other. Charming one bed one bath home built in 1988. This beach house has stood the test of time and still remains strong to this day. Very well maintained and cared for. Peek a boo view of the Gulf and located on a direct beach access road. Located in the heart of Crystal Beach near all restaurants, bars, attractions, and shops. This one won\'t last long!' ,`Acres` = '0.0973' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 PAGE 7 LOT 106 PEARL BEACH ADDN' ,`LotDesciption` = 'Other' ,`LotSize` = '4237' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Pearl Beach' ,`TaxAmount` = '3953' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086093' WHERE `Matrix_Unique_ID` = '213622919'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T12:51:47.610' ,`MLSNumber` = '96050561' ,`ListAgentFullName` = 'Tanner Charalampous' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.599205' ,`Longitude` = '-95.212414' ,`PhotoCount` = '14' ,`PostalCode` = '77089' ,`RoomCount` = '7' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Sagehurst' ,`StreetNumber` = '11606' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2235' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL, WELL MAINTAINED, UPGRADES GALORE - LARGE ROOMS THROUGHOUT HOUSE; EXTENDED DEN, KITCHEN AND BREAKFAST AREA. CUSTOM CABINETS W/BUILT-INS. KITCHEN FEATURES BLACK GRANITE COUNTERTOPS, BAR AND GRANITE BACKSPLASH. MAIN BATHROOM W/TRAVERTINE FLOOR AND STANDUP SHOWER. NEW WATER HEATER AND RECENT HEAVY INSULATION, LARGE FENCED BACKYARD WITH MATURE PECAN TREE; ENJOY THE BACKYARD\'s HUGE 2-LEVEL DECK WITH BUILT-IN BBQ GRILL AND STORAGE SHED. HURRY THIS HOME WON\'T LAST LONG!' ,`Acres` = '0.1641' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 13 SAGEMONT SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'STUCHBERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sagemont Sec 03' ,`TaxAmount` = '4202' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086094' WHERE `Matrix_Unique_ID` = '214043026'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T11:07:07.717' ,`MLSNumber` = '90499176' ,`ListAgentFullName` = 'Cynthia Campos' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.741837' ,`Longitude` = '-95.240776' ,`PhotoCount` = '13' ,`PostalCode` = '77547' ,`RoomCount` = '3' ,`ListPrice` = '179000.00' ,`Status` = 'Active' ,`StreetName` = '13th' ,`StreetNumber` = '1906' ,`StreetSuffix` = 'Street' ,`City` = 'Galena Park' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Excellent property located in the heart of Galena Park! Double lot with much potential. Within walking distance to all schools.' ,`Acres` = '0.2296' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 3 & 4 BLK 74 CLINTON' ,`LotDesciption` = 'Other' ,`LotSize` = '10000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'MACARTHUR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GALENA PARK HIGH SCHOOL' ,`SchoolMiddle` = 'GALENA PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clinton' ,`TaxAmount` = '3554' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086094' WHERE `Matrix_Unique_ID` = '214551370'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T12:33:04.880' ,`MLSNumber` = '80513761' ,`ListAgentFullName` = 'Maggie Martinez' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.249689' ,`Longitude` = '-95.445615' ,`PhotoCount` = '19' ,`PostalCode` = '77302' ,`RoomCount` = '3' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Fort Sumpter' ,`StreetNumber` = '538' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2838' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Traditional style home in highly desirable River Plantation neighborhood in Conroe and nestled in a cul-de-sac street. Surrounded by tall mature pine trees and in close proximity to the River Plantation Country Club. This home has an updated kitchen with granite counter tops, subway tile back splash; new stainless appliances, sink and faucet. Family room and living is spacious with full brick veneer wall providing a wood burning fireplace; French doors lead to back patio and detached 2-car garage and breakfast area. This home has an all brick exterior with a spacious back yard with a pool, jacuzzi and a covered deck area perfect for an outdoor kitchen. Enjoy all the amenities which include of miles of walking/biking trails, River Plantation Country Club, shopping, restaurants and more!' ,`Acres` = '0.2784' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S832003 - RIVER PLANTATION 03, LOT 92' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '12128' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '222' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'River Plantation 03' ,`TaxAmount` = '6344' ,`TaxRate` = '2.1648' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086094' WHERE `Matrix_Unique_ID` = '214996944'  --> Updated record success<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215120193','1675086094','215120193','2022-12-01T11:12:26.727','5244906','Christy Wade','BHGRE Gary Greene','','','29.847688','-95.805941','38','77493','9','415000.00','Active','Monarch Belle','5110','Lane','Katy','3','1','4','2745','Single-Family','Beautiful Beazer 4 bedroom, 3.5 bath home located on large corner lot in the community of King Crossing, zoned to KISD.  Upon entry, private study with french doors. The chef in the family, will love the kitchen with rich cabinets, large island, custom backsplash, granite counters, SS appliances and 2 windows under the cabinets for natural light.  The breakfast room and family room are off the Kitchen, for easy family gatherings.  Secluded master suite on the 1rst floor.  Primary bath includes soaking tub, shower and walk in closet.  Large gameroom up with 3 spacious bedrooms and 2 full baths(1 ensuite) Covered front porch and covered back patio.  Large lot on corner.  Community amenities include resort-style pool, splash pad, play grounds and dog park.  Easy access to major freeways, dining, shopping and entertainment.','0.1977','25','Beazer Homes','','','','Mud,Sellers Disclosure','1','','','Katy - Old Towne','Central Gas','1','LT 15 BLK 2 KING CROSSING SEC 10','Corner,Subdivision Lot','8612','Appraisal District','','800','0','','2','','0','','','Gas Cooktop','','Composition','30 - Katy','BETHKE ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','STOCKDICK JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,No Supra Keybox','Appraisal District','2','Traditional','King Crossing','10794','3.4768','Water District','2017','Appraisal District');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215213544','1675086094','215213544','2022-12-01T12:48:42.007','33581159','Kati Hall','RE/MAX On The Water - Bolivar','','','29.472624','-94.592249','47','77650','3','565000.00','Active','Gateway','939','','Crystal Beach','2','0','3','1559','Single-Family','NEW CONSTRUCTION home just minutes from the Beach! Home offers vaulted ceiling in the living room area and open to the kitchen. Kitchen feature above and under cabinet lighting. Amazing backsplash and will feature a stainless steal vent-a-hood. Large island with multiple seating. Living room features lots of natural lighting and fabulous shiplap accent wall. Upstairs you will find the Primary bedroom with private balcony! Enjoy the sound of the waves and the beautiful views while sipping your morning coffee. This property is the perfect location! Close to Restaurant\'s and Shopping.','0.1033','33','Prestige','','','','Other Disclosures','1','','','Crystal Beach','Central Electric','0','ABST 65 B FRANKS SUR LOT 26 BLK 7 GATEWAY','Cleared,Other','4500','Appraisal District','','','1','Never Lived In','1','','0','','','Freestanding Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Accompany,Appointment Required','Builder','2','Other Style','Gateway','333','1.6103','Aerobic,Public Water','2022','Builder');  --> New record created successfully<br />