Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
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)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T18:07:13.150' ,`MLSNumber` = '6721223' ,`ListAgentFullName` = 'Nancy Macias-Morales' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.784533' ,`Longitude` = '-94.941885' ,`PhotoCount` = '37' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '419800.00' ,`Status` = 'Active' ,`StreetName` = 'Sylvan' ,`StreetNumber` = '2314' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2127' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CLASSIC COMFORT WITH CONTEMPORARY CONVENIENCES.A TRUE RARE FIND!ONE STORY 3/2 + SITTING ON 2.35 ACRES OF LAND WITH NO DEED RESTRICTIONS-FEATURES INCLUDE PRIVATE ENTRANCE MANNED GATE-FULLY FENCED IN-LONG DOUBLE WIDE DRIVEWAY*GORGEOUS KITCHEN WITH A MODERN TWIST, GRANITE COUNTERTOPS, SS APPLIANCES, PLENTY OF STORAGE AND OPENS RIGHT INTO THE OPEN CONCEPT LIVING AREA*EXTENSIVE CERAMIC TILE FLOORS*INVITING ENTRY*LARGE YET ELEGANT FORMAL DINING ROOM W/BUILT IN BUFFET-LIVING AREA WITH A GAS CENTERED FIREPLACE*PRIVATE SUNROOM OFF OF LIVING ROOM THAT CAN BE USED FOR GAMEROOM OR OFFICE* IMPRESSIVE PRIMARY SUITE AND SPACIOUS SECONDARY BEDROOMS-BACKYARD OFFERS A LARGE CANOPY WITH A CUSTOM BUILT OVEN- A FEW AREAS IN BACK ARE SET FOR SMALL LIVESTOCK AND PLENTY OF YARD SPACE TO ENJOY*DETACHED CAR GARAGE IS LARGE ENOUGH FOR ALL YOUR TOOLS & COVERED CARPORT & PRIVATE HALF BATH- - EZ ACCESS TO MAJOR ROADS* SCHOOLS*COMMERCE*NO HOA, NO MUD TAX & LOW TAX RATES!COME SEE FOR YOURSELF. IT\'S AN AMAZING BUY!!' ,`Acres` = '2.35' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 35 & 36 GARDEN TERRACE U/R' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '102366' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Garden Terrace' ,`TaxAmount` = '5449' ,`TaxRate` = '2.285' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702573' WHERE `Matrix_Unique_ID` = '208766689' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T18:35:38.897' ,`MLSNumber` = '38811454' ,`ListAgentFullName` = 'Philip Rayos' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.639835' ,`Longitude` = '-95.258175' ,`PhotoCount` = '31' ,`PostalCode` = '77075' ,`RoomCount` = '8' ,`ListPrice` = '249800.00' ,`Status` = 'Active' ,`StreetName` = 'Edgebrook' ,`StreetNumber` = '8902' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1637' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautifully updated home. As you walk in you will notice brand new waterproof vinyl flooring in all the bedrooms, fresh paint, and new ceiling fans throughout the house. Brand new stainless appliances are featured in the kitchen. There are also brand new fixtures installed in the bathrooms. Conveniently located close to I-45, come check this house out before it\'s gone.' ,`Acres` = '0.0781' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 EDGEBROOK PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'JESSUP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHHOUSTON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Edgebrook Place' ,`TaxAmount` = '5038' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702573' WHERE `Matrix_Unique_ID` = '209124535' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T18:14:39.200' ,`MLSNumber` = '6221351' ,`ListAgentFullName` = 'Korina Carnes' ,`ListOfficeName` = 'Kodu Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.135872' ,`Longitude` = '-95.039484' ,`PhotoCount` = '22' ,`PostalCode` = '77327' ,`RoomCount` = '5' ,`ListPrice` = '179900.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5202' ,`StreetNumber` = '804' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1904' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very motivated seller, in this fast growing area now has quick access 99 The Grand Parkway & HWY 59. In less than 15 minutes you can be shopping in Kroger\'s Market Place, Academy, Hobby Lobby, TJ Max and much more or enjoy a delicious restaurant with some desert. ONLY 25 minutes from Spring, Splendora, Kingwood and 35 minutes to The Woodlands Mall. This home sits on an acre with a 2020 4 bedroom 2 bath double wide mobile home. This home is FHA Approved and the home is outside of a flood zone. Seller is providing a elevation certificate. This home has never flooded. Call for questions or to schedule your tour.' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SANTA FE, SEC 4, BLOCK 63, LOT 5916 and 5917' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '45517' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe Sec 4' ,`TaxAmount` = '1424' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702574' WHERE `Matrix_Unique_ID` = '209344339' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T19:14:18.780' ,`MLSNumber` = '12069773' ,`ListAgentFullName` = 'Suzanne Heinrich' ,`ListOfficeName` = 'Main Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.814116' ,`Longitude` = '-94.839094' ,`PhotoCount` = '38' ,`PostalCode` = '77523' ,`RoomCount` = '5' ,`ListPrice` = '274500.00' ,`Status` = 'Active' ,`StreetName` = 'Snapping Turtle' ,`StreetNumber` = '5515' ,`StreetSuffix` = 'Road' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2326' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A must see! Come take at look at this updated, move-in ready, 4 bedrooms, 2.5 bathrooms, 2 car garage home in Barbers Hill ISD. New paint and flooring throughout, with waterproof wood-look vinyl on the first floor and new carpet on the second floor. This home features a water filtration system for the entire house and a reserve osmosis filter system in the kitchen. The open concept living area downstairs, secondary living area upstairs and fully fenced backyard make this home perfect for entertaining. Green space behind the house, so no backyard neighbors. Quick access to I-10 and Hwy 146 make for an easy commute to Baytown, Houston, or Beaumont. A neighborhood park and paved sidewalks are a bonus. This home is a short drive from local schools, restaurants, and shopping. Schedule your private showing today.' ,`Acres` = '0.126' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 33 BK 3 JOSEPHS COVE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5489' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Joseph\'s Cove' ,`TaxAmount` = '4431' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702574' WHERE `Matrix_Unique_ID` = '210089790' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T19:49:38.380' ,`MLSNumber` = '23778430' ,`ListAgentFullName` = 'Marcela Martinez' ,`ListOfficeName` = 'Blackshear Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.820942' ,`Longitude` = '-94.975510' ,`PhotoCount` = '43' ,`PostalCode` = '77521' ,`RoomCount` = '12' ,`ListPrice` = '289999.00' ,`Status` = 'Active' ,`StreetName` = 'Bay Leaf' ,`StreetNumber` = '5622' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2673' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HOME SWEET HOME!! 2 story Home, 4 bedrooms, 2 and half baths and 2 car garage! New roof was installed 2021 and new water heater. Beautiful wood flooring on living room, formal dinning, office, primary bedroom and one other bedroom from upstairs. All other bedrooms with good size closets. Game room upstairs. \r\nFormal dinning with high ceilings giving a dramatic entrance; private office to the left side with wood flooring; kitchen with a large walk-in pantry. Formal dinning room and living room are separated by 3 nice and elegant arches offering an open but also private feel to each space. Gas fire place on living room to add a cosy feel to those winter months. And at last we have a good size yard to enjoy hot summer with family gathers. This gorgeous home is waiting for you, stop today and schedule an appointment now! Home Sweet Home.' ,`Acres` = '0.1566' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 73 SPRINGFIELD ESTATES SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '340' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'VICTORIA WALKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Springfield Estates Sec 05' ,`TaxAmount` = '7120' ,`TaxRate` = '3.095' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702574' WHERE `Matrix_Unique_ID` = '210205036' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T19:15:34.000' ,`MLSNumber` = '73122708' ,`ListAgentFullName` = 'Enriqueta Azuara' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = 'Marlein Martinez' ,`SellingOfficeName` = 'RE/MAX Real Estate Assoc.' ,`Latitude` = '29.808618' ,`Longitude` = '-94.928318' ,`PhotoCount` = '50' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '295000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Hunters Way' ,`StreetNumber` = '6731' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2833' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! From the moment you walk through the front door you will know that this is the one! High ceilings and open floorplan will greet you from the moment you enter the house. Beautiful maple cabinets, granite countertops in kitchen. Double sinks and huge walk in closet, separate tub and shower in primary bath. Activity room and secondary bedrooms upstairs.' ,`Acres` = '0.1484' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 8 HUNTERS CREEK SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '6464' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Crk Sec 1' ,`TaxAmount` = '9126' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702574' WHERE `Matrix_Unique_ID` = '211187213' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T19:09:40.313' ,`MLSNumber` = '60838234' ,`ListAgentFullName` = 'Paul Hunter' ,`ListOfficeName` = 'One Plus Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.337768' ,`Longitude` = '-95.552684' ,`PhotoCount` = '21' ,`PostalCode` = '77304' ,`RoomCount` = '8' ,`ListPrice` = '129990.00' ,`Status` = 'Active' ,`StreetName` = 'Westcreek' ,`StreetNumber` = '1500' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Double wide mobile home that has been sheetrocked, taped and floated so it looks like a stick built home on the inside. Insulated metal roof and double pane windows. French doors lead from dining room out to covered deck. Big lot with fenced yard and outside storage building. Not far from Lake Conroe but close to town in this quiet and mostly built out subdivision of clean homes. \r\nLow taxes and good schools. No HOA fees.this is inexpensive living!\r\nGas cooking.\r\n\r\n\r\n\r\n \r\n\r\n \'\'Oak\'\' laminate in living room and \'\'oak\'\' laminate in bedrooms. Ceiling fans in bedrooms, living room, and kitchen' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LAKE CONROE WEST-WEST CRK, LOT 84, MH SER' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18501' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'LAKE CONROE W-W CRK' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702574' WHERE `Matrix_Unique_ID` = '211491642' --> Updated record success