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-18T20:18:49.033' ,`MLSNumber` = '95389834' ,`ListAgentFullName` = 'Tahira Syed' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.715782' ,`Longitude` = '-95.422772' ,`PhotoCount` = '13' ,`PostalCode` = '77005' ,`RoomCount` = '10' ,`ListPrice` = '3225000.00' ,`Status` = 'Active' ,`StreetName` = 'Amherst' ,`StreetNumber` = '2807' ,`StreetSuffix` = 'Street' ,`City` = 'West University Place' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5313' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'An epitome of refined sophistication.. Designed by M Architecture and built by Detamore Development team on one of the premier location in West University Place! 2807 Amherst - A 5 bedroom/5 FULL & 2 HALF bathroom home is a contemporary take on a stately French design combining elegant yet comfortable formal & informal spaces. Mind-blowing kitchen features Wolf/Subzero appliances, large natural stone center island and a walk-in pantry! Relaxed and inviting living & dining spaces will be filled with natural light soaking in through the wall of windows enveloping the entire space. Breathtaking primary retreat makes a statement with a custom-fitted closet and a luxurious spa-like bath. Large lot,*7812 sqft* allows for a veranda/summer kitchen, backyard oasis with enough room for a pool (renderings in pictures). High ceilings, wide wood floors, natural stone counters & more. STUNNING!\r\n*Room dimensions are approx. and must be identified by buyers and their agents*' ,`Acres` = '0.1779' ,`Area` = '17' ,`BuilderName` = 'Detamore Dev' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 11 & 12A BLK 14 RICE COURT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7812' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,French' ,`Subdivision` = 'Rice Court' ,`TaxAmount` = '18562' ,`TaxRate` = '2.1316' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700332' WHERE `Matrix_Unique_ID` = '207583875' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T21:14:17.903' ,`MLSNumber` = '64680813' ,`ListAgentFullName` = 'Rebecca Ramirez' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.174128' ,`Longitude` = '-95.322734' ,`PhotoCount` = '25' ,`PostalCode` = '77302' ,`RoomCount` = '6' ,`ListPrice` = '659999.00' ,`Status` = 'Active' ,`StreetName` = 'Clark' ,`StreetNumber` = '19080' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1340' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property can be utilized as residential or commercial. There are three lots for sale totaling 117159 Sq. Ft. - Lots 10, 25 & 26 all sold inclusive. No subdividing. Property has two ingress and egress; one from Clark St. & one from FM 1314. Great location that is centrally positioned between 59/69, 242, 99, and 45. Green space features a combination of cleared space and mature trees. Home exterior highlighted with stone accents and landscape bedding. Storm doors on front and back. Neutral home palette allows for easy coordinating or customization. Newer carpet in primary bedroom that connects with en-suite bathroom. New aerobic system installed (2022).' ,`Acres` = '2.68960055' ,`Area` = '40' ,`BuilderName` = 'Precision Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S652000 - LAKE ADAMS, LOT 26' ,`LotDesciption` = 'Cleared' ,`LotSize` = '37926' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Adams' ,`TaxAmount` = '1716' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700332' WHERE `Matrix_Unique_ID` = '208045899' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T20:40:17.990' ,`MLSNumber` = '60419279' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435449' ,`Longitude` = '-95.441360' ,`PhotoCount` = '17' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '325990.00' ,`Status` = 'Active' ,`StreetName` = 'Truckee River' ,`StreetNumber` = '1522' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1528' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'D.R. Horton, America\'s #1 Builder since 2002! This NEW CONSTRUCTION Diana Plan with Elevation T, their NEWEST modern design offers 3 spacious bedrooms and 2 bathrooms, covered patio, a 2-car garage and no back neighbors! This 4-sided brick, STUNNING home with open concept has an expansive kitchen which includes granite countertops, 42\" cabinets, large breakfast bar and stainless steel appliances including gas range, microwave and dishwasher. As you walk into the Primary bathroom, you will see dual sinks, oversized shower, soaker tub (on select inventory) and a large walk-in closet! Water resistant vinyl flooring, 2\" blinds and a tankless water heater are all included! Did we mention the Smart Home Technology that\'s included?! Security System with prewired locations for more Smart Technology! Location, Location, Location - right off 288 and close to downtown! Sierra Vista also has amenities for all ages - enjoy the NEW Island Amenity Village!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sierra Vista Lot 3 Block 4 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7007' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700332' WHERE `Matrix_Unique_ID` = '209565521' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T20:19:03.120' ,`MLSNumber` = '64312823' ,`ListAgentFullName` = 'Sonia Duque' ,`ListOfficeName` = 'Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.982076' ,`Longitude` = '-95.401082' ,`PhotoCount` = '11' ,`PostalCode` = '77073' ,`RoomCount` = '3' ,`ListPrice` = '272000.00' ,`Status` = 'Active' ,`StreetName` = 'Oland' ,`StreetNumber` = '20035' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1690' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful house has 3 bedrooms, 2.5 bathrooms, it does not have neighbors in the patio, nor in front of the street. The refrigerator will stay, it has a large patio for family gatherings or children\'s games.' ,`Acres` = '0.101' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 1 MEADOWVIEW FARMS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '410' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadowview Farms Sec 2' ,`TaxAmount` = '4766' ,`TaxRate` = '2.8445' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700332' WHERE `Matrix_Unique_ID` = '209828540' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T21:08:10.113' ,`MLSNumber` = '41903180' ,`ListAgentFullName` = 'Linh Bui' ,`ListOfficeName` = 'ABSOLUTE Realty Group Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014731' ,`Longitude` = '-95.612809' ,`PhotoCount` = '33' ,`PostalCode` = '77377' ,`RoomCount` = '9' ,`ListPrice` = '399980.00' ,`Status` = 'Active' ,`StreetName` = 'Blooming Willow' ,`StreetNumber` = '12162' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2772' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AN AMAZING HOME WITH EXCELLENT SCHOOLS IN NORTH IS AWAITING FOR YOU !\r\n A new built 2022 home and never lived- in with 40K upgrades include convert study rm to 5th bedroom, brick at all sides, 3rd full bath downstairs, long duration wood look- like tiles for whole ground foor, add shower to the master bath, ceiling heigh 9 feet with higher kitchen cabinet, elegance balluster for stair...\r\nOpen space with combo Kitchen- Dining- Living is great for family parties. Comfortable kitchen with upgrade for granite counter top, deep and big stainlless steel sink, large island for convinient breakfast and bar. \r\n Corner lot next to playground with nice brick fence. No rear neighbor so you can add a gate to access the natrural pond for fishing !\r\nA huge master bedroom with large ensuite bath with a lot of natural light will bring to you a relax felling when in there.\r\nGiant family space upstair give you have a sufficient place for game and sofa.\r\nCOME AND FALL IN LOVE WITH THIS HOME !' ,`Acres` = '0.0992' ,`Area` = '35' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 3 WILLOW WOOD PLACE SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '4320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'WILLOW CREEK ELEMENTARY SCHOOL (TOMBALL)' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Wood Place Sec 1' ,`TaxAmount` = '734' ,`TaxRate` = '2.756' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700332' WHERE `Matrix_Unique_ID` = '210030883' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T20:10:25.900' ,`MLSNumber` = '73902927' ,`ListAgentFullName` = 'Matthew Diehl' ,`ListOfficeName` = 'Round Top Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.920351' ,`Longitude` = '-96.685198' ,`PhotoCount` = '25' ,`PostalCode` = '78940' ,`RoomCount` = '6' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Kubena Ridge' ,`StreetNumber` = '132' ,`StreetSuffix` = '' ,`City` = 'Fayetteville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Opportunity to buy in this mildly restricted community located inside the city limits of Fayetteville. Watch the cattle graze near the neighboring pond through the windows across the back of the entire great room inside this 2500 square foot, 3 bedroom, 2 bath home. The project awaits your vision. This is your chance to complete this new construction project with finishes of your selection/choosing and instruction with a builder of your choice. Bring your own builder OR Bluebonnet Renovators is happy to work with you to bring your vision to reality. \r\n\r\nA neighboring lot is for sale should you wish to expand this lot. All utilities are in-place and ready to be hooked up for neighboring lot.\r\n\r\n*Buyer may chose gas or electric HVAC' ,`Acres` = '0.28' ,`Area` = '69' ,`BuilderName` = 'Bluebonnet Renovator' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WESTVIEW LOT 14 0.282 NO BLDGS OR M H' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '204 - Fayetteville' ,`SchoolElementary` = 'FAYETTEVILLE HIGH SCHOOL' ,`SchoolHigh` = 'FAYETTEVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'FAYETTEVILLE HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westview' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663700332' WHERE `Matrix_Unique_ID` = '210565246' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T21:45:39.987' ,`MLSNumber` = '11086752' ,`ListAgentFullName` = 'Sophia Pickens-Graves' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.782594' ,`Longitude` = '-95.328374' ,`PhotoCount` = '8' ,`PostalCode` = '77026' ,`RoomCount` = '6' ,`ListPrice` = '307000.00' ,`Status` = 'Active' ,`StreetName` = 'Abernathy' ,`StreetNumber` = '2212' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This modest home is ready for a growing and expanding family with neutral colors through out this lovely house. Kitchen boast granite counter tops, with ceramic title in all wet areas. Beautiful wood cabinets, spacious Primary bedrooms with plush carpet in all bedrooms and family room area. Located in the up and coming area of the greater 5th Ward. The edge of downtown Houston, Medical Center is nearby, NRG Stadium and the Houston Zoo. This is a must see, bring your first time buyer.' ,`Acres` = '0.0623' ,`Area` = '2' ,`BuilderName` = 'On Track Ministeies' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 1 ABERNATHY COURT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2713' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DOGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = '' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'ABERNATHY COURT' ,`TaxAmount` = '505' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700333' WHERE `Matrix_Unique_ID` = '211309367' --> Updated record success