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` = '2023-01-14T13:27:39.663' ,`MLSNumber` = '95286412' ,`ListAgentFullName` = 'Tracie Dillon' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.974568' ,`Longitude` = '-95.465039' ,`PhotoCount` = '27' ,`PostalCode` = '77014' ,`RoomCount` = '6' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Silverglen Run' ,`StreetNumber` = '13222' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1834' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Home that you will never want to leave. Soaring ceilings, soothing palette, open floor plan, gorgeous wood-like flooring, upgraded lighting, window blinds, & lots of natural light throughout. Stunning open concept kitchen featuring a large center island with bar seating, granite counters, breakfast bar, Black appliances, under-mount sink & plenty of wood cabinets. Bedrooms are generously sized and the primary bedroom includes a bay window, upscale primary bath w/ his and her sinks, separate spa tub, and shower. Plush carpet in all bedrooms, ample closets, interior laundry room, & wall space for your art or family photos. Ring doorbell and alarm system installed for added security. Lush green backyard landscape with fire pit. Lots of room for pets, play, entertaining, and more. This gem won\'t last long! See it and make it yours! MOTIVATED SELLER!' ,`Acres` = '0.1606' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 SILVERGLEN NORTH SEC 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6997' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '530' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'DELORAS E THOMPSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'STELLE CLAUGHTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Silverglen #rth Sec 15' ,`TaxAmount` = '5622' ,`TaxRate` = '2.8867' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675135409' WHERE `Matrix_Unique_ID` = '210202696' --> 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','210673236','1675135410','210673236','2023-01-14T13:35:57.520','19065787','Beverly Bradley','Weekley Homes','','','29.563879','-95.746960','50','77469','9','513049.00','Active','Travers Hill','23739','Road','Richmond','3','0','4','2593','Single-Family','Bring your creative design ideas to life in the spacious and sophisticated Omaha family home plan. Your glamorous Owner’s Retreat offers a scenic backyard view, expansive walk-in closet, and an everyday-spa bathroom. Each lovely spare bedroom provides ample closets and room for personalization. Create the ultimate home office in the lively and bright study. Explore new vistas of culinary delight in the streamlined kitchen, featuring a presentation island and countertops that extend to the dining room. Design your ideal living arrangement in the open-concept floor plan. Take a breath of fresh air and enjoy a gentle breeze from your timeless covered patio. Bonus features include extra storage in the 2-car garage and a central laundry room. What specialty rooms will you create in the FlexSpace? of this superb new home plan?','','30','David Weekley Homes','','','','Mud','','','','Fort Bend South/Richmond','Central Electric,Central Gas','1','Lot 14 Block 2','Corner,Other,Subdivision Lot','','','','750','1','To Be Built/Under Construction','2','','0','','','','','Composition','33 - Lamar Consolidated','PHELAN ELEMENTARY SCHOOL','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox','Builder','1','Traditional','Veranda','','3.22','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T13:41:15.520' ,`MLSNumber` = '34930762' ,`ListAgentFullName` = 'Roxanna Plazas' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.876443' ,`Longitude` = '-95.733584' ,`PhotoCount` = '26' ,`PostalCode` = '77449' ,`RoomCount` = '7' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Southern Colony' ,`StreetNumber` = '21131' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1452' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 1 SETTLERS VILLAGE SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Settlers Village Sec 01 R/P' ,`TaxAmount` = '4531' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675135410' WHERE `Matrix_Unique_ID` = '211014034' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T13:31:58.880' ,`MLSNumber` = '46578803' ,`ListAgentFullName` = 'Santa Creado' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747536' ,`Longitude` = '-94.971813' ,`PhotoCount` = '32' ,`PostalCode` = '77520' ,`RoomCount` = '6' ,`ListPrice` = '307000.00' ,`Status` = 'Active' ,`StreetName` = 'Morrell' ,`StreetNumber` = '508' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1809' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION!!! June 2022 completion!! Welcome to this amazing 1 story home with 3 bedrooms, 1 office/study room, 2 full baths and 2 car garage. Boasting of a great open floor plan with a spacious Family room that overlooks to the Kitchen. The Kitchen has beautiful white cabinetry with quartz countertops and plenty of counter space. The laundry room is located inside the house with large space for extra storage. The primary bath has double-sink vanity, walk-in shower and a walk-in closet. Throughout the house you will see high ceilings and a wall in the family room built just for the television. Schedule your private showing today!!' ,`Acres` = '0.1377' ,`Area` = '2' ,`BuilderName` = 'Private Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 13 MORRELL PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'LAMAR ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'HORACE MANN J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Morrell Park Sec 01' ,`TaxAmount` = '535' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675135410' WHERE `Matrix_Unique_ID` = '213220517' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T13:09:26.057' ,`MLSNumber` = '77186661' ,`ListAgentFullName` = 'Kaleb Monroe' ,`ListOfficeName` = 'Real Broker, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.589269' ,`Longitude` = '-95.205529' ,`PhotoCount` = '41' ,`PostalCode` = '77089' ,`RoomCount` = '5' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Joy' ,`StreetNumber` = '11319' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1946' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this completely renovated home sitting on a 6,720 sqft lot with no back door neighbors!! You walk into a beautiful open kitchen-living room concept that includes a BRAND NEW remodeled kitchen with NEW cabinets, NEW grey granite countertops, a NEW microwave, and a NEW dishwasher! All the doors throughout the home are NEW, as well as NEW framing, and absolutely NEW tile throughout the entire home! Through the renovation, the garage was converted to a fresh NEW bedroom living space with cool tones on the walls and plenty of closet space in all bedrooms. This home is ready for its new owner, come out and check it out yourself!' ,`Acres` = '0.1543' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 37 BLK 11 WOOD MEADOWS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'BURNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wood Mdw Sec 02 Reserve A' ,`TaxAmount` = '4983' ,`TaxRate` = '2.7255' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675135410' WHERE `Matrix_Unique_ID` = '213645162' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T14:11:06.863' ,`MLSNumber` = '31042242' ,`ListAgentFullName` = 'John Goerner' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.330709' ,`Longitude` = '-95.617876' ,`PhotoCount` = '19' ,`PostalCode` = '77316' ,`RoomCount` = '3' ,`ListPrice` = '214900.00' ,`Status` = 'Active' ,`StreetName` = 'Skylane' ,`StreetNumber` = '6082' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1482' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction by Quality Custom Homes. Two Story 3 bedroom 2.5 bathroom charmer! Large open-concept living area with lots of natural light, wood look like floors, and high vaulted ceilings which provide a wonderful sense of space. The kitchen boasts a fresh modern look with gorgeous granite countertops, beautiful wood cabinets, large pantry and stainless steel appliances. Quality Custom Homes includes higher quality fixtures throughout their homes. The primary bathroom has a very nice shower with a calming spa feel. There is a dedicated laundry room and a beautiful patio! PLEASE NOTE: the house will be completed roughly by mid-late December. If you put under contract fast enough you can select from a variety of custom colors / material options to give this home your personal touch!' ,`Acres` = '0.1469' ,`Area` = '39' ,`BuilderName` = 'SJP Capital' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S654001 - LAKE BONANZA 01, BLOCK 9, LOT 27' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6399' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '243' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Bonanza 01' ,`TaxAmount` = '105' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675135410' WHERE `Matrix_Unique_ID` = '213675054' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T14:38:30.057' ,`MLSNumber` = '43600253' ,`ListAgentFullName` = 'Diana Power' ,`ListOfficeName` = 'Texas Power Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.469180' ,`Longitude` = '-95.906697' ,`PhotoCount` = '50' ,`PostalCode` = '77471' ,`RoomCount` = '12' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Engeling' ,`StreetNumber` = '2120' ,`StreetSuffix` = 'Road' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is the perfect country property, but close enough to Hwy 59 to get into Houston easily. This 5 acre property means bring your FFA or 4-H animals. This home includes a 900 sq. ft. shop w/office built in. 50 amp hookup for RV w/drain. There is also a fenced in area around the loafing shed. This home features, wood floors in most of the downstairs, an office that could also be a 5th bedroom, large kitchen w/silestone counters & tons of cabinet space, oversized laundry room w/sink & more storage. The primary bedroom/bath is huge. You will also love the sitting area in the primary bedroom. You will also enjoy the media room/game room w/large balcony. This room includes a sink & room for a kitchenette - great space for family nights. The sellers have added extra concrete out back and great walkways in the yard. This property comes with a bonus hot tub on the back porch. There are beautiful oaks in the yard, but room to run horses. Come see what the country has to offer. Check the VTour' ,`Acres` = '5' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '0249 H AND TC RY, TRACT B, ACRES 5.00' ,`LotDesciption` = 'Other,Wooded' ,`LotSize` = '217800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Lockbox Left Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Engeling Subdivision' ,`TaxAmount` = '8331' ,`TaxRate` = '1.9957' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675135411' WHERE `Matrix_Unique_ID` = '213729755' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T13:01:47.477' ,`MLSNumber` = '28802230' ,`ListAgentFullName` = 'Paula Golden' ,`ListOfficeName` = 'Covington Real Estate, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.400476' ,`Longitude` = '-95.848513' ,`PhotoCount` = '18' ,`PostalCode` = '77461' ,`RoomCount` = '3' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Banker' ,`StreetNumber` = '8124' ,`StreetSuffix` = 'Street' ,`City` = 'Needville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1659' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming home sits on almost 1.5 acres and is truly move in ready! The living/dining/kitchen are welcoming and ready for family gatherings! There are three sunny, nicely sized bedrooms with good closet space! There are clean, bright bathrooms that are loaded with storage. Spacious two car garage and a nice sized covered patio. The oversized backyard, is a great combination of sunshine & shade with a working water well, nice raised deck surrounding a large tree and a storage building! Enjoy the low tax rate and outside the city limits of Needville!' ,`Acres` = '1.4769' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '1.4769 acres of land in the H. & T. R R CI, Survey,' ,`LotDesciption` = 'Other' ,`LotSize` = '43560' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'G Stabbert' ,`TaxAmount` = '3535' ,`TaxRate` = '1.8957' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675135411' WHERE `Matrix_Unique_ID` = '213855975' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T13:05:00.753' ,`MLSNumber` = '59090733' ,`ListAgentFullName` = 'Corby Callaway' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.647710' ,`Longitude` = '-95.938389' ,`PhotoCount` = '49' ,`PostalCode` = '77441' ,`RoomCount` = '13' ,`ListPrice` = '2350000.00' ,`Status` = 'Active' ,`StreetName` = 'Bowser' ,`StreetNumber` = '3130' ,`StreetSuffix` = 'Road' ,`City` = 'Fulshear' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '6254' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of Fulshear\'s FINEST Properties is now for sale. Approx 5 Acres, UNRESTRICTED. MAIN HOUSE- 4 bdrms/5.1baths/3car garage. GUEST HOUSE approx 875 sq ft 2 bdrm, 1 fb, 1 carport, Covered area for RV or Boat. WAREHOUSE- approx 75ftX40ft = 3000 sq ft, w/1 bdrm Apartment. When you drive through the gates of this Estate, your private pond with fountain, bridge and water wheel, will welcome you home. Circular Driveway w/plenty of parking for your guests or family members. The detail work that was put into this CUSTOM home is AMAZING- SPA ROOM, Beautiful Harwood Floors, Phenomenal Fireplace with Undermount Lighting, Game Room, Study, 2nd Bedroom Down, Infinity Pool will Large Spa, Fire Area by Spa, Horses Allowed. 2 Large Wet Bars, European Bathrooms, GENERATOR that will run the entire compound. Property is on +-5 acres.' ,`Acres` = '10.1465' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '0' ,`Legal` = '0076 JNO RANDON, ACRES 5.077, LT 11' ,`LotDesciption` = 'Other,Water View,Wooded' ,`LotSize` = '441959' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MORGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Jno Randon' ,`TaxAmount` = '19169' ,`TaxRate` = '1.8223' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675135411' WHERE `Matrix_Unique_ID` = '214559566' --> 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','216154005','1675135411','216154005','2023-01-14T13:46:19.163','89927003','Miriam Santana','HomeSmart','','','29.987213','-95.157987','28','77346','7','375000.00','Active','CEDAR JUMP DR','7622','','Humble','2','1','4','2869','Single-Family','STUNNING PERRY HOME !!!! WILL NOT LAST !!!!. NEAT AND TIDY .HOUSE HAS BEEN REMODELED.NEW CARPET UPSTAIRS.KITCHEN AND BATHROOMS WITH GRANITE COUNTER TOPS.CERAMIC TILE FLOORS THROUGH OUT THE FIRST FLOOR.PRIMARY BATHROOM HAS BEEN REMODELED, DOUBLE VANITY SINKS ON THE PRIMARY AND SECONDARY BATHROOM ,NEW TILE AND TUB FOR THE PRIMARY BATHROOM .NEW SINK ON THE GUEST BATHROOM .WALKING CLOSET ON THE PRIMARY BEDROOM AND MANY MORE UPDATES,PLEASE CALL OR SCHEDULE YOUR APPOINTMENT TO SEE THIS BEAUTIFUL HOME!!!! .THANK YOU.','','1','PERRY HOME','','','','Exclusions','','','','Atascocita South','Central Gas','1','LT 60 BLK 46 SPRINTERS VILLAGE WALDEN ON LAKE HOUSTON PH VII','Corner','','','','100','0','','3','','0','','','','','Composition,Slate','29 - Humble','MAPLEBROOK ELEMENTARY SCHOOL','ATASCOCITA HIGH SCHOOL','ATASCOCITA MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','WALDEN ON LAKE HOUSTON','','','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','216173310','1675135411','216173310','2023-01-14T14:16:59.630','32166583','Isaac Hernandez','eXp Realty, LLC','','','30.030184','-95.377569','25','77338','3','214900.00','Active','Donata','21523','Circle','Humble','2','0','3','1455','Single-Family','Great three bedroom, Two bath home ready for the perfect family. If your looking for a move in ready home? This is it. The neighborhood is nice with many friendly faces. The home is an open floor plan. Wood flooring through out the home. beautiful darkwood cabinets.\r\ncall me for your private tour.','0.1162','12','','','','','Sellers Disclosure','','','','Aldine Area','Central Gas','1','LT 90 BLK 3 WERRINGTON SEC 1','Cleared','5063','Appraisal District','','370','0','','2','','0','','','','','Composition','1 - Aldine','OGDEN ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','TEAGUE MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Werrington Sec 01','5459','2.9808','Public Sewer,Public Water','2012','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','216197616','1675135412','216197616','2023-01-14T14:49:16.220','93568713','Sherril Bates','Bates-Brinkley Realty','','','29.874316','-94.885228','47','77535','10','498000.00','Active','Cherry Point','11702','','Mont Belvieu','3','0','4','2919','Single-Family','Located on one acre, this one of a kind beauty, has it all. All new kitchen with cabinets galore, kitchen drawers, built in lazy Susan, unique built in vent a hood, a huge Island 7x4 for all your cooking needs, all new appliances and hardware plus sinks and faucets. Many spacious box windows in many of the rooms, Utility room is so spacious, you can have freezer and it also has a built in sink. There are two baths that have double lavatories, separate shower and tub. Primary bedroom has a fabulous bath with double lavatories, separate shower and a unique tub you will love for relaxing. Storage in this house is overwhelming, and the extras are special. Oversize garage 28x23 plus covered porch 12x38 off back of the house. NO FLOODING HERE !!!!!!!!!!!!!','1','53','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Mock Fireplace','1','Chambers County West','Central Electric','0','Lot 28, Cherry Point','Cleared,Corner','1','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','6 - Barbers Hill','BARBERS HILL NORTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL NORTH MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Cherry Point','','','Public Sewer,Public Water','1979','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216207602','1675135412','216207602','2023-01-14T13:57:18.807','45265855','Adriana Mendoza','Nextgen Real Estate Properties','','','30.340685','-95.458860','6','77303','3','360000.00','Active','Mace','2','Street','Conroe','2','1','3','2277','Single-Family','Welcome to your luxurious brand new home! \r\n\r\nThis home has tons of thoughtful details throughout including tile flooring on the entire first floor, a waterfall island, beautiful white quartz countertops with a gray vein and splash of gold. Think contemporary meets modern as you walk through a well planned layout, I mean who else is putting small details like the washer/dryer being offered on both the first and second floor? Enjoy the primary suite conveniently located on the first floor, the second floor offers 2 bedrooms and a game room/ flex space that oversees the living room. \r\n\r\nLocation is ideal being minutes away from I45 and major grocery stores, with a short 17-minute drive to The Woodlands. Guess what that means... You also enjoy a low property tax rate! Schedule your private tour today.','0.2783','19','Imperial Homes','','','','No Disclosures','1','','','Conroe Northeast','Central Electric,Central Gas','0','WIGGINS VILLAGE 03, BLOCK 1, LOT 8','Cul-De-Sac','12121','Appraisal District','','','1','To Be Built/Under Construction','2','Gas Oven','0','','','','','Composition','11 - Conroe','REAVES ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front','Builder','2','Contemporary/Modern,Traditional','Wiggins Village 03','949','2.1863','Public Sewer,Public Water','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','216253122','1675135412','216253122','2023-01-14T14:41:24.163','72195671','Sandra Cook','Century 21 Olympian LakeJackson','','','28.982096','-95.569106','10','77422','5','225000.00','Active','County Road 604','2927','','Brazoria','1','1','2','768','Single-Family','This 2 br 1 bath 2 car garage river home sits in a quiet secluded neighborhood with lots of Pecan and Magnolia trees. There is another room off of the garage that could be a 3rd bedroom. The garage has a 1/2 bath in it. Home is located right next to the private neighborhood boat ramp. Home has a partial wrap around porch that leads to a side porch (12.8x11.4) where you will find a hot tub. Home comes furnished.','0.6','5','','','','','Mud,Sellers Disclosure','','','','West of the Brazos','Central Electric','1','SCOTT ACRES (A0041 T B BELL) LOT 1 ACRES 0.6','Cleared,Waterfront','26136','Appraisal District','','50','0','','2','','0','','','','','Composition','51 - Sweeny','SWEENY ELEMENTARY SCHOOL','SWEENY HIGH SCHOOL','SWEENY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Right Side','Appraisal District','1','Other Style','Scott Acres','2729','1.9264','Septic Tank,Well','1976','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','216259516','1675135412','216259516','2023-01-14T13:05:41.500','86576097','Jared Turner','LennarVillageBldr-JaredTurner','','','29.769036','-96.172847','6','77474','7','290000.00','Active','Riverwood Village','345','Lane','Sealy','2','1','4','2229','Single-Family','NEW! Cottage Collection by Lennar \'\'Linden II-B\'\' Plan in Sealy Texas!!! The lovely two-story Linden floor plan features a smart layout that offers space and versatility. The front door leads into the room which connects with a dining area and kitchen around the corner in a flexible open layout. Upstairs are four bedrooms, including the owner’s suite, which features a private bathroom and walk-in closet. **ESTIMATED COMPLETION JUNE 2023**','','57','Lennar Homes','','','','Other Disclosures','','','','','Central Gas','1','SEC 0001 BLK 001 LOT 023','Subdivision Lot','','','','500','1','To Be Built/Under Construction','2','','0','','','','','Composition','109 - Sealy','SELMAN ELEMENTARY SCHOOL','SEALY HIGH SCHOOL','SEALY JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Riverwood Village','','2.61','Public Sewer,Public Water','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','216373941','1675135412','216373941','2023-01-14T13:43:30.393','60651193','John Goerner','Keller Williams Advtge Realty','','','30.476707','-95.677597','23','77356','3','186900.00','Active','Forest Drive','15844','','Montgomery','2','0','3','1144','Single-Family','**Check out the VIRTUAL TOUR LINK!!!***\r\nNew Construction by Quality Custom Homes! Single Story 3 bedroom 2 bathroom charmer! Large open-concept living area with lots of natural light and high vaulted ceilings which provide a wonderful sense of space. Eye catching wood look tile floors, with high quality fixtures. The kitchen boasts a fresh modern look with gorgeous granite countertops, an island, beautiful wood cabinets, large pantry for storage and stainless steel appliances. The primary bath has a very nice shower with a calming spa feel, and just wait till you see the backyard with a back patio for your enjoyment. Enjoy the outdoors and only minutes away from Sam Houston National Forest and Scotts Ridge boat ramp, Stubblefield Lake Recreation Area, Lone Star Hiking Trail, Northwest Trailhead and Big Creek Scenic Area Trail Head. This could be a primary home or a Getaway home to unplug and relax in nature. Don\'t Forget about the beautiful Lake Mount Pleasant!','0.2475','39','SJP Capital','','','','No Disclosures','1','','','Lake Conroe Area','Central Electric','1','HIDDEN FOREST EST 01, LOT 99','Subdivision Lot','10780','Appraisal District','','36','1','To Be Built/Under Construction','0','','0','','','','','Composition','37 - Montgomery','LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Hidden Forest Estate 01','529','1.8242','Public Water,Septic Tank','',''); --> 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','216375239','1675135412','216375239','2023-01-14T13:51:00.907','83365981','John Goerner','Keller Williams Advtge Realty','','','30.364124','-95.624828','24','77316','2','194900.00','Active','Dounreay','16991','','Montgomery','1','1','2','1188','Single-Family','**Check out our VIRTUAL TOUR!!**\r\n\r\nNew construction by Quality Custom Homes! Two story 3 bedroom, 2.5 bathroom charmer. Large open-concept living area wtih lots of natural light which provides a great sense of space. Eye catching wood look tile floors throughout home. The kitchen boasts a fresh modern look with gorgeous granite countertops, beautiful wood cabinets, large pantry for storage, and stainless steel appliances. The primary bathroom has a large rainhead showerhead with arm extension as well as a beautiful tile that creates a calming spa feel. Quality Custom Homes uses high-end quality fixtures throughout the home.','0.0482','39','SJP Capital','','','','No Disclosures','1','','','Lake Conroe Area','Central Electric','1','S660300 - LAKE CONROE VILLAGE, BLOCK 11, LOT 1','Subdivision Lot','2100','Appraisal District','','384','1','To Be Built/Under Construction','0','','0','','','','','Composition','37 - Montgomery','STEWART CREEK ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Builder','2','Traditional','Lake Conroe Village','309','1.825','Public Sewer,Public Water','','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','216381725','1675135412','216381725','2023-01-14T14:01:50.240','48627854','John Goerner','Keller Williams Advtge Realty','','','30.476853','-95.670031','24','77356','3','212900.00','Active','Beechnut','15872','','Montgomery','2','1','3','1482','Single-Family','New Construction by Quality Custom Homes. Two Story 3 bedroom 2.5 bathroom charmer! Large open-concept living area with lots of natural light, wood look like tile floors, and high vaulted ceilings which provide a wonderful sense of space. The kitchen boasts a fresh modern look with gorgeous granite countertops, beautiful wood cabinets, large pantry and stainless steel appliances. Quality Custom Homes includes higher end fixtures througout the home. The primary bathroom has a very nice shower with a calming spa feel. There is a dedicated laundry room and a beautiful patio. Enjoy the outdoors and minutes away from Sam Houston National Forest and Scotts Ridge Boat Ramp, Stubblefield Lake Recreation Area, Lone Star Hiking Trail, Northwest Trailhead and Big Creek Scenic Area Trail Head. This could be a primary home or a Getaway home to unplug and relax in nature. Don\'t forget about the beautiful Lake Mount Pleasant!','0.1263','39','SJP Capital','','','','No Disclosures','1','','','Lake Conroe Area','Central Electric','1','HIDDEN FOREST EST 04, LOT 125','Subdivision Lot','5500','Appraisal District','','36','1','To Be Built/Under Construction','0','','0','','','','','Composition','37 - Montgomery','LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Builder','2','Traditional','Hidden Forest Estate 04','270','1.8242','Public Water,Septic Tank','','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','216382480','1675135412','216382480','2023-01-14T14:07:57.703','58655855','John Goerner','Keller Williams Advtge Realty','','','30.476743','-95.670031','16','77356','3','179900.00','Active','Beechnut','15862','','Montgomery','2','0','3','1058','Single-Family','Virtual tour link below!!! Single Story 3 bedroom 2 bathroom charmer! Large open-concept living area with lots of natural light and high vaulted ceilings which provide a wonderful sense of space. Eye catching wood look tile floors throughout home with high quality fixtures. The kitchen boasts a fresh modern look with gorgeous granite countertops, beautiful wood cabinets, an island, large pantry for storage and stainless steel appliances. Quality Custom Homes includes higher end fixtures througout the home. The primary bathroom has a very nice shower with a calming spa feel. There is a dedicated laundry room and a beautiful patio. Enjoy the outdoors and minutes away from Sam Houston National Forest and Scotts Ridge Boat Ramp, Stubblefield Lake Recreation Area, Lone Star Hiking Trail, Northwest Trailhead and Big Creek Scenic Area Trail Head. This could be a primary home or a Getaway home to unplug and relax in nature. Don\'t forget about the beautiful Lake Mount Pleasant!','0.1263','39','SJP Capital','','','','No Disclosures','1','','','Lake Conroe Area','Central Electric','1','HIDDEN FOREST EST 04, LOT 126','Subdivision Lot','5500','Appraisal District','','36','1','To Be Built/Under Construction','0','','0','','','','','Composition','37 - Montgomery','LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Hidden Forest Estate 04','270','1.8242','Public Water,Septic Tank','','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','216382692','1675135412','216382692','2023-01-14T13:40:51.497','39385164','Jared Turner','LennarVillageBldr-JaredTurner','','','29.844702','-95.849780','9','77493','7','310000.00','Active','Twilight Green','1440','Drive','Katy','2','0','3','1880','Single-Family','NEW! Lennar Watermill Collection “Knightley” IV Plan with Elevation “A” in Sunterra! This single-story home has everything needed right on one floor with three bedrooms, a study and an open living area. Two bedrooms share a bathroom in the hall at the front of the home, beside the versatile study. Adjacent is the open concept living area with access to a covered porch, while the owner’s suite is tucked into the back corner for maximum privacy. Virtual tour is a representation of the floor plan, not the actual home. *Estimated Completion February 2023*','','26','Lennar Homes','','','','Mud,Other Disclosures','','','','Katy - Old Towne','Central Gas','1','SEC 0014 BLK 001 LOT 011','Subdivision Lot','','','','1200','1','To Be Built/Under Construction','2','','0','','','','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Sunterra','','3.54','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','216397777','1675135412','216397777','2023-01-14T13:20:40.610','67626297','Deborah Burr','Berkshire Hathaway HomeServices Premier Properties','','','29.481715','-95.245852','27','77511','9','1350000.00','Active','Highway 35','19927','','Alvin','4','1','4','2951','Single-Family','The main home is a spacious 2,951sf with 2 primary rooms, 1 up, 1 down. Most bedrooms have their own ensuite bathroom. The upstairs primary room has another room adjacent that could be used as a 2nd family room or bedroom. Downstairs has a few areas for entertaining, large family room, & 2 large areas that could be used as game rooms, media rooms, separate kid\'s area, or offices. Thinking of using the property as a business space, open up the downstairs for offices, keeps the upstairs for a living area. With over 14 acres of land, the property could be a great home to your AG needs, horses, goats, cattle and/or lease out the stables for added revenue. Other possibilities could be to develop the back 14 acres into storage, riding lessons or another business option. Highway 35 offers substantial daily traffic counts to support a solid business. This property is an open slate for your home improvement designs, a creative business endeavor or both. Exclusions: Portable Tack Room by Barn.','14.0745','5','','','','','Sellers Disclosure','1','','0','Alvin North','Central Electric,Propane','0','A0595 H STEVENS TRACT 1C2-1C2A-1C3-2C ACRES 14.0745','Cleared','613085','Appraisal District','','','0','','5','Freestanding Oven,Single Oven','0','','','','','Composition','3 - Alvin','MARK TWAIN ELEMENTARY SCHOOL (ALVIN)','ALVIN HIGH SCHOOL','G W HARBY J H','Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Other Style,Traditional','H Stevens','2234','2.118696','Septic Tank,Well','1946','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','216398009','1675135412','216398009','2023-01-14T13:30:13.037','95568083','Santa Creado','RE/MAX 5 Star Realty','','','29.706354','-95.297140','25','77087','5','250000.00','Active','Keller','6823','Street','Houston','1','0','3','1020','Single-Family','Great Starter Home!! This home has 3 bedrooms, 1 bath and 1 car garage. Throughout the house you will see Hardwood flooring, tile and carpet in the bedrooms. There\'s a shed at the back of the house for extra storage space. Enjoy the convenience of easy access to major freeways and just mins away from Downtown.','0.1263','4','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','0','','','East End Revitalized','Central Gas','0','LT 3 BLK 103 PECAN PARK R/P','Subdivision Lot','5500','Appraisal District','','','0','','1','Gas Oven','0','','','Freestanding Range','','Composition','27 - Houston','SOUTHMAYD ELEMENTARY SCHOOL','MILBY HIGH SCHOOL','DEADY MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Pecan Park R/P','2670','2.3307','Public Sewer,Public Water','1951','Appraisal District'); --> New record created successfully