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-10T18:51:24.793' ,`MLSNumber` = '68557808' ,`ListAgentFullName` = 'Michael Vo' ,`ListOfficeName` = 'Liv Texas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.825302' ,`Longitude` = '-95.445270' ,`PhotoCount` = '49' ,`PostalCode` = '77018' ,`RoomCount` = '13' ,`ListPrice` = '1199990.00' ,`Status` = 'Active' ,`StreetName` = 'Althea' ,`StreetNumber` = '1810' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4690' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Custom home in the desirable Oak Forest! This home features 5 Bedrooms with large walk in closets w/ built-in storage, 4 bathrooms and 1 half bath including Carrera marble bathroom vanities.  The exterior construction features Austin stone w/ full stucco elevation. The living room has a spacious open floor plan with high ceilings great for entertaining. Included is a fully enclosed office on first floor. Large game room living area on second floor.  With prewired security, custom audio sound system throughout the home and smart home features to control from apps on your device. There are custom cabinets built in throughout the home. A custom cast stone fireplace, solid wood floors & travertine.  With Viking appliances, honed quartz kitchen counters, and a butler\'s pantry, this home offers a full functioning custom kitchen. There are double crown molding, coffered ceilings, covered back patio, outdoor grill island in stone/stucco to be included to enjoy the outdoor activities.' ,`Acres` = '0.1736' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 2 OAK FOREST SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest Sec 10' ,`TaxAmount` = '23976' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696766' WHERE `Matrix_Unique_ID` = '208568709'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T18:24:13.270' ,`MLSNumber` = '97142434' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.071735' ,`Longitude` = '-95.616763' ,`PhotoCount` = '34' ,`PostalCode` = '77375' ,`RoomCount` = '4' ,`ListPrice` = '381780.00' ,`Status` = 'Active' ,`StreetName` = 'Everpine' ,`StreetNumber` = '13111' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready January 2023! Stock up on everyone\'s favorites with plenty of room in the walk-in pantry. Espresso cabinets with cream black granite countertops Travertine look tile and warm grey carpet in our Balanced package. Whether you’re headed to work or for a night out, Cherry Pines is just minutes away from premier retail, restaurants, and employment centers. Send the kids to school in the sought-after Tomball school district and enjoy weekends at the future pool and playground. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0287 Plan 830B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cherry Pines' ,`TaxAmount` = '' ,`TaxRate` = '2.4' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696766' WHERE `Matrix_Unique_ID` = '210574897'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T19:14:05.883' ,`MLSNumber` = '42287018' ,`ListAgentFullName` = 'Martha Bennett' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.502809' ,`Longitude` = '-94.956577' ,`PhotoCount` = '30' ,`PostalCode` = '77539' ,`RoomCount` = '8' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Debbie' ,`StreetNumber` = '218' ,`StreetSuffix` = 'Lane' ,`City` = 'San Leon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful Home Being Built by Robertson Homes in San Leon with view of the gulf from back side of home. Lumber to be #2 except bracing and plate material Tech Shield roof GAF 40 year mildew resistant shingle Hardy Siding R13 fiberglass exterior wall insulation R38 fiberglass ceiling insulation vinyl windows with insulated Low E glass 16 seer energy-efficient air conditioners, 200 amp electrical service one 50 gallon hot water heater Wirehouse for ( CAT 5 ) Prewire for security Gutters Crown molding in kitchen, great room, dining rm, foyer, and master bedroom 4 ½” baseboards 3 ½” casing GREATROOM Hardwood flooring Wood ceiling beams KITCHEN Custom wood cabinets with granite tops Under-mount stainless sink Tile floors DINING Hardwood flooring MASTER BEDROOM Bedroom has hardwood flooring Tile in bath Granite with under-mount bowls Tile shower Satin nickel shower door' ,`Acres` = '0.1974' ,`Area` = '33' ,`BuilderName` = 'ROBERTSON HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BAY CASA (2013) ABST 10, LOT 22, ACRES 0.1974' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '8600' ,`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` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Casa 2013' ,`TaxAmount` = '1377' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696766' WHERE `Matrix_Unique_ID` = '211171211'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T18:00:40.093' ,`MLSNumber` = '73826334' ,`ListAgentFullName` = 'Ralph Green' ,`ListOfficeName` = 'JB Goodwin, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.561493' ,`Longitude` = '-98.017195' ,`PhotoCount` = '36' ,`PostalCode` = '78155' ,`RoomCount` = '6' ,`ListPrice` = '565000.00' ,`Status` = 'Active' ,`StreetName` = 'Reiley' ,`StreetNumber` = '207' ,`StreetSuffix` = 'Road' ,`City` = 'Seguin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1904' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WATERFRONT LAKE PLACID 2-story home w/ private road gated access off Reiley Rd & approx. 60\' of river front access w/ 2 docks along the Guadalupe River. Home was lifted in 2019 above flood level FEMA recommended contractor (see attached documentation). Roof replaced 2018, completely new AC & Septic systems installed in 2019. Approx. 800sf detached metal garage shop. Reside full time on the river, great weekend hideaway or short/long term rental, the possibilities are endless!' ,`Acres` = '0.718' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '0' ,`Legal` = 'ABS: 3 SUR: ISAAC BAKER 0.718 ACS.' ,`LotDesciption` = 'Cleared,Water View,Waterfront,Wooded' ,`LotSize` = '31276' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '157 - Seguin' ,`SchoolElementary` = 'MCQUEENEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEGUIN HIGH SCHOOL (SEGUIN)' ,`SchoolMiddle` = 'A.J. BRIESEMEISTER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Isaac Baker Surv Abs 3' ,`TaxAmount` = '10405' ,`TaxRate` = '2.2057' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696767' WHERE `Matrix_Unique_ID` = '211247993'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T18:14:18.413' ,`MLSNumber` = '7633642' ,`ListAgentFullName` = 'Amber Morris' ,`ListOfficeName` = 'RE/MAX Opportunities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.376259' ,`Longitude` = '-95.820788' ,`PhotoCount` = '40' ,`PostalCode` = '77461' ,`RoomCount` = '1' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Kanak' ,`StreetNumber` = '13420' ,`StreetSuffix` = 'Street' ,`City` = 'Needville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for unrestricted land in NISD? This is IT!! Buyer to Complete - Under Construction - This Potential Barndominium has several features to love! 50x50 Red Iron Frame, Insulated, 16ft Roll up door, 200 Amp Service, Power Set drop for Car Lift, 380 ft 4\" well, Recent Aerobic Septic, 500 gallon Buried Propane Tank, All completed and Fully fenced with 2 Driveways!  Inside the potential living space is all pre-plumbed with studs ready for sheetrock. Tankless water heater is already installed!! Check out the gorgeous shower!! Approximate living space is 50x20ft. Outside, there is a sidewalk around, with plumbing for an outdoor shower. Do NOT miss this rare Opportunity to own your piece of Texas and finish your Barndo today! Located approx 5 minutes from NISD schools, 15 minutes from 59 Freeway, and all major shopping. Call and schedule today!' ,`Acres` = '1.5' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = '0224 H AND TC RY, TRACT 9, ACRES 1.50' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '65340' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Barndominium' ,`Subdivision` = 'H & Tc Ry' ,`TaxAmount` = '1898' ,`TaxRate` = '1.8957' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696767' WHERE `Matrix_Unique_ID` = '211267521'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T19:51:58.563' ,`MLSNumber` = '4910596' ,`ListAgentFullName` = 'John Bennett' ,`ListOfficeName` = 'UHS Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.737711' ,`Longitude` = '-95.357486' ,`PhotoCount` = '7' ,`PostalCode` = '77004' ,`RoomCount` = '2' ,`ListPrice` = '128500.00' ,`Status` = 'Active' ,`StreetName` = 'Delano' ,`StreetNumber` = '2406' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '782' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located minutes away from Texas Medical Center.  Great opportunity for New Construction of a new townhome.  Property being sold as is at lot value, no disclosures.  Location is also close to University of Houston and TSU campuses.' ,`Acres` = '0.082' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TR 4B BLK 2 & TRS 5 & 6A BLK A HOLMAN OL 1 WELLS' ,`LotDesciption` = 'Other' ,`LotSize` = '3570' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Wells' ,`TaxAmount` = '2220' ,`TaxRate` = '2.5144' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696767' WHERE `Matrix_Unique_ID` = '211282935'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T19:37:54.287' ,`MLSNumber` = '79576307' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.160901' ,`Longitude` = '-95.589277' ,`PhotoCount` = '26' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '467140.00' ,`Status` = 'Active' ,`StreetName` = 'Flintlock' ,`StreetNumber` = '27050' ,`StreetSuffix` = 'Trail' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2434' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Show Stopper !! This 2-story home features 4 bedrooms, 3 1/2 baths, with Gameroom and Study. Covered Patio + 2 Car Garage!  This spacious and entertainers home has a Central Island Kitchen, Spacious Casual Dining, and a Well-lit two-story Family Room offering lots of Windows! The study is located off the family room. Private Owner\'s Suite w/ Attached Spa-like Bath located on the rear of the first level. Three more secondary bedrooms and two full bathrooms are located upstairs with a gameroom. Stainless Steel Appliances, 2\" Blinds, Security System, Sprinkler System,  Gutters, Fully Sodded Yard + Landscaping Pkg all included! **HOME IS UNDER CONSTRUCTION. Photos are REPRESENTATIVE of the plan/layout and are not of the actual home. Selections, colors, and finishes will vary. For more info, contact Chesmar Homes in NorthGrove community.  October/November 2022 estimated completion.**' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S740215 - Northgrove 15, BLOCK 5, Lot 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6120' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northgrove' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696767' WHERE `Matrix_Unique_ID` = '211283037'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T19:43:26.057' ,`MLSNumber` = '66351926' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.438321' ,`Longitude` = '-95.402984' ,`PhotoCount` = '13' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '568900.00' ,`Status` = 'Active' ,`StreetName` = 'Cooper' ,`StreetNumber` = '4523' ,`StreetSuffix` = 'Lane' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION-Home office with French doors set at entry with 12-foot ceiling. Extended entry leads to open kitchen, dining area and family room. Kitchen features corner walk-in pantry, generous counter space and island with built-in seating space. Dining area flows into family room with wall of windows. Primary suite includes double-door entry to primary bath with dual vanities, garden tub, separate glass-enclosed shower and two large walk-in closets. A guest suite with private bath adds to this spacious one-story home. Extended covered backyarrd patio. overed backyard patio. Mud room off two-car garage.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 60 (A0287) (IOWA COLONY) BLK 1 LOT 48' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6653' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696767' WHERE `Matrix_Unique_ID` = '211283059'  --> Updated record success<br />