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-20T10:07:42.017' ,`MLSNumber` = '10341897' ,`ListAgentFullName` = 'Beth Westbrook' ,`ListOfficeName` = 'Coldwell Banker Southern Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.920440' ,`Longitude` = '-93.936326' ,`PhotoCount` = '32' ,`PostalCode` = '77642' ,`RoomCount` = '8' ,`ListPrice` = '165000.00' ,`Status` = 'Active' ,`StreetName` = '35th' ,`StreetNumber` = '3800' ,`StreetSuffix` = 'Street' ,`City` = 'Port Arthur' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2186' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a solid house with big rooms? This house has it. New Roof in December of 2020. Replaced AC in 2020 also new water heater in 2021. So, no worries on the big-ticket items for sure. Home sits on a cul-de-sac in a quiet neighborhood. Elementary close by. Shopping is close to this home too! Great backyard for playing or even a garden. No Flooding at all. High and dry. Solid home with lots to offer. Don\'t miss out come see today!' ,`Acres` = '0.2287' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'HARGROVE REPLAT LT 10 BLK 2' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '9960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '236 - Port Arthur' ,`SchoolElementary` = 'TYRRELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PORT ARTHUR)' ,`SchoolMiddle` = 'JEFFERSON MIDDLE SCHOOL (PORT ARTHUR)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hargrove Rep' ,`TaxAmount` = '4401' ,`TaxRate` = '3.267' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093494' WHERE `Matrix_Unique_ID` = '206449873' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T10:08:47.927' ,`MLSNumber` = '60135544' ,`ListAgentFullName` = 'Robert Peltier' ,`ListOfficeName` = 'Bob Peltier & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.178140' ,`Longitude` = '-95.403906' ,`PhotoCount` = '32' ,`PostalCode` = '77515' ,`RoomCount` = '5' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Austin' ,`StreetNumber` = '236' ,`StreetSuffix` = 'Street' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1490' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW WHAT A DEAL, THE MAIN HOUSE HAS LARGE LIVING OPEN TO KITCHEN AND DINING, LARGE PANTRY, TWO BEDROOMS AND ONE BATH, ENCLOSED GARAGE WITH INDOOR UTILITY, ATTACHED WITH IT\'S OWN ENTRY IS THE IN LAW QUARTERS CONSISTING OF BEDROOM/LIVING, BATH, KITCHEN, DINING AREA AND INDOOR UTILITY, WITH OUTSIDE ENTRY TO COVERED DECK WHICH LEADS TO SEPARATE GUEST QUARTERS WHICH INCLUDE BEDROOM/LIVING AND BATH, DECK IS SURROUNDED BY BEAUTIFUL TROPICAL PLANTS AND FLOWERS, SIT OUT AT NIGHT AND ENJOY THE DECK WITH SOLAR LIGHTS AND OPEN FIELD BEHIND THIS BEAUTIFUL BACK YARD. , THIS WOULD MAKE A GREAT INCOME HOME.' ,`Acres` = '0.186' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'COUNTRY ESTATES SEC 2 (ANGLETON) BLK 3 LOT 10' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8102' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Estates' ,`TaxAmount` = '4206' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093494' WHERE `Matrix_Unique_ID` = '209821966' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T09:24:33.257' ,`MLSNumber` = '53633916' ,`ListAgentFullName` = 'Babu Kuttarappallil' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.772444' ,`Longitude` = '-95.405023' ,`PhotoCount` = '9' ,`PostalCode` = '77007' ,`RoomCount` = '3' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Allen' ,`StreetNumber` = '4322' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '910' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'In a very good location and you can build your dream home home. contact the listing agent for more information. It was leased previously. The home will be sold as is.' ,`Acres` = '0.0735' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TR 14B BLK 3 LEAGUE J C' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2409' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'League J C' ,`TaxAmount` = '3974' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675093494' WHERE `Matrix_Unique_ID` = '210116912' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T09:46:43.507' ,`MLSNumber` = '94074333' ,`ListAgentFullName` = 'Maira Vale' ,`ListOfficeName` = 'Hardee & Company Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.172687' ,`Longitude` = '-95.055366' ,`PhotoCount` = '25' ,`PostalCode` = '77327' ,`RoomCount` = '7' ,`ListPrice` = '130000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 3548' ,`StreetNumber` = '2149' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This mobile home is sitting in a corner lot and has residential and commercial use. Since HWY 99 has opened this will be a great opportunity to develop a commercial shop as well.' ,`Acres` = '0.45' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND SAN JACINTO, SEC 5, BLOCK 65, LOT 2539, ACRES 0.45' ,`LotDesciption` = 'Cleared' ,`LotSize` = '19602' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand San Jacinto, Sec 5' ,`TaxAmount` = '997' ,`TaxRate` = '1.8013' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093494' WHERE `Matrix_Unique_ID` = '211427474' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T09:44:00.977' ,`MLSNumber` = '16789060' ,`ListAgentFullName` = 'Cynthia Gomez' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.547580' ,`Longitude` = '-95.340893' ,`PhotoCount` = '22' ,`PostalCode` = '77584' ,`RoomCount` = '8' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Northfork' ,`StreetNumber` = '4922' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1668' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 4922 Northfork! Located in Pearland TX! This beautiful home features 3 bedrooms, 2 baths, 2 car garage, a nice cover patio, shed for extra storage, and solar panel screens. Neighborhood park in walking distance and shady front yard. Call me to schedule your private showing today!' ,`Acres` = '0.1581' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHWYCK, BLOCK 9, LOT 3 SEC 1-REPLAT, A0242 HT&BRR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6887' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SILVERLAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwyck' ,`TaxAmount` = '5170' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093494' WHERE `Matrix_Unique_ID` = '211463380' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T10:01:01.903' ,`MLSNumber` = '83532543' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.547513' ,`Longitude` = '-95.484291' ,`PhotoCount` = '31' ,`PostalCode` = '77358' ,`RoomCount` = '4' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Tafelski' ,`StreetNumber` = '345' ,`StreetSuffix` = 'Road' ,`City` = 'New Waverly' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated on 1.5 unrestricted acres, this 3 bed 2 bath home is priced to sell! The kitchen boasts ample cabinet and counter space, an electric range, breakfast bar, and features an adjacent dining area + opens up to the family room featuring a wood burning fireplace, built-in shelves, and a generously sized space. The primary bedroom boasts an en-suite bath flaunting dual sinks, a separate shower + tub, and an abundance of storage space. Exterior features include a 24x40 metal shop, 10x15 storage building, a 2-car detached carport, and ample trees providing privacy! This home is priced to sell and won\'t last long. Schedule a private tour today!' ,`Acres` = '1.5' ,`Area` = '43' ,`BuilderName` = 'Palm Harbor' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'New Waverly Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'COLLARD L M (A-10), TRACT 2.32, ACRES 1.5, (MH 2.31)' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '65340' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '105 - New Waverly' ,`SchoolElementary` = 'NEW WAVERLY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEW WAVERLY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW WAVERLY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'N/A' ,`TaxAmount` = '1444' ,`TaxRate` = '1.8438' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675093495' WHERE `Matrix_Unique_ID` = '211560945' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T10:03:04.737' ,`MLSNumber` = '8236977' ,`ListAgentFullName` = 'Jay Patel' ,`ListOfficeName` = 'New Trends Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.945920' ,`Longitude` = '-95.249048' ,`PhotoCount` = '50' ,`PostalCode` = '77396' ,`RoomCount` = '10' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Barlow Springs' ,`StreetNumber` = '9506' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3510' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Must see this open and airy home on a large dead-end cul-de-sac lot. Updated kitchen with granite countertops and oversized pantry open to the family room. Beautifully tiled entrance & Breakfast area. Full bedroom and bathroom downstairs. Second floor primary bedroom en-suite bath features a separate shower, dual vanities, and a garden tub. Large Utility Room. Pre-wired Media room that is currently used as a bedroom. Plenty of storage in the garage. Huge backyard with patio. GATED COMMUNITY with covered basketball court and pool. Easy access to Beltway 8 and 10 minutes to IAH.' ,`Acres` = '0.2217' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 52 BLK 1 CANYON GATE AT PARK LAKES SEC 13' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9658' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PARK LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Gate/Pk Lakes Sec 13' ,`TaxAmount` = '8635' ,`TaxRate` = '2.9873' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675093495' WHERE `Matrix_Unique_ID` = '211766218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T10:59:54.190' ,`MLSNumber` = '29849000' ,`ListAgentFullName` = 'Maygen Ritchie' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.490111' ,`Longitude` = '-94.782083' ,`PhotoCount` = '12' ,`PostalCode` = '77351' ,`RoomCount` = '2' ,`ListPrice` = '130000.00' ,`Status` = 'Active' ,`StreetName` = 'Charles Keys' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Road' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1192' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this large lot with 2/2 with detached garage. Open space concept living and dinning room. Perfect for an investor. You don\'t want to miss out on this lot.' ,`Acres` = '0.998' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BIG THICKET LAKE ESTATES SECTION 3 LOT 406, 407, 408, 409 &' ,`LotDesciption` = 'Wooded' ,`LotSize` = '43472' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Big Thicket Lake Estates Secti' ,`TaxAmount` = '1469' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093495' WHERE `Matrix_Unique_ID` = '212124502' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T10:28:45.003' ,`MLSNumber` = '48499780' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.203272' ,`Longitude` = '-95.407333' ,`PhotoCount` = '22' ,`PostalCode` = '77515' ,`RoomCount` = '6' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Prairie Rose' ,`StreetNumber` = '3603' ,`StreetSuffix` = 'Trail' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Popular CastleRock \"Pedernales\" floorplan boasts 4 bedrooms and 2 bathrooms. Home is nicely upgraded with a covered patio, beautiful front elevation with stone highlights, and a luxury primary bath, among other included options. Beautiful, open floorplan.\r\n\r\nNew Windrose Green community in Angleton ISD! Windrose Green will offer easy access to I-35 & HWY 288 and will feature amenities such as a recreation center, lakes and walking trails, a play ground, and splash pad.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 26 Block 2 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5625' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'RANCHO ISABELLA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Windrose Green' ,`TaxAmount` = '' ,`TaxRate` = '3.48' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093495' WHERE `Matrix_Unique_ID` = '213439091' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T09:57:35.240' ,`MLSNumber` = '15861108' ,`ListAgentFullName` = 'Paige Potter' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.736568' ,`Longitude` = '-94.949979' ,`PhotoCount` = '22' ,`PostalCode` = '77520' ,`RoomCount` = '7' ,`ListPrice` = '169900.00' ,`Status` = 'Active' ,`StreetName` = 'Jefferson ST' ,`StreetNumber` = '1306' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*FRESH PAINT JOB ALERT!! Seller has had entire Outside of Home Repainted White w/ Black Trim! Giving it a NEW & Modern Look!*Do NOT Miss out on this Amazing Starter Home OR Potential Investment Property! This Spic & Span 3 Bedroom, 1 Bath is READY FOR MOVE IN! Home sits on a Great sized Lot, Has attached garage, Stunning Mixture of Grey tones throughout the house giving it a NEW & Modern Touch. Spacious living/ dining room combination, Ample amount of Wood Finished Cabinets in the Kitchen, Plenty of Granite Counter Top space, Stainless Steel Appliances, Upgraded Flooring in Living Room and Kitchen, Hallway, and Bathroom. Full Bath features tub/ shower combo w/ tile surround, HVAC & Roof replaced in 2015!If you\'re looking to add A home to your investment portfolio that needs LITTLE to ZERO improvement\'s- Than look no further- This home is for YOU! *Seller has added new flooring to kitchen to match flooring in living room! Home is also AVAILABLE TO LEASE! $1550/Month, Min 6 Month Lease.' ,`Acres` = '0.1808' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 2 MILBY DALE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'LORENZO DE ZAVALA ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'HORACE MANN J H' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Milby Dale Sec 05' ,`TaxAmount` = '2711' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093496' WHERE `Matrix_Unique_ID` = '214044467' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T09:30:57.240' ,`MLSNumber` = '27825174' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.728342' ,`Longitude` = '-95.933896' ,`PhotoCount` = '15' ,`PostalCode` = '77423' ,`RoomCount` = '9' ,`ListPrice` = '347965.00' ,`Status` = 'Active' ,`StreetName` = 'Harvest Valley' ,`StreetNumber` = '32634' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SEE SAMPLE 3D VIRTUAL TOUR!!! Welcome home the beautiful 2 Story, The Bedford II Floor Plan with 4 Bedrooms, 2 1/2 Baths, and attached 2 Car Garage. This floor plan boasts High Ceilings and a Spacious OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Study, and a Master Bedroom with an oversized closet downstairs. Upstairs you will find a Game Room, 3 Bedrooms with another full bath. Tile and Carpet throughout. Fenced Backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. A scenic overlook greets visitors as soon as they drive in, revealing a lakeside view that gives way to an open-air pavilion and amenity center. Amenities include RESORT-STYLE SWIMMING POOL! SPLASHPAD! CHILDREN’S PLAYGROUND! Convenient to I-10, TX Hwy 359, and Westpark Tollway. Lamar CISD!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Vanbrooke' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093496' WHERE `Matrix_Unique_ID` = '214794455' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T09:24:55.517' ,`MLSNumber` = '21221495' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.723338' ,`Longitude` = '-95.938701' ,`PhotoCount` = '14' ,`PostalCode` = '77423' ,`RoomCount` = '9' ,`ListPrice` = '342000.00' ,`Status` = 'Active' ,`StreetName` = 'Ruthie Dean' ,`StreetNumber` = '32935' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SEE SAMPLE 3D VIDEO TOUR!!! Welcome home the beautiful 2 Story, The Bedford II Floor Plan with 4 Bedrooms, 2 1/2 Baths, and attached 2 Car Garage. This floor plan boasts High Ceilings and a Spacious OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Study, and a Master Bedroom with an oversized closet downstairs. Upstairs you will find a Game Room, 3 Bedrooms with another full bath. Tile and Carpet throughout. Fenced Backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. A scenic overlook greets visitors as soon as they drive in, revealing a lakeside view that gives way to an open-air pavilion and amenity center. Amenities include RESORT-STYLE SWIMMING POOL! SPLASHPAD! CHILDREN’S PLAYGROUND! Convenient to I-10, TX Hwy 359, and Westpark Tollway. Lamar CISD!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Vanbrooke' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093496' WHERE `Matrix_Unique_ID` = '214820136' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T10:10:00.980' ,`MLSNumber` = '55133805' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.722717' ,`Longitude` = '-95.938597' ,`PhotoCount` = '8' ,`PostalCode` = '77423' ,`RoomCount` = '9' ,`ListPrice` = '385965.00' ,`Status` = 'Active' ,`StreetName` = 'Silver Meadow' ,`StreetNumber` = '32938' ,`StreetSuffix` = 'Way' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SEE SAMPLE 3D VIRTUAL TOUR!!! Welcome home the beautiful 2 Story, The Bedford II Floor Plan with 4 Bedrooms, 2 1/2 Baths, and attached 2 Car Garage. This floor plan boasts High Ceilings and a Spacious OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Study, and a Master Bedroom with an oversized closet downstairs. Upstairs you will find a Game Room, 3 Bedrooms with another full bath. Tile and Carpet throughout. Fenced Backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. A scenic overlook greets visitors as soon as they drive in, revealing a lakeside view that gives way to an open-air pavilion and amenity center. Amenities include RESORT-STYLE SWIMMING POOL! SPLASHPAD! CHILDREN’S PLAYGROUND! Convenient to I-10, TX Hwy 359, and Westpark Tollway. Lamar CISD!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Vanbrooke' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093496' WHERE `Matrix_Unique_ID` = '214829454' --> 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','215156625','1675093497','215156625','2022-12-20T09:50:43.553','29753639','Lisa Vuong','REALM Real Estate Professional','','','29.699023','-95.523567','30','77036','13','439900.00','Active','Tours','7319','Street','Houston','3','0','6','3600','Single-Family','OPEN HOUSE 1-3PM on SUNDAY DEC 11th. Hello, have you been looking for a large house that has 6 bedrooms/3 full baths and close to freeways, supermarkets, restaurants, schools, and hospitals? If so, this house is for you! This gorgeous house is situated on a large corner lot w/ amazing curb appeal. Tile and beautiful hardwood floors. NEW ROOF 2022! Both formals with french door open to an extra room that could be used as game room/office. Gorgeous chef\'s kitchen w/ granite countertops & ample cabinet space is open to the breakfast room and the large family room w/ cozy wood paneling and built ins. 3 bedrooms w/ 2 full baths downstairs; 3 bedrooms with a full bath upstairs. Big closets. Stunning sun room with 2 ceiling fans overlooking the backyard. Huge covered patio area. Selling as-is. Washer, dryer stay with the buyer. Easy access to major freeways, downtown, medical center, the Galleria. A must see!','0.2328','21','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Sharpstown Area','Central Gas','0','LT 4 & TR 3A BLK 7 SHARPSTOWN SEC 5','Corner,Subdivision Lot','10140','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','27 - Houston','NEFF ELEMENTARY SCHOOL','SHARPSTOWN HIGH SCHOOL','SUGAR GROVE MIDDLE SCHOOL','Supra Keybox','Seller','2','Traditional','Sharpstown Sec 05','6282','2.3307','Public Sewer,Public Water','1965','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','215685764','1675093497','215685764','2022-12-20T09:38:23.603','65523920','Cesar Espinoza','Equity Real Estate','','','29.780272','-95.393045','44','77007','4','1275000.00','Active','Columbia','515','Street','Houston','3','1','4','3100','Single-Family','A thoughtfully expanded and remodeled quintessential Historic Heights Dream Home with character and modern beauty that shines with an expansive living/dining room layout and lovely architectural details throughout that include hardwood floors, tall ceilings, handsome millwork, an exceptional gourmet kitchen with quartz island, and countertops, 5-burner gas cooktop, ovens/micro built-in. Additional features: abundant recessed lighting, plentiful built-ins, spacious first-floor primary suite w/ a spa-like bathroom, spacious bathroom, walk-in closet, and a secondary bedroom. This home has bright open spaces that separate the main living areas and bedrooms. The second floor offers a bedroom, office/studio, and a flex space ideal for another bedroom or game room. Situated on an expansive 6600 sq. ft. lot with enough room for a pool and a backyard. A superb location offering alley access through the garage. Easy access to the Hike & Bike trail & strolls through the tree-lined streets.','0.1515','9','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Heights/Greater Heights','Central Gas','0','LT 9 BLK 287 HOUSTON HEIGHTS','Subdivision Lot','6600','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','27 - Houston','HARVARD ELEMENTARY SCHOOL','HEIGHTS HIGH SCHOOL','HOGG MIDDLE SCHOOL (HOUSTON)','Appointment Required','Seller','2','Traditional','Houston Heights','10936','2.3307','Public Sewer,Public Water','1920','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','215705051','1675093497','215705051','2022-12-20T09:50:26.660','29108346','Becky Wied','Wied Realty','','','28.693227','-96.383891','23','77465','0','72500.00','Active','Red Snapper','161','Drive','Palacios','1','0','0','168','Single-Family','Move-in ready! Corner lot with circle drive. Metal cover, 2021 Kingsport 21\' travel trailer on pad, covered patio and separate storage building. Electricity, water and sewer installed. Come out and take a look at the Boca Chica community. Pool, playground, covered pavilion and boat ramp for property owners only. Everything you need to start enjoying the coastal life is waiting for you.','0.2','67','','','','','Sellers Disclosure','','','','','Central Electric','1','BOCA CHICA SEC. VI, LOT 76','Corner,Water View','9029','Appraisal District','','200','0','','0','','0','','','Electric Range','','Aluminum','156 - Palacios','CENTRAL ELEMENTARY SCHOOL (PALACIOS)','PALACIOS HIGH SCHOOL','PALACIOS JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,No Supra Keybox','Seller','1','Other Style','Boca Chica Sub Sec 6','265','1.8978','Public Sewer,Public Water','2021','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215751725','1675093497','215751725','2022-12-20T09:48:26.387','36840436','Bryan Bass','Texas Property Traders, INC','','','29.835361','-95.854436','14','77493','8','409814.00','Active','Bonita Beach','241','Drive','Katy','3','0','4','2321','Single-Family','The Chinook plan serves three bedrooms, three full bathrooms & an upstairs game room for the kids!','','25','CastleRock','','Electric Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','','','Katy - Old Towne','Central Gas','1','Lot 56, Block 1, Section 2','Subdivision Lot,Water View','5778','Survey','','1200','1','Never Lived In','2','Freestanding Oven','0','','','Freestanding Range','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','No Appointment Required','Builder','1.5','Traditional','Sunterra','','','Public Sewer,Water District','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','215753866','1675093497','215753866','2022-12-20T10:56:31.990','82289459','Manuel Molina','RE/MAX The Woodlands & Spring','','','30.257419','-95.521772','17','77384','7','349900.00','Active','Lake Crescent','14070','Drive','Conroe','2','0','4','1869','Single-Family','BEAUTIFUL 1 STORY THAT OFFERS 4 BEDROOMS, LG OPEN KITCHEN W/LARGE ISLAND. PRIMARY SUITE HAS A PRIVATE HALLWAY. THIS HOME SITS ON ONE OF THE LARGEST HOMESITES IN NEIGHBORHOOD. CONROE SCHOOL DISTRICT BUT ZONED FOR WOODLANDS SCHOOLS. COME CHECK IT OUT!!! THE NEIGHBORHOOD OFFERS COMMUNITY POOL, LODGE TO RENT OUT FOR YOUR SPECIAL EVENTS AND A HUGE PLAYGROUND. SIDE WALKS THRU OUT COMMUNITY AS WELL.','0.2035','15','DR Horton','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','0','Conroe Southwest','Central Gas','1','S516408 - FOSTERS RIDGE 08, BLOCK 2, LOT 18','Cleared,Subdivision Lot','8864','Appraisal District','','850','0','','2','Gas Oven','0','','','Gas Range','','Composition','11 - Conroe','BUSH ELEMENTARY SCHOOL (CONROE)','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Fosters Ridge 08','9165','3.1488','Public Sewer,Public Water,Water District','2018','Appraisal District'); --> New record created successfully