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-11-30T18:48:43.567' ,`MLSNumber` = '60100595' ,`ListAgentFullName` = 'Melinda Petree' ,`ListOfficeName` = 'Heinen Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659923' ,`Longitude` = '-95.461675' ,`PhotoCount` = '15' ,`PostalCode` = '77035' ,`RoomCount` = '7' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Hummingbird' ,`StreetNumber` = '4830' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great 1 story home nestled in the heart of the desirable Willowbend area! It is convenient to the Med Center, museum district, Rice Univ., and Galleria, and a short commute to downtown! The Willow Waterhole is just a few blocks away for dog walking & biking. This neighborhood is easily accessible to all surrounding Freeways. The home is a 3 bedroom, 2 bath with all wood floors with an open concept kitchen with an additional room (thats not on the appraisal district square footage) that could be an office, playroom or additional living room with surrounding windows over looking the spacious backyard. This home can be a great place for you & your family to settle into! Seller offering 2 to 1 Buy down for Buyer to help off set high Interest rates for a reasonable offer (see attachments)' ,`Acres` = '0.1917' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 3 WILLOWBROOK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8350' ,`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` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Willowbrook' ,`TaxAmount` = '5536' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085811' WHERE `Matrix_Unique_ID` = '209675065' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-30T18:00:52.330' ,`MLSNumber` = '36623316' ,`ListAgentFullName` = 'Spencer Huck' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768586' ,`Longitude` = '-95.415415' ,`PhotoCount` = '26' ,`PostalCode` = '77007' ,`RoomCount` = '6' ,`ListPrice` = '649990.00' ,`Status` = 'Active' ,`StreetName` = 'Lester' ,`StreetNumber` = '713' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2387' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction - Expected completion January 2023! Welcome to Lester Oaks by TOMO Homes. Located in the heart of Rice Military/Memorial Park these modern 3 story homes boast nearly 2,400 square feet with a unique open floor plan that features 3 beds, 3.5 baths, second floor living space, large primary and secondary bedrooms, and a second floor balcony off of the spacious living area, perfect for entertaining! Contemporary interior design includes an open kitchen with a quartz waterfall island, rustic oak ASIA cabinetry, Fisher & Paykel stainless steel appliances, European engineered white oak hardwoods throughout, and stainless steel wine cooler.. The primary bedroom features an oversized walk-in closet, frameless glass shower and an elegant soaking tub. Additional features include, walk-in utility room and pantry, pre wired security cameras, and private driveways. Enjoy Nellie Keyes Park, quick freeway access, and walking distance from many bars and restaurants. No HOA! ' ,`Acres` = '0.1148' ,`Area` = '16' ,`BuilderName` = 'Tomo Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 7 & 8 BLK 7 SETTEGAST & DODGE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Settegast & Dodge' ,`TaxAmount` = '8973' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675085811' WHERE `Matrix_Unique_ID` = '214067022' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-30T17:54:47.720' ,`MLSNumber` = '71538172' ,`ListAgentFullName` = 'Spencer Huck' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768965' ,`Longitude` = '-95.415362' ,`PhotoCount` = '38' ,`PostalCode` = '77007' ,`RoomCount` = '7' ,`ListPrice` = '749990.00' ,`Status` = 'Active' ,`StreetName` = 'Lester' ,`StreetNumber` = '711' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2724' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction - Expected completion January 2023! Welcome to Lester Oaks by TOMO Homes. Located in the heart of Rice Military, these modern 3 story homes boast over 2,700 square feet with a unique open floor plan that features 4 beds, 3.5 baths, first floor living space, large primary and secondary bedrooms, and a third floor rooftop terrace with city views, perfect for entertaining! Modern interior design includes an open kitchen with a quartz waterfall island, rustic oak ASIA cabinetry, Fisher & Paykel stainless steel appliances, European engineered white oak hardwoods throughout, and stainless steel wine cooler. The primary bedroom features an oversized walk-in closet, frameless glass shower and an elegant soaking tub. Additional features include walk-in utility room and pantry, pre wired security cameras, and private driveways. Enjoy being right across from Nellie Keyes Park, quick freeway access, and walking distance from Memorial Park and many bars and restaurants. No HOA!' ,`Acres` = '0.1148' ,`Area` = '16' ,`BuilderName` = 'Tomo Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 7 & 8 BLK 7 SETTEGAST & DODGE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Settegast & Dodge' ,`TaxAmount` = '8973' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675085811' WHERE `Matrix_Unique_ID` = '214067879' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-30T17:01:40.390' ,`MLSNumber` = '78953498' ,`ListAgentFullName` = 'Aaron Jistel' ,`ListOfficeName` = 'Listing Spark' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.330484' ,`Longitude` = '-95.618519' ,`PhotoCount` = '25' ,`PostalCode` = '77316' ,`RoomCount` = '6' ,`ListPrice` = '209568.00' ,`Status` = 'Active' ,`StreetName` = 'Beech' ,`StreetNumber` = '6101' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country living at its best! Charming 1-story 3BR, 2B ranch house nestled on 2 wooded lots. Beautifully situated with views of Lake Bonanza from the covered front porch w/ceiling fans to provide cool breeze while sipping your morning coffee. Interior just received a fresh coat of paint throughout and new vinyl plank flooring being installed in kitchen & utility hall. Roomy family/living room w/EPA certified wood stove for cozy family time. Large master BR w/ensuite bath. Family room & master BR receiving new carpeting. Kitchen features white cabinetry w/tile backsplash & built-in breakfast bar. Seller will be installing new dishwasher & gas range. New 40-gallon hot water heater Oct \'22. Stylish 2\" Levolor blinds throughout. Roomy 2nd floor loft for kid\'s area, crafts. Fully fenced backyard with large oak trees. Subdivision amenities include private fishing lake, clubhouse w/pool, horse stables, private airstrip & parks. Montgomery ISD, close to shopping, restaurants & Lake Conroe.' ,`Acres` = '0.334' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE BONANZA 01, BLOCK 9, LOT 14,15' ,`LotDesciption` = 'Other,Water View' ,`LotSize` = '14550' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Ranch' ,`Subdivision` = 'Lake Bonanza 01' ,`TaxAmount` = '1786' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085812' WHERE `Matrix_Unique_ID` = '214649529' --> 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','215108068','1675085812','215108068','2022-11-30T17:07:26.560','9082137','Kate Myhan','JPAR - The Sears Group','','','6.534907','-75.816780','44','00000','7','1200000.00','Active','Via Paso Rea','17 y 19','','Other','9','0','7','31215','Single-Family','Gorgeous and ready for all of your personal touches. 7 bedrooms, 9 bathrooms + butler home. Construction building areas: Building area plus Outdoors areas 10,000 sq ft estimate. (see PDF details). 7 min from Parque de Santa Fe de Antioquia close to city of Medellin in Colombia. This property can be used as retreat destination or your secondary home. Open concept, hot tub, pool , master bedroom upstairs , all other bedrooms downstairs plus separate house for the butler that lives full time on property to maintain it for you. Property surrounded by 12 meters natural fence.','','','Echeverri y Cia,','','','','Sellers Disclosure','','','','','Central Gas','0','Parcelación Pangordito vereda las Estancias','Subdivision Lot','71881','Other','','500','0','','3','','1','In Ground','','','','Other','','','','','Appointment Required','Seller','2','Contemporary/Modern','Parcelación Pangordito','','','Public Sewer,Public Water','2014','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','215213869','1675085812','215213869','2022-11-30T17:36:02.917','23820075','Jeffrey Walters','Virginia Malone Realty','','','29.724636','-94.976502','18','77520','7','165000.00','Active','Duke','503','Street','Baytown','2','0','3','1272','Single-Family','Home on corner lot with lots of room, 3 bedroom, 2 bath with updated appliances and 2 window units to be installed prior to closing.','0.1102','2','','','','','Sellers Disclosure','','','','Baytown/Harris County','Window Unit','0','LTS 5 & 6 BLK 25 MIDDLETOWN','Corner,Other','4800','Appraisal District','','','0','','0','','0','','','','','Composition','23 - Goose Creek Consolidated','CARVER ELEMENTARY SCHOOL (GOOSE CREEK)','LEE HIGH SCHOOL (GOOSE CREEK)','HORACE MANN J H','Appointment Required','Appraisal District','1','Traditional','Middletown','1519','2.97','Public Sewer,Public Water','1950','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','215214239','1675085812','215214239','2022-11-30T17:39:18.223','68673438','Justin Dickey','Keller Williams Professionals','','','29.832877','-95.855808','46','77493','8','463042.00','Active','Blue Sand','27311','Drive','Katy','3','0','4','2543','Single-Family','Beautiful one story with 4 bedrooms, 3 full baths plus study/dining room. Two sinks in primary bath with garden tub and stand-alone shower with seat, XLarge primary closet. High ceilings throughout the home with vestibule in the entry. Granite Kitchen with deep under-mount sink. 42” cabinets, Stainless Steel 5 burner gas range, microwave and dishwasher 2” blinds standard along with windstorm panels, large covered patio. EST Completion May 2023. PICTURES ARE REPRESENTATIVE- Not the actual home.','','25','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Katy - Old Towne','Central Gas','1','Lot 12 BLK 4 Sec 40','Subdivision Lot','7927','Appraisal District','','1330','1','To Be Built/Under Construction','3','Gas Oven','0','','','Gas Cooktop','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Accompany,Leave Business Card','Builder','1','Contemporary/Modern','Sunterra','','3.5','Public Sewer,Public Water','2023','Builder'); --> New record created successfully