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-08-30T12:50:31.460' ,`MLSNumber` = '57674332' ,`ListAgentFullName` = 'Manuel Munoz' ,`ListOfficeName` = 'M5 Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804406' ,`Longitude` = '-95.354615' ,`PhotoCount` = '13' ,`PostalCode` = '77009' ,`RoomCount` = '6' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Chapman' ,`StreetNumber` = '4901' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '1470' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 5 bed, 2 bath located near Downtown. This home is selling as-is but has lots of potential with 4 bedroom down and one bedroom upstairs and sits on a corner lot. Close to several major highway for easy access and considered a upcoming area.' ,`Acres` = '0.0459' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TR 10A BLK 140 RYON' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '2000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOOSCAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ryon' ,`TaxAmount` = '3785' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704815' WHERE `Matrix_Unique_ID` = '202223806' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:39:49.260' ,`MLSNumber` = '47925248' ,`ListAgentFullName` = 'Cheryn Reynolds' ,`ListOfficeName` = 'Ameristar, REALTORS' ,`SellingAgentFullName` = 'Julissa Alcantar-Martinez' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.932936' ,`Longitude` = '-95.514393' ,`PhotoCount` = '11' ,`PostalCode` = '77086' ,`RoomCount` = '7' ,`ListPrice` = '179900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Galena Creek' ,`StreetNumber` = '13646' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1740' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Kitchen and dining rooms are open to the living room making for a spacious living space. Covered patio just off dining area makes entertaining easy. The game room is just at the top of the stairs. The primary bedroom features an en-suite bath with beautifully tiled shower. Next door is the neighborhood park! Easy access to Beltway 8 and SH 249. This property is eligible under the First Look Initiative which expires after 20 full days on market. No investor offers until first look period expires. No offers, regardless of buyer type, will be negotiated within the first 7 days of listing. Multiple offers received.' ,`Acres` = '0.0937' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Real Estate Owned' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 1A & 2A BLK 1 BLUE CREEK PAR R/P' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '4080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MCDOUGLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'KLEIN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Blue Creek' ,`TaxAmount` = '4690' ,`TaxRate` = '2.6745' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704815' WHERE `Matrix_Unique_ID` = '202849418' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:51:50.550' ,`MLSNumber` = '11331508' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.980841' ,`Longitude` = '-95.192436' ,`PhotoCount` = '28' ,`PostalCode` = '77346' ,`RoomCount` = '6' ,`ListPrice` = '264900.00' ,`Status` = 'Active' ,`StreetName` = 'Granite Woods' ,`StreetNumber` = '12323' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1216' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 2 CLAYTONS CORNER SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '5299' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ATASCOCITA SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Claytons Corner Sec 01' ,`TaxAmount` = '5086' ,`TaxRate` = '2.933' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704815' WHERE `Matrix_Unique_ID` = '205641468' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:29:24.997' ,`MLSNumber` = '25820524' ,`ListAgentFullName` = 'Robert Miles' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.721256' ,`Longitude` = '-95.572579' ,`PhotoCount` = '37' ,`PostalCode` = '77082' ,`RoomCount` = '9' ,`ListPrice` = '635000.00' ,`Status` = 'Active' ,`StreetName` = 'St Laurent' ,`StreetNumber` = '11215' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2861' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy a quiet secure lifestyle in this guard gated community. Located on a quiet cul-de-sac street in fabulous Royal Oaks Country Club, this 3 bedroom property features no carpet and a delightful pool/spa with tranquil water feature & pergola. Downstairs primary suite with hardwood floors has an elegant en-suite bath with whirlpool tub & two walk in closets. The large family room features gleaming hardwood floors, gas log fireplace, and a view of the beautiful pool/spa. The kitchen is open to the family & breakfast rooms. Kitchen features include granite counters, 5 burner gas cooktop, builtin refrigerator, convection oven, microwave, under cabinet lighting, and plenty of storage and prep space. The adjacent butlers pantry area makes for easy serving to the dining room. Upstairs is an extra large gameroom with wood floors. Two bedrooms & hollywood bath complete the upstairs - one bedroom includes a computer/study niche. Close to shopping, entertainment and major roads.' ,`Acres` = '0.1397' ,`Area` = '31' ,`BuilderName` = 'McVaugh Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 62 BLK 2 ROYAL OAKS COUNTRY CLUB SEC 9' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community' ,`LotSize` = '6086' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3295' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Royal Oaks Country Club' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704816' WHERE `Matrix_Unique_ID` = '206935858' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:19:39.937' ,`MLSNumber` = '22292673' ,`ListAgentFullName` = 'Don Hulen' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.941914' ,`Longitude` = '-95.293681' ,`PhotoCount` = '32' ,`PostalCode` = '77541' ,`RoomCount` = '8' ,`ListPrice` = '469000.00' ,`Status` = 'Active' ,`StreetName` = 'Seashell' ,`StreetNumber` = '1014' ,`StreetSuffix` = 'Drive' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1669' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Surfs up! Spectacular Gulf views abound at this Surfside Beach house! Located one block from the beach, this charming home has numerous decks to soak in the sun and views. This home has not been used as a rental property...but would be a great investment opportunity as a vacation rental, with potential second rental upstairs. This home is offered FULLY FURNISHED...so rental income can start right away! Pilings, roof, windows, 1350sf of wooden decks, and a 900 square foot addition are all less than 10 years old. The addition features an upstairs bedroom with a separate entrance and decks with fantastic views. Easy access from both Surf Drive and Seashell Drive. Other features include Hardi-plank siding, cedar wall coverings, and an outdoor shower. Easy access to the best surfing beach in Surfside. Come enjoy the good life in Surfside Beach!' ,`Acres` = '0.1848' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'SURFSIDE SD A (A0051 F J CALVIT DIV 2 (B C I C)) (SURFSIDE)' ,`LotDesciption` = 'Water View' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'FLEMING ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Surfside' ,`TaxAmount` = '4369' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704816' WHERE `Matrix_Unique_ID` = '208222721' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T13:12:09.980' ,`MLSNumber` = '79684273' ,`ListAgentFullName` = 'Britney Barcus' ,`ListOfficeName` = 'Barcus Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812606' ,`Longitude` = '-95.446388' ,`PhotoCount` = '29' ,`PostalCode` = '77092' ,`RoomCount` = '9' ,`ListPrice` = '555000.00' ,`Status` = 'Active' ,`StreetName` = 'Brookwoods' ,`StreetNumber` = '3710' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3243' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to custom design your dream home in the desirable Oak Forest area. Home has been gutted down to the studs so the options are limitless. This unique home is in a unrestricted area so it can be used as residential and/or commercial. The garage is converted to extra living space and ideal for offices spaces, game room, or as you choose. Home has great bones and situated on a huge ravine lot with mature trees and lots of privacy. Bridge in backyard leads to an extra secluded outdoor oasis. This is another wonderful green space to enjoy or build an addition to the home that fits your lifestyle - a gazebo, fitness/yoga studio, gallery, workshop, or storage. The opportunities are endless! Construction loan available; please inquire from listing agent. Previous design plans available. You are close to hiking/biking trails, restaurants, and a quick commute to Downtown. Enjoy the convenience of near city living with your own private backyard retreat!' ,`Acres` = '0.5969' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 149 BLK 7 BROOK-WOODS ESTATES' ,`LotDesciption` = 'Cleared,Ravine,Subdivision Lot' ,`LotSize` = '26000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Brook-Woods Estates' ,`TaxAmount` = '10434' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663704816' WHERE `Matrix_Unique_ID` = '208566647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:50:41.147' ,`MLSNumber` = '62466617' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.895461' ,`Longitude` = '-95.074804' ,`PhotoCount` = '15' ,`PostalCode` = '77532' ,`RoomCount` = '7' ,`ListPrice` = '340990.00' ,`Status` = 'Active' ,`StreetName` = 'Alaska Cedar' ,`StreetNumber` = '614' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous and spacious CastleRock \"Creede\" 1 story home with 4 bedrooms. Covered patio, granite countertops in the kitchen, 42\" cabinets, High ceilings, large island in the kitchen and vinyl plank flooring.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 1 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6717' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.6256' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704816' WHERE `Matrix_Unique_ID` = '208648249' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:17:36.620' ,`MLSNumber` = '74006082' ,`ListAgentFullName` = 'Cynthia Trahan' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.773752' ,`Longitude` = '-95.429269' ,`PhotoCount` = '47' ,`PostalCode` = '77007' ,`RoomCount` = '7' ,`ListPrice` = '1425000.00' ,`Status` = 'Active' ,`StreetName` = 'Rodrigo' ,`StreetNumber` = '6606' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3302' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING LOCATION!! ENTER THIS LOVELY PROPERTY THROUGH A DECORATIVE WROUGHT IRON GATE, WALK WAY WITH PAVERS, COLUMNS AND A CALMING WATERFALL. BEAUTIFUL HARDWOOD FLOORING THROUGHOUT THIS FRESHLY PAINTED (IN AND OUT) HOME. THIS INCREDIBLE PROPERTY FEATURES A POOL WITH WATERFALL, OUTDOOR KITCHEN, BALCONY AND COVERED PATIO. LARGE OPEN FLOOR PLAN WITH HIGH CEILINGS, ISLAND KITCHEN, SEPARATE ICE MAKER, WINE REFRIGERATOR, SS APPLIANCES AND WALK IN PANTRY. OTHER HIGHLIGHTS INCLUDE AN ELEVATOR, LAUNDRY CHUTE AND A TANKLESS WH. DON\'T MISS THE AIR CONDITIONED GARAGE WITH EPOXY FLOORING. PLENTY OF GUEST PARKING IN YOUR OWN DRIVEWAY AND ON THE STREET.' ,`Acres` = '0.0713' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 BERCONS RODRIGO AVENUE TRAILS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3106' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Camp Logan' ,`TaxAmount` = '19000' ,`TaxRate` = '2.55' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704816' WHERE `Matrix_Unique_ID` = '209244902' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:10:04.000' ,`MLSNumber` = '32388409' ,`ListAgentFullName` = 'Jacqueline Short' ,`ListOfficeName` = 'All City Real Estate, Ltd. Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.911194' ,`Longitude` = '-96.871223' ,`PhotoCount` = '41' ,`PostalCode` = '78945' ,`RoomCount` = '5' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Lafayette' ,`StreetNumber` = '637' ,`StreetSuffix` = 'Street' ,`City` = 'La Grange' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently remodeled home with all the character! Large 2 car garage with storage. Large pecan tree in the front yard and fenced in backyard. New electrical, plumbing, appliances, HVAC and roof.' ,`Acres` = '0.2829' ,`Area` = '69' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MOORE FARM BLOCKS (446) BLK 39 .2829 78 X 158 = 12,324 SFT,' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12324' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '205 - La Grange' ,`SchoolElementary` = 'HERMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA GRANGE HIGH SCHOOL' ,`SchoolMiddle` = 'LA GRANGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Moore Farm Blocks 446' ,`TaxAmount` = '715' ,`TaxRate` = '1.8302' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704816' WHERE `Matrix_Unique_ID` = '209350893' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:41:59.047' ,`MLSNumber` = '17504933' ,`ListAgentFullName` = 'Carlos Sequeira' ,`ListOfficeName` = 'Marland Interest, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.984430' ,`Longitude` = '-95.200755' ,`PhotoCount` = '34' ,`PostalCode` = '77346' ,`RoomCount` = '10' ,`ListPrice` = '292000.00' ,`Status` = 'Active' ,`StreetName` = 'Timber Path' ,`StreetNumber` = '4906' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2709' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two-story home with great curb appeal situated on a corner lot in The Timber Forest subdivision. Property built in 2002 and has 4 bedrooms and 2 full and one half bathroom . Zoned for Humble ISD schools. Wonderful opportunity to own a home in this quiet suburban subdivision!. High vaulted ceilings and lots of windows. Huge Primary bedroom w/ his and her vanities, shower, separate tub and large walk-in closet. 3 additional spacious bedrooms and game room upstairs.' ,`Acres` = '0.1416' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 6 TIMBER FOREST SEC 6' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6166' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '441' ,`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` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Forest Sec 06' ,`TaxAmount` = '6608' ,`TaxRate` = '2.933' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704816' WHERE `Matrix_Unique_ID` = '209555607' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:25:29.053' ,`MLSNumber` = '42842171' ,`ListAgentFullName` = 'Brittany Langley' ,`ListOfficeName` = 'DBL Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.726660' ,`Longitude` = '-95.570771' ,`PhotoCount` = '29' ,`PostalCode` = '77320' ,`RoomCount` = '4' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Valley Street' ,`StreetNumber` = '236' ,`StreetSuffix` = 'Street' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2250' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move in ready! This beautiful 4-bedroom 2-bathroom home is situated on just under a half-acre lot conveniently located in the heart of Huntsville! Forest Hills is a charming neighborhood, seconds from a grocery store and a quick bite to eat, the park is under 1/2 a mile from the door. Within the past decade many awesome improvements have been made: a new roof, air conditioner, furnace, vinyl plank flooring, granite countertops, and new piping throughout the home. The floor plan allows for the cozy feel of along with great flexibility throughout the home, each bedroom has a large closet, and the windows are covered with wooden shutters. As you walk out the back door, you will notice a huge yard, fenced and ready for fur family too! Come check this home out.' ,`Acres` = '0.3367' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'FOREST HILLS - SEC 2, BLOCK 21, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14665' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Hills - Twnhms' ,`TaxAmount` = '3803' ,`TaxRate` = '1.9609' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704817' WHERE `Matrix_Unique_ID` = '209891818' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T13:50:47.200' ,`MLSNumber` = '68897679' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.859023' ,`Longitude` = '-95.193895' ,`PhotoCount` = '26' ,`PostalCode` = '77044' ,`RoomCount` = '5' ,`ListPrice` = '295065.00' ,`Status` = 'Active' ,`StreetName` = 'Karan Park' ,`StreetNumber` = '13214' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1821' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready January 2023 Brand new 1 story 3-bedroom 2 bath 2 car garage. Colina Home features Stormy Night granite countertops, Pewter Gray 42” cabinets, stainless steel range, microwave, and dishwasher, subway kitchen tile backsplash. 9’ ceilings, 2” blinds throughout, large garden tub with separate shower, marble vanities, large walk-in closet, covered back patio, carpet only in bedrooms, luxury vinyl wood plank through out. Raised panel doors, rounded sheetrock corners and archways. 365 day rate lock or $0 down no PMI. PHOTOS ARE REPRESENTATIVE' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6, Block 1, Section 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tidwell Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704817' WHERE `Matrix_Unique_ID` = '209958799' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:18:41.517' ,`MLSNumber` = '28306779' ,`ListAgentFullName` = 'Margarita Ortegon' ,`ListOfficeName` = 'Texas Exclusive Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.707652' ,`Longitude` = '-95.283075' ,`PhotoCount` = '27' ,`PostalCode` = '77012' ,`RoomCount` = '14' ,`ListPrice` = '323900.00' ,`Status` = 'Active' ,`StreetName` = 'Brumblay' ,`StreetNumber` = '7720' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1584' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A HOMEOWNER\'S DREAM!!! A LOVELY 4 BED/1 BATH HOME CONVENIENTLY LOCATED NEAR HWY 610, 225 AND I-45. THE CURRENT OWNERS REMODELATED THE HOUSE RETAINING MOST OF ITS ORIGINAL FEATURES IN 2004. IT FEATURES ENGINEERED HARDWOOD FLOORING AND TILE THROUGHOUT, GRANITE COUNTERS IN THE KITCHEN, UPDATED BATHROOMS, NEW PAINT, NEW LIGHTING FIXTURES AND MORE. DOWNSTAIRS FEATURES 2 BEDROOMS, A LIVING ROOM, A DINING ROOM, A KITCHEN AND A LAUNDRY ROOM. 2 MORE BEDROOMS ARE LOCATED UPSTAIRS. THIS LOT INCLUDES AN ADDITIONAL 1 BEDROOM APARTMENT EQUIPPED WITH A FULL KITCHEN AND BATH. PERFECT FOR THE HOMEOWNER WANTING SOME RENTAL INCOME. THIS BEAUTY WON\'T LAST. CALL FOR AN APPOINMENT TO HAVE A PRIVATE TOUR!!!!' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 92 BLK 4 GLOVERDALE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`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` = 'SANCHEZ ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MILBY HIGH SCHOOL' ,`SchoolMiddle` = 'DEADY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gloverdale' ,`TaxAmount` = '3026' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704817' WHERE `Matrix_Unique_ID` = '210059215' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:52:38.877' ,`MLSNumber` = '29582597' ,`ListAgentFullName` = 'Abel Sanchez' ,`ListOfficeName` = 'SIS Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.931748' ,`Longitude` = '-95.478535' ,`PhotoCount` = '36' ,`PostalCode` = '77086' ,`RoomCount` = '5' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Kaltenbrun' ,`StreetNumber` = '13610' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3259' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '2' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 15A & 15B BLK 11 (009*LT 15 & E1/2 OF 16) WEISENBERGER C' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '87119' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'SHOTWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Weisenberger City 2' ,`TaxAmount` = '11607' ,`TaxRate` = '2.1553' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704817' WHERE `Matrix_Unique_ID` = '210093858' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:43:51.287' ,`MLSNumber` = '35211926' ,`ListAgentFullName` = 'Connie Guide' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.803020' ,`Longitude` = '-95.016583' ,`PhotoCount` = '24' ,`PostalCode` = '77521' ,`RoomCount` = '5' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Wade' ,`StreetNumber` = '7302' ,`StreetSuffix` = 'Road' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1279' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large Lot 20,473. Non restricted. Large shaded front yard with large pecan tree .. long driveway for extra parking. Open floor plan. Living room has high ceiling and a fireplace. Primary bedroom has high ceiling, linen closet, and a walk-in closet. Kitchen has a large window to view large backyard. Third bedroom has high ceiling a large triple window. All room sizes are approximate. Pls Verify.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 TERRELL ACRES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20473' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HARLEM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Terrell Acres' ,`TaxAmount` = '2098' ,`TaxRate` = '2.1' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704817' WHERE `Matrix_Unique_ID` = '210203193' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:51:31.020' ,`MLSNumber` = '50171103' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.893870' ,`Longitude` = '-95.074895' ,`PhotoCount` = '21' ,`PostalCode` = '77532' ,`RoomCount` = '9' ,`ListPrice` = '358990.00' ,`Status` = 'Active' ,`StreetName` = 'Alberta Spruce' ,`StreetNumber` = '14218' ,`StreetSuffix` = 'Lane' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2513' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large 2 Story plan with a 2-story family room. If you are looking for a large home with Granite Countertops in the kitchen, Island, a covered patio, and a large game room, this is your home!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5, Block 4, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.6256' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704817' WHERE `Matrix_Unique_ID` = '210291815' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:51:48.943' ,`MLSNumber` = '32896227' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.894191' ,`Longitude` = '-95.075324' ,`PhotoCount` = '21' ,`PostalCode` = '77532' ,`RoomCount` = '9' ,`ListPrice` = '358990.00' ,`Status` = 'Active' ,`StreetName` = 'Alberta Spruce' ,`StreetNumber` = '14314' ,`StreetSuffix` = 'Lane' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2513' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large 2 Story plan with a 2 story family room. If you are looking for a large home with Granite Countertops in the kitchen, Island, covered patio, and a large game room, this is your home!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9, Block 4, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.6256' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704817' WHERE `Matrix_Unique_ID` = '210293496' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T13:58:22.110' ,`MLSNumber` = '10659503' ,`ListAgentFullName` = 'Sonia Lopez' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Derek Boles' ,`SellingOfficeName` = 'Legacy Homes & Properties, LLC' ,`Latitude` = '29.945095' ,`Longitude` = '-95.201205' ,`PhotoCount` = '25' ,`PostalCode` = '77346' ,`RoomCount` = '11' ,`ListPrice` = '460000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Falkirk Green' ,`StreetNumber` = '15406' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2876' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home in the highly sought after gated section of Balmoral. Balmoral in Humble offers residents the exclusivity of gated living in a community where the amenities are second to none. This Stunning 4 bedroom 3 bath home boasts UPGRADES GALORE: Oversized lot with, 2 BEDROOMS DOWN, beautiful Wood Floors throughout 1st floor, Extended Custom designed Patio great for entertaining, 3 car garage + MORE! The Master Chef will relish among the Stainless Whirlpool Appliances, Quartz Countertops, beautiful Island, Gorgeous White Cabinetry w/ Under counter lights. Find Serenity in the Master Suite featuring an En Suite w/ Separate Tub and Shower. This amazing Master Planned Community offers a Crystal-Clear Lagoon surrounded by White Beaches, hammocks & cabanas, Infinity Pool and more!, Convenient to Beltway 8, Hwy 59, IAH Airport, minutes to Downtown, Dining and Shopping. Call now for your private tour.' ,`Acres` = '0.2941' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 BALMORAL SEC 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '12813' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Balmoral Sec 3' ,`TaxAmount` = '9649' ,`TaxRate` = '2.9873' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704818' WHERE `Matrix_Unique_ID` = '210690437' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:22:27.040' ,`MLSNumber` = '23965026' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Newmark Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.683827' ,`Longitude` = '-95.897037' ,`PhotoCount` = '10' ,`PostalCode` = '77441' ,`RoomCount` = '6' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Hawthorn Glen' ,`StreetNumber` = '30602' ,`StreetSuffix` = 'Court' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2354' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning stucco and brick one story plan, the Sorano from Newmark Homes. This home has 4 large bedrooms with walk-in closets, 3 full baths, spacious formal dining room and covered patio. Ideal feature includes en suite for bedroom 4. This beauty features a huge family room open to the kitchen, grey cabinetry with sliding shelves in lower cabinets, island kitchen and breakfast room plus an electric fireplace. The Kitchen boasts upgraded quartz counters, under cabinet lighting and built-in stainless-steel appliances. Vinyl flooring throughout common areas add just a touch of elegance. The spacious Main Suite offers a large walk-in closet, porcelain vanities with dual sinks, and an oversize shower. The open concept makes this home perfect for a family that loves to entertain. Corner lot with fully landscaped front and back adds to the charm.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'lot 01, Block 01' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6913' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fulbrook on Fulshear Creek Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704818' WHERE `Matrix_Unique_ID` = '210695865' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:13:59.647' ,`MLSNumber` = '17268366' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.210334' ,`Longitude` = '-95.341809' ,`PhotoCount` = '34' ,`PostalCode` = '77302' ,`RoomCount` = '7' ,`ListPrice` = '359990.00' ,`Status` = 'Active' ,`StreetName` = 'Grand Canyon' ,`StreetNumber` = '17312' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2403' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Single-Story in the vibrant, amenity and nature filled Conroe Community of Artavia. This home is a coveted floor plan constructed by Lennar in 2019. Offering a very functional and comfortable 2,400SF of living space, it offers 3 Bedrooms | 2.5 Baths | Study | 2-Car Garage. The interior floor plan has a functional flow, featuring a formal foyer entry, study/extra room on your right, secondary bedrooms on your left split away from the primary bedroom, and beyond that is an expansive, open concept living area. The kitchen hosts a large island w/ sitting bar, an abundance of counter and cabinetry space, and a comfortable adjacent dining area. The primary suite is large in size, and is accompanied by a spacious en-suite, featuring a dual vanity, large walk-in shower with sitting, and a walk-in closet with ample space! Enjoy your private backyard under an over-sized covered patio! The Artavia amenities are resort like, offering an endless amount of recreation & activities!' ,`Acres` = '0.1674' ,`Area` = '19' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S216902 - ARTAVIA 02, BLOCK 5, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7290' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '970' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '8541' ,`TaxRate` = '3.1988' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704818' WHERE `Matrix_Unique_ID` = '210712715' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T13:02:05.017' ,`MLSNumber` = '40689473' ,`ListAgentFullName` = 'Wanda Taylor' ,`ListOfficeName` = 'Taylor Real Estate Group, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.790168' ,`Longitude` = '-95.489666' ,`PhotoCount` = '10' ,`PostalCode` = '77055' ,`RoomCount` = '7' ,`ListPrice` = '900000.00' ,`Status` = 'Active' ,`StreetName` = 'Archley' ,`StreetNumber` = '1201' ,`StreetSuffix` = 'Drive' ,`City` = 'Hilshire Village' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4686' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous lot in the heart of Hilshire Village on the corner of Archley and Ridgeley. Amazing opportunity to build you dream home. Existing home sold as is. Zoned to Valley Oaks, Spring Branch Middle, Memorial High. Hilshire Village is patrolled by Spring Valley Village Police.' ,`Acres` = '0.4591' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 47 BLK 5 RIDGELEY PLACE' ,`LotDesciption` = 'Corner,Ravine' ,`LotSize` = '20000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'VALLEY OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hilshire Village' ,`TaxAmount` = '22874' ,`TaxRate` = '2.4805' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704818' WHERE `Matrix_Unique_ID` = '210717289' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T13:53:22.880' ,`MLSNumber` = '3831839' ,`ListAgentFullName` = 'Xuyen Pham' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.402980' ,`Longitude` = '-94.912600' ,`PhotoCount` = '25' ,`PostalCode` = '77590' ,`RoomCount` = '8' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Park Lane' ,`StreetNumber` = '1132' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2011' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You\'ll fall in love with this newly renovated home in Mainland Park! Features include: New flooring wood laminates throughout, new recess lighting, fixtures, sinks, faucets, updated bathrooms, granite counters, new stove 2022, dishwasher 2022, water heater 2022, and furnace 2022, new interior & exterior paint, new side fence and driveway. Oversized backyard is perfect for entertaining. Just a short drive to Galveston and Kemah Boardwalk. Schedule your showing today!!' ,`Acres` = '0.2191' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 167 PAGE 2 LOT 14 BLK 37 MAINLAND PARK SEC A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9544' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'ROOSEVELT-WILSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mainland Park' ,`TaxAmount` = '3109' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704818' WHERE `Matrix_Unique_ID` = '210721351' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T13:06:56.337' ,`MLSNumber` = '95777187' ,`ListAgentFullName` = 'Dayna Simmons' ,`ListOfficeName` = 'Dayna Simmons Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.050875' ,`Longitude` = '-94.175655' ,`PhotoCount` = '37' ,`PostalCode` = '77707' ,`RoomCount` = '11' ,`ListPrice` = '995000.00' ,`Status` = 'Active' ,`StreetName` = 'S Lakeside Dr' ,`StreetNumber` = '7750' ,`StreetSuffix` = '' ,`City` = 'Beaumont' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fall in love with this magnificent mansion situated in the highly desired Crescent on Walden neighborhood. Sitting on approximately 1.2 acres, this 4-bedroom stunner boasts 4,268 square feet. Upon pulling into the driveway you will be captivated by the immaculate curb appeal, beautiful landscaping, plantation shutters, and unique design. Release your inner chef in the beautiful kitchen complete with beautiful quartz countertops, extra large island, and an oven fit for a pro. Retreat to the beautiful master bathroom and soak your troubles away in the gorgeous claw foot soaking tub. Escape to the absolutely beautiful back patio to read a book by the outdoor fireplace while listening to the sound of the water. This impeccable estate will be the place to host gatherings with the outdoor grill, two patios, and beautiful dock over the water and is ready to be the home of your dreams.' ,`Acres` = '1.2188' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'THE CRESCENT ON WALDEN PHASE II LOT 38' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '53091' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1885' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'DISHMAN ELEMENTARY SCHOOL (BEAUMONT)' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'VINCENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Crescent On Walden Ph II' ,`TaxAmount` = '15444' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704818' WHERE `Matrix_Unique_ID` = '210781735' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T13:00:02.217' ,`MLSNumber` = '29925716' ,`ListAgentFullName` = 'Christopher Lowe' ,`ListOfficeName` = 'HOM' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.107616' ,`Longitude` = '-95.773656' ,`PhotoCount` = '6' ,`PostalCode` = '75831' ,`RoomCount` = '3' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Pr 1195' ,`StreetNumber` = '7815' ,`StreetSuffix` = '' ,`City` = 'Midway' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW!! Your chance to own these 2 properties on over 3 acres just north of Huntsville! 2/1 House and a 3/2 Mobile home can be updated to your desire! Escape the city and make your home in the country!' ,`Acres` = '3.28' ,`Area` = '63' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Centerville/Leona Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SUNSHINE ACRES LT 11 BLK 4 3.280 AC AB 2 S ALLPHIN - JEWEL M' ,`LotDesciption` = 'Other' ,`LotSize` = '142877' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '155 - Centerville (Leon)' ,`SchoolElementary` = 'CENTERVILLE ELEMENTARY SCHOOL (CENTERVILLE-LEON)' ,`SchoolHigh` = 'CENTERVILLE JUNIOR-SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'CENTERVILLE JUNIOR-SENIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunshine acres' ,`TaxAmount` = '1089' ,`TaxRate` = '1.7413' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704818' WHERE `Matrix_Unique_ID` = '210797798' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:37:58.377' ,`MLSNumber` = '64674491' ,`ListAgentFullName` = 'Aurelio Diaz' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835224' ,`Longitude` = '-95.764176' ,`PhotoCount` = '33' ,`PostalCode` = '77449' ,`RoomCount` = '8' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Fornari' ,`StreetNumber` = '4302' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2106' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 4302 Fornari Lane! This charming 2-story home sits at 2,106 sq ft and boasts 4 bedrooms, 3 bathrooms, and a GAME ROOM! This home is located on a spacious 7,069 sq ft lot in the incredible community of Ventana Lakes East, featuring multiple pools, a splash pad, picnic area, club house, and is zoned to Katy ISD! You\'ll love all the great features this home has to offer, including wood look floors, staircase with wrought iron railings, stainless steel appliances, recessed lighting, a spacious master suite, and modern fixtures and finishes! Owners have never lived in the house. Schedule your private showing of this amazing home today!' ,`Acres` = '0.1623' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 61 BLK 3 VENTANA LAKES EAST SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7069' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ventana Lakes East' ,`TaxAmount` = '834' ,`TaxRate` = '3.2357' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704819' WHERE `Matrix_Unique_ID` = '210808529' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:26:42.090' ,`MLSNumber` = '30987182' ,`ListAgentFullName` = 'Linda Burnett' ,`ListOfficeName` = 'CB&A, Realtors-Katy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.072287' ,`Longitude` = '-95.125049' ,`PhotoCount` = '42' ,`PostalCode` = '77541' ,`RoomCount` = '4' ,`ListPrice` = '680000.00' ,`Status` = 'Active' ,`StreetName` = 'Buccaneer' ,`StreetNumber` = '12930' ,`StreetSuffix` = 'Parkway' ,`City` = 'Freeport' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1598' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Treasure Island & your own piece of paradise! This beautiful beach house features 4 bedrooms and 3 full bathrooms. Wood laminate floors, stunning views, granite in all the baths and kitchen. This fully furnished home is ready for you to move in and enjoy the fun. The extended covered deck provides you views of gulf for a stunning sunrise and set. Don\'t feel like hanging out on the patio take the elevator down and enjoy your own Tiki bar on the lower level in the shade. This beautiful property is located in the highly sought after neighborhood of Treasure Island with semi private beaches and some of the best fishing in Texas. Where else can you wade fish, surf fish, bay fishing or offshore fish, be sure to shower off in the outdoor shower before heading into the house!' ,`Acres` = '0.1148' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Treasure Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TREASURE ISLAND (A0029 S F AUSTIN) BLK 15 LOT 8' ,`LotDesciption` = 'Water View' ,`LotSize` = '5001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`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` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Treasure Island' ,`TaxAmount` = '8391' ,`TaxRate` = '2.3804' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704819' WHERE `Matrix_Unique_ID` = '210965800' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:09:26.953' ,`MLSNumber` = '49914274' ,`ListAgentFullName` = 'Brandon Brewer' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.706270' ,`Longitude` = '-95.082287' ,`PhotoCount` = '9' ,`PostalCode` = '77351' ,`RoomCount` = '0' ,`ListPrice` = '55000.00' ,`Status` = 'Active' ,`StreetName` = 'Sherwood' ,`StreetNumber` = '145' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '640' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This 640 sq ft house has never been lived in and ready to be finished into your dream home! Studs are in place to make it into a 1/1 but there\'s room to do as you please. The oversized 1 car garage needs a little TLC but has plenty of space for a workshop too! On a corner lot in a lake access neighborhood, this will make a great place to call home!' ,`Acres` = '0.1708' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '1' ,`Legal` = 'SHELTER COVE SECTION 3 LOT 41' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '7440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shelter Cove' ,`TaxAmount` = '100' ,`TaxRate` = '2.7745' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663704819' WHERE `Matrix_Unique_ID` = '211165215' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T13:32:41.377' ,`MLSNumber` = '52895484' ,`ListAgentFullName` = 'James Steinbeck' ,`ListOfficeName` = 'James Steinbeck, Ind. Broker' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795780' ,`Longitude` = '-95.415787' ,`PhotoCount` = '11' ,`PostalCode` = '77008' ,`RoomCount` = '0' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = '14th' ,`StreetNumber` = '1813' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '1189' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property is located inside inner loop adjacent to The Heights in Clark Pines. It\'s on a desirable tree lined street where there are multiple premium homes being constructed. Existing house probably is a \"tear-down\" so property is priced at lot value only. House could be assessed by a builder for major remodel. No repairs will be considered by the seller and is to be purchased \"as-is\". House is temporarily occupied by estate family member and is not to be shown inside. Seller still requires a showing approval to observe and assess the lot.' ,`Acres` = '0.1818' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 11B BLK 2 CLARK PINES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Clark Pines' ,`TaxAmount` = '8532' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704819' WHERE `Matrix_Unique_ID` = '211231214' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T13:37:37.160' ,`MLSNumber` = '27672162' ,`ListAgentFullName` = 'Maria Bonilla' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.860700' ,`Longitude` = '-95.294451' ,`PhotoCount` = '9' ,`PostalCode` = '77016' ,`RoomCount` = '6' ,`ListPrice` = '211289.00' ,`Status` = 'Active' ,`StreetName` = 'Wileyvale' ,`StreetNumber` = '7407' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Contruction! Make new memories in this amazing One story 3-bedroom open concept, no carpet Home. This house is near shopping centers and freeways Minutes from Downtown. Amazing Price don’t miss out this great opportunity. Please verify room dimensions and schools.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Europa Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5760' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Trinity Gardens' ,`TaxAmount` = '' ,`TaxRate` = '2.33' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704819' WHERE `Matrix_Unique_ID` = '211378913' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T13:02:41.190' ,`MLSNumber` = '24727662' ,`ListAgentFullName` = 'Kathryn Hammond' ,`ListOfficeName` = 'RE/MAX On The Water - Bolivar' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.461736' ,`Longitude` = '-94.611783' ,`PhotoCount` = '49' ,`PostalCode` = '77650' ,`RoomCount` = '6' ,`ListPrice` = '1250000.00' ,`Status` = 'Active' ,`StreetName` = 'SAND DRIFT' ,`StreetNumber` = '2432' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INCREDIBLE BEACHFRONT OASIS !!! This spectacular custom home offers an extraordinary way of life. A wall of windows across the ocean side provides natural light and stunning beach views. This gorgeous home offers spacious living areas, tall ceilings, a large kitchen island, two stories, two front decks and a back sunset deck. Beautiful resort style home, is an excellent vacation rental that sleeps 17 comfortably. Convenient location, desirable neighborhood and exceptional views make entertaining easy with family and friends. This home will sell fully furnished and ready to enjoy. The seller will replace the garage door, and paint the exterior of the house. \r\nIt doesn\'t get better than beachfront. Just steps to the beach. Escape to your very own paradise with this relaxed coastal design. Call to schedule an appointment.' ,`Acres` = '0.8043' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOT 1 DRIFTWOOD ADDN' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '35036' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`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` = 'Traditional' ,`Subdivision` = 'Driftwood' ,`TaxAmount` = '8943' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704819' WHERE `Matrix_Unique_ID` = '211508194' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T13:23:37.407' ,`MLSNumber` = '9186924' ,`ListAgentFullName` = 'Nicole Espinosa' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.059161' ,`Longitude` = '-95.382100' ,`PhotoCount` = '16' ,`PostalCode` = '77373' ,`RoomCount` = '4' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Beechtree Gully' ,`StreetNumber` = '23410' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in established neighborhood, open concept kitchen with granite countertops, lots of cabinet space and walk in pantry. Large game room upstairs great for entertainment. Covered back porch and a large backyard great for BBQs or get togethers! Buyer and buyers agent to verify all information. Home is sold AS-IS (no exceptions).' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Short Sale' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 BRECKENRIDGE WEST SEC 3' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'BRECKENRIDGE WEST SEC 3' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704819' WHERE `Matrix_Unique_ID` = '211704767' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:44:57.210' ,`MLSNumber` = '41744162' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.602374' ,`Longitude` = '-95.805070' ,`PhotoCount` = '24' ,`PostalCode` = '77471' ,`RoomCount` = '15' ,`ListPrice` = '523038.00' ,`Status` = 'Active' ,`StreetName` = 'Scott' ,`StreetNumber` = '6000' ,`StreetSuffix` = 'Way' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning two-story Easton II home design features 4 bedrooms, 3.5 baths and 3 car attached garage on an oversized lot. Convenient home office located off hall. Elegant dining room with easy access to gourmet kitchen. Beautiful maple cabinets, granite countertops, farmhouse sink and walk-in pantry in gourmet kitchen. Cozy cast stone fireplace in great room. Huge walk-in closet, dual vanity sinks, separate tub and shower in owner\'s bath. Upstairs, you\'ll find a versatile activity room and all secondary bedrooms. Bedroom 2 features an en-suite bath. Covered patio in backyard, perfect for entertaining. \r\nEnjoy the convenience of the community\'s Recreation Center, Lakes and Parks. Kingdom Heights in Rosenberg is conveniently located between Sugar Land and Katy/Fulshear with easy access to the major Highway 99 (Grand Pkwy). Offered by: K. Hovnanian of Houston II, L.L.C' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '9/1/6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10281' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '665' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingdom Heights' ,`TaxAmount` = '' ,`TaxRate` = '2.7948' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704820' WHERE `Matrix_Unique_ID` = '211724166' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:58:31.083' ,`MLSNumber` = '33766446' ,`ListAgentFullName` = 'Christopher Lowe' ,`ListOfficeName` = 'HOM' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.865123' ,`Longitude` = '-96.969338' ,`PhotoCount` = '20' ,`PostalCode` = '76520' ,`RoomCount` = '5' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = '20th' ,`StreetNumber` = '202' ,`StreetSuffix` = 'Street' ,`City` = 'Cameron' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1496' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW!! Rehabbed 3bedroom 2bathroom at a great price! Close to great schools, shopping and restaurants! Schedule your showing today!' ,`Acres` = '0.1894' ,`Area` = '71' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S23800 TERRAL HEIGHTS #1 BLK 5 LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '388 - Cameron' ,`SchoolElementary` = 'CAMERON ELEMENTARY SCHOOL (CAMERON)' ,`SchoolHigh` = 'C. H. YOE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMERON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Terral Heights #1' ,`TaxAmount` = '1348' ,`TaxRate` = '2.7198' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704820' WHERE `Matrix_Unique_ID` = '211748870' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:41:46.910' ,`MLSNumber` = '30640871' ,`ListAgentFullName` = 'Jeanie Turk' ,`ListOfficeName` = 'RE/MAX Northwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.152209' ,`Longitude` = '-94.328681' ,`PhotoCount` = '23' ,`PostalCode` = '77659' ,`RoomCount` = '5' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Piney Point' ,`StreetNumber` = '427' ,`StreetSuffix` = 'Drive' ,`City` = 'Sour Lake' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2062' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning home on over 1.58 acres in a park like setting. This beautiful home with an atrium is located in Pinewood/ Idylwild golf andtennis club community. The 4 bedroom/ 2 bath home sits in the middle of two lots in the top rated HJ school district. Oversized garagewith plenty of room for a golf cart and lawn equipment. Located in Flood zone X! Amazing covered back patio designed using trexboards with additional insulated panels to drop temperatures on a summer day by 20 degrees to enjoy the patio furniture that comesincluded with the home.' ,`Acres` = '1.582' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOTS 14 & 15 BLK 14 PINEWOOD #2 P# HJ25-14-15' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '68912' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'SOUR LAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinewood Sec 02' ,`TaxAmount` = '4297' ,`TaxRate` = '2.158' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704820' WHERE `Matrix_Unique_ID` = '211768286' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T13:24:29.120' ,`MLSNumber` = '6188481' ,`ListAgentFullName` = 'Michael Furman' ,`ListOfficeName` = 'RE/MAX Unlimited' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.086739' ,`Longitude` = '-96.207688' ,`PhotoCount` = '42' ,`PostalCode` = '77871' ,`RoomCount` = '3' ,`ListPrice` = '529987.00' ,`Status` = 'Active' ,`StreetName` = 'Golfview' ,`StreetNumber` = '202' ,`StreetSuffix` = 'Drive' ,`City` = 'Hilltop Lakes' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1887' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to Hilltop Lakes. This beautiful full brick 3 bedroom, 2 bath home on a CORNER DOUBLE LOT offers craftsmanship, amenities galore and a one-of-a-kind 1/1 apartment in the Golf/Guest suite you must see!!\r\n\r\nThis beautiful luxury home is a golfers paradise. The backyard backs up to the lush golf course (11th green). The home features an open-concept living space with luxurious granite in this custom kitchen. This home is situated with a split floor plan. Each bedroom features a walk-in closet and beautiful wood flooring. \r\n\r\nLocated next to the main house is a first-class metal brick Golf/Guest suite. The suite includes a kitchenette with a murphy bed, a full bathroom, and an area to park golf carts or precious vehicle(s), a built-in golf simulator, and putting green. The suite has mini split heating & air unit to keep the space feeling comfortable year round!\r\nReverse Osmosis & water softener, Solar Screens; Water Well for the water sprinklers.' ,`Acres` = '0.5349' ,`Area` = '63' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Normangee/Marquez Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HILLTOP LAKES SEC 6 BLK 1 LT 13 & 14' ,`LotDesciption` = 'Corner,In Golf Course Community,On Golf Course' ,`LotSize` = '23302' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '65' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '131 - Normangee' ,`SchoolElementary` = 'NORMANGEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORMANGEE HIGH SCHOOL' ,`SchoolMiddle` = 'NORMANGEE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hilltop Lakes Sec 06' ,`TaxAmount` = '4247' ,`TaxRate` = '1.8865' ,`WaterSewer` = 'Aerobic,Public Sewer,Public Water,Well' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704820' WHERE `Matrix_Unique_ID` = '211871142' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:35:30.790' ,`MLSNumber` = '54198268' ,`ListAgentFullName` = 'Jestin Philip' ,`ListOfficeName` = 'Prime Texas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.632389' ,`Longitude` = '-95.185954' ,`PhotoCount` = '44' ,`PostalCode` = '77504' ,`RoomCount` = '4' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Laura Lee' ,`StreetNumber` = '5211' ,`StreetSuffix` = 'Lane' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2482' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful home located in Travis Estates. This home features 4 bedrooms, 2baths, 2 car garage. Well maintained home, Low Tax !! highly rated schools. Short commute to downtown, medical center, clear lake, league city and NASA area. Easy access to Major highways. Shopping and restaurants nearby. Call and schedule a private tour now' ,`Acres` = '0.1515' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 TRAVIS ESTATES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'TEAGUE ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PASADENA)' ,`SchoolMiddle` = 'BONDY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Travis Estates Sec 02' ,`TaxAmount` = '6873' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704820' WHERE `Matrix_Unique_ID` = '211916641' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T13:46:53.347' ,`MLSNumber` = '93980781' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841742' ,`Longitude` = '-94.989159' ,`PhotoCount` = '12' ,`PostalCode` = '77521' ,`RoomCount` = '9' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Birch Colony' ,`StreetNumber` = '9610' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2393' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW LENNAR Community - STERLING POINT!!! New Lennar Brookstone II Collection Homes in Sterling Point! The Russo III, Brick/Stone Elevation \"D\" is a spacious, single-story home with a cohesive design shared among the modern kitchen, dining and family room, with an attached covered patio. Three bedrooms and a study present ample flexibility in the front of the home. The owner’s suite highlights privacy tucked away at the end of the home, complete with a lavish bathroom and walk-in closet.\r\n**Estimated Completion Date, January 2022**' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0003 BLK 001 LOT 018' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'PUMPHREY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Point' ,`TaxAmount` = '' ,`TaxRate` = '3.69' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704820' WHERE `Matrix_Unique_ID` = '211943661' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T13:57:21.087' ,`MLSNumber` = '29880195' ,`ListAgentFullName` = 'John Brannen' ,`ListOfficeName` = 'Lawrence Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.543236' ,`Longitude` = '-95.230638' ,`PhotoCount` = '42' ,`PostalCode` = '75844' ,`RoomCount` = '3' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'State Highway 21' ,`StreetNumber` = '20497' ,`StreetSuffix` = '' ,`City` = 'Grapeland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1587' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SMALL COUNTRY ACREAGE! \r\n You will be impressed as you drive up the asphalt drive to this country home. The front pasture is fenced, perfect for livestock or a garden area. This three bedroom, two bath home is in move-in-ready condition. The spacious living area has a wood burning fireplace and ample windows to look across the property. The kitchen has good cabinet space and all appliances will convey. You’ll appreciate the mudroom/laundry with access to the carport. The primary bedroom has a private bath, while two guest bedrooms share a hall bath. Outdoors, there is storage in the carport, as well as a shop with electricity. You’ll enjoy sitting on the covered front and back porches. For a private showing, give us a call today!' ,`Acres` = '1.861' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Grapeland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'J PREWITT AB 66 1.861 AC' ,`LotDesciption` = 'Other' ,`LotSize` = '81065' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '60 - Kennard' ,`SchoolElementary` = 'KENNARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KENNARD HIGH SCHOOL' ,`SchoolMiddle` = 'KENNARD HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'NA' ,`TaxAmount` = '1827' ,`TaxRate` = '1.6058' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704820' WHERE `Matrix_Unique_ID` = '211972054' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T13:20:27.263' ,`MLSNumber` = '88155323' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.062301' ,`Longitude` = '-95.357860' ,`PhotoCount` = '6' ,`PostalCode` = '77373' ,`RoomCount` = '10' ,`ListPrice` = '319990.00' ,`Status` = 'Active' ,`StreetName` = 'Kentwood Springs' ,`StreetNumber` = '24002' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2498' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FABULOUS NEW D. R. HORTON BUILT F-I-V-E BEDROOM! Wonderful Island Kitchen with Corner Walk-In Pantry Opens to Spacious Dining Area & Living Room! Beautiful Modern Finishes with Soft Grey Cabinetry and Stainless Steel Appliances! Guest Suite/Secondary Bedroom with Adjoining Full Bath Downstairs! Oversized Indoor Utility Room! Great Primary Suite with Sitting Area & Lovely Bath with Walk-In Closet! Huge Loft/Gameroom/Media Room! Covered Back Patio & Landscape Package! Wonderful Community with Recreation Center & Easy Access to the Hardy Toll Road! Estimated Completion - October 2022.' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLOCK 1 BRECKENRIDGE EAST SECTION 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6140' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Breckenridge Forest' ,`TaxAmount` = '' ,`TaxRate` = '3.112' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704821' WHERE `Matrix_Unique_ID` = '211972243' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:23:28.547' ,`MLSNumber` = '71496431' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.202933' ,`Longitude` = '-95.406833' ,`PhotoCount` = '18' ,`PostalCode` = '77515' ,`RoomCount` = '12' ,`ListPrice` = '419722.00' ,`Status` = 'Active' ,`StreetName` = 'Prairie Rose' ,`StreetNumber` = '3524' ,`StreetSuffix` = 'Trail' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2477' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Ashville home design features 4 bedrooms, 3 baths and 2 car attached garage. Charming farmhouse sink, maple cabinets and quartz countertops with low bartop in kitchen. Two bedrooms, including owner\'s suite, located downstairs. Double sinks, huge walk-in closet, separate tub and shower in owner\'s luxury bath. Upstairs, you\'ll find a cozy loft space and 2 secondary bedrooms, plus a built-in desk off hall 3. Covered patio in backyard, perfect for entertaining. This home is a must see, so schedule your appointment today to find out if this home is the best option for you and your family. \r\nWindrose Green in Angleton offers easy access to Hwy 288 and Hwy 35. Students will have access to a trail which will lead them to Angleton High School. Planned amenities include a neighborhood park with playground and splashpad plus walking trails. Offered by: K. Hovnanian of Houston II, L.L.C.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'K.Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '20/3/1' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'RANCHO ISABELLA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Windrose Green' ,`TaxAmount` = '' ,`TaxRate` = '3.527' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704821' WHERE `Matrix_Unique_ID` = '211972638' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T12:38:07.860' ,`MLSNumber` = '6942338' ,`ListAgentFullName` = 'Steven Ciapi' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.755010' ,`Longitude` = '-95.458981' ,`PhotoCount` = '34' ,`PostalCode` = '77056' ,`RoomCount` = '11' ,`ListPrice` = '769000.00' ,`Status` = 'Active' ,`StreetName` = 'Wynden Oaks' ,`StreetNumber` = '21' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4387' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegant Tanglewood area home nestled in a prestigious, private gated community with fountain pool. This 4-bedroom estate is within walking distance to Uptown Park, with close proximity to the Galleria and some of Houston’s finest shopping and dining. Thoughtfully designed, this home features an amazing floor plan with high ceilings, tons of natural light, and spacious rooms throughout. Large island kitchen equipped with plenty of storage space opens to a light-filled breakfast room. The family room features hardwood flooring, gas fireplace, coffered ceilings, and custom built-ins. Primary bedroom down with two walk-in closets and an amazing en-suite bath. Sizeable upstairs game room (23X19) also equipped with custom built-ins. Additional features include a 20-foot foyer, formal dining, wet bar, crown molding, and plantation shutters. Schedule your private showing today.' ,`Acres` = '0.1014' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 WYNDEN OAKS ESTATES SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4415' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3310' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wynden Oaks Estates Sec 01' ,`TaxAmount` = '20471' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704821' WHERE `Matrix_Unique_ID` = '211975488' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T13:56:12.463' ,`MLSNumber` = '98578964' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.062646' ,`Longitude` = '-95.357929' ,`PhotoCount` = '6' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '254990.00' ,`Status` = 'Active' ,`StreetName` = 'Auburn Gardens' ,`StreetNumber` = '5306' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1296' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WONDERFUL NEW D. R. HORTON BUILT 1 STORY! Fantastic Open Concept Interior Layout! Beautiful Modern Finishes with Soft Grey Cabinetry and Stainless Steel Appliances! Lovely Foyer Opens to Island Kitchen with Spacious Corner Pantry, Dining Area, & Large Living Room! Privately Located Primary Suite Features Great Bath with Oversized Shower & Walk-In Closet! Spacious Secondary Bedrooms! Great Guest Bath with Tub/Shower Combo! Indoor Utility Room! Covered Patio Overlooks Tranquil Backyard! Landscape Package Included! Incredible Community with Recreation Center - PLUS Easy Access to the Hardy Toll Road! Estimated Completion - November 2022.' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 59 BLOCK 6 BRECKENRIDGE EAST SECTION 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8037' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Breckenridge Forest' ,`TaxAmount` = '' ,`TaxRate` = '3.112' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704821' WHERE `Matrix_Unique_ID` = '211977957' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T13:41:44.147' ,`MLSNumber` = '6935732' ,`ListAgentFullName` = 'Tracie Conyers' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.100811' ,`Longitude` = '-93.743767' ,`PhotoCount` = '17' ,`PostalCode` = '77630' ,`RoomCount` = '3' ,`ListPrice` = '69999.00' ,`Status` = 'Active' ,`StreetName` = 'John' ,`StreetNumber` = '1402' ,`StreetSuffix` = 'Avenue' ,`City` = 'Orange' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.161' ,`Area` = '50' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 1 BLK H-1 SHELDON' ,`LotDesciption` = 'Other' ,`LotSize` = '7013' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '270 - West Orange-Cove Consolidated' ,`SchoolElementary` = 'WEST ORANGE-STARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST ORANGE-STARK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST ORANGE-STARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sheldon' ,`TaxAmount` = '1240' ,`TaxRate` = '2.779' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1929' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663704821' WHERE `Matrix_Unique_ID` = '211978904' --> Updated record success