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-14T09:37:21.453' ,`MLSNumber` = '59890390' ,`ListAgentFullName` = 'Joseph Peterson' ,`ListOfficeName` = 'Briko Realty Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.033692' ,`Longitude` = '-94.672500' ,`PhotoCount` = '6' ,`PostalCode` = '77535' ,`RoomCount` = '6' ,`ListPrice` = '110484.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 122' ,`StreetNumber` = '43' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1946' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ON GOING AUCTION Auction properties are sold AS IS /SIGHT UNSEEN without any guarantee or\r\nwarranty by seller. Property may be occupied.' ,`Acres` = '0.8798' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'RAYWOOD, BLOCK D, LOT TR 3, ACRES .8798, MH LABEL# PFS103262' ,`LotDesciption` = 'Other' ,`LotSize` = '38324' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '108 - Hull-Daisetta' ,`SchoolElementary` = 'HULL-DAISETTA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HULL-DAISETTA HIGH SCHOOL' ,`SchoolMiddle` = 'HULL-DAISETTA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Raywood' ,`TaxAmount` = '1394' ,`TaxRate` = '2.0606' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675090958' WHERE `Matrix_Unique_ID` = '200432606' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T09:05:30.713' ,`MLSNumber` = '52093062' ,`ListAgentFullName` = 'Dawn Dietz' ,`ListOfficeName` = 'Top Guns Realty on Lake Conroe' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.401544' ,`Longitude` = '-95.605182' ,`PhotoCount` = '49' ,`PostalCode` = '77356' ,`RoomCount` = '9' ,`ListPrice` = '685000.00' ,`Status` = 'Active' ,`StreetName` = 'Walden Estates' ,`StreetNumber` = '3829' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3038' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Waterview Catalina home on the prestigious Walden Estates Drive! From the minute you walk in the front door, you will appreciate the open concept and designer details. With a fully open concept downstairs area, this home is perfect for entertaining. The kitchen features sight built custom cabinets, walk in pantry and granite back splash. The living room features large wall of windows and granite fireplace centerpiece. Want to add a little more fun to the home, the backyard has plenty of room for a pool and green space. The Primary bedroom located on the first floor is magnificent with private access to outdoor patio, framed windows, a 13x10 closet and primary bath fit for royalty. Upstairs has a fabulous sitting area/game room open to the downstairs living area with gorgeous custom iron railing. There are two upstairs bedrooms both featuring a private bath and walk-in closet. One of the bedrooms also features 16x12 covered balcony with amazing permanent Waterview\'s.' ,`Acres` = '0.1766' ,`Area` = '39' ,`BuilderName` = 'Catalina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALDEN 07, BLOCK 2, LOT 67, SECTION 7A' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Water View,Wooded' ,`LotSize` = '7691' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Walden 07' ,`TaxAmount` = '658' ,`TaxRate` = '2.1392' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090958' WHERE `Matrix_Unique_ID` = '207186410' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:25:52.703' ,`MLSNumber` = '69451447' ,`ListAgentFullName` = 'Rusty Gerdes' ,`ListOfficeName` = 'Longitude Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.905797' ,`Longitude` = '-95.243941' ,`PhotoCount` = '22' ,`PostalCode` = '75862' ,`RoomCount` = '3' ,`ListPrice` = '589900.00' ,`Status` = 'Active' ,`StreetName` = 'Memphis Bell' ,`StreetNumber` = '231' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1918' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Want a relaxing get away? Come and enjoy beautiful Lake Livingston and all it has to offer. Hard to find large lot with only 9 homes on the street, no HOA. Sit out on the large deck that overlooks the lake or hang out on the boat dock, which includes a lift and boat house, and enjoy some of the best fishing around! While enjoying the view, make sure to watch out for bald eagles that live in a nearby nest as well as the family of otters. This spacious 3 bedroom 2 bath home offers an open concept in the living, dining, and kitchen area. The primary bedroom includes a sitting area overlooking the lake and large en suite bath with a shower and separate garden tub. In addition there is an abundance of storage space including multiple closets, attic storage, large pantry and utility area, and 2 car garage, plus space under the deck which is perfect for kayaks, and paddle boards ect.' ,`Acres` = '0.344' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0067 Aldridge, Isaac, Port, Sebestapol sec 1' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '14984' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '59 - Groveton' ,`SchoolElementary` = 'GROVETON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GROVETON J H-H S' ,`SchoolMiddle` = 'GROVETON J H-H S' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sebastapol' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090958' WHERE `Matrix_Unique_ID` = '207530027' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:23:07.177' ,`MLSNumber` = '6473836' ,`ListAgentFullName` = 'Joshua Hill' ,`ListOfficeName` = 'Compass RE Texas, LLC Heights' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799798' ,`Longitude` = '-95.418839' ,`PhotoCount` = '19' ,`PostalCode` = '77008' ,`RoomCount` = '7' ,`ListPrice` = '635000.00' ,`Status` = 'Active' ,`StreetName` = '16th' ,`StreetNumber` = '1136' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2442' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING NEW CONSTRUCTION! 16th Street Manor will offer a coveted modern lifestyle. This is one of five unique homes built in the community. This home features 3 stories of modern indoor living and a 4th story rooftop deck, an entertainer\'s dream! The 2nd story offers a spacious open floorplan with a chef\'s dream kitchen including state of the art appliances and large dining and living rooms. 4 large bedrooms with en-suite bathroom and walk-in closets. Primary suite features a spa like wet room with oversized shower and freestanding bathtub. Buyers will have the opportunity to select interior finishes in the building process, if under contract before builder\'s selections. Courtyards will be turfed and future private pool installation will be possible in each turfed area. Call today!' ,`Acres` = '0.057' ,`Area` = '9' ,`BuilderName` = 'Claypoole Group' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 WEST 16TH STREET MANORS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2464' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'West 16th Street Manors' ,`TaxAmount` = '2956' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090959' WHERE `Matrix_Unique_ID` = '211465554' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:23:37.847' ,`MLSNumber` = '37140786' ,`ListAgentFullName` = 'Joshua Hill' ,`ListOfficeName` = 'Compass RE Texas, LLC Heights' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799797' ,`Longitude` = '-95.419001' ,`PhotoCount` = '19' ,`PostalCode` = '77008' ,`RoomCount` = '7' ,`ListPrice` = '635000.00' ,`Status` = 'Active' ,`StreetName` = '16th' ,`StreetNumber` = '1144' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2442' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING NEW CONSTRUCTION! 16th Street Manor will offer a coveted modern lifestyle. This is one of five unique homes built in the community. This home features 3 stories of modern indoor living and a 4th story rooftop deck, an entertainer\'s dream! The 2nd story offers a spacious open floorplan with a chef\'s dream kitchen including state of the art appliances and large dining and living rooms. 4 large bedrooms with en-suite bathroom and walk-in closets. Primary suite features a spa like wet room with oversized shower and freestanding bathtub. Buyers will have the opportunity to select interior finishes in the building process, if under contract before builder\'s selections. Courtyards will be turfed and future private pool installation will be possible in each turfed area. Call today!' ,`Acres` = '0.0497' ,`Area` = '9' ,`BuilderName` = 'Claypoole Gorup' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 WEST 16TH STREET MANORS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2164' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'West 16th Street Manors' ,`TaxAmount` = '2522' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090959' WHERE `Matrix_Unique_ID` = '211509074' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T09:51:04.610' ,`MLSNumber` = '51399123' ,`ListAgentFullName` = 'Shawn Speer' ,`ListOfficeName` = '7th Generation Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.230824' ,`Longitude` = '-95.671347' ,`PhotoCount` = '24' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '899999.00' ,`Status` = 'Active' ,`StreetName` = 'Damuth' ,`StreetNumber` = '40606' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4906' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing Investment Opportunity! Harrisburg Homes Model home in Mostyn Manor Reserve is available with a guaranteed lease back period. Never lived in and will continue to be utilized as a Model Home. Please contact listing agent for additional information!!\r\n\r\nThis beautiful Custom Home by Harrisburg Homes is located in the rapidly growing FM 1488 Corridor. Welcome Home! An Extravagant Entry, with Sweeping Wood and Tile Custom Staircase greet you upon entering. Soaring ceilings that compliment the open design and create an airy feel with lots of light. Gourmet Kitchen with Over-sized Island, Farm Style Sink, and elegant Cabinetry. Four Bedroom (Primary and MIL Suite down), 3 Car Garage, Over-sized lot, and UPGRADES as you would expect in a true showcase Model Home. Front and Rear Covered porches, Walk in Shower with Freestanding Scallop tub, Breakfast Room Niche Seating, Media Room and SO MUCH MORE!!\r\n\r\nLOW TAXES, GREAT LOCATION, AND HIGHLY RATED SCOOLS!' ,`Acres` = '0.6132' ,`Area` = '15' ,`BuilderName` = 'Harrisburg Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S730807 - MOSTYN MANOR 07, BLOCK 2, LOT 1' ,`LotDesciption` = 'Other,Subdivision Lot,Wooded' ,`LotSize` = '26709' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mostyn Manor Reserve' ,`TaxAmount` = '9108' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090959' WHERE `Matrix_Unique_ID` = '211513275' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:26:53.090' ,`MLSNumber` = '29396452' ,`ListAgentFullName` = 'Vinod Ramani' ,`ListOfficeName` = 'Urban Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.808023' ,`Longitude` = '-95.388980' ,`PhotoCount` = '17' ,`PostalCode` = '77009' ,`RoomCount` = '12' ,`ListPrice` = '699990.00' ,`Status` = 'Active' ,`StreetName` = 'East 24th' ,`StreetNumber` = '818' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful home by Topaz Ventures. Stunning designer finishes were hand selected and a thoughtful floorplan provides all you could need. The open floor plan allows for convenient luxurious living that flows into an oversized spacious private backyard. If you work from home, this plan has you covered with an office / game-room on the second floor. Schedule an appointment to learn more and to view the finishes.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Joes Construction' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 13 Block 67 Sunset Heights' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sunset Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090959' WHERE `Matrix_Unique_ID` = '212681836' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:57:07.223' ,`MLSNumber` = '91843665' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.815243' ,`Longitude` = '-95.845950' ,`PhotoCount` = '19' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '759929.00' ,`Status` = 'Active' ,`StreetName` = 'North Upland' ,`StreetNumber` = '3243' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3670' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A NEW Coventry Home located in the master-planned community, Cane Island! Zoned to Katy ISD! This stunning single-story home has impressive curb appeal. The front stucco elevation gives a light and bright appearance. When you step inside, the soaring high ceilings are breathtaking! The spacious kitchen island is every entertainer’s dream come true! The dining room connects to the kitchen and family room, perfect for friends and family to gather. This home has it all, with 4 bedrooms, 4 full bathrooms, a study, a game room, and a media room! Featuring quartz countertops, a freestanding tub in the primary bath, durable wood-like tile in all the main areas, and the ever-so-popular glass sliding doors leading to the patio. Yep, it has the features you are looking for! Make this your new home today! Interior photos are of this floorplan previously built, not of this actual property, selections may vary.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11 Block 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9713' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090960' WHERE `Matrix_Unique_ID` = '212768148' --> 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','213271250','1675090960','213271250','2022-12-14T10:24:39.247','341437','Pamela Castello','Comiskey Realty','','','29.298031','-94.908878','50','77554','4','868000.00','Active','Lokai','218','Street','Tiki Island','3','1','4','2883','Single-Family','Gorgeous bay view\'s see all fireworks at Moody Gardens. 4 Bedrooms living dining and breakfast area. Bring your boat park in your backyard fish there or jump in and you are right at the Intracoastal canal easy access to all the great fishing areas','0.119','33','','','','','Mud','','','','Tiki Island','Central Electric','1','ABST 7 S C BUNDICK SUR LOT 68 TIKI ISLAND SEC 13 REPLAT','Cleared,Waterfront','5184','Appraisal District','','','0','','2','','0','','','','','Composition','52 - Texas City','HAYLEY ELEMENTARY SCHOOL','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL (TEXAS CITY)','Appointment Required','Appraisal District','2','Traditional','Tiki Island 13','17406','2.4912','Public Sewer,Public Water','1997','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:55:58.880' ,`MLSNumber` = '24874684' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.272759' ,`Longitude` = '-95.473903' ,`PhotoCount` = '37' ,`PostalCode` = '77304' ,`RoomCount` = '8' ,`ListPrice` = '459965.00' ,`Status` = 'Active' ,`StreetName` = 'Chestnut Reef' ,`StreetNumber` = '571' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2463' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 2-story home in Grand Central Park boasts an ideal location, situated at the end of a cul-de-sac. As you enter you will be amazed by the 20-foot ceilings and architectural designs. 8-foot interior doors and oversized baseboards, on the first floor, give this home a custom feel. Entertaining’s easy in the spacious family room, overlooking the casual dining room and kitchen. The gourmet kitchen is equipped with 42-inch cabinetry and an oversized upgraded stone island. After a long day retreat to the luxurious primary suite, with a bowed window, to relax. Upstairs you will discover two spacious secondary bedrooms and a large game room. This spectacular home offers something for everyone, come visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15 Block 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8089' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1075' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Central Park' ,`TaxAmount` = '' ,`TaxRate` = '3.01' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090960' WHERE `Matrix_Unique_ID` = '213788415' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:55:08.107' ,`MLSNumber` = '71725264' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.443377' ,`Longitude` = '-95.381843' ,`PhotoCount` = '21' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '598638.00' ,`Status` = 'Active' ,`StreetName` = 'Pecos' ,`StreetNumber` = '5807' ,`StreetSuffix` = 'Court' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2867' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous one-story home offers an abundance of space. The grand foyer leads past two secondary bedrooms, complete with walk-in closets and private bathrooms, and leads you into the main living areas of the home. Adjacent to the kitchen, you will discover the dining room, where you can easily host family gatherings. The spacious kitchen is equipped with a large island that overlooks the family room with fireplace and beautiful sliding doors that open up to your Texas size patio and back yard with no direct back neighbor. With a space like this, entertaining will be a breeze. Tucked away at the back of the home, the primary suite offers double sinks, vanity, two closets, a garden tub and a separate shower. Opposite of the family room, the game room shares a hallway with an added media room and half bathroom. Many upgrades and a 3-car tandem garage. Come see this home and all of its stunning features today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 2' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10061' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090960' WHERE `Matrix_Unique_ID` = '214078968' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:54:52.257' ,`MLSNumber` = '36173276' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.445055' ,`Longitude` = '-95.394793' ,`PhotoCount` = '21' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '511706.00' ,`Status` = 'Active' ,`StreetName` = 'McCourt' ,`StreetNumber` = '5026' ,`StreetSuffix` = 'Lane' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2627' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the master-planned community of Meridiana, this gorgeous one-story home boasts everything you have been searching for and more. Step into the foyer and venture down the long hallway, passing the powder bath, a secondary bedroom and the spacious study. The foyer opens into the kitchen, family room and dining room. This open-concept space is ideal for families, entertaining guests and hosting gatherings of all sorts. With an oversized kitchen island, there is an abundance of countertop space to prepare everyone’s favorite dish. The kitchen is equipped with stainless steel appliances that are perfect for the chef in your family. After a long day, relax in the primary suite complemented by a vaulted ceiling. This home has something for everyone, including a media room, 2.5 car garage and Texas size patio. Don’t miss out on this lovely home, come visit today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 41 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9812' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090960' WHERE `Matrix_Unique_ID` = '214080102' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:54:33.240' ,`MLSNumber` = '80946130' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.222294' ,`Longitude` = '-95.774127' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '322810.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Crest' ,`StreetNumber` = '42574' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1636' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming 1-story home boasts everything you have been dreaming of and more. As you enter, you will discover luxurious details throughout the home. The gourmet kitchen is equipped with 42\" cabinetry, gleaming granite countertops, stainless-steel appliances, and a large island ideal for preparing everyone\'s favorite dish. At the end of the day, retreat to the primary suite featuring a bowed window perfect for a sitting area to enjoy a book before bed. This home is certified Environments for Living and offers some of the highest energy features available today.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5194' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Escondido' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090961' WHERE `Matrix_Unique_ID` = '214085640' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:54:12.850' ,`MLSNumber` = '34541481' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.219572' ,`Longitude` = '-95.772069' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '362270.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeside Creek' ,`StreetNumber` = '1322' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Walk through the front door of this beautiful 2-story home and see the grand entry paved with ceramic tile floors all the way to the back door. This open-concept floor plan has 20’ ceilings in the family room and you can watch television while you cook in the beautiful kitchen. After a long day, retreat to the spacious primary bedroom with a bowed window. Enjoy the Magnolia breeze on your covered patio or spend some family time upstairs in your game room that overlooks the family room. This home is certified Environments for Living which guarantees heating and cooling costs in writing!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5610' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Escondido' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090961' WHERE `Matrix_Unique_ID` = '214087056' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:53:54.913' ,`MLSNumber` = '37626241' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.222392' ,`Longitude` = '-95.773805' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '328499.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Crest' ,`StreetNumber` = '42530' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1855' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this charming one-story design. Entering through the front door, you are sure to be impressed by the grand foyer that leads you into the heart of the home. Enjoy making those lifelong family memories in the gourmet kitchen that features an abundance of storage space, stainless-steel appliances,and a large island that overlooks the dining and family room. The secluded primary suite is tucked away in the back of the home and is complemented by a bowed window and a luxurious primary bath. Take entertaining outdoors on the Texas-sized covered patio with no rear neighbors. This home was meant for you and your family to enjoy. Schedule your appointment today!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5625' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '990' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Escondido' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090961' WHERE `Matrix_Unique_ID` = '214133929' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:53:30.123' ,`MLSNumber` = '39201631' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.220467' ,`Longitude` = '-95.771876' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '319562.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeside Creek' ,`StreetNumber` = '1330' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This appealing 1-story home is located in the peaceful community of Escondido and includes 3-sides brick, a beautifully landscaped yard, and a sprinkler system. As you enter the home, you will discover a well-defined entry with 10-foot coffered ceilings that will lead you into an open concept kitchen and family room. The gourmet kitchen is equipped with 42-inch cabinets, polished granite countertops, and stainless-steel appliances. Enjoy your Texas-sized covered patio while entertaining family and friends. The energy efficiency is just another reason to love this home!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Escondido' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090961' WHERE `Matrix_Unique_ID` = '214134759' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:51:11.100' ,`MLSNumber` = '66600802' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.430777' ,`Longitude` = '-95.412714' ,`PhotoCount` = '22' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '418667.00' ,`Status` = 'Active' ,`StreetName` = 'Amoroso' ,`StreetNumber` = '3718' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning 2-story home welcomes you in with its grand foyer boasting soaring ceilings and a sleek metal balluster staircase. The gourmet kitchen is equipped with beautiful cabinetry, gleaming granite countertops and an oversized island to complement the open-concept design of the home. The elegant tiled floors pave your way throughout the home. The primary bedroom is complemented by a bow window and private bath with separate shower and tub. A secondary bedroom with full bath downstairs is ideal for guests. Upstairs, you will discover a large game room that overlooks the family room. Take entertaining outdoors in the backyard to host BBQ’s or relax with family and friends. This home is energy efficient and Environments for Living certified. Don’t miss your chance to visit today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4448' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090962' WHERE `Matrix_Unique_ID` = '214502021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T09:03:29.457' ,`MLSNumber` = '11717388' ,`ListAgentFullName` = 'Sheryl Hawkins' ,`ListOfficeName` = 'RE/MAX Compass' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.744823' ,`Longitude` = '-95.086936' ,`PhotoCount` = '48' ,`PostalCode` = '77351' ,`RoomCount` = '6' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Bluff' ,`StreetNumber` = '241' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Too Good to be True! Was a 3/2 w/an attached one car garage when seller purchased in 2020. It is now a 4/2 w/a magnificent detached 2.5 car, insulated garage/workshop on a corner lot. Unique, professionally painted designer kitchen cabinets. Stainless kitchen appliances were new in 2020. Lots of storage in kitchen. Primary 15x12 bedroom+primary bath w/a gorgeous 5x4 shower+13x7 closet was added to sq. footage in 2020. Additional bedroom w/a large closet downstairs is now being used as a study/craft room. There are 2 spacious bedrooms w/a Jack & Jill bath upstairs. A grand stone fireplace is the focal point of the massive family/formal dining room. Vinyl plank wood look flooring was installed throughout the home in 2020. AC & Heat replaced in 2019. Exterior doors replaced in 2020. Roof approximately 10 yrs. old. Amazing detached, insulated 35x23 garage/workshop was added to the property in 2020. 2 carports, one 35x17, second one 21x20. Mosquito mister & full sprinkler systems.' ,`Acres` = '0.3381' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'INDIAN HILL ESTATES SECTION 2 BLK 7 LOT 1 & 2' ,`LotDesciption` = 'Corner,Subdivision Lot,Water View' ,`LotSize` = '14727' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Indian Hill Estates Sec 2' ,`TaxAmount` = '4157' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Septic Tank' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090962' WHERE `Matrix_Unique_ID` = '214502486' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:50:51.977' ,`MLSNumber` = '66417773' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.949873' ,`Longitude` = '-95.780173' ,`PhotoCount` = '7' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '678128.00' ,`Status` = 'Active' ,`StreetName` = 'Cosmopolitan' ,`StreetNumber` = '11318' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3228' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This amazing home features a soaring two-story ceiling in the foyer and has a dramatic round stair case. The dining room has a pass-through butler’s pantry to the kitchen that includes a huge storage pantry. This home features a spacious study great for working from home, a massive kitchen island perfect for family gatherings, and an expansive covered patio for outdoor entertainment. What makes this home so wonderful for everyone is there are 2 bedrooms on first floor, the utility connects and opens to the primary closet, and there are two bedrooms on the second floor along with a game room and a media room! Many upgrades are included, such as beautiful wood floors, granite countertops, and tile accents. This home is a showstopper, make an appointment today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 41 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7231' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090962' WHERE `Matrix_Unique_ID` = '214502747' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:49:04.730' ,`MLSNumber` = '53674910' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813290' ,`Longitude` = '-95.840582' ,`PhotoCount` = '15' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '825872.00' ,`Status` = 'Active' ,`StreetName` = 'Shoreline View' ,`StreetNumber` = '6903' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3806' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a new home located on a lakefront homesite? You just found it! This 2-story home is nothing short of amazing, with a wide, open design with 2-story ceilings in the foyer, family room and dining rooms. This gorgeous new home features finishes everyone loves, as well as large windows, which make this home airy and bright. Enjoy a stunning panoramic view from the game room overlooking the family and dining rooms. Two bedrooms are downstairs and two bedrooms are located upstairs, along with a massive game room and media room which are perfect for entertaining guests. The rear patio is Texas sized. You just found home, call today! Interior photos are of this floorplan previously built, not of this actual property, selections may vary.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Water View' ,`LotSize` = '12965' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090962' WHERE `Matrix_Unique_ID` = '214572781' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:48:26.120' ,`MLSNumber` = '50624678' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.950534' ,`Longitude` = '-95.688686' ,`PhotoCount` = '35' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '623724.00' ,`Status` = 'Active' ,`StreetName` = 'Miller Springs' ,`StreetNumber` = '17930' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2577' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous, open-concept, two-story home features wood flooring throughout the main areas of the home. The large open kitchen includes omega stone countertops with stainless steel appliances. Entertain guests in the spacious game room or outside on the Texas-sized covered patio that overlooks the amazing Towne Lake park area. The garage has a 5\' extension to store lawn equipment, bikes, or any overflow you might have. This home is at the end of the cul-de-sac and sits alongside walking trails. With the perfect location and perfect plan, this home won’t last long. Schedule your appointment today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5688' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1675' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Towne Lake' ,`TaxAmount` = '' ,`TaxRate` = '3.65' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090963' WHERE `Matrix_Unique_ID` = '214802246' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:48:05.280' ,`MLSNumber` = '74449055' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.155350' ,`Longitude` = '-95.393566' ,`PhotoCount` = '10' ,`PostalCode` = '77385' ,`RoomCount` = '9' ,`ListPrice` = '499987.00' ,`Status` = 'Active' ,`StreetName` = 'Highwood Green' ,`StreetNumber` = '32204' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2328' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning one-story home offers extra space in all the right places. A spacious kitchen and family room boast 12’ ceilings and four large windows overlooking the back yard. The Texas-sized covered rear patio allows plenty of room your family BBQ’s and other events. The large corner lot faces due north and is fully fenced. The primary bedroom and bath feature as much room as homes twice this size. For extra storage, this home offers a 3-car tandem garage plus a 5’ bump out for plenty of additional elbow room. Other great features Include luxury vinyl plank flooring, beautiful granite countertops in the kitchen, a 8’ knotty alder front door and Control4 home automation.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9326' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Meadows at Imperial Oaks' ,`TaxAmount` = '' ,`TaxRate` = '3.3' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090963' WHERE `Matrix_Unique_ID` = '214803017' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:46:33.040' ,`MLSNumber` = '25699002' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.943384' ,`Longitude` = '-95.689995' ,`PhotoCount` = '11' ,`PostalCode` = '77433' ,`RoomCount` = '15' ,`ListPrice` = '1048002.00' ,`Status` = 'Active' ,`StreetName` = 'Brazos River' ,`StreetNumber` = '18010' ,`StreetSuffix` = 'Circle' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4902' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated on a quiet cul-de-sac street in the gated subdivision of Marina Bay. You will find a truly unique design as you enter and are greeted by soaring ceilings, spiral staircase, wine grotto, home office and spectacular formal dining room. The family room, over-sized breakfast room and kitchen are all combined into one a large open space that is perfectly designed for entertaining. The primary bedroom is tucked at the rear of the home for added privacy. Enjoy backyard entertaining on the expansive Texas-sized covered patio or in the media room positioned just off the family room for family movie night. Be delighted by the large secondary bedrooms upstairs, the added Hobby Room, and the game room perfect for additional lounging. Don’t miss this amazing home, visit today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9792' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2274' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Towne Lake' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090963' WHERE `Matrix_Unique_ID` = '214931689' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:46:08.593' ,`MLSNumber` = '93090487' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.018444' ,`Longitude` = '-95.791585' ,`PhotoCount` = '8' ,`PostalCode` = '77447' ,`RoomCount` = '10' ,`ListPrice` = '523098.00' ,`Status` = 'Active' ,`StreetName` = 'Lynn Orchard' ,`StreetNumber` = '17307' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2513' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the beautiful community of Dellrose, you will fall in love with every intricate detail of this home. Enter through the foyer and immediately be wowed. Wood-look tile floors pave your way throughout the home. The family room opens up to a gourmet kitchen, complete with an oversized island and built-in appliances. The primary suite includes a luxurious bath. Downstairs, you will discover a secondary bedroom with a full bath that is ideal for guests and live-in family members. Enjoy the beautiful Dellrose sunsets from an oversized covered patio. Come visit this gorgeous home today!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8241' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Dellrose' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090963' WHERE `Matrix_Unique_ID` = '214934991' --> 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','214940131','1675090964','214940131','2022-12-14T09:52:57.707','12757869','Bonnie Collins','Bonnie Collins Group','','','30.031458','-95.649220','42','77429','7','265000.00','Active','Misty Pond','17915','Court','Cypress','2','0','3','1504','Single-Family','One story home in Wildwood at Oakcrest North! Needs TLC. Priced below comparables in the area. This home features 3 bedrooms, 2 bathrooms, and an open floor plan. Cul de sac street. Wildwood at Oakcrest North has multiple community parks, ponds, a pool, soccer field, and walking paths. Convenient location to schools, the Grand Parkway, 249, 290, shopping centers, grocery stores, and restaurants. Zoned to Tomball ISD.','','35','','','Electric Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Tomball South/Lakewood','Central Gas','1','LT 69 BLK 1 OAKCREST NORTH SEC 2','Subdivision Lot','5603','Appraisal District','','795','0','','2','Electric Oven','0','','','','','Composition','53 - Tomball','WILDWOOD ELEMENTARY SCHOOL','TOMBALL MEMORIAL H S','GRAND LAKES JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Ranch,Traditional','Wildwood at Oakcrest North','6892','2.8172','Water District','2008','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:45:22.357' ,`MLSNumber` = '18978796' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.019762' ,`Longitude` = '-95.793489' ,`PhotoCount` = '8' ,`PostalCode` = '77447' ,`RoomCount` = '9' ,`ListPrice` = '494128.00' ,`Status` = 'Active' ,`StreetName` = 'Veranda Oaks' ,`StreetNumber` = '17423' ,`StreetSuffix` = 'Court' ,`City` = 'Hockley' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2470' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous one-story home greets you with an impressive elevation. A spacious study flanks the foyer, providing an ideal space to work from home. The kitchen, adorned with 42-inch cabinetry, is perfectly positioned for entertaining. Overlooking the family room and casual dining space, the large granite island will accommodate a great buffet for any holiday gathering. Complete with dual closets, double vanities, an inviting glass enclosed shower with seat and a large garden tub, the primary suite is the perfect setting to unwind at the end of day. As the sun begins to set, escape to the covered patio and enjoy the evening. Come visit this home before it is too late!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 34 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7192' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Dellrose' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090964' WHERE `Matrix_Unique_ID` = '214952937' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:44:53.577' ,`MLSNumber` = '51973092' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.019902' ,`Longitude` = '-95.792950' ,`PhotoCount` = '8' ,`PostalCode` = '77447' ,`RoomCount` = '10' ,`ListPrice` = '512744.00' ,`Status` = 'Active' ,`StreetName` = 'Veranda Oaks' ,`StreetNumber` = '17422' ,`StreetSuffix` = 'Court' ,`City` = 'Hockley' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2513' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located on a cul-de-sac in Dellrose, this popular plan has 14\' ceilings, an open floor plan, and a large kitchen island that overlooks the family room. The kitchen boasts granite countertops, built-in appliances, and pendant lighting. This plan also offers a front study and a front bedroom with an on-suite bath, plus 2 back bedrooms in addition to the primary suite. Formal dining and breakfast room are also included in the 2500 square feet. Enjoy the backyard from the covered patio. This home won\'t last long!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 45 Block 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7678' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Dellrose' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090964' WHERE `Matrix_Unique_ID` = '214957972' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:44:31.910' ,`MLSNumber` = '6447039' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.564954' ,`Longitude` = '-95.753695' ,`PhotoCount` = '15' ,`PostalCode` = '77469' ,`RoomCount` = '11' ,`ListPrice` = '723092.00' ,`Status` = 'Active' ,`StreetName` = 'Dixon Shoals' ,`StreetNumber` = '24214' ,`StreetSuffix` = 'Road' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has it all! One of Coventry Homes’ best-selling floor plans, this home features an open-concept design with a game room, media room and a study. The kitchen comes equipped with an oversized island that overlooks the family room, study and dining area, creating the perfect area for entertaining. The game room and media room offer ample amounts of additional entertaining space. The spacious covered back patio and 3 car garage completes the home. Come and see this home today!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 31 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8574' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1095' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Veranda' ,`TaxAmount` = '' ,`TaxRate` = '2.8' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090964' WHERE `Matrix_Unique_ID` = '215011592' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-14T10:43:38.793' ,`MLSNumber` = '75451939' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.584485' ,`Longitude` = '-95.748693' ,`PhotoCount` = '29' ,`PostalCode` = '77406' ,`RoomCount` = '10' ,`ListPrice` = '521484.00' ,`Status` = 'Active' ,`StreetName` = 'Wild Mustang' ,`StreetNumber` = '1303' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2426' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is our model home floor plan, equipped with 4-bedrooms, 4-baths and a 3-car garage, it sits on a large corner lot with plenty of curb appeal. The gorgeous brick exterior is just a hint of what is on the inside. The house is adorned with 14’-foot ceilings throughout the main living and kitchen area. This beautiful gem has a large game room on one side of the home overlooking the back patio and backyard. The large primary suite is tucked away on the other side of the home for privacy. Come and see this amazing home that you will absolutely fall in love with and make it yours, you deserve it!' ,`Acres` = '' ,`Area` = '29' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 3' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '9807' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LONG ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'English,Traditional' ,`Subdivision` = 'Mandola Farms' ,`TaxAmount` = '' ,`TaxRate` = '2.4' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090964' WHERE `Matrix_Unique_ID` = '215013389' --> 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','215237879','1675090965','215237879','2022-12-14T09:36:40.257','16044035','Megan Latour','JLA Realty','','','29.762910','-95.235490','21','77029','4','259000.00','Active','Munn','11006','Street','Jacinto City','2','0','3','1840','Single-Family','Beautiful and tastefully renovated home in the heart of Jacinto City. This property features 3 spacious bedrooms, 2 bathrooms- 1 updated and 1 brand new, a large game room plus a HUGE workshop & storage shed on a 16,000+ sqft lot! Inside you will find new carpet, vinyl plank, and tile flooring with fresh paint and updated trim all highlighted by the ample natural light the flows throughout. The kitchen offers gorgeous quartz countertops, stainless steel appliances and refreshed cabinetry. Jacinto City provides it\'s own public services- Police Dept., EMS. Public works. Community offers holiday celebrations such as Christmas parade/Santa in the fire truck, Annual Easter egg hunt, Market Days Festival 1x/month, National Night Out festivities, 4th of July firework show, etc. Property is minutes from school system, little league fields, shopping, restaurants, medical center and major highways. Metro transportation system is within proximity for commutes into Houston-Metro Areas.','0.3746','2','','','Washer Connections','','Other Disclosures,Sellers Disclosure','1','','0','North Channel','Central Gas','0','W 1/2 OF LT 8 BLK 50 INDUSTRIAL','Cleared','16318','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','21 - Galena Park','JACINTO CITY ELEMENTARY SCHOOL','GALENA PARK HIGH SCHOOL','GALENA PARK MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Seller','1','Traditional','Industrial','3629','2.993','Public Sewer,Public Water','1926','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','215254541','1675090965','215254541','2022-12-14T10:25:25.607','61460246','Carrie Vigliotti','Keller Williams Advtge Realty','','','31.458153','-97.781085','24','76528','8','735000.00','Active','Western Ridge','155','Road','Gatesville','3','1','4','2283','Single-Family','23 Acre property. Nestled to the back of a quiet cul-de-sac for privacy. Land is fenced and cross fenced. Beautiful home that has been well cared for. . Wonderful country front porch that wraps around the front half of home.4 large bedrooms. 3 full baths and half bath for guests. Two master bedrooms. Jack and Jill bath as well. Perhaps you have a teen or mother staying with you that require their own suite. The smaller second master is perfect for that. Kitchen offers an amazing amount of cabinets for storage. Built in secretary desk. Breakfast bar can easily accommodate 6-8 stools. Large Breakfast/dining area with bay window. Living room is huge! Could easily be broken up into two areas if desired. Gorgeous fireplace with mantle and hearth. Loads of natural light flows through this area. Let\'s not forget the stunning pool area. Extra decking for those large pool parties. Covered back patio area. 30x40 shop with built in game room for dad. Bring the horses and settle in.','23','83','','','Electric Dryer Connections','','Other Disclosures,Sellers Disclosure','1','Wood Burning Fireplace','1','','Central Electric','0','Western ridge, Lot 15 Acres 23','Cul-De-Sac','','','','','0','','2','Electric Oven','1','In Ground','','Electric Range','','Composition','538 - Gatesville','GATESVILLE ELEMENTARY SCHOOL','GATESVILLE HIGH SCHOOL','GATESVILLE JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Ranch','Western Ridge','','1.55','Septic Tank','2002','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215490401','1675090965','215490401','2022-12-14T09:51:32.597','35662411','Meredith Davis','KSP','','','29.811744','-95.380993','19','77009','5','550000.00','Active','Eastman','2621','Street','Houston','2','0','3','1664','Single-Family','Are you looking for a lot to build on.....This LOT-VALUE ONLY 7,500 sf corner lot is located in the desirable East Sunset Heights... new construction all around. This lot is right near the newly renovated Houston Farmers Market. Lot has the option to be divided. Home interior is not available to be shown, do not walk the property as there are dogs on site. This lot is large enough for 3-4 homes if you wish to split.','0.1722','9','','','','','Sellers Disclosure','','','','Heights/Greater Heights','Central Gas','0','LT 6 & TR 5 BLK 4 EAST SUNSET HEIGHTS','Corner,Subdivision Lot','7500','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','JEFFERSON ELEMENTARY SCHOOL (HOUSTON)','HEIGHTS HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (HOUSTON)','Appointment Required,No Supra Keybox','Appraisal District','1','Traditional','East Sunset Heights','7749','2.3307','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215546599','1675090965','215546599','2022-12-14T09:18:53.090','90237801','Ana Salazar','Keller Williams HoustonCentral','','','29.785129','-95.168511','25','77015','5','179900.00','Active','Texarkana','14340','Street','Houston','3','0','5','1958','Single-Family','Great investment opportunity, possible rental properties. Main house is a 3/1 with Living, construction needs to be completed. Unit in the back has a 1/1 with living in the front and a 1/1 unit on the side, no kitchen. Oversized corner lot in a unrestricted area. Entire property is all electric.','0.1932','2','','','','','Sellers Disclosure','','','','North Channel','No Heating','0','LT 16 & W 1/2 OF LT 18 BLK 85 CLOVER LEAF','Subdivision Lot','8415','Appraisal District','','','0','','0','','0','','','','','Composition','21 - Galena Park','NORTH SHORE ELEMENTARY SCHOOL','NORTH SHORE SENIOR HIGH SCHOOL','NORTH SHORE MIDDLE SCHOOL','Appointment Required,Supra Keybox','Seller','1','Traditional','Clover Leaf','6431','2.5853','Water District','1955','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','215570839','1675090965','215570839','2022-12-14T09:14:44.620','37376209','Jessica Murphy','Birdsong Real Estate','','','29.166964','-95.631825','9','77486','6','329990.00','Active','Valle Verde','409','Lane','West Columbia','2','0','4','1691','Single-Family','Welcome to 409 Valle Verde Lane. This stunning Caldwell floor plan offers 4 spacious bedrooms, 2 bathrooms, an oversized kitchen island, double vanity, and so much more. Fall in love with the copious amount of natural light flowing through the home, as well as the massive amount of closet storage. Contact your Realtor today to schedule your private showing.','0.2284','5','Kendall Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','West of the Brazos','Central Gas','1','COLUMBIA LAKES SEC 3 (A0133 M VARNER) BLK 31 LOT 35','In Golf Course Community,Subdivision Lot','9949','Appraisal District','','150','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','10 - Columbia-Brazoria','','COLUMBIA HIGH SCHOOL','WEST BRAZOS JUNIOR HIGH','Appointment Required,Lockbox Front','Builder','1','Traditional','Columbia Lakes Sec 1-2-3-4-5','821','2.0633','Public Sewer,Water District','2023','Builder'); --> New record created successfully