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-04T13:05:22.477' ,`MLSNumber` = '66294974' ,`ListAgentFullName` = 'Astrid Forbes' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.376933' ,`Longitude` = '-95.394451' ,`PhotoCount` = '22' ,`PostalCode` = '77303' ,`RoomCount` = '10' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Amber Park' ,`StreetNumber` = '11361' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1866' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country living - Ranch Style home with endless possibilities on an unrestricted 3.74 +/- ac. land, love horseback pasture is fenced with a large pond, No Flood, No Water Bill, No HOA, low taxes, measurements approximate.\r\nThis property has so much to offer. Don\'t missed out on this great opportunity.' ,`Acres` = '3.74' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TEXABA 02, BLOCK 7, LOT 4' ,`LotDesciption` = 'Cleared' ,`LotSize` = '162914' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Texaba 02' ,`TaxAmount` = '5254' ,`TaxRate` = '1.9103' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694395' WHERE `Matrix_Unique_ID` = '202477245' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T12:39:09.840' ,`MLSNumber` = '92748850' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830411' ,`Longitude` = '-95.554970' ,`PhotoCount` = '15' ,`PostalCode` = '77043' ,`RoomCount` = '12' ,`ListPrice` = '484995.00' ,`Status` = 'Active' ,`StreetName` = 'Centre Meadow' ,`StreetNumber` = '4007' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1935' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy low maintenance living! Gorgeous new 3 story home with beautiful stucco exterior located in the gated, pocket community of Centrepark Terrace. The Amalfi plan features 3 spacious bedrooms, 3 full baths & powder bath. Entertain in the open, modern kitchen/living area. The gourmet kitchen has a functional island, maple cabinets with under cabinet lighting, quartz countertops, farmhouse sink, gas cooktop & stainless steel appliances. Cozy linear fireplace in great room. The owner\'s luxury bathroom has an oversized tub & separate shower with dual vanity sinks. The first floor features a valet cabinet option, perfect for organizing. Versatile activity room with door located downstairs. Stained wood stair treads with painted risers on all floors. Community walking trail. Great location, near Beltway 8 & I-10. Within minutes of CITYCENTRE, Memorial City Mall, Energy Corridor, parks & restaurants. Schedule a tour today! Offered by: K. Hovnanian Houston III, L.L.C.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '3/2/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2086' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TERRACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Centrepark Terrace' ,`TaxAmount` = '' ,`TaxRate` = '2.473' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694395' WHERE `Matrix_Unique_ID` = '207032315' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T13:06:02.163' ,`MLSNumber` = '50590083' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.514996' ,`Longitude` = '-95.819585' ,`PhotoCount` = '9' ,`PostalCode` = '77471' ,`RoomCount` = '13' ,`ListPrice` = '390410.00' ,`Status` = 'Active' ,`StreetName` = 'Silverhorn' ,`StreetNumber` = '3015' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2609' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Find total comfort in this beautiful Foxwood Builders home in Fairpark Village. Resting on a spacious lot, this home boasts a premium elevation, open ceilings, wrought iron spindles, a guest suite, a sprinkler system, and a covered patio. Impress your guests in the kitchen, equipped with laminate countertops, stainless steel appliances, and 42” upper cabinets. Unwind in the serene primary suite, featuring dual vanities, a 42” tub, and a separate shower. Fairpark Village offers peaceful lake views and is in close proximity to a variety of nature parks. Located off Highway 59 and Highway 36, residents enjoy easy access to popular shopping centers and restaurants at the Sugar Land Town Center. Schools in the area are zoned to the Lamar Consolidated ISD. This could be your dream home – call today!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Foxwood Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '533' ,`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` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TERRY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO/GEORGE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairpark Village' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694395' WHERE `Matrix_Unique_ID` = '207937829' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T13:09:49.790' ,`MLSNumber` = '74608700' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.495075' ,`Longitude` = '-95.810915' ,`PhotoCount` = '42' ,`PostalCode` = '77471' ,`RoomCount` = '12' ,`ListPrice` = '480745.00' ,`Status` = 'Active' ,`StreetName` = 'Lacebark Pine' ,`StreetNumber` = '5002' ,`StreetSuffix` = 'Trail' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2586' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Find total comfort in this Briarwood Home in Briarwood Crossing. Resting on a spacious lot, this 4-sided brick home features a premium elevation, tile flooring, faux wood blinds, cast stone fireplace, sprinkler system, and a covered patio. Impress your guests in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. The spa-like primary suite boasts dual vanities, a 42” drop-in tub, and a separate shower. Community comforts include a 5-acre park, pool, walking trails, and a recreation area with a splash pad. Commuters enjoy quick access to Hwy 59 and the Grand Parkway. Nearby schools are zoned to Lamar Consolidated ISD. Don’t wait – call today for more information!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Briarwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '533' ,`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` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarwood Crossing' ,`TaxAmount` = '' ,`TaxRate` = '3.23' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694395' WHERE `Matrix_Unique_ID` = '208081929' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T12:27:49.797' ,`MLSNumber` = '15945686' ,`ListAgentFullName` = 'Eric Linder' ,`ListOfficeName` = 'Integrity Real Estate Agency' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.384294' ,`Longitude` = '-96.077952' ,`PhotoCount` = '27' ,`PostalCode` = '77868' ,`RoomCount` = '3' ,`ListPrice` = '239500.00' ,`Status` = 'Active' ,`StreetName` = 'Gibbs' ,`StreetNumber` = '904' ,`StreetSuffix` = 'Street' ,`City` = 'Navasota' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1968' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very nice 3 bedroom 2.5 bath home located on a corner lot in sought after Milroy Terrace neighborhood. Send the agent a text today to schedule a showing.' ,`Acres` = '0.2828' ,`Area` = '60' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'MILROY TERRACE, BLOCK 5, LOT 1' ,`LotDesciption` = 'Corner,Wooded' ,`LotSize` = '12320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'WEBB ELEMENTARY SCHOOL (NAVASOTA)' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Milroy Terrace' ,`TaxAmount` = '4471' ,`TaxRate` = '2.3442' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694395' WHERE `Matrix_Unique_ID` = '208360217' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T13:10:03.033' ,`MLSNumber` = '82031725' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.495075' ,`Longitude` = '-95.810915' ,`PhotoCount` = '13' ,`PostalCode` = '77471' ,`RoomCount` = '18' ,`ListPrice` = '529720.00' ,`Status` = 'Active' ,`StreetName` = 'Learning Tree' ,`StreetNumber` = '3410' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '3972' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. You don’t want to miss this gorgeous Briarwood Home in Briarwood Crossing. Resting on a spacious lot, this 4-sided brick home boasts a premium elevation, tile flooring, wrought iron spindles, faux wood blinds, a natural stone fireplace, a study with French doors, and a sprinkler system. Try a new recipe in the island kitchen, equipped with granite countertops, stainless steel appliances, and 42” upper cabinets. The relaxing primary suite, features dual vanities, a drop-in tub, and a separate shower. Community comforts include a 5-acre park, pool, recreation area with a splash pad, and walking trails. Commuters enjoy easy access to Hwy 59 and the Grand Parkway. Schools are zoned to the highly-acclaimed Lamar Consolidated ISD. Don’t wait – call now to learn more!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Briarwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '533' ,`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` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarwood Crossing' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694396' WHERE `Matrix_Unique_ID` = '208742453' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T13:07:30.160' ,`MLSNumber` = '18026547' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.495075' ,`Longitude` = '-95.810915' ,`PhotoCount` = '18' ,`PostalCode` = '77471' ,`RoomCount` = '14' ,`ListPrice` = '447840.00' ,`Status` = 'Active' ,`StreetName` = 'Fogmist' ,`StreetNumber` = '3247' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2785' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. This amazing Lake Ridge Builders home in Briarwood Crossing is what you’ve been dreaming of. Situated on a spacious lot, this 3-sided brick home boasts a prem elevation, tile flooring, 3-car garage, sprinkler system, wrought iron spindles, faux wood blinds, study with French doors, and a covered patio. Try a new recipe in the kitchen, equipped with granite countertops, stainless steel appliances, and 42” upper cabinets. Complete with dual vanities, a 42” tub, and a separate shower, the primary suite is the perfect place to unwind. Community comforts include a 5-acre park, pool, recreation area with a splash pad, and walking trails. Commuters enjoy easy access to Hwy 59 and the Grand Parkway. Schools are zoned to the highly-acclaimed Lamar Consolidated ISD. Don’t wait – call today!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '533' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarwood Crossing' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694396' WHERE `Matrix_Unique_ID` = '208746192' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T13:07:43.293' ,`MLSNumber` = '74081761' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.495075' ,`Longitude` = '-95.810915' ,`PhotoCount` = '17' ,`PostalCode` = '77471' ,`RoomCount` = '11' ,`ListPrice` = '387300.00' ,`Status` = 'Active' ,`StreetName` = 'Fogmist' ,`StreetNumber` = '3303' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1869' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Retreat to this incredible Lake Ridge Builders home in Briarwood Crossing. Resting on a spacious lot, this 3-sided brick home boasts a premium elevation, tile flooring, sprinkler system, faux wood blinds, and a covered patio. Spend quality time in the kitchen, equipped with granite countertops, stainless steel appliances, and 42” upper cabinets. The tranquil primary suite features dual vanities, a 42” tub, and a separate shower. Community comforts include a 5-acre park, pool, recreation area with a splash pad, and walking trails. Commuters enjoy easy access to Hwy 59 and the Grand Parkway. Schools are zoned to the highly acclaimed Lamar Consolidated ISD. Don’t wait – call now to learn more!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '533' ,`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` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarwood Crossing' ,`TaxAmount` = '' ,`TaxRate` = '3.23' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694396' WHERE `Matrix_Unique_ID` = '208747096' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T13:10:37.527' ,`MLSNumber` = '59107349' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.495075' ,`Longitude` = '-95.810915' ,`PhotoCount` = '14' ,`PostalCode` = '77471' ,`RoomCount` = '16' ,`ListPrice` = '526563.00' ,`Status` = 'Active' ,`StreetName` = 'Learning Tree' ,`StreetNumber` = '3402' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Escape the city to this beautiful Briarwood Home in Briarwood Crossing. Resting on a spacious lot, this 4-sided brick home boasts a premium elevation, tile flooring, sprinkler system, wrought iron spindles, faux wood blinds, natural stone fireplace, a study with French doors, and a covered patio. Spend quality time in the kitchen, equipped with granite countertops, stainless steel appliances, and 42” upper cabinets. Community comforts include a 5-acre park, pool, recreation area with a splash pad, and walking trails. Commuters enjoy easy access to Hwy 59 and the Grand Parkway. Schools are zoned to the highly-acclaimed Lamar Consolidated ISD. Don’t wait – call today!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Briarwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '533' ,`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` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarwood Crossing' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694396' WHERE `Matrix_Unique_ID` = '208767069' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T12:39:22.990' ,`MLSNumber` = '67008149' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.877460' ,`Longitude` = '-95.793289' ,`PhotoCount` = '27' ,`PostalCode` = '77493' ,`RoomCount` = '13' ,`ListPrice` = '444917.00' ,`Status` = 'Active' ,`StreetName` = 'Winterberry Glen' ,`StreetNumber` = '7118' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Terrace, Elevation B). CURRENTLY UNDER CONSTRUCTION. Two story. 4 bedrooms. 3.5 baths. Spacious island kitchen open to informal dining room and family room. Primary suite with large walk in closet. Large Game Room and three additional bedrooms upstairs. Covered patio and attached 2 car garage. Just minutes from the Grand Parkway, Elyson is located in the Heart of Katy! The Elyson Café is the center of this community and offers a full food and drinks menu plus a coffee bar. Community amenities also include a pool, fitness center, game room, event lawn, tennis courts, parks and trails, and so much more. Stop by the Westin Homes model to learn more about Elyson!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5200' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1242' ,`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` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694396' WHERE `Matrix_Unique_ID` = '208987329' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T13:06:48.023' ,`MLSNumber` = '70936246' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.514996' ,`Longitude` = '-95.819585' ,`PhotoCount` = '15' ,`PostalCode` = '77471' ,`RoomCount` = '15' ,`ListPrice` = '415640.00' ,`Status` = 'Active' ,`StreetName` = 'Silverhorn' ,`StreetNumber` = '2910' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2793' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Create unforgettable memories in this stunning Foxwood Builders home in Fairpark Village. Resting on a spacious lot, this home boasts tile flooring, full gutters, a sprinkler system, wrought iron spindles, faux wood blinds, a study with French doors, and a covered patio. Impress your guests in the kitchen, equipped with granite countertops, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. Unwind in the tranquil primary suite, featuring dual vanities, a 42” tub, and a separate shower. Fairpark Village offers peaceful lake views and is in close proximity to a variety of nature parks. Located off Highway 59 and Highway 36, residents enjoy easy access to popular shopping centers and restaurants at the Sugar Land Town Center. Nearby schools are a part of the acclaimed Lamar Consolidated ISD. Don’t wait – call today for more information!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Foxwood Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '533' ,`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` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TERRY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO/GEORGE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairpark Village' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694396' WHERE `Matrix_Unique_ID` = '209521672' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T13:06:29.587' ,`MLSNumber` = '4204381' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.514996' ,`Longitude` = '-95.819585' ,`PhotoCount` = '13' ,`PostalCode` = '77471' ,`RoomCount` = '12' ,`ListPrice` = '386275.00' ,`Status` = 'Active' ,`StreetName` = 'Silverhorn' ,`StreetNumber` = '2930' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2387' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Cherish lasting moments in this gorgeous Foxwood Builders home in Fairpark Village. Situated on a spacious lot, this home boasts a premium elevation, tile flooring, full gutters, a sprinkler system, wrought iron spindles, and a covered patio. Spend all day in the kitchen, equipped with granite countertops, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. The tranquil primary suite features dual vanities, a 42” tub, and a separate shower. Fairpark Village offers peaceful lake views and is in close proximity to a variety of nature parks. Located off Highway 59 and Highway 36, residents enjoy easy access to popular shopping centers and restaurants at the Sugar Land Town Center. Nearby schools are a part of the acclaimed Lamar Consolidated ISD. Don’t wait – call today for more information!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Foxwood Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '533' ,`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` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TERRY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO/GEORGE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairpark Village' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694396' WHERE `Matrix_Unique_ID` = '209522027' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T13:21:15.397' ,`MLSNumber` = '46236045' ,`ListAgentFullName` = 'Kyle Pryor' ,`ListOfficeName` = 'Pryor Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.394891' ,`Longitude` = '-95.688634' ,`PhotoCount` = '7' ,`PostalCode` = '77356' ,`RoomCount` = '7' ,`ListPrice` = '539000.00' ,`Status` = 'Active' ,`StreetName` = 'Abner Ln' ,`StreetNumber` = '166' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2790' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction in the heart of Montgomery. Beautiful 4 bedroom/3.5 bath/3 car garage +gameroom. Large, open family room, spacious primary bedroom with en suite bath featuring jetted tub and separate shower, double vanity and walk in closet. Upstairs, 2 bedrooms with Hollywood bath and one large bedroom with adjacent bath. Kitchen has granite countertops, 42\" upper cabinets and breakfast room. Tile flooring throughout the downstairs main living areas, kitchen, all baths and utility room. Zoned to much desired Montgomery ISD schools.' ,`Acres` = '0.28' ,`Area` = '39' ,`BuilderName` = 'Camillo Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S456900 - ESTATES OF LAKE CREEK VILLAGE, BLOCK 1, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12197' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates Of Lake Creek Village' ,`TaxAmount` = '1146' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694396' WHERE `Matrix_Unique_ID` = '209592652' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T13:09:04.130' ,`MLSNumber` = '17503328' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.495075' ,`Longitude` = '-95.810915' ,`PhotoCount` = '13' ,`PostalCode` = '77471' ,`RoomCount` = '15' ,`ListPrice` = '443495.00' ,`Status` = 'Active' ,`StreetName` = 'Fogmist' ,`StreetNumber` = '3307' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2809' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Fall in love with this gorgeous Lake Ridge Builders home in Briarwood Crossing. Resting on a spacious lot, this 3-sided brick home boasts a premium elevation, tile flooring, sprinkler system, wrought iron spindles, faux wood blinds, and a covered patio. Cook up new cuisines in the kitchen, equipped with granite countertops, stainless steel appliances, and 42” upper cabinets. The serene primary suite features dual vanities, a 42” tub, and a separate shower. Community comforts include a 5-acre park, pool, recreation area with a splash pad, and walking trails. Commuters enjoy easy access to Hwy 59 and the Grand Parkway. Zoned to the highly acclaimed Lamar Consolidated ISD. Don’t wait – call now to learn more!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '533' ,`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` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarwood Crossing' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694397' WHERE `Matrix_Unique_ID` = '209846316' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T13:07:01.113' ,`MLSNumber` = '62535820' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.514996' ,`Longitude` = '-95.819585' ,`PhotoCount` = '50' ,`PostalCode` = '77471' ,`RoomCount` = '15' ,`ListPrice` = '392570.00' ,`Status` = 'Active' ,`StreetName` = 'Godric Hollow' ,`StreetNumber` = '2931' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2797' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy peace and quiet in this lovely Foxwood Builders home in Fairpark Village. Situated on a spacious lot, this home boasts a premium elevation, wrought iron spindles, a media room, a study with French doors, a sprinkler system, and a covered patio. Master new recipes in the kitchen, equipped with laminate countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. The spa-like primary suite features dual vanities, a 42” tub, and a separate shower. Fairpark Village offers peaceful lake views and is in close proximity to a variety of nature parks. Located off Highway 59 and Highway 36, residents enjoy easy access to popular shopping centers and restaurants at the Sugar Land Town Center. Schools in the area are zoned to the acclaimed Lamar Consolidated ISD. Don’t wait – call today for more information!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Foxwood Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 19 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '533' ,`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` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TERRY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO/GEORGE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairpark Village' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694397' WHERE `Matrix_Unique_ID` = '209882264' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T12:38:32.387' ,`MLSNumber` = '56987461' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.876104' ,`Longitude` = '-95.785543' ,`PhotoCount` = '7' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '429817.00' ,`Status` = 'Active' ,`StreetName` = 'House Wren' ,`StreetNumber` = '7007' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2365' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Retreat, Elevation B) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 2.5 baths. Spacious island kitchen open to Family room and dining room. Primary suite with large walk-in closet. Covered patio and attached 2 car garage. Just minutes from the Grand Parkway, Elyson is located in the Heart of Katy! The Elyson Café is the center of this community and offers a full food and drinks menu plus a coffee bar. Community amenities also include a pool, fitness center, game room, event lawn, tennis courts, parks and trails, and so much more. Stop by the Westin Homes model to learn more about Elyson!' ,`Acres` = '0.1142' ,`Area` = '25' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4974' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1242' ,`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` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '1739' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694397' WHERE `Matrix_Unique_ID` = '210768934' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T12:42:26.007' ,`MLSNumber` = '45003575' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.883040' ,`Longitude` = '-95.789247' ,`PhotoCount` = '8' ,`PostalCode` = '77493' ,`RoomCount` = '15' ,`ListPrice` = '654857.00' ,`Status` = 'Active' ,`StreetName` = 'Primrose Garden' ,`StreetNumber` = '23906' ,`StreetSuffix` = 'Road' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3757' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Rowan, Elevation EP) 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. Just minutes from the Grand Parkway, Elyson is located in the Heart of Katy! The Elyson Café is the center of this community and offers a full food and drinks menu plus a coffee bar. Community amenities also include a pool, fitness center, game room, event lawn, tennis courts, parks and trails, and so much more. Stop by the Westin Homes model home to learn more about Elyson!' ,`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 1 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8884' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1242' ,`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` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694397' WHERE `Matrix_Unique_ID` = '210839325' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T12:29:31.800' ,`MLSNumber` = '50785949' ,`ListAgentFullName` = 'Michelleanne Small' ,`ListOfficeName` = 'Real Broker, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.995453' ,`Longitude` = '-95.518031' ,`PhotoCount` = '34' ,`PostalCode` = '77069' ,`RoomCount` = '10' ,`ListPrice` = '529000.00' ,`Status` = 'Active' ,`StreetName` = 'Court Of York' ,`StreetNumber` = '5202' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 5202 Court of York. If you are looking for a one of a kind home on a HUGE, PRIVATE cul-de-sac lot, you have arrived! Eight foot glass-paned double french door welcomes you and your guests to an impressive Foyer with gleaming marble floors, sweeping staircase and 19 ft ceiling. The large Great room with cathedral ceilings offers floor to ceiling windows which provide a spectacular view of the pool, lawn and mature trees. The Great room, Study and Breakfast room offer rich, handcrafted wood block paneling. You will love the sunlit rooms and traditional architectural features of this home, including crown molding, wood beams, chair railing, built-ins, gas-log fireplace, 2 wet bars and bay windows that adorn the front elevation. Large, downstairs Master Bedroom has an en-suite and French Doors leading to the backyard. Gameroom & 3 KING- SIZE Bedrooms upstairs. The Kitchen offers tons of storage, granite counters, island, cabinets w glass inserts, warming drawer & walk-in pantry.' ,`Acres` = '0.3912' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 1 HUNTWICK FOREST SEC 5' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '17039' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '151' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BRILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Huntwick Forest Sec 05' ,`TaxAmount` = '9486' ,`TaxRate` = '2.3915' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694397' WHERE `Matrix_Unique_ID` = '211045999' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T12:54:35.533' ,`MLSNumber` = '72585418' ,`ListAgentFullName` = 'Jason Vo' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.880325' ,`Longitude` = '-93.929248' ,`PhotoCount` = '13' ,`PostalCode` = '77640' ,`RoomCount` = '2' ,`ListPrice` = '109000.00' ,`Status` = 'Active' ,`StreetName` = 'Stilwell' ,`StreetNumber` = '541' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Port Arthur' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'For investors only. Welcome to a cozy 2 beds, 1 bath in the heart of the beloved City of Port Arthur. This home features a recent upgrade to the interior. Detached 2 car garage. Beautiful front landscaping. Large backyard for your weekend BBQ get-together. Please contact the listing agent for more questions.' ,`Acres` = '0.1286' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'N 10\' OF LT 10 & S 30\' OF LT 11 BLK 119 CITY OF PORT ARTHUR' ,`LotDesciption` = 'Other' ,`LotSize` = '5600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '236 - Port Arthur' ,`SchoolElementary` = 'DEQUEEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PORT ARTHUR)' ,`SchoolMiddle` = 'LINCOLN MIDDLE SCHOOL (PORT ARTHUR)' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Port Arthur City' ,`TaxAmount` = '' ,`TaxRate` = '3.1' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694397' WHERE `Matrix_Unique_ID` = '211047708' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T13:28:19.880' ,`MLSNumber` = '4459627' ,`ListAgentFullName` = 'Brenda Richardson' ,`ListOfficeName` = 'U.S.A. Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.643757' ,`Longitude` = '-95.516100' ,`PhotoCount` = '8' ,`PostalCode` = '77071' ,`RoomCount` = '6' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Preakness' ,`StreetNumber` = '12206' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2257' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The interior was remodeled 12 months ago. Pictures were taken during remodel. Completely remodeled kitchen, new tile flooring throughout and nicely painted. Outside repairs to siding is in progress. Corner home was completely re-built 1999. Tax records are not updated. Oversized downstairs master bedroom & bath with garden tub. Fireplace in living room. Large formal dining room. One huge bedroom upstairs (almost larger than the master bedroom). Additional two bedrooms upstairs are larger than your typical bedrooms. Large bathroom upstairs. Nice size utility room inside. Large front & backyard. Detached garage.' ,`Acres` = '0.1517' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 FONDREN SW SOUTHMEADOW SEC 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GROSS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fondren Sw Southmeadow Sec 05' ,`TaxAmount` = '4284' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694397' WHERE `Matrix_Unique_ID` = '211050821' --> Updated record success