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-09-04T20:23:05.497' ,`MLSNumber` = '59463781' ,`ListAgentFullName` = 'Shirah Kennedy' ,`ListOfficeName` = 'Coldwell Banker Southern Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.867646' ,`Longitude` = '-94.331665' ,`PhotoCount` = '35' ,`PostalCode` = '77622' ,`RoomCount` = '3' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Powers' ,`StreetNumber` = '13651' ,`StreetSuffix` = 'Road' ,`City` = 'Hamshire' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare Find... Quiet and secluded on 6 acres with plenty of room to build and grow! Large open concept living. Updated kitchen and baths. Huge bedrooms and living areas. Enjoy your backyard gatherings under the covered patio, abundance of room for the entire family. Plenty of space to store campers, toys, build your barn, garden, etc. Call today to schedule your showing!' ,`Acres` = '6' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 2 14 KOCH 135 T&NO 6.000' ,`LotDesciption` = 'Cleared' ,`LotSize` = '261360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '110 - Hamshire-Fannett' ,`SchoolElementary` = 'HAMSHIRE-FANNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HAMSHIRE-FANNETT HIGH SCHOOL' ,`SchoolMiddle` = 'HAMSHIRE-FANNETT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Ranch' ,`Subdivision` = 'KOCH' ,`TaxAmount` = '3586' ,`TaxRate` = '2.0781' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706828' WHERE `Matrix_Unique_ID` = '202526046' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T21:38:18.603' ,`MLSNumber` = '46605584' ,`ListAgentFullName` = 'Pam Schwertner' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.385877' ,`Longitude` = '-95.130902' ,`PhotoCount` = '26' ,`PostalCode` = '77517' ,`RoomCount` = '6' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Walnut' ,`StreetNumber` = '15117' ,`StreetSuffix` = 'Street' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1790' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Comfortable country living three bedroom brick home with up-dates throughout. BONUS: Cottage with one bedroom, 1 full bath, kitchen, and great storage, and handicap ramps. Spacious living room with high ceilings, beautiful up-dated kitchen with abundance of storage. Split bedroom master bedroom with generous master bath.\r\nEnjoy outdoor entertainment this is the place to be with above ground pool. Bring your animals or use as extra storage barn included. Considerable frontage on Walnut with large trees on lot.' ,`Acres` = '1.049' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 613 I & G N RR SUR SEC 19 PT OF LOT F (6-3) BLK 79 ANGE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '45695' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'ROY J. WOLLAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Angell-Runge Add' ,`TaxAmount` = '5511' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706829' WHERE `Matrix_Unique_ID` = '209639746' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T21:29:18.867' ,`MLSNumber` = '52676987' ,`ListAgentFullName` = 'Diane Sumphunvivat' ,`ListOfficeName` = 'Midland Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.564915' ,`Longitude` = '-95.585893' ,`PhotoCount` = '25' ,`PostalCode` = '77479' ,`RoomCount` = '4' ,`ListPrice` = '660000.00' ,`Status` = 'Active' ,`StreetName` = 'Dogwood Canyon' ,`StreetNumber` = '3922' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3036' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1848' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERSTONE NORTH SEC 4, BLOCK 1, LOT 3' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SETTLERS WAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverstone North Sec 4' ,`TaxAmount` = '9757' ,`TaxRate` = '2.4529' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706829' WHERE `Matrix_Unique_ID` = '209907785' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T20:22:25.840' ,`MLSNumber` = '67956201' ,`ListAgentFullName` = 'Christina Shyu' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.718078' ,`Longitude` = '-95.783268' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '12' ,`ListPrice` = '928999.00' ,`Status` = 'Active' ,`StreetName` = 'San Clemente Point' ,`StreetNumber` = '7606' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3953' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LAKEFRONT. PREVIOUS WESTPORT MODEL HOME IN AVALON @ SEVEN MEADOWS THIS DESIRABLE GREAT NEIGHBORHOOD. UPDATED RECENTLY---GORGEROUS NEWLY FRESH PAINTED STUCCO EXTERIOR, STUNNING OPEN CONCEPT ENTERIOR DESIGN WITH CLASSIC ARCHITECTURE DETAILS. NEWLY DESIGNER\'S PAINT THROUGHOUT THE INTERIOR WALL WITH ACCENT PAINT IN LIVING (OPEN OFFICE), DINING AND KITCHEN. 14\' HIGH CEILING IN FORMAL LIVING ( CAN BE CONVERTED TO AN OPEN OFFICE ) AND DINING NEWLY INSTALLED ENGINEER WOOD FLOOR. FROM FOYER, HALLWAY, DEN, BREAKFAST AND KITCHEN AREA NEWLY FLOORED WITH LUXUARY VINYL PLANK. GOURMET KITCHEN WITH FULLY BUILT-IN APPLIANCES INCLUDING REFRIGERATOR, MICROWAVE, AND DOUBLE OVEN, NEW KHOLER\'S INDUSTRIAL STYLE FAUCET, GRANITE COUNTERTOP. NEWLY FRESH PAINTED CABINETS IN KITCHEN, MASTER BATH AND UPSTAIRS JACK & JILL BATH...DOWN STAIRS GUEST SUITE CAN BE IN-LAW\'S ROOM. SPACIOUS MASTER BEDROOM WITH SITTING AREA. HUGE GAME ROOM UPSTAIR WITH ONE FEXIBLE ROOM WHICH CAN BE USE AS EXERCISE RM.' ,`Acres` = '0.3087' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON AT SEVEN MEADOWS SEC 1, BLOCK 1, LOT 15' ,`LotDesciption` = 'Cul-De-Sac,Waterfront' ,`LotSize` = '13445' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GRIFFIN ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Avalon At Seven Meadows Sec 1' ,`TaxAmount` = '18428' ,`TaxRate` = '2.3845' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706829' WHERE `Matrix_Unique_ID` = '209943656' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T20:43:58.113' ,`MLSNumber` = '31879707' ,`ListAgentFullName` = 'Daniel Delk' ,`ListOfficeName` = 'Central Metro Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.059433' ,`Longitude` = '-95.476075' ,`PhotoCount` = '33' ,`PostalCode` = '77388' ,`RoomCount` = '4' ,`ListPrice` = '349449.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Key' ,`StreetNumber` = '3806' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2656' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '15 minutes from the Woodlands Mall. This 4 bedroom 2.5 bath and 2.5 detached garage is a great place to raise the family. Great Klein school district in a great neighborhood. Open floor plan with tile and wooden floors with a gas fireplace. Spacious master bath and master closet. Stainless steel appliances, and large utility room.' ,`Acres` = '0.2014' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 CYPRESSWOOD GLEN ESTATES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HAUDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Glen Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706829' WHERE `Matrix_Unique_ID` = '210400977' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T21:12:09.153' ,`MLSNumber` = '12789197' ,`ListAgentFullName` = 'Seda Hambarchian' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.690465' ,`Longitude` = '-95.719047' ,`PhotoCount` = '25' ,`PostalCode` = '77407' ,`RoomCount` = '7' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Mustang Pointe' ,`StreetNumber` = '19222' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1835' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning totally remodeled one story 4 bedroom 2 bathroom home on a quiet cul de sac. This home features an inviting front porch area, high ceiling, split floor plan, open layout, fireplace and much more. As you walk into the home, you are greeted by arched doorways and newly installed tile throughout the living area. Kitchen is totally remodeled and has plenty of cabinets, counter space, breakfast area & is open to dining area & den. Large master with Updated gorgeous slate walk in shower! Totally updated guest bathroom. Brand new carpets in all bedrooms. Mancave with custom shelves in garage and water softener! Massive back covered patio area great for entertaining. No backyard neighbors! Community has great amenities. waterpark, gym,2 pools, hiking & biking trails, basketball court, clubhouse, fitness center, multiple parks and more! Walking distance to elementary school. LOW TAXES AND LOW HOA.Minutes from 99 and Westpark tollway, restaurants, shopping, and entertainment and more.' ,`Acres` = '0.1481' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND MISSION SEC 12, BLOCK 1, LOT 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Mission Sec 12' ,`TaxAmount` = '5123' ,`TaxRate` = '2.5097' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706829' WHERE `Matrix_Unique_ID` = '210660816' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T21:38:27.980' ,`MLSNumber` = '53828686' ,`ListAgentFullName` = 'Caylee Loville' ,`ListOfficeName` = 'Nextgen Real Estate Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.094827' ,`Longitude` = '-95.539901' ,`PhotoCount` = '24' ,`PostalCode` = '77375' ,`RoomCount` = '6' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Still Pond' ,`StreetNumber` = '22906' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2241' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 22906 Still Pond Dr! This gorgeous home located off of the Grand Parkway (99) features all laminate and tile flooring, a spacious one story floor plan, fireplace, and an oversized master bedroom. The open concept kitchen, which over looks the family room and has direct access to your formal dining, offers granite countertops and stainless steel appliances. Your private primary suite is tucked away from every other bedroom and offers its own study corner, perfect for working from home or simply creating a space to unwind. The primary bath gives you a spa like feel with your own stand up shower and oversized soaking tub. Additionally it offers a dual vanity, private toilet and an oversized walk-in closet. As a final point per seller the home features upgrades such as roof (7/2021), HVAC (4/2020), ductwork and coiling (4/2020), water heater (4/2022), and a fence (7/2021)!\r\n\r\nPlease call to schedule your showing today!' ,`Acres` = '0.1515' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 38 BLK 1 CREEKSIDE PLACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'SCHULTZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekside Place Sec 01' ,`TaxAmount` = '6406' ,`TaxRate` = '2.8765' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706829' WHERE `Matrix_Unique_ID` = '211277030' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T21:43:56.153' ,`MLSNumber` = '60351027' ,`ListAgentFullName` = 'Ashly Kirkland' ,`ListOfficeName` = 'Real Broker, LLC' ,`SellingAgentFullName` = 'Wesley Ferguson' ,`SellingOfficeName` = 'Texas United Realty' ,`Latitude` = '29.975286' ,`Longitude` = '-95.181546' ,`PhotoCount` = '28' ,`PostalCode` = '77346' ,`RoomCount` = '19' ,`ListPrice` = '550000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Kinkaid Meadows' ,`StreetNumber` = '12715' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4285' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Village Builder home (Classic Series, \'\'Van Gogh\'\' Design with Brick Elev. B) in highly sought-after Eagle Springs! This home boasts 5 large bedrooms (primary and one guest bedroom on the first floor), a large study on the first floor and a secondary built-in study nook on the second floor, game room and media room on the second floor, utility room with convenient access from the primary bedroom and hallway (near one of two butler\'s pantries), large covered patio with stamped concrete finish, and 3-car garage with custom floor coating! Prime location in Eagle Springs, with tons of community amenities (clubhouse, fitness center, sports complex, two pools, splash pad, events, etc). Both AC units replaced in June 2022 (AC and coils) with 10 year extended warranty until 2032. At an amazing price, come see this gem today!' ,`Acres` = '0.2086' ,`Area` = '1' ,`BuilderName` = 'Village Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 EAGLE SPRINGS SEC 38' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9086' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'EAGLE SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Spgs Sec 38' ,`TaxAmount` = '12610' ,`TaxRate` = '2.913' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706829' WHERE `Matrix_Unique_ID` = '211578771' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T20:04:33.297' ,`MLSNumber` = '38246074' ,`ListAgentFullName` = 'Nicole Garner' ,`ListOfficeName` = 'Windsor Hill Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.800991' ,`Longitude` = '-95.111324' ,`PhotoCount` = '12' ,`PostalCode` = '77360' ,`RoomCount` = '6' ,`ListPrice` = '125000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeview Wood' ,`StreetNumber` = '142' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '874' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable 2-3 bedroom manufactured home in the quiet lakeside community of Impala Woods. The main house features a split floor plan with independent window units in every room. Subfloor has recently been repaired and PEX plumbing installed. Culverts added just before listing. The low HOA fees and a community boat launch, make this a perfectly affordable weekend retreat or rental! All appliances included with sale.' ,`Acres` = '0.0964' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'IMPALA WOODS SECTION 4 BLK 4 LOT 7 & 8 SERIAL# N/A HUD# N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '170' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Impala Woods' ,`TaxAmount` = '393' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706830' WHERE `Matrix_Unique_ID` = '211633281' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212167677','1663706830','212167677','2022-09-04T21:33:53.690','25027455','Toyia Chenevert','Re/MAX Universal','','','30.140695','-95.395751','33','77386','4','305000.00','Active','Crescent Oaks Park','3107','Lane','Spring','3','0','4','2013','Single-Family','This magnificent 4 bedroom 3 bath 1.5 Story home is located in the Master Planned community of Imperial Oaks. The open and airy family room has tons of natural light all open to the sleek and stylish gourmet kitchen equipped with stainless steel appliances, tons of cabinets for storage, all open to the family room which makes it the perfect spot to connect with family and friends. Unwind in your luxurious Primary Retreat with a beautiful bath featuring dual sinks, soaking tub, separate shower and walk-in closet. Step upstairs where you will find a secondary bedroom, full bath and spacious game room. Not to mention the outdoor shed, water softener and filtration system.','0.1218','15','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','','','Spring Northeast','Central Gas','1','S612111 - IMPERIAL OAKS PARK 11, BLOCK 1, LOT 11','Subdivision Lot','5306','Appraisal District','','500','0','','2','Single Oven','0','','','Freestanding Range,Gas Range','','Composition','11 - Conroe','KAUFMAN ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Accompany,Leave Business Card,Supra Keybox','Appraisal District','1.5','Traditional','Imperial Oaks Park 11','6016','2.7627','Water District','2008','Appraisal District'); --> New record created successfully