Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T14:38:37.430' ,`MLSNumber` = '95110024' ,`ListAgentFullName` = 'Jerome Drewry' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.800089' ,`Longitude` = '-95.109776' ,`PhotoCount` = '31' ,`PostalCode` = '77360' ,`RoomCount` = '6' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'Panther' ,`StreetNumber` = '170' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great affordable WATERVIEW. 3/2 with large living area/dining combo, 12x12 open country kitchen with beautiful tile counters. Fencing for small dogs, Upper deck is 22x13 and screened in for enjoying the water views. Two large storage sheds. Super clean and move in ready.\r\nSorry, no short term rentals allowed in this subdivision' ,`Acres` = '0.1451' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'IMPALA WOODS SECTION 4 BLK 2 LOT 23 & 24' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6319' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '170' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Impala Woods Sec 4' ,`TaxAmount` = '2594' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089137' WHERE `Matrix_Unique_ID` = '206177716' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T14:56:40.773' ,`MLSNumber` = '70012691' ,`ListAgentFullName` = 'Kyle Pryor' ,`ListOfficeName` = 'Pryor Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.395273' ,`Longitude` = '-95.688456' ,`PhotoCount` = '37' ,`PostalCode` = '77356' ,`RoomCount` = '6' ,`ListPrice` = '439000.00' ,`Status` = 'Active' ,`StreetName` = 'Abner' ,`StreetNumber` = '167' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2258' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New home with 3 car garage and on large lot! Ready for move in January 2023. 4 bedrooms, game room, & study.\r\nceramic tile all down stairs except for primary bedroom. Located in Montgomery school district. Low HOA dues & tax rate! View virtual tour, 3D floorplan image, & pics.' ,`Acres` = '0.28' ,`Area` = '39' ,`BuilderName` = 'Camillo Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S456900 - ESTATES OF LAKE CREEK VILLAGE, BLOCK 1, LOT 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '12197' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates Of Lake Creek Village' ,`TaxAmount` = '1146' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675089137' WHERE `Matrix_Unique_ID` = '211048353' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T14:34:12.940' ,`MLSNumber` = '29401455' ,`ListAgentFullName` = 'Kyle Pryor' ,`ListOfficeName` = 'Pryor Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.438636' ,`Longitude` = '-95.615438' ,`PhotoCount` = '31' ,`PostalCode` = '77356' ,`RoomCount` = '3' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Clear Water' ,`StreetNumber` = '115' ,`StreetSuffix` = 'Street' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1818' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New home with 3 bedrooms, 2 bath & covered back porch. Ceramic tile floor everywhere except bedrooms. Located in sought after Montgomery school district & is in a low tax rate. Subdivision does have a boat ramp with Lake Conroe access. View virtual tour, 3D floor plan image, & pics.' ,`Acres` = '0.1321' ,`Area` = '39' ,`BuilderName` = 'Camillo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CLEAR WATER COVE, BLOCK 5, LOT 9' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '5756' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Water Cove' ,`TaxAmount` = '394' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675089137' WHERE `Matrix_Unique_ID` = '211066736' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T13:19:52.547' ,`MLSNumber` = '23315806' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Princeton Classic Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.500018' ,`Longitude` = '-95.397786' ,`PhotoCount` = '21' ,`PostalCode` = '77578' ,`RoomCount` = '7' ,`ListPrice` = '499990.00' ,`Status` = 'Active' ,`StreetName` = 'Indian Wells' ,`StreetNumber` = '95' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3577' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in the gated section of Rodeo Palms in Manvel, TX! The McKendree floor plan is a stunning 2-story home with 4 bedrooms, 3.5 bathrooms, study, game room, flex room, AND a 2.5 car garage! This home includes ALL of the designer finishes you\'ve been looking for, wood-look tile throughout + WATER VIEW! The gourmet kitchen is sure to please with 42\" cabinetry, granite countertops, and picket mosaic backsplash! Retreat to the Owner\'s Suite featuring a beautiful bay window and a separate tub and shower. Enjoy the great outdoors with a covered patio! Don\'t miss your opportunity to call Rodeo Palms home, schedule a visit today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'PRINCETON CLASSIC' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 14 BLK 2 RODEO PALMS - THE LAKES' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6900' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rodeo Palms - The Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.7' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675089138' WHERE `Matrix_Unique_ID` = '211518296' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T13:12:38.583' ,`MLSNumber` = '33430988' ,`ListAgentFullName` = 'Tisha Lockwood' ,`ListOfficeName` = 'Southern Style Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.075730' ,`Longitude` = '-95.168929' ,`PhotoCount` = '6' ,`PostalCode` = '77345' ,`RoomCount` = '7' ,`ListPrice` = '277000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodspring Glen' ,`StreetNumber` = '4717' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1935' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bed 2 bath home in the heart of Woodspring Forest! This open concept home features breakfast room, island kitchen, formal dining room, and family room with cozy fireplace fantastic for entertaining. Primary bedroom has HUGE walk-in closet and a separate tub and shower. Walking distance to park and pool!' ,`Acres` = '0.1299' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 4 WOODSPRING FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5658' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'HIDDEN HOLLOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodspring Forest' ,`TaxAmount` = '5106' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089138' WHERE `Matrix_Unique_ID` = '212707953' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T13:32:17.737' ,`MLSNumber` = '10954581' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Newmark Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.926650' ,`Longitude` = '-95.736529' ,`PhotoCount` = '50' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '539204.00' ,`Status` = 'Active' ,`StreetName` = 'Colorado Bend Park Drive' ,`StreetNumber` = '15342' ,`StreetSuffix` = '' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2750' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Bailey plan by Newmark Homes features a ranch-style exterior with modern character. Soaring high ceilings in the family room meet point-vaulted windows that overlook the spacious covered patio, and no back neighbor. 4 beds (2 down), 3.5 baths, huge gameroom, formal living room, office, and 2 car garage. Corner lot with full sprinkler system!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 07, Blk 02, Sec 56' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6764' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1210' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Bridgeland, Parkland Village' ,`TaxAmount` = '' ,`TaxRate` = '3.540968' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675089138' WHERE `Matrix_Unique_ID` = '212771798' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T13:36:06.940' ,`MLSNumber` = '71213510' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.456344' ,`Longitude` = '-95.472633' ,`PhotoCount` = '7' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '328445.00' ,`Status` = 'Active' ,`StreetName` = 'Urban' ,`StreetNumber` = '626' ,`StreetSuffix` = 'Way' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1553' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Enjoy every moment spent in this incredible Pride Builders home in Huntington Place. Nestled on a spacious lot, this 3-sided brick home boasts a premium elevation, no back neighbors, tile flooring, full gutters, a sprinkler system, faux wood blinds, a cast stone fireplace, and a covered patio. Try new cuisines in the kitchen, complete with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. The spa-like primary suite features dual vanities, a 42” tub, and a separate shower. Amenities of Huntington Place include a community pool, recreation center, and abundant greenspaces. Residents benefit from direct access to Hwy 288 and Hwy 6, making a quick drive to the Texas Medical Center. Numerous outdoor adventures and nature parks surround the area, along with a variety of shops and restaurants. Zoned to Fort Bend ISD. This is your dream home – call now!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Pride Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '523' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntington Place' ,`TaxAmount` = '' ,`TaxRate` = '3.25' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675089138' WHERE `Matrix_Unique_ID` = '213763466' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T14:34:04.423' ,`MLSNumber` = '88202866' ,`ListAgentFullName` = 'Joy Scipio' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.387916' ,`Longitude` = '-94.933017' ,`PhotoCount` = '24' ,`PostalCode` = '77590' ,`RoomCount` = '5' ,`ListPrice` = '149900.00' ,`Status` = 'Active' ,`StreetName` = '3rd' ,`StreetNumber` = '2620' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1018' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TAKE A LOOK AT THIS COZY HOUSE ON LARGE LOT, BEAUTIFULLY UPDATED AND MOVE IN READY, NEW SIDING, NEW FLOORING, NEW WINDOWS, NEW CABINETS, NEW FIXTURES, NEW WINDOW UNITS, UPDATED BATHROON, NEW GRANITE AND MANY MORE. COME TAKE A LOOK' ,`Acres` = '0.3185' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Other Heating,Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 142 PAGE 4 PT OF LOT 28 (28-9) TEXAS CITY HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HEIGHTS ELEMENTARY SCHOOL (TEXAS CITY)' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Texas City Heights' ,`TaxAmount` = '2612' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089139' WHERE `Matrix_Unique_ID` = '214176331' --> 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','214284400','1675089139','214284400','2022-12-09T14:09:46.770','86478954','Jamie Bechtold','RE/MAX Signature','','','30.743966','-94.922984','7','77351','4','299000.00','Active','US Highway 59','3053','','Livingston','1','0','2','1714','Single-Family','Beautiful 4.25 acres, unrestricted, can be used as a residential home or for commercial use. The property sits right off of Highway 59 and features a pond towards the back of the property, a 1714 sq ft home, a well that can be used as a water source, a climate controlled greenhouse, and much more! Come see this beauty for yourself! Schedule a showing today!','3.4574','44','','','','','Sellers Disclosure','1','','','Livingston Area','Central Electric','0','ABST 9 JOHN D BURKS SURVEY TRACT 50','Cleared','150604','Appraisal District','','','0','','0','','0','','','','','Aluminum','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','None','1874','1.8745','Public Water,Septic Tank,Well','1951','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T14:23:07.667' ,`MLSNumber` = '23051681' ,`ListAgentFullName` = 'Dominique Johnson' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.158405' ,`Longitude` = '-95.756171' ,`PhotoCount` = '32' ,`PostalCode` = '77355' ,`RoomCount` = '17' ,`ListPrice` = '649000.00' ,`Status` = 'Active' ,`StreetName` = 'Indigo Lake' ,`StreetNumber` = '28211' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Click the Virtual Tour link to view the 3D walkthrough. Enjoy stunning lakefront views right from the backyard! This 3,000+ square foot home is perched right on the lake with over 2 acres of land & it\'s own running path. This open floor plan has plenty of room to entertain on all 3 levels. Built-in shelves, granite countertops, & an island with bar seating are just a few kitchen highlights. All appliances are new & convey! Escape to your own private oasis where the primary bedroom features a spa-like en-suite bathroom with double sinks, grand soaking tub, & lakefront views. The game room & remaining bedrooms are on the second floor where each room has individual access to the porch. The massive media room features a wet bar and a hidden room behind the bookshelf. Enjoy the outdoors by sitting under the covered patio where lush trees surround the property or head over to the lake with your backyard access. 7 kayaks & water trampoline included! All furniture left in the home will convey!' ,`Acres` = '2.143' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'INDIGO LAKE ESTATES 02, BLOCK 1, LOT 9' ,`LotDesciption` = 'Corner,Water View' ,`LotSize` = '93349' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'NICHOLS SAWMILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Indigo Lake Estates 02' ,`TaxAmount` = '12260' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089139' WHERE `Matrix_Unique_ID` = '214322447' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T13:23:17.930' ,`MLSNumber` = '52171455' ,`ListAgentFullName` = 'Sammy Younis' ,`ListOfficeName` = 'RE/MAX Southwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.511905' ,`Longitude` = '-95.609131' ,`PhotoCount` = '39' ,`PostalCode` = '77469' ,`RoomCount` = '10' ,`ListPrice` = '698880.00' ,`Status` = 'Active' ,`StreetName` = 'Carroll' ,`StreetNumber` = '135' ,`StreetSuffix` = 'Road' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4345' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rural estate property located off of FM 2759. Situated on a beautifully wooded 1.8 acres with an additional 30X50 slab at back of the property and custom wrap around porch (874 sqft)! Grand entry with high ceilings, both formals, primary bedroom on 1st floor with attached study/nursery. Large secondary bedrooms upstairs, with lots of natural lighting! 800+ sqft of unfinished space on the 3rd floor can be converted to a large game room, media room, or a secondary primary bedroom. Additional workshop and storage building can be used for RV or boat storage. Endless potential for this acreage property!' ,`Acres` = '1.8' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend Southeast' ,`HeatSystem` = 'No Heating,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'PECAN ESTATES, LOT 24, ACRES 1.8' ,`LotDesciption` = 'Wooded' ,`LotSize` = '78408' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'VELASQUEZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional,Victorian' ,`Subdivision` = 'Pecan Estates' ,`TaxAmount` = '5822' ,`TaxRate` = '1.6948' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089139' WHERE `Matrix_Unique_ID` = '214550242' --> 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','215328523','1675089139','215328523','2022-12-09T13:34:50.113','72001686','Deborah Kahla','RE/MAX On The Water - Bolivar','','','29.461165','-94.612456','49','77650','15','2500000.00','Active','Sand Drift','2414','Lane','Crystal Beach','5','1','5','4140','Single-Family','Gorgeous Beachfront! Enhanced w/Wide WalkOver the Expanded Dunes Allowing Privacy as You Come/Go to the Water\'s Edge & Sand!!1st Floor Offers Open Concept Kitchen/Dining/Living Area w/Wet Bar & Game Room w/Child\'s Hideaway & Pool Table..Endless Gulf Views Thru a Wall of Windows & Doors..Conveniences of 1/2 Bath, Utility Room & Elevator to Both Levels..Oversized Kitchen Island, S/S Farm Sink, S/S Appliances, Custom Cabinetry w/Quartz Countertops & Stunning Accented Backsplash & Wood Flooring Giving an Overall Color Palette for Coastal Living! Quality Light Fixtures, Recessed Lighting & Crown Moulding & Monitering System. Upstairs Boasts 5 Spacious Bedrooms & 5 Ensuite Bathrooms w/Porcelain Tile..Master w/Expansive WalkIn Closet & Stunning Dbl Vanity Sinks & Private Deck for Unforgetable Views/Relaxation..Hallway Area offers Sm Fridge & Ice Maker @ Wet Bar Accomodating All..2 Car/1 Golf Garage,Utility,Sand Shower,Fenced Back Yard, Composite Decking, Louvered Privacy Boards & More','0.686','33','','','Electric Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','1','','','Crystal Beach','Central Electric','0','ABST 65 B FRANKS SUR PT OF LOTS 4 & 5 (4-1) DRIFTWOOD ADDN','Subdivision Lot,Water View,Waterfront','29882','Appraisal District','','','0','','2','Double Oven,Electric Oven','0','','','Electric Cooktop,Grill','','Other','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox','Appraisal District','2','Traditional','Driftwood','30568','1.6113','Public Sewer,Public Water','2015','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','215459080','1675089139','215459080','2022-12-09T14:34:04.737','22121318','Kathy Prescott','Prescott Properties LLC','','','30.396910','-96.084448','25','77868','3','188500.00','Active','Mcnair','613','Street','Navasota','2','0','3','1189','Single-Family','This Ranch style home is on a Large Corner Lots, 2.5 lots and a 3 Bedroom, 2 full baths. Ready for move in, Just installed flooring, new appliances and interior paint in each room. The Foundation has been repaired and New Septic lines to the city hook up installed. Large fenced in back yard with a refreshed Deck, waiting for a Great Party!','0.2152','60','','','','','Sellers Disclosure','','','','','Central Electric','0','MCNAIR, BLOCK 22, LOT 7, 8(N/2)','Corner','9375','Appraisal District','','','0','','0','','0','','','','','Composition','129 - Navasota','WEBB ELEMENTARY SCHOOL (NAVASOTA)','NAVASOTA HIGH SCHOOL','NAVASOTA JUNIOR HIGH','Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Traditional','Mcnair','2296','2.2111','Public Sewer,Public Water','1965','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215476966','1675089139','215476966','2022-12-09T14:34:08.840','44636328','Nimesh Patel','RE/MAX Fine Properties','','','29.565922','-95.746774','29','77469','10','674000.00','Active','Masterson Garden','23742','Lane','Richmond','4','1','4','3485','Single-Family','Welcome to Newmark Homes in Veranda! This Langford floor plan features a 3-car garage with 4 Bedrooms and 4 Baths situated on a lot with pond and no back neighbors! Upon entry you are greeted with 8-foot Entry Doors with an astounding 20-foot ceiling with 8-foot interior doors and curved staircase. Wood floors expanding throughout the main living areas. Kitchen is a chefs dream with upgraded appliances, large serving island with an abundance of cabinetry and prep space. 2 Bedrooms downstairs make for a perfect guest space! Veranda, by Johnson Development is known for Life Beyond the Front Porch. Offering swimming pool and splash pad, fitness center, event lawn, biking and walking trails, yoga lawn and of course massage and spa. Veranda is perfectly situated right off 59 making getting into Houston or to Katy a quick ride!','','30','Newmark Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','Mock Fireplace','1','Fort Bend South/Richmond','Central Gas','1','Lot 3 Block 1 Section 39','Subdivision Lot,Waterfront','','','','1095','1','Never Lived In','3','Convection Oven,Electric Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','PHELAN ELEMENTARY SCHOOL','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Contemporary/Modern','Veranda','','3.17','Public Sewer,Public Water,Water District','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','215481701','1675089139','215481701','2022-12-09T14:23:43.843','63715563','Dana Staples','Staples Sotheby\'sInternational','','','32.056514','-95.505752','48','75763','8','445000.00','Active','Elm','310','Street','Frankston','3','0','5','3289','Single-Family','Inviting well designed home on oversized lot in Frankston, TX! The seller is an architect who values detail, as shown in this well loved, 1-owner custom built home that makes the most of interior & exterior space. Upon entering you will immediately be drawn to views of the wooded backyard through the wall of windows spanning the back of the home. A vaulted wood ceiling & stone gas fireplace in the living area welcome you into this special place. The open dining area adjacent to the main level living area has the same beautiful view & access to the deck. With a great flow for entertaining, an elevated deck runs the length of the house providing outdoor living & dining space. Kitchen has granite counters with great work space. Main level also has 3 BRs, including the primary bedroom that has access to the deck. Downstairs has the 2nd living area with brick WBFP, access to backyard, & 2 bedrooms (1 without closet) & full bath.','0.7174','75','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace,Wood Burning Fireplace','2','Frankston','Central Gas,Zoned','0','FRANKSTON HEIGHTS BLOCK J LOT 9 -13 & 24-28','Subdivision Lot','31250','Appraisal District','','','0','','0','Electric Oven,Single Oven','0','','','Electric Cooktop','','Composition','67 - Frankston','FRANKSTON ELEMENTARY SCHOOL','FRANKSTON HIGH SCHOOL','FRANKSTON MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Other Style','Frankston Heights','4846','2.2441','Public Sewer,Public Water','1974','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','215484901','1675089139','215484901','2022-12-09T14:37:13.053','55235761','Vicki Miller','RE/MAX Opportunities','','','29.386992','-95.835907','44','77461','6','408000.00','Active','Highland Pointe','9715','','Needville','2','1','3','2090','Single-Family','Beautiful custom brick/stone home located in the heart of Needville, Tx with city utilities. Built by High Hills Custom Homes and designed with all the architectural features that most buyers are dreaming of! Enjoy wood plank tile floors throughout the house, open floor plan with a home/office study or use as your \"Zoom\" room, formal dining, elaborate kitchen with Quartz counters, ample cabinets/counter space, stainless appliances, gas cook top, break bar, and bright breakfast room. The ceilings are 10ft with upgraded 8 ft doors and recessed lighting. All bedrooms are generous in size; the primary bedroom offers a distinctive detailed bathroom with double sinks, separate tub/shower, and walk in closet. This home is within walking distance to Needville Schools, the public library, and just minutes from major freeways and hospitals.','','30','High Hills Custom','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','Gas Connections','1','','Central Gas','1','HIGHLAND POINTE SEC 5, BLOCK 2, LOT 1','Subdivision Lot','','','','75','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','38 - Needville','NEEDVILLE ELEMENTARY SCHOOL','NEEDVILLE HIGH SCHOOL','NEEDVILLE JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Builder','1','Traditional','Highland Pointe','','','Public Sewer,Public Water','2022','Builder'); --> New record created successfully