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-16T23:39:25.913' ,`MLSNumber` = '67971709' ,`ListAgentFullName` = 'Cathy Carter' ,`ListOfficeName` = 'Carter Signature Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.075763' ,`Longitude` = '-95.131467' ,`PhotoCount` = '40' ,`PostalCode` = '77541' ,`RoomCount` = '5' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = 'China Clipper' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Drive' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1450' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Experience the ultimate coastal lifestyle in this beautifully updated canal home on Treasure Island. With a boat lift and water station at your fingertips, you\'ll be able to head out to deep water fishing and return to prepare your catch for dinner. Step inside to find a spacious open floorplan with vaulted ceilings, updated flooring, tiled showers, quartz counters and perfectly decorated furnishings (sold furnished). Enjoy the sunset from the back deck after a day on the water. Treasure Island offers the perfect blend of seclusion and convenience with Galveston just across the bridge, Surfside restaurants and stores down the road, and the beach only a short golf cart ride away. Don\'t miss this rare opportunity, schedule your signature tour today!' ,`Acres` = '0.1148' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Treasure Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TREASURE ISLAND NO 2 (A0029 S F AUSTIN) BLK 4 LOT 3' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '5001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Treasure Island' ,`TaxAmount` = '6270' ,`TaxRate` = '2.3804' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675194914' WHERE `Matrix_Unique_ID` = '212162690' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-17T00:14:54.363' ,`MLSNumber` = '14692321' ,`ListAgentFullName` = 'Vuong-Vu Bui' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.541493' ,`Longitude` = '-95.608329' ,`PhotoCount` = '48' ,`PostalCode` = '77479' ,`RoomCount` = '13' ,`ListPrice` = '1450000.00' ,`Status` = 'Active' ,`StreetName` = 'Rouchel Brook' ,`StreetNumber` = '5426' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '5510' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy luxury living at its finest in this gorgeous Mediterranean villa, located in the gated section of the award-winning Avalon at Riverstone community. This lakeview home truly elevates your everyday living, boasting stunning curb appeal, a thoughtfully designed floorplan w/ the most exquisite interior & exterior features. As you enter the private gateway into the gorgeous courtyard, prepare to be wowed at every turn. This home is grand in every sense of the word yet still feels warm and cozy. Grand foyer, double staircases, soaring ceilings w/ an abundance of natural light, chef’s dream kitchen, plenty of room to spread around w/ 3 beds on each floor plus a formal dining, breakfast area, study, sitting area, game room & media room with a custom bar. Extend your living outside w/ an extended covered patio, paved-in yard, outdoor kitchen and a saltwater pool & spa. Come, experience, & make it yours!' ,`Acres` = '0.2506' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON AT RIVERSTONE SEC 15-B PHASE II, BLOCK 1, LOT 1' ,`LotDesciption` = 'Corner,Water View' ,`LotSize` = '10914' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1810' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Fiberglass,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SULLIVAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Avalon At Riverstone' ,`TaxAmount` = '19167' ,`TaxRate` = '2.4529' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675194914' WHERE `Matrix_Unique_ID` = '213931849' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T23:44:06.800' ,`MLSNumber` = '89627900' ,`ListAgentFullName` = 'Cathy Carter' ,`ListOfficeName` = 'Carter Signature Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.072634' ,`Longitude` = '-95.125010' ,`PhotoCount` = '45' ,`PostalCode` = '77541' ,`RoomCount` = '4' ,`ListPrice` = '739900.00' ,`Status` = 'Active' ,`StreetName` = 'Buccaneer' ,`StreetNumber` = '13002' ,`StreetSuffix` = 'Parkway' ,`City` = 'Freeport' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2236' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Take in the breathtaking beach and bay views from this spacious 4-bedroom, 3-bathroom home on a corner lot surrounded by palm trees. Entertain guests or relax with family in the open living room with vaulted ceilings, visible from the kitchen and den. The gourmet kitchen features a hidden spice rack and a dining room that seats 10+. The two living areas have plenty of natural light, blind covered windows, and multiple access points to the deck. Retreat to the primary bedroom with an en-suite and deck access to enjoy the sunset. The spiral staircase leads to a bedroom with en-suite, which can be used as a bunkroom or a private retreat with 4 bunk beds and a children\'s play area. This property is a popular rental, sleeps 14+, and perfect for family fun. Schedule your tour of this Signature Treasure Island home today!' ,`Acres` = '0.2' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Treasure Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TREASURE ISLAND (A0029 S F AUSTIN) BLK 10 LOT 1 ACRES .2' ,`LotDesciption` = 'Corner,Water View' ,`LotSize` = '8712' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Treasure Island' ,`TaxAmount` = '10023' ,`TaxRate` = '2.3804' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675194914' WHERE `Matrix_Unique_ID` = '214152645' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T23:49:06.450' ,`MLSNumber` = '79781664' ,`ListAgentFullName` = 'Ruby Thomas Wadhwa' ,`ListOfficeName` = 'Houston Dwell Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.539688' ,`Longitude` = '-95.679353' ,`PhotoCount` = '49' ,`PostalCode` = '77469' ,`RoomCount` = '6' ,`ListPrice` = '509500.00' ,`Status` = 'Active' ,`StreetName` = 'HUISACHE GROVE' ,`StreetNumber` = '607' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2493' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION! Highly sought after Greatwood Lake community located in Richmond with award winning schools, close to popular shopping, dining & entertainment as well as easy access to US 59/ Grand Parkway 99 & only 28 miles to Downtown Houston. This 1-story New Construction home features 4 bedrooms, 3 baths and 3 car attached garage. Convenient home office with French doors off foyer. Open dining room leads into great room with cozy stone fireplace. Beautiful maple cabinets, granite countertops and apron front farmhouse sink in gourmet kitchen. Walk-in pantry. Double sinks, huge walk-in closet, separate tub and shower in owner\'s luxury bath. Extended covered patio in backyard, perfect for entertaining. Never lived in home built by: K. Hovnanian Homes.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'K HOVNANIAN HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend Southeast' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 2, BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '775' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'VELASQUEZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'GREATWOOD LAKE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675194915' WHERE `Matrix_Unique_ID` = '214986791' --> 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','215411276','1675194915','215411276','2023-01-16T23:46:18.803','15772230','Cathy Carter','Carter Signature Properties','','','29.169956','-94.993438','43','77554','3','849900.00','Active','De Vaca','18302','','Galveston','2','0','3','1645','Single-Family','Discover the ultimate coastal living in the Sea Salt Parrot, a stunning 2-story, double deck home with cargo lift and breathtaking Gulf views. Park on the spacious concrete pad and make use of the ground floor amenities such as golf cart garage and outdoor shower. Enter the home to find an open floor plan with a combined kitchen, breakfast bar, living and dining room with a wall of windows overlooking the water. Spend the day lounging on the partially covered deck and gather with friends and family in front of the fireplace. Retire to one of the two first-floor bedrooms with a jack and jill bath, and centrally located utility room. If you\'re looking for privacy, head upstairs to the primary bedroom with a private deck, walk-in closet, and en-suite to enjoy. The home is being sold furnished with appliances, schedule your signature tour today and fall in love with the Sea Salt Parrot.','0.346','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','West End','Central Electric','1','ABST 121 HALL & JONES SUR LOT 69 INDIAN BEACH SEC 4','Water View','15072','Appraisal District','','321','0','','1','','0','','','Electric Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required','Appraisal District','1.5','Other Style','Indian Beach 4','10415','1.9875','Public Sewer,Public Water','2001','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','216188808','1675194915','216188808','2023-01-16T23:38:58.803','898353','Dorothy Yee','RE/MAX Fine Properties','','','29.546025','-95.605594','50','77479','12','2388000.00','Active','Tillbuster Ponds','5014','Court','Sugar Land','5','1','6','5800','Single-Family','Custom Home on a Unique Street of Dreams. Only 11 homes on a privately gated street of 1/2 acre lots. Complete with its own guest house, huge pool and basketball court. The main house has 5 bedrooms. 4 1/2 baths. Two bedrooms, game room and media room on first floor. Impressive chef like kitchen with 6 burner gas range w/griddle, 3 ovens, microwave and built in refrigerator. Lots of custom cabinets throughout. 2nd floor bathrooms completely remodeled to include showers in lieu of bath tubs, new countertops, new tile flooring and lighting. Bath tiles from floor to ceiling. Dining room includes wine room and wet bar. Stand alone guest house with one bedroom one full bath, family room and full size kitchen, refrigerator, washer and dryer. Outdoor living includes kitchen with built in grill, refrigerator and sink. Heated pool and hot tub with color changing lights and water features. Security system includes cameras. Generac generator covers whole home, pool and guest house.','0.6745','29','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Sugar Land South','Central Gas','1','AVALON AT RIVERSTONE SEC 7, BLOCK 1, LOT 9','Subdivision Lot','29381','Appraisal District','','1810','0','','3','Double Oven','1','In Ground','','Gas Cooktop','','Tile','19 - Fort Bend','SULLIVAN ELEMENTARY SCHOOL','ELKINS HIGH SCHOOL','FORT SETTLEMENT MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Mediterranean','Avalon At Riverstone','25138','2.4529','Water District','2015','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','216199344','1675194915','216199344','2023-01-17T00:31:50.913','17973040','Marian Rohat','Ross & Marshall Realty','','','30.085202','-95.463388','44','77389','8','315000.00','Active','Rustling Chestnut','3011','Street','Spring','2','1','4','2580','Single-Family','Minutes to The Woodlands and access to 3 major highways.Cozy, comfortable,inviting home.Four very large bedrooms (master down),2.5 baths, laminate & bamboo floors,upgraded carpet,tile,eat in kitchen,black appliances with built in microwave,Silestone countertops, 42\' cabinets,upgraded stainless steel sink,HUGE gameroom with built in desk, jacuzzi tub in master bath,blinds throughout,sodded backyard for the kids,beautifully landscaped and many more upgrades! Gardener playground with lots of outdoor options.A very quiet and tranquil neighborhood with great shopping center nearby. This neighborhood offers a tennis court, playground, private lake with a walking trail. FRESH PAINT 2023, NEW BACKYARD FENCE 2023.Very motivated seller.','0.1048','14','','','','','Sellers Disclosure','1','','','Spring/Klein','Central Gas','1','LT 24 BLK 3 FOREST RIDGE SEC 1','Subdivision Lot','4565','Appraisal District','','490','0','','2','','0','','','','','Wood Shingle','32 - Klein','ZWINK ELEMENTARY SCHOOL','KLEIN COLLINS HIGH SCHOOL','HILDEBRANDT INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Contemporary/Modern,Traditional','Forest Rdg Sec 01','6643','2.804','Water District','2006','Appraisal District'); --> New record created successfully