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-27T11:24:27.453' ,`MLSNumber` = '38140861' ,`ListAgentFullName` = 'Luz Castillo' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.679438' ,`Longitude` = '-95.201645' ,`PhotoCount` = '20' ,`PostalCode` = '77502' ,`RoomCount` = '4' ,`ListPrice` = '228000.00' ,`Status` = 'Active' ,`StreetName` = 'Basket' ,`StreetNumber` = '2201' ,`StreetSuffix` = 'Street' ,`City` = 'Pasadena' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1311' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPEN HOUSE! AUGUST 28,2022 From 12-3pm\r\n\r\n Mature Trees, providing plenty of shade, to enjoy your gardening. \r\nBack yard ready for family fun and cookouts, in a ready for a makeover-to your perfect, entertaining area. \r\nthis Home is ready and eagerly waiting on it\'s new owner. This is a must see!\r\nLocated in well established area of Pasadena, easy access to shopping area & Restaurants.' ,`Acres` = '0.1623' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 232 BLK 15 SHAVER PLACE SEC 3' ,`LotDesciption` = 'Other' ,`LotSize` = '7068' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'BAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'PARKVIEW INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shaver Place Sec 03' ,`TaxAmount` = '3338' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703652' WHERE `Matrix_Unique_ID` = '207746779' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T11:39:51.260' ,`MLSNumber` = '68489469' ,`ListAgentFullName` = 'Malika Tookes' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.770131' ,`Longitude` = '-95.000423' ,`PhotoCount` = '20' ,`PostalCode` = '77521' ,`RoomCount` = '4' ,`ListPrice` = '338000.00' ,`Status` = 'Active' ,`StreetName` = 'Goose Creek' ,`StreetNumber` = '5110' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2646' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RECENT REPAIRS MADE BY SELLER. COME CHECK OUT THIS 4/2/2 LOCATED IN BAYTOWN. This home has been fully remodeled inside and out. New floors, paint inside and out, granite countertops, and upgraded bathrooms. This home also includes an updated sunroom and beautifully landscaped with huge shade trees. This is a MUST SEE HOME in the Country Club neighborhood.' ,`Acres` = '0.4743' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 8 COUNTRY CLUB OAKS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20660' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial' ,`Subdivision` = 'Country Club Oaks Sec 01' ,`TaxAmount` = '7449' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703653' WHERE `Matrix_Unique_ID` = '207924255' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T11:55:21.880' ,`MLSNumber` = '32873429' ,`ListAgentFullName` = 'Son Pham' ,`ListOfficeName` = 'Home State Realty Firm LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.894793' ,`Longitude` = '-95.457612' ,`PhotoCount` = '17' ,`PostalCode` = '77088' ,`RoomCount` = '6' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Lovington' ,`StreetNumber` = '11226' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2149' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 Bedrooms 2 Baths Master Suite down with Separate Tub & Shower and Dual Vanity, Open Kitchen with 42\'\' Cabinets. House is ready to move in.' ,`Acres` = '0.1343' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 9 MOUNT ROYAL VILLAGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5848' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '455' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'HILL ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Mount Royal Village Sec 2' ,`TaxAmount` = '5685' ,`TaxRate` = '2.6153' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703653' WHERE `Matrix_Unique_ID` = '208036771' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T11:40:56.917' ,`MLSNumber` = '95377173' ,`ListAgentFullName` = 'Emily Johnson' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.495351' ,`Longitude` = '-95.919010' ,`PhotoCount` = '20' ,`PostalCode` = '77417' ,`RoomCount` = '3' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = '6th' ,`StreetNumber` = '204' ,`StreetSuffix` = 'Street' ,`City` = 'Beasley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2131' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TWO story home on a 4950sq ft lot. This open concept home has lots of space and upgrades. The first floor has 10 ft ceilings, a spacious family room, a large pantry, an adjacent dining room, and lots of cabinet space. The second-floor primary bedroom is enormous and includes an enclosed walk-in shower, double vanity sinks, and lots of cabinet space. The bedroom also has a very large walk-in closet and a refreshing walk-out balcony. The other side of the home contains 2 bedrooms, Jack n Jill bathroom w/double sink vanities, a laundry room, and a Gameroom. Granite and Corian counters throughout. This Quiet and remote home has very LOW TAXES and is located just outside of Richmond/Rosenberg; 10 mins from Brazos Town Center & 1 min access to Hwy 59.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'JAYE BREE HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Beasley, BLOCK 37, LOT 11 & 1/2 OF 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4950' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BEASLEY ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'TERRY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO/GEORGE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'City Of Beasley' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703653' WHERE `Matrix_Unique_ID` = '208639737' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T11:56:09.710' ,`MLSNumber` = '18875702' ,`ListAgentFullName` = 'Ellisa Carswell' ,`ListOfficeName` = 'Carswell Real Estate Co. Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.112702' ,`Longitude` = '-95.639290' ,`PhotoCount` = '38' ,`PostalCode` = '77375' ,`RoomCount` = '7' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Alice' ,`StreetNumber` = '31106' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained home located on an oversized lot in the sought after Tomball Hills. This beautiful 3 bedrooms 2 bath has been updated with granite in the kitchen and baths. Huge walk in custom shower in primary bath and bathrooms all updated as well. Gorgeous laminate throughout. Gas cook top and Oven replaced 2 years ago. Recessed lighting in the Den, gas logs set replaced. Radiant Barrier added in Attic. Cedar fencing replaced 3 months ago. Roof and gutters replace 8/21. Lot backs up to woods. This beautiful home is in a great location to schools, shopping, churches. Close to SH 249 for easy access to Houston to the South and Magnolia to the north. Tomball ISD.' ,`Acres` = '0.2984' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 TOMBALL HILLS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '45' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Tomball Hills' ,`TaxAmount` = '4488' ,`TaxRate` = '2.3717' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703653' WHERE `Matrix_Unique_ID` = '209301406' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T10:13:47.470' ,`MLSNumber` = '88648633' ,`ListAgentFullName` = 'Angelica Robles' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.741239' ,`Longitude` = '-95.295195' ,`PhotoCount` = '7' ,`PostalCode` = '77011' ,`RoomCount` = '2' ,`ListPrice` = '160000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue K' ,`StreetNumber` = '7145' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '790' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The property is located close to Downtown and the Port of Houston. Magnolia Park is an established neighborhood. Lot has the opportunity for development. Don\'t hesitate on viewing this property.' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 10 & 11 BLK 100 MAGNOLIA PARK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FRANKLIN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'EDISON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Park Sec 02' ,`TaxAmount` = '1446' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1936' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703653' WHERE `Matrix_Unique_ID` = '210192571' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T10:41:08.697' ,`MLSNumber` = '29991110' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.953099' ,`Longitude` = '-95.192987' ,`PhotoCount` = '12' ,`PostalCode` = '77396' ,`RoomCount` = '6' ,`ListPrice` = '399365.00' ,`Status` = 'Active' ,`StreetName` = 'Black Grouse' ,`StreetNumber` = '15859' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2054' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME TO THE THREE STORY FAIRVIEW PLAN in beautiful Balmoral! This home is part of Chesmar\'s BRAND NEW TOWN SQUARE SERIES. The Fairview features a split level plan, step down to a guest suite or step up to open concept living with tons of natural light, spacious kitchen, and a private study and half bath tucked away. Head upstairs again to a spacious master suite and another large bedroom with ensuite bathroom. This home showcases THREE Covered Outdoor Living Space (Ground floor side patio, raised front porch, and second floor Balcony off kitchen!)+ 2 Car Attached Garage with additional storage space for hobby items or an extra long truck! Stainless Steel Appliances, 2\" Blinds, Upgraded Wood-Look Tile Flooring, on-trend quartz counters and neutral cabinets in the kitchen, Fully Sodded Yard + Landscaping Pkg all included! **HOME IS UNDER CONSTRUCTION. For more info, contact Chesmar Homes in BALMORAL community. August 2022 estimated completion.**' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot:15 Block:1 Section:26' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '3.55735' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703653' WHERE `Matrix_Unique_ID` = '211293779' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T10:38:36.367' ,`MLSNumber` = '19241817' ,`ListAgentFullName` = 'Praful Shah' ,`ListOfficeName` = 'Praful Shah' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.108565' ,`Longitude` = '-94.171974' ,`PhotoCount` = '23' ,`PostalCode` = '77706' ,`RoomCount` = '8' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Charleston' ,`StreetNumber` = '3535' ,`StreetSuffix` = 'Lane' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2481' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom Built by Patton Homes 4-bedroom home in Barrington Heights. Never rented well cared and immaculately maintained by owner. Located in cul-de-sac with minimal traffic, in highly sought-after Barrington Heights HOA subdivision in the Heart of Beaumont\'s West End! This home features an open concept split bedroom floor plan with formal living and dining. Beautiful wood floors high ceilings, crown molding, lovely inbuilt gas fireplace! The kitchen includes breakfast combo, granite counter tops, Energy Efficient Appliances, island work center. Spacious Master Suite with double vanity, jetted tub, walk-in shower & walk-in closet. House has lots of Upgrades including NEW ROOF (June 2022), Granite Counter tops, new A/C compressor and new furnace - - under warranty. Recently pressure washed and painted.' ,`Acres` = '0.2039' ,`Area` = '51' ,`BuilderName` = 'PATTON HOMES INC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BARRINGTON HEIGHTS PHASE II LOT 16 BLK 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8880' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'REGINAL-HOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Barrington Heights Ph II' ,`TaxAmount` = '7449' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703653' WHERE `Matrix_Unique_ID` = '211588749' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T10:21:05.240' ,`MLSNumber` = '68226487' ,`ListAgentFullName` = 'Lucy Ware' ,`ListOfficeName` = 'Birdsong Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.041143' ,`Longitude` = '-95.428657' ,`PhotoCount` = '31' ,`PostalCode` = '77566' ,`RoomCount` = '7' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Persimmon' ,`StreetNumber` = '122' ,`StreetSuffix` = 'Lane' ,`City` = 'Lake Jackson' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2722' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This spacious home sits on almost half an acre! The house contains 2 living rooms, dining, kitchen, breakfast area, 5 bedrooms, and 3 baths. Walk into the large living room that looks out to the front yard. The second living has great space for a game room! The cozy kitchen has plenty of counter and cabinet space, gas stove, microwave and dishwasher. The utility room is located inside. Walk outside to the huge deck and fenced in yard. Close to shopping and schools. Call us to schedule an appointment today.' ,`Acres` = '0.4312' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LAKE FOREST (LAKE JACKSON) BLK 1 LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18783' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BEUTEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Forest Lake Jackson' ,`TaxAmount` = '5911' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703654' WHERE `Matrix_Unique_ID` = '211683692' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T10:11:50.893' ,`MLSNumber` = '28214242' ,`ListAgentFullName` = 'Tahira Syed' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.723959' ,`Longitude` = '-95.426692' ,`PhotoCount` = '7' ,`PostalCode` = '77005' ,`RoomCount` = '9' ,`ListPrice` = '1900000.00' ,`Status` = 'Active' ,`StreetName` = 'Albans' ,`StreetNumber` = '3112' ,`StreetSuffix` = 'Road' ,`City` = 'West University Place' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stylish West U new construction home to be built by Detamore Development Team.. 3112 Albans defines modern elegance with timeless finishes featuring 4-5 bedrooms and 5 FULL bathrooms, open and airy spaces, large windows, high ceilings and a conveniently located first floor office/bedroom with a FULL bathroom! The sunlit Kitchen will showcase Wolf/Sub-Zero Appliances, custom built cabinetry, natural stone countertops, large center island and a walk-in pantry. Primary retreat on second floor with a custom fitted closet and a luxurious spa like bathroom! Game-room and three additional secondary bedrooms with walk-in closets and en-suite bathrooms on the second floor. Pergola with outdoor kitchen and a spacious backyard to fit a sizable pool (see renderings in pictures). Tucked in the heart of West University Place, short walk to the Rice Village, Parks, Shops and Restaurants. A SHOWSTOPPER!' ,`Acres` = '0.1205' ,`Area` = '17' ,`BuilderName` = 'Detamore Development' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 3 MONTICELLO' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Temporarily No Showings' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,French,Other Style' ,`Subdivision` = 'Monticello' ,`TaxAmount` = '15345' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703654' WHERE `Matrix_Unique_ID` = '211775293' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T10:17:20.357' ,`MLSNumber` = '55980572' ,`ListAgentFullName` = 'Quyen Nguyen' ,`ListOfficeName` = 'Smith Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.694252' ,`Longitude` = '-96.257239' ,`PhotoCount` = '18' ,`PostalCode` = '77465' ,`RoomCount` = '3' ,`ListPrice` = '479000.00' ,`Status` = 'Active' ,`StreetName` = 'Palm Coast' ,`StreetNumber` = '3019' ,`StreetSuffix` = 'Lane' ,`City` = 'Palacios' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1814' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful open concept home with spectacular water views from every room! Relax on the patio/deck with views of Turtle Bay and beautiful sunsets. Soak up the sun and family fun at the community pool, basketball & tennis courts. Make this your home and enjoy the tranquil and relaxing atmosphere of coastal living today!' ,`Acres` = '0.2611' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BEACHSIDE, LOT 359' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '11375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '156 - Palacios' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (PALACIOS)' ,`SchoolHigh` = 'PALACIOS HIGH SCHOOL' ,`SchoolMiddle` = 'PALACIOS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Beachside' ,`TaxAmount` = '7732' ,`TaxRate` = '2.7349' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703654' WHERE `Matrix_Unique_ID` = '211804978' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T10:19:31.127' ,`MLSNumber` = '9584007' ,`ListAgentFullName` = 'Quyen Nguyen' ,`ListOfficeName` = 'Smith Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.707148' ,`Longitude` = '-96.215447' ,`PhotoCount` = '16' ,`PostalCode` = '77465' ,`RoomCount` = '5' ,`ListPrice` = '359900.00' ,`Status` = 'Active' ,`StreetName` = '4th' ,`StreetNumber` = '801' ,`StreetSuffix` = 'Street' ,`City` = 'Palacios' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful newly-renovated Craftsman-style home you have to see! This charming home has 4 bedrooms, 3.5 baths, large kitchen island with stainless steel appliances, designer backsplash, Quartz countertops, and a spacious mud room. The home sits on a huge corner lot with a new privacy fence, roof, and HVAC (per seller)' ,`Acres` = '0.344' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PALACIOS ORIGINAL TOWNSITE, BLOCK 45, LOT 1-3-S-100\'' ,`LotDesciption` = 'Other' ,`LotSize` = '14985' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '156 - Palacios' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (PALACIOS)' ,`SchoolHigh` = 'PALACIOS HIGH SCHOOL' ,`SchoolMiddle` = 'PALACIOS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Palacios Original Townsite' ,`TaxAmount` = '2233' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703654' WHERE `Matrix_Unique_ID` = '211807090' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T10:29:37.060' ,`MLSNumber` = '19154732' ,`ListAgentFullName` = 'Jared English' ,`ListOfficeName` = 'Congress Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.385826' ,`Longitude` = '-95.638428' ,`PhotoCount` = '20' ,`PostalCode` = '77356' ,`RoomCount` = '2' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake View' ,`StreetNumber` = '807' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1954' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is an absolute STUNNER! Ever dreamed of owning a vacation home? or perhaps just want a home that is very low maintenance and has peaceful surroundings? Look NO further! This home features just under 2000 sq feet of living place. It has a split two master suite floor plan, both with bathrooms. This home has been fully remodeled, designer decorated, large front patio with some lake views, and very low maintenance yard! Cute and quaint neighborhood. This turn key home can come fully furnished and is ready for its new owner!! Come take a look today and don\'t let this one get away!' ,`Acres` = '0.3891' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CAPE CONROE 02, BLOCK 13, LOT 11, 12' ,`LotDesciption` = 'Water View' ,`LotSize` = '16950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other,Tile' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,French,Other Style' ,`Subdivision` = 'Cape Conroe 02' ,`TaxAmount` = '4545' ,`TaxRate` = '2.3542' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663703654' WHERE `Matrix_Unique_ID` = '211874891' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T10:43:46.703' ,`MLSNumber` = '95389544' ,`ListAgentFullName` = 'Dinh Nguyen' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.114233' ,`Longitude` = '-95.506760' ,`PhotoCount` = '48' ,`PostalCode` = '77389' ,`RoomCount` = '9' ,`ListPrice` = '749000.00' ,`Status` = 'Active' ,`StreetName` = 'De Lagos' ,`StreetNumber` = '4919' ,`StreetSuffix` = '' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '5' ,`BedsTotal` = '4' ,`SqFtTotal` = '4012' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous cul-de-sac home in GATED COMMUNITY of MCKENZIE PARK. Zoned to award winning Klein Independent School District. Spacious home features 4 beds 3.5 baths with high ceiling, 8-foot doors, 4 car garage, walk-in closet, wall of windows with SHUTTERS carrying out a lot of natural lights, formal dining, game room and office room. Gourmet kitchen features Oversized Island, granite counters, lot of cabinets, walk-in pantry and SS appliances. Master suite features high ceiling, oversized tub and separated shower, double vanity and duel walk-in closet. HUGE backyard with outdoor kitchen and sink for cooking and entertainment. Yet, community pool, 40 miles greenway trail surrounding by many lakes. Just a few minutes away from major freeway (Grand parkway/99, 45, 249), Exxon campus, Market Street and The Woodland mall. You will fall in love with this great community. Come visit today!' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 2 MCKENZIE PARK SEC 4' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '20534' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2433' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRENCH ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mckenzie Park Sec 4' ,`TaxAmount` = '14269' ,`TaxRate` = '3.004' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703654' WHERE `Matrix_Unique_ID` = '211877171' --> Updated record success