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-11-07T06:58:26.843' ,`MLSNumber` = '34701495' ,`ListAgentFullName` = 'Traci Crawford' ,`ListOfficeName` = 'Origen Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.227223' ,`Longitude` = '-94.740275' ,`PhotoCount` = '49' ,`PostalCode` = '77575' ,`RoomCount` = '3' ,`ListPrice` = '565000.00' ,`Status` = 'Active' ,`StreetName` = 'Highway 146' ,`StreetNumber` = '15822' ,`StreetSuffix` = '' ,`City` = 'Liberty' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom 2 bath home is surrounded by 20 acres and is ready for new owners. Inside you will find updated luxury vinyl, new carpet, and fresh paint. Open living room and kitchen make it great for entertaining. Outside is a 3-car detached carport, barn with storage and ready for your horses! Enjoy evenings in the country watching the birds and taking in the fresh air! Call to schedule your showing today!' ,`Acres` = '20' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '000058 JAS KNIGHT, TRACT 199 212, ACRES 20.0' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '871200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '107 - Hardin' ,`SchoolElementary` = 'HARDIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jas Knight' ,`TaxAmount` = '6785' ,`TaxRate` = '1.8773' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835684' WHERE `Matrix_Unique_ID` = '208133063' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T06:13:45.593' ,`MLSNumber` = '75566991' ,`ListAgentFullName` = 'Diane Driscoll' ,`ListOfficeName` = 'Rock Edwards & Associates,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.639598' ,`Longitude` = '-95.488929' ,`PhotoCount` = '25' ,`PostalCode` = '77035' ,`RoomCount` = '9' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Southminster' ,`StreetNumber` = '5803' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1814' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'YOUR NEXT HOME AWAITS! 3/2/2 on CORNER LOT in Westbury South. NO CARPET anywhere! Kitchen has GLASS TOP COOKTOP, DOUBLE-OVEN, GRANITE COUNTERTOPS, SOFT-CLOSE DRAWERS & CABINETS and a WALK-IN-PANTRY! EXTRA-WIDE DOORS (most wheelchairs will fit). There is a STUDY/OFFICE/CRAFT ROOM/FLEX ROOM up front. DECKED ATTIC in house and garage. OVERSIZED GARAGE for plenty of storage space! FENCED BACKYARD has MATURE SHADE TREES on the South and a spacious patio. EASY ACCESS TO TEXAS MEDICAL CENTER! HAVE YOUR AGENT SCHEDULE A SHOWING TODAY! CHOICE HOME PROTECTION PLAN INCLUDED THROUGH 7-1-2025!!' ,`Acres` = '0.1846' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'E 67 FT OF LT 15 BLK 141 WESTBURY SOUTH' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Westbury South' ,`TaxAmount` = '4814' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835685' WHERE `Matrix_Unique_ID` = '210700806' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T06:27:13.977' ,`MLSNumber` = '46408798' ,`ListAgentFullName` = 'Melissa Galloway' ,`ListOfficeName` = 'Hite Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.401791' ,`Longitude` = '-95.549895' ,`PhotoCount` = '25' ,`PostalCode` = '77318' ,`RoomCount` = '8' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Natalia' ,`StreetNumber` = '11417' ,`StreetSuffix` = 'Lane' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1802' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MUST SEE gorgeous single story 4/2/2 home in the community of Clear View Estates in Willis, TX! NO CARPET & MOVE IN READY! Energy efficient and features a brick and stone exterior, art niches in entry, large living open to kitchen, pretty white cabinets, GRANITE counter tops, gas cooktop, high ceilings, recessed lighting, ceiling fans and lots of natural light throughout. Luxury vinyl plank flooring throughout!! Large master bedroom with tray ceiling, large ensuite bath, separate tiled shower and soaking tub plus a large walk-in closet with built in shelving. Enjoy the back yard that also includes a covered back patio! FANTASTIC LOCATION! Nearby attractions include Lake Conroe, Sam Houston National Forest, Margaritaville Lake Resort and The Woodlands Mall! NEW HEB set to open up in Wills too! Zoned to the growing Willis ISD! LOW TAX RATE & HOA and convenient access to I-45! Schedule your showing today!' ,`Acres` = '0.1386' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S343400 - CLEAR VIEW ESTATES, BLOCK 5, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6038' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear View Estates' ,`TaxAmount` = '911' ,`TaxRate` = '2.5148' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835685' WHERE `Matrix_Unique_ID` = '212180042' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T06:46:43.083' ,`MLSNumber` = '45363649' ,`ListAgentFullName` = 'M. Carmen Fujimoto' ,`ListOfficeName` = 'Maddie Lowe Properties' ,`SellingAgentFullName` = 'Kara DiCarlo' ,`SellingOfficeName` = 'Texas Local Realty, LLC' ,`Latitude` = '29.896882' ,`Longitude` = '-95.659143' ,`PhotoCount` = '29' ,`PostalCode` = '77095' ,`RoomCount` = '8' ,`ListPrice` = '287000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Salinas' ,`StreetNumber` = '16310' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2316' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two Story Home with 4 bedrooms and 2.5 bathrooms with Gutters, Sprinklers, Covered Back Patio, Granite Counters in the kitchen with under-mount sink, fireplace, Granite in Secondary bathroom and Powder Room. The Primary Bedroom is on 1st Floor and all Secondary Bedrooms on 2nd floor. This home is conveniently located near Highways, Restaurants, Shopping and more!! Community Pool, Playground and Tennis Courts are near by!' ,`Acres` = '0.1305' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 4 WHEATSTONE VLG CLOVERFIELD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5685' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LOWERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wheatstone Village' ,`TaxAmount` = '5931' ,`TaxRate` = '2.881' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835685' WHERE `Matrix_Unique_ID` = '212210390' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T06:53:58.250' ,`MLSNumber` = '70029640' ,`ListAgentFullName` = 'Martha Cornejo' ,`ListOfficeName` = 'RE/MAX Real Estate Assoc.' ,`SellingAgentFullName` = 'Lucas Frank' ,`SellingOfficeName` = 'Keller Williams Metropolitan' ,`Latitude` = '29.613472' ,`Longitude` = '-95.723586' ,`PhotoCount` = '43' ,`PostalCode` = '77406' ,`RoomCount` = '9' ,`ListPrice` = '339000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Woven Wood' ,`StreetNumber` = '2423' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2004' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOOK NO MORE - YOU HAVE FOUND IT! The house of your dreams waiting on the perfect subdivision of The Grove part of the after sought community of Pecan Grove. Walk onto a newly designed floor plan. Entering this gorgeous home you will find a fourth room to your right that can also be your study room, and to your left you will find a spacious private utility room that allows you access to the garage. Continue walking onto the amazing kitchen with brand new quartz counter tops with touchless water faucet and soft close kitchen cabinets. Don\'t miss the newly added pantry room. Stare all you want to the polish porcelain fireplace. On the master bedroom gawk at the texture porcelain tile accent wall - you will definitely love it! Make sure you don\'t miss the massive master walk in closet and the beautifully renovated bathroom with the sliding frameless shower door. Waterproof and scratch resistant laminate floors. This home will not disappoint! Call for your private tour today.' ,`Acres` = '0.1622' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE GROVE SEC 3, BLOCK 16, LOT 51' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '7066' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '195' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'The Grove Sec 3' ,`TaxAmount` = '4957' ,`TaxRate` = '2.3298' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835685' WHERE `Matrix_Unique_ID` = '212488786' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T06:39:12.257' ,`MLSNumber` = '14981328' ,`ListAgentFullName` = 'Rene Sorola' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.130166' ,`Longitude` = '-95.544894' ,`PhotoCount` = '48' ,`PostalCode` = '77389' ,`RoomCount` = '11' ,`ListPrice` = '837500.00' ,`Status` = 'Active' ,`StreetName` = 'Fawn Point' ,`StreetNumber` = '25306' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4873' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom magnificent stone and stucco home located on appx 1/2 acre in cul-de-sac. Very limited through traffic. Lakeview w/fountains 5+ bedrooms; walking distance to Augusta Pines Country Club. Short distance to world-class restaurants, shopping, and entertainment. 3 car garage; 11 rooms; fabulous open floor plan and breathtaking millwork w custom windows+ views! Versatile 2 bedrooms down! 2 lighted stairways. Two gas fireplaces. Open floorplan with grand entry, winding stairway and wrought iron spindles on stairway & balcony. Wet Bar. Granite Countertops. Master with large walk-in closet and built-ins. Each bedroom has its own walk-in closet. Large game room up. Study and formals. Automatic sprinkler system. Generac generator installed 2022; new roof 2021; three new HVAC units 2018, 2019, and 2021. Tankless water heater installed 2019. Solar Screens. 3 Nest Thermostats.' ,`Acres` = '0.4512' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 PRESERVE SEC 1 AMEND' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View' ,`LotSize` = '19656' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'METZLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Preserve Sec 01 Amd' ,`TaxAmount` = '11387' ,`TaxRate` = '2.834' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835685' WHERE `Matrix_Unique_ID` = '212881297' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T05:32:31.643' ,`MLSNumber` = '32358178' ,`ListAgentFullName` = 'Jennifer Sheridan' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.037854' ,`Longitude` = '-95.222265' ,`PhotoCount` = '24' ,`PostalCode` = '77339' ,`RoomCount` = '7' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Southern Pines Ct' ,`StreetNumber` = '1502' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2658' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A diamond in the rough. This grand home offers generous space for everyone and is ready for you to make it yours. Original owners have maintained the home very well. 4 bedrooms with a study. The study can be transformed into a 5th bedroom (downstairs) and has a full bathroom adjacent, making this ideal for a guest suite. On a Cul de sac, a quick walk or bike ride to nearby parks, schools, duck ponds, boat launch and fishing pier.' ,`Acres` = '0.1974' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 29 TRAILWOOD VILLAGE SEC 4' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FOSTER ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Left Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Trailwood Village' ,`TaxAmount` = '5987' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835686' WHERE `Matrix_Unique_ID` = '212919302' --> 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','213202053','1667835686','213202053','2022-11-07T06:52:38.753','37599399','Christine Lorentz','PRG, Realtors','','','30.114295','-95.405306','31','77386','8','314900.00','Active','July Sky Court','2418','','Spring','2','1','4','2361','Single-Family','Welcome to this gorgeous, well kept neighborhood! Terrific 4 bedroom and 2.5 bath home with a 2 car garage on a quiet cul- da-sac. Enjoy preparing meals in this impressive kitchen equipped with newer appliances, ample cabinets and generous counter space. Entertaining is a breeze with this great floor plan complete with a cozy fireplace. Primary bathroom features a separate tub and shower and dual sinks. Bedrooms offer new plush carpet, paint, ceiling fans, and sizable closets. This four bedroom home offers 3 bedrooms on the second floor and one bedroom currently used as a study, on the first floor., Relax with your favorite drink in the fenced in backyard with a patio, lush grass and a pomegranate tree. There is an open lot across the street that currently cannot be built on which makes it feel so open! Garage has an upstairs attic for extra storage. Make this beautiful home yours today.','','15','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Spring Northeast','Central Electric','1','FOREST VILLAGE 02, BLOCK 1, LOT 20','Cul-De-Sac,Subdivision Lot','4729','Appraisal District','','424','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','FORD ELEMENTARY SCHOOL (CONROE)','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Supra Keybox','Appraisal District','2','Traditional','Forest Village','','','Water District','2009','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T05:15:59.373' ,`MLSNumber` = '51287664' ,`ListAgentFullName` = 'Rosalinda Swartz' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.050733' ,`Longitude` = '-95.384707' ,`PhotoCount` = '21' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '187000.00' ,`Status` = 'Active' ,`StreetName` = 'Tree House' ,`StreetNumber` = '23347' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1025' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is it! Move-in ready single-story home LOADED w/ upgrades in the popular Cypress Trails community offering a gated pool, & quick access to I-45, Grand Parkway and Hardy. This home\'s curb appeal begins w/ the oversize corner lot, & a cozy covered front porch. The upgrades to this home include new: water heater, exterior sliding door, garage door/door opener, sheetrock, trim, doors, blinds, ceiling fans light fixtures, & 2 new toilets. Once inside you are welcomed by an open-concept layout featuring high ceilings, neutral paint tones, laminate flooring, & plenty of natural light. The spacious living room offers a brick fireplace & leads into the dining area & the updated kitchen w/ a new stove, ample cabinet storage, & a pantry. A large primary bedroom w/ sliding door access to the backyard, 1 well-sized secondary bedroom with newly built closet, & a full bath completes this home. Don\'t forget to check out the NEWLY decked backyard that\'s perfect for entertaining.' ,`Acres` = '0.0685' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TR 31A BLK 8 CYPRESS TRAILS OF TIMBERLANE 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '2986' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Trails Timberlane' ,`TaxAmount` = '3534' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835686' WHERE `Matrix_Unique_ID` = '213594808' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T06:14:51.237' ,`MLSNumber` = '58498880' ,`ListAgentFullName` = 'Jennifer Duhe' ,`ListOfficeName` = 'Bailes Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.050526' ,`Longitude` = '-95.445140' ,`PhotoCount` = '31' ,`PostalCode` = '77566' ,`RoomCount` = '4' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak' ,`StreetNumber` = '163' ,`StreetSuffix` = 'Drive' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1336' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this Mid-Century charmer that has been lovingly updated and is waiting for you to call home. Located in the heart of Lake Jackson it\'s an easy commute to nearby cities. This home still has some of the original touches such as the hardwood that flows through out the living room and bedrooms. This spacious four-bedroom home has had a new large bathroom and walk in closet located in the primary bedroom. Some of the recent updates include roof march of 2022, fresh paint inside and out, light fixtures, pex pipe, ceiling fans, kitchen appliances, new counter, backsplash, sink and more. Make your appointment today to tour this home.' ,`Acres` = '0.2571' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AREA B-C-D-E-G-H-J-K-L ETC (LAKE JACKSON) BLK 5 LOT 3 AREA E' ,`LotDesciption` = 'Cleared' ,`LotSize` = '11199' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BRANNEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Area B-C-D-E-G-H-J-K-L Etc La' ,`TaxAmount` = '4547' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835686' WHERE `Matrix_Unique_ID` = '213617766' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T06:38:59.857' ,`MLSNumber` = '54383381' ,`ListAgentFullName` = 'Leslie McMurrey' ,`ListOfficeName` = 'Red Door Realty & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.008820' ,`Longitude` = '-95.169679' ,`PhotoCount` = '37' ,`PostalCode` = '77346' ,`RoomCount` = '9' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'January' ,`StreetNumber` = '19815' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2718' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming home in the desirable Pinehurst of Atascocita. Spacious main living area with gas fireplace and loads of windows letting in all the natural light. Large kitchen with walk-in pantry, breakfast area, and spacious laundry room. Office/formal dining and primary bedroom complete the first floor. Upstairs includes 3 bedrooms, full bath and storage galore! Large gameroom overlooking 2nd floor deck and backyard. NO BACK NEIGHBORS!!' ,`Acres` = '0.2204' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 23 PINEHURST OF ATASCOCITA SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinehurst Atascocita Sec 06' ,`TaxAmount` = '5710' ,`TaxRate` = '2.453' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835686' WHERE `Matrix_Unique_ID` = '213656558' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T06:45:27.397' ,`MLSNumber` = '16829335' ,`ListAgentFullName` = 'Billie Garza' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.872525' ,`Longitude` = '-95.707170' ,`PhotoCount` = '48' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '405650.00' ,`Status` = 'Active' ,`StreetName` = 'River Rock' ,`StreetNumber` = '19603' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3325' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to this spacious 4-bedroom, 3.5 bath gem! At just over 1/2 an acre, this home sits on one of the largest lots in the subdivision!! As you enter the home you are greeted by high ceilings, a winding staircase and enclosed Home Study/Office that is flooded with natural light. New vinyl plank flooring flows throughout the downstairs living areas, along with New Carpet and Fresh Paint. Kitchen has been updated with New Countertops and appliances; New Dishwasher (2020), Range (2020), BRAND NEW microwave (2022), AND refrigerator (2022). Massive Game Room area upstairs is surrounded by remaining 3 bedrooms. Each room offers large walk-in closets, new carpet and fresh paint. Other updates, and upgrades, include NEW HVAC (2020), Tankless Water Heater (2021), and BRAND-NEW fencing enclosing the backyard. Home also offers an Oversized 3 car garage, and extended driveway for additional parking. Come see me today!' ,`Acres` = '0.564' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 14 ESTATES OF HIGHLAND CREEK' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '24570' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '540' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'DURYEA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates Highland Creek' ,`TaxAmount` = '6762' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835687' WHERE `Matrix_Unique_ID` = '213910737' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T05:14:31.580' ,`MLSNumber` = '2894931' ,`ListAgentFullName` = 'Rosalinda Swartz' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.303499' ,`Longitude` = '-95.500679' ,`PhotoCount` = '32' ,`PostalCode` = '77304' ,`RoomCount` = '10' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeshore' ,`StreetNumber` = '113' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1724' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful completely renovated home on an oversize & unrestricted lot in a quiet community that offers quick access to The Woodlands and I45. Out front, find a large yard & long driveway surrounded by large shade trees. Once inside, you will notice the attention to detail in every room, from the stylish flooring, LED recessed lighting, fresh paint, & more! The open floorplan allows TONS of natural light to flow throughout the home. The formal living & dining area leads into the ALL NEW kitchen that offers marble-look quartz counters, trendy blue cabinetry, SS appliances, & a utility room w/ extra storage. Next, find the large great room w/double-door access to the backyard. The spacious primary includes private backyard access, dual closets, & a NEW en-suite bath. 2 additional bedrooms w/ walk-in closets share a NEW double sink bath. Lastly, check out the Texas-size back entertaining space featuring a large patio, full fence, & a BIG storage shed/garage.' ,`Acres` = '0.5845' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S218000 - ARTESIAN LAKE ESTATES, BLOCK C, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '25462' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RICE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Artesian Lake Estates' ,`TaxAmount` = '2889' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835687' WHERE `Matrix_Unique_ID` = '213917728' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T06:56:00.223' ,`MLSNumber` = '13732786' ,`ListAgentFullName` = 'Paulina Yakovleva' ,`ListOfficeName` = 'Prime Dwellings LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.861922' ,`Longitude` = '-95.618588' ,`PhotoCount` = '45' ,`PostalCode` = '77041' ,`RoomCount` = '4' ,`ListPrice` = '384900.00' ,`Status` = 'Active' ,`StreetName` = 'Neston' ,`StreetNumber` = '13714' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2913' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated, ready to move-in, two story four bedroom house ideally situated minutes from I-10! Freshly updated finishes throughout with a high ceiling great room and grand foyer entrance. From a fresh paint makeover inside and out to a newly installed 30 year composition shingled roof (2022) and HVAC system (2022). Featuring Luxury Vinyl Plank throughout and quality newly carpeted second floor bedrooms. These are just a few of the many updates so schedule your tour before this one is gone!' ,`Acres` = '0.146' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 CONCORD BRIDGE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LEE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Concord Bridge Sec 05' ,`TaxAmount` = '5750' ,`TaxRate` = '2.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835687' WHERE `Matrix_Unique_ID` = '213918388' --> 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','214033695','1667835687','214033695','2022-11-07T06:48:49.580','77328734','Yeira Baldazo','Amada Agency Real Estate','','','29.932233','-95.063128','36','77532','10','650000.00','Active','Miller Wilson','17619','Road','Crosby','3','0','4','2730','Single-Family','Welcome to a beautiful New Construction home sitting on a little over an acre. Come fall in love with the warming front porch to enjoy the sounds of the outdoor country living. This home features a grand entry way foyer and to the left of the entry way you have a spacious home office/ study area. The living room offers soaring high ceilings with stained wood shelves and a cozy fire place. The kitchen has so much counter space and comes with a massive walk in pantry! The primary suite has his and her sinks and with ample counter space. One of the secondary bedrooms has their own private bathroom. The utility room is extremely spacious with custom built-ins and an additional sink. The oversized garage is a fully finished garage. Come feel the coziness and openness all at the same time in this new home! Take notice the home has exterior brick all around.','1.09','1','Otero & Son','','Electric Dryer Connections,Gas Dryer Connections','','No Disclosures','1','Mock Fireplace','1','Crosby Area','Central Gas','0','LT 4 BLK 1 WHITWORTH CROSBY','Cleared','47480','Appraisal District','','','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','12 - Crosby','CROSBY ELEMENTARY SCHOOL (CROSBY)','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Appointment Required','Builder','1','Traditional','Whitworth Corsby','1492','2.0943','Septic Tank,Well','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T06:42:23.040' ,`MLSNumber` = '12558842' ,`ListAgentFullName` = 'Rene Sorola' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.775393' ,`Longitude` = '-95.548912' ,`PhotoCount` = '45' ,`PostalCode` = '77024' ,`RoomCount` = '9' ,`ListPrice` = '1500000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodthorpe' ,`StreetNumber` = '12435' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3896' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated 4 bedroom home ideally situated on a quiet cu-de-sac in the peaceful Memorial Hollow community. Impressive floor plan includes formal dining, butlers pantry, wine room, and game room with vaulted exposed beam ceiling. Attractive wood flooring and recessed lighting throughout. Spacious living room features a wall of windows allowing in plenty of natural light, full wet bar and stacked stone fireplace. Gourmet kitchen offers granite counters, island with pendant lighting, stainless appliances, and breakfast bar. Relaxing primary suite is complete with tray ceiling, dual sinks, garden tub and separate shower. The whole house is wired for audio, video and security system. The back yard is turfed and perfect for entertaining with 9 hole putting green, extended covered patio, outdoor kitchen, fenced pool (Redone in 2008) and pergola. Additional features include Generac Natural Gas Generator, and central vac. Zoned to exemplary Spring Branch ISD and Memorial High School.' ,`Acres` = '0.3085' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 4 MEMORIAL HOLLOW SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'BUNKER HILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Hollow Sec 01' ,`TaxAmount` = '22763' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835687' WHERE `Matrix_Unique_ID` = '214171030' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T06:26:51.653' ,`MLSNumber` = '59455142' ,`ListAgentFullName` = 'Jormayline Dipre' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.684158' ,`Longitude` = '-95.620389' ,`PhotoCount` = '12' ,`PostalCode` = '77083' ,`RoomCount` = '9' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Tonnochy' ,`StreetNumber` = '13611' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love at first light! This sun-drenched fully upgraded 4 bedroom/2.5 bathroom sits in the perfect location near Bellaire Blvd. From entirely new windows, doors, and floors, this home is ready to be yours. The spacious backyard wraps around two covered patios. The ground level hosts the primary bedroom with an en-suite and an entertainer\'s delight open-concept kitchen and living area. The second floor features 3 additional bedrooms for all of your family and friends. Nothing left to do here... PRICED TO SELL. Come see it today!' ,`Acres` = '0.2571' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 8 OLYMPIA SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '646' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'ALEXANDER ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Olympia' ,`TaxAmount` = '4329' ,`TaxRate` = '2.507' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835687' WHERE `Matrix_Unique_ID` = '214221548' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T05:44:03.640' ,`MLSNumber` = '26349459' ,`ListAgentFullName` = 'Clarissa Woodward' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.374969' ,`Longitude` = '-95.114154' ,`PhotoCount` = '31' ,`PostalCode` = '77517' ,`RoomCount` = '6' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Cherry' ,`StreetNumber` = '4623' ,`StreetSuffix` = 'Street' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1209' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is the property you\'ve been looking for! Set back on two beautiful acres in Santa Fe, this updated 3 bedroom 2 bathroom home features a spacious open concept living area full of character and charm with laminate wood floors. The kitchen has stainless steel appliances, granite counters and plenty of cabinets for all your storage needs, with additional storage built-in to the dining room. The primary bedroom features an updated en-suite and walk-in closet, and all bedrooms have hardwood floors. Enjoy your days out back on the stamped patio, and enjoy country living with a tall glass of crisp well water. This 2 acres is beautifully plotted, and crossed fenced for your convenience. Have you been searching for acreage with convenient access to Hwy 6, Hwy 288, and I45? Schedule your in-person showing today to see all that this home has to offer you.' ,`Acres` = '2' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 611 I & G N RR SUR SEC 17 PT OF LOT B (2-1) BLK 73 ANGE' ,`LotDesciption` = 'Other' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'DAN J KUBACAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Angell-Runge' ,`TaxAmount` = '6549' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835688' WHERE `Matrix_Unique_ID` = '214358908' --> 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','214475011','1667835688','214475011','2022-11-07T06:39:09.730','35374284','Brian Simpson','RE/MAX Elite Properties','','','29.928838','-95.675247','34','77095','8','345000.00','Active','Kiowa River','17110','Lane','Houston','2','0','3','2351','Single-Family','Beautiful one story home that has been freshly painted and updated in October 2022. Features include a grand foyer with high ceilings, large game room that could also be used as an office/living area, hardwood floors in common areas, 42\" cabinets in kitchen, kitchen island, breakfast bar open to living area, plantation shutters in living area, two sinks in primary bath, jetted tub with separate shower, huge walk-in closet, covered back patio, sprinkler system and the list goes on.','0.1584','8','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','Gas Connections','1','Copperfield Area','Central Gas','1','LT 10 BLK 4 RIATA RANCH SEC 4 AMEND','Subdivision Lot','6900','Appraisal District','','844','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','WOODARD ELEMENTARY SCHOOL','CYPRESS RANCH HIGH SCHOOL','SPILLANE MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Riata Ranch Sec 04 Amd','','','Water District','1999','Appraisal District'); --> New record created successfully