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-10-10T05:33:26.530' ,`MLSNumber` = '34680371' ,`ListAgentFullName` = 'Jenni Meador' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.160065' ,`Longitude` = '-95.630644' ,`PhotoCount` = '20' ,`PostalCode` = '77486' ,`RoomCount` = '7' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Ridgewood' ,`StreetNumber` = '2248' ,`StreetSuffix` = '' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2402' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION 1 STORY HOME, NO BACK NEIGHBORS. LARGE BEDROOMS. OPEN KITCHEN, FORMAL DINING WITH LARGE FAMILY ROOM AND HIGH CEILINGS! MASTER BEDROOM WITH WALK IN CLOSET AND BUILT-INS. DON\'T MISS EVERYTHING THIS BEAUTIFUL NEW HOME HAS TO OFFER!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'WS4 HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COLUMBIA LAKES SEC 3 (A0133 M VARNER) BLK 24 LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14250' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbia Lakes Sec 1-2-3-4-5' ,`TaxAmount` = '1159' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665421312' WHERE `Matrix_Unique_ID` = '208289440' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-10T05:14:40.050' ,`MLSNumber` = '91283550' ,`ListAgentFullName` = 'Marcey Nelson' ,`ListOfficeName` = 'The Cox Company Real Estate Gr' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.705469' ,`Longitude` = '-95.080320' ,`PhotoCount` = '7' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Legend' ,`StreetNumber` = '186' ,`StreetSuffix` = 'Lane' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1850' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction in nice gated community to be completed Once contract is executed allow 4-6 weeks for completion. 3/2/2 on corner lot with adjoining lot #2 also available to be purchased separately. Open concept, foyer, high ceilings, separate den could be used as 4th bedroom or home office. Subdivision amenities include, swimming pool, tennis courts, playground, community center and boat launch. Floor plans may not be exactly like picture some changes may be made.' ,`Acres` = '0.1515' ,`Area` = '44' ,`BuilderName` = 'RigginParadise Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'MEMORIAL POINT BLK 1 Lot 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '129' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Memorial Point' ,`TaxAmount` = '64' ,`TaxRate` = '2.7745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665421312' WHERE `Matrix_Unique_ID` = '209205905' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-10T05:25:07.790' ,`MLSNumber` = '81303468' ,`ListAgentFullName` = 'Kristina Newcomb' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = 'Gidget Sauceda' ,`SellingOfficeName` = 'RE/MAX Integrity' ,`Latitude` = '30.080531' ,`Longitude` = '-95.563594' ,`PhotoCount` = '37' ,`PostalCode` = '77375' ,`RoomCount` = '13' ,`ListPrice` = '430000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Alderdale' ,`StreetNumber` = '22810' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3373' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1.5 story brick/stone home with no back neighbors! Features include a covered front porch, 4 bedrooms down, 3.5 baths with a large 3 car garage and a back covered patio. Spacious living with, tile and wood in main living areas, with split floor plan. Three bedrooms located near the front of the home, large study behind double glass doors with wood grid coffered ceilings, inviting living room with walls of windows for natural light, cast stone gas fireplace, spacious kitchen with island, breakfast nook, stainless appliances, gas cook top, oversized pantry, butler\'s pantry connecting to the formal dining room. Relax in large primary suite & primary bathroom offers dual vanities, tub and shower. Upstairs you find a fun flex space currently being used as a game room with half bath & a media room. Close to community pool & park. Residents enjoy the neighborhood park, pool and facility center. Located near the Grand Parkway and 2920. Minutes to an abundance of shopping & dining.' ,`Acres` = '0.1926' ,`Area` = '14' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 2 INVERNESS ESTATES SEC 9 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8391' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MAHAFFEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Inverness Estates Sec 9 Amd' ,`TaxAmount` = '11372' ,`TaxRate` = '3.0565' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665421312' WHERE `Matrix_Unique_ID` = '210903714' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-10T05:40:27.837' ,`MLSNumber` = '89841220' ,`ListAgentFullName` = 'Nicole Handy' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.471467' ,`Longitude` = '-95.471390' ,`PhotoCount` = '23' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '312801.00' ,`Status` = 'Active' ,`StreetName` = 'Caldwell Creek' ,`StreetNumber` = '7718' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1433' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DR Horton, America\'s #1 Builder! NEW CONSTRUCTION Bellvue Plan with Elevation N, features a modern design and offers 3 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\"\" cabinets, and stainless & steel appliances. Delight yourself in the primary bathroom, with dual sinks, separate shower, garden tub (on select inventory homes) and a large walk-in closet! (All information provided by builder). Located in Rosharon\'s newest DR Horton Community, Caldwell Ranch this gorgeous community will feature a resort-style pool, Covered Pavilion with Picnic Tables, Splash areas, Water Slides, Soccer Fields, and miles of walking trails. Visit our onsite sales center today!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'DR HORTON, INC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Caldwell Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665421312' WHERE `Matrix_Unique_ID` = '211172427' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-10T05:50:25.730' ,`MLSNumber` = '13732415' ,`ListAgentFullName` = 'Lauren Edwards' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.408241' ,`Longitude` = '-95.671336' ,`PhotoCount` = '48' ,`PostalCode` = '77356' ,`RoomCount` = '10' ,`ListPrice` = '895000.00' ,`Status` = 'Active' ,`StreetName` = 'Serene Water' ,`StreetNumber` = '18839' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful waterfront home sits on 1/2 an acre in the gated community of Grand Harbor on Lake Conroe. The home has been recently updated and remodeled with stunning finishes, offering a turn-key move-in. A few noteworthy updates include new paint on the interior and exterior of the home, all new flooring, primary bathroom remodel, and new roof in 2022. This property offers lake living at its best – a large lot, quiet neighborhood, short boat ride to the open water, and an impressive house to call home.' ,`Acres` = '0.5036' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S538009 - GRAND HARBOR 09, BLOCK 4, LOT 3' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '21936' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Grand Harbor 09' ,`TaxAmount` = '11125' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665421312' WHERE `Matrix_Unique_ID` = '212386782' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-10T05:53:03.540' ,`MLSNumber` = '68739294' ,`ListAgentFullName` = 'Christina Pizzitola' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.689881' ,`Longitude` = '-95.480095' ,`PhotoCount` = '50' ,`PostalCode` = '77096' ,`RoomCount` = '13' ,`ListPrice` = '1475000.00' ,`Status` = 'Active' ,`StreetName` = 'Edith' ,`StreetNumber` = '5411' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5353' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '5411 Edith Street has everything you have been looking for, and more! This beautiful 2007(per HCAD) Brookstone Home situated on a 10,500 square foot lot (per HCAD) features 5-bedrooms, 4.5-bathrooms, TWO utility rooms and a game room! Upon entry into this 5,353 square foot house (Per HCAD), you’ll find the gorgeous office/library with newly installed windows, formal dining room, and the perfect wine room for entertaining! The Kitchen features a large island & breakfast area, which then opens to the Family Room where you will enjoy looking out onto the expansive backyard and gated pool. The large Primary Suite features a separate sitting area and Primary Bathroom which offers dual vanity sinks, a walk-in shower, soaking tub, and a walk-in closet with built-ins. The property has a two-car garage, and a two-car porte-cochere. Near Meyerland Shopping, Downtown and the Medical Center! Come see this fabulous home today!All info per seller' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = 'BROOKSTONE HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 2 BRAES VIEW TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed,Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Braes View Terrace' ,`TaxAmount` = '22934' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665421312' WHERE `Matrix_Unique_ID` = '212421136' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-10T05:29:24.000' ,`MLSNumber` = '24077489' ,`ListAgentFullName` = 'George Huntoon' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.514965' ,`Longitude` = '-94.481274' ,`PhotoCount` = '45' ,`PostalCode` = '77617' ,`RoomCount` = '3' ,`ListPrice` = '1150000.00' ,`Status` = 'Active' ,`StreetName` = 'Hwy 87' ,`StreetNumber` = '2366' ,`StreetSuffix` = '' ,`City` = 'Gilchrist' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2135' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing 1-owner BEACHFRONT home w/90ft of beachfront access on 3/4 acre lot. 3 Bedrooms, 4 Full Baths Custom built w/many extras. Four decks, one with gazebo, all w/great views. Large 1st floor living room with high shiplap ceilings opening to kitchen area. Large kitchen, perfect for family gatherings. Many windows throughout for optimal views of Beach/Ocean. Master Bedroom 1st floor. Upstairs Game Room. All bedrooms have a private baths. New A/C & exterior paint. Outdoor bar on ground level. Stainless steel BBQ grill in yard. House can sleep up to 16 people. This is the perfect home for family gatherings or an income producing rental. Please see Virtual Tour.' ,`Acres` = '0.6271' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Gilchrist' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 52 J DUNMAN SUR LOT 1 HOGANS LANDING UNRECORDED SUB' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '27315' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '25 - High Island' ,`SchoolElementary` = 'HIGH ISLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HIGH ISLAND HIGH SCHOOL' ,`SchoolMiddle` = 'HIGH ISLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hogans Landing' ,`TaxAmount` = '7383' ,`TaxRate` = '1.5543' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665421313' WHERE `Matrix_Unique_ID` = '212878023' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-10T05:52:27.097' ,`MLSNumber` = '4694395' ,`ListAgentFullName` = 'Sarah Conway' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.428126' ,`Longitude` = '-95.629862' ,`PhotoCount` = '50' ,`PostalCode` = '77356' ,`RoomCount` = '9' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = 'Wick Willow' ,`StreetNumber` = '18' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2205' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Bentwater Treasure! Remarkable opportunity – Backyard Oasis w/ stunning pool, spa, waterfalls, & stunning Outdoor Living area w/ Summer Kitchen fit for a Chef, Oversized Serving Bar, and 3 storage closets! This Beautiful brick One-Story has a timeless floorplan & many appointments. The welcoming foyer opens to a study w/ abundant shelving & French doors. Open LivingRM w/ cozy fireplace, Kitchen w/ attractive island & gleaming granite countertops, & accommodating Dining. Magnificent Owners Retreat w/ well-appointed ensuite Bath. Secondary BRs located off private hallway. This Private Backyard Includes a Fabulous Screened Patio & backs up to a Seasonal Creek for added privacy. Sought after Montgomery ISD. Enjoy life like you\'re on a vacation with access to the country club, THREE 18-hole championship golf courses, the yacht club, sports club, pickle ball, dog park, and 24 hr manned gate!!! UPDATES: Roof (2022), H2O Heater (2022), AC Condenser (2021). Masters Golf Membership Available.' ,`Acres` = '0.3668' ,`Area` = '39' ,`BuilderName` = 'BUYOURHOME Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 09, BLOCK 3, LOT 10' ,`LotDesciption` = 'Cleared,Greenbelt,In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '15979' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1146' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '6954' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665421313' WHERE `Matrix_Unique_ID` = '212982868' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-10T05:40:15.823' ,`MLSNumber` = '66237702' ,`ListAgentFullName` = 'Claudia Oakley' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.194020' ,`Longitude` = '-94.714375' ,`PhotoCount` = '48' ,`PostalCode` = '75941' ,`RoomCount` = '7' ,`ListPrice` = '785000.00' ,`Status` = 'Active' ,`StreetName` = 'Old Burke' ,`StreetNumber` = '3540' ,`StreetSuffix` = 'Road' ,`City` = 'Diboll' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this one of kind, custom built country home on 6 acres! You are welcomed through the gated private drive where you will find main residence with over 2,750 sq. ft. This home has been completely renovated! Spacious gourmet kitchen with a 9.5 ft. custom made butcher block island, top of the line stainless appliances including a Kutch professional gas oven, Dekon countertops, farm sink, and large pantry. Laundry room with farm sink and cedar lined storage room/second pantry. Formal dining and private office with french pocket doors. The oversized family room with floor to ceiling windows is the perfect place to relax & enjoy views of the immaculately maintained backyard w/covered patio! 3 car garage with second story unfinished apartment or extra storage. Adjacent to the main house you will find a fully equipped cottage style guest house 2bedrooms 1bath. Underground wiring to all 3 locations. 4,000 sq.ft. shop, well house and a chicken house! Low utilities. \r\nA must see!!!' ,`Acres` = '5.99' ,`Area` = '45' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angelina County' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'ABS 0031 MORIN J.,TRACT 1.1.1,ACRES 5.99' ,`LotDesciption` = 'Wooded' ,`LotSize` = '260924' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '266 - Diboll' ,`SchoolElementary` = 'TEMPLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DIBOLL HIGH SCHOOL' ,`SchoolMiddle` = 'DIBOLL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'ABS 0031 MORIN J.,TRACT 1.1.1,ACRES 5.99' ,`TaxAmount` = '5945' ,`TaxRate` = '1.8119' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665421313' WHERE `Matrix_Unique_ID` = '213047684' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213112186','1665421313','213112186','2022-10-10T04:10:01.107','18715888','John Nguyen','JN Realty Group, LLC','','','29.925585','-95.619424','15','77065','11','395900.00','Active','Durbridge Trail','13418','Drive','Houston','2','1','4','3090','Single-Family','Wonderful area with park near home.Great for kids.Located in wonderful sought after CyFair/Copperfield area. Beautiful ceramic tile in wet areas w/hard wood floor,crown molding thoughout,home features a breakfast bar,large backyard,42\' cabinets,chair railing,mirrored wall in formal,decorative paint, beveled glass/wood front door,sprinkler system,solar tint on windows,beautiful archways,soaring ceilings in family rm, sitting area in master. No flooding. Low tax rate. THIS WONT LAST LONG!!!FABULOUS HOME!!!','0.195','10','Kimball Hill','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','1960/Cypress','Central Gas','1','LT 1 BLK 5 WORTHAM GROVE SEC 2','Cleared,Subdivision Lot','8494','Appraisal District','','560','0','','2','Gas Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','ADAM ELEMENTARY SCHOOL','CY-FAIR HIGH SCHOOL','ARNOLD MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Wortham Grove Sec 02','6901','2.341','Public Sewer,Public Water','2001','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-10T05:41:11.063' ,`MLSNumber` = '39780077' ,`ListAgentFullName` = 'Nicole Handy' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.469909' ,`Longitude` = '-95.463892' ,`PhotoCount` = '29' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Caspian Ranch' ,`StreetNumber` = '7723' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1817' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DR Horton, America\'s #1 Builder! NEW CONSTRUCTION Cali Plan with Elevation L, features a modern design and offers 4 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\" cabinets, and stainless & steel appliances. Delight yourself in the primary bathroom, with dual sinks, separate shower, garden tub (on select inventory homes) and a large walk-in closet! (All information provided by builder). Located in Rosharon\'s newest DR Horton Community, Caldwell Ranch this gorgeous community will feature a resort-style pool, Covered Pavilion with Picnic Tables, Splash areas, Water Slides, Soccer Fields, and miles of walking trails. Visit our onsite sales center today!\r\n\r\nListing photos are of a similar floor plan. Finishes may vary and are subject to change.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'D.R. HORTON, INC.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Caldwell Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665421313' WHERE `Matrix_Unique_ID` = '213372491' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-10T04:17:29.460' ,`MLSNumber` = '89518206' ,`ListAgentFullName` = 'Karol Deem' ,`ListOfficeName` = 'Deem Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.244480' ,`Longitude` = '-94.902283' ,`PhotoCount` = '33' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '590000.00' ,`Status` = 'Active' ,`StreetName` = 'Zingelmann' ,`StreetNumber` = '11631' ,`StreetSuffix` = 'Road' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1419' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two Acres on dead end country road with horses & cows for neighbors. Three bedrooms, two baths, 1419 square feet split level with concrete below. Home renovated with recent roof, HVAC, vinyl wood look flooring, paint inside and out, vinyl insulated windows, lights, ceiling fans, plugs, switches, electric hot water heater, exterior electric meter disconnect switch, bathroom fixtures, water line from street, closed cell insulation on ceiling below and soffit below. Includes all new appliances. Owner/agent. Ready to move in. Enter by dirt driveway and park in rear of home.' ,`Acres` = '2' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 PAGE 58 PT OF LOT 161 (161-13) TRIMBLE & LINDSEY SE' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Lockbox Back,Lockbox Left Side,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Trimble & Lindsey Sec 2' ,`TaxAmount` = '3642' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665421313' WHERE `Matrix_Unique_ID` = '213469743' --> Updated record success