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-10T09:30:27.330' ,`MLSNumber` = '49775829' ,`ListAgentFullName` = 'Shelly Faust' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.362634' ,`Longitude` = '-95.094066' ,`PhotoCount` = '49' ,`PostalCode` = '77328' ,`RoomCount` = '6' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 2025' ,`StreetNumber` = '677' ,`StreetSuffix` = 'Road' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1148' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property is set up for great commercial opportunity. It has road frontage on FM 2025 just down from where two new CISD campuses are being built. It is hemmed in on both sides by businesses. High traffic count. It is unrestricted and can also be used as residential. There are two buildings. The main house has two bedrooms and one full bath, large utility room with tons of cabinets and a sink, front porch, screened in back porch/sunroom, plus a carport. The guest house/apartment has one bedroom and one full bath, living room, kitchen, plus a one car garage (or workshop) with a roll up door on front and back. The property is situated on one acre and has a private water well and well house with extra storage space. Low tax rate!' ,`Acres` = '1' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '000201 F GIBENRATH, TRACT 43, ACRES 1.0' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'F Gibenrath' ,`TaxAmount` = '3100' ,`TaxRate` = '1.8013' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708916' WHERE `Matrix_Unique_ID` = '206544800' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T09:31:50.367' ,`MLSNumber` = '60395256' ,`ListAgentFullName` = 'Toni Knis' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = 'Christina Brewster' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.568014' ,`Longitude` = '-95.042735' ,`PhotoCount` = '26' ,`PostalCode` = '77586' ,`RoomCount` = '9' ,`ListPrice` = '310000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bayou View' ,`StreetNumber` = '434' ,`StreetSuffix` = 'Drive' ,`City` = 'El Lago' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2644' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED PER SELLER. THIS TRADITIONAL HOME SITS ON A HUGE CORNER LOT IN THE HIGHLY DESIRABLE NEIGHBORHOOD OF EL LAGO, WHICH HAS PARKS, PLAYGROUNDS, TENNIS COURTS AND EASY ACCESS TO THE LAKE. ZONED TO THE PRESTIGIOUS ED WHITE E-STEM ELEMENTARY SCHOOL IN AWARD WINNING CCISD. FEATURING A SPARKLING POOL, 4 BEDROOMS, 2 1/2 BATHS, GAME ROOM WITH BAR AND FAMILY ROOM WITH GAS LOG FIREPLACE. THE KITCHEN IS OPEN TO THE BREAKFAST ROOM WITH A BUILT IN BUFFET THAT WOULD MAKE THE PERFECT COFFEE BAR. HUGE MASTER SUITE UPSTAIRS WITH 2 CLOSETS AND SEPARATE VANITY. 3 ADDITIONAL BEDROOMS AND FULL BATH UPSTAIRS AS WELL. THERE IS NO SHORTAGE OF CLOSET/STORAGE SPACE EITHER. MANY RECENT IMPROVEMENTS INCLUDE: ROOF 2019, HVAC REPLACEMENT 2020, DUCTWORK 2021, POOL PLUMBING AND REFURBISHED EQUIPMENT 2021, UNDERGROUND PLUMBING TO LAUNDRY AND HALF BATH 2021. PER SELLER TRANSFERABLE FOUNDATION WARRANTY THROUGH DU-WEST. MAKE THIS HOUSE A HOME WITH YOUR PERSONAL TOUCHES AND IDEAS!' ,`Acres` = '0.261' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 4 EL LAGO SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '11370' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '65' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ED H WHITE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'El Lago Sec 03' ,`TaxAmount` = '6672' ,`TaxRate` = '2.6666' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708916' WHERE `Matrix_Unique_ID` = '209594926' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T08:40:52.753' ,`MLSNumber` = '21145040' ,`ListAgentFullName` = 'Ken Lewis' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.888812' ,`Longitude` = '-95.695496' ,`PhotoCount` = '22' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Connemara' ,`StreetNumber` = '7674' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2728' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHECK OUT THIS 5 BEDROOM IN WESTGATE COMMUNITY READY FOR MOVE IN. HUGE CUSTOM BUILT COVERED PATIO. LARGE LIVING ROOM FLOWS INTO KITHCEN AREA. MASTER DOWN, 4 BEDROOMS AND GAMEROOM UP.' ,`Acres` = '0.1472' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 WESTGATE SEC 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6414' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westgate Sec 19' ,`TaxAmount` = '6584' ,`TaxRate` = '2.671' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708916' WHERE `Matrix_Unique_ID` = '209807871' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T08:06:56.630' ,`MLSNumber` = '71055369' ,`ListAgentFullName` = 'Gary Holub' ,`ListOfficeName` = 'Holub Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.439061' ,`Longitude` = '-96.943237' ,`PhotoCount` = '26' ,`PostalCode` = '77964' ,`RoomCount` = '3' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'River' ,`StreetNumber` = '201' ,`StreetSuffix` = 'Street' ,`City` = 'Hallettsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1587' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Price Improvement! This affordable 1,587 SF three bedroom, two bath home is nestled on a extra large corner lot with a fenced in back yard. The home has been recently updated with new ceiling fans & fresh paint. This floorplan features a spacious open dining and living area that is 13\'9\" x 26\" A kitchen with plenty cabinets & a large pantry will make the cook happy. The back yard already has an area that has been designated for a garden. Beautifully landscaped, sidewalks, mature pecan, oak & ash trees provide plenty shade.' ,`Acres` = '0.397' ,`Area` = '68' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'C A KESSLER ADDN, BLK 4-FR, ACRES 0.3970' ,`LotDesciption` = 'Corner' ,`LotSize` = '17293' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '179 - Hallettsville' ,`SchoolElementary` = 'HALLETTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HALLETTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'HALLETTSVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'C A Kessler Add' ,`TaxAmount` = '2506' ,`TaxRate` = '2.095' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708917' WHERE `Matrix_Unique_ID` = '209947453' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T08:06:48.240' ,`MLSNumber` = '28407781' ,`ListAgentFullName` = 'Jo Anne Johnson' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.151410' ,`Longitude` = '-95.464427' ,`PhotoCount` = '35' ,`PostalCode` = '77380' ,`RoomCount` = '9' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Maystar' ,`StreetNumber` = '9' ,`StreetSuffix` = 'Court' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1856' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RARE OPPORTUNITY to find a 1-story mid-century/modern custom awaiting your personal touches - nestled in a premium golf course neighborhood with easy on/off access to the Tournament Player Course, and seated amidst homes valued well over $1M! Walk/ride to Waterway, Town Center dining & shops, golf club, convenient access to I-45, medical district, more! Situated on a corner, cul-de-sac lot with classic brick & wood exterior, floor plan boats large great room w/vaulted ceiling, formal dining/optional study, combo kitchen/breakfast room, spacious primary retreat with en-suite bath, his/hers closets, two secondary BRs w/hall bath. Special features: dbl pane wdws, wood laminate flooring throughout, tile in all wet areas, extended pavestone patio, plus ample yard for kids, pets with room for a pool, and detached garage with breezeway. Zoned to top-ranked schools and surrounded by walking trails! High & dry & low tax rate! Prime-time real estate in The Wdlds! Priced for quick sale - \'as is.\'' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL GROGANS ML 17, BLOCK 1, LOT 41' ,`LotDesciption` = 'Corner,Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '8979' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'LAMAR ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'The Woodlands Grogans Mill' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708917' WHERE `Matrix_Unique_ID` = '210188842' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T09:53:07.617' ,`MLSNumber` = '75549188' ,`ListAgentFullName` = 'Melissa Rod' ,`ListOfficeName` = 'The Real Estate Service' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.214775' ,`Longitude` = '-96.275370' ,`PhotoCount` = '50' ,`PostalCode` = '77437' ,`RoomCount` = '12' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Doris' ,`StreetNumber` = '607' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2664' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This wonderful 2 story, 4 bedrooms, 2 bath home sits on 1.25 +/- acres inside the city limits. The beautiful tree lined driveway with fully fenced yard and entry gate leads to this completely updated \"Farm House\" themed home with original wood floors, ship lap walls & ceilings, bead board and built-ins that you will just fall in love with. With 2600 +/- square feet of living area there is plenty of room to entertain. There is also a 40x80 barn on cement slab with 3 overhead doors, 2 walk through doors, 1/2 bath & electricity. In 2018 a New Hot Water Heater was installed, the home was leveled and a new Central Air & Heat Unit was installed. 2020 the kitchen was completely remodeled and in 2022 the new roof was put on and second bath completely remodeled. There is also a sprinkler system and separate fenced in area behind the barn that can be used for a garden or dog kennel if needed.' ,`Acres` = '1.25' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LEVI PAUL BLOCK 22 LOT 22C-1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '54450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Levi Paul' ,`TaxAmount` = '4531' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1900' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663708917' WHERE `Matrix_Unique_ID` = '210205715' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T08:45:49.180' ,`MLSNumber` = '48348524' ,`ListAgentFullName` = 'Wanda Taylor' ,`ListOfficeName` = 'Taylor Real Estate Group, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.787981' ,`Longitude` = '-95.509199' ,`PhotoCount` = '8' ,`PostalCode` = '77055' ,`RoomCount` = '5' ,`ListPrice` = '739000.00' ,`Status` = 'Active' ,`StreetName` = 'Bace' ,`StreetNumber` = '8913' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring Valley Village' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Selling as is, great opportunity to renovate, add on, or tear down and build new! Zoned to Valley Oaks Elementary, Spring Branch Middle, and Memorial High. Spring Valley Village is an amazing place to live, has it\'s own City Park, City Hall, and Police department.' ,`Acres` = '0.1882' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK B BONNIE OAKS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'VALLEY OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Spring Valley Village' ,`TaxAmount` = '12096' ,`TaxRate` = '2.3056' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663708917' WHERE `Matrix_Unique_ID` = '210281433' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T09:06:16.030' ,`MLSNumber` = '82451067' ,`ListAgentFullName` = 'Hoang Nguyen' ,`ListOfficeName` = 'Alex Mark Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.935096' ,`Longitude` = '-95.669158' ,`PhotoCount` = '40' ,`PostalCode` = '77095' ,`RoomCount` = '10' ,`ListPrice` = '589000.00' ,`Status` = 'Active' ,`StreetName` = 'Rosillion' ,`StreetNumber` = '16615' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4025' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Complete Remodel Extra long driveway Parking Space #. 3 Cars Garage has a unique floor plan. RARE and Awesome Golf course View Home. Ready to move in with a Private Swimming pool prepared for Summer.' ,`Acres` = '0.2888' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 4 STONE GATE SEC 3' ,`LotDesciption` = 'In Golf Course Community,On Golf Course' ,`LotSize` = '12578' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LAMKIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Seller' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Gate Sec 03' ,`TaxAmount` = '9221' ,`TaxRate` = '2.561' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708917' WHERE `Matrix_Unique_ID` = '210313493' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T09:58:29.100' ,`MLSNumber` = '24018572' ,`ListAgentFullName` = 'Delia Barajas' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.338996' ,`Longitude` = '-95.488068' ,`PhotoCount` = '32' ,`PostalCode` = '77304' ,`RoomCount` = '8' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Hill Manor' ,`StreetNumber` = '1913' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2609' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Graystone Hills a Master-Planned Community ! This is your chance to live at Graystone Hills, THIS HOME DID NOT FLOOD DURING HURRICANE HARVEY. It\'e in Excellent Condition! What a Spacious Home with 5 Bedrooms 3.5 Baths, Master Down. No Carpet, Wood Laminated Floors All Throughout. There\'e Tile in all Wet Areas, Granite Counter Tops in Kitchen, Ceramic Log Fireplace, Formal Dining Room is Big and great for entertaining or it can be used as a Study. The Breakfast Nook, Family, two bedrooms upstairs, and Master Bedroom have a view of the backyard. Extended Garage is Great for Bikes and Work Bench. Huge Cover Patio! No Survey. Graystone Hills also offers scenic surrounds and amenities: Minutes from Lake Conroe, Walking Trails, Parks, Recreation Center, Pool, and a Nature Preserve. This beautiful property is Located minutes from hospitals, golf courses, restaurants, and retail centers. Home Has Never Flooded. Check Out the Virtual Tour and Schedule your Private Showing Today!' ,`Acres` = '0.269' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S539306 - GRAYSTONE HILLS 06, BLOCK 2, LOT 14' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11719' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '765' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Graystone Hills 06' ,`TaxAmount` = '7791' ,`TaxRate` = '3.0284' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708917' WHERE `Matrix_Unique_ID` = '210326094' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T09:44:12.950' ,`MLSNumber` = '56065166' ,`ListAgentFullName` = 'Janet Schmidt' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795339' ,`Longitude` = '-95.435550' ,`PhotoCount` = '42' ,`PostalCode` = '77008' ,`RoomCount` = '8' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Cindy' ,`StreetNumber` = '6723' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2011' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has a large lot that is beautifully landscaped with a large Oak tree. The front porch is very big. Kitchen has custom cabinets, double oven and breakfast bar. The Utility room is very large with a pantry. New windows and hardwood floors thru out the home. This home has a large separate living room, den and formal dining. The master bedroom has a walk-in closet and the bathroom has a walk-in shower with a seat and double shower heads. Backyard has large flagstone patio and gorgeous landscaping.' ,`Acres` = '0.2463' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 51 TIMBERGROVE MANOR SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10730' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timbergrove Manor' ,`TaxAmount` = '10255' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708917' WHERE `Matrix_Unique_ID` = '210353305' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T08:06:06.807' ,`MLSNumber` = '43070685' ,`ListAgentFullName` = 'Kathy Abshire' ,`ListOfficeName` = 'Worth Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.932057' ,`Longitude` = '-95.180545' ,`PhotoCount` = '33' ,`PostalCode` = '77044' ,`RoomCount` = '10' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Wadlington' ,`StreetNumber` = '14431' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2092' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely 1 story with detached garage located in beautiful Summerwood community. This house has been freshly painted, tile throughout main living areas, study, dinning, bathrooms and kitchen. New carpet in all bedrooms. Sprinkler system throughout the yard and landscape. Pre wiring for surround sound and multi media in main living area. This wonderful home is move in Ready!' ,`Acres` = '0.2007' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 3 SEVEN OAKS VILLAGE SUMMERWOOD SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '8742' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '926' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SUMMERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Summerwood' ,`TaxAmount` = '6280' ,`TaxRate` = '2.683' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708918' WHERE `Matrix_Unique_ID` = '210364551' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T09:01:36.183' ,`MLSNumber` = '18860664' ,`ListAgentFullName` = 'Pinky Pirani' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.625606' ,`Longitude` = '-95.692834' ,`PhotoCount` = '50' ,`PostalCode` = '77407' ,`RoomCount` = '13' ,`ListPrice` = '635000.00' ,`Status` = 'Active' ,`StreetName` = 'Windmill Hill' ,`StreetNumber` = '4111' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4115' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful and functional 5 bedroom/ 4.5 bath Perry home located in the gated Old Orchard sub-division zoned to excellent FBISD schools! You\'re greeted with 23ft high ceilings in the foyer leading to family room. Large open concept Texas style family room w/ 2 story windows, a spacious island kitchen & breakfast nook! Nice sized office w/French-doors that can be used as a formal living room & an elegant formal dining room. 2 bedrooms downstairs! A large primary bedroom w/bay window, spa-like ensuite bathroom w/ a garden tub, walk-in shower, double sinks, and his and hers walk-in closets. The 2nd downstairs bedroom has a large walk-in closet & private full bath that is perfect for visiting guests or as a mother-in-law suite. Upstairs, a large game room, media room, 3 bedrooms with large walk-in closets and 2 full bathrooms. Relaxing backyard w/covered extended patio backing up to nature reserve! No back neighbors. New roof, less than 3-year-old.' ,`Acres` = '0.2367' ,`Area` = '37' ,`BuilderName` = 'Perry Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'OLD ORCHARD SEC 4, BLOCK 1, LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10310' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1225' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MALALA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Old Orchard Sec 4' ,`TaxAmount` = '10877' ,`TaxRate` = '2.6329' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708918' WHERE `Matrix_Unique_ID` = '210461519' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T09:07:16.680' ,`MLSNumber` = '61932825' ,`ListAgentFullName` = 'Teri Brockway' ,`ListOfficeName` = 'Simien Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.593029' ,`Longitude` = '-95.116934' ,`PhotoCount` = '35' ,`PostalCode` = '77059' ,`RoomCount` = '8' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Crestbrook' ,`StreetNumber` = '15722' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2252' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Brook Forest! This one-story, four bedroom home offers multiple living areas with flexibility to meet your family\'s needs. The kids and pets will enjoy the spacious back yard and there is plenty of room for entertaining. The beautiful neighborhood offers play grounds, swimming pool, tennis courts, and a greenbelt for those who like to walk or bike. Zoned to fantastic Clear Creek ISD schools, and located near lots of shopping, dining, and entertainment. No flooding! Now is your opportunity to put your special touches on this home in the heart of Clear Lake.' ,`Acres` = '0.2206' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 62 BROOK FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '508' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ARMAND BAYOU ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brook Forest Sec 03' ,`TaxAmount` = '7398' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663708918' WHERE `Matrix_Unique_ID` = '211011825' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T08:35:27.027' ,`MLSNumber` = '72314405' ,`ListAgentFullName` = 'Robbie Nelson' ,`ListOfficeName` = 'RE/MAX Crossroads Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.440908' ,`Longitude` = '-95.107159' ,`PhotoCount` = '25' ,`PostalCode` = '77539' ,`RoomCount` = '7' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Catalpa Bluff' ,`StreetNumber` = '6872' ,`StreetSuffix` = 'Lane' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1844' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great open floor plan with primary on the first floor. Upstairs features a game room and 3 bedrooms. Lots of closet space in this home. Pergola in the back yard for sitting by a fire pit or just to relax from the hustle and bustle of life!' ,`Acres` = '0.1102' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ENCLAVE AT BAY COLONY WEST SEC ONE PHASE I (2011) ABST 19, B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Enclave At Bay Colony West Sec' ,`TaxAmount` = '7842' ,`TaxRate` = '3.4497' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708918' WHERE `Matrix_Unique_ID` = '211217815' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T08:25:15.983' ,`MLSNumber` = '29060010' ,`ListAgentFullName` = 'Ingrid Gonzalez' ,`ListOfficeName` = 'Inside Galveston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.296309' ,`Longitude` = '-94.791628' ,`PhotoCount` = '42' ,`PostalCode` = '77550' ,`RoomCount` = '6' ,`ListPrice` = '427000.00' ,`Status` = 'Active' ,`StreetName` = '24th' ,`StreetNumber` = '1326' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful opportunity to own a classic Victorian cottage on one of Galveston\'s oak tree shaded streets. Home was built sometime in the late 1890\'s and surrounded by homes inspired by Greek and Colonial Revival along with Victorian and Southern charm. Clever arrangement of rooms and modifications for upgrades has been a hit with vacationers as short term guest experience if only for a moment, the character and piece of Galveston\'s history. Upgrades were completed within the past 3 years. This property is located a short distance to the beach and downtown areas. Galveston has been an anchor for the season investor and young entrepreneurs alike. So, if Galveston has piqued your interest, don\'t hesitate to consider this lovely island as part of your investment portfolio. View now before the Fall rental season begins. This may be the mooring you\'ve been trying to locate.' ,`Acres` = '0.0558' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR (1000-5) PT OF NE BLK 17 GALVESTON O' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2430' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`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` = '1' ,`Style` = 'Victorian' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '5785' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1895' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708918' WHERE `Matrix_Unique_ID` = '211355718' --> 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','211846701','1663708918','211846701','2022-09-10T09:05:20.230','7275068','LaNell Shaw','Keller Williams Realty','','','30.704957','-95.087025','45','77351','4','169000.00','Active','Imogene','180','','Livingston','2','0','3','1155','Single-Family','This Dollhouse Cottage has been completely Renovated throughout - Single Level 3 Bedroom / 2 Full Baths with Mud/Utility Room on Approx 1/3 Acre in Waterfront Subdivision. Excellent Residence, Starter Home or Retirees will find this very appealing. Upgrades include: New Vinyl Plank Flooring/Carpet, Paint, Fixtures, Remodeled to add 3rd Bedroom. Stainless Appliances. Recent Roof and A/C. Feels like New and Ready to Move-In! Storage Building and Covered Carport in back for Boat or park RV. Second large, separate Building for Storage or Workshop. Income Property ideas. Two Additional Lots Adjoining available for more elbow room and privacy - separate affordable purchase. Just steps from the Lake and the Subdivision offers Homeowner Fishing Pier and Fenced Covered Picnic Area where Sunsets are Amazing - come enjoy! Adorable - don\'t hesitate to come see this one.','0.344','44','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Lake Livingston Area','Central Electric','1','NUGENT\'S COVE SECTION 1 BLK 11 LOT 11','Cleared,Subdivision Lot','15000','Appraisal District','','180','0','','0','Electric Oven','0','','','Electric Range','','Composition','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Accompany,Lockbox Front','Appraisal','1','Traditional','Nugents Cove Sec 1','2138','1.8745','Public Water,Septic Tank','1970','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T09:49:22.857' ,`MLSNumber` = '37885387' ,`ListAgentFullName` = 'Rhonda Smith' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Jordan Hogan' ,`SellingOfficeName` = 'NextHome Realty Center' ,`Latitude` = '30.247822' ,`Longitude` = '-95.534558' ,`PhotoCount` = '36' ,`PostalCode` = '77384' ,`RoomCount` = '7' ,`ListPrice` = '400000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Timber' ,`StreetNumber` = '41' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1723' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pride of ownership shows in this “neat as a pin” home that sits on an acre in Lake Creek Forest! With its fresh & trendy color palette, this home has a casual vibe with an open concept family room, kitchen and dining area. Rich wood floors and the fireplace add warmth and lend a cozy feel. The dining area features a large bay window with a great view and window seat with added storage. This kitchen allows you to enjoy the family while preparing their favorite meals! Granite countertops, convection double ovens The Texas sized utility room is nearby with wine rack and extra cabinetry plus room for secondary refrigerator. This home features a split plan with a spacious primary en-suite with separate shower, soaking tub and double sinks. The secondary bedrooms share a beautifully updated hall bath as well. The property features a pond, a storage shed with plenty of space to play, or room for a pool. You’ll love the feeling of country living, yet so close to any amenity you desire.' ,`Acres` = '1' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE CREEK FOREST 01, BLOCK 4, LOT 6, ACRES 1.000' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '264' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Creek Forest 01' ,`TaxAmount` = '3781' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708918' WHERE `Matrix_Unique_ID` = '211925419' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T08:54:38.717' ,`MLSNumber` = '15650912' ,`ListAgentFullName` = 'Patricia Buchanan' ,`ListOfficeName` = 'Texas Diamond Realty' ,`SellingAgentFullName` = 'Jeneen Poole' ,`SellingOfficeName` = 'Vylla Home' ,`Latitude` = '29.979357' ,`Longitude` = '-95.118051' ,`PhotoCount` = '50' ,`PostalCode` = '77532' ,`RoomCount` = '7' ,`ListPrice` = '679900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Little Deer' ,`StreetNumber` = '20811' ,`StreetSuffix` = 'Lane' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '3126' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning custom-built home has an exquisite entry with marble floors leading into an alluring open den/dining room area with an amazing gourmet kitchen with elite appliances, 2 dishwashers, built in coffee machine, sub-zero commercial refrigerator that\'s included, 2 garbage disposals, ice maker, wine cooler, Island and walk in pantry with epic storage. This irresistible open concept is perfect for the holiday\'s and entertaining. This floor plan has 2 primary bedrooms each having a private bath. Patio doors lead to an engaging back yard oasis with a Texas shaped pool and hot tub, mosquito mister all around the property, a sprinkler system and gas grill that is also included. First primary bedroom is gorgeous with a voluminous walk-in closet that walks through to the laundry room. Media room /3rd bedroom, immense guest house with a full bathroom and walk in closet, living room and a full kitchen. This home also has a Generac generator. Property is a little over 1 acre!' ,`Acres` = '1.1149' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LTS 151 & 152 BLK 20 INDIAN SHORES SEC 5A' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '48565' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Indian Shores Sec 05a' ,`TaxAmount` = '14789' ,`TaxRate` = '2.7056' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708919' WHERE `Matrix_Unique_ID` = '211926394' --> 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','211941220','1663708919','211941220','2022-09-10T09:11:56.590','40928180','Jared Turner','Turner Mangum,LLC','','','30.131402','-95.747171','48','77355','9','574990.00','Active','Country','17710','Grove','Magnolia','3','0','4','2782','Single-Family','Stunning Single-Story, situated on a private, half acre + home site in the heart of the expanding area of Magnolia. The home offers a very thoughtful and functional plan, hosting 4 Bedrooms | 3 Full Baths | 3 Car Garage. Find custom touches throughout, elegant hardwood floors, coffered ceilings, crown molding, & more. Enjoy an expansive living room design, accented by a stately stone corner fireplace! The kitchen offers an island, built-in desk, adjacent breakfast area, walk-in pantry, and an abundance of counter/cabinetry space. Spacious Primary Suite, providing private backyard views and a luxury bathroom & walk-in closet. The front bedroom currently functions as an office with glass french doors, but can easily be utilized as a 4th bedroom w/ its walk-in closet. Bedrooms 2 & 3 share a jack-n-jill bathroom, and bathroom #3 is accessible through the hallway. LARGE front & backyards, beautiful landscaping, and a storage shed! New roof 2021','0.565','15','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Magnolia/1488 West','Central Gas','1','COUNTRY WOODS ESTATES 02, BLOCK 7, LOT 25','Cul-De-Sac,Subdivision Lot','24611','Appraisal District','','400','0','','3','','0','','','','','Composition','36 - Magnolia','NICHOLS SAWMILL ELEMENTARY SCHOOL','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Country Woods Estates 02','7395','1.8587','Aerobic,Public Water','2015','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-10T09:07:57.910' ,`MLSNumber` = '28481166' ,`ListAgentFullName` = 'Kimberly Duckett' ,`ListOfficeName` = 'Realty ONE Group, Experience' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.325022' ,`Longitude` = '-96.184459' ,`PhotoCount` = '11' ,`PostalCode` = '77880' ,`RoomCount` = '3' ,`ListPrice` = '224990.00' ,`Status` = 'Active' ,`StreetName` = 'Sweed' ,`StreetNumber` = '19121' ,`StreetSuffix` = 'Road' ,`City` = 'Washington' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1149' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This well maintained 3 bedroom 2 bath home is a rare find. Come and enjoy the cozy country living it has to offer. Fully fenced half acre. Conveniently located off Hwy 105 just 30 minutes from College Station and 20 minutes from Brenham. There is a storage building with electricity. Call today to schedule your appointment.' ,`Acres` = '0.5' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0064 JACKSON, E. D. , TRACT 225, ACRES 0.50' ,`LotDesciption` = 'Cleared' ,`LotSize` = '21780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'N/A' ,`TaxAmount` = '1750' ,`TaxRate` = '1.5429' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708919' WHERE `Matrix_Unique_ID` = '211964626' --> 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','212090779','1663708919','212090779','2022-09-10T09:27:05.357','84703180','Allison King','LennarVillageBldr-JaredTurner','','','30.085550','-95.183268','11','77365','10','496590.00','Active','Sea Star','9435','Lane','Porter','4','1','5','3126','Single-Family','The beautiful two-story Oak Hill III-G Next Gen floor plan, from the Fairway Collection by Lennar, offers space and versatility, including an optional attached suite with a private entrance, single-bay garage, living room, kitchenette, bedroom and bath. In the main home is a lavish owner’s suite and open living area, along with three bedrooms and a bonus room situated upstairs.','','32','Lennar','','','','Mud','1','','','Kingwood East','Central Gas','1','SEC 0017 BLK 001 LOT 013','Subdivision Lot','','','','1200','1','To Be Built/Under Construction','2','','0','','','','','Composition','29 - Humble','SHADOW FOREST ELEMENTARY SCHOOL','KINGWOOD HIGH SCHOOL','RIVERWOOD MIDDLE SCHOOL','Appointment Required','Builder','2','Traditional','Kingwood Royal Brook','','2.58','Public Sewer,Water District','2023','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','212164731','1663708919','212164731','2022-09-10T09:15:41.197','71787935','Kathryn O\'Hearn','Realex Homes','','','29.474720','-95.361849','30','77578','8','389900.00','Active','Lewis Ln','6903','','Manvel','3','0','3','2625','Single-Family','Don\'t miss out on this beautiful country style home with its stylish wrap around porch! The kitchen overlooks the living area which has a vaulted ceiling accented with wood beams. The split floor plan offers a master bedroom with two closets and an accomodating walk in tub. Upstairs there is a large BONUS ROOM which comes with a full bath! There is plenty of storage space throughout this gem. Welcome home!','1.07','5','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Alvin North','Central Gas','0','Lot 33','Corner','','','','','0','','1','Double Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','E C MASON ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','MANVEL JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Back','Seller','2','Traditional','Manvel Acres','','','Public Sewer,Public Water','1992','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','212165326','1663708919','212165326','2022-09-10T09:22:43.013','18328652','Faline Windell','Page Properties','','','30.299851','-95.697517','15','77316','8','485000.00','Active','Fm 149','8225','Road','Montgomery','3','0','5','3868','Single-Family','Gorgeous Estate with Incredible Hardwood Trees Throughout on Scenic approximately 3.16 Acres. Amazing Estate Home with 5 Bedrooms, Game Room, Study, 3 Full Baths, 2 Car Garage, Pool, Guest House, Barn perfect for Horses or Workshop, Well, Cirular Driveway with Porte-cochere, Fencing, and Many Property Improvements. Charming Estate Home priced according to updates needed and sold as is. Stunning Property in a Wonderful Location across the street from Cook\'s Branch Conservancy. Very Low Tax Rate. Highly Sought after MISD and Lake Creek High School. No HOA fees.','3.16','39','','','','','Other Disclosures','','Wood Burning Fireplace','1','Montgomery County Northwest','Central Electric','0','LAKE CREEK ESTATE, LOT 11, ACRES 3.16','Cleared,Wooded','137649','Other','','','0','','2','','1','Vinyl Lined','','','','Composition','37 - Montgomery','MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Colonial,Ranch,Traditional','Lake Creek Estate','4430','1.8242','Septic Tank,Well','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','212170570','1663708919','212170570','2022-09-10T08:46:14.653','61958371','Calvin Kim','Walzel Properties','','','29.781874','-95.699114','50','77094','10','469000.00','Active','Resica Falls','18710','Lane','Houston','3','1','4','2931','Single-Family','Amazing opportunity to own 2 Story 4 bedrooms 3.5 bathrooms, office, formal dining, efficient game room (up), 3 car oversized garage in the desirable Green Trails Park. Great amount of natural light with high ceiling and large windows! Gorgeous and spacious kitchen offers classic white cabinets, elegant granite counter tops, island with cooktop, upgraded kitchen sink with fixture, and a separate breakfast nook. Fresh new interior neutral color paint, hardwood flooring in family room, jack and jill bathroom (2nd floor), ceiling fans, fireplace, and a powder room. Large primary suite offers backyard view, vaulted ceiling, updated frameless shower with separate tub, walk in closet, and dual sinks. Beautiful tall mature trees, sprinkler system, fire pit, No Back Neighbors. New Roof (2016), Tankless water heater, and Water Softener. Quiet low traffic neighborhood. Easy access to I-10, restaurants, shopping, entertainment, and hospitals. Highly rated Schools. Ready for move in! No flood!','0.2231','36','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Katy - Southeast','Central Gas','1','LT 33 BLK 1 GREEN TRAILS PARK SEC 17','Subdivision Lot','9720','Appraisal District','','1150','0','','3','Electric Oven','0','','','Electric Range','','Composition','30 - Katy','PATTISON ELEMENTARY SCHOOL','TAYLOR HIGH SCHOOL (KATY)','MCMEANS JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Green Trails Park Sec 17','8331','2.3533','Water District','1997','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','212192448','1663708919','212192448','2022-09-10T09:59:40.093','87013287','Judith Hayes','Designed Realty Group','','','30.713161','-95.176629','36','77331','5','249500.00','Active','Lake Shore','401','Drive','Coldspring','1','1','3','1564','Single-Family','Dreaming of a weekend get away cabin or ready to be lake side full time?? This lake view log cabin is a wonderful option for you and your family! Fishing? Boating? Jet Ski? Swimming? All just steps from your front door! This highly sought after community has a private boat ramp for its property owners! Home features 3 bedrooms and 1.5 baths. Open and spacious family room and kitchen - both with a lake view. HOME IS FULLY FURNISHED AND DECORATED! EVERYTHING YOU SEE THERE STAYS WITH THE HOME! Family room has mock fireplace. Window units for AC and portable heating units. Secure safe/gun room with lock located at top. Stackable washer and dryer located in the main bath. Owner\'s bedroom has 1/2 bath. Tile throughout main areas and carpet in bedrooms. Galley style kitchen with portable island and several storage shelves for pantry items. Storage located under porch/home.','0.202','64','','','Electric Dryer Connections,Washer Connections','','Probate,Sellers Disclosure','0','Mock Fireplace','1','Lake Livingston Area','Other Heating','1','HOLIDAY SHORES SUB 2, BLOCK 2, LOT 646, SECTION 5, ACRES .20','Cleared,Water View','8799','Appraisal District','','100','0','','0','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Other','101 - Coldspring-Oakhurst Consolidated','JAMES STREET ELEMENTARY SCHOOL','COLDSPRING-OAKHURST HIGH SCHOOL','LINCOLN JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Other Style','Holiday Shores Sub 2','2000','1.6254','Aerobic,Public Water','2013','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','212192705','1663708919','212192705','2022-09-10T08:31:21.487','44467564','Tory Brown','Connect Realty','','','29.663338','-95.343544','5','77033','0','128000.00','Active','Westover','5402','Street','Houston','1','0','2','1180','Single-Family','This is an amazing Investor\'s special. This 3 bedrooms converted to 2 bedroom for a larger owner\'s bedroom, 1 bath home is available for your next project. Owners currently living in home.','0.1598','3','','','','','Sellers Disclosure','','','','Medical Center South','Other Heating','0','LT 9 BLK 28 INWOOD TERRACE SEC 3','Other','6960','Appraisal District','','','0','','2','','0','','','','','Other','27 - Houston','WOODSON ELEMENTARY SCHOOL','WORTHING HIGH SCHOOL','THOMAS MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Ranch','Inwood Terrace Sec 03','1582','2.3307','Public Sewer,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','212237193','1663708919','212237193','2022-09-10T09:38:06.900','61979200','Robert Villanueva','Surge Realty','','','29.615289','-95.016284','42','77571','4','469000.00','Active','Shady','619','Lane','La Porte','2','0','4','1580','Single-Family','Land of OPPORTUNITIES! Over half an acre of land (23,550 sqft) is available for you to own now (which is rare to find). Make this four-bedroom, two full-bathroom with canal views your dream home. You can make this a vacation home or an income-producing investment property (Airbnb). The opportunities are endless. The seller is willing to include the furniture. Enjoy plentiful breezes from the large back deck with no back neighbors. Add your touch to the covered and fenced spacious storage under the house. Save money with LOW TAX RATES and NO HOA! Minutes from Sylvan Beach Park & the public boat launch. Convenient access to Houston Yacht Club. Easy access to Hwy 146, San Jacinto Maritime College. They are not making more land. This is an excellent opportunity to own over half an acre.','0.5406','7','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Shoreacres/La Porte','Central Gas','0','LT 3D & E 50 FT OF LT 2D SHADY OAKS','Water View,Waterfront','23550','Appraisal District','','','0','','0','Electric Oven','0','','','Gas Range','','Composition','35 - La Porte','BAYSHORE ELEMENTARY SCHOOL','LA PORTE HIGH SCHOOL','LA PORTE J H','Accompany,Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Shady Oaks','5050','2.7208','Public Sewer,Public Water','1958','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','212247342','1663708919','212247342','2022-09-10T08:56:53.327','37362101','April Maki','Gehan Homes Brokerage, LLC','','','29.507853','-95.004216','18','77573','6','459990.00','Active','Sellers Island','2803','Drive','League City','2','0','3','2009','Single-Family','Enjoy coastal living at its finest at Coastal Point community. This master-planned oasis offers a staycation lifestyle with walking trails and parks, a picturesque pond, and a resort-style pool. Stunning NEW construction Palmfloor plan is a 1-Story, 3 beds with flex room, 2 baths & 2-car garage! The kitchen is open & bright offering elilxir kitchen backsplash, espresso cabinets, caliza omega stone countertops & butternut wood flooring. Fully sodded yard with sprinkler system! Home will be ready for an October move-in!','','33','Gehan Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','League City','Central Gas','1','Lot 26 Block 4 Section 4','Subdivision Lot','6000','Other','','1000','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Cooktop','','Composition','9 - Clear Creek','SANDRA MOSSMAN ELEMENTARY SCHOOL','CLEAR FALLS HIGH SCHOOL','BAYSIDE INTERMEDIATE SCHOOL','Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment','Builder','1','Traditional','Coastal Point','','2.8','Public Sewer,Public Water,Water District','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','212257614','1663708919','212257614','2022-09-10T09:14:09.657','89317274','Allison King','LennarVillageBldr-JaredTurner','','','30.085500','-95.182825','6','77365','7','293990.00','Active','Arcadia Sound','6233','Lane','Porter','2','0','4','1538','Single-Family','NEW! \"San Luis II B\" floor plan from the Gulf Coast collection by Lennar in Royal Brook. This single-story home has a smart layout for growing families. Three bedrooms share a hall bathroom at the back of the home and the owner’s suite is in the front with a full bathroom. Beside it is the open concept living area with a family room, modern kitchen, breakfast nook and covered patio.\r\n\r\nPrices and features may vary and are subject to change. Photos are for illustrative purposes only.','','32','Lennar','','','','Mud','','','','Kingwood East','Central Gas','1','SEC 0010 BLK 001 LOT 025','Subdivision Lot','','','','1200','1','To Be Built/Under Construction','','','0','','','','','Composition','29 - Humble','SHADOW FOREST ELEMENTARY SCHOOL','KINGWOOD HIGH SCHOOL','RIVERWOOD MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Kingwood Royal Brook','','2.58','Public Sewer,Water District','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','212276567','1663708919','212276567','2022-09-10T08:47:39.703','49825382','Nora Tornero','Keller Williams Realty FortWorth','','','28.964887','-95.371408','29','77541','8','280000.00','Active','Avenue A','919','','Freeport','2','0','3','2442','Single-Family','History lovers! All the charm of the early 1900s perfectly located on the corner of a quaint, established neighborhood 10 minutes from the beach. Equally a gardener’s dream, visionaries will adore the manor-like property reminiscent of a different era. The eye-catching curb appeal of 6 lots is sure to impress! Approach the classic over-sized front porch and enter a grand foyer that resembles history’s fine living. Take a tour and view the hardwood floors, 10’ ceilings, traditional separate kitchen and living room PLUS a huge formal dining fit for entertaining in style. The kitchen has gas appliances and space for eat-in dining while the living room boasts a period appropriate gas fireplace and lots of natural light. Enjoy a 20x16 outdoor storage, covered rear parking and a mud room for your convenience. Fill this 3 bdrm, 2 bath & 1 extra bonus room with your ideas! Timeless in modern day, only an in-person visit can convey the historic richness and future possibilities.','0.287','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','Gas Connections','1','Freeport','Central Gas','0','VELASCO (FREEPORT), BLOCK 668, LOT 19-20-21-22','Corner,Other','12502','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','7 - Brazosport','VELASCO ELEMENTARY SCHOOL','BRAZOSPORT HIGH SCHOOL','FREEPORT INTERMEDIATE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Velasco Freeport','3633','2.5981','Public Sewer,Public Water','1900','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','212305012','1663708919','212305012','2022-09-10T08:23:29.250','68688415','Trey Young','Promark Realty Group','','','29.781665','-95.770945','45','77450','11','439000.00','Active','Adwick','23010','Court','Katy','3','0','5','3338','Single-Family','Beautiful home located in a CUL-DE-SAC! Open floor plan and multiple areas within the home to enjoy with family or friends. Gorgeous large plank tile on first floor and lots of large windows, allowing the natural light to shine in. Formal dining and living room areas as you walk in. Family room off kitchen and includes gas fireplace. Stainless steel appliances, gas range, loads of cabinets and counter space in kitchen. Four bedrooms upstairs (including Primary) and one secondary bedroom down. All bedrooms are VERY spacious. Large game room/flex space up. HUGE primary bedroom w/ sitting area, wood floors and vaulted ceiling. Primary bathroom features glass framed walk in shower, large soaking tub and two separate vanity areas. The backyard offers a covered patio and a large deck perfect for the whole family and plenty of room to add a pool! Easy access to I-10 and dining and shopping options Great tax rate. Katy ISD','0.1844','36','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Katy - Southeast','Central Gas,Zoned','1','LT 66 BLK 3 GOVERNORS PLACE SEC 4','Cul-De-Sac,Subdivision Lot','8031','Appraisal District','','608','0','','2','Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','30 - Katy','WEST MEMORIAL ELEMENTARY SCHOOL','TAYLOR HIGH SCHOOL (KATY)','WEST MEMORIAL JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Governors Place Sec 04','6895','2.3833','Public Sewer,Public Water,Water District','1997','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','212310791','1663708919','212310791','2022-09-10T09:07:11.487','88280776','Dawn Lanclos','2 Gen Realty, LLC','','','29.176323','-95.424312','32','77515','5','197400.00','Active','Lorraine','740','Street','Angleton','1','0','4','1799','Single-Family','Come see your new home only 25 minutes from the beach! This home has a large primary bedroom with an extra large primary closet! Retreat to your screened in porch for outdoor living without the mosquitos! Large fenced in backyard for your kids and pets to play!','0.1702','5','','','','','Sellers Disclosure','0','','1','Angleton','Central Electric','0','K & S PLAZA (ANGLETON) BLK 2 LOT 25 (E/54.5\'), UNDIVIDED INT','Subdivision Lot','7414','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Cooktop','','Composition','5 - Angleton','NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)','ANGLETON HIGH SCHOOL','ANGLETON MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','K & S Plaza Angleton','1760','2.6102','Public Water','1952','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','212383411','1663708919','212383411','2022-09-10T08:09:11.163','50087224','Nathan Kinser','NetWorth Realty of Houston, LLC','','','29.486784','-94.923511','10','77539','4','169000.00','Active','11th','715','Street','San Leon','2','0','4','1800','Single-Family','Nearly complete, this duplex just needs finishing and cleanup to make this dream come true. Needs hand rails on steps to pass final inspection. Once passed, electric and water can bed hooked up. New water heaters, new porch with privacy walls, 220 volt hook ups for large window units in living rooms, left unit has fresh remodel this year, right side unit is about 4 year old remodel, 2 brand new stoves, 1 new fridge, 1 old fridge, electrical is complete in both units, new water heaters, elevation is 13.2ft above sea level, requirement is 13ft. This is a great opportunity to grab some sweat equity. 2 units both 2 bed 1 bath. Live in one side and rent the other if you would like. Schedule a showing today.','0.2238','33','','','','','Mud,Other Disclosures,Sellers Disclosure','','','','Bacliff/San Leon','Central Gas','0','ABST 10 A EDWARDS LOTS 20 THRU 22 BLK 136 SAN LEON','Other','9749','Appraisal District','','','0','','0','','0','','','','','Composition','17 - Dickinson','SAN LEON ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','JOHN AND SHAMARION BARBER MIDDLE SCHOOL','Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','San Leon','5012','2.521','Water District','2017','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','212383750','1663708919','212383750','2022-09-10T09:12:20.660','78065848','Diane Trykowski','Platinum Key Realty','','','29.979428','-95.201606','31','77346','9','280000.00','Active','Gypsy Forest','4834','Drive','Humble','2','1','4','2330','Single-Family','Look no further! This spacious 4 bedroom, 2.5 bath home is waiting for you! 4834 Gypsy Forest is located in a quiet neighborhood that backs to a heavily wooded area. Home features laminate wood flooring, solar panels, a large covered patio with structure and firepit, driveway extension, plus so much more! Home has only had 2 owners so it has been greatly taken care of. Come and see your new home today!','0.1284','1','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Atascocita South','Central Gas','1','LT 15 BLK 6 TIMBER FOREST SEC 4','Subdivision Lot','5591','Appraisal District','','450','0','','2','Gas Oven,Single Oven','0','','','Gas Cooktop,Gas Range','','Composition','29 - Humble','WHISPERING PINES ELEMENTARY SCHOOL','HUMBLE HIGH SCHOOL','HUMBLE MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Timber Forest','6053','2.933','Water District','1996','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','212384520','1663708919','212384520','2022-09-10T09:27:51.050','90398295','Alisa Story','Olde Homestead Properties of Texas','','','30.123793','-95.566958','34','77375','9','509999.00','Active','Stablewood Lakes','9323','Lane','Tomball','2','1','3','2301','Single-Family','Meticulously maintained w/many upgrades, this 1 story, 3/2.5 w/3 car garage on a lrg cul-de-sac lot w/ample parking. High ceilings, lots of windows for natural lighting & upgraded flooring thru out. Open concept perfect for family & entertaining. Large living room, dining area & an amazing kitchen in the heart of the home, huge center island w/seating, pendant lighting, 5 burner gas range, granite counters, mosaic backsplash, under cabinet lighting & dbl door pantry. Master w/bay window, granite vanity, dbl sinks, oversized walk-in shower w/rain showerhead, seating & lrg walk in closet. Down the hall are the secondary bedrooms, main bath & laundry w/built-in folding table. Study w/French doors & a built-in bench upon entering from garage. Covered back patio w/TV hookup, gas grill connections & fruit trees. Gutters, sprinkler system, 50-amp breaker for generator, lrg walkable attic & so much more. Amenities: pool w/slide, playgrounds, walking paths & lakes. Close to 99. Tomball ISD','0.2187','14','David Weekley','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Tomball','Central Gas','1','LT 25 BLK 2 LAKES AT CREEKSIDE SEC 4','Cul-De-Sac,Subdivision Lot','9527','Appraisal District','','975','0','','3','Gas Oven','0','','','Gas Range','','Composition','53 - Tomball','TIMBER CREEK ELEMENTARY SCHOOL (Tomball)','TOMBALL HIGH SCHOOL','CREEKSIDE PARK JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Lakes at Creekside','10246','2.784','Public Sewer,Public Water','2019','Appraisal District'); --> New record created successfully