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-19T14:32:31.527' ,`MLSNumber` = '23460829' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.441145' ,`Longitude` = '-95.248996' ,`PhotoCount` = '23' ,`PostalCode` = '77511' ,`RoomCount` = '15' ,`ListPrice` = '426988.00' ,`Status` = 'Active' ,`StreetName` = 'Kenley' ,`StreetNumber` = '1846' ,`StreetSuffix` = 'Way' ,`City` = 'Alvin' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2711' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming Monaco III home features 5 bedrooms, 3.5 baths and 2 car garage. Convenient home office tucked of foyer. Maple cabinets and quartz countertops in kitchen. Huge walk-in closet, double sinks, separate tub and shower in owner\'s luxury bath. Upstairs, you\'ll find a cozy loft space and all secondary bedrooms. Covered patio in backyard, perfect for entertaining. Offered by: K. Hovnanian Houston Midtown Park I, LLC.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '7/4/3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HASSE ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Midtown Park' ,`TaxAmount` = '' ,`TaxRate` = '2.885' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700625' WHERE `Matrix_Unique_ID` = '206278500' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T14:23:21.190' ,`MLSNumber` = '57980018' ,`ListAgentFullName` = 'Mariana Ginebra Saavedra' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.737184' ,`Longitude` = '-95.287631' ,`PhotoCount` = '16' ,`PostalCode` = '77012' ,`RoomCount` = '3' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue I' ,`StreetNumber` = '7604' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1 story home on a big lot that has high ceilings throughout the home! This home offers many upgrades including new HVAC, attic insulation, water heater, floors, appliances, and many other upgrades. Come get a tour of this lovely home before it is gone!' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 27 & 28 BLK 65 MAGNOLIA PARK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DE ZAVALA ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MILBY HIGH SCHOOL' ,`SchoolMiddle` = 'EDISON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Park Sec 02' ,`TaxAmount` = '2432' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700626' WHERE `Matrix_Unique_ID` = '206501735' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T15:56:31.693' ,`MLSNumber` = '31776090' ,`ListAgentFullName` = 'Wendy Dozier' ,`ListOfficeName` = 'RE/MAX On The Water - Bolivar' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.474654' ,`Longitude` = '-94.588637' ,`PhotoCount` = '50' ,`PostalCode` = '77650' ,`RoomCount` = '3' ,`ListPrice` = '765000.00' ,`Status` = 'Active' ,`StreetName` = 'Castle' ,`StreetNumber` = '3169' ,`StreetSuffix` = 'Drive' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1886' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous custom home with so many possibilities and amenities in a popular beach neighborhood just a short walk or golf cart ride to the beach! Two garage spaces with plenty of space for storage on one side and entertainment with a bar area & TV on the other. Enjoy the Gulf breezes on the deck or below. Extra lot & yard is large enough to add a swimming pool &/or hot tub! Beautiful 3 bedroom, 2 bath home with an extra work space and a back deck to enjoy the peninsulas beautiful sunsets and the intracoastal. All stainless steel appliances and there is also a wine refrigerator. This home has been occupied full time by the owners since it was built, but it would also make an excellent vacation rental investment. Sand Castle has golf cart bridge access to the beach right down the road. No \"thru-traffic\" in this subdivision. Come see this home and make it your own for you & your family to make lasting memories!' ,`Acres` = '0.81' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 PAGE 11 LOTS 34 THRU 35 (36-0) BLK 3 SAND CASTLE BEA' ,`LotDesciption` = 'Other,Water View' ,`LotSize` = '35284' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sand Castle Beach 2' ,`TaxAmount` = '7587' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700626' WHERE `Matrix_Unique_ID` = '207448452' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T14:14:45.750' ,`MLSNumber` = '90579906' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.475170' ,`Longitude` = '-95.530793' ,`PhotoCount` = '16' ,`PostalCode` = '77459' ,`RoomCount` = '11' ,`ListPrice` = '979900.00' ,`Status` = 'Active' ,`StreetName` = 'Pleasant' ,`StreetNumber` = '8922' ,`StreetSuffix` = 'Cove' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4428' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Private courtyard. Front porch leads to welcoming two-story entry with 20-foot ceilings framed by a home office with French doors and a circular staircase. Two-story family room with soaring 21-foot ceiling features a fireplace and a wall of windows. Island kitchen with built-in seating space offers and generous walk-in pantry and a butler\'s pantry that leads to the formal dining room. Morning area with a curved wall of windows just off the kitchen. Private primary suite with a curved wall of windows. Primary bathroom features a French door entry, dual vanities, garden tub, separate glass enclosed shower, linen closet and two walk-in closets. Guest suite with a full bathroom and walk-in closet downstairs. Second floor features additional guest suites with full bathrooms, a game room with a wall of windows and a media room. Utility room offers dual access to the primary bathroom. Covered backyard patio. Mud room. Three-car split garage.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sienna - Valencia by Perry Homes Lot 12, Blk 1, Section 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11515' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1357' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna - Valencia by Perry Homes' ,`TaxAmount` = '' ,`TaxRate` = '3.16' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700626' WHERE `Matrix_Unique_ID` = '207674569' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T14:15:12.880' ,`MLSNumber` = '68837298' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.475625' ,`Longitude` = '-95.530049' ,`PhotoCount` = '16' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '854900.00' ,`Status` = 'Active' ,`StreetName` = 'Pleasant' ,`StreetNumber` = '9010' ,`StreetSuffix` = 'Cove' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3581' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Large private front courtyard. New stucco design. Home office and game room, both featuring French doors frame entry with a barrel vault ceiling. Formal dining room with easy access to Butler\'s pantry for added convenience. Open family room with a corner wood mantel fireplace and a wall of windows. Kitchen features a large island with built-in seating space, two wall ovens and a 5-burner gas cooktop and opens to the morning area. Private primary suite with a curved wall of windows. Primary bath with double doors features dual vanities, two linen closets, garden tub, a separate glass-enclosed shower and a large walk-in closet. Secondary bedrooms and a Hollywood bath complete this expansive design. Covered backyard patio. Mud room. Three-car split garage with porte-cochere.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sienna - Valencia by Perry Homes Lot 35, Blk 1, Section 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9983' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1357' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna - Valencia by Perry Homes' ,`TaxAmount` = '' ,`TaxRate` = '3.16' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700626' WHERE `Matrix_Unique_ID` = '207935141' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T14:15:34.903' ,`MLSNumber` = '55199525' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.475263' ,`Longitude` = '-95.529791' ,`PhotoCount` = '15' ,`PostalCode` = '77459' ,`RoomCount` = '11' ,`ListPrice` = '979900.00' ,`Status` = 'Active' ,`StreetName` = 'Orchard' ,`StreetNumber` = '9007' ,`StreetSuffix` = 'Cove' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4428' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Private courtyard. Front porch leads to welcoming two-story entry with 20-foot ceilings framed by a home office French doors and circular staircase. Two-story family room with soaring 21-foot ceiling features wood mantel fireplace and a wall of windows. Island kitchen with built-in seating space offers and generous walk-in pantry, two wall ovens, 5-burner gas cooktop and butler\'s pantry that leads to formal dining room. Morning area with a curved wall of windows off the kitchen. Private primary suite with curved wall of windows. Primary bathroom features a French door entry, dual vanities, garden tub, separate glass enclosed shower, linen closet and two walk-in closets. Guest suite with full bathroom and walk-in closet downstairs. Second floor features additional guest suites with full bathrooms, game room with a wall of windows and media room. Utility room offers dual access to primary bathroom. Covered backyard patio. Mud room. Three-car split garage.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sienna - Valencia by Perry Homes Lot 38, Blk 1, Section 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10536' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1357' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna - Valencia by Perry Homes' ,`TaxAmount` = '' ,`TaxRate` = '3.16' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700626' WHERE `Matrix_Unique_ID` = '207936949' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T15:47:37.643' ,`MLSNumber` = '81369429' ,`ListAgentFullName` = 'Charles Miller' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.573485' ,`Longitude` = '-94.888788' ,`PhotoCount` = '19' ,`PostalCode` = '77335' ,`RoomCount` = '9' ,`ListPrice` = '690000.00' ,`Status` = 'Active' ,`StreetName` = 'LIBERTY LANE' ,`StreetNumber` = '100' ,`StreetSuffix` = '' ,`City` = 'Goodrich' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1730' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to peace and seclusion. This 50 acres is hidden away in the country from all the busy streets. There is a abundance of wildlife to go with the beautiful trees and scenery. This property has a 3 bedrooms, 2 bathroom home, 35x48 metal barn, and a pond. This property stays high and dry and never flooded. This property has so many possibilities from a working ranch, hunting, fishing, and much more.' ,`Acres` = '50' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Propane,Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 77 AUGUSTIN VIESCA SURVEY TRACT 358, 358-A' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '138 - Goodrich' ,`SchoolElementary` = 'GOODRICH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOODRICH HIGH SCHOOL' ,`SchoolMiddle` = 'GOODRICH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'none' ,`TaxAmount` = '8743' ,`TaxRate` = '1.703' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700626' WHERE `Matrix_Unique_ID` = '207941287' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T14:08:21.830' ,`MLSNumber` = '70589519' ,`ListAgentFullName` = 'Sarah Hartwell' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.420870' ,`Longitude` = '-95.251669' ,`PhotoCount` = '31' ,`PostalCode` = '77511' ,`RoomCount` = '9' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Beauregard' ,`StreetNumber` = '404' ,`StreetSuffix` = 'Street' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3028' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is your opportunity to own a piece of history! Welcome to Twin Oaks, a beautiful Victorian home built by A.J. Birchfield, the first editor of the Alvin Sun. Also dubbed Birchfield-McCown House, this is one of only two Historic Homes in Alvin with a Texas Historical Marker beside the front door. Often a storm refuge, the home kept over 100 safe in the famed 1900 coastal hurricane. Four leading townspeople have owned this 12-room Victorian structure. Enjoy the lush oversized corner lot from the upper and lower wrapping porches. The driveway is flanked by 100+ year old twin oak trees. Much of the interior is painted with traditional Victorian era colors. Original stairway & crown moldings, some original hardwoods, high ceilings, en-suite bath in Primary. Updated kitchen with granite and island opens to the side & back decks. Close proximity to Sealy Park, the community garden, & Alvin High! This is an as-is sale; no repairs to be made by Seller. Inspection and HVAC estimate in Docs.' ,`Acres` = '0.287' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas,No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ALVIN NO 1 (ALVIN), BLOCK 56, LOT 9-10' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '12502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'ALVIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Victorian' ,`Subdivision` = 'Alvin 1 Alvin' ,`TaxAmount` = '8522' ,`TaxRate` = '2.8854' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1901' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700626' WHERE `Matrix_Unique_ID` = '208253770' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T15:09:52.593' ,`MLSNumber` = '61203323' ,`ListAgentFullName` = 'Shani Daigle' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Barbara Kearns' ,`SellingOfficeName` = 'Coldwell Banker Southern Homes' ,`Latitude` = '30.142055' ,`Longitude` = '-94.163234' ,`PhotoCount` = '23' ,`PostalCode` = '77708' ,`RoomCount` = '8' ,`ListPrice` = '219577.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Margaret' ,`StreetNumber` = '5290' ,`StreetSuffix` = 'Lane' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1925' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you are looking for a spacious, well built home in a quiet neighborhood with a lot of space, this is the one! No where else in the city can you get a home on over an acre of land and still conveniently located within 3 mins of Beaumont\'s major shopping district. This home has a large living room, formal dining, den/sitting room and breakfast room. Dishwasher, refrigerator, cooktop, double ovens, washer and dryer are all included! The garage also has extra storage space. Schedule your showing today!' ,`Acres` = '1.0331' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Probate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WOODLAND AC L16 B 7' ,`LotDesciption` = 'Cleared' ,`LotSize` = '45000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'HOMER DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'KING MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Acres' ,`TaxAmount` = '4408' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700626' WHERE `Matrix_Unique_ID` = '209308806' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T14:45:59.707' ,`MLSNumber` = '10728525' ,`ListAgentFullName` = 'Sharon Holt' ,`ListOfficeName` = 'Clark Realty' ,`SellingAgentFullName` = 'Jessica Howland' ,`SellingOfficeName` = 'Birdsong Real Estate' ,`Latitude` = '29.117182' ,`Longitude` = '-95.562225' ,`PhotoCount` = '34' ,`PostalCode` = '77515' ,`RoomCount` = '4' ,`ListPrice` = '499900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bronco' ,`StreetNumber` = '1407' ,`StreetSuffix` = 'Trail' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2302' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Country home on approx. 2 acres in Bar X Ranch. This home has 3 bedrooms/2 baths down and bonus room/ bedroom with full bath up. This home also has a 32x50 pole barn with 15\' lean-to built in 2017. Home consist of beautiful stained concrete throughout with carpet in bedrooms, granite countertops with butcher block island. This house has never flooded, come take a look today!' ,`Acres` = '1.98' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BAR X RANCH SEC 3 (A0038 J B BAILEY) BLK 5 LOT 302-303 ACRES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '86249' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Bar X Ranch Sec 3' ,`TaxAmount` = '5333' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700627' WHERE `Matrix_Unique_ID` = '209841680' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T15:06:31.460' ,`MLSNumber` = '94438283' ,`ListAgentFullName` = 'Valeria Cervantes-Lopez' ,`ListOfficeName` = 'My City Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.676699' ,`Longitude` = '-95.257833' ,`PhotoCount` = '14' ,`PostalCode` = '77017' ,`RoomCount` = '4' ,`ListPrice` = '158000.00' ,`Status` = 'Active' ,`StreetName` = 'Bendell' ,`StreetNumber` = '8172' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1644' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LARGE CORNER LOT LOCATED IN SOUTH EAST HOUSTON, CLOSE TO SCHOOLS, EASY ACCESS TO 45 SOUTH & 610 LOOP. HOME NEEDS TLC. HAS 3 B3DRROMS 1 BATH IN THE MAIN HOUSE WITH CENTRAL AIR/HEAT/ W/LARGE COVERED PATIO & A BEDROOM WITH WINDOW UNIT IN THE COVERTED GARAGE, WITH FULL BATH. HOME HAS EASY ACCES TO 45S & 610. BONNER ELEMENTARY SCHOOL ACROSS THE STREET. CHAVEZ HIGH SCHOOL IS 1 MILE AWAY. SELLER IS SELLING AS/IS AND WILL NOT MAKE REPAIRS.' ,`Acres` = '0.2282' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric,Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 55 MEADOWBROOK SEC G' ,`LotDesciption` = 'Corner' ,`LotSize` = '9941' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BONNER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'CHAVEZ HIGH SCHOOL' ,`SchoolMiddle` = 'STEVENSON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadowbrook Sec G' ,`TaxAmount` = '3045' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663700627' WHERE `Matrix_Unique_ID` = '209966884' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T14:26:01.960' ,`MLSNumber` = '77247352' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.200142' ,`Longitude` = '-95.407176' ,`PhotoCount` = '16' ,`PostalCode` = '77515' ,`RoomCount` = '10' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Brushy Meadow' ,`StreetNumber` = '3319' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2044' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Juniper II home design features 3 bedrooms, 2 baths and 2 car garage. Cozy media room with barn doors located across from great room. Beautiful maple cabinets, quartz countertops, island and farmhouse sink in gourmet kitchen. Double sinks, huge walk-in closet, separate tub and shower in owner\'s luxury bath. Covered patio in backyard, perfect for entertaining. This home is a must see, so schedule your appointment today to find out if this home is the best option for you and your family. \r\nWindrose Green in Angleton offers easy access to Hwy 288 and Hwy 35. Students will have access to a trail which will lead them to Angleton High School. Planned amenities include a neighborhood park with playground and splashpad plus walking trails. Offered by: K. Hovnanian of Houston II, L.L.C.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'K.Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '59/2/1' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'RANCHO ISABELLA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Windrose Green' ,`TaxAmount` = '' ,`TaxRate` = '3.527' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700627' WHERE `Matrix_Unique_ID` = '210497624' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T14:56:24.343' ,`MLSNumber` = '46605737' ,`ListAgentFullName` = 'JC Torres' ,`ListOfficeName` = 'Signature Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.853569' ,`Longitude` = '-95.695227' ,`PhotoCount` = '23' ,`PostalCode` = '77449' ,`RoomCount` = '7' ,`ListPrice` = '318000.00' ,`Status` = 'Active' ,`StreetName` = 'Lansdowne Stream' ,`StreetNumber` = '18838' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home built by Legend Homes 4 bedroom/2.5 baths/2 car garage. Greenbelt location.Open floor plan Living, Dinning, Kitchen. Kitchen featuring large granite island available for additional seating, upgraded appliances Gas range and oven, dishwasher, microwave with refrigerator to remain. Neutral colors throughout. Open plan to entire living room downstairs. Walk in pantry. All Vinyl wood flooring downstairs. Half bath downstairs for guests. Plenty of windows for natural lighting. 4 Bedrooms upstairs. Master bedroom with master bath 2 vanities, separate shower and garden tub. Walk in closet. Spacious secondary bedrooms upstairs. Secondary bath with two vanities, combo tub/shower. Ceiling fans. 2 car garage Small backyard backs to greenbelt. Community amenities include a playground and splash pad. Easy access to hwy 6, 99 and IH 10 just minutes around the Metro. Won\'t last... Make us an offer' ,`Acres` = '0.0781' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 ADELAIDE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SHERIDAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'ADELAIDE' ,`TaxAmount` = '5879' ,`TaxRate` = '2.641' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663700627' WHERE `Matrix_Unique_ID` = '210793690' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T14:34:46.820' ,`MLSNumber` = '56337438' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.441790' ,`Longitude` = '-95.249264' ,`PhotoCount` = '23' ,`PostalCode` = '77511' ,`RoomCount` = '15' ,`ListPrice` = '432029.00' ,`Status` = 'Active' ,`StreetName` = 'Kenley' ,`StreetNumber` = '1856' ,`StreetSuffix` = 'Way' ,`City` = 'Alvin' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2711' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming Monaco III home features 5 bedrooms, 3.5 baths and 2 car garage. Convenient home office tucked of foyer. Maple cabinets and quartz countertops in kitchen. Huge walk-in closet, double sinks, separate tub and shower in owner\'s luxury bath. Upstairs, you\'ll find a cozy loft space and all secondary bedrooms. Covered patio in backyard, perfect for entertaining. Offered by: K. Hovnanian Houston Midtown Park I, LLC.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '12/4/3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HASSE ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Midtown Park' ,`TaxAmount` = '' ,`TaxRate` = '2.885' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700627' WHERE `Matrix_Unique_ID` = '211299627' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T14:35:24.667' ,`MLSNumber` = '22382587' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.442742' ,`Longitude` = '-95.249435' ,`PhotoCount` = '12' ,`PostalCode` = '77511' ,`RoomCount` = '13' ,`ListPrice` = '402968.00' ,`Status` = 'Active' ,`StreetName` = 'Kenley' ,`StreetNumber` = '1868' ,`StreetSuffix` = 'Way' ,`City` = 'Alvin' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2298' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming Captiva II home features 5 bedrooms, 3 baths and 2 car garage. Elegant dining room with easy access to kitchen. Beautiful maple cabinets, undercabinet lighting, granite countertops and walk-in pantry in kitchen. One secondary bedroom located downstairs. Upstairs, you\'ll find the owner\'s suite, plus 3 secondary bedrooms. Huge walk-in closet, double sinks, separate tub and shower in owner\'s luxury bath. Covered patio in backyard, perfect for entertaining. Offered by: K. Hovnanian Houston Midtown Park I, LLC.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '18/4/3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HASSE ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Appointment Required,Call Occupant' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Midtown Park' ,`TaxAmount` = '' ,`TaxRate` = '2.885' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700627' WHERE `Matrix_Unique_ID` = '211302707' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T14:43:38.517' ,`MLSNumber` = '92592673' ,`ListAgentFullName` = 'Cary Stephens' ,`ListOfficeName` = 'RE/MAX East' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799868' ,`Longitude` = '-95.194855' ,`PhotoCount` = '22' ,`PostalCode` = '77015' ,`RoomCount` = '17' ,`ListPrice` = '895000.00' ,`Status` = 'Active' ,`StreetName` = 'Thornhill Oaks' ,`StreetNumber` = '27' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3785' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Location!! Gated Community with a total of only 29 homes! Near I-10 so close to downtown! Large home on large lot! Garage Apartment for Guests or Family Members! Large Master Bedroom with Coffered Ceiling and Bonus Storage Area ! Large Master Bath! Game Rom Down! Bedroom/Office Down! Large Bedrooms Up! Oversized Garage! Recent Roof and AC Units! Generac Home Generator!! Lots of Azaleas!! Great Family Home!' ,`Acres` = '1.094' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 THORNHILL U/R' ,`LotDesciption` = 'Cul-De-Sac,Wooded' ,`LotSize` = '47654' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'NORMANDY CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'CUNNINGHAM MIDDLE SCHOOL (GALENA PARK)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Thornhill U/R' ,`TaxAmount` = '8589' ,`TaxRate` = '2.2994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700627' WHERE `Matrix_Unique_ID` = '211443828' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T14:16:42.793' ,`MLSNumber` = '73491451' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.337656' ,`Longitude` = '-95.318454' ,`PhotoCount` = '23' ,`PostalCode` = '77303' ,`RoomCount` = '6' ,`ListPrice` = '318328.00' ,`Status` = 'Active' ,`StreetName` = 'Shoreview' ,`StreetNumber` = '304' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 4 bed 2 bath home located in the Lakes at Crockett Martin subdivision! This home boasts a masterfully planned open concept with high ceilings, vinyl flooring throughout the common areas, and generously sized bedrooms. The kitchen flaunts gorgeous backsplash, a breakfast bar, and opens up to the family room with an adjacent breakfast room. The primary bedroom is oversized and features an en-suite bath boasting dual sinks, a separate garden tub + shower, and a walk-in closet. Exterior features include a fenced-in backyard and an attached 2-car garage. This home is priced to sell and won\'t last long! Schedule a private tour today!' ,`Acres` = '0.1722' ,`Area` = '19' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S929600 - THE LAKES AT CROCKETT MARTIN 01, BLOCK 2, LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Lakes At Crockett Martin 01' ,`TaxAmount` = '574' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700628' WHERE `Matrix_Unique_ID` = '211443833' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T14:23:30.720' ,`MLSNumber` = '86878152' ,`ListAgentFullName` = 'Norma Hernandez' ,`ListOfficeName` = 'Greg Flaniken & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.950370' ,`Longitude` = '-95.366006' ,`PhotoCount` = '24' ,`PostalCode` = '77541' ,`RoomCount` = '7' ,`ListPrice` = '125000.00' ,`Status` = 'Active' ,`StreetName` = '7th' ,`StreetNumber` = '1407' ,`StreetSuffix` = 'Street' ,`City` = 'Freeport' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This would be a great starter home or investment property. Home features 2 Bedrooms, 1 bath with a bonus room that could be converted to a 3rd bedroom or office. Original wood floors throughout except in the kitchen & bathroom. Oversized 30x50 slab in the back yard that fits over 6 vehicles. Please note this house is being sold as-is. Schedule your appointment today.' ,`Acres` = '0.1607' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'FREEPORT, BLOCK 155, LOT 7' ,`LotDesciption` = 'Other' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Freeport' ,`TaxAmount` = '1208' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1942' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700628' WHERE `Matrix_Unique_ID` = '211446213' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T15:57:24.513' ,`MLSNumber` = '80574633' ,`ListAgentFullName` = 'Dayna Simmons' ,`ListOfficeName` = 'Dayna Simmons Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.097152' ,`Longitude` = '-93.774126' ,`PhotoCount` = '26' ,`PostalCode` = '77630' ,`RoomCount` = '8' ,`ListPrice` = '135000.00' ,`Status` = 'Active' ,`StreetName` = 'Gardenia' ,`StreetNumber` = '526' ,`StreetSuffix` = 'Avenue' ,`City` = 'Orange' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out this precious 4 bedroom home situated in Orange off of Gardenia Avenue. This home features lush green grass and a fenced in back-yard. Host gatherings in the spacious living room while whipping up your favorite party recipe in the adorable kitchen with lots of built-in storage! Hang a hammock on the back patio and relax to the sounds of nature while reading a good book. This home has also never flooded per the seller. You will fall in love with the potential this home has to offer. Call us today!' ,`Acres` = '0.193' ,`Area` = '50' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ROSELAWN, LOT 30, ACRES 0.193' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8407' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '270 - West Orange-Cove Consolidated' ,`SchoolElementary` = 'WEST ORANGE-STARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST ORANGE-STARK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST ORANGE-STARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Roselawn' ,`TaxAmount` = '2249' ,`TaxRate` = '2.779' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663700628' WHERE `Matrix_Unique_ID` = '211475722' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T14:44:29.557' ,`MLSNumber` = '45874205' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.756000' ,`Longitude` = '-95.768635' ,`PhotoCount` = '28' ,`PostalCode` = '77494' ,`RoomCount` = '12' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Lodge Meadows' ,`StreetNumber` = '23015' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3172' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fall in love with this wonderful 4-bedroom, 3.5-bathroom home in Cinco Ranch – Greenway Village S, which features a brick front, crown molding, a brand-new roof, gas fireplace, 2-car detached garage, spacious mud room, study with French doors, formal dining room, game room, and a comfortable backyard. The island kitchen is complete with a tile backsplash, electric cooktop, built-in desk, breakfast bar, and dining area. Unwind in the large primary suite, boasting a walk-in closet, dual vanities, a tub, and separate shower. Community comforts include a pool, park, basketball court, playground, and walking trails. Situated off the Grand Parkway, residents are minutes from LaCenterra at Cinco Ranch, Katy Mills Mall, Katy Asian Town, and Westgate Marketplace. Find nearby outdoor recreation at The Golf Club at Cinco Ranch, Buffalo Bayou Nature Trails, and Typhoon Texas. Zoned to the highly acclaimed Katy ISD. HOUSE BEING SOLD AS-IS.' ,`Acres` = '0.1809' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH GREENWAY VILLAGE SEC 8, BLOCK 1, LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7879' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'FIELDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch Greenway Village' ,`TaxAmount` = '8575' ,`TaxRate` = '2.4795' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700628' WHERE `Matrix_Unique_ID` = '211569760' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T15:08:35.077' ,`MLSNumber` = '80774929' ,`ListAgentFullName` = 'Lucy Ware' ,`ListOfficeName` = 'Birdsong Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.971706' ,`Longitude` = '-95.493293' ,`PhotoCount` = '32' ,`PostalCode` = '77541' ,`RoomCount` = '5' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Cotton' ,`StreetNumber` = '215' ,`StreetSuffix` = 'Street' ,`City` = 'Jones Creek' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Jones Creek! This home sits on over a 1/2 acre. It\'s a 4 bedroom, 1.5 bathroom, 1 car attached garage. The kitchen opens to the living and dining area. The primary bedroom is spacious. You\'ll absolutely love the big fenced in yard. Plenty of space to enjoy outside. 2 storage sheds. Close to Stephen F Austin Elementary. Call today for your private showing.' ,`Acres` = '0.5785' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'JONES CREEK TERRACE (A0020 S F AUSTIN DIV 17)(JONES CREEK) B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '25199' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jones Creek Terrace' ,`TaxAmount` = '2942' ,`TaxRate` = '2.5124' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700628' WHERE `Matrix_Unique_ID` = '211580694' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T14:02:22.870' ,`MLSNumber` = '3988567' ,`ListAgentFullName` = 'Erika Barrera' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.439529' ,`Longitude` = '-95.451825' ,`PhotoCount` = '23' ,`PostalCode` = '77378' ,`RoomCount` = '7' ,`ListPrice` = '272000.00' ,`Status` = 'Active' ,`StreetName` = 'Buffalo' ,`StreetNumber` = '5516' ,`StreetSuffix` = 'Circle' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HOME SWEET HOME! Pristine two-story home, nestled on a premium corner lot fully fenced for maximum privacy. Boasts a natural lit open floor plan, soaring high ceilings, warm neutral tones, tile & carpet throughout. A spacious open kitchen offers quartz countertops, a new GE range & spacious kitchen cabinets making this ideal for entertaining. Main level features a primary bedroom with a large walk in closet & en suite bathroom with dual sinks, soaking tub & separate shower. The second floor features 2 additional bedrooms with walk-in closets, a full bathroom & a game room/loft. Ready for summer? Step out into this oversize backyard & extended patio making this ideal for summer barbecues. As if this wasn’t enough, this home also includes a water softener. Don’t miss out on this rare opportunity & schedule your private showing today!' ,`Acres` = '0.1515' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willis Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CADDO VILLAGE, LOT 189' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Caddo Village' ,`TaxAmount` = '3780' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700628' WHERE `Matrix_Unique_ID` = '211622732' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T15:41:50.617' ,`MLSNumber` = '89314837' ,`ListAgentFullName` = 'Javier Vasquez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806927' ,`Longitude` = '-95.479627' ,`PhotoCount` = '17' ,`PostalCode` = '77055' ,`RoomCount` = '6' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Counter Point' ,`StreetNumber` = '2003' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1381' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained corner lot house 3/2/1, Living are with high ceiling and fire place, open floor plan, vinyl flooring, double pane windows, roof approximately 5 years, Spacious screened back cover patio, large Back yard,\r\nWalking distance to School, easy Access to I-10 and 290....Don\'t miss this opportunity!!!!' ,`Acres` = '0.1928' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 6 LONG POINT OAKS' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TREASURE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Long Point Oaks' ,`TaxAmount` = '5860' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700628' WHERE `Matrix_Unique_ID` = '211629558' --> Updated record success