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-29T12:08:49.943' ,`MLSNumber` = '20086192' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Charlotte Galbraith' ,`SellingOfficeName` = 'Bailey Banks & GoldrichProperties' ,`Latitude` = '29.851099' ,`Longitude` = '-95.817854' ,`PhotoCount` = '9' ,`PostalCode` = '77493' ,`RoomCount` = '12' ,`ListPrice` = '365000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Marisol Cove' ,`StreetNumber` = '5354' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2431' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction**' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Marisol' ,`TaxAmount` = '' ,`TaxRate` = '3.700793' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704438' WHERE `Matrix_Unique_ID` = '201545748' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:26:54.437' ,`MLSNumber` = '39746091' ,`ListAgentFullName` = 'Chay LeUnes' ,`ListOfficeName` = 'NextHome Realty Center' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.992473' ,`Longitude` = '-96.273452' ,`PhotoCount` = '50' ,`PostalCode` = '77418' ,`RoomCount` = '10' ,`ListPrice` = '1150000.00' ,`Status` = 'Active' ,`StreetName` = 'Reinhardt' ,`StreetNumber` = '3882' ,`StreetSuffix` = 'Road' ,`City` = 'Bellville' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3874' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DREAM HOME! This must see 10+ acre gem is just a few minutes outside of Bellville. No detail was spared in the construction of this custom built beauty. A stucco and brick exterior gives way to an interior of gorgeous hardwood floors, soaring ceilings with exposed beam work, and a terrific view of the pond from most of the rooms in the house. Custom windows and doors. Office entry with transom accent glass. Granite countertops throughout. Travertine tile. Viking Appliances. See the master shower with glass blocks, double shower head and seating. Each bedroom has a walk in closet. Massive mudroom and laundry with tons of storage. Follow the wood stairs up to the game room with a view of the pond featuring a Viking fridge and full bath. Media room adjacent to the game room with a walk-in attic space for additional storage. Enjoy the back patio for wildlife viewing and recently rebuilt pier for fishing. 3 car oversized garage. Water softener.' ,`Acres` = '10.576' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST A254 A LOTT' ,`LotDesciption` = 'Water View,Waterfront,Wooded' ,`LotSize` = '460691' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '136 - Bellville' ,`SchoolElementary` = 'WEST END ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'BELLVILLE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Arthur Lott Surv Abs 254' ,`TaxAmount` = '10615' ,`TaxRate` = '1.8096' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704438' WHERE `Matrix_Unique_ID` = '203913130' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:20:19.503' ,`MLSNumber` = '60050671' ,`ListAgentFullName` = 'John Arcana' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.195784' ,`Longitude` = '-94.214647' ,`PhotoCount` = '36' ,`PostalCode` = '77657' ,`RoomCount` = '5' ,`ListPrice` = '740800.00' ,`Status` = 'Active' ,`StreetName` = 'Baldwin' ,`StreetNumber` = '11290' ,`StreetSuffix` = 'Court' ,`City` = 'Lumberton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CUSTOM home to be built in Lumberton\'s Madison Park on 1.43 acres. *SEE COMPLETE LIST OF UPGRADE OPTIONS BELOW* 4 bedroom PLUS office PLUS bonus room. You\'ll believe you\'re in Hill Country in this grand home. Soaring 22ft A-frame ceiling with stone fireplace from floor to ceiling. Open layout with grand beams suspended 15ft above the huge kitchen island. Built in fridge/freezer, Walkin butler pantry, gas cook top, double oven, kitchen sink overlooks back yard and patio. Master suite features an oversized shower, freestanding tub, two separate vanities, TWO large walk in closets, and two (yes TWO) private toilets. Just off the master suite is a 15\'x16\'study. Also downstairs is a guest bedroom, full bathroom, and large laundry with sink. Upstairs is a bonus living area/game room, two bedrooms, & full bathroom. Pictured with upgraded items: Extended back patio. Outdoor kitchen. Outdoor fireplace. Ceiling trusses in living room. Prices for these options can be provided.' ,`Acres` = '1.43' ,`Area` = '49' ,`BuilderName` = 'JT&I Custom Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11 Madison Park II' ,`LotDesciption` = 'Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '154 - Lumberton' ,`SchoolElementary` = 'LUMBERTON PRIMARY SCHOOL' ,`SchoolHigh` = 'LUMBERTON HIGH SCHOOL' ,`SchoolMiddle` = 'LUMBERTON MIDDLE SCHOOL' ,`ShowInstructions` = 'No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Madison Park' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663704438' WHERE `Matrix_Unique_ID` = '205286361' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T13:38:30.377' ,`MLSNumber` = '61805786' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.026116' ,`Longitude` = '-95.384611' ,`PhotoCount` = '27' ,`PostalCode` = '77073' ,`RoomCount` = '7' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Werrington' ,`StreetNumber` = '21406' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2020' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.124' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 WERRINGTON PARK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5402' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '620' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'OGDEN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Werrington Park Sec 2' ,`TaxAmount` = '4005' ,`TaxRate` = '2.9808' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704438' WHERE `Matrix_Unique_ID` = '205629561' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:02:59.610' ,`MLSNumber` = '96345069' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = 'Marixa Okafor' ,`SellingOfficeName` = 'Texas Premier Realty' ,`Latitude` = '29.944228' ,`Longitude` = '-95.205037' ,`PhotoCount` = '14' ,`PostalCode` = '77346' ,`RoomCount` = '14' ,`ListPrice` = '449990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Abbotshall Bend' ,`StreetNumber` = '15539' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. This gorgeous Lake Ridge Builders home in Balmoral is what you’ve been looking for. Situated on an oversized lot, this 3-sided brick home boasts a premium elevation, tile flooring, wrought iron spindles, cast stone fireplace, guest suite, sprinkler system, and an extended covered patio. Master new recipes in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. Relax in the serene primary suite, featuring dual vanities, a 42” tub, and a separate shower. The desirable Balmoral community includes white sand beaches, lakes, parks, an infinity pool, a recreation center, and walking trails. Located off Beltway 8 and Highway 59, commuters enjoy easy access to George Bush Intercontinental Airport and Downtown Houston. Zoned to Humble ISD. Don’t wait – call now to learn more!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 106 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10300' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704438' WHERE `Matrix_Unique_ID` = '207646245' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:05:20.520' ,`MLSNumber` = '66377473' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.907474' ,`Longitude` = '-95.751296' ,`PhotoCount` = '21' ,`PostalCode` = '77433' ,`RoomCount` = '18' ,`ListPrice` = '880275.00' ,`Status` = 'Active' ,`StreetName` = 'Bossley Park' ,`StreetNumber` = '9203' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4609' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 66377473 ~ REPRESENTATIVE PHOTOS ADDED! Built by Taylor Morrison, Ready December ~ The Palisade! This floor plan design encompasses an exceptional collection of rooms for an elevated living and entertaining experience. Enter the grand foyer through the 42\" entry door to visit the quiet study room to the left, along with a guest bedroom with its own private bath. The formal dining area on the right is great for those special occasions. Mingle with friends and family in the large gathering room that opens to the kitchen and casual dining. The owner\'s suite has a large walk-in closet and a lovely extension added to the suite for more relaxation. Upstairs are 3 bedrooms with 3 full baths, an amazing game room area, and a media room great for a home theater! Structural options at 9203 Bossley Park Drive include: 42\" entry doors, extended owner’s suite, fireplace, media room, 9\'x8\' sliding glass doors to patio, and mud bench at owner’s entry.' ,`Acres` = '0.264' ,`Area` = '25' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10, Block 2 of Avalon at Cypress Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11537' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Avalon at Cypress 70\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704438' WHERE `Matrix_Unique_ID` = '207685316' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:07:59.040' ,`MLSNumber` = '30895806' ,`ListAgentFullName` = 'Cindy Beltran' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.696067' ,`Longitude` = '-95.484158' ,`PhotoCount` = '45' ,`PostalCode` = '77401' ,`RoomCount` = '11' ,`ListPrice` = '860000.00' ,`Status` = 'Active' ,`StreetName` = 'Braeburn' ,`StreetNumber` = '5424' ,`StreetSuffix` = 'Drive' ,`City` = 'Bellaire' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3116' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Build your dream home on this 20,000+sqft lot!! Located on Braeburn Drive, within the Braeburn Country Club Estates exclusive community. This Lot is in Zone X on FEMA\'s map and is one of the higher elevations in the area putting it in the 500 yr, not the 100 yr floodplain! You\'ll instantly be enchanted by the street, which is gorgeously lined with mature trees and lush landscaping. The architectural style of homes framed by this beautiful landscaping ranges from modest historic homes to luxury new construction. This property could be renovated or provide a great lot to build new construction. This 5-bedroom, 3.5-bath home has recently \r\ninstalled stunning engineered hardwood floors throughout the first floor. The backyard features a private pool with a lush landscaping that is perfect for outdoor entertaining . As a bonus, the home features an extra 500 square feet of living space next to the pool. This home also includes a 3 car garage, and a large storage shed with electricity.' ,`Acres` = '0.47' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 7 BRAEBURN CNTRY CLUB ESTS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Brae Burn Cc Estates' ,`TaxAmount` = '16926' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704439' WHERE `Matrix_Unique_ID` = '208154248' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T13:59:33.503' ,`MLSNumber` = '50987198' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.164663' ,`Longitude` = '-95.197151' ,`PhotoCount` = '8' ,`PostalCode` = '77357' ,`RoomCount` = '10' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Lazzaro Springs' ,`StreetNumber` = '18906' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2732' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Homes Fairway Collection, \'\'Southwind\'\' Plan, Elevation \'\'F\'\' in beautiful Tavola! The beautiful one and one-half story Southwind floor plan by Lennar features a welcoming front porch and a lovely entrance foyer, a formal dining room, kitchen with breakfast area, a generous family room and a walk-in utility room and mud room. The primary bedroom features an en suite bathroom with dual sinks, stand-up shower, private toilet enclosure and dual walk-in master closets.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0042 BLK 001 LOT 013' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1125' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Tavola' ,`TaxAmount` = '' ,`TaxRate` = '3.5826' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704439' WHERE `Matrix_Unique_ID` = '208187857' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:12:47.587' ,`MLSNumber` = '9520010' ,`ListAgentFullName` = 'Will Clark' ,`ListOfficeName` = 'Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.167089' ,`Longitude` = '-95.429948' ,`PhotoCount` = '9' ,`PostalCode` = '77515' ,`RoomCount` = '6' ,`ListPrice` = '409000.00' ,`Status` = 'Active' ,`StreetName` = 'Greystone' ,`StreetNumber` = '14' ,`StreetSuffix` = 'Court' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home is being built by Aplin Construction in the Greystone Subdivision. Open floor plan, the kitchen is open to the family room, separate study, indoor utility room and many extras . Estimated completion date is December 2022.\r\nAttached video is not actual subject but similar floor plan. Some amenities and adjustments may vary' ,`Acres` = '0.19' ,`Area` = '5' ,`BuilderName` = 'Aplin Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Legal lot 28 block 1' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greystone' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704439' WHERE `Matrix_Unique_ID` = '208242476' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T13:27:33.433' ,`MLSNumber` = '48614949' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.053552' ,`Longitude` = '-95.362340' ,`PhotoCount` = '29' ,`PostalCode` = '77373' ,`RoomCount` = '7' ,`ListPrice` = '318990.00' ,`Status` = 'Active' ,`StreetName` = 'Lady Capulet' ,`StreetNumber` = '23631' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2125' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Cypresswood Landing in Spring, TX! Conveniently located with easy access to Grand Parkway, I-45, FM 1960, and I-69 - commuting to the Energy Corridor, The Woodlands, or Bush Intercontinental Airport is a breeze! The Briscoe plan is a stunning two-story home with soaring ceilings in the foyer and NO BACK NEIGHBORS! Complete with 4 bedrooms, 2.5 baths, game room, and 2-car garage. This home has it all - including blinds and room for an additional refrigerator or freezer in the utility room! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless steel appliances! Retreat to the Owner\'s suite featuring a double sinks and separate tub and shower. Enjoy the great outdoors on the covered patio and no backyard neighbors! Don’t miss your opportunity to call Cypresswood Landing home, schedule a visit today!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'LEGEND HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 2 BLK 2 CYPRESSWOOD LANDING SEC. 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Landing' ,`TaxAmount` = '' ,`TaxRate` = '2.61' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704439' WHERE `Matrix_Unique_ID` = '208424579' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T13:52:05.703' ,`MLSNumber` = '85852753' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.164663' ,`Longitude` = '-95.197151' ,`PhotoCount` = '8' ,`PostalCode` = '77357' ,`RoomCount` = '10' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Lazzaro Springs' ,`StreetNumber` = '18914' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2561' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Homes Fairway Collection, \'\'Pine Valley\'\' Plan Elevation \'\'E\'\' in beautiful Tavola! This wonderful two-story home features a circular layout with an open-concept kitchen that leads to a large nook and family room. The first- floor primary suite boasts two walk-in closets, while the second floor hosts three bedrooms, a shared bathroom and versatile bonus room.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0042 BLK 001 LOT 011' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1125' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tavola' ,`TaxAmount` = '' ,`TaxRate` = '3.5826' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704439' WHERE `Matrix_Unique_ID` = '208850041' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T13:54:35.677' ,`MLSNumber` = '53948959' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.164605' ,`Longitude` = '-95.197089' ,`PhotoCount` = '8' ,`PostalCode` = '77357' ,`RoomCount` = '8' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Lazzaro Springs' ,`StreetNumber` = '18910' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW Lennar Homes Fairway Collection, \'\'Cantaron\" Plan with Elevation E in Beautiful Tavola! The Charming 1 Story Cantaron floor plan with 4 bedrooms, 3.5 baths, 2 car garage + plus storage is the largest single-story home at Fairway. The gourmet kitchen overlooks the living space and attached covered patio. There is plenty of flexibility for family living with three secondary bedrooms and a study, and the owner\'s en-suite bathroom is tucked away for privacy.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Tavola 42, BLOCK 1, Lot 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1125' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tavola' ,`TaxAmount` = '' ,`TaxRate` = '3.5826' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704439' WHERE `Matrix_Unique_ID` = '208851812' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:36:54.177' ,`MLSNumber` = '63433664' ,`ListAgentFullName` = 'Heather McClain' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.782649' ,`Longitude` = '-95.465155' ,`PhotoCount` = '15' ,`PostalCode` = '77320' ,`RoomCount` = '3' ,`ListPrice` = '165000.00' ,`Status` = 'Active' ,`StreetName` = 'Park' ,`StreetNumber` = '8' ,`StreetSuffix` = 'Lane' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Minutes from Sam Houston State University and from TDCJ locations. Three bedrooms, two bath with a fenced in back yard. This home is also on it\'s own water well. Makes a great rental property for investors.' ,`Acres` = '' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HARMON CREEK RANCHETTES, MH 54.14 (MH ONLY) ON TR 54, MH LAB' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SCOTT JOHNSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harmon Creek Ranchettes' ,`TaxAmount` = '151' ,`TaxRate` = '1.7134' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663704439' WHERE `Matrix_Unique_ID` = '209189837' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T13:42:27.490' ,`MLSNumber` = '49329494' ,`ListAgentFullName` = 'Brent Herman' ,`ListOfficeName` = 'Upside Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.987094' ,`Longitude` = '-95.173565' ,`PhotoCount` = '19' ,`PostalCode` = '77346' ,`RoomCount` = '3' ,`ListPrice` = '317500.00' ,`Status` = 'Active' ,`StreetName` = 'Atasca Creek' ,`StreetNumber` = '6839' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2143' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this recently renovated, beautiful Atasca Woods charmer !! Hurry, It won\'t last long !!!' ,`Acres` = '0.1417' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 ATASCA WOODS SEC 4 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6174' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '510' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'TIMBERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Atasca Woods Sec 04 Amd' ,`TaxAmount` = '5349' ,`TaxRate` = '2.3974' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704440' WHERE `Matrix_Unique_ID` = '209591907' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T13:10:44.330' ,`MLSNumber` = '76311150' ,`ListAgentFullName` = 'Edna Lopez' ,`ListOfficeName` = 'Dash Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.541776' ,`Longitude` = '-95.564899' ,`PhotoCount` = '37' ,`PostalCode` = '77479' ,`RoomCount` = '10' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Plum Point' ,`StreetNumber` = '5614' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Well Designed Floor Plan in the Highly desirable community of Creekstone at Riverstone and it\'s top notch community amenities. It\'s located in a cul-de-sac ~no thru traffic and with no neighbors on one side. It offers 4 Bedrooms and 4 Full Bathrooms ( 3br downstairs & 1 upstairs); minutes away from top rated schools, fine shopping, restaurants and entertainment. ~ The Owners added various of the builder\'s upgrades when they purchased the home: Bay Window in Main Bedroom, Sunroom, Extended patio with outdoor kitchen and grill, natural gas piped to both outdoor cooktop and grill -you never have to buy a gas tank. The main bedroom, 2 other bedrooms and the study are on the first floor; all bedrooms have attached bathrooms. On the second level are a game room, a media room and another bedroom with a full bath and a walk in closet. Plantation shutters through out the house. Hard Wood & Tile floors. (Zoned to Anne Sullivan Elementary School)' ,`Acres` = '0.247' ,`Area` = '29' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CREEKSTONE VILLAGE AT RIVERSTONE SEC 6 PHASE II, BLOCK 2, LO' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SULLIVAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekstone Village At Riverstone' ,`TaxAmount` = '11339' ,`TaxRate` = '2.5104' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663704440' WHERE `Matrix_Unique_ID` = '209660412' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:35:23.153' ,`MLSNumber` = '49001636' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.295653' ,`Longitude` = '-95.553497' ,`PhotoCount` = '21' ,`PostalCode` = '77316' ,`RoomCount` = '8' ,`ListPrice` = '630757.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Lily' ,`StreetNumber` = '365' ,`StreetSuffix` = 'Trail' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2165' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS #49001636 ~ REPRESENTATIVE PHOTOS ADDED. Built by Taylor Morrison, Ready December ~ The Driftwood! The gorgeous Driftwood plan is a sprawling one-story home you\'ve always wanted with dual owner’s suites. The gathering room and formal dining area are open to one another and are perfect for celebrations. The kitchen with luxurious finishes and views to the covered outdoor living area would please any chef! One owner’s suite is located towards the rear of the home and is accented with a bay window, walk-in shower, and large walk-in closet. The second private owner’s suite is just off the foyer featuring a soaking tub, separate shower, and walk-in closet. The spacious media room is near the owner’s entry from the 4-car garage. Structural options added at 365 Royal Lily Trail include: bay window, walk-in shower, a dual primary suite w/tub, media room, 4-car garage, covered patio 2, and fireplace.' ,`Acres` = '0.329' ,`Area` = '39' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 43, Block 1, of Bonterra at Woodforest Section 9' ,`LotDesciption` = 'Cul-De-Sac,Other' ,`LotSize` = '14340' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2825' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonterra at Woodforest 50\'s' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704440' WHERE `Matrix_Unique_ID` = '209841744' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:48:18.717' ,`MLSNumber` = '29203864' ,`ListAgentFullName` = 'Carolyn Guillory' ,`ListOfficeName` = 'Pat Griffin Realty ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.156620' ,`Longitude` = '-94.188118' ,`PhotoCount` = '21' ,`PostalCode` = '77708' ,`RoomCount` = '5' ,`ListPrice` = '156000.00' ,`Status` = 'Active' ,`StreetName` = 'Hidden Valley' ,`StreetNumber` = '7315' ,`StreetSuffix` = 'Drive' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1194' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Renovated home with hard wood floors and tile throughout. Spacious back yard with covered patio. There is a utility shed for storage. Each bedroom has its own bath. Wood burning fireplace accents a nice size family room. There is an additional room area that can be a formal dining room or formal living room. Also, the room sizes are estimates. Very nice, comfortable place to call home.' ,`Acres` = '0.1607' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HIDDEN VALLEY ESTATES LT 5 BLK 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'GUESS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'VINCENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hidden Valley Estates' ,`TaxAmount` = '3778' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704440' WHERE `Matrix_Unique_ID` = '209865491' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T13:08:13.983' ,`MLSNumber` = '2733778' ,`ListAgentFullName` = 'Eva Ray' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.202327' ,`Longitude` = '-95.685202' ,`PhotoCount` = '36' ,`PostalCode` = '77362' ,`RoomCount` = '11' ,`ListPrice` = '1189900.00' ,`Status` = 'Active' ,`StreetName` = 'Fishers Cove' ,`StreetNumber` = '14746' ,`StreetSuffix` = '' ,`City` = 'Pinehurst' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3705' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful must-see 1.5 story in gated community of Old Mill Lake. Custom home with luxury finishes include stone fireplace in Great Room, wall of windows overlooking Pool & Spa, paneled Library, hardwood & Tile flooring, granite counters, extra large walk-in pantry, closets & Laundry room. Spacious master suite with cozy fireplace, sitting room & French doors leading to backyard oasis & outdoor kitchen, perfect for alfresco dining! Approx. 3700 sq. ft. with added bonus Private office (approx. 662 sq. ft.) upstairs off garage, plus a 3 car + golf cart garage. Bring your fishing rods to utilize the stocked bass, catch and release pond across the street from this amazing property!' ,`Acres` = '1.09' ,`Area` = '15' ,`BuilderName` = 'ROSEMOND CUSTOM HOME' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'OLD MILL LAKE 01, Block 1, Lot 29, Acres 1.090' ,`LotDesciption` = 'Subdivision Lot,Water View,Wooded' ,`LotSize` = '47480' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2045' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Old Mill Lake' ,`TaxAmount` = '11574' ,`TaxRate` = '1.85857' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663704440' WHERE `Matrix_Unique_ID` = '209955856' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:49:19.507' ,`MLSNumber` = '17079011' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.857525' ,`Longitude` = '-95.192800' ,`PhotoCount` = '33' ,`PostalCode` = '77044' ,`RoomCount` = '7' ,`ListPrice` = '281800.00' ,`Status` = 'Active' ,`StreetName` = 'Karan Park' ,`StreetNumber` = '13222' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1615' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COMPLETION JANUARY/FEBRUARY 2023 Brand new CORNER LOT 1 story 3-bedroom 2 bath 2 car garage. LARGE CORNER LOT OVERSIZED MASTER BEDROOM AND FAMILY ROOM LOADED WITH UPGRADES. Colina Home features Fantasy Blue granite countertops, White 42” cabinets, 9” farmhouse sink ,stainless steel range, microwave, and dishwasher to include our premium 5 burner range , subway kitchen tile backsplash. 9’ ceilings, 2” blinds throughout, large garden tub with separate shower, marble vanity, large walk-in closet, covered back patio, carpet only in bedrooms, luxury vinyl wood plank throughout. Raised panel doors, rounded sheetrock corners and archways. Pex Plumbing, Lennox 16 seer A/C. Taexx Pest Control. All this included for you. Don\'t miss out on 365 day rate lock or $0 down no PMI. PHOTOS ARE REPRESENTATIVE' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 1 Section 6' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tidwell Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704440' WHERE `Matrix_Unique_ID` = '209988986' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:00:36.263' ,`MLSNumber` = '4830294' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.906602' ,`Longitude` = '-95.755383' ,`PhotoCount` = '24' ,`PostalCode` = '77433' ,`RoomCount` = '12' ,`ListPrice` = '792116.00' ,`Status` = 'Active' ,`StreetName` = 'Luddenham Lilac' ,`StreetNumber` = '8907' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3939' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#4830294 REPRESENTATIVE PHOTOS ADDED! Built by Taylor Morrison, December Completion - The Larimar! From its wide-open design to a soaring two-story ceiling in the family room, the Larimar’s open-concept main living spaces feel bright and airy. The area embraces a large island kitchen, spacious family room and casual dining area and offers views out to the covered outdoor living area. Study is located at front of the home for privacy! Owner’s suite is includes a vast walk in closet, tub, shower and dual sinks. Three bedrooms with walk-in closets are situated upstairs on the second level. The upper floor also holds a media room for family movie night and game room. Structural options added to 8907 Luddenham Lilac include: 42\" entry door, lifestyle space, drop in tub and mud-set shower in owner’s bath, fireplace, open railing,15 x 8 sliding glass door and study.' ,`Acres` = '0.167' ,`Area` = '25' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9, Block 1, Of Avalon at Cypress Section 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8878' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Avalon at Cypress 60\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704440' WHERE `Matrix_Unique_ID` = '210060210' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:20:03.547' ,`MLSNumber` = '14135435' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.398595' ,`Longitude` = '-95.688137' ,`PhotoCount` = '8' ,`PostalCode` = '77356' ,`RoomCount` = '10' ,`ListPrice` = '443292.00' ,`Status` = 'Active' ,`StreetName` = 'Dina' ,`StreetNumber` = '142' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2492' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the rolling hills of Montgomery! Beautiful 2 Story, The Gloster Floor Plan with 4 Bedrooms, 3 1/2 Baths, with 2 CAR GARAGE. This floor plan boasts High Ceilings & Spacious OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Formal Dining Room, & 4 spacious bedrooms downstairs, and a Bonus Game room and bathroom on 2nd floor. You will love the Kitchen with lots of cabinets & granite countertops with under the cabinet lighting, stainless steel appliances, & even a USB outlet. Tile and Carpet throughout. SPRINKLER SYSTEM and Fenced Backyard. COST AND ENERGY EFFICIENCY FEATURES: Lennox 16 Seer HVAC System, Honeywell Programmable Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, & Vinyl Double Pane Low E Windows that open to the inside of the home for Cleaning. Amenities include Splash Pad and Playground.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S929900 - Town Creek Crossing 01, BLOCK 4, Lot 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Town Creek Crossing' ,`TaxAmount` = '' ,`TaxRate` = '2.9242' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704441' WHERE `Matrix_Unique_ID` = '210069401' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:17:49.670' ,`MLSNumber` = '38190878' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.398595' ,`Longitude` = '-95.688137' ,`PhotoCount` = '8' ,`PostalCode` = '77356' ,`RoomCount` = '11' ,`ListPrice` = '432277.00' ,`Status` = 'Active' ,`StreetName` = 'Dina' ,`StreetNumber` = '138' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2821' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the rolling hills of Montgomery! Beautiful 2 Story, The Bristol Floor Plan with 4/5 Bedrooms, 3 Baths, with a 2 CAR GARAGE. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Dining Room, and the 5th bedroom downstairs. Upstairs you will find a Game Room, Primary Bedroom with ensuite Full Bath, 2 Bedrooms, and another Full Bath. You will love the Kitchen with lots of cabinets with under the cabinet lighting, Quartz/Granite countertops, SS appliances, and even a USB outlet. COVERED Patio, Sprinkler System, Front & Back Sod, with fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Wifi Programmable Thermostat, PEX Hot & Cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for Cleaning.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S929900 - Town Creek Crossing 01, BLOCK 4, Lot 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Town Creek Crossing' ,`TaxAmount` = '' ,`TaxRate` = '2.9242' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704441' WHERE `Matrix_Unique_ID` = '210071118' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:06:02.357' ,`MLSNumber` = '29521409' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.398595' ,`Longitude` = '-95.688137' ,`PhotoCount` = '8' ,`PostalCode` = '77356' ,`RoomCount` = '11' ,`ListPrice` = '469964.00' ,`Status` = 'Active' ,`StreetName` = 'Dina' ,`StreetNumber` = '134' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2980' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the rolling hills of Montgomery! Beautiful Morton floor Plan with 4 Bedroom, 2 1/2 Bath, with a 2 Car Garage. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room with direct vent Gas Log Fireplace, Kitchen, Breakfast Room, Formal Dining Room, Study, and the Master Bedroom downstairs. Upstairs you will find a Game Room, 3 Bedrooms which 1 Bedroom has an ensuite bath and another full Bath that has 2 sinks. Comes with COVERED PATIO, SPRINKLER SYSTEM, and fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. Amenities include Splash Pad & Playground. . Convenient to TX-105, FM-2854, TX-249 and I-45 for local dining and entertainment and quick commutes to Conroe, The Woodlands, Magnolia, and Tomball. 5 Minutes from Lake Conroe! Montgomery ISD.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S929900 - Town Creek Crossing 01, BLOCK 4, Lot 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Town Creek Crossing' ,`TaxAmount` = '' ,`TaxRate` = '2.9242' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704441' WHERE `Matrix_Unique_ID` = '210077003' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T13:14:07.593' ,`MLSNumber` = '53633916' ,`ListAgentFullName` = 'Babu Kuttarappallil' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.772444' ,`Longitude` = '-95.405023' ,`PhotoCount` = '9' ,`PostalCode` = '77007' ,`RoomCount` = '3' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Allen' ,`StreetNumber` = '4322' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '910' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'In a very good location and you can build your dream home home. contact the listing agent for more information. It was leased previously.' ,`Acres` = '0.0735' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TR 14B BLK 3 LEAGUE J C' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2409' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'League J C' ,`TaxAmount` = '3974' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663704441' WHERE `Matrix_Unique_ID` = '210116912' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:05:29.130' ,`MLSNumber` = '54144240' ,`ListAgentFullName` = 'Tonya Mitchell' ,`ListOfficeName` = 'Century 21 Garlington & Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.893715' ,`Longitude` = '-95.024809' ,`PhotoCount` = '44' ,`PostalCode` = '77532' ,`RoomCount` = '7' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Bohemian Hall' ,`StreetNumber` = '14401' ,`StreetSuffix` = 'Road' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2320' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property is 3.34 Acres w/045-121-000-0097. Additional renovations done to increase the Sq.Feet. Interior of home has been completely updated and includes beautiful woodwork thru out and on ceilings. Master BR accommodates large furniture and Master Bath en suite is a true refuge from a long day! Separate spa tub, large seated shower, and dual vanities complete this beautiful space. Secondary Bedrooms are large with great closet space. Kitchen is open to Family room and Breakfast/Dining Area which makes family gatherings awesome. Office space accommodates several pieces of furniture to aid in working/studying from home and privacy for zoom meetings. In addition to these spaces, is a flex room, perfect for morning coffee, evening wine, or a playroom for kids. Adding to the indoor appeal, is an outdoor oasis that has to be seen to truly appreciate. Large patio/deck, detached garage with parking for 3, barn, work area, inground pool, and a Bass stocked Pond. Don\'t miss out!' ,`Acres` = '3.34' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 7C ABST 817 T TOBY' ,`LotDesciption` = 'Cleared,Greenbelt' ,`LotSize` = '145490' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'BARRETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Toby Thos' ,`TaxAmount` = '2449' ,`TaxRate` = '2.1501' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704441' WHERE `Matrix_Unique_ID` = '210226847' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T13:50:27.427' ,`MLSNumber` = '10200951' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.929235' ,`Longitude` = '-95.737986' ,`PhotoCount` = '31' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '799023.00' ,`Status` = 'Active' ,`StreetName` = 'Thirsty Horse' ,`StreetNumber` = '15634' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3319' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#10200951 ~ REPRESENTATIVE PHOTOS ADDED. December Completion! The modern 5807 Darling Collection plan is a 2 story home featuring a welcoming entry and soaring ceilings. Drawing you into the home, the open designer kitchen shows off a large island, built-in appliances, walk-in pantry and huge utility room! The connecting dining and family room creates the perfect space to entertain. The relaxing owner\'s suite has a spa-like bathroom with separate vanities, step-in shower and oversized walk-in shower. A private main level bedroom with en suite bath and walk-in closet works well for guests! Upstairs offers three more bedrooms with two shared bathrooms, and a game room. Walking distance to the Parkland Village Dragonfly Park and amenities center. Final opportunity in the highly sought after modern section in Bridgeland! Structural upgrades at 15634 Thirsty Horse Trail include: double front doors, fireplace and shower at secondary bath.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2, Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7649' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bridgeland 60\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704441' WHERE `Matrix_Unique_ID` = '210283344' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:19:06.590' ,`MLSNumber` = '48887316' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.707576' ,`Longitude` = '-95.875617' ,`PhotoCount` = '16' ,`PostalCode` = '77441' ,`RoomCount` = '8' ,`ListPrice` = '487957.00' ,`Status` = 'Active' ,`StreetName` = 'Copper Ridge' ,`StreetNumber` = '28907' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2021' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready December! Built by Taylor Morrison! This perfectly sized 2,021 square foot home features an open kitchen, family and casual dining combo that will comfortably fit all your guests. Elbow room won’t be a problem in this island kitchen, complete with built-in appliances and corner pantry. With the extension added to the covered patio, the indoor/outdoor space opens up to a beautifully groomed back yard. The owner’s suite is lined with a bay window that floods the room with natural light thanks to this homes North/South exposure. Smartly designed, the owner’s bath has a stand up shower with seat, dual vanities and another window in the perfect place for morning sun. Complete with two guest bedrooms and full bath, adorable owner’s entry and laundry room, the Maple is sure to make you feel right at home. Structural options added include: covered outdoor living 1, half bath, extended owner\'s suite, study, raised ceilings and 8\' doors.' ,`Acres` = '0.17' ,`Area` = '30' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Block 2 Lot 01' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7643' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2925' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonterra at Cross Creek Ranch 50\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.45' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704441' WHERE `Matrix_Unique_ID` = '210359755' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:08:13.890' ,`MLSNumber` = '95350592' ,`ListAgentFullName` = 'Jace Bowlin' ,`ListOfficeName` = 'Real Broker, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.274888' ,`Longitude` = '-94.933255' ,`PhotoCount` = '25' ,`PostalCode` = '77327' ,`RoomCount` = '4' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2286' ,`StreetNumber` = '679' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2338' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'It\'s time for to experience country living at its finest! Custom built on 4 acres, this beautiful home in Cleveland, TX offers 4 bedrooms, 2 bathrooms, plus an additional guest suite, and a half bathroom. Tarkington ISD. Superb curb appeal with the white painted brick and black trim, this home features tall ceilings and beautiful ceramic tile upon entry. This home\'s open floor plan will definitely impress you. With a beautiful island, granite countertops, stainless steel whirlpool appliances, and a large walk-in pantry, the kitchen is full of storage. With dual sinks, separate shower and bathtub, and a large walk-in closet with built-in storage, the main suite is spacious and ready for relaxation. Additionally, there are three more nice sized bedrooms and a full bath. The back yard has a large covered patio with fans and recessed lighting waiting for you to entertain. There is a guest suite with its own half bath located just off the patio. Zoned to TARKINGTON ISD! 20x10 shed included!' ,`Acres` = '4' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000447 M TANNER, TRACT 69, ACRES 4.0' ,`LotDesciption` = 'Wooded' ,`LotSize` = '174240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'TARKINGTON PRIMARY SCHOOL' ,`SchoolHigh` = 'TARKINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'TARKINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'M Tanner' ,`TaxAmount` = '4677' ,`TaxRate` = '1.5226' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704441' WHERE `Matrix_Unique_ID` = '210471313' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T13:02:37.593' ,`MLSNumber` = '60892036' ,`ListAgentFullName` = 'Lai Duc Hong' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.562549' ,`Longitude` = '-95.220440' ,`PhotoCount` = '41' ,`PostalCode` = '77581' ,`RoomCount` = '10' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'San Conero' ,`StreetNumber` = '2403' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3043' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready to move in 2-story 4-bed and 3-and-half bath with masterbed and studyroom down in a quiet subdivision. All tile and laminate throughout house with high ceiling and spacious. Dual stairs case. Washer, dryer and refrigerator included. Previous owner replaced roof in 2016, new fence 2021, new AC units 2021. Easy to access Frwy 45 and Belt8. Hurry to make appointment before you miss it.' ,`Acres` = '0.1928' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 1 VILLA VERDE SEC 3 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'WEBER ELEMENTARY' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'WESTBROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villa Verde Sec 03' ,`TaxAmount` = '8982' ,`TaxRate` = '2.8854' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704442' WHERE `Matrix_Unique_ID` = '210668637' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:45:45.123' ,`MLSNumber` = '68101025' ,`ListAgentFullName` = 'Lovie Verser' ,`ListOfficeName` = 'JPAR Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.981862' ,`Longitude` = '-95.553733' ,`PhotoCount` = '23' ,`PostalCode` = '77070' ,`RoomCount` = '3' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Naples Park' ,`StreetNumber` = '7906' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1868' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location! Vintage Park is the perfect location for you!\r\nPrivacy on a Cul-De-Sac! Welcome to your impeccably\r\nmaintained move-in-ready home tucked away in sought-after Prestonwood Park on a quiet cul-de-sac. This spacious\r\n3 bedroom/2 bathroom beauty has a lot to offer. Featuring\r\nan oversized owner’s bedroom, en suite & huge walk-in\r\ncloset, open concept living area with double-sided\r\nfireplace, and plenty of natural light. This quiet\r\nneighborhood is conveniently located close to 249, Grand\r\nParkway and Beltway 8. Your family will enjoy Vintage Park for\r\na variety of shops and eateries.' ,`Acres` = '0.1357' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 36 BLK 2 PRESTONWOOD PARK SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5913' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '395' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HANCOCK ELEMENTARY SCHOOL (CY-FAIR)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Prestonwood Park Sec 01' ,`TaxAmount` = '4741' ,`TaxRate` = '2.4087' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704442' WHERE `Matrix_Unique_ID` = '210747136' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:10:08.020' ,`MLSNumber` = '93144306' ,`ListAgentFullName` = 'Jodie Bente' ,`ListOfficeName` = 'RE/MAX 1st Choice' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.373017' ,`Longitude` = '-95.133325' ,`PhotoCount` = '44' ,`PostalCode` = '77517' ,`RoomCount` = '4' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Tallow' ,`StreetNumber` = '14610' ,`StreetSuffix` = 'Street' ,`City` = 'Santa Fe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2054' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'come on home to this spacious updated beauty with a park like setting! To many updates to mention them all, newer roof (2019), plumbing redone , brand new flooring, interior and exterior paint and so much more!!! come relax on your huge front porch in your park like setting all on a dead end street!!! Seller has also finished all the inside base boards from pictures' ,`Acres` = '0.936' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 612 I & G N RR SUR SEC 18 PT OF LOT E (5-4) BLK 76 ANGE' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '40772' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'ROY J. WOLLAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Angell-Runge Add' ,`TaxAmount` = '3638' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704442' WHERE `Matrix_Unique_ID` = '210772145' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T13:35:06.773' ,`MLSNumber` = '21591418' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.186137' ,`Longitude` = '-95.416409' ,`PhotoCount` = '18' ,`PostalCode` = '77515' ,`RoomCount` = '7' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Bennett' ,`StreetNumber` = '208' ,`StreetSuffix` = 'Loop' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1313' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! nuHome by Lennar Colonial Collection \"San Marcos\" Plan with Elevation \"B\" in Riverwood Ranch! A cozy single-story home, this layout features a large centered living room surrounded by private bedrooms and bathrooms. The kitchen highlights a tucked away dining nook with window views that provide natural lighting. *HOME ESTIMATED TO BE COMPLETE, NOVEMBER, 2022*' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0002 BLK 001 LOT 003' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverwood Ranch' ,`TaxAmount` = '' ,`TaxRate` = '2.744432' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704442' WHERE `Matrix_Unique_ID` = '210789022' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T13:35:46.927' ,`MLSNumber` = '50896496' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.187223' ,`Longitude` = '-95.417369' ,`PhotoCount` = '18' ,`PostalCode` = '77515' ,`RoomCount` = '6' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Bennett' ,`StreetNumber` = '207' ,`StreetSuffix` = 'Loop' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! nuHome by Lennar Colonial Collection \"La Vista\" Plan with Elevation \"A\" in Riverwood Ranch! A single-story home, this open layout features a living room that unites with the dining room and kitchen for effortless gathering. Two bedrooms are conveniently accessible from the living room and the owner’s suite, privately situated, comes complete with a walk-in closet and en-suite bathroom. *HOME ESTIMATED TO BE COMPLETE, December 2022*' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0002 BLK 002 LOT 002' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverwood Ranch' ,`TaxAmount` = '' ,`TaxRate` = '2.744432' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704442' WHERE `Matrix_Unique_ID` = '210828666' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:28:43.323' ,`MLSNumber` = '82384142' ,`ListAgentFullName` = 'Charlene Findley' ,`ListOfficeName` = 'Boom Real Estate' ,`SellingAgentFullName` = 'Toni Hite' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '29.922452' ,`Longitude` = '-95.091135' ,`PhotoCount` = '40' ,`PostalCode` = '77532' ,`RoomCount` = '9' ,`ListPrice` = '374900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Chart' ,`StreetNumber` = '1438' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2320' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Bright spacious floor plan with high ceilings. Formal dining and study that can be used as a 5th bedroom. Lg open kitchen with granite counters, breakfast area views the pool outback. Living room with a wood-burning fireplace, and ceramic tile throughout. The primary bedroom offers plenty of space for a sitting area. Primary bath with a walk-in shower and jetted tub and dual sinks, LG walk-in closet. The covered back patio is perfect for entertaining while grilling and taking a dip in your very own saltwater pool. New A/C unit. New Solar screens. Freshly landscaped and irrigation added. Fresh paint on the exterior. The pool has a Catch A kid Net and a cover for safety. Storage shed can easily be made into a she shed or man cave, or kept as storage space.' ,`Acres` = '0.2652' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 14 NEWPORT SEC 4' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '11550' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Salt Water' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Sec 04' ,`TaxAmount` = '7427' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704442' WHERE `Matrix_Unique_ID` = '211077584' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:29:27.970' ,`MLSNumber` = '73421402' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.293811' ,`Longitude` = '-95.552825' ,`PhotoCount` = '23' ,`PostalCode` = '77316' ,`RoomCount` = '9' ,`ListPrice` = '545529.00' ,`Status` = 'Active' ,`StreetName` = 'Stargazer Lily' ,`StreetNumber` = '229' ,`StreetSuffix` = 'Bend' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2169' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS #73421402 ~ REPRESENTATIVE PHOTOS ADDED. Built by Taylor Morrison, Ready December ~ The Driftwood! This gorgeous floor plan design is a sprawling one-story home you\'ve always wanted. Upon entry, a private guest bedroom and shared bath is perfect for overnight guests or family. Continue down the foyer to the flex room and a secondary bedroom with an ensuite bath. In the heart of the home, enjoy the open gathering room, dining area, and kitchen with long center island. Perfect for entertaining! The owner’s suite and bath are located towards the rear of the home and features a walk-in shower, large walk-in closet, and dual vanity. Enjoy views of your backyard oasis under the spacious covered patio. Structural options added at 229 West Stargazer Lily Bend include: walk-in shower in owner’s suite, covered patio 2, 5’ garage extension, raised ceilings in gathering room, and a sink in the laundry room.' ,`Acres` = '0.217' ,`Area` = '39' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25, Block 1, of Bonterra at Woodforest Section 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9460' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2825' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonterra at Woodforest 50\'s' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704442' WHERE `Matrix_Unique_ID` = '211094087' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:26:48.573' ,`MLSNumber` = '74214706' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.293960' ,`Longitude` = '-95.552949' ,`PhotoCount` = '40' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '542297.00' ,`Status` = 'Active' ,`StreetName` = 'Stargazer Lily' ,`StreetNumber` = '233' ,`StreetSuffix` = 'Bend' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '2021' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS #74214706 ~ REPRESENTATIVE PHOTOS ADDED! Built by Taylor Morrison, Ready December ~ The Dovetail! This home will have you feeling like you have a one-of-a-kind, custom designer home. Embrace this 2-bedroom, 2-bathroom home with a study and open concept living. The extravagant foyer will reel you in upon entry with clean lines and wall space for your personal décor. The private study and secondary bedroom are just off the front foyer area. The gathering room, which is open to a luxurious kitchen and breakfast area, has views to the covered outdoor living. The owner’s retreat will become your sanctuary featuring a bay window, a plush bathroom, and enormous walk-in closet. Structural Options added at 233 West Stargazer Lily Bend include: a bay window, covered outdoor living 1, 8’ entry and rear doors, raised ceiling at the foyer, shower/mud-set at owner’s bath, and study.' ,`Acres` = '0.182' ,`Area` = '39' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 26, Block 1, of Bonterra at Woodforest Section 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7949' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2825' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonterra at Woodforest 50\'s' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704443' WHERE `Matrix_Unique_ID` = '211099800' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:24:16.727' ,`MLSNumber` = '8557732' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.294461' ,`Longitude` = '-95.553007' ,`PhotoCount` = '34' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '493410.00' ,`Status` = 'Active' ,`StreetName` = 'Stargazer Lily' ,`StreetNumber` = '241' ,`StreetSuffix` = 'Bend' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS #8557732 ~ REPRESENTATIVE PHOTOS ADDED! Built by Taylor Morrison, Ready December ~ The Evergreen! Embrace this 2-bedroom, 2-bathroom home with a flex and open concept gathering room. The extravagant foyer will reel you in upon entry with clean lines and wall space for your personal décor. The flex room can be used as a study or home office. Entertain in the gathering room that flows seamlessly to the perfect kitchen and breakfast area and enjoy the views to the covered outdoor living. The owner\'s suite and bath will become your own personal sanctuary featuring a bay window, walk-in shower, and walk-in closet. The secondary bedroom and shared bath are near the owner’s entry from the 2-car garage. Structural options at 241 West Stargazer Lily Bend include: bay window at owner\'s suite, covered outdoor living, 4’ garage extension, raised ceilings in main living areas, and 8’ entry and rear doors.' ,`Acres` = '0.176' ,`Area` = '39' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 28, Block 1, of Bonterra at Woodforest Section 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7658' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2825' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonterra at Woodforest 50\'s' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704443' WHERE `Matrix_Unique_ID` = '211104770' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:28:48.267' ,`MLSNumber` = '71285736' ,`ListAgentFullName` = 'Justin Guyer' ,`ListOfficeName` = 'RE/MAX Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.722440' ,`Longitude` = '-96.422608' ,`PhotoCount` = '47' ,`PostalCode` = '77465' ,`RoomCount` = '7' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayview' ,`StreetNumber` = '1253' ,`StreetSuffix` = 'Drive' ,`City` = 'Palacios' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fisherman\'s weekend retreat! Your new favorite place to relax and enjoy the salt life is here. Upstairs there are 3 spacious bedrooms, 1 full bathroom, a U-shaped kitchen with counter height dining as well as open concept dining and living with walls of windows for plenty of natural light. Downstairs you\'ll find the large quest suite with full bath, living area and laundry & storage closets. The separate spaces could easily be used as additional bedroom, game room or storage. Community amenities include: Lighted fishing piers, boat ramp, 2 swimming pools, community center, tennis courts, playground, parks and friendly atmosphere.' ,`Acres` = '0.19' ,`Area` = '67' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CAPE CARANCAHUA #2, LOT 577, ACRES 0.19' ,`LotDesciption` = 'Corner,Subdivision Lot,Water View' ,`LotSize` = '8276' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '156 - Palacios' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (PALACIOS)' ,`SchoolHigh` = 'PALACIOS HIGH SCHOOL' ,`SchoolMiddle` = 'PALACIOS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cape Carancahua 02' ,`TaxAmount` = '2842' ,`TaxRate` = '1.8978' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704443' WHERE `Matrix_Unique_ID` = '211148948' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T13:36:43.613' ,`MLSNumber` = '90678430' ,`ListAgentFullName` = 'Tonya Kiliddjian' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.174031' ,`Longitude` = '-95.171473' ,`PhotoCount` = '35' ,`PostalCode` = '77357' ,`RoomCount` = '6' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Southwood' ,`StreetNumber` = '2006' ,`StreetSuffix` = 'Drive' ,`City` = 'Woodbranch' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1886' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning two story on large lot. Incredibly remodeled kitchen with granite, double ovens, under cabinet lighting, walk in pantry, large undermount sink, tons of counter space, cabinets and drawers. Amazing electric fireplace with remote to change lighting colors... does offer heat when set to heat. Improvements include roof 2018, lowE double pane windows 2018, water heater 2017, utility room addition 2016, flooring in living 2016. Amazing yard front and back. Backyard has large covered patio area perfect for all your entertaining needs with a quiet and tranquil surrounding. Large storage shed included, perfect for all your storage needs. The utility room is every home owners dream with ample space for storage, and your extra fridge and freezer. You will love the low taxes and no hoa fees here. Enormous master bedroom is perfect for all your furnishings along with large secondary bedrooms. Paint and carpet upstairs are as pictured. What a find!' ,`Acres` = '0.1928' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WOODWAY FOREST 01, BLOCK 1, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`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` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodway Forest 01' ,`TaxAmount` = '3050' ,`TaxRate` = '2.4398' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704443' WHERE `Matrix_Unique_ID` = '211202920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:59:39.090' ,`MLSNumber` = '54868499' ,`ListAgentFullName` = 'Buddy Novak' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.715377' ,`Longitude` = '-94.935113' ,`PhotoCount` = '32' ,`PostalCode` = '77351' ,`RoomCount` = '9' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Beatty' ,`StreetNumber` = '905' ,`StreetSuffix` = 'Avenue' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2583' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large unique 5 BR 2 BA- 2,583\' square foot Historic home built in 1905 centrally located in downtown Livingston. Features a large kitchen, wonderful formal dining and den with Master BR & bath downstairs. 4 large bedrooms and another full bath upstairs. Has a 2 car carport and storage building. New Roof installed in 2021. AC was replaced 2018. This home is a Historic Landmark designated by the Polk County Heritage Society known as the \"Ray Brock\" home. Come take a look and own a slice of History! The potential of this home is unlimited!' ,`Acres` = '0.303' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 15 M L CHOATE SURVEY SEC 1 SUB LOT 91' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '13200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'NA' ,`TaxAmount` = '2276' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1905' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704443' WHERE `Matrix_Unique_ID` = '211261643' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T13:09:25.553' ,`MLSNumber` = '54547581' ,`ListAgentFullName` = 'Jocelyn Nieman' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.726779' ,`Longitude` = '-95.509663' ,`PhotoCount` = '46' ,`PostalCode` = '77063' ,`RoomCount` = '10' ,`ListPrice` = '699999.00' ,`Status` = 'Active' ,`StreetName` = 'Pagewood' ,`StreetNumber` = '8010' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2661' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Briarmeadow! This 3 bedroom, 2 bath home has been newly remodeled and is great for entertaining! Upgrades include: New LOE windows, 30 yr GAF composite roof, PEX above ground plumbing, and engineered hardwood floors throughout. This home has a beautiful kitchen with custom built soft close cabinets, quartz countertops, stainless steel appliances, peninsula with breakfast area that opens to the living room with vaulted ceilings and a gas/wood burning fireplace. It also features an additional family/living space that offers lots of natural bright lighting and French doors that lead to the large backyard covered patio! Bathrooms have double sinks, quartz countertops, and custom built cabinets, and new tile. The Primary bath has a walk in shower with sliding glass door, walk in closet and 2 additional smaller closets for extra space! 24 hour constable and neighborhood pool.' ,`Acres` = '0.2181' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briarmeadow/Tanglewilde' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 25 BRIARMEADOW SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '720' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PINEY POINT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Briarmeadow Sec 01' ,`TaxAmount` = '8355' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704443' WHERE `Matrix_Unique_ID` = '211416703' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:52:34.423' ,`MLSNumber` = '72302570' ,`ListAgentFullName` = 'Jack McLemore' ,`ListOfficeName` = 'Listing Results, LLC' ,`SellingAgentFullName` = 'David Gloger' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.604211' ,`Longitude` = '-95.230897' ,`PhotoCount` = '23' ,`PostalCode` = '77089' ,`RoomCount` = '10' ,`ListPrice` = '239900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Kirkmeadow' ,`StreetNumber` = '11443' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1719' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Single story all brick beauty. 4 bedrooms 2 full bathrooms. Remodeled in 2018 including new roof and garage doors in August 2018, new HVAC and stainless steel appliances in July 2018. New indoor paint including garage in July 2022. No carpet, only tile throughout the house. Indoor laundry room with A/C. Granite countertops in kitchen & bathrooms. Ceiling fans in all bedrooms and living room. Not located in a flood zone and has never flooded. Conveniently located near Beltway 8, I-45 & 288. 13 min from Hobby airport. 7 min from Memorial Herman Hospital.' ,`Acres` = '0.1692' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 & W 2 FT OF LT 10 BLK 10 KIRKWOOD SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7370' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'ATKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Kirkwood Sec 02' ,`TaxAmount` = '4680' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704443' WHERE `Matrix_Unique_ID` = '211434015' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:33:53.143' ,`MLSNumber` = '27412692' ,`ListAgentFullName` = 'Alberto Castanon' ,`ListOfficeName` = 'DSG Realty Goup' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.796201' ,`Longitude` = '-95.466266' ,`PhotoCount` = '6' ,`PostalCode` = '77055' ,`RoomCount` = '2' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Corbin' ,`StreetNumber` = '6534' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is being sold as is. Lot value only. Great neighborhood, ready for your dream home to be built on. Lovely neighbors, minutes away from stores, movie theater and restaurants. Phenomenal location!' ,`Acres` = '0.1865' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 26 BLK 1O WESTVIEW TERRACE' ,`LotDesciption` = 'Other' ,`LotSize` = '8125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westview Terrace' ,`TaxAmount` = '8025' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704444' WHERE `Matrix_Unique_ID` = '211471218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T13:01:20.313' ,`MLSNumber` = '10838234' ,`ListAgentFullName` = 'Pamela Messina' ,`ListOfficeName` = 'Messina Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835735' ,`Longitude` = '-95.789104' ,`PhotoCount` = '39' ,`PostalCode` = '77493' ,`RoomCount` = '12' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'San Barria' ,`StreetNumber` = '23826' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3482' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'IMMACULATE MOVE-IN READY 5-Bedroom, 3.5 Bath Home with Covered Patio and Water Softener! Home comes complete with ALL MEDIA EQUIPMENT, I.E. SURROUND SOUND SPEAKERS, COMPONENTS, PROJECTOR AND FURNITURE TO STAY! The chef\'s gourmet kitchen offers gas cooking, granite countertops and LOTS of CABINETS FOR STORAGE with a Walk-In Pantry! Primary Bedroom is Downstairs with a super-sized walk-in closet, oversized shower, soaking tub, DBL sinks and vanity knee space. All Bedrooms are Extra-Large with Ceiling Fans and Generously-Sized Closets. The Laundry Room is big enough for an extra refrigerator or freezer. FRESH INTERIOR PAINT! Located close to 99 with easy access to I-10, Shopping, Restaurants and MORE! The neighborhood is beautiful and loaded with Amenities which include TWO Swimming Pools, Splash Pad and Clubhouse (available to rent for your special occasion). Katy ISD. THIS HOME WILL NOT DISAPPOINT...CALL YOUR REALTOR TODAY AND SCHEDULE YOUR PRIVATE SHOWING!' ,`Acres` = '0.1492' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 1 VENTANA LAKES SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ventana Lakes' ,`TaxAmount` = '9228' ,`TaxRate` = '3.2768' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704444' WHERE `Matrix_Unique_ID` = '211503170' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T13:06:59.777' ,`MLSNumber` = '32004221' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'RE/MAX Legends' ,`SellingAgentFullName` = 'Tiffany Varela' ,`SellingOfficeName` = 'Connect Realty' ,`Latitude` = '30.226537' ,`Longitude` = '-95.464225' ,`PhotoCount` = '37' ,`PostalCode` = '77384' ,`RoomCount` = '9' ,`ListPrice` = '595000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Rope Maker' ,`StreetNumber` = '2136' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3133' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BREATHTAKING 1 STORY DESIGNER SHOWPLACE! Beautiful Craftsman-Style Exterior with Covered Porch! Absolutely GORGEOUS Interior - MEGA Upgrades + Desirable Split Plan Design! Impressive Foyer Opens to Supersized Family Room - Gas Log Fireplace, Recessed Lighting, & Stately Millwork! Chef\'s Dream Island Kitchen: Granite Counters, Stainless Bosch Appliances, 42\" Cabinetry with Under Cabinet Lighting, & Basket-Weave Style Backsplash! Big Walk-In Pantry! Home Office/Study/Flex Room - Plantation Shutters + French Doors to Patio! Privately Located Master Suite - Dramatic Tray Ceiling! Luxurious Bath: Dual Sinks, Soaking Tub, & Oversized Shower with Bench! MASSIVE 18 x 14 Walk-In Closet with Built-Ins + Direct Access to Utility Room! Movie Lover\'s Media Room - Sconce Lighting & 7.1 Surround Sound Wiring! Covered Brick Patio with Fan - AND Extended Patio Area with Pergola & Fountains! Private Setting - Backs to Wooded Area! Quaint Community with 4 Acre Gathering Space + Easy Access to Woodlands!' ,`Acres` = '0.2157' ,`Area` = '15' ,`BuilderName` = 'Gracepoint' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S903303 - STILLWATER 03, BLOCK 4, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9397' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1075' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'POWELL ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Stillwater' ,`TaxAmount` = '11652' ,`TaxRate` = '3.0663' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704444' WHERE `Matrix_Unique_ID` = '211565212' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T13:55:31.570' ,`MLSNumber` = '53864591' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.887123' ,`Longitude` = '-95.834658' ,`PhotoCount` = '10' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Vista Field' ,`StreetNumber` = '27015' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1311' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Homes Cottage Series, \'\'Windhaven\'\' Plan with Elevation \'\'C\" in Beautiful Winward! This single-story home has a comfortable layout with three bedrooms and a living area all on one floor. The front door leads into the living room, which flows into the kitchen and dining area in an open concept layout. Two bedrooms share a hall bathroom at the front of the home, while tucked into the back corner is the owner’s suite with a full bathroom and walk-in closet.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0007 BLK 004 LOT 004' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Winward' ,`TaxAmount` = '' ,`TaxRate` = '3.54' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704444' WHERE `Matrix_Unique_ID` = '211693716' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:14:43.007' ,`MLSNumber` = '10060348' ,`ListAgentFullName` = 'Jaclyn Tilley' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.217195' ,`Longitude` = '-95.420117' ,`PhotoCount` = '32' ,`PostalCode` = '77385' ,`RoomCount` = '10' ,`ListPrice` = '368500.00' ,`Status` = 'Active' ,`StreetName` = 'Snowy Egret' ,`StreetNumber` = '16380' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2755' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This 4BR, 2 1/2 BA home features a NEW/FRESH feeling, custom cabinets in garage, laundry and gameroom, Solar panels provide a HUGE savings on electricity!! Open concept from kitchen to living room perfect for entertaining. Kitchen features: Granite countertops, an abundance of cabinet space, undermount sink, stainless appliances, upgraded range and more. Relax on your back porch covered patio, low maintenance yard. Call your agent for a showing today.' ,`Acres` = '0.1142' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S720820 - MONTGOMERY CREEK RANCH 20, BLOCK 1, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4975' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '266' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Creek Ranch 20' ,`TaxAmount` = '6634' ,`TaxRate` = '2.6088' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704444' WHERE `Matrix_Unique_ID` = '211762517' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T13:14:09.700' ,`MLSNumber` = '96234643' ,`ListAgentFullName` = 'Kitten Strahan' ,`ListOfficeName` = 'Leopold & Strahan Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.388443' ,`Longitude` = '-94.928892' ,`PhotoCount` = '12' ,`PostalCode` = '77590' ,`RoomCount` = '3' ,`ListPrice` = '99900.00' ,`Status` = 'Active' ,`StreetName` = '4th' ,`StreetNumber` = '2327' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1333' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Calling all investors!!! 3 Bedroom/2 Bath home with a massive enclosed covered patio. Per the City of Texas City, property must be fully rehabbed to certain specifications, permitted by the City of Texas City and completed and signed off by The City of Texas City no later than 11/8/22.' ,`Acres` = '0.2009' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 142 PAGE 4 LOT 12 LOGAN COURT SUB' ,`LotDesciption` = 'Other' ,`LotSize` = '8750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HEIGHTS ELEMENTARY SCHOOL (TEXAS CITY)' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Logan Courts' ,`TaxAmount` = '3494' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704444' WHERE `Matrix_Unique_ID` = '211769969' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:44:02.947' ,`MLSNumber` = '3177322' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.066730' ,`Longitude` = '-94.109595' ,`PhotoCount` = '27' ,`PostalCode` = '77701' ,`RoomCount` = '9' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue H' ,`StreetNumber` = '1090' ,`StreetSuffix` = '' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2320' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated in the heart of Beaumont, this 2,320 Sq Ft 3 bed 2 bath home on a corner lot is move-in ready and won\'t last long! This home boasts hardwood flooring throughout, generously sized bedrooms, and lots of space! Upon entry you are greeted by the large great room that seamlessly transitions into the formal dining room and kitchen area boasting a breakfast bar, gas range, and an abundance of storage space! The living room is located off of the breakfast area. The primary bedroom is large in size and boasts a flex room and access to the utility room! Exterior features include an attached 2-car garage, covered patio, full fencing and an electric driveway gate. Schedule a private tour today' ,`Acres` = '0.1722' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CARTWRIGHT TERR L 6 B 6' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'FLETCHER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'KING MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cartwright Terrace' ,`TaxAmount` = '2009' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704445' WHERE `Matrix_Unique_ID` = '211780057' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:46:38.583' ,`MLSNumber` = '88704715' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.101623' ,`Longitude` = '-94.127027' ,`PhotoCount` = '19' ,`PostalCode` = '77703' ,`RoomCount` = '8' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = '9th' ,`StreetNumber` = '2535' ,`StreetSuffix` = 'Street' ,`City` = 'Beaumont' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2832' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Take a look at this 3 bed 3 bath home situated on 0.5 acres in the heart of Beaumont! This home boasts 2,832 Sq Ft of living space and features built-in shelving, high ceilings, and immense potential! Upon entry you are greeted by the formal entrance with a formal dining area to your left. The living room features a brick wood burning fireplace, tile flooring and access to the backyard. The kitchen flaunts a breakfast bar extending out to the living room, ample storage space, and a built-in oven. Additionally, there is a large sun room. Exterior features include a massive backyard, covered back patio, and an attached 2-car garage! This home is priced to sell and won\'t last long. Schedule a private tour today!' ,`Acres` = '0.5002' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PECAN GROVE E168.5 OF L18&19 & E168.5 OF N20.75 OF L17 & E16' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '21787' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'JONES-CLARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Grove To Beaumont' ,`TaxAmount` = '3757' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704445' WHERE `Matrix_Unique_ID` = '211786655' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T13:38:36.990' ,`MLSNumber` = '76533837' ,`ListAgentFullName` = 'Ashton Gill' ,`ListOfficeName` = 'BHGRE Gary GreeneLeague City' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.508864' ,`Longitude` = '-94.993821' ,`PhotoCount` = '20' ,`PostalCode` = '77518' ,`RoomCount` = '8' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Clay' ,`StreetNumber` = '4002' ,`StreetSuffix` = 'Lane' ,`City` = 'Bacliff' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1290' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This nicely maintained one and a half story home sits on a double lot and is only a one block walk from the local elementary school. The entire downstairs flooring is tile and bathroom counter is granite. A hidden bonus office/media room is upstairs. All major appliances are staying, to include the washer, dryer, stove/oven, and refrigerator. The home is a more recent build in 2016 and had NO FLOODING during Hurricane Harvey, per the seller. The giant fenced in backyard has a slab already poured and built for any additional storage or structures a buyer might want. This home is move in ready!' ,`Acres` = '0.2296' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 89 S HINTON SUR LOTS 1 & 2 BLK 17 BAY CLIFF HEIGHTS' ,`LotDesciption` = 'Corner' ,`LotSize` = '10000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'KENNETH E. LITTLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Other Style' ,`Subdivision` = 'Bacliff Heights' ,`TaxAmount` = '3305' ,`TaxRate` = '2.2342' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663704445' WHERE `Matrix_Unique_ID` = '211814452' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:45:20.740' ,`MLSNumber` = '61655774' ,`ListAgentFullName` = 'Yi Zhang' ,`ListOfficeName` = 'All Side Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834554' ,`Longitude` = '-95.727696' ,`PhotoCount` = '37' ,`PostalCode` = '77449' ,`RoomCount` = '6' ,`ListPrice` = '322800.00' ,`Status` = 'Active' ,`StreetName` = 'Footstep' ,`StreetNumber` = '20615' ,`StreetSuffix` = 'Path' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1787' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Amazing 3 bedroom 2 bathroom home located in Westfield Ranch is sure to impress! Large covered front porch, Study room with French Door by the entrance. Open concept kitchen with huge island bar , granite countertops open to dinning area and family room with higher ceilings. Modern looking fabric blinds. The split floorplan has the Primary Bedroom located at the back of the home . The Primary Bath features double sinks, a walk in closet and a separate tub/shower. The backyard covered patio. Great benefits for buyer to keep the paid off Solar Panels at Zero cost, lots of savings. Zoned to highly acclaimed Cypress-Fairbanks Independent School District (CFISD). Residents can enjoy a playground, splashpad and baseball/soccer field. Easy access to golf courses, major shopping centers, popular restaurants and entertainment. Close to beautiful Bear Creek Pioneer Park, Minutes to Grand parkway 99 and I-10. Great value than new builds. Schedule your showings today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Westfield Ranch Section1, BLOCK 3, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5110' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield Ranch' ,`TaxAmount` = '6630' ,`TaxRate` = '3.01' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704445' WHERE `Matrix_Unique_ID` = '211839688' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:06:44.680' ,`MLSNumber` = '31974543' ,`ListAgentFullName` = 'Andrew Codia' ,`ListOfficeName` = 'Ameri Choice Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812515' ,`Longitude` = '-95.798719' ,`PhotoCount` = '15' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '405000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakecrest Bend' ,`StreetNumber` = '24703' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2772' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Easy access to Hwy 99, I-10, Hwy 99, and Westpark Toll Rd. A few minutes away from the new Katy Asian Town, Katy Mills, Costco, Walmart, and major groceries. Located in award-winning Katy ISD. Build by Perry Home. House features 4 bedrooms, 2 full baths, 2 car garages, high ceilings, split floor plan, breakfast, combo formal dining and living, family room, ceramic tile, french door, and oversized cover patio.\r\nLOW TAXES 2.6083 AND LOW HOA DUE.' ,`Acres` = '0.1205' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 4 LAKECREST FOREST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakecrest Forest Sec 01' ,`TaxAmount` = '7042' ,`TaxRate` = '2.6083' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704445' WHERE `Matrix_Unique_ID` = '211846285' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:30:03.893' ,`MLSNumber` = '86887843' ,`ListAgentFullName` = 'DeAndra Knight' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.897051' ,`Longitude` = '-95.271012' ,`PhotoCount` = '6' ,`PostalCode` = '77050' ,`RoomCount` = '4' ,`ListPrice` = '169000.00' ,`Status` = 'Active' ,`StreetName` = 'Tomahawk' ,`StreetNumber` = '8102' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property is drive-by only. No access. Two lots with home that needs work. Investors welcome or Make this your future dream home!' ,`Acres` = '0.3249' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 30 & 31 BLK 2 SHADOWLAKE ESTATES SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14152' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Shadowlake Estates Sec 01' ,`TaxAmount` = '2034' ,`TaxRate` = '1.8999' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663704445' WHERE `Matrix_Unique_ID` = '211934758' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:00:25.610' ,`MLSNumber` = '50509484' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.049374' ,`Longitude` = '-95.359236' ,`PhotoCount` = '15' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '304990.00' ,`Status` = 'Active' ,`StreetName` = 'Montague' ,`StreetNumber` = '23431' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2093' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Cypresswood Landing in Spring, TX! Conveniently located with easy access to Grand Parkway, I-45, FM 1960, and I-69 - commuting to the Energy Corridor, The Woodlands, or Bush Intercontinental Airport is a breeze! The Payton floor plan is a spacious 2-story home with 4 bedrooms, 2.5 baths, game room, and 2-car garage. This home has it all, including vinyl plank flooring and NO BACK NEIGHBORS! The first floor offers the perfect space for entertaining with a large galley-style kitchen open to both the living and dining areas! The gourmet kitchen is sure to please with 42\" white colored cabinetry, granite countertops, and stainless steel appliances! Retreat to the first-floor Owner\'s Suite featuring a separate tub and shower and walk-in closet! Enjoy the great outdoors with a covered patio! Don\'t miss your opportunity to call Cypresswood Landing home, schedule a visit today!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'LEGEND HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 36 BLK. 2 CYPRESSWOOD LANDING SEC. 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MILDRED JENKINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Landing' ,`TaxAmount` = '' ,`TaxRate` = '2.61' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704445' WHERE `Matrix_Unique_ID` = '211935111' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T12:24:36.723' ,`MLSNumber` = '43366481' ,`ListAgentFullName` = 'Alexis Pettway' ,`ListOfficeName` = 'Nextgen Real Estate Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.394787' ,`Longitude` = '-95.426117' ,`PhotoCount` = '27' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '1500000.00' ,`Status` = 'Active' ,`StreetName` = 'Pleasant Valley' ,`StreetNumber` = '13023' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property is located in a pristine part of town with GREAT ADVERTISING ABILITY! As it sits on spacious 1 acre right on the feeder of HWY 288 North. If you own or think about owning a business that needs great HWY advertising exposure, this place will be perfect for your company\'s industrial or commercial needs. This property may also be used for RESIDENTIAL and/or COMMERCIAL at the same time. Located on the feeder of HWY 288 allows for quick access to the city! Move-in ready! Enjoy a private driveway and some added privacy, since neighbors aren’t close by. This cozy home won’t disappoint! \r\n\r\nDon\'t wait this property won\'t last long!!!' ,`Acres` = '0.9' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'VALLEY VISTA ESTATES (A0235 H T & B R R) BLK 5 LOT 8' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Valley Vista Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704446' WHERE `Matrix_Unique_ID` = '211935799' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T13:45:47.850' ,`MLSNumber` = '24777340' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.399019' ,`Longitude` = '-95.689351' ,`PhotoCount` = '6' ,`PostalCode` = '77356' ,`RoomCount` = '8' ,`ListPrice` = '381093.00' ,`Status` = 'Active' ,`StreetName` = 'Little Dog' ,`StreetNumber` = '251' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1881' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the rolling hills of Montgomery! Beautiful 1 Story, The Lincoln Floor Plan with 3 Bedrooms, 2 Baths, with attached 2 Car Garage. SPACIOUS OPEN CONCEPT FLOOR PLAN and HIGH CEILINGS with the Family Room with Gas Log Fireplace, Kitchen, Breakfast Room, Dining Room, and 3 Bedrooms with 2 full Baths. You will love the Kitchen with lots of cabinets and granite countertops with under the cabinet lighting, stainless steel appliances, and even a USB outlet. Tile and Carpet throughout. Fenced backyard W/SPRINKLER SYSTEM. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Wifi Programmable Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. Amenities include Splash Pad and Playground. Convenient to TX-105, FM-2854, TX-249 and I-45 for local dining and entertainment and quick commutes to Conroe, The Woodlands, Magnolia, and Tomball.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S929900 - Town Creek Crossing 01, BLOCK 2, Lot 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7279' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Town Creek Crossing' ,`TaxAmount` = '' ,`TaxRate` = '2.9242' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704446' WHERE `Matrix_Unique_ID` = '211941126' --> Updated record success