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-12T10:31:34.893' ,`MLSNumber` = '29526788' ,`ListAgentFullName` = 'Magdalena Cano' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.785835' ,`Longitude` = '-95.326555' ,`PhotoCount` = '36' ,`PostalCode` = '77026' ,`RoomCount` = '1' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Kirk' ,`StreetNumber` = '2515' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this spacious fully renovated home. This open floor plan offers 2 bedrooms/2 bathrooms, with tray ceilings, granite countertops, custom-built cabinets, tile floors throughout, a laundry room, and a host of other fine finishes. The roof, plumbing, electrical, appliances, wrought iron gate, and air conditioning of this property were all renovated in 2018. Easy access to main freeways and conveniently located close to Downtown, Toyota Center, Houston Dynamo, Discovery Green, and many restaurants. No HOA! The home is occupied.' ,`Acres` = '0.1148' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 2 ROY B NICHOLS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DOGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Roy B Nichols' ,`TaxAmount` = '3106' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697546' WHERE `Matrix_Unique_ID` = '208002169' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T11:41:37.547' ,`MLSNumber` = '85053873' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Mitchell Maxwell' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.860591' ,`Longitude` = '-95.735023' ,`PhotoCount` = '8' ,`PostalCode` = '77449' ,`RoomCount` = '6' ,`ListPrice` = '355490.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Dove Hill' ,`StreetNumber` = '5151' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2170' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WONDERFUL NEW D. R. HORTON BUILT 4 BEDROOM WITH 3 FULL BATHS! PREMIUM CORNER LOT LOCATION! Desirable Plan with Two Bedrooms & Baths Downstairs! Island Kitchen with Abundant Cabinetry - Opens Onto Spacious Dining Area & Living Area! Privately Located First Floor Primary Suite Offers Huge Walk-In Closet & Bath with Large Shower! Second Bedroom/Guest Suite with Adjoining Full Bath Also Downstairs! Massive Gameroom/Media Room Up! Generously Sized Indoor Utility Room! Covered Patio! Estimated Completion - July 2022.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 JASMINE HEIGHTS SEC 23' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`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` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HEMMENWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697546' WHERE `Matrix_Unique_ID` = '209033577' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T10:20:10.790' ,`MLSNumber` = '51518597' ,`ListAgentFullName` = 'Madelene Rogers' ,`ListOfficeName` = 'Martindale Real EstateInvestments' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.524840' ,`Longitude` = '-94.446490' ,`PhotoCount` = '41' ,`PostalCode` = '77663' ,`RoomCount` = '7' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Ming' ,`StreetNumber` = '906' ,`StreetSuffix` = 'Place' ,`City` = 'Village Mills' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2350' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LAKEFRONT HOME ON 0.4 AC . 3/2/2 LOOKING FOR ITS NEW OWNER, LARGE LIVINGING AREA WITH WINDOWS ON ALL SIDES, FOR A VIEW OF THE LAKE. WET BAR, FORMAL DINING ROOM. KITCHEN HAS DOUBLE OVEN, DISHWASHER, COMPACTOR, AND REFRIGERATOR. THE LAKE IS ON 3 SIDES OF PROPERTY. LOCATED IN A 24/7 SECURITY , BEAUTIFUL 18 HOLE GOLF COURSE 365 AC LAKE FOR FISHING AND WATER SPORT. VOLLEYBALL, BASKETBALL AND TENNIS COURTS, LOCATED IN A CARING COMMUNITY. THE HOUSE GOT 6 INCHES OF WATER IN THE HOUSE DURING HARVEY, WAS COMLETELY REDONE BY PROFESSIONAL. 365 AC. LAKE WHICH IS CURRENTLY DRAINED IN PREPARATION FOR RECONSTRUCTION. MEAS APPROX. HOME SELLIING AS IS.' ,`Acres` = '0.4144' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 4 BLK 122 WILDWOOD P# WW122-4 I# 1075/511 & WILL' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '18051' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1012 - Warren' ,`SchoolElementary` = 'WARREN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KOUNTZE HIGH SCHOOL' ,`SchoolMiddle` = 'KOUNTZE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wildwood' ,`TaxAmount` = '3309' ,`TaxRate` = '1.9244' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697546' WHERE `Matrix_Unique_ID` = '209306424' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T10:17:06.027' ,`MLSNumber` = '52533138' ,`ListAgentFullName` = 'Bain McEldowney' ,`ListOfficeName` = 'RE/MAX Metro' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.760404' ,`Longitude` = '-95.568746' ,`PhotoCount` = '50' ,`PostalCode` = '77042' ,`RoomCount` = '9' ,`ListPrice` = '1295000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeside Valley' ,`StreetNumber` = '103' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4011' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 103 Lakeside Valley! Per seller and previous seller, this home did not flood. This custom 2-story home is zoned to Rummel Creek Elementary, Memorial Middle, and Stratford HS. This gorgeous home is nestled into a quiet cul-de-sac on an over-sized, ravine-view lot. The spacious interior boasts hardwood floors, high ceilings, updated kitchen, and grand windows offering endless views of a natural ravine/wooded area in the rear. The private back yard is a tranquil get-away from the city, and the screened swimming pool can be used year-round. Engineered foundation includes deep builders piers. The oversized garage offers plenty of room for cars and activity space. Included on the property is a large 3-room apartment, with full bath. The apartment has served as a game room and guest suite, but it could be easily utilized as a full-time bedroom. Per the previous owner, the home did not flood, and it has not flooded during these sellers’ ownership.' ,`Acres` = '0.4465' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 LAKESIDE FOREST SEC 4' ,`LotDesciption` = 'Cul-De-Sac,Ravine,Wooded' ,`LotSize` = '19450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'RUMMEL CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeside Forest Sec 04' ,`TaxAmount` = '18688' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697546' WHERE `Matrix_Unique_ID` = '209667252' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T11:26:12.777' ,`MLSNumber` = '32225858' ,`ListAgentFullName` = 'David Jones' ,`ListOfficeName` = 'Evans and Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.844635' ,`Longitude` = '-95.147731' ,`PhotoCount` = '42' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'May' ,`StreetNumber` = '1405' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1088' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is 4 acres fronting Brushy Creek, Brushy Creek runs into Lake Livingston. This tract has a 3 bedroom mobile home in need of repair. And there is another location that recently had a mobile home on it with utilities in place. One drive way to both locations. Unrestricted use. No POA.' ,`Acres` = '4' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ONALASKA 360 LOT 4' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '174240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Onalaska 360' ,`TaxAmount` = '308' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697546' WHERE `Matrix_Unique_ID` = '210762903' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T10:32:33.843' ,`MLSNumber` = '23059501' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.088532' ,`Longitude` = '-95.598179' ,`PhotoCount` = '23' ,`PostalCode` = '77375' ,`RoomCount` = '10' ,`ListPrice` = '471988.00' ,`Status` = 'Active' ,`StreetName` = 'Sam Raburn' ,`StreetNumber` = '22110' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2541' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#23059501 ~ REPRESENTATIVE PHOTOS ADDED! Ready September! The Camelia plan offers 5 bedrooms, 4 baths, and an open concept layout ideal for any type of entertaining! Excellent location across from community pool and park! Beautiful interior finishes and flooring throughout! The kitchen includes an island perfect for quick meals or appetizers and is connected to the casual dining area. Lounge with friends outside on the covered patio in privacy! The first-floor owner\'s retreat boasts a luxurious bath with dual vanity sinks and a large walk-in closet. A bedroom and full bath located off the foyer is ideal for guests. Upstairs, there are three bedrooms, 2 full bathrooms, and a game room. Structural options include: additional full bath, bedroom 5/bath 3 ILO flex, 8\' front door, and covered outdoor living.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RABURN RESERVE LOT 7, BLOCK 2, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9026' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '760' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Raburn Reserve 50\'s' ,`TaxAmount` = '' ,`TaxRate` = '2.436' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697547' WHERE `Matrix_Unique_ID` = '211147217' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T10:22:40.310' ,`MLSNumber` = '53720952' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.051501' ,`Longitude` = '-95.359294' ,`PhotoCount` = '42' ,`PostalCode` = '77373' ,`RoomCount` = '7' ,`ListPrice` = '309990.00' ,`Status` = 'Active' ,`StreetName` = 'Yellow Ginko' ,`StreetNumber` = '4830' ,`StreetSuffix` = 'Trail' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2125' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Cypresswood Landing in Spring, TX! Conveniently located with easy access to Grand Parkway, I-45, FM 1960, and I-69 - commuting to the Energy Corridor, The Woodlands, or Bush Intercontinental Airport is a breeze! The Briscoe floor plan is a stunning two-story home with soaring ceilings in the foyer! Complete with 4 bedrooms, 2.5 baths, game room, and 2-car garage. This home has it all - including blinds and room for an additional refrigerator or freezer in the utility room! The gourmet kitchen is sure to please with 42\" cabinets and granite countertops! Retreat to the Owner\'s Suite featuring a double sinks and separate tub and shower. Enjoy the great outdoors with full sod and a covered patio! Don’t miss your opportunity to call Cypresswood Landing home, schedule a visit today!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'LEGEND HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 8 BLK 4 CYPRESSWOOD LANDING SEC. 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Landing' ,`TaxAmount` = '' ,`TaxRate` = '2.61' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697547' WHERE `Matrix_Unique_ID` = '211171796' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T11:14:07.460' ,`MLSNumber` = '15698314' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.277755' ,`Longitude` = '-95.534015' ,`PhotoCount` = '27' ,`PostalCode` = '77316' ,`RoomCount` = '16' ,`ListPrice` = '654874.00' ,`Status` = 'Active' ,`StreetName` = 'Caverna' ,`StreetNumber` = '512' ,`StreetSuffix` = 'Street' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3471' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Preston III, Elevation P) CURRENTLY BEING BUILT. Two Story. 4 bedrooms, 3.5 baths. Private Primary Suite with spacious walk-in closet downstairs. Formal Dining Room and Living Room/Study with spacious Kitchen and breakfast area open to Family Room. Spacious Game Room upstairs with private Media Room. Covered patio and attached 2 car garage. You\'ll fall in love with the Woodforest lifestyle—there’s something for everyone! The frequent social events and community amenities are a quick golf cart ride away. These days, residents of Woodforest can be found biking along miles of scenic trails, dining and shopping at The Shops at Woodforest, relaxing by the pool, touring the community via golf cart, or hitting the links at the renowned Woodforest Golf Club. Stop by the Westin Homes sales model to learn more about Woodforest!' ,`Acres` = '' ,`Area` = '39' ,`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` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 9 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10683' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '' ,`TaxRate` = '2.79' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697547' WHERE `Matrix_Unique_ID` = '211183793' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T10:18:54.523' ,`MLSNumber` = '28840613' ,`ListAgentFullName` = 'Ivan Arjona' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.425042' ,`Longitude` = '-95.631674' ,`PhotoCount` = '41' ,`PostalCode` = '77356' ,`RoomCount` = '9' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'BENT TREE' ,`StreetNumber` = '142' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2956' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous and move-in ready! Recently updated home in the exclusive community of Bentwater. Well-appointed designer touches throughout. Open, light and bright floorplan featuring 4 bedroom/3 bath, private study, dining room and breakfast room. Screened balcony off the upstairs guest suite, could be a gameroom or media room. Kitchen and all bathrooms remodeled in 2021. Upscale lighting throughout. Other thoughtful updates include designer cabinets in the kitchen and bathrooms, beautiful Quartz countertops, Stainless Steel appliances, attractive wood finish tile flooring, ceiling fans and complete interior paint. New additions include the screened balcony, back patio deck, French drain and landscaping in 2022. Hot water heater, driveway and dishwasher replaced in 2021. New evaporator coil and condenser 8/22 and 2nd system replaced in 2021. Short walk to the Country Club grill, pool, fitness center, tennis courts and spa. Perfect home for entertaining friends and family.' ,`Acres` = '0.2149' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 19, BLOCK 2, LOT 24' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9362' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1146' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double 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,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '7093' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697547' WHERE `Matrix_Unique_ID` = '211207689' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T11:10:45.510' ,`MLSNumber` = '14277453' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.949534' ,`Longitude` = '-95.198689' ,`PhotoCount` = '26' ,`PostalCode` = '77346' ,`RoomCount` = '16' ,`ListPrice` = '549657.00' ,`Status` = 'Active' ,`StreetName` = 'Roscobie Park' ,`StreetNumber` = '15611' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3136' ,`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.1427' ,`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 68 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6218' ,`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` = '1659' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697547' WHERE `Matrix_Unique_ID` = '211222982' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T10:41:36.800' ,`MLSNumber` = '51797905' ,`ListAgentFullName` = 'Mark Dimas' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.892248' ,`Longitude` = '-95.715916' ,`PhotoCount` = '24' ,`PostalCode` = '77433' ,`RoomCount` = '3' ,`ListPrice` = '276000.00' ,`Status` = 'Active' ,`StreetName` = 'Flowing Oak' ,`StreetNumber` = '7902' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1515' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming single-story home featuring 3 bedrooms, 2 bathrooms, and a 2-car attached garage! Inside, you\'ll find neutral paint, wood-type flooring and tile throughout, ceiling fans, a fireplace in the living room, and an island kitchen that boasts granite countertops and access to the utility room. The master bedroom suite includes a walk-in closet, a jetted tub, and a separate shower while the backyard offers a covered patio! This home is located with proximity to TX-99/Grand Pkwy, Hwy 6, and the Boardwalk at Towne Lake!' ,`Acres` = '0.1256' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 5 OAK LANDING SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5470' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '470' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'DURYEA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Landing Sec 02' ,`TaxAmount` = '4824' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663697547' WHERE `Matrix_Unique_ID` = '211256418' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-12T11:10:17.570' ,`MLSNumber` = '7297530' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.949202' ,`Longitude` = '-95.197931' ,`PhotoCount` = '5' ,`PostalCode` = '77346' ,`RoomCount` = '15' ,`ListPrice` = '549638.00' ,`Status` = 'Active' ,`StreetName` = 'Banchory Leaf' ,`StreetNumber` = '12614' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3122' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Alden II, Elevation AL) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, Living room/Study and 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 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.1515' ,`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 62 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`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` = '1714' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663697547' WHERE `Matrix_Unique_ID` = '211258797' --> Updated record success