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-12-13T13:06:17.857' ,`MLSNumber` = '5672429' ,`ListAgentFullName` = 'Kathleen Smith' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.300217' ,`Longitude` = '-94.925166' ,`PhotoCount` = '12' ,`PostalCode` = '77554' ,`RoomCount` = '10' ,`ListPrice` = '895000.00' ,`Status` = 'Active' ,`StreetName` = 'Isles End' ,`StreetNumber` = '502' ,`StreetSuffix` = 'Road' ,`City` = 'Tiki Island' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2626' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL WELL-BUILT WATERFRONT 5 BEDROOM 3 BATH HOME ON TIKI ISLAND. DOWNSTAIRS FOYER USED AS 5TH BEDROOM. KITCHEN UPDATED. CUSTOM PLANTATION SHUTTERS. APPLIANCES REMAIN. PROPERTY IS LOCATED ON THE END OF THE ISLAND WITH GREAT VIEWS OF JONES LAKE AND ON LARGE CANAL. EASY ACCESS BY BOAT TO JONES LAKE AND WEST GALVESTON BAY.\r\nFANTASTIC BREEZE NEW LARGE PALAPA AND HVAC INSTALLED NOVEMBER 2020. EXCELLENT FISHING. PLEASE NOTE SELLERS ARE IN PROCESS OF PACKING AND MOVING.\r\nCALL LISTING AGENT TO SCHEDULE YOUR SHOWING!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S BURDICK SUR LOT 71 TIKI ISLAND SEC 10' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5009' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'TIKI ISLAND' ,`TaxAmount` = '11638' ,`TaxRate` = '2.3702' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090645' WHERE `Matrix_Unique_ID` = '208565419' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T14:43:20.470' ,`MLSNumber` = '75911232' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.782950' ,`Longitude` = '-95.034690' ,`PhotoCount` = '20' ,`PostalCode` = '77520' ,`RoomCount` = '9' ,`ListPrice` = '397000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Haven' ,`StreetNumber` = '414' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction! Huge private backyard with extended covered patio! The Trinity plan by CastleRock Communities is an open concept plan with a dramatic 2-story ceiling in the family room, 4 bedrooms, 2 1/2 baths, private study, game room, and 3 car garage! The huge eat-in kitchen features upgraded quartz counter tops, under mount stainless sink, upgraded 42\" cabinets, and stainless GE appliances! The truly gorgeous backsplash is the focal point of this kitchen! The main living areas boast Rigid Core flooring that is beautiful and durable! High-end upgraded black iron rails on the staircase! The primary bedroom is located on the first floor with an upgraded 12 x 24 tile in bath with a separate soaker tub & shower, as well as a walk-in closet! CastleRock Communities has builder backed 2/10 year warranty on all homes!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8, Block 78, Section R' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '19327' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Lakewood Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090645' WHERE `Matrix_Unique_ID` = '211806386' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T14:49:32.190' ,`MLSNumber` = '43825915' ,`ListAgentFullName` = 'Karen Vicknair' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.900761' ,`Longitude` = '-95.708196' ,`PhotoCount` = '19' ,`PostalCode` = '77433' ,`RoomCount` = '13' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Brinklow Point' ,`StreetNumber` = '8502' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW! Don\'t miss this opportunity to live in the manned gated community of Canyon Lakes West.\r\nThis 4 bedroom, 3.5 bath features a private study downstairs, family room down, step up game room upstairs, media room off set from bedrooms upstairs. Jack and Jill bath with 2 of the upstairs bedrooms, third bedroom is off the game room and has a full bath that can be used by the game room. Large Primary bedroom is on the first floor with over sized walk in primary closet, separate jetted tub and shower, 2 separate sinks and a linen closet within the primary bath. Dramatic entry way from front door. Kitchen is open to the family room and breakfast area. Family room has fireplace with ample room for over sized furniture.\r\nZoned to highly acclaimed Cy-Fair ISD.' ,`Acres` = '0.1405' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 CANYON LAKES WEST SEC 10' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Crk/Canyon Lakes West Sec 1' ,`TaxAmount` = '9775' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090645' WHERE `Matrix_Unique_ID` = '212170175' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T13:18:37.120' ,`MLSNumber` = '73617141' ,`ListAgentFullName` = 'Robert Ginn' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781217' ,`Longitude` = '-95.591635' ,`PhotoCount` = '16' ,`PostalCode` = '77079' ,`RoomCount` = '6' ,`ListPrice` = '535000.00' ,`Status` = 'Active' ,`StreetName` = 'Saint Marys' ,`StreetNumber` = '14023' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1692' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This thoughtfully updated, classically styled ranch style home in Nottingham West is a three bedroom, two bathroom home zoned to some of Houston\'s finest public schools. The home displays an open concept living style with quartz countertops, soft closing cabinets/drawers and raised counters. The large backyard is perfect for gatherings of family and friends. It should also be noted that the home did not flood during the Harvey event - per seller.' ,`Acres` = '0.1691' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 9 NOTTINGHAM WEST SEC 3 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7368' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '680' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WILCHESTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Nottingham West' ,`TaxAmount` = '9340' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090645' WHERE `Matrix_Unique_ID` = '212356687' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T14:20:32.093' ,`MLSNumber` = '96744974' ,`ListAgentFullName` = 'James Phillips' ,`ListOfficeName` = 'Phillips & Sons Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.648542' ,`Longitude` = '-95.586809' ,`PhotoCount` = '19' ,`PostalCode` = '77477' ,`RoomCount` = '8' ,`ListPrice` = '393000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Crest' ,`StreetNumber` = '11930' ,`StreetSuffix` = 'Drive' ,`City` = 'Meadows Place' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RECENTLY REMODELED, NEW ROOF, GRANITE COUNTER TOPS, NEW CARPET' ,`Acres` = '0.1225' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MEADOWGLEN SEC 1, BLOCK 4, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5338' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MEADOWS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Meadowglen Sec 1' ,`TaxAmount` = '5719' ,`TaxRate` = '2.4949' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090645' WHERE `Matrix_Unique_ID` = '212703697' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T13:46:51.077' ,`MLSNumber` = '92007607' ,`ListAgentFullName` = 'Guadalupe Flores' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.845103' ,`Longitude` = '-95.400695' ,`PhotoCount` = '16' ,`PostalCode` = '77022' ,`RoomCount` = '5' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Tidwell' ,`StreetNumber` = '153' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '884' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Business Opportunity for Residential x Office Mixed Use Space, with bedroom loft upstairs. This property is located on a busy street with lots of traffic and multiple shopping plazas around. This is a great opportunity to work from home and start your own business or expand into another territory for your current professional business.' ,`Acres` = '0.1607' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 2A HIGHLAWN NORTH SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highlawn North' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090646' WHERE `Matrix_Unique_ID` = '213556622' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T14:45:59.507' ,`MLSNumber` = '9857409' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Christian Fuentes' ,`SellingOfficeName` = 'Connect Realty' ,`Latitude` = '30.250082' ,`Longitude` = '-95.203543' ,`PhotoCount` = '12' ,`PostalCode` = '77372' ,`RoomCount` = '3' ,`ListPrice` = '232990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Upper Gardenia' ,`StreetNumber` = '14104' ,`StreetSuffix` = 'Drive' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WONDERFUL NEW D. R. HORTON BUILT BEAUTY! Pretty Elevation with Front Porch! Premium Corner Lot Location! Impressive Foyer Opens to Gourmet Island Kitchen with Corner Walk-In Pantry & Espresso Colored Cabinetry, Spacious Dining Area, & Large Living Room! Privately Located First Floor Primary Suite Offers Great Bath with Dual Sinks & Oversized Shower - PLUS Walk-In Closet! Versatile Gameroom/Media Room! Convenient Indoor Utility Room with Direct Garage Access! Covered Patio & Landscape Package Enhance Backyard Setting! Great New Community with Easy Access to Highway 59 - PLUS Just Minutes to Elementary & High Schools!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23 Block 1 Presswoods Section 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5866' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`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` = '47 - Splendora' ,`SchoolElementary` = 'PINEY WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Presswoods' ,`TaxAmount` = '' ,`TaxRate` = '3.4283' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090646' WHERE `Matrix_Unique_ID` = '214771920' --> 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','215133062','1675090646','215133062','2022-12-13T14:29:51.977','72282629','Jenna Clements','CC Texas Realty, LLC','','','29.358633','-95.035448','12','77563','3','187000.00','Active','Meadow','407','Lane','Hitchcock','1','1','3','1802','Single-Family','***Brick 3 Bedroom 1.5 Bath on oversized corner lot*** Spacious home on quiet street in Hitchcock. Beautifully renovated and move-in ready.','0.2762','33','','','','','Sellers Disclosure','','','','Hitchcock','Central Electric','0','ABST 71 P GAYATT SUR LOT 75 GREENWOOD','Corner','12030','Appraisal District','','','0','','2','','0','','','','','Composition','26 - Hitchcock','HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL','HITCHCOCK HIGH SCHOOL','CROSBY MIDDLE SCHOOL (HITCHCOCK)','Lockbox Front','Appraisal District','1','Ranch','Greenwood 1','3963','2.3428','Public Sewer,Public Water','1955','Seller'); --> 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','215134105','1675090646','215134105','2022-12-13T14:31:06.527','9293819','Jenna Clements','CC Texas Realty, LLC','','','29.649651','-95.338818','10','77033','3','185000.00','Active','Ricky','5615','Street','Houston','1','0','3','1087','Single-Family','Beautifully renovated charming 3 bedroom 1 bath. Home has new wood cabinets, granite counters, new tile, flooring, and paint throughout.','0.157','3','','','','','Sellers Disclosure','','','','Medical Center South','Central Electric','0','LT 24 BLK 3 CRESTMONT SEC 1','Subdivision Lot','6840','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','MADING ELEMENTARY SCHOOL','STERLING HIGH SCHOOL (HOUSTON)','THOMAS MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Ranch','Cresmont Sec 01','2349','2.3307','Public Sewer,Public Water','1956','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','215136350','1675090646','215136350','2022-12-13T14:28:59.467','37997058','Jenna Clements','CC Texas Realty, LLC','','','29.840344','-95.255469','12','77078','3','187900.00','Active','Laura Koppe','9122','Road','Houston','1','0','3','1064','Single-Family','Charming beautifully renovated 3 bed 1 bath home. This home is ready for its new owners. New counters, tile, flooring, and paint throughout.','0.1653','2','','','','','Sellers Disclosure','','','','Northeast Houston','Central Electric','0','LT 325 BLK 11 CHATWOOD PLACE SEC 3','Subdivision Lot','7200','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','ELMORE ELEMENTARY SCHOOL','KASHMERE HIGH SCHOOL','KEY MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Chatwood Place Sec 03','2085','2.3307','Public Sewer,Public Water','1950','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','215137358','1675090646','215137358','2022-12-13T14:30:26.403','76165080','Jenna Clements','CC Texas Realty, LLC','','','29.349650','-95.035153','13','77563','3','179000.00','Active','Sycamore','302','Drive','Hitchcock','1','0','3','1266','Single-Family','Charming Beautifully Renovated 3 Bedroom 1 bath home on nice shaded lot in Hitchcock. Home has solid wood cabinets, new tile, new flooring, granite counters, and fresh paint throughout.','0.1564','33','','','','','Sellers Disclosure','','','','Hitchcock','Central Gas','0','ABST 13 W H JACK SUR LOT 24 BLK 3 GARDEN TERRACE','Subdivision Lot','6814','Appraisal District','','','0','','0','','0','','','','','Composition','26 - Hitchcock','HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL','HITCHCOCK HIGH SCHOOL','CROSBY MIDDLE SCHOOL (HITCHCOCK)','Lockbox Front','Appraisal District','1','Ranch','Garden Terrace','2257','2.2942','Public Sewer,Public Water','0','Seller'); --> 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','215276086','1675090646','215276086','2022-12-13T13:17:03.210','52548917','Charles Kennedy','Coldwell Banker Pat Dickey,','','','31.401000','-95.589000','26','75835','4','250000.00','Active','Pine','291','Road','Crockett','2','0','2','952','Single-Family','Shaded but open lot in a quiet subdivision. Actually two houses; one conventional with one large room, full bath, and nice front porch, walkway to A-frame a few feet away. A-frame has large room, small kitchen, and full bath down, primary bed with good closet/storage space up. Primary bed has small balcony deck in back. Small deck down in back, large deck in front. Both buildings newly refreshed. Large metal building for garage / toy storage. Private spaces for two families or parents/kids, with common meeting - eating - socializing areas. Quick access to Houston County Lake. Room dimensions are approximate.','0.475','41','','','','','Sellers Disclosure','','','','Crockett Area','Central Electric','1','GOLDEN ACRES LOT 20 & PT LOT 19 BLK 15','Wooded','20691','Appraisal District','','100','0','','2','','0','','','Electric Range','','Built Up','61 - Latexo','LATEXO ELEMENTARY SCHOOL','LATEXO HIGH SCHOOL','LATEXO HIGH SCHOOL','Accompany,Leave Business Card','Appraisal District','2','Other Style','Golden Acres','1069','1.8562','Aerobic','1994','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','215447618','1675090646','215447618','2022-12-13T14:02:30.887','26292328','Stacy Jones','Texas 1st Choice Realty','','','29.372807','-95.084287','17','77510','7','219000.00','Active','14th','12106','Street','Santa Fe','2','0','4','1558','Single-Family','Back on the market!! 4 Bedroom home in Beautiful Downtown Santa Fe. Gorgeous Large Mature Trees! Kitchen has been updated with Lovely Butcher Block and Granite counter tops and bright cabinets. Plenty of cabinet space. Primary bedroom steps down to Bamboo flooring with glass French doors. Split floor plan with open concept.','0.2388','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Santa Fe','Central Gas','0','ABST 149 E MITCHELL SUR LOTS 27 & 28 BLK 5 ALTA LOMA TOWNSIT','Cleared','10400','Appraisal District','','','0','','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Cooktop','','Aluminum','45 - Santa Fe','WILLIAM F BARNETT ELEMENTARY SCHOOL','SANTA FE HIGH SCHOOL','SANTA FE JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Alta Loma Townsite','4571','2.6465','Public Sewer,Public Water','1965','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','215453744','1675090646','215453744','2022-12-13T14:02:10.657','37629650','Cyndi Kornegay','Gatehouse Properties','','','29.443183','-95.381560','47','77583','10','598792.00','Active','Lavaca','5805','Lane','Manvel','3','0','4','2838','Single-Family','Located in the beautiful community of Meridiana, you will fall in love with every detail of this home. Enter through the foyer and immediately be wowed. Flanking the foyer, you will discover a spacious study offering the perfect space to work from home. The family room features oversized windows giving you ample natural sunlight and opens up to a gourmet kitchen, complete with an oversized island. The spacious primary suite includes an elegant bow window, a luxurious bath enhanced by an oversized garden tub, large shower paired with a seat for relaxation and a spacious walk-in closet. Downstairs, you will discover a secondary bedroom with an en-suite bath that is ideal for guests. This is the perfect home for entertaining, featuring a loft-style game room and a covered patio. As you enter through the 3-car garage, you will appreciate the convenience of the mud room, powder room, and utility room. This home has it all! Come see this home for yourself, available for immediate move in!','','5','Coventry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','','Alvin North','Central Gas','1','Lot 11 Block 2','Subdivision Lot','10399','Survey','','1050','1','Never Lived In','3','Gas Oven,Single Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','2','Contemporary/Modern,Traditional','Meridiana','','3.63','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','215547949','1675090646','215547949','2022-12-13T14:21:40.433','9692025','Aaron Jistel','Listing Spark','','','30.370803','-95.534355','7','77304','9','639900.00','Active','Trellis','40','Court','Conroe','3','0','5','2750','Single-Family','Will be ready by Jan’23. A gorgeous, Acadian style brand-new 2-story custom house on the corner lot of a quiet cul-de-sac in the peaceful Camellia subdivision of Conroe. This spacious house has several captivating features: • 5 beds, 3 baths, and a game room with a tranquil wooded area behind the house and only one neighbor • 2750+ total sq ft. allows plenty of room for family and a lot of storage space • First floor (10’ & 11’ ceilings): o 21-foot ceiling, open foyer, living room o Sit around the gas fireplace with a fine view of the serene landscape to enjoy a relaxing evening with family/guests o Primary bedroom features a large walk-in closet and a luxurious bathroom with a tub and walk-in shower o High-quality appliances in the kitchen with shaker-style cabinets and a formal dining area to enjoy a meal or entertain guests • Second floor (9’ ceiling): o 2 more bedrooms along with a cozy space that may be used as a 2nd office/library • 12-feet high garage, tankless water heater','0.2306','39','Astra Developers LLC','','','','No Disclosures','1','','1','Lake Conroe Area','Central Electric','1','S322400 - CAMELLIA SUBDIVISION 01, BLOCK 5, LOT 8','Corner,Cul-De-Sac','10044','Appraisal District','','125','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Cooktop','','Composition','56 - Willis','LAGWAY ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','ROBERT P. BRABHAM MIDDLE SCHOOL','Supra Keybox','Seller','2','Traditional','Camellia Sub 01','5742','2.1823','Public Sewer,Public Water','2022','Seller'); --> 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','215571023','1675090646','215571023','2022-12-13T14:59:27.423','22625233','Jennifer Fredericks','Inhabit Real Estate Group','','','30.665991','-96.471658','6','77808','3','338235.00','Active','Tarleton','3173','','Bryan','2','0','3','1800','Single-Family','Avonley Homes \"Violet\" plan comes to Rudder Pointe! Grand entryway leads to homes open living and dining areas, with a gorgeous U-shaped kitchen overlooking it all! Kitchen features a large eat-in island, spacious pantry, and bright window to allow plenty of natural light! Split bedroom floorplan clusters additional bedrooms around the main hallway, all with access to a full bathroom. Primary bedroom is spacious with two bright windows. Primary En-Suite features double vanities, separate tub and shower, closeted toilet, and generous walk-in closet with access to homes laundry room. Laundry room opens up to Avonley Homes signature mudroom, which wraps around to homes main hallway. Covered back porch provides the perfect entertaining space for all outdoor activities!','0.15','61','Avonley Homes','','','','No Disclosures','','Gas Connections,Wood Burning Fireplace','1','','Central Electric','1','RUDDER POINTE PH 4, LOT 40, BLOCK 8','Other','6600','Other','','300','1','To Be Built/Under Construction','2','','0','','','','','Wood Shingle','148 - Bryan','KEMP ELEMENTARY SCHOOL','BRYAN HIGH SCHOOL','STEPHEN F. AUSTIN MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Rudder Point','','','Public Sewer','2022','Builder'); --> New record created successfully