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-25T05:59:50.397' ,`MLSNumber` = '12798540' ,`ListAgentFullName` = 'Kenneth Purswell' ,`ListOfficeName` = 'Kenneth Purswell - Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.086984' ,`Longitude` = '-95.280441' ,`PhotoCount` = '30' ,`PostalCode` = '77541' ,`RoomCount` = '11' ,`ListPrice` = '429000.00' ,`Status` = 'Active' ,`StreetName` = 'Flounder' ,`StreetNumber` = '2' ,`StreetSuffix` = 'Circle' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1605' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique opportunity on Demijohn Island, Home built 2020 excellent residence or weekend retreat, in exceptionally family friendly neighborhood, this is a must see!. Bright, open living, dining and kitchen with lots of windows to enjoy the views. Boat slip (24x 9.5) with lift (6,000 lb. capacity) High Bay (12’Hx12.5’W) Community has pool and boat ramp. Coastal Living on Bastrop Bayou, Bastrop Marina nearby. Waterway access to Bastrop, Christmas, West Galveston Bays, San Louis Pass, Brazoria National Wildlife Refuge, Surfside Beach 14 mile drive.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'DEMIJOHN ISLAND SEC 4 (A0157 G M BRYAN) LOT 1' ,`LotDesciption` = 'Corner,Subdivision Lot,Waterfront' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'DemiJohn Island' ,`TaxAmount` = '' ,`TaxRate` = '2.358893' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666695954' WHERE `Matrix_Unique_ID` = '209855007' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T05:38:03.723' ,`MLSNumber` = '35719095' ,`ListAgentFullName` = 'Janet Schmidt' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.679806' ,`Longitude` = '-95.489777' ,`PhotoCount` = '13' ,`PostalCode` = '77096' ,`RoomCount` = '7' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Braesvalley' ,`StreetNumber` = '5719' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1842' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is ready for someone to make their home. Total redo.' ,`Acres` = '0.1901' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 20 BLK 5 MAPLEWOOD NORTH SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HEROD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Maplewood North' ,`TaxAmount` = '4451' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666695954' WHERE `Matrix_Unique_ID` = '211911178' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T05:54:20.367' ,`MLSNumber` = '95975133' ,`ListAgentFullName` = 'Johnathan Callery' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.303529' ,`Longitude` = '-94.777107' ,`PhotoCount` = '25' ,`PostalCode` = '77550' ,`RoomCount` = '26' ,`ListPrice` = '1200000.00' ,`Status` = 'Active' ,`StreetName` = '10th' ,`StreetNumber` = '1013' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '6' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '4110' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property was designed with a Beautiful split floor plan design and is located in an upcoming neighborhood, \"Palms Of Galveston\". 1013 10th St. is perfectly designed to accommodate the entire family PLUS additional friends. Located in a prime location on Galveston Island, this home has a total of 6 bedrooms, 6.5 bathrooms, 2 open kitchen concepts, Luxury Finishes, multiple Balconies with views of the Gulf of Mexico, and an abundance of parking to accommodate family and friends. The property is located minutes from the UTMB Medical District, The Beach, Strand District, and Highly Desired restaurants. Furthermore, situated off the garage is a private patio space that was designed to be easily converted into a one bedroom, one bathroom additional living unit. Please take the time to view the virtual tour link attached to the listing.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Al Hoda Enterprises' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOTS 8 & 9 (8-100) BLK 130 GALVESTON' ,`LotDesciption` = 'Other,Water View' ,`LotSize` = '4800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '8368' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666695955' WHERE `Matrix_Unique_ID` = '212186090' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T05:40:00.567' ,`MLSNumber` = '50098506' ,`ListAgentFullName` = 'Rachel Shaw' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.295715' ,`Longitude` = '-95.417458' ,`PhotoCount` = '39' ,`PostalCode` = '77301' ,`RoomCount` = '7' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Fox Ledge' ,`StreetNumber` = '2961' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home!! This gorgeous 4 bedroom, 2 bathroom home boasts so many updates/upgrades, including a chef\'s kitchen with a 5 gas burner range and double ovens, granite countertops, 10 ft windows for tons of natural light, huge backyard oasis perfect for entertaining, plus so much more. Ladera Creek residents enjoy the walking trails and the convenience of plentiful nearby surrounding amenities, from an abundance of outdoor recreation spots, such as the nearby Sam Houston National Park, Carl Barton Jr. Park, and sparkling Lake Conroe, to fantastic shopping destinations such as the Outlets at Conroe. Come see this beautiful home, it won\'t last long.' ,`Acres` = '0.1722' ,`Area` = '19' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S646902 - LADERA CREEK 02, BLOCK 1, LOT 16' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12196' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RUNYAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ladera Creek 02' ,`TaxAmount` = '8152' ,`TaxRate` = '3.0863' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666695955' WHERE `Matrix_Unique_ID` = '212659058' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T05:54:35.717' ,`MLSNumber` = '19140535' ,`ListAgentFullName` = 'Joy Samuel' ,`ListOfficeName` = 'Prompt Realty & Mortgage, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.531733' ,`Longitude` = '-95.472538' ,`PhotoCount` = '30' ,`PostalCode` = '77545' ,`RoomCount` = '4' ,`ListPrice` = '519999.00' ,`Status` = 'Active' ,`StreetName` = 'San Bernard' ,`StreetNumber` = '2727' ,`StreetSuffix` = 'Drive' ,`City` = 'Fresno' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2889' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Loan Assumable. Never lived, ready to move in, 2022 built One of a kind spacious single story Ashton woods Hanover model. No more lots available to build this model. 40k upgrades. Incredible energy efficient 4-bedroom 3.5 bath, tandem three car garage, 8ft doors everywhere, Full Bricks around with stone front. High ceiling, formal dining, wow huge kitchen island opens to family room, 42\" cabinets, pull out double trash can under the countertop, remote controlled fireplace, large utility, 2 bathrooms with standing showers, primary bath with Jacuzzi & shower. Gameroom/media room, bedrooms and family rooms are with carpet, entry dining etc. with tiles, covered patio with gas line, hot/cold water line for outside kitchen, sprinkler system, garage door opener, 2\" fox wood blinds for all windows. see to believe this GEM.........! Easy access to Hwy 6 and Fort Bend Toll. Fort bend School district and utilities even though in Fresno.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'AW' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7, Block 2 Shipman\'s Cove sec-2' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'GOODMAN ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shipman\'s Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.29' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666695955' WHERE `Matrix_Unique_ID` = '212968717' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T04:57:27.373' ,`MLSNumber` = '4630657' ,`ListAgentFullName` = 'Janet Schmidt' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.794866' ,`Longitude` = '-95.435364' ,`PhotoCount` = '31' ,`PostalCode` = '77008' ,`RoomCount` = '7' ,`ListPrice` = '535000.00' ,`Status` = 'Active' ,`StreetName` = 'Seaspray' ,`StreetNumber` = '1338' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1789' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1921' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 42 BLK 51 TIMBERGROVE MANOR SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8370' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timbergrove Manor' ,`TaxAmount` = '9962' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666695955' WHERE `Matrix_Unique_ID` = '213216564' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-25T05:55:03.750' ,`MLSNumber` = '8358038' ,`ListAgentFullName` = 'Johnathan Callery' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.295646' ,`Longitude` = '-94.915452' ,`PhotoCount` = '22' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '815000.00' ,`Status` = 'Active' ,`StreetName` = 'Hawaii' ,`StreetNumber` = '1303' ,`StreetSuffix` = 'Drive' ,`City` = 'Tiki Island' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1578' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing Deal! Home located On A LARGE CORNER LOT, directly on the canal. Property is also equipped with a nice sized vacant piece of land that will give new home owners multiple options for utilizing and building on. 1303 Hawaii Dr. features three bedrooms, two bathrooms, A large open living and kitchen combination with HIGH CEILINGS and beautifully EXPOSED BEAMS. Each bathroom is equipped with large walk-in showers plus the home also includes a luxury Over-Sized Jetted Tub that heats up to 104°, perfect for relaxing. The first level has a large covered patio space perfect for family gatherings or entertainment. The Owners recently replaced the entire patio deck flooring which provides multiple scenic views of Tiki and the Canal. A nice over-sized garage, plus plenty of additional parking to accommodate family and friends. Situated right on the canal, you have a BOAT SLIP and DIRECT ACCESS to the Gulf of Mexico at your leisure. Please View Virtual Video Tour and schedule a tour.' ,`Acres` = '0.21' ,`Area` = '33' ,`BuilderName` = 'N/A' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S C BUNDICK SUR LOT 72 TIKI ISLAND SEC 3' ,`LotDesciption` = 'Corner,Water View,Waterfront' ,`LotSize` = '9148' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Tiki Island 3' ,`TaxAmount` = '6519' ,`TaxRate` = '2.4912' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666695956' WHERE `Matrix_Unique_ID` = '213487865' --> 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','213665506','1666695956','213665506','2022-10-25T04:48:31.520','33458311','Lily Nguyen','New Trans Realty ','','','29.766894','-95.696143','50','77094','14','2067000.00','Active','Windsor Lakes','18711','Drive','Houston','6','1','5','8648','Single-Family','Stuning, custom-built home in gated guarded community. A must see house, resort style living in a red roof tile and manmade lake subdivision. Fabulous 8,648 SF , 2-story home 5 beds room and 6 ½ baths , 3-car garage , features with loaded upgrade. Brick drive way. Iron fencing, pool/patio, pergola, detached gazebo. Open concept living spaces. Grand entry with two stairs ways ,high ceiling , large lounge and two bar areas located on the first and second floor , huge master bed room on the first floor with sitting area, a gourmet kitchen, granite counter top formal dinning room , family room with dining area, fireplace. Outdoor kitchen built with enclosure. Utilities room on first floor. Second floor includes game room, theater room and 4 bedrooms and balcony area. Granite mostly on the first floor. Buyers should verify room sizes & Sq.Ft. Furniture and accessories are negotiable.\r\nProof of funds/Pre-approval required prior to showing.','0.2995','36','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','2','Katy - Southeast','Central Gas','1','LT 3 BLK 2 WINDSOR PARK LAKES SEC 4','Subdivision Lot','13046','Appraisal District','','2400','0','','3','Convection Oven,Double Oven,Electric Oven','1','In Ground','','Gas Cooktop','','Tile','30 - Katy','PATTISON ELEMENTARY SCHOOL','TAYLOR HIGH SCHOOL (KATY)','MCMEANS JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal District','2','Mediterranean','Windsor Park Lakes Sec 04','32731','2.3333','Water District','2006','Appraisal District'); --> New record created successfully
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','214033210','1666695956','214033210','2022-10-25T05:51:10.830','10451753','Nicole Handy','Braden Real Estate Group, LLC','','','29.893105','-95.713532','28','77433','4','299000.00','Active','Summerfern','7923','Court','Cypress','2','1','4','2372','Single-Family','This well-kept 4 bedroom 2.5 bath home is ready for owner seeking to grow their investment portfolio! Pride of ownership with only 1 owner. This 2 story home is move-in ready with fresh paint throughout. The living area offers tons of natural light, with an open floorplan. The kitchen features a spacious island, abundant cabinet space, and a walk-in pantry. The Owner’s Retreat includes a luxurious en suite bathroom, 2 closets, and an added BONUS space that can double as a study area. This home is nestled on an oversized cul de sac lot with a huge backyard! Zoned to top-rated Cypress Fairbanks ISD. Conveniently located mins from premier shopping and dining including Houston Premium Outlets and the Towne Lake Boardwalk. Only a short drive to HWY 290, HWY 99, I-10. This property won\'t last long, schedule your tour today!','0.1545','25','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Cypress South','Central Gas','1','LT 58 BLK 3 CYPRESS SPRINGS SEC 4','Cul-De-Sac,Subdivision Lot','6730','Appraisal District','','350','0','','2','Gas Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','ANDRE ELEMENTARY SCHOOL','CYPRESS SPRINGS HIGH SCHOOL','HOPPER MIDDLE SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Cypress Spgs Sec 4','5422','3.041','Public Sewer,Public Water,Water District','2005','Appraisal District'); --> New record created successfully
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','214033229','1666695956','214033229','2022-10-25T05:49:15.983','44235961','Moon Kim','Lifestyles Realty, Inc.','','','29.670255','-95.335568','9','77033','3','164900.00','Active','Kenilwood','5730','Drive','Houston','1','0','3','1150','Single-Family','Located in the established Edgewood subdivision. This recently remodeled home features an updated kitchen with granite counter tops, nice fixtures, and stainless appliances. The restroom has a granite counter top and updated tile surround. Recent roof and HVAC. With easy access to 610, 288, and 45. This one is a MUST SEE!!!','0.1501','3','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Medical Center South','Central Gas','0','LT 15 BLK 13 EDGEWOOD SEC 2','Subdivision Lot','6540','Appraisal District','','','0','','1','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','ALCOTT ELEMENTARY SCHOOL','STERLING HIGH SCHOOL (HOUSTON)','ATTUCKS MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Edgewood Sec 02','','','Public Sewer,Public Water','1940','Appraisal District'); --> New record created successfully