Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>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)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T17:26:11.820' ,`MLSNumber` = '5413499' ,`ListAgentFullName` = 'Ngoc Estello' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.015215' ,`Longitude` = '-95.623090' ,`PhotoCount` = '33' ,`PostalCode` = '77377' ,`RoomCount` = '9' ,`ListPrice` = '409900.00' ,`Status` = 'Active' ,`StreetName` = 'Eagle Ledge' ,`StreetNumber` = '17222' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2862' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful 4 bed 3.5 bath home in Village Creek! This is a highly desirable neighborhood with an excellent school district. This home features beautiful floors, tall ceilings with large windows with an upstairs game room. There are 2 brand new water heaters and new AC unit.' ,`Acres` = '0.185' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 2 VILLAGE CREEK SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8059' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '759' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'WILLOW CREEK ELEMENTARY SCHOOL (TOMBALL)' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Creek Sec 04' ,`TaxAmount` = '8477' ,`TaxRate` = '2.7564' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704124' WHERE `Matrix_Unique_ID` = '207358128'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T16:38:29.213' ,`MLSNumber` = '87229617' ,`ListAgentFullName` = 'Adrian Stephens' ,`ListOfficeName` = 'RE/MAX  All Stars' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.792797' ,`Longitude` = '-95.102316' ,`PhotoCount` = '47' ,`PostalCode` = '77360' ,`RoomCount` = '10' ,`ListPrice` = '1275000.00' ,`Status` = 'Active' ,`StreetName` = 'Shady' ,`StreetNumber` = '154' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4177' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CUSTOM AUSTIN STONE RANCH-STYLE WATERFRONT HOME SITUATUATED OFF LAKE LIVINGSTON! This home is completely renovated & is luxurious lakefront country living. Home features an open concept, the lake can be seen from anywhere on the first floor. Waterfront views can be seen from the back patio that wraps around the entire home. Watch the sun set and sun rise from the roof top deck above the boathouse. Enjoy a cozy night in front of the covered pavilion featuring automatic shades, outdoor kitchen with grill, outdoor burners, green egg, and fireplace. Gourmet island kitchen with oversized built-ins with Thermador stainless steel appliances. Home upgrades include: LED lighting, built-in speaker system indoor and outdoor, tankless water heater, UV thermo-pane windows throughout, Generac generator, water filtration system, boathouse and sun deck, 2 electric jet ski lifts, 1 bedroom garage apt w/kitchen, 2 utility areas, 2 washer & dryers, high eff. HVAC systems, & Spider be gone System.' ,`Acres` = '0.0016' ,`Area` = '44' ,`BuilderName` = 'Paul Bublis' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Central Gas,Other Heating,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'IDLEWILDE ESTATES SECTION 1 BLK 2 LOT 14' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Other,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '70' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '132' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Ranch,Traditional' ,`Subdivision` = 'Idlewilde Estates Sec 1' ,`TaxAmount` = '13993' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704124' WHERE `Matrix_Unique_ID` = '208193007'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T16:39:31.640' ,`MLSNumber` = '7130092' ,`ListAgentFullName` = 'Dewey Miller' ,`ListOfficeName` = 'Homes Of Huntsville, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.551083' ,`Longitude` = '-95.511644' ,`PhotoCount` = '23' ,`PostalCode` = '77358' ,`RoomCount` = '6' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Pavey' ,`StreetNumber` = '128' ,`StreetSuffix` = 'Circle' ,`City` = 'New Waverly' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1659' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Waverly Family Delight- Great Country home & floor plan, located in the most desired, New Waverly School District. This home has an open concept, vaulted ceiling in family room, , wood burning fireplace, laminate flooring, breakfast bar, kitchen/dining combination, spacious bedrooms enhanced by natural lighting. There two areas  for the washer & dryer, one in the pantry area & one in the garage. There is a 2 car garage, front porch & back covered patio. Fenced front and back yards, storage building with electricity & the ultimate luxury, your own above ground pool.' ,`Acres` = '0.6165' ,`Area` = '43' ,`BuilderName` = '' ,`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` = 'EMERALD WOOD RANCHETTES, BLOCK 2, LOT 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '26853' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`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,Leave Business Card,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Emerald Wood Ranchettes' ,`TaxAmount` = '3274' ,`TaxRate` = '1.8438' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704124' WHERE `Matrix_Unique_ID` = '209217204'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T16:54:43.090' ,`MLSNumber` = '21010037' ,`ListAgentFullName` = 'Michele Jacobs' ,`ListOfficeName` = 'Michele Jacobs Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.504895' ,`Longitude` = '-95.052069' ,`PhotoCount` = '50' ,`PostalCode` = '77573' ,`RoomCount` = '12' ,`ListPrice` = '1295000.00' ,`Status` = 'Active' ,`StreetName` = 'Bella Luna' ,`StreetNumber` = '1284' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5071' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exclusive gated community in Tuscan Lakes on the Lake Custom Home built by Dan Wallrath*Feel like you are living in a stunning 5 star resort each day complete with pool/spa-outdoor kitchen-putting green-Gazebo-waterfalls on the lake with a multi-million dollar water view*The interior is a villa style each room is a feast for your eyes*Each bedroom is very large with their own bathroom*Dreamy closet in the primary suite*New A/C upstairs 2022*Generator 2022*Resurfaced pool plus new remotes and pool lighting 2019*Outside repainted 2021*Remote control blinds 2019*Curtains 2021*Wine Room*Roof cleaned and serviced 2021*Mosquito Prevention System*Dishwasher and microwave 2019*Primary Bedroom carpet 2020*3 car garage is tucked around side with long driveway*Casita/Guest Quarters with private exterior entrance*2 Staircases*3 Fireplaces*You have to see this beauty! WOW!' ,`Acres` = '0.4633' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'TUSCAN LAKES SEC SF 90-1 (2005) ABST 18, BLOCK 2, LOT 8, ACR' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '20181' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1640' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GOFORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'LEAGUECITY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Tuscan Lakes' ,`TaxAmount` = '23030' ,`TaxRate` = '2.6697' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704124' WHERE `Matrix_Unique_ID` = '210612235'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T16:56:11.993' ,`MLSNumber` = '33267062' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Newmark Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.708403' ,`Longitude` = '-95.890161' ,`PhotoCount` = '29' ,`PostalCode` = '77441' ,`RoomCount` = '10' ,`ListPrice` = '935719.00' ,`Status` = 'Active' ,`StreetName` = 'Aaron River' ,`StreetNumber` = '29854' ,`StreetSuffix` = 'Trail' ,`City` = 'Fulshear' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4191' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Introducing THE MONTEREY.  This stately 2 story home has it all. Front elevation features stone entry with the castle opening above. Enter the double 8 ft front door and prepare to be amazed. The distinguished curved stairs will capture your attention right away. The fabulous Family room boast two story wall of windows that looks out to the oversized covered patio. Turn and behold the stunning kitchen with double oven, glass canopy vent hood, gas cooktop and cleverly placed pot filler. The spacious main bedroom leads into the grand bathroom with the Adatto freestanding bath tub and oversized shower. Upstairs, the oversized game room is perfect for get togethers.  Move into the serene Media room and dim the lights for the movies. You are all set.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 30 Block 01' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '70' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704124' WHERE `Matrix_Unique_ID` = '211824994'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T16:44:24.820' ,`MLSNumber` = '96813715' ,`ListAgentFullName` = 'Pinky Pirani' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.645051' ,`Longitude` = '-95.699261' ,`PhotoCount` = '43' ,`PostalCode` = '77407' ,`RoomCount` = '10' ,`ListPrice` = '1500000.00' ,`Status` = 'Active' ,`StreetName` = 'Kirkshaw' ,`StreetNumber` = '11610' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5374' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your perfect LUXURY home search ends here. This beauty with a new pool guarantees one of the best lake view of Aliana. Built by prestigious builder J-Patrick homes this Kensington Plan is nestled in the highly sought master-planned community of Aliana. This 5 bedroom, 4 full bathroom, and 2 half baths home welcomes you with a grand double door entrance foyer, 21-foot soaring ceiling, a study, formal dining room, and a spacious family room. The kitchen has all the counter space you could ever want and has a large breakfast bar. Large master’s suite plus another spacious bedroom down. Three more spacious bedrooms are found upstairs plus a game room and a media room perfect for bonding and movie nights. You will have a bonus half bath upstairs also. Enjoy and relax with family and friends while sitting on your covered back patio with an outdoor kitchen. The balcony upstairs facing the lake will be your favorite place to unwind.' ,`Acres` = '0.2753' ,`Area` = '37' ,`BuilderName` = 'J Patrick Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ALIANA SEC 52, BLOCK 1, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11994' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1137' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MALALA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Aliana Sec 52' ,`TaxAmount` = '18528' ,`TaxRate` = '3.0329' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704124' WHERE `Matrix_Unique_ID` = '211857485'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T17:44:45.000' ,`MLSNumber` = '15816173' ,`ListAgentFullName` = 'Terry Burnaman' ,`ListOfficeName` = 'Terry Burnaman                ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.975147' ,`Longitude` = '-95.399762' ,`PhotoCount` = '20' ,`PostalCode` = '77073' ,`RoomCount` = '8' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Rising Springs' ,`StreetNumber` = '1419' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1798' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home!  This beautiful 3 bedroom, 2 bath brick home is located minutes away from the Hardy Toll, Beltway 8, Bush Airport and 45 North freeway.   The primary bedroom is located on the first floor and there are 3 additional bedrooms and a gameroom upstairs. The Kitchen is spacious with plenty of cabinet space and open to the living room.  Recent updates include interior paint, window coverings and carpeting throughout the bedrooms.  Schedule a private showing today!' ,`Acres` = '0.1027' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 2 MEADOWVIEW FARMS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4474' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '410' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadowview Farms Sec 5' ,`TaxAmount` = '4621' ,`TaxRate` = '2.8445' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704124' WHERE `Matrix_Unique_ID` = '211915271'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T16:25:34.587' ,`MLSNumber` = '68630833' ,`ListAgentFullName` = 'Kayla Sorrell' ,`ListOfficeName` = 'Pop Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.807955' ,`Longitude` = '-95.413176' ,`PhotoCount` = '47' ,`PostalCode` = '77008' ,`RoomCount` = '11' ,`ListPrice` = '619000.00' ,`Status` = 'Active' ,`StreetName` = '24th' ,`StreetNumber` = '819' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2391' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Escape the hustle and bustle of city life while still being in the middle of it all. This Modern and Contemporary home nestled in a gated community with no HOA is ready for new owners. This home will check off every item on your list - 3 Stories, 3 bedrooms, 3.5 baths, and no yard to maintain. You will enjoy the functional floor plan with 11\' ceilings, floor-to-ceiling windows providing an abundance of natural light, engineered wood floors throughout (NO CARPET!), and modern touches like a pivot front door, biofuel fireplace, LED lighting, modern fixtures, etc. Creating your favorite recipes is a real treat in this kitchen with six (6) gas burners, a double oven, waterfall island, and stainless steel appliances (including a wine cooler and ice maker). Begin and/or end your day on your own private balcony.  Location! Location! Location! Minutes to everything - HEB, Snooze, Flower Child Houston Heights, etc. Quick access to 610, 10, 290, 59, and 45 makes it a commuter\'s dream.' ,`Acres` = '0.0369' ,`Area` = '9' ,`BuilderName` = 'LaCasa International' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 ARGENTUM HEIGHTS' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '1608' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Argentum Heights' ,`TaxAmount` = '11131' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704125' WHERE `Matrix_Unique_ID` = '211917438'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T17:58:10.343' ,`MLSNumber` = '69848193' ,`ListAgentFullName` = 'Mohammed Ansari' ,`ListOfficeName` = 'Greenleaf Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.596880' ,`Longitude` = '-95.183391' ,`PhotoCount` = '10' ,`PostalCode` = '77034' ,`RoomCount` = '4' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Charidges' ,`StreetNumber` = '406' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1744' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1439' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 5 SYCAMORE VALLEY SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6267' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'SOUTH BELT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sycamore Valley Sec 02' ,`TaxAmount` = '4877' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663704125' WHERE `Matrix_Unique_ID` = '211918501'  --> Updated record success<br />