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-16T18:24:35.250' ,`MLSNumber` = '13927868' ,`ListAgentFullName` = 'Daniel Elizondo' ,`ListOfficeName` = 'Mirabal, Montalvo & Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.043757' ,`Longitude` = '-95.435006' ,`PhotoCount` = '23' ,`PostalCode` = '77388' ,`RoomCount` = '4' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Black Forest' ,`StreetNumber` = '222' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2081' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for an amazing deal? No need to look any further, come check out this 4 bedroom, 2 full bath, 3 sided brick home in a well established and enticing neighborhood! 2 Living areas, 2 dining areas totaling over 2,000 sq ft of a home! Roof is only 3 years old and furnace was replaced in June of 2022. Massive backyard with privacy fence with panoramic driveway leading to your detached 2 car garage. This home is ready for your own special finishes, with so much potential, this beauty is ready for new owners to call it home! Minutes away from schools, shops, churches and restaurants, don’t let this opportunity slip your fingers! Contact us today and lets get you into this home NOW!' ,`Acres` = '0.2118' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 54 BLK 1 ENCHANTED OAKS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9225' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'LEMM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Enchanted Oaks Sec 01' ,`TaxAmount` = '4350' ,`TaxRate` = '2.484' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663699546' WHERE `Matrix_Unique_ID` = '209498921' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T19:05:31.867' ,`MLSNumber` = '98587427' ,`ListAgentFullName` = 'Salvador Caballero' ,`ListOfficeName` = 'ListWithFreedom.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841397' ,`Longitude` = '-95.174030' ,`PhotoCount` = '19' ,`PostalCode` = '77049' ,`RoomCount` = '7' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Round Rock' ,`StreetNumber` = '8025' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1834' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Never flooded (here during Harvey). Beautiful home on 0.38 acres with huge yard areas, covered patio, mature trees, detached 2 car garage + workshop & garden shed. Custom oak cabinets w/granite countertops in kitchen and bathrooms; convection oven; gas stovetop (down draft ready); bamboo flooring in common areas; carpet in bedrooms; tile in bathrooms; doorless walk-in tiled shower in main bathroom; marble/glass tile tub surround in Master Bedroom; open concept living/kitchen/dining area; Venetian plaster accent walls. Bonus room with French doors could be and office. Automatic gate opener for privacy driveway/backyard fencing; new garage door w/opener. Don\'t pay for water or sewage ever again - water well & septic system. Quiet, low traffic neighborhood close to shopping and downtown but outside city limits.' ,`Acres` = '0.3857' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 270 & 271 BLK 9 HAMPTON OAKS SEC 2' ,`LotDesciption` = 'Other' ,`LotSize` = '16800' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Hampton Oaks Sec 02' ,`TaxAmount` = '1072' ,`TaxRate` = '2.2893' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663699547' WHERE `Matrix_Unique_ID` = '210100856' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T19:27:42.943' ,`MLSNumber` = '90527267' ,`ListAgentFullName` = 'Rodney Hamp' ,`ListOfficeName` = 'CB&A, Realtors- Loop Central' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745222' ,`Longitude` = '-95.475461' ,`PhotoCount` = '6' ,`PostalCode` = '77056' ,`RoomCount` = '15' ,`ListPrice` = '2395000.00' ,`Status` = 'Active' ,`StreetName` = 'Chevy Chase' ,`StreetNumber` = '5626' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '5615' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION. Not to late to make your own selections. Stunning custom masterpiece by McDaniel Homes and walking distance to the Galleria. Located on an over-sized lot with plenty of room for a pool. To many features to mention.' ,`Acres` = '0.2893' ,`Area` = '22' ,`BuilderName` = 'McDaniel Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 9 BRIARCROFT' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '12600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Briarcroft' ,`TaxAmount` = '18440' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699547' WHERE `Matrix_Unique_ID` = '210412533' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T19:59:10.877' ,`MLSNumber` = '60345681' ,`ListAgentFullName` = 'Byanca Vazquez' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.676060' ,`Longitude` = '-95.053801' ,`PhotoCount` = '36' ,`PostalCode` = '77571' ,`RoomCount` = '6' ,`ListPrice` = '549000.00' ,`Status` = 'Active' ,`StreetName` = 'shirley ln' ,`StreetNumber` = '2220' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2196' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful custom built home on an oversized lot in the highly sought after Lomax area! Primary bedroom includes his & hers closets! Home was built with custom upgrades; including but not limited to a study with built in cabinetry & granite countertops throughout. Spacious secondary bedrooms, walk in closets & Jack and Jill bathroom. Enjoy a peaceful & quiet view from the back patio area with no back neighbors! The back patio includes a kitchen area ready to be customized to your liking; great for entertaining! Gas, water access & cable drop are all available in patio kitchen area. Low taxes & no HOA! Bring your offers!' ,`Acres` = '0.3134' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lomax Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 SPILLER GARDENS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '13650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LOMAX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LOMAX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spiller Gardens' ,`TaxAmount` = '7967' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699547' WHERE `Matrix_Unique_ID` = '210923482' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T19:47:19.803' ,`MLSNumber` = '71700295' ,`ListAgentFullName` = 'Shelly Franklin' ,`ListOfficeName` = 'Texas Land Depot, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.378236' ,`Longitude` = '-95.453136' ,`PhotoCount` = '50' ,`PostalCode` = '75835' ,`RoomCount` = '3' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 1605' ,`StreetNumber` = '431' ,`StreetSuffix` = '' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2110' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here\'s a chance to own your \"Peace\" in the Pines with this inviting 2100 sqft 3/2 brick home on 10.3 acres in the desired Latexo ISD. This home has an open concept living/dining area with a farmhouse style kitchen. Master suite is spacious & has an attached bathroom with walk-in rain shower, his & hers sink & large walk-in closet. Utility room has cabinets & space for a 2nd refrigerator/freezer. Garage enclosed for added office & study. Enjoy the outdoors on a nice front porch or the inviting back porch with great views of the property & above ground salt-water pool. Property is fenced/cross fenced with 2 ponds, a Metal Building w/2 attached lean-to\'s, cover for livestock, cattle chute & chicken coop. Property has a small vineyard with red & white grapes, peach orchard & a blueberry patch that are fully auto watered. House is equipped with Security System, Ring Doorbell, Remote Operated Entrance Gate & Starlink broadband internet. A 20x10 tiny home offers potential for rental income.' ,`Acres` = '10.3' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WHISPERING OAKS PT LOT 15 9.30 AC' ,`LotDesciption` = 'Cleared' ,`LotSize` = '405108' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '61 - Latexo' ,`SchoolElementary` = 'LATEXO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LATEXO HIGH SCHOOL' ,`SchoolMiddle` = 'LATEXO HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'NA' ,`TaxAmount` = '203' ,`TaxRate` = '1.8562' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663699547' WHERE `Matrix_Unique_ID` = '210975712' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T18:14:51.830' ,`MLSNumber` = '46124286' ,`ListAgentFullName` = 'Ayesha Shelton' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.673506' ,`Longitude` = '-95.342137' ,`PhotoCount` = '8' ,`PostalCode` = '77033' ,`RoomCount` = '6' ,`ListPrice` = '589999.00' ,`Status` = 'Active' ,`StreetName` = 'Longmeadow' ,`StreetNumber` = '5314' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '3679' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous new construction duplex in Houston’s Medical Center South! Featuring an oversized interior lot, 1 Car Garage per side, Covered Patios, Open living area with an entry foyer. This spacious 3 bedroom & 2.5 bath Modern Farm home with all the features of an open floor plan with beautiful tile floors, a Large Primary Bedroom, nice cabinetry with granite countertop, a large yard & much more! All the charm you could ask for just south of Downtown Houston. Located approx. 15 minutes from Downtown Houston, 10 Mins from Houston Medical Center, 20 Mins from Galleria Houston, and easy access to Hwy 610, 288, and Hwy 45. This listing includes both units! Schedule your private showing and have the chance to put your personal touches on the counters and interior colors!' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'Martinez Dream Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 5 LT 4 BLK 5 SMALLWOOD TERRACE' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALCOTT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'SMALLWOOD TERRACE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699547' WHERE `Matrix_Unique_ID` = '211010297' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T18:59:06.277' ,`MLSNumber` = '49915921' ,`ListAgentFullName` = 'Carlos Caballero' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.858036' ,`Longitude` = '-95.347331' ,`PhotoCount` = '9' ,`PostalCode` = '77093' ,`RoomCount` = '6' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Chapis' ,`StreetNumber` = '2422' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1484' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COMPLETE REMODEL! Beautiful 3-4 Bedroom home, 2 full baths. Brand New Kitchen cabinets, countertops, appliances, flooring, lighting, updated baths, and much more. The back has a garage that was divided into 2 sections. NO traffic since it is on a dead end road. About 2 minutes from the highway. Book your appointment today!!' ,`Acres` = '0.1788' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 76 DUNBAR PLACE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7788' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'COOP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER' ,`SchoolMiddle` = 'PATRICK HENRY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Dunbar Place' ,`TaxAmount` = '1803' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699547' WHERE `Matrix_Unique_ID` = '211119576' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-16T18:30:56.957' ,`MLSNumber` = '69288233' ,`ListAgentFullName` = 'Amy Huffman' ,`ListOfficeName` = 'Henson Land & Ranch Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.179472' ,`Longitude` = '-97.204739' ,`PhotoCount` = '42' ,`PostalCode` = '76579' ,`RoomCount` = '3' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'CR 453' ,`StreetNumber` = '119' ,`StreetSuffix` = '' ,`City` = 'Troy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2130' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful farm house inspired home has it all! Located in the small quiet community of Bellfalls, Tx you will find this 2,130 sq ft home consisting of 3 bedrooms & 2 baths on almost 3 acres. Complete with a garage, pool and deck, 16\' x 44\' cabin, RV parking with hookups and so much more! All the right elements influence the farm house inspired design of this home as they are incorporated in the rustic materials, neutral colors and abundant lighting throughout the home. The white shiplap wall accents, stainless steel farm sink, extra large kitchen island, stand alone master tub and other well thought out details throughout this home not only gives it a classic style but also brings a warmth and comfort to the home that you feel the minute you walk in. Located approximately 7 miles to I-35, 35 miles to Waco, Tx , 13 miles to Temple, Tx and centrally located between Dallas/Ft Worth and Austin. Troy ISD.' ,`Acres` = '2.857' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0424 ROGERSON H C 2.857 ACRES' ,`LotDesciption` = 'Other' ,`LotSize` = '124451' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '987 - Troy' ,`SchoolElementary` = '' ,`SchoolHigh` = 'TROY HIGH SCHOOL' ,`SchoolMiddle` = 'TROY MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'ROGERSON H C' ,`TaxAmount` = '646' ,`TaxRate` = '2.1637' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699547' WHERE `Matrix_Unique_ID` = '211120989' --> Updated record success