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'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','205911341','1663706390','205911341','2022-09-03T17:01:05.873','82890191','Ben Caballero','Highland Homes Realty','','','29.806252','-95.841973','18','77493','12','600000.00','Active','Country Lane','2630','','Katy','3','1','4','3118','Single-Family','MLS# 82890191 - Built by Highland Homes - Ready Now! ~ Model Home with 5 bedrooms, 4 full and 1 powder bath. Two bedrooms down with beautiful study. Family room with high ceilings and floor to ceiling fireplace. Upstairs has game room and 3 additional bedrooms!','','25','Highland Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','Gas Connections,Wood Burning Fireplace','1','Katy - Old Towne','Central Gas,Zoned','1','Lot 48 Block 1','Subdivision Lot','7209','Survey','','1200','1','Never Lived In','2','Electric Oven','0','','','Gas Range','','Composition','30 - Katy','BRYANT ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','KATY JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Cane Island','','3.407','Public Water,Water District','2018','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T17:45:48.500' ,`MLSNumber` = '62010400' ,`ListAgentFullName` = 'John Prell' ,`ListOfficeName` = 'Creekview Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.002728' ,`Longitude` = '-95.554135' ,`PhotoCount` = '42' ,`PostalCode` = '77379' ,`RoomCount` = '14' ,`ListPrice` = '730000.00' ,`Status` = 'Active' ,`StreetName` = 'Kepler Mcvey' ,`StreetNumber` = '9702' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5282' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 story home on large corner lot (.25 + acre) with mature trees and fresh landscaping in a quiet neighborhood. Two bedrooms and 2.5 bathrooms downstairs and a wine cellar. Paradise backyard with stunning pool, waterfalls, palm trees, outdoor lighting and an outdoor kitchen. Wood floors downstairs with new carpet upstairs. Klein schools.' ,`Acres` = '0.2938' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 & TR 17A BLK 1 ESTATES AT WINDRUSH SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '12797' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BRILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Champion Forest' ,`TaxAmount` = '12000' ,`TaxRate` = '2.3465' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706390' WHERE `Matrix_Unique_ID` = '208844307' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T16:18:13.597' ,`MLSNumber` = '46296908' ,`ListAgentFullName` = 'Ashley Diep' ,`ListOfficeName` = 'Hardee & Company Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.582164' ,`Longitude` = '-95.225061' ,`PhotoCount` = '15' ,`PostalCode` = '77089' ,`RoomCount` = '4' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Sageglow' ,`StreetNumber` = '10311' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2274' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Walk into this open home greeted by a fireplace and a spacious vaulted living room. The large windows in the living room brightens the room. The wet bar oversees the living room and is perfect for entertaining many guests. In fact, the driveway is expansive and can hold up to 7 cars not including the garage. Sitting on the corner lot, you:ll have a lot of extra room for activities! This area is very family friendly and zoned to Clear Creek ISD. Never flooded. Also minutes away from Beltway 8 and 45, Memorial Hermann Southeast Hospital and multiple ethnic eateries. Add your own touches! This is a great investment opportunity. Check out the virtual tour!!' ,`Acres` = '0.198' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 18 SAGEGLEN SEC 2' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '254' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'WEBER ELEMENTARY' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'WESTBROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Sageglen Sec 02' ,`TaxAmount` = '5299' ,`TaxRate` = '2.356' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706390' WHERE `Matrix_Unique_ID` = '208973788' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T17:34:38.173' ,`MLSNumber` = '76494439' ,`ListAgentFullName` = 'Sasha Lester' ,`ListOfficeName` = 'RE/MAX Opportunities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.357057' ,`Longitude` = '-95.579010' ,`PhotoCount` = '50' ,`PostalCode` = '77430' ,`RoomCount` = '9' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'River Oaks' ,`StreetNumber` = '18315' ,`StreetSuffix` = 'Road' ,`City` = 'Damon' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3286' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Magnificent Home on 6+ Acres w/Modern Contemporary Flare. Perfectly Situated on the Brazos River, the Property Features a Sheek Solar Powered Fishing Cabin w/Projection Screen, Fire Pit, & Stairway to the River Surrounded By Woods. In the Home, Soak in the Luxurious Tile Bath Tub in The Primary Bedroom or Hop in the Shower Where there are Dual Shower Heads & Numerous Jets. Relax on the 2nd Story Balcony & Watch the Deer Roam. Enjoy a Great TX BBQ & Make S\'mores on the Firepit. The Home Features Bamboo Flooring & a Sleek Modern Kitchen w/Granite Countertops, Single Basin Sink, Glass Island Mount Range Hood in S/S, a Wine Cooler & Cabinets Galore! Want to Explore More? Go Around the Corner to the Neighborhood ATV Trails, Boat Ramp, and River \"Beach\" Access Or to the Stocked Lakes, Playground, & Rec Center. This is Prime Location for Retreat or Short Term Rental. It\'s < 45 mi to Houston & Hobby Airport, < 50 Mi to the Beach, & < 25 Mi to Memorial Hermann SL. Has FIBER INTERNET!!' ,`Acres` = '6.12' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = '0080 E ROBERTSON, TRACT 183, ACRES 6.12, PECAN BEND' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront,Wooded' ,`LotSize` = '266587' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '220' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'E Robertson' ,`TaxAmount` = '5600' ,`TaxRate` = '1.8957' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706390' WHERE `Matrix_Unique_ID` = '209843211' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T16:48:47.537' ,`MLSNumber` = '56591502' ,`ListAgentFullName` = 'Luwannah Lamas' ,`ListOfficeName` = 'ARBOR Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.602150' ,`Longitude` = '-94.996032' ,`PhotoCount` = '20' ,`PostalCode` = '77586' ,`RoomCount` = '5' ,`ListPrice` = '219000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar' ,`StreetNumber` = '4809' ,`StreetSuffix` = 'Street' ,`City` = 'Seabrook' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1230' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t wait to check out this darling home! The property is just minutes away from the bay/beach in the El Jardin Subdivision, and conveniently located off 146 for a fast commute to literally everywhere. This recently remodeled 3 bedroom, 2 bath home has been completely redone, and it has a long drive-way for extra parking. A list of things that have been completed in last 6 months includes: Roof reframed and replaced, HVAC installed, all electrical replaced, all plumbing replaced with PEX piping, insulation installed in attic as well as exterior walls, light fixtures, cabinets throughout house, granite countertops, custom oversized island with seating for 6, kitchen appliances, flooring throughout, doors, trim and neutral paint. The list goes on and on. This is the perfect place to call home.' ,`Acres` = '0.1377' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 23 EL JARDIN BAY SHORE SEC 1' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'El Jardin' ,`TaxAmount` = '3020' ,`TaxRate` = '2.2819' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706390' WHERE `Matrix_Unique_ID` = '210511481' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T17:46:18.607' ,`MLSNumber` = '96130705' ,`ListAgentFullName` = 'Cathy Crawford' ,`ListOfficeName` = 'TAS Realty Group' ,`SellingAgentFullName` = 'Mark Haley' ,`SellingOfficeName` = 'eXp Realty LLC' ,`Latitude` = '29.970646' ,`Longitude` = '-95.506113' ,`PhotoCount` = '50' ,`PostalCode` = '77066' ,`RoomCount` = '11' ,`ListPrice` = '300000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Spanish Oak' ,`StreetNumber` = '5526' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2977' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has been so loved and meticulously maintained. You will LOVE the floor plan - VERY SPACIOUS and well laid out. 5 Bedrooms/3.5 baths! Both Formals, plus family and GAME room! Primary, plus another bedroom DOWN. Laminate flooring, corner gas log fireplace, beamed ceilings and built-in shelving in the family room. Kitchen updated with granite look counters and tile backsplash. Formal living area OR 2nd downstairs bedroom could be a perfect office/study. All full baths have been updated. PEX PLUMBING!!! Exterior with mature landscaping. Great location with easy access to Willowbrook/249/Bltwy 8. Ready for immediate move-in.' ,`Acres` = '0.2167' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 47 017*G6652900-007-047-020 GREENWOOD FOREST SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'GREENWOOD FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'WUNDERLICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Greenwood Forest Sec 07' ,`TaxAmount` = '5234' ,`TaxRate` = '2.3715' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706390' WHERE `Matrix_Unique_ID` = '210786496' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T16:19:25.107' ,`MLSNumber` = '11278653' ,`ListAgentFullName` = 'Inder Thandi' ,`ListOfficeName` = 'Careways Realty & Mgmt. Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.922821' ,`Longitude` = '-95.637153' ,`PhotoCount` = '50' ,`PostalCode` = '77095' ,`RoomCount` = '10' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Driftwood Park' ,`StreetNumber` = '10022' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1841' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RARE FIND: Beau corner lot w/beau home in most desirable subdivision close to 290 and FM 1960/SH 6 in Cyfair ISD & Cyfall High. Impressive 4X19 front porch to relax. Enter thru red front door to well kept one story home w/ 3-2-2, spacious Formal Living & Dining rooms, Large Den w/ceramic gas FP w/nice mental. Large breakfast area & open concept Island kitchen w/double sinks, MW Oven, gas cooking range, new DW being installed, good sized pantry, large breakfastbar, cabinets & lots of counter space. Huge Master bedroom at back w/nice master bathroom w/jacuzzi, separate shower & walkin closet. 2 other bedrooms share the hall bathroom. Good sized utility room w/shelves inside house off hallway. Clean 2-Car garage w/shelves & double driveway. Box windows. Neutral color ceramic plank floors, high ceilings, blinds, & ceiling fans thruout the house. Nice 09X13 covered patio in fenced Backyard. Lawn Sprinkler system installed. Sidewalks, tree lined streets, Jogging/walking trails, play grounds.' ,`Acres` = '0.1319' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 4 WHITE OAK FALLS SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5744' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FIEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side,No Photos/No Videos,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'White Oak Falls' ,`TaxAmount` = '5255' ,`TaxRate` = '2.551' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706390' WHERE `Matrix_Unique_ID` = '210940104' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T16:26:45.557' ,`MLSNumber` = '25083340' ,`ListAgentFullName` = 'Dulce Davis' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.247236' ,`Longitude` = '-95.234629' ,`PhotoCount` = '31' ,`PostalCode` = '77577' ,`RoomCount` = '5' ,`ListPrice` = '288000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 776' ,`StreetNumber` = '215' ,`StreetSuffix` = '' ,`City` = 'Liverpool' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1430' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Renovated home with tons of perks! Sqr ftg is 1430 per professionally created floor plan. Main living area upstairs with beautiful water views of Chocolate Bayou. 2 bedrooms up and 1 bedroom down. Short list of updates: Paint, 2718 sqr ft of concrete, Granite in kitch/bath up, Luxury Vinyl Planking, Porcelain shower surrnd, LED Fans/lights, etc...Other amenities: Cvr deck up 734sqr ft, plus lg cvrd patio on side yard. Fully Cvrd driveway for 8 car parking with 51 ft uncvrd parking. Approx 33x13ft cvrd concrete pad behind home. Overszd 4 car garage spaces. One with workbench separated by cinderblock wall. Water softener, Generac generator w/dedicated propane tank. Half bath down is only toilet with ability to reinstate shower. The Gulf is 5-10 minutes by boat. Multiple boat launches within 2 minutes. This home is water VIEW, no direct access on the property itself. Lutes Marina basically at end of street where you input your boat. Ask for Full About Me Booklet!' ,`Acres` = '0.3444' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HARBORVIEW HOMESITES (A0011 HENRY AUSTIN), LOT 8-9 SEC 1' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '15002' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'WALT DISNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Harborview Homesites' ,`TaxAmount` = '1963' ,`TaxRate` = '2.2507' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706391' WHERE `Matrix_Unique_ID` = '211521050' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T16:13:21.193' ,`MLSNumber` = '83863176' ,`ListAgentFullName` = 'Douglass Williams' ,`ListOfficeName` = 'Olympus/Nelson Realty' ,`SellingAgentFullName` = 'Manuela Serna' ,`SellingOfficeName` = 'Maxima Realty' ,`Latitude` = '29.987098' ,`Longitude` = '-95.503632' ,`PhotoCount` = '50' ,`PostalCode` = '77069' ,`RoomCount` = '10' ,`ListPrice` = '210000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cashel' ,`StreetNumber` = '4723' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1880' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3/2/2 patio home in champions area. Private yard, two-toned paint throughout, updated 18\'\' ceramic tile with carpet, large den with fireplace, living and dining room combo with wet bar, and vaulted ceilings. The exterior of the property has brand new Hardie (cement/fiber) siding and paint. Easy access to FM 1960 and area shopping. A Must See.' ,`Acres` = '0.0803' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 5B & 6A BLK 3 017*C0362900-001-003-005B-006A CHAMPIONS T' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '3500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MITTELSTADT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Champions Terrace Sec 01 U/R' ,`TaxAmount` = '3652' ,`TaxRate` = '2.3715' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706391' WHERE `Matrix_Unique_ID` = '211611115' --> 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','211812668','1663706391','211812668','2022-09-03T16:55:29.167','40508563','Faron Daigle','Faron Daigle Real Estate','','','29.587090','-95.142792','26','77062','9','298300.00','Active','Whitlock','14307','Drive','Houston','2','1','3','1666','Single-Family','14307 Whitlock is a 3 bedroom, 2.5 bath home in the heart of Clear Lake in Bay Glen. All bedrooms are up. Entryway leads directly into the family room that has a soaring ceiling and wood burning fireplace with gas connection. Kitchen features include a double stainless steel sink, stainless steel finish dishwasher, freestanding gas range/oven, and built in microwave. The breakfast area over looks the backyard and has doors leading to the attached garage and backyard. Laundry closet is at the rear of the breakfast area and accommodates full size washer and dryer. Recent wood \"look\" plank flooring in family and dining rooms. Ceramic tile floors in kitchen and breakfast area. Carpet on stairs & in bedrooms. Primary bathroom features double cultured marble sinks, \"garden\" tub, separate shower, and walk-in closet. Full bath 2 features tub/shower combo. Spacious backyard with concrete patio area. Close to NASA, UofH Clear Lake, Ellington Field and Space Center Houston. Easy access to I-45.','0.1525','7','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Clear Lake Area','Central Gas','1','LT 39 BLK 3 BAY GLEN SEC 8','Subdivision Lot','6641','Appraisal District','','500','0','','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','9 - Clear Creek','WARD ELEMENTARY SCHOOL (CLEAR CREEK)','CLEAR BROOK HIGH SCHOOL','CLEARLAKE INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Bay Glen','6120','2.5769','Public Sewer,Public Water,Water District','1990','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','212023649','1663706391','212023649','2022-09-03T16:45:51.387','26192625','Lei Jin','eXp Realty, LLC','','','29.773436','-95.898858','32','77423','7','319999.00','Active','Pappas Dr','10137','','Brookshire','2','1','4','2406','Single-Family','Recently paint on all walls, trim, and doors in August 2022. This home is in Katy ISD! Easy access to the freeway and near major business. Solstice plan is the perfect home for a family. This 4 bedroom and 2.5 bathroom home has a lot of extra space. You will enjoy a bonus room on the first floor and a loft space on the second floor. The kitchen features brand new stainless steel appliances, granite countertops and a spacious pantry. Set up an appointment today!','','26','Starlight Homes','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Fulshear/South Brookshire/Simonton','Central Electric','1','Lot 1, Block 3, Sec 14','Subdivision Lot','6469','Appraisal District','','435','0','','2','Electric Oven','0','','','Electric Cooktop','','Wood Shingle','30 - Katy','BRYANT ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','WOODCREEK JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','2','Traditional','Kingsland Heights','','','Water District','2019','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','212112499','1663706391','212112499','2022-09-03T16:25:05.810','81891981','Mark Smith','Texas United Realty','','','29.701462','-95.720508','14','77407','3','330000.00','Active','Wheaton Hill','7015','Lane','Richmond','2','0','3','2121','Single-Family','This is a gorgeous home in grand mission well maintained and is waiting for a new owner.','0.1528','37','David Weekley','','Gas Dryer Connections','','Mud,Sellers Disclosure,Tenant Occupied','1','','0','Fort Bend County North/Richmond','Central Electric','1','GRAND MISSION SEC 8, BLOCK 1, LOT 12','Subdivision Lot','6656','Other','','950','0','','2','Gas Oven','0','','','Gas Range','','Composition','19 - Fort Bend','SEGUIN ELEMENTARY (FORT BEND)','BUSH HIGH SCHOOL','CROCKETT MIDDLE SCHOOL (FORT BEND)','Appointment Required,Lockbox Left Side,Supra Keybox','Appraisal District','1','Traditional','Grand Mission Sec 8','5581','2.5097','Water District','2006','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212124502','1663706391','212124502','2022-09-03T16:34:13.780','29849000','Maygen Ritchie','BHGRE Gary Greene','','','30.490111','-94.782083','12','77351','2','150000.00','Active','Charles Keys','210','Road','Livingston','2','0','2','1192','Single-Family','Come see this large lot with 2/2 with detached garage. Open space concept living and dinning room. Perfect for an investor. You don\'t want to miss out on this lot.','0.998','44','','','','','Sellers Disclosure','0','','','Livingston Area','Central Electric','0','BIG THICKET LAKE ESTATES SECTION 3 LOT 406, 407, 408, 409 &','Wooded','43472','Survey','','','0','','2','','0','','','','','Aluminum','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','1','Other Style','Big Thicket Lake Estates Secti','1469','1.8745','Public Water,Septic Tank','1967','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','212166799','1663706391','212166799','2022-09-03T16:20:08.020','8562952','Dante Cruz','eXp Realty, LLC','','','30.022552','-95.462758','46','77090','4','496999.00','Active','Castlerock','1710','Drive','Houston','2','1','4','2872','Single-Family','new construction built in 2015 Come to view this gorgeous newly remodeled home with very superb finishings. This exquisite home boasts 4 bedrooms, 3 baths, 2 car garage plus an extravagant large pool. This home is literally like new. The bathrooms are completely and tastefully remodeled with exquisite finishings. painted inside and outside from top to bottom. This beautiful home sits on one of the largest lots in the community. it includes a superb large terrace/patio for your cookouts, enjoyment, and entertainment. Excellent location, very close to a super large, gorgeous park with large lakes and long trails. Call to see this beautiful home today.','0.2122','13','','','','','Sellers Disclosure','','','2','1960/Cypress Creek North','Central Electric,Central Gas','1','LT 8 BLK 25 PONDEROSA FOREST SEC 3','Other','9243','Appraisal District','','479','0','','','','1','In Ground','','','','Composition','48 - Spring','PONDEROSA ELEMENTARY SCHOOL','WESTFIELD HIGH SCHOOL','EDWIN M WELLS MIDDLE SCHOOL','Supra Keybox','Appraisal District','2','Other Style','Ponderosa Forest Sec 03','9395','2.4101','Water District','2015','Seller'); --> 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','212167949','1663706391','212167949','2022-09-03T17:49:37.473','5695917','Renee\' Hollek','O\'Hara & Company Real Estate','','','29.962319','-95.643966','35','77429','5','344998.00','Active','Cricket Hollow','13018','Lane','Cypress','2','0','4','1922','Single-Family','Welcome home to your charming 4 Bedroom house in popular Enchanted Valley! Home boasts four spacious Bedrooms and a large Family Room with vaulted ceilings, that is open to the Kitchen area, great for entertaining! You will also find a cozy Den with a stone fireplace, which can also be used as your home office. In the Kitchen you will find ample cabinet space, with updated cabinets for all your storage needs. After dinner you can step into your own backyard oasis and relax by the pool. There is plenty of room for weekend entertaining also in this large backyard, with the added privacy of no rear neighbors. Pool was re-plastered and coping was replaced in 2002. Pool pump replaced in 2014. Spa heater replaced in 2017. Home AC and Heater replaced in 2015 w/ 16 SEER 5 ton unit. Refrigerator in home to stay. NEVER FLOODED! This home is a MUST SEE and will not last long! Room dimensions should be verified if important.','0.2663','10','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','','1','Cypress North','Central Electric','1','LT 27 BLK 7 ENCHANTED VALLEY SEC 2','Subdivision Lot','11600','Appraisal District','','585','0','','2','Electric Oven,Single Oven','1','Gunite,Heated,In Ground','','Electric Cooktop','','Composition','13 - Cypress-Fairbanks','MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CY-FAIR HIGH SCHOOL','ARNOLD MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Enchanted Valley Sec 02','6285','2.806','Water District','1973','Appraisal District'); --> New record created successfully