Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T10:28:48.500' ,`MLSNumber` = '82175523' ,`ListAgentFullName` = 'Angela Heiman' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.292997' ,`Longitude` = '-95.735983' ,`PhotoCount` = '18' ,`PostalCode` = '77430' ,`RoomCount` = '3' ,`ListPrice` = '90000.00' ,`Status` = 'Active' ,`StreetName` = 'Railroad St County Rd 264m' ,`StreetNumber` = '3406' ,`StreetSuffix` = '' ,`City` = 'Damon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a nice 3/2 single wide in the heart of Damon right behind the feedstore. house has wood lament floors in living and bedrooms and an open concept kitchen/living space.  house has been cared for and maintained nicely. \r\nThe home has a concreted cover front porch to sit out under and enjoy the day in the shade. Come take a look before it is gone. Zoned and bused to Needville High School.  the community does a lot for one another in this small town. Home is not windstorm 2 certified. Seller purchased home in 2017 used.' ,`Acres` = '0.155' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'RR (DAMON) BLK 1 LOT 2 MH DESIGNATED AS REAL PROPERTY S# 125' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6752' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '14 - Damon' ,`SchoolElementary` = 'DAMON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAMON HIGH SCHOOL' ,`SchoolMiddle` = 'DAMON ELEMENTARY SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '0' ,`Style` = 'Traditional' ,`Subdivision` = 'Rr Damon' ,`TaxAmount` = '441' ,`TaxRate` = '1.5443' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086439' WHERE `Matrix_Unique_ID` = '208193342'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T09:48:06.720' ,`MLSNumber` = '11937533' ,`ListAgentFullName` = 'Janie Schmidt' ,`ListOfficeName` = 'ST Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.624304' ,`Longitude` = '-95.203847' ,`PhotoCount` = '19' ,`PostalCode` = '77034' ,`RoomCount` = '3' ,`ListPrice` = '274900.00' ,`Status` = 'Active' ,`StreetName` = 'Palmbeach' ,`StreetNumber` = '12410' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1663' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 12410 Palm Beach! You new home awaits nestled in one of Houston\'s up and coming neighborhoods. You will find endless updates in this home and pride of ownership shows throughout.  Important updates include, upgraded HVAC 2018, Entire home generator installed recently, Entire home water filtration system 2019, Recent Roof, Plumbing replaced in 2007, Upgraded windows, updated water heater, and the list goes on and on.  Special features include a spacious warehouse which would be a mechanic\'s dream or has potential for other uses. This is a special home located in the perfect area and minutes from major freeways of 45 N and Beltway. Only a 15 minute drive to Downtown Houston.  Do not miss out on this great opportunity.' ,`Acres` = '0.1791' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 17 GULF PALMS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'GENOA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PASADENA)' ,`SchoolMiddle` = 'BONDY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gulf Palms Sec 02' ,`TaxAmount` = '3552' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086439' WHERE `Matrix_Unique_ID` = '209586919'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T09:07:08.540' ,`MLSNumber` = '45655355' ,`ListAgentFullName` = 'Misti Bruton' ,`ListOfficeName` = 'AVO Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.756685' ,`Longitude` = '-98.359033' ,`PhotoCount` = '23' ,`PostalCode` = '78163' ,`RoomCount` = '9' ,`ListPrice` = '875000.00' ,`Status` = 'Active' ,`StreetName` = 'Preakness' ,`StreetNumber` = '6542' ,`StreetSuffix` = 'Pass' ,`City` = 'Bulverde' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '2035' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing custom log home with breathtaking, unobstructed views of Downtown San Antonio! Large, open floor plan with high ceilings, gourmet kitchen and laundry room. XL primary bedroom with sitting area and an en-suite bath with separate sinks. There is a separate guest house with a bedroom, private bath, living room and kitchen. Perfect for guests or an in-law suite. From the side and back porch, enjoy the breathtaking hill country and panoramic view of downtown San Antonio. If you are looking for the one, this is it! Schedule your showing today!' ,`Acres` = '2' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'RIM ROCK RANCH 2, LOT 255' ,`LotDesciption` = 'Other,Wooded' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground,Heated' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '141 - Comal' ,`SchoolElementary` = 'JOHNSON RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SMITHSON VALLEY HIGH SCHOOL' ,`SchoolMiddle` = 'SMITHSON VALLEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Rim Rock Ranch 2' ,`TaxAmount` = '7139' ,`TaxRate` = '1.8256' ,`WaterSewer` = 'Other Water/Sewer,Septic Tank' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086439' WHERE `Matrix_Unique_ID` = '210729896'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T09:12:25.850' ,`MLSNumber` = '42137577' ,`ListAgentFullName` = 'Samantha Savage' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.880446' ,`Longitude` = '-94.224625' ,`PhotoCount` = '12' ,`PostalCode` = '77705' ,`RoomCount` = '8' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Patterson' ,`StreetNumber` = '7271' ,`StreetSuffix` = 'Road' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1791' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy the serenity of Fannett in this beautiful 3 bed 2 bath home. Built in 2010, this 4 side brick house is nestled on over 0.58 acres. Don’t like dealing with an HOA? No problem! Here on Patterson Road, the neighbors all work together to maintain the beauty and peacefulness that Fannett has to offer. Recessed ceilings in the primary bedroom and living room bring more than a touch of elegance to this home. Primary bathroom hosts a private water closet as well as two separate walk in closets. Snuggle up this winter season by the wood burning fireplace in the oversized Living / Family room or step outside to relish in having no back neighbors and a covered porch overlooking a natural habitat of trees and greenery. If you’re looking to get away from all the noise that city life brings, look no further! This home comes practically move in ready with new appliances including refrigerator, dishwasher, washer and dryer!' ,`Acres` = '0.5861' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LONE STAR LANDING LOT 4 .590' ,`LotDesciption` = 'Cleared' ,`LotSize` = '25531' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '110 - Hamshire-Fannett' ,`SchoolElementary` = 'HAMSHIRE-FANNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HAMSHIRE-FANNETT HIGH SCHOOL' ,`SchoolMiddle` = 'HAMSHIRE-FANNETT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lone Star Landing' ,`TaxAmount` = '4289' ,`TaxRate` = '2.0652' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086440' WHERE `Matrix_Unique_ID` = '212179899'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T10:51:51.227' ,`MLSNumber` = '6825606' ,`ListAgentFullName` = 'Ace Hernandez' ,`ListOfficeName` = 'Manor Lane Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.476176' ,`Longitude` = '-95.817754' ,`PhotoCount` = '50' ,`PostalCode` = '77471' ,`RoomCount` = '8' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Gerken' ,`StreetNumber` = '5638' ,`StreetSuffix` = 'Road' ,`City` = 'Pleak' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2063' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ideal corner property for easy access to both South/North of Hwy 59 off of Spur 10 or Hwy 36 heading toward Freeport. \r\nHome has lots of potential, the outdoors offers an in-ground swimming pool, covered patio and storage shed and pool 1/2 bath. \r\nThe interior has an open concept for family living, a wood burning fireplace, an island for entertaining, high ceilings also offers 3 -4 bedrooms or extra room can be an office depending on your needs.' ,`Acres` = '1.0823' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BIG CREEK RURAL ESTATE, BLOCK C, LOT 3, ACRES 1, (PT) LOT 4,' ,`LotDesciption` = 'Corner' ,`LotSize` = '47146' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Big Creek Rural Estate' ,`TaxAmount` = '2614' ,`TaxRate` = '1.7948' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086440' WHERE `Matrix_Unique_ID` = '213672610'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T10:48:52.580' ,`MLSNumber` = '98322495' ,`ListAgentFullName` = 'Hector Salguero' ,`ListOfficeName` = 'RE/MAX Pearland' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.878722' ,`Longitude` = '-95.282103' ,`PhotoCount` = '50' ,`PostalCode` = '77016' ,`RoomCount` = '7' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Pittswood' ,`StreetNumber` = '7134' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1127' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Attention buyers! Look no further, this beautiful freshly remodeled home has everything you want and need, numerous updates and upgrades include a fairly plumbing system, beautiful tile throughout, no carpet; both bathrooms have been remodeled, new paint, nice kitchen, huge backyard, storage building in the backyard, oversized two car garage addtional oversized two car carport completely enclosed and secured; great curb appeal. Call and make your appointment today! you won\'t be disappointed.' ,`Acres` = '0.1515' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 228 BLK 7 NORTHWOOD MANOR SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northwood Manor Sec 08' ,`TaxAmount` = '2551' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086440' WHERE `Matrix_Unique_ID` = '213913395'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T09:02:10.573' ,`MLSNumber` = '20468237' ,`ListAgentFullName` = 'Luke Moses' ,`ListOfficeName` = 'Loft Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.917507' ,`Longitude` = '-93.950724' ,`PhotoCount` = '31' ,`PostalCode` = '77642' ,`RoomCount` = '4' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Big Bend' ,`StreetNumber` = '4301' ,`StreetSuffix` = 'Avenue' ,`City` = 'Port Arthur' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2156' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mid-Century modern in charming Port Arthur neighborhood.  Home has 4 bedrooms, 2 full baths with large living and dining rooms with beautiful vinyl floors throughout.  A must see!' ,`Acres` = '0.1928' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 26 PARK PLACE 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '236 - Port Arthur' ,`SchoolElementary` = 'HOUSTON ELEMENTARY SCHOOL (PORT ARTHUR)' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PORT ARTHUR)' ,`SchoolMiddle` = 'LINCOLN MIDDLE SCHOOL (PORT ARTHUR)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Park Place To Port Arthur' ,`TaxAmount` = '2692' ,`TaxRate` = '3.267' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086440' WHERE `Matrix_Unique_ID` = '214169780'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T09:10:59.023' ,`MLSNumber` = '10797212' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.946693' ,`Longitude` = '-95.312320' ,`PhotoCount` = '41' ,`PostalCode` = '75862' ,`RoomCount` = '9' ,`ListPrice` = '850000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeway' ,`StreetNumber` = '101' ,`StreetSuffix` = 'Drive' ,`City` = 'Trinity' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 3-story 4 bed 4 bath waterfront home situated in the Westwood Shores community! This home features breathtaking lake views, high ceilings, water-proof wood plank vinyl floors, and a PVE elevator! The 2nd story boasts an open concept living/dining area with access to the balcony. The kitchen flaunts quartz countertops, a large island, double ovens + a built in electric induction cooktop, & an abundance of cabinet and counter space, walk-in pantry + breakfast area and a forced air wood-burning fireplace in the family room! There is also two bedrooms with a connecting Jack & Jill bathroom. The oversized primary bedroom is located on the 3rd story and features access to the balcony overlooking the water and an en-suite bath with dual sinks, a separate shower + soaking tub and a massive closet. The first story has a large flex space + a full bath. Exterior features include 2 balcony\'s, oversized garage, and a 8x16 deck being built with access to the lake. Schedule a tour today!' ,`Acres` = '0.0846' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 12, BLOCK 6 LOT 33' ,`LotDesciption` = 'Cleared,In Golf Course Community,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '3687' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '178' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Shores' ,`TaxAmount` = '11024' ,`TaxRate` = '2.5863' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675086441' WHERE `Matrix_Unique_ID` = '214581130'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T10:49:25.433' ,`MLSNumber` = '13887567' ,`ListAgentFullName` = 'Jeronimo Guerrero' ,`ListOfficeName` = 'Lucky Money Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.247726' ,`Longitude` = '-95.544833' ,`PhotoCount` = '11' ,`PostalCode` = '77384' ,`RoomCount` = '12' ,`ListPrice` = '829500.00' ,`Status` = 'Active' ,`StreetName` = 'W Forest Ct' ,`StreetNumber` = '5' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3340' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**ESTIMATED DELIVERY: DECEMBER** Beautiful modern farmhouse design at Lake Forest Subdivision. ** Low Tax Rate ** Zoned to highly acclaimed schools such as The Woodlands High School, close to parks and restaurants, and easy access to I-45, located in a quiet neighborhood surrounded by trees. This spacious two-story home with three bedrooms and 3.5 bathrooms, plus an office, TV room, an a huge game room/extra room upstairs. It will be completed in September 2022. Many upgrades throughout, such as top of the line countertops, stainless steel appliances, wood flooring, spacious bedrooms, and an open floor plan, are perfectly laid out. Great front porch. Massive rear covered patio with summer kitchen.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Urbanika Const.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22 Block 1 Lake Creek Forest Section 1 Montgomery TX' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '21780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '265' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Lake Creek Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086441' WHERE `Matrix_Unique_ID` = '214699476'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T09:37:09.743' ,`MLSNumber` = '8773867' ,`ListAgentFullName` = 'Tanovia Cossey' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.836489' ,`Longitude` = '-95.318040' ,`PhotoCount` = '7' ,`PostalCode` = '77016' ,`RoomCount` = '4' ,`ListPrice` = '120000.00' ,`Status` = 'Active' ,`StreetName` = 'Jones' ,`StreetNumber` = '4917' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1421' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investment property, fixer upper, sold as is. Buyer to provide survey. Room dimensions approx. Please verify.' ,`Acres` = '0.1263' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 8 FOREST LAWN' ,`LotDesciption` = 'Other' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'COOK ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Forest Lawn' ,`TaxAmount` = '1691' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086441' WHERE `Matrix_Unique_ID` = '214919712'  --> 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','215213443','1675086441','215213443','2022-12-02T10:50:12.810','92290543','Cyndi Kornegay','Gatehouse Properties','','','30.159372','-95.404081','10','77385','8','374180.00','Active','Meadow View','2735','Lane','Conroe','2','1','3','1855','Single-Family','Welcome home to this charming one-story design. At the heart of the home, you will discover the open concept layout in the family room, dining and kitchen. The gourmet kitchen boasts a large granite island, 42-inch cabinets and stainless-steel appliances, perfect for the chef of the house. This home has 3 bedrooms, 2 full bathrooms, a powder room, and a perfectly situated study with French doors. The primary bedroom is secluded at the back of the home complemented by beautiful bowed windows and a primary bath that features a separate shower and tub and double sinks. This home is certified Environments for Living and offers some of the highest energy features available today. Come visit this beautiful home today!','','15','Coventry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','0','Spring Northeast','Central Gas','1','Lot 8 Block 1','Subdivision Lot','40','Survey','','600','1','To Be Built/Under Construction','2','Electric Oven','0','','','Freestanding Range','','Composition','11 - Conroe','KAUFMAN ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','1','Traditional','The Meadows at Imperial Oaks','','3.3','Water District','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','215274216','1675086441','215274216','2022-12-02T10:57:21.813','72450701','Erika Trevino','HomeSmart','','','30.019916','-95.321665','30','77338','9','480000.00','Active','Quartz Creek','20702','Lane','Humble','3','1','6','3702','Single-Family','Welcome to 20702 Quartz Creek Ln in Humble, TX. This  3,702sq ft, 6 bedroom, and 3.5 bathroom is an immaculately cared for home. This wonderful home sits on a quiet cul-de-sac lot with a spacious backyard,  privacy fence and garden. This home comes with TWO laundry area - one laundry room upstairs and connections for the option to do laundry downstairs! The backyard patio has a cement extension to buildout a beautiful backyard lounging area and bring to life your very own backyard oasis! Definitely a hidden gem!','0.2632','12','Long Lake','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','HOA First Right of Refusal,Mud,Sellers Disclosure','1','Gas Connections','1','Humble Area West','Central Gas','1','LT 28 BLK 1 CYPRESSWOOD POINT SEC 5','Cul-De-Sac','11465','Appraisal District','','310','0','','3','Freestanding Oven','0','','','Gas Cooktop','','Composition','1 - Aldine','CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','JONES MIDDLE SCHOOL (ALDINE)','Accompany,Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','Cypresswood Point Sec 5','7483','2.7734','Public Sewer,Water District','2014','Appraisal District');  --> New record created successfully<br />