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` = '2023-01-12T22:11:46.163' ,`MLSNumber` = '81889151' ,`ListAgentFullName` = 'Chester Tucker' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.981291' ,`Longitude` = '-95.206715' ,`PhotoCount` = '28' ,`PostalCode` = '77346' ,`RoomCount` = '7' ,`ListPrice` = '294900.00' ,`Status` = 'Active' ,`StreetName` = 'Stillwater Place' ,`StreetNumber` = '18106' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Instantly appealing with its treed lot and arched windows, this charming one story home is sure to please. You will never miss out on the action from the spacious kitchen overlooking the living rooms. The chef in the house will adore the abundant cabinet and counter space complete with center island. Spend time outdoors in this spacious and welcoming backyard with more than six beautiful mature trees. Book a tour with your real estate agent today and feel right at home!' ,`Acres` = '0.213' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 4 PARK AT ATASCOCITA FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9278' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '390' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WHISPERING PINES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park At Atascocita Forest 03' ,`TaxAmount` = '6146' ,`TaxRate` = '2.773' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675131960' WHERE `Matrix_Unique_ID` = '207117382' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-12T22:10:28.120' ,`MLSNumber` = '7402235' ,`ListAgentFullName` = 'Alex Westbrook-McCollum' ,`ListOfficeName` = 'Swede\'s Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.456751' ,`Longitude` = '-94.624378' ,`PhotoCount` = '34' ,`PostalCode` = '77650' ,`RoomCount` = '6' ,`ListPrice` = '699000.00' ,`Status` = 'Active' ,`StreetName` = 'Mills' ,`StreetNumber` = '2100' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming, one owner, two story beach cabin on quiet, dead end street in the heart of the peninsula - close to restaurants, the beach, short drive to the ferry, and more! Large deck is perfect spot to watch for fireworks or look for \"pirate ships\" from the upstairs dormers. Eat in kitchen features granite countertops, ample storage with two pantries, gas cooktop, pot filler, drink fridge. Primary bedroom has jacuzzi tub and separate shower. Upstairs bedrooms have bunk beds - room for plenty of guests. Home features elevator for convenience. Short walk, golf cart, or car ride to the beach for shell shopping or hunting for shark teeth.' ,`Acres` = '0.1148' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOT 77 ALBERDIE ADDN NO 1' ,`LotDesciption` = 'Water View' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Alberdie Add 1' ,`TaxAmount` = '5402' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675131960' WHERE `Matrix_Unique_ID` = '208795544' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-12T22:31:01.827' ,`MLSNumber` = '58263623' ,`ListAgentFullName` = 'Alexandra Berry' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.049399' ,`Longitude` = '-95.595959' ,`PhotoCount` = '28' ,`PostalCode` = '77375' ,`RoomCount` = '8' ,`ListPrice` = '264900.00' ,`Status` = 'Active' ,`StreetName` = 'Shores Edge' ,`StreetNumber` = '19810' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two story home with fantastic open layout. You will never miss out on the action from the spacious kitchen overlooking the dining and living rooms! Neutral colors, tile, and wood look floors will allow you to make this home your own. Spend time outdoors in the welcoming backyard. Book a tour with your real estate agent today and feel right at home!' ,`Acres` = '0.1035' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 9 THREE LAKES EAST SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4508' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '335' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KOHRVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Three Lakes East Sec 4' ,`TaxAmount` = '6112' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675131960' WHERE `Matrix_Unique_ID` = '208845741' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-12T21:12:46.093' ,`MLSNumber` = '45325477' ,`ListAgentFullName` = 'Lacy Troutman' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.929106' ,`Longitude` = '-94.613685' ,`PhotoCount` = '41' ,`PostalCode` = '75936' ,`RoomCount` = '10' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Park' ,`StreetNumber` = '291' ,`StreetSuffix` = 'Loop' ,`City` = 'Chester' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2076' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful 2-story farmhouse on half an acre in the heart of Chester, TX. This corner property is completely fenced, with one electric gate entrance, one front gate entrance and an additional side gate. With a total of 2,076 Sq ft. this home offers four large bedrooms, the primary located on the 1st floor, an additional 16x13 game room/ office located on the 2nd floor, two full baths and an additional half bath, updated flooring on the 1st floor, updated kitchen including granite counter tops. Outside you will find a 20x24 patio area, great for relaxing or hosting the perfect backyard BBQ! Also including a storage building wired with electricity, and recently installed solar screens on all windows. Call me to tour this beautiful home !!' ,`Acres` = '0.5196' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S5350 SUNRISE ACRES (A3), LOT 14, ACRES .5196' ,`LotDesciption` = 'Corner' ,`LotSize` = '22632' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '181 - Chester' ,`SchoolElementary` = 'CHESTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CHESTER HIGH SCHOOL' ,`SchoolMiddle` = 'CHESTER HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Sunrise Acres' ,`TaxAmount` = '3349' ,`TaxRate` = '2.0365' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675131960' WHERE `Matrix_Unique_ID` = '211008385' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-12T21:07:56.830' ,`MLSNumber` = '83019214' ,`ListAgentFullName` = 'Thomas Saunders' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.081148' ,`Longitude` = '-95.220853' ,`PhotoCount` = '31' ,`PostalCode` = '77365' ,`RoomCount` = '3' ,`ListPrice` = '231900.00' ,`Status` = 'Active' ,`StreetName` = 'Yupon' ,`StreetNumber` = '22928' ,`StreetSuffix` = 'Street' ,`City` = 'Porter' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country Charmer 3 bedroom 2 bathroom home with cedar siding, tucked away in the highly desirable Timberlane Acres. Peace and tranquility abound with this home situated on almost a full an acre and is the perfect setting for entertaining and making memories. You will be wowed by the expansive open space and trees. Kitchen is spacious with a long break bar that works great for a buffet setup for family gatherings. The covered patios have plenty of room for relaxing. Garage is twice a deep as the typical garage (wide for 2 cars and 2 cars deep) allowing for additional space for parking and work shop and tools. The primary bedroom is large enough for a sitting area and full sized furniture. Here is your chance to have a piece of your own country get away.' ,`Acres` = '0.8' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TIMBERLANE ACRES 08, LOT 61' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '34848' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'PORTER ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timberlane Acres 08' ,`TaxAmount` = '2363' ,`TaxRate` = '2.5431' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675131960' WHERE `Matrix_Unique_ID` = '211505348' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-12T22:52:04.920' ,`MLSNumber` = '72895574' ,`ListAgentFullName` = 'Marcia Gibbs' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.151207' ,`Longitude` = '-95.471917' ,`PhotoCount` = '17' ,`PostalCode` = '77380' ,`RoomCount` = '5' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Kino' ,`StreetNumber` = '3' ,`StreetSuffix` = 'Court' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1623' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location! Location! Location! Walking distance to HEB Woodlands Market, Town Centre, Cinthia\r\nWoods Pavilion Woodlands Mall, and Waterway! Quiet 3-2-2 with fenced back yard in golf course\r\nneighborhood in Village of Grogan’s Mill. Brand new wood-look tile floors downstairs with open living\r\nroom and fireplace. 3-year-old roof and air conditioning and recent kitchen remodeling with large\r\nbreakfast bar. Convenient to The Woodlands Mall, Exxon, HP and both I-45 and Hardy freeways. New\r\npaint with neutral colors and ceiling fans and window blinds in all rooms. Fantastic neighborhood and\r\npriced right so it won’t last long. Thanks for looking!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Wdlands Village Grogans ML13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6488' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Wood Shingle' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'LAMAR ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlands Village Grogans' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675131961' WHERE `Matrix_Unique_ID` = '213098571' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-12T22:55:27.527' ,`MLSNumber` = '26767042' ,`ListAgentFullName` = 'Alicia Reader' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.144097' ,`Longitude` = '-95.421562' ,`PhotoCount` = '6' ,`PostalCode` = '77386' ,`RoomCount` = '7' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Coppercrest' ,`StreetNumber` = '1334' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two story home with fantastic open layout. You will never miss out on the action from the spacious kitchen overlooking the breakfast adjacent the family rooms. The primary suite along with two additional bedrooms are located upstairs while one additional bedroom or study is located downstairs with an attached half bath. Neutral colors and wood look floors allow you to make this home your own. Spend time outdoors in this spacious and welcoming backyard. Book a tour with your real estate agent today and feel right at home!' ,`Acres` = '0.1333' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'IMPERIAL OAKS 09, BLOCK 1, LOT 19 REPLAT PHASE 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5807' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks 09' ,`TaxAmount` = '7915' ,`TaxRate` = '2.4827' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675131961' WHERE `Matrix_Unique_ID` = '214556361' --> 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','215133732','1675131961','215133732','2023-01-12T22:43:19.310','10997541','Darian Candler','Entera Realty LLC','','','30.132198','-95.371187','27','77386','7','240000.00','Active','Pecos River','29011','Court','Spring','2','1','3','1608','Single-Family','This single family home has three bedrooms, two and a half bathrooms, and a two car garage.','0.1361','15','','','','','Mud,Other Disclosures,Sellers Disclosure,Special Addendum','','','','Spring Northeast','Central Electric','1','S352703 - CREEKSIDE VILLAGE 03, BLOCK 4, LOT 66','Subdivision Lot','5929','Appraisal District','','500','0','','2','','0','','','','','Composition','11 - Conroe','BRADLEY ELEMENTARY SCHOOL (CONROE)','GRAND OAKS HIGH SCHOOL','YORK JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Creekside Village 03','4325','1.8487','Public Sewer,Public Water','2007','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','215395297','1675131961','215395297','2023-01-12T21:17:09.977','44133358','Darrell Cooper','Metro Plus Realty PLLC','','','29.289662','-94.794092','24','77550','1','269900.00','Active','Avenue P 1/2','2713','','Galveston','1','1','1','583','Single-Family','Welcome home to this beautiful 1-bedroom 1.5 bath home located 3 blocks from the seawall and Galveston Pleasure Pier. This home has been updated and well maintained. The roof and ac are recent. Washer and Dryer inside home. The home is a successful Airbnb rental bringing in tens of thousands of dollars in revenue.','','33','','','','','Sellers Disclosure','','','','East End','Central Electric','0','ABST 628 M B MENARD SUR E PT OF LOT 4 (3004-2) SE BLK 90 GAL','Cleared','','','','','0','','0','','0','','','','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Lockbox Front','Seller','1','Traditional','Galveston Outlots','','','Public Sewer,Public Water','1958','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','215421467','1675131961','215421467','2023-01-12T21:12:03.100','64182979','Kimberly Rensimer','Martha Turner Sotheby\'s International Realty','','','29.725954','-96.088866','23','77474','5','695000.00','Active','Mixville','4779','Road','Sealy','2','1','4','2729','Single-Family','','5.89','57','','','Electric Dryer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','','Central Gas','0','A125 J P BORDEN','Cleared,Other','25657','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','109 - Sealy','SELMAN ELEMENTARY SCHOOL','SEALY HIGH SCHOOL','SEALY JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Ranch,Traditional','N/A','3695','1.81','Septic Tank,Well','1973','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','215507729','1675131961','215507729','2023-01-12T21:20:15.313','78378416','Jyothi Reddy','Excel Realty Co','','','29.840635','-95.717484','15','77449','9','325000.00','Active','Parkstone Bend','20014','Lane','Katy','2','1','4','2642','Single-Family','Very desirable Neighborhood. This property will move fast. This property has been Well maintained The spacious floorplan. Lots of natural light. Backyard is good size to entertain guests. Well maintained community and close to all Amenities. All bedrooms plus game room up, study down formal dining. Spacious Kitchen with room for island, huge pantry and inside utility. **********Energy Star Home**********\r\nUpdated Kitchen Cabinets and Bathrooms. New Floors, Paint all through the house,\r\nProperty Sold as is.','0.1244','25','','','Washer Connections','','Sellers Disclosure','1','','1','Bear Creek South','Central Gas','1','LT 18 BLK 1 WINDSTONE COLONY SEC 7','Subdivision Lot','5418','Appraisal District','','500','0','','2','','0','','','Gas Range','','Wood Shingle','13 - Cypress-Fairbanks','SHERIDAN ELEMENTARY SCHOOL','CYPRESS LAKES HIGH SCHOOL','THORNTON MIDDLE SCHOOL (CY-FAIR)','Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Traditional','Windstone Colony Sec 07','8146','2.781','Water District','2005','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','216038305','1675131961','216038305','2023-01-12T21:04:21.603','61834342','Jessica St. John','Compass RE Texas, LLC','','','29.769684','-95.405521','25','77007','5','479000.00','Active','Patterson','912','Street','Houston','3','1','3','2412','Single-Family','Excellent location close to restaurants, coffee, shopping and trails! Well maintained townhome with hardwood flooring throughout. Gourmet kitchen with stainless steel appliances, granite counters, gas cooktop and breakfast bar. Immaculate details with shutter window coverings, wrought iron stairs, and insulated windows. Enjoy a third floor primary suite with whirlpool tub and separate shower and spacious closet. 2nd floor living area with abundant light, as well as powder room and desk area. Manicured outdoor space with tree lined streets and fenced yard for pets.','0.0424','16','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Rice Military/Washington Corridor','Central Electric','0','LT 6 BLK 1 VILLAS AT PATTERSON STREET','Other','1847','Appraisal District','','235','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','27 - Houston','MEMORIAL ELEMENTARY SCHOOL (HOUSTON)','HEIGHTS HIGH SCHOOL','HOGG MIDDLE SCHOOL (HOUSTON)','Appointment Required','Appraisal District','3','Contemporary/Modern','Villas/Patterson Street','','','Public Sewer','2008','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','216307205','1675131961','216307205','2023-01-12T22:33:04.703','76625504','Kaleigh Baker','Mega Realty','','','29.133734','-95.786462','40','77480','7','479000.00','Active','County Road 728b','385','','Sweeny','2','0','6','2464','Single-Family','Welcome to your paradise in the country. This stunning 2,464 sq. ft. barndominium has so many amazing features starting with the OPEN CONCEPT living area. This Barndo offers SIX BEDROOMS! Primary Bedroom boasts 13x34 space. The home has 14-foot Cathedral ceilings with waterproof vinyl wood floors through-out, FIFTY-EIGHT KITCHEN CABINETS, TEN CABINETS on 4’3”x8’3” ISLAND, Granite counters, Samsung Stainless Smudge Free Appliances, double jacuzzi 4x6 tub in Primary Bathroom, and a tankless water heater. Pond is stocked with bass, crappie, and catfish, a deer feeder that feeds daily, 1,100 sq. ft. porch, 20x44 lean too, 10x12 shed, 30x40 SHOP. The list goes on!!! Also included with the home is a 32 ft. 2006 camper with a slide out that is hooked to power, water and sewer. Your guests will surely be in awe with this one-of-a-kind property. Enjoy the calming LED lights that are powered by remote control on your covered patio, windows are Pella brand, triple pane with built in blinds.','3.753','5','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','0','','','West of the Brazos','Central Electric','0','A0136 JOSEPH WHITE TRACT 1D (PT) (CALLED LOT 57) (FOREST ACR','Cleared,Wooded','163481','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Aluminum','10 - Columbia-Brazoria','','COLUMBIA HIGH SCHOOL','WEST BRAZOS JUNIOR HIGH','Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox','Seller','1','Barndominium,Ranch','Joseph White','3911','1.5833','Public Sewer,Well','2021','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','216317030','1675131961','216317030','2023-01-12T22:06:02.193','60513062','Marwah Al mimar','MIH REALTY, LLC','','','29.692491','-95.818594','23','77406','12','534999.00','Active','Creston Meadow','25510','Drive','Richmond','4','0','5','4072','Single-Family','Beautiful two story home located in gated community . Home is loaded with upgrades, featuring 5-6 Bedrooms and 4 full bath, primary bedroom on the first floor, high ceiling living area, formal living and formal dinning, a big game room on the second floor, island kitchen with granite counter tops, a big back yard with a covered patio, this house is a MUST see, Call today for more details!!!','0.2116','37','','','','','Sellers Disclosure','','','2','Fort Bend County North/Richmond','Central Gas','1','CANYON GATE AT WESTHEIMER LAKES SEC 1, BLOCK 5, LOT 17','Cul-De-Sac','9216','Appraisal District','','1355','0','','3','','0','','','','','Composition','33 - Lamar Consolidated','BENTLEY ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment','Appraisal District','2','Traditional','Canyon Gate At Westheimer Lakes Sec 1','12568','2.5248','Public Sewer,Public Water','2006','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','216351024','1675131962','216351024','2023-01-12T22:18:36.557','4634567','Cedric Barlow','Legacy Homes & Properties, LLC','','','29.878690','-95.292588','26','77016','3','190000.00','Active','Hanley','6507','Lane','Houston','1','1','3','1767','Single-Family','Calling all first time home buyers, investors and more. This 3 bedroom 1-1/2 bath has nothing but opportunity to offer with an open concept and spacious living room. There is some TLC that needs to be done but it has strong bones. Don\'t miss your opportunity and submit your best offer.','0.1422','2','','','','','Other Disclosures','','','','Northside','Central Electric','0','LT 28 BLK 3O NORTHWOOD MANOR SEC 2','Other','6195','Appraisal District','','','0','','1','','0','','','','','Composition,Wood Shingle','27 - Houston','MARSHALL ELEMENTARY SCHOOL','NORTH FOREST HIGH SCHOOL','FOREST BROOK MIDDLE SCHOOL','Lockbox Left Side','Appraisal District','1','Traditional','Northwood Manor','2318','2.3307','Water District','1966','Appraisal District'); --> New record created successfully