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-21T23:25:27.887' ,`MLSNumber` = '64803158' ,`ListAgentFullName` = 'Arinze Ezebuilo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.522306' ,`Longitude` = '-95.465453' ,`PhotoCount` = '32' ,`PostalCode` = '77545' ,`RoomCount` = '4' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Avery Bay Court' ,`StreetNumber` = '4407' ,`StreetSuffix` = '' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2546' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ANDOVER FARMS SEC 6, BLOCK 1, LOT 8' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9551' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BURTON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Andover Farms' ,`TaxAmount` = '5729' ,`TaxRate` = '2.5734' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641029' WHERE `Matrix_Unique_ID` = '208457302' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T23:22:38.787' ,`MLSNumber` = '25144325' ,`ListAgentFullName` = 'Arinze Ezebuilo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.823721' ,`Longitude` = '-95.712357' ,`PhotoCount` = '32' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '369000.00' ,`Status` = 'Active' ,`StreetName` = 'Autumnglade Place' ,`StreetNumber` = '19631' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2994' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has a new roof, brand new A/C units, microwave, dishwasher and stove. The carpet is also new! This beautiful home was a model home with a lot of upgrades including surround sound, front/back sprinkler system, intercom system, hardwood floors, tile, mirrored dining room, second floor ceiling entry with extended tiles, arched entry into the formal living/dining, tile backsplash in kitchen. Home is on a Cup-De-Sac lot.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 1 WESTFIELD ESTATES SEC 8' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9498' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '326' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RHOADS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CARDIFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641029' WHERE `Matrix_Unique_ID` = '210428332' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T23:42:44.600' ,`MLSNumber` = '78048331' ,`ListAgentFullName` = 'Roxanna Plazas' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.005239' ,`Longitude` = '-95.432742' ,`PhotoCount` = '36' ,`PostalCode` = '77090' ,`RoomCount` = '9' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Skywood' ,`StreetNumber` = '415' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1787' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedroom 2 bathroom property located in North Forest Subdivision. Recently renovated with laminated floors, tile, granite countertops in kitchen and bathroom, new lighting fixtures. This will not last long! ' ,`Acres` = '0.1566' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 5 NORTH FOREST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'BAMMEL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'North Forest' ,`TaxAmount` = '3808' ,`TaxRate` = '2.6492' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641030' WHERE `Matrix_Unique_ID` = '210993952' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T23:35:25.253' ,`MLSNumber` = '44562131' ,`ListAgentFullName` = 'Colleen Pye' ,`ListOfficeName` = 'RE/MAX Elite Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.164357' ,`Longitude` = '-95.746541' ,`PhotoCount` = '36' ,`PostalCode` = '77355' ,`RoomCount` = '7' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Elm Trace' ,`StreetNumber` = '28610' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1922' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare 2.82 acres on cul-de-sac.Tiny subdivision-min 1 acre lots\r\nMOVE-IN READY\r\nLow taxes & utilities\r\nNear schools/conveniences\r\nSplit bdrm layout,2 living areas+dining rm & utility rm\r\nHuge kitchen-cabinets galore/island open to family rm\r\nHVAC w/ceiling vents\r\n2-water heaters\r\nDrywall-round corners/crown molding/neutral colors\r\nNew or newer doors/lights/baths/wood floors/tile/roof/gutters/paint\r\n8\'x8\'/12\'x24\' decks\r\nFenced yard, asphalt driveway\r\nBacks to High Meadow Ranch.' ,`Acres` = '2.8224' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SAWMILL ESTATES, BLOCK 1, LOT 14, MH SERIAL # OC050013655A,' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Ravine,Wooded' ,`LotSize` = '122944' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'NICHOLS SAWMILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sawmill Estates' ,`TaxAmount` = '1653' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669641030' WHERE `Matrix_Unique_ID` = '211323517' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T00:19:33.403' ,`MLSNumber` = '4935651' ,`ListAgentFullName` = 'Kishana Strawn' ,`ListOfficeName` = 'Keller Williams Realty - Memor' ,`SellingAgentFullName` = 'Andre Beraud' ,`SellingOfficeName` = 'CR Elite Realty' ,`Latitude` = '29.676672' ,`Longitude` = '-95.375586' ,`PhotoCount` = '26' ,`PostalCode` = '77051' ,`RoomCount` = '5' ,`ListPrice` = '314900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Parnell' ,`StreetNumber` = '7902' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1966' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Your Brand New Home! that has All rooms upstairs. Entire home is pre-wired for internet access. Your 3 bedrooms, 2.5 Baths, 2 Story Home in Medical Center South. Built to perfection, has a super spacious primary bedroom with bathroom attached, free standing tub with frame less shower. This beautiful home includes everything needed. This home has a Beautiful Outdoor Living where you can enjoy outdoor activities all year round. The kitchen includes Stainless Steel Appliances with one year warranty and Quartz Counter tops. Schedule your private tour today!' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'QUEENSDRIVE inc' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK K SUNNYSIDE PLACE' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '2680' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'YOUNG ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sunnyside Ext South' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641030' WHERE `Matrix_Unique_ID` = '211583499' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T23:32:32.957' ,`MLSNumber` = '52149017' ,`ListAgentFullName` = 'Cindy Boutwell' ,`ListOfficeName` = 'Boutwell Properties LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.982983' ,`Longitude` = '-95.620010' ,`PhotoCount` = '45' ,`PostalCode` = '77429' ,`RoomCount` = '12' ,`ListPrice` = '1500000.00' ,`Status` = 'Active' ,`StreetName` = 'Hunters Canyon' ,`StreetNumber` = '12626' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the exclusive Great Oaks Estates, this beautifully designed 1.5 story home offers 5 oversized bedrooms, 4 full baths and 2 half baths. Featuring a spectacular one of a kind double pool with slide, waterfall, tree swing, beach entry & spa. Surrounded by lush landscaping and shady palm trees, this home makes the perfect sunshine retreat. Unsurpassed views of the 1.5 acre property, fantastic covered patio with summer kitchen, long driveway with a 3 car oversized garage and a 2 car carport, are sure to impress. The immaculate interior features rich woods, built-ins, trey ceilings, custom lighting, stainless steel appliances and more! Incredible master retreat with bay windows, trey ceiling, very spacious Master Bath w/raised soaking tub, tiled shower, and huge closet w/Built-Ins and Exercise room. Upstairs has media room, Bedroom, Gameroom, Full Bath and large Storage rooms. Zoned to highly acclaimed Cy-Fair Schools and minutes from dining, shopping, parks, and more.' ,`Acres` = '1.5009' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 GREAT OAKS ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '65381' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1720' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Great Oaks Estates' ,`TaxAmount` = '19601' ,`TaxRate` = '2.1637' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641030' WHERE `Matrix_Unique_ID` = '212865323' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T00:32:16.423' ,`MLSNumber` = '23460566' ,`ListAgentFullName` = 'Daisy Acuna' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812620' ,`Longitude` = '-95.387047' ,`PhotoCount` = '28' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '669000.00' ,`Status` = 'Active' ,`StreetName` = 'Princeton' ,`StreetNumber` = '2824' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2808' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Heights Enclave Place. A beautiful, gated community in the sought-after Heights! This impressive Mediterranean home offers 3 bedrooms and 3.5 baths, high-end finishes throughout, with an elevator! You will enjoy the large family room with high ceilings, fireplace, custom lighting and beautiful wood floors. The kitchen has a beautiful island, custom cabinets, Bosch stainless steel appliances & wine fridge. Every room will feel private with its own en-suite bathroom! This home has great natural lighting with an open floor plan, which makes it great for entertaining! Relax and enjoy the views on the outdoor balcony. Great central location. Close to Downtown, Galleria, Medical Center, shops, parks, dining, and museums. Don\'t miss this one!' ,`Acres` = '0.0506' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 HEIGHTS ENCLAVE' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2204' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1740' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Heights Enclave Place' ,`TaxAmount` = '12003' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641031' WHERE `Matrix_Unique_ID` = '212926516' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T00:20:30.857' ,`MLSNumber` = '28120732' ,`ListAgentFullName` = 'MaryAnne Adams-Tyler' ,`ListOfficeName` = 'Keller Williams Advntge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.949379' ,`Longitude` = '-95.320809' ,`PhotoCount` = '34' ,`PostalCode` = '75862' ,`RoomCount` = '14' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Coral Gables' ,`StreetNumber` = '304' ,`StreetSuffix` = 'Drive' ,`City` = 'Trinity' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3426' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2.5-level home on the waterfront in Westwood Shores subdivision on the North end of Lake Livingston. Home offers 3 bd/3ba with main living areas on the second floor. The second floor includes 2 bedrooms, 1 bath, living area, dining area, and large kitchen. 17\' glass wall of windows offers beautiful views of the Lake and pastures beyond. It\'s the perfect location to enjoy the beauty of the changing seasons. Third floor bedroom is very SPACIOUS with a large walk-in closet and tall windows. Top floor hallway provides access to secondary closet and wall of shelves. Bath includes shower, toilet and spacious single vanity. Bottom floor offers PLENTY of space for a Gameroom, large utility spaces that include laundry/sewing room, a 13\' x 30\' workshop, utility room and bath with shower. Outdoor features include covered patio w/stone walkway to waterfront. Carport is open to waterfront patio and steps to second floor. Carport also includes outdoor closet for lawn equipment and auto items.' ,`Acres` = '0.1819' ,`Area` = '42' ,`BuilderName` = 'Randall McLaren' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Section 11, Block 15, Lot 15' ,`LotDesciption` = 'Cleared,In Golf Course Community,Subdivision Lot,Waterfront' ,`LotSize` = '7923' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Left Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Shores' ,`TaxAmount` = '3225' ,`TaxRate` = '2.4708' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641031' WHERE `Matrix_Unique_ID` = '213328778' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T23:09:47.357' ,`MLSNumber` = '17595560' ,`ListAgentFullName` = 'Gabriela Hagler' ,`ListOfficeName` = 'AIM Commercial Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.502006' ,`Longitude` = '-98.296249' ,`PhotoCount` = '30' ,`PostalCode` = '78109' ,`RoomCount` = '6' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Copper' ,`StreetNumber` = '7611' ,`StreetSuffix` = 'Lake' ,`City` = 'Converse' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1402' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Bright and inviting, open-concept 3/2/2 in the heart of Copperfield! Built to enjoy, this perfectly appointed home has a large patio (by builder) great for entertaining in style, plus chic bay window, vaulted ceilings, 6 panel (builder\'s gold package) premium doors, two-inch faux wood blinds throughout, pre-wire for security, radiant barrier, double pane windows, ceiling fans, and high SEER HVAC for energy efficiency. Come check out the awesome Primary Bedroom with walk-in closet and private ensuite featuring relaxing Garden Tub! What else could you ask for in an OPEN CONCEPT FLOORPLAN WITH EXCELLENT CURB APPEAL with ABUNDANT ENTERTAINING OPTIONS - INDOOR AND OUTDOOR, under 1500SF?! All within close proximity to main thoroughfares, with easy access to Loop 1604, and I-35, Randolph AFB, shopping and schools! *all information should be verified by buyer\"' ,`Acres` = '0.1291' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CB 5069B (MEADOWS OF COPPERFIELD UT-4), BLOCK 14 LOT 25 PLAT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5624' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '135' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '634 - Judson' ,`SchoolElementary` = 'RICARDO SALINAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JUDSON HIGH SCHOOL' ,`SchoolMiddle` = 'KITTY HAWK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadows Of Copperfield Ut-4' ,`TaxAmount` = '5094' ,`TaxRate` = '2.4938' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641031' WHERE `Matrix_Unique_ID` = '213677653' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T00:20:39.730' ,`MLSNumber` = '65083567' ,`ListAgentFullName` = 'Bari Pace' ,`ListOfficeName` = 'Texas Legacy Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.156843' ,`Longitude` = '-95.678399' ,`PhotoCount` = '48' ,`PostalCode` = '77362' ,`RoomCount` = '9' ,`ListPrice` = '428000.00' ,`Status` = 'Active' ,`StreetName` = 'Evergreen Meadows' ,`StreetNumber` = '818' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2498' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRISTINE VILLAGE BUILDERS SINGLE STORY HOME featuring 3 bedrooms, 2.5 baths & 2 car garage. The beautifully landscaped backyard has an extended, tiled patio that backs to a green belt with no rear neighbors! Lovely neutral tile throughout w/carpet in the bedrooms. Gourmet island kitchen with 42\" Maple cabinets, granite countertops & large walk-in pantry. Stainless appliances including 5 burner gas cooktop & refrigerator. Living room has tall tray ceilings, gas log fireplace & beautiful views! The study has 5\" Birch hardwood floors, wainscoting & double wood/glass doors. Spacious primary bedroom has a vaulted ceiling, with extended windows. Primary bath has double sinks, jetted tub & separate shower. This home is situated on a quiet cul-de-sac street within walking distance of the 23 acre spring fed lake & amenities. Come & walk the over 5 miles of trails or explore Central Park. Tomball ISD Schools. Easy access to the SH 249 Freeway, Grand Parkway & the Beltway. THIS COULD BE HOME!!' ,`Acres` = '0.1641' ,`Area` = '15' ,`BuilderName` = 'Village' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S959404 - WOODTRACE 04, BLOCK 1, LOT 9' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodtrace 04' ,`TaxAmount` = '9696' ,`TaxRate` = '3.2015' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641031' WHERE `Matrix_Unique_ID` = '213801019' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T23:32:55.530' ,`MLSNumber` = '97679481' ,`ListAgentFullName` = 'Cindy Boutwell' ,`ListOfficeName` = 'Boutwell Properties LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.000904' ,`Longitude` = '-95.749910' ,`PhotoCount` = '48' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '404900.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Valley' ,`StreetNumber` = '15515' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2898' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BE HOME BEFORE THE HOLIDAYS! Awesome 2 story home in the heart of Fairfield! Excellent location, with no back yard neighbors, backing to a park area. Beautiful curb appeal with mature trees and attractive landscaping. This home features hard wood flooring, over-sized kitchen open to the living room, and a large master bedroom with en suite bathroom. Great sizes for all secondary bedrooms, with fabulous upstairs game room perfect for a pool table or gaming area. Although it\'s very close to the Garden Grove pool, the back yard is perfect for putting in your own pool as well. Partial new fencing, and recent updates to carpet, stove, water heater and kitchen sink. Zoned to great Fairfield schools, and located perfectly for quick access to all the dining, shopping, and entertainment options Fairfield has to offer. With 6 area pools, 2 splashpads, miles of walking trails, multiple lakes and a dog park, there\'s a lot to love about Fairfield! Schedule your private showing today!' ,`Acres` = '0.1874' ,`Area` = '35' ,`BuilderName` = 'Perry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 FAIRFIELD VILLAGE WEST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8161' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1080' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairfield' ,`TaxAmount` = '7354' ,`TaxRate` = '2.616' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641032' WHERE `Matrix_Unique_ID` = '213828656' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T23:18:00.880' ,`MLSNumber` = '97667524' ,`ListAgentFullName` = 'Sherry McNabb' ,`ListOfficeName` = 'Nest Ahead' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800320' ,`Longitude` = '-95.791984' ,`PhotoCount` = '42' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Lanning' ,`StreetNumber` = '24410' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2179' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one story home in Lakecrest, a gorgeous subdivision just minutes away from I-10 and 99 Grand Parkway! Open-flow concept with engineered flooring in the main areas and primary bedroom, tile and granite in kitchen and bathrooms, new dishwasher, high-end insulated garage door, and many more upgrades! Home has just been completely repainted. This backyard is big enough for a pool, and the front yard is oversized as well with gorgeous mature trees! Lakecrest Community has so much to offer with walking trails, playground and a community pool. Low tax rate and low HOA dues. This HOME IS A MUST SEE! Schedule your showing today.' ,`Acres` = '0.2793' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 2 LAKECREST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12166' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakecrest' ,`TaxAmount` = '6804' ,`TaxRate` = '2.5733' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641032' WHERE `Matrix_Unique_ID` = '213973362' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T00:20:39.653' ,`MLSNumber` = '32739049' ,`ListAgentFullName` = 'Trisha Lauter' ,`ListOfficeName` = 'Realm Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.027229' ,`Longitude` = '-95.504630' ,`PhotoCount` = '21' ,`PostalCode` = '77379' ,`RoomCount` = '11' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Dayln' ,`StreetNumber` = '5811' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2005' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in highly acclaimed Cypress Trace, located in a caul-de-sac. Featuring 3 large bedrooms and 2 large bathrooms. The Owner\'s Bedroom has an additional bedroom with closet that can be used as a nursery or could be another separate bedroom with the addition of another entry door if desired. Huge Kitchen with large island, gas range, granite countertops, and lots of storage - open to the Breakfast room and Living Area. Great for entertaining!!! Lovely Formal Dining area that could be used for another Living Area or Game Room. The A/C and tankless gas water heater is approximately 1 year old. Zoned to Klein schools and centrally located to I-45, HWY 249, and the Grand Parkway for easy access to anywhere you need to go. Very well maintained and never flooded, even during Harvey. This is a beautiful home and will not last long!! The PERFECT place to call HOME!' ,`Acres` = '0.1239' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 45 BLK 2 CYPRESS TRACE SEC 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5395' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BENFER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Trace Sec 02' ,`TaxAmount` = '5300' ,`TaxRate` = '2.5965' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641032' WHERE `Matrix_Unique_ID` = '214107280' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T23:32:47.107' ,`MLSNumber` = '30923655' ,`ListAgentFullName` = 'Lin Huang' ,`ListOfficeName` = 'KingFay Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.576637' ,`Longitude` = '-95.216465' ,`PhotoCount` = '20' ,`PostalCode` = '77089' ,`RoomCount` = '8' ,`ListPrice` = '319800.00' ,`Status` = 'Active' ,`StreetName` = 'Christophers Walk' ,`StreetNumber` = '12035' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2420' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 2 story home features 3 bedrooms & 2.5 bath located in highly sought after Clear Brook Crossing Community! The open-concept kitchen features brand new granite countertop, SS appliance, new microwave oven, custom tile backsplash, breakfast bar. Formal dining room, large den with cozy fireplace. Bedrooms with ceiling fans and 2 inch blinds. Upstairs Game Room, large backyard, NO direct back neighbor. Double panel windows for energy and noise insulation. AC replaced in 2021, water heater 2022. NO carpet, Fresh paint. Zoned to great CCISD. Easy access to Beltway 8, I-45, shopping, restaurants, parks and walking trails.' ,`Acres` = '0.1356' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 3 CLEAR BROOK CROSSING SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5906' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'WEBER ELEMENTARY' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'WESTBROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Brook Crossing' ,`TaxAmount` = '5785' ,`TaxRate` = '2.524' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641032' WHERE `Matrix_Unique_ID` = '214108876' --> 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','214239294','1669641032','214239294','2022-11-22T00:20:39.140','22850257','Anthony Pivaral','Walzel Properties','','','30.385091','-95.643433','7','77356','4','270000.00','Active','Estelle','82','Circle','Montgomery','3','0','3','2152','Single-Family','House needs to be remodel.','0.1895','39','','','','','Sellers Disclosure','','Freestanding','1','Lake Conroe Area','Central Electric','1','CAPE CONROE 01, BLOCK 2, LOT 82','Cul-De-Sac','8256','Appraisal District','','240','0','','2','','0','','','','','Composition','37 - Montgomery','STEWART CREEK ELEMENTARY SCHOOL','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Cape Conroe 01','5096','2.3542','Public Sewer,Public Water','1996','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T00:05:51.197' ,`MLSNumber` = '32054665' ,`ListAgentFullName` = 'Cindy Boutwell' ,`ListOfficeName` = 'Boutwell Properties LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.002037' ,`Longitude` = '-95.760882' ,`PhotoCount` = '41' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Silent Jasmin' ,`StreetNumber` = '21807' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '2711' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a dream home, this is it! This beautiful four bedroom two full/two half bath home is waiting for you! Located in the highly desirable Fairfield community, this one has it all. You will enjoy the beautiful pool, patio area, outdoor kitchen, and outdoor bathroom installed in 2018. The spacious indoor entertainment area is equally impressive with a large living room featuring a stone fireplace, wood floors, decorative arches and beautiful natural light. You will love prepping meals in this upgraded kitchen! Open to the living room, this kitchen has ample granite countertops, recently replaced backsplash, walk in pantry and breakfast area. The first floor primary bedroom will not disappoint with wood floors, lots of natural light, duel sinks, soaking tub and spacious walk in closet. The upstairs game room is perfect for watching TV or playing your favorite games. If that is not enough, the garage has epoxy floors! Beautiful inside and out, you will not want to miss this one!' ,`Acres` = '0.187' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 3 FAIRFIELD VILLAGE SOUTH SEC 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8146' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairfield' ,`TaxAmount` = '6998' ,`TaxRate` = '2.746' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641032' WHERE `Matrix_Unique_ID` = '214242871' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T23:09:55.983' ,`MLSNumber` = '10704242' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.032006' ,`Longitude` = '-95.377075' ,`PhotoCount` = '7' ,`PostalCode` = '77338' ,`RoomCount` = '13' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Fiorella' ,`StreetNumber` = '3507' ,`StreetSuffix` = 'Way' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2847' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Four bedroom, 3 1/2 bath, two car garage, two-story home. Primary bedroom and laundry on first floor additional bedrooms bathrooms and flex space upstairs. Granite countertops in the kitchen all appliances are accounted for. Laminate flooring throughout the home. Two story staircase area, vaulted ceilings in flex space, primary bedroom and family room. Fireplace in the family room. Large covered area at back patio.' ,`Acres` = '0.1159' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 6 WERRINGTON SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '5050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '370' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'OGDEN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Werrington Sec 01' ,`TaxAmount` = '7110' ,`TaxRate` = '2.9808' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641033' WHERE `Matrix_Unique_ID` = '214415647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T23:31:30.480' ,`MLSNumber` = '19917726' ,`ListAgentFullName` = 'Cindy Boutwell' ,`ListOfficeName` = 'Boutwell Properties LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.032323' ,`Longitude` = '-95.759136' ,`PhotoCount` = '38' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '895000.00' ,`Status` = 'Active' ,`StreetName` = 'Fairhaven Falls' ,`StreetNumber` = '17911' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3958' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW! What an amazing property! Stunning Trendmaker 1.5 story home features 4-5 bedrooms, 4 full and 1 half bath, study, dining room, over-sized primary bedroom with fireplace, media room up can be 5th bedroom does have full bath and can also be a gameroom/media room. Outdoor living space is a dream! Gorgeous Pool, 4 outdoor living spaces, Outdoor kitchen with ICEMAKER, BBQ pit, sink and fridge, custom firepit area, cool decking, large wrought iron fenced area, Sonos sound system, Up-Lights in the front, additional outdoor lighting in front and back. Home has stunning Limestone flooring in entry, Custom wood vent over stove, wine rack and side cabinet around fridge, marble countertops, under cabinet lighting, built in cabinet in family room, Plantation shutters in many rooms, cameras, water softener, additional crown molding and professionally landscaped.' ,`Acres` = '0.5421' ,`Area` = '35' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 10 LAKES OF FAIRHAVEN SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '23615' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1345' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`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,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes of Fairhaven' ,`TaxAmount` = '13792' ,`TaxRate` = '2.2317' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641033' WHERE `Matrix_Unique_ID` = '214419314' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T00:20:39.373' ,`MLSNumber` = '39123865' ,`ListAgentFullName` = 'Theresa Almogabar' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.139367' ,`Longitude` = '-95.378517' ,`PhotoCount` = '28' ,`PostalCode` = '77386' ,`RoomCount` = '8' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Enchanted Timbers' ,`StreetNumber` = '3809' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2612' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 BEDROOMS+GAME ROOM+OFFICE+POOL+Falls at Imperial Oaks = PERFECT!This gem waits for you! At the entry you\'re greeted by wide walkways leading into the kitchen & living areas.Your home office is at the front of the home with two large windows facing the front yard & french doors for added privacy. The chef in your home will love cooking in this kitchen with TONS of counter space,cabinets for storage,and under-cabinet lighting. The living room is anchored by a gas fireplace and 3 large windows to see the POOL outside. The primary bedroom is spacious and features a bay window to let in tons of natural light. Primary bathroom features double sinks, a large soaking tub and separate shower. Upstairs your game room is large enough for a pool table! The secondary bedrooms are spacious and one is currently being used as a media room. Step outside into your own backyard oasis with a screened-in porch, pool and spa to play or relax, a fire pit for those cool nights, and plenty of seating areas.' ,`Acres` = '0.1443' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S504217 - FALLS AT IMPERIAL OAKS 17, BLOCK 2, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6284' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Fiberglass' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BRADLEY ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falls At Imperial Oaks' ,`TaxAmount` = '9363' ,`TaxRate` = '3.1987' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641033' WHERE `Matrix_Unique_ID` = '214459059' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T23:30:39.207' ,`MLSNumber` = '96395993' ,`ListAgentFullName` = 'Annie Pillay' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799599' ,`Longitude` = '-95.464432' ,`PhotoCount` = '13' ,`PostalCode` = '77055' ,`RoomCount` = '13' ,`ListPrice` = '1700000.00' ,`Status` = 'Active' ,`StreetName` = 'Remlap' ,`StreetNumber` = '6434' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4841' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 2022 elegant custom home showcases extravagant finishes and world class detail. Modern 5676 sqft living at its finest with an open floor plan that is perfect for entertaining and family living yet retains room boundaries. \r\nImpeccably designed with top tier finishes. Fisher & Paykel gourmet chefs range & appliances. Study with impressive entrance hall & modern floating stairs The primary bedroom features vaulted ceilings and abundant natural light. Guest room on1st floor with walk in closets. Sliding door from family room leads to an impressive loggia overlooking ample backyard space ideal for a pool. 3 bedrooms upstairs, each with ensuite bathrooms and large walk-in closets.Game room upstairs plus a large bonus room perfect for a gym, play area, media room, cr etc Pool ready,generator ready,EV ready with smart features for the modern family throughout. Must see to appreciate craftsmanship and finish. 3D rendering is just a representation to convey spatial appreciation.' ,`Acres` = '0.1865' ,`Area` = '24' ,`BuilderName` = 'MYka Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 23 BLK 23 WESTVIEW TERRACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Westview Terrace Sec 02' ,`TaxAmount` = '8085' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641033' WHERE `Matrix_Unique_ID` = '214501231' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T23:22:32.390' ,`MLSNumber` = '48019237' ,`ListAgentFullName` = 'Aishat Trevino' ,`ListOfficeName` = 'C.R.Realty' ,`SellingAgentFullName` = 'Irisnexy Regueira' ,`SellingOfficeName` = 'Lugary, LLC' ,`Latitude` = '29.845604' ,`Longitude` = '-95.788548' ,`PhotoCount` = '26' ,`PostalCode` = '77493' ,`RoomCount` = '3' ,`ListPrice` = '309999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Padova Gardens' ,`StreetNumber` = '23814' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1705' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning remodeled One-Story Home 3BD/2BA, One of the best homes in Ventana Lakes Subdivision! Gorgeous open kitchen features a large center island with breakfast bar seating, quartz countertops, subway tile backsplash, bamboo flooring, and stainless steel appliances. The floorplan is very open & spacious which includes a laundry room and an electric fireplace built into the living room wall. Ventana Lakes residents enjoy easy access to the community clubhouse, resort-style pool, splash pad, scenic lakes, walking trails, water park, and easy access to Highways.' ,`Acres` = '0.1435' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 46 BLK 1 VENTANA LAKES SEC 14' ,`LotDesciption` = 'Other' ,`LotSize` = '6250' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Venatna Lakes Sec 14' ,`TaxAmount` = '7160' ,`TaxRate` = '3.2768' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641034' WHERE `Matrix_Unique_ID` = '214584647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T23:43:20.917' ,`MLSNumber` = '69193015' ,`ListAgentFullName` = 'Mary Markwardt' ,`ListOfficeName` = 'HOUSTON TOP REALTY' ,`SellingAgentFullName` = 'Loretta Blendermann' ,`SellingOfficeName` = 'Legacy Texas Properties' ,`Latitude` = '29.499673' ,`Longitude` = '-95.442193' ,`PhotoCount` = '30' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '310000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Windy Knoll' ,`StreetNumber` = '5705' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2259' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'JUST UNPACK & MOVE IN! Lovely 4 bedroom one story with spacious open floor plan. Home has fresh custom interior paint throughout! No need for any touchups here. The living room, dining room and kitchen are open and flowing offering a great space for entertaining. Brand new luxury vinyl plank flooring and new carpet installed August, 2022. There is an ample sized covered back patio with an extended wooden deck which is the perfect setting for reading, cranking up the grill or even dancing! A little music and twinkle lights and you\'re set! No power lines on this lot. New A/C June of 2022. Lakes of Savannah offers two pools, two club houses, splash pad, parks, ponds & miles of sidewalks. Located near Hwy. 6 and Hwy. 288. Just minutes to Pearland Town Center. Neighborhood did NOT lose power during the big freeze of 2021! Welcome HOME!' ,`Acres` = '0.1589' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SAVANNAH RIDGE SEC 1 (A0403 ACH&B), BLOCK 2, LOT 36, ACRES 0' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6922' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SAVANNAH LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes of Savannah' ,`TaxAmount` = '6985' ,`TaxRate` = '3.1908' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641034' WHERE `Matrix_Unique_ID` = '214639771' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T00:16:49.140' ,`MLSNumber` = '46288431' ,`ListAgentFullName` = 'Cortney Dickens' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.769643' ,`Longitude` = '-95.232780' ,`PhotoCount` = '34' ,`PostalCode` = '77029' ,`RoomCount` = '7' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Invierno' ,`StreetNumber` = '11117' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2006' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home buyers or Investors! Super cute, cozy and well maintained home! HUGE living room addition for entertaining family and friends! Kitchen opens to view living room area. Easy access to I10 and 610 to all areas of Houston! Contact me for more information!' ,`Acres` = '0.1523' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LT 66 BLK 6 MARKET STREET GARDENS EXTN 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6634' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WHITTIER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'FURR HIGH SCHOOL' ,`SchoolMiddle` = 'HOLLAND MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Market Street Gardens Ext 02' ,`TaxAmount` = '2621' ,`TaxRate` = '2.5534' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1939' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641034' WHERE `Matrix_Unique_ID` = '214890935' --> 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','215016918','1669641034','215016918','2022-11-21T23:17:48.167','3357218','Manuel Mata','White Picket Realty LLC','','','30.203373','-95.445929','32','77385','8','450000.00','Active','Black Percher','8127','Street','Conroe','2','1','4','2880','Single-Family','You\'ll absolutely love this beautiful 4 bedroom, 2.5 bath home located in the picturesque gated community of Harper\'s Preserve! The home features hardwood floors throughout theliving areas andinto the primary bedroom. Gorgeous archways and crown molding give the home a distinguished look. The open concept of kitchen, breakfast area, and living room is perfect for entertaining. Primary bedroom features high cielings, large windows, and wood floors. Primary bath with double vanity and large walk in closet. Escape to the upstairs where you will find large gameroom/flex room with private half bath. It can easily be converted to a media room, 5th bedroom, home office, or more. The mud room is perfect for additional storage, can fit an additional refrigerator/freezer. The covered patio and stone paved slab is perfect to enjoy your back yard. Harper\'s Preserve is located only minutes from the I-45 and FM 242 intersection, shopping, and restaurants. Contact your agent today!','0.158','15','','','','','Sellers Disclosure','1','Gaslog Fireplace','1','Spring Northeast','Central Gas','1','S572702 - HARPER\'S PRESERVE 02, BLOCK 4, LOT 8','Subdivision Lot','6882','Appraisal District','','1125','0','','2','Electric Oven','0','','','Gas Range','','Composition','11 - Conroe','SUCHMA ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal','2','Traditional','Harpers Preserve 02','10350','3.0088','Water District','2013','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215019140','1669641034','215019140','2022-11-21T23:10:49.583','39966915','Chasity Bufford','The Lakes Group','','','29.732659','-95.523061','13','77063','5','342990.00','Active','Clarkcrest','9009','Street','Houston','2','0','3','1604','Single-Family','MOVE-IN READY!!! See this charming home that is located in the heart of Houston. 3 bedrooms 2 bath with a study is ready for your family. This home has new floors and windows, plumbing and underground plumbing system, new electrical, HVAC water heater, roof and more! You don\'t want to miss out on this great home.','0.124','22','','','Washer Connections','','Sellers Disclosure','1','','','Briarmeadow/Tanglewilde','Central Gas','0','LT 40 BLK 10 CARVER CREST R/P & EXTN','Subdivision Lot','5400','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','EMERSON ELEMENTARY SCHOOL (HOUSTON)','WISDOM HIGH SCHOOL','REVERE MIDDLE SCHOOL','Appointment Required,Lockbox Back','Seller','1','Traditional','Carver Crest R/P & Ext','3132','2.3307','Public Sewer,Public Water','1948','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','215019285','1669641034','215019285','2022-11-21T23:00:06.400','36208113','Mike Haman','Brookside Realty, LLC','','','29.751355','-95.565278','37','77042','5','549900.00','Active','Bordley','10706','Drive','Houston','3','1','4','3227','Single-Family','WELCOME HOME! This gorgeous home nestled in the desirable Walnut Bend subdivision has so much to offer! It has been completely remodeled. Upon entry to the home you are greeted with an abundance of natural light. The open floor plan is great for entertaining and extremely functional. The kitchen offers a sleek modern look with quartz counter tops, stainless steel appliances, gas cook-top, wine fridge, under mount sink, and subway tile backsplash. The home features a fabulous en-suite bathroom and closet for the primary with double sinks, Jacuzzi tub, separate shower, spacious closet, and a makeup vanity station. All bedrooms are spacious with large closets. The backyard offers ample space for entertaining and weekend BBQs. Separate GUEST SUITE / APARTMENT in the backyard with a full kitchen, full bath, living area, and bedroom. It’s a MUST SEE!!! Minutes away from Katy Freeway, Westheimer, and the Energy Corridor. Close proximity to shopping, dining, and much more! Never Flooded!','0.2066','31','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Freestanding','1','Briargrove Park/Walnutbend','Central Gas','1','LT 8 BLK 22 WALNUT BEND SEC 7','Subdivision Lot','9000','Appraisal District','','1172','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','27 - Houston','WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)','WESTSIDE HIGH SCHOOL','REVERE MIDDLE SCHOOL','Accompany,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Walnut Bend Sec 07','15685','2.3307','Public Sewer,Public Water','1968','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','215019393','1669641035','215019393','2022-11-22T00:00:37.270','15969986','Ivonne Beteta','ELSA Realty','','','30.142766','-95.477671','0','77380','13','529000.00','Active','Leisure','30','Lane','The Woodlands','3','1','5','3080','Single-Family','This spacious home on the golf course has beautiful views of the golf course. An abundance of natural light. Large master, complete with a bonus room that could be a study, TV room, or even a nursery. Secondary bedrooms are located on the ground, third floors, and living areas and master are on the second level. Spacious living room; this home is situated on a wooded, quiet cul-de-sac just minutes from I-45, SOLD AS IS. No survey available; buyer pays for survey. Property is subject to FRIPTA rules.','','15','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,No Disclosures,Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure','0','Freestanding','1','The Woodlands','Central Gas','0','WDLNDS MILBEND VIL 01, LOT 8','On Golf Course','5114','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','11 - Conroe','SAM HAILEY ELEMENTARY SCHOOL','THE WOODLANDS COLLEGE PARK HIGH SCHOOL','KNOX JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','3','Split Level','Wdlnds Milbend Village 01','6059','2.246','Water District','1980','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','215020460','1669641035','215020460','2022-11-22T00:18:48.803','21827508','Elissa Campbell','Lucid Realty, LLC','','','29.284997','-94.821575','14','77551','2','225000.00','Active','51st','1714','Street','Galveston','1','0','2','789','Single-Family','I would make a perfect short term rental, and am a vacationers dream. I’m a charming turn key house located a short walk from the beach and blocks from the strand. I have been recently remodeled and am as cute as can be! I have a beautiful new kitchen you should see for yourself, with quartz countertops and beautiful backsplash, it even has all new appliances. My floors are to die for, they are all hand laid. I have plenty of room and a large loft space perfect for a bunk room or a secret hideaway for the kids. You don’t want to miss me, so come see me today!','0.0574','33','','','','','Sellers Disclosure','','','','Midtown - Galveston','Central Gas','0','ABST 628 M B MENARD SUR N 50 FT OF LOTS 23 & 24 (23-1) BLK 9','Subdivision Lot','2500','Appraisal District','','','0','','0','','0','','','','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required','Appraisal District','1.5','English','Denver Resurvey','2059','2.0662','Public Sewer,Public Water','1955','Appraisal District'); --> New record created successfully