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-08-20T09:07:51.433' ,`MLSNumber` = '40694365' ,`ListAgentFullName` = 'Lorena Janik' ,`ListOfficeName` = 'RE/MAX Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.202297' ,`Longitude` = '-96.271059' ,`PhotoCount` = '21' ,`PostalCode` = '77437' ,`RoomCount` = '3' ,`ListPrice` = '205000.00' ,`Status` = 'Active' ,`StreetName` = 'Merchant' ,`StreetNumber` = '608' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2194' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the heart of El Campo. This move in ready three bedroom and two bathroom home has been updated in the kitchen and bathrooms along with new flooring and a fresh coat of paint on the inside and outside. Has a huge gaming room as well as plenty of storage. Come and see for yourselves.' ,`Acres` = '0.1607' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LUNDY CENTRAL BLOCK 2 LOT 11A,12A Acres:0.1607' ,`LotDesciption` = 'Corner' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Left Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lundy Central' ,`TaxAmount` = '3541' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1939' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700907' WHERE `Matrix_Unique_ID` = '205179413' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T09:26:24.070' ,`MLSNumber` = '20272109' ,`ListAgentFullName` = 'Tahira Syed' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.712328' ,`Longitude` = '-95.420811' ,`PhotoCount` = '9' ,`PostalCode` = '77005' ,`RoomCount` = '9' ,`ListPrice` = '2699000.00' ,`Status` = 'Active' ,`StreetName` = 'Barbara' ,`StreetNumber` = '2715' ,`StreetSuffix` = 'Lane' ,`City` = 'West University Place' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4645' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sophisticated & Timeless... Located in the most coveted Pemberton section of West U, 2715 Barbara Lane is an architectural masterpiece (to be built by Detamore Development Team) that allows maximum indoor/outdoor spaces for comfortable living and entertainment. A stylish and welcoming home for those who are drawn to refined luxury yet embrace the warm and functional spaces. This open concept 4 bedrooms and 4.5 bath residence will feature a seamless flow between the indoors and outdoors allowing effortless entertainment. The living room and kitchen will feature a wall of windows and steel doors leading to the outdoor veranda and backyard! Tucked in the heart of West University Place, walking distance Rice Village restaurants and shops! This home will be STUNNING!' ,`Acres` = '0.1515' ,`Area` = '17' ,`BuilderName` = 'Detamore Development' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 7 & 8A BLK 7 PEMBERTON' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Pemberton' ,`TaxAmount` = '22147' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700907' WHERE `Matrix_Unique_ID` = '208145573' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T09:14:37.757' ,`MLSNumber` = '55378873' ,`ListAgentFullName` = 'Jessica Escamilla' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.751656' ,`Longitude` = '-95.387683' ,`PhotoCount` = '45' ,`PostalCode` = '77006' ,`RoomCount` = '8' ,`ListPrice` = '429900.00' ,`Status` = 'Active' ,`StreetName` = 'Bomar' ,`StreetNumber` = '536' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2360' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Roof 7/22! Absolutely wonderful, freestanding townhome, well-located on tree-lined street and so convenient to everything Midtown has to offer! This stunning 3 story home is in a premium Midtown location within walking distance to trendy restaurants, entertainment, coffee bars and Buffalo Bayou Park. Shaded street with the walkability like no other. Upon entering the door, you will be greeted by the warmth of this architecturally inspired home. This end unit home offers an abundance of natural light. Balcony off the kitchen area for your morning coffee or afternoon wine. Home needs some stucco work. Seller has estimate. Otherwise home is in great shape. Make an offer.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 1 MILLENNIUM HOMES ON BOMAR AVE' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '1694' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1530' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WILLIAM WHARTON K-8 DUAL LANGUAGE ACADEMY' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'GREGORY-LINCOLN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Lockbox Right Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Millennium Homes On Bomar' ,`TaxAmount` = '8475' ,`TaxRate` = '2.55896' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700907' WHERE `Matrix_Unique_ID` = '209467582' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T08:48:41.263' ,`MLSNumber` = '57916900' ,`ListAgentFullName` = 'Nicole Howard Curette' ,`ListOfficeName` = 'Dream Maker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835191' ,`Longitude` = '-95.767531' ,`PhotoCount` = '25' ,`PostalCode` = '77449' ,`RoomCount` = '9' ,`ListPrice` = '398000.00' ,`Status` = 'Active' ,`StreetName` = 'Theodoli' ,`StreetNumber` = '22624' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2775' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous barely lived in home ready for new owners to make tons of memories! Kitchen is open to dining and living room. This is a great space for entertaining or just relaxing! Primary bedroom and 1 extra room down stairs. Inviting game room and 3 other bedrooms up! Don\'t let this gem of a home get by you! All appliances stay with the home!' ,`Acres` = '0.1621' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 VENTANA LAKES EAST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7061' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ventana Lks East Sec 2' ,`TaxAmount` = '8672' ,`TaxRate` = '3.2357' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663700907' WHERE `Matrix_Unique_ID` = '209763432' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T09:23:08.713' ,`MLSNumber` = '53801159' ,`ListAgentFullName` = 'Sharon Teare' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.677116' ,`Longitude` = '-95.004814' ,`PhotoCount` = '32' ,`PostalCode` = '77351' ,`RoomCount` = '5' ,`ListPrice` = '189000.00' ,`Status` = 'Active' ,`StreetName` = 'Gwendolyn' ,`StreetNumber` = '202' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lake Livingston Beauty!!! Almost NEW 2020 Built Home on 3 FULL LOTS!!! +/- 1/2 Acres!! Island Kitchen with Tons of Beautiful Cabinets! Amazing Open Floor Plan with 3 bedrooms and 2 full bathrooms! Primary Bedroom Suite has large walk-in Closet and double sinks in Bathroom. The 2 additional bedrooms are separate from the primary bedroom for added privacy, with washer dryer just down the hall. Spacious Open Floor plan is beautifully decorated and feels brand new! Custom Built covered Front Porch for enjoying the outside as much as the inside! New Storage building with lofts can be included with acceptable offer!! Community Boat Ramp is available for launching your boat. Enjoy all that beautiful Lake Livingston has to offer down the road. Community Center building next door is available for private get togethers and family events. Reach out today for your private showing and make this beautiful home yours!!' ,`Acres` = '0.46' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PUTNAMS LANDING SECTION 3 LOT 7 SERIAL# 025000HA000157A HUD#' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '20250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '45' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Putnams Landing Sec 3' ,`TaxAmount` = '1027' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700907' WHERE `Matrix_Unique_ID` = '210227026' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T08:09:42.893' ,`MLSNumber` = '67524951' ,`ListAgentFullName` = 'Jennifer Hartmann' ,`ListOfficeName` = 'Hartmann Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.502387' ,`Longitude` = '-95.853484' ,`PhotoCount` = '28' ,`PostalCode` = '77471' ,`RoomCount` = '7' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Sims' ,`StreetNumber` = '4211' ,`StreetSuffix` = 'Road' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1807' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COME HOME TO A SLICE OF THE GOOD LIFE IN THIS WONDERFUL COUNTRY PROPERTY!!! Just a mile+ from Highway 59 makes this a desirable location for those commuters working in city but wanting to come home to the country. Located on almost 4 acres, the home has been recently updated and square footage added and is bricked on all 4 sides. Tasteful extras like the addition of a kitchen island, granite counters in kitchen and baths, hickory wood and marble tile flooring, plantation shutters, some double pane windows, fireplace made of lava rock, cultured marble shower in primary bath and a 30X34 insulated garage with 12\' doors....one of which is power operated.....and a climate controlled 10X10 storage room. One overhead door opens to rear. Barns with stalls and water runs to each. You will spend countless HOURS enjoying the south breezes on your 14 x 26 covered patio with 3 ceiling fans for added cooling. Mature fig trees, Jack oaks & LOTS of room for a country garden. DON\'T MISS!!!' ,`Acres` = '3.9386' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'COTTONWOOD MEADOWS SEC 1, LOT 1 (PT), ACRES 3' ,`LotDesciption` = 'Wooded' ,`LotSize` = '171565' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BEASLEY ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'TERRY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO/GEORGE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cottonwood Meadows Sec 1' ,`TaxAmount` = '9' ,`TaxRate` = '1.7948' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700907' WHERE `Matrix_Unique_ID` = '211447233' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T08:08:44.180' ,`MLSNumber` = '94792433' ,`ListAgentFullName` = 'Natalie Sloan' ,`ListOfficeName` = 'Styled Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.917330' ,`Longitude` = '-95.089319' ,`PhotoCount` = '25' ,`PostalCode` = '77532' ,`RoomCount` = '6' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'River Wood' ,`StreetNumber` = '16643' ,`StreetSuffix` = 'Court' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2111' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready for immediate move in, this charming home offers the opportunity for easy living in the popular Newport neighborhood, located on a quiet cul-de-sac, the home has been tastefully updated with new flooring, beautiful granite countertops, fresh paint, new hardware. 3 bedrooms/2 baths plus an additional open room for a playroom/office. Open design concept with gas fireplace in family room, kitchen with generous cabinet space, an island bar for informal meals and a separate dining area. Ceiling fans remain as well as washer/dryer set up.\r\nThe home is fully fenced and offers a generous, extended drive that will accommodate additional vehicles/golf carts. Newport is an established neighborhood that offers convenient access to Lake Houston, pools, area playgrounds, golf course, tennis courts, hike and bike trails. Make your appointment today to see this lovely property.' ,`Acres` = '0.1754' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 1 SEVEN OAKS NORTH AMEND' ,`LotDesciption` = 'Cleared,In Golf Course Community,Subdivision Lot' ,`LotSize` = '7642' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Seven Oaks North 1' ,`TaxAmount` = '5967' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700907' WHERE `Matrix_Unique_ID` = '211647066' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T09:04:32.727' ,`MLSNumber` = '38425686' ,`ListAgentFullName` = 'Usman Toor' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.573261' ,`Longitude` = '-95.601752' ,`PhotoCount` = '32' ,`PostalCode` = '77479' ,`RoomCount` = '5' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Mesquite' ,`StreetNumber` = '3406' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2375' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two story home in a First Colony area! beautiful home located in the subdivision of Austin Park, only a few minutes from the town center of Sugar Land. open floor plan concept with a formal living area, a formal dining, a large family room, and a bonus/game area upstairs. The primary bedroom located on the first floor, home have 3 bedrooms and 2.5 bath, call today for more details!!!' ,`Acres` = '0.1907' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AUSTIN PARK SEC 1, BLOCK 1, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8306' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '795' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SETTLERS WAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Austin Pk' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663700908' WHERE `Matrix_Unique_ID` = '211647796' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T09:17:40.907' ,`MLSNumber` = '52727722' ,`ListAgentFullName` = 'Emily Wang' ,`ListOfficeName` = 'Intown Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.817879' ,`Longitude` = '-95.509207' ,`PhotoCount` = '10' ,`PostalCode` = '77080' ,`RoomCount` = '6' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = 'West Kolbe' ,`StreetNumber` = '2421' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2110' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'URBAN FARMHOUSE COURTYARD HOME w/ Tons of OUTDOOR SPACE: a 45 FT Long Private FENCED IN YARD, 100 SF+ Living Room Balcony BEING BUILT in KOLBE FARMS, a 40 Acre Community that is NOT COOKIE CUTTER: OVER 100 Different Home Designs so Far! AMENITIES - 3 Acre Lake/Park, Pools (Main & Kids), Trails, Dog Park, Courtyards, Gated (Gate Station Manned at Night). Love Openness and Light? 2421 West Kolbe is a courtyard hard home adjacent to the easement that has the Spring Branch Bike Trail. You will love the living room: 12 FT Soaring Ceilings, Fantastic Island Kitchen w/ Soft Close Cabinets, 5 Piece Bosch Kitchen Appliances (5 Burner Gas Cooktop), Double Crown Molding. But what makes it so great are the TRIPANELED SLIDING GLASS DOORS that lead out to a courtyard side FANTASTIC BALCONY! Primary Bedroom has Vaulted Ceilings and Wide Plank Wood Floors. Primary Bathroom has FREE STANDING TUB, Split Vanities, Seated Shower. Home is estimated to be finished by End of the Year.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'InTown Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14, BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2091' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'EDGEWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Kolbe Farms' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700908' WHERE `Matrix_Unique_ID` = '211648002' --> Updated record success