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` = '2022-12-21T13:30:50.590' ,`MLSNumber` = '70172272' ,`ListAgentFullName` = 'Bruce Ham' ,`ListOfficeName` = 'Real Broker, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804613' ,`Longitude` = '-94.935980' ,`PhotoCount` = '39' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Delynn' ,`StreetNumber` = '7810' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2371' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous home features 3 bedrooms, 2 bathroom home ready to foster a countless amount of memories! Stunning kitchen with S.S appliances and electric cooktop over looking the main living and dining room. Property includes Large wooden patio, RV arport, 2-car garage and extra storage workshop. New A/C unit as of May 2022 and heater as of February 2022. I-10, Trinity Bay, Downtown Baytown and restaurants are all within close proximity! Call us to schedule your private tour today!' ,`Acres` = '0.62' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 29 ABST 4 W BLOODGOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '27007' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'William Bloodgood Surv Abs 4' ,`TaxAmount` = '3603' ,`TaxRate` = '2.285' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093931' WHERE `Matrix_Unique_ID` = '211728946' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-21T13:30:40.060' ,`MLSNumber` = '61482906' ,`ListAgentFullName` = 'Darcy Hecht' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.664585' ,`Longitude` = '-95.461130' ,`PhotoCount` = '32' ,`PostalCode` = '77035' ,`RoomCount` = '4' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Willowbend' ,`StreetNumber` = '4834' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2119' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Renovated 3 Bedroom, 2.5 Bathroom Home in The Willow Meadows area (Willow Bend Subdivision). Fresh Paint Inside and Out, Large Backyard Covered Porch with Ceiling Fans. Totally Renovated Home with Modern Fixtures, Recessed Light throughout the Home, No Carpet - LVP and Tile Flooring. Spacious Eat-in Kitchen and Island, Pot Filler, Open and Closed Shelving, Quartz Counter Tops and Backsplash, all new Cabinets and Stainless Steel Appliances (Gas Stove). Both Bathrooms have Walk-In Showers, Quartz Counter Tops and Rain Shower Head. Large Living Room with Wood Burning Fireplace. All measurements are approximate and should be independently verified.' ,`Acres` = '0.2066' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 80 BLK 4 WILLOW BEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Willow Bend' ,`TaxAmount` = '4661' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093931' WHERE `Matrix_Unique_ID` = '213228655' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-21T13:04:26.877' ,`MLSNumber` = '42865643' ,`ListAgentFullName` = 'Toke Ettehadieh' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.002872' ,`Longitude` = '-95.600416' ,`PhotoCount` = '36' ,`PostalCode` = '77377' ,`RoomCount` = '11' ,`ListPrice` = '419786.00' ,`Status` = 'Active' ,`StreetName` = 'Gettysburg' ,`StreetNumber` = '15706' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2999' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This phenomenal 4 Bedroom, 3.5 Bathroom Residence has been Renovated from top to bottom. Impressive Foyer with High Ceilings and Split Staircase. Formal Living Room w/Wood Burning Fireplace off the Foyer could easily double as a Home Office/Study. Refinished Original Hardwood Floors in the Living Room, Formal Dining & Living, and Primary Bedroom! Spacious Kitchen features Quartz Countertops, Large Island w/Gas Range, SS Appliances, and Solid Wood Cabinetry. Primary Bedroom w/Amazing Picture Window and High Ceilings. Grand Primary Bathroom w/Jetted Tub, Stand Alone Shower, His/Her Vanity and His/Her Closets. Second Floor has 3 Bedrooms and a Bonus Room. New Carpeting throughout. Fantastic community includes a community pool, park and tennis courts. Check out the Virtual Tour and Schedule a Viewing Today!' ,`Acres` = '0.2386' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 2 GETTYSBURG SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10395' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '695' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'LAKEWOOD ELEMENTARY SCHOOL (TOMBALL)' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Gettysburg Sec 01' ,`TaxAmount` = '7404' ,`TaxRate` = '2.4945' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093932' WHERE `Matrix_Unique_ID` = '214431605' --> 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','215290715','1675093932','215290715','2022-12-21T14:51:08.667','75534059','Natalie Sloan','Styled Real Estate',' Non-MLS Agent','Non-MLS ','30.082684','-95.128776','43','77336','8','610000.00','Pending Continue to Show','Commons Forest','29114','Drive','Huffman','2','1','4','2950','Single-Family','A popular lakeside community located just 35 minutes from downtown Houston and minutes away from Highway 99. This stunning one and a half story home on over two acres positioned on a corner lot can be yours to celebrate the holiday season. The beautiful open concept home offers an expansive living/dining area that flows over travertine tile into a large kitchen. Granite countertops, stainless steel appliances and generous cabinet space make family dining and entertaining fun and easy. The home has four generous-sized bedrooms on the first level with easy to maintain wood tile flooring. An additional bedroom/gameroom is located on the second level. This professionally landscaped backyard has a heated pool and spa. Join a community that offers 30 plus miles of walking trails, horse trails and gated parks with lake access and boat ramp. A truly outstanding home with beautiful well-designed touches.\r\n\r\n**Please see attached home upgrades under attachment link.','2.124','32','','','Electric Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Huffman Area','Propane','1','LT 1 BLK 3 COMMONS OF LAKE HOUSTON SEC 4 2ND AMEND','Cleared,Subdivision Lot','92521','Appraisal District','','1000','0','','2','Gas Oven','1','Gunite,Heated,In Ground','','Gas Range','','Aluminum','28 - Huffman','FALCON RIDGE ELEMENTARY SCHOOL','HARGRAVE HIGH SCHOOL','HUFFMAN MIDDLE SCHOOL','Appointment Required,Leave Business Card','Appraisal District','1','Traditional','Commons Lake Houston Sec 04','8738','2.0083','Public Water,Septic Tank','2000','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','215352879','1675093932','215352879','2022-12-21T14:20:22.133','40030640','Cyndi Kornegay','Gatehouse Properties','','','29.469540','-95.523234','13','77459','13','880611.00','Active','Crescent Wood','10019','Drive','Missouri City','5','1','5','4587','Single-Family','This impressive 2 story home has it all. Step through the double front doors into the grand foyer that is flanked by a dramatic curved staircase on one side and huge dining across. This home echoes luxury with 5 bedrooms and attached private bathrooms for each bedroom, a great room that impresses as it leads into the Texas-sized patio where your family can enjoy outdoor living. The backyard is oversized and large enough for a pool. Upstairs you\'ll find a movie lover’s ideal setting with a theater and a large game room to enjoy pool and popcorn parties! Located in prestigious Sienna, featurning acclaimed schools, shopping, restaurants, movies, and first colony mall within minutes. Make an appointment today!','','38','Coventry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Levee District,Mud,Other Disclosures','1','Gas Connections,Gaslog Fireplace','1','Sienna Area','Central Gas,Zoned','1','Lot 8 Block 4','Subdivision Lot','10143','Survey','','1307','1','To Be Built/Under Construction','3','Single Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','LEONETTI ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','THORNTON MIDDLE SCHOOL (FORT BEND)','Accompany,Appointment Required,No Supra Keybox','Builder','2','Traditional','Sienna','','3.17','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','215396025','1675093932','215396025','2022-12-21T14:47:04.393','45364814','Huy Phan','Keller Williams Signature','','','29.706177','-95.523535','35','77036','11','415000.00','Active','Hiawatha','7807','Drive','Houston','2','1','4','3303','Single-Family','Welcome home to this REMODELED 4 bedroom, 2 1/2 Bath with large 2 car detached garage. New roof 2022, new tile in bedroom area, new vinyl plank flooring in kitchen & sunroom, new tile backslash & granite countertops in kitchen and laundry room, new curtains in sunroom. Beautiful open floorplan with spacious living areas, including den, living room, formal dining room, breakfast, and bright sunroom is ideal for entertaining. Relaxing oversized yard close to 14,000 sqft. Great location with easy access to Beltway 8, High way 59 and Westpark Tollway. Closed to China town, Little Saigon, Hong Kong City Mall, Viet Hoa supermarket etc. Call today for your private tour!','0.3214','21','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Sharpstown Area','Central Gas','0','LT 17 BLK 1 SHARPSTOWN COUNTRY CLUB EST 2','Subdivision Lot','14000','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','NEFF ELEMENTARY SCHOOL','SHARPSTOWN HIGH SCHOOL','SUGAR GROVE MIDDLE SCHOOL','Accompany,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Sharpstown Cntry Club Estates Sec','8587','2.3307','Public Sewer,Public Water','1960','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','215449918','1675093932','215449918','2022-12-21T13:43:12.147','77269620','Aaron Jistel','Listing Spark','','','29.583532','-95.007529','25','77586','7','310000.00','Active','Heron','4514','Drive','Seabrook','2','0','3','1651','Single-Family','Lovely bay-side neighborhood. Home has been completely renovated like new - ready to move in with neutral pallet of exterior & interior paint (new ceilings & smooth walls), new dbl-pained windows, recessed lighting & new wiring & ceiling fans, vaulted ceiling in fam rm w/stained beam. Handsome laminate flooring throughout & new carpet in 2 bdrms. Kitchen transformed - new cabinets, granite counters & island w/pendant lights, under counter lighting, new stainless appliances & tile backsplash. Both bathrooms upgraded w/granite counters, new vanities and new tile throughout. Primary suite features sliding barn door entry to bathroom w/new cabinetry, granite counter, dbl sinks & new shower w/sliding glass door. New Pex piping, new HVAC system, newer hot water heater &, new blown-in insulation in attic. Fully fenced backyard w\\firepit & small patio. Residents can enjoy private waterfront park on Galveston Bay including pier. Walking distance to parks, jogging trail, nature & Wildlife Park!','0.1584','7','','','','','Sellers Disclosure','1','','0','Clear Lake Area','Central Gas','1','LT 4 BLK 2 SEASCAPE SEC 2','Other','6900','Appraisal District','','82','0','','2','Gas Oven,Single Oven','0','','','Gas Cooktop','','Other','9 - Clear Creek','BAY ELEMENTARY SCHOOL','CLEAR FALLS HIGH SCHOOL','SEABROOK INTERMEDIATE SCHOOL','Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern','Seascape Sec 02','4851','2.2905','Public Sewer,Public Water','1966','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','215781877','1675093932','215781877','2022-12-21T13:14:49.423','82152944','Etha Eglin','Keller Williams Metropolitan','','','30.151554','-94.141141','27','77708','8','307990.00','Active','Rilplee Street','6755','','Beaumont','2','0','4','','Single-Family','The Kingston elevation P is a one-story home featuring 4 bedrooms, 2 baths, and 2 car garage beautifully crafted new construction home by D.R. Horton.. The entry opens to the guest bedrooms, bath with linen closet. Center kitchen includes oversized breakfast bar with beautiful counter tops and stainless-steel appliances. Open concept floorplan boasts large, combined family room and dining area. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and walk-in closet. The standard rear covered patio is located off the family room. Beaumont\'s trendy hidden neighborhood, Spring Wood is tucked away on RFD Road just off FM 105 and Major Drive. Schedule your tour today!','','51','D.R. Horton','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures','1','','','','Central Gas','1','Lot 3 Block 5 Springwood','Corner,Subdivision Lot','8400','Survey','','300','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','143 - Beaumont','HOMER DRIVE ELEMENTARY SCHOOL','BEAUMONT UNITED HIGH SCHOOL','KING MIDDLE SCHOOL (BEAUMONT)','Accompany,Appointment Required,Vacant/Unoccupied','Builder','1','Traditional','Spring Wood','','2.6134','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215782447','1675093932','215782447','2022-12-21T13:01:00.480','16741200','Casey Babin','Nextgen Real Estate Properties','','','29.294593','-94.804502','14','77550','6','315000.00','Active','Avenue L','3415','','Galveston','2','0','3','1156','Single-Family','Marvelously Updated & Cheerfully Charming Home in Galveston! Nestled in a sought-after area only minutes from Pleasure Pier, this 3BR/2BA, 1,156sqft captivates w/ a vibrant exterior color scheme, an idyllic picket fence, & a covered entryway. Explore the sundrenched interior to discover an open floorplan, gorgeous tile faux wood flooring, a coastal color palette, crown moulding, tons of natural light, & a spacious living/dining room. Entertainment-ready w/ modern panache, the updated open concept kitchen features stainless-steel appliances, white cabinetry, a gas range, and a built-in microwave. Three bedrooms are abundantly sized for comfort, while the full bathrooms are ideal for convenient living. Whether you desire a personal vacation home or an investment Airbnb, this property offers an array of possibilities. Other features: fenced backyard, street parking, laundry area, near The Strand & Moody Gardens, only 1-mile to beach, & more! All furnishings and decor is negotiable!','','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','East End','Central Electric','0','ABST 628 M B MENARD SUR PT OF LOTS 4 & 5 (4-1) BLK 34 GALVES','Subdivision Lot','2230','Appraisal District','','','0','','0','Electric Oven','0','','','Gas Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required','Appraisal District','1','Traditional','Galveston Townsite','4012','2.0161','Public Sewer,Public Water','1963','Appraisal District'); --> New record created successfully