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-07T21:26:31.587' ,`MLSNumber` = '14953580' ,`ListAgentFullName` = 'Eduardo Rangel' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.970893' ,`Longitude` = '-95.611362' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '8' ,`ListPrice` = '670000.00' ,`Status` = 'Active' ,`StreetName` = 'Lismore Lake' ,`StreetNumber` = '11943' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3618' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**IMMACULATE AND PRIVATE SPA AND POOL** \r\n\r\n* RESORT/EXCLUSIVE GATED COMMUNITY!! \r\n\r\n*AWESOME WATERFRONT DREAM!! * HEATED POOL WITH SPA!!\r\n\r\n* Beautiful house with Amazing 2-story entry.\r\n \r\n* Study with French Doors and wood floors downstairs.\r\n\r\n* Kitchen with island, walk-in pantry, granite countertops and Stainless Steel appliances.\r\n\r\n* Wonderful view from the Den to the lake and the AMAZING backyard with Heated Pool and Spa!!\r\n\r\n* Wonderful balcony with view of the lake and fountains. Direct access to the lake with Boat Slip and Wooded Deck.\r\n\r\n * Game Room upstairs with 4 Bedrooms and 2 baths upstairs. note: Common Areas upstairs an first floor master bedroom.\r\n\r\n* NOTE: NEW WOOD FLOORS, AN NEW BATHROOM IN THE MASTER BEDROOM, FRESH NEW PAINT, A FEW UPDATES IN THE ENTIRE HOUSE, COME AN SEE INSIDE.' ,`Acres` = '0.1723' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas,Heat Pump,Window Unit' ,`HOAMandatory` = '1' ,`Legal` = 'LT 54 BLK 1 LISMORE LAKE ESTATES' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '7507' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Built Up,Composition,Slate,Tile' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lismore Lake Estates' ,`TaxAmount` = '10819' ,`TaxRate` = '2.7587' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924544' WHERE `Matrix_Unique_ID` = '209645748' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:37:00.637' ,`MLSNumber` = '39698033' ,`ListAgentFullName` = 'Lorannette Lewis' ,`ListOfficeName` = 'In Town Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819932' ,`Longitude` = '-95.430137' ,`PhotoCount` = '38' ,`PostalCode` = '77018' ,`RoomCount` = '9' ,`ListPrice` = '554900.00' ,`Status` = 'Active' ,`StreetName` = 'Lynette Cove Place' ,`StreetNumber` = '3510' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Lisbon is one of Sandcastle Homes\' specialty floor plans. The functional layout features three bedrooms, two full baths, and one-half bath. In addition to the spacious bedrooms, the home boasts a large multi-purpose game room located on the second level. This home in particular will have a large backyard the whole family, including the furry relatives, can enjoy! Future residents can park either in their two-car garage or in their private driveway. Move-In Ready October 2022!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Sandcastle Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 5, Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3447' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'EastJudiway Court' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924544' WHERE `Matrix_Unique_ID` = '209906232' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T22:25:13.400' ,`MLSNumber` = '10022320' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.722036' ,`Longitude` = '-95.850283' ,`PhotoCount` = '35' ,`PostalCode` = '77441' ,`RoomCount` = '4' ,`ListPrice` = '427000.00' ,`Status` = 'Active' ,`StreetName` = 'Gracefield' ,`StreetNumber` = '27723' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous neighborhood! Terrific 4 bedroom, 3 full and 1 half bathroom home with a 2 car garage. Enjoy preparing meals in this impressive kitchen equipped with ample cabinets, breakfast bar, generous counter space, stainless appliances and stylish tile backsplash. Flow into the living room featuring a cozy fireplace, perfect for entertaining. Relax in your primary suite, complete with a spacious closet and an en-suite bathroom with double sinks. Relax with your favorite drink in the fenced in backyard with lush grass. Hurry, this won’t last long! This home has been virtually staged to illustrate its potential' ,`Acres` = '0.2231' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CHURCHILL FARMS SEC 9, BLOCK 2, LOT 9' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9719' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '841' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Churchill Farms Sec 9' ,`TaxAmount` = '8404' ,`TaxRate` = '2.8745' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667924544' WHERE `Matrix_Unique_ID` = '210483643' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:34:40.540' ,`MLSNumber` = '61994977' ,`ListAgentFullName` = 'Susan Kinder' ,`ListOfficeName` = 'MV Realty Of Texas LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.164341' ,`Longitude` = '-95.077173' ,`PhotoCount` = '29' ,`PostalCode` = '77327' ,`RoomCount` = '4' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5108' ,`StreetNumber` = '77' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2095' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning home is better than new. Home comes with upgraded features, including huge backyard, built in swimming pool and a beautiful wide outside porch. You get to relax and also have a stunning view of .51 acres. Walk into a large, long driveway enough to fit 8 cars with a spacious 2 car garage. Once inside you will see a 2-story luxurious inside beautiful living room with a perfect view of the granite countered top gourmet kitchen. The kitchen features 12 feet ceilings, brand new appliances including microwave, stove and dishwasher, long granite countertop island, and a wooded tiled floor plan for the entire downstairs. You have plenty of space with 3 hallways to move back and forth to your desired location. The primary bedroom is located downstairs with an extended walk-in closet, double sink for his and hers, including shower and tub. Three more bedrooms are located upstairs along with a walk-in closet, and a full-size bathroom with a shower and tub.' ,`Acres` = '0.51' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SANTA FE, SEC 1, BLOCK 3, LOT 438, ACRES .51' ,`LotDesciption` = 'Corner' ,`LotSize` = '22216' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English' ,`Subdivision` = 'Santa Fe, Sec 1' ,`TaxAmount` = '5287' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667924544' WHERE `Matrix_Unique_ID` = '210743194' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T22:45:23.970' ,`MLSNumber` = '19663584' ,`ListAgentFullName` = 'Cathy Lakey' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.400173' ,`Longitude` = '-95.500519' ,`PhotoCount` = '36' ,`PostalCode` = '77318' ,`RoomCount` = '14' ,`ListPrice` = '729000.00' ,`Status` = 'Active' ,`StreetName` = 'Irenic Mist' ,`StreetNumber` = '337' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3203' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Abundant natural light infuses this stunning one-story home sitting on a nearly half-acre cul-de-sac lot in one of the most popular master-planned communities in Montgomery County. Same floor plan as the Highland Homes model, loaded with upgrades, and priced far less than new! The heart of the home is a fabulous white kitchen loaded with cabinet space and accented by stylish gold drawer pulls, open to the living and dining area and facing a wall of windows overlooking the extended covered patio. The primary suite offers an oversized bedroom, a sumptuous ensuite bath with double vanities flanking a soaking tub, plus a separate seated vanity, an oversized shower and a huge walk-in closet with custom built-ins. Even the secondary bedrooms are sized generously. The entertainment room has the flexibility to be a theater, billiard or game room. Also features a speaker system and private study. 13-foot ceilings and five-inch plantation shutters top off the glamorous flair of this home.' ,`Acres` = '0.4724' ,`Area` = '39' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S927100 - THE WOODLANDS HILLS 01, BLOCK 1, LOT 8' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '20576' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills 01' ,`TaxAmount` = '15390' ,`TaxRate` = '3.2823' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924544' WHERE `Matrix_Unique_ID` = '210955200' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T22:09:28.097' ,`MLSNumber` = '66355828' ,`ListAgentFullName` = 'Crystal Mooney' ,`ListOfficeName` = '316 Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.687641' ,`Longitude` = '-95.107429' ,`PhotoCount` = '43' ,`PostalCode` = '77536' ,`RoomCount` = '7' ,`ListPrice` = '419900.00' ,`Status` = 'Active' ,`StreetName` = 'Yellowstone' ,`StreetNumber` = '1606' ,`StreetSuffix` = 'Drive' ,`City` = 'Deer Park' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3285' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This beautifully maintained 3,285 square feet home features 4 bedrooms/ 2 1/2 baths on an oversized lot in the heart of Deer Park! The primary suite is on the first floor with his/her vanities, a garden tub, separate shower, and a large walk in closet. The downstairs features a large living room with vaulted ceilings, formal dining room, a study/sitting room, a large kitchen with granite counters, breakfast area, and plenty of cabinets for storage. The upstairs features an oversized game room, 3 bedrooms, and a secondary bathroom. The backyard has a large covered patio, a 32 x 12 storage shed and a Generac generator! Some of the updates include: roof in 2017, AC in 2016 and the other one in 2021, dishwasher in 2022, bamboo floors in 2015, and hot water heater in 2020. This home won\'t last long. Schedule your showing today!' ,`Acres` = '0.2731' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 39 BLK 6 PARK PLACE SEC 6 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11898' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'DEER PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'DEER PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Place Sec 06 R P' ,`TaxAmount` = '10166' ,`TaxRate` = '2.8239' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924545' WHERE `Matrix_Unique_ID` = '212038080' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:34:46.653' ,`MLSNumber` = '31787733' ,`ListAgentFullName` = 'Dawn Bajalieh' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.044042' ,`Longitude` = '-95.360496' ,`PhotoCount` = '39' ,`PostalCode` = '77373' ,`RoomCount` = '8' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Summergate' ,`StreetNumber` = '23106' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1374' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is in process of deep cleaning, painting, minor makeready repairs.' ,`Acres` = '0.1515' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 74 BLK 5 FAIRFAX SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MILDRED JENKINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairfax Sec 01' ,`TaxAmount` = '3851' ,`TaxRate` = '2.9367' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924545' WHERE `Matrix_Unique_ID` = '212178108' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T22:28:11.733' ,`MLSNumber` = '35445712' ,`ListAgentFullName` = 'Brenda Estes' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.067195' ,`Longitude` = '-95.537347' ,`PhotoCount` = '42' ,`PostalCode` = '77379' ,`RoomCount` = '11' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Saddle Tree' ,`StreetNumber` = '7315' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AWESOME ALL BRICK ONE STORY 4 BEDROOMS 3 BATHS PLUS OFFICE/PLAYROOM AND DINING ROOM! GREAT UPDATED KITCHEN WITH QUARTZITE COUNTERTOPS AND BACKSPLASH! SPACIOUS PRIMARY BEDROOM WITH ENSUITE BATH! LARGE COVERED PATIO! WOOD LOOK TILE FLOORS THROUGHOUT! GREAT CONDITION! NO BACK NEIGHBORS! KLEIN SCHOOLS AWESOME POOL, SPLASH PAD, CLUBHOUSE, DOG PARK, WALKING TRAILS AND PUTTING GREEN! GREAT PLACE TO CALL HOME FOR YOUR FAMILY! HURRY WON\'T LAST!' ,`Acres` = '0.1494' ,`Area` = '14' ,`BuilderName` = 'Hallmark' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 LAUREL PARK NORTH SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6510' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '990' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MUELLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Laurel Park North Sec 3' ,`TaxAmount` = '9513' ,`TaxRate` = '3.2565' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924545' WHERE `Matrix_Unique_ID` = '212254088' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:39:55.227' ,`MLSNumber` = '81288323' ,`ListAgentFullName` = 'Julia Pecina' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.903352' ,`Longitude` = '-95.731344' ,`PhotoCount` = '20' ,`PostalCode` = '77433' ,`RoomCount` = '4' ,`ListPrice` = '439900.00' ,`Status` = 'Active' ,`StreetName` = 'Tuskin Oaks' ,`StreetNumber` = '20730' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2731' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home sweet home! Gorgeous subdivision that offers several amenities, lush landscaping, gated privacy and a community lake. Once inside your new home, you\'ll notice wide hallways, high ceilings and an open floor plan. The seller has done many thoughtful upgrades including: upgraded appliances, porcelain tile floors, automatic shades, and new lighting fixtures. The massive island can easily fit 4-5 bar stools and the kitchen opens up to the living room and breakfast area. The formal dining room is spacious and right off the main living space. Study/office makes for a great fourth bedroom or media room. Primary suite is LARGE and provides additional access to the backyard. The back yard is huge (9,000 sq ft lot), great for play and entertaining with it\'s outdoor grilling space, lights, and 2 covered patios. Conveniently located near entertainment, Cypress Spring High School, a daycare, and great restaurants. Imagine your life in this booming part of Cypress. Schedule your showing today!' ,`Acres` = '0.2066' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 2 CANYON LAKES WEST SEC 3 & SEC 7 2ND PAR R/P' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Canyon Lakes West Sec 3 & 7 Pt' ,`TaxAmount` = '9789' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924545' WHERE `Matrix_Unique_ID` = '212990791' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T22:37:54.093' ,`MLSNumber` = '54771873' ,`ListAgentFullName` = 'MeiMei JamesOu' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.712831' ,`Longitude` = '-95.823760' ,`PhotoCount` = '49' ,`PostalCode` = '77494' ,`RoomCount` = '13' ,`ListPrice` = '1380000.00' ,`Status` = 'Active' ,`StreetName` = 'Prescott Glen' ,`StreetNumber` = '10410' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5101' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely gorgeous custom home offers a SPARKLING POOL & OUTDOOR KITCHEN With wet bar, situated on a large lot in desirable GATED community RESERVE@SPRING LAKE. Spectacular front elevation, impressive double door leads to a grand foyer with high ceilings, it is elegant & welcoming. Excellent floor plan, Many features, upgrades & updates. quality construction with attention to details. Elegant arches, tray ceilings, crown moldings & high ceilings throughout. amazing island kitchen, wood floor in the entire home except Media room &tiles in wet areas, wine cellar with iron door & cooler, two bedrooms down with 2 full bathrooms & half bath, one of the bathroom by backdoor can use as a pool bathroom. two kitchens, 4 car garages with extra big space, new interior paint & new paint in kitchen & master, new pool pump & computer control panel board. large balcony with beautiful view of pool/backyard. Big two story cover patio area, Shows beautifully like a model home. Come to see today!' ,`Acres` = '0.3535' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH SOUTHWEST SEC 21, BLOCK 4, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1795' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'STANLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'SEVEN LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Cinco Ranch Southwest Sec 21' ,`TaxAmount` = '25792' ,`TaxRate` = '2.7045' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924545' WHERE `Matrix_Unique_ID` = '213468542' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T22:15:24.843' ,`MLSNumber` = '76022376' ,`ListAgentFullName` = 'Christian Strong' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = 'Isaias Contreras' ,`SellingOfficeName` = 'Keller Williams Signature' ,`Latitude` = '29.648163' ,`Longitude` = '-95.736458' ,`PhotoCount` = '45' ,`PostalCode` = '77406' ,`RoomCount` = '6' ,`ListPrice` = '280000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Clara Lake' ,`StreetNumber` = '2010' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1696' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This amazing one story Perry Home with sought after oversized detached garage in a cul-de-sac street has a charming curb appeal and nice landscaping! LOTS OF RECENT UPGRADES! Your new home already has a 26-PANEL SOLAR SYSTEM installed on Nov. 2019! FULLY PAID by Seller- $36,400. NEW 30-year Roof installed in 2018 -$9,700. NEW CARPET AND INTERIOR PAINT FROM CEILINGS TO BASEBOARDS -Sept 2022 -$9,800. NEW Locks, Backyard limestone gravel -2020. NEW Stainless Steel Kitchen Appliances - 2019. Ceiling fans-2017-2019. Exterior paint, Built in home theater cabinet+shelves, Wood decking and Outdoor speakers at the Spa area -2018. Replaced Fences -2017. Living room surround sound -2015, Outdoor Spa -2012. Convenient location between Sugar Land and Katy with easy access to Grand Parkway 99. Waterside Estates is a desirable neighborhood with lakes, trails, playgrounds, pool, & tennis court. Close to shopping and restaurants. LOW PROPERTY TAX 2.29% HELPS SAVE YOU MONEY!' ,`Acres` = '0.1668' ,`Area` = '37' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WATERSIDE ESTATES SEC 11, BLOCK 4, LOT 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7265' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OAKLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Waterside Estates Sec 11' ,`TaxAmount` = '4584' ,`TaxRate` = '2.2929' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924546' WHERE `Matrix_Unique_ID` = '213471851' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:15:22.460' ,`MLSNumber` = '74991802' ,`ListAgentFullName` = 'Helen Pac Franco' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780575' ,`Longitude` = '-95.429755' ,`PhotoCount` = '44' ,`PostalCode` = '77007' ,`RoomCount` = '4' ,`ListPrice` = '555500.00' ,`Status` = 'Active' ,`StreetName` = 'Petty' ,`StreetNumber` = '5934' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2345' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Modern Architecture located in the desirable Cottage Grove Area. This lovely, free-standing unit is completed. It has 3 bedrooms, 3.5 baths. This home features an amazing kitchen with a large island bar, quartz countertops, stainless steel appliances, and a gas range. 10 foot ceilings on every level, primary bath with dual vanities, walking shower, and spa-like tub. Engineered wood floors, double-pane sound proof windows, high efficient trane HVAC and a large Roof-Top Terrace with and amazing view to Downtown Houston. NO HOA. This home is conveniently located close to the Houston coolest Shops, Patio Cafés, Art Galleries, Trendy Eatery Places. Easy access to I-10, Five miles approx. away from Northwest of Downtown Houston, Three miles approx. away from Galleria Area and River Oaks, Two miles away from Memorial Park and The Heights, Don\'t miss out!' ,`Acres` = '0.0339' ,`Area` = '9' ,`BuilderName` = 'Clariss Group LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cottage Grove' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 TOWNHOMES AT PETTY STREET' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Townhomes/Petty Street' ,`TaxAmount` = '1822' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924546' WHERE `Matrix_Unique_ID` = '213490533' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:11:49.837' ,`MLSNumber` = '66960926' ,`ListAgentFullName` = 'Christopher Boyles' ,`ListOfficeName` = 'CB Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.122161' ,`Longitude` = '-95.245316' ,`PhotoCount` = '22' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Heritage Forest' ,`StreetNumber` = '21324' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great 1-Story home located in the highly sought-after Valley Ranch Master Planned Community. Plan includes 3 bedrooms, 2 baths and 2 car garage. Large Living Room open to the kitchen with breakfast bar & breakfast room. Spacious primary bedroom with ensuite bathroom complete with separate tub and shower, double sinks, and large walk-in closet. Split plan offers privacy for all! Features include 10-foot ceilings, wood-like flooring, gas cooking, covered patio! This community also offers a beautiful splash pad and resort-style pool! Convenient access to 59, IAH, Downtown Houston, the Grand Parkway 99 and Valley Ranch Town Center. Don\'t miss your chance to view this beautiful home!' ,`Acres` = '0.1544' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S941203 - VALLEY RANCH 03, BLOCK 3, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6724' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'VALLEY RANCH ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW CANEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Valley Ranch 03' ,`TaxAmount` = '6290' ,`TaxRate` = '3.2331' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924546' WHERE `Matrix_Unique_ID` = '213794476' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:13:19.660' ,`MLSNumber` = '30864543' ,`ListAgentFullName` = 'Orey Lamai' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.463770' ,`Longitude` = '-95.471079' ,`PhotoCount` = '15' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '339998.00' ,`Status` = 'Active' ,`StreetName` = 'Wainwright' ,`StreetNumber` = '8302' ,`StreetSuffix` = 'Way' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Agents, Homebuyers, do not let this rare find pass you by! 5 bedrooms, 3.5 baths, and study.\r\n \'SMART HOME\' in Southern Colony. This 2-story NEWMARK home is UPDATED & 100% ready to move in! The kitchen is a chef\'s dream with 42\"cabinets, QUARTZ Countertops, and STAINLESS-STEEL APPLIANCES. Gas Stove and Sink. ENGINEERED WOOD throughout the first floor, including the primary, adds warmth and sophistication. RING, KEYLESS Entry lock, & Security Cameras come with the home! Large Open concept family room keeps you connected to loved ones! The oversized Master Bedroom offers a wonderful retreat after a day\'s work. The primary Bathroom has double vanity sinks, a shower, a garden tub, and a HUGE walk-in closet. Four spacious bedrooms upstairs with a game room make this home complete for your family. A NEW WATER HEATER. ZONED TO SIENNA/FBISD SCHOOLS. <> This home will go fast! Priced to SELL. Schedule an appointment today!' ,`Acres` = '0.1157' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHERN COLONY SEC 1, BLOCK 3, LOT 37' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southern Colony Sec 1' ,`TaxAmount` = '6434' ,`TaxRate` = '3.1329' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924546' WHERE `Matrix_Unique_ID` = '213934234' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:35:42.860' ,`MLSNumber` = '4687942' ,`ListAgentFullName` = 'James Dickerson' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.028557' ,`Longitude` = '-95.154307' ,`PhotoCount` = '32' ,`PostalCode` = '77346' ,`RoomCount` = '9' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Atascocita Point' ,`StreetNumber` = '21310' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2421' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Its Fall So Come See This Lovely Home and Fall in Love! The Home Is Setting on 2 Big Lots. \r\nLooking for a new home - this is it! ATASCOCITA SHORES WITH ACCESS TO MARINA, PICKLE BALL & TENNIS COURTS, 2 COMMUNITY POOLS! Golf course in Subdivision! Wood tile floors, quartz countertops, stunning glass backsplash, smooth top cooktop, microwave, oven, pot filler, farmhouse sink, oversized island! Kitchen open to family room & breakfast room! DEN/DINING ROOM W/GAS LOG FIREPLACE! Primary bath w/vessel sinks, whirlpool tub & separate shower w/stunning tile, huge walk in primary closet w/closet system! Complete your apartment over the garage/ mother-in-law suite and below is 11x12 storage room OR WORKSHOP/DARKROOM in 3 car garage!\r\n\r\n 1 STORY - GORGEOUS - 2 LOTS! HIGH END REMODEL! 4 BEDROOM, 3 CAR GARAGE, GAMEROOM OR APARTMENT OVER GARAGE 200sqft that is not included in the size of the home!' ,`Acres` = '0.2711' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LTS 14 & 15 BLK 11 ATASCOCITA SHORES SEC 4' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '11808' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita Shores Sec 04' ,`TaxAmount` = '4327' ,`TaxRate` = '2.216' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924547' WHERE `Matrix_Unique_ID` = '213938287' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:09:13.000' ,`MLSNumber` = '43883466' ,`ListAgentFullName` = 'Ashley Zuniga' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.829353' ,`Longitude` = '-95.692278' ,`PhotoCount` = '26' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Wood Glen' ,`StreetNumber` = '18711' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1997' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this three bedroom, two bathroom home. As you enter in the front door you are welcomed by open and spacious living room with natural light. In the kitchen has a gas range, refrigerator, double sink, granite counter. Big backyard with a patio porch and a newly built shed. Since the garage has central A/C it can be converted into a game room or an additional room. Zoned to Katy ISD. Home has NEVER FLOODED! Property Is Selling AS IS!' ,`Acres` = '0.1566' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 168 BLK 6 ROLLING GREEN SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '6820' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SCHMALZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CARDIFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Rolling Green Sec 01' ,`TaxAmount` = '4558' ,`TaxRate` = '2.587' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924547' WHERE `Matrix_Unique_ID` = '213982093' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:29:28.500' ,`MLSNumber` = '42325944' ,`ListAgentFullName` = 'April Lorenz' ,`ListOfficeName` = 'Zuri Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.689168' ,`Longitude` = '-95.342885' ,`PhotoCount` = '29' ,`PostalCode` = '77021' ,`RoomCount` = '4' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Gren' ,`StreetNumber` = '5107' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1509' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely 4 bedroom one story home, move in ready. Neutral colors walls and flooring throughout, no carpet. You\'ll love the kitchen that offers tons of counter space. Spacious bedrooms and large closets with lighting. Large backyard with extra storage. Close to Medical Center, U of H, Hobby Airport, and Reliant Stadium.' ,`Acres` = '0.1329' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 154 BLK 6 MACGREGOR TERRACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5791' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HARTSFIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Macgregor Terrace Sec 01' ,`TaxAmount` = '3247' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924547' WHERE `Matrix_Unique_ID` = '214000037' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:30:41.040' ,`MLSNumber` = '23817910' ,`ListAgentFullName` = 'April Lorenz' ,`ListOfficeName` = 'Zuri Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.668399' ,`Longitude` = '-95.321649' ,`PhotoCount` = '27' ,`PostalCode` = '77033' ,`RoomCount` = '3' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Ridgeway' ,`StreetNumber` = '6143' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1873' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this lovely one story home with so much to offer. Large living areas and open floor plan. Tile throughout home. Bedrooms are large with huge closets that offer lighting. Upgraded bathrooms. Large backyard with plenty of room. Close to UofH, Hobby Airport, Medical Center, and Reliant Stadium.' ,`Acres` = '0.1501' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 42 EDGEWOOD SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6540' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALCOTT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Edgewood Sec 09' ,`TaxAmount` = '3944' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924547' WHERE `Matrix_Unique_ID` = '214001355' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:37:34.457' ,`MLSNumber` = '28111982' ,`ListAgentFullName` = 'Marilyn Carson' ,`ListOfficeName` = 'CORCORAN FERESTER REALTY' ,`SellingAgentFullName` = 'Clarissa Michaels' ,`SellingOfficeName` = 'C & S Premier Realty' ,`Latitude` = '30.146828' ,`Longitude` = '-95.553914' ,`PhotoCount` = '50' ,`PostalCode` = '77375' ,`RoomCount` = '10' ,`ListPrice` = '670000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Twin Ponds' ,`StreetNumber` = '31' ,`StreetSuffix` = 'Court' ,`City` = 'Tomball' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Darling home located on large quiet cul-de-sac lot with no back neighbors with covered patio with fireplace! This home is move in ready and is within walking distance to Creekside Parks many amenities including Theater, HEB, restaurants, exercise, elementary and middle schools, parks, pools and more. The home features gorgeous hardwood floors throughout downstairs, high ceilings, Plantation Shutters, formal dining, mud room area, a secondary bedroom or office down with full bath, Amazing white kitchen open to family room with huge island workspace, double ovens, gas cooktop, quartz counters and walk in pantry. The primary suite features high ceilings, wall of windows, executive bath with his and hers vanities, soaking tub and walk in shower. Upstairs there are 3 large secondary beds, one with ensuite bath, two that share a bath, large game room and separate media room. There is also a 2.5 car attached garage which includes a separate storage area.' ,`Acres` = '0.2764' ,`Area` = '14' ,`BuilderName` = 'Darling' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Exclusions,Mud,Other Disclosures,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 THE WOODLANDS CREEKSIDE PARK WEST 10' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Wooded' ,`LotSize` = '12041' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CREEKVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodlands Creekside Park West' ,`TaxAmount` = '11296' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924547' WHERE `Matrix_Unique_ID` = '214039038' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:11:32.117' ,`MLSNumber` = '11279581' ,`ListAgentFullName` = 'Carrie Farmer' ,`ListOfficeName` = 'All City Real Estate, Ltd. Co.' ,`SellingAgentFullName` = 'Shaju Thomas' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '29.742546' ,`Longitude` = '-95.825339' ,`PhotoCount` = '22' ,`PostalCode` = '77494' ,`RoomCount` = '4' ,`ListPrice` = '499900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Snowy Egret Dr' ,`StreetNumber` = '2203' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3265' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 story 4 Bedroom 3 1/2 Bath home in the small community of Hawks Landing. This home features a grand staircase entry way with two Juliette balconies, a large open concept living area with 22 ft ceilings. The kitchen welcomes all chefs with double ovens and a large walk in pantry. Upstairs hosts a large game and media room perfect for entertaining. Outside the covered patio conveys comfort with stamped concrete floors and string lights that provide a warm ambiance. There is also plenty of room for out door play in this large backyard. Other features of this home include a reverse osmosis water softener, additional garage lighting, updated wood look tile in living room and study as well as fresh paint through out the downstairs. Zoned to award winning Katy ISD schools this home has tons to offer!' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Hawks Landing Sec 1, BLOCK 2, Lot 28' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7410' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '785' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOODCREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'TAYS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hawks Landing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667924548' WHERE `Matrix_Unique_ID` = '214150963' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T22:10:01.980' ,`MLSNumber` = '79517508' ,`ListAgentFullName` = 'James Pitman' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.724212' ,`Longitude` = '-95.367777' ,`PhotoCount` = '24' ,`PostalCode` = '77004' ,`RoomCount` = '6' ,`ListPrice` = '474900.00' ,`Status` = 'Active' ,`StreetName` = 'Rosewood' ,`StreetNumber` = '2801' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1999' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Have you ever wondered what it would be like to live within 10 minutes of everything? Herman park, the zoo, Downtown/Toyota Center, Museum District, Medical Center, Greenway Plaza, Midtown, Montrose, NRG stadium, and literally hundreds of restaurants are all within 10 minutes of this meticulously updated home. This turnkey smart home will impress from the moment you walk through the arched front door. You will love the spacious feeling you get from the 10\' ceilings and your eyes will be drawn to the designer elements throughout the kitchen and baths. The roof, HVAC, plumbing, and foundation were all replaced or upgraded during the renovation. Additionally, a new privacy fence and electric gate were just installed. May this home be your new sanctuary deep in the heart of Houston.' ,`Acres` = '0.1687' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 & TR 21 BLK 31 WASHINGTON TERRACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '7350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Washington Terrace' ,`TaxAmount` = '8437' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1942' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924548' WHERE `Matrix_Unique_ID` = '214183124' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:00:39.680' ,`MLSNumber` = '73210313' ,`ListAgentFullName` = 'Roman Rodriguez' ,`ListOfficeName` = 'Green Residential' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.726950' ,`Longitude` = '-95.502448' ,`PhotoCount` = '41' ,`PostalCode` = '77063' ,`RoomCount` = '9' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = 'Freshmeadows' ,`StreetNumber` = '3515' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2293' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Seller offering $5K to buy down rate with valid offer* Gorgeous 3 bedroom, 2.5 bath property located in Briarwood Subdivision. The property has been updated through most major ticket items. The home has a low age A/C, foundation repair with warranty ($125 to transfer), updated flooring, updated bathroom, and other details that you will love. As you enter the home, you are greeted by a spacious and elegant den that flows into the large formal dining space. Hand-sculpted wood flooring gives a timeless aesthetic. The living room has beautiful vaulted, beamed ceilings, a cozy brick fireplace (gas or wood), and built in shelving. Kitchen has been renovated with 2 toned cabinetry, granite countertops, and gorgeous backsplash. Updated flooring throughout the home. Guest bedroom was converted into second primary bedroom and is attached to the renovated bathroom. The bedroom also has an attached secondary room that has so many possibilities. 3 car detached garage. This property is a must see!' ,`Acres` = '0.2388' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briarmeadow/Tanglewilde' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 17 BRIARMEADOW SEC 1 PAR R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '10400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '762' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PINEY POINT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarmeadow Sec 1 Pt Rp' ,`TaxAmount` = '9258' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924548' WHERE `Matrix_Unique_ID` = '214190707' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:43:17.133' ,`MLSNumber` = '21553898' ,`ListAgentFullName` = 'Anh Tran' ,`ListOfficeName` = 'ABSOLUTE Realty Group Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.698615' ,`Longitude` = '-95.682206' ,`PhotoCount` = '18' ,`PostalCode` = '77083' ,`RoomCount` = '3' ,`ListPrice` = '254900.00' ,`Status` = 'Active' ,`StreetName` = 'Espinosa' ,`StreetNumber` = '16742' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1175' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This cozy 3 bedroom, 2 bath, 1 story, newer built home in Mission West is ready for you to call it home! Home features open concept floorplan with lots of natural lights. The new kitchen comes with soft-closed cabinets, quartz countertop and SS appliances. New vinyl and tile floorings. Fresh interior/exterior paints. Beautifully updated bathrooms. New Roof. New ceiling fans and light fixtures. Zoned to desired Fort Bend schools, just minutes from the Westpark Tollway. Never flooded. Hurry! You don’t want to miss this adorable home.' ,`Acres` = '0.1374' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MISSION WEST SEC 1, BLOCK 5, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5986' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MISSION WEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Mission West Sec 1' ,`TaxAmount` = '4862' ,`TaxRate` = '2.4297' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924548' WHERE `Matrix_Unique_ID` = '214211032' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:54:27.573' ,`MLSNumber` = '7109034' ,`ListAgentFullName` = 'Beth Cassidy' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799913' ,`Longitude` = '-95.420216' ,`PhotoCount` = '19' ,`PostalCode` = '77008' ,`RoomCount` = '5' ,`ListPrice` = '630000.00' ,`Status` = 'Active' ,`StreetName` = '16th' ,`StreetNumber` = '1205' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2636' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you\'re looking for a custom quality design, this is it! Enjoy convenience & luxury in Shady Acres! Located minutes from 610 & local dining, with easy access to downtown attractions. This home features a beautiful front elevation, open floor plan on second floor with large windows & high ceilings, which allow in plenty of natural light! Featuring designer finishes, including wood floors throughout, 2nd floor balcony, marble island & breakfast bar. Fourth floor flex room has floor to ceiling windows & sliding glass doors that open to rooftop terrace with views of downtown. This home will surely not disappoint!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lt 3 Blk 1 Georgetown Heights' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2027' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Georgetown Heights' ,`TaxAmount` = '9323' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924549' WHERE `Matrix_Unique_ID` = '214274303' --> 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','214295314','1667924549','214295314','2022-11-07T22:44:41.820','30805291','Chawannia OConner','O\'Conner Fine Properties','','','29.848034','-95.804547','0','77493','5','430000.00','Active','Rue Dela Croix','5014','Drive','Katy','3','1','4','3168','Single-Family','Only a few years young, this Pulte Home is located in the beautiful and quite community of Kings Crossing. This home features two-story ceilings in the gathering room, a built in office nook downstairs, and a spacious covered patio. The second floor game room, ideal for a kids\' play space or media room adds flex space upstairs. Front and backyard sprinklers and a half bath downstairs check more boxes on your home purchase list. Lovely wood style tiled flooring and a Kitchen island with Granite countertop open to the family room. Enjoy the ease of access to the highways for commute and shopping. Schedule a tour today!','0.126','25','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Katy - Old Towne','Central Gas','1','LT 20 BLK 1 KING CROSSING SEC 10','Subdivision Lot','5490','Appraisal District','','880','0','','2','','0','','','','','Composition','30 - Katy','BETHKE ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','STOCKDICK JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,No Supra Keybox','Appraisal District','2','Traditional','King Xing Sec 10','10836','3.4768','Public Sewer','2018','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','214311118','1667924549','214311118','2022-11-07T21:20:51.343','41945061','Briseida Hinojosa','Rivich Realty','','','29.993890','-95.603135','27','77070','9','335000.00','Active','Willow Branch','15123','Drive','Houston','2','1','4','2740','Single-Family','Adorable 2 story 4 bedroom, 2.5 bathrooms, 2 car garage home in HEATHERWOOD VILLAGE. Spacious kitchen with island cooktop and counter seating. Loads of cabinet storage and counter space. Tiled 1st floor with lovely laminate in Primary bedroom. Separate shower, jetted garden tub and dual vanities. 3 very spacious bedrooms and game room on 2nd floor. Back yard ideal for entertainment and BBQ\'s, deck along the entire back of home. Zoned to Cypress-Fairbanks ISD and easy access to 249 and Sam Houston.','0.1848','10','','','','','Sellers Disclosure','1','','1','Cypress North','Central Gas','1','LT 13 BLK 7 HEATHERWOOD VILLAGE SEC 1 R/P','Subdivision Lot','8050','Appraisal District','','375','0','','2','','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','MOORE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS CREEK HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Heatherwood Village','7327','2.5197','Water District','1999','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:28:06.213' ,`MLSNumber` = '54126533' ,`ListAgentFullName` = 'Colleen Pye' ,`ListOfficeName` = 'RE/MAX Elite Properties' ,`SellingAgentFullName` = 'Omran Sultan' ,`SellingOfficeName` = 'THE BROKER Real Estate Firm' ,`Latitude` = '29.802445' ,`Longitude` = '-95.354870' ,`PhotoCount` = '30' ,`PostalCode` = '77009' ,`RoomCount` = '8' ,`ListPrice` = '225000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Evelyn' ,`StreetNumber` = '1310' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1272' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ryon.. wow, so much growth.Some much regentrification. Convenient location, so much new construction surrounding this lot.' ,`Acres` = '0.1435' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 119 RYON' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOOSCAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ryon' ,`TaxAmount` = '3199' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924549' WHERE `Matrix_Unique_ID` = '214318982' --> 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','214337179','1667924549','214337179','2022-11-07T22:59:35.470','62966487','My Nguyen','BHGRE Gary GreeneLeague City','','','29.546654','-95.054188','32','77565','12','1375000.00','Active','Appia','602','Drive','Kemah','3','1','4','3446','Single-Family','BOATER’S DREAM! EXPERIENCE TRUE ELEGANCE AND CRAFTSMANSHIP W/THIS STUNNING NEW CONSTRUCTION. 100’+ WATERFRONT, CUL-DE-SAC LOT W/BOATHOUSE! DEEP WATER ACCESS TO CLEAR LAKE & GALVESTON BAY. DBL DOORS OPEN TO THE FOYER W/SOARING 20’ CEILINGS. THIS HOME BOASTS LUXURY FINISHES THROUGHOUT THE FML LIVING, STUDY, FRML DINING, CHEF\'S KITCHEN W/ FISHER & PAYKEL DBL 30” BUILT-IN OVENS, 36”GAS RANGE-TOP W/6 BURNERS,DBL DISHWASHER DRAWER. ALL STAINLESS W/QUARTZ COUNTERTOPS.4 SPACIOUS BDRM & 3.1 BEAUTIFULLY FINISHED BATHS.PRIMARY BDRM ON 1ST LEVEL. ENJOY THE VIEW FR THE BALCONY OR COVERED VERANDA W/OUTDOOR KITCHEN. APPROXIMATELY 550SF OF COVERED OUTDOOR LIVING. PERFECT FOR ENTERTAINING! 3 CAR OVERSIZED GARAGE.EXCELLENT CONSTRUCTION W/ALL STUCCO EXTERIOR,BELL BOTTOM PIER FOUNDATION,TANKLESS WATER HEATER,HURRICANE RATED WINDOWS & MUCH MORE.','','33','ANS Construction','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Gas Connections','1','League City','Central Gas','1','CYPRESS BAY SEC 1 (2009) ABST 18, BLOCK 2, LOT 22','Cul-De-Sac,Subdivision Lot,Water View,Waterfront','12078','Appraisal District','','3100','1','Never Lived In','3','Gas Oven','0','','','Gas Range','','Composition','9 - Clear Creek','STEWART ELEMENTARY SCHOOL (CLEAR CREEK)','CLEAR FALLS HIGH SCHOOL','BAYSIDE INTERMEDIATE SCHOOL','Appointment Required','Builder','2','Traditional','Cypress Bay Sec 1 2009','','2.25','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214341585','1667924549','214341585','2022-11-07T21:30:50.977','51019070','My Nguyen','BHGRE Gary GreeneLeague City','','','29.548559','-95.053350','32','77565','12','1425000.00','Active','Amalfi','502','Drive','Kemah','3','1','4','3446','Single-Family','BOATER’S DREAM! EXPERIENCE TRUE ELEGANCE AND CRAFTSMANSHIP W/THIS STUNNING NEW CONSTRUCTION. 100’+ WATERFRONT, CUL-DE-SAC LOT W/BOATHOUSE! DEEP WATER ACCESS TO CLEAR LAKE & GALVESTON BAY. DBL DOORS OPEN TO THE FOYER W/SOARING 20’ CEILINGS. THIS HOME BOASTS LUXURY FINISHES THROUGHOUT THE FML LIVING, STUDY, FRML DINING, CHEF\'S KITCHEN W/ FISHER & PAYKEL DBL 30” BUILT-IN OVENS, 36”GAS RANGE-TOP W/6 BURNERS,DBL DISHWASHER DRAWER. ALL STAINLESS APPLIANCES W/QUARTZ COUNTERTOPS.4 SPACIOUS BDRM & 3.1 BEAUTIFULLY FINISHED BATHS.PRIMARY BDRM ON 1ST LEVEL. ENJOY THE VIEW FR THE BALCONY OR COVERED VERANDA W/OUTDOOR KITCHEN. APPROXIMATELY 550SF OF COVERED OUTDOOR LIVING SPACE. PERFECT FOR ENTERTAINING! 3 CAR OVERSIZED GARAGE.EXCELLENT CONSTRUCTION W/ALL STUCCO EXTERIOR, CUSTOM BELL BOTTOM PIER FOUNDATION,TANKLESS WATER HEATER,HURRICANE RATED WINDOWS & MUCH MORE.','','33','ANS Construction','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Gas Connections','1','League City','Central Gas','1','CYPRESS BAY SEC 3 AMND PLT (2022) ABST 18, BLOCK 1, LOT 11A,','Subdivision Lot,Water View,Waterfront','14157','Other','','3100','1','Never Lived In','3','Gas Oven','0','','','Gas Range','','Composition','9 - Clear Creek','STEWART ELEMENTARY SCHOOL (CLEAR CREEK)','CLEAR FALLS HIGH SCHOOL','BAYSIDE INTERMEDIATE SCHOOL','Accompany,Appointment Required,Vacant/Unoccupied','Builder','2','Traditional','Cypress Bay Sec 3 2010','1877','2.0697','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:15:29.463' ,`MLSNumber` = '49876236' ,`ListAgentFullName` = 'Mike Haman' ,`ListOfficeName` = 'Brookside Realty, LLC' ,`SellingAgentFullName` = 'Jen Nguyen' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.682679' ,`Longitude` = '-95.678500' ,`PhotoCount` = '35' ,`PostalCode` = '77083' ,`RoomCount` = '4' ,`ListPrice` = '319900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Fredericksburg' ,`StreetNumber` = '8423' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2809' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This beautiful home is nestled in the quiet community of Keegans Ridge. Upon entry you are greeted with soaring high ceilings and an abundance of natural light. Open concept floor plan that naturally flows through the home. Living and dining area are great for gatherings and entertaining. The fireplace in the living room is a nice touch for the holidays. The spacious primary bedroom is located on the first floor with an en-suite bathroom, dual sinks, and a large closet. The remaining spacious bedrooms are located on the second floor, and all offer generous sized closets. The game room upstairs is a bonus and can be used as a flex space or office space. Conveniently located near Highway 6, FM 1464, and the Westpark Tollway, close to shopping, schools, and dining. Fresh paint throughout the home! Well Maintained and Move in Ready! NEVER FLOODED! MUST SEE!!' ,`Acres` = '0.1334' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'KEEGANS RIDGE SEC 1, BLOCK 1, LOT 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5813' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '335' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MISSION GLEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'HODGES BEND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Keegans Ridge Sec 1' ,`TaxAmount` = '5627' ,`TaxRate` = '2.5157' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924549' WHERE `Matrix_Unique_ID` = '214344647' --> 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','214355549','1667924549','214355549','2022-11-07T21:25:30.793','56719756','Celestine Moore','RE/MAX Integrity','','','29.723412','-95.612593','0','77082','9','240000.00','Active','Briar Knoll','3420','Drive','Houston','2','0','3','1760','Single-Family','STOP RENTING!. Lots of Potential SOLD AS IS. 1-Story large 7,050 sqft Corner living in Westpark Village has brick fireplace, nicely manicured yard, cozy 3 bedroom, 2 bath, 2 car garage. Offer an open dining, breakfast and den to enjoy family time. New Heating, New Roof, New hot water heater, AC 5 years, home is centrally located to Westpark toll, Beltway 8, Galleria, Memorial, I-10. Good schools nearby. Don\'t miss an opportunity to make this home yours today. NO FLOODING Here!','0.1618','31','','','Electric Dryer Connections,Gas Dryer Connections','','Other Disclosures,Sellers Disclosure','1','Freestanding,Wood Burning Fireplace','1','Alief','Central Electric','1','LT 37 BLK 2 WESTPARK VILLAGE SEC 1','Corner','7050','Appraisal District','','300','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','2 - Alief','HEFLIN ELEMENTARY SCHOOL','AISD DRAW','O\'DONNELL MIDDLE SCHOOL','Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Westpark Village Sec 01','4331','2.4411','Public Water','1978','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T22:42:10.753' ,`MLSNumber` = '87941200' ,`ListAgentFullName` = 'Dane Gates' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.146842' ,`Longitude` = '-95.673393' ,`PhotoCount` = '50' ,`PostalCode` = '77362' ,`RoomCount` = '8' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Majestic Shores' ,`StreetNumber` = '738' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3076' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Truly STUNNING Drees Custom Home located in the beautiful, amenity rich, Woodtrace community! 3 Bed/3 Bath home with Oversized Garage that backs to a serene nature preserve. This home shows like a model! Gourmet Kitchen w/ Huge Island, Breakfast Bar, Designer White Cabinets, Display Cabinets with Lighting, Dbl Ovens, 6 Burner Gas Range, Incredible Storage, Beautiful Quartz Countertops and Butler\'s Pantry. Open to Family Room with Exposed Beams and Panaramic Doors Overlooking The Wooded Nature Preserve. Beautiful Hardwood Floors throughout. Primary Suite with amazing bath that features a large walk in shower, soaking tub, and walk in closet. Bedroom 2 with on suite bath and Bedroom 3 with Off Suite Bath. Dedicated Study/Media Room with French Doors. Awesome covered patio with fans and integrated audio. Extremely Energy Efficient Home! Woodtrace features amenities that include a recreation center with pool, clubhouse, greenbelt, trails and 23 acre spring fed lake with fishing dock.' ,`Acres` = '0.214' ,`Area` = '15' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S959406 - WOODTRACE 06, BLOCK 1, LOT 23' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '9321' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`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' ,`TaxAmount` = '13991' ,`TaxRate` = '3.2015' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924549' WHERE `Matrix_Unique_ID` = '214418198' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T22:11:43.313' ,`MLSNumber` = '3064580' ,`ListAgentFullName` = 'Randall Peraza-Borbon' ,`ListOfficeName` = 'Vylla Home' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.986401' ,`Longitude` = '-95.954456' ,`PhotoCount` = '20' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '124900.00' ,`Status` = 'Active' ,`StreetName` = '10th' ,`StreetNumber` = '3002' ,`StreetSuffix` = 'Street' ,`City` = 'Bay City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2276' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large two story home with lots of space, for a total of 3036 Sq. Ft, of living space. Main living area one has approximately 2,276 Sq Ft. and living area two has about 760 Sq. Ft., Living area two has a large office/extra bedroom. Main living area one features three bedrooms and two bathrooms with one car port. Located not too far from Tennie Holmes Elementary. Near all amenities, shopping, and entertainment in the heart of Bay City, Texas.' ,`Acres` = '0.1091' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Real Estate Owned' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'SILVER HEIGHTS, BLOCK 6, LOT 12 (W-73\') + (S 22\' X 50\' OF LO' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4752' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Silver Heights' ,`TaxAmount` = '3436' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924550' WHERE `Matrix_Unique_ID` = '214452539' --> 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','214458450','1667924550','214458450','2022-11-07T22:17:56.847','32776014','Hai Huynh','Keller Williams Signature','','','29.962031','-95.559847','25','77070','3','265000.00','Active','Rose Landing Dr','13039','Drive','Houston','2','0','3','1650','Single-Family','Location Location Location !!! Welcome Home - to this beautiful single story 3 Bedrooms 2 bathrooms 2 Garage open concept floor plan. Freshly paint and lovely flooring through out the house. Conveniently located minutes to Willowbrook Mall, shopping centers, dinning, Costco, and Sam\'s Club. Easy access to 249, Sam Houston Tollway and FM 1960. Great Opportunity to own.','0.0918','10','','','','','Sellers Disclosure','1','','','Willowbrook South','Central Gas','1','LT 23 BLK 4 MILLS LANDING SEC 2','Subdivision Lot','4000','Appraisal District','','400','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','HANCOCK ELEMENTARY SCHOOL (CY-FAIR)','CYPRESS CREEK HIGH SCHOOL','BLEYL MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Mills Lndg Sec 02','4771','2.5842','Public Sewer,Public Water,Water District','2007','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T22:49:09.023' ,`MLSNumber` = '17053690' ,`ListAgentFullName` = 'Renita Scroggins' ,`ListOfficeName` = 'ERA Legacy Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.547260' ,`Longitude` = '-95.349939' ,`PhotoCount` = '31' ,`PostalCode` = '77584' ,`RoomCount` = '11' ,`ListPrice` = '379900.00' ,`Status` = 'Active' ,`StreetName` = 'Pebble Beach' ,`StreetNumber` = '3313' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2481' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 4-bedroom, 2.5 bath home on a beautiful lot. Welcoming entry flanked by both formals. Beautifully upgraded luxury vinyl tile floors are from the entry throughout the entire home excluding wet areas. Kitchen opens to the family room & breakfast area. Additional seating is an option at the island. Gas fireplace centers the family room. Primary suite downstairs has nice windows for great natural lighting. Primary bath has double sink vanity, jetted tub & updated separate shower. 3 bedrooms upstairs with 1 full bath. Gameroom is spacious and overlooks the backyard. Backyard offers a space for entertaining with the addition of a 14x14 deck. Replaced fence in 2020. HVAC system(s) replaced in 2016. No MUD tax. Zoned to Pearland ISD schools. Close to shopping.' ,`Acres` = '0.165' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VILLAGES OF EDGEWATER ESTATES SEC 3 (A0309 H T & B), BLOCK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7187' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '595' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SILVERLAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages Of Edgewater Estates' ,`TaxAmount` = '7350' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924550' WHERE `Matrix_Unique_ID` = '214467723' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:26:24.003' ,`MLSNumber` = '18806714' ,`ListAgentFullName` = 'John Harcrow' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.555369' ,`Longitude` = '-95.621613' ,`PhotoCount` = '40' ,`PostalCode` = '77340' ,`RoomCount` = '5' ,`ListPrice` = '222500.00' ,`Status` = 'Active' ,`StreetName` = 'Holly' ,`StreetNumber` = '5' ,`StreetSuffix` = 'Lane' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1519' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make Sam Houston Forest Estates, a Lake Conroe Community, MOVE IN READY new home by High Road Homes. *ENJOY LOW PROPERTY TAXES* Features 3/2.5/1 cul-de-sac lot w/ large backyard & many extras at this unbelievable price point! Spacious 2-story; 3 sizeable bedrooms, large living & dining room w/ an open concept kitchen, mudroom, & desirable pocket office. Notable features incl. Double Panel Insulated Low E Windows, 16 SEER HVAC System w/ Media Filter, Luxury Vinyl Wood Plank Flooring (common areas) & Mohawk Plush Carpet (bedrooms), 2\" Faux Wood Blinds, Delta Plumbing Fixtures, Sherwin Williams Paint, GE Stainless Steel Appliances, 30\" Maple Cabinetry, Structurally Engineered, Engineered Post Tension Foundation, Cemplank by James Hardie Masonry Siding, TAMKO Elite Glass-Seal Shingles, Seamless Aluminum Gutters (front of home), PEX Piping, Automatic Sprinkler System Front/Back, Garage Door Opener. Additional Home Features attached! Photos are a sample of a completed home.' ,`Acres` = '0.116' ,`Area` = '43' ,`BuilderName` = 'High Road Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'SAM HOUSTON FOREST ESTATES - SEC 2, LOT 69' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5052' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '132' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sam Houston Forest Estates Sec 2' ,`TaxAmount` = '210' ,`TaxRate` = '1.7534' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924550' WHERE `Matrix_Unique_ID` = '214494920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:09:41.110' ,`MLSNumber` = '46450256' ,`ListAgentFullName` = 'John Harcrow' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.555583' ,`Longitude` = '-95.621860' ,`PhotoCount` = '37' ,`PostalCode` = '77340' ,`RoomCount` = '5' ,`ListPrice` = '222500.00' ,`Status` = 'Active' ,`StreetName` = 'Holly' ,`StreetNumber` = '1' ,`StreetSuffix` = 'Lane' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1519' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make Sam Houston Forest Estates, a Lake Conroe Community, MOVE IN READY new home by High Road Homes. *ENJOY LOW PROPERTY TAXES* Features 3/2.5/1 cul-de-sac lot w/ large backyard & many extras at this unbelievable price point! Spacious 2-story; 3 sizeable bedrooms, large living & dining room w/ an open concept kitchen, mudroom, & desirable pocket office. Notable features incl. Double Panel Insulated Low E Windows, 16 SEER HVAC System w/ Media Filter, Luxury Vinyl Wood Plank Flooring (common areas) & Mohawk Plush Carpet (bedrooms), 2\" Faux Wood Blinds, Delta Plumbing Fixtures, Sherwin Williams Paint, GE Stainless Steel Appliances, 30\" Maple Cabinetry, Structurally Engineered, Engineered Post Tension Foundation, Cemplank by James Hardie Masonry Siding, TAMKO Elite Glass-Seal Shingles, Seamless Aluminum Gutters (front of home), PEX Piping, Automatic Sprinkler System Front/Back, Garage Door Opener. Additional Home Features attached! Photos are a sample of a completed home.' ,`Acres` = '0.1356' ,`Area` = '43' ,`BuilderName` = 'High Road Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SAM HOUSTON FOREST ESTATES - SEC 2, LOT 71' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5905' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '132' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sam Houston Forest Estates Sec 2' ,`TaxAmount` = '210' ,`TaxRate` = '1.7534' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924550' WHERE `Matrix_Unique_ID` = '214495213' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:41:06.173' ,`MLSNumber` = '30070388' ,`ListAgentFullName` = 'John Harcrow' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.556225' ,`Longitude` = '-95.621298' ,`PhotoCount` = '41' ,`PostalCode` = '77340' ,`RoomCount` = '5' ,`ListPrice` = '222500.00' ,`Status` = 'Active' ,`StreetName` = 'Dogwood' ,`StreetNumber` = '3' ,`StreetSuffix` = 'Avenue' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1519' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make Sam Houston Forest Estates, a Lake Conroe Community, MOVE IN READY new Home by High Road Homes. *ENJOY LOW PROPERTY TAXES* Features 3/2.5/1 cul-de-sac lot w/ large backyard & many extras at this unbelievable price point! Spacious 2-story; 3 sizeable bedrooms, large living & dining room w/ an open concept kitchen, mudroom, & desirable pocket office. Notable features incl. Double Panel Insulated Low E Windows, 16 SEER HVAC System w/ Media Filter, Luxury Vinyl Wood Plank Flooring (common areas) & Mohawk Plush Carpet (bedrooms), 2\" Faux Wood Blinds, Delta Plumbing Fixtures, Sherwin Williams Paint, GE Stainless Steel Appliances, 30\" Maple Cabinetry, Structurally Engineered, Engineered Post Tension Foundation, Cemplank by James Hardie Masonry Siding, TAMKO Elite Glass-Seal Shingles, Seamless Aluminum Gutters (front of home), PEX Piping, Automatic Sprinkler System Front/Back, Garage Door Opener. Additional Home Features attached! Photos are a sample of a completed home.' ,`Acres` = '0.1788' ,`Area` = '43' ,`BuilderName` = 'High Road Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'SAM HOUSTON FOREST ESTATES - SEC 2, LOT 53' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7788' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '132' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sam Houston Forest Estates Sec 2' ,`TaxAmount` = '210' ,`TaxRate` = '1.7534' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924551' WHERE `Matrix_Unique_ID` = '214495499' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:56:36.033' ,`MLSNumber` = '61023231' ,`ListAgentFullName` = 'John Harcrow' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.556191' ,`Longitude` = '-95.621487' ,`PhotoCount` = '40' ,`PostalCode` = '77340' ,`RoomCount` = '5' ,`ListPrice` = '222500.00' ,`Status` = 'Active' ,`StreetName` = 'Dogwood' ,`StreetNumber` = '1' ,`StreetSuffix` = 'Avenue' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1519' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make Sam Houston Forest Estates, a Lake Conroe Community, MOVE IN READY NEW HOME by High Road Homes. *ENJOY LOW PROPERTY TAXES* Features 3/2.5/1 cul-de-sac lot w/ large backyard & many extras at this unbelievable price point! Spacious 2-story; 3 sizeable bedrooms, large living & dining room w/ an open concept kitchen, mudroom, & desirable pocket office. Notable features incl. Double Panel Insulated Low E Windows, 16 SEER HVAC System w/ Media Filter, Luxury Vinyl Wood Plank Flooring (common areas) & Mohawk Plush Carpet (bedrooms), 2\" Faux Wood Blinds, Delta Plumbing Fixtures, Sherwin Williams Paint, GE Stainless Steel Appliances, 30\" Maple Cabinetry, Structurally Engineered, Engineered Post Tension Foundation, Cemplank by James Hardie Masonry Siding, TAMKO Elite Glass-Seal Shingles, Seamless Aluminum Gutters (front of home), PEX Piping, Automatic Sprinkler System Front/Back, Garage Door Opener. Additional Home Features attached! Photos are a sample of a completed home.' ,`Acres` = '0.1592' ,`Area` = '43' ,`BuilderName` = 'High Road Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'SAM HOUSTON FOREST ESTATES - SEC 2, LOT 54' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6934' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '132' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sam Houston Forest Estates Sec 2' ,`TaxAmount` = '210' ,`TaxRate` = '1.7534' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667924551' WHERE `Matrix_Unique_ID` = '214495794' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-07T21:41:52.303' ,`MLSNumber` = '92457296' ,`ListAgentFullName` = 'Monty Singh' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.651027' ,`Longitude` = '-95.691964' ,`PhotoCount` = '50' ,`PostalCode` = '77407' ,`RoomCount` = '10' ,`ListPrice` = '869990.00' ,`Status` = 'Active' ,`StreetName` = 'Lanarkshire' ,`StreetNumber` = '17511' ,`StreetSuffix` = 'Crossing' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3949' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'POOL!! 2 Bedrooms Down! Beautiful 5 Bed 4.5 Bath Trendmaker built home nested in renowned Aliana subdivision. Premium Lot, Stucco/Stone Elevation Foyer & 3 car garage. Stunning 2-story family room with Stone Accent Fireplace, Engineered Wood Floors, wall of windows with lots of natural light. Chefs kitchen complete with huge island, granite countertops, stainless appliances(double oven & 5-burner cooktop), pot-filler & walk-in pantry. Custom Window Treatments throughout the first floor. Spacious primary bedroom & bath with his/hers closets & oversized shower, soaking tub, separate sinks and vanity area. Study/office and second bedroom downstairs with private full bath. Upstairs Gameroom overlooks Family room, nice sized secondary bedrooms with walk-in closets. Backyard OASIS offers SPARKLING POOL, Covered patio, sprinkler system & Lush Landscaping. Highly Acclaimed Fort Bend Schools!' ,`Acres` = '0.2269' ,`Area` = '37' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'ALIANA SEC 37, BLOCK 2, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9885' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MALALA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Aliana' ,`TaxAmount` = '15874' ,`TaxRate` = '3.0329' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924551' WHERE `Matrix_Unique_ID` = '214498089' --> 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','214499157','1667924551','214499157','2022-11-07T21:03:04.007','10054910','Madison Holt','Home Topic Realty','','','29.868166','-95.470545','39','77088','3','299900.00','Active','Victory','4444','Drive','Houston','2','1','3','2197','Single-Family','Welcome home to 4444 Victory Ln. Primary bathroom BRAND NEW!! 3 BED 2.5 BATH in gated community. Featuring a private office suite, formal dining and large living area. Recessed lighting throughout home. Formal dining area with multi level ceilings, chandelier and large windows perfect for hosting family/guest. Kitchen - breakfast nook, island with cooktop, stainless steal appliances replaced in 2015. Jack-n-Jill style bathroom between bedroom 2/3 upstairs. Backyard with covered seating area. Book your tour today! **Bedroom dimensions are approximate','0.1153','11','','','','','Sellers Disclosure','1','','1','Northwest Houston','Central Gas','1','LT 29 BLK 1 HUNTINGTON PARK PAR R/P','Cul-De-Sac,Subdivision Lot','5022','Appraisal District','','500','0','','2','','0','','','','','Composition','1 - Aldine','CARAWAY ELEMENTARY SCHOOL (ALDINE)','EISENHOWER HIGH SCHOOL','HOFFMAN MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Huntington Park Prcl R/P','5331','2.5119','Public Sewer,Public Water','2002','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','214504664','1667924551','214504664','2022-11-07T21:04:35.263','96137404','Amanda Escamilla','CB&A, Realtors- Southeast','','','30.040386','-95.245355','18','77339','10','440000.00','Active','Burning Tree','1610','Road','Houston','3','0','5','2833','Single-Family','WOW, 17K lot and a 2,833 5 bedroom, 4 bath house in a very established subdivision is ready for you to call HOME! This house has been tastefully updated and upon entry you will find a living room with fireplace and large bay window. 1 primary bedroom sits on the first level along with 2 other large bedrooms and a full bath. There is a dining/kitchen combo that oversees the large covered patio. The kitchen features quartz countertops and new appliances. The utility room is adjacent to the kitchen. Upstairs you will find 2 bedrooms, 1 is another primary bedroom with HUGE primary bath and HUGE separate shower. The upstairs also has a loft area that can be transitioned anyway you wish. The exterior features a new covered patio with concrete stained flooring and a fire pit for some SMORES :) and lets not forget the NEW windows all around. It really is a MUST SEE so call today for a private showing & get in just in time for the holidays. :)','0.4063','32','','','Electric Dryer Connections,Gas Dryer Connections','','Sellers Disclosure','1','Freestanding','1','Kingwood West','Central Gas','1','LT 12 BLK 38 FOREST COVE COUNTRY CLUB ESTATES SEC 1 U/R','Subdivision Lot,Wooded','17700','Appraisal District','','100','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','29 - Humble','FOSTER ELEMENTARY SCHOOL (HUMBLE)','KINGWOOD PARK HIGH SCHOOL','KINGWOOD MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Traditional','Estates Sec 01 U/R','6087','2.5839','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','214508317','1667924551','214508317','2022-11-07T22:00:02.677','68326767','Stephanie Lambrecht','EXIT Lone Star Realty','','','30.091957','-95.613506','23','77375','3','121000.00','Active','Willowick','311','Street','Tomball','1','0','3','1094','Single-Family','This is a great starter home! 3 bedroom 1 bath zoned to Tomball ISD. Quiet street with easy access to 249 and 99. You\'ll be close to Downtown Tomball and all the restaurants/shopping on Main. This home has been remodeled from the inside out. Brand new roof, Brand new HVAC including duct work. Completely new interior and exterior painting. New carpet in all 3 bedrooms. New light fixtures and hardware on the doors. New wood blinds and screens on the windows throughout the home. Too many details to count and all done with love for the next homeowner in 2022. There is a storage shed in the fenced backyard. Make your appointment today to see what could be your next home.','0.0872','14','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Tomball','Central Gas','0','LT 5 BLK 2 HAMPTON PLACE-TOMBALL PAR R/P','Subdivision Lot','3799','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','53 - Tomball','TOMBALL ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','TOMBALL JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Hampton Place-Tomball Prcl R/P','1913','2.3717','Public Sewer,Public Water','1998','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','214508550','1667924551','214508550','2022-11-07T21:13:36.460','8619436','Steve Welkie','Keller Williams Woodlands','','','29.823435','-95.415044','44','77018','8','449000.00','Active','Fisher','808','Street','Houston','3','1','3','2219','Single-Family','Fantastic 3-Bedroom/3.5-Bath Free-Standing Home With A 2-Car Garage And 4th Floor Roof-Top Terrace! Situated In Sought-After Garden Oaks And Close To Several Great Venues; The Home Features An Open Floor Plan With Striking Wood Floors Thru-Out All Four Levels, Designer Tiles In The Baths, And Carpet In The Bedrooms; The Living/Kitchen/Dining Spaces Located On The 2nd Floor Are Wonderful For Relaxing Or Entertaining; The Island Kitchen Is Ideal For The Host And Features Gorgeous White Quartz Counters, High End Appliances, Soft Close Drawers/Cabinets, And A Wine Fridge; The Luxurious Primary Suite Offers A Beautifully Designed Full Bathroom With A Frameless Shower, Stylish Soaking Tub, Quartz Counters, Dual Sinks, And Two Spacious Walk-In Closets; All Bedrooms Have Ensuite Baths! There Is An Awesome Roof-Top Terrace With Great Views And Gas/Water Connections - Perfect For Entertaining, BBQ\'ing, And Relaxing! Quick And Easy Access To Downtown, The 610 Loop, I-45, And Other Major Roads.','0.0348','9','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Oak Forest East Area','Central Gas,Zoned','0','LT 7 BLK 1 NEO GARDEN OAKS','Patio Lot','1518','Appraisal District','','','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','27 - Houston','GARDEN OAKS ELEMENTARY SCHOOL','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','3','Contemporary/Modern','Neo Garden Oaks','8248','2.3307','Public Sewer,Public Water','2020','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','214509293','1667924551','214509293','2022-11-07T22:01:28.553','96660596','Earl Trammell','Coldwell Banker RealtyREALTORS','','','30.612049','-94.841349','17','77351','4','260000.00','Active','Bird','656','Road','Livingston','1','0','4','1406','Single-Family','This property is ready for all farm and ranch style living. A horse property fully fence around the entire lot with plenty of space for all your animals and pets. This classic home is perfect with the most beautiful lot in the area. \r\nAlmost completely cleared ready to build what ever you can imagine. Close to the freeway and shopping. Lake Livingston right down the road in a very quiet neighborhood. This is a must see lot and home. Schedule your showing today.','5','44','','','Electric Dryer Connections','','Sellers Disclosure','0','','','Livingston Area','No Heating','0','ABST 77 AUGUSTIN VIESCA SURVEY TRACT 301','Cleared','217800','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Other','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Appointment Required','Seller','1','Ranch,Traditional','AUGUSTIN VIESCA','1548','1.8745','Aerobic,Septic Tank,Well','1960','Appraisal District'); --> New record created successfully