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-09-12T20:37:27.447' ,`MLSNumber` = '50563020' ,`ListAgentFullName` = 'Lillie Boson' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.807477' ,`Longitude` = '-95.328612' ,`PhotoCount` = '11' ,`PostalCode` = '77026' ,`RoomCount` = '4' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Hirsch Rd' ,`StreetNumber` = '5109' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1296' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COMMERCIAL LOCATION OPPORTUNITY!! 5109 Hirsch Rd is 19,553 sf. lot one (1) BLK off 610 Loop East. House is a teardown. 130 Ft. of Hwy Frontage on Hirsch. Only minutes from Downtown, and Bush Airport. It\'s a Prime Development Opportunity!!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 192 & 193 BLK 12 CRANE STREET GARDENS' ,`LotDesciption` = 'Other' ,`LotSize` = '19553' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KASHMERE GARDENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crane Street Gardens' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1947' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709854' WHERE `Matrix_Unique_ID` = '200626289' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T20:34:50.463' ,`MLSNumber` = '61262047' ,`ListAgentFullName` = 'Lillie Boson' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.575586' ,`Longitude` = '-95.030206' ,`PhotoCount` = '10' ,`PostalCode` = '77331' ,`RoomCount` = '2' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Ridge' ,`StreetNumber` = '1751' ,`StreetSuffix` = 'Road' ,`City` = 'Coldspring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL, QUIET, SECLUDED COUNTRY PARADISE located on the Trinity River in San Jacinto County. The beauty of East Texas Forest is apparent in the wooded area of hardwood and pines. If you are lucky you will see Deer grazing and coming up to eat on the feed they know the owners have put out for them. The front of the property has been cleared, and a 1994 manufactured home (2 bedrooms and 2 baths) sits back off the Spring Ridge Road with a Fish Pond OUT FRONT that has been stocked in the past. There is an additional building on the property for storage.' ,`Acres` = '14.88' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A032 JOSE DOLORES MARTINEZ, TRACT 30.2, ACRES 14.88' ,`LotDesciption` = 'Water View,Waterfront,Wooded' ,`LotSize` = '648173' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Ridge' ,`TaxAmount` = '3072' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663709854' WHERE `Matrix_Unique_ID` = '206531993' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T21:08:47.023' ,`MLSNumber` = '80257698' ,`ListAgentFullName` = 'Linda Beck' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014597' ,`Longitude` = '-95.486194' ,`PhotoCount` = '50' ,`PostalCode` = '77068' ,`RoomCount` = '11' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Placid' ,`StreetNumber` = '2906' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '4854' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful & exceptional custom home in beautiful Northgate Forest, a golf course & country club community. Nestled in quiet culdesac on oversized lot, impressive curb appeal, tiled roof, & 3 car garage & gated driveway. Exquisite custom detail throughout! Foyer has sparkling crystal chandelier & custom iron staircase railing. Formal living room has rich wood paneling, beautiful ceiling detail & 1 of 3 fireplaces. Dining Room features crystal chandelier, lighted display cabinets, mirrored wall & double doors to private court yard. Inviting family room, wall windows looking out to sparkling pool & full wet bar seats 4 at the bar w/ access formal living rm. Island kitchen, 5 burner gas cooktop, granite, double ovens. Beautiful primary bedroom, fireplace, access to pool, 2 custom closets. Primary bath like no other & a sun room workout area. Private study has custom desk & file cabinets. 2 bedrooms & game room up. 22KW n/gas generator. Wonderful backyard for outdoor entertaining. Must See!' ,`Acres` = '0.4446' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 & TR 12A BLK 5 NORTHGATE FOREST PH 1 R/P' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Wooded' ,`LotSize` = '19365' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northgate Forest Ph 01 R/P' ,`TaxAmount` = '10387' ,`TaxRate` = '2.4892' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709854' WHERE `Matrix_Unique_ID` = '207578772' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T21:45:15.790' ,`MLSNumber` = '94606183' ,`ListAgentFullName` = 'John Coscia' ,`ListOfficeName` = 'Olympus/Nelson Realty' ,`SellingAgentFullName` = 'Benjamin Plouvier' ,`SellingOfficeName` = 'HNB Realty, LLC' ,`Latitude` = '29.851583' ,`Longitude` = '-95.635961' ,`PhotoCount` = '18' ,`PostalCode` = '77084' ,`RoomCount` = '5' ,`ListPrice` = '225000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Crystal Bay' ,`StreetNumber` = '5111' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1610' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home just appraised with FHA for $247K. Home has never flooded. Beautiful three bedroom, two bath home with attached two car garage ready for your family. Tile flooring, granite countertop in kitchen with carpet in the bedrooms, wood flooring in master bedroom. Cozy neighborhood with great neighbors. This home needs nothing, just your furniture. Katy school district and the elementary is close by.' ,`Acres` = '0.1818' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 39 BEAR CREEK VILLAGE SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BEAR CREEK ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CARDIFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Call Occupant,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Bear Creek Village Sec 02 R/P' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709854' WHERE `Matrix_Unique_ID` = '208573494' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T20:12:59.080' ,`MLSNumber` = '29800619' ,`ListAgentFullName` = 'Pat Sherf' ,`ListOfficeName` = 'PGS Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.023023' ,`Longitude` = '-95.556594' ,`PhotoCount` = '24' ,`PostalCode` = '77379' ,`RoomCount` = '11' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Spoon Creek' ,`StreetNumber` = '8902' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3731' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Corner lot on a cul-de-sac street. 5 bedrooms ( 2 down)!!! Great location- convenient to Spring Cypress or Louetta\r\nVery open with separate living area down. Gameroom up! Plenty of Storage. Walk in closets.' ,`Acres` = '0.2971' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 MEMORIAL CREEK SEC 3' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '12941' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'THEISS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Creek Sec 03' ,`TaxAmount` = '7265' ,`TaxRate` = '2.4965' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709854' WHERE `Matrix_Unique_ID` = '208740373' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T20:57:14.373' ,`MLSNumber` = '58600010' ,`ListAgentFullName` = 'Emelie Mavligit' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Richard Stone' ,`SellingOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`Latitude` = '29.715366' ,`Longitude` = '-95.463705' ,`PhotoCount` = '50' ,`PostalCode` = '77401' ,`RoomCount` = '13' ,`ListPrice` = '1285000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wedgewood' ,`StreetNumber` = '4818' ,`StreetSuffix` = 'Drive' ,`City` = 'Bellaire' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4014' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Bellaire home on a large corner lot with mature trees and beautiful landscaping, large rooms, a 3rd floor game room, 3-car garage & spacious detached garage apartment with separate entrance. This incredible property has only had one owner who has meticulously cared for & upgraded every inch of the home over the years. Whole house is freshly painted (June 2022) & some of the amazing features are a huge chefs kitchen with so much storage & a great breakfast room open to the family room with wonderful built-ins, very large formal dining room that will fit your entire extended family, beautiful formal living, covered patio & storage shed in back. Upstairs you will find hardwood floors throughout, enormous primary suite with incredible spa retreat, spacious secondary bedrooms & an amazing utility room with sink. Wonderful third floor game room or flex space & also houses the tankless water heater. So many upgrades, see upgrades list in docs or request from agent. NEVER FLOODED.' ,`Acres` = '0.1865' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 20 BLK 2 WEST POST OAK' ,`LotDesciption` = 'Corner' ,`LotSize` = '8125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CONDIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'West Post Oak' ,`TaxAmount` = '19732' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709854' WHERE `Matrix_Unique_ID` = '209358939' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T20:51:39.133' ,`MLSNumber` = '78247281' ,`ListAgentFullName` = 'Stacy Sharp Gehring' ,`ListOfficeName` = 'Weichert,REALTORS-Murray Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.351820' ,`Longitude` = '-95.542288' ,`PhotoCount` = '24' ,`PostalCode` = '77304' ,`RoomCount` = '10' ,`ListPrice` = '274000.00' ,`Status` = 'Active' ,`StreetName` = 'La Salle Branch' ,`StreetNumber` = '12077' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1724' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has been completely updated. new roof,new appliances,new flooring,new fixtures,fresh paint inside and out, new landscaping,new A/C unit. This is a wonderful one story home with thoughtful lay out. you get a formal dinning room, a home office with a closet that could be used as a 4th bedroom. You will love the vaulted ceilings in the entry and the Family room. The fire place has and upgraded surround and mantel. There are full windows across the back of this home that provide that beautiful natural light. The kitchen is light and bright with white cabinets and counter tops, a gas range and oven, dishwasher and the refrigerator is also included. The breakfast room opens onto the kitchen and the living room.The laundry room is straightly placed with the washer and dryer included. The primary bedroom will accommodate your king size bed, night stands, your largest chest of drawers and a comfortable chair or two. Come see the walk in clausal.Westlake is 5 mints to the lake & Conroe' ,`Acres` = '0.1584' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LA SALLE CROSSING 01 (WESTLAKE), BLOCK 4, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'La Salle Crossing - Westlake' ,`TaxAmount` = '4899' ,`TaxRate` = '2.8638' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709855' WHERE `Matrix_Unique_ID` = '209719218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T21:43:23.347' ,`MLSNumber` = '62657265' ,`ListAgentFullName` = 'Brianna Tieperman' ,`ListOfficeName` = 'Keller Williams Coastal Bend' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '28.065119' ,`Longitude` = '-97.101937' ,`PhotoCount` = '26' ,`PostalCode` = '78382' ,`RoomCount` = '6' ,`ListPrice` = '520000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Dove Dr' ,`StreetNumber` = '111' ,`StreetSuffix` = '' ,`City` = 'Rockport' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Salt Lake Living! You have got to see the views from every angle of this wrap around porch. Gorgeous three bedroom, three bathroom, 2200 sq ft stilt home. Upstairs features a spacious living area with sit down bar connecting to the kitchen. Formal dining room will fit the entire family or perfect for entertaining guests. Master bedroom off of the living room with access to the wraparound porch. Bedroom two and three off of the kitchen with a spare guest bathroom and walk-in pantry/laundry room. Downstairs features a fully enclosed workshop, garage, storage shed; plenty of room for all the boats and tools. Sitting on three lots with a gorgeous pergola out back. Copano Cove is the place to call home. Come view this gorgeous home today!' ,`Acres` = '0.57' ,`Area` = '85' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Copano Cove Unit 7, lots 93, 94, 95' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '25200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '310 - Aransas County' ,`SchoolElementary` = 'LIVE OAK 1-3 LEARNING CENTER' ,`SchoolHigh` = 'ROCKPORT-FULTON HIGH SCHOOL' ,`SchoolMiddle` = 'ROCKPORT-FULTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Copano Cove' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709855' WHERE `Matrix_Unique_ID` = '209731195' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T20:04:37.903' ,`MLSNumber` = '39986647' ,`ListAgentFullName` = 'Kristina Houston' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Mary Kay Casey' ,`SellingOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`Latitude` = '29.720095' ,`Longitude` = '-95.411808' ,`PhotoCount` = '30' ,`PostalCode` = '77005' ,`RoomCount` = '8' ,`ListPrice` = '1700000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Tangley' ,`StreetNumber` = '2301' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2345' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Opportunity to own two neighboring homes (2301 & 2307 Tangley) in desireable Southampton. This home has been lovingly cared for and is ready for your updates and personal touches. Thoughtful floorpan features a breakfast room and large dining room by the kitchen, as well as a sun room. All bedrooms have an en-suite bath, one bedroom down. The most recent updates are beautiful refinished hardwood floors, and updated electrical and plumbing to the entire home (all 2011). Walk to Rice University and Rice Village, minutes away from the Texas Medical Center.' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 18 SOUTHAMPTON PLACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '8820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southampton Place' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1934' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709855' WHERE `Matrix_Unique_ID` = '210049877' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T20:05:33.923' ,`MLSNumber` = '83511424' ,`ListAgentFullName` = 'Kristina Houston' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Mary Kay Casey' ,`SellingOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`Latitude` = '29.720046' ,`Longitude` = '-95.412040' ,`PhotoCount` = '6' ,`PostalCode` = '77005' ,`RoomCount` = '7' ,`ListPrice` = '900000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Tangley' ,`StreetNumber` = '2307' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1514' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Opportunity to own a prime location in Southampton Place. Home is in original condition and ready for a refresh. Walk to Rice University and Rice Village, minutes away from the Texas Medical Center.' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 18 SOUTHAMPTON PLACE' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6858' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southampton Place' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709855' WHERE `Matrix_Unique_ID` = '210061105' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T20:42:39.427' ,`MLSNumber` = '71557411' ,`ListAgentFullName` = 'Tina Saalwaechter' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.117846' ,`Longitude` = '-95.404163' ,`PhotoCount` = '36' ,`PostalCode` = '77386' ,`RoomCount` = '5' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory Hollow' ,`StreetNumber` = '2410' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2360' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home that is quiet, peaceful, secluded and still in the area of lots of shopping and entertainment! Roof was replaced in 2/2015, A/C in 6/2014 & Furnace in 8/2020. This beautiful property backs up to a retaining pond with no back neighbors except for the wildlife for you to enjoy. Plenty of deer to be seen here! The backyard is plenty large enough for a pool and the 2nd - 2+ garage could be used as a business location! There is a restroom in the detached garage....during the freeze, the pipes broke, seller just had the pipes capped off and water damage from broken pipes was removed. Up and running in no time if you desire. PLUS, you have a RV Covered area, if you do not have the RV, rent the space out!!! You will love the oak and magnolia trees that surround the property, very peaceful and quiet! This home has NEVER Flooded! One of the lowest tax rates in Montgomery Co. Call your Favorite Realtor and Make your appointment today to see this property in person!' ,`Acres` = '0.586' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SPRING FOREST 02, BLOCK 15, LOT 208-B, 209' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '25526' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'FORD ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Forest 02' ,`TaxAmount` = '5006' ,`TaxRate` = '1.8487' ,`WaterSewer` = 'Aerobic,Other Water/Sewer,Septic Tank' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709855' WHERE `Matrix_Unique_ID` = '210224016' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T20:03:12.543' ,`MLSNumber` = '87815497' ,`ListAgentFullName` = 'Brion Boznango' ,`ListOfficeName` = 'Pro 1 Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.654315' ,`Longitude` = '-95.143407' ,`PhotoCount` = '21' ,`PostalCode` = '77505' ,`RoomCount` = '10' ,`ListPrice` = '419900.00' ,`Status` = 'Active' ,`StreetName` = 'Turtle Creek' ,`StreetNumber` = '6302' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3558' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this move-in ready 4 bedroom, 3 1/2 bath home located on a corner lot in the highly sought after Turtle Creek subdivision. Great curb appeal. Downstairs features a large family room that opens to a spacious kitchen with granite countertops, ample storage space, and a walk-in pantry. Primary bedroom is located on the first floor and features a vaulted ceiling, recently renovated primary bathroom, and spacious walk-in closet. The 2nd floor includes 3 additional bedrooms, 2 full bathrooms, and a massive media room with an included 200\" electric in-ceiling/recessed projector screen. 2-car Detached garage with porte-cochere and 2nd story loft. Whole home generator! Shopping and restaurants nearby. Deer Park ISD!' ,`Acres` = '0.2562' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 TURTLE CREEK SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '11158' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '189' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'FAIRMONT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Turtle Creek' ,`TaxAmount` = '10215' ,`TaxRate` = '2.8798' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709855' WHERE `Matrix_Unique_ID` = '210257601' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T20:37:23.407' ,`MLSNumber` = '51205452' ,`ListAgentFullName` = 'Eduardo Garcia' ,`ListOfficeName` = 'Las Lomas Realty Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812100' ,`Longitude` = '-95.722060' ,`PhotoCount` = '20' ,`PostalCode` = '77449' ,`RoomCount` = '7' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Sun Glen' ,`StreetNumber` = '3031' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property is a 4 bedroom 2.5 bath in a corner lot nice big yard for the family. Close to shopping and major freeways very open living area. All rooms upstairs. A/C and Roof approximately 3-4 yrs old.' ,`Acres` = '0.1539' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 2 SUNDOWN GLEN SEC 6 AMEND' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6703' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '395' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'STEPHENS ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MORTON RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sundown Glen Sec 06 Amd' ,`TaxAmount` = '5395' ,`TaxRate` = '2.9983' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709855' WHERE `Matrix_Unique_ID` = '210352161' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T21:45:07.460' ,`MLSNumber` = '48344135' ,`ListAgentFullName` = 'Margaret Ibrahim' ,`ListOfficeName` = 'M/I Properties' ,`SellingAgentFullName` = 'Elisabeth McNinch' ,`SellingOfficeName` = 'Village Property Advisors' ,`Latitude` = '29.897883' ,`Longitude` = '-95.568626' ,`PhotoCount` = '47' ,`PostalCode` = '77040' ,`RoomCount` = '12' ,`ListPrice` = '695000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Red Pheasant' ,`StreetNumber` = '8605' ,`StreetSuffix` = 'Court' ,`City` = 'Jersey Village' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4271' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for an ideal Wyndham Village abode where you can simply move in, unpack, and relax? Extensively remodeled with $150,000+ worth of upgrades, this remarkable residence provides just that since all the hard work has been done for you! Towering trees, lush foliage, a manicured lawn, and a stately brick façade lend a stunning curb appeal that will surely turn heads. From the covered porch, enter a grand two-story foyer where arched and transom windows spill radiant sunlight across the neutral tones, crown molding, plantation shutters, and beautiful bamboo floors throughout. This quiet community is located just around the corner from a walking trail, dog park, and the Jersey Meadow Golf Course. This home is located in the incorporated city of Jersey Village and does not have a MUD. Jersey Village has many family friendly events throughout the year. Come experience the small-town feeling of JV. Easy access to Hwy. 290, Beltway 8 and I-10. See photos for additional comments.' ,`Acres` = '0.3026' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Jersey Village' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 27, Block 71, Wyndham Village' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community' ,`LotSize` = '13182' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POST ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wyndham Village' ,`TaxAmount` = '12620' ,`TaxRate` = '2.7758' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709856' WHERE `Matrix_Unique_ID` = '210648145' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T21:02:45.450' ,`MLSNumber` = '43568714' ,`ListAgentFullName` = 'Joseph Landes' ,`ListOfficeName` = 'Directed Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.392577' ,`Longitude` = '-95.213361' ,`PhotoCount` = '43' ,`PostalCode` = '77511' ,`RoomCount` = '9' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Fulton' ,`StreetNumber` = '80' ,`StreetSuffix` = 'Drive' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1523' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country charm not far from modern comfort. This beautiful 1 story brick-all-around home comes Texas Large! With a bright and open layout you will receive 3 bedrooms, 2 full baths, 2 car garage, new roof, new a.c., all on an oversized lot! Coupled with engaging details you find a welcoming entrance adorned by a chic red door between large windows that allow sights of an inviting fireplace. Just a couple steps in and to the right you\'re greeted with a charming kitchen visible from the entry hallway and through the expanse open living room. A split layout gives you secondary bedrooms and a full guest bath to the left and to the right the primary room not far from the dining area and kitchen. You will be located in a great area with good schools and good neighbors. Never flooded and not in a flood zone this neatly remodeled home is ready to move-in! Stop searching, we found your dream home. Don\'t delay and make it your home today!' ,`Acres` = '0.4283' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'GREEN MEADOWS SEC 2 (A0161 BBB & CRR) LOT 20 BLOCK B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18657' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'WALT DISNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Green Meadows' ,`TaxAmount` = '1805' ,`TaxRate` = '2.2174' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663709856' WHERE `Matrix_Unique_ID` = '210723100' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T21:32:51.410' ,`MLSNumber` = '39443659' ,`ListAgentFullName` = 'Patrick King' ,`ListOfficeName` = 'Realty Kings Properties' ,`SellingAgentFullName` = 'Christian Galindo' ,`SellingOfficeName` = 'City Insight Houston' ,`Latitude` = '29.656058' ,`Longitude` = '-95.487078' ,`PhotoCount` = '38' ,`PostalCode` = '77035' ,`RoomCount` = '11' ,`ListPrice` = '299900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Warm Springs' ,`StreetNumber` = '5703' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2320' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ideal corner lot home in the well established Westbury subdivision. This home features 3-bedrooms, 2-bathrooms, original hardwood floor, original windows and formal dining with pass through to kitchen. Well-appointed kitchen with 30-inch wood cabinets, breakfast bar and breakfast nook. The den features wood beam in ceilings and a cozy wood burning fireplace. Primary bedroom boasts double closet, built-in vanity and ensuite bath with walk-in shower. The backyard boasts patio and ample green space for family enjoyment. Additional features include fresh paint and new carpet throughout. This home needs updating but with a little work you could bring this home back to life. Don’t miss this opportunity, schedule your tour today.' ,`Acres` = '0.2204' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 68 WESTBURY SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbury Sec 03' ,`TaxAmount` = '5185' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709856' WHERE `Matrix_Unique_ID` = '211460408' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T21:00:12.057' ,`MLSNumber` = '13456747' ,`ListAgentFullName` = 'Tania Castelan' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.077016' ,`Longitude` = '-94.153236' ,`PhotoCount` = '32' ,`PostalCode` = '77707' ,`RoomCount` = '3' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Devon' ,`StreetNumber` = '566' ,`StreetSuffix` = 'Street' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2318' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming home sitting in West End Beaumont waiting for it\'s new owner! Walk in to be greeted w/ updated wood flooring, an open concept floorplan & more! the living room boasts a woodburning fireplace, exposed brick & large sliding doors leading into a large bonus room w/ vaulted ceilings. Flowing right into the kitchen you\'ll find granite countertops, a breakfast bar & stainless steel appliances. Off of the kitchen is a separate den space w/ an abundance of natural lighting. Each bedroom is nicely sized & granite countertops in each bathroom. The backyard has tons of green space, perfect for kids to play or dogs to run! Call today to schedule your personal tour!' ,`Acres` = '0.25' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CALDWOOD L17 B12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10892' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'CALDWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'ODOM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Caldwood' ,`TaxAmount` = '4165' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709856' WHERE `Matrix_Unique_ID` = '211587430' --> 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','211651513','1663709856','211651513','2022-09-12T20:04:15.347','57697840','Anna Amboree','Amboree & Associates','','','29.521543','-95.554017','14','77459','11','474900.00','Active','Bear Grove','10','Drive','Missouri City','3','1','4','3161','Single-Family','Drive By Only. Will show with contract offer and proof of funds. Beautiful home in the award-winning community of Sienna! This 2 story boasts 4 bedrooms/3.5 baths, open foyer, living room, formal dining room, your gourmet kitchen & breakfast area just to name a few! Your foyer welcomes all your guests w/a soaring ceiling, arched doorways, & art-niches. Huge game room upstairs. Room sizes are approximate.','0.1499','38','','','','','Sellers Disclosure','','','','Sienna Area','Central Gas','1','SIENNA VILLAGE OF BEES CREEK SEC 7, BLOCK 1, LOT 4','Subdivision Lot','6531','Appraisal District','','1307','0','','3','','0','','','','','Composition','19 - Fort Bend','SIENNA CROSSING ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','BAINES MIDDLE SCHOOL','Appointment Required,No Supra Keybox','Appraisal District','2','Traditional','Sienna Village Of Bees Creek Sec 7','10130','2.8129','Public Sewer,Public Water','2013','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T20:03:32.743' ,`MLSNumber` = '46452993' ,`ListAgentFullName` = 'Samantha Wade' ,`ListOfficeName` = 'Home Sweet Home Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.501264' ,`Longitude` = '-95.388351' ,`PhotoCount` = '40' ,`PostalCode` = '77378' ,`RoomCount` = '12' ,`ListPrice` = '599999.00' ,`Status` = 'Active' ,`StreetName` = 'E FM 1097' ,`StreetNumber` = '18281' ,`StreetSuffix` = '' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '2313' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This stunning custom built home on 2 UNRESTRICTED acres with privacy fencing and an automatic access gate is a must see! The home also features an oversized 2 car garage plus a small building for additional workshop space- WOW! Designed as a 2 bedroom 2 bath PLUS a generously sized office/study and a HUGE game room that has access to the back porch. Both rooms can be converted to a 3rd & 4th bedroom if desired. This home boasts a large open concept with a living area with a cozy fireplace, dining and kitchen that can accommodate any family gathering. The chef\'s kitchen features beautiful custom cabinetry complete with high end granite countertops and stone backsplash! The oversized primary retreat is beautiful with an en-suite bathroom with dual sinks, an oversized soaking tub and tiled shower! Enjoy the back yard under the shade of the MASSIVE covered patio with industrial fans! Don\'t miss out on this gorgeous home!' ,`Acres` = '2.066' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willis Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S765100 - Oak Springs, RES A-1, ACRES 2.029' ,`LotDesciption` = 'Cleared' ,`LotSize` = '88383' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Springs' ,`TaxAmount` = '5985' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709856' WHERE `Matrix_Unique_ID` = '211667675' --> 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','211785926','1663709856','211785926','2022-09-12T21:46:34.270','69772713','Elizabeth Beiter','Maven Real Estate Group','','','29.746180','-95.571154','19','77042','7','287000.00','Active','Trixie','2014','Lane','Houston','2','0','3','1428','Single-Family','This perfect patio home is light and bright with fresh paint and updates. Current tenants occupying the home till June 2023. A few highlights include a grand living room with vaulted ceiling and wood-burning fireplace, a spacious primary bedroom with Container Store \"Elfa\" closet, and a patio with a refinished deck and covered pergola, ideal for outside dining. This house is also equipped with smart home features & roof-top solar panels. All appliances including the washer and dryer, refrigerator, and countertop microwave stay with the home. The new owners will have access to the neighborhood tennis courts & pool! HOA covers trash & lawn care. This house is looking for the perfect investor that is ready to make money right away!','0.0713','31','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure,Tenant Occupied','1','Wood Burning Fireplace','1','Briargrove Park/Walnutbend','Central Electric','1','LT 46 BLK 2 LAKESIDE ESTATES T/H SEC 1 R/P','Patio Lot','3107','Appraisal District','','60','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','27 - Houston','WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)','WESTSIDE HIGH SCHOOL','REVERE MIDDLE SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox','Appraisal District','1','Contemporary/Modern','Lakeside Estates T/H Sec 01 R/','5159','2.3307','Public Sewer,Public Water','1977','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','211867131','1663709856','211867131','2022-09-12T20:33:05.480','67242169','Beverly Bradley','Weekley Homes','','','30.279590','-95.568047','26','77316','7','450000.00','Active','Bungalow','183','Drive','Montgomery','2','1','3','2408','Single-Family','Welcome home to the classic comfort and contemporary design combination of The Ziegler luxury home plan. Each upstairs bedroom provides a great place to grow and its own walk-in closet. The sunlit open floor plan is suited for daily life and hosting special occasions, and offers a beautiful backyard view. Easily prepare family meals and party spreads in the streamlined kitchen. Enjoy the outdoors from the comfort of your generous covered patio. Your owner\'s retreat gives you a beautiful place to begin and end every day in luxury with a deluxe bathroom with super shower and walk-in closet. The upstairs retreat and downstairs study and dining areas provide FlexSpace for you to design the specialty rooms you\'ve been dreaming of. Build your future together in this splendid new home plan.','','39','David Weekley Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','','Conroe Southwest','Central Gas,Zoned','1','Lot 5 Block 3','Cul-De-Sac,Subdivision Lot','5250','Survey','','1300','1','To Be Built/Under Construction','2','Gas Oven,Single Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Vacant/Unoccupied','Builder','2','Contemporary/Modern','Woodforest','','3.356','Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-12T21:54:55.917' ,`MLSNumber` = '45949773' ,`ListAgentFullName` = 'Faye Ausmus' ,`ListOfficeName` = 'Ausmus Premier Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.429386' ,`Longitude` = '-95.636826' ,`PhotoCount` = '27' ,`PostalCode` = '77356' ,`RoomCount` = '7' ,`ListPrice` = '698500.00' ,`Status` = 'Active' ,`StreetName` = 'Bentwood' ,`StreetNumber` = '114' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3728' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Modern Design w/High Ceilings through out, 2 bedrooms down!. Enjoy entertaining with a very large family room open to the kitchen. Kitchen features large 9\' island, Shaker Style Wood Cabinets w/soft close drawers and doors, Quartz Countertops with Waterfall sides. Beautiful Engineered Hardwood Floors, Other custom features include 8\' interior doors and 8\" Baseboards. Work from home? No problem! Spacious Study located off the front entry( or another bedroom with a full bath) . Upstairs 3 Bedrooms each with their own bath and a very Large game room with a view of the Lake at meadows Park. Large Walk in showers in each bathroom Enjoy your coffee in the mornings on your 214 Sq. Ft lanai! Or dining area with a view of the lake at Meadows Park. Space allowed for nice Wine Room off Entry/Kitchen.walk across street to Meadows Park. Want room for a Pool- See attached idea for Lap Pool and Photo of conceptual idea. Corner Lot. Walk to the Meadows Park..... So much more!' ,`Acres` = '0.1698' ,`Area` = '39' ,`BuilderName` = 'SK & SA HomeBuilders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 33, BLOCK 1, LOT 1' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot,Water View' ,`LotSize` = '7397' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bentwater 33' ,`TaxAmount` = '405' ,`TaxRate` = '2.1898' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709856' WHERE `Matrix_Unique_ID` = '211996729' --> 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','212030030','1663709857','212030030','2022-09-12T20:46:47.760','68543407','Monica Andrews','Texas Signature Realty','','','30.264390','-95.131213','19','77372','11','175000.00','Active','County Road 3740','12718','','Splendora','2','0','3','2112','Single-Family','Welcome home - this home is nestled into mature trees - on almost a full acre of land. The kitchen boasts abundant cabinets and countertop space for the cook in the family! Breakfast bar, island, and a spot for your breakfast table! Nice sized laundry/mud room off the kitchen. In addition to the office space adjacent to the primary bedroom, you will also find a desk/work from home area in the kitchen. All bedrooms are generously sized. All appliances including washer/dryer will stay with the home. Double carport - workshop, and shed. Yard is fenced all the way around....Bring your animals. No restrictions! No HOA! Located within 15 minutes of Shopping, Theatres, restaurants, and highway 99. Room measurments should be verified. HOME DID NOT FLOOD DURING HARVEY OR IMELDA. Extremely motivated seller - all offers will be considered.','0.89','52','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Cleveland Area','Central Electric','0','SOUTHERN CROSSING, SEC 2, LOT 89, ACRES .89, MH LABEL# RAD12','Subdivision Lot,Wooded','38768','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Aluminum','100 - Cleveland','SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)','CLEVELAND HIGH SCHOOL','CLEVELAND MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Southern Crossing,','2168','1.8013','Public Water,Septic Tank','2000','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','212123753','1663709857','212123753','2022-09-12T20:27:53.280','94651634','Betty Guo','REALM Real Estate Professional','','','29.698180','-95.833284','45','77494','8','358900.00','Active','Whittmore Fields','26323','Drive','Katy','2','1','3','2162','Single-Family','Please ask listing agent how to get qualified for under 5% insterest rate for 30 yrs loan. Beautiful 2 story home in Westheimer Lakes North zoned to KATY ISD. Laminate wood flooring in entry, dining and family area. Tile flooring in the kitchen, breakfast & baths. Spacious bedrooms & game room upstairs. Ceiling fans. Covered patio with huge backyard. NO BACK NEIGHBORS. Easy access to Westpark, Grand Parkway, and I10!','0.1204','36','','','','','Mud','','','2','Katy - Southwest','Central Electric,Central Gas','1','WESTHEIMER LAKES NORTH SEC 1, BLOCK 3, LOT 32','Subdivision Lot','5243','Appraisal District','','850','0','','2','','0','','','','','Composition','30 - Katy','SHAFER ELEMENTARY SCHOOL','JORDAN HIGH SCHOOL','SEVEN LAKES JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Westheimer Lakes North Sec 1','5477','2.6345','Public Sewer,Public Water','2007','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','212267294','1663709857','212267294','2022-09-12T21:09:44.757','52968898','Jeremy Alvarado','Coldwell Banker Realty','','','29.722796','-95.585924','50','77082','12','1199000.00','Active','Legend Manor','11807','Drive','Houston','3','1','4','4571','Single-Family','Spectacular brick and stone home situated on the 11th fairway within the 24/7 guard-gated Royal Oaks Country Club community. The 2-story foyer commands attention before flowing into the formal living and dining. Gourmet kitchen with professional appliances and large island opens to the breakfast and family room with panoramic golf course views through tall windows. Serene primary suite spoiled with golf course views, spa-like ensuite and enormous walk-in closet with custom built-ins. Upstairs boast a game room featuring a wetbar stocked with wine cooler and ice-maker with access to balcony overlooking the golf course, and a flex room- makes for a perfect theatre/study or bedroom. This home has been elevated with freshly updated kitchen, new paint and carpet throughout. Outside welcomes you with a relaxing covered patio and plenty of green space for a custom pool while engulfing the amazing views of the 11th fairway.','0.2466','31','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','Gaslog Fireplace','1','Westchase Area','Central Gas','1','LT 7 BLK 2 ROYAL OAKS COUNTRY CLUB SEC 10','Subdivision Lot','10740','Appraisal District','','3130','0','','3','Electric Oven','0','','','Gas Cooktop','','Composition','2 - Alief','OUTLEY ELEMENTARY SCHOOL','AISD DRAW','O\'DONNELL MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Royal Oaks Country Club Sec 10','23451','2.6086','Water District','2003','Builder'); --> New record created successfully