Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T18:08:17.890' ,`MLSNumber` = '44423250' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.361857' ,`Longitude` = '-95.502989' ,`PhotoCount` = '7' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '306649.00' ,`Status` = 'Active' ,`StreetName` = 'Myrtle Oak' ,`StreetNumber` = '2023' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1833' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready June 2022! Volume ceilings in the Yellowstone’s foyer make a striking impression. Linen cabinets with white-toned quartz countertops, beige tone EVP flooring with dark gray tweed carpet in our Balanced package. Easy access to I-45 makes it simple to get to work or play quickly. Located in the fast-growing City of Conroe, these affordable homes are located in the desirable Willis ISD. Nearby shopping, dining, and entertainment mean you don’t need to venture far for a night out. Each energy-efficient home also comes standard with features that go beyond helping you save on utility bills—they allow your whole family to live better and breathe easier too.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0159 Plan N307B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Oaks' ,`TaxAmount` = '' ,`TaxRate` = '3.13' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697700' WHERE `Matrix_Unique_ID` = '203915105' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T18:05:40.070' ,`MLSNumber` = '34347679' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.478620' ,`Longitude` = '-95.455126' ,`PhotoCount` = '8' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '355077.00' ,`Status` = 'Active' ,`StreetName` = 'Melrose' ,`StreetNumber` = '7207' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2336' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready October 2022! Brick and Stone front accent with accent shutters. Upgraded front door and Blinds included. Sleek Interior Package with EVP flooring throughout in many areas downstairs. Many included features with each Meritage Home at Glendale Lakes include rear covered patio, brick front accent, M Connected features, Spray Foam insulation, tankless water heater, grand kitchen island, sodded back yard, front gutters and many other included features. Located in the acclaimed Fort Bend ISD, Glendale Lakes is nestled in Rosharon with great access to nearby dining, entertainment and retail with major employment centers such as the Houston Medical Center, Galleria and Hobby Airport all just a short drive away. With an onsite elementary school, you\'ll relax knowing the kids don\'t have to travel far. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0328 Plan 870B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697700' WHERE `Matrix_Unique_ID` = '206954272' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T18:05:59.880' ,`MLSNumber` = '73707730' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.479552' ,`Longitude` = '-95.452766' ,`PhotoCount` = '7' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '327980.00' ,`Status` = 'Active' ,`StreetName` = 'Melrose' ,`StreetNumber` = '7106' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready October 2022! Brick and stone accent at front. Upgraded front door and blinds included. Cool Interior Package with Ceramic Tile flooring throughout in many areas. Many included features with each Meritage Home at Glendale Lakes include rear covered patio, brick front accent, M Connected features, Spray Foam insulation, tankless water heater, grand kitchen island, sodded back yard, front gutters and many other included features. Located in the acclaimed Fort Bend ISD, Glendale Lakes is nestled in Rosharon with great access to nearby dining, entertainment and retail with major employment centers such as the Houston Medical Center, Galleria and Hobby Airport all just a short drive away. With an onsite elementary school, you\'ll relax knowing the kids don\'t have to travel far. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0357 Plan 830B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697700' WHERE `Matrix_Unique_ID` = '207046021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T18:06:20.643' ,`MLSNumber` = '3545381' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.479234' ,`Longitude` = '-95.452165' ,`PhotoCount` = '8' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '364777.00' ,`Status` = 'Active' ,`StreetName` = 'Bryman' ,`StreetNumber` = '1218' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2336' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready October 2022! Front Porch with Brick and stone accent. Upgraded front door and Blinds included. Elemental Interior Package with EVP flooring throughout in many areas downstairs. Many included features with each Meritage Home at Glendale Lakes include rear covered patio, brick front accent, M Connected features, Spray Foam insulation, tankless water heater, grand kitchen island, sodded back yard, front gutters and many other included features.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0332 Plan 870C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697700' WHERE `Matrix_Unique_ID` = '207046301' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T18:06:09.833' ,`MLSNumber` = '62723401' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.479234' ,`Longitude` = '-95.452916' ,`PhotoCount` = '8' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '361865.00' ,`Status` = 'Active' ,`StreetName` = 'Melrose' ,`StreetNumber` = '7114' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2336' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready October 2022! Front Porch with Brick and stone accent. Upgraded front door and Blinds included. Crisp Interior Package with Ceramic Tile flooring throughout in many areas downstairs. Many included features with each Meritage Home at Glendale Lakes include rear covered patio, brick front accent, M Connected features, Spray Foam insulation, tankless water heater, grand kitchen island, sodded back yard, front gutters and many other included features. Located in the acclaimed Fort Bend ISD, Glendale Lakes is nestled in Rosharon with great access to nearby dining, entertainment and retail with major employment centers such as the Houston Medical Center, Galleria and Hobby Airport all just a short drive away. With an onsite elementary school, you\'ll relax knowing the kids don\'t have to travel far. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0355 Plan 870C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697700' WHERE `Matrix_Unique_ID` = '207047167' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T18:26:52.460' ,`MLSNumber` = '6569118' ,`ListAgentFullName` = 'Emma Valdes' ,`ListOfficeName` = 'ChoiceStar Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.019705' ,`Longitude` = '-95.476385' ,`PhotoCount` = '41' ,`PostalCode` = '77068' ,`RoomCount` = '8' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Encreek Road' ,`StreetNumber` = '2411' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2055' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful upgraded 4 bedroom home! It\'s located on a well established neighborhood with large lots and mature trees. This home features recent upgrades such as tile flooring throughout the home and paint. The kitchen was upgraded with granite countertops, kitchen cabinets, sink, vent hood, backsplash, water and lighting fixtures. It has a formal dining, breakfast and study. Primary bedroom on first floor. The bathrooms were upgraded with cabinetry, mirrors, granite countertops, sinks, lighting and water fixtures. There is a secondary bedroom downstairs. New large porch and circular driveway. Large back yard with covered patio. The detached garage has front and back door with an extra wide concrete driveway and iron gate. Located in the 100 year floodplain. No HOA fees and no MUD taxes. Great location with easy access to major roads and freeways. Close to The Woodlands and GB International Airport. Call today to schedule a private viewing!' ,`Acres` = '' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 279 Bammel Forest Sec. 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '19200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PONDEROSA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bammel Forest' ,`TaxAmount` = '4332' ,`TaxRate` = '2.0892' ,`WaterSewer` = 'Public Sewer,Public Water,Septic Tank' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697701' WHERE `Matrix_Unique_ID` = '210704094' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T18:23:50.697' ,`MLSNumber` = '72210080' ,`ListAgentFullName` = 'Marilly Mendez' ,`ListOfficeName` = 'Worth Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.807516' ,`Longitude` = '-94.994067' ,`PhotoCount` = '13' ,`PostalCode` = '77521' ,`RoomCount` = '9' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Taino' ,`StreetNumber` = '4503' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2293' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you are looking for a great home in a great location, this is it! Cozy, corner lot home located in Meadowlake!! Once inside, you\'ll have a formal dining room, a spacious kitchen and a breakfast area, followed by a family room. Primary bedroom is downstairs and the secondary bedrooms and game room are upstairs . Great size backyard! Meadowlake Village offers a community pool, tennis and basketball courts, playground area and a park with a walking trail. Conveniently located close to all the shopping, dining, and major highways.' ,`Acres` = '0.1874' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 MEADOWLAKE VILLAGE SEC 7' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8162' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '440' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Photos/No Videos,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadowlake Village Sec 07' ,`TaxAmount` = '6149' ,`TaxRate` = '2.755' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697701' WHERE `Matrix_Unique_ID` = '211223592' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T19:01:56.900' ,`MLSNumber` = '91170247' ,`ListAgentFullName` = 'Warren Green' ,`ListOfficeName` = 'Weichert, Realtors - BCS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.104110' ,`Longitude` = '-95.391021' ,`PhotoCount` = '18' ,`PostalCode` = '77386' ,`RoomCount` = '7' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Caroline Park Ln' ,`StreetNumber` = '2306' ,`StreetSuffix` = '' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This fantastic 4 bedroom, 2 bathroom plus an office that could double as a 5th bedroom home is in a prime location on a corner lot, being close to community pool, and amenities, near The Woodlands Market street and the mall, huge HEB and great schools. Spring Trails offers easy access to Grand Parkway, Hardy Toll Road and I-45.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SPRING TRAILS 01, BLOCK 1, LOT 56' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BROADWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Barndominium,Traditional' ,`Subdivision` = 'Spring Trails' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697701' WHERE `Matrix_Unique_ID` = '211305429' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T19:32:56.393' ,`MLSNumber` = '62580533' ,`ListAgentFullName` = 'Billie Harris' ,`ListOfficeName` = 'RE/MAX East' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.763922' ,`Longitude` = '-95.041476' ,`PhotoCount` = '38' ,`PostalCode` = '77520' ,`RoomCount` = '7' ,`ListPrice` = '1275000.00' ,`Status` = 'Active' ,`StreetName` = 'Winkler' ,`StreetNumber` = '303' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3557' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom-Built Home in a private location along Burnet Bay...Upon arrival, whether you enter through the elevator, the front dual staircase, or the travertine stairs in the oversized breezeway; you\'re sure to immediately feel the quality and custom features this home offers! The first floor features a Chef\'s Kitchen, a Living Room with windows to showcase the Baytown Nature Reserve directly behind the property, two guest bedrooms and a home office. The Primary Suite resides on its own level and has a Private Balcony facing the bay, and the more than 4 acres of mature trees provide privacy that compare to none! In addition to all this, the home is built with concrete pillars instead of typical wood pillars and was built to exceed the Hurricane Standards and provide excellent peace of mind and security during our famous Texas Storms! This Custom Home is unlike any other and is sure to impress with its views, privacy, custom details, and all it has to offer! Welcome to Paradise!' ,`Acres` = '4.26' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 1 and 2 DALE MORRIS' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '185783' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '75' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Pointe Royale' ,`TaxAmount` = '15069' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697701' WHERE `Matrix_Unique_ID` = '211359836' --> Updated record success