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-19T12:11:09.013' ,`MLSNumber` = '51073188' ,`ListAgentFullName` = 'Tammie Brisby' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.194853' ,`Longitude` = '-95.427422' ,`PhotoCount` = '18' ,`PostalCode` = '77515' ,`RoomCount` = '4' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Trail Ride' ,`StreetNumber` = '125' ,`StreetSuffix` = 'Road' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Many updates for you to enjoy. Spacious open floor plan. Rear double doors make it so easy to entertain from the indoors to the outdoors or simply keep an eye while the little ones are at play. Walking distance to schools. Corner fireplace perfect for chilly days/nights. Move in ready, with oversized backyard....perfect for family functions or relaxing' ,`Acres` = '0.1653' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Short Sale' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RANCHO ISABELLA SEC 2 (ANGLETON) BLK 13 LOT 28' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'RANCHO ISABELLA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rancho Isabella Sec 1-2-3-4 A' ,`TaxAmount` = '4333' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700592' WHERE `Matrix_Unique_ID` = '207703520' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T13:08:24.110' ,`MLSNumber` = '91282203' ,`ListAgentFullName` = 'Julia Harmon' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.146691' ,`Longitude` = '-95.675577' ,`PhotoCount` = '46' ,`PostalCode` = '77362' ,`RoomCount` = '13' ,`ListPrice` = '643000.00' ,`Status` = 'Active' ,`StreetName` = 'Majestic Shores' ,`StreetNumber` = '710' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REDUCED PRICE - 5BR, 4Bath home welcomes you into a grand 2 story foyer. A home office with ceiling beams is on your right as you enter. The lovely dining room which is connected to the kitchen through the butler\'s pantry/dry bar. Gourmet island kitchen with breakfast bar and breakfast room leading out onto the spacious backyard with plunge pool/spa, water feature and landscaping overlooking a forest that will not be developed. Living Room has high ceilings and gas log fireplace. 1st floor Primary BR and bath are located just off the LR. The Primary bath has 2 separate sink vanities and a separate shower and soaking tub. Also downstairs is a bedroom and full bath. Upstairs is a gameroom and media room along with 3 bedrooms and 2 bathrooms. Custom window treatments remain. The garage is oversized with custom flooring. Don\'t miss this Wifi certified smart home with voice control through Amazon Alexa. Compare to new construction, landscaped yard and spa/pool add value to this home.' ,`Acres` = '0.202' ,`Area` = '15' ,`BuilderName` = 'Village' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S959406 - WOODTRACE 06, BLOCK 1, LOT 28' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English,Traditional' ,`Subdivision` = 'Woodtrace' ,`TaxAmount` = '13994' ,`TaxRate` = '3.2015' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700592' WHERE `Matrix_Unique_ID` = '207847405' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T13:04:18.700' ,`MLSNumber` = '45437894' ,`ListAgentFullName` = 'Shyanne May' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.476781' ,`Longitude` = '-95.024674' ,`PhotoCount` = '17' ,`PostalCode` = '77539' ,`RoomCount` = '3' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Guadalupe' ,`StreetNumber` = '5813' ,`StreetSuffix` = 'Drive' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1293' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS GREAT HOME OFFERS AN OPEN LIVING AREA WITH TALL CEILINGS THAT OPEN TO THE KITCHEN AND EAT IN AREA. THERE ARE TWO SECONDARY BEDROOMS DOWNSTAIRS AND THEN A PRIVATE MAIN BEDROOM UPSTAIRS.' ,`Acres` = '0.075' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 155 P G MERRITT SUR LOT 40 BLK 5 CHEYENNE SUB REPLAT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3267' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '170' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cheyenne' ,`TaxAmount` = '4262' ,`TaxRate` = '2.5214' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700592' WHERE `Matrix_Unique_ID` = '209526986' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T13:53:33.733' ,`MLSNumber` = '78968909' ,`ListAgentFullName` = 'Dale Vinson' ,`ListOfficeName` = 'Pinnacle Realty Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.900375' ,`Longitude` = '-95.322776' ,`PhotoCount` = '50' ,`PostalCode` = '75862' ,`RoomCount` = '7' ,`ListPrice` = '170000.00' ,`Status` = 'Active' ,`StreetName` = 'Campground' ,`StreetNumber` = '478' ,`StreetSuffix` = 'Road' ,`City` = 'Trinity' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '912' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Waterview 3 bedroom on Stilts with a large exterior deck. This newly renovated home features a large living-dining combo, three bedrooms, one bath, utility room in the house, storage room under the house, and is fully fenced with a drive-through gate. Enjoy the water views of Trinity Cove and the Trinity River. The community is minutes from shopping and dining and has water access to Trinity Cove, The Trinity River, and Lake Livingston.' ,`Acres` = '0.1622' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TRINITY COVE SECTION 03, BLOCK 2 LOT 15' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '7066' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Trinity Cove Sec 3' ,`TaxAmount` = '855' ,`TaxRate` = '1.8863' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700592' WHERE `Matrix_Unique_ID` = '209692783' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T13:01:59.660' ,`MLSNumber` = '9836018' ,`ListAgentFullName` = 'Tammi Freund' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.786897' ,`Longitude` = '-95.361746' ,`PhotoCount` = '40' ,`PostalCode` = '77009' ,`RoomCount` = '6' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Booth' ,`StreetNumber` = '1003' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOVELY 3 BEDROOM 3 FULL FULL BATH W/ 4 CAR CARPORT Home fully fenced all the way around the home. Enjoy watching the pet or kids play in the front fenced in yard from the front patio. Kitchen offer ample counter space and cabinets and drop down lighting. Spacious dining open to living room. Spacious master bedroom and master bath with dual sinks. Secondary rooms are nice in size as well. This home is perfect for someone who loves to work on project or cars! Seller is consider selling the car lift. Back carport with electricity and clean off in the full bath in the back part of the home. This cute cozy home is well kept and ready for new owners!' ,`Acres` = '0.155' ,`Area` = '9' ,`BuilderName` = 'Savannah' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 113 BOOTH NORTH MAIN ST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KETELSEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Booth North Main St' ,`TaxAmount` = '6577' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700593' WHERE `Matrix_Unique_ID` = '209891910' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T12:22:24.320' ,`MLSNumber` = '43638312' ,`ListAgentFullName` = 'Kelli Owens' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.346808' ,`Longitude` = '-94.175831' ,`PhotoCount` = '16' ,`PostalCode` = '77656' ,`RoomCount` = '4' ,`ListPrice` = '179140.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue J' ,`StreetNumber` = '435' ,`StreetSuffix` = '' ,`City` = 'Silsbee' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Whether this will be your income-producing home or primary living, this is the home for you. Live in the house, rent the space above the garage or start your own Airbnb business. It is This quaint home is being offered with owner-carry if needed. Schedule your appointment now. This is an active Airbnb, please request a tour, if there is no guest the tour will be approved. If there are guests, we will need to schedule the showing after they check out of the property.' ,`Acres` = '0.1561' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 12 BLK 44 SANTA FE TOWNSITE P# S47-44-9-X I# 2019-100422' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '252 - Silsbee' ,`SchoolElementary` = 'SILSBEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SILSBEE HIGH SCHOOL' ,`SchoolMiddle` = 'EDWARDS-JOHNSON MEMORIAL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Silsbee' ,`TaxAmount` = '2053' ,`TaxRate` = '2.3756' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700593' WHERE `Matrix_Unique_ID` = '209965302' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T12:21:42.527' ,`MLSNumber` = '25271205' ,`ListAgentFullName` = 'Kelli Owens' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.993909' ,`Longitude` = '-95.188444' ,`PhotoCount` = '34' ,`PostalCode` = '77346' ,`RoomCount` = '5' ,`ListPrice` = '249100.00' ,`Status` = 'Active' ,`StreetName` = 'Toddington' ,`StreetNumber` = '5711' ,`StreetSuffix` = 'Road' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1810' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home. So you are ready to start the homeownership journey, this is the perfect place to start. Come out and tour the home today. The seller is offering a carryback for you to be able to move and enjoy the benefits of being a homeowner.' ,`Acres` = '0.1591' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 38 BLK 8 ATASCOCITA TRAILS SEC 1' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita Trails Sec 01' ,`TaxAmount` = '3763' ,`TaxRate` = '2.492' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700593' WHERE `Matrix_Unique_ID` = '210019552' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T12:21:23.870' ,`MLSNumber` = '7565882' ,`ListAgentFullName` = 'Kelli Owens' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.352891' ,`Longitude` = '-94.171834' ,`PhotoCount` = '9' ,`PostalCode` = '77656' ,`RoomCount` = '4' ,`ListPrice` = '100740.00' ,`Status` = 'Active' ,`StreetName` = 'Grimes' ,`StreetNumber` = '695' ,`StreetSuffix` = 'Avenue' ,`City` = 'Silsbee' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic little home nestled in the gorgeous and peaceful town of Silsbee, TX. Zero carpet, fresh paint, great kitchen with beautifully painted cabinets. The seller would love for you to achieve your goal of homeownership or picking up an investment property, therefore owner carry back is available to you.' ,`Acres` = '0.124' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 10 BLK 1 N SILSBEE #2 P# S39-1-9 I# 2020-107872 9/28/202' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5401' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '252 - Silsbee' ,`SchoolElementary` = 'SILSBEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SILSBEE HIGH SCHOOL' ,`SchoolMiddle` = 'EDWARDS-JOHNSON MEMORIAL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'North Silsbee Add' ,`TaxAmount` = '1137' ,`TaxRate` = '2.3756' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700593' WHERE `Matrix_Unique_ID` = '210020765' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T12:22:47.593' ,`MLSNumber` = '41472809' ,`ListAgentFullName` = 'Sheree Chang' ,`ListOfficeName` = 'FCI Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.711208' ,`Longitude` = '-95.567554' ,`PhotoCount` = '14' ,`PostalCode` = '77072' ,`RoomCount` = '6' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Havendale' ,`StreetNumber` = '6314' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1614' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready to move in! >$45k updates/upgrades: New AC ($5k), New paint in/out, New wood like vinyl floor, New remodel bathrooms, New granite kitchen counter top, New dishwasher, Doors, locks, baseboards, light fixtures, etc. Foundation repairs with lifetime warranty. Easy access to Beltway 8 and Westpark tollway. Close to China Town Hurry! It won\'t last!' ,`Acres` = '0.0924' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 80 BLK 7 BRAYS VILLAGE EAST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4023' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'CHANCELLOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALIEF MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brays Village East' ,`TaxAmount` = '3722' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700593' WHERE `Matrix_Unique_ID` = '210364514' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T13:10:02.823' ,`MLSNumber` = '22358162' ,`ListAgentFullName` = 'Emmalee Schraeder' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.507485' ,`Longitude` = '-95.409809' ,`PhotoCount` = '24' ,`PostalCode` = '77578' ,`RoomCount` = '4' ,`ListPrice` = '334000.00' ,`Status` = 'Active' ,`StreetName` = 'Garden Ridge' ,`StreetNumber` = '10' ,`StreetSuffix` = 'Court' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2411' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You\'ll love this gorgeous, bright and up-kept 2014 build. A 2 story home with a 2 car garage in the peaceful community of Rodeo Palms. This 4 bedroom 2/1 bath property features the master on the first floor. A great sized master bath and closet adjacent! The immaculate kitchen boasts new backsplash, granite countertops, kitchen bar top seating, and a open floor plan great for entertaining. New fixtures! SOME REPAIRS WILL BE INCLUDED IF NEEDED! Located close to main highways, restaurants, & shopping come take a look at this beauty this home won\'t last long!' ,`Acres` = '0.132' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RODEO PALMS THE COLONY SEC 4 BLK 1 LOT 36' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rodeo Palms, The Colony Sec 4' ,`TaxAmount` = '8890' ,`TaxRate` = '3.6694' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700593' WHERE `Matrix_Unique_ID` = '210929272' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T13:58:35.287' ,`MLSNumber` = '15646424' ,`ListAgentFullName` = 'Kimberly Washington' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.683586' ,`Longitude` = '-95.337227' ,`PhotoCount` = '9' ,`PostalCode` = '77033' ,`RoomCount` = '6' ,`ListPrice` = '205000.00' ,`Status` = 'Active' ,`StreetName` = 'Chennault st' ,`StreetNumber` = '5421' ,`StreetSuffix` = '' ,`City` = 'South Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 23 Blk 23 Southpark' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5692' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KELSO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'South Park' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663700593' WHERE `Matrix_Unique_ID` = '211017068' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T12:20:58.303' ,`MLSNumber` = '80334933' ,`ListAgentFullName` = 'Kelli Owens' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.224147' ,`Longitude` = '-93.898946' ,`PhotoCount` = '20' ,`PostalCode` = '77632' ,`RoomCount` = '5' ,`ListPrice` = '179034.00' ,`Status` = 'Active' ,`StreetName` = 'Westbend' ,`StreetNumber` = '9743' ,`StreetSuffix` = '' ,`City` = 'Orange' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1320' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New A/C was installed in 2019, the home has received some love on the inside. The outside could use a little TLC. This home has a lot of character and personality. The seller is willing to carry a note.' ,`Acres` = '1.967' ,`Area` = '50' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 11 SEC 1 WOODRIDGE COUNTRY' ,`LotDesciption` = 'Cleared' ,`LotSize` = '85683' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '683 - Little Cypress-Mauriceville Consolidated' ,`SchoolElementary` = 'MAURICEVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LITTLE CYPRESS-MAURICEVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MAURICEVILLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodridge Country # 1' ,`TaxAmount` = '2105' ,`TaxRate` = '2.0551' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663700594' WHERE `Matrix_Unique_ID` = '211202865' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T12:03:12.510' ,`MLSNumber` = '16550666' ,`ListAgentFullName` = 'Loren Miner' ,`ListOfficeName` = 'Eastwood Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.739151' ,`Longitude` = '-95.290894' ,`PhotoCount` = '19' ,`PostalCode` = '77011' ,`RoomCount` = '2' ,`ListPrice` = '249888.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue J' ,`StreetNumber` = '7419' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '858' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Behold, the MogunMini, located just outside of Downtown in the highly desired and rapidly transforming East End, can finally be yours. Revitalized to an unmatched level of craftsmanship and luxury that has been tastefully packaged into a modern, sleek and a pleasantly efficient footprint. Open concept living/dining/kitchen for entertaining with pristine custom cabinetry and concrete countertops to impress the friends and family. A large primary bedroom with plentiful natural light and an abundance of closet/storage space is separated from the second bedroom by a warm spa-like bathroom. Enjoy the lush green grass and beautiful mature trees all around on your covered front porch or enjoy a cool night with friends and drinks on the deck/yard out back. Feeling creative? Tons of additional green space to build another home/garage apartment for that nice value-add component. Book a consultation today with Eastwood Realty to view this home and learn how you can still win in real estate.' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 16 & 17 BLK 87 MAGNOLIA PARK SEC 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DE ZAVALA ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'EDISON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Magnolia Park' ,`TaxAmount` = '1472' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1938' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700594' WHERE `Matrix_Unique_ID` = '211505545' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T12:02:13.750' ,`MLSNumber` = '1041757' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014518' ,`Longitude` = '-95.415308' ,`PhotoCount` = '27' ,`PostalCode` = '77073' ,`RoomCount` = '6' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Great Royal' ,`StreetNumber` = '22219' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2094' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Imperial Heights in Houston, TX! The Shannon Plan is a spacious 2-story home with 3 bedrooms, 2.5 bathrooms and a 2-car garage. This home has it all, including blinds and a FLEX ROOM on the first floor! With an open kitchen, dining, and family room, you\'ll love entertaining in this home! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless steel appliances. Upstairs offers a private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring a separate tub and shower and walk-in closet. Enjoy the great outdoors with full sod and a covered patio! Don’t miss your opportunity to call Imperial Heights home, schedule a visit today!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 3 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3590' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CAROLEE BOOKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Heights' ,`TaxAmount` = '' ,`TaxRate` = '2.73' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700594' WHERE `Matrix_Unique_ID` = '211615435' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T12:34:07.453' ,`MLSNumber` = '78116006' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014566' ,`Longitude` = '-95.414187' ,`PhotoCount` = '20' ,`PostalCode` = '77073' ,`RoomCount` = '5' ,`ListPrice` = '264990.00' ,`Status` = 'Active' ,`StreetName` = 'Sovereign Heights' ,`StreetNumber` = '22214' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1643' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Imperial Heights in Houston, TX! The Sequoia plan is a spacious 2-story home with 3 bedrooms, 2.5 baths, and 2-car garage. This home has it all, including blinds! The first floor offers the perfect space for entertaining with a large kitchen island open to both the living and dining areas! The gourmet kitchen is sure to please with 42\" white colored cabinetry, granite countertops, and stainless steel appliances! Upstairs offers a split floor plan and private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring a sizable shower and Texas-sized walk-in closet! Enjoy the great outdoors with full sod and a covered patio! Don’t miss your opportunity to call Imperial Heights home, schedule a visit today!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 24 Block 5 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3204' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CAROLEE BOOKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Heights' ,`TaxAmount` = '' ,`TaxRate` = '2.73' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700594' WHERE `Matrix_Unique_ID` = '211617104' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T13:48:58.387' ,`MLSNumber` = '87772379' ,`ListAgentFullName` = 'Mayra Salas' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768608' ,`Longitude` = '-95.001341' ,`PhotoCount` = '32' ,`PostalCode` = '77521' ,`RoomCount` = '4' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Goose Creek' ,`StreetNumber` = '5016' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2252' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is the one you’ve been looking for! Beautifully remodeled home in Country Club Oaks. Home features new kitchen with modern shaker style cabinets and quartzite countertops. 3 car garage with extra high bay for your boat/RV and extra room for workshop. 2 bedrooms up and 2 down. Master bedroom downstairs features accent wall. Updated master bath offers his and hers closets, double sinks, and quartzite countertops. Formal dinning and office space perfect for those working from home. The open spaces allows for tons of natural light throughout the house. Close to schools, shopping, and dinning. So many features to mention! Come see for yourself!' ,`Acres` = '0.3041' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 8 COUNTRY CLUB OAKS SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '13245' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Club Oaks Sec 01' ,`TaxAmount` = '7506' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700594' WHERE `Matrix_Unique_ID` = '211620950' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T13:29:39.870' ,`MLSNumber` = '91065802' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.864700' ,`Longitude` = '-95.282900' ,`PhotoCount` = '6' ,`PostalCode` = '77016' ,`RoomCount` = '3' ,`ListPrice` = '239990.00' ,`Status` = 'Active' ,`StreetName` = 'Red Orchid' ,`StreetNumber` = '1515' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Cooper floorplan showcases 3 bedrooms 2 full bathrooms and a 2 car garage! This open concept kitchen is full of high quality cabinetry, a pantry and a large eating area that is blanketed with natural lighting illuminating from the breakfast area windows. It is completed with hard surface flooring throughout the common areas. And for family fun times, it has an amazing covered front porch and back patio that comes standard with this home.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '4/4' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wayside Village' ,`TaxAmount` = '' ,`TaxRate` = '3.13' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700594' WHERE `Matrix_Unique_ID` = '211621453' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T13:32:48.983' ,`MLSNumber` = '20749760' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.864700' ,`Longitude` = '-95.282900' ,`PhotoCount` = '24' ,`PostalCode` = '77016' ,`RoomCount` = '3' ,`ListPrice` = '256490.00' ,`Status` = 'Active' ,`StreetName` = 'Vinca Minor' ,`StreetNumber` = '10530' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1402' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Sommerville floorplan showcases 3 bedrooms 2 full bathrooms and a 2 car garage! This open concept kitchen is full of high quality cabinetry, a pantry and a large eating area that is blanketed with natural lighting illuminating from the breakfast area windows. It is completed with hard surface flooring throughout the common areas. And for family fun times, it has an amazing covered front porch and back patio that comes standard with this home.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '16/2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wayside Village' ,`TaxAmount` = '' ,`TaxRate` = '3.13' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700594' WHERE `Matrix_Unique_ID` = '211621600' --> Updated record success