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-04T10:25:00.287' ,`MLSNumber` = '77808061' ,`ListAgentFullName` = 'Osaan Ronding' ,`ListOfficeName` = 'The Listing Firm' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.684736' ,`Longitude` = '-95.477972' ,`PhotoCount` = '35' ,`PostalCode` = '77096' ,`RoomCount` = '6' ,`ListPrice` = '799900.00' ,`Status` = 'Active' ,`StreetName` = 'Jackwood' ,`StreetNumber` = '5315' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '4484' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Truly one of a kind. This home has NEVER FLOODED and is NOT a flip. Home was purchased from the original owner in 2010 and taken to the studs. Ceilings were raised to 9 feet and a second floor was added at this time. The home was modernized with new plumbing, wiring, appliances, flooring, etc. The home was redesigned w/ functionality in mind while keeping the craftsmanship that is hard to find in new builds. Other standout features in this home include: All window were replaced with energy efficient windows. The house is extremely well sealed and insulated. Spray foam insulation in the attic makes the house function like an igloo. Enhanced structural support and sheathing was added to the corners of the home to provide further stability in hurricanes, whole house GFI surge protector, external generator hook-up, wired for surround sound in living area & camera system, coax and RJ45 cabling throughout home. Ademco/Honeywell alarm system..all doors and windows.' ,`Acres` = '0.229' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 8 BRAESMONT SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9977' ,`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` = 'LOVETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Braesmont Sec 3' ,`TaxAmount` = '15742' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706672' WHERE `Matrix_Unique_ID` = '206780767' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T10:48:37.153' ,`MLSNumber` = '87106447' ,`ListAgentFullName` = 'Rusty Shannon' ,`ListOfficeName` = 'Patti Shannon Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.936786' ,`Longitude` = '-96.035016' ,`PhotoCount` = '50' ,`PostalCode` = '77423' ,`RoomCount` = '14' ,`ListPrice` = '1349000.00' ,`Status` = 'Active' ,`StreetName` = 'Cessna' ,`StreetNumber` = '12099' ,`StreetSuffix` = 'Place' ,`City` = 'Brookshire' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3215' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Pilots Dream Estate! Your Opportunity to purchase (owner terms available) a Meticulously Maintained, 2021, single story, 3,215 Sq ft Custom Built Brick home in the Gated community of Fair Weather Field. Beautifully landscaped, Fully fenced backyard, & Two Separate, Private, Entry Gates onto your Property. Two Car Garage with Golf Cart Garage too. The interior? The pictures don\'t lie. Shows like a Model Home. The 65x75 Metal Hangar has a 45Wx14T Hydraulic Door, a 12ftT x 10ftW Roll Up Automatic door, a downstairs Build Shop with a Fold Away Wall, and A/C. A Well Appointed Upstairs Apartment above. Plenty of room for aircraft, your car collection, and toys! The Airport Identifier is TX42 with a 3,375 ft long asphalt 13/31 runway & a 2,400 ft 18/36 turf strip. Push your plane from the Hangar to your Over-sized concrete pad. Taxi on a separate asphalt taxiway to the run up - no back taxiing. Plenty of room for other airplanes, invite your friends to fly in & visit. #SearchTexasAirparks' ,`Acres` = '1' ,`Area` = '26' ,`BuilderName` = 'New Camden Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S474600 FAIR WEATHER FIELD BLK 2 LOT 1 ACRES 1.0 (.61 AC IN' ,`LotDesciption` = 'Airpark' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '44 - Royal' ,`SchoolElementary` = 'ROYAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROYAL HIGH SCHOOL' ,`SchoolMiddle` = 'ROYAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,No Photos/No Videos,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Fair Weather Field' ,`TaxAmount` = '20942' ,`TaxRate` = '3.1767' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663706672' WHERE `Matrix_Unique_ID` = '207266555' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T11:51:38.543' ,`MLSNumber` = '57145966' ,`ListAgentFullName` = 'Michael Gaido' ,`ListOfficeName` = 'Sand N Sea Properties, LLC' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.217913' ,`Longitude` = '-94.911922' ,`PhotoCount` = '39' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '895000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Ventura' ,`StreetNumber` = '12628' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1944' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Watch the sunrise from this 4/5 bedroom beachside home with beachfront views and upper/lower decks.This home has a multitude of possibilities to add 1 or 2 bedrooms and a bathroom.Soaring 18’ living room ceilings that might be split & floored for an additional upstairs room.Spacious kitchen/dining with ample cabinet and counter space including hardwood flooring.Large upstairs primary bedroom w beach views from the bed, featuring French doors leading to a Juliet balcony. Large 2nd floor loft that could be converted to a bedroom.Separate utility room off kitchen with W&D,2nd refrigerator.Some of the most recent improvements include new roof in 2018, Upstairs AC 2020, Downstairs AC 2019,Refrigerator 2021, dishwasher 2021, new sewer line 2018. Most of the windows have roll down or louvered shutters.Low slope modified bitumen roofing per seller.Double garage door.Lot to the east is owned by the city.Closer to town than most West End subdivisions. 1998 summary appraisal showing 2,222ft' ,`Acres` = '0.1357' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 61 LOT 46 SPANISH GRANT SEC 11' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '5912' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Spanish Grant' ,`TaxAmount` = '8943' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706672' WHERE `Matrix_Unique_ID` = '209391804' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T11:53:44.297' ,`MLSNumber` = '80080737' ,`ListAgentFullName` = 'Ximena Anderson' ,`ListOfficeName` = 'Resident Realty, Ltd.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.460844' ,`Longitude` = '-95.541379' ,`PhotoCount` = '26' ,`PostalCode` = '77318' ,`RoomCount` = '2' ,`ListPrice` = '145900.00' ,`Status` = 'Active' ,`StreetName` = 'Andwood' ,`StreetNumber` = '12789' ,`StreetSuffix` = '' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '//New construction// Fall in love with this beautiful single story 2 bedroom 2 bath home featuring an open floor plan, high ceilings, granite counters, kitchen island, self closing drawers/cabinets, 42\" upper cabinets, great walk-in-pantry and stainless steel package. Ample primary bedroom with private bath and large walk-in closet. The primary bath has a large shower that gives it a spa like feel. Laundry room is also nice sized too!!! All this at a very affordable price. Come take a look soon, If you put under contract fast enough you can select from a variety of custom colors/material options to give this home your personal touch.' ,`Acres` = '0.0482' ,`Area` = '39' ,`BuilderName` = '3-G Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALNUT COVE 01, BLOCK 12, LOT 41' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '51' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walnut Cove' ,`TaxAmount` = '149' ,`TaxRate` = '1.8698' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706672' WHERE `Matrix_Unique_ID` = '211208491' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T11:56:59.340' ,`MLSNumber` = '16922967' ,`ListAgentFullName` = 'Ximena Anderson' ,`ListOfficeName` = 'Resident Realty, Ltd.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.461309' ,`Longitude` = '-95.541209' ,`PhotoCount` = '28' ,`PostalCode` = '77318' ,`RoomCount` = '3' ,`ListPrice` = '158900.00' ,`Status` = 'Active' ,`StreetName` = 'Black Gum' ,`StreetNumber` = '9753' ,`StreetSuffix` = '' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '//New construction// Fall in love with this beautiful single story 3 bedroom 2 bath home featuring an open floor plan, high ceilings, granite counters, kitchen island, self closing drawers/cabinets, 42\" upper cabinets, great walk-in-pantry and stainless steel package. Ample primary bedroom with private bath and large walk-in closet. The primary bath has a large shower that gives it a spa like feel. Laundry room is also nice sized too!!! All this at a very affordable price. Come take a look soon, If you put under contract fast enough you can select from a variety of custom colors/material options to give this home your personal touch.' ,`Acres` = '0.0482' ,`Area` = '39' ,`BuilderName` = '3-G Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALNUT COVE 01, BLOCK 12, LOT 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walnut Cove' ,`TaxAmount` = '149' ,`TaxRate` = '1.8698' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706672' WHERE `Matrix_Unique_ID` = '211208957' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T11:51:36.313' ,`MLSNumber` = '991087' ,`ListAgentFullName` = 'Mohammed Hossain' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.704473' ,`Longitude` = '-95.366007' ,`PhotoCount` = '50' ,`PostalCode` = '77021' ,`RoomCount` = '4' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Tampa' ,`StreetNumber` = '3507' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great location! Less than two miles from the Med Center and Museum district. Minutes from UH and TSU. Enjoy \'big city\' living without \'big city\' prices. Great starter home across from neighborhood elementary school. Wonderful investment!' ,`Acres` = '0.1337' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Riverside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 1 TERRACE OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5824' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'THOMPSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Terrace Oaks' ,`TaxAmount` = '4961' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706672' WHERE `Matrix_Unique_ID` = '211214010' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T10:55:37.367' ,`MLSNumber` = '47097279' ,`ListAgentFullName` = 'Tresa Olsen' ,`ListOfficeName` = 'Treasure Chest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.378675' ,`Longitude` = '-95.023711' ,`PhotoCount` = '50' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '324900.00' ,`Status` = 'Active' ,`StreetName` = 'Parkstone' ,`StreetNumber` = '110' ,`StreetSuffix` = 'Drive' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2198' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check back soon as new photos being posted throughout the day. OR, schedule your appointment to see this fabulous home that has some custom added features you won\'t find in the new builds or other area homes...from the beautiful chandelier to the decorative & stylish tiled walls under counter/bar, the added modern faux fireplace with remote, and the added under stairway lighted book nook, or use for toy play house & storage, or pet house...and more. This home is a MUST SEE! HVAC is single unit with dual zoning. The game room upstairs is NOT a loft that opens to the living area (only a half wall to the entry). So, game room is is an actual room with the stairway and walls as a noise buffer. LET THE GAMES BEGIN and still enjoy your quiet time downstairs. Small wood brace above fireplace was for sellers\' 80 inch TV. They left brace in case new owners needed it. But they can also remove & paint that small area if new owners don\'t need it. NOTE: Room sizes are estimates.' ,`Acres` = '0.1379' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LANDING AT DELANY COVE SEC 2 (2016) ABST 2, BLOCK 1, LOT 4,' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6008' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Delany Cove' ,`TaxAmount` = '7637' ,`TaxRate` = '3.1135' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706672' WHERE `Matrix_Unique_ID` = '211386969' --> 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','211612379','1663706673','211612379','2022-09-04T11:29:55.193','58994287','Sabrina Ash','Keller Williams Premier RealtyKaty','','','29.869310','-95.780581','31','77493','11','660000.00','Active','Providence River','6511','Lane','Katy','5','0','6','3888','Single-Family','Spacious 6 bedroom Next Gen plan - a home within a home. Second living quarters features it\'s own front door, kitchenette, bedroom, living area, washer/dryer hook up and full bath with shower. The main home offers an inviting foyer entry, island kitchen w/walk-in pantry, dining area with a spacious family room, large utility room, mud room and a 3 car garage. Covered back patio and no back neighbors. First floor offers a 2nd bedroom and full bath room. Second floor offers 3 bedrooms, 2 full baths, game room, media room. Each bath has it\'s own medicine cabinet and linen closet, providing ample space throughout. Pre-wired for a generator, full gutters and reverse osmosis in both kitchens, offers filtered water for drinking and cooking. Call to schedule your private tour today! This spacious home is great for entertaining and won\'t last long!','0.1841','25','Village Builders','','Electric Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gas Connections','1','Katy - Old Towne','Central Gas','1','LT 28 BLK 1 ELYSON SEC 9','Greenbelt,Subdivision Lot','8019','Appraisal District','','1280','0','','3','Electric Oven','0','','','Gas Cooktop','','Composition','30 - Katy','MCELWAIN ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','STOCKDICK JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Seller','2','Traditional','Elyson','15295','3.5368','Water District','2019','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T11:39:58.410' ,`MLSNumber` = '73054241' ,`ListAgentFullName` = 'Melissa Joseph Balderas' ,`ListOfficeName` = 'CJM Realty Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806644' ,`Longitude` = '-95.357732' ,`PhotoCount` = '18' ,`PostalCode` = '77009' ,`RoomCount` = '5' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Joyce' ,`StreetNumber` = '1017' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1818' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in Houston\'s Hidden gem, Lindale Park. This 1818 SF home sits on a large corner lot. Lindale Park is located inside the Loop and a 10 minute drive from downtown Houston. Here you will find oak trees, dog walkers, friendly neighbors, and an old-fashioned vibe. Great restaurants and coffee shops are also close by. Schedule your private tour today! Property is being sold as is. Lindale is a rapidly appreciating area with easy access to 610 and 45.' ,`Acres` = '0.1322' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 38 & TR GG BLK 20 LINDALE PARK SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '5760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'JEFFERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lindale Park Sec 03' ,`TaxAmount` = '5084' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706673' WHERE `Matrix_Unique_ID` = '211745005' --> 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','212042288','1663706673','212042288','2022-09-04T11:26:52.753','18048420','Danial Semar','JLA Realty','','','30.361236','-95.091470','23','77328','3','259900.00','Active','Frances','203','Street','Cleveland','2','0','3','1880','Single-Family','Great property on a corner lot in a quiet neighborhood. This 3/2 has a large office/bedroom addition on the back of the house with TONS of natural light! There is a fully fenced high privacy fence and mature trees in the back yard. The brick fireplace is sure to please. There is a freshly updated kitchen with new appliances. The covered back porch is a great place to entertain.','0.4408','52','','','','','Sellers Disclosure','','','1','Cleveland Area','Central Gas','0','TANGLEWOOD, BLOCK 6, LOT 7-9, ACRES .4408','Cleared,Corner','19201','Appraisal District','','','0','','0','','0','','','','','Composition','100 - Cleveland','NORTHSIDE ELEMENTARY SCHOOL (CLEVELAND)','CLEVELAND HIGH SCHOOL','CLEVELAND MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Tanglewood','4433','2.5563','Public Sewer,Public Water','1975','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','212079391','1663706673','212079391','2022-09-04T11:59:14.637','39568025','Ronnie Matthews','RE/MAX Legends','','','30.066296','-95.232144','41','77339','13','499990.00','Active','Black Opal','21523','Lane','Kingwood','3','1','5','3572','Single-Family','YOUR OWN PRIVATE PARADISE! SUPERSIZED FIVE BDRM BEAUTY! RETREAT-STYLE BACKYARD OASIS - POOL + OUTDOOR KITCHEN! Beautiful Elevation - Covered Front Porch! High Ceiling Foyer Opens to Lovely Formals! Gourmet Island Kitchen: Granite Counters, Stainless Appliances, 42\" Cabinetry Galore, & Tile Flooring! Built-In Wine Chiller + Water Softener System! Incredible Two-Story Family Rm - Gas Log Fireplace + Surround Sound Wiring! Privately Located First Floor Master Suite - Garden Bath with Dual Sinks + Walk-In Closet! Oversized Secondary Bdrms - All with Walk-In Closets & Two with Jack & Jill Bath! Enormous Gamerm - AND Movie Lover\'s Media Rm! Unbelievable Backyard: POOL, Extensive Decking, & Outdoor Kitchen with 2 Built-In Grills, Fridge, & Wine Chiller! Garage Currently Used as 2nd Media Rm/Music Rm - Can Easily Be Used as Garage if Desired! Security System with Cameras! Recent A/C Units, Water Heaters, 22 kW Whole Home Generator, Interior & Exterior Paint, PLUS MORE! Mins to Hwy 59 & GP 99!','0.1515','40','Meritage','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Kingwood West','Central Gas,Zoned','1','S642400 - KINGS MILL 01, BLOCK 4, LOT 8','Subdivision Lot','6600','Appraisal District','','650','0','','2','Electric Oven','1','Gunite,In Ground','','Gas Cooktop','','Composition','39 - New Caney','KINGS MANOR ELEMENTARY SCHOOL','PORTER HIGH SCHOOL (NEW CANEY)','WOODRIDGE FOREST MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Kings Mill','10366','3.1831','Public Sewer,Water District','2005','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','212100611','1663706673','212100611','2022-09-04T10:50:16.543','94308305','Rebecca Sherwood','Keller Williams Elite','','','30.061853','-95.917530','24','77484','5','283000.00','Active','Ironwood','31727','Drive','Waller','2','0','3','1480','Single-Family','Fabulously updated 3 bedroom 2 bath home! New paint, flooring, butlers pantry, updated light fixtures, custom updates throughout! New HVAC system, new fence, storage shed, extended back patio and cover and extended driveway. This home has it all and NO HOA or MUD!!\r\nAgent is related to sellers.','0.194','25','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Mock Fireplace,Wood Burning Fireplace','2','Waller','Central Gas','0','LT 4 BLK 9 BRIARTREE SEC 1','Subdivision Lot','8450','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','55 - Waller','','WALLER HIGH SCHOOL','WALLER JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment','Appraisal District','1','Traditional','Briartree Sec 01','3897','2.5948','Public Sewer,Public Water','1979','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','212119607','1663706673','212119607','2022-09-04T10:11:04.307','70879542','Michael Greiner','My Castle Realty','','','30.085460','-96.074300','15','77445','6','205990.00','Active','17th','2524','Street','Hempstead','2','0','4','1209','Single-Family','OPEN-CONCEPT LAYOUT | Don’t miss this opportunity to own a DELIGHTFUL NEW home in the Hempstead Community! The desirable 1201 Plan makes entertaining easy, with a kitchen overlooking a dinette and a generous great room. The Kitchen features gorgeous cabinets, granite countertops, and Stainless-Steel Steel Appliances (Includes Range with a Microwave hood and Dishwasher). All bedrooms, including the laundry room, are on the main floor. The private owner’s suite features an attached bath and walk-in closet. This desirable plan also comes complete with a 1 car garage!','','26','Century Complete','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Hempstead','Central Electric','0','S519000 HEMPSTEAD BLK 641 LOT 3','Subdivision Lot','6250','Other','','','1','To Be Built/Under Construction','1','Electric Oven','0','','','Electric Range','','Composition','24 - Hempstead','HEMPSTEAD ELEMENTARY SCHOOL','HEMPSTEAD HIGH SCHOOL','HEMPSTEAD MIDDLE SCHOOL','Appointment Required,Vacant/Unoccupied','Builder','1','Traditional','Hempstead','','2.418','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','212119921','1663706673','212119921','2022-09-04T10:10:22.080','96598907','Michael Greiner','My Castle Realty','','','30.085460','-96.074300','15','77445','6','205990.00','Active','17th','2544','Street','Hempstead','2','0','4','1209','Single-Family','OPEN-CONCEPT LAYOUT | Don’t miss this opportunity to own a DELIGHTFUL NEW home in the Hempstead Community! The desirable 1201 Plan makes entertaining easy, with a kitchen overlooking a dinette and a generous great room. The Kitchen features gorgeous cabinets, granite countertops, and Stainless-Steel Steel Appliances (Includes Range with a Microwave hood and Dishwasher). All bedrooms, including the laundry room, are on the main floor. The private owner’s suite features an attached bath and walk-in closet. This desirable plan also comes complete with a 1 car garage!','','26','Century Complete','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Hempstead','Central Electric','0','S519000 HEMPSTEAD BLK 641 LOT 5','Subdivision Lot','6250','Other','','','1','To Be Built/Under Construction','1','Electric Oven','0','','','Electric Range','','Composition','24 - Hempstead','HEMPSTEAD ELEMENTARY SCHOOL','HEMPSTEAD HIGH SCHOOL','HEMPSTEAD MIDDLE SCHOOL','Appointment Required,Vacant/Unoccupied','Builder','1','Traditional','Hempstead','','2.418','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','212120109','1663706673','212120109','2022-09-04T10:09:36.527','36977808','Michael Greiner','My Castle Realty','','','30.085460','-96.074300','15','77445','6','199990.00','Active','17th','2531','Street','Hempstead','2','0','4','1209','Single-Family','OPEN-CONCEPT LAYOUT | Don’t miss this opportunity to own a DELIGHTFUL NEW home in the Hempstead Community! The desirable 1201 Plan makes entertaining easy, with a kitchen overlooking a dinette and a generous great room. The Kitchen features gorgeous cabinets, granite countertops, and Stainless-Steel Steel Appliances (Includes Range with a Microwave hood and Dishwasher). All bedrooms, including the laundry room, are on the main floor. The private owner’s suite features an attached bath and walk-in closet. This desirable plan also comes complete with a 1 car garage!','','26','Century Complete','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Hempstead','Central Electric','0','S519000 HEMPSTEAD BLK 642 LOT 9','Subdivision Lot','6250','Appraisal District','','','1','To Be Built/Under Construction','1','Electric Oven','0','','','Electric Range','','Composition','24 - Hempstead','HEMPSTEAD ELEMENTARY SCHOOL','HEMPSTEAD HIGH SCHOOL','HEMPSTEAD MIDDLE SCHOOL','Appointment Required,Vacant/Unoccupied','Builder','1','Traditional','Hempstead','','2.418','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','212120268','1663706673','212120268','2022-09-04T10:12:32.150','27047866','Michael Greiner','My Castle Realty','','','30.085460','-96.074300','19','77445','9','245990.00','Active','18th','2527','Street','Hempstead','2','0','4','1801','Single-Family','GENEROUS GREAT ROOM | FLEX SPACE\r\nDon’t miss this opportunity to own a BEAUTIFUL NEW 2 Story home in the Hempstead Community! The desirable 1801 Plan highlights an open spacious great room overlooking a charming Dining area and a Flex Room. The Kitchen features gorgeous cabinets, granite countertops, and Stainless-Steel Steel Appliances (Includes Range with Microwave and Dishwasher). All bedrooms, including the laundry room, are on the 2nd floor. The primary suite has a private bath with dual vanity sinks and a walk-in closet. This desirable plan also comes complete with a 1 car garage.','','26','Century Complete','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Hempstead','Central Electric','0','S519000 HEMPSTEAD BLK 643 LOT 8','Subdivision Lot','6250','Other','','','1','To Be Built/Under Construction','1','Electric Oven','0','','','Electric Range','','Composition','24 - Hempstead','HEMPSTEAD ELEMENTARY SCHOOL','HEMPSTEAD HIGH SCHOOL','HEMPSTEAD MIDDLE SCHOOL','Appointment Required,Vacant/Unoccupied','Builder','1','Traditional','Hempstead','','2.418','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','212175898','1663706673','212175898','2022-09-04T11:16:53.987','57240472','Nancy Wong','ABC Realty Advisor','','','29.817667','-95.696954','34','77084','7','315000.00','Active','Bluebonnet Meadows','3310','Lane','Houston','2','1','4','2216','Single-Family','Fabulous Trendmaker home with spacious island kitchen & large master with exec bath. Enormous deck in the backyard. Floorplan begs to entertain -- high ceilings, lots of natural light. Carpet upstairs. All bedrooms are up leaving worlds of space downstairs. Beloved Neighborhood...many family activities...walking trails, parks. Room sizes approx. Currently tenant occupied, serious inquiries only. Currently tenant occupied until the end of July 2023. Minimum of a two hour notice','0.1446','25','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Katy - North','Central Gas','1','LT 87 BLK 15 BARKERS RIDGE SEC 1 R/P','Subdivision Lot','6300','Appraisal District','','495','0','','2','Electric Oven','0','','','Electric Range','','Composition','30 - Katy','SCHMALZ ELEMENTARY SCHOOL','MAYDE CREEK HIGH SCHOOL','MAYDE CREEK JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal','2','Traditional','Barkers Ridge Sec 01 R/P','','','Water District','1990','Appraisal'); --> New record created successfully