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-29T08:36:59.857' ,`MLSNumber` = '5204913' ,`ListAgentFullName` = 'Ethan Cameron' ,`ListOfficeName` = 'Cameron Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.296892' ,`Longitude` = '-94.978553' ,`PhotoCount` = '24' ,`PostalCode` = '77327' ,`RoomCount` = '9' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2267' ,`StreetNumber` = '22' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2947' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom 2 bath ranch style home is located on 1.96 fenced acres in Tarkington ISD. This large 2,900+ square foot home features a living room, center island kitchen, and a game room for an abundance of living spaces. The yard features large shade trees that blanket the lush green grass and offer a welcoming break from the Texas summer sun.' ,`Acres` = '1.96' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000116 J WEST, TRACT 62 140 161 181, ACRES 1.96' ,`LotDesciption` = 'Cleared' ,`LotSize` = '85377' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'TARKINGTON PRIMARY SCHOOL' ,`SchoolHigh` = 'TARKINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'TARKINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'J West' ,`TaxAmount` = '2692' ,`TaxRate` = '1.539' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096947' WHERE `Matrix_Unique_ID` = '199883796' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T08:43:37.100' ,`MLSNumber` = '70367545' ,`ListAgentFullName` = 'Alex Westbrook-McCollum' ,`ListOfficeName` = 'Swede\'s Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.462046' ,`Longitude` = '-94.625532' ,`PhotoCount` = '24' ,`PostalCode` = '77650' ,`RoomCount` = '3' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Meynig' ,`StreetNumber` = '993' ,`StreetSuffix` = 'Drive' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '895' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION! Beautiful 2 bedroom 2 bathroom sitting in the heart of Crystal Beach. Beachside with direct access by your vehicle/golf cart/foot. The kitchen features stainless steel appliances, beautiful backsplash, and a mobile island to move at your convenience. This 895 sq ft home has NO carpet and utilizes space with a bunk room! It will be sold fully furnished, excluding a few personal belongings. It has never been a rental but would do well with renters who don’t have too many guests. Close to all restaurants and attractions.' ,`Acres` = '0.1033' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 PAGE 4 LOT 2 MEYNIG ADDN' ,`LotDesciption` = 'Cleared' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Meynig' ,`TaxAmount` = '4146' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096947' WHERE `Matrix_Unique_ID` = '207416271' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T08:48:54.987' ,`MLSNumber` = '88707950' ,`ListAgentFullName` = 'Cindy Conti' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748073' ,`Longitude` = '-95.341880' ,`PhotoCount` = '22' ,`PostalCode` = '77003' ,`RoomCount` = '10' ,`ListPrice` = '709000.00' ,`Status` = 'Active' ,`StreetName` = 'Sampson St' ,`StreetNumber` = '510' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2482' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New luxury builds in premier location in EaDo. Unobstructed skyline views with rooftop terrace overlooking Downtown. Built ready for an outdoor kitchen and wired for entertaining. Open balconies on every floor, including private backyard! Smart home features for easy remote access to A/C, lights, cameras, and doors. Open floorplan with natural light and high ceilings. Primary retreat on 3rd floor with stunning views of Downtown skylines, including an oversized walk-in closet, spa like shower and free-standing garden tub. 1st floor is suited to be an ADA compliant bedroom and bathroom with full 360 degree turn radius. Check out virtual tour links!' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'Nazi Family' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 548 RANGER - SSBB' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2679' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LANTRIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'RANGER - SSBB' ,`TaxAmount` = '' ,`TaxRate` = '2.33' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675096947' WHERE `Matrix_Unique_ID` = '207624098' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T08:48:30.900' ,`MLSNumber` = '59288696' ,`ListAgentFullName` = 'Cindy Conti' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748073' ,`Longitude` = '-95.341880' ,`PhotoCount` = '22' ,`PostalCode` = '77003' ,`RoomCount` = '10' ,`ListPrice` = '718000.00' ,`Status` = 'Active' ,`StreetName` = 'Sampson St' ,`StreetNumber` = '508' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2518' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New luxury builds in premier location in EaDo. Unobstructed skyline views with rooftop terrace overlooking Downtown. Built ready for an outdoor kitchen and wired for entertaining. Open balconies on every floor, including private backyard! Smart home features for easy remote access to A/C, lights, cameras, and doors. Open floorplan with natural light and high ceilings. Primary retreat on 3rd floor with stunning views of Downtown skylines, including an oversized walk-in closet, spa like shower and free-standing garden tub. 1st floor is suited to be an ADA compliant bedroom and bathroom with full 360 degree turn radius. Check out virtual tour links!' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'Nazi Family' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 548 RANGER - SSBB' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2679' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LANTRIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'RANGER - SSBB' ,`TaxAmount` = '' ,`TaxRate` = '2.33' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675096947' WHERE `Matrix_Unique_ID` = '207642639' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T08:03:44.220' ,`MLSNumber` = '32965413' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Dequalin Jackson' ,`SellingOfficeName` = 'Blackshear Realty' ,`Latitude` = '30.367030' ,`Longitude` = '-95.665467' ,`PhotoCount` = '39' ,`PostalCode` = '77316' ,`RoomCount` = '5' ,`ListPrice` = '318990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Little Rabbit' ,`StreetNumber` = '1610' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2267' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOVELY NEW D. R. HORTON BUILT ONE STORY! Great Interior Layout! Lovely Foyer Leads to Gourmet Island Kitchen with Big Corner Pantry, Light & Bright Dining Area, & Supersized Family Room! Privately Located Primary Suite Offers Garden Bath with Dual Sinks, Separate Tub & Shower, & Huge Walk-In Closet! Covered Patio & Sprinkler System! High Ceilings, Recessed Lighting, Linen & Coat Closets, Tons of Storage Space - Too Much to List! HURRY! Nestled in the rolling hills along FM 2854, you\'ll find FAIRWATER the NEWEST community in Montgomery, TX! Zoned to the prestigious Montgomery ISD students receive the best education in some of the HIGHEST rated schools in the state! Come see why we are the FASTEST growing community in Montgomery, TX' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Fairwater 07, BLOCK 2, Lot 46' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairwater' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675096947' WHERE `Matrix_Unique_ID` = '212235373' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T08:33:30.213' ,`MLSNumber` = '22718074' ,`ListAgentFullName` = 'J. Claudia Seybold' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.965552' ,`Longitude` = '-95.172832' ,`PhotoCount` = '27' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Blanton Forest' ,`StreetNumber` = '17214' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2364' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful three bedroom, one office, two full bath, one story , situated on spacious lot, located in The Groves. This charming one story features a spacious open kitchen/formal dining to the living room for great entertaining. The spacious kitchen features a large island with seating and a sink, stainless steel appliances, built in desk, butlers pantry, granite counter tops and an abundance of cabinets for all the space you need. Inviting living room featuring engineered wood floors and gas log fire place. Private office with glass French doors. The primary bedroom features high ceilings, ceiling fan, his/her vanities, large walk in shower, and spacious walk in closet. Exterior features back covered patio. Call today to see how this beauty can become yours!' ,`Acres` = '0.2014' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 1 GROVES SEC 2' ,`LotDesciption` = 'Cleared,Greenbelt,Subdivision Lot' ,`LotSize` = '8775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '264' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Groves' ,`TaxAmount` = '10478' ,`TaxRate` = '3.443' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096948' WHERE `Matrix_Unique_ID` = '213276910' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T07:33:13.770' ,`MLSNumber` = '3974701' ,`ListAgentFullName` = 'Travis Nichols' ,`ListOfficeName` = 'Keller Williams Realty - Memor' ,`SellingAgentFullName` = 'Lisa Mann' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.903892' ,`Longitude` = '-95.623427' ,`PhotoCount` = '32' ,`PostalCode` = '77095' ,`RoomCount` = '9' ,`ListPrice` = '329500.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Trailbrook' ,`StreetNumber` = '14710' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2515' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautifully updated home located in Copperbrook, one of Houston\'s well-established neighborhoods. Inviting entry leads to spacious formal living & dining room adorned w/crown molding & wood plantation shutters. Kitchen remodeled in 2019 w/luxurious cabinets, Quartz countertops, glass tile backsplash, Viking dishwasher, and large breakfast island w/ample drawer storage. Many of the floors have been completely updated to engineered wood in 2019. Other recent updates include HVAC (2019); Outdoor Covered Patio (2019); and 22kw Generac (2022); Large Primary Bedroom w/tons of natural light; Primary Bath features dual sink vanity, separate tub shower, & large walk-in closet. Gameroom up with built-in speakers! Covered Patio is a main highlight for your entertaining w/Wet Bar, Gazebo, and Summer Kitchen. Community pool and playground in subdivision. Zoned to the highly acclaimed Cypress-Fairbanks ISD! Easy access to Hwy 290, Beltway 8 and Hwy 99!' ,`Acres` = '0.1105' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 6 COPPERBROOK SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '4813' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '675' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'OWENS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Copperbrook' ,`TaxAmount` = '5879' ,`TaxRate` = '2.401' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096948' WHERE `Matrix_Unique_ID` = '213644818' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T08:25:29.997' ,`MLSNumber` = '12654675' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.980388' ,`Longitude` = '-95.226467' ,`PhotoCount` = '6' ,`PostalCode` = '77338' ,`RoomCount` = '11' ,`ListPrice` = '449995.00' ,`Status` = 'Active' ,`StreetName` = 'Saxon Creek' ,`StreetNumber` = '18406' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3421' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** This amazing KB Home in Estates of Tour 18 could be your dream home, featuring a brick front, stone veneer, and an open great room. Prepare incredible feasts in the kitchen, equipped with granite countertops, tile backsplash, 30” gas cooktop, stainless steel Energy Star® appliances, and 42-in. cabinets. The spa-like primary suite boasts extended dual vanities and a shower with a Moen Seena® WaterSense showerhead. Additional home features include an extended covered patio. This beautiful golf course community is conveniently located near Hwy 59 and Beltway 8, giving residents easy access to Downtown Houston, The Woodlands, Lake Houston, and the George Bush Intercontinental Airport. Residents are mere minutes from dining and shopping at the Atascocita Commons and Deerbrook Mall. Zoned to the highly-rated Humble ISD.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '748' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'LAKELAND ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'ROSS STERLING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tour 18' ,`TaxAmount` = '' ,`TaxRate` = '2.933' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675096948' WHERE `Matrix_Unique_ID` = '214621719' --> 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','215686276','1675096948','215686276','2022-12-29T07:13:18.127','10146109','Tia Copeland','Keller Williams Realty - Memor','','','29.908917','-95.462885','29','77038','4','235500.00','Active','Mallard Stream','12047','Court','Houston','2','1','3','1431','Single-Family','Very charming home waiting for a new owner.REMODELED! December 2022. This 3 Bedrooms 2 and half baths home comes with a spacious layout. Upgraded Features Include New granite countertops, backsplash, and new flooring throughout. New Interior garage. New light fixtures. New fencing and interior, fully painted. Located in the Willow Springs Subdivision and convenient to 45, Beltway 8, 249 Airport, Willowbrook Mall area. Great for shopping, entertainment, and restaurants. Close to everything you may want or need. Put this home on your list today!','0.101','11','','','','','Sellers Disclosure','1','','','Aldine Area','Central Electric,Central Gas','1','LT 23 BLK 2 WILLOW SPRINGS SEC 3','Subdivision Lot','4400','Appraisal District','','450','0','','1','Gas Oven','0','','','Gas Range','','Composition','1 - Aldine','CARTER ACADEMY','EISENHOWER HIGH SCHOOL','SHOTWELL MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Left Side,Vacant/Unoccupied','Appraisal District','2','Contemporary/Modern','Willow Spgs Sec 03','5317','3.4553','Public Sewer,Public Water,Water District','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','215823830','1675096948','215823830','2022-12-29T08:32:57.453','2735395','Chad Sellers','Texas Property Shop','','','29.556099','-95.525329','5','77459','5','495000.00','Active','Timber Creek','4407','Court','Missouri City','3','1','5','3809','Single-Family','Beautiful 3,809 sq ft, 5 bedroom 3 1/2 bath home on a cul-de-sac lot! Inground pool & spa. Master bath has double vanity and separate shower. Large family room and gameroom. Well maintained landscaping, full sprinkler system. If occupied property, inspections not available - sold as-is. No For Sale sign. Contact with occupants is prohibited.','0.2297','38','','','','','No Disclosures','','','2','Missouri City Area','Central Gas','1','CRESCENT OAK VILLAGE AT LAKE OLYMPIA SEC 2, BLOCK 2, LOT 39','Cul-De-Sac','10004','Appraisal District','','922','0','','2','','1','In Ground','','','','Composition','19 - Fort Bend','PALMER ELEMENTARY SCHOOL (FORT BEND)','ELKINS HIGH SCHOOL','LAKE OLYMPIA MIDDLE SCHOOL','Temporarily No Showings','Appraisal District','2','Traditional','Crescent Oak Village At Lake Olympia','14179','2.79','Public Sewer','1996','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','215852025','1675096948','215852025','2022-12-29T08:58:28.100','24869685','Crystal Atkinson','A Action Realty','','','30.716528','-95.069961','23','77351','1','125900.00','Active','Bracken Ridge','919','','Livingston','2','0','1','','Single-Family','Perfect weekender getaway or snowbird escape! All you need is your suitcase and a boat. Two shady, wonderful lots make up this property that features a covered 32\' 2006 Sandpiper RV. Every detail of this fisherman\'s paradise/weekender\'s retreat or relocate has been done for you. Hook up the boat, grab your rod & reel and we will see you at Lake Livingston. This incredible opportunity includes improved parking and driveway. 1 (360 sf) storage Conex and 1 (120 sf) Conex, both painted to match the properties clean organized motif. Extraordinary bonus!!! A 180 sf laundry, kitchen and shower cabin is also custom built on the property. All the wilderness and peace with none of the roughing it. Clean & Serene. All necessary utilities are here, active and utilized. Final buyer notes: This property is located in the Lake Livingston Village POA giving you boat ramp access to Lake Livingston! This community also features 3 swimming pools, a pavilion and a playground.','','44','','','','','Sellers Disclosure','','','','Lake Livingston Area','Central Electric,Window Unit','1','Lake Livingston Village Section 11 Lots 48 & 49','Cleared','','','','24','0','','0','','0','','','','','Aluminum,Other','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Appointment Required','','1','Other Style','Lake Livingston Village','386','1.742','Public Sewer,Public Water','2006','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','215858418','1675096948','215858418','2022-12-29T08:09:48.987','61503311','Khai Tran','Martha Turner Sotheby\'s International Realty','','','29.556844','-95.583005','41','77479','11','570000.00','Active','Fountainbrook','5115','Lane','Sugar Land','3','1','4','3353','Single-Family','A welcoming two story home cleverly designed by Ashton Woods Homes. Situated in a Master Planned Community of Crossing Cove at Riverstone. Featuring: 4 spacious bedrooms, 3 1/2 bathrooms, private home office/study, gameroom overlooking the foyer, gourmet kitchen is complete with a spectacular island breakfast bar, high ceilings, lots natural light, 2 car swing garage, ample back yard. Just a short drive to shopping, dining and entertainment. We hope you love it!','0.2041','29','Ashton Woods','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Sugar Land South','Central Gas','1','CROSSING COVE AT RIVERSTONE SEC 1, BLOCK 2, LOT 8','Subdivision Lot','8893','Appraisal District','','1080','0','','2','Single Oven','0','','','Gas Range','','Composition','19 - Fort Bend','SETTLERS WAY ELEMENTARY SCHOOL','ELKINS HIGH SCHOOL','FIRST COLONY MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Riverstone','10935','2.3554','Public Sewer,Public Water,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','215908317','1675096948','215908317','2022-12-29T08:23:07.527','78390331','Abby Todd','Gann Medford Real Estate','','','31.389792','-94.767500','29','75904','3','249900.00','Active','Pebble Creek','110','Street','Lufkin','2','0','3','1849','Single-Family','Basically BRAND NEW... Home has been COMPLETELY remodeled from top to bottom! Brand new roof (and roof decking), interior and exterior doors, double pane windows, HVAC, electrical, plumbing, kitchen cabinets, flooring, appliances, garage door, interior walls, insulation... MUST SEE, make your appointment today!','0.5739','45','','','','','Sellers Disclosure','1','','','Angelina County','Central Electric','0','4480 IDLEWOOD BLK 4 LOT 18','Subdivision Lot','25000','Appraisal District','','','0','','2','','0','','','Electric Range','','Composition','267 - Central','CENTRAL ELEMENTARY SCHOOL (CENTRAL)','CENTRAL HIGH SCHOOL (CENTRAL)','CENTRAL JUNIOR HIGH SCHOOL (CENTRAL)','Appointment Required','Appraisal District','1','Traditional','Idlewood','2836','1.6994','Public Sewer,Public Water','1977','Appraisal District'); --> New record created successfully