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-29T11:27:00.313' ,`MLSNumber` = '61792465' ,`ListAgentFullName` = 'Linda Miner' ,`ListOfficeName` = 'R. Alexa Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.778440' ,`Longitude` = '-95.396965' ,`PhotoCount` = '41' ,`PostalCode` = '77007' ,`RoomCount` = '7' ,`ListPrice` = '3600000.00' ,`Status` = 'Active' ,`StreetName` = 'Heights' ,`StreetNumber` = '420' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4025' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Outstanding Victorian Replica Built In 2007 Includes Separate Guest Quarters/Office & Double Garage w/Garage Apartment All On 15,000 Sq.Ft. Of Land In Premiere Location. COMMERCIAL/RESIDENTIAL PROPERTY. The Main House Boasts Five Bedrooms, Four Full Baths & Two Half-Baths. Porte-Cochere On South Side Of Main House With Second-Floor Room Above. Dramatic Staircase As You Enter w/12\' High Ceilings On First & 11\' High Ceilings On Second Floors Plus Finished Third Floor. Wrought-Iron Fencing With Motorized Gate. Masterfully Constructed With Period Finishes To Showcase This Victorian Beauty. NO FLOODING DURING HURRICANE HARVEY! Click The Virtual Tour Icon Above Primary Photo To See More Of The Property.' ,`Acres` = '0.3444' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 16 & 17 BLK 301 HOUSTON HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HARVARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Victorian' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '44176' ,`TaxRate` = '2.39' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675085340' WHERE `Matrix_Unique_ID` = '197027979' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T12:03:58.897' ,`MLSNumber` = '21467325' ,`ListAgentFullName` = 'Patricia Taylor' ,`ListOfficeName` = 'Coldwell Banker Ultimate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.051810' ,`Longitude` = '-95.636448' ,`PhotoCount` = '16' ,`PostalCode` = '77422' ,`RoomCount` = '6' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 747A' ,`StreetNumber` = '4862' ,`StreetSuffix` = '' ,`City` = 'Brazoria' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2522' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'San Bernard River area home. The home situated on a .83-acre lot and also includes the .51-acre adjacent lot. Some recent renovation completed with projects still ongoing. PLUS, oversized approximately 756 sq.ft. garage, 352 sq.ft. storage space - workshop area and recently renovated approximately 400 sq.ft. apartment. Bedrooms are oversized with sitting areas or activity spaces. River is just across the street. Home and .8554-acre Lot may be purchased separately. Please call Listing Agent for Pricing.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric,Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'Lots 37C + 37E' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Allhands Subdivision' ,`TaxAmount` = '1800' ,`TaxRate` = '' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085340' WHERE `Matrix_Unique_ID` = '209444748' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T11:04:29.627' ,`MLSNumber` = '30577743' ,`ListAgentFullName` = 'Lori May' ,`ListOfficeName` = 'Mary Dunn Real Estate, Inc.' ,`SellingAgentFullName` = 'Janae Allnutt' ,`SellingOfficeName` = 'Fathom Realty' ,`Latitude` = '29.841073' ,`Longitude` = '-94.858562' ,`PhotoCount` = '33' ,`PostalCode` = '77523' ,`RoomCount` = '6' ,`ListPrice` = '379900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Travis' ,`StreetNumber` = '10215' ,`StreetSuffix` = 'Lane' ,`City` = 'Mont Belvieu' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1897' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your best life can be in this beautiful home in Crown Colony. Enjoy the low taxes in BHISD as well as the wonderful amenities in the City of Mont Belvieu! The exterior includes detached garage with a nice spacious breeze way. Beautiful back patio area that looks out into the backyard with an above ground swimming pool. A nice 12x15 shed. This property sits on almost a 1/2 acre (.482). The interior features gorgeous floors throughout the main living areas, a wood burning fireplace. Spacious family room. The front room can be a dining room, media or a study. 3 bedrooms w/hall bath. The master suite is very spacious and has access to the back patio area. The breakfast area includes 2 access areas to the garage and to the back patio area. Utility Room is located off of the breakfast area. NO HOA and LOW CHAMBERS COUNTY TAXES. Conveniently located within minutes to BHISD and the City Park!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lt 24 Blk 5 Crown Colony Sec 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crown Colony' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085341' WHERE `Matrix_Unique_ID` = '210568384' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T12:04:43.387' ,`MLSNumber` = '35257763' ,`ListAgentFullName` = 'Patricia Taylor' ,`ListOfficeName` = 'Coldwell Banker Ultimate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.066982' ,`Longitude` = '-95.498059' ,`PhotoCount` = '47' ,`PostalCode` = '77566' ,`RoomCount` = '6' ,`ListPrice` = '747685.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou' ,`StreetNumber` = '2202' ,`StreetSuffix` = 'Drive' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '2946' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning and exceptional custom-built home is filled with original elements expected in a Mastercraft Builder’s Home. This home’s traditional styling and original, timeless design elements are second to none. Thoughtful and complex design components blend its meticulous and modern features with sophisticated comfort. The harmonious design keeps both relaxation and function in perfect balance, whether indoors or outdoors. With a precise building and superb construction approach, the builder/owner has honored the home\'s character by seamlessly blending impeccable craftsmanship and traditional character with modern lifestyle amenities. Every detail was carefully selected and quality crafted.\r\n\r\nFabulous - Timeless - Sophisticated - Functional. Any, or all, of these words, can accurately describe this gorgeous and quality-built home at 2202 Bayou Drive (County Road 682G) Lake Jackson.' ,`Acres` = '1.06' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 22 (1.06 Acres)' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugar Mill East' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085341' WHERE `Matrix_Unique_ID` = '210676930' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T11:14:25.013' ,`MLSNumber` = '96006862' ,`ListAgentFullName` = 'Camilia Mack' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.030320' ,`Longitude` = '-95.104010' ,`PhotoCount` = '31' ,`PostalCode` = '77336' ,`RoomCount` = '6' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Colony Meadow Trail' ,`StreetNumber` = '24814' ,`StreetSuffix` = 'Trail' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2082' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HONEY STOP THE CAR, THIS IS IT!!! Welcome to your home in the newly unincorporated community of Woodland Lakes located northeast of Houston, this community in Huffman boasts a beautiful setting with rustic charm and convenient access to a variety of regional attractions. You’ll enjoy close proximity to Lake Houston, offering boating, fishing and other recreational activities. Local grocery stores include HEB, Kroger and Walmart. And city amenities are also within easy reach, with quick routes to downtown Houston, George Bush Intercontinental Airport, the popular Deerbrook Mall and more. This home is newly constructed, less than one year old. The elementary is within walking distance and this small quaint community is ready for you to call it \"Home\"!! Call your trusted Realtor and have them schedule a tour!! Won\'t last long! New construction without the wait!!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Century' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Blk 2 Woodland Lakes Sec 4' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675085341' WHERE `Matrix_Unique_ID` = '211594697' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T11:16:46.767' ,`MLSNumber` = '52750600' ,`ListAgentFullName` = 'Cheree Rose' ,`ListOfficeName` = 'Sunrise Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.386944' ,`Longitude` = '-95.119640' ,`PhotoCount` = '27' ,`PostalCode` = '77517' ,`RoomCount` = '7' ,`ListPrice` = '249950.00' ,`Status` = 'Active' ,`StreetName` = '2nd' ,`StreetNumber` = '14414' ,`StreetSuffix` = 'Street' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1376' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home sits on a Stunning .386 acres Corner Lot in the heart of Santa Fe, lined with Beautiful Mature Pecan & Shade Trees all around. 140 ft rd frontage on 2nd St & 120 ft. rd frontage on Terry St., plenty of space to build a huge metal building or workshop if you want. No need for a well or septic, this one has public utilities and is in the heart of SFISD! Back yard is fenced for pets and attached garage is oversized, no neighbors to the right either. Come inside and enjoy original hardwood flooring, gas cooking, en-suite bath for owner\'s retreat. Great kitchen for the foodie enthusiast in your family! Versatile 3 or 4 bedrooms and 2 full bathrooms. Washer/dryer connections have been run to a flex room inside home and to garage, so utilize however you see fit. Must see, not many homes priced at this level in Santa Fe and on such a beautiful piece of land, make your appointment to view this beautiful property soon!' ,`Acres` = '0.3857' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 604 I & G N RR SUR SEC 16 LOTS 4 & 5 BLK 17 ARCADIA TOW' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '16800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'ROY J. WOLLAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Arcadia Townsite' ,`TaxAmount` = '2887' ,`TaxRate` = '2.9382' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085341' WHERE `Matrix_Unique_ID` = '211748926' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T11:10:38.273' ,`MLSNumber` = '18245749' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Delia Peters' ,`SellingOfficeName` = 'JPAR-The Sears Group' ,`Latitude` = '29.832859' ,`Longitude` = '-95.855573' ,`PhotoCount` = '19' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '344990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sunrise Gables' ,`StreetNumber` = '1577' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1867' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING NEW CONSTRUCTION! Beautiful brick and stone exterior. 4 bedroom!! High Ceilings, Luxury Hard Surface Flooring, Stainless Appliances with 5 Burner Cooktop, Quartz countertops, grey ceramic tile backsplash & 42\" White Kitchen Cabinetry with Under Cabinet Lighting, Primary Bath with Separate Tub & Shower, Tankless Water Heater, Oversized Covered Patio, & Full Sprinkler System! WOW! Open Concept Interior Design with Island Kitchen Open to Spacious Dining & Living Areas! Privately Located Primary Suite with Pretty Garden Bath & Walk-In Closet! Indoor Utility Room! Zoned to Katy ISD Schools! Unbelievable Community with Crystal Lagoon & Amenity Center with Clubhouse, Playground, Trails, Pool, PLUS MORE! Easy Access to the Grand Parkway! Estimated Completion - February 2023' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '20/1/15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6665' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675085342' WHERE `Matrix_Unique_ID` = '212235847' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T12:42:10.860' ,`MLSNumber` = '63586535' ,`ListAgentFullName` = 'Margaret Broussard' ,`ListOfficeName` = 'Coldwell Banker Southern Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.106873' ,`Longitude` = '-94.165654' ,`PhotoCount` = '29' ,`PostalCode` = '77706' ,`RoomCount` = '12' ,`ListPrice` = '1550000.00' ,`Status` = 'Active' ,`StreetName` = 'Estates Of Montclaire' ,`StreetNumber` = '2' ,`StreetSuffix` = '' ,`City` = 'Beaumont' ,`BathsFull` = '4' ,`BathsHalf` = '3' ,`BedsTotal` = '6' ,`SqFtTotal` = '4806' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home located in the gated community of The Estates of Montclaire and is positioned on over 1 acre of land. This French style Chateau has 6 bedrooms, 4 full baths, and 3 half baths, 2 fireplaces, double crown mouldings, and ironwork. There is a grand theater, beautiful gourmet kitchen with built-in bar, game room, workout room, and huge primary suite with spa bath and large walk-in shower. Outside amenities are many...tiki bar, pool, outdoor kitchen, and a 4-car garage.' ,`Acres` = '1.01' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MONTCLAIRE PHASE 1 LOT 2 BLK 2' ,`LotDesciption` = 'Other' ,`LotSize` = '43996' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'REGINAL-HOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'French' ,`Subdivision` = 'Montclaire Ph 1' ,`TaxAmount` = '26652' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085342' WHERE `Matrix_Unique_ID` = '213244448' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T12:36:15.843' ,`MLSNumber` = '35309666' ,`ListAgentFullName` = 'Blake Yarborough' ,`ListOfficeName` = 'The Yarborough Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.634421' ,`Longitude` = '-95.365094' ,`PhotoCount` = '15' ,`PostalCode` = '77047' ,`RoomCount` = '5' ,`ListPrice` = '194900.00' ,`Status` = 'Active' ,`StreetName` = 'Botany' ,`StreetNumber` = '3907' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1196' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy 3 bedroom 1 bath home w/ laminate flooring in the family and den area. Spacious living room, utility room is located in the home. Fenced backyard. Minutes away from Downtown Houston, University of Houston, Medical Center and Museum District! Schedule your appointment TODAY !\r\n\r\nNew Roof , Foundation leveling Paint and Shower Surround as of November 2022\r\n\r\nUpdated Pics to follow' ,`Acres` = '0.1515' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 9 CLOVERLAND SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial' ,`Subdivision` = 'Cloverland Sec 01' ,`TaxAmount` = '2301' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085342' WHERE `Matrix_Unique_ID` = '213516614' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T11:35:29.077' ,`MLSNumber` = '84518003' ,`ListAgentFullName` = 'Shermae Lopez' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.181916' ,`Longitude` = '-96.279362' ,`PhotoCount` = '8' ,`PostalCode` = '77437' ,`RoomCount` = '3' ,`ListPrice` = '174999.00' ,`Status` = 'Active' ,`StreetName` = 'Sam St' ,`StreetNumber` = '1311' ,`StreetSuffix` = '' ,`City` = 'El Campo' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1278' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is a one story Plan with 3 bedrooms, 2 bath home, open concept kitchen overlooking the large living-dining combo, which makes it perfect for entertaining. Vinyl plank flooring in living areas and plush carpet in the bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home. The Energy efficient features in the home will be reflected in your utility bills. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows, ENERGY EFFICIENT! \r\nWarranty: 1 yr workmanship & materials, 2 yr on all systems- plumbing, electrical, HVAC & other Mechanical Systems, 10 yr Major Structural components' ,`Acres` = '0.151' ,`Area` = '55' ,`BuilderName` = 'Censeo Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'NA' ,`LotDesciption` = 'Other' ,`LotSize` = '6578' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'NA' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675085342' WHERE `Matrix_Unique_ID` = '213750843' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T11:24:50.353' ,`MLSNumber` = '60025486' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835287' ,`Longitude` = '-95.854881' ,`PhotoCount` = '12' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '354594.00' ,`Status` = 'Active' ,`StreetName` = 'Catalina Cove' ,`StreetNumber` = '200' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2108' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Montauk plan features four bedrooms, two full bathrooms, and spacious walk-in closets!' ,`Acres` = '0.1408' ,`Area` = '25' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S800002 SUNTERRA SECTION 2 BLK 1 LOT 35' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6465' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.658234' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675085343' WHERE `Matrix_Unique_ID` = '214062100' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T12:56:11.017' ,`MLSNumber` = '40452282' ,`ListAgentFullName` = 'Jessica Smith' ,`ListOfficeName` = 'Coldwell Banker Ultimate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.004948' ,`Longitude` = '-95.298199' ,`PhotoCount` = '31' ,`PostalCode` = '77541' ,`RoomCount` = '5' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Treasure' ,`StreetNumber` = '107' ,`StreetSuffix` = 'Lane' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located on the canal in Hide-A-Way on the Gulf, you\'ll find a spacious 3 bed/ 2 bath home with some amazing amenities! Enjoy island life in this open floor plan at 107 Treasure Lane. It rests above a 3-car garage and includes an enclosed elevator that will allow your guests to visit with ease. Under a vaulted ceiling with recessed lighting, you\'ll have ample space to move about comfortably. Beautiful wood laminate runs seamlessly throughout most of the home. The family room is open to an island kitchen where you\'ll find plenty of room to enjoy casual dining. Granite countertops blend perfectly with dark, rich cabinets. You\'ll love sipping coffee as you enjoy dessert on the balcony! An office bathed in natural light offers access to a glorious deck overlooking the canal under which a boat slip is located. Relax on the deck or in the shade of a screened-in sunroom. A ground-level covered patio is another shaded place to relax and visit with friends. Live the life you love near the gulf!' ,`Acres` = '0.1927' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HIDE-A-WAY ON GULF UNIT 1 (A0009 B T ARCHER) LOT 188' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '8394' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Photos/No Videos,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hide-A-Way On Gulf' ,`TaxAmount` = '8318' ,`TaxRate` = '2.2069' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085343' WHERE `Matrix_Unique_ID` = '214107565' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T12:46:35.853' ,`MLSNumber` = '3490812' ,`ListAgentFullName` = 'Juli Morman' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.675032' ,`Longitude` = '-95.058469' ,`PhotoCount` = '44' ,`PostalCode` = '77571' ,`RoomCount` = '7' ,`ListPrice` = '398900.00' ,`Status` = 'Active' ,`StreetName` = 'H' ,`StreetNumber` = '11226' ,`StreetSuffix` = 'Street' ,`City` = 'La Porte' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2186' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this one story on over an acre and bring all your animals!!! Enter the home to an open concept, Living, breakfast and kitchen with a walk-in pantry! Tile is throughout the entire home so no carpet! The living room has gorgeous wood beams that accent the tall ceilings. This home features 4 bedrooms and 3 full bathrooms. One of the bedrooms and bathrooms has its own access from outside and also has all the stub outs ready for a kitchenet perfect for a guest or renter. All bathrooms have been updated. Utility room is inside. Roof was replaced 3 years ago! Call today for your private showing!' ,`Acres` = '1.0013' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 471D & 471D-1 LA PORTE OUTLOTS' ,`LotDesciption` = 'Other' ,`LotSize` = '43616' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LOMAX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LOMAX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'La Porte Outlots' ,`TaxAmount` = '7696' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085343' WHERE `Matrix_Unique_ID` = '214188741' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T11:47:11.460' ,`MLSNumber` = '90269240' ,`ListAgentFullName` = 'Melissa Martin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.406823' ,`Longitude` = '-95.214362' ,`PhotoCount` = '48' ,`PostalCode` = '77511' ,`RoomCount` = '5' ,`ListPrice` = '745000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 531' ,`StreetNumber` = '3190' ,`StreetSuffix` = '' ,`City` = 'Alvin' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2397' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Do you want to come home to the serenity of 10 green acres? This spacious house is beautiful both inside and out and offers a quiet escape while being near town. Step inside and walk through the formal entryway to the open living room. You will find the connected living and dining are the heart of the home! The roomy kitchen has a gas cooktop and plenty of counter space for cooking and serving. All four bedrooms have walk in closets. The doorways and third full bathroom meet ADA standards. \r\n\r\nThe seller is open to giving the buyer a credit for floors and paint.\r\n\r\nHouse has shared drive way.' ,`Acres` = '10' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0481 H T & B R R, TRACT 35-36 (E/2), ACRES 10.00' ,`LotDesciption` = 'Other' ,`LotSize` = '435600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'WALT DISNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'H T & B R R' ,`TaxAmount` = '6279' ,`TaxRate` = '2.2174' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085343' WHERE `Matrix_Unique_ID` = '214512926' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T11:18:30.923' ,`MLSNumber` = '57410445' ,`ListAgentFullName` = 'Kayla Brisbin' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.418473' ,`Longitude` = '-94.697672' ,`PhotoCount` = '40' ,`PostalCode` = '77650' ,`RoomCount` = '9' ,`ListPrice` = '1156000.00' ,`Status` = 'Active' ,`StreetName` = 'Ranger' ,`StreetNumber` = '4416' ,`StreetSuffix` = 'Drive' ,`City` = 'Port Bolivar' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2556' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Better than new, this custom home is equipped w/DOUBLE fridge, DOUBLE washer&dryer, & comes FULLY FURNISHED! Enchanted w/cool coastal colors, soaring ceilings, shiplap walls, sand shower & downstairs bar to name a few. More than enough room for everyone (sleeps 22). Entertain year round in the fully equipped open plan kitchen featuring custom cabinetry, beautiful blue tile backsplash, & 11-foot-long island w/BF seating. The primary features a ship lap wall, spa-like ensuite w/double sinks, vanity, soaking tub, & walk-in shower w/dual head & rainfall shower system. Upstairs are 2 large bedrooms w/ensuite baths, game room (adds aprox. 239 sqft to 2556 sqft), locked storage room & 2nd story deck. Enjoy the ease of the cargo lift, owners closet w/keypad lock & owners garage; perfect for managing renters. Walk to the beach where it\'s wider & less congested. Close to Bolivar Yacht Basin for easy access to East Galveston Bay & minutes away from the the ferry & all Crystal Beach has to offer!' ,`Acres` = '0.1573' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Port Bolivar' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HOLIDAY SHORES REPLAT (2007) ABST203, BLOCK 3, Lot 17' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6851' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Holiday Shores' ,`TaxAmount` = '9794' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085344' WHERE `Matrix_Unique_ID` = '214543025' --> 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','214999135','1675085344','214999135','2022-11-29T11:04:02.827','42225843','Pompello Rubio','Texas Key Holders Real Estate','','','29.812291','-95.362811','16','77009','7','700000.00','Active','Eleanor','614','Street','Houston','1','1','3','1622','Single-Family','LOCATION, LOCATION, LOCATION!!!Original hardwood floors, great layout, plenty of room to grow. This is a property that needs some love but has high potential. This property is conveniently located 610 and Irvington, minutes from the metro train, minutes to downtown Houston, and minutes to the heights. The property comes with the lot next door totaling 10,600 SqFt.','0.2433','9','','','','','Sellers Disclosure','1','Freestanding,Wood Burning Fireplace','1','Northside','Central Gas','0','LTS 9 & 10 BLK 6 LINDALE PARK SEC 1','Subdivision Lot','10600','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Cooktop','','Composition','27 - Houston','JEFFERSON ELEMENTARY SCHOOL (HOUSTON)','NORTHSIDE HIGH SCHOOL','MARSHALL MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Lindale Park Sec 01','10514','2.3307','Public Sewer,Public Water','1945','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','215126901','1675085344','215126901','2022-11-29T12:23:31.717','88608709','Cyndi Kornegay','Gatehouse Properties','','','30.156195','-95.396801','11','77385','12','649850.00','Active','Kingly Pine','2806','Trail','Conroe','4','1','5','3619','Single-Family','This stunning 2-story home is located in the elegant community of The Meadows at Imperial Oaks. As you enter this amazing home, you are greeted by a grand foyer with soaring ceilings. Continuing into the heart of the home, you will adore the open-concept floor plan. The spacious gourmet kitchen is highlighted by G.E. appliances and an oversized island that overlooks the family room. Located downstairs, guests or family will enjoy the secondary bedroom with full private bath. Upstairs you will find 3 additional bedrooms with 2 full baths plus a game room. As the sun begins to set, escape to the large Texas-sized covered patio and relax. Located on a quiet cul-de-sac and complete with a study and a 3-car tandem garage, you do not want to miss out on this home!','','15','Coventry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','Gaslog Fireplace','1','Spring Northeast','Central Gas','1','Lot 6 Block 1','Subdivision Lot','8295','Survey','','600','1','To Be Built/Under Construction','3','Electric Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','KAUFMAN ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','2','Traditional','The Meadows at Imperial Oaks','','3.3','Public Sewer,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','215127673','1675085344','215127673','2022-11-29T12:22:26.963','38594978','Cyndi Kornegay','Gatehouse Properties','','','30.154827','-95.396020','10','77385','10','564989.00','Active','Kingly Pine','2839','Trail','Conroe','4','0','4','2867','Single-Family','This amazing one-story is quickly becoming a huge favorite. Boasting 14-foot ceilings from the kitchen through the family room, this home is full of exquisite details that will have you amazed. Located just off the main living area, elegant french doors welcome you into the study where you can easily work from home. The secluded primary suite provides a beautiful bay window perfect for a sitting area and offers a double closet off of the lavish primary bath. Every bedroom in the home features its own bathroom, perfect for guests and children. This home truly has it all. Entertaining will be a breeze in this home equipped with a game room, fireplace and a large covered patio, plus an over-sized 3-car tandem garage. Schedule your appointment today!','','15','Coventry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','Gaslog Fireplace','1','Spring Northeast','Central Gas','1','Lot 2 Block 3','Subdivision Lot','8556','Survey','','600','1','To Be Built/Under Construction','3','Electric Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','KAUFMAN ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','1','Contemporary/Modern,Traditional','The Meadows at Imperial Oaks','','3.3','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215151418','1675085344','215151418','2022-11-29T12:13:15.393','62261880','Cyndi Kornegay','Gatehouse Properties','','','29.812976','-95.842298','16','77493','12','831269.00','Active','Shoreline View','6943','Drive','Katy','3','1','4','3838','Single-Family','A New Coventry Home located on a lake lot in the beautfiul master-planned community, Cane Island! Highly sought after Katy ISD! This dreamy home features a contemporary front elevation with stately double front doors. Step inside and be greeted by a grand 2 story ceiling with a curved stair case followed by an impressive rotunda. The Media room and gameroom are both located on the first floor, perfect for entertaining family and friends. Wait, there is more! A 2nd Gameroom is even located upstairs! Enjoy a beautiful Katy sunset on the Texas-sized patio. Plenty of storage space in the 3 car garage! Beautiful new home finishes, durable wood-like tile floors in the main areas and light and bright Quartz countertops in the kitchen. Make an appointment to see this gorgous home today! Interior photos are of this floorplan previously built, not of this actual property, selections may vary.','','25','Coventry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','Gaslog Fireplace','1','Katy - Old Towne','Central Gas','1','Lot 15 Block 1','Cul-De-Sac,Water View','9603','Survey','','1200','1','To Be Built/Under Construction','3','Convection Oven,Electric Oven','0','','','Gas Cooktop','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','KATY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','2','Contemporary/Modern,Traditional','Cane Island','','3.34','Public Sewer,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','215154982','1675085344','215154982','2022-11-29T12:58:14.550','74937041','Justin Dickey','Keller Williams Professionals','','','29.832866','-95.855819','31','77493','5','397600.00','Active','Acapulco Mist','5326','Drive','Katy','2','0','3','1830','Single-Family','Colina Homes- Single Story: Elegant entry with coffered tall ceilings, bedrooms, 2 baths, located in our gated section of Sierra Vista! Spacious master closet with his/her sinks and sep. tub and shower. Tons of Beautiful Finishes included!!Gorgeous kitchen with stunning cabinets, granite and tiled backslash , Perfect backyard and a Large covered back patio ready for weekend BBQ\'s. You\'re going to Love it! Situated in one of Katy\'s best communities. and offers everything your are 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 5 Block 4 Sec 40','Subdivision Lot','8125','Survey','','1330','1','To Be Built/Under Construction','2','','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