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-11-27T21:33:47.807' ,`MLSNumber` = '55965602' ,`ListAgentFullName` = 'Carolyn Bowen' ,`ListOfficeName` = 'Texas Home Team, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072187' ,`Longitude` = '-94.800743' ,`PhotoCount` = '30' ,`PostalCode` = '77575' ,`RoomCount` = '5' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Holly' ,`StreetNumber` = '1520' ,`StreetSuffix` = 'Street' ,`City` = 'Liberty' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1443' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Old Southern Liberty feels like Charleston or Savannah! Canopy of HUGE Oaks, corner lot with room to enlarge. Make the attached garage into master suite and build a dream garage. Plenty room and frontage for that. Newly remodeled and updated with granite countertops, new appliances and updated plumbing. Quiet neighborhood with no neighbors across the street...well maybe a deer now and then. Near schools and old downtown with so many possibilities. Bedrooms are huge. Comfortable home with room to grow. NEVER FLOODED! ORIGINAL OWNERS FAMILY STILL OWNS HOUSE SO THEY KNOW IT DID NOT FLOOD. Price dropped to rock bottom \"as is\" price.' ,`Acres` = '0.303' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Liberty' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LIBERTY OUTER BLOCKS, BLOCK 2, LOT PT 2 TR 28, 30, ACRES .30' ,`LotDesciption` = 'Corner' ,`LotSize` = '13199' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '73 - Liberty' ,`SchoolElementary` = 'LIBERTY ELEMENTARY SCHOOL (LIBERTY)' ,`SchoolHigh` = 'LIBERTY HIGH SCHOOL (LIBERTY)' ,`SchoolMiddle` = 'LIBERTY MIDDLE SCHOOL (LIBERTY)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Liberty Outer Blocks' ,`TaxAmount` = '4060' ,`TaxRate` = '2.6826' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652365' WHERE `Matrix_Unique_ID` = '206700564' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T22:45:47.837' ,`MLSNumber` = '29374494' ,`ListAgentFullName` = 'Jessica Gunn' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.791296' ,`Longitude` = '-95.524392' ,`PhotoCount` = '22' ,`PostalCode` = '77055' ,`RoomCount` = '8' ,`ListPrice` = '389900.00' ,`Status` = 'Active' ,`StreetName` = 'Cedarpost Square Street' ,`StreetNumber` = '9515' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2339' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite wood flooring, granite countertops in kitchen, stainless steel appliances, separate wet bar with wine refrigerator, and separate media section! This home has the option to transfer furnishings as well as a refrigerator, washer, and dryer. The primary bathroom features a walk-in shower with a separate garden tub and is connected to an extra-large bedroom. Privacy, elegance, and low maintenance are what you can expect with this home! Only minutes away from Energy Corridor & City Centre in a gated community. This home also has a grant program available for buyers that qualify.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Blk 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '2016' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2304' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WOODVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cedarpost Square' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652365' WHERE `Matrix_Unique_ID` = '210322126' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T22:33:06.190' ,`MLSNumber` = '89591498' ,`ListAgentFullName` = 'Andrea Cooksey' ,`ListOfficeName` = 'Exit Realty 360' ,`SellingAgentFullName` = 'Kayin Lawrence' ,`SellingOfficeName` = 'Exit Realty 360' ,`Latitude` = '29.773980' ,`Longitude` = '-95.406977' ,`PhotoCount` = '32' ,`PostalCode` = '77007' ,`RoomCount` = '10' ,`ListPrice` = '435900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Maxie' ,`StreetNumber` = '4517' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1317' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on market A Listing with options prime location minutes from Downtown sport venues, Memorial Park Houston Galleria, Local neighborhood restaurants, sprawling new development all around. This cute historical cottage 2 plus a study or 3 bedroom 2 full baths updated kitchen, hardwood floors and a great back yard. Or it is your perfect development spot to create your own new paradise in a prime location. Room dimensions are approx. Owner finally decided to sell so hurray location location location one of the few last full home sites in the area.' ,`Acres` = '0.1171' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 8 & 9 BLK 84 BRUNNER' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brunner' ,`TaxAmount` = '6654' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1925' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652365' WHERE `Matrix_Unique_ID` = '210608427' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T21:29:34.390' ,`MLSNumber` = '64258158' ,`ListAgentFullName` = 'Clarissa Castleberry' ,`ListOfficeName` = 'Surge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.789151' ,`Longitude` = '-95.407170' ,`PhotoCount` = '27' ,`PostalCode` = '77008' ,`RoomCount` = '3' ,`ListPrice` = '1174000.00' ,`Status` = 'Active' ,`StreetName` = 'Lawrence' ,`StreetNumber` = '1009' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2824' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 1009 Lawrence; a thoughtfully designed 2-story home with a detached 2 car garage, on a large 6k lot in the heights! As you enter this craftsman style home you are greeted by the formal dining area and the office. The heart of the home boasts a large, open, airy kitchen with a butlers pantry, a walk-in pantry, and plenty of cabinetry. The family room features high ceiling, an electric fireplace, and a nice view of your backyard. A 2nd living area awaits at the top of the 2nd floor. The private primary suite has lots of windows, a large en suite bath, and a spacious walk-in closet that leads to the Utility room. Customization of the interior of this home is still available! Make this home yours today! Built by Forthright Construction- End of December 2022 completion!*SELLER CAN CONTRIBUTE TO LOWER RATE*' ,`Acres` = '0.1377' ,`Area` = '9' ,`BuilderName` = 'Forthright Constr.' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 7 WEST HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'West Heights' ,`TaxAmount` = '9433' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669652365' WHERE `Matrix_Unique_ID` = '211144226' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T21:40:59.057' ,`MLSNumber` = '27487886' ,`ListAgentFullName` = 'Lori Tribe' ,`ListOfficeName` = 'Fairwater Westmont Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.440740' ,`Longitude` = '-95.615015' ,`PhotoCount` = '40' ,`PostalCode` = '77356' ,`RoomCount` = '13' ,`ListPrice` = '579000.00' ,`Status` = 'Active' ,`StreetName` = 'Clear Water St West' ,`StreetNumber` = '132' ,`StreetSuffix` = 'Street' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2496' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REDUCED PRICE - Your Piece of Lake Conroe Paradise has arrived! MOVE IN READY! Same family has owned this home from original construction, they say it\'s time! This home has a WATERFRONT WALL OF WINDOWS on both upper and lower levels bring in an ABUNDANCE OF NATURAL LIGHT. This OPEN CONCEPT HOME boasts not only of 3 bdrm/3 bath but an amazing lower level \"FLEX ROOM\" includes full bathroom and spacious storage closet- this is a GREAT SPACE FOR ENTERTAINING, etc. Enter \"Flex room\" from OVER-SIZED GARAGE or backyard stairs and use the INDOOR STAIRCASE ACCESS to the \"living\" area of the home, or use the outside stairway to the upper level deck and entry through the front door or additional staircase to the flex room. Property has bulk-heading with plenty of yard space to create your own custom patio deck, fishing pier,boat slip. Community has private boat ramp,& LOW HOA FEES. Come on out and LET YOUR WATERFRONT DREAM BECOME A REALITY!' ,`Acres` = '0.1208' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CLEAR WATER COVE, BLOCK 2, LOT 18' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '5263' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Water Cove' ,`TaxAmount` = '6450' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652365' WHERE `Matrix_Unique_ID` = '211334462' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T21:43:29.153' ,`MLSNumber` = '60282742' ,`ListAgentFullName` = 'Gina Jaeschke' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.006942' ,`Longitude` = '-95.758306' ,`PhotoCount` = '15' ,`PostalCode` = '77433' ,`RoomCount` = '14' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Thistle' ,`StreetNumber` = '15106' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2692' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss out on this rare one story, four bedroom, three bath home, with three car tandem garage! The home offers an easy flowing floor plan with open kitchen, big island & counter height bar that opens up to an inviting living room which is great for gathering your friends & family! The kitchen was renovated in 2019 with white painted cabinets & white quartz countertops, giving the home a modern-sleek look! When you walk into the backyard, you\'ll enjoy the oversized covered patio with fans for your outdoor entertaining! This lovely home is located in close proximity to Salyards Junior High in Fairfield! This master planned community has many miles of walking trails & sidewalks to get to the the rec center with tennis courts, baseball fields, pools, ponds, lakes and parks.\r\nThis one won\'t last long!' ,`Acres` = '0.1941' ,`Area` = '35' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 FAIRFIELD VILLAGE SOUTH SEC 4' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8456' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SWENKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Fairfield Village South Sec 04' ,`TaxAmount` = '8592' ,`TaxRate` = '2.746' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652366' WHERE `Matrix_Unique_ID` = '211412635' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T21:18:22.630' ,`MLSNumber` = '26854511' ,`ListAgentFullName` = 'Barrie Jones' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.703523' ,`Longitude` = '-95.343497' ,`PhotoCount` = '6' ,`PostalCode` = '77021' ,`RoomCount` = '9' ,`ListPrice` = '160000.00' ,`Status` = 'Active' ,`StreetName` = 'Marietta' ,`StreetNumber` = '4719' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1464' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very nice home near Macgregor Park, Univ of Houston and TSU Quite neighborhood' ,`Acres` = '0.1636' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 49 BLK 91 RIVERSIDE TERRACE SEC 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverside Terrace Sec 22' ,`TaxAmount` = '3406' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652366' WHERE `Matrix_Unique_ID` = '212346023' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T21:49:07.743' ,`MLSNumber` = '90768914' ,`ListAgentFullName` = 'Jay Schulz' ,`ListOfficeName` = 'Zarco Properties, LLC' ,`SellingAgentFullName` = 'Lorena Cousin' ,`SellingOfficeName` = 'Surge Realty' ,`Latitude` = '30.193032' ,`Longitude` = '-95.574897' ,`PhotoCount` = '50' ,`PostalCode` = '77382' ,`RoomCount` = '11' ,`ListPrice` = '1490000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Ambassador' ,`StreetNumber` = '11' ,`StreetSuffix` = 'Bend' ,`City` = 'The Woodlands' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5316' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Magnificent George Weaver custom home nestled on a cul-de-sac in Sterling Ridge! Grand foyer, extensive Travertine floors, soaring ceilings, stunning trim work, recently remodeled laundry room and primary closet expansion. Island kitchen w/granite counters, Viking appliances & walk-in pantry opens to breakfast & den w/beam ceiling & fireplace; wine room; formal dining; study w/wood floors & fireplace; master retreat w/his & her closets + 2nd bedroom down; 3 large bedrooms, huge media/gameroom w/wet bar up; fenced yard w/covered patio, summer kitchen & chlorine pool! 2022 outdoor kitchen upgrade with quarts countertops, grill, sink, refrigerator, stone mantle, and a custom bar sitting area.' ,`Acres` = '0.37' ,`Area` = '15' ,`BuilderName` = 'George Weaver' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'S969933 - WDLNDS VIL STERLING RIDGE 33, BLOCK 1, LOT 40' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community' ,`LotSize` = '16026' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'DERETCHIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodlands Village Sterling Ridge' ,`TaxAmount` = '24029' ,`TaxRate` = '2.1816' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652366' WHERE `Matrix_Unique_ID` = '212725154' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T22:42:31.797' ,`MLSNumber` = '23124389' ,`ListAgentFullName` = 'Jessica Salinas' ,`ListOfficeName` = 'RE/MAX ONE - Premier' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.080256' ,`Longitude` = '-95.479804' ,`PhotoCount` = '26' ,`PostalCode` = '77388' ,`RoomCount` = '10' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Morgan Park' ,`StreetNumber` = '21715' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2384' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully landscaped two-story home offers 4 Bedrooms, 3.5 Baths & 2 car garage. This meticulously kept home welcomes you with a two-story entry, upgraded tile opening up to a formal/dining room/office/flex room with beautiful new hardwood like LVT flooring. Kitchen boasts an oversized bar area, 42” maple cabinets, tile backsplash, granite counters, black appliances & gas range. Gather together with family & friends in the breakfast area leading into the open concept family room. Relax in the primary bedroom & escape in the En Suite that includes a luxurious garden tub, separate shower, double vanity & spacious closet. Enjoy three other expansive bedrooms & game room upstairs with two additional full bathrooms. Fresh neutral paint, new hardwood like LVT flooring, new carpet, & prewired security system. Tons of storage, three large storage areas in the attic, & under the stairs. Low traffic street & a spacious backyard. Location-min. from Exxon, 99, & The Woodlands. Klein ISD Schools!' ,`Acres` = '0.1218' ,`Area` = '14' ,`BuilderName` = 'KHOV' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 PARK AT MEADOWHILL RUN SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5307' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '338' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'ZWINK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Park/Meadowhill Run Sec 4' ,`TaxAmount` = '6309' ,`TaxRate` = '2.804' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652366' WHERE `Matrix_Unique_ID` = '213273915' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T21:51:12.883' ,`MLSNumber` = '18611550' ,`ListAgentFullName` = 'Maria Rios' ,`ListOfficeName` = 'Cavazos Realty International' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.441620' ,`Longitude` = '-95.086090' ,`PhotoCount` = '17' ,`PostalCode` = '77539' ,`RoomCount` = '4' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Rau Drive' ,`StreetNumber` = '3805' ,`StreetSuffix` = 'Drive' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2015' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome HOME! NO HOA! You must see this gorgeous 4 bedroom, 2-and-a-half-bathroom home with fast and easy access to FM 517 and I-45. The primary bedroom is on the first floor along with a guest bedroom and half bath. There are two additional bedrooms upstairs that share a jack and jill bathroom. This home features a spacious living room with a fireplace and open to the beautifully updated kitchen with stainless steel appliances, granite countertops and new cabinets. It also has a very spacious dining room ready for you to host holiday gatherings. And we can\'t forget about the oversized backyard also ready for your family cookouts! Call to schedule your private showing.' ,`Acres` = '0.3587' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 19 PERRY & AUSTIN SUR S 75 FT OF LOT 13 & N 1/2 OF LOT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Bayou Crest 2' ,`TaxAmount` = '6346' ,`TaxRate` = '2.5214' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652367' WHERE `Matrix_Unique_ID` = '213650767' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T22:18:14.220' ,`MLSNumber` = '96505899' ,`ListAgentFullName` = 'Jordan Schilleci' ,`ListOfficeName` = 'Jo & Co. Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.362053' ,`Longitude` = '-95.387825' ,`PhotoCount` = '23' ,`PostalCode` = '77303' ,`RoomCount` = '11' ,`ListPrice` = '428546.00' ,`Status` = 'Active' ,`StreetName` = 'Hazel Lake Drive' ,`StreetNumber` = '6134' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2431' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE IN READY! You have just found your dream home. This two-story, 5 bedroom, 3 bathroom home sits on almost half an acre while backing up to a small lake reserve with breathtaking views in the new community of Deer Trail Estates. This new construction home was built by Alta Homes with designer upgrades which include granite countertops and shaker-style kitchen cabinets. On the first floor of this home, you will the primary bedroom with ensuite bathroom, a study (or first-floor flex-space), a mother-in-law suite (additional full bedroom and bathroom) a formal dining room, a breakfast room, an over-sized kitchen, and a wood-burning fireplace. 2nd floor: an enclosed game room and two bedrooms + bathroom. With soaring ceilings up to 17 feet high, this is a luxurious home with plenty of room to grow! This home is ready for move-in ready! The builder is currently offering $5000 for you to use how you like. LOW TAXES! Call or stop by today!' ,`Acres` = '0.41' ,`Area` = '19' ,`BuilderName` = 'Alta Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15 Blk 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Water View,Waterfront,Wooded' ,`LotSize` = '16500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Craftsman,Traditional' ,`Subdivision` = 'Deer Trail Estates' ,`TaxAmount` = '' ,`TaxRate` = '1.91' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669652367' WHERE `Matrix_Unique_ID` = '214197496' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T21:30:19.083' ,`MLSNumber` = '43734241' ,`ListAgentFullName` = 'Yvonne Pruneda' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = 'Kayla Scarbrough' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.673724' ,`Longitude` = '-95.191366' ,`PhotoCount` = '46' ,`PostalCode` = '77502' ,`RoomCount` = '8' ,`ListPrice` = '225990.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Dewberry' ,`StreetNumber` = '2518' ,`StreetSuffix` = 'Lane' ,`City` = 'Pasadena' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1354' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 2518 Dewberry. This impeccable newly renovated 3-bedroom, 1.5-bath home boasts an array of sleek finishes throughout and is a paradigm of modern suburban living. This 1,350SF home offers a living room w/high ceiling, and kitchen/dining combo. Features of this home include laminate flooring throughout main living area, kitchen and hallway, carpeted bedrooms, a light and bright kitchen equipped with granite countertops, modern backsplash, and a suite of appliances. Enjoy the outdoors w/covered patio, and fully fenced Backyard perfect for Kids & Pets. See attached list of improvements.' ,`Acres` = '0.1519' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 8 PARK VIEW MANOR SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6615' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'FISHER ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'PARKVIEW INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park View Manor Sec 01' ,`TaxAmount` = '3730' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652367' WHERE `Matrix_Unique_ID` = '214258384' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T21:31:52.947' ,`MLSNumber` = '5913255' ,`ListAgentFullName` = 'Debra Spurr' ,`ListOfficeName` = 'Grace Team Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.510994' ,`Longitude` = '-95.199742' ,`PhotoCount` = '49' ,`PostalCode` = '77546' ,`RoomCount` = '12' ,`ListPrice` = '684900.00' ,`Status` = 'Active' ,`StreetName` = 'Briarmeadow' ,`StreetNumber` = '712' ,`StreetSuffix` = 'Avenue' ,`City` = 'Friendswood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2919' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous property has it all!! Spacious home has 4 bedrooms, 2.5 baths in main house, beautifully updated kitchen and primary bath, and sets on almost an acre of greenspace. The kitchen comes equipped with top of the line GE Monogram Professional appliances, duel fuel range, center prep island, beautiful granite counter tops, and lots of cabinet space. Refrigerator stays. Just off of the main house is a flex space that includes a mini kitchen and another full bath. This space has its own cooling system and hot water heater. Endless possibilities could be used for this flex area, ie. guest quarters, mother-in-law suite, or game room. The backyard is an entertainer\'s paradise, with lush trees and lovely pool and deck. For the handyman, there\'s a 33X23 workshop with 100 amp electrical service, at the very back of the property. This home has too many amenities to mention; it is definitely a must see.' ,`Acres` = '0.811' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 151 S MCKISSICK SUR LOT 2 ELLIOTT SUB NO 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '35327' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elliott 1' ,`TaxAmount` = '8340' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652367' WHERE `Matrix_Unique_ID` = '214288005' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T21:20:05.820' ,`MLSNumber` = '13709848' ,`ListAgentFullName` = 'Barrie Jones' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.623802' ,`Longitude` = '-95.435697' ,`PhotoCount` = '6' ,`PostalCode` = '77045' ,`RoomCount` = '7' ,`ListPrice` = '169900.00' ,`Status` = 'Active' ,`StreetName` = 'Darlinghurst Dr' ,`StreetNumber` = '3907' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice 4 bedroom home located near NRG, Downtown and U of H area, with large backyard Also close to schools and parks and shopping .' ,`Acres` = '' ,`Area` = '18' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'E 45 Ft of Lt 10 & W 15 Ft of Lt 11 Blk 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'South Glen' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652367' WHERE `Matrix_Unique_ID` = '214289984' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T21:22:29.600' ,`MLSNumber` = '12761800' ,`ListAgentFullName` = 'Courtney Okanlomo' ,`ListOfficeName` = 'Collective Realty Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.739339' ,`Longitude` = '-95.405229' ,`PhotoCount` = '45' ,`PostalCode` = '77098' ,`RoomCount` = '12' ,`ListPrice` = '1994500.00' ,`Status` = 'Active' ,`StreetName` = 'Marshall' ,`StreetNumber` = '1815' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4678' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME TO ANOTHER HAMPTON LANE BUILDERS,100% COMPLETE,ELEVATOR CAPABLE,WINLOW RESIDENCE.LUXE FORMAL DINING RM & PRIVATE STUDY.CUSTOM STAINED HICKORY,HRDWD FLOORING,11FT CEILINGS,DESIGNER COLOR PALETTE,CUSTOM LIGHT FIXTURES & RECESSED LIGHTING ENVELOPE THE HOME.GOURMET KITCHEN W/WOLF & SUB-ZERO APPLIANCES,GRANITE COUNTERTOPS,2-TONE CABINETRY,EXPOSED FAUXWOOD BEAMS,DOUBLE OVEN,&GREAT RM W/FIREPLACE & BUILT-INS.THE DRY BAR OFFERS SLEEK STORAGE,45-BOTTLE WINE COOLER,& STEPS AWAY FROM THE OUTDOOR KITCHEN W/PAVER FLOORING,DEEP SINK & GAS GRILL.2ND FLR GAMEROOM & LOFT AREA.MASSIVE PRIMARY BDRM,COLOSSAL CUSTOM CLOSET W/PACKING ISLAND&MARBLE COUNTERTOPS;SPA-INSPIRED BTH W/DUAL VANITY,RAIN SHOWER & FREE-STANDING TUB.WALK-IN CLOSETS IN ALL BDRMS.LUSH LANDSCAPE W/SPRINKLER SYSTEM,FULL GUTTERS & CEDAR FENCE.4-ZONE HEATING & AIR;2 WATER HEATERS,2 FIREPLACES.PRE-WIRED FOR SURROUND SOUND.HIGHLY RATED SCHOOLS,MINUTES AWAY FROM RICE U., MUSEUM DISTRICT, MED CTR & DOWNTOWN; SCHEDULE YOUR PRIVATE TOUR!' ,`Acres` = '0.144' ,`Area` = '16' ,`BuilderName` = 'Hampton Lane Bldrs' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 13 WINLOW PLACE' ,`LotDesciption` = 'Other' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Winlow Place' ,`TaxAmount` = '12791' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669652368' WHERE `Matrix_Unique_ID` = '214323425' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T22:57:14.420' ,`MLSNumber` = '8814142' ,`ListAgentFullName` = 'Setha Ponce' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.718760' ,`Longitude` = '-95.067008' ,`PhotoCount` = '31' ,`PostalCode` = '77351' ,`RoomCount` = '8' ,`ListPrice` = '139500.00' ,`Status` = 'Active' ,`StreetName` = 'Quailcrest' ,`StreetNumber` = '258' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2240' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4/2 home situated in quiet, country, neighborhood just minutes from lake livingston. Space isn\'t an issue here, inside or out! The large kitchen is open to the dining room, features an island and plenty of cabinetry. Home is 4 years old and over 2200 sq ft with both back and front porches. Property is fully fenced and ready for all your babies, fur or human. Come out and experience country living at its finest!' ,`Acres` = '0.1732' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE LIVINGSTON VILLAGE LOT 343 & 344 SERIAL# ALS21971A' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7544' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Lake Livingston Village Sectio' ,`TaxAmount` = '2212' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652368' WHERE `Matrix_Unique_ID` = '214397418' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T21:25:20.480' ,`MLSNumber` = '89716455' ,`ListAgentFullName` = 'Triska Sparks' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819520' ,`Longitude` = '-94.995548' ,`PhotoCount` = '22' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Amaryllis' ,`StreetNumber` = '4306' ,`StreetSuffix` = 'Avenue' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1325' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for the Perfect Starter Home? Look no Further. This beautiful 4 Bedroom 2 Full baths and 2 car attached garage sets conveniently Near Garth Rd. between Baytown and Highlands. NEVER FLOODED! Located in the wonderful neighborhood of Bay River Colony with 2 parks and walking paths through out perfect for kids to! Rooms are approximate.' ,`Acres` = '0.1278' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 181 BAY RIVER COLONY SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5568' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay River Colony Sec 01' ,`TaxAmount` = '4064' ,`TaxRate` = '2.705' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652368' WHERE `Matrix_Unique_ID` = '214464426' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T21:51:10.170' ,`MLSNumber` = '92476457' ,`ListAgentFullName` = 'Joshua Haynie' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.195806' ,`Longitude` = '-95.266942' ,`PhotoCount` = '49' ,`PostalCode` = '77357' ,`RoomCount` = '6' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Woods' ,`StreetNumber` = '17416' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1782' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning property is where you can plant your roots & let that imagination run wild! This 6 acre property offers two main dwellings, one being a 1,782 sq ft. Two story 4 bedroom 2 full bathroom main home & a secondary 1,064 sq ft. 3 bedroom 2 bathroom home. But if that\'s not enough, how about a Gorgeous 2,800 sq ft. Barn/Garage built in 2020, that\'s ready for your dream build-out! This property also offers a totally separate workshop, multiple carports, and the cherry on top, which is the picturesque pond for the backdrop of all your get togethers or your quiet enjoyment!' ,`Acres` = '5.9409' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S750350 - OAK GROVE SOUTH RANCHETTES, LOT 17 AKA-PICKERING R' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '258786' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'MILAM ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Grove South Ranchettes' ,`TaxAmount` = '1918' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652368' WHERE `Matrix_Unique_ID` = '214492370' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T22:21:21.540' ,`MLSNumber` = '49564632' ,`ListAgentFullName` = 'Steve Anton' ,`ListOfficeName` = 'Hallmark Properties, Inc.' ,`SellingAgentFullName` = 'Rattanawadee Duangjai' ,`SellingOfficeName` = 'NB Elite Realty' ,`Latitude` = '29.667540' ,`Longitude` = '-95.433770' ,`PhotoCount` = '24' ,`PostalCode` = '77025' ,`RoomCount` = '9' ,`ListPrice` = '329000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Clearview' ,`StreetNumber` = '3444' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Bargain price for a bright, clean and spotlessly maintained Med Center home featuring a roomy floorplan that\'s ideal for entertaining or a busy family. Desirable end unit with extra parking and adjacent green space for pets and playing. Formal dining plus formal living or study/home office, spacious family room with wall of windows and nice flow to granite kitchen with breakfast bar, gas range and pantry, and large adjacent laundry room with lots of storage. Shining wood floors through 1st floor. Roomy master w/large walk-in, sunny bath with deep tub & separate shower. Lots of storage throughouth including large space under the staircase. Covered walk to 2-car garage. Simple, easy-to-keep yard. Refrigerator, washer & dryer can stay. Ready to close before the holidays. Call us today to see this great home.' ,`Acres` = '0.0636' ,`Area` = '18' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 6 PARK AT CLEARVIEW AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2770' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1243' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHEARN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Park/Clearview' ,`TaxAmount` = '6350' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652369' WHERE `Matrix_Unique_ID` = '214555386' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T22:02:45.033' ,`MLSNumber` = '62255906' ,`ListAgentFullName` = 'Hoang Nguyen' ,`ListOfficeName` = 'Avignon Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.853530' ,`Longitude` = '-95.739630' ,`PhotoCount` = '13' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Greenwood Summit' ,`StreetNumber` = '5234' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1574' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1373' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 2 JASMINE HEIGHTS SEC 17' ,`LotDesciption` = 'Other' ,`LotSize` = '5980' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HEMMENWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Jasmine Hts Sec 17' ,`TaxAmount` = '881' ,`TaxRate` = '2.821' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652369' WHERE `Matrix_Unique_ID` = '214617467' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T22:46:27.037' ,`MLSNumber` = '84786808' ,`ListAgentFullName` = 'Maelia Davis' ,`ListOfficeName` = 'Re/Max Property Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.016064' ,`Longitude` = '-95.728789' ,`PhotoCount` = '45' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Hamilton Pool' ,`StreetNumber` = '16602' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3397' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Ryland built home comes with a wonderful floor plan that includes both formals, an open concept kitchen with granite counter tops, amazing cabinet storage, a breakfast area, and plenty of space for all your entertaining needs. Wood flooring downstairs in the main living areas, including the primary bedroom where you will find a bay window, a huge walk-in closet, along w/ double sinks in primary bath, jetted garden tub, and glass shower w/shower bench. Upstairs a large game room awaits with three additional bedrooms, full bath, and a great media room pre-wired for surround sound. Spacious backyard w/ sprinkler system in front and back. Home has a water filtration system, and a tankless water heater. No back neighbors and it\'s just down the street from beautiful walking trails around a lake. Call agent for info. Refrigerator, washer, and dryer included!' ,`Acres` = '0.2276' ,`Area` = '35' ,`BuilderName` = 'Ryland' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 3 FALLS AT DRY CREEK SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9916' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KEITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falls at Dry Creek Sec 1' ,`TaxAmount` = '13450' ,`TaxRate` = '3.5317' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669652369' WHERE `Matrix_Unique_ID` = '214639748' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T22:07:49.507' ,`MLSNumber` = '44218236' ,`ListAgentFullName` = 'Janice Poscovsky' ,`ListOfficeName` = 'Spouses Selling Houses' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.632690' ,`Longitude` = '-95.727512' ,`PhotoCount` = '50' ,`PostalCode` = '77406' ,`RoomCount` = '10' ,`ListPrice` = '498000.00' ,`Status` = 'Active' ,`StreetName` = 'Cooling Breeze' ,`StreetNumber` = '2530' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2852' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovingly cared for by the original owners, this home is beautiful on the inside and outside. Located on a corner lot that\'s just under 1/3 of an acre, with a backyard paradise, this Emerald built home has many upgrades. The primary bath was recently remodeled and includes a super shower and quartz counters. The downstairs flooring is engineered wood with the exception of the wet areas that are tiled. Great storage throughout, including a kitchen pantry that seems to go on forever. The kitchen was updated in 2010; roof replaced in 2017;HVAC in 2015 and the pool resurfaced in 2020.' ,`Acres` = '0.3013' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'PECAN GROVE PLANTATION SEC 22, BLOCK 2, LOT 1' ,`LotDesciption` = 'Corner,Wooded' ,`LotSize` = '13126' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '209' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PECAN GROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Grove Plantation' ,`TaxAmount` = '7556' ,`TaxRate` = '2.2979' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652369' WHERE `Matrix_Unique_ID` = '214668820' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T21:06:43.253' ,`MLSNumber` = '22489109' ,`ListAgentFullName` = 'Naheshae Davis' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.024934' ,`Longitude` = '-95.612018' ,`PhotoCount` = '37' ,`PostalCode` = '77377' ,`RoomCount` = '8' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Durango Point' ,`StreetNumber` = '17919' ,`StreetSuffix` = 'Court' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2628' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The phrase \"Welcome Home\" takes on new meaning in this gorgeous pool home w/exquisite indoor/outdoor living. From the covered front porch, step inside & notice the open floor plan streaming w/natural light & office off the foyer that is perfect for a work-from-home lifestyle. Enjoy hosting holiday dinners in the formal dining room & a fireplace in the living room grants a peaceful destination for everyday living & entertaining. Stunning white kitchen cabinets, granite island, pantry & SS appliances add inspiration & style for any chef. Whether looking for a place to take your morning coffee, savor a dip in your private pool, or grill w/built-in outdoor kitchen, the covered patio is a treat. There is a fenced dog run for your furry pal plus indoor doggie nook under the stairs. Look forward to retiring to the vaulted main floor primary & indulge in the spa-like bath w/walk-in closet, soaking tub, glass shower & double sinks. A full bath is central to the upstairs bedrooms & game room.' ,`Acres` = '0.1791' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 1 TREELINE NORTH' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1070' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'WILLOW CREEK ELEMENTARY SCHOOL (TOMBALL)' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Treeline North' ,`TaxAmount` = '9057' ,`TaxRate` = '2.7564' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652370' WHERE `Matrix_Unique_ID` = '214678357' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T22:02:55.813' ,`MLSNumber` = '94967821' ,`ListAgentFullName` = 'Jamie Hyde' ,`ListOfficeName` = 'Stoneburner & Associates ' ,`SellingAgentFullName` = 'Raul Garcia' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '30.006470' ,`Longitude` = '-95.656027' ,`PhotoCount` = '25' ,`PostalCode` = '77429' ,`RoomCount` = '5' ,`ListPrice` = '240000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Brock Creek' ,`StreetNumber` = '15402' ,`StreetSuffix` = 'Way' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1195' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 story single family residence with NO BACK NEIGHBORS! Kitchen/Dinning combo is open to the living room. The master bathroom has a large soaking garden tub and separate walk in shower. Home has been updated throughout with New Carpet Feb. 2021, New Paint Feb. 2021, New Stove, New Roof March 2022 and New A/C Sept. 2021. Home has easy access to 249, 2920, and 290. Don\'t forget to check out the green space and walking trails from the back yard access behind the home. Great first time home and is located in award winning Cy-Fair School District. Don\'t miss your opportunity.' ,`Acres` = '0.1205' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 2 FOREST CREEK FARMS' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '415' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BLACK ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Crk Farms' ,`TaxAmount` = '4937' ,`TaxRate` = '2.821' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652370' WHERE `Matrix_Unique_ID` = '214898852' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T22:40:04.677' ,`MLSNumber` = '95527624' ,`ListAgentFullName` = 'Roxana Santos' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = 'Laura Bello' ,`SellingOfficeName` = 'RE/MAX Northwest, REALTORS' ,`Latitude` = '29.738384' ,`Longitude` = '-95.251793' ,`PhotoCount` = '36' ,`PostalCode` = '77547' ,`RoomCount` = '3' ,`ListPrice` = '180000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sage' ,`StreetNumber` = '802' ,`StreetSuffix` = 'Drive' ,`City` = 'Galena Park' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1205' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice, Cozy Starter Home with 3 Bedrooms and 2 Baths. Home features Recent Kitchen Backsplash, Granite countertops with recently painted cabinets & New Appliances (Gas Stove, Microwave, & Refrigerator). Property also features Original Hardwood floors in living area, dining Room and all 3 Bedrooms. These Hardwood floors can be polished & burnished for a desired shiny finish. The Family Living Area is opened to the Dining Area. Both bathrooms have been remodeled with new tubs, toilets, and tile. Home also features Brand New Roof, and recent exterior paint. This is a perfect starter home or a nice home to downsize. Easy quick access to 610 & I-10, and Just Minutes away from Clinton Park & Galena Park.' ,`Acres` = '0.1623' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'N 22.56 FT OF LT 5 & S 32.84 FT OF LT 6 BLK 19 GALENA MANOR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7070' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'GALENA PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GALENA PARK HIGH SCHOOL' ,`SchoolMiddle` = 'GALENA PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Galena Manor' ,`TaxAmount` = '3544' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652370' WHERE `Matrix_Unique_ID` = '214903349' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T22:43:11.950' ,`MLSNumber` = '72146461' ,`ListAgentFullName` = 'Melissa Sumrall' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809913' ,`Longitude` = '-94.893661' ,`PhotoCount` = '31' ,`PostalCode` = '77523' ,`RoomCount` = '8' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Sugar Cane' ,`StreetNumber` = '8006' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1413' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW! Perfect size 3 bedroom 2 full bath home on a cul-de-sac lot. As you enter you will be greeted by a very spacious entryway which opens up to the large kitchen and living room, allowing for entertaining into the breakfast and living area. The primary bathroom has a beautiful new shower. The back yard has an amazing covered back patio and not one, but two good sized storage buildings to store all your tools and equipment. Make an appointment today - this house is priced to SELL QUICK!!!' ,`Acres` = '0.194' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 41 COUNTRY MEADOWS SEC 6' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8451' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '175' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Mdw Sec 06' ,`TaxAmount` = '5743' ,`TaxRate` = '2.8882' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652370' WHERE `Matrix_Unique_ID` = '214919653' --> 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','214937385','1669652371','214937385','2022-11-27T21:07:42.860','22900471','Kristin Tillman','Greenwood King Properties','','','29.707588','-95.438277','29','77005','12','1575000.00','Active','College','6703','Street','West University Place','3','1','4','3711','Single-Family','Relaxed charm comes to mind at 6703 East College.Tucked away on a non-thru West U street, this one owner home provides a versatile open floor plan, natural light & desirable outdoor spaces featuring a beautiful pool all on an over 8,000 sqft (HCAD) lot!With 4 bedrooms & a potential 5th, East College boasts a rare first flr primary suite w/patio access.Contiguous living & dining along w/a kitchen open to family room w/amazing views of the pool & entertaining space are appealing.A private study, half bath & utility complete the first floor. Hardwoods are featured throughout the home.The second floor opens to a generous game room w/ wet bar, built-ins, & a balcony overlooking the pool.Two secondary bedrooms share a Hollywood bath & the additional bedroom has a bath w/game room access.All bedrooms have spacious walk-in closets.Finally, there is a flexible space nearby for 5th bedroom/exercise/playroom.Recent updates include paint inside/out & refinished first floor hardwoods.All per Seller','0.1894','17','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','West University/Southside Area','Central Gas','0','LT 4 BLK 5 CUNNINGHAM TERRACE','Subdivision Lot','8250','Appraisal District','','','0','','2','Electric Oven,Single Oven','1','Gunite','','Gas Cooktop','','Composition','27 - Houston','WEST UNIVERSITY ELEMENTARY SCHOOL','LAMAR HIGH SCHOOL (HOUSTON)','PERSHING MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','2','Traditional','Cunningham Terrace','21385','2.0584','Public Sewer,Public Water','2002','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T21:24:35.787' ,`MLSNumber` = '15641297' ,`ListAgentFullName` = 'Sabrina Rodriguez' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.360768' ,`Longitude` = '-94.970956' ,`PhotoCount` = '16' ,`PostalCode` = '77568' ,`RoomCount` = '2' ,`ListPrice` = '110000.00' ,`Status` = 'Active' ,`StreetName` = 'Oleander' ,`StreetNumber` = '1828' ,`StreetSuffix` = 'Drive' ,`City` = 'La Marque' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '846' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this newly remodeled 1 bed 1 bath home with an attatched 1 car garage! Some of the updates include a NEW ROOF, NEW FLOORING AND CARPET THROUGHOUT, NEW HVAC, NEW SHEETROCK, NEW GRANITE COUNTERTOPS and many more updates! You are greeted with a long welcoming driveway & spacious front yard, perfect for entertaining! You are then welcomed by your beautiful living room & kitchen and you are going to love this spacious bedroom and closet along with your beautiful remodeled bathroom. PERFECT STARTER HOME OR INVESTMENT PROPERTY!' ,`Acres` = '0.2003' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 150 J D MOORE SUR PT OF LOT 1 (1-2) BLK 1 NORMAN & BOAT' ,`LotDesciption` = 'Other' ,`LotSize` = '8726' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Norman & Boatright' ,`TaxAmount` = '1788' ,`TaxRate` = '2.6428' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669652371' WHERE `Matrix_Unique_ID` = '214988324' --> 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','214990516','1669652371','214990516','2022-11-27T21:08:08.897','38276573','Annu Naik','Coldwell Banker Realty','','','29.759055','-95.782972','32','77494','9','375000.00','Active','Hackberry','23726','Drive','Katy','2','0','3','2218','Single-Family','Immaculate home in gated community. Quick access to Grand Parkway & I-10. Large study, elegant dining w/double crown molding, arched entryways. Spacious island kitchen, granite counters & stainless steel appliances, a very well updated home. Both bathrooms are completely redone. Inviting living room w/gas log fireplace, high ceilings & view of backyard, beautiful covered patio. Large master with additional sitting room. Master bath has whirlpool tub, separate huge updated shower, double sinks, huge walk-in closet. 5 ton A/C in 2016. This one is a must see home!','0.1875','36','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','1','Katy - Southwest','Central Gas','1','FALCON LANDING SEC 6, BLOCK 2, LOT 33','Subdivision Lot','8169','Appraisal District','','950','0','','2','','0','','','Gas Range','','Composition','30 - Katy','FIELDER ELEMENTARY SCHOOL','CINCO RANCH HIGH SCHOOL','CINCO RANCH JUNIOR HIGH SCHOOL','Appointment Required,Controlled Access,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Falcon Landing Sec 6','6972','2.3545','Water District','2001','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215014141','1669652371','215014141','2022-11-27T21:34:02.750','9709985','Daryl Charbula','Weichert,REALTORS-Murray Group','','','29.575835','-95.376675','29','77584','7','285000.00','Active','Peach Hollow','2830','Circle','Pearland','2','0','3','1832','Single-Family','Gorgeous Country Place 55+ home in the shade of a majestic oak nestled on a quiet street off the busy thoroughfares. Expansive chef’s kitchen with serving island, plentiful counter and cabinet space. Large breakfast area and walk in pantry. Finely appointed dining room opens to a large family room adorned with an inviting cozy fireplace. Nicely sized primary bedroom has an ensuite bath, soaking tub and separate shower. Generous amounts of closet space. Split floor plan for privacy with new flooring and paint. Enjoy morning coffee in an 18’ x 9’ sunroom overlooking the beautifully landscaped back yard. Fenced and gated back yard features a sizeable patio and room for a garden. Refrigerator, electric range & wash/dryer convey with the sale. Minutes from the golf course, tennis courts and pool. A short drive to major box stores, the medical center and downtown!','0.1515','5','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Pearland','Central Gas','1','COUNTRYPLACE SEC 1 (A0510 F B DRAKE) BLK 4 LOT 8','In Golf Course Community,Subdivision Lot','6600','Appraisal District','','198','0','','2','','0','','','Electric Range,Freestanding Range','','Composition','42 - Pearland','CHALLENGER ELEMENTARY SCHOOL','GLENDA DAWSON HIGH SCHOOL','BERRY MILLER JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Countryplace Sec 1','5760','2.5552','Public Sewer,Public Water','1988','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215043683','1669652371','215043683','2022-11-27T22:21:45.550','98892651','Oneyda Flores','Keller Williams Realty','','','30.849066','-95.195937','36','75862','5','210000.00','Active','Mud Cat','141','Drive','Trinity','1','1','2','1280','Single-Family','Prepare to fall in love! This property is stunning, well cared for, and ready for new owners! Fully furnished, with all appliances, including a gas range double oven with convection and air fryer settings. Central AC/Heat, Aerobic system, and tankless/on-demand water heater. This 2 bed/1.5 bath home has a gorgeous large kitchen with an epoxy kitchen island, butcher block countertops, a large farmhouse sink, and a big open space that connects to the family/dining area making it very inviting and multifunctional. It has a new 10x12 shed with electricity, sits on 2 lots, 1 min. drive to the lake and about 10 minutes to food and shopping. Pack your bags and get ready for lake living in this lake community subdivision offering a boat ramp, fishing pier, and playground. Drive up to your new home and enjoy the peace and quiet. What are you waiting for? Still not convinced? Come see it for yourself!','0.287','42','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Mock Fireplace','1','Lake Livingston Area','Central Electric','1','HAWG HEAVEN SECTION 2, LOT 306','Cleared,Other,Subdivision Lot,Wooded','12502','Appraisal District','','80','0','','0','Convection Oven,Double Oven,Gas Oven','0','','','Gas Cooktop,Gas Range','','Aluminum','59 - Groveton','GROVETON ELEMENTARY SCHOOL','GROVETON J H-H S','GROVETON J H-H S','Accompany,Appointment Required,Leave Business Card,Request Online Appointment','Appraisal District','1','Ranch','Hawg Heaven Sec 2','1681','1.5582','Aerobic','2021','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215049272','1669652371','215049272','2022-11-27T21:47:21.993','55586947','Darius Franklin','Texas Ally Real Estate Group,','','','29.993009','-95.175777','16','77346','7','269726.00','Active','Dawn Star','6726','Drive','Humble','2','0','3','1835','Single-Family','Upgraded and in a premium corner lot, this house is ready for immediate occupancy. In the newer section of Atascocita South. Close to a large variety of restaurants and shopping, and not far from 59 or the Beltway. Close to Lake Houston as well. Once the FM 1960 expansion has been completed, longer commuting times will be reduced even more. Some highlights: New flooring almost throughout the house, brand new stainless steel microwave, brand new granite counter top in the kitchen, LED lights everywhere, brand new carpet in the bedrooms and a jetted tub in the master bathroom. Take a look at the pictures...','0.1537','1','Pulte Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Atascocita South','Central Gas','1','LT 24 BLK 2 ATASCOCITA SOUTH SEC 6','Subdivision Lot','6696','Appraisal District','','433','0','','2','Gas Oven','0','','','Gas Range','','Composition','29 - Humble','TIMBERS ELEMENTARY SCHOOL','ATASCOCITA HIGH SCHOOL','ATASCOCITA MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front','Appraisal District','1','Contemporary/Modern','Atascocita South Sec 06','5238','2.2837','Water District','2003','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215078553','1669652371','215078553','2022-11-27T22:41:13.160','56437771','Melissa Sumrall','Keller Williams Elite','','','29.799073','-94.826259','36','77523','10','629000.00','Active','Tremont','5919','Drive','Baytown','3','1','4','2709','Single-Family','You\'ll fall in love with this beautiful Custom Built one story 4/3.5/3 home on a 1.35 Acre cul-de-sac lot, in the desirable Plantation on Cotton Bayou Subdivision! This one of a kind home is tastefully designed to accommodate everyone\'s needs! The interior features a very spacious primary suite with 2 walk-in closets, a gorgeous kitchen with custom cabinetry overlooking the living room, and very spacious spare bedrooms with a Jack&Jill bathroom. New paint and New carpet throughout the home, along with Custom Cabinetry. Create your favorite projects in the stand-alone workshop or in your oversized 3 car garage. The backyard will offer years of enjoyment for your family, you\'ll also enjoy the neighborhood boat ramp, pier, and park right down the street! Located in the highly sought-after Barbers Hill School District. This is the home you’ve been searching for - Lots to Love about this Home! Home has never flooded. 1.7058 Tax Rate!','1.35','53','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Estate,No Disclosures','1','Gaslog Fireplace','1','Chambers County West','Central Electric','1','LT 16 & 17 PLANTATION ON C B SEC 11','Cleared,Cul-De-Sac,Subdivision Lot','58806','Appraisal District','','250','0','','3','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Back,Vacant/Unoccupied','Appraisal District','1','Traditional','Plantation on Cotton Bayou','7977','1.7058','Public Water,Septic Tank','2003','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215085999','1669652371','215085999','2022-11-27T22:07:12.927','6931486','Debbie Richardson','Coldwell Banker Realty','','','29.526107','-95.381975','50','77578','13','694900.00','Active','Indigo','3902','Court','Manvel','4','1','5','4040','Single-Family','Outstanding J Patrick home boast of 5 large bedrooms, 4.5 baths, 3 car garage. Enjoy high ceilings with stacked windows in the family room with a view of your private inground pool & spa. Entertaining is easy under the covered patio and outdoor kitchen. A spacious game room and media room offers more family and friend time! A 2nd primary bedroom is located upstairs with on-suite and large closet. Neutral shades of gray and white on floors and walls feels fresh and airy. Warm up next to the gas log fireplace with stone surround. The bright white kitchen features glass subway tile and stylish gray counters. A beautiful foyer with a winding staircase greets you upon entering this amazing home. The primary bathroom is truly spa-like with a floating tub and walk thru shower! This culdesac location offers a gracious backyard with a professionally installed 1/2 court basketball court and enormous green area for pets, play, or plants! You\'ll fall in love with this beautiful home!','0.4575','5','J Patrick Homes','','Electric Dryer Connections,Washer Connections','','Corporate Listing,Mud,Sellers Disclosure,Special Addendum','1','Gas Connections,Gaslog Fireplace','1','Alvin North','Central Gas,Zoned','1','SEDONA LAKES SEC 3 (A0541 ACH&B)(A0469 MV O\'DONNELL) BLK 1 L','Cul-De-Sac,Subdivision Lot','19929','Appraisal District','','900','0','','3','Double Oven,Electric Oven','1','Gunite,In Ground','','Gas Cooktop','','Composition','3 - Alvin','POMONA ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','MANVEL JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Sedona Lakes','18677','3.4494','Public Sewer,Public Water,Water District','2017','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215090443','1669652371','215090443','2022-11-27T21:14:50.570','91119655','Maria Lule','Go Real Estate','Maria Lule','Go Real Estate','29.166690','-96.286071','20','77437','3','310000.00','Option Pending','Whitewing','303','Trail','El Campo','2','1','3','1621','Single-Family','Don’t miss out on this marvelous brick home it sits on a cleared, 1 acre lot in a quiet neighborhood, and is ready for your family to move in! It has recently been updated with new paint, flooring, blinds, and light fixtures throughout the home.','1','55','','','','','Other Disclosures,Sellers Disclosure','','','','','Central Electric','0','QUAIL MEADOWS-ABST.524 BLOCK 1 LOT 13 Acres:1.0000','Cleared','43560','Appraisal District','','','0','','2','','0','','','','','Composition','198 - El Campo','','EL CAMPO HIGH SCHOOL','EL CAMPO MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Quail Mdws Ph I','','','Public Sewer,Septic Tank','2006','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215106559','1669652371','215106559','2022-11-27T22:53:38.367','15058616','Yvonne Pruneda','Nan & Company PropertiesChristie\'s International R','','','29.565376','-95.044681','50','77586','11','359990.00','Active','Cedar','418','Lane','El Lago','2','0','4','2490','Single-Family','This home is truly an entertainer\'s dream with a warm, welcoming interior that is light, uplifting and features well-proportioned rooms, formal living/dining area, generous family room and a bonus room. Brick fireplace. Added features of the home include stainless appliances which enhance this charming newly renovated kitchen, that comprises quartz countertops, tile backsplash, recessed lighting, over-the-range microwave and gas range. The comfortably sized owner\'s suite is an oasis of peace and relaxation and affords an ensuite bathroom and a walk-in closet. A true oasis, the primary bathroom was completely remodeled and is beautifully appointed walk-in shower w/frameless glass door, and double vanity. Adding to the home\'s charm are newly installed laminate floors throughout the main living spaces. Unwind in the beautifully maintained backyard that comes complete with a covered patio. Keep your tools handy and organized in a spacious 2-car breezeway garage. Stop in today!','0.2756','7','','','Gas Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','Gaslog Fireplace','1','Clear Lake Area','Central Gas','1','LT 92 BLK 7 EL LAGO SEC 2','Subdivision Lot','12007','Appraisal District','','65','0','','2','Gas Oven','0','','','Gas Range','','Composition','9 - Clear Creek','ED H WHITE ELEMENTARY SCHOOL','CLEAR FALLS HIGH SCHOOL','SEABROOK INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1.5','Traditional','El Lago Sec 02','9632','2.6666','Public Sewer,Public Water','1963','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215113978','1669652371','215113978','2022-11-27T21:26:46.463','2271773','Amy McGee','Compass RE Texas, LLCHeights','','','29.835056','-95.477710','16','77092','5','325000.00','Active','Verdome','5911','Lane','Houston','2','0','3','1557','Single-Family','Behind a magnificent, towering oak tree you will find a charming, single-story traditional Forest Pines home with an incredible covered and screened back patio for entertaining, a yard and a fun outdoor shed with lots of character and history. The current owners opened up the kitchen to the living room in a property that already had three spacious bedrooms and two full renovated bathrooms. Stainless appliances and side by side refrigerator make the updated kitchen beautiful and practical. Beautiful painted brick fireplace and new high tech, camera based alarm system.','0.1446','9','','','','','Sellers Disclosure','1','','1','Oak Forest West Area','Central Gas','0','LT 2 BLK 4 FOREST PINES SEC 2B','Subdivision Lot','6300','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','27 - Houston','WAINWRIGHT ELEMENTARY SCHOOL','SCARBOROUGH HIGH SCHOOL','CLIFTON MIDDLE SCHOOL (HOUSTON)','Appointment Required','Appraisal District','1','Traditional','Forest Pines Sec 02b','6303','2.3307','Public Sewer,Public Water','1971','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215115371','1669652371','215115371','2022-11-27T22:16:20.143','30719955','Paulino Miranda','NB Elite Realty','','','29.704473','-95.366007','39','77021','4','339000.00','Active','Tampa','3507','Street','Houston','2','0','4','2128','Single-Family','Welcome home near the medical center, zoo, museums, NRG Stadium, shopping and easy access freeways. This home is a 4 bedroom 2 full baths with modern updates from flooring to tub tiles. Stainless steel appliances surrounded with shaker style cabinets, quartz countertops, patio in back yard for your entertaining, great floor plan. Come visit this home and make it yours!','0.1337','4','','','Washer Connections','','Sellers Disclosure','1','','','Riverside','Central Gas','0','LT 15 BLK 1 TERRACE OAKS','Subdivision Lot','5824','Appraisal District','','','0','','2','Freestanding Oven','0','','','Freestanding Range','','Composition','27 - Houston','THOMPSON ELEMENTARY SCHOOL (HOUSTON)','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Mediterranean','Terrace Oaks','5292','2.3307','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully