Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:22:02.090' ,`MLSNumber` = '63517037' ,`ListAgentFullName` = 'Beverly Berry' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = 'Lee Kaplan' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.724502' ,`Longitude` = '-95.439040' ,`PhotoCount` = '39' ,`PostalCode` = '77005' ,`RoomCount` = '10' ,`ListPrice` = '1595000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Drake' ,`StreetNumber` = '3819' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite contemporary home which has been featured in AIA Home tour in 2008. Custom built, 2nd owner. Resort-style home featuring operable window walls showcasing visual and physical connection between interior and exterior space bringing the outdoors in. More features include a gourmet kitchen with commercial grade appliances, including full size SubZero dual wine coolers with temperature controls, an elevator, a Generac Generator and bamboo and plank slate flooring. 2-story guest house (653 sq.ft. per Appraisal) has a separate entrance from the main house by a covered breezeway. It includes a large 1st floor living, kitchen, and bathrm & 2nd fl. bedrm & access to pool. Outdoor space is peaceful with heated saltwater pool and spa, surround sound speakers, and outdoor living. West University Elementary (Buyer must verify eligibility for attendance). All per Seller.' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = 'StudioMet' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Electric,Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 8 MONTCLAIR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8313' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Montclair' ,`TaxAmount` = '39621' ,`TaxRate` = '2.52923' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054908' WHERE `Matrix_Unique_ID` = '205924018' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:56:19.133' ,`MLSNumber` = '70070089' ,`ListAgentFullName` = 'Setha Ponce' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.869961' ,`Longitude` = '-95.076775' ,`PhotoCount` = '25' ,`PostalCode` = '77360' ,`RoomCount` = '7' ,`ListPrice` = '69000.00' ,`Status` = 'Active' ,`StreetName` = 'Park' ,`StreetNumber` = '149' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1496' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3/2 home on almost .5 acre corner lot. Roof and septic are both fairly new. This home needs a lot of TLC but would make a great project for an investor or anyone who loves to hunt and fish. This land is beautiful and feels very secluded without being too far out. Come out and see for yourself what this land has to offer.' ,`Acres` = '0.4183' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '1' ,`Legal` = 'SPORTSMAN RETREAT LOT 443 & 444' ,`LotDesciption` = 'Cleared,Corner,Water View,Wooded' ,`LotSize` = '18222' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '25' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Sportsman Retreat' ,`TaxAmount` = '1461' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054908' WHERE `Matrix_Unique_ID` = '208981240' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:34:23.923' ,`MLSNumber` = '94138279' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = 'Adekunle Amoo' ,`SellingOfficeName` = 'Fairdale Realty' ,`Latitude` = '29.834775' ,`Longitude` = '-95.855939' ,`PhotoCount` = '23' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '430937.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Catalina Cove' ,`StreetNumber` = '237' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2843' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story Dakota Floorplan by CastleRock in Sunterra with BALCONY & LAGOON VIEW! 5 bedrooms, study, 3.5 baths, and 2 car garage. Soaring high ceilings, huge family great room with open kitchen and dining. Covered front porch & HUGE 17x16 covered rear porch! Elegant designer colors and options including luxury vinyl flooring in all main living areas, full blinds, upgraded cabinets, and much more! Can close in Aug/Sep! Sunterra Community features 3.5 acres of Crystal Blue Lagoon with white sand beaches, palm trees, cabanas, watercraft rentals of kayaks, paddle boards, etc, and clubhouse, event center, swim-up beach bar, swimming pool, and splash pad all in Amazing Katy ISD! Close to everything!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 43, Block 1, Section 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669054908' WHERE `Matrix_Unique_ID` = '209723422' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:16:05.420' ,`MLSNumber` = '13414936' ,`ListAgentFullName` = 'Noel Mosher' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.165775' ,`Longitude` = '-95.437800' ,`PhotoCount` = '11' ,`PostalCode` = '77515' ,`RoomCount` = '6' ,`ListPrice` = '263400.00' ,`Status` = 'Active' ,`StreetName` = 'Bryan Way' ,`StreetNumber` = '240' ,`StreetSuffix` = '' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1717' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One story 1717 sq.ft with tall ceilings with 2 car garage. 4 sides brick with Covered Back Patio. 3 bedrooms and 2 full baths. Coffered ceilings in Family and Primary bedroom. Dining room has a bay window. Granite kitchen with deep under mount sink and 36\" cabinets with crown molding. Stainless steel 5 burner gas range, microwave, dishwasher, 2\" blinds included!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Adama Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = '0/0/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '281' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kiber Reserve' ,`TaxAmount` = '' ,`TaxRate` = '2.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669054909' WHERE `Matrix_Unique_ID` = '210031871' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:21:22.220' ,`MLSNumber` = '80974425' ,`ListAgentFullName` = 'Noel Mosher' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.157201' ,`Longitude` = '-95.396646' ,`PhotoCount` = '9' ,`PostalCode` = '77515' ,`RoomCount` = '5' ,`ListPrice` = '251900.00' ,`Status` = 'Active' ,`StreetName` = 'Bryan Way' ,`StreetNumber` = '300' ,`StreetSuffix` = '' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1525' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One story 1525 sq.ft with tall ceilings with 2 car garage. 4 sides brick with covered back patio. 3 bedrooms and 2 full baths. Coffered ceilings in Primary bedroom. Granite kitchen with deep under mount sink and 36\" cabinets with crown molding. Stainless steel Frigidaire, 5 burner gas range, microwave, dishwasher, 2\" blinds included!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Adams Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '0/0/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '261' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kiber Reserve' ,`TaxAmount` = '' ,`TaxRate` = '2.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669054909' WHERE `Matrix_Unique_ID` = '210033576' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:15:29.297' ,`MLSNumber` = '89788459' ,`ListAgentFullName` = 'Noel Mosher' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.165775' ,`Longitude` = '-95.437800' ,`PhotoCount` = '9' ,`PostalCode` = '77515' ,`RoomCount` = '7' ,`ListPrice` = '266900.00' ,`Status` = 'Active' ,`StreetName` = 'Bryan Way' ,`StreetNumber` = '308' ,`StreetSuffix` = '' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One story 1820 sq.ft with tall ceilings with 2 car garage. 4 sides brick with covered back patio. 3 bedrooms and 2 full baths. Coffered ceilings in Primary bedroom. Granite kitchen with deep under mount sink and 36\" cabinets with crown molding. Stainless steel 5 burner gas range, microwave, dishwasher, 2\" blinds included! Ceramic Tile and carpet floors.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Adama Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = '0/0/0' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '281' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kiber Reserve' ,`TaxAmount` = '' ,`TaxRate` = '2.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669054909' WHERE `Matrix_Unique_ID` = '210034029' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:51:27.203' ,`MLSNumber` = '50133564' ,`ListAgentFullName` = 'Gary Schero' ,`ListOfficeName` = 'BHGRE Gary GreeneGalveston In Town' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.275934' ,`Longitude` = '-94.816006' ,`PhotoCount` = '32' ,`PostalCode` = '77551' ,`RoomCount` = '7' ,`ListPrice` = '569999.00' ,`Status` = 'Active' ,`StreetName` = 'Sherman' ,`StreetNumber` = '4811' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2556' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pristine Denver Court home just a block from the beach, recent impact windows, large family room featuring parquet floors, formal living and dining rooms, updated kitchen with Quartz countertops and Saltillo tile flooring, Hardwood floors throughout the rest of the house, Zoned HVAC, cozy covered porch overlooking the tropically landscaped backyard with numerous fruit trees (key lime, plantains, figs, bananas, and a bay tree). Favorable flood zone.' ,`Acres` = '0.1536' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 5 BLK 8 DENVER COURT & ADJ 8 FT' ,`LotDesciption` = 'Other' ,`LotSize` = '6692' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Denver Court' ,`TaxAmount` = '6494' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054909' WHERE `Matrix_Unique_ID` = '210126896' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:11:24.857' ,`MLSNumber` = '5429421' ,`ListAgentFullName` = 'Rashad Garrett' ,`ListOfficeName` = 'Brooks & Davis Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.444847' ,`Longitude` = '-95.440475' ,`PhotoCount` = '6' ,`PostalCode` = '77583' ,`RoomCount` = '2' ,`ListPrice` = '249999.00' ,`Status` = 'Active' ,`StreetName` = 'Peridot Green' ,`StreetNumber` = '9419' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1659' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1401' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'STERLING LAKES AT IOWA COLONY SEC 9 (A0289 HT&B) BLK 1 LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6103' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Lakes At Iowa Colony' ,`TaxAmount` = '5989' ,`TaxRate` = '3.4099' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054909' WHERE `Matrix_Unique_ID` = '210131416' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:27:44.040' ,`MLSNumber` = '80813235' ,`ListAgentFullName` = 'Valentina Marquez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.796920' ,`Longitude` = '-95.306348' ,`PhotoCount` = '19' ,`PostalCode` = '77026' ,`RoomCount` = '5' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Crane' ,`StreetNumber` = '6302' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1288' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1 story home, recently remodel kitchen offers granite countertops and new cabinets. Home has new laminate floors, and water proof vinyl floors in the kitchen and bathroom. detach garage with door opener. Short commute to downtown, hospital and parks nearby.' ,`Acres` = '0.124' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 188 BLK 10 LIBERTY GARDENS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ISAACS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Liberty Gardens Sec 01' ,`TaxAmount` = '1836' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054910' WHERE `Matrix_Unique_ID` = '210189554' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:31:45.613' ,`MLSNumber` = '25715847' ,`ListAgentFullName` = 'Louise Farmer' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.015068' ,`Longitude` = '-95.150716' ,`PhotoCount` = '38' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '529000.00' ,`Status` = 'Active' ,`StreetName` = 'Atascocita Shores' ,`StreetNumber` = '20323' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2516' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Awesome Custom Built home with all the bells and whistles, on the golf course with beautiful rot iron fence, 4 bedrooms or 1 can be a study, open floor plan with wood floors, 2/1 baths with granite counters, master has sep.\r\nshower and tub. The family room has a central vac floor plug and a beautiful electric fireplace. The kitchen has glass doors on the cabinets, all stainless steel app, wine fridge included. The breakfast room is very large. The patio deck and front porch have a cedar ceiling. All windows have custom shutters, the lawn has a full sprinkler system and lights in front flower beds. Subdivision offers homeowners a private boat launch. This home has a low tax rate.' ,`Acres` = '0.261' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 70 BLK 12 PINEHURST OF ATASCOCITA SEC 2' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '11371' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '618' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinehurst Atascocita Sec 02' ,`TaxAmount` = '7277' ,`TaxRate` = '2.216' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054910' WHERE `Matrix_Unique_ID` = '211172873' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:01:04.277' ,`MLSNumber` = '39571652' ,`ListAgentFullName` = 'Lauren Teare' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Kristen Zagoren' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.713594' ,`Longitude` = '-95.446732' ,`PhotoCount` = '31' ,`PostalCode` = '77005' ,`RoomCount` = '15' ,`ListPrice` = '1350000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Swarthmore' ,`StreetNumber` = '4235' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home located blocks from Colonial Park and Pool on a corner lot. Custom built in 1996 by the prior owners, this lovely 4 bedroom, 3.5 bath home has great updates throughout. Features spacious formal dining and living rooms with high ceilings and built-ins, a playroom upstairs, spacious kitchen that opens to family room, a breakfast room that overlooks the backyard. Primary suite has a remodeled bath with a soaking tub, separate shower, dual sinks, nice storage space and a walk-in closet. Beautiful hardwoods throughout. Updates also include a custom wine vault, remodeled half bath and an outdoor patio with a fireplace and summer kitchen. New roof (2019). Easy access to downtown, Texas Medical Center, Greenway Plaza, Rice University and the Westpark Tollway.' ,`Acres` = '0.1148' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 10 COLONIAL TERRACE' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Colonial Terrace' ,`TaxAmount` = '22167' ,`TaxRate` = '2.1629' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054910' WHERE `Matrix_Unique_ID` = '211222218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:47:18.147' ,`MLSNumber` = '61433508' ,`ListAgentFullName` = 'Juliana Swisher' ,`ListOfficeName` = 'South Haus Living, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.734968' ,`Longitude` = '-95.412664' ,`PhotoCount` = '6' ,`PostalCode` = '77098' ,`RoomCount` = '4' ,`ListPrice` = '1819000.00' ,`Status` = 'Active' ,`StreetName` = 'Colquitt' ,`StreetNumber` = '2147' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4042' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning home in the Upper Kirby area is currently under construction. The interior will feature four spacious bedrooms up - all ensuite, luxe finishes, and a well-thought-out floor plan. Formal dining and living area, along with an open concept kitchen, and grand family room with high ceilings and lovely natural light. The home is situated on a fabulous size lot, offering you ample backyard space to relax, and entertain AND a pool to enjoy. Located in a neighborhood with great walkability, excellent public and private schools nearby, and a stone\'s throw to dining and shopping. Framing and drywall completed as of 11/07. Estimated completion Jan 2023. Inquire for details.' ,`Acres` = '0.2152' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Upper Kirby' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 & TR 11 BLK 5 WESTLAWN TERRACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '9375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Westlawn Terrace' ,`TaxAmount` = '17212' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1935' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054910' WHERE `Matrix_Unique_ID` = '212227788' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:48:50.753' ,`MLSNumber` = '24515677' ,`ListAgentFullName` = 'Kelsey Casey' ,`ListOfficeName` = 'Realty ONE Group Iconic' ,`SellingAgentFullName` = 'Melanie Aubrey' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.338738' ,`Longitude` = '-95.511235' ,`PhotoCount` = '43' ,`PostalCode` = '77304' ,`RoomCount` = '8' ,`ListPrice` = '324900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Elkington' ,`StreetNumber` = '1911' ,`StreetSuffix` = 'Circle' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2884' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This two-story home, located in the community of Wedgewood Falls, features 3 bedrooms, 2.5 baths, a downstairs study, upstairs game room/ flex room, and an open concept living/dining area! This home boasts multiple upgrades throughout, including but not limited to, fresh paint, brand new carpet in the main living areas upstairs, upgraded flooring in all bedrooms, a French drain located in backyard, and many more! Please see attached property highlight and upgrade document for the full list. Enjoy the pond view from the over-sized covered patio and quick access to the pond through the added gate on the back fence. Location! Location! Location! Take advantage of the easy access to I-45, SH 105, Lake Conroe, and all of the nearby grocery stores, restaurants and shops. The West Fork Golf Course and Club is located just minutes away. Zoned to the highly rated Conroe ISD!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Wedgewood Falls 01, BLOCK 3, Lot 3' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '5999' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '665' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wedgewood Falls' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669054911' WHERE `Matrix_Unique_ID` = '212293648' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:19:03.250' ,`MLSNumber` = '69004531' ,`ListAgentFullName` = 'Clinton Omiwade' ,`ListOfficeName` = 'ERA Legacy Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.436982' ,`Longitude` = '-95.486896' ,`PhotoCount` = '39' ,`PostalCode` = '77378' ,`RoomCount` = '3' ,`ListPrice` = '264999.00' ,`Status` = 'Active' ,`StreetName` = 'Brooklyn Mead' ,`StreetNumber` = '13536' ,`StreetSuffix` = 'Lane' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1656' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous two-story, 1656 sqft home in a great location ! This home features beautiful wood , and carpet floors through the whole house, stunning front entry with large beautiful kitchen, stunning countertops and so much more! Very spacious Main Living area With great Flooring. Large Sized Kitchen with a Open Concept. 2-car garage. Large backyard. House has been extensively taken care of. Located close to multiple grocery options , schools , highways. You will be hard-pressed to find this unique open floor plan in this neighborhood. This home has everything you could ever want! This gem will not last long - schedule a showing. This home is fitted with solar panels. NO LIGHT BILL! If you use our preferred lender , we are able to offer a lower interest rate . ' ,`Acres` = '0.0917' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willis Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S888400 - SOUTH MEADOWS AMENDING PLAT NO 1, BLOCK 3, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3994' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'C.C. HARDY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'South Meadows Amd 1' ,`TaxAmount` = '2474' ,`TaxRate` = '2.4131' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054911' WHERE `Matrix_Unique_ID` = '212554037' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:45:18.823' ,`MLSNumber` = '61199483' ,`ListAgentFullName` = 'Lee Hudman' ,`ListOfficeName` = 'PRG, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.752624' ,`Longitude` = '-95.391248' ,`PhotoCount` = '43' ,`PostalCode` = '77006' ,`RoomCount` = '6' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Peden' ,`StreetNumber` = '1012' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1519' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'English cottage style art deco jewel box on one of the best blocks in East Montrose. Featured twice on East Montrose Biennial Home Tour. High ceilings, art deco touches, vaulted living room w/ cloud ceiling & hidden lighting & WBFP, octagon shaped fir down dining room w/ cloud ceiling. Spacious den w/ surround sound & hidden storage. Large eat-in kitchen w/ lots of cabinets & counter space. Multiple glass pocket doors, incredible main bath w/ large spa tub. 25 windows, w/ most having blackout cellular up/down shades. Two large closets w/ storage & drawers in the main bedroom. Side deck & back screened-in porch. HVAC system & roof replaced in 2015. Tankless water heater. PEX piping. Hurricane film on windows & glass doors. Deco style wood floors or tile - no carpet! All appliances stay. Garage w/ 2nd story storage is sold as is. Mostly fresh interior neutral paint. The backyard is large enough for a pool. Plus more features and location location location!' ,`Acres` = '0.1429' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 1A & B1 BLK 11 ROSEMONT HEIGHTS EXTN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6223' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Built Up,Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WILLIAM WHARTON K-8 DUAL LANGUAGE ACADEMY' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'GREGORY-LINCOLN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,No Supra Keybox,Temporarily No Showings,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rosemont Heights Ext' ,`TaxAmount` = '13818' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054911' WHERE `Matrix_Unique_ID` = '212782440' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:44:13.847' ,`MLSNumber` = '28857572' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.751011' ,`Longitude` = '-95.872017' ,`PhotoCount` = '35' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Davenport' ,`StreetNumber` = '29110' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3478' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two story home located in the premier master-planned community of Firethorne! Features include a lovely stone & brick facade with covered front porch, open-concept design, private home office, formal dining, soaring ceilings in the family room, 5 bedrooms (2 downstairs), 4 full baths, covered back patio & 3 car garage. Hardwood floors extend through the 1st floor, staircase & gameroom. The kitchen boasts double ovens, a 5 burner gas cooktop, large island, white cabinetry & sleek countertops. The family room has a floor-to-ceiling stone fireplace & a built-in serving bar. The primary suite features wood-look tile flooring & a luxurious bathroom. Covered outdoor living has a gas connection for a grill or future outdoor kitchen. Epoxy coating on garage floor. Solar panels provide energy savings. Numerous community amenities include a pool, competitive swim center, pickle ball courts, fitness center, clubhouse, lakes & more. Walking distance to the elementary school.' ,`Acres` = '0.168' ,`Area` = '30' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FIRETHORNE WEST SEC 10, BLOCK 3, LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7316' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Firethorne West' ,`TaxAmount` = '9254' ,`TaxRate` = '2.5848' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054911' WHERE `Matrix_Unique_ID` = '212969117' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:58:01.030' ,`MLSNumber` = '14860653' ,`ListAgentFullName` = 'Shelby Forbert' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947631' ,`Longitude` = '-95.689836' ,`PhotoCount` = '37' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '599999.00' ,`Status` = 'Active' ,`StreetName` = 'Texas Wildflower' ,`StreetNumber` = '18007' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2941' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICE IMPROVEMENT!! Your search is over! Welcome to 18007 Texas Wildflower situated in the Award Winning Master Community of TOWNE LAKE! This Incredible 1.5 story home offers a spacious/open floor plan with 4beds/3baths/2car garage. Built in 2021 by Village Builders & Excellently designed with High Ceilings, Large windows, Granite countertops, Frigidaire appliances, Crown Moulding, and much more! ‘Better Than New\' with Custom Drapes, and Shutters to block out the TX heat! Also features a Chef\'s Gourmet Island Kitchen & a Gorgeous Dining room surrounded by Windows with Ample Natural Light over looking the Backyard & Extended Covered Patio. Enjoy family time in the Generous Living room downstairs or Large Game room upstairs! Unwind in the Private Master Suite w/ Tub&Separate Shower, Dual sinks, & Large Walk-in Closet. Unrivaled Amenities including a Beach, Waterpark, Boardwalk where you can BOAT to dinner, Lazy River & MORE! A True STAYCATION Home! Zoned to TOP RATED Schools!' ,`Acres` = '0.1846' ,`Area` = '25' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 1 TOWNE LAKE SEC 56' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8043' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1674' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Towne Lake' ,`TaxAmount` = '2464' ,`TaxRate` = '3.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669054911' WHERE `Matrix_Unique_ID` = '213011286' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:20:11.997' ,`MLSNumber` = '61019946' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518568' ,`Longitude` = '-95.783957' ,`PhotoCount` = '6' ,`PostalCode` = '77471' ,`RoomCount` = '8' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Shadow Crest' ,`StreetNumber` = '3721' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2086' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Wildflower Collection \"Hanover II\" Plan with Elevation \"A\" in Sendero! This single-story home has a modern open living area that invites gathering, along with a covered patio for outdoor leisure. Two bedrooms and a study offer versatility near the entry, while the owner’s suite is tucked in the back corner for added privacy, complete with a luxe bathroom and walk-in closet. *HOME ESTIMATED TO BE COMPLETE, FEBRUARY, 2023*' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0006 BLK 001 LOT 029' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '756' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sendero' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669054912' WHERE `Matrix_Unique_ID` = '213069156' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:09:29.827' ,`MLSNumber` = '57924290' ,`ListAgentFullName` = 'Edgardo Martinez' ,`ListOfficeName` = 'Lucky Money Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.060846' ,`Longitude` = '-95.363882' ,`PhotoCount` = '44' ,`PostalCode` = '77373' ,`RoomCount` = '9' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Hurst' ,`StreetNumber` = '5023' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your search ends here! Beautiful 2 story house in Spring! Formal dining room has chair railing & upgraded light fixture. Open floor plan, includes formal dining room, Media Room, HUGE Game room, and Study. Kitchen has 42” cabinets, SS appliances, breakfast bar. Great family room with gas log fireplace. Large master bedroom down w/walk-in closet, dual sinks, garden tub & separate shower. 5th bedroom optional as study. Secondary bedrooms have large closets & large second full bath. Double Pane windows & Tech Shield. Conveniently located near Hardy Toll Rd, Grand Parkway, I-45, I-59, and George Bush international Airport.' ,`Acres` = '0.1205' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 4 FOREST POINT AT CYPRESSWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Forest Point/Cypresswood' ,`TaxAmount` = '6870' ,`TaxRate` = '2.8117' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054912' WHERE `Matrix_Unique_ID` = '213187770' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:18:56.073' ,`MLSNumber` = '4552878' ,`ListAgentFullName` = 'Noel Mosher' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.165775' ,`Longitude` = '-95.437800' ,`PhotoCount` = '8' ,`PostalCode` = '77515' ,`RoomCount` = '5' ,`ListPrice` = '251900.00' ,`Status` = 'Active' ,`StreetName` = 'Lago' ,`StreetNumber` = '9' ,`StreetSuffix` = 'Court' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1525' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegant, One story home is waiting to be yours. This charming home offers a stunning long front entrance, open concept floor plan, high ceilings, spacious kitchen overlooking the living room. The kitchen is surrounded with tall cabinets, granite countertops, backsplash, and a stainless steel under-mound sink. Included Frigidaire stainless steel electric range, dishwasher, and microwave and a walk in pantry. This 3 bedroom 2 bath has roomy bedrooms, walk in closets, spacious private commode bathrooms, with double sinks. Master suite boasts soaring ceiling, separate tub and shower with tile surround and double vanities. Energy efficient 16 seer HVAC, programmable digital thermostat. Large back patio. Inside windows have faux wood blinds is included.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Adams Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = '17-2-2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '281' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kiber Reserve' ,`TaxAmount` = '' ,`TaxRate` = '2.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669054912' WHERE `Matrix_Unique_ID` = '213205324' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:13:38.160' ,`MLSNumber` = '38932047' ,`ListAgentFullName` = 'Noel Mosher' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.165775' ,`Longitude` = '-95.437800' ,`PhotoCount` = '8' ,`PostalCode` = '77515' ,`RoomCount` = '7' ,`ListPrice` = '298900.00' ,`Status` = 'Active' ,`StreetName` = 'Lago' ,`StreetNumber` = '7' ,`StreetSuffix` = 'Court' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2227' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegant, Two story home is waiting to be yours. This charming home offers a stunning long front entrance, open concept floor plan, high ceilings, spacious kitchen overlooking the living room. The kitchen is surrounded with tall cabinets, granite countertops, backsplash, and a stainless steel under-mound sink. Included Frigidaire stainless steel electric range, dishwasher, and microwave and a walk in pantry. This 4 bedroom 2 and Half bath has roomy bedrooms, walk in closets, spacious private commode bathrooms, with double sinks. Master suite boasts soaring ceiling, separate tub and shower with tile surround and double vanities. Energy efficient 16 seer HVAC, programmable digital thermostat. Covered patio. Inside windows have faux wood blinds is included.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Adams Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = '15-2-2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '280' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kiber Reserve' ,`TaxAmount` = '' ,`TaxRate` = '2.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669054912' WHERE `Matrix_Unique_ID` = '213205947' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:10:58.073' ,`MLSNumber` = '34351390' ,`ListAgentFullName` = 'Rachael Garnett' ,`ListOfficeName` = 'Malone Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.660311' ,`Longitude` = '-95.129953' ,`PhotoCount` = '50' ,`PostalCode` = '77331' ,`RoomCount` = '8' ,`ListPrice` = '849000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Harbour' ,`StreetNumber` = '221' ,`StreetSuffix` = 'Drive' ,`City` = 'Coldspring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3822' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LAKE FRONT GET-A-WAY! Located in the gated community of Cape Royale, this gorgeous home sits on over half an acre of beautiful Lake Livingston. The perfect spot for rest & relaxation, or an exciting adventure. Large circular driveway shaded with mature trees & plush landscaping. Open concept kitchen/living/dining. Two secondary bedrooms are on the second floor with a full bath. One bedroom below, could be a second primary, with patio access. The primary retreat has a wall of windows with the en-suite bath offering dual sinks, free-standing shower, large jetted tub and a huge walk-in closet. Study opposite of primary retreat with half bath and w/i closet (can be a 5th bedroom). Upstairs game room includes a fireplace & wet bar. Decking across entire back of home, with tons of shaded areas and a fenced yard. Boat house with boat/jet ski lifts. Firepit situated for perfect lake views near the bulkhead. Located on a calm canal, just seconds from open water.' ,`Acres` = '0.6082' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CAPE ROYALE - PINE HARBOUR, BLOCK 6, LOT 42, ACRES .6082' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '26493' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Cape Royale Pine Harbour' ,`TaxAmount` = '10736' ,`TaxRate` = '2.0554' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054913' WHERE `Matrix_Unique_ID` = '213274931' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:03:25.670' ,`MLSNumber` = '6160935' ,`ListAgentFullName` = 'Wesley Jurena' ,`ListOfficeName` = 'Texas Legacy Properties' ,`SellingAgentFullName` = 'Steven Kleiman' ,`SellingOfficeName` = 'Oakington Realty' ,`Latitude` = '29.659587' ,`Longitude` = '-95.486254' ,`PhotoCount` = '36' ,`PostalCode` = '77096' ,`RoomCount` = '10' ,`ListPrice` = '499500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sanford' ,`StreetNumber` = '5631' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2270' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to another beautiful remodel by Crew Ventures! This impressive Westbury home is in a great neighborhood with wide tree lined streets. Extensively remodeled with designer touches this home offers an open floor plan throughout the kitchen and living are, a beautiful butcher block island and laundry room. Also includes a private office or flex space. So much new, to include paint inside and out, windows, stainless steel appliances, cabinets throughout, quartz counter tops, laminate and tile flooring. New pex plumbing and fixtures, new electrical panel and wiring and fresh landscape. Zoned to Parker Elementary with Westbury Park and pool in the neighborhood. Easy access to 610, Galleria and the Medical Center. This home has never flooded and is in Zone X, no mandatory flood insurance. Schedule your showing today!' ,`Acres` = '0.2287' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 188 WESTBURY SEC 5 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbury Sec 05 R/P' ,`TaxAmount` = '6721' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054913' WHERE `Matrix_Unique_ID` = '213453445' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:39:49.170' ,`MLSNumber` = '98546242' ,`ListAgentFullName` = 'Troy Tomlinson' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.774582' ,`Longitude` = '-94.919547' ,`PhotoCount` = '47' ,`PostalCode` = '77521' ,`RoomCount` = '5' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Gulfway' ,`StreetNumber` = '4730' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3657' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Big Beautiful Bayou-front Home! Multi-level outdoor entertainment locations! Two options for your Primary room, one up and one down. Covered front porch, open back porch, and balcony leave you with plenty of options to start your morning or entertain! Huge living room + 110\" projector screen + surround sound = home theater! New paint, new flooring, and subfloor throughout the first floor! Home water filtration system in 2020, Spray foam insulation under the whole home in 2021, blown-in insulation throughout attic in 2020. Sellers to offer up to $15,000 for rate buydown with an acceptable offer!' ,`Acres` = '0.5391' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 176 and a portion of lot 175 WHISPERING PINES SEC 3' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '23483' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Whispering Pines' ,`TaxAmount` = '9844' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054913' WHERE `Matrix_Unique_ID` = '213517400' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:20:55.857' ,`MLSNumber` = '95181511' ,`ListAgentFullName` = 'Noel Mosher' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.165775' ,`Longitude` = '-95.437800' ,`PhotoCount` = '6' ,`PostalCode` = '77515' ,`RoomCount` = '5' ,`ListPrice` = '251900.00' ,`Status` = 'Active' ,`StreetName` = 'Bryan' ,`StreetNumber` = '309' ,`StreetSuffix` = 'Way' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1525' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegant, One story home is waiting to be yours. This charming home offers a stunning long front entrance, open concept floor plan, high ceilings, spacious kitchen overlooking the living room. The kitchen is surrounded with tall cabinets, granite countertops, backsplash, and a stainless steel under-mound sink. Included Frigidaire stainless steel electric range, dishwasher, and microwave and a walk in pantry. This 3 bedroom 2 bath has roomy bedrooms, walk in closets, spacious private commode bathrooms, with double sinks. Master suite boasts soaring ceiling, separate tub and shower with tile surround and double vanities. Energy efficient 16 seer HVAC, programmable digital thermostat. Large back patio. Inside windows have faux wood blinds is included.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Adams Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = '12-2-2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '281' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kiber Reserve' ,`TaxAmount` = '' ,`TaxRate` = '2.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669054913' WHERE `Matrix_Unique_ID` = '213554001' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:14:13.210' ,`MLSNumber` = '28496463' ,`ListAgentFullName` = 'Noel Mosher' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.165775' ,`Longitude` = '-95.437800' ,`PhotoCount` = '7' ,`PostalCode` = '77515' ,`RoomCount` = '6' ,`ListPrice` = '283900.00' ,`Status` = 'Active' ,`StreetName` = 'Lago' ,`StreetNumber` = '8' ,`StreetSuffix` = 'Court' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1915' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegant, One story home is waiting to be yours. This charming home offers a stunning long front entrance, open concept floor plan, high ceilings, spacious kitchen overlooking the living room. The kitchen is surrounded with tall cabinets, granite countertops, backsplash, and a stainless steel under-mound sink. Included Frigidaire stainless steel electric range, dishwasher, and microwave and a walk in pantry. This 3 bedroom 2 bath has roomy bedrooms, walk in closets, spacious private commode bathrooms, with double sinks. Master suite boasts soaring ceiling, separate tub and shower with tile surround and double vanities. Energy efficient 16 seer HVAC, programmable digital thermostat. Large back patio. Inside windows have faux wood blinds is included.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Adam\'s Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = '16-2-2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '261' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kiber Reserve' ,`TaxAmount` = '' ,`TaxRate` = '2.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669054914' WHERE `Matrix_Unique_ID` = '213556914' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:03:03.003' ,`MLSNumber` = '64696518' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.051120' ,`Longitude` = '-95.798813' ,`PhotoCount` = '6' ,`PostalCode` = '77447' ,`RoomCount` = '6' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'Jasper Ridge' ,`StreetNumber` = '18935' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1186' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW CONSTRUCTION - Lennar\'s Cottage Collection \"Brook II\" Elevation B in Becker Fields! The lovely 1-story 3 bedroom, 2 bathroom Brook II floor plan features a welcoming front porch, a spacious family room with an adjoining casual dining area. The spacious primary bedroom boasts an en-suite bathroom. The Brook II floor plan also features two additional bedrooms with a second bathroom.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 004 BLK 001 LOT 005' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`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` = 'Becker Fields' ,`TaxAmount` = '' ,`TaxRate` = '3.56' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669054914' WHERE `Matrix_Unique_ID` = '213584226' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:28:26.347' ,`MLSNumber` = '28918012' ,`ListAgentFullName` = 'Rosalie Stevenson' ,`ListOfficeName` = 'Rose Above Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.385608' ,`Longitude` = '-94.974340' ,`PhotoCount` = '33' ,`PostalCode` = '77591' ,`RoomCount` = '12' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Evelyn' ,`StreetNumber` = '5533' ,`StreetSuffix` = 'Street' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3038' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a fantastic opportunity for you to own a large one-story home that needs a full renovation. This home has plenty of space for you to make your changes and add any features you desire. Think of all the possibilities! You can add a pool, store your extra vehicles, plenty of yard for your pets to roam. You will find no better value on a large one story 4 bedroom 2 full bath with formal living room, formal dining room and study. A full renovation is needed but with this size home, there is plenty of square footage left over to add your own touches.' ,`Acres` = '0.7415' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 197 T TOBY SUR LOT 54 & NE 146.4 FT OF LOT 55 COLLINS &' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '32301' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'SIMMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Photos/No Videos' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Collins & Gauldin' ,`TaxAmount` = '7003' ,`TaxRate` = '2.582' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054914' WHERE `Matrix_Unique_ID` = '213675125' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:41:43.733' ,`MLSNumber` = '26971183' ,`ListAgentFullName` = 'Janice Kopfler' ,`ListOfficeName` = 'Coldwell Banker RealtyREALTORS' ,`SellingAgentFullName` = 'David Tello' ,`SellingOfficeName` = 'Lions Gate Realty' ,`Latitude` = '29.998393' ,`Longitude` = '-95.492104' ,`PhotoCount` = '43' ,`PostalCode` = '77068' ,`RoomCount` = '11' ,`ListPrice` = '339000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Parkville' ,`StreetNumber` = '14931' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2931' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wow..You will love this beautifully designed home with fabulous salt water pool, 1/3 acre park-like backyard and loads of windows for a light and bright interior. From the moment you enter you will find wood floors in den, dining and study, high ceilings in den with custom built-ins, wet bar and a wall of windows open to the backyard featuring new deck, salt water pool with natural stone waterfalls, pebble tec pool finish and interior AquaLink control system. Home has 2 recent replaced AC condensors, 2021 water heater, motion sensor closet lights,2022 carpet, replaced electrical panel and upgraded light switches,electrical outlets and Porcelain tile in entry, kitchen and utility. Master bedroom has double sinks, vanity area,2 closets, plus sliding glass door to deck and pool .2nd bedroom down, perfect for guests,nursery or multitude of uses. Upstairs are 2 huge bedrooms with large closets, custom built-ins, plus gameroom with wood floors and full bath with sit down vanity. GREAT HOME!' ,`Acres` = '0.3817' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 41 BLK 10 OAK CREEK VILLAGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '335' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Creek Village' ,`TaxAmount` = '5237' ,`TaxRate` = '2.4592' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054914' WHERE `Matrix_Unique_ID` = '213762893' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:00:48.240' ,`MLSNumber` = '89607793' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.211419' ,`Longitude` = '-95.736631' ,`PhotoCount` = '7' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Bend' ,`StreetNumber` = '108' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1841' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW CONSTRUCTION - Lennar\'s Cottage Collection \"Hawthorn 1.5\" Elevation A in Magnolia Ridge! The lovely 2-story 4 bedroom, 2.5 bathroom Hawthorn floor plan features a welcoming front porch, a spacious family room, and kitchen with an adjoining casual dining area. The spacious primary bedroom boasts an en suite bathroom, and a spacious closet. The Hawthorn floor plan also features three separate bedrooms and a loft on the second floor.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0011 BLK 004 LOT 004' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Ridge' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669054914' WHERE `Matrix_Unique_ID` = '213795652' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:59:58.967' ,`MLSNumber` = '13454242' ,`ListAgentFullName` = 'Marysol Calvillo' ,`ListOfficeName` = 'Elite Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.879812' ,`Longitude` = '-95.630448' ,`PhotoCount` = '50' ,`PostalCode` = '77095' ,`RoomCount` = '5' ,`ListPrice` = '799000.00' ,`Status` = 'Active' ,`StreetName` = 'Avila Bend' ,`StreetNumber` = '14815' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6793' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Hearthstone home located right off 290 and 529. This home features 5 bedrooms 5 full baths 2 half baths on a cul-de-sac lot with a game room, media room, gym, pool/spa, cabana, tool shed, formals.... the list goes on. Schedule a showing and see for yourself. Join the Hearthstone Country club, shopping and dining are minutes away, downtown Houston is an easy commute. Zoned to CYFAIR ISD, low HOA fees, Tax rate right under 2.6%' ,`Acres` = '0.2664' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 AVILA COURT ESTATES AMEND' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '11604' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'OWENS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hearthstone Avila Court Estates' ,`TaxAmount` = '12436' ,`TaxRate` = '2.501' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054915' WHERE `Matrix_Unique_ID` = '213859394' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:58:35.097' ,`MLSNumber` = '43326659' ,`ListAgentFullName` = 'Toyia Chenevert' ,`ListOfficeName` = 'Re/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.941619' ,`Longitude` = '-95.201368' ,`PhotoCount` = '42' ,`PostalCode` = '77346' ,`RoomCount` = '5' ,`ListPrice` = '359900.00' ,`Status` = 'Active' ,`StreetName` = 'Bedford Bend' ,`StreetNumber` = '12431' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2048' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful, well maintained 3 bedroom 2 bath smart home with study has an astonishing open concept. You are greeted by high ceilings & a large foyer that leads you directly to the the family room with a wall of windows inviting in tons of natural light. The gourmet kitchen boasts sleek quartz countertops, tile backsplash, modern appliance suite, large island, and tons of cabinet space for storage. You can relax in your grand Primary retreat w/an ensuite featuring double vanities, cultured marble countertops, massive shower & dress to impress in the spacious closet. Relax under the covered patio & watch the sunset or entertain family & friends. This award winning Balmoral community has the first man-made, Crystal Clear lagoon in Texas surrounded by white sand beaches and lush landscaping. Not to mention the beach club, restaurant, an array of parks, walking trails & easy access to major airports & highways. Create new memories in this move-in ready beauty!' ,`Acres` = '0.1463' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 5 BALMORAL SEC 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '980' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral Sec 23' ,`TaxAmount` = '1163' ,`TaxRate` = '2.9873' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054915' WHERE `Matrix_Unique_ID` = '214025298' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:14:41.830' ,`MLSNumber` = '8037879' ,`ListAgentFullName` = 'Noel Mosher' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.165775' ,`Longitude` = '-95.437800' ,`PhotoCount` = '7' ,`PostalCode` = '77515' ,`RoomCount` = '6' ,`ListPrice` = '283900.00' ,`Status` = 'Active' ,`StreetName` = 'Bryan' ,`StreetNumber` = '305' ,`StreetSuffix` = 'Way' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1915' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegant, One story home is waiting to be yours. This charming home offers a stunning long front entrance, open concept floor plan, high ceilings, spacious kitchen overlooking the living room. The kitchen is surrounded with tall cabinets, granite countertops, backsplash, and a stainless steel under-mound sink. Included Frigidaire stainless steel electric range, dishwasher, and microwave and a walk in pantry. This 3 bedroom 2 bath has roomy bedrooms, walk in closets, spacious private commode bathrooms, with double sinks. Master suite boasts soaring ceiling, separate tub and shower with tile surround and double vanities. Energy efficient 16 seer HVAC, programmable digital thermostat. Large back patio. Inside windows have faux wood blinds is included.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Adam\'s Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = '19-2-2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '261' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kiber Reserve' ,`TaxAmount` = '' ,`TaxRate` = '2.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669054915' WHERE `Matrix_Unique_ID` = '214054602' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:59:53.180' ,`MLSNumber` = '26166289' ,`ListAgentFullName` = 'Sandra Durr' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.048522' ,`Longitude` = '-95.180872' ,`PhotoCount` = '49' ,`PostalCode` = '77345' ,`RoomCount` = '8' ,`ListPrice` = '409900.00' ,`Status` = 'Active' ,`StreetName` = 'Kings Retreat' ,`StreetNumber` = '2714' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICE ADJUSTMENT ! Wonderful 3 story home in the gated community of Kingwood Estates. This house boasts beautiful heavy crown molding throughout the house, wood floors, window shutters and 2 fireplaces. On 1st floor is a versatile room w/new carpet. Could be bedroom, study, exercise room, guest quarters & has its own full bath. 2nd floor has open concept living, dining, kitchen, breakfast room & half bath. Kitchen has large walk in pantry & gas cooking w/SS appliances, granite counters & solid wood cabinets. Living room has fabulous mantel at fireplace and access to balcony seating overlooking your own private pool. 3rd floor has primary bedroom with fireplace in bedroom & at jetted tub. Also frameless shower & large walk in closet with built ins & new carpet. Back yard is a great oasis - gorgeous pool with spa & room to have flower beds, grass area, putting green, etc. House has shaft for future elevator if you want, wrought iron spindles, central vacuum. Make this your home today' ,`Acres` = '0.0716' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 KINGWOOD ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3121' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GREENTREE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingwood D Estates Sub' ,`TaxAmount` = '7276' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054915' WHERE `Matrix_Unique_ID` = '214062233' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:18:09.523' ,`MLSNumber` = '6837043' ,`ListAgentFullName` = 'Steven Hackbarth' ,`ListOfficeName` = 'Hackbarth Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.737191' ,`Longitude` = '-95.637081' ,`PhotoCount` = '50' ,`PostalCode` = '77077' ,`RoomCount` = '8' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Wickersham' ,`StreetNumber` = '13923' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2484' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious 4 Bedroom 2 1/2 bath in a great location the \"Energy Corridor\", with easy access to I10, Hwy 6 and Westheimer. Newly remodeled home with a Brand New A/C, New Roof, New Carpet, New Laminate flooring, New granite Countertops in Kitchen and Bathrooms, all New Stainless Appliances in the Kitchen, New Water Heater and New Paint inside and out. Conveniently located to many restaurants and stores. Low Tax rate. Great Schools. Neighborhood has Playground, Swimming Pool and Tennis Courts.' ,`Acres` = '0.1705' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 15 BRIAR VILLAGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7425' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '570' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DAILY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English' ,`Subdivision` = 'Briar Village Sec 02' ,`TaxAmount` = '5631' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054916' WHERE `Matrix_Unique_ID` = '214069453' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:29:34.820' ,`MLSNumber` = '5968651' ,`ListAgentFullName` = 'Stacy Lyon' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = 'Matt Clark' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '29.589595' ,`Longitude` = '-95.119359' ,`PhotoCount` = '50' ,`PostalCode` = '77059' ,`RoomCount` = '21' ,`ListPrice` = '955000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Deep Oak' ,`StreetNumber` = '2522' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '7' ,`SqFtTotal` = '5574' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 1/3 acre Bay Oaks-5,574 sq ft.; 7 bed/4.5bath home on quiet cul de sac w/no back neighbors;LED lights on heated pool with sheer descents, spa, covered outdoor area wired for kitchen/TVs. 3 car over-sized garage w/porte cochere; walk in pantry; large utility room w/utility sink, plantation shutters; butlers pantry w/2 wine coolers; Primary bedroom with 2 sided remote control fireplace and sitting area. Granite countertops; built in fridge. Double pane windows; game room up; SS double ovens, microwave; 6 burner Jenn Air gas stove; stone archways in living/kitchen/wine area; large walk in primary closet w/ drawer built ins & slit board rack; front & back sprinkler system; front & back; landscape lighting; storage room upstairs not shown in in photos; flex room upstairs; REPLACEMENTS as follows: roof 10/18; re-surfaced pool/spa- 3/22; HVAC 7/22; 1 hot water heater 12/21; 2nd 8/22; pool filter 7/22; Dishwasher 719; carpet upstairs 9/22. No carpet downstairs & more. See it today!' ,`Acres` = '0.3955' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 1 BAY OAKS SEC 21' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '17227' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '930' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FALCON PASS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Oaks Sec 21' ,`TaxAmount` = '17053' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054916' WHERE `Matrix_Unique_ID` = '214080179' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:55:36.017' ,`MLSNumber` = '59455142' ,`ListAgentFullName` = 'Jormayline Dipre' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.684158' ,`Longitude` = '-95.620389' ,`PhotoCount` = '12' ,`PostalCode` = '77083' ,`RoomCount` = '9' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Tonnochy' ,`StreetNumber` = '13611' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love at first light! This sun-drenched fully upgraded 4 bedroom/2.5 bathroom sits in the perfect location near Bellaire Blvd. From entirely new windows, doors, and floors, this home is ready to be yours. The spacious backyard wraps around two covered patios. The ground level hosts the primary bedroom with an en-suite and an entertainer\'s delight open-concept kitchen and living area. The second floor features 3 additional bedrooms for all of your family and friends. Nothing left to do here... PRICED TO SELL. Come see it today!!!' ,`Acres` = '0.2571' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 8 OLYMPIA SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '646' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'ALEXANDER ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Olympia' ,`TaxAmount` = '4329' ,`TaxRate` = '2.507' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054916' WHERE `Matrix_Unique_ID` = '214221548' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:33:31.753' ,`MLSNumber` = '55689834' ,`ListAgentFullName` = 'Natalie Tye' ,`ListOfficeName` = 'Monarch Real Estate & Ranch' ,`SellingAgentFullName` = 'Thomas Miles' ,`SellingOfficeName` = 'Compass RE Texas, LLCHeights' ,`Latitude` = '29.799442' ,`Longitude` = '-95.836249' ,`PhotoCount` = '26' ,`PostalCode` = '77493' ,`RoomCount` = '3' ,`ListPrice` = '385000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Tiger' ,`StreetNumber` = '6707' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently built by David Weekley, this beautiful 1 story home welcomes you with a warm brick and stone exterior and sits on a quiet street in the sought after neighborhood of Cane Island! You will love all of the features it has to offer including stunning wood tile throughout all main areas, high ceilings, covered patio, chef\'s kitchen with painted white cabinets and smart Nest doorbell and thermostat! The primary suite is a relaxing retreat and includes a large bay window, trace ceilings, and huge upgraded bathroom with aromatherapy steam shower! Last but certainly not least, it boasts a spacious backyard with room for a pool or outdoor kitchen! Cane Island includes wonderful amenities and is convenient to i10, shopping, dining, and is all zoned to Katy ISD! Schedule your private tour today!' ,`Acres` = '0.1599' ,`Area` = '25' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S422322 CANE ISLAND SECTION 2 BLK 4 LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6964' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island Sec 2' ,`TaxAmount` = '9425' ,`TaxRate` = '3.4077' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054916' WHERE `Matrix_Unique_ID` = '214293514' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:49:33.870' ,`MLSNumber` = '16664053' ,`ListAgentFullName` = 'Michael Parker' ,`ListOfficeName` = 'Phyllis Foster Real Estate Ser' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.695499' ,`Longitude` = '-95.110332' ,`PhotoCount` = '34' ,`PostalCode` = '77536' ,`RoomCount` = '6' ,`ListPrice` = '324800.00' ,`Status` = 'Active' ,`StreetName` = 'Shoshoni' ,`StreetNumber` = '1810' ,`StreetSuffix` = 'Drive' ,`City` = 'Deer Park' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2195' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT PROPERTY LOCATED IN THE HEART OF DEER PARK. NO BACK NEIGHBORS. GREAT OPEN CONCEPT FLOOR PLAN WITH 4 BEDROOMS AND 2 FULL BATH. THE KITCHEN OPENS TO THE FAMILY ROOM WITH WOOD FLOORING. GRANITE COUNTER TOPS WITH AMPLE COUNTER TOP AND STORAGE SPACE. SPACIOUS SECONDARY BEDROOMS WITH LARGE WALK IN CLOSETS. OVER SIZED POOL WITH COVERED PATION AND DECK. RECENT IMPROVEMENTS INCLUDE A/C AND ROOF. DO NOT MISS THIS GREAT OPPURTUNITY BOOK TODAY.' ,`Acres` = '0.2682' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 2 RUNNINGBROOK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11682' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (DEER PARK)' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'DEER PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Runningbrook Sec 01' ,`TaxAmount` = '7933' ,`TaxRate` = '2.8239' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054917' WHERE `Matrix_Unique_ID` = '214323622' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:47:35.757' ,`MLSNumber` = '71777023' ,`ListAgentFullName` = 'Alejandro Barrella' ,`ListOfficeName` = 'Pinnacle Realty Advisors' ,`SellingAgentFullName` = 'Minal Vyas' ,`SellingOfficeName` = 'RE/MAX Fine Properties' ,`Latitude` = '29.582258' ,`Longitude` = '-95.669293' ,`PhotoCount` = '24' ,`PostalCode` = '77479' ,`RoomCount` = '6' ,`ListPrice` = '649000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Crisfield' ,`StreetNumber` = '1910' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3487' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic Weekley Plan with master & second bedroom with full bathroom down, plus both formals & upstairs game room. The house is immaculate, a new kitchen that was recently rebuild with an open concept and an amazing island, and really nice wood floors downstairs. The house is on a very large corner lot that is just across from a park area and with views of lake and fountain. The backyard has a huge pool with a spa, plenty of grassy play areas, a covered patio with deck above. Oversized garage with eight foot extension faces street for easy parking. This wonderful house is at walking distance to exemplary middle school and retail center.\r\n\r\n*** PLEASE NOTE THAT AN OFFER HAS BEEN ACCEPTED AND A SALES CONTRACT IS SIGNED. SHOULD YOU BE INTERESTED IN SUBMITTING A BACKUP OFFER PLEASE CONTACT THE LISTING AGENT ***' ,`Acres` = '0.2669' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NEW TERRITORY PARCEL SF-22, BLOCK 2, LOT 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11624' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1060' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'WALKER STATION ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'SARTARTIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'New Territory Prcl Sf-22' ,`TaxAmount` = '11098' ,`TaxRate` = '2.4394' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669054917' WHERE `Matrix_Unique_ID` = '214341150' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:37:22.813' ,`MLSNumber` = '17930178' ,`ListAgentFullName` = 'Christine Laborde' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.763963' ,`Longitude` = '-95.425527' ,`PhotoCount` = '11' ,`PostalCode` = '77007' ,`RoomCount` = '5' ,`ListPrice` = '3490000.00' ,`Status` = 'Active' ,`StreetName` = 'Cowan' ,`StreetNumber` = '200' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '3' ,`BedsTotal` = '5' ,`SqFtTotal` = '7303' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Withdrawn for a couple days. \r\nWelcome home to a premier neighborhood of Houston. 200 Cowan is down the street from the renown Memorial Park and a PGA tour course. This luxury home has five bedrooms, a downstairs primary, a screening room, multiple fireplaces, an MTV Cribs worthy infinity pool plus a four car garage with room for lifts. A chef\'s kitchen, outdoor kitchen and a pizza oven will make you the premier holiday and gathering location. 200 Cowan is a short stroll from the Memorial Park two tier, 87 bay driving range and the iconic 3 mile jogging loop. Various events throughout the year lend a camaraderie among neighbors. Located close to many hot spots such as Post Oak Hotel, Oak Room, Polo Club, downtown. Crestwood is also minutes from Toyota Center and Minute Maid Park. Come upgrade your lifestyle on Cowan.' ,`Acres` = '0.4937' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Memorial Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 16 BLK 7 CRESTWOOD' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '21506' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Crestwood' ,`TaxAmount` = '64350' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054917' WHERE `Matrix_Unique_ID` = '214363127' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:13:05.340' ,`MLSNumber` = '47238321' ,`ListAgentFullName` = 'Laura Reagor' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.929826' ,`Longitude` = '-95.609894' ,`PhotoCount` = '50' ,`PostalCode` = '77065' ,`RoomCount` = '12' ,`ListPrice` = '440000.00' ,`Status` = 'Active' ,`StreetName` = 'Timberland' ,`StreetNumber` = '12710' ,`StreetSuffix` = 'Trace' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3508' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Much sought after home in the beautiful Wortham Park Subdivision. Nestled in a quiet cul de sac, this home is truly move-in READY! Fresh paint throughout most of the home, updated kitchen and primary bath.This home has been meticulously cared for, large covered patio, gated access to back yard, detached 2 car garage with additional parking spaces for the busy family. Great floor plan, lots of windows with plenty of natural light, mature trees, the backyard is shaded and peaceful and an extension of your living space. Walk in and see marble floors and a very open living area, with impressive high ceilings. Wortham Park has 3 miles of walking trails, great location with easy access to Hwy. 290, Sam Houston Toll Rd. and Grand Pkwy. No through streets keeps this neighborhood quiet and private.' ,`Acres` = '0.208' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 39 BLK 6 WORTHAM PARK SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9060' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ADAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wortham Park Sec 02' ,`TaxAmount` = '7166' ,`TaxRate` = '2.341' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054917' WHERE `Matrix_Unique_ID` = '214367305' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:34:09.323' ,`MLSNumber` = '42648595' ,`ListAgentFullName` = 'Camden Brown' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659299' ,`Longitude` = '-95.449708' ,`PhotoCount` = '7' ,`PostalCode` = '77035' ,`RoomCount` = '3' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Kingfisher' ,`StreetNumber` = '4313' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1928' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 3 Bedroom, 2 Bathroom Home Located only 15 minutes from Downtown and 15 from the Memorial Area!\r\nThis fully Modern upgraded home features Open Floor plan with kitchen open to the Living and dinning room. We will have no Showings until our Open House Weekend starting Saturday (10am - 4pm ) 11/19/2022 and \r\nSunday ( 10am - 4pm) 11/20/2022!' ,`Acres` = '0.1816' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 20 WILLOWBROOK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7910' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Willowbrook Sec 02' ,`TaxAmount` = '6602' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054917' WHERE `Matrix_Unique_ID` = '214435859' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:07:09.163' ,`MLSNumber` = '5635524' ,`ListAgentFullName` = 'Liz Hazenberg' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.376425' ,`Longitude` = '-95.646012' ,`PhotoCount` = '46' ,`PostalCode` = '77316' ,`RoomCount` = '3' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunrise Pines' ,`StreetNumber` = '18424' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1487' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely three bedroom, two bath one story home near Lake Conroe with an open concept floor plan. The home features a large walk-in pantry, covered back patio and fenced backyard. The primary bathroom includes a separate shower and garden tub. The kitchen includes new stainless steel appliances with a breakfast bar that overlooks the family room with a corner gas fireplace. Extensive tile flooring throughout living room and both guest bedrooms and hallways. Freshly painted interior and exterior walls. Exterior side of doors freshly painted. Updated light fixtures, hardware and brand new bathroom mirrors! Google Nest Smart Thermostat. Brand new garage door opener! Pre-plumbed for water softener located in garage. Updated HVAC system and whole house media air filter. New playground in walking distance. Low tax rate!' ,`Acres` = '0.1262' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S909204 - SUNRISE RANCH 04, BLOCK 2, LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5499' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunrise Ranch 04' ,`TaxAmount` = '3213' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054918' WHERE `Matrix_Unique_ID` = '214493751' --> 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','214512716','1669054918','214512716','2022-11-20T09:00:24.153','40571303','Melissa Cruz','Keller Williams Woodlands','','','29.939442','-95.238940','43','77396','12','450000.00','Active','Butterfly Path','4735','Drive','Humble','4','0','4','2895','Single-Family','RARE FIND! 1.5 story Chesmar home with 4 bedrooms, 4 full baths and no back neighbors! High ceilings throughout with updated wood-look flooring and neutral tile, no carpet! Open concept floorplan is perfect for entertaining. Den with gas-log fireplace and views of the backyard. HUGE island in the kitchen with stainless apps, gas range, built-in microwave, and refrigerator is included! Warm-toned cabinets and granite counters accented with stone-tile backsplash. Large breakfast area and formal dining room. Spacious primary suite with en-suite bath, dual sink vanity, granite counter, framed mirror, soaking tub, separate shower, and large closet. Upstairs game room with full bath can be used for media room or home office, as desired! Covered back patio, generous backyard, and sprinkler system. Quiet manned-gated neighborhood with amenities that include clubhouse, pool, playgrounds, basketball court, and lake. Convenient location to airport, shopping, and restaurants.','0.1624','1','Chesmar','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Humble Area East','Central Gas,Zoned','1','LT 9 BLK 3 CANYON GATE AT PARK LAKES SEC 8','Subdivision Lot','7076','Appraisal District','','1200','0','','2','Electric Oven','0','','','Gas Range','','Composition','29 - Humble','PARK LAKES ELEMENTARY SCHOOL','HUMBLE HIGH SCHOOL','HUMBLE MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Canyon Gate/Pk Lakes','8387','2.9873','Public Sewer,Public Water','2009','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:51:05.960' ,`MLSNumber` = '77719541' ,`ListAgentFullName` = 'Jason Knebel' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = 'Justin Strickland' ,`SellingOfficeName` = 'Cy-Fair Real Estate' ,`Latitude` = '29.950700' ,`Longitude` = '-95.744678' ,`PhotoCount` = '33' ,`PostalCode` = '77433' ,`RoomCount` = '17' ,`ListPrice` = '910000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Water Bridge' ,`StreetNumber` = '19207' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4837' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated property located on a corner cul-de-sac in Bridgeland is ready for you! Step inside to a grand foyer flanked by a home office and formal dining. The family room has a fireplace and is open to a stunning kitchen. Recent kitchen updates include quartz counters, tile floors, marble backsplash, dishwasher drawers, Jenn-Air gas cooktop, and more! Updated primary bath has dual head shower, quartz counters, and sculptural soaking tub. A guest suite completes the first floor. Upstairs you will find game and media rooms, three secondary bedrooms and two baths. Step outside to your private oasis! The covered patio has a fireplace, kitchen with granite counter and recent grill, and four recently added fans. Inviting heated pool has multiple waterfalls, updated spa tile, and surrounded by mature landscaping. Whole home generator installed August 2022! Community amenities abound in Bridgeland. See video tour and list of updates. Quick access to 99 and 290. Info per seller.' ,`Acres` = '0.2858' ,`Area` = '25' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 1 WATER HAVEN AT BRIDGELAND SEC 6' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12448' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1255' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POPE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Water Haven/Bridgeland Sec 6' ,`TaxAmount` = '19043' ,`TaxRate` = '3.4329' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054918' WHERE `Matrix_Unique_ID` = '214521479' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:36:23.277' ,`MLSNumber` = '22168092' ,`ListAgentFullName` = 'Robert Griffith' ,`ListOfficeName` = 'Circa Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841323' ,`Longitude` = '-95.837750' ,`PhotoCount` = '47' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '699000.00' ,`Status` = 'Active' ,`StreetName` = 'Silhouette' ,`StreetNumber` = '4711' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, spacious one-story homestead on 1.3 acres with mature oak trees, landscaping, lighting, pool, covered patio, RV barn with boat storage and workshop! Water views from front and back! You really have to see this one to appreciate all this home has to offer. Extensive built-ins, crown molding, cabinets and storage space! Large cooks kitchen with lots of counter space, SS Bosch appliances, wall ovens including warmer!! Tons of storage and separate pantry. Large convenient mud room with storage. Split plan allows for guest/in-law privacy. Multiple flexible, open living spaces...Living, Den, Game Room, Dining Room combinations galore!! Barn has 45\'x10\' RV bay, 800sf workspace/storage above and huge (30\'x40\') air-conditioned/heated shop below!! Architectural interest throughout with high tray (coffered) ceilings, art niches, shelves. TWO fully stocked ponds available for fishing (bass, crappie, catfish) Whole house vacuum system. Priced to sell...call for your showing TODAY!' ,`Acres` = '1.25' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 KATY LAKE ESTATES SEC 2' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '54450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '6' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'English,Other Style,Ranch,Traditional' ,`Subdivision` = 'Katy Lakes Estates Sec 02' ,`TaxAmount` = '10524' ,`TaxRate` = '2.0368' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054918' WHERE `Matrix_Unique_ID` = '214688407' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:49:19.200' ,`MLSNumber` = '11755895' ,`ListAgentFullName` = 'Anthony Silvas' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Eric Contreras' ,`SellingOfficeName` = 'RE/MAX Signature' ,`Latitude` = '29.698459' ,`Longitude` = '-95.279376' ,`PhotoCount` = '25' ,`PostalCode` = '77017' ,`RoomCount` = '4' ,`ListPrice` = '144700.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Kimble' ,`StreetNumber` = '8021' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1492' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 MAYSWOOD' ,`LotDesciption` = 'Other' ,`LotSize` = '6500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'CHAVEZ HIGH SCHOOL' ,`SchoolMiddle` = 'DEADY MIDDLE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mayswood' ,`TaxAmount` = '2520' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054918' WHERE `Matrix_Unique_ID` = '214725645' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:33:27.983' ,`MLSNumber` = '80088856' ,`ListAgentFullName` = 'Helen Hairston' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.549144' ,`Longitude` = '-95.365722' ,`PhotoCount` = '38' ,`PostalCode` = '77584' ,`RoomCount` = '15' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Falcon Ridge' ,`StreetNumber` = '2539' ,`StreetSuffix` = 'Street' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3492' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor special! Selling AS IS! Priced to allow repairs to Make it your own! Ask agent for details- Spacious 4/3.5/3 car detached garage, corner lot, Per seller recent AC. Great location with easy access to 288 and 19 minutes to Texas Medical Center and 21 Minutes to Downtown. Close to Pearland Town Center Mall, shopping, dining, and more! Zoned to highly sought-after Pearland schools, close to Lake and park. Southwick Golf Club wanders through the Silverlake subdivision' ,`Acres` = '0.2536' ,`Area` = '5' ,`BuilderName` = 'Newmark' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PARKSIDE SEC 1 AT SILVERLAKE, BLOCK 3, LOT 2, 0309 HT&B-0721' ,`LotDesciption` = 'Corner' ,`LotSize` = '11047' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '753' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SILVERLAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkside Sec 1 At Silverlake' ,`TaxAmount` = '9023' ,`TaxRate` = '2.3537' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054919' WHERE `Matrix_Unique_ID` = '214732759' --> 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','214738118','1669054919','214738118','2022-11-20T10:00:46.850','41881153','Nikki Jackson','eXp Realty, LLC','','','29.520269','-96.066177','28','77435','10','389900.00','Active','John Albert','901','Drive','East Bernard','2','0','4','1892','Single-Family','Lovely, fresh and newly renovated! Welcome to 901 John Albert Dr! This recently remodeled home has all the features you are looking for and more! New custom cabinets, fresh paint, granite countertops, along with plumbing and lighting fixtures! In it\'s almost 1900 square feet of living you have 4 bedrooms, 2 new bathrooms and a formal dining/living room! It sits under mature trees and it walking distance from EBISD, the city pool and grocery shopping. Come see this beauty before it\'s gone! Call for your private tour today!','0.2169','55','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','','Central Electric','0','SOUTHVIEW TERRACE II BLOCK 4 LOT 8','Subdivision Lot','9448','Appraisal District','','','0','','2','Electric Oven,Freestanding Oven','0','','','Electric Range','','Composition','145 - East Bernard','EAST BERNARD ELEMENTARY SCHOOL','EAST BERNARD HIGH SCHOOL','EAST BERNARD J H','Appointment Required,Lockbox Front','Appraisal District','1','Ranch','Southview Terrace II','4885','2.2057','Public Sewer,Public Water','1994','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:53:18.990' ,`MLSNumber` = '19135496' ,`ListAgentFullName` = 'Roxanna Gross' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.871258' ,`Longitude` = '-95.714990' ,`PhotoCount` = '50' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '296000.00' ,`Status` = 'Active' ,`StreetName` = 'Cresent Creek' ,`StreetNumber` = '19927' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2501' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom 2.5 bath home in Estates of Highland Creek with no back neighbors!! This home has been freshly painted and new carpet installed. Bedrooms are good size and have lots of great windows throughout the home and bay windows in the bedrooms. You and your family will love this lightly lived in home. The back yard features no back neighbors and has a deck and hot tub to enjoy this Winter. Schedule your appointment today!' ,`Acres` = '0.1584' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 77 BLK 1 ESTATES OF HIGHLAND CREEK SEC 2' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'DURYEA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates Highland Creek 02' ,`TaxAmount` = '5818' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054919' WHERE `Matrix_Unique_ID` = '214748425' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:22:41.737' ,`MLSNumber` = '8261142' ,`ListAgentFullName` = 'Beverly Hoeke' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.186526' ,`Longitude` = '-95.427473' ,`PhotoCount` = '10' ,`PostalCode` = '77515' ,`RoomCount` = '3' ,`ListPrice` = '150000.00' ,`Status` = 'Active' ,`StreetName` = 'Manor' ,`StreetNumber` = '620' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1619' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Multiple offers received. Offer deadline 11/18 @ 3PM. Please do not contact agent.**\nProperty is a short sale. Home has a lot of potential, has great curb appeal. Will need some rehabbing and plumbing work.' ,`Acres` = '0.168' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Short Sale' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PLANTATION NORTH (ANGLETON), BLOCK 4, LOT 21' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7318' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Plantation North Angleton' ,`TaxAmount` = '4953' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054919' WHERE `Matrix_Unique_ID` = '214749083' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:32:14.363' ,`MLSNumber` = '45021903' ,`ListAgentFullName` = 'Jeanne Skinner' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.594248' ,`Longitude` = '-95.673716' ,`PhotoCount` = '41' ,`PostalCode` = '77479' ,`RoomCount` = '10' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Harbor View' ,`StreetNumber` = '37' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3811' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxurious contemporary style two-story home with 4 bedrooms, 3.5 bathrooms, a library that opens up to the side courtyard, a spacious family room that connect to the kitchen and a game room upstairs with access to the sunny balcony. Primary bath features his and her closet and all secondary bedrooms have walk-in closets. This beautiful floorplan is located in the sought after gated community of Pointe Royale in New Territory with excellent Fort Bend Schools. The modern interior features vaulted foyer with black granite flooring leading to a spacious family room with crown molding, large windows that overlook the beautifully landscaped pool area. The kitchen features an induction cooktop, double oven and subzero refrigerator. The home was recently updated with quartz countertops, carpet and bamboo wooden flooring.' ,`Acres` = '0.285' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'POINT ROYALE SEC 1, BLOCK 1, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12416' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1060' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'WALKER STATION ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'SARTARTIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Pointe Royale' ,`TaxAmount` = '11120' ,`TaxRate` = '2.4394' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054919' WHERE `Matrix_Unique_ID` = '214762067' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:32:16.597' ,`MLSNumber` = '17260269' ,`ListAgentFullName` = 'Renee Blake' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.950661' ,`Longitude` = '-95.199411' ,`PhotoCount` = '33' ,`PostalCode` = '77346' ,`RoomCount` = '6' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Crosby Hall' ,`StreetNumber` = '15702' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1536' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable Bungalow by Lennar. Open concept kitchen overlooking the family room. Master bedroom ensuite master bedroom with large shower. No carpet! Wi-Fi certified and smart home! Extra-long driveway to come home to the oversized 2-car garage. NO BACK NEIGHBORS! Perfect location and access to Balmoral to the lagoon pool surrounded by white sand beaches. Hammocks, cabanas, infinity pool, splash pad, lakes, parks, and tennis courts! Enoy being on vacation at home. Call for your appointment today!' ,`Acres` = '0.1728' ,`Area` = '1' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 BALMORAL SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7525' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral Sec 6' ,`TaxAmount` = '7910' ,`TaxRate` = '3.5573' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054920' WHERE `Matrix_Unique_ID` = '214762559' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:55:16.173' ,`MLSNumber` = '65818394' ,`ListAgentFullName` = 'Lisa Kornhauser' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.788821' ,`Longitude` = '-95.390276' ,`PhotoCount` = '26' ,`PostalCode` = '77008' ,`RoomCount` = '12' ,`ListPrice` = '3499000.00' ,`Status` = 'Active' ,`StreetName` = '10th' ,`StreetNumber` = '644' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6086' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fully furnished, one-of-a-kind recent construction in coveted location in The Heights designed by iconic tastemaker Bill Stubbs. Named in the AD 100, Architectural Digest’s list of the World’s Top Designers and Architects, Stubbs designed every inch of this 6,086 square foot home to be a tranquil sanctuary in the heart of the city. Completed in 2021 (per seller), this impeccable home has every bell and whistle. A gated front entry leads to a turfed lawn and covered patio where a steel pivot front door leads to a gorgeous two-story entry. The first floor is an entertainer\'s dream with a large dining room, temp controlled wine room, study, large living room open to kitchen, and more. Indoor/outdoor living concept with sliding doors leading to the lanai, pool, and summer kitchen. The second floor is complete with 4-5 bedrooms, optional game room/quarters with separate entrance, plus living/media room off of primary. The third floor has a workout room and spacious rooftop terrace.' ,`Acres` = '0.1435' ,`Area` = '9' ,`BuilderName` = 'L&B Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 12 & 13 BLK 43 STUDES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HARVARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Stude Sec 02' ,`TaxAmount` = '37022' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669054920' WHERE `Matrix_Unique_ID` = '214768487' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:59:39.700' ,`MLSNumber` = '31170635' ,`ListAgentFullName` = 'Fafu Zeng' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.676967' ,`Longitude` = '-95.342510' ,`PhotoCount` = '20' ,`PostalCode` = '77033' ,`RoomCount` = '4' ,`ListPrice` = '169800.00' ,`Status` = 'Active' ,`StreetName` = 'Le Havre' ,`StreetNumber` = '7351' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1088' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful cozy house with 3 bedrooms and 1 full bath. Recently updated with new paint throughout both inside and outside. new roof, new central AC, new windows, new flooring, new bathroom, new kitchen, new appliances, new lights/fans, new water heater, new electric panel and some new wires. Great layout and cozy feeling! Fully fences and gated front yard! Central location and easy access to all amenities. Schedule your show today as it won\'t last with this price!' ,`Acres` = '0.135' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 17 SOUTH PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5880' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KELSO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Park Sec 01' ,`TaxAmount` = '1653' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054920' WHERE `Matrix_Unique_ID` = '214776309' --> 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','214804063','1669054920','214804063','2022-11-20T10:07:36.170','33772918','Nicole Shields','CRI Real Estate Services','','','29.932822','-95.746727','50','77433','11','2395000.00','Active','Round Prairie','19310','Lane','Cypress','5','1','5','5950','Single-Family','Modern 2 story home located behind the gates of Sheldon Lakes in Bridgeland. 5 bedroom/5.5 bath home sits on over a half acre lot with no rear neighbors.Over $400K in upgrades to the home. 54\'x27\' exquisite pool/spa/14\' fire wall, water features. Outdoor kitchen with waterfall quartz counters, accent lighting and ss storage cabinets and drawers set under a large 2 story covered back patio.2 tankless water heaters, water softener, 22KW Generac generator installed with upgraded gas meter. 2 story office has dramatic commercial grade corner windows with electric shades and storage closet. Seamless glass wine room with door has ample storage and countertop space.A chef\'s kitchen with large island, double Jenn Air ovens, gas range, farm sink with RO system, butlers pantry and large walk in pantry. Kitchen opens to living room with soaring ceilings and flex room with accordion sliding door which opens to covered back patio. Ultimate primary, spa bathroom and stunning 2 story closet.','0.5026','25','Partners in Building','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','Mock Fireplace','1','Cypress South','Central Gas','1','LT 3 BLK 2 BRIDGELAND PARKLAND VILLAGE SEC 20','Cul-De-Sac,Subdivision Lot','21893','Appraisal District','','1997','0','','3','Double Oven','1','Gunite,Heated,In Ground','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','MCGOWN ELEMENTARY SCHOOL','BRIDGELAND HIGH SCHOOL','SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,Lockbox Back,Request Online Appointment','Appraisal','2','Contemporary/Modern','Bridgeland Parkland Vlg Sec 20','6427','3.541','Public Sewer,Public Water,Water District','2021','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T09:47:09.997' ,`MLSNumber` = '86233165' ,`ListAgentFullName` = 'Sharon Brier' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.754570' ,`Longitude` = '-95.382879' ,`PhotoCount` = '21' ,`PostalCode` = '77019' ,`RoomCount` = '8' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Cleveland' ,`StreetNumber` = '1518' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1625' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This traditional home is conveniently positioned just two blocks from Gray St., the hub of fabulous restaurants and entertainment. This home features a beautiful updated interior, with grey paint, clean white cabinetry, and neutral granite countertops throughout. All of the bedrooms are upstairs and have large closets. The primary bedroom features a spacious bathroom and walk-in closet. The backyard green space is the perfect spot to enjoy the upcoming cooler weather and provide a space for your pets. The covered patio provides shade while lounging outside. An extended driveway in the back adds extra guest parking. Wiley Park is nearby. All info per Seller.' ,`Acres` = '0.0659' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 4 ESTATES MIRACLE OF HOPE-FOURTH WARD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2872' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GREGORY-LINCOLN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'GREGORY-LINCOLN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Miracle Hope-Fourth Ward' ,`TaxAmount` = '7065' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054920' WHERE `Matrix_Unique_ID` = '214815774' --> 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','214835029','1669054921','214835029','2022-11-20T09:11:43.390','59836645','Patrick Bilnoski','Century 21 Top Realty','','','29.839590','-95.420438','38','77018','10','759500.00','Active','Alba','5103','Road','Houston','2','1','4','2667','Single-Family','Come and tour this lovely home in the sought after subdivision of Candlelight Plaza. The home has had extensive renovations including underground sewer replacement, PEX plumbing throughout the interior, HVAC, plantation shutters, hardie plank exterior and new paint, exterior brick with paint, adding a driveway gate, updating and reconfiguring the master retreat, bath and closet, updated kitchen and bath, updated appliances, new lighting, security gate, low-e windows and extensive landscaping. The backyard is impressive with a covered patio, dining pergola and large yard with playscape. The function and feel prove to be thoughtful and inviting in this amazing home. 5103 Alba is a great place to call your new home.','0.2238','9','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Shepherd Park Plaza Area','Central Gas','0','LT 12 BLK 1 CANDLELIGHT PLAZA SEC 2','Subdivision Lot','9750','Appraisal District','','','0','','1','Double Oven,Gas Oven','0','','','Gas Cooktop','','Composition','27 - Houston','DURHAM ELEMENTARY SCHOOL','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Candlelight Plaza Sec 02','14427','2.3307','Public Sewer,Public Water','1961','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:42:59.460' ,`MLSNumber` = '66441593' ,`ListAgentFullName` = 'Michelle Reyna' ,`ListOfficeName` = 'The Reyna Group' ,`SellingAgentFullName` = 'Michelle Reyna' ,`SellingOfficeName` = 'The Reyna Group' ,`Latitude` = '29.807116' ,`Longitude` = '-95.396829' ,`PhotoCount` = '22' ,`PostalCode` = '77008' ,`RoomCount` = '4' ,`ListPrice` = '585000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = '23rd' ,`StreetNumber` = '207' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '975' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming Heights bungalow with garage apartment and backyard. Located directly across from Halbert Park. Updates include fresh interior paint, new lighting, HVAC and airducts replaced 2019, all electrical, full PEX piping/plumbing, new decking 2020, fence 2021, and turf added to backyard. Generous room sizes in the main home. Garage apartment with two room + dining and full kitchen. Long, private drive with space to add a motorized private gate. Walking distance to cafes, bars, parks, and schools. Wonderful location with loads of charm!' ,`Acres` = '0.1217' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 2 MILROY PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Milroy Place' ,`TaxAmount` = '10674' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054921' WHERE `Matrix_Unique_ID` = '214835650' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-20T10:52:00.933' ,`MLSNumber` = '71000744' ,`ListAgentFullName` = 'Craig Zietsman' ,`ListOfficeName` = 'Sprout Realty' ,`SellingAgentFullName` = 'Caroline Billipp' ,`SellingOfficeName` = 'Greenwood King Properties' ,`Latitude` = '29.713660' ,`Longitude` = '-95.432574' ,`PhotoCount` = '40' ,`PostalCode` = '77005' ,`RoomCount` = '7' ,`ListPrice` = '2700000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Mercer' ,`StreetNumber` = '6330' ,`StreetSuffix` = 'Street' ,`City` = 'West University Place' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5044' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This custom built home is perfectly located in the heart of West U. This home was designed to allow maximum natural light and large rooms for entertaining. Recently installed white oak hardwood floors create a warm home feeling and you will be sure to love the 15ft ceilings and high end light fixtures through-out the home. Marble and quartz in the bathrooms create a dreamy escape, there is also a large gameroom connected to the balcony upstairs which is perfect for entertaining friends and family.' ,`Acres` = '0.1725' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 WEST UNIVERSITY UNITED METHODIST CHURCH' ,`LotDesciption` = 'Other' ,`LotSize` = '7514' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'West Univ United Methodist Ch' ,`TaxAmount` = '39941' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669054921' WHERE `Matrix_Unique_ID` = '214896332' --> 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','214959613','1669054921','214959613','2022-11-20T10:07:09.477','76348407','Bian Hu','KingFay Inc','','','29.577162','-95.601494','39','77479','8','330000.00','Active','Lazy Brook','3122','Drive','Sugar Land','2','1','4','2072','Single-Family','A cozy home in the heart of Sugar Land. New carpet! New Painting! New cabinets and upgraded kitchen; Walking distance to community pool, tennis court and elementary! Excellent schools! Easy access to Hwy 6 & US 59! Must See!','','29','','','Washer Connections','','Sellers Disclosure','1','','1','Sugar Land South','Central Gas','1','SETTLERS PARK SEC 2, BLOCK 16, LOT 47','Cul-De-Sac,Subdivision Lot','7035','Appraisal District','','500','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','19 - Fort Bend','SETTLERS WAY ELEMENTARY SCHOOL','CLEMENTS HIGH SCHOOL','FIRST COLONY MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','SETTLERS PARK SEC 2','','','Public Sewer,Public Water','1982','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','214969386','1669054921','214969386','2022-11-20T09:19:17.303','11644863','Jamie Ramos','Styled Real Estate','','','29.882335','-95.740082','32','77433','9','325000.00','Active','Cypress Pin Oak','7303','Drive','Cypress','3','0','3','2412','Single-Family','Looking for that Perfect Holiday Gift?? Look No More we have the Perfect one...Gorgeous 1.5 Story 3 Bedroom 3 Full bath home with a gameroom that also can be a 4th bedroom with its own private bathroom, a Formal Sitting Area and Flex room that has Multi-purpose use!! Home was built by Saratoga Builders in 2018 -Calabria Series Plan 2012BGR. Home includes Granite countertops, 42\"Cabinets, Refrigerator, Water Filter system, Pre-wired for Surround sound, with Vaulted Ceilings....Don\'t wait...Come Un-wrap your Home Today!!','0.1449','25','Saratoga Builder','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','','','Cypress South','Central Gas','1','LT 3 BLK 6 CYPRESS OAKS SEC 2','Subdivision Lot','6314','Appraisal District','','500','0','','2','Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','13 - Cypress-Fairbanks','WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS PARK HIGH SCHOOL','ROWE MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1.5','Traditional','Cypress Oaks Sec 2','7139','2.831','Water District','2018','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','214970426','1669054921','214970426','2022-11-20T09:59:40.943','10374129','Kelley Mills','Keller Williams Metropolitan','','','29.799527','-95.417162','27','77008','4','749900.00','Active','16th','1059','Street','Houston','3','1','3','3000','Single-Family','Recent construction home with designer finishes and touches throughout. Fully fenced backyard with turf, rooftop patio, and fourth floor game room complete with dry bar. Primary bedroom with a spa like en-suite and oversized walk in closet. Attention to detail throughout with high ceilings and a floor plan meant for entertaining. The quality of this home shines through every space.','0.0385','9','Titan Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','','Gaslog Fireplace','1','Heights/Greater Heights','Central Gas','0','LT 5 BLK 1 GRANADA','Other','1677','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','LOVE ELEMENTARY SCHOOL','WALTRIP HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (HOUSTON)','Appointment Required,Supra Keybox','Appraisal District','4','Contemporary/Modern','Granada','13847','2.3307','Public Sewer,Public Water','2017','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','214976881','1669054921','214976881','2022-11-20T10:14:00.170','72023705','Roscoe Ford','JPAR-The Sears Group','','','29.313001','-96.094000','33','77488','2','169900.00','Active','Avenue C','508','','Wharton','1','0','2','936','Single-Family','Don\'t miss out on this nice 2 bedroom 1 full bath home updated with beautiful granite countertops, engineered flooring and more. The living room is a great space to relax by your electric fire place. The dining area is centrally located off the living area and adjoins the beautiful kitchen area. Kitchen boasts beautiful granite countertops and nice white tile backsplash, all stainless appliances and yes, the Fridge stays also! Bathroom is also updated and the laundry room is indoors. There is a recently installed wood fence around the over-sized back yard. Lots of room for all your pets or children to play safely. Schedule your private viewing today!','0.1664','55','','','','','Sellers Disclosure','','','','','Central Electric','0','WHARTON BLOCK 53 LOT 10','Subdivision Lot','7248','Appraisal District','','','0','','1','','0','','','','','Composition','180 - Wharton','CG SIVELLS/WHARTON ELEMENTARY SCHOOL','WHARTON HIGH SCHOOL','WHARTON JUNIOR HIGH','Supra Keybox','Appraisal District','1','Traditional','Wharton','1567','2.3512','Public Sewer,Public Water','1930','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','214978470','1669054921','214978470','2022-11-20T09:26:24.887','66395119','Rosalie Stevenson','Rose Above Realty','','','29.415063','-95.019114','17','77591','9','348990.00','Active','Rockefeller Road','3409','','Texas City','3','0','4','2034','Single-Family','OVERSIZED LOT! New Construction home has everything you need, including the latest in energy efficient features. This \"LAKEWAY\" plan has a modern farmhouse elevation. One-story home featuring 4 bedrooms, 3 Full baths with a study and 2 car garage. The kitchen includes a breakfast bar with beautiful granite counter tops, 42\" Cabinets, Stainless Steel Appliances, a corner pantry and connects to the dining and family room. The primary suite features a sloped ceiling and attractive primary bath with granite counter and dual vanities, walk in shower and walk-in closet. The standard rear covered patio is located off the family room. 4 SIDES BRICK! Smart home automation, wireless security at exterior doors, SKybell(R) doorbell, smart lighting. Get ready for the sparkling new look and space of your very own home. Home is under construction. Lock in your new home!','','33','DR Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Texas City','Central Gas','1','Lot 24 BLK 1 Sect 1','Subdivision Lot','11995','Other','','650','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','17 - Dickinson','HUGHES ROAD ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','JOHN AND SHAMARION BARBER MIDDLE SCHOOL','Appointment Required,No Appointment Required','Builder','1','Contemporary/Modern','Central Park','','3.54','Public Sewer,Public Water','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','214979244','1669054921','214979244','2022-11-20T10:47:10.953','85909134','Diane Trykowski','Platinum Key Realty','','','29.979428','-95.201606','31','77346','9','270000.00','Active','Gypsy Forest','4834','Drive','Humble','2','1','4','2330','Single-Family','Look no further! This spacious 4 bedroom, 2.5 bath home is waiting for you! 4834 Gypsy Forest is located in a quiet neighborhood that backs to a heavily wooded area. Home features laminate wood flooring, solar panels, a large covered patio with structure and firepit, driveway extension, plus so much more! Home has only had 2 owners so it has been greatly taken care of. Come and see your new home today!','0.1284','1','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Atascocita South','Central Gas','1','LT 15 BLK 6 TIMBER FOREST SEC 4','Subdivision Lot','5591','Appraisal District','','450','0','','2','Gas Oven,Single Oven','0','','','Gas Cooktop,Gas Range','','Composition','29 - Humble','WHISPERING PINES ELEMENTARY SCHOOL','HUMBLE HIGH SCHOOL','HUMBLE MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Timber Forest','6053','2.933','Water District','1996','Appraisal District'); --> New record created successfully