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-03T17:43:34.987' ,`MLSNumber` = '46393367' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.842858' ,`Longitude` = '-94.828076' ,`PhotoCount` = '10' ,`PostalCode` = '77523' ,`RoomCount` = '11' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Augusta' ,`StreetNumber` = '14819' ,`StreetSuffix` = 'Avenue' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2721' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW CONSTRUCTION by Lennar Homes, Wildflower Collection \'\'Dewberry II\" Elevation \"A\" in South Lakes! This spacious two-story home offers an inviting foyer that flows into the family room with an adjoining breakfast nook. The open kitchen features bar seating and overlooks the family room. Nearby is the owner’s suite which includes an en suite bathroom and a large walk-in closet. Upstairs are more bedrooms, bathrooms and a game room.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0001 BLK 005 LOT 002' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'South Lakes' ,`TaxAmount` = '' ,`TaxRate` = '2.309' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101160' WHERE `Matrix_Unique_ID` = '211863667' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T18:20:53.333' ,`MLSNumber` = '95721973' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.484159' ,`Longitude` = '-95.362552' ,`PhotoCount` = '13' ,`PostalCode` = '77578' ,`RoomCount` = '6' ,`ListPrice` = '409900.00' ,`Status` = 'Active' ,`StreetName` = 'Eliot' ,`StreetNumber` = '5010' ,`StreetSuffix` = 'Place' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Home office with French doors set at entry with 11-foot ceiling. Open kitchen offers center island and corner walk-in pantry. Dining area is adjacent to open family room with wall of windows. Spacious primary suite. Dual vanities, garden tub, separate glass-enclosed shower and large walk-in closet in primary bath. Secondary bedrooms include walk-in closets. Mud room off overhead garage.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Meridiana Lot 1,Blk 2, Section 48B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8258' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101160' WHERE `Matrix_Unique_ID` = '214931772' --> 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','215356397','1675101160','215356397','2023-01-03T17:45:20.517','15989056','Rosa Contreras','RE/MAX Signature','','','30.019363','-95.477039','13','77068','4','395000.00','Active','Encreek','2507','Road','Houston','2','1','4','2933','Single-Family','NO SHOWINGS UNTIL JAN 13TH Stop the search, Come live among the trees! Recently renovated home located in a forest like setting is turn-ley ready for move in. An open concept floor plan greets you as you enter. Updated flooring & a neutral color scheme throughout the property will make decorating a breeze. Vaulted ceilings & sky lights provide vast amounts of light. Fresh cabinetry in the kitchen provides massive amounts of storage & stone countertops offer ample space for all your small appliances. The master suite in equipped with a spa like bathroom retreat & the additional three bedrooms have fresh carpeting. A second bath also gives easy access to the additional living spaces. An expansive driveway provides ample parking & the backyard is large enough to give the kids plenty of space for fun activities. Easy access to I-45 North & FM 1960. Book your viewing today. . Call the listing agent for more questions to schedule a privet showing. Room dimensions are approximate','0.4408','13','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','','','1','1960/Cypress Creek North','Central Electric,Central Gas','0','LT 281 BAMMEL FOREST SEC 3','Cleared','19200','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Cooktop','','Composition','48 - Spring','PONDEROSA ELEMENTARY SCHOOL','WESTFIELD HIGH SCHOOL','EDWIN M WELLS MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','1','Traditional','Bammel Forest','7188','2.0892','Public Water,Septic Tank','1972','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','215565136','1675101160','215565136','2023-01-03T17:13:27.437','47525951','Katherine Haydel','New Key Properties','','','29.694653','-95.305897','30','77087','6','475000.00','Active','Roe','3171','Drive','Houston','3','0','6','3634','Single-Family','Location, location, location! Here\'s a great opportunity to own a completely remodeled home within the loop with easy access to downtown, the medical center, 45 AND the 610 Loop! This charming home offers 4 bedrooms/ 2 full bathrooms and a double car garage that could fit four cars on an oversized lot. Large enclosed patio. Enjoy recent improvements like the NEW roof, recently replaced AC, paint carpet, kitchen just to name a few! Garage apartment is perfect for a home business with two bedrooms, full bath, and kitchen OR rental income! Schedule your tour today!','0.2355','3','','','','','No Disclosures','','','1','Hobby Area','Central Electric','0','LT 1 BLK 5 ROE SEC 2','Subdivision Lot','10260','Appraisal District','','','0','','4','','0','','','','','Composition','27 - Houston','SEGUIN ELEMENTARY SCHOOL (HOUSTON)','STERLING HIGH SCHOOL (HOUSTON)','HARTMAN MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Other Style','Roe Sec 02','5880','2.3307','Public Sewer,Public Water','1955','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215680728','1675101160','215680728','2023-01-03T17:02:42.237','51244042','Binh Vo','RE/MAX Universal Northwest','','','29.955302','-95.602292','6','77429','6','230000.00','Active','Cypress Crossing','12507','Drive','Cypress','2','1','3','1372','Single-Family','Investors special!!! Drive By Only Tenants Occupied, Showing will be allowed when the contract accepted). Great Location!!!This Double-wide mobile home sits on a roughly 1/2-acre lot with great setting of a variety of trees. It\'s an ideal location for those who love country living in the city. It\'s minutes from TX 249 & 290 Northwest Fwy. Located in Cypress Fairbank ISD.','0.54','10','','','','','Sellers Disclosure','1','','','Cypress North','Central Electric','0','TR 44 CYPRESS CROSSING M/H PARK U/R ABST 788 T TOBY','Cleared','23522','Appraisal District','','','0','','2','Electric Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS CREEK HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required','Appraisal District','1','Other Style','Cypress Crossing M/H Park','2937','2.1637','Aerobic,Public Water,Septic Tank','1971','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','215996714','1675101160','215996714','2023-01-03T17:02:47.510','71616937','Tai Saba','Saba Group Realty Company','','','29.670242','-95.325713','13','77033','8','150050.00','Active','Glenhurst','6054','Street','Houston','1','1','4','1815','Single-Family','This is a one-story house, Again, a perfect investment property for an investor or any individual that will buy fix and flip. THIS PROPERTY IS (AS IS) SPECIAL CASH DEAL OR INVESTOR ONLY OR BUILDER.','0.1738','3','','','','','No Disclosures,Seller may be subject to foreign tax and Buyer withholding per IRS','','','','Medical Center South','Other Heating','0','LT 14 BLK 30 EDGEWOOD SEC 6','Subdivision Lot','7569','Appraisal District','','','0','','0','','0','','','','','Wood Shingle','27 - Houston','ALCOTT ELEMENTARY SCHOOL','STERLING HIGH SCHOOL (HOUSTON)','ATTUCKS MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Contemporary/Modern','Edgewood Sec 06','2991','2.3307','Public Sewer,Public Water','1952','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216029078','1675101160','216029078','2023-01-03T17:09:31.833','58705188','Heather McClain','Connect Realty','','','29.698543','-94.940987','9','77523','5','189900.00','Active','Gulls Cut','130','','Baytown','2','0','3','1300','Single-Family','FISHING COMMUNITY!!! ***COMES WITH 2 LOTS*** Great opportunity to purchase this gem of a home!!! Brand new construction! Very few items are left to complete this home and you have the option to pick out the final colors of the remaining floors that need to be finished on this home. The location is prime for those who love the water. Make this your weekend getaway or your everyday escape. More pics to come soon! \r\n***THIS COMMUNITY INCLUDES A POOL TO ENJOY IN THE SUMMERTIME. HOA INCLUDES A COMMUNITY BUILDING WITH A PAVILION THAT CAN BE RENTED FOR GATHERINGS. THERE IS ALSO A COMMUNITY PIER LOCATED ACROSS FROM ANGELFISH ROAD WHICH IS JUST A FEW BLOCKS AWAY FROM THE HOME. IT\'S LIT UP FOR NIGHT FISHING.','0.0723','2','Pablo Villa','','','','Sellers Disclosure','','','','Baytown/Harris County','Central Electric','1','LT 45 BLK 3 BAY OAKS HARBOR AMENDED','Cleared,Subdivision Lot','3150','Appraisal District','','35','1','To Be Built/Under Construction','0','','0','','','','','Composition','23 - Goose Creek Consolidated','LORENZO DE ZAVALA ELEMENTARY SCHOOL (GOOSE CREEK)','LEE HIGH SCHOOL (GOOSE CREEK)','HORACE MANN J H','Accompany,Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Bay Oaks Harbor Amd','4995','2.97','Public Sewer,Public Water','2020','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','216031715','1675101161','216031715','2023-01-03T17:48:07.947','6396437','Sapramjeet Singh','SJS International LLC','','','29.829939','-95.406692','7','77018','5','625000.00','Active','Sikes','440','Street','Houston','2','0','3','1224','Single-Family','Investors/Builders look no further. Oversized lot in up and coming neighborhood accessible to major freeways 610 and I45, minutes from downtown. Potential for 2-3 townhomes. Do your due diligence. Many new homes being built nearby.','0.1873','9','','','','','No Disclosures','','','','Northwest Houston','Other Heating','0','TRS 8 & 8A BLK 10 OAKRIDGE','Subdivision Lot','8160','Appraisal District','','','0','','','','0','','','','','Composition','27 - Houston','KENNEDY ELEMENTARY SCHOOL (HOUSTON)','WASHINGTON HIGH SCHOOL','WILLIAMS MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Oakridge','4748','2.3307','Public Sewer,Public Water','1947','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','216034875','1675101161','216034875','2023-01-03T17:56:27.283','43837801','Matthew Guzman','RE/MAX Universal','','','29.384571','-95.247552','13','77511','8','349910.00','Active','Riesling','330','Drive','Alvin','2','0','3','1848','Single-Family','SEE SAMPLE 3D VIRTUAL TOUR!!! Beautiful Wetherby Floor Plan, 1 Story, 3 Bedroom, 2 Bath, with a 2 Car Garage. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN and HIGH CEILINGS with the Family Room, Kitchen, Breakfast Room, Home Office and 3 Bedrooms with 2 full Baths. Carpet & Tile throughout. You will love the Kitchen with lots of cabinets and granite countertops with under the cabinet lighting, stainless steel appliances, and even a USB outlet. Fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, Hot & Cold Pex Plumbing System, Rheem® Tankless Gas Water Heater and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. Martha’s Vineyard, located just northwest from the intersection of Highway 6 and CR-46 spanning over 100 acres. The new development will offer residents two large lakes, playgrounds, and splash pad. Call today!!!!','0.1791','5','Anglia Homes','','Electric Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','','','Alvin South','Central Gas','1','MARTHAS VINEYARD SEC 3 (A0230 HT&BRR) BLK 1 LOT 27','Subdivision Lot','7802','Appraisal District','','550','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','3 - Alvin','WALT DISNEY ELEMENTARY SCHOOL','ALVIN HIGH SCHOOL','ALVIN JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card','Builder','1','Ranch','Martha\'s Vineyard','1987','3.7074','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216034974','1675101161','216034974','2023-01-03T17:56:58.337','21504777','Alicia Richards','GoUpRE','','','29.807983','-95.518679','50','77080','3','370000.00','Active','Bauer','2009 E','Drive','Houston','3','1','3','1644','Single-Family','Built by Award Winning Custom Builder, Legion Custom Home Builders. This community will consist of 22 homes with the perfect floor plan to fit your lifestyle. All homes are 3 stories, 3 bedrooms, with 3.5 bathrooms. Phase I has begun construction and expected completion date is Mid-End September! Phase II has begun construction and expected completion date is Mid-End November! These homes feature natural light through oversized windows and high ceilings. Large primary suite has a walk-in closet, double vanity, and an oversized shower. The open kitchen has a large island, quartz counter tops, cabinetry with plenty of storage space and stainless steel appliances. Easy access to CityCentre, Heights and Galleria. Low HOA & tax rate.','','24','Legion Custom Home B','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Special Addendum','1','','','Spring Branch','Central Gas','1','Lot 21 Block 1 Bauer Grove','Subdivision Lot','1333','Survey','','1600','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop','','Composition','49 - Spring Branch','BUFFALO CREEK ELEMENTARY SCHOOL','SPRING WOODS HIGH SCHOOL','SPRING WOODS MIDDLE SCHOOL','Accompany,Appointment Required','Builder','3','Traditional','Bauer Grove','','','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216036146','1675101161','216036146','2023-01-03T18:44:22.800','51031625','Matthew Guzman','RE/MAX Universal','','','29.452081','-95.299131','17','77511','10','437005.00','Active','Malbec','23423','Drive','Alvin','3','1','4','2653','Single-Family','SEE SAMPLE 3D INTERACTIVE VIRTUAL TOUR! Beautiful Winchester floorplan with 4 Bedroom, 3 1/2 Bath, with 3 Car Garage. SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Dining Room, Half Bath and the Master Suite downstairs. Upstairs you will find a Game Room, 2 Bedrooms, Guest Bedroom with ensuite Bath and another Full Bath. You will love the Kitchen cabinets and granite countertops with under the cabinet lighting, stainless steel appliances, and even a USB outlet. COVERED PATIO with fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, Pex Hot & Cold Water Lines, Rheem® High Efficient Tankless Gas Water Heater, Radiant Barrier, and Low E Windows that open to the inside of the home for Cleaning. Martha’s Vineyard will offer residents two large lakes, playgrounds, and splash pad. Alvin ISD. Convenient to Hwy. 6, Hwy 288, and Beltway 8. Get your private tour today!!!','0.1791','5','Anglia Homes','','Electric Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','','','Alvin North','Central Gas','1','MARTHA\'S VINEYARD SEC 3 (A0230 HT&BRR) BLK 1 LOT 6','Subdivision Lot','7802','Appraisal District','','550','1','Never Lived In','3','Gas Oven','0','','','Gas Range','','Composition','3 - Alvin','HOOD-CASE ELEMENTARY SCHOOL','ALVIN HIGH SCHOOL','G W HARBY J H','Appointment Required,Leave Business Card','Builder','2','Traditional','Martha\'s Vineyard','1987','3.7074','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216036258','1675101161','216036258','2023-01-03T18:53:33.277','16893123','Matthew Guzman','RE/MAX Universal','','','29.451599','-95.298552','7','77511','9','448985.00','Active','Riesling','406','Drive','Alvin','3','0','4','2492','Single-Family','SEE SAMPLE 3D VIRTUAL TOUR! Welcome home to your beautiful Gloster Floor Plan 1 1/2 Story, 4 Bedroom, 3 Bath, with an attached 3 Car Garage. This floor plan boasts High Ceilings and a Spacious OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Formal Dining Room and 4 spacious bedrooms. This home also has the upgraded half story with Media Room and 3rd Bathroom. Tile and Carpet throughout. Comes with COVERED PATIO and fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, Pex Hot & Cold Water Lines, Rheem® High Efficient Tankless Gas Water Heater, Radiant Barrier, and Low E Windows that open to the inside of the home for Cleaning. Martha’s Vineyard will offer residents two large lakes, playgrounds, and splash pad. Alvin ISD. Convenient to Hwy. 6, Hwy 288, and Beltway 8. Get your private tour today!!!','0.1791','5','Anglia Homes','','Electric Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','','','Alvin North','Central Gas','1','MARTHAS VINEYARD SEC 3 (A0230 HT&BRR) BLK 1 LOT 25','Subdivision Lot','7802','Appraisal District','','550','1','Never Lived In','3','Gas Oven','0','','','Gas Range','','Composition','3 - Alvin','HOOD-CASE ELEMENTARY SCHOOL','ALVIN HIGH SCHOOL','G W HARBY J H','Accompany,Appointment Required,Leave Business Card','Builder','2','Ranch,Traditional','Martha\'s Vineyard','1987','3.7074','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully