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-06T01:22:01.717' ,`MLSNumber` = '6369407' ,`ListAgentFullName` = 'Terry Azzouz' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.292559' ,`Longitude` = '-94.816080' ,`PhotoCount` = '31' ,`PostalCode` = '77327' ,`RoomCount` = '1' ,`ListPrice` = '120000.00' ,`Status` = 'Active' ,`StreetName` = 'Sour Lake' ,`StreetNumber` = '479' ,`StreetSuffix` = 'Circle' ,`City` = 'Cleveland' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '393' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a perfect get away! Enjoy all that nature has to offer. From fishing, to swimming in one of the 3 pools and more. Do you like hiking? We got it. Feeding the deer? Got that too! Or you can just relax at the lake and allow the stress of city life melt away. This lot is perfect for all of your dreams. A tiny home on a large lot for your RV.' ,`Acres` = '0.2207' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '1' ,`Legal` = 'CYPRESS LAKES, BLOCK 11 UNIT 10, LOT 383' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '9614' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'TARKINGTON PRIMARY SCHOOL' ,`SchoolHigh` = 'TARKINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'TARKINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Cypress Lakes' ,`TaxAmount` = '822' ,`TaxRate` = '1.5473' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694961' WHERE `Matrix_Unique_ID` = '202235812' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T01:22:01.717' ,`MLSNumber` = '88057831' ,`ListAgentFullName` = 'Bruce Ham' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.346880' ,`Longitude` = '-95.476942' ,`PhotoCount` = '49' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '1300000.00' ,`Status` = 'Active' ,`StreetName` = 'Wrangler' ,`StreetNumber` = '16511' ,`StreetSuffix` = 'Road' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '6000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this stunning custom home that sets a new standard in luxurious living. Set on a 4 Acre Tract in the City of Rosharon with over 150 trees planted, massive garden, pond and pergola for a private backyard oasis. An impressive 4 BD, 3.5 BA 4,990 sqft home with ALL Bedrooms Down. Features include a sumptuous owner’s suite and 1,400 sqft guest house w/ 2bd, 2ba, laundry and a 672 sqft maintenance garage. Main home offers an opulent ensuite w/ his and hers closets, sinks with a huge soaking tub, 12foot ceiling, oversized family room, sunken living room, game room, media room, gourmet kitchen with huge island for the home chef onlooking the expansive custom built pool with outdoor kitchen and covered patio perfect for the avid entertainer. Skylights and large windows ensure an abundance of natural light while high-end finishes add a touch of elegance. Property has never flooded! There is no better place to call home other than in Suncreek Ranch. Schedule your private today!' ,`Acres` = '4' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUNCREEK RANCH SEC 1 (A0125 A ROBINSON) BLK 2 LOT 15' ,`LotDesciption` = 'Other' ,`LotSize` = '174240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`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` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Suncreek Ranch Sec 1-2-3-4' ,`TaxAmount` = '15019' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694961' WHERE `Matrix_Unique_ID` = '205290905' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T01:22:01.717' ,`MLSNumber` = '81922163' ,`ListAgentFullName` = 'Terry Azzouz' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.287135' ,`Longitude` = '-94.810452' ,`PhotoCount` = '24' ,`PostalCode` = '77327' ,`RoomCount` = '1' ,`ListPrice` = '99500.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Lakes' ,`StreetNumber` = '4484' ,`StreetSuffix` = 'Circle' ,`City` = 'Cleveland' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '363' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'It\'s a lifestyle! Get out of the city, out of the stress, and decompress in your own natural retreat! The peace and serenity will leave you wanting more. You can have this slice of heaven for weekends, summer vacations, family get away, or as a permanent home. Enjoy all that The Preserve has to offer. Fishing, lakes, deer, private beach, boat access to the Trinity River, dog park, splash pad, putt putt golf, parks and more. This site includes 2016 40ft PUMA RV with all the extras. Stackable washer and dryer, full size fridge and stove, and fire place. There is a fully covered gorgeous screened porch. It includes a large shed and dock driveway. If you so desire, we can add on the fully cleared second lot that is ready for you!' ,`Acres` = '0.3635' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CYPRESS LAKES, BLOCK 8 UNIT 2, LOT 471, MH LABEL# TRAVEL TRA' ,`LotDesciption` = 'Cleared,Subdivision Lot,Waterfront' ,`LotSize` = '15832' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'TARKINGTON PRIMARY SCHOOL' ,`SchoolHigh` = 'TARKINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'TARKINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Cypress Lakes' ,`TaxAmount` = '585' ,`TaxRate` = '1.5309' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694962' WHERE `Matrix_Unique_ID` = '205486082' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T01:22:01.717' ,`MLSNumber` = '97550864' ,`ListAgentFullName` = 'Morad Fiki' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.698273' ,`Longitude` = '-95.456104' ,`PhotoCount` = '49' ,`PostalCode` = '77401' ,`RoomCount` = '6' ,`ListPrice` = '699900.00' ,`Status` = 'Active' ,`StreetName` = 'Evergreen' ,`StreetNumber` = '4605' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury awaits you at this stunning fully renovated home! In the highly desired community of Bellaire, this home sits on a nearly 9,000 sqft lot. The timeless look of the solid Mahogany entry door makes this home feel warm and inviting. The bright interior & open floorplan is ideal for everyday living as well as entertaining. Your inner chef will be inspired in the fully updated kitchen, offering modern cabinetry, a luxurious copper farmhouse sink & hood range, and natural quartzite stone on all counters. No detail was missed with the fully renovated kitchen, side island was added to serve as a breakfast bar. This home boasts a 3 bed/2 bath which features a free-standing tub + separate shower, European style sinks, and beautiful tiles to add character. Electric updates, insulation added to all the outer walls, and brand new solid white oaks floors throughout make this home a stunner! NEVER FLOODED! Top Zoned schools and central location! Won\'t last long!' ,`Acres` = '0.2045' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 EVERGREEN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8910' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HORN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Evergreen' ,`TaxAmount` = '10560' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694962' WHERE `Matrix_Unique_ID` = '206458013' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T01:22:01.717' ,`MLSNumber` = '36358611' ,`ListAgentFullName` = 'Daniel Pina' ,`ListOfficeName` = 'City Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.810080' ,`Longitude` = '-95.527549' ,`PhotoCount` = '21' ,`PostalCode` = '77080' ,`RoomCount` = '4' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Truscon' ,`StreetNumber` = '9517' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1844' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Proud homeowners who have truly taken care of this 4 bed 1.5 bath located in the desired Spring Branch area. Property has been recently remolded and updated. Security cameras are installed and included with the home. This home is ideally situated within minutes from Downtown Houston, and Near Memorial City Mall, Memorial Med Center, and City Center. Welcome Home!' ,`Acres` = '0.1591' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 5 CAMPBELL WOODS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6929' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'PINE SHADOWS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Campbell Woods' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663694962' WHERE `Matrix_Unique_ID` = '208576536' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T01:22:01.717' ,`MLSNumber` = '7952791' ,`ListAgentFullName` = 'Lisa Markel' ,`ListOfficeName` = 'Keller Williams Met Inner Loop' ,`SellingAgentFullName` = 'Krista DiPuma' ,`SellingOfficeName` = 'UTR TEXAS, REALTORS' ,`Latitude` = '29.501493' ,`Longitude` = '-95.100253' ,`PhotoCount` = '28' ,`PostalCode` = '77573' ,`RoomCount` = '11' ,`ListPrice` = '350000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Hyland' ,`StreetNumber` = '1010' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2668' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Conveniently located to I-45 with easy access to Downtown, Galveston, Kemah, and the Space Center, this home has everything you\'d need, including low tax rates! Groceries, restaurants, shopping, and amenities are within close proximity, such as Baybrook Mall, Victory Lakes Town Center, Walter Hall Park, Challenger Seven Memorial Park, and more. The split floor plan includes 4 bedrooms, 3 full bathrooms, a formal dining room, and French doors that lead to the den that could also be used as a home office. The open kitchen has ample cabinet and counter space, a double oven perfect for hosting holidays, and an island. Upgrades to the kitchen include a recent stove, microwave, and touchless faucet. Don\'t forget about the covered patio for some outdoor R&R! This beloved home has overcome storms with no issues (no flooding or burst pipes!). Did we mention the new roof as well? Come take a look!' ,`Acres` = '0.1716' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WILSHIRE PLACE SEC 2 (2007) ABST 3, BLOCK 3, LOT 5, ACRES 0.' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '264' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'RALPH PARR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wilshire Place Sec 2 2007' ,`TaxAmount` = '6475' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694962' WHERE `Matrix_Unique_ID` = '208620959' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T01:22:01.717' ,`MLSNumber` = '3320254' ,`ListAgentFullName` = 'Karen Gandy' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.137591' ,`Longitude` = '-95.046513' ,`PhotoCount` = '42' ,`PostalCode` = '77554' ,`RoomCount` = '5' ,`ListPrice` = '634900.00' ,`Status` = 'Active' ,`StreetName` = 'Termini San Luis Pass' ,`StreetNumber` = '22002' ,`StreetSuffix` = 'Road' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1142' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wow, Just Wow!!! Stunning Recently Remodeled Coastal Cottage has it all!!! Conveys FULLY FURNISHED & is MOVE IN READY. Wake up to a view of the sunrise over the Gulf. Enjoy coffee with a view of the Gulf while soaking in the absolutely gorgeous Kitchen showcasing a 6 ft X 7 ft Quartz Island that seats 5 comfortably, stainless steel appliances, farm sink, & wine refrigerator. Relax on the deck or enjoy entertaining downstairs. Guests will have the best sleep of their lives in the 12X14 air conditioned/ heated bonus room below with half bathroom, two bunk beds, a mini fridge & coffee bar plus an outdoor shower. Don\'t forget to bring your golf cart - There is plenty of room in the garage. Sleeps 8 comfortably. Sea Isle\'s numerous amenities include a public beach, private fishing pier, boat ramp, park, swimming pool, tennis court, Sand Bar Restaurant & West End Marina! Karaoke on Friday nights is sure to impress! Perfect Short Term Rental Investment!' ,`Acres` = '0.1515' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 19 LOT 95 SEA ISLE SEC 1' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sea Isle 1' ,`TaxAmount` = '4654' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694962' WHERE `Matrix_Unique_ID` = '209143153' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T01:22:01.717' ,`MLSNumber` = '39503558' ,`ListAgentFullName` = 'Darnell Fuller' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.076576' ,`Longitude` = '-95.222967' ,`PhotoCount` = '28' ,`PostalCode` = '77365' ,`RoomCount` = '9' ,`ListPrice` = '440000.00' ,`Status` = 'Active' ,`StreetName` = 'Adrift Row' ,`StreetNumber` = '22743' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3783' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming Traditional on the best street in Woodbridge! This stunning 2-story home has stunning curb appeal, energy-certified windows, and stainless steel appliances. It welcomes you with fresh paint and beautiful new waterproof and scratch-resistant laminate flooring on the first floor. No carpet on the first floor. The layout offers a formal study upon entry, with an adjacent elegant formal dining room. An island kitchen w/ 42\" cabinets, butler\'s pantry w/ added wine chiller! Oversized family room area and primary bedroom on the first floor that offers its owners a relaxing retreat with a luxurious bath and 2 walk-in closets! The second floor offers an enormous raised floor game room, surround sound and media room! 2 Full baths all w/ new toilets and 3 additional bedrooms! A peaceful, oversized, covered back porch tops this beauty off perfect for you backyard \"shindig\"! Convenient location within minutes access to 59 and Kingwood! Home has never flooded! Schedule your showings today!' ,`Acres` = '0.1665' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S973603 - WOODRIDGE FOREST 03, BLOCK 1, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7254' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '790' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'KINGS MANOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodridge Forest 03' ,`TaxAmount` = '12563' ,`TaxRate` = '3.4339' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694962' WHERE `Matrix_Unique_ID` = '209521563' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T01:22:01.717' ,`MLSNumber` = '80952536' ,`ListAgentFullName` = 'Carla Wade' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.327336' ,`Longitude` = '-94.935647' ,`PhotoCount` = '31' ,`PostalCode` = '77563' ,`RoomCount` = '5' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Marlin' ,`StreetNumber` = '748' ,`StreetSuffix` = 'Street' ,`City` = 'Bayou Vista' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2424' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'So many updates were done in June 2022 on this spacious canal front Bayou Vista beauty including French doors, exterior paint, interior paint, luxury vinyl plank flooring in the family room, kitchen, dining, powder room and laundry room, carpet in bedrooms, new refrigerator, new vanity in downstairs powder room and upper floor bath bath and more! Other updates in past few years include the kitchen cabinets, granite counters, stainless appliances. There are 2 bedrooms with a Jack N Jill bath plus a half bath on the first floor. The open floor plan features a huge family area with vaulted ceiling, remodeled kitchen and dining area with a huge walk out deck over the boat house. Upstairs is a very large Primary Suite with French doors and a balcony overlooking the canal plus al bedroom with ensuite bath. The partially finished out ground floor quarters were freshly painted and have shiplap walls in gameroom area, a bedroom and an unfinished bath with toilet, shower and storage area.' ,`Acres` = '0.1062' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bayou Vista' ,`HeatSystem` = 'Central Gas,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 7 PAGE 7 LOT 748 NEW BAYOU VISTA ADDN 5' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '4625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'New Bayou Vista 5' ,`TaxAmount` = '9487' ,`TaxRate` = '2.635' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694962' WHERE `Matrix_Unique_ID` = '209611915' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T01:22:01.717' ,`MLSNumber` = '98138930' ,`ListAgentFullName` = 'Leomares Vasquez' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801240' ,`Longitude` = '-95.741168' ,`PhotoCount` = '17' ,`PostalCode` = '77449' ,`RoomCount` = '7' ,`ListPrice` = '469900.00' ,`Status` = 'Active' ,`StreetName` = 'Morgan Knoll Ln' ,`StreetNumber` = '20838' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3172' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home to enjoy with the family , great school district, completed remodeled, no carpet, ceramic title and much to see in person. Bring in your special buyers.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 CASTLE ROCK SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'FRANZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MORTON RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Castle Rock Sec 4' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663694963' WHERE `Matrix_Unique_ID` = '210193831' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T01:22:01.717' ,`MLSNumber` = '81939030' ,`ListAgentFullName` = 'Binbin Wu' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.680338' ,`Longitude` = '-95.481094' ,`PhotoCount` = '32' ,`PostalCode` = '77096' ,`RoomCount` = '7' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Loch Lomond' ,`StreetNumber` = '5425' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Prime location in Meyerland zoned great schools. This is one of the newest house in Mayerland with beautiful white stacco. Fresh painted, new carpet, real red oak hardwood floors in office, dinning room and living room, Julian Jade Marble in the front entrance area. Automatic driveway gate with extra parking spaces. Lots of natural light in every corner of the house, Huge backyard with detached garage in the back. This is a must see home in this wonderful neighborhood.' ,`Acres` = '0.2014' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 MEYERCREST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8774' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '545' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HEROD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meyercrest' ,`TaxAmount` = '12730' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694963' WHERE `Matrix_Unique_ID` = '210274875' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T01:22:01.717' ,`MLSNumber` = '54877279' ,`ListAgentFullName` = 'Jenny Guerra' ,`ListOfficeName` = 'Surge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.544713' ,`Longitude` = '-95.393387' ,`PhotoCount` = '35' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '449999.00' ,`Status` = 'Active' ,`StreetName` = 'Dawson' ,`StreetNumber` = '11109' ,`StreetSuffix` = 'Road' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3546' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BACK ON MARKET! HONEY, STOP THE CAR!! This 4 bedroom, 3.5 bath, corner lot home in the heart of Pearland could be yours! This home features high ceilings & big windows throughout allowing natural lighting in the home. The kitchen features a large island & opens up to the spacious living room, & cozy fireplace! Primary bedroom w/ en-suite has double sinks, garden tub, separate shower with a huge closet. Spacious office/study room with a closet can be potentially converted into a 5th bedroom. Second level begins with a centrally located Game Room followed by a split plan of 2 bedrooms & 1 full bathroom on your left and 1 Bedroom, a Full Bathroom on your right. The exterior is brick on all 4 sides with a long double driveway. The oversized garage/carport, with upstairs flex/storage space has so much potential and can be converted into guest quarters in the future. Minutes away from The Pearland Town Center which features shopping, restaurants, entertainment, & more!' ,`Acres` = '0.2322' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHGATE SEC 1 (A0300 HT&B) (PEARLAND) BLK 2 LOT 37' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '10115' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'RED DUKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'NOLAN RYAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southgate Sec 1' ,`TaxAmount` = '9100' ,`TaxRate` = '2.8209' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694963' WHERE `Matrix_Unique_ID` = '210298852' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T01:22:01.717' ,`MLSNumber` = '81503770' ,`ListAgentFullName` = 'Luis Martinez' ,`ListOfficeName` = 'CA Modern Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.817789' ,`Longitude` = '-95.788793' ,`PhotoCount` = '28' ,`PostalCode` = '77493' ,`RoomCount` = '5' ,`ListPrice` = '530000.00' ,`Status` = 'Active' ,`StreetName` = 'Capuchin' ,`StreetNumber` = '23903' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2695' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Breath taking home offers 5 spacious bedrooms and 3 full baths. Locate in a spacious corner lot!!! GREAT space for children to play. Home has had major upgrades. Come check it out soon!' ,`Acres` = '0.1116' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 1 MORTON CREEK RANCH SEC 14' ,`LotDesciption` = 'Other' ,`LotSize` = '4861' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Morton Crk Ranch Sec 14' ,`TaxAmount` = '8861' ,`TaxRate` = '3.3333' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694963' WHERE `Matrix_Unique_ID` = '210559274' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T01:22:01.717' ,`MLSNumber` = '41906260' ,`ListAgentFullName` = 'Kelly Farmer' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.685691' ,`Longitude` = '-95.994752' ,`PhotoCount` = '39' ,`PostalCode` = '77485' ,`RoomCount` = '9' ,`ListPrice` = '1950000.00' ,`Status` = 'Active' ,`StreetName` = 'CHISOLM TRAIL' ,`StreetNumber` = '600' ,`StreetSuffix` = '' ,`City` = 'Wallis' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3918' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This GORGEOUS CUSTOM Home Rest on 10 acres of lush with verdant grounds~ A Unique Property that Incorporates the Comforting Nostalgia of the Past and the Amenities of Today. Convenient to Shopping and Major Access Routes~ Cleared and Manicured but Heavily Wooded with a Large Private Pond (Catfish and Bass), BEAUTIFUL Gazebo and Bridge. Home DID NOT FLOOD ~ The Incredible Home Sits on a Raised Extra Thick 6\" Slab with a 2000 + sq ft Wrap Around Porch~ 5 Large Bedrooms ~ Each with a Private Bath and Walk-in Closet. Balcony off a bedroom to enjoy that morning Coffee and soak in the peaceful views. The Kitchen has a Farmhouse Sink , Double Ovens, Commercial Gas Grill with Pot Filler. A Large Building at the Rear of the Property has a Media Room, another Full Bath and Office with covered Parking Space for Your RV and All the Equipment. An Electric Generator Insures No Power Outages on Property. One of a Kind Must See Property to take in all its Beauty.' ,`Acres` = '10' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = '0092 T WESTALL, ACRES 10.00' ,`LotDesciption` = 'Water View,Wooded' ,`LotSize` = '435600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MORGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'T Westall' ,`TaxAmount` = '14551' ,`TaxRate` = '1.7948' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694963' WHERE `Matrix_Unique_ID` = '210700186' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T01:22:01.717' ,`MLSNumber` = '57155384' ,`ListAgentFullName` = 'Michelle Eads' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.881530' ,`Longitude` = '-95.462273' ,`PhotoCount` = '28' ,`PostalCode` = '77088' ,`RoomCount` = '10' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Wild Basin' ,`StreetNumber` = '8822' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2090' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous move-in ready corner lot home w/ a huge backyard in the quiet & friendly Inwood Forest Village community that offers a park, & quick access to I45, & 290. Out front find a low-maintenance lawn, a large shade tree, & a spacious 2-car garage. Inside you are welcomed by a completely updated open floor plan that features modern paint tones, wood-look tile flooring, a high ceiling entry, & ample natural light throughout. The open living room includes a gas fireplace, and a half bath & leads into the updated eat-in kitchen boasting mosaic-style flooring, granite counters, & plenty of cabinet storage space. The 1st-floor primary bedroom includes an updated en-suite bath, & a sizable walk-in closet. Head upstairs & find a large game room, & 3 spacious secondary bedrooms that share an updated full bath. Lastly, check out the huge fully fenced backyard that\'s perfect for transforming into your dream oasis.' ,`Acres` = '0.1699' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 6 INWOOD FOREST VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '280' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARAWAY ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Inwood Forest Village' ,`TaxAmount` = '4655' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694963' WHERE `Matrix_Unique_ID` = '210761327' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T00:35:53.190' ,`MLSNumber` = '61876694' ,`ListAgentFullName` = 'Karryn Nichols' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.395135' ,`Longitude` = '-96.324227' ,`PhotoCount` = '48' ,`PostalCode` = '75846' ,`RoomCount` = '4' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Lcr 908' ,`StreetNumber` = '155' ,`StreetSuffix` = '' ,`City` = 'Jewett' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2417' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'VIEWS GALORE! This 95 feet of Lake Water Frontage Property on Lake Limestone has amazing view on the main lake! It features 2 Stories with 2 very large Bedrooms and 2 1/2 baths, Master Bedroom on the bottom floor with a Wonderful Jacuzzi Tub to soak in and Walk in shower! New Flooring, New Hot Water Heaters, Beautiful trees and lots of shade out back on your porch facing the Lake! It has a Boat Ramp, Boat Dock, Boat House with 2 lifts and a Concrete Pier and has plenty of room for Boats, Jet Ski\'s and lake toys! The Huge Garage and Dream Workshop has Concrete Pillars and Concrete floor with a attic fan and it was made to withstand high winds. It was built so that a big door could be installed for a motorhome if needed! This property is priced to sell, so Come see it TODAY!' ,`Acres` = '0.5612' ,`Area` = '73' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CEDAR CREEK ESTATES LAKE LIMESTONE, BLOCK H, LOT 099' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Waterfront' ,`LotSize` = '28314' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '222 - Groesbeck' ,`SchoolElementary` = 'GROESBECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GROESBECK HIGH SCHOOL' ,`SchoolMiddle` = 'GROESBECK MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Cedar Creek Estates' ,`TaxAmount` = '3784' ,`TaxRate` = '2.298' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694963' WHERE `Matrix_Unique_ID` = '211079402' --> Updated record success