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'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','205856336','1664113997','205856336','2022-09-25T06:55:24.740','9955927','Beverly Bradley','Weekley Homes','','','29.927667','-95.732929','25','77433','8','663040.00','Active','Keepers Dwelling','18711','Court','Cypress','3','1','4','3100','Single-Family','Fulfill your lifestyle ambitions in the vibrant and innovative Milburn home plan. The Jack-and-Jill bedrooms and a separate front bedroom offer plenty of personal space for your growing residents and overnight guests. A quiet media room and front study present unparalleled opportunities to craft the family movie theater and home office you’ve been dreaming of. The streamlined kitchen provides an easy culinary layout for the resident chef with an extended pantry and prep area and a delightful view of the sunny family and dining spaces. Spend quality time together in the shade of your covered patio. Your blissful Owner’s Retreat offers an everyday escape from the outside world, and includes a spa-inspired en suite bathroom and a luxury walk-in closet.','','25','David Weekley Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Home Protection Plan,Mud,No Disclosures','1','Gas Connections','1','Cypress South','Central Gas,Zoned','1','Lot 3 Block 1','Cul-De-Sac,Other,Subdivision Lot','','Survey','','1284','1','To Be Built/Under Construction','3','Convection Oven,Double Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','MCGOWN ELEMENTARY SCHOOL','BRIDGELAND HIGH SCHOOL','SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied','Builder','1','Contemporary/Modern,Traditional','Bridgeland','','3.68','Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T06:55:54.460' ,`MLSNumber` = '76972903' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.927928' ,`Longitude` = '-95.733015' ,`PhotoCount` = '49' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '684000.00' ,`Status` = 'Active' ,`StreetName` = 'Keepers Dwelling' ,`StreetNumber` = '18715' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy an abundance of everyday luxury in this glamorous and charming Ardell plan in Parkland Village. The upstairs retreat and downstairs study provide sunny spaces to craft your ideal special-purpose rooms. Unique personalities and growing minds can flourish in the delightful spare bedrooms. Soaring ceilings and sleek spaces for living and dining make the open floor plan a beautiful place to play host. Share your cuisine creations on the presentation island in the modern kitchen. Withdraw to the elegant Owner’s Retreat, which includes the closet and bathroom features to pamper your wardrobe and yourself. The covered porches present remarkable opportunities for outdoor relaxation. Lifestyle refinements include extra storage, a 3-car garage, and a variety of built-in conveniences.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 1' ,`LotDesciption` = 'Corner,Cul-De-Sac,Other,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1284' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.68' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113997' WHERE `Matrix_Unique_ID` = '207636196' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T06:38:46.040' ,`MLSNumber` = '58737582' ,`ListAgentFullName` = 'Brandon Scott' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = 'Lee Smalley' ,`SellingOfficeName` = 'Energy Realty' ,`Latitude` = '29.703624' ,`Longitude` = '-95.842495' ,`PhotoCount` = '28' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '315000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Grassy Haven' ,`StreetNumber` = '6115' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1756' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 6115 Grassy Haven! Located on a cul-de-sac street this 1 story home features 3 bedrooms, 2 full baths, and a 2-car garage. Come inside and find a flex room with French doors and crown molding. The kitchen has a center island, lots of counter space, and a breakfast area. The primary bedroom has high ceilings, crown molding, and an ensuite with dual sinks and a separate bath and shower. The tranquil backyard has a covered patio, extended patio area for seating, and gardening paths with rocks and stepping-stones.' ,`Acres` = '0.1136' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTHEIMER LAKES NORTH SEC 7, BLOCK 2, LOT 47' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '4950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SHAFER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'SEVEN LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westheimer Lakes North Sec 7' ,`TaxAmount` = '5503' ,`TaxRate` = '2.6345' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113998' WHERE `Matrix_Unique_ID` = '207934226' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T07:51:03.560' ,`MLSNumber` = '54425913' ,`ListAgentFullName` = 'Andrea Martin' ,`ListOfficeName` = 'Century 21 Olympian LakeJackson' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.026924' ,`Longitude` = '-95.428953' ,`PhotoCount` = '40' ,`PostalCode` = '77566' ,`RoomCount` = '7' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Caladium' ,`StreetNumber` = '230' ,`StreetSuffix` = 'Street' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1894' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BACK ON THE MARKET! The charm of this four bedroom home in the heart of Lake Jackson is absolutely captivating! Walking up to the home you will notice a front patio and seating area. Open the front door and enter a lovely dining room or second living area with tons of natural lighting. The kitchen is open to the spacious living room and has a breakfast bar. The split floor plan features the primary bedroom on the opposite side of the home than the other three bedrooms. Out the back door you will find a patio, fenced back yard, and separate fenced area. Recently updated items include windows, roof, water heater and A/C. The seller is leaving both the kitchen refrigerator and the garage fridge for the new buyer as well as security cameras. Call myself or your Realtor today to make an appointment!' ,`Acres` = '0.2684' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BRAZOS OAKS SEC 4 (LAKE JACKSON), BLOCK 11, LOT 30' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11692' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brazos Oaks Lake Jackson' ,`TaxAmount` = '4391' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113998' WHERE `Matrix_Unique_ID` = '208149570' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T06:47:40.910' ,`MLSNumber` = '39716217' ,`ListAgentFullName` = 'Terrence Hartzell' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.571455' ,`Longitude` = '-95.615937' ,`PhotoCount` = '44' ,`PostalCode` = '77479' ,`RoomCount` = '14' ,`ListPrice` = '1580000.00' ,`Status` = 'Active' ,`StreetName` = 'Queen Mary' ,`StreetNumber` = '45' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6302' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss your opportunity on this stunning home situated on the Sweetwater Golf Course! Enter through the towering 21\' entry foyer, complete with dazzling chandelier and sweeping staircase. Custom wall finishes and tasteful trim complement solid wood doors and large windows. A Sub Zero refrigerator/freezer and Thermador ovens and cooktop make this home ready for entertaining. An \"extra room\" adjacent to the Owners Suite was originally built as quarters and has a separate o/s entrance. Now used as the Owner\'s Retreat, it includes a kitchenette, walk-in closet and another full bath. The patio and the balcony are both roof covered and, in addition to the views of the golf course, enjoy a southerly breeze. Ascend one more level to the third floor to enjoy the game room, entertainment area, and additional bedroom with full bath. Home has a 60 KW full-home Generac generator, roof-mounted lightning protection, and is fully prepped for Astroguard hurricane fabric protection.' ,`Acres` = '0.26' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Owner/Agent,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 22, BLOCK 8, SECTION 1' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,On Golf Course' ,`LotSize` = '11381' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2132' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY BEND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant' ,`SqFtSource` = 'Seller' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Sweetwater Sec 1' ,`TaxAmount` = '14069' ,`TaxRate` = '2.1789' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113998' WHERE `Matrix_Unique_ID` = '208844246' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T07:50:37.400' ,`MLSNumber` = '4623122' ,`ListAgentFullName` = 'Drue DaSilva' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.987829' ,`Longitude` = '-95.144999' ,`PhotoCount` = '47' ,`PostalCode` = '77346' ,`RoomCount` = '11' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Aquatic' ,`StreetNumber` = '18703' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2599' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'IMMACULATELY MAINTAINED, 1-STORY home on a PREMIUM, GOLF COURSE LOT. This home is FULL OF UPGRADES & is MOVE-IN READY. 2 attached garages for 3 cars. The oversized, extended, covered back patio with flagstone has an outdoor kitchen & granite-topped bar area ready for entertaining. This corner lot gives a great view of the course & has NO BACK NEIGHBORS. The home features 4 Beds/2 Baths (4th bed could be private study) & an open floor plan with great flow. The large, curved window & cathedral ceiling in the formal dining are stunning. The updated gourmet kitchen will wow you, as will the family room with custom built-ins. Enjoy the bamboo floors, 4\" shutters & 2\" blinds, crown molding, neutral paint, contemporary lighting & ample windows throughout. Low maintenance yard with lush landscaping, wrought-iron fence & sprinkler system. Convenient to W. Lake Houston Pkwy, IAH, 59 & Bltwy 8. Shopping, dining, golf & entertainment surround this wonderful, sought-after neighborhood. No flooding.' ,`Acres` = '0.1869' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 43 BLK 29 CHAMPIONS VILLAGE WALDEN ON LAKE HOUSTON PH 5' ,`LotDesciption` = 'Cleared,Corner,In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '8142' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '399' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'MAPLEBROOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden On Lake Houston' ,`TaxAmount` = '7074' ,`TaxRate` = '2.5885' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113998' WHERE `Matrix_Unique_ID` = '210346922' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T06:04:58.450' ,`MLSNumber` = '31445997' ,`ListAgentFullName` = 'Wallace Everitt' ,`ListOfficeName` = 'Southwest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.041844' ,`Longitude` = '-95.459097' ,`PhotoCount` = '41' ,`PostalCode` = '77388' ,`RoomCount` = '5' ,`ListPrice` = '265500.00' ,`Status` = 'Active' ,`StreetName` = 'Candle Pond' ,`StreetNumber` = '3115' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1821' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SECURE, GATED COMMUNITY. 2 BR WITH STUDY OFF MASTER BR. WOULD MAKE GREAT NURSERY OR 3RD BR.\r\nNEW A/C IN 2019 WITH TO 17 SEER. NEW GARAGE DOOR OPENER. 3 YEAR CHOICE HOME WARRANTY PURCHASED RECENTLY.\r\nREFRIGERATOR AND WASHER AND DRIER INCLUDED.' ,`Acres` = '0.1331' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 1 CANDLELIGHT PARK ESTATES SEC 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5797' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas 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` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Candlelight Park Estates Sec 0' ,`TaxAmount` = '4178' ,`TaxRate` = '2.124' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113998' WHERE `Matrix_Unique_ID` = '210399107' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T07:54:57.590' ,`MLSNumber` = '16832969' ,`ListAgentFullName` = 'William Fisher' ,`ListOfficeName` = 'Wyebrook Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.760227' ,`Longitude` = '-95.615562' ,`PhotoCount` = '38' ,`PostalCode` = '77077' ,`RoomCount` = '3' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Kingsbridge' ,`StreetNumber` = '12916' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2559' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated large 3 bedroom home located in a beautiful gated community. Recent updates include fully remodeled kitchen, bathrooms, Electrical panel, flooring, and much more. Zoned to Daily Elementary, West Briar Middle, and Westside High. Covered private back patio/deck area is great for relaxation or grilling with friends and family. Empty lot next door is a nice green space that no structure can be built on per the deed restrictions. Close proximity I-10, Energy Corridor, and City Center.' ,`Acres` = '0.09' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 STONEHENGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DAILY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stonehenge Sec 02' ,`TaxAmount` = '6488' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113998' WHERE `Matrix_Unique_ID` = '210965433' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T07:49:33.567' ,`MLSNumber` = '18965274' ,`ListAgentFullName` = 'Luwannah Lamas' ,`ListOfficeName` = 'ARBOR Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.609244' ,`Longitude` = '-95.116458' ,`PhotoCount` = '44' ,`PostalCode` = '77059' ,`RoomCount` = '12' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Elm Crest Trail' ,`StreetNumber` = '4022' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'There will be an open house scheduled this Saturday, September 17th, from 12-3 p.m. This stunning home can be a 4 bedroom with a media room, but has the 5th bedroom upgrade and is currently being used as an extremely roomy 5 bedroom, with a walk-in closet. Inside you will notice wood-look tile flooring installed in 2019, upgraded plantation shutters, 2 Energy Efficient HVACs installed in 2011, and foundation repairs with transferable lifetime warranties, performed in 2014. The Primary Bedroom Suite is downstairs and features double vanities and dual walk-in closets. 2 FULL bathrooms upstairs, one offers a Jack-n-Jill bathroom between secondary bedrooms, with a vanity in each room. All secondary bedrooms are large enough for multiple beds, leaving enough room to play. This Back Yard is an amazing- an oasis with lush landscaping, a heated pool and hot tub, and a pool deck that was redone in 2015. The garage has a 5 feet extension in the back, perfect for parking Texas trucks.' ,`Acres` = '0.22' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 1 PINE BROOK SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BROOKWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Brook' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113999' WHERE `Matrix_Unique_ID` = '211627701' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T07:40:43.343' ,`MLSNumber` = '18196851' ,`ListAgentFullName` = 'Paul Holub' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = 'Paulina Davila' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.884668' ,`Longitude` = '-95.705661' ,`PhotoCount` = '37' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '325000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Swan Valley' ,`StreetNumber` = '19618' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2402' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss out on this beautifully remodeled home in Cypress! NEVER FLOODED! This 4 bedroom, 2.5 bathroom home is zoned to Cy-Fair ISD schools. Fully updated kitchen with quartz countertops, distressed stone backsplash, SS apron front sink, gas range and new cabinets! Inviting breakfast area and a spacious formal dining room that can be a flex space. Large living room with wide-plank laminate flooring, gas-log fireplace & ample natural light. Mother-in-law bedroom downstairs with dual closets. NO CARPET IN THE HOUSE! New flooring up the stairs is accented by the wrought iron balusters. The spacious master bedroom is on the second floor with dual closets, vaulted ceilings and the amazing master bathroom with a new vanity, \"out of this world\" shower with dual rainfall showerheads & designer tile. Two additional bedrooms are upstairs w/ walk-in closets & a gameroom overlooking the generously sized backyard. Two car garage with double wide driveway, new roof & much more!' ,`Acres` = '0.1167' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 2 YAUPON PLACE SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '5082' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '312' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Yaupon Place' ,`TaxAmount` = '6313' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113999' WHERE `Matrix_Unique_ID` = '211813007' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T07:52:25.693' ,`MLSNumber` = '25299256' ,`ListAgentFullName` = 'Don Allen' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '31.346559' ,`Longitude` = '-96.338248' ,`PhotoCount` = '9' ,`PostalCode` = '76687' ,`RoomCount` = '6' ,`ListPrice` = '140000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hickory' ,`StreetNumber` = '12026' ,`StreetSuffix` = 'Loop' ,`City` = 'Thornton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1232' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Waterfront Property located on Two Large Lots . Almost One Acre Total. Very Nice Wood/Laminate Flooring. Large Outside Storage Shed. A Quiet Place to Relax and Enjoy Nature and Wildlife!\r\nLarge Back Covered Deck. Lots of Trees! Call Your Realtor to have a Private Showing.' ,`Acres` = '0.9' ,`Area` = '72' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BL 1 LAKE LIMESTONE COVES 1298/194 1324/323 LABEL#NTA0' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '39204' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '195 - Leon' ,`SchoolElementary` = 'LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LEON HIGH SCHOOL' ,`SchoolMiddle` = 'LEON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Limestone Coves' ,`TaxAmount` = '929' ,`TaxRate` = '1.7007' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113999' WHERE `Matrix_Unique_ID` = '212111563' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T07:50:52.080' ,`MLSNumber` = '31245941' ,`ListAgentFullName` = 'Rachel Gilbert' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.546723' ,`Longitude` = '-95.492959' ,`PhotoCount` = '39' ,`PostalCode` = '77545' ,`RoomCount` = '10' ,`ListPrice` = '324000.00' ,`Status` = 'Active' ,`StreetName` = 'Tucker Creek' ,`StreetNumber` = '2622' ,`StreetSuffix` = 'Drive' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2627' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous well-maintained home in Winfield Lakes offers plenty of room to stretch out. This beautiful 4 bedroom 2 1/2 bath house on a large lot is ready for move in. This house features a ton of upgrades. Granite counter tops, crown molding, extra-large game room, stainless steel appliances and water softner are just to name a few. Relax in your own deluxe style primary bathroom with separate shower and oversized tub. Winfield lakes offers beautiful lakes, walking trails, and a tennis court. Centrally located, close to highway 6 and fort bent toll, schedule your showing today to see this captivating property.' ,`Acres` = '0.1769' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WINFIELD LAKES SEC 17 PARTIAL REPLAT NO 1, BLOCK 1, LOT 1' ,`LotDesciption` = 'Other' ,`LotSize` = '7704' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PARKS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Winfield Lakes Sec 17 Pt Rep 1' ,`TaxAmount` = '6926' ,`TaxRate` = '3.0229' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113999' WHERE `Matrix_Unique_ID` = '212176344' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T07:17:41.950' ,`MLSNumber` = '6876010' ,`ListAgentFullName` = 'Mollie Yarborough' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.705073' ,`Longitude` = '-95.368881' ,`PhotoCount` = '23' ,`PostalCode` = '77021' ,`RoomCount` = '3' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Tampa' ,`StreetNumber` = '3387' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1391' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in Houston’s historic Riverside Terrace, this classic brick 3-bed, 2-bath home is not to be missed! Completely renovated in 2016 with further improvements made through 2022, the home features updated electrical, PEX plumbing, and new energy efficient windows. A/C system was installed in 2016, and includes an updated blower from 2019 that’s still under warranty, and updated roof, facia, and upper siding in 2021. This charming home boasts stainless steel appliances, hardwood floors, ample natural light, and an oversized yard for all of your entertaining needs. Ideally located inside the inner-loop, and within walking distance of Parkwood Park (Ivy Park). Placed perfectly near bike and walking trails along the bayou, and just minutes from a new HEB, Texas Medical Center, Museum District, Downtown, Rice University, U of H, and Texas Southern University. The home has never flooded and is idyllic for anyone looking for a classic updated home in one of Houston’s best kept secrets!' ,`Acres` = '0.1736' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Riverside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 74 RIVERSIDE TERRACE SEC 16' ,`LotDesciption` = 'Other' ,`LotSize` = '7560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'THOMPSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverside Terrace Sec 16' ,`TaxAmount` = '6439' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113999' WHERE `Matrix_Unique_ID` = '212299026' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T06:32:35.420' ,`MLSNumber` = '25715144' ,`ListAgentFullName` = 'Evelyn Martinez' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.491613' ,`Longitude` = '-95.160985' ,`PhotoCount` = '31' ,`PostalCode` = '77573' ,`RoomCount` = '0' ,`ListPrice` = '264999.00' ,`Status` = 'Active' ,`StreetName` = 'Woodvale' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1594' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**WELCOME HOME ! ** You’ll fall in love with this charming, beautiful and cozy one story home nestled in League City. This 3 bedroom and 2 bath home offers a brick exterior, high ceilings, formal dining room, granite counter tops in the kitchen and a living room that features a brick wood burning fireplace. This home has a relaxing primary suite that features a walk-in closet and a spacious backyard perfect for entertaining. Residents enjoy a short walking distance to Clear Creek, tennis courts, a swimming pool, walking trails, and parks. Located off I-45, commuters are a short drive from Clear Lake, Galveston Bay, and the Kemah waterfront., Space Center Houston and Baybrook Mall are all minutes away. Nearby schools are a part of Clear Creek ISD. \r\n\r\nThis home will not last long! OPEN HOUSE SATURDAY 9/10 & SUNDAY 9/11 12PM - 3PM' ,`Acres` = '0.1737' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 9 J DICKINSON SUR LOT 44 BLK 5 COUNTRYSIDE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7568' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '346' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'HALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Countryside' ,`TaxAmount` = '3699' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113999' WHERE `Matrix_Unique_ID` = '212325444' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T07:55:15.513' ,`MLSNumber` = '91538175' ,`ListAgentFullName` = 'Chris White' ,`ListOfficeName` = 'Dream Home Seekers' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.030157' ,`Longitude` = '-95.520678' ,`PhotoCount` = '40' ,`PostalCode` = '77379' ,`RoomCount` = '6' ,`ListPrice` = '283599.00' ,`Status` = 'Active' ,`StreetName` = 'Seven Pines' ,`StreetNumber` = '17215' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2206' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated 4 bedroom, 2.5 bath with a 2 car detached garage completely updated and move in ready. This house features updated lighting throughout. You walk into a spacious living room with wood like tile throughout your entire downstairs. Entertain in your formal dining room with family and friends as it boasts a grandeur look with updated flooring, door knobs, and 5 ½ inch baseboards throughout the downstairs. Cook your family meals in the updated kitchen with updated appliances, granite counter tops, backsplash subway tile. Keep your family and friends cool with the new AC unit recently installed. As you walk upstairs feel the softness of the updated carpet throughout the second story. Fresh paint, ceiling fans, and new roof! Klein Schools!' ,`Acres` = '0.1616' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 8 017*O0118825-001-008-024 OAKWOOD GLEN SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '492' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'EHRHARDT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Lockbox Left Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oakwood Glen Sec 01' ,`TaxAmount` = '4644' ,`TaxRate` = '2.5085' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664114000' WHERE `Matrix_Unique_ID` = '212463305' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T07:37:00.453' ,`MLSNumber` = '75664643' ,`ListAgentFullName` = 'Valentina Marcano-Boscan' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.144620' ,`Longitude` = '-95.477998' ,`PhotoCount` = '33' ,`PostalCode` = '77380' ,`RoomCount` = '12' ,`ListPrice` = '702420.00' ,`Status` = 'Active' ,`StreetName` = 'Logrun' ,`StreetNumber` = '2704' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3054' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Step into this beautifully remodeled home from 1976 & witness the unique mixture of vintage & modern styles. Conveniently located close to I-45 & The Woodlands Mall. Once inside, you’ll be taken with the elegant renovations including a stunningly remodeled kitchen with custom made soft-close cabinets, gas cooktop, electric oven, quartz countertops & porcelain backsplash. A designer-style gas fireplace with stained floating red oak shelves, water-resistant laminate flooring on the 1st floor, trendy new light fixtures and fans throughout the house. Master bath has been stunningly remodeled with quartz countertops, trendy bathroom tile & vintage fixtures, & a tasteful combination of chrome & brass finishes. This 5 bedroom designer-style house offers an abundance of sunlight & has direct access to hike & bike trails which lead to nearby tennis courts & Woodlands Country Club & Golf Course. Interior & exterior has been freshly painted, new A/C system & electrical panel. LOTS of storage.' ,`Acres` = '0.3025' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL GROGANS ML 02, BLOCK 2, LOT 28' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '13179' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAM HAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Grogans Ml 02' ,`TaxAmount` = '5355' ,`TaxRate` = '2.0469' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664114000' WHERE `Matrix_Unique_ID` = '212486815' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T07:49:35.327' ,`MLSNumber` = '9087911' ,`ListAgentFullName` = 'Michelle Hinton' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.848444' ,`Longitude` = '-95.592303' ,`PhotoCount` = '45' ,`PostalCode` = '77041' ,`RoomCount` = '11' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Sterling' ,`StreetNumber` = '5527' ,`StreetSuffix` = 'Brook' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3978' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stately Trendmaker home on a well-landscaped corner lot w/ pool & spa in desirable Lakes on Eldridge. A soaring 2-story foyer w/elegant curved staircase opens to a spacious plan w/ hickory wood flooring, plantation shutters & great natural light. Private Study w/ French doors & Formal Dining w/ millwork details feature bay windows overlooking the front of the home. Island kitchen w/ white cabinetry & breakfast bar boasts sleek black granite, stainless steel appliances, double oven. Family Room w/ updated fireplace & wall of windows overlooking the backyard & pool. First-floor Primary Suite features a spacious sitting area w/fireplace & an Ensuite w/dual vanities, jetted tub & frameless shower. Upstairs is a Game Room w/ built-ins, hidden room & desk area, plus 3 secondary beds and baths. Outside is a private backyard oasis. Flagstone patio w/ pergola, pool & spa. 3 car garage, gated driveway, recent roof. Enjoy resort-like living in this guard-gated community. Did not flood.' ,`Acres` = '0.28' ,`Area` = '8' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 2 LAKES ON ELDRIDGE SEC 18' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '12197' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'Gunite,Heated' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes On Eldridge Sec 18' ,`TaxAmount` = '13077' ,`TaxRate` = '2.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664114000' WHERE `Matrix_Unique_ID` = '212553928' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T06:36:16.437' ,`MLSNumber` = '49485709' ,`ListAgentFullName` = 'Juan Corral' ,`ListOfficeName` = 'Century 21 Olympian Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.508661' ,`Longitude` = '-95.799007' ,`PhotoCount` = '18' ,`PostalCode` = '77469' ,`RoomCount` = '6' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Sandy Sea' ,`StreetNumber` = '2323' ,`StreetSuffix` = 'Road' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1373' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 1 story home w/great curb appeal with tile entry along with new laminate wood plank flooring*Spacious tiled family room! The spacious bedrooms offer plenty of space for the whole family*You will love the granite counter tops and back splash w/ kitchen island*All black appliances (Fridge Stays)*Great master suite in this split floor planned home with new laminate flooring in all bedrooms. New exterior fire pit deck is the perfect spot for entertaining and roasting marshmallows. Perfect home to raise your family! Truly a must see!!!' ,`Acres` = '0.1404' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'THE TRAILS AT SEABOURNE PARKE SEC 3, BLOCK 1, LOT 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6118' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Trails At Seabourne Parke Sec 3' ,`TaxAmount` = '4946' ,`TaxRate` = '3.0248' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664114000' WHERE `Matrix_Unique_ID` = '212640163' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T06:45:42.557' ,`MLSNumber` = '25813213' ,`ListAgentFullName` = 'Ileana Riojas' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.025444' ,`Longitude` = '-95.431212' ,`PhotoCount` = '18' ,`PostalCode` = '77566' ,`RoomCount` = '3' ,`ListPrice` = '199000.00' ,`Status` = 'Active' ,`StreetName` = 'Redwood' ,`StreetNumber` = '217' ,`StreetSuffix` = 'Street' ,`City` = 'Lake Jackson' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1361' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A lovely home with a bright, open floor plan. The inviting living room is a great place to relax and unwind after a long day. The kitchen is built for function and flexibility with stainless steel appliances and plenty of natural light.\r\n The master bedroom is enveloped in warm light with plenty of closet space. The bathroom is light and airy. Additional rooms includes a home office perfect for working from home. The fully fenced backyard is a beautiful oasis with mature trees, the perfect place to relax and enjoy the outdoors, away from the hustle and bustle of everyday life. Come and take a look today!' ,`Acres` = '0.1667' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BRAZOS OAKS (LAKE JACKSON), BLOCK 6, LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7261' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brazos Oaks Lake Jackson' ,`TaxAmount` = '3567' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664114000' WHERE `Matrix_Unique_ID` = '212691660' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T06:33:44.713' ,`MLSNumber` = '88675258' ,`ListAgentFullName` = 'Joseph Murphy' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.400193' ,`Longitude` = '-95.277829' ,`PhotoCount` = '21' ,`PostalCode` = '77511' ,`RoomCount` = '8' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Wood Fox' ,`StreetNumber` = '3305' ,`StreetSuffix` = 'Drive' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2471' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to your spacious 3 bedroom, 2 1/2 bath affordably priced 2-story home. NO HOA! Home has a great master bedroom with large walk in closet. \r\nExtra large game room big enough for a pool table AND a ping pong tale.\r\nKitchen breakfast room combo. Inside laundry... washer and dryer can stay. \r\nThe backyard has a great shape and has covered patio to enjoy summer BBQ’s, the kids to play or the dog to run. \r\nThe home did not flood during Hurricane Harvey (2017) and did not lose power during the 2021 freeze per the seller. Make your appointment to see this home today before it is gone!!!' ,`Acres` = '0.1933' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FOXWOOD SUB (A0487 H & W), BLOCK 7, LOT 23, ALVIN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8420' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'NELSON ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Foxwood' ,`TaxAmount` = '7656' ,`TaxRate` = '2.8854' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664114000' WHERE `Matrix_Unique_ID` = '212771574' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T07:02:47.120' ,`MLSNumber` = '66731710' ,`ListAgentFullName` = 'Stacey Dawn Ocampo' ,`ListOfficeName` = 'Stacey Dawn Realty & Mortgage' ,`SellingAgentFullName` = 'Veronica Cisneros' ,`SellingOfficeName` = 'Jane Byrd Properties INTL.' ,`Latitude` = '30.037850' ,`Longitude` = '-95.329017' ,`PhotoCount` = '25' ,`PostalCode` = '77373' ,`RoomCount` = '5' ,`ListPrice` = '210000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Barrygate' ,`StreetNumber` = '22214' ,`StreetSuffix` = 'Circle' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Highest and Best Offer by Sept. 24,2022(Sat) 7: 00PM.Kids Need A Yard. HUGE BACK YARD. Cul De Sac lot. Ready for Immediate Move In. Refrigerator, Washer Dryer Included. Large Family Room with High Ceilings, Brick Wood Burning Fireplace, Ceiling Fan, Large window great for natural lighting in Family Room. In between Kitchen and Family is back door (with Screen Door) to back yard oasis. Kitchen comes with Beautiful Cabinets, long countertop tops great for preparing those large get together, with room for two barstools at the end. White appliances. Great Kitchen/Dining Combo. 2 Large windows in Kitchen. Good Size Pantry. Utility is in Garage. Garage has shelves & door that goes out to side yard. Auto garage opener for one side. Going to Love your Primary Room. It is large enough for the King Size Bed & Furniture plus has large window. Primary Bath Shower Only. 2nd & 3rd bedroom nice size with good size Closets. Elementary school in Neighborhood.' ,`Acres` = '0.2387' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 36 GREENGATE PLACE SEC 5 R/P' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10396' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '374' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greengate Place' ,`TaxAmount` = '3876' ,`TaxRate` = '2.6867' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664114001' WHERE `Matrix_Unique_ID` = '212810196' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T07:50:56.930' ,`MLSNumber` = '45347568' ,`ListAgentFullName` = 'Betty Baker Burns' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.751448' ,`Longitude` = '-95.490349' ,`PhotoCount` = '34' ,`PostalCode` = '77057' ,`RoomCount` = '24' ,`ListPrice` = '2695000.00' ,`Status` = 'Active' ,`StreetName` = 'Doliver' ,`StreetNumber` = '6127' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5824' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exceptional interior finishes & architectural accents in this beautiful home located on the North side of Briargrove. Unique wood floors are wide plank French oak. Entry foyer designed chevron pattern. Formal living & dining rooms with plaster walls, ceilings&living has custom hand painted strie walls. Bar area has custom reclaimed panel doors for silver storage. Custom limestone fireplaces in the living & family rooms. 2-Powder rooms dwn,1 formal w/ PhilipJeffries wallpaper, also used in her office.Gourmet kitchen, soapstone counters & storage doors for appliances. Mudroom w/kids lockers, dog kennel. Custom wool runners on both stairs& upstairs hallway.All bedrooms ensuite baths, gamerm w/ full bath. Primary bedroom w/foyer entry,& his office, & bedroom w/custom painted wood ceiling, reclaimed wood panel door to media Spa like primary bath w/marble counters,honed marble floors. Lg outdoor patio w/fireplace,tv, s.s.grill. L.Scape lighting, putting green, security cam..Epoxy flr garage' ,`Acres` = '0.2158' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Briargrove' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 599 BLK 29 BRIARGROVE SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9401' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1210' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briargrove Sec 08' ,`TaxAmount` = '52223' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664114001' WHERE `Matrix_Unique_ID` = '212830322' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T07:28:28.707' ,`MLSNumber` = '6033881' ,`ListAgentFullName` = 'Ronald Co' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.694935' ,`Longitude` = '-95.706273' ,`PhotoCount` = '44' ,`PostalCode` = '77407' ,`RoomCount` = '8' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Highland Chase' ,`StreetNumber` = '7507' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Look no further, this cozy 1-story home has everything you\'re looking for! Front-door facing Northwest walking distance to the community lakes. Built in 2020, it is gently lived in with 4 bedrooms, 2 bathrooms, and a large covered patio. One of DR Horton\'s most popular floor plans with high ceilings and an open concept combined kitchen, dining room, and living room. As you enter, you\'re greeted with light gray tiles extending throughout the common areas. The kitchen has premium cabinetry, granite countertops, 2 globe chandeliers, and a walk-in pantry with built-in shelves. The spacious dining room & living room is great for entertaining guests with direct access to the large covered patio. The primary bedroom is very roomy with a large bathroom and walk-in closet. Move-in ready with blinds, water softener, and water purification system. Conveniently located off Westpark Tollway for direct access to Galleria/Downtown and near Grand Parkway 99 for easy access to Cypress/Katy/Sugar Land.' ,`Acres` = '0.1318' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKEVIEW RETREAT SEC 4, BLOCK 4, LOT 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5742' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeview Retreat Sec 4' ,`TaxAmount` = '7519' ,`TaxRate` = '3.0697' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664114001' WHERE `Matrix_Unique_ID` = '212847552' --> 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','212867364','1664114001','212867364','2022-09-25T07:57:26.613','91821371','Kyle Koerner','The Koerner Team Realty LLc','','','29.613614','-95.242055','33','77075','9','228375.00','Active','Sumerlin','9801','Street','Houston','2','0','3','1410','Single-Family','Darling 3 bedroom 2 bath home. Well maintained corner lot with beautiful Magnolia tree. Move in ready. New carpet in the bedrooms and hall. New paint throughout. Large covered back patio for entertaining and grilling. Back yard is cross fenced for the safety of your pets and guests. Great location!!! Close to I 45, Beltway 8, Hobby Airport, Memorial Herman Hospital, easy commute to downtown and all feeder schools are in close proximity. It is also close to Almeda and Baybrook malls, and many restaurants. Home has never flooded. No HOA/POA.','0.2016','3','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Southbelt/Ellington','Central Gas','0','LT 35 BLK 5 EASTRIDGE TERRACE','Corner','8780','Appraisal District','','','0','','0','Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','41 - Pasadena','ATKINSON ELEMENTARY SCHOOL','DOBIE HIGH SCHOOL','BEVERLYHILLS INTERMEDIATE SCHOOL','Accompany,Lockbox Front,Vacant/Unoccupied','Seller','1','Ranch','Eastridge Terrace','3692','2.6863','Public Sewer,Public Water','1958','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T07:31:40.090' ,`MLSNumber` = '57064715' ,`ListAgentFullName` = 'Kimberly Orbison' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813643' ,`Longitude` = '-94.996817' ,`PhotoCount` = '43' ,`PostalCode` = '77521' ,`RoomCount` = '11' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Bearberry' ,`StreetNumber` = '4223' ,`StreetSuffix` = 'Avenue' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED! LOW TAX RATE! ONE YEAR HOME WARRANTY! OVER QUARTER ACRE LOT! This 2 Story 4 Bedroom 3.5 Bath home sits on over a quarter acre lot, no back neighbors, perfect for a pool, already has She Shed or Workshop what ever you choose equipped with electric, and the home is located in a cul-de-sac. Some of its features are granite countertops in the kitchen and primary bathroom, soaking tub, with separate shower, walk in closet, designer cabinets, gas fireplace, crown molding, private utility room, 2nd floor bonus room with a private balcony, and a private covered 18x7 patio in the oversized backyard. This is a must see!! The kitchen is an open concept with a breakfast bar/eat in kitchen with pantry, and a Formal Dining Room for entertainment or the holidays. Refrigerator is included!' ,`Acres` = '0.2722' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 BAY RIVER COLONY SEC 10' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '11858' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay River Colony Sec 10' ,`TaxAmount` = '7382' ,`TaxRate` = '2.705' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664114001' WHERE `Matrix_Unique_ID` = '212872098' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T07:47:43.150' ,`MLSNumber` = '5331759' ,`ListAgentFullName` = 'Vanessa Sanchez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.839440' ,`Longitude` = '-95.277392' ,`PhotoCount` = '12' ,`PostalCode` = '77028' ,`RoomCount` = '3' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Knoll' ,`StreetNumber` = '8166' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this charming cottage style home. This beauty features 3 spacious bedrooms with 1.5 baths. House has been completely renovated. New AC system, roof, double pane windows and more. Tile flooring throughout the house with neutral paint. Huge backyard is perfect for relaxing or entertaining. Great location with multiple access to freeways. Close to downtown entertainment and activities. Washer, dryer and refrigerator included. Welcome home!' ,`Acres` = '0.1612' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 240 BLK 11 CLAIRMONT PLACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HILLIARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clairmont Place Sec 01' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1946' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664114001' WHERE `Matrix_Unique_ID` = '212920029' --> 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','212937920','1664114002','212937920','2022-09-25T07:30:51.267','32539381','Kevin King','RE/MAX ONE - Premier','','','29.819356','-95.071064','34','77562','9','275000.00','Active','Hampton','307','Court','Highlands','2','0','4','2147','Single-Family','Looking for a move-in ready 4 bedroom in an established neighborhood? Look no further because this is the home for you.','0.1584','2','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Baytown/Harris County','Central Gas','1','LT 2 BLK 4 HIGHLAND WOODS SEC 2','Subdivision Lot','6900','Appraisal District','','212','0','','2','Gas Oven','0','','','Gas Range','','Composition','23 - Goose Creek Consolidated','HOPPER/HIGHLANDS ELEMENTARY SCHOOL','GOOSE CREEK MEMORIAL','HIGHLANDS JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Highland Woods Sec 02','4995','2.575','Public Sewer,Water District','1997','Appraisal District'); --> New record created successfully