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-12-29T14:57:41.887' ,`MLSNumber` = '26869389' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.229125' ,`Longitude` = '-95.449601' ,`PhotoCount` = '36' ,`PostalCode` = '77302' ,`RoomCount` = '7' ,`ListPrice` = '319990.00' ,`Status` = 'Active' ,`StreetName` = 'Wedge Hill' ,`StreetNumber` = '16830' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2417' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Estimated Completion April 2023.  The Kisko’s open first floor allows for flowing spaces between the kitchen, dining area, and the great room, perfect for entertaining and family interaction. Unwind in one of the five bedrooms available with options or the upstairs game room.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Centex Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '28/02/07' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mavera' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097054' WHERE `Matrix_Unique_ID` = '209443955'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T14:10:15.873' ,`MLSNumber` = '10601607' ,`ListAgentFullName` = 'Polly Guillory' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804269' ,`Longitude` = '-94.926756' ,`PhotoCount` = '25' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Hunters Trace' ,`StreetNumber` = '6407' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1879' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house has it all!  One story home on a CORNER LOT with a CAR GARAGE that has an 8\' rear door and a back yard of fun!  This 3 bedroom with study that can easily be a 4th bedroom has an open floor plan with a large open kitchen with granite countertops, stainless steel appliances and an island.  A separate formal dining place and a large den with a fireplace.  The home has brick on all 4 sides.  This you don\'t want to miss.  Washer, dryer and refrigerator are available for purchase as well.' ,`Acres` = '0.161' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 3 HUNTERS CREEK SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '7014' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Crk Sec 3' ,`TaxAmount` = '8611' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097054' WHERE `Matrix_Unique_ID` = '211203476'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T14:48:07.387' ,`MLSNumber` = '53914321' ,`ListAgentFullName` = 'Robert Gresham' ,`ListOfficeName` = 'RE/MAX Eastside' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.854870' ,`Longitude` = '-95.005293' ,`PhotoCount` = '16' ,`PostalCode` = '77532' ,`RoomCount` = '3' ,`ListPrice` = '139000.00' ,`Status` = 'Active' ,`StreetName` = 'Stables Ln' ,`StreetNumber` = '3919' ,`StreetSuffix` = '' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'County living with no restrictions!  Great location between Crosby and Baytown!  This three bedroom home is move-in ready and sits on a quiet lot in Crosby. Nice size primary bedroom. Primary Bathroom has jacuzzi style bathtub, double sinks, and a separate shower. Bedroom two and three share a full bathroom with a shower/tub combo. Washer and dryer are staying with the home!  Front porch is covered and is wheelchair accessible.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 3F-7 BLK 3 (LT 46B)' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6970' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'DREW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Elena Fruit & Cotton Farms' ,`TaxAmount` = '' ,`TaxRate` = '2.0766' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097054' WHERE `Matrix_Unique_ID` = '211527842'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T14:44:11.740' ,`MLSNumber` = '86798609' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Ravenna Homes' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS                       ' ,`Latitude` = '29.947741' ,`Longitude` = '-95.779001' ,`PhotoCount` = '28' ,`PostalCode` = '77433' ,`RoomCount` = '17' ,`ListPrice` = '759900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Zinnias' ,`StreetNumber` = '11123' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3799' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This move-in ready 2-story floor plan features an entry with 21\' ceilings that extend past study. Oversized 17\'x23\' family room with 21\' ceilings, corner fireplace, and full wall of windows. Open kitchen features 42\" cabinets and high-bar seating. Master bath includes a freestanding tub, separate shower, His & Hers vanities, and dual walk-in closets. Located upstairs are 3 bedrooms, 2 baths, theater room, and a game room. Please contact us for more information.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Ravenna Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 43 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1237' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.6543' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097055' WHERE `Matrix_Unique_ID` = '213065804'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T14:51:28.993' ,`MLSNumber` = '4815805' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = 'Sara Vradenburg' ,`SellingOfficeName` = 'Realty ONE Group, Experience' ,`Latitude` = '29.944408' ,`Longitude` = '-95.197950' ,`PhotoCount` = '23' ,`PostalCode` = '77346' ,`RoomCount` = '14' ,`ListPrice` = '441660.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Mid Stocket' ,`StreetNumber` = '13131' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. This beautiful Lake Ridge Builders home nestled by the lake in Balmoral has everything you’re looking for! This 4-sided brick home boasts a premium elevation, tile flooring, full gutters, sprinkler system, wrought iron spindles, a cast stone fireplace, study with French doors, and covered patio. Create new recipes in the kitchen, complete with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. The relaxing primary suite features dual vanities, a 42” tub, and a separate shower. The tranquil Balmoral community includes white sand beaches, lakes, parks, an infinity pool, recreation center, and walking trails. Located off Beltway 8 and Highway 59, commuters enjoy easy access to George Bush Intercontinental Airport and Downtown Houston. Zoned to Humble ISD.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 55 Block 2' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '3.5534' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097055' WHERE `Matrix_Unique_ID` = '213278771'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T13:08:16.190' ,`MLSNumber` = '81556878' ,`ListAgentFullName` = 'Ozzie Ramirez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.506307' ,`Longitude` = '-95.163657' ,`PhotoCount` = '28' ,`PostalCode` = '77546' ,`RoomCount` = '10' ,`ListPrice` = '439900.00' ,`Status` = 'Active' ,`StreetName` = 'Cortona' ,`StreetNumber` = '3416' ,`StreetSuffix` = 'Lane' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3044' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous custom built two story home in gated community with nice and spacious covered back patio. This home features 20 ft high ceilings in entry way, and living room. Large kitchen has beautiful granite countertops and upgraded stainless steel appliances. Come relax in the large primary suite and enjoy a long hot bath in this large, breathtaking, brand new, soaking tub. Private study could be used as a fourth bedroom, but does not have a closet. Additional upgrades include new roof April 27, 2022, new A/C units with ducts in 2017 and 2021, new upstairs carpet in 2021. Home has never flooded. Call us today to view this exquisite home! Owner/Agent' ,`Acres` = '0.1148' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 5 TERRA BELLA SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'LANDOLT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Terra Bella Sec 01 Final' ,`TaxAmount` = '7244' ,`TaxRate` = '2.2534' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097055' WHERE `Matrix_Unique_ID` = '213381812'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T13:08:09.123' ,`MLSNumber` = '30948076' ,`ListAgentFullName` = 'Stacey Adkins' ,`ListOfficeName` = 'One Solution Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.690618' ,`Longitude` = '-95.915114' ,`PhotoCount` = '27' ,`PostalCode` = '77441' ,`RoomCount` = '6' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Divot' ,`StreetNumber` = '8411' ,`StreetSuffix` = 'Trace' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1653' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming one-story house has an attractive three-sided brick façade, an open floor plan, 9\' ceilings, an extended covered patio, 3 bedrooms, and 2 full bathrooms! Numerous additional features and finishes are available to you as well, such as tile flooring throughout the main living areas, granite countertops in the kitchen and bathrooms, stainless steel appliances, a neutral color scheme, a garden tub, and a separate shower with dual vanities in the primary bathroom, ceiling fans, Rinnai tankless water heaters, LED lighting, front and back gutters, a complete sprinkler system, 16 SEER HVAC, and a whole house water softener. The washer/Dryer and Refrigerator will stay with the home. Call today for your private tour.' ,`Acres` = '0.144' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'POLO RANCH SEC 2, BLOCK 1, LOT 34' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6273' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MORGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Polo Ranch Sec 2' ,`TaxAmount` = '7100' ,`TaxRate` = '3.2779' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097055' WHERE `Matrix_Unique_ID` = '214409125'  --> 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','215285220','1675097056','215285220','2022-12-29T14:53:17.397','42781749','Micah Tillotson','HOUSTON HOUSE OF REALTY, LLC','','','29.674097','-95.374366','27','77051','12','359900.00','Active','Grandview','8123','Street','Houston','3','1','3','2021','Single-Family','Location. Location. Location. You\'ll never have to worry between convenience and comfort with this beautiful brand new 2- story townhome located within minutes from Downtown Houston, Medical Center South, NRG, the university area, Houston Zoo, and Hermann Park. This is an open concept home with 3 - bedrooms, 3.5- bathrooms, and a two-car garage. This home features high ceiling walls and a stunning island kitchen. Huge master bedroom with a big bathroom and closet. Great price for this amazing home.','','3','Builder','','Gas Dryer Connections','','No Disclosures','1','','0','Medical Center South','Central Gas','0','LT 2 BLK 1 NORTHEAST GUIDED AT SUNNYSIDE','Cleared','2500','Survey','','','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop','','Composition','27 - Houston','YOUNG ELEMENTARY SCHOOL (HOUSTON)','WORTHING HIGH SCHOOL','ATTUCKS MIDDLE SCHOOL','Vacant/Unoccupied','Builder','2','Contemporary/Modern','SUNNYSIDE PLACE','','','Public Sewer,Public Water,Water District','2022','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','215683027','1675097056','215683027','2022-12-29T13:35:41.227','17567310','Macarena Briseno-Barboza','RE/MAX ONE - Premier','','','29.982262','-94.950114','30','77535','6','350000.00','Active','County Rd 4894','99','','Dayton','1','1','4','1800','Single-Family','Want to have it all? City access along with quiet country feel and Lots of room to roam with this 2.39 Acre home. Plenty of room and accomodations for large gatherings or your favorite farm pets. The 4 bedrooms, large kitchen, living, dining combo will be spacious and comfortable for your indoor get togethers. No carpet throughout. Call for an appointment today.','2.3989','52','','','','','Sellers Disclosure','','','','Dayton','Central Electric','0','CEDAR FARMS, BLOCK 4, LOT 8, ACRES 2.3989','Cleared','104496','Appraisal District','','','0','','0','','0','','','','','Composition','74 - Dayton','KIMMIE M. BROWN ELEMENTARY SCHOOL','DAYTON HIGH SCHOOL','WOODROW WILSON JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Ranch','Cedar Farms','3464','1.693','Septic Tank','2007','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','215901637','1675097056','215901637','2022-12-29T13:06:02.813','76123076','Rosalva Cardenas','HOUSTON TOP REALTY','','','30.140217','-95.281107','18','77365','4','200000.00','Active','Ferne Leaf Drive','21240','','Porter','2','0','2','952','Single-Family','This is a must see! To live in or Investment property.   Plenty of room to build on. Septic. . Half an acre! Clean and Clear with a Manufactured home on it, Move in Ready! Very well maintained. Also has a storage and a structure with roof ready to be enclosed for a storage unit in the back.','','40','','','','','Sellers Disclosure','','','','Porter/New Caney West','Central Electric,Central Gas','0','Lot 31,Serial #PHO7149,TITLE#00459293,Label #TEXO251649','Subdivision Lot','','','','','0','','0','','0','','','','','Composition','39 - New Caney','ROBERT CRIPPEN ELEMENTARY SCHOOL','PORTER HIGH SCHOOL (NEW CANEY)','WHITE OAK MIDDLE SCHOOL (NEW CANEY)','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Winchester Place','','','Other Water/Sewer,Septic Tank','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','215916741','1675097056','215916741','2022-12-29T14:40:39.867','76102472','Ann Tran','Compass RE Texas, LLC','','','29.928863','-95.556898','30','77064','3','262000.00','Active','Autumnsong Dr','9019','','Houston','2','0','3','1831','Single-Family','A warm tone cozy property featuring open kitchen with a long designed granite counter, plenty of light. The big backyard also has roof cover for your BBQ weekend get together. Wooden cabinets warm tone is a nice tough to the home. Close by facilities: Harvest Bend Pool and Community Center which has tennis court and green park for all nature lovers. Great School, and located close to Beltway 8, freeway 249, and highway 290.','0.181','10','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Willowbrook South','Central Electric,Central Gas','1','LT 30 BLK 6 HARVEST BEND THE VILLAGE 3 R/P','Subdivision Lot','7885','Appraisal District','','368','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','WILLBERN ELEMENTARY SCHOOL','CYPRESS RIDGE HIGH SCHOOL','CAMPBELL MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Ranch','HARVEST BND VILLAGE PT','5429','2.4','Public Sewer,Water District','1991','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','215919133','1675097056','215919133','2022-12-29T13:02:07.713','65223168','Scott Miller','RE/MAX Signature Galleria','','','30.350087','-95.603098','8','77316','2','219900.00','Active','Crystal River','909','','Montgomery','2','0','2','1409','Single-Family','10\' ceilings in kitchen/Living, open concept. Spacious kitchen with 42\" upper cabinets with large island, granite tops. Bedrooms with huge walk-in closet. Samsung Stainless Steel appliance package including easy clean top range with electric oven, 3 rack dishwasher, and microwave. 1 year warranty on appliances from Samsung. Ask agent about preferred lender benefits.','0.1739','39','Starter Homes of TX','','Electric Dryer Connections','','No Disclosures','1','','','Lake Conroe Area','Central Electric','1','LAKE CONROE FOREST 03, BLOCK 53, LOT 10','Subdivision Lot','7573','Appraisal District','','125','1','To Be Built/Under Construction','0','Electric Oven','0','','','Freestanding Range','','Composition','37 - Montgomery','KEENAN ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card','Builder','1','Traditional','Lake Conroe Forest 03','473','2.1625','Public Water,Septic Tank','2022','Builder');  --> New record created successfully<br />