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` = '2023-01-21T18:52:51.507' ,`MLSNumber` = '17619505' ,`ListAgentFullName` = 'Charlene Findley' ,`ListOfficeName` = 'Boom Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.109241' ,`Longitude` = '-95.135339' ,`PhotoCount` = '47' ,`PostalCode` = '77336' ,`RoomCount` = '6' ,`ListPrice` = '247000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunny Oak' ,`StreetNumber` = '158' ,`StreetSuffix` = 'Drive' ,`City` = 'Huffman' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1106' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 1940s cottage-style home tucked away in a canopy of trees. Property backs up to Blue Lake with a private deck and pier where you can enjoy fishing or ride your paddle boat. Original wood floors throughout. Spacious kitchen with breakfast nook with a lake view. Covered wrap-around porch with stained glass accents. Call your favorite realtor to tour this super cute home.' ,`Acres` = '0.74' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 2 CYPRESS POINT SEC 7 U/R' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '32234' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '25' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Point Sec 07 U/R' ,`TaxAmount` = '1419' ,`TaxRate` = '2.0083' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217210' WHERE `Matrix_Unique_ID` = '211022671' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T18:10:39.980' ,`MLSNumber` = '40642991' ,`ListAgentFullName` = 'Linsey Mitchell' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = 'Clayton Estrems' ,`SellingOfficeName` = 'RE/MAX Associates Northeast' ,`Latitude` = '30.003734' ,`Longitude` = '-95.183882' ,`PhotoCount` = '39' ,`PostalCode` = '77346' ,`RoomCount` = '9' ,`ListPrice` = '285000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Forest Timbers' ,`StreetNumber` = '5738' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2261' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your next home! This beautiful property has all you could need! This home features 4 bedrooms, 2.5 bathrooms, open concept living/kitchen, formal living/dining combo, UPGRADED flooring, countertops, backsplash, HUGE closets for all the storage one could ask for and the list goes on and on. The neighborhood is perfectly situated near great shopping, outdoor fun, parks, Lake Houston and so much more! But don\'t take my word for it, come see for yourself! RECENT PAINTING REFRESH IN MOST ROOMS!!' ,`Acres` = '0.135' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 KINGWOOD GLEN SEC 3' ,`LotDesciption` = 'Other' ,`LotSize` = '5880' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingwood Glen Sec 03' ,`TaxAmount` = '5379' ,`TaxRate` = '2.613' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217210' WHERE `Matrix_Unique_ID` = '211411980' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T17:26:53.577' ,`MLSNumber` = '73756499' ,`ListAgentFullName` = 'Carol Heilman' ,`ListOfficeName` = 'Zion Premier Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.698382' ,`Longitude` = '-95.077661' ,`PhotoCount` = '50' ,`PostalCode` = '77351' ,`RoomCount` = '5' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'Edgewater' ,`StreetNumber` = '278' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2906' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this home made for entertaining!!! A beautiful property that has lakefront swimming pool and plentyy of space to relax. The high ceilings and wall of windows looks out over the lake, while the amazing sunsets and a short distance to Pine Island show it\'s impressive lake location. Open concept kitchen features a breakfast bar, dry bar coffee bar. Updated granite throughout. New light fixtures. The floor to ceiling stone fireplace is the focal point of the living and game room area. Three bedroom and 3 full bathrooms with a loft area that is perfect for guests, office, 4th bedroom or full game room. Full boathouse with jet ski, and boat lift, plenty of room for fishing and kayaks. The community offers a public pool, tennis courts, playground, volleyball court and clubhouse. This home is currently a short term rental. Walk through tour - click on the movie reel and use your mouse as your feet as you walk through the home and up the stair.' ,`Acres` = '0.0018' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'MEMORIAL POINT BLK 11 LOT 27 PT & 28' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '129' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Point' ,`TaxAmount` = '11791' ,`TaxRate` = '2.7745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675217210' WHERE `Matrix_Unique_ID` = '211665439' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T17:05:16.053' ,`MLSNumber` = '74406557' ,`ListAgentFullName` = 'Melinda Menefee' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.427459' ,`Longitude` = '-95.623938' ,`PhotoCount` = '48' ,`PostalCode` = '77356' ,`RoomCount` = '9' ,`ListPrice` = '349999.00' ,`Status` = 'Active' ,`StreetName` = 'Bermuda Circle' ,`StreetNumber` = '9' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2272' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely 3 Bedroom, 2 1/2 Bath home on Corner lot. Conveniently located in beautiful Bentwater. Located on the north shore of Lake Conroe, this gated community offers golf, tennis, swimming, social and Country Club activities and more! This custom, split floor plan home offers a large kitchen with granite countertops open to the living area with both a large breakfast area and formal living area. Coffered ceilings, open archways with lots of natural light and beautiful crown moulding are just a few of the features of this well designed, custom home. Double side entry garage, large deck area with retractable Sunsetter awning for outdoor entertaining. Close to Country Club and all that Bentwater has to offer. Call for your private viewing today.' ,`Acres` = '0.2104' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 05, BLOCK 2, LOT 22' ,`LotDesciption` = 'Corner,In Golf Course Community' ,`LotSize` = '9167' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1091' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwater 05' ,`TaxAmount` = '6064' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217211' WHERE `Matrix_Unique_ID` = '212130885' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T17:33:23.673' ,`MLSNumber` = '44999876' ,`ListAgentFullName` = 'Cindy Beltran' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.709461' ,`Longitude` = '-95.472363' ,`PhotoCount` = '25' ,`PostalCode` = '77401' ,`RoomCount` = '5' ,`ListPrice` = '439900.00' ,`Status` = 'Active' ,`StreetName` = 'Chestnut' ,`StreetNumber` = '5223' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1446' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1607' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 43 & ADJ N 5 FT OF ABAND ALLEY BELLAIRE' ,`LotDesciption` = 'Corner' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CONDIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Bellaire' ,`TaxAmount` = '7710' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217211' WHERE `Matrix_Unique_ID` = '213003331' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T17:12:53.073' ,`MLSNumber` = '74116987' ,`ListAgentFullName` = 'Pinky Pirani' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.770662' ,`Longitude` = '-95.815359' ,`PhotoCount` = '49' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Mount Auburn' ,`StreetNumber` = '24615' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3532' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful 2-story home w/ 5 bedrooms & 3.5 bathrooms in the lovely Pin Oak Village. As you enter,You will be greeted by a bright entry w/ soaring ceiling.The casual dining opens to the family room w/ an upgraded fireplace & wall of windows filling the home w/ample natural light, open to a wet bar nook to sit and chat w/friends! The kitchen boasts lots of cabinets, granite countertops, tile backsplash, & a breakfast nook. The first-floor primary bedroom hosts an en-suite w/ dual vanity sink, tons of cabinets, jacuzzi tub, separate glass enclosed shower, & a walk-in closet. Custom molding throughout the home provides an elegant unique touch.On the 2nd floor, you will find 4 more bedrooms & a game room w/ built in cabinets.Your backyard looks serene & relaxing with tall mature trees.Background is gigantic which can easily accommodate future pool & other entertainment features.Home is zoned to Katy ISD schools.' ,`Acres` = '0.2534' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PIN OAK VILLAGE SEC 1, BLOCK 2, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11036' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '820' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KATY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pin Oak Village Sec 1' ,`TaxAmount` = '7892' ,`TaxRate` = '2.3143' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217211' WHERE `Matrix_Unique_ID` = '214296968' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T18:15:43.267' ,`MLSNumber` = '35340111' ,`ListAgentFullName` = 'Jessica Garcia' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.179419' ,`Longitude` = '-96.414995' ,`PhotoCount` = '26' ,`PostalCode` = '77833' ,`RoomCount` = '8' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Briscoe' ,`StreetNumber` = '1023' ,`StreetSuffix` = 'Street' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This cozy DR Horton home is a single-story, 1568 sq. ft., 4 bedroom, 2 bathroom, designed to provide you with a comfortable place to call home sweet home. The inviting entryway opens into the spacious living/open dining area and large kitchen with an oversized island, perfect for entertaining. The primary bedroom is located off the family room and includes a large walk-in closet and a relaxing spa-like bathroom. Other Features include: ungraded granite counter tops in the kitchen and an upgraded stainless appliances package (fridge negotiable). You will also enjoy added security with the Home is Connected features- using one central hub that talks to all the devices in your home, you can control the lights, thermostat and locks, all from your cellular device. This home is a MUST SEE! See list of upgrades in Attachments.' ,`Acres` = '0.148' ,`Area` = '58' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S3803 - LIBERTY VILLAGE S/D, BLOCK 2, LOT 8, ACRES 0.148' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6272' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Liberty Vlg Sub' ,`TaxAmount` = '2000' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217211' WHERE `Matrix_Unique_ID` = '214469255' --> 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','215147887','1675217211','215147887','2023-01-21T18:30:08.213','23417521','Tara Hanel','eXp Realty, LLC','','','30.075267','-94.797016','44','77575','4','220000.00','Active','Pine','1904','Street','Liberty','2','0','3','1680','Single-Family','OVER 1/2 acre in the heart of Liberty. Huge Oak tree in the front provides the perfect shade and nice feature to the property. Other trees are fig, and pecan. You are greeted by a large living area with tons of windows, that leads to the spacious remodeled kitchen with new counter tops and painted cabinets. The full bath in the hallway has been remodeled as well, new floors and countertops, with walk in shower/tub combo. Off of the back of the home is a large windowed in sun room, perfect to relax and enjoy. The spacious two bay garage has plenty of room for your cars and storage, with workshop off the back. Also there a side room with window unit being used as a bedroom. Behind the garage is wood shop and extra storage. So many possibilities with this property, you could easily build another home next to this one and have plenty of room.','0.57','52','','','Electric Dryer Connections','','Sellers Disclosure','1','','','Liberty','Central Electric','0','RYE SMITH & ADAMS TRACT, LOT TR 24, ACRES .57','Cleared,Subdivision Lot','24829','Appraisal District','','','0','','2','','0','','','Electric Cooktop,Electric Range','','Composition','73 - Liberty','LIBERTY ELEMENTARY SCHOOL (LIBERTY)','LIBERTY HIGH SCHOOL (LIBERTY)','LIBERTY MIDDLE SCHOOL (LIBERTY)','Appointment Required,Leave Business Card,Lockbox Right Side,Request Online Appointment','Appraisal District','1','Traditional','Rye Smith & Adams Tr','4557','2.5375','Public Sewer,Public Water','1968','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','215434456','1675217212','215434456','2023-01-21T17:20:29.750','76414064','Treva Christopher','The Christopher Dynasty Real Estate Group','','','30.078024','-95.770247','38','77447','7','315000.00','Active','Sunshine Meadow','20727','Drive','Hockley','2','1','3','2186','Single-Family','See what Pride In Home Ownership is. This Home creates the perfect ambiance and is still under builder warranty and well maintained. This gorgeous Hockley home sits directly across from the community dog park and offers a brick elevation, a open floor plan featuring 3 large bedrooms, 2.5 baths, game room and large backyard. The kitchens features expresso cabinets, stainless appliances, large countertop, lots of natural sunlight and so much more. Primary bedroom features dual vanity sinks, garden whirlpool tub and separate shower. This home has lots of recess lighting, natural light and very spacious rooms. Very low tax rate & and just minutes away from Grand Parkway 99. Schedule your showing today!!','0.1147','35','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Hockley','Central Electric,Central Gas','1','LT 29 BLK 14 BAUER LANDING SEC 7','Subdivision Lot','4995','Appraisal District','','475','0','','2','Gas Oven','0','','','Gas Range','','Composition','55 - Waller','EVELYN TURLINGTON ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','SCHULTZ JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Bauer Landing','8361','2.8556','Water District','2021','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','216040866','1675217212','216040866','2023-01-21T17:15:41.140','14296689','Feras Rachid','Opendoor Brokerage, LLC','','','29.690504','-95.660282','19','77083','3','270000.00','Active','Suspiro','8015','Drive','Houston','2','1','3','1997','Single-Family','Your dream home is waiting for you! This home has fresh interior paint and partial flooring replacement. Discover a bright and open interior with plenty of natural light and a neutral color palette, complimented by a fireplace. You\'ll love cooking in this kitchen, complete with a spacious center island and a sleek backsplash. You won’t want to leave the serene primary suite, the perfect space to relax. Extra bedrooms add nice flex space for your everyday needs. Take advantage of the extended counter space in the primary bathroom complete with double sinks and under sink storage. The fenced in backyard gives you the perfect private area to enjoy the outdoors. A must see! This home has been virtually staged to illustrate its potential','0.1853','37','','','','','Sellers Disclosure','1','','1','Mission Bend Area','Central Gas','1','MISSION BEND SAN MIGUEL SEC 1, BLOCK 5, LOT 51','Subdivision Lot','8071','Appraisal District','','400','0','','2','','0','','','','','Composition','19 - Fort Bend','MISSION BEND ELEMENTARY SCHOOL','BUSH HIGH SCHOOL','HODGES BEND MIDDLE SCHOOL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Seller','2','Traditional','Mission Bend San Miguel Sec 1','4953','1.9747','Water District','1982','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216045874','1675217212','216045874','2023-01-21T17:07:26.917','6161971','Thomas Saunders','RE/MAX Associates Northeast','','','29.817473','-95.348998','16','77026','2','155000.00','Active','King','2010','Street','Houston','1','0','2','1008','Single-Family','Single story home. Fully fenced yard. Carport. House needs work to be complete. Get it today at the bottom of the market price and make it your own. Easy commute! Close to Highway 59, 610, Hardy Toll Road and 45.','0.1607','9','','','','','Sellers Disclosure','','','','Northside','Window Unit','0','LT 279 BLK 7 HUNTINGTON PLACE','Cleared,Subdivision Lot','7000','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','ROSS ELEMENTARY SCHOOL (HOUSTON)','NORTHSIDE HIGH SCHOOL','KEY MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Huntington Place','2356','2.3307','Public Sewer,Public Water','1940','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','216055880','1675217212','216055880','2023-01-21T17:49:53.810','33986729','Deborah Bly','eXp Realty, LLC','','','29.544935','-95.034168','28','77565','6','324900.00','Active','Narcissus','617','Road','Clear Lake Shores','1','0','1','864','Single-Family','ADORABLE COZY BUNGALOW HOME IS JUST A BLOCK FROM THE WATER - LOCATED IN THIS FUN AND SOCIAL WATERFRONT COMMUNITY WHERE EVERYDAY IS A VACATION. ENJOY NIGHTLY SUNSETS AND FISHING IN THE PARKS. GOURMET DINING - BARS AND OTHER ISLAND ADVENTURES ARE JUST A STROLL OR SHORT GOLF CART RIDE AWAY. WHEN YOU ARE DONE EXPLORING ENJOY LOUNGING IN YOUR OWN BACKYARD SALTWATER POOL WITH SOCIAL BAR-B-QUES.MINUTES AWAY FROM THE KEMAH BOARDWALK THIS HOME MAKES A PERFECT WEEKEND GETAWAY OR YOUR PERMANENT LIVE-IN-PARADISE HOME. UPDATES IN SUMMER OF 2022 INCLUDE NEW VINYL FLOORING - FRESH PAINT-NEW HVAC - PEX PLUMBING AND ELECTRICAL PANEL ALONG MANY OTHER ITEMS THAT HAVE BEEN UPDATED.','0.1377','33','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','League City','Central Gas','0','ABST 18 M MULDOON SUR LOTS 309,310 & 311 CLEAR LAKE SHORES','Subdivision Lot','6000','Appraisal District','','','0','','0','Electric Oven,Freestanding Oven','1','Heated,In Ground','','Electric Range,Freestanding Range','','Composition','9 - Clear Creek','STEWART ELEMENTARY SCHOOL (CLEAR CREEK)','CLEAR FALLS HIGH SCHOOL','BAYSIDE INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Clear Lake Shores','3749','1.7054','Public Sewer,Public Water,Water District','1960','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','216276459','1675217212','216276459','2023-01-21T18:06:47.373','15932281','Cameron Namazi','Summit Realty','','','29.975190','-95.116451','50','77532','10','329000.00','Active','Round Wind','1915','Trail','Crosby','2','1','3','2159','Single-Family','WELCOME to this beautiful 3 bedroom and 2.5 bathroom spacious home, located on a large lot on the golf course in Indian Shores! 2 tax accounts combined for over 1/2 acre, 26,070 sf lot. Fresh new paint, light fixtures, new floors, and stainless steel appliances, new granite countertops. This home offers a spacious kitchen with a touch-screen electric cooktop and a separate stainless steel electric oven. Both the living room and dining room areas are very large and include a large wood fireplace. All 3 bedrooms and 2 full baths along with a large game room are upstairs. Fully updated master bathroom, with a new shower and double sinks, as well as a spacious walk-in closet. Short distance to lake Houston, boat ramp, and community pool. It offers direct access to 2100 and a convenient location of Kroger, Starbucks, and many other local conveniences. The home is surrounded by tall pines, which preserves the rural feel while being so convenient to Houston.','0.6','1','','','Electric Dryer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Crosby Area','Central Electric','0','LT 33 BLK 2 INDIAN SHORES SEC 5','Cleared,Subdivision Lot','26070','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','12 - Crosby','NEWPORT ELEMENTARY SCHOOL','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Appointment Required','Appraisal District','2','Traditional','Indian Shores Sec 05','1578','2.7056','Public Sewer,Public Water','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','216415293','1675217212','216415293','2023-01-21T17:55:58.357','43069620','John Pham','REMAX ASPIRE','','','29.993787','-95.496605','23','77068','5','345000.00','Active','Lake Cypress','4131','Circle','Houston','2','1','4','2620','Single-Family','Your Lakefront estate is here!!.. This 2 story home has been well maintained throughout. Soaring high 9-foot ceiling on the first floor, allow plenty of natural light to saturate living areas. The kitchen opens up to the den with plenty of windows throughout. Truly a grand owners retreat on the first floor. Enjoy a mild evening or entertain guests on your covered patio with sweeping views of you lakefront. Retail and dining establishments are situated right outside of the community.','0.1312','13','','','','','Mud,Sellers Disclosure','','','','1960/Cypress Creek North','Central Gas','1','LT 5 BLK 3 CYPRESS CREEK CROSSING SEC 2','Subdivision Lot,Water View,Waterfront','5715','Appraisal District','','750','0','','2','','0','','','','','Composition','48 - Spring','PAT REYNOLDS ELEMENTARY SCHOOL','WESTFIELD HIGH SCHOOL','EDWIN M WELLS MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Cypress Crk Xing Sec 2','6851','2.5842','Water District','2016','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','216534502','1675217212','216534502','2023-01-21T17:20:27.520','80823585','Jarred DeMore','Keller Williams SoutheastTexas','','','29.460609','-94.627928','38','77650','5','470000.00','Active','Seahorse','2115','Lane','Crystal Beach','2','0','3','1584','Single-Family','Beach side beauty! Check out this 3/2. 1584sqft. Direct beach access just a short golf cart ride away. This home was started in 2018 and previous seller finished it in late 2022. Very modern and sleek. All new stainless appliances, stackable washer/dryer and an open concept from kitchen to living room. There is plenty of outdoor deck space to have your BBQ or sit on the deck sipping your morning coffee. The possibilities for an STR or full-time living are endless... this property is located in the heart of Crystal Beach and it is priced right! Schedule your showing before this one goes!','0.1148','33','Tomas Aguilar','','','','Sellers Disclosure','','','','Crystal Beach','Central Electric','0','ABST 65 B FRANKS SUR LOT 4 ALBERDIE ADDN NO 1','Other','5000','Appraisal District','','','1','Never Lived In','0','','0','','','','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required','Appraisal District','1','Traditional','Alberdie Add 1','6148','1.6113','Aerobic','2018','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','216563767','1675217212','216563767','2023-01-21T18:11:48.540','30760451','Ali Palacios','Happy Clients Realty Group','','','29.840170','-95.403970','18','77018','6','195000.00','Active','Delz','320','Street','Houston','1','0','3','1074','Single-Family','Welcome home to your dream property! This is an amazing opportunity for you to build the home of your dreams on a large lot located off of Yale between Garden Oaks and Independence Heights. Enjoy all that this prime location has to offer with nearby shopping, amazing restaurants, parks and more – just minutes from downtown Houston, The Heights, The Galleria, Memorial Park and the Energy Corridor. You’ll love being surrounded by beautiful mature trees which line the street along with having a huge backyard perfect for outdoor entertaining. There is already a 3 bedroom 1 bath home on the property but it\'s priced for lot value so you can create something special in this ideal setting. Don\'t miss out on this unique chance!','0.2417','9','','','Washer Connections','','Sellers Disclosure','0','','','Northwest Houston','Central Gas','0','TR 4B JANISCH','Subdivision Lot','10530','Appraisal District','','','0','','0','Electric Oven','0','','','Freestanding Range','','Composition','27 - Houston','HIGHLAND HEIGHTS ELEMENTARY SCHOOL','WASHINGTON HIGH SCHOOL','WILLIAMS MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Janisch','1953','2.3307','Public Sewer,Public Water','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','216622699','1675217212','216622699','2023-01-21T18:28:04.730','74201013','Jeri Bailey','JLA Realty','','','30.455059','-94.936146','23','77371','7','151500.00','Active','Oak Crest','90','Drive','Shepherd','2','0','2','1050','Single-Family','Country living in this cute updated home in Lake Tejas subdivision on .5 acre. Home has been updated. It has new PEX plumbing, new paint throughout, new fixtures and new appliances coming. Extra bonus room for another bedroom and/or office. Seller will be installing a new aerobic septic system upon closing, recent maintenance on HVAC system, and property has public water. There is a 12x12 back covered porch great for relaxing and/or entertaining, large back yard and 2- car carport. Lake community and quiet neighborhood not far from town and minutes from highway 69.','0.5','64','','','','','Sellers Disclosure','0','','','Coldspring/South San Jacinto County','Central Electric','0','LAKE TEJAS, LOT 160, ACRES .5','Cleared','21780','Appraisal District','','','0','','0','','0','','','Electric Range','','Composition','130 - Shepherd','SHEPHERD PRIMARY SCHOOL','SHEPHERD HIGH SCHOOL','SHEPHERD MIDDLE SCHOOL','Lockbox Back','Seller','1','Traditional','Lake Tejas','1085','1.7852','Aerobic','1978','Appraisal District'); --> New record created successfully