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-15T16:27:15.950' ,`MLSNumber` = '96597704' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.824580' ,`Longitude` = '-94.991710' ,`PhotoCount` = '12' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '332990.00' ,`Status` = 'Active' ,`StreetName` = 'Crescent Lake' ,`StreetNumber` = '4519' ,`StreetSuffix` = 'Circle' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Creede plan consists of three bedrooms, two full attached bathrooms, and a massive family room!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9, Block 3, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9010' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Goose Creek Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091429' WHERE `Matrix_Unique_ID` = '208744482' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T16:56:34.397' ,`MLSNumber` = '84864704' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.026861' ,`Longitude` = '-95.845856' ,`PhotoCount` = '50' ,`PostalCode` = '77447' ,`RoomCount` = '10' ,`ListPrice` = '392142.00' ,`Status` = 'Active' ,`StreetName` = 'Kildeer Point' ,`StreetNumber` = '16110' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Create unforgettable moments with this charming property. This home boasts a stone elevation, high ceilings, luxury vinyl plank flooring, formal dining room, spacious study, island kitchen, and a covered patio. Cook up new recipes in the kitchen, fully equipped with granite countertops, tile backsplash, 30” gas cooktop, and stainless steel appliances. Get some rest and relaxation in the tranquil primary suite, complete with a bay window, a walk-in closet, dual vanities, luxury spa shower. Experience a community with a small town feel situated just minutes from Highway 290 and FM 1960, with easy access to Grand Parkway and the rest of the Greater Houston area. Enjoy a variety of amenities including the neighborhood pool, dog park, and a walking trail around the community lake. Come visit us this weekend!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 68 Block 1 Section 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'I T HOLLEMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091429' WHERE `Matrix_Unique_ID` = '209357679' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T16:59:16.930' ,`MLSNumber` = '43089128' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.084333' ,`Longitude` = '-95.769221' ,`PhotoCount` = '17' ,`PostalCode` = '77447' ,`RoomCount` = '10' ,`ListPrice` = '411629.00' ,`Status` = 'Active' ,`StreetName` = 'Lyle Manor' ,`StreetNumber` = '31611' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2034' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful house has it all. Stone elevation, 3 full baths, luxury vinyl plank flooring, a 3-car garage, beamed ceilings, and an extended covered patio. Try a new recipe in the kitchen complete with granite countertops, tile backsplash, 30” gas cooktop, and stainless steel appliances. Take a well-deserved break in the serene primary suite, fully equipped with a bay window, a walk-in closet, dual vanities, a tub and separate shower. Enjoy a variety of amenities including the community pool, recreation center, dog park and beautiful lake with a walking trail. Situated minutes from Highway 290, residents have easy access to the Grand Parkway and the rest of the Greater Houston area. Call or visit us soon!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 1 Section 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091429' WHERE `Matrix_Unique_ID` = '209361818' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T16:57:21.070' ,`MLSNumber` = '85719301' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.026861' ,`Longitude` = '-95.845856' ,`PhotoCount` = '47' ,`PostalCode` = '77447' ,`RoomCount` = '14' ,`ListPrice` = '457221.00' ,`Status` = 'Active' ,`StreetName` = 'Jack Point' ,`StreetNumber` = '31606' ,`StreetSuffix` = 'Circle' ,`City` = 'Hockley' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2853' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Create unforgettable moments in this beautiful property. This home boasts a stone elevation, 3 car garage, versatile flex room downstairs, luxury vinyl plank flooring, spacious game room upstairs and an extended covered patio on a quiet cul-de-sac lot. Cook up new recipes in the island kitchen, fully equipped with granite countertops, tile backsplash, 30” gas cooktop, and stainless steel appliances. Get some rest and relaxation in the tranquil primary suite, complete with a bay window, a walk-in closet, dual vanities, a luxury spa shower. Experience a community with a small town feel situated just minutes from Highway 290 and FM 1960, with easy access to Grand Parkway and the rest of the Greater Houston area. Enjoy a variety of amenities including the neighborhood pool or quiet walks at nearby Zube and Roberts Road Parks. Come visit us this weekend!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10 Block 1 Section 7' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'I T HOLLEMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091429' WHERE `Matrix_Unique_ID` = '209362677' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T16:55:29.143' ,`MLSNumber` = '57911134' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.026861' ,`Longitude` = '-95.845856' ,`PhotoCount` = '18' ,`PostalCode` = '77447' ,`RoomCount` = '15' ,`ListPrice` = '474437.00' ,`Status` = 'Active' ,`StreetName` = 'Will Park' ,`StreetNumber` = '16027' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2996' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house has it all! Situated on an oversized premium cul-de-sac lot, this home features a 3 car garage, luxury vinyl plank flooring, study, game room, media room, and an extended covered patio. Create amazing meals in the open island kitchen, fully equipped with granite countertops, tile backsplash, 30\" gas cooktop and stainless steel appliances. Spend your evenings relaxing in the primary suite, complete with a bay window, a walk-in closet, dual vanities and a luxury walk-in spa shower. Experience a small town feel while being just minutes away from Highway 290 with easy access to the Grand Parkway, popular shopping, dining and entertainment. Call now or visit us this weekend!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 36 Block 1 Section 7' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '15594' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'I M TERRELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091430' WHERE `Matrix_Unique_ID` = '209364446' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T16:17:38.860' ,`MLSNumber` = '44503703' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.368150' ,`Longitude` = '-95.671563' ,`PhotoCount` = '22' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '420990.00' ,`Status` = 'Active' ,`StreetName` = 'Tilia Creek' ,`StreetNumber` = '1263' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2418' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The charming Frost plan includes three bedrooms with walk-in closets and two-and a half bathrooms!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12, Block 3, Section 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9482' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fairwater' ,`TaxAmount` = '' ,`TaxRate` = '2.58' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091430' WHERE `Matrix_Unique_ID` = '210112510' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T15:18:50.833' ,`MLSNumber` = '95758949' ,`ListAgentFullName` = 'Pam Holmes' ,`ListOfficeName` = 'Texas Premier Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.806187' ,`Longitude` = '-94.429043' ,`PhotoCount` = '49' ,`PostalCode` = '75979' ,`RoomCount` = '11' ,`ListPrice` = '799000.00' ,`Status` = 'Active' ,`StreetName` = 'US Hwy 69 N' ,`StreetNumber` = '1561' ,`StreetSuffix` = '' ,`City` = 'Woodville' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Look no further! Possibilities are Endless for this Unique Gem. This property sits just outside North of Woodville on Highway 69. This is a gorgeous 3,300SF Custom Brick Home situated on 5.150 acres. Home offers 3 bedrooms, 4 bathrooms, oversized kitchen with Natural Gas, island, granite countertops. Concrete drive leading to THREE sheds to store all the outdoor toys. Raised garden in the backyard to grow those veggies. Fenced area for livestock. This home is fed by a well or public water. Also, located on this property is a 10,000SF brick church with 6 restrooms, 2 offices, 1 sanctuary, 1 dining, full size apartment upstairs with additional rooms. There are 3 RV Hook-ups. This property can be used for multiple opportunities. Now is your time to expand your DREAMS and make this property yours! New Survey on file. Will not divide the house and church. Must sell together. Call today!' ,`Acres` = '5.15' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0020 E. F. HANKS,ACRES 5.15' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '253 - Woodville' ,`SchoolElementary` = 'WHEAT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WOODVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'WOODVILLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Back' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'NONE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water,Well' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091430' WHERE `Matrix_Unique_ID` = '210129485' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T16:58:16.620' ,`MLSNumber` = '4416899' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.026861' ,`Longitude` = '-95.845856' ,`PhotoCount` = '18' ,`PostalCode` = '77447' ,`RoomCount` = '15' ,`ListPrice` = '486278.00' ,`Status` = 'Active' ,`StreetName` = 'Zoe Point' ,`StreetNumber` = '31607' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3233' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of our newest floor plans! This gorgeous home is situated on a cul-de-sac lot and features a stone elevation, luxury vinyl plank flooring, game room, spacious loft upstairs, and a covered patio. No back neighbors! Whip up amazing meals in the open island kitchen, fully equipped with granite countertops, tile backsplash, 30\" gas cooktop and stainless steel appliances. Spend your evenings relaxing in the primary suite, complete with a walk-in closet, dual vanities, a luxury spa shower. Community comforts include a dog park, recreation center, playground, community pool and a beautiful lake with a walking trail. Experience a small town feel while being just minutes away from popular shopping, dining and entertainment.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21 Block 1 Lot 7' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6837' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'I T HOLLEMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091430' WHERE `Matrix_Unique_ID` = '210297855' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T16:21:40.340' ,`MLSNumber` = '91472270' ,`ListAgentFullName` = 'Joana Gonzalez' ,`ListOfficeName` = 'Keller Williams Realty - Memor' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801939' ,`Longitude` = '-95.497952' ,`PhotoCount` = '29' ,`PostalCode` = '77055' ,`RoomCount` = '5' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayram' ,`StreetNumber` = '1746' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1169' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Surrounded by million dollar homes- this is a great opportunity! This cozy ranch style home features 3 bedrooms, 1 bath, lots of yard space to built an addition or enjoy with the loved ones. Walk into an open floor concept with dining and living room space, gorgeous hard wood floors and fresh paint throughout. Kitchen has granite countertops and tile backsplash. Bedrooms plenty of closet space and built-ins. This home has lots of windows providing ample natural bright light. You can walk out the kitchen to the patio area and enjoy all the green yard space and mature trees. Keep your yard looking green with the sprinkler system in back and front yard. Home has never flooded and is zoned to excellent schools Valley Oaks Elementary and Memorial High School.' ,`Acres` = '0.1942' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 65 BLK 4 SPRING OAKS R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8460' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'VALLEY OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Spring Oaks R/P' ,`TaxAmount` = '9328' ,`TaxRate` = '2.6056' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091430' WHERE `Matrix_Unique_ID` = '210483455' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T15:10:25.270' ,`MLSNumber` = '35515146' ,`ListAgentFullName` = 'Sarah Holley' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.943754' ,`Longitude` = '-95.330480' ,`PhotoCount` = '13' ,`PostalCode` = '75862' ,`RoomCount` = '4' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Cherry' ,`StreetNumber` = '39' ,`StreetSuffix` = 'Hills' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1644' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom 2 bath new construction in the wonderful golf community of Westwood Shores! Home sits on the golf course and features...Stone/siding exterior, Interior: Vinyl plank flooring, massive kitchen island, foam insulation, electric range, open floor plan, walk-in shower, custom cabinets, tall ceilings, pendant lighting and Granite countertops. Subdivision has 24 hour manned gate, public pool, golf course, tennis court and access to Lake Livingston!! Home is Completed! Call for a showing today! ' ,`Acres` = '0.1571' ,`Area` = '42' ,`BuilderName` = 'HOLLEY CUSTOM HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 07, BLOCK 75 LOT 14' ,`LotDesciption` = 'In Golf Course Community,On Golf Course' ,`LotSize` = '6844' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '178' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Controlled Access,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Shores' ,`TaxAmount` = '133' ,`TaxRate` = '2.5863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091431' WHERE `Matrix_Unique_ID` = '210670768' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T15:23:31.890' ,`MLSNumber` = '11320179' ,`ListAgentFullName` = 'Nikola Knezevic' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = 'Jorge Maldonado' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '29.937571' ,`Longitude` = '-95.282112' ,`PhotoCount` = '18' ,`PostalCode` = '77396' ,`RoomCount` = '4' ,`ListPrice` = '209900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Grand Prairie' ,`StreetNumber` = '14907' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT HOME MOVE IN READY!...4 bedroom 2.5 baths...freshly painted in and out... NEW Stainless steel APPLIANCES...NEW granite...NEW Hardware through out the house...NEW Carpet...W/D connections...Easy access to major highways...Near to restaurants and shopping\'s...come see it for yourself! Make your appointment today!' ,`Acres` = '0.1708' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Owner/Agent,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 1 EASTEX OAKS VILLAGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'NORTH BELT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Eastex Oaks Village Sec 01' ,`TaxAmount` = '2720' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091431' WHERE `Matrix_Unique_ID` = '212117786' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T15:08:46.740' ,`MLSNumber` = '76371155' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Newmark Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947921' ,`Longitude` = '-95.782331' ,`PhotoCount` = '23' ,`PostalCode` = '77433' ,`RoomCount` = '13' ,`ListPrice` = '978378.00' ,`Status` = 'Active' ,`StreetName` = 'Heartleaf Aster' ,`StreetNumber` = '11122' ,`StreetSuffix` = 'Way' ,`City` = 'Cypress' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4325' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is THE ONE with the COURTYARD - Newmark Homes VENETIAN plan in Bridgeland. This MODERN 70\' floor plan offers everything the master planned community home buyer is looking for! 5 beds (2 down), 5.5 baths, living, formal dining, mud room, loft, game room, media room, and a FOUR car garage. This is the one you\'ve heard about, modern, sleek, and elegant. Come see this home before it sells... because it will soon!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '29/01/06' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11195' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.637885' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091431' WHERE `Matrix_Unique_ID` = '212272892' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T15:21:06.333' ,`MLSNumber` = '23846369' ,`ListAgentFullName` = 'Pam Holmes' ,`ListOfficeName` = 'Texas Premier Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.714146' ,`Longitude` = '-95.061400' ,`PhotoCount` = '5' ,`PostalCode` = '77351' ,`RoomCount` = '8' ,`ListPrice` = '287500.00' ,`Status` = 'Active' ,`StreetName` = 'Village Cove' ,`StreetNumber` = '118' ,`StreetSuffix` = 'Loop' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This NEW CONSTRUCTION, 1,611+- SF, 3/2, with a 2 car attached garage offers some great neighborhood amenities. You have access to a private boat launch, community pool and a clubhouse. This open concept home also boasts luxury vinyl flooring, granite counter tops and stainless steel appliances. Stay tuned!! Estimated completion date will be October 2022.' ,`Acres` = '0.186' ,`Area` = '44' ,`BuilderName` = 'Tennalyle Properties' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE LIVINGSTON VILLAGE SECTION 12 LOT 38' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '24' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Livingston Village Sectio' ,`TaxAmount` = '152' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1675091431' WHERE `Matrix_Unique_ID` = '213255236' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T16:53:27.437' ,`MLSNumber` = '37501265' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.026861' ,`Longitude` = '-95.845856' ,`PhotoCount` = '17' ,`PostalCode` = '77447' ,`RoomCount` = '17' ,`ListPrice` = '489960.00' ,`Status` = 'Active' ,`StreetName` = 'Will Park' ,`StreetNumber` = '16003' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3626' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated on a spacious lot, this home boasts a stone elevation, luxury vinyl plank flooring, wrought iron spindles, game room, large media room, and an extended covered patio. Enjoy the convenience of bedroom #2 located downstairs with its own private full bath.The open concept island kitchen comes fully equipped with Omegastone countertops, tile backsplash, 30\" gas cooktop and stainless steel appliances. Spend your evenings relaxing in the primary suite, complete with a bay window, a walk-in closet, dual vanities, a luxury spa shower. Call now or visit us this weekend!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 30 Block 1 Section 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9169' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'I T HOLLEMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091432' WHERE `Matrix_Unique_ID` = '213392418' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T15:51:34.147' ,`MLSNumber` = '46844609' ,`ListAgentFullName` = 'Iliana Sanchez' ,`ListOfficeName` = 'NuWay Realty Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.234708' ,`Longitude` = '-95.404329' ,`PhotoCount` = '10' ,`PostalCode` = '77302' ,`RoomCount` = '3' ,`ListPrice` = '219995.00' ,`Status` = 'Active' ,`StreetName` = 'Long' ,`StreetNumber` = '11482' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT OPPORTUNITY TO BUILD YOUR DREAM HOME! Schedule your showing today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'S700011 - MAGNOLIA BEND 11, BLOCK 1, LOT 35-36' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20885' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Bend 11' ,`TaxAmount` = '1992' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091432' WHERE `Matrix_Unique_ID` = '213767474' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T15:15:34.670' ,`MLSNumber` = '29326964' ,`ListAgentFullName` = 'Lauren Mendoza' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.380790' ,`Longitude` = '-94.764362' ,`PhotoCount` = '6' ,`PostalCode` = '77650' ,`RoomCount` = '7' ,`ListPrice` = '799900.00' ,`Status` = 'Active' ,`StreetName` = 'Royalville' ,`StreetNumber` = '1982' ,`StreetSuffix` = 'Court' ,`City` = 'Crystal Beach' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1970' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here is the one! Another Luxury Home by August Design & Construction. This 4 bed, 3.5 bath beauty is located in Crystal Beach Estates with stunning views. On ground level you\'ll find enclosed cargo lift, 36\' x 12\' garage with roll up door and bar for cabana area, sand shower, and nice size back yard. All painted/stained exterior with custom LED lighting in stairs and around deck featuring tempered glass railing. As you step inside you\'ll appreciate the vaulted ceiling with custom dormer windows bringing in tons of natural light. White Oak Vanity Cabinets, White Oak stair treads & risers, & White Oak ceiling cladding in the vaulted living area. Custom Designer selected lighting throughout. As you walk through this home, you\'ll find that the builder has spared no expense to create another one of a kind home. Book today to get a private tour as this one will be ready for a January move-in date!' ,`Acres` = '0.1637' ,`Area` = '33' ,`BuilderName` = 'See Agent Remarks' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Port Bolivar' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 16 BLK 1 CRYSTAL BEACH ESTATES (2021) ABST 179' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '7132' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Crystal Beach Estates' ,`TaxAmount` = '919' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091432' WHERE `Matrix_Unique_ID` = '214993117' --> 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','215268031','1675091432','215268031','2022-12-15T16:22:27.623','61027257','Melissa Granberry','C & K Properties','','','29.734227','-95.452002','43','77027','12','2450000.00','Active','Staunton','4506','','Houston','5','1','5','4947','Single-Family','Beautiful new construction by Laird Custom Homes in highly desirable Afton Oaks! This brick home offers 5 bedrooms, including one downstairs, and all ensuite. First floor has large foyer with custom iron doors, formal dining, study, walk-in pantry, mud room, bar/butler\'s pantry, & island kitchen open to the family room and breakfast area. Kitchen features quartz countertops & backsplash, farmhouse sink, Miele appliances, wine tower, soft-close cabinets/drawers & under cabinet lighting. Covered back lanai with 36\" gas grill, recessed lighting & ceiling fan. Upstairs the primary bed has raised ceilings, 2 WICs with built ins, ensuite bath w/ marble floors and quartz countertops. 3 additional bedrooms up w/ ensuite baths & WICs. Game room features wet bar w/ quartz counters & 24\" beverage cooler. Laundry up, elevator capable. Prewired for speakers & cameras. Experience inner loop living near fine shopping & dining, while enjoying AO\'s beautiful boulevards and green space! *All per seller','','16','Laird Custom Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Gaslog Fireplace','1','Royden Oaks/Afton Oaks','Central Gas,Zoned','1','LT 10 & TR11A BLK 11','Subdivision Lot','8260','Appraisal District','','800','1','To Be Built/Under Construction','2','Convection Oven,Double Oven,Freestanding Oven','0','','','Freestanding Range,Gas Range','','Composition','27 - Houston','SCHOOL AT ST GEORGE PLACE','LAMAR HIGH SCHOOL (HOUSTON)','LANIER MIDDLE SCHOOL','Accompany,Appointment Required','Builder','2','Traditional','Afton Oaks','','','Public Sewer,Public Water','2023','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','215390922','1675091432','215390922','2022-12-15T16:30:27.030','59477063','Kelechi Okeadu','eXp Realty, LLC','','','29.665158','-95.323955','10','77033','3','125000.00','Active','Belbay st','7826','','Houston','1','0','3','1062','Single-Family','','','3','','','','','No Disclosures','','','','Medical Center South','Central Electric','0','Belfort Park','Subdivision Lot','7200','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','ALCOTT ELEMENTARY SCHOOL','STERLING HIGH SCHOOL (HOUSTON)','ATTUCKS MIDDLE SCHOOL','Accompany,Leave Business Card,Lockbox Front,Temporarily No Showings','Appraisal District','1','Traditional','Belfort park','','','Public Sewer,Public Water','1955','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','215482220','1675091432','215482220','2022-12-15T16:03:17.610','30764714','Ethan Cameron','Cameron Real Estate','','','30.309580','-94.984618','16','77327','8','489900.00','Active','FM 163','4137','Road','Cleveland','2','0','3','2044','Single-Family','Recently renovated 3bdr/2ba home with separate guest apartment located in Tarkington ISD! \r\n2-car detached garage with nice garage apartment above. Long driveway leads up to the home which sits on 1.62 unrestricted acres! Light & bright kitchen with beautiful apron sink. Living area with tons of natural light and wood ceiling accent beams. Gorgeous laminate floors throughout. Primary bedroom with ensuite bath featuring double sinks, tub/shower combo and large walk-in closet.','1.62','52','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Cleveland Area','Central Electric','0','000354 B TARKINGTON, TRACT 145 275, ACRES 1.62','Cleared','70567','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Aluminum','102 - Tarkington','TARKINGTON PRIMARY SCHOOL','TARKINGTON HIGH SCHOOL','TARKINGTON MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','000354 B TARKINGTON','','1.412436','Aerobic,Well','1945','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','215506688','1675091432','215506688','2022-12-15T15:43:06.880','15515008','Jimmie Campbell','RE/MAX Fine Properties','','','29.661529','-95.361219','39','77051','6','194900.00','Active','Larkspur','4413','Street','Houston','2','0','2','1894','Single-Family','This property is ready for move-in and is in very good condition recently painted, nice upgrades, pier & beams replaced under laminate flooring, spacious rooms, large kitchen w/beautiful cabinetry plus nice breakfast area, refrigerator can remain, pretty formal dining room, this house features two bedrooms w/option of 3rd bedroom w/ full bath or game room. Indoor utility room w/washer & dryer! Two car covered carport. House sits on 2 lots, the lot\r\nthat the house sits on is lot 16 is a part of the sale. Lot 17 is not a part of the sale.','0.2319','3','','','Electric Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','0','','','Medical Center South','Central Gas','0','LTS 16 & 17 BLK 2 FLOWER CITY','Subdivision Lot','10100','Appraisal District','','','0','','0','Electric Oven','0','','','Freestanding Range','','Composition','27 - Houston','BASTIAN ELEMENTARY SCHOOL','WORTHING HIGH SCHOOL','ATTUCKS MIDDLE SCHOOL','Appointment Required,Leave Business Card,No Supra Keybox','Appraisal District','1','Other Style','Flower City','2420','2.3307','Public Sewer,Public Water','1960','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','215647966','1675091432','215647966','2022-12-15T16:56:34.553','80048044','Gay Fundling','Galveston Island Real Estate','','','29.128894','-95.068970','41','77554','6','600000.00','Active','2nd','3919','Street','Galveston','2','2','3','1640','Single-Family','\"Bay Harbor Big House\" Named for the large open concept home that sits on a 1.377 acre fenced in raised lot. Beach and bay views from the covered decks. Like a ranch just steps from the ocean. Main floor has 3 bedrooms, 2 baths, breakfast bar, breakfast nook. 1600 sq ft ground level closed in with 2 baths and separate shower. Set up to entertain the extended family inside, outside, shaded and in the sun. Can be used as a special occasion venue. Plenty of room for most sports - very popular with volleyball players. Updated in 2005. Successful vacation rental.','1.3774','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','West End','Central Electric','0','ABST 121 HALL & JONES SUR LOT 42 & N 1/2 OF LOT 40 BAY HARBO','Cleared,Greenbelt,Other,Subdivision Lot,Water View','60000','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Controlled Access,Lockbox Front,Request Online Appointment','Appraisal District','1','Traditional','Bay Harbor','6996','2.2215','Public Water,Septic Tank','1956','Appraisal District'); --> New record created successfully