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-09-02T19:59:21.307' ,`MLSNumber` = '86762662' ,`ListAgentFullName` = 'Carolina Beltran' ,`ListOfficeName` = 'Matrix Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.946479' ,`Longitude` = '-95.319024' ,`PhotoCount` = '31' ,`PostalCode` = '75862' ,`RoomCount` = '3' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'CORAL GABLES' ,`StreetNumber` = '262' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL 3 BED 2 Bath NOW READY!! COMPLETED!. 2 STORY. All Granite white bathrooms, Kitchen and back splash. Custom cabinets.Master Bedroom and secondary room will have carpet and title in all other areas. 30 Year Roof, High Efficiency AC, back porch. Brick and stone. Brick both sides of the home. Gated community, Public Pool, Golf Course and Tennis court. Access to Lake Livingston and much much more.' ,`Acres` = '' ,`Area` = '42' ,`BuilderName` = 'LFC Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 11 LOT 01' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2136' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'WESTWOOD SHORES' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706044' WHERE `Matrix_Unique_ID` = '202636743' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T18:19:08.693' ,`MLSNumber` = '71711265' ,`ListAgentFullName` = 'Michael Gray' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.710920' ,`Longitude` = '-95.458927' ,`PhotoCount` = '12' ,`PostalCode` = '77401' ,`RoomCount` = '0' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Winslow' ,`StreetNumber` = '500' ,`StreetSuffix` = 'Lane' ,`City` = 'Bellaire' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Incredible corner lot to build your dream home in Bellaire located inside the loop.\r\nZoned to Horn Elementary and a short walk to all this part of Bellaire has to offer,\r\nEvelyn’s Park, Episcopal HS, Evergreen park, as well as the Horn fields. This location\r\nis just minutes to the Galleria, the medical center, as well as downtown and super\r\nconvenient to highway 59 and 610. A well-laid-out lot that will allow for multiple\r\nbuild options and layouts.' ,`Acres` = '0.1756' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 1 BLK 1 RICHMOND POST OAKS' ,`LotDesciption` = 'Corner' ,`LotSize` = '7650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HORN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Richmond Post Oaks' ,`TaxAmount` = '11126' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663706044' WHERE `Matrix_Unique_ID` = '205895137' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T18:32:19.323' ,`MLSNumber` = '31952112' ,`ListAgentFullName` = 'Carlos Perez' ,`ListOfficeName` = 'Affinity Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.547897' ,`Longitude` = '-95.578024' ,`PhotoCount` = '22' ,`PostalCode` = '77479' ,`RoomCount` = '11' ,`ListPrice` = '1690000.00' ,`Status` = 'Active' ,`StreetName` = 'Miramar Heights' ,`StreetNumber` = '15' ,`StreetSuffix` = 'Circle' ,`City` = 'Sugar Land' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6282' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom Home in one of Riverstone\'s most desirable gated communities. Exquisite taste all over this magnificent home. Designed for entertainment and functionality. As you enter this fabulous home, you will be able to see a curved staircase to die for. Both Formals and office suite. The Kitchen is centrally located, it is the heart of the home, breakfast area, and family room adjacent to it. Full bathroom with access to the pool area with outdoor kitchen and terrace. Upstairs you will enjoy a large media room, game room, and four bedrooms each with direct access to a bathroom. Verify measurements, HOA, any additional fees or anything that is important for you.' ,`Acres` = '0.3645' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CRESCENT VIEW ESTATES AT RIVERSTONE, BLOCK 2, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15879' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SULLIVAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Crescent View Estates At Riverstone' ,`TaxAmount` = '38128' ,`TaxRate` = '2.4259' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706045' WHERE `Matrix_Unique_ID` = '206437528' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T18:05:58.390' ,`MLSNumber` = '81912418' ,`ListAgentFullName` = 'Yasmin Alvarado' ,`ListOfficeName` = 'Texas Skyline Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.604739' ,`Longitude` = '-95.218218' ,`PhotoCount` = '13' ,`PostalCode` = '77089' ,`RoomCount` = '10' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Sagebriar' ,`StreetNumber` = '10602' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION!!!\nThis is one of the kind House 2 min. from beltway 8, 3 min. from 45 Freeway.\nYou must see it.....\nThis beautiful 4 bedrooms house , 2 1/2 bathrooms has so much to offer close to schools, shopping centers, restaurants, theatres and mayor Freeway.\nNice neighborhood..\nYou don\'t want to miss it.\n\nNEVER BEEN FLOOD' ,`Acres` = '0.1716' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 3 SAGEMONT PARK SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '7475' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'STUCHBERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sagemont Park Sec 01' ,`TaxAmount` = '5388' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663706045' WHERE `Matrix_Unique_ID` = '208657433' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T19:17:12.183' ,`MLSNumber` = '12569478' ,`ListAgentFullName` = 'Susana Barreto' ,`ListOfficeName` = 'Texas Realty' ,`SellingAgentFullName` = 'Susana Barreto' ,`SellingOfficeName` = 'Texas Realty' ,`Latitude` = '29.826951' ,`Longitude` = '-95.714138' ,`PhotoCount` = '32' ,`PostalCode` = '77449' ,`RoomCount` = '7' ,`ListPrice` = '335000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Flatwood' ,`StreetNumber` = '3806' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2270' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 1 Story split floor plan with high ceilings. Formal living and Dining areas, kitchen boast granite countertop, tile backsplash and breakfast area. Family room with a gas fireplace, master bedroom with a garden tub & a walk in shower. Study can be used as a 4th bedroom. It has a softener water system. Ceramic floor and new paint. A great floor plan in Westfield. Zoned to a desirable Katy ISD school district. Schedule a showing soon before it gets away.' ,`Acres` = '0.1584' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 3 WESTFIELD SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RHOADS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CARDIFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield Sec 10' ,`TaxAmount` = '6259' ,`TaxRate` = '2.822' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706045' WHERE `Matrix_Unique_ID` = '209013977' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T19:47:33.637' ,`MLSNumber` = '48129566' ,`ListAgentFullName` = 'Huglimar Colmenarez' ,`ListOfficeName` = 'Correa Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.742205' ,`Longitude` = '-95.883838' ,`PhotoCount` = '22' ,`PostalCode` = '77494' ,`RoomCount` = '8' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Zephyr Park' ,`StreetNumber` = '3307' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house is a one-story home featuring 4 bedrooms, 2 baths, and 2 car garage. The long foyer with an entry coat closet leads to the open concept kitchen and breakfast area. The kitchen includes a breakfast bar with granite countertops, stainless steel appliances, a corner pantry and opens to the family room. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, a water closet, and a spacious walk-in closet.' ,`Acres` = '0.1395' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TAMARRON SEC 43, BLOCK 6, LOT 41' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6075' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'TAMARRON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron Sec 43' ,`TaxAmount` = '7404' ,`TaxRate` = '3.0648' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706045' WHERE `Matrix_Unique_ID` = '209688673' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T19:55:42.207' ,`MLSNumber` = '10615264' ,`ListAgentFullName` = 'Craig Jones' ,`ListOfficeName` = 'Eastex Real Estate Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.717072' ,`Longitude` = '-94.928805' ,`PhotoCount` = '24' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '179000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Hill' ,`StreetNumber` = '511' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3862' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pine Hill Cottage is a large home originally built in 1955 featuring 3 bedrooms and 2.5 baths. This spacious home features two living rooms with a large kitchen with plenty of cabinet and counter space. The den has vaulted ceiling and the property has a quite porch with views of the outdoors. The home is centrally located in Livingston where you can easily get to Lake Livingston or the Naskila Gaming. The commute to the Houston area is also easy by way of 59/I69. Come take a look at this unique home today!' ,`Acres` = '0.384' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'EASTWAY BLK 9 LOT 1-B E/2 & 2' ,`LotDesciption` = 'Corner,Other,Subdivision Lot' ,`LotSize` = '16727' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Eastway' ,`TaxAmount` = '2916' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706045' WHERE `Matrix_Unique_ID` = '209737987' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T19:29:18.183' ,`MLSNumber` = '31945818' ,`ListAgentFullName` = 'Lori Selman' ,`ListOfficeName` = 'NextHome Realty Center' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.986161' ,`Longitude` = '-95.682499' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '12' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Cypress' ,`StreetNumber` = '16706' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3711' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a ton of space?? This home definitely has it at 3700 square feet! Situated in a beautiful community along a tree-lined street, this home is super charming with a covered porch, three car garage and a beautiful open concept. Kitchen, with large island, tons of cabinets, and stainless appliances. The Fridge, washer and dryer stay! Bamboo wood flooring thru-out the downstairs. Formal living/dining room as well as a nice study compliment this amazing floor plan. New interior paint. Upstairs you will find a huge game room to entertain your friends and family! The large primary suite offers an in-suite bathroom with double sinks, soaker tub and separate shower. The three secondary bedrooms are also very nice sizes. The roof was replaced in the within the past few years. The fence was already recently replaced. No rear neighbors offer this backyard a lot of privacy! No flooding here per sellers! What are you waiting for, check out your NextHome today!!!' ,`Acres` = '0.1609' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 CYPRESS POINT LAKE ESTATES SEC 5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7007' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FARNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Point Lake Estates 05' ,`TaxAmount` = '7427' ,`TaxRate` = '2.751' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706045' WHERE `Matrix_Unique_ID` = '209920289' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T18:07:11.833' ,`MLSNumber` = '98492459' ,`ListAgentFullName` = 'Craig Perez' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.785041' ,`Longitude` = '-94.920845' ,`PhotoCount` = '36' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou' ,`StreetNumber` = '5115' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1876' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BACK ON THE MARKET!!! STUNNING freshly remodeled home in a quiet and wooded neighborhood on an ACRE lot! Fully gated and fenced with wraparound driveway that extends into the back with a large carport! Beautifully updated kitchen with island that flows into spacious living area, perfect for entertaining guests! Garage is equipped with two new A/C splits! New septic tank has been installed along with spray foam insulation throughout. This house is truly remarkable, a one of one! Call or text to schedule your showing TODAY!' ,`Acres` = '1' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 5 & 9F ABST 123 B BARROW ABST 591 D MCFADDEN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43549' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'D Mcfadden Tr 5f Abst 591' ,`TaxAmount` = '2607' ,`TaxRate` = '2.285' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706045' WHERE `Matrix_Unique_ID` = '210258963' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T18:18:26.667' ,`MLSNumber` = '21151235' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.293859' ,`Longitude` = '-95.551977' ,`PhotoCount` = '34' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '483576.00' ,`Status` = 'Active' ,`StreetName` = 'Stargazer Lily' ,`StreetNumber` = '209' ,`StreetSuffix` = 'Bend' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#21151235- REPRESENTATIVE PHOTOS ADDED! Built by Taylor Morrison, Ready October The Evergreen! This home will have you feeling like you have a one-of-a kind new home. Embrace this 2-bedroom 2-bathroom home with a flex and open concept gathering room. The extravagant foyer will reel you in upon entry with clean lines and wall space for your personal décor. The flex room can be used as a study or home office. Entertain in the gathering room that flows seamlessly to the perfect kitchen and breakfast area. The owner\'s suite will become your own personal sanctuary with the lovely bathroom and walk-in closet. Structural options at 209 West Stargazer Lily Bend include: bay window at owner\'s suite, 4ft garage extension, raised ceilings in foyer and living areas, and 8ft interior doors.' ,`Acres` = '0.169' ,`Area` = '39' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21 Block 1 Section 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7389' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2825' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonterra at Woodforest 50\'s' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706046' WHERE `Matrix_Unique_ID` = '210494481' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T18:19:52.250' ,`MLSNumber` = '76439146' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.289863' ,`Longitude` = '-95.550121' ,`PhotoCount` = '10' ,`PostalCode` = '77316' ,`RoomCount` = '10' ,`ListPrice` = '628482.00' ,`Status` = 'Active' ,`StreetName` = 'Wild Petunia' ,`StreetNumber` = '142' ,`StreetSuffix` = 'Trail' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2508' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 76439146 ~ Built by Taylor Morrison, December Completion - The Juniper! This beautiful floor plan is cozy & functional! Stunning architecture will stop you in your tracks. The adorable front porch perfect for relaxing followed by an impressive foyer and study rooms. The heart of the home opens to the kitchen, dining and gathering room. The island kitchen is the perfect place to entertain guests while cooking and spending time together before relaxing in the gathering room. On nice evenings, unwind on the covered patio. Two equally sized guest rooms share a bathroom, and on its own side of the home is the owner\'s suite complete with separate walk-in closets, dual sinks, and large walk-in shower. Structural options for 142 South Wild Petunia Trail include: second sink at bath 2, bay window at owner\'s suite, walk-in shower in owner\'s bath, fireplace in family room, raised ceilings at foyer, gathering room and kitchen.' ,`Acres` = '0.217' ,`Area` = '39' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10, Block 1, of Bonterra At Woodforest Section 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9490' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2825' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonterra at Woodforest 60\'s' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706046' WHERE `Matrix_Unique_ID` = '210498988' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T18:10:02.217' ,`MLSNumber` = '96551269' ,`ListAgentFullName` = 'Elena Bryant' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.591384' ,`Longitude` = '-95.095614' ,`PhotoCount` = '23' ,`PostalCode` = '77058' ,`RoomCount` = '7' ,`ListPrice` = '396500.00' ,`Status` = 'Active' ,`StreetName` = 'Cornell Park' ,`StreetNumber` = '3923' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2726' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE-IN READY PATIO HOME IN DESIRABLE UNIVERSITY PARK. THIS PROPERTY IS LOCATED IN A QUIET CUL-DE-SAC WITH A SPACIOUS OPEN CONCEPT KITCHEN, A BREAKFAST AREA, AND A LIVING ROOM WITH GREAT VIEWS OF THE BACKYARD. A FORMAL DINING ROOM/STUDY, A FLEX ROOM UPSTAIRS THAT COULD BE USED AS A GAME ROOM, AN EXTRA BEDROOM, OR AN OFFICE. A NICE COVERED PATIO AND BEAUTIFULLY LANDSCAPED BACKYARD WILL MAKE YOU FEEL AT HOME. LOCATED A FEW MINUTES FROM JOHNSON SPACE CENTER, KEMAH BOARDWALK, EASY ACCESS TO MAJOR FREEWAYS, SHOPPING, AND DINING. ZONED TO EXEMPLARY CLEAR CREEK INDEPENDENT SCHOOL DISTRICT.' ,`Acres` = '0.1382' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 2 UNIVERSITY PARK PATIO HOMES 3' ,`LotDesciption` = 'Cul-De-Sac,Patio Lot' ,`LotSize` = '6018' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BROOKWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'University Park Patio Homes 03' ,`TaxAmount` = '7930' ,`TaxRate` = '2.5419' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706046' WHERE `Matrix_Unique_ID` = '210555145' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T18:24:40.317' ,`MLSNumber` = '95288091' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.855698' ,`Longitude` = '-95.192330' ,`PhotoCount` = '27' ,`PostalCode` = '77044' ,`RoomCount` = '6' ,`ListPrice` = '265290.00' ,`Status` = 'Active' ,`StreetName` = 'Lanrin' ,`StreetNumber` = '13215' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1357' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COMPLETION JANUARY/FEBRUARY 2023 A beautiful Colina built show-case home, features brick front and cemplank fiber-cement 8” siding 9’ ceilings throughout . Kitchen features large walk-in pantry, 42” Expresso Cabinets, New Caledonia Granite , recessed can lighting, home 9” farmhouse sink stainless-steel sink and stainless-steel appliances to include our premium 5 burner range. Oversized master bedroom and bathroom with marble vanity sink, separate garden tub, glass shower and walk-in closet. 12x12 Twighlight Grey ceramic tile backsplash in all wet areas. Luxury vinyl planking in entry, living room, kitchen bathrooms and hallways. 2\" blinds, garden tub plus separate walk-in shower. Pex Plumbing, Lennox 16 seer A/C. Taexx Pest Control. All this included for you. Don\'t miss out on 365 day rate lock or $0 down no PMI. PHOTOS ARE REPRESENTATIVE.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 5 Section 6' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tidwell Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706046' WHERE `Matrix_Unique_ID` = '210656225' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T18:26:22.463' ,`MLSNumber` = '51807249' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.858927' ,`Longitude` = '-95.193863' ,`PhotoCount` = '19' ,`PostalCode` = '77044' ,`RoomCount` = '7' ,`ListPrice` = '294290.00' ,`Status` = 'Active' ,`StreetName` = 'Vuitton' ,`StreetNumber` = '13218' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '1978' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COMPLETION JANUARY/FEBRUARY 2023Brand new 2 story 5-bedroom 3.5 bath 2 car garage. Colina Home features granite countertops, 42” cabinets, stainless steel range, microwave, and dishwasher, kitchen tile backsplash and island. 9’ ceilings, 2” blinds throughout, large garden tub with separate shower, marble vanity, large walk-in closet, carpet only in bedrooms, luxury vinyl wood plank throughout. Raised panel doors, rounded sheetrock corners and archways. 365 day rate lock or $0 down no PMI. PHOTOS ARE REPRESENTATIVE' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10, Blk 5, Section 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tidwell Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706046' WHERE `Matrix_Unique_ID` = '210776406' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T18:16:09.780' ,`MLSNumber` = '82463213' ,`ListAgentFullName` = 'Judy Dusenbury' ,`ListOfficeName` = 'Judy Dusenbury, Broker' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.091531' ,`Longitude` = '-95.726199' ,`PhotoCount` = '50' ,`PostalCode` = '77377' ,`RoomCount` = '13' ,`ListPrice` = '1699000.00' ,`Status` = 'Active' ,`StreetName` = 'CHATEAU RIDGE' ,`StreetNumber` = '19327' ,`StreetSuffix` = 'Court' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4281' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**REMARKABLE CUSTOM 1 STORY IN PRIVATE GATED COMMUNITY**NESTLED ON OVER 2 ACRES WITH TOTAL PRIVACY**4 BDRMS*3 1/2 BTH + 1/2 IN GARAGE*OVERSIZE 4 CAR + 5 CAR CARPORT*STORAGE BUILDING*EXTREME ATTENTION TO DETAIL THRU-OUT HOME*BRICK FLOORS*HIGH CEILINGS, BEAMS, DOUBLE CROWN, 8\" BASEBOARDS*MAIN KITCHEN W/ISLAND, 6 BURNER VIKING RANGE, FARM SINK,COMPACTOR, LIGHTED GLASS FRONT CABINETS & ADDITIONAL \'WORKING KITCHEN\' FOR ALL PREP WORK W/2ND SINK, DBLE OVENS, REFRIGERATOR, ICE-MAKER*OVERSIZE DINING+BREAKFAST AREA+11\' BREAKFAST BAR PROVIDE LOTS OF EATING SPACE*FORMAL LIVING/STUDY/MUSIC ROOM OFF ENTRY FOYER*PRIVATE OVERSIZE PRIMARY SUITE W/SITTING AREA, VIEW OF BACK GARDENS,LUXURY BATH W/DUAL SINKS, JACUZZI TUB,SHOWER TOWER,DUAL CLOSETS,LINEN STORAGE*SEPARATE SECONDARY BEDRMS W/BATH*WORKING OFFICE SPACE W/2 DESK AREA*CHEERFUL UTILITY TO PLEASE ANYONE*SO MANY BUILT-INS*SURROUND SOUND -MOST ROOMS*2 A/C, 1-2022, 1-2018* 2 TANKLESS HOT WATERS <1 YR*WELL PUMP-1 YR*NO MUD TAX*TOMBALL SCHOOLS*' ,`Acres` = '2.0614' ,`Area` = '35' ,`BuilderName` = 'JAMES WALLACE' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 1 ROSEHURST' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '89793' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '725' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'ROSEHILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'ROSEHURST' ,`TaxAmount` = '18790' ,`TaxRate` = '2.1425' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706046' WHERE `Matrix_Unique_ID` = '210988929' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T18:08:32.953' ,`MLSNumber` = '33194652' ,`ListAgentFullName` = 'Brian Carter' ,`ListOfficeName` = 'TCG' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.380409' ,`Longitude` = '-95.480183' ,`PhotoCount` = '23' ,`PostalCode` = '77303' ,`RoomCount` = '7' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Rain' ,`StreetNumber` = '4909' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1696' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4909 Summer Rain Drive is a gorgeous home in exceptional condition. This home has been meticulously maintained and is simply amazing. Overall this home features 3 bedrooms, 2 bathrooms, a spacious family room, large kitchen, and a nice covered patio. There is absolutely no carpet in the entire home and you will be truly impressed by the cleaniness. The walls are freshly painted and feature a nice relaxing grey tone. The exterior of the home is beautiful, elegant, and timeless. The front porch area is lovely and perfect for your outdoor furniture. There is a gorgeous fireplace that provides beauty and warmth to the family room. The kitchen has ample cabinet and countertop space and is highlighted by 3 beautiful pendant lights! Overall this home is truly special!' ,`Acres` = '0.1353' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S906400 - SUMMER WOOD 01, BLOCK 2, LOT 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5894' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'A.R. TURNER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Summer Wood 01' ,`TaxAmount` = '3805' ,`TaxRate` = '2.1823' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706046' WHERE `Matrix_Unique_ID` = '211053137' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T18:26:04.977' ,`MLSNumber` = '12615537' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.290074' ,`Longitude` = '-95.553413' ,`PhotoCount` = '33' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '478004.00' ,`Status` = 'Active' ,`StreetName` = 'Turks Cap' ,`StreetNumber` = '311' ,`StreetSuffix` = 'Trail' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1752' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#12615537 REPRESENTATIVE PHOTOS ADDED January Completion! Built by Taylor Morrison specifically for age restricted 55+ communities. The attractive 1501 plan is a one-story home with a welcoming front porch. Just off the entry foyer, a study with double doors offers a private office space. Head into the beautiful open kitchen that is connected to the dining room and spacious family room. In the designer kitchen you\'ll find a large island and step-in pantry. This gathering area is perfect for entertaining. The second bedroom with bath is located at the front of the home. Relax in the owner\'s suite, providing a peaceful haven with spa-like bathroom and walk-in closet. Bonterra’s amenities include a 10,000 sq ft community Clubhouse with fitness center, spa, game room, lagoon style pool, pickleball courts and more. Structural options added at 311 N Turks Cap Trail include: Alternate Kitchen, Extended Covered Patio, 8\' Interior/Exterior Doors' ,`Acres` = '0.143' ,`Area` = '39' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BONTERRA AT WOODFOREST Lot 10, Blk 1, Sec 7' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '6253' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2825' ,`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` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonterra at Woodforest' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706047' WHERE `Matrix_Unique_ID` = '211221885' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T18:46:05.303' ,`MLSNumber` = '25009050' ,`ListAgentFullName` = 'Shelly Hyatt' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.245420' ,`Longitude` = '-95.127163' ,`PhotoCount` = '26' ,`PostalCode` = '77372' ,`RoomCount` = '9' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Country Colony' ,`StreetNumber` = '27960' ,`StreetSuffix` = 'Drive' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3156' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This amazing home sits on 5+ acres of unrestricted land in sought-after Splendora ISD, only minutes away from major highways and shopping. Inside you will find a spacious living area with lots of natural sunlight that opens up to the kitchen/dining area that features upgraded appliances a beautifully enlarged, custom island, and a wood-burning fireplace. There are four large bedrooms and two full bathrooms. Outside you will find a shed and a barn offers endless possibilities due to its space and electricity. This is truly a diamond in the rough just needing your TLC to shine her up! Don\'t let this one get away! Schedule a private showing today!' ,`Acres` = '5.05' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'COUNTRY COLONY 82, LOT 21, PT LT 22, ACRES 5.05' ,`LotDesciption` = 'Cleared' ,`LotSize` = '219978' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'GREENLEAF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Colony 82' ,`TaxAmount` = '4596' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663706047' WHERE `Matrix_Unique_ID` = '211281725' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T18:38:40.443' ,`MLSNumber` = '2822146' ,`ListAgentFullName` = 'Leslie Kelly-Nicholls' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = 'Candice Williams' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '30.074000' ,`Longitude` = '-95.165649' ,`PhotoCount` = '50' ,`PostalCode` = '77345' ,`RoomCount` = '14' ,`ListPrice` = '519990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Aspen Pass' ,`StreetNumber` = '6009' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Award Winning Meritage Suzanne Floor Plan. An immaculately kept home with many recent updates. Massive Garage is perfect for Golf Cart & extra storage. Freshly Painted Interior throughout, Energy Rated with all LED, very low electric bills.New Carpet, Painting throughout, wood floors, Primary Shower The dramatic 2 story Mezzanine Entry is open to both Formals & Study, complete with Picture Windows overlooking the front Veranda/Patio. Very spacious rooms throughout this impressive home. Stainless Appliances, Granite Counters, plus extensive Crown Molding & Lighting. This coveted Floor Plan has a massive Game Room & private Media Room off of the Staircase Upstairs, with Juliet Cut-outs providing views of the Entry, Formals & Family Room below. The private Backyard backs to no neighbors with an inviting Pebble Tec Pool/Spa & ample Covered Patio for year round entertaining. Not in Flood Zone and Never Flooded.' ,`Acres` = '0.1879' ,`Area` = '32' ,`BuilderName` = 'Meritage' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 3 VILLAGES OF RIVERCHASE SEC 2' ,`LotDesciption` = 'Cleared,In Golf Course Community,Subdivision Lot' ,`LotSize` = '8186' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SHADOW FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverchase' ,`TaxAmount` = '10602' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706047' WHERE `Matrix_Unique_ID` = '211362177' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T18:18:58.133' ,`MLSNumber` = '30776086' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830688' ,`Longitude` = '-95.805095' ,`PhotoCount` = '20' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '284990.00' ,`Status` = 'Active' ,`StreetName` = 'Deledda' ,`StreetNumber` = '3922' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1643' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Camillo Lakes in Katy, TX! The Sequoia floor plan is a spacious 2-story home with 3 bedrooms, 2.5 baths, and 2-car garage. This home has it all, including blinds, upgraded carpeting in the bedrooms, and vinyl plank flooring throughout the first-floor common areas! The first floor offers the perfect space for entertaining with a large kitchen island open to both the living and dining areas! The gourmet kitchen is sure to please with 42\" cabinetry, granite countertops, and stainless steel appliances! Upstairs offers a split floor plan and private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring double sinks, a sizable shower, and Texas-sized walk-in closet! Enjoy the great outdoors with full sod and a sprinkler system! Don\'t miss your opportunity to call Camillo Lakes home, schedule a visit today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'LEGEND HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 4 CAMILLO LAKES SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2482' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'CAMILLO LAKES' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706047' WHERE `Matrix_Unique_ID` = '211434450' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','211633314','1663706047','211633314','2022-09-02T18:30:43.103','917227','Stephen Metarelis','Offerpad Brokerage, LLC','','','29.536935','-95.173223','10','77546','4','344900.00','Active','Silver Spruce','4703','Lane','Friendswood','2','1','4','2476','Single-Family','Stunning two-story home in a desirable Heritage Park subdivision and zones to Clear Creek ISD. The home features a solar system, a personal gas generator, and a water softener. Fresh interior paint. Laminate flooring throughout living areas. Brand new carpets were installed in all bedrooms, stairs, and the second floor. Upgraded primary bedroom. The kitchen features a granite countertop with all stainless appliances and a refrigerator. Washer and dryer included. Owned solar panels. Big backyard with covered patio, and fully fenced. Quick access to I45.','0.1879','7','','','','','Sellers Disclosure','1','','1','Friendswood','Central Gas','1','LT 40 BLK 2 HERITAGE PARK SEC 29','Cul-De-Sac','8187','Appraisal District','','436','0','','2','Gas Oven','0','','','Gas Range','','Composition','9 - Clear Creek','GREENE ELEMENTARY SCHOOL','CLEAR BROOK HIGH SCHOOL','BROOKSIDE INTERMEDIATE SCHOOL','Request Online Appointment','Appraisal District','2','Traditional','Heritage Park Sec 29','6030','2.166','Water District','2004','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212015504','1663706047','212015504','2022-09-02T19:48:29.093','70105919','Morad Fiki','Keller Williams Metropolitan','Andre Tolbert','Coldwell Banker Realty','29.163189','-95.632995','33','77486','8','375000.00','Pending Continue to Show','Amherst','361','Drive','West Columbia','2','0','4','2474','Single-Family','READY FOR MOVE-IN! Stunning New Construction located in the beautiful community of Columbia Lakes! Offering a beautiful traditional facade, the exterior features rustic timber beams & columns, a brick exterior, a well-manicured landscape, & front porch where you can sit & enjoy the cool summer evenings. Inside features a well-thought-out & open floor plan, with the great room immediately greeting you as you enter the home. You\'ll enjoy the tiered ceilings, large windows, & quick access to the rear porch & backyard through the double doors. Towards the center of the home, you\'ll find the chef\'s kitchen with a butler\'s pantry or possible coffee bar, a separate island with bar seating, & the dining room adjacent to the kitchen - perfect for entertaining! The spacious primary bedroom & ensuite bathroom offer dual vanity sinks, a separate spa tub & standing shower, & a large walk-in closet with built-in shelf space. Don\'t miss this incredible home!!!','0.2668','5','Fiki Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Owner/Agent','1','Mock Fireplace','1','West of the Brazos','Central Gas','1','COLUMBIA LAKES SEC 3 (A0133 M VARNER) BLK 28 LOT 51','Subdivision Lot','11622','Appraisal District','','45','1','Never Lived In','2','Electric Oven','0','','','Electric Cooktop,Gas Cooktop','','Composition','10 - Columbia-Brazoria','','COLUMBIA HIGH SCHOOL','WEST BRAZOS JUNIOR HIGH','Appointment Required','Builder','1','Contemporary/Modern,Ranch,Traditional','Columbia Lakes','523','2.2487','Water District','2021','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212099111','1663706047','212099111','2022-09-02T18:12:23.270','3426811','Justin Dickey','Keller Williams Professionals','','','29.401162','-95.056193','47','77568','8','332990.00','Active','Bonita Island','13505','Lane','Texas City','3','0','4','1982','Single-Family','BEAUTIFUL BRAND NEW COLINA HOME- LARGE 1STORY WITH 4 BEDROOMS, 3 FULL BATHS , WITH STUDY, INCLUDES 2\' FAUX WOOD BLINDS, BUILT IN TAEXX PEST CONTROL, BACK COVERED PATIO, GRANITE KITCHEN, 42\" WHITE CABINETS WITH CROWN MOLDING, 9\" SINGLE BOWL KITCHEN SINK, STAINLESS STEEL 5 BURNER GAS APPLIANCES, VINYL PLANK FLOORING EVERYWHERE EXCEPT & BEDROOMS, OPEN HOME PLAN, BRICK ELEVATION, FRONT GUTTERS, LENNOX 16 SEER A/C, 4TH SIDE BRICK AND MUCH MORE! These are photo\'s of the home plan not of the actual property. MOVE IN READY!','','33','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Santa Fe','Central Gas','1','Lot 15 Block 1 Sec 3','Subdivision Lot','','Other','','1330','1','Never Lived In','2','Freestanding Oven','0','','','Gas Cooktop','','Composition','17 - Dickinson','LOBIT ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Accompany','Builder','1','Contemporary/Modern,Traditional','Lago Mar','','3.55','Water District','2021','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212099234','1663706047','212099234','2022-09-02T18:08:41.050','56274396','Justin Dickey','Keller Williams Professionals','','','29.405309','-95.061251','33','77568','12','334750.00','Active','Diamond Reef','13532','Lane','Texas City','2','1','3','2201','Single-Family','This 2201 Sq. Ft. 2 Story plan offers an attractive curb appeal, oversized breakfast bar, ample counter space in the kitchen and a study! The Great Room has 17\' high Ceilings. Home features Satin Nickel Moen Faucets, Granite Counter-Tops and 42\" Cabinets, and Frigidaire stainless steel appliances. 2\" blinds, recessed can lighting in the kitchen. 5 burner gas range, single under-mount kitchen sink, high ceilings, gas and electric connections, vinyl plank flooring in all of the wet areas and living area. Master Bath has a separate shower and garden tub. Home elevation is awesome with a front porch and lots of architectural details for a nice curb appeal. This home has American Made Acme brick on 1st floor. ASK about the Pest Defense System, Pex Plumbing, Lennox AC, 30 Year Shingle, Front Gutters also included. THIS HOME IS READY FOR MOVE IN!!!!','','33','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Texas City','Central Gas','1','LT 22 BLK 3 POD 2','Subdivision Lot','6000','Survey','','1330','1','Never Lived In','2','Electric Oven','0','','','Gas Cooktop','','Composition','17 - Dickinson','LOBIT ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Accompany','Builder','2','Traditional','Lago Mar','','3.55','Water District','2021','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212099325','1663706047','212099325','2022-09-02T18:09:45.977','59712818','Justin Dickey','Keller Williams Professionals','','','29.401162','-95.056193','21','77568','7','327505.00','Active','Windy Grove','2218','Drive','Texas City','2','1','3','2026','Single-Family','Inviting curb appeal CUL-DE-SAC LOT!! Check out the huge family room open to a spacious gourmet kitchen with 42\" cabinets with beautiful granite counter tops, 5 burner gas range, , vinyl plank flooring in all area\'s except bedrooms, Master suite boasts super sized closet, his and her bath vanities, separate tub/Shower, spacious back yard for relaxing and entertaining, plus garage opener!\r\nCome see this beautiful home with its 12-acre community lagoon!! THIS HOME COMES WITH STAINLESS KITCHEN W PREMIUM 5-BURNER STOVE, MICROWAVE & DISHWASHER ALONG WITH FULLY-SODDED FRONT YARD. EST COMPLETION APRIL 2022 These are photo\'s of the home plan not of the actual property. LAST ONE LEFT!','','33','Colina Homes','','','','Mud','1','','','Santa Fe','Central Gas','1','LT 12 BLK 1 SEC 1','Other','4400','Survey','','1330','1','Never Lived In','2','Electric Oven','0','','','Gas Cooktop','','Composition','17 - Dickinson','LOBIT ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Accompany','Builder','2','Contemporary/Modern','Lago Mar','','3.55','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212099414','1663706047','212099414','2022-09-02T18:00:33.323','9015806','Justin Dickey','Keller Williams Professionals','','','29.401162','-95.056193','34','77568','11','337590.00','Active','Golden Palms','2617','Lane','Texas City','2','1','3','2201','Single-Family','BEAUTIFUL BRAND NEW COLINA HOME- LARGE 2 STORY WITH 3 BEDROOMS, 2.5 BATHS , WITH FORMAL DINING ROOM, Study, INCLUDES 2\' FAUX WOOD BLINDS, BUILT IN TAEXX PEST CONTROL, BACK COVERED PATIO, GRANITE KITCHEN, 42\" CABINETS WITH CROWN MOLDING, 9\" SINGLE BOWL KITCHEN SINK, DOUBLE SINKS IN MASTER BATH, STAINLESS STEEL 5 BURNER GAS APPLIANCES, VINYL PLANK FLOORING EVERYWHERE EXCEPT & BEDROOMS, DINING ROOM AND STAIRS AND LOFT/GAMEROOM ( 2) OPEN HOME PLAN, BRICK ELEVATION, FRONT GUTTERS, LENNOX 16 SEER A/C , BRICK/STONE ELEVATION! THIS HOME IS MOVE IN READY!','','33','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Santa Fe','Central Gas','1','Lot 6 Block 2 sec 3','Subdivision Lot','','Survey','','1330','1','Never Lived In','2','Electric Oven','0','','','Gas Cooktop','','Composition','17 - Dickinson','LOBIT ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Accompany','Builder','2','Contemporary/Modern,Traditional','Lago Mar','','3.55','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212138993','1663706047','212138993','2022-09-02T18:41:01.483','84747142','Oscar Jalifi','The Local Agents Real Estate LLC','','','28.949901','-95.287866','17','77541','3','523500.00','Active','Surf','112','Drive','Surfside Beach','2','0','3','1170','Single-Family','Beautiful 3 bedroom, 2 bath home with many upgrades to make this a comfortable home or rental. Great views and sea breezes to melt away the stress. Once you leave the front deck and force yourself to take your eyes off the surf, you will find a modern kitchen, dining and living area. Down the hall there is a bath for the two secondary bedrooms and also a utility area. The primary is on the left with a private bath. You won’t want to miss this gem that is so close to the beach. It’s everything you’ve been dreaming about. Come see but be ready to make an offer when you fall in love.\r\nTenant occupied. Please do not walk onto deck or schedule showings until September 20,2022','0.1205','5','','','','','Sellers Disclosure','','','','Surfside','Central Electric','0','SURFSIDE BLK 514 LOT 5 (A0051 F J CALVIT)','Water View','5249','Appraisal District','','0','0','','0','','0','','','','','Composition','7 - Brazosport','VELASCO ELEMENTARY SCHOOL','BRAZOSPORT HIGH SCHOOL','FREEPORT INTERMEDIATE SCHOOL','Accompany,Appointment Required,Vacant/Unoccupied','Appraisal District','1','Traditional','Surfside Beach','5482','2.333','Public Sewer,Public Water','2012','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212145276','1663706047','212145276','2022-09-02T18:37:53.783','56789955','Ronnie Matthews','D.R. Horton Homes','','','30.059551','-95.360165','9','77373','6','320990.00','Active','Kentwood Springs','24059','','Spring','3','0','5','2498','Single-Family','AMAZING 5 BEDROOM!!! NEW CONSTRUCTION!! Wonderful brand NEW Express Home in Breckenridge Forest! Fantastic location! Charming curb appeal! Perfect floor plan with open living spaces and modern finishes! Lovely island kitchen with new gray cabinetry! Great Primary suite with large closet and oversized shower! Great outdoor space with covered back patio and landscape package! Breckenridge Forest has a great amenity center! Hurry and call today!! No Back Neighbors!','','12','Express Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Spring East','Central Gas','1','Lot 9, Blk 1, Section 1','Subdivision Lot','','','','400','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','48 - Spring','CHET BURCHETT ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','DUEITT MIDDLE SCHOOL','Appointment Required','Builder','2','Traditional','Breckenridge Forest','','','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212145986','1663706047','212145986','2022-09-02T19:20:28.320','60971143','Cynthia Pierce','Gann Medford Real Estate','','','31.316831','-94.736747','26','75904','4','195500.00','Active','Mark','902','Street','Lufkin','2','0','3','1208','Single-Family','Super cute and clean! 3 bedrooms and 2 baths. Flowing floor plan and neutral palette throughout. Completely updated. Kitchen with granite counters and stainless appliances. Fenced backyard. Attached double garage.','0.2829','45','','','','','Sellers Disclosure','1','','0','Angelina County','Central Electric','0','5395 OAKLAWN BLK 3 LOT 9','Subdivision Lot','12325','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','186 - Lufkin','','LUFKIN HIGH SCHOOL','LUFKIN MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Oaklawn','3103','2.3856','Public Sewer,Public Water','2006','Appraisal District'); --> New record created successfully