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` = '2023-01-02T15:33:08.163' ,`MLSNumber` = '40865768' ,`ListAgentFullName` = 'Zaira Maxwell' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.776372' ,`Longitude` = '-94.933173' ,`PhotoCount` = '19' ,`PostalCode` = '77521' ,`RoomCount` = '10' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Park Shadow' ,`StreetNumber` = '4520' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2746' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifull corner lot, open living area with high ceilings that open to breakfast room- formal dining, master down, game room up-Plantation shutters in living room and master. Amazing landscape and best school district in Baytown. Near great shopping and entertainment. \r\nSelling as is.' ,`Acres` = '0.2336' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 2 PARKWOOD PLACE SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '10176' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Parkwood Place Sec 02' ,`TaxAmount` = '7757' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098933' WHERE `Matrix_Unique_ID` = '206283755' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T15:33:41.093' ,`MLSNumber` = '2779878' ,`ListAgentFullName` = 'Janet Vittur' ,`ListOfficeName` = 'Texas All American Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.961563' ,`Longitude` = '-95.162187' ,`PhotoCount` = '30' ,`PostalCode` = '77044' ,`RoomCount` = '11' ,`ListPrice` = '564900.00' ,`Status` = 'Active' ,`StreetName` = 'Turn Point' ,`StreetNumber` = '13706' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3489' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Simply GORGEOUS describes this LOVELY home. The large culdesac lot features gated access to the park area and walking trail. One side of the lot is ajoined by a natural habitat that is protected by the government,thus having only one neighbor. The home offers 4 bedrooms, 3 1/2 baths, a game room and media room. The seller has installed a beautiful custom build patio cover and swimming pool to enjoy friends and family times.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'PERRY HOMES' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 3 LAKESHORE SEC 10' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11754' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '740' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'LAKESHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeshore Sec 10' ,`TaxAmount` = '9695' ,`TaxRate` = '3.46234' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098933' WHERE `Matrix_Unique_ID` = '207038769' --> 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','208572426','1675098934','208572426','2023-01-02T15:12:28.187','68706654','Amanda Martin','AM Real Estate Group, LLC','','','29.452928','-95.305493','41','77511','9','379000.00','Active','Bordeaux','23122','Drive','Alvin','2','1','4','2595','Single-Family','Relax & unwind in your new home on Bordeaux Drive...Come tour this spaciously divine 4/2.5/3 with exterior hues of your fav red wine in the beautiful, gated community of Marthas Vineyard. This home has is it ALL from granite countertops, undercabinet lighting, high ceilings, formal dining, media room, & flex room. As cost-of-living continues to soar, you\'ll appreciate the MANY cost & energy efficiency features offered such as Honeywell programmable thermostat, 16 Seer HVAC, Radiant barrier, LowE windows & Pex plumbing. Seller upgrades include 18x40 built to last attached outdoor patio,(windstorm cert.) great for entertaining. Neighborhood parking can often be scarce, the driveway extension allows for a full 3-car driveway instead of the traditional two, never worry about outages due to hurricane season or past freezes again, the NEWLY INSTALLED 20K CUMMINGS whole home generator will ensure peace of mind for your family. Call & schedule your showing TODAY!','0.1653','5','Anglia','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Alvin North','Central Gas','1','MARTHAS VINEYARD SEC 1 (A0230 HT&BRR) BLK 2 LOT 10','Subdivision Lot','7200','Appraisal District','','550','0','','3','Gas Oven','0','','','Gas Range','','Composition','3 - Alvin','HOOD-CASE ELEMENTARY SCHOOL','ALVIN HIGH SCHOOL','G W HARBY J H','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Traditional','Marthas Vineyard Sec 1','10690','3.7074','Public Sewer,Public Water','2020','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T16:34:40.857' ,`MLSNumber` = '82469066' ,`ListAgentFullName` = 'Tammy Petterson' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.572852' ,`Longitude` = '-95.132819' ,`PhotoCount` = '32' ,`PostalCode` = '77062' ,`RoomCount` = '10' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Diana' ,`StreetNumber` = '15303' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2155' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 15303 Diana Lane! Enjoy your own peace of paradise on Exploration Green! This charming 4 bed, 2 bath home features an awesome floor-plan, and sits on an oversized-lot with open views of green space - no back neighbors! Beautiful landscaping for great curb appeal, flagstone patio and separate sitting area in the back. Inside features defined spaces for a Home Study with French doors, formal Dining with pocket doors, Family Room, Breakfast Area, and a separate nook with bay window that could function as another Home Office. Vaulted ceiling and fireplace in the Family Room, Island kitchen with Corian countertops, stainless steel appliances, gas stove, 42\" cabinets, pots and pan drawers and pull-outs throughout! 4 bedrooms completely isolated from the Living Areas for added privacy, 2 full baths, French doors from the primary open to the back patio. Foundation Work is needed for this home - quote from Allied Foundation available. Beautiful potential!' ,`Acres` = '0.2204' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Probate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 CLEAR LAKE CITY CORE B SEC 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'CLEAR LAKE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'CLEARLAKE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Lake City Core B Sec 01' ,`TaxAmount` = '5936' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098934' WHERE `Matrix_Unique_ID` = '208610955' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T15:20:24.237' ,`MLSNumber` = '51119163' ,`ListAgentFullName` = 'Velma Ellison' ,`ListOfficeName` = 'Alliance Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.961698' ,`Longitude` = '-95.019136' ,`PhotoCount` = '50' ,`PostalCode` = '77532' ,`RoomCount` = '6' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Lord' ,`StreetNumber` = '4249' ,`StreetSuffix` = 'Road' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2146' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '8.949 acres, fenced and cross fenced. Updated Country Home with spacious covered front and back porches. Oversized detached garage with covered breezeway. 1200 sq ft shop and 1500 sq ft equipment shed. Low taxes, nice mature shade trees. Well and septic. Outbuildings, chicken pens, Barn. Come live the country life.' ,`Acres` = '8.949' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '(part of) TRS 2A 2B 2K 2K-1 & 2K-2 ABST 1336 HT&BRR CO SEC 4' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '389818' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'BARRETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'N/A' ,`TaxAmount` = '7654' ,`TaxRate` = '2.0943' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1938' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098934' WHERE `Matrix_Unique_ID` = '209547854' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T16:54:12.900' ,`MLSNumber` = '19649579' ,`ListAgentFullName` = 'Patrick Poteet' ,`ListOfficeName` = 'Patrick Poteet Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.697052' ,`Longitude` = '-96.781145' ,`PhotoCount` = '18' ,`PostalCode` = '78962' ,`RoomCount` = '8' ,`ListPrice` = '142900.00' ,`Status` = 'Active' ,`StreetName` = 'South' ,`StreetNumber` = '106' ,`StreetSuffix` = 'Street' ,`City` = 'Weimar' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2766' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just Reduced $50k….This giant custom-built home is ready for a new updated look. The home sits on almost an acre, you can tell it was a real looker at one time but needs a total makeover, just lipstick probably won\'t get it. For all those owner investors looking for the next project, here it is. There also may be an opportunity to add a couple more houses to the adjacent land or even a small multi-family. The property has full city utilities including gas.' ,`Acres` = '0.967' ,`Area` = '56' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A-4 H AUSTIN BLK 104 WEIMAR .967 AC HOUSE & BLDGS' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '42123' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '203 - Weimar' ,`SchoolElementary` = 'WEIMAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEIMAR HIGH SCHOOL' ,`SchoolMiddle` = 'WEIMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Weimar' ,`TaxAmount` = '3489' ,`TaxRate` = '1.9586' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098934' WHERE `Matrix_Unique_ID` = '209753484' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T15:17:22.533' ,`MLSNumber` = '25661794' ,`ListAgentFullName` = 'Reecie Meeker' ,`ListOfficeName` = 'Cobb Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.425087' ,`Longitude` = '-94.683435' ,`PhotoCount` = '49' ,`PostalCode` = '77650' ,`RoomCount` = '6' ,`ListPrice` = '720000.00' ,`Status` = 'Active' ,`StreetName` = 'Atkinson' ,`StreetNumber` = '455' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1845' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new resort paradise. Spacious custom 3 bedroom, 2.5 bath on an oversized lot. 4 car garage, outdoor kitchen, new flooring, wood burning stove. Solar panels. Too many features to list. See attached document. Open concept with large living/dining/kitchen area is an entertainers dream. Knotty pine ceiling and walls, plenty of closet space, each closet is cedar lined. Spacious kitchen features granite, plenty of counter seating, in addition to dining table. Butler\'s pantry has extra counter space and more cabinets. Step outside to the bar area, outdoor kitchen, wrap around deck for easy maintenance. Master Suite has en suite bath with shower and double walk in closets. Separate access from master suite to balcony. One Guest bedroom has 4 bunks and the other guest bedroom has a Murphy Bed. Come see this beauty today!' ,`Acres` = '0.5006' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 203 PAGE 14 W 1/2 OF LOT 6 (6-2) ED MILLER UNRECORDED S' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '21804' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Miller Ed Unrec' ,`TaxAmount` = '9078' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098934' WHERE `Matrix_Unique_ID` = '211089349' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T15:09:18.930' ,`MLSNumber` = '35186139' ,`ListAgentFullName` = 'Raquel Ginebra' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.018993' ,`Longitude` = '-95.460036' ,`PhotoCount` = '38' ,`PostalCode` = '77090' ,`RoomCount` = '11' ,`ListPrice` = '359500.00' ,`Status` = 'Active' ,`StreetName` = 'Anvil' ,`StreetNumber` = '17406' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3358' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly updated home! Beautiful modern look with an open concept floor plan. New luxury laminate vinyl plank flooring, new cabinets, and new granite! Gorgeous on the exterior as well as inside. You will not want to miss this Houston gem!' ,`Acres` = '0.3782' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 10 PONDEROSA FOREST SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '16475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '749' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PONDEROSA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ponderosa Forest Sec 02' ,`TaxAmount` = '5542' ,`TaxRate` = '2.4101' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098935' WHERE `Matrix_Unique_ID` = '211737617' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T16:03:14.590' ,`MLSNumber` = '82037200' ,`ListAgentFullName` = 'Michelle Whitecotton' ,`ListOfficeName` = 'Markham Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.654652' ,`Longitude` = '-95.540669' ,`PhotoCount` = '44' ,`PostalCode` = '77340' ,`RoomCount` = '10' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Azalea' ,`StreetNumber` = '2015' ,`StreetSuffix` = 'Circle' ,`City` = 'Huntsville' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Modern, stylish, and premier location. Brick exterior, 4 bedroom 3 1/2 bath, located on an oversized corner lot in the sought after Elkins Lake subdivision. From the moment you walk through the front door, you will fall in love with all the custom details this home has to offer. From the ornate chandelier in the dining room to the antique island in the kitchen, these owners thought of it all. Featuring a free flowing floor plan, granite countertops, hard wood floors, plantation shutters, Viking appliances, and built-ins galore. Complete with home generator, 2 Ac units, 2 hot water heaters, wrought iron fence, and raised garden area. Finally, enjoy your cabana-like patio as you relax in the spa or entertain your guests in your spacious backyard. Don\'t miss the rare opportunity to call this one home!' ,`Acres` = '0.4897' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ELKINS LAKE - SEC 3A, BLOCK 35, LOT 14' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '21331' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '208' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'ESTELLA STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elkins Lake' ,`TaxAmount` = '8626' ,`TaxRate` = '1.9609' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098935' WHERE `Matrix_Unique_ID` = '211778335' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T16:47:12.600' ,`MLSNumber` = '98094313' ,`ListAgentFullName` = 'Uriel Rodriguez' ,`ListOfficeName` = 'Realty World Elite Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.666243' ,`Longitude` = '-95.230169' ,`PhotoCount` = '48' ,`PostalCode` = '77587' ,`RoomCount` = '4' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'N 3rd St' ,`StreetNumber` = '109' ,`StreetSuffix` = '' ,`City` = 'South Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction 3 story home located in South Houston Gardens. First floor features a large walk-in Laundry room with electric water heater & gas connections. A study/office flex room with ceramic tile flooring along with a 3 car garage. The primary bedroom with Full bath is located in the second floor with an open living area and open kitchen. Gas stove, microwave and refrigerator included, Ceramic tile and vinyl plank flooring including a half bath. Third floor features three bedrooms along with jack n jill bathroom. An outside balcony area great for morning coffee and grabbing fresh air. Home includes recess lighting, vinyl flooring, natural woods stairs, double pane windows and crystal chandeliers. Come out and check it out Today!' ,`Acres` = '' ,`Area` = '6' ,`BuilderName` = 'Del Rio Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'South Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 99 (MORRIS) SOUTH HOUSTON GARDENS SEC 1 PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'SOUTH HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHHOUSTON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'South Houston Gardens' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098935' WHERE `Matrix_Unique_ID` = '212021085' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T15:39:49.117' ,`MLSNumber` = '2287304' ,`ListAgentFullName` = 'Kenny Hunt' ,`ListOfficeName` = 'Nuvilla Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.088395' ,`Longitude` = '-95.279878' ,`PhotoCount` = '34' ,`PostalCode` = '77541' ,`RoomCount` = '4' ,`ListPrice` = '329990.00' ,`Status` = 'Active' ,`StreetName` = 'Redfish' ,`StreetNumber` = '239' ,`StreetSuffix` = 'Drive' ,`City` = 'Freeport' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1570' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated, water front 4 bed, 3 bath home with a split floor that would be great for weekend get-away\'s! All new appliances, interior finishes and bulkhead. You will love both of the spacious wrap around porches and covered patio area overlooking the water. There is also a private community pool and boat ramp. Bastrop Marina is minutes away and Surfside beach is roughly a 15 minute drive. Call today to setup your private showing!' ,`Acres` = '0.1033' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'DEMIJOHN ISLAND SEC 1 (A0157 G M BRYAN) LOT 22' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Demijohn Island Sec 1' ,`TaxAmount` = '3675' ,`TaxRate` = '2.3589' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098935' WHERE `Matrix_Unique_ID` = '213115299' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T15:47:10.790' ,`MLSNumber` = '87712582' ,`ListAgentFullName` = 'Debbie Corder' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.403404' ,`Longitude` = '-95.092286' ,`PhotoCount` = '26' ,`PostalCode` = '77510' ,`RoomCount` = '7' ,`ListPrice` = '564900.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 646' ,`StreetNumber` = '2710' ,`StreetSuffix` = 'Road' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country living at it\'s best!! Beautifully updated 3/4 bedroom 2 bath home on 4.7 manicured acres in the heart of Santa Fe. Home features open living areas with with center set fireplace with blower for additional heating in the winter. Gorgeous kitchen with quartz countertops and eat in bar with contemporary swivel bar stools. Primary suite with walk-in closet and oversized spa like shower. All bedrooms have walk-in closets. A/C, Appliances, and much more new in 2018. Property zoned residential/commercial' ,`Acres` = '4.7179' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 1 PAGE 9 N 1/2 OF LOT 51 (51-1) THAMANS 1ST SUB' ,`LotDesciption` = 'Wooded' ,`LotSize` = '205512' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'WILLIAM F BARNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Thamans 1st Sub' ,`TaxAmount` = '5399' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098936' WHERE `Matrix_Unique_ID` = '213574370' --> 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','215219136','1675098936','215219136','2023-01-02T15:29:33.043','44341390','Elias Guzman','Nexus One Properties','','','29.837004','-95.789758','23','77493','8','305000.00','Active','Aversa','4419','Drive','Katy','2','0','3','1685','Single-Family','This stunning home offers 3 bedrooms, 2 baths and an attached 2 car garage. Built in 2016, all major structural items are only 6 years old! Enjoy A+ curb appeal with a brick elevation. double pane windows. High ceilings & neutral tile floors throughout. kitchen that features granite, SS appliances, a gas range stove & beautiful espresso cabinetry. The spacious dining room connects to the Butler’s Pantry. huge walk-in closet. covered patio that overlooks the large green space . Hurry, this move-in-ready gem won’t last long!','0.1492','25','','','','','Sellers Disclosure','','','','Katy - North','Central Gas','1','LT 27 BLK 1 VENTANA LAKES SEC 9','Cleared','6500','Appraisal District','','850','0','','2','','0','','','','','Composition','30 - Katy','BETHKE ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','STOCKDICK JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Ventana Lakes Sec 9','7728','3.2768','Water District','2016','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','215440504','1675098936','215440504','2023-01-02T15:01:04.113','93221254','Pamela Eppes','Century 21 Realty Partners','','','30.238130','-95.575671','49','77354','14','849000.00','Active','Brown Bark','6710','','Magnolia','4','1','5','5352','Single-Family','Great Family Home! 5 bedrooms,3.5 bathrooms all on 2.5 Acres in Ridgewood Subdivision. French doors at entry will lead to a private study with lots of built-ins. Formal dining for all your family gatherings. Large family room with gas fireplace opens to the kitchen. The kitchen boasts granite countertops, custom cabinetry, a butler\'s pantry, Viking gas stove, and a walk-in pantry. The primary suite features 2 large walk-in closets, a slate shower, and jetted tub, a sitting area, and great view of the backyard! Upstairs you will find a custom game room, bar, and balcony for all your entertaining, a media room, and 4 secondary bedrooms! There is a garage apartment that features a 22x15 living area, full bath, and 12 x12 bedroom! Great for extended guests, Airbnb or rental! Extended driveway and fenced backyard. New Roof!','2.5','15','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','1','Gaslog Fireplace','1','Magnolia/1488 East','Central Gas','0','S827300 - RIDGEWOOD 01, LOT 43, ACRES 2.5','Cleared,Subdivision Lot','108900','Appraisal District','','','0','','3','Freestanding Oven,Gas Oven','0','','','Electric Cooktop','','Composition','36 - Magnolia','TOM R. ELLISOR ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Accompany,Leave Business Card','Appraisal District','2','Traditional','Ridgewood 01','14657','1.8587','Aerobic,Public Water','2009','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','215573696','1675098936','215573696','2023-01-02T15:10:45.540','45696118','Ray Faragher','Clearview Real Estate, LLC','','','30.392828','-95.611742','50','77356','9','425000.00','Active','Glenforest','3243','Road','Montgomery','3','1','4','2439','Single-Family','Very nice 4 bedroom, 3.5 bath home with an oversize 3 car garage, and fenced yard located on a culdesac within Walden. 3 car garage was enlarged/added onto, and there is a pass-through door on the third bay that leads to the backyard directly behind. Garage floor was also coated, and there are lots of storage racks & cabinets installed. Home is on a nice level lot, with plenty of room for a pool if desired; stone & brick exterior looks great, and makes for low maintenance! Inside the formal dining has beautiful hardwood flooring & crown moulding. High ceilings & lots of windows in the living area let in plenty of natural light, and the living room is open to the kitchen. Kitchen has granite counters, & stainless appliances. Master bedroom is located downstairs, gameroom/second living area is up. Ceiling Fans, 2\'\' faux wood blinds throughout the home. Auto sprinklers cover all areas of the yard, and the backyard is fully fenced. Rain-gutters with leaf guards and eave down-lighting..','0.1798','39','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Lake Conroe Area','Central Electric','1','WALDEN 08, BLOCK 23, LOT 20','Cul-De-Sac,In Golf Course Community,Subdivision Lot','7831','Appraisal District','','1150','0','','3','Electric Oven','0','','','Electric Range','','Composition','37 - Montgomery','MADELEY RANCH ELEMENTARY SCHOOL','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Walden 08','6413','2.2242','Water District','2017','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','215687861','1675098936','215687861','2023-01-02T15:43:01.383','44557453','Denise McLarty','Coldwell Banker Realty','','','29.544274','-95.671116','46','77479','9','515000.00','Active','Summer','1307','Brook','Sugar Land','3','0','4','2927','Single-Family','Stunning 4 bedroom 3 bath home located in the desirable Greatwood neighborhood. This tastefully remodeled home has a Main floor with Spacious rooms, high ceilings and lots of Natural light. New Porcelain tile throughout most of the first floor. The updated Fireplace has gas logs and is perfect for enjoying cozy evenings! The Chef\'s dream kitchen boasts quartz countertops and lots of counterspace! The Primary bedroom is elegant, spacious, and has a view of the Sparkling pool. spa, and stone waterfall. There is a 2ND Guest suite downstairs - perfect for visiting guests. Game room and secondary bedrooms are upstairs. Unique lot located next to greenbelt allows easy access to walking and biking trails, and offers no next door neighbor. Updates include Tile porcelain floors, Calcutta Quarts and marble countertops, updated appliances, new carpet upstairs and Primary bedroom, and designer paint colors and light fixtures. Gutters were also recently added. This one is truly MOVE IN Ready!','0.1873','30','','','','','Levee District,Sellers Disclosure','1','Gaslog Fireplace','2','Sugar Land West','Central Gas','1','GREATWOOD BEND SEC 1, BLOCK 2, LOT 1','In Golf Course Community,Subdivision Lot','8160','Appraisal District','','910','0','','','','1','In Ground','','','','Composition','33 - Lamar Consolidated','DICKINSON ELEMENTARY SCHOOL (LAMAR)','GEORGE RANCH HIGH SCHOOL','RYON/READING JUNIOR HIGH SCHOOL','Appointment Required','Appraisal','2','Traditional','Greatwood Bend','8605','2.3013','Public Sewer,Public Water','1995','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','215979838','1675098936','215979838','2023-01-02T15:02:54.013','22762108','Nikiesha Scott','Legacy Homes & Properties, LLC','','','30.809479','-94.336872','32','75979','6','100000.00','Active','County Road 4050','221','','Woodville','1','1','3','1352','Single-Family','Sitting on just over an acre of land this home has 3 bedrooms and 1.5 bathrooms. The living room, dining room and kitchen are all open to each other making it the perfect space to gather with family. It has been vacant for a bit and is waiting for someone to put some TLC into it and make updates for their family or even use it as an investment property to lease to tenants. No HOA and NO RESTRICTIONS! Home is not new construction. Buyer and buyer\'s agent to verify all info. For more information or to schedule your own private tour reach out to the listing agent!','1.0238','48','','','','','Sellers Disclosure','','','','Tyler County','Window Unit','0','S3450 LINCOLN ACRES (A504), LOT 30, ACRES 1.0238','Other','44597','Appraisal District','','','0','','0','','0','','','','','Composition','253 - Woodville','WHEAT ELEMENTARY SCHOOL','WOODVILLE HIGH SCHOOL','WOODVILLE MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Other Style','Lincoln Acres','1482','2.0543','Septic Tank','1352','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','215993675','1675098936','215993675','2023-01-02T15:36:22.453','76329525','Bintuan Zhu','Great Wall Realty, LLC','','','29.685615','-95.480239','15','77096','9','448000.00','Active','Grape','5415','Street','Houston','2','0','4','2017','Single-Family','Never flooded. Masterful renovation. Massive living areas in this home are highlighted with brand new energy-efficient windows plus recessed lighting. Features include wood floors, new trim and doors, gourmet kitchen cabinets with pantry, Quartz countertops, modern island, Stainless Steel appliances, new water heater, new PEX water pipe, new AC duct and new insulation. The open concept living is perfect for entertaining. Conveniently located minutes from Texas Medical Center, galleria mall, exemplary elementary school, and Bellaire high school. Newly additional 320 sqft building in backyard with ACcan be use as a gym, or play area. This make total area 2337 sqft.','0.1894','20','','','','','Owner/Agent,Sellers Disclosure','1','','','Meyerland Area','Central Gas','0','LT 7 BLK 7 BRAES VIEW TERRACE','Other','8250','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','27 - Houston','HEROD ELEMENTARY SCHOOL','BELLAIRE HIGH SCHOOL','FONDREN MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Braes View Terrace','8854','2.5304','Public Sewer,Public Water','1960','Appraisal District'); --> New record created successfully