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-15T16:07:27.173' ,`MLSNumber` = '18492661' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.342225' ,`Longitude` = '-95.026098' ,`PhotoCount` = '15' ,`PostalCode` = '77563' ,`RoomCount` = '7' ,`ListPrice` = '279990.00' ,`Status` = 'Active' ,`StreetName` = 'Parkview' ,`StreetNumber` = '7403' ,`StreetSuffix` = 'Drive' ,`City` = 'Hitchcock' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1604' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This well-designed three-bedroom home with a private owner’s suite and walk-in closet has an option for a fourth bedroom. The spacious kitchen/dining area and massive family room are perfect for entertaining. The flex space allows for either a fourth bedroom, study, formal dining area, game room, or anything your heart desires.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hitchcock' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 16, Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Parkview Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699055' WHERE `Matrix_Unique_ID` = '197105439' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T16:30:56.000' ,`MLSNumber` = '71345485' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.508492' ,`Longitude` = '-95.408925' ,`PhotoCount` = '28' ,`PostalCode` = '77578' ,`RoomCount` = '8' ,`ListPrice` = '578000.00' ,`Status` = 'Active' ,`StreetName` = 'Broad Reach' ,`StreetNumber` = '2922' ,`StreetSuffix` = 'Road' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2974' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built by Empire Communities - Estimated October completion! You will love this charming, gated community with amenities galore. Located off of the 288 Corridor and C. R. 58, Newport Lake Estates offers the lifestyle you are looking for. Vibrant community has easy access to the Medical Center, Downtown Houston and Galveston. No back neighbor homesite offering peaceful scenery. Empire\'s gorgeous Morgan floorplan. Spacious foyer with 19\" tall ceilings. Kitchen offers custom cabinets, trendy backsplash, quartz countertops, and a living space with tons of natural light and plenty of room for entertaining. Private owner\'s suite has a ton of characters, vaulted ceiling and many windows. Oversized covered patio with a ceiling fan! Don\'t miss an opportunity to take a stroll in the gated community to visit all of the great amenities Newport Lake Estates has to offer, basketball, volleyball, fishing, boating, and more. *photos are representative, Finishes and selections will differ.' ,`Acres` = '0.1653' ,`Area` = '5' ,`BuilderName` = 'Empire communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NEWPORT LAKE ESTATES SEC 2 (A0299 HT&BRR) (MANVEL) BLK 6 LOT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '935' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Lake Estates' ,`TaxAmount` = '2019' ,`TaxRate` = '3.7392' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699055' WHERE `Matrix_Unique_ID` = '204826432' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T16:29:38.907' ,`MLSNumber` = '94576770' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.508622' ,`Longitude` = '-95.412110' ,`PhotoCount` = '17' ,`PostalCode` = '77578' ,`RoomCount` = '7' ,`ListPrice` = '545000.00' ,`Status` = 'Active' ,`StreetName` = 'Broad Reach' ,`StreetNumber` = '2726' ,`StreetSuffix` = 'Road' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2880' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built by Empire communities -Estimated October completion! You will love this charming gated community with amenities galore. Located off of the 288 Corridor and C. R. 58, Newport Lake Estates offers the lifestyle you are looking for. Vibrant community has easy acess to the Medical Center, Downtown Houston, and Galveston. No back neighbor homesite offering peaceful scenery. Empire\'s gourgeous Burleson floorplan offers a spacious foyer with 11\' tray ceilings. The kitchen offers light gray cabinets, trendy backsplash, quartz countertops, and a living space with tons of natural light and plenty of room for entertaining. Private owner\'s suite has a ton of character. Oversized covered atio with a ceiling fan! Don\'t miss an opportunity to take a stroll in the gated community to visit all the great amenities Newport Lake Estates has to offer, basketball volleyball, fishing, boating, and more. *Photos are representative, finishes and selections will differ.' ,`Acres` = '0.1653' ,`Area` = '5' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NEWPORT LAKE ESTATES SEC 2 (A0299 HT&BRR) (MANVEL) BLK 5 LOT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '935' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Lake Estates' ,`TaxAmount` = '2019' ,`TaxRate` = '3.78' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699055' WHERE `Matrix_Unique_ID` = '204830372' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T16:04:57.187' ,`MLSNumber` = '93306400' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.406500' ,`Longitude` = '-95.055396' ,`PhotoCount` = '18' ,`PostalCode` = '77568' ,`RoomCount` = '9' ,`ListPrice` = '429990.00' ,`Status` = 'Active' ,`StreetName` = 'Vanilla Sky' ,`StreetNumber` = '2725' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Highly sought after CastleRock \"Glenwood 1.5\" Silver Series floor plan in Gated Section of Lago Mar\'s Master Planned Community. Home of the largest Crystal Lagoon in Texas. Upgrades include a Large Covered Back Patio, Tile throughout all main living areas, a Beautiful Glass Entryway Door, White Stone Elevation with a front Patio and Cedar Beams. The kitchen is every cook\'s dream with plenty of Countertops, Cabinetry, and Pantry Space. High Ceiling throughout the home. Bonus Room with private full bath, study, and prewired entertainment package. Master Bedroom has lots of brightness. Master Bath has a relaxing soaker tub and a separate shower with a bench. Large Utility room and 2 Car Garage.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mi/Lenders Approval,Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16, Block 3, Section 5-1' ,`LotDesciption` = 'Greenbelt,Other,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699056' WHERE `Matrix_Unique_ID` = '205106722' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T16:26:22.587' ,`MLSNumber` = '69914303' ,`ListAgentFullName` = 'Randall Hon' ,`ListOfficeName` = 'Edward G Rizk' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.669674' ,`Longitude` = '-95.449451' ,`PhotoCount` = '18' ,`PostalCode` = '77035' ,`RoomCount` = '10' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Nenana' ,`StreetNumber` = '4307' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2113' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location! Location! Location! Gorgeous updated and remodeled home in established Willow Meadows Subdivision. Four large bedrooms with two full baths including a two car detached garage with additional work area. Formal living, formal dining and large den with updated / refinished hardwood floors. Completely remodeled kitchen including cabinets, granite counters, microwave, built-in oven and new counter top range and new dishwasher. Kitchen also includes an oversized walk-in pantry. Inside utility room for clothes washer and dryer. Executive Master bath includes a jacuzzi tub / shower. and walk-in closet, Abundance of closet / storage space. Roof 5 Years old *New interior paint, double pane windows and much much more. Don\'t miss this awesome opportunity.' ,`Acres` = '0.2351' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 5 WILLOW MEADOWS SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Meadows 4' ,`TaxAmount` = '6300' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699056' WHERE `Matrix_Unique_ID` = '205306937' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T16:03:57.300' ,`MLSNumber` = '74845102' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.408054' ,`Longitude` = '-95.056904' ,`PhotoCount` = '14' ,`PostalCode` = '77568' ,`RoomCount` = '6' ,`ListPrice` = '379990.00' ,`Status` = 'Active' ,`StreetName` = 'Oleander Bay' ,`StreetNumber` = '13014' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Highly sought after CastleRock \"Greeley\" Silver Series floor plan in Gated Section of Lago Mar\'s Master Planned Community. Home of the largest Crystal Lagoon in Texas. Upgrades include a Large Covered Back Patio, Tile throughout all main living areas, Beautiful Glass Entryway Door, White Stone Elevation with front Patio and Cedar Beams. The kitchen is every cook\'s dream with plenty of Countertops, White Cabinetry, and Pantry Space. High Ceiling throughout the home. Bonus Room with private full bath, study, and prewired entertainment package. Master Bedroom has lots of brightness and a super shower in lieu of tub. Large Utility room and 2 Car Garage.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mi/Lenders Approval,Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4, Block 1, Section 5-1' ,`LotDesciption` = 'Greenbelt,Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699056' WHERE `Matrix_Unique_ID` = '205600747' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T16:04:32.583' ,`MLSNumber` = '96757262' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.407463' ,`Longitude` = '-95.057786' ,`PhotoCount` = '17' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '425990.00' ,`Status` = 'Active' ,`StreetName` = 'Oleander Bay' ,`StreetNumber` = '13029' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This three-bed, two-bath home includes a large family room and study which provides the luxury of being able to work from home.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mi/Lenders Approval,Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13, Block 2, Section 5-1' ,`LotDesciption` = 'Corner,Cul-De-Sac,Greenbelt' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.5' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699056' WHERE `Matrix_Unique_ID` = '205867603' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T16:29:45.380' ,`MLSNumber` = '42835884' ,`ListAgentFullName` = 'Kimberly Williams' ,`ListOfficeName` = '2011 AMERICAN REAL ESTATE CO.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.122413' ,`Longitude` = '-94.124811' ,`PhotoCount` = '8' ,`PostalCode` = '77703' ,`RoomCount` = '7' ,`ListPrice` = '80900.00' ,`Status` = 'Active' ,`StreetName` = 'Taylor' ,`StreetNumber` = '2465' ,`StreetSuffix` = 'Street' ,`City` = 'Beaumont' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1052' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great investment Opportunity!! This cozy, ready to move in home sits on 2 fenced in lots. It consists of 3 bedrooms and one bath perfect for a family just starting off. This property was used as a rental that generated $1100 per month. Central air/heat. NEVERFLOODED!! Don’t sleep on this great investment it won’t last long!' ,`Acres` = '0.3214' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PINECREST L 3 L 4 B 57' ,`LotDesciption` = 'Cleared' ,`LotSize` = '14000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'MARTIN ELEMENTARY SCHOOL (BEAUMONT)' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Pinecrest' ,`TaxAmount` = '898' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663699056' WHERE `Matrix_Unique_ID` = '207035713' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T16:12:14.673' ,`MLSNumber` = '65603777' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.836110' ,`Longitude` = '-95.855761' ,`PhotoCount` = '14' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '370990.00' ,`Status` = 'Active' ,`StreetName` = 'Cambria Green' ,`StreetNumber` = '224' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1850' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'END OF SUMMER SAVINGS! 1 story COmanche Floorplan by CastleRock Communities in Sunterra. 3 bedrooms (maximum of 4) with study, 2 baths, and 2 car garage. Soaring high ceilings, wonderful layout, and huge family great room with open kitchen and\r\ndining. Covered front porch and covered rear porch. Elegant designer colors and options including\r\nluxury vinyl flooring in all main living areas, full blinds, upgraded cabinets, and much more! Sunterra Community features a 3.5-acre Crystal Blue Lagoon with white sand beaches, palm trees, cabanas, watercraft rentals of kayaks, paddleboards, etc, and clubhouse, event center, swim-up beach bar, swimming pool, and splash pad all in Amazing Katy ISD! Close to everything!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25, Block 1, Section 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699056' WHERE `Matrix_Unique_ID` = '207131422' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T16:04:16.500' ,`MLSNumber` = '89819889' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405266' ,`Longitude` = '-95.055243' ,`PhotoCount` = '20' ,`PostalCode` = '77568' ,`RoomCount` = '11' ,`ListPrice` = '409990.00' ,`Status` = 'Active' ,`StreetName` = 'Ocean Breeze' ,`StreetNumber` = '12901' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2544' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Glenwood features three bedrooms, three bathrooms, a massive family room for entertaining and a bonus room w/ bathroom upstairs!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mi/Lenders Approval,Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 35, Block 1, Section 5-1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1630' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Controlled Access,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.5' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699056' WHERE `Matrix_Unique_ID` = '208241368' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T16:05:29.273' ,`MLSNumber` = '33522248' ,`ListAgentFullName` = 'Loretta Moehle' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.642818' ,`Longitude` = '-94.869938' ,`PhotoCount` = '32' ,`PostalCode` = '77351' ,`RoomCount` = '7' ,`ListPrice` = '139900.00' ,`Status` = 'Active' ,`StreetName` = 'Sunrise' ,`StreetNumber` = '304' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '924' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Can you say $20 a month or less for electricity!! This 2/2 home features solar panels that allow just that. Home also includes many updates like: New wood floors in the living room, New AC 2016, Generac Generator, and New metal roof 2020. Home has a two car port, as well as an additional RV port with full hook up. RV cover replaced 2002. The grounds of this property are something to see. Pecan trees and peach tree abound with other scrubs and plants to give you that peaceful feel as you enjoy your property from any of the 318 feet of covered decks, the 201 square feet of screened porch or if you prefer any of the 316 square feet of uncovered porch areas. Yard has full sprinkler system installed. Home is located in a community designed for RV travelers. As such you have the option to join Escapees RV club and have access to all they have to offer. Membership is not mandatory. Come take a look. This is the home you and your RV have been looking for.' ,`Acres` = '0.318' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Rainbow End Section 2 Lot 55PT' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Other' ,`LotSize` = '13852' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Rainbow End' ,`TaxAmount` = '428' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699056' WHERE `Matrix_Unique_ID` = '208249223' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T16:11:56.937' ,`MLSNumber` = '84885507' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.412500' ,`Longitude` = '-95.051475' ,`PhotoCount` = '29' ,`PostalCode` = '77568' ,`RoomCount` = '17' ,`ListPrice` = '599917.00' ,`Status` = 'Active' ,`StreetName` = 'Flora Manor' ,`StreetNumber` = '12623' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Asher V, Elevation A) CURRENTLY BEING BUILT. Two story. 5 bedrooms. 4.5 baths. Elegant double front door entry, family room, informal dining room and study. Spacious island kitchen open to family room. Primary suite with large double walk-in closets and secondary bedroom on first floor. Three additional bedrooms, spacious game room and media room on second floor. Attached 3-car tandem garage. Representing a prime location off I-45 South in the Galveston-Clear Lake corridor, you’ll find Lago Mar and its resort style living! Bay Area breezes will caress you while you lounge on white-sand beaches, swim in Caribbean-blue waters or dine lagoon-side on our beach boardwalk. Lago Mar includes 2 private resident gyms, 2 resident pools, playgrounds and acres of outdoor space. It’s an unparalleled standard of living where life is truly a breeze! Stop by the Westin Homes model home today to find out more about Lago Mar!' ,`Acres` = '0.2491' ,`Area` = '33' ,`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` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 19 BLK 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10852' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '1892' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699057' WHERE `Matrix_Unique_ID` = '208334039' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:16:17.667' ,`MLSNumber` = '86426737' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.437035' ,`Longitude` = '-95.439379' ,`PhotoCount` = '9' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '415555.00' ,`Status` = 'Active' ,`StreetName` = 'Homewood Point' ,`StreetNumber` = '1707' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2175' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one story home features a spacious kitchen with stainless appliances, granite countertops, upgraded 42\" cabinets, vinyl flooring, a walk in pantry and is open to the huge family room. The master suite is separate from the other bedrooms and has a big walk in closet, standup shower and relaxing oval tub in master bath. Covered back patio to complete the house - it just needs you and your family to make it a home. PHOTOS ARE REPRESENTATIVE' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 3 Sec 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699057' WHERE `Matrix_Unique_ID` = '208371175' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:13:20.953' ,`MLSNumber` = '19128777' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.437035' ,`Longitude` = '-95.439379' ,`PhotoCount` = '21' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '396565.00' ,`Status` = 'Active' ,`StreetName` = 'Amador Peak' ,`StreetNumber` = '10602' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Colina Homes- Single Story: Elegant entry with coffered tall ceilings, 4 bedrooms, 3 baths location in our gated section of Sierra Vista! Spacious master closet with his/her sinks and sep. tub\r\nand shower. Tons of Beautiful Finishes included!!Gorgeous kitchen with stunning cabinets, granite\r\nand tiled backslash , Perfect backyard and a Large covered back patio ready for weekend BBQ\'s.\r\nYou\'re going to Love it! Situated in one of Rosharon\'s best communities. and offers everything your\r\nare looking in a family friendly community- amenities located in Sterling Lakes - the spashpad, fitness\r\ncenter, Basketball Court, Lakes & Parks. Crystal Lagoon coming soon! Close to Pearland, Alvin,\r\nManvel, Lake Jackson, 30 minutes from Downtown Houston. SHOP AND WORK IN THE CITY AND\r\nCOME HOME TO A QUIET PEACEFUL COMMUNITY @ SIERRA VISTA! PHOTOS ARE REPRESENTATIVE.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 2 Sec 7' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8616' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699057' WHERE `Matrix_Unique_ID` = '208371545' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:10:15.600' ,`MLSNumber` = '2782526' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.436920' ,`Longitude` = '-95.438449' ,`PhotoCount` = '34' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '366082.00' ,`Status` = 'Active' ,`StreetName` = 'Amador Peak' ,`StreetNumber` = '10718' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1830' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Colina Homes- Single Story: Elegant entry with coffered tall ceilings, bedrooms, 2 baths, located in our gated section of Sierra Vista! Spacious master closet with his/her sinks and sep. tub and shower. Tons of Beautiful Finishes included!!Gorgeous kitchen with stunning cabinets, granite and tiled backslash , Perfect backyard and a Large covered back patio ready for weekend BBQ\'s. You\'re going to Love it! Situated in one of Rosharon\'s best communities. and offers everything your are looking in a family friendly community- amenities located in Sterling Lakes - the spashpad, fitness center, Basketball Court, Lakes & Parks. Crystal Lagoon coming soon! Close to Pearland, Alvin, Manvel, Lake Jackson, 30 minutes from Downtown Houston. SHOP AND WORK IN THE CITY AND COME HOME TO A QUIET PEACEFUL COMMUNITY @ SIERRA VISTA!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14 Block 2 Sec 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7750' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699057' WHERE `Matrix_Unique_ID` = '208371589' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:22:41.930' ,`MLSNumber` = '4995343' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.437750' ,`Longitude` = '-95.434452' ,`PhotoCount` = '40' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '456515.00' ,`Status` = 'Active' ,`StreetName` = 'Tioga View' ,`StreetNumber` = '1719' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2349' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one story home featuring a spacious kitchen with stainless appliances, granite counter tops, upgraded 42\" cabinets, vinyl flooring, a walk in pantry and is open to the huge family room and spacious dining area. The master suite is separate from the other bedrooms and has TWO walk in closets, larger closet has easy access to laundry room, stand up shower and relaxing oval tub in master bath. Covered back patio to complete the house - it just needs you and your family to make it a home.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17 BLK 3 Sec 7' ,`LotDesciption` = 'Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699057' WHERE `Matrix_Unique_ID` = '208371750' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:27:24.000' ,`MLSNumber` = '24377775' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.437772' ,`Longitude` = '-95.434420' ,`PhotoCount` = '27' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '470525.00' ,`Status` = 'Active' ,`StreetName` = 'Tioga View' ,`StreetNumber` = '1807' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2543' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous Colina Home is the ultimate floor plan! When you walk through the front door into the extra large entryway, you will feel right at home. There are 4 bedrooms, 3 bathrooms, plus an office. The living room, kitchen, & dining area are all open to each other with high ceilings. The kitchen features a huge island with seating, 42\" cabinetry, & a walk in pantry. The primary bedroom is tucked away in the back of the home with an extremely spacious en suite bathroom & walk in closet. There is a 3 car garage and a covered back patio. This home is truly beautiful - it just needs you and your family to make it a home.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23 BLK 3 Sec 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699057' WHERE `Matrix_Unique_ID` = '208371773' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:34:59.273' ,`MLSNumber` = '79440780' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.437751' ,`Longitude` = '-95.434410' ,`PhotoCount` = '8' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '524215.00' ,`Status` = 'Active' ,`StreetName` = 'Bear Point' ,`StreetNumber` = '10507' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3256' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous Colina Home is the ultimate floor plan! When you walk through the front door into the extra large entryway, you will feel right at home. There are 4 bedrooms, 3 bathrooms, plus an office. The living room, kitchen, & dining area are all open to each other with high ceilings. The kitchen features a huge island with seating, 42\" cabinetry, & a walk in pantry. The primary bedroom is tucked away in the back of the home with an extremely spacious en suite bathroom & walk in closet. Oversized game room located upstairs with secondary bedroom. 3 car garage and a covered back patio. This home is truly beautiful - it just needs you and your family to make it a home.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 19 BLK 5' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699057' WHERE `Matrix_Unique_ID` = '208371890' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:32:21.733' ,`MLSNumber` = '39938949' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.437035' ,`Longitude` = '-95.439379' ,`PhotoCount` = '21' ,`PostalCode` = '77583' ,`RoomCount` = '11' ,`ListPrice` = '466350.00' ,`Status` = 'Active' ,`StreetName` = 'Plumas Run' ,`StreetNumber` = '10506' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2715' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Colina Home with 4 bedrooms, 2.5 baths, and study there\'s room for everyone! Large study located downstairs. Master bedroom located downstairs just outside the huge living room large enough for the whole family to get together for special occasions and holidays. Beautiful kitchen with upgraded 42\" cabinets, granite countertops, stainless steel appliances and is open to the oversized family room. The master suite features a large walk in closet and a spacious bath with a relaxing soaker tub and separate shower. Large game room located upstairs with a view to the first floor, 3 car garage included. 2\" faux wood blinds save you money and provide privacy from day one. The in wall pest control system protects your home.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11, Block 3, Sec 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.7' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699057' WHERE `Matrix_Unique_ID` = '208712275' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:11:58.650' ,`MLSNumber` = '82939379' ,`ListAgentFullName` = 'Hilary Griffin' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.204116' ,`Longitude` = '-94.934543' ,`PhotoCount` = '50' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '1780000.00' ,`Status` = 'Active' ,`StreetName` = 'Buccaneer' ,`StreetNumber` = '4219' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '3116' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to beachfront living in PIRATES BEACH! Take in the warm ocean breeze from the expansive balcony overlooking the waves or venture out for an easy stroll in the sand...just steps away from your front door. This beautiful home is the perfect beach getaway featuring an inverted floor plan, elevator, elevated ceilings, large bedrooms, and an expansive and welcoming 3rd floor gathering space that combines the kitchen, dining room, and living room. There are multiple decks for outdoor living space which makes entertaining large groups easy and fun. \r\n This home also has a STRONG RENTAL HISTORY for those interested in investment opportunities. Contact agent to schedule your showing today.' ,`Acres` = '0.1389' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 12 BLK 6 PIRATES BEACH SEC 2' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '6050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '3' ,`Style` = 'Other Style' ,`Subdivision` = 'Pirates Beach 2' ,`TaxAmount` = '17885' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699058' WHERE `Matrix_Unique_ID` = '209797139' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T16:12:23.613' ,`MLSNumber` = '11695338' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.409880' ,`Longitude` = '-95.052279' ,`PhotoCount` = '10' ,`PostalCode` = '77568' ,`RoomCount` = '15' ,`ListPrice` = '594357.00' ,`Status` = 'Active' ,`StreetName` = 'Playa Cove' ,`StreetNumber` = '12719' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3211' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Camelot, Elevation A) CURRENTLY BEING BUILT. Large lake front lot. Two story. 4 bedrooms, 3.5 baths. Primary suite downstairs with large walk in closet. Spacious island kitchen with informal dining area open to Family room. Downstairs study. Game room upstairs with Media room and 3 additional bedrooms. Covered patio and 2 car attached garage. Representing a prime location off I-45 South in the Galveston-Clear Lake corridor, you’ll find Lago Mar and its resort style living! Bay Area breezes will caress you while you lounge on white-sand beaches, swim in Caribbean-blue waters or dine lagoon-side on our beach boardwalk. Lago Mar includes 2 private resident gyms, 2 resident pools, playgrounds and acres of outdoor space. It’s an unparalleled standard of living where life is truly a breeze! Stop by the Westin Homes model home today to find out more about Lago Mar!' ,`Acres` = '' ,`Area` = '33' ,`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` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 18 BLK 2' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '8238' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699058' WHERE `Matrix_Unique_ID` = '209903352' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T16:51:01.093' ,`MLSNumber` = '27113180' ,`ListAgentFullName` = 'Randy French' ,`ListOfficeName` = 'Stylecraft Builders, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.177406' ,`Longitude` = '-96.427553' ,`PhotoCount` = '10' ,`PostalCode` = '77833' ,`RoomCount` = '9' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Muscadine' ,`StreetNumber` = '2058' ,`StreetSuffix` = 'Trail' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming three bedroom, two bath home is known for its intelligent use of space and now features an even more open living area. The large kitchen granite-topped island opens up to your living room to provide a cozy flow throughout the home. Your dining area features the most charming window you\'ll ever see. Featuring large walk-in closets, luxury flooring, and volume ceilings - this beauty certainly delivers when it comes to affordable luxury. Additional options include: Stainless steel appliances, exterior coach lighting, decorative tile backsplash, integral blinds in rear door, and a dual primary bathroom vanity.' ,`Acres` = '0.156' ,`Area` = '58' ,`BuilderName` = 'Stylecraft' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S5942 - Vintage Farms S/D # 3, BLOCK 1, Lot 29, ACRES 0.156' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6795' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Vintage Farms' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699058' WHERE `Matrix_Unique_ID` = '210184252' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:15:56.433' ,`MLSNumber` = '70666951' ,`ListAgentFullName` = 'Brian Keith Bexley' ,`ListOfficeName` = 'Bexley Land and Cattle, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.413889' ,`Longitude` = '-97.007553' ,`PhotoCount` = '22' ,`PostalCode` = '78947' ,`RoomCount` = '7' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Hale' ,`StreetNumber` = '504' ,`StreetSuffix` = 'Street' ,`City` = 'Lexington' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Quintessential mid-century home on the most incredible tree-shaded lot, on the best street in town and within walking distance of almost everything in Lexington! Built in 1955, this 3/2 Ranch-Style home has original wood flooring, two-car carport w/alley access, the cutest one-car attached garage and the best tree house/playscape a kid could ever ask for! And yes, it has a white wooden fence! It\'s 1,704 sqft. of nostalgia and a step back to screen doors, summer afternoons spent in a swing under the shade trees and a walk around the square down town! All L.I.S.D. campuses, banking, Post Office, City Hall, Senior Citizen\'s, Snow\'s BBQ, Pizza Pro, Mom and Pop\'s Icehouse, Third Street Deli, The Dowdy House, Circle C Mercantile, a hair salon, a donut shop and at least five churches are within walking distance! Sell your car and move to Lexington! \r\nUnless you need to commute to work and then that\'s easy too! About 1 hour to Austin, 45 minutes to Bastrop and 35 minutes to Taylor and Elgin!' ,`Acres` = '0.2975' ,`Area` = '70' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'NEW TOWN LEXINGTON, BLOCK 14, LOT 7 & S/2 OF 8' ,`LotDesciption` = 'Corner' ,`LotSize` = '12959' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '165 - Lexington' ,`SchoolElementary` = 'LEXINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LEXINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'LEXINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'New Town Lexington' ,`TaxAmount` = '2801' ,`TaxRate` = '2.2448' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699058' WHERE `Matrix_Unique_ID` = '210476008' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T16:11:32.413' ,`MLSNumber` = '91503749' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.409724' ,`Longitude` = '-95.057906' ,`PhotoCount` = '34' ,`PostalCode` = '77568' ,`RoomCount` = '17' ,`ListPrice` = '539853.00' ,`Status` = 'Active' ,`StreetName` = 'Deep Marine' ,`StreetNumber` = '13102' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Wimberly, Elevation A) CURRENTLY BEING BUILT. Two Story. 4 bedrooms, 3.5 baths. Private Primary Suite downstairs with large walk-in closet. Second bedroom downstairs with private bath. Family room, Study and Formal Dining Room. Spacious island kitchen open to family room. Spacious Game Room and Media Room upstairs. Covered patio and attached 3-car tandem garage. Representing a prime location off I-45 South in the Galveston-Clear Lake corridor, you’ll find Lago Mar and its resort style living! Bay Area breezes will caress you while you lounge on white-sand beaches, swim in Caribbean-blue waters or dine lagoon-side on our beach boardwalk. Lago Mar includes 2 private resident gyms, 2 resident pools, playgrounds and acres of outdoor space. It’s an unparalleled standard of living where life is truly a breeze! Stop by the Westin Homes model home today to find out more about Lago Mar!' ,`Acres` = '0.1627' ,`Area` = '33' ,`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` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 23 BLK 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7087' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '1983' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699058' WHERE `Matrix_Unique_ID` = '210601161' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T16:44:23.323' ,`MLSNumber` = '31013513' ,`ListAgentFullName` = 'Candice Cucco' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.299404' ,`Longitude` = '-94.852439' ,`PhotoCount` = '34' ,`PostalCode` = '77327' ,`RoomCount` = '6' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2255' ,`StreetNumber` = '441' ,`StreetSuffix` = 'Road' ,`City` = 'Cleveland' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1152' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming country home sitting on 10.9 stunning acres in Tarkington ISD. Surrounded by mature timber giving you a peaceful and secluded homestead. Offering an array of fruit trees, berry bushes, a garden, and tons of wildlife, true country living at it’s finest.This warm and cozy home boast laminate and luxury vinyl plank floors throughout, a spacious kitchen with an abundance of cabinet and counter space, and beautiful travertine backsplash in both the kitchen and bathroom. Home was completely renovated and a new aerobic system installed in 2010 and the HVAC system, hot water heater and flooring were all replaced in 2020. Electrical, water, and septic have been ran to the side of the property perfectly set up to add a shop. Sitting high and dry in the Davis Hill subdivision, this property is one you won’t want to miss!' ,`Acres` = '10.93' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'DAVIS HILLS BIG THICKET PARK, LOT 170, ACRES 10.91' ,`LotDesciption` = 'Cul-De-Sac,Wooded' ,`LotSize` = '475240' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'TARKINGTON PRIMARY SCHOOL' ,`SchoolHigh` = 'TARKINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'TARKINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Davis Hills Big Thicket Park' ,`TaxAmount` = '2357' ,`TaxRate` = '1.53' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699058' WHERE `Matrix_Unique_ID` = '210758954' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:19:28.540' ,`MLSNumber` = '81382823' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.427733' ,`Longitude` = '-95.451362' ,`PhotoCount` = '9' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '433645.00' ,`Status` = 'Active' ,`StreetName` = 'Amador Peak' ,`StreetNumber` = '10630' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2349' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one story with four bedrooms, three full baths plus study/dining room, 2 sinks in primary bath with garden Tub and large standalone shower. utility room connect to spaces primary closet. Additional closet in primary off primary bath. High ceiling granite kitchen with deep vinderman sink 42 inch cabinets. Stainless steel five burner gas range and With microwave and dishwasher 2\" blinds along with windstorm panels. Est completion: Oct 2022' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 BLK 2 Sec 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7748' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.606' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699059' WHERE `Matrix_Unique_ID` = '211025773' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:18:15.753' ,`MLSNumber` = '74971228' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.427733' ,`Longitude` = '-95.451362' ,`PhotoCount` = '9' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '430795.00' ,`Status` = 'Active' ,`StreetName` = 'Amador Peak' ,`StreetNumber` = '10606' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2349' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one story with four bedrooms, three full baths plus study/dining room, 2 sinks in primary bath with garden Tub and large standalone shower. utility room connect to spaces primary closet. Additional closet in primary off primary bath. High ceiling granite kitchen with deep vinderman sink 42 inch cabinets. Stainless steel five burner gas range and With microwave and dishwasher 2\" blinds along with windstorm panels. Est completion: Oct 2022' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 BLK 2 Sec 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7748' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.606' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699059' WHERE `Matrix_Unique_ID` = '211154697' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:11:56.343' ,`MLSNumber` = '94507136' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.437801' ,`Longitude` = '-95.434385' ,`PhotoCount` = '9' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '415240.00' ,`Status` = 'Active' ,`StreetName` = 'Amador Peak' ,`StreetNumber` = '10811' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Colina Homes- Single Story: Elegant entry with coffered tall ceilings, 4 bedrooms, 3 baths location in our gated section of Sierra Vista! Spacious master closet with his/her sinks and sep. tub\r\nand shower. Tons of Beautiful Finishes included!!Gorgeous kitchen with stunning cabinets, granite\r\nand tiled backslash , Perfect backyard and a Large covered back patio ready for weekend BBQ\'s.\r\nYou\'re going to Love it! Situated in one of Rosharon\'s best communities. and offers everything your\r\nare looking in a family friendly community- amenities located in Sterling Lakes - the spashpad, fitness\r\ncenter, Basketball Court, Lakes & Parks. Crystal Lagoon coming soon! Close to Pearland, Alvin,\r\nManvel, Lake Jackson, 30 minutes from Downtown Houston. SHOP AND WORK IN THE CITY AND\r\nCOME HOME TO A QUIET PEACEFUL COMMUNITY @ SIERRA VISTA! PHOTOS ARE REPRESENTATIVE.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21 Block 1 Sec 7' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7920' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699059' WHERE `Matrix_Unique_ID` = '211183714' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:15:09.950' ,`MLSNumber` = '89485937' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.437799' ,`Longitude` = '-95.434453' ,`PhotoCount` = '9' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '415140.00' ,`Status` = 'Active' ,`StreetName` = 'Tioga View' ,`StreetNumber` = '1803' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Colina Homes- Single Story: Elegant entry with coffered tall ceilings, 4 bedrooms, 3 baths location in our gated section of Sierra Vista! Spacious master closet with his/her sinks and sep. tub\r\nand shower. Tons of Beautiful Finishes included!!Gorgeous kitchen with stunning cabinets, granite\r\nand tiled backslash , Perfect backyard and a Large covered back patio ready for weekend BBQ\'s.\r\nYou\'re going to Love it! Situated in one of Rosharon\'s best communities. and offers everything your\r\nare looking in a family friendly community- amenities located in Sterling Lakes - the spashpad, fitness\r\ncenter, Basketball Court, Lakes & Parks. Crystal Lagoon coming soon! Close to Pearland, Alvin,\r\nManvel, Lake Jackson, 30 minutes from Downtown Houston. SHOP AND WORK IN THE CITY AND\r\nCOME HOME TO A QUIET PEACEFUL COMMUNITY @ SIERRA VISTA! PHOTOS ARE REPRESENTATIVE.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22 Block 3 Sec 7' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8374' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699059' WHERE `Matrix_Unique_ID` = '211184606' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:25:44.053' ,`MLSNumber` = '60669576' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.437772' ,`Longitude` = '-95.434420' ,`PhotoCount` = '22' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '449825.00' ,`Status` = 'Active' ,`StreetName` = 'Homewood Point' ,`StreetNumber` = '1811' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2543' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous Colina Home is the ultimate floor plan! When you walk through the front door into the extra large entryway, you will feel right at home. There are 4 bedrooms, 3 bathrooms, plus an office. The living room, kitchen, & dining area are all open to each other with high ceilings. The kitchen features a huge island with seating, 42\" cabinetry, & a walk in pantry. The primary bedroom is tucked away in the back of the home with an extremely spacious en suite bathroom & walk in closet. There is a 3 car garage and a covered back patio. This home is truly beautiful - it just needs you and your family to make it a home.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17 BLK 5 Sec 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699059' WHERE `Matrix_Unique_ID` = '211185083' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T16:05:04.580' ,`MLSNumber` = '96154556' ,`ListAgentFullName` = 'Dianne Stone' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.968542' ,`Longitude` = '-95.961794' ,`PhotoCount` = '19' ,`PostalCode` = '77414' ,`RoomCount` = '4' ,`ListPrice` = '197280.00' ,`Status` = 'Active' ,`StreetName` = 'Briar' ,`StreetNumber` = '3412' ,`StreetSuffix` = 'Lane' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1644' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is only limited by the buyer\'s imagination! New roof in 2022 adds value to this 3 bed, 2 bath home. If you love vintage styling, you may want to keep the tiles in the kitchen and bathrooms; however, if a modern touch is more your style, then a remodel would be fun! Located in the very desirable Briar Meadow Subdivision, this home had only 1 owner. Now, it\'s time for a new family to make memories here. Fully fenced backyard, covered porch, 2 living areas and a 2 car attached garage is just the right amount of space for a starter home or a buyer looking to downsize. INVESTORS: this could be a perfect addition to your rental inventory. Bring your ideas and come take a look today!' ,`Acres` = '0.22' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BRIAR MEADOW S/D, BLOCK 4, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9583' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front,No Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Briar Meadow Sub' ,`TaxAmount` = '3424' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699059' WHERE `Matrix_Unique_ID` = '211194144' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:30:26.857' ,`MLSNumber` = '90884111' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.437772' ,`Longitude` = '-95.434420' ,`PhotoCount` = '22' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '471900.00' ,`Status` = 'Active' ,`StreetName` = 'Amador Peak' ,`StreetNumber` = '10631' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2543' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one story with 4 bedrooms, 3 full baths plus study/dining room. Two sinks in primary bath with garden tub and stand-alone shower with seat, XLarge primary closet. High ceilings throughout the home with vestibule in the entry. Granite Kitchen with deep under-mount sink. 42” cabinets, Stainless Steel 5 burner gas range, microwave and dishwasher 2” blinds standard along with windstorm panels, large covered patio. EST Completion 10/24/22. PICTURES ARE REPRESENTATIVE- Not the actual home.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 BLK 1 Sec 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699059' WHERE `Matrix_Unique_ID` = '211200636' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T16:07:42.510' ,`MLSNumber` = '51202771' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.401876' ,`Longitude` = '-95.068858' ,`PhotoCount` = '28' ,`PostalCode` = '77568' ,`RoomCount` = '16' ,`ListPrice` = '509752.00' ,`Status` = 'Active' ,`StreetName` = 'Lierna' ,`StreetNumber` = '2218' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3138' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Albany, Elevation F) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, study and formal dining room. Spacious island kitchen open to family room. Primary suite with large walk-in closet. Three additional bedrooms, spacious game room and media room on second floor. Covered patio and attached 2-car garage. Representing a prime location off I-45 South in the Galveston-Clear Lake corridor, you’ll find Lago Mar and its resort style living! Bay Area breezes will caress you while you lounge on white-sand beaches, swim in Caribbean-blue waters or dine lagoon-side on our beach boardwalk. Lago Mar includes 2 private resident gyms, 2 resident pools, playgrounds and acres of outdoor space. It’s an unparalleled standard of living where life is truly a breeze! Stop by the Westin Homes model home today to find out more about Lago Mar!' ,`Acres` = '' ,`Area` = '33' ,`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` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 14 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6240' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699060' WHERE `Matrix_Unique_ID` = '211230758' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T16:07:02.480' ,`MLSNumber` = '77019490' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.402324' ,`Longitude` = '-95.070747' ,`PhotoCount` = '30' ,`PostalCode` = '77568' ,`RoomCount` = '16' ,`ListPrice` = '499232.00' ,`Status` = 'Active' ,`StreetName` = 'Bellano Bay' ,`StreetNumber` = '2225' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Albany, Elevation G) CURRENTLY BEING BUILT. Two story. 4 bedrooms. 3.5 baths. Family room, study and formal dining room. Spacious island kitchen open to family room. Primary suite with large walk-in closet. Three additional bedrooms, spacious game room and media room on second floor. Covered patio and attached 2-car garage. Representing a prime location off I-45 South in the Galveston-Clear Lake corridor, you’ll find Lago Mar and its resort style living! Bay Area breezes will caress you while you lounge on white-sand beaches, swim in Caribbean-blue waters or dine lagoon-side on our beach boardwalk. Lago Mar includes 2 private resident gyms, 2 resident pools, playgrounds and acres of outdoor space. It’s an unparalleled standard of living where life is truly a breeze! Stop by the Westin Homes model home today to find out more about Lago Mar!' ,`Acres` = '' ,`Area` = '33' ,`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` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 4 BLK 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699060' WHERE `Matrix_Unique_ID` = '211231185' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:49:40.303' ,`MLSNumber` = '11281617' ,`ListAgentFullName` = 'Kleber Pita' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.732290' ,`Longitude` = '-95.317896' ,`PhotoCount` = '15' ,`PostalCode` = '77023' ,`RoomCount` = '2' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Hughes' ,`StreetNumber` = '1308' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1156' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nicely updated and tenant occupied single family property in developing East End Revitalized. Single-family home offers two bed one bath. This property has been thoughtfully updated for easy rental maintenance. This is one of several properties available making up a combined 19,000+ sq ft of land in the popular East End Revitalized. (See MLS #’s 3389831 and 32285320 for full portfolio). Rent rolls are available upon request.' ,`Acres` = '0.1936' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 14 & 15 BLK 4 DISSEN HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8433' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CARRILLO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Spanish' ,`Subdivision` = 'Dissen Heights' ,`TaxAmount` = '3871' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699060' WHERE `Matrix_Unique_ID` = '211245179' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:51:05.490' ,`MLSNumber` = '29790362' ,`ListAgentFullName` = 'Kleber Pita' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.787934' ,`Longitude` = '-95.325065' ,`PhotoCount` = '13' ,`PostalCode` = '77026' ,`RoomCount` = '3' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Wylie' ,`StreetNumber` = '4438' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This three bedroom / one bathroom single-family home is well positioned on a corner lot peppered with mature trees. Freshly refurbished and well maintained to enjoy today’s living styles. This home is currently tenant occupied and rent rolls are available upon request. Located near plenty of parks and restaurants and just minutes from Downtown Houston as well as the highly anticipated East River Project.' ,`Acres` = '0.1027' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR D BLK 8 GRANT PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4472' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DOGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grant Park' ,`TaxAmount` = '3087' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699060' WHERE `Matrix_Unique_ID` = '211245226' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:48:50.587' ,`MLSNumber` = '21394981' ,`ListAgentFullName` = 'Kleber Pita' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781525' ,`Longitude` = '-95.320382' ,`PhotoCount` = '12' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '117500.00' ,`Status` = 'Active' ,`StreetName` = 'Gagne' ,`StreetNumber` = '2311' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two bedroom, one-bath home currently being used as an income-producing rental property. This is one of several properties available making up a combined 20,000+ sq ft of land in popular Denver Harbor. Property is ideal to buy now, cash flow, and redevelop later.' ,`Acres` = '0.031' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Special Addendum' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S 27.00 FT OF LT 5 & S 27.00 FT OF E 1/2 OF LT 4 BLK 30 GAGN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1350' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead Add' ,`TaxAmount` = '704' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699060' WHERE `Matrix_Unique_ID` = '211245229' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:50:27.693' ,`MLSNumber` = '96850146' ,`ListAgentFullName` = 'Kleber Pita' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781522' ,`Longitude` = '-95.320938' ,`PhotoCount` = '13' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '165000.00' ,`Status` = 'Active' ,`StreetName` = 'Solo' ,`StreetNumber` = '2310' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This cozy Gagne Homestead home with a land square footage of 1,739 is superbly nestled in the heart of Houston. Within walking distance to Atherton Elementary school and Boyce Dorian Park. This two bedroom / one bathroom single family home features new flooring throughout, freshly painted walls and refurbished bathrooms.' ,`Acres` = '0.0399' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'S 34.78 FT OF LT 1 BLK 30 GAGNE HOMESTEAD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1739' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead Add' ,`TaxAmount` = '2398' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699060' WHERE `Matrix_Unique_ID` = '211245231' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:50:07.150' ,`MLSNumber` = '28339721' ,`ListAgentFullName` = 'Kleber Pita' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.784380' ,`Longitude` = '-95.314517' ,`PhotoCount` = '15' ,`PostalCode` = '77020' ,`RoomCount` = '3' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Sam Wilson' ,`StreetNumber` = '2421' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1468' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy single-family home in Denver Harbor with a studio apartment sits on a 5000-square foot lot is an ideal rental property or opportunity to house hack by renting out the studio apartment. Both units are currently tenant-occupied. Rent rolls are available upon request.' ,`Acres` = '0.1148' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 15 CHEW F F' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chew F F' ,`TaxAmount` = '3487' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663699060' WHERE `Matrix_Unique_ID` = '211245243' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:50:25.043' ,`MLSNumber` = '9857739' ,`ListAgentFullName` = 'Kleber Pita' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781663' ,`Longitude` = '-95.320263' ,`PhotoCount` = '15' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '150000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee' ,`StreetNumber` = '4920' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-bedroom, one-bath home currently being used as an income-producing rental property. This is one of several properties available making up a combined 20,000+ sq ft of land in popular Denver Harbor. Property is ideal to buy now, cash flow, and redevelop later.' ,`Acres` = '0.0419' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'E 1/2 OF N 73.00 FT OF LT 5 BLK 30 GAGNE HOMESTEAD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead Add' ,`TaxAmount` = '850' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699061' WHERE `Matrix_Unique_ID` = '211290427' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:49:43.750' ,`MLSNumber` = '39949606' ,`ListAgentFullName` = 'Kleber Pita' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781643' ,`Longitude` = '-95.320379' ,`PhotoCount` = '15' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '150000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee' ,`StreetNumber` = '4918' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-bedroom, one-bath home currently being used as an income-producing rental property. This is one of several properties available making up a combined 20,000+ sq ft of land in popular Denver Harbor. Property is ideal to buy now, cash flow, and redevelop later.' ,`Acres` = '0.0419' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'W 1/2 OF N 73.00 FT OF LT 5 BLK 30 GAGNE HOMESTEAD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead Add' ,`TaxAmount` = '886' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699061' WHERE `Matrix_Unique_ID` = '211290486' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:48:12.413' ,`MLSNumber` = '87667132' ,`ListAgentFullName` = 'Kleber Pita' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781647' ,`Longitude` = '-95.320520' ,`PhotoCount` = '15' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '150000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee' ,`StreetNumber` = '4914' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-bedroom, one-bath home currently being used as an income-producing rental property. This is one of several properties available making up a combined 20,000+ sq ft of land in popular Denver Harbor. Property is ideal to buy now, cash flow, and redevelop later.' ,`Acres` = '0.0574' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'W 1/2 OF LT 4 BLK 30 GAGNE HOMESTEAD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead Add' ,`TaxAmount` = '1040' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699061' WHERE `Matrix_Unique_ID` = '211290653' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:47:49.983' ,`MLSNumber` = '11005621' ,`ListAgentFullName` = 'Kleber Pita' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781627' ,`Longitude` = '-95.320598' ,`PhotoCount` = '15' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '150000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee' ,`StreetNumber` = '4912' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-bedroom, one-bath home currently being used as an income-producing rental property. This is one of several properties available making up a combined 20,000+ sq ft of land in popular Denver Harbor. Property is ideal to buy now, cash flow, and redevelop later.' ,`Acres` = '0.0574' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'E 1/2 OF LT 3 BLK 30 GAGNE HOMESTEAD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead' ,`TaxAmount` = '902' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699061' WHERE `Matrix_Unique_ID` = '211290755' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:47:17.240' ,`MLSNumber` = '14484007' ,`ListAgentFullName` = 'Kleber Pita' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781630' ,`Longitude` = '-95.320668' ,`PhotoCount` = '15' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '150000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee' ,`StreetNumber` = '4910' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-bedroom, one-bath home currently being used as an income-producing rental property. This is one of several properties available making up a combined 20,000+ sq ft of land in popular Denver Harbor. Property is ideal to buy now, cash flow, and redevelop later.' ,`Acres` = '0.0574' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'W 1/2 OF LT 3 BLK 30 GAGNE HOMESTEAD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead Add' ,`TaxAmount` = '902' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699061' WHERE `Matrix_Unique_ID` = '211290949' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:46:51.843' ,`MLSNumber` = '62275571' ,`ListAgentFullName` = 'Kleber Pita' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781639' ,`Longitude` = '-95.320760' ,`PhotoCount` = '15' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '150000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee' ,`StreetNumber` = '4908' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-bedroom, one-bath home currently being used as an income-producing rental property. This is one of several properties available making up a combined 20,000+ sq ft of land in popular Denver Harbor. Property is ideal to buy now, cash flow, and redevelop later.' ,`Acres` = '0.0574' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'E 1/2 OF LT 2 BLK 30 GAGNE HOMESTEAD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead Add' ,`TaxAmount` = '913' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699061' WHERE `Matrix_Unique_ID` = '211290953' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:46:11.503' ,`MLSNumber` = '75164046' ,`ListAgentFullName` = 'Kleber Pita' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781647' ,`Longitude` = '-95.320831' ,`PhotoCount` = '15' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '150000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee' ,`StreetNumber` = '4906' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-bedroom, one-bath home currently being used as an income-producing rental property. This is one of several properties available making up a combined 20,000+ sq ft of land in popular Denver Harbor. Property is ideal to buy now, cash flow, and redevelop later.' ,`Acres` = '0.0574' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'W 1/2 OF LT 2 BLK 30 GAGNE HOMESTEAD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead Add' ,`TaxAmount` = '1040' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699061' WHERE `Matrix_Unique_ID` = '211290957' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:45:47.790' ,`MLSNumber` = '73529786' ,`ListAgentFullName` = 'Kleber Pita' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781649' ,`Longitude` = '-95.320904' ,`PhotoCount` = '15' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '150000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee' ,`StreetNumber` = '4904' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-bedroom, one-bath home currently being used as an income-producing rental property. This is one of several properties available making up a combined 20,000+ sq ft of land in popular Denver Harbor. Property is ideal to buy now, cash flow, and redevelop later.' ,`Acres` = '0.0367' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'E 1/2 OF N 65.22 FT OF LT 1 BLK 30 GAGNE HOMESTEAD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead Add' ,`TaxAmount` = '703' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699062' WHERE `Matrix_Unique_ID` = '211290971' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:44:25.347' ,`MLSNumber` = '67740687' ,`ListAgentFullName` = 'Kleber Pita' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781646' ,`Longitude` = '-95.320996' ,`PhotoCount` = '15' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '150000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee' ,`StreetNumber` = '4902' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-bedroom, one-bath home currently being used as an income-producing rental property. This is one of several properties available making up a combined 20,000+ sq ft of land in popular Denver Harbor. Property is ideal to buy now, cash flow, and redevelop later.' ,`Acres` = '0.0374' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'W 1/2 OF N 65.22 FT OF LT 1 BLK 30 GAGNE HOMESTEAD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1630' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead Add' ,`TaxAmount` = '2909' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699062' WHERE `Matrix_Unique_ID` = '211290980' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T17:16:40.190' ,`MLSNumber` = '46014944' ,`ListAgentFullName` = 'Rayanna Eury' ,`ListOfficeName` = 'Gulf Coast Star Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.768385' ,`Longitude` = '-95.643401' ,`PhotoCount` = '19' ,`PostalCode` = '77414' ,`RoomCount` = '10' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 201' ,`StreetNumber` = '1838' ,`StreetSuffix` = '' ,`City` = 'Sargent' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION! Fisherman\'s Paradise! Beautiful home on Caney Creek. Two lots, that\'s 100ft of Caney Creek! This property is so close to the ICW. Just bring your boat, clothes and head on out to fish East Matagorda Bay or The Gulf of Mexico. The home was built in 2013. Low E impact windows, high ceilings, and so much more. The deck upstairs is partially covered. The house will be sold furnished. Downstairs has a bonus room and half bathroom. Also, there is a 9x9 storage with a roll up door for your larger items (mowers, kayaks, fishing rods, ect.) Don\'t forget there is a 400sq ft separate storage area on the second lot.\r\nSargent beach, restaurants, bait camps are all close by.\r\nThis subdivision has it\'s own boat ramp.' ,`Acres` = '0.521' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'DOWNEY CANEY CREEK SEC 1, BLOCK 4, LOT 14 and Lot 15' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '22694' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '134 - Van Vleck' ,`SchoolElementary` = 'VAN VLECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VAN VLECK HIGH SCHOOL' ,`SchoolMiddle` = 'O H HERMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Downey Caney Creek Sec 1' ,`TaxAmount` = '8480' ,`TaxRate` = '2.3895' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699062' WHERE `Matrix_Unique_ID` = '211357661' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T16:02:02.173' ,`MLSNumber` = '43725040' ,`ListAgentFullName` = 'Lourdes Reynolds' ,`ListOfficeName` = 'Southern Style Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.117105' ,`Longitude` = '-95.225688' ,`PhotoCount` = '17' ,`PostalCode` = '77365' ,`RoomCount` = '10' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn Woods' ,`StreetNumber` = '22511' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2104' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION! 9 Acres property with Loop 494 frontage, just one mile from the newly opened Highway 99. Perfect location for anything, commercial or residential. Nothing like it on the market! The possibilities are endless. Nice country home! Needs some updating, but very comfortable. Don\'t let this one pass you by!' ,`Acres` = '9' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0540 SMITH WM, TRACT 13, 86 , ACRES 9' ,`LotDesciption` = 'Wooded' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'VALLEY RANCH ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW CANEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'William Smith' ,`TaxAmount` = '2568' ,`TaxRate` = '2.5431' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699062' WHERE `Matrix_Unique_ID` = '211442571' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T16:07:43.833' ,`MLSNumber` = '45948857' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.755160' ,`Longitude` = '-95.877440' ,`PhotoCount` = '14' ,`PostalCode` = '77494' ,`RoomCount` = '5' ,`ListPrice` = '411900.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Peach' ,`StreetNumber` = '2515' ,`StreetSuffix` = 'Street' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION!!! Spacious entry leads to open family room, dining area and kitchen. Large windows and 10-foot ceilings throughout. Dining area features window seat. Kitchen features large walk-in pantry and generous island with built-in seating space. Primary suite with 10-foot ceiling. Dual vanities, separate glass-enclosed shower and large walk-in closet in primary bath. All bedrooms feature walk-in closets. Mud room with bonus closet off two-car garage' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 27, Block 1, Section 31' ,`LotDesciption` = 'Other' ,`LotSize` = '5447' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699062' WHERE `Matrix_Unique_ID` = '211443431' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-15T16:20:52.267' ,`MLSNumber` = '76856532' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.655080' ,`Longitude` = '-95.117823' ,`PhotoCount` = '17' ,`PostalCode` = '77505' ,`RoomCount` = '13' ,`ListPrice` = '555469.00' ,`Status` = 'Active' ,`StreetName` = 'Fairfield' ,`StreetNumber` = '5550' ,`StreetSuffix` = 'Lane' ,`City` = 'Pasadena' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2931' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one-story Margaret home with 4 bedrooms, 3 baths and 3 car tandem garage on a corner lot. Elegant dining room tucked off foyer with easy access to gourmet kitchen. Beautiful maple cabinets, quartz countertops and farmhouse sink in kitchen. Cozy box mantel fireplace with crown and tile surrounds in great room. Owner\'s suite features a versatile sitting room. Huge walk-in closet, dual vanity sinks, separate tub and shower in owner\'s bath. Double sinks in hall bath. Enjoy your evening relaxing on your cover patio. Offered by: K. Hovnanian Houston Parkway Trails, LLC.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '11/2/4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkway Trails' ,`TaxAmount` = '' ,`TaxRate` = '2.6198' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699062' WHERE `Matrix_Unique_ID` = '211443552' --> Updated record success