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-03T09:56:21.173' ,`MLSNumber` = '13029179' ,`ListAgentFullName` = 'Eliesa Wright' ,`ListOfficeName` = 'Lawrence Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.341136' ,`Longitude` = '-95.466502' ,`PhotoCount` = '21' ,`PostalCode` = '75835' ,`RoomCount` = '2' ,`ListPrice` = '125000.00' ,`Status` = 'Active' ,`StreetName` = 'Norman' ,`StreetNumber` = '712' ,`StreetSuffix` = 'Lane' ,`City` = 'Crockett' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FRESHLY UPDATED!\r\n This cute two bedroom, one bath home, just minutes outside of Loop 304 in Crockett, TX, has just been remodeled and is ready for it’s new family. Brand new carpet, paint, and an updated kitchen with new flooring, cabinets, countertops, and backsplash really give this home a light and bright, homey feel. There is a front porch to relax on, a welcoming red door, and a nice metal roof. The yard is a good size as well, just add a little bit of fencing and it’s ready for your pets! The attached shop/extra large garage offers plenty of storage space and/or room for projects. Contact us today for a private showing.' ,`Acres` = '0.29' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A E GOSSETT AB 423 .29 AC NEOL 221' ,`LotDesciption` = 'Other' ,`LotSize` = '12632' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '57 - Crockett' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (CROCKETT)' ,`SchoolHigh` = 'CROCKETT HIGH SCHOOL (CROCKETT)' ,`SchoolMiddle` = 'CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'NA' ,`TaxAmount` = '715' ,`TaxRate` = '2.3627' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706264' WHERE `Matrix_Unique_ID` = '205852177' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T09:10:16.150' ,`MLSNumber` = '57668630' ,`ListAgentFullName` = 'Randall Martin' ,`ListOfficeName` = 'CB&A, Realtors- Southeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.566857' ,`Longitude` = '-95.333007' ,`PhotoCount` = '44' ,`PostalCode` = '77581' ,`RoomCount` = '12' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Reid' ,`StreetNumber` = '2341' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1976' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '\"Country in the city\" is calling all you city slickers! If you\'ve been tirelessly hunting for a home w/ guest questers, this would be ideal. Sale includes main home, mobile home & 3 storage buildings sitting on about 2.48 acres in Pearland. Adjacent 4+ acres currently owned by city. This property has so much potential...it would a great opportunity for you to have horses, create rental income, and/or build your custom home in a private location back off of the main road. There is even a RV pad w/ electric hook-up. Roof on the main home was replaced a few years ago & both home & mobile have updated PEX water pipes thanks to the infamous ice storm. Seller says flood water never entered into the main home, nor into the mobile home. Home measurements & square footages listed include main home + mobile. Seller does not have a survey. Buyers are encouraged to verify all information including but not limited to specific uses, restrictions, utility availability, measurements & property lines.' ,`Acres` = '2.4808' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0234 H T & B R R TRACT 26 ACRES 2.4808' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '108064' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'LAWHON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'H T & B R R' ,`TaxAmount` = '3243' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706264' WHERE `Matrix_Unique_ID` = '205956865' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T09:35:47.130' ,`MLSNumber` = '24726462' ,`ListAgentFullName` = 'Judy Emmett' ,`ListOfficeName` = 'Top Guns Realty on Lake Conroe' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.721464' ,`Longitude` = '-95.556393' ,`PhotoCount` = '50' ,`PostalCode` = '77340' ,`RoomCount` = '11' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue O' ,`StreetNumber` = '1304' ,`StreetSuffix` = '' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COMMERCIAL OR RESIDENTIAL! ON .424 ACRES. Plenty of parking , built in 1923. Recognized as one of the beautiful historical homes of Huntsville. Original Craftsman Style architecture. Beaming w/ authentic wood floors throughout, artfully crafted woodwork, tall ceilings & generous room sizes. Large windows provide ample natural light to every room. This house has retained its orginal beauty. Updated baths and kitchen. Built-in cabinets in breakfast room. Built-in book shelves under the stairs .Huge attic with a staircase for entrance. Model T garage! Driveway in front and side of house. Patio. This spectacular brick home is located on approx. .424 Acres, corner lot. Large trees surround the house. The sellers are only the second owners of the property. Residential or Commercial use. Fenced yard , Zoned a/c and heat. The City of Huntsville just bought the property across the street for the City Hall expansion and parking. (Old hospital property) Blocks from Downtown Huntsville and SHSU' ,`Acres` = '0.4248' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'Smither, Lot 10' ,`LotDesciption` = 'Corner' ,`LotSize` = '18506' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SCOTT JOHNSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Smither' ,`TaxAmount` = '3857' ,`TaxRate` = '1.96' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1923' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663706265' WHERE `Matrix_Unique_ID` = '207409039' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T09:57:23.260' ,`MLSNumber` = '49247632' ,`ListAgentFullName` = 'Julio Archila' ,`ListOfficeName` = 'Archila Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.776425' ,`Longitude` = '-95.622434' ,`PhotoCount` = '50' ,`PostalCode` = '77079' ,`RoomCount` = '8' ,`ListPrice` = '585000.00' ,`Status` = 'Active' ,`StreetName` = 'Langwood' ,`StreetNumber` = '735' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2705' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning price reduction!!! MOTIVATED SELLER! SELLER SAYS BRING US AN OFFER ! Ok Best priced Home in this amazing community!!Beautiful two story home located in the prestigious subdivision of Thornwood . Just minutes away from energy corridor, memorial area, I 10 freeway and commercial establishments. Wake up to a nice sun-filled day for a run or bike ride in the renowned Terry Hershey Park Hike and Bike Trail . The park trail is just a 2 minute walk from this house. Enjoy a fun time with family and friends in the new custom built patio kitchen/fireplace with built-in fridge and barb-q grill for special gatherings. This house boasts a great interior lay out with modern tile floors, granite countertops, and a cozy living room spaces for special day occasions. Hurry up and call your realtor today to view this amazing home. It won\'t last long. This home contains a fully remodeled Kitchen. Fully remodeled luxurious primary bath, roof is only 5 years old. BEAUTIFUL HOME!' ,`Acres` = '0.198' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 THORNWOOD SEC 2' ,`LotDesciption` = 'Other' ,`LotSize` = '8625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOLFE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MEMORIAL PARKWAY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Thornwood Sec 02' ,`TaxAmount` = '9308' ,`TaxRate` = '2.4889' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706265' WHERE `Matrix_Unique_ID` = '208944301' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T09:49:49.040' ,`MLSNumber` = '4050992' ,`ListAgentFullName` = 'Crystal Williams' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = 'Michael Parker' ,`SellingOfficeName` = 'Phyllis Foster Real Estate Ser' ,`Latitude` = '29.483232' ,`Longitude` = '-95.125070' ,`PhotoCount` = '46' ,`PostalCode` = '77573' ,`RoomCount` = '10' ,`ListPrice` = '374500.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Lexington' ,`StreetNumber` = '2508' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2499' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 2508 Lexington Court! As you enter this home you will be greeted with a stunning 2 story entry complete with gold custom chandler. This 4 bedroom 2.5 bath home is located in the highly sought after Brittany Lakes Subdivision. The kitchen features new backsplash (2021) and dish washer (2021) and has plenty of space for entertaining. The breakfast area and living room offer views of your private backyard. NO BACK NEIGHBORS! The 2 story living room has a corner fireplace. The primary suite is on the first floor and has an updated separate shower/tub and a double sink vanity. Upstairs you have high performance fiber carpet with stain and soil protect and LifeGuard spill proof backing, installed in 2019. As you go up the stairs you have a game room to the left and 3 bedrooms plus 1 full bathroom to the right. This home has a NEW AC unit (2021) and hot water heater (2021). Come and take a look at this well maintained home.' ,`Acres` = '0.1612' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BRITTANY LAKES SEC 7 (2003) ABST 3 & 9, BLOCK 1, LOT 23, ACR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAUERSCHLAG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brittany Lakes Sec 7 2003' ,`TaxAmount` = '6414' ,`TaxRate` = '2.2667' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706265' WHERE `Matrix_Unique_ID` = '209178606' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T09:23:29.103' ,`MLSNumber` = '47536935' ,`ListAgentFullName` = 'Marian Rohat' ,`ListOfficeName` = 'Ross & Marshall Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.085202' ,`Longitude` = '-95.463388' ,`PhotoCount` = '37' ,`PostalCode` = '77389' ,`RoomCount` = '8' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Rustling Chestnut' ,`StreetNumber` = '3011' ,`StreetSuffix` = 'Street' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2580' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Minutes to The Woodlands and access to 3 major highways.Cozy, comfortable , inviting home.Priced to sell quick as it needs minor cosmetic updates.Four very large bedrooms (master down),2.5 baths, laminate & bamboo floors,upgraded carpet,tile,eat in kitchen,black appliances with built in microwave,Silestone countertops,42\' cabinets,upgraded stainless steel sink,HUGE gameroom with built in desk,jacuzzi tub in master bath,blinds throughout,sodded backyard for the kids,beautifully landscaped and many more upgrades! Gardener playground with lots of outdoor options.A very quiet and tranquil neighborhood with great shopping center nearby. This neighborhood offers a tennis court, playground, private lake with a walking trail.' ,`Acres` = '0.1048' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 3 FOREST RIDGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4565' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '490' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'ZWINK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Forest Rdg Sec 01' ,`TaxAmount` = '6039' ,`TaxRate` = '2.804' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706265' WHERE `Matrix_Unique_ID` = '209240155' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T08:52:54.313' ,`MLSNumber` = '18549109' ,`ListAgentFullName` = 'Monica Rojas' ,`ListOfficeName` = 'RE/MAX 1st Choice' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.379315' ,`Longitude` = '-95.147166' ,`PhotoCount` = '33' ,`PostalCode` = '77517' ,`RoomCount` = '9' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Bluebird' ,`StreetNumber` = '16101' ,`StreetSuffix` = 'Street' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2359' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING THREE BEDROOM, TWO BATH HOME APPX 2,359sq ft ON CUL-DE-SAC LOT AT THE END OF THE ROAD. JUST OVER AN ACRE OF LAND. PRIMARY BATH HAS BEEN TOTALLY RENOVATED AND ALL ROOMS ARE LARGE AND READY TO OCCUPY. SECONDARY BEDROOMS ARE HUGE! BIG OPEN KITCHEN. VAULTED CEILING IN LIVING ROOM. SEPARATE DINING ROOM.TILE FLOORS AND CARPETED BEDROOMS. NEW BACK PATIO DOOR LEADS TO PATIO AREA. FULLY FENCED BACK YARD. DOUBLE WIDE DRIVEWAY WITH A DETACHED THREE CAR GARAGE AND EVEN HAS AN ADDITIONAL ROOM THAT’S AIR CONDITIONED GREAT FOR STORAGE, HOBBY ROOM OR EVEN TO USE AS A STUDIO. ALL LOCATED IN THE COUNTY. NO REAL RULES OR RESTRICTIONS. NICE, QUIET AND PEACEFUL. EXTRA SLAB FOR BOAT OR RV PARKING TOO.' ,`Acres` = '1.105' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 34 C BIGELOW SUR LOT 9 COMPEAN UNRECORDED SUB' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '48134' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`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 Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Compean Bros Unrec' ,`TaxAmount` = '5985' ,`TaxRate` = '2.0881' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706265' WHERE `Matrix_Unique_ID` = '209726891' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T09:03:33.220' ,`MLSNumber` = '8990207' ,`ListAgentFullName` = 'Barry Mosley' ,`ListOfficeName` = 'Blue Dolphin Realty, LLC.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.816156' ,`Longitude` = '-97.223404' ,`PhotoCount` = '49' ,`PostalCode` = '77963' ,`RoomCount` = '3' ,`ListPrice` = '1600000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 622' ,`StreetNumber` = '12448' ,`StreetSuffix` = 'Road' ,`City` = 'Goliad' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2952' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful Property features 3+ bedrooms 2 bathrooms 2952 square foot home. Recently remodeled. Kitchen has all upgraded stainless-steel appliances 6 burner propane cooktop with electric oven, built in convection Microwave and oven, Granite counter tops, large center Island with small sink, electric outlets with usb charging station with a genuinely nice chandelier above. Other Features are the open floor plan Kitchen, living area, and Dining area with vinyl plank flooring thru out, large rooms as well Master bedroom 16’x21’ with a unique master bath, has a weight room, a home office well house with water softener and filter system \r\n\r\nThis property also features two very nice shops the front shop is 2600 square foot with 2 large bays equipped electric, water, and air. One-ton Jib crane\r\n\r\n\r\nSecond shop is awesome 5000 square foot Fabrication shop it is set up with three phase power, 10-ton bridge crane, two-ton JIB Crane,' ,`Acres` = '5.38' ,`Area` = '85' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'J O NEAL R-5 ABS 224 AC 1.00 IMP' ,`LotDesciption` = 'Other' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '549 - Goliad' ,`SchoolElementary` = 'GOLIAD ELEMENTARY SCHOOL (GOLIAD)' ,`SchoolHigh` = 'GOLIAD HIGH SCHOOL' ,`SchoolMiddle` = 'GOLIAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'J O NEAL' ,`TaxAmount` = '3793' ,`TaxRate` = '1.8932' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663706265' WHERE `Matrix_Unique_ID` = '209813609' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T09:30:47.850' ,`MLSNumber` = '11998590' ,`ListAgentFullName` = 'Carlito Rivera' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.797267' ,`Longitude` = '-95.173358' ,`PhotoCount` = '21' ,`PostalCode` = '77015' ,`RoomCount` = '5' ,`ListPrice` = '239995.00' ,`Status` = 'Active' ,`StreetName` = 'Kirkaldy' ,`StreetNumber` = '238' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1466' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this newly remodeled 3 bedroom, 2 full bath home. Newly installed vinyl flooring through out common areas and new carpet in the bedrooms give this home a cozy feeling fresh paint interior and exterior, new appliances, cabinets, quartz counter-tops and many more. The 2 car garage and fenced in large backyard provides plenty of room for a pool or simply entertaining and activities. Located just minutes away from major shopping, schools and a college.' ,`Acres` = '0.2019' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 41 BLK 47 WOODFOREST SEC 17 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8793' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'HAVARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 17 & Rp' ,`TaxAmount` = '4105' ,`TaxRate` = '2.5294' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706265' WHERE `Matrix_Unique_ID` = '210252726' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T08:37:01.553' ,`MLSNumber` = '23127028' ,`ListAgentFullName` = 'Sharhonda Spates' ,`ListOfficeName` = 'Astute Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.619843' ,`Longitude` = '-95.382682' ,`PhotoCount` = '17' ,`PostalCode` = '77047' ,`RoomCount` = '3' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Skyview Grove' ,`StreetNumber` = '2639' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1379' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very well-maintained home just minutes from the medical center. Living room and kitchen just painted.' ,`Acres` = '0.0964' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 1 SKYVIEW PARK SEC 4' ,`LotDesciption` = 'Cleared' ,`LotSize` = '4200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Skyview Park Sec 04' ,`TaxAmount` = '4610' ,`TaxRate` = '2.9307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706266' WHERE `Matrix_Unique_ID` = '211025156' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T08:22:39.693' ,`MLSNumber` = '58280360' ,`ListAgentFullName` = 'Ebonee Bledsoe' ,`ListOfficeName` = 'Glass House Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.413394' ,`Longitude` = '-95.014610' ,`PhotoCount` = '23' ,`PostalCode` = '77591' ,`RoomCount` = '4' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Yellow Rose' ,`StreetNumber` = '9310' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1710' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bedroom 2.5 bath, 2 car garage home. Primary bedroom and bath located on the first floor with walk in closet. 3 more bedrooms with all walk-in closets on 2nd floor a long side a huge game room. This home features upgraded white 42 inch cabinets and granite counters . Covered back patio with a great size back yard. Buyer is to verify all dimensions.' ,`Acres` = '0.1389' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 4 BLK 1 LONE TRAIL VILLAGE SEC 3 (2019) ABST 208' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6050' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lone Trail Village Sec 3' ,`TaxAmount` = '7347' ,`TaxRate` = '3.3628' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706266' WHERE `Matrix_Unique_ID` = '211158672' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T09:59:47.170' ,`MLSNumber` = '7254290' ,`ListAgentFullName` = 'Marly Freeman' ,`ListOfficeName` = 'Freeman Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.590521' ,`Longitude` = '-95.135881' ,`PhotoCount` = '27' ,`PostalCode` = '77062' ,`RoomCount` = '3' ,`ListPrice` = '565000.00' ,`Status` = 'Active' ,`StreetName` = 'Ridgewood Lake' ,`StreetNumber` = '14214' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3188' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.2513' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 40 BLK 2 BAY OAKS SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10947' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FALCON PASS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Oaks Sec 03' ,`TaxAmount` = '11246' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706266' WHERE `Matrix_Unique_ID` = '211724064' --> 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','212077131','1663706266','212077131','2022-09-03T08:24:00.563','94920428','Kevin Johnson','eXp Realty, LLC','','','29.967988','-94.970256','26','77535','3','175000.00','Active','County Road 48824','308','','Dayton','2','0','3','1056','Single-Family','Very nice manufactured home sitting on over 1/2 an acre. This home has been lovingly cared for. Recent updates include new interior paint, expanded parking including full RV 50 amp hook ups with sewer and water in front of the home, and LOTS of material brought in to raise the elevation of the lot and create good drainage. The home features 3 bedrooms, 2 baths, and an open kitchen/dining/living room area. The finishes are very nice with hard surface flooring throughout and high end appliances in the kitchen. The primary bedroom suite is on one end with the other two bedrooms on the other. Primary suite is large and comfortable. The secondary bedrooms consist of one normal sized and one large room with a bathroom between them. The shed was used for puppies so the seller added an A/C. The property is sounded by large trees and has no immediate neighbor behind.','0.689','52','','','','','Sellers Disclosure','','','','Dayton','Central Electric','0','CEDAR CREEK, SEC 3, BLOCK 10, LOT 25, ACRES 0.689,','Cleared','30013','Other','','','0','','0','','0','','','','','Composition','74 - Dayton','STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)','DAYTON HIGH SCHOOL','WOODROW WILSON JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Ranch','Cedar Creek','2149','1.9062','Public Water,Septic Tank,Water District','2013','Seller'); --> 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','212131803','1663706266','212131803','2022-09-03T09:11:54.070','51428821','Khanh Tran','Loft Realty','','','29.786551','-96.228920','29','77474','3','419000.00','Active','Longhorn','5658','Trail','Sealy','2','0','3','1524','Single-Family','Beautiful ranch-style 1522-sqft 1-story home on an 1.169 ACRE LOT in Settlers Crossing subdivision. The property is updated with 3 Beds & 2 Baths, attached garage, covered patio, fresh paint, tile floor, new carpet, and brand new kitchen appliances (dishwasher/stove). The property has open concept kitchen, granite counter tops and lots of natural lights. No City or MUD taxes. Horses allowed. Ideal for family seeking a country life and horse rides but still minutes away from school, shopping, I10 highway and Katy.','1.169','57','','','','','Sellers Disclosure','1','','','','Butane','1','SETTLERS CROSSING SUBD SEC 2 BLOCK 2 LOT 6','Subdivision Lot','50922','Appraisal District','','185','0','','2','Gas Oven','0','','','','','Composition','109 - Sealy','SEALY ELEMENTARY SCHOOL','SEALY HIGH SCHOOL','SEALY JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','1','Ranch','Settlers Crossing Sub','4941','1.8832','Public Water,Septic Tank','2015','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','212157568','1663706266','212157568','2022-09-03T09:38:54.237','97446986','Khanh Tran','Loft Realty','','','30.280896','-95.169570','36','77328','6','269000.00','Active','Aspen','11320','Street','Cleveland','2','0','2','1700','Single-Family','Beautiful two-story 1700-sqft home located in Splendora on a huge lot with OVER 0.5 acre. The house has 3 bedrooms, new carpet, 2 modern-style baths and HVAC. Ideal for family seeking a country life. CALL TODAY TO TAKE A LOOK AT THIS MOVE-IN-READY HOME.','0.561','40','','','','','Sellers Disclosure','','','1','Cleveland Area','Central Electric','1','NORTH WOODS 01, LOT 222,223','Cleared,Subdivision Lot','24438','Appraisal District','','48','0','','0','','0','','','','','Composition','47 - Splendora','GREENLEAF ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Leave Business Card','Appraisal District','2','Ranch,Traditional','North Woods 01','3590','2.0783','Public Water,Septic Tank','1988','Appraisal District'); --> New record created successfully