Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:50:57.327' ,`MLSNumber` = '49327870' ,`ListAgentFullName` = 'Ryan Kutter' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.302940' ,`Longitude` = '-95.352306' ,`PhotoCount` = '31' ,`PostalCode` = '77306' ,`RoomCount` = '6' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Hart' ,`StreetNumber` = '10291' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Seven acres of complete privacy. Located at the end of the road this 3 bedroom 2 bath home was completely remodeled in 2008. Replaced was the electrical, plumbing, insulation, sheetrock walls with 2x4 studs and ceilings with inset lights. The home was bolted together and placed completely on a concrete slab. After the remodel all inseams were removed so it has the look and feel of a ranch style home. The AC is industrial with sealed metal ducts running under the house. Brand new water heater 2022. Sprinklers encompass the entire house and yard running on their own zones. The pool was professionally installed in 2016 complete with a sand pump and wood deck. 24X24 building with concrete floor. 12X12 well house. 1200 square foot garage attached to the house and additional storage room. Covered BBQ pit/cooking shelter. Fenced in and irrigated garden. Horseshoe pits for outdoor fun. Land slopes down and to the left from the back of the home. The rest is of the property is wooded.' ,`Acres` = '7.3928' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'A0188 A0188 - DAVIS JOHN A, TRACT 19, LT 1,4, SERIAL S1332U,' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Abstract Area 31 (FM 1485 Loop to SH 242' ,`TaxAmount` = '1013' ,`TaxRate` = '1.9103' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132317' WHERE `Matrix_Unique_ID` = '201161260' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:08:27.990' ,`MLSNumber` = '44801184' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.943075' ,`Longitude` = '-95.689828' ,`PhotoCount` = '35' ,`PostalCode` = '77433' ,`RoomCount` = '12' ,`ListPrice` = '849997.00' ,`Status` = 'Active' ,`StreetName` = 'Brazos River' ,`StreetNumber` = '18019' ,`StreetSuffix` = 'Circle' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4073' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HX6812 - This incredible one-story home offers everything you have been searching for. Pulling into the drive, you are welcomed by a lovely stucco and brick elevation with auto-court. As you walk in, you will be welcomed by a beautiful rotunda leading past the study and secondary bedrooms. The breathtaking gourmet kitchen is a chef\'s dream, complete with an island work center with granite countertops and wine chiller. The spacious family room is enhanced with 14-foot ceilings and offers views of the covered patio. Entertain friends and family in the game room and media room, or invite everyone over and enjoy grilling in your outdoor kitchen. After a long day, retreat to the primary suite and discover bowed windows and a spa-like primary bath complete with a spacious shower, garden tub and walk-in closet. Come visit today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10397' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1674' ,`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` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Towne Lake' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664132317' WHERE `Matrix_Unique_ID` = '201485438' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:52:36.913' ,`MLSNumber` = '9915607' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.759171' ,`Longitude` = '-95.868296' ,`PhotoCount` = '24' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '574990.00' ,`Status` = 'Active' ,`StreetName` = 'Partridgeberry' ,`StreetNumber` = '2210' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2652' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ASHTON WOODS NEW CONSTRUCTION - Enter into this beautiful and spacious home. The Dominion Plan, featuring 4 bedrooms, 3 baths, a private study, Retreat, & 3-car garage. Kitchen designed to entertain, open to family room, has lots of windows. Ultra off white cabinetry, Quartz counters in kitchen & primary bath, kitchen Santorini white backsplash, Wood flooring throughout main areas, stainless-steel appliances, 8\' doors downstairs, upgraded pad and carpet in bedrooms, Pre-wire Camera & security system. Days on market reflect the number of days the home has been under construction.' ,`Acres` = '0.1817' ,`Area` = '30' ,`BuilderName` = 'Ashton woods' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Firethorne Section 15, Lot 3, Block 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7916' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`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` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Firethorne' ,`TaxAmount` = '' ,`TaxRate` = '2.61' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664132317' WHERE `Matrix_Unique_ID` = '207189646' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:44:42.680' ,`MLSNumber` = '39858044' ,`ListAgentFullName` = 'Andrew Czobor' ,`ListOfficeName` = 'RE/MAX Metro' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795996' ,`Longitude` = '-95.398204' ,`PhotoCount` = '49' ,`PostalCode` = '77008' ,`RoomCount` = '20' ,`ListPrice` = '1495000.00' ,`Status` = 'Active' ,`StreetName` = 'Heights' ,`StreetNumber` = '1341' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Brownstone, three-story home located in the prestigious Heights, facing the boulevard hike/bike green esplanade. Over 5,200SF of living space, 5 bedrooms, 4.5 baths. LOCATION X3! Close to restaurants and shops; few minutes from major freeways to downtown, energy corridor, Galleria, Montrose, River Oaks, Memorial Park, etc. Unique and versatile floorplan: 1st floor with 1,300+SF could be a separate unit for lease, vacation rental, in-laws, game room, office or business. Also, a fully furnished garage apartment for guests or added income. Exquisite interior charm and craftmanship. DETAILS x3! Hardwoods, high ceilings, loads of light, elevator shaft, fully remodeled primary bathroom, oversized bedrooms and storage. All windows replaced, plantation shutters throughout. Front courtyard, backyard and deck. Ready to move in. Dimensions are estimates. All appliances stay. Garage apt. furnishings stay. No HOA. Never flooded. See attached list of features and Upgrades for more details.' ,`Acres` = '0.0933' ,`Area` = '9' ,`BuilderName` = 'Harry James Building' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 1 BOULEVARD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4064' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'French,Traditional' ,`Subdivision` = 'Boulevard Sub' ,`TaxAmount` = '21657' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132317' WHERE `Matrix_Unique_ID` = '207357739' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:15:44.220' ,`MLSNumber` = '8353285' ,`ListAgentFullName` = 'Helen Pac Franco' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780575' ,`Longitude` = '-95.429712' ,`PhotoCount` = '45' ,`PostalCode` = '77007' ,`RoomCount` = '4' ,`ListPrice` = '569500.00' ,`Status` = 'Active' ,`StreetName` = 'Petty' ,`StreetNumber` = '5934' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2345' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Modern Architecture located in the desirable Cottage Grove Area. This Lovely, free-standing unit is under construction. It has 3 bedrooms, 3.5 baths. This home will feature an amazing kitchen with a large island bar, quartz countertops, Stainless Steel Appliances, and a gas range. 10 Foot Ceilings on every level, Primary Bath with dual vanities, walking shower, and spa-like tub. Engineered Wood Floors, Double-Pane Sound Proof Windows, High Efficient Trane HVAC, Tank-less Water Heater, and a Large Roof-Top Terrace. NO HOA. Construction already underway and the house is ready to be shown. Estimated completion SEPT 2022. \r\nThis home is conveniently located close to the Houston coolest Shops, Patio Cafés, Art Galleries, Trendy Eatery Places. Easy access to I-10. Five miles approx. away from Northwest of Downtown Houston, Three miles approx. away from the Galleria Area and River Oaks. $5K Builder Incentive Apply Towards Closing Cost. Don\'t miss out!' ,`Acres` = '0.0339' ,`Area` = '9' ,`BuilderName` = 'Clariss Group LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cottage Grove' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 TOWNHOMES AT PETTY STREET' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Townhomes/Petty Street' ,`TaxAmount` = '1822' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664132318' WHERE `Matrix_Unique_ID` = '207517323' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:07:24.250' ,`MLSNumber` = '66301893' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.936465' ,`Longitude` = '-95.746295' ,`PhotoCount` = '21' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '799998.00' ,`Status` = 'Active' ,`StreetName` = 'Alligator Gar' ,`StreetNumber` = '16234' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3418' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This former modern stucco front model 2-story home with covered front patio, invites you through the foyer and leads to a beautiful spiral staircase. The formal dining room is spacious, with plenty of room for friends and family to gather. The open-concept kitchen, with tons of storage space, custom backsplash, stainless steel appliances, and a butler\'s pantry, pours straight out into the family room and the breakfast nook. Retreat to your spacious master suite with an oversized walk-in closet, shower with a seat, and stand alone tub. It also has a game room for kids to play and lounge! This home has amazing additional features including a media room, and an individual bathroom for every bedroom. Head out back to the covered patio with outdoor kitchen to entertain guests or to enjoy a relaxing Texas sunset. You have plenty of privacy with no neighbor on one side, extra landscaping & a spacious 3-car tandem garage. Don\'t miss out on this incredible home zoned to CY-Fair!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '8632' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664132318' WHERE `Matrix_Unique_ID` = '207672383' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:39:53.900' ,`MLSNumber` = '11883829' ,`ListAgentFullName` = 'LaTisha Grant' ,`ListOfficeName` = 'TAS Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.805809' ,`Longitude` = '-95.316380' ,`PhotoCount` = '8' ,`PostalCode` = '77026' ,`RoomCount` = '0' ,`ListPrice` = '140000.00' ,`Status` = 'Active' ,`StreetName` = 'Pardee' ,`StreetNumber` = '5414' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '2206' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Currently occupied as a religious venue located in a residential area. In accordance to HCAD this conversion is as simple as the completion of one document. This unit is located two blocks inside the loop and is ready for your unique touch.' ,`Acres` = '0.1148' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 613B & 614B BLK 44 KASHMERE GARDENS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KASHMERE GARDENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Kashmere Gardens' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664132318' WHERE `Matrix_Unique_ID` = '208088001' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:24:56.907' ,`MLSNumber` = '19936765' ,`ListAgentFullName` = 'Katherine Massey' ,`ListOfficeName` = 'NextHome Realty Solutions BCS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.508946' ,`Longitude` = '-95.529165' ,`PhotoCount` = '50' ,`PostalCode` = '77459' ,`RoomCount` = '13' ,`ListPrice` = '1548000.00' ,`Status` = 'Active' ,`StreetName` = 'Hope Farm' ,`StreetNumber` = '35' ,`StreetSuffix` = 'Road' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5755' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Westport custom home in award winning community of Sienna. Amazing lake and pool views.\r\nWow entrance with 2 story living and dining rooms. Must see in person to truly appreciate. Great home\r\nfor entertaining with very large kitchen, breakfast and family area. Lots of outdoor covered living space\r\nand large pool with tremendous deck surrounding entire space. Large Master with 2 sided fireplace to\r\nsitting area. Large His/Hers closets. Large master bath with vanity mirrors to the ceiling. 2 nd bedroom\r\ndown. 3 bedrooms up which have vaulted ceilings and large windows all with great views. Oversized 4\r\ncar garage and 3 walk in attic spaces provide all the storage you will need. 3 new 16 seer HVAC, 2 new\r\n50 gal water heaters, new hardwood floors, new stainless appliances, pool with lifetime warranty, and\r\nrecent metal fence eliminate any big costs. Extremely energy efficient design. No MUD taxes.' ,`Acres` = '1.3475' ,`Area` = '38' ,`BuilderName` = 'Westport' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA ACREAGE ESTATES PHASE 1, BLOCK 5, LOT 11, ACRES 1.347' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '58697' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1310' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SIENNA CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Acreage Estates Ph 1' ,`TaxAmount` = '22344' ,`TaxRate` = '2.1129' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132318' WHERE `Matrix_Unique_ID` = '208920291' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:24:34.630' ,`MLSNumber` = '19236288' ,`ListAgentFullName` = 'Richard Orellana' ,`ListOfficeName` = 'Nextgen Real Estate Properties' ,`SellingAgentFullName` = 'Valerie Le' ,`SellingOfficeName` = 'Nextgen Real Estate Properties' ,`Latitude` = '29.528929' ,`Longitude` = '-95.168847' ,`PhotoCount` = '23' ,`PostalCode` = '77546' ,`RoomCount` = '8' ,`ListPrice` = '319000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lighthouse View' ,`StreetNumber` = '16911' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2434' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A handsome redbrick of pleasing proportions, this home is nestled on a quiet Friendswood street in a community of neighbors who care. Open-concept and effortlessly functional, the floorplan includes an office and an additional flex space. New flooring and contemporary warm/neutral paintwork are among many recent improvements. With vaulted ceilings and Palladian windows, the primary bedroom is one of several rooms to benefit from amplified light and flow. French doors open onto a leafy back yard with a large covered patio: perfect for drinks as the sun dips down behind the trees. At Heritage Park, the clue is in the name: this is where many put down roots and make memories among the well-maintained amenities, ranging from playgrounds and trails to swimming, tennis and basketball. Walking distance to some of the beloved neighborhood schools as well as an array of dining and retail, this never-flooded home is the perfect base to build a life rich in people and experience.' ,`Acres` = '0.134' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 4 HERITAGE PARK SEC 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5837' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GREENE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Park Sec 20' ,`TaxAmount` = '5718' ,`TaxRate` = '2.166' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132318' WHERE `Matrix_Unique_ID` = '209398903' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:27:29.580' ,`MLSNumber` = '21855703' ,`ListAgentFullName` = 'Rebecca Thomas' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.911441' ,`Longitude` = '-94.813167' ,`PhotoCount` = '36' ,`PostalCode` = '77535' ,`RoomCount` = '6' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 417' ,`StreetNumber` = '689' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2096' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you are looking for a little land & a waterfront home tucked away in Dayton, this one is for you. Enjoy the Gorgeous view of Champions Lake from this home nestled on 1.14 acres. This 3/2/2 custom built home is well kept with beautiful Brazilian wood floors and cedar beams. Sellers have recently added all new paint, custom cabinets and beautiful granite counters, brand new 4 ton AC, stainless appliances, dishwasher with french doors,and much more. Roof is approximately 2 years. Call for a tour today! They do not come any nicer than this home.' ,`Acres` = '1.14' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WOODRIDGE PARK SOUTH, BLOCK 1, LOT 28, 29 (W/2), ACRES 1.14' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '49658' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'KIMMIE M. BROWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodridge Park South' ,`TaxAmount` = '4222' ,`TaxRate` = '1.7625' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132318' WHERE `Matrix_Unique_ID` = '209517352' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:46:21.847' ,`MLSNumber` = '59338477' ,`ListAgentFullName` = 'Lacy Glaspie' ,`ListOfficeName` = 'Mainstream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.196305' ,`Longitude` = '-95.120533' ,`PhotoCount` = '27' ,`PostalCode` = '77372' ,`RoomCount` = '4' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Rio Blanco' ,`StreetNumber` = '27684' ,`StreetSuffix` = 'Drive' ,`City` = 'Splendora' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2547' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bedroom, 3-bathroom home on a 1.2-acre lot in the Rio Vista subdivision. Home features a spacious family room, high ceilings, fireplace, granite counter tops, formal dining, primary suite with huge walk-in closet, backyard has a covered patio with ceiling fan. Neighborhood features security patrol. Sold AS IS.' ,`Acres` = '1.21' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Real Estate Owned' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'S827600 - RIO VISTA, BLOCK 3, LOT 34, ACRES 1.21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '52708' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Rio Vista' ,`TaxAmount` = '6552' ,`TaxRate` = '1.9783' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664132319' WHERE `Matrix_Unique_ID` = '209575324' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:42:52.113' ,`MLSNumber` = '32701141' ,`ListAgentFullName` = 'Drue DaSilva' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = 'Vivian Jones' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.531430' ,`Longitude` = '-95.396389' ,`PhotoCount` = '46' ,`PostalCode` = '77578' ,`RoomCount` = '13' ,`ListPrice` = '525000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Maple Oak' ,`StreetNumber` = '2811' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3019' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to this GORGEOUS, BARELY LIVED IN 1-STORY with 4 beds/3.5 baths/3-car garage in the master-planned community of Pomona. With great curb appeal & located on a tree-lined street, it is so close to the neighborhood’s many amenities. Built by Highland Homes, this open-concept floorplan is immaculate, move-in ready, spacious & inviting! It is so functional and includes a study with French doors, open formal dining & family room, flex room entertainment space perfect for a game room or media room & all of the spacious bedrooms are on 1 level. The primary retreat is fabulous & is a spa-like experience with soaking tub, separate shower & large custom closet with Elfa. The home features wood-look tile, ample natural light, high ceilings, blinds, neutral paint, covered patio & NO NEIGHBORS BEHIND. The GOURMET KITCHEN is spectacular with a large island, Benedettini Cabinetry and ample storage & counter space. With the great flow from room to room, this is an ENTERTAINER’S DREAM HOME.' ,`Acres` = '0.1865' ,`Area` = '5' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'POMONA SEC 2 (A0417 ACH&B & A0540 ACH&B) BLK 2 LOT 22' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8124' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1190' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'POMONA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pomona' ,`TaxAmount` = '14930' ,`TaxRate` = '3.6594' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132319' WHERE `Matrix_Unique_ID` = '209882288' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:59:21.330' ,`MLSNumber` = '61886222' ,`ListAgentFullName` = 'M.Cathy Finck' ,`ListOfficeName` = 'Taylor Real Estate Group, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.760722' ,`Longitude` = '-95.523124' ,`PhotoCount` = '46' ,`PostalCode` = '77024' ,`RoomCount` = '15' ,`ListPrice` = '3299000.00' ,`Status` = 'Active' ,`StreetName` = 'Dunnam' ,`StreetNumber` = '4' ,`StreetSuffix` = 'Lane' ,`City` = 'Bunker Hill Village' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6986' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning residence in the heart of Bunker Hill Village has been extensively updated with extreme attention to detail. It is the perfect combination of open concept with intimate gathering spaces for entertaining and to welcome you home. You will not want to miss the primary bathroom downstairs, updated with designer finishes and fixtures. This home has large bedrooms, updated bathrooms and a chef\'s kitchen that flows into the expansive family room. The backyard and pool have also been transformed making this dreamy home perfect for backyard gatherings. It has a three-car garage and extra parking in the gated driveway and is zoned to award winning SBISD schools.' ,`Acres` = '0.4705' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 DUNNAM ESTATES' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '20493' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`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,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English,Traditional' ,`Subdivision` = 'Dunnam Estates' ,`TaxAmount` = '51701' ,`TaxRate` = '2.1656' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132319' WHERE `Matrix_Unique_ID` = '210248749' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:43:15.277' ,`MLSNumber` = '4623122' ,`ListAgentFullName` = 'Drue DaSilva' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.987829' ,`Longitude` = '-95.144999' ,`PhotoCount` = '47' ,`PostalCode` = '77346' ,`RoomCount` = '11' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Aquatic' ,`StreetNumber` = '18703' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2599' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'IMMACULATELY MAINTAINED, 1-STORY home on a PREMIUM, GOLF COURSE LOT. This home is FULL OF UPGRADES & is MOVE-IN READY. 2 attached garages for 3 cars. The oversized, extended, covered back patio with flagstone has an outdoor kitchen & granite-topped bar area ready for entertaining. This corner lot gives a great view of the course & has NO BACK NEIGHBORS. The home features 4 Beds/2 Baths (4th bed could be private study) & an open floor plan with great flow. The large, curved window & cathedral ceiling in the formal dining are stunning. The updated gourmet kitchen will wow you, as will the family room with custom built-ins. Enjoy the bamboo floors, 4\" shutters & 2\" blinds, crown molding, neutral paint, contemporary lighting & ample windows throughout. Low maintenance yard with lush landscaping, wrought-iron fence & sprinkler system. Convenient to W. Lake Houston Pkwy, IAH, 59 & Bltwy 8. Shopping, dining, golf & entertainment surround this wonderful, sought-after neighborhood. No flooding.' ,`Acres` = '0.1869' ,`Area` = '1' ,`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` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 43 BLK 29 CHAMPIONS VILLAGE WALDEN ON LAKE HOUSTON PH 5' ,`LotDesciption` = 'Cleared,Corner,In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '8142' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '399' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'MAPLEBROOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden On Lake Houston' ,`TaxAmount` = '7074' ,`TaxRate` = '2.5885' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132319' WHERE `Matrix_Unique_ID` = '210346922' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:14:04.913' ,`MLSNumber` = '27385998' ,`ListAgentFullName` = 'Hollie Rasberry' ,`ListOfficeName` = 'Virginia Malone & Assoc.,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.078767' ,`Longitude` = '-95.265546' ,`PhotoCount` = '20' ,`PostalCode` = '77365' ,`RoomCount` = '8' ,`ListPrice` = '268000.00' ,`Status` = 'Active' ,`StreetName` = 'Langwell' ,`StreetNumber` = '20137' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1948' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME to this light and bright 3 BEDROOM/ 2 BATHROOM home featuring 9 ft ceilings throughout. The kitchen has a large island, walk in pantry, black Whirlpool appliances, and GREAT storage. The well designed split floorplan also provides a dining area and a generous, yet cozy, living room. Secondary bedrooms are sizable and share a full bathroom. The primary retreat is spacious, and adorned with a walk in closet and full private en suite. ADDITIONAL Large flex room can be used as an office, game room, media room, or easily converted into a FOURTH BEDROOM! The backyard is sizable, with an oversized slab patio, and backs to an easement offering additional privacy. Home has plenty of storage, is within walking distance to the elementary, and convenient to I59/99. VERY MOTIVATED SELLER, this home is a MUST SEE!' ,`Acres` = '0.1218' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Kingwood NW/Oakhurst' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S273105 - BROOKWOOD FOREST 05, BLOCK 3, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5305' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '740' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BROOKWOOD FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brookwood Forest 05' ,`TaxAmount` = '7201' ,`TaxRate` = '3.6131' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132319' WHERE `Matrix_Unique_ID` = '210949116' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:37:00.707' ,`MLSNumber` = '78828859' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.043663' ,`Longitude` = '-95.490107' ,`PhotoCount` = '21' ,`PostalCode` = '77379' ,`RoomCount` = '3' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Luminescent' ,`StreetNumber` = '18805' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1274' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Townhomes of Ambient Living at Kuykendahl is ready to show now! Experience a neighborhood feel, with new construction 2-story single-family homes including 3 bedrooms, 2.5 bathrooms, and backyards all within a gated community. Open concept floor plans mapped with multi-functional rooms designed to suit any lifestyle. Granite countertops, stainless appliances and tankless water heaters are among the many customary offerings here. This gated townhome community is nestled just north of Spring/Klein area. Minutes away from The Woodlands, major freeways, and popular eateries and entertainment. The Townhomes of Ambient Living at Kuykendahl is the perfect community to jump-start your future!Move in this September!' ,`Acres` = '0.0323' ,`Area` = '13' ,`BuilderName` = 'Novi Homebuilders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 5 AMBIENT LIVING AT KUYKENDAHL' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1409' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'ROTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Ambient Living/Kuykendahl Rese' ,`TaxAmount` = '1030' ,`TaxRate` = '2.8265' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664132319' WHERE `Matrix_Unique_ID` = '211004399' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:14:56.233' ,`MLSNumber` = '29352640' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'Gracepoint Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.191214' ,`Longitude` = '-95.785753' ,`PhotoCount` = '7' ,`PostalCode` = '77355' ,`RoomCount` = '8' ,`ListPrice` = '759990.00' ,`Status` = 'Active' ,`StreetName` = 'High Meadow Preserve Drive' ,`StreetNumber` = '25631' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '3721' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Gracepoint Homes Construction in beautiful Magnolia, TX. Brand new two story floor-plan. Includes five bedrooms, study and game room! Large, extended covered back patio over -looks beautiful 1-acre wooded lot. Upgraded interior selections and appliance package. This home is expected to be complete December 2022.\r\nMODEL HOME NOW OPEN' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Gracepoint Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S582250 - High Meadow Preserve, BLOCK 1, Lot 48' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric 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,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Preserve' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664132320' WHERE `Matrix_Unique_ID` = '211053903' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:18:30.497' ,`MLSNumber` = '54759302' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'Gracepoint Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.191214' ,`Longitude` = '-95.785753' ,`PhotoCount` = '7' ,`PostalCode` = '77355' ,`RoomCount` = '5' ,`ListPrice` = '699990.00' ,`Status` = 'Active' ,`StreetName` = 'Whispering Creek Trail' ,`StreetNumber` = '19828' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3101' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gracepoint Homes new construction in The Preserve. Beautiful new elevation and floor-plan. Four bedroom, 3.5 baths and 3 car garage. Large primary suite. Painted brick \'Transitional\' elevation. Construction estimated to be complete December 2022 - MODEL NOW OPEN' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Gracepoint Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S582250 - High Meadow Preserve, BLOCK 1, Lot 22' ,`LotDesciption` = 'Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric 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,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'The Preserve' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664132320' WHERE `Matrix_Unique_ID` = '211062480' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:01:05.387' ,`MLSNumber` = '80267403' ,`ListAgentFullName` = 'Remo Castillo' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801221' ,`Longitude` = '-95.309344' ,`PhotoCount` = '10' ,`PostalCode` = '77026' ,`RoomCount` = '8' ,`ListPrice` = '189800.00' ,`Status` = 'Active' ,`StreetName` = 'Kress' ,`StreetNumber` = '4503' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Big Discount for a Quick Sale !!!! Great Property provides best living with easy access to downtown and public transit. It has 3 comfortable bedrooms with a friendly open plan. Extra storage ( 17 X 17 ). It has a great in-law apartment. A large yard with plenty of space to entertain, & relax.' ,`Acres` = '0.2342' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 296 BLK 16 LIBERTY GARDENS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10200' ,`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` = 'ISAACS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Liberty Gardens' ,`TaxAmount` = '2004' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664132320' WHERE `Matrix_Unique_ID` = '211141045' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:26:06.873' ,`MLSNumber` = '18990419' ,`ListAgentFullName` = 'Victoria Lenerd' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.868561' ,`Longitude` = '-95.200438' ,`PhotoCount` = '19' ,`PostalCode` = '77044' ,`RoomCount` = '4' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'White Fir Villa' ,`StreetNumber` = '10319' ,`StreetSuffix` = 'Avenue' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1460' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to a cozy 4-bedroom 2 bath home in Evergreen Villas where you will enjoy the small community feel. This well-maintained home consists of vinyl flooring throughout living and wet areas. Relax in the backyard with a built-in patio or cool off from the heat and take a dip in the private neighborhood pool. The elementary school is conveniently located right outside of the neighborhood and a short distance from the new C.E King High School, and Generation Park. Take advantage of quick access to Beltway 8, nearby shopping and restaurants.' ,`Acres` = '0.101' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 6 EVERGREEN VILLAS SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'CARROLL ELEMENTARY SCHOOL (SHELDON)' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Evergreen Villas Sec 2' ,`TaxAmount` = '5376' ,`TaxRate` = '3.0293' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132320' WHERE `Matrix_Unique_ID` = '211182997' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:25:27.573' ,`MLSNumber` = '18126283' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.711917' ,`Longitude` = '-95.853727' ,`PhotoCount` = '22' ,`PostalCode` = '77441' ,`RoomCount` = '10' ,`ListPrice` = '593909.00' ,`Status` = 'Active' ,`StreetName` = 'Kenton Place' ,`StreetNumber` = '5222' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3433' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LIKE NEW... Stunning One Story home in the heart of Cross Creek Ranch Master Planned Community. Featuring 4 bedrooms, 3 bathrooms, Game Room, Private study, PLUS a 3 CAR GARAGE- this home will not disappoint. Formal entry with tall ceilings, tile flooring, and a home office with new double doors are just some of the details you will notice upon entering. This beautiful floorplan offers a spacious living area with tall ceilings and a gas fireplace. Well laid out open kitchen with butler pantry, stainless steel appliances, under cabinet lighting, and center island. Expansive primary retreat with en-suite bath featuring dual sinks, separate shower, and soaking tub. The home backs to green space and walking trails. Oversized back and side yard. ROOM FOR A POOL! Fresh paint throughout! Light and Bright! New flooring in all bedrooms. Cross Creek Ranch features miles of walking and biking trails, community pools, tennis courts, pickle ball courts and other amenities. Exemplary KISD!' ,`Acres` = '0.2502' ,`Area` = '36' ,`BuilderName` = 'Perry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEK BEND AT CROSS CREEK RANCH SEC 6, BLOCK 1, LOT 13' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '10897' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'JAMES E RANDOLPH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creek Bend At Cross Creek Ranch Sec 6' ,`TaxAmount` = '12411' ,`TaxRate` = '3.1375' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132320' WHERE `Matrix_Unique_ID` = '211194885' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:48:48.443' ,`MLSNumber` = '68228620' ,`ListAgentFullName` = 'Adriane Taylor' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = 'Oneal Texada' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '30.143366' ,`Longitude` = '-95.433678' ,`PhotoCount` = '50' ,`PostalCode` = '77386' ,`RoomCount` = '10' ,`ListPrice` = '375000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hanna' ,`StreetNumber` = '26226' ,`StreetSuffix` = 'Road' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming Colonial Meets Modern Design! Situated On Nearly 1/2 An Acre Of A Private Wooded, Lot! Tasteful Updates In Kitchen Include; Custom Cabinetry W/Beautiful Hardware, Silestone Counters + Bar, KitchenAid Convection Microwave/Oven, 5-Burner Gas Cooktop W/Vent Hood. Fully Remodeled Primary Bath Has A Double Vanity & An Accessible Walk-In Shower W/Bench Seat. Second Floor Bath Has Updated Vanities, Fixtures, Floors, & Tile Surround Shower/Tub Combo. This Home Combines The Allure Of Classic Design W/State Of The Art Amenities Including Energy Star Appliances, LED Lights, High-Efficiency HVAC, Insulated Doors, Radiant Attic Barrier & More-All Helping To Keep Your Energy Costs Low. The Detached Oversized 2-Car Garage Provides Ample Space For Cars + Room For A Workshop/Mancave. Conveniently Located Across From The Woodlands - Full Of Restaurants, Shops, Hospitals, Entertainment Options & More. Zoned To Highly Acclaimed Conroe ISD, LOW Taxes, & NO HOA! What More Can You Ask For?!' ,`Acres` = '0.4649' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'SPRING OAKS, LOT 67' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '20250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'OAK RIDGE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Spring Oaks' ,`TaxAmount` = '3569' ,`TaxRate` = '2.0087' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132320' WHERE `Matrix_Unique_ID` = '211223078' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:32:41.660' ,`MLSNumber` = '97312196' ,`ListAgentFullName` = 'Rubeena Aggarwal' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.751966' ,`Longitude` = '-95.821188' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '16' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Crystal Meadow' ,`StreetNumber` = '1615' ,`StreetSuffix` = 'Place' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4339' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Understated elegance and minimal maintenance with no carpet. Note the recent upgrades: Brand-new SS appliances, granite countertops in kitchen, all bathrooms and the utility room, upgraded master bath, brand-new light fixtures, brand-new Kohler bath fixtures and Kohler/Kraus sinks throughout, brand-new wood flooring, sprinkler system, Pelican/Pentair whole home water purifier and filter system. Game room has extra plumbing connection for the bar area and garage for a half bath. From extensive crown molding throughout the home to a reinforced subfloor on the second floor, it\'s a very well cared for home. The lot is just under 12,000 sq ft, making it one of the largest in Grayson Lakes which boasts of 30 acres of green space, 33+ acres of 4 usable lakes, boat docks, fitness trails, clubhouse with pool and tennis courts. Less than 10 Minutes from I-10 and Katy Mills Mall! Great Katy ISD schools, LOW TAXES! This beautiful 5 bedroom 4 1/2 bath home is ready for immediate move in !' ,`Acres` = '0.2755' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COUNTRY LAKES AT GRAYSON LAKES SEC 6, BLOCK 3, LOT 9' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11999' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOODCREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Lakes At Grayson Lakes Sec 6' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132321' WHERE `Matrix_Unique_ID` = '211242996' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:39:51.353' ,`MLSNumber` = '12873840' ,`ListAgentFullName` = 'Karina Wade-Gledhill' ,`ListOfficeName` = 'Seabrook Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.575398' ,`Longitude` = '-95.052585' ,`PhotoCount` = '39' ,`PostalCode` = '77586' ,`RoomCount` = '14' ,`ListPrice` = '604500.00' ,`Status` = 'Active' ,`StreetName` = 'Harborcrest' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Drive' ,`City` = 'Seabrook' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FROM THE MOMENT YOU WALK-IN YOU WILL NOTICE AN ELEGANT HOME WITH BEAUTIFUL MODERN FINISHES, AND STUNNING NATURAL LIGHTING. HOME IS COMPLETELY UPDATED FROM TOP TO BOTTOM INCLUDING NEW ROOF, NEW DRIVEWAY, NEW A/C, NEW WINDOWS, NEW FLOORING, NEW KITCHEN, NEW BATHROOMS, NEW APPLIANCES, NEW FIXTURES, NEW PAINT ETC. THIS 3,836 SQFT., 4 BEDROOM, 3.5 BATH, HOME HAS AN 11,884 SQFT. FENCED IN PROPERTY WITH A WOODEN OUTDOOR PATIO. THE NEW KITCHEN HAS A MUST SEE WALK IN PANTRY, QUARTZ COUTERTOPS, BREAKFAST BAR, AND EASY ACCESS TO THE OVERSIZED LAUNDRY ROOM AND HALF BATHROOM. THE FAMILY ROOM HAS A BRICK GAS FIRE PLACE, AND FRENCH DOORS OPEN UP INTO THE ADDITIONAL LIVING AREA.THE UPSTAIRS PRIMARY BEDROOM FEATURES A VERY LARGE CUSTOM WALK-IN CLOSET WITH BEAUTIFUL LIGHTING, AND MUST SEE PRIMARY BATHROOM. THIS HOME HAS NEVER FLOODED. THIS HOME IS LOCATED IN THE DESIRABLE WATERFONT COMMUNITY OF TIMBER COVE IN 77586, WITH PARKS, WALKING TRAILS, BOATING AND FISHING ALL CLOSE BY.' ,`Acres` = '0.2728' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 4 TIMBER COVE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11884' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Cove Sec 01' ,`TaxAmount` = '8135' ,`TaxRate` = '2.279' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132321' WHERE `Matrix_Unique_ID` = '211333665' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:28:29.267' ,`MLSNumber` = '95423624' ,`ListAgentFullName` = 'Brad Bortz' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.913890' ,`Longitude` = '-95.653572' ,`PhotoCount` = '32' ,`PostalCode` = '77095' ,`RoomCount` = '7' ,`ListPrice` = '333000.00' ,`Status` = 'Active' ,`StreetName` = 'Aber Trail' ,`StreetNumber` = '8931' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2510' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Aberdeen Green; a wonderful family-oriented community, convenient to all your needs. This beautiful home sits on the corner of a quiet cul-de-sac. The vaulted family room lets the Sun Shine In! Large windows overlooking the paver patio drench the home with natural light. Cozy up to your stone, wood-burning & gas, fireplace on those chilly Houston nights. Offering a large formal dining room for those family holiday gatherings, and a large breakfast room off the kitchen for your everyday gastronomic enjoyment. The first-floor primary BR has an en-suite bath with a separate shower, double vanities, and a very spacious walk-in closet. On the second floor, you will find two oversized bedrooms, a full bath, and a sizeable game room, workout area, or perhaps a playroom for the kids. Just a 5-minute walk to the lake and walking path; just across the street from the community swimming pool, clubhouse, and play areas. Freshly painted, New carpeting. NEVER FLOODED. PRIVATELY OWNED.' ,`Acres` = '0.169' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 ABERDEEN GREEN SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7362' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '675' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BIRKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Aberdeen Green Sec 03' ,`TaxAmount` = '6352' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132321' WHERE `Matrix_Unique_ID` = '211388201' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:38:30.923' ,`MLSNumber` = '22433658' ,`ListAgentFullName` = 'Henry Molenaar' ,`ListOfficeName` = 'Vylla Home' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.541786' ,`Longitude` = '-95.170147' ,`PhotoCount` = '15' ,`PostalCode` = '77546' ,`RoomCount` = '6' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Selder' ,`StreetNumber` = '16734' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great 3 bedroom starter home that boasts the following improvements within the last 2 years: New HVAC blower, new roof, luxury vinyl plank in the family room, and new Hardie Plank siding, new back yard fence.' ,`Acres` = '0.1543' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 21 HERITAGE PARK SEC 9 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '165' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'LANDOLT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'WESTBROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Heritage Park Sec 09 R/P' ,`TaxAmount` = '4347' ,`TaxRate` = '2.166' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132321' WHERE `Matrix_Unique_ID` = '211479263' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:15:51.337' ,`MLSNumber` = '45786843' ,`ListAgentFullName` = 'Derek Stevenson' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = 'Derek Stevenson' ,`SellingOfficeName` = 'Keller Williams Professionals' ,`Latitude` = '29.822404' ,`Longitude` = '-95.715812' ,`PhotoCount` = '30' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '255000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Winding Branch' ,`StreetNumber` = '19818' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1869' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming single-story home in the highly-desired Westfield community; zoned to award-winning Katy ISD schools! 1,869 sq.ft. floor plan offers 3 beds & 2 full baths, + 2-car attached garage w/auto-opener. Interior features gleaming wood floors, crown molding, 2\" blinds, upgraded lighting/ceilings fans & more. Cute covered front porch welcomes you inside to the foyer & both formals. Spacious family room w/inviting raised ceilings & stately brick fireplace, opens to updated Chef\'s kitchen w/gorgeous quartz counters & modern SS appliances. Breakfast bar & breakfast space w/window seat for ample seating. Spacious Primary Suite offers sitting area & private en-suite bath w/dual sinks, oversized shower, & dual walk-in closets. Great patio w/grill for outdoor entertaining, overlooks lush backyard w/room to play. Approx 1/4mi to Westfield pool, splash pad, tennis courts & playground. Near endless premier shopping, dining, entertainment, & major highways I-10 & TX-99 for easy commute.' ,`Acres` = '0.1519' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 8 WESTFIELD SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6615' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '373' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RHOADS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CARDIFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield' ,`TaxAmount` = '4112' ,`TaxRate` = '2.387' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132321' WHERE `Matrix_Unique_ID` = '211479612' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:22:41.363' ,`MLSNumber` = '90525857' ,`ListAgentFullName` = 'Codi Beane' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.138268' ,`Longitude` = '-95.393977' ,`PhotoCount` = '21' ,`PostalCode` = '77386' ,`RoomCount` = '8' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Rose Trace' ,`StreetNumber` = '3111' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2660' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Tucked away on a quiet street in The Estates of Legends Trace, this incredible 4 bed/3.1 bath home awaits you. This home has an elegant flow from the formal dining room to the walk-through kitchen and dinette and opening to a great living room which is adorned with a fireplace and lots of natural light. The primary bedroom is located discreetly off the main living area. En-suite primary bathroom equipped with dual sinks, soaking tub, separate shower, and large walk-in closet. With a sprawling game room, the 2nd floor additionally touts 3 separate bedrooms, one with its own en-suite full bath! With its\' beautiful brick exterior, this home also features, wrap-around gutters, full-yard sprinkler system, over-sized back patio and 3-car garage. For your personal security, this home is also equipped with 6 exterior surveillance cameras. Conveniently located minutes from The Woodlands Mall and Houston, the area has a ton of new restaurants and shopping. Top CONROE ISD schools!' ,`Acres` = '0.1736' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S456100 - ESTATES OF LEGENDS TRACE 01, BLOCK 4, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7561' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BRADLEY ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates Of Legends Trace 01' ,`TaxAmount` = '8200' ,`TaxRate` = '3.1987' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132321' WHERE `Matrix_Unique_ID` = '211482742' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:13:23.120' ,`MLSNumber` = '49392874' ,`ListAgentFullName` = 'Amy McInnis' ,`ListOfficeName` = 'Prime Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.559582' ,`Longitude` = '-95.653689' ,`PhotoCount` = '33' ,`PostalCode` = '77479' ,`RoomCount` = '9' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Morningstar' ,`StreetNumber` = '9127' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2385' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Close to highly sought-after Campbell Elementary, Greatwood parks, tennis courts, catch & release lake, & fun pool #3 w/ water slides, splash pad, & lazy river, this well-maintained one-story home offers a more modern, open floorplan with an upscale but comfortable feel featuring high ceilings, moldings, home office w/hardwoods, open dining room & gathering room/flex space, large family room with beautiful, wooded view & 3 spacious bedrooms. Kitchen features upgraded cabinets & counters, GAS range, desk, & walk-in pantry. Interior walls & exterior recently painted (8/22), recent carpet (8/22) 2013 sprinkler system, 2017 water heater, 2017 Trane HVAC w/wifi thermostat, big back yard w/updated fence, & NO BACK NEIGHBORS! You will love Greatwood, a wooded, master planned, golf course community w/a small town feel! Enjoy neighborhood restaurants, shopping at the local HEB, reasonable drive times to the Galleria, Downtown Houston, the Med Center, & all that Fort Bend County has to offer!' ,`Acres` = '0.2035' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREATWOOD STONEBRIDGE SEC 3, BLOCK 2, LOT 20' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '8864' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '915' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greatwood Brazos Bend' ,`TaxAmount` = '6689' ,`TaxRate` = '2.3013' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132322' WHERE `Matrix_Unique_ID` = '211530953' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:15:54.250' ,`MLSNumber` = '60535333' ,`ListAgentFullName` = 'Jennifer Guillen' ,`ListOfficeName` = 'Guillen Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.028828' ,`Longitude` = '-95.471556' ,`PhotoCount` = '42' ,`PostalCode` = '77388' ,`RoomCount` = '14' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Edsall Drive' ,`StreetNumber` = '17319' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2652' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Open House - Sunday, 9/25 from 2pm-4pm!! Welcome to your next home in the sought after subdivision of \"Cypresswood\"!! Beautifully updated home on a cul-de-sac with plenty of room for a family with 5 bedrooms, 2.5 bathrooms, Office, Sunroom, Flex Room, and big backyard!! Surrounded by nature\'s beauty with mature trees on the front lawn, enjoy your view of Magnolia, Sycamore, Sago Palms, and an Ornamental Pear Tree(s). Freshly painted interior, wood-like tile and new carpet throughout all secondary bedrooms; Silestone countertops in Kitchen. Foundation already repaired and comes with a transferrable warranty. Schedule an appt. today - won\'t last long!! **Approx. Room Measurements - Buyer to verify room dimensions**' ,`Acres` = '0.2112' ,`Area` = '13' ,`BuilderName` = 'N/A' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 11 CYPRESSWOOD SEC 4' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HAUDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Sec 04' ,`TaxAmount` = '4649' ,`TaxRate` = '2.4565' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132322' WHERE `Matrix_Unique_ID` = '211537302' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:24:31.480' ,`MLSNumber` = '35148204' ,`ListAgentFullName` = 'Julia Prothro' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.907802' ,`Longitude` = '-95.077478' ,`PhotoCount` = '34' ,`PostalCode` = '77532' ,`RoomCount` = '4' ,`ListPrice` = '339990.00' ,`Status` = 'Active' ,`StreetName` = 'Yoke' ,`StreetNumber` = '619' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2104' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This home has a hard-to-find 4 bedrooms and 3 1/2 bathrooms! When you walk in, your greeted with a long entrance way and a split floor plan. Opening up into the living area with a beautifully tiled fireplace with an open concept living area. Large kitchen island with granite upgrades and stylish tile backsplash. Expansive primary suite opens up into a luxurious en-suite bathroom and large walk-in closet. Extended covered backyard patio leading to a fire-pit area perfect for gatherings!' ,`Acres` = '0.1716' ,`Area` = '1' ,`BuilderName` = 'castle rock' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 1 NEWPORT SEC 8 3RD PAR R/P' ,`LotDesciption` = 'Other' ,`LotSize` = '7474' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '55' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Newport' ,`TaxAmount` = '6875' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132322' WHERE `Matrix_Unique_ID` = '211562819' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:13:20.533' ,`MLSNumber` = '69300767' ,`ListAgentFullName` = 'Summer Bloom' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.140067' ,`Longitude` = '-95.049145' ,`PhotoCount` = '40' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '549000.00' ,`Status` = 'Active' ,`StreetName` = 'Fort Bend' ,`StreetNumber` = '4102' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1258' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular single level home w/canal view in Sea Isle. Close to beach, marina and bay. Recent 2021 updates per sellers: New composite flooring, lighting, updated electrical/plumbing, freshly painted, kitchen backsplash, custom cabinetry, gorgeous tile in bathrooms upstairs/downstairs. Windows (2018). Tons of natural light. Two decks, one facing the street and other facing empty lot w/amazing canal view. Covered deck w/lots of space. Oversized kitchen w/lots of counter/storage space, granite, SS appliances open to living room w/high ceilings. Three large spacious bedrooms w/plenty of closet space. Washer/Dryer/Refrigerator included. Lots of storage in garage & extra storage on backside of house. Updated downstairs bath/shower. Lots of space downstairs for entertaining & parking. Hardy plank siding. Short golfcart ride to the beach, 2 convenience stores, 2 restaurants, swimming pool, tennis, boat ramp. Sold furnished minus few exclusions. See list of upgrades. Come rest, nest or invest!' ,`Acres` = '0.1439' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 1560 SEA ISLE 5TH EXTENSION' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6270' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '225' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric 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` = 'Other Style' ,`Subdivision` = 'Sea Isle Ext' ,`TaxAmount` = '7235' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132322' WHERE `Matrix_Unique_ID` = '211652164' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:30:23.163' ,`MLSNumber` = '14587356' ,`ListAgentFullName` = 'Emily Wang' ,`ListOfficeName` = 'Intown Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.769190' ,`Longitude` = '-95.372022' ,`PhotoCount` = '12' ,`PostalCode` = '77007' ,`RoomCount` = '7' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory' ,`StreetNumber` = '1207' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ABSOLUTELY STUNNING SKYLINE VIEWS of DOWNTOWN! in the LOWER HEIGHTS DISTRICT. SPACIOUS 150+ SF ROOFTOP TERRACE home in HOUSTON VIEWS, a FULLY GATED community w/ a DOG PARK!! NEW construction by Houston\'s award winning builder, InTown Homes. 1207B Hickory St. is a one-of-a-kind 4 Story w/ 12 FT living room ceilings, 10 FT sliding tri-panoramic doors, Luxury BOSCH appliances, quartz counters and custom soft close cabinetry. Luxurious Primary Suite, HUGE walk in closet! Free Standing Tub! 4th Floor game room with the covered roof top deck! Quiet street with NO through traffic!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'InTown Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Washington East/Sabine' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 14 BLOCK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Houston Views' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664132322' WHERE `Matrix_Unique_ID` = '211655523' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:24:42.150' ,`MLSNumber` = '28296609' ,`ListAgentFullName` = 'Sergio Franco' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.850903' ,`Longitude` = '-95.797669' ,`PhotoCount` = '50' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Sunset' ,`StreetNumber` = '5243' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is the home you\'ve been looking for! Beautifully built Beazer home featuring 3 amazing bedrooms plus an office with tons of upgrades, including kitchen custom built cabinet drawers and an extended covered patio that is gorgeous and hand painted. Are you ready to make this your next home? Come see it before it\'s gone!' ,`Acres` = '0.1711' ,`Area` = '25' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 2 KING CROSSING SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7453' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '880' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'King Xing Sec 5' ,`TaxAmount` = '10098' ,`TaxRate` = '3.4768' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132323' WHERE `Matrix_Unique_ID` = '211660281' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:38:45.493' ,`MLSNumber` = '55407746' ,`ListAgentFullName` = 'Debbie Richardson' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.502921' ,`Longitude` = '-95.433327' ,`PhotoCount` = '30' ,`PostalCode` = '77583' ,`RoomCount` = '11' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Lilywood' ,`StreetNumber` = '5511' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2082' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW PRICE! Prior Lennar model. Open & airy floorplan has high ceiling in family room, open to family room from 2nd floor. Laminate, tile & carpeted bedrooms. Very spacious bedrooms and large closets. Comfortable game room up. Huge laundry/utility room with storage. Pretty front porch elevation. Large, fenced backyard for pets, plants and play! Replaced stainless steel appliances. Recent interior paint. Interior speakers. Replaced water heater. Sprinkler system. Oversized backyard for pets, plants, and play! Great location to 288/Medical Center/freeway/beltway. Well maintained home is neat & nice! Ready for new owners asap!' ,`Acres` = '0.1801' ,`Area` = '5' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Mud,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SAVANNAH MEADOWS SEC 3 (A0403 ACH&B-A0562 HT&BRR), BLOCK 3,' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '7845' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SAVANNAH LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes of Savannah' ,`TaxAmount` = '7003' ,`TaxRate` = '3.1908' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132323' WHERE `Matrix_Unique_ID` = '211666597' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:39:25.510' ,`MLSNumber` = '59118770' ,`ListAgentFullName` = 'Selina Cerda' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = 'Selina Cerda' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '30.008915' ,`Longitude` = '-95.566449' ,`PhotoCount` = '25' ,`PostalCode` = '77070' ,`RoomCount` = '5' ,`ListPrice` = '245000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cedar Point' ,`StreetNumber` = '9406' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1476' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this lovely 3 bedroom 2 bath home featuring a 2 car garage, extended front porch with brick pavers, and a covered patio all sitting at the beginning of a cul-de-sac. The interior of the home boast with charm, from crown molding, to granite countertops, and the kitchen features custom cabinetry! You will fall in love! Neutral colored tile floors flow throughout the main living and wet areas of the home while all three bedrooms are complimented by laminate wood floors. The corner gas log fire place makes for a beautiful focal point in the den and a great way to warm up the home on a cold winter day! This home is just minutes away from shopping, dinning and entertainment at the Vintage Park center and has easy acess to HWY 249! You don\'t want to miss out on this one!! Schedule your tour today!' ,`Acres` = '0.1584' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 46 BLK 10 017*C2916900-002-010-046 CHARTERWOOD SEC 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '289' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KRAHN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Charterwood' ,`TaxAmount` = '4300' ,`TaxRate` = '2.474' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132323' WHERE `Matrix_Unique_ID` = '211671026' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:55:49.437' ,`MLSNumber` = '37934803' ,`ListAgentFullName` = 'Pamela Adkins' ,`ListOfficeName` = 'Central Metro Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.871928' ,`Longitude` = '-95.656497' ,`PhotoCount` = '41' ,`PostalCode` = '77084' ,`RoomCount` = '5' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Brookside Willow' ,`StreetNumber` = '16331' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3385' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this spacious Gehan home available in the Bear Creek South area located in Sommerall Park. Built in 2016, the primary bedroom with en-suite features dual separate vanities, garden tub and two walk in closets is located on the first floor. Entertain in the over-sized game room located on the second floor. Secondary bedrooms with walk-in closets and two bathrooms are located off the game room. Enjoy this popular floor plan with a nice size backyard and covered patio. Wired security system included. Waterproof flooring (2021), AC Compressor (2022), S/S appliances. W/D included. Zoned to Langham Creek HS. Become a resident in this well maintained and quiet neighborhood with easy access to Hwy 6 and FM 529. Located near dining, shopping and main roads to I-10, 290, Beltway 8.' ,`Acres` = '0.1587' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 2 SOMMERALL PARK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6914' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HOLMSLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sommerall Park' ,`TaxAmount` = '7953' ,`TaxRate` = '2.641' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132323' WHERE `Matrix_Unique_ID` = '211790093' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:30:15.973' ,`MLSNumber` = '85226303' ,`ListAgentFullName` = 'Maria DeLeon' ,`ListOfficeName` = 'Texas Xpert Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.884221' ,`Longitude` = '-95.477684' ,`PhotoCount` = '46' ,`PostalCode` = '77088' ,`RoomCount` = '3' ,`ListPrice` = '318000.00' ,`Status` = 'Active' ,`StreetName` = 'Green Lawn' ,`StreetNumber` = '8018' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home!!! beautiful home located in Inwood Forest Subdivision, Livingroom has a beautiful view to the pool Master bedroom is downstairs with sliding doors to the pool. 2 bedroom upstairs, studio room by the kitchen can also be converted to a bedroom. Home has granite counter tops throughout, Kitchen with Island with cook top, the garage has been converted to an apartment with its own back door entrance.\r\nAC is 1 year old and has 4 more years warranty. Quiet neighborhood and close to shopping centers and schools.' ,`Acres` = '0.2089' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 12 INWOOD FOREST SEC 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'SMITH ACADEMY' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'HOFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Inwood Forest Sec 12' ,`TaxAmount` = '6374' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132323' WHERE `Matrix_Unique_ID` = '211839832' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:16:19.697' ,`MLSNumber` = '34551807' ,`ListAgentFullName` = 'Kelcie Bennett' ,`ListOfficeName` = 'Etheredge Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.340141' ,`Longitude` = '-95.032006' ,`PhotoCount` = '7' ,`PostalCode` = '77563' ,`RoomCount` = '6' ,`ListPrice` = '205000.00' ,`Status` = 'Active' ,`StreetName` = 'Center St' ,`StreetNumber` = '7606' ,`StreetSuffix` = '' ,`City` = 'Hitchcock' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1041' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is located on just shy of 3 acres. Loads of potential with ample space to build! Located close to shopping and schools with easy access to the freeway.' ,`Acres` = '2.93' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hitchcock' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 13 W H JACK SUR PT OF OUTLOT 1 (1-8) DARTS SUB' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Darts' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664132323' WHERE `Matrix_Unique_ID` = '211979855' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:45:27.783' ,`MLSNumber` = '50463930' ,`ListAgentFullName` = 'M. Carmen Fujimoto' ,`ListOfficeName` = 'Maddie Lowe Properties' ,`SellingAgentFullName` = 'Monica Sinha' ,`SellingOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`Latitude` = '29.882140' ,`Longitude` = '-95.648436' ,`PhotoCount` = '24' ,`PostalCode` = '77095' ,`RoomCount` = '6' ,`ListPrice` = '219000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'River Garden' ,`StreetNumber` = '7206' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1509' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1-story patio home located in the the heart of Copperfield. Open & spacious floor plan with plenty of natural light throughout and shutters too! Gorgeous hardwood flooring throughout! Two bedroom w/a study and Primary bath w/dual sinks, Roof, A/C & interior paint - 2016. All appliances included! The Study can be converted back to a bedroom.' ,`Acres` = '0.1322' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 COPPERFIELD SOUTHPOINT SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '675' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LOWERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Copperfield' ,`TaxAmount` = '3661' ,`TaxRate` = '2.357' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132324' WHERE `Matrix_Unique_ID` = '212032331' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:37:00.707' ,`MLSNumber` = '89509225' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.047003' ,`Longitude` = '-95.492079' ,`PhotoCount` = '20' ,`PostalCode` = '77379' ,`RoomCount` = '2' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Luminescent' ,`StreetNumber` = '18823' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1210' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Townhomes of Ambient Living at Kuykendahl is ready to show now! Experience a neighborhood feel, with new construction 2-story single-family homes including 2 bedrooms, 2.5 bathrooms, and backyards all within a gated community. Open concept floor plans mapped with multi-functional rooms designed to suit any lifestyle. Granite countertops, stainless appliances and tankless water heaters are among the many customary offerings here. This gated townhome community is nestled just north of Spring/Klein area. Minutes away from The Woodlands, major freeways, and popular eateries and entertainment. The Townhomes of Ambient Living at Kuykendahl is the perfect community to jump-start your future! Move in Ready September 2022!' ,`Acres` = '0.0323' ,`Area` = '13' ,`BuilderName` = 'Novi Homebuilders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 5 AMBIENT LIVING AT KUYKENDAHL' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1409' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'ROTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Ambient Living/Kuykendahl Rese' ,`TaxAmount` = '1030' ,`TaxRate` = '2.8265' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664132324' WHERE `Matrix_Unique_ID` = '212133449' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:51:19.680' ,`MLSNumber` = '38619112' ,`ListAgentFullName` = 'Dorothy Mitchell' ,`ListOfficeName` = 'The Gentry Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.289986' ,`Longitude` = '-94.821871' ,`PhotoCount` = '25' ,`PostalCode` = '77551' ,`RoomCount` = '7' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Austin' ,`StreetNumber` = '4924' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1574' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This family home is pristine and ready for you to enjoy, featuring an open concept, with beautiful finishes and fresh paint in and out. Crown Molding throughout the home. Primary bedroom with ensuite and closet. Primary bath includes luxury double sink vanity with quartz countertop, as well as a walk-in shower with gray subway tile design and glass door. The 2nd bathroom is similarly appointed with a luxury double sink vanity and quartz countertop, as well as a new walk-in shower with white subway tile design. Both baths include new toilets, faucets, fixtures and lighting. Upgrades everywhere! Faux fireplace tile wrap and mantle redesign. LED lighting throughout, NuCore luxury vinyl plank flooring as well as new high-impact vinyl windows. Crown molding in all rooms. 4 parking areas in back and two in the front. Roof is only 3 1/2 years old. Great AirBNB prospect. Call and schedule today!' ,`Acres` = '0.1148' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 PAGE 98 LOT 2 PALM GARDENS' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Palm Gardens' ,`TaxAmount` = '4031' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132324' WHERE `Matrix_Unique_ID` = '212174311' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:20:21.223' ,`MLSNumber` = '12038322' ,`ListAgentFullName` = 'Corey Cole' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Jane NgaDung Nguyen' ,`SellingOfficeName` = 'Alpha, REALTORS' ,`Latitude` = '29.339999' ,`Longitude` = '-94.965388' ,`PhotoCount` = '41' ,`PostalCode` = '77563' ,`RoomCount` = '5' ,`ListPrice` = '299924.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bayou' ,`StreetNumber` = '4702' ,`StreetSuffix` = 'Lane' ,`City` = 'Hitchcock' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a must see waterfront home!! Great coastal chic weekend getaway, fishing location, or just amazing views of the sunsets from the covered patio! This 2 bedroom 1 bath home on the bayou is cute and clean with lots of updates. Most recent is a new metal roof in 2022! It is a very open concept and feels larger than it is! Granite kitchen, stainless steel appliances, high ceilings and so much more! This is an active Airbnb so you could continue that to offset cost of a 2nd home or move in and just enjoy it everyday! Furniture negotiable.' ,`Acres` = '0.146' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Hitchcock' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 175 J SPILLMAN SUR LOT 11 (10-1)BLK 26 WITTJEN 7,' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '6360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wittjen 7' ,`TaxAmount` = '3018' ,`TaxRate` = '2.2084' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132324' WHERE `Matrix_Unique_ID` = '212175075' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:58:58.677' ,`MLSNumber` = '82067947' ,`ListAgentFullName` = 'Lisa Rigdon' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.752063' ,`Longitude` = '-95.553185' ,`PhotoCount` = '44' ,`PostalCode` = '77042' ,`RoomCount` = '7' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Lynbrook Hollow' ,`StreetNumber` = '10119' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3287' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this wonderful 4-bedroom, 3-bath home nestled on a corner lot in Briargrove Park. This home features two primary suites, one upstairs and one downstairs, along with an office/flex space, and a beautiful kitchen showcasing granite countertops and stainless steel appliances. The kitchen is a home chef\'s dream with double ovens and a gas cooktop! There is an abundance of storage space with 11 closets, 7 are walk-in and 1 is a cedar closet! Step out into the spacious backyard with space for a pool and extra parking space for up to 3 cars! Recent updates to the home include new carpet on the second floor, fresh paint throughout the interior of the home, a new downstairs furnace and new sewer lines. Enjoy the wonderful neighborhood amenities such as a community pool and tennis courts as well as a short walk to the Mary Ann Francklow Park. This home is ideally located with convenient access to Beltway 8, I-10 and Westpark Tollway. Schedule a tour today!' ,`Acres` = '0.2153' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 BRIARGROVE PARK SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9380' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '685' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briargrove Park Sec 3' ,`TaxAmount` = '13822' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132324' WHERE `Matrix_Unique_ID` = '212205603' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:51:27.390' ,`MLSNumber` = '49177281' ,`ListAgentFullName` = 'Dan Gad' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.475080' ,`Longitude` = '-95.670461' ,`PhotoCount` = '14' ,`PostalCode` = '77356' ,`RoomCount` = '5' ,`ListPrice` = '149930.00' ,`Status` = 'Active' ,`StreetName` = 'Beechnut' ,`StreetNumber` = '15743' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '1598' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful contemporary ready to be lived in home on a prime OVERSIZED yard(additional lot 103 is INCLUDED with the sale) in Hidden Forest. Home is perfect for large gatherings, boasting 5 bedrooms and 2.5 baths. Huge Master Suite, private bathroom. You will find this quaint country home in the quiet Hidden Forest Community surrounded by the National Forest which features a fishing lake and community pool. Imagine coming home after a hard day’s work and sitting on the huge front porch. Zoned to the highly sought-after Montgomery ISD schools. All you need to do is move in! Close to historic downtown Montgomery. LOW TAXES AND NO MUD TAXES. Hurry, priced under market for quick sale!' ,`Acres` = '0.1263' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '1' ,`Legal` = 'HIDDEN FOREST EST 04, LOT 104' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '32' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hidden Forest Estate 04' ,`TaxAmount` = '1607' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132325' WHERE `Matrix_Unique_ID` = '212223001' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:48:09.507' ,`MLSNumber` = '15416416' ,`ListAgentFullName` = 'Kimberly Hangs' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.573216' ,`Longitude` = '-95.425402' ,`PhotoCount` = '34' ,`PostalCode` = '77584' ,`RoomCount` = '14' ,`ListPrice` = '639000.00' ,`Status` = 'Active' ,`StreetName` = 'Laguna Shores' ,`StreetNumber` = '13220' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4119' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '$50,000 in UPGRADES! BACK ON THE MARKET! NEW ROOF 5/22! This WESTIN Home, Pearland property has been a happy home to the present owners and is now looking for a new family to make memories. In Shadow Creek Ranch,home is over 4100 sq ft per HCAD. It overlooks a lovely duck, wildlife filled pond. STUNNING SUNSETS every evening. The POOL and lush back yard are lovingly maintained. The MASTER BEDROOM is DOWNSTAIRS. There are 3 more bedrooms upstairs as well as a GAME ROOM, THEATER, STUDY AREA. 4 BEDROOMS, 3 1/2 BATHS only tells part of the story. It must be seen to be truly appreciated. This is a unique, one-of-a-kind gem. This treasure will go quickly. DID NOT FLOOD-NOT in Flood plane* per owner* EV Level (2) compatible plug in garage. MONTGOMERY ISD w virtual tour.' ,`Acres` = '0.1805' ,`Area` = '5' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-33, BLOCK 1, LOT 13' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '7863' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '845' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'WILDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'NOLAN RYAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf1-Sf2-Sf3' ,`TaxAmount` = '16044' ,`TaxRate` = '3.5409' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132325' WHERE `Matrix_Unique_ID` = '212245430' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:54:30.573' ,`MLSNumber` = '95576406' ,`ListAgentFullName` = 'Jessica Bastidas' ,`ListOfficeName` = 'Southern Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.030846' ,`Longitude` = '-95.536671' ,`PhotoCount` = '40' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '585000.00' ,`Status` = 'Active' ,`StreetName` = 'Erinwood' ,`StreetNumber` = '7515' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 7515 Erinwood Dr. This beautiful and very elegant estate boast 4 bedrooms and 3.5 baths, den, game room, 3rd living room and a formal dining room. This home is located on double lot with a large driveway and extra parking. There is pride of ownership all over this property with many recent renovations, wood like tile floors (2021), renovated kitchen, new water heater (2022) on the west wing, the game room up has built-ins and partial opening to view the den below, 3 car garage, two complete (east and west wing) Trane ultra high efficiency Heating and Cooling systems, including six zones and complete new ductwork, Owens Corning R-48 rolled bales fiberglass in attic and R-60 over front upstairs bedroom, commercial grade automated iron gates to garage and side yard and much more. The pool was replastered (2017) with Pebble Tec Pebble Sheen and new pool pump, motor, and plumbing. This well kept estate is perfect for entertaining. It won\'t last long!' ,`Acres` = '0.3969' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 & TR 8A BLK 3 017*S2915536-001-003-007-008A SHANNON FOR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '17288' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'EHRHARDT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shannon Forest Sec 01 Rep' ,`TaxAmount` = '7726' ,`TaxRate` = '2.5085' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132325' WHERE `Matrix_Unique_ID` = '212280427' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:07:39.787' ,`MLSNumber` = '78870109' ,`ListAgentFullName` = 'Kimberly Verrett' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Christian Aguilera' ,`SellingOfficeName` = 'Dream Home Realty' ,`Latitude` = '30.698646' ,`Longitude` = '-95.538090' ,`PhotoCount` = '19' ,`PostalCode` = '77340' ,`RoomCount` = '10' ,`ListPrice` = '215000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'McCollum' ,`StreetNumber` = '424' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1413' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just unpack & relax in this beautiful 3/2 home! Open concept with breakfast bar and two primary bedrooms! Perfect layout ... home office, roommates, multi-generations, children, work-out room, etc! Fantastic kitchen: soft-close cabinets, granite counters, stainless steel appliances. No carpet. Enjoy the backyard deck and large yard! Back portion of home includes new Hardi plank, plumbing, electrical, & insulation. Freshly painted inside/outside. PEX plumbing. New in 2021-2022: Roof, Gutters, Low-E double paned windows, HVAC & ducts/insulation, Water Heater, Oven/stove & Range hood. It’s ready for you to relax or entertain! Close to Sam Houston Univ and I45.' ,`Acres` = '0.17' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'DAVIDS E SURVEY, LOT 20, ACRES 0.17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7405' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Wood Shingle' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'ESTELLA STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'n/a' ,`TaxAmount` = '1806' ,`TaxRate` = '1.9017' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132325' WHERE `Matrix_Unique_ID` = '212292608' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:50:00.277' ,`MLSNumber` = '46344329' ,`ListAgentFullName` = 'Keith Brown' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Jamie McMartin' ,`SellingOfficeName` = 'Compass RE Texas, LLCKaty' ,`Latitude` = '30.799344' ,`Longitude` = '-95.071703' ,`PhotoCount` = '41' ,`PostalCode` = '77351' ,`RoomCount` = '7' ,`ListPrice` = '390000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Apple Grove' ,`StreetNumber` = '279' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2116' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Imagine a Lake Livingston Lifestyle? You will love this 1/2 acre lot with outstanding outdoor entertaining spaces such as wrap-around porches, screen-in porch & fire pit. Exterior offers cement board siding for durability, 2 car-garage & one bay carport for boat storage. Just inside the charming red front door you’ll find a large living space with wood floors, ceiling fans & natural light. The combination living, dining & kitchen make for a communal space for family & friends. The two-story island kitchen has granite & solid wood cabinetry, double ovens, gas cooktop, breakfast bar & stainless appliances. Spacious primary suite boasts natural light & ensuite bath with shower, double sinks & seated vanity. The study with solid wood built-ins is at the top of the stairway. Two additional bedrooms are located on the first floor serviced by a hallway bath. Community provides manned security at gate, community boat launches, pool, playground area & recreation room. The Lake is waiting!' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = 'Lakewood Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Cedar Point Sec 5, BLK 63, LOTS 19 - 22' ,`LotDesciption` = 'Corner,Subdivision Lot,Water View,Wooded' ,`LotSize` = '28244' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '683' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Point' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132325' WHERE `Matrix_Unique_ID` = '212296683' --> 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','212356635','1664132325','212356635','2022-09-25T09:27:27.433','84571916','Sandra Ferguson','Precision Realty & Mgmt., LLC','','','29.818399','-95.713076','21','77449','10','279000.00','Active','Painted Meadow','3111','Circle','Katy','2','0','3','1832','Single-Family','Conveniently Located in Westfield Near Fry & Morton Roads. Near Shopping & Schools! Just Minutes to Grand Parkway & I-10. This Beautiful Home Features High Open Ceilings in Den, Formal Dining Room & Kitchen. Includes Refrigerator, Gas Range, Dishwasher, Microwave, Huge Walk-In Pantry/Laundry Room. Nice Size Bedrooms & closet space, Huge Master w/ Over sized Walk-in Closet. Master. 2-Car Garage, Door Opener. Landscaping & Sprinkler system. Photos reflect property before last tenant.','','25','','','Washer Connections','','Mud,Sellers Disclosure','1','','1','Katy - North','Central Gas','1','LT 12 BLK 3 WESTFIELD SEC 19','Subdivision Lot','5249','Appraisal District','','437','0','','2','Gas Oven','0','','','Gas Range','','Composition','30 - Katy','MCROBERTS ELEMENTARY SCHOOL','MAYDE CREEK HIGH SCHOOL','CARDIFF JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Westfield','5216','3.005','Water District','2004','Appraisal District'); --> New record created successfully
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','212372855','1664132325','212372855','2022-09-25T08:14:04.177','51984696','Jarrah Fulghum','Doug Erdy Group','','','29.987492','-95.138222','38','77346','10','949000.00','Active','Aquatic','19223','Drive','Houston','3','1','4','3300','Single-Family','Enjoy this Exceptionally Beautiful lakefront home on 1 and 1/2 lots! Lake views through walls and walls of windows! Open concept kitchen. Butlers pantry and walk in pantry. Mudroom off of the garage with custom cabinetry. Granite throughout. Primary bath has jetted tub, double sinks, and separate shower with seamless glass doors. Mechanical blinds in primary room. Large walk in closets in all rooms. Study is private with pocket doors and custom built-ins. Game room up with custom built ins. Two secondary rooms share a Hollywood bath. Media room upstairs, can be a 5th bdrm. Balcony off of game room overlooks the pool and lake. Exceptional Infinity edge pool, overlooking Lake Houston, pool tile completely updated. Outdoor kitchen with ice maker, mini fridge, gas range, and 2 gas burners. Also has Teak wood ceiling and automatic solar shades, Deep sink with granite counters, and tall granite island. Spa/Pool is lit with led lights. Boat dock with lifts, and extended deck/pier.','0.2893','1','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Atascocita South','Central Electric,Central Gas','1','LT 86 & N 1/2 OF LT 87 BLK 29 CHAMPIONS VILLAGE WALDEN ON LA','In Golf Course Community,Waterfront','12600','Appraisal District','','367','0','','3','Convection Oven,Gas Oven,Single Oven','1','Gunite,Heated,In Ground','','Gas Cooktop,Grill','','Composition','29 - Humble','MAPLEBROOK ELEMENTARY SCHOOL','ATASCOCITA HIGH SCHOOL','ATASCOCITA MIDDLE SCHOOL','Appointment Required,Supra Keybox','Seller','2','Traditional','Walden On Lake Houston Ph 05','14247','2.5839','Public Sewer,Water District','2004','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:00:00.770' ,`MLSNumber` = '43291483' ,`ListAgentFullName` = 'Remo Castillo' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.853445' ,`Longitude` = '-95.272812' ,`PhotoCount` = '26' ,`PostalCode` = '77078' ,`RoomCount` = '9' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Seeker' ,`StreetNumber` = '9718' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1478' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Property ! . Fully Remodeled !!!!! New Roof !!!!! Please schedule an appointment to see this property Today !!!' ,`Acres` = '0.1515' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 12 GLENWOOD FOREST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HILLIARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glenwood Forest' ,`TaxAmount` = '2989' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664132325' WHERE `Matrix_Unique_ID` = '212401933' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:54:36.800' ,`MLSNumber` = '40503898' ,`ListAgentFullName` = 'Michelle Weaver' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.805882' ,`Longitude` = '-95.521019' ,`PhotoCount` = '44' ,`PostalCode` = '77080' ,`RoomCount` = '10' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'Livernois' ,`StreetNumber` = '9367' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3376' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning, custom Brookfield home in popular Spring Branch Oaks that has it ALL! Elegantly appointed & energy efficient (new Trane AC units), high end finishes sweep this light filled open layout, ideal for entertaining. Park-like oversized lot is accented by beautiful PebbleTec waterfall pool/spa with waterfall. Fresh exterior paint & new roof, covered front patio & spacious back pool deck make for enjoyable outdoor living. Interior features study, gameroom, 3 bedrooms down, separate suite up, mud room, bonus storage & more. Gourmet kitchen flaunts large island, rich cabinetry & fridge. Great central location w/ easy access going East or West in SBISD.' ,`Acres` = '0.3598' ,`Area` = '24' ,`BuilderName` = 'Brookfield' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 235 BLK 22 SPRING BRANCH OAKS SEC 4' ,`LotDesciption` = 'Cleared,Subdivision Lot,Wooded' ,`LotSize` = '15672' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '20' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SPRING BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Branch Oaks Sec 04' ,`TaxAmount` = '12940' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132326' WHERE `Matrix_Unique_ID` = '212460248' --> 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','212468662','1664132326','212468662','2022-09-25T08:51:35.450','3994613','Anita Cameron','EOC Realty Associates LLC','','','29.579124','-95.013959','32','77586','14','485000.00','Active','Plymouth Rock','1321','Lane','Seabrook','2','1','5','4097','Single-Family','Lowest price per sq foot in Mystic Village!!*Texas Size home in much desired Mystic Village*Over 4,000 sq ft*Low tax rate*Never flooded*Beautiful home with soaring 2 story ceilings in family room*Family room with fireplace*Open concept kitchen with island & breakfast bar & breakfast rm*Separate living/dining room*Game room 2nd floor*Home office/study 1st floor*Primary bedroom down with ensuite bathroom*Separate shower, soaking tub & double sinks*4 great sized bedrooms up (ck rm sizes)*Media room 2nd floor*Oversized 2 car garage*Workshop w/sink*Big yard w/fully fenced BY w/fence replaced in 2019*New roof 2018*Recently painted interior*Updated 2nd floor bathroom is gorgeous & was done this yr*All new light fixtures/ceiling fans & hardware on doors*New plumbing fixtures throughout*Half bath recently updated*Location is everything, this house is not exception, subdivision park on Lake Mija*Close to the Kemah Boardwalk*Desirable CCISD*Please call for your private viewing.','0.219','7','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Clear Lake Area','Central Gas','1','LT 20 BLK 7 MYSTIC VILLAGE AT LAKE MIJA','Subdivision Lot','9540','Appraisal District','','325','0','','2','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','9 - Clear Creek','BAY ELEMENTARY SCHOOL','CLEAR FALLS HIGH SCHOOL','SEABROOK INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Mystic Village At Lake Mija','8592','2.2905','Public Sewer,Public Water','2001','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:52:50.227' ,`MLSNumber` = '24499891' ,`ListAgentFullName` = 'Meriam Shaw' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.909136' ,`Longitude` = '-95.082271' ,`PhotoCount` = '10' ,`PostalCode` = '77532' ,`RoomCount` = '8' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Chamfer' ,`StreetNumber` = '907' ,`StreetSuffix` = 'Way' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this beautiful home with NO BACK NEIGHBOR! Enjoy the Covered back patio, 3 CAR GARAGE. This home also comes with generator!' ,`Acres` = '0.1635' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas,Other Heating' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 5 NEWPORT SEC 8 PAR R/P' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '7143' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport' ,`TaxAmount` = '6146' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132326' WHERE `Matrix_Unique_ID` = '212530572' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:07:25.700' ,`MLSNumber` = '63242165' ,`ListAgentFullName` = 'Fernanda Lampson' ,`ListOfficeName` = 'CB&A, Realtors-Katy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.469290' ,`Longitude` = '-95.027848' ,`PhotoCount` = '31' ,`PostalCode` = '77539' ,`RoomCount` = '5' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Thornwood' ,`StreetNumber` = '5403' ,`StreetSuffix` = 'Circle' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1571' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Dickinson Texas! *NEVER FLOODED* Come see this newly remodeled beautiful 3-bedroom, 2-bathroom home! Beautiful and spacious living space with high ceilings, great for entertaining! Great kitchen with spacious counter tops. Fully remodeled primary suite, stunning en-suite bathroom and large primary closet. Updated flooring throughout, updated light fixtures, fresh paint inside and new windows! Each bedroom has large closets. Enjoy a fully fenced backyard with beautiful green grass. This home has a life-time transferable foundation warranty. Ready to move in. Fantastic location with an easy commute to both Galveston and Houston. Don’t miss this opportunity!' ,`Acres` = '0.2124' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 60 E P EPPERSON SUR LOT 63 BRIAR GLEN SUB' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briar Glen' ,`TaxAmount` = '4559' ,`TaxRate` = '2.5214' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132326' WHERE `Matrix_Unique_ID` = '212557451' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:52:01.257' ,`MLSNumber` = '26132545' ,`ListAgentFullName` = 'Tiffani Reynolds' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.017560' ,`Longitude` = '-95.301660' ,`PhotoCount` = '28' ,`PostalCode` = '77338' ,`RoomCount` = '8' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Chancewood' ,`StreetNumber` = '8135' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1884' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your light and bright, move-in ready home with new and modern laminate flooring. This home features 3 bedrooms, 2 and a half bathrooms, and a large covered back patio. Meal prep with ease with the abundant kitchen counterspace, and enjoy the oversized walk-in pantry. Granite countertops are throughout the entire house. Enjoy your entertainment options with a large living room, and breakfast area that leads out into the extended covered outdoor space. Downstairs your guests have access to a half bathroom. This one is ready to be your next home or investment property. Schedule your showing today!' ,`Acres` = '0.0964' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 2 KENSWICK FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JONES ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kenswick Forest' ,`TaxAmount` = '4225' ,`TaxRate` = '2.7433' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132326' WHERE `Matrix_Unique_ID` = '212572007' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:50:05.990' ,`MLSNumber` = '87405644' ,`ListAgentFullName` = 'Rickey Chavez' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.996280' ,`Longitude` = '-95.608417' ,`PhotoCount` = '45' ,`PostalCode` = '77429' ,`RoomCount` = '11' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Meadow Drive' ,`StreetNumber` = '12903' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '5' ,`BedsTotal` = '4' ,`SqFtTotal` = '3117' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning home with so much potential surrounded by mature trees and oversized lot. A fixer upper. Needs work but good bones. This timeless home has some amazing upgrades with so much to offer a buyer that wants to put their personal touch and creativity into it. Upgrades include custom cabinets with porcelain floors and fresh paint throughout the entire home. Home features high ceiling and open concept and a stunning sunroom with floor to wall windows overlooking the oversized pool and hot tub. Make your appointment today.' ,`Acres` = '0.433' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 16 LAKEWOOD FOREST SEC 10' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '18850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '680' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Forest Sec 10' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132326' WHERE `Matrix_Unique_ID` = '212605004' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:37:00.707' ,`MLSNumber` = '75817326' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.636467' ,`Longitude` = '-95.721036' ,`PhotoCount` = '46' ,`PostalCode` = '77406' ,`RoomCount` = '15' ,`ListPrice` = '539999.00' ,`Status` = 'Active' ,`StreetName` = 'Warm Summer' ,`StreetNumber` = '906' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Energy Saving Home on Huge Private Cul De Sac Lot, 3 Car Garage, Upgraded Front Porch W/Stone Elevation! Grand Entry Boast 2 Story Dramatic Entry W/Two Story Sweeping Iron Stairway! Gorgeous Large Tile Floors throughout! The First Floor has amazing Tall Custom Doors! Study/Formal Dining! Amazing soaring Ceiling in the Huge Family Area W/Walls of Windows, Cast Stone Corner Fireplace, all open to the Gourmet Kitchen & Casual Dining! Gourmet Kitchen features Granite Counters, Large Eat In Island, Tall Custom Cabinets, Undermount Lighting, Subway Tile Backsplash, Stainless Steel Built In 5 Burner Range, Double Ovens, Pots & Pan Drawers & More! Huge Primary Suite W/High Coffered Ceilings, Luxurious Bathroom W/His & Her Private Sink Vanity W/Granite, Deep Soaker Tub, Huge Shower, Massive Walk In Closet! Upstairs Guest Suite, Huge Game Rm & 2 Guest Bedrooms & Double Sink Vanity Bathroom! Massive Backyard W/Covered Patio! No Flooding! Resort Pool, Splashpad, Fitness Center & More!' ,`Acres` = '0.3231' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'HARVEST GREEN SEC 22, BLOCK 1, LOT 64' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '14074' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'NEILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harvest Green' ,`TaxAmount` = '12200' ,`TaxRate` = '3.1129' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132327' WHERE `Matrix_Unique_ID` = '212605450' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:08:55.303' ,`MLSNumber` = '97864618' ,`ListAgentFullName` = 'Kathryn Jean' ,`ListOfficeName` = 'TexasLife Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.234120' ,`Longitude` = '-95.671621' ,`PhotoCount` = '47' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '579990.00' ,`Status` = 'Active' ,`StreetName` = 'Damuth' ,`StreetNumber` = '40656' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2717' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to 40656 Damuth Drive in Mostyn Manor Reserve. This one-story, 3 bedroom, 2-1/2 bath home has been meticulously maintained - it feels like a brand-new home. You are greeted with a grand front porch with lots of space for a seating area to having your morning coffee. The floor plan is amazing - large kitchen island opens to your living room and kitchen table area - both with beautiful ceiling beams. This home was built with a lengthy list of upgrades and top selections. This home has it all: original owners, plantation shutters, custom shades on the back windows, amazing rock fireplace, double oven, reverse osmosis, 3 car garage, lots of windows for great natural light, unbelievable primary bathroom and huge closet, beautiful design detail, etc., etc. Overlook the large backyard while on your covered patio that is pre-wired, gas stubbed for all of your entertaining needs - perfect backyard for a pool.' ,`Acres` = '0.4012' ,`Area` = '15' ,`BuilderName` = 'Dunn & Stone' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S730807 - MOSTYN MANOR 07, BLOCK 2, LOT 13' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '17477' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mostyn Manor 07' ,`TaxAmount` = '8275' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132327' WHERE `Matrix_Unique_ID` = '212626561' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:22:44.197' ,`MLSNumber` = '87912637' ,`ListAgentFullName` = 'Brandon Dunbar' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.887828' ,`Longitude` = '-95.606979' ,`PhotoCount` = '23' ,`PostalCode` = '77041' ,`RoomCount` = '8' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Fountaincrest' ,`StreetNumber` = '7510' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Open House Saturday 9/24 11-3 pm\r\nTHIS ONE-OF-A-KIND PATIO HOME IS A MUST-SEE!! This 2-3/2 home is nestled into the prestigious Chimney Hill subdivision. The home has high ceilings and a large living room area that you and your family could enjoy. The home has a unique upstairs bedroom/home office/game room adding more living space and possibilities! Super easy access to HWY 290. The furniture seen in the home is all negotiable with the sale of the home. Refrigerator/Washer/Dryer come with home!' ,`Acres` = '0.1188' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 2 CHIMNEY HILL SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '381' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAIRGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Mediterranean' ,`Subdivision` = 'Chimney Hill Sec 05' ,`TaxAmount` = '4174' ,`TaxRate` = '2.811' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132327' WHERE `Matrix_Unique_ID` = '212666702' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:47:57.303' ,`MLSNumber` = '44997857' ,`ListAgentFullName` = 'Rose Yannakis' ,`ListOfficeName` = 'Energy Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747991' ,`Longitude` = '-95.636976' ,`PhotoCount` = '41' ,`PostalCode` = '77077' ,`RoomCount` = '14' ,`ListPrice` = '1197000.00' ,`Status` = 'Active' ,`StreetName` = 'Teal Cove' ,`StreetNumber` = '14207' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4550' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Magnificent Mediterranean-style home in the exclusive Lakes of Parkway community of Energy Corridor. Built in 2012, this tiled-roof, 5-Bed, 5 Bath, 3-car garage property features open-concept living, tremendous natural light, gleaming luxurious porcelain tile, and a 2-story family room with sprawling views on the sparkling pool through the large covered patio. First floor includes; Formal Dining, Breakfast area, Study, Utility room, a secondary Bedroom with full Bath. The large Primary suite comes complete with extra spacious his-and-hers closets. The tastefully designed kitchen includes marble countertops and generously sized island. A spiral staircase leads you upstairs to a large Gameroom, which grants access to the outdoor balcony, overlooking the backyard. Also upstairs; 3 large bedrooms & 2 baths. Zoned to exemplary public schools, in close proximity to prestigious private schools and main roads, such as Hwy 6, Westpark tollway, I-10 and access to HOV. A must see!!' ,`Acres` = '0.2083' ,`Area` = '31' ,`BuilderName` = 'KICKERILLO' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 2 LAKES OF PARKWAY SEC 18 AMEND NO 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9075' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'LAKES OF PARKWAY' ,`TaxAmount` = '20621' ,`TaxRate` = '2.3907' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132327' WHERE `Matrix_Unique_ID` = '212679377' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:17:46.070' ,`MLSNumber` = '10865408' ,`ListAgentFullName` = 'Jamie Terry' ,`ListOfficeName` = 'Priority One Real Estate' ,`SellingAgentFullName` = 'Daniel Nalbandian' ,`SellingOfficeName` = 'Nextgen Real Estate Properties' ,`Latitude` = '29.772871' ,`Longitude` = '-95.373896' ,`PhotoCount` = '45' ,`PostalCode` = '77007' ,`RoomCount` = '9' ,`ListPrice` = '385000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Summer' ,`StreetNumber` = '1605' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1912' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning home centrally located features three bedrooms and three full bathrooms with a two-car garage. Located across the street from a park and walking distance to restaurants, bars, and shops. Enter to a gated private front yard. On the first floor you will find a bedroom, full bath, and entry to the garage. On the second floor you will find a spacious living room with beautiful wood flooring open to the kitchen and breakfast area. Chef\'s kitchen features a breakfast bar, granite countertops, stainless steel appliances, updated lighting and 42\" cabinets with crown molding. An abundance of windows illuminate the home with morning light. On the third floor you will find two additional bedrooms and two full baths. The primary bedroom boasts high ceilings and an en-suite bath with double sinks, granite countertops, walk-in shower, soaking tub, and walk-in closet. Fridge, washer and dryer stay with the home. Hurry and schedule your showing; you will fall in love!' ,`Acres` = '0.0341' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Washington East/Sabine' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 MERFISH COLORADO' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1484' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2155' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Merfish Colorado' ,`TaxAmount` = '7057' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132327' WHERE `Matrix_Unique_ID` = '212687503' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:54:33.543' ,`MLSNumber` = '17935028' ,`ListAgentFullName` = 'Cheri Melcher' ,`ListOfficeName` = 'RE/MAX ONE - Premier' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.912927' ,`Longitude` = '-95.091208' ,`PhotoCount` = '33' ,`PostalCode` = '77532' ,`RoomCount` = '4' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Audie Lee' ,`StreetNumber` = '16014' ,`StreetSuffix` = 'Court' ,`City` = 'Crosby' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2406' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This 4/3.5/2 2-story has a beautiful elevation with nice curb appeal and is move-in ready. The media/game room is upstairs with a half bath. This home boasts high ceilings, easy-care flooring and upgrades throughout. The open concept and covered patio make it ideal for entertaining. Private backyard is fully fenced with no back neighbors. Located on a cul-de-sac with minimal traffic. \r\nNewport is a vibrant, growing community located just 30 minutes from downtown. Neighborhood amenities include pool, walking trails, splash pad, parks, tennis courts, golf course, gym, boat access to Lake Houston, beach area on San Jacinto River, and RV & boat storage. Schedule your tour today!' ,`Acres` = '0.1392' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 62 BLK 1 SEVEN OAKS SOUTH PAR R/P' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '6063' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '55' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Seven Oaks South Pt Rep 1' ,`TaxAmount` = '6874' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132327' WHERE `Matrix_Unique_ID` = '212707372' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:45:30.607' ,`MLSNumber` = '35885965' ,`ListAgentFullName` = 'Eboni Taylor' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.970611' ,`Longitude` = '-95.223507' ,`PhotoCount` = '8' ,`PostalCode` = '77396' ,`RoomCount` = '8' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Hannah Oaks' ,`StreetNumber` = '17222' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2386' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 17222 Hannah Oaks. This home offers you the opportunity to own a great home at a great price. There is a spacious yard, island/bar open concept kitchen, dining area, nice sized game room and many more updates.' ,`Acres` = '0.1136' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 BLACKSTONE CREEK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIVER PINES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Blackstone Crk Sec 2' ,`TaxAmount` = '' ,`TaxRate` = '2.933' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132328' WHERE `Matrix_Unique_ID` = '212724622' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:20:23.430' ,`MLSNumber` = '69492864' ,`ListAgentFullName` = 'Mary Keller' ,`ListOfficeName` = 'Origen Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.826571' ,`Longitude` = '-94.816363' ,`PhotoCount` = '25' ,`PostalCode` = '77523' ,`RoomCount` = '1' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Danna' ,`StreetNumber` = '203' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2182' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Zoned in BHISD. Lovely 4 bedroom 2.5 bath home, has an upstairs game/family room with 3 upstairs bedrooms and 1 full bathroom. Primary bedroom and primary bathroom is located downstairs. Kitchen has beautiful granite counters, stainless appliances, ample storage and pantry. There is a bonus room currently being used as an office space. Laundry room recently renovated to add extra storage. Fresh paint throughout home! Don\'t miss the chance to call this house your home! Schedule your showing today.' ,`Acres` = '0.232' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 38 LANAI SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10106' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '211' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric 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,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lanai Sec 02' ,`TaxAmount` = '3850' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132328' WHERE `Matrix_Unique_ID` = '212729647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:33:21.410' ,`MLSNumber` = '21432581' ,`ListAgentFullName` = 'Tiffany Limbousis' ,`ListOfficeName` = 'Caryn Beard Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.562220' ,`Longitude` = '-95.671977' ,`PhotoCount` = '22' ,`PostalCode` = '77479' ,`RoomCount` = '10' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Verdant Valley' ,`StreetNumber` = '1914' ,`StreetSuffix` = '' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come take a look at this gem in the heart of Greatwood!!! Upgrades throughout: Dual hot water heaters installed 5 years ago, new fence on the right side of the home. There are two ac units, one is 5 years old and the other is 2 years old. Don\'t worry about losing electricity, because this home comes with a Generac!!! There are four bedrooms, and features two primary suites, one in the front of the home, and one in the back. Not to mention a flex room to do with what you desire! Call this home yours today!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREATWOOD ARBOR SEC 1, BLOCK 1, LOT 24' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '8688' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '885' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Greatwood Arbor Sec 1' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132328' WHERE `Matrix_Unique_ID` = '212742025' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:37:00.707' ,`MLSNumber` = '11227790' ,`ListAgentFullName` = 'Alexis Skeen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.216150' ,`Longitude` = '-95.597129' ,`PhotoCount` = '48' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '1200000.00' ,`Status` = 'Active' ,`StreetName` = 'Clubhouse' ,`StreetNumber` = '10603' ,`StreetSuffix` = 'Circle' ,`City` = 'Magnolia' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4913' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SPECTACULAR home on Lake Windcrest golf course!!\r\nThis home features luxurious interior finishes throughout. \r\nSpacious floor plan has both formals, wine grotto, four bedrooms down (includes primary), large laundry with outdoor access & a game-room upstairs. \r\nPrimary Bathroom has been redesigned with double vanities coupled with double closets, spacious walk in shower, and a deep soaking tub.\r\nThe kitchen comes complete with new appliances, quartz countertops, and Large island with lots of cabinetry.\r\nLooking out the back windows you will see a beautiful Manicured backyard that accompanies a pool & spa, HUGE covered patio that features outdoor fireplace & full kitchen. \r\nComplete with a one bedroom guest house with private bath.\r\nPerfect for entertaining!! \r\nTHIS IS A MUST SEE!! Schedule your appointment today ;)' ,`Acres` = '1.048' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LAKE WINDCREST 05, BLOCK 1, LOT 20' ,`LotDesciption` = 'In Golf Course Community,On Golf Course' ,`LotSize` = '45651' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Windcrest Sec 5' ,`TaxAmount` = '12377' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132328' WHERE `Matrix_Unique_ID` = '212749957' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:47:43.377' ,`MLSNumber` = '92661457' ,`ListAgentFullName` = 'Ryan Birdsong' ,`ListOfficeName` = 'Birdsong Real Estate' ,`SellingAgentFullName` = 'Yumiko Morales' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.055802' ,`Longitude` = '-95.419053' ,`PhotoCount` = '24' ,`PostalCode` = '77566' ,`RoomCount` = '5' ,`ListPrice` = '314900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Rockrose' ,`StreetNumber` = '104' ,`StreetSuffix` = 'Lane' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1672' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home located in the Creekside Subdivision is just waiting for you! It offers a great open floor plan with high ceilings throughout along with 3 bedrooms, 2 baths and 2 car attached garage. The kitchen has stainless steel appliances, granite counter tops, breakfast bar, lots of storage and walk in pantry. The large indoor utility room has lots of additional storage and counter space. The primary en-suite bath has double sinks with vanity space, shower and large walk in closet. You will enjoy having the covered/ screened in patio! This one won\'t last long! Don\'t miss the chance to make it yours, call us to see today!' ,`Acres` = '0.1801' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CREEKSIDE SD SEC 1 (A0066 JE GROCE) (LAKE JACKSON) BLK 5 LOT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7845' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BRANNEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekside SD Sec 1' ,`TaxAmount` = '6263' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132328' WHERE `Matrix_Unique_ID` = '212764020' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:04:38.267' ,`MLSNumber` = '35654600' ,`ListAgentFullName` = 'Luz Hall' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.938893' ,`Longitude` = '-95.710287' ,`PhotoCount` = '25' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '449999.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeridge Park' ,`StreetNumber` = '26815' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2287' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous home tastefully UPDATED with excellent finishes and enhanced by neutral paint color inside and out. This residence welcomes you with an open concept floor plan, spacious foyer, formal dining room, and wall of windows throughout with panoramic views of the backyard. Feels like a new construction with new luxury flooring throughout, light fixtures replaced, modern countertops, and updated bathrooms featuring floor to ceiling tile, frameless separate shower with garden tub. Several new doors have been replaced including both garage doors. The kitchen opens to the family room and breakfast, features new SS appliances, decorative backsplash, and oversized island. Custom blinds to be installed upon arrival. This is a must to see! \r\nOpen House Sunday 1-3 pm' ,`Acres` = '0.1696' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Stove' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 3 CYPRESS CREEK LAKES SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7388' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WARNER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Creek Lakes' ,`TaxAmount` = '7703' ,`TaxRate` = '2.801' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132329' WHERE `Matrix_Unique_ID` = '212787153' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:07:21.597' ,`MLSNumber` = '91653905' ,`ListAgentFullName` = 'Zachary Khushf' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.777052' ,`Longitude` = '-95.612609' ,`PhotoCount` = '45' ,`PostalCode` = '77079' ,`RoomCount` = '9' ,`ListPrice` = '640000.00' ,`Status` = 'Active' ,`StreetName` = 'Greenpark' ,`StreetNumber` = '823' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2826' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully remodeled home located in desirable Thornwood neighborhood in the Energy corridor. Easy commutes to Galleria and Memorial City. The home been repiped with new PEX piping. There are granite countertops in the kitchen and all bathrooms, new paint on all interior and exterior surfaces, brand new durable vinyl floors on first floor and new carpet upstairs. Home features plenty of natural lighting through all new energy efficient double pane vinyl windows. There are new cabinet doors with soft close hinges in the kitchen, living room and all bathrooms, recessed lighting with dimmable switches throughout the first floor and new ceiling fans throughout the home. Never flooded. You won\'t want to miss out on this one!' ,`Acres` = '0.2032' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 3 THORNWOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'NOTTINGHAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Thornwood' ,`TaxAmount` = '9071' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132329' WHERE `Matrix_Unique_ID` = '212799305' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:31:41.317' ,`MLSNumber` = '87413658' ,`ListAgentFullName` = 'Shoujian Huang' ,`ListOfficeName` = 'Forever Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.699326' ,`Longitude` = '-95.496128' ,`PhotoCount` = '24' ,`PostalCode` = '77074' ,`RoomCount` = '6' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Rowan' ,`StreetNumber` = '6417' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1226' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely remodeled beautiful one story brick home, 3 BR, 2 bath, and 1 car garage and 1 covered porch/car port. High quality waterproof SPC wood like flooring throughout the whole house, walls, ceiling and trim have been freshly painted, new lighting, new blinds. Brand new kitchen features open concept design, kitchen has granite countertops and custom white cabinets, stainless stove/oven, dishwasher etc. The primary bedroom offers en suite bathroom with new vanity and shower. Spacious secondary bedrooms & large second bath with high end design of custom cabinetry, frameless glass walk-in shower. Lots of natural light for the whole house. New A/C system, brand new plumbing. New garage floor, new walls and garage door. New concrete drive way led to covered porch/car port. NEVER FLOODED! Not even in the 500-Year Floodplains.' ,`Acres` = '0.1639' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 8 SHARPSTOWN SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SUTTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'LONG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Lockbox Right Side,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sharpstown Sec 01' ,`TaxAmount` = '3610' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132329' WHERE `Matrix_Unique_ID` = '212801578' --> 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','212816595','1664132329','212816595','2022-09-25T09:36:58.107','53745935','Bonnie Schinnerer','eXp Realty, LLC','','','29.846580','-94.847636','37','77523','9','469900.00','Active','Broadmoor','4010','Drive','Mont Belvieu','3','1','4','3070','Single-Family','Welcome Home to Wilburn Ranch Subdivision. One of the most sought out subdivisions in Mont Belvieu, TX. Over 3000 sq ft 1 story beautiful home has 4 large bedrooms, 3 1/2 bathrooms, dining room, office/study and sits on a little over 1/4-acre lot, large enough for a swimming pool. As you walk through the front door you will notice the 12ft ceilings, hard wood floors and crown molding throughout the home. Open concept gourmet kitchen extends into the living room perfect for entertaining family and friends. Kitchen features dark expresso cabinets, granite counter tops, breakfast nook and a white stone wrap around island with granite countertop. The master bedroom has a huge master bath with a jetted jacuzzi tub and an oversized master closet. One of the bedrooms includes an ensuite bathroom. Large backyard patio and a 10x20 shed. Enjoy morning or nightly walks on the walking trail. Prime location for dining, shopping and only 30 minutes to Houston. Low Taxes, A+ Rating BHISD','0.378','53','','','','','Sellers Disclosure','1','','1','Chambers County West','Central Gas','1','BK 5 LT 35 WILBURN RANCH S/D','Subdivision Lot','16466','Appraisal District','','','0','','3','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','6 - Barbers Hill','BARBERS HILL NORTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL NORTH MIDDLE SCHOOL','Appointment Required,Lockbox Front','Builder','1','Traditional','Wilburn Ranch Sub','8304','2.1606','Public Sewer,Public Water','2015','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:15:19.950' ,`MLSNumber` = '28660488' ,`ListAgentFullName` = 'Adel Hazim' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.602390' ,`Longitude` = '-95.609313' ,`PhotoCount` = '32' ,`PostalCode` = '77478' ,`RoomCount` = '8' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Amesbury' ,`StreetNumber` = '15310' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2023' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely one story 4 bedrooms house, rare find, tucked in a cul-de-sac with mature oak trees, fresh good in style paint, laminate and tiles throughout the house, as you enter to your left good size formal dining with an access to a beautiful bright kitchen remodeled with granite counters, brand-new appliances sink and faucet, kitchen open to a huge family room with wood inspired tile, many windows to the backyard provide flood of natural light, large primary bedroom with large walk-in closet and remodeled primary bath with granite counters, sinks, faucets, mirrors and light fixtures, frameless beautiful shower, good size secondary bedroom, one of which is a good option for study with French door. Large and lovely back yard big enough for a good size pool, wooden deck. Roof about 7 years old, AC about 5 years. Three minutes from 69, and 7 minutes away from Beltway 8 and Grand Pkwy, zoned to a great schools.' ,`Acres` = '0.1743' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ENGLEWOOD PLACE ESTATES SEC 2, BLOCK 1, LOT 14' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7593' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Englewood Place Estates Sec 2' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132329' WHERE `Matrix_Unique_ID` = '212819014' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:01:42.440' ,`MLSNumber` = '41731121' ,`ListAgentFullName` = 'Firely Vincent' ,`ListOfficeName` = '1st Class RE Luxury Living,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.843109' ,`Longitude` = '-95.723939' ,`PhotoCount` = '48' ,`PostalCode` = '77449' ,`RoomCount` = '11' ,`ListPrice` = '349990.00' ,`Status` = 'Active' ,`StreetName` = 'Lamppost Hill' ,`StreetNumber` = '5030' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3220' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 5030 Lamppost Hill Ct! This stunning 3,220 sq ft 2-story home boasts with 4 bedrooms, 2 1/2 bathrooms, and features a ton of beautiful upgrades, not to mention the HUGE upstairs GAMEROOM, an incredible MEDIA ROOM, and an amazing BONUS ROOM that would be perfect for a study! Featuring beautiful stainless steel appliances, wine cooler fridge under countertop, modern fixtures, a spacious covered back patio, above ground pool and so much more. New roof & heater both installed less then a year ago! With an amazing location featuring easy access to 99 and I-10, this stunning home has everything you could ever want or need! This gorgeous home won\'t last long, schedule your private showing today!' ,`Acres` = '0.1102' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 RICEWOOD VILLAGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '430' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ricewood Village Sec 2' ,`TaxAmount` = '7481' ,`TaxRate` = '3.011' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664132329' WHERE `Matrix_Unique_ID` = '212826798' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:05:49.993' ,`MLSNumber` = '45347568' ,`ListAgentFullName` = 'Betty Baker Burns' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.751448' ,`Longitude` = '-95.490349' ,`PhotoCount` = '34' ,`PostalCode` = '77057' ,`RoomCount` = '24' ,`ListPrice` = '2695000.00' ,`Status` = 'Active' ,`StreetName` = 'Doliver' ,`StreetNumber` = '6127' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5824' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exceptional interior finishes & architectural accents in this beautiful home located on the North side of Briargrove. Unique wood floors are wide plank French oak. Entry foyer designed chevron pattern. Formal living & dining rooms with plaster walls, ceilings&living has custom hand painted strie walls. Bar area has custom reclaimed panel doors for silver storage. Custom limestone fireplaces in the living & family rooms. 2-Powder rooms dwn,1 formal w/ PhilipJeffries wallpaper, also used in her office.Gourmet kitchen, soapstone counters & storage doors for appliances. Mudroom w/kids lockers, dog kennel. Custom wool runners on both stairs& upstairs hallway.All bedrooms ensuite baths, gamerm w/ full bath. Primary bedroom w/foyer entry,& his office, & bedroom w/custom painted wood ceiling, reclaimed wood panel door to media Spa like primary bath w/marble counters,honed marble floors. Lg outdoor patio w/fireplace,tv, s.s.grill. L.Scape lighting, putting green, security cam..Epoxy flr garage' ,`Acres` = '0.2158' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Briargrove' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 599 BLK 29 BRIARGROVE SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9401' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1210' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briargrove Sec 08' ,`TaxAmount` = '52223' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132329' WHERE `Matrix_Unique_ID` = '212830322' --> 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','212852372','1664132330','212852372','2022-09-25T08:22:13.903','45458765','Lang Bui','VTEX Realty ','','','29.662233','-95.540260','19','77031','9','305000.00','Active','BANKSIDE','9234','Drive','Houston','2','0','3','1752','Single-Family','THIS BEAUTIFUL PROPERTY IS LOCATED IN BRAEBURN SUDIVISION, AND IS JUST MINUTES AWAY FROM BELTWAY 8 AND HWY 59, PROVIDING SHORT AND CONVIENIENT TRAVELS TO AND FROM HOME.\r\n\r\nTHIS PROPERTY WAS RECENTLY RENOVATED WITH A FULL KITCHEN UPGRADE INCLUDING GRANITE KITCHEN COUNTER TOPS AND CUSTOM CABINENTS, FRESH PAINT ALL AROUND, AND BRAND NEW BEDROOM WOOD FLOORS. THIS PROPERTY IS PERFECT FOR FAMILY HOME BUYERS LOOKING FOR A TURNKEY HOME THAT IS REQUIRES LITTLE TO NO WORK.','0.1641','20','','','Electric Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','Wood Burning Fireplace','1','Brays Oaks','Central Electric','1','LT 18 BLK 33 BRAEBURN VALLEY WEST SEC 2','Subdivision Lot','7150','Appraisal District','','381','0','','2','Electric Oven','0','','','Electric Cooktop,Electric Range','','Composition','27 - Houston','VALLEY WEST ELEMENTARY SCHOOL','SHARPSTOWN HIGH SCHOOL','WELCH MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Braeburn Valley West Sec 02','3861','2.3307','Public Sewer,Public Water','1972','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:40:41.227' ,`MLSNumber` = '78818715' ,`ListAgentFullName` = 'Dean Melton' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.253306' ,`Longitude` = '-95.519842' ,`PhotoCount` = '47' ,`PostalCode` = '77384' ,`RoomCount` = '9' ,`ListPrice` = '499990.00' ,`Status` = 'Active' ,`StreetName` = 'Routt Forest' ,`StreetNumber` = '14027' ,`StreetSuffix` = 'Trail' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2829' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Delightful home with relaxing backyard oasis, sparkling gunite pool/spa, large end lot in the peaceful community of Fosters Ridge. Home has 4 bedrooms, 3 full baths, open floorplan with 3 bedrooms down, including primary suite. The 4th bdrm, 3rd bath & spacious gameroom are upstairs. Beautiful island kitchen, granite countertops, stainless steel appliances, butlers pantry, & walk-in pantry. The open kitchen, family room, breakfast area & patio overlook the pool. Great flow for entertaining. Home boasts tons of windows providing natural light. Custom chandelier & designer pressed tin ceiling in the formal dining room, custom valances in family & breakfast, electric FP, walk-in closets in most rooms, plenty of storage, easily accessible floored attic, 8\'x8\' storage shed on concrete pad & professional landscape lighting in backyard. Beautifully designed gunite pool has 3 waterfalls, raised hot tub, LED lights, removable table top, & tanning deck. Walking distance to park and rec center.' ,`Acres` = '0.2115' ,`Area` = '15' ,`BuilderName` = 'D R Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S516400 - FOSTERS RIDGE 01, BLOCK 2, LOT 17' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9212' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Fosters Ridge' ,`TaxAmount` = '9074' ,`TaxRate` = '3.1488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132330' WHERE `Matrix_Unique_ID` = '212854255' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:46:57.950' ,`MLSNumber` = '56396015' ,`ListAgentFullName` = 'Christina Brewster' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.717486' ,`Longitude` = '-95.032124' ,`PhotoCount` = '50' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Mossy' ,`StreetNumber` = '208' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Three story, three bd, two bath home on 2 acres surrounded by mature trees that provide privacy to the property. Just minutes from the lake! Access to a private pavilion/boat ramp 2.4 miles from Lake Livingston & 1.3 miles to Tigerville Public Park & boat ramp. No mobile homes allowed in this section. Buyer\'s agent to verify dimensions & schools. Window sticker for the private (gated) pavilion/boat ramp is currently $25.00 annually. Schedule your tour today!' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = '97 THR 108,110,112,113' ,`LotDesciption` = 'Corner' ,`LotSize` = '91911' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '230' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lakeland Hideaway' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132330' WHERE `Matrix_Unique_ID` = '212867334' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:52:31.780' ,`MLSNumber` = '17223679' ,`ListAgentFullName` = 'Tri Tran' ,`ListOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014377' ,`Longitude` = '-95.420631' ,`PhotoCount` = '47' ,`PostalCode` = '77073' ,`RoomCount` = '7' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Mission Ridge' ,`StreetNumber` = '16943' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3592' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the gorgeous 5 bed & 3 bath home, Tile & Laminate are in the living area, spacious kitchen has tones of cabinet space, granite countertops. Large master bedroom suite, with 2 walk-in closets, separate shower, double sinks and whirlpool tub, plus with 3 additional bedrooms upstairs & a game room make the home being exclusive when having 2 living spaces, one for adults and one for kids. 5th bedroom could turn into the study/office- working from home would be a great idea.' ,`Acres` = '0.132' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 9 IMPERIAL RIDGE SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CAROLEE BOOKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Ridge Sec 01' ,`TaxAmount` = '6496' ,`TaxRate` = '2.7292' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132330' WHERE `Matrix_Unique_ID` = '212872516' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:37:00.660' ,`MLSNumber` = '81440122' ,`ListAgentFullName` = 'Oscar Jalifi' ,`ListOfficeName` = 'The Local Agents Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.946622' ,`Longitude` = '-95.293937' ,`PhotoCount` = '32' ,`PostalCode` = '77541' ,`RoomCount` = '3' ,`ListPrice` = '354500.00' ,`Status` = 'Active' ,`StreetName` = 'Crab' ,`StreetNumber` = '427' ,`StreetSuffix` = 'Street' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1152' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This bright and light happy home is the perfect getaway destination. It has everything you need for your stay at the beach even if you decide to make it your permanent resident. Ah, enjoy music outdoors with the wired speakers and watch the pelicans fly over heard. You don\'t have to worry about the dogs because the yard is fenced already. The home has 3 bedrooms and 2 full baths which will make it a great rental property if you are an investor. It has been so well cared for and has so many upgrades that you may want to settle in as a beach local forever. Come down and see if this is the one you have been waiting to find. It just may be the ONE!' ,`Acres` = '0.1791' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GULF RIDGE BLK 2 LOT 15 SURFSIDE' ,`LotDesciption` = 'Water View' ,`LotSize` = '7802' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Gulf Ridge' ,`TaxAmount` = '7730' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132330' WHERE `Matrix_Unique_ID` = '212874116' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:50:21.683' ,`MLSNumber` = '82218612' ,`ListAgentFullName` = 'Vivian Jones' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.884644' ,`Longitude` = '-95.447788' ,`PhotoCount` = '20' ,`PostalCode` = '77088' ,`RoomCount` = '4' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Hampton' ,`StreetNumber` = '2412' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Please come out and see this beautifully renovated home the sellers have taken the extra mile to bring the electrical and the plumbing up to code. This home is an open floor plan that is very functional and great for entertaining. This kitchen has gorgeous granite tops that follows to the bathrooms. The bathroom has a great walk-in shower, and the tile work is amazing. This home is centrally located and driving distance from the Medical Center, Downtown Houston, and any of the stadiums in about 20 minutes or less. You don\'t want to take a chance on missing out of this home make your appointment to come out to see it before it\'s gone. \r\nAppliances will be added once offer is accepted' ,`Acres` = '0.1708' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 8 HIGHLAND GARDENS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Gardens Sec 02' ,`TaxAmount` = '2174' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132330' WHERE `Matrix_Unique_ID` = '212888105' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:56:17.870' ,`MLSNumber` = '65361195' ,`ListAgentFullName` = 'Kay Simpson' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.562864' ,`Longitude` = '-95.234136' ,`PhotoCount` = '23' ,`PostalCode` = '77581' ,`RoomCount` = '8' ,`ListPrice` = '407000.00' ,`Status` = 'Active' ,`StreetName` = 'Venice' ,`StreetNumber` = '2407' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2529' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BellaVita | The Good Life | Gated Community - 55+ Active Adult Community - Easy Access to I-45 and Hwy 518. NO FLOODING FROM Harvey. NEW ROOF. Desirable 2529 sf. with 3 Bedrooms 2 Bathrooms & Separate Dining Room. Study with Front view. 3rd bedroom could be a craft room, master bath has double sinks, separate walk-in shower with spacious closet. Front Door, Fireplace. Corner Lot. Tile and Carpet. Corian countertops. Fairly new Stainless-Steel dishwasher and microwave and oven and hot water heater. Back patio faces north. Wide Foyer Front Door Crown Molding. Every 9 years the HOA paints the exterior of the house and every 2 years the front door will get stained. Security system and Basic Comcast cable with Highspeed internet is included in HOA plus front yard and sprinklers maintained by HOA. You can have your backyard maintained (mowed, weed eat and blown) for $50 a month The Clubhouse has Pool/Spa, Fitness Center, Ballroom. 11-acre lake, 1 mile walking trails and Nature Reserve.' ,`Acres` = '0.1761' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 3 BELLAVITA AT GREEN TEE 2 AMEND' ,`LotDesciption` = 'Corner' ,`LotSize` = '7669' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '262' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'WEBER ELEMENTARY' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'WESTBROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bellavita At Green Tee 02 Amd' ,`TaxAmount` = '9009' ,`TaxRate` = '2.8854' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132331' WHERE `Matrix_Unique_ID` = '212889560' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:44:57.187' ,`MLSNumber` = '97840344' ,`ListAgentFullName` = 'Nicole Handy' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.714640' ,`Longitude` = '-95.428055' ,`PhotoCount` = '39' ,`PostalCode` = '77005' ,`RoomCount` = '13' ,`ListPrice` = '3700000.00' ,`Status` = 'Active' ,`StreetName` = 'University' ,`StreetNumber` = '3201' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '7040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Seize the opportunity to own the most iconic home in Houston, nestled behind breathtaking majestic oak trees on a primer 18K sqft corner lot in the heart of the prestigious West University. Internationally renowned, with over 7K sqft of spacious living, this unique design features 2 grand floating staircases with towering floor-to-ceiling windows lining the entire rear of the home. The backyard oasis is seen from every room in the home. Significant upgrades and features include a state-of-the-art lighting system, 3 new AC units, new water heater, 2 new ice makers, new dishwasher, new oven, 72\' sub zero fridge, wet bar, stunning wine room, a home study with a 360 view of the 1st floor, 4 car show garage, & security camera system. Delight on the 2nd story balcony that overlooks the brand new pool & spa. This home was built to entertain. Located minutes from the world-renowned Texas Medical Center, Rice University, Rice U Elementary, & Rice Village premier shopping and dining.' ,`Acres` = '0.4132' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 6A 7 & 8B BLK 21 WEST UNIVERSITY PLACE SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '18000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'West University Place Sec 01' ,`TaxAmount` = '66863' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132331' WHERE `Matrix_Unique_ID` = '212917104' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:16:08.950' ,`MLSNumber` = '79286269' ,`ListAgentFullName` = 'Alicia Grazer' ,`ListOfficeName` = 'Ausmus Premier Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.375094' ,`Longitude` = '-95.616950' ,`PhotoCount` = '16' ,`PostalCode` = '77356' ,`RoomCount` = '3' ,`ListPrice` = '399500.00' ,`Status` = 'Active' ,`StreetName` = 'Capetown' ,`StreetNumber` = '280' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2114' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.0584' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'APRIL SOUND 07, BLOCK 64, LOT 4' ,`LotDesciption` = 'Other' ,`LotSize` = '2544' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '234' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'April Sound 07' ,`TaxAmount` = '4523' ,`TaxRate` = '2.2625' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132331' WHERE `Matrix_Unique_ID` = '212918772' --> 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','212923041','1664132331','212923041','2022-09-25T08:54:41.137','8062762','Berj Kupelian','Realty Associates','','','30.110355','-95.382794','25','77386','9','324900.00','Active','Lockeridge Springs','28538','Drive','Spring','2','0','3','2066','Single-Family','Beautiful home in Lockeridge Farms subdivision in Spring. Family friendly neighborhood, highly rated schools, community playground and pool. home has spacious open concept. Kitchen has granite countertops, tall cabinets and tile backsplash and island that opens to breakfast area and living room.\r\nCovered patio and a back yard with no neighbors\r\nFresh paint inside and outside and a new roof for years of worry free living.','0.1343','40','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Spring Northeast','Central Gas','1','S692400 - LOCKERIDGE FARMS 01, BLOCK 8, LOT 16','Subdivision Lot','5850','Appraisal District','','550','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','ANN K. SNYDER ELEMENTARY SCHOOL','GRAND OAKS HIGH SCHOOL','YORK JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,No Supra Keybox','Appraisal District','1','Traditional','Lockeridge Farms 01','6448','2.8187','Water District','2012','Appraisal District'); --> New record created successfully
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','212924511','1664132331','212924511','2022-09-25T09:57:11.303','5549928','Remo Castillo','Realty Associates','','','29.802769','-95.177989','28','77015','6','269900.00','Active','Evanston','171','Street','Houston','2','0','3','1746','Single-Family','Renovated property with new roof replaced May 2021. Remodeling includes new flooring and paint throughout, new light feature including LED recessed highlight, new kitchen appliance, new A/C condenser and pluming re-pipe as new water heating. Immaculate bathrooms, detached garage with storage and work area with adjacent converted carport. Home has a beautiful POOL in back yard. Do not miss it. Go and see it today.','0.147','2','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','North Channel','Central Gas','1','LT 13 BLK 77 WOODFOREST SEC 22','Corner,Subdivision Lot','6405','Appraisal District','','350','0','','2','Single Oven','1','In Ground','','Gas Cooktop','','Composition','21 - Galena Park','HAVARD ELEMENTARY SCHOOL','NORTH SHORE SENIOR HIGH SCHOOL','NORTH SHORE MIDDLE SCHOOL','Appointment Required,Lockbox Back','Appraisal District','1','Traditional','Woodforest','4513','2.5294','Public Sewer,Public Water','1978','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T09:07:38.990' ,`MLSNumber` = '33179615' ,`ListAgentFullName` = 'Andrew Ward' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.629498' ,`Longitude` = '-95.334264' ,`PhotoCount` = '28' ,`PostalCode` = '77048' ,`RoomCount` = '8' ,`ListPrice` = '259000.00' ,`Status` = 'Active' ,`StreetName` = 'Park Village' ,`StreetNumber` = '5623' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come take a look at this Gorgeous home with a open floorplan concept. The kitchen boasts a large center island, granite counter tops and large cabinets. Hard surface flooring throughout the entire home (no carpet). Great size backyard that is suited well for animals. Conveniently located minutes from Pearland, Downtown, Medical Center, NRG Stadium, Museum District and Beltway.' ,`Acres` = '0.1263' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 36 BLK 3 KINGDOM COME PLACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingdom Come Place' ,`TaxAmount` = '4107' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132331' WHERE `Matrix_Unique_ID` = '212928469' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-25T08:56:10.383' ,`MLSNumber` = '32539381' ,`ListAgentFullName` = 'Kevin King' ,`ListOfficeName` = 'RE/MAX ONE - Premier' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819356' ,`Longitude` = '-95.071064' ,`PhotoCount` = '34' ,`PostalCode` = '77562' ,`RoomCount` = '9' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Hampton' ,`StreetNumber` = '307' ,`StreetSuffix` = 'Court' ,`City` = 'Highlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2147' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a move-in ready 4 bedroom in an established neighborhood? Look no further because this is the home for you.' ,`Acres` = '0.1584' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 4 HIGHLAND WOODS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '212' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Woods Sec 02' ,`TaxAmount` = '4995' ,`TaxRate` = '2.575' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664132331' WHERE `Matrix_Unique_ID` = '212937920' --> 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','212947126','1664132331','212947126','2022-09-25T09:07:50.097','42936599','Joe Reyes','Nextgen Real Estate Properties','','','29.651914','-95.236451','28','77034','3','239900.00','Active','Marleen','927','Street','Houston','2','0','3','1564','Single-Family','Here it’s is the beautifully completely renovated home you’ve been so patiently looking for! This home consists of 3 bedrooms and 2 bathrooms! New pex plumbing, new HVAC, new roof, new windows, new siding, new flooring, remodeled kitchen with newly installed cabinets, remodeled bathrooms and so much more this home has been completely transformed inside out! The backyard has plenty of green space, covered patio and not one but 2 beautifully built sheds you can say a his and hers shed! Schedule an appointment today to see this lovely home and all it has to offer!','0.1419','6','','','','','Sellers Disclosure','','','','Hobby Area','Central Gas','0','LT 4 BLK 24 FREEWAY MANOR SEC 3','Subdivision Lot','6180','Appraisal District','','','0','','0','','0','','','','','Composition','41 - Pasadena','FREEMAN ELEMENTARY SCHOOL (PASADENA)','SOUTH HOUSTON HIGH SCHOOL','SOUTHHOUSTON INTERMEDIATE SCHOOL','Supra Keybox','Seller','1','Traditional','Freeway Manor Sec 03','3385','2.6863','Public Sewer,Public Water','1951','Appraisal'); --> New record created successfully