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-03T19:22:03.440' ,`MLSNumber` = '88193793' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Sikiru Ogunboyejo' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.678317' ,`Longitude` = '-95.832803' ,`PhotoCount` = '30' ,`PostalCode` = '77406' ,`RoomCount` = '15' ,`ListPrice` = '534218.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Carina Cloud' ,`StreetNumber` = '10410' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Ellicott, Elevation A) CURRENTLY BEING BUILT. Two story. 4 bedrooms, 3.5 baths. Primary suite with large walk-in closet. Second bedroom on first floor with private bath. Grand foyer with winding staircase & rotunda ceiling. First floor study and informal dining adjacent to the island kitchen. Upstairs additional 2 bedrooms, game room, and media room. Covered patio and attached 2 car garage. Candela offers new homes for sale in Richmond, Texas. The community is the perfect combination of small-town charm and easy access to big city conveniences. Take a stroll through Downtown Historic Richmond, visit the Imperial Farmer\'s Market and enjoy the great outdoors at Brazos Bend State Park. Major employers in Houston, Katy and Sugar Land are only a short commute away. Great restaurants, and local and big box retail offerings are all close by. Visit Candela today to find your new home!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 1, LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6500' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.15' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101200' WHERE `Matrix_Unique_ID` = '210733128' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T19:31:50.747' ,`MLSNumber` = '59302379' ,`ListAgentFullName` = 'Janeth Valenzuela' ,`ListOfficeName` = 'Intero Real Estate Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.463161' ,`Longitude` = '-95.460724' ,`PhotoCount` = '21' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Philox Park' ,`StreetNumber` = '8407' ,`StreetSuffix` = 'Court' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1297' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Like New! Beautiful new home in Southern Colony, welcome to this immaculate one story home featuring 3 bedrooms, 2 baths and an amazing open floor concept perfect for all of your family gatherings. You will love the kitchen granite counter tops, stainless steel appliances, walk-in pantry including luxury vinyl flooring through out the common areas. Energy efficient, Smart Home Technology features, pool sized backyard with endless opportunities, this home just has it all and more ready for you to call it your own.Perfectly situated within minutes from major roads, shopping and dinning. Schedule your private tour today!' ,`Acres` = '0.1852' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHERN COLONY SEC 4-C, BLOCK 4, LOT 48' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8066' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southern Colony' ,`TaxAmount` = '5729' ,`TaxRate` = '3.1329' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101201' WHERE `Matrix_Unique_ID` = '213534847' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T19:44:39.697' ,`MLSNumber` = '76434183' ,`ListAgentFullName` = 'Ashley Van den Heuvel' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.428782' ,`Longitude` = '-95.625782' ,`PhotoCount` = '31' ,`PostalCode` = '77356' ,`RoomCount` = '8' ,`ListPrice` = '510000.00' ,`Status` = 'Active' ,`StreetName` = 'Bermuda' ,`StreetNumber` = '128' ,`StreetSuffix` = 'Circle' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2706' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2022 Beautiful brand new custom built home in the exclusive gated community of Bentwater Yacht and Country Club! This 4 bedroom 3.5 bath features an amazing open floor plan with high ceilings and stunning backsplash and counter tops throughout. An impressive kitchen with ample counter space allows for the perfect room for entertaining family and friends. A separate office gives you plenty of privacy to work from home. The second story provides a large room that could be used as an extra bedroom or bonus room with a full bath. A separate mud room gives everyone the space to take your shoes off before relaxing at home! This house is nothing short of amazing!' ,`Acres` = '0.1653' ,`Area` = '39' ,`BuilderName` = 'Blue Sky Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S261505 - BENTWATER 05, BLOCK 3, LOT 19' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1146' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '388' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101201' WHERE `Matrix_Unique_ID` = '214472069' --> 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','215084419','1675101201','215084419','2023-01-03T19:20:24.087','83018110','Clinton Omiwade','ERA Legacy Living','','','30.022065','-95.628648','45','77377','10','424999.00','Active','Northpointe Ridge','12327','Lane','Tomball','2','1','4','2775','Single-Family','Gorgeous single story home in a great location ! This home features beautiful tile ,wood and carpet floors through the whole house, stunning front entry with a large beautiful kitchen, stunning countertops and so much more! Very spacious Main Living area With great Flooring. Large Sized Kitchen with Open Concept. 2-car garage. The house is placed on one of the largest lots in the community and has a huge backyard. House has been extensively taken care of and is being sold to you with EQUITY. Located close to multiple grocery options ,schools ,police. You will be hard-pressed to find this unique open floor plan in this neighborhood. This home has everything you could ever want! This gem will not last long - schedule a showing','0.2173','35','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','','','1','Tomball South/Lakewood','Central Gas','1','LT 7 BLK 2 WILDWOOD AT NORTHPOINTE SEC 20','Subdivision Lot','9466','Appraisal District','','1035','0','','2','','0','','','','','Composition','53 - Tomball','WILDWOOD ELEMENTARY SCHOOL','TOMBALL MEMORIAL H S','GRAND LAKES JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Wildwood/Northpointe Sec 20','10849','3.0564','Public Water,Water District','2014','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','215412979','1675101201','215412979','2023-01-03T19:34:17.150','43757143','Sylvia Broussard','Keller Williams Professionals','','','30.032003','-95.498260','10','77379','4','379900.00','Active','Bryanhurst','5511','Lane','Spring','2','1','4','3247','Single-Family','','0.2238','13','','','','','Sellers Disclosure','1','','1','Champions Area','Central Gas','1','LT 585 BLK 2 TERRANOVA WEST SEC 4','Subdivision Lot','9750','Appraisal District','','900','0','','2','Double Oven','0','','','','','Composition','32 - Klein','BENFER ELEMENTARY SCHOOL','KLEIN HIGH SCHOOL','STRACK INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Terranova West','7686','2.7066','Water District','1984','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','215967056','1675101201','215967056','2023-01-03T20:07:24.127','71509777','Dena May','Coastal Dream Properties','','','29.730907','-94.961425','32','77520','8','272000.00','Active','Defee','520','Avenue','Baytown','2','0','3','1667','Single-Family','Brand new home! Never lived in with tons of extra room. Living area and kitchen are beautiful. Laminate floors with massive granite island. Massive white shaker kitchen cabinets with plenty of counter space. Seven ceiling fans throughout home. 3 ton AC! 30 year shingle on the roof with Solid 2x8 Ceiling Joist and 2x6 Rafters 16” centers. Open floor plan that allows for lots of space and room for entertaining. Oversize Multi-Car Driveway with reinforced Extra Steel Rebar in the cement. New sidewalks and covered front porch. The perfect location for relaxing after a long day of work. New fence. Brushed nickel pulls and faucets. Every detail was thought of in this amazing home. Double pane windows with extra insulation make the home very quiet. Make your appointment today to see this beautiful home before it is gone.','0.1148','2','JKB Energy Corp.','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','0','Baytown/Harris County','Central Electric','0','LT 1 BLK 8 LONG A C','Corner','5000','Appraisal District','','','1','Never Lived In','0','Electric Oven','0','','','Electric Range','','Composition','23 - Goose Creek Consolidated','ASHBEL SMITH ELEMENTARY SCHOOL','LEE HIGH SCHOOL (GOOSE CREEK)','HORACE MANN J H','Appointment Required,Lockbox Right Side,Supra Keybox','Builder','1','Ranch','Long A C','','','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','215977538','1675101201','215977538','2023-01-03T20:15:27.993','14190984','Sadaf Moon','REALM Real Estate Professional','','','29.660507','-95.620309','26','77498','4','265000.00','Active','Sarento Village','13418','','Sugar Land','2','0','3','1577','Single-Family','Great Location . Need a little TLC .\r\nGreat buy and hold .Bring reasonable offers .','0.1188','29','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Sugar Land North','Central Gas','1','ELDRIDGE PARK VILLAGE SEC 1, BLOCK 1, LOT 18','Subdivision Lot','5177','Appraisal District','','500','0','','2','Single Oven','0','','','Gas Range','','Composition','19 - Fort Bend','BARRINGTON PLACE ELEMENTARY SCHOOL','KEMPNER HIGH SCHOOL','SUGAR LAND MIDDLE SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment','Appraisal District','1','Traditional','Eldridge Park Village Sec 1','4606','2.3329','Public Sewer,Public Water','1999','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','215996301','1675101201','215996301','2023-01-03T19:01:26.490','68020814','Natasha Simon','Keller Williams Realty - Memor','','','29.797918','-95.325714','7','77026','3','140000.00','Active','Wayne','4106','Street','Houston','1','0','3','1200','Single-Family','This property sits on 15000 sqft. Make your offer today!','0.3444','2','','','','','No Disclosures','','','','Northside','Central Gas','0','LT 92 BLK 8 KASHMERE GARDENS','Subdivision Lot','15000','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','ISAACS ELEMENTARY SCHOOL','WHEATLEY HIGH SCHOOL','FLEMING MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Ranch','Kashmere Gardens','2707','2.3307','Public Sewer,Public Water','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','216031006','1675101201','216031006','2023-01-03T20:39:32.467','32687152','Elena Jackson','House Hunter Houston, Inc','','','30.249274','-95.528635','50','77384','6','515000.00','Active','Kerrick Vista','14402','Lane','Conroe','3','1','4','3120','Single-Family','Beautiful two-story home with 3 car garage in a desirable community of Foster`s Ridge. This home features gorgeous brick\r\nand stone exterior and includes a 4 bed/3 baths and a spacious Game Room! Features include upgraded SS appliances w/gas\r\nburner cooktop, granite countertops, Osmosis system and 42\" cabinets in Kitchen, Smart Home Package, Tankless Water\r\nHeater, Covered Patio, and Full Sprinkler System. The property showcases expansive front and back yards with landscaping\r\nfeatures. This home is zoned to highly acclaimed Woodlands Schools within Conroe ISD. Better than new! Barely lived in for 6\r\nmonths and no building delays, part of DR Horton\'s classic line. Fosters Ridge offers a beautiful community center,\r\nplayground, and pool. This is a must see home that offers affordable luxury in a premium location for whatever adventures you\r\nseek.','0.3493','15','','','Electric Dryer Connections','','Mud,Sellers Disclosure','1','','','Conroe Southwest','Central Gas','1','S516407 - FOSTERS RIDGE 07, BLOCK 3, LOT 5','Cul-De-Sac','15217','Appraisal District','','850','0','','3','Double Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','BUSH ELEMENTARY SCHOOL (CONROE)','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Left Side,Supra Keybox','Appraisal District','2','Contemporary/Modern','Fosters Ridge 07','7067','3.1488','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','216031528','1675101201','216031528','2023-01-03T19:33:28.340','38328471','Joseph Nnadozie','eXp Realty, LLC','','','30.618036','-95.485032','50','77340','10','695900.00','Active','State Highway 75','8407','','Huntsville','2','0','3','1456','Single-Family','This country home features a great landscape view with tons of space on a 8.69 Acres lot. This home includes a fully fenced electric gate, a circled driveway, a three car garage, stable, a barn, and an apartment with a kitchen, living area, and bedroom connected to the house. Also the oversized garage has massive space to create additional rooms.','8.69','43','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures,Sellers Disclosure,Tenant Occupied','1','Wood Burning Fireplace','1','New Waverly Area','Central Electric,Heat Pump,Window Unit','0','SADDLE RIDGE, LOT 5, ACRES 8.69','Cleared,Patio Lot,Subdivision Lot','378536','Other','','','0','','3','Electric Oven,Freestanding Oven','0','','','Electric Cooktop,Electric Range,Freestanding Range','','Composition','105 - New Waverly','NEW WAVERLY ELEMENTARY SCHOOL','NEW WAVERLY HIGH SCHOOL','NEW WAVERLY JUNIOR HIGH SCHOOL','Appointment Required','Seller','1','Ranch','Saddle Ridge','3049','1.7846','Aerobic,Well','2002','Seller'); --> 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','216038015','1675101201','216038015','2023-01-03T20:56:30.353','60086790','Rachel Parsons','Keller Williams Realty Austin','','','29.428670','-97.165832','19','77984','2','261800.00','Active','Avenue B','104','','Shiner','2','0','2','1668','Single-Family','Looking for a home in the \"Cleanest little city of Texas\"? This brick 2/2 on a corner lot is within walking distance to the historic THE SPOETZL BREWERY and the downtown area. The in-ground pool is perfect for those hot sunny days while the sun room provides the perfect place for relaxing and enjoying family & friends poolside. With an open concept kitchen, dining & living area, you can converse, watch TV and still see the outside pool area. The warmth of the fireplace is ideal for cozy evenings relaxing by the flames with your favorite beverage. If small town living is your dream, give me a call & let\'s make this house your home!','0.1722','68','','','Electric Dryer Connections,Washer Connections','','Estate','0','','1','','Central Electric','0','SHINER (TOWNSITE), BLK 29-FR, ACRES 0.1720','Corner','7501','Appraisal District','','','0','','0','Electric Oven','1','In Ground','','Electric Range','','Composition','251 - Shiner','SHINER ELEMENTARY SCHOOL','SHINER HIGH SCHOOL','SHINER HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Shiner Townsite','4025','1.7009','Public Sewer,Public Water','2005','Appraisal District'); --> New record created successfully