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-10-22T05:59:18.330' ,`MLSNumber` = '65577778' ,`ListAgentFullName` = 'Michael Callihan' ,`ListOfficeName` = 'Riverway Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.802806' ,`Longitude` = '-95.503378' ,`PhotoCount` = '28' ,`PostalCode` = '77055' ,`RoomCount` = '7' ,`ListPrice` = '725999.00' ,`Status` = 'Active' ,`StreetName` = 'Ojeman Creek' ,`StreetNumber` = '8710' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2842' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just finished MOVE IN READY!  First floor living with a huge yard Riverway Homes in Spring Valley Point - conveniently located minutes away from Highway I-10 and zoned to highly desirable Valley Oaks Elementary, Spring Branch Middle, and Memorial High School. This gorgeous Alisa floor-plan has an open concept floor plan with high ceilings and generously sized rooms with tons of natural light. Enjoy the contemporary designer finishes throughout; such as hard surface flooring in all of the main areas, wooden staircase treads with iron balusters, quartz countertops, modern cabinetry, upgraded light fixtures, and many more. This 4 bedroom, 3.5 bath home also includes a finished backyard with a covered patio. Built with Energy Efficient features throughout; including stainless steel kitchen appliances and a tankless water heater. Schedule your tour today!' ,`Acres` = '0.0702' ,`Area` = '24' ,`BuilderName` = 'Riverway Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 5 SPRING VALLEY POINT' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3060' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'VALLEY OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Spring Valley Point' ,`TaxAmount` = '5304' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666439196' WHERE `Matrix_Unique_ID` = '212148405'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T05:45:39.700' ,`MLSNumber` = '92609919' ,`ListAgentFullName` = 'Bill Hyman' ,`ListOfficeName` = 'Markham Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.656624' ,`Longitude` = '-96.364428' ,`PhotoCount` = '26' ,`PostalCode` = '77802' ,`RoomCount` = '8' ,`ListPrice` = '235900.00' ,`Status` = 'Active' ,`StreetName` = 'Southern' ,`StreetNumber` = '511' ,`StreetSuffix` = 'Lane' ,`City` = 'Bryan' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1468' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this charming 3 bedroom 2 bath home with numerous updates situated in an established neighborhood close to Historic Downtown Bryan! This classic 1950s home has luxury vinyl plank installed on the main floor living spaces and new tile installed in the kitchen and bathroom. Original shiplap accent walls, subway tile, farmhouse sink, and butcher block countertops all make this home feel cozy. A new dishwasher (2022) and French-door refrigerator (2020) bring the kitchen to life. You just cannot beat this location.  With two full baths, a garage, carport, fenced yard, and bonus sunroom with endless possibilities, this home is move in ready.  Updates and renovations include:  new outdoor AC unit (2019), new Shulte roof (2020), and new gutters (2022). The foundation and crawl space are rebuilt and improved  (2022).  Come see this charmer before it is too late!' ,`Acres` = '0.2191' ,`Area` = '61' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CAVITTS WOODLAND HEIGHTS PH 2, BLOCK 4, LOT 7 (SW 80\' OF)' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9544' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'HENDERSON ELEMENTARY SCHOOL (BRYAN)' ,`SchoolHigh` = 'BRYAN HIGH SCHOOL' ,`SchoolMiddle` = 'STEPHEN F. AUSTIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Left Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Heights Ph 2' ,`TaxAmount` = '3713' ,`TaxRate` = '2.262' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666439197' WHERE `Matrix_Unique_ID` = '212410393'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T05:18:08.443' ,`MLSNumber` = '94930636' ,`ListAgentFullName` = 'Rosa Sanchez-Setticase' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.670804' ,`Longitude` = '-95.624991' ,`PhotoCount` = '17' ,`PostalCode` = '77498' ,`RoomCount` = '0' ,`ListPrice` = '239500.00' ,`Status` = 'Active' ,`StreetName` = 'Overview' ,`StreetNumber` = '9919' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1296' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 9919 Overview Dr. This house features 3 bedrooms and 2 full bathrooms.  Beautiful tile floors throughout the entire house.   Inviting backyard with cover patio and deck for entertaining.' ,`Acres` = '0.1433' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TOWNEWEST SEC 1, BLOCK 14, LOT 5, R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '356' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'TOWNEWEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR LAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Townewest' ,`TaxAmount` = '3594' ,`TaxRate` = '2.3329' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666439197' WHERE `Matrix_Unique_ID` = '213257092'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T05:34:28.907' ,`MLSNumber` = '48025785' ,`ListAgentFullName` = 'Mayra Salguero' ,`ListOfficeName` = 'Coldwell Banker RealtyThe Willis Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.343466' ,`Longitude` = '-95.069586' ,`PhotoCount` = '50' ,`PostalCode` = '77327' ,`RoomCount` = '6' ,`ListPrice` = '308000.00' ,`Status` = 'Active' ,`StreetName` = 'Cobblestone' ,`StreetNumber` = '176' ,`StreetSuffix` = 'Lane' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1710' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Kirby Woods subdivision! WOW! Large Lot, Cul-De-Sec, nice landscaping, build in 2019 by Kendall Homes, Open floor plan, Energy star Appliances, clean and very well kept by current owners. Gorgeous vinyl plank flooring, Spacious family area with ceiling fan in every room, nice lighting throughout the house, Master Bedroom with high Ceilings,' ,`Acres` = '0.2549' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'KIRBY WOODS, BLOCK 1, SEC 2, LOT 5, ACRES .2549' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11103' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kirby Woods' ,`TaxAmount` = '' ,`TaxRate` = '2.5563' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666439197' WHERE `Matrix_Unique_ID` = '213276759'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T05:20:26.143' ,`MLSNumber` = '55206106' ,`ListAgentFullName` = 'Mike Schroeder' ,`ListOfficeName` = 'RE/MAX Preferred Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.009942' ,`Longitude` = '-95.754809' ,`PhotoCount` = '45' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '379999.00' ,`Status` = 'Active' ,`StreetName` = 'Amber Elm' ,`StreetNumber` = '21915' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2062' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Beautiful Perry Home 3 Bedrooms with a 1st floor Flex Room can be used as a 4th Bedroom Features a Neutral Den with Soaring 20-foot Ceilings that Open to a Light and Bright Kitchen with an an abundance of counter space and storage. The Home Features Recent Paint, Carpet and  a Beautifully Landscaped Backyard with a Oversized Sparkling Pool. All of this in the Exemplary Cy-Fair School District and the much-Desired Master Planned Community of Fairfield.' ,`Acres` = '0.1401' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 3 FAIRFIELD VILLAGE WEST SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6104' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1020' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KEITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairfield Village West Sec 09' ,`TaxAmount` = '6283' ,`TaxRate` = '2.616' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666439197' WHERE `Matrix_Unique_ID` = '213614353'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T05:58:46.473' ,`MLSNumber` = '41527663' ,`ListAgentFullName` = 'Francois Delille' ,`ListOfficeName` = 'Cozy Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.149066' ,`Longitude` = '-95.444422' ,`PhotoCount` = '49' ,`PostalCode` = '77386' ,`RoomCount` = '3' ,`ListPrice` = '239995.00' ,`Status` = 'Active' ,`StreetName` = 'Hillside' ,`StreetNumber` = '26526' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2629' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Selling the property \"AS-IS\". Stop and explore this 3/4 bedroom beauty, located in a great location near 45 freeway, recreation center next door, and great schools, it is just waiting for someone to come and make it their home. The large space in the second-floor access to the attic could potentially be converted as living space, buyer to verify independently. This home sits on a HUGE 22,008 sqft lot that offers 2,629 sqft living space with 3 bedrooms and 2 bathrooms. Perfect for entertainment and even to add a pool if it\'s your heart’s desire. This prime location will not last long, so stop, and make your appointment today.' ,`Acres` = '0.5052' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'OAK RIDGE NORTH 06, BLOCK 4, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '22008' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'OAK RIDGE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Ridge North 06' ,`TaxAmount` = '5513' ,`TaxRate` = '2.321' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666439197' WHERE `Matrix_Unique_ID` = '213820929'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-22T04:02:37.863' ,`MLSNumber` = '90309178' ,`ListAgentFullName` = 'Lana Ryaboy' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.736603' ,`Longitude` = '-95.758572' ,`PhotoCount` = '50' ,`PostalCode` = '77450' ,`RoomCount` = '12' ,`ListPrice` = '690000.00' ,`Status` = 'Active' ,`StreetName` = 'Cinco Lakes' ,`StreetNumber` = '3503' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3726' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautifully designed home located in the highly sought-after Cinco Ranch South Lake Village! Meticulously clean and well maintained, truly loved and updated throughout. Enjoy the open concept floor plan with tremendous amount of space soaked with natural light, oversized lot and 3-car garage. This home features: custom European style kitchen with quartz counters, soft close cabinetry, SS appliances (2021), remodeled primary bathroom, recent paint, updated tile and laminate flooring throughout the house, stunning light fixtures and much more.\r\nRelax and unwind at your private backyard oasis with pool, spa, beautiful mature trees and tons of green space.\r\nLocated near major freeways, restaurants, shops, lakes, golf course & Cinco Ranch Beach Club. Zoned to award-winning Katy ISD schools.\r\nAsk your agent to check the List of Updates and Additional Information about this house!\r\nShowings will start on Sunday, October 23, from 2:00 P.M.' ,`Acres` = '0.3342' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH SOUTH LAKE VILLAGE SEC 4, BLOCK 3, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14558' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WILLIAMS ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cinco Ranch South Lake Village Sec 4' ,`TaxAmount` = '10873' ,`TaxRate` = '2.4395' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666439198' WHERE `Matrix_Unique_ID` = '213860722'  --> Updated record success<br />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','213891890','1666439198','213891890','2022-10-22T05:53:54.963','56913455','Arthur Wayne Garza','Keller Williams Realty-FM','','','31.386852','-94.436037','31','75944','4','485000.00','Active','4921','661','','Etoile','2','0','4','1800','Single-Family','Room for friends and family, Lake house with guest cabin and shop, lots of deck space with outdoor kitchen, Sunroom with a fireplace and hot tub, Spectacular sunsets, lots of waterfront access, less than a mile from Shirley Creek Marina, Double door shop large enough for boat storage, also detached carport large enough for a full size boat. Hidden room under the Guest house.','0.58','77','','','','','Sellers Disclosure','','','2','','Central Electric','1','LOT 25 & 26 BLOCK 1 LAKECREST MANOR','Waterfront,Wooded','','Appraisal District','','165','0','','0','Electric Oven','0','','','Electric Cooktop','','Composition','261 - Etoile','ETOILE ELEMENTARY SCHOOL','','ETOILE ELEMENTARY SCHOOL','Appointment Required','Appraisal District','2','Traditional','Lake Crest Manor','','','Aerobic,Public Water','2011','Appraisal District');  --> New record created successfully<br />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','213967162','1666439198','213967162','2022-10-22T05:36:02.040','80271671','Lynn Collins','BHGRE Gary Greene','','','29.887622','-95.534670','43','77040','10','580000.00','Active','Brahms','9114','Lane','Houston','3','1','4','3776','Single-Family','Beautifully Appointed Lakefront 2-Story Executive Home on Peaceful Oversized Cul-De-Sac Lot with Sparkling Pool/Spa, 4 Laminar Jets. Walls of Windows for Spectacular Lake Views. Chef\'s Island Kitchen w/Abundant Cabinet & Counter Space, Stainless Appliances, 5-Burner Gas Cooktop & Sit-up Bar. Light & Bright Breakfast Area with 2 French Doors. Custom Built-ins in Family Rm. Renovated 2ndary Baths. Spacious 2ndary Bedrooms. Renovated Primary Bath has Custom Built-ins, Deep Jetted Soaker Tub, Dual Walk-in Closets & Linen Closet. Enormous Game Rm w/Built-Ins. Large Laundry Rm w/Built-ins. Updated Lighting/Hardware/Fixtures Throughout. Covered Patio Area and Large Deck for Entertaining. Fantastic Curb Appeal. Roof (2021). ACs (2020). Recent Water Heaters. Pool Pump (2022) Heater (2020). NO FLOODING. A Definite Must See! You\'ll Love the Woodwind Lakes Neighborhood with Mature Trees, 3 Peaceful Lakes with Walking Trails, Catch & Release Fishing, 2 Pools, Tennis Courts, Pavilion and Dog Park.','0.2562','11','Trendmaker','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Northwest Houston','Central Gas,Zoned','1','LT 31 BLK 3 WOODWIND LAKES SEC 1','Cul-De-Sac,Waterfront,Wooded','11162','Appraisal District','','815','0','','2','Electric Oven','1','Gunite,Heated,In Ground','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','GLEASON ELEMENTARY SCHOOL','JERSEY VILLAGE HIGH SCHOOL','COOK MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Woodwind Lakes Sec 01','9793','2.591','Public Sewer,Water District','1992','Appraisal District');  --> New record created successfully<br />