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-07T14:53:09.360' ,`MLSNumber` = '16043554' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.426771' ,`Longitude` = '-95.449137' ,`PhotoCount` = '10' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '312990.00' ,`Status` = 'Active' ,`StreetName` = 'Homewood Point' ,`StreetNumber` = '1623' ,`StreetSuffix` = 'Lane' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1710' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, 2.5 Car Garage, Study, Granite Dual Square Vanities in Owner’s Bath, Separate Garden Tub and Shower, Rigid Core Floors in Entry, Study, Dining, Utility, Kitchen, Breakfast, Family Room and All Baths, Quartz Kitchen Countertops with Island, Mosaic Tile Backsplash, Granite Countertops in Secondary Bath, Stainless Steel Appliances, Upgrade Interior Doors w/ Satin Nickel Hardware, 42” Upper Kitchen Cabinets, Full Gutters, Covered Patio, Full Sod, Irrigation, Stone Accents, Brick Back, Brick Front Porch, 2” Window Blinds, Tech Shield Roof, Environments for Living Home, plus more…AVAILABLE DECEMBER .' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 2 BLK 2 SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088380' WHERE `Matrix_Unique_ID` = '208771967' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T14:53:30.370' ,`MLSNumber` = '97623756' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.426771' ,`Longitude` = '-95.449137' ,`PhotoCount` = '10' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '334990.00' ,`Status` = 'Active' ,`StreetName` = 'Homewood Point' ,`StreetNumber` = '1627' ,`StreetSuffix` = 'Lane' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1837' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, 3 Car Garage, Study, Formal Dining, Granite Dual Square Vanities in Owner’s Bath, Separate Garden Tub and Shower, Rigid Core Floors in Entry/Foyer, Study, Dining, Utility, Kitchen, Breakfast, Family Room and All Baths, Granite Kitchen Countertops with Island, Tile Backsplash, Granite Countertops in Secondary Bath, 42\" Upper Kitchen Cabinets, Stainless Steel Appliances, 2” Window Blinds, Upgrade Interior Doors w/ Satin Nickel Hardware, Stone Accents, Brick Back, Brick Front Porch, Covered Patio, Full Sod and Irrigation System, Full Gutters, Corner Home Site, Tech Shield Roof, Environments for Living Home, plus more…AVAILABLE DECEMBER.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1 BLK 2 SEC 8' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8438' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088380' WHERE `Matrix_Unique_ID` = '208773515' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T14:53:56.203' ,`MLSNumber` = '8465559' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.426771' ,`Longitude` = '-95.449137' ,`PhotoCount` = '10' ,`PostalCode` = '77583' ,`RoomCount` = '12' ,`ListPrice` = '368990.00' ,`Status` = 'Active' ,`StreetName` = 'Homewood Point' ,`StreetNumber` = '1607' ,`StreetSuffix` = 'Lane' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2593' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 4 Bedroom, 2 1/2 Bath, 3 Car Garage, Study, Formal Dining, Game Room & Owner’s Suite Up, Granite Dual Square Vanities in Owner’s Bath, Separate Garden Tub and Shower, Rigid Core Floors in Entry, Utility, Study, Dining, Kitchen/Breakfast, Family Room and all Baths, Quartz Kitchen Countertops with Island, Marble Backsplash, 42” Upper Kitchen Cabinets, Upgraded Stainless Steel Appliances, Wrought Iron Stair Parts, Extended Covered Patio, Full Sod and Irrigation System, Full Gutters, Brick Back, Brick Front Porch, Stone Accented Elevation, Tech Shield Roof, Environments for Living Home, plus more…AVAILABLE DECEMBER.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 6 BLK 2 SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088380' WHERE `Matrix_Unique_ID` = '208776558' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T14:11:56.300' ,`MLSNumber` = '2874186' ,`ListAgentFullName` = 'Lacie Lugo' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.849087' ,`Longitude` = '-95.488160' ,`PhotoCount` = '5' ,`PostalCode` = '77092' ,`RoomCount` = '3' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Highrock' ,`StreetNumber` = '6626' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1814' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION - COMING SOON' ,`Acres` = '0.1435' ,`Area` = '9' ,`BuilderName` = 'The Collective' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 40 & 41 BLK 7 ROSSLYN' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Colonial,Contemporary/Modern' ,`Subdivision` = 'Rosslyn' ,`TaxAmount` = '2638' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088381' WHERE `Matrix_Unique_ID` = '210731151' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T14:12:29.980' ,`MLSNumber` = '72621272' ,`ListAgentFullName` = 'Lacie Lugo' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.849087' ,`Longitude` = '-95.488160' ,`PhotoCount` = '5' ,`PostalCode` = '77092' ,`RoomCount` = '3' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Highrock' ,`StreetNumber` = '6630' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1814' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION - COMING SOON' ,`Acres` = '0.1435' ,`Area` = '9' ,`BuilderName` = 'The Collective' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 40 & 41 BLK 7 ROSSLYN' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Colonial,Contemporary/Modern' ,`Subdivision` = 'Rosslyn' ,`TaxAmount` = '2638' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088381' WHERE `Matrix_Unique_ID` = '210734450' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T14:05:23.097' ,`MLSNumber` = '12518467' ,`ListAgentFullName` = 'Clayton Hays' ,`ListOfficeName` = 'RE/MAX Advanced Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.472575' ,`Longitude` = '-96.049360' ,`PhotoCount` = '19' ,`PostalCode` = '75831' ,`RoomCount` = '3' ,`ListPrice` = '149500.00' ,`Status` = 'Active' ,`StreetName` = 'Ray' ,`StreetNumber` = '528' ,`StreetSuffix` = 'Street' ,`City` = 'Buffalo' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1512' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Buffalo TX - 3 BED 2 BATH on 1+/-AC in Buffalo City Limits -\r\n Great location being located just at the edge of town at the end of a black top city street. This home is in a nice quiet area in a neat and clean neighborhood.\r\nThe Home sits atop a beautiful hill with a great view off the back porch overlooking a huge back yard and in ground swimming pool.\r\nA circle driveway and huge oak trees decorate the front yard creating a nice approach from the road.\r\nThis Home has had several updates throughout that includes new laminate flooring, fixtures and bathroom upgrades. \r\nThe master bedroom is very spacious and also has a huge custom shower with nice tilework.\r\nGreat place to entertain friends and family in the back yard this summer hanging out by the pool.' ,`Acres` = '0.88' ,`Area` = '63' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Buffalo Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BUFFALO CITY TR 9 0.8800 AB 562 S D MCKAY' ,`LotDesciption` = 'Cleared' ,`LotSize` = '38333' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '194 - Buffalo' ,`SchoolElementary` = 'BUFFALO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUFFALO HIGH SCHOOL' ,`SchoolMiddle` = 'BUFFALO JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Buffalo' ,`TaxAmount` = '2458' ,`TaxRate` = '2.2532' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088381' WHERE `Matrix_Unique_ID` = '211225869' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T14:58:23.160' ,`MLSNumber` = '96442664' ,`ListAgentFullName` = 'Jody Cassady' ,`ListOfficeName` = 'Full Stringer Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.691561' ,`Longitude` = '-95.971263' ,`PhotoCount` = '33' ,`PostalCode` = '77457' ,`RoomCount` = '3' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Mulberry' ,`StreetNumber` = '599' ,`StreetSuffix` = 'Street' ,`City` = 'Matagorda' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Potential investment on one corner lot in Matagorda. Mature trees that provide a lot of shade and outdoor enjoyment. Home has potential to add your own personal touch with updates and renovation. Flooring will need repair. Large living room with spacious windows allowing natural light to flow in the home. New roof. Wood burning fireplace. Three bedrooms with three baths. Out buildings will need to be removed. Lot size 112 x 167. Once removed a barn could be built for the boat and golf cart! Great outdoor living space that could be improved upon or enhanced. Minutes from the harbor. Short drive to the beach. Enjoy all the amenities of beach and fishing and living in town close to shops and restaurants.' ,`Acres` = '0.423' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TIER 3 MATAGORDA FRONT LOTS 5 BLK 5' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '37418' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '170 - Matagorda' ,`SchoolElementary` = 'MATAGORDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'MATAGORDA ELEMENTARY SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Matagorda' ,`TaxAmount` = '3886' ,`TaxRate` = '1.7637' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088381' WHERE `Matrix_Unique_ID` = '212425246' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T14:50:54.483' ,`MLSNumber` = '84154297' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.434015' ,`Longitude` = '-95.450717' ,`PhotoCount` = '6' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Greenhorn' ,`StreetNumber` = '10318' ,`StreetSuffix` = 'Lane' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1670' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, Study with French Doors, Dual Rectangle Vanities with Granite Tops in Primary Bath, Separate Garden Tub and Recessed Tile Shower, Rigid Core Floors in Entry/Foyer, Study, Dining, Utility, Kitchen/Breakfast, Family Room, Hall to Bedrooms and all Baths, Quartz Kitchen Countertops with Island, 4”x6” Tile Kitchen Backsplash, Upgraded Carpet and Pad, Stainless Steel Appliances, Brushed Nickel Lighting and Plumbing Trim Packages, 42” Upper Kitchen Cabinets, Rocker Switches, 2” Window Blinds, Satin Nickel Door Levers, Full Gutters, Covered Patio, Brick Back, Full Sod and Irrigation System, Garage Door Opener, Stone Accented Elevation, Tech Shield Roof, ENERGY STAR Certified Home, plus more…AVAILABLE JANUARY.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 18 BLK 1 SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6336' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.607' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088382' WHERE `Matrix_Unique_ID` = '213042281' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T14:52:34.570' ,`MLSNumber` = '81243219' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.431982' ,`Longitude` = '-95.453313' ,`PhotoCount` = '6' ,`PostalCode` = '77583' ,`RoomCount` = '16' ,`ListPrice` = '379990.00' ,`Status` = 'Active' ,`StreetName` = 'Darwin Cedar' ,`StreetNumber` = '1605' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2883' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cul-De-Sac Home Site, 2 Story, 5 Bedroom, 3 ½ Bath, Study with French Doors, Formal Dining Room, Game Room Up, Primary Bedroom Down, Dual Rectangle Vanities with Granite Tops in Primary Bath, Separate Garden Tub and Recessed Tile Shower, Rigid Core Floors in Entry/Foyer, Utility, Study, Dining, Kitchen/Breakfast, Family Room and all Baths, Silestone Kitchen Countertops with Island, Marble Kitchen Backsplash, 42” Upper Kitchen Cabinets, Upgraded Carpet and Pad, Stainless Steel Appliances, Wrought Iron Stair Parts, Raised Panel Interior Doors, Rocker Switches, 2” Window Blinds, Satin Nickel Interior Door Levers, Extended Covered Patio with Gas Line Stub, Full Sod and Irrigation System, Full Gutters, Brick Back on First Floor, Stone Accented Elevation, Tech Shield Roof, ENERGY STAR Certified Home, plus more…AVAILBLE FEBRUARY.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 11 BLK 2 SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8402' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.607' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088382' WHERE `Matrix_Unique_ID` = '213042343' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T14:52:10.907' ,`MLSNumber` = '70980842' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.433910' ,`Longitude` = '-95.450616' ,`PhotoCount` = '6' ,`PostalCode` = '77583' ,`RoomCount` = '12' ,`ListPrice` = '349990.00' ,`Status` = 'Active' ,`StreetName` = 'Greenhorn' ,`StreetNumber` = '10322' ,`StreetSuffix` = 'Lane' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2593' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 4 Bedroom, 2 ½ Bath, Study with French Doors, Formal Dining Room, Game Room and Primary Bedroom Up, Dual Rectangle Vanities with Granite Tops in Primary Bath, Separate Garden Tub and Shower, Rigid Core Floors in Entry/Foyer, Utility, Study, Dining, Kitchen/Breakfast, Family Room and all Baths, Granite Kitchen Countertops with Island, Tile Kitchen Backsplash, Upgraded Carpet and Pad, 42” Upper Kitchen Cabinets, Stainless Steel Appliances, Wrought Iron Stair Parts, Raised Panel Interior Doors, Rocker Switches, 2” Window Blinds, Satin Nickel Door Levers, Extended Covered Patio, Full Sod and Irrigation System, Garage Door Opener, Full Gutters, Brick Back on First Floor, Tech Shield Roof, ENERGY STAR Certified Home, plus more…AVAILABLE FEBRUARY.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 17 BLK 1 SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6351' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.607' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088382' WHERE `Matrix_Unique_ID` = '213042603' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T14:33:36.133' ,`MLSNumber` = '6848683' ,`ListAgentFullName` = 'Nancy Lawrence' ,`ListOfficeName` = 'Lawrence Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.315472' ,`Longitude` = '-95.443774' ,`PhotoCount` = '26' ,`PostalCode` = '75835' ,`RoomCount` = '3' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Enchanted Estates' ,`StreetNumber` = '206' ,`StreetSuffix` = 'Drive' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2528' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you’re looking for a move-in-ready home in the highly desirable Enchanted Estates subdivision, look no further! This three bedroom, two and one-half bath brick home is situated on a large .413-acre lot at the front of Enchanted Estates. From the moment you walk through the door, you will feel at home with the wonderful sunroom and open living space for the whole family to enjoy. This home has been outfitted with new vinyl tile in all the shared living areas and primary bedroom. In the two guest bedrooms, you will appreciate the cozy carpet on your feet as you step out of bed in the morning. The primary bedroom is oversized with a walk-in shower. The mudroom/laundry is large and includes a half bath that is perfect for visiting guests. Granite countertops throughout the home complete this great layout. This home also includes a brick gas fireplace, outdoor covered patio, fended yard for the family pets, and a new roof! If you would like to see this beautiful home, call today!' ,`Acres` = '0.4126' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ENCHANTED ESTATES A E GOSSETT LOT 23 AB 423 SEC 1 .01 AC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '17973' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '57 - Crockett' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (CROCKETT)' ,`SchoolHigh` = 'CROCKETT HIGH SCHOOL (CROCKETT)' ,`SchoolMiddle` = 'CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Enchanted Estates' ,`TaxAmount` = '5035' ,`TaxRate` = '2.3627' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088382' WHERE `Matrix_Unique_ID` = '213591064' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T14:21:53.700' ,`MLSNumber` = '26048819' ,`ListAgentFullName` = 'Beth Buford' ,`ListOfficeName` = 'Compass RE Texas, LLC Heights' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.280224' ,`Longitude` = '-95.562617' ,`PhotoCount` = '40' ,`PostalCode` = '77316' ,`RoomCount` = '10' ,`ListPrice` = '485500.00' ,`Status` = 'Active' ,`StreetName` = 'Clearmont' ,`StreetNumber` = '183' ,`StreetSuffix` = 'Place' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3132' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller!! You will fall in love with this home! Located in the desirable Woodforest neighborhood, it offers\r\na beautifully landscaped large backyard with a lovely lit social area perfect for a fire pit along with a covered\r\npatio, making it a spot for you to enjoy year-round. Nestled on a quiet cul-de-sac, you will find 3\r\nbr and 2.5 ba downstairs with the 4th br, en suite bath and large game room up. The\r\nupstairs offers endless potential for an office, media room or playroom! The inviting entrance leads to an\r\nopen kitchen/living space perfect for entertaining or enjoying family time together. The split floor plan\r\ndown allows for privacy between the primary and secondary br. Looking for additional storage\r\nand/or a work space? The garage is equipped w/ a built-in work bench & storage racks. Mounted TV in\r\ngarage to stay with home.\r\nWoodforest amenities include a resort-style pool, lap pool, splash pad, walking paths, playgrounds,\r\n& community events.' ,`Acres` = '0.3145' ,`Area` = '39' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965200 - WOODFOREST 01, BLOCK 1, LOT 34' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '13698' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '10944' ,`TaxRate` = '2.6888' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088382' WHERE `Matrix_Unique_ID` = '214550545' --> 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','215148289','1675088383','215148289','2022-12-07T13:13:53.077','55158138','Shoaib Ahmed','REALM Real Estate Professional','','','29.683696','-95.368511','25','77021','3','390000.00','Active','La Salette','7526','Street','Houston','3','1','3','1804','Single-Family','NEW CONSTRUCTION! Spectacular 3 story house with contemporary looks and finishes. Located minutes away from the Medical Center, EDO, Downtown, Rice U, UH Main Campus, and TSU. This open floor plan offers 1 Bedroom w/ attached bath on 1st floor, 2 bedrooms including the Master Suite on the third floor; kitchen, dining, and living on the 2nd floor. SS appliances and Quartz countertop in the kitchen soft close cabinets, high ceilings and tall doors throughout the house for the perfect modern look. Luxury Vinyl flooring Throughout, Porcelain Tile in Bathrooms & Wet Areas. High Ceilings, PEX Plumbing, Tech Shield Roof Decking w/Radiant Barrier. Call today to schedule a private tour.','','4','TMC Homes LLC','','Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','University Area','Central Gas','0','LT 3 BLK 1 LASALETTE STREET HOMES','Subdivision Lot','1550','Survey','','','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','WHIDBY ELEMENTARY SCHOOL','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Leave Business Card,Lockbox Front,Vacant/Unoccupied','Builder','3','Contemporary/Modern','SOUTH END SUNNYSIDE U/R','','','Public Sewer,Public Water','2022','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','215167391','1675088383','215167391','2022-12-07T14:59:46.540','31770249','Patricia McCulley','Country World Realty, LLC','','','30.433358','-95.475143','16','77378','5','164000.00','Active','Libby','104','Circle','Willis','1','1','2','1086','Single-Family','Great starter home located in the Willis area and very convenient to I45 for commute. Has washer and dryer hookups. 2 Bedroom/1.5 Bath, with the half bath being adjacent to the primary suite. Primary suite also has access to primary bath from the half bath. Fenced in backyard.','0.1723','19','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Willis Area','Central Electric','0','FOWLER WILLIAM E 02 LT 21 F#8928757','Subdivision Lot','7507','Appraisal District','','','0','','0','','0','','','','','Composition','56 - Willis','PARMLEY ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','LYNN LUCAS MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Fowler William E 02','2827','2.4131','Public Sewer,Public Water','1985','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','215175518','1675088383','215175518','2022-12-07T13:10:25.103','46013448','Linda Tello','Berkshire Hathaway HomeServicePremier Properties','','','29.409347','-98.685739','12','78245','4','180000.00','Active','Messenger','9858','Pass','San Antonio','2','0','2','1068','Single-Family','Cozy one story home with open floor plan, 2 bedrooms, 2 baths and 1 car garage. Great for 1st time home buyers.Large backyard with deck great for entertainment. Quick access to Loop 1604 - Hwy 90','0.106','83','','','','','Sellers Disclosure','','','','','Central Electric','1','CB 4332A BLK 83 LOT 6 SUNSET SUBD UT-3','Subdivision Lot','4617','Appraisal District','','','0','','1','','0','','','','','Composition','247 - Northside (Bexar)','MICHAEL ELEMENTARY SCHOOL','STEVENS HIGH SCHOOL','VALE MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Sunset Sub','2861','2.0216','Public Sewer,Public Water','2001','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','215339526','1675088383','215339526','2022-12-07T13:52:50.857','18421537','Dan Cook','SWE Homes','','','29.826041','-95.363610','12','77022','3','258500.00','Active','Post','642','Street','Houston','1','0','3','1036','Single-Family','Cute 3 bed 1 bath home located in Northern Houston. This home sits on ¼ acres of land and features wooded flooring in the main areas of the home, carpet in the bedrooms, a 1-car garage, extended driveway, brand new roof, fresh interior/exterior paint, and fresh paint on the kitchen cabinets! It has a beautiful and spacious backyard! You will also have easy access to 610, I-45 N, and the Hardy Toll Road which are all main highways to get around town. Don\'t miss this opportunity! Contact us for more information!','0.3044','9','','','','','Other Disclosures,Owner/Agent','','','','Northwest Houston','Other Heating','0','LT 293 BLK 12 COLONIAL GARDENS','Other','13260','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','HERRERA ELEMENTARY SCHOOL (HOUSTON)','SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER','BURBANK MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Other Style','Colonial Gardens','2894','2.3307','Other Water/Sewer','1948','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','215357604','1675088383','215357604','2022-12-07T14:24:02.007','37430891','Shoaib Ahmed','REALM Real Estate Professional','','','29.683704','-95.368507','23','77021','3','390000.00','Active','La Salette','7524','Street','Houston','3','1','3','1804','Single-Family','NEW CONSTRUCTION! Spectacular 3 story house with contemporary looks and finishes. Located minutes away from the Medical Center, EDO, Downtown, Rice U, UH Main Campus, and TSU. This open floor plan offers all bedrooms including the Master Suite on the third floor; kitchen, dining, and living on the 2nd floor. SS appliances and Quartz countertop in the kitchen soft close cabinets, high ceilings and tall doors throughout the house for the perfect modern look. Luxury Vinyl flooring Throughout, Porcelain Tile in Bathrooms & Wet Areas. High Ceilings, PEX Plumbing, Tech Shield Roof Decking w/Radiant Barrier. Call today to schedule a private tour.','','4','TMC Homes LLC','','Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','University Area','Central Gas','0','LT 2 BLK 1 LASALETTE STREET HOMES','Subdivision Lot','1550','Survey','','','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','WHIDBY ELEMENTARY SCHOOL','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied','Builder','3','Contemporary/Modern','SOUTH END SUNNYSIDE U/R','','','Public Sewer,Public Water','2022','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','215405044','1675088383','215405044','2022-12-07T13:40:34.620','4258078','Dan Cook','SWE Homes','','','29.889209','-95.502126','11','77040','4','249500.00','Active','Log Hollow','7410','Drive','Houston','2','1','4','1683','Single-Family','Large 4 bed 2.5 bath home located in Northwest Houston. This is the perfect place for you and your family to call home! The property features plenty of windows for an abundance of natural light. It also boasts a gorgeous kitchen with oversized cabinets, granite-like countertops, and tile backsplash. There is laminate flooring in the living areas, tiled showers in the bathrooms, and a large backyard with a designated grilling area that is perfect for barbeques! You will also enjoy being near plenty of grocery stores, a Tinseltown movie theater, and a bunch of popular restaurants! Contact us to learn how you can make this wonderful home yours today!','0.1465','11','','','','','No Disclosures','','','','Northwest Houston','Other Heating','0','LT 19 BLK 7 WOODLAND TRAILS NORTH SEC 7','Other','6380','Appraisal District','','','0','','0','','0','','','','','Composition','1 - Aldine','ERMEL ELEMENTARY SCHOOL','EISENHOWER HIGH SCHOOL','GARCIA MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Other Style','Woodland Trails North Sec 07','3790','2.5119','Other Water/Sewer','1977','Appraisal District'); --> New record created successfully