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-04T15:47:47.070' ,`MLSNumber` = '82678894' ,`ListAgentFullName` = 'Angela Carter' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = 'Angela Carter' ,`SellingOfficeName` = 'NB Elite Realty' ,`Latitude` = '29.874897' ,`Longitude` = '-95.425080' ,`PhotoCount` = '6' ,`PostalCode` = '77088' ,`RoomCount` = '3' ,`ListPrice` = '169000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Marjorie' ,`StreetNumber` = '992' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1148' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The house was built in 1944 and need repairs. Sold As Is. NICE FIXER UP\r\nNICE CORNER LOT FOR INVESTORS House Recently Burned Sold As IS' ,`Acres` = '0.3223' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 180 & 181 BLK 9 LINCOLN CITY SEC 5' ,`LotDesciption` = 'Corner' ,`LotSize` = '14040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OSBORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Lincoln City Sec 05' ,`TaxAmount` = '2224' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1944' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694426' WHERE `Matrix_Unique_ID` = '200147584' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T15:52:13.743' ,`MLSNumber` = '97428367' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.456307' ,`Longitude` = '-95.472633' ,`PhotoCount` = '45' ,`PostalCode` = '77583' ,`RoomCount` = '12' ,`ListPrice` = '363990.00' ,`Status` = 'Active' ,`StreetName` = 'Cabin Loft' ,`StreetNumber` = '8818' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2387' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy peace and quiet in this beautiful Pride Builders home in Huntington Place. Nestled on an oversized lot, this 3-sided brick home features tile flooring, wrought iron spindles, and a covered patio. Master new recipes in the kitchen, complete with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. Relax in the tranquil primary suite boasting dual vanities, a 42” tub, and a separate shower. Amenities of Huntington Place include a community pool, recreation center, and abundant green spaces. Residents benefit from direct access to Hwy 288 and Hwy 6, making the drive to the Texas Medical Center a quick one. Numerous outdoor adventures and nature parks surround the area, along with a variety of shops and restaurants. This is your dream home – call now to learn more!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Pride Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '523' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntington Place' ,`TaxAmount` = '' ,`TaxRate` = '3.25' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694427' WHERE `Matrix_Unique_ID` = '203944687' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T15:16:06.430' ,`MLSNumber` = '76555275' ,`ListAgentFullName` = 'Misti Bruton' ,`ListOfficeName` = 'AVO Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.661063' ,`Longitude` = '-98.634924' ,`PhotoCount` = '36' ,`PostalCode` = '78255' ,`RoomCount` = '15' ,`ListPrice` = '1350000.00' ,`Status` = 'Active' ,`StreetName` = 'Cielo' ,`StreetNumber` = '23715' ,`StreetSuffix` = 'Vista' ,`City` = 'San Antonio' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5044' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous, fully remodeled two story home with TONS of upgrades in the Hill Country offering amazing panoramic views! Seller added approximately 1000 sqft when the remodel was done. Everything in this house comes in pair -- 2 primary suites, 2 en suite baths, 2 living rooms, 2 dining areas and 2 kitchens! An Elevator is also available. The best part? it\'s walking distance to shopping and restaurants. Schedule your showing today!' ,`Acres` = '3' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'NCB 34730 BLK LOT P-15 2.082 NCB 34732 BLK LOT P-27 .918 \"AR' ,`LotDesciption` = 'Other' ,`LotSize` = '130680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '247 - Northside (Bexar)' ,`SchoolElementary` = 'LEON SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRANDEIS HIGH SCHOOL' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (NORTHSIDE)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'unknown' ,`TaxAmount` = '18974' ,`TaxRate` = '2.5635' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694427' WHERE `Matrix_Unique_ID` = '207713555' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T14:46:36.710' ,`MLSNumber` = '11839062' ,`ListAgentFullName` = 'Tricia Turner' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.807950' ,`Longitude` = '-95.096438' ,`PhotoCount` = '38' ,`PostalCode` = '77360' ,`RoomCount` = '10' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakefront' ,`StreetNumber` = '591' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'VIEW VIEW VIEW - LAKEFRONT LIVING!! This beautifully updated 4 bed | 2 bath two story lakefront home is nestled on over half an ACRE (.528) on TWO cleared & wooded lots on a cul de sac street in the pristine piney woods of Onalaska! INCREDIBLE views of Lake Livingston in the community of Twin Harbors! High ceilings in the living room & vinyl plank wood-look floors flow throughout the downstairs. Primary bedroom w/ ensuite bath, 2 spacious secondary bedrooms & a second full bath located on the first floor. Second-floor game room & 4th bedroom + more stunning views! Kitchen boasts gorgeous quartz counters, custom backsplash, SS appliances, and grey cabinets w/ a corner 2-level lazy Susan to store non-perishables. Enjoy your morning coffee on the massive deck. Oversized 2-car detached garage is perfect for boat storage & fishing gear + 2 driveways for extra parking. Cleared side yard, great for your pets! Community amenities: boat launch, pier, swimming pool, tennis & basketball courts.' ,`Acres` = '0.528' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TWIN HARBORS SECTION 2 BLK 1 LOT 195 & 196' ,`LotDesciption` = 'Subdivision Lot,Water View,Wooded' ,`LotSize` = '22988' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Twin Harbors' ,`TaxAmount` = '4335' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694427' WHERE `Matrix_Unique_ID` = '207904261' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T15:22:33.113' ,`MLSNumber` = '61446029' ,`ListAgentFullName` = 'Gabriel Torre' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780429' ,`Longitude` = '-95.421004' ,`PhotoCount` = '28' ,`PostalCode` = '77007' ,`RoomCount` = '3' ,`ListPrice` = '570000.00' ,`Status` = 'Active' ,`StreetName` = 'Petty' ,`StreetNumber` = '5525' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2707' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A luxurious and large home full of charm & character with everything you could want including double master bedrooms with huge walk-in closets, two separate balconies, & it’s very own elevator. Perfect for anyone who has hip, knee, or back issues, or an older loved one to get up all four floors with ease & absolutely no stress. Property has just had brand new powder white granite countertops with grey vein streaks installed. Luxurious options include gorgeous, gleaming hardwood floors sprawling throughout this massive living space. Zoned Ac for separate control of multiple floors. Also comes complete with a projector & a screen that comes down from the ceiling. Has lots of large windows throughout, allowing tons of soft lights giving it a very cozy home feel. The location is impossible to beat, being less than five minutes to the Heights, Memorial Park, or Washington Avenue with all of its restaurants, bars, & lively nightlife. Only minutes from Downtown or the Galleria area.' ,`Acres` = '0.0445' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cottage Grove' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 HOMES AT PETTY STREET' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1938' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Homes/Petty Street' ,`TaxAmount` = '10243' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694427' WHERE `Matrix_Unique_ID` = '208106402' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T15:50:09.227' ,`MLSNumber` = '43246353' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.456344' ,`Longitude` = '-95.472633' ,`PhotoCount` = '6' ,`PostalCode` = '77583' ,`RoomCount` = '15' ,`ListPrice` = '420485.00' ,`Status` = 'Active' ,`StreetName` = 'Mallow Rose' ,`StreetNumber` = '8751' ,`StreetSuffix` = 'Way' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Enjoy the comforts of this stunning Lake Ridge Builders home in Huntington Place. Situated on a corner lot, this 3-sided brick home boasts a premium elevation, no back neighbors, tile flooring, wrought iron spindles, a study with French, full gutters, a sprinkler system, and a covered patio. Whip up meals for guests in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. Amenities of Huntington Place include a community pool, recreation center, and abundant green spaces. Residents benefit from direct access to Hwy 288 and Hwy 6, making the drive to the Texas Medical Center a quick one. Numerous outdoor adventures and nature parks surround the area, along with a variety of shops and restaurants. This is your dream home – call now to learn more!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '523' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntington Place' ,`TaxAmount` = '' ,`TaxRate` = '3.25' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694427' WHERE `Matrix_Unique_ID` = '208186099' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T15:49:34.003' ,`MLSNumber` = '65304987' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.456307' ,`Longitude` = '-95.472633' ,`PhotoCount` = '6' ,`PostalCode` = '77583' ,`RoomCount` = '11' ,`ListPrice` = '353990.00' ,`Status` = 'Active' ,`StreetName` = 'Cabin Loft' ,`StreetNumber` = '8811' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1826' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*This home is under construction.* Enjoy living in this beautiful Lake Ridge Builders in Huntington Place. Nestled on a spacious lot, this 3-sided brick home boasts high ceilings, wood-look tile flooring, faux wood blinds, full gutters, a sprinkler system, and a covered patio. Whip up meals for guests in the island kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. The spa-like primary suite features dual vanities, a 42” tub, and a separate shower. Amenities of Huntington Place include a community pool, recreation center, and abundant green spaces. Residents benefit from direct access to Hwy 288 and Hwy 6, making the drive to the Texas Medical Center a quick one. Numerous outdoor adventures and nature parks surround the area, along with a variety of shops and restaurants. This is your dream home – call now to learn more!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12 Block 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '523' ,`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` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntington Place' ,`TaxAmount` = '' ,`TaxRate` = '3.25' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694427' WHERE `Matrix_Unique_ID` = '208231613' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T15:00:07.840' ,`MLSNumber` = '13471685' ,`ListAgentFullName` = 'Lomil Truitt' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.685635' ,`Longitude` = '-95.736286' ,`PhotoCount` = '34' ,`PostalCode` = '77407' ,`RoomCount` = '7' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Parker Bend' ,`StreetNumber` = '20306' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3659' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate lake front home is ready you to move in! This Lennar Homes Stonewall Collection, \"Ashton\" in Grand Mission Estates has great curb appeal! The home catches your attention with it\'s stunning brick and stone elevation. This gently lived in 2 story 4/3.5/2 also features a study with french doors, dining room, game room, media room, open concept kitchen/living room, large island with seating, 42\" cabinets, under cabinet lighting, sparkling granite, large pantry, master suite, huge closet, his & her vanities, sprinkler system, covered patio, crown molding and soaring ceilings. Grand Mission Estates is conveniently located with quick access to major roadways and you can be downtown in a matter of minutes. Here you\'ll find everything you need...a warm sense of community, walking/hiking trails, clubhouse with fitness center, basketball court, soccer field, jr. olympic size pool complete with slide, splash park, & so much more!' ,`Acres` = '0.1936' ,`Area` = '37' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND MISSION ESTATES SEC 13, BLOCK 1, LOT 22' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '8433' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Mission Estates Sec 13' ,`TaxAmount` = '9830' ,`TaxRate` = '2.8397' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694427' WHERE `Matrix_Unique_ID` = '208444716' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T15:48:56.330' ,`MLSNumber` = '9987220' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.456307' ,`Longitude` = '-95.472633' ,`PhotoCount` = '8' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '342990.00' ,`Status` = 'Active' ,`StreetName` = 'Cabin Loft' ,`StreetNumber` = '8835' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*This home is under construction.* Settle into this charming Lake Ridge Builders home in Huntington Place. Resting on a spacious lot, this 3-sided brick home boasts tile flooring, faux wood blinds, full gutters, a sprinkler system, and a covered patio. Whip up meals for guests in the island kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. The serene primary suite features dual vanities, a 36” tub, and a separate shower. Amenities of Huntington Place include a community pool, recreation center, and abundant green spaces. Residents benefit from direct access to Hwy 288 and Hwy 6, making the drive to the Texas Medical Center a quick one. Numerous outdoor adventures and nature parks surround the area, along with a variety of shops and restaurants. This is your dream home – call today for more information!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '523' ,`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` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntington Place' ,`TaxAmount` = '' ,`TaxRate` = '3.25' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694427' WHERE `Matrix_Unique_ID` = '208609299' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T15:48:21.247' ,`MLSNumber` = '4550936' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.456307' ,`Longitude` = '-95.472633' ,`PhotoCount` = '8' ,`PostalCode` = '77583' ,`RoomCount` = '14' ,`ListPrice` = '434990.00' ,`Status` = 'Active' ,`StreetName` = 'Urban' ,`StreetNumber` = '623' ,`StreetSuffix` = 'Way' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2657' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*This home is under construction.* Seek comfort in this beautiful Lake Ridge Builders home in Huntington Place. Nestled on an oversized cul-de-sac lot, this 3-sided brick home boasts a premium elevation, open ceilings, tile flooring, wrought iron spindles, faux wood blinds, a study with French doors, full gutters, a sprinkler system, and a covered patio. Spend quality time in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. The tranquil primary suite features dual vanities, a 42” tub, and a separate shower. Amenities of Huntington Place include a community pool, recreation center, and abundant green spaces. Residents benefit from direct access to Hwy 288 and Hwy 6, making the drive to the Texas Medical Center a quick one. Numerous outdoor adventures and nature parks surround the area, along with a variety of shops and restaurants. This is your dream home – call now!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15 Block 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '523' ,`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` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntington Place' ,`TaxAmount` = '' ,`TaxRate` = '3.25' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694428' WHERE `Matrix_Unique_ID` = '208610029' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T15:44:22.013' ,`MLSNumber` = '33142017' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.882862' ,`Longitude` = '-95.142535' ,`PhotoCount` = '44' ,`PostalCode` = '77044' ,`RoomCount` = '14' ,`ListPrice` = '403990.00' ,`Status` = 'Active' ,`StreetName` = 'Statice' ,`StreetNumber` = '15407' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2786' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*This home is under construction.* This beautiful Lake Ridge Builders home in the desirable Sheldon Ridge community has it all. Nestled on a corner lot, this 3-sided brick home boasts a premium elevation, no back neighbors, open ceilings, front porch, wrought iron spindles, faux wood blinds, a study with French doors, a sprinkler system, and a covered patio. Whip up meals for guests in the kitchen, equipped with granite countertops, tile backsplash, and 42” upper cabinets. The serene primary suite features dual vanities, a 42” tub, and a separate shower. Popular restaurants and shopping centers are only a short distance away, among the area’s stunning nature parks. Bush Intercontinental Airport and Downtown Houston are easily accessible via Hwy 90. Schools are zoned to the recognized Sheldon ISD. Don’t wait – call now!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sheldon Ridge' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694428' WHERE `Matrix_Unique_ID` = '208767463' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T14:34:11.053' ,`MLSNumber` = '19830984' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Elridge Guillory' ,`SellingOfficeName` = 'Quest Real Estate' ,`Latitude` = '30.164414' ,`Longitude` = '-95.294069' ,`PhotoCount` = '15' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '296740.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Timbermill' ,`StreetNumber` = '18358' ,`StreetSuffix` = 'Lane' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING AND SPACIOUS! Fantastic floor plan!! With a grand living area incorporating the living, kitchen and semi-formal dining, a great place to spend time and relax! 4 bedrooms and 2 baths offer options for any size family. And a great primary suite secluded at the back of the home. Carrier 16 SEER air conditioning system, tankless water heater, built in home automation system controlled from a single app, great appliance package, and covered back patio included! Hurry and call TODAY!' ,`Acres` = '0.1395' ,`Area` = '40' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S812702 - PORTERS MILL 02, BLOCK 2, LOT 31' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6077' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Porters Mill 02' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694428' WHERE `Matrix_Unique_ID` = '209476473' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T14:18:34.427' ,`MLSNumber` = '50134424' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Sorita Alexander' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '30.157703' ,`Longitude` = '-95.612294' ,`PhotoCount` = '14' ,`PostalCode` = '77354' ,`RoomCount` = '3' ,`ListPrice` = '298740.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Lavender Lane' ,`StreetNumber` = '10002' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1617' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect brand NEW DR Horton Home!! Excellent location in Montgomery County! Lovely 1 story floor plan with designer details at every corner! Modern finishes and open living spaces! Beautiful island kitchen with granite countertops and white cabinetry! Nice primary bedroom suite with spa like bath! Includes a useful covered patio and landscape package! Hurry and call TODAY!!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21 Block 5 Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Enclave at Dobbin' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694428' WHERE `Matrix_Unique_ID` = '209953322' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T14:22:05.830' ,`MLSNumber` = '75049820' ,`ListAgentFullName` = 'Teresa Neveu' ,`ListOfficeName` = 'Southern Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.231345' ,`Longitude` = '-95.283231' ,`PhotoCount` = '20' ,`PostalCode` = '77306' ,`RoomCount` = '6' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Beeson' ,`StreetNumber` = '18693' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Plenty of UNRESTRICTED Space on this Wonderful Country Living 4-acre property. Four acres with lots of potential. Very Spacious private corner lot located at the end of the street with plenty of room to grow. There is also a huge 3 garage bay, 41\'x25\' shop with lift, which would be great for an auto shop, storage or barn. The home is a 4 bedroom 2 full baths and another full bath under construction. The huge family room is open to the large kitchen. The square footage for the added 4th bedroom and the unfinished full bath has not been calculated in the Appraisal square footage. The added bedroom, closet and extra bath have not been calculated to reflect the total square footage of the property. Room sizes are approximate, buyers please verify. Come out and see this home today.' ,`Acres` = '4' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0303 - KIBBE WM, TRACT 12, SERIAL # TXFL586A06689GH11, LABE' ,`LotDesciption` = 'Corner,Wooded' ,`LotSize` = '174240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'MILAM ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Abstract Area' ,`TaxAmount` = '1422' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694428' WHERE `Matrix_Unique_ID` = '210323135' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T15:44:17.817' ,`MLSNumber` = '80664803' ,`ListAgentFullName` = 'Emily Dieckmann' ,`ListOfficeName` = 'Keller Williams Realty C. P.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.455640' ,`Longitude` = '-97.961924' ,`PhotoCount` = '40' ,`PostalCode` = '78645' ,`RoomCount` = '6' ,`ListPrice` = '1499000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunset Ridge' ,`StreetNumber` = '6905' ,`StreetSuffix` = 'Way' ,`City` = 'Jonestown' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4118' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Semi Custom, highly upgraded home on almost 1 acre. Peek a boo views of Lake Travis & lush green hill country to enjoy. TESLA SOLAR &POWER WALLS make this a rare find & super energy efficient. Upgrades: automatic & motorized shades, accent walls like shiplap provide a modern feel, custom drapery in master & main living spaces, custom staircase railing, all light fixtures have been hand picked for each space as well as matching hardware throughout the home, & fenced back yard. Award winning layout boasts 3 car garage, 2 primary bedrooms + 2 other secondary bedrooms, office/5th bedroom, game room, media room, 2 fireplaces, 2 eating spaces, butlers pantry & MORE! Amenities are endless in the Hollows: miles of hiking and biking trails, a beach club, resort style pool and restaurant that overlooks the lake, boat launch area, kayak club, live music, neighborhood events, a brand new amenity center within walking distance of the home. Come see what Austin living is like on Lake Travis!' ,`Acres` = '0.8249' ,`Area` = '83' ,`BuilderName` = 'Coventry' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Solar Assisted' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 11 BLK B HOLLOWS PHS II-C THE' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Wooded' ,`LotSize` = '35933' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '540' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '114 - Lago Vista' ,`SchoolElementary` = 'LAGO VISTA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAGO VISTA HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Hollows Ph 2c The' ,`TaxAmount` = '18822' ,`TaxRate` = '2.39' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663694428' WHERE `Matrix_Unique_ID` = '210344027' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T15:20:05.760' ,`MLSNumber` = '85845605' ,`ListAgentFullName` = 'Kevin Torres' ,`ListOfficeName` = 'Realty Executives Torres Team' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.466680' ,`Longitude` = '-95.568435' ,`PhotoCount` = '50' ,`PostalCode` = '77318' ,`RoomCount` = '7' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Carmel' ,`StreetNumber` = '15485' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss out on this RARE opportunity to own a New Modern Farmhouse with 3 bedrooms, 2 bathrooms PLUS Study, in Lake Conroe\'s Corinthian Point Subdivision! This open concept beauty has all of the latest design features & finishes. A magazine worthy front elevation with white painted brick accenting the classic board & batten, black frame windows, dark trim & stained-wood columns highlighting the unique front porch. Inside, you will find high ceilings thru-out, gourmet kitchen with quartz countertops, huge island, gas cooktop (propane on-site) & elegant lighting / plumbing fixtures . Flooring includes a combination of luxury vinyl plank in the common areas + study, tile in the bathrooms and plush carpeting in the bedrooms/closets. Community amenities include: lake access, boat launch, fishing pier, green space, clubhouse, pool, tennis & basketball courts! All of this with easy access to Conroe & The Woodlands. *Uploaded photos are representative of plan-only & not of the actual home.' ,`Acres` = '0.209' ,`Area` = '39' ,`BuilderName` = 'SPI' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CORINTHIAN POINT 02, BLOCK 11, LOT 171' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9056' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '81' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Corinthian Point' ,`TaxAmount` = '' ,`TaxRate` = '2.2463' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694428' WHERE `Matrix_Unique_ID` = '210660390' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T14:23:56.230' ,`MLSNumber` = '9105263' ,`ListAgentFullName` = 'Scott Laird' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.349433' ,`Longitude` = '-95.534848' ,`PhotoCount` = '26' ,`PostalCode` = '77304' ,`RoomCount` = '5' ,`ListPrice` = '360685.00' ,`Status` = 'Active' ,`StreetName` = 'Newcomb Hollow' ,`StreetNumber` = '531' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME home to Hills of Westlake located just minutes from Lake Conroe and zoned to CONROE ISD. Enjoy easy access to I-45 and a quick commute to lots of great shopping and dining. Community offers a large community pool and playground. THIS NEW 4 bed, 2.5 bath home is loaded with LUXURY features -- GRANITE ISLAND, stainless steel appliances, breakfast bar, and 42\" modern cabinetry. Kitchen open to living/dining with open views to your backyard space. Smart home package, & solid surface flooring throughout. Spacious guest rooms and a HUGE primary retreat w/ dual vanities, large walk-in closet, frameless shower, and separate tub. Relaxing backyard featuring covered back patio!!! MAKE THE MOVE!!!' ,`Acres` = '0.1386' ,`Area` = '19' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S582102 - HILLS OF WESTLAKE 02, BLOCK 1, LOT 31' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6039' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hills Of Westlake' ,`TaxAmount` = '1297' ,`TaxRate` = '2.98' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694429' WHERE `Matrix_Unique_ID` = '210688521' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T14:23:24.907' ,`MLSNumber` = '80047657' ,`ListAgentFullName` = 'Scott Laird' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.349883' ,`Longitude` = '-95.535043' ,`PhotoCount` = '28' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '363485.00' ,`Status` = 'Active' ,`StreetName` = 'Newcomb Hollow' ,`StreetNumber` = '532' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2271' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME home to Hills of Westlake located just minutes from Lake Conroe and zoned to CONROE ISD. Enjoy easy access to I-45 and a quick commute to lots of great shopping and dining. Community offers a large community pool and playground. THIS NEW 4 bed, 3 bath home is loaded with LUXURY features -- GRANITE ISLAND, stainless steel appliances, breakfast bar, and 42\" modern cabinetry. Kitchen open to living/dining with open views to your backyard space. Study, Smart home package, & solid surface flooring throughout. Spacious guest rooms and a HUGE primary retreat w/ dual vanities, large walk-in closet, frameless shower, and separate tub. Relaxing backyard featuring covered back patio!!! MAKE THE MOVE!!!' ,`Acres` = '0.146' ,`Area` = '19' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S582102 - Hills Of Westlake 02, BLOCK 1, Lot 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hills Of Westlake' ,`TaxAmount` = '1297' ,`TaxRate` = '2.98' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694429' WHERE `Matrix_Unique_ID` = '210689354' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T14:23:12.410' ,`MLSNumber` = '47021231' ,`ListAgentFullName` = 'Scott Laird' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.349395' ,`Longitude` = '-95.535000' ,`PhotoCount` = '24' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '346135.00' ,`Status` = 'Active' ,`StreetName` = 'Newcomb Hollow' ,`StreetNumber` = '535' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2060' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME home to Hills of Westlake located just minutes from Lake Conroe and zoned to CONROE ISD. Enjoy easy access to I-45 and a quick commute to lots of great shopping and dining. Community offers a large community pool and playground. THIS NEW 4 bed, 3 bath home is loaded with LUXURY features -- GRANITE ISLAND, stainless steel appliances, breakfast bar, and 42\" modern cabinetry. Dining room off kitchen, open family room, Smart home package, & solid surface flooring throughout. Spacious guest rooms and a HUGE primary retreat w/ dual vanities, large walk-in closet, frameless shower, and separate tub. Relaxing backyard featuring covered back patio!!! MAKE THE MOVE!!!' ,`Acres` = '0.137' ,`Area` = '19' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S582102 - Hills Of Westlake 02, BLOCK 1, Lot 32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6011' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hills Of Westlake' ,`TaxAmount` = '1297' ,`TaxRate` = '2.98' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694429' WHERE `Matrix_Unique_ID` = '210689813' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T14:54:15.807' ,`MLSNumber` = '39061068' ,`ListAgentFullName` = 'Naila Duran' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.126955' ,`Longitude` = '-95.290160' ,`PhotoCount` = '8' ,`PostalCode` = '77365' ,`RoomCount` = '10' ,`ListPrice` = '702905.00' ,`Status` = 'Active' ,`StreetName` = 'Nasas' ,`StreetNumber` = '19482' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2869' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remarkable new construction retreat encompassing 1 acre in scale situated in the prestigious Riverwalk subdivision. Brixton Development has created another spectacular modern design incorporating stylish surfaces and a gracious floor plan featuring plenty of natural light flow enabling effortless indoor/outdoor living to maximize use of the serene setting. Gourmet waterfall quartz Island Kitchen with all the modern finishes to surpass your expectations. Oversized primary suite with a luxurious bath and extravagant walk in shower. Generous secondary bedrooms with walk in closets of their own. Covered outdoor patio with endless possibilities. Schedule a tour today to see this stunning new home!' ,`Acres` = '1' ,`Area` = '40' ,`BuilderName` = 'Brixton Development' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERWALK 05, BLOCK 5, LOT 19, ACRES 1.000' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'SORTERS MILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Riverwalk 05' ,`TaxAmount` = '1173' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694429' WHERE `Matrix_Unique_ID` = '210719271' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T14:09:48.300' ,`MLSNumber` = '27131932' ,`ListAgentFullName` = 'Rachel Anderson' ,`ListOfficeName` = 'Rachel Anderson Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.729640' ,`Longitude` = '-96.187995' ,`PhotoCount` = '27' ,`PostalCode` = '75840' ,`RoomCount` = '8' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 1260' ,`StreetNumber` = '103' ,`StreetSuffix` = '' ,`City` = 'Fairfield' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very versatile story & half home on over half an acre! Zoned climate control & great arrangement of living space keeps everyone comfortable! A high ceiling & stunning rock fireplace make a memorable first impression as you enter to an open floor plan of the living, kitchen, & dining rooms. The spiral staircase leads to a loft bedroom with ensuite bath. Bedrms 2 & 3 are downstairs & share a hall bath with a tub & shower. You’ll enjoy the updated granite kitchen with huge walk-in pantry & the appliances are included. Just beyond the dining area through French doors is the massive den. Nice natural light & high ceiling with plenty of space for large furniture & even a pool table. Add\'l space in the loft for a playrm or office! Side door to open deck & huge privacy fenced back yard. Laundry room connects to a half bath & a big storage closet. Add’l storage in the shed that opens to the backyard. Plenty of covered parking under the double car attached carpt & 1 car gar.' ,`Acres` = '0.62' ,`Area` = '74' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Freestone County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WESTWOOD- I H REED A-23 TRACT 65' ,`LotDesciption` = 'Cleared' ,`LotSize` = '27007' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '226 - Fairfield' ,`SchoolElementary` = 'FAIRFIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FAIRFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRFIELD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Reed Surv' ,`TaxAmount` = '2189' ,`TaxRate` = '1.7349' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694429' WHERE `Matrix_Unique_ID` = '210898701' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T15:07:57.917' ,`MLSNumber` = '97703484' ,`ListAgentFullName` = 'Ari Spahiu' ,`ListOfficeName` = 'Texas Advantage Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.256114' ,`Longitude` = '-95.530521' ,`PhotoCount` = '20' ,`PostalCode` = '77384' ,`RoomCount` = '7' ,`ListPrice` = '427000.00' ,`Status` = 'Active' ,`StreetName` = 'Wonder Lake' ,`StreetNumber` = '14234' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2565' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Brick Exterior! Versatile Interior Layout with GAMEROOM & HOME OFFICE/STUDY/5th BDRM! Features: Quartz Counters, Stainless Steel Appliances with Gas Cooktop, & 36\" White Kitchen Cabinetry! Smart Home Package, Solid Surface Flooring, Tankless Water Heater, Covered Patio, & Sprinkler System! Outstanding Design - Home Office/Study/5th Bdrm with Walk-In Closet & Adjoining Half Bath, Privately Located First Floor Primary Suite with Walk-In Closet & Posh Bath, Gourmet Island Kitchen, Open Living & Dining Area, & Enormous Gameroom/Media Room Upstairs! Great Community with Pool, Playground, & Community Center! Conroe ISD/The Woodlands Schools!' ,`Acres` = '0.1442' ,`Area` = '15' ,`BuilderName` = 'Dr Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S516492 - FOSTERS RIDGE 20A, BLOCK 3, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fosters Ridge 20a' ,`TaxAmount` = '457' ,`TaxRate` = '3.1488' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694429' WHERE `Matrix_Unique_ID` = '211036979' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T15:06:44.660' ,`MLSNumber` = '33755391' ,`ListAgentFullName` = 'Kyle Pryor' ,`ListOfficeName` = 'Pryor Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.394691' ,`Longitude` = '-95.686003' ,`PhotoCount` = '7' ,`PostalCode` = '77356' ,`RoomCount` = '5' ,`ListPrice` = '439000.00' ,`Status` = 'Active' ,`StreetName` = 'Abner Lane' ,`StreetNumber` = '206' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2258' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New home on large corner lot with big back yard and covered back porch. 2 1/2 car garage, study, 4 bedroom & game room and 2 1/2 bath. Ceramic tile all downstairs except for master bedroom & closet. Kitchen has a large island and is open to the family room. Master bedroom very large and has a bay window. Sprinkler system, grassed yard, ceiling fans, window blinds, garage door opener, stainless appliances included. Ready for move in September 2022.' ,`Acres` = '0.3082' ,`Area` = '39' ,`BuilderName` = 'Camillo Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S456900 - ESTATES OF LAKE CREEK VILLAGE, BLOCK 1, LOT 11' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '13426' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`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` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates Of Lake Creek Village' ,`TaxAmount` = '1262' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694429' WHERE `Matrix_Unique_ID` = '211042290' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T14:20:52.730' ,`MLSNumber` = '25468636' ,`ListAgentFullName` = 'Ronaldo Perez' ,`ListOfficeName` = 'Executive Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.661129' ,`Longitude` = '-95.034685' ,`PhotoCount` = '5' ,`PostalCode` = '77571' ,`RoomCount` = '3' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = '15th' ,`StreetNumber` = '407' ,`StreetSuffix` = 'Street' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2192' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful modern new construction home in La Porte! This 3 bedroom 2 and a half baths open floor concept with high ceilings will not disappoint. Home is energy efficient with amazing custom kitchen cabinets and quartz countertops. Enjoy the backyard patio with family and friends. Did I mention no HOA! Call your favorite realtor today and schedule a tour.' ,`Acres` = '0.1435' ,`Area` = '7' ,`BuilderName` = 'Juan' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 5 & 6 BLK 790 LA PORTE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LA PORTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'La Porte' ,`TaxAmount` = '733' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694430' WHERE `Matrix_Unique_ID` = '211053160' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T15:18:16.017' ,`MLSNumber` = '83402597' ,`ListAgentFullName` = 'Kyle Pryor' ,`ListOfficeName` = 'Pryor Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.395084' ,`Longitude` = '-95.686348' ,`PhotoCount` = '7' ,`PostalCode` = '77356' ,`RoomCount` = '5' ,`ListPrice` = '509000.00' ,`Status` = 'Active' ,`StreetName` = 'Abner' ,`StreetNumber` = '207' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2686' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique 1 1/2 story floor plan. Primary bedroom down & a primary bedroom upstairs that could be used as another primary bedroom. The upstairs has a room, full bath & living area/game room. Upstairs is a private area not open to the down stairs so has plenty of privacy. 4 bedrooms with 2 living areas, 3 full baths, 2 1/2 car garage. Large corner lot. Ready for move in October 2022.' ,`Acres` = '0.2848' ,`Area` = '39' ,`BuilderName` = 'Camillo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S456900 - ESTATES OF LAKE CREEK VILLAGE, BLOCK 1, LOT 10' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '12406' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric 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` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates Of Lake Creek Village' ,`TaxAmount` = '1166' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694430' WHERE `Matrix_Unique_ID` = '211054493' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T14:55:18.110' ,`MLSNumber` = '10819516' ,`ListAgentFullName` = 'Tuyet Nguyen' ,`ListOfficeName` = 'T & T Real Estate Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.001332' ,`Longitude` = '-95.499693' ,`PhotoCount` = '20' ,`PostalCode` = '77068' ,`RoomCount` = '10' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Brightwood' ,`StreetNumber` = '4027' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2506' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 4027 Brightwood Dr. Beautiful 4 BR and 2.5 bath located established neighborhood located in Olde Oaks. Wood laminate in the formal dining and living area on the first floor and carpet upstairs. Spacious master bedroom with dual vanities, separate tub and shower, and walk-in closet. Furthermore, the backyard is a good size, perfect for outdoor gatherings on the weekend. Updated double pane windows in 2007, new roof June 2022, water softener, extended enclosed sunroom with additional kitchen in 2007. The location is convenient to schools, FM 1960, shopping centers, grocery stores, and restaurants. Washer/dryer included.' ,`Acres` = '0.1858' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 4 OLDE OAKS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8094' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '445' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Olde Oaks Sec 02' ,`TaxAmount` = '4174' ,`TaxRate` = '2.4592' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694430' WHERE `Matrix_Unique_ID` = '211056361' --> Updated record success