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-31T01:22:33.097' ,`MLSNumber` = '66818177' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = 'Monica Darr' ,`SellingOfficeName` = 'American Realty' ,`Latitude` = '29.035607' ,`Longitude` = '-95.419197' ,`PhotoCount` = '35' ,`PostalCode` = '77531' ,`RoomCount` = '9' ,`ListPrice` = '360000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Meadow Ridge' ,`StreetNumber` = '101' ,`StreetSuffix` = 'Way' ,`City` = 'Clute' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2851' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Woodshore! This is a beautiful 4 bedroom, 2.5 bathroom home with 2 living areas, media room and a screened in patio. The spacious kitchen opens up to the living room, making entertaining easy. Plenty of counter and cabinet space and an island. The primary room is down stairs with plenty of natural lighting. The master bathroom has double sinks, a separate shower and a soaker tub with a big walk-in closet. Enjoy all the space this home has to offer. Call today for your private showing.' ,`Acres` = '0.1868' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clute' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WOODSHORE SEC 1 (A0066 J E GROCE) (CLUTE) BLK 11 LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8137' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'POLK ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodshore' ,`TaxAmount` = '8400' ,`TaxRate` = '2.6231' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266574' WHERE `Matrix_Unique_ID` = '209594856' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T01:37:55.723' ,`MLSNumber` = '33163947' ,`ListAgentFullName` = 'Johnathan Canizalez' ,`ListOfficeName` = 'Gold Quest Realty- Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.687620' ,`Longitude` = '-95.435398' ,`PhotoCount` = '6' ,`PostalCode` = '77025' ,`RoomCount` = '12' ,`ListPrice` = '1424995.00' ,`Status` = 'Active' ,`StreetName` = 'Linkmeadow' ,`StreetNumber` = '8814' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4539' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'S/V Development has done it again regarding elevating how we should live. This new Construction modern contemporary home is located in the sought-after neighborhood of Linkwood. This is a 5 bedroom, 6 full bath and a 4 car garage home. From the street you are greeted, with 9ft double steel front door and sleek garage doors; talk about curb appeal. Upon entry you are welcomed with beautiful engineer-wood floors and high ceiling. Your new kitchen is like a chef\'s dream, with high grade appliances, custom cabinetry and beautiful quartz countertops to complement the rest of the house. Living room is a spacious size, with plenty of space for entertaining. Downstairs also offers a flex room/home office/wet bar/elevator. Primary room is a generous size; walking into your bathroom is like walking into your own private oasis, walk in shower and soaking tub. The rest of the bedrooms and media room are down the hallway. Home also offers 410 SF of cover patio. Please call for additional info.' ,`Acres` = '0.2169' ,`Area` = '17' ,`BuilderName` = 'SV-Development' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Knollwood/Woodside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 BLK 7 LINKWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LONGFELLOW ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Linkwood' ,`TaxAmount` = '6656' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266574' WHERE `Matrix_Unique_ID` = '210435371' --> 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','215991104','1675266575','215991104','2023-01-31T02:19:58.857','82015252','Yvonne Cazares','The Monarch Team, LLC','','','29.789053','-95.551575','42','77043','4','486000.00','Active','Shadeland','1115','Drive','Houston','3','0','4','1979','Single-Family','Welcome to 1115 Shadeland, newest renovated home on the block! Located in Wildewood Forest Subdivison!You have upscale shopping & dining within close proximity.Your home features stunning quality & attention to detail, you will love the open and inviting concept floor plan,natural light galore, spacious rooms & more! Home was fully renovated, including new roof, plumbing, flooring, windows, new appliances, electrical box and many more upgrades throughout the home. Layout is prefect for entertaining as it connects the living, dining, & kitchen flawlessly. Private fenced property & an attached 2 vehicle garage! The perfect home with plenty of space to live, work, or entertain!','0.1958','24','','','Gas Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','','','Spring Branch','Central Electric,Central Gas','0','LT 18 BLK 5 WILDEWOOD FOREST SEC 2','Subdivision Lot','8530','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','49 - Spring Branch','SHADOW OAKS ELEMENTARY SCHOOL','SPRING WOODS HIGH SCHOOL','SPRING OAKS MIDDLE SCHOOL','Appointment Required','Seller','1','Colonial','Wildewood Forest','6185','2.4415','Public Water','1961','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','216168711','1675266575','216168711','2023-01-31T01:22:33.097','80537432','Andrea Kitzmann','Keller Williams Realty','','','30.178247','-96.401268','35','77833','11','465000.00','Active','Park','1209','Street','Brenham','2','1','4','2730','Single-Family','At last! The home of YOUR dreams is awaiting new owners. Situated on a spacious corner lot, minutes to Historic Downtown Brenham, this is one you don\'t want to miss. This stately 4 bed, 2.5 bath home offers 2,730 of indoor living space plus a rooftop deck. Prepare to fall in love and be WOW’d. Brand new electrical, plumbing, flooring, paint, and lighting throughout make this home feel brand new. The HVAC, roof, windows, and water heater are also all brand new! The kitchen features plenty of storage, quartz counters, eating bar, stainless appliances and walk-in pantry. The real show stopper is the primary suite. As you enter this MASSIVE space, you\'ll feel your home is truly a staycation suite with an en-suite bath featuring a frameless shower, stand-alone soaking tub, dual sinks, and a walk-in closet. Head upstairs to find 3 generous sized bedrooms with so many closets and the rooftop terrace - a great space for entertaining. What more could you ask for? Schedule your showing today!','0.3033','58','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Mock Fireplace','1','','Central Gas','0','WASHINGTON TERRACE , BLOCK 12, LOT 1A','Corner','13210','Appraisal District','','','0','','2','Double Oven,Electric Oven','0','','','Electric Cooktop','','Composition','137 - Brenham','BISD DRAW','BRENHAM HIGH SCHOOL','BRENHAM JUNIOR HIGH SCHOOL','Request Online Appointment,Supra Keybox','Appraisal District','2','Traditional','Washington Terrace','','','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','216339406','1675266575','216339406','2023-01-31T01:23:37.520','45459832','Samuel Carratala','eXp Realty, LLC','','','29.799898','-95.420661','19','77008','6','519000.00','Active','16th','1221','Street','Houston','3','1','3','2800','Single-Family','Experience luxury living in the heart of the highly sought-after Shady Acres/ Greater Heights community with these 6 new construction single-family homes offering the perfect blend of urban convenience and suburban tranquility. Enjoy being within walking distance of local eateries, shops, and the White Oak Bayou trail. These 6 homes feature an open-concept living area with hardwood flooring, a gourmet island kitchen, high ceilings, and luxurious finishes. This home has 3 bedrooms, and 3.5 bathrooms, The master suite includes a walk-in closet and spa-like bathroom and an Electric car charging connection in the garage. Don\'t miss out, houses are under construction, estimated completion June-July 2023. Call for details about the community.','','9','Noor ConstructionLLC','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Heights/Greater Heights','Central Gas','0','LT 1 BLK 1 WEST 16TH LANDING','Patio Lot','1789','Appraisal District','','','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','SINCLAIR ELEMENTARY SCHOOL (HOUSTON)','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required','Builder','3','Contemporary/Modern,Traditional','West 16th Landing','','','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','216343862','1675266575','216343862','2023-01-31T01:24:05.350','25975425','Samuel Carratala','eXp Realty, LLC','','','29.799898','-95.420661','19','77008','7','539000.00','Active','16th','1221','Street','Houston','3','1','3','3060','Single-Family','Experience luxury living in the heart of the highly sought-after Shady Acres/ Greater Heights community with these 6 new construction single-family homes offering the perfect blend of urban convenience and suburban tranquility. Enjoy being within walking distance of local eateries, shops, and the White Oak Bayou trail. These 6 homes feature an open-concept living area with hardwood flooring, a gourmet island kitchen, high ceilings, and luxurious finishes. This home has 3 bedrooms, and 3.5 bathrooms, The master suite includes a walk-in closet and spa-like bathroom and an Electric car charging connection in the garage. Don\'t miss out, houses are under construction, estimated completion June-July 2023. Call for details about the community.','','9','Noor ConstructionLLC','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Heights/Greater Heights','Central Gas','0','LT 2 BLK 1 WEST 16TH LANDING','Patio Lot','1851','Appraisal District','','','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','SINCLAIR ELEMENTARY SCHOOL (HOUSTON)','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required','Builder','3','Contemporary/Modern,Traditional','West 16th Landing','','','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','216344864','1675266575','216344864','2023-01-31T01:22:54.063','57521872','Samuel Carratala','eXp Realty, LLC','','','29.799898','-95.420661','19','77008','7','539000.00','Active','16th','1221','Street','Houston','3','1','3','3060','Single-Family','Experience luxury living in the heart of the highly sought-after Shady Acres/ Greater Heights community with these 6 new construction single-family homes offering the perfect blend of urban convenience and suburban tranquility. Enjoy being within walking distance of local eateries, shops, and the White Oak Bayou trail. These 6 homes feature an open-concept living area with hardwood flooring, a gourmet island kitchen, high ceilings, and luxurious finishes. This home has 3 bedrooms, and 3.5 bathrooms, The master suite includes a walk-in closet and spa-like bathroom and an Electric car charging connection in the garage. Don\'t miss out, houses are under construction, estimated completion June-July 2023. Call for details about the community.','','9','Noor ConstructionLLC','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Heights/Greater Heights','Central Gas','0','LT 3 BLK 1 WEST 16TH LANDING','Patio Lot','1851','Appraisal District','','','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','SINCLAIR ELEMENTARY SCHOOL (HOUSTON)','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required','Builder','3','Contemporary/Modern,Traditional','West 16th Landing','','','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','216469438','1675266575','216469438','2023-01-31T02:20:26.530','89113062','Yvonne Cazares','The Monarch Team, LLC','','','29.659507','-95.493751','50','77096','6','524000.00','Active','Sanford','5927','Road','Houston','2','1','3','2352','Single-Family','Welcome to 5927 Sanford! This 3 bedroom/2.5 full bath home is one of the nicest in the area! Sellers took it down to the studs. Those recent (2022) structural/mechanical upgrades include: plumbing with PEX water lines, underground pipes, electric water heater, updated electrical & grounding, new electrical box, windows, roof & HVAC. french drain system, Majority of the home features gorgeous tile floors! The gourmet kitchen boasts beautiful light countertops, 36\"gas cooktop & stainless range hood. Living area is open, spacious, and bright. Separate dining area opens to kitchen and living room. The secondary rooms are spacious with plenty of storage in the closets. Primary suite features, tray ceiling, large walk-in closet, and lots of natural light. Large primary bath has double sinks, and huge shower with bench. Come see this beauty today!','0.1708','20','','','','','Owner/Agent,Sellers Disclosure','1','','','Brays Oaks','Central Electric,Central Gas','0','E 34 FT OF LT 13 & W 28 FT OF LT 14 BLK 159 WESTBURY SEC 5','Subdivision Lot','7440','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','PARKER ELEMENTARY SCHOOL (HOUSTON)','WESTBURY HIGH SCHOOL','MEYERLAND MIDDLE SCHOOL','Appointment Required','Appraisal','1','Traditional','Westbury Sec 05','5324','2.3307','Public Water','1965','Appraisal'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216550067','1675266575','216550067','2023-01-31T01:22:33.097','94216500','Dana Olejniczak','Martha Turner Sotheby\'s International Realty','','','29.970295','-95.182461','50','77346','12','663500.00','Active','Fisher Grove','17511','Lane','Humble','4','1','4','4488','Single-Family','Overlooking one of the serene Beringer Place ponds, this beautiful Eagle Springs home is nestled on a expansive lot sprinkled with mature trees, lush landscaping and a relaxing view from your covered back patio and pool area. Your guest enter a lovely rotunda foyer flanked by a private office and expansive dining room. The warm wood floors are through out the downstairs living areas. This chef\'s kitchen is the heart of the home. With sweeping granite countertops, tons of custom cabinetry and a large breakfast bar, there is enough space for friends and family to gather. An entertainers dream as you step outside to the expansive covered patio to be greeted by the blue Beringer Pond and fountain. Great for catch and release fishing and kayaking for fun. Enjoy the sparkling pool and hot tub with LED Lights that provide a spectacular light show. This is luxury living! Other features are guest bedroom down, huge game room, media room with theater style seating and 2 additional bedrooms.','0.2539','1','MI Homes','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','','Gas Connections','1','Atascocita South','Central Electric','1','LOT 59 BLK 1','Subdivision Lot','11060','Appraisal District','','825','0','','3','Double Oven,Electric Oven','1','Gunite,Heated,In Ground','','Gas Cooktop','','Composition','29 - Humble','ATASCOCITA SPRINGS ELEMENTARY SCHOOL','ATASCOCITA HIGH SCHOOL','WEST LAKE MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Eagle Springs','15631','2.913','Public Sewer,Public Water,Water District','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','216878490','1675266575','216878490','2023-01-31T01:19:36.690','59299476','Ashley Copeland','Pam\'s Home Team','','','29.468598','-95.155245','50','77573','12','705000.00','Active','Misty Trails','1066','Lane','League City','3','1','5','4157','Single-Family','BETTER THAN NEW,this stunning 2-story is completely renovated w/ $100k+ in upscale selections & situated on an oversized 15,230 SF lot! Built by David Weekley Homes,this home offers a functional floor plan w/ 5 bedrooms,3 1/2 baths,study,formal dining,upstairs media/bonus room & huge game room!Fresh paint & plantation shutters throughout,beautiful re-finished wood floors,built-ins,custom lighting,new high-end fixtures & new hardware!All bathrooms updated w/ new Quartz countertops,new toilets & lighted LED faucets!Renovated master bath w/ new flooring,new framed mirror,new tub & a new shower!New,stamped berber carpet upstairs!Remodeled island Kitchen is a chef\'s dream w/ Quartz countertops,new backsplash,SS appliances,butlers pantry & a large breakfast room.Vacay 365 days per year in the backyard oasis,complete w/ waterfall pool,spa,pergola,basketball court&NO REAR NEIGHBORS!3 car garage,cul-de-sac location,golf course community&zoned to excellent schools!Too many upgrades to list!!!','0.3496','33','David Weekley Homes','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','League City','Central Gas','1','MAGNOLIA CREEK SEC 7 (2005) ABST 606, BLOCK 1, LOT 8, ACRES','Greenbelt','15230','Appraisal District','','726','0','','3','Electric Oven','1','In Ground','','Gas Range','','Composition','9 - Clear Creek','GILMORE ELEMENTARY SCHOOL','CLEAR SPRINGS HIGH SCHOOL','VICTORYLAKES INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox','Appraisal District','2','Traditional','Magnolia Creek','10206','1.9062','Water District','2004','Appraisal District'); --> New record created successfully