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-10T11:10:38.913' ,`MLSNumber` = '24835657' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Andrew Codia' ,`SellingOfficeName` = 'Ameri Choice Realty, LLC' ,`Latitude` = '29.477371' ,`Longitude` = '-95.375750' ,`PhotoCount` = '15' ,`PostalCode` = '77578' ,`RoomCount` = '13' ,`ListPrice` = '449698.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Lynnwood Crest' ,`StreetNumber` = '18923' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2566' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Escape the city to this charming Beazer Home in Bluewater Lakes, boasting a brick façade, tile flooring, 3-car garage, wrought iron spindles, a study with French doors, an open great room, and an extended covered patio. Whip up meals for guests in the kitchen, equipped with quartz countertops, mosaic backsplash, large cove molding, stainless steel appliances, 42” upper cabinets, pendant lighting, and under-counter lighting. The serene primary suite features a walk-in closet, dual vanities, and a mud set shower. Located off Highway 288, residents enjoy easy access to Downtown Houston and the Medical Center. Bluewater Lakes’ amenities include a pool and a playground. Schools in the area are zoned to the top-rated Alvin ISD. This could be your dream home – call now!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 2' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bluewater Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.76904' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696630' WHERE `Matrix_Unique_ID` = '204268085' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T11:04:21.453' ,`MLSNumber` = '81812066' ,`ListAgentFullName` = 'Americo Mendez' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.569145' ,`Longitude` = '-95.378755' ,`PhotoCount` = '28' ,`PostalCode` = '77584' ,`RoomCount` = '4' ,`ListPrice` = '455000.00' ,`Status` = 'Active' ,`StreetName` = 'Appian' ,`StreetNumber` = '2304' ,`StreetSuffix` = 'Way' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction in the highly desirable and established Autumn Lakes Subdivision of Pearland. Immediate access to SH 288 and surrounded by Pearland\'s newer retail developments. Zoned to highly rated Pearland school district. Home features energy efficient roof, windows, insulation, windstorm grade construction, dual 2 ton AC units, both electric and gas connections for range, oven, washer and dryer and HVAC. Home will also feature a unique PET ROOM complete with pet shower and closet. All permits comply to custom construction standards of the city of Pearland. NOTE: At this stage in the build , buyer\'s can have some input into standard colors and finishes.' ,`Acres` = '0.1736' ,`Area` = '5' ,`BuilderName` = 'Botero Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AUTUMN LAKE SEC 2 (A0304 HT&BRR) , PEARLAND, BLOCK 1, LOT 18' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7562' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'CHALLENGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Autumn Lake Sec 1-2-3' ,`TaxAmount` = '753' ,`TaxRate` = '2.8451' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696631' WHERE `Matrix_Unique_ID` = '206011675' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T11:59:17.010' ,`MLSNumber` = '58862258' ,`ListAgentFullName` = 'Larry Cain' ,`ListOfficeName` = 'Crystal Beach Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472934' ,`Longitude` = '-94.592896' ,`PhotoCount` = '31' ,`PostalCode` = '77650' ,`RoomCount` = '6' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Cove' ,`StreetNumber` = '944' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1552' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous 3/2 with additional living space downstairs, including a full kitchen and dining area. Bonus room in attic. Easy beach access directly down Cove Street, with peek-a-boo beach view from deck. Over-sized garage area with loft storage. Sits on two lots and has its own septic system. Walk-around deck and plenty of covered deck for relaxing. Covered stairs and cargo lift for easy access. Never a rental, but would make a great rental or personal use. Close to the Big Store and Stingaree Restaurant. Sells fully furnished except for personal items, golf cart and trailer, and other items in closets and garage. Meticulous owner since 2014 has kept everything in great condition. Fresh exterior paint, new dishwasher, new HVAC in 2019, new roof in 2018, cargo lift installed in 2017. Don\'t miss seeing this one!' ,`Acres` = '0.2066' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOTS 17 & 19 BLK 7 GATEWAY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gateway' ,`TaxAmount` = '5498' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696631' WHERE `Matrix_Unique_ID` = '207910673' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T11:02:32.180' ,`MLSNumber` = '73351549' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Jenine Cinco' ,`SellingOfficeName` = 'Kay Stimson Properties , LLC' ,`Latitude` = '30.067562' ,`Longitude` = '-95.723424' ,`PhotoCount` = '16' ,`PostalCode` = '77377' ,`RoomCount` = '8' ,`ListPrice` = '369913.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Palfrey Prairie' ,`StreetNumber` = '19422' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*home is under construction.* Stunning Beazer Home in the desirable community of Amira, boasting a brick façade, sloped ceilings, luxury vinyl plank flooring, sprinkler system, extended entry, open great room, and a covered patio. Prepare incredible feasts in the kitchen, equipped with quartz countertops, mosaic backsplash, large cove molding, stainless steel appliances, 42” upper cabinets, pendant lighting, and under-counter lighting. The tranquil primary suite features a walk-in closet, dual vanities, a tub, and a separate shower. With the community situated so close to the Grand Parkway and Hwy 249, residents are only minutes away from a variety of dining and shopping options. Amira amenities include an infinity-edge pool, dog park, and gym. Nearby schools are zoned to the top-rated Tomball ISD. Arrange your private showing today!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`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` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696631' WHERE `Matrix_Unique_ID` = '208832765' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T11:09:43.083' ,`MLSNumber` = '65401632' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806975' ,`Longitude` = '-95.837842' ,`PhotoCount` = '5' ,`PostalCode` = '77493' ,`RoomCount` = '15' ,`ListPrice` = '649591.00' ,`Status` = 'Active' ,`StreetName` = 'Eden Terrace' ,`StreetNumber` = '6615' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3757' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Rowan XL, Elevation A) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, informal dining room and study. Spacious island kitchen open to family room. Primary suite with large walk-in closet and secondary bedroom on first floor. Two additional bedrooms, spacious game room and media room on second floor. Covered patio and attached 2-car garage. Located in the heart of Katy and minutes from the Grand Parkway and I-10, the Falls at Green Meadows is Katy’s premiere Community! Residents of the Falls at Green Meadows can enjoy the Community Recreation Center that features a crystal-blue pool and outdoor patio area. Other amenities include sparkling lakes, meandering walking trails, and a playground. Stop by the Westin Homes model home today to find out more about the Falls at Green Meadows!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 10 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10482' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KATY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falls at Green Meadows' ,`TaxAmount` = '' ,`TaxRate` = '3.48' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696631' WHERE `Matrix_Unique_ID` = '208900549' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T10:51:33.427' ,`MLSNumber` = '46476280' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Destiny Gallion' ,`SellingOfficeName` = 'Main Properties' ,`Latitude` = '29.659700' ,`Longitude` = '-95.049500' ,`PhotoCount` = '20' ,`PostalCode` = '77571' ,`RoomCount` = '11' ,`ListPrice` = '549634.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Shore Hill' ,`StreetNumber` = '102' ,`StreetSuffix` = 'Circle' ,`City` = 'La Porte' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2817' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction** Enjoy your own slice of paradise in this charming Beazer former model home in Morgan’s Landing, boasting a brick façade, tile flooring, stone fireplace, a game room, a study with French doors, an open great room, and an extended covered patio. Cook up new cuisines in the kitchen, equipped with granite countertops, mosaic backsplash, 36” 5-burner gas cooktop, double wall oven, stainless steel appliances, 42” upper cabinets, and under-counter LED lighting. Seek comfort in the primary suite, featuring a walk-in closet, dual vanities, and a mud set shower. Located in La Porte, this community gives residents easy access to Kemah, the Houston Ship Channel, and Bay Area. Clear Lake and the Johnson Space Center are just minutes away! Morgan’s Landing’s amenities include a dog park, resort-style pool, pocket parks, lakes, and walking trails. Schools are zoned to La Porte ISD. Arrange your private showing today!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LOMAX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgan\'s Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.543251' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696631' WHERE `Matrix_Unique_ID` = '208984074' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T11:43:04.050' ,`MLSNumber` = '61419344' ,`ListAgentFullName` = 'Cynthia Block' ,`ListOfficeName` = 'CB&A, Realtors- Loop Central' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.657422' ,`Longitude` = '-95.520277' ,`PhotoCount` = '40' ,`PostalCode` = '77071' ,`RoomCount` = '5' ,`ListPrice` = '549900.00' ,`Status` = 'Active' ,`StreetName` = 'Albin' ,`StreetNumber` = '8027' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5172' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home!! Elegant, move-in ready, naturally lit home, wows as you walk in the door. This 5 bedroom, 4.5 bathroom home is set up for entertaining. The large eat-in kitchen abuts upon a family room with full bar and sun room and has ample storage, as well as, a butlers pantry adjacent to the large dining room. Large primary bedroom with en suite, boasts two closets, steam shower, jacuzzi, double sink, and entry to private office. The upstairs bedrooms have 2 jack and jill bathrooms, with each room having their own vanity, two finished lofts and two balconies. The separate laundry room with 4th bathroom is large and flexible enough to portion off into an additional bonus room. The sunroom looks over a large inviting pool and a separate powder room all contribute to making this house a must see.' ,`Acres` = '0.2112' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 & TR 2A BLK 7 FONDREN SW NORTHFIELD SEC 4' ,`LotDesciption` = 'Corner' ,`LotSize` = '9200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MILNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fondren Sw Northfield Sec 04' ,`TaxAmount` = '8140' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696631' WHERE `Matrix_Unique_ID` = '209342595' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T10:15:57.960' ,`MLSNumber` = '31027717' ,`ListAgentFullName` = 'Melissa Shechter' ,`ListOfficeName` = 'Ironwood Realty' ,`SellingAgentFullName` = 'Kevin King' ,`SellingOfficeName` = 'RE/MAX ONE - Premier' ,`Latitude` = '29.779179' ,`Longitude` = '-94.957066' ,`PhotoCount` = '20' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '375000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cedar Bayou Lynchburg' ,`StreetNumber` = '706' ,`StreetSuffix` = 'Road' ,`City` = 'Baytown' ,`BathsFull` = '0' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '2528' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated property with 2.19 acres. Property was rehabbed for commercial lease space but could be converted back to residential if buyer preferred. 3 bedrooms, 2 half baths, huge family room. Huge den with stone fireplace divided with beautiful, accented glass doors. Kitchen has new granite, SS appliances, and new cabinets. Fresh updated accents throughout home with colors, baseboards, trim and lighting. Lots of natural light with mature trees. Metal roof. Circle driveway in front of covered porch. Long driveway on side leading to the back of the house to 2 car garage. Property on Well and Septic with tons of space to add your own garden, green house, or building. Options are endless. Come tour this gorgeous property today.' ,`Acres` = '2.192' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 10B (PR YR LAND 2012-2016*0450130050219) ABST 709 J W SIN' ,`LotDesciption` = 'Corner' ,`LotSize` = '95484' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'J W Singleton' ,`TaxAmount` = '10395' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696631' WHERE `Matrix_Unique_ID` = '209718047' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T10:23:24.247' ,`MLSNumber` = '22897526' ,`ListAgentFullName` = 'Brian McCulley' ,`ListOfficeName` = 'Beck & Bond Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804898' ,`Longitude` = '-95.532314' ,`PhotoCount` = '11' ,`PostalCode` = '77080' ,`RoomCount` = '8' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Parana' ,`StreetNumber` = '1805' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2317' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled on a HUGE 12,240 sq.ft. lot shaded by huge mature oak trees in popular Pine Village, this 4/2 offers tons of potential for renovations or new construction. House has never flooded.' ,`Acres` = '0.281' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 58 LESS S 5 FT BLK 6 PINE VILLAGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'PINE SHADOWS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Village Sec 02' ,`TaxAmount` = '7144' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696632' WHERE `Matrix_Unique_ID` = '209845508' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T10:04:36.570' ,`MLSNumber` = '17157400' ,`ListAgentFullName` = 'Carla Rae Southard' ,`ListOfficeName` = 'The Virtual Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.799146' ,`Longitude` = '-95.658968' ,`PhotoCount` = '32' ,`PostalCode` = '77414' ,`RoomCount` = '4' ,`ListPrice` = '329862.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 297' ,`StreetNumber` = '1916' ,`StreetSuffix` = '' ,`City` = 'Sargent' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '878' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REDUCED!!!!! Your dream home is right here on Caney Creek!!Recently remodeled and fresh interior and exterior paint, This home has so many unique features....Let\'s start inside! This home is 2 Bedrooms one bath and the interior is amazing!! Custom Cabinetry, Granite Counter tops and windowsills, new flooring, new Ductless HVAC system, Vinyl Windows, ALL NEW STAINLESS Appliances and a totally Spa like bathroom!! Now let\'s talk about the outside!! This lot is totally bulkheaded, and the most amazing covered outdoor kitchen area in town! Wired and ready for you to customize, this is where all the fun will be for family and friends!!! The breezy shady front Porch is made for some Rocking Chairs or even a hammock! This one is ready to start enjoying Sargent Life!!!! Neighborhood Boat ramps, Bait Camps and Sargent Beach Minutes away!!' ,`Acres` = '0.432' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'CANEY CREEK ESTATES SEC 1, LOT 122' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '18818' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '60' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '134 - Van Vleck' ,`SchoolElementary` = 'VAN VLECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VAN VLECK HIGH SCHOOL' ,`SchoolMiddle` = 'O H HERMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Caney Creek Estates Sec 1' ,`TaxAmount` = '3637' ,`TaxRate` = '2.3895' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663696632' WHERE `Matrix_Unique_ID` = '210470884' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T10:31:42.463' ,`MLSNumber` = '78507302' ,`ListAgentFullName` = 'Daniel Stringer' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795218' ,`Longitude` = '-95.417400' ,`PhotoCount` = '25' ,`PostalCode` = '77008' ,`RoomCount` = '11' ,`ListPrice` = '1590000.00' ,`Status` = 'Active' ,`StreetName` = '14th' ,`StreetNumber` = '1906' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Introducing a treasure, a new construction Lowcountry plantation style home with modern touches coming to the Greater Heights. 1906B W 14 will command attention with its three levels, boasting over 4500 sqft, 5 bedrooms and 5 ¾ baths. The main floor family room and kitchen spans the rear of the home and opens to the outdoors at the screened porch. This level hosts a chef’s kitchen with walk-in pantry, butler’s pantry, breakfast room, office / 4th bedroom, dining room / bar, mud room, elevator closet and 1 ¾ baths. The second floor has a spacious primary suite with a well-appointed ensuite bath and walk-in closets. Two additional bedrooms with ensuite baths, a large rear hall/flex space and laundry room will grace this level. The third floor and overlook will provide 360-degree views, and 1000 sqft of unfinished flex space. The carriage house over the garage will include a kitchenette and full bath. A private retreat designed with entertaining in mind. LOT ALSO FOR SALE. CONTACT AGENT.' ,`Acres` = '0.2129' ,`Area` = '9' ,`BuilderName` = 'DTS Landholdings' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 SIGALA PINES and TR 4B-1 BLK 3 CLARK PINES' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '9275' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Clark Pines' ,`TaxAmount` = '' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663696632' WHERE `Matrix_Unique_ID` = '210588226' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T10:57:21.543' ,`MLSNumber` = '15236181' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Kenya Fanus' ,`SellingOfficeName` = 'Elite 5 Star Realty' ,`Latitude` = '29.852627' ,`Longitude` = '-95.817988' ,`PhotoCount` = '11' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '329429.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Marisol Sunsets' ,`StreetNumber` = '25603' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Settle into this lovely Beazer Home in Marisol, boasting tile flooring, faux wood blinds, an open great room, and an extended covered patio. Create new recipes in the kitchen, equipped with quartz countertops, stainless steel appliances, and 42” upper cabinets. The spa-like primary suite features a walk-in closet, dual vanities, and a shower. Residents of Marisol enjoy easy access to a variety of popular shopping and dining spots at the nearby Katy Mills Mall and LaCenterra at Cinco Ranch. Commuters love the easy drive to Downtown Houston and the Energy Corridor via I-10 and the Grand Parkway. Community comforts include a waterfall entry, green spaces, and walking trails. Zoned to the top-rated Katy ISD. You don’t want to miss this home!' ,`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 7 Block 3' ,`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` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marisol' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696632' WHERE `Matrix_Unique_ID` = '210629898' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T11:10:34.750' ,`MLSNumber` = '23133782' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806600' ,`Longitude` = '-95.837470' ,`PhotoCount` = '5' ,`PostalCode` = '77493' ,`RoomCount` = '16' ,`ListPrice` = '684892.00' ,`Status` = 'Active' ,`StreetName` = 'Eden Terrace' ,`StreetNumber` = '6606' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3987' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Ashton, Elevation A) CURRENTLY BEING BUILT. Two Story. 4 bedrooms, 3.5 baths. Private Primary Suite with spacious double walk-in closets downstairs. Secondary bedroom with attached bathroom as well as Study on first floor. Spacious Kitchen and breakfast area open to Family Room and Formal Dining Room. Spacious Game Room upstairs with private Media Room. Covered patio and attached 3 car tandem garage. Located in the heart of Katy and minutes from the Grand Parkway and I-10, the Falls at Green Meadows is Katy’s premiere Community! Residents of the Falls at Green Meadows can enjoy the Community Recreation Center that features a crystal-blue pool and outdoor patio area. Other amenities include sparkling lakes, meandering walking trails, and a playground. Stop by the Westin Homes model home today to find out more about the Falls at Green Meadows!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 5 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8912' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KATY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falls at Green Meadows' ,`TaxAmount` = '' ,`TaxRate` = '3.48' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696632' WHERE `Matrix_Unique_ID` = '210644207' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T10:16:57.800' ,`MLSNumber` = '14655534' ,`ListAgentFullName` = 'Ryan Birdsong' ,`ListOfficeName` = 'Birdsong Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.053603' ,`Longitude` = '-95.428465' ,`PhotoCount` = '24' ,`PostalCode` = '77566' ,`RoomCount` = '6' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Southern Oaks' ,`StreetNumber` = '426' ,`StreetSuffix` = 'Drive' ,`City` = 'Lake Jackson' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2407' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT LOCATION AND LARGE LOT! THIS HOME OFFERS 5 BEDROOMS AND 3 FULL BATHROOMS AND AN OVERSIZED 2 CAR DETACHED GARAGE WITH A STORAGE AREA. THERE ARE 2 PRIMARY SUITES, LARGE LIVING ROOM, KITCHEN/DINING COMBO AND AN INDOOR UTILITY ROOM. RECENT UPDATES INCLUDE KITCHEN, BATHROOMS AND SOME PAINT & FLOORING. LOTS OF EXTRA PARKING SPACE. DON\'T MISS THE CHANCE TO MAKE IT YOURS. CALL US TO SEE TODAY!' ,`Acres` = '0.4184' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'SOUTHERN OAKS (LAKE JACKSON) BLK 2 LOT 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18226' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BRANNEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southern Oaks Lake Jackson' ,`TaxAmount` = '4746' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696632' WHERE `Matrix_Unique_ID` = '211099531' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T10:53:29.720' ,`MLSNumber` = '45924069' ,`ListAgentFullName` = 'Dayna Simmons' ,`ListOfficeName` = 'Dayna Simmons Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.109508' ,`Longitude` = '-94.185340' ,`PhotoCount` = '28' ,`PostalCode` = '77713' ,`RoomCount` = '12' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Abby Ln' ,`StreetNumber` = '3525' ,`StreetSuffix` = '' ,`City` = 'Beaumont' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2913' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out this exquisite enclave situated on Abby Lane in the sought-after Fairfield Addition. Sitting on a .19 acre lot, this home boasts 2,913 square feet of living space. Never run out of space with the 4 bedrooms, study/office, and flex room off of the mudroom. Upstairs bedroom can also be used as a game room! Stunning custom cabinets throughout, large kitchen drawers, coffee bar, and the beautiful island are just a few features that you will love in this awe-inspiring kitchen. Wake up to the sunshine peaking through the large windows in the owners suite and retreat to your bathroom to get ready for the day with the soaking tub, separate shower, and two walk-in closets. The 4th bedroom upstairs could also be used as a game room! The privacy fenced in backyard is the perfect place for the pups to play and for you to supervise under the covered patio. Give us a call today to make this gem yours!' ,`Acres` = '0.1983' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FAIRFIELD PHASE IV LOT 72 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8640' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'REGINAL-HOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairfield Ph IV' ,`TaxAmount` = '10727' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696632' WHERE `Matrix_Unique_ID` = '211190903' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T10:00:44.497' ,`MLSNumber` = '50720453' ,`ListAgentFullName` = 'Tracy Montgomery' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.757120' ,`Longitude` = '-95.340449' ,`PhotoCount` = '45' ,`PostalCode` = '77003' ,`RoomCount` = '4' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Engelke' ,`StreetNumber` = '2817' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute, gated home located in the EADO “New Heights” Home has covered front porch. Large famlily room that leads to the kitchen. Kitchen has gas cook-top and a ton of cabinet space for storage. Home has two very spacious bedrooms and a full bath. Head outside under the covered patio which also leads to a building that could be used as an office (has bathroom and washer/dryer hookups). Walking distance to Navigation Blvd East End Street Market, Dynamo Stadium, Minute Maid Park, Original Ninfa\'s and El Tiempo. Schedule an appointment today to view.' ,`Acres` = '0.0716' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 16B ABST 87 S M WILLIAMS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURNET ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Dietschold S M Williams' ,`TaxAmount` = '3687' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1936' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696633' WHERE `Matrix_Unique_ID` = '211210148' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T10:11:35.153' ,`MLSNumber` = '30212643' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.013641' ,`Longitude` = '-95.414865' ,`PhotoCount` = '17' ,`PostalCode` = '77073' ,`RoomCount` = '6' ,`ListPrice` = '272990.00' ,`Status` = 'Active' ,`StreetName` = 'Great Royal' ,`StreetNumber` = '22102' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1759' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Imperial Heights in Houston, TX! The Leon plan is a charming 2-story home with 3 bedrooms, 2.5 bathrooms, and a 2-car garage. The first floor offers the perfect space for entertaining, with an open kitchen overlooking the family room and dining area! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless steel appliances! The second floor offers a private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring a separate tub and shower and a walk-in closet! Enjoy the great outdoors with full sod and a covered patio! Don’t miss your opportunity to call Imperial Heights 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` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21 Block 4 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3462' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CAROLEE BOOKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Heights' ,`TaxAmount` = '' ,`TaxRate` = '2.73' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696633' WHERE `Matrix_Unique_ID` = '211250254' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T10:29:35.467' ,`MLSNumber` = '50103379' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.013216' ,`Longitude` = '-95.413933' ,`PhotoCount` = '25' ,`PostalCode` = '77073' ,`RoomCount` = '4' ,`ListPrice` = '274990.00' ,`Status` = 'Active' ,`StreetName` = 'Sovereign Heights' ,`StreetNumber` = '22206' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1629' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Imperial Heights in Houston, TX! The Aubrey plan is an open concept 2-story home with soaring ceilings in the entry! Complete with 3 bedrooms, 2.5 bathrooms and a 2-car garage. The interior features an open kitchen, dining, and family room perfect for entertaining! The gourmet kitchen is sure to please with 42\" cabinetry, granite countertops, and stainless steel appliances! Retreat to the Owner\'s Suite featuring a beautiful bay window, double sinks, and a separate tub and shower! Enjoy the great outdoors with full sod and a covered patio! Don’t miss your opportunity to call Imperial Heights home, schedule a visit today! Don\'t miss your opportunity to call Imperial Heights 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` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22 Block 5 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3244' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CAROLEE BOOKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Heights' ,`TaxAmount` = '' ,`TaxRate` = '2.73' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696633' WHERE `Matrix_Unique_ID` = '211250642' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T11:55:49.070' ,`MLSNumber` = '22104118' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.013613' ,`Longitude` = '-95.414833' ,`PhotoCount` = '8' ,`PostalCode` = '77073' ,`RoomCount` = '7' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Great Royal' ,`StreetNumber` = '22210' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2067' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Imperial Heights in Houston, TX! The Miguel floor plan is a charming 2-story home with 4 bedrooms, 2.5 bathrooms, and 2-car garage! The first floor offers the perfect entertainment space with a large bar top kitchen overlooking the expansive family room! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless steel appliances! Upstairs offers a private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring a separate tub and shower and spacious walk-in closet! Secondary bedrooms have walk-in closets too! Enjoy the great outdoors with full sod and a covered patio! Don’t miss your opportunity to call Imperial Heights 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` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 28 Block 4 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3244' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CAROLEE BOOKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Heights' ,`TaxAmount` = '' ,`TaxRate` = '2.73' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696633' WHERE `Matrix_Unique_ID` = '211256455' --> Updated record success