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-06T03:42:00.193' ,`MLSNumber` = '64945740' ,`ListAgentFullName` = 'Londa Carlisle' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.050430' ,`Longitude` = '-95.445452' ,`PhotoCount` = '47' ,`PostalCode` = '77388' ,`RoomCount` = '9' ,`ListPrice` = '312500.00' ,`Status` = 'Active' ,`StreetName` = 'Teller' ,`StreetNumber` = '19711' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on the market! Move-In ready one story home in Klein ISD! Open floor plan has been Updated to the Max!  New kitchen & brand new appliances, new master bath, new secondary bath, flooring, doors, fixtures, lighting, paint, blinds, new grass--too much to list!  Neutral colors to accommodate any style. Great Room upon entry could be formal dining & living/study/home office area.   Easy entertaining in new gourmet kitchen.  Huge family room with cozy fireplace is open to the kitchen/breakfast area. It overlooks shady backyard with access to patio. Master retreat beautifully updated with new glass-enclosed shower/dual vanity/flooring/paint/doors/lighting/fixtures. Large secondary bedrooms with updated full bath are located on a separate hallway. Secondary bath is light & inviting with new countertops/fixtures/tub/shower/flooring. Easy access to I-45/Grand Pkwy/Hardy Tollway/Springwoods Village.  Minutes to The Woodlands Mall/Market Street. Zoned to top rated Klein schools!  Hurry!' ,`Acres` = '0.2057' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 4 DEVONSHIRE WOODS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '566' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'LEMM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Devonshire Woods Sec 01' ,`TaxAmount` = '4870' ,`TaxRate` = '2.534' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665048775' WHERE `Matrix_Unique_ID` = '208003358'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T03:37:01.050' ,`MLSNumber` = '97140292' ,`ListAgentFullName` = 'Alejandro Soules-Lara' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.145080' ,`Longitude` = '-95.491910' ,`PhotoCount` = '40' ,`PostalCode` = '77380' ,`RoomCount` = '10' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Kentwood' ,`StreetNumber` = '3323' ,`StreetSuffix` = 'Drive' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEWLY AND COMPLETELY RENOVATED, READY TO MOVE-IN SPACIOUS HOME located on a corner lot with 2 driveways in a comfortable neighborhood in The Woodlands minutes away from The Woodlands Mall, Market St, and the Mitchell Nature Preserve where your family will enjoy miles of hiking and biking. Situated in the renowned Conroe ISD with “A” rated schools like Glen Loch Elementary. Amenities include a pool area with playground. The entire interior and exterior are newly painted with a new roof, gutters, sprinkler system and HVAC system. The 1st floor offers a large master bedroom with adjoining bath, two extra bedrooms, a dining room, breakfast room with bay window, and a large living room. The new section offers a huge tiled game room with high ceilings and gas connections for a new kitchen, a 2nd master bedroom with adjoining bathroom and bay window, a study/ office with 1/2 bath and balcony with French doors. Perfect for a mother-in-law’s apartment. Appliances included. Never flooded!' ,`Acres` = '0.2135' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TIMBER RIDGE 03, LOT 26' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '70' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GLEN LOCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Ridge 03' ,`TaxAmount` = '4685' ,`TaxRate` = '2.5954' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665048775' WHERE `Matrix_Unique_ID` = '209840329'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T03:28:05.197' ,`MLSNumber` = '33470674' ,`ListAgentFullName` = 'Gail Medina' ,`ListOfficeName` = 'Intero Real Estate Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.849295' ,`Longitude` = '-95.592839' ,`PhotoCount` = '18' ,`PostalCode` = '77041' ,`RoomCount` = '9' ,`ListPrice` = '535000.00' ,`Status` = 'Active' ,`StreetName` = 'Summerland Ridge' ,`StreetNumber` = '12210' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home! NEVER flooded, not even during Harvey. Spacious 5 bedroom layout with beautiful pool in the back yard, custom removable pool-fence and a 3 car garage. Newly painted interior walls. Home comes with backyard patio furniture, kitchen refrigerator, washer, dryer and two mounted flat-screen TVs with their brackets. Professionally landscaped back and front yard. New tile back splash in the kitchen & brand new stainless steel appliances.  Located in a gated community with lakes, swans and palm trees all through out.  Primary en-suite bathroom with jetted garden tub, new tile and frameless glass shower. Second floor includes 2 full baths which includes fully tiled flooring, bathtub with sliding glass doors & Siltstone counters. LED lights throughout the home! Primary bedroom downstairs, all other bedrooms upstairs.' ,`Acres` = '0.218' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 LAKES ON ELDRIDGE SEC 19 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9496' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1690' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes On Eldridge' ,`TaxAmount` = '12020' ,`TaxRate` = '2.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665048775' WHERE `Matrix_Unique_ID` = '210243279'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T02:05:35.010' ,`MLSNumber` = '71016322' ,`ListAgentFullName` = 'Syed Chishty' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.645708' ,`Longitude` = '-95.768189' ,`PhotoCount` = '38' ,`PostalCode` = '77406' ,`RoomCount` = '8' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Singing Flower' ,`StreetNumber` = '3735' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2281' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'IF YOU ARE LOOKING FOR A HOME IN THE MCCRARY NEIGHBORHOOD, THIS IS 4 BEDROOM,2 1/2 BATHROOM AND A GAME ROOM, 2281 SQFT HOME MIGH BE THE BEST IN THE MARKET RIGHT NOW. THE ENCHANTING TWO-STORY FLOOR PLAN FEATURES A SPACIOUS KITCHEN WITH A WALK-IN PANTRY, AN ADJOINING BREAKFAST ROOM\r\nTHAT OFFERS ACCESS TO A COVERED REAR PATIO, A GENEROUS FAMILY ROOM, AND A WALK-IN UTILITY ROOM. THE SPACIOUS FIRST FLOOR MASTER BEDROOM FEATURES AN EN SUITE MASTER BATHROOM OFFERING DUAL SINKS, A SEPERATE SHOWER AND TUB, A PRIVATE TOILET ENCLOSURE, AND A LARGE MASTER CLOSET. THE SECOND FLOOR FEATURES A LARGE GAME ROOM AND A FULL BATHROOM. ALL SECONDARY BATHROOMS IN THE FLOOR PLAN FEATURE WALK-IN CLOSETS.' ,`Acres` = '0.1557' ,`Area` = '37' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MCCRARY MEADOWS SEC 5, BLOCK 5, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6784' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mccrary Meadows Sec 5' ,`TaxAmount` = '6941' ,`TaxRate` = '2.8548' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665048775' WHERE `Matrix_Unique_ID` = '211062816'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T03:01:20.287' ,`MLSNumber` = '59976334' ,`ListAgentFullName` = 'Maura Westphal Coady' ,`ListOfficeName` = 'FYI Realty-Katy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.879858' ,`Longitude` = '-94.885820' ,`PhotoCount` = '34' ,`PostalCode` = '77535' ,`RoomCount` = '9' ,`ListPrice` = '505999.00' ,`Status` = 'Active' ,`StreetName` = 'OAKWOOD' ,`StreetNumber` = '11826' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2931' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS One story Margaret plan home with beautiful and welcoming entryway has 4 spacious bedrooms and 3 full bath with 3 car garage and huge yard! Upgraded gourmet kitchen includes farm sink, double oven, granite countertops & butlers pantry! High ceilings and lots of natural light, kitchen w huge island open to living room with beautiful stone fireplace. Welcoming entry with 8ft front door, rain gutters on entire home and upgraded owner\'s luxury bath.  Home has safety cameras installed and included in sale, prewired for your tv in living room and primary bedroom.  Upgraded plumbing fixtures, framed bath mirrors and. Patio gas line for your outdoor grilling and sink upgrade installation in laundry room. Easy access to I-10 via Highway 146, 3 minutes to highway 99/grand parkway and near shopping centers.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'K.HOVNANIAN' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13  BK 6 ST AUGUSTINE MEADOWS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11680' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '455' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'ST. AUGUSTINE MEADOWS' ,`TaxAmount` = '' ,`TaxRate` = '2.3' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665048775' WHERE `Matrix_Unique_ID` = '211894876'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T02:36:45.977' ,`MLSNumber` = '47518626' ,`ListAgentFullName` = 'Melissa Walters' ,`ListOfficeName` = 'The MW Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.707716' ,`Longitude` = '-95.369387' ,`PhotoCount` = '22' ,`PostalCode` = '77021' ,`RoomCount` = '4' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Parkwood' ,`StreetNumber` = '3321' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2972' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PARKWOOD HOME NEEDS WORK. BEING SOLD AS IS. COMPLETE RENO NECESSARY. ENORMOUS POTENTIAL WITH GARAGE APARTMENT AND ALL FORMALS IN THE MAIN HOME INCLUDING SUNROOM.' ,`Acres` = '0.2984' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Riverside' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 & TR 11A BLK 52 RIVERSIDE TERRACE SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'THOMPSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverside Terrace Sec 08' ,`TaxAmount` = '6442' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1935' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665048776' WHERE `Matrix_Unique_ID` = '212628561'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-06T03:44:01.857' ,`MLSNumber` = '10027354' ,`ListAgentFullName` = 'Michael Greiner' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.743223' ,`Longitude` = '-95.419677' ,`PhotoCount` = '38' ,`PostalCode` = '77019' ,`RoomCount` = '10' ,`ListPrice` = '1600000.00' ,`Status` = 'Active' ,`StreetName` = 'Locke' ,`StreetNumber` = '3019' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3654' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3 story home in extremely desirable Avalon Place neighborhood on 9172 sq ft lot with a magnificent, well-cared for oak tree in the front yard.  Spacious rooms throughout with plenty of windows allowing plenty of natural light. Beautiful crown molding, hardwoods and tile floors throughout. Formal dining and downstairs study. Gated driveway with 2 car carport and studio apartment above the carport.  Endless opportunities to remodel to bring to todays standards or to build your dream house on a magnificent lot in one the most sought-after communities in Houston. The owners are offering this property to be sold in its current condition, AS-IS!' ,`Acres` = '0.2106' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 & TR 3 BLK F AVALON PLACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9172' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Avalon Place' ,`TaxAmount` = '23796' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665048776' WHERE `Matrix_Unique_ID` = '212884441'  --> 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','213285606','1665048776','213285606','2022-10-06T02:03:50.820','59528693','Bobbie Schwartz','Orchard Brokerage','','','30.179535','-95.566816','33','77382','12','390000.00','Active','Vesper Bend','154','Circle','The Woodlands','2','1','4','2229','Single-Family','Click the Virtual Tour link to view the 3D walkthrough. This clean and move in ready house awaits new owners! Entertaining comes easy with this spacious 4 bed/2.5 bath property. All bedrooms are situated upstairs for additional privacy leaving the first floor ideal for hosting. The formal dining room shines with natural light. The open concept layout allows room for mingling between the kitchen, living room, and breakfast nook. Both Kitchen and laundry have gas line in addition to electric. Breakfast bar is great for buffet style snacks and meals. The enormous primary bedroom features high ceilings and an en-suite bath with access to the walk-in closet. Enjoy the large, private backyard while staying out of the sun under the covered patio. Home is generator ready! Spend the morning playing golf nearby at The Club at Carlton Woods: Jack Nicklaus Signature Course or relaxing at the Artist grove park. Easy access to various restaurants and grocery stores for all your needs. Welcome home!','0.1693','15','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','','','','The Woodlands','Central Gas','0','WDLNDS VIL STERLING RIDGE 30, BLOCK 1, LOT 15','Subdivision Lot','7374','Appraisal District','','','0','','2','Electric Oven,Gas Oven','0','','','Electric Cooktop','','Composition','11 - Conroe','TOUGH ELEMENTARY SCHOOL','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','2','Traditional','Wdlnds Village Sterling Ridge 30','5701','2.1816','Water District','2004','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','213343554','1665048776','213343554','2022-10-06T02:55:49.443','23983455','Bertha Hernandez','Jerry Fullerton Realty, Inc.','','','30.704627','-95.084271','29','77351','4','194500.00','Active','Bay Haven','168','Boulevard','Livingston','1','0','3','1336','Single-Family','Weekend get away or home sweet home. Within walking distance from the Lake/Pier and the Boat Ramp. Huge 2 lots. THE HOUSE HAS BEEN UPDATED. Freshly paint throughout the house, new floors in the opened areas in the front, foundation repair. Come see this beautiful home.','0.4247','44','','','','','Sellers Disclosure','1','','','Lake Livingston Area','Central Electric','1','BAY HAVEN SECTION 1 BLK 2 LOT 6 & 7','Subdivision Lot','18500','Appraisal District','','300','0','','2','','0','','','','','Composition','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Contemporary/Modern,Traditional','Bay Haven #1','1791','1.8745','Public Sewer,Public Water','1965','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','213364273','1665048776','213364273','2022-10-06T03:59:40.670','29896854','Susan Hutson','CB&A, Realtors-Katy','','','29.764243','-95.833810','44','77494','9','519000.00','Active','Rustic Woods','26242','Lane','Katy','3','1','5','3246','Single-Family','Gorgeous 2 story home has 2 Bedrooms downstairs located in the beautiful Woodcreek Reserve Community w no neighbors in the back! As you enter this beautiful home you are greeted w soaring two story ceilings & gorgeous engineered wood flooring throughout the common areas on the first floor!  This home features a private study also w wood flooring & behind glass plated french doors, elegant formal dining room w crown molding.  Large kitchen w granite counters, undermount sink, stainless appliances, gas range cooktop.  Huge living room space again w high ceiling  & wood flooring. Large primary bathroom w granite counters, double sinks, jetted tub, & huge walk in closet.  Secondary inlaw suite downstairs great for guest to stay.  Three large secondary bedrooms on the second floor w great sized closet space.  Media & gameroom also on the second floor, this home is perfect for entertaining. This amazing home is about 2 blocks away from Woodcreek Elementary & Woodcreek JH easy access to I10!','0.2324','36','','','Electric Dryer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Katy - Southwest','Central Gas','1','WOODCREEK RESERVE SEC 8, BLOCK 1, LOT 5','Subdivision Lot','10125','Appraisal District','','1200','0','','3','Electric Oven','0','','','Gas Range','','Composition','30 - Katy','WOODCREEK ELEMENTARY SCHOOL','KATY HIGH SCHOOL','WOODCREEK JUNIOR HIGH SCHOOL','Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Woodcreek Reserve Sec 8','10415','2.8317','Water District','2012','Appraisal District');  --> New record created successfully<br />