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-02T12:54:39.790' ,`MLSNumber` = '41504138' ,`ListAgentFullName` = 'Kelly Turner' ,`ListOfficeName` = 'BSRH Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795972' ,`Longitude` = '-96.170248' ,`PhotoCount` = '9' ,`PostalCode` = '77474' ,`RoomCount` = '6' ,`ListPrice` = '368400.00' ,`Status` = 'Active' ,`StreetName` = 'Hunters Crossing' ,`StreetNumber` = '431' ,`StreetSuffix` = '' ,`City` = 'Sealy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2082' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction in Hunters Crossing! This Traditional styled 3 bedroom, 2 bath, includes a spacious kitchen with granite counter-tops and stainless steel appliances. The master suite includes an oversized shower and master closet. Don\'t forget the large covered patio where you can relax and enjoy the fresh country breeze! Walking distance to Sealy Elementary School. (Room measurements to be verified by buyer.)' ,`Acres` = '' ,`Area` = '57' ,`BuilderName` = '00000' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16, Block 1, Hunters Crossing' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SEALY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693636' WHERE `Matrix_Unique_ID` = '206363169' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T13:49:45.130' ,`MLSNumber` = '51634177' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.532926' ,`Longitude` = '-95.526793' ,`PhotoCount` = '7' ,`PostalCode` = '77358' ,`RoomCount` = '6' ,`ListPrice` = '428885.00' ,`Status` = 'Active' ,`StreetName` = 'Jim Hall' ,`StreetNumber` = '227' ,`StreetSuffix` = 'Lane' ,`City` = 'New Waverly' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS NEW D. R. HORTON BUILT 1 STORY 4 BEDROOM! MASSIVE LOT - OVER AN ACRE (per WCAD)! 3 Car Garage! Desirable Interior Layout with 4 Bedrooms + 2.5 Baths! Upgraded Island Kitchen with White Cabinetry, Spacious Living Area with Picture Windows Overlooking the Tranquil Backyard, Privately Located Primary Suite with Lovely Garden Bath & Huge Walk-In Closet, Spacious Secondary Bedrooms, & Generously Sized Indoor Utility Room! Double Pane Low-E Vinyl Windows, LED Lighting, & Tons of Other Energy Efficient Features! Subdivision is Deed Restricted, but Horses & RV Garages Are Allowed! Beautiful Wooded Homesite! Easy Access to National Park, Lake Conroe, & Boat Slip! SUPER LOW TAX RATE! Estimated Completion - May 2022.' ,`Acres` = '' ,`Area` = '43' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'New Waverly Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WAVERLY PLACE - SEC 1, BLOCK 5, LOT 12' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '43561' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '105 - New Waverly' ,`SchoolElementary` = 'NEW WAVERLY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEW WAVERLY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW WAVERLY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Waverly Place' ,`TaxAmount` = '' ,`TaxRate` = '1.8438' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693636' WHERE `Matrix_Unique_ID` = '206442002' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T12:17:24.443' ,`MLSNumber` = '67137454' ,`ListAgentFullName` = 'Carlos Olimon' ,`ListOfficeName` = 'Realty Executives' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851422' ,`Longitude` = '-95.590900' ,`PhotoCount` = '44' ,`PostalCode` = '77041' ,`RoomCount` = '13' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Cielio Bay' ,`StreetNumber` = '5706' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4060' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and view this perfectly located executive home in a 24 hour guard gated resort like community. This home is situated on a over sized quiet cul-de-sac and has many upgrades including a large tropical backyard with a salt water pool and spa with a rock waterfall and trees.. home has a large entry foyer with a wrapping elegant staircase, study and formal dining room. The kitchen is a chefs\'s dream with gourmet island and granite counters and stainless steel appliances. A huge master suite with a sitting area master bathroom wirh 2 shower heads and jacuzzi.In the upper level there is 3 large bedrooms and a big gameroom with 2 baths. This home water softner, sprinkler system and more.\r\nWhy not make this your home?.' ,`Acres` = '0.301' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 4 LAKES ON ELDRIDGE NORTH SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13110' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1854' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes On Eldridge North' ,`TaxAmount` = '10830' ,`TaxRate` = '2.431' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693636' WHERE `Matrix_Unique_ID` = '207877612' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T13:55:21.603' ,`MLSNumber` = '13568821' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Jerry Battle' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '29.505094' ,`Longitude` = '-95.714680' ,`PhotoCount` = '6' ,`PostalCode` = '77469' ,`RoomCount` = '18' ,`ListPrice` = '734427.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Moonstone' ,`StreetNumber` = '1603' ,`StreetSuffix` = 'Circle' ,`City` = 'Rosenberg' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4463' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carleigh II, Elevation B) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. Elegant double front door entry. Family room, formal dining room and study. Spacious island kitchen open to Family room. Primary suite with large double walk-in closets. Guest suite with bathroom on first floor. Three additional bedrooms, spacious game room and media room on second floor. Covered patio and 3-car tandem garage. This growing community is already a comfortable home to many who appreciate its state-of-the-art amenities and calming landscape. Outside Stone Creek Estates is the flourishing suburb of Rosenberg, Texas. Shopping is around the corner, there are multiple five-star restaurants, and most importantly is the access to the highly recognized Lamar Consolidated ISD. Stop by the Westin Homes model to learn more about Stone Creek Estates!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 22 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12873' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stonecreek Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693637' WHERE `Matrix_Unique_ID` = '208699391' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T13:36:12.910' ,`MLSNumber` = '83136587' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.349287' ,`Longitude` = '-95.536484' ,`PhotoCount` = '20' ,`PostalCode` = '77304' ,`RoomCount` = '3' ,`ListPrice` = '342385.00' ,`Status` = 'Active' ,`StreetName` = 'Newcomb Hollow' ,`StreetNumber` = '519' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2255' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING NEW DR HORTON HOME! Fantastic floor plan with island kitchen, spacious living areas, lovely bedroom 1 suite, and so much more! This home also features modern finishes, granite counter tops, vinyl wood plank floors, stainless steel appliances, great outdoor space and useful covered patio. Bath 1 features double sinks and a separate shower and tub! Beautiful community with the best amenities! Come take a look! Call today!' ,`Acres` = '0.1378' ,`Area` = '19' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S582102 - HILLS OF WESTLAKE 02, BLOCK 1, LOT 28' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6004' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = '' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hills Of Westlake 02' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693637' WHERE `Matrix_Unique_ID` = '209322424' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T12:37:07.770' ,`MLSNumber` = '58337331' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.220464' ,`Longitude` = '-95.713491' ,`PhotoCount` = '36' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '526397.00' ,`Status` = 'Active' ,`StreetName` = 'Legacy Park' ,`StreetNumber` = '15398' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2518' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Estimated October 2022 completion, this functional floor plan offers just the right amount of space for any lifestyle featuring 4 bedrooms, 3 bathrooms, plus a study all on one level. The designer kitchen offers luxurious quartz countertops, painted cabinetry, and a trendy matching backsplash. With luxury vinyl plank wood flooring throughout main areas, a spa-inspired custom en-suite in the primary bedroom, and a spacious covered patio, this home is the perfect spot to wind down after a long day. With Empire\'s quality construction and efficiency standards guaranteed by the Environment\'s for Living Program, you will feel confident and at peace heading into the Texas summer heat. Audubon will feature a resort-style amenity center, on-site elementary school, nature trails, and much more. Convenient access to nearby dining, shopping, schools, and 249, schedule your private tour today and fall in love with your new Empire home.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot17 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693637' WHERE `Matrix_Unique_ID` = '209363422' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T13:35:42.647' ,`MLSNumber` = '18248914' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.349287' ,`Longitude` = '-95.536484' ,`PhotoCount` = '22' ,`PostalCode` = '77304' ,`RoomCount` = '4' ,`ListPrice` = '353785.00' ,`Status` = 'Active' ,`StreetName` = 'Newcomb Hollow' ,`StreetNumber` = '511' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2185' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHARMING NEW DR HORTON HOME! Fantastic floor plan with island kitchen, spacious living areas, lovely bedroom 1 suite, and so much more! This home also features modern finishes, granite counter tops, vinyl wood plank floors, stainless steel appliances, great outdoor space and useful covered patio. Bath 1 features double sinks and a separate shower and tub! Beautiful community with the best amenities! Come take a look! Call today!' ,`Acres` = '0.1267' ,`Area` = '19' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S582102 - HILLS OF WESTLAKE 02, BLOCK 1, LOT 26' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5518' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = '' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hills Of Westlake 02' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693637' WHERE `Matrix_Unique_ID` = '209407165' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T13:41:32.020' ,`MLSNumber` = '7611011' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.683041' ,`Longitude` = '-95.832617' ,`PhotoCount` = '7' ,`PostalCode` = '77406' ,`RoomCount` = '11' ,`ListPrice` = '830900.00' ,`Status` = 'Active' ,`StreetName` = 'Klaria Crescent' ,`StreetNumber` = '10722' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3791' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Curved staircase highlights two-story entry. Home office with French doors and formal dining room set at entry. Two-story family room with wall of windows and corner wood mantel fireplace opens to kitchen and morning area. Kitchen features walk-in pantry, double wall oven, 5-burner gas cooktop and island with built-in seating space. First-floor primary suite with wall of windows. Dual vanities, garden tub, separate glass-enclosed shower and two walk-in closets in primary bath. First-floor guest suite offers private bath. A game room, media room and three secondary bedrooms are upstairs. Extended covered backyard patio. Three-car garage.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Candela Lot 11, Blk 1, Section 8' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9994' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693637' WHERE `Matrix_Unique_ID` = '209592655' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T13:34:58.750' ,`MLSNumber` = '86245843' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.349822' ,`Longitude` = '-95.535554' ,`PhotoCount` = '18' ,`PostalCode` = '77304' ,`RoomCount` = '5' ,`ListPrice` = '345135.00' ,`Status` = 'Active' ,`StreetName` = 'Newcomb Hollow' ,`StreetNumber` = '523' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2271' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING!! NEW DR HORTON HOME! Lovely 1 story floor plan with island kitchen, spacious living areas, wonderful bedroom 1 suite, and so much more! This home also features modern finishes, granite counter tops, vinyl wood plank floors, stainless steel appliances, great outdoor space and useful covered patio. Bath 1 features double sinks and a separate shower and tub! Beautiful community with the best amenities! Come take a look! Call today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Hills Of Westlake 02, BLOCK 1, Lot 29' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hills Of Westlake' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693637' WHERE `Matrix_Unique_ID` = '209637501' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T12:24:01.850' ,`MLSNumber` = '91841911' ,`ListAgentFullName` = 'Randy French' ,`ListOfficeName` = 'Stylecraft Builders, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.177406' ,`Longitude` = '-96.427553' ,`PhotoCount` = '8' ,`PostalCode` = '77833' ,`RoomCount` = '9' ,`ListPrice` = '278900.00' ,`Status` = 'Active' ,`StreetName` = 'Muscadine' ,`StreetNumber` = '2050' ,`StreetSuffix` = 'Trail' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1354' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming three bedroom, two bath home is known for its intelligent use of space and now features an even more open living area. The large kitchen granite-topped island opens up to your living room to provide a cozy flow throughout the home. Your dining area features the most charming window you\'ll ever see. Featuring large walk-in closets, luxury flooring, and volume ceilings - this beauty certainly delivers when it comes to affordable luxury. Additional options include: Stainless steel appliances, exterior coach lighting, decorative tile backsplash, integral blinds in rear door, and a dual primary bathroom vanity.' ,`Acres` = '0.158' ,`Area` = '58' ,`BuilderName` = 'Stylecraft' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S5942 - Vintage Farms S/D # 3, BLOCK 1, Lot 25, ACRES 0.158' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6882' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Vintage Farms' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693637' WHERE `Matrix_Unique_ID` = '210182676' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T12:45:44.310' ,`MLSNumber` = '24868418' ,`ListAgentFullName` = 'Trinh Le' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.861472' ,`Longitude` = '-95.729374' ,`PhotoCount` = '16' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Whitwell' ,`StreetNumber` = '5807' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1585' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor\'s opportunity!!! Cozy 1 story 3bed/2bath CORNER lot home located at EXCELLENT LOCATION - walking distance to elementary school, minutes to Fry Rd/W. Little York/529/99, 15m to Katy Asian Town, 7m to Ca Mau Food Market. Good long term tenant. Home comes with 3 sides brick, laminate flooring throughout the house except for 1 bedroom w/carpet. BRAND NEW AC. WATER HEATER 2021. Quiet neighborhood. Make this your next investment property!' ,`Acres` = '0.1725' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 26 SETTLERS VILLAGE SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7516' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HEMMENWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Settlers Village Sec 03' ,`TaxAmount` = '4932' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693638' WHERE `Matrix_Unique_ID` = '210488408' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T12:16:46.833' ,`MLSNumber` = '86895028' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.060053' ,`Longitude` = '-95.235282' ,`PhotoCount` = '27' ,`PostalCode` = '77339' ,`RoomCount` = '10' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Kings Park Hollow' ,`StreetNumber` = '26869' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.0802' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S775600 - PARK AT KINGS MANOR 01, BLOCK 2, LOT 15' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '3493' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '440' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'KINGS MANOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Park At Kings Manor 01' ,`TaxAmount` = '5219' ,`TaxRate` = '2.7631' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693638' WHERE `Matrix_Unique_ID` = '210810363' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T12:20:53.357' ,`MLSNumber` = '82307826' ,`ListAgentFullName` = 'Francia Lopez' ,`ListOfficeName` = 'Remington Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.087958' ,`Longitude` = '-95.425430' ,`PhotoCount` = '12' ,`PostalCode` = '77373' ,`RoomCount` = '4' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Henderson' ,`StreetNumber` = '27320' ,`StreetSuffix` = 'Road' ,`City` = 'Spring' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1657' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location Location Location!!! Amazing opportunity to purchase a property with in minutes of the most desired Old Town Spring. This beautiful 2 lot property features almost 1/2 acre of unrestricted land with a one story ,3 bedroom 1.5 bath with original wood floors. Don\'t miss the opportunity to purchase this amazing property in prime location!!!! Home selling AS IS. (Property is 27320 & 27322 Henderson)' ,`Acres` = '0.4769' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 6B & 6C-1 ABST 971 C W FRITZ (HT&BRR)' ,`LotDesciption` = 'Other' ,`LotSize` = '20774' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'NORTHGATE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'SPRINGWOODS VILLAGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'ABST 971 C W FRITZ (HT&BRR)' ,`TaxAmount` = '3301' ,`TaxRate` = '2.1367' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693638' WHERE `Matrix_Unique_ID` = '210944784' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T13:15:52.050' ,`MLSNumber` = '40464890' ,`ListAgentFullName` = 'Laura Bonck' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.763382' ,`Longitude` = '-95.475742' ,`PhotoCount` = '37' ,`PostalCode` = '77056' ,`RoomCount` = '11' ,`ListPrice` = '3399000.00' ,`Status` = 'Active' ,`StreetName` = 'Sturbridge' ,`StreetNumber` = '5524' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6435' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This masterfully remodeled estate sits on almost 1 acre and is perfectly placed on a quiet street in Tanglewood. Oversized double doors lead you inside this contemporary home. Large windows decorate the home, letting in abundant amounts of natural light. The open concept areas have spectacular views of the spacious backyard, which is perfect for entertaining with a patio, salt water pool, batting cage and golfing area. The gourmet kitchen is fully equipped with Viking double ovens, 2 dishwashers, subzero refrigerator, and a beautiful island with bar seating. With a steam room, luxurious soaking tub, and vanity areas, the divine master bath truly serves as your own personal spa. All 5 bedrooms have full baths and palatial closets for maximized storage. The 3 car garage parking area has the ability to double as a basketball court as well. Large oak trees line the front and back of the house, only further adding to the incredible landscape and enchanting views this stunning home offers.' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lt 9 Blk 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '41250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tanglewood Sec 05' ,`TaxAmount` = '70303' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663693638' WHERE `Matrix_Unique_ID` = '210952029' --> Updated record success