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-05T15:07:23.833' ,`MLSNumber` = '72805134' ,`ListAgentFullName` = 'Chantal Riehs' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.970124' ,`Longitude` = '-96.640407' ,`PhotoCount` = '19' ,`PostalCode` = '77957' ,`RoomCount` = '6' ,`ListPrice` = '299500.00' ,`Status` = 'Active' ,`StreetName` = 'Hanover' ,`StreetNumber` = '805' ,`StreetSuffix` = 'Street' ,`City` = 'Edna' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '3300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you\'re looking for a home with a ton of room and storage, this home is for you. At 3,300 square feet, with 6 bedrooms, 3 full baths, 2 living spaces, and a formal dining area, there is plenty of room for growing families or if you\'re needing a home with a work space. Not only does it have plenty of room inside, but walk outside to your backyard oasis, fully fenced with privacy on a 0.38 acre lot. The kitchen and bathrooms were recently updated with granite countertops and new flooring throughout the home in 2017. The location of the home is in close proximity to the local schools, only a few blocks from the hospital, and a short distance to our local plants.' ,`Acres` = '0.384' ,`Area` = '67' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SOUTHSIDE, BLOCK 11, LOT 102X164.25FT, ACRES 0.38' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16728' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '246 - Edna' ,`SchoolElementary` = 'EDNA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'EDNA HIGH SCHOOL' ,`SchoolMiddle` = 'EDNA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Southside' ,`TaxAmount` = '3745' ,`TaxRate` = '2.1055' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087661' WHERE `Matrix_Unique_ID` = '208355247' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T16:51:46.910' ,`MLSNumber` = '41489807' ,`ListAgentFullName` = 'David Montalvo' ,`ListOfficeName` = 'Homelister, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.375343' ,`Longitude` = '-95.301498' ,`PhotoCount` = '24' ,`PostalCode` = '77303' ,`RoomCount` = '9' ,`ListPrice` = '441721.00' ,`Status` = 'Active' ,`StreetName` = 'Guadalupe' ,`StreetNumber` = '9846' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Representative pictures. Ready in September. This gorgeous and efficiently designed floor plan, is sitting on an acre lot in a new and beautiful community. You will be amazed of how much of a house you can purchase due to its super low property tax rate. Enjoy the peaceful surroundings of a country lifestyle and the advantages of an urban living. This upgraded, open concept floor plan features a large back patio, perfect for entertaining guests at a summer cookout. The family and dining areas are open, full of light. You can build a shed, shop, barn, guest house, detached garage, swimming pool or anything you have in mind. Park your RV or boat and enjoy the freedom this community provides. Don\'t miss this opportunity!' ,`Acres` = '1' ,`Area` = '19' ,`BuilderName` = 'First American' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Other Heating,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'S400102 - Deer Pines 02, BLOCK 2, Lot 8' ,`LotDesciption` = 'Other,Patio Lot,Subdivision Lot,Wooded' ,`LotSize` = '43560' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Deer Pines' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1675087662' WHERE `Matrix_Unique_ID` = '208992281' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T16:03:28.030' ,`MLSNumber` = '42885193' ,`ListAgentFullName` = 'Cynthia Corder' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.170006' ,`Longitude` = '-94.999151' ,`PhotoCount` = '45' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '579000.00' ,`Status` = 'Active' ,`StreetName` = 'Warrior' ,`StreetNumber` = '18607' ,`StreetSuffix` = 'Road' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1393' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gulf VIEW! This newer construction, 5 star rated vacation rental would make a nice addition to your investment portfolio or a wonderful 2nd home. Beautifully maintained 3 bed, 2 bath home in desirable Indian Beach Subdivision. Situated only a block from the beach on a large estate size lot (26,948 sq ft). Enjoy the gulf breeze and sunrise off your large south facing deck. In the evening enjoy the sunset from the large north facing deck off of the primary suite. Bright open floor plan with open concept living and gorgeous kitchen design with an abundance of cabinets and plenty of seating at the island. Beautiful baths with tile showers. Washer & electric dryer included. Don\'t forget the pets- the fenced yard is perfect for your four legged friends. The downastairs makes a perfect place to entertain, enjoy family & more with the built in bar. This home is selling furnished and is an active vacation rental. Schedule your appointment today to inquire about vacation rental income.' ,`Acres` = '0.6186' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 18 BLK 5 INDIAN BEACH SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '26948' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '338' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Indian Beach 1' ,`TaxAmount` = '7448' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087662' WHERE `Matrix_Unique_ID` = '210643240' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T15:13:19.753' ,`MLSNumber` = '26335148' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Carlos Alvarez' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.232586' ,`Longitude` = '-95.705397' ,`PhotoCount` = '13' ,`PostalCode` = '77354' ,`RoomCount` = '4' ,`ListPrice` = '302490.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'BIRCH SHADOWS COURT' ,`StreetNumber` = '40502' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming Brand New Express 1 Story Home!! Features Include Open Concept living w/large dining room open to family room & kitchen! Primary bathroom suite offers huge walk in closet! Features include 30\" Flat panel maple cabinets w/crown molding, exotic granite, 4 burner gas cooktop w/SS appliances, tile wall surrounds in bathrooms, smart home system, full sprinklers, front & back sod, fully front landscape, tankless water heater, LED lighting and more! Large covered patio overlooks the PRIVATE backyard with so much room for a pool! Mill Creek Offers 50\' wide lots! Call us today to schedule your showing!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '35/5/5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6344' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`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 PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087662' WHERE `Matrix_Unique_ID` = '211978593' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T15:53:54.217' ,`MLSNumber` = '40039694' ,`ListAgentFullName` = 'Jorge Llanas' ,`ListOfficeName` = 'David Hulsey, REALTORS ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.393689' ,`Longitude` = '-95.502629' ,`PhotoCount` = '18' ,`PostalCode` = '77318' ,`RoomCount` = '13' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Elianne Lace' ,`StreetNumber` = '234' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2921' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bedroom, 2.5 bath, 2 story home with home office and media/gameroom in the desirable Woodland Hills Community. The open living room concept is perfect for entertaining with Kitchen open to living room and dining area. Large gameroom upstairs, covered back patio and plenty of backyard for entertainment. Community amenities include hike & bike trails, dog par, tennis courts, fitness center & pools.' ,`Acres` = '0.1574' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S935600 - TWDC-HHC 01, BLOCK 1, LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6858' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Twdc' ,`TaxAmount` = '10390' ,`TaxRate` = '3.2823' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087662' WHERE `Matrix_Unique_ID` = '213516070' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T16:52:43.927' ,`MLSNumber` = '77414982' ,`ListAgentFullName` = 'Trey Young' ,`ListOfficeName` = 'Promark Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.583310' ,`Longitude` = '-95.267771' ,`PhotoCount` = '35' ,`PostalCode` = '77581' ,`RoomCount` = '12' ,`ListPrice` = '649000.00' ,`Status` = 'Active' ,`StreetName` = 'Bentlake' ,`StreetNumber` = '1406' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4761' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located inside the desirable gated community of Lakes at Highland Glen! Grand family room with lots of natural light, high ceilings and open floor plan to kitchen. The kitchen is spacious and features a brick accent wall, granite counters, breakfast bar and 2 walk in pantries. The primary bedroom is large and has lots of windows with a view to the backyard. Separate tub and shower, double vanity and large walk in closet. Office/bedroom with an attached sitting room is also located on the first floor with a full en-suite bathroom. Upstairs you will find lots of space to entertain in the gameroom area and media space. Oversized backyard with covered patio, outdoor kitchen and plenty of space for entertaining guests. Located near Pearland Parkway & Beltway 8. Pearland ISD.' ,`Acres` = '0.2722' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE LAKES AT HIGHLAND GLEN SEC 11 (A0076)(PEARLAND) BLK 1 LO' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11857' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '799' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'BARBARA COCKRELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH WEST' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Lakes At Highland Glen Sec' ,`TaxAmount` = '16993' ,`TaxRate` = '2.9952' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087663' WHERE `Matrix_Unique_ID` = '213865179' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T15:03:07.813' ,`MLSNumber` = '69588972' ,`ListAgentFullName` = 'Gabriela Vazquez' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.846841' ,`Longitude` = '-95.548614' ,`PhotoCount` = '8' ,`PostalCode` = '77041' ,`RoomCount` = '4' ,`ListPrice` = '249500.00' ,`Status` = 'Active' ,`StreetName` = 'Triway' ,`StreetNumber` = '5510' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move in ready! Minutes away from the major beltways such as 290, Belway 8 and I-10. This 4 bedroom beauty includes kitchen quarts, porcelain flooring, and best of all no HOA! There are ceiling fans in all bedrooms, blinds in all the windows, tub showers with glass doors in all the bathrooms. ' ,`Acres` = '0.1607' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 131 BLK R CARVERDALE SEC 4' ,`LotDesciption` = 'Other' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Carverdale' ,`TaxAmount` = '2585' ,`TaxRate` = '2.5842' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087663' WHERE `Matrix_Unique_ID` = '214021910' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T15:32:56.053' ,`MLSNumber` = '37925027' ,`ListAgentFullName` = 'Erica Nava' ,`ListOfficeName` = 'JEA Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.939362' ,`Longitude` = '-95.330687' ,`PhotoCount` = '50' ,`PostalCode` = '75862' ,`RoomCount` = '9' ,`ListPrice` = '364000.00' ,`Status` = 'Active' ,`StreetName` = 'Sawgrass' ,`StreetNumber` = '13' ,`StreetSuffix` = 'Drive' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2102' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A stunning fusion of modern architecture integrated w/ the natural beauty of a golf course & nature beyond. Majestically situated on a quiet cul-de-sac & golf course. High 2 Story Ceiling in the Living area Conveying an Open, Airy, Atmosphere. Elegant Accents are on trend in the Kitchen Comprised of an island kitchen, bar seating, quartz countertops, state of the art cabinetry, overlooking the living room, all with a breathtaking view of the golf course and nature beyond. The Large Primary Suite Includes floor-to-ceiling sliding glass doors that provide a seamless space combining the interior and the exterior to create multi-functional areas to relax, work, or entertain, and of course a Luxe Bathroom, double sinks, a generous size walk in closet. Feel worlds away in 1,200+ acre waterfront residential resort community on Lake Livingston w/ its peaceful lifestyle and lots centered around recreational lakes. Boat, fish, explore, & enjoy stunning wildlife on the water. Attention to detail!' ,`Acres` = '0.2277' ,`Area` = '42' ,`BuilderName` = 'Raa Innovations' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 03, BLOCK 62 LOT 13' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '9920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2508' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Westwood Shores Sec 3' ,`TaxAmount` = '106' ,`TaxRate` = '2.4708' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087663' WHERE `Matrix_Unique_ID` = '214841068' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T16:48:32.180' ,`MLSNumber` = '82277650' ,`ListAgentFullName` = 'Jennie Green-Prats' ,`ListOfficeName` = '1st Choice Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.945369' ,`Longitude` = '-95.358073' ,`PhotoCount` = '6' ,`PostalCode` = '77541' ,`RoomCount` = '3' ,`ListPrice` = '91500.00' ,`Status` = 'Active' ,`StreetName` = '10th' ,`StreetNumber` = '723' ,`StreetSuffix` = 'Street' ,`City` = 'Freeport' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1028' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home needs TLC. Needs new flooring. 3 large bedrooms and 1 bath. Large fenced back yard. Large bathroom' ,`Acres` = '0.14' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SOUTH VIEW GARDENS (FREEPORT), BLOCK 6, LOT 9' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6098' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'South View Gardens Freeport' ,`TaxAmount` = '2865' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087663' WHERE `Matrix_Unique_ID` = '214943418' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T15:08:28.133' ,`MLSNumber` = '23584447' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = 'Karyn Green' ,`SellingOfficeName` = 'RE/MAX ONE - Premier' ,`Latitude` = '29.819817' ,`Longitude` = '-94.835711' ,`PhotoCount` = '16' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '365386.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'South River' ,`StreetNumber` = '14055' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2063' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Juniper II plan is a beautiful one-story home with 3 bedrooms, 2 baths and 2 car garage. Convenient media room with barn doors located across from great room. Beautiful maple cabinets and quartz countertops in kitchen. Huge owner\'s suite features a spa like owner\'s bath with tub, separate shower, double sinks and big walk-in closet. Covered patio in backyard, perfect for entertaining. Low tax rate and zoned to Barbers Hill ISD. Offered by: K Hovnanian Houston River Farms, LLC.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '14/1/6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10506' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'River Farms' ,`TaxAmount` = '' ,`TaxRate` = '1.69399' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087663' WHERE `Matrix_Unique_ID` = '214996816' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T15:34:47.637' ,`MLSNumber` = '25919052' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.950054' ,`Longitude` = '-95.779454' ,`PhotoCount` = '30' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '574287.00' ,`Status` = 'Active' ,`StreetName` = 'Canda Thistle' ,`StreetNumber` = '21218' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2658' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This open concept 1-story design features 14-foot soaring ceilings and a 3-car tandem garage. A spacious study is centrally located in the home complemented by an abundance of windows allowing for natural light. The casual dining room is ideally located off the gourmet kitchen, equipped with an oversized island. French doors in the family room create the perfect indoor-outdoor area for entertaining. The luxurious primary suite is complete with bowed windows, dual vanities, a large shower and a walk-in closet. Entertain family and friends in the game room or outdoors on the spacious covered patio. Come visit this spectacular home today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 30 Block 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9306' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = '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` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087664' WHERE `Matrix_Unique_ID` = '215054143' --> 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','215191158','1675087664','215191158','2022-12-05T16:12:44.780','68042689','Fred McDaniel','Realty ONE Group Iconic','','','30.461910','-95.544338','17','77318','6','175000.00','Active','Maywood','10976','Street','Willis','2','0','3','956','Single-Family','PERFECT investment property! Newly constructed home loaded with upgrades. Three bedrooms and open concept living area. Kitchen has granite countertops, an island, wood cabinets, large pantry for storage, and stainless steel appliances. Currently leased through May 2023. Call listing agent for details.','0.0475','39','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Lake Conroe Area','Central Electric','1','S946202 - WALNUT COVE 02, BLOCK 9, LOT 38','Subdivision Lot','2070','Appraisal District','','51','0','','0','Electric Oven','0','','','Electric Range','','Composition','56 - Willis','PARMLEY ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','LYNN LUCAS MIDDLE SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','1','Traditional','Walnut Cove 02','','1.8448','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215245900','1675087664','215245900','2022-12-05T15:32:08.583','17008985','Cyndi Kornegay','Gatehouse Properties','','','29.983153','-95.647672','12','77429','11','724989.00','Active','Greenwood Gable','13622','Lane','Cypress','4','1','5','3689','Single-Family','This luxurious, 2-story home welcomes you in through the foyer and features a beautiful sky-high ceiling over the grand spiral staircase. Located to the left of the entry is the guest suite, which boasts its own private bathroom. A home office with French doors is located to the right of the entry. The spacious formal dining room opens to the butler’s pantry leading into the open concept kitchen. The kitchen features a large walk-in pantry and built-in stainless-steel appliances. Retreat to your luxurious primary suite with an oversized walk-in closet that connects to the utility room. A powder room for guests is also conveniently located on the first floor. On the second floor you will find a large game room and 2 additional bedrooms. Schedule your appointment today!','','10','Coventry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','Gaslog Fireplace','1','Cypress North','Central Gas','1','Lot 5 Block 1','Cleared,In Golf Course Community,Subdivision Lot','7494','Survey','','1070','1','To Be Built/Under Construction','3','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','HAMILTON ELEMENTARY SCHOOL','CY-FAIR HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Accompany,Appointment Required,No Supra Keybox','Builder','2','Contemporary/Modern,Traditional','Enclave at Longwood','','2.48','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215335012','1675087664','215335012','2022-12-05T15:21:19.237','97241805','Samantha Almeida','Cornerstone, Realtors','','','29.146923','-95.650905','15','77486','3','225000.00','Active','Ellis','133','Lane','West Columbia','2','0','3','1221','Single-Family','Stunning Craftsman style home in the heart of West Columbia! The luxury and precision are clearly defined in this efficient and charming home! Features include stained concrete flooring, custom wood cabinetry, quartz countertops in the kitchen & bath areas and designer fixtures! The home comes with a 1-2-10 Builder Warranty and is energy efficient with foam sealed base and top plates! Don\'t miss your opportunity to tour this rare charmer! Let\'s take a look today!','0.1642','5','Cornerstone Builders','','','','No Disclosures','','','','West of the Brazos','Central Electric','1','WILLOW FARMS SD (A0040 J H BELL DIV 9) (WEST COLUMBIA) LOT 9','Subdivision Lot','7153','Appraisal District','','','1','Never Lived In','0','','0','','','','','Composition','10 - Columbia-Brazoria','','COLUMBIA HIGH SCHOOL','WEST BRAZOS JUNIOR HIGH','Appointment Required,Lockbox Front','Builder','1','Craftsman','Willow Farms SD','','2.2983','Public Sewer,Public Water','2022','Builder'); --> New record created successfully