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-12-12T09:42:43.073' ,`MLSNumber` = '47305362' ,`ListAgentFullName` = 'Ryan Jockers' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.161713' ,`Longitude` = '-95.482584' ,`PhotoCount` = '47' ,`PostalCode` = '77381' ,`RoomCount` = '21' ,`ListPrice` = '4000000.00' ,`Status` = 'Active' ,`StreetName` = 'Windsail' ,`StreetNumber` = '46' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '9431' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MAGNIFICENT custom built LAKE FRONT home nestled on over an acre in the heart of The Woodlands on LAKE WOODLANDS!  You can walk or take a short boat ride to shops & restaurants at Hughes Landing! This 9,400 sq ft custom home was inspired by The Jefferson house in Monticello and features a private gated entrance, circular driveway, porte-cochere, 5-6 BDRMS, 6.5 BATHS, indoor pool & spa, & 4-car garage. Luxuries include 25 ft. ceilings, exquisite wrought iron double staircase, hand-painted murals, crown molding, marble floors, custom drapery, & 180 degree lake views. The 1st floor offers an impressive dining room, butler\'s kitchen, wet bar, game room, parquet dance floor, guest suite w/ private bath, & formal living. Upstairs find the family room, main kitchen, & 3 bedrooms. 3rd floor features huge primary bedroom w/ office. Sitting on 1.2 acres, this amazing home boasts a gazebo with fire pit, beach volleyball court, & multiple balconies. Enjoy easy access to I-45, 99 & The Woodlands' ,`Acres` = '1.2382' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WDLNDS VIL PANTHER CK 33, BLOCK 1, LOT 37' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '53935' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SALLY RIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodlands Panther Creek' ,`TaxAmount` = '54124' ,`TaxRate` = '2.0501' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090206' WHERE `Matrix_Unique_ID` = '210081582'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T10:54:57.080' ,`MLSNumber` = '72143565' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.026861' ,`Longitude` = '-95.845856' ,`PhotoCount` = '20' ,`PostalCode` = '77447' ,`RoomCount` = '14' ,`ListPrice` = '523203.00' ,`Status` = 'Active' ,`StreetName` = 'Kildeer Point' ,`StreetNumber` = '16034' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '3626' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located on a large oversized corner lot, with room for a pool!  This home features a stone elevation, luxury vinyl plank flooring, wrought iron spindles, separate formal dining and breakfast area, spacious game room, and a covered patio. Enjoy the convenience of bedroom #2 located downstairs with its own private full bath. Whip up amazing meals in the open concept island kitchen, fully equipped with Omega stone countertops, tile backsplash, 30\" gas cooktop, double ovens and stainless steel appliances. Spend your evenings relaxing in the primary suite, complete with a bay window, a walk-in closet, dual vanities, and a large spa shower.  Experience a small town feel while being just minutes away from popular shopping, dining and entertainment. Call now or visit us this weekend!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 1 Section 7' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9954' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'I T HOLLEMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090206' WHERE `Matrix_Unique_ID` = '210367393'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T10:50:20.140' ,`MLSNumber` = '59435525' ,`ListAgentFullName` = 'Jude Nassar' ,`ListOfficeName` = 'Vibrant Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.755388' ,`Longitude` = '-95.569564' ,`PhotoCount` = '37' ,`PostalCode` = '77042' ,`RoomCount` = '7' ,`ListPrice` = '580000.00' ,`Status` = 'Active' ,`StreetName` = 'Tupper Lake' ,`StreetNumber` = '10827' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2738' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NICE 4 BEDROOM 2 1/2 BATH SPACIOUS HOME, NEWER FLOORING, STAINLESS APPLIANCES, NEWER UPGRADES DONE BEFORE TENANT MOVED IN, WELL TAKEN CARE OF, LARGE LIVING ROOM PERFECT FOR FAMILY GATHERINGS WITH FIREPLACE, NICE SIZE BACKYARD WITH POOL FOR ENTERTAINING AND ENJOYING THOSE HOT SUMMER DAYS, HOME IS CONVENIENTLY LOCATED CLOSED TO SHOPPING CENTERS AND RESTAURANTS. MUST SEE TO APPRECIATE' ,`Acres` = '0.2649' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 6 LAKESIDE FOREST SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '11537' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '811' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeside Forest Sec 02' ,`TaxAmount` = '11251' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090206' WHERE `Matrix_Unique_ID` = '211005374'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T09:24:43.540' ,`MLSNumber` = '73026319' ,`ListAgentFullName` = 'Mohammed Khan' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.871846' ,`Longitude` = '-95.785912' ,`PhotoCount` = '50' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Brookdale Meadow' ,`StreetNumber` = '6706' ,`StreetSuffix` = 'Trace' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3010' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your Dream Home of Westin Home of 3,123 Sqft Featuring 4 beds, 3 and 1/2 baths, with beautiful Stone and Brick Elevation only few years old in master Planned Elyson community, featuring community Pool, splash pad, parks, trails, tennis court, fitness center, the Elyson Cafe, event space, soccer field (being built), with HEB and Target within few miles coming soon, Katy ISD zoned, backyard has a nice covered patio, corner lot. \r\nAppliances, washer, dryer included.' ,`Acres` = '0.2067' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 2 ELYSON SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9005' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson Sec 4' ,`TaxAmount` = '13180' ,`TaxRate` = '3.5368' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090206' WHERE `Matrix_Unique_ID` = '212159661'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T10:59:14.627' ,`MLSNumber` = '70594015' ,`ListAgentFullName` = 'Colleen Carriere' ,`ListOfficeName` = 'Asset Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.563865' ,`Longitude` = '-95.738436' ,`PhotoCount` = '20' ,`PostalCode` = '77469' ,`RoomCount` = '6' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'County Seat' ,`StreetNumber` = '3735' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1499' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and check out this beautiful 2 bedroom, 2 bath, with a bonus room that can be used as a home office/study with French Doors or as a 3rd bedroom! Gleaming hardwood floors and tile throughout...no carpet. Primary bedroom is light and bright with a wall of windows and huge walk-in closet. Expertly landscaped front and backyard with covered patio and sprinkler system.  Located in the fabulous Del Webb Sweetgrass community--adult 55+, this home was designed for easy living and great for entertaining!  The Del Webb community offers several incredible amenities: 27,000 sq. ft. lake house/recreation center, fitness center with indoor lap pool.  Enjoy the neighborhood\'s natural scenery, large lake, miles of walking trails, and an outdoor amphitheater.  Close to medical, dining, shopping, and entertainment!!!' ,`Acres` = '0.1121' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'DEL WEBB RICHMOND SEC 9-A, BLOCK 5, LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4884' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Webb Richmond Sec 9-A' ,`TaxAmount` = '6177' ,`TaxRate` = '2.9548' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090207' WHERE `Matrix_Unique_ID` = '213503089'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T10:47:15.503' ,`MLSNumber` = '93698397' ,`ListAgentFullName` = 'Albert Wade' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.002176' ,`Longitude` = '-95.847727' ,`PhotoCount` = '41' ,`PostalCode` = '77447' ,`RoomCount` = '8' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Harlequin' ,`StreetNumber` = '26934' ,`StreetSuffix` = 'Lane' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming one story home is move-in ready! New paint throughout and new carpet. Plenty of space outside on the covered deck to grill and entertain. The shed with a ramp in the backyard offers additional storage for tools and other items. Living, dining and kitchen area are open to allow you to stay engaged with guests while hosting. A must-see home for you and your family.' ,`Acres` = '0.1197' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 1 MALLARD CROSSING SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5213' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '280' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'I T HOLLEMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mallard Crossing' ,`TaxAmount` = '5573' ,`TaxRate` = '3.256' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090207' WHERE `Matrix_Unique_ID` = '213797010'  --> 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','214896425','1675090207','214896425','2022-12-12T10:43:49.653','92874896','Greg Holcombe','Holcombe Properties','','','30.215313','-95.645872','20','77354','6','220000.00','Active','Octavia','32713','Drive','Magnolia','2','0','3','1456','Single-Family','Look no further, Your Family will love this one! Brand New Construction in sought after Magnolia School District. Low Taxes, no HOA Fees, No water Bills, No Mud Tax. This home features a nice and spacious floor plan with good sized bedrooms, gorgeous kitchen with plenty of cabinet and counter space, walk in pantry, Nice utility room and tons of upgrades to include vinyl flooring, granite counter tops and much more. Call and make your appointment today because it won’t last long.','0.301309','15','MKM Superior Homes','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Magnolia/1488 East','Central Electric','0','S848002 - Royal Oaks On 1488 02, Lot 121','Cleared,Subdivision Lot','13125','Appraisal District','','','1','Never Lived In','0','','0','','','Electric Range','','Composition','36 - Magnolia','MAGNOLIA PARKWAY ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Accompany,Lockbox Front,Supra Keybox','Builder','1','Ranch','Royal Oaks On 1488 02','653','1.8587','Aerobic,Septic Tank,Well','2022','Builder');  --> 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','215014215','1675090207','215014215','2022-12-12T09:47:28.967','26756307','Minnie Chen','HomeSmart','','','30.107339','-95.269267','28','77365','7','365000.00','Active','Laurette','19891','Drive','Porter','3','0','6','3198','Single-Family','New remodeling 6 bedroom and 3 baths. Formal dining room, study room and extra big game room. It is good for a big family. New 42\" cabinet, granite countertop. New paint, new tile and new carpet. Nice swimming pool!','0.3333','40','','','','','No Disclosures','1','Freestanding','1','Porter/New Caney West','Central Electric','0','SHADOWLAND RETREAT, LOT 73','Cleared','14519','Appraisal District','','','0','','2','Electric Oven','1','In Ground','','','','Composition','39 - New Caney','SORTERS MILL ELEMENTARY SCHOOL','PORTER HIGH SCHOOL (NEW CANEY)','WHITE OAK MIDDLE SCHOOL (NEW CANEY)','No Appointment Required,No Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Contemporary/Modern','Shadowland Retreat','6089','2.1331','Public Sewer,Public Water','1973','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','215319560','1675090207','215319560','2022-12-12T09:58:27.440','85607915','Victorino Cortez','Lions Gate Realty','','','30.099885','-95.289674','41','77365','3','165000.00','Active','Jay','18681','Court','Porter','2','0','3','1216','Single-Family','This beautiful 3 bedroom, 2 bathroom home has plenty of space inside and out. Inside you will have open floor plan, fresh paint, new floor and spacious living room. Outside you will have a HUGE backyard, LOTS of room to play, covered patio and a storage shed. \r\nWon’t last long. Must view today!','0.3616','40','','','','','Sellers Disclosure','','','','Porter/New Caney West','Central Electric','0','S906301 - SUMMER HILLS 01, LOT 62, SERIAL CLW009682TX, TITLE','Other','15750','Appraisal District','','','0','','0','','0','','','','','Aluminum','39 - New Caney','BROOKWOOD FOREST ELEMENTARY SCHOOL','PORTER HIGH SCHOOL (NEW CANEY)','WOODRIDGE FOREST MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Summer Hills 01','1758','2.1331','Septic Tank','1997','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','215319690','1675090207','215319690','2022-12-12T10:04:28.413','89399576','Jace Bowlin','Real Broker, LLC','','','30.071200','-95.189840','41','77339','4','260000.00','Active','Cedar Forest','4038','Drive','Houston','2','0','4','2112','Single-Family','Gorgeous 4 bedroom and 2 bathroom home located in Elm Grove. Spacious living area with wood beams located on the tall ceilings. Tile leads to a wood burning fireplace which is the focal point, sure to warm the house. The kitchen has granite countertops, travertine, tile backsplash, breakfast area and tons of storage including a walk-in pantry! The home also has a spacious walk-in laundry room. The primary suite is located on the front of the home and large, with dual sinks topped with granite, with a large tile walk in shower. Down the hall you will find the three other bedrooms with a bathroom in the middle. The backyard is a green oasis, with tons of great landscaping and trees to relax. The garage is attached by a cat walk and a large driveway. Schedule now to see the great Kingwood home!','0.1826','32','','','','','Sellers Disclosure','','','1','Kingwood West','Central Gas','1','LT 1 BLK 2 ELM GROVE VILLAGE SEC 1','Corner,Subdivision Lot','7956','Appraisal District','','220','0','','1','','0','','','','','Composition','29 - Humble','ELM GROVE ELEMENTARY SCHOOL (HUMBLE)','KINGWOOD PARK HIGH SCHOOL','KINGWOOD MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Elm Grove Village','5366','2.5839','Public Sewer,Public Water','1978','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','215465087','1675090207','215465087','2022-12-12T10:30:14.747','34665542','Vinod Eapen','Stride Real Estate, LLC','','','29.623435','-95.420600','29','77045','7','395000.00','Active','Painted Sunrise','2923','Trail','Houston','2','0','4','1787','Single-Family','Check out this beautiful , spacious  4 bed 2 bath home in a great gated community. Elegant master suite with large walk-in closet and ample shelving. Kitchen with bay window open to family room. Located in a quiet community minutes away from Downtown and the Medical Center.','0.114','18','','','','','Sellers Disclosure','1','','','Five Corners','Central Gas','1','LT 14 BLK 2 BAYOU OAKS AT WEST OREM SEC 8','Subdivision Lot','4966','Appraisal District','','710','0','','2','','0','','','','','Composition','27 - Houston','PETERSEN ELEMENTARY SCHOOL','MADISON HIGH SCHOOL (HOUSTON)','LAWSON MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Bayou Oaks/West Orem Sec 8','902','2.8907','Public Sewer,Public Water','2022','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','215530473','1675090207','215530473','2022-12-12T10:36:10.510','94367565','Katrina Guerrero','Texas Premier Realty','','','29.768335','-96.160622','0','77474','4','295000.00','Active','Rexville','1104','Road','Sealy','1','0','4','1224','Single-Family','This 2 story farmhouse, feasibly built in the 1920\'s, but remodeled in the 1960\'s is surrounded by a 12,981 sq. ft. lot. This home is move in ready and has been an investment property with continuous tenancy over the years. The lot is large enough to support additional add-ons to the home or spacious enough to add an additional dwelling for maximum investment potential. Located in a peaceful neighborhood that is less than a mile from the Sealy Police Department and about 4 miles to B&PW Park. This one won\'t last long, so make an appointment to view today! Room sizes are approximate.\r\n\r\n.','0.298','57','','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','Mock Fireplace','1','','Central Gas','0','KRAMPITZ (DON ELL) SUB. LOT 1','Subdivision Lot','12981','Appraisal District','','','0','','0','Electric Oven','0','','','Gas Cooktop','','Composition','109 - Sealy','SELMAN ELEMENTARY SCHOOL','SEALY HIGH SCHOOL','SEALY JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card','Appraisal District','2','Other Style','Krampitz Don Ell Sub','','','Public Sewer','1960','Appraisal District');  --> New record created successfully<br />