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-27T12:15:32.077' ,`MLSNumber` = '68283526' ,`ListAgentFullName` = 'Caroline Bean' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766783' ,`Longitude` = '-95.502299' ,`PhotoCount` = '32' ,`PostalCode` = '77024' ,`RoomCount` = '13' ,`ListPrice` = '5995000.00' ,`Status` = 'Active' ,`StreetName` = 'Timberglen' ,`StreetNumber` = '10803' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '7530' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous new construction by Build 48 in Hunter\'s Creek area. This expansive home of 7,530 SF sits on a 29,750 SQFT cul-de-sac lot and features 5 bed, 5 bath plus 2 half baths. First floor primary bedroom suite with coffee bar, large walk-in closet, en-suit bathroom with double vanities, dual water closets, soaking tub and shower. Other home features include study, mud room, wine room, 3-car garage, second floor game room and much more.' ,`Acres` = '' ,`Area` = '23' ,`BuilderName` = 'BUILD 48' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 TIMBERGLEN SEC 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '29750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEMORIAL DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Timberglen' ,`TaxAmount` = '35487' ,`TaxRate` = '2.1325' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703683' WHERE `Matrix_Unique_ID` = '206885997' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T12:46:43.397' ,`MLSNumber` = '71366802' ,`ListAgentFullName` = 'Grace Harris' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.318497' ,`Longitude` = '-95.337915' ,`PhotoCount` = '22' ,`PostalCode` = '77306' ,`RoomCount` = '10' ,`ListPrice` = '315990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Kamilia' ,`StreetNumber` = '14108' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1893' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 2 story with open floor plan and high ceilings. 4 bedrooms, 2.5 baths and 2 car garage. Beautiful kitchen w/42\" upper cabinets, designer tile backsplash, granite counters and large serving bar overlooking an oversized family room. Breakfast is big enough for a table for 8! Primary suite is upstairs and offers his and her vanities, separate garden tub and shower. Vinyl wood plank downstairs, carpet in bedrooms! Home includes a covered patio, wrought iron spindles, slate appliances, a fenced backyard and so much more! Sought after Conroe ISD schools with super low tax rate! Builder closeout won\'t last long!' ,`Acres` = '0.118916' ,`Area` = '40' ,`BuilderName` = 'KENDALL HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S944804 - Waukegan Way 04, BLOCK 1, Lot 54' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5180' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'CREIGHTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Waukegan Way' ,`TaxAmount` = '' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703683' WHERE `Matrix_Unique_ID` = '207059877' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T13:38:51.447' ,`MLSNumber` = '64192133' ,`ListAgentFullName` = 'Alice Ellisor' ,`ListOfficeName` = 'Alice Ellisor Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.860507' ,`Longitude` = '-95.443405' ,`PhotoCount` = '18' ,`PostalCode` = '77320' ,`RoomCount` = '6' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Fisherman\'s Trail' ,`StreetNumber` = '221' ,`StreetSuffix` = '' ,`City` = 'Huntsville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '864' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is built on Stilts so flooding from Harmon Creek should never be an issue. Home has had many updates in the last few years including Foam Insulation under deck of homes, new roof, replaced stairs, wonderful screened in porch 18.6\'X9.6\' overlooking creek, new interior and exterior paint, new plumbing, new vinyl in kitchen and bath, and 30 amp breaker for guests with RV\'s. Home is ready for new family to come enjoy the week-ends and summer vacations fishing in Harmon Creek which is known for it\'s white bass runs. Harmon Creek Marina is close by so if you have extended family they can stay in camp ground or there are small cabins available for rentals.' ,`Acres` = '' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Riverside (Walker)' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 135, Sec. 1, Harmon Creek Ridge' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'HUNTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harmon Creek Ridge' ,`TaxAmount` = '1603' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703684' WHERE `Matrix_Unique_ID` = '208018166' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T13:11:05.323' ,`MLSNumber` = '78165609' ,`ListAgentFullName` = 'Melody Moore' ,`ListOfficeName` = 'Coldwell Banker Southern Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.700162' ,`Longitude` = '-95.003259' ,`PhotoCount` = '20' ,`PostalCode` = '77351' ,`RoomCount` = '6' ,`ListPrice` = '129000.00' ,`Status` = 'Active' ,`StreetName` = 'Royal' ,`StreetNumber` = '142' ,`StreetSuffix` = 'Road' ,`City` = 'Livingston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a property close to the lake? Look no further! Enjoy a little over a 1/2 acre of unrestricted land NO HOA, near Beacon Bay Marina, Lake Livingston State Park, Livingston Municipal Airport, shopping, plus restaurants, and much much more. 15-20 minutes from Naskila Gaming. Great opportunity for a weekend retreat or make it an Airbnb - Awesome Country Living.' ,`Acres` = '0.5268595041' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GREEN ACRES LOT 141' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '22950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Green Acres' ,`TaxAmount` = '20' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Aerobic,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703684' WHERE `Matrix_Unique_ID` = '208388575' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T13:10:53.560' ,`MLSNumber` = '49037750' ,`ListAgentFullName` = 'Jose Rueda' ,`ListOfficeName` = 'Southern Star Realty' ,`SellingAgentFullName` = 'Dwight Downing' ,`SellingOfficeName` = 'Top Guns Realty on Lake Conroe' ,`Latitude` = '30.182640' ,`Longitude` = '-95.750046' ,`PhotoCount` = '31' ,`PostalCode` = '77355' ,`RoomCount` = '10' ,`ListPrice` = '319900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sapling Oaks' ,`StreetNumber` = '30106' ,`StreetSuffix` = 'Place' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2571' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Excellent location placed on the inside-curve of the cul-de-sac, includes ample backyard space that backs up to the retention pond (with a fence gate for ez access). Yard is perfect for entertaining guests and for kids to run free. Floor plan features four large rooms, 3 full bathrooms, and 1 half bathroom. Master bathroom includes a large soaking tub, separate standing shower, and double vanity sink. Kitchen features granite counter tops, wood finish cabinetry, stainless steel appliances, and corner walk-in pantry. Property includes separate study room which features a French glass double door opening. Staircase railing is comprised of wrought iron spindles to project class and elegance. \r\nGlen Oaks subdivision, offers many amazing amenities, including but not limited to park, dog park, pool, and workout facility. \r\nMake this beautiful house your new home.' ,`Acres` = '0.1655' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S532202 - GLEN OAKS 02, BLOCK 3, LOT 16' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '7209' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'NICHOLS SAWMILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glen Oaks 02' ,`TaxAmount` = '6503' ,`TaxRate` = '2.8087' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703684' WHERE `Matrix_Unique_ID` = '208759853' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T12:38:30.013' ,`MLSNumber` = '88344968' ,`ListAgentFullName` = 'Anthony Cook' ,`ListOfficeName` = 'Grand Monarch Management LP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.426600' ,`Longitude` = '-95.579210' ,`PhotoCount` = '27' ,`PostalCode` = '77318' ,`RoomCount` = '9' ,`ListPrice` = '338500.00' ,`Status` = 'Active' ,`StreetName` = 'Antares' ,`StreetNumber` = '12637' ,`StreetSuffix` = '' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2155' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful one story, split bedroom plan in a guard gated community. New roof May 2022, new carpet June 2022, High ceilings, built in cabinets and shelves. Island kitchen. Open and bright home. Large master suite, Ceiling fans throughout home. Large back yard with nice deck. Sprinkler system. Lakefront subdivision with area pool, lighted tennis courts, picnic areas, marina and much more!!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'POINT AQUARIUS 06, BLOCK 6, LOT 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9319' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Point Aquarius 06' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703684' WHERE `Matrix_Unique_ID` = '209106302' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T13:42:17.890' ,`MLSNumber` = '4409831' ,`ListAgentFullName` = 'Bobby De La Rosa' ,`ListOfficeName` = 'DLR Properties, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.810239' ,`Longitude` = '-95.195987' ,`PhotoCount` = '19' ,`PostalCode` = '77049' ,`RoomCount` = '4' ,`ListPrice` = '165000.00' ,`Status` = 'Active' ,`StreetName` = 'Gorman' ,`StreetNumber` = '5914' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1337' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1708' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 56 BLK 9 PINE TRAILS SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'PURPLE SAGE ELEMENTARY SCHOOL (GALENA PARK)' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'CUNNINGHAM MIDDLE SCHOOL (GALENA PARK)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Trails Sec 01' ,`TaxAmount` = '2345' ,`TaxRate` = '2.2994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703684' WHERE `Matrix_Unique_ID` = '209868986' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T13:25:22.190' ,`MLSNumber` = '32406611' ,`ListAgentFullName` = 'Jimmy Simien' ,`ListOfficeName` = 'Simien Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.561477' ,`Longitude` = '-95.107831' ,`PhotoCount` = '22' ,`PostalCode` = '77058' ,`RoomCount` = '5' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Doverwood' ,`StreetNumber` = '16818' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1256' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHARMING 2 BED 2 BATH HOME ON BEAUTIFUL CORNER LOT IN UNIVERSITY GREEN. HOME FEATURES RECENT PAINT THROUGHOUT. SPLIT PLAN WITH 2 LARGE PRIMARY BEDROOMS. OPEN KITCHEN OVERLOOKS THE LIVING AREA. BACKYARD OAISIS WITH CUSTOM DECK AND BEAUTIFUL LUSH LANDSCAPING THROUGHOUT. 2022 NEW A/C CONDENSER AND 2022 NEW ROOF! QUICK ACCESS TO BAY AREA BLVD. NEARBY SHOPPING AND DINING AT BAYBROOK MALL! CALL TO SCHEDULE YOUR PERSONAL SHOWING TODAY!' ,`Acres` = '0.155' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 50 BLK 3 UNIVERSITY GREEN SEC 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FALCON PASS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'University Green' ,`TaxAmount` = '4978' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703684' WHERE `Matrix_Unique_ID` = '209874277' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T13:49:41.650' ,`MLSNumber` = '41682473' ,`ListAgentFullName` = 'Raymond Jones' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014259' ,`Longitude` = '-95.515667' ,`PhotoCount` = '29' ,`PostalCode` = '77379' ,`RoomCount` = '10' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Southampton' ,`StreetNumber` = '16219' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2659' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated home (2017) in the Excellent Klein ISD. Dream Kitchen has dual pantry\'s and beautiful granite countertops with a glass tile backsplash and SS appliances. Pendent and recessed lighting set it all off. Huge corner lot. They have added new windows and Radiant barrier with added insulation in the attic, AC, blinds and toilets were all done in 2019 and a new garage door opener in 2021. Over sized 2 car garage. All you need to do here is add your furniture and you are home. A very gently lived in home. Large living areas & HUGE master suite with dual closets!. Wine bar, open kitchen you\'ll always be in the action. Entire interior has been updated. Beautiful dark wood flooring in living area & tile floors in wet areas and carpet upstairs. Beautiful crown molding in the formal dining and living rooms as well as the master bedroom. Slate tiles on the entry porch. House did not flood during Harvey. Rec center, pool, tennis courts, trails, children\'s playground close by. Hurry' ,`Acres` = '0.2139' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 2 WIMBLEDON ESTS & RACQ CL SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '9316' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '655' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MITTELSTADT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Spanish' ,`Subdivision` = 'Wimbledon Estates & Racq Cl' ,`TaxAmount` = '4415' ,`TaxRate` = '2.1875' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703684' WHERE `Matrix_Unique_ID` = '210324610' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T13:42:37.810' ,`MLSNumber` = '17713112' ,`ListAgentFullName` = 'Laura Montalvo' ,`ListOfficeName` = 'RE/MAX Pearland' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.568150' ,`Longitude` = '-95.393967' ,`PhotoCount` = '17' ,`PostalCode` = '77584' ,`RoomCount` = '10' ,`ListPrice` = '345500.00' ,`Status` = 'Active' ,`StreetName` = 'Quiet Bay' ,`StreetNumber` = '2308' ,`StreetSuffix` = 'Street' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2149' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely 1 Story Home featuring 3 Bedroom, 2 Full Bath, with Study and 2 Attached Car Garage in Shadow Creek Ranch Community! Beautiful chandeliers at the foyer entrance and in the formal dining room. Open Concept! Kitchen w/ Breakfast Bar. Elegant tile flooring through out family room and formal dinning areas; no carpet anywhere in the house! Large Master Bedroom with walk-in closet and en-suite restroom with double sinks and garden tub! Spacious backyard with storage shed! Minutes from Pearland Town Center, Medical Center, University of Houston, Shopping, and Dining. Quick and easy access to Beltway 8 and Hwy 288! Schedule your tour TODAY!' ,`Acres` = '0.1584' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-9A (PEARLAND) BLK 2 LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MAREK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'NOLAN RYAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf-9a Pear' ,`TaxAmount` = '6644' ,`TaxRate` = '2.9209' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703684' WHERE `Matrix_Unique_ID` = '210424133' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T13:40:16.290' ,`MLSNumber` = '27841814' ,`ListAgentFullName` = 'Daniel Sanchez' ,`ListOfficeName` = 'Engel & Volkers Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.678774' ,`Longitude` = '-95.276943' ,`PhotoCount` = '16' ,`PostalCode` = '77061' ,`RoomCount` = '6' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Glen Dell' ,`StreetNumber` = '7903' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2285' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Priced to Sell. 1/2 Acre lot (27,858 SQFT). Glenbrook Valley (HISTORIC DISTRICT). Mid-century modern one story home that DID NOT flood during Harvey! This beautiful one story home sits at the end of a quiet cul-de-sac in a prestigious neighborhood. Stunning bayou views, an open floor plan, and plenty of entertainment space. Oversized front and backyard with great access to roads. 15 Minute proximity to downtown. Perfect home for young professionals to experienced veterans. Features: Formal Dining and living with laminate floors, 3 spacious bedrooms, original vintage tiled bathrooms in great condition, with impeccable pendant lighting, and lots of built-ins. Call for your appointment TODAY!!!' ,`Acres` = '0.6395' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 5 GLENBROOK VALLEY SEC 5 R/P' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '27858' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARK PLACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CHAVEZ HIGH SCHOOL' ,`SchoolMiddle` = 'ORTIZ MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Glenbrook Valley' ,`TaxAmount` = '5550' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703685' WHERE `Matrix_Unique_ID` = '211313100' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T13:16:01.980' ,`MLSNumber` = '15272310' ,`ListAgentFullName` = 'Elizabeth Bartee' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.076880' ,`Longitude` = '-95.770186' ,`PhotoCount` = '32' ,`PostalCode` = '77447' ,`RoomCount` = '8' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Rocky Reserve' ,`StreetNumber` = '22043' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1904' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 22043 Rocky Reserve Drive! This home sits on a 4,950 sq/ft lot with NO BACK NEIGHBORS and offers 1,904 sq/ft of living space with 3 bedrooms, 2 full bathrooms, sits on a quiet street with beautiful landscaping, brick exterior, and all zoned to Waller ISD! You\'ll love all the features this home has to offer, including a primary suite, spacious living room, formal dining room, wood cabinets, granite countertops, fully fenced backyard, back patio, and so much more! Bauer Landing is minutes from Grand Parkway 99 and 290 - in an excellent location! Schedule your private showing today!' ,`Acres` = '0.1136' ,`Area` = '35' ,`BuilderName` = 'LGI Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 4 BAUER LANDING SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '474' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bauer Landing' ,`TaxAmount` = '3987' ,`TaxRate` = '2.8556' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703685' WHERE `Matrix_Unique_ID` = '211416464' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T12:37:28.147' ,`MLSNumber` = '20554174' ,`ListAgentFullName` = 'Kathy Garrison' ,`ListOfficeName` = 'Real Living Karapasha Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.713237' ,`Longitude` = '-95.825503' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '14' ,`ListPrice` = '1990000.00' ,`Status` = 'Active' ,`StreetName` = 'Pebblecreek' ,`StreetNumber` = '10502' ,`StreetSuffix` = 'Crossing' ,`City` = 'Katy' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Step into this completely custom built Partners In Building design in the prestigious gated section of The Reserve @ Spring Lake. Breathtaking upon entry, this rare 1.5 story home has everything you could want: beautiful wood floors, plantation shutters, lots of wood casing and oversized trim everywhere! Open floorpan with massive living area and wall of windows overlooking the backyard oasis and lake! Chef\'s kitchen complete with 2 islands both with sinks, oversized pantry, updated quartzite counters and faucets make a great area for entertaining. All 5 bedrooms down with ensuite baths plus a children\'s retreat within 3 of the bedrooms gives everyone their space. Upstairs you find an additional game room, media and gym with panoramic windows overlooking the resort style pool/spa and lake! Don\'t forget to look at the Texas basement for lots of storage space. Thought has gone into every inch of this SMART home inside and out. Too many details to list and a home you must see!' ,`Acres` = '0.4517' ,`Area` = '36' ,`BuilderName` = 'Partners in Building' ,`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 - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH SOUTHWEST SEC 21, BLOCK 2, LOT 1' ,`LotDesciption` = 'Corner,Subdivision Lot,Water View' ,`LotSize` = '19676' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'STANLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'SEVEN LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Controlled Access,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Ranch' ,`Subdivision` = 'Cinco Ranch Southwest Sec 21' ,`TaxAmount` = '31113' ,`TaxRate` = '2.7045' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703685' WHERE `Matrix_Unique_ID` = '211602217' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T13:44:48.893' ,`MLSNumber` = '53912421' ,`ListAgentFullName` = 'Alex Westbrook-McCollum' ,`ListOfficeName` = 'Swede\'s Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.461054' ,`Longitude` = '-94.619412' ,`PhotoCount` = '50' ,`PostalCode` = '77650' ,`RoomCount` = '5' ,`ListPrice` = '579000.00' ,`Status` = 'Active' ,`StreetName` = 'Crab' ,`StreetNumber` = '2298' ,`StreetSuffix` = 'Street' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Corner lot charmer in Sandpiper Beach is a perfect spot for entertaining. Open living room with shiplap vaulted ceiling flows to kitchen with large granite island for meal prep, and dining, granite countertops, stainless steel appliances. Washer and dryer are just off the kitchen in hall that leads to a rear deck. 3 bedrooms wit custom built-ins in both room and closets, 2 baths - shared bathroom has shower/tub combo. Master suite is accessible for all with spacious closets and the bathroom features 2 sinks and shower only. Large rear deck overlooks canal. Outdoor shower and insulated garage on ground level. Lots of potential on this deep lot! Enjoy both sunrise and sunset from either deck! A great home for families or rentals!' ,`Acres` = '0.3129' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SANDPIPER BEACH SEC 4 PH 1 (2014) ABST 65, LOT 10, ACRES 0.3' ,`LotDesciption` = 'Corner,Water View' ,`LotSize` = '13631' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Single 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` = 'Traditional' ,`Subdivision` = 'Sandpiper Beach Sec 4 Ph 1 20' ,`TaxAmount` = '5782' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703685' WHERE `Matrix_Unique_ID` = '211657025' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T12:47:33.877' ,`MLSNumber` = '55399432' ,`ListAgentFullName` = 'Britni Haley' ,`ListOfficeName` = 'Britni Haley' ,`SellingAgentFullName` = 'Sarah Herbek' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '28.978191' ,`Longitude` = '-95.253654' ,`PhotoCount` = '38' ,`PostalCode` = '77541' ,`RoomCount` = '7' ,`ListPrice` = '645000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Seagull' ,`StreetNumber` = '123' ,`StreetSuffix` = 'Avenue' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1386' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Turn-key ready beachside home with amazing views and steps from the water! This home has everything you\'re looking for from an updated kitchen, new cargo lift, golf cart garage, sleeping space for your many guests, and a wraparound extended deck space with wide open views of the beach and bay!! It sits on two lots and has new A/C (2021) and updated storm windows throughout. This well-maintained home will make the perfect rental, vacation home, or primary residence. Comes fully furnished except high-grade poly lumber outdoor furniture, which is negotiable! It is currently being used as a rental, so call ahead to make sure it is available for showings.' ,`Acres` = '0.1607' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SHANKS & BELANGER TR 238 (A0009 B T ARCHER DIV 1 (B C I C))' ,`LotDesciption` = 'Water View' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Shanks & Belanger Tr 238' ,`TaxAmount` = '7155' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703685' WHERE `Matrix_Unique_ID` = '211662886' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T13:35:45.360' ,`MLSNumber` = '44866630' ,`ListAgentFullName` = 'Wan Yi' ,`ListOfficeName` = 'W Realty & Investment Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.790981' ,`Longitude` = '-95.537862' ,`PhotoCount` = '15' ,`PostalCode` = '77055' ,`RoomCount` = '6' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Westview' ,`StreetNumber` = '9909' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2098' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great location! Easy access to I-10, City Centre, Memorial Mall, Energy Corridor, and Downtown. New Roof 2019. Well maintained one story property with updated kitchen and wood floor. Spacious backyard with a deck. The garage has been converted to flex space, and it can easily convert back to a garage.' ,`Acres` = '0.1928' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 5 SPRING BRANCH WOODS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WOODVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Branch Woods Sec 01' ,`TaxAmount` = '6470' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703685' WHERE `Matrix_Unique_ID` = '211671791' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T12:52:39.410' ,`MLSNumber` = '98073062' ,`ListAgentFullName` = 'Tonya Brown' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947223' ,`Longitude` = '-95.677659' ,`PhotoCount` = '38' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '535000.00' ,`Status` = 'Active' ,`StreetName` = 'Streamertail' ,`StreetNumber` = '11750' ,`StreetSuffix` = 'Circle' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2788' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to your new address in Alder Trails. This beautiful Taylor Morrison home has been well-maintained and rivals new construction in the area. The decorative brick / stone elevation covered front porch invites you to enter the foyer where you’re greeted with high ceilings along with a formal dining with open passage to the kitchen. The large kitchen and breakfast room feature an open concept and the tall wall of windows in the family room provides great natural light and a gas log fireplace. The primary bedroom is down and boasts a well-appointed en suite. There’s also a powder bathroom on the main floor. Upstairs you’ll find 3 additional bedrooms, 2 full bathrooms, a media room and large game room. Situated on an oversized semi-corner lot with no rear neighbors, a spacious but private backyard and extended covered patio are ready to host your favorite recreational activities or just to relax. The community amenities are a short walk away and Cy-Fair schools are nearby.' ,`Acres` = '0.159' ,`Area` = '25' ,`BuilderName` = 'Taylor Morrison' ,`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` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 ALDER TRAILS SEC 4' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '6924' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WOODARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Alder Trails Sec 4' ,`TaxAmount` = '8839' ,`TaxRate` = '2.711' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703686' WHERE `Matrix_Unique_ID` = '211792712' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T12:19:09.720' ,`MLSNumber` = '80063530' ,`ListAgentFullName` = 'David Feliciano III' ,`ListOfficeName` = 'Home Journey Realtors, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.075944' ,`Longitude` = '-95.163470' ,`PhotoCount` = '31' ,`PostalCode` = '77345' ,`RoomCount` = '6' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Aspen Pass' ,`StreetNumber` = '6134' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2499' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful and well-maintained 4 bedroom 1-Story in the sought after community of Kingwood. This home boasts incredible curb appeal, brick and stone exterior, sprinkler system, hard wood & tile flooring, large bedrooms and a study that can be used as a 4th bedroom! The luxurious master bathroom is exactly what you need after a long day at work. The open living concept includes a fireplace and a gorgeous kitchen with granite countertops! Kingwood is home to one of the best school districts in Texas. This home is zoned to Riverwood Middle and Kingwood High School. View it today!' ,`Acres` = '0.1873' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 47 BLK 4 VILLAGES OF RIVERCHASE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SHADOW FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages/Riverchase Sec 2' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703686' WHERE `Matrix_Unique_ID` = '211871307' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T13:30:10.233' ,`MLSNumber` = '49941103' ,`ListAgentFullName` = 'Desiree Burnley' ,`ListOfficeName` = 'BRE Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.176996' ,`Longitude` = '-96.384551' ,`PhotoCount` = '7' ,`PostalCode` = '77833' ,`RoomCount` = '2' ,`ListPrice` = '151000.00' ,`Status` = 'Active' ,`StreetName` = 'Brown' ,`StreetNumber` = '811' ,`StreetSuffix` = 'Street' ,`City` = 'Brenham' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1071' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This adorable house sits on a small hill and is full of potential!! The spacious living room offers a great entryway with room for extra seating area or dining area. Plenty of yard space. Great starter home or if looking to downsize to a place that is easy to maintain. Huge shady oak tree in the front that is great for enjoying the sunset. Just minutes from the Blue Bell Creamery.' ,`Acres` = '0.1423' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S2150 - COLLEGE HEIGHTS, LOT PT OF 44' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'College Heights' ,`TaxAmount` = '1816' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703686' WHERE `Matrix_Unique_ID` = '211873354' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T13:47:12.813' ,`MLSNumber` = '85291855' ,`ListAgentFullName` = 'Wayne Comer' ,`ListOfficeName` = '360 Realty & Management' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834330' ,`Longitude` = '-95.792398' ,`PhotoCount` = '32' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Highland Cliff' ,`StreetNumber` = '4123' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2499' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING 4 BEDROOM 3.5 BATH HOME WITH 2 CAR GARAGE. DINING ROOM, GREAT ROOM AND GAMEROOM. GOURMET KITCHEN, GRANITE KITCHEN COUNTERTOPS, AND A CAST STONE FIREPLACE IN GREAT ROOM. UPSTAIRS YOU\'LL FIND A LOFT SPACE AND ALL SECONDARY BEDROOMS. COVERED PATIO IN BACKYARD PERFECT FOR ENTERTAINING. COMMUNITY LAKE VIEW.' ,`Acres` = '0.1435' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 46 BLK 2 KATY POINTE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '590' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Pointe Sec 1' ,`TaxAmount` = '9956' ,`TaxRate` = '3.4768' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703686' WHERE `Matrix_Unique_ID` = '211874961' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T12:17:50.397' ,`MLSNumber` = '21144420' ,`ListAgentFullName` = 'Jared English' ,`ListOfficeName` = 'Congress Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.777097' ,`Longitude` = '-95.591054' ,`PhotoCount` = '3' ,`PostalCode` = '77079' ,`RoomCount` = '5' ,`ListPrice` = '1399998.00' ,`Status` = 'Active' ,`StreetName` = 'Pinerock' ,`StreetNumber` = '14015' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4375' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SEPT. 2022 COMPLETION - **FINAL PHASE OF FINISHES** Located in Memorial West, nestled in the Energy Corridor, this beautiful new construction home has been designed with no detail spared. The spacious modern cottage-style home boasts 4300+ SQFT filled with wide hallways, solid wood cabinetry, Quartzite countertops, hardwood flooring, luxurious primary suite, 1st & 2nd level laundry, double island kitchen and five (5) bedrooms with additional office. Home is zoned to award winning Wilchester Elementary and Stratford High School. The neighborhood is adjacent to the 22 acre Nottingham Park which contains a splash pad, running trail, tennis courts and disc golf course. The neighborhood sidewalk also connects to the 10+ miles of the Terry Hershey Trail system. Builder uses only quality materials and energy efficient building methods including premium Jeldwen windows, foam insulation, and a smart irrigation system.' ,`Acres` = '0.1861' ,`Area` = '23' ,`BuilderName` = 'Willow Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 4 NOTTINGHAM WEST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8107' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '680' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WILCHESTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'English,Traditional' ,`Subdivision` = 'Nottingham West Sec 02' ,`TaxAmount` = '9866' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703686' WHERE `Matrix_Unique_ID` = '211890218' --> Updated record success