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-24T21:13:12.350' ,`MLSNumber` = '27890834' ,`ListAgentFullName` = 'Lois De Armas' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Karina Mazariegos' ,`SellingOfficeName` = 'Greater Houston REP, Inc.' ,`Latitude` = '28.993411' ,`Longitude` = '-95.235442' ,`PhotoCount` = '50' ,`PostalCode` = '77541' ,`RoomCount` = '4' ,`ListPrice` = '430000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Blue Water' ,`StreetNumber` = '4407' ,`StreetSuffix` = 'Highway' ,`City` = 'Freeport' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '779' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TRIPLE Investment Opportunity! Well-maintained beach house includes lots on each side! 22,500sf total for all 3 lots. Enjoy panoramic views of ocean & Drum Bay from decked balconies! Decks replaced 2016! Conveniently located between 2 public beach access roads & close to boat pier/ramp on bay side. Plenty of guest parking. Large storage area w/cabinet storage & half bath! Enclosed outdoor shower w/hot & cold water! Exterior freshly stained! Aluminum roof 2010! Stairs replaced 2018! Updated DBL pane windows! 2012-interior gutted & updated w/beadboard + kitchen cabinets & appliances! 2016 water well replaced! Sewage-2019 leech lines expanded! Vinyl plank flooring thru-out interior! Open living & kitchen area! 2 bedrooms each w/closets & ceiling fans! Bathroom has tiled shower w/built-in shelves. Enjoy beautiful sunsets from the rear balcony across the entire length of the home. The furniture is included. No HOA. Interior of home never flooded per seller. Low taxes! MUST SEE! MUST HAVE!' ,`Acres` = '0.1722' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SAN LUIS BEACH (A0029 S F AUSTIN), BLOCK 2, LOT 17' ,`LotDesciption` = 'Cleared,Corner,Water View' ,`LotSize` = '7501' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'San Luis Beach' ,`TaxAmount` = '2276' ,`TaxRate` = '1.9981' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675228359' WHERE `Matrix_Unique_ID` = '211332294' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T21:30:22.310' ,`MLSNumber` = '11105746' ,`ListAgentFullName` = 'Kolawole Ayeni' ,`ListOfficeName` = 'Texas Signature Realty' ,`SellingAgentFullName` = 'Linda Tello' ,`SellingOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`Latitude` = '29.810662' ,`Longitude` = '-95.713161' ,`PhotoCount` = '26' ,`PostalCode` = '77084' ,`RoomCount` = '9' ,`ListPrice` = '320000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Oakwood Falls' ,`StreetNumber` = '19602' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2458' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This freshly painted 4/2/2 home is ready for move in. Open floor plan with lots of upgrades including wood shutters, tile and wood flooring etc. Home comes with crown molding, ceiling fans throughout, extra storage in the attic and pre-wired for surround sound. Oversized lot with access to the Bayou. The backyard is shaded with tall trees and spacious for your family and friends to play and run. Great location in KISD with access to I-10, shops, restaurants and hospitals' ,`Acres` = '0.241' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 CREEK BEND ESTATES SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '10498' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '643' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'STEPHENS ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Creek Bend Estates Sec 03' ,`TaxAmount` = '5761' ,`TaxRate` = '2.572' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675228360' WHERE `Matrix_Unique_ID` = '212989422' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T22:25:31.020' ,`MLSNumber` = '50088009' ,`ListAgentFullName` = 'Steve Aziegbe' ,`ListOfficeName` = 'Keller Williams Realty - Memor' ,`SellingAgentFullName` = 'Steve Aziegbe' ,`SellingOfficeName` = 'Keller Williams Realty - Memor' ,`Latitude` = '29.589368' ,`Longitude` = '-95.095507' ,`PhotoCount` = '18' ,`PostalCode` = '77058' ,`RoomCount` = '4' ,`ListPrice` = '329000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Rutgers Park' ,`StreetNumber` = '12427' ,`StreetSuffix` = 'Court' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2086' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely, charming residence with a fantastic floor plan for a place to call home. Located in highly sought after University Park- a quiet neighborhood centrally located to shopping, medical and dining. Operated as a low maintenance property that allows you to enjoy fireside dinners. Master bedroom is positioned away from the other bedrooms for extra privacy. In the master, enjoy the spaciousness and comfort with 2 large closets and separate tub/shower. Newly installed water softener to provide best quality water for your everyday needs. Come live, play and be a part of a great school district and community. \r\n\r\nConsider this as a key to your next home: low-maintenance, close proximity, fabulous schools and an active community makes this an ideal place to call home. \r\n\r\nUbicado en el popular barrio Parque Universitario. Cerca de tiendas, médicos, restaurantes y buenas escuelas. La suite principal tiene 2 armarios. Se instala un ablandador de agua nuevo.' ,`Acres` = '0.116' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 UNIVERSITY PARK PATIO HOMES 4' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '5053' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BROOKWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'University Park Patio Homes 04' ,`TaxAmount` = '6164' ,`TaxRate` = '2.5419' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675228360' WHERE `Matrix_Unique_ID` = '213467134' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T21:37:52.810' ,`MLSNumber` = '29810301' ,`ListAgentFullName` = 'Tonya Brown' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.723422' ,`Longitude` = '-95.939795' ,`PhotoCount` = '50' ,`PostalCode` = '77423' ,`RoomCount` = '9' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Ruthie Dean' ,`StreetNumber` = '32963' ,`StreetSuffix` = 'Drive' ,`City` = 'Brookshire' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2974' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Vanbrooke in the Fulshear / Brookshire area! This barely lived in home is waiting for you to make it your own. Featuring brick on 4 sides, this customized home features 5 bedrooms + study, 4.5 bathrooms, 2.5 car garage on a premium lot with back patio and no rear neighbors. This gorgeous home features 2 primary suites -- 1 upstairs and 1 downstairs! This is the only home constructed with this exact configuration in the community. New builds in the neighborhood are priced significantly higher for less options, square footage and lot size. There are too many features to name, but some include LVP and ceramic tile flooring, 2\" blinds throughout, Dual zoned 16 SEER HVAC system, tankless water heater, island kitchen with walk-in pantry, covered patio, full sprinkler system, epoxy coated garage floor, a total of 3 en suites, family room with lots of natural lighting and an open concept to the kitchen, plus a game room upstairs. Verify all measurements and community-related info.' ,`Acres` = '0.1906' ,`Area` = '30' ,`BuilderName` = 'HistoryMaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VANBROOKE SEC 2, BLOCK 1, LOT 115' ,`LotDesciption` = 'Cleared,Greenbelt,Subdivision Lot' ,`LotSize` = '8301' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Vanbrooke Sec 2' ,`TaxAmount` = '4775' ,`TaxRate` = '3.2948' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675228360' WHERE `Matrix_Unique_ID` = '213564129' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T21:07:10.720' ,`MLSNumber` = '30923655' ,`ListAgentFullName` = 'Lin Huang' ,`ListOfficeName` = 'KingFay Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.576637' ,`Longitude` = '-95.216465' ,`PhotoCount` = '26' ,`PostalCode` = '77089' ,`RoomCount` = '8' ,`ListPrice` = '319800.00' ,`Status` = 'Active' ,`StreetName` = 'Christophers Walk' ,`StreetNumber` = '12035' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2420' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 2 story home features 3 bedrooms & 2.5 bath located in highly sought after Clear Brook Crossing Community! The open-concept kitchen features brand new granite countertop, SS appliance, new microwave oven, custom tile backsplash, breakfast bar. Formal dining room, large den with cozy fireplace. Bedrooms with ceiling fans and 2 inch blinds. Upstairs Game Room, large backyard, NO direct back neighbor. Double panel windows for energy and noise insulation. AC replaced in 2021, water heater 2022. NO carpet, Fresh paint. Zoned to great CCISD. Easy access to Beltway 8, I-45, shopping, restaurants, parks and walking trails.' ,`Acres` = '0.1356' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 3 CLEAR BROOK CROSSING SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5906' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'WEBER ELEMENTARY' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'WESTBROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Brook Crossing' ,`TaxAmount` = '5785' ,`TaxRate` = '2.524' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675228360' WHERE `Matrix_Unique_ID` = '214108876' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-24T22:59:02.083' ,`MLSNumber` = '35133554' ,`ListAgentFullName` = 'Jade Ngoc Truong' ,`ListOfficeName` = 'V-Pro Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.045802' ,`Longitude` = '-95.604157' ,`PhotoCount` = '22' ,`PostalCode` = '77375' ,`RoomCount` = '8' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Hollis Garden' ,`StreetNumber` = '19210' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very nice house in quiet neighborhood. Open floor plan with high ceiling. Just 1.5 yrs high quality roof. 2100sf house with 3 bedrooms and 1 study room. Fresh laminate floor in formal dining, formal living, study room. Fresh paint whole house. Good size kitchen combines with breakfast. Refrigerator to be stayed. Big size windows give bright for the house. Designed master bedroom ceiling. Double sink, separate shower and garden bathtub in master bathroom. Convenient location - minutes to 249 & Grand Parkway 99, shopping centers, supermarkets....Price is affordable and lowest with ready to move in conditions.' ,`Acres` = '0.1488' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 4 PINECREST FOREST SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6482' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '370' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KOHRVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinecrest Forest Sec 09' ,`TaxAmount` = '6154' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675228361' WHERE `Matrix_Unique_ID` = '214545493' --> 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','215468282','1675228361','215468282','2023-01-24T22:04:47.753','16488047','Cynthia Chang','R.E.D (Real Estate Driven)','','','30.343132','-95.442104','21','77303','6','279999.00','Active','Arbor','981','Crossing','Conroe','2','0','4','1732','Single-Family','Welcome to this gem of a home! Spacious living areas, a mock fireplace, formal dining and wood floors. Absolutely no carpet in the home! The kitchen will check all your boxes - light and bright, granite counters, open to the living and dining areas plus stainless steel appliances! The primary suite is spacious as well as the en suite bath. Both bathrooms have granite counters too. The secondary bedrooms are good sized and the back yard has space without being a lot to manage.','0.1554','19','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','','Mock Fireplace','1','Conroe Northeast','Central Gas','1','S215802 - ARBOR PLACE 02, BLOCK 1, LOT 8','Cul-De-Sac,Subdivision Lot','6770','Appraisal District','','250','0','','2','','0','','','Gas Range','','Composition','11 - Conroe','ANDERSON ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','STOCKTON JUNIOR HIGH SCHOOL','Appointment Required,Vacant/Unoccupied','Appraisal District','1','Traditional','Arbor Place 02','5135','2.1863','Public Sewer,Public Water','2017','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','215766684','1675228361','215766684','2023-01-24T21:19:22.760','70360431','Wendy Miles','Greater Houston REP, Inc.','','','29.705753','-95.856107','48','77441','9','884999.00','Active','Caspian Falls','5714','Lane','Fulshear','5','1','5','4745','Single-Family','This immaculately maintained 5 Br/5.1 Ba has charming curb appeal, a welcoming front porch, & beautiful Iron double door entry. Enter into a spacious foyer and 2-story family room with a grand staircase and stone fireplace to the ceiling. Hardwood floors in entry, powder room, family room, & kitchen/breakfast nook. The kitchen includes high end finishes like granite counters & stainless steel appliances incl. DBL OVENS! Situated within Cross Creek Ranch, your family can enjoy all the amenities & highly rated schools.','0.2735','36','','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Katy - Southwest','Central Gas','1','CREEK COVE AT CROSS CREEK RANCH SEC 2, BLOCK 2, LOT 4','Subdivision Lot','11912','Appraisal District','','1300','0','','3','Double Oven,Gas Oven','1','Gunite','','Gas Cooktop','','Composition','30 - Katy','JAMES E RANDOLPH ELEMENTARY SCHOOL','JORDAN HIGH SCHOOL','ADAMS JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal','2','Traditional','Cross Creek Ranch','21047','3.1375','Water District','2013','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','215818356','1675228361','215818356','2023-01-24T21:55:21.100','86883246','Odalys Sivils','Sharcom Realty','','','30.086460','-95.467517','23','77389','8','295000.00','Active','Meadowhill','22226','Drive','Spring','2','0','4','2156','Single-Family','Beautiful, one story, four bedroom plus home office, bright and spacious home on a lush corner lot. This home includes a beautiful update inside and out. Just inside the glass front door, you will find a delightful foyer, a spacious and bright home office, leading to a vaulted ceiling, huge family room with a towering stone fire place. The kitchen is spacious and bright with new granite counters and a new sink and faucet. The dining is big enough to host a wonderful gathering and opens to the back deck. Outside of the family room is a fenced in patio. The principal bedroom is large and bright with a recently updated en suite bathroom including a spacious shower and walk in closet. The additional 3 bedrooms have ceiling fans and spacious closets. The guest bath was beautifully updated. The schools and neighborhood park are superb! The updates include all flooring, kitchen update, bathrooms, exterior and interior paint, lighting, and more. Come take a peek but prepare to fall in love!','0.1928','14','','','Electric Dryer Connections,Washer Connections','','Exclusions,Mud','','','1','Spring/Klein','Central Gas','1','LT 15 BLK 11 017*F5951900-002-011-015 FOREST NORTH SEC 2 R/P','Corner','8400','Appraisal District','','380','0','','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','32 - Klein','ZWINK ELEMENTARY SCHOOL','KLEIN COLLINS HIGH SCHOOL','HILDEBRANDT INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Ranch','Forest North Sec 02 Rep','6772','3.024','Public Sewer,Public Water','1979','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','215930636','1675228361','215930636','2023-01-24T21:17:46.947','68240722','Lisa Clark','Keller Williams Professionals','','','29.968940','-95.213380','29','77396','7','270000.00','Active','Misty Ridge','3806','Drive','Humble','2','0','3','1837','Single-Family','Looking for a 3-bedroom 2-bath 1-story home, this home has a new roof 1.5 years old, fresh paint throughout the home, fresh paint outside, new vinyl kitchen floor, new carpet in the master bedroom, new ceiling fans in several rooms and a beautiful fireplace for those chilly nights with high ceiling in the living room. Large lot, backyard great for family gatherings.','0.2244','1','','','','','Mud,Sellers Disclosure','1','Freestanding','1','Atascocita South','Central Gas','1','LT 30 BLK 16 ATASCOCITA FOREST SEC 8 R/P','Subdivision Lot','9775','Appraisal District','','450','0','','2','','0','','','','','Composition','29 - Humble','WHISPERING PINES ELEMENTARY SCHOOL','HUMBLE HIGH SCHOOL','HUMBLE MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Atascocita Forest Sec 08 Rep','5664','2.773','Public Water,Water District','1991','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','216098702','1675228361','216098702','2023-01-24T21:56:23.217','75913470','Jason Aguirre','Fathom Realty','','','29.610526','-95.445549','21','77053','4','240000.00','Active','Knottynold','4426','Lane','Houston','2','0','4','1410','Single-Family','Charming home, 2-story, 4 bed, 2 bath, conveniently located min away from beltway 8. The kitchen has brand new appliances. The home has brand new flooring upstairs and tile throughout the first floor, fully fenced backyard, 2 car attached garage, formal dining room, 2 living rooms. New AC installed 2023!','0.1301','18','','','','','Sellers Disclosure','','','','Five Corners','Central Gas','0','LT 11 BLK 2 DUMBARTON VILLAGE R/P','Subdivision Lot','5665','Appraisal District','','','0','','2','','0','','','','','Slate','27 - Houston','MONTGOMERY ELEMENTARY SCHOOL (HOUSTON)','MADISON HIGH SCHOOL (HOUSTON)','LAWSON MIDDLE SCHOOL','Lockbox Front','Appraisal District','2','Traditional','Dumbarton Village R/P','2116','2.3307','Public Sewer,Public Water','1965','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','216602038','1675228361','216602038','2023-01-24T21:16:01.307','45196409','Wendy Miles','Greater Houston REP, Inc.','','','29.868754','-95.880999','26','77493','3','272900.00','Active','Killam County','316','Drive','Katy','2','0','3','1621','Single-Family','Lovely 3 bedroom, 2 bathroom, single-story home featuring an attached 2-car garage! Upon entering this home is a flex area that can be used as an office, play room or formal dining room, then the kitchen boasting granite countertops, stainless steel appliances and a breakfast bar open to the living room. The primary bedroom includes the primary bathroom with a garden tub, separate shower and a walk-in closet. The two secondary bedrooms, secondary bathroom and laundry room make up the rest of the home while the fenced in backyard offers a covered patio and ample green space. This home is located outside of TX-99 near I-10!','0.1937','26','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Brookshire','Central Electric','1','S491903 FREEMAN RANCH 3 BLK 11 LOT 9','Subdivision Lot','8437','Appraisal District','','325','0','','2','Electric Oven','0','','','Electric Range','','Composition','44 - Royal','ROYAL ELEMENTARY SCHOOL','ROYAL HIGH SCHOOL','ROYAL JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Left Side','Appraisal District','1','Traditional','Freeman Ranch','6225','2.783','Water District','2020','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','216604893','1675228361','216604893','2023-01-24T21:13:54.157','19233238','Crystal Jenkins','Keller Williams Hou Preferred','','','29.634750','-95.529780','11','77489','7','320000.00','Active','Padons Trace','16122','Court','Missouri City','2','1','4','2446','Single-Family','Beautiful 2 story home, located on a cul-de-sac, in the Colony Crossing subdivision of Missouri City. The grand entryway of the home welcomes you to a formal dining and office space. The kitchen is an open concept with breakfast nook and adjacent bar for plenty of entertainment. From your kitchen you’ll have a great view of the spacious family room with the cozy fireplace adding a special touch for our cozy winters. All of the bedrooms are housed upstairs to allow for plenty of privacy. The primary bedroom is grand with a large bathroom to match, with his & hers sinks, a garden tub, and a stand up shower. This is definitely a prize home for the price!!','0.1553','20','','','','','Mud,Sellers Disclosure','','','1','Missouri City Area','Central Electric','1','LT 26 BLK 1 VILLAGE OF SAWYERS CROSSING COLONY CROSSING','Corner,Cul-De-Sac,Subdivision Lot','6764','Appraisal District','','395','0','','2','','0','','','','','Composition','27 - Houston','BELL ELEMENTARY SCHOOL (HOUSTON)','WESTBURY HIGH SCHOOL','WELCH MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Contemporary/Modern','Colony Crossing','5307','2.81','Water District','1995','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','216643726','1675228361','216643726','2023-01-24T21:47:36.997','64279202','Lizabeth Comiskey','Comiskey Realty','','','29.296863','-94.910906','33','77554','6','779999.00','Active','Short Reach','1003','','Tiki Island','2','1','3','1936','Single-Family','NEWLY BUILT HOME\r\nGREAT MAN CAVE DOWNSTAIRS WITH OFFICE\r\nOnly Builder living in home since built!!\r\nRoom For Pool.','0.13','33','Freddie Carmichael','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Tiki Island','Central Electric','1','ABST 7 S C BUNDICK SUR LOT 65 TIKI ISLAND SEC 12','Subdivision Lot,Water View,Waterfront','5663','Appraisal District','','160','0','','1','Electric Oven','0','','','Electric Cooktop,Electric Range','','Composition','52 - Texas City','HIGHLANDS ELEMENTARY SCHOOL (LA MARQUE)','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','2','Other Style,Traditional','Tiki Island','16782','2.6125','Public Sewer,Public Water','2021','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','216717459','1675228361','216717459','2023-01-24T21:08:18.453','87782754','Jessica Smith','Coldwell Banker Ultimate','','','28.951394','-95.365999','20','77541','3','165000.00','Active','6th','1415','Street','Freeport','2','0','3','1404','Single-Family','Located on a spacious lot, this charming home is a great opportunity! Enjoy every aspect from the new foundation to the new vinyl plank flooring. Natural light bathes the interior with a warm welcome. This 3 bed, 2 bath home offers a comfortable living room that opens to a stylish kitchen that features granite countertops and new cabinets. The primary bathroom was completely remodeled and boasts a stand-alone shower with a shampoo nook. Enjoy a large indoor utility room. Located near the Brazos River, you\'ll find any number of eating establishments nearby. Call today to make an offer.','','5','','','','','Sellers Disclosure','','','','Freeport','Central Electric','0','FREEPORT, BLOCK 154, LOT 3 W 1/2','Subdivision Lot','7000','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','7 - Brazosport','LONG ELEMENTARY SCHOOL (BRAZOSPORT)','BRAZOSPORT HIGH SCHOOL','FREEPORT INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Freeport','2736','2.5981','Public Sewer,Public Water','1951','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','216717825','1675228361','216717825','2023-01-24T22:20:06.473','48486080','Susan Heflin','eXp Realty, LLC','','','29.841875','-95.481703','16','77092','11','385000.00','Active','Brown Bark','6122','Drive','Houston','2','0','5','1995','Single-Family','6122 is a beauty! Professionally renovated ranch style home in highly desirable Forest West. Full remodel from top to bottom featuring open concept in living/dining/kitchen with complete new roof, complete new A/C/Heater, complete new plumbing repipe throughtout the house w/gas lines including new hot water heater, complete new electrical, new appliances, new shaker cabinets throughoutwith beautiful granite. This home has the most trendy color schemes and is waiting for it\'s forever family. Welcome Home!','0.2066','9','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Oak Forest West Area','Central Gas','1','LT 624 BLK 20 FOREST WEST SEC 2','Subdivision Lot','9000','Appraisal District','','151','0','','2','Electric Oven,Gas Oven','0','','','Gas Range','','Composition','27 - Houston','WAINWRIGHT ELEMENTARY SCHOOL','SCARBOROUGH HIGH SCHOOL','CLIFTON MIDDLE SCHOOL (HOUSTON)','Lockbox Front','Seller','1','Traditional','Forest West Sec 02','5214','2.2019','Public Sewer,Public Water','1972','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','216718003','1675228361','216718003','2023-01-24T22:09:42.803','27176993','Hung Dang','The Realty','','','29.708168','-95.671267','26','77083','3','259999.00','Active','Rancho Blanco','6410','Court','Houston','2','0','3','1494','Single-Family','Beautiful updated residence for sale, located in the Mission Bend North subdivision. Absolutely no carpet, fresh paint on the walls, granite counter tops, and transferrable lifetime foundation warranty. Easy access to major roads such as west park tollway and Westheimer Rd.','0.1698','37','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Mission Bend Area','Central Electric','1','TR 5 BLK 2 MISSION BEND NORTH SEC 3','Corner','7398','Appraisal District','','370','0','','2','Electric Oven','0','','','Electric Range','','Composition','2 - Alief','PETROSKY ELEMENTARY SCHOOL','AISD DRAW','ALBRIGHT MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Mission Bend North Sec 03','3872','2.1862','Water District','1981','Appraisal District'); --> New record created successfully