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-18T23:04:36.937' ,`MLSNumber` = '62986359' ,`ListAgentFullName` = 'Marina Okorocha' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.905131' ,`Longitude` = '-93.904060' ,`PhotoCount` = '6' ,`PostalCode` = '77642' ,`RoomCount` = '5' ,`ListPrice` = '109000.00' ,`Status` = 'Active' ,`StreetName` = 'Procter' ,`StreetNumber` = '4037' ,`StreetSuffix` = 'Street' ,`City` = 'Port Arthur' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1734' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The LOCATION! This one is a one of a kind property; consisting of a nice-sized lot, seasoned and warm welcoming neighborhood. Perfect for an investor/ Air BNB, ready to be remodeled and made as your own. Only minutes away from Lamar State College, Pleasure Island, and many more attractions. No HOA \n12 NewsNow \'Southern Living\' has coined the beloved city, the \"Cajun capital of Texas.\"' ,`Acres` = '0.155' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 22 DELMAR UND 75% INT' ,`LotDesciption` = 'Other' ,`LotSize` = '6752' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '236 - Port Arthur' ,`SchoolElementary` = '' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PORT ARTHUR)' ,`SchoolMiddle` = 'JEFFERSON MIDDLE SCHOOL (PORT ARTHUR)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,No Photos/No Videos' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Del Mar & Del Mar Terrace' ,`TaxAmount` = '494' ,`TaxRate` = '3.267' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663712385' WHERE `Matrix_Unique_ID` = '205840958' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T23:46:12.130' ,`MLSNumber` = '41662768' ,`ListAgentFullName` = 'Myrna Lopez' ,`ListOfficeName` = 'Beyond Real Estate' ,`SellingAgentFullName` = 'Sarah Atterberry' ,`SellingOfficeName` = 'HomeTown Real Estate Group' ,`Latitude` = '30.545401' ,`Longitude` = '-96.276537' ,`PhotoCount` = '20' ,`PostalCode` = '77845' ,`RoomCount` = '3' ,`ListPrice` = '369000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Pickering' ,`StreetNumber` = '4401' ,`StreetSuffix` = 'Place' ,`City` = 'College Station' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1611' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Entertain both inside and out on this large CORNER lot! MOVE IN READY! Walk through the grand foyer into the living room with real wood floors and columned fireplace. Follow through archways into the kitchen and dining room. The spacious kitchen has a large island with electrical outlets, beautiful granite counters and a walk-in pantry. The master bathroom features double vanity sinks, jetted bathtub and oversized walk-in shower. Vaulted ceilings and crown molding throughout are a few of the many details this home has to offer. NEW ROOF installed April, HVAC and water heater replaced within last 2 years. Enjoy the warm summer nights on the extended covered patio overlooking the lush landscaped backyard. Enjoy this wonderful home in the desirable Castlegate neighborhood!' ,`Acres` = '0.176' ,`Area` = '61' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CASTLEGATE SEC 4, PH 2, BLOCK 1, LOT 41' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7667' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '153 - College Station' ,`SchoolElementary` = 'FOREST RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLLEGE STATION HIGH SCHOOL' ,`SchoolMiddle` = 'WELLBORN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Castlegate Sec 04 Ph 02' ,`TaxAmount` = '5540' ,`TaxRate` = '2.2433' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712385' WHERE `Matrix_Unique_ID` = '208383043' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T23:18:01.623' ,`MLSNumber` = '42192201' ,`ListAgentFullName` = 'Xiaoming Shao' ,`ListOfficeName` = '31 Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.676800' ,`Longitude` = '-95.711618' ,`PhotoCount` = '43' ,`PostalCode` = '77407' ,`RoomCount` = '4' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Harvest' ,`StreetNumber` = '18931' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2361' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in a great neighborhood. Great open floor plan! Granite countertops and 42” cabinetry with ample storage space! Master downstairs. 3 bedrooms and a Game room upstairs.Tile flooring throughout the living room, dining, and kitchen. Large back yard with covered patio. The garage has extra space with a window. Convenient location, easy access to highway, close to shopping and restaurants' ,`Acres` = '0.1435' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND VISTA SEC 7, BLOCK 1, LOT 36' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Vista Sec 7' ,`TaxAmount` = '6120' ,`TaxRate` = '2.4429' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712385' WHERE `Matrix_Unique_ID` = '209136074' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T23:39:51.087' ,`MLSNumber` = '13140333' ,`ListAgentFullName` = 'Deborah Trahan' ,`ListOfficeName` = 'Texas Go2, Realtors' ,`SellingAgentFullName` = 'Mohammed Al-Jammal' ,`SellingOfficeName` = 'Keller Williams Signature' ,`Latitude` = '29.985395' ,`Longitude` = '-95.676985' ,`PhotoCount` = '11' ,`PostalCode` = '77429' ,`RoomCount` = '11' ,`ListPrice` = '365000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lawton Ridge' ,`StreetNumber` = '14402' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2988' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRING ALL OFFERS, THE OWNER IS MOTIVATED TO SELL - Gorgeous 2-story Home with 4 bedroom 2.5 baths, formals, game room, primary bedroom downstairs with sitting area, roomy Bathroom with large walk-in closets. Nice open kitchen to breakfast area. and large family room with 1 of 2 fireplaces, Game room upstairs with fireplace. Spacious rooms throughout home. Nice size fenced backyard with 2 storage buildings. Private covered patio off Family room. Walk to school! Best of all it has a *GENERATOR* ! All Offers!' ,`Acres` = '0.1976' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 CYPRESS POINT SEC 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8607' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FARNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Point Sec 04' ,`TaxAmount` = '6776' ,`TaxRate` = '2.751' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712385' WHERE `Matrix_Unique_ID` = '209314870' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T23:40:17.170' ,`MLSNumber` = '80201928' ,`ListAgentFullName` = 'Deborah Trahan' ,`ListOfficeName` = 'Texas Go2, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.174743' ,`Longitude` = '-95.447439' ,`PhotoCount` = '46' ,`PostalCode` = '77515' ,`RoomCount` = '3' ,`ListPrice` = '459000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Ridge' ,`StreetNumber` = '909' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2313' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1 story with over 100 sq. ft. of lake front! 16\' x 7\' air conditioned workshop, 13\' x 5\' room for mower/garden equip. w/ rear garage access, Double carport, Porte-cochere. Flagstone patio + firepit by lake.\r\nRoof (2015), HVAC (2019), Dishwasher (2018) ,Water heater and garbage disposal (2017), Low voltage outdoor lights, 3 porches totaling 970 sq ft., Sprinkler system(front, side and front flower bed. Invisible fence for dogs with with 4 various sized collars. Southeast breeze across the lake makes it cooler in backyard and patio. Enjoy vegetable gardening with two 8\'x16\' raised bed gardens. Check out Moonlight picture and grandson\'s big catch!' ,`Acres` = '0.5569' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HERITAGE OAKS SEC 3 (A0380 & A0699) (ANGLETON) BLK 10 LOT 13' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '24259' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Heritage Oaks Sec 3 A0380 & A' ,`TaxAmount` = '8421' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712385' WHERE `Matrix_Unique_ID` = '209331118' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T22:30:47.897' ,`MLSNumber` = '84655360' ,`ListAgentFullName` = 'Rick Garcia' ,`ListOfficeName` = 'Carlos Garcia Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.741099' ,`Longitude` = '-95.333196' ,`PhotoCount` = '27' ,`PostalCode` = '77023' ,`RoomCount` = '10' ,`ListPrice` = '429900.00' ,`Status` = 'Active' ,`StreetName` = 'Mckinney' ,`StreetNumber` = '4427' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1976' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICE REDUCED! MOTIVATED SELLER! MAKE OFFER! EASTWOOD! This Lovely Well Maintained Home & recently added Apartment are located on tree-lined McKinney St- Great location, just minutes from downtown, the home features both Formals, Original Hardwoods, Nice millwork, and Historic touches with a modern twist - Modest updates to the Kitchen include tiled backsplash, countertops and flooring, a Gas Range with Microwave above, and room for a Breakfast Nook- A 7\'x14\' Mud Room adjoins the kitchen and leads to the 5\'x14\' Hallway to the Bedrooms and Bathroom - This area is spacious enough for a workstation - Both Bedrooms are good size, with big windows for lots of Natural Light - This long standing Family Home features a detached garage that was recently converted to a Beautiful Apartment with All the Modern Conveniences - High Ceilings - Open Living Area - Granite Counters - Stainless Steel Appliances - Central AC/Heat - Good size bedroom & Walk-In Closet - Come and See!' ,`Acres` = '0.1228' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 15 & 16A BLK 23 EASTWOOD' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '5350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LANTRIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Eastwood' ,`TaxAmount` = '5029' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712386' WHERE `Matrix_Unique_ID` = '209936848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T22:45:12.720' ,`MLSNumber` = '22918086' ,`ListAgentFullName` = 'Erica Wells' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Holly Bittick' ,`SellingOfficeName` = 'DSG Realty Goup' ,`Latitude` = '29.927707' ,`Longitude` = '-95.088889' ,`PhotoCount` = '25' ,`PostalCode` = '77532' ,`RoomCount` = '6' ,`ListPrice` = '295000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Casal Springs' ,`StreetNumber` = '1211' ,`StreetSuffix` = 'Court' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2183' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEARLY NEW Gehan 2-story, 3-bed, 2.5 bath, almost 2100sf, home on cul-de-sac and near the walking/jogging trail. Harwood plank flooring throughout the first story leads you from the front door through to the open-concept living area. The dining room sits off to the side, allowing this stunner of a kitchen to look out over the backyard! Kitchen features gas range, SS appliances, 42” inch cabinets and an oversize island with quartz countertops. Main floor primary suite with WIC and dual sinks. Two bedrooms, a full-size bath and loft with balcony upstairs. The front approach features a front-loading 2-car garage, on-street overflow parking and that loft balcony! Nice sized backyard is big enough for a small pool in the future. Balance of warranty transfers!!!' ,`Acres` = '0.1337' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 NEWPORT SEC 10 PAR R/P' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '5825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport' ,`TaxAmount` = '3596' ,`TaxRate` = '2.82' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663712386' WHERE `Matrix_Unique_ID` = '210302594' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T22:01:54.537' ,`MLSNumber` = '95451201' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819780' ,`Longitude` = '-94.820866' ,`PhotoCount` = '28' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '307990.00' ,`Status` = 'Active' ,`StreetName` = 'Cold Water' ,`StreetNumber` = '14807' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1409' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Baxtor Plan by D.R. Horton Homes Ready for Move In! Located in TOP #1 School District for all ages! Beautiful Stylish Timeless Chic 1 story home features Grand Entry W/High Ceilings, Gorgeous Luxury Vinyl Wood Floors throughout! Tile in all Bathrooms, Laundry Room & Plush Carpeting in Bedrooms! Amazing Open Floor Plan W/Huge Family Area that Flows into the Gourmet Kitchen W/Gorgeous Silestone Counters, Tile Back-splash, Large Eat-in Island W/Undermount Stainless Sink, Stainless Steel Appliances, Tall Upgraded Shaker Cabinets & more! Private Primary Suite has a Luxurious Bathroom featuring His & Her Undermount Deep Sink, Vanity has Cultured Marble Countertops \"Massive\" Shower with Tile Surroundings & Walk-in Closet! Enjoy the Covered Patio! Standard Energy Features: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets &\"Smart Home\" w/Amazon Echo & Dot, Skybell, Smart Lighting, Electric Deadbolt, Thermostat & Wireless Security, Control your home from anywhere! NO FLOODING' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 34 /Block: 3' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6600' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663712386' WHERE `Matrix_Unique_ID` = '210306412' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T22:11:17.100' ,`MLSNumber` = '19670180' ,`ListAgentFullName` = 'Donald Tomek' ,`ListOfficeName` = 'Donald Charles Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.845302' ,`Longitude` = '-95.483262' ,`PhotoCount` = '47' ,`PostalCode` = '77092' ,`RoomCount` = '9' ,`ListPrice` = '314900.00' ,`Status` = 'Active' ,`StreetName` = 'Birchmont Ct' ,`StreetNumber` = '6211' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2073' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT PROPERTY IN DESIRABLE FOREST WEST SUBDIVISION- This 4-bedroom 2-bath home with three matured trees is located on one of only two Cul-De-Sac streets in the neighborhood. A formal entry opens into the living/dining areas with lots of natural light. The kitchen w/bar seating opens to a breakfast room flanked with bay windows looking out to back yard. The family room located off the kitchen/breakfast area features vaulted beamed ceilings and brick wood burning fireplace. This space is very open and encourages entertainment to the back yard. The primary suite offers an ensuite bath/vanity area with large a walk-in closet. Three additional secondary bedrooms are generous size and share a hall bath.' ,`Acres` = '0.1757' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 443 BLK 12 FOREST WEST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7654' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '197' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest West Sec 02' ,`TaxAmount` = '5776' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712386' WHERE `Matrix_Unique_ID` = '210466788' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T22:52:45.083' ,`MLSNumber` = '85112006' ,`ListAgentFullName` = 'Danielle Navas' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.875351' ,`Longitude` = '-95.289519' ,`PhotoCount` = '22' ,`PostalCode` = '77016' ,`RoomCount` = '5' ,`ListPrice` = '199999.00' ,`Status` = 'Active' ,`StreetName` = 'Leedale' ,`StreetNumber` = '6710' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1384' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this absolutely lovely home! Fully renovated! New interior and exterior paint. New HVAC. New cabinets. New quartz counter tops. New backsplash. New tankless water heater, you\'ll never run out of hot water. Updated restrooms. Crown molding. Lots of LED lighting. Tile floor all throughout, no carpet. Spacious and open floor plan. Huge backyard perfect for entertaining and parties. Appliances included! This is a beautiful house, schedule your tour today!' ,`Acres` = '0.1325' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 60 NORTHWOOD MANOR SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5772' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Northwood Manor Sec 06' ,`TaxAmount` = '3578' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712386' WHERE `Matrix_Unique_ID` = '210614304' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T22:02:38.577' ,`MLSNumber` = '56444174' ,`ListAgentFullName` = 'Sardar Anamul' ,`ListOfficeName` = 'Prompt Realty & Mortgage, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.604432' ,`Longitude` = '-95.509725' ,`PhotoCount` = '32' ,`PostalCode` = '77489' ,`RoomCount` = '8' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Millbury' ,`StreetNumber` = '1727' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1661' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one-story home fully remodel. It\'s a 3 bedroom, 2 full bathrooms providing a nice open space area along with plenty of natural light. Granite countertops , Floor Tile and Water Heater are new. A/C units and Roof have been installed about Three years, freshly painted with popular colors and new flooring installed. The property has not been affected by any of the heavy rain or flooding.' ,`Acres` = '0.1708' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HUNTERS GLEN SEC 2, BLOCK 3, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7441' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '108' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HUNTERS GLEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Glen Sec 2' ,`TaxAmount` = '4350' ,`TaxRate` = '2.693' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712386' WHERE `Matrix_Unique_ID` = '210862144' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T23:21:49.880' ,`MLSNumber` = '50840623' ,`ListAgentFullName` = 'Brian Hargrove' ,`ListOfficeName` = 'Country Pride Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.536671' ,`Longitude` = '-95.727247' ,`PhotoCount` = '35' ,`PostalCode` = '77469' ,`RoomCount` = '9' ,`ListPrice` = '384999.00' ,`Status` = 'Active' ,`StreetName` = 'Verde Lake' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Way' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2272' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This impressive 1 story home has 2,268 square feet of luxury and a very open floor plan, including 3 spacious bedrooms with walk in closets, 2.5 bathrooms, an in home office, a covered patio and a 2 car attached garage. This kitchen is absolutely gorgeous, 42\" cabinets w/ crown molding and extra wide covers for bar seating and an island for extra work space. A huge master with vanity area and a beautiful walk in shower. Located in a Cul-de-sac near the edge of the neighborhood. This home is move in ready and can come fully furnished with the right offer. Owners are willing to leave all appliances and furniture and most decor. Come see it today and make this house your home!' ,`Acres` = '0.2949' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUMMER LAKES SEC 10, BLOCK 2, LOT 17' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '12846' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'WILLIAMS ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Summer Lakes' ,`TaxAmount` = '7440' ,`TaxRate` = '2.8448' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712386' WHERE `Matrix_Unique_ID` = '211133769' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T22:07:29.060' ,`MLSNumber` = '19086684' ,`ListAgentFullName` = 'Purva Shah' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.944455' ,`Longitude` = '-95.253672' ,`PhotoCount` = '30' ,`PostalCode` = '77396' ,`RoomCount` = '9' ,`ListPrice` = '349990.00' ,`Status` = 'Active' ,`StreetName` = 'Palestine Cove' ,`StreetNumber` = '4418' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3010' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This wonderful 2 storey floor plan has four bedrooms and two and a half bathrooms with two car garage. Flooring installed a year ago and fresh interior paint. This house features a downstairs master suite, open concept living room and open flex area which can be used for any purpose including office/formal dining. Upstairs, you will find a game room & a good sized Media room, three secondary bedrooms, and another full bathroom. Nice cozy backyard. Recently installed AC condenser unit. The desirable community is minutes from shopping and dining in Generation Park and near to airport! YOU WOULD NOT WANT TO MISS MOVING INTO THIS HOUSE!' ,`Acres` = '0.1523' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 3 CANYON VILLAGE AT PARK LAKES SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6634' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PARK LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Canyon Vlg/Pk Lakes' ,`TaxAmount` = '7591' ,`TaxRate` = '2.9873' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712387' WHERE `Matrix_Unique_ID` = '211338438' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T22:17:19.733' ,`MLSNumber` = '58349297' ,`ListAgentFullName` = 'Richard Fenyes' ,`ListOfficeName` = 'Rocket, Realtors' ,`SellingAgentFullName` = 'Shana Pratt' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.084967' ,`Longitude` = '-95.234763' ,`PhotoCount` = '25' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '320000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cascade Mountain' ,`StreetNumber` = '22008' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2690' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Super clean & spacious 4-BEDROOM (largest floor-plan) newer home with many fabulous upgrades, including many features, located in a great location, close to 99 Grand Parkway, 59/69, close to restaurants, a new shopping center (new grocery store) and so much more.The family functional floorplan is open and inviting including upgraded elevated ceilings w/recessed lighting,ceiling fans w/lighting,an expansive(great for entertaining)all-granite island kitchen including ample aesthetically pleasing wrap-around counter space,also providing a barstool seating area;extremely nice,the kitchen also opens to dining & family room areas all harmoniously working together for optimum living.Home includes a guest powder-bath and the large Primary Bedroom is down with wonderful closet space;Primary bath includes separate garden tub & shower w/dual vanities.The upstairs game-FLEX room is it\'s own separate oasis that can provide space for more!Large in-home utility and beautiful backyard w/covered patio.' ,`Acres` = '0.1008' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S269800 - BROOKLYN TRAILS 01, BLOCK 1, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4393' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'PORTER ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brooklyn Trails 01' ,`TaxAmount` = '2863' ,`TaxRate` = '3.6031' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663712387' WHERE `Matrix_Unique_ID` = '211594477' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T22:06:15.570' ,`MLSNumber` = '20665840' ,`ListAgentFullName` = 'Elizabeth Matthews' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = 'Eric Gage' ,`SellingOfficeName` = 'Douglas Elliman Real Estate' ,`Latitude` = '29.514265' ,`Longitude` = '-95.058075' ,`PhotoCount` = '21' ,`PostalCode` = '77573' ,`RoomCount` = '8' ,`ListPrice` = '359999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Aurelia' ,`StreetNumber` = '2874' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2209' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3-4 bedroom/ 2 bath home in the highly sought after community of Tuscan Lakes! This adorable D.R. Horton home welcomes you in with high ceilings, beautiful hand-scraped Bamboo floors, and an open concept floor plan which is great for entertaining. The kitchen has granite countertops, a breakfast bar, gas range, and canned lighting throughout. The primary bedroom has an en-suite bathroom with double sinks, garden tub, walk in closet and separate shower! There are 2 additional bedrooms, a second full bathroom and an office/4th bedroom off the entry way. Recent upgrades include new AC, furnace, ductwork, dishwasher, garbage disposal, carpet and water heater. The backyard includes a covered patio and is fully fenced, which is great for outdoor dining. The highly desired community of boasts an array of amenities and an active calendar of events, pool, splash pad, multiple parks, and miles of walking trails! Home is zoned to high accredited CCISD! Schedule your appointment today!' ,`Acres` = '0.1515' ,`Area` = '33' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TUSCAN LAKES SEC SF 55-3 (2008) ABST 18, BLOCK 1, LOT 8, ACR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GOFORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'LEAGUECITY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tuscan Lakes Sec Sf 55-3' ,`TaxAmount` = '7636' ,`TaxRate` = '2.6697' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712387' WHERE `Matrix_Unique_ID` = '211595177' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T22:22:07.190' ,`MLSNumber` = '62398828' ,`ListAgentFullName` = 'Mia Li' ,`ListOfficeName` = 'KingFay Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.042571' ,`Longitude` = '-95.444232' ,`PhotoCount` = '26' ,`PostalCode` = '77388' ,`RoomCount` = '4' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Enchanted Trail' ,`StreetNumber` = '719' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2945' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exceptionally Unique Castle-Inspired Home with Two Primary Suites! Conveniently located in a highly sought-after neighborhood only steps from parks and trails, this 4BR/3.5BA enchants the senses with a gorgeous exterior brick façade. Exuding old-world European charm, the interior dazzles with an impressive foyer with a curving wrought-iron staircase, an entertainment-ready floorplan, beautiful wood flooring, tons of shimmering natural light, and a spacious living room with soaring ceilings & wood ceiling beams. Open concept gourmet kitchen featuring SS appliances, granite countertops, richly toned wood cabinetry, a center island, built-in wine storage, a rustic backsplash and an adjoining formal dining room. Restful relaxation is found in the oversized main-level primary bedroom with dual closets and an attached en suite with two vanities and a deep soaking tub. One of the guest bedrooms boasts an attached en suite(New Carpet). A cozy reading nook with a whimsical cloud pattern.' ,`Acres` = '' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 17 ENCHANTED OAKS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'LEMM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Enchanted Oaks' ,`TaxAmount` = '5233' ,`TaxRate` = '2.484' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712387' WHERE `Matrix_Unique_ID` = '211655661' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-18T22:39:23.567' ,`MLSNumber` = '70897881' ,`ListAgentFullName` = 'Renee Lopez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = 'Anya Hernandez' ,`SellingOfficeName` = 'Synmark Realty' ,`Latitude` = '29.713408' ,`Longitude` = '-95.362820' ,`PhotoCount` = '44' ,`PostalCode` = '77004' ,`RoomCount` = '14' ,`ListPrice` = '597000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Oakdale St' ,`StreetNumber` = '3418' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2678' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this 1930\'s 4/4.5 recently renovated home w/ so many modern touches! Situated in the Southwood sub., & min. from the Medical Center & Downtown Houston this home has so much Warmth & Class! Features include an open concept w/ Living, Dining and Kitchen. New 4\" White Oak Fl down & original White Oak fl upstairs! White Quartz Countertops in kitchen & bathrooms w/ White Oak Butcher blocks countertops in the living room. Primary Bed & Bath 1st floor overlooking the backyard & a new addition to this home. Each bedroom upstairs has its own bathroom w/ 2 bedrooms being en-suit & lots of natural light. Enjoy outdoor living w/ 2 covered balconies one facing the front & the ex-large backyard patio balcony right outside a jazzy loft area with white Oak Butcher blocks countertops on the 2nd floor loft looking out to the balcony. Too many upgrades to list. Schedule your private showing today! And have your Realtor go over the many new features of this home with you!' ,`Acres` = '0.1561' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Riverside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 11 SOUTHWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Southwood' ,`TaxAmount` = '7875' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1935' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663712387' WHERE `Matrix_Unique_ID` = '211676590' --> 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','211707042','1663712387','211707042','2022-09-18T22:32:04.057','23411447','Chelsea Woodard','Texas Diamond Realty',' Non-MLS Agent','Non-MLS ','30.085836','-95.131572','48','77336','8','995000.00','Option Pending','Vista Del Lago','419','Drive','Huffman','4','1','5','4315','Single-Family','This unique property, filled with mature oak trees is located in the highly sought-after Huffman School District. From the red iron and steel framing to the wide-open concept and property layout, this property is truly one of a kind! Starting from the oversized circle driveway, make your way through a home built for entertaining to the back porch that spans the length of the house. This home is filled with walk-in closets, built-in shelving, custom cabinets and lighting features. From there take a dip in the pool on your way to the natural, & fully stocked pond. Cross fenced with a barn and an oversized garage/workshop. The garage adds an additional full bathroom and kitchenette area, along with office space. Above the garage the plumbing is ran for a loft apartment but not finished. The main yard is equipped with a drainage system consisting of French drains and catch basins.Come view this property before someone else makes it their home!','4.5914','32','','','Electric Dryer Connections','','Sellers Disclosure','1','','2','Huffman Area','Central Electric','1','LT 7 BLK 2 COMMONS OF LAKE HOUSTON SEC 4 2ND AMEND','Cleared,Wooded','200000','Appraisal District','','1000','0','','2','Double Oven','1','In Ground','','Electric Cooktop','','Aluminum','28 - Huffman','FALCON RIDGE ELEMENTARY SCHOOL','HARGRAVE HIGH SCHOOL','HUFFMAN MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card','Seller','1','Ranch,Traditional','Commons Lake Houston Sec 04','10598','2.0083','Aerobic,Septic Tank','2001','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','211936082','1663712387','211936082','2022-09-18T23:03:07.080','61846181','Ivan Williams','Walzel Properties','','','30.013351','-95.743561','43','77433','6','320000.00','Active','Blue Hyacinth','20502','Drive','Cypress','2','0','3','1600','Single-Family','Fabulous Master Plan Fairfield Gem – Cul-de-Sac Lot with covered patio, Gourmet Kitchen with Stainless Steel appliances and Granite counters with Tile back splash and spacious Breakfast Nook, 42\'\' cabinets and under cabinet lighting. Kitchen peninsula with breakfast bar seating is great for entertaining with surround sound wiring. Primary Bedroom with room for seating area and large windows open to backyard, Primary bath has dual sink vanity, large soaker tub and large glass shower and walk-in closet. Secondary Bedrooms all have walk-in closets for plenty of storage through-out. Ceiling fans, 2-inch Window blinds, 2 car garage with room for storage and garage door opener, full sprinkler system, and covered patio with natural gas outlet for entertaining/relaxing area with Fan and Light leading to the backyard with minimal back neighbors, large side yard in this Cul-de-Sac home. Easy access to Grand Parkway, Tomball, Katy and Houston Premium Outlets. Top-rated schools in Cy-Fair ISD.','0.1455','35','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Cypress North','Central Gas','1','LT 34 BLK 1 FAIRFIELD VILLAGE NORTH SEC 10','Cul-De-Sac,Greenbelt,Subdivision Lot','6336','Appraisal District','','1011','0','','2','Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','13 - Cypress-Fairbanks','SWENKE ELEMENTARY SCHOOL','BRIDGELAND HIGH SCHOOL','SALYARDS MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox','Appraisal District','1','Ranch','Fairfield Village North Sec 10','6101','2.611','Water District','2013','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','211960408','1663712387','211960408','2022-09-18T23:26:30.550','20662194','Joel Johnson','Real Broker, LLC','','','30.186594','-95.801952','23','77355','9','380000.00','Active','Allan Poe','26043','Drive','Magnolia','2','1','5','2576','Single-Family','Find your new home here nestled in the heart of the quiet Williams Trace community! Located just on the edge of old magnolia your new home is waiting for you. This home has been upgraded where it counts, air conditioning ducts, security systems, and large array of solar panels. This two story home has been well cared for has a large back yard with a well established lawn and is waiting ir you to come make it your own! Schedule your tour today!','0.1094','15','','','','','No Disclosures','1','','','Magnolia/1488 West','Central Electric','1','S955200 - WILLIAMS TRACE 01, BLOCK 1, LOT 4','Subdivision Lot','4764','Appraisal District','','350','0','','2','','0','','','','','Composition','36 - Magnolia','WILLIE E. WILLIAMS ELEMENTARY SCHOOL','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Williams Trace 01','4650','1.8587','Public Sewer,Public Water','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','212219732','1663712387','212219732','2022-09-18T22:52:32.107','56301498','Shubin Liu','Realty Alliance','','','29.750728','-95.741175','40','77450','10','353000.00','Active','Park Maple','2139','','Katy','2','0','3','2077','Single-Family','You will love this unique home! This home has a great floor-plan with the newer(4 year old) roof and AC system.The whole house has just been repainted. Entire stained fences was just installed. The home features..Tons of recent upgrades..Granite countertop with a curve style cabinets in Kitchen, Formal dining room, Formal study, Formal breakfast, Spacious kitchen, Breakfast bar, Living area with high ceilings, Large utility room; Interior features multiple beautiful arches, unique windows and door frames, decorated with crown moldings, beautiful light fixtures and chandeliers; Home is located on large cul-de-sac with an unique shape of the front yard and a big back yard, No neighbor in the back. The home is close to a walking trail. There is a doorway in the backyard that opens to a walkable natural area with creeks and a pedestrian bridge. Exterior features bricks in three sides with a gorgeous multi-layered styling design that catches the eye. A must see!','','36','','','','','Mud','1','Gaslog Fireplace','1','Katy - Southeast','Central Gas','1','Lt 19, Blk 1','Corner,Cul-De-Sac','14587','Appraisal District','','525','0','','2','Gas Oven','0','','','Gas Range','','Composition','30 - Katy','HAYES ELEMENTARY SCHOOL','TAYLOR HIGH SCHOOL (KATY)','MCMEANS JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal','1','Contemporary/Modern','Oak Park Trails','5539','2.4133','Public Sewer,Public Water','2000','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','212230872','1663712388','212230872','2022-09-18T23:56:33.843','19358885','Alexander DiSaggio','City Group','','','30.089603','-94.114327','12','77701','8','135000.00','Active','Harrison','1897','Street','Beaumont','2','0','4','1822','Single-Family','Huge professional add-on in back can be used as a 4th bedroom. Great home for a great price! Home is leased out until August 2023 at 1,325 a month. This home is for INVESTORS ONLY. If you are a landlord looking for a turn key property, this is it!','0.1722','51','','','Electric Dryer Connections','','Other Disclosures,Sellers Disclosure','','Wood Burning Fireplace','1','','Central Gas','0','MC FADDIN 2 L10 B31 & ADJ 1/2 ALLEY','Subdivision Lot','7500','Appraisal District','','','0','','0','Gas Oven','0','','','','','Composition','143 - Beaumont','CALDWOOD ELEMENTARY SCHOOL','BEAUMONT UNITED HIGH SCHOOL','ODOM MIDDLE SCHOOL','Appointment Required,Temporarily No Showings','Appraisal','1','Traditional','Mcfaddin Add','1780','2.645','Public Sewer','1962','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','212283189','1663712388','212283189','2022-09-18T23:57:33.577','19532184','Alexander DiSaggio','City Group','','','29.533586','-95.263725','32','77581','8','425000.00','Active','Travis Lake','3914','Court','Pearland','3','1','4','3309','Single-Family','Welcome Home to the gated community of Towne Lake Estates! This home is on a cul de sac and boasts a large living area with an open floor plan. The kitchen is open to the living room perfect for entertaining and includes a gas range and large island. The formal dining room is ready for your large dining table and guests. The primary bedroom is large and has a huge walk in closet and en suite bathroom with separate shower and tub plus dual vanities. The game room is big enough for your full size pool table and lots of seating, or turn it in to your theater room. The secondary bedrooms are all large, one of them is almost as big as the primary, perfect for guests or mother in law suite. Come tour today!','0.184','5','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','','Gaslog Fireplace','1','Pearland','Central Gas','1','TOWNE LAKE ESTATES SEC 2 (A0507 ACH&B) (PEARLAND) BLK 1 LOT','Cul-De-Sac','8015','Appraisal District','','982','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','42 - Pearland','SHADYCREST ELEMENTARY SCHOOL','PEARLAND HIGH SCHOOL','PEARLAND JUNIOR HIGH EAST','Appointment Required','Appraisal District','2','Traditional','Towne Lake Estates Sec 2','8727','2.8052','Water District','2004','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','212447274','1663712388','212447274','2022-09-18T22:43:01.230','24534658','Pamela Hall','ERA Legacy Living','','','29.582882','-95.218849','16','77089','7','345000.00','Active','Sagewillow','11626','Lane','Houston','3','1','5','3040','Single-Family','','0.1806','3','Perry Homes','','Electric Dryer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Southbelt/Ellington','Central Electric','1','LT 24 BLK 9 SAGEGLEN SEC 1','Other','7866','Appraisal District','','300','0','','1','Electric Oven','0','','','Electric Cooktop','','Composition','9 - Clear Creek','WEBER ELEMENTARY','CLEAR BROOK HIGH SCHOOL','WESTBROOK INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Other Style','Sageglen Sec 01','5282','2.356','Public Sewer,Public Water','1977','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212572296','1663712388','212572296','2022-09-18T23:24:19.497','59922146','Rhonda Flanagan','Connect Realty','','','30.051354','-94.089132','26','77705','3','79999.00','Active','Kenneth','3605','Avenue','Beaumont','1','0','2','1617','Single-Family','Great investment property located in the South End of Beaumont Texas. This 2 bedroom, 1 bath, 1 car garage home appears to have a solid structure and foundation. Has been well maintained. The home has two living areas, the walk-in attic could be converted into additional living space. The rear section of the garage could be converted into a workshop. Schedule a showing today!','0.1148','51','','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure,Special Addendum','0','','0','','Central Electric','0','N1/3 LTS 1 & 2 B16 JEF CHAISON','Other','5000','Appraisal District','','','0','','1','Electric Oven','0','','','Electric Range','','Composition','143 - Beaumont','PIETZSCH-MACARTHUR ELEMENTARY SCHOOL','BEAUMONT UNITED HIGH SCHOOL','KING MIDDLE SCHOOL (BEAUMONT)','Appointment Required','Appraisal District','1','Other Style','Jef Chaison Add','1190','2.645','Public Sewer,Public Water','1962','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','212662216','1663712388','212662216','2022-09-18T22:19:15.157','57494142','Sachin Jain','Sachin Jain','','','29.660114','-95.460904','2','77035','3','199900.00','Active','Kinglet','4813','Street','Houston','2','0','3','1422','Single-Family','Fire-burnt home close to Meyerland. Biking distance from Kroger, Walmart, Meyerland Plaza and major shopping. 60-70% of the framing in the house is not salvageable. An investor can choose to either tear down the remaining home or build almost from the slab up converting this one story home into 1.5 or 2 story and realizing a heated footage of 2600-3200 sq ft depending on exit strategy. One Such example of a slab up rehab is 10826 Moonlight St that sold for 780k. 2018 built 3512 sq ft home (4725 Redstart) sold for 860k on the next street. Selling below Lot Value. No low balls offers please.','0.1998','20','','','','','Sellers Disclosure','','','','Willow Meadows Area','No Heating','0','LT 10 BLK 3 WILLOWBROOK','Cleared','8705','Appraisal District','','','0','','','','0','','','','','Composition','27 - Houston','RED ELEMENTARY SCHOOL','WESTBURY HIGH SCHOOL','MEYERLAND MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Ranch','Willowbrook','5433','2.3307','Public Water','1955','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','212666979','1663712388','212666979','2022-09-18T22:01:04.260','68095271','Tatyana Ricci','Trinity Realty TX','','','30.324039','-95.424138','34','77301','3','224995.00','Active','Shady Birch','2213','Drive','Conroe','2','0','3','1198','Single-Family','Cozy, well maintained 3BDR/2BTH home in Shady Woods. Built in 2009, remodeled in 2015. Laminate flooring in living/dining area and ceramic tile in all wet areas. Granite countertops in the kitchen and bathrooms. Carpet in bedrooms is one year old. New garage door opener. Fridge is included. Ceiling fans in all rooms. 2\'\' blinds throughout the house. Spacious backyard with mature trees. Low property tax and No HOA. Great starter home or investment property.','0.1349','19','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','','0','Conroe Northeast','Central Electric','0','SHADY WOODS 01 REPLAT, BLOCK 1, LOT 69','Subdivision Lot','5875','Appraisal District','','','0','','1','Electric Oven','0','','','Electric Range','','Composition','11 - Conroe','PATTERSON ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','STOCKTON JUNIOR HIGH SCHOOL','Appointment Required,Controlled Access,Leave Business Card,Vacant/Unoccupied','Appraisal District','1','Traditional','Shady Woods 01 Rep','2600','2.1863','Public Sewer,Public Water','2009','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','212667543','1663712388','212667543','2022-09-18T22:51:30.987','96207710','Nasir Malik','Sunrise, Realtors','','','30.229425','-95.644649','0','77354','10','899900.00','Active','Garland','0','Road','Magnolia','4','2','4','4000','Single-Family','Gorgeous, Build-to-Suite Custom Home by Sunrise Global Builders, Four or Five Bedrooms, Four Full and two half baths, Formal Living, Family room, and Media room. Gourmet Kitchen opens to the family room, Texas size Game room, and garage to park your Texas size trucks and SUV. Minimum 4000 sqft with no maximum, use our floor plan or bring yours or we can custom design a floor plan for your family. This is rare to find lot one Acer plus lot close to New HEB, Toll rd, FM 1488, Hwy 149, mins from the Shopping mall, Groceries stores, Hospitals, and Schools. Please call us for more details.','1.47','15','Sunrise Global Build','','Electric Dryer Connections','','No Disclosures','1','','1','Magnolia/1488 East','Central Electric','1','Country Forest West 01 , Lot 61 Acres 1.470','Other,Wooded','64033','Appraisal District','','','1','To Be Built/Under Construction','','Freestanding Oven','0','','','Freestanding Range','','Composition,Other','36 - Magnolia','MAGNOLIA PARKWAY ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox','Builder','2','Other Style','Country Forest West 01','','','Septic Tank,Well','2022','Builder'); --> New record created successfully