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-26T10:50:52.783' ,`MLSNumber` = '45595107' ,`ListAgentFullName` = 'Connie Strban' ,`ListOfficeName` = 'Crockett Springs Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.314121' ,`Longitude` = '-95.438862' ,`PhotoCount` = '39' ,`PostalCode` = '75835' ,`RoomCount` = '9' ,`ListPrice` = '299500.00' ,`Status` = 'Active' ,`StreetName` = 'Plantation' ,`StreetNumber` = '1307' ,`StreetSuffix` = 'Drive' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2590' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate, totally renovated with attention to every detail! 3 bedrooms/2 baths/2 car attached garage. This beautiful home offers wood flooring, granite in kitchen and baths, and plenty of space for indoor and outdoor entertaining. Relax in total privacy in the large hot tub. There is also very nice 960 sq ft with 1 bedroom/1 bath apartment, great for a guest house, Mother-In-Law suite or rented for extra income. Conveniently located in a quite area of Historic Crockett, Texas.' ,`Acres` = '0.269' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PLANTATION ACRES LOT 27 SEC A' ,`LotDesciption` = 'Cleared' ,`LotSize` = '11718' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '57 - Crockett' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (CROCKETT)' ,`SchoolHigh` = 'CROCKETT HIGH SCHOOL (CROCKETT)' ,`SchoolMiddle` = 'CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation Acres Sec A' ,`TaxAmount` = '3325' ,`TaxRate` = '2.3627' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703229' WHERE `Matrix_Unique_ID` = '205244517' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T11:36:14.747' ,`MLSNumber` = '34080412' ,`ListAgentFullName` = 'Rhonda Flanagan' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.949080' ,`Longitude` = '-93.977363' ,`PhotoCount` = '22' ,`PostalCode` = '77642' ,`RoomCount` = '11' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = 'Honeywood' ,`StreetNumber` = '8060' ,`StreetSuffix` = 'Trail' ,`City` = 'Port Arthur' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2067' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FOR SALE OR FOR LEASE! \r\nThis beautiful new construction which features 3 bedrooms, 2.5 bathrooms, and 2 car garage is a must-see! \r\nSpacious primary suite downstairs, primary ensuite has two vanities, granite countertop, large garden tub with separate tiled shower and large walk-in closet.\r\nKitchen is open to the family room, has work island, bar seating, granite countertops, dark cabinetry with black and stainless gas-free standing range and dishwasher. \r\nDining room and utility room are located off open foyer. \r\nUpstairs has 2 nice sized bedrooms, full bath with granite countertop, two vanities, shower/tub combo. \r\nEasily accessible walk-in attic that houses energy efficient gas hot water heater, two energy efficient a/c and heating unit with lots of storage space.\r\nHome is located near Babe Zaharias Golf course, shopping centers and entertainment nearby.' ,`Acres` = '0.12' ,`Area` = '51' ,`BuilderName` = 'GP REALTY BUILDING C' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 30 WGN ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '236 - Port Arthur' ,`SchoolElementary` = 'ADAMS ELEMENTARY SCHOOL (PORT ARTHUR)' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PORT ARTHUR)' ,`SchoolMiddle` = 'JEFFERSON MIDDLE SCHOOL (PORT ARTHUR)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'WGN Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703229' WHERE `Matrix_Unique_ID` = '205336365' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T10:01:57.483' ,`MLSNumber` = '5872932' ,`ListAgentFullName` = 'David Floyd' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.708991' ,`Longitude` = '-95.790319' ,`PhotoCount` = '48' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '749500.00' ,`Status` = 'Active' ,`StreetName` = 'Legendary Lane' ,`StreetNumber` = '23819' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3492' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Quality, Value, Style, and Design! This is an amazing 1 story home nestled on a secluded wooded street. Pride in ownership shines throughout. Grand Entry with high ceiling opens up to Spacious light and bright Family Room and separates Private Study and impressive Dining Room. Gourmet Island Kitchen offers Granite Counters, Tile Backsplash, updated Stainless Steel Appliances, and opens to Breakfast and Family Room. Private Owners Retreat includes elegant wood flooring and French doors that open to backyard with sparkling pool and spa. Three large secondary rooms (one with a private full bath that makes a great guest suite). Amazing 1/3 of an acre estate sized homesite includes a beautifully landscaped front yard and spacious back yard oasis offers a great backdrop for family gatherings, BBQ’s, and pool parties. This special home truly has it ALL!' ,`Acres` = '0.3781' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEVEN MEADOWS SEC 4, BLOCK 3, LOT 7' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '16469' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HOLLAND ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Seven Meadows' ,`TaxAmount` = '12954' ,`TaxRate` = '2.5145' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703230' WHERE `Matrix_Unique_ID` = '208289547' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T11:08:06.780' ,`MLSNumber` = '38554960' ,`ListAgentFullName` = 'Christopher Phan' ,`ListOfficeName` = 'Truss Real Estate' ,`SellingAgentFullName` = 'Mahir Rizvon' ,`SellingOfficeName` = 'Truss Real Estate' ,`Latitude` = '29.846825' ,`Longitude` = '-95.448621' ,`PhotoCount` = '10' ,`PostalCode` = '77091' ,`RoomCount` = '5' ,`ListPrice` = '355000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Paul Quinn' ,`StreetNumber` = '2625' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Oracle City Home\'s \"Paul Quinn\" project features 24 units in a privately gated community with private backyard located in highly developing Acres Homes. This is 1 of 2 distinct floor-plans meticulously designed inside and out with stunning elevations and interior designs that redefine the standard for farmhouse modern homes. 1st floor has an additional office/flex space great for working from home or any new addition. The 2nd floor embodies an open floorplan and professional design with hand selected bold finishes to create stunning interior décor. The kitchen features a spacious island, complimented by beautiful cabinetry, generous back countertops, and grand backsplash. All bedrooms up 3rd floor, primary is set with shiplap wall, ensuite is dressed to impress with features such as oversized shower, his/her sinks, and walk-in closet. Welcome to Paul Quinn! RENDERS ARE NOT EXACT AND SOME MATERIALS ARE SUBJECT TO CHANGE DUE TO LACK OF INVENTORY UPON ORDERING.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Oracle City Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Northwest Landing LT 13, BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1671' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`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` = 'SMITH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Northwest Landing' ,`TaxAmount` = '7174' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703230' WHERE `Matrix_Unique_ID` = '208539282' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T10:37:12.373' ,`MLSNumber` = '87335933' ,`ListAgentFullName` = 'Kristi Martinez' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.342683' ,`Longitude` = '-95.281309' ,`PhotoCount` = '36' ,`PostalCode` = '77328' ,`RoomCount` = '10' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Parker' ,`StreetNumber` = '18492' ,`StreetSuffix` = 'Road' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1944' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Dreaming of a country home? Look no further! Well maintained home on 1.93 beautiful acres with mature shade trees, workshop, storage building with A/C, peace and quiet! Spacious, open home with 4 bedrooms, 2 baths, 2 living areas, island kitchen, large front porch to sit and enjoy the breeze. This home boasts upgraded window and insulation package. New well in 2020, septic 2019, roof 2019, hot water heater 2022, shop roof 2022. Come enjoy everything the country living has to offer!' ,`Acres` = '1.934' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S773700 - PARKER ROAD ESTATES, BLOCK 1, LOT 6' ,`LotDesciption` = 'Cleared' ,`LotSize` = '84245' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Parker Road Estates' ,`TaxAmount` = '551' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703230' WHERE `Matrix_Unique_ID` = '208766733' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T10:10:41.080' ,`MLSNumber` = '67685314' ,`ListAgentFullName` = 'Diego Huerta' ,`ListOfficeName` = 'Go Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.821057' ,`Longitude` = '-95.713999' ,`PhotoCount` = '43' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Amber Meadow' ,`StreetNumber` = '3338' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, well-maintained home in Westfield subdivision. Large formal dining leading right into charming country kitchen with breakfast nook and open sightliness into spacious, bright living room with wood burning fireplace, Neutral tile flooring throughout and full- bath on first floor. All 3 spacious bedrooms with walk-in closets and large game room on second floor with wood flooring throughout. NO CARPET ANYWHERE. Solar panels on roof make this an energy efficient home. Located in a quiet cul-de-sac and zoned to the sought after Katy School District. Schedule your showing today before its gone! ' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 WESTFIELD SEC 19' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCROBERTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CARDIFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Westfield Sec 19' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703230' WHERE `Matrix_Unique_ID` = '208771579' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T10:22:57.427' ,`MLSNumber` = '90520758' ,`ListAgentFullName` = 'Melissa Johnson' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.447630' ,`Longitude` = '-95.396400' ,`PhotoCount` = '13' ,`PostalCode` = '77578' ,`RoomCount` = '7' ,`ListPrice` = '482900.00' ,`Status` = 'Active' ,`StreetName` = 'Morrison' ,`StreetNumber` = '5066' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1992' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Formal dining room set at entry. Open island kitchen offers walk-in pantry and generous counter space. Morning area is set adjacent to open family room with wall of windows. Primary suite includes primary bath with dual vanity, garden tub, separate glass-enclosed shower and walk-in closet. Secondary bedrooms include walk-in closets. Covered backyard patio. Two-car garage.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SECTION 48, LOT 8, BLOCK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '17334' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = '' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703230' WHERE `Matrix_Unique_ID` = '209348473' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T10:34:12.713' ,`MLSNumber` = '8038470' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.500566' ,`Longitude` = '-95.408826' ,`PhotoCount` = '48' ,`PostalCode` = '77578' ,`RoomCount` = '13' ,`ListPrice` = '675400.00' ,`Status` = 'Active' ,`StreetName` = 'Carmel' ,`StreetNumber` = '3' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3874' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two story, new construction home for sale in Manvel, TX with elongated foyer entryway. Our gourmet kitchen is a chef\'s dream kitchen with a large granite kitchen island, double ovens, and walk-in pantry. Formal dining room and separate breakfast area. Open-concept family room features a grandiose wall of windows and stone fireplace faces the kitchen where lasting memories will be made. Spacious primary retreat located on the first level boasts an enormous walk-in closet. Primary bath is the perfect oasis with his and hers vanities, separate soaking tub, and walk-in shower. Open to below catwalk makes it easy to keep an eye on the kids from the first level. Four secondary bedrooms. Reading loft, huge game room, and separate media room lie upstairs. Covered back patio. Our Hudson plan is the ULTIMATE floor plan for entertaining!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Rodeo Palms Lot 2 Block 2 Section RPL-4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rodeo Palms' ,`TaxAmount` = '' ,`TaxRate` = '3.82' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703230' WHERE `Matrix_Unique_ID` = '209367549' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T10:43:08.637' ,`MLSNumber` = '39267651' ,`ListAgentFullName` = 'Meaghan Arceneaux' ,`ListOfficeName` = 'Mega Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.980312' ,`Longitude` = '-95.955394' ,`PhotoCount` = '23' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '206900.00' ,`Status` = 'Active' ,`StreetName` = '4th' ,`StreetNumber` = '2909' ,`StreetSuffix` = 'Street' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1282' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for New Construction? Look no further, this charming home is ready for its new owner! This brand new build features 3 bedrooms, 2 full bathrooms and an open concept layout that showcases over 1200 sqft. Ready to make a move? Call today for an appointment!' ,`Acres` = '0.1722' ,`Area` = '54' ,`BuilderName` = 'Award Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MAGILLS S/D LOTS 12 BLK 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'MAGILLS, FRY EXT, ROBERTSON,MORTON & SVE' ,`TaxAmount` = '283' ,`TaxRate` = '2.82382' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703230' WHERE `Matrix_Unique_ID` = '209664199' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T10:21:21.830' ,`MLSNumber` = '58832908' ,`ListAgentFullName` = 'Jonathan Denissen' ,`ListOfficeName` = 'FYI Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.886117' ,`Longitude` = '-95.740123' ,`PhotoCount` = '7' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '379900.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Pin Oak' ,`StreetNumber` = '7535' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2488' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful New Construction 1 1/2 Story Saratoga Home, the Elise. Former model home for Saratoga Homes. Home has 3 bedrooms all downstairs, Master Bedrooms both with ensuite, 3 Full Bathrooms and a 2 car attached garage. Home has an open floor plan perfect for entertaining. The kitchen has a large island with granite countertops, custom tile back splash, and ceramic tile flooring. Master Suite complete with double sinks, large walk-in closet. Large game room is located upstairs with its own full bathroom.' ,`Acres` = '0.1559' ,`Area` = '25' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 CYPRESS OAKS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6792' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Oaks North Sec 1' ,`TaxAmount` = '7024' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703231' WHERE `Matrix_Unique_ID` = '209685106' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T11:16:23.690' ,`MLSNumber` = '20020886' ,`ListAgentFullName` = 'Luis Marti' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.908090' ,`Longitude` = '-95.710138' ,`PhotoCount` = '48' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Mountain Vista' ,`StreetNumber` = '19814' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2872' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Energy Efficient Meritage home with spacious master suite, flex/private study room on the first floor, 9 feet ceilings, secondary rooms located upstairs with large game room. Open concept Kitchen, Dining, and Living Room. \r\nKitchen with 48 inches cabinetry, Granite countertops Energy Star Stainless Steel Appliances, Walking Pantry, Gas Cooktop. Spacious Master Suite with Bay Windows, Quartz Countertops in master bath.Bricks on 4 sides and Stone in the front.Sprinkler system, Tankless water heater.Tile floor throughout the first floor.\r\nFor entertainment, you be delighted with the huge back porch space. Virtual Tour is attached for your review.\r\nMiramesa community amenities include a recreation center and walking trails' ,`Acres` = '0.1377' ,`Area` = '25' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 1 MIRAMESA SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '940' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POSTMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Miramesa' ,`TaxAmount` = '9644' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703231' WHERE `Matrix_Unique_ID` = '210091196' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T11:32:00.710' ,`MLSNumber` = '21167364' ,`ListAgentFullName` = 'Jessica Gonzales' ,`ListOfficeName` = 'Winhill Advisors - Kirby' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.859948' ,`Longitude` = '-95.701418' ,`PhotoCount` = '29' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Deep South' ,`StreetNumber` = '19126' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2246' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect starter home that includes a spacious layout with all 4 bedrooms located on second floor. Kitchen with breakfast area, formal living area and formal dining and/or office space. Located on quiet cul-de-sac. Clean with minimal repairs needed.' ,`Acres` = '0.099' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 110 BLK 5 BRENWOOD TRAILS SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '4311' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCFEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brenwood Trls Sec 01' ,`TaxAmount` = '5248' ,`TaxRate` = '2.641' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703231' WHERE `Matrix_Unique_ID` = '210432305' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T10:42:13.180' ,`MLSNumber` = '47400452' ,`ListAgentFullName` = 'Courtney McEachern' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.791358' ,`Longitude` = '-95.486739' ,`PhotoCount` = '10' ,`PostalCode` = '77055' ,`RoomCount` = '3' ,`ListPrice` = '930000.00' ,`Status` = 'Active' ,`StreetName` = 'Glourie' ,`StreetNumber` = '1222' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in beautiful Hilshire Village, this is the perfect opportunity to build your dream home. Zoned to Valley Oaks Elementary, Spring Branch Middle, and Memorial High! So convenient to downtown, the Galleria, I-10 corridor and Memorial Park!' ,`Acres` = '0.2645' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 BLK 4 HILSHIRE MANOR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'VALLEY OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'HILSHIRE MANOR' ,`TaxAmount` = '15186' ,`TaxRate` = '2.4805' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663703231' WHERE `Matrix_Unique_ID` = '210614710' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T11:05:58.240' ,`MLSNumber` = '70440848' ,`ListAgentFullName` = 'Anthony Atuchi' ,`ListOfficeName` = 'ABL Real Estate Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.692988' ,`Longitude` = '-95.708140' ,`PhotoCount` = '21' ,`PostalCode` = '77407' ,`RoomCount` = '8' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Allendale Forest' ,`StreetNumber` = '18607' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2534' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Agents This is a popular Pierce floor plan by D. Horton. Property is occupied, this piece of property is 4/2.5/2 built in 2020. Property is in a good shape. Bring your buyers they will love to call it a home. It has a solar panel installed and functioning perfectly well. Per seller the cost of power is very well reduced. Seller need 2hour notice.' ,`Acres` = '0.156' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LAKEVIEW RETREAT SEC 5, BLOCK 1, LOT 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6797' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '8820' ,`TaxRate` = '3.0697' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703231' WHERE `Matrix_Unique_ID` = '210659669' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T10:30:20.327' ,`MLSNumber` = '90216238' ,`ListAgentFullName` = 'Kameka Edwards' ,`ListOfficeName` = 'Realty Right' ,`SellingAgentFullName` = 'Ken Lewis' ,`SellingOfficeName` = 'RE/MAX Signature' ,`Latitude` = '29.595903' ,`Longitude` = '-96.326509' ,`PhotoCount` = '19' ,`PostalCode` = '77434' ,`RoomCount` = '3' ,`ListPrice` = '199000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Waverly' ,`StreetNumber` = '107' ,`StreetSuffix` = 'Avenue' ,`City` = 'Eagle Lake' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1323' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly improved pricing! Make yourself at home, not far from historic downtown Eagle Lake! See the pride in ownership of this well-kept ranch style home! Nestled on OVER HALF AN ACRE on the edge of town, this brick home boasts a comfortable semi-open floor plan, perfect for entertaining, beautiful tile flooring throughout, and new water heater and HVAC unit. The spacious kitchen is perfect for any cook, with stainless steel appliances that will convey. Dining room bay window features unique stained glass that\'s sure to be a conversation starter. Step out onto the back covered patio, and take a gander at the beautiful large lot, lined with numerous mature shade trees. Perfect for spending those lazy afternoons in the hammock! Home has a covered carport located on the front of the house, as well as an additional covered carport in the backyard, with access from the back of the property. Another lean-to was added and is the perfect space for storing your lawn tools.' ,`Acres` = '0.6171' ,`Area` = '56' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BLK 4 PT LT 13,12 HIGHLAND PARK EAGLE LAKE & HOUSE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '26881' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '161 - Rice Consolidated' ,`SchoolElementary` = 'EAGLE LAKE INTERMEDIATE SCHOOL' ,`SchoolHigh` = 'RICE HIGH SCHOOL (RICE CISD)' ,`SchoolMiddle` = 'RICE JUNIOR HIGH SCHOOL (RICE CISD)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Highland Park' ,`TaxAmount` = '1938' ,`TaxRate` = '2.5343' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703231' WHERE `Matrix_Unique_ID` = '210698201' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T11:21:19.800' ,`MLSNumber` = '83134866' ,`ListAgentFullName` = 'Jay Thieme' ,`ListOfficeName` = 'RE/MAX Cinco Ranch' ,`SellingAgentFullName` = 'Wei Phillips' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.752288' ,`Longitude` = '-95.789003' ,`PhotoCount` = '30' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '365000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Marquette' ,`StreetNumber` = '2551' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2469' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very well maintained two story home with a PRIVATE BACKYARD...NO BACK NEIGHBOR in Parkway Oaks! Engineered WOOD FLOORING in the entry, formal dining room, family room, kitchen, breakfast AND on the stairs. Open floor plan. Kitchen with gas cooktop and WALK-IN PANTRY. Kitchen refrigerator is INCLUDED. Spacious family room with a wall of windows overlooking the backyard. Fireplace with gas logs. Primary bathroom includes a WALK-IN CLOSET, dual sinks, separate shower & tub. Large secondary bedrooms upstairs along with a gameroom. Double pane windows. Gutters. COVERED BACK PATIO. You\'ll love this backyard...it gets the afternoon/evening shade. Privacy screen on backyard fence. Easy access to the South Bank Walking Trail. Zoned for A++ Katy ISD Schools...Rylander Elem, Cinco Ranch Jr High & Cinco Ranch High School. Whoop!' ,`Acres` = '0.162' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PARKWAY OAKS SEC 3, BLOCK 3, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7051' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RYLANDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'CINCO RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkway Oaks' ,`TaxAmount` = '6621' ,`TaxRate` = '2.73' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703231' WHERE `Matrix_Unique_ID` = '210894386' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T11:48:16.367' ,`MLSNumber` = '74716346' ,`ListAgentFullName` = 'David Nguyen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.703489' ,`Longitude` = '-95.522819' ,`PhotoCount` = '21' ,`PostalCode` = '77036' ,`RoomCount` = '11' ,`ListPrice` = '324000.00' ,`Status` = 'Active' ,`StreetName` = 'Edgemoor' ,`StreetNumber` = '7802' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2106' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained One-story Home located in the heart of the city in Chinatown. Cul-de-sac at an open-wide lot. ROOF 2016. Laminate Flooring throughout the house. Covered Patio. Beautiful Landscaping. Never Flooded. As you approach the house, the spacious living room has a bay window that lets in lots of natural light. A gas stove and built-in microwave are among the modern appliances in the open, which also have recessed lighting and under mount cabinet lighting. An additional room, a flex room/game room, and storage can be found everywhere in this three-bedroom house.' ,`Acres` = '0.3077' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TR 30A BLK 2 SHARPSTOWN SEC 5' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13403' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'NEFF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR GROVE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sharpstown Sec 05' ,`TaxAmount` = '6377' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703232' WHERE `Matrix_Unique_ID` = '210907212' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T10:59:29.930' ,`MLSNumber` = '75862107' ,`ListAgentFullName` = 'Della Abtahi' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.577734' ,`Longitude` = '-95.760952' ,`PhotoCount` = '24' ,`PostalCode` = '77469' ,`RoomCount` = '10' ,`ListPrice` = '379900.00' ,`Status` = 'Active' ,`StreetName` = 'Austin' ,`StreetNumber` = '515' ,`StreetSuffix` = 'Street' ,`City` = 'Richmond' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '1792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICE REDUCED, LOCATION...LOCATION. COMMERCIAL USE OR RESIDENTIAL OR BOTH, TOTALLY REMODELED, NEW EXTERIOR WOOD AND, NEW ROOF RECENTLY, AND INTERIOR SHEETROCK, NEW AIR-CONDITION AND WATER HEATER, TILE IN FIRST FLOOR AND WOOD FLOOR IN SECOND FLOOR. THE HOUSE WAS USED AS A COMMERCIAL AS A LAWYER OFFICE BUT IS READY for ANY KIND OF BUSINESS OR RESIDENTIAL, THERE IS AN AIRCONDITIONED STORAGE UNIT IN THE REAR. VERIFY ALL ROOM SIZES.NO HOA. PLEASE CALL THE LISTING AGENT FOR ANY INFORMATION AND QUESTION. THANKS' ,`Acres` = '0.1498' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'RICHMOND , BLOCK 40, LOT 12 (PT) & LOTS 13,14' ,`LotDesciption` = 'Corner' ,`LotSize` = '6525' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LONG ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Richmond' ,`TaxAmount` = '4832' ,`TaxRate` = '2.3748' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703232' WHERE `Matrix_Unique_ID` = '210917417' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T11:39:35.170' ,`MLSNumber` = '79582334' ,`ListAgentFullName` = 'Shlomo Cohen' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.679236' ,`Longitude` = '-95.475997' ,`PhotoCount` = '12' ,`PostalCode` = '77096' ,`RoomCount` = '9' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Braesvalley' ,`StreetNumber` = '5246' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2799' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the heart of Meyerland, this spacious 4 bedroom 2 1/2 bathroom home is situated on a large 11,000 square foot lot. This home features a large living area with high ceilings and lots of natural light. The updated kitchen has new cabinets with plenty of storage and granite counter tops. \nThis home is perfectly located just minutes away from braesbayou hike & bike trails and a wide variety of shopping and dining at Meyerland Plaza.' ,`Acres` = '0.2626' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 41 MEYERLAND SEC 6B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11441' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '483' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meyerland Sec 06b' ,`TaxAmount` = '6520' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703232' WHERE `Matrix_Unique_ID` = '210940709' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T10:17:32.487' ,`MLSNumber` = '46083398' ,`ListAgentFullName` = 'Patricia Grijalva' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.178072' ,`Longitude` = '-95.583561' ,`PhotoCount` = '49' ,`PostalCode` = '77382' ,`RoomCount` = '12' ,`ListPrice` = '735000.00' ,`Status` = 'Active' ,`StreetName` = 'Caulfield' ,`StreetNumber` = '31' ,`StreetSuffix` = 'Court' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3694' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don’t miss the opportunity to tour this beautiful house, located in the Village of Sterling Ridge in The Woodlands, features 5 spacious bedrooms, a game room, 3.5 baths and WOOW!! Two studies/offices on the first floor with French doors, or one study and a flex room that could be used as a second study, formal living or 6th bedroom. Open floor plan, full of light, nice views from every window, no back neighbors, travertine flooring, wood floors, this house has it all!! Freshly painted with a neutral color, brand new carpet, oversized garage,next to a peaceful pond park with a nice fountain, and a few steps from the Spindle Tree Jogging Trail reserve. New roof and new gutters 2021, upgraded security system, including window sensors in all windows, glass break detectors and cameras front and back of the house. Huge attic with finished flooring to store EVERYTHING you need.\r\nExemplary schools zone. Close to parks, trails, tennis courts, shopping centers, and restaurants. Don’t miss it' ,`Acres` = '0.2351' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S969940 - WDLNDS VIL STERLING RIDGE 40, BLOCK 1, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10242' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'TOUGH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Sterling Ridge 40' ,`TaxAmount` = '10406' ,`TaxRate` = '2.1816' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703232' WHERE `Matrix_Unique_ID` = '211164958' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T11:42:32.117' ,`MLSNumber` = '90937791' ,`ListAgentFullName` = 'Erik Jeffreys' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.475368' ,`Longitude` = '-95.672752' ,`PhotoCount` = '24' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '184900.00' ,`Status` = 'Active' ,`StreetName` = 'Spruce' ,`StreetNumber` = '20249' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1103' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy this new construction home in the peace and quiet of country living near the city! Minutes from Lake Conroe, this lovely 3 bedroom home is perfect for sharing dreams with friends and loved ones. Just imagine coming home from a hard day\'s work, kickin\' off your boots, and sittin\' back to enjoy an evening of casual conversation with the friendly neighbors! If you blink, it\'ll be gone so don\'t wait! Come by and see it... today!' ,`Acres` = '0.1263' ,`Area` = '39' ,`BuilderName` = 'Vanguard Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HIDDEN FOREST EST 03, LOT 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '36' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hidden Forest Estate 03' ,`TaxAmount` = '98' ,`TaxRate` = '1.8698' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703232' WHERE `Matrix_Unique_ID` = '211259387' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T11:47:41.330' ,`MLSNumber` = '35570786' ,`ListAgentFullName` = 'David Nguyen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.699345' ,`Longitude` = '-95.623231' ,`PhotoCount` = '30' ,`PostalCode` = '77083' ,`RoomCount` = '9' ,`ListPrice` = '279500.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Marlin' ,`StreetNumber` = '13574' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1870' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Beautiful 1-story corner lot with NEW UPGRADES: 2021 NEW ROOF, HVAC recent condenser (4 ton 14 SEER), LAMINATE FLOORS, FRESH PAINTS, LANDSCAPING, and indoor & exterior light fixtures. Roomy kitchen with lots of cabinetry and counter space, in kitchen breakfast area features a bay window, bringing lots of natural light into the home. Kitchen opens to dining room with a new skylight (2021) and living room with a corner gas fireplace. Wide hallway leads to your bedrooms with generous closets and a large hall closet. Primary bedroom opens to ensuite vanity area and bath. Huge walk-in closet in primary bedroom. Second bath has separate bath and vanity areas. Inside Utility room. Deck patio outside of living room and primary bedroom is a great area to entertain family and friends. NO FLOODING!!!' ,`Acres` = '0.1251' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 42 BLK 2 PHEASANT RUN VILLAGE' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '410' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'LIESTMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'KILLOUGH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pheasant Run Village' ,`TaxAmount` = '3979' ,`TaxRate` = '2.397' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703232' WHERE `Matrix_Unique_ID` = '211445292' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T10:40:35.433' ,`MLSNumber` = '98642150' ,`ListAgentFullName` = 'Bridgette Lester' ,`ListOfficeName` = 'RE/MAX Opportunities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.117577' ,`Longitude` = '-95.547196' ,`PhotoCount` = '5' ,`PostalCode` = '77515' ,`RoomCount` = '10' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Palomino' ,`StreetNumber` = '1325' ,`StreetSuffix` = 'Trail' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2034' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning, NEW CONSTRUCTION Home, under construction with an estimated completion date of 9/16/2022. This home sits on almost 1 acre of cleared land. Endless opportunities are awaiting. The home will feature 10\' ceilings throughout the living and kitchen area and 9\' ceilings in the bedrooms, bathrooms, and utility room, Tile floors throughout the home except in the bedrooms they are carpeted, Quartz Countertops, and the Utility room inside the home. The home comes with a builders warranty, water well warranty (1yr from installation date) and septic tank warranty (2yr from installation date).Bar X Ranch has several amenities that include: Pools, Playgrounds, 2 Lakes to Fish, Basketball and Tennis Courts.' ,`Acres` = '0.99' ,`Area` = '5' ,`BuilderName` = 'Villazana Constr' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BAR X RANCH SEC 4 (A0038 J B BAILEY) BLK 1 LOT 43 ACRES 0.99' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '43124' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bar X Ranch' ,`TaxAmount` = '212' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703232' WHERE `Matrix_Unique_ID` = '211479196' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T11:39:22.707' ,`MLSNumber` = '3579708' ,`ListAgentFullName` = 'Sharon Ballas' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.760472' ,`Longitude` = '-95.538255' ,`PhotoCount` = '41' ,`PostalCode` = '77024' ,`RoomCount` = '14' ,`ListPrice` = '1795000.00' ,`Status` = 'Active' ,`StreetName` = 'Pebble Hill' ,`StreetNumber` = '12003' ,`StreetSuffix` = 'Drive' ,`City` = 'Bunker Hill Village' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The classically styled brick facade with charming front porch is nestled in old growth oak trees & lends an elegant presence on lovely Pebble Hill Drive in Bunker Hill Village. Beautiful entry staircase. Graciously proportioned rooms with spacious formal living and dining rooms. The well-appointed study features softly painted paneled walls overlooking the front porch and grounds. Family room with fireplace opens to the breakfast room and adjoining kitchen. Primary suite down plus four large bedrooms up. Great back porch and wonderful yard with picturesque fountain. Three car garage plus additional parking.' ,`Acres` = '0.4934' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 LEXINGTON GREEN' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '21494' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'FROSTWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bunker Hill Village' ,`TaxAmount` = '22090' ,`TaxRate` = '2.1656' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703233' WHERE `Matrix_Unique_ID` = '211683200' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T10:54:15.803' ,`MLSNumber` = '21693547' ,`ListAgentFullName` = 'Tawni Slaughter' ,`ListOfficeName` = 'Stanfield Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.381847' ,`Longitude` = '-95.001752' ,`PhotoCount` = '29' ,`PostalCode` = '77591' ,`RoomCount` = '12' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Amburn' ,`StreetNumber` = '115' ,`StreetSuffix` = 'Road' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2466' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ranch-style home with a pool on an unrestricted 1.8-acre lot dotted with mature oak & pecan trees for shade! This charming stone & brick bungalow boasts spacious living & dining rooms with cased windows, an inviting breakfast room with a built-in buffet, and a must-see updated kitchen with a butcher block island, abundant white cabinetry, a glass tile backsplash, & recently replaced appliances. The home offers 3 bedrooms, 3.5 baths, tons of storage with cedar-lined closets, and a custom built-in bed in the hall bedroom. Step through the mudroom to the huge outdoor deck overlooking the pool, spa, & tiki hut bar. A great space for entertaining! The property also features multiple storage buildings, including one that is air-conditioned, a 2 car garage, a second driveway that could be used for boat or RV storage, and a 1 bedroom/1 bath cottage in the back that needs repairs. With no HOA restrictions, the possibilities are endless!' ,`Acres` = '1.824' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 2 S F AUSTIN SUR PT OF LOT 15 (15-1) AMBURN SUB' ,`LotDesciption` = 'Cleared' ,`LotSize` = '79453' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'SIMMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Amburn Sub N Ih 45' ,`TaxAmount` = '4509' ,`TaxRate` = '2.582' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703233' WHERE `Matrix_Unique_ID` = '211746099' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T10:25:34.623' ,`MLSNumber` = '23122810' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.238309' ,`Longitude` = '-95.315757' ,`PhotoCount` = '21' ,`PostalCode` = '77302' ,`RoomCount` = '5' ,`ListPrice` = '286990.00' ,`Status` = 'Active' ,`StreetName` = 'Lonely Pines' ,`StreetNumber` = '16663' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2182' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic brand NEW DR Horton home in the beautiful Granger Pines community! Lovely curb appeal with quaint front patio! Wonderful floor plan with island kitchen! Modern finishes, espresso cabinetry the kitchen and so much more! Bedroom offers a generous sized walk-in-closet and spacious bathroom! Also features a home automation system! Landscape package with useful covered back patio! Neighborhood includes an 11-acre community park, with a splash pad, 6-acre lake, pocket parks, trails, pavilion and more! Along with preserved open space, natural creeks, walking trails and green space! Hurry and call today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'DR HORTON' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 53 BLK 2 GRANGER PINES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOPE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Granger Pines' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703233' WHERE `Matrix_Unique_ID` = '211794666' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T10:37:22.357' ,`MLSNumber` = '16970636' ,`ListAgentFullName` = 'Kirk Williams' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.394693' ,`Longitude` = '-94.900880' ,`PhotoCount` = '15' ,`PostalCode` = '77590' ,`RoomCount` = '7' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = '10th' ,`StreetNumber` = '432' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1721' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Super cute 3 bedroom with 1 full bath and half bath on corner lot! New fence installed as of July of 2022. Roof is less than 2 years old! New carport is being installed over driveway area. Huge kitchen with nice gas stove/oven! Laminate flooring in kitchen area and wood flooring in most of home. Extra room in back of home with big inside utility room! Tons of decked out attic space perfect for extra storage! Lots of original charm and character in this home! Never flooded per seller! Come see this home today!' ,`Acres` = '0.1435' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 205 PAGE 5 LOTS 1 & 2 BLK 307 TEXAS CITY' ,`LotDesciption` = 'Corner' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'ROOSEVELT-WILSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Texas City' ,`TaxAmount` = '4421' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1941' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703233' WHERE `Matrix_Unique_ID` = '211825665' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T11:43:05.467' ,`MLSNumber` = '65078334' ,`ListAgentFullName` = 'Christina Osborne' ,`ListOfficeName` = 'Houston Realty Team' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.272354' ,`Longitude` = '-95.583339' ,`PhotoCount` = '9' ,`PostalCode` = '77316' ,`RoomCount` = '1' ,`ListPrice` = '900000.00' ,`Status` = 'Active' ,`StreetName` = 'Ponderosa' ,`StreetNumber` = '7202' ,`StreetSuffix` = 'Trail' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '1316' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Commercial Building just built! Can be used in so many ways! Incredible property and easy access to I45, FM1488, MF2854 and Aggie Hwy! It offers a 6000 Square foot Warehouse on ONE ACRE CORNER LOT! 14\' garage doors, plumbed for 2 bathrooms at each end, two entrance doors with two exit doors, electric has been installed, septic is being installed and should be completed by end of September. Very unique property and unrestricted!' ,`Acres` = '1' ,`Area` = '39' ,`BuilderName` = 'Seller-ArmstongBuild' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'S942000 - VALLEYWOOD ACRES, LOT 1, SERIAL ALCA0894680S22436,' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Valleywood Acres' ,`TaxAmount` = '1762' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663703233' WHERE `Matrix_Unique_ID` = '211845853' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T10:12:10.280' ,`MLSNumber` = '47062848' ,`ListAgentFullName` = 'Cheryl Castillo' ,`ListOfficeName` = 'House Guide Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.844833' ,`Longitude` = '-95.371212' ,`PhotoCount` = '34' ,`PostalCode` = '77022' ,`RoomCount` = '3' ,`ListPrice` = '315900.00' ,`Status` = 'Active' ,`StreetName` = 'Wynell' ,`StreetNumber` = '309' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2098' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 309 Wynell Street Located in the WYNELL TERRACE Community. This 3 bedroom 2 bath gated home is in an area that have no home owner association. Lots of new construction around and with close easy access to major freeways and retail. Property is occupied' ,`Acres` = '0.1747' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 WYNELL TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURBANK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER' ,`SchoolMiddle` = 'BURBANK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wynell Terrace' ,`TaxAmount` = '5954' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703233' WHERE `Matrix_Unique_ID` = '211847291' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T10:45:21.233' ,`MLSNumber` = '59218953' ,`ListAgentFullName` = 'Cindy Beltran' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.339441' ,`Longitude` = '-95.095552' ,`PhotoCount` = '6' ,`PostalCode` = '77327' ,`RoomCount` = '3' ,`ListPrice` = '85000.00' ,`Status` = 'Active' ,`StreetName` = 'Dunnam' ,`StreetNumber` = '524' ,`StreetSuffix` = 'Avenue' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1474' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investors Bring your offers! Homes is conveniently located near major highway i-69 and 105. Lots of potential! Home is ready for a new uplift. Check out the barn style storage in the back. It can be used as a work area or as a garage to park your vehicles in! Don\'t miss out of this great opportunity.' ,`Acres` = '0.1722' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'MERCY, LOT 37, ACRES .1722' ,`LotDesciption` = 'Other' ,`LotSize` = '7501' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mercy' ,`TaxAmount` = '2127' ,`TaxRate` = '2.5563' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663703233' WHERE `Matrix_Unique_ID` = '211849188' --> Updated record success