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-10-31T05:21:07.203' ,`MLSNumber` = '80738136' ,`ListAgentFullName` = 'Kim Zubia' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Milly Kammerdiener' ,`SellingOfficeName` = 'Newhomeprograms.com LLC' ,`Latitude` = '30.114876' ,`Longitude` = '-95.212174' ,`PhotoCount` = '47' ,`PostalCode` = '77357' ,`RoomCount` = '8' ,`ListPrice` = '220000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Harmony' ,`StreetNumber` = '22906' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful and lovely Mobile Home, ready for you and your family to start new memories.This house has 4 Bedrooms with a very spacious closets, 2 full bathrooms, breakfast area, formal dining and open living room. Very good maintained Home with great land, located on 1/2 acre, completely fenced and electronic gate. Also includes 2 storage shed, a workshop with a pegboard, lights in garage w/4 electrical outlets and tandem detached carport for 4 cars plus a big driveway. \r\nDon\'t miss this opportunity, schedule your appointment. \r\nPlease call agent for any more information' ,`Acres` = '0.5289' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'OAK SHADOWS, BLOCK 2, LOT 20, MH SERIAL # 12336439A, TITLE #' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '23040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'OAKLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW CANEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Shadows' ,`TaxAmount` = '885' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227299' WHERE `Matrix_Unique_ID` = '209515255' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T05:07:39.990' ,`MLSNumber` = '33923870' ,`ListAgentFullName` = 'Norberto Lopez' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.862852' ,`Longitude` = '-95.722798' ,`PhotoCount` = '32' ,`PostalCode` = '77449' ,`RoomCount` = '11' ,`ListPrice` = '314990.00' ,`Status` = 'Active' ,`StreetName` = 'Horse Prairie' ,`StreetNumber` = '5918' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2162' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a lovely neighborhood home on a cul- de-sac street with all brick around and a new roof. The home has 4 bedrooms, 2 bathrooms, and a 2-car garage. There is ceramic tile in the living room, kitchen, bathrooms, and in bedrooms. The kitchen has been updated with quartz countertops, stainless appliances & a breakfast nook. The master bedroom has an en suite bathroom with a garden tub and separate shower. The spacious master suite features a tray ceiling, walk-in closet & updated bath with dual vanities, soaking tub & separate shower. 3 additional bedrooms & another full bath complete this home. The home is situated on a large lot with plenty of room for outdoor activities. This would be an ideal starter home or for someone looking to downsize. Don\'t miss out on this great opportunity!' ,`Acres` = '0.1906' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 36 BLK 1 EAGLE RANCH WEST SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8302' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HEMMENWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Ranch West Sec 1' ,`TaxAmount` = '6239' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227299' WHERE `Matrix_Unique_ID` = '213245102' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T04:10:44.313' ,`MLSNumber` = '98565951' ,`ListAgentFullName` = 'Telma Garcia' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.968115' ,`Longitude` = '-95.193799' ,`PhotoCount` = '30' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Kobuk Valley' ,`StreetNumber` = '17239' ,`StreetSuffix` = 'Circle' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1851' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This fantastic one-story home combines desirable location, an open floor plan, and modern updates into one attractive package. Featuring 10-foot ceilings and hardwood or tile floors throughout(No Carpet!). This home also offers a newly remodeled stunning primary bathroom ! New fabulous custom closet! Recent new A/C and Water heater units. New fence in 2021, Exterior painted 2022. The open living and kitchen area includes energy-efficient s.s. appliances and plenty of room for cooking or entertaining. (Refrigerator stays) The large backyard and covered patio make grilling with the family a breeze. No Flooding here! Located in the highly desired community of Eagle Springs and situated in a family-friendly cul-de-sac. This perfect home is also conveniently close to lots of shopping and restaurants & easy access to Beltway 8 and Hwy 59. Neighborhood amenities include 24-hour fitness center, resort style pools, sports fields, splash pad, several parks, and more!' ,`Acres` = '0.1515' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 1 EAGLE SPRINGS SEC 19' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6598' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ATASCOCITA SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Springs' ,`TaxAmount` = '5905' ,`TaxRate` = '2.913' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227299' WHERE `Matrix_Unique_ID` = '213393823' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T05:24:26.490' ,`MLSNumber` = '89518206' ,`ListAgentFullName` = 'Karol Deem' ,`ListOfficeName` = 'Deem Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.244480' ,`Longitude` = '-94.902283' ,`PhotoCount` = '33' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Zingelman' ,`StreetNumber` = '11631' ,`StreetSuffix` = 'Road' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1419' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two Acres on dead end country road with horses & cows for neighbors. Three bedrooms, two baths, 1419 square feet split level with concrete below. Home renovated with recent roof, HVAC, vinyl wood look flooring, paint inside and out, vinyl insulated windows, lights, ceiling fans, plugs, switches, electric hot water heater, exterior electric meter disconnect switch, bathroom fixtures, water line from street, closed cell insulation on ceiling below and soffit below. Includes all new appliances. Owner/agent. Ready to move in. Enter by dirt driveway and park in rear of home.' ,`Acres` = '2' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 PAGE 58 PT OF LOT 161 (161-13) TRIMBLE & LINDSEY SE' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Lockbox Back,Lockbox Left Side,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Trimble & Lindsey Sec 2' ,`TaxAmount` = '3642' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227300' WHERE `Matrix_Unique_ID` = '213469743' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T05:22:37.543' ,`MLSNumber` = '14728530' ,`ListAgentFullName` = 'Lisa Roth' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.200434' ,`Longitude` = '-95.441522' ,`PhotoCount` = '33' ,`PostalCode` = '77385' ,`RoomCount` = '12' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Laughing Falcon Trail' ,`StreetNumber` = '8206' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3139' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous 1.5 story home on an oversized lot! Second floor offers large flexible space and a fourth bedroom with full bath. Extended back patio. Wood floors in family room and all 3 first floor bedrooms - no carpet downstairs! Oversized master suite. Floor to ceiling stone fireplace. Granite countertops in the kitchen with stainless appliances. Open floor plan with high ceilings. Shutters. Private study. Gated community. Walk to community pool/park! HOA takes care of front yard! Excellent location near The Woodlands medical center, shopping, dining & I-45 for an easy commute.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S572700 - HARPER\'S PRESERVE 01, BLOCK 5, LOT 65' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11244' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1027' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Harpers Preserve 01' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227300' WHERE `Matrix_Unique_ID` = '213774525' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T05:26:46.500' ,`MLSNumber` = '54313496' ,`ListAgentFullName` = 'Kristina Newcomb' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.906076' ,`Longitude` = '-95.318226' ,`PhotoCount` = '22' ,`PostalCode` = '77039' ,`RoomCount` = '6' ,`ListPrice` = '160000.00' ,`Status` = 'Active' ,`StreetName` = 'Charriton' ,`StreetNumber` = '4911' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '990' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3 bedroom 1.5 bath home with attached 2 car garage plus carport located on a spacious lot in the heart of Fairgreen. The family room has tile flooring and opens to the dining/breakfast room with access to the fenced back yard. Plenty of cabinets for storage and counter space for prepping great meals in the light and bright kitchen with gas cooking. Split plan primary with two addtional bedrooms. One full bath with an additional half bath. Large front and back yards. Easy access to 59 and Beltway 8. Close to shopping and dining. Call today for a private tour.' ,`Acres` = '0.1716' ,`Area` = '34' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 132 BLK 8 FAIRGREEN SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'OLESON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MACARTHUR HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'MEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairgreen Sec 01 R/P' ,`TaxAmount` = '3295' ,`TaxRate` = '2.9881' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227300' WHERE `Matrix_Unique_ID` = '213808311' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T05:31:16.517' ,`MLSNumber` = '38474668' ,`ListAgentFullName` = 'Kristina Newcomb' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.883375' ,`Longitude` = '-95.333247' ,`PhotoCount` = '24' ,`PostalCode` = '77093' ,`RoomCount` = '8' ,`ListPrice` = '170000.00' ,`Status` = 'Active' ,`StreetName` = 'Brea Crest' ,`StreetNumber` = '3519' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1135' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated 3 bedroom 1.5 bath one story located on a large, shaded corner lot in Oakwilde. Tile flooring flows through out the home, enter into the family room with bay window for tons of natural light, white cabinetry and appliances in the sunny kitchen with adorning breakfast/dinning room with access to the backyard, gas cooking, double basin stainless kitchen sink, garage has been converted into a large storage room with utility room, primary has en-suite half bath, two secondary bedrooms and full bath complete the home, large backyard with shade trees. Easy access to 45, 69, Hardy Toll Rd ND 610. Close to shopping, dining and parks. Aldine ISD. Call today for a private showing' ,`Acres` = '0.2297' ,`Area` = '34' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 669 BLK 31 OAKWILDE SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '10005' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'WORSHAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MACARTHUR HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'MEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oakwilde Sec 03' ,`TaxAmount` = '2183' ,`TaxRate` = '2.1553' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227300' WHERE `Matrix_Unique_ID` = '213808640' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T05:11:37.670' ,`MLSNumber` = '21827438' ,`ListAgentFullName` = 'Sandra Sawyer' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.645732' ,`Longitude` = '-95.225982' ,`PhotoCount` = '17' ,`PostalCode` = '77034' ,`RoomCount` = '8' ,`ListPrice` = '219999.00' ,`Status` = 'Active' ,`StreetName` = 'Edgebrook' ,`StreetNumber` = '531' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1390' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You’ve got to come see all the updates in this recently remodeled home! Windows, central A/C, furnace, bathrooms, stainless appliances including double-oven, water heater, cabinets, lighting, flooring, all recently replaced. Second bathroom straight down the hall so convenient for your guests, giving you a private bathroom! Vacant and ready to move in! Conveniently located to I-45 & Beltway 8 (Sam Houston tollway), you can zip to downtown, or all around Houston, or down to the beach! And no HOA for added freedoms with ownership!' ,`Acres` = '0.1655' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 56 FREEWAY MANOR SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7209' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'FREEMAN ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'MILLER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Freeway Manor' ,`TaxAmount` = '3777' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227301' WHERE `Matrix_Unique_ID` = '213817683' --> Updated record success