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` = '2023-01-15T13:37:52.880' ,`MLSNumber` = '23913170' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Newmark Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.133336' ,`Longitude` = '-95.315708' ,`PhotoCount` = '20' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '498000.00' ,`Status` = 'Active' ,`StreetName` = 'North Enchanted Rock' ,`StreetNumber` = '21758' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEWMARK HOMES NEW CONSTRUCTION - Vienna - Welcome home to 21758 North Enchanted Rock Drive located in the master planned community of The Highlands and zoned to New Caney ISD. This gorgeous home will feature 4 bedrooms, 3.5 baths and an attached 2 car garage. Come by to see how much this home will have to offer, estimated completion is January 2023!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '010139' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1420' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'The Highlands' ,`TaxAmount` = '' ,`TaxRate` = '3.38' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675151872' WHERE `Matrix_Unique_ID` = '212035472'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-15T13:53:33.830' ,`MLSNumber` = '22526032' ,`ListAgentFullName` = 'Rosaura Arango' ,`ListOfficeName` = 'The Monarch Team, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768739' ,`Longitude` = '-95.401345' ,`PhotoCount` = '42' ,`PostalCode` = '77007' ,`RoomCount` = '3' ,`ListPrice` = '660000.00' ,`Status` = 'Active' ,`StreetName` = 'Barnes' ,`StreetNumber` = '4005' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2225' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home...This property is located in the heart of Rice Military with easy access to Downtown Houston!! The first floor has a bedroom that includes a fridge and a spacious suite bar that can potentially be used as a short-term rental. All bedrooms are very spacious with walk-in closets! The primary room has an extra-large walk-in closet connected to the double vanity luxurious bathroom! Light sleeper?! The primary bedroom has soundproof isolation within the walls that\'s definitely a plus! The 4th story welcomes you to a rooftop patio that\'s perfect for a summer BBQ. In addition, for our furry best friends there is access to a dog park/play area right aside from the backyard. Furniture negotiable with reasonable offers. Inquire within for more information!!' ,`Acres` = '0.0415' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 MEMORIAL PATIO HOMES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1808' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1195' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Memorial Patio Homes' ,`TaxAmount` = '12738' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675151872' WHERE `Matrix_Unique_ID` = '212183797'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-15T14:16:33.890' ,`MLSNumber` = '3225121' ,`ListAgentFullName` = 'Ricki Bergeron' ,`ListOfficeName` = 'Bridgecrest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.183786' ,`Longitude` = '-94.973793' ,`PhotoCount` = '48' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Edward Teach' ,`StreetNumber` = '16603' ,`StreetSuffix` = '' ,`City` = 'Jamaica Beach' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '814' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REDUCED -  Location, Location! This 2/1 home is located on Extra Large Lot Corner of Edward Teach & Buccaneer. Enjoy morning coffee on Huge 45X11 deck or Enjoy a Breezy Gulf View w/your favorite beverage in the Eve. Home sold fully furnished w/few exceptions. All you need are Clothes & Bathing Suit! Lot South of House is 8910 sqft available for purchase as well. Yellow etched outline shows House w/side lot & Solid Yellow outline shows Additional Lot Together. Plenty of room to add on to House, Build Garage/Man Cave or Build another House for Rental Income. The possibilities are Endless!! Upgrades include, Ceiling Fans/Blinds, Extended Deck & Stairway 2022, Quartz Countertops in Kitchen & Bath 2021 w/new SS Appliances convey. Plumbing & Electrical upgrades 2020. New HVAC July 2022. Large Corner Lot w/mature landscaping for private downstairs patio. Less than 5 minute walk/golf cart ride to Beach. Home in Rental pool-rental history available. Call Now to Preview Your Best Investment Yet!' ,`Acres` = '0.2045' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 9 BLK 1 JAMAICA BEACH SEC 1 RE' ,`LotDesciption` = 'Cleared,Corner,Water View' ,`LotSize` = '8910' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '10' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding 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` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jamaica Beach 1' ,`TaxAmount` = '3214' ,`TaxRate` = '1.7044' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675151872' WHERE `Matrix_Unique_ID` = '212953598'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-15T13:57:05.997' ,`MLSNumber` = '57068112' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Newmark Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.674121' ,`Longitude` = '-95.898366' ,`PhotoCount` = '20' ,`PostalCode` = '77441' ,`RoomCount` = '9' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Southpoint Way Ct' ,`StreetNumber` = '30502' ,`StreetSuffix` = '' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful newly designed Como plan by Newmark Homes.   Four bedroom home with 2 bedrooms down for unique family needs.  Home grabs your attention with the beautiful stucco exterior followed by a charming courtyard at the front entry.    Upon entering the home you have a private study off to the left with double French doors. Stunning staircase and open dining area gives a very open feel as you enter. Spectacular hardwood floors greet you and flow throughout the family room and kitchen breakfast area which also include stacked cabinets in the kitchen.    Family room displays a bay window on the rear and numerous windows to look into the back yard.  Final touches include a huge back covered patio, a freestanding tub in the main suite with a separate shower, quartz counters, and exquisite tile accents.    8 foot doors on the first level add that luxurious touch that finishes out the home.  This is a show stopper in our 60 foot lot section!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Newmark' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11 Block 2' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8705' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fulbrook on Fulshear Creek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675151873' WHERE `Matrix_Unique_ID` = '213727746'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-15T14:31:58.520' ,`MLSNumber` = '11572169' ,`ListAgentFullName` = 'Charon Marshall' ,`ListOfficeName` = 'Gulf Coast, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.506512' ,`Longitude` = '-94.977748' ,`PhotoCount` = '28' ,`PostalCode` = '77518' ,`RoomCount` = '4' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = '1st' ,`StreetNumber` = '4816' ,`StreetSuffix` = 'Street' ,`City` = 'Bacliff' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3018' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This great 4 bedroom 2 1/2 bath nestled in the trees sits on 3 lots on a dead end street. Just Blocks from the Galveston Bay and the famous Noah\'s. You will be just minutes from Kemah and a short drive to Downtown Houston or Galveston Island.' ,`Acres` = '0.2152' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 164 E PAYNE SUR LOTS 5,6 & 7 BLK 33 CLIFTON BY THE SEA' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'KENNETH E. LITTLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Clifton By The Sea' ,`TaxAmount` = '3231' ,`TaxRate` = '2.2342' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675151873' WHERE `Matrix_Unique_ID` = '214137566'  --> 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','215360851','1675151873','215360851','2023-01-15T14:51:17.227','98692534','Faheem Ghaffar','REALM Real Estate Professional','','','29.664581','-95.624819','25','77498','6','279900.00','Active','Overview','10423','Drive','Sugar Land','2','0','4','1604','Single-Family','Come home to this Meticulously Upgraded Single Family Home located at a fanatastic location only a few minutes away from Shopping, Restaurants and Schools. This Lovely One Story Home offer 4 Bedrooms and 2 Baths along with a Garage that is converted into 5th. Bedroom with its own private access. Beautifully remodeled Kitchen features a breakfast bar, Brand New Cabinets, Quartz Countertops & Stainless Steel Appliances. This house also features Brand New 30 year Roof, New Flooring, New recessed LED lights all over the house, New Fans in Every Room, New Double Pane Windows, Brand New Water Heater & Completely Remodeled Bathrooms with New Vanities, Quartz Countertops and New Plumbing fixtures. Complete Fresh Interior & Exterior Paint with new baseboards. Easy access to Hwy6, Hwy59 and Hwy90. (Garage can easily converted back.)\r\nWe promise that you\'ll fall in Love with this house the minute you walk in. Come see for yourself or Call Us to schedule a Private Showing.','0.1433','29','','','','','Sellers Disclosure','','','1','Sugar Land North','Central Electric','1','TOWNEWEST SEC 1, BLOCK 2, LOT 6, R/P','Subdivision Lot','6240','Appraisal District','','356','0','','2','','0','','','','','Composition','19 - Fort Bend','TOWNEWEST ELEMENTARY SCHOOL','KEMPNER HIGH SCHOOL','SUGAR LAND MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Townewest','4308','2.3329','Public Sewer,Public Water','1974','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','215821611','1675151873','215821611','2023-01-15T13:25:30.370','73789043','Jerilyn Schultz','eXp Realty, LLC','','','27.687713','-97.419230','17','78413','7','221000.00','Active','Snowmass','4202','Street','Corpus Christi','2','0','3','1393','Single-Family','Room Sizes are Approximate, corner lot! Beautiful home at an affordable price located in a well-established neighborhood. The 3 spacious bedrooms, 2 baths and large front yard makes this a great home for ANYONE! Featuring tons of built ins, remodeled Master Bathroom, extra cabinet space in kitchen/dining, Fireplace, covered patio, very convenient floor plan with split bedrooms, kitchen with lots of cabinet and counter space, outside hot tub, roof is less than 5 yrs old, near Grant Middle School! Ready for a new owner!','0.1473','85','','','Electric Dryer Connections,Washer Connections','','Real Estate Owned,Sellers Disclosure','1','','1','','Central Electric','0','WEBERS GLEN BLK 5 LOT 25','Corner','6416','Appraisal District','','','0','','2','Electric Oven','0','','','','','Composition','440 - Corpus Christi','DAWSON ELEMENTARY SCHOOL (CORPUS CHRISTI)','CARROLL HIGH SCHOOL (CORPUS CHRISTI)','GRANT MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Ranch','Webers Glen','4883','2.592','Public Sewer,Public Water','1984','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','216206385','1675151873','216206385','2023-01-15T14:33:00.047','46594015','Hope Swanner','Coldwell Banker Ultimate','','','29.018310','-95.634216','7','77422','3','475000.00','Active','County Road 652','4860','','Brazoria','2','0','3','2268','Single-Family','DIAMOND IN THE ROUGH---This 3 bedroom 2 full bath country home sits on 20 acres. 3 car garage attached/detached, plenty of room for storage & tools. This home offers 2 living area, kitchen opens up to dining room, also has a enclosed patio, with a great view of the back yard.  Property offers multiple barns and storage buildings and still lots of room for livestock.  One acre is homestead & the rest of the property is Agricultural exempt!','20','5','','','Electric Dryer Connections,Washer Connections','','Estate,Sellers Disclosure','0','','','West of the Brazos','Central Electric','0','CARLTON WOODED ACRES (A0138 S M WILLIAMS) BLK 3 LOT 9 (PT) A','Cleared','871200','Appraisal District','','','0','','3','Freestanding Oven','0','','','Gas Cooktop','','Composition','51 - Sweeny','SWEENY ELEMENTARY SCHOOL','SWEENY HIGH SCHOOL','SWEENY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Left Side,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Traditional','Carlton Wooded Acres','3179','1.9264','Septic Tank','1964','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','216247280','1675151873','216247280','2023-01-15T13:20:36.973','74396239','Mayte Pena-Garcia','eXp Realty, LLC','','','30.157667','-96.024077','10','77445','6','310000.00','Active','Waterford','24781','Street','Hempstead','2','1','3','1600','Single-Family','Beautiful  House on a hill and its a Newly built home!!!! 3bed, 2 bath, 1 half bath, home nestled on almost half an acres! Open Floor Plan, modern fixtures, Spacious Living area w/ tiled floors, high vaulted ceilings, Kitchen modern  hardware and island sits off dining area! Not to mention the beautiful tray  ceilings and the new 30 year roof!  If you are looking for a new home with a amazing space for family gathering look no further!','0.33','26','Marksmen developmen','','','','No Disclosures','','','','Waller','Central Electric','1','S755600 ROLLING HILLS 6 BLK 8 LOT N 90\' LOT 2 ACRES .33','Cleared','14375','Appraisal District','','75','1','To Be Built/Under Construction','2','','0','','','','','Composition','55 - Waller','H T JONES ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','SCHULTZ JUNIOR HIGH SCHOOL','Lockbox Back,Lockbox Front','Builder','1','Contemporary/Modern,Craftsman,Ranch,Traditional','Rolling Hills 6','544','1.9405','Septic Tank','2023','Builder');  --> 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','216413072','1675151873','216413072','2023-01-15T13:47:42.980','47847512','John Lee','WestwoodCPM Real Estate','','','29.901358','-95.706602','16','77433','9','385000.00','Active','Dunlay Springs','19514','Drive','Cypress','2','1','4','2542','Single-Family','Immaculate 4 bedroom, 2-1/2 bath traditional home, featuring kitchen open to living area, high ceiling, game room, double vanity in primary and much more, plenty of space for everything you ever wanted in your dream home.','0.1377','25','','','','','Mud','','','','Cypress South','Central Gas','1','LT 12 BLK 7 GATES AT CANYON LAKES WEST SEC 1','Subdivision Lot','6000','Appraisal District','','1140','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','ANDRE ELEMENTARY SCHOOL','CYPRESS SPRINGS HIGH SCHOOL','ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,Controlled Access,Lockbox Front,No Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Gates/Canyon Lakes West Sec 1','9045','3.041','Water District','2007','Appraisal District');  --> New record created successfully<br />