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-04T15:50:09.227' ,`MLSNumber` = '43246353' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.456344' ,`Longitude` = '-95.472633' ,`PhotoCount` = '6' ,`PostalCode` = '77583' ,`RoomCount` = '15' ,`ListPrice` = '420485.00' ,`Status` = 'Active' ,`StreetName` = 'Mallow Rose' ,`StreetNumber` = '8751' ,`StreetSuffix` = 'Way' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Enjoy the comforts of this stunning Lake Ridge Builders home in Huntington Place. Situated on a corner lot, this 3-sided brick home boasts a premium elevation, no back neighbors, tile flooring, wrought iron spindles, a study with French, full gutters, a sprinkler system, and a covered patio. Whip up meals for guests in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. Amenities of Huntington Place include a community pool, recreation center, and abundant green spaces. Residents benefit from direct access to Hwy 288 and Hwy 6, making the drive to the Texas Medical Center a quick one. Numerous outdoor adventures and nature parks surround the area, along with a variety of shops and restaurants. This is your dream home – call now to learn more!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '523' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntington Place' ,`TaxAmount` = '' ,`TaxRate` = '3.25' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668974201' WHERE `Matrix_Unique_ID` = '208186099' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T15:48:56.330' ,`MLSNumber` = '9987220' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.456307' ,`Longitude` = '-95.472633' ,`PhotoCount` = '8' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '342990.00' ,`Status` = 'Active' ,`StreetName` = 'Cabin Loft' ,`StreetNumber` = '8835' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*This home is under construction.* Settle into this charming Lake Ridge Builders home in Huntington Place. Resting on a spacious lot, this 3-sided brick home boasts tile flooring, faux wood blinds, full gutters, a sprinkler system, and a covered patio. Whip up meals for guests in the island kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. The serene primary suite features dual vanities, a 36” tub, and a separate shower. Amenities of Huntington Place include a community pool, recreation center, and abundant green spaces. Residents benefit from direct access to Hwy 288 and Hwy 6, making the drive to the Texas Medical Center a quick one. Numerous outdoor adventures and nature parks surround the area, along with a variety of shops and restaurants. This is your dream home – call today for more information!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '523' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntington Place' ,`TaxAmount` = '' ,`TaxRate` = '3.25' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668974201' WHERE `Matrix_Unique_ID` = '208609299' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T15:48:21.247' ,`MLSNumber` = '4550936' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.456307' ,`Longitude` = '-95.472633' ,`PhotoCount` = '8' ,`PostalCode` = '77583' ,`RoomCount` = '14' ,`ListPrice` = '434990.00' ,`Status` = 'Active' ,`StreetName` = 'Urban' ,`StreetNumber` = '623' ,`StreetSuffix` = 'Way' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2657' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*This home is under construction.* Seek comfort in this beautiful Lake Ridge Builders home in Huntington Place. Nestled on an oversized cul-de-sac lot, this 3-sided brick home boasts a premium elevation, open ceilings, tile flooring, wrought iron spindles, faux wood blinds, a study with French doors, full gutters, a sprinkler system, and a covered patio. Spend quality time in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. The tranquil primary suite features dual vanities, a 42” tub, and a separate shower. Amenities of Huntington Place include a community pool, recreation center, and abundant green spaces. Residents benefit from direct access to Hwy 288 and Hwy 6, making the drive to the Texas Medical Center a quick one. Numerous outdoor adventures and nature parks surround the area, along with a variety of shops and restaurants. This is your dream home – call now!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15 Block 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '523' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntington Place' ,`TaxAmount` = '' ,`TaxRate` = '3.25' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668974201' WHERE `Matrix_Unique_ID` = '208610029' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T14:18:34.427' ,`MLSNumber` = '50134424' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Sorita Alexander' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '30.157703' ,`Longitude` = '-95.612294' ,`PhotoCount` = '14' ,`PostalCode` = '77354' ,`RoomCount` = '3' ,`ListPrice` = '298740.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Lavender Lane' ,`StreetNumber` = '10002' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1617' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect brand NEW DR Horton Home!! Excellent location in Montgomery County! Lovely 1 story floor plan with designer details at every corner! Modern finishes and open living spaces! Beautiful island kitchen with granite countertops and white cabinetry! Nice primary bedroom suite with spa like bath! Includes a useful covered patio and landscape package! Hurry and call TODAY!!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21 Block 5 Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Enclave at Dobbin' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668974201' WHERE `Matrix_Unique_ID` = '209953322' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T14:22:05.830' ,`MLSNumber` = '75049820' ,`ListAgentFullName` = 'Teresa Neveu' ,`ListOfficeName` = 'Southern Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.231345' ,`Longitude` = '-95.283231' ,`PhotoCount` = '20' ,`PostalCode` = '77306' ,`RoomCount` = '6' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Beeson' ,`StreetNumber` = '18693' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Plenty of UNRESTRICTED Space on this Wonderful Country Living 4-acre property. Four acres with lots of potential. Very Spacious private corner lot located at the end of the street with plenty of room to grow. There is also a huge 3 garage bay, 41\'x25\' shop with lift, which would be great for an auto shop, storage or barn. The home is a 4 bedroom 2 full baths and another full bath under construction. The huge family room is open to the large kitchen. The square footage for the added 4th bedroom and the unfinished full bath has not been calculated in the Appraisal square footage. The added bedroom, closet and extra bath have not been calculated to reflect the total square footage of the property. Room sizes are approximate, buyers please verify. Come out and see this home today.' ,`Acres` = '4' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0303 - KIBBE WM, TRACT 12, SERIAL # TXFL586A06689GH11, LABE' ,`LotDesciption` = 'Corner,Wooded' ,`LotSize` = '174240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'MILAM ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Abstract Area' ,`TaxAmount` = '1422' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668974202' WHERE `Matrix_Unique_ID` = '210323135' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T15:44:17.817' ,`MLSNumber` = '80664803' ,`ListAgentFullName` = 'Emily Dieckmann' ,`ListOfficeName` = 'Keller Williams Realty C. P.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.455640' ,`Longitude` = '-97.961924' ,`PhotoCount` = '40' ,`PostalCode` = '78645' ,`RoomCount` = '6' ,`ListPrice` = '1499000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunset Ridge' ,`StreetNumber` = '6905' ,`StreetSuffix` = 'Way' ,`City` = 'Jonestown' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4118' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Semi Custom, highly upgraded home on almost 1 acre. Peek a boo views of Lake Travis & lush green hill country to enjoy. TESLA SOLAR &POWER WALLS make this a rare find & super energy efficient. Upgrades: automatic & motorized shades, accent walls like shiplap provide a modern feel, custom drapery in master & main living spaces, custom staircase railing, all light fixtures have been hand picked for each space as well as matching hardware throughout the home, & fenced back yard. Award winning layout boasts 3 car garage, 2 primary bedrooms + 2 other secondary bedrooms, office/5th bedroom, game room, media room, 2 fireplaces, 2 eating spaces, butlers pantry & MORE! Amenities are endless in the Hollows: miles of hiking and biking trails, a beach club, resort style pool and restaurant that overlooks the lake, boat launch area, kayak club, live music, neighborhood events, a brand new amenity center within walking distance of the home. Come see what Austin living is like on Lake Travis!' ,`Acres` = '0.8249' ,`Area` = '83' ,`BuilderName` = 'Coventry' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Solar Assisted' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 11 BLK B HOLLOWS PHS II-C THE' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Wooded' ,`LotSize` = '35933' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '540' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '114 - Lago Vista' ,`SchoolElementary` = 'LAGO VISTA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAGO VISTA HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Hollows Ph 2c The' ,`TaxAmount` = '18822' ,`TaxRate` = '2.39' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1668974202' WHERE `Matrix_Unique_ID` = '210344027' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T14:23:56.230' ,`MLSNumber` = '9105263' ,`ListAgentFullName` = 'Scott Laird' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.349433' ,`Longitude` = '-95.534848' ,`PhotoCount` = '26' ,`PostalCode` = '77304' ,`RoomCount` = '5' ,`ListPrice` = '360685.00' ,`Status` = 'Active' ,`StreetName` = 'Newcomb Hollow' ,`StreetNumber` = '531' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME home to Hills of Westlake located just minutes from Lake Conroe and zoned to CONROE ISD. Enjoy easy access to I-45 and a quick commute to lots of great shopping and dining. Community offers a large community pool and playground. THIS NEW 4 bed, 2.5 bath home is loaded with LUXURY features -- GRANITE ISLAND, stainless steel appliances, breakfast bar, and 42\" modern cabinetry. Kitchen open to living/dining with open views to your backyard space. Smart home package, & solid surface flooring throughout. Spacious guest rooms and a HUGE primary retreat w/ dual vanities, large walk-in closet, frameless shower, and separate tub. Relaxing backyard featuring covered back patio!!! MAKE THE MOVE!!!' ,`Acres` = '0.1386' ,`Area` = '19' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S582102 - HILLS OF WESTLAKE 02, BLOCK 1, LOT 31' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6039' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hills Of Westlake' ,`TaxAmount` = '1297' ,`TaxRate` = '2.98' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668974202' WHERE `Matrix_Unique_ID` = '210688521' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T14:23:24.907' ,`MLSNumber` = '80047657' ,`ListAgentFullName` = 'Scott Laird' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.349883' ,`Longitude` = '-95.535043' ,`PhotoCount` = '28' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '363485.00' ,`Status` = 'Active' ,`StreetName` = 'Newcomb Hollow' ,`StreetNumber` = '532' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2271' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME home to Hills of Westlake located just minutes from Lake Conroe and zoned to CONROE ISD. Enjoy easy access to I-45 and a quick commute to lots of great shopping and dining. Community offers a large community pool and playground. THIS NEW 4 bed, 3 bath home is loaded with LUXURY features -- GRANITE ISLAND, stainless steel appliances, breakfast bar, and 42\" modern cabinetry. Kitchen open to living/dining with open views to your backyard space. Study, Smart home package, & solid surface flooring throughout. Spacious guest rooms and a HUGE primary retreat w/ dual vanities, large walk-in closet, frameless shower, and separate tub. Relaxing backyard featuring covered back patio!!! MAKE THE MOVE!!!' ,`Acres` = '0.146' ,`Area` = '19' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S582102 - Hills Of Westlake 02, BLOCK 1, Lot 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hills Of Westlake' ,`TaxAmount` = '1297' ,`TaxRate` = '2.98' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668974202' WHERE `Matrix_Unique_ID` = '210689354' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T14:09:48.300' ,`MLSNumber` = '27131932' ,`ListAgentFullName` = 'Rachel Anderson' ,`ListOfficeName` = 'Rachel Anderson Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.729640' ,`Longitude` = '-96.187995' ,`PhotoCount` = '27' ,`PostalCode` = '75840' ,`RoomCount` = '8' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 1260' ,`StreetNumber` = '103' ,`StreetSuffix` = '' ,`City` = 'Fairfield' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very versatile story & half home on over half an acre! Zoned climate control & great arrangement of living space keeps everyone comfortable! A high ceiling & stunning rock fireplace make a memorable first impression as you enter to an open floor plan of the living, kitchen, & dining rooms. The spiral staircase leads to a loft bedroom with ensuite bath. Bedrms 2 & 3 are downstairs & share a hall bath with a tub & shower. You’ll enjoy the updated granite kitchen with huge walk-in pantry & the appliances are included. Just beyond the dining area through French doors is the massive den. Nice natural light & high ceiling with plenty of space for large furniture & even a pool table. Add\'l space in the loft for a playrm or office! Side door to open deck & huge privacy fenced back yard. Laundry room connects to a half bath & a big storage closet. Add’l storage in the shed that opens to the backyard. Plenty of covered parking under the double car attached carpt & 1 car gar.' ,`Acres` = '0.62' ,`Area` = '74' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Freestone County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WESTWOOD- I H REED A-23 TRACT 65' ,`LotDesciption` = 'Cleared' ,`LotSize` = '27007' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '226 - Fairfield' ,`SchoolElementary` = 'FAIRFIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FAIRFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRFIELD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Reed Surv' ,`TaxAmount` = '2189' ,`TaxRate` = '1.7349' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668974202' WHERE `Matrix_Unique_ID` = '210898701' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T15:18:16.017' ,`MLSNumber` = '83402597' ,`ListAgentFullName` = 'Kyle Pryor' ,`ListOfficeName` = 'Pryor Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.395084' ,`Longitude` = '-95.686348' ,`PhotoCount` = '7' ,`PostalCode` = '77356' ,`RoomCount` = '5' ,`ListPrice` = '509000.00' ,`Status` = 'Active' ,`StreetName` = 'Abner' ,`StreetNumber` = '207' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2686' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique 1 1/2 story floor plan. Primary bedroom down & a primary bedroom upstairs that could be used as another primary bedroom. The upstairs has a room, full bath & living area/game room. Upstairs is a private area not open to the down stairs so has plenty of privacy. 4 bedrooms with 2 living areas, 3 full baths, 2 1/2 car garage. Large corner lot. Ready for move in October 2022.' ,`Acres` = '0.2848' ,`Area` = '39' ,`BuilderName` = 'Camillo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S456900 - ESTATES OF LAKE CREEK VILLAGE, BLOCK 1, LOT 10' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '12406' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates Of Lake Creek Village' ,`TaxAmount` = '1166' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668974203' WHERE `Matrix_Unique_ID` = '211054493' --> Updated record success