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` = '2023-01-17T11:43:34.837' ,`MLSNumber` = '2375107' ,`ListAgentFullName` = 'Gerald Womack' ,`ListOfficeName` = 'Womack Development' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.845554' ,`Longitude` = '-95.284236' ,`PhotoCount` = '9' ,`PostalCode` = '77028' ,`RoomCount` = '3' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Wayside' ,`StreetNumber` = '9114' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Formerly a purposed for Montessori type daycare building. Can be repurposed for your use, offers a large yard on a corner lot.' ,`Acres` = '0.3854' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 392 & TR 393 BLK 23 PARKHURST ESTATES SEC 2' ,`LotDesciption` = 'Other' ,`LotSize` = '16790' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HILLIARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkhurst Estates Sec 02' ,`TaxAmount` = '2178' ,`TaxRate` = '2.5304' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213538' WHERE `Matrix_Unique_ID` = '178963516' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T11:48:58.653' ,`MLSNumber` = '82587408' ,`ListAgentFullName` = 'Jerry Walker' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.173650' ,`Longitude` = '-95.442587' ,`PhotoCount` = '6' ,`PostalCode` = '77385' ,`RoomCount` = '4' ,`ListPrice` = '795000.00' ,`Status` = 'Active' ,`StreetName` = 'Mccowan' ,`StreetNumber` = '2863' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1978' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare find! Keep your horses within 5 minutes of The Woodlands! 3 bedroom home ideally situated on 4 +/- acres Approx. 1.5 miles from The Woodlands. Home is just under 2000sq.ft. and is completely unrestricted. This is the perfect place to settle in and call home for you and your horses.' ,`Acres` = '4' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0350 MONTG CO SCH LAND, TRACT 49, ACRES 4.000' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '174240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOUSER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'MONTG CO SCH LAND' ,`TaxAmount` = '4662' ,`TaxRate` = '1.9015' ,`WaterSewer` = 'Public Sewer,Septic Tank' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213539' WHERE `Matrix_Unique_ID` = '196194070' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T11:15:27.590' ,`MLSNumber` = '85631132' ,`ListAgentFullName` = 'Cary Stephens' ,`ListOfficeName` = 'RE/MAX East' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.068699' ,`Longitude` = '-95.102138' ,`PhotoCount` = '32' ,`PostalCode` = '77336' ,`RoomCount` = '10' ,`ListPrice` = '749000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 2100' ,`StreetNumber` = '27811' ,`StreetSuffix` = 'Road' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3072' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REDUCED $200,000!! BRING US A CONTRACT!! FM 2100 is being widened making this a great commercial location! Grand Parkway is close! Great Location for Country Living & Commercial Business! 6.29 Acres fenced with 2 Street Access!! FM 2100 frontage on both sides of Road!! .03 acre tract on East Side of FM 2100, too!! Multiple Structures: 3 BR 2 bath main house with two living areas, 10 x 70 covered front porch & covered back porch!! 672 sq. ft. 1 BR 1 bath guest house with living area, kitchen & utility room! 2nd Guest house 400 sq. ft. 2 BR 1 bath with living room, kitchen and utility room! 30 x 50 insulated shop with hydraulic lift! 20 x 45 covered RV/Boat Parking! Horse barn with Tack Room, Chicken coop, 26 foot above ground pool with deck! Per Seller the main house is approximately 2,000 sq. ft. The small trailer is approximately 400 sq. ft. and the little guest cottage is 672 sq. ft. Total of everything is approximately 3,072 sq. ft. Do your own due diligence Bring us a contract!!' ,`Acres` = '6.29' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'TR 44 ABST 474 J H ISBELL' ,`LotDesciption` = 'Cleared,Other,Wooded' ,`LotSize` = '273992' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'JH Isbell' ,`TaxAmount` = '2649' ,`TaxRate` = '2.0463' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213539' WHERE `Matrix_Unique_ID` = '202603780' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T11:42:17.510' ,`MLSNumber` = '10224885' ,`ListAgentFullName` = 'Gerald Womack' ,`ListOfficeName` = 'Womack Development' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.690854' ,`Longitude` = '-95.283945' ,`PhotoCount` = '13' ,`PostalCode` = '77087' ,`RoomCount` = '5' ,`ListPrice` = '199000.00' ,`Status` = 'Active' ,`StreetName` = 'Greenstone' ,`StreetNumber` = '7819' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1020' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute and quaint 3 bedroom 1 bathroom home that is conveniently located just blocks from from 610 Loop and I-45. This home is ideal for first time homebuyer for their starter home. Kitchen and living area are great for hosting friends and family alike. Situated on a 6,600 square foot lot, this large backyard is a wonderful retreat! Quick and easy access to highways, dining, and shopping! A little TLC is all this hidden gem needs. Reach out to schedule your showing today!' ,`Acres` = '0.1529' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 4 GREENWAY SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6660' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GOLFCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greenway Sec 01' ,`TaxAmount` = '1962' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213539' WHERE `Matrix_Unique_ID` = '202784326' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T11:56:58.150' ,`MLSNumber` = '87415336' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.672531' ,`Longitude` = '-95.465761' ,`PhotoCount` = '49' ,`PostalCode` = '77096' ,`RoomCount` = '13' ,`ListPrice` = '1299990.00' ,`Status` = 'Active' ,`StreetName` = 'Yarwell' ,`StreetNumber` = '5003' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4411' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Custom Modern Farmhouse with vintage touches by CastleRock Communities is absolutely stunning! This popular custom Laguna plan is currently under construction, being built upon pier and beam out of the flood zone, and will be ready for a new family before the end of the year. You will fall in love with this dramatic open concept home, it features custom cabinets in the kitchen that go to 10\' and open to a 2-story family room, built-ins, balanced out with a modern linear fireplace. The home is located minutes from the Galleria, Medical Center, parks and is conveniently located near major highways! This beautiful home won\'t last long! Call us today for more details! All homes have a two-year builder-backed warranty!' ,`Acres` = '' ,`Area` = '20' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15, Block 4, Meyerland Section 8' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9921' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KOLTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Meyerland' ,`TaxAmount` = '' ,`TaxRate` = '2.39' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675213539' WHERE `Matrix_Unique_ID` = '203556781' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T11:10:26.750' ,`MLSNumber` = '34037235' ,`ListAgentFullName` = 'Cary Stephens' ,`ListOfficeName` = 'RE/MAX East' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.843174' ,`Longitude` = '-94.867374' ,`PhotoCount` = '50' ,`PostalCode` = '77523' ,`RoomCount` = '8' ,`ListPrice` = '1850000.00' ,`Status` = 'Active' ,`StreetName` = 'Trinity' ,`StreetNumber` = '3203' ,`StreetSuffix` = 'Street' ,`City` = 'Mont Belvieu' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2392' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Location! 4 BR 4 bath located in the Heart of Mont Belvieu! Buy all for ultimate mini-ranch or develop as a small custom subdivision or family compound! Do your own due diligence! Will sell house & all 17..35 acres for $1,850,000 (Tax ID\'s #35234, #36836 #39264 & #39265) or will divide! Will sell house on 3.208 acres for $795,000 (Tax ID\'s #35234 & #36836! Extra +/- 3.5 acres available for $350,000 (Part of #39264)! Plus extra 10.64 acres for $850,000 (Part of #39264) 40x40 Building w/ full bath! Storage Bldg, Custom Pool & Covered Patio! 4th bedroom could be game room or study! Seller prefers to sell all property together or the 10.64 acres of land first! Will sell house & 3.2 acres or house & 6.7 acres first ! Access easement through 3.5acres must be granted along south edge of property to back acreage if divided! Owner in the process of digging a +/- 1 acre pond in back SW corner of the property overlooking Park. Should be finished in November & make this a paradise! Come See!' ,`Acres` = '17.351' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PT LT 10 BK 1 K B RANCH' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '755810' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'K B Ranch' ,`TaxAmount` = '7298' ,`TaxRate` = '2.1487' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213540' WHERE `Matrix_Unique_ID` = '204077526' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T12:54:02.067' ,`MLSNumber` = '45595107' ,`ListAgentFullName` = 'Connie Strban' ,`ListOfficeName` = 'Crockett Springs Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.314121' ,`Longitude` = '-95.438862' ,`PhotoCount` = '39' ,`PostalCode` = '75835' ,`RoomCount` = '9' ,`ListPrice` = '299500.00' ,`Status` = 'Active' ,`StreetName` = 'Plantation' ,`StreetNumber` = '1307' ,`StreetSuffix` = 'Drive' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1638' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate, totally renovated with attention to every detail! 3 bedrooms/2 baths/2 car attached garage. This beautiful home offers wood flooring, granite in kitchen and baths, and plenty of space for indoor and outdoor entertaining. Relax in total privacy in the large hot tub. There is also very nice 960 sq ft with 1 bedroom/1 bath apartment, great for a guest house, Mother-In-Law suite or rented for extra income. Conveniently located in a quite area of Historic Crockett, Texas.' ,`Acres` = '0.269' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PLANTATION ACRES LOT 27 SEC A' ,`LotDesciption` = 'Cleared' ,`LotSize` = '11718' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`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` = 'Traditional' ,`Subdivision` = 'Plantation Acres Sec A' ,`TaxAmount` = '3325' ,`TaxRate` = '2.3627' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213540' WHERE `Matrix_Unique_ID` = '205244517' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T12:09:52.873' ,`MLSNumber` = '55859182' ,`ListAgentFullName` = 'Laura Sweeney' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.753900' ,`Longitude` = '-95.505535' ,`PhotoCount` = '50' ,`PostalCode` = '77024' ,`RoomCount` = '18' ,`ListPrice` = '5999000.00' ,`Status` = 'Active' ,`StreetName` = 'Wickwood' ,`StreetNumber` = '11002' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '5' ,`BedsTotal` = '6' ,`SqFtTotal` = '14288' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A magnificent Memorial manor prominently positioned on over 1.7+ acres at the end of a coveted cul-de-sac in prestigious Piney Point Village. This remarkable residence combines impressive architectural elements with regal reception spaces and resort-style amenities in a spectacular setting enhanced by sweeping vistas of the wooded surroundings and natural bayou border. Primary Suite down with adjacent flex room. 3 Guest Suites + Game Room up. Third Floor Bedroom #5. Extraordinary ground-level entertainment extension with Game Room, Media Room, and Conservatory Lounge. An additional Guest Quarters is accessible via a separate staircase and connects to a Home Office with private exterior entry. Elevator. Slate Roof. Loggia with outdoor fireplace. Swimming Pool/Spa. Putting Green. Circular drive and gated motor court with portico parking leads to a 2-car attached Garage. Close proximity to Kinkaid & St Francis Episcopal School.' ,`Acres` = '1.77' ,`Area` = '23' ,`BuilderName` = 'Jim Frankel' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '6' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 1 WILLOWICK ESTATES PAR R/P' ,`LotDesciption` = 'Cul-De-Sac,Ravine,Waterfront,Wooded' ,`LotSize` = '77293' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other,Slate' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEMORIAL DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Photos/No Videos' ,`SqFtSource` = 'Appraisal' ,`Stories` = '3' ,`Style` = 'English,Traditional' ,`Subdivision` = 'Willowick Estates' ,`TaxAmount` = '95795' ,`TaxRate` = '2.1721' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213540' WHERE `Matrix_Unique_ID` = '206037831' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T11:49:24.313' ,`MLSNumber` = '36921345' ,`ListAgentFullName` = 'Elizabeth Robertson' ,`ListOfficeName` = 'Results Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.639426' ,`Longitude` = '-95.235541' ,`PhotoCount` = '21' ,`PostalCode` = '77034' ,`RoomCount` = '3' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Kittrell' ,`StreetNumber` = '10011' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1094' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning curb appeal on this ranch style home located just minutes from down town. Once in a lifetime opportunity to own this understated home that offers both an oversized front and back, fully sodded yards. Pride of ownership with family in mind. Updated floors and paint throughout this 3 bedroom home checks all theses Don\'t miss out this one, you won\'t be able to forgive yourself.' ,`Acres` = '0.1584' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 30 BLK 13 SUN VALLEY SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'GARFIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PASADENA)' ,`SchoolMiddle` = 'MILLER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sun Valley Sec 01' ,`TaxAmount` = '3599' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213540' WHERE `Matrix_Unique_ID` = '206378418' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T12:29:40.263' ,`MLSNumber` = '48491370' ,`ListAgentFullName` = 'Darian Candler' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.621894' ,`Longitude` = '-95.380368' ,`PhotoCount` = '28' ,`PostalCode` = '77047' ,`RoomCount` = '7' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Skyview Knoll' ,`StreetNumber` = '2734' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2731' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1691' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 2 SKY VIEW PARK SEC 6' ,`LotDesciption` = 'Other' ,`LotSize` = '7368' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`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' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Skyview Park Sec 6' ,`TaxAmount` = '7093' ,`TaxRate` = '2.9307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213540' WHERE `Matrix_Unique_ID` = '208277713' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T11:33:10.107' ,`MLSNumber` = '68190984' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.225186' ,`Longitude` = '-95.704815' ,`PhotoCount` = '19' ,`PostalCode` = '77354' ,`RoomCount` = '10' ,`ListPrice` = '426958.00' ,`Status` = 'Active' ,`StreetName` = 'Heron Heights' ,`StreetNumber` = '15175' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 Story, The Sandown Floor Plan with 4 Bedrooms, 3 ½ Baths, with a 2 CAR GARAGE. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Study, Half Bath, and the Master Bedroom & Bath downstairs. Upstairs you will find a Game Room, 3 Bedrooms, and 2 Full Bath. You will love the Kitchen with lots of cabinets and granite countertops with under the cabinet lighting, SS appliances, and even a USB outlet. Window blinds throughout. SPRINKLER SYSTEM and fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot and cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for Cleaning. Located in Magnolia, TX the new master-planned community Audubon will be conveniently on both sides of FM-1488 near Mill Creek Road, just along the TX-249 Toll Road. Magnolia ISD.' ,`Acres` = '0.1455' ,`Area` = '15' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S221203 - AUDUBON CREEKSIDE NORTH 03A, BLOCK 3, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6338' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '539' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675213541' WHERE `Matrix_Unique_ID` = '208900671' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T11:39:18.053' ,`MLSNumber` = '20515081' ,`ListAgentFullName` = 'Marissa Montejano' ,`ListOfficeName` = 'The Local Agents Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.943490' ,`Longitude` = '-95.297920' ,`PhotoCount` = '18' ,`PostalCode` = '77541' ,`RoomCount` = '1' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Thunder' ,`StreetNumber` = '516' ,`StreetSuffix` = 'Road' ,`City` = 'Surfside Beach' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '1' ,`SqFtTotal` = '800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Surfside Beach, TX and your piece of the island life! This home is quite unique and you won\'t find another one just like it anywhere on the island. There is a bedroom downstairs off the kitchen and living area as well as a half bathroom. Up a winding staircase, you will find a large open concept room where the sky is the limit on what you can use it as. There is a full bathroom upstairs as well as a laundry closet. The views from your porch include the beach and the channel. There is ample storage outside the home with a covered carport! Thunder Road has access to the beach as well as the city boat ramp. Come see this house today and get ready to call Surfside Beach home!' ,`Acres` = '0.1205' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'SURFSIDE BLK 552 LOT 8A (REPLAT \'16) (A0051 F J CALVIT)' ,`LotDesciption` = 'Water View' ,`LotSize` = '5249' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'FLEMING ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Surfside' ,`TaxAmount` = '4631' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213541' WHERE `Matrix_Unique_ID` = '209020795' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T11:20:46.820' ,`MLSNumber` = '55455024' ,`ListAgentFullName` = 'Minerva Garza' ,`ListOfficeName` = 'Can-2 Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.737663' ,`Longitude` = '-95.257217' ,`PhotoCount` = '30' ,`PostalCode` = '77029' ,`RoomCount` = '7' ,`ListPrice` = '345500.00' ,`Status` = 'Active' ,`StreetName` = 'Clinton Park' ,`StreetNumber` = '604' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1750' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS CUSTOM PROPERTY OFFERS 3-4 BEDROOMS INCLUDING A STUDIO OR COMPUTER ROOM, LIVING ROOM COMBINATON WITH DINNING AREA OPEN CONCEPT, GRANITE ALL COUNTER TOPS, CERAMIC TILE ,GAS RANGE,MICROWAVE, ALL BRICK SIDE BY SIDE AROUND THE HOUSE , DOUBLE WYDE DRIVE WAY WITH ENTRANCE GATE , FOR SALE IN PRESENT CONDITION ,CALL YOUR AGENT TODAY' ,`Acres` = '0.1515' ,`Area` = '2' ,`BuilderName` = 'JUAN DE LA CRUZ' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 11 CLINTON PARK' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PLEASANTVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GALENA PARK HIGH SCHOOL' ,`SchoolMiddle` = 'HOLLAND MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Clinton Park' ,`TaxAmount` = '810' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675213541' WHERE `Matrix_Unique_ID` = '209065794' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T11:40:18.737' ,`MLSNumber` = '13598515' ,`ListAgentFullName` = 'Jennifer Delaney' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.294921' ,`Longitude` = '-94.801419' ,`PhotoCount` = '7' ,`PostalCode` = '77550' ,`RoomCount` = '5' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = '32nd' ,`StreetNumber` = '1224' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1259' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Starting at 550,000.00 NEW Construction.This open concept 3/2 boasts almost 1300 sq. ft. Built on raised pilings in a preferred flood zone, the exceptional construction of this home is engineered to exceed windstorm building codes, Designed by Plum Construction, the open concept living flows into a custom designed kitchen showcased with built in storage, marble surfaces, designer finishes as well as vintage inspired appliances.The first floor primary bedroom offers it\'s own private terrace and oversized closets. Two spacious bedrooms on the second floor allow for ample space to entertain friends and family. Fully furnished with curated pieces and attention to detail, this home is a true work of art! Centrally located, blocks from The Strand and the Seawall making it the perfect second home/ investment property.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Delaneys Restoration' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 7 (1007-0) BLK 31 RPLT GALVESTON' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2551' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1675213541' WHERE `Matrix_Unique_ID` = '209543574' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T11:22:31.787' ,`MLSNumber` = '96204571' ,`ListAgentFullName` = 'Lillian Ballard' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.741731' ,`Longitude` = '-95.337749' ,`PhotoCount` = '28' ,`PostalCode` = '77023' ,`RoomCount` = '8' ,`ListPrice` = '437770.00' ,`Status` = 'Active' ,`StreetName` = 'Lamar' ,`StreetNumber` = '4106' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1490' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home this bungalow is in one of Houston\'s oldest neighborhoods on the Eastend (EADO) Walking distance from public transit and numerous bike trails. This home is just minutes away from all that Houston has to offer, Minute Maid, Reliant Stadium and much more. Short bike ride to U of H campus, All work done by the seller was done in 2022. The home has been updated with new HVAC system, pex piping, new double paned windows, brushed nickel finishes, ceiling fans, vinyl plank flooring throughout the home with beautiful carpet in the bedrooms interior and exterior painting. Parking has been added to front of the home to alleviate on street city parking. Garage apartment has a split unit AC/Heater, mini kitchen and full bath. Perfect for extended family or could be an income producing addition. Call today to schedule a private tour. Please confirm room dimensions.' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 7 WOODLEIGH' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LANTRIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Woodleigh' ,`TaxAmount` = '5039' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675213542' WHERE `Matrix_Unique_ID` = '209571116' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T11:52:41.693' ,`MLSNumber` = '25493143' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.319019' ,`Longitude` = '-95.457972' ,`PhotoCount` = '25' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '645000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeland' ,`StreetNumber` = '839' ,`StreetSuffix` = 'Circle' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3756' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous CastleRock Communities Eureka Floorplan in lovely Suncreek Estates. 3-Car side-load garage, 8\' interior doors on the first floor, among the many delightful options and upgrades selected. Late November completion.' ,`Acres` = '1' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25 Block 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '43560' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'The Oaks of Suncreek Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.182' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675213542' WHERE `Matrix_Unique_ID` = '209573977' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T12:59:06.133' ,`MLSNumber` = '37884014' ,`ListAgentFullName` = 'Brian Brady' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.361059' ,`Longitude` = '-94.946293' ,`PhotoCount` = '13' ,`PostalCode` = '77327' ,`RoomCount` = '6' ,`ListPrice` = '1