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-08-09T15:06:37.613' ,`MLSNumber` = '52142455' ,`ListAgentFullName` = 'Gerald Womack' ,`ListOfficeName` = 'Womack Development' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.723646' ,`Longitude` = '-95.379526' ,`PhotoCount` = '50' ,`PostalCode` = '77004' ,`RoomCount` = '8' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Southmore' ,`StreetNumber` = '1814' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '2032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the heart of the Museum District, this property is situated on a lot of more than 11,000 square feet. The property currently is configured for two units but was originally a single family house. There are endless possibilities with this property whether it be converting to an office, back to a single family residence, short term rentals or tearing down and building new construction. The location of this property is unmatched and is within walking distance to The Ion, Rice Universities Innovation Hub. Midtown, Downtown, the Texas Medical Center as well as all the major universities are a short distance away. Property is being sold as-is.' ,`Acres` = '0.2583' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 & TRS 13A & 15A BLK 6 SOUTHMORE 116' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southmore 116' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696319' WHERE `Matrix_Unique_ID` = '207252908'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T14:55:24.493' ,`MLSNumber` = '82660694' ,`ListAgentFullName` = 'Justin Guyer' ,`ListOfficeName` = 'RE/MAX Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.732124' ,`Longitude` = '-96.422149' ,`PhotoCount` = '50' ,`PostalCode` = '77465' ,`RoomCount` = '2' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayshore' ,`StreetNumber` = '135' ,`StreetSuffix` = 'Drive' ,`City` = 'Palacios' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Outstanding and well-maintained home in the gated Cape Carancahua Community. This home is ready for you to enjoy as-is or add your touches of modernity and style. The upstairs has living, kitchen, bedroom and bathroom while downstairs you\'ll find the second bed and bath separate from the utility/laundry room. The large garage adds parking and additional storage. There is a fully fenced side yard and hurricane fencing around the remainder of the property. Coastal ambiance and proximity to fishing and boating give this home high marks, especially with the abundance of features offered by the community. Amenities include: Boat Ramp, Lighted Fishing Piers, Covered Pavilion, Restrooms, Tennis Court, Playground, 2 Pools and relaxed atmosphere.' ,`Acres` = '0.32' ,`Area` = '67' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CAPE CARANCAHUA #4, LOT 1535-1536, ACRES 0.32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13939' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '156 - Palacios' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (PALACIOS)' ,`SchoolHigh` = 'PALACIOS HIGH SCHOOL' ,`SchoolMiddle` = 'PALACIOS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Left Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cape Carancahua 04' ,`TaxAmount` = '1571' ,`TaxRate` = '1.8978' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696319' WHERE `Matrix_Unique_ID` = '207633998'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T14:48:56.003' ,`MLSNumber` = '80686046' ,`ListAgentFullName` = 'Velma Ellison' ,`ListOfficeName` = 'Alliance Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.962397' ,`Longitude` = '-95.017595' ,`PhotoCount` = '39' ,`PostalCode` = '77532' ,`RoomCount` = '5' ,`ListPrice` = '383040.00' ,`Status` = 'Active' ,`StreetName` = 'Lord' ,`StreetNumber` = '4305' ,`StreetSuffix` = 'Road' ,`City` = 'Crosby' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '876' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently refurbished cute farm house on 4.38 acres. Mature trees provide much needed shade. New appliances. Granite countertops and tile backsplashes. Modern cabinets. Laminate flooring throughout. New energy effecient windows. Small but cozy. You will fall in love with the land.' ,`Acres` = '4.39' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 2D & 2G ABST 1336 HT&BRR CO SEC 4' ,`LotDesciption` = 'Corner,Wooded' ,`LotSize` = '191228' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'BARRETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'H & T C Rr Co Sec 4 Blk 4' ,`TaxAmount` = '6067' ,`TaxRate` = '2.0943' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696320' WHERE `Matrix_Unique_ID` = '208118046'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T14:52:09.657' ,`MLSNumber` = '54897346' ,`ListAgentFullName` = 'Bonnie Collins' ,`ListOfficeName` = 'Bonnie Collins Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.023479' ,`Longitude` = '-95.619210' ,`PhotoCount` = '36' ,`PostalCode` = '77377' ,`RoomCount` = '9' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Imperial Crossing' ,`StreetNumber` = '12618' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2686' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two-story home on a cul-de-sac street in Village Creek! This home features four bedrooms, three full bathrooms, a half bathroom, formal dining room, upstairs game room, and LARGE back yard! The kitchen has stainless steel appliances and a gas range. The kitchen opens to the breakfast nook and family room which has a cozy fireplace and high ceilings. The primary bedroom has an ensuite bathroom with a jetted tub, walk in shower, double sink, vanity area, and a walk-in closet. Upstairs there is a game room and three additional bedrooms with two full bathrooms. The backyard has many trees and is spacious with a play set. Village Creek has a community pond with a walking trail, parks, a basketball court, splashpad, and a pool. Convenient location and zoned to Tomball ISD.' ,`Acres` = '0.2308' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 1 VILLAGE CREEK SEC 13' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10052' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '795' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'WILLOW CREEK ELEMENTARY SCHOOL (TOMBALL)' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Creek' ,`TaxAmount` = '8734' ,`TaxRate` = '3.0164' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696320' WHERE `Matrix_Unique_ID` = '208485958'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T15:42:34.717' ,`MLSNumber` = '28089319' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.032495' ,`Longitude` = '-95.386315' ,`PhotoCount` = '27' ,`PostalCode` = '77073' ,`RoomCount` = '6' ,`ListPrice` = '254900.00' ,`Status` = 'Active' ,`StreetName` = 'Westfield Ridge' ,`StreetNumber` = '21902' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1705' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1111' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 5 CYPRESS TERRACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4840' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '308' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'OGDEN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Terrace Sec 1' ,`TaxAmount` = '4961' ,`TaxRate` = '2.9808' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696320' WHERE `Matrix_Unique_ID` = '208898330'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T14:16:16.267' ,`MLSNumber` = '86260891' ,`ListAgentFullName` = 'Robin Landua' ,`ListOfficeName` = 'BHGRE Hometown' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.210895' ,`Longitude` = '-96.420923' ,`PhotoCount` = '24' ,`PostalCode` = '77833' ,`RoomCount` = '3' ,`ListPrice` = '309500.00' ,`Status` = 'Active' ,`StreetName` = 'Possum Trot' ,`StreetNumber` = '3004' ,`StreetSuffix` = 'Street' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedroom, 2 bath brick home on a half acre lot in desirable Oak Hill Acres. Inside you will find a large living room with wood burning fireplace, lighted built in display cabinet, and sliding glass doors out to the covered patio. The living room is open to the dining room and kitchen that has a breakfast nook, tons of cabinet space, bar and bar sink. On the opposite side of the house are two guest bedrooms, hall bath, and primary bedroom with attached bath and large walk in closet. The entire interior of the house has recently been painted and brand new laminate flooring in the living, kitchen and dining room and new carpet in the bedrooms. Outside there is a fenced back yard and beautiful live oak trees.' ,`Acres` = '0.5008' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'OAK HILL ACRES SEC III , LOT 75' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '21813' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Oak Hill Acres' ,`TaxAmount` = '3409' ,`TaxRate` = '1.9088' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696320' WHERE `Matrix_Unique_ID` = '208906168'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T14:08:14.320' ,`MLSNumber` = '69026874' ,`ListAgentFullName` = 'Marina Boyce' ,`ListOfficeName` = 'Lady In The Hat' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.001293' ,`Longitude` = '-95.934432' ,`PhotoCount` = '41' ,`PostalCode` = '77484' ,`RoomCount` = '5' ,`ListPrice` = '398000.00' ,`Status` = 'Active' ,`StreetName` = 'Sandtrap' ,`StreetNumber` = '15639' ,`StreetSuffix` = 'Drive' ,`City` = 'Waller' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2197' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Golf Course neighborhood in the Sky Lakes Subdivision that has its own airport and is the home of \"Skydive Houston\". House sits on the cul-de-sac with open woods behind the house. House has an attached 3 door garage with an additional air-conditioned workshop. There are 3 bedrooms and 2.1 baths, large kitchen and separated dining area, vaulted ceilings in the living room and wood burning fireplace. House has its own well, water softer system, completely re-pipped with flex pipes and a 20-year transferrable warranty. No damage during the freeze and never flooded per seller. House is backing to an 80-acre golf course that is currently closed down and will be re-opened some time in the future. Relaxed and peaceful living with all conveniences.' ,`Acres` = '0.7451' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S778200 SKY LAKES 2 BLK 3 LOT 61 & 62' ,`LotDesciption` = 'Corner' ,`LotSize` = '32457' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '140' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'H T JONES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sky Lakes 2' ,`TaxAmount` = '5670' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696320' WHERE `Matrix_Unique_ID` = '208928639'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T14:25:38.100' ,`MLSNumber` = '70337827' ,`ListAgentFullName` = 'Susan Bolz' ,`ListOfficeName` = 'Weichert,REALTORS-Murray Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.679382' ,`Longitude` = '-95.472186' ,`PhotoCount` = '13' ,`PostalCode` = '77096' ,`RoomCount` = '4' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Ferris' ,`StreetNumber` = '9010' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2435' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Opportunity to build in prime Meyerland location. Beautiful spacious lot (over 10,000 SF) with mature trees. House is not in livable condition but can be viewed at buyer\'s risk. Zoned to exemplary Bellaire High school, Meyerland Middle school, and Lovett Elementary. Numerous new construction homes nearby. Walk to Lovett and Meyers Park. Close to Loop 610 and Meyerland plaza. Short commute to Texas Medical Center, Galleria, Greenway, and Downtown.\r\n.' ,`Acres` = '0.2354' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 43 MEYERLAND SEC 6A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10256' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meyerland Sec 06a' ,`TaxAmount` = '6793' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696320' WHERE `Matrix_Unique_ID` = '209260174'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T14:46:06.610' ,`MLSNumber` = '97611905' ,`ListAgentFullName` = 'Ryan Kutter' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.428407' ,`Longitude` = '-95.630787' ,`PhotoCount` = '38' ,`PostalCode` = '77356' ,`RoomCount` = '6' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Wick Willow' ,`StreetNumber` = '51' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2002' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous new home seated in the highly desirable Golf Course Community of Bentwater.  The expansive open floor plan allows for a relaxed lifestyle and easy entertaining. Meal prep will be a breeze with Quartz counters, Stainless Steel appliances, a breakfast bar, a tiled backsplash, and lots of storage. The living room is complete with a sleek gas log fireplace and natural light filtering in from two sides. The spacious primary retreat offers a luxurious ensuite bath with dual sinks, lots of counter space, a large, walk-in double shower, and a generous walk-in closet. Secondary bedrooms are well-appointed. You will enjoy peaceful moments while relaxing on the covered patio overlooking a spacious backyard. With a minimum social membership, you will gain access to Bentwater Yacht & Country Club, where you will enjoy resort-style living with three 18-hole championship golf courses, yacht club, fitness center, spa, tennis, and more. 24-HOUR MANNED COMMUNITY GATE. Book your showing today!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Bali Real Estate Dev' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 09 BLOCK 2 LOT 7' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '8052' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696320' WHERE `Matrix_Unique_ID` = '209536792'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T15:41:00.280' ,`MLSNumber` = '13361034' ,`ListAgentFullName` = 'Donna Pinon' ,`ListOfficeName` = 'White Ivy Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.710758' ,`Longitude` = '-95.558371' ,`PhotoCount` = '29' ,`PostalCode` = '77340' ,`RoomCount` = '7' ,`ListPrice` = '229000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue Q' ,`StreetNumber` = '2117' ,`StreetSuffix` = '' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1823' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Huntsville Location!!   Located in the lovely and historic Avenues area of Huntsville, you\'ll enjoy the convenience of this centrally located property.   Only a short drive to shopping, dining, entertainment, and major area employers.   Enter this home and you\'ll fall in love with the original wood flooring and other vintage details that have been preserved.   Three spacious bedrooms PLUS a separate study.   The large eat-in kitchen offers island work space.  The large back yard and patio means you\'ll have plenty of space for outdoor activities or just relaxing.' ,`Acres` = '0.368' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'HIGHLAND - SEC 1, BLOCK 5, LOT 3, ACRES .368' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16030' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SCOTT JOHNSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Highland - Sec 1' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696320' WHERE `Matrix_Unique_ID` = '210008799'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T14:02:12.580' ,`MLSNumber` = '37681042' ,`ListAgentFullName` = 'Bannesa Mota' ,`ListOfficeName` = 'Dream Home Realty' ,`SellingAgentFullName` = 'Elsa Cordovi Llanuza' ,`SellingOfficeName` = 'Lugary, LLC' ,`Latitude` = '29.636742' ,`Longitude` = '-95.511689' ,`PhotoCount` = '26' ,`PostalCode` = '77071' ,`RoomCount` = '3' ,`ListPrice` = '265000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Royan' ,`StreetNumber` = '7738' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This two story house has what you need to call it home! Living room is spacious with gas fireplace open floor plan into the dining area and half bath downstairs for your guests. Large kitchen with tons of counter-space, all of the appliances are stainless steel and granite countertops. There’s also a breakfast area for Sunday Brunch. The backyard is spacious and also has a few fruit trees. June plum, Pomegranate, Pear and Apple tree. The upstairs has a separate living space, utility room and all 3 bedrooms. Master bedroom is spacious can fit an entire king size bedroom set and still have lots of space. Master restroom has double sink with large mirror, shower with glass door, whirlpool tub, and a walk-in closet. Flooring all through the house was done in 2010. Two car garage attached to home with driveway for extra parking. Home is not located in flood zone and has never flooded, no damage during winter storm.' ,`Acres` = '0.1194' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 65 BLK 7 FONMEADOW SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GROSS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fonmeadow Sec 03 Pt Rep' ,`TaxAmount` = '5050' ,`TaxRate` = '2.8249' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696321' WHERE `Matrix_Unique_ID` = '210283178'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T14:42:40.337' ,`MLSNumber` = '33223979' ,`ListAgentFullName` = 'Aaron Tschoepe' ,`ListOfficeName` = 'Bernstein Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.675861' ,`Longitude` = '-95.441548' ,`PhotoCount` = '15' ,`PostalCode` = '77025' ,`RoomCount` = '9' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Osby' ,`StreetNumber` = '4029' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1608' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Currently tenant occupied until September 30, 2023.  Light and Bright home located 10 minutes from the Medical Center and 15 minutes from Downtown Houston. Zoned to Bellaire High School and Pershing Middle School. Home has been recently renovated with new paint, Vinyl Flooring and Tile throughout. Complete with open concept, Chef\'s style kitchen. Primary bedroom is connected to an extra flex space room, perfect for your home office or private sitting room. Back yard is large with privacy fence and pet friendly.  Main bathroom has double sinks and brand new tub and tile surround. Westwood neighborhood is quiet and has easy access to 610.' ,`Acres` = '0.1653' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 749 BLK 33 WESTWOOD SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8600' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHEARN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Westwood' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696321' WHERE `Matrix_Unique_ID` = '210988164'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T15:47:36.087' ,`MLSNumber` = '44719218' ,`ListAgentFullName` = 'Raul Gonzalez' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.442880' ,`Longitude` = '-95.458201' ,`PhotoCount` = '14' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '303000.00' ,`Status` = 'Active' ,`StreetName` = 'Garnet Grove' ,`StreetNumber` = '9607' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1879' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious home in a gated community and with 24 hour guard. Kitchen features granite counter tops with a nice size dining nook. Primary bathroom has a double sink, separate Tub and Shower and over sized walk in closet.  Community amenities include a beautiful walking trail on a lake, splash pad, 2 pools, tennis court, basketball court and elementary school conveniently located in the neighborhood.' ,`Acres` = '0.2084' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'STERLING LAKES WEST SEC 3 (A0714 WM PATTUS) BLK 2 LOT 32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9078' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Lakes West Sec 3 A07' ,`TaxAmount` = '7585' ,`TaxRate` = '3.4099' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696321' WHERE `Matrix_Unique_ID` = '211220744'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T15:13:17.510' ,`MLSNumber` = '60842249' ,`ListAgentFullName` = 'Jesse Burton' ,`ListOfficeName` = 'Get Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.777798' ,`Longitude` = '-95.352306' ,`PhotoCount` = '7' ,`PostalCode` = '77009' ,`RoomCount` = '3' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Mckee' ,`StreetNumber` = '1809' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1382' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to renovate or build. Current home sits on 2 lots and can be subdivided. This property is literally minutes away from Minute Maid Park, Downtown Houston, and the new development East River in EaDo (East Downtown) is now under construction with a new HEB being one of the anchor stores. Don\'t miss the chance on this great opportunity to invest.' ,`Acres` = '0.1067' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 7 & 8 BLK 10 CASCARA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHERMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cascara' ,`TaxAmount` = '3314' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1925' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696321' WHERE `Matrix_Unique_ID` = '211223576'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T15:07:03.527' ,`MLSNumber` = '57968235' ,`ListAgentFullName` = 'Dustin Erwin' ,`ListOfficeName` = 'Vista Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.773225' ,`Longitude` = '-98.074845' ,`PhotoCount` = '44' ,`PostalCode` = '78132' ,`RoomCount` = '8' ,`ListPrice` = '462000.00' ,`Status` = 'Active' ,`StreetName` = 'Timberwood' ,`StreetNumber` = '1349' ,`StreetSuffix` = 'Trail' ,`City` = 'New Braunfels' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1855' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Private country living at it\'s best with NO HOA and just minutes from Gruene, shopping, restaurants, I35, Canyon Lake and downtown New Braunfels! OUTSIDE THE CITY LIMITS = LOWER TAXES = LOWER PAYMENTS!!! You\'ll love the privacy of this huge backyard while cooling off in the pool underneath the mature oak trees or enjoy cooking family meals in the chef\'s kitchen with more counter space than you could ask for.' ,`Acres` = '0.492' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'COUNTRY HILLS 1, LOT 12' ,`LotDesciption` = 'Wooded' ,`LotSize` = '21432' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '141 - Comal' ,`SchoolElementary` = 'HOFFMANN LANE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CANYON HIGH SCHOOL (COMAL)' ,`SchoolMiddle` = 'CHURCH HILL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Hills 1' ,`TaxAmount` = '4737' ,`TaxRate` = '1.7138' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696321' WHERE `Matrix_Unique_ID` = '211224575'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-09T15:29:48.623' ,`MLSNumber` = '17363294' ,`ListAgentFullName` = 'Dustin Erwin' ,`ListOfficeName` = 'Vista Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750836' ,`Longitude` = '-98.067725' ,`PhotoCount` = '27' ,`PostalCode` = '78130' ,`RoomCount` = '7' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Starling' ,`StreetNumber` = '403' ,`StreetSuffix` = 'Creek' ,`City` = 'New Braunfels' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1619' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully maintained home in a great neighborhood with easy access to I35, shopping, Gruene and downtown New Braunfels. This home boasts brand new engineered hardwood flooring in all bedrooms, fresh paint and new fixtures. No neighbors directly behind the house! This is a stunning home and is move in ready!!' ,`Acres` = '0.157' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'QUAIL VALLEY 1, BLOCK C, LOT 46' ,`LotDesciption` = 'Other' ,`LotSize` = '6839' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '141 - Comal' ,`SchoolElementary` = 'OAK CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CANYON HIGH SCHOOL (COMAL)' ,`SchoolMiddle` = 'CANYON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Quail Valley 1' ,`TaxAmount` = '5577' ,`TaxRate` = '2.1209' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696321' WHERE `Matrix_Unique_ID` = '211225810'  --> Updated record success<br />