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-12-10T11:14:04.987' ,`MLSNumber` = '98210669' ,`ListAgentFullName` = 'Elias Guzman' ,`ListOfficeName` = 'Nexus One Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.141660' ,`Longitude` = '-95.262168' ,`PhotoCount` = '15' ,`PostalCode` = '77365' ,`RoomCount` = '3' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Larry Wayne' ,`StreetNumber` = '19290' ,`StreetSuffix` = 'Street' ,`City` = 'Porter' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ENJOY COUNTRY LIVING WHILE STILL CLOSE TO EVERYTHING!! Inviting mobile home! This home has two bedrooms and one full sized bathrooms. Split plan, tub. Nice Secondary Bedrooms, The kitchen has lots of cabinet space for all of your storage needs, nice Livingroom, Utility room This property sits on a little over Quarter of Acre.' ,`Acres` = '0.3585' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S925306 - TIMBERLAND NORTH 06, BLOCK 4, LOT 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15618' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'SORTERS MILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timberland North 06' ,`TaxAmount` = '326' ,`TaxRate` = '2.1739' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675089482' WHERE `Matrix_Unique_ID` = '203884622' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T11:12:51.310' ,`MLSNumber` = '67393182' ,`ListAgentFullName` = 'Elias Guzman' ,`ListOfficeName` = 'Nexus One Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.142518' ,`Longitude` = '-95.263689' ,`PhotoCount` = '20' ,`PostalCode` = '77365' ,`RoomCount` = '3' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Haven' ,`StreetNumber` = '19228' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ENJOY COUNTRY LIVING WHILE STILL CLOSE TO EVERYTHING!! Inviting mobile home! This home has two bedrooms and one full sized bathrooms. Split plan, tub. Nice Secondary Bedrooms, The kitchen has lots of cabinet space for all of your storage needs, nice Livingroom, Utility room This property sits on a little over Quarter of Acre.' ,`Acres` = '0.3444' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S925307 - TIMBERLAND NORTH 07, BLOCK 1, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15002' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'SORTERS MILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timberland North 07' ,`TaxAmount` = '1566' ,`TaxRate` = '2.1739' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675089483' WHERE `Matrix_Unique_ID` = '203885407' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T11:13:18.190' ,`MLSNumber` = '71371378' ,`ListAgentFullName` = 'Elias Guzman' ,`ListOfficeName` = 'Nexus One Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.135743' ,`Longitude` = '-95.262498' ,`PhotoCount` = '19' ,`PostalCode` = '77365' ,`RoomCount` = '4' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Amy' ,`StreetNumber` = '19278' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ENJOY COUNTRY LIVING WHILE STILL CLOSE TO EVERYTHING!! Inviting mobile home! This home has two bedrooms and one full sized bathrooms. Split plan, tub. Nice Secondary Bedrooms, The kitchen has lots of cabinet space for all of your storage needs, nice Livingroom, Utility room This property sits on a little over Quarter of Acre.' ,`Acres` = '0.3857' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S925302 - TIMBERLAND NORTH 02, BLOCK 1, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16801' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'SORTERS MILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timberland North 02' ,`TaxAmount` = '326' ,`TaxRate` = '2.1739' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675089483' WHERE `Matrix_Unique_ID` = '203886177' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T11:10:50.477' ,`MLSNumber` = '39505155' ,`ListAgentFullName` = 'Elias Guzman' ,`ListOfficeName` = 'Nexus One Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.135716' ,`Longitude` = '-95.262292' ,`PhotoCount` = '17' ,`PostalCode` = '77365' ,`RoomCount` = '5' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Amy' ,`StreetNumber` = '19282' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ENJOY COUNTRY LIVING WHILE STILL CLOSE TO EVERYTHING!! Inviting mobile home! This home has two bedrooms and one full sized bathrooms. Split plan, tub. Nice Secondary Bedrooms, The kitchen has lots of cabinet space for all of your storage needs, nice Livingroom, Utility room This property sits on a little over Quarter of Acre.' ,`Acres` = '0.3214' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TIMBERLAND NORTH 02, BLOCK 1, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'SORTERS MILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timberland North 02' ,`TaxAmount` = '326' ,`TaxRate` = '2.1739' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1198' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675089483' WHERE `Matrix_Unique_ID` = '203887856' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T11:11:21.987' ,`MLSNumber` = '45052839' ,`ListAgentFullName` = 'Elias Guzman' ,`ListOfficeName` = 'Nexus One Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.136869' ,`Longitude` = '-95.268570' ,`PhotoCount` = '17' ,`PostalCode` = '77365' ,`RoomCount` = '4' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Abigail Grace' ,`StreetNumber` = '21521' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '992' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ENJOY COUNTRY LIVING WHILE STILL CLOSE TO EVERYTHING!! Inviting mobile home! This home has two bedrooms and one full sized bathrooms. Split plan, tub. Nice Secondary Bedrooms, The kitchen has lots of cabinet space for all of your storage needs, nice Livingroom, Utility room This property sits on a little over Quarter of Acre.' ,`Acres` = '0.4357' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S926602 - TIMBERLAND CENTRAL 02, BLOCK 2, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18981' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'SORTERS MILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timberland Central 02' ,`TaxAmount` = '326' ,`TaxRate` = '2.1739' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675089483' WHERE `Matrix_Unique_ID` = '203893517' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T12:34:11.613' ,`MLSNumber` = '54215126' ,`ListAgentFullName` = 'Saira Alvarez' ,`ListOfficeName` = 'PRG, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.521048' ,`Longitude` = '-95.441594' ,`PhotoCount` = '9' ,`PostalCode` = '77545' ,`RoomCount` = '3' ,`ListPrice` = '129999.00' ,`Status` = 'Active' ,`StreetName` = 'Renfro Burford' ,`StreetNumber` = '706' ,`StreetSuffix` = 'Road' ,`City` = 'Fresno' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SOLD AS-IS:SELLER WILL NOT MAKE ANY REPAIRS* This property has 9000sqft lot, house is 900sqft 2-bed/1 bath currently not in livable condition. Great opportunity for a handyman or investors! Mobile homes accepted. No restrictions** All room measurements are approximate and need to be verified independently. Seller has no survey, buyer to purchase a new survey if necessary.\r\n\r\n**Seller is also selling LOT next to it **\r\nParcel ID 6400-00-028-0800-907 Lot Sq Ft 9,525. Legal Description RIDGEWOOD ESTATES, BLOCK 28, LOT 8**' ,`Acres` = '0.2066' ,`Area` = '38' ,`BuilderName` = 'Seller' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'RIDGEWOOD ESTATES, BLOCK 28, LOT 2/3 OF 9, PART IN FT BEND C' ,`LotDesciption` = 'Other' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ridgewood Estates' ,`TaxAmount` = '2397' ,`TaxRate` = '2.7629' ,`WaterSewer` = 'No Sewer,No Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675089484' WHERE `Matrix_Unique_ID` = '208197920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T12:52:48.893' ,`MLSNumber` = '95210313' ,`ListAgentFullName` = 'Christy Buck' ,`ListOfficeName` = 'Infinity Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.598797' ,`Longitude` = '-95.232060' ,`PhotoCount` = '26' ,`PostalCode` = '77089' ,`RoomCount` = '6' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'Kirkgreen' ,`StreetNumber` = '10534' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investment opportunity! Tenant occupied as of 9/12/2022 with a one year lease for $1800 per month. Check out this great home in a cul-de-sac with a large fenced yard. Open concept floor plan with wood burning fireplace and vaulted ceilings in the living area. Breakfast bar and eat-in kitchen with gas stove. Laminate flooring and tile throughout the home other than the bedrooms, double pane windows and updated bathrooms. Per seller, roof replaced @ 3 yrs ago, water heater replaced in 2017 and all air ducts replaced. A/C was existing when he purchased the home approximately 8 years ago but works great! Large covered patio and storage shed in the backyard. Convenient location to the beltway and I45. See attached previous foundation repair and proposed foundation repair quote in attachments.' ,`Acres` = '0.1791' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 81 BLK 2 KIRKWOOD SOUTH SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '190' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MOORE ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kirkwood South Sec 05' ,`TaxAmount` = '3994' ,`TaxRate` = '2.6355' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089484' WHERE `Matrix_Unique_ID` = '209537470' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T11:02:58.980' ,`MLSNumber` = '64860020' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Newmark Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.723208' ,`Longitude` = '-95.872605' ,`PhotoCount` = '28' ,`PostalCode` = '77441' ,`RoomCount` = '8' ,`ListPrice` = '506991.00' ,`Status` = 'Active' ,`StreetName` = 'SHERMAN OAK' ,`StreetNumber` = '4131' ,`StreetSuffix` = '' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2563' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEWTON PLAN - Fabulous Stucco and Brick Elevation. This popular 2 story home features 4 bedrooms, with 2 bedrooms down. Fantastic chef\'s kitchen, built-in stainless steel appliances, quartz counters, and Linen Cabinets. Hardwood Flooring in living area, 8 ft. front door, wrought iron staircase and 2 story foyer. Open and Bright with natural light coming in from the Pointed Vault ceiling and wall of windows. Upstairs Game room and Media room. Covered Patio with oversized back yard and 2 car garage with 5\' storage area.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17 Block 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '45' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675089484' WHERE `Matrix_Unique_ID` = '212788620' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T11:44:30.710' ,`MLSNumber` = '82954329' ,`ListAgentFullName` = 'Natacha Vera' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.145391' ,`Longitude` = '-95.491862' ,`PhotoCount` = '23' ,`PostalCode` = '77380' ,`RoomCount` = '7' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Kentwood' ,`StreetNumber` = '3322' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1326' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Modern completely remodeled single story home, sitting on a spacious corner lot in The woodlands. Beautiful kitchen with stainless steel appliances, all new plumbing, backsplash, countertops, lighting & blinds throughout! and great backyard space with covered porch. Updated baths with quartz look countertop, double sinks in primary bathroom, new shower heads & toilets. Family room includes a GORGEOUS fireplace for those cozy winter evenings. NO CARPET. GREAT LOCATION, close to all amenities, Shopping, dining, & entertainment venues min away.Not to mention, just minutes from The Woodlands Mall & the beautiful waterway. Home is zoned to Conroe ISD, with excellent schools nearby. Never Flooded.' ,`Acres` = '0.2135' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TIMBER RIDGE 03, LOT 50' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '70' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GLEN LOCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Lockbox Right Side,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Ridge 03' ,`TaxAmount` = '3568' ,`TaxRate` = '2.5954' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089484' WHERE `Matrix_Unique_ID` = '214152818' --> 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','214278760','1675089484','214278760','2022-12-10T12:10:15.580','71542113','Jeremy Casanova','Morel Realty LLC','','','29.805491','-95.366379','9','77009','11','435000.00','Active','Gale','406','Street','Houston','2','0','4','1511','Single-Family','Don\'t miss out on this rare income producing capable property surrounded by major freeways 45,59,610,and I10 yet quiet and off the beaten path only seven minutes from Downtown Market Square park and the Epicenter of the burgeoning 4th biggest city in the USA with 4 bedrooms which can be converted to 5. Its no wonder Air B and B\'s (Air DNA) states this property @ 4 bedrooms can command $79,000/ year as a short term rental @69% occupancy (see attachment) Boasting a double driveway capable of parking 8 cars yet comfortably nestled on an unheard of 35 foot wide street with legal street parking! A three minute stroll from Houstons Lite Rail capable of effortlessly reaching Houston\'s robust Downtown attractions (Discovery Green, White Oak Music Hall, 713 Music hall, UH Downtown, etc.) All possibilities are on the table whether family home, rental, or a combination of both as the detached garage can be made into separate living quarters. Please verify all information.','0.1722','9','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','0','','','Northside','Central Gas','0','LT 5 & TR 6A BLK 28 LINDALE PARK SEC 5','Subdivision Lot','7500','Appraisal District','','35','0','','1','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','JEFFERSON ELEMENTARY SCHOOL (HOUSTON)','NORTHSIDE HIGH SCHOOL','MARSHALL MIDDLE SCHOOL','Appointment Required,Lockbox Front,No Supra Keybox','Appraisal District','2','Traditional','Lindale Park Sec 05','7883','2.3307','Public Sewer,Public Water','1940','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T11:31:18.037' ,`MLSNumber` = '82714626' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.696911' ,`Longitude` = '-95.911940' ,`PhotoCount` = '10' ,`PostalCode` = '77441' ,`RoomCount` = '5' ,`ListPrice` = '302990.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Palm' ,`StreetNumber` = '7915' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CENTURY COMMUNITIES NEW CONSTRUCTION - Welcome home to 7915 Royal Palm Drive located in the community of Polo Ranch and zoned to Lamar Consolidated ISD. The 1698 floorplan features 3 bedrooms, 2 full baths and an attached 2 car garage. This home has great standard features including granite countertops in kitchen and all baths, 42 inch cabinets, Whirlpool band appliances, tankless water heater, full sod font and back with irrigation, home automation powered by google, large walk-in showers, coach lights and more! You don\'t want to miss all this gorgeous home has to offer! Estimated completion is November 2022. Call to schedule your showing today! Days on market reflect the number of days the home has been under construction.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21 Block 1 Section 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6760' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '675' ,`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,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Polo Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675089484' WHERE `Matrix_Unique_ID` = '214434914' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T11:22:09.807' ,`MLSNumber` = '58642172' ,`ListAgentFullName` = 'Amna Zia' ,`ListOfficeName` = 'Texas Signature Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.925304' ,`Longitude` = '-95.565053' ,`PhotoCount` = '47' ,`PostalCode` = '77064' ,`RoomCount` = '8' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Twilight Moon' ,`StreetNumber` = '9415' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely Gorgeous home with updates. New water heater 9/2022. New Roof 5/2021. All sliding of house changed in 7/2017. New french doors. Spacious kitchen open to supersize family room. Large master bedroom with sitting area, garden tub and walk in closet. Large backyard with sprinkler system. Refrigerator/washer and dryer included.' ,`Acres` = '0.1457' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 3 HARVEST BEND THE MEADOW 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6345' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILLBERN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harvest Bend Meadow 01 R/P' ,`TaxAmount` = '4771' ,`TaxRate` = '2.5587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089485' WHERE `Matrix_Unique_ID` = '214807781' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T11:36:32.460' ,`MLSNumber` = '87470967' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.696911' ,`Longitude` = '-95.911940' ,`PhotoCount` = '11' ,`PostalCode` = '77441' ,`RoomCount` = '8' ,`ListPrice` = '352990.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Palm' ,`StreetNumber` = '7903' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2466' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CENTURY COMMUNITIES NEW CONSTRUCTION - Welcome home to 7903 Royal Palm Drive located in the community of Polo Ranch and zoned to Lamar Consolidated ISD. The 2466 floorplan features 4 bedrooms, 2 full baths, 1 half baths and an attached 2 car garage. You don\'t want to miss all this gorgeous home has to offer! Call to schedule your showing today! Days on market reflect the number of days the home has been under construction.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Polo Ranch Section 8, Block 1, Lot 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7100' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '675' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`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,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Polo Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.309' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675089485' WHERE `Matrix_Unique_ID` = '214824560' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T11:30:50.660' ,`MLSNumber` = '32834590' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.695230' ,`Longitude` = '-95.911794' ,`PhotoCount` = '10' ,`PostalCode` = '77441' ,`RoomCount` = '5' ,`ListPrice` = '295990.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Palm' ,`StreetNumber` = '8022' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1602' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CENTURY COMMUNITIES NEW CONSTRUCTION - Welcome home to 8022 Royal Palm Drive located in the community of Polo Ranch and zoned to Lamar Consolidated ISD. The 1602 floorplan features 4 bedrooms, 2 full baths, and an attached 2 car garage. You don\'t want to miss all this gorgeous home has to offer! Call to schedule your showing today! Estimated completion is November 2022. Days on market reflect the number of days the home has been under construction.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Polo Ranch Section 8, Block 2, Lot 39' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '675' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`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,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Polo Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.3' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675089485' WHERE `Matrix_Unique_ID` = '214825410' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-10T11:33:37.107' ,`MLSNumber` = '4826998' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.695497' ,`Longitude` = '-95.911766' ,`PhotoCount` = '10' ,`PostalCode` = '77441' ,`RoomCount` = '5' ,`ListPrice` = '298990.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Palm' ,`StreetNumber` = '8002' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CENTURY COMMUNITIES NEW CONSTRUCTION - Welcome home to 8002 Royal Palm Drive located in the community of Polo Ranch and zoned to Lamar Consolidated ISD. The 1698 floorplan features 3 bedrooms, 2 full baths, and an attached 2 car garage. You don\'t want to miss all this gorgeous home has to offer! Estimated completion is November 2022. Call to schedule your showing today! Days on market reflect the number of days the home has been under construction.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Polo Ranch Section 8, Block 2, Lot 34' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '675' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`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,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Polo Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.3' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675089485' WHERE `Matrix_Unique_ID` = '214896354' --> 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','215151983','1675089486','215151983','2022-12-10T12:37:07.980','76224388','Justin Dickey','Keller Williams Professionals','','','29.832787','-95.855923','45','77493','14','507273.00','Active','Acapulco Mist','5331','Drive','Katy','4','0','5','3256','Single-Family','Beautiful Colina Home 5/4/2 Truly amazing 2 Story Featuring a Stunning Vestibule in the Foyer. Double Tray Ceilings in the Family Room with 13\' Ceilings, Oversized kitchen island overlooking the living room,42\" cabinets, granite and tiled backsplash. + Stainless steel appliances to include a 5 burner stove+ Vinyl Wood Floors + 2” blinds + LP Techshield radiant barrier + Front Gutters + Pex Plumbing and Much more is included in your new Colina Home. Situated in one of the best communities in Katy. Katy Lakes offers everything you are looking for in a family friendly community- NEW Jr. Size Olympic swimming pool, NEW Splash Pad, Huge Playground, Cabana all included for you, 30 minutes from Downtown Houston. Open 7 days a week. Built W/Outstanding standard features!! This is one of the last homes to be built so take advantage now! Stop by the model home today. EST completion MAY 2023!! Photos are Representative','','25','Colina Homes','','Electric Dryer Connections,Gas Dryer Connections','','No Disclosures','1','','','Katy - Old Towne','Central Gas','1','Lot 8 Block 2 Sec 40','Corner,Subdivision Lot','10495','Survey','','1330','1','To Be Built/Under Construction','2','Freestanding Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Accompany','Builder','2','Traditional','Sunterra','','3.5','Public Sewer,Public Water,Water District','2023','Builder'); --> 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','215165940','1675089486','215165940','2022-12-10T12:35:20.330','59681007','Justin Dickey','Keller Williams Professionals','','','29.832870','-95.855810','20','77493','11','461200.00','Active','Acapulco Mist','5322','Drive','Katy','2','1','4','2715','Single-Family','Beautiful Colina Home with 4 bedrooms, 2.5 baths, and study there\'s room for everyone! Large study located downstairs. Master bedroom located downstairs just outside the huge living room large enough for the whole family to get together for special occasions and holidays. Beautiful kitchen with upgraded 42\" cabinets, granite countertops, stainless steel appliances and is open to the oversized family room. The master suite features a large walk in closet and a spacious bath with a relaxing soaker tub and separate shower. Large game room located upstairs with a view to the first floor, 3 car garage included. 2\" faux wood blinds save you money and provide privacy from day one. The in wall pest control system protects your home. EST completion MAY 2023!! Photos are REPRESENTATIVES!!!','','25','Colina Homes','','Electric Dryer Connections,Gas Dryer Connections','','No Disclosures','1','','','Katy - Old Towne','Central Gas','1','Lot 4 Block 4 Sec 40','Subdivision Lot','11336','Survey','','1330','1','To Be Built/Under Construction','3','','0','','','Freestanding Range,Gas Cooktop,Gas Range','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Builder','2','Traditional','Sunterra','','3.5','Public Sewer,Public Water,Water District','2023','Builder'); --> 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','215166436','1675089486','215166436','2022-12-10T12:33:02.710','20123976','Justin Dickey','Keller Williams Professionals','','','29.832787','-95.855923','45','77493','14','488023.00','Active','Mystic Sea','5306','Drive','Katy','4','0','5','3256','Single-Family','Beautiful Colina Home 5/4/2 Truly amazing 2 Story Featuring a Stunning Vestibule in the Foyer. Double Tray Ceilings in the Family Room with 13\' Ceilings, Oversized kitchen island overlooking the living room,42\" cabinets, granite and tiled backsplash. + Stainless steel appliances to include a 5 burner stove+ Vinyl Wood Floors + 2” blinds + LP Techshield radiant barrier + Front Gutters + Pex Plumbing and Much more is included in your new Colina Home. Situated in one of the best communities in Katy. Katy Lakes offers everything you are looking for in a family friendly community- NEW Jr. Size Olympic swimming pool, NEW Splash Pad, Huge Playground, Cabana all included for you, 30 minutes from Downtown Houston. Open 7 days a week. Built W/Outstanding standard features!! This is one of the last homes to be built so take advantage now! Stop by the model home today. Estimated completion May 2023!! Photos are Representative','','25','Colina Homes','','Electric Dryer Connections,Gas Dryer Connections','','No Disclosures','1','','','Katy - Old Towne','Central Gas','1','Lot 14 Block 3 Sec 40','Corner,Subdivision Lot','10495','Survey','','1330','1','To Be Built/Under Construction','2','Freestanding Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Accompany','Builder','2','Traditional','Sunterra','','3.5','Public Sewer,Public Water,Water District','2023','Builder'); --> 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','215213561','1675089486','215213561','2022-12-10T12:34:03.097','32200990','Justin Dickey','Keller Williams Professionals','','','29.832787','-95.855923','46','77493','14','491099.00','Active','Costa Ridge','5318','Lane','Katy','4','0','5','3256','Single-Family','Beautiful Colina Home 5/4/2 Truly amazing 2 Story Featuring a Stunning Vestibule in the Foyer. Double Tray Ceilings in the Family Room with 13\' Ceilings, Oversized kitchen island overlooking the living room,42\" cabinets, granite and tiled backsplash. + Stainless steel appliances to include a 5 burner stove+ Vinyl Wood Floors + 2” blinds + LP Techshield radiant barrier + Front Gutters + Pex Plumbing and Much more is included in your new Colina Home. Situated in one of the best communities in Katy. Katy Lakes offers everything you are looking for in a family friendly community- NEW Jr. Size Olympic swimming pool, NEW Splash Pad, Huge Playground, Cabana all included for you, 30 minutes from Downtown Houston. Open 7 days a week. Built W/Outstanding standard features!! This is one of the last homes to be built so take advantage now! Stop by the model home today. EST completion MAY 2023!!Photos are Representative','','25','Colina Homes','','Electric Dryer Connections,Gas Dryer Connections','','No Disclosures','1','','','Katy - Old Towne','Central Gas','1','Lot 24 Block 4 Sec 40','Corner,Subdivision Lot','10495','Survey','','1330','1','To Be Built/Under Construction','2','Freestanding Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Accompany','Builder','2','Traditional','Sunterra','','3.5','Public Sewer,Public Water,Water District','2023','Builder'); --> 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','215498952','1675089486','215498952','2022-12-10T12:15:07.730','97574528','Daryl Pavlicek','Adams Homes Realty, INC','','','28.031237','-97.064655','26','78382','5','339000.00','Active','North Terry','902','Street','Rockport','2','0','3','2198','Single-Family','You must see this large home, over 2100 sq ft on 2 corner lots with majestic coastal live oaks, and a water well for irrigation. Ranch brick style home has 3 bedrooms, 2 baths, formal living, and a large game room/media room with built-ins, and fireplace. Large covered screened patio for outdoor entertaining or enjoying the breeze with your favorite book. The screened porch also has a hidden built-in double oven for extra holidays baking. There is a converted room in the garage perfect for home-office, studio or you could convert it back to a garage. This home is in a great location and minutes from the Rockport Beach.','0.293','85','','','','','Other Disclosures,Sellers Disclosure','','','','','Central Gas','0','SMITH AND WOOD, BLOCK 184, LOT 15 THRU 16','Corner','12800','Survey','','','0','','2','','0','','','','','Composition','310 - Aransas County','LIVE OAK 1-3 LEARNING CENTER','ROCKPORT-FULTON HIGH SCHOOL','ROCKPORT-FULTON MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Ranch','Smith & Wood','3313','1.3696','Public Sewer,Public Water,Well','1967','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','215506911','1675089486','215506911','2022-12-10T12:52:14.153','29648549','Moises Arteaga','Coldwell Banker Realty','','','29.656017','-95.639710','45','77498','10','850000.00','Active','Burney','11010','Road','Sugar Land','4','1','5','3926','Single-Family','A rare opportunity to own just under an acre of commercial and residential property! 11010 Burney Rd. offers the opportunity to bypass traffic and the inflated gas prices by working in your freestanding office/workplace separate from your residence but within steps from your home. Both properties and structures will be sold together, with the exception of the dog grooming business itself. There is plenty of private parking for the business as well as parking for the homeowners and or guests. This 3,926sqft.(per the builder) 5 Bedroom 4.5 Bath home has plenty of sqft. which includes a game-room(pool/ping pong table can be negotiated) movie/entertainment room, gym area( exercise equipment are negotiable as well) and 4 Car Garage! The property also features a private pool, a double size tennis court and basketball goal with outdoor area to spare. The frontage is fantastic and off a convenient, busy and major road. This is a perfect property for a small business, church or youth center.','1.045','29','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Sugar Land North','Central Electric','1','0032 A HODGE, ACRES 0.5185, BURNEY ROAD CENTER SUBDIVISION','Cleared,Other','22586','Appraisal District','','711','0','','4','Electric Oven','1','In Ground','','Electric Cooktop','','Composition','19 - Fort Bend','DRABEK ELEMENTARY SCHOOL','KEMPNER HIGH SCHOOL','SUGAR LAND MIDDLE SCHOOL','Appointment Required,Request Online Appointment','Appraisal District','2','Traditional','A Hodge','6745','2.2929','Water District','2008','Appraisal District'); --> New record created successfully