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` = '2023-01-31T16:16:22.173' ,`MLSNumber` = '86094189' ,`ListAgentFullName` = 'Jorge Llanas' ,`ListOfficeName` = 'David Hulsey, REALTORS ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781812' ,`Longitude` = '-95.351109' ,`PhotoCount` = '6' ,`PostalCode` = '77026' ,`RoomCount` = '7' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Hardy' ,`StreetNumber` = '2210' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1663' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property being sold for lot value only. Buyers do your own due-diligence regarding the structure on the property.' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 37 LITTLE & DICKINSON' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHERMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Photos/No Videos,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Little & Dickinson' ,`TaxAmount` = '5250' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266822' WHERE `Matrix_Unique_ID` = '201331760' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:32:47.707' ,`MLSNumber` = '35151018' ,`ListAgentFullName` = 'Lisa Dinh Tran' ,`ListOfficeName` = 'RE/MAX RESULTS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.691966' ,`Longitude` = '-95.457921' ,`PhotoCount` = '44' ,`PostalCode` = '77401' ,`RoomCount` = '11' ,`ListPrice` = '1795000.00' ,`Status` = 'Active' ,`StreetName` = 'Holt' ,`StreetNumber` = '4625' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4685' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exceptional custom build is currently under construction by Bellaire Builders. Estimated completion date, Fall/Winter 2022. The sophisticated open floor plan will give a clean modern look. This property offers 4 bedrooms/4.5 baths including a convenient mother in law suite down. Fall in love with the details and finishes that offer a combination of contemporary elements and stunning stones finishes. Magnificent chef\'s kitchen will be open to family room and features a grand sliding glass wall to outdoor patio. Impress guests with wine area with glass enclosed walls. 2nd floor offers expansive primary suite with a luxurious spa bath and an enormous closet with ample built-ins. Bonus Game Room can be 5th bedroom if desired. Backyard is generous in size with new custom pool. All photos are of a recent property with high end upgrades and similar finishes by Bellaire Builders.' ,`Acres` = '0.2014' ,`Area` = '17' ,`BuilderName` = 'Bellaire' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 4 POST OAK TERRACE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HORN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Post Oak Terrace Sec 01' ,`TaxAmount` = '8797' ,`TaxRate` = '2.2849' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266823' WHERE `Matrix_Unique_ID` = '202439283' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:52:45.080' ,`MLSNumber` = '24674199' ,`ListAgentFullName` = 'Cathy Lakey' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.224269' ,`Longitude` = '-95.532867' ,`PhotoCount` = '36' ,`PostalCode` = '77382' ,`RoomCount` = '10' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = 'Connemara' ,`StreetNumber` = '407' ,`StreetSuffix` = 'Drive' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '2193' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICED TO SELL!!! CLEARLY THE BEST BUY IN DEL WEBB!!! Gorgeous Martin Ray floor plan in the area\'s premier active adult community is loaded with luxury! Builder upgrades include the high-end front elevation with porch and stone accents, sunroom, 4-foot garage extension, gourmet white kitchen, huge 9-foot shower in primary bath, fireplace framed by a wall of stacked stone, plus hardwood flooring throughout with tile in baths and utility. NO CARPET! Sellers added custom built-ins in the study, including a sliding \"barn\" door, custom closet built-ins in both bedrooms, cabinets in the utility room, a custom \"drop zone,\" plus cabinets and a sink in the garage, and a huge glass shower in the secondary bath. Framed by beautiful flowering gardens in both front yard and back, you\'ll love the pretty patio done with pavers and accented with a pergola, perfect for relaxing in privacy with no back neighbors. Plus iron fencing, water softener, insulated garage door and a whole-house generator!' ,`Acres` = '0.1456' ,`Area` = '15' ,`BuilderName` = 'Pulte' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S402303 - DEL WEBB THE WOODLANDS 03, BLOCK 1, LOT 35' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6341' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Webb The Woodlands 03' ,`TaxAmount` = '7094' ,`TaxRate` = '1.7646' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266823' WHERE `Matrix_Unique_ID` = '203687831' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:10:18.297' ,`MLSNumber` = '72340381' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.444999' ,`Longitude` = '-95.397934' ,`PhotoCount` = '48' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '679990.00' ,`Status` = 'Active' ,`StreetName` = 'Sanger' ,`StreetNumber` = '9619' ,`StreetSuffix` = 'Way' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3323' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Shea Homes 6015\r\nBeautiful single story stucco home, 3 car garage, 4 bedrooms, 4.5 baths.\r\nSpacious, open floor plan concept living area with engineered wood throughout.\r\nA stacking sliding opens up from the great room to the outdoor patio. \r\nPrimary bedroom has a bay window, his and hers closet, double sinks and a separate glass shower. \r\nThe kitchen boasts a double oven, 5 burner gas cook top with an island.\r\n\r\n\r\nCome live the difference in this gorgeous Shea home!' ,`Acres` = '0.2369' ,`Area` = '5' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 44 (A0282 & A0286) (MANVEL) BLK 2 LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10319' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double 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` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Mediterranean,Spanish' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '2044' ,`TaxRate` = '3.68' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266824' WHERE `Matrix_Unique_ID` = '205070142' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:29:13.570' ,`MLSNumber` = '80446500' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.868089' ,`Longitude` = '-95.686740' ,`PhotoCount` = '34' ,`PostalCode` = '77449' ,`RoomCount` = '11' ,`ListPrice` = '814900.00' ,`Status` = 'Active' ,`StreetName` = 'Wildrye Meadow' ,`StreetNumber` = '7515' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4190' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Two-story entry highlights curved staircase. Home office and formal dining room frame entry. Two-story family room features a wood mantel fireplace opens to island kitchen and morning area. Kitchen features walk-in pantry, 5-burner gas cooktop, double wall oven and Butler\'s pantry. Family room features corner fireplace and angled wall of windows. First-floor primary suite includes bedroom with curved wall of windows. Dual vanities, garden tub, separate glass-enclosed shower and two walk-in closets in primary bath. First-floor guest suite includes private bath. Upstairs highlights a game room, media room and Hollywood bath. Abundant storage space adds to this generous five-bedroom home. Extended covered backyard patio. Three-car garage with porte-cochere.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Elyson Lot 3, Blk 9, Section 39' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10176' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCFEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '' ,`TaxRate` = '3.49' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266824' WHERE `Matrix_Unique_ID` = '205867508' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:28:50.873' ,`MLSNumber` = '27088872' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.882887' ,`Longitude` = '-95.799692' ,`PhotoCount` = '31' ,`PostalCode` = '77449' ,`RoomCount` = '9' ,`ListPrice` = '769900.00' ,`Status` = 'Active' ,`StreetName` = 'Wildrye Meadow' ,`StreetNumber` = '7511' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3578' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Home office with French doors set at entry. Extended entry leads past formal dining room to open family room with corner wood mantel fireplace. Open kitchen features center island, 5-burner gas cooktop, double wall oven and walk-in pantry. Guest suite with private bath off morning area. Primary suite includes bedroom with wall of windows. Dual vanities, corner garden tub, separate glass-enclosed shower and two walk-in closets in primary bath. High ceilings and walls of large windows add to this spacious four-bedroom design. Extended covered backyard patio. Mud room off three-car garage.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Elyson Lot 3, Blk 8, Section 39' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12770' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '' ,`TaxRate` = '3.49' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266825' WHERE `Matrix_Unique_ID` = '205869113' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:29:58.123' ,`MLSNumber` = '60152777' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.754541' ,`Longitude` = '-95.877566' ,`PhotoCount` = '33' ,`PostalCode` = '77494' ,`RoomCount` = '6' ,`ListPrice` = '384900.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Peach' ,`StreetNumber` = '2539' ,`StreetSuffix` = 'Street' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1743' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Entry with 11-foot rotunda ceiling leads to open kitchen, dining area and family room. Kitchen features corner walk-in pantry and generous island with built-in seating space. Primary suite includes double-door entry to primary bath with dual vanities, separate glass-enclosed shower and large walk-in closet. Home office with French doors set at back entrance. Large windows, extra closets and bonus mud room add to this spacious three-bedroom home. Two-car garage.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Jordan Ranch Lot 33, Blk 1,Section 31' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5927' ,`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 Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266825' WHERE `Matrix_Unique_ID` = '205997220' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:39:50.080' ,`MLSNumber` = '29507965' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.563816' ,`Longitude` = '-95.756251' ,`PhotoCount` = '40' ,`PostalCode` = '77469' ,`RoomCount` = '7' ,`ListPrice` = '699900.00' ,`Status` = 'Active' ,`StreetName` = 'Ruby Ford' ,`StreetNumber` = '1507' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3295' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Home office with French doors set at entry with 12-foot ceiling. Extended entry leads to open family room, dining area and kitchen with 17-foot ceilings throughout. Family room features wall of windows and fireplace. Kitchen features generous counter space, walk-in pantry and island with built-in seating space. Primary suite with wall of windows. Double doors lead to primary bath with 11-foot ceiling, dual vanities, garden tub, separate glass-enclosed shower and two walk-in closets. Game room with French doors features wall of windows. A guest suite plus abundant closet and storage space add to this open one-story design. Covered backyard patio with 16-foot ceiling. Mud room off three-car garage.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Veranda Lot 12, Blk 1, Section 38' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8410' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1020' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUTCHISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Veranda' ,`TaxAmount` = '' ,`TaxRate` = '3.16' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266825' WHERE `Matrix_Unique_ID` = '206006536' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:30:48.557' ,`MLSNumber` = '90981763' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750478' ,`Longitude` = '-95.884194' ,`PhotoCount` = '34' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '594900.00' ,`Status` = 'Active' ,`StreetName` = 'Sycamore Wood' ,`StreetNumber` = '2838' ,`StreetSuffix` = 'Trace' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2944' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Home office with French doors set entry. Media room with French doors off extended entry. Formal dining room flows into open family room with a wood mantel fireplace and a wall of windows. Kitchen features corner walk-in pantry and generous island with built-in seating space. Adjoining morning area features wall of windows. Primary suite includes double-door entry to primary bath with dual vanities, garden tub, separate glass-shower and two walk-in closets. Guest suite offers private bath. High ceilings and abundant closet space add to this spacious four-bedroom design. Extended covered backyard patio. Mud room off three-car garage.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Jordan Ranch Lot 4, Blk 2, Section 29' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9836' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266826' WHERE `Matrix_Unique_ID` = '206041294' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:29:33.273' ,`MLSNumber` = '53547376' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.883987' ,`Longitude` = '-95.799394' ,`PhotoCount` = '33' ,`PostalCode` = '77449' ,`RoomCount` = '11' ,`ListPrice` = '824900.00' ,`Status` = 'Active' ,`StreetName` = 'Wildrye Meadow' ,`StreetNumber` = '7611' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4263' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Grand two-story entry with 19 foot ceilings. Formal dining room and home office with French doors set at entry. Family room features a wood mantel fireplace and a wall of windows. Spacious kitchen with ample counter space, double wall oven, 5-burner gas cooktop, island with built-in seating, large walk-in pantry and butler pantry. Primary suite features a wall of windows, two large walk-in closets with access to large utility room. Primary bathroom includes dual vanities, garden tub and separate large walk-in shower. Guest suite with private bathroom is included on the first floor. Media room, game room, secondary bedrooms and a Hollywood bathroom completes the second floor. Extended covered backyard patio. Mud room leads to three-car garage.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Elyson Lot 3, Blk 14, Section 39' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10393' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '' ,`TaxRate` = '3.49' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266826' WHERE `Matrix_Unique_ID` = '206103575' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:26:40.977' ,`MLSNumber` = '88720970' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.807860' ,`Longitude` = '-95.847070' ,`PhotoCount` = '14' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '834900.00' ,`Status` = 'Active' ,`StreetName` = 'Mirabeau' ,`StreetNumber` = '6807' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3478' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Home office with French doors set at entry with 15-foot ceiling. Entry leads to open family room, dining area and kitchen with 15-foot ceilings throughout. Family room features wall of windows and a wood mantel fireplace. Kitchen features generous counter space, double wall oven, 5-burner gas cooktop, walk-in pantry and island with built-in seating space. Game room with French doors and wall of windows just off kitchen. Primary suite includes bedroom with curved wall of windows. Double doors lead to primary bath with dual vanities, garden tub, separate glass-enclosed shower and walk-in closet with access to utility room. A Hollywood bath and guest suite with private bath add to this spacious four-bedroom design. Extended covered backyard patio. Mud room off three-car garage.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Cane Island Lot 35, Blk 1, Section 31' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10400' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.45' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266827' WHERE `Matrix_Unique_ID` = '206956983' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:31:16.277' ,`MLSNumber` = '10331204' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.751530' ,`Longitude` = '-95.883370' ,`PhotoCount` = '33' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '684900.00' ,`Status` = 'Active' ,`StreetName` = 'Sycamore Wood' ,`StreetNumber` = '2810' ,`StreetSuffix` = 'Trace' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3465' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Waterfront homesite. Home office with French doors set at entry. Formal dining room. Open family room with wall of windows and a wood mantel fireplace flows into kitchen and morning area. Kitchen features island and walk-in pantry. Secluded Primary suite with curved wall of windows. Primary bath includes corner garden tub, separate glass-enclosed shower, dual vanities and two deep walk-in closets. Game room with French doors. Mud room. Abundant closet and storage space. Extended covered backyard patio. Three-car garage.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Jordan Ranch Lot 11, Blk 2, Section 29' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '9494' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266827' WHERE `Matrix_Unique_ID` = '207138510' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','207323746','1675266828','207323746','2023-01-31T16:26:24.940','13192997','Robert Moore','Perry Development Management','','','29.795660','-95.850270','14','77493','8','699900.00','Active','Pemberley','7519','Court','Katy','3','1','4','3384','Single-Family','PERRY HOMES NEW CONSTRUCTION! Two story entry with 196-foot ceilings. Home office with French doors just off the Foyer with an adjacent circular staircase. Two story family room with a grand wall of windows and corner cast stone fireplace extends to the dining area. Island kitchen with built-in seating space, 5-burner gas cooktop and a corner walk-in pantry. Secluded primary suite features bedroom with 12-foot ceilings, double door entry to primary bathroom, dual vanities, center garden tub, separate glass enclosed shower, two walk-in closets and additional private entry to the utility room. Guest suite with full bathroom and a walk-in closet on first floor. Second floor hosts a generous game room that overlooks the family room and dining area, media room, a Hollywood bathroom and secondary bedrooms. Covered backyard patio. Three-car garage.','','25','Perry Homes','','Washer Connections','','Mud','1','','1','Katy - Old Towne','Central Gas','1','Cane Island Lot 33, Blk 1, Section 14','Subdivision Lot','7942','Other','','1750','1','To Be Built/Under Construction','3','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','30 - Katy','BRYANT ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','KATY JUNIOR HIGH SCHOOL','Vacant/Unoccupied','Builder','2','Traditional','Cane Island','','3.45','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:13:03.823' ,`MLSNumber` = '97688453' ,`ListAgentFullName` = 'Bryan Beene' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.777922' ,`Longitude` = '-95.507477' ,`PhotoCount` = '43' ,`PostalCode` = '77024' ,`RoomCount` = '18' ,`ListPrice` = '8995000.00' ,`Status` = 'Active' ,`StreetName` = 'Beinhorn' ,`StreetNumber` = '10950' ,`StreetSuffix` = 'Road' ,`City` = 'Hedwig Village' ,`BathsFull` = '8' ,`BathsHalf` = '3' ,`BedsTotal` = '6' ,`SqFtTotal` = '14473' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Introducing The Beinhorn, a magnificent 14,473-square-foot residence beautifully positioned on one of Hedwig Village’s most prominent streets. Built for discerning clientele with the finest materials, The Beinhorn sets a new standard for elevating living in desirable Memorial Villages. Formal living spaces flank primary and catering kitchens with top-of-the-line appliances, while a wet bar and wine room make gracious hosting effortless. Al fresco entertaining and lounging is effortless with a summer kitchen, covered patios with fireplaces and a pool and spa. Fully fenced with a motor court designed with valet service and direct outdoor access in mind. The home includes a magnificent owner\'s retreat with a two-story ladies\' lounge and closet. The grand guest suite offers home-within-a-home luxury, including a living room and kitchenette, ideal for guests or staff. An elevator, generator and thoughtful lifestyle storage nod to the conveniences found throughout.' ,`Acres` = '0.7585' ,`Area` = '23' ,`BuilderName` = 'Legacy Development G' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TR 61F ABST 610 A H OSBORNE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '33040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEMORIAL DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Sam F Deck Unrecorded Sub' ,`TaxAmount` = '' ,`TaxRate` = '2.2564' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266828' WHERE `Matrix_Unique_ID` = '207715580' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:49:23.910' ,`MLSNumber` = '33709867' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.367222' ,`Longitude` = '-95.666338' ,`PhotoCount` = '19' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '334390.00' ,`Status` = 'Active' ,`StreetName` = 'Youth Water' ,`StreetNumber` = '955' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2198' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FANTASTIC NEW D. R. HORTON BUILT 4 BEDROOM! Sought-After Interior Layout with 3 Full Baths! Two Bedrooms & Baths Downstairs! Impressive Entry Opens Onto Gourmet Island Kitchen with Big Corner Pantry, Spacious Dining Area, & Adjoining Large Living Area! Privately Located First Floor Primary Suite - Lovely Garden Bath with Dual Sinks + Separate Tub & Shower + Huge Walk-In Closet! Guest Suite/Second Bedroom with Adjoining Full Bath Also on First Floor! Abundant Storage Under Stairs! Massive Gameroom/Media Room Upstairs! Covered Back Patio! Estimated Completion - August 2022. Nestled in the rolling hills along FM 2854, you\'ll find FAIRWATER the NEWEST community in Montgomery, TX! Zoned to the prestigious Montgomery ISD students receive the best education in some of the HIGHEST rated schools in the state! Come see why we are the FASTEST growing community in Montgomery, TX' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S503207 - Fairwater 07, BLOCK 3, Lot 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7845' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairwater' ,`TaxAmount` = '' ,`TaxRate` = '3.0981' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266828' WHERE `Matrix_Unique_ID` = '207938914' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:10:19.983' ,`MLSNumber` = '24625735' ,`ListAgentFullName` = 'Kelly Turner' ,`ListOfficeName` = 'BSRH Properties' ,`SellingAgentFullName` = 'Ellen Remmert' ,`SellingOfficeName` = 'Remmert Real Estate, LLC' ,`Latitude` = '29.795273' ,`Longitude` = '-96.169582' ,`PhotoCount` = '15' ,`PostalCode` = '77474' ,`RoomCount` = '6' ,`ListPrice` = '351900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Buckhorn' ,`StreetNumber` = '522' ,`StreetSuffix` = 'Street' ,`City` = 'Sealy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1853' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Craftsman 3 bedroom, 2 bath open-concept design includes a large kitchen with granite counter-tops and SS appliances. Kitchen opens onto the dining room and family room with hard-wood floors and tons of windows to let in the natural light. Spacious utility room and Mud area. The master suite includes an oversized master closet with separate master shower. The secondary bedrooms are spacious and each has its own walk-in closet. And don’t forget the large covered patio where you can relax and enjoy the fresh country breeze. ***All measurements must be verified.***' ,`Acres` = '' ,`Area` = '57' ,`BuilderName` = '****' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12, Block 2, Hunters Crossing' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SEALY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Hunters Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266829' WHERE `Matrix_Unique_ID` = '208264070' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:21:38.390' ,`MLSNumber` = '15289391' ,`ListAgentFullName` = 'Ashlee Cantu' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.777844' ,`Longitude` = '-95.352029' ,`PhotoCount` = '17' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Mckee' ,`StreetNumber` = '1812' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this amazing opportunity to own a home in the Near Northside. Only 5 minutes away from Downtown and right down the street from Hardy Yards. This very large home has 4 bedrooms with 2 1/2 baths. As you enter the home you will be amazed by the spacious living room that leads to the kitchen. Your new kitchen has a ton of counter space with a raised bar top to enjoy your morning breakfast. As you leave the dining room entering the back of the home, you will enter into another huge space that can be a second living room or game room. With so much space and only 5 minutes from Downtown, its perfect for investors and/or a new homeowner!' ,`Acres` = '0.1067' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 41 & 42 BLK 11 CASCARA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHERMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cascara' ,`TaxAmount` = '2626' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1910' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266829' WHERE `Matrix_Unique_ID` = '208418801' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:01:31.690' ,`MLSNumber` = '42814839' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.222685' ,`Longitude` = '-95.713427' ,`PhotoCount` = '17' ,`PostalCode` = '77354' ,`RoomCount` = '11' ,`ListPrice` = '589900.00' ,`Status` = 'Active' ,`StreetName` = 'Legacy Park' ,`StreetNumber` = '15418' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3546' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! wo-story entry framed by Home office with French doors and formal dining room. Entry flows into the family room kitchen and morning area. Two-story family room with 19-foot ceiling, a wood mantel fireplace and a grand wall of windows. Island kitchen with built-in seating space, 5-burner gas cooktop, a walk-in pantry and butler\'s pantry that leads to the formal dining room. Secluded primary suite features a large bedroom, primary bathroom with dual vanities, garden tub, separate glass enclosed shower, a linen closet and two walk-in closets. Second floor hosts a large game room, media room and secondary bedrooms. Covered backyard patio. Mud room and utility room just off the three-car garage.' ,`Acres` = '0.178' ,`Area` = '15' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S221802 - Audubon Park 02, BLOCK 4, Lot 12' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7762' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266830' WHERE `Matrix_Unique_ID` = '208694932' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:07:49.553' ,`MLSNumber` = '78417689' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.193135' ,`Longitude` = '-95.408492' ,`PhotoCount` = '33' ,`PostalCode` = '77515' ,`RoomCount` = '8' ,`ListPrice` = '359990.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Bend' ,`StreetNumber` = '173' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2558' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Bayou Bend! Anglia Homes presents the Haydock floor plan. This is a beautiful 4 bedroom, 2.5 bathroom with a game room or the option of a 5th bedroom. The primary bedroom is downstairs with a luxury master bathroom and a large walk-in closet. Call today for your private showing!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17 Block 1 Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bayou Bend' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266830' WHERE `Matrix_Unique_ID` = '208774098' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:36:13.320' ,`MLSNumber` = '83312630' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.678410' ,`Longitude` = '-95.901026' ,`PhotoCount` = '50' ,`PostalCode` = '77441' ,`RoomCount` = '9' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Creekbend' ,`StreetNumber` = '4826' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'September Completion! This brick & stucco one-story has 4 bedrooms, 3.5 baths, game room, and a 3-car garage. This home features a large covered front porch, a grand gallery entrance, and a secluded private study. The open living area has high ceilings throughout, gourmet kitchen with a large island and walk-in pantry, spacious family dining area, and great room with fireplace. The owners’ suite has a beautiful bow window, separate vanities in the bathroom, freestanding tub, and massive walk-in closet. Enjoy entertaining family and friends in the game room, or sitting outside on the covered back patio. One of this home’s most notable features is the 3 full-size garage bays – you don’t have to navigate a tandem garage once you move in here!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14, Block 2, Section 15' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '10288' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fulbrook on Fulshear Creek' ,`TaxAmount` = '' ,`TaxRate` = '2.99' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266830' WHERE `Matrix_Unique_ID` = '208775728' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:52:04.503' ,`MLSNumber` = '75109355' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.641173' ,`Longitude` = '-95.671129' ,`PhotoCount` = '18' ,`PostalCode` = '77498' ,`RoomCount` = '3' ,`ListPrice` = '261000.00' ,`Status` = 'Active' ,`StreetName` = 'Whispering' ,`StreetNumber` = '2819' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1414' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Renovated January 2023. Your dream home is waiting just for you in Sugar Land! You’ll enjoy preparing meals in the gorgeous kitchen with sleek granite counters, stainless appliances, and beautiful spacious cabinetry. Entertaining is a breeze with this great floor plan complete with a cozy fireplace and freshly painted living area. Primary bedroom features plush carpet, a spacious closet, and a private bathroom. Lush green landscape surrounds this beautiful house. Don\'t wait! Make this beautiful home yours today.\r\nThis home has been virtually staged to illustrate its potential' ,`Acres` = '0.153' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PHEASANT CREEK SEC 2, BLOCK 1, LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6663' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '398' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OYSTER CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pheasant Creek Sec 2' ,`TaxAmount` = '4196' ,`TaxRate` = '2.6329' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675266831' WHERE `Matrix_Unique_ID` = '208890922' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:30:41.533' ,`MLSNumber` = '87104901' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Jen Nguyen' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.852738' ,`Longitude` = '-95.742516' ,`PhotoCount` = '8' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '330490.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Riverdew Drive' ,`StreetNumber` = '21327' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2294' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW D.R. Horton two story! Wonderful open floor plan! Island kitchen has lots of cabinets and is open to the breakfast room and family room! Large primary bedroom with a spacious closet! Features a large shower in the primary bathroom as well! Hard surface flooring in all living areas and modern designer details! Covered Patio overlooking the backyard! Landscape package included and so much more! Hurry and call today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 - Block 3 - Section 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6842' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266831' WHERE `Matrix_Unique_ID` = '208897708' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:45:17.733' ,`MLSNumber` = '19271597' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.180858' ,`Longitude` = '-95.150079' ,`PhotoCount` = '6' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '334990.00' ,`Status` = 'Active' ,`StreetName` = 'Forest View' ,`StreetNumber` = '814' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2170' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW DR Horton Home! Situated on a huge homesite! Over 19,000 square feet and tons of trees! 3 car garage! Fantastic floor plan with 4 bedrooms and 3 full baths! Two beds and two full baths downstairs! The open kitchen features shaker cabinets, granite countertops and stainless-steel appliances! Spacious Primary Suite is tucked away for your own private retreat with separate shower and garden tub. The home has front sprinklers and landscape package! Also features a home automation system! You will appreciate the great storage and energy efficient features throughout. Hurry and call TODAY!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 12 Block 10 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '19034' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates at Roman Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266832' WHERE `Matrix_Unique_ID` = '209107171' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:48:57.703' ,`MLSNumber` = '88341699' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.366810' ,`Longitude` = '-95.664226' ,`PhotoCount` = '21' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '311590.00' ,`Status` = 'Active' ,`StreetName` = 'Purple Orchid Street' ,`StreetNumber` = '1132' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1867' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHARMING NEW D. R. HORTON BUILT 4 BEDROOM!! Gourmet Island Kitchen with Large Corner Pantry & Abundant Cabinetry, Open Living Space, & Lovely Dining Area! Primary Suite - Lovely Garden Bath with Dual Sinks, Separate Tub & Shower, & Enormous Walk-In Closet! Spacious Second Bedrooms/Guest Suites! Covered Patio Enhances Backyard! Fantastic Community with Recreation Center, SplashPad, Playground, Pavilion, & Pickleball Courts! Wonderful MISD and zoned to Lake Creek High School! MUST SEE! Nestled in the rolling hills along FM 2854, you\'ll find FAIRWATER the NEWEST community in Montgomery, TX! Zoned to the prestigious Montgomery ISD students receive the best education in some of the HIGHEST rated schools in the state! Come see why we are the FASTEST growing community in Montgomery, TX' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Fairwater 08, BLOCK 1, Lot 18' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7501' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairwater' ,`TaxAmount` = '' ,`TaxRate` = '3.17' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266832' WHERE `Matrix_Unique_ID` = '209261006' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:36:43.193' ,`MLSNumber` = '3615097' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.678208' ,`Longitude` = '-95.898968' ,`PhotoCount` = '3' ,`PostalCode` = '77441' ,`RoomCount` = '13' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Creekbend' ,`StreetNumber` = '4939' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The spacious 1.5-story Azure floor plan was designed with all the essentials for modern living. The open gourmet kitchen has ample counter space, a large island with a rounded countertop, and a walk-in pantry. The dining room and great room are perfect for entertaining friends and family, and a dedicated study area is ideal for those who work from home. The primary bedroom has a spa-like ensuite with double vanities, shower, freestanding tub, and impressive walk-in closet. An upstairs bonus room with a powder room can be used as a game room, entertainment hub, or additional storage space. Thoughtful extra conveniences like mudroom built-ins, utility room cabinets, a modern 60” linear fireplace, and an outdoor kitchen are included.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 29, Block 1, Section 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Fulbrook on Fulshear Creek' ,`TaxAmount` = '' ,`TaxRate` = '2.99' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266832' WHERE `Matrix_Unique_ID` = '209472423' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:42:36.573' ,`MLSNumber` = '95210313' ,`ListAgentFullName` = 'Christy Buck' ,`ListOfficeName` = 'Infinity Real Estate Group' ,`SellingAgentFullName` = 'Cesar Saenz' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '29.598797' ,`Longitude` = '-95.232060' ,`PhotoCount` = '26' ,`PostalCode` = '77089' ,`RoomCount` = '6' ,`ListPrice` = '200000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Kirkgreen' ,`StreetNumber` = '10534' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investment opportunity! Tenant occupied as of 9/12/2022 with a one year lease for $1800 per month. Check out this great home in a cul-de-sac with a large fenced yard. Open concept floor plan with wood burning fireplace and vaulted ceilings in the living area. Breakfast bar and eat-in kitchen with gas stove. Laminate flooring and tile throughout the home other than the bedrooms, double pane windows and updated bathrooms. Per seller, roof replaced @ 3 yrs ago, water heater replaced in 2017 and all air ducts replaced. A/C was existing when he purchased the home approximately 8 years ago but works great! Large covered patio and storage shed in the backyard. Convenient location to the beltway and I45. See attached previous foundation repair and proposed foundation repair quote in attachments.' ,`Acres` = '0.1791' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 81 BLK 2 KIRKWOOD SOUTH SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '190' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MOORE ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kirkwood South Sec 05' ,`TaxAmount` = '3994' ,`TaxRate` = '2.6355' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266833' WHERE `Matrix_Unique_ID` = '209537470' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:31:53.790' ,`MLSNumber` = '55859198' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Nelly Schmidt' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '29.848455' ,`Longitude` = '-95.746294' ,`PhotoCount` = '7' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '285490.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Wine Palm' ,`StreetNumber` = '21607' ,`StreetSuffix` = 'Way' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1501' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WONDERFUL NEW D. R. HORTON BUILT 1 STORY! Sought-After Open Concept Interior Layout! Island Kitchen with Lots of Cabinetry & Corner Pantry Opens Onto Family Room & Dining Area! Privately Located Primary Suite Offers Two Big Walk-In Closets & Lovely Bath with Dual Sinks & Large Shower! Spacious Secondary Bedrooms! Generously Sized Indoor Utility Room! Covered Patio Overlooks Backyard!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 JASMINE HEIGHTS SEC 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7177' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266833' WHERE `Matrix_Unique_ID` = '209547539' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:26:10.023' ,`MLSNumber` = '65142445' ,`ListAgentFullName` = 'Lee Christensen' ,`ListOfficeName` = 'Kimberly Beggs' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.140600' ,`Longitude` = '-95.050062' ,`PhotoCount` = '45' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Ector' ,`StreetNumber` = '4019' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy breathtaking canal views without the canal prices from your 3 bed, 2 bath, over 1500 sf home! Built in 2018, it is one of only a handful of Sea Isle properties sitting on a dry lot with an unobstructed view down a beautiful canal. Move-in ready, this home conveys fully furnished, with very few exclusions. Has been a private family home, never rented. Live here full time or make it a getaway, this home has amenities that will give the entire family something to do! A spacious living area, large bedrooms, fully-fenced yard, garage, and downstairs party area with plenty of parking! And, with those incredible water views and short proximity to the Gulf, you are sure to enjoy island life! Sea Isle boasts two stores, restaurants, bars, marina, bait shop, pool, tennis/pickleball court and longest private fishing pier on the island! Park the car and walk, ride your bike, or use a golf cart to access Sea Isle\'s amenities or travel through the various neighborhoods and to beach areas.' ,`Acres` = '0.1439' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 15 LOT 884 SEA ISLE 4TH EXTENSION' ,`LotDesciption` = 'Water View' ,`LotSize` = '6270' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '215' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sea Isle Ext 4' ,`TaxAmount` = '7912' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266833' WHERE `Matrix_Unique_ID` = '209611148' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:50:21.627' ,`MLSNumber` = '35723142' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.894006' ,`Longitude` = '-95.627239' ,`PhotoCount` = '24' ,`PostalCode` = '77095' ,`RoomCount` = '4' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Oceanside' ,`StreetNumber` = '8023' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2458' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your dream home is waiting for your in Houston! Home was just updated in December, 2022 including: Kitchen renovated with a new dishwasher, freshly painted cabinets. Home interior has been freshly painted. This charming 4 bedroom, 2.5 bathroom, 2 car garage home is now on the market! The kitchen boasts generous granite counter space, stainless appliances and a central island with breakfast bar, making cooking and entertaining a delight. Discover a bright interior with neutral laminate/tile floors and plush carpet in all the right places. Flow into the living room featuring a cozy fireplace, perfect for kicking back at the end of the day. The main bedroom boasts a private ensuite bathroom with dual sinks and walk-in closet. Other bedrooms offer plush carpet, ceiling fans and sizable closets. Don\'t wait! Makes this beautiful home yours today!' ,`Acres` = '0.1148' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 1 HEARTHSTONE SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'OWENS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hearthstone Sec 07' ,`TaxAmount` = '5719' ,`TaxRate` = '2.501' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675266834' WHERE `Matrix_Unique_ID` = '210001857' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:00:15.980' ,`MLSNumber` = '6420697' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.368287' ,`Longitude` = '-95.671057' ,`PhotoCount` = '13' ,`PostalCode` = '77316' ,`RoomCount` = '6' ,`ListPrice` = '355990.00' ,`Status` = 'Active' ,`StreetName` = 'Tilia Creek' ,`StreetNumber` = '1262' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The attractive Greeley plan presents three bedrooms with large walk-in closets & two full bathrooms!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10, Block 2, Section 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7027' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fairwater' ,`TaxAmount` = '' ,`TaxRate` = '2.58' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266834' WHERE `Matrix_Unique_ID` = '210120320' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:07:13.660' ,`MLSNumber` = '8800789' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.368123' ,`Longitude` = '-95.672062' ,`PhotoCount` = '17' ,`PostalCode` = '77316' ,`RoomCount` = '9' ,`ListPrice` = '430990.00' ,`Status` = 'Active' ,`StreetName` = 'Tilia Creek' ,`StreetNumber` = '1270' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2637' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Fitzgerald plan features four bedrooms, three full bathrooms, and an upstairs gameroom!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8, Block 2, Section 6' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '7673' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fairwater' ,`TaxAmount` = '' ,`TaxRate` = '2.58' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266834' WHERE `Matrix_Unique_ID` = '210129796' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:00:04.160' ,`MLSNumber` = '62297703' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.158672' ,`Longitude` = '-95.610156' ,`PhotoCount` = '7' ,`PostalCode` = '77354' ,`RoomCount` = '3' ,`ListPrice` = '260740.00' ,`Status` = 'Active' ,`StreetName` = 'Tammy Lane' ,`StreetNumber` = '10009' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1489' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic NEW DR Horton Home!! Excellent location in Montgomery County! GREAT 1 story floor plan with designer details at every corner! Modern finishes and open living spaces! Beautiful island kitchen with granite countertops and white cabinetry! Nice primary bedroom suite with spa like bath! Includes a useful covered patio and landscape package! Hurry and call TODAY!!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8/ Block 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Enclave at Dobbin' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266835' WHERE `Matrix_Unique_ID` = '210177649' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:41:31.710' ,`MLSNumber` = '11810619' ,`ListAgentFullName` = 'Meredith Flores' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = 'Philip Alter' ,`SellingOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`Latitude` = '29.749284' ,`Longitude` = '-95.452009' ,`PhotoCount` = '32' ,`PostalCode` = '77027' ,`RoomCount` = '8' ,`ListPrice` = '1750000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Eaton' ,`StreetNumber` = '10' ,`StreetSuffix` = 'Square' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '5988' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location!Location!Location! There is no better example than the gated enclave of Eaton Square.Positioned in the Uptown area between two of Houston’s most prestigious neighborhoods, River Oaks and Tanglewood, this elegant English Regency home is perfectly situated inside a guarded community of 15 luxury homes.Elevator to all 3 levels, gracious formals, primary bedroom suite with spacious sitting or office area and luxury en-suite bath w/ two walk-in wardrobes.2 guest bedrooms with en suite baths on second floor, third-floor bedroom with en suite bath. This property boasts designer features throughout including stylish finishes, baccarat light fixtures, a copper backed fireplace, and a calacutta marble primary bathroom.Additional features include Sonos system throughout,2 wetbars, a large upstairs laundry room, and state of the art Miele and Sub-zero appliances.Inviting and picturesque landscaped turf backyard with covered loggia.2-car garage, gated/guarded community.Ample guest parking.' ,`Acres` = '0.1111' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Briar Hollow' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 EATON SQUARE AMEND' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '4838' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'English' ,`Subdivision` = 'Eaton Square' ,`TaxAmount` = '' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266835' WHERE `Matrix_Unique_ID` = '210179103' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:59:38.403' ,`MLSNumber` = '11126792' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.158672' ,`Longitude` = '-95.610156' ,`PhotoCount` = '7' ,`PostalCode` = '77354' ,`RoomCount` = '5' ,`ListPrice` = '317740.00' ,`Status` = 'Active' ,`StreetName` = 'Tammy Lane' ,`StreetNumber` = '10001' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2182' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful brand NEW DR Horton Home!! Excellent location in Montgomery County! Lovely two story plan with designer details at every corner! Awesome game room space upstairs! Wonderful layout with open living spaces and modern finishes! Beautiful island kitchen with granite countertops and white cabinetry! Nice primary bedroom suite with spa like bath! Includes a useful covered patio and landscape package! Hurry and call TODAY!!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6/Block 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Enclave at Dobbin' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266835' WHERE `Matrix_Unique_ID` = '210181641' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:58:45.630' ,`MLSNumber` = '88597084' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.158672' ,`Longitude` = '-95.610156' ,`PhotoCount` = '11' ,`PostalCode` = '77354' ,`RoomCount` = '3' ,`ListPrice` = '273740.00' ,`Status` = 'Active' ,`StreetName` = 'Tammy Lane' ,`StreetNumber` = '10005' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1541' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely NEW DR Horton Home!! Excellent location in Montgomery County! GREAT 1 story floor plan with designer details at every corner! Modern finishes and open living spaces! Beautiful island kitchen with granite countertops and white cabinetry! Nice primary bedroom suite with spa like bath! Includes a useful covered patio and landscape package! Hurry and call TODAY!!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 Block 5 Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Enclave at Dobbin' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266836' WHERE `Matrix_Unique_ID` = '210182689' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:27:00.943' ,`MLSNumber` = '26116540' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.814627' ,`Longitude` = '-95.836209' ,`PhotoCount` = '14' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '839900.00' ,`Status` = 'Active' ,`StreetName` = 'Nimitz' ,`StreetNumber` = '6718' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3578' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION: Home office with French doors set at entry. Extended entry leads past formal dining room to an open family room with a corner wood mantel fireplace and a sliding glass door. Open kitchen features a center island, 5-burner gas cooktop, double wall oven, and walk-in pantry. Guest suite with private bath off morning area. Primary suite includes bedroom with wall of windows. Dual vanities, a garden tub, separate glass-enclosed shower and two walk-in closets in primary bath. High ceilings and walls of large windows add to this spacious four-bedroom design. Extended covered backyard patio. Mud room off four-car garage' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Perry Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S422391 CANE ISLAND SECTION 31 BLK 2 LOT 7' ,`LotDesciption` = 'Other' ,`LotSize` = '12558' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.45583' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266836' WHERE `Matrix_Unique_ID` = '210240176' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:10:13.040' ,`MLSNumber` = '10831050' ,`ListAgentFullName` = 'Delilah McKenna' ,`ListOfficeName` = 'McKenna Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812015' ,`Longitude` = '-95.395001' ,`PhotoCount` = '27' ,`PostalCode` = '77008' ,`RoomCount` = '4' ,`ListPrice` = '464900.00' ,`Status` = 'Active' ,`StreetName` = '28th' ,`StreetNumber` = '328' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1074' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully preserved and restored 1940\'s Craftsman style Bungalow in Sunset Heights on 6000 sf lot. Original hardwood floors. Fully fenced yard (front and back). All new bath and updated kitchen. All new windows! Good closet space. Huge new walk-in shower. Custom, locally built, double vanities in the new bath. Recent brick walkway, stairs, and front porch. NEW HVAC in Nov 2022. Huge, fenced backyard is great for dogs and kids or future additions, a pool, etc. Attached garage. Nice, quiet Sunset Heights location inside the loop and close to all the Heights food, drink, shopping, entertainment, grocery, etc. Nice screened-in porches (front and back) are a must in the south and are fantastic for entertaining and dining al fresco. You won\'t find another place quite like this one on the (very short) list of original single family houses available in this entire area. This is a beautiful, well-maintained property. Call or text with questions or to schedule a showing appointment.' ,`Acres` = '0.1377' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 13 & 14 BLK 18 SUNSET HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Sunset Heights' ,`TaxAmount` = '7943' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266836' WHERE `Matrix_Unique_ID` = '210244838' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:23:03.237' ,`MLSNumber` = '57368251' ,`ListAgentFullName` = 'Jeffrey Winans' ,`ListOfficeName` = 'Showcase Properties of Texas' ,`SellingAgentFullName` = 'Matthew Ersler' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '29.677504' ,`Longitude` = '-95.436651' ,`PhotoCount` = '23' ,`PostalCode` = '77025' ,`RoomCount` = '8' ,`ListPrice` = '349900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Riddlewood' ,`StreetNumber` = '9710' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2194' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GATED COMMUNITY. LOCATION! LOCATION! LOCATION! Easy access to 610 S Loop and to the Galleria, TMC, and Downtown. Freshly painted and move-in ready contemporary open light filled single family home. Dramatic 2 story living room space with fireplace, hardwood floors, granite counters in kitchen. Bathrooms are original to the home. Separate study/office located off dining room. No HOA, never flooded, per seller.' ,`Acres` = '' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 1 CONTEMPORARY PLAZA 2 AMEND 1' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1562' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHEARN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Contemporary Plaza 02 Amd 01' ,`TaxAmount` = '6343' ,`TaxRate` = '2.33' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266837' WHERE `Matrix_Unique_ID` = '210367038' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:11:32.020' ,`MLSNumber` = '44607076' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.444369' ,`Longitude` = '-95.399964' ,`PhotoCount` = '4' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '719990.00' ,`Status` = 'Active' ,`StreetName` = 'Sanger' ,`StreetNumber` = '9534' ,`StreetSuffix` = 'Way' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction by Shea Homes. Plan 6025. This inviting and spacious single-story home offers 4 bedrooms, 3.5 bathrooms, and a 3-car tandem garage. As you walk through the gorgeous rotunda in the entry, you will find hallways that lead to the secondary bedrooms and office. The Great Room awaits at the end of the hall with a 12\' ceiling featuring beautiful cedar beams, fireplace and stacked sliding doors that fill the space with natural light. An oversized Casual Dining Room leads out to the large, covered patio. Back inside, the gourmet Kitchen included cabinets galore, double ovens, a 5-burner gas cooktop, large kitchen island and a huge walk-in pantry. The primary suite is the perfect place to relax featuring a bay window and spa like bathroom with dual vanities, shower with bench seat and garden tub. A Media Room off the Great Room will provide the perfect space to entertain family and friends. come and Live the Difference in a Shea Home!' ,`Acres` = '0.2492' ,`Area` = '5' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 44 (A0282 & A0286) (MANVEL) BLK 1 LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10855' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven,Single 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` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '2070' ,`TaxRate` = '3.6807' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266837' WHERE `Matrix_Unique_ID` = '210464269' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:54:35.820' ,`MLSNumber` = '39349810' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.987871' ,`Longitude` = '-95.723898' ,`PhotoCount` = '26' ,`PostalCode` = '77429' ,`RoomCount` = '5' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Mackinaw Isle' ,`StreetNumber` = '19607' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3164' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your dream home is waiting just for you in Cypress! Home was just updated in December, 2022 including: Kitchen renovated with freshly painted cabinets, bathroom updated with new faucets and flooring. Enjoy preparing meals in this impressive kitchen equipped with ample cabinets, stainless steel appliances, tile backsplash and generous counter space. Lighting, ceiling fans, and fixtures flow throughout. The primary bedroom features plush carpet, a spacious closet, and a private bathroom with dual sinks and with walk-in closet. Head to the backyard for the perfect private area to enjoy the outdoors. Don\'t miss this incredible opportunity.' ,`Acres` = '0.1823' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 3 VILLAGES OF CYPRESS LAKES SEC 11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7941' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '614' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages/Cypress Lakes Sec 11' ,`TaxAmount` = '8132' ,`TaxRate` = '3.061' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675266837' WHERE `Matrix_Unique_ID` = '210486648' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:13:18.940' ,`MLSNumber` = '29516969' ,`ListAgentFullName` = 'Kimberly Doty-Baker' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = 'David Buehler' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '30.148177' ,`Longitude` = '-95.644874' ,`PhotoCount` = '45' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '680000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Green Tree' ,`StreetNumber` = '25910' ,`StreetSuffix` = 'Street' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3088' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Impeccable custom Farmhouse-style country home located in Tomball ISD! Positioned on approx 2 acres, this property is sure to please. Upon entrance, you are warmly greeted by a beautiful stairway, study, low maintenance tile flooring & a bright open floor plan that seamlessly connects the kitchen to the living area. Meticulous attention to detail is present in the chef\'s kitchen showcasing granite countertops, subway tile backsplash, custom finished cabinetry, abundant bar space & apron sink. Spacious primary suite is on the 1st floor w two additional bedrooms as a split plan. Another HUGE bedroom/bonus room & full bath upstairs providing add\'l flexibility. Three car garage provides ample parking space. Enjoy the covered back patio w/ceiling fans & stone/granite prep area with sink. The backyard provides a plentiful space for gardening & entertaining! Approx 30x40 barn. NO flooding. Low tax rate! Moco 4H welcome! Make your appt today to view this move in ready home. Just beautiful!' ,`Acres` = '1.0605' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'POST OAK FOREST, LOT 27, ACRES 1.060' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '46195' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '140' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Post Oak Forest' ,`TaxAmount` = '5730' ,`TaxRate` = '1.9215' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266838' WHERE `Matrix_Unique_ID` = '210558604' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','210684705','1675266838','210684705','2023-01-31T16:31:21.317','7992397','Mary Wassef','Circa Real Estate','','','29.875419','-95.433744','17','77088','7','359000.00','Active','James Franklin','8418','Street','Houston','3','1','4','2106','Single-Family','Acres Place is a new near-town development from respected builder, J G Hollins Builders. This is the Ferguson floor plan which is a spacious two-story with a spacious primary suite on the second floor, along with two secondary bedrooms. The guest suite on the first floor is perfect for visitors or office space. Other highlights of this home include spacious living and dining, a chef\'s kitchen, lots of entertainment space and a spacious backyard with room for a pool!. This thriving 47-home neighborhood is just minutes away from everything that Houston has to offer. There are four fantastic floor plans to choose from and all come with massive yards. If you get in early enough, you can choose many of your finishes! Quality construction, stylish finishes and plenty of space. This is an amazing find just minutes from town. Don\'t let this opportunity slip away. Homes are selling quickly. Contact us to see a model home. Finishes and specifications subject to change','','11','JG Hollins Builder','','','','No Disclosures','1','','','Northwest Houston','Central Gas','0','LT 1 BLK 1 JAMES FRANKLIN','Subdivision Lot','6700','Appraisal District','','','1','To Be Built/Under Construction','2','Single Oven','0','','','Gas Range','','Composition','1 - Aldine','ANDERSON ACADEMY','CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS','DREW ACADEMY','Appointment Required','Appraisal District','2','Traditional','James Franklin Annex','702','2.5119','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:05:35.710' ,`MLSNumber` = '41039035' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822450' ,`Longitude` = '-94.820299' ,`PhotoCount` = '22' ,`PostalCode` = '77523' ,`RoomCount` = '11' ,`ListPrice` = '318990.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Forest' ,`StreetNumber` = '14911' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1842' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready to move-in! The Mercury home design is a one-story home featuring charming front porch, 4 bedrooms, 2 baths and a two car attached garage. From the moment you walk through the front door, you will know that this is the one! Convenient home office tucked off foyer. The cozy kitchen has maple cabinets, granite countertops with low bar top and a pantry. Huge walk-in closet, separate tub and shower in owner\'s luxury bath. Double sinks in all baths. Vinyl flooring in living areas. Covered patio in backyard, perfect for entertaining.\r\nWe are conveniently located off I-10, which makes it easy to get to places in Baytown, Mont Belvieu and Houston! Great schools and low taxes make Raintree a desirable community to live in. Come on out! We would love to see you! Offered by: K. Hovnanian of Houston II, L.L.C.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = '13/1/3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7095' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.746051' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266838' WHERE `Matrix_Unique_ID` = '210687243' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:05:16.833' ,`MLSNumber` = '13637143' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822590' ,`Longitude` = '-94.819333' ,`PhotoCount` = '23' ,`PostalCode` = '77523' ,`RoomCount` = '11' ,`ListPrice` = '318990.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Forest' ,`StreetNumber` = '14931' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1842' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready to move-in! The Mercury home design is a one-story home featuring charming front porch, 4 bedrooms, 2 baths and a two car attached garage. From the moment you walk through the front door, you will know that this is the one! Elegant dining room tucked off foyer. The cozy kitchen has maple cabinets, quartz countertops with low bar top and a pantry. Huge walk-in closet, separate tub and shower in owner\'s luxury bath. Double sinks in all baths. Vinyl flooring in living areas. Covered patio in backyard, perfect for entertaining.\r\nWe are conveniently located off I-10, which makes it easy to get to places in Baytown, Mont Belvieu and Houston! Great schools and low taxes make Raintree a desirable community to live in. Come on out! We would love to see you! Offered by: K. Hovnanian of Houston II, L.L.C.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = '18/1/3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.746051' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266838' WHERE `Matrix_Unique_ID` = '210690382' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:21:19.967' ,`MLSNumber` = '39061068' ,`ListAgentFullName` = 'Naila Duran' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.126955' ,`Longitude` = '-95.290160' ,`PhotoCount` = '40' ,`PostalCode` = '77365' ,`RoomCount` = '10' ,`ListPrice` = '702905.00' ,`Status` = 'Active' ,`StreetName` = 'Nasas' ,`StreetNumber` = '19482' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2869' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remarkable new construction retreat encompassing 1 acre in scale situated in the prestigious Riverwalk subdivision. Brixton Development has created another spectacular modern design incorporating stylish surfaces and a gracious floor plan featuring plenty of natural light flow enabling effortless indoor/outdoor living to maximize use of the serene setting. Gourmet waterfall quartz Island Kitchen with all the modern finishes to surpass your expectations. Oversized primary suite with a luxurious bath and extravagant walk in shower. Generous secondary bedrooms with walk in closets of their own. Covered outdoor patio with endless possibilities. Schedule a tour today to see this stunning new home!' ,`Acres` = '1' ,`Area` = '40' ,`BuilderName` = 'Brixton Development' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERWALK 05, BLOCK 5, LOT 19, ACRES 1.000' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'SORTERS MILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Riverwalk 05' ,`TaxAmount` = '1173' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266838' WHERE `Matrix_Unique_ID` = '210719271' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:32:41.060' ,`MLSNumber` = '60025664' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.908118' ,`Longitude` = '-95.738538' ,`PhotoCount` = '6' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '564900.00' ,`Status` = 'Active' ,`StreetName` = 'Sail Ridge' ,`StreetNumber` = '8815' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2934' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Home office with French doors frame the two-story entry. Formal dining room. Two-story family room with a wall of windows, wood mantel fireplace and 19-foot ceiling. Island kitchen with built-in seating space offers a walk-in pantry and opens to morning area. Primary suite with 11-foot ceiling. Garden tub, separate glass-enclosed shower, dual sinks and two walk-in closets in the primary bath. Additional bedroom on first floor. Secondary bedrooms with walk-in closets and a game room complete this spacious design. Utility room. Extended covered backyard patio. Two-car garage.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11, Block 2 Section 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7046' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266839' WHERE `Matrix_Unique_ID` = '210889645' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:27:36.213' ,`MLSNumber` = '96013556' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.877932' ,`Longitude` = '-95.785469' ,`PhotoCount` = '11' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '759900.00' ,`Status` = 'Active' ,`StreetName` = 'Switchgrass Valley' ,`StreetNumber` = '24502' ,`StreetSuffix` = 'Way' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3791' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perry Homes New Construction! Curved staircase highlights two-story entry. Home office with French doors and formal dining room set at entry. Two-story family room with wall of windows and corner wood mantel fireplace opens to kitchen and morning area. Kitchen features walk-in pantry, double wall oven, 5-burner gas cooktop and island with built-in seating space. First-floor primary suite with wall of windows. Dual vanities, garden tub, separate glass-enclosed shower and two walk-in closets in primary bath. First-floor guest suite offers private bath. A game room, media room and three secondary bedrooms are upstairs. Extended covered backyard patio. Three-car garage.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9_Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8434' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1280' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '' ,`TaxRate` = '3.49' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266839' WHERE `Matrix_Unique_ID` = '210972043' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:28:34.760' ,`MLSNumber` = '30326146' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.018269' ,`Longitude` = '-95.322841' ,`PhotoCount` = '35' ,`PostalCode` = '77338' ,`RoomCount` = '4' ,`ListPrice` = '313000.00' ,`Status` = 'Active' ,`StreetName` = 'Jasmine Leaf' ,`StreetNumber` = '20519' ,`StreetSuffix` = 'Trail' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3051' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Humble two-story home offers a two-car garage.' ,`Acres` = '0.1452' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 8 CYPRESSWOOD POINT SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '310' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Point Sec 01' ,`TaxAmount` = '6418' ,`TaxRate` = '2.7734' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675266839' WHERE `Matrix_Unique_ID` = '211159835' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:40:21.153' ,`MLSNumber` = '27946352' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.564564' ,`Longitude` = '-95.753952' ,`PhotoCount` = '36' ,`PostalCode` = '77469' ,`RoomCount` = '9' ,`ListPrice` = '686900.00' ,`Status` = 'Active' ,`StreetName` = 'Norwood Groves' ,`StreetNumber` = '24207' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3257' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Home office with French doors and formal dining room frame elongated entry. Open family room features wall of windows and a wood mantel fireplace. Island kitchen features Butler\'s pantry, 5-burner gas cooktop and large walk-in pantry. Game room with French doors off morning area. Primary suite includes primary bath with dual vanity, corner garden tub, separate glass-enclosed shower and two walk-in closets. Guest suite offers private bath. High ceilings, large windows and abundant closet space add to this generous one-story home. Extended covered backyard patio. Mud room off three-car garage.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Veranda Lot 8 Blk 2 Section 38' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8920' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1020' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Veranda' ,`TaxAmount` = '' ,`TaxRate` = '3.16' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266839' WHERE `Matrix_Unique_ID` = '211202246' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:19:04.983' ,`MLSNumber` = '94175990' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Keith Davis' ,`SellingOfficeName` = 'Exceed Realty' ,`Latitude` = '30.221248' ,`Longitude` = '-95.240160' ,`PhotoCount` = '18' ,`PostalCode` = '77357' ,`RoomCount` = '5' ,`ListPrice` = '306740.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Starry Night' ,`StreetNumber` = '21554' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2041' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FANTASTIC BRAND NEW DR HORTON HOME! AMAZING 1 STORY FLOOR PLAN WITH 3 CAR GARAGE!!! Perfect location!!! Spacious island kitchen with great space for entertaining! Modern finishes and designer details at every corner!! Primary suite secluded to back of the home for privacy with spa like bath retreat! Also features a home office!! Wonderful outdoor space with landscape package and covered patio!! Hurry and call TODAY!!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '08/04/08' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266840' WHERE `Matrix_Unique_ID` = '211370066' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T16:08:59.397' ,`MLSNumber` = '62187940' ,`ListAgentFullName` = 'Jeffrey Morrison' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799755' ,`Longitude` = '-95.388664' ,`PhotoCount` = '38' ,`PostalCode` = '77008' ,`RoomCount` = '8' ,`ListPrice` = '875000.00' ,`Status` = 'Active' ,`StreetName` = '16th' ,`StreetNumber` = '760' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2226' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Picturesque Renovated original Heights Bungalow! 3 beds 3 baths home on a great street! Excellent location! Walk up the inviting large front porch and into a Classic Heights home! This 2-story home has a bedroom and full bath down, Vintage Heights formals and large kitchen with Breakfast bar and sitting area. Hardwoods throughout, beautifully landscaped front and back yards with sprinkler systems and outdoor lighting. Relaxing backyard and wood deck. 2 car detached garage, long model T driveway with Porta Cache covering, and lots of extra parking. Beautiful crown Moulding throughout. Upstairs primary bedroom is fantastic with awesome master bath. Double sinks, large, jetted tub and separate shower. Walk in closet and tons of storage throughout! 2nd upstairs bedroom has private bath and lots of closet space. Home has white plantation shutters throughout, Fresh paint in and out, Garage has workshop and AC! Don\'t miss out on this stunning home!' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 5 PINELAWN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinelawn' ,`TaxAmount` = '14629' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266840' WHERE `Matrix_Unique_ID` = '211394840' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T15:10:39.870' ,`MLSNumber` = '90479856' ,`ListAgentFullName` = 'Jane Draughon' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = 'Kristy Salas' ,`SellingOfficeName` = 'CB&A, Realtors' ,`Latitude` = '30.147366' ,`Longitude` = '-95.478713' ,`PhotoCount` = '41' ,`PostalCode` = '77380' ,`RoomCount` = '10' ,`ListPrice` = '699000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Timberwagon' ,`StreetNumber` = '10712' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3887' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique updated French style home in the heart of The Woodlands. Exquisite finishes and architectural details throughout with beautiful double iron front doors. The raised grand entry descends to the family room, featuring a spectacular fireplace which extends to the ceiling, surrounded by tall, elegant arched windows. Updates include double pane energy efficient Anderson windows throughout, gorgeous updated hardwood floors, new carpet and a huge workshop w/ A/C. The lifetime Mansard roof shakes, metal stair balusters, stainless steel appliances, custom cabinets and granite kitchen and bath countertops are a few of the upgrades. Game room could also be 2nd primary bedroom. The remodeled primary bath has a huge walk-in shower, custom cabinets with quartz countertops, and new fixtures, toilet & lighting. The downstairs primary bedroom, with it\'s own cozy fireplace, has a gorgeous view of the huge, picturesque backyard oasis with multi-level decking for relaxing under the canopy of trees.' ,`Acres` = '0.4886' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL GROGANS ML 06, BLOCK 6, LOT 20' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '21283' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Other' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAM HAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'French' ,`Subdivision` = 'Wdlnds Village Grogans Ml 06' ,`TaxAmount` = '7924' ,`TaxRate` = '2.0469' ,`WaterSewe