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-18T16:10:47.030' ,`MLSNumber` = '88848395' ,`ListAgentFullName` = 'Darla Ortiz' ,`ListOfficeName` = 'Colesio Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.981089' ,`Longitude` = '-95.955253' ,`PhotoCount` = '14' ,`PostalCode` = '77414' ,`RoomCount` = '4' ,`ListPrice` = '237900.00' ,`Status` = 'Active' ,`StreetName` = '5th' ,`StreetNumber` = '2920' ,`StreetSuffix` = 'Street' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1676' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful STILL UNDER CONSTRUCTION, 2-story home located 2 blocks from Tennie Holmes Elementary in the heart of Bay City, Texas! This home has 4 bedrooms, 2 1/2 bath w/ a 2 car garage, giving you 1676 sq. ft. of spacious wonderful living. Downstairs you will find designer waterproof vinyl plank flooring & LED lighting throughout, an open concept for living area, dining & kitchen. Enjoy your cooking in a modern gourmet kitchen w/ brand name stainless steel appliances, tiled backsplash, along w/ solid granite countertops & nickel brushed hardware. Upstairs you can relax in your spacious Master Bedroom w/master bath & walk in closet. All bedrooms are upstairs & have carpet. This home is all electric, w/low E insulated energy efficient windows, 16-Seer Air Conditioning System, fresh air filtration, Sherwin Williams designer paint on walls & ceilings. Estimated date of completion of home is July 31, 2022.***Warranty: 1 year workmanship, 2-year mechanical, 10-year structural.' ,`Acres` = '0.1722' ,`Area` = '54' ,`BuilderName` = 'AWARD Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MAGILLS S/D LOTS 6 BLK 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = '' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Magills Addition' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700269' WHERE `Matrix_Unique_ID` = '208470096' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T16:08:55.183' ,`MLSNumber` = '2684435' ,`ListAgentFullName` = 'Shari Baird' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.949077' ,`Longitude` = '-95.361146' ,`PhotoCount` = '20' ,`PostalCode` = '77541' ,`RoomCount` = '5' ,`ListPrice` = '435000.00' ,`Status` = 'Active' ,`StreetName` = '7th' ,`StreetNumber` = '1023' ,`StreetSuffix` = 'Street' ,`City` = 'Freeport' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4587' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Remarkable find!\r\nThis gracious 4587 Sq ft home offers an abundance of space for everyone. 5 bedrooms, 3 full baths, an oversized family room with 3 sitting areas, an office, two dining areas, a large kitchen with lots of storage. A utility room, a bonus room that can be used as a flex or craft room, a double car garage along with a port cochere. Two patio areas for entertaining family and friends. This home would make a great multi-generational home or plenty room to operate a home-based business. Come tour this home and see all it has to offer. Contact the agent today.' ,`Acres` = '0.4821' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'FREEPORT, BLOCK 120, LOT 2-3-4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '21000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'FLEMING ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Freeport' ,`TaxAmount` = '4716' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700270' WHERE `Matrix_Unique_ID` = '208753984' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T16:43:10.157' ,`MLSNumber` = '80739679' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.316694' ,`Longitude` = '-95.456773' ,`PhotoCount` = '24' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '549000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeland' ,`StreetNumber` = '1015' ,`StreetSuffix` = 'Circle' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2799' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Malibu in Suncreek Estates! Storage space proves to be no issue with this sprawling three-bedroom, two-and-a-half bathroom home. Upon entering this home, you are met with the long foyer leading directly to your spacious family room with a stylish fireplace that opens up to an integrated kitchen and breakfast area providing for optimal convenience for the entire family and is perfect for hosting gatherings of any size. Your kitchen boasts exclusive features such as a kitchen island with granite countertops, industry-leading appliances, designer light fixtures, and a large pantry. From your breakfast room, you have access to your large covered patio. On the way to your family room are three secondary bedrooms, three walk-in closets, and a full secondary bathroom. On the opposite side of the home resides your private master suite, a powder bathroom, and a sizable walk-in utility room granting you access to your 3-car garage.' ,`Acres` = '1' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18, Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style,Ranch,Traditional' ,`Subdivision` = 'The Oaks at Suncreek Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.069' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700270' WHERE `Matrix_Unique_ID` = '209161941' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T16:45:06.263' ,`MLSNumber` = '77425619' ,`ListAgentFullName` = 'Justin Paden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.275404' ,`Longitude` = '-95.250267' ,`PhotoCount` = '32' ,`PostalCode` = '77577' ,`RoomCount` = '9' ,`ListPrice` = '795000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 730H' ,`StreetNumber` = '718' ,`StreetSuffix` = '' ,`City` = 'Liverpool' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '4125' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful private and secluded Barndominium with over 425 feet of water frontage on Chocolate Bayou! Located in Liverpool TX, this property also offers 12 acres of land and that would make a perfect set up for a gentleman\'s ranch, vacation house, or Air B&B. Escape the big city life but still enjoy the close proximity to Houston and the newly proposed Grand Parkway. The opportunities are endless for the avid fisherman with your own private boat dock and launch with easy access to West Bay and the Gulf of Mexico. The living space offers beautiful custom wood beams that really gives this retreat the WOW factor as soon as you walk into the gourmet kitchen. Three huge bedrooms that can accommodate an abundance of family and guests. Spa like bathroom in the primary bedroom with a huge walk-in closet. Gorgeous stained concrete floors throughout. Huge workshop with tons of storage above the living area. Outside kitchen and patio overlooking the bayou. DID NOT FLOOD IN HARVEY!' ,`Acres` = '12.03' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0037 S F AUSTIN TRACT 12I ACRES 12.03' ,`LotDesciption` = 'Water View,Waterfront,Wooded' ,`LotSize` = '524027' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'WALT DISNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Barndominium' ,`Subdivision` = 'S F Austin' ,`TaxAmount` = '8575' ,`TaxRate` = '2.2507' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663700270' WHERE `Matrix_Unique_ID` = '210096778' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T16:05:05.620' ,`MLSNumber` = '35711046' ,`ListAgentFullName` = 'Gwendlyn Key Willis' ,`ListOfficeName` = 'Key, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.192586' ,`Longitude` = '-95.184126' ,`PhotoCount` = '16' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine' ,`StreetNumber` = '24761' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1570' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This one is for the handyman. This property flooded in Harvey and Imelda. The interior is down to the studs. Tile flooring throughout looks to be in good condition. There are utilities on in the home. There are no restrictions, No HOA. Low Tax rate.' ,`Acres` = '0.568' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PEACH CREEK COLONY, BLOCK 2, LOT 3,4 AND 20, ACRES1.285' ,`LotDesciption` = 'Corner' ,`LotSize` = '24742' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Peach Creek Colony' ,`TaxAmount` = '1038' ,`TaxRate` = '2.3341' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700270' WHERE `Matrix_Unique_ID` = '210127070' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T16:32:47.440' ,`MLSNumber` = '33702017' ,`ListAgentFullName` = 'Harley Hedgpeth' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811794' ,`Longitude` = '-95.384684' ,`PhotoCount` = '40' ,`PostalCode` = '77009' ,`RoomCount` = '8' ,`ListPrice` = '1000000.00' ,`Status` = 'Active' ,`StreetName` = '27th' ,`StreetNumber` = '1110' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2578' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great investment opportunity in Sunset Heights. Property has three separate rental units that are all leased. You can build additional units. The lot is listed on the tax roll as 1110 E 27th Street, 77009. It is 9,874 sqft with a total of 2,578 sqft between the 3 homes. They all have independent utilities, recent roofs, and two have been recently and updated and the third home needs some updating. They all have central air and heat, refrigerators, ranges, washers and dryers, and dishwashers. The addresses are 1110 & 1114 E 27th Street, 77009.The third home is 2632 Link, 77009 which is a garage apartment. The garage apartment is above an oversized 2 car garage that could be developed into a fourth rental unit. There is also space behind 1114 to build additional units and ample space for parking. Bring your investors / buyers today.\r\n\r\n*******PLEASE INDEPENDENTLY VERIFY ALL ROOM DIMENSIONS, TAXES, AND SCHOOL DISTRICT.********' ,`Acres` = '0.2267' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 2 & 3 BLK 4 SUNSET HEIGHTS EXTN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9874' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Sunset Heights Sec 01 Ext' ,`TaxAmount` = '14075' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663700270' WHERE `Matrix_Unique_ID` = '210190907' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T16:03:32.180' ,`MLSNumber` = '73373437' ,`ListAgentFullName` = 'Nancy McDermand' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.140341' ,`Longitude` = '-94.188878' ,`PhotoCount` = '23' ,`PostalCode` = '77708' ,`RoomCount` = '7' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Griffing' ,`StreetNumber` = '7290' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1855' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUMONT\"S GRIFFING PLACE ADDITION: Home sits on a beautiful large corner lot (100x200). The backyard features a large covered patio provides the perfect area to set up a grill in the Spring/Summer or a firepit in the Fall/Winter. There is plenty of space for the kids or pets to run around the backyard; privacy wood fence. This home has 3 bedrooms, 2 full bathrooms; a 2 car garage. This home has wonderful curb appeal. As you walk through the entryway you will notice the dining room to the left and the stain glass window and now enter into the spacious den you will see the beautiful stone around the wood burning fireplace, high cathedral ceiling, beautiful built-in-cabinet; recess lighting. The kitchen and breakfast room combo, granite countertops, electric range; refrigerator. The primary bedroom is complete with a full bathroom with double sinks, two walk-in closets; bathtub. The second guest bedroom has its on full bathroom. Wood and tile flooring throughout the home.' ,`Acres` = '0.2755' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GRIFFING PLACE L 1 BLK 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'GUESS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'VINCENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Griffing Place' ,`TaxAmount` = '3059' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700270' WHERE `Matrix_Unique_ID` = '210244538' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T17:00:28.353' ,`MLSNumber` = '30714695' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.650879' ,`Longitude` = '-95.533409' ,`PhotoCount` = '30' ,`PostalCode` = '77340' ,`RoomCount` = '3' ,`ListPrice` = '264900.00' ,`Status` = 'Active' ,`StreetName` = 'Lake' ,`StreetNumber` = '1816' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1505' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 3 bed 2 bath home in the Elkins Lake subdivision of Huntsville! Interior features include an oversized family room boasting a brick accent wall, ridge beam, wood burning fireplace, and gorgeous farmhouse doors! The kitchen features butcher block countertops and an abundance of cabinet space for all of your storage needs + an adjacent breakfast room. The primary bedroom is generous in size with a en-suite bath flaunting dual sinks, a massive tiled walk-in shower, as well as a walk-in closet! Exterior features include a fenced-in backyard, back patio, and a2-car attached garage. Community amenities include a two community pools, golf courses, tennis courts, clubhouse, walking trails, and easy access to I-45! Schedule a showing today!' ,`Acres` = '0.2242' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ELKINS LAKE - SEC 3, BLOCK 26, LOT 48' ,`LotDesciption` = 'Cleared,In Golf Course Community,Subdivision Lot' ,`LotSize` = '9765' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '198' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'ESTELLA STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elkins Lake' ,`TaxAmount` = '2455' ,`TaxRate` = '1.9609' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700270' WHERE `Matrix_Unique_ID` = '210945875' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T16:52:00.447' ,`MLSNumber` = '90347679' ,`ListAgentFullName` = 'Kathleen Montes' ,`ListOfficeName` = 'Target Realty, Inc.' ,`SellingAgentFullName` = 'Kelsey Casey' ,`SellingOfficeName` = 'Realty ONE Group Iconic' ,`Latitude` = '30.167924' ,`Longitude` = '-95.445883' ,`PhotoCount` = '47' ,`PostalCode` = '77385' ,`RoomCount` = '6' ,`ListPrice` = '435000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Pine Manor' ,`StreetNumber` = '307' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '2568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This meticulously maintained home in highly sought after Oak Ridge North features an open floor plan with a formal dining room & beautiful laminate flooring. Enjoy cooking in the gorgeous, spacious gourmet kitchen with granite counters, SS appliances, double ovens w/convection, 5 burner gas cooktop, beautiful 42\" soft close cabinets soft close drawers, under cabinet lighting & pot filler. Relax in the primary suite, large enough to have sitting area. Primary bath boasts large tile shower, double vanities, and spacious closet. 2nd bedroom downstairs! Upstairs features 2 large bedrooms & game room. Relax on the covered patio overlooking the lush private backyard. Private ground level garage apt w/ 1/2 bath, perfect for home office or guest quarters! Sprinkler system, custom built-ins, plantation shutters are just a few of the amenities of this home! Roof 2021! Schedule your showing today!' ,`Acres` = '0.2568' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'OAK RIDGE NORTH 10, BLOCK 4, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11188' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'OAK RIDGE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Ridge North 10' ,`TaxAmount` = '5324' ,`TaxRate` = '2.461' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663700271' WHERE `Matrix_Unique_ID` = '211444224' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T17:00:30.317' ,`MLSNumber` = '20137613' ,`ListAgentFullName` = 'Teresa Hoang' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.599071' ,`Longitude` = '-95.395742' ,`PhotoCount` = '34' ,`PostalCode` = '77047' ,`RoomCount` = '8' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Fellows' ,`StreetNumber` = '1718' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home!!! this beautifully remodeled and updated 3 beds 2 baths home comes with a refresh modern touch. Home features new stucco, new roof, new pane windows, new bathrooms, new porcelain tile throughout this 1,500 square foot relaxing and comfortable home. Minutes away from Sam Houston Beltway 8, SH-288, and Pearland city limits. Medical Center, Downtown Houston. and Hobby Airport is only a 10 minute drive from your home. No water bills and low low taxes at 1.77% Perfect opportunity to live close to Downtown Houston, but still have that county living environment. Lots of yard space for playing or gardening. Huge lot which is over 14,508 sq feet. No RESTRICTIONS, and can even use the property for Commercial Development. Don’t wait to see this home. Come see it today!' ,`Acres` = '0.33308' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 23 BLK 1 M L PARKER U/R ABST 881 D WHITE' ,`LotDesciption` = 'Other' ,`LotSize` = '14509' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALMEDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'White David' ,`TaxAmount` = '1230' ,`TaxRate` = '1.7798' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700271' WHERE `Matrix_Unique_ID` = '211446656' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T16:22:16.907' ,`MLSNumber` = '85739942' ,`ListAgentFullName` = 'Eric Garcia' ,`ListOfficeName` = 'Carlos Garcia Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.244194' ,`Longitude` = '-95.893506' ,`PhotoCount` = '36' ,`PostalCode` = '77484' ,`RoomCount` = '4' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Spur Court' ,`StreetNumber` = '17679' ,`StreetSuffix` = '' ,`City` = 'Waller' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2660' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Home in Saddle Creek Forest! Beautiful new home features 4 bedrooms 2.5 baths, primary down, large open family room, island kitchen! Custom built cabinets were built on-site! Carrera marble island and countertops! This gorgeous home is poised on a large corner lot! Sprinkler System! 1.5 Acres! Heavily wooded lot in the quiet community of Saddle Creek Forest! Find yourself tucked away from all the NOISE of the city! Saddle Creek Forest is a beautiful and serene community - perfect for anyone wanting to slow down and enjoy Nature and live that country life that you always dreamed about - now is your chance to make it a reality! Features many mature pines trees, native deer, tranquil creeks, and ponds. Community amenities include an equestrian center, miles of nature trails, fishing lakes, two playgrounds, swimming pool, and sports courts.Located off Hwy 249 and FM 1774, the lot isn’t far from the communities of Magnolia, Tomball, Zoned to Navasota Independent School District.' ,`Acres` = '1.52' ,`Area` = '60' ,`BuilderName` = 'Genesis Homes LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Plantersville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S7644 - SADDLE CREEK FOREST SEC. 4, BLOCK 6, LOT 15, ACRES 1' ,`LotDesciption` = 'Corner,Wooded' ,`LotSize` = '66211' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '775' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'HIGH POINT ELEMENTARY SCHOOL (Navasota)' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Saddle Creek Forest Sec 4' ,`TaxAmount` = '914' ,`TaxRate` = '1.7749' ,`WaterSewer` = 'Other Water/Sewer,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700271' WHERE `Matrix_Unique_ID` = '211539404' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T16:26:40.210' ,`MLSNumber` = '63972109' ,`ListAgentFullName` = 'Lillian Newman' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.778157' ,`Longitude` = '-95.474265' ,`PhotoCount` = '30' ,`PostalCode` = '77024' ,`RoomCount` = '12' ,`ListPrice` = '5795000.00' ,`Status` = 'Active' ,`StreetName` = 'Little John' ,`StreetNumber` = '612' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '3' ,`BedsTotal` = '5' ,`SqFtTotal` = '7871' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Elegant 5 bedroom 6.3 bath private home is situated on over 1.5 wooded lush landscaped acres at the end of a cul-de-sac in Sherwood Forest. An oasis of a property with an oversized lagoon style pool, sand volleyball court and meticulously landscaped grounds. A gardeners paradise. Recently renovated Chef\'s kitchen with tons of storage, 3 ovens, two refrigerators and secondary sink. Oversized dining, large open living spaces with floor to ceiling windows to take in the view of the amazing grounds. All bathrooms recently renovated including primary bath remodeled in 2022 with large walk-in marble shower and free standing soaking tub. Beautifully appointed closets with glass cabinet storage. Most windows replaced in 2020. Laundry room renovated in 2022. Additional features include an air conditioned dog house with long dog run and gardeners shed. Every detail considered in this well appointed and maintained home.' ,`Acres` = '1.58' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial Close In' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 SHERWOOD FOREST SEC B' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '68825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HUNTERS CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sherwood Forest Sec B' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700271' WHERE `Matrix_Unique_ID` = '211582981' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T16:17:37.610' ,`MLSNumber` = '23821719' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.881990' ,`Longitude` = '-106.406703' ,`PhotoCount` = '14' ,`PostalCode` = '79924' ,`RoomCount` = '3' ,`ListPrice` = '129999.00' ,`Status` = 'Active' ,`StreetName` = 'Verbena' ,`StreetNumber` = '9500' ,`StreetSuffix` = 'Drive' ,`City` = 'El Paso' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1106' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice brick home with 3 bedroom, 2 bathroom, and 1-carport. Corner Lot! Easy access to Hwy., and close to convenience stores. As Is Give us a call now for more information!' ,`Acres` = '0.1904' ,`Area` = '86' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = '15 SKYVIEW LOT 41 (8295 SQ FT)' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8295' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '497 - El Paso' ,`SchoolElementary` = 'DOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IRVIN HIGH SCHOOL' ,`SchoolMiddle` = 'MAGOFFIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Skyview' ,`TaxAmount` = '2564' ,`TaxRate` = '3.1246' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700271' WHERE `Matrix_Unique_ID` = '211583591' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T16:30:03.860' ,`MLSNumber` = '84030115' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.909187' ,`Longitude` = '-106.404403' ,`PhotoCount` = '20' ,`PostalCode` = '79924' ,`RoomCount` = '3' ,`ListPrice` = '159999.00' ,`Status` = 'Active' ,`StreetName` = 'Fertell' ,`StreetNumber` = '10212' ,`StreetSuffix` = 'Drive' ,`City` = 'El Paso' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1444' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming property in Yucca Village is the perfect place to call home. This 3 bedroom, 2 bathroom home features a huge open concept living room plus a bonus flex room. The kitchen features wooden cabinetry with quality appliances and a comfortable nook for dining. The cozy master bedroom has plenty of storage space and an en suite. There\'s also a carport which makes it easy to pull into your driveway at night. The backyard is fully fenced for safety and has plenty of storage space! Contact us today for more information!' ,`Acres` = '0.1377' ,`Area` = '86' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = '8 YUCCA VILLAGE LOT 221' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1052 - Ysleta' ,`SchoolElementary` = 'PARKLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PARKLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PARKLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Yucca Village Rep' ,`TaxAmount` = '3466' ,`TaxRate` = '3.2974' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700271' WHERE `Matrix_Unique_ID` = '211584557' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T16:58:02.013' ,`MLSNumber` = '77816606' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.248931' ,`Longitude` = '-101.488482' ,`PhotoCount` = '8' ,`PostalCode` = '79720' ,`RoomCount` = '1' ,`ListPrice` = '26999.00' ,`Status` = 'Active' ,`StreetName` = 'Galveston' ,`StreetNumber` = '203' ,`StreetSuffix` = 'Street' ,`City` = 'Big Spring' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '528' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A fixer upper with a lot of potential, at a price you will love! This home has easy access to I-20 with plenty of shopping and eateries nearby! If you want to experience nature in all its splendor, the property is minutes away from Big Spring State Park, and Comanche Trail Park. Take advantage of this opportunity, create your dream home! Give us a call today for more information! AS IS.' ,`Acres` = '0.078' ,`Area` = '86' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ACRES: 0.078 N/34 S/90 OF LTS 1-2 BK 6 JONES VALLEY 34X100 5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3398' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '341 - Big Spring' ,`SchoolElementary` = '' ,`SchoolHigh` = 'BIG SPRING HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NA' ,`TaxAmount` = '134' ,`TaxRate` = '2.2535' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700271' WHERE `Matrix_Unique_ID` = '211586372' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T17:07:08.950' ,`MLSNumber` = '89504103' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.829341' ,`Longitude` = '-106.578595' ,`PhotoCount` = '10' ,`PostalCode` = '79922' ,`RoomCount` = '3' ,`ListPrice` = '159900.00' ,`Status` = 'Active' ,`StreetName` = 'Corvena' ,`StreetNumber` = '316' ,`StreetSuffix` = 'Way' ,`City` = 'El Paso' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home located in El Paso, Texas is ready for a new owner! It offers quick access to I-10 and a diverse selection of dining options and entertainment to enjoy! There is also much to explore around this area including Franklin Mountains State Park, the Rio Grande, and so much more! As Is.' ,`Acres` = '0.1888' ,`Area` = '86' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = '6 RIVER BEND ESTATES LOT 2 (8223 SQ FT)' ,`LotDesciption` = 'Other' ,`LotSize` = '8223' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '497 - El Paso' ,`SchoolElementary` = 'ZACH WHITE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CORONADO HIGH SCHOOL (EL PASO)' ,`SchoolMiddle` = 'LINCOLN MIDDLE SCHOOL (EL PASO)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'River Bend Estates' ,`TaxAmount` = '3060' ,`TaxRate` = '3.1246' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700272' WHERE `Matrix_Unique_ID` = '211586854' --> Updated record success