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'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','199760761','1663705604','199760761','2022-09-01T14:03:13.697','58801708','Jesse Herrera','HomeSmart','','','29.743459','-94.970057','12','77520','2','164300.00','Active','Scott','406','Street','Baytown','1','0','2','1568','Single-Family','The property has been recently updated and is ready to sell. THERE ARE TWO DOGS ON THE PROPERTY, DO NOT GO WITHOUT AN APPOINTMENT AND THE OWNER RESTRAINING THE DOGS.','0.1837','2','','','','','Sellers Disclosure','0','','','Baytown/Harris County','Central Gas','0','LT 4 BLK 4 KNOWLTON','Subdivision Lot','8000','Appraisal District','','','0','','1','Convection Oven','0','','','','','Composition','23 - Goose Creek Consolidated','LAMAR ELEMENTARY SCHOOL (GOOSE CREEK)','LEE HIGH SCHOOL (GOOSE CREEK)','HORACE MANN J H','Appointment Required','Appraisal District','1','Traditional','Knowlton','2249','2.9705','Public Sewer,Public Water','1945','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','200847081','1663705604','200847081','2022-09-01T14:59:36.493','40379834','Lydia Flores','Lydia\'s Fine Homes, LLC','','','30.079198','-95.330099','20','77386','14','2499990.00','Active','White Birch','6015','Run','Spring','4','1','5','7200','Single-Family','Custom Home in a very great location!! Picture yourself here your DREAM HOME in Benders Landing Estates. Very quite street just located in Cul-De-Sac. Great street for the kids to play on with no thru traffic. Clubhouse within walking distance with all the amenities, Swimming Pool, Workout Facility, Tennis & Basketball Courts, Park & Pavillion,72 Acre Stocked Lake, Exemplary Conroe ISD Schools, Easy access to The Woodlands, I-45, 99, and Hardy. Easy access in and out of neighborhood. Very sought after neighborhood airport, and ExxonMobil Campus. Not located in a flood zone. Enjoy the peaceful surroundings of Bender Landing Estates! Enjoy the tranquility of Country Living without having to leave the city. Your custom dream home awaits! No mud TAXES is must see home will be ready DECEMBER 2022.You can still choose your colors from builders pallet . Grand Oaks Hight School.','1.0799','40','DAHER CUSTOM HOMES,L','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Freestanding,Gaslog Fireplace,Mock Fireplace','1','Spring Northeast','Central Gas','1','S257206 - BENDERS LANDING ESTATES 06, BLOCK 1, LOT 5','Cleared,Cul-De-Sac','47042','Survey','','950','1','To Be Built/Under Construction','3','Double Oven,Electric Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','ANN K. SNYDER ELEMENTARY SCHOOL','GRAND OAKS HIGH SCHOOL','YORK JUNIOR HIGH SCHOOL','No Appointment Required','Builder','2','Mediterranean','Benders Landing Estates 06','2381','1.9103','Public Water,Water District','','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:49:54.137' ,`MLSNumber` = '90838101' ,`ListAgentFullName` = 'Monica Montez' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = 'Nimesh Patel' ,`SellingOfficeName` = 'RE/MAX Fine Properties' ,`Latitude` = '29.810175' ,`Longitude` = '-95.408866' ,`PhotoCount` = '29' ,`PostalCode` = '77008' ,`RoomCount` = '3' ,`ListPrice` = '809900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'W 26th St' ,`StreetNumber` = '615' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3110' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'TITAN HOMES' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 41, BLK 24' ,`LotDesciption` = 'Other' ,`LotSize` = '3275' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,French,Mediterranean,Spanish' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705604' WHERE `Matrix_Unique_ID` = '201781516' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:51:00.140' ,`MLSNumber` = '69630934' ,`ListAgentFullName` = 'Monica Montez' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809779' ,`Longitude` = '-95.408523' ,`PhotoCount` = '35' ,`PostalCode` = '77008' ,`RoomCount` = '3' ,`ListPrice` = '849900.00' ,`Status` = 'Active' ,`StreetName` = 'W 26th St' ,`StreetNumber` = '613' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3110' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'TITAN HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 42, BLK 24' ,`LotDesciption` = 'Other' ,`LotSize` = '3275' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,French,Mediterranean,Spanish' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705604' WHERE `Matrix_Unique_ID` = '201782363' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:05:18.957' ,`MLSNumber` = '69640412' ,`ListAgentFullName` = 'Monica Montez' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809779' ,`Longitude` = '-95.408596' ,`PhotoCount` = '27' ,`PostalCode` = '77008' ,`RoomCount` = '3' ,`ListPrice` = '889900.00' ,`Status` = 'Active' ,`StreetName` = 'W 26th St' ,`StreetNumber` = '617' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3110' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'TITAN HOMES' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT40, BLK24' ,`LotDesciption` = 'Other' ,`LotSize` = '3275' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,French,Mediterranean,Spanish' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705604' WHERE `Matrix_Unique_ID` = '201783126' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:36:46.007' ,`MLSNumber` = '56750157' ,`ListAgentFullName` = 'Alma Roman' ,`ListOfficeName` = 'Pin Property Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.249689' ,`Longitude` = '-95.445615' ,`PhotoCount` = '32' ,`PostalCode` = '77302' ,`RoomCount` = '3' ,`ListPrice` = '313999.00' ,`Status` = 'Active' ,`StreetName` = 'Fort Sumpter' ,`StreetNumber` = '538' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2838' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home! Desirable location in well established neighborhood, conveniently located minutes from N 45, sought after spacious floor plan, and huge curb appeal. Large mature trees surround this gorgeous tree and is absolutely stunning during the spring and summer! Nestled in a quiet cul-de-sac. Large driveway with an additional shed unit next to the driveway makes for amazing storage. Fabulous backyard hosts a pool and deck. Schedule a showing today!' ,`Acres` = '0.2784' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S832003 - RIVER PLANTATION 03, LOT 92' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12128' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'River Plantation 03' ,`TaxAmount` = '4731' ,`TaxRate` = '2.1648' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705604' WHERE `Matrix_Unique_ID` = '205698358' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:46:26.580' ,`MLSNumber` = '86501904' ,`ListAgentFullName` = 'Jeremy Larkin' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.335147' ,`Longitude` = '-95.055647' ,`PhotoCount` = '22' ,`PostalCode` = '77327' ,`RoomCount` = '6' ,`ListPrice` = '284409.00' ,`Status` = 'Active' ,`StreetName` = 'Poppy Hills' ,`StreetNumber` = '20063' ,`StreetSuffix` = 'Lane' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1681' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE-IN READY NEW HOME offered by First America Homes -- located with easy access to TX-105 and a quick commute on I-69. Zoned to Cleveland ISD! This 3 bed, 2 bath home is LOADED with features -- GRANITE kitchen w/ stainless steel appliances, MODERN 36\" cabinetry, recessed can lighting, breakfast room, and breakfast bar that opens to family room. High ceilings, vinyl wood floors in kitchen and wet areas, SPACIOUS guest bedrooms. Private primary retreat featuring dual vanities, separate tub/shower and walk-in closet! Enjoy the covered patio w/ plenty of backyard space for a future pool or just relaxing the weekends away. Community features a super low TAX RATE and LOW HOA dues. Don\'t wait-- Schedule your PRIVATE showing today!!' ,`Acres` = '0.1689' ,`Area` = '52' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND OAKS RESERVE, SEC 4, BLOCK 1, LOT 5, ACRES .1689' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7357' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Oaks Reserve' ,`TaxAmount` = '564' ,`TaxRate` = '2.5563' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705604' WHERE `Matrix_Unique_ID` = '206242685' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:57:41.133' ,`MLSNumber` = '67898157' ,`ListAgentFullName` = 'Jeanette Coury' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.897529' ,`Longitude` = '-95.571953' ,`PhotoCount` = '9' ,`PostalCode` = '77040' ,`RoomCount` = '16' ,`ListPrice` = '777500.00' ,`Status` = 'Active' ,`StreetName` = 'Wyndham Village Drive' ,`StreetNumber` = '8521' ,`StreetSuffix` = '' ,`City` = 'Jersey Village' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Build your DREAM House and Leave the clutter behind in this Modern clean edge style, bright and spacious 4 bedroom, 3-1/2 bath home in the quiet, private community of Wyndham Village, inside Jersey Village. TWO FULL BEDROOM SUITES W/BATHS and NO CARPET on the first floor - Engineered wood and tile floors only! Features brick and stone exterior w/TechShield roof deck and 30-year roof. Front porch delivery closet eliminates theft! Grand entry w/circular stair, oak steps and iron balusters. No need to pack clothes away from summer to winter with the HUGE main closet. Have a cooking party in the GRAND kitchen w/island and lots of cabinets, dbl ovens and cooktop. Jersey Meadow Golf course/club, parks and recreation nearby. NEVER FLOODED! No MUD! Local JV Police. Quick access to US 290 and Beltway 8 with Cy-fair schools nearby. *3-bedroom, 3-1/2 bath plan with 2980sf available at price of $757,500; Call Agent for info on 5 and 6 bedroom and optional garage studio apt available*' ,`Acres` = '' ,`Area` = '10' ,`BuilderName` = 'Wyndham Lake Dev\'t' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Jersey Village' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6, Blk 72' ,`LotDesciption` = 'Cleared,In Golf Course Community,Subdivision Lot' ,`LotSize` = '10118' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '458' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POST ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Wyndham Village' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705604' WHERE `Matrix_Unique_ID` = '206630597' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:02:26.087' ,`MLSNumber` = '39654923' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.162001' ,`Longitude` = '-95.589739' ,`PhotoCount` = '22' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '484990.00' ,`Status` = 'Active' ,`StreetName` = 'Flintlock' ,`StreetNumber` = '26983' ,`StreetSuffix` = 'Trail' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2279' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 39654923 - Built by Highland Homes - September completion! ~ This open concept one story home offers a lot of light and possibilities with it’s blue and natural interior it sets up to make this house a home. The patio is extended and enhanced to allow for lots of room for entertaining. The lot backs to green space and on a cul-de-sac. The primary suite has a bay window. This home also comes with stainless steel appliances, fully sod front and back yard and Smart Home Technology!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7392' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NorthGrove' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705605' WHERE `Matrix_Unique_ID` = '207542775' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:46:05.613' ,`MLSNumber` = '87649788' ,`ListAgentFullName` = 'Jeremy Larkin' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.334693' ,`Longitude` = '-95.054178' ,`PhotoCount` = '17' ,`PostalCode` = '77327' ,`RoomCount` = '5' ,`ListPrice` = '280506.00' ,`Status` = 'Active' ,`StreetName` = 'Torrey Pines' ,`StreetNumber` = '20091' ,`StreetSuffix` = 'Lane' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1681' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW HOME OPPORTUNITY offered by First America Homes -- located with easy access to TX-105 and a quick commute on I-69. Zoned to Cleveland ISD! This 3 bed, 2 bath home is LOADED with features -- GRANITE kitchen w/ stainless steel appliances, MODERN 36\" cabinetry, recessed can lighting, breakfast room, and breakfast bar that opens to family room. High ceilings, vinyl wood floors in kitchen and wet areas, SPACIOUS guest bedrooms. Private primary retreat featuring dual vanities, separate tub/shower and walk-in closet! Enjoy the covered patio w/ plenty of backyard space for a future pool or just relaxing the weekends away. Community features a super low TAX RATE and LOW HOA dues. Don\'t wait-- Schedule your PRIVATE showing today!!' ,`Acres` = '0.1442' ,`Area` = '52' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND OAKS RESERVE, SEC 4, BLOCK 2, LOT 13, ACRES .1442' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6281' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Oaks Reserve' ,`TaxAmount` = '' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705605' WHERE `Matrix_Unique_ID` = '207651202' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:45:49.030' ,`MLSNumber` = '55142077' ,`ListAgentFullName` = 'Jeremy Larkin' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.335290' ,`Longitude` = '-95.054284' ,`PhotoCount` = '16' ,`PostalCode` = '77327' ,`RoomCount` = '4' ,`ListPrice` = '274680.00' ,`Status` = 'Active' ,`StreetName` = 'Torrey Pines' ,`StreetNumber` = '20151' ,`StreetSuffix` = 'Drive' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1681' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW HOME OPPORTUNITY offered by First America Homes -- located with easy access to TX-105 and a quick commute on I-69. Zoned to Cleveland ISD! This 3 bed, 2 bath home is LOADED with features -- GRANITE kitchen w/ stainless steel appliances, MODERN 36\" cabinetry, recessed can lighting, breakfast room, and breakfast bar that opens to family room. High ceilings, vinyl wood floors in kitchen and wet areas, SPACIOUS guest bedrooms. Private primary retreat featuring dual vanities, separate tub/shower and walk-in closet! Enjoy the covered patio w/ plenty of backyard space for a future pool or just relaxing the weekends away. Community features a super low TAX RATE and LOW HOA dues. Don\'t wait-- Schedule your PRIVATE showing today!!' ,`Acres` = '0.1365' ,`Area` = '52' ,`BuilderName` = 'First America Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND OAKS RESERVE, SEC 4, BLOCK 2, LOT 9, ACRES .1707' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5946' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Oaks Reserve' ,`TaxAmount` = '456' ,`TaxRate` = '2.5563' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705605' WHERE `Matrix_Unique_ID` = '207789184' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:22:13.000' ,`MLSNumber` = '30816119' ,`ListAgentFullName` = 'Barbie Tucker' ,`ListOfficeName` = 'Etheredge Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.417669' ,`Longitude` = '-95.142977' ,`PhotoCount` = '42' ,`PostalCode` = '77517' ,`RoomCount` = '6' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Three Oaks' ,`StreetNumber` = '2318' ,`StreetSuffix` = 'Drive' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1996' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exclusive Three Oaks home on just over an acre of land. Start your day watching the birds play while having a cup of coffee on your 12x30 back patio. All pasture on the back. Stroll around the pond with your glass of wine in the evenings to relax from a hard day. One story all brick with stone accent home has propane for the chef in the family, gorgeous manufactured wood floors, high ceilings, large kitchen with formal dining, gas fireplace, deep well, 22x22 detached garage. The pictures say it all!' ,`Acres` = '1.0273' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'THREE OAKS SUB (2006) ABST 15, LOT 17, ACRES 1.027' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '44748' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'ROY J. WOLLAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Three Oaks Sub 2006' ,`TaxAmount` = '6772' ,`TaxRate` = '2.0881' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705605' WHERE `Matrix_Unique_ID` = '207823844' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:38:09.400' ,`MLSNumber` = '67548585' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.842644' ,`Longitude` = '-95.811419' ,`PhotoCount` = '7' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '341511.00' ,`Status` = 'Active' ,`StreetName` = 'Lally Brook' ,`StreetNumber` = '4519' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1693' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**home is under construction.** Escape the hustle and bustle of the city to this lovely KB Home in Katy Manor, boasting a brick front, vinyl plank flooring, wrought iron spindles, and an open great room. Spend afternoons in the kitchen, equipped with Silestone countertops, tile backsplash, stainless steel Energy Star® appliances, and 42-in. cabinets. Unwind in the tranquil primary suite, featuring extended dual vanities and a shower with a Moen Genta® WaterSense Showerhead. Additional home features include faux wood blinds and a covered patio. Located minutes from I-610, Hwy. 35, and Hwy. 288, residents enjoy an easy commute to the Texas Medical Center, Westchase District, and Downtown Houston. Shopping, dining, and entertainment can be found nearby at The Galleria and Pearland Town Center. The home is close to various parks, outdoor recreation, and the NRG Stadium. Zoned to Houston ISD.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '465' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Manor' ,`TaxAmount` = '' ,`TaxRate` = '3.556' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705605' WHERE `Matrix_Unique_ID` = '207838004' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:53:04.610' ,`MLSNumber` = '19605970' ,`ListAgentFullName` = 'James Davidoff' ,`ListOfficeName` = 'Sundae Funding, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.442000' ,`Longitude` = '-94.957000' ,`PhotoCount` = '21' ,`PostalCode` = '77371' ,`RoomCount` = '4' ,`ListPrice` = '199000.00' ,`Status` = 'Active' ,`StreetName` = 'County Line' ,`StreetNumber` = '1001' ,`StreetSuffix` = 'Road' ,`City` = 'Shepherd' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2077' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property is 10.97 acres with a double wide manufactured home sitting in the middle of the land. Home needs some work but is livable. Well, electricity and septic are available. Property is a long rectangular shape, mostly wooded, with several hundreds of feet of frontage to the road. Property is not in any flood zone.' ,`Acres` = '10.97' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A144 WILLIAM HAYS, TRACT 10.2O, CALLED TRACT 12 OF PINE CREE' ,`LotDesciption` = 'Wooded' ,`LotSize` = '477853' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '130 - Shepherd' ,`SchoolElementary` = 'SHEPHERD PRIMARY SCHOOL' ,`SchoolHigh` = 'SHEPHERD HIGH SCHOOL' ,`SchoolMiddle` = 'SHEPHERD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'PINE CR-PINE CR' ,`TaxAmount` = '3437' ,`TaxRate` = '1.8509' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705605' WHERE `Matrix_Unique_ID` = '207861571' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:13:29.423' ,`MLSNumber` = '28057642' ,`ListAgentFullName` = 'Dayna Simmons' ,`ListOfficeName` = 'Dayna Simmons Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.108393' ,`Longitude` = '-94.181335' ,`PhotoCount` = '6' ,`PostalCode` = '77706' ,`RoomCount` = '9' ,`ListPrice` = '614500.00' ,`Status` = 'Active' ,`StreetName` = 'Brayfield Ln' ,`StreetNumber` = '6565' ,`StreetSuffix` = '' ,`City` = 'Beaumont' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3242' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Another incredible Merrill construction with amazing amenities. This home has an estimated completion date of September 2022. The kitchen features custom cabinetry, a large island, walk-in pantry & gorgeous granite countertops. You will love all the custom details &the storage you will find in this home. The spacious living room is complete with a magnificent fireplace & the huge master bedroom features a luxury bathroom & a dreamy closet. This home is a beauty & you will want to see it in person.' ,`Acres` = '0.2298' ,`Area` = '51' ,`BuilderName` = 'L&L Merrill' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BARRINGTON HEIGHTS PHASE XI LOT 16 BLK 13 .227AC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10008' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'REGINAL-HOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Barrington Heights Ph 11' ,`TaxAmount` = '505' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705605' WHERE `Matrix_Unique_ID` = '208277170' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:55:55.573' ,`MLSNumber` = '91126569' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.470768' ,`Longitude` = '-95.520965' ,`PhotoCount` = '49' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Knollwood' ,`StreetNumber` = '9806' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3054' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Augustine blends vibrant lifestyle spaces with top-quality craftsmanship to present a uniquely welcoming new home plan. Livability enhancements include a 4 bedrooms, 3 bath, Study, TV Room, 4-car garage, a convenient mudroom, and a built-in countertop in the laundry room. Large entertainers delight kitchen island. Color scheme is cool grey and linen cabinets, with kit quartz c-tops and taupe hardwood floors. Tall soaring high ceilings in family and master compliments space. Escape to the luxury of the master bedroom suite, with its deluxe bathroom and remarkable walk in closet. Welcome guests to an extended rear porch. Each spare bedroom provides sizable closets. Invent the perfect specialty rooms for your family in the sunlit study and TV room. Corner lot-facing old native trees' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13 Block 05' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1229' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705606' WHERE `Matrix_Unique_ID` = '208395888' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:10:45.710' ,`MLSNumber` = '8112269' ,`ListAgentFullName` = 'Rachael Reynolds' ,`ListOfficeName` = 'KSP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.857799' ,`Longitude` = '-95.440536' ,`PhotoCount` = '40' ,`PostalCode` = '77091' ,`RoomCount` = '3' ,`ListPrice` = '590000.00' ,`Status` = 'Active' ,`StreetName` = 'Wilburforce' ,`StreetNumber` = '2017' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1734' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GENTRIFICATION GOLD MINE!! 1.25 ACRES! THIS PROPERTY IS IN THE PERFECT AREA, NO HOA OR DEED RESTRICATIONS. INVESTORS- THIS PROPERTY IS YOUR DREAM COME TRUE! THE POSSIBILITES ARE ENDLESS, BUILD AND ENTIRE NEW COMMUNITY OF HOMES OR BUILD YOUR DREAM MANSION WITH POOL, BASKETBALL OR TENNIS COURT, OR WHATEVER YOUR HEART DESIRES!' ,`Acres` = '1.0315' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 45 BLK 11 HIGHLAND HEIGHTS ANNEX SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '44933' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Highland Heights Annex Sec 02' ,`TaxAmount` = '3916' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705606' WHERE `Matrix_Unique_ID` = '208642597' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:22:13.070' ,`MLSNumber` = '46298889' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.537012' ,`Longitude` = '-95.490826' ,`PhotoCount` = '45' ,`PostalCode` = '77545' ,`RoomCount` = '10' ,`ListPrice` = '345990.00' ,`Status` = 'Active' ,`StreetName` = 'Bright Sunrise' ,`StreetNumber` = '2239' ,`StreetSuffix` = 'Trail' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1776' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*This home is under construction.* Seek comfort in this charming Lake Ridge Builders home in Winfield Lakes. Resting on a spacious lot, this 3-sided brick home boasts a stone front, high ceilings, tile flooring, faux wood blinds, cast stone gas fireplace, and a covered patio. Whip up meals for guests in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. Spend evenings relaxing in the primary suite, featuring dual vanities, a 42” tub, and a separate shower. Community amenities include a clubhouse, pool, playground, and lake with trails. Conveniently located near Hwy 6 and the Fort Bend Toll Road, residents enjoy quick access to Downtown Houston and an assortment of nearby restaurants and shopping centers. Students attend schools zoned to Fort Bend ISD. Don’t wait any longer - call now!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 37 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '515' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PARKS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Winfield Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.02' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705606' WHERE `Matrix_Unique_ID` = '208765849' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:44:20.597' ,`MLSNumber` = '80317176' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Jill Almai' ,`SellingOfficeName` = 'RE/MAX Signature' ,`Latitude` = '30.067544' ,`Longitude` = '-95.723478' ,`PhotoCount` = '16' ,`PostalCode` = '77377' ,`RoomCount` = '8' ,`ListPrice` = '359283.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Palfrey Prairie' ,`StreetNumber` = '19406' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*home is under construction.* Find what you’ve been looking for in this incredible Beazer Home in Amira, boasting a brick façade, sloped ceilings, luxury vinyl plank flooring, sprinkler system, extended entry, and a covered patio. Cook up new cuisines in the kitchen, equipped with quartz countertops, mosaic backsplash, large cove molding, stainless steel appliances, 42” upper cabinets, pendant lighting, and under-counter lighting. The spa-like primary suite features a walk-in closet, dual vanities, a tub, and a separate shower. With the community situated so close to the Grand Parkway and Hwy 249, residents are only minutes away from a variety of dining and shopping options. Amira amenities include an infinity-edge pool, dog park, and gym. Nearby schools are zoned to the top-rated Tomball ISD. Call for more information today!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705606' WHERE `Matrix_Unique_ID` = '208832511' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:58:56.000' ,`MLSNumber` = '87632803' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.292049' ,`Longitude` = '-95.561998' ,`PhotoCount` = '17' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '685000.00' ,`Status` = 'Active' ,`StreetName` = 'Everest' ,`StreetNumber` = '127' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2828' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 87632803 - Built by Highland Homes - October completion! ~ Lovely 1 story home with 3 beds & 2.5 bath. 10\' sliders that open to an extended covered patio. Extended Primary suite with 6\' drop-in rectangular tub & enlarged shower. Classic X Kitchen upgrade with 36 inch apron front sink. Extended brick fireplace & 72 inch Noir ceiling fan. Additional features include study, media room, formal dining area, & 2.5 car garage' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '26-1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 55s' ,`TaxAmount` = '' ,`TaxRate` = '2.83' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705606' WHERE `Matrix_Unique_ID` = '209028630' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:18:42.190' ,`MLSNumber` = '21291986' ,`ListAgentFullName` = 'Kimberly Patel' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809545' ,`Longitude` = '-95.408027' ,`PhotoCount` = '8' ,`PostalCode` = '77008' ,`RoomCount` = '6' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Lawrence' ,`StreetNumber` = '2514' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ideal location in The Heights! Perfect lot to build several townhomes or build your dream home! Minutes from 610 & I-10.' ,`Acres` = '0.0781' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 23A & 24A BLK 32 HOUSTON HEIGHTS' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '5150' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '5813' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1931' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705606' WHERE `Matrix_Unique_ID` = '209092260' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:50:18.050' ,`MLSNumber` = '98124474' ,`ListAgentFullName` = 'Alma Flores' ,`ListOfficeName` = 'House Matchmaker Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.453380' ,`Longitude` = '-95.355224' ,`PhotoCount` = '43' ,`PostalCode` = '77578' ,`RoomCount` = '3' ,`ListPrice` = '539999.00' ,`Status` = 'Active' ,`StreetName` = 'Sherri' ,`StreetNumber` = '8515' ,`StreetSuffix` = 'Circle' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COME AND CHECK OUT THIS GORGEOUS 3 BEDROOM 2 FULL BATH HOME! THIS HOME SITS ON JUST UNDER AN ACRE OF LAND. YOU WILL BE WOWED AS SOON AS YOU ENTER AND SEE THE 12FT HIGH CEILINGS, 7-INCH WOOD TILES, OPEN KITCHEN WITH A LARGE BAR AREA, CUSTOM-MADE CABINETS, STAINLESS STEEL APPLIANCES, GRANITE COUNTERTOPS, CABINETS LIGHTS, MULTI-COLOR CHANGE RECESSED LIGHTING THROUGHOUT THE HOME, LED LIGHTS IN THE RECESSES CEILINGS. LARGE MASTER CLOSET WITH BUILT-IN SHELVES, ALL BEDROOMS WITH WALK-IN CLOSETS WITH BUILT-IN SHELVES, LARGE DOUBLE PANE WINDOWS. AND MUCH MORE, YOU HAVE TO COME AND SEE IT!' ,`Acres` = '0.94' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BRANDI ESTATES (A0476 A B & M)(MANVEL) LOT 20 ACRES .94' ,`LotDesciption` = 'Other' ,`LotSize` = '40946' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Brandi Estates' ,`TaxAmount` = '6056' ,`TaxRate` = '2.7874' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705606' WHERE `Matrix_Unique_ID` = '209146590' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:31:46.753' ,`MLSNumber` = '39729661' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.839929' ,`Longitude` = '-95.857932' ,`PhotoCount` = '31' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '538750.00' ,`Status` = 'Active' ,`StreetName` = 'Newport Creek' ,`StreetNumber` = '945' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 39729661 - Built by Highland Homes - November completion! ~ LAKE LOT - Built by Highland Homes - Walking distance to the famous 3.5 acre Crystal Lagoon in a community that\'s just 15 minutes from both I-10 and 99! The Everleigh features a lovely front porch, two-story entry, 8\' solid doors plus two bedrooms downstairs! Downstairs is an open family room with double-stacked windows climbing the tall ceilings, large kitchen island with peninsula, window seat, extra cabinet space, a fourth bedroom and bathroom, and the primary suite. This kitchen is a show stopper featuring a 5 piece GE stainless appliance package, endless cabinets and quartz countertops! Primary suite includes a bay window, large walk in closet and separate tub and shower. Upstairs are two spacious bedrooms, a full bath, walk-in linen closet, and game room open to below. Full sprinkler system, tank less water heater, and SMARTHOME PACKAGE included!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '12/2' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705606' WHERE `Matrix_Unique_ID` = '209215362' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:08:14.640' ,`MLSNumber` = '2688137' ,`ListAgentFullName` = 'Amy Shao' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.893930' ,`Longitude` = '-95.658052' ,`PhotoCount` = '38' ,`PostalCode` = '77095' ,`RoomCount` = '10' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Hidden Oaks' ,`StreetNumber` = '7918' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2150' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2-story home with open floor plan,high ceiling. Breakfast area with bay-window. Brand new roof , 2 years new Granite Counter top and painting. Marble\'s foyer and fireplace. Jacuzzi and separate shower. Well cared, Pool size yard, 4 zones sprinkler,Two mins walk way to a park, tennis court and swimming pool. Great schools and YMCA in community. A huge yard for your future pool . Title & Laminate woodfloor no Carpet! Current occupid a very good tenant! Good for your investment or owner occupid both ! A must see home!' ,`Acres` = '' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 3 COPPERFIELD SOUTHCREEK VILLAGE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6785' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '610' ,`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` = 'LOWERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Copperfield Southcreek Village' ,`TaxAmount` = '4505' ,`TaxRate` = '2.78038' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705607' WHERE `Matrix_Unique_ID` = '209410599' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:26:36.313' ,`MLSNumber` = '80499010' ,`ListAgentFullName` = 'Aaron Jistel' ,`ListOfficeName` = 'Listing Spark' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.833392' ,`Longitude` = '-95.289472' ,`PhotoCount` = '25' ,`PostalCode` = '77028' ,`RoomCount` = '7' ,`ListPrice` = '179900.00' ,`Status` = 'Active' ,`StreetName` = 'Delavan' ,`StreetNumber` = '7637' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1326' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently updated 3 Bedroom, 1 Bathroom home in Weyburn. The property features upgraded cabinetry with granite countertops, new tile shower surrounds, new EE and plumbing fixtures. The house features a contemporary floor plan, new tile, stainless steel appliances, grey scale paint and resurfaced hardwoods. Newer 410AC and the foundation is passing with structural engineer report. Please review agent remarks and we have an appraisal in hand.' ,`Acres` = '0.185' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 184 BLK 6 WEYBURN PLACE SEC 2' ,`LotDesciption` = 'Other' ,`LotSize` = '8060' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MCGOWEN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Weyburn Place Sec 02' ,`TaxAmount` = '2932' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705607' WHERE `Matrix_Unique_ID` = '209634065' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:08:24.820' ,`MLSNumber` = '33478510' ,`ListAgentFullName` = 'Hedley Karpas' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.697923' ,`Longitude` = '-95.468647' ,`PhotoCount` = '32' ,`PostalCode` = '77401' ,`RoomCount` = '13' ,`ListPrice` = '1149000.00' ,`Status` = 'Active' ,`StreetName` = 'Patrick Henry' ,`StreetNumber` = '5106' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4732' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED per seller. Stunning 3 story home in the heart of Bellaire. Open floorplan with oversized rooms & high ceilings. 5 Bedrooms, 4.5 baths & two built-in office spaces. Formals, Wet Bar & Granite Island Kitchen open to Family Room with wall of glass overlooking yard. Luxurious Primary Retreat with room for sitting area. Second floor Game Room & large third floor Flex Room with Full Bath & two Closets. Formal Living Room could be used as a Study/Library. New roof and fence being completed 7/2022 & 2 water heaters replaced in 2020. Tons of storage, neutral colors, filled with light. A walk away from Condit & Bellaire High.' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 8 PEACEFUL VALLEY SEC 1 2ND R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6222' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CONDIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Peaceful Valley' ,`TaxAmount` = '22588' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705607' WHERE `Matrix_Unique_ID` = '209661540' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:20:03.967' ,`MLSNumber` = '15711173' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Pulte Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.623987' ,`Longitude` = '-95.298937' ,`PhotoCount` = '12' ,`PostalCode` = '77075' ,`RoomCount` = '10' ,`ListPrice` = '349210.00' ,`Status` = 'Active' ,`StreetName` = 'Health Knoll' ,`StreetNumber` = '7329' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2312' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Are you looking for a large lot in the cul-de-sac? Look no more! \r\nThis two story, 4 bedroom, 3 bath home features upgraded 42\" white cabinets w/ brushed nickel hardware, granite countertops, granite backsplash, stainless steel Whirlpool kitchen appliances, and vinyl wood flooring throughout the main living area, and 2\" faux wood blinds. Along with gutters, sprinkler system and sod.' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'Centex' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14, Block 1, Section 5' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DEANDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Forbes Crossing' ,`TaxAmount` = '' ,`TaxRate` = '3.07' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705607' WHERE `Matrix_Unique_ID` = '209750631' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:20:43.610' ,`MLSNumber` = '75990046' ,`ListAgentFullName` = 'Nancy Ware' ,`ListOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.179205' ,`Longitude` = '-95.753849' ,`PhotoCount` = '38' ,`PostalCode` = '77355' ,`RoomCount` = '6' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Nichols Sawmill' ,`StreetNumber` = '29715' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1454' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COMMERCIAL OPPORTUNITY in a fast growing retail corridor of Magnolia, Tx. 1.15 acres. 318’ of frontage on newly widened Nichols Sawmill Rd provides great exposure for your business. Lot is level and mostly cleared. Residence is on the North end of the property, leaving plenty of empty lot space to build on. 1454 square foot 3 bedroom, 1.5 bathroom home could be used as a residence or repurposed as an office, retail or showroom. Additional septic, water and electrical connections that formerly served a mobile home are still present. 3 car detached garage. No restrictions. No HOA.' ,`Acres` = '1.14' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'SHADY BROOK ACRES, BLOCK 4, LOT 9' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'NICHOLS SAWMILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shady Brook Acres' ,`TaxAmount` = '1795' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705607' WHERE `Matrix_Unique_ID` = '209882202' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:50:37.913' ,`MLSNumber` = '63987714' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.291151' ,`Longitude` = '-95.562183' ,`PhotoCount` = '45' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '720510.00' ,`Status` = 'Active' ,`StreetName` = 'Everest' ,`StreetNumber` = '109' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2685' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 63987714 - Built by Highland Homes - January completion! ~ Our show stopping open concept 540 floorplan Draws you in with its beautiful double entry doors - This top selling floorplan offers a huge, updated kitchen open to living and dining area with window seat. 10FT. Sliding glass doors open to extended covered patio on this oversized lot! Huge number of upgrades including wood floors, quartz countertops everywhere, three car garage! This one won\'t last long.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965304 - Woodforest 104, BLOCK 1, Lot 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8770' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 55s' ,`TaxAmount` = '' ,`TaxRate` = '2.83' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705607' WHERE `Matrix_Unique_ID` = '209901346' --> 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','210189008','1663705607','210189008','2022-09-01T15:32:31.777','51919831','Bobbie Alexander','Alexander Properties',' Non-MLS Agent','Non-MLS ','29.686113','-95.702796','13','77407','12','721058.00','Pending Continue to Show','Licola Meadow','18343','Lane','Richmond','4','1','5','3950','Single-Family','MLS#51919831 Ready September! The Larimar plan is so impressive! The beautiful staircase greets you in the foyer with a study & formal dining on either side. The formal dining connects to the gourmet kitchen by way of a butler\'s pantry making dinner parties a breeze! Don\'t miss a thing with an island kitchen overlooking the gathering room with a casual dining space. A perfect layout for entertaining! From its wide-open design to the soaring two-story ceiling in the gathering room, the open-concept main living spaces feel bright & airy! Wind down in the luxurious owners suite and lovely en suite bathroom. Three bedrooms with walk-in closets are situated upstairs on the second level along with a game room & media room for fun evenings at home. You\'ll love the covered patio as it\'s perfect for year-round eating in your backyard sanctuary! Structural options added at 18343 Licola Meadow Lane include: 5th Bedroom, Balcony, Sliding glass door, 42\' entry. REPRESENTATIVE PHOTOS ADDED!','','37','Taylor Morrison','','Electric Dryer Connections,Washer Connections','','Mud','1','','0','Mission Bend Area','Central Gas','1','BLOCK 2, OF GRAND VISTA SECTION 23, A SUBDIVISION OF 100.4','Other,Subdivision Lot,Water View','7727','Appraisal District','','850','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','PATTERSON ELEMENTARY SCHOOL (FORT BEND)','BUSH HIGH SCHOOL','CROCKETT MIDDLE SCHOOL (FORT BEND)','Leave Business Card,No Appointment Required,No Supra Keybox,Request Online Appointment','Builder','2','Contemporary/Modern','Grand Vista 60\'s','','2.52','Public Sewer','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:19:55.790' ,`MLSNumber` = '5540805' ,`ListAgentFullName` = 'Aadil Murad' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.068883' ,`Longitude` = '-95.157473' ,`PhotoCount` = '32' ,`PostalCode` = '77345' ,`RoomCount` = '8' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Longflower' ,`StreetNumber` = '6407' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3274' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out this absolutely stunning 5 bedroom home on a quite cul-de-sac street in the heart of the masterplanned community of Kingwood, TX! Enjoy the miles of nature trails that Kingwood has to offer! This home has been beautifully upgraded with all the modern touches. Fresh new paint really gives the home a light and bright feeling. Also the newly installed lighting fixtures add an elegant modern touch. Not to mention the stainless steel appliances with granite countertops and porcelain tile make this kitchen so breathtaking! The open concept floor-plan is also ideal for entertaining with plenty of room for everyone! High ceilings in the living room with tons of natural light gives this home so much charm! Backyard has a huge covered patio and the home is dotted with mature trees providing plenty of shade! Zoned to top rated schools as well! 5 bedrooms with a gameroom and study with beautiful french doors! Whats not to like, come take a look today!!' ,`Acres` = '0.2328' ,`Area` = '32' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 44 BLK 1 RIVERCHASE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '671' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WILLOW CREEK ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverchase Sec 01' ,`TaxAmount` = '9496' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705607' WHERE `Matrix_Unique_ID` = '210260146' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:48:21.493' ,`MLSNumber` = '42802493' ,`ListAgentFullName` = 'Amanda Hill' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.705818' ,`Longitude` = '-95.874442' ,`PhotoCount` = '34' ,`PostalCode` = '77441' ,`RoomCount` = '5' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Zacate Creek' ,`StreetNumber` = '29031' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1721' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautiful property in the eloquent retirement community of Bonterra located in Cross Creek Ranch. This home boasts a spacious open-concept floor plan that is perfect for relaxing or gatherings. The state of the art kitchen is any chef’s dream with ample counter space, stainless steel appliances and natural lighting. The primary suite is the perfect retreat at the end of the day and looks out over the back yard. Primary bathroom features duel vanities and sinks plus a roomy shower complete with a bench. The guest room offers a Murphy bed that can convert into a large working desk making it the perfect flex room. This home also has a large covered patio to let you enjoy the outdoors during any season. Hard water isn’t an issue as this home comes complete with a whole house water softener. This home also has extra storage in the garage with its added 5 foot extension!' ,`Acres` = '0.2341' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BONTERRA AT CROSS CREEK RANCH SEC 2, BLOCK 2, LOT 8' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10197' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonterra At Cross Creek Ranch Sec 2' ,`TaxAmount` = '10009' ,`TaxRate` = '3.3362' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705608' WHERE `Matrix_Unique_ID` = '210333127' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:22:43.880' ,`MLSNumber` = '7242706' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.537012' ,`Longitude` = '-95.490826' ,`PhotoCount` = '13' ,`PostalCode` = '77545' ,`RoomCount` = '9' ,`ListPrice` = '329990.00' ,`Status` = 'Active' ,`StreetName` = 'Bright Sunrise' ,`StreetNumber` = '2218' ,`StreetSuffix` = 'Trail' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*This home is under construction.* Enjoy peace and quiet in this lovely Lake Ridge Builders home in Winfield Lakes. Nestled on a spacious lot, this 3-sided brick home boasts tile flooring, a sprinkler system, and a covered patio. Impress your guests in the island kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. The spa-like primary suite features dual vanities, a 36” tub, and a separate shower. Conveniently located near Hwy 6 and the Fort Bend Toll Road, residents enjoy quick access to Downtown Houston and an assortment of nearby restaurants and shopping centers. Students attend schools zoned to Fort Bend ISD. Don’t wait any longer - call now to learn more!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '515' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PARKS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Winfield Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.02' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705608' WHERE `Matrix_Unique_ID` = '210340722' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:23:47.923' ,`MLSNumber` = '80251664' ,`ListAgentFullName` = 'Aaron Jistel' ,`ListOfficeName` = 'Listing Spark' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.814408' ,`Longitude` = '-95.064312' ,`PhotoCount` = '25' ,`PostalCode` = '77562' ,`RoomCount` = '7' ,`ListPrice` = '174900.00' ,`Status` = 'Active' ,`StreetName` = '6th' ,`StreetNumber` = '207' ,`StreetSuffix` = 'Street' ,`City` = 'Highlands' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1125' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently updated 3 Bedroom, 1 Bathroom home in Highlands Townsite. The property features upgraded cabinetry with granite countertops (pearl white), new tile shower surrounds, new EE and plumbing fixtures. The house features a contemporary floor plan, new tile, stainless steel appliances, grey scale painted and new carpet. Property comes with foundation warranty.Easy to show, cleaned weekly, remove agent remarks, and schedule a showing today!' ,`Acres` = '0.2296' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4D BLK 22 HIGHLANDS TOWNSITE' ,`LotDesciption` = 'Other' ,`LotSize` = '10000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Highlands Townsite' ,`TaxAmount` = '1598' ,`TaxRate` = '2.575' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705608' WHERE `Matrix_Unique_ID` = '210504332' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:49:47.617' ,`MLSNumber` = '9800208' ,`ListAgentFullName` = 'Pam Holmes' ,`ListOfficeName` = 'Eastex Real Estate Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.649864' ,`Longitude` = '-94.942761' ,`PhotoCount` = '37' ,`PostalCode` = '77351' ,`RoomCount` = '17' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Bishop' ,`StreetNumber` = '229' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '3114' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique property with income producing potential. This 3,114SF brick home sits on a large lot (.7208 acre) and offers: 6 bedrooms, 6.5 baths. New addition with oversized kitchen/dining combo. Large walk-in pantry, large utility, 2-A/C\'s, 2 WH\'s. New Plumbing, New electrical, Entire home has foam insulation. Attached apartment has own entrance, carport and access to private porch/storage. Conventiently located to 59 S for an easy commute to Houston. Endless possibility for this massive home. You must visit to appreciate everything offered. Call today for your tour. OPPORTUNITY is WAITING! (new pictures coming soon)' ,`Acres` = '0.7208' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CHESSWOOD SECTION 1 BLK 3 LOT 4' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '31400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Chesswood Sec 1' ,`TaxAmount` = '4333' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705608' WHERE `Matrix_Unique_ID` = '210588454' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:22:13.637' ,`MLSNumber` = '22961585' ,`ListAgentFullName` = 'Patricia Coursey' ,`ListOfficeName` = 'Equicap Brokerage LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.723404' ,`Longitude` = '-95.382408' ,`PhotoCount` = '24' ,`PostalCode` = '77004' ,`RoomCount` = '6' ,`ListPrice` = '710000.00' ,`Status` = 'Active' ,`StreetName` = 'Jackson' ,`StreetNumber` = '5407' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3134' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED! \r\nGorgeous home in a wonderful location near Hermann Park and the Medical Center. This home is one of the few that has the convenience of first floor living with an open floor plan concept and access to a quaint backyard great for entertainment. The kitchen is equipped with Bosh stainless steel appliances and silestone countertops. The mudroom at garage entry is perfect for keeping the home tidy. The spacious third floor bonus room has a full bathroom and closet ready for you to make it what you always wanted. You can enjoy the beautiful wood floors throughout the home with natural stone floors in bathrooms. Contemporary designer finishes throughout the home create the perfect ambiance. \r\nThe location of this wonderful home puts you in walking distance to Hermann park and many museums and restaurants.' ,`Acres` = '0.0574' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 TRICONS CALUMET STREET PLACE PAR R/P' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Tricons Calumet Street Place P' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705608' WHERE `Matrix_Unique_ID` = '210607392' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:58:16.283' ,`MLSNumber` = '23689980' ,`ListAgentFullName` = 'Daniel Herrington' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.796271' ,`Longitude` = '-95.113563' ,`PhotoCount` = '44' ,`PostalCode` = '77530' ,`RoomCount` = '3' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Duncan' ,`StreetNumber` = '1102' ,`StreetSuffix` = 'Street' ,`City` = 'Channelview' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2112' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This three bedroom two and half bath with an oversized 2 car garage and carport home located in Channelview, offers some open concept, built-in\'s, and a bonus room that could be used as an additional living room, formal dinning or office/home schooling area. The home features tile flooring and wood vinyl plank flooring throughout. Looking for a large yard, 1102 Duncan sits on a corner lot and has a very large back yard that backs up to the next street.' ,`Acres` = '0.57' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 2 PATTERSON' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '24829' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'CRENSHAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'AGUIRRE JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Patterson' ,`TaxAmount` = '2967' ,`TaxRate` = '2.423' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705608' WHERE `Matrix_Unique_ID` = '210626263' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:36:56.537' ,`MLSNumber` = '55150280' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.843452' ,`Longitude` = '-95.857476' ,`PhotoCount` = '6' ,`PostalCode` = '77493' ,`RoomCount` = '3' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Newport Creek' ,`StreetNumber` = '1010' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1582' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 55150280 - Built by Highland Homes - March completion! ~ Built by Highland Homes - Walking distance to the famous 3.5 acre Crystal Lagoon in a community that\'s just 15 minutes from both I-10 and 99! The spacious floorplan offers tile floors, soaring 11 ft ceilings and huge family room. The light & bright kitchen is open to the family room and boasts stainless steel appliances, large island, pantry and so much more! The open floorplan is a true entertainer\'s delight. The primary bedroom is a dream retreat while the primary bath offers dual sinks, separate shower & tub along with a large closet. SMART HOME PACKAGE, tankless water heater, full sprinkler system are all included!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '3-1' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705608' WHERE `Matrix_Unique_ID` = '210647267' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:02:40.750' ,`MLSNumber` = '66157210' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.892880' ,`Longitude` = '-95.219945' ,`PhotoCount` = '6' ,`PostalCode` = '77044' ,`RoomCount` = '3' ,`ListPrice` = '157999.00' ,`Status` = 'Active' ,`StreetName` = 'Greenspark' ,`StreetNumber` = '11822' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1326' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedroom, 2 bathroom home located in Northeast Houston (Contains fire damage throughout). Only a short drive away from Lake Houston! As is with new framing and 30 year roof installed, and subflooring replaced in the back of the house.' ,`Acres` = '0.1148' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 20 BLK 1 GREENSBROOK SEC 1 R/P' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'GARRETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greensbrook Sec 1' ,`TaxAmount` = '3491' ,`TaxRate` = '3.1593' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705609' WHERE `Matrix_Unique_ID` = '210736376' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:31:47.957' ,`MLSNumber` = '65760976' ,`ListAgentFullName` = 'Alfredo Gomez' ,`ListOfficeName` = 'Ai Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.776281' ,`Longitude` = '-94.932490' ,`PhotoCount` = '29' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Parkleaf' ,`StreetNumber` = '4519' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3608' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this amazing and spacious house located in Parkwood Place. This two-story home offers 5 bedrooms with a private office and a formal dinning for family and friends to enjoy. Take the entertainment outside with plenty of outdoor space with a covered patio and a huge driveway for guests. There is a huge open den/gameroom located upstairs for additional entertainment and a 5th bedroom made into a media room. Take advantage of this very functional space and book a tour today!' ,`Acres` = '0.198' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 2 PARKWOOD PLACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '235' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Parkwood Place Sec 02' ,`TaxAmount` = '9182' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705609' WHERE `Matrix_Unique_ID` = '210748439' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:32:23.010' ,`MLSNumber` = '68651374' ,`ListAgentFullName` = 'Kevin Torres' ,`ListOfficeName` = 'Realty Executives Torres Team' ,`SellingAgentFullName` = 'Luis Cardenas' ,`SellingOfficeName` = 'Keller Williams RealtyNortheast' ,`Latitude` = '30.401426' ,`Longitude` = '-95.640227' ,`PhotoCount` = '18' ,`PostalCode` = '77356' ,`RoomCount` = '6' ,`ListPrice` = '420000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Presidio' ,`StreetNumber` = '58' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2085' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location Location! Check out this corner lot STUNNER nestled in the highly coveted Del Lago / Magaritaville community with world class Amenities! Open & airy floor plan with 3 bedrooms, 2.5 bathrooms + study, high ceilings, wood beams in the living area, crown molding & abundance of natural light. The Pinterest worthy gourmet kitchen features a gorgeous 8\' quartzite waterfall island, 42\" cabinetry, stainless appliances and a convenient pot filler above the gas cooktop. Flooring includes a combination of luxury vinyl plank in the common areas + study, tile in the bathrooms and plush carpeting in the bedrooms/closets. Curb appeal GALORE with the painted white brick exterior, custom diamond-pattern accents, board & batten gable finished in black, cedar beams and farmhouse light fixtures.. No cookie cutters here! A truly custom luxurious Modern Farmhouse on a green space home site with golf course access nearby and less than 1 mile to Margaritaville Resort. Schedule your showing today!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'SPI' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'DEL LAGO 01, BLOCK 4, LOT 58' ,`LotDesciption` = 'Cleared,Corner,In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '6117' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Craftsman' ,`Subdivision` = 'Del Lago' ,`TaxAmount` = '' ,`TaxRate` = '1.8698' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705609' WHERE `Matrix_Unique_ID` = '211056530' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:20:16.133' ,`MLSNumber` = '26594029' ,`ListAgentFullName` = 'Vicki Barazandeh' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = 'James Tomberlin' ,`SellingOfficeName` = 'RE/MAX Grand' ,`Latitude` = '29.766312' ,`Longitude` = '-95.416189' ,`PhotoCount` = '32' ,`PostalCode` = '77007' ,`RoomCount` = '7' ,`ListPrice` = '539800.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Detering' ,`StreetNumber` = '408' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2521' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare two story with the perfect backyard. Just a brisk walk from Memorial Park sits this gorgeous first floor living with open flow plan. Owned by an engineer, it has been meticulously maintained. Expanded living room open directly to the backyard through wall of French doors and windows. Island kitchen with lots of cabinets and pantry and granite counters. Three bedrooms and a den/gameroom/library comprise the second floor. Serene primary suite has high ceilings, lots of windows for natural light, two vanity bath with jetted tub and two walk-in closets. Beautiful backyard with covered back porch and maintenance free artificial turf. Private driveway and and iron gate for lock and leave capability. One block from the bike/jog trail. Easy to show.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 1 GARDEN HOMES BY THE PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2345' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rice Military' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705609' WHERE `Matrix_Unique_ID` = '211086577' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:41:01.110' ,`MLSNumber` = '3360426' ,`ListAgentFullName` = 'Ryan Jockers' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Brandi Brantner' ,`SellingOfficeName` = 'RE/MAX Integrity' ,`Latitude` = '30.002282' ,`Longitude` = '-95.570687' ,`PhotoCount` = '26' ,`PostalCode` = '77070' ,`RoomCount` = '8' ,`ListPrice` = '300000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cane Creek' ,`StreetNumber` = '9615' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2613' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL describes this lovely 4 bedroom, 2.5 bathroom home nestled in the heart of the Majestic Oaks subdivision, and zoned to the acclaimed Klein Independent School District! The impressive entrance features a lovely front porch, & beautiful wrought iron stairway. You\'ll love the crown molding, open floor plan, brand new LVP flooring, fresh paint, large windows, tons of natural light, recessed lighting, formal dining, formal living, & spacious family room with beautiful stacked stone fireplace. This home boasts gorgeous updated bathrooms, & large bedrooms; each with a walk-in closet! The chef\'s kitchen features large cabinets, island, tons of storage, breakfast room, & stainless steel appliances. Enjoy the large back yard with spacious covered patio! This wonderful neighborhood has a community pool, lovely walking trails, 2 dog parks, playground, & is conveniently nestled near restaurants, shopping, The Vintage, Hwy 249, Beltway 8, IAH, Tomball, & The Woodlands!' ,`Acres` = '0.1527' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 31 MAJESTIC OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KRAHN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Majestic Oaks' ,`TaxAmount` = '5950' ,`TaxRate` = '2.474' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705609' WHERE `Matrix_Unique_ID` = '211103912' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:10:43.323' ,`MLSNumber` = '22415986' ,`ListAgentFullName` = 'Lisa Mose' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.908180' ,`Longitude` = '-95.455278' ,`PhotoCount` = '34' ,`PostalCode` = '77038' ,`RoomCount` = '8' ,`ListPrice` = '344000.00' ,`Status` = 'Active' ,`StreetName` = 'Sabine Woods' ,`StreetNumber` = '12022' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3079' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two-story, 4 bed, 2.5 bath, brick home in Westview Landing neighborhood. Gorgeous natural wood-look vinyl floors, open concept living, 10 ft. doors, kitchen and dining areas perfect for any gathering and plenty of natural light. The kitchen is well- equipped with ample space, modern cabinetry, island, gas range, up to date appliances and quartz countertops. Find an additional living space upstairs! The primary bedroom includes an en-suite bathroom with separate shower, soaking tub and double sinks! Finally, step outside to a covered patio space and fully fenced large backyard, no immediate back neighbors, certain to meet your outdoor needs!' ,`Acres` = '0.1961' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 WESTVIEW LANDING SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8541' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARTER ACADEMY' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'SHOTWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westview Landing' ,`TaxAmount` = '9613' ,`TaxRate` = '3.4553' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705609' WHERE `Matrix_Unique_ID` = '211130472' --> 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','211161492','1663705609','211161492','2022-09-01T15:20:49.720','14095740','Umer Hasan','Pinnacle Realty Advisors','','','29.786500','-95.211917','29','77015','10','335000.00','Active','Saint Michel','12410','Drive','Houston','2','1','4','2508','Single-Family','Amazing two-story 2,508 sq ft home with 4 bedrooms, 2.5 baths, and a beautiful pool on a large corner lot! This great home has only had ONE OWNER, which shows pride in ownership. It features a formal dining room with a stone fireplace, family room, breakfast area, and a completely updated kitchen with granite countertops. Upstairs you will find three additional bedrooms and the primary bedroom along with two bathrooms. Large modern primary bathroom with separate shower, tub, and a walk-in closet. You can enjoy the patio in the backyard for all your barbecues & family gatherings next to the beautiful pool. Plenty of yard space for the kids to run around. Multiple fruit trees throughout the backyard. New HVAC unit to keep your family cool on those hot summer days. House has never been flooded.','0.1543','2','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','Wood Burning Fireplace','1','North Channel','Central Gas','1','LT 18 BLK 3 RIVIERA EAST SEC 4','Corner','6720','Appraisal District','','498','0','','2','Gas Oven','1','In Ground','','Gas Cooktop','','Wood Shingle','21 - Galena Park','NORMANDY CROSSING ELEMENTARY SCHOOL','NORTH SHORE SENIOR HIGH SCHOOL','CUNNINGHAM MIDDLE SCHOOL (GALENA PARK)','Supra Keybox','Seller','2','Contemporary/Modern','Riviera East Sec 04','5678','2.6774','Public Sewer,Public Water','1993','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:20:37.340' ,`MLSNumber` = '51103324' ,`ListAgentFullName` = 'Bobbie Poole' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.410112' ,`Longitude` = '-95.580243' ,`PhotoCount` = '41' ,`PostalCode` = '75835' ,`RoomCount` = '5' ,`ListPrice` = '642000.00' ,`Status` = 'Active' ,`StreetName` = 'Dogwood' ,`StreetNumber` = '206' ,`StreetSuffix` = 'Street' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3322' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WATERFRONT and Beautiful Shade Trees front and back. This one and half story home has 5 bedrooms and 2.5 baths! With 2 bedrooms downstairs and three up. This home offers a formal living room and dining \r\nwith a large kitchen open to a cozy den with fireplace and a wall of windows across the back with wonderful views and huge deck across the back! It has your own private boat house with the lot being completely bulkheaded. The garage and circle driveway has plenty of room for your parking and guest! Come enjoy the Houston County Lake and enjoy the beautiful sunsets and all that the Lake has to offer! Come take a look at this Waterfront home!!!' ,`Acres` = '0.48' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 21 Blk A' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '20909' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '61 - Latexo' ,`SchoolElementary` = 'LATEXO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LATEXO HIGH SCHOOL' ,`SchoolMiddle` = 'LATEXO HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Right Side' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Other Style' ,`Subdivision` = 'Linwood Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705610' WHERE `Matrix_Unique_ID` = '211191399' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:10:24.637' ,`MLSNumber` = '26528956' ,`ListAgentFullName` = 'Gillian McEniry' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.169751' ,`Longitude` = '-95.170595' ,`PhotoCount` = '50' ,`PostalCode` = '77357' ,`RoomCount` = '13' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Athens' ,`StreetNumber` = '2006' ,`StreetSuffix` = 'Drive' ,`City` = 'Roman Forest' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3329' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated home on two lots - total just over an acre ! New roof 22, HVAC replaced 21, Wood look porcelain tile & baseboards downstairs 22. Fresh int/ext paint 22. Primary bedroom downstairs, 4 spacious bedrooms up with great closets plus two full bathrooms (one with jetted tub) Kitchen open to den - great sightlines - solid surface countertops, SS dishwasher (20), gas cooktop, double ovens. Wood floors & new carpet upstairs. Versatile floorplan - Current dining room could be study, current formal living could be dining room, room off utility room could be gameroom, craft room or office. Lots of outdoor living too - Front porch, upstairs front balcony accessible from bedrooms, large covered back patio w/two ceiling fans for those hot days! Garden shed stays. Part of backyard fenced off - great for pets or kiddos. Wonderful pergola for those large outdoor gatherings! Be sure to visit the area pool & splash pad! Easy access to 59 and shopping at Valley Ranch & Porter.' ,`Acres` = '1' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ROMAN FOREST 01, BLOCK 5, LOT 67 & LOT 66' ,`LotDesciption` = 'Wooded' ,`LotSize` = '43740' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Roman Forest' ,`TaxAmount` = '5609' ,`TaxRate` = '2.9064' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705610' WHERE `Matrix_Unique_ID` = '211216355' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:27:19.913' ,`MLSNumber` = '80924885' ,`ListAgentFullName` = 'Kimberly Capps-Rumfield' ,`ListOfficeName` = 'Keller Williams Realty-FM' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.417900' ,`Longitude` = '-96.827082' ,`PhotoCount` = '33' ,`PostalCode` = '75165' ,`RoomCount` = '7' ,`ListPrice` = '348900.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Roan' ,`StreetNumber` = '204' ,`StreetSuffix` = 'Drive' ,`City` = 'Waxahachie' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2297' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '$2000 offered by sellers to help buyers with interest rate buydown, fresh paint or whatever they desire. This great three bedroom two bath is located in a great neighborhood and is close to everything. All bedrooms are upstairs with a large open living area. Downstairs features a space for either formal dining or study with an open floor plan from the living room to the kitchen. Waxahachie is a growing community but still holding on to that small town charm.' ,`Acres` = '0.18' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 2 BLK C MUSTANG CREEK PH I 0.18 AC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7841' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1014 - Waxahachie' ,`SchoolElementary` = 'SHACKELFORD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WAXAHACHIE HIGH SCHOOL' ,`SchoolMiddle` = 'EDDIE FINLEY SR SEVENTH GRADE CENTER' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mustang Creek Ph I' ,`TaxAmount` = '5006' ,`TaxRate` = '2.3435' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705610' WHERE `Matrix_Unique_ID` = '211370805' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:32:48.203' ,`MLSNumber` = '61999641' ,`ListAgentFullName` = 'Donna Wisenbaker-Barret' ,`ListOfficeName` = 'Direct Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.170908' ,`Longitude` = '-96.284365' ,`PhotoCount` = '46' ,`PostalCode` = '77437' ,`RoomCount` = '10' ,`ListPrice` = '214900.00' ,`Status` = 'Active' ,`StreetName` = 'Agnes' ,`StreetNumber` = '581' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2112' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Price improvement! Don\'t miss this beautiful 4 bedroom 2 full bath, large home on nearly 1 acre, built in 2016. This amazing home sits on a corner lot in a very desirable neighborhood. Upon entering this spacious home, the welcoming open floor plan will amaze you. Large gatherings and entertaining are what this home was built for. The huge kitchen & island are a chef\'s dream! There is an abundance of cabinets for storing and counter space for food prepping! The large primary bedroom and en suite bathroom do not disappoint. Soak the day\'s stress away in the large soaking tub and wait until you see the huge oversized shower! Yes, even your fluffy fur babies could shower in this shower! The split plan gives privacy to all who need it. The seller has added a large covered porch on the back, built a workshop/barn, so bring those 4H/FFA projects and a dirt pad has been laid for a large workshop! The hard work has already been and seller says bring your offers!' ,`Acres` = '0.9183' ,`Area` = '55' ,`BuilderName` = 'SE/Clayton Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'DUCKETT SOUTH LOT 65 2016 SOUTHERN ENERGY 45TFC32664AH16 30X' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '40001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Duckett South' ,`TaxAmount` = '2239' ,`TaxRate` = '1.9674' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705610' WHERE `Matrix_Unique_ID` = '211507472' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:57:42.193' ,`MLSNumber` = '58587796' ,`ListAgentFullName` = 'Kristen Coleman' ,`ListOfficeName` = 'Markham Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.941005' ,`Longitude` = '-95.325197' ,`PhotoCount` = '25' ,`PostalCode` = '75862' ,`RoomCount` = '9' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Cottonwood' ,`StreetNumber` = '17' ,`StreetSuffix` = 'Road' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2031' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The perfect combination of peaceful living and a sense of community! Enjoy unlimited access to the private 18-hole golf course and utilize all the amenities that this community has to offer. Tennis courts, the 19th Hole bar & grill, fitness center, swimming pool, and a marina and boat launch. This is the perfect place to settle in! The large corner lot boasts many mature trees. This home has 3 generously sized bedrooms, a primary bedroom with two walk-in closets, en-suite with double sinks and soaking tub, a large living area with vaulted ceilings and gas fireplace, and a breakfast nook that leads into the kitchen with a spacious island. The oversized 2 car garage features enough room for a work area and also has an attached golf cart garage space. Recent roof, newer HVAC, new range in kitchen, new interior paint, and GENERAC home generator. Adjacent lot also available.' ,`Acres` = '0.2965' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18, Block 1, Westwood Shores Section 01' ,`LotDesciption` = 'Corner,Cul-De-Sac,In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '12937' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2244' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Shores Section 01' ,`TaxAmount` = '' ,`TaxRate` = '2.5863' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705610' WHERE `Matrix_Unique_ID` = '211558320' --> 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','211581340','1663705610','211581340','2022-09-01T14:10:10.930','51907997','Jessica Escamilla','Coldwell Banker Realty','','','29.731093','-95.474123','24','77056','2','340000.00','Active','Barrington','3304','Road','Houston','2','2','2','2182','Single-Family','This is a great investment property. Currently there is a duplex on the lot and the lot size square footage includes 5502 Beverly Hill. The owner would prefer to sell together with 5502 Beverly Hill. Come see this lot Centrally located in Larchmont near the Galleria on a corner lot. Two covered patios with side yard and private front entrance. Flex room could be used as an office or third bedroom. Tons of shopping and restaurants close by with easy access to 59 and 610.','0.0816','22','','','Washer Connections','','Sellers Disclosure','1','','','Galleria','Central Gas','0','TR 1 BLK 1 LARCHMONT SEC 1','Corner,Subdivision Lot','3553','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','27 - Houston','SCHOOL AT ST GEORGE PLACE','WISDOM HIGH SCHOOL','TANGLEWOOD MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Ranch','Larchmont Sec 01','5362','2.3307','Public Sewer,Public Water','1960','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:37:05.300' ,`MLSNumber` = '38226526' ,`ListAgentFullName` = 'Elizabeth Tinnell' ,`ListOfficeName` = 'Tower Point Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.379470' ,`Longitude` = '-95.628961' ,`PhotoCount` = '23' ,`PostalCode` = '77356' ,`RoomCount` = '8' ,`ListPrice` = '825000.00' ,`Status` = 'Active' ,`StreetName` = 'Deepwater' ,`StreetNumber` = '9256' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Waterfront Paradise on Lake Conroe with amazing views! This entertainment haven has a spot for everyone and a view from every seat. The outdoor kitchen and eating bar provide plenty of space to sit and enjoy a meal or just relax on the covered patio or sit under the two palapa\'s next to the waterfalls or the natural rock grotto featuring seating beneath it. You have an amazing open water view from the very large sundeck or the boat dock that features a 6000lb boat lift with new cover and twin jet ski lifts. The pool and spa have just been resurfaced with a tranquil blue hue that complements the new blue tiles. It features multiple swim out ledges and a retractable awning that shades much of the afternoon sun. The open concept interior has French doors and large windows to maximize your lake views. Large kitchen with ample counter space and cabinets has a breakfast bar and additional pantry space. Storage space is not lacking here! Freshly painted decks!' ,`Acres` = '0.1526' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HARBOUR POINT REPLAT B, BLOCK 5, LOT 13-B,14' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '6649' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harbour Point Rep B' ,`TaxAmount` = '10735' ,`TaxRate` = '2.3542' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705610' WHERE `Matrix_Unique_ID` = '211705208' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:40:41.050' ,`MLSNumber` = '88970273' ,`ListAgentFullName` = 'Tillyn Lowery' ,`ListOfficeName` = 'Creative TLC Realty' ,`SellingAgentFullName` = 'Edmundo Padilla' ,`SellingOfficeName` = '5th Stream Realty' ,`Latitude` = '29.929699' ,`Longitude` = '-95.239108' ,`PhotoCount` = '17' ,`PostalCode` = '77396' ,`RoomCount` = '11' ,`ListPrice` = '344999.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Aspen Falls' ,`StreetNumber` = '10010' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2692' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 4 bedroom 3 bath home with an elegant entrance. Spacious kitchen with custom cabinets, stainless steel appliances and a magnificent island with granite countertops equipped to entertain! This home won\'t last! Schedule now!' ,`Acres` = '0.1446' ,`Area` = '1' ,`BuilderName` = 'KHovnanian Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fall Creek Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 5 FALL CREEK EAST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6299' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'AUTUMN CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fall Crk East' ,`TaxAmount` = '9898' ,`TaxRate` = '3.0673' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705610' WHERE `Matrix_Unique_ID` = '211744002' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:52:31.460' ,`MLSNumber` = '32583645' ,`ListAgentFullName` = 'Lee Hines' ,`ListOfficeName` = 'Lee R. Hines' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.970850' ,`Longitude` = '-95.461652' ,`PhotoCount` = '13' ,`PostalCode` = '77014' ,`RoomCount` = '8' ,`ListPrice` = '244000.00' ,`Status` = 'Active' ,`StreetName` = 'Glenleigh' ,`StreetNumber` = '12414' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2073' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS SINGLE STORY HOME SITS ON AN OVERSIZED SUBDIVISION LOT. THE FRONT, LEFT AND RIGHT ELEVATIONS ARE BRICK AND THE BACK ELEVATION IS HARDY BOARD. LARGE PRIMARY BEDROOM AND PRIMARY BATHROOM HAS HIS/HER SINKS AND CLOSETS. TEN FOOT CEILINGS, WOOD BURNING FIREPLACE IN THE MAIN LIVING AREA. LAWN SPRINKLER SYSTEM, A/C WAS INSTALLED IN 2018. THE ROOF WAS INSTALLED IN 2012.' ,`Acres` = '0.1735' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 1 SILVERGLEN SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7557' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '396' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'DELORAS E THOMPSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'STELLE CLAUGHTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Silverglen Sec 02' ,`TaxAmount` = '5174' ,`TaxRate` = '2.8867' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705611' WHERE `Matrix_Unique_ID` = '211775347' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:45:10.253' ,`MLSNumber` = '73601769' ,`ListAgentFullName` = 'James Willis, Jr' ,`ListOfficeName` = 'NextHome Realty Center' ,`SellingAgentFullName` = 'Mayada Shahrokhi' ,`SellingOfficeName` = 'CB&A, Realtors' ,`Latitude` = '30.008780' ,`Longitude` = '-95.765823' ,`PhotoCount` = '32' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '335000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Raleighs Meadow' ,`StreetNumber` = '14719' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1857' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic 3/2/2 1 story home with Brick/Stone exterior located in the popular master planned community of Fairfield* Spacious entry opens to home with premium finishes such as crown molding, tile flooring, & recessed lighting* Office/Study with tall ceilings & french doors located off entry* Open floor plan* Kitchen with granite counter tops, under cabinet lighting, stainless appliances & large pantry* Refrigerator included* Primary suite with walk in closet & bath featuring granite double vanity, separate tub & oversized shower with bench* Ceiling fans in all bedrooms, study, and family room* Energy Star construction & 16 seer HVAC* Covered patio & large extended patio with gas stub for grilling* Private back yard* Full sprinkler system* Zoned to highly rated Cy-Fair ISD schools* Family friendly community with walking trails, splash pad, dog park, pools, work out facility & more* Minutes away from schools, churches, restaurants, shopping, Hwy 290 & Grand Pkwy 99* Must see!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 FAIRFIELD VILLAGE SOUTH SEC 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SWENKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairfield' ,`TaxAmount` = '6729' ,`TaxRate` = '2.631' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705611' WHERE `Matrix_Unique_ID` = '211784084' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:59:24.750' ,`MLSNumber` = '16864936' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Pulte Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.132495' ,`Longitude` = '-95.659494' ,`PhotoCount` = '13' ,`PostalCode` = '77355' ,`RoomCount` = '5' ,`ListPrice` = '279930.00' ,`Status` = 'Active' ,`StreetName` = 'Red Clover' ,`StreetNumber` = '26493' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1814' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Springfield new home floor plan at Decker Farms boasts a 2-story entry and is built for entertaining. The kitchen is truly a chefs dream, spacious and beautiful with 42” cabinetry, and stainless-steel appliances. Large family room and 2 story foyer makes the Springfield stand out to the rest!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Centex' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25, Block 3, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Decker Farms' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705611' WHERE `Matrix_Unique_ID` = '211786350' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:13:26.733' ,`MLSNumber` = '83680418' ,`ListAgentFullName` = 'Rachael Reynolds' ,`ListOfficeName` = 'KSP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.810187' ,`Longitude` = '-96.683151' ,`PhotoCount` = '25' ,`PostalCode` = '75228' ,`RoomCount` = '9' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Abshire' ,`StreetNumber` = '1824' ,`StreetSuffix` = 'Lane' ,`City` = 'Dallas' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1716' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3 bedroom, 2 bathroom ranch-style home located near the city, enjoy the best of both worlds. Home has recently updated with a contemporary feel throughout; Luxury vinyl plank and carpet, fresh paint, modern subway tile and fixtures in the kitchen, marble tile in bathrooms and more. Beautifully located just off of N Buckner Blvd, and nestled into the neighborhood for quiet evenings. The area boasts highly rated GISD schools, grocery stores, shopping and entertainment all, conveniently, nearby. This home is a gem, and a must see. Bring your clients looking for a new place to call home.' ,`Acres` = '0.1067' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'APPLE GATE BLK 13/7376 LT 6 ABSHIRE LN' ,`LotDesciption` = 'Other' ,`LotSize` = '4648' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '211 - Dallas' ,`SchoolElementary` = 'GEORGE W TRUETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SKYLINE HIGH SCHOOL' ,`SchoolMiddle` = 'HAROLD WENDELL LANG SR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'APPLE GATE' ,`TaxAmount` = '3698' ,`TaxRate` = '2.638' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705611' WHERE `Matrix_Unique_ID` = '211866683' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:57:52.180' ,`MLSNumber` = '36924990' ,`ListAgentFullName` = 'Valore Lott' ,`ListOfficeName` = 'Valore Lott' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.600519' ,`Longitude` = '-95.524325' ,`PhotoCount` = '35' ,`PostalCode` = '77489' ,`RoomCount` = '10' ,`ListPrice` = '289950.00' ,`Status` = 'Active' ,`StreetName` = 'Cowden' ,`StreetNumber` = '1323' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2386' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready for your Texas-Sized furniture and Texas-Style entertainment. This delightful 4-bedroom offers all the space you\'ll need for your household. Freshly painted in & out, recent roof, sprinkler system, game room, patio and much more. Low-traffic culdesac street! All new kitchen appliances, ie, stainless steel gas range with grill, dishwasher, and microwave. Conveniences near such as grocers, banking, eateries, recreation, HCC campuses, mega merchants, library, & super freeway & beltway 8 access! Move-in ready, relax, & enjoy your guests! Entertain in downstairs family rooms, in upstairs game room, or under spacious covered patio. 2022 Updates? Paint in & out, all new kitchen stainless steel appliances, new granite counters in kitchen and all baths, new lighting throughout, recent roof, new drive-way paving & much more! Primary bath accented with new frameless glass shower & separate tub. Double vanities, double closets! House-ready for upcoming holiday season!' ,`Acres` = '0.1247' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HUNTERS POINT ESTATES, BLOCK 2, LOT 22' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5430' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '285' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HUNTERS GLEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Left Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Hunters Point Estates' ,`TaxAmount` = '5230' ,`TaxRate` = '2.693' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705611' WHERE `Matrix_Unique_ID` = '211874221' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:10:54.470' ,`MLSNumber` = '53540516' ,`ListAgentFullName` = 'Nicole Shields' ,`ListOfficeName` = 'CRI Real Estate Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.425312' ,`Longitude` = '-95.313273' ,`PhotoCount` = '12' ,`PostalCode` = '77378' ,`RoomCount` = '4' ,`ListPrice` = '699900.00' ,`Status` = 'Active' ,`StreetName` = 'Quiet Springs' ,`StreetNumber` = '31' ,`StreetSuffix` = 'Trail' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3307' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come home to your own slice of paradise! Peach Creek Farms is a new custom home development in Willis with 32 beautiful 1-to-6-acre parcels. Modern farmhouse design built by Hycraft Homes and boasts beautiful finishings throughout. Well appointed layout has 4 bedrooms , large family room with fireplace and sliding doors to back patio, spacious kitchen with large island, shaker white kitchen cabinets with matte black hardware, large walk in pantry. Luxurious primary suite showcases a large walk in shower, vessel soaking tub, amble cabinets/vanities, super closet. Upstairs game room with 2 full baths. 3 full car garage.Home is currently being built with expected completion in November 2022.' ,`Acres` = '1' ,`Area` = '64' ,`BuilderName` = 'Hycraft Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PEACH CREEK FARMS, LOT 30, ACRES 1.0' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'EDWARD B. CANNAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Peach Creek Farms' ,`TaxAmount` = '1175' ,`TaxRate` = '1.9577' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705611' WHERE `Matrix_Unique_ID` = '211926122' --> 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','211929406','1663705611','211929406','2022-09-01T15:58:42.740','11271155','Sara Nguyen','BHGRE Gary Greene','','','29.479136','-95.460150','37','77583','8','320000.00','Active','Canoga','7211','Drive','Rosharon','2','0','4','2104','Single-Family','Charming 1-story in Glendale Lakes is filled with fabulous features you\'re going to love. Find a light & bright open floorplan with soaring ceilings, neutral paint, tile floors in the living areas, beautiful lighting & fans & so much more. The spacious family room opens to a spectacular island kitchen & elegant dining room, perfect for gathering with friends & family. This immaculate kitchen will inspire your inner chef with rich wood cabinetry, Quartz countertops, sleek stainless steel appliances, gorgeous tile backsplash, under-cabinet lights & a large walk-in pantry. The primary suite offers 2 huge walk-in closets & a luxurious ensuite bathroom. This bathroom features separate vanities, a relaxing soaking tub, & a walk-in shower with frameless glass & beautiful tile work. Secondary bedrooms are all spacious with large closets & easy access to a full bathroom. A large fenced yard is ready for outdoor fun. Close to schools, shopping, dining & more. Easy commute through Hwy 6 & 288.','0.1267','38','Saratoga Homes of TX','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Sienna Area','Central Gas','1','GLENDALE LAKES SEC 3, BLOCK 3, LOT 11','Subdivision Lot','5520','Appraisal District','','550','0','','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','19 - Fort Bend','HERITAGE ROSE ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','THORNTON MIDDLE SCHOOL (FORT BEND)','Appointment Required,Lockbox Front,Supra Keybox','Appraisal','1','Traditional','Glendale Lakes','7177','3.1129','Public Sewer,Public Water,Water District','2020','Seller'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:46:33.213' ,`MLSNumber` = '52921456' ,`ListAgentFullName` = 'Dominic Vu' ,`ListOfficeName` = 'HomePro Realty, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.810957' ,`Longitude` = '-95.478408' ,`PhotoCount` = '11' ,`PostalCode` = '77055' ,`RoomCount` = '7' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Hammerly' ,`StreetNumber` = '7522' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1312' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is an estate sales property. Good for investor, large lot size, House needs new floors and works. Sell as its present condition. All room measurements are approximately.' ,`Acres` = '0.2107' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 2 LONG POINT OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9177' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TREASURE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Long Point Oaks' ,`TaxAmount` = '5195' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705611' WHERE `Matrix_Unique_ID` = '211931245' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T15:04:06.823' ,`MLSNumber` = '46702272' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.690791' ,`Longitude` = '-95.714065' ,`PhotoCount` = '12' ,`PostalCode` = '77407' ,`RoomCount` = '3' ,`ListPrice` = '354900.00' ,`Status` = 'Active' ,`StreetName` = 'Euphonia Glade' ,`StreetNumber` = '7922' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to the American dream! A brand, (almost new) home for sale, fully loaded with luxury extras! Upgraded kitchen, with tall cabinets, stainless steel range, microwave, dishwasher and granite countertops,! This charming one story, 3 bedrooms, 2 full baths single-family home located in Grand Vista subdivision has great space to entertain and features high ceilings, hardwood floors, and open space concept! Formal dining area with large windows. Spacious primary bedroom filled with natural light. Primary bath features dual vanities, soaker tub and separate shower. Covered patio and fully fenced backyard. Mud room off the garage. Convenient location within walking distance to schools, amenities, as well as close proximity to Westpak Tollway & 99 Grand Parkway. Near Katy Town Center for shopping, dining & entertaining! Don’t miss out on this. Move-in ready!' ,`Acres` = '0.124' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND VISTA SEC 26, BLOCK 2, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Vista' ,`TaxAmount` = '4865' ,`TaxRate` = '2.4297' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705612' WHERE `Matrix_Unique_ID` = '211936873' --> 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','211966336','1663705612','211966336','2022-09-01T14:59:05.590','41338818','Jimmy Franklin','Newmark Homes','','','29.977761','-95.746819','14','77433','8','749282.00','Active','Via Del Corso','20731','Lane','Cypress','4','1','4','3704','Single-Family','NEWMARK HOMES NEW CONSTRUCTION - Welcome home to 20731 Via del Corso Circle located in the master planned community of Dunham Pointe and zoned to Cy-Fair ISD. This stunning home is set to be complete in November 2022. Featuring 4 bedrooms, 4 baths, 1 half bath, 3 car garage, and over 3,800 square feet of living space, the Carmel floorplan has it all. Dunham Pointe is a 1,327-acre master-planned community located on the south side of US Hwy 290 in Cypress, Texas. This will be the last master-planned development zoned to Cy-Fair ISD and will include a new educational village consisting of a Cy-Fair ISD elementary, middle, and high schools.','','25','Newmark Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','Gaslog Fireplace','1','Cypress South','Central Gas','1','Lot 4 Block 4','Subdivision Lot','9768','Survey','','1000','1','To Be Built/Under Construction','','Double Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','AULT ELEMENTARY SCHOOL','BRIDGELAND HIGH SCHOOL','SALYARDS MIDDLE SCHOOL','Appointment Required,Request Online Appointment','Builder','2','Traditional','Dunham Pointe','','3.44','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T14:53:26.170' ,`MLSNumber` = '22864992' ,`ListAgentFullName` = 'Cindy Fitzgerald' ,`ListOfficeName` = 'Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.171585' ,`Longitude` = '-95.424051' ,`PhotoCount` = '14' ,`PostalCode` = '77515' ,`RoomCount` = '3' ,`ListPrice` = '349200.00' ,`Status` = 'Active' ,`StreetName` = 'Lasso' ,`StreetNumber` = '5' ,`StreetSuffix` = 'Court' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic Deal-NEW CONSTRUCTION! Large kitchen with Large Island, Stainless Steel Appliances, Vinyl Plank Floors, Open Floor Plan, Large Primary with Large Walk in Closet, Spacious Bedrooms, Large Covered Patio to Entertaining, Located on a Large Corner Lot , Energy Efficient, 10/2/1 Warranty' ,`Acres` = '0.2312' ,`Area` = '5' ,`BuilderName` = 'Award Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Rancho Isbella Sec 2 Blk 12 Lot 3' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10070' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rancho Original' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705612' WHERE `Matrix_Unique_ID` = '211967862' --> 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','211978750','1663705612','211978750','2022-09-01T14:29:44.330','47781336','Dayna Simmons','Dayna Simmons Real Estate','','','29.884954','-94.243089','24','77705','8','200000.00','Active','Craigen Rd','14143','','Beaumont','2','1','3','1647','Single-Family','The cutest little farmhouse you ever did see! This precious 3 bedroom charmer sits on a .60 acre lot in Fannett. Picture yourself sipping your morning coffee while watching the sun rise on the beautiful wrap around porch picked straight from a Hallmark movie. The inside of the home gives off a farmhouse vibe with an industrial feel with the deep stainless sink in the kitchen and beautiful features such as the mirror and faucets in the bathrooms. Never worry about a lack of natural light with stunning windows placed all throughout the home. The shop is open giving you plenty of room to park your vehicles, tractors, and toys out of the SETX heat! Give us a call to make this gem yours!','0.61','51','','','','','Sellers Disclosure','1','','','','Central Electric','0','TR 388 AB 68 D BURRELL .6088AC','Subdivision Lot','26572','Unknown','','','0','','0','','1','Above Ground','','','','Other','110 - Hamshire-Fannett','HAMSHIRE-FANNETT ELEMENTARY SCHOOL','HAMSHIRE-FANNETT HIGH SCHOOL','HAMSHIRE-FANNETT MIDDLE SCHOOL','Appointment Required','Appraisal','2','Traditional','N/A','3621','2.0652','Aerobic,Public Water','1998','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','211984039','1663705612','211984039','2022-09-01T14:22:08.617','81344523','Aaron Jistel','Listing Spark','','','29.789713','-95.322746','10','77026','6','215000.00','Active','Lucille','4713','Street','Houston','2','0','3','1500','Single-Family','Welcome to this absolutely charming Fixer Upper 3 bedrooms, 2 full bathroom Single family that you can turn into your home. The house features high ceiling, front covered porch, large backyard and front yard, tandem for two cars. Roof is completely new. Prime location- right off of 59 in the Greater 5th Ward. House has tons of potential. Call to schedule your showing!','0.11','2','n/a','','','','No Disclosures','','','0','Northside','Central Electric','0','LTS 6 & 7 BLK 39 AUGUSTA','Corner','10000','Other','','','1','To Be Built/Under Construction','0','','0','','','','','Composition','27 - Houston','ISAACS ELEMENTARY SCHOOL','WHEATLEY HIGH SCHOOL','FLEMING MIDDLE SCHOOL','Vacant/Unoccupied','Seller','1','Traditional','Augusta','4495','2.3307','Public Water','2019','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','211989075','1663705612','211989075','2022-09-01T14:32:24.227','46654601','Robert Moore','Perry Development Management','','','29.720692','-95.874581','19','77441','11','839900.00','Active','Windy Oaks','4330','Drive','Fulshear','4','1','5','3798','Single-Family','PERRY HOMES NEW CONSTRUCTION!!! Home office and formal dining room frame two-story entry with curved staircase. Two-story family room with fireplace and wall of windows opens to kitchen and morning area. Kitchen features corner walk-in pantry, Butler\'s pantry and island with built-in seating space. First-floor primary suite with curved wall of windows. Dual vanities, garden tub, separate glass-enclosed shower and two walk-in closets in primary bath. First-floor guest suite. Upstairs highlights a media room, game room, computer area and Hollywood bath. Mud room off three-car garage.','','30','Perry Homes','','Electric Dryer Connections','','Mud','1','','','Katy - Southwest','Central Gas','1','Creek Trace At Cross Creek Ranch Sec 5, BLOCK 3, Lot 13','Other','9643','Other','','1300','1','To Be Built/Under Construction','3','Electric Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','HUGGINS ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Cross Creek Ranch','','3.36','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','211994155','1663705612','211994155','2022-09-01T14:05:19.760','12750101','Juana Macias','eXp Realty, LLC','','','29.593441','-95.217766','32','77089','9','269000.00','Active','Sageriver','11307','Drive','Houston','2','0','3','2078','Single-Family','To be enamored by such a property is knowing that it was meant to be. This 3 bedroom, 2 full bath, and attached 2-car garage may be yours. This beautiful neighborhood is near beltway 8 and I-45 for easy access. WAIT! DO NOT MISS OUT ON THE EXTRA BEDROOM AND BATHROOM OUT IN THE BACKYARD! WOW! AMAZING! HURRY AND COME SEE!','0.2164','3','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Southbelt/Ellington','Central Gas','1','LT 26 BLK 21 SAGEMONT SEC 5','Subdivision Lot','9425','Appraisal District','','50','0','','2','Electric Oven','0','','','Freestanding Range','','Composition','41 - Pasadena','STUCHBERY ELEMENTARY SCHOOL','DOBIE HIGH SCHOOL','THOMPSON INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Sagemont Sec 05','4136','2.6863','Public Sewer,Public Water','1965','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','212011932','1663705612','212011932','2022-09-01T15:31:12.530','94701305','Bradley Tiffan','Legend Home Corporation','','','29.831077','-95.805148','27','77493','6','289990.00','Active','Landolfi','24922','Drive','Katy','2','1','3','1849','Single-Family','Love where you live in Camillo Lakes in Katy, TX! The Chestnut floor plan is a charming 2-story home with 3 bedrooms, 2.5 bathrooms, and 2-car garage! This home has it all, including blinds, upgraded carpeting in the bedrooms, and NO BACK NEIGHBORS! The first floor offers the perfect entertainment space with vinyl plank flooring and a large kitchen island overlooking the family and dining rooms! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless steel appliances! The second floor offers a private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring double sinks, a sizable shower, and spacious walk-in closet! Secondary bedrooms have walk-in closets, too! Enjoy the great outdoors with full sod, sprinkler system, and a covered patio! Don\'t miss your opportunity to call Camillo Lakes home, schedule a visit today!','','25','Legend Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Katy - Old Towne','Central Gas','1','LT 66 BLK 1','Cul-De-Sac,Subdivision Lot','2645','Appraisal District','','875','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','30 - Katy','LEONARD ELEMENTARY SCHOOL (KATY)','PAETOW HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','2','Traditional','Camillo Lakes','','3.53','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212021831','1663705612','212021831','2022-09-01T14:09:46.953','31299600','Aaron Jistel','Listing Spark','','','30.614368','-95.073706','24','77331','8','224900.00','Active','Southwood Shores','241','Drive','Coldspring','2','1','4','2072','Single-Family','Great investment or lake home opportunity 4 Bedroom, 2.5 Bathroom home in Southwood. The property is being sold \"as is\" and will require some handyman work. A boat is available to this lake side community. Please review agent remarks and MLS documents. Schedule a showing today!!','0.34','64','','','','','Sellers Disclosure','1','','0','Lake Livingston Area','Central Electric','1','SOUTHWOOD SHORES, LOT 25, ACRES .34','Other','14810','Appraisal District','','240','0','','1','Convection Oven','0','','','','','Composition','101 - Coldspring-Oakhurst Consolidated','JAMES STREET ELEMENTARY SCHOOL','COLDSPRING-OAKHURST HIGH SCHOOL','LINCOLN JUNIOR HIGH SCHOOL','Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern,Traditional','Southwood Shores','2755','1.6254','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','212022919','1663705612','212022919','2022-09-01T15:03:47.323','93403883','Emily Wang','Intown Homes','','','29.793500','-95.459000','9','77055','6','650000.00','Active','Nicholas Grove Place','6107','','Houston','3','1','3','2589','Single-Family','Gated Spacious BACKYARD zoned to MEMORIAL HIGH SCHOOL & SPRING BRANCH MIDDLE. Come join the elegant and charming European Style white painted brick gated community of Alexandra Grove! Freestanding home has spacious fenced private backyard. Living area has cozy gaslog fireplace, soaring 12-ft ceilings and luxe base boards with crown moulding. Living room leads into a huge OVERSIZED BALCONY w/ glorious 10-ft glass sliding trifold doors that bring in all the natural light with unobstructed views! Elegant chef\'s kitchen features high quality furniture grade soft close upgraded stacked cabinets that will wow your guests and luxe Fisher Paykel SS appliances. Spa-like primary bath is like a homeowners dream. Enjoy peace of mind in a lock-and-leave community. Incredible location & high quality finishes with tall baseboards throughout the home, crown moulding, and wide plank wood floors. Gorgeous curb appeal - last chance only two homes left in the community!','','24','Ravenna Building','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Spring Branch','Central Gas','1','Lot 15 Block 1','Patio Lot','','','','2395','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Cooktop','','Composition','49 - Spring Branch','HOUSMAN ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (SPRING BRANCH)','SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)','Appointment Required','Builder','3','Colonial,Contemporary/Modern,French,Other Style','Alexandra Grove','','','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','212063046','1663705612','212063046','2022-09-01T15:46:53.697','54461019','Patrick McGrath','Meritage Homes Realty','','','30.195573','-95.440066','13','77385','7','658670.00','Active','Harper\'s','17615','Way','Conroe','3','1','4','3611','Single-Family','Brand NEW energy-efficient home ready February 2023! Modern Glam Package. 8\' Trim Doors, Fireplace, Outdoor covered Patio, Extended Flooring. Towering two-story. Warm & inviting great room hub opens to the kitchen & dining rooms. Great flex space & private wing downstairs. Fun game room and private, split upstairs suite perfect for guests or teens. Located a half hour north of downtown Houston off Hwy 242, Harper’s Preserve is a stunning gated master-planned community that features an on site local elementary school and grocery store, as well as nearby restaurants and shopping. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.','','15','Meritage Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Spring Northeast','Central Electric,Heat Pump','1','SF 0113 Plan 5362B','Subdivision Lot','','','','1127','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','SUCHMA ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Harpers Preserve','','3.09','Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212084882','1663705612','212084882','2022-09-01T14:19:51.560','64334412','Scott Miller','RE/MAX Signature Galleria','','','30.351527','-95.739189','8','77316','4','329900.00','Active','Pine Ridge','5320','','Montgomery','2','1','4','2059','Single-Family','10\' ceilings in kitchen/Living, beautiful open concept. Spacious kitchen with 42\" upper cabinets with large island, granite tops. Bedrooms with huge walk-in closet. Great lighting and all LED! Samsung Stainless Steel appliance package including easy clean top range with electric oven, 3 rack dishwasher, and microwave. 1 year warranty on appliances from Samsung. Ask agent about preferred lender benefits.','0.4683','39','Starter Homes of TX','','Electric Dryer Connections','','No Disclosures','1','','','Montgomery County Northwest','Central Electric','1','TRI LAKE ESTATE 01, LOT 181','Subdivision Lot','20400','Appraisal District','','40','1','To Be Built/Under Construction','2','Electric Oven','0','','','Freestanding Range','','Composition','37 - Montgomery','MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card','Builder','2','Traditional','Tri Lake Estate 01','372','1.8242','Public Water,Septic Tank','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','212086061','1663705612','212086061','2022-09-01T15:03:28.573','93492094','Suzanne Corbin','Berkshire Hathaway HomeServices','','','29.266008','-94.839109','34','77551','10','675000.00','Active','Colony Park','10','Drive','Galveston','3','0','3','3062','Single-Family','Impressive Home w/Porte Cochere, Pool, & Large Covered Patio f/Outdoor Living Area In Colony Park, One of Galveston\'s Best Neighborhoods! This Nicely Renovated 3 Bedroom, 3 Bath, 3 Car Garage Home w/Circular Drive & So Many Extra Features! Double-Sided, Wood-Burning Fireplace Greets You in the Enormous Gallery-Style \r\nEntry. Arched Wrought-Iron Gates Lead to the Massive Den w/Cathedral Ceiling & Tucked Away Wet-Bar Area That Can Be Hidden Behind Closed Doors. Spacious Primary Bedroom Accommodates Large Furnishings-Complete w/En-Suite Bath w/Both Shower & Over-Sized Tub. Additional Guest Bedroom & Bath-Located on 1st Floor. Up the Stairs, a Wrap-Around Balcony Area w/Library Over-Looking the Grand Den. 3rd Bedroom w/Bath is Located on the 2nd Floor. Beautiful Block Wood Paneling Gives an Elegant & Warm Feel to the Over-All Decor. Amazing, Copious Closets & Storage Throughout. Large Lot-Maintained w/Sprinkler System-Stunning Pool & Grassy Areas. Owner Licensed Agent is Not Listing Agent','0.2918','33','','','Electric Dryer Connections','','Corporate Listing','1','Wood Burning Fireplace','1','Near West End','Central Electric','1','ABST 121 HALL & JONES SUR LOT 23 BLK 4 COLONY PARK SEC 2','Cleared,Cul-De-Sac,Subdivision Lot','12711','Appraisal District','','125','0','','3','Electric Oven','1','Gunite,In Ground','','Electric Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Lockbox Front','Builder','1.5','Other Style,Traditional','Colony Park 2','5565','2.0662','Public Sewer,Public Water','1978','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','212087369','1663705612','212087369','2022-09-01T14:33:47.403','6204984','Bobbie Alexander','Alexander Properties','','','30.294744','-95.552549','16','77316','8','424611.00','Active','Stargazer Lily','252','Bend','Montgomery','2','0','2','1552','Single-Family','MLS#6204984 ~ REPRESENTATIVE PHOTOS ADDED! Built by Taylor Morrison, November Completion! The Sandpiper in Bonterra at Woodforest. Built specifically for age restricted 55+ communities. The open concept design of the Sandpiper provides an inviting area for relaxing or entertaining! The kitchen features an island with breakfast bar and pantry and sits adjacent to a large dining area. The spacious gathering room, just across from the kitchen, is open with views of the outdoor covered living. A nearby study is perfect for working from home and a private guest bedroom with bath is just off the foyer. Cozy up with your favorite book in the roomy owner’s suite where you can enjoy the extra space the bay window provides. The primary bath features dual sinks, a large shower, and large walk-in closet. Structural options for 252 West Stargazer Lily Bend include: bay window at primary, extended covered patio, raised ceilings in foyer and living area, and 5’ garage storage.','0.161','39','Taylor Morrison','','Electric Dryer Connections,Washer Connections','','Mud','1','','0','Conroe Southwest','Central Gas','1','LOT 1, BLOCK 2, OF BONTERRA AT WOODFOREST SECTION 10','Subdivision Lot','7054','Appraisal District','','2825','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied','Builder','1','Traditional','Bonterra at Woodforest 45\'s','','2.78','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212089755','1663705612','212089755','2022-09-01T15:24:57.773','80170587','Tung Do','JLA Realty','','','29.941390','-95.775290','47','77433','8','819000.00','Active','Velvet Wing Dr','20927','','Cypress','3','1','4','3395','Single-Family','LAST SECTION FOR EXCELLENT BRIDGELAND SCHOOL!!! Welcome home with stunning 2 stories LAKE VIEW - PERRY HOMES in Master planned community Bridgeland. NEVER LIVED IN. Open concept home features 4 beds 3.5 baths with 3 CAR GARAGE, HIGH CEILING, MEDIA ROOM, Natural gas line for outdoor cooking, mud room, etc. OFFICE with Double French doors set at entry with 20-foot ceiling. FORMAL DINING room opens to Beautiful ROTUNDA WITH CURVED STAIRCASE. Family room features 18-foot ceiling, fireplace, upgraded tile floor and lot of natural lights. Kitchen hosts generous island with built-in seating space, SS appliances, plenty of cabinets and backsplash. Primary suite with curved wall of windows. Wonderful AMENITIES with lot of activities: walking trails, swimming pool, gym, playground, kayak, dog park, events, etc. Easy access to 99, 290, 529. Few minutes away from shopping mall, schools, groceries, restaurant and business area','','25','','','','','Sellers Disclosure','1','Gaslog Fireplace','1','Cypress South','Central Gas','1','LT 13 BLK 1 BRIDGELAND PRAIRIELAND VILLAGE SEC 4','Subdivision Lot','','','','1197','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','BRIDGELAND HIGH SCHOOL','SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Bridgeland','','3.65','Water District','2022','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','212092141','1663705612','212092141','2022-09-01T15:47:34.850','20598507','Matt Chauvin','Keller Williams Metropolitan','','','29.795754','-95.478052','31','77055','9','444900.00','Active','Woodvine','1424','Drive','Houston','2','1','3','2604','Single-Family','Rare Spring Branch traditional home, located in a private gated enclave (only 4 properties). Warm & bright with an abundance of natural light found throughout this elegant home. Gleaming hardwoods on all the main areas. The French Colonial inspired kitchen can be your Dream kitchen that includes: gas cooktop, large island as the center piece, porcelain tile back splash & endless supply of granite counter tops.\r\n Huge primary bedroom suite with tray ceiling & built-ins, walk-in closet with built-in drawers. Ample storage, Utility room with storage plus folding area. Prime location only minutes from downtown, Galleria, Energy Corridor & Memorial Park. Look around the area, it will be nearly impossible to find a better deal. Call for your own private showing today.','0.044','24','','','Gas Dryer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Spring Branch','Central Gas','1','TR 51C BLK 9 WHISPERING PINES ESTATES SEC 2','Subdivision Lot','1916','Appraisal District','','550','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','49 - Spring Branch','HOUSMAN ELEMENTARY SCHOOL','NORTHBROOK HIGH SCHOOL','LANDRUM MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Colonial','Whispering Pines Estate 2','9987','2.6056','Public Sewer,Public Water','1998','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','212092257','1663705612','212092257','2022-09-01T15:46:59.610','91465532','Bryan Bass','Texas Property Traders, INC','','','29.402016','-95.066335','17','77568','7','337019.00','Active','Villa Sola','13214','Drive','Texas City','2','0','4','1604','Single-Family','CastleRock\'s \"Comal\" Cobalt Series floor plan in Un-Gated Section of Lago Mar\'s Master Planned Community. Home of the largest Crystal Lagoon in Texas and Voted BEST Master Planned Community 2 years in a row. Upgrades include a large Covered Back Patio, Tile throughout all main living areas, and White Brick Elevation with the front Patio. The kitchen is every cook\'s dream with plenty of Countertops, Cabinetry, and Pantry Space. This home also highlights a spectacular Oversized Living Room and a 4th bedroom that could be used as a study. Master Bedroom has lots of brightness. Master Bath has a relaxing soaker tub and a separate shower. Large Utility room and 2 Car Garage.','','33','CastleRock','','Electric Dryer Connections,Washer Connections','','Home Protection Plan,Mi/Lenders Approval,Mud,Owner/Agent,Sellers Disclosure','1','','','Texas City','Central Gas','1','Lot 15, Block 1, Section 3-3','Greenbelt,Other,Subdivision Lot','','','','800','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','17 - Dickinson','LOBIT ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Accompany,Appointment Required,Controlled Access','Builder','1','Traditional','Lago Mar','','3.4212','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212092604','1663705612','212092604','2022-09-01T15:53:29.870','34498487','Jimmy Franklin','Pulte Homes','','','29.621879','-95.298240','10','77075','8','375380.00','Active','Heath Knoll','7309','Drive','Houston','3','0','4','2606','Single-Family','The Mesilla checks off all the boxes! A downstairs guest room with full bathroom great for guest or family members who cannot go up and downstairs, and 3 more bedrooms upstairs. With an open concept living space and oversized kitchen built to entertain any family big or small. A formal study downstairs great for working from home while the kids play upstairs in the game room. This home features upgraded 42\" white cabinets w/ brushed nickel hardware, granite countertops, granite backsplash, stainless steel Whirlpool kitchen appliances, and vinyl wood flooring throughout the main living area, and 2\" faux wood blinds.','','3','Centex','','Electric Dryer Connections,Washer Connections','','Other Disclosures','1','','','Hobby Area','Central Gas','1','Lot 4, Block 10, Section 5','Cul-De-Sac,Subdivision Lot','','','','375','1','To Be Built/Under Construction','2','Freestanding Oven','0','','','Freestanding Range,Gas Range','','Composition','27 - Houston','DEANDA ELEMENTARY SCHOOL','STERLING HIGH SCHOOL (HOUSTON)','THOMAS MIDDLE SCHOOL','Appointment Required','Builder','2','Traditional','Forbes Crossing','','3.07','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully