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-22T19:02:51.113' ,`MLSNumber` = '86094189' ,`ListAgentFullName` = 'Jorge Llanas' ,`ListOfficeName` = 'David Hulsey, REALTORS ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781812' ,`Longitude` = '-95.351109' ,`PhotoCount` = '6' ,`PostalCode` = '77026' ,`RoomCount` = '7' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Hardy' ,`StreetNumber` = '2210' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1663' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property being sold for lot value only. Buyers do your own due-diligence regarding the structure on the property.' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 37 LITTLE & DICKINSON' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHERMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Photos/No Videos,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Little & Dickinson' ,`TaxAmount` = '5250' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641384' WHERE `Matrix_Unique_ID` = '201331760' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T19:18:06.153' ,`MLSNumber` = '16540814' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.322560' ,`Longitude` = '-95.514912' ,`PhotoCount` = '38' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '508834.00' ,`Status` = 'Active' ,`StreetName` = 'Coxcomb' ,`StreetNumber` = '106' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2271' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Hennesey new home plan presents a delightful balance of energy-efficiency, individual privacy, and elegant gathering spaces. Host unforgettable celebrations in the sunny, open-concept living kitchen, dining area, and family room. The Owner’s Retreat includes a luxurious en suite bathroom and an oversized walk-in closet. The spare bedrooms include sizable closets and room for personal flair. The extra garage space offers incredible potential for you to use as storage or to create a crafty workshop. The study, powder room, and bonus closet give this home a private area for working from home. Build your future with the peace of mind that Our Industry-leading Warranty brings to this new home plan.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 03 Block 04' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7186' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1073' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Central Park' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641384' WHERE `Matrix_Unique_ID` = '207895860' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T19:01:52.693' ,`MLSNumber` = '93810268' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.801451' ,`Longitude` = '-95.112230' ,`PhotoCount` = '38' ,`PostalCode` = '77360' ,`RoomCount` = '5' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeview Wood' ,`StreetNumber` = '210' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1449' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PANORAMIC WATER VIEWS FROM EVERY ROOM! This breathtaking lake house situated on a double lot has it all! Recently upgraded, this 3-story 2 bed 2 bath home on Lake Livingston features a game room upon entrance of the second story with access to the large deck overlooking the lake. The kitchen boasts new granite countertops & tile flooring, a breakfast bar, pantry and opens up to the oversized family room. The bedrooms are generous in size and the master bedroom features an en-suite bath with a walk-in shower! Exterior features include dual boat lifts, a massive pier, covered patio, plenty of space for parking and outdoor gatherings! Recent upgrades include: New roof, AC unit, windows, wave runner, exterior paint, interior paint, steel bulkhead, granite and tile flooring, plumbing, and gutters! This home is priced to sell and won\'t last long! Schedule a private tour today!' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'IMPALA WOODS SECTION 4 BLK 4 LOT 24' ,`LotDesciption` = 'Cleared,Water View,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '170' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Impala Woods' ,`TaxAmount` = '5049' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641385' WHERE `Matrix_Unique_ID` = '208288038' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T20:30:23.840' ,`MLSNumber` = '38521205' ,`ListAgentFullName` = 'Cindy Villatoro' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.784353' ,`Longitude` = '-95.310616' ,`PhotoCount` = '19' ,`PostalCode` = '77020' ,`RoomCount` = '3' ,`ListPrice` = '179900.00' ,`Status` = 'Active' ,`StreetName` = 'Hoffman' ,`StreetNumber` = '234' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great starter home or rental income investment. Extension for a 3rd bedroom, game-room, or a second living-room. Minutes away from Downtown, Medical Center, and Stadiums. Call directly to apply for a loan today!' ,`Acres` = '0.1435' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 31 & 32 BLK 101 DENVER' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELIOT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Denver' ,`TaxAmount` = '2455' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669641385' WHERE `Matrix_Unique_ID` = '209351478' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T20:37:18.523' ,`MLSNumber` = '50619530' ,`ListAgentFullName` = 'Loulou Hayes' ,`ListOfficeName` = 'Santa Fe Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.382171' ,`Longitude` = '-94.970341' ,`PhotoCount` = '14' ,`PostalCode` = '77591' ,`RoomCount` = '6' ,`ListPrice` = '169000.00' ,`Status` = 'Active' ,`StreetName` = 'Post Oak' ,`StreetNumber` = '205' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1838' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3/2/2 BRICK HOME WITH METAL ROOF. A/C REPLACED IN 2020. FORMAL LIVING ROOM. FAMILY ROOM IS UNIQUE WITH AN INTERIOR BRICK ACCENT WALL. STORAGE SHED IN THE BACK. \r\nNICE MATURE TREES WITH LOTS OF SHADING FOR THOSE HOT SUMMER DAYS. COVERED BACK PATIO WITH A NATURAL GAS GRILL THAT WILL REMAIN.' ,`Acres` = '0.1422' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 126 PAGE 1 NE PT OF TR A (0-1) OAK PARK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6195' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'SIMMS ELEMENTARY SCHOOL (TEXAS CITY)' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Park 2' ,`TaxAmount` = '2951' ,`TaxRate` = '2.582' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641385' WHERE `Matrix_Unique_ID` = '211154295' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T20:41:35.387' ,`MLSNumber` = '67234764' ,`ListAgentFullName` = 'Reyna Portillo' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.600093' ,`Longitude` = '-95.212687' ,`PhotoCount` = '23' ,`PostalCode` = '77089' ,`RoomCount` = '3' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Sagehollow' ,`StreetNumber` = '11618' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1807' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'welcome to 11618 , This home has been beautifully remodeled . Bring your picky buyers and schedule a viewing soon.' ,`Acres` = '0.1641' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 12 SAGEMONT SEC 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'STUCHBERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Sagemont Sec 03' ,`TaxAmount` = '3773' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641385' WHERE `Matrix_Unique_ID` = '211321873' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T20:35:51.040' ,`MLSNumber` = '69907486' ,`ListAgentFullName` = 'Carlos Garcia II' ,`ListOfficeName` = 'Carlos Garcia Realty' ,`SellingAgentFullName` = 'Cesar Martinez' ,`SellingOfficeName` = 'BlueRoof Real Estate, LLC' ,`Latitude` = '29.734290' ,`Longitude` = '-95.328252' ,`PhotoCount` = '17' ,`PostalCode` = '77023' ,`RoomCount` = '5' ,`ListPrice` = '260000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Leeland' ,`StreetNumber` = '4928' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '965' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Quaint brick two bedroom with central air and heat, a two-car garage, and a fully fenced yard. This house is literally within blocks of the elementary, middle and high schools. there is also a charter school right down the block.' ,`Acres` = '0.1106' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 13 EASTLAWN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4816' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CAGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Eastlawn' ,`TaxAmount` = '2748' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641386' WHERE `Matrix_Unique_ID` = '212103948' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T19:24:36.593' ,`MLSNumber` = '30105311' ,`ListAgentFullName` = 'Lupe Quiroga' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = 'Joseph Hoang' ,`SellingOfficeName` = 'Exceed Realty' ,`Latitude` = '29.838810' ,`Longitude` = '-95.697984' ,`PhotoCount` = '18' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '280000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Orchard Blossom' ,`StreetNumber` = '4602' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2165' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice Corner lot home. Great entry foyer 4 bedroom or could be a study. Formal Dining and Living room.\r\nIsland kitchen. breakfast area. Covered back yard patio. Near by walking trail and Pool, Park, and Playground.\r\nMany restaurants and plenty of shopping Center in the area.' ,`Acres` = '0.1326' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 79 BLK 6 ROLLING CREEK SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '5775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '710' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SHERIDAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rolling Creek Sec 01' ,`TaxAmount` = '6135' ,`TaxRate` = '2.731' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641386' WHERE `Matrix_Unique_ID` = '212105077' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T20:06:18.310' ,`MLSNumber` = '38334352' ,`ListAgentFullName` = 'Michelle Carruthers' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.421700' ,`Longitude` = '-95.736024' ,`PhotoCount` = '50' ,`PostalCode` = '77356' ,`RoomCount` = '4' ,`ListPrice` = '1150000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 1097' ,`StreetNumber` = '25551' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2847' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '~16 acres 10 minutes from Historic Downtown Montgomery. Dare to be different in this custom Barndominium with English Cottage Exterior. Custom rustic elements throughout the home including wood counter tops, beams & door frames made from 100+ year old reclaimed wood. 4 bedrooms, 3 baths with generous living spaces offering functional rooms throughout. \r\nCorrugated steel roof with spray foam insulation. PEX pipes. Home built around steel beam structure on slab with no interior walls being load bearing. 50amp power for RV hookup. \r\nLarge pond for livestock, fishing (bass & perch).\r\nPerimeter fencing with cross fencing at the front for horses; Horse loafing shed. \r\n~7 acres of hayfields (Bahia w mix of natural grasses) fertilized & cut. \r\nPlenty of opportunity to clear & add structures or leave the property as-is to enjoy the abundant wildlife that visits throughout the year. Some of the most beautiful sunsets you\'ve ever seen! Bring your horses & enjoy the Town & Country life!' ,`Acres` = '15.92' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0021 - LANDRUM WM, TRACT 5-E, ACRES 15.92' ,`LotDesciption` = 'Cleared,Waterfront,Wooded' ,`LotSize` = '639475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Landrum WM' ,`TaxAmount` = '3266' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641386' WHERE `Matrix_Unique_ID` = '212447968' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T20:23:59.780' ,`MLSNumber` = '75368879' ,`ListAgentFullName` = 'Jerri Alonzo' ,`ListOfficeName` = 'Keller Williams Heritage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.783458' ,`Longitude` = '-94.910652' ,`PhotoCount` = '30' ,`PostalCode` = '77523' ,`RoomCount` = '9' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Sandy Creek' ,`StreetNumber` = '6007' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2493' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '\"Home Sweet Home\" one of the largest homes in the subdivision. 4 bedrooms, 2.5 bathroom, new roof and water heater. Living room adjoins kitchen with recently installed: kitchen cabinets, kitchen countertops, dishwasher, stove. Breakfast nook and double door pantry. Upstairs, spacious game room, with three additional bedrooms and additional bath. The primary bedroom, located on main floor, is very spacious and bathroom has a large closet as well as a walk-in shower. NO backyard neighbors. Did I mention, it has an Epoxy garage floor. Minutes from the elementary school. LOW PROPERTY TAXES! in Chambers County. Located close to shopping, entertainment, and dining. Right off Hwy 146 and close to I-10.' ,`Acres` = '0.127' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BK 1 LT 2 DEVINWOOD PHASE I' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5532' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Devinwood Ph 01' ,`TaxAmount` = '5661' ,`TaxRate` = '2.9232' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641386' WHERE `Matrix_Unique_ID` = '212484552' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T20:07:00.520' ,`MLSNumber` = '55548735' ,`ListAgentFullName` = 'Luis Nunez' ,`ListOfficeName` = 'Keller Williams HoustonCentral' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.936816' ,`Longitude` = '-95.752714' ,`PhotoCount` = '28' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Grove' ,`StreetNumber` = '16203' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3815' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of the few 5 bedroom homes in the area, only two years old, 2-story home features an entry with 21’ ceilings that extend past the study. Open kitchen features 42” raised panel cabinets, granite countertop, and high-bar seating. Oversized 17’ x 23’ family room with 21’ ceilings, corner fireplace, and full wall of windows. Master bath includes a 6’ garden tub, separate shower, His & Hers vanities, and dual walk-in closets. Located upstairs are 3 bedrooms, 2 baths, media room, and a game room.' ,`Acres` = '0.236' ,`Area` = '25' ,`BuilderName` = 'Ravenna Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 35 BLK 1 BRIDGELAND PARKLAND VILLAGE SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10279' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland Parkland Village Sec 8' ,`TaxAmount` = '18433' ,`TaxRate` = '3.4929' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669641386' WHERE `Matrix_Unique_ID` = '212552548' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T19:59:59.177' ,`MLSNumber` = '53331471' ,`ListAgentFullName` = 'Lisa Perez' ,`ListOfficeName` = 'Country Pride Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.002085' ,`Longitude` = '-95.797658' ,`PhotoCount` = '41' ,`PostalCode` = '77447' ,`RoomCount` = '4' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Adam Prairie' ,`StreetNumber` = '16319' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2695' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This totally updated 3 bed 2 full bath home sits on a large corner lot, great open concept with high ceilings, formal entry, kitchen/dining/living combo. Kitchen has a huge island with seating area for breakfast for visiting. Sink/dishwasher on the island, nice gas drop in cooktop with double ovens and lots of cabinet space. The huge living area is adorned with a gas log fireplace and so many windows on the back wall that let that natural lighting in. Great split bedroom floorplan offers the owner ultimate privacy with the 2 guest bedrooms at the front of the home and the master suite at the back. There is a nice flex room off the wide formal entry that can be your home office, library or even a 4th bedroom. Master en-suite boasts a huge soaker tub, separate walk-in shower with glass doors, split his/hers vanities and huge walk-in closet that will amaze. Great fenced in back and side yard for entertaining, relaxing and furry friends. Sprinkler system keeps your lawn green.' ,`Acres` = '0.2035' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 1 STONE CREEK RANCH SEC 5' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '8863' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '9693' ,`TaxRate` = '3.1924' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641387' WHERE `Matrix_Unique_ID` = '212627516' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T20:09:29.840' ,`MLSNumber` = '92095850' ,`ListAgentFullName` = 'Gerald Gonzalez' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.878897' ,`Longitude` = '-95.289752' ,`PhotoCount` = '11' ,`PostalCode` = '77016' ,`RoomCount` = '2' ,`ListPrice` = '132000.00' ,`Status` = 'Active' ,`StreetName` = 'Hopper' ,`StreetNumber` = '6707' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '793' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come Check out this cozy Home in the heart of Houston\'s Hispanic cultural center! This Home has been fully remodeled to Morden fixtures and is perfect as a starter home or investment! The Home has space in both the front and back yards, great for events, BBQ\'s or just having a relaxed day! Don\'t miss the opportunity to come to see this wonderful Home that can be your Home!' ,`Acres` = '0.1371' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 23 BLK 54 NORTHWOOD MANOR SEC 6' ,`LotDesciption` = 'Corner,Other' ,`LotSize` = '5972' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northwood Manor Sec 06' ,`TaxAmount` = '2291' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641387' WHERE `Matrix_Unique_ID` = '212748127' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T19:45:55.850' ,`MLSNumber` = '30942937' ,`ListAgentFullName` = 'Jayson Peoples' ,`ListOfficeName` = 'Greater Houston REP, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.751012' ,`Longitude` = '-95.583132' ,`PhotoCount` = '28' ,`PostalCode` = '77077' ,`RoomCount` = '11' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Brookspring' ,`StreetNumber` = '11607' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW!!! Freshly updated 4 bed/3.5 bath home located in the beautiful Lakeside Place neighborhood! With updated landscaping in the front and back, outdoor patio, fresh exterior and interior paint, wood and tile flooring, gutters, front door and the list goes on. This floor plan features large rooms and functionality. The office and primary suite are settled in their own section of the home for privacy. The huge family room downstairs and the large gameroom upstairs provide plenty of room for play and relaxation. Large kitchen with granite tops, ss appliances, 6 burner gas cooktop, double convection ovens and recently painted white kitchen cabinets. This home has everything you could want with tons of storage, large windows for natural light and an inviting yard to enjoy. Location is everything and this property does not disappoint with easy access to City Centre, BW8, I-10 & Westpark Tollway. Great shopping and dining options are close by. This home is ready for it\'s new family!' ,`Acres` = '0.1901' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 12 LAKESIDE PLACE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '860' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASKEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeside Place' ,`TaxAmount` = '9690' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641387' WHERE `Matrix_Unique_ID` = '213092342' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T19:19:53.837' ,`MLSNumber` = '93722170' ,`ListAgentFullName` = 'Emily Arce' ,`ListOfficeName` = 'One Property Grp' ,`SellingAgentFullName` = 'Steven Cline' ,`SellingOfficeName` = 'CB&A, Realtors-Katy' ,`Latitude` = '30.190036' ,`Longitude` = '-95.339363' ,`PhotoCount` = '50' ,`PostalCode` = '77302' ,`RoomCount` = '3' ,`ListPrice` = '375000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Village Woods' ,`StreetNumber` = '15472' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1794' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming country home nestled at the end of the road has it all! Situated on nearly three acres, the property features a 3 bedroom, 2 bath home with stunning rustic touches throughout. The vaulted ceiling showcases a wood beam upon entry, wooden cabinetry with open shelving, wine rack, walk-in pantry, wood like tile throughout, and a built-in kegerator. Some additional features are the large primary bedroom with a walk-in closet, a stunning living area with a gorgeous wood burning fireplace, oversized windows with lots of natural light and a wet bar for entertaining. The property includes a 60 x 40 Metal building with insulation & two 12 ft bay doors, a pond fully stocked with blue gill, perch and blue cat, a back to eden garden plus fruit trees scatted throughout the property that includes pear, plum and fig. Wrought Iron fencing along the front, shady mature trees and an inviting front porch offer a peaceful escape from a busy day. Great location & the pool table stays!' ,`Acres` = '2.8395' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'VILLAGE WOODS, LOT 12,13,14,15' ,`LotDesciption` = 'Cleared' ,`LotSize` = '123689' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Woods' ,`TaxAmount` = '1143' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641387' WHERE `Matrix_Unique_ID` = '213385255' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T19:45:19.347' ,`MLSNumber` = '70055519' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.038055' ,`Longitude` = '-95.405043' ,`PhotoCount` = '26' ,`PostalCode` = '77531' ,`RoomCount` = '6' ,`ListPrice` = '298000.00' ,`Status` = 'Active' ,`StreetName` = 'Hancock' ,`StreetNumber` = '202' ,`StreetSuffix` = 'Street' ,`City` = 'Clute' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1841' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come home to this beautifully updated 3 bedroom, 2 bath home in the lovely College Park subdivision. This home is conveniently located near schools, restaurants and the highway - giving you everything you could possibly need, nearby. The kitchen is a chef\'s dream with quartz countertops and a butcher-block island. Most of the appliances have been recently replaced, along with the A/C unit as well as flooring, paint updates and landscaping improvements. An attached generator will keep things running when needed. This home won\'t stay, so call today to make it yours!' ,`Acres` = '0.2166' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clute' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'COLLEGE PARK ESTATES SEC 5 (A0066 J E GROCE) (CLUTE) BLK 4 L' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9435' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'GRIFFITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'College Park Estates Sec 5' ,`TaxAmount` = '7207' ,`TaxRate` = '2.6231' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641388' WHERE `Matrix_Unique_ID` = '213412983' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T19:37:31.860' ,`MLSNumber` = '3870262' ,`ListAgentFullName` = 'Keaton Labby' ,`ListOfficeName` = 'Home Simple Of Texas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.954206' ,`Longitude` = '-95.203202' ,`PhotoCount` = '39' ,`PostalCode` = '77346' ,`RoomCount` = '5' ,`ListPrice` = '440000.00' ,`Status` = 'Active' ,`StreetName` = 'California Sister' ,`StreetNumber` = '11970' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built by Highland Homes - The Everleigh features a lovely wrap around porch and two story entry. Downstairs is an open living area with double-stacked windows that give the home great natural light. The kitchen has a large island, window seat and an abundance of cabinets. Beautiful wood look flooring is in all the main living areas. The primary suite is downstairs, along with a second bedroom. Relaxing will be easy in the primary suite with a freestanding tub and bay window. Upstairs are 2 additional bedrooms, a full bath and a game room. Includes a SMART HOME Package, tankless water heater, full sprinkler system and a 2-car garage. Located close to many of the amenities The Groves has including: the Resort Style Pool, Adaptive Sports Complex, Amenity Center, Lifestyle Center, Fish Camp, Exploration Trails, Mini Groves Toddler Park!!!' ,`Acres` = '0.1367' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 4 GROVES SEC 33' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5954' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '264' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Groves Sec 33' ,`TaxAmount` = '1987' ,`TaxRate` = '3.5373' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641388' WHERE `Matrix_Unique_ID` = '213474149' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T19:08:16.397' ,`MLSNumber` = '70594015' ,`ListAgentFullName` = 'Colleen Carriere' ,`ListOfficeName` = 'Asset Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.563865' ,`Longitude` = '-95.738436' ,`PhotoCount` = '20' ,`PostalCode` = '77469' ,`RoomCount` = '6' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'County Seat' ,`StreetNumber` = '3735' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1499' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and check out this beautiful 2 bedroom, 2 bath, with a bonus room that can be used as a home office/study with French Doors or as a 3rd bedroom! Gleaming hardwood floors and tile throughout...no carpet. Primary bedroom is light and bright with a wall of windows and huge walk-in closet. Expertly landscaped front and backyard with covered patio and sprinkler system. Located in the fabulous Del Webb Sweetgrass community--adult 55+, this home was designed for easy living and great for entertaining! The Del Webb community offers several incredible amenities: 27,000 sq. ft. lake house/recreation center, fitness center with indoor lap pool. Enjoy the neighborhood\'s natural scenery, large lake, miles of walking trails, and an outdoor amphitheater. Close to medical, dining, shopping, and entertainment!!!' ,`Acres` = '0.1121' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'DEL WEBB RICHMOND SEC 9-A, BLOCK 5, LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4884' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Webb Richmond Sec 9-A' ,`TaxAmount` = '6177' ,`TaxRate` = '2.9548' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641388' WHERE `Matrix_Unique_ID` = '213503089' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T20:39:29.450' ,`MLSNumber` = '90895554' ,`ListAgentFullName` = 'Sonya Burnett' ,`ListOfficeName` = 'RE/MAX East' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838765' ,`Longitude` = '-95.250178' ,`PhotoCount` = '50' ,`PostalCode` = '77078' ,`RoomCount` = '5' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Knoll' ,`StreetNumber` = '9254' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1282' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make this amazing home yours! First home entails 3 bedrooms and one full bath. Owner was in the process of expanding the closet and adding a private primary bath, but will leave it to be completed by new owner. Granite countertops in kitchen, oversized laundry room is located inside the home. Enjoy your evenings outside with the covered patio and additional exterior kitchen. Bring along a parent or college aged child with a second living quarters. Consists of a family room, bedroom, full bathroom in addition to an additional attached bathroom. Store your belongings in the multilevel storage building. Extra space in the back is on concreted ground. Lots of backyard space great for a tenant or family member.' ,`Acres` = '0.2316' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 908 BLK 41 CHATWOOD PLACE SEC 6' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '10088' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chatwood Place Sec 06' ,`TaxAmount` = '3317' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641388' WHERE `Matrix_Unique_ID` = '213553619' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T20:17:51.473' ,`MLSNumber` = '74866242' ,`ListAgentFullName` = 'Shari Postel' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.115887' ,`Longitude` = '-95.240517' ,`PhotoCount` = '33' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Colony' ,`StreetNumber` = '21617' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1475' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Reduced & Ready! Beautiful brick 3/2/2 with great split floorplan, high ceilings, laminate & tile flooring throughout. Home also features large family room with corner gas fireplace and dining room with pass-through bar to kitchen. Gas appliances, kitchen with bay window! Primary bedroom with attached bathroom that features double sinks, soaking tub, separate shower and huge walk-in closet. Ceiling fans and 2\" mini-blinds throughout. High ceilings, inside utility room. Neutral colors, no carpet! Front double wide driveway. Fenced back yard that backs to woods and features a huge, private covered porch and storage building! Very convenient location, close to Hwy 59/69 and minutes from 99 tollroad. Valley Ranch area has dining, shopping and theater. Neighborhood pool/park is nearby, and property is minutes from IAH Bush Airport. Estate sale, come see this beautiful home!' ,`Acres` = '0.1452' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud,No Disclosures,Probate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FOREST COLONY 01, BLOCK 1, LOT 37' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6326' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '615' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'VALLEY RANCH ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW CANEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Colony' ,`TaxAmount` = '3944' ,`TaxRate` = '2.5431' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641389' WHERE `Matrix_Unique_ID` = '213639000' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T20:41:10.957' ,`MLSNumber` = '60571309' ,`ListAgentFullName` = 'Angie Farish' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.098106' ,`Longitude` = '-95.281916' ,`PhotoCount` = '48' ,`PostalCode` = '77365' ,`RoomCount` = '9' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Iris' ,`StreetNumber` = '18923' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2097' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your newly built one-story home situated over .22 acres of land! The double-wide and deep driveway can accommodate up to 6 cars in addition to the 2-car attached garage. Enter through the grand sidelight door and checkout the chef’s kitchen, lined with white crisp cabinetry! Appliances strategically placed for convenient cooking, and a grand ole sink to clean it all up, after! Perfectly placed trey ceilings make this home look modern and luxurious! A primary en suite bathroom with a magnificent soaking tub and a walk-in shower! Double sinks with bright and impressive vanity lights. Need storage? The primary bedroom has an enormous walk-in closet and additional storage closets throughout the home. Whether you want light from the home or natural light, this home provides both with the recessed lighting throughout. Take a tour to see for yourself. This could all be yours!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'David Luis' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SUMMER HILLS 01 LOT 267' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BROOKWOOD FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'SUMMER HILLS 01' ,`TaxAmount` = '1154' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641389' WHERE `Matrix_Unique_ID` = '214278262' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T19:23:49.093' ,`MLSNumber` = '79106200' ,`ListAgentFullName` = 'Stacy Wood' ,`ListOfficeName` = 'Compass RE Texas, LLCHeights' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830815' ,`Longitude` = '-95.443084' ,`PhotoCount` = '19' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '1099000.00' ,`Status` = 'Active' ,`StreetName` = 'Libbey' ,`StreetNumber` = '1709' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3632' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1722' ,`Area` = '9' ,`BuilderName` = 'Resources Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 30 BLK 59 OAK FOREST SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7994' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest Add Sec 06' ,`TaxAmount` = '8061' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641389' WHERE `Matrix_Unique_ID` = '214286072' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T19:13:00.060' ,`MLSNumber` = '67899557' ,`ListAgentFullName` = 'Mohammed Ansari' ,`ListOfficeName` = 'Greenleaf Realty' ,`SellingAgentFullName` = 'Sheryle Campbell' ,`SellingOfficeName` = 'Energy Realty' ,`Latitude` = '29.846707' ,`Longitude` = '-95.592811' ,`PhotoCount` = '49' ,`PostalCode` = '77041' ,`RoomCount` = '11' ,`ListPrice` = '599900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sterling' ,`StreetNumber` = '5419' ,`StreetSuffix` = 'Brook' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '4034' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Look no further! This is a beautiful Governor Mansion style 6 Bedroom home, sitting on a corner lot with no direct back neighbor, and within the Manned Gated Subdivision “The Lakes on Eldridge.” House is equipped with new modern countertop, sink and the kitchen is open to the living room! High Ceiling throughout this beautiful home! Capable of offering four vehicles covered! Both Kitchen and Master Bath are Newly Renovated! Spacious rooms, closet, pantry, utility room throughout! This home is equipped with Water Softener, Lawn Sprinkler, French Drain and fully guttered. This is a must-see home! Picture says everything about this home!' ,`Acres` = '0.215' ,`Area` = '8' ,`BuilderName` = 'VILLAGE BUILDER' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 36 BLK 1 LAKES ON ELDRIDGE SEC 18' ,`LotDesciption` = 'Corner' ,`LotSize` = '9365' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1460' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lakes On Eldridge' ,`TaxAmount` = '13267' ,`TaxRate` = '2.471' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641389' WHERE `Matrix_Unique_ID` = '214475656' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T19:52:03.983' ,`MLSNumber` = '67395241' ,`ListAgentFullName` = 'Paige Houston' ,`ListOfficeName` = 'Texas Real Estate Pro' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.045066' ,`Longitude` = '-95.363685' ,`PhotoCount` = '20' ,`PostalCode` = '77373' ,`RoomCount` = '2' ,`ListPrice` = '185000.00' ,`Status` = 'Active' ,`StreetName` = 'Monteith' ,`StreetNumber` = '4507' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 bedroom 2 bathroom home in Spring! Being sold AS-IS! High ceilings & laminate floors in the living room. Split floor plan. COVERED BACK PATIO & BIG YARD! Fully fenced backyard. The community features a subdivision pool, park & tennis courts! Located closed to 1960 & Hardy! Approximately 20 minutes from IAH Airport.' ,`Acres` = '0.178' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 5 BIRNAM WOOD SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7754' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MILDRED JENKINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Birnam Wood' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641389' WHERE `Matrix_Unique_ID` = '214507684' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T19:02:58.557' ,`MLSNumber` = '60170645' ,`ListAgentFullName` = 'Carla Wade' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = 'Grant Rothberg' ,`SellingOfficeName` = 'Keller Williams Hou Preferred' ,`Latitude` = '29.474723' ,`Longitude` = '-95.146760' ,`PhotoCount` = '45' ,`PostalCode` = '77573' ,`RoomCount` = '11' ,`ListPrice` = '629000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cross Creek' ,`StreetNumber` = '5204' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4132' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Lovely David Weekly Barden 5 bedroom home is nestled on a huge cul-de-sac lot in the Estates section and features a welcoming front porch with pretty stone arched entry, 3 car garage, sparkling pool with spa and waterfall, outdoor kitchen, huge side yards and a 3rd floor game room with half bath! The kitchen has pretty Silestone counters, an island, stainless appliances and overlooks the large family room with it\'s soaring ceilings and wall of windows with pool views. Other upgrades include Plantation Windows with rosette corners and fluted molding on every window, added insulation in the ceiling between the primary suite and 2nd floor gameroom and between the 2nd and 3rd floor gamerooms. No MUD or PID taxes! Zoned for Clear Springs High School.' ,`Acres` = '0.2832' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'MAGNOLIA CREEK SEC 4 PH 2 (2002) ABST 607, BLOCK 3, LOT 16,' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '12338' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '726' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GILMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Creek Sec 4 Ph 2' ,`TaxAmount` = '9970' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641390' WHERE `Matrix_Unique_ID` = '214580146' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T19:48:24.653' ,`MLSNumber` = '14554920' ,`ListAgentFullName` = 'Kenneth Purswell' ,`ListOfficeName` = 'Kenneth Purswell - Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.043249' ,`Longitude` = '-95.427197' ,`PhotoCount` = '50' ,`PostalCode` = '77566' ,`RoomCount` = '12' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Rose Trail' ,`StreetNumber` = '103' ,`StreetSuffix` = 'Trail' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2051' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remarkable Remodel/Refurbish, Flooring, Painting, Fixtures, Counters, Cabinets, Bath Shower, Pool,' ,`Acres` = '0.254' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'KINGSWOOD ESTATES (LAKE JACKSON) BLK 2 LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11064' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BEUTEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Kingswood Estates Lake Jackson' ,`TaxAmount` = '4759' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641390' WHERE `Matrix_Unique_ID` = '214613844' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T19:41:29.067' ,`MLSNumber` = '75008364' ,`ListAgentFullName` = 'Blake House' ,`ListOfficeName` = 'Elite Agents' ,`SellingAgentFullName` = 'Mindy Kim' ,`SellingOfficeName` = 'United Real Estate' ,`Latitude` = '29.833122' ,`Longitude` = '-95.779325' ,`PhotoCount` = '45' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '449000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Verona View' ,`StreetNumber` = '23310' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2873' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Only 1 owner has gently lived in this well-maintained home built by Perry Homes. This 4-bedroom/3-bath home has 2 additional large bonus rooms that can be used as study/office, game room or formal dining. The tall coffered ceilings and wide arches in this open floor plan showoff the openness throughout. In the master bedroom you will find ample room for large furniture and an en-suite bathroom with all the amenities you would want. Large, tall and open is the theme in the kitchen/living area great for any gathering. This homes kitchen is a chefs dream with stainless steel appliances and an abundance of cabinets and counter space. Ventana Lakes offers easy access to the Grand Parkway & the Katy Freeway. Amenities include a club house, pool, outdoor covered picnic area, playground, trails, and green space. Schedule a tour today to see and appreciate this beauty in-person. All measurements and other information should be independently verified.' ,`Acres` = '0.1913' ,`Area` = '25' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 VENTANA LAKES SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8335' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ventana Lakes Sec 5' ,`TaxAmount` = '10567' ,`TaxRate` = '3.2768' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641390' WHERE `Matrix_Unique_ID` = '214768698' --> 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','214807926','1669641390','214807926','2022-11-22T20:23:00.097','26643130','Amy Lippincott','Keller Williams Platinum','','','29.982404','-95.708451','35','77429','7','500000.00','Active','Fairmont Springs','18611','Court','Cypress','2','1','4','2832','Single-Family','Welcome to this beautiful lake view home with 4 bedrooms/2.5 baths located in a gated community called The Reserve across from Cypress Lakes Golf Course. A very warm and welcoming entrance with a 8ft wrought iron and wooden door, high ceilings, hardwood tile flooring. A formal dining room on the right with entry into kitchen from the dining room. Study/4th bedroom on the left next to the half bathroom. Two secondary bedrooms and a secondary bathroom finish off the front of the home. Open floor plan awaits you in the kitchen and living area. The kitchen has beautiful white cabinets, granite countertops, island, farm sink, and a nice breakfast nook. The living room has the hardwood tile floors, high ceilings, stone gas fireplace and a wall of windows. Upstairs, you will find a large game room with storage closet and attic access with some decking. The backyard is a dreamy one with a custom oversized patio overlooking the lake. Such a beautiful home ready for the next family to love.','0.1515','35','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Cypress North','Central Gas','1','LT 18 BLK 1 VILLAGES OF CYPRESS LAKES SEC 29','Cul-De-Sac,Subdivision Lot','6600','Appraisal District','','1400','0','','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','A ROBISON ELEMENTARY SCHOOL','CYPRESS WOODS HIGH SCHOOL','GOODSON MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1.5','Traditional','Villages of Cypress Lakes','11438','3.061','Public Sewer,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','215045741','1669641390','215045741','2022-11-22T19:29:23.330','84180090','Neil Ally','Executive Texas Realty','','','29.721606','-95.798280','30','77494','6','439999.00','Active','Azalea Meadow','5103','Lane','Katy','2','1','4','2438','Single-Family','Beautiful and extremely well maintained home in the coveted Cinco Ranch neighborhood in Katy. Centrally located in the subdivision completely surrounded by each level of school, the parks, tennis courts, and swimming pools that are all amenities to this location, and its is in one of the best school districts in the Houston area. \r\n\r\nThe roof was replaced in 2016 and all carpet was replaced with beautiful real hardwood floors. This was the model home for the neighborhood so it has all of the upgrades and it features a sprinkler system, and widened driveway. Owners never had any pets.','0.1331','36','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Katy - Southwest','Central Gas','1','CINCO WEST AT SEVEN MEADOWS SEC 5, BLOCK 3, LOT 8','Cul-De-Sac','5799','Appraisal District','','1115','0','','2','Gas Oven','0','In Ground','','Gas Range','','Composition','30 - Katy','KILPATRICK ELEMENTARY SCHOOL','SEVEN LAKES HIGH SCHOOL','BECKENDORFF JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','2','Traditional','Cinco West At Seven Meadows Sec 5','6392','2.3145','Public Sewer,Public Water,Water District','2007','Appraisal'); --> 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','215045901','1669641390','215045901','2022-11-22T19:47:34.610','10381011','Stacy Newton','Weichert,REALTORS-Murray Group','','','30.018270','-95.536872','48','77379','10','524000.00','Active','Vickridge','8011','Lane','Spring','4','2','5','5005','Single-Family','MOTIVATED SELLER - ALL OFFERS WILL BE PRESENTED!! Stately colonial home situated on a quiet cul-de-sac. This home offers everything and then some. For the chef in the family the kitchen offers GE profile and Bosch appliances along with an oversized island. At the back of the home there is a sun room that overlooks the oversized backyard and in the ground pool. There is a large room above the 3 car garage that could be used as a 2nd living space or game room. The primary bedroom sits on the first floor with all secondary bedrooms upstairs. When you walk through the front door you are met with natural light throughout the home. This spacious floor plan with both a formal living space and formal dining area offers the perfect place to entertain. Zoned to exceptional schools and close to dining and shopping the possibilities are endless. Call today to schedule your private showing! You don\'t want to miss this!','0.4092','13','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Champions Area','Central Gas','1','LT 9 BLK 4 017*M1876900-002-004-009 MEMORIAL NORTHWEST SEC 2','Cul-De-Sac','17825','Appraisal District','','693','0','','3','Double Oven','1','In Ground','','Electric Cooktop','','Composition','32 - Klein','THEISS ELEMENTARY SCHOOL','KLEIN HIGH SCHOOL','DOERRE INTERMEDIATE SCHOOL','Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox','Appraisal District','2','Colonial,Traditional','Memorial Northwest Sec 02 R/P','7452','2.3213','Public Sewer,Public Water,Water District','1972','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215045982','1669641391','215045982','2022-11-22T19:40:49.007','74243909','Stacy Newton','Weichert,REALTORS-Murray Group','','','30.118654','-95.502014','32','77389','7','348900.00','Active','Glenfield Spring','5422','Lane','Spring','2','0','3','2249','Single-Family','Charming one story home conveniently located. Upon walking up to this home you are welcomed to an inviting front porch. When entering the home you will have a private office/study off of the entry hall. The kitchen with a large walk in pantry and tons of cabinet space is open to the dining room and family room. The back yard backs up to a greenbelt space which offers added privacy so you can sit on the covered back patio and relax. The primary suite has a room connected to it with closet space and a window that could easily be used as a private office, nursery, workout space - the possibilities are endless. Both secondary rooms are down their own hallway for privacy. The home also offers a central vacuum system throughout. Call today to schedule a private showing.','0.1544','14','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Spring/Klein','Central Gas','1','LT 14 BLK 1 HAMPTON CREEK SEC 2 AMEND','Subdivision Lot','6725','Appraisal District','','925','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','32 - Klein','FRENCH ELEMENTARY SCHOOL (KLEIN)','KLEIN OAK HIGH SCHOOL','HOFIUS INTERMEDIATE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Hampton Crk Sec 2','8939','3.304','Public Sewer,Public Water,Water District','2014','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','215046119','1669641391','215046119','2022-11-22T19:54:43.910','31548061','Ashley Young','ERA Legacy Living','','','29.818513','-95.551450','24','77043','5','448999.00','Active','Kenross','2511','Street','Houston','2','0','4','2392','Single-Family','Don\'t miss this beautiful 4 BR 2 Bath home. Located on the corner of an exclusive cul-de-sac in the sought after neighborhood of Spring Branch. This fully renovated home features beautiful finishes from top to bottom including beautiful chevron wood floors. The Kitchen is a chefs dream boasting All New cabinetry, stainless steel appliances, updated lighting and fixtures, on a new extra large kitchen island with quartz counter tops.\r\n\r\n All new plumbing, new water heater, new doors, windows and hardware.Conveniently located, across the street from Terrace Elementary and within minutes from Sam Houston Tollway, and Katy fwy, to make for an easy commute to Memorial area!!. Buyer to independently verify room dimensions.','0.1874','24','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Spring Branch','Central Gas','1','LT 14 BLK 6 MAC GREGOR WEST','Corner,Cul-De-Sac','8164','Appraisal District','','336','0','','2','Gas Oven','0','','','Gas Range','','Composition','49 - Spring Branch','TERRACE ELEMENTARY SCHOOL','SPRING WOODS HIGH SCHOOL','SPRING OAKS MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Mac Gregor West','6434','2.4415','Public Sewer,Public Water','1975','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','215046488','1669641391','215046488','2022-11-22T20:15:26.210','14790355','Cynthia Pierce','Gann Medford Real Estate','','','31.327031','-94.805863','34','75904','5','309400.00','Active','Cedar Hill','424','Loop','Lufkin','2','0','3','1820','Single-Family','Home Sweet Home!! This gorgeous new construction is ready to go! 3 bedrooms and 2 baths with an open concept floorplan. The kitchen offers granite counter tops and bar seating. Vaulted ceilings, shiplap accents and neutral color palette prove no detail was missed! Primary suite has two walk in closets, two sinks, soaking tub and separate shower. Double attached garage with some extra room for storage.','0.22','45','Jimmy Warren','','','','No Disclosures','1','','0','Angelina County','Central Electric','0','3A042 CEDAR HILL SUBD PHASE 2 BLK 1 LOT 36','Subdivision Lot','9583','Appraisal District','','','1','Never Lived In','2','Electric Oven','0','','','','','Composition','262 - Hudson','W.H. BONNER ELEMENTARY SCHOOL','HUDSON HIGH SCHOOL','HUDSON MIDDLE SCHOOL (HUDSON)','Appointment Required','Builder','1','Traditional','Cedar Hill Sub Ph 2','194','1.6824','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','215046553','1669641391','215046553','2022-11-22T20:51:03.973','56634590','Maria Cortes','Anchor Realty Assoc., Inc.','','','29.767747','-94.949414','12','77521','6','185000.00','Active','Apache','1401','Trail','Baytown','2','0','3','1316','Single-Family','Chaparral Village. This property is being sold AS IS, 3 bedrooms, 2 full baths, attached 2 car garage. The property has fire damage to living room and kitchen. Most of the property has smoke damage.','0.1641','2','','','','','No Disclosures','','','','Baytown/Harris County','Central Gas','0','LT 6 BLK 4 CHAPARRAL VILLAGE SEC 1','Subdivision Lot','7150','Appraisal District','','','0','','2','','0','','','','','Composition','23 - Goose Creek Consolidated','CROCKETT ELEMENTARY SCHOOL (GOOSE CREEK)','STERLING HIGH SCHOOL (GOOSE CREEK)','CEDAR BAYOU J H','Accompany,Appointment Required','Appraisal District','1','Traditional','Chaparral Village Sec 01','5317','2.97','Public Sewer,Public Water','1971','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','215046717','1669641391','215046717','2022-11-22T20:56:50.893','15862764','Sylvia Reyes','JLA Realty','','','29.126624','-95.554958','25','77515','7','639900.00','Active','Quarter Horse','1019','Trail','Angleton','3','0','4','3790','Single-Family','Your future home sits on a 43,994 sq. ft. lot with amenities and upgrades that are sure to fit all your needs! No expense was spared; as the slab was poured with the most expensive and highest quality concrete available. Relax in either of your two living areas, have breakfast with a scenic view of your property in the breakfast area, or have a feast fit for a king in the dining room. The beautiful quartz countertops compliment the white porcelain tile floors perfectly, making it an awe-inspiring experience. Your new master bedroom has a separate sitting/office area for an ideal work-from-home situation. The possibilities are endless with this homes’ half-circle driveway and three-car garage. The septic tank holds 250 gallons and the extra large gas tank is sure to last. Your future home is waiting for you, all you need to do is take that first step; come and see it today!','1.01','5','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Angleton','Central Gas','1','BAR X RANCH SEC 2 (A0038 J B BAILEY) BLK 2 LOT 239 (A0053 CA','Subdivision Lot','43996','Appraisal District','','400','0','','3','Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','10 - Columbia-Brazoria','','COLUMBIA HIGH SCHOOL','WEST BRAZOS JUNIOR HIGH','Appointment Required','Appraisal District','2','Traditional','Bar X Ranch Sec 2','8019','1.6364','Septic Tank,Well','2021','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215046790','1669641391','215046790','2022-11-22T20:55:22.363','82709165','Amberly Hall','J. Lindsey Properties','','','29.779649','-95.528347','0','77024','4','1195000.00','Active','Denise','11702','Drive','Houston','3','0','4','2030','Single-Family','','0.29','23','','','Electric Dryer Connections','','Sellers Disclosure','0','','0','Memorial Villages','Central Electric','0','LT 11 BLK 1 MARIAN OAKS','Subdivision Lot','12740','Appraisal District','','','0','','0','Electric Oven','0','','','Gas Cooktop','','Composition','49 - Spring Branch','BUNKER HILL ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (SPRING BRANCH)','SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)','Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Marian Oaks','','','Public Sewer,Public Water','1955','Appraisal District'); --> New record created successfully