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-10T18:54:34.967' ,`MLSNumber` = '56426272' ,`ListAgentFullName` = 'Tiffany Richardson' ,`ListOfficeName` = 'Bill Johnson & Assoc. Real Est' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.796215' ,`Longitude` = '-96.044241' ,`PhotoCount` = '45' ,`PostalCode` = '77474' ,`RoomCount` = '6' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Lazy River' ,`StreetNumber` = '3795' ,`StreetSuffix` = 'Drive' ,`City` = 'Sealy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'I give you one of the few properties on the market today that have the ideal location and set-up to host gatherings and celebrations for any event. Situated on the flowing Brazos River, the activities are endless: best fishing in the area, kayaking, floating the rapids then stopping to explore the sandy banks of the river…. The green manicured lawn off the banks leads up to a 2680 sf, 4/3.5 three story main house, offering ample space for lodging. The porches and balconies on each floor are prime spots to watch the neighborhood deer explore and bald eagles soar. Off the main house is a large garage and workshop, which connects to the outdoor/indoor kitchen and living area. Up to 200 people have enjoyed dancing to the live band on the deck, while the grill was hot, and the drinks were cold. 3795 Lazy River Drive could be your weekend retreat, business investment, or fulltime residence…no matter the reason behind the purchase, you’ll be glad you did….' ,`Acres` = '' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lazy River Subdivision Lot 79 and 80' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SEALY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Other Style,Split Level' ,`Subdivision` = 'Lazy River Subdivision' ,`TaxAmount` = '4674' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675111964' WHERE `Matrix_Unique_ID` = '209141117' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T17:04:28.103' ,`MLSNumber` = '63902174' ,`ListAgentFullName` = 'Monica Wheeler' ,`ListOfficeName` = 'RE/MAX Elite Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.222954' ,`Longitude` = '-95.082909' ,`PhotoCount` = '10' ,`PostalCode` = '77327' ,`RoomCount` = '5' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 3435' ,`StreetNumber` = '501' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HIGH and DRY! THIS PROPERTY HAS NEVER FLOODED! Are you looking for peaceful country living with a short commute? You are just minutes away from Hwy 59, Hwy 105 and SH 99 Grand Parkway. A quick commute in any direction. Don\'t miss out on this charming home. It offers 3 bedrooms and 2 bathrooms with a porch entry to the living room and a porch entry to the kitchen. 2022 upgrades: new flooring, new bathroom vanities, new sheetrock and paint inside, newly painted outside, and new interior bedroom doors. The property has a 24x25 metal building on a slab with two roll up doors and 1 pedestrian door on the side with a window. This building has electricity and a work area across the entire back wall. The home sits on 1.33 acres in an unrestricted neighborhood and has endless possibilities.' ,`Acres` = '1.33' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '59 ESTATES, SEC 1, BLOCK 5, LOT 1, ACRES 1.33' ,`LotDesciption` = 'Corner' ,`LotSize` = '57935' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = '59 Estates' ,`TaxAmount` = '2583' ,`TaxRate` = '2.2178' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675111965' WHERE `Matrix_Unique_ID` = '209512217' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T18:17:20.360' ,`MLSNumber` = '79260602' ,`ListAgentFullName` = 'Maaz Kazmi' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822797' ,`Longitude` = '-95.736982' ,`PhotoCount` = '31' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Afton Forest' ,`StreetNumber` = '3406' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3010' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT INVESTMENT PROPERTY. Property is tenant occupied until April 30, 2023. Gorgeous 5 bedroom, 3 Full Bath, 2 Story Home in Bridgewater Meadow Subdivision. Super Spacious Master Suite with Sitting Area on the second floor + Dual Vanities, Garden Tub, Stand-In Shower & large his/her Closets in the Master Bath. Flex 5th Bedroom or Use as Study w/ French Doors on the first floor. Back yard offers a Covered Patio for a Nice Outdoor Living/BBQ Fun. Kitchen with Stainless Steel Appliances, lots of Cabinets & Refrigerator, Washer & Dryer are Included! Never flooded, Katy ISD Schools, and Close to (99) Grand Parkway.' ,`Acres` = '0.1162' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 3 BRIDGEWATER MEADOW SEC 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5060' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCROBERTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bridgewater Meadow Sec 03' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675111965' WHERE `Matrix_Unique_ID` = '212922088' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T18:10:08.520' ,`MLSNumber` = '39941059' ,`ListAgentFullName` = 'Robin Landua' ,`ListOfficeName` = 'BHGRE Hometown' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.168405' ,`Longitude` = '-96.392202' ,`PhotoCount` = '17' ,`PostalCode` = '77833' ,`RoomCount` = '6' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Main' ,`StreetNumber` = '702' ,`StreetSuffix` = 'Street' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2277' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Vintage home on a corner lot just 3 blocks from downtown Brenham. This home features over 2200 square feet, 3 bedrooms, 2 baths, plus large bonus room over garage. Downstairs there is a large living room with fireplace, dining room, full bath and kitchen. Upstairs are the 3 bedrooms, full bath, and potential 4th bedroom/bonus room over the side entry one car garage and carport. Bonus room has a second stairway down to side door. Owner has removed some of the carpet upstairs to expose hardwood floors. Would make a great Air Bnb or a full time residence.\r\nNote:Year built date is effective date per WCAD. Year built is uknown.' ,`Acres` = '0.0792' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S3900 - EAST MAIN S/D, PT OF 30A' ,`LotDesciption` = 'Corner' ,`LotSize` = '3452' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'East Main' ,`TaxAmount` = '3141' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675111965' WHERE `Matrix_Unique_ID` = '213425344' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T17:45:00.043' ,`MLSNumber` = '22259967' ,`ListAgentFullName` = 'Cassandra Perez' ,`ListOfficeName` = 'White Picket Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.797245' ,`Longitude` = '-95.363938' ,`PhotoCount` = '10' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Averill' ,`StreetNumber` = '4019' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '616' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Never Flooded* This home is for anyone seeking an investment opportunity. Conveniently located less than 10 minutes from downtown & only a couple of blocks from the metro train ! This home has an additional living space on the property with a bedroom, living area & full size bathroom ! Schedule your tour today :)' ,`Acres` = '0.1263' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 49 IRVINGTON' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOOSCAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Irvington' ,`TaxAmount` = '2502' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675111965' WHERE `Matrix_Unique_ID` = '213500339' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T18:32:37.663' ,`MLSNumber` = '68523884' ,`ListAgentFullName` = 'Judy Langston' ,`ListOfficeName` = 'Nacol Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.618055' ,`Longitude` = '-95.027398' ,`PhotoCount` = '24' ,`PostalCode` = '77331' ,`RoomCount` = '5' ,`ListPrice` = '89900.00' ,`Status` = 'Active' ,`StreetName` = 'Richard' ,`StreetNumber` = '250' ,`StreetSuffix` = 'Street' ,`City` = 'Coldspring' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate home with many upgraded features. Marble Counter tops kitchen, new smooth cook top. Large One compartment sink in kitchen, upgraded faucets, Beautiful Floors, Excellent workmanship. Huge walk in shower with beautiful tile work and marble countertop. Trinity River at one end of Road and Lake Livingston Dam at other end of road. If you like boating, fishing or recreational activities, this is the place for you. Three bedrooms one with separate entry Large two car detached garage with storage building off to the side with a separate entrance. Huge mature oak trees, fig tree, totally fenced yard. Must see to appreciate!' ,`Acres` = '0.241' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'Lots 459 & 460 Section 2 Camilla Twin Harbors' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '10498' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '48' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Supra Keybox' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Camilla Twin Harbors' ,`TaxAmount` = '187' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675111965' WHERE `Matrix_Unique_ID` = '213504766' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T17:42:37.447' ,`MLSNumber` = '83291460' ,`ListAgentFullName` = 'Diana Backus' ,`ListOfficeName` = 'Texas Patriot Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.940011' ,`Longitude` = '-95.331935' ,`PhotoCount` = '11' ,`PostalCode` = '75862' ,`RoomCount` = '6' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Westwood' ,`StreetNumber` = '109' ,`StreetSuffix` = 'Drive' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1804' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS HOME IS MOVE IN READY. This home features open living/kitchen/ dining area. 3 Bedrooms, 2 full baths, fireplace, granite counter tops, separate utility room, 2 car attached garage. There are waterfront views from the back porch, for there is a small waterfront park behind the home, walk right down to the water from the back porch. Refrigerator and washer and dryer and 2 TVs included in the sale. Amenities for the subdivision include clubhouse with dining, pool, golf and pro shop, tennis courts, miniature golf and boat ramp. Put this home on your list.' ,`Acres` = '0.1719' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 03, BLOCK 63 LOT 15' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '7488' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2508' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Shores Sec 3' ,`TaxAmount` = '6293' ,`TaxRate` = '2.4708' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675111966' WHERE `Matrix_Unique_ID` = '214420805' --> 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','215292667','1675111966','215292667','2023-01-10T17:13:06.367','64949164','Faline Windell','Page Properties','','','30.301167','-95.697013','10','77316','10','722700.00','Active','Lone Star Way','TBD 01','','Montgomery','3','2','4','3491','Single-Family','Beautiful Country Home just under an Acre with 3 Car Garage, 4 Spacious Bedrooms, Study, 3 1/2 Baths, Open Concept Living, Kitchen, Dining, all on 1st floor. Expansive Bonus Room on 2nd Floor. Stunning Chef\'s Kitchen with Granite or Quartz Counters, Stainless Steel Appliances, Double Ovens, 5 Burner Gas Range, 3rd Row Cabinets with Lighting, Dovetail Drawers with Soft Close Hardware & Large Open Island to Living and Dining. High Ceilings, Open & Airy Spaces throughout with Large Front Porch & Large Covered Patio perfect for Indoor/Outdoor Living opening to your Private, Wooded, Backyard Oasis. Custom Features & Trim Work, Energy Efficient with Environments for Living Designation, 16 SEER HVAC, Tankless Water Heater. Serene Country Living Conveniently located close to, Shopping & Restaurants with Very Low Tax Rate in Montgomery ISD & Lake Creek High School. Customize Selections Now!','0.96','39','Hallmark Builders','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures','1','Gaslog Fireplace','1','Montgomery County Northwest','Central Gas','1','Lake Creek Estates 2, Block 1, Lot 1','Cleared,Subdivision Lot,Wooded','41818','Other','','750','1','To Be Built/Under Construction','3','Double Oven','0','','','Gas Cooktop','','Composition','37 - Montgomery','MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required','Builder','1.5','Ranch,Traditional','Lake Creek Estates','','1.7525','Aerobic,Water 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','215293576','1675111966','215293576','2023-01-10T17:12:44.667','23001380','Faline Windell','Page Properties','','','30.300524','-95.697311','11','77316','9','652700.00','Active','Lone Star Way','TBD 02','','Montgomery','3','0','4','2972','Single-Family','Beautiful Country Home just under an Acre with 3 Car Garage, 4 Spacious Bedrooms, 3 Bathrooms, Open Concept Living, Kitchen, Dining, all on 1st floor. Expansive Bonus Room on 2nd Floor. Stunning Chef\'s Kitchen with Granite or Quartz Counters, Stainless Steel Appliances, Double Ovens, 5 Burner Gas Range, 3rd Row Cabinets with Lighting, Dovetail Drawers with Soft Close Hardware & Large Open Island to Living and Dining. Beautiful Floor to ceiling Stone or Brick Gas Fireplace with Cedar Mantle. High Ceilings, Spacious, Open & Airy Spaces throughout with Large Covered Patio perfect for Indoor/Outdoor Living opening to your Private, Wooded, Backyard Oasis. Custom Features & Trim Work, Energy Efficient with Environments for Living Designation, 16 SEER HVAC, Tankless Water Heater. Serene Country Living Conveniently located close to, Shopping & Restaurants with Very Low Tax Rate in Montgomery ISD & Lake Creek High School. Personalize Selections Now!','0.96','39','Hallmark Builders','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures','1','Gas Connections,Gaslog Fireplace','1','Montgomery County Northwest','Central Electric','1','Lake Creek Estates 2, Block 1, Lot 2','Cleared,Subdivision Lot,Wooded','41818','Other','','750','1','To Be Built/Under Construction','3','Double Oven','0','','','Gas Cooktop','','Composition','37 - Montgomery','MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required','Builder','1.5','Ranch,Traditional','Lake Creek Estates','','1.7525','Aerobic','',''); --> 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','215734072','1675111966','215734072','2023-01-10T18:28:10.597','6396598','Jimmy Simien','Simien Properties','','','29.549013','-95.066291','20','77573','9','859000.00','Active','Corniche','1625','Street','League City','2','1','3','3044','Single-Family','DON’T MISS THIS BEAUTIFUL WATERFRONT HOME IN THE DESIRABLE GATED RIVERA COMMUNITY. ENJOY ENTERTAINING YOUR GUESTS ON THE COVERED OUTSIDE LIVING AREA OVERLOOKING SOUTH SHORE HARBOUR. RELAX IN THE PRIMARY BEDROOM WITH ITS OWN FIREPLACE, COFFEE BAR, TWO CLOSETS, AND BALCONY WITH BEAUTIFUL VIEWS. SO MANY AMAZING UPGRADES AND FEATURES IN THIS STUNNING HOME. QUICK ACCESS TO I-45. NEARBY SHOPPING AND DINING. SCHEDULE A TOUR TODAY!','0.125','33','','','','','Sellers Disclosure','1','Gaslog Fireplace','2','League City','Central Gas','1','ABST 18 PAGE 4 LOT 13 RIVIERA','Water View,Waterfront','5446','Appraisal District','','240','0','','2','Double Oven','0','','','Gas Range','','Tile','9 - Clear Creek','FERGUSON ELEMENTARY SCHOOL','CLEAR CREEK HIGH SCHOOL','CLEAR CREEK INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Mediterranean','Riviera 92','12009','1.9062','Public Sewer,Public Water','1992','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','215744401','1675111966','215744401','2023-01-10T18:34:29.510','22793645','Marissa Stevens','RE/ImageProperties and Investm','','','30.053884','-95.378558','18','77373','7','312000.00','Active','Spruce Summit','23131','Trail','Spring','2','1','4','2214','Single-Family','Beautiful 4 bedrooms house with GAMEROOM! Great opportunity to own a house in this pretty new neighborhood.','0.1192','12','','','','','Sellers Disclosure','1','','','Spring East','Central Gas','1','LT 24 BLK 1 BRECKENRIDGE WEST SEC 5','Cleared','5192','Appraisal District','','400','0','','2','','0','In Ground','','Gas Range','','Composition','48 - Spring','GLORIA MARSHALL ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','RICKY C BAILEY M S','Accompany,Appointment Required','Appraisal District','2','Traditional','BRECKENRIDGE FOREST','8699','3.0268','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','215760805','1675111966','215760805','2023-01-10T17:23:48.150','855386','Robert Moore','Perry Homes Realty, LLC','','','30.208683','-95.328823','15','77302','6','419900.00','Active','Merigold Heights','17363','Drive','Conroe','3','0','4','2169','Single-Family','PERRY HOMES NEW CONSTRUCTION! Extended entry with 12-foot ceiling leads to open kitchen, dining area and family room with 10-foot ceilings throughout. Kitchen features center island. Family room features wall of windows. Primary suite with 10-foot ceiling and wall of windows. Dual vanities, garden tub, separate glass-enclosed shower and large walk-in closet in primary bath. A guest suite with private bath adds to this four-bedroom home. Covered backyard patio. Mud room off two-car garage.','','19','Perry Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Spring Northeast','Central Electric,Zoned','1','S216912 - Artavia 12, BLOCK 1, Lot 41','Subdivision Lot,Wooded','6656','Other','','995','1','To Be Built/Under Construction','2','Single Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','SAN JACINTO ELEMENTARY SCHOOL (CONROE)','CANEY CREEK HIGH SCHOOL','MOORHEAD JUNIOR HIGH SCHOOL','Appointment Required,No Appointment Required','Builder','1','Traditional','Artavia','','3.088','Other Water/Sewer','2022','Builder'); --> 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','215798479','1675111966','215798479','2023-01-10T18:43:35.807','36344469','Marisol Velez','Realty Associates','','','29.692309','-95.219917','10','77506','3','199900.00','Active','Sunset','1221','Drive','Pasadena','2','0','3','1310','Single-Family','Ready for immediate move-in! Remodel completed in 2021; new roof, siding, flooring, windows, HVAC, water heater and fixtures. Spacious kitchen with granite countertops and shaker style cabinets. Also, corner lot with 2 driveways.','0.1653','6','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Pasadena','Central Electric','0','LT 12 BLK 3 SUNSET TERRACE SEC 1','Corner,Subdivision Lot','7200','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Cooktop','','Composition','41 - Pasadena','RICHEY ELEMENTARY SCHOOL','PASADENA HIGH SCHOOL','JACKSON INTERMEDIATE SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','Sunset Terrace','4795','2.6514','Public Sewer,Public Water','1948','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','216110867','1675111966','216110867','2023-01-10T18:53:58.277','95562903','Dan VanDeventer','VanDeventer Realtors','','','30.035423','-94.776319','45','77575','8','389000.00','Active','Wallisville','632','Road','Liberty','2','0','3','2262','Single-Family','This beautiful home is located on 3 acres which is a rare find in the town of Liberty, Tx. This house contains 3 bedrooms, 2 bathrooms, living room with fireplace, formal dining, sun room, utility room and served by a 2 car attached carport. There is also a 30\' x 50\' metal building that would make a great workshop, boat & equipment storage or even a party house. It also has two 1/2 bathrooms located in the building that needs repairs. The land is ready for you to improve, play on or even fence and put a horse on. Do not wait, call soon to view this property!','3','52','','','Gas Dryer Connections,Washer Connections','','No Disclosures','1','Wood Burning Fireplace','1','Liberty','Central Electric,Central Gas','0','000196 B C FRANKLIN, TRACT 37, ACRES 3.0','Cleared','130680','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Composition','73 - Liberty','LIBERTY ELEMENTARY SCHOOL (LIBERTY)','LIBERTY HIGH SCHOOL (LIBERTY)','LIBERTY MIDDLE SCHOOL (LIBERTY)','Appointment Required','Appraisal District','1','Traditional','B C Franklin','4842','2.5375','Public Sewer,Public Water','1957','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','216122952','1675111966','216122952','2023-01-10T17:08:44.200','7937845','Catherine Borel','JLA Realty','','','29.971678','-93.991171','18','77627','4','120000.00','Active','15th','115','Street','Nederland','1','1','3','852','Single-Family','','0.3214','51','','','','','Sellers Disclosure','','','','','Central Gas','0','J CARABIN 1 LTS 3 & 4','Other','14000','Appraisal District','','','0','','0','','0','','','','','Other','152 - Nederland','HIGHLAND PARK ELEMENTARY SCHOOL (NEDERLAND)','NEDERLAND HIGH SCHOOL','CENTRAL MIDDLE SCHOOL (NEDERLAND)','Appointment Required','Appraisal District','1','Other Style','Carabin 1','2144','2.3638','Public Sewer,Public Water','1968','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','216204319','1675111966','216204319','2023-01-10T17:01:55.057','67862122','Maelia Davis','Re/Max Property Group','','','31.052401','-96.212729','34','77871','2','490000.00','Active','Trail Lane','18','Lane','Hilltop Lakes','1','0','1','1200','Single-Family','Private Hilltop Lakes retreat with 27+ lush acres with a farmhouse cottage overlooking the property. LIVESTOCK WELCOME! Several areas already cleared and ready for ADDITIONAL HOMES or pastures for your livestock! Join the HTL Wildlife Team and enjoy bow hunting in the THREE DEER STANDS. Spring fed brooks all through the entire property which will feed to 10 acre lake on property. Native Texas wildlife on property include deer, bobcats, birds, otters, beavers, and so much more. Enjoy life on your ranch... or drive to the Hilltop Lakes community center for a FREE round of golf on private 18 hole course, swimming or fishing at the lakes, summer days in the Texas shaped pool, FREE disc golf and mini golf, watch the horses at the equestrian center or watch planes land at the PRIVATE air strip. Only a 45 minute drive to COLLEGE STATION! Centrally located between HOUSTON and DFW. Call to schedule a tour of the entire property today!','27.231','63','','','','','Exclusions,Sellers Disclosure','','','','Normangee/Marquez Area','Heat Pump','1','HILLTOP LAKES SEC 60 BLK 4 LT 11 - 12 4.821 AC','Cleared,In Golf Course Community,Water View,Waterfront,Wooded','','Appraisal District','','120','0','','0','','0','','','','','Composition','131 - Normangee','NORMANGEE ELEMENTARY SCHOOL','NORMANGEE HIGH SCHOOL','NORMANGEE MIDDLE SCHOOL','Accompany,Appointment Required','Seller','1','Other Style,Traditional','Hilltop Lakes Sec 60','683','1.8895','Septic Tank','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','216244631','1675111966','216244631','2023-01-10T17:24:06.353','12494500','Stephanie Duong','United Heroes Realty LLC','','','29.839236','-95.862108','20','77493','3','365000.00','Active','Malibu Pines','668','Drive','Katy','2','0','3','1804','Single-Family','BEAUTIFUL NEW CONSTRUCTION BY SHEA HOMES! Never lived in home in the 50’ section features a spacious entry way that lead to an open concept kitchen that overlook the living and dining area. Kitchen feature granite counter top, stainless steel appliances, with a large island that overlook to the spacious family room. The home has plenty of windows thus providing with plenty of natural light into the house making it very inviting and warmth. Primary suite with dual vanity, separate glass shower and tub, and a large walk-in closet. Walking distance to the lake and Crystal Lagoon (currently under construction). This is a CONTROL ACCESSED COMMUNITY.','0.1485','25','Shea Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Katy - Old Towne','Central Gas','1','S800006 SUNTERRA SECTION 6 BLK 1 LOT 16','Subdivision Lot','6469','Appraisal District','','1200','1','Never Lived In','2','Convection Oven,Gas Oven','0','','','Freestanding Range','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern,Traditional','Sunterra Sec 6','1703','3.516','Public Sewer,Public Water','','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','216259639','1675111966','216259639','2023-01-10T17:28:10.160','60350665','Pablo Martinez','BlueRoof Real Estate, LLC','','','29.610905','-95.484709','26','77085','4','249000.00','Active','Tadlock','6621','Lane','Houston','2','0','3','1721','Single-Family','One story home with 3 bedrooms and 2 baths located in an established subdivision. The property features high ceilings and open floor plan. Area does not have HOA. Call my office for your personal tour today .','0.1808','20','','','','','Sellers Disclosure','0','','','Five Corners','Central Electric','0','LT 12 BLK 15 SOUTH MAIN PLAZA','Subdivision Lot','7875','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','27 - Houston','WINDSOR VILLAGE ELEMENTARY SCHOOL','MADISON HIGH SCHOOL (HOUSTON)','LAWSON MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','South Main Plaza','4042','2.3307','Public Sewer,Public Water','2003','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','216261459','1675111966','216261459','2023-01-10T18:54:35.340','45457144','Shelly Bishop','316 Realty Group','','','31.313858','-95.457694','27','75835','7','169000.00','Active','4th','410','Street','Crockett','2','1','3','1646','Single-Family','This home is being SOLD AS IS! The windows in the home are fairly new. The roof is 10 years old. There is an additional parcel being sold with this property, for a combined total of 56,367 sq ft (1.29 acres) You have access to E Bonham Ave as well. The 60X30, steel framed, insulated work shop with a reinforced concrete slab is in excellent condition. The shop is 1800 sq ft with 4 roll up doors that vary in size. The shelving will stay along with the work bench. There are several 220 plugs throughout the shop. 7 Pecan trees on the property.','1.294','41','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Crockett Area','Central Gas','0','A E GOSSETT AB 423 .5503 AC SEOL 14','Cleared','56367','Appraisal District','','','0','','0','Gas Oven','1','In Ground,Vinyl Lined','','Freestanding Range','','Composition','57 - Crockett','CROCKETT ELEMENTARY SCHOOL (CROCKETT)','CROCKETT HIGH SCHOOL (CROCKETT)','CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)','Appointment Required,Lockbox Back','Appraisal District','1','Traditional','NA','1666','2.3571','Public Sewer,Public Water','1921','Appraisal District'); --> New record created successfully