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-07T12:02:00.023' ,`MLSNumber` = '90507730' ,`ListAgentFullName` = 'Traci Crawford' ,`ListOfficeName` = 'Origen Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.139777' ,`Longitude` = '-95.050943' ,`PhotoCount` = '8' ,`PostalCode` = '77554' ,`RoomCount` = '4' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Yoakum' ,`StreetNumber` = '22114' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new construction home on canal lot in Sea Isle. If purchased in time you can have the option to select your finishes including paint, countertops, tile, and appliances. This home comes with two primary suites one up and one down with beautiful views! This 1700 sq ft waterfront home offers 4 bedrooms, 3 baths, and an oversized 1 car garage. This home will be complete with composite decking on porches, boat house and party deck. Loaded with features that include open living room with wall of windows and high ceilings, wood look floors, gourmet kitchen with stainless appliances, custom cabinetry, quartz or granite counters, and island. Home will be built with all high efficiency impact windows and doors, aluminum roof, concrete columns and raised well above base flood elevation for cheaper flood insurance. Estimated completion is January 2023. Vacation rentals allowed!' ,`Acres` = '0.1033' ,`Area` = '33' ,`BuilderName` = 'delCampo Customs LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 65 SEA ISLE 15TH EXTENSION' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '225' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sea Isle Ext 15' ,`TaxAmount` = '1738' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088349' WHERE `Matrix_Unique_ID` = '204323275' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T11:24:35.427' ,`MLSNumber` = '87784397' ,`ListAgentFullName` = 'Joan Coufal' ,`ListOfficeName` = 'Coldwell Banker The Ron BrownCompany' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.702893' ,`Longitude` = '-96.547003' ,`PhotoCount` = '9' ,`PostalCode` = '78934' ,`RoomCount` = '4' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Fannin' ,`StreetNumber` = '1410' ,`StreetSuffix` = 'Street' ,`City` = 'Columbus' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '812' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION! LOCATION! HIGH VISABILITY AREA and CONVENIENT LOCATION makes property IDEAL for COMMERCIAL or RESIDENTIAL. Located on a main street with high foot and vehicle traffic (see Traffic Counts in photos) and zoned for both commercial and residential, this is an investors dream boasting several options for the new owner. If you are looking to invest in real estate, this is the one.' ,`Acres` = '0.1049' ,`Area` = '56' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'BLK 73 LT PT 5,6 COLUMBUS & HOUSE' ,`LotDesciption` = 'Other' ,`LotSize` = '4569' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '188 - Columbus' ,`SchoolElementary` = 'COLUMBUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLUMBUS HIGH SCHOOL' ,`SchoolMiddle` = 'COLUMBUS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbus' ,`TaxAmount` = '736' ,`TaxRate` = '1.8359' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1935' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088350' WHERE `Matrix_Unique_ID` = '205719277' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T12:24:31.003' ,`MLSNumber` = '81224831' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Chase Manor' ,`SellingOfficeName` = 'Camelot Realty' ,`Latitude` = '30.062454' ,`Longitude` = '-95.716855' ,`PhotoCount` = '17' ,`PostalCode` = '77377' ,`RoomCount` = '9' ,`ListPrice` = '418794.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Avelignese' ,`StreetNumber` = '20431' ,`StreetSuffix` = 'Way' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2207' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Create unforgettable memories in this stunning Beazer Home in Amira, boasting wood-look tile flooring, a fireplace, study with French doors, open great room, and an extended covered patio. Spend all day in the kitchen, equipped with quartz countertops, mosaic backsplash, stainless steel appliances, pendant lighting, and undercounter lighting. The spa-like primary suite features a walk-in closet, dual vanities, and a mud set shower. With the community situated so close to the Grand Parkway and Hwy 249, residents are only minutes away from a variety of dining and shopping options. Amira amenities include an infinity-edge pool, dog park, and gym. Nearby schools are a part of the top-rated Tomball ISD. You don’t want to miss this home – call now' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088350' WHERE `Matrix_Unique_ID` = '210412239' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T12:38:59.867' ,`MLSNumber` = '66996074' ,`ListAgentFullName` = 'Cynthia Hodges' ,`ListOfficeName` = 'Broussard\'s Real Estate Invest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766407' ,`Longitude` = '-95.269797' ,`PhotoCount` = '13' ,`PostalCode` = '77029' ,`RoomCount` = '4' ,`ListPrice` = '185000.00' ,`Status` = 'Active' ,`StreetName` = 'Berndale' ,`StreetNumber` = '8703' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1332' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome! This 2 bedroom, with possibilities to be a 3 bedroom, 1 bath home has great potential and sits on a corner lot! The primary bedroom was originally 2 bedrooms that were converted into one large bedroom. There is a room off of the kitchen that has a walk in closet that could be used as a third bedroom. The floors are the original oak hardwood floors. The utility/mudroom is right off the kitchen and leads to the backyard where a large two car garage/workshop was built in 2018. There\'s parking for three cars in front of the garage and additional parking in the driveway in front of the house. Check out this diamond in the rough!' ,`Acres` = '0.1419' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 172 BLK 8 PLEASANTVILLE SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6180' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PLEASANTVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FURR HIGH SCHOOL' ,`SchoolMiddle` = 'HOLLAND MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Pleasantville Sec 08' ,`TaxAmount` = '2418' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675088350' WHERE `Matrix_Unique_ID` = '211404215' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T11:42:50.513' ,`MLSNumber` = '9478457' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.118036' ,`Longitude` = '-95.564801' ,`PhotoCount` = '24' ,`PostalCode` = '77375' ,`RoomCount` = '6' ,`ListPrice` = '528831.00' ,`Status` = 'Active' ,`StreetName` = 'Keswick Valley' ,`StreetNumber` = '24547' ,`StreetSuffix` = 'Way' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2512' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Longspuur floorplan - Fantastic two-story home featuring 4 bedrooms, 3.5 baths, and a 2 bay garage. The covered front porch leads to a grand foyer showcasing a curved staircase. This open concept layout centers around a spacious kitchen overlooking both the casual dining area and great room. The primary suite features dual sinks and a large walk-in closet. Upstairs you will find a game room and two additional bedrooms.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '01/07/11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MAHAFFEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes at Creekside' ,`TaxAmount` = '' ,`TaxRate` = '2.92' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088350' WHERE `Matrix_Unique_ID` = '212243532' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T11:54:25.590' ,`MLSNumber` = '72458347' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.745993' ,`Longitude` = '-95.610387' ,`PhotoCount` = '21' ,`PostalCode` = '77320' ,`RoomCount` = '7' ,`ListPrice` = '295367.00' ,`Status` = 'Active' ,`StreetName` = 'Bobcat' ,`StreetNumber` = '114' ,`StreetSuffix` = 'Bend' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2052' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Hunter\'s Creek in Huntsville, TX! The Ellington floor plan is a spacious 2-story home with 3 bedrooms, 2.5 bathrooms, game room, formal dining room, and 2-car garage. This home has it all, including blinds, vinyl plank flooring, and tray ceilings for some dramatic flair! The gourmet kitchen is sure to please with 42 inch cabinetry, tile backsplash, and granite countertops. Retreat to the first floor Owner\'s Suite featuring double sinks, a separate tub and shower, and spacious walk-in closet! Secondary bedrooms have walk-in closets, too! Don\'t miss your opportunity to call Hunter\'s Creek home, schedule a visit today!' ,`Acres` = '' ,`Area` = '43' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HUNTERS CREEK SECTION 1, BLOCK 12, LOT 16, ACRES 0.14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'HUNTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Creek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088350' WHERE `Matrix_Unique_ID` = '213619422' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T11:53:52.177' ,`MLSNumber` = '2741092' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.745947' ,`Longitude` = '-95.609753' ,`PhotoCount` = '15' ,`PostalCode` = '77320' ,`RoomCount` = '6' ,`ListPrice` = '267490.00' ,`Status` = 'Active' ,`StreetName` = 'Bobcat' ,`StreetNumber` = '106' ,`StreetSuffix` = 'Bend' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1523' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Hunter\'s Creek in Huntsville, TX! The Grayson floor plan is a charming 1-story home with 3 bedrooms, 2 bathrooms, and a 2-car garage! This home has it all, including blinds and vinyl plank flooring! The gourmet kitchen is sure to please with an island overlooking the dining and family rooms, 42” cabinets, and granite countertops! Retreat to the Owner’s Suite featuring double sinks, separate tub and shower, spacious walk-in closet, and tray ceiling for some dramatic flair! Enjoy the great outdoors with a covered patio! Don\'t miss your opportunity to call Hunter\'s Creek home, schedule a visit today!' ,`Acres` = '' ,`Area` = '43' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HUNTERS CREEK SECTION 1, BLOCK 12, LOT 13, ACRES 0.14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'HUNTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Creek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088351' WHERE `Matrix_Unique_ID` = '213620118' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T11:17:34.177' ,`MLSNumber` = '87551059' ,`ListAgentFullName` = 'James Polomsky' ,`ListOfficeName` = 'Red Door Realty & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.233818' ,`Longitude` = '-95.576580' ,`PhotoCount` = '22' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Durango' ,`StreetNumber` = '6718' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2355' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this updated and upgraded beauty!! Beautiful one story with 3/4 bedrooms. Huge kitchen with stainless steel appliances. Extra built ins with 42-inch cabinets. Lead glass/storm front door. Screened in back porch. Outside deck and fire pit. Lush landscaping front and back with fresh flowers and rock edging. Decorative front patio. Upgrades include:\r\nExtended Driveway (w/ room for a trailer or golf cart)-2021, Laminent Wood Floors-2020, Roof-2019, Wood Deck-2019, Double convection oven-2019. Sprinkler system- BRAND NEW control panel and all heads replaced in 2022. other upgrades include a beautiful wood barn door to the office/flex room, and a cedar custom mantle over the fireplace. Come view this beautiful country like living home in Magnolia. MAKE AN APPOINTMENT NOW!' ,`Acres` = '0.2755' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WOODLAND OAKS, BLOCK 9, LOT 36' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Woodland Oaks' ,`TaxAmount` = '5150' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088351' WHERE `Matrix_Unique_ID` = '214337438' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-07T11:21:09.730' ,`MLSNumber` = '15290642' ,`ListAgentFullName` = 'Bessy Farris' ,`ListOfficeName` = 'FYI Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.464620' ,`Longitude` = '-95.030223' ,`PhotoCount` = '22' ,`PostalCode` = '77539' ,`RoomCount` = '4' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Briarbrook' ,`StreetNumber` = '5015' ,`StreetSuffix` = 'Drive' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1822' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Home ready for you to make it yours! 4 bedrooms, Den, Living , dining and breakfast area, Converted garage that can be use as game room, extra bedroom, family room , you name it! Big backyard , fresh paint throughout whole house. Just a little TLC, and this will be the perfect starter home or investment property! schedule your showing today! Check out our video link!' ,`Acres` = '0.2512' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 60 E P EPPERSON LOT 8 BLK 2 PLANTATION ESTATES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '10943' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation Estates 1' ,`TaxAmount` = '4813' ,`TaxRate` = '2.5214' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675088351' WHERE `Matrix_Unique_ID` = '214379661' --> 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','214966131','1675088351','214966131','2022-12-07T12:41:51.290','93037014','Malika Tookes','NB Elite Realty','','','32.641774','-97.138825','13','76001','9','430000.00','Active','Fannin Dr','6407','','Arlington','2','0','4','2679','Single-Family','YOU DON\'T WANT TO MISS THIS DESIRED FLOOR PLAN.!!!! Charming 1-story home, 4 Bedrooms, located in Fannin Farm subdivision. Large living room located in the center of the home with a fireplace, windows overlooking the backyard. Chef style kitchen with a lovely breakfast nook with lots of natural light. Spacious primary bedroom with walk-in closets, double sink vanity, tub and shower. Other 3 bedrooms are nicely sized with an attached garage.','','84','','','','','Sellers Disclosure','','','','','Central Electric','1','FANNIN FARM ADDITION Block 11 Lot 4','Subdivision Lot','7187','Appraisal District','','300','0','','2','','0','','','','','Composition','221 - Mansfield','CAROL HOLT ELEMENTARY SCHOOL','MANSFIELD SUMMIT HIGH SCHOOL','T.A. HOWARD MIDDLE SCHOOL','Appointment Required','Seller','1','Contemporary/Modern','FANNIN FARM ADDITION','','','Public Sewer,Public Water','1998','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','215346413','1675088351','215346413','2022-12-07T12:45:44.660','27888554','Robbie Nelson','RE/MAX Crossroads Realty','','','29.354120','-95.108818','32','77510','8','579000.00','Active','28th','13531','Street','Santa Fe','2','1','3','2560','Single-Family','Are you looking for a home in the country? Check out this Spanish style home on 4.46 acres. Formal living and den features a double fireplace. Formal dining room, kitchen and breakfast area and bath in the utility room. Home has lots of space and a sunroom to host large gatherings or just sit and watch the sunsets. Enough room to bring your animals, build a barn or workshop to create your very own oasis!','4.463','33','','','','','Sellers Disclosure','','Wood Burning Fireplace','2','Santa Fe','Central Gas,Propane','0','ABST 47 L CRAWFORD SUR PT OF OUTLOT 399 (399-5) ALTA LOMA OU','Cleared','194408','Appraisal District','','','0','','2','Electric Oven','0','','','Gas Cooktop','','Tile','45 - Santa Fe','DAN J KUBACAK ELEMENTARY SCHOOL','SANTA FE HIGH SCHOOL','SANTA FE JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Spanish','Alta Loma Outlots','8316','2.0139','Septic Tank,Well','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','215405568','1675088351','215405568','2022-12-07T11:04:35.277','89083049','Bill Gottfried','Gottfried InternationalEstates','','','43.707700','7.334400','12','4370','3','3100000.00','Active','Rue Gallieni Beaulieu-sur-Mer','M6098','','Other','3','0','3','2260','Single-Family','Beautiful villa in Beaulieu-sur-Mer, located in a quiet and sunny area and incorporating a peaceful garden planted with citrus, orange, and lemon fruit trees. Beautifully appointed. On the ground floor there are an entrance, a large living room, a dining room, a separate fully fitted kitchen, an office, and a large WC. Upstairs, there are a bedroom with dressing room and full bath, a second bedroom with bath, numerous closets, and a third bedroom. On the garden level there is a two room apartment with its own entrance, sauna, laundry room, and an office room. There is an elevator for all levels, and an alarm, insulation throughout, and air conditioning throughout. There is a garage for 2 parking spaces. There is room to install a swimming pool. The residence is close to all amenities, the beaches are 2 minutes away, and Monaco is 15 minutes away. Beaulieu-sur-Mer borders Saint-Jean-Cap-Ferrat and Villefranche-sur-Mer and not far from Eze to the northeast.','','','','','','','No Disclosures','','','','','Central Gas','0','Beaulieu-sur-Mer 6098 Alpes-Maritimes Department','Patio Lot,Water View','','','','','0','','2','','0','','','','','Slate,Tile','','','','','Accompany,Appointment Required,Controlled Access','Builder','2','French,Mediterranean','Beaulieu-sur-Mer 73344 Alpes-Maritimes','','','Public Sewer,Public Water','2000','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','215406575','1675088351','215406575','2022-12-07T11:27:24.837','88956928','Frances Deserrano','Advantage Real Estate','','','29.526878','-94.758244','36','77514','4','135000.00','Active','Bayshore','128','Road','Anahuac','1','0','1','720','Single-Family','Charming bay house with water views. Many improvements including new foundation, staircase, and remodeled bathroom. House has one bedroom and one bathroom with a clawfoot tub and washer/dryer included. A large, bright open floor plan living area with room for a daybed or guest space. The downstairs has a garage/workshop area with room to park a single car or small boat and has double door access. There is a great open-air fish cleaning room with its own water supply and sink. Large enclosed yard with double gates, fruit trees and tropical plants. Sit on the upper porch or the swing downstairs and relax. Fishing and water access are right around the corner and there is a community pier and boat launch close by. Stove and refrigerator stay. This house is move-in ready, whether you’re looking for a vacation getaway near the water or you are ready for a full-time move to the slower pace of coastal living.','0.1722','53','','','','','Mud,Sellers Disclosure','','','','Chambers County East','Window Unit','0','34 SOUTHSHORE #1','Cleared,Water View','7500','Appraisal District','','','0','','1','','0','','','','','Aluminum','4 - Anahuac','ANAHUAC ELEMENTARY SCHOOL','ANAHUAC HIGH SCHOOL','ANAHUAC MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Other Style','South Shore & Add 01','1294','2.467','Water District','1974','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','215409790','1675088352','215409790','2022-12-07T12:45:25.177','50756562','Patty Laviolette','A Action Realty','','','30.726078','-95.055182','29','77351','3','79900.00','Active','Terlingua','411','','Livingston','2','0','3','1624','Single-Family','Lake Livingston Village is located in East Texas about an hour 1/2 north of Houston. The subdivision offers 2 pools, pavilion, covered picnic area, fishing pier and a boat ramp, Putt Putt Golf and More.','0.23','44','','','','','No Disclosures,Tenant Occupied','','','','Lake Livingston Area','Wall Heater','1','LOT 46,47,48,49','Cleared','10080','Appraisal District','','600','0','','0','','0','','','','','Composition','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Lake Livingston Village','1523','1.8745','Public Sewer,Public Water','2002','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','215410463','1675088352','215410463','2022-12-07T12:54:14.297','76823573','Jane NgaDung Nguyen','Alpha, REALTORS','','','29.934568','-95.537414','30','77064','10','450000.00','Active','Heron Lakes','7302','Drive','Houston','3','1','5','4082','Single-Family','Beautiful home in a gated community, This home has 5 bedrooms & 3 full/1 half baths, High ceiling, hardwood flooring in entry way, formal dining/living, family room, master bedroom, and staircase; ceramic tile in kitchen, breakfast and baths, granite countertop in kitchen area with Island. Open an spacious game room for entertaining, and extra for media room. New Laminate floor upstairs, and whole house with new paint. Minutes to Hwy 290 and Hwy 249, is surrounded with restaurants, education opportunities, entertainment venues, shopping and more.','0.1603','10','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Willowbrook South','Central Gas','1','LT 51 BLK 2 HERON LAKES ESTATES','Corner','6982','Appraisal District','','1100','0','','2','Freestanding Oven','0','','','Freestanding Range','','Composition','13 - Cypress-Fairbanks','WILLBERN ELEMENTARY SCHOOL','CYPRESS CREEK HIGH SCHOOL','CAMPBELL MIDDLE SCHOOL','Leave Business Card,Lockbox Front','Appraisal District','2','Traditional','Heron Lakes Estates','6835','2.1637','Public Sewer,Public Water','2006','Appraisal District'); --> New record created successfully