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-08-11T10:30:17.040' ,`MLSNumber` = '2707648' ,`ListAgentFullName` = 'Michelle Hatcher' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.786022' ,`Longitude` = '-95.358946' ,`PhotoCount` = '13' ,`PostalCode` = '77009' ,`RoomCount` = '2' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Hammock' ,`StreetNumber` = '1124' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '2' ,`SqFtTotal` = '1092' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property is Centrally located near Downtown Houston. Completely remodeled and move-in ready. Property also includes a garage apartment that has been completely rennovated.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 11 & 12A HAMMOCK' ,`LotDesciption` = 'Other' ,`LotSize` = '5225' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KETELSEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hammock' ,`TaxAmount` = '4333' ,`TaxRate` = '2.4216' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697079' WHERE `Matrix_Unique_ID` = '192995350' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T10:26:22.843' ,`MLSNumber` = '46034850' ,`ListAgentFullName` = 'Carla Abendshein' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750144' ,`Longitude` = '-95.494117' ,`PhotoCount` = '25' ,`PostalCode` = '77057' ,`RoomCount` = '7' ,`ListPrice` = '875000.00' ,`Status` = 'Active' ,`StreetName` = 'San Felipe' ,`StreetNumber` = '6236' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2403' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor opportunity!! Currently being used as an Airbnb this home is perfectly located near downtown Houston. Walking distance from groceries, workouts, shopping and eating. This home has been completely remodeled to feature a more modern open floorplan. The kitchen has been freshly redone with all new cabinetry, quartz countertops, stainless appliances, and an oversized island with built in oven. The oversized living area features a wood burning fireplace and plenty of extra space for a home office. Walk-in his and hers closets in the primary bedroom. Dual sinks in the primary bathroom and a large shower with dual shower heads. The backyard has an enormous 2-teir deck perfect for entertaining. Make an appointment to view this lovely home today!' ,`Acres` = '0.2334' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 371 BLK 18 BRIARGROVE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10165' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Briargrove Sec 03' ,`TaxAmount` = '12819' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697079' WHERE `Matrix_Unique_ID` = '207705440' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T11:19:26.910' ,`MLSNumber` = '67794182' ,`ListAgentFullName` = 'Brittany Rushing' ,`ListOfficeName` = 'StepStone Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.068691' ,`Longitude` = '-95.492874' ,`PhotoCount` = '19' ,`PostalCode` = '77388' ,`RoomCount` = '9' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Temple Bell' ,`StreetNumber` = '4814' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1855' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 4814 Temple Bell, updated and spacious! This home boasts an extra room previously used as a study, perfect for your work-from-home needs. Enjoy an open living room and split floorplan layout. Zoned to the award-winning KISD, this neighborhood is also conveniently located near major shopping and retail.' ,`Acres` = '0.0951' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 6 BRIDGESTONE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4142' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '327' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'ROTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgestone Sec 06' ,`TaxAmount` = '4939' ,`TaxRate` = '2.644' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697079' WHERE `Matrix_Unique_ID` = '207762868' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T11:48:10.050' ,`MLSNumber` = '44263763' ,`ListAgentFullName` = 'Evan Compean' ,`ListOfficeName` = 'Compean Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.466059' ,`Longitude` = '-95.229765' ,`PhotoCount` = '43' ,`PostalCode` = '77546' ,`RoomCount` = '5' ,`ListPrice` = '1395000.00' ,`Status` = 'Active' ,`StreetName` = 'Canal' ,`StreetNumber` = '120' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4847' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Grandeur home zoned to Friendswood ISD! This fully custom home is situated on a lavish landscaped 2.6 acre lot with a detached warehouse/shop with separate entrance. This \"forever\" home was built with high end features & details you typically don\'t find in a home. Open outdoor spaces invite you to relax & enjoy the peaceful surroundings. Home features an open kitchen/dining/living area with a newly updated fireplace. Gourmet kitchen w/high end custom cabinets & trim, gorgeous custom selected granite counter tops, bar seating & S.S. appliances. Primary suite overlooks the outdoor terrain & has an oversized walk-in shower, separate jetted tub & 2 separate vanities with an abundance of cabinet space. First floor also has a separate office, 2nd bedroom w/full bath. Circular staircase leads you to multiple bedrooms, gameroom, entertainment area w/ wine grotto, & access to 2nd floor balcony. Metal warehouse comes with a $30k commercial HVAC system & rolling garage door that can fit an RV!' ,`Acres` = '2.6' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LESLIE\'S LOTS (2001) ABST 616, LOT 3, ACRES 2.600' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '113256' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '6' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'CLINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Leslies Lts 2001' ,`TaxAmount` = '12738' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697079' WHERE `Matrix_Unique_ID` = '207799944' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T10:10:51.130' ,`MLSNumber` = '16800102' ,`ListAgentFullName` = 'Tami Payne' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194916' ,`Longitude` = '-95.080132' ,`PhotoCount` = '33' ,`PostalCode` = '77327' ,`RoomCount` = '5' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 5033' ,`StreetNumber` = '227' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2112' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful unique piece of heaven. The trees and gardens are abundant here. Such a paradise!\r\nThis property is made up of two lots equaling almost 1 acre. There is a 215 foot concrete driveway already poured for your use. This 2018 double wide mobile home is move in ready. There are also 2 decks added on, 8x40 and 12x16. Not to mention the Hot Tub/Spa garden area. Also, there are several raised garden beds with so many fresh herbs and vegetables. Also on the property is an unfinished tiny home. Next to that is a carport area that can be finished into a shop, etc...Endless possibilities! There is also an outdoor covered kitchen area with a BBQ pit. This property is completely enclosed with 7 & 8 foot privacy fences. When touring the property, notice the secluded seating areas tucked away. So peaceful.' ,`Acres` = '0.92' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CAMINO REAL, SEC 2, BLOCK 22, LOT 1308 & 1309, ACRES 0.92' ,`LotDesciption` = 'Cul-De-Sac,Other,Wooded' ,`LotSize` = '40076' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Camino Real, Sec 2' ,`TaxAmount` = '' ,`TaxRate` = '1.8013' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697079' WHERE `Matrix_Unique_ID` = '207940964' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T10:30:14.607' ,`MLSNumber` = '9418835' ,`ListAgentFullName` = 'Beth Naef' ,`ListOfficeName` = 'CI Estates Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.802478' ,`Longitude` = '-95.849652' ,`PhotoCount` = '9' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '2190000.00' ,`Status` = 'Active' ,`StreetName` = 'Palmetto Springs' ,`StreetNumber` = '7347' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6115' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come join me for a personal tour in The Estates at Cane Island. This exquisite 5 bedroom, 5.5 bath, 6115 sq ft home is situated on a 25,240 N/S facing sq ft lot. Cason Graye Homes, an award winning builder, has designed a transitional style home with a 1st floor Master Suite/Bath with a large walk-in closet, a large open great room, as well as a game room & bright airy gourmet kitchen that boasts a Caesarstone island w waterfall sides. In addition to the 4 bedrooms upstairs, find an exercise room w black regrind rubber floors & a bonus room/bar w golf simulator capabilities. Other amenities include a study, Chenin Blanc engineered wood floors thru out, a Butler\'s Pantry w a beverage center, mud room and pool bath w a shower. Relax in the rear yard veranda w a fireplace & summer kitchen. Another amenity unique to The Estates is a secure air conditioned Street Pantry for home deliveries. Buyer to verify all.' ,`Acres` = '0.57' ,`Area` = '25' ,`BuilderName` = 'Cason Graye Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'lot 4, block 1' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '25240' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'The Estates at Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.49' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697079' WHERE `Matrix_Unique_ID` = '208275219' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T10:18:52.750' ,`MLSNumber` = '15932513' ,`ListAgentFullName` = 'Derek Barham' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.103022' ,`Longitude` = '-96.089053' ,`PhotoCount` = '17' ,`PostalCode` = '77445' ,`RoomCount` = '4' ,`ListPrice` = '179999.00' ,`Status` = 'Active' ,`StreetName` = '19th' ,`StreetNumber` = '208' ,`StreetSuffix` = 'Street' ,`City` = 'Hempstead' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction Energy-efficient home with Low Tax rate and Large Homesite! Under construction for estimated August closing. Energy-efficient home with Low Tax rate! large living-dining combo, which makes it perfect for entertaining. Beautiful black appliance package, rounded sheetrock corners, engineered and inspected by third party engineer, High Efficiency HVAC system, double pane insulated Low-E windows. \r\n\r\nWarranty: 1 yr workmanship & materials, 2 yr on all systems- plumbing, electrical, HVAC & other Mechanical Systems, 10 yr Major Structural components' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 1 Block 45' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Town of Hempstead' ,`TaxAmount` = '' ,`TaxRate` = '2.59' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697079' WHERE `Matrix_Unique_ID` = '208756001' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T10:19:15.790' ,`MLSNumber` = '14765855' ,`ListAgentFullName` = 'Derek Barham' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.103022' ,`Longitude` = '-96.089053' ,`PhotoCount` = '19' ,`PostalCode` = '77445' ,`RoomCount` = '4' ,`ListPrice` = '179999.00' ,`Status` = 'Active' ,`StreetName` = '19th' ,`StreetNumber` = '248' ,`StreetSuffix` = 'Street' ,`City` = 'Hempstead' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction Energy-efficient home with Low Tax rate and Large Homesite! Under construction for estimated August closing. Energy-efficient home with Low Tax rate! large living-dining combo, which makes it perfect for entertaining. Beautiful black appliance package, rounded sheetrock corners, engineered and inspected by third party engineer, High Efficiency HVAC system, double pane insulated Low-E windows. \r\n\r\nWarranty: 1 yr workmanship & materials, 2 yr on all systems- plumbing, electrical, HVAC & other Mechanical Systems, 10 yr Major Structural components' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 5 Block 45' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Town of Hempstead' ,`TaxAmount` = '' ,`TaxRate` = '2.59' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697079' WHERE `Matrix_Unique_ID` = '208756458' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T11:15:11.953' ,`MLSNumber` = '78033962' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.802055' ,`Longitude` = '-95.329754' ,`PhotoCount` = '9' ,`PostalCode` = '77026' ,`RoomCount` = '2' ,`ListPrice` = '189999.00' ,`Status` = 'Active' ,`StreetName` = 'Leffingwell' ,`StreetNumber` = '4601' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '648' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a cute 2 bedroom and 1 bathroom home located inside the 610 loop near Lyndon B Johnson Hospital. Newly remodeled home give you modern touches without losing the historic feel. It features fresh interior/exterior paint, vinyl wood flooring in living areas, new carpet in bedrooms, and a nice kitchen area. This is the perfect starter home for those looking to live near central Houston. What are you waiting for? Give us a call today!' ,`Acres` = '0.2686' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 35 CITY GARDENS SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '11700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KASHMERE GARDENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'City Gardens Sec 01' ,`TaxAmount` = '1553' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697080' WHERE `Matrix_Unique_ID` = '210080764' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T10:06:02.243' ,`MLSNumber` = '81675960' ,`ListAgentFullName` = 'Abdul Hannan' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.902161' ,`Longitude` = '-95.691749' ,`PhotoCount` = '26' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '368000.00' ,`Status` = 'Active' ,`StreetName` = 'Weston Park' ,`StreetNumber` = '18306' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2592' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful well maintained two story home sits on huge cul-de-sac lot. The house has an open floor concept for large gathering and entertaining. The kitchen has granite counter tops and open-concept kitchen, large pantry, and is overlooking the living room. The first-floor master suite features a bright, spacious bathroom with double vanities & separate tub and shower. Upstairs, there’s a Game room in addition to Three bedrooms and full bathroom. The backyard has a covered patio. The house is in a cul de sac and is a 2 minutes walk away from the lake. It has easy access to a lot of nearby businesses such as shopping centers, restaurants, entertainments, schools, community center, etc. The community center has private swimming pool, park, picnic area, large lake etc.' ,`Acres` = '0.225' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 69 BLK 3 COLLEGE PARK WEST SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '9800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POSTMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'College Park West' ,`TaxAmount` = '7566' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663697080' WHERE `Matrix_Unique_ID` = '210097996' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T10:57:56.033' ,`MLSNumber` = '54529493' ,`ListAgentFullName` = 'Monica Foster' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.454162' ,`Longitude` = '-95.305737' ,`PhotoCount` = '42' ,`PostalCode` = '77511' ,`RoomCount` = '9' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Burgundy' ,`StreetNumber` = '309' ,`StreetSuffix` = 'Drive' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2143' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous Anglia Home, in Marthas Vineyard, has been gently lived-in! Gorgeous landscaping will greet you each day, as will a leaded glass door, adorned with a Texas star! Once inside, notice the 18\' ceilings in entry & tile flooring. To the left is the Formal Dining Room, with it\'s barn door - it\'s the focal point for many a gathering! The Family Room is spacious, and a great place to chat about the day\'s events. The Kitchen is sure to please, boasting gorgeous granite counters, a gas range, abundant pantry & even the refrigerator. The private Primary Bedroom is a great place to unwind after a long day. It features a terrific ensuite with double sinks, gorgeous counters, a great soaking tub, separate shower & walk-in closet. Upstairs finds a Game Room, 3 generous bedrooms (2 with walk-in closets) and a bathroom. The 3-car garage is perfect for your cars with room to spare! The huge backyard can accommodate a pool, and overlooks the trees and green space! A must see! Never flooded!' ,`Acres` = '0.1842' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MARTHAS VINEYARD SEC 1 (A0230 HT&BRR) BLK 2 LOT 18' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8024' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HOOD-CASE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Marthas Vineyard' ,`TaxAmount` = '9465' ,`TaxRate` = '3.7074' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697080' WHERE `Matrix_Unique_ID` = '210193483' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T10:15:42.933' ,`MLSNumber` = '26704907' ,`ListAgentFullName` = 'Elena Bryant' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768012' ,`Longitude` = '-95.413627' ,`PhotoCount` = '24' ,`PostalCode` = '77007' ,`RoomCount` = '7' ,`ListPrice` = '569900.00' ,`Status` = 'Active' ,`StreetName` = 'Floyd' ,`StreetNumber` = '5204' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2325' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rice Military/Washington Corridor. Stand-alone 3-story single-family home, with a wide private driveway. A spacious living room with high ceilings, a fireplace, a half bath, and a dry bar are located on the first floor. The open-concept kitchen is located on the second floor, it has an island, a gas cooktop, granite countertops, designer backsplash, and stainless steel appliances. Additional space can be used as a breakfast area, and a formal dining room or a study. All bedrooms and the utility room are located on the third floor. A Spacious primary bedroom with and beautiful primary bathroom with a tub, a separate shower, double sinks, and a walk-in closet. No flooding from Harvey or plumbing damage from the freeze 2021. Plenty of windows make this home nice and bright, balconies are located on the first and second floors. Wood floors throughout the main areas, carpet on all bedrooms.' ,`Acres` = '0.0465' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 1 OURSLER W N' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '2025' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Oursler W N' ,`TaxAmount` = '10607' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697080' WHERE `Matrix_Unique_ID` = '210231084' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T10:54:47.747' ,`MLSNumber` = '3866661' ,`ListAgentFullName` = 'Mariana Alvarez' ,`ListOfficeName` = 'Texan Preferred Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.419881' ,`Longitude` = '-95.625775' ,`PhotoCount` = '48' ,`PostalCode` = '77356' ,`RoomCount` = '11' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Naples Ln' ,`StreetNumber` = '49' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4522' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New contruction home on golf course in the heart of Bentwater gated community. The high ceiling foyer leads you to the kitchen that opens to the family room and dinning wich gives you a beautiful view to the golf camp. Very well iluminated primary bedroom. Primary bathroom with 2 separate sink and extra vanity, separate walk in shower and bath tub. in the same floor you will find 2 bedrooms and a guest room and study/office, an extra space as a entertainment space.\r\nSecond floor where you will find spacious gameroom with bar to allow you enjoy the golf course view up stairs too. You can also find a media room, another bedroom and a full bathroom. \r\nThis house has a lot more to offer!' ,`Acres` = '0.2667' ,`Area` = '39' ,`BuilderName` = 'AYR Homes LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 06, BLOCK 2, LOT 17' ,`LotDesciption` = 'On Golf Course,Subdivision Lot' ,`LotSize` = '11619' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1146' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwater 06' ,`TaxAmount` = '614' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697080' WHERE `Matrix_Unique_ID` = '210401525' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T11:58:03.253' ,`MLSNumber` = '41238194' ,`ListAgentFullName` = 'Linda Riddle' ,`ListOfficeName` = 'Team Riddle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.508306' ,`Longitude` = '-95.528502' ,`PhotoCount` = '47' ,`PostalCode` = '77459' ,`RoomCount` = '16' ,`ListPrice` = '1150000.00' ,`Status` = 'Active' ,`StreetName` = 'Hope Farm' ,`StreetNumber` = '31' ,`StreetSuffix` = 'Road' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '4878' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this Amazing Home sitting on a Waterfront, Acreage Lot in The Award Winning Golf Course Community of Sienna! NO MUD TAX! WHOLE HOUSE GENERATOR! Water Filtration System! THREE Bedrooms on the First Floor, THREE on the Second Floor! Welcomed by a Wall of Windows, High Ceilings, Beautiful Fireplace and a Chefs Island Kitchen! TONS of Cabinet and Counter Space, GAS Stovetop, Large Breakfast Room and Breakfast Bar, Private Home Office, Living Room, Large Primary Suite and Spa-Like Bath, Vanity Area & DBL Sinks. Secondary Bedrooms are Large, NO CARPET In Bedrooms, Large Game room with a Balcony Overlooking the Backyard and Lake, MEDIA Room (used as a Gym) Updated Secondary Bathrooms, Large Covered Patio,( Fenced in Dog or Kiddo Area) and a Beautiful Green Canvas to Build the POOL of your Dreams, Sienna Offers 5 Resort Style POOLS, Golf Course, Tennis, Baseball, Softball, Soccer Fields, Horse Stables, etc. Call us today for a private showing!' ,`Acres` = '1.1187' ,`Area` = '38' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA ACREAGE ESTATES PHASE 1, BLOCK 5, LOT 12, ACRES 1.118' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Water View' ,`LotSize` = '48731' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SIENNA CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Acreage Estates Ph 1' ,`TaxAmount` = '12826' ,`TaxRate` = '2.1129' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697080' WHERE `Matrix_Unique_ID` = '210736956' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T11:27:35.677' ,`MLSNumber` = '63789738' ,`ListAgentFullName` = 'Jon Lanclos' ,`ListOfficeName` = 'The Discovery Group, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.145422' ,`Longitude` = '-95.050266' ,`PhotoCount` = '33' ,`PostalCode` = '77554' ,`RoomCount` = '10' ,`ListPrice` = '989000.00' ,`Status` = 'Active' ,`StreetName` = 'Deaf P Smith' ,`StreetNumber` = '21820' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1812' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This vacation home is 4 stories tall. On the first floor there is a tiki bar with half bath and wet bar as well as a covered boat slip over the canal. Second floor has granite kitchen with living room, dining room and two guest bedrooms. On the third floor there is a game room, washer/dryer, guest bathroom, guest bedroom and master bedroom with bathroom. On the fourth floor there is a sky deck overlooking Galveston Bay. Subdivision amenities include tennis courts, boat launch, lighted fishing pier, neighborhood pool, bait shop, gas, store and restaurants.' ,`Acres` = '0.1398' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 14 & 15 LOT 1709 SEA ISLE 12TH EXTENSION' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '6090' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '231' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Back,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'Traditional' ,`Subdivision` = 'Sea Isle' ,`TaxAmount` = '8126' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697080' WHERE `Matrix_Unique_ID` = '210809615' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T10:43:05.677' ,`MLSNumber` = '12056200' ,`ListAgentFullName` = 'Joni Wolfswinkel' ,`ListOfficeName` = 'Real Property Management Prefe' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.796338' ,`Longitude` = '-95.710122' ,`PhotoCount` = '8' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Peach Valley' ,`StreetNumber` = '19303' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1874' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investors! Property sold individually or with rental package. Text agent for details. Spacious 4 bedroom within walking distance from Westlake Community Park, Lovely property in a cul-de-sac with a delightful open floor plan featuring two living areas! Open peninsula kitchen with plenty of countertop space and a nice sized pantry and open to a breakfast nook.There\'s a well-illuminated dining room available right off the kitchen and the backyard is accessible through the living room.The living room is embroidered with a brick fireplace, and plenty of natural illumination runs throughout the house 4 spacious bedrooms with plenty of closet space, the master suite comes with its own bathroom with a tiled a step-in shower.' ,`Acres` = '0.1848' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 40 BLK 10 WESTLAKE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MAYDE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westlake Sec 01' ,`TaxAmount` = '4377' ,`TaxRate` = '2.4758' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697081' WHERE `Matrix_Unique_ID` = '210877178' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T11:22:00.190' ,`MLSNumber` = '66242484' ,`ListAgentFullName` = 'LaNell Shaw' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.806967' ,`Longitude` = '-95.074816' ,`PhotoCount` = '49' ,`PostalCode` = '77351' ,`RoomCount` = '8' ,`ListPrice` = '324900.00' ,`Status` = 'Active' ,`StreetName` = 'Plum Tree' ,`StreetNumber` = '863' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2497' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Be Impressed with this Majestic and Stunning Renovation of this 2497 Sq Ft - 5 Bedroom/2.5 Bath Waterview Home with Bonus Room ideal for Game Room, Office or Media Room! Kitchen is a Dream with Breakfast Room and separate Formal Dining. Completely gutted and masterfully renovated w/top of the line selections makes this beauty like new - upgraded top to bottom including: New Roof, New 55 Gal Water Heater, Pex Plumbing, New Cabinetry w/Quartz Countertops, Fabulous Bath Renovations, Pfister Fixtures, Massive Walk-In Shower in Owner\'s Suite w/Trolley Doors on Walk-In Closet, 2 Panel Doors, New Vinyl Plank Flooring and New Carpet with Supreme Grade Pad, Leveled and some Pads and Beams Replaced to mention a few! Utility Room In-House. Paperwork for all new Upgrades can be made available. Cedar Point Subdivision is a Gated Community with Community Center, Swimming Pool with Park Playground Area, several Boat Launches for Home Owners. Within 10 Minutes to either town - Livingston or Onalaska!' ,`Acres` = '0.324' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CEDAR POINT SECTION 1 BLK 27 LOT 2, 3, 4, 27, 28 & 29' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '14115' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Point Sec 1' ,`TaxAmount` = '2533' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697081' WHERE `Matrix_Unique_ID` = '210901494' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T11:08:41.730' ,`MLSNumber` = '75506497' ,`ListAgentFullName` = 'Pamela Eppes' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.097675' ,`Longitude` = '-95.475610' ,`PhotoCount` = '49' ,`PostalCode` = '77389' ,`RoomCount` = '6' ,`ListPrice` = '419000.00' ,`Status` = 'Active' ,`StreetName` = 'Juniper' ,`StreetNumber` = '4011' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1619' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Opportunity! This .708 of an Acre is UNRESTRICTED with no HOA! The property features 3 bedrooms with 2 full bathrooms, a large living room with fireplace, spacious kitchen with gas cooktop, plenty of cabinets storage, and a breakfast/dining area. Huge covered patio, 26x20 Porte Cochere attached to the 2 car garage, 26x20 RV Coverage, 24x20 Storage Building, and a 36x24 Metal Roof 3 Door Garage, extended wide driveway for plenty of parking. The home is on WELL and SEPTIC! Minutes away from SH99, The Woodlands, and Exxon Mobile facility. LOW TAXES! THE HOME HAS NEVER FLOODED! ORIGINAL OWNER! Call today!' ,`Acres` = '0.7084' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 93 017*M5967300-002-000-093 MOSSY OAKS SEC 2' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '30858' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'ZWINK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mossy Oaks Sec 02' ,`TaxAmount` = '3803' ,`TaxRate` = '2.124' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697081' WHERE `Matrix_Unique_ID` = '210927798' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T10:38:16.290' ,`MLSNumber` = '28067081' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.949616' ,`Longitude` = '-95.197656' ,`PhotoCount` = '25' ,`PostalCode` = '77346' ,`RoomCount` = '16' ,`ListPrice` = '549853.00' ,`Status` = 'Active' ,`StreetName` = 'Banchory Leaf' ,`StreetNumber` = '12623' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3137' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Albany, Elevation H) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, study and formal dining room. Spacious island kitchen open to family room. Primary suite with large walk-in closet. Three additional bedrooms, spacious game room and media room on second floor. Covered patio and attached 2-car garage. Forget the world outside and come home to Balmoral, a community surrounded by beauty and peace in the West Lake Houston area of northeast Beltway 8 in Humble, TX. Balmoral offers residents connected living with luxurious homes and many amenities to choose from, including the Houston area\'s Crystal Clear Lagoon surrounded by glistening white sand beaches. Stop by the Westin Homes model home today to find out more about Balmoral!' ,`Acres` = '0.175' ,`Area` = '1' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7624' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1430' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '1851' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697081' WHERE `Matrix_Unique_ID` = '210956752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T10:58:55.827' ,`MLSNumber` = '69466111' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.968147' ,`Longitude` = '-95.268523' ,`PhotoCount` = '19' ,`PostalCode` = '77541' ,`RoomCount` = '5' ,`ListPrice` = '608000.00' ,`Status` = 'Active' ,`StreetName` = 'Bluewater' ,`StreetNumber` = '1739' ,`StreetSuffix` = 'Highway' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1676' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ever dreamed of living by the beach? Here\'s your chance! This is a brand new, beautiful 3 bedroom, 2 bathroom beach house! Walk into this spacious open floor plan. The living space is in the front of the home and the bedrooms are towards the back. You won\'t want to miss out on this home, call today for your private showing.' ,`Acres` = '0.6' ,`Area` = '5' ,`BuilderName` = 'Smyth Construction' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'B C I C DIV 1 LOT 208D (A0009 B T ARCHER) (SURFSIDE) ACRES 0' ,`LotDesciption` = 'Water View' ,`LotSize` = '26136' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'B C I C Div 1' ,`TaxAmount` = '1087' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697081' WHERE `Matrix_Unique_ID` = '211084483' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T10:27:15.117' ,`MLSNumber` = '8154131' ,`ListAgentFullName` = 'Rebecca Nelson' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.255285' ,`Longitude` = '-96.106884' ,`PhotoCount` = '50' ,`PostalCode` = '77488' ,`RoomCount` = '7' ,`ListPrice` = '950000.00' ,`Status` = 'Active' ,`StreetName` = 'CR 132' ,`StreetNumber` = '3016' ,`StreetSuffix` = 'Road' ,`City` = 'Wharton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '2400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite county estate situated on 11.62 acres on the Colorado River is perfect for relaxation & entertainment. The foyer opens up to the large gourmet kitchen that features an oversized island, upgraded granite, new backsplash, SS appliances & beautiful cabinetry. Great room has soaring ceilings, new lighting, luxury vinyl flooring, gorgeous fireplace & abundant natural light. Primary bedroom has french doors that open up to the patio with stunning views of the river. The primary bath has an enormous double vanity & spa-like shower. Wrought iron stairs lead you up to the 2nd story loft bedroom w/ full bath & double closets. Your guests will enjoy the large patio that runs the length of the back of the home & the view of your bluff overlooking the Colorado. Walk down to the river bed to enjoy the sand and water. One car garage, storage/tack room, plus covered carport. Great weekend getaway or Air BNB w/ the Kitten Ranch around the corner. No restrictions. Watch the virtual tour.' ,`Acres` = '11.62' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A20007 ABST.7 TRACT 66D ACRES: 11.62' ,`LotDesciption` = 'Water View,Waterfront,Wooded' ,`LotSize` = '506167' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman,Other Style,Traditional' ,`Subdivision` = 'None' ,`TaxAmount` = '4577' ,`TaxRate` = '2.01419' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697081' WHERE `Matrix_Unique_ID` = '211206469' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T10:08:44.087' ,`MLSNumber` = '93101417' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.958770' ,`Longitude` = '-95.199670' ,`PhotoCount` = '17' ,`PostalCode` = '77346' ,`RoomCount` = '11' ,`ListPrice` = '746696.00' ,`Status` = 'Active' ,`StreetName` = 'Agogo Woods' ,`StreetNumber` = '16634' ,`StreetSuffix` = 'Way' ,`City` = 'Humble' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3740' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 93101417 - Built by Toll Brothers, Inc. - December completion! ~ Your dream home is waiting. The striking two-story foyer offers sweeping views of the great room just beyond. The stunning kitchen is highlighted by a designer backsplash, modern cabinets, and upgraded countertops. A first-floor office provides the space to work from home. Gorgeous interior finishes highlight every room of this home. Experience the luxury you\'ve always wanted and schedule your appointment today!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 (PURE ACCT*1504710010049) GROVES SEC 30' ,`LotDesciption` = 'Cul-De-Sac,Other,Subdivision Lot' ,`LotSize` = '8899' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '393' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Groves-Select Collection' ,`TaxAmount` = '' ,`TaxRate` = '3.73' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697082' WHERE `Matrix_Unique_ID` = '211225164' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T10:21:18.793' ,`MLSNumber` = '19988205' ,`ListAgentFullName` = 'Cynthia Garcia' ,`ListOfficeName` = 'Tramco Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.027736' ,`Longitude` = '-95.456430' ,`PhotoCount` = '23' ,`PostalCode` = '77090' ,`RoomCount` = '7' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Romaine' ,`StreetNumber` = '1110' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2574' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated 4 bedroom home on over 10k cul-de-sac lot ! All spacious bedrooms are located upstairs with lots of closet space and storage. New carpet upstairs, less than 5 years old flooring downstairs. Kitchen features granite counter tops and tile flooring. Bathrooms feature granite counter tops. Recent modern paint, new garage doors, large back yard with a good sized shed with windows, perfect for workshop, playhouse.' ,`Acres` = '0.2332' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 118 BLK 11 WESTADOR SEC 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'BAMMEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westador Sec 03' ,`TaxAmount` = '4429' ,`TaxRate` = '2.3072' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697082' WHERE `Matrix_Unique_ID` = '211298660' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T11:04:13.637' ,`MLSNumber` = '90508562' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.910745' ,`Longitude` = '-95.750924' ,`PhotoCount` = '36' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '561722.00' ,`Status` = 'Active' ,`StreetName` = 'Cecil Garden' ,`StreetNumber` = '8818' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#90508562 REPRESENTATIVE PHOTOS ADDED Built by Taylor Morrison, November Completion! The beautiful Terracotta is the perfect 2 story family home. As you step into the foyer from the porch, you get invited into a large family room with a gorgeous open island kitchen and a casual dining area. Then transition to the secluded owner\'s suite with dual sinks and a large walk-in closet. The study at the front of the home is perfect for a home office. The second floor opens to below in the family room and foyer and features an open railing staircase. Upstairs has a huge game room for the kiddos, 3 generous-sized secondary bedrooms, and 2 baths. Omega stone countertops throughout! Painted brick exterior and close to cul-de-sac! Structural options added to 8818 Cecil Garden include: a walk-in shower at the owner\'s bath, fireplace, 8-foot interior doors, lifestyle space, and study.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 30, Block 3, Avalon at Cypress, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6475' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Avalon at Cypress 50\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697082' WHERE `Matrix_Unique_ID` = '211301728' --> Updated record success