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-12T15:12:52.360' ,`MLSNumber` = '22256479' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.229310' ,`Longitude` = '-95.450030' ,`PhotoCount` = '8' ,`PostalCode` = '77302' ,`RoomCount` = '4' ,`ListPrice` = '264990.00' ,`Status` = 'Active' ,`StreetName` = 'Wedge Hill' ,`StreetNumber` = '16825' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1415' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Families will swiftly adapt to the single-story Becket. A spacious owner’s suite and bath combine with two secondary bedrooms for resident comfort, and frame a versatile great room for enjoying endless entertainment and relaxation.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Centex Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '25/2/3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mavera' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090301' WHERE `Matrix_Unique_ID` = '209440365' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T15:14:38.623' ,`MLSNumber` = '53349808' ,`ListAgentFullName` = 'Warren Reed' ,`ListOfficeName` = 'Etheredge Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405026' ,`Longitude` = '-94.896734' ,`PhotoCount` = '27' ,`PostalCode` = '77590' ,`RoomCount` = '9' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = '20th' ,`StreetNumber` = '138' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1938' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Classic 3 bedroom, 2 bathroom home in the heart of Texas City. Beautiful backyard. Established neighborhood with mature trees. Great neighbors. This home is ready for updates or live in the nostalgia of a retro house. Two front doors are a quirky oddity that the new owner will enjoy. Call agent for an appointment Thanks for showing!' ,`Acres` = '0.2666' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 167 PAGE 4 & 5 LOT 24 & W 13 FT OF LOT 23 BLK 15 MAINLA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11613' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'ROOSEVELT-WILSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mainland Park' ,`TaxAmount` = '4157' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675090301' WHERE `Matrix_Unique_ID` = '211620030' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T15:20:39.677' ,`MLSNumber` = '32445906' ,`ListAgentFullName` = 'Anita Turnbow' ,`ListOfficeName` = 'Vylla Home' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.155402' ,`Longitude` = '-95.596907' ,`PhotoCount` = '40' ,`PostalCode` = '77354' ,`RoomCount` = '11' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Carraway' ,`StreetNumber` = '8919' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1760' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this sweet country 4 bedroom 3 bath brick home with HUGE Oak and Pecan trees nestled on approximately 1 acre of land and enjoy a cold glass of tea while you sit on a custom-built swing that hangs from one of the largest trees on the property! This home is located on the Carraway Homestead property which is made up of several privately owned sections. This home also has an additional home that is located behind the family home that can be utilized for extra living space or a separate home office.' ,`Acres` = '1' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Electric,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'A0027 MILLER JOSEPH, TRACT 72, ACRES 1.000' ,`LotDesciption` = 'Other' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Abstract Area 9 (Southeast Magnolia)' ,`TaxAmount` = '3243' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675090301' WHERE `Matrix_Unique_ID` = '211660018' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T16:58:28.303' ,`MLSNumber` = '69330975' ,`ListAgentFullName` = 'Jack McLemore' ,`ListOfficeName` = 'Listing Results, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.764010' ,`Longitude` = '-95.738196' ,`PhotoCount` = '39' ,`PostalCode` = '77450' ,`RoomCount` = '11' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Park Brook' ,`StreetNumber` = '21227' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3143' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 owner home. This is a beautiful 2-story home on a corner lot located in the desirable Memorial Parkway neighborhood. Spacious floorplan, large kitchen and walk-in pantry. All bedrooms are large and spacious. Also has several walk-in attic spaces. Gated backyard. Katy ISD schools. Hurry, this home will go fast!' ,`Acres` = '0.1959' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 34 MEMORIAL PARKWAY SEC 6 R/P' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8533' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MEMORIAL PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MEMORIAL PARKWAY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Memorial Pkwy Sec 06 R/P' ,`TaxAmount` = '5756' ,`TaxRate` = '2.3283' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090302' WHERE `Matrix_Unique_ID` = '211698441' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T15:30:37.200' ,`MLSNumber` = '75384252' ,`ListAgentFullName` = 'Kaleb Monroe' ,`ListOfficeName` = 'Real Broker, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.895579' ,`Longitude` = '-95.074692' ,`PhotoCount` = '41' ,`PostalCode` = '77532' ,`RoomCount` = '6' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Alaska Cedar' ,`StreetNumber` = '610' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely NEW Construction GEM! Enter your new chapter in life with this 3 Bedroom 2 Restroom home with stunning modern day upgrades! Sitting on a 6,718 sqft Lot in Crosby TX, this miraculous home includes ALL NEW Whirlpool Stainless Steel Appliances connected to a HUGE open living room concept covered in tile flooring! NEW soft closed cabinets with plenty of pantry storage, and NEW modern light fixtures! All 3 spacious bedrooms have carpet, beautiful high ceilings, and spacious closet storage as well! Both restrooms have stand up showers. The master restroom has a double sink with an enormous BRAND NEW vanity and to top it off a beautiful bathtub with a window view. ALL NEW sewer lines (2022), NEW water lumping (2022), NEW A/C (2022), NEW electric wiring (2022), and NEW roofing (2022) have been put in place. To add the cherry on top, the backyard of this home is tremendously spacious!! Enjoy a relaxing time under a cover patio with a ceiling fan to fresh your mornings!' ,`Acres` = '0.1542' ,`Area` = '1' ,`BuilderName` = 'Castle Rock' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 PECAN ESTATES SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6718' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Pecan Ests Sec 1' ,`TaxAmount` = '1259' ,`TaxRate` = '3.4068' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090302' WHERE `Matrix_Unique_ID` = '212483055' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T15:21:53.477' ,`MLSNumber` = '48517004' ,`ListAgentFullName` = 'Deborah Coffey' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.367147' ,`Longitude` = '-94.972745' ,`PhotoCount` = '50' ,`PostalCode` = '77568' ,`RoomCount` = '13' ,`ListPrice` = '440000.00' ,`Status` = 'Active' ,`StreetName` = 'Carter' ,`StreetNumber` = '1906' ,`StreetSuffix` = 'Lane' ,`City` = 'La Marque' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '7' ,`SqFtTotal` = '4629' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Priced to sell!! This fully remodeled 4629 sq. ft. home is one you don\'t want to miss. EVERYTHING, walls, floors, insulation, electrical, plumbing, windows, doors, ac, and heating is NEW! It even smells like a new home. The home boasts 5-8 bedrooms and 4.5.bathrooms. 3 of the large rooms upstairs could be utilized as a gym, media room, game room, or library. With a second set of stairs leading from the 3rd garage, yes there are 3 garages, there are two ways to access the second floor. One of the upstairs bedrooms has an added feature of a private vanity just waiting to be finished. The large kitchen is any chef\'s dream. The huge quartz island doubles as a breakfast bar with room for barstools. It even has a fireplace. NO BACK NEIGHBORS!' ,`Acres` = '0.235' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 150 J D MOORE SUR LOT 3 CARTER ADDN' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10238' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Lockbox Left Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Carter Addition' ,`TaxAmount` = '6022' ,`TaxRate` = '2.6428' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090302' WHERE `Matrix_Unique_ID` = '213556170' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T16:03:23.353' ,`MLSNumber` = '59093347' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.563495' ,`Longitude` = '-95.021311' ,`PhotoCount` = '4' ,`PostalCode` = '77586' ,`RoomCount` = '8' ,`ListPrice` = '569990.00' ,`Status` = 'Active' ,`StreetName` = 'Harbourtown' ,`StreetNumber` = '1330' ,`StreetSuffix` = 'Court' ,`City` = 'Seabrook' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2267' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'On the banks of the Seabrook Lagoon, with waters fed by Galveston Bay, you’ll find picturesque Old Seabrook Village! This idyllic neighborhood is just 2 miles from the 60-acre themed Kemah Boardwalk. This new construction 2270 floor plan is a 3-story, 4 bedroom with 3 bath with flex space and gameroom! The kitchen is open and bright featuring 42\" Thimble cabinets, coastal white granite countertops and santorini backsplash. The home will feature carpet in bedrooms, tile in baths and wood flooring in main areas.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 1 Section A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3705' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Old Seabrook Village' ,`TaxAmount` = '' ,`TaxRate` = '2.2' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090302' WHERE `Matrix_Unique_ID` = '214517798' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-12T15:08:03.783' ,`MLSNumber` = '62342801' ,`ListAgentFullName` = 'Anthony Jensen' ,`ListOfficeName` = 'ZAPP Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.277554' ,`Longitude` = '-94.828127' ,`PhotoCount` = '14' ,`PostalCode` = '77551' ,`RoomCount` = '4' ,`ListPrice` = '439900.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue R' ,`StreetNumber` = '5745' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Up for sale is a new construction 4 bedroom, 3.5 bathroom home located within a short drive to the beach. This home offers luxury vinyl plank flooring, tall ceilings, shaker style cabinets, quartz countertops, matte black fixtures, 2 primary suites (one on the first floor and 1 on the second) a double gallery design with a front porch and 2nd floor balcony, vast entertaining or parking space on the ground level and so much more! Come see this coastal charmer today!' ,`Acres` = '0.0746' ,`Area` = '33' ,`BuilderName` = 'Cactusland' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 4 & ADJ N 1/2 OF ALLEY BLK D C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Colorado' ,`TaxAmount` = '823' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090303' WHERE `Matrix_Unique_ID` = '214618584' --> 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','215285556','1675090303','215285556','2022-12-12T15:00:32.693','88486688','Harold Ruiz','Kodu Realty, LLC','','','30.284617','-95.172983','28','77328','3','290000.00','Active','Morgan Cemetery','25106','Road','Cleveland','2','0','3','2000','Single-Family','Come see this custom built ONE STORY 2,000 SqFt home sitting on a large 11,850 SqFt lot. Upgraded stone exterior in the front and custom designed cement board in the back. As you enter you are welcomed by a spacious hallway leading you to 2 secondary bedrooms to your left and garage entry to your right. The hallway leads you to open concept living/dining area. Chef\'s kitchen features plenty of cabinets, granite countertops and upgraded fixtures. Notice the wood look tile throughout the entry, living, dining and kitchen area. High ceiling throughout the home, fans in every room. Oversized primary bedroom on the far back end of the home offering extra privacy. Also, check out the oversized covered patio in the back! WOW! PLUS - low tax rate at 2.07%','','40','SAPEC DESIGN & CON','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','Freestanding','1','Cleveland Area','Central Electric','1','S743500 - NORTH WOODS 01, LOT 63','Cleared,Subdivision Lot,Wooded','11850','Appraisal District','','100','1','Never Lived In','2','Electric Oven','0','','','Electric Cooktop','','Composition','47 - Splendora','GREENLEAF ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Lockbox Front,Vacant/Unoccupied','Builder','1','Traditional','NORTH WOODS 01','','','Aerobic','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','215349705','1675090303','215349705','2022-12-12T16:33:28.283','63343612','John Pham','REALM Real Estate Professional','','','29.774618','-95.422399','40','77007','6','599000.00','Active','Tyne','6007','Street','Houston','3','1','3','2531','Single-Family','Welcome to this luxurious and gated 4-story home which features 3 bedrooms, 3.5 bathrooms, an attached 2-car garage with 240v plug for a Tesla, and a private rooftop terrace just minutes from downtown Houston! This gem is within walking distance of Houston\'s finest restaurants, & entertainment. Easy access to 610 and I-10! The first level offers a spacious guest suite with an ensuite bathroom and private access to the side yard! Head on up to the second level to find your open-concept living, dining, & kitchen areas! The gourmet kitchen offers a stunning waterfall island with quartz counters, marble backsplash, stainless steel appliances, a gas range, under-cabinet lighting, & a large breakfast bar! Decompress next to the fireplace that offers a STUNNING accent wall with contrasting colors that perfectly complement each other. You will find designer touches throughout the entire home. The massive primary suite & another secondary bedroom with private bathroom each on third floor.','0.0539','16','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Other Disclosures,Sellers Disclosure','1','Gaslog Fireplace','1','Rice Military/Washington Corridor','Central Gas','0','LT 1 BLK 1 TYNE STREET PATIO HOMES','Subdivision Lot','2350','Appraisal District','','','0','','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','27 - Houston','MEMORIAL ELEMENTARY SCHOOL (HOUSTON)','LAMAR HIGH SCHOOL (HOUSTON)','HOGG MIDDLE SCHOOL (HOUSTON)','Appointment Required,Supra Keybox','Appraisal District','4','Contemporary/Modern','Tyne Street Patio Homes','10198','2.3307','Public Sewer,Public Water','2007','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','215350100','1675090303','215350100','2022-12-12T16:30:20.433','4422375','Patrick McGrath','Meritage Homes Realty','','','29.818910','-94.870951','16','77523','6','429740.00','Active','Lake Groove','8507','Lane','Baytown','3','1','4','2544','Single-Family','Brand new, energy-efficient home available by Jun 2023! Enjoy this spectacular home with plenty of space for entertaining. The foyer reveals a formal dining room that can be converted to fit your needs. Upstairs you’ll find the game room and secondary bedrooms. From the mid $300s, Heights of Barbers Hill offers access to A-rated schools and major employment centers in Baytown, Mont Belvieu, and the ship channel. Unwind at the planned community pool or exploring the miles of trails. Premier dining, shopping, and recreation are all just minutes from your front door. We also build each home with innovative, energy-efficient features that cut down on utility bills so you can afford to do more living.* Each Meritage® home is built with innovative, energy-efficient features designed to help you enjoy more savings, better health, real comfort and peace of mind.','','53','Meritage Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Chambers County West','Central Electric','1','SF 0151 Plan 3L16C','Subdivision Lot','','','','900','1','To Be Built/Under Construction','2','Convection Oven','0','','','Gas Range','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','No Appointment Required','Builder','2','Contemporary/Modern,Traditional','Heights of Barbers Hill','','3.37','Water District','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','215350437','1675090303','215350437','2022-12-12T16:30:05.643','71020601','Patrick McGrath','Meritage Homes Realty','','','29.819513','-94.870990','16','77523','6','423490.00','Active','Lake Groove','8603','Lane','Baytown','3','1','4','2544','Single-Family','Brand new, energy-efficient home available by June 2023! Enjoy this spectacular home with plenty of space for entertaining. The foyer reveals a formal dining room that can be converted to fit your needs. Upstairs you’ll find the game room and secondary bedrooms. From the mid $300s, Heights of Barbers Hill offers access to A-rated schools and major employment centers in Baytown, Mont Belvieu, and the ship channel. Unwind at the planned community pool or exploring the miles of trails. Premier dining, shopping, and recreation are all just minutes from your front door. We also build each home with innovative, energy-efficient features that cut down on utility bills so you can afford to do more living.* Each Meritage® home is built with innovative, energy-efficient features designed to help you enjoy more savings, better health, real comfort and peace of mind.','','53','Meritage Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Chambers County West','Central Electric','1','SF 0146 Plan 3L16B','Subdivision Lot','','','','900','1','To Be Built/Under Construction','2','Convection Oven','0','','','Gas Range','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','No Appointment Required','Builder','2','Contemporary/Modern,Traditional','Heights of Barbers Hill','','3.37','Water District','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','215350864','1675090303','215350864','2022-12-12T16:29:51.497','56312744','Patrick McGrath','Meritage Homes Realty','','','29.819657','-94.870274','16','77523','6','417290.00','Active','Baytown Heights','8634','Drive','Baytown','3','1','4','2544','Single-Family','Brand new, energy-efficient home available by June 2023! Enjoy this spectacular home with plenty of space for entertaining. The foyer reveals a formal dining room that can be converted to fit your needs. Upstairs you’ll find the game room and secondary bedrooms. From the mid $300s, Heights of Barbers Hill offers access to A-rated schools and major employment centers in Baytown, Mont Belvieu, and the ship channel. Unwind at the planned community pool or exploring the miles of trails. Premier dining, shopping, and recreation are all just minutes from your front door. We also build each home with innovative, energy-efficient features that cut down on utility bills so you can afford to do more living.* Each Meritage® home is built with innovative, energy-efficient features designed to help you enjoy more savings, better health, real comfort and peace of mind.','','53','Meritage Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Chambers County West','Central Electric','1','SF 0135 Plan 3L16C','Subdivision Lot','','','','900','1','To Be Built/Under Construction','2','Convection Oven','0','','','Gas Range','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','No Appointment Required','Builder','2','Contemporary/Modern,Traditional','Heights of Barbers Hill','','3.37','Water District','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','215351148','1675090303','215351148','2022-12-12T16:29:36.440','63555063','Patrick McGrath','Meritage Homes Realty','','','29.819692','-94.869924','6','77523','7','428940.00','Active','Baytown Heights','8626','Drive','Baytown','2','1','4','2585','Single-Family','Brand new, energy-efficient home available by June 2023! Skip your commute and work from home in the quiet main level flex space. The upstairs game room makes a great\r\nmedia or play space. Downstairs, a large walk-in closet and bath complement the private primary suite. From the mid $300s, Heights of Barbers Hill offers access to A-rated schools and major employment centers in Baytown, Mont Belvieu, and the ship channel. Unwind at the planned community pool or exploring the miles of trails. Premier dining, shopping, and recreation are all just minutes from your front door. We also build each home with innovative, energy-efficient features that cut down on utility bills so you can afford to do more living.* Each Meritage® home is built with innovative, energy-efficient features designed to help you enjoy more savings, better health, real comfort and peace of mind.','','53','Meritage Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Chambers County West','Central Electric','1','SF 0133 Plan 880C','Subdivision Lot','','','','900','1','To Be Built/Under Construction','2','Convection Oven','0','','','Gas Range','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','No Appointment Required','Builder','2','Contemporary/Modern,Traditional','Heights of Barbers Hill','','3.37','Water District','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','215351460','1675090303','215351460','2022-12-12T16:29:22.293','59217069','Patrick McGrath','Meritage Homes Realty','','','29.819773','-94.869678','17','77523','3','354480.00','Active','Baytown Heights','8622','Drive','Baytown','2','0','3','1688','Single-Family','Brand new, energy-efficient home available by June 2023! Stock up on everyone’s favorites with plenty of room in the walk-in pantry. The open-concept layout and covered\r\noutdoor living space are great for entertaining. A fourth bedroom is perfect for guests or larger families. From the mid $300s, Heights of Barbers Hill offers access to A-rated schools and major employment centers in Baytown, Mont Belvieu, and the ship channel. Unwind at the planned community pool or exploring the miles of trails. Premier dining, shopping, and recreation are all just minutes from your front door. We also build each home with innovative, energy-efficient features that cut down on utility bills so you can afford to do more living.* Each Meritage® home is built with innovative, energy-efficient features designed to help you enjoy more savings, better health, real comfort and peace of mind.','','53','Meritage Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Chambers County West','Central Electric','1','SF 0132 Plan 830C','Subdivision Lot','','','','900','1','To Be Built/Under Construction','2','Convection Oven,Electric Oven','0','','','Gas Range','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','No Appointment Required','Builder','1','Contemporary/Modern,Traditional','Heights of Barbers Hill','','3.37','Water District','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','215364366','1675090303','215364366','2022-12-12T16:29:06.867','67922051','Patrick McGrath','Meritage Homes Realty','','','29.819702','-94.869440','6','77523','5','410290.00','Active','Baytown Heights','8614','Drive','Baytown','2','1','4','2336','Single-Family','Brand new, energy-efficient home available by June 2023! Unwind in the private main floor primary suite, complete with a sizeable walk-in closet and bath. Upstairs, the kids will love the spacious game room. From the mid $300s, Heights of Barbers Hill offers access to A-rated schools and major employment centers in Baytown, Mont Belvieu, and the ship channel. Unwind at the planned community pool or exploring the miles of trails. Premier dining, shopping, and recreation are all just minutes from your front door. We also build each home with innovative, energy-efficient features that cut down on utility bills so you can afford to do more living.* Each Meritage® home is built with innovative, energy-efficient features designed to help you enjoy more savings, better health, real comfort and peace of mind.','','53','Meritage Homes','','','','Mud','1','','','Chambers County West','Central Electric','1','SF 0130 Plan 870B','Subdivision Lot','','','','900','1','To Be Built/Under Construction','2','','0','','','','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','No Appointment Required','Builder','2','Contemporary/Modern,Traditional','Heights of Barbers Hill','','3.37','Water District','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','215364544','1675090303','215364544','2022-12-12T16:28:49.097','90606713','Patrick McGrath','Meritage Homes Realty','','','29.819647','-94.869250','6','77523','3','355490.00','Active','Baytown Heights','8610','Drive','Baytown','2','0','3','1477','Single-Family','Brand new, energy-efficient home available by June 2023! Prepare dinner at the convenient kitchen island without missing the conversation in the adjacent great room. In the secluded primary suite, a spacious walk-in closet, and a large shower simplify busy mornings. From the mid $300s, Heights of Barbers Hill offers access to A-rated schools and major employment centers in Baytown, Mont Belvieu, and the ship channel. Unwind at the planned community pool or exploring the miles of trails. Premier dining, shopping, and recreation are all just minutes from your front door. We also build each home with innovative, energy-efficient features that cut down on utility bills so you can afford to do more living.* Each Meritage® home is built with innovative, energy-efficient features designed to help you enjoy more savings, better health, real comfort and peace of mind.','','53','Meritage Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Chambers County West','Central Electric','1','SF 0129 Plan 820B','Subdivision Lot','','','','900','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Range','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','No Appointment Required','Builder','1','Contemporary/Modern,Traditional','Heights of Barbers Hill','','3.37','Water District','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','215364636','1675090303','215364636','2022-12-12T16:28:34.963','45505861','Patrick McGrath','Meritage Homes Realty','','','29.819695','-94.868872','6','77523','6','450690.00','Active','Baytown Heights','8606','Drive','Baytown','4','0','5','2844','Single-Family','Brand new, energy-efficient home available by June 2023! Host a game night in the Reynolds sizeable upstairs gameroom. Your guest will enjoy their privacy in the secluded downstairs bedroom. Enjoy your morning coffee in your open concept kitchen. From the mid $300s, Heights of Barbers Hill offers access to A-rated schools and major employment centers in Baytown, Mont Belvieu, and the ship channel. Unwind at the planned community pool or exploring the miles of trails. Premier dining, shopping, and recreation are all just minutes from your front door. We also build each home with innovative, energy-efficient features that cut down on utility bills so you can afford to do more living.* Each Meritage® home is built with innovative, energy-efficient features designed to help you enjoy more savings, better health, real comfort and peace of mind.','','53','Meritage Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Chambers County West','Central Electric','1','SF 0128 Plan 890B','Subdivision Lot','','','','900','1','To Be Built/Under Construction','2','Convection Oven','0','','','Gas Range','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','No Appointment Required','Builder','2','Contemporary/Modern,Traditional','Heights of Barbers Hill','','3.37','Water District','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','215365122','1675090303','215365122','2022-12-12T16:27:59.007','35951675','Patrick McGrath','Meritage Homes Realty','','','29.819722','-94.868677','17','77523','6','439440.00','Active','Baytown Heights','8546','Drive','Baytown','2','1','4','2764','Single-Family','Brand new, energy-efficient home available by June 2023! Two story with more to adore. A formal dining room flows to the vast kitchen, casual meal spot & family oasis. Upstairs bed, game & media rooms hide from the tranquil downstairs primary suite. Oversized walk-in closet. From the mid $300s, Heights of Barbers Hill offers access to A-rated schools and major employment centers in Baytown, Mont Belvieu, and the ship channel. Unwind at the planned community pool or exploring the miles of trails. Premier dining, shopping, and recreation are all just minutes from your front door. We also build each home with innovative, energy-efficient features that cut down on utility bills so you can afford to do more living.* Each Meritage® home is built with innovative, energy-efficient features designed to help you enjoy more savings, better health, real comfort and peace of mind.','','53','Meritage Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Chambers County West','Central Electric','1','SF 0126 Plan 3L08B','Subdivision Lot','','','','900','1','To Be Built/Under Construction','2','Convection Oven','0','','','Gas Range','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','No Appointment Required','Builder','2','Contemporary/Modern,Traditional','Heights of Barbers Hill','','3.37','Water District','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','215542500','1675090303','215542500','2022-12-12T15:13:58.563','5201586','Justin Dickey','Keller Williams Professionals','','','29.832870','-95.855810','20','77493','11','430727.00','Active','Acapulco Mist','5342','Drive','Katy','2','1','4','2715','Single-Family','Beautiful Colina Home with 4 bedrooms, 2.5 baths, and study there\'s room for everyone! Large study located downstairs. Master bedroom located downstairs just outside the huge living room large enough for the whole family to get together for special occasions and holidays. Beautiful kitchen with upgraded 42\" cabinets, granite countertops, stainless steel appliances and is open to the oversized family room. The master suite features a large walk in closet and a spacious bath with a relaxing soaker tub and separate shower. Large game room located upstairs with a view to the first floor, 3 car garage included. 2\" faux wood blinds save you money and provide privacy from day one. The in wall pest control system protects your home. EST completion MAY 2023!! Photos are REPRESENTATIVES!!!','','25','Colina Homes','','Electric Dryer Connections,Gas Dryer Connections','','No Disclosures','1','','','Katy - Old Towne','Central Gas','1','Lot 9 Block 4 Sec 40','Subdivision Lot','11336','Survey','','1330','1','To Be Built/Under Construction','3','','0','','','Freestanding Range,Gas Cooktop,Gas Range','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Builder','2','Traditional','Sunterra','','3.5','Public Sewer,Public Water,Water District','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','215544492','1675090303','215544492','2022-12-12T15:47:57.177','94896389','Edwin Ortiz','NuWay Realty Group LLC','','','30.159041','-95.071551','20','77327','3','183888.00','Active','Road 5102 I','108','','Cleveland','2','0','3','1232','Single-Family','Come check out this brand new home!! It is a great starter home for someone that want to add their finishing touches. It still missing a few things to be completed. House has lots of potential.','0.32','52','','','','','Sellers Disclosure','','','','Cleveland Area','Central Electric','0','SANTA FE, SEC 3, BLOCK 44, LOT 4693, ACRES .32','Cleared','13939','Appraisal District','','','0','','0','','0','','','','','Wood Shingle','100 - Cleveland','COTTONWOOD SCHOOL (CLEVELAND)','CLEVELAND HIGH SCHOOL','CLEVELAND MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Other Style','SANTA FE, SEC 3','2182','2.0417','Public Sewer,Public Water','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','215545652','1675090303','215545652','2022-12-12T16:29:36.597','45043753','Justin Dickey','Keller Williams Professionals','','','29.832859','-95.855808','29','77493','10','367590.00','Active','Costa Ridge','5315','Lane','Katy','3','0','4','2050','Single-Family','Colina Homes- Single Story: Elegant entry with coffered tall ceilings, 4 bedrooms, 3 baths location in our gated section of Sierra Vista! Spacious master closet with his/her sinks and sep. tub\r\nand shower. Tons of Beautiful Finishes included!!Gorgeous kitchen with stunning cabinets, granite\r\nand tiled backslash , Perfect backyard and a Large covered back patio ready for weekend BBQ\'s.\r\nYou\'re going to Love it! Situated in one of Katy\'s best communities. and offers everything your\r\nare looking in a family friendly community- amenities located in Sunterra, Crystal Lagoon coming soon! PHOTOS ARE REPRESENTATIVE.','','25','Colina Homes','','Electric Dryer Connections','','No Disclosures','1','','','Katy - Old Towne','Central Gas','1','Lot 16 Block 4 Sec 40','Corner,Subdivision Lot','8123','Survey','','1300','1','To Be Built/Under Construction','3','','0','','','Freestanding Range,Gas Cooktop,Gas Range','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Accompany','Builder','1','Traditional','Sunterra','','3.5','Public Sewer,Public Water,Water District','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','215546298','1675090303','215546298','2022-12-12T16:27:06.220','37374490','Bradley Tiffan','Legend Home Corporation','','','29.831077','-95.805148','38','77493','6','279990.00','Active','Landolfi','24922','Drive','Katy','2','1','3','1849','Single-Family','Love where you live in Camillo Lakes in Katy, TX! The Chestnut floor plan is a charming 2-story home with 3 bedrooms, 2.5 bathrooms, and 2-car garage! This home has it all, including blinds, upgraded carpeting in the bedrooms, and NO BACK NEIGHBORS! The first floor offers the perfect entertainment space with vinyl plank flooring and a large kitchen island overlooking the family and dining rooms! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless steel appliances! The second floor offers a private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring double sinks, a sizable shower, and spacious walk-in closet! Secondary bedrooms have walk-in closets, too! Enjoy the great outdoors with full sod, sprinkler system, and a covered patio! Don\'t miss your opportunity to call Camillo Lakes home, schedule a visit today!','','25','Legend Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Katy - Old Towne','Central Gas','1','LT 66 BLK 1','Cul-De-Sac,Subdivision Lot','2645','Appraisal District','','875','1','Never Lived In','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','30 - Katy','LEONARD ELEMENTARY SCHOOL (KATY)','PAETOW HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','2','Traditional','Camillo Lakes','','3.53','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','215546762','1675090303','215546762','2022-12-12T16:40:51.217','63753599','Justin Dickey','Keller Williams Professionals','','','29.832916','-95.855864','33','77493','8','447450.00','Active','Costa Ridge','5306','Lane','Katy','3','1','4','2922','Single-Family','This gorgeous Colina Home has amazing offerings! When you walk through the front door you will feel right at home. This home offers 4bedrooms,3.5bathrooms, dining & 3car garage! The living room, kitchen, area are open to each other with high ceilings. The kitchen features oversized island with seating,42\" cabinetry, & spacious walk-in pantry. The primary bedroom is tucked away in the back of home with a spacious en suite bathroom & walk in closet. There is a Huge covered back patio great for grilling and fun, Lakes & Parks. Crystal Lagoon coming soon!','','25','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Katy - Old Towne','Central Gas','1','Lot 21 Block 4 Sec 40','Subdivision Lot','7500','Survey','','1300','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','2','Contemporary/Modern','Sunterra','','','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','215547316','1675090303','215547316','2022-12-12T16:48:02.170','78377633','Justin Dickey','Keller Williams Professionals','','','29.832916','-95.855864','33','77493','8','468970.00','Active','Acapulco Mist','5319','Drive','Katy','3','1','4','2922','Single-Family','This gorgeous Colina Home has amazing offerings! When you walk through the front door you will feel right at home. This home offers 4bedrooms,3.5bathrooms, dining & 3car garage! The living room, kitchen, area are open to each other with high ceilings. The kitchen features oversized island with seating,42\" cabinetry, & spacious walk-in pantry. The primary bedroom is tucked away in the back of home with a spacious en suite bathroom & walk in closet. There is a Huge covered back patio great for grilling and fun, Lakes & Parks. Crystal Lagoon coming soon!','','25','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Katy - Old Towne','Central Gas','1','Lot 11 Block 2 Sec 40','Subdivision Lot','7500','Survey','','1300','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','2','Contemporary/Modern','Sunterra','','','Public Sewer,Public Water','2023','Builder'); --> New record created successfully