Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T02:34:28.043' ,`MLSNumber` = '72614110' ,`ListAgentFullName` = 'Jason Wyche' ,`ListOfficeName` = 'Traditions Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834848' ,`Longitude` = '-95.775647' ,`PhotoCount` = '34' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '349990.00' ,`Status` = 'Active' ,`StreetName` = 'Fenetre Forest' ,`StreetNumber` = '4223' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2668' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Take a look and fall in love with your new home in Ventana Lakes. This cozy home comes enhanced with hand-scraped hardwood floors on the first level and tile in all wet areas. The kitchen is filled with all stainless-steel GE appliances, a gas cooktop, 42” cabinets, and granite counters with a tile backsplash. Seller is offering a $3k for Carpet & Paint. Perfect for growing or extended families, the first-floor grants 3 bedrooms, 2 full baths, and a home office with a splendid view of the front yard. The upstairs provides an added layer of privacy as it is equipped with a game room, an additional bedroom, and full bath. Still not convinced that this home is the right home for you? Take a seat on the covered front porch or covered patio in the backyard. Lucky for you, there are no backyard neighbors.' ,`Acres` = '0.1486' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 3 VENTANA LAKES SEC 3' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '6475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ventana Lakes' ,`TaxAmount` = '9202' ,`TaxRate` = '3.2768' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664385957' WHERE `Matrix_Unique_ID` = '207770041' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T02:31:08.930' ,`MLSNumber` = '64619128' ,`ListAgentFullName` = 'Christine Luong' ,`ListOfficeName` = 'Realty USA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.725869' ,`Longitude` = '-95.447323' ,`PhotoCount` = '40' ,`PostalCode` = '77005' ,`RoomCount` = '9' ,`ListPrice` = '799000.00' ,`Status` = 'Active' ,`StreetName` = 'Childress' ,`StreetNumber` = '4274' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3528' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3-Story stucco townhome in a the West-U area boast fresh paints, new floorings in bedrooms with first floor living, open concept with high ceilings, crown moldings, tavertine floorings, new stainless steel cooktop/microwave/dishwasher, and breakfast bar. 2nd floor has 2 bedrooms each with it\'s own bathrooms, one has a balcony/terrace, huge game room and a sunroom. Primary bedroom is located on the third floor along with another bedroom with it\'s own bathroom as well. Primary bath has double sinks, separate shower and oversize tub. Covered patio with full size sink and counterspace for outdoor cooking. Spacious side yard to enjoy your BBQ with no back neighbors. Stainless steel fridge, washer and dryer included. Minutes to 59 freeway, Westpark Tollway, a wide variety of restaurants, national retailers, shopping centers, night life, parks etc... A must see to appreciate!' ,`Acres` = '0.0623' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 YASSIR COURT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2715' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Yassir Court' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664385957' WHERE `Matrix_Unique_ID` = '211199953' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T02:06:01.860' ,`MLSNumber` = '29841813' ,`ListAgentFullName` = 'Shalom Cepeda' ,`ListOfficeName` = 'Vive Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.174394' ,`Longitude` = '-95.226754' ,`PhotoCount` = '22' ,`PostalCode` = '77357' ,`RoomCount` = '10' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Brook Forest' ,`StreetNumber` = '22236' ,`StreetSuffix` = 'Road' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1716' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Are you ready to get to the country yet still close to grocery stores, shopping, movie theatre, and waterpark? Want to see every star in the sky? You can do that here. Nestled in the quiet New Caney subdivision of Brook Forest, this home features 1,716 square feet of living space. Tile throughout the whole house. This home also sits on a 1.69 acre lot. Never flooded!!! Make an appointment today.\r\n\r\nNote - \r\nNew water heater, new water well pump, new 5-ton AC system (electric), new cement patio, new plumbing (throughout the whole house), new wiring & breaker box, new pre-fab cabinets, new 30-year roof (2019) and, new limestone driveway with limestone paver blocks.' ,`Acres` = '1.69' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S271000 - BROOK FOREST, LOT 111, ACRES 1.69' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '73616' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brook Forest' ,`TaxAmount` = '2520' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664385958' WHERE `Matrix_Unique_ID` = '211451455' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T02:09:44.780' ,`MLSNumber` = '64517107' ,`ListAgentFullName` = 'Natasha Bhakta' ,`ListOfficeName` = 'Houston Dwell Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701546' ,`Longitude` = '-95.717421' ,`PhotoCount` = '17' ,`PostalCode` = '77407' ,`RoomCount` = '8' ,`ListPrice` = '334500.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Heath' ,`StreetNumber` = '19103' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2108' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This well-kept home will not stay for long. Home has tile flooring throughout, ample natural light, high ceilings, extra space to design and add new homeowners personal touch. This ready to move in home has upgrades including an oversized porch, extra paved backyard, shed for storage, insulated garage door, installed water softener, pre-wired for sound and security and many more attributes. This three bedroom two bath home has an abundance of natural light to create a warm space with a convenient one story layout to access all parts of the home. Home is located in a community with plenty of amenities for families to access. Zoned to Fortbend ISD with easy routes to and from Westpark Tollway and Grand Parkway.' ,`Acres` = '0.1355' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND MISSION SEC 5, BLOCK 2, LOT 15' ,`LotDesciption` = 'Other' ,`LotSize` = '5904' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '827' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Mission' ,`TaxAmount` = '5184' ,`TaxRate` = '2.5097' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664385958' WHERE `Matrix_Unique_ID` = '212173118' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T02:45:52.253' ,`MLSNumber` = '64534047' ,`ListAgentFullName` = 'Veronica Alarcon' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.510043' ,`Longitude` = '-95.801906' ,`PhotoCount` = '23' ,`PostalCode` = '77469' ,`RoomCount` = '7' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Cottage Creek' ,`StreetNumber` = '5023' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2493' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great size home!! 4/5 bedrooms because a closed in game room could be converted to a room and there is still an office/study room as well. Home could use minor TLC. Paint/upgrades as home has builder grade counter tops etc. Home is ready for the buyer to make this place fit their groove!! Don\'t miss out. This home is priced to sell!! Bring your offer and call your favorite realtor because this home will not last. This back yard has room for your own oasis! Large enough for a pool and much more! Huge lot! Come see for yourself as pictures do not do justice!! Buyer to verify all room measurements *seller provided estimates**' ,`Acres` = '0.1462' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE TRAILS AT SEABOURNE PARK SEC 1, BLOCK 7, LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6370' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Trails At Seabourne Park Sec 1' ,`TaxAmount` = '4885' ,`TaxRate` = '3.0248' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664385958' WHERE `Matrix_Unique_ID` = '212325462' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T03:20:16.860' ,`MLSNumber` = '68271094' ,`ListAgentFullName` = 'Jeri Bailey' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.617070' ,`Longitude` = '-95.059849' ,`PhotoCount` = '21' ,`PostalCode` = '77331' ,`RoomCount` = '13' ,`ListPrice` = '489000.00' ,`Status` = 'Active' ,`StreetName` = 'Paradise' ,`StreetNumber` = '40' ,`StreetSuffix` = 'Trail' ,`City` = 'Coldspring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2256' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COME TO PARADISE! SPECTACULAR WATERVIEW TWO STORY HOME. This one of a kind home is situated on 2 lots (over 1/2 acre) and the home sits high on a hill giving you fantastic views of Lake Livingston. Layout is open and spacious w/living area open to the views and lots of natural light. Austin stone wood burning fireplace. Kitchen has stainless steel appliances, granite countertops, walk-in pantry & desk area w/ lots of cabinets. Updates include new paint, awning over sunroom, AC units, windows throughout house w/lifetime warranty, PEX plumbing in attic from upstairs bathroom to hot water heater. Updated bathrooms include walk-in shower, fixtures, flooring & paint. Oversized detached 2 car garage w/ full bathroom & upstairs unfinished bonus room. Views from every bedroom! Neighborhood is small, quiet & friendly w/amenities - boat ramp, park, swimming area & private pier. Sit on your wrapped porch or entertain in the sunroom. Come live where you are always \"Living on Lake Time\"' ,`Acres` = '0.6984' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PARADISE COVE, BLOCK 7, LOT 25 & 26, ACRES .6984' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '30422' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '40' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Paradise Cove' ,`TaxAmount` = '5190' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Aerobic,Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664385958' WHERE `Matrix_Unique_ID` = '212517553' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T03:00:48.917' ,`MLSNumber` = '56341438' ,`ListAgentFullName` = 'Jon Caballero' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = 'Helen Pac Franco' ,`SellingOfficeName` = 'Keller Williams Metropolitan' ,`Latitude` = '29.775601' ,`Longitude` = '-95.357419' ,`PhotoCount` = '27' ,`PostalCode` = '77009' ,`RoomCount` = '5' ,`ListPrice` = '424990.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Harrington' ,`StreetNumber` = '1003' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1590' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OFFER DEADLINE MONDAY 9/26 @ 1PM •• Beautiful and highly sought-after 3 bed / 2 bath single-story bungalow on a highly desirable 5,000 sf corner lot. PERFECT FOR ENTERTAINING thanks to its OPEN FLOOR PLAN, oversized island, spacious front and back porches, and an oversized carport that also functions as an outdoor, covered entertaining space with recessed lighting. Driveway can fit up to 6 cars. Interior features genuine hardwood floors, stone countertops, high ceilings, and custom cabinetry. UNIQUELY WHEELCHAIR & STROLLER FRIENDLY via the wheelchair ramp along the side of the house, plus an extra-wide front door and bathroom. Exterior features custom shed (with warranty), irrigation system, concrete pad for a generator, and fountain. Schedule a showing today!' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 FLORES REFUGE' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHERMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Ac Allens Add' ,`TaxAmount` = '7790' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664385958' WHERE `Matrix_Unique_ID` = '212664012' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T03:00:26.843' ,`MLSNumber` = '91286592' ,`ListAgentFullName` = 'Carol Knott Tefft' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.214654' ,`Longitude` = '-95.528705' ,`PhotoCount` = '27' ,`PostalCode` = '77382' ,`RoomCount` = '6' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Sienna' ,`StreetNumber` = '11' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1908' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous location with Alden Bridge of The Woodlands providing a short walk to the area shopping center. Quiet, peaceful neighborhood featuring patio homes. This home has a lovely backyard complete with extended patio and hot tub! This single story patio home on a culdesac will wow you as soon as you enter. Wide wood-look tile flooring in all common areas. The kitchen was remodeled a few years ago and features gas cooktop, granite countertops and a wine fridge. Living area was extended to include approximately 150 sq ft (per seller) Open plan with high ceilings, a beautiful stacked stone fireplace, study with built-ins are just a few of the features that may appeal to you! Washer, dryer and refrigerator will convey to buyer. Within the last 5 years, HVAC system with scrubber, water heater, roof and exterior paint (per seller). Don\'t miss this opportunity!' ,`Acres` = '0.1354' ,`Area` = '15' ,`BuilderName` = 'Village' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL ALDEN BR 30, BLOCK 1, LOT 7' ,`LotDesciption` = 'Cul-De-Sac,Patio Lot' ,`LotSize` = '5900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUCKALEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Alden Br 30' ,`TaxAmount` = '6753' ,`TaxRate` = '2.1811' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664385958' WHERE `Matrix_Unique_ID` = '212757338' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T03:00:04.753' ,`MLSNumber` = '10868215' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Sugra Shaik' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '29.571545' ,`Longitude` = '-95.518441' ,`PhotoCount` = '39' ,`PostalCode` = '77459' ,`RoomCount` = '14' ,`ListPrice` = '424795.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Griffith View' ,`StreetNumber` = '1114' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2607' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Dramatic today style Chic Stucco & Brick Timeless Elevation! Huge Private Lot W/Covered Patio! 1 Story Ranch Home! Guest Suite W/Bathroom, 3 Guest Bedrooms & Primary Suite! Home Office/Study! Dramatic Open Floor Plan that will welcome you with Carefree Luxurious Wood Plank Vinyl Floors! Huge Family Area open to the Casual Dining & Gourmet Kitchen! Gourmet Kitchen Boasts Tall Stylish Shaker Cabinets, Tile Backsplash, Stainless Steel Appliances, Gorgeous Quartz Counters, Walk In Pantry, Deep Undermount Stainless Steel Sink, Wonderful Large Eat In Working Station Island! Private Primary Suite W/High Ceilings, Huge Walk In Closet, Large Vanity with Quartz Counters with His & Her Undermount Sinks, Large Tile Floors, Shower & More! Guest Bathroom W/Quartz Counters! Guest Bedrooms W/Huge Closets! Fully Landscaped Front & Back Yards! Energy HERS Rated W/Tankless/On-Demand H2O Heater! Park\'s Edge is a 300 acre Master Planned Community W/Lap Pool, Waterslides, Playgrounds, Sports Fields & More!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Parks Edge: Lot 12 /Block 3' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PALMER ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Parks Edge' ,`TaxAmount` = '' ,`TaxRate` = '3.240027' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664385959' WHERE `Matrix_Unique_ID` = '212760993' --> 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','212829268','1664385959','212829268','2022-09-28T03:28:30.657','90526312','Latosha Davis','Keller Williams Professionals','','','29.484455','-95.364739','32','77578','6','439500.00','Active','Marble Falls','6607','Lane','Manvel','2','1','3','2552','Single-Family','Welcome to this meticulously maintained Cervelle Custom Home! This beautiful Waterfront property comes completely furnished for immediate move in! As you enter the home there\'s a private study to your left that can easily be converted into a fourth bedroom. Nestled in the primary bath is a sensational soaker tub for relaxation. Kitchen presents massive storage, granite counter tops, built in microwave, oven and under cabinet lighting. This ultimate floor plan boost soaring ceilings, formal dining with columns, solar screens for energy savings, storm doors, extensive crown molding and bay windows. Not to mention this spacious lot has a covered deck/patio, plenty of parking space, and a huge backyard great for entertaining. SCHEDULE YOUR SHOWING TODAY!','0.2444','5','Cervelle Custom Home','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Alvin North','Central Electric','1','LAKELAND SD SEC 4 (A0493 HT&BRR) (MANVEL) BLK 2 LOT 66','Waterfront','10646','Appraisal District','','450','0','','4','Electric Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','E C MASON ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','MANVEL JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox','Appraisal District','1','Mediterranean,Traditional','Lakeland SD Sec 4 A0493 Ht&Br','11674','3.5974','Water District','2018','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213022055','1664385959','213022055','2022-09-28T02:21:12.813','37728759','Tisha Matticks','Matticks Real Estate &','','','30.469904','-95.008561','45','77371','7','275000.00','Active','Hickory','211','Street','Shepherd','2','0','3','1596','Single-Family','Enjoy this quite Brick Single Family Home located in the serenity of Sam Houston Forest located not faraway. Three bedroom, two baths, dining area with living with a wood burning fireplace and mantel. Kitchen with lots of cabinets and U-shape counter space. Fridge (dated fridge, good as a secondary fridge) will remain with property. Master Bedroom consist of a Window AC for those that like rooms extra cold without freezing the guest bedrooms.\r\nDouble vehicle garage, with a double vehicle carport. Small workshop in the rear of the garage. Lots of back yard, large enough to add a swimming pool. Back & Front Porch. Garden area around the side and front for all you Garden Growing Farmers. The owner put extra money into his driveway so it will last for many years out. This home is none restricted and easy access to Hwy 150 or FM 2025. All furniture is For Sale as well.','0.3874','64','','','Electric Dryer Connections,Washer Connections','','Home Protection Plan,Sellers Disclosure','1','Wood Burning Fireplace','1','Coldspring/South San Jacinto County','Central Electric','0','COZY FOREST, BLOCK A, LOT 10 & 11, the N 25\'','Subdivision Lot','16875','Appraisal District','','','0','','2','Freestanding Oven','0','','','Freestanding Range','','Composition','130 - Shepherd','SHEPHERD PRIMARY SCHOOL','SHEPHERD HIGH SCHOOL','SHEPHERD MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal','1','Traditional','Cozy Forest','2528','1.8509','Septic Tank','1987','Appraisal'); --> 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','213028631','1664385959','213028631','2022-09-28T02:55:24.253','43649452','Alexandra McCauley','Keller Williams Realty - Memorial','','','29.672154','-95.516615','50','77071','12','519900.00','Active','Braesview','7830','Lane','Houston','2','1','5','3938','Single-Family','Welcome home to 7830 Braesview Ln, in highly sought after Braeburn Valley. This fully remodeled 2 story home, sits on an oversized lot boasting 5 beds (primary down) & 2.5 baths. This charming cottage style property is conducive to anyone looking to entertain. Formal living area overlooks the street & can easily be converted to a home office or play room. Open floor plan leads into a massive formal dining space, living area & expansive chefs kitchen. Kitchen features a center island, white shaker cabinets, quartz counter tops & ample upper & lower cabinet storage & built in pantry. Primary bed located downstairs. Secondary bedroom down as well. 3 generous sized bedrooms upstairs. Middle bedroom includes a gas log fireplace. Easily convert this room to a 2nd playroom, workout area, etc. All beds up are extremely spacious. Full bath w/tub & shower combo up. Lovely backyard w/patio & ample room to build a pool. Close proximity to hike & bike trails, entertainment, local eateries & more!','0.2112','20','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','2','Brays Oaks','Central Gas','1','LT 19 BLK 1 BRAEBURN VALLEY SEC 3','Subdivision Lot','9200','Appraisal District','','450','0','','2','Double Oven','0','','','Electric Range','','Composition','27 - Houston','MILNE ELEMENTARY SCHOOL','SHARPSTOWN HIGH SCHOOL','WELCH MIDDLE SCHOOL','Appointment Required','Appraisal','1','Traditional','Braeburn Valley Sec 03','6065','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','213035998','1664385959','213035998','2022-09-28T03:04:24.007','93490771','Etha Eglin','Keller Williams Metropolitan','','','30.141428','-93.786723','18','77632','8','404990.00','Active','Allie Payne','3405','Road','Orange','3','0','5','2594','Single-Family','The Irving x50l is a gorgeous single-story by America\'s Builder D.R. Horton located in a beautiful private lake community, Mallard Lakes. Offering a spacious 2,594 square feet home, 5 bedroom, 3 bathroom, 2-car garage plan. Ranch style layout which ideal for entertaining. The foyer leads you into the spacious dining room just off the living room. This layout offers a large open concept kitchen with a granite island and is equipped with a large walk-in pantry, Whirlpool Stainless Steel appliances and a gas range. A beautiful bedroom En-Suite located at the rear of the house for complete privacy. Enjoy working from home in your study, perfect for a home office! The exterior comes with front and back sod, landscaping in the front, and a large covered patio! With numerous bedrooms and large living areas, this plan has everything you’ve been looking for!','0.479','50','D.R. Horton','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures','1','','','','Central Gas','0','OAK ALLIE, LOT 14, ACRES 0.48','Subdivision Lot','20865','Appraisal District','','','1','To Be Built/Under Construction','2','Gas Oven','0','','','Freestanding Range','','Composition','683 - Little Cypress-Mauriceville Consolidated','LITTLE CYPRESS ELEMENTARY SCHOOL','LITTLE CYPRESS-MAURICEVILLE HIGH SCHOOL','LITTLE CYPRESS JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Ranch','Oak Allie','185','2.831','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213038215','1664385959','213038215','2022-09-28T03:50:20.170','94793769','Sharlene Mercier','Soho Realty & Mtg Lending, Inc','','','29.507410','-95.411317','11','77578','4','380000.00','Active','Desert Willow','9','Court','Manvel','2','1','4','2513','Single-Family','','0.132','5','','','','','Mud,Sellers Disclosure','1','','1','Alvin North','Central Gas','1','RODEO PALMS THE COLONY SEC 4 (A0299 HT&BRR)(MANVEL) BLK 1 LO','Subdivision Lot','5750','Appraisal District','','650','0','','2','','0','','','','','Composition','3 - Alvin','DON JETER ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','RODEO PALMS JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Rodeo Palms, The Colony Sec 4','9284','3.6694','Public Sewer,Public Water,Water District','2014','Appraisal District'); --> New record created successfully