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-20T12:33:03.667' ,`MLSNumber` = '39746091' ,`ListAgentFullName` = 'Chay LeUnes' ,`ListOfficeName` = 'NextHome Realty Center' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.992473' ,`Longitude` = '-96.273452' ,`PhotoCount` = '50' ,`PostalCode` = '77418' ,`RoomCount` = '10' ,`ListPrice` = '995000.00' ,`Status` = 'Active' ,`StreetName` = 'Reinhardt' ,`StreetNumber` = '3882' ,`StreetSuffix` = 'Road' ,`City` = 'Bellville' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3874' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DREAM HOME! This must see 10+ acre gem is just a few minutes outside of Bellville. No detail was spared in the construction of this custom built beauty. A stucco and brick exterior gives way to an interior of gorgeous hardwood floors, soaring ceilings with exposed beam work, and a terrific view of the pond from most of the rooms in the house. Custom windows and doors. Office entry with transom accent glass. Granite countertops throughout. Travertine tile. Viking Appliances. See the master shower with glass blocks, double shower head and seating. Each bedroom has a walk in closet. Massive mudroom and laundry with tons of storage. Follow the wood stairs up to the game room with a view of the pond featuring a Viking fridge and full bath. Media room adjacent to the game room with a walk-in attic space for additional storage. Enjoy the back patio for wildlife viewing and recently rebuilt pier for fishing. 3 car oversized garage. Water softener.' ,`Acres` = '10.576' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST A254 A LOTT' ,`LotDesciption` = 'Water View,Waterfront,Wooded' ,`LotSize` = '460691' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '136 - Bellville' ,`SchoolElementary` = 'WEST END ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'BELLVILLE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Arthur Lott Surv Abs 254' ,`TaxAmount` = '10615' ,`TaxRate` = '1.8096' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093525' WHERE `Matrix_Unique_ID` = '203913130' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T12:19:59.150' ,`MLSNumber` = '86318864' ,`ListAgentFullName` = 'Toke Ettehadieh' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.283663' ,`Longitude` = '-94.809750' ,`PhotoCount` = '29' ,`PostalCode` = '77550' ,`RoomCount` = '10' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue Q 1/2' ,`StreetNumber` = '4119' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1757' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Own a piece of the island with this charming 3 bedroom, 2 bathroom on a 7,200 sq. ft. lot! Property has a ton of potential. New Vinyl Flooring, Counters and Solid Wood Kitchen Cabinetry (2022). Roof, HVAC & Storm Windows replaced less than 6 years old. Two primary suites. Walking distance to all the food, drink and entertainment the seawall has to offer. Great for a first time buyer or investor. Check out the virtual tour and schedule a viewing today!' ,`Acres` = '0.1652' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOTS 4 & 5 PABST SUB' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '3993' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093525' WHERE `Matrix_Unique_ID` = '209676992' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T11:27:05.077' ,`MLSNumber` = '36473325' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.140212' ,`Longitude` = '-94.411024' ,`PhotoCount` = '14' ,`PostalCode` = '77659' ,`RoomCount` = '7' ,`ListPrice` = '279990.00' ,`Status` = 'Active' ,`StreetName` = 'Haidlyns' ,`StreetNumber` = '1500' ,`StreetSuffix` = 'Way' ,`City` = 'Sour Lake' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '1750' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction in Holly Trails!! The Huntsville plan by D.R. Horton is a one-story featuring 4 bedrooms, 2 baths, and 2 car garage. The foyer opens to the guest bedrooms, bath and hall linen closet. Center kitchen includes breakfast bar with beautiful counter tops, stainless steel appliances and corner pantry and opens to family room. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and spacious walk-in closet. The standard rear covered patio is located off the dining area.' ,`Acres` = '0.2798' ,`Area` = '49' ,`BuilderName` = 'D.R.Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 17 BLK 2 HOLLY TRAILS PHASE 1 AS PER PLAT 4-209 P# HT-1-' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12188' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '135' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'SOUR LAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Holly Trails Ph 1' ,`TaxAmount` = '759' ,`TaxRate` = '1.8384' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093525' WHERE `Matrix_Unique_ID` = '209805594' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T11:42:34.607' ,`MLSNumber` = '39735496' ,`ListAgentFullName` = 'Karen Beckman' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.277133' ,`Longitude` = '-95.596496' ,`PhotoCount` = '41' ,`PostalCode` = '77316' ,`RoomCount` = '13' ,`ListPrice` = '1149000.00' ,`Status` = 'Active' ,`StreetName` = 'Zoe Loop' ,`StreetNumber` = '11413' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5660' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to this Grand 5 Bedroom 4.5 Bath with detached 865 sq. ft. Guest House/Pool House on 1.5 acres located in the Prestigious Gated, Golf Course Community of \"Grand Lake Estates\"!! This Elegant home features a private 1st floor Primary Bedroom Suite w/jetted soaker tub, separate shower, new carpet and 2 large walk-in closets with custom built-ins. Gourmet Kitchen boosts Stainless Steel Appliances, Granite Countertops, and walk in pantry. You will enjoy entertaining your guests in your backyard retreat which includes an infinity pool and spa, grotto and water slide, outdoor 1/2 bath, outdoor kitchen with gas stove as well as a natural wood burning oven. This home also backs up to a small pond for the fisherman in the Family. Three brand new A/C Units Installed on 8/25/22. Seller owns the 1.5 acre lot next door and may consider selling together. Zoned to new Montgomery ISD Schools, Low Taxes. Easy Access to Lake Conroe and The Woodlands. Seller is Motivated!!' ,`Acres` = '1.5' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND LAKE ESTATES 04, BLOCK 2, LOT 1' ,`LotDesciption` = 'In Golf Course Community,Waterfront' ,`LotSize` = '65340' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '845' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Grand Lake Estates' ,`TaxAmount` = '14625' ,`TaxRate` = '1.9139' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093526' WHERE `Matrix_Unique_ID` = '210908621' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T12:03:30.807' ,`MLSNumber` = '90763609' ,`ListAgentFullName` = 'Xiaoming Shao' ,`ListOfficeName` = '31 Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.827545' ,`Longitude` = '-95.806359' ,`PhotoCount` = '50' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '319000.00' ,`Status` = 'Active' ,`StreetName` = 'Don Giovanni' ,`StreetNumber` = '3723' ,`StreetSuffix` = 'Place' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lakeview. 4 Bedrooms 2 and half bathroom. Primary bedroom is downstairs. 3 bedrooms and a game room upstairs. Great community. Move in ready.' ,`Acres` = '0.1199' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 2 CAMILLO LAKES SEC 2' ,`LotDesciption` = 'Water View' ,`LotSize` = '5223' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Camillo Lakes Sec 2' ,`TaxAmount` = '8539' ,`TaxRate` = '3.5333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093526' WHERE `Matrix_Unique_ID` = '213276207' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T11:39:19.923' ,`MLSNumber` = '84829664' ,`ListAgentFullName` = 'Timothy Williams' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.137932' ,`Longitude` = '-94.406214' ,`PhotoCount` = '17' ,`PostalCode` = '77659' ,`RoomCount` = '4' ,`ListPrice` = '69900.00' ,`Status` = 'Active' ,`StreetName` = 'Hartel' ,`StreetNumber` = '265' ,`StreetSuffix` = 'Street' ,`City` = 'Sour Lake' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '912' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute little 2/1 investment property! This home has an adorable backyard that would be great for pets or kids to play or for a little garden. Make your appointment today!' ,`Acres` = '0.1148' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 7 BLK 11 ELECTRIC ADDN P# HJ11-11-4' ,`LotDesciption` = 'Other' ,`LotSize` = '5001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'SOUR LAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Electric Add' ,`TaxAmount` = '920' ,`TaxRate` = '2.2858' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093526' WHERE `Matrix_Unique_ID` = '213663639' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T11:56:19.247' ,`MLSNumber` = '26930388' ,`ListAgentFullName` = 'Rock Edwards' ,`ListOfficeName` = 'Rock Edwards & Associates,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.740425' ,`Longitude` = '-95.405024' ,`PhotoCount` = '50' ,`PostalCode` = '77098' ,`RoomCount` = '12' ,`ListPrice` = '1650000.00' ,`Status` = 'Active' ,`StreetName` = 'Kipling' ,`StreetNumber` = '1810' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '4578' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic Custom Built home in sought after inner loop neighborhood of Winlow Place. Built for entertaining. Home features dramatic curved staircase with brushed stainless & glass railings, Maple paneling fabricated and installed onsite including matching custom storage pieces. Slate decked Pool and Spa. Kitchen with sub zero refrigerator & 6 burner Wolf Range & bar height island. An oversized primary bedroom with angled windows overlooking pool. Enormous primary bath with walk-in shower, jetted tub & 3 glass vessel sinks. 1st floor features 2 entertainment areas the first at the entry and 2nd with rounded glass walls & \r\naccess to side patio and currently has a baby grand piano. One of the bedrooms is in the rear of the home with direct access to pool and spa & has an en suite bathroom that also has access outside from pool area.\r\nThe 3rd floor has a large bedroom, a \"game room\", bonus room, full bath & tons of storage. A unique home for those who love contemporary design.' ,`Acres` = '0.1435' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 25B & 26A BLK 8 WINLOW PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Winlow Place' ,`TaxAmount` = '27599' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093526' WHERE `Matrix_Unique_ID` = '214122484' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T11:52:53.380' ,`MLSNumber` = '42732222' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.504130' ,`Longitude` = '-95.720160' ,`PhotoCount` = '40' ,`PostalCode` = '77469' ,`RoomCount` = '8' ,`ListPrice` = '547979.00' ,`Status` = 'Active' ,`StreetName` = 'Ash Valley' ,`StreetNumber` = '5830' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2877' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Award-winning craftsmanship and remarkable luxuries combine in the delightful Omni new home plan. Gather in the open dining and living areas for delectable meals and memorable evenings together. The contemporary kitchen offers ample room for storage, meal prep, cooking, and presentation. Design your ideal home office, media studio, or game room in the open study and quiet retreat. A pair of secondary bedrooms provide lovely places for growth and personalization. Retire to the effortless comforts of your Owner’s Retreat, which features a serene en suite bathroom and a walk-in closet. Contact our StoneCreek Estates Team to learn more about the built-in storage spaces and conveniences in this new home plan.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 1' ,`LotDesciption` = 'Other' ,`LotSize` = '7200' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stonecreek Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093527' WHERE `Matrix_Unique_ID` = '214512916' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T12:16:30.287' ,`MLSNumber` = '35410429' ,`ListAgentFullName` = 'Toke Ettehadieh' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.523765' ,`Longitude` = '-95.171274' ,`PhotoCount` = '27' ,`PostalCode` = '77546' ,`RoomCount` = '8' ,`ListPrice` = '249786.00' ,`Status` = 'Active' ,`StreetName` = 'Barcelona' ,`StreetNumber` = '17138' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3 bedroom 2 bathroom home. Ready for move in! Great family room with high ceilings and a fireplace. Opened floor plan. Family friendly neighborhood and low taxes. Check out the Virtual Tour and Schedule a Showing Today!' ,`Acres` = '0.1618' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SE 2 FT OF LT 8 & NW 63.2 FT OF LT 9 FOREST BEND SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'WEDGEWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Bend 3 Fourplex Pt' ,`TaxAmount` = '4563' ,`TaxRate` = '2.2534' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093527' WHERE `Matrix_Unique_ID` = '214623326' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T12:49:10.480' ,`MLSNumber` = '51408763' ,`ListAgentFullName` = 'Nathan Bowers' ,`ListOfficeName` = 'All City Real Estate, Ltd. Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.132103' ,`Longitude` = '-94.197283' ,`PhotoCount` = '6' ,`PostalCode` = '77713' ,`RoomCount` = '11' ,`ListPrice` = '69900.00' ,`Status` = 'Active' ,`StreetName` = 'Tolivar' ,`StreetNumber` = '7820' ,`StreetSuffix` = 'Road' ,`City` = 'Beaumont' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AS IS SPECIAL IN THE GROWING BEAUMONT ISD AREA! Bring Your Bright Ideas As This 2 Story, 3 Bed, 3.5 Bath House Is Looking For A Lot Of Love From The Right Person! Property Does Have Previous Fire Damage. Current Seller Has Not Seen The Property, But All Information On The Listing Deemed Reliable. Buyer & Buyer\'s Agent Are Encouraged To Follow Through With Due Diligence.' ,`Acres` = '0.36' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'MIZE ESTATES LOT 4 .360 AC' ,`LotDesciption` = 'Other' ,`LotSize` = '15682' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'GUESS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'VINCENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Mize Estates' ,`TaxAmount` = '2092' ,`TaxRate` = '2.6134' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093527' WHERE `Matrix_Unique_ID` = '214903158' --> 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','215175081','1675093527','215175081','2022-12-20T12:01:08.383','14533499','Jennifer Gangeri','Martha Turner Sotheby\'s International Realty','','','29.740324','-95.450212','40','77027','9','1150000.00','Active','Mid','2701','Lane','Houston','3','1','4','3866','Single-Family','2701 Mid Lane is located within idyllic West Lane Place, steps away from swanky Highland Village shopping and dining. This 2-story, brick home sitting on a full-sized lot is the needle in a haystack of townhomes. Never stress for parking for you or guests with the 2-car garage + driveway with space for 4 cars. Updates to the home include double pane windows, new double-entry front door, recent water heater, UV air filters at AC compressor, and full kitchen reno. The kitchen sparkles with an oversized island, secondary sink, beverage fridge and high-end Miele appliances. Built-in refrigerator, electric double ovens with microwave, steam and convection capabilities + warming drawer. The open floorplan flows with living and study downstairs and 4 bedrooms + laundry upstairs. Enjoy the abundantly sized primary suite with a gas log fireplace, coffered ceiling, bidet, and colossal closet! Outside, the low-maintenance garden provides plenty of entertaining space plus a 4-hole putting green.','0.1466','16','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','3','Highland Village/Midlane','Central Gas','0','TR 11A BLK 2 WEST LANE PLACE','Subdivision Lot','6385','Appraisal District','','','0','','2','Convection Oven,Double Oven,Electric Oven','0','','','Gas Range','','Composition','27 - Houston','SCHOOL AT ST GEORGE PLACE','LAMAR HIGH SCHOOL (HOUSTON)','LANIER MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','West Lane Place','21547','2.3307','Public Sewer,Public Water','1992','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','215179441','1675093527','215179441','2022-12-20T11:31:43.230','11351546','Stacy Dodson','H-TOWN REALTY','','','30.018512','-95.539522','26','77379','13','449000.00','Active','Carriage Dale','17107','Court','Spring','3','1','5','4788','Single-Family','Photos were taken prior to Seller move in. Home is currently occupied. Gorgeous 2 story home 5 bedroom home on spacious cul-de-sac lot and 3 car garage. Grand entrance boasts high ceilings and curved staircase. Formal dining and home office off entry. Island kitchen with walk-in pantry, stainless steel appliances, double ovens. Great room has high ceilings, fireplace, built-ins, and wet bar. Second staircase located off breakfast room. Indoor laundry has room for a second fridge. Upstairs four bedrooms, 2 full baths, gameroom with wet bar. 2019 Roof. Lots of updates throughout!','0.2847','13','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Freestanding','1','Champions Area','Central Gas','1','LT 28 BLK 4 MEMORIAL NORTHWEST SEC 13','Cul-De-Sac','12400','Appraisal District','','695','0','','1','Double Oven','0','','','Electric Cooktop','','Composition','32 - Klein','THEISS ELEMENTARY SCHOOL','KLEIN HIGH SCHOOL','DOERRE INTERMEDIATE SCHOOL','Accompany,Appointment Required','Appraisal District','2','Traditional','Memorial Northwest Sec 13','11673','2.3213','Water District','1984','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','215463604','1675093527','215463604','2022-12-20T12:09:57.817','77963377','James Valles','R.E.D. Right Realty','','','30.116345','-95.617078','6','77375','6','385000.00','Active','Mckinney','30615','Drive','Tomball','1','1','3','1814','Single-Family','Welcome home. Rare listing in the highly desired McKinney Place subdivision. This estimated half acre lot offers the possibility to expand this 1,814 sq. ft. 3 bedroom, 1.5 bathroom home. There is also plenty room to install a custom pool. The subject property is in the Tomball Independent School District which is one of the best in and around the great Houston area. No HOA. All offers are welcome.','0.5','14','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Tomball','Central Electric','0','LT 4 MCKINNEY PLACE U/R ABST 50 J MILLER','Cleared,Subdivision Lot','21780','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','53 - Tomball','TOMBALL ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','TOMBALL JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Mckinney Place','5782','2.0872','Septic Tank','1980','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','215727272','1675093527','215727272','2022-12-20T11:03:11.320','94785382','Deana Fojt','Coldwell Banker Realty','','','29.743213','-94.957569','25','77520','10','139800.00','Active','Vista','603','Avenue','Baytown','2','0','5','','Single-Family','Great home with 5 bedrooms. Ready. Open floor plan from kitchen to Family room. Huge primary bedroom with luxury bath. Great neighborhood. This is a must see!','0.1414','2','','','Electric Dryer Connections','','Sellers Disclosure','','','','Baytown/Harris County','Central Electric','0','LT 27 VISTA VILLAGE R/P','Subdivision Lot','6160','Appraisal District','','','0','','0','Electric Oven','0','','','','','Composition','23 - Goose Creek Consolidated','ASHBEL SMITH ELEMENTARY SCHOOL','LEE HIGH SCHOOL (GOOSE CREEK)','HORACE MANN J H','Appointment Required','','1','Traditional','Vista Village R/P','536','2.97','Public Sewer,Public Water','1997','Appraisal District'); --> New record created successfully