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-09-01T21:53:10.257' ,`MLSNumber` = '30866849' ,`ListAgentFullName` = 'Tamintris Robinson' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.437704' ,`Longitude` = '-95.434818' ,`PhotoCount` = '42' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '392900.00' ,`Status` = 'Active' ,`StreetName` = 'Whitney Reach' ,`StreetNumber` = '10010' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2316' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'We have inventory homes ready!\r\n\r\n  Upgrades throughout! Wood tile greets you in the grand entrance with soaring ceilings. \r\nThe 4 Bedrooms and 3 full bathrooms are tucked away for privacy.  A HUGE owner\'s suite with trayed ceilings will accommodate large furniture and still has plenty of room to move!  Come take a look!  You can\'t beat the in \"eat in\" kitchen which opens to the living/dining area!  Upgraded Fantasy Brown granite adds to the sleek clean look! Backsplash and crown molding (plan specific), front gutters, blinds and garage door opener are STANDARD!   The Adams Homes Moto is  \"The Good life DESERVES a GREAT Home!\"' ,`Acres` = '0.18' ,`Area` = '5' ,`BuilderName` = 'Adams Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA SEC 1 (A0288 HT&BRR) BLK 1 LOT 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7840' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Sierra Vista Sec 1' ,`TaxAmount` = '3144' ,`TaxRate` = '3.605996' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705698' WHERE `Matrix_Unique_ID` = '192112457'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T21:45:15.210' ,`MLSNumber` = '97339068' ,`ListAgentFullName` = 'Anissa Veal' ,`ListOfficeName` = 'AMV Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.077561' ,`Longitude` = '-95.216126' ,`PhotoCount` = '33' ,`PostalCode` = '77365' ,`RoomCount` = '8' ,`ListPrice` = '459000.00' ,`Status` = 'Active' ,`StreetName` = 'Birchwood Springs' ,`StreetNumber` = '25207' ,`StreetSuffix` = 'Avenue' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2866' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**ASSUMABLE LOAN** Westin built with grand 2 story curved staircase.  3 yrs new with lots of extras.  Primary and one add\'l bdrm with en-suite downstairs, perfect for in-laws. Primary bath has whirlpool tub and his & her walk in closets.  Formal dining room is flexible and can be used as dining room or office. Stop in the MUD room before entering main part of house. Spacious kitchen area with over sized island and bar seating. Enjoy the open concept while you cook and entertain with open view to the 2 story family room.  Upstairs are 2 bedrooms with jack/jill bath & separate sinks, and a loft area that can be used for office, craft, play, or sitting area.  Room to expand in large walk in attic.  Nicely sized for media room, bedroom or office, etc.  See attached Seller upgrades list, one of which is a small inground fiberglass pool with LED color changing lights.  Conveniently located to IAH Airport. Enjoy the 4 miles of walking or jogging trails, and peacefulness of wide-open spaces.' ,`Acres` = '0.1653' ,`Area` = '40' ,`BuilderName` = 'WESTIN HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S973604 - WOODRIDGE FOREST 04, BLOCK 5, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '790' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Fiberglass,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'KINGS MANOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodridge Forest 04' ,`TaxAmount` = '10764' ,`TaxRate` = '3.3931' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705698' WHERE `Matrix_Unique_ID` = '208296265'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T21:33:29.410' ,`MLSNumber` = '84655433' ,`ListAgentFullName` = 'Anna Ye' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822110' ,`Longitude` = '-95.747909' ,`PhotoCount` = '28' ,`PostalCode` = '77449' ,`RoomCount` = '8' ,`ListPrice` = '317000.00' ,`Status` = 'Active' ,`StreetName` = 'Coldwater Canyon' ,`StreetNumber` = '3447' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2296' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely REMODELED and FRESH in July-2022. Charming two-story home with 3 Beds and ½ Bath. Master Bedroom Down. NEW PAINT Interior. A/C less than 4 years old. Water Heater less than 4 years old. Open Concept design in a family with a High Ceiling. Cozy Fireplace. Formal Dining. Gourmet kitchen with New Microwave. New Range with Oven. Elegant and durable granite countertop with ceramic tile backsplash. Spacious master bedroom with designable oversize separated shower. Upgrade water faucet and light feature. Double sinks. Family-Friendly game room best for the kid’s entertainment. New carpet on the second flooring. New window blinds, New Light features throughout the house. New Ceiling Fans. Convenient New garage door opener. Large backyard with privacy fence. Lake Subdivision.  Easy to access Highway 99 and Highway I-10 and shopping areas. Great Location!!' ,`Acres` = '0.169' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 4 LAKES OF BRIDGEWATER SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '7362' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '490' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes Bridgewater Sec 02' ,`TaxAmount` = '4997' ,`TaxRate` = '2.8233' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705698' WHERE `Matrix_Unique_ID` = '209850193'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T20:57:32.660' ,`MLSNumber` = '73114434' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.765115' ,`Longitude` = '-95.831299' ,`PhotoCount` = '15' ,`PostalCode` = '77494' ,`RoomCount` = '4' ,`ListPrice` = '637900.00' ,`Status` = 'Active' ,`StreetName` = 'Wooded Hollow' ,`StreetNumber` = '26127' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3968' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, location, location, this gorgeous home is located in beautiful Woodcreek reserve just moments from I-10. Invite friends & spend time relaxing in the stunning home! Have you been searching for the one-of-a-kind home? This is it! You will love cooking and entertaining in this immense kitchen with island prep sink and wait until you see the storage! Hugh covered patio, coffered ceiling in the living room, dining room. Tons of natural light throughout the entire home. Wood floors in the study. Study office with private entry onto patio. The master suite offers a sitting area, stunning closet and extended shower. All three secondary bedrooms are well appointed and one w/en-suite. Zoned to Katy ISD. Excellent shopping, restaurants, and medical facilities nearby. Neighborhood features pool, tennis courts, basketball courts, walking trail and fishing ponds.' ,`Acres` = '0.2406' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WOODCREEK RESERVE SEC 6, BLOCK 2, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10479' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOODCREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodcreek Reserve Sec 6' ,`TaxAmount` = '11922' ,`TaxRate` = '2.8317' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705698' WHERE `Matrix_Unique_ID` = '210280703'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T20:27:44.653' ,`MLSNumber` = '84669435' ,`ListAgentFullName` = 'Monica Humphrey' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.962065' ,`Longitude` = '-95.181647' ,`PhotoCount` = '36' ,`PostalCode` = '77346' ,`RoomCount` = '9' ,`ListPrice` = '548000.00' ,`Status` = 'Active' ,`StreetName` = 'Bornish Hill' ,`StreetNumber` = '16815' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3444' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning Perry Home starts with a dramatic rotunda with spiral staircase and ends with a large covered patio and oversized backyard; big enough for your future pool and outdoor kitchen (renderings in attachments).  This meticulously kept home has 4 bedrooms, a playroom, media room, office (currently being used as a downstairs nursery), and 3 car garage.  The kitchen offers a large island, walk-in pantry, butler\'s pantry, stainless steel appliances, and plenty of storage and countertop space. The primary bedroom is downstairs and is extremally spacious.  The primary bathroom features 2 vanities, 2 walk-in closets, a garden tub, and separate shower.  Downstairs you will also find a mud room/area, laundry room, and half-bath. Upstairs you will find 3 bedrooms, a full bathroom, Hollywood bathroom, game room, media room, and lots of attic space for storage. Residents of The Groves enjoy amenities including: a rec center, pool, splash pad, playgrounds, fishing pond, and walking trails.' ,`Acres` = '0.1813' ,`Area` = '1' ,`BuilderName` = 'Perry' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 3 GROVES SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7897' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '274' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Groves' ,`TaxAmount` = '13796' ,`TaxRate` = '3.5373' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705698' WHERE `Matrix_Unique_ID` = '210398305'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T20:13:10.033' ,`MLSNumber` = '15555762' ,`ListAgentFullName` = 'Angela Rasberry' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.928142' ,`Longitude` = '-94.635618' ,`PhotoCount` = '50' ,`PostalCode` = '75936' ,`RoomCount` = '11' ,`ListPrice` = '854900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2475' ,`StreetNumber` = '306' ,`StreetSuffix` = '' ,`City` = 'Chester' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '4136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This exceptional Log Home offers a CHARACTER-FILLED interior & boasts generous living spaces, bonus room, large game room w/a pool table, glorious fireplace, & soaring ceilings. No expense was spared in this gorgeous kitchen that is equipped w/ a \"Verona Italian\" Gas stove/oven, built in microwave, & stunning kitchen island. Head outside for an adventurous day on this secluded 24 acre ranch completed w/a 9 stall horse barn-2 birthing stalls & tack room are included. Grab your fishing pole & swimsuit & head down to your nearly 3 acre spring fed pond stocked w/Bass,Catfish,& Crappie for a great catch or take a refreshing swim. Unwind on your wrap-around porch while taking in the majestic views of your pond. Plenty of parking w/ a 2 car attached carport that provides a storage area w/ a Category 5 Storm Shelter & a detached 2 car garage w/a porch on each side & a large room above the garage that can easily be converted into guest quarters. Don\'t miss out on this gorgeous home!' ,`Acres` = '24.123' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0003 G. Araujo, Acres 24.123' ,`LotDesciption` = 'Cleared,Water View,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '181 - Chester' ,`SchoolElementary` = 'CHESTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CHESTER HIGH SCHOOL' ,`SchoolMiddle` = 'CHESTER HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'County Road 2475' ,`TaxAmount` = '9259' ,`TaxRate` = '2.0365' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705698' WHERE `Matrix_Unique_ID` = '210535519'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T20:38:13.403' ,`MLSNumber` = '44410026' ,`ListAgentFullName` = 'Robbie Jansky' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472209' ,`Longitude` = '-96.936408' ,`PhotoCount` = '42' ,`PostalCode` = '77964' ,`RoomCount` = '11' ,`ListPrice` = '617550.00' ,`Status` = 'Active' ,`StreetName` = 'US Highway 77' ,`StreetNumber` = '1141' ,`StreetSuffix` = '' ,`City` = 'Hallettsville' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4117' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous custom-built Ranch-style home with over 4,000 square feet of living area consisting of 4 bedrooms, 3.5 bathrooms, chefs gourmet kitchen, office, craft room, dining room, living room, and more! This stunning 2.15-acre property is located just outside the city limits of Hallettsville, Texas and is a prime property with an abundance of features, such as serene and tranquil small-town living, magnificent sunsets, and early morning sunrises. This beautiful home brings the outdoors in with amazing natural lighting features and offers a beautiful, covered porch and backyard patio for that first cup of morning coffee, relaxation and entertaining.  Country living with modern amenities, such as granite countertops, high ceilings, custom built-ins & cabinetry is a rare find. This property is ideally positioned within a few hours of the Texas Gulf Coast and halfway between San Antonio and Houston.' ,`Acres` = '2.15' ,`Area` = '68' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0355 LUKE J PRESNAL & A0006 JAMES CAMPBELL, ACRES 2.1500' ,`LotDesciption` = 'Cleared' ,`LotSize` = '93654' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '179 - Hallettsville' ,`SchoolElementary` = 'HALLETTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HALLETTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'HALLETTSVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Luke Presnall Surv Abs #355' ,`TaxAmount` = '6244' ,`TaxRate` = '1.739' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705699' WHERE `Matrix_Unique_ID` = '210739216'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T21:08:59.967' ,`MLSNumber` = '73439417' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.179002' ,`Longitude` = '-95.518035' ,`PhotoCount` = '11' ,`PostalCode` = '77381' ,`RoomCount` = '4' ,`ListPrice` = '434900.00' ,`Status` = 'Active' ,`StreetName` = 'Stony Bridge' ,`StreetNumber` = '27' ,`StreetSuffix` = 'Court' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1984' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home in Woodlands Village Cochrans Crossing is ready for your family with 4 bedrooms,  2 1/2 baths, two car garage with a covered front porch and a very nice large backyard. Fresh interior paint.  Lots of updates thru out that were completed over the last few years. The kitchen was gorgeously remodeled by the previous owner with replaced cabinets, granite countertops, glass tile backsplash and stainless steel appliances including a refrigerator. All windows and sliding doors were replaced (per previous owner). The Family Room with gas log fireplace is open to the Breakfast Nook and Kitchen, and overlooks the backyard. Home features tile and wood floors throughout. All bathrooms have also been updated.  Newer fixtures. Located across The Woodlands High School and Bear Branch Park. Community features parks, lakes, and playgrounds.  Welcome home!' ,`Acres` = '0.1822' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WDLNDS VIL COCHRANS CR10, BLOCK 4, LOT 74' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7935' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GALATAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodlands Village Cochrans Crossing' ,`TaxAmount` = '4629' ,`TaxRate` = '2.1319' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705699' WHERE `Matrix_Unique_ID` = '210894508'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T21:22:20.030' ,`MLSNumber` = '34814181' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.465805' ,`Longitude` = '-95.048765' ,`PhotoCount` = '9' ,`PostalCode` = '77539' ,`RoomCount` = '3' ,`ListPrice` = '254900.00' ,`Status` = 'Active' ,`StreetName` = 'Rasberry' ,`StreetNumber` = '4006' ,`StreetSuffix` = 'Court' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1422' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Desirable 3 bedroom, 2 bath 1-story home on a corner lot in Berry Field.  Brand NEW ROOF!  Fresh interior paint. Kitchen features granite countertops with stainless appliances (stove, vent hood, dishwasher, and refrigerator). Huge backyard. No carpet here.  Laminate wood and tile throughout.  Conveniently close to I-45. Easy access to Kemah Boardwalk and Space Center. Move in today!' ,`Acres` = '0.165' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BERRY FIELD SUB (2005) ABST 19, BLOCK 4, LOT 13, ACRES 0.165' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '7186' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SILBERNAGEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Berry Field' ,`TaxAmount` = '4962' ,`TaxRate` = '2.5214' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705699' WHERE `Matrix_Unique_ID` = '211115080'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T21:28:01.193' ,`MLSNumber` = '33506615' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.561995' ,`Longitude` = '-95.336017' ,`PhotoCount` = '11' ,`PostalCode` = '77581' ,`RoomCount` = '5' ,`ListPrice` = '354900.00' ,`Status` = 'Active' ,`StreetName` = 'Waterlilly' ,`StreetNumber` = '7504' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2122' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic one-story home in Avalon Terrace is move in ready! Desirable 4 bedroom floor plan with office.  Fresh interior paint. Brand new Luxury Vinyl Plank flooring in the living room and dining room. New carpet in bedrooms. The kitchen features granite countertops with an oversized island/breakfast bar and all stainless appliances (stove, microwave, and brand new dishwasher). Primary bedroom is spacious and features an adjoining bathrfoom with dual sinks, soaking tub and separate shower.  Fenced Backyard with covered porch and patio to provide outdoor living space. Conveniently located close to 288 and Sam Houston Tollway.' ,`Acres` = '0.1515' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON TERRACE SEC 1 (A0505 H T & B), BLOCK 4, LOT 37' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6599' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'LAWHON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH WEST' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Avalon Terrace' ,`TaxAmount` = '6891' ,`TaxRate` = '2.6537' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705699' WHERE `Matrix_Unique_ID` = '211119480'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T21:28:26.620' ,`MLSNumber` = '78212612' ,`ListAgentFullName` = 'Anna Ye' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.794000' ,`Longitude` = '-95.742208' ,`PhotoCount` = '28' ,`PostalCode` = '77449' ,`RoomCount` = '7' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Windsor Hollow' ,`StreetNumber` = '20931' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2072' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous home with 3 bedrooms 2 and ½ bathrooms. Completely remodeled and FRESH, move-in Ready home! A/C in the year 2017. Water heater less than 3 years old. NEW interior paint including doors. Baseboard and trim. Large family room with high ceiling. 13”x 13” tile flooring throughout the first floor. The open gourmet Kitchen overlooks to living area. NEW range with oven. Lots of kitchen cabinets with many storage spaces. NEW nature color carpet on the second floor. Comfy Master bedroom with Laminated wood flooring. Best master bathroom with double sinks. Separated shower with garden tub. Large walk-in Closet. The most amazing video game room ideas for kids and friends’ fun place. Landry Room downstairs. Ceiling fans. Great location to access I-10 Freeway and Highway 99, and shopping areas. Low property taxes rate!' ,`Acres` = '0.1138' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 3 CASTLE ROCK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4956' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '455' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'FRANZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MORTON RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Castle Rock Sec 2' ,`TaxAmount` = '5079' ,`TaxRate` = '2.502' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705699' WHERE `Matrix_Unique_ID` = '211556655'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T20:46:13.567' ,`MLSNumber` = '40220136' ,`ListAgentFullName` = 'Leticia Gomez' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.850314' ,`Longitude` = '-95.648165' ,`PhotoCount` = '14' ,`PostalCode` = '77084' ,`RoomCount` = '4' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Lanesborough' ,`StreetNumber` = '16414' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2674' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Impeccable maintained property to call home! This stunning 2 story in Berkshire Place is move in ready. The open floor plan to the kitchen is great for your indoor entertainments. But you don\'t want to miss your outdoor patio. It\'s great for your outdoor entertainments or to enjoy your cup of coffee every morning.' ,`Acres` = '0.1265' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 2 BERKSHIRE PLACE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5510' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '725' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LIEDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'BERKSHIRE PLACE' ,`TaxAmount` = '7044' ,`TaxRate` = '2.601' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705699' WHERE `Matrix_Unique_ID` = '211860156'  --> 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','211990282','1663705699','211990282','2022-09-01T21:53:10.317','82422641','Stanley George','Realty Associates','','','29.736330','-95.295569','11','77011','6','329000.00','Active','Avenue E','7236','Street','Houston','2','1','3','1412','Single-Family','Brand new home in the historic Magnolia Park neighborhood of the Greater East End. Home is currently under construction, and offers 3 bedrooms, 2.5 bathrooms, with a 1-car attached garage. The first floor of the home features a spacious Kitchen with solid-wood cabinetry, quartz countertop, and a waterfall island which opens up to a large Living and Dining area. The Primary Bedroom offers 2 walk-in closets, and the Primary Bathroom features a double-sink vanity, freestanding soaking tub and a separate, large shower. The Utility Room is located on the second floor conveniently near all bedrooms. The home is prewired for both exterior surveillance cameras, and ethernet in all bedrooms for a reliable internet connection. Please note that renderings are for concept only. Colors and finishes may vary. The area is being revitalized with many new homes and businesses; the new 150-acre East River project is just minutes away and features restaurants, bike trails, and shopping.','','4','Bayou Hawthorn Const','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','East End Revitalized','Central Gas','0','LTS 43 BLK 29 MAGNOLIA PARK SEC 2','Cleared','2500','Survey','','','1','To Be Built/Under Construction','1','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','27 - Houston','GALLEGOS ELEMENTARY SCHOOL (HOUSTON)','AUSTIN HIGH SCHOOL (HOUSTON)','EDISON MIDDLE SCHOOL','Appointment Required,Request Online Appointment','Builder','2','Contemporary/Modern,Craftsman,Split Level,Traditional','Magnolia Park','','2.3307','Public Sewer,Public Water','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','212102843','1663705699','212102843','2022-09-01T20:34:15.460','54047154','Shean Manickchan','United Real Estate','','','29.602248','-95.493871','15','77489','8','239000.00','Active','Towerview','7115','Lane','Houston','2','0','4','1869','Single-Family','Great starter home or investment opportunity. This beautiful home is nestled away in the Briargate neighborhood just minutes away from the Fort Bend toll rd. and Sam Houston Pkwy. This 4-bedroom 2 bath home sits on a corner lot of the Cul de sac and features granite counter tops in the kitchen and bathrooms. Recently updated tile and laminate flooring throughout the home. Did not flood. Home sold as is. Home is vacant. Make an appointment today!','0.2004','38','','','Washer Connections','','Sellers Disclosure,Tenant Occupied','1','','1','Missouri City Area','Central Gas','1','BRIARGATE SEC 2, BLOCK 6, LOT 15','Corner,Cul-De-Sac,Subdivision Lot','8730','Appraisal District','','144','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','19 - Fort Bend','BRIARGATE ELEMENTARY SCHOOL','WILLOWRIDGE HIGH SCHOOL','MCAULIFFE MIDDLE SCHOOL','Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Briargate','3841','2.2137','Public Sewer,Public Water','1972','Appraisal District');  --> New record created successfully<br />