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-12T14:11:26.500' ,`MLSNumber` = '58020192' ,`ListAgentFullName` = 'Maria Gallegos' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.258335' ,`Longitude` = '-95.077993' ,`PhotoCount` = '23' ,`PostalCode` = '77327' ,`RoomCount` = '4' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 340' ,`StreetNumber` = '574' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t let this opportunity pass you by. A beautiful 4 bedroom, 2 bathroom gem that sits on half an acre. With a large primary room, double sink, large tub and a walk in closet. An open concept kitchen that opens up to a large living room to engage with all while cooking. This gorgeous home has 2 outdoor entertainment areas along with a large custom built storage unit. Another great feature this home has to offer is a grand attached deck, either to host, sip on your coffee or simply enjoy the country living. Property sits on a busy road, great space to convert into commercial or maintain as a residence. LOW TAXES, NO HOA. Don\'t think twice, make your appointment now!' ,`Acres` = '0.5' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BELLA VISTA SEC 2, BLOCK 4, LOT 110, ACRES .5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '21780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Bella Vista Sec 2' ,`TaxAmount` = '1956' ,`TaxRate` = '1.8013' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090270' WHERE `Matrix_Unique_ID` = '214067033' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T13:57:22.703' ,`MLSNumber` = '17173032' ,`ListAgentFullName` = 'Coleen Ethridge' ,`ListOfficeName` = 'CAMM Group, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.676347' ,`Longitude` = '-95.435318' ,`PhotoCount` = '34' ,`PostalCode` = '77025' ,`RoomCount` = '7' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Madeline Alyssa' ,`StreetNumber` = '9822' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2256' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this freestanding, 2 story home is located in a quiet gated community and conveniently located minutes from the Medical Center and Galleria. The spacious home welcomes you to the first floor that include a lovely entry, 2 bedrooms with walk in closets, full bathroom and an office/study that could be used as a fourth bedroom. Two car attached garage with built in work bend and extra storage as well as a large, oversized storage closet under the staircase. The second floor offers beautiful wood floors in the open concept kitchen, dining room and living room with lots of windows for natural lighting. Other features include faux wood blinds throughout, ceiling fans in every room, wired for alarm system, built-in cabinets/shelving in the living room, double oven. 2nd level primary bedroom with very large bathroom with jetted soaking tub and separate tub area and extra spacious walk-in closet. Walk-in laundry room on 2nd floor with storage cabinets and hanging rack.' ,`Acres` = '0.0403' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 1 CONTEMPORARY PLAZA SEC 5' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1754' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '185' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHEARN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Contemporary Plaza Sec 05' ,`TaxAmount` = '6802' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090270' WHERE `Matrix_Unique_ID` = '214091579' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T14:59:52.553' ,`MLSNumber` = '84978886' ,`ListAgentFullName` = 'Trisha Cranney' ,`ListOfficeName` = 'Anne Vickery & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.225148' ,`Longitude` = '-95.167260' ,`PhotoCount` = '16' ,`PostalCode` = '77372' ,`RoomCount` = '3' ,`ListPrice` = '394000.00' ,`Status` = 'Active' ,`StreetName` = 'Memorial' ,`StreetNumber` = '15002' ,`StreetSuffix` = 'Drive' ,`City` = 'Splendora' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1632' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable Freshly painted Block & Beam home on 1 Unrestricted acre on the corner of 1st Street & Memorial Drive, Ideal commercial property with City of Splendora public utilities, Natural Gas is available. Located 4 miles from Valley Ranch, 2 Miles from Grand Texas & 242' ,`Acres` = '1' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0594 WILLS WILLIAM, TRACT 3 & 4, ACRES 1.00' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'East HWY 59' ,`TaxAmount` = '830' ,`TaxRate` = '2.7447' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675090270' WHERE `Matrix_Unique_ID` = '214175678' --> 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','215153621','1675090271','215153621','2022-12-12T13:24:32.310','52770588','Martha Nguyen','Nan & Company PropertiesChristie\'s International R','','','29.827916','-94.994205','10','77521','9','299545.00','Active','Brazos','8903','Drive','Baytown','2','0','3','1855','Single-Family','**Home is under construction.** Find total comfort in this lovely Beazer home in Ashbel Cove, boasting a brick façade, study with French doors, and open an great room. Spend afternoons in the kitchen, equipped with quartz countertops, mosaic backsplash, stainless steel appliances, pendant lighting, and under-counter lighting. Unwind in the serene primary suite, features dual vanities and a mud set shower. Situated near I-10 and Hwy 90, residents love the quick access to popular dining, shopping, and entertainment in the Greater Houston area. The serene Ashbel Cove community includes a park, serene lakes, and walking trails. Students attend schools zoned to Goose Creek CISD. There’s no time to lose – call today for more information!','','2','Beazer Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Baytown/Harris County','Central Gas','1','LT 13 BLK 1 ASHBEL CROSSING SEC 6','Cul-De-Sac,Subdivision Lot','','','','750','1','Never Lived In','2','Single Oven','0','','','Gas Cooktop','','Composition','23 - Goose Creek Consolidated','PUMPHREY ELEMENTARY SCHOOL','GOOSE CREEK MEMORIAL','HIGHLANDS JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Ashbel Cove','','3.545293','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215231280','1675090271','215231280','2022-12-12T14:17:40.513','96810458','Diana Nickell','Texas Palladium Properties','','','28.695937','-96.378852','25','77465','4','99000.00','Active','Clam','170','Drive','Palacios','1','0','1','704','Single-Family','Come enjoy this one bedroom / 1 bath cabin on a 1/2 acre in the Boca Chica Subdivision located between Palacios & Port Lavaca! If you are looking for a fisherman\'s getaway camp, this is it! Spacious front porch to sit out and enjoy the coastal breeze. Large storage building for your fishing gear. Bring your boat or RV and create a great family and friends coastal escape. Enjoy the subdivision amenities: Member swimming pool, playground, fishing pier, boat ramp, pavilion and an onsite convenience store/cafe. Water, electric and septic installed.','0.55','67','','','','','Sellers Disclosure','0','','0','','Other Heating','1','BOCA CHICA SEC. III, LOT 13','Cleared','23958','Appraisal District','','250','0','','0','','0','','','','','Composition','156 - Palacios','CENTRAL ELEMENTARY SCHOOL (PALACIOS)','PALACIOS HIGH SCHOOL','PALACIOS JUNIOR HIGH SCHOOL','Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Other Style,Traditional','Boca Chica','1011','1.8978','Public Sewer,Public Water,Water District','2019','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','215293756','1675090271','215293756','2022-12-12T14:59:35.503','38793488','Nicole Garner','Windsor Hill Real Estate Group','','','30.046385','-95.423372','23','77373','12','285840.00','Active','Dickson Park','19215','Drive','Spring','2','1','3','2382','Single-Family','Welcome to your new home! This 3-bedroom, 2.5-bathroom home is ready for new owners. From the moment you walk in, you\'ll be impressed by the high ceilings and abundance of natural light. The gated community provides a quiet setting and leaves one with peace of mind. You\'ll love spending time in the kitchen, thanks to the ample countertop space and abundant storage. The primary bedroom suite features a large en-suite bathroom with a walk-in closet. With two additional bedrooms upstairs and a spacious gameroom, this floor plan could easily accommodate a multi-generational setup and allow for multiple living spaces. \r\n\r\nYou\'ll love the peaceful and scenic surroundings of this exclusive gated community, while also enjoying the convenience of being close to all the best shopping, dining, and entertainment that Houston has to offer. Don\'t miss out on this amazing opportunity - call today for a private tour! Motivated sellers!','0.1523','12','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Spring East','Central Gas','1','LT 21 BLK 1 SPRING PARK VILLAGE','Subdivision Lot','6634','Appraisal District','','685','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','48 - Spring','GINGER MCNABB ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','TWIN CREEKS MIDDLE SCHOOL','Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Spring Park Village','5520','2.4967','Water District','2006','Appraisal'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215357277','1675090271','215357277','2022-12-12T13:24:15.883','2558004','Massiel Romero','2M Realty Advisors, LLC','','','30.219680','-95.327580','17','77302','7','168000.00','Active','Wild Oak','16267','Lane','Conroe','2','0','3','1568','Single-Family','','0.241','19','','','','','Sellers Disclosure','','','','Conroe Southeast','Central Electric','1','S694104 - LONE STAR RANCH 04, BLOCK 4, LOT 68, SERIAL # TXFL','Subdivision Lot','10500','Appraisal District','','300','0','','2','','0','','','','','Composition,Other','11 - Conroe','SAN JACINTO ELEMENTARY SCHOOL (CONROE)','CANEY CREEK HIGH SCHOOL','MOORHEAD JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Call Occupant,Leave Business Card','Appraisal District','1','Other Style','Lone Star Ranch 04','2507','1.8488','Public Sewer,Public Water','2002','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','215504516','1675090271','215504516','2022-12-12T13:26:48.650','75527857','Jane NgaDung Nguyen','Alpha, REALTORS','','','30.209626','-95.341523','22','77302','8','475000.00','Active','Sunset Skies','17553','Road','Conroe','3','1','4','2435','Single-Family','Feel at ease in this 4-bed 3 bath, plus half bath, One-story home with high ceilings. Study with French doors.\r\nWaltz into the foyer and adventure down the long hallway, passing the powder bath. The foyer opens into the kitchen w/ 42\'\' Cabinets, Granite Countertops & a Stainless Steel Appliance , family room and dining room. The Master Suite has a Super Shower, Dual Sinks & Large Walk-In Closet. Complete with 3-car tandem garage and extended covered patio. Located in the beautifully forested community of Artavia, near The Woodlands, Zoned to Conroe ISD, North of Grand PKWY between 45 & 59.','0.1642','19','Coventry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Spring Northeast','Central Gas','1','S216902 - ARTAVIA 02, BLOCK 5, LOT 18','Cleared','7154','Appraisal District','','996','0','','3','Freestanding Oven','0','','','Freestanding Range','','Composition','11 - Conroe','SAN JACINTO ELEMENTARY SCHOOL (CONROE)','CANEY CREEK HIGH SCHOOL','MOORHEAD JUNIOR HIGH SCHOOL','Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Artavia 02','10276','3.1988','Water District','2020','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215524622','1675090271','215524622','2022-12-12T14:16:26.213','5070279','Ariana White','eXp Realty, LLC','','','29.658830','-95.538447','22','77031','3','266000.00','Active','Gatlinburg','11023','Drive','Houston','2','0','3','1980','Single-Family','This beautiful 3-bedroom, 2-bathroom home is located in the Brays Oaks area of SW Houston and is currently leased until February 2024.This completely renovated home has been updated with modern clean lines. This home offers a neutral and inviting space for any style and decor. The open kitchen, complete with electric range, double sink, and new stainless steel appliances, overlooks the living area, making it perfect for entertaining. The bedrooms feature new flooring and ceiling fans for added comfort. The master bedroom\'s ensuite bathroom includes double vanities and bright white tiling. Don\'t miss out on this amazing opportunity!','0.1791','20','','','Gas Dryer Connections','','Sellers Disclosure','1','','','Brays Oaks','Central Gas','0','LT 20 BLK 36 BRAEBURN VALLEY WEST SEC 2','Subdivision Lot','7800','Appraisal District','','','0','','1','','0','','','Electric Range','','Composition','27 - Houston','VALLEY WEST ELEMENTARY SCHOOL','SHARPSTOWN HIGH SCHOOL','WELCH MIDDLE SCHOOL','Temporarily No Showings','Appraisal District','1','Traditional','Braeburn Valley West Sec 02','5039','2.3307','Public Sewer,Public Water','1972','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215536918','1675090271','215536918','2022-12-12T13:41:28.357','56593851','Chandra White','HomeSmart','','','29.503373','-95.442652','17','77583','9','399990.00','Active','Imperial Wood','14206','Lane','Rosharon','2','1','4','3277','Single-Family','SELLER IS RELOCATING MUST SELL... This home is located in the beautiful planned community of Lakes of Savannah . Four bedrooms, primary bedroom first floor, study, dining room, open concept to the family/ kitchen area that features a large island, game room /movie room great for fun family night . Tile in the entry, family, kitchen/breakfast as well as wet areas along with warm engineered wood flooring on stairs and bedrooms. This home is great for entertaining. Nice backyard for family cookouts with a covered patio for those hot summer days. This home location is idea for medical center, Pearland Town Center and future Manvel Town Center. Come Tour Today!!','0.2045','5','','','','','Sellers Disclosure','1','','1','Alvin North','Central Electric','1','SAVANNAH TRACE SEC 2 (A0403 ACH&B) BLK 4 LOT 3 ACRES .2045','Subdivision Lot','8908','Appraisal District','','650','0','','2','Freestanding Oven','1','Above Ground','','Gas Range','','Composition','3 - Alvin','SAVANNAH LAKES ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','MANVEL JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card','Appraisal District','2','Traditional','Savannah Trace Sec 2','8141','2.9567','Water District','2005','Appraisal District'); --> New record created successfully