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-08T18:21:39.553' ,`MLSNumber` = '90578914' ,`ListAgentFullName` = 'Ekaterine Khmaladze' ,`ListOfficeName` = 'R. Alexa Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.669427' ,`Longitude` = '-95.502742' ,`PhotoCount` = '34' ,`PostalCode` = '77096' ,`RoomCount` = '9' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Bob White' ,`StreetNumber` = '10210' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2310' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful, updated home is located in Maplewood. Easy commute to TMC, Downtown, Galleria. Architect\'s Influence throughout the House. Walls have been opened between the Foyer, Formal LR, and Family Room.Underground plumbing replaced with PVC to City Sewer, new PEX Piping in the whole house, New water heater. Marble Floors in the Foyer and Formal LR. Den has High Cathedral Ceiling, Marble-Faced Fireplace.New ceiling fans and recess lights in whole house.The home is enhanced by tile floors. Kitchen was remodeled with Shaker Cabinets,Granite Counters; it\'s equipped with brand new LG Stainless Steel Appliance Package. 4th Bedroom opens to primary bedroom--wall could be reconstructed. Primary Bedroom with en suite bath and walk-in closets Primary Bath has dual sinks,vanity area. A 2-car attached garage with covered walkway to the house. The garage has built in cabinets. In the attic there is an extra storage room that is air conditioned and has shelves for easy storage. ' ,`Acres` = '0.2017' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 37 MAPLEWOOD SOUTH SEC 7 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8784' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '488' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELROD ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Maplewood South Sec 07 R/P' ,`TaxAmount` = '6120' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696008' WHERE `Matrix_Unique_ID` = '209066972' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T18:46:51.820' ,`MLSNumber` = '31687961' ,`ListAgentFullName` = 'Cody Zboril' ,`ListOfficeName` = 'The Real Estate Service' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.312272' ,`Longitude` = '-96.100910' ,`PhotoCount` = '50' ,`PostalCode` = '77488' ,`RoomCount` = '0' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Houston' ,`StreetNumber` = '201' ,`StreetSuffix` = 'Street' ,`City` = 'Wharton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '7096' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Listing!! 201 North Houston, Wharton, TX 77488. Multifunctional 7,000+ sqft Commercial Property. Currently functioning as a salon, barber shop, 3 professional office spaces and conference room. Several multipurpose rooms off the salon with beautiful barn wood sliding doors. One of the offices has a convenient separate outdoor entrance. This large building is equipped with a shared kitchen and shared ADA compliant bathrooms. Outside you will find a stand alone fully functioning outdoor restaurant area with covered seating and serving space. The large outdoor courtyard is completely fenced in and perfect for event hosting, parties or venue rental. The entire building has recently been rewired, roof is only 6 years old, and has split AC units. A large digital sign above the entrance was recently added as well. Security cameras and fiber internet are an added bonus. You will find beautiful modern industrial finishes throughout the building as it was completely remodeled in 2017.' ,`Acres` = '0.6041' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Reports Available' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HAWES BLOCK B LOT 4A,5,6,7' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '26315' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Hawes' ,`TaxAmount` = '12318' ,`TaxRate` = '2.4334' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696008' WHERE `Matrix_Unique_ID` = '209328687' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T19:55:13.937' ,`MLSNumber` = '29535266' ,`ListAgentFullName` = 'Maria Alanis' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.454120' ,`Longitude` = '-95.840926' ,`PhotoCount` = '43' ,`PostalCode` = '77461' ,`RoomCount` = '5' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Paloma' ,`StreetNumber` = '5903' ,`StreetSuffix` = 'Lane' ,`City` = 'Needville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2048' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 hour notice to show propety! Lovely country home in the country, near the city. Features lovely spacious country kitchen, spacious master bedroom with spacious bathroom with Jacuzzi, split bedroom plan with spacious hallway for remaining bedrooms, laundry area, office area, spacious living area. This property is a little over 2 acres, includes a large detached steel building as garage. 2 recent air conditioning units, 4 ton, 31/2 ton, spacious home. New windows in master bedroom, 4 new windows in back side of house. aerobic septic system. Come see this lovely home in the country!! You won\'t regret it. Lots of trees, no back neighbors, corner lot. Low taxes, many,many trees in backyard and pond when plenty of rain. Spacious lot with alot of room for parking, bring your trucks, trailers, country living very near the city of Rosenberg, Richmond, near freeway 59. Lovely home and property overall!!!' ,`Acres` = '2.11' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '0241 H AND TC RY, BLOCK 3, ACRES 1.124, LOT 40 CHAPARRAL ACR' ,`LotDesciption` = 'Corner' ,`LotSize` = '96877' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'H & Tc Ry' ,`TaxAmount` = '3239' ,`TaxRate` = '1.8957' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663696009' WHERE `Matrix_Unique_ID` = '211075080' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T19:07:36.990' ,`MLSNumber` = '58148280' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.219294' ,`Longitude` = '-95.162090' ,`PhotoCount` = '14' ,`PostalCode` = '77372' ,`RoomCount` = '13' ,`ListPrice` = '301540.00' ,`Status` = 'Active' ,`StreetName` = 'Cooperstown' ,`StreetNumber` = '26170' ,`StreetSuffix` = 'Way' ,`City` = 'Splendora' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '1978' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand new beautiful 2 story 5 bedroom 3 1/2 bath and 2 car garage. Colina Home features 42\'\' cabients, quartz/granite kitchen countertops, kitchen includes recess lighting, high ceilings, laminated vinyl (wood look) flooring throughout the home, 2\" blinds throughout the home, Stainless Steel Appliances including 5 burner gas range, Large single bowl under-mount kitchen sink. Ceramic tile backsplash in kitchen & bathrooms. Masterbath features a large garden tub with separate shower, dual marble vanities, large walk-in closet. 10-year warranty on frame and foundation, 25-year warranty on roof, and 30-year warranty on Hardi Plank, and extreme energy efficiencies to reduce cost. This Home is Move in ready Nov 2022.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21 BLK 1 Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Splendora Fields' ,`TaxAmount` = '' ,`TaxRate` = '2.62' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696009' WHERE `Matrix_Unique_ID` = '211132188' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T18:55:06.107' ,`MLSNumber` = '15159909' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.220693' ,`Longitude` = '-95.160747' ,`PhotoCount` = '32' ,`PostalCode` = '77372' ,`RoomCount` = '9' ,`ListPrice` = '276390.00' ,`Status` = 'Active' ,`StreetName` = 'Babe Ruth' ,`StreetNumber` = '26036' ,`StreetSuffix` = 'Drive' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1668' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand new 1 story 3 bedroom 2 bath with a study and 2 car garage. Colina Home features granite countertops in kitchen includes recess lighting. high ceilings, laminated vinyl (wood look) flooring throughout the home, 2\" blinds throughout the home, Stainless Steel Appliances including 5 burner gas range, 42\" cabinets, Large single bowl under-mount kitchen sink. Ceramic tile backsplash in kitchen & bathrooms. Masterbath features a large garden tub with separate shower, dual marble vanities, large walk-in closet. 10-year warranty on frame and foundation, 25-year warranty on roof, and 30-year warranty on Hardi Plank. Covered back patio and extreme energy efficiencies to reduce cost. This Home is MOVE IN READY.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 19 Blk 2 Section 4' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '7813' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Splendora Fields' ,`TaxAmount` = '' ,`TaxRate` = '2.48' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696009' WHERE `Matrix_Unique_ID` = '211138739' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T18:12:04.883' ,`MLSNumber` = '68044783' ,`ListAgentFullName` = 'Christopher Davidson' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812030' ,`Longitude` = '-95.383243' ,`PhotoCount` = '26' ,`PostalCode` = '77009' ,`RoomCount` = '5' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = '27th' ,`StreetNumber` = '1205' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1625' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This newly renovated home in the heart of Sunset Heights is a MUST SEE! This lovely house was stripped to the studs and fully renovated with all new Electrical, PEX Plumbing, A/C, Sheetrock, Flooring, Roof, Quartz Countertops and a brand new single car Garage! This open floor concept features a spacious Kitchen, Stainless Steel Appliances, Quartz Countertops, Gas Stove and Pantry. Spacious Living Room comes with tons of natural lighting and also easy access to the Guest Bedrooms and Bathroom. The Primary Bedroom comes with an en-suite Bathroom that features a double sink vanity, massive walk-in shower that is a MUST SEE! Custom Cabinetry in all of the closets. The furniture can be purchased separate from sale of the home! This home is surrounded by tons of new Restaurants, Hwy 610 is 2 blocks away, the Farmers Market is 2 minutes away. Call now to schedule a viewing today!' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 6 SUNSET HEIGHTS EXTN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`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` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Victorian' ,`Subdivision` = 'Sunset Heights Sec 01 Ext' ,`TaxAmount` = '5974' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1936' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696009' WHERE `Matrix_Unique_ID` = '211161193' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T18:48:27.337' ,`MLSNumber` = '31867745' ,`ListAgentFullName` = 'Stacie Fontenot' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.094015' ,`Longitude` = '-94.147038' ,`PhotoCount` = '27' ,`PostalCode` = '77706' ,`RoomCount` = '7' ,`ListPrice` = '159900.00' ,`Status` = 'Active' ,`StreetName` = 'Lucas' ,`StreetNumber` = '1336' ,`StreetSuffix` = 'Drive' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1470' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This well-maintained, completely updated, cottage-style home in the heart of Beaumont’s west end is priced perfect for the first-time home buyer. With right at 1500sqft., this 3 bedroom, 2 baths are located near shops and eateries. At this price, it will not last long. Call today for your private showing. The land on the side' ,`Acres` = '0.2563' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CALDER HIGHLANDS L5 B9' ,`LotDesciption` = 'Cleared' ,`LotSize` = '11165' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'REGINAL-HOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Accompany,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Calder Highlands' ,`TaxAmount` = '3065' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696009' WHERE `Matrix_Unique_ID` = '211186000' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T18:24:40.417' ,`MLSNumber` = '16728385' ,`ListAgentFullName` = 'Brandi Morris' ,`ListOfficeName` = 'Bill Bell Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.955246' ,`Longitude` = '-95.971531' ,`PhotoCount` = '16' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '169999.00' ,`Status` = 'Active' ,`StreetName` = 'Bay Ridge' ,`StreetNumber` = '1411' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1313' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3/2/2 Is Waiting On You To Call It Home. This House Offers Low Maintenance Tile Floors Through Out The Main Living Areas, Only The Bedrooms Offer Carpet. The Kitchen Features Black Quartz Counter Tops, With Matching Black Appliances! Also, You Don\'t Have To Worry About Power Outages With This Home, It Has A Whole Home Generac Installed. The Back Yard Has A Spacious Deck, Perfect For Entertaining. The Neighborhood Park Just Down The Road, Has Brand New Play Ground Equipment. The Refrigerator Stays And The Washer And Dryer Can Stay.' ,`Acres` = '0.174' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BAY RIDGE SEC 1, BLOCK 4, LOT 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7579' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Ridge' ,`TaxAmount` = '2953' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696009' WHERE `Matrix_Unique_ID` = '211192979' --> Updated record success