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-12-01T09:52:53.643' ,`MLSNumber` = '18889788' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.295089' ,`Longitude` = '-95.403408' ,`PhotoCount` = '37' ,`PostalCode` = '77301' ,`RoomCount` = '6' ,`ListPrice` = '279462.00' ,`Status` = 'Active' ,`StreetName` = 'Cub' ,`StreetNumber` = '3661' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Mackenzie Creek in Conroe, Texas! Conveniently located off 336, East of 45 - where homeowners enjoy the benefit of low property taxes and close proximity to Lake Conroe! The Devonhurst II plan is a spacious 2-story home with 4 bedrooms, 2.5 baths, and 2-car garage. This home has it all on an oversized homesite! The first floor offers the perfect space for entertaining with a peninsula kitchen open to both the living and dining areas! The gourmet kitchen is sure to please with 42\" cabinetry, granite countertops, and stainless steel applinces. Retreat to the Owner\'s Suite featuring a walk-in closet and separate tub and shower. Enjoy the great outdoors with a covered patio! Don\'t miss your opportunity to call Mackenzie Creek home, schedule a visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15 Blk. 1 Mackenzie Creek Sec. 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mackenzie Creek' ,`TaxAmount` = '' ,`TaxRate` = '2.89' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086061' WHERE `Matrix_Unique_ID` = '207637616' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T10:21:25.693' ,`MLSNumber` = '32918008' ,`ListAgentFullName` = 'Sondra Petermann-Williams' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.195151' ,`Longitude` = '-95.576474' ,`PhotoCount` = '50' ,`PostalCode` = '77382' ,`RoomCount` = '27' ,`ListPrice` = '2950000.00' ,`Status` = 'Active' ,`StreetName` = 'Sterling Dale' ,`StreetNumber` = '2' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6785' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite Custom T.D. Cox home designed & built with elegance & timeless architectural details situated on 1.18 acres of majestic grounds on the Player Course. Home boasts 6785 sq ft living space, 5 bedrooms, 5 baths, & 2 half baths. Step into the soaring entry & enjoy the magnificence of the formal living w/fireplace, elevator, wine room, formal dining & many walls of windows. Primary suite includes stunning views of outdoors, spa like bath plus his/her closets. Study features fireplace, built-ins & great view of outdoors. Open concept kitchen w/center island, Wolf appliances, breakfast room, family room w/fireplace & built-ins, luxurious game room/card room w/built-ins/wet bar/ice maker. Guest suite down. Upstairs find 3 secondary ensuite bedrooms, media room, plus game room w/balcony. Entertainment outdoors: pool/spa w/led color changing lights, 1200+ sq ft covered space, outdoor kitchen w/Wolf Grill, wood burning fireplace, fire pit, mosquito mister & 45 KW whole house generator.' ,`Acres` = '1.1768' ,`Area` = '15' ,`BuilderName` = 'Tom Cox' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL STERLING RIDGE 23, BLOCK 3, LOT 5' ,`LotDesciption` = 'Cleared,Cul-De-Sac,On Golf Course,Subdivision Lot,Wooded' ,`LotSize` = '51262' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'DERETCHIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Sterling Ridge 23' ,`TaxAmount` = '41091' ,`TaxRate` = '2.1816' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086061' WHERE `Matrix_Unique_ID` = '207844773' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T09:50:37.413' ,`MLSNumber` = '68913733' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.293636' ,`Longitude` = '-95.400269' ,`PhotoCount` = '38' ,`PostalCode` = '77301' ,`RoomCount` = '7' ,`ListPrice` = '313385.00' ,`Status` = 'Active' ,`StreetName` = 'Cub' ,`StreetNumber` = '3681' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2628' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Mackenzie Creek in Conroe, Texas! Conveniently located off 336, East of 45 - where homeowners enjoy the benefit of low property taxes and close proximity to Lake Conroe. The Poole II plan is a spacious two-story home with 4 bedrooms, 2.5 baths, and 2-car garage. This home has it all - including a Texas-sized game room! The gourmet kitchen is sure to please with tons of COUNTER SPACE, 42\" cabinets, granite countertops, and stainless steel appliances! Enjoy the privacy and convenience of having the Owner\'s Suite on the first floor! Retreat to the Owner\'s Suite featuring an extended shower and spacious walk-in closet. Enjoy the great outdoors with a covered patio! Don\'t miss your opportunity to call Mackenzie Creek home, schedule a visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20 Blk. 1 Mackenzie Creek Sec. 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mackenzie Creek' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086061' WHERE `Matrix_Unique_ID` = '211304882' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T10:29:17.437' ,`MLSNumber` = '19998085' ,`ListAgentFullName` = 'Scott Laird' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.872033' ,`Longitude` = '-95.607147' ,`PhotoCount` = '36' ,`PostalCode` = '77041' ,`RoomCount` = '12' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Emmett' ,`StreetNumber` = '13010' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '2' ,`BedsTotal` = '9' ,`SqFtTotal` = '5203' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION -- located just minutes from FM 529 with easy access to US 290 and I-10. DUAL USE PROPERTY -- commercial/residential. Property is a single family property being used as office space but can be easily converted back to single family home. Over 5000+ sqft of space and offers 9 office spaces, full kitchen space, 1 full bath, and two half baths. Recently added 3-CAR CARPORT and offering 12 total parking spaces. Fenced backyard area, fireplace in main area, private well & septic, and LOW TAX RATE. Located less than 1 miles from intersection of FM 529 and Eldrige Parkway. Call for your private tour!! This space has endless possibilities!!!' ,`Acres` = '0.3809' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'E 158 FT OF LT 46 BLK 4 SATSUMA ESTATES SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '16590' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAIRGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Satsuma Estates' ,`TaxAmount` = '9239' ,`TaxRate` = '2.091' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086062' WHERE `Matrix_Unique_ID` = '211508430' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T09:48:15.863' ,`MLSNumber` = '64708449' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.292191' ,`Longitude` = '-95.399301' ,`PhotoCount` = '23' ,`PostalCode` = '77301' ,`RoomCount` = '7' ,`ListPrice` = '288582.00' ,`Status` = 'Active' ,`StreetName` = 'Raider' ,`StreetNumber` = '2247' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Mackenzie Creek in Conroe, Texas! Conveniently located off 336, East of 45 - where homeowners enjoy the benefit of low property taxes and close proximity to Lake Conroe. The Drake floor plan is a spacious 2-story home with 4 bedrooms, 2.5 baths, game room, and 2-car garage. This home has it all, including blinds, vinyl plank flooring, and a CORNER homesite! The first floor offers the perfect space for entertaining with a bar top kitchen open to the family room! The gourmet kitchen is sure to please with 42 inch cabinets and granite countertops! Retreat to the first-floor Owner’s Suite featuring a beautiful bay window, separate tub and shower, and a spacious walk-in closet! Secondary bedrooms have walk-in closets, too! Enjoy the great outdoors with full sod, a sprinkler system, and covered patio! Don\'t miss your opportunity to call Mackenzie Creek home, schedule a visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Blk. 3 Mackenzie Creek Sec. 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5506' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mackenzie Creek' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086062' WHERE `Matrix_Unique_ID` = '211722976' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T09:45:20.540' ,`MLSNumber` = '22267966' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.292682' ,`Longitude` = '-95.399469' ,`PhotoCount` = '19' ,`PostalCode` = '77301' ,`RoomCount` = '5' ,`ListPrice` = '249990.00' ,`Status` = 'Active' ,`StreetName` = 'Raider' ,`StreetNumber` = '2229' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1342' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Mackenzie Creek in Conroe, Texas! Conveniently located off 336, East of 45 - where homeowners enjoy the benefit of low property taxes and close proximity to Lake Conroe! The Charlotte floor plan is a charming 1-story home with 3 bedrooms, 2 bathrooms, and a 2-car garage! The gourmet kitchen is sure to please with 42\" cabinets and granite countertops. Enjoy the great outdoors with a sprinkler system and a covered patio! Don\'t miss your opportunity to call Mackenzie Creek home, schedule a visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'LEGEND HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 16 BLK 04 MACKENZIE CREEK SEC. 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4494' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mackenzie Creek' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086062' WHERE `Matrix_Unique_ID` = '211942462' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T10:15:14.730' ,`MLSNumber` = '81620905' ,`ListAgentFullName` = 'Ann Sheppard' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.000156' ,`Longitude` = '-95.573208' ,`PhotoCount` = '50' ,`PostalCode` = '77070' ,`RoomCount` = '16' ,`ListPrice` = '1665000.00' ,`Status` = 'Active' ,`StreetName` = 'Vintage Villa' ,`StreetNumber` = '9802' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6485' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury living at its finest in prestigious guard-gated community of Vintage Lakes. This stunning “smart” home has a 2-story foyer, faux painting & custom crystal chandeliers. The formal living room opens into a well-appointed study, while the formal dining room showcases a uniquely lighted Onyx wall, custom cabinets, & wine cellar. Island kitchen w/ floor-to-ceiling cabinets, granite counters, double convection oven, gas cooktop & great storage. The 2-story great room features a wood-beamed ceiling & floor to ceiling stacked-stone gas log fireplace. The primary bedroom has a double-tiered high ceiling while the adjoining bathroom is the ultimate in luxury. The California closet system is the largest you will ever see! Spacious guest bedroom on the ground floor. Sound-insulated Media room with wet bar & large game room on the second floor. The huge covered patio encourages seamless indoor-outdoor living with its stunning views of the pool, spa, waterfall & summer kitchen.' ,`Acres` = '0.3139' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 1 VINTAGE LAKES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13675' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KRAHN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Vintage Lakes Sec 2' ,`TaxAmount` = '21828' ,`TaxRate` = '2.474' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086062' WHERE `Matrix_Unique_ID` = '212950229' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T09:10:56.703' ,`MLSNumber` = '28958829' ,`ListAgentFullName` = 'Cameron Namazi' ,`ListOfficeName` = 'Summit Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.985146' ,`Longitude` = '-95.115958' ,`PhotoCount` = '48' ,`PostalCode` = '77532' ,`RoomCount` = '13' ,`ListPrice` = '319000.00' ,`Status` = 'Active' ,`StreetName` = 'Papoose' ,`StreetNumber` = '2015' ,`StreetSuffix` = 'Trail' ,`City` = 'Crosby' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2590' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING LOCATION!! This 5 bedroom and 3 bathroom home are located in the heart of Crosby and near Lake Houston and 1960 near the Kingwood area. New paint, new floors, and light fixtures. The spacious kitchen & breakfast room features granite countertops, stainless appliances & breakfast bar that opens to the formal dining room large family room, and to the large family room with a vaulted ceiling and fireplace!! Large Master Bedroom! The Master bath has jetted tub, a separate shower, and a double 2 Car garage with an oversized driveway perfect for additional parking! A fully fenced large backyard, that has an in-ground pool, and a covered patio area in which you can host parties on those hot summer days. Your new home is also located near Crosby Huffman Road, the Indian Shores Golf Course, and shopping centers.' ,`Acres` = '0.2927' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 25 INDIAN SHORES SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Indian Shores 8' ,`TaxAmount` = '6090' ,`TaxRate` = '2.5873' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086062' WHERE `Matrix_Unique_ID` = '213104490' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T10:55:45.563' ,`MLSNumber` = '43498364' ,`ListAgentFullName` = 'Fabiola Oropeza' ,`ListOfficeName` = 'Vibrant Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.628327' ,`Longitude` = '-95.441365' ,`PhotoCount` = '23' ,`PostalCode` = '77045' ,`RoomCount` = '4' ,`ListPrice` = '219000.00' ,`Status` = 'Active' ,`StreetName` = 'Boynton' ,`StreetNumber` = '4211' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1446' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully renovated 4 bed 2 bath with modern feels. Spacious floor plan, Large primary bedroom, Huge living room, Fenced back yard for outdoor activities. Close to highways, Medical Center, Shopping and restaurants. Schedule your showing today!' ,`Acres` = '0.1712' ,`Area` = '18' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 17 PAMELA HEIGHTS SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7458' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HOBBY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Pamela Heights Sec 02' ,`TaxAmount` = '3762' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086063' WHERE `Matrix_Unique_ID` = '213621154' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T09:33:23.163' ,`MLSNumber` = '55173037' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.291511' ,`Longitude` = '-95.399082' ,`PhotoCount` = '20' ,`PostalCode` = '77301' ,`RoomCount` = '6' ,`ListPrice` = '274011.00' ,`Status` = 'Active' ,`StreetName` = 'Raider' ,`StreetNumber` = '2271' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Mackenzie Creek in Conroe, Texas! Conveniently located off 336, East of 45 - where homeowners enjoy the benefit of low property taxes and close proximity to Lake Conroe! The Devonhurst floor plan is a spacious 2-story home with 4 bedrooms, 2.5 baths, and 2-car garage. This home has it all on a CORNER LOT! The first floor offers the perfect space for entertaining with a peninsula kitchen open to both the living and dining areas! The gourmet kitchen is sure to please with 42\" cabinetry, granite countertops, and stainless-steel appliances. Upstairs offers a private retreat for all of the bedrooms! Retreat to the Owner\'s Suite featuring a walk-in closet and separate tub and shower. Enjoy the great outdoors with a covered patio! Don\'t miss your opportunity to call Mackenzie Creek home, schedule a visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 42 Blk. 5 Mackenzie Creek Sec. 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '4400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mackenzie Creek' ,`TaxAmount` = '' ,`TaxRate` = '2.7' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086063' WHERE `Matrix_Unique_ID` = '213807674' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T09:30:37.603' ,`MLSNumber` = '97715255' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.292140' ,`Longitude` = '-95.399290' ,`PhotoCount` = '28' ,`PostalCode` = '77301' ,`RoomCount` = '7' ,`ListPrice` = '260181.00' ,`Status` = 'Active' ,`StreetName` = 'Raider' ,`StreetNumber` = '2251' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1707' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Mackenzie Creek in Conroe, Texas! Conveniently located off 336, East of 45 - where homeowners enjoy the benefit of low property taxes and close proximity to Lake Conroe. The Darrel floor plan is a spacious 2-story home with 4 bedrooms, 2.5 baths, and 2-car garage. The first floor offers the perfect space for entertaining with a bar top kitchen open to the family room! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless-steel appliances! Retreat to the first-floor Owner’s Suite featuring a bay window, oversized shower, and spacious walk-in closet! Enjoy the great outdoors with a sprinkler system and covered patio! Don\'t miss your opportunity to call Mackenzie Creek home, schedule a visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 47, Blk. 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4210' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mackenzie Creek' ,`TaxAmount` = '' ,`TaxRate` = '2.7' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086063' WHERE `Matrix_Unique_ID` = '213810631' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T10:07:03.430' ,`MLSNumber` = '60431963' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.354233' ,`Longitude` = '-95.537510' ,`PhotoCount` = '17' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '389935.00' ,`Status` = 'Active' ,`StreetName` = 'Terrace Grove' ,`StreetNumber` = '2853' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2317' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'No rear neighbors nature view**\r\nThe Buescher home design is a charming two-story home plan offered in Westridge Cove 50\'. Be welcomed by the grand foyer showcasing a beautiful staircase and the open-plan great room. The included flex room is ideal for an open home office, den, or additional dining space. Whip up goodies in the gourmet kitchen or relax by the optional electric fireplace in the great room. And the upstairs loft area is great for entertaining!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = '01/01/18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5418' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas 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` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westridge Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086063' WHERE `Matrix_Unique_ID` = '213847144' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T09:49:37.260' ,`MLSNumber` = '31138873' ,`ListAgentFullName` = 'Sarah Conway' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.427819' ,`Longitude` = '-95.627586' ,`PhotoCount` = '50' ,`PostalCode` = '77356' ,`RoomCount` = '8' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Monterrey' ,`StreetNumber` = '185' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2246' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare find... Beautifully UPDATED 1-story in the prestigious gated golf community of Bentwater! Nestled amongst the trees on Weiskopf #2 w/ views of the golf course & 2nd tee box. Custom home w/ OPEN floorplan, spacious rooms, tall ceilings, real wood floors & Over $100K spent in remodeling in the last 2 years. UPDATES Include: updated kitchen w/new stainless appliances, countertops, and cabinetry, fresh paint throughout, new LED lights & light fixtures, completely remodeled baths, reconfigured fireplace/mantel/dining (Pull Feature Sheet)! Split floorplan w/ private Master BR & Spa-like Bath. Large secondary BR with walk-up Study/craft/Bonus Room. BR3 (or Study) just to the right of the front door. Peaceful screened porch perfect for relaxing & entertaining. Enjoy life, like you\'re on a vacation with access to the country club, THREE 18-hole championship golf courses, the yacht club, sports club, 24 hr manned gate. Comes w/social membership. Montgomery ISD!!!' ,`Acres` = '0.1653' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 05, BLOCK 1, LOT 5' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1146' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '6200' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086064' WHERE `Matrix_Unique_ID` = '213908072' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T09:29:31.837' ,`MLSNumber` = '92413826' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.291622' ,`Longitude` = '-95.399119' ,`PhotoCount` = '24' ,`PostalCode` = '77301' ,`RoomCount` = '7' ,`ListPrice` = '280228.00' ,`Status` = 'Active' ,`StreetName` = 'Raider' ,`StreetNumber` = '2267' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2076' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Mackenzie Creek in Conroe, Texas! Conveniently located off 336, East of 45 - where homeowners enjoy the benefit of low property taxes and close proximity to Lake Conroe. The Aubrey floor plan is an open concept 2-story home with soaring ceilings in the entry! Complete with 4 bedrooms, 2.5 bathrooms and a 2-car garage. The interior features an open kitchen, dining, and family room perfect for entertaining! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless-steel appliances. Retreat to the first-floor Owner\'s Suite featuring a beautiful bay window, double sinks, and a separate tub and shower. Enjoy the great outdoors with a covered patio! Don\'t miss your opportunity to call Mackenzie Creek home, schedule a visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 43 Blk. 5 Mackenzie Creek Sec. 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mackenzie Creek' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086064' WHERE `Matrix_Unique_ID` = '214284480' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T09:28:20.953' ,`MLSNumber` = '87751133' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.293501' ,`Longitude` = '-95.401301' ,`PhotoCount` = '37' ,`PostalCode` = '77301' ,`RoomCount` = '7' ,`ListPrice` = '283576.00' ,`Status` = 'Active' ,`StreetName` = 'Cub' ,`StreetNumber` = '3653' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2076' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Mackenzie Creek in Conroe, Texas! Conveniently located off 336, East of 45 - where homeowners enjoy the benefit of low property taxes and close proximity to Lake Conroe. The Aubrey floor plan is an open concept 2-story home with soaring ceilings in the entry! Complete with 4 bedrooms, 2.5 bathrooms and a 2-car garage. The interior features an open kitchen, dining, and family room perfect for entertaining! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless-steel appliances. Retreat to the first-floor Owner\'s Suite featuring a beautiful bay window, double sinks, and a separate tub and shower. Enjoy the great outdoors with a sprinkler system and a covered patio! Don\'t miss your opportunity to call Mackenzie Creek home, schedule a visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13 Blk. 1 Mackenzie Creek Sec. 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mackenzie Creek' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086064' WHERE `Matrix_Unique_ID` = '214286046' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T10:29:28.263' ,`MLSNumber` = '63344601' ,`ListAgentFullName` = 'Dane Gates' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.383328' ,`Longitude` = '-95.419143' ,`PhotoCount` = '50' ,`PostalCode` = '77303' ,`RoomCount` = '10' ,`ListPrice` = '825000.00' ,`Status` = 'Active' ,`StreetName` = 'Pineridge' ,`StreetNumber` = '10155' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3353' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful custom home and guest house situated on fully fenced and gated 5 acres only a short commute to Conroe, Willis and The Woodlands! Open concept split plan that features a spacious living with gorgeous picture windows overlooking the wooded backyard. Island kitchen with abundant storage, site built cabinetry, stainless appliances, pot filler, and pantry. Kitchen opens to a large family room with custom built ins and cozy fire. Perfect for entertaining with Formal Dining, Gameroom, large covered patio, and incredible outdoor space. Primary Suite with luxurious bath. Primary bath includes double sinks, soaking tub, and stand alone shower. Spacious secondary bedrooms. This property also features a 600 SF apartment that includes a kitchen, bedroom and full bath. 50x40 Metal pole barn and covered RV parking. Amazing privacy encompassed in trees giving the property a gorgeous park like setting. Close to Conroe-North Houston Regional Airport. CISD schools. Country living at its best!' ,`Acres` = '5' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'S743100 - NORTHRIDGE, LOT 36, ACRES 5' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '217800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Northridge' ,`TaxAmount` = '16293' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086064' WHERE `Matrix_Unique_ID` = '214369894' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T09:13:14.447' ,`MLSNumber` = '25045669' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.290677' ,`Longitude` = '-95.399334' ,`PhotoCount` = '19' ,`PostalCode` = '77301' ,`RoomCount` = '6' ,`ListPrice` = '250299.00' ,`Status` = 'Active' ,`StreetName` = 'Raider' ,`StreetNumber` = '2298' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1337' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Mackenzie Creek in Conroe, Texas! Conveniently located off 336, East of 45 - where homeowners enjoy the benefit of low property taxes and close proximity to Lake Conroe! The Charlotte floorplan is a charming 1-story home with 3 bedrooms, 2 bathrooms, and a 2-car garage! This home has it all, including vinyl plank flooring throughout the entire home! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, undermount sink, and tile backsplash! Retreat to the Owner\'s Suite featuring a beautiful bay window and sizable shower. Enjoy the great outdoors on the covered patio! Don\'t miss your opportunity to call Mackenzie Creek home, schedule a visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'LEGEND HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 33 BLK 05 MACKENZIE CREEK SEC. 02' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4495' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mackenzie Creek' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086065' WHERE `Matrix_Unique_ID` = '214383521' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T10:11:57.097' ,`MLSNumber` = '95721969' ,`ListAgentFullName` = 'Amanda Kelley' ,`ListOfficeName` = 'Cedar Stone Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.085898' ,`Longitude` = '-95.121950' ,`PhotoCount` = '45' ,`PostalCode` = '77336' ,`RoomCount` = '5' ,`ListPrice` = '749000.00' ,`Status` = 'Active' ,`StreetName` = 'Commons Vista' ,`StreetNumber` = '603' ,`StreetSuffix` = 'Drive' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2641' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Look at this gorgeous home sitting on almost 3 acres.As you walk up you notice the extensive front porch,perfect spot for watching the many deer that call The Commons home.As you enter the double front doors on right is your spacious formal dining.Down the hall is 2beds,large bath and office nook.Living area is open and bright with lots of natural lighting.Primary bed is located off the living area and has its own private door to the backyard and separate patio.Primary bath has double sinks and newly renovated huge shower.Recent updated kitchen is stunning,tile backsplash,beautiful countertops,new appliances,farmhouse sink,and pot filler are just a few of the features in the gorgeous kitchen.Above garage is a living area with full bath and own AC/heat.Front & most of backyard yard has a hidden fence,pasture is fenced and crossed fenced with a loafing shed and chicken coop ready for animals.If that was not enough the home has a recent roof and Renewal by Andersen Windows with warranty.' ,`Acres` = '2.957' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 5 COMMONS OF LAKE HOUSTON SEC 6' ,`LotDesciption` = 'Cleared' ,`LotSize` = '128807' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Commons Lake Houston Sec 06' ,`TaxAmount` = '9111' ,`TaxRate` = '2.0083' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086065' WHERE `Matrix_Unique_ID` = '214930360' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T10:22:25.440' ,`MLSNumber` = '93968977' ,`ListAgentFullName` = 'Steven Kleiman' ,`ListOfficeName` = 'Oakington Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.669850' ,`Longitude` = '-95.457113' ,`PhotoCount` = '20' ,`PostalCode` = '77035' ,`RoomCount` = '12' ,`ListPrice` = '1095000.00' ,`Status` = 'Active' ,`StreetName` = 'Willowgrove' ,`StreetNumber` = '10314' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3783' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '10314 Willowgrove is a new construction home built on a large corner lot in Willow Meadows. This centrally located home makes for an easy commute to the Galleria, the Medical Center, downtown & all of Houston’s premier attractions, including the Houston Zoo & NRG Stadium. Thoughtfully planned by Design DCA. The first floor features a large family room open to the island kitchen with tons of built-in cabinets. Upon entry you will find the study, dining room and wet bar. Several storage closets are located throughout the home which is a rarity in new construction. If the study is needed as a 5th bedroom, there is a full bath located on this level. Upstairs you will find the primary bedroom along with 3 additional secondary bedrooms and a game room. All bedrooms have walk-in closets and their own bathrooms. The backyard is expansive and wraps around the side of the home giving plenty of space for a pool, playset and additional outdoor living space.' ,`Acres` = '0.4902' ,`Area` = '20' ,`BuilderName` = 'McDaniel Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LTS 17 BLK 21 WILLOW MEADOWS SEC 7' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '396' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Meadows Sec 07' ,`TaxAmount` = '13561' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086065' WHERE `Matrix_Unique_ID` = '214974762' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215055664','1675086065','215055664','2022-12-01T09:41:44.110','90132638','Holly Fanning','Fanning Realty and Company LLC','','','29.685563','-95.721585','31','77407','8','354000.00','Active','Solitude Hill','8411','Lane','Richmond','2','0','3','2179','Single-Family','Welcome home to this well-maintained one-story home with excellent curb appeal located in Grand Mission. Just minutes from the Westpark Tollway, this subdivision is centrally located to many restaurants and shopping areas. This 3 bedroom with game-room/playroom home has an open concept feel with the kitchen open to the family room and dining room. Twin water filter system in the kitchen. Primary bedroom has great space, bath includes his/her sinks with vanity, a large tub, and a separate shower. You will also find a game room that can easily serve as an office, playroom, or gym. Enjoy the large backyard space with plenty of green grass for the kiddos to run and play. Programmable water sprinkler system. Camera and surround sound system stay. A must-see, this home will not disappoint!','0.132','37','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Fort Bend County North/Richmond','Central Gas','1','GRAND MISSION SEC 17, BLOCK 2, LOT 7','Cleared,Subdivision Lot','5750','Appraisal District','','1050','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','SEGUIN ELEMENTARY (FORT BEND)','BUSH HIGH SCHOOL','CROCKETT MIDDLE SCHOOL (FORT BEND)','Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','Grand Mission Sec 17','6783','2.5097','Water District','2013','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215111122','1675086065','215111122','2022-12-01T10:20:44.107','17906010','Steven Kleiman','Oakington Realty','','','29.663381','-95.461080','15','77035','10','848500.00','Active','Creekbend','4834','Drive','Houston','3','0','4','3296','Single-Family','4834 Creekbend is a new construction home built by McDaniel Homes. This centrally located home makes for an easy commute to the Galleria, the Medical Center, downtown & all of Houston’s premier attractions, including the Houston Zoo & NRG Stadium. Thoughtfully planned by Design DCA. The first floor features a large family room open to the island kitchen with tons of built-in cabinets. Two secondary bedrooms down along with the primary bedrooms are locarted on the first floor as well. Upstairs you will find an additional secondary bedroom and a game room. All bedrooms have walk-in closets. Great value for new construction!','0.2693','20','McDaniel','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Gaslog Fireplace','1','Willow Meadows Area','Central Gas','0','LT 144 BLK 8 WILLOW BEND','Subdivision Lot','11729','Appraisal District','','','1','To Be Built/Under Construction','2','Convection Oven,Double Oven,Electric Oven','0','','','Gas Cooktop','','Composition','27 - Houston','RED ELEMENTARY SCHOOL','WESTBURY HIGH SCHOOL','MEYERLAND MIDDLE SCHOOL','Appointment Required','Builder','2','Traditional','Willow Bend Sec 01','4863','2.3307','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215171766','1675086065','215171766','2022-12-01T09:52:47.933','75949118','Mirna Smith','Real Broker, LLC','','','30.141873','-95.211707','29','77357','6','319500.00','Active','Johnson','23362','Road','New Caney','2','0','3','1841','Single-Family','Beautiful 3 bedroom 2 bath fully renovated with tons of upgrades ready for its new owners. Location is the key to this one. This rare find is conveniently located with easy access to the Eastex Freeway. Completely remodeled Open concept design with three bedrooms down and a large bonus room or game room upstairs. A large room upstairs can be a game room or study or media room. Large windows throughout the house for natural light. The backyard oasis includes a covered patio and a full wood deck that wraps around the side of the house - perfect for entertaining family and friends.','0.2505','40','','','','','Sellers Disclosure','','','','Porter/New Caney East','Central Electric','0','S544600 - GREEN OAK, BLOCK 1, LOT 1','Subdivision Lot','10911','Appraisal District','','','0','','2','','0','','','','','Composition','39 - New Caney','OAKLEY ELEMENTARY SCHOOL','NEW CANEY HIGH SCHOOL','KEEFER CROSSING MIDDLE SCHOOL','Appointment Required','Appraisal District','1.5','Traditional','Green Oak','8069','2.6739','Public Sewer,Public Water','2002','Appraisal District'); --> New record created successfully