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-10-16T06:14:13.410' ,`MLSNumber` = '89982717' ,`ListAgentFullName` = 'Virginia Vasquez' ,`ListOfficeName` = 'Hardee & Company Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.845904' ,`Longitude` = '-95.475919' ,`PhotoCount` = '33' ,`PostalCode` = '77092' ,`RoomCount` = '9' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Silver Forest' ,`StreetNumber` = '5826' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3316' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 5826 Silver Forest Dr. This gorgeous Energy Star certified recent construction, 4/5 bdrm, 3.5 bath by Design Tech custom homes in a well-established neighborhood, with community swimming pool. This perfect family home, has an enormous amount of space. Open floor plan with high ceilings and plenty of room for hosting holiday gatherings indoors or out on the spacious patios and porches. 42\" tall cabinets, stainless steel appliances, granite countertops, large breakfast room, formal dining room, and study that can be used as a 5th bedroom, are some of the features offered. Master bedroom downstairs features access to the backyard, spa like bathroom, and large custom designed closet. All secondary bedrooms are spacious and light. Backing to a greenbelt, plenty of backyard greenspace, and double wide fence gate to park your boat. Make your appointment today!\r\n\r\nPhotos Coming Soon!!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 1 FOREST WEST SEC 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '17300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '238' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'FOREST WEST' ,`TaxAmount` = '13719' ,`TaxRate` = '2.5304' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665929175' WHERE `Matrix_Unique_ID` = '211331289' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T07:03:17.050' ,`MLSNumber` = '81479197' ,`ListAgentFullName` = 'Marie Davis' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.131714' ,`Longitude` = '-95.522752' ,`PhotoCount` = '50' ,`PostalCode` = '77389' ,`RoomCount` = '9' ,`ListPrice` = '642700.00' ,`Status` = 'Active' ,`StreetName` = 'Carrick Bend' ,`StreetNumber` = '25211' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4111' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you love to entertain, this home is for you! This fantastic open floorplan is filled with natural light for a space that\'s easy to host in and you will love to show off! Gather with family in the impressive two-story family room that overlooks the kitchen. This kitchen is perfect for hosting guests with dual ovens, a huge granite island, under cabinet lighting, and more! A flex space tucked away off the breakfast nook offers so many possibilities...a study, hobby room, play area, and more! Relax and unwind in the luxurious primary suite with a spacious sitting area, spa-like bath, and walk-in closet. Upstairs, the kids will have their own space to play in the oversized game room with a homework desk and French Doors that close for sound control. Check out this amazing backyard! The extended patio offers loads of room for outdoor entertaining with grassy space left where the kids and pets can play. Sprinkler system. Close to Auburn Lakes Rec Center w a pool, splash-zone, and park!' ,`Acres` = '0.2646' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 1 AUBURN LAKES RETREAT SEC 1' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '11524' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '680' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRENCH ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Auburn Lakes Retreat Sec 1' ,`TaxAmount` = '13431' ,`TaxRate` = '2.914' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665929175' WHERE `Matrix_Unique_ID` = '211430841' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T07:38:37.537' ,`MLSNumber` = '67020409' ,`ListAgentFullName` = 'Jarvis Williford' ,`ListOfficeName` = 'Intero Real Estate Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.864171' ,`Longitude` = '-95.739300' ,`PhotoCount` = '17' ,`PostalCode` = '77449' ,`RoomCount` = '7' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Iris Bloom' ,`StreetNumber` = '21018' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2108' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 1 story home is nestled in a cul des sac! This home boasts 4 bedrooms, 2 full bathrooms zone to Cy-Fair ISD. The open layout is perfect for entertaining and the large walking closet makes this one a must see. The home is equipped with solar panels also! DON\'T MiSS OUT!' ,`Acres` = '0.1777' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 42 BLK 2 JASMINE HEIGHTS SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7741' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HEMMENWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '6811' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665929175' WHERE `Matrix_Unique_ID` = '211636949' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T06:54:31.210' ,`MLSNumber` = '7236951' ,`ListAgentFullName` = 'Amy Vanterpool' ,`ListOfficeName` = 'Elite 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.136872' ,`Longitude` = '-95.061072' ,`PhotoCount` = '20' ,`PostalCode` = '77554' ,`RoomCount` = '4' ,`ListPrice` = '520000.00' ,`Status` = 'Active' ,`StreetName` = 'Martes' ,`StreetNumber` = '22903' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'All one level three bedrooms two bathrooms, canal front home in Terramar Beach. Windows have storm shutters you will really enjoy all the deck and patio space as well as the downstairs storage and yard area. Terramar community offers a pool, boat ramp, beach access, frisbee golf course, and pavilion area. Terramar is close to Sea Isle restaurant, marina, & stores. Buyer to verify room dimensions and details of the property. Everything stays with the sale of the property. Property is being sold AS IS.' ,`Acres` = '0.123' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 12 LOT 6 BLK 8 TERRAMAR BEACH SEC 4' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '5360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Terramar 4' ,`TaxAmount` = '7438' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665929175' WHERE `Matrix_Unique_ID` = '211902844' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T07:52:47.417' ,`MLSNumber` = '42152834' ,`ListAgentFullName` = 'Brenda Venable' ,`ListOfficeName` = 'Brenda Venable' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.807684' ,`Longitude` = '-95.575428' ,`PhotoCount` = '49' ,`PostalCode` = '77043' ,`RoomCount` = '9' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Western Village' ,`StreetNumber` = '2053' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2628' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unbelievable rare opportunity! Super secluded acreage inside the city! Minutes from I 10/Beltway 8! Resort style pool with lush landscaping! Enter through an automatic wrought gate down a long drive! Three bedrooms with three full baths! Primary is on a separate wing! Top of line granite in kitchen and baths! Kitchen includes wood soft close cabinetry! Stainless steel appliances with gas cooking@! Primary includes double sinks, separate shower, jacuzzi tub! Two 2022 Trane ac and heaters@! Replaced ductwork, plumbing water lines replaced, replastered decking around pool area, generator, solar panels! Views from every room! It is a must see! If you have visited Costa Rica you will feel like you are there!' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'RES A WESTERN VILLAGE SEC 1 U/R' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '118915' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Western Village Sec 01 U/R' ,`TaxAmount` = '10944' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665929175' WHERE `Matrix_Unique_ID` = '212434361' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T06:58:30.763' ,`MLSNumber` = '98165339' ,`ListAgentFullName` = 'Murphy Kovar' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.868307' ,`Longitude` = '-95.702682' ,`PhotoCount` = '31' ,`PostalCode` = '77449' ,`RoomCount` = '11' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Old Hickory' ,`StreetNumber` = '6419' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2392' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 6419 Old Hickory Street located in the heart of Bear Creek Plantation. This home has been updated with new high-end cabinets, Quartz countertops and backsplash in the kitchen, laminate wood floors and stainless steel appliances. Fresh paint, light fixtures, crown molding and 2 inch blinds throughout this lovely house. Large backyard that is fully fenced and mature trees in the front yard. All bedrooms are located upstairs and has no carpet just laminate wood floors. Large walk-in closets in all four (4) bedrooms and the utility room is conveniently located between the secondary bedrooms. Fireplace in the Family room with wall of windows for that extra natural light. You will not be disappointed after seeing the transformation of this amazing house. Make your appointment today!!' ,`Acres` = '0.1905' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 3 BEAR CREEK PLANTATION 2 PAR RP' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8298' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '470' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bear Creek Plantation 02 Prcl' ,`TaxAmount` = '5210' ,`TaxRate` = '2.671' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665929176' WHERE `Matrix_Unique_ID` = '212440786' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T07:56:07.437' ,`MLSNumber` = '66156470' ,`ListAgentFullName` = 'Milton Stewart' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.885943' ,`Longitude` = '-95.455682' ,`PhotoCount` = '11' ,`PostalCode` = '77088' ,`RoomCount` = '3' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Gloyna' ,`StreetNumber` = '9905' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated and bright, this home is located in the heart of Garden City Park. Newly laminated floors, neutral paint tones and a family friendly floor plan that makes this home perfect. Large backyard with plenty of space for \r\noutdoor entertaining. Separate storage shed for added space.' ,`Acres` = '0.0735' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 145 BLK F 017*G0351300-000-F00-145 GARDEN CITY PARK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NITSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'KLEIN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Garden City Park Sec 02' ,`TaxAmount` = '2715' ,`TaxRate` = '2.5451' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665929176' WHERE `Matrix_Unique_ID` = '212726750' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T07:09:40.200' ,`MLSNumber` = '96214487' ,`ListAgentFullName` = 'Mary Lou Moritz' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.624415' ,`Longitude` = '-95.584460' ,`PhotoCount` = '32' ,`PostalCode` = '77477' ,`RoomCount` = '7' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Sutton' ,`StreetNumber` = '3331' ,`StreetSuffix` = 'Square' ,`City` = 'Stafford' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '2242' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1-story with tile and wood floors. Pond/fountain in entry courtyard. Open floorplan with beautiful tile throughout & wood in primary bedroom. Plantation shutters, recent AC, radiant barrier in attic, some double pane windows, recent H20 heater. Recent insulated garage door. Storage closet in garage. LED lighting. Home has alarm system and security cameras. Laundry with sink located inside the house. Beautifully landscaped yard with pond, jasmine along back fence and flower beds. Covered back porch. Extra wide driveway. You will love this convenient location with easy access to Highway 59 and 90. Located in Stafford with low taxes.' ,`Acres` = '0.1978' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUGAR CREEK SEC 28, BLOCK 4, LOT 16' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '8616' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '50 - Stafford' ,`SchoolElementary` = 'STAFFORD ELEMENTARY SCHOOL (STAFFORD MSD)' ,`SchoolHigh` = 'STAFFORD HIGH SCHOOL' ,`SchoolMiddle` = 'STAFFORD INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugar Creek Sec 28' ,`TaxAmount` = '5861' ,`TaxRate` = '1.9342' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665929176' WHERE `Matrix_Unique_ID` = '212857500' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T07:49:25.867' ,`MLSNumber` = '59665418' ,`ListAgentFullName` = 'Ash Wermuth' ,`ListOfficeName` = 'Real Haven Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.684784' ,`Longitude` = '-95.481931' ,`PhotoCount` = '41' ,`PostalCode` = '77096' ,`RoomCount` = '12' ,`ListPrice` = '440000.00' ,`Status` = 'Active' ,`StreetName` = 'Jackwood' ,`StreetNumber` = '5443' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2181' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED...EVER! Move in ready Meyerland ranch home on a 9000+ SQFT LOT (Huge backyard)! Zoned to coveted Harrod Elementary School! This home features plenty of upgrades including but not limited to newer Roof, Windows, HVAC, Plumbing (All CPVC), Insulation, Electrical Panel, Electrical Service, Irrigation System, Dual Ovens, Refrigerator, Microwave, Gas Cooktop, Dishwasher, Washer/Dryer(Gas!) Included, Extensive Smart Home Wiring/Speakers, Ring Video Doorbell, and Carpet. This home also feature a ton of decorative, cabinetry, and lighting upgrades! This home is also VERY ENERGY EFFICIENT! The foundation was reinforced with 21 piers in 2009 and carriers a lifetime transferable warranty.' ,`Acres` = '0.2096' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 8 MAPLEWOOD SEC 12' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9130' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HEROD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Maplewood Sec 12' ,`TaxAmount` = '7434' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665929176' WHERE `Matrix_Unique_ID` = '213070935' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T07:51:51.160' ,`MLSNumber` = '80193296' ,`ListAgentFullName` = 'Dan King' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.676607' ,`Longitude` = '-95.435321' ,`PhotoCount` = '33' ,`PostalCode` = '77025' ,`RoomCount` = '3' ,`ListPrice` = '324000.00' ,`Status` = 'Active' ,`StreetName` = 'Madeline Alyssa' ,`StreetNumber` = '9810' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2256' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very spacious 3 bedroom, 2.5 bathroom, 2 story town home with 2 car attached garage in a gated community. 2 bedrooms down, primary room upstairs. Open kitchen to living areas, great for entertaining. HOA fee includes water and trash. Conveniently located near 610 freeway, medical center, NRG and much more.\r\n\r\nPlease independently verify room sizes and schools.' ,`Acres` = '0.0403' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 1 CONTEMPORARY PLAZA SEC 5' ,`LotDesciption` = 'Other' ,`LotSize` = '1754' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '185' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHEARN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Contemporary Plaza Sec 05' ,`TaxAmount` = '6781' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665929176' WHERE `Matrix_Unique_ID` = '213125982' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T07:32:15.107' ,`MLSNumber` = '35944932' ,`ListAgentFullName` = 'Carol Marple' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.081124' ,`Longitude` = '-95.194422' ,`PhotoCount` = '35' ,`PostalCode` = '77339' ,`RoomCount` = '10' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Knoll Terrace' ,`StreetNumber` = '5434' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous two-story brick home nestled amongst mature trees on a quiet cul-de sac. As you enter the home you will feel like you are at home....the open family room/dining room has been updated with new flooring, crown molding, and a modern fireplace. Kitchen has fresh paint and shiplap, granite counters & a stone backsplash that adds to the coziness of this home. The spacious primary retreat boasts an updated en suite with dual sinks, jetted tub, and huge walk in closet. Three spacious bedrooms up allows plenty of room for the entire family. Texas-sized back yard is great for entertaining and family BBQ\'s. Sprinkler system, washer, dryer & refrigerator included. NEVER FLOODED with access to the Greenbelt Trails, parks, pool, golf, tennis, restaurants, & shopping. COME LIVE LIFE IN THE WOODS....KINGWOOD!' ,`Acres` = '0.2039' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 34 ELM GROVE VILLAGE SEC 3' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '8880' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '439' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ELM GROVE ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elm Grove Village' ,`TaxAmount` = '5366' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665929176' WHERE `Matrix_Unique_ID` = '213256015' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T06:58:04.023' ,`MLSNumber` = '14985973' ,`ListAgentFullName` = 'Michelle Hinton' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.876861' ,`Longitude` = '-95.627457' ,`PhotoCount` = '39' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Sanour' ,`StreetNumber` = '14603' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2110' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful & better than new construction w/ recent updates in a private gated community! Positioned on a lot backing to a lake w/ the added privacy of no back neighbors, this 2-story features a light & airy floorplan w/wide-plank flooring, upgraded fixtures, PEX plumbing, 5\'\' baseboards, crown molding, & a neutral palette. A spacious living room w/ fireplace opens to a renovated kitchen (2021) w/stainless appliances, stunning quartz countertops w/contrasting glass tile backsplash, crisp white shaker cabinets & statement chandelier. First-floor Primary Suite has Ensuite w/dual sinks, soaking tub w/shower + a frameless walk-in shower. Upstairs offers a game room, built-in desk area, plus 2 additional bedrooms & a full bath w/double sinks. Outside welcomes you to a private backyard w/ recently added brick patio and greenspace. This home is conveniently located near HWY 6, Beltway 8 & 290 for an easy commute and quick access to nearby restaurants, shopping & entertainment!' ,`Acres` = '0.0746' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 1 LA MANSION ON HUFFMEISTER ROAD' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '3249' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'La Mansion/Huffmeister Road Re' ,`TaxAmount` = '8352' ,`TaxRate` = '3.171' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665929177' WHERE `Matrix_Unique_ID` = '213298244' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T07:10:48.900' ,`MLSNumber` = '29472102' ,`ListAgentFullName` = 'Donyale Jones' ,`ListOfficeName` = 'TDRealty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.491923' ,`Longitude` = '-95.123516' ,`PhotoCount` = '17' ,`PostalCode` = '77573' ,`RoomCount` = '6' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Newport' ,`StreetNumber` = '1305' ,`StreetSuffix` = 'Boulevard' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2157' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see This one-story property features 3 bedrooms and 2 full bathrooms in the desirable Newport subdivision. It is well maintained, cozy, and ready to move into. It comes complete with fireplace, ceiling fans, granite countertops, and an extra flex room near the nice sized backyard. It has pex plumbing, new HVAC system (2021). This home is fully upgraded ready for it new Owner.' ,`Acres` = '0.2238' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 3 PAGE 3 LOT 21 BLK 18 NEWPORT SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '49' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROSS ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport 6' ,`TaxAmount` = '5091' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665929177' WHERE `Matrix_Unique_ID` = '213338165' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T06:37:35.397' ,`MLSNumber` = '89948760' ,`ListAgentFullName` = 'Brent Crowell' ,`ListOfficeName` = 'RE/MAX Metro' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.574573' ,`Longitude` = '-95.016193' ,`PhotoCount` = '38' ,`PostalCode` = '77586' ,`RoomCount` = '6' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Meyer' ,`StreetNumber` = '1109' ,`StreetSuffix` = 'Road' ,`City` = 'Seabrook' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2486' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous custom home on Parker\'s Lake in the heart of Seabrook. This property has unmatched Southern lake front views to be enjoyed from the entire living space and primary bedroom. Property line extends into water so you can add a pier for kayaks and fishing. If you are looking for an amazing property minutes from the action this is it!' ,`Acres` = '0.2218' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 1 ( IMPS ONLY *1338000010019) PARKERS LAKE 2ND AMEN' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '9663' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '620' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level' ,`Subdivision` = 'Parkers Lake' ,`TaxAmount` = '7278' ,`TaxRate` = '2.2905' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665929177' WHERE `Matrix_Unique_ID` = '213433907' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T06:51:08.803' ,`MLSNumber` = '12397451' ,`ListAgentFullName` = 'Fadimata Diallo' ,`ListOfficeName` = 'Coldwell Banker RealtyREALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.044178' ,`Longitude` = '-95.468651' ,`PhotoCount` = '36' ,`PostalCode` = '77388' ,`RoomCount` = '12' ,`ListPrice` = '462500.00' ,`Status` = 'Active' ,`StreetName` = 'Big Cypress' ,`StreetNumber` = '18715' ,`StreetSuffix` = '' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3170' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This STUNNING 4 bed 3.5 bath home that has been COMPLETELY REMODELED is the find of a lifetime! Walk in and you\'re greeted by an elegant formal dining room great for dinner parties and family gatherings. Opposite the dining room are a formal living and family room with an open concept floorplan, BRAND NEW engineered wood flooring, a fireplace with brick surround, and plenty of natural lighting. The absolutely gorgeous kitchen is equipped with NEW quartz countertops, an extra-large island with a built-in cooktop, plus a new dishwasher, oven, cooktop and microwave. All new carpet, doors and paint in the home. Huge 1st floor owners retreat with a luxurious bathroom showcasing a custom tiled walk-in shower and an expanded closet. All bathrooms have new cabinets, countertops, flooring and wall tile. 2nd floor has a large game room, a guest suite, and 2 more bedrooms! Backyard features \r\nprofessional landscaping and a large covered patio great for outdoor entertaining. Must see to believe!!!' ,`Acres` = '0.22' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 3 Thicket at Cypresswood' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '703' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HAUDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Thicket At Cypresswood' ,`TaxAmount` = '7726' ,`TaxRate` = '2.6273' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665929177' WHERE `Matrix_Unique_ID` = '213518582' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T06:04:53.237' ,`MLSNumber` = '14876921' ,`ListAgentFullName` = 'Janetta Penn' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.051305' ,`Longitude` = '-95.156898' ,`PhotoCount` = '50' ,`PostalCode` = '77345' ,`RoomCount` = '12' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Seven Maples' ,`StreetNumber` = '2103' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom Klotz beauty in prestigious Kings Point, steps away from award winning schools! Soaring 2 story entry/double wrought iron front door! Lushly landscaped backyard paradise w/rec. re-plastered pool/spa/cool decking; located on OS corner lot *recent 150K upgrades including: triple pane windows dnstrs, plant. shutters, luxurious engineered wood flooring dnstrs; evap coil, hot water heaters, condenser, ductwork; pool automation; bonus room up; inviting French doored study w/f/p; dual sized f/p separates formal/family room *DID NOT FLOOD! Bonus room !' ,`Acres` = '0.343' ,`Area` = '32' ,`BuilderName` = 'KLOTZ' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 1 KINGS POINT VLG 1 AMEND R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '14932' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '585' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WILLOW CREEK ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Point' ,`TaxAmount` = '14419' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665929177' WHERE `Matrix_Unique_ID` = '213519051' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T07:06:35.170' ,`MLSNumber` = '14274241' ,`ListAgentFullName` = 'Kandas Graham' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800769' ,`Longitude` = '-95.757622' ,`PhotoCount` = '29' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '328000.00' ,`Status` = 'Active' ,`StreetName` = 'Vobe' ,`StreetNumber` = '22306' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2346' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 Bed 2.5 Bath located in a quiet cul-de-sac in the sought after Williamsburg Subdivision! Great floorplan with large master suite with two walk in closets, separate shower and tub. Huge Family room, Kitchen with tons of storage opening up to a gorgeous formal dining room filled with natural light and tall ceilings. Large covered patio, detached garage with separate workshop. Close to Neighborhood Pool, Tennis Courts and Clubhouse!\r\nBackdoor trash pick up is also included in the HOA dues.' ,`Acres` = '0.1983' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 88 BLK 10 WILLIAMSBURG SETTLEMENT SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WINBORN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MORTON RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Williamsburg Settlement Sec 02' ,`TaxAmount` = '5438' ,`TaxRate` = '2.4833' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665929178' WHERE `Matrix_Unique_ID` = '213520064' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T07:37:15.950' ,`MLSNumber` = '48413438' ,`ListAgentFullName` = 'Margaret Vinson' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.697862' ,`Longitude` = '-95.436656' ,`PhotoCount` = '36' ,`PostalCode` = '77025' ,`RoomCount` = '8' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'Aberdeen' ,`StreetNumber` = '3744' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two magnificent Oak trees greet you as you enter this charming Braes Heights home featuring open floor plan, 3 beds, 2 baths plus ~440 SF in detached air-conditioned bonus space. The large bonus room, currently being used as a Game Room, may also be perfect as a Home Office. The Pinterest-worthy Kitchen features marble countertops, beautiful custom-built cabinetry, stainless-steel appliances, subway tile backsplash and wood floors. Enclosed via a driveway gate, the backyard offers so much space for fun and relaxation with its spacious green space, beautiful tree & landscaping, large patio and covered carport that also offers shaded space for outdoor fun with trikes, chalk & games. Located in the inner-loop, community-centric neighborhood of Braes Heights, a DESIRABLE LIFESTYLE awaits with convenient commute to TMC, Uptown & Downtown + WALKABILITY to Mark Twain Elem, Pershing MS, parks, library, shops, fitness & more.' ,`Acres` = '0.1779' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Braeswood Place' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7749' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Braes Heights' ,`TaxAmount` = '13984' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665929178' WHERE `Matrix_Unique_ID` = '213534031' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T06:17:37.207' ,`MLSNumber` = '95572970' ,`ListAgentFullName` = 'Harry Lou' ,`ListOfficeName` = 'Fidelity Realtors and Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747482' ,`Longitude` = '-95.733850' ,`PhotoCount` = '39' ,`PostalCode` = '77450' ,`RoomCount` = '12' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Hidden Shore' ,`StreetNumber` = '2422' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4038' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW FOORING. NEW WINDING STAIRCASE/HANDRAIL! NEW ROOF! NEW INTERIOR PAINTING! LOTS OF IMPROVEMENTS IN THIS ELOQUENT KELLIWOOD LAKES HOME! LAKE VIEW, 4 BEDROOMS AND 3.5 BATHS. HIGH CEILING STUDY, FORMALS, GAMEROOM UP, MASTER DOWN W/ BAY WINDOW. MASTER BATH W/ DUAL SINKS, GARDEN TUB WITH SEPARATE SHOWER. ISLAND KITCHEN. EXCELLENT KATY ISD SCHOOLS. TWO STAIRCASES, ROOF TOP DECK / BALCONY WITH LAKE VIEW. PORTE COCHERE FOR ADDITIONAL PARKING.' ,`Acres` = '0.2296' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 KELLIWOOD LAKES SEC 1 PAR R/P' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '10000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HAYES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kelliwood Lakes Sec 01' ,`TaxAmount` = '12473' ,`TaxRate` = '2.3333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665929178' WHERE `Matrix_Unique_ID` = '213559518' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-16T07:03:21.030' ,`MLSNumber` = '89593507' ,`ListAgentFullName` = 'Tristan Broussard' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.510283' ,`Longitude` = '-95.738107' ,`PhotoCount` = '39' ,`PostalCode` = '77469' ,`RoomCount` = '11' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Cherrington Woods' ,`StreetNumber` = '2414' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3022' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful recent construction home in Walnut Creek! This 5 bedroom 4 bathroom home features luxury finishes, game room, media room, and is located on a cul-de-sac. First floor includes primary bedroom, en-suite primary bathroom, oversized walk-in closet, guest bedroom/office, full guest bathroom, and living spaces. The second floor includes three bedrooms, en-suite bath, guest bathroom with dual sinks, game room, and media room. This spectacular home also features, granite counters, reverse osmosis system, water softener, radiant attic barrier, UV HVAC lighting system, covered back patio, epoxied garage flooring, mudroom, and plenty of storage!' ,`Acres` = '0.1497' ,`Area` = '30' ,`BuilderName` = 'Pulte' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'WALNUT CREEK SEC 16, BLOCK 2, LOT 16' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6523' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'THOMAS ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walnut Creek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665929178' WHERE `Matrix_Unique_ID` = '213726534' --> 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','213734766','1665929178','213734766','2022-10-16T06:31:16.120','37587726','Mariam Rasouli','Mersaes Real Estate, Inc.','','','30.011612','-95.311278','16','77338','4','239000.00','Active','Secretariat Ridge','7426','Drive','Humble','2','0','4','1530','Single-Family','Don\'t this out on the opportunity to own this modern 1 story home with a traditional open concept kitchen. The home comes with 4 bedrooms and 2 bathrooms. A spacious traditional home in Humble is now available for you to call home! This gem is ready to entertain a family or friends. Come step foot into this charming home that features its cozy and nice sized windows and open kitchen. The home features all tile throughout the homes with no carpet! Enjoy the open backyard which is great for all your family activities, close to schools, major freeways and shopping. If you are interested this home come see 7426 SECRETARIAT RIDGE DR. This home is a must-see and is waiting for you to call it your own! Schedule your viewing appointment today!','0.1211','12','','','','','Sellers Disclosure','1','','','Humble Area West','Central Electric,Central Gas','1','LT 10 BLK 1 SADDLE RIDGE SEC 2','Subdivision Lot','5276','Appraisal District','','450','0','','2','','0','','','','','Composition','1 - Aldine','CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','JONES MIDDLE SCHOOL (ALDINE)','Appointment Required','Appraisal District','1','Traditional','Saddle Rdg Sec 02','4250','2.7734','Public Sewer,Water District','2005','Appraisal District'); --> New record created successfully