Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T21:14:55.310' ,`MLSNumber` = '70859154' ,`ListAgentFullName` = 'Lizabeth Comiskey' ,`ListOfficeName` = 'Comiskey Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.295228' ,`Longitude` = '-94.922485' ,`PhotoCount` = '34' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '895598.00' ,`Status` = 'Active' ,`StreetName` = 'Copra' ,`StreetNumber` = '1627' ,`StreetSuffix` = 'Street' ,`City` = 'Tiki Island' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1844' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A RARE FIND!\r\nEVERY DAY IS A SUNSET!\r\nBeautiful bay front home illustrates a Great location for Living the life on Tiki~ \r\nHome excels with Walls of windows displaying the wonderful sparkling Bay.\r\nHigh ceilings bringing in the natural light. Open floor plan including the family room, breakfast room, dining room and kitchen all as one.\r\nFront driveway can easily park 10-15 cars along with the two private garages.\r\nThe porch offers limitless sunset views! \r\nThe boat dock is oversized and extra wide for the much larger boats. Keep it oversized or construct to the two slips to include a jet ski lift. \r\nOwners use to have a 56foot boat parked on outer side of slip as well, \r\nAlready has plugs for the larger boats!\r\nYou will be amazed of all the fish you can catch off your dock.\r\nPlease look for the airconditioned bonus room with walk in closet and full bath! \r\nMust Come see this wonderful home!' ,`Acres` = '0.15' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S C BUNDICK SUR LOT 56 TIKI ISLAND SEC 7' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '6534' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Tiki Island' ,`TaxAmount` = '13375' ,`TaxRate` = '2.2119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709477' WHERE `Matrix_Unique_ID` = '207011703' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T21:57:23.933' ,`MLSNumber` = '92730980' ,`ListAgentFullName` = 'Yolanda Graham' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.447886' ,`Longitude` = '-95.070007' ,`PhotoCount` = '50' ,`PostalCode` = '77539' ,`RoomCount` = '4' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Old Bayou' ,`StreetNumber` = '406' ,`StreetSuffix` = 'Drive' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2236' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautifully renovated home located on an oversized corner lot in Bayou Chantilly. This spacious home has an amazing flow and a modern design style that includes 4 bedrooms with carpet and 2 bathrooms, tile floors, a fireplace, quartz countertops, stainless steel appliances, and a primary bath walk-in shower. The electrical and plumbing were updated as well as the roof, HVAC system, fence and so much more! You will also love the spacious backyard and back patio for entertaining family and guests. The front of the home has a side drive that enters into the backyard where you can park your boat or RV. The RV hookup is located on the side of the home. You get the value of peaceful living while being conveniently located close to I-45, shopping, dining, schools, and minutes from Galveston.' ,`Acres` = '0.2819' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 11 A FARMER SUR LOT 22 BLK 6 BAYOU CHANTILLY SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '12278' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,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,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bayou Chantilly' ,`TaxAmount` = '6481' ,`TaxRate` = '2.5984' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709478' WHERE `Matrix_Unique_ID` = '209165109' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T20:54:47.103' ,`MLSNumber` = '23775621' ,`ListAgentFullName` = 'Pamela Pena' ,`ListOfficeName` = 'RE/MAX GO' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.728155' ,`Longitude` = '-95.052692' ,`PhotoCount` = '45' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '138000.00' ,`Status` = 'Active' ,`StreetName` = 'Willowbend' ,`StreetNumber` = '336' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1536' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2015 mobile home on 2 lots. Clean and ready-to-move-in manufactured home located close to Lake Livingston in the wonderful community of Lake Livingston Village. You will have access to the community pools, pavilion, and a beautiful Lake Livingston boat ramp.' ,`Acres` = '0.1678' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE LIVINGSTON VILLAGE SECTION 3 LOT 146 and 147' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '24' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Livingston Village Section 3' ,`TaxAmount` = '71' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709478' WHERE `Matrix_Unique_ID` = '209234689' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T20:34:45.543' ,`MLSNumber` = '33917199' ,`ListAgentFullName` = 'Jing He' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.689115' ,`Longitude` = '-95.489008' ,`PhotoCount` = '24' ,`PostalCode` = '77096' ,`RoomCount` = '8' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Beechnut' ,`StreetNumber` = '5610' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'It\'s a fantastic 4 bedrooms/2 baths new remodeled home on a huge 10,891 SF lot. An open floor plan filled with tons of natural lighting. Every room has a fancy new ceiling with new luxury modern lights. Almost everything is new: new drywall and insulation, new kitchen granite counter top cabinets, new kitchen island, new wood/tiles, new bathrooms , new windows, new A/C,furnace and air ducts, new roof. From the living room you\'ll have views of the covered patio that\'s perfect for enjoying with your family and friends. The large back yard is perfect for entertainment. Walking distance to Herod Elem, and zoned to Bellaire High! Must come to see!' ,`Acres` = '0.25' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 41 BLK 9 MAPLEWOOD SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10891' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRAEBURN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'LONG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Maplewood' ,`TaxAmount` = '6687' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663709478' WHERE `Matrix_Unique_ID` = '209485568' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T21:42:32.467' ,`MLSNumber` = '35330505' ,`ListAgentFullName` = 'Hana Shaath' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.820567' ,`Longitude` = '-95.456850' ,`PhotoCount` = '24' ,`PostalCode` = '77320' ,`RoomCount` = '3' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Wood Farm Estates' ,`StreetNumber` = '133' ,`StreetSuffix` = 'Road' ,`City` = 'Huntsville' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this charming house sitting on 1 acre of cleared fenced in land. This property has 2 sheds on it, a large 25 x 25 carport, an outdoor grilling area, and the fencing in the backyard is brand new. This is the perfect quiet neighborhood with NO RESTRICTIONS. This 3 bedroom 1 full bath and 1 half bath house is spacious and ready to be lived in. Laminate floors running through out the house and granite countertops in the kitchen. Only 20 minuets from Downtown Huntsville. The spacious backyard is perfect for kids, animals, and family events.' ,`Acres` = '1' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WOOD FARM ROAD ESTATES, LOT 18, ACRES 1.0, #8263472' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'HUNTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Wood Farm Road Estates' ,`TaxAmount` = '2022' ,`TaxRate` = '1.7134' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709478' WHERE `Matrix_Unique_ID` = '209511922' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T21:16:50.047' ,`MLSNumber` = '41782604' ,`ListAgentFullName` = 'Shannon Binder' ,`ListOfficeName` = 'Binder Real Estate, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.657780' ,`Longitude` = '-96.528776' ,`PhotoCount` = '13' ,`PostalCode` = '78934' ,`RoomCount` = '3' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Hwy 71' ,`StreetNumber` = '4501' ,`StreetSuffix` = '' ,`City` = 'Columbus' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.519' ,`Area` = '56' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A-5B Braden .0519 acres House & buildings' ,`LotDesciption` = 'Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '188 - Columbus' ,`SchoolElementary` = 'COLUMBUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLUMBUS HIGH SCHOOL' ,`SchoolMiddle` = 'COLUMBUS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'None' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'No Sewer,Septic Tank' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709478' WHERE `Matrix_Unique_ID` = '209847294' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T20:04:11.143' ,`MLSNumber` = '10298949' ,`ListAgentFullName` = 'Kimberly Weddel' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.154044' ,`Longitude` = '-95.380316' ,`PhotoCount` = '40' ,`PostalCode` = '77386' ,`RoomCount` = '10' ,`ListPrice` = '419900.00' ,`Status` = 'Active' ,`StreetName` = 'Chapel Rock' ,`StreetNumber` = '31866' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2420' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You don\'t want to miss this gorgeous home located in the highly sought after Falls at Imperial Oaks. This 2 story home has a great open floor plan. You will enter through a spacious entry hall, the first room on the left is being used as an office but can be a formal dining. The open kitchen has beautiful granite countertops, breakfast bar, stainless appliances, cabinet space galore and a walk in pantry. The breakfast/dining opens to a large living area. You will love the primary suite and bath located on 1st floor. Primary bath has granite with double sinks, separate tub and shower with a really nice walk in closet. There are absolutely gorgeous wood floors throughout the home. Upstairs you will find a gameroom that\'s being used as a media room, 3 additional bedrooms and a full bath.The huge backyard is fully fenced with a covered patio. You will have no neighbors behind or on one side of the home; all located in a gorgeous neighborhood. You will love calling this your new home.' ,`Acres` = '0.251' ,`Area` = '15' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S504210 - FALLS AT IMPERIAL OAKS 10, BLOCK 1, LOT 28' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '10932' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BIRNHAM WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falls At Imperial Oaks 10' ,`TaxAmount` = '8439' ,`TaxRate` = '3.0687' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709478' WHERE `Matrix_Unique_ID` = '209962807' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T21:52:33.603' ,`MLSNumber` = '66447322' ,`ListAgentFullName` = 'Casey Tong' ,`ListOfficeName` = 'ABSOLUTE Realty Group Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.643970' ,`Longitude` = '-95.509797' ,`PhotoCount` = '35' ,`PostalCode` = '77071' ,`RoomCount` = '10' ,`ListPrice` = '318000.00' ,`Status` = 'Active' ,`StreetName` = 'Braesridge' ,`StreetNumber` = '12303' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3025' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HUGE REDUCTION, motivated seller, Introducing 12303 Braesridge Dr. A beautiful 4 bedroom/3 bath/2 car garage sitting on a corner lot in FONDREN SW SOUTHMEADOW. This home features not one but TWO Primary bedrooms, a large kitchen/dining combo with, GRANITE kitchen counters, STAINLESS STEEL appliances, new soft closing cabinets, and drawers. Stay cozy with the wood-burning fireplace in the living room and gorgeous backyard and trees. Located within the outer loop and ALT 90, the home sits between Glenshire Park and Willow Waterhole. It\'s a short drive to both Houston and Missouri city rec areas, Bellaire, local pharmacies, and stores. All the kitchen appliances, AC are new, and the home is freshly cleaned and painted. Ready for you and your family. CONSIDER all offers.' ,`Acres` = '0.1856' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 & N 10 FT OF LT 2 BLK 3 FONDREN SW SOUTHMEADOW SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8085' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GROSS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Split Level' ,`Subdivision` = 'Fondren Sw Southmeadow' ,`TaxAmount` = '2546' ,`TaxRate` = '2.5216' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709478' WHERE `Matrix_Unique_ID` = '210031830' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T21:07:11.637' ,`MLSNumber` = '5429421' ,`ListAgentFullName` = 'Rashad Garrett' ,`ListOfficeName` = 'Brooks & Davis Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.444847' ,`Longitude` = '-95.440475' ,`PhotoCount` = '6' ,`PostalCode` = '77583' ,`RoomCount` = '2' ,`ListPrice` = '259999.00' ,`Status` = 'Active' ,`StreetName` = 'Peridot Green' ,`StreetNumber` = '9419' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1659' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1401' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'STERLING LAKES AT IOWA COLONY SEC 9 (A0289 HT&B) BLK 1 LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6103' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Lakes At Iowa Colony' ,`TaxAmount` = '5989' ,`TaxRate` = '3.4099' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709479' WHERE `Matrix_Unique_ID` = '210131416' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T20:47:57.390' ,`MLSNumber` = '80396860' ,`ListAgentFullName` = 'Georgia Strong' ,`ListOfficeName` = 'Georgia Strong Realty Group' ,`SellingAgentFullName` = 'Leann Schmidt' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.866746' ,`Longitude` = '-95.633990' ,`PhotoCount` = '23' ,`PostalCode` = '77084' ,`RoomCount` = '7' ,`ListPrice` = '265000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Rigdale' ,`StreetNumber` = '15019' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1744' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A beautiful well-maintained home in this price point is hard to find. Don\'t miss the opportunity to own this gem. The roof was replaced in 2020 and HVAC has been replaced. There is a new fence surrounding the serene backyard space. This 3 bedroom 2 bath home is a very livable layout and is move-in ready.' ,`Acres` = '0.1716' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 6 CONCORD COLONY SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Concord Colony' ,`TaxAmount` = '3782' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709479' WHERE `Matrix_Unique_ID` = '211023095' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','211731216','1663709479','211731216','2022-09-11T20:46:38.970','5899976','Melanie Hunt','Doug Erdy Group','John Altic','JLA Realty','30.674742','-94.410039','20','75979','3','295000.00','Option Pending','Sherwood Forest','521','Drive','Woodville','2','0','3','2010','Single-Family','Waterfront property in Ivanhoe, a private subdivision neighborhood six miles from Woodville. Drive down the path to your furnished home that sits on a beautiful lawn with the water steps away. The boat house is ready for your boat, with a dock waiting for you to enjoy a nice evening with stunning view of the lake. Bonus: a view of the lake from the living area, sunroom, kitchen and even the laundry room! You may never want to leave. There is plenty of room to invite company and spend time on the water or enjoying the outdoors on the spacious lawn. ALL room sizes are estimates and should be verified. Hurry this property won\'t last long!','0.4708','48','','','','','Exclusions,Mud,Sellers Disclosure','','','','Tyler County','Central Electric','1','S3755 LAKE CHARMAINE SEC 5 (A568) BLOCK 60 LOT 45 ACRES 0.47','Subdivision Lot,Waterfront','20508','Appraisal District','','0','0','','2','','0','','','','','Composition','253 - Woodville','WHEAT ELEMENTARY SCHOOL','WOODVILLE HIGH SCHOOL','WOODVILLE MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Ranch','Lake Charmaine','4405','2.8994','Septic Tank,Water District','1971','Appraisal District'); --> New record created successfully
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','212015400','1663709479','212015400','2022-09-11T21:47:28.190','94199646','Frank Olivares','Pinnacle Realty Advisors','','','30.720816','-95.541826','7','77340','5','90000.00','Active','Avenue C','1311E','','Huntsville','2','0','3','1120','Single-Family','Great first time buyer opportunity and investors opportunity. Please call us to set up a showing TODAY!!!','0.191','43','','','','','Sellers Disclosure','','','','Huntsville Area','Central Electric','0','BOETTCHER MILL, BLOCK 2, LOT 30.4, (CALLED LOT 4) CALIXTO CA','Cleared','8320','Appraisal District','','','0','','0','','0','','','','','Aluminum','64 - Huntsville','SCOTT JOHNSON ELEMENTARY SCHOOL','HUNTSVILLE HIGH SCHOOL','MANCE PARK MIDDLE SCHOOL','Leave Business Card,Lockbox Front','Appraisal District','1','Other Style','Boettcher Mill','548','1.9609','Public Sewer,Public Water','2004','Appraisal District'); --> New record created successfully
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','212325085','1663709479','212325085','2022-09-11T20:45:57.630','92102528','Wendee Newman','Results Real Estate','','','29.361094','-94.980897','7','77568','5','315000.00','Active','Meadow Lane','2516','','La Marque','2','1','5','2858','Single-Family','Beautiful, completely renovated 5 Bedroom 2.5 bath in a small, quiet neighborhood-no HOA! Completion date is 9/26/22. Spend easy evenings in this very open kitchen and living area. Kitchen features new white cabinets with beautiful Quartz countertops. First floor also features formal living area with newly adorned fireplace perfect for cozy winter evenings. Open to the formal living, is a large brightly lit den/office/childrens play area. Second floor features 5 newly remodelled spacious bedrooms. Primary bedroom with new ensuite bathroom and walk in closet. Second upstairs bath also features new cabinets and shower. So many updates...New Sheetrock, New tile, New carpet, New LVP flooring, New water heater, NEW PEX water pipes! Bring the children, and don\'t forget the fur babies as this home boasts a large fenced backyard for everyone to enjoy. Keep watching this one for completion photos.','0.29','33','','','Electric Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','1','Gas Connections','1','La Marque','Central Gas','0','ABST 150 J D MOORE SUR W 50 FT OF LOT 5 & E 56 FT OF LOT 6','Subdivision Lot','12720','Other','','','0','','2','','0','','','','','Composition','52 - Texas City','HAYLEY ELEMENTARY SCHOOL','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL (TEXAS CITY)','Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Seller','1.5','Ranch','Briar Meadow','','2.6428','Public Sewer,Public Water','1964','Seller'); --> New record created successfully
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','212410322','1663709479','212410322','2022-09-11T21:29:31.850','4340087','Clarissa Michaels','C & S Premier Realty','','','30.336776','-94.978221','27','77327','6','360000.00','Active','County Road 2237','291','','Cleveland','2','0','3','2103','Single-Family','Gorgeous farmhouse situated on two acres of unrestricted property! This Tarkington ISD home comes fully fenced with beautiful mature trees throughout the property. The charm this home has to offer, you simply cannot find in newly built homes. The front porch is what dreams are made of! Plenty of room for an entire party just on the porch! Walking into the home you will be entered into a large flex space currently used for a formal dining room. Custom made dining table, chairs, bench & buffet to convey! Split floorplan offers the primary suite privacy, but still close enough for little ones. Bay windows throughout offer subtle charm. Home has been updated throughout with the bathrooms, kitchen, paint, & flooring all with recent upgrades! The exterior boasts a privacy fenced backyard, garage/shop with leanto\'s off the side & rear, citrus trees, & enough room for a horse or additional home! Come see all the possibilities this land has to offer!','2','52','','','Electric Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','','0','Cleveland Area','Central Electric','0','000025 M DONAHO, TRACT 228, ACRES 2.0','Cleared','87120','Appraisal District','','','0','','1','Electric Oven','0','','','Electric Range','','Composition','102 - Tarkington','TARKINGTON PRIMARY SCHOOL','TARKINGTON HIGH SCHOOL','TARKINGTON MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Back,Request Online Appointment,Supra Keybox','Appraisal','1','Ranch','M Donaho','3179','1.5226','Public Water,Septic Tank','1950','Appraisal District'); --> New record created successfully
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','212410712','1663709479','212410712','2022-09-11T21:38:37.627','7110958','Mark Bland','Realty Associates','','','29.919781','-95.066938','13','77532','11','299995.00','Active','Feverfew Trail','6306','','Crosby','2','1','3','1616','Single-Family','Welcome Home! Lovely Two Story Cul-de-sac home. 3brd, 2 1/2bth with all bedrooms up. Master bedroom has a stand up shower along with soaking garden tube for those long stressful days. The kitchen has maple cabinets with quartz countertops. Living room has a corner fireplace with a maple mantel that compliments the tile flooring. Located near Crosbys 46-acre Park. Contract your real estate agent and make your appointment now.','','1','K Hovnanian','','Electric Dryer Connections,Gas Dryer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Crosby Area','Central Gas','1','Block 22 Lot 1 Crosby Park Village','Subdivision Lot','3999','Survey','','500','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','12 - Crosby','CROSBY ELEMENTARY SCHOOL (CROSBY)','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Accompany,Appointment Required,Leave Business Card,Supra Keybox','Builder','1','Traditional','Crosby Park Village','','','Public Sewer,Public Water','2021','Builder'); --> New record created successfully