Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>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)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T05:10:32.553' ,`MLSNumber` = '29368096' ,`ListAgentFullName` = 'Richard Tanner' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.460164' ,`Longitude` = '-95.051012' ,`PhotoCount` = '18' ,`PostalCode` = '77539' ,`RoomCount` = '4' ,`ListPrice` = '325900.00' ,`Status` = 'Active' ,`StreetName` = 'New Iberia' ,`StreetNumber` = '5327' ,`StreetSuffix` = 'Lane' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '(MODEL HOME) PRIVATE WATERFRONT COMMUNITY!  This gorgeous 3 bedroom home comes with a 4th room that can either be wonderful 4th bedroom or STUDY/OFFICE!! A LARGE COVERED PORCH in the back makes for wonderful space to enjoy the privacy of your back yard, no matter the weather! Included is also a BREAKFAST NOOK for casual meals or a FORMAL DINING ROOM for those holiday dinners!!! It\'s conveniently located to 1-45 for easy commutes and has great Dickinson Schools! Since 1991 Adams homes has taken great pride in quality construction along with excellent utilization of space and believes \"The Good life DESERVES a GREAT Home!\" This home dons an upgraded backsplash, granite counter-tops, Stainless Steel appliances, brushed nickel finishes, FULLY SODDED yard, 4 sides brick and so much more!' ,`Acres` = '0.1441' ,`Area` = '33' ,`BuilderName` = 'Adams Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1 BLK 3 BAYOU MAISON SEC 2 (2020) ABST 60 & 155' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '6275' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Bayou Maison' ,`TaxAmount` = '' ,`TaxRate` = '2.74' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664795499' WHERE `Matrix_Unique_ID` = '186300943'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T05:11:12.787' ,`MLSNumber` = '15211316' ,`ListAgentFullName` = 'Richard Tanner' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.378442' ,`Longitude` = '-95.004136' ,`PhotoCount` = '13' ,`PostalCode` = '77539' ,`RoomCount` = '8' ,`ListPrice` = '308900.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Maison' ,`StreetNumber` = '4205' ,`StreetSuffix` = 'Circle' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2025' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AVAILABLE FOR IMMEDIATE MOVE IN. This open floor plan has spacious bedrooms and  upgraded ceramic plank floors in kitchen/ living area. Kitchen opens up into living area and primary bedroom is downstairs. Upstairs is  a spacious loft area and has 3 generously spaced bedrooms with a full bath and double sinks. Kitchen counter top has a breakfast bar for those grab and go mornings. This home is located in Dickinson I.S.D. and comes with stainless steel built in appliances, 1st level 4 sides brick and fully sodded yards.' ,`Acres` = '0.1102' ,`Area` = '33' ,`BuilderName` = 'ADAMS HOMES' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 14 BLK 3 BAYOU MAISON SEC 2 (2020) ABST 60 & 155' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SIMMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'BAYOU MAISON' ,`TaxAmount` = '3263' ,`TaxRate` = '2.6502' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664795499' WHERE `Matrix_Unique_ID` = '203063219'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T05:11:41.320' ,`MLSNumber` = '73846516' ,`ListAgentFullName` = 'Richard Tanner' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.461571' ,`Longitude` = '-95.026307' ,`PhotoCount` = '6' ,`PostalCode` = '77539' ,`RoomCount` = '5' ,`ListPrice` = '310400.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Maison' ,`StreetNumber` = '4405' ,`StreetSuffix` = 'Circle' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out this private gated waterfront community!! This charming home is near the bayou with a greenbelt behind it. The 1820 open floor plan offers three bedrooms and an office. Formal dining opens into living and kitchen making entertaining easy! All Adams homes offer granite counter-tops, stainless steel appliances, brush nickel finishes, fully sodded front and back yards and much more. Bayou Maison is conveniently located between I-45 and 146.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Adams Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'lot 2 Block 1 sec 3 Bayou Maison' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bayou Maison' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664795499' WHERE `Matrix_Unique_ID` = '209307693'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T05:19:13.090' ,`MLSNumber` = '72712885' ,`ListAgentFullName` = 'Richard Tanner' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.461434' ,`Longitude` = '-95.026291' ,`PhotoCount` = '5' ,`PostalCode` = '77539' ,`RoomCount` = '6' ,`ListPrice` = '319400.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Maison' ,`StreetNumber` = '4409' ,`StreetSuffix` = 'Circle' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out this private gated waterfront community!! This charming home is near the bayou with a greenbelt behind it. The 1900 open floor plan offers three bedrooms with a huge master. This home as nice front and back porch!!All Adams homes offer granite counter-tops, stainless steel appliances, brush nickel finishes, fully sodded front and back yards and much more. Bayou Maison is conveniently located between I-45 and 146.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Adams Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 blk 1' ,`LotDesciption` = 'Greenbelt,Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Bayou Maison' ,`TaxAmount` = '' ,`TaxRate` = '2.7' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664795500' WHERE `Matrix_Unique_ID` = '210083962'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T04:44:43.850' ,`MLSNumber` = '23396992' ,`ListAgentFullName` = 'William Jenkins' ,`ListOfficeName` = 'The Hatmaker Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.276395' ,`Longitude` = '-94.841942' ,`PhotoCount` = '45' ,`PostalCode` = '77551' ,`RoomCount` = '3' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Bernardo de Galvez' ,`StreetNumber` = '6914' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1482' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great newer construction home in a quiet neighborhood a stone\'s throw from Parker and Oppe Elementary Schools, Moody Gardens, Schlitterbahn, Babes Beach, grocery stores, restaurants, pharmacies and the boat club. Built in 2011, the house is completely elevated, including a back storage/bonus room.  The main floor has a living room that is open to the kitchen/dining area.  Washer and dryer hookups are in the utility room off the dining area and there is lots of storage under the stairs and in the pantry. The kitchen has a gas oven/range and built in microwave. There is a main floor full bath on the way to the main floor bedroom with the back door opening to back stairs and the bonus storage room.  Upstairs are two good sized bedrooms with closets and all of the bedrooms have study/bookshelf nook areas.  The house if fully centrally heated and cooled and has tons of storage space underneath.' ,`Acres` = '0.0717' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Near West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 PAGE 78 LOT 20 BLK 3 PABSTS\' BAYVIEW ADDN' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '3125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pabst Bayview' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664795500' WHERE `Matrix_Unique_ID` = '211225139'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T05:23:47.927' ,`MLSNumber` = '44554309' ,`ListAgentFullName` = 'Stephen Sheffer' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.124236' ,`Longitude` = '-95.515533' ,`PhotoCount` = '32' ,`PostalCode` = '77389' ,`RoomCount` = '9' ,`ListPrice` = '524900.00' ,`Status` = 'Active' ,`StreetName` = 'Holden Mills' ,`StreetNumber` = '6306' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3562' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful updated 4 bedroom 3.5 bath 2-story home in Auburn Lakes on a cul-de-sac lot features a 2-story entry and stunning family room w/ 18 foot ceilings & stacked windows that overlook the oasis like backyard and pool! The home features an open floor plan. Private primary suite down w/ updated primary bath, dual walk in closet & door from the sitting area to the backyard for private escapes! Large gourmet island kitchen with recently updated custom cabinets, lighting, Azurite countertops, & stainless steel appliances. Downstairs is complete with formal dining and study. Oversized game room upstairs with 3 large bedrooms & two baths. 3-car detached garage! Recent roof (\'22), pool resurface (\'22), interior paint (\'22), and new carpet! Zoned to outstanding Klein ISD schools!' ,`Acres` = '0.3017' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 2 VILLAGE OF AUBURN LAKES SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13143' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRENCH ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Auburn Lakes Sec 01' ,`TaxAmount` = '10408' ,`TaxRate` = '2.914' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664795500' WHERE `Matrix_Unique_ID` = '211344269'  --> Updated record success<br />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','212092001','1664795500','212092001','2022-10-03T05:13:33.433','97004266','Trina Roberson','BHGRE Gary Greene','','','29.959687','-95.647614','22','77429','10','339500.00','Active','Rolling Valley','12807','Drive','Cypress','2','1','4','2340','Single-Family','No Flooding! This lovely home was completely renovated a few years ago. September 2022 the interior was freshly painted, landscaping updated, exterior paint and the driveway was repaired.','0.2112','10','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Cypress North','Central Gas','1','LT 17 BLK 3 ENCHANTED VALLEY SEC 1','Subdivision Lot','9200','Appraisal District','','450','0','','1','Double Oven,Electric Oven','0','','','Electric Cooktop','','Composition','13 - Cypress-Fairbanks','MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CY-FAIR HIGH SCHOOL','ARNOLD MIDDLE SCHOOL','Lockbox Back','Appraisal District','1','Ranch,Traditional','Enchanted Valley Sec 01','5462','2.806','Water District','1970','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T04:02:12.653' ,`MLSNumber` = '10643688' ,`ListAgentFullName` = 'Gwen Cannon' ,`ListOfficeName` = 'White Label Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.514964' ,`Longitude` = '-95.074480' ,`PhotoCount` = '48' ,`PostalCode` = '77573' ,`RoomCount` = '18' ,`ListPrice` = '999500.00' ,`Status` = 'Active' ,`StreetName` = 'Dellore' ,`StreetNumber` = '1919' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '5644' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If seclusion, space and class are what you are looking for… look no further! This property is over 2 acres hidden within the heart if League City and has the charm of being in the country. This custom gated spread hosts 2 complete homes with the larger home having 4 bedrooms with game room and the second home is a smaller replica of the larger one with 2 primary bedrooms, office and a complete kitchen. The second home could be a MIL wing, guest home or a tenant space. There is a large shop/garage on the property that has an office with air and a full bath. There is plenty room in the shop for a large motor home. The options for this property are endless. The roof was replaced in 2017, the larger home has 2 ac units that were replaced in 2018. A security gate surrounds the property with 2 entrances. The interior walls are insulated and the has bell bottom piers. The outdoor area is beautiful and offers beauty and peace.' ,`Acres` = '2.3' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 18 M MULDOON SUR PT OF LOT 18 (18-5) DIV C LEAGUE CITY' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Greenbelt' ,`LotSize` = '100168' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '6' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'LEAGUE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'LEAGUECITY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'League City Div C' ,`TaxAmount` = '23143' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Other Water/Sewer,Well' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664795500' WHERE `Matrix_Unique_ID` = '212125367'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T05:55:57.877' ,`MLSNumber` = '83722597' ,`ListAgentFullName` = 'Ryan Green' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Janet Vittur' ,`SellingOfficeName` = 'Texas All American Real Estate' ,`Latitude` = '29.919522' ,`Longitude` = '-95.074902' ,`PhotoCount` = '41' ,`PostalCode` = '77532' ,`RoomCount` = '5' ,`ListPrice` = '349900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Mediterranean' ,`StreetNumber` = '16411' ,`StreetSuffix` = 'Street' ,`City` = 'Crosby' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3485' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious, light-filled, and filled with character – this five-bedroom residence in Crosby is designed to present an enviable blend of immaculate comfort and a clear touch of elegance. Its over 3,400 square foot floor plan features five bedrooms, a good-sized yard, inviting living areas promising high-quality entertaining, home office, and formal dining room. Step through the front door and be greeted by an inviting entrance with cathedral ceilings. The living area features a cozy fireplace. The household chef is sure to enjoy the kitchen with plenty of bench space, kitchen island and stainless steel appliances to indulge their love of cooking. Upstairs you will find secondary suite with en suite bathroom, three additional bedrooms, Jack n Jill style bathroom, and generously sized game room area. The interior is freshly painted. Outside, you will be treated to ample outdoor space. Schedule a showing to discover the relaxed lifestyle you deserve.' ,`Acres` = '0.2365' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 13 NEWPORT SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '55' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Sec 01' ,`TaxAmount` = '6996' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664795500' WHERE `Matrix_Unique_ID` = '212644950'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T05:04:09.033' ,`MLSNumber` = '63927789' ,`ListAgentFullName` = 'Richard Tanner' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.464412' ,`Longitude` = '-95.026748' ,`PhotoCount` = '9' ,`PostalCode` = '77539' ,`RoomCount` = '8' ,`ListPrice` = '297900.00' ,`Status` = 'Active' ,`StreetName` = 'New Iberia' ,`StreetNumber` = '5323' ,`StreetSuffix` = 'Lane' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRIVATE GATED WATERFRONT COMMUNITY!!! This WONDERFUL OPEN FLOORPLAN has generously portioned bedrooms. The formal dining opens to the living and kitchen and the granite counter has breakfast bar is perfect for those \"Grab & Go\" mornings. This WATERFRONT community is conveniently located to 1-45 for easy commutes and has great Dickinson Schools! Since 1991 Adams homes has taken great pride in quality construction along with excellent utilization of space and believes \"The Good life DESERVES a GREAT Home!\" This home dons granite counter-tops, Stainless Steel appliances, brushed nickel finishes, FULLY SODDED yards, 4 sides brick and so much more! Bayou Maison is a short drive to great dining, entertainment and plenty of shopping!' ,`Acres` = '0.1492' ,`Area` = '33' ,`BuilderName` = 'ADAMS HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 2 BLK 3 BAYOU MAISON SEC 2 (2020) ABST 60 & 155' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Bayou Maison' ,`TaxAmount` = '172' ,`TaxRate` = '2.6502' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664795500' WHERE `Matrix_Unique_ID` = '212864749'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T04:12:02.000' ,`MLSNumber` = '12068005' ,`ListAgentFullName` = 'Artt Levy' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.070101' ,`Longitude` = '-95.418254' ,`PhotoCount` = '43' ,`PostalCode` = '77373' ,`RoomCount` = '11' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Morgan' ,`StreetNumber` = '25907' ,`StreetSuffix` = 'Springs' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED!! This Beautiful 2 story home is in a private gated Spring Lake community. The open floor plan with lots of cabinet storage space in the kitchen includes a solid kitchen island with granite counters. Has a breakfast area open to the living room. The living has a 2-story ceiling with lots of natural lighting and a beautifully designed fireplace with a hearth. The primary suite is located downstairs, with all other bedrooms upstairs: wood floors, tile, and carpet throughout the home and gable ceilings. The media room is separate from the game room. The backyard fully fenced and has plenty of space for entertaining. Including a huge covered patio.' ,`Acres` = '0.2277' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 SPRING LAKES SEC 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '815' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'SALYERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'SPRINGWOODS VILLAGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Lakes Sec 15' ,`TaxAmount` = '8866' ,`TaxRate` = '2.9067' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664795501' WHERE `Matrix_Unique_ID` = '212874482'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T05:26:24.270' ,`MLSNumber` = '53945398' ,`ListAgentFullName` = 'Richard Tanner' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.464336' ,`Longitude` = '-95.027999' ,`PhotoCount` = '7' ,`PostalCode` = '77539' ,`RoomCount` = '7' ,`ListPrice` = '302400.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Maison' ,`StreetNumber` = '4201' ,`StreetSuffix` = 'Circle' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2227' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRIVATE GATED WATERFRONT COMMUNITY!  This WONDERFUL OPEN FLOORPLAN downstairs has generously portioned bedrooms upstairs. Kitchen opens to the living area and has a double sink island . Home is great for entertaining family and guest.  This WATERFRONT community is conveniently located to 1-45 for easy commutes and has great Dickinson Schools! Since 1991 Adams homes has taken great pride in quality construction along with excellent utilization of space and believes \"The Good life DESERVES a GREAT Home!\" This home dons granite counter-tops, Stainless Steel appliances, brushed nickel finishes, FULLY SODDED yards, 4 sides brick and so much more!' ,`Acres` = '0.1102' ,`Area` = '33' ,`BuilderName` = 'Adams Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 16 BLK 3 BAYOU MAISON SEC 2 (2020) ABST 60 & 155' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Bayou Maison' ,`TaxAmount` = '127' ,`TaxRate` = '2.6502' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664795501' WHERE `Matrix_Unique_ID` = '212875158'  --> Updated record success<br />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','213204078','1664795501','213204078','2022-10-03T05:48:50.427','47541782','Cristina Riol','HomeSmart','','','29.574347','-95.362306','11','77584','10','300000.00','Active','Wellsford','1027','Drive','Pearland','2','0','3','2085','Single-Family','NEVER FLOODED! Situated in the middle of the highly desirable Southdown neighborhood in Pearland. This home is a single story, open concept 3/2/2.  Fireplace centers the Family Room with a wall of windows overlooking the gorgeous pool in the backyard. The home features an extra large kitchen open to the breakfast area and the living room, separate shower and garden tub, pool, and not a single stair in sight. Needs flooring throughout - just an opportunity to put in your personal touch. Conveniently located near SH-288, Pearland Medical Center, and Town Center. Schedule your showing today!','0.1446','5','Lennar','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Pearland','Central Electric','1','SOUTHDOWN S/D, BLOCK 5, LOT 14 SEC 5, A0310 H T & B','Subdivision Lot','6299','Appraisal District','','200','0','','2','Single Oven','1','In Ground','','Electric Range','','Composition','42 - Pearland','CHALLENGER ELEMENTARY SCHOOL','GLENDA DAWSON HIGH SCHOOL','BERRY MILLER JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Southdown','6567','2.5552','Public Sewer,Public Water','1996','Appraisal District');  --> New record created successfully<br />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','213227760','1664795501','213227760','2022-10-03T04:45:23.490','81669175','Ebony Royal','Braden Real Estate Group, LLC','','','29.894538','-95.435522','5','77047','3','294990.00','Active','Barnsbury','12808','Lane','Houston','2','0','3','1288','Single-Family','D.R. Horton is America\'s #1 Builder since 2002! Want to live the suburban life close Downtown Houston, The Medical Center, and NRG Stadium? You have found a highly sought after neighborhood that offers you modern designs at affordable pricing. Come out an see this NEW CONSTRUCTION Amber plan with elevation N. \r\n\r\nThe OPEN CONCEPT design features 3 bedrooms, 2 baths, a beautiful kitchen that includes quartz countertops, 42\" inch cabinets, large bar area, and stainless steal appliances including gas stove, built-in microwave, and dishwasher. Enjoy the oversized shower in the Primary Bath, along with a large walk-in closet. Water resistant vinyl flooring, 2\" blinds, and tankless water heater also included. Don\'t pass up this opportunity, this is one of the last opportunities left in this section of the subdivision.\r\n*PHOTOS ARE NOT PICTURES OF THE ACTUAL HOME BUT ARE A REPRESENTATION*','','11','D.R. Horton','','','','No Disclosures','','','','Northwest Houston','Central Gas','1','Lot 9 Block 1 Section 5','Subdivision Lot','','','','1200','1','Never Lived In','2','Gas Oven','0','','','Gas Cooktop','','Composition','1 - Aldine','HILL ELEMENTARY SCHOOL (ALDINE)','EISENHOWER HIGH SCHOOL','GARCIA MIDDLE SCHOOL','Appointment Required','Builder','1','Contemporary/Modern','City Gate','','','Water District','2022','Builder');  --> New record created successfully<br />