Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:20:28.027' ,`MLSNumber` = '81889151' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.981291' ,`Longitude` = '-95.206715' ,`PhotoCount` = '28' ,`PostalCode` = '77346' ,`RoomCount` = '7' ,`ListPrice` = '294900.00' ,`Status` = 'Active' ,`StreetName` = 'Stillwater Place' ,`StreetNumber` = '18106' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Instantly appealing with its treed lot and arched windows, this charming one story home is sure to please. You will never miss out on the action from the spacious kitchen overlooking the living rooms. The chef in the house will adore the abundant cabinet and counter space complete with center island. Spend time outdoors in this spacious and welcoming backyard with more than six beautiful mature trees. Book a tour with your real estate agent today and feel right at home!' ,`Acres` = '0.213' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 4 PARK AT ATASCOCITA FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9278' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '390' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WHISPERING PINES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park At Atascocita Forest 03' ,`TaxAmount` = '6146' ,`TaxRate` = '2.773' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640998' WHERE `Matrix_Unique_ID` = '207117382' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:05:49.770' ,`MLSNumber` = '30818744' ,`ListAgentFullName` = 'Teresa Hill' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.818414' ,`Longitude` = '-95.121207' ,`PhotoCount` = '14' ,`PostalCode` = '77360' ,`RoomCount` = '2' ,`ListPrice` = '89670.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 356' ,`StreetNumber` = '666' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is located on FM 356, Could also be commercial property. Property is OCCUPIED. \r\nPLEASE DO NOT DISTURB THE TENANTS. This property is part of a group of homes that are being sold \"As Is\". Investment Opportunity. Dimensions to be verified.\r\nHome is on the tax roll as 666 FM 356, it is marked as 658 FM 356' ,`Acres` = '0.2242' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 2 LOT 14 & 15 PT' ,`LotDesciption` = 'Other' ,`LotSize` = '9768' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Canyon Park Sec 2' ,`TaxAmount` = '1136' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640998' WHERE `Matrix_Unique_ID` = '208140104' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:38:04.370' ,`MLSNumber` = '36697837' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.019499' ,`Longitude` = '-95.415522' ,`PhotoCount` = '27' ,`PostalCode` = '77073' ,`RoomCount` = '5' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Queenbury Hills' ,`StreetNumber` = '22330' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great 3 bedroom, 2 bathroom home! This home offers a covered front porch, and a two car garage.' ,`Acres` = '0.1085' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 2 IMPERIAL GARDEN SEC 3' ,`LotDesciption` = 'Other' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CAROLEE BOOKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Garden Sec 03' ,`TaxAmount` = '4401' ,`TaxRate` = '2.7904' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640999' WHERE `Matrix_Unique_ID` = '208980047' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:51:12.850' ,`MLSNumber` = '42280240' ,`ListAgentFullName` = 'Helen Pac Franco' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '13.930425' ,`Longitude` = '-90.834027' ,`PhotoCount` = '18' ,`PostalCode` = '' ,`RoomCount` = '4' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Condominio Linda Mar Puerto San Jose' ,`StreetNumber` = '0' ,`StreetSuffix` = '' ,`City` = 'Other' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1361' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to own this vacation home with great rental potential in Puerto San José. This property has 3 spacious bedrooms and 2 bathrooms. Soaring high ceilings, wonderful layout, and a huge family room with open kitchen and dining. Covered front porch with a beautiful view to the pool. Direct access to the beach. Very extensive property with lots of potential development. Nice size fenced yard. Points of interest: close to the naval base, 1.5 hours away from the main city Guatemala. Main attractions deep sea fishing, lots of marine live such as sea turtles, sailfish, Marlin Fish. Great Roads to travel from town to town. 30 minutes to Playas El Paredón to Enjoy surfing and Live Marine Watch.' ,`Acres` = '' ,`Area` = '82' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'NA' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '70347' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '70' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '' ,`SchoolElementary` = '' ,`SchoolHigh` = '' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Condominio Linda Mar' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669640999' WHERE `Matrix_Unique_ID` = '209083554' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T21:08:55.857' ,`MLSNumber` = '28169824' ,`ListAgentFullName` = 'Kariliz Perez' ,`ListOfficeName` = 'Stone & Fields' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.618126' ,`Longitude` = '-95.243051' ,`PhotoCount` = '30' ,`PostalCode` = '77075' ,`RoomCount` = '4' ,`ListPrice` = '304900.00' ,`Status` = 'Active' ,`StreetName` = 'Habitat' ,`StreetNumber` = '9646' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1740' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready December 2022. This NEW community of 65 homes has been thoughtfully designed for family living and convenience near the Hobby Airport. An open floor plan with lots of natural light and beautiful vinyl wood looking floors. The kitchen features designer cabinets, quartz counter tops, gas cooktop, subway tile backsplash and stainless steel GE appliances. Upgrades included are: garage door opener package, tiled shower walls, frameless glass shower and freestanding tub.' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'HGC Build' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22 Block 3' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'HANCOCK ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Villas at Windmill Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669640999' WHERE `Matrix_Unique_ID` = '210024114' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T21:20:54.933' ,`MLSNumber` = '79695906' ,`ListAgentFullName` = 'Elizabeth Coblentz' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = 'Pierre Guitard' ,`SellingOfficeName` = 'Haussmann International Realty' ,`Latitude` = '29.739638' ,`Longitude` = '-95.476581' ,`PhotoCount` = '20' ,`PostalCode` = '77056' ,`RoomCount` = '7' ,`ListPrice` = '575000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wickersham' ,`StreetNumber` = '5661' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1781' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable 3 bedroom home situated on a great lot in Briarcroft Subdivision. Conveniently located near shopping, public/private schools, a wide variety of restaurants offering cuisines from all over the World, plus much more.\r\nThis cozy home flows nicely from the kitchen/breakfast room, dining room, living room, making it a great home for entertaining. The den is located directly off of the kitchen/dining/living rooms & is a perfect option for an office/workout room/game room/playroom. All bedrooms are located on the left side of the house, the living areas/kitchen on the right side of the house. This is great for privacy & quiet time. Don\'t miss the backyard with plenty of room to play, grill, relax, & enjoy the greenery with the privacy of a fenced-in backyard.' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 1 & 2A BLK 2 BRIARCROFT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '727' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarcroft' ,`TaxAmount` = '15128' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669640999' WHERE `Matrix_Unique_ID` = '210359800' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:08:34.110' ,`MLSNumber` = '39181281' ,`ListAgentFullName` = 'Teresa Hill' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.817181' ,`Longitude` = '-95.111196' ,`PhotoCount` = '14' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '48450.00' ,`Status` = 'Active' ,`StreetName` = 'Sequoia' ,`StreetNumber` = '614' ,`StreetSuffix` = 'Lane' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Text agent with request. All dimensions to be verified by client. Home is currently occupied, do not disturb the tenants.' ,`Acres` = '0.1791' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 4 LOT 200' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park' ,`TaxAmount` = '128' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1669640999' WHERE `Matrix_Unique_ID` = '212098731' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:07:58.653' ,`MLSNumber` = '71239425' ,`ListAgentFullName` = 'Teresa Hill' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.817929' ,`Longitude` = '-95.111666' ,`PhotoCount` = '13' ,`PostalCode` = '77360' ,`RoomCount` = '2' ,`ListPrice` = '39250.00' ,`Status` = 'Active' ,`StreetName` = 'Cherokee' ,`StreetNumber` = '616' ,`StreetSuffix` = 'Lane' ,`City` = 'Onalaska' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Text agent with request. All dimensions to be verified by client. Home is currently occupied, do not disturb the tenants.' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 4 LOT 91, 92 & 93 SERIAL# N/A HUD# N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1669641000' WHERE `Matrix_Unique_ID` = '212100219' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T21:10:55.537' ,`MLSNumber` = '40179909' ,`ListAgentFullName` = 'Michael Gray' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.608710' ,`Longitude` = '-95.722420' ,`PhotoCount` = '22' ,`PostalCode` = '77406' ,`RoomCount` = '7' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Country Place' ,`StreetNumber` = '2723' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2215' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Priced to Sell or Lease One Year Minimum. Beautiful Remodeled Split Level with No Rear Neighbors. Brand New 4 Ton A/C with New Duct Work Very rare home with upper deck where you can see miles of farm land with the most beautiful sunrises. 4 Bedrooms 2 Bathrooms with an oversized garage. This plan boasts a private Primary Downstairs with access to a covered patio. Second living area off primary bedroom gives this a private retreat for the owner with built ins and a fireplace. Home has a fully remodeled Kitchen with New Cabinets, Flooring, Backsplash, Quartz Countertops, Farm Sink, Dishwasher, Gas Cooktop, Under Cabinet Microwave, Chimney Style Vent Hood, Dishwasher, Wine Bar and Custom Pantry Area around Refrigerator . Custom Touches include Barn Door Custom Beams Around Kitchen and Custom Farmhouse Curtains.' ,`Acres` = '0.1568' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE GROVE SEC 4, BLOCK 10, LOT 84, R/P' ,`LotDesciption` = 'Greenbelt,In Golf Course Community' ,`LotSize` = '6829' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '195' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level' ,`Subdivision` = 'The Grove Sec 4' ,`TaxAmount` = '4816' ,`TaxRate` = '2.3298' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641000' WHERE `Matrix_Unique_ID` = '212406031' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:04:04.583' ,`MLSNumber` = '90706419' ,`ListAgentFullName` = 'Vernessa Wadsworth' ,`ListOfficeName` = 'Executive Texas Realty' ,`SellingAgentFullName` = 'Chelsea Wingardh' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.234602' ,`Longitude` = '-95.551762' ,`PhotoCount` = '25' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '475000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Douglas Fir' ,`StreetNumber` = '811' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2867' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW! This Gorgeous Home is a 1 story, 3/2 , 2 car garage with Study sitting on a 20,000 sq ft Lot in the Sought out neighborhood of Westwood Subdivision. Featuring a Stone and Brick Exterior, Split Floor Plan, Open Living Areas with Plantation Shutters, Trey Ceilings, Arched Doorways, Crown Molding, Granite Countertops, Gas Oven and Stove, Gas and Electric Washer/Dryer Connections, Gas Fireplace and a Large Covered Patio. The Primary Bedroom is very Spacious with room for a sitting area, nice fixtures, on suite that includes a Walk in Closet, separate tub/shower, double vanities. Home also has a All Home Generator, New A/C 2019, LOW HOA and No MUD. Community Pool and Park.This home is BEAUTIFUL and a MUST SEE. Schedule your showing today!' ,`Acres` = '0.4591' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,HOA First Right of Refusal,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas,Wall Heater,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S949503 - WESTWOOD 03, BLOCK 14, LOT 52' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '228' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood 03' ,`TaxAmount` = '6544' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641000' WHERE `Matrix_Unique_ID` = '212462636' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T21:54:14.500' ,`MLSNumber` = '26502293' ,`ListAgentFullName` = 'James Henderson' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.647691' ,`Longitude` = '-95.484887' ,`PhotoCount` = '50' ,`PostalCode` = '77035' ,`RoomCount` = '8' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Duxbury' ,`StreetNumber` = '5603' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic remodel in Westbury taken down to the studs! Beautiful kitchen features custom cabinets with built in wine rack, concrete counter tops, stainless appliances with gas stove, and deep under-mount sink. Master bedroom features enlarged bathroom with walk in glass shower, dual sinks, concrete counters, vaulted ceiling, huge walk in closet and custom cedar barn doors! All NEW electrical, plumbing, flooring, driveway, HVAC and paint. Indoor laundry and walk in pantry. Giant picture window overlooks backyard entertainer’s delight, complete with spacious deck with pergola (2020), new pine wood perimeter fence and gate. Home video surveillance system, monitored alarm system, mounted electronics, garage door, front door and thermostat controlled by smartphone. Premium home warranty, with one year of fees to be paid by seller from date of sale. Whole home 22 kW Generac standby generator that runs off natural gas line for continuous use (2022) Never flooded!' ,`Acres` = '0.1983' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 112 WESTBURY SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbury Sec 04' ,`TaxAmount` = '7808' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641000' WHERE `Matrix_Unique_ID` = '212801386' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T21:31:48.633' ,`MLSNumber` = '45458765' ,`ListAgentFullName` = 'Lang Bui' ,`ListOfficeName` = 'VTEX Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.662233' ,`Longitude` = '-95.540260' ,`PhotoCount` = '19' ,`PostalCode` = '77031' ,`RoomCount` = '9' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'BANKSIDE' ,`StreetNumber` = '9234' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1752' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS BEAUTIFUL PROPERTY IS LOCATED IN BRAEBURN SUDIVISION, AND IS JUST MINUTES AWAY FROM BELTWAY 8 AND HWY 59, PROVIDING SHORT AND CONVIENIENT TRAVELS TO AND FROM HOME.\r\n\r\nTHIS PROPERTY WAS RECENTLY RENOVATED WITH A FULL KITCHEN UPGRADE INCLUDING GRANITE KITCHEN COUNTER TOPS AND CUSTOM CABINENTS, FRESH PAINT ALL AROUND, AND BRAND NEW BEDROOM WOOD FLOORS. THIS PROPERTY IS PERFECT FOR FAMILY HOME BUYERS LOOKING FOR A TURNKEY HOME THAT IS REQUIRES LITTLE TO NO WORK.\r\n\r\nFOR QUICK CLOSING, SELLERS HAVE DROPED LARGE AMOUNT OF LIST PRICE AND ALSO WILL CONTRIBUTE\r\n$5,000.00 FOR FIXING DRIVWAY IF IT IS NEEDED' ,`Acres` = '0.1641' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 33 BRAEBURN VALLEY WEST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '381' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'VALLEY WEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Braeburn Valley West Sec 02' ,`TaxAmount` = '3861' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641001' WHERE `Matrix_Unique_ID` = '212852372' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T21:35:43.700' ,`MLSNumber` = '17778755' ,`ListAgentFullName` = 'Shean Manickchan' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.940722' ,`Longitude` = '-95.503508' ,`PhotoCount` = '25' ,`PostalCode` = '77066' ,`RoomCount` = '4' ,`ListPrice` = '304000.00' ,`Status` = 'Active' ,`StreetName` = 'Imperial Grove' ,`StreetNumber` = '5606' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2348' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to this newly renovated home nestled in the beautiful Ashcreek subdivision! This home features 4 spacious rooms, 2.5 baths, a family room, living room, dining room and gorgeous kitchen. The home has fresh paint in and out, new flooring in bedrooms, and a renovated kitchen. Don\'t miss this opportunity to own this gem. This home is conveniently located near major highways including beltway 8. Measurements are approximate. Home never flooded. Call today to schedule your private tour!' ,`Acres` = '0.1543' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 5 ASHCREEK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MCDOUGLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'WUNDERLICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashcreek' ,`TaxAmount` = '4850' ,`TaxRate` = '2.6316' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641001' WHERE `Matrix_Unique_ID` = '212950761' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:04:27.343' ,`MLSNumber` = '50209023' ,`ListAgentFullName` = 'Janelle Williams' ,`ListOfficeName` = 'RE/MAX Cinco Ranch' ,`SellingAgentFullName` = 'Diana Dao' ,`SellingOfficeName` = 'Circa Real Estate' ,`Latitude` = '29.711940' ,`Longitude` = '-95.859908' ,`PhotoCount` = '50' ,`PostalCode` = '77441' ,`RoomCount` = '9' ,`ListPrice` = '855000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hunt Trace' ,`StreetNumber` = '27922' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4150' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*VIDEO IS UNDER THE VIRTUAL TAB LINK*Located in the desirable IBIS LAKES section of Cross Creek Ranch. OUTDOOR LIVING is yours to enjoy with SPARKLING POOL & SPA + fabulous COVERED OUTDOOR KITHCEN PAVILLON w/ remote controlled shade. Step inside this 2 story beauty that is ON POINT W/ DESIGNER TRENDS to find 4 BRs, 3 ½ BA. Highly sought after 2nd BR DOWN & EN SUITE BATH. Floorplan includes a handsome STUDY and a CASUAL DINING AREA that opens to a spacious LIVING ROOM boasting SOARING CEILINGS. Stunning GOURMET KITCHEN is complete w/ ENORMUS GRANITE ISLAND, DBL OVENS & LOFTY PANTRY. Inviting Primary suite leads to luxurious bath featuring FREESTANDING TUB & separate shower. Primary CLOSET delights w/ CUSTOM BUILT INS. Head Upstairs to find GMRM + MEDIA and 2 More BRs! Hidden Storage opens to Attic for more storage. SHUTTERS. 3 CAR GARAGE. CULDESAC. Zoned to Award winning KATY ISD. Walk/Bike to Adams JH /Jordan HS. Enjoy 60+ miles of trails, resort pools, dog park & so much more in CCR!' ,`Acres` = '0.2333' ,`Area` = '36' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEK COVE AT CROSS CREEK RANCH SEC 5, BLOCK 2, LOT 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10162' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'JAMES E RANDOLPH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '18451' ,`TaxRate` = '3.1375' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641001' WHERE `Matrix_Unique_ID` = '213107078' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:12:09.247' ,`MLSNumber` = '23816188' ,`ListAgentFullName` = 'Grayson Bannister' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.805167' ,`Longitude` = '-95.312577' ,`PhotoCount` = '32' ,`PostalCode` = '77026' ,`RoomCount` = '8' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Hilary' ,`StreetNumber` = '5606' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy 2 bed, 1.5 bath home inside the inner loop! Solid surface flooring throughout - NO carpet! Beautiful wide plank laminate wood floors throughout the bright and airy living room and all bedrooms. Updated kitchen features on-trend white painted cabinets, island, new tile floors, and separate bar with seating and shiplap. Lots of room for dining and extra flex space closeby would make a nice seating area, reading nook, or office. Utility room includes a half bath. Two spacious bedrooms also have laminate wood floors and share a remodeled bath. Don\'t miss the fully fenced backyard with lots of green space, a storage shed, and plenty of room to stretch out! Conveniently located with quick access to 610, 69, and Downtown and in close proximity to Lyndon B Johnson Hospital and Hutcheson Park.' ,`Acres` = '0.1717' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 5 STANNARD PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7480' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KASHMERE GARDENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stannard Place' ,`TaxAmount` = '1971' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641001' WHERE `Matrix_Unique_ID` = '213273961' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:30:46.140' ,`MLSNumber` = '81556777' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750080' ,`Longitude` = '-95.821056' ,`PhotoCount` = '28' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '524900.00' ,`Status` = 'Active' ,`StreetName` = 'Spice Trail' ,`StreetNumber` = '2011' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3640' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bedroom, 3.5 bathroom home! Guests are greeted by charming curb appeal, and soaring two story ceilings in the entryway and living room. Entertain friends and family for the holidays in the oversized kitchen, or by the fireplace in the living room. **Home is in the process of being painted**' ,`Acres` = '0.4238' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COUNTRY LAKES AT GRAYSON LAKES SEC 6, BLOCK 2, LOT 25' ,`LotDesciption` = 'Other' ,`LotSize` = '18459' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOODCREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Lakes At Grayson Lakes' ,`TaxAmount` = '8937' ,`TaxRate` = '2.4245' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669641002' WHERE `Matrix_Unique_ID` = '213331078' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T21:22:05.240' ,`MLSNumber` = '32382668' ,`ListAgentFullName` = 'Denise Hackbarth' ,`ListOfficeName` = 'Hackbarth Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.158051' ,`Longitude` = '-96.403764' ,`PhotoCount` = '46' ,`PostalCode` = '77833' ,`RoomCount` = '3' ,`ListPrice` = '267900.00' ,`Status` = 'Active' ,`StreetName` = 'Fifth' ,`StreetNumber` = '705' ,`StreetSuffix` = 'Street' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2963' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wow!!! Two homes walking distance to Blinn College and close to downtown Brenham. The main home is 1814 sq feet per appraisal district and the blue home is 1149 sq feet. The blue home is 2-bedroom one bath with large living area open to kitchen with a covered storage area through the back door. Yellow home is historical looking and offers 2/3 bedrooms 2 full baths, Large Kitchen, Living area and formal dining. Has original wood floors and lots of windows. High ceilings throughout the home. Lots of lovely potential in both homes.' ,`Acres` = '0.578972' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Real Estate Owned' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'KEYS 1ST , BLOCK 23, LOT PT 1A, ALL LOT 2, ACRES 0.2895, (70' ,`LotDesciption` = 'Cleared' ,`LotSize` = '12610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Keys 1st' ,`TaxAmount` = '3963' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641002' WHERE `Matrix_Unique_ID` = '213467064' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:11:43.553' ,`MLSNumber` = '94655624' ,`ListAgentFullName` = 'Grayson Bannister' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795249' ,`Longitude` = '-95.495743' ,`PhotoCount` = '50' ,`PostalCode` = '77055' ,`RoomCount` = '14' ,`ListPrice` = '699000.00' ,`Status` = 'Active' ,`StreetName` = 'Hilshire Park' ,`StreetNumber` = '1410' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3250' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bed, 3.5 bath home in the Hilshire Park gated community! Recently painted. Gorgeous wood floors throughout the 1st & 2nd story including primary & secondary bedrooms. Bright & airy formal LR has plantation shutters & built-ins leading into the formal dining w/ french doors. Large kitchen has granite counters, spacious island w/ seating, SS appliances, breakfast room, & sitting room! Second story primary bedroom has 2 sets of french doors to small standing balconies as well as an en-suite with dual sinks, custom tiled tub & walk-in shower, & large walk-in closet w/ built-in dresser. 2 secondary bdrms on the 2nd floor share a jack & jill bath and have built-in Thomasville cabinets and desks w/ granite tops. The 3rd floor offers a bedroom w/ built-in cherry cabinets. Don\'t miss the backyard w/ a large covered patio & an outdoor kitchen w/ Viking stove. Located across from Moritz Pech Family Park & Valley Oaks Elem School. Quick access to 1-10, Energy Corridor, and Downtown.' ,`Acres` = '0.0705' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'TR 2 BLK 1 HILSHIRE PARK' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '3070' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'VALLEY OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Hilshire Park' ,`TaxAmount` = '14877' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641002' WHERE `Matrix_Unique_ID` = '213661028' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T21:05:20.707' ,`MLSNumber` = '37821037' ,`ListAgentFullName` = 'Jessica Smith' ,`ListOfficeName` = 'Coldwell Banker Ultimate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.951394' ,`Longitude` = '-95.365999' ,`PhotoCount` = '21' ,`PostalCode` = '77541' ,`RoomCount` = '3' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = '6th' ,`StreetNumber` = '1415' ,`StreetSuffix` = 'Street' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located on a spacious lot, this charming home is a great opportunity! Enjoy every aspect from the new foundation to the new vinyl plank flooring. Natural light bathes the interior with a warm welcome. This 3 bed, 2 bath home offers a comfortable living room that opens to a stylish kitchen that features granite countertops and new cabinets. The primary bathroom was completely remodeled and boasts a stand-alone shower with a shampoo nook. Enjoy a large indoor utility room. Located near the Brazos River, you\'ll find any number of eating establishments nearby. Call today to make an offer.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FREEPORT, BLOCK 154, LOT 3 W 1/2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric 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,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Freeport' ,`TaxAmount` = '2736' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641002' WHERE `Matrix_Unique_ID` = '213729853' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T21:04:48.743' ,`MLSNumber` = '4366508' ,`ListAgentFullName` = 'Limei Zhang' ,`ListOfficeName` = 'Keller Williams Realty - Memor' ,`SellingAgentFullName` = 'Shelley Prince' ,`SellingOfficeName` = 'Keller Williams Realty - Memor' ,`Latitude` = '29.679996' ,`Longitude` = '-95.452646' ,`PhotoCount` = '50' ,`PostalCode` = '77096' ,`RoomCount` = '4' ,`ListPrice` = '390000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cliffwood' ,`StreetNumber` = '9418' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2766' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming house is equipped with a gorgeous open concept kitchen, Fully renovated, granite counter top, electric system rewired, roof replaced in 2020. Great size pool for summer family time, Prime location Easy commute to NRG, DT, Museum district, Medical Center, Galleria. Zoned to top tier high school. Contact today for a viewing! Contact for your private showing today!' ,`Acres` = '0.2802' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 2 BLK 35 WILLWO MEADOWS SEC 15' ,`LotDesciption` = 'Other' ,`LotSize` = '12207' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Meadows 15' ,`TaxAmount` = '7304' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641002' WHERE `Matrix_Unique_ID` = '213731119' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T21:34:37.840' ,`MLSNumber` = '30392123' ,`ListAgentFullName` = 'Kathy Garrison' ,`ListOfficeName` = 'Real Living Karapasha Realty' ,`SellingAgentFullName` = 'Julie Pickett' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '29.749262' ,`Longitude` = '-95.760749' ,`PhotoCount` = '32' ,`PostalCode` = '77450' ,`RoomCount` = '11' ,`ListPrice` = '735000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Long Cove' ,`StreetNumber` = '2210' ,`StreetSuffix` = 'Circle' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3974' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this rare find, Mitchell-Carroll custom home. Centrally located in the exclusive gated golf course community of Fairway Manor, all within the heart of Cinco Ranch where location is key! Beautiful mature trees and lush landscaping greet you from the curb. Meticulously maintained inside and out, this home is spacious with lots of natural light, boasting 12 foot ceilings and many windows with spectacular views overlooking the pool and spa. Primary, living and study all with beautiful hard woods, while porcelain tile in den, kitchen and dining for easy maintenance. This home offers lots of storage from the closets, built-ins and generous bathroom space to extra garage space. New updates include HVAC systems, water heaters, toilets, carpet and paint. Backyard paradise includes lots of covered space for entertaining, pool/spa with rock waterfall and ample yard space plus a sports court which offers multiple uses. LOW TAX RATE! Zoned to Award Winning Exemplary Katy ISD!' ,`Acres` = '0.2771' ,`Area` = '36' ,`BuilderName` = 'Mitchell-Carroll' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH NORTH LAKE VILLAGE SEC 6, BLOCK 1, LOT 27' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '12070' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1665' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'FIELDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch North Lake Village Sec 6' ,`TaxAmount` = '11227' ,`TaxRate` = '2.2045' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641003' WHERE `Matrix_Unique_ID` = '213821058' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T21:23:26.840' ,`MLSNumber` = '13975870' ,`ListAgentFullName` = 'Sue Ann Wilson' ,`ListOfficeName` = 'Bian Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811552' ,`Longitude` = '-95.533317' ,`PhotoCount` = '33' ,`PostalCode` = '77080' ,`RoomCount` = '8' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Elmgate' ,`StreetNumber` = '2306' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1859' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a single-story home with 4 bedrooms, a formal dining area, and a family room. The bedrooms are separated from the common areas with a door and hallway. The family room is large and has a fireplace. The bedrooms are carpeted, wood in the great room and dining room, tile in the wet areas. The kitchen has a small breakfast bar and double ovens. The utility room is inside off one of the backdoors. The garage was designed by a handyman! The roof was replaced last year. Water heater is a few years old. Interior walls have fresh paint. DISCLOSURE: SELLER AND AGENT ARE SIBLINGS.' ,`Acres` = '0.1768' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 21A SPRING SHADOWS SEC 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '336' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SPRING SHADOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Spring Shadows Sec 11' ,`TaxAmount` = '6623' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641003' WHERE `Matrix_Unique_ID` = '213909652' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T21:52:23.650' ,`MLSNumber` = '60985141' ,`ListAgentFullName` = 'Connie Buck' ,`ListOfficeName` = 'Flat Fee Discount Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.676312' ,`Longitude` = '-95.435878' ,`PhotoCount` = '13' ,`PostalCode` = '77025' ,`RoomCount` = '3' ,`ListPrice` = '328000.00' ,`Status` = 'Active' ,`StreetName` = 'Meredith Elise' ,`StreetNumber` = '9826' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2251' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HOUSTON LIVING AT ITS BEST. THIS MODERN HOME WITH 3 BEDROOMS, 2.5 BATHS HAS IT ALL. SOARING CEILINGS AND LOTS OF WINDOWS PROVIDE AN ABUNDANCE OF NATURAL LIGHT. GORGEOUS CHEF\'S KITCHEN IS EQUIPPED WITH STAINLESS STEEL APPLIANCES AND GRANITE COUNTERTOPS. ENJOY WORKING FROM HOME AT THE CUSTOM BUILT-IN DESK. COZY UP IN THE EVENING IN FRONT OF THE FIREPLACE. LARGE PRIMARY BEDROOM COMES WITH A HUGE CLOSET OFFERING PLENTY OF ROOM FOR A LARGE WARDROBE. UNWIND AT THE END OF THE DAY IN THE SPA LIKE BATHROOM THAT INCLUDES DOUBLE SINKS, LARGE SOAKING TUB AND SEPERATE STAND-UP SHOWER. HOME SITS ON TOP OF YOUR OWN PRIVATE TWO CAR GARAGE, IS IN GATED COMMUNITY AND INCLUDES FENCED IN BACKYARD. LOCATED IN THE HEART OF HOUSTON, ONLY MINUTES AWAY FROM EVERYTHING THAT H-TOWN HAS TO OFFER! WELCOME HOME!' ,`Acres` = '0.0346' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 CONTEMPORARY PLAZA SEC 8' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1508' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '60' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHEARN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Contemporary Plaza Sec 08' ,`TaxAmount` = '6439' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641003' WHERE `Matrix_Unique_ID` = '213990693' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T21:13:48.037' ,`MLSNumber` = '45416208' ,`ListAgentFullName` = 'Matt Issa' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.915787' ,`Longitude` = '-93.947896' ,`PhotoCount` = '16' ,`PostalCode` = '77642' ,`RoomCount` = '3' ,`ListPrice` = '168999.00' ,`Status` = 'Active' ,`StreetName` = '39th' ,`StreetNumber` = '3007' ,`StreetSuffix` = 'Street' ,`City` = 'Port Arthur' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1664' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1354' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PARK PLACE 5 LT 5 BLK 22' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '5900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '236 - Port Arthur' ,`SchoolElementary` = 'HOUSTON ELEMENTARY SCHOOL (PORT ARTHUR)' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PORT ARTHUR)' ,`SchoolMiddle` = 'LINCOLN MIDDLE SCHOOL (PORT ARTHUR)' ,`ShowInstructions` = 'Leave Business Card,Lockbox Back,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Place To Port Arthur' ,`TaxAmount` = '3022' ,`TaxRate` = '3.267' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641003' WHERE `Matrix_Unique_ID` = '214025170' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:42:12.913' ,`MLSNumber` = '85119915' ,`ListAgentFullName` = 'Nina Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.475037' ,`Longitude` = '-95.170538' ,`PhotoCount` = '49' ,`PostalCode` = '77573' ,`RoomCount` = '6' ,`ListPrice` = '439990.00' ,`Status` = 'Active' ,`StreetName` = 'Westwood' ,`StreetNumber` = '812' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2385' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS ONE-STORY, 4 BEDROOMS, 2.5 BATH, STUDY AND 3 CAR TANDEM GARAGE! Built by D.R Horton, the Lancaster floor plan features an open-concept living and dining space w/ spacious rooms. Silestone countertops, 42\" cabinets, a large breakfast island, and stainless steel appliances make this kitchen a chef\'s dream. Luxury vinyl plank floors throughout. Enjoy the party outside with an oversized covered patio. Located in League City, WESTWOOD offers easy access to shopping, dining, and entertainment. Residents can enjoy resort-style amenities including a splash pad, pool, amenities center, and playground. Zoned to highly-acclaimed CCISD. Schedule a showing today to learn more!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Westwood Lot 8 Block 4 Section 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood' ,`TaxAmount` = '' ,`TaxRate` = '3.07' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641004' WHERE `Matrix_Unique_ID` = '214089459' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T21:12:30.163' ,`MLSNumber` = '40452282' ,`ListAgentFullName` = 'Jessica Smith' ,`ListOfficeName` = 'Coldwell Banker Ultimate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.004948' ,`Longitude` = '-95.298199' ,`PhotoCount` = '31' ,`PostalCode` = '77541' ,`RoomCount` = '5' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Treasure' ,`StreetNumber` = '107' ,`StreetSuffix` = 'Lane' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located on the canal in Hide-A-Way on the Gulf, you\'ll find a spacious 3 bed/ 2 bath home with some amazing amenities! Enjoy island life in this open floor plan at 107 Treasure Lane. It rests above a 3-car garage and includes an enclosed elevator that will allow your guests to visit with ease. Under a vaulted ceiling with recessed lighting, you\'ll have ample space to move about comfortably. Beautiful wood laminate runs seamlessly throughout most of the home. The family room is open to an island kitchen where you\'ll find plenty of room to enjoy casual dining. Granite countertops blend perfectly with dark, rich cabinets. You\'ll love sipping coffee as you enjoy dessert on the balcony! An office bathed in natural light offers access to a glorious deck overlooking the canal under which a boat slip is located. Relax on the deck or in the shade of a screened-in sunroom. A ground-level covered patio is another shaded place to relax and visit with friends. Live the life you love near the gulf!' ,`Acres` = '0.1927' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HIDE-A-WAY ON GULF UNIT 1 (A0009 B T ARCHER) LOT 188' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '8394' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Photos/No Videos,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hide-A-Way On Gulf' ,`TaxAmount` = '8318' ,`TaxRate` = '2.2069' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641004' WHERE `Matrix_Unique_ID` = '214107565' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:05:41.813' ,`MLSNumber` = '15008715' ,`ListAgentFullName` = 'Daniel Wright' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = 'David Tello' ,`SellingOfficeName` = 'Lions Gate Realty' ,`Latitude` = '30.379595' ,`Longitude` = '-95.503086' ,`PhotoCount` = '39' ,`PostalCode` = '77304' ,`RoomCount` = '12' ,`ListPrice` = '342000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Dusty Melody' ,`StreetNumber` = '7602' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2464' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is it! Looking for a move-in ready 4 bed, 2 1/2 bath home, huge yard on ~1/3 acre, beautiful 20x14 covered pergola + porch swing, storage shed & greenhouse? You\'ve found your match! 7602 Dusty Melody boasts 2,464 sqft of living space & is ready for its new owners. Inside, you\'re greeted by freshly painted interior, a spacious living room leading into the dining room & kitchen with granite countertops, breakfast bar + pantry. Utility room & half bath are also found downstairs. All bedrooms upstairs + game room. Large primary bedroom with tall 10ft ceilings, a huge walk-in closet & view of your backyard + private bathroom. All secondary bedrooms are spacious, one could even be used as a second primary! It\'s conveniently located close to i45 & minutes from Lake Conroe -> fun activities & tons of grocery, restaurants, home improvement stores & all shopping just around the corner. You\'re guaranteed to enjoy your new home with a great location for years to come. Stop by & stay a while!' ,`Acres` = '0.2911' ,`Area` = '39' ,`BuilderName` = 'LGI Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S340203 - CHASE RUN 03, BLOCK 2, LOT 11' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '12682' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '432' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Chase Run' ,`TaxAmount` = '5581' ,`TaxRate` = '2.1823' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641004' WHERE `Matrix_Unique_ID` = '214188394' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T21:35:15.687' ,`MLSNumber` = '21553898' ,`ListAgentFullName` = 'Anh Tran' ,`ListOfficeName` = 'ABSOLUTE Realty Group Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.698615' ,`Longitude` = '-95.682206' ,`PhotoCount` = '18' ,`PostalCode` = '77083' ,`RoomCount` = '3' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Espinosa' ,`StreetNumber` = '16742' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1175' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This cozy 3 bedroom, 2 bath, 1 story, newer built home in Mission West is ready for you to call it home! Home features open concept floorplan with lots of natural lights. The new kitchen comes with soft-closed cabinets, quartz countertop and SS appliances. New vinyl and tile floorings. Fresh interior/exterior paints. Beautifully updated bathrooms. New Roof. New ceiling fans and light fixtures. Zoned to desired Fort Bend schools, just minutes from the Westpark Tollway. Never flooded. Hurry! You don’t want to miss this adorable home.' ,`Acres` = '0.1374' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MISSION WEST SEC 1, BLOCK 5, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5986' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MISSION WEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Mission West Sec 1' ,`TaxAmount` = '4862' ,`TaxRate` = '2.4297' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641004' WHERE `Matrix_Unique_ID` = '214211032' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T21:40:47.533' ,`MLSNumber` = '73094600' ,`ListAgentFullName` = 'Matt Issa' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.953390' ,`Longitude` = '-95.372158' ,`PhotoCount` = '14' ,`PostalCode` = '77541' ,`RoomCount` = '5' ,`ListPrice` = '189900.00' ,`Status` = 'Active' ,`StreetName` = '6th' ,`StreetNumber` = '1757' ,`StreetSuffix` = 'Street' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '1660' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1751' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FREEPORT, BLOCK 180, LOT 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '7627' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,No Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Freeport' ,`TaxAmount` = '2818' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641005' WHERE `Matrix_Unique_ID` = '214225212' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T21:17:11.890' ,`MLSNumber` = '44068232' ,`ListAgentFullName` = 'Maria A. Lugo' ,`ListOfficeName` = 'Sean Powers Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.290385' ,`Longitude` = '-94.809738' ,`PhotoCount` = '24' ,`PostalCode` = '77550' ,`RoomCount` = '6' ,`ListPrice` = '357500.00' ,`Status` = 'Active' ,`StreetName` = '40th' ,`StreetNumber` = '1502' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1366' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this newly remodeled and updated home on a corner lot!\r\n\r\nThis 3 bedroom 2 bathroom home is located near the Galveston Pleasure Pier and the Strand which makes it a perfect location for a family home or vacation rental property. \r\n\r\nA few minutes away from the Galveston Seawall, the beach, and other local attractions.' ,`Acres` = '0.0592' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR N 1/2 OF LOT 1 (1001-1) NE BLK 34 GA' ,`LotDesciption` = 'Corner' ,`LotSize` = '2580' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '4705' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641005' WHERE `Matrix_Unique_ID` = '214368194' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:59:16.870' ,`MLSNumber` = '50799023' ,`ListAgentFullName` = 'Brooke Mason' ,`ListOfficeName` = 'Cross-Town Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.494579' ,`Longitude` = '-96.468722' ,`PhotoCount` = '10' ,`PostalCode` = '77878' ,`RoomCount` = '7' ,`ListPrice` = '268500.00' ,`Status` = 'Active' ,`StreetName` = 'Rustic Trace' ,`StreetNumber` = '233' ,`StreetSuffix` = '' ,`City` = 'Snook' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1429' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This new-build home, in the Grand Lake Community, is MOVE IN READY and has a desirable, open floor plan and includes 3 bedrooms and a covered patio space out back. This dream home boasts modern cabinetry, granite countertops, and stunning, Stainless-Steel Appliances. Additionally, the primary bedroom has an en-suite, private bath complete with dual vanity sinks and a walk-in closet. Come see this gem of a home today.' ,`Acres` = '' ,`Area` = '59' ,`BuilderName` = 'WJH, LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S3451 GRAND LAKE OF SNOOK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8189' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '65' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '192 - Snook' ,`SchoolElementary` = 'SNOOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SNOOK SECONDARY SCHOOL' ,`SchoolMiddle` = 'SNOOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Lakes of Snook' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641005' WHERE `Matrix_Unique_ID` = '214457062' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:58:22.927' ,`MLSNumber` = '19531085' ,`ListAgentFullName` = 'Brooke Mason' ,`ListOfficeName` = 'Cross-Town Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.494579' ,`Longitude` = '-96.468722' ,`PhotoCount` = '11' ,`PostalCode` = '77878' ,`RoomCount` = '8' ,`ListPrice` = '287900.00' ,`Status` = 'Active' ,`StreetName` = 'Rustic Trace' ,`StreetNumber` = '136' ,`StreetSuffix` = '' ,`City` = 'Snook' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1776' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fall in love with this New-Build, Single-Story Home in Snook\'s Grand Lake Community. This home has an open floor plan encompassing the Living, Dining, and Kitchen spaces. The Kitchen features sparkling, granite countertops, and Stainless-Steel Steel Appliances. The primary bedroom has a private, en-suite bath with dual vanity sinks and a walk-in closet. Completing this home, 3 more bedrooms, a full secondary bath, and a relaxing, covered patio space in the back yard. Come see this gem of a home and imagine the new memories you could make here!' ,`Acres` = '0.214' ,`Area` = '59' ,`BuilderName` = 'WJH LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S3451 GRAND LAKE OF SNOOK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9321' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '65' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '192 - Snook' ,`SchoolElementary` = 'SNOOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SNOOK SECONDARY SCHOOL' ,`SchoolMiddle` = 'SNOOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Lake of Snook' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641005' WHERE `Matrix_Unique_ID` = '214510249' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:17:02.843' ,`MLSNumber` = '57410445' ,`ListAgentFullName` = 'Kayla Brisbin' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.418473' ,`Longitude` = '-94.697672' ,`PhotoCount` = '40' ,`PostalCode` = '77650' ,`RoomCount` = '9' ,`ListPrice` = '1156000.00' ,`Status` = 'Active' ,`StreetName` = 'Ranger' ,`StreetNumber` = '4416' ,`StreetSuffix` = 'Drive' ,`City` = 'Port Bolivar' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2556' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Better than new, this custom home is equipped w/DOUBLE fridge, DOUBLE washer&dryer, & comes FULLY FURNISHED! Enchanted w/cool coastal colors, soaring ceilings, shiplap walls, sand shower & downstairs bar to name a few. More than enough room for everyone (sleeps 22). Entertain year round in the fully equipped open plan kitchen featuring custom cabinetry, beautiful blue tile backsplash, & 11-foot-long island w/BF seating. The primary features a ship lap wall, spa-like ensuite w/double sinks, vanity, soaking tub, & walk-in shower w/dual head & rainfall shower system. Upstairs are 2 large bedrooms w/ensuite baths, game room (adds aprox. 239 sqft to 2556 sqft), locked storage room & 2nd story deck. Enjoy the ease of the cargo lift, owners closet w/keypad lock & owners garage; perfect for managing renters. Walk to the beach where it\'s wider & less congested. Close to Bolivar Yacht Basin for easy access to East Galveston Bay & minutes away from the the ferry & all Crystal Beach has to offer!' ,`Acres` = '0.1573' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Port Bolivar' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HOLIDAY SHORES REPLAT (2007) ABST203, BLOCK 3, Lot 17' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6851' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Holiday Shores' ,`TaxAmount` = '9794' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641005' WHERE `Matrix_Unique_ID` = '214543025' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214619333','1669641006','214619333','2022-11-21T21:05:55.900','54269965','Adrianna Trevino','NetWorth Realty Houston North','','','30.225110','-95.610911','36','77354','6','590000.00','Active','Sendera','9811','Drive','Magnolia','3','1','3','2500','Single-Family','Elegance meets comfort! This exquisite home is located in the prestigious community of Sendera Lake Estates. This home has natural light that flows through the living room. This house also features vaulted ceilings, a gorgeous double sided fireplace, breakfast bar seating, and a large formal dining area. The House comes with all new stainless steel appliances in the kitchen including a new refrigerator and new dishwasher. The Primary bedroom is spacious with a large walk-in closet and a newly renovated bathroom that includes 2 shower panels and a brand new soaking tub. This fantastic homed also has a new AC system, water heater, 12x20 craft shed with electricity, and a two story storage shed approximately 16x20. The large backyard is perfect for family gatherings and enjoying being outside while cooking on the outside grilling area.\r\n It is also close to shopping, restaurants, and other fun entertainment. Come take a look at this hidden gem on your must see list today!','2.25','15','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Magnolia/1488 East','Central Electric','1','Sendera Lake Estates 01, Block 3, Lot 1','Wooded','87120','Appraisal District','','470','0','','2','','0','','','Electric Range','','Composition','36 - Magnolia','BEAR BRANCH ELEMENTARY SCHOOL (MAGNOLIA)','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Seller','1','Traditional','Sendera Lake Estate 01','6693','1.8587','Public Water,Septic Tank','1992','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:59:53.500' ,`MLSNumber` = '50644283' ,`ListAgentFullName` = 'Courtney Johnson Rose' ,`ListOfficeName` = 'George E. Johnson Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.478928' ,`Longitude` = '-95.374060' ,`PhotoCount` = '32' ,`PostalCode` = '77578' ,`RoomCount` = '6' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = 'Water Glen' ,`StreetNumber` = '7006' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2835' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You must see this home! Its Like New! Less than 5 years old and still has the 10yr. structural warranty from the builder. Wood-style tile floors throughout the home. Carpet on bedroom floors for comfort. It has a gorgeous and spacious kitchen that\'s open to the living and dinning area. Centered and perfect for family or entertaining. Fenced backyard with covered patio. This home has been exceptionally well-kept and features 4 br, study, 3 full baths, & attached 2 car garage all on one floor. This is the one, do not miss it.' ,`Acres` = '0.1722' ,`Area` = '5' ,`BuilderName` = 'Beazer' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLUEWATER LAKES SEC 2 (MANVEL) BLK 1 LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7501' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bluewater Lakes' ,`TaxAmount` = '13631' ,`TaxRate` = '3.7274' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641006' WHERE `Matrix_Unique_ID` = '214638854' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T21:13:51.187' ,`MLSNumber` = '66908185' ,`ListAgentFullName` = 'Anmol Dalwadi' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.701890' ,`Longitude` = '-95.083031' ,`PhotoCount` = '50' ,`PostalCode` = '77351' ,`RoomCount` = '9' ,`ListPrice` = '239500.00' ,`Status` = 'Active' ,`StreetName` = 'Heather' ,`StreetNumber` = '246' ,`StreetSuffix` = 'Lane' ,`City` = 'Livingston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2132' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RARE FIND! 4-bedroom & 3 bath Water View home! Immaculate move-in ready! Gated Subdivision. (Realtor required to enter) has a pool, (within walking distance), playground, boat launch, tennis courts. Living area has wood burning fireplace. Separate Kitchen/dining is open concept. Off dining area is a 22’x21’ covered patio, for ease of entertaining, bbq\'s. etc. Palm trees for tropical look. Split bedroom floor plan. 4th bedroom has a full bath/shower. Master suite has jetted tub, free standing shower & huge walk-in closet. 9’x 4’ utility rm. with wet sink & cabinets galore~more in hallway. Optional furniture and appliances including washer and dryer (on separate bill of sale) at closing. A/C & all duct work replaced approx. 4 yrs. Roof \'08. Seller has leveled the home (with transferable warranty). 48K in renovations to the home!' ,`Acres` = '0.2035' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'MEMORIAL POINT BLK 5 LOT 10' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '8866' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '129' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Point' ,`TaxAmount` = '5353' ,`TaxRate` = '2.7745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641006' WHERE `Matrix_Unique_ID` = '214701238' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:58:56.577' ,`MLSNumber` = '21391587' ,`ListAgentFullName` = 'Brooke Mason' ,`ListOfficeName` = 'Cross-Town Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.613653' ,`Longitude` = '-96.411292' ,`PhotoCount` = '10' ,`PostalCode` = '77807' ,`RoomCount` = '9' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Fox Bluff' ,`StreetNumber` = '5516' ,`StreetSuffix` = 'Drive' ,`City` = 'Bryan' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1797' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE IN READY! This new-build home, in Foxwood Crossing, has a desirable, open floor plan and includes 4 bedrooms and a covered\r\npatio space out back. This dream home boasts modern cabinetry, granite countertops, and stunning, Stainless-Steel Appliances.\r\nAdditionally, the primary bedroom has an en-suite, private bath complete with dual vanity sinks and a walk-in closet. Come see this\r\ngem of a home today.' ,`Acres` = '0.137' ,`Area` = '61' ,`BuilderName` = 'WJH LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'FOXWOOD CROSSING PH 1, BLOCK 2, LOT 16, ACRES .137' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5968' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'MARY BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRYAN HIGH SCHOOL' ,`SchoolMiddle` = 'STEPHEN F. AUSTIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Foxwood Xing Ph 1' ,`TaxAmount` = '1320' ,`TaxRate` = '2.193' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641006' WHERE `Matrix_Unique_ID` = '214701292' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:01:36.560' ,`MLSNumber` = '19739467' ,`ListAgentFullName` = 'Angel Webb' ,`ListOfficeName` = 'Angel Webb Realty, LLC' ,`SellingAgentFullName` = 'Diane Mireles' ,`SellingOfficeName` = 'Visions & Traditions Realty' ,`Latitude` = '29.531283' ,`Longitude` = '-95.198725' ,`PhotoCount` = '15' ,`PostalCode` = '77546' ,`RoomCount` = '3' ,`ListPrice` = '249900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Oak Vista' ,`StreetNumber` = '407' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1694' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming home located in the heart of Friendswood, brick home on an ideal lot in the Harwood Subdivision. This 3 bedroom, 2 bath home features an oversized kitchen open to den with corner fireplace, formal would be ideal for home office, plantation shutters in this room that opens to a lovely view of the picturesque street view, replaced flooring, no carpet, washer, dryer and refrigerator are negotiable, no flooding per seller, privacy fence and nice walkway on side of home to the rear & next to the 2 car garage. Zoned to the sought after Friendswood School District, easy access to I45 and walking distance to shopping, dining, and entertainment. Don\'t Delay - Come make this home yours today! This home has a gas range and electric oven, but seller said it is plumbed for gas.' ,`Acres` = '0.1703' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 151 S MCKISSICK SUR LOT 6 BLK 2 HARWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7420' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harwood' ,`TaxAmount` = '3539' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641006' WHERE `Matrix_Unique_ID` = '214719821' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:36:16.523' ,`MLSNumber` = '89563284' ,`ListAgentFullName` = 'Nicole Hohman' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.782843' ,`Longitude` = '-95.939469' ,`PhotoCount` = '24' ,`PostalCode` = '77423' ,`RoomCount` = '8' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Hereford' ,`StreetNumber` = '319' ,`StreetSuffix` = 'Road' ,`City` = 'Brookshire' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2017' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A little slice of heaven in the private and mature neighborhood of Glenbrook. A ranch styled\r\nhome kept in meticulous condition with 3 bedrooms, 2 baths, formal dining and a sun room. The\r\nkitchen opens up to the family room where you will find a timeless wood burning fireplace. The\r\nsun room offers a sizable space with gorgeous cedar wood ceilings and THE perfect area to relax\r\nand unwind! Both the family and formal dining offer fresh paint, window treatments and crown\r\nmolding. Upgraded secondary bathroom with ceramic tile and granite countertops. The primary is\r\npaired with double closets, granite countertops, ceramic tile and an ADA capable tub/shower\r\njacuzzi combo. Spacious laundry room and attached to a 2-car garage. Situated on an oversized\r\nlot with sweeping trees and located in a neighborhood that will give you that small town feel!\r\nReady and available for move in now!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brookshire' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S502000 GLENBROOK LOT 30' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14474' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '44 - Royal' ,`SchoolElementary` = 'ROYAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROYAL HIGH SCHOOL' ,`SchoolMiddle` = 'ROYAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Glenbrook' ,`TaxAmount` = '5018' ,`TaxRate` = '2.7487' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641007' WHERE `Matrix_Unique_ID` = '214727900' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:29:39.907' ,`MLSNumber` = '80814795' ,`ListAgentFullName` = 'Cortney Dickens' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.429769' ,`Longitude` = '-95.409912' ,`PhotoCount` = '6' ,`PostalCode` = '77303' ,`RoomCount` = '4' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Lake' ,`StreetNumber` = '13290' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1312' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Little country feel, not far from city, with a private neighborhood lake! Huge porch ready for some rocking chairs! 2 bedroom, 1 bath, kitchen/dining room with an island area, living room and dining room seperate. Home is handicap accessible. More pictures to follow!' ,`Acres` = '0.5738' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willis Area' ,`HeatSystem` = 'Central Electric,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'S847000 - ROYAL FOREST 01, BLOCK 68, LOT 429, 430-A - 430-B' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '24996' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '170' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'EDWARD B. CANNAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Royal Forest 01' ,`TaxAmount` = '2181' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Other Water/Sewer,Septic Tank' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641007' WHERE `Matrix_Unique_ID` = '214815814' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T21:23:54.127' ,`MLSNumber` = '71814721' ,`ListAgentFullName` = 'Gaynell Blackshear' ,`ListOfficeName` = 'Blackshear Realty' ,`SellingAgentFullName` = 'Nakia Agee' ,`SellingOfficeName` = 'Luxury Home Advisors' ,`Latitude` = '29.930173' ,`Longitude` = '-95.089008' ,`PhotoCount` = '34' ,`PostalCode` = '77532' ,`RoomCount` = '6' ,`ListPrice` = '207999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Broken Back' ,`StreetNumber` = '17131' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1395' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious one story home, warm and inviting. Granite countertops in kitchen for holiday baking and cooking. Family room with cathedral ceiling and large brick hearth and fireplace that opens to French doors to back yard. Three bedrooms with newer carpet and nice walk in closets. Trendy laminate wood flooring in main area of living room and hall. Kitchen and wet areas with ceramic tile. Beautifully resurfaced tubs and granite counters in baths. Split A/C unit added to home and saves apprx. $100 a month on electric bills. Two car attached garage. Lovely neighborhood with 5 miles of walking wooded trails, country club, Stonebridge at Newport Golf course, community Olympic size swimming pool and park with several parks and ponds throughout neighborhood. New splashpad park almost complete and only 7 houses down. You\'ll love the community and neighborhood! Showings are easy, call your favorite Realtor.' ,`Acres` = '0.1791' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 NEWPORT SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '55' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Newport Sec 10' ,`TaxAmount` = '4862' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641007' WHERE `Matrix_Unique_ID` = '214904259' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:42:47.060' ,`MLSNumber` = '22015774' ,`ListAgentFullName` = 'Justin Phillips' ,`ListOfficeName` = 'Hardee & Company Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.828381' ,`Longitude` = '-95.088448' ,`PhotoCount` = '41' ,`PostalCode` = '77360' ,`RoomCount` = '7' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Birch Dr' ,`StreetNumber` = '371' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come get your slice of Heaven right on Lake Livingston. With a lake view from the front porch this home is a perfect weekend getaway, or home away from home. This 2 bedroom 1 bath home on three lots is located in a well sought after area with nearby access to Lake Livingston. The home itself features a large living room with tall ceilings and skylights that flows into a beautiful, fully furnished kitchen. Perfect for entertaining. If the lake view from the front porch isn\'t enough, head around back and enjoy a soak in your hot tub on the back porch or a refreshing dip in your decked out pool. This property also has a ~30x20 shop on the rear of the property with multiple roll up doors, and a car/boat port for any additional vehicle storage. This house has a lot to offer, so don\'t let this opportunity pass you by.' ,`Acres` = '0.557' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'YAUPON COVE BLK 6 LOT 15, 16 & 22' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '24261' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Yaupon Cove' ,`TaxAmount` = '2715' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641007' WHERE `Matrix_Unique_ID` = '214941815' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-21T22:16:39.990' ,`MLSNumber` = '50482387' ,`ListAgentFullName` = 'Cindi Rickman' ,`ListOfficeName` = 'ROCK REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.385168' ,`Longitude` = '-94.921099' ,`PhotoCount` = '10' ,`PostalCode` = '77590' ,`RoomCount` = '6' ,`ListPrice` = '234900.00' ,`Status` = 'Active' ,`StreetName` = 'Wayside' ,`StreetNumber` = '1726' ,`StreetSuffix` = '' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Super cute 3/2/2 with MANY updates. Fenced backyard. Spacious living room and 2 primary bedrooms. Fireplace with gas lighter. Great home family home!' ,`Acres` = '0.1584' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 205 PAGE 3 LOT 9 BLK 17 WAYSIDE PLACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'KOHFELDT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wayside Place 2' ,`TaxAmount` = '4312' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669641008' WHERE `Matrix_Unique_ID` = '214959191' --> 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','214973806','1669641008','214973806','2022-11-21T21:14:27.207','56763315','Jayda Gray','Keller Williams Realty Austin','','','30.181787','-95.063057','26','77327','4','135000.00','Active','County Road 3558','1395','','Cleveland','2','0','4','1250','Single-Family','Take a look at this beautifully remodeled 4 bed 2 bath home situated on 0.46 acres! This property boasts vinyl flooring throughout, modern finishes, and much more. The kitchen flaunts modern white cabinetry, an electric range, and an abundance of cabinet space. The primary bedroom is generously sized and features an en-suite bath flaunting gorgeous marble flooring and a marble stand-up shower. In addition, the secondary bathroom features dual sinks, marble flooring, and a shower/tub combo. Recent upgrades include a large covered patio and a back deck! Schedule a tour today!','0.46','52','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Cleveland Area','Central Electric','1','GRAND SAN JACINTO, SEC 6, BLOCK 76, LOT 3021, ACRES .46','Cleared','20038','Appraisal District','','120','0','','0','Electric Oven','0','','','Electric Range','','Composition','100 - Cleveland','PINE BURR ELEMENTARY SCHOOL','CLEVELAND HIGH SCHOOL','CLEVELAND MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Grand San Jacinto, Sec 6','1779','1.6917','Public Sewer,Public Water','1995','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','215018029','1669641008','215018029','2022-11-21T22:20:20.600','97398004','Ivannia Recio','Ace Realty','','','29.374608','-94.959479','40','77568','6','194999.00','Active','Bluebonnet','515','Drive','La Marque','2','0','4','1260','Single-Family','','0.2851','33','','','','','Sellers Disclosure','','','','La Marque','Other Heating','0','ABST 150 J D MOORE SUR LOT 11 BLK A INTER-CITY PLACE','Subdivision Lot','12421','Appraisal District','','','0','','1','','0','','','','','Composition','52 - Texas City','HAYLEY ELEMENTARY SCHOOL','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL (TEXAS CITY)','Accompany,Appointment Required,Lockbox Front','Appraisal District','1','Other Style','Intercity Place','3272','2.6428','Public Sewer,Public Water','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','215018166','1669641008','215018166','2022-11-21T21:36:52.510','16382904','Amanda Williams','Connect Realty','','','28.675370','-96.385060','14','77465','1','99600.00','Active','Lobster Lane','237','','Palacios','0','0','1','660','Single-Family','This little barndominium is a FISHERMANS DREAM. The property is ready for you to come and catch some large red fish right outside your backdoor. This property also has a travel trailer that will be sold with the property and is in useable condition while you finish out the barndominium. Come take a look at this property and see all the potential it has to offer. The property is set up for water and electric already and is in working order.','','67','','','','','Sellers Disclosure','','','','','Other Heating','1','BOCA CHICA SEC. IV, LOT 263','Waterfront','','','','','0','','1','','0','','','','','Aluminum','156 - Palacios','CENTRAL ELEMENTARY SCHOOL (PALACIOS)','PALACIOS HIGH SCHOOL','PALACIOS JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Barndominium','Boca Chica No Imp','','','Public Sewer,Public Water','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','215018182','1669641008','215018182','2022-11-21T21:47:46.693','94376159','Magdalena Cano','BHGRE Gary Greene','','','29.785835','-95.326555','30','77026','2','260000.00','Active','Kirk','2515','Street','Houston','2','0','2','1500','Single-Family','Welcome to this spacious fully renovated home. This open floor plan offers 2 bedrooms/2 bathrooms, with tray ceilings, granite countertops, custom-built cabinets, tile floors throughout, a laundry room, and a host of other fine finishes. The roof, plumbing, electrical, appliances, wrought iron gate, and air conditioning of this property were all renovated in 2018. Easy access to main freeways and conveniently located close to Downtown, Toyota Center, Houston Dynamo, Discovery Green, and many restaurants. No HOA! The home is occupied.','0.1148','2','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure,Tenant Occupied','0','','','Denver Harbor','Central Electric','0','LT 15 BLK 2 ROY B NICHOLS','Subdivision Lot','5000','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','DOGAN ELEMENTARY SCHOOL','WHEATLEY HIGH SCHOOL','FLEMING MIDDLE SCHOOL','Accompany,Appointment Required','Seller','1','Traditional','Roy B Nichols','3106','2.3307','Public Sewer,Public Water','1940','Seller'); --> New record created successfully