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-05T18:51:29.293' ,`MLSNumber` = '13263224' ,`ListAgentFullName` = 'Toke Ettehadieh' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766021' ,`Longitude` = '-95.493857' ,`PhotoCount` = '45' ,`PostalCode` = '77024' ,`RoomCount` = '28' ,`ListPrice` = '9250000.00' ,`Status` = 'Active' ,`StreetName` = 'Hunters Trail' ,`StreetNumber` = '346' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '8' ,`BathsHalf` = '2' ,`BedsTotal` = '7' ,`SqFtTotal` = '10050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Custom Built Masterpiece situated on a quiet cul-de-sac, ravine lot in Prestigious Hunterwood. The residence boosts 10,000+ sq ft w/7 Bedrooms, 8.5 Baths, Elevator & Resort Style backyard Oasis. Gourmet Kitchen w/Marble Center Island/Waterfall Edges opens to the Breakfast Nook, Family & Living areas. Twelve-inch Hardwood Maple Flooring throughout w/Italian Marble at Foyer. Primary Retreat features Fireplace, Adjoining Room (Workout Room, Nursery or Additional Study), Luxurious Stand-Alone Shower & Tub, His & Her Vanities & Custom His/Her Walk-In Closets. First Level also featuring Dining, Family Room, Butler’s Pantry, Wine Room, Library & Guest Suite w/Kitchen. Second Level Kitchenette serves 5 Bedrooms (All En-Suite Baths), Game Room & Theater. A Balcony w/Surround Sound & Slate Flooring overlooks the Backyard Oasis. Heated Fresh Water Pool & Jacuzzi, Surround Sound, Mosquito Control System, Rail-less Glass Railing & a 2,100 sq ft Decking encompass this Exquisite Backyard.' ,`Acres` = '0.7941' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 3 HUNTERWOOD R/P' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Wooded' ,`LotSize` = '34591' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HUNTERS CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Hunterwood R/P' ,`TaxAmount` = '51300' ,`TaxRate` = '2.1111' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675105224' WHERE `Matrix_Unique_ID` = '211305762' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-05T18:26:14.123' ,`MLSNumber` = '95980307' ,`ListAgentFullName` = 'Veronica Mendoza' ,`ListOfficeName` = 'Veronica Mendoza Realty, LLC.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.685209' ,`Longitude` = '-95.710137' ,`PhotoCount` = '32' ,`PostalCode` = '77407' ,`RoomCount` = '7' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Vista Hills Dr' ,`StreetNumber` = '8619' ,`StreetSuffix` = '' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Juneberry plan delivers a home designed for entertaining. The center third of the home functions as one large integrated space for cooking, dining and socializing. The kitchen design is perfect for casual and formal occasions open-plan to the family room perfect for entertaining. The owner\'s bedroom at the back of the home is separated from the guest bedrooms located on the opposite side of the home.' ,`Acres` = '0.148' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND VISTA SEC 13, BLOCK 1, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6467' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105224' WHERE `Matrix_Unique_ID` = '213004992' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-05T17:39:34.907' ,`MLSNumber` = '12784458' ,`ListAgentFullName` = 'Gina Thayer' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.965645' ,`Longitude` = '-95.578402' ,`PhotoCount` = '32' ,`PostalCode` = '77070' ,`RoomCount` = '6' ,`ListPrice` = '324000.00' ,`Status` = 'Active' ,`StreetName` = 'Mills River' ,`StreetNumber` = '13159' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2317' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated well maintained home on a quiet cul-de-sac! Sellers are original owners. Featuring new plumbing throughout (2021), new downstairs flooring and paint, kitchen and bath cabinets and gorgeous quartz countertops, appliances, including compactor. QUIET dual Lennox energy-efficient HVAC system. Sprinkler system.' ,`Acres` = '0.202' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 155 BLK 5 MILLS WALK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MATZKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mills Walk' ,`TaxAmount` = '5063' ,`TaxRate` = '2.4817' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675105224' WHERE `Matrix_Unique_ID` = '213197961' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-05T17:47:59.460' ,`MLSNumber` = '55974062' ,`ListAgentFullName` = 'Ashwin Kewalramani' ,`ListOfficeName` = 'New Age' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799042' ,`Longitude` = '-95.352138' ,`PhotoCount` = '7' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '419990.00' ,`Status` = 'Active' ,`StreetName` = 'Malvern' ,`StreetNumber` = '1604' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1938' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Malvern Modern is located in the heart of Hardy Yards. Just 5 minutes from downtown Houston, these 3 story modern residences are the definition of city living. Each home has a private driveway, high ceilings and designer finishes. Malvern Modern’s interior finishes were selected to showcase true luxury. The difference is shown through superior craftsmanship and Arcada’s acclaimed floor plan. Contract before the home is complete and Arcada Homes will provide hardwood floors throughout along with ceiling fans in each room. Estimated completion date is mid February 2023.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Arcada Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'NA' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOOSCAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Ryon' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675105224' WHERE `Matrix_Unique_ID` = '214196316' --> 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','215209182','1675105225','215209182','2023-01-05T17:32:46.807','87923549','Tammy Longdon','Coldwell Banker RealtyThe Willis Office','','','30.289345','-95.166342','50','77328','8','249900.00','Active','LOST MAPLES','10639','Drive','Cleveland','2','0','3','1658','Single-Family','BEAUTIFUL THREE BEDROOM, TWO BATHROOMS AND OFFICE/FLEX ROOM/4TH BEDROOM WITH FRENCH GLASS DOORS, LOCATED IN PINEWOOD TRAILS IN CLEVELAND; NO MUD; AMENITIES INCLUDE: COMMUNITY PARK, SPLASH PAD, PICNIC AREA, POND W/FOUNTAINS; WALKING TRAIL AND MORE; THE KITCHEN FEATURES A BREAKFAST ISLAND, GRANITE COUNTERTOPS, AND OPEN CONCEPT TO THE DINING ROOM AND LIVING ROOM; PRIMARY ENSUITE WITH LARGE GARDEN BATHTUB, SEPARATE STAND-UP SHOWER AND HUGE WALK IN CLOSET; COVERED BACK PATIO AND FENCED BACK YARD. THE HOME IS BUILT BY LGI HOMES AND IS THE SABINE HOME. THIS HOME HAS PROGRAMMABLE THERMOSTAT, USB COMPATIBLE OUTLET IN THE KITCHEN AND WI-FI ENABLED GARAGE DOOR OPENER AS WELL AS ENERGY EFFICIENT FEATURES SUCH AS THE DOUBLE PANED LOW E WINDOWS AND LED LIGHTS. THE (4) CAMERAS ARE EXCLUDED WHICH (3) ARE LOCATED OUTSIDE AND (1) LOCATED INSIDE.','0.1309','40','LGI Homes','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Cleveland Area','Central Electric','1','S800200 - PINEWOOD TRAILS 01, BLOCK 10, LOT 25','Subdivision Lot','5704','Appraisal District','','348','0','','2','Electric Oven','0','','','Electric Range','','Composition','47 - Splendora','GREENLEAF ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Builder','1','Traditional','Pinewood Trails 01','6825','2.8333','Public Sewer,Public Water','2021','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','215769021','1675105225','215769021','2023-01-05T18:39:45.097','32894816','Robert Moore','Perry Homes Realty, LLC','','','30.070456','-95.724503','18','77377','8','449900.00','Active','Belmont Stakes','19322','Way','Tomball','3','0','4','2438','Single-Family','PERRY HOMES NEW CONSTRUCTION! Entry welcomes with 12-foot ceiling. Game room and formal dining room frame coffered extended entry. Kitchen and morning area open to spacious family room with cast stone mantel fireplace and wall of windows. Kitchen features corner walk-in pantry and inviting island with built-in seating space. Primary suite includes dual vanity, garden tub, separate glass-enclosed shower and large walk-in closet in primary bath. All bedrooms feature walk-in closets. Extended covered backyard patio. Overhead garage.','','35','Perry Homes','','','','Mud,Other Disclosures','1','','1','Tomball Southwest','Central Gas','1','Lot 17, Block 2','Subdivision Lot','6500','Unknown','','975','1','To Be Built/Under Construction','2','Electric Oven','0','','','','','Composition','53 - Tomball','GRAND OAKS ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','GRAND LAKES JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment','Builder','1','Traditional','Amira','','3.49254','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','216068910','1675105225','216068910','2023-01-05T18:31:47.780','37701175','Traye Wise','RE/MAX Signature','','','29.459283','-94.620663','33','77650','8','795000.00','Active','Shrimp','2215','','Port Bolivar','4','0','4','1700','Single-Family','2023 Built - Beautiful New Custom Home near community private beach access with beach view, Unique 4 Bedrooms and 4 full Bathrooms, 2 Primary bedrooms and spacious open concept - Living, Dining and Island Kitchen with 12 ft high ceilings, crown molding, luxury vinyl plank flooring and stainless appliances. Chefs Island Kitchen has plenty of custom cabinets and room for 2 full size refrigerator/freezer - great for entertaining family and friends. Each Bedroom has large walk-in closets with custom cabinet/shelving. Truly a stunning home in the making. Home near Big Store, Restaurants and Shopping. Let this be the next place you call home!','0.154','33','Wise-Palmer','','Electric Dryer Connections,Washer Connections','','Owner/Agent','','','0','Crystal Beach','Central Electric','0','ABST 65 B FRANKS SUR LOT 32 BEAUMONT DRIVE SUB','Subdivision Lot','6708','Appraisal District','','','1','To Be Built/Under Construction','1','Electric Oven','0','','','Electric Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Lockbox Front','Builder','1','Traditional','Beaumont Drive Sub','540','1.6113','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','216093618','1675105225','216093618','2023-01-05T17:56:20.830','82937567','Alba Guzman','Jane Byrd Properties INTL.','','','29.844896','-94.980316','13','77521','2','345000.00','Active','Fm 1942','5611','Road','Baytown','1','0','2','960','Single-Family','If you are looking for a property with no restrictions, land and great location...this is the property for you!! \r\nalmost 3 Acres of land, partial wooded and a house with great bones if you want to have a project to work on.\r\nlet me know if you need a tour.','2.74','1','','','','','Sellers Disclosure','','','','Crosby Area','No Heating','0','TR 4 ABST 54 H NASH','Cleared,Wooded','119354','Appraisal District','','','0','','1','','0','','','','','Composition','12 - Crosby','DREW ELEMENTARY SCHOOL','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Accompany,Appointment Required','Appraisal District','1','Traditional','Hannah Nash League','3201','2.0766','Septic Tank,Well','1940','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','216105782','1675105225','216105782','2023-01-05T17:11:34.697','87105679','Adriana Banks','Douglas Elliman Real Estate','','','29.765244','-95.468877','36','77056','17','5299000.00','Active','Green Tree','5215','Road','Houston','6','2','6','9646','Single-Family','Enjoy exceptional indoor-outdoor living and entertaining in this stunning estate in Tanglewood area(Pine Shadows) featuring bespoke craftsmanship and premium finishes. Soaring ceilings, designer lighting and gleaming marble and ceramic floors. A grand formal living room and dining/family open room share a stone fireplace, and the work-of-art kitchen boasts double islands, custom cabinetry and a fleet of state-of-art stainless-steel appliances. A powder room, oversized closets and a bar area make gracious entertaining effortless. The massive family room opens to a backyard oasis with a covered pavilion, summer kitchen, staff rooms, gym, office, luxurious secondary bedroom suites and storage. Elevator, Creston controls, generator, integrated speakers, alarm and more. Circular drive and 3-car garage with EV charging. Ideal location close to Memorial Park and Galleria. Must see!','','22','Davis','','','','Sellers Disclosure','1','Gaslog Fireplace','1','Tanglewood Area','Central Gas,Zoned','1','LT 19 BLK 2 BAYOU GLEN','Other','14076','Appraisal District','','1100','0','','3','Gas Oven','1','Heated,In Ground','','Gas Range','','Tile','27 - Houston','BRIARGROVE ELEMENTARY SCHOOL','WISDOM HIGH SCHOOL','TANGLEWOOD MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','3','Contemporary/Modern,Mediterranean,Spanish','Pine Shadows','','','Public Sewer,Public Water','2016','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','216110656','1675105225','216110656','2023-01-05T18:11:01.220','71494820','Kimberly Weddel','Texas United Realty','','','29.776650','-95.353616','41','77009','6','350000.00','Active','Harrington','1401','Street','Houston','1','0','2','840','Single-Family','Just minutes from Downtown Houston in a Historic Neighborhood. This 2/1/2 home has so many possibilities. Take advantage of purchasing in an upcoming neighborhood. This property offers a home on a corner lot with 2 driveway access and a larger lot. There are 2 covered parking areas; one on each side of the property. The detached garage has electricity and plumbing for a sink and commode. You could easily make the garage a second home with it\'s own entrance and driveway. The home has an enclosed front porch, good sized living room, dining, kitchen, and two bedrooms with a hollywood bath. Home has central heating and a/c and is nice and livable although many are coming in and building 2 and 3 story homes. A great corner lot and a great investment property. Enjoy being close to the Texas Medical Ctr, Discovery Green, Museums,Zoo, and so much more. Near freeways and Monorail. Such a great investment!','0.0788','9','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','','0','Northside','Central Gas','0','TRS 27 & 28A BLK 9 CASCARA','Corner,Subdivision Lot','3431','Appraisal District','','','0','','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','27 - Houston','SHERMAN ELEMENTARY SCHOOL','NORTHSIDE HIGH SCHOOL','MARSHALL MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Cascara','1999','2.3307','Public Sewer,Public Water','1920','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','216112711','1675105225','216112711','2023-01-05T17:42:19.263','12701856','Matthew Guzman','RE/MAX Universal','','','29.453885','-95.303118','25','77511','11','478010.00','Active','Riesling','402','Drive','Alvin','3','1','4','3360','Single-Family','SEE SAMPLE 3D INTERACTIVE VIRTUAL TOUR! Welcome home to this beautiful Cambridge floor plan with 4 Bedroom, 3 1/2 Bath, with a 3 CAR GARAGE. SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room with wood burning Fireplace, Kitchen, Dining Room, Living Room and a Master Bedroom with large walk-in closets downstairs. Upstairs you will find a Game Room, 3 Bedrooms, full bath, and a Hollywood Bath. 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','Wood Burning Fireplace','1','Alvin North','Central Gas','1','MARTHAS VINEYARD SEC 3 (A0230 HT&BRR) BLK 1 LOT 26','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','Traditional','Martha\'s Vineyard','1987','3.7074','Public Sewer,Public Water','2022','Builder'); --> New record created successfully