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-08-27T14:16:22.190' ,`MLSNumber` = '73188435' ,`ListAgentFullName` = 'Jeffrey Welch' ,`ListOfficeName` = 'Welch Realty Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.081123' ,`Longitude` = '-95.521555' ,`PhotoCount` = '30' ,`PostalCode` = '77379' ,`RoomCount` = '4' ,`ListPrice` = '297000.00' ,`Status` = 'Active' ,`StreetName` = 'Amesbury Meadow' ,`StreetNumber` = '21622' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a one-story home with an open floor plan, tiles in all wet areas, and high ceilings in the family room, granite countertops, tile backsplash in the kitchen, black appliances, a security system, and more. The home is going to have new carpet and new paint along with additional make-ready. If you are fast might be able to pick the color of carpet and paint.' ,`Acres` = '0.132' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 SPRING TERRACE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MUELLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Spring Terrace' ,`TaxAmount` = '4969' ,`TaxRate` = '2.6526' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703715' WHERE `Matrix_Unique_ID` = '201052057' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T14:31:19.427' ,`MLSNumber` = '12242232' ,`ListAgentFullName` = 'Elmer Salamanca' ,`ListOfficeName` = 'HOUSTON HOUSE OF REALTY, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.677677' ,`Longitude` = '-95.369088' ,`PhotoCount` = '8' ,`PostalCode` = '77051' ,`RoomCount` = '12' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Colonial' ,`StreetNumber` = '7810' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2021' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location. Location. Location. You\'ll never have to worry about convenience and comfort with this beautiful brand new 2- story home located minutes from Downtown Houston, Medical Center South, NRG, the university area, Houston Zoo, and Hermann Park. This is an open concept home with 3 - bedrooms, 3.5- bathrooms, and a two-car garage. This home features high ceiling walls and a stunning island kitchen. Huge master bedroom with a big bathroom and closet. Great price for this amazing home. The anticipated completion is by the end of July 2022.' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'ARA GROUP LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 20 BLK 42 SUNNYSIDE PLACE' ,`LotDesciption` = 'Other' ,`LotSize` = '2500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'YOUNG ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sunnyside Place' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703715' WHERE `Matrix_Unique_ID` = '208016362' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T14:04:30.560' ,`MLSNumber` = '24004857' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.465173' ,`Longitude` = '-95.027475' ,`PhotoCount` = '37' ,`PostalCode` = '77539' ,`RoomCount` = '7' ,`ListPrice` = '263690.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Maison' ,`StreetNumber` = '4120' ,`StreetSuffix` = 'Circle' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1427' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful One story 1427 sqft with 2 car garage. 3 sides acme brick with covered back patio. 3 bedrooms and 2 full baths. Granite kitchen with deep under mount sink and 42\" cabinets. Stainless steel 5 burner gas range, microwave, dishwasher, refrigerator. 2\" blinds and window treatments included!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 2 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8026' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bayou Maison' ,`TaxAmount` = '' ,`TaxRate` = '2.521389' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703716' WHERE `Matrix_Unique_ID` = '209096898' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T14:21:44.533' ,`MLSNumber` = '49629387' ,`ListAgentFullName` = 'Roger Elam' ,`ListOfficeName` = 'Elam Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.985467' ,`Longitude` = '-95.582230' ,`PhotoCount` = '25' ,`PostalCode` = '77422' ,`RoomCount` = '8' ,`ListPrice` = '549900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 416' ,`StreetNumber` = '247' ,`StreetSuffix` = '' ,`City` = 'Brazoria' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2843' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '(Motivated Seller) The river is calling. Come listen for your name as you look at this spacious 4 bedroom, 4 bathroom home on over one acre with approximately 340\' of fully bulkheaded San Bernard River frontage. Never flooded (not even during Hurricane Harvey). Large family room with a wood burning fireplace, breakfast room with bay-windows overlooking one of the best views on the river. Formal dining room, spacious paneled study, large walk-in pantry and indoor utility room. Detached 3 car garage and plenty of additional paved parking. An expansive wooden deck overlooks the river affording a perfect setting for entertaining and relaxing with the beverage of your choice as you watch the river flow by. When the days activities wind down the 4 bedrooms and 4 full bathrooms will accommodate family and guests in privacy and comfort. Come see if it\'s your name the river is calling......' ,`Acres` = '1.111' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'A0058 REBECCA CUMMINGS TRACT 14C ACRES 1.111' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '48395' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rebecca Cummings' ,`TaxAmount` = '4699' ,`TaxRate` = '2.0957' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703716' WHERE `Matrix_Unique_ID` = '209375104' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T14:36:03.883' ,`MLSNumber` = '39221267' ,`ListAgentFullName` = 'Carletha Francis' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.685992' ,`Longitude` = '-95.372970' ,`PhotoCount` = '23' ,`PostalCode` = '77021' ,`RoomCount` = '4' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Noah street' ,`StreetNumber` = '3540' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1735' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make this stunning YOURS! Located minutes from the Houston Zoo,Medical Center, Downtown. The second floor features Modern Open concept floorpan living space with beautiful kitchen, Massive island ,quartz countertops, nice lighting, beautiful finishes and craftsmanship adorn each floor. Smart-home setup, Close to I69, I45, 288. Schedule your Private-Tour Today!' ,`Acres` = '0.0574' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Probate' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 NOAH WOODS ESTATES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WHIDBY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Lockbox Right Side,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Noah Woods Ests' ,`TaxAmount` = '5159' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703716' WHERE `Matrix_Unique_ID` = '209487734' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T14:03:57.770' ,`MLSNumber` = '31857320' ,`ListAgentFullName` = 'Susan Key' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745934' ,`Longitude` = '-95.592176' ,`PhotoCount` = '32' ,`PostalCode` = '77077' ,`RoomCount` = '12' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Eagle Falls' ,`StreetNumber` = '1827' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3134' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This jewel of a home situated in the highly sought after neighborhood of Ashford Village in the heart of the energy corridor. Your new home is located just blocks from the elementary school, the community pool, community park and tennis courts. Low taxes, no MUD and no flooding. This home is located within the city but with the serenity and peaceful atmosphere that makes it seem miles away. Your new home offers a built out garage apartment; sparkling heated pool with rock waterfall and hot tub with a gazebo . Inside you will enjoy a wet bar, media room, double-pane windows; stately shade trees and a cozy gas log fireplace.' ,`Acres` = '0.1843' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 14 ASHFORD VILLAGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8027' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashford Village Sec 01' ,`TaxAmount` = '7473' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703716' WHERE `Matrix_Unique_ID` = '209520902' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T14:25:48.527' ,`MLSNumber` = '61084550' ,`ListAgentFullName` = 'Misti Bruton' ,`ListOfficeName` = 'AVO Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.952106' ,`Longitude` = '-97.949848' ,`PhotoCount` = '39' ,`PostalCode` = '78666' ,`RoomCount` = '5' ,`ListPrice` = '585000.00' ,`Status` = 'Active' ,`StreetName` = 'Deer Trail' ,`StreetNumber` = '907' ,`StreetSuffix` = 'Drive' ,`City` = 'San Marcos' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '1180' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming, rustic, modern 2 story Barndominium on 6 heavily wooded acres, on a paved dead-end road, just 7 miles outside San Marcos! This hidden retreat is a proven Super-host Airbnb rental. Open first floor with a 25 ft vaulted ceiling in the back half. Full bath, claw-foot tub & a big rock shower. Upstairs, the Primary bedroom is a treehouse with a vaulted rustic tin ceiling, full bath, kitchenette, & an 8\'x16\' deck overlooking a private forest. It also overlooks the back half of the first floor. Interior garden /planter from pouring 2 separate slabs. 10\'x16\' storage shed w/loft & power. Two car shed with new metal roof, water & power. 6\' metal soak tank. 13 water faucets, each with a below & above ground valve. 800 GPD Septic system. Very well insulated, with 6\" studs, R-19 paper, 1/2\" plywood & 2 sheets of R-5 sheet foam under the corrugated tin exterior. Pick your school! Property straddles over both the SMISD and the Hays County ISD. Buyer to verify school district. 26\' Travel Tra' ,`Acres` = '6.03' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'VALLEY VIEW RANCH, LOT PT OF 32, ACRES 4.43' ,`LotDesciption` = 'Cul-De-Sac,Wooded' ,`LotSize` = '192971' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '121 - Hays Consolidated' ,`SchoolElementary` = 'BLANCO VISTA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HAYS HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Barndominium' ,`Subdivision` = 'Valley View Ranch' ,`TaxAmount` = '2130' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703716' WHERE `Matrix_Unique_ID` = '209585359' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T14:33:09.777' ,`MLSNumber` = '88342418' ,`ListAgentFullName` = 'Michelle Brecker' ,`ListOfficeName` = '1Percent Lists Greater Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.779660' ,`Longitude` = '-95.771491' ,`PhotoCount` = '37' ,`PostalCode` = '77450' ,`RoomCount` = '10' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Billingford Dr' ,`StreetNumber` = '326' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1896' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 GOVERNORS PLACE SEC 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8259' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '620' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WEST MEMORIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Governors Place Sec 04' ,`TaxAmount` = '7026' ,`TaxRate` = '2.3833' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703716' WHERE `Matrix_Unique_ID` = '209868125' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T15:39:51.947' ,`MLSNumber` = '90944801' ,`ListAgentFullName` = 'Manika Sethia' ,`ListOfficeName` = 'Home Dream Solutions' ,`SellingAgentFullName` = 'James Monk' ,`SellingOfficeName` = 'J. Frank Monk Real Estate' ,`Latitude` = '29.937493' ,`Longitude` = '-96.255074' ,`PhotoCount` = '35' ,`PostalCode` = '77418' ,`RoomCount` = '8' ,`ListPrice` = '319900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Concordia B' ,`StreetNumber` = '737' ,`StreetSuffix` = 'Drive' ,`City` = 'Bellville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the paradise on earth !! Almost new ( 2019 built ), Custom and tastefully built ..as if coming right from the magazines !!Beautiful 2 Beds/ 2 Baths in the quiet city of Bellville......Away from the hustle Bustle of the city but still close to shopping and Hwy 36!!. Open Living Space ..Huge Kitchen with Granite Counter tops, Stainless steel appliances , Beautiful Island in Kitchen, Lots of natural light throughout , Huge Backyard with a Covered Patio, and 2 storage sheds outside included...The house is almost new , with custom accent walls, custom chandeliers, custom fans !!! Master Bedroom has his and her sinks and a huge walk in closet big enough to be a study !! This home is a MUST SEE !! Washer Dryer Included ..!!' ,`Acres` = '0.239' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CONCORDIA HEIGHTS LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10411' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '136 - Bellville' ,`SchoolElementary` = 'WEST END ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'BELLVILLE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Concordia Heights' ,`TaxAmount` = '3260' ,`TaxRate` = '2.1116' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663703716' WHERE `Matrix_Unique_ID` = '210494579' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T15:48:53.623' ,`MLSNumber` = '47001261' ,`ListAgentFullName` = 'John McDonald' ,`ListOfficeName` = 'Houston Home Store LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.965698' ,`Longitude` = '-95.206778' ,`PhotoCount` = '23' ,`PostalCode` = '77346' ,`RoomCount` = '5' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Great Forest' ,`StreetNumber` = '4118' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2246' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large Brick open concept home on Large lot. Remodeled Bathrooms and Laminate throughout first floors. Quiet neighborhood close to shopping and parks. Large gameroom upstairs and private study on first floor. Spacious back yard with large cemented patio. Create the perfect outdoor haven. Come and see wont last long' ,`Acres` = '0.149' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 2 ATASCOCITA FOREST SEC 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6490' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WHISPERING PINES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita Forest Sec 16' ,`TaxAmount` = '5026' ,`TaxRate` = '2.773' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703717' WHERE `Matrix_Unique_ID` = '211098155' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T15:35:09.970' ,`MLSNumber` = '61261144' ,`ListAgentFullName` = 'Manika Sethia' ,`ListOfficeName` = 'Home Dream Solutions' ,`SellingAgentFullName` = 'Constance Guillory' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.568659' ,`Longitude` = '-95.431147' ,`PhotoCount` = '46' ,`PostalCode` = '77584' ,`RoomCount` = '15' ,`ListPrice` = '499900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Starwreath' ,`StreetNumber` = '13604' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3803' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICED TO SELL !!! This home has EVERYTHING including a $17K Generator..Never Lose power again !!!Open floor plan with High Ceiling, 5 bedrooms (2 downstairs), 4.5 baths plus Study plus GAME ROOM plus MEDIA Room plus Covered Patio plus a Huge Yard for a pool & a 3 car garage home in MASTER - PLANNED community of Shadow Creek Ranch. Gorgeous Upgraded Stone & brick elevation! Tons of upgrades with Hardwood flooring throughout 1st floor, Granite counter tops and Updated light fixtures. Two story entry opens to STUDY enclosed by French doors & FORMAL DINING room. Family room has HIGH CEILINGS with WALL of WINDOWS & CAST STONE fireplace. Gourmet island kitchen with stainless steel appliances, granite countertops, stone backsplash & breakfast room. Primary room features TWO walk in closets, double sinks, garden tub & separate shower. Granite countertops in all bathrooms. Covered patio in backyard with ceiling fan, perfect for family gatherings!!' ,`Acres` = '0.1848' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-49 PARTIAL REPLAT NO 1, BLOCK 2, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf-49 Pt Rep 1' ,`TaxAmount` = '12081' ,`TaxRate` = '3.2123' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703717' WHERE `Matrix_Unique_ID` = '211170081' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T15:55:34.877' ,`MLSNumber` = '72050333' ,`ListAgentFullName` = 'Reecie Meeker' ,`ListOfficeName` = 'Cobb Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.440833' ,`Longitude` = '-94.666551' ,`PhotoCount` = '42' ,`PostalCode` = '77650' ,`RoomCount` = '5' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Jacks' ,`StreetNumber` = '975' ,`StreetSuffix` = 'Road' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Super cute like new 3/2 home on 2 lots in the heart of Crystal Beach. You will be impressed with the spacious feel and the amount of light in the house. A huge vaulted ceiling in the living/kitchen add to the open feel. The kitchen features granite counters with stainless appliance. The whole family will be able to gather around the breakfast bar with seating for 6. The master has an oversized closet, bath with double sinks and granite counters. Nice sized guest room and also a bunkroom for the kids. Fenced for your furry family members, and a cargo lift for heavy loads. Walk straight down the road to the beach. Never been a vacation rental. RV hookup is included for your overflow guests. Come see this little piece of paradise today.' ,`Acres` = '0.084' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 179 J SHAW SUR TR 204-3, AKA TR 5 UNREC SUB ACRES 0.084' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3659' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'J & S Beach Add #2' ,`TaxAmount` = '4661' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703717' WHERE `Matrix_Unique_ID` = '211732780' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T14:58:48.610' ,`MLSNumber` = '85226303' ,`ListAgentFullName` = 'Maria DeLeon' ,`ListOfficeName` = 'Texas Xpert Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.884221' ,`Longitude` = '-95.477684' ,`PhotoCount` = '46' ,`PostalCode` = '77088' ,`RoomCount` = '3' ,`ListPrice` = '321000.00' ,`Status` = 'Active' ,`StreetName` = 'Green Lawn' ,`StreetNumber` = '8018' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home!!! beautiful home located in Inwood Forest Subdivision, Livingroom has a beautiful view to the pool Master bedroom is downstairs with sliding doors to the pool. 2 bedroom upstairs, studio room by the kitchen can also be converted to a bedroom. Home has granite counter tops throughout, Kitchen with Island with cook top, the garage has been converted to an apartment with its own back door entrance.\r\nAC is 1 year old and has 4 more years warranty. Quiet neighborhood and close to shopping centers and schools.' ,`Acres` = '0.2089' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 12 INWOOD FOREST SEC 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'SMITH ACADEMY' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'HOFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Inwood Forest Sec 12' ,`TaxAmount` = '6374' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703717' WHERE `Matrix_Unique_ID` = '211839832' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T15:46:59.450' ,`MLSNumber` = '44626433' ,`ListAgentFullName` = 'Cyndie Miller' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.202090' ,`Longitude` = '-95.435344' ,`PhotoCount` = '37' ,`PostalCode` = '77385' ,`RoomCount` = '6' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Spindle Oaks' ,`StreetNumber` = '17135' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1834' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.5165' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S916002 - TALL TIMBERS 02, LOT 110-B' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '22500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '108' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tall Timbers 02' ,`TaxAmount` = '2872' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703717' WHERE `Matrix_Unique_ID` = '211877517' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T14:19:50.403' ,`MLSNumber` = '85324305' ,`ListAgentFullName` = 'Brian Pruett' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.721592' ,`Longitude` = '-95.447383' ,`PhotoCount` = '12' ,`PostalCode` = '77005' ,`RoomCount` = '2' ,`ListPrice` = '539500.00' ,`Status` = 'Active' ,`StreetName` = 'Community' ,`StreetNumber` = '5600' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '870' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DID NOT FLOOD! HOME TENANT OCCUPIED-DO NOT DISTURB, PRICED AT LOT VALUE, RENTABLE 2-1-1, NEWER A/C, SELF LEVELING 1 INCH TRAVERTINE STONE FLOORS HAVE REPLACED WOOD FLOORS.....HIGHLY SOUGHT AFTER WEST U LOCATION, GREAT SCHOOLS, ON LARGER 5800 SQ FT LOT, NO REAR NEIGHBORS -BACKS UP TO RR TRACKS-NO HORN NO BLOW ZONE, HOME/LOT NEXT DOOR TO SOUTH IS EXTRA WIDE/75 FT WIDE, NEAR PARKS, TENNIS COURTS, EXCELLENT WEST U schools, shopping, CITY sports/pool/rec center, MED Center, LOWEST PRICED WEST U LOT ON $/SQ FT BASIS! TENANTS HAVE DONE SOME REMODELING SO PICTURES WILL NOT BE EXACTLY WHAT IS IN PLACE TODAY.' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 & TR 22A BLK 1 COLLEGE COURT PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'COLLEGE COURT PLACE' ,`TaxAmount` = '7799' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1946' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703717' WHERE `Matrix_Unique_ID` = '211895507' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T15:52:57.383' ,`MLSNumber` = '26515778' ,`ListAgentFullName` = 'Willian Garcia Mejia' ,`ListOfficeName` = 'Riverbend Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.421334' ,`Longitude` = '-95.032121' ,`PhotoCount` = '4' ,`PostalCode` = '77591' ,`RoomCount` = '3' ,`ListPrice` = '303990.00' ,`Status` = 'Active' ,`StreetName` = 'Chadwick Rd' ,`StreetNumber` = '4307' ,`StreetSuffix` = '' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1988' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to you New HOME built by Cyrene Homes! In Section 2 of Cobblestone Subdivision, High ceilings with open floorplan will greet you as you enter this beautiful home! Kitchen is donned with a wonderful breakfast bar along with an \"eat-in\" area which then opens to the living area. The island includes plenty of seating and is perfect for entertaining or those grab and go mornings! Granite counter-tops, Stainless steel appliances are only a few things that make this home sparkle! All finishes and colors allow for soothing home feel that make you want to say, \"AAAHHHH\"...I\'m home! See our standard feature list for more details! We also have other floor plans available to build.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Cyrene Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'cobblestone lot 39 Blk 0' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cobblestone' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703717' WHERE `Matrix_Unique_ID` = '211898311' --> Updated record success