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-18T21:12:36.590' ,`MLSNumber` = '20020886' ,`ListAgentFullName` = 'Luis Marti' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.908090' ,`Longitude` = '-95.710138' ,`PhotoCount` = '6' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Mountain Vista' ,`StreetNumber` = '19814' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2872' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Energy Efficient Meritage home with spacious master suite, flex/private study room on the first floor, 9 feet ceilings, secondary rooms located upstairs with large game room. Open concept Kitchen, Dining, and Living Room. \r\nKitchen with 48 inches cabinetry, Granite countertops Energy Star Stainless Steel Appliances, Walking Pantry, Gas Cooktop. Spacious Master Suite with Bay Windows, Quartz Countertops in master bath.Bricks on 4 sides and Stone in the front.Sprinkler system, Tankless water heater.Tile floor throughout the first floor.\r\nFor entertainment, you be delighted with the huge back porch space. Virtual Tour is attached for your review.\r\nMiramesa community amenities include a recreation center and walking trails.' ,`Acres` = '0.1377' ,`Area` = '25' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 1 MIRAMESA SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '940' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POSTMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Miramesa' ,`TaxAmount` = '9644' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040309' WHERE `Matrix_Unique_ID` = '210091196' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T22:06:22.610' ,`MLSNumber` = '98687797' ,`ListAgentFullName` = 'Kim Schwartz' ,`ListOfficeName` = 'Stanfield Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.672178' ,`Longitude` = '-95.482829' ,`PhotoCount` = '23' ,`PostalCode` = '77096' ,`RoomCount` = '8' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Valkeith' ,`StreetNumber` = '5602' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2275' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here it is - your forever home! Situated on an 8,760 square foot corner lot on one of the most sought-after streets in the Meyerland area on the west side of Houston, this single-story home is ideally located just minutes from Loop 610 & Highway 90. Neutral paint, new wood-look tile flooring, and expansive windows dressed with timeless plantation shutters extend throughout the foyer, formal living, dining, and into the spacious family room anchored by a wall of rear-facing windows, a coffered beam ceiling, and a charming brick fireplace. The kitchen has been beautifully updated to include granite countertops with raised breakfast bars, a modern glass tile backsplash, white cabinetry, and recent stainless appliances. Also note the indoor utility room, plush carpet underfoot in all three bedrooms, generously sized walk-in closets, and the large covered patio overlooking a lush yard with mature landscaping & an in-ground sprinkler system. Just 2 blocks to the Jewish Community Center!' ,`Acres` = '0.2011' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 8 BARKLEY SQUARE SOUTH SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Barkley Square South Sec 02' ,`TaxAmount` = '7451' ,`TaxRate` = '2.59' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040309' WHERE `Matrix_Unique_ID` = '210669110' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T21:02:56.427' ,`MLSNumber` = '60695652' ,`ListAgentFullName` = 'Darren Tidwell' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.409007' ,`Longitude` = '-95.000896' ,`PhotoCount` = '39' ,`PostalCode` = '77591' ,`RoomCount` = '8' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Amethyst' ,`StreetNumber` = '2713' ,`StreetSuffix` = 'Court' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1642' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely new construction. You can own this wonderful brand new home. This model is a fully completed 4 bedroom, 2 bath home with an open concept living area. Features included are stainless steel appliances, nice backsplash in kitchen, Central 16 SEER air conditioner, 42\" Wood cabinets, and more. Come to see these wonderful new homes at an affordable price. Pearlbrook community offers two nice ponds, with connected walking trails, sitting areas, including two build up playground parks. Conveniently located close to I-45, Hwy 3, and Expwy 1764. Close proximity to shopping areas, medical center, restaurants, and fun Galveston Beach. Visit the Model home to see all available new homes Wednesday through Sunday 10:00 am to 6:00 pm. Call today if you have any questions!!!' ,`Acres` = '0.1363' ,`Area` = '33' ,`BuilderName` = 'Stylecraft Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 29 BLK 5 PEARLBROOK SEC 8 (2021) ABST 180' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5937' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pearlbrook' ,`TaxAmount` = '874' ,`TaxRate` = '3.4928' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040310' WHERE `Matrix_Unique_ID` = '211173666' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T22:09:56.683' ,`MLSNumber` = '27698841' ,`ListAgentFullName` = 'Madeline Phillips' ,`ListOfficeName` = 'Premier Property Group' ,`SellingAgentFullName` = 'Abigail Patrick' ,`SellingOfficeName` = 'RE/MAX The Woodlands & Spring' ,`Latitude` = '30.616797' ,`Longitude` = '-94.866214' ,`PhotoCount` = '39' ,`PostalCode` = '77351' ,`RoomCount` = '4' ,`ListPrice` = '310000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Summer' ,`StreetNumber` = '141' ,`StreetSuffix` = 'Place' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1998' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Farmhouse dream! Come check out this 2021 build! Situated on two lots, this beautiful custom home has so much to offer! Attached two car carport, concrete sidewalk to the front door, custom cabinetry throughout, quartz countertops, split floor plan, oversized master closet, tiled showers, HUGE office that could also serve as a 4th bedroom, and much more! Subdivision features a community center, park, baseball field, and a private lake!' ,`Acres` = '0.4132' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'FOREST SPRINGS SECTION 1 BLK L LOT 9 & 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Spgs Sec 1' ,`TaxAmount` = '4114' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040310' WHERE `Matrix_Unique_ID` = '211948760' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T22:45:36.940' ,`MLSNumber` = '60205541' ,`ListAgentFullName` = 'Ayo Oluwi' ,`ListOfficeName` = 'J. Lindsey Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.548902' ,`Longitude` = '-95.799830' ,`PhotoCount` = '27' ,`PostalCode` = '77471' ,`RoomCount` = '3' ,`ListPrice` = '236000.00' ,`Status` = 'Active' ,`StreetName` = 'Madison' ,`StreetNumber` = '2601' ,`StreetSuffix` = 'Avenue' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1625' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in a great neighborhood with a private pool and fireplace.New floor, new washable paint and fittings (2022)with Quartz counter top in the kitchen.Primary bedroom is very spacious and the house layout is very welcoming.' ,`Acres` = '0.1834' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CAMBRIDGE VILLAGE SEC 1, BLOCK 2, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7991' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'RAY ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'TERRY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO/GEORGE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'English' ,`Subdivision` = 'Cambridge Village Sec 1' ,`TaxAmount` = '4026' ,`TaxRate` = '2.0748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040310' WHERE `Matrix_Unique_ID` = '212401167' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T21:35:48.630' ,`MLSNumber` = '73083460' ,`ListAgentFullName` = 'Jennifer Nunez-Mindiola' ,`ListOfficeName` = 'BlueRoof Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822547' ,`Longitude` = '-95.682092' ,`PhotoCount` = '30' ,`PostalCode` = '77084' ,`RoomCount` = '5' ,`ListPrice` = '364500.00' ,`Status` = 'Active' ,`StreetName` = 'Rowlock Vine' ,`StreetNumber` = '3711' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3655' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home boasts 3,655 square feet of living space with 5 spacious bedrooms, 3 full bathrooms, and 1 additional room that can be used as an extra study or storage space. Large upstairs living/game room, massive primary suite, including an adjoining study/sitting space and 2 walk-in closets accessible through the primary bathroom. 4 bedrooms upstairs and 1 bedroom downstairs with separate full-size bathroom. Kitchen has an upgraded farmhouse style sink with touch-technology faucet. Large walk-in pantry. Backyard has an expansive concrete patio with double-sided pergola and lighted pond with fountain. New roof with 30-year shingles installed less than 6 years ago. No flooding during Harvey! Zoned to Katy schools and easy access to I-10, Highway 6, Beltway 8, and the Grand Parkway/99, depending on the direction you travel. Many reasons to make this your new home! It\'s the perfect place for a family! Schedule your appointment to view today!' ,`Acres` = '0.2003' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 BARKERS BRANCH SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8726' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SCHMALZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Barkers Branch Sec 2' ,`TaxAmount` = '6500' ,`TaxRate` = '2.587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040310' WHERE `Matrix_Unique_ID` = '212662651' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T21:18:50.560' ,`MLSNumber` = '34743951' ,`ListAgentFullName` = 'Kimberly Englebert' ,`ListOfficeName` = 'Yokom Properties LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.034599' ,`Longitude` = '-95.645958' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '7' ,`ListPrice` = '449990.00' ,`Status` = 'Active' ,`StreetName` = 'Quarry Vale' ,`StreetNumber` = '18147' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2717' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Like-new 4 bedroom, 2.5 bathroom, two-story home, zoned to the highly acclaimed Tomball Independent School District, and located within the prestigious Hayden Lakes Community! Walk into a grand entry with hardwood flooring leading to the living area, which is open to the kitchen. The kitchen features 42” white cabinets, subway tile backsplash, pendant lighting, stainless steel appliances and a gas stove. Entertain in the backyard underneath the extended covered back patio in a yard that has ample room for a pool. In additional to the 4 bedrooms, this home has a study downstairs and a large game room upstairs—either can be used as a flex space. Conveniently located to TX-249 and the Grand Parkway, this home is ideal for commuters. Community features and amenities include a sparkling pool, dog park and several water features and sidewalks throughout….AND don’t forget—LOW TAX RATE! Come check out this beautiful home today!' ,`Acres` = '0.168' ,`Area` = '35' ,`BuilderName` = 'Beazer' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 2 HAYDEN LAKES SEC 9' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7318' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hayden Lakes Sec 9' ,`TaxAmount` = '8931' ,`TaxRate` = '2.8172' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040311' WHERE `Matrix_Unique_ID` = '212981700' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T22:14:35.230' ,`MLSNumber` = '49914187' ,`ListAgentFullName` = 'Erika Jones' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = 'Schakara Eleby' ,`SellingOfficeName` = 'CB&A, Realtors' ,`Latitude` = '30.050727' ,`Longitude` = '-95.476779' ,`PhotoCount` = '50' ,`PostalCode` = '77388' ,`RoomCount` = '11' ,`ListPrice` = '649000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Puget' ,`StreetNumber` = '19410' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4512' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You\'ve arrived behind the gates of Bainbridge Estates on stunning lot w/mature trees! This home,\r\nmeticulously maintained, includes Family room, Formal Dining & Living w/ 2 sided fireplace & wood flooring. Kitchen includes SS appliances & Granite countertops. This home boasts 5 bedrooms w/walk in closets. The owners\' retreat has pool views & door to step out for an evening dip. The spa-like bath has large shower w/rain showerhead, jetted tub, double sinks w/vanity, & 2 walk in closets w/built ins. Sweeping staircase leads you to 4 spacious bedrooms, 2 Jack & Jill baths, and a spacious Media room w/Wet bar, microwave & fridge + long Granite bar ready for the big game & movie night! Two covered patios, Summer kitchen and Firepit are perfect for entertaining. The picturesque Lagoon style pool is amazing at night with LED lighting and beautifully landscaped backyard. Located minutes from Exxon, The Woodlands, and IAH airport. Must see!' ,`Acres` = '0.2989' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 38 BLK 1 BAINBRIDGE ESTATES AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HAUDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'French,Traditional' ,`Subdivision` = 'Bainbridge Estates' ,`TaxAmount` = '12328' ,`TaxRate` = '2.769' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040311' WHERE `Matrix_Unique_ID` = '213021001' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T21:02:33.997' ,`MLSNumber` = '68386798' ,`ListAgentFullName` = 'Hai Huynh' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.858327' ,`Longitude` = '-95.774524' ,`PhotoCount` = '25' ,`PostalCode` = '77493' ,`RoomCount` = '3' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Bright Light Lane' ,`StreetNumber` = '23014' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1349' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction home, never lived in 1-story 3 bedrooms, 2 bathrooms in a fast selling community that offers open floorplan perfect for entertainment. Kitchen features 42 in cabinetry, granite countertop, open to the casual dining room and the living room. Beautiful vinyl and tile flooring throughout the house. Conveniently located near major thoroughfares such as FM 529, I-10 and 99 Grand Parkway. Minutes away from shopping, dining, entertainment and grocery. Please schedule your showing today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 1 AURORA SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040311' WHERE `Matrix_Unique_ID` = '213035548' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T22:30:54.380' ,`MLSNumber` = '38125390' ,`ListAgentFullName` = 'David Moosavi' ,`ListOfficeName` = 'Rose Above Realty' ,`SellingAgentFullName` = 'Carlos Velez' ,`SellingOfficeName` = 'Texas Team Real Estate' ,`Latitude` = '29.036656' ,`Longitude` = '-95.427576' ,`PhotoCount` = '17' ,`PostalCode` = '77566' ,`RoomCount` = '6' ,`ListPrice` = '189999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Carnation' ,`StreetNumber` = '301' ,`StreetSuffix` = 'Street' ,`City` = 'Lake Jackson' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1245' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Awesome three bedroom home on an oversized lot! Whether you enjoy grilling on the stamped concrete patio or lounging in the shade, you\'re sure to make use of the abundance of yard space. Situated on a corner lot in a nice neighborhood, this cozy home is the one to make your own.' ,`Acres` = '0.2353' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PARKWOOD TERRACE (LAKE JACKSON) BLK 11 LOT 23' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '10250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BEUTEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkwood Terrace Lake Jackson' ,`TaxAmount` = '3920' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040311' WHERE `Matrix_Unique_ID` = '213122247' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T22:38:17.987' ,`MLSNumber` = '46900686' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.166883' ,`Longitude` = '-96.397744' ,`PhotoCount` = '12' ,`PostalCode` = '77833' ,`RoomCount` = '4' ,`ListPrice` = '302100.00' ,`Status` = 'Active' ,`StreetName` = 'Davy' ,`StreetNumber` = '1114' ,`StreetSuffix` = 'Street' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Dakota is a single-story, 1568 sq. ft., 4 bedroom, 2 bathroom floorplan, designed to provide you and your family a comfortable place to call home. The inviting entryway opens into the spacious living area with an open dining area connects to the spacious kitchen. Enjoy preparing meals and spending time together gathered around the kitchen island. Bedroom 1 is located off the family room and it includes a large walk-in closet and a relaxing spa-like bathroom. Other Features include: granite counter tops in the kitchen and Frigidaire® Stainless appliances. You’ll enjoy added security in your new DR Horton home with our Home is Connected features. Using one central hub that talks to all the devices in your home, you can control the lights, thermostat and locks, all from your cellular device. DR Horton also includes an Amazon Echo Dot to make voice activation a reality in your new Smart Home.' ,`Acres` = '0.156' ,`Area` = '58' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S3803 - Liberty Village S/D, BLOCK 10, Lot 4, ACRES 0.156' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6795' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Liberty Village' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040311' WHERE `Matrix_Unique_ID` = '213244586' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T21:41:45.237' ,`MLSNumber` = '62300900' ,`ListAgentFullName` = 'Liaqat Hussain' ,`ListOfficeName` = 'M&M Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.123301' ,`Longitude` = '-95.572209' ,`PhotoCount` = '50' ,`PostalCode` = '77375' ,`RoomCount` = '12' ,`ListPrice` = '644990.00' ,`Status` = 'Active' ,`StreetName` = 'Lilly Hall' ,`StreetNumber` = '24919' ,`StreetSuffix` = 'Court' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2709' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A stunning Tripointe (Martin Plan) with oversized lake lot, a stucco-stone home and upgraded GE Profile appliances. Perfectly located on a Private Cul De Sac with green space. An elegant two-story plan with dramatic soaring ceiling with 4 bedrooms, 2.5 baths and a 2-car garage. This open concept plan offers a flex room, and family room with 2-story ceilings, casual dining area off kitchen, an upstairs loft space where kids can game and a large walk-in closet at primary bathroom. \r\n\r\nEnjoy Scenic Lake Views from your bedroom windows or while relaxing out in your expanding living space of your covered patio. Lakes at Creekside offers amazing amenities including its own Fitness Center, a Club House to host parties, anniversaries or to enjoy neighborhood events, a pavilion, perfect for picnics and get togethers, a sparkling pool for great fun in the sun, eight different lakes and multiple play areas which makes it the ideal place to call it home.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Tripointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1, Block 4, Lakes at Creekside Section 10' ,`LotDesciption` = 'Cul-De-Sac,Waterfront' ,`LotSize` = '9141' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TIMBER CREEK ELEMENTARY SCHOOL (Tomball)' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes at Creekside' ,`TaxAmount` = '' ,`TaxRate` = '2.89' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040312' WHERE `Matrix_Unique_ID` = '213307986' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T22:06:26.387' ,`MLSNumber` = '90319266' ,`ListAgentFullName` = 'Debra Roobaert' ,`ListOfficeName` = 'Tricia Turner Properties' ,`SellingAgentFullName` = 'Debra Roobaert' ,`SellingOfficeName` = 'Tricia Turner Properties' ,`Latitude` = '29.808576' ,`Longitude` = '-95.829924' ,`PhotoCount` = '29' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '330000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'North Fawnlake' ,`StreetNumber` = '6122' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERFECT LOCATION! NO FLOODING! Lovely, move-in ready home is a must see and nestled in the heart of Katy. This beautiful home is located in the Fawnlake Community which is zoned to the highly acclaimed Katy ISD. A spacious one-story floorplan with 3 bedrooms, 2 full baths, open kitchen, living and dining areas with a lot of natural light throughout, high ceilings, and beautiful views of the stunning covered patio area and backyard. The garage has a convenient work and storage space with Epoxy Flooring to keep things clean. Recent upgrades include interior/exterior paint, new carpet, new back fence/gate, fresh landscaping, and roof in 2020. This Fawnlake Community brings a hometown feel with a park, scenic water views, and walking trails, but only a short distance from dining, shopping, the library, and entertainment. Minutes away from I-10 and Grand Parkway. Don\'t miss out on this ideal home! Schedule your showing, today.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 48, Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KATY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fawnlake' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040312' WHERE `Matrix_Unique_ID` = '213780250' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T22:49:53.663' ,`MLSNumber` = '14616993' ,`ListAgentFullName` = 'Thor Paulsen' ,`ListOfficeName` = 'D. Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.784394' ,`Longitude` = '-95.204773' ,`PhotoCount` = '13' ,`PostalCode` = '77015' ,`RoomCount` = '3' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Rue Fontaine' ,`StreetNumber` = '747' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1450' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BIG corner lot! Freshly painted throughout, new carpet, updated kitchen with beautiful wood cabinets and granite countertops. Bathrooms have been remodeled as well. Large covered patio, great for entertainment. Lots of green area great for kids and pets. Convenient access to major freeway, I10. Schedule your showing fast before it\'s gone!' ,`Acres` = '0.1515' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 4 RIVIERA EAST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '280' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'NORMANDY CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'CUNNINGHAM MIDDLE SCHOOL (GALENA PARK)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riviera East Sec 03' ,`TaxAmount` = '3928' ,`TaxRate` = '2.6774' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040312' WHERE `Matrix_Unique_ID` = '213890686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T22:01:55.140' ,`MLSNumber` = '72944064' ,`ListAgentFullName` = 'Brandon Snyder' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.107434' ,`Longitude` = '-95.779872' ,`PhotoCount` = '42' ,`PostalCode` = '77447' ,`RoomCount` = '8' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Lazy Hollow' ,`StreetNumber` = '23214' ,`StreetSuffix` = 'Lane' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2328' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to your perfect slice of Country Heaven! Lazy Hollow Lane is as quaint as the homes that sit on it! At the end of a Cul-de-sac, this magnificent home has what you\'ve been looking for! Plenty of space for the entire immediate family daily, and for the extended family on holidays! Sitting on over an Acre lot, this 2005 home has only had one owner and has been meticulously maintained! This home is on sewer and well that is serviced ON THE DOT yearly, along with an HVAC system that get\'s more check ups than we do! Did I mention is has NO HOA?! Tons of windows, high ceilings and arches that speak right to your country heart, you will WANT to see this one!' ,`Acres` = '1.0347' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CLEAR CREEK FOREST 10, BLOCK 5, LOT 33' ,`LotDesciption` = 'Cul-De-Sac,Other,Wooded' ,`LotSize` = '45071' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'J.L. LYON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Creek Forest 10' ,`TaxAmount` = '6134' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040312' WHERE `Matrix_Unique_ID` = '213989570' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T22:58:55.200' ,`MLSNumber` = '83153725' ,`ListAgentFullName` = 'Deb Stirling' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.154961' ,`Longitude` = '-95.583780' ,`PhotoCount` = '49' ,`PostalCode` = '77354' ,`RoomCount` = '10' ,`ListPrice` = '524900.00' ,`Status` = 'Active' ,`StreetName` = 'Madeline Lake' ,`StreetNumber` = '27120' ,`StreetSuffix` = 'Circle' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3619' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BETTER THAN NEW two story beauty with amazing Bright, Open and super functional design. This popular Westin Asher II floor plan features 2 main floor bedrooms, private study, formal dining, game room, media room and spacious island kitchen with breakfast area open to great room. Neutral colors throughout and an abundance of windows work perfect with any decorating style. Private corner lot offers large back yard with covered patio and plenty of room for a pool, playground or whatever whatever you may desire. 3 car tandem garage and stunning curb appeal with low maintenance full brick and stone exterior and professional landscaping. Window treatments, washer and dryer, Fridge and large freezer in garage are also included making this home MOVE IN READY! The community of Northgrove offers resort-style amenities including a 9400 square foot club house, pool, fitness center, several children\'s play areas and MORE! Click on virtual tour for a 3D walk through tour of this incredible home.' ,`Acres` = '0.2497' ,`Area` = '15' ,`BuilderName` = 'Westin' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S740207 - NORTHGROVE 07, BLOCK 2, LOT 11' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '10878' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1335' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northgrove 07' ,`TaxAmount` = '12996' ,`TaxRate` = '3.2087' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040313' WHERE `Matrix_Unique_ID` = '214205000' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T22:46:03.337' ,`MLSNumber` = '82686168' ,`ListAgentFullName` = 'Libby Mitchell' ,`ListOfficeName` = 'REGENCY REAL ESTATE PROF' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.910863' ,`Longitude` = '-94.129188' ,`PhotoCount` = '49' ,`PostalCode` = '77705' ,`RoomCount` = '14' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = 'FM 365' ,`StreetNumber` = '10587' ,`StreetSuffix` = 'Road' ,`City` = 'Beaumont' ,`BathsFull` = '6' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '8273' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Where Yellowstone meets Southfork, this stunning luxury ranch sits on 22+ ac w/designer finishes, stunning entrance w/winding staircase, gorgeous chandeliers & marble columns. Remarkable family rm w/soaring ceilings & 26’ stone FP &windows overlooking green pastures. Grand formal DR, gourmet kitchen w/coffered ceiling +custom cabinetry, Thermador gas cooktop+dbl conv. ovens, exotic granite, island+Butler’s pantry. Private study w/beautiful view accommodates book & art collections. Impressive parlor/frml LR. Private owner’s retreat, w/cozy sitting room +coffee bar & FP +luxurious dream bath w/walk-thru shwr, His/Her vanities & huge walk-in closets w/built-ins, salon sink & 2nd laundry center! Media room for family movie nights. Upstairs guest apt. w/2nd kitchen & living+1st floor guest qtrs w/private entry. Enjoy sunsets & starry night skies as you relax by the outdoor FP on large patio. 3/2 mobile home for STR income or guests+2 stall barn+40x30 shop+playground+fishing pond & more!' ,`Acres` = '22.37' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'PT TR 1 3 B BLACKMAN 1.000 AC + PT TR 1 3 B BLACKMAN 21.373' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '974567' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '110 - Hamshire-Fannett' ,`SchoolElementary` = 'HAMSHIRE-FANNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HAMSHIRE-FANNETT HIGH SCHOOL' ,`SchoolMiddle` = 'HAMSHIRE-FANNETT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Colonial' ,`Subdivision` = 'Blackman' ,`TaxAmount` = '14993' ,`TaxRate` = '2.0652' ,`WaterSewer` = 'Aerobic,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040313' WHERE `Matrix_Unique_ID` = '214323363' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T22:05:51.473' ,`MLSNumber` = '66124424' ,`ListAgentFullName` = 'Alicia Lansford' ,`ListOfficeName` = 'Markham Realty, Inc.' ,`SellingAgentFullName` = 'Virginia Price' ,`SellingOfficeName` = 'Virginia Price Realty, LLC' ,`Latitude` = '30.595897' ,`Longitude` = '-95.961808' ,`PhotoCount` = '33' ,`PostalCode` = '77830' ,`RoomCount` = '2' ,`ListPrice` = '174500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'County Road 226' ,`StreetNumber` = '3729' ,`StreetSuffix` = '' ,`City` = 'Anderson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1332' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great 2 bed, 2 bath home on just over 3 acres in the coveted Anderson ISD! This cute, country home offers loads of privacy while still being close to all the amenities. Make sure to check out the private deck from the upstairs loft area. Short drive to College Station & TAMU, Navasota, and Huntsville. No pipelines, high-lines, or flood plain. Schedule your showing today on this adorable home!' ,`Acres` = '3.274' ,`Area` = '60' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bedias/Roans Prairie Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'A0025 J HADLEY, TRACT 25-4, ACRES 3.274' ,`LotDesciption` = 'Wooded' ,`LotSize` = '142615' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '135 - Anderson-Shiro' ,`SchoolElementary` = 'ANDERSON-SHIRO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDERSON-SHIRO JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ANDERSON-SHIRO JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rural' ,`TaxAmount` = '2674' ,`TaxRate` = '1.5426' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669040313' WHERE `Matrix_Unique_ID` = '214325577' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T21:33:10.827' ,`MLSNumber` = '43481673' ,`ListAgentFullName` = 'Daniela Sumbera' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.967870' ,`Longitude` = '-95.179936' ,`PhotoCount` = '35' ,`PostalCode` = '77346' ,`RoomCount` = '9' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Riata River' ,`StreetNumber` = '13207' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2210' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this immaculate 3 bed 3 bath home located in the desirable Eagle Springs community. This home features a desirable open floorplan, high ceilings, & tons of natural light throughout. Foyer welcomes you to the home office and a formal dining room. The oversized kitchen offers a stainless-steel appliances, tons of cabinet & counter space with island that opens to a large living room with cozy fireplace. Spacious primary suite boasts ensuite bath access featuring double vanity, soaking tub & tiled shower with glass enclosure. Additional features include spacious guest rooms, secondary baths, and a large laundry room with tons storage closets. Enjoy your quiet evenings in the covered back patio and take a dip in your sparkling pool. Conveniently located close to award winning schools, freeways, shopping, and dining.' ,`Acres` = '0.1459' ,`Area` = '1' ,`BuilderName` = 'Lennar Whitney' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 1 EAGLE SPRINGS SEC 47' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6355' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ATASCOCITA SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Spgs Sec 47' ,`TaxAmount` = '7941' ,`TaxRate` = '2.913' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040313' WHERE `Matrix_Unique_ID` = '214567044' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T22:17:05.857' ,`MLSNumber` = '48019237' ,`ListAgentFullName` = 'Aishat Trevino' ,`ListOfficeName` = 'C.R.Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.845604' ,`Longitude` = '-95.788548' ,`PhotoCount` = '26' ,`PostalCode` = '77493' ,`RoomCount` = '3' ,`ListPrice` = '309999.00' ,`Status` = 'Active' ,`StreetName` = 'Padova Gardens' ,`StreetNumber` = '23814' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1705' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning remodeled One-Story Home 3BD/2BA, One of the best homes in Ventana Lakes Subdivision! Gorgeous open kitchen features a large center island with breakfast bar seating, quartz countertops, subway tile backsplash, bamboo flooring, and stainless steel appliances. The floorplan is very open & spacious which includes a laundry room and an electric fireplace built into the living room wall. Ventana Lakes residents enjoy easy access to the community clubhouse, resort-style pool, splash pad, scenic lakes, walking trails, water park, and easy access to Highways.' ,`Acres` = '0.1435' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 46 BLK 1 VENTANA LAKES SEC 14' ,`LotDesciption` = 'Other' ,`LotSize` = '6250' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Venatna Lakes Sec 14' ,`TaxAmount` = '7160' ,`TaxRate` = '3.2768' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040314' WHERE `Matrix_Unique_ID` = '214584647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T22:26:27.550' ,`MLSNumber` = '26735434' ,`ListAgentFullName` = 'KeMesha Hall' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405217' ,`Longitude` = '-94.922104' ,`PhotoCount` = '31' ,`PostalCode` = '77590' ,`RoomCount` = '8' ,`ListPrice` = '292000.00' ,`Status` = 'Active' ,`StreetName` = '22nd' ,`StreetNumber` = '1821' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2044' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to the Newest Completely Remodeled home in the highly desirable Westview Subdivision. This stunning 4-bedroom 2 bath home sits on the corner lot & features high-end luxury fixtures with upgrades that are rare at this price point. This home includes a Brand-new Roof with a Transferable warranty, New HVAC, Electric Panel, & Water Heater. The Kitchen boasts Opulent Tile floors with Brand New Modern Appliances, Pristine Quartz Countertops with Designer High-end backsplashes & hardware in both the kitchen & bathrooms. The Master Bedroom features all New Double Sliding Barn Doors, New Tub/Shower Surround and fixtures. Your newly remodeled Master Bathroom that features a New Vanity with Designer Backsplash, & New Tub/shower. Great Size backyard with Shed for storage and Newly Converted Fire Pit for entertaining friends and family. Within walking distance to school and parks! This home will not last long so bring your best offers fast!' ,`Acres` = '0.1856' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 167 D L RICHARDSON SUR LOT 20 BLK 3 WESTVIEW SEC 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8085' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'GUAJARDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westview 5' ,`TaxAmount` = '4770' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040314' WHERE `Matrix_Unique_ID` = '214616410' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T21:03:28.873' ,`MLSNumber` = '31512225' ,`ListAgentFullName` = 'Erin Kaplan' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.836297' ,`Longitude` = '-95.433776' ,`PhotoCount` = '13' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Candlelight' ,`StreetNumber` = '1322' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '0' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Construct your dream home on an oversized lot in Oak Forest. Price is for the lot + a contract to build with SF Custom Homes LLC. The final price will depend on the buyers selected floor plan and finishes. You can choose from several floor plans by SF Custom Homes or work with the builder to create your own. Property is zoned to the award winning Oak Forest Elementary. Lot size allows for spacious home and ample backyard with green space and pool if desired. Designer consultation available to select all interior finishes.' ,`Acres` = '0.2934' ,`Area` = '9' ,`BuilderName` = 'SF Custom Homes LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 35 OAK FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Colonial,Contemporary/Modern,Craftsman,English,French,Georgian,Traditional' ,`Subdivision` = 'Oak Forest' ,`TaxAmount` = '11590' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040314' WHERE `Matrix_Unique_ID` = '214665766' --> 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','214745341','1669040314','214745341','2022-11-18T21:54:01.633','29712708','Darrell Anderson','eXp Realty, LLC','','','29.562788','-95.706647','32','77469','5','460000.00','Active','Parsley Mist','21614','Lane','Richmond','3','1','4','3066','Single-Family','Beautiful two story traditional in Riverpark! You will love walking through the front doors into the two story foyer with sweeping staircase. The oversized family room has a wall of majestic windows, overlooking the manicured backyard and covered patio. The kitchen is open to the family room and includes granite countertops with 42\' cabinets, Energy Star appliances and tons of cabinet space. The primary bedroom is downstairs with 3 bedrooms and a gameroom located upstairs. Excellent FBISD schools, conveniently located near major highways, shopping, dining and medical centers.','0.15','30','','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Fort Bend South/Richmond','Central Gas','1','RIVERPARK WEST SEC 9 REPLAT NO 2, BLOCK 1, LOT 21','Greenbelt,Subdivision Lot','6533','Appraisal District','','850','0','','3','Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','33 - Lamar Consolidated','HUTCHISON ELEMENTARY SCHOOL','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Riverpark West Sec 9 Rep 2','7922','2.8748','Public Sewer,Public Water','2012','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T22:54:01.070' ,`MLSNumber` = '68079369' ,`ListAgentFullName` = 'Lisa Hudgens' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = 'Jill Behrens' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '30.224767' ,`Longitude` = '-95.466238' ,`PhotoCount` = '31' ,`PostalCode` = '77384' ,`RoomCount` = '7' ,`ListPrice` = '395000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Victory Lake' ,`StreetNumber` = '15' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '2352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Lennar built home in sough after gated over 55 community of Woodlands Windsor Lakes.The home has a professionally landscaped front & back yard w/mature trees & beautiful flower beds. The gutters have leaf guard covers & whole house is on a surge protector. The foyer opens into the study which has french doors, wood tile & high ceilings. The dining room has arched doorways wood tile, crown molding & chair railing. The kitchen features granite countertops, butler\'s & large walk in pantry & roll out shelves in all cabinets. Family room has a wall of windows, fireplace w/recently updated mantle & recently installed ceiling fan. The primary bedroom has carpet, high ceilings & solar screens. En suite bath w/granite countertops, double sinks, jetted tub, spacious standing shower & spacious closet. The secondary bath has been updated as well w/ granite countertops & standing shower. The entire inside of the home has been painted & the HVAC was replaced in 2021.' ,`Acres` = '0.2347' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S976105 - WDLNDS WINDSOR LAKES 05, BLOCK 1, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10223' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '208' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Windsor Lakes' ,`TaxAmount` = '7611' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040314' WHERE `Matrix_Unique_ID` = '214776066' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T22:44:03.470' ,`MLSNumber` = '71245192' ,`ListAgentFullName` = 'Michael Borrel' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.673232' ,`Longitude` = '-95.498866' ,`PhotoCount` = '31' ,`PostalCode` = '77096' ,`RoomCount` = '9' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Queensloch' ,`StreetNumber` = '6131' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2420' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED! Nestled in the quiet, tree-lined community of beautiful Maplewood South, this redesigned home has been completely remodeled to meet today\'s standards of elevated living! Immaculate curb appeal featuring new landscaping, fresh exterior paint and a new whitewashed brick walkway that leads you right up to your new home. Upon entry, you are greeted with wood herringbone and an open layout that flows seamlessly throughout the kitchen, dining area and living area - perfect for entertaining! No expense was spared in the kitchen, which features a custom, on-site built oversized island with Italian marble, custom moulding, bronze hardware, designer light fixtures, high-end appliances, eat-up counter seating and a breakfast nook with custom banquette. The gorgeous wood floors continue throughout the rest of the home and into the bedrooms. The primary suite features a walk-in closet and ensuite bath with standalone shower, hexagon flooring, Italian marble and on-trend fixtures.' ,`Acres` = '0.1956' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 19 MAPLEWOOD SOUTH SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELROD ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Maplewood South' ,`TaxAmount` = '7011' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040315' WHERE `Matrix_Unique_ID` = '214797335' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T22:02:59.927' ,`MLSNumber` = '73364357' ,`ListAgentFullName` = 'Aishat Trevino' ,`ListOfficeName` = 'C.R.Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.737511' ,`Longitude` = '-95.016926' ,`PhotoCount` = '24' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '144999.00' ,`Status` = 'Active' ,`StreetName` = 'Del Rio' ,`StreetNumber` = '185' ,`StreetSuffix` = 'Avenue' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1392' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful remodeled 3 bedroom 2 bath home located in a quiet neighborhood minutes from lake Livingston. This property also includes a spacious laundry room along with a washer and dryer with lots of storage. Home has brand new luxury vinyl flooring, new interior and exterior paint with brand new fans, fixtures, and faucets. Home also has a detached carport along with a storage shed for fishing poles and water toys. Close to shopping, restaurants, Naskila Casino, Tripple J Bowling, and a nearby hospital.' ,`Acres` = '0.2187' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WIGGINS RIDGE LOT 95' ,`LotDesciption` = 'Other' ,`LotSize` = '9525' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Wiggins Ridge' ,`TaxAmount` = '2263' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040315' WHERE `Matrix_Unique_ID` = '214817790' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T21:41:23.553' ,`MLSNumber` = '20193160' ,`ListAgentFullName` = 'Amanda Klam' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = 'Shezila Ali' ,`SellingOfficeName` = 'Keller Williams Signature' ,`Latitude` = '29.868175' ,`Longitude` = '-95.878157' ,`PhotoCount` = '23' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '285000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wayne County' ,`StreetNumber` = '305' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1570' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Style meets functionality in this open and spacious layout with 3 bedrooms and 2 bathrooms.  The open kitchen with a sprawling breakfast bar, a spacious family room and a private dining room makes the perfect layout for entertaining. Laminate Flooring throughout homes main living areas and primary bedroom! A spacious covered patio and fully fenced OVERSIZED, backyard extends the entertaining space outdoors. MOVTIVATED SELLER! Contact agent for details!' ,`Acres` = '0.1876' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brookshire' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S491903 FREEMAN RANCH SECTION 3 BLK 14 LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8172' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '348' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '44 - Royal' ,`SchoolElementary` = 'ROYAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROYAL HIGH SCHOOL' ,`SchoolMiddle` = 'ROYAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Freeman Ranch Sec 3' ,`TaxAmount` = '' ,`TaxRate` = '2.8667' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040315' WHERE `Matrix_Unique_ID` = '214834236' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-18T21:09:07.370' ,`MLSNumber` = '64569882' ,`ListAgentFullName` = 'Amanda Brautigam' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = 'Joseph Cavanaugh' ,`SellingOfficeName` = 'CB&A, Realtors' ,`Latitude` = '29.940199' ,`Longitude` = '-95.638397' ,`PhotoCount` = '27' ,`PostalCode` = '77429' ,`RoomCount` = '6' ,`ListPrice` = '230000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Rosetta' ,`StreetNumber` = '14231' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 14231 Rosetta Dr. in Bonaire! This charming, single-story home located on a quiet street has 3 bedrooms and 2 baths and has never flooded! Home is complete with laminate and tile flooring throughout, and granite countertops in kitchen, primary, and secondary baths. Relax in your private primary suite with walk-in closet and ensuite bathroom with large walk-in shower. There\'s plenty of space to entertain inside or out back in the private picket fenced yard with covered patio, and mature trees that provide great shade from the Texas sun. Located closely to shopping, restaurants, schools, and hospital, with easy access to highway 290!' ,`Acres` = '0.1492' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 28 BONAIRE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '260' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LAMKIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonaire Sec 05' ,`TaxAmount` = '4364' ,`TaxRate` = '2.438' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040315' WHERE `Matrix_Unique_ID` = '214835596' --> 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','214935348','1669040316','214935348','2022-11-18T21:01:45.700','8165005','Catherine OBriant','RE/MAX Preferred Homes','','','29.856256','-95.676669','30','77084','7','229900.00','Active','Garden Manor','18074','Drive','Houston','2','0','3','1386','Single-Family','BEEautiful 3 bedroom 2 bathroom split plan home. Recent improvements made after the family left includes interior and exterior paint, exterminator, interior 6-panel bedroom doors, carpet, kitchen faucet and counters, primary tub, toilet, and AC compressor. a Like new home that will go fast! Be one of the first to see it and BEE in Love!','0.1591','8','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Bear Creek South','Central Electric','1','LT 6 BLK 7 WINDSONG SEC 1','Subdivision Lot','6929','Appraisal District','','425','0','','2','Freestanding Oven','0','','','Freestanding Range','','Composition','13 - Cypress-Fairbanks','WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS LAKES HIGH SCHOOL','WATKINS MIDDLE SCHOOL','Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','Windsong Sec 01','5137','2.5618','Public Sewer,Public Water,Water District','1983','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','214940559','1669040316','214940559','2022-11-18T21:41:47.000','43497934','Michelle Henderson','Coldwell Banker Realty','','','29.664158','-95.478076','40','77096','4','385000.00','Active','Oasis','10710','Drive','Houston','2','0','3','1761','Single-Family','Stunning, glamorous home in Westbury community is move in ready! Welcome guests with this intimate, inviting covered front porch. Experience a modern open floorplan with so many exquisite features you will not forget it. This home has been freshly updated and renovated with modern and timeless finishes. Kitchen is \"model home\" material-brand new black stainless steel appliances, quartz countertops, soft-close cabinet drawers, with the latest gold/brass hardware- stunning! Luxury vinyl flooring is beautiful & low-maintenance. Wet bar/wine fridge/wine storage. This home home is basked in natural light due to the many windows. Two car garage/dual driveways. Backyard is spacious with plenty of room for outdoor living and entertaining. So much attention to detail went into making this home a spectacular finished product. This established, quiet community is IDEALLY located- easy access to 610, Galleria, top restaurants, shopping and easy access to Medical center and NRG. No long commutes!','0.2204','20','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Brays Oaks','Central Gas','0','LT 11 BLK 39 WESTBURY SEC 2','Corner,Subdivision Lot','9600','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','PARKER ELEMENTARY SCHOOL (HOUSTON)','WESTBURY HIGH SCHOOL','MEYERLAND MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Westbury Sec 02','5514','2.3307','Public Sewer,Public Water','1960','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','214948617','1669040316','214948617','2022-11-18T21:41:48.497','16455592','Nicky Gomez','RE/MAX The Woodlands & Spring','','','29.858241','-95.381132','14','77076','4','165000.00','Active','Wellington','39','Street','Houston','1','0','2','1220','Single-Family','Welcome Home to this One-Story Home located in the Burbank Gardens Community. This Home brings Warmth and Character from the moment you step through the door. This Home features 2 Bedrooms, Living Room, Kitchen, and Breakfast Room. Spacious Backyard is great for Entertaining all your Family and Friends. Minutes away from Downtown Houston, Entertainment, Dining, and Shopping. PROPERTY SOLD AS IS','0.1818','9','','','Gas Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','0','','','Northwest Houston','No Heating','0','LT 10 BLK 1 BURBANK GARDENS SEC 3','Subdivision Lot','7920','Appraisal District','','','0','','1','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','DE CHAUMES ELEMENTARY SCHOOL','SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER','FONVILLE MIDDLE SCHOOL','Accompany,Lockbox Back','Appraisal District','1','Traditional','Burbank Gardens','2381','2.3307','Public Sewer,Public Water','1950','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','214957337','1669040316','214957337','2022-11-18T21:54:23.270','90042145','Madeline Phillips','Premier Property Group','','','30.606758','-94.952079','24','77335','4','179900.00','Active','Tyler','159','Road','Goodrich','2','0','4','1568','Single-Family','LIKE NEW 4bed/2bath manufactured home nestled on over half of an acre with easy access to Hwy 59! This property features an oversized front porch, covered concrete awning that runs along the entire back of the home, and much more! This home has been well taken care of, let’s go take a look!','0.535','44','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Lake Livingston Area','Central Electric','0','TYLER ESTATES LOT 5','Cleared,Subdivision Lot','23305','Appraisal District','','','0','','0','','0','','','','','Composition','138 - Goodrich','GOODRICH ELEMENTARY SCHOOL','GOODRICH HIGH SCHOOL','GOODRICH MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Tyler Estates','96','1.7032','Public Sewer,Public Water','2021','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214960988','1669040316','214960988','2022-11-18T21:26:48.340','54787948','Mario Rivas','RE/MAX Universal','','','29.866846','-95.193859','15','77044','6','242500.00','Active','Dawson Hill','9927','Lane','Houston','2','0','3','1197','Single-Family','One story Centex (Adams plan) very GORGEOUS and BEAUTIFUL Stone/Brick home! All bedrooms down! High 9\' ceilings! Gourmet granite kitchen with recessed lighting and comfort height countertops! Tile throughout. High energy home with a Radiant Attic Barrier and a digital thermostat. Ready for IMMEDIATE MOVE-IN! Call to make your appointment.','0.1056','2','Centex','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','North Channel','Central Gas','1','LT 6 BLK 1 SUNRISE PINES SEC 4','Subdivision Lot','4601','Appraisal District','','450','0','','2','Electric Oven','0','','','Electric Range','','Composition','46 - Sheldon','SHELDON LAKEE ELEMENTARY SCHOOL','CE KING HIGH SCHOOL','C.E. KING MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','1','Traditional','Sunrise Pines Sec 4','5825','2.9993','Public Sewer,Public Water,Water District','2016','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','214961201','1669040316','214961201','2022-11-18T22:01:21.837','74893575','Brandon Snyder','eXp Realty, LLC','','','29.715541','-95.579585','13','77072','3','204999.00','Active','Bugle','4111','Road','Houston','2','0','3','1492','Single-Family','INVESTOR SPECIAL, 3 BEDROOM 2 BATH. In the heart of Alief this investor friendly rental is already cash flowing and ready for its new owner. ','0.1374','28','','','','','Sellers Disclosure','','','1','Alief','Central Electric','1','LT 36 BLK 1 BRAYS VILLAGE SEC 5','Other','5985','Appraisal District','','300','0','','2','','0','','','','','Composition','2 - Alief','CHANCELLOR ELEMENTARY SCHOOL','AISD DRAW','ALIEF MIDDLE SCHOOL','Temporarily No Showings','Appraisal District','1','Traditional','Brays Village Sec 05','4827','2.4411','Public Sewer,Public Water','1977','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214961398','1669040316','214961398','2022-11-18T22:03:24.200','31507088','Karen Kaman','First US Services & ChannelsLLC','','','30.159657','-95.205078','17','77357','6','259900.00','Active','Cicerone Ct','18984','','New Caney','2','1','4','1922','Single-Family','Lennar Homes Gulf Coast Series, in Beautiful Tavola! Two stories with 4 bedrooms, 2.5 bathrooms and 2 car garage. Foyer opens to family room. Amazing Kitchen with 36\" Designer Cabinets, Granite Countertops. Breakfast dining area with Window seat & great stainless appliance pkg. Refri included.Smart home featuring.','','40','','','','','Mud,Sellers Disclosure','1','','','Porter/New Caney East','Central Gas','1','Tavola Sec 25, Block 4, Lot 03','Subdivision Lot','','','','800','0','','2','','0','','','','','Composition','39 - New Caney','TAVOLA ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','KEEFER CROSSING MIDDLE SCHOOL','Appointment Required,Lockbox Front','Builder','2','Traditional','Tavola','','','Public Sewer,Water District','2019','Builder'); --> New record created successfully