Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T19:28:09.657' ,`MLSNumber` = '42729077' ,`ListAgentFullName` = 'Maria Morua' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.810266' ,`Longitude` = '-95.382547' ,`PhotoCount` = '16' ,`PostalCode` = '77009' ,`RoomCount` = '3' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Aurora' ,`StreetNumber` = '1230' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Cozy home with 3 bedrooms and 1 full bad, front and back porch, and one car garage detached ready to view. House is sold as is. Is located on a very quiet neighborhood, inside the loop and so closed to downtown, just minutes from highway 610 and I-45.' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 SUNSET HEIGHTS EXTN' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Heights Sec 01 Ext' ,`TaxAmount` = '6486' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705667' WHERE `Matrix_Unique_ID` = '202456711' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:02:44.153' ,`MLSNumber` = '72428679' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.478421' ,`Longitude` = '-95.456784' ,`PhotoCount` = '8' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '378845.00' ,`Status` = 'Active' ,`StreetName` = 'Melrose' ,`StreetNumber` = '7234' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2594' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready July 2022! Front Porch with Brick and stone accent, upgraded front door, blinds, and Cool Interior Package with Ceramic Tile in many areas throughout downstairs. Skip your commute and work from home in the quiet main level flex space. The upstairs game room makes a great media or play space. Downstairs, a large walk-in closet and bath complement the private primary suite. Located in the acclaimed Fort Bend ISD, Glendale Lakes is nestled in Rosharon with great access to nearby dining, entertainment and retail with major employment centers such as the Houston Medical Center, Galleria and Hobby Airport all just a short drive away. With an onsite elementary school, you\'ll relax knowing the kids don\'t have to travel far. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0345 Plan 880C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705667' WHERE `Matrix_Unique_ID` = '203521727' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T19:24:36.517' ,`MLSNumber` = '81188810' ,`ListAgentFullName` = 'Sharon Harris' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.790980' ,`Longitude` = '-95.513571' ,`PhotoCount` = '12' ,`PostalCode` = '77055' ,`RoomCount` = '4' ,`ListPrice` = '950000.00' ,`Status` = 'Active' ,`StreetName` = 'Elizabeth' ,`StreetNumber` = '9052' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1750' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This prodigious property is a rare find in Houston: 16,000+ sq ft in coveted and prestigious Spring Valley Village subdivision. Amazing wooded lot that faces south and never flooded. Per owner, lot is on the medical power grid which means power is restored quickly during outages. Build your dream home. Zoned to distinguished Spring Branch schools including Memorial High School, Spring Branch Middle School, and Valley Oaks Elementary School. Walking distance to the beautiful Spring Valley Village city park.' ,`Acres` = '0.3731' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 RUVERN VILLAGE' ,`LotDesciption` = 'Ravine,Wooded' ,`LotSize` = '16254' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'VALLEY OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Spring Valley Village' ,`TaxAmount` = '13471' ,`TaxRate` = '2.3365' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705667' WHERE `Matrix_Unique_ID` = '203691347' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:38:22.250' ,`MLSNumber` = '68375554' ,`ListAgentFullName` = 'Michelle Falgoust' ,`ListOfficeName` = 'The Discovery Group, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.807093' ,`Longitude` = '-95.794345' ,`PhotoCount` = '19' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '329500.00' ,`Status` = 'Active' ,`StreetName` = 'Lakecrest Town' ,`StreetNumber` = '24415' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning home is located in the highly sought after Lakecrest Village community! From the prime location, to upgraded flooring, study complete with French doors and a closet, blinds throughout,open concept, a large gameroom/media upstairs, large backyard with no back neighbors - zoned to Katy ISD. Nearby neighborhood playground with Jogging and Bike Trail with lake at Mason Creek Park. Just minutes from retail. Make your appointment today!' ,`Acres` = '0.1736' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 4 LAKECREST VILLAGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7562' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakecrest Village Sec 01' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705667' WHERE `Matrix_Unique_ID` = '206950727' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:02:12.063' ,`MLSNumber` = '20040390' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.479738' ,`Longitude` = '-95.452573' ,`PhotoCount` = '7' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '360140.00' ,`Status` = 'Active' ,`StreetName` = 'Bryman' ,`StreetNumber` = '1214' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2012' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready November 2022! Porch with Brick and stone accent. Upgraded front door and blinds included. Sleek Interior Package with EVP flooring throughout in many areas. Many included features with each Meritage Home at Glendale Lakes include rear covered patio, brick front accent, M Connected features, Spray Foam insulation, tankless water heater, grand kitchen island, sodded back yard, front gutters and many other included features. Located in the acclaimed Fort Bend ISD, Glendale Lakes is nestled in Rosharon with great access to nearby dining, entertainment and retail with major employment centers such as the Houston Medical Center, Galleria and Hobby Airport all just a short drive away. With an onsite elementary school, you\'ll relax knowing the kids don\'t have to travel far. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0331 Plan 841C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705667' WHERE `Matrix_Unique_ID` = '207046605' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:01:53.733' ,`MLSNumber` = '6703166' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.480486' ,`Longitude` = '-95.455759' ,`PhotoCount` = '8' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '361230.00' ,`Status` = 'Active' ,`StreetName` = 'Rosemead' ,`StreetNumber` = '1211' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2336' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready October 2022! Brick and Stone front accent with accent shutters. Upgraded front door and Blinds included. Cool Interior Package with Ceramic Tile flooring throughout in many areas downstairs. Many included features with each Meritage Home at Glendale Lakes include rear covered patio, brick front accent, M Connected features, Spray Foam insulation, tankless water heater, grand kitchen island, sodded back yard, front gutters and other included features. Located in the acclaimed Fort Bend ISD, Glendale Lakes is nestled in Rosharon with great access to nearby dining, entertainment and retail with major employment centers such as the Houston Medical Center, Galleria and Hobby Airport all just a short drive away. With an onsite elementary school, you\'ll relax knowing the kids don\'t have to travel far. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0372 Plan 870B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705667' WHERE `Matrix_Unique_ID` = '207627621' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:12:57.303' ,`MLSNumber` = '46144715' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405741' ,`Longitude` = '-95.059947' ,`PhotoCount` = '50' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '313025.00' ,`Status` = 'Active' ,`StreetName` = 'Dalvay Beach' ,`StreetNumber` = '13214' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1617' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW COLINA HOME IN LAGO MAR - LAGOON COMMUNITY!\r\n1 STORY WITH 4 BEDROOMS, 2 BATHS , INCLUDES 2\' FAUX WOOD BLINDS, BUILT IN TAEXX PEST CONTROL, RINNAH TANKLESS WATER HEATER, BACK COVERED PATIO, GRANITE ISLAND KITCHEN, 42\" CABINETS WITH CROWN MOLDING,, STAINLESS STEEL 5 BURNER GAS APPLIANCES, TILE FLOORING EVERYWHERE EXCEPT BEDROOMS, BRICK ELEVATION, FRONT GUTTERS, LENNOX 16 SEER A/C, DOUBLE VANITY IN MASTER BATH, OVERSIZED LOT! READY OCT - NOV 2022! \r\nPHOTOS ARE REPRESENTATIVE OF FLOOR PLAN.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 Block 2 Sec Pod 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705668' WHERE `Matrix_Unique_ID` = '208124553' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:17:49.100' ,`MLSNumber` = '90678873' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.360575' ,`Longitude` = '-94.966261' ,`PhotoCount` = '28' ,`PostalCode` = '77568' ,`RoomCount` = '6' ,`ListPrice` = '368275.00' ,`Status` = 'Active' ,`StreetName` = 'Eagle Nook' ,`StreetNumber` = '2308' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1808' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL BRAND NEW COLINA HOME- IN BRAND NEW SECTION. HUGE LAKE LOT, BEAUTIFUL SUNSET VIEWS, 2 STORY HOME WITH 3 BEDROOMS 2 BATHS. INCLUDES 2\' FAUX WOOD BLINDS, BUILT IN TAEXX PEST CONTROL, BACK COVERED PATIO, GRANITE ISLAND KITCHEN, 42\" CABINETS WITH CROWN MOLDING,, STAINLESS STEEL 5 BURNER GAS APPLIANCES, VINYL FLOORING EVERYWHERE EXCEPT BEDROOMS, & STAIRS, BRICK AND STONE ON ALL SIDES, FRONT GUTTERS, LENNOX 16 SEER A/C, DOUBLE VANITY IN MASTER BATH, IRON FENCE; SOD FRONT AND BACK, READY IN OCTOBER! DO NOT WAIT! EST COMPLETION OCTOBER 2022, PHOTOS ARE REPRESENTATIVE' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22 Block 1 Section 3' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '19845' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (LA MARQUE)' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705668' WHERE `Matrix_Unique_ID` = '208371110' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:02:41.160' ,`MLSNumber` = '86633468' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.574970' ,`Longitude` = '-95.250895' ,`PhotoCount` = '10' ,`PostalCode` = '77089' ,`RoomCount` = '6' ,`ListPrice` = '429340.00' ,`Status` = 'Active' ,`StreetName` = 'Hatton Terrace' ,`StreetNumber` = '2606' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2067' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready October 2022! Debate what to wear in the Preston’s impressive primary walk-in closet. A fourth bedroom with private bath makes a perfect spot for guests or grandparents. The expansive laundry room leaves plenty of space for storage. The newest master planned community near the heart of Pearland, TX. You’ll love Riverstone Ranch’s community lakes, pool, recreation center & trails. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0533 Plan C403F' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'SOUTH BELT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverstone Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705668' WHERE `Matrix_Unique_ID` = '208962366' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:05:05.893' ,`MLSNumber` = '24108243' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.193497' ,`Longitude` = '-95.440268' ,`PhotoCount` = '13' ,`PostalCode` = '77385' ,`RoomCount` = '6' ,`ListPrice` = '436070.00' ,`Status` = 'Active' ,`StreetName` = 'Pond Apple' ,`StreetNumber` = '17529' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2267' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready December 2022! Modern Rustic interior package, Extended Flooring, Patio, 8\' Trim & Doors, Front door rain glass. Sip your morning coffee at the Henderson’s convenient kitchen island overlooking the dining and family rooms. In the primary suite, elegant sloped ceilings complement the sizeable space, including ensuite with dual sinks and large walk-in closet. 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.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0129 Plan C404E' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1127' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harpers Preserve' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705668' WHERE `Matrix_Unique_ID` = '209380411' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:04:12.510' ,`MLSNumber` = '23092639' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194483' ,`Longitude` = '-95.442377' ,`PhotoCount` = '13' ,`PostalCode` = '77385' ,`RoomCount` = '6' ,`ListPrice` = '337365.00' ,`Status` = 'Active' ,`StreetName` = 'Buckeye' ,`StreetNumber` = '17458' ,`StreetSuffix` = 'Branch' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1414' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready December 2022! Elemental interior package. Unwind after a long day in the Glacier’s relaxing primary suite, complete with a spa-like primary bathroom. Purpose the flex space located just off the foyer into a useful office or convenient third bedroom. 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.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0186 Plan N304M' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1127' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harpers Preserve' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705668' WHERE `Matrix_Unique_ID` = '209524768' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:50:29.687' ,`MLSNumber` = '66597884' ,`ListAgentFullName` = 'Neil Ally' ,`ListOfficeName` = 'Executive Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.721606' ,`Longitude` = '-95.798280' ,`PhotoCount` = '30' ,`PostalCode` = '77494' ,`RoomCount` = '6' ,`ListPrice` = '439999.00' ,`Status` = 'Active' ,`StreetName` = 'Azalea Meadow' ,`StreetNumber` = '5103' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2438' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful and extremely well maintained home in the coveted Cinco Ranch neighborhood in Katy. Centrally located in the subdivision completely surrounded by each level of school, the parks, tennis courts, and swimming pools that are all amenities to this location, and its is in one of the best school districts in the Houston area. \r\n\r\nThe roof was replaced in 2016 and all carpet was replaced with beautiful real hardwood floors. This was the model home for the neighborhood so it has all of the upgrades and it features a sprinkler system, and widened driveway. Owners never had any pets.' ,`Acres` = '0.1331' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO WEST AT SEVEN MEADOWS SEC 5, BLOCK 3, LOT 8' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5799' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1115' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KILPATRICK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco West At Seven Meadows Sec 5' ,`TaxAmount` = '6392' ,`TaxRate` = '2.3145' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705668' WHERE `Matrix_Unique_ID` = '209653235' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:00:15.753' ,`MLSNumber` = '15634786' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.662640' ,`Longitude` = '-95.755479' ,`PhotoCount` = '4' ,`PostalCode` = '77406' ,`RoomCount` = '6' ,`ListPrice` = '410450.00' ,`Status` = 'Active' ,`StreetName` = 'Iron Oak' ,`StreetNumber` = '21527' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2067' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready December 2022! Debate what to wear in the Preston\'s impressive walk in closet located just off the private primary suite bath. Espresso cabinets with cream black granite countertops Travertine look tile and warm grey carpet in our Crisp package. Access to Grand Parkway and the Westpark Tollway make it easy to get to work or play. A low tax rate and zoning to the prestigious Lamar Consolidated ISD bolster Creekside Farms’ appeal. Known for our energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving you thousands of dollars on your utility bills.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0148 Plan L403B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '725' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ADOLPHUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekside Farms' ,`TaxAmount` = '' ,`TaxRate` = '2.5' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705668' WHERE `Matrix_Unique_ID` = '209715904' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:00:01.870' ,`MLSNumber` = '83343884' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.662963' ,`Longitude` = '-95.755403' ,`PhotoCount` = '3' ,`PostalCode` = '77406' ,`RoomCount` = '4' ,`ListPrice` = '400300.00' ,`Status` = 'Active' ,`StreetName` = 'Iron Oak' ,`StreetNumber` = '21522' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready December 2022! A private flex space in the Oleander makes a perfect home office or play room. Linen cabinets with smoky grey granite countertops grey cool tone flooring and textured carpet in our Cool package. Access to Grand Parkway and the Westpark Tollway make it easy to get to work or play. A low tax rate and zoning to the prestigious Lamar Consolidated ISD bolster Creekside Farms’ appeal. Known for our energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving you thousands of dollars on your utility bills.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0145 Plan L401D' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '725' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ADOLPHUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekside Farms' ,`TaxAmount` = '' ,`TaxRate` = '2.5' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705669' WHERE `Matrix_Unique_ID` = '209717199' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:16:27.717' ,`MLSNumber` = '82597596' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405789' ,`Longitude` = '-95.059789' ,`PhotoCount` = '24' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '328635.00' ,`Status` = 'Active' ,`StreetName` = 'Stonewater Cove' ,`StreetNumber` = '2201' ,`StreetSuffix` = '' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1759' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW COLINA HOME- 1 STORY OFFERS 4 BEDROOMS, 3 FULL BATHS, OPEN CONCEPT INCLUDES UPGRADED 42\" KITCHEN CABINETS WITH CROWN MOLDING; UPGRADED KITCHEN GRANITE COUNTERTOPS; VINYL PLANK FLOORING EVERYWHERE EXCEPT BEDROOMS; SINGLE 9\" KITCHEN SINK; BUILT IN TAEXX PEST CONTROL; FRONT GUTTERS, PEX PLUMBING; 16 SEER LENNOX A/C; BACK COVERED PORCH; RINNAI TANKLESS WATER HEATER; CORDLESS FAUX WOOD BLINDS, DOUBLE SINKS IN MASTER BATH AND MUCH MORE! CORNER HOME SITE WITH NO BACK NEIGHBORS!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 48 Block 1 Section 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705669' WHERE `Matrix_Unique_ID` = '210143653' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:43:33.640' ,`MLSNumber` = '53273075' ,`ListAgentFullName` = 'Morgan Warren' ,`ListOfficeName` = 'Triple T Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.062804' ,`Longitude` = '-95.698643' ,`PhotoCount` = '20' ,`PostalCode` = '77480' ,`RoomCount` = '4' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 878b' ,`StreetNumber` = '1501' ,`StreetSuffix` = '' ,`City` = 'Sweeny' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1924' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom 1.5 bath home situated on 3.3 acres with 2 covered porches! Extra room and storage that could be used as a man cave, game room or another bedroom! This home features new paint and flooring, granite counter tops in 2021, new roof in 2020, new windows in 2018, and new ac in 2020. This home has solar panels owned out right to help keep your electric costs low. There are 2 storage buildings and a conex storage container to store all of your tools and lawn equipment. Call for a private showing!' ,`Acres` = '3.3' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HOMELAND ACRES (A0085 D MCCORMICK) LOT 37 ACRES 3.3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '143748' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Homeland Acres' ,`TaxAmount` = '3858' ,`TaxRate` = '2.0957' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705669' WHERE `Matrix_Unique_ID` = '210239303' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T19:26:31.940' ,`MLSNumber` = '50211218' ,`ListAgentFullName` = 'Karen DeLeon-Bailes' ,`ListOfficeName` = 'Bailes Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.062537' ,`Longitude` = '-95.444600' ,`PhotoCount` = '32' ,`PostalCode` = '77566' ,`RoomCount` = '7' ,`ListPrice` = '314900.00' ,`Status` = 'Active' ,`StreetName` = 'Petunia' ,`StreetNumber` = '419' ,`StreetSuffix` = 'Street' ,`City` = 'Lake Jackson' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2693' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovley home on spacious corner lot in well established Lake Jackson neighborhood! This 4 bedroom, 3 full bath offers options with 2 Primary suites. Space is not an issue in this home with formal dine, formal living and game room. Close to parks and schools make this a great home!' ,`Acres` = '0.3655' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TANGLEWOOD SEC 1 (LAKE JACKSON), BLOCK 5, LOT 1' ,`LotDesciption` = 'Other' ,`LotSize` = '15921' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BRANNEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tanglewood Lake Jackson' ,`TaxAmount` = '3739' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705669' WHERE `Matrix_Unique_ID` = '210284867' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:17:07.103' ,`MLSNumber` = '18594726' ,`ListAgentFullName` = 'Lynne LaQue' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.400245' ,`Longitude` = '-95.079636' ,`PhotoCount` = '30' ,`PostalCode` = '77510' ,`RoomCount` = '11' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue J' ,`StreetNumber` = '2901' ,`StreetSuffix` = '' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3942' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Investment Home with a detached Mother- In-Law Suite!\r\nThis home does need some updating, but has great potential. If you\'re looking for that hard to find, large home with guest/mother-in-law quarters on 2 acres in Santa Fe, here it is. Stained concrete and wood flooring throughout, no carpet! Light and bright. Large living room with fireplace. Covered patio, outbuildings for your storage needs and small horse stall area. This property provides beautiful trees and tons of privacy.' ,`Acres` = '2.02' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 1 M AUSTIN SU PT OF LOTS 31 & 33 (31-5) MCGREGORS SUB' ,`LotDesciption` = 'Other,Wooded' ,`LotSize` = '87991' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'WILLIAM F BARNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mcgregors Sub' ,`TaxAmount` = '8668' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705669' WHERE `Matrix_Unique_ID` = '210307872' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:05:09.950' ,`MLSNumber` = '53938206' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.424648' ,`Longitude` = '-95.457753' ,`PhotoCount` = '21' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '449215.00' ,`Status` = 'Active' ,`StreetName` = 'Eagle Pass' ,`StreetNumber` = '1334' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2558' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready December 2022! Turn the kids loose in the Royals second-story media and game rooms. Slate cabinets with cotton white quartz countertops, cool grey EVP flooring and multi-tone tweed carpet in our Sleek package. Situated along the Manuel growth corridor, Sierra Vista is 25 miles south of metro Houston in the sought-after Alvin ISD, consistently rated among the best in the region. Nearby, the brand-new rec center offers amenities like fitness classes, youth sports, and a swimming pool. Known for our energy saving features, our homes help you live a healthier and quieter lifestyle, while saving you thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0311 Plan L481D' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.61' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705669' WHERE `Matrix_Unique_ID` = '210352395' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T19:18:38.610' ,`MLSNumber` = '52343912' ,`ListAgentFullName` = 'Darla Ortiz' ,`ListOfficeName` = 'Colesio Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.981087' ,`Longitude` = '-95.955320' ,`PhotoCount` = '8' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '206900.00' ,`Status` = 'Active' ,`StreetName` = '5th St' ,`StreetNumber` = '2912' ,`StreetSuffix` = '' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1282' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful STILL UNDER CONSTRUCTION, Lovely and well built contemporary home. Located 2 blocks from Tennie Holmes Elementary in the heart of Bay City, Texas! This home has 3 bedrooms, 2 bath w/1 car garage, giving you 1282 sq. ft. of spacious wonderful living. You will find designer waterproof vinyl plank flooring throughout and LED lighting brightens all the rooms. Enjoy an open concept for living area, dining & kitchen. Your modern gourmet kitchen includes brand name stainless steel appliances, tiled backsplash, along w/ solid granite countertops & nickel brushed hardware. Relax in your spacious Master Bedroom w/master bath & big closet. This home is all electric, w/low E insulated energy efficient windows, 16-Seer Air Conditioning System, fresh air filtration, Sherwin Williams designer paint on walls & ceilings. ***Warranty: 1 year workmanship, 2-year mechanical, 10-year structural. Est. Completion date 8/19/22. THIS HOME IS WAITING FOR YOU!' ,`Acres` = '0.1722' ,`Area` = '54' ,`BuilderName` = 'AWARD HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MAGILLS S/D LOTS 4 BLK 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Magills Subdivision' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705669' WHERE `Matrix_Unique_ID` = '210568942' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T19:13:24.880' ,`MLSNumber` = '33359762' ,`ListAgentFullName` = 'Charles Canales' ,`ListOfficeName` = 'RUTLEDGE REAL ESTATE LLC' ,`SellingAgentFullName` = 'Christopher Bittinger' ,`SellingOfficeName` = 'RUTLEDGE REAL ESTATE LLC' ,`Latitude` = '29.307641' ,`Longitude` = '-94.781040' ,`PhotoCount` = '44' ,`PostalCode` = '77550' ,`RoomCount` = '3' ,`ListPrice` = '499900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Post Office' ,`StreetNumber` = '1201' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '1' ,`SqFtTotal` = '2161' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful and versatile home on the East End of Galveston, built in 1893 and off the historic street of Postoffice. It is close to the Strand, many local island attractions, great dining, and right down the street from UTMB. Custom shutters and awnings outfit the exterior. Upon entering you will notice the endless conversion opportunities on the first floor, turn the office into a bedroom, or even use it for commercial purposes, previously used as an art gallery. As you move upstairs notice the openness, the natural lighting, and beautiful floors. The kitchen boasts beautiful granite countertops with stainless steel appliances, subway tile adorn as the backsplash. The bedroom is very spacious and connected to the adjoining sitting room that you can also make it your own. Balcony is great for relaxing, the back patio is open and great for entertaining. Refrigerator, washer and dryer included. Schedule your private showing today!' ,`Acres` = '0.059' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR N 60 FT OF LOT 7 (7-1) BLK 432 GALVE' ,`LotDesciption` = 'Corner' ,`LotSize` = '2570' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '7154' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1893' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705669' WHERE `Matrix_Unique_ID` = '210845828' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T19:17:55.380' ,`MLSNumber` = '97692007' ,`ListAgentFullName` = 'Yesenia Rizo' ,`ListOfficeName` = 'Century 21 United D&D LaVernia' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.494598' ,`Longitude` = '-98.239831' ,`PhotoCount` = '40' ,`PostalCode` = '78154' ,`RoomCount` = '10' ,`ListPrice` = '1490000.00' ,`Status` = 'Active' ,`StreetName` = 'Guy Guisborne' ,`StreetNumber` = '12406' ,`StreetSuffix` = '' ,`City` = 'Schertz' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This luxurious home boasts 3,9000 Sq. Ft. of impeccable design and top quality finishes. The home is situated on 4.04 acres surrounded by verdant landscaping and an impressive courtyard. Chef\'s kitchen with stainless steel appliances indoor pizza oven/bbq smoker, and custom cabinets will grant you and your guests the most remarkable experience. The master bathroom offers double vanities, a spacious walk-in shower and jetted tub. This home offers a number of luxurious amenities, an expansive patio with plumbing for outdoor kitchen or gas fireplace, and luxury pool with tranquil waterfalls. The park like setting of this home is something to be desired. Enjoy a sixty-foot sitting wall while fishing in your pond (with 500+ ft retaining wall) for bass, catfish, carp, and trout. Income producing Pecan orchard; 43 trees electronically irrigated, fruit trees and veggie boxes for the gardener of the the house. Pride of ownership is shown throughout this home. No HOA.' ,`Acres` = '4.04' ,`Area` = '83' ,`BuilderName` = 'Greg Setzer' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'CB 519E (SCHERTZ FOREST UT-3 SUBD), BLOCK 3, LOT 40' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '911 - Schertz-Cibolo-Universal City' ,`SchoolElementary` = 'ROSE GARDEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAMUEL CLEMENS HIGH SCHOOL' ,`SchoolMiddle` = 'RAY D. CORBETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Spanish' ,`Subdivision` = 'SCHERTZ FOREST' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705670' WHERE `Matrix_Unique_ID` = '210994166' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:17:11.287' ,`MLSNumber` = '98788649' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405755' ,`Longitude` = '-95.059880' ,`PhotoCount` = '27' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '317565.00' ,`Status` = 'Active' ,`StreetName` = 'Dalvay Beach' ,`StreetNumber` = '13317' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1759' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW COLINA HOME- 1 STORY OFFERS 4 BEDROOMS, 3 FULL BATHS, OPEN CONCEPT INCLUDES UPGRADED 42\" KITCHEN CABINETS WITH CROWN MOLDING; UPGRADED KITCHEN GRANITE COUNTERTOPS; BEAUTIFUL TRAY CEILING IN FOYER;VINYL PLANK FLOORING EVERYWHERE EXCEPT BEDROOMS; SINGLE BOWL 9\" KITCHEN SINK; BUILT IN TAEXX PEST CONTROL; FRONT GUTTERS, PEX PLUMBING; 16 SEER LENNOX A/C; BACK COVERED PORCH; RINNAI TANKLESS WATER HEATER; CORDLESS FAUX WOOD BLINDS, DOUBLE SINKS IN MASTER BATH AND MUCH MORE! NO BACK NEIGHBORS!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 43 Section 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '0' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705670' WHERE `Matrix_Unique_ID` = '211111275' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:15:48.467' ,`MLSNumber` = '10211821' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405789' ,`Longitude` = '-95.059789' ,`PhotoCount` = '22' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '317635.00' ,`Status` = 'Active' ,`StreetName` = 'Dalvay Beach' ,`StreetNumber` = '13205' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1759' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW COLINA HOME- 1 STORY OFFERS 4 BEDROOMS, 3 FULL BATHS, OPEN CONCEPT INCLUDES UPGRADED 42\" KITCHEN CABINETS WITH CROWN MOLDING; UPGRADED KITCHEN GRANITE COUNTERTOPS; BEAUTIFUL TRAY CEILING IN FOYER;VINYL PLANK FLOORING EVERYWHERE EXCEPT BEDROOMS; SINGLE BOWL 9\" KITCHEN SINK; BUILT IN TAEXX PEST CONTROL; FRONT GUTTERS, PEX PLUMBING; 16 SEER LENNOX A/C; BACK COVERED PORCH; RINNAI TANKLESS WATER HEATER; CORDLESS FAUX WOOD BLINDS, DOUBLE SINKS IN MASTER BATH AND MUCH MORE! HOME SITE WITH NO BACK NEIGHBORS!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 35 Section 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5600' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '0' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705670' WHERE `Matrix_Unique_ID` = '211111654' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:02:15.357' ,`MLSNumber` = '14940108' ,`ListAgentFullName` = 'Jeffrey Walters' ,`ListOfficeName` = 'Virginia Malone & Assoc.,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.746551' ,`Longitude` = '-94.965462' ,`PhotoCount` = '13' ,`PostalCode` = '77520' ,`RoomCount` = '6' ,`ListPrice` = '197500.00' ,`Status` = 'Active' ,`StreetName` = 'Park' ,`StreetNumber` = '105' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1294' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom, 1 bath has been redone from top to bottom. Beautiful flooring with spacious open living, dining, and kitchen. All new fixtures, flooring, paint, granite counters in kitchen, and so much more. Updated wiring, plumbing, A/C and much more. Feels like a new home. Large backyard for friends, family and pets.' ,`Acres` = '0.1869' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 20 BLK 3 WILBURN BROTHERS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8142' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'LAMAR ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'HORACE MANN J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wilburn Brothers Sec 01' ,`TaxAmount` = '1818' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705670' WHERE `Matrix_Unique_ID` = '211221594' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:56:34.917' ,`MLSNumber` = '88382488' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.763946' ,`Longitude` = '-95.794332' ,`PhotoCount` = '11' ,`PostalCode` = '77494' ,`RoomCount` = '3' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Caravelle' ,`StreetNumber` = '1334' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2094' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Delightful and dramatic! Striking entry boasts chic art niche along with an office/ bedroom. A marvelous family room is ready for food & drink or just step away to the open kitchen with a sky light & breakfast room. Private master suite is a true retreat. Two generous secondary bedrooms! Large, beautiful paver patio in quaint backyard! Gated community. It’s an absolute jewel! Zoned to highly acclaimed Katy ISD. Easy access to 99 Grand Parkway and I-10. Conveniently located to Katy town Center for shopping, dining, and entertaining. Relax, and enjoy a round of golf on the golf course of Falcon Point.' ,`Acres` = '0.1318' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FALCON POINT SEC 2, BLOCK 1, LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5741' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '980' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RYLANDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Falcon Point' ,`TaxAmount` = '5867' ,`TaxRate` = '2.4445' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705670' WHERE `Matrix_Unique_ID` = '211445592' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:27:12.737' ,`MLSNumber` = '16206426' ,`ListAgentFullName` = 'Nancy Wong' ,`ListOfficeName` = 'ABC Realty Advisor' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.710069' ,`Longitude` = '-95.569443' ,`PhotoCount` = '24' ,`PostalCode` = '77072' ,`RoomCount` = '3' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Briar Terrace' ,`StreetNumber` = '6407' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1756' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful patio home with a split floorplan, ceramic tile, ceiling fans in every bedroom. Large master bedroom with walk-in and double sink. Close to Beltway 8 and shopping/dinning centers.' ,`Acres` = '0.0924' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 9 BRAYS VILLAGE EAST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4023' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '285' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'CHANCELLOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALIEF MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Brays Village East Sec 01' ,`TaxAmount` = '4055' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705670' WHERE `Matrix_Unique_ID` = '211486493' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:50:31.543' ,`MLSNumber` = '98854115' ,`ListAgentFullName` = 'Emanuel Marsis' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = 'Jennifer Erwing' ,`SellingOfficeName` = 'Erwing Realty' ,`Latitude` = '29.747198' ,`Longitude` = '-95.398125' ,`PhotoCount` = '15' ,`PostalCode` = '77006' ,`RoomCount` = '3' ,`ListPrice` = '769900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Yupon' ,`StreetNumber` = '2311' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2489' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completion Sep 2022. Luxurious Urban 3-Story Custom Built with outstanding custom features allover. Located in the heart of Cherryhurst. Unobstructed Park View on the West Side, and Unobstructed Downtown view on the East Side. 3-Story Elevator Shaft. High Ceilings with high-end millwork. Thermador Appliances. Chef’s kitchen comes with custom built cabinets, and a huge island. The spacious rooftop comes with a breathtaking views of downtown, Allen Pkwy, and Med Center. Spacious Master Bedroom with custom built closet. Spacious master bathroom. Features include custom cabinets, hidden appliances, grade 1 white oak solid hardwood floors, 2 high efficiency AC units with multi zone control, solid core doors, in-wall insulation in all interior walls , heated master bath mirrors, in-drawer outlets and much more.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'Amal Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 2 AMAL HOMES ON Maryland' ,`LotDesciption` = 'Corner' ,`LotSize` = '1559' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cherryhurst' ,`TaxAmount` = '' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705671' WHERE `Matrix_Unique_ID` = '211561798' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:18:16.070' ,`MLSNumber` = '81687826' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.087593' ,`Longitude` = '-95.181450' ,`PhotoCount` = '8' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '394240.00' ,`Status` = 'Active' ,`StreetName` = 'Camden Cliff' ,`StreetNumber` = '9418' ,`StreetSuffix` = 'Court' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1990' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand New Lennar Fairway Collection home in Royal Brook at Kingwood! The beautiful 1-story Blackstone D plan by Lennar features an inviting front porch and entry foyer, a dining room, an island kitchen with walk-in pantry and breakfast room that offers access to a relaxing covered rear patio, a generous open family room, and a walk-in utility room. The master bedroom features an en suite master bathroom with dual sinks, stand-up shower, private toilet enclosure, and access to a large master closet.' ,`Acres` = '' ,`Area` = '32' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0020 BLK 001 LOT 009' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SHADOW FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingwood Royal Brook' ,`TaxAmount` = '' ,`TaxRate` = '2.58' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705671' WHERE `Matrix_Unique_ID` = '211577671' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:22:10.973' ,`MLSNumber` = '66356487' ,`ListAgentFullName` = 'Jaclyn Joiner' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.048077' ,`Longitude` = '-94.888982' ,`PhotoCount` = '8' ,`PostalCode` = '77535' ,`RoomCount` = '6' ,`ListPrice` = '205000.00' ,`Status` = 'Active' ,`StreetName` = 'Clayton' ,`StreetNumber` = '106' ,`StreetSuffix` = 'Street' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2020' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, location, location! \r\nThis property sets right in the middle of all of the hustle and bustle of Dayton, Texas. This home is a 3 bedroom/2 bathroom with covered parking for 4+ vehicles. \r\nCome and take a look and imagine all the possibilities of this 2020 ft. home on a very nice, shaded corner lot. \r\nThe access to this home is incredible, it rests off 1960 which turns into E. Clayton St. in the middle of Dayton. This home is situated just a few blocks away from highway 90 you will have easy access to Houston(90W), Beaumont(90E), Humble(1960) and into Baytown(146). \r\nDayton is growing and homes with access like this...is worth a look and maybe a breath of fresh air and a new perspective!\r\n**Agents, please see agent remarks!' ,`Acres` = '0.2525' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'STERLING INVESTMENTS, BLOCK 10, LOT 11 12, ACRES .2525' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '10999' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'RICHTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Sterling Investments' ,`TaxAmount` = '3348' ,`TaxRate` = '2.4832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705671' WHERE `Matrix_Unique_ID` = '211605036' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:15:15.783' ,`MLSNumber` = '4352645' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405789' ,`Longitude` = '-95.059789' ,`PhotoCount` = '22' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '318065.00' ,`Status` = 'Active' ,`StreetName` = 'Dalvay Beach' ,`StreetNumber` = '13301' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1759' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW COLINA HOME- 1 STORY OFFERS 4 BEDROOMS, 3 FULL BATHS, OPEN CONCEPT INCLUDES UPGRADED 42\" KITCHEN CABINETS WITH CROWN MOLDING; UPGRADED KITCHEN GRANITE COUNTERTOPS; BEAUTIFUL TRAY CEILING IN FOYER;VINYL PLANK FLOORING EVERYWHERE EXCEPT BEDROOMS; SINGLE BOWL 9\" KITCHEN SINK; BUILT IN TAEXX PEST CONTROL; FRONT GUTTERS, PEX PLUMBING; 16 SEER LENNOX A/C; BACK COVERED PORCH; RINNAI TANKLESS WATER HEATER; CORDLESS FAUX WOOD BLINDS, DOUBLE SINKS IN MASTER BATH AND MUCH MORE! HOME SITE WITH NO BACK NEIGHBORS!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 1 Section 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5600' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '0' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705671' WHERE `Matrix_Unique_ID` = '211661920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:52:26.507' ,`MLSNumber` = '31479810' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Connie Shugart' ,`SellingOfficeName` = 'Shug Realty Group' ,`Latitude` = '30.232641' ,`Longitude` = '-95.705421' ,`PhotoCount` = '8' ,`PostalCode` = '77354' ,`RoomCount` = '4' ,`ListPrice` = '299490.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'COTTONTOP MOUNTAIN' ,`StreetNumber` = '14528' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exceptional Open Concept 4 bedroom 1 story home! Features Include Open Concept living w/large dining room open to family room & kitchen! Primary bathroom suite offers huge walk in closet! Features include 30\" Flat panel maple cabinets w/crown molding, exotic granite, 4 burner gas cooktop w/SS appliances, tile wall surrounds in bathrooms, smart home system, full sprinklers, front & back sod, fully front landscape, tankless water heater, LED lighting and more! Large covered patio overlooks the PRIVATE backyard with so much room for a pool! Mill Creek Offers 50\' wide lots! Call us today to schedule your showing!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Express Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 26 Block 1 Section 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705671' WHERE `Matrix_Unique_ID` = '211731694' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:17:03.143' ,`MLSNumber` = '16353381' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.135329' ,`Longitude` = '-95.314139' ,`PhotoCount` = '6' ,`PostalCode` = '77365' ,`RoomCount` = '8' ,`ListPrice` = '371549.00' ,`Status` = 'Active' ,`StreetName` = 'Angels Landing' ,`StreetNumber` = '7506' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter Heights' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1857' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! **LENNAR IS NOW IN THE HIGHLANDS! Lennar Brookstone Collection \"Onyx II\" Plan with Elevation \"J!\" in The Highlands! This single-story home features an open design that’s ideal for shared living and a versatile dining room. The kitchen includes a breakfast nook, complete with a window seat, which flows to the family room and covered patio. The owner’s suite boasts a spa-like bathroom and walk-in closet, tucked in the back of the home for added privacy.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0006 BLK 003 LOT 011' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1420' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Highlands' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705671' WHERE `Matrix_Unique_ID` = '211831887' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:00:32.710' ,`MLSNumber` = '83164190' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659346' ,`Longitude` = '-95.754362' ,`PhotoCount` = '10' ,`PostalCode` = '77406' ,`RoomCount` = '4' ,`ListPrice` = '395750.00' ,`Status` = 'Active' ,`StreetName` = 'Virginia' ,`StreetNumber` = '8030' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready December 2022! A private flex space in the Oleander makes a perfect home office or play room. Clear sight lines from the kitchen through the family room bring everyone together, while twin secondary bedrooms are tucked away in their own hall. Access to Grand Parkway and the Westpark Tollway make it easy to get to work or play. A low tax rate and zoning to the prestigious Lamar Consolidated ISD bolster Creekside Farms’ appeal. Known for our energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving you thousands of dollars on your utility bills.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0188 Plan L401D' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '725' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ADOLPHUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekside Farms' ,`TaxAmount` = '' ,`TaxRate` = '2.5' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705671' WHERE `Matrix_Unique_ID` = '211856540' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T18:44:23.073' ,`MLSNumber` = '9664209' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.751643' ,`Longitude` = '-95.878829' ,`PhotoCount` = '7' ,`PostalCode` = '77423' ,`RoomCount` = '8' ,`ListPrice` = '405000.00' ,`Status` = 'Active' ,`StreetName` = 'Lemonwood' ,`StreetNumber` = '2719' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Village Builders Bristol Collection \"Pelham\" Plan with Elevation \"B\" in Jordan Ranch! This two-story home has a versatile layout that is perfect for those who need privacy. Two bedrooms are on the first floor, including the owner’s suite which features a private bathroom and walk-in closet. Also on the first floor is the open concept living area, which offers access to a back patio. Upstairs are two additional bedrooms, which center around a game room loft. **HOME ESTIMATED TO BE COMPLETE, DECEMBER 2022**' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0025 BLK 001 LOT 062' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705672' WHERE `Matrix_Unique_ID` = '211865997' --> 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','211968403','1663705672','211968403','2022-09-01T18:43:31.330','30563290','Jared Turner','LennarVillageBldr-JaredTurner','','','29.567462','-95.730620','10','77469','7','400000.00','Active','Boone Hollow','1631','Lane','Richmond','3','0','4','2097','Single-Family','NEW! Lennar Brookstone Collection \"Agate\" with Elevation \"C\" in Veranda! This single-story home has a smart layout that is just perfect. A bedroom by the front door offers easy access to a bathroom in the hall. Down the hall is the open concept living area, which has a covered patio in the back. Next to the living area are three bedrooms, including the owner’s suite which features a private bathroom and a walk-in closet. *HOME ESTIMATED TO BE COMPLETE, JANUARY, 2023*','','30','Lennar Homes','','','','Mud','1','','','Fort Bend South/Richmond','Central Gas','1','SEC 0041 BLK 001 LOT 011','Subdivision Lot','','','','958','1','To Be Built/Under Construction','2','','0','','','','','Composition','33 - Lamar Consolidated','PHELAN ELEMENTARY SCHOOL','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Veranda','','3.22','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','212019866','1663705672','212019866','2022-09-01T19:37:32.030','62090313','Terry Felton','Fox Properties','','','29.695123','-95.360216','13','77021','8','157000.00','Active','Daphne','3915','Street','Houston','1','1','2','1300','Single-Family','Just minutes to the Medical Center, University of Houston and Downtown. This family ready home offers a cozy den, two bedrooms with 1 and ½ baths, formal living room, full kitchen and dining area, an attractive front yard, covered rear patio and a roomy back yard. There is an attached single car garage with additional off-street parking. Sold as is.','0.1412','4','','','Electric Dryer Connections,Washer Connections','','Estate','0','','0','University Area','Central Gas','0','LT 20 BLK 10 SCOTT TERRACE SEC 3','Subdivision Lot','6150','Appraisal District','','','0','','1','','0','','','Freestanding Range,Gas Range','','Composition','27 - Houston','FOSTER ELEMENTARY SCHOOL (HOUSTON)','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Accompany,Appointment Required,Lockbox Front','Appraisal District','1','Ranch','Scott Terrace','1955','2.3307','Public Sewer,Public Water','1950','Appraisal'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212021938','1663705672','212021938','2022-09-01T18:33:53.467','79777050','Jared Turner','LennarVillageBldr-JaredTurner','','','29.887006','-95.834568','10','77493','8','329990.00','Active','Euphonia Green','27026','Lane','Katy','2','1','4','1851','Single-Family','NEW! Cottage Collection by Lennar, Hawthorn plan elevation A in Winward! This two-story home has a classic layout that is perfect for those who need privacy. The front door leads into the open concept family room which flows seamlessly into the kitchen and dining room at the back of the home. The owner’s suite is adjacent with a private bathroom and walk-in closet. Upstairs, three bedrooms and a laundry room connect to a versatile loft.','','25','Lennar','','','','Mud','','','','Katy - Old Towne','Central Gas','1','SEC 0009 BLK 001 LOT 021','Subdivision Lot','','','','750','1','To Be Built/Under Construction','','','0','','','','','Composition','30 - Katy','MCELWAIN ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Ranch','Winward','','3.48','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','212026901','1663705672','212026901','2022-09-01T18:37:49.240','38859453','Scott Oleksy','Dana Scott Properties','','','29.830251','-95.396283','12','77022','5','158000.00','Active','Whitney','310','Street','Houston','1','1','3','1183','Single-Family','Attention Investors!! 3 Bedroom 1.5 Bath and inside utility room. This home is located just outside the 610 loop with new construction going up all over. This has been a long time lease property and is in need of repairs for you to lease out, flip or build new as you decide.','0.1067','9','','','Gas Dryer Connections,Washer Connections','','Owner/Agent','0','','0','Northwest Houston','Central Electric','0','TR 11I ABST 493 O P KELTON','Subdivision Lot','4650','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','KENNEDY ELEMENTARY SCHOOL (HOUSTON)','WASHINGTON HIGH SCHOOL','WILLIAMS MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','1','Traditional','O P Kelton','671','2.3307','Public Sewer,Public Water','1940','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','212035488','1663705672','212035488','2022-09-01T18:30:46.750','85237124','Diana Nickell','Texas Palladium Properties','','','28.695937','-96.378852','9','77465','1','125000.00','Active','Clam','170','Drive','Palacios','1','0','1','704','Single-Family','Come enjoy this one bedroom / 1 bath cabin on a 1/2 acre in the Boca Chica Subdivision located between Palacios & Port Lavaca! If you are looking for a fisherman\'s getaway camp, this is it! Spacious front porch to sit out and enjoy the coastal breeze. Large storage building for your fishing gear. Bring your boat or RV and create a great family and friends coastal escape. Enjoy the subdivision amenities: Member swimming pool, playground, fishing pier, boat ramp, pavilion and an onsite convenience store/cafe. Water, electric and septic installed.','0.55','67','','','','','Sellers Disclosure','0','','0','','Other Heating','1','BOCA CHICA SEC. III, LOT 13','Cleared','23958','Appraisal District','','250','0','','0','','0','','','','','Composition','156 - Palacios','CENTRAL ELEMENTARY SCHOOL (PALACIOS)','PALACIOS HIGH SCHOOL','PALACIOS JUNIOR HIGH SCHOOL','Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Other Style,Traditional','Boca Chica','1011','1.8978','Septic Tank,Water District','2019','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','212063865','1663705672','212063865','2022-09-01T18:47:52.207','53173998','Jared Turner','LennarVillageBldr-JaredTurner','','','29.567462','-95.730620','9','77469','8','430000.00','Active','Boone Hollow','1638','Lane','Richmond','3','0','4','2393','Single-Family','NEW! Lennar Homes Brookstone Collection, \'\'Russo II\'\' Plan with Brick Elevation \'\'A\" in Veranda! A single-story home with a cohesive design shared among the modern kitchen, dining and family room, with an attached covered patio. Three bedrooms and a study present ample flexibility in the front of the home. The owner’s suite highlights privacy tucked away at the end of the home, complete with a lavish bathroom and walk-in closet. \r\n *HOME ESTIMATED TO BE COMPLETE, JANUARY, 2023*','','30','Lennar Homes','','','','Mud','1','','','Fort Bend South/Richmond','Central Gas','1','SEC 0041 BLK 001 LOT 003','Subdivision Lot','','','','950','1','To Be Built/Under Construction','2','','0','','','','','Composition','33 - Lamar Consolidated','PHELAN ELEMENTARY SCHOOL','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Veranda','','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','212085202','1663705672','212085202','2022-09-01T18:29:13.700','93595309','Georganna Zaba','Keller Williams Realty','','','30.543281','-98.378468','21','78657','3','600000.00','Active','Hi Circle West','716','','Horseshoe Bay','2','1','3','2229','Single-Family','Don’t miss this 3 bedroom, 2.5 bath split bedroom home on a corner lot by Horseshoe Bay Resort’s Slick Rock Golf Course with gorgeous oak trees and a 3-car garage. The home features: 1) LARGE OFFICE/MEDIA ROOM with a big window to view the beautiful trees; 2) OPEN AREA BY FOYER currently used for formal dining; 3) LIVING AREA with wood burning fireplace, built-in cabinetry, floor-to-ceiling glass panels with glass door to backyard covered patio; 4) DRY BAR with granite countertop, upper and lower cabinets; 5) SPACIOUS BREAKFAST ROOM with wall of windows to enjoy backyard views; 6) KITCHEN with granite counters, breakfast bar, built-in desk, lots of cabinets, Whirlpool Stainless Steel refrigerator, double ovens and microwave installed in 2015; 7) LAUNDRY ROOM with sink, storage cabinets, Maytag washer and Samsung dryer included; 8) FENCED BACKYARD with large covered patio and irrigation system for entire yard. 9) Replaced air conditioning system-2016, replaced water heater-2018.','0.3396','83','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','','Central Electric','1','HORSESHOE BAY LT 8008','Corner,In Golf Course Community,Subdivision Lot,Wooded','14792','Other','','305','0','','3','Convection Oven,Double Oven,Electric Oven','0','','','Electric Cooktop','','Tile','183 - Llano','','LLANO HIGH SCHOOL','LLANO JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Appraisal District','1','Traditional','Horseshoe Bay Proper','5063','1.5721','Public Sewer,Public Water','1993','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','212099529','1663705672','212099529','2022-09-01T18:03:04.993','80498794','Ashlee Johnston','Realty ONE Group, Experience','','','30.093311','-95.198752','10','77365','3','359900.00','Active','Bell','24243','Avenue','Porter','2','0','3','1803','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.','','40','Starter Homes of TX','','Electric Dryer Connections','','No Disclosures','1','','','Porter/New Caney East','Central Electric','0','S589001 - Holly Terrace 01, Lot 12','Subdivision Lot','13500','Survey','','','1','To Be Built/Under Construction','2','Electric Oven','0','','','Freestanding Range','','Composition','39 - New Caney','PORTER ELEMENTARY SCHOOL (NEW CANEY)','PORTER HIGH SCHOOL (NEW CANEY)','WOODRIDGE FOREST MIDDLE SCHOOL','Appointment Required,Leave Business Card','Builder','1','Traditional','Holly Terrace 01','7522','2.5431','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','212100400','1663705672','212100400','2022-09-01T18:50:34.960','67205740','Ronnie Matthews','D.R. Horton Homes','','','30.059788','-95.359912','6','77373','3','262990.00','Active','Kentwood Springs','24010','','Spring','2','0','3','1489','Single-Family','Wonderful brand NEW Express Home in Breckenridge Forest! Fantastic location! Charming curb appeal! Perfect floor plan with open living spaces and modern finishes! Lovely island kitchen with espresso cabinetry! Great Primary suite with large closet and oversized shower! Great outdoor space with covered back patio and landscape package! Breckenridge Forest has a nice community recreation center!! Hurry and call today!!','','12','Express Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Spring East','Central Gas','1','Lot 28, Bkl 6, Section 1','Subdivision Lot','6140','Other','','400','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','48 - Spring','CHET BURCHETT ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','DUEITT MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Breckenridge Forest','','','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','212101877','1663705672','212101877','2022-09-01T19:59:13.837','18233198','Rosalinda Frias','Manor, LLC','','','29.642045','-95.664115','35','77498','3','299900.00','Active','Grind Stone','2330','Lane','Sugar Land','2','0','3','1594','Single-Family','Come see this beautifully updated 3 bedroom 2 bath in the highly-desired Pheasant Creek subdivision. This home had a wide range of improvements including new roof, siding, energy efficient windows, water heater, carpet, tiles, HVAC, and stainless steel appliances. There was no detailed spared throughout with the elegant tiles, quartz countertops, and cabinets throughout the home.','0.1743','37','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Sugar Land West','Central Gas','1','PHEASANT CREEK SEC 1, BLOCK 5, LOT 17','Subdivision Lot','7594','Appraisal District','','398','0','','2','Gas Oven','0','','','Gas Range','','Composition','19 - Fort Bend','OYSTER CREEK ELEMENTARY SCHOOL','AUSTIN HIGH SCHOOL (FORT BEND)','GARCIA MIDDLE SCHOOL (FORT BEND)','Appointment Required','Appraisal District','1','Traditional','Pheasant Creek Sec 1','4675','2.6329','Water District','1980','Appraisal District'); --> New record created successfully