Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T08:13:22.253' ,`MLSNumber` = '48640258' ,`ListAgentFullName` = 'Jennifer Hernandez' ,`ListOfficeName` = 'Powers Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.997568' ,`Longitude` = '-96.652482' ,`PhotoCount` = '18' ,`PostalCode` = '77957' ,`RoomCount` = '6' ,`ListPrice` = '170000.00' ,`Status` = 'Active' ,`StreetName` = 'State Highway 111' ,`StreetNumber` = '449' ,`StreetSuffix` = '' ,`City` = 'Edna' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1584' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 bedroom 2 bath home in Edna. Ready for you to make it your own with completion of unfinished projects. Home is near businesses, shops, and Hwy 59.' ,`Acres` = '0.34' ,`Area` = '67' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A5072 SMITH, HENRY, TRACT -100X150FT-, ACRES 0.34' ,`LotDesciption` = 'Other' ,`LotSize` = '14810' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '246 - Edna' ,`SchoolElementary` = 'EDNA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'EDNA HIGH SCHOOL' ,`SchoolMiddle` = 'EDNA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'NA' ,`TaxAmount` = '1446' ,`TaxRate` = '1.8589' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675100973' WHERE `Matrix_Unique_ID` = '207493195' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T08:24:22.847' ,`MLSNumber` = '38737266' ,`ListAgentFullName` = 'Mark Lovfald' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.540061' ,`Longitude` = '-95.084386' ,`PhotoCount` = '44' ,`PostalCode` = '77058' ,`RoomCount` = '12' ,`ListPrice` = '1950000.00' ,`Status` = 'Active' ,`StreetName` = 'BACK BAY COURT' ,`StreetNumber` = '2014' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '5119' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME TO THIS ONE OF A KIND CUSTOM WATERFRONT ESTATE WITH ALL THE EXQUISITE MODERN TOUCHES! THIS STATELY 5000+ SQ FT HOME BOASTS AN INVITING GRAND ENTRY*ELEGANT CURVED STAIRCASE LEADING UPSTAIRS TO AN OVERSIZED MEDIA ROOM AND/OR HOME OFFICE*LIGHT & BRIGHT OVERSIZED LIVING AREA W/COFFERED CEILINGS*NEW EXTENSIVE MARBLE FLOORING*PICTURESQUE WALL OF WINDOWS THROUGHOUT OFFERING PANORAMIC VIEWS OF THE WATERFRONT*ANY CHEF WOULD BE AMAZED BY THE ISLAND KITCHEN W/COMMERCIAL STYLE GAS RANGE & WET BAR*2 FIREPLACES*AMAZING PRIMARY BEDROOM W/ACCESS TO COVERED PATIO*LUXURIOUS SPA-LIKE PRIMARY BATHROOM W/MASSIVE WALK IN*HALL LIBRARY WITH BEAUTIFUL BUILT INS*BREATHTAKING WATERVIEWS FROM ABOUT ALL THE ROOMS*TROPICAL LANDSCAPING & RELAXING SALTWATER POOL*LARGE COVERED PALAPA & SUMMER KITCHEN*COVERED BOAT HOUSE W/UPSTAIRS SUN DECK*LOCATED AT THE END OF A QUIET CUL DE SAC IN VERY POPULAR NASSAU BAY. EASY ACCESS TO THE BAY/GULF BY BOAT*THIS IS SIMPLY THE ULTIMATE IN LUXURY LIVING & ENTERTAINING!' ,`Acres` = '0.4648' ,`Area` = '7' ,`BuilderName` = 'CUSTOM BLT.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 32 NASSAU BAY SEC 8' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '20245' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '210' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NASSAU BAY' ,`TaxAmount` = '24882' ,`TaxRate` = '2.4882' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675100973' WHERE `Matrix_Unique_ID` = '210693682' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T08:23:50.150' ,`MLSNumber` = '60933717' ,`ListAgentFullName` = 'Mark Lovfald' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.412494' ,`Longitude` = '-95.087351' ,`PhotoCount` = '49' ,`PostalCode` = '77510' ,`RoomCount` = '18' ,`ListPrice` = '895000.00' ,`Status` = 'Active' ,`StreetName` = 'AVENUE L' ,`StreetNumber` = '1910' ,`StreetSuffix` = '' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MAJOR REDUCTION! WELCOME TO THIS GORGEOUS 4/2.5 CUSTOM COLONIAL ESTATE W/ 3/1 GUEST QUARTERS SITUATED ON 3.5 PLUS UNRESTRICTED ACRES. ONCE YOU ENTER THROUGH THE AUTOMATIC GATE, YOU WILL NOT WANT TO LEAVE! FEATURES INCLUDE DRAMATIC TWO STORY LIVING AREA W/ELEGANT WOOD FLOORS AND BUILT-IN ENTERTAINMENT CABINET*LOTS OF NATURAL LIGHT*SITTING AREA W/CORNER BRICK WBFP & BUILT-IN WINE CABINET*YOUR CHEF WILL FALL IN LOVE THIS ISLAND KITCHEN W/STACKED STONE BACKSPLASH/GRANITE COUNTERS*LOADS OF COUNTER AND CABINET SPACE*RELAX IN THE TILED REAR SUNROOM*IMPRESSIVE PRIMARY SUITE DOWN*SPACIOUS SECONDARY BEDROOMS W/BUILT-INS*WATCH YOUR FAVORITE MOVIES IN THE GAME ROOM W/ACCESS TO UPSTAIRS BACKYARD BALCONY*5 CAR GARAGE W/COVERED PARKING FOR THE CAR COLLECTORS*ENTERTAIN WITH EASE WITH THIS TROPICAL BACKYARD OASIS W/POOL & AMAZING PALAPA*PLAY BALL IN YOUR PERSONAL BASEBALL FIELD TOO! TAKE A SHORT WALK TO THE GUEST QUARTERS OR HOME OFFICE*FISH IN YOUR OWN POND W/PIER*EZ ACESS TO MAJOR ROADS*' ,`Acres` = '2.65' ,`Area` = '33' ,`BuilderName` = 'R.C. HANKAMER' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 1 PT OF LOT 78 (78-6) THAMANS 1ST SUB' ,`LotDesciption` = 'Wooded' ,`LotSize` = '115434' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'WILLIAM F BARNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Colonial,Traditional' ,`Subdivision` = 'Thamans 1st Sub' ,`TaxAmount` = '12741' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675100973' WHERE `Matrix_Unique_ID` = '211625523' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T08:57:55.643' ,`MLSNumber` = '51394514' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.970958' ,`Longitude` = '-95.976852' ,`PhotoCount` = '17' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '139999.00' ,`Status` = 'Active' ,`StreetName` = 'Moore' ,`StreetNumber` = '3212' ,`StreetSuffix` = 'Avenue' ,`City` = 'Bay City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction ready for move-in immediately - This one-story plan with 3 bedrooms, 2 bath, one-story home is energy efficient, with an open concept kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting and vinyl plank flooring, and carpet in all bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home with espresso cabinetry. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\nFantastic Builder \'1-2-10\' Warranty' ,`Acres` = '0.1607' ,`Area` = '54' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 7' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Morton-Corbett' ,`TaxAmount` = '1748' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675100973' WHERE `Matrix_Unique_ID` = '212986583' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T08:32:08.820' ,`MLSNumber` = '98409135' ,`ListAgentFullName` = 'Kate Johnson' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.828021' ,`Longitude` = '-95.138929' ,`PhotoCount` = '39' ,`PostalCode` = '77360' ,`RoomCount` = '7' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Cattle' ,`StreetNumber` = '485' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2516' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous 2 bedroom, 2 ½ bath home, on over an acre, with amazing water views and easy access to Lake Livingston. Originally designed as a 3 bedroom, the sole owner opted for an oversized master suite and used the enclosed sunroom as a second bedroom. Impeccably maintained, this home boasts an elegant entryway, study, large living room with built ins and a cozy fireplace; a large kitchen with lots of natural light and lake view. The crowning glory is the 3-bay detached garage with climate control, workshop, finished floor, elaborate man cave with a ½ bath and built in bookcases. Plenty of room to park your boat, ATV, and additional vehicles inside and room on the slab for an RV outside. This is a smart home with 2 large backup generators, security system for both buildings, tankless water heater, aerobic septic system. With the original blueprint included, the home can convert to a 3 or 4 bedroom without changing any of the exterior walls and is just waiting for your personal updates!' ,`Acres` = '1.0758' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TEXAS ACRES SECTION 2 BLK 11 LOT 14, 15, 16, 50, 51 & 52' ,`LotDesciption` = 'Water View' ,`LotSize` = '46860' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Texas Acres Sec 2' ,`TaxAmount` = '7042' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675100974' WHERE `Matrix_Unique_ID` = '213795886' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T07:43:20.863' ,`MLSNumber` = '97705203' ,`ListAgentFullName` = 'Judith Lisac' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.286841' ,`Longitude` = '-94.828935' ,`PhotoCount` = '42' ,`PostalCode` = '77551' ,`RoomCount` = '8' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = '56th' ,`StreetNumber` = '1315' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1337' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming, thoughtfully maintained 3 bedroom, 2 bath Galveston home is ready for you to make your own! The spacious formal living with a large window warmly welcomes you home. Your ideal kitchen provides built-in appliances and ample prep and storage space. The bright dining room opens to the kitchen and has access to the backyard for easy outdoor entertaining. The primary bedroom features an en-suite bathroom. The 3rd bedroom can easily be used as a comfortable home office or cozy den. You\'ll appreciate the large backyard with a patio! Don\'t miss your opportunity to turn this blank canvas into your dream home! 3D tour is available online.' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR N 60 FT OF LOTS 13 THRU 16 (13-1) BL' ,`LotDesciption` = 'Other' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`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` = 'Denver Resurvey' ,`TaxAmount` = '5901' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675100974' WHERE `Matrix_Unique_ID` = '213896049' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T07:07:07.067' ,`MLSNumber` = '44891527' ,`ListAgentFullName` = 'Richard Elkowitz' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.622448' ,`Longitude` = '-95.773766' ,`PhotoCount` = '50' ,`PostalCode` = '77406' ,`RoomCount` = '10' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Shadow' ,`StreetNumber` = '2015' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2712' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Living in the country, but close to everything. Absolutely stunning updated interior design situated on 1.859 unrestricted acres. Oh. The home has two primary bedrooms with gorgeous private bathrooms. First class stuff. The interior has been totally updated down to the framing studs. Flooring, kitchen, bathrooms, walls, roof, underground plumbing; interior plumbing updates; cement board siding and more. The beauty will knock your socks off. The home was just measured by an appraiser at 2,712 square feet. NO HOA fees. NO MUD taxes. Gas lines have been installed in the attic for future use if desired. Want to build towards the back of the property someday? Electrical lines already in place for future construction. Water softer system. No carpet. Mostly ceramic Italian tile. Slow close drawers and cabinets. Quartz counters. Home has not been lived in since updated. Extra room is off the primary bedroom. Makes a great study, or exercise room.' ,`Acres` = '1.86' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '0046 KNIGHT AND WHITE, TRACT 119, ACRES 1.86, LOT 5 PECAN S' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '81022' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Knight & White' ,`TaxAmount` = '5461' ,`TaxRate` = '1.6948' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675100974' WHERE `Matrix_Unique_ID` = '214011314' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T08:54:21.313' ,`MLSNumber` = '29539565' ,`ListAgentFullName` = 'Charmayne Lacewell' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.544570' ,`Longitude` = '-95.487534' ,`PhotoCount` = '30' ,`PostalCode` = '77545' ,`RoomCount` = '10' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Feather Green' ,`StreetNumber` = '2803' ,`StreetSuffix` = 'Trail' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2282' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained home looking for a new owner. Wood like tile located throughout first floor. Home features both formals, spacious den w/ceiling fan & plenty of lighting. Study/ library that can be used as a 4th bedroom if needed. Grand island in kitchen with a breakfast bar. Loads of storage. All bedrooms located on second floor. Large primary bedroom with walk in closet and double sinks. Natural light flows throughout the space. Nice size secondary rooms. Great backyard space with no back neighbors. Service panel upgraded in preparation for solar panels. Easy commute to Amazon facility, Medical Center and Downtown. Close proximity to shopping in Sugar Land and Pearland.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WINFIELD LAKES SEC 6, BLOCK 6, LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4904' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '515' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PARKS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Winfield Lakes' ,`TaxAmount` = '4455' ,`TaxRate` = '2.4829' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675100974' WHERE `Matrix_Unique_ID` = '214410249' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T07:32:11.470' ,`MLSNumber` = '20973750' ,`ListAgentFullName` = 'Garrett Mohnke' ,`ListOfficeName` = 'Complete Property Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.174923' ,`Longitude` = '-95.417470' ,`PhotoCount` = '17' ,`PostalCode` = '77515' ,`RoomCount` = '3' ,`ListPrice` = '149000.00' ,`Status` = 'Active' ,`StreetName` = 'Chevy Chase' ,`StreetNumber` = '1232' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated 3 bedroom 2 bath home with wood floors in the living area and bedrooms, tile flooring and granite counters in the kitchen.' ,`Acres` = '0.1822' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CHEVY CHASE #1 (ANGLETON) BLK 2 LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7937' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chevy Chase #1 Angleton' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675100975' WHERE `Matrix_Unique_ID` = '214607439' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T08:29:03.123' ,`MLSNumber` = '90861977' ,`ListAgentFullName` = 'Crystal Mason' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.860802' ,`Longitude` = '-95.422626' ,`PhotoCount` = '22' ,`PostalCode` = '77091' ,`RoomCount` = '3' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Knox' ,`StreetNumber` = '6728' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1760' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom, 2-1/2 bathroom two story home with modern brushed nickel finishes throughout. Living and kitchen areas join to be able to provide an open layout. Sizable windows provide a nice touch of natural lighting and view of relaxing back porch and nice sized backyard. Configured to have first floor living and sleeping quarters on the secondary level. All bedrooms have walk in closets w/shelving… the primary bedroom has two spacious walk in closets! Conveniently located minutes from downtown Houston and has major highway access. Inquire about reserving your new home today!' ,`Acres` = '0.1377' ,`Area` = '9' ,`BuilderName` = 'Kensli Homes LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 25 HIGHLAND HEIGHTS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WESLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Heights' ,`TaxAmount` = '1154' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675100975' WHERE `Matrix_Unique_ID` = '214684787' --> 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','215469640','1675100975','215469640','2023-01-03T08:13:22.550','51335265','Jennifer Hernandez','Powers Real Estate','','','29.307295','-96.095998','9','77488','2','60000.00','Active','Elm','518','Street','Wharton','1','0','2','1120','Single-Family','This is a small 2 bedroom 1 bath home. Great for investors! Almost .25 acres in Wharton City Limits not too far from downtown Wharton Square. Seller will close in Wharton Texas. Please call Jennifer Hernandez for appointment, or call your agent to see the property, as tenants are still living in the home, as well as dogs on the property. Home will need complete renovation. Showings are only available on Wednesdays and Thursdays.','0.2494','55','','','','','Sellers Disclosure,Tenant Occupied','','','','','Other Heating','0','WHARTON BLOCK 59 LOT 2','Other','10864','Appraisal District','','','0','','0','','0','','','','','Tile','180 - Wharton','CG SIVELLS/WHARTON ELEMENTARY SCHOOL','WHARTON HIGH SCHOOL','WHARTON JUNIOR HIGH','Accompany,Appointment Required,Lockbox Front','Appraisal District','1','Other Style','Wharton','1006','2.3512','Public Sewer,Public Water','1940','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','215536758','1675100975','215536758','2023-01-03T07:26:17.283','54441615','Clinton Omiwade','ERA Legacy Living','','','29.871519','-95.476833','9','77088','3','214000.00','Active','Darkwood','5926','Drive','Houston','2','0','3','1704','Single-Family','TLC Needed! This is an Investor Special and a flippers dream. The property needs the right investor ! 3 bedroom 2 bathroom with cosmetic repair needed . Come take a look asap . This gem will not last long . ','0.1928','11','','','','','Sellers Disclosure','','','1','Northwest Houston','Other Heating','0','LT 15 BLK 2 INWOOD FOREST SEC 3','Subdivision Lot','8400','Appraisal District','','','0','','1','','0','','','','','Composition','1 - Aldine','SMITH ACADEMY','EISENHOWER HIGH SCHOOL','HOFFMAN MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Ranch','Inwood Forest Sec 03','5505','2.5119','Public Sewer,Public Water','1969','Appraisal District'); --> New record created successfully