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-10-15T23:12:32.750' ,`MLSNumber` = '82137613' ,`ListAgentFullName` = 'Martha Schauer' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.153491' ,`Longitude` = '-95.676901' ,`PhotoCount` = '31' ,`PostalCode` = '77362' ,`RoomCount` = '12' ,`ListPrice` = '719000.00' ,`Status` = 'Active' ,`StreetName` = 'Spicewood Ridge' ,`StreetNumber` = '34118' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Spicewood Ridge! This home has one of the finest floorplans a builder could design! The high ceilings and massive entry add to the WOW factor of this home. As you pass the study and formal dining room, you are led into the open concept family room and kitchen. The dining room also connects to the kitchen area through the butlers pantry, which host it\'s own beverage refrigerator. The flow of the home is great for family functions and entertaining. The BEST part of the home? TWO BEDROOMS DOWN! A private guest suite/nursery with private bath and a utility that connects to the primary suite. Three additional bedrooms are upstairs with a connecting bath and a guest bath. The upstairs media room sits off of the game room. The wood flooring gives options of use for a play room, work out room or for home schooling. For those with a hobby or who like to \'tinker\" the oversized three car garage has a work station with upper cabinets. This home meets all the needs and wants of any buyer' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S959490 - WOODTRACE 05-B, BLOCK 4, LOT 12' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10861' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodtrace 05-B' ,`TaxAmount` = '16921' ,`TaxRate` = '3.3178' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928784' WHERE `Matrix_Unique_ID` = '204062818' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T23:03:03.400' ,`MLSNumber` = '22402645' ,`ListAgentFullName` = 'Kay Watson' ,`ListOfficeName` = 'eXp Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.855634' ,`Longitude` = '-98.419579' ,`PhotoCount` = '49' ,`PostalCode` = '78070' ,`RoomCount` = '6' ,`ListPrice` = '949000.00' ,`Status` = 'Active' ,`StreetName` = 'Fawn' ,`StreetNumber` = '211' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring Branch' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '5238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated on almost 4 acres in the hill country, walking distance to the Guadalupe River, minutes from downtown San Antonio, Boerne, Canyon Lake and 1 hour from Fredericksburg, The primary home is 4102 S.F. and the fully equipped casita is 1136 S.F. and has its own private patio. Live in the casita while you update the main home, then upgrade the casita while enjoying your dream home modernized to your exact specifications. Priced with these needed upgrades in mind. The main house has 2 large master suites with patio access from each room. Visualize yourself entertaining beneath the soaring ceilings in the spacious kitchen and patio that runs along the entire back side of the home. Underneath the loft area there is a flex room, the home has huge closets and lots of storage. The casita is perfect for a mother-in-law suite, college student or extra income. This home was featured in the NY times and HGTV when it was built. Quiet convenient neighborhood with river access. Welcome home!' ,`Acres` = '3.689' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'GUADALUPE RIVER ESTATES, LOT 132, UNDIVIDED INTEREST 40.0000' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '160693' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '141 - Comal' ,`SchoolElementary` = 'ARLON SEAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SMITHSON VALLEY HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (COMAL)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Guadalupe River Estates' ,`TaxAmount` = '4610' ,`TaxRate` = '1.786' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928784' WHERE `Matrix_Unique_ID` = '208532976' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:09:47.230' ,`MLSNumber` = '75496010' ,`ListAgentFullName` = 'Glendi Ramos' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.772905' ,`Longitude` = '-95.162370' ,`PhotoCount` = '41' ,`PostalCode` = '77015' ,`RoomCount` = '7' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Muscatine' ,`StreetNumber` = '14625' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2240' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2018 constructed masterpiece ready for you to call home! 5 Bedrooms 3 bathrooms \r\nbrand new HVAC System , \r\nConveniently located close to I-10 with amazing conveniences within the area. Lots of potential to customize to your liking and make it your own!\r\nPer seller this home did NOT FLOOD, Measurements are approximate, buyer to verify the information.\r\nschedule your appointment today !' ,`Acres` = '0.1263' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 1 HOUSTON MANOR' ,`LotDesciption` = 'Other' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'SAM HOUSTON ELEMENTARY SCHOOL (GALENA PARK)' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'North Chanel' ,`TaxAmount` = '3658' ,`TaxRate` = '2.5853' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928784' WHERE `Matrix_Unique_ID` = '208999458' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T23:17:46.803' ,`MLSNumber` = '9738653' ,`ListAgentFullName` = 'Therese Landa' ,`ListOfficeName` = 'Houstonian Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.913733' ,`Longitude` = '-95.653175' ,`PhotoCount` = '46' ,`PostalCode` = '77095' ,`RoomCount` = '7' ,`ListPrice` = '284400.00' ,`Status` = 'Active' ,`StreetName` = 'Aber Trail' ,`StreetNumber` = '8926' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1716' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Good quality products stand the test of time! This is certainly the case for this charming (1) story, single family, brick and stone ranch home, featuring 3 bedrooms and 2 full baths. The best news is that it’s MOVE IN READY. High ceilings, wide-floor-to-ceiling windows, so many kitchen surfaces and abundant storage; with large front rooms for formal dining and home office space, all seamlessly come together in a generous open floor plan. Two bedrooms occupy one side of the home, while the luxurious primary ensuite bed/bath are on the other side. Beautiful exterior landscaping, front and back; with a huge covered patio and green backyard, the entire yard has a sprinkler system.' ,`Acres` = '0.152' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 2 ABERDEEN GREEN SEC 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6621' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '665' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BIRKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aberdeen Green Sec 03' ,`TaxAmount` = '5533' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928784' WHERE `Matrix_Unique_ID` = '209367715' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:23:46.407' ,`MLSNumber` = '3831839' ,`ListAgentFullName` = 'Xuyen Pham' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.402980' ,`Longitude` = '-94.912600' ,`PhotoCount` = '25' ,`PostalCode` = '77590' ,`RoomCount` = '8' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Park Lane' ,`StreetNumber` = '1132' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2011' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller! You\'ll fall in love with this newly renovated home in Mainland Park! Features include: New flooring wood laminates throughout, new recess lighting, fixtures, sinks, faucets, updated bathrooms, granite counters, new stove 2022, dishwasher 2022, water heater 2022, and furnace 2022, new interior & exterior paint, new side fence and driveway. Oversized backyard is perfect for entertaining. Just a short drive to Galveston and Kemah Boardwalk. Schedule your showing today!!' ,`Acres` = '0.2191' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 167 PAGE 2 LOT 14 BLK 37 MAINLAND PARK SEC A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9544' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'ROOSEVELT-WILSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mainland Park' ,`TaxAmount` = '3109' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928785' WHERE `Matrix_Unique_ID` = '210721351' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T23:01:38.913' ,`MLSNumber` = '44021572' ,`ListAgentFullName` = 'Dawn Struss' ,`ListOfficeName` = 'Greystone Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.133057' ,`Longitude` = '-95.554647' ,`PhotoCount` = '48' ,`PostalCode` = '77375' ,`RoomCount` = '4' ,`ListPrice` = '1375000.00' ,`Status` = 'Active' ,`StreetName` = 'Haven' ,`StreetNumber` = '8514' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5282' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on market! When here relaxing sitting in your backyard looking at the lake having the children camp out it’s easy to forget that the rest of the world exist. Just intime for the Holiday’s Gorgeous Estate Home, Bucolic Park like waterfront property, large contemporary style heated pool with spa, circular driveway w/ water fountain. Travertine floors, granite counters w/ tile back-splash, huge plate glass picturesque windows. Serene patio, balcony Master an guest bedroom down and two bedrooms upstairs media/study/game areas. 2nd floor storage for items big and small. Large enough to expand. Secure gated community. it’s time to make the move to a nice quiet safe community of only 27 homes, where Children can ride and play with safety. Highly Motivated Seller!' ,`Acres` = '1.84' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 HAVEN LAKE ESTATES' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront,Wooded' ,`LotSize` = '80150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'METZLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Haven Lake Estates' ,`TaxAmount` = '22780' ,`TaxRate` = '2.124' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928785' WHERE `Matrix_Unique_ID` = '210733733' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:17:18.940' ,`MLSNumber` = '55964332' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733468' ,`Longitude` = '-95.361628' ,`PhotoCount` = '29' ,`PostalCode` = '77004' ,`RoomCount` = '3' ,`ListPrice` = '439900.00' ,`Status` = 'Active' ,`StreetName` = 'Delano' ,`StreetNumber` = '2909' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1803' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION! Introducing Delano Springs Phase I. This community will include 5 single family homes with private driveways and a contemporary design. These homes boast high end features including: Luxury vinyl floors, upgraded quartz countertop island, stainless steel appliances, shaker cabinets, modern glass backsplash in elegant patterned design, spacious 2nd floor living area, open concept floor-plan, and much more! Enjoy the convenient location that offers quick access to many downtown attractions and walking distance to Emancipation Park' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'BG Building Group' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 5 Blk 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Temporarily No Showings,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Delano Springs' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665928785' WHERE `Matrix_Unique_ID` = '211011319' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:48:14.057' ,`MLSNumber` = '50110993' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733468' ,`Longitude` = '-95.361628' ,`PhotoCount` = '29' ,`PostalCode` = '77004' ,`RoomCount` = '3' ,`ListPrice` = '439900.00' ,`Status` = 'Active' ,`StreetName` = 'Anita' ,`StreetNumber` = '2803' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1803' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION! Introducing Delano Springs Phase I. This community will include 5 single family homes with private driveways and a contemporary design. These homes boast high end features including: Luxury vinyl floors, upgraded quartz countertop island, stainless steel appliances, shaker cabinets, modern glass backsplash in elegant patterned design, spacious 2nd floor living area, open concept floor-plan, and much more! Enjoy the convenient location that offers quick access to many downtown attractions and walking distance to Emancipation Park' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'BG Building Group' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 2 BLK 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '1509' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Delano Springs' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665928785' WHERE `Matrix_Unique_ID` = '211031826' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:22:59.373' ,`MLSNumber` = '76987523' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733468' ,`Longitude` = '-95.361628' ,`PhotoCount` = '30' ,`PostalCode` = '77004' ,`RoomCount` = '3' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Delano' ,`StreetNumber` = '2913' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION! Introducing Delano Springs Phase I. This community will include 5 single family homes with private driveways and a contemporary design. These homes boast high end features including: Luxury vinyl floors, upgraded quartz countertop island, stainless steel appliances, shaker cabinets, modern glass backsplash in elegant patterned design, spacious 2nd floor living area, open concept floor-plan, and much more! Enjoy the convenient location that offers quick access to many downtown attractions and walking distance to Emancipation Park' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'BG Building Group' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Delano Springs' ,`LotDesciption` = 'Cleared' ,`LotSize` = '1964' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lot 1 BLK 1' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665928785' WHERE `Matrix_Unique_ID` = '211270826' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:21:29.533' ,`MLSNumber` = '64122217' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733468' ,`Longitude` = '-95.361628' ,`PhotoCount` = '29' ,`PostalCode` = '77004' ,`RoomCount` = '3' ,`ListPrice` = '439900.00' ,`Status` = 'Active' ,`StreetName` = 'Anita' ,`StreetNumber` = '2805' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1803' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION! Introducing Delano Springs Phase I. This community will include 5 single family homes with private driveways and a contemporary design. These homes boast high end features including: Luxury vinyl floors, upgraded quartz countertop island, stainless steel appliances, shaker cabinets, modern glass backsplash in elegant patterned design, spacious 2nd floor living area, open concept floor-plan, and much more! Enjoy the convenient location that offers quick access to many downtown attractions and walking distance to Emancipation Park' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'BG Building Group' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 3 BLK 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '1509' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Delano Springs' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665928786' WHERE `Matrix_Unique_ID` = '211271291' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T23:28:14.980' ,`MLSNumber` = '63380425' ,`ListAgentFullName` = 'Steven Johns' ,`ListOfficeName` = 'The Woodlands Realty' ,`SellingAgentFullName` = 'Cari Chambliss' ,`SellingOfficeName` = 'Elite Texas Properties' ,`Latitude` = '30.162986' ,`Longitude` = '-95.552020' ,`PhotoCount` = '50' ,`PostalCode` = '77375' ,`RoomCount` = '11' ,`ListPrice` = '737500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Woodglade' ,`StreetNumber` = '7' ,`StreetSuffix` = 'Way' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3149' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beyond the gates into Timarron Lakes this Pristine & Impeccable Home is perfectly situated on a premium homesite with plenty of space for your new pool. Backs to the Nature Preserve with an iron rear fence affording views of the forested greenbelt & wildlife. This one truly is immaculate and shows better than a model with incredible upgrades including Solid hardwood flooring, updated kitchen/bathrooms. Upon entry is a study with French doors and closet and beyond is a guest room with ensuite bath. The gourmet island kitchen is open to the family room and features include beautiful quartz countertops, Carrera marble backsplash, Monogram appliances, pot-filler and large walk-in pantry. Family room features include a corner fireplace, surround sound and a wall of windows. Master bedroom with recently updated elegant master bath suite. Up the hardwood staircase is the large media room along and a guest room and ensuite bath. Large 3.5 car garage with professionally applied epoxy coating.' ,`Acres` = '0.2469' ,`Area` = '14' ,`BuilderName` = 'Darling Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 40 BLK 1 THE WOODLANDS CREEKSIDE PARK WEST 17' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '10754' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1690' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TIMBER CREEK ELEMENTARY SCHOOL (Tomball)' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Creekside Park West 17' ,`TaxAmount` = '11162' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928786' WHERE `Matrix_Unique_ID` = '211409228' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T23:29:06.443' ,`MLSNumber` = '94919141' ,`ListAgentFullName` = 'Monty Singh' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766455' ,`Longitude` = '-95.340957' ,`PhotoCount` = '24' ,`PostalCode` = '77020' ,`RoomCount` = '6' ,`ListPrice` = '489990.00' ,`Status` = 'Active' ,`StreetName` = 'Cline' ,`StreetNumber` = '2838' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1828' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NOW SELLING!! NEW CONSTRUCTION Gated Community in the hottest, fastest growing part of Houston - East Downtown!! Amazing views of the downtown skyline! Stunning 3 bed 3.5 Bath homes with private backyards centrally located inner city. ONE BLOCK from the upcoming, East River shipping/residential project, brought to you by the same developers of City Centre - but a planned 4 times the size! Literally 1 mile from Downtown, and minute away from Minute Maid Park, Toyota Center, and Discovery Green. Modern Open concept floorplan, Living and Kitchen area on the 2nd floor, massive kitchen island with shaker cabinets and elegant quartz counter-tops, living area opens up to a spacious exterior balcony. Beautiful finishes and fine craftsmanship adorn each floor. 9in High End Luxury Vinyl Wood planks, Stainless steel appliances, fine hardware, high ceilings on all levels make this community a one of a kind. Selection Sheet of all Finishes available upon request. Schedule your Private-Tour today!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'RDZ Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Schwartz Gardens BLK 1 LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1558' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRUCE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Views At East River' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665928786' WHERE `Matrix_Unique_ID` = '211455364' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T23:25:22.880' ,`MLSNumber` = '59178024' ,`ListAgentFullName` = 'Monty Singh' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766157' ,`Longitude` = '-95.340914' ,`PhotoCount` = '24' ,`PostalCode` = '77020' ,`RoomCount` = '6' ,`ListPrice` = '499990.00' ,`Status` = 'Active' ,`StreetName` = 'Cline' ,`StreetNumber` = '2842' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1828' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NOW SELLING!! NEW CONSTRUCTION Gated Community in the hottest, fastest growing part of Houston - East Downtown!! Amazing views of the downtown skyline! Stunning 3 bed 3.5 Bath homes with private backyards centrally located inner city. ONE BLOCK from the upcoming, East River shipping/residential project, brought to you by the same developers of City Centre - but a planned 4 times the size! Literally 1 mile from Downtown, and minute away from Minute Maid Park, Toyota Center, and Discovery Green. Modern Open concept floorplan, Living and Kitchen area on the 2nd floor, massive kitchen island with shaker cabinets and elegant quartz counter-tops, living area opens up to a spacious exterior balcony. Beautiful finishes and fine craftsmanship adorn each floor. 9in High End Luxury Vinyl Wood planks, Stainless steel appliances, fine hardware, high ceilings on all levels make this community a one of a kind. Selection Sheet of all Finishes available upon request. Schedule your Private-Tour today!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'RDZ Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Schwartz Gardens BLK 1 LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1408' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRUCE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Views At East River' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665928786' WHERE `Matrix_Unique_ID` = '211455859' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T23:27:04.610' ,`MLSNumber` = '95264301' ,`ListAgentFullName` = 'Monty Singh' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766204' ,`Longitude` = '-95.340780' ,`PhotoCount` = '24' ,`PostalCode` = '77020' ,`RoomCount` = '6' ,`ListPrice` = '479990.00' ,`Status` = 'Active' ,`StreetName` = 'Cline' ,`StreetNumber` = '2850' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1850' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NOW SELLING!! NEW CONSTRUCTION Gated Community in the hottest, fastest growing part of Houston - East Downtown!! Amazing views of the downtown skyline! Stunning 3 bed 3.5 Bath homes with private backyards centrally located inner city. ONE BLOCK from the upcoming, East River shipping/residential project, brought to you by the same developers of City Centre - but a planned 4 times the size! Literally 1 mile from Downtown, and minutes away from Minute Maid Park, Toyota Center, and Discovery Green. Modern Open concept floorplan, Living and Kitchen area on the 2nd floor, massive kitchen island with shaker cabinets and elegant quartz counter-tops, living area opens up to a spacious exterior balcony. Beautiful finishes and fine craftsmanship adorn each floor. 9in High End Luxury Vinyl Wood planks, Stainless steel appliances, fine hardware, high ceilings on all levels make this community a one of a kind. Selection Sheet of all Finishes available upon request. Schedule your Private-Tour today!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'RDZ Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Schwartz Gardens BLK 1 LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1408' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRUCE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Views At East River' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665928786' WHERE `Matrix_Unique_ID` = '211456248' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T23:21:59.693' ,`MLSNumber` = '48072559' ,`ListAgentFullName` = 'Monty Singh' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766043' ,`Longitude` = '-95.340791' ,`PhotoCount` = '24' ,`PostalCode` = '77020' ,`RoomCount` = '6' ,`ListPrice` = '499990.00' ,`Status` = 'Active' ,`StreetName` = 'Cline' ,`StreetNumber` = '2846' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1866' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NOW SELLING!! NEW CONSTRUCTION Gated Community in the hottest, fastest growing part of Houston - East Downtown!! Amazing views of the downtown skyline! Stunning 3 bed 3.5 Bath homes with private backyards centrally located inner city. ONE BLOCK from the upcoming, East River shipping/residential project, brought to you by the same developers of City Centre - but a planned 4 times the size! Literally 1 mile from Downtown, and minute away from Minute Maid Park, Toyota Center, and Discovery Green. Modern Open concept floorplan, Living and Kitchen area on the 2nd floor, massive kitchen island with shaker cabinets and elegant quartz counter-tops, living area opens up to a spacious exterior balcony. Beautiful finishes and fine craftsmanship adorn each floor. 9in High End Luxury Vinyl Wood planks, Stainless steel appliances, fine hardware, high ceilings on all levels make this community a one of a kind. Selection Sheet of all Finishes available upon request. Schedule your Private-Tour today!' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'RDZ Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Schwartz Gardens BLK 1 LOT 6' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '1658' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRUCE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Views At East River' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665928787' WHERE `Matrix_Unique_ID` = '211456655' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:02:28.297' ,`MLSNumber` = '29224034' ,`ListAgentFullName` = 'Melida Marquez' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.720841' ,`Longitude` = '-95.059634' ,`PhotoCount` = '23' ,`PostalCode` = '77351' ,`RoomCount` = '5' ,`ListPrice` = '99000.00' ,`Status` = 'Active' ,`StreetName` = 'Cloverdale' ,`StreetNumber` = '304' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1072' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 Bedroom 2 Bath located inside Lake Livingston Village. Subdivision offers so many amenities to its property owners, including a boat ramp, pavilions, swimming pools and picnic areas only1 ½ hours north of Houston, and just minutes into town.' ,`Acres` = '0.0872' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE LIVINGSTON VILLAGE SECTION 8 LOT 17' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '3800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '24' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Livingston Village' ,`TaxAmount` = '71' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665928787' WHERE `Matrix_Unique_ID` = '211499021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:37:41.497' ,`MLSNumber` = '63935295' ,`ListAgentFullName` = 'Sugra Shaik' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.059788' ,`Longitude` = '-95.522486' ,`PhotoCount` = '20' ,`PostalCode` = '77379' ,`RoomCount` = '7' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Chicoma' ,`StreetNumber` = '6706' ,`StreetSuffix` = 'Street' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2866' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Home is in a Tranquil gated community, 4 minutes to a golf course, secluded with a play ground, lake and walking trails!!!!\r\nThis home is a village builders ICON, \"Versailles\" plan, Brick/Stone elevation A, in Vistas at Klein lake. The home sits on a corner lot that is landscaped, It has recessed lighting, tall ceilings and a modern warm feeling. kitchen features an island with 42\" designer cabinets and granite countertops. All stainless steel appliances included.\r\nThis gorgeous 2 story 4/3.5/2 with master and 2nd bedroom downstairs, game room and 2 bedrooms upstairs. Master bath with tub and separate shower and his and hers closets.\r\nIt has an extended patio to entertain family and guests. It has energy efficient 16 seer HVAC system program, digital Thermostat, Radiant barrier, roof decking, and MORE!!!! It is also a WIFI certified smart home featuring automation and voice control with Amazon Alexa.\r\nSchedule your showing today!!!' ,`Acres` = '0.1766' ,`Area` = '14' ,`BuilderName` = 'village builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 1 VISTAS OF KLEIN LAKE SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '7693' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BENIGNUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Vistas/Klein Lake Sec 2' ,`TaxAmount` = '9359' ,`TaxRate` = '2.6765' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665928787' WHERE `Matrix_Unique_ID` = '212242356' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T23:22:00.317' ,`MLSNumber` = '3817396' ,`ListAgentFullName` = 'Ronald Espling' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.669957' ,`Longitude` = '-95.496725' ,`PhotoCount` = '42' ,`PostalCode` = '77096' ,`RoomCount` = '9' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Yarwell' ,`StreetNumber` = '6027' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2819' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming home in the highly sought after and established neighborhood of Maplewood South has been tastefully renovated! The homes layout has been taken from closed off/isolated to spacious/open! New windows welcome tons of natural light as well as providing better efficiency. The stunning kitchen has been generously expanded and offers soft close cabinetry, new stainless steel appliances, gas range, lux glass tile backsplash, and more! Home office/study area offers a nice place to work or focus on daily tasks. Large primary suite has more than enough room for a king sized bed and a seating area and offers a stunning spa like primary bathroom with gorgeous glass tile shower and walk in closet. Large secondary bedrooms offer family the space they crave and one of the secondary bedrooms offers its own private en suite bathroom. Other updates: PEX plumbing, new lux flooring, New electrical, new quartz counters, new tile, recessed lighting, new cabinets, new paint inside and out, and more!' ,`Acres` = '0.1901' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 24 MAPLEWOOD SOUTH SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '487' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELROD ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Maplewood South Sec 06' ,`TaxAmount` = '7030' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928787' WHERE `Matrix_Unique_ID` = '212455505' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T23:04:10.670' ,`MLSNumber` = '9087911' ,`ListAgentFullName` = 'Michelle Hinton' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Martine Nerrant' ,`SellingOfficeName` = 'Energy Realty' ,`Latitude` = '29.848444' ,`Longitude` = '-95.592303' ,`PhotoCount` = '45' ,`PostalCode` = '77041' ,`RoomCount` = '11' ,`ListPrice` = '650000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sterling' ,`StreetNumber` = '5527' ,`StreetSuffix` = 'Brook' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3978' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stately Trendmaker home on a well-landscaped corner lot w/ pool & spa in desirable Lakes on Eldridge. A soaring 2-story foyer w/elegant curved staircase opens to a spacious plan w/ hickory wood flooring, plantation shutters & great natural light. Private Study w/ French doors & Formal Dining w/ millwork details feature bay windows overlooking the front of the home. Island kitchen w/ white cabinetry & breakfast bar boasts sleek black granite, stainless steel appliances, double oven. Family Room w/ updated fireplace & wall of windows overlooking the backyard & pool. First-floor Primary Suite features a spacious sitting area w/fireplace & an Ensuite w/dual vanities, jetted tub & frameless shower. Upstairs is a Game Room w/ built-ins, hidden room & desk area, plus 3 secondary beds and baths. Outside is a private backyard oasis. Flagstone patio w/ pergola, pool & spa. 3 car garage, gated driveway, recent roof. Enjoy resort-like living in this guard-gated community. Did not flood.' ,`Acres` = '0.28' ,`Area` = '8' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 2 LAKES ON ELDRIDGE SEC 18' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '12197' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'Gunite,Heated' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes On Eldridge Sec 18' ,`TaxAmount` = '13077' ,`TaxRate` = '2.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928787' WHERE `Matrix_Unique_ID` = '212553928' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:31:15.027' ,`MLSNumber` = '96001827' ,`ListAgentFullName` = 'Cristal Yanes' ,`ListOfficeName` = 'RE/MAX American Dream' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.344410' ,`Longitude` = '-95.112831' ,`PhotoCount` = '25' ,`PostalCode` = '77517' ,`RoomCount` = '9' ,`ListPrice` = '388000.00' ,`Status` = 'Active' ,`StreetName` = 'Highland' ,`StreetNumber` = '7217' ,`StreetSuffix` = 'Road' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1514' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property features 3 beds, 2 baths on 3.181 acres in Santa Fe TX. Home has been fully updated with attractive modern finishes. Resilient vinyl plank flooring throughout. Open living, dining and kitchen concept. Beautiful kitchen offers quartz countertops, tiled backsplash and brand new stainless steel Samsung appliances. Side by side refrigerator with water and ice maker included. Ideal split floor plan. Large primary bedroom consists of its own private bathroom and conveniently provides a full tub shower combo plus a lavish separate stand up shower. Both full bathrooms supply double sinks. Indoor utility space may also serve as a mud room. Enjoy front and side covered deck porches. Three sided, 3 car carport also great for a workshop. Schedule to appreciate in person all that this lovely home with acreage delivers. Ready for immediate new ownership!' ,`Acres` = '3.18' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 47 L CRAWFORD SUR PT OF OUTLOT 403 (403-6) ALTA LOMA OU' ,`LotDesciption` = 'Cleared' ,`LotSize` = '138564' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'DAN J KUBACAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Alta Loma Outlots' ,`TaxAmount` = '4761' ,`TaxRate` = '2.0881' ,`WaterSewer` = 'Septic Tank,Water District,Well' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928787' WHERE `Matrix_Unique_ID` = '212685218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T23:25:38.107' ,`MLSNumber` = '38499326' ,`ListAgentFullName` = 'Tamara Edwards' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.003742' ,`Longitude` = '-95.143980' ,`PhotoCount` = '50' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '279800.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn Creek' ,`StreetNumber` = '19603' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**This one has some additional perks, please ask for more info!** WELCOME - to this lovely 1.5 story with wood beam vaulted ceilings and an OPEN-floorplan of a ranch featuring ALL Bedrooms Down! Situated in the prime location of Atascocita and next to Lake Houston! Turnkey ready this home boasts tasteful upgrades & recent improvements! Shows like a model home after recently being renovated & now brags w/Luxury Vinyl floors, Granite in kitchen, Quartz in primary bath, New carpet, New hardware/fixtures/lighting, wrought iron stair railing, ALL cabinetry refurb, revitalized tile, PEX plumbing, AC under warranty until 2023! There\'s MORE; a new driveway, new sidewalk entry, landscaping, sod, painted exterior, & transferrable lifetime foundation warranty. The list goes on! FRIDGE stays! Primary room is massive w/French doors that lead to outdoor patio & has ensuite bath w/ Soaker tub AND walk-in dual closets! Gameroom UP w/Wetbar & cooler niche + Half Bath! Low Tax Rate & Never Flooded!' ,`Acres` = '0.1331' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 1 PINES OF ATASCOCITA SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '649' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Pines Atascocita Sec 01' ,`TaxAmount` = '4199' ,`TaxRate` = '2.216' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928788' WHERE `Matrix_Unique_ID` = '212745163' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:10:35.510' ,`MLSNumber` = '59705517' ,`ListAgentFullName` = 'Osaan Ronding' ,`ListOfficeName` = 'The Listing Firm' ,`SellingAgentFullName` = 'Jennifer Yoingco' ,`SellingOfficeName` = 'Walzel Properties' ,`Latitude` = '30.135170' ,`Longitude` = '-95.648153' ,`PhotoCount` = '20' ,`PostalCode` = '77362' ,`RoomCount` = '4' ,`ListPrice` = '319900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Annice' ,`StreetNumber` = '32018' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully maintained 4 bedroom 2.5 bath home w/ sparkling pool, ready for your immediate move in! Fresh paint & designers touches throughout. Granite counters in kitchen w/ SS appliances. Huge primary bedroom w/ his & her vanities, tub, separate shower & large walk-in closet. Easy access to 249. This is a must see!' ,`Acres` = '0.1263' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'VILLAGE OF DECKER OAKS 01, BLOCK 6, LOT 28' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Of Decker Oaks 01' ,`TaxAmount` = '4550' ,`TaxRate` = '1.9215' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928788' WHERE `Matrix_Unique_ID` = '212778657' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T23:04:46.110' ,`MLSNumber` = '25822208' ,`ListAgentFullName` = 'Norma Camarillo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.818669' ,`Longitude` = '-95.789253' ,`PhotoCount` = '29' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Bugatti' ,`StreetNumber` = '3026' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1457' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICE REDUCED!!! BETTER THAN NEW! THIS COZY ONE STORY THREE BEDROOMS AND TWO BATHS IS READY FOR A NEW OWNER! THIS BEAUTIFUL ENERGY EFFICIENT HOME, FEATURES AN OPEN CONCEPT WITH AN ISLAND KITCHEN, LIGHTING UNDER THE CABINETS, HIS AND HER\'S CLOSETS. SPOT LIGHTS THROUGH OUT THEHOME, HIGH CEILINGS, TANKLESS WATER HEATER, GARAGE DOOR OPENER AND SPINKLER SYSTEM. COVENIENTLY LOCATED NEAR ELEMENTARY SCHOOL, SHOPPING CENTERS, GRAND PARKWAY99 AND I-10.\r\nBUYER PLEASE VERIFY SCHOOLS, ROOM DIMENSIONS APPROXIMATE.' ,`Acres` = '0.1149' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 2 MORTON CREEK RANCH SEC 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5005' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Morton Creek Ranch Sec 14' ,`TaxAmount` = '6072' ,`TaxRate` = '3.3333' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928788' WHERE `Matrix_Unique_ID` = '212980928' --> 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','213033910','1665928788','213033910','2022-10-15T23:09:32.400','34377053','Luanna Taylor','Sapphire Realty','','','29.725840','-95.634215','19','77082','6','275000.00','Active','Aspen Hollow','13851','Lane','Houston','2','1','3','1592','Single-Family','This beautiful fully renovated/upgraded 3 bedroom home is located in a well established neighborhood with a large lot in the Alief area. This home features recent upgrades such as laminate tile flooring throughout the home and paint. The kitchen has upgraded kitchen cabinets, sink, backsplash, water and lighting fixtures. The kitchen features a nice island/sitting area. All bedrooms are located upstairs. Bathrooms were upgraded with mirrors, sinks, lighting and water fixtures. Large back yard with patio slab and 2-car garage.','0.1772','31','','','','','Sellers Disclosure','1','','0','Alief','Central Electric','1','LT 31 BLK 5 (ORIG RES L BK 7) WESTHOLLOW VILLAGE','Subdivision Lot','7720','Appraisal District','','400','0','','2','Gas Oven','0','','','Gas Range','','Composition','2 - Alief','HEFLIN ELEMENTARY SCHOOL','AISD DRAW','O\'DONNELL MIDDLE SCHOOL','Lockbox Right Side,Vacant/Unoccupied','Appraisal District','2','Contemporary/Modern','Westhollow Village','3907','2.4411','Public Sewer,Public Water','1981','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:33:13.197' ,`MLSNumber` = '48791631' ,`ListAgentFullName` = 'Claire Liang' ,`ListOfficeName` = 'Houston Elite Properties LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.670732' ,`Longitude` = '-95.420938' ,`PhotoCount` = '33' ,`PostalCode` = '77054' ,`RoomCount` = '5' ,`ListPrice` = '363000.00' ,`Status` = 'Active' ,`StreetName` = 'Coastal Greens' ,`StreetNumber` = '2606' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2047' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 3-story house with 3 bedrooms, 3.5 baths, in guard-gated community. Fresh exterior painting (2022), new garage door motor,(2015) new A/C (2020). This house has updated modern ceiling fans, wide windows, hardwood & carpet flooring. You will surely love this house as it has an open floor plan in the living room, dining area, and kitchen. It has a spacious well-lit living room featuring wide windows, a ceiling fan, and easy access to the balcony with a great water view. The beautiful kitchen equipped with stainless steel appliances, custom cabinets, and granite countertops. On the third floor, a wide master bedroom with high ceilings and a spa-like bathroom await you. There are also two guest rooms to provide you and your guest more space to relax and enjoy. Outside, is a fully fenced backyard, a perfect place for your family to relax and unwind. Great Location. Easy to access to public transportation, TMC, Rice and etc. Water bill is included.Don\'t forget to check our 3D tour' ,`Acres` = '0.0347' ,`Area` = '18' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Medical Center Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 3 BEDFORD FALLS AMEND' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '1512' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHEARN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Bedford Falls' ,`TaxAmount` = '6837' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665928788' WHERE `Matrix_Unique_ID` = '213092759' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:22:07.957' ,`MLSNumber` = '89747206' ,`ListAgentFullName` = 'Claire Liang' ,`ListOfficeName` = 'Houston Elite Properties LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.697192' ,`Longitude` = '-95.713034' ,`PhotoCount` = '21' ,`PostalCode` = '77407' ,`RoomCount` = '5' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Sable Forest TRL' ,`StreetNumber` = '18906' ,`StreetSuffix` = '' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1818' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning house with 4 bedrooms, 2 baths, in a very nice community in Lakeview Retreat. This house has ceiling fans, wide windows, hardwood flooring & carpet flooring. You will surely love this house as it has an open floor plan in the living room, dining area, and kitchen. It has a spacious living room featuring wide windows, a ceiling fan, and easy access to the backyard. Cook like a pro in the beautiful kitchen equipped with stainless steel appliances, with nice white custom cabinets, and a large island. It also has a wide master\'s bedroom with an en suite bathroom that awaits you for your slumber. There are also three guest rooms to provide you and your guest more space to relax and enjoy. Outside, is a covered patio and a fully fenced backyard with green luscious grass, a perfect place for your family to relax and unwind. Create your precious memories and make your dream home come true. Don\'t forget to check our 3D tour.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Sec 6, BLOCK 5, Lot 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6016' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928788' WHERE `Matrix_Unique_ID` = '213093301' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:46:31.953' ,`MLSNumber` = '29279167' ,`ListAgentFullName` = 'Thurman Nassoiy' ,`ListOfficeName` = 'Worth Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.776551' ,`Longitude` = '-95.420673' ,`PhotoCount` = '23' ,`PostalCode` = '77007' ,`RoomCount` = '10' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Nolda' ,`StreetNumber` = '5516' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home! You are close to everything and part of a wonderful gated community! Enter to find an open-concept living, dining, and kitchen area that\'s ideal for entertaining. The well-equipped kitchen has granite countertops, stainless appliances (including new microwave, 2022) and the refrigerator is included! Upstairs you\'ll find two spacious secondary bedrooms with a generous secondary bath. Fall in love the secluded primary suite complete with a generous bedroom area that basks in natural light, an expansive closet, and an ensuite bathroom with large tub, separate shower, and extended vanity with dual sinks. The second-floor utility room eliminates carrying laundry up and down the stairs. Outside, you\'ll find a beautiful low-maintenance patio and the patio furniture is also included! This home is everything you need and ready for you to make fabulous new memories!' ,`Acres` = '0.0471' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 1 NOLDA TERRACE T/H' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Nolda Terrace Twnhms' ,`TaxAmount` = '7929' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928789' WHERE `Matrix_Unique_ID` = '213127348' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:30:52.843' ,`MLSNumber` = '26921049' ,`ListAgentFullName` = 'Kori Schmidt' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = 'Kristopher Wilson' ,`SellingOfficeName` = 'TDT, Realtors' ,`Latitude` = '29.748447' ,`Longitude` = '-94.967046' ,`PhotoCount` = '25' ,`PostalCode` = '77520' ,`RoomCount` = '7' ,`ListPrice` = '189000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Gresham' ,`StreetNumber` = '218' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1276' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This newly remodeled home is ready for it\'s new owners! This corner lot home features two living areas, a 2 car garage with a porte cochere, 3 bedrooms, and tons of natural light! Its recent renovations include AC installed 2020, new windows in 2020 and 2022, roof replaced 2019, siding repairs 2022, all new flooring throughout 2022, completely new bathroom 2022, and new kitchen cabinets 2022. Act fast! You won\'t want to miss out on this one.' ,`Acres` = '0.1377' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 3 MORRELL PARK SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'LAMAR ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'HORACE MANN J H' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Morrell Park Sec 01' ,`TaxAmount` = '2248' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928789' WHERE `Matrix_Unique_ID` = '213169887' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T23:12:26.383' ,`MLSNumber` = '96053876' ,`ListAgentFullName` = 'Victor Correa' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.998880' ,`Longitude` = '-95.704131' ,`PhotoCount` = '44' ,`PostalCode` = '77429' ,`RoomCount` = '9' ,`ListPrice` = '299995.00' ,`Status` = 'Active' ,`StreetName` = 'Kings Cypress' ,`StreetNumber` = '15826' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2424' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Totally upgraded 3 beds 2.5 bath! New floors all thru out! New Appliances! New Trane Hvac! New Roof, New Kitchen! New Blinds! And much more! Won\'t last!' ,`Acres` = '0.1288' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 1 CYPRESS RIDGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'A ROBISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Ridge Sec 01' ,`TaxAmount` = '5657' ,`TaxRate` = '2.761' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928789' WHERE `Matrix_Unique_ID` = '213194508' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:14:02.303' ,`MLSNumber` = '65460158' ,`ListAgentFullName` = 'Lesa Shatzer' ,`ListOfficeName` = 'Reliable Realty' ,`SellingAgentFullName` = 'Corby Callaway' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.884526' ,`Longitude` = '-95.616813' ,`PhotoCount` = '17' ,`PostalCode` = '77041' ,`RoomCount` = '6' ,`ListPrice` = '229000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Kite Hill' ,`StreetNumber` = '7319' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1468' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '!! We have received multiple offers. Please send best and final offer by 4PM today October 11th.!!\r\n\r\nGreat one story with engineered heard woods in living room and hall, tile in kitchen, entry and baths and new carpet in bedrooms only. New kitchen countertops, faucet, dishwasher, stove, new tub and deco tile primary bath, new 2 tone interior paint, new blinds and back fence. Ready for move in and enjoy BBQ on covered back patio.' ,`Acres` = '0.1377' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud,No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 2 CHIMNEY HILL SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAIRGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chimney Hill Sec 01' ,`TaxAmount` = '4200' ,`TaxRate` = '2.811' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928789' WHERE `Matrix_Unique_ID` = '213224826' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:18:37.453' ,`MLSNumber` = '79400205' ,`ListAgentFullName` = 'Neil Silverman' ,`ListOfficeName` = 'Bernstein Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.683388' ,`Longitude` = '-95.490770' ,`PhotoCount` = '43' ,`PostalCode` = '77096' ,`RoomCount` = '10' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Jason' ,`StreetNumber` = '5727' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2515' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious 4 bedroom, 2.5 bath home in Meyerland, zoned to Bellaire Highschool. Home has formal dining and\r\nliving room as well as spacious family room. Good size kitchen with plenty of cabinets, ample counter space,\r\nas well as a breakfast room area. All bedrooms are good size. Great backyard, spacious enough for\r\nentertaining and adding a pool. FANTASTIC Location, zoned to Bellaire HS, short drive to Medical Center, Galleria, and Downtown. Room dimensions are approximate, please verify as well as school(s)\r\nenrollment availability that property is zoned for.(*Roof replaced March of 2016, *Never Flooded. *Per Seller)' ,`Acres` = '0.2197' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 10 MEYERLAND SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9569' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HEROD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Meyerland Sec 10' ,`TaxAmount` = '9117' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928789' WHERE `Matrix_Unique_ID` = '213254110' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T23:41:24.847' ,`MLSNumber` = '91479318' ,`ListAgentFullName` = 'Patricia Castillo' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.941396' ,`Longitude` = '-95.699160' ,`PhotoCount` = '48' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '870000.00' ,`Status` = 'Active' ,`StreetName` = 'Jodie Lynn' ,`StreetNumber` = '26047' ,`StreetSuffix` = 'Circle' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Gracefully situated on a very quiet street in the sought after Cypress Creek Lakes Community. This luxurious 4 Bedroom and 3.5 Bath Perry Home has highly desirable features which include inviting double doors, huge Grand Rotunda entry with cathedral ceiling, wrought iron circular double stairs. Enormous Formal Living and Dining Rooms. Spacious Gourmet Kitchen with custom cabinets and granite countertops, huge walking pantry, and professional grade appliances including new Cooktop, Dishwasher & Microwave. Enormous master retreat with fireplace and seating area. Stunning Family Room with wall of windows. Open Flowing Floor Plan. Elegant raised Study with french doors . Climb the elegant curved staircase to find a big Game Room, 2nd Master Suite and 2 additional Bedrooms, 2 Full Baths and a Media Room. Enjoy the outdoors with your own Tropical Backyard with a Big Saltwater Pool with Grotto Spa. 3 Car Garage. Top Rated CFISD Schools. Full Picture Gallery loading Sat Oct 15' ,`Acres` = '0.3587' ,`Area` = '25' ,`BuilderName` = 'Perry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 2 CYPRESS CREEK LAKES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`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,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Crk Lakes Sec 2' ,`TaxAmount` = '15010' ,`TaxRate` = '2.801' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928790' WHERE `Matrix_Unique_ID` = '213262577' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T23:52:00.693' ,`MLSNumber` = '6629217' ,`ListAgentFullName` = 'Maria Villenas' ,`ListOfficeName` = 'Evol Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.661319' ,`Longitude` = '-95.351495' ,`PhotoCount` = '11' ,`PostalCode` = '77033' ,`RoomCount` = '3' ,`ListPrice` = '119000.00' ,`Status` = 'Active' ,`StreetName` = 'Larkspur' ,`StreetNumber` = '4826' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable Abode on quiet street, ready for new owner to give it lots of creativity and loving attention. Older house with plenty of charm! 2 well lit bedrooms, a modernized bathroom, a comfy and spacious living/dining combo, and a timeless carport are the right fit for a young family starting out their dream of home ownership, or an empty nester ready to downsize to a simple life,. The neighbors love their street and take care of their home and each other. This is also a wonderful addition to anyone\'s portfolio of performing rental units of the money making kind.' ,`Acres` = '0.1313' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 21 CHOCOLATE BAYOU ESTATES SEC 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chocolate Bayou Estates Sec 02' ,`TaxAmount` = '1748' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928790' WHERE `Matrix_Unique_ID` = '213264793' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T23:02:42.310' ,`MLSNumber` = '12131377' ,`ListAgentFullName` = 'Karen Shotwell' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Kelly Le' ,`SellingOfficeName` = '5th Stream Realty' ,`Latitude` = '29.875852' ,`Longitude` = '-95.681528' ,`PhotoCount` = '23' ,`PostalCode` = '77084' ,`RoomCount` = '3' ,`ListPrice` = '240000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Autumn Hills' ,`StreetNumber` = '17902' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3 bedroom 2 bath single level home with high ceilings ample amount of natural sunlight. Nestled in the established Northglen subdivision. Upgraded kitchen with granite countertops with matching stainless steel appliances. Primary bedroom has a large walk-in closet, private bath with dual vanity, separate shower, and garden tub. Fully fenced backyard with oversized shed. This well cared for home is Just minutes from Lone Star College and the Berry Center. Call to schedule your private showings today!' ,`Acres` = '0.1494' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 10 NORTHGLEN SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6510' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'METCALF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northglen Sec 02' ,`TaxAmount` = '4465' ,`TaxRate` = '2.706' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928790' WHERE `Matrix_Unique_ID` = '213304139' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:30:20.757' ,`MLSNumber` = '62583380' ,`ListAgentFullName` = 'Deborah Stepanek' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.838574' ,`Longitude` = '-95.944025' ,`PhotoCount` = '29' ,`PostalCode` = '77831' ,`RoomCount` = '3' ,`ListPrice` = '275000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'County Road 115 A' ,`StreetNumber` = '27344' ,`StreetSuffix` = '' ,`City` = 'Bedias' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1296' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great country property with privacy on a dead end road, 3 bedroom 2 bath home on 3.79 acres, Large Living room/Nice Kitchen with a breakfast bar, Nice cabinets & Refrigerator will convey, split floor plan. Large Laundry/Mudroom, with an above ground pool 2 car detached garage, and dining area with sliding glass doors with a nice view of the property, Storage buildings and a pond. Nice trees and fenced and crossed fenced, You can have horses or 4-H projects, This home and property have many improvements, New vinyl flooring last week, New Shower doors in the Master, New Plumbing after the freeze 2021, Well had a new pump in 2006 redrilled with new pipes inside the well in 2007, septic tank installed in early 2021, New Vinyl Siding May 2022, Above ground pool has a new liner, 2 car garage W/slab with 220 wiring, Roof is only 7 yrs old, There is a well house and a storage building, additional building that could be remodeled for a guest house or additional storage. Not a Mobile Home' ,`Acres` = '3.79' ,`Area` = '60' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bedias/Roans Prairie Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0053 I SIMES, TRACT 2, ACRES 3.79' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '165092' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '175 - Madisonville Consolidated' ,`SchoolElementary` = 'MADISONVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISONVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MADISONVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'N/A' ,`TaxAmount` = '2653' ,`TaxRate` = '1.7056' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928790' WHERE `Matrix_Unique_ID` = '213327236' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:45:18.400' ,`MLSNumber` = '31818439' ,`ListAgentFullName` = 'Jeffrey Welch' ,`ListOfficeName` = 'Welch Realty Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.998090' ,`Longitude` = '-95.608132' ,`PhotoCount` = '47' ,`PostalCode` = '77429' ,`RoomCount` = '10' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Highland Hills' ,`StreetNumber` = '12815' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2922' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This amazing house in Lakewood Forest has 4 spacious bedrooms, 2 1/2 baths & a detached two-car garage sitting on a 10,000+- square foot lot. Inside this home, you will find a foyer, den, dining room, huge family room with built-ins and a gas log fireplace., a nice updated kitchen with pantry & breakfast area overlooking the lovely backyard, a huge upstairs game room, a large master bedroom plus 3 additional spacious bedrooms all w/large walk-in closets, the secondary bathroom comes with double sinks and tub/shower combination. The very generous main bedroom includes a walk-in closet and an updated bathroom with double sinks. The mini-splits throughout the home and the no carpeting could make this home very efficient in cost and cleaning. A wonderful large home in a beautiful neighborhood and award-winning Cypress-Fairbanks School District Make your appointment today!' ,`Acres` = '0.2388' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 23 LAKEWOOD FOREST SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '655' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`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,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Forest' ,`TaxAmount` = '5958' ,`TaxRate` = '2.5217' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928790' WHERE `Matrix_Unique_ID` = '213329617' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:22:58.920' ,`MLSNumber` = '81481673' ,`ListAgentFullName` = 'Denise Moore' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.047459' ,`Longitude` = '-95.204505' ,`PhotoCount` = '39' ,`PostalCode` = '77339' ,`RoomCount` = '14' ,`ListPrice` = '1150000.00' ,`Status` = 'Active' ,`StreetName` = 'Kings Forest' ,`StreetNumber` = '2907' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4826' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This incredible home has been built and redesigned with today\'s living in mind. Create memories and entertain in the Chef\'s kitchen which features a massive marble island, gorgeous windows and Fisher Paykel appliances. Quality white oak floors flows seamless throughout the first floor living space. Relax in this spacious primary bath as you are surrounded by marble down to the basket weave pattern on the floor. Enjoy the soaking tub, huge shower, separate vanities, gorgeous built-in linen closet and separate make-up vanity. Window casing and handcrafted custom cabinetry throughout shows the quality and excellence in this stunning home. Roof, windows, plumbing, electrical and tankless water heater have been replaced. Take a look at this one of a kind custom remodel. The details and designer touches are truly exquisite!' ,`Acres` = '0.8945' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 15A BLK 4 KINGS FOREST SEC 1' ,`LotDesciption` = 'Cleared,In Golf Course Community' ,`LotSize` = '38964' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Forest Sec 01' ,`TaxAmount` = '8418' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928791' WHERE `Matrix_Unique_ID` = '213376954' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:12:22.747' ,`MLSNumber` = '95862909' ,`ListAgentFullName` = 'Patricia Woldtvedt' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.444471' ,`Longitude` = '-95.098565' ,`PhotoCount` = '18' ,`PostalCode` = '77539' ,`RoomCount` = '7' ,`ListPrice` = '268000.00' ,`Status` = 'Active' ,`StreetName` = 'Sandstone Creek' ,`StreetNumber` = '416' ,`StreetSuffix` = 'Lane' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home, nestled in the Bay Pointe Colony Subdivision is ready for its new owners. Home did not flood. Buyer(s) to verify. Beautiful archways and double sided fireplace to enjoy while dining or relaxing in your living area. The front bedroom can be utilized as an office/playroom for you to enjoy as you see fit! Freshly painted interior & exterior allows for you to move right in, add your own finishing touches and decor to make this your next forever home. Call now for your appointment. This one is sure to go fast!' ,`Acres` = '0.1398' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 19 PERRY & AUSTIN SUR LOT 11 BLK 1 BAY COLONY POINTE SE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6090' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '96' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Colony Pointe' ,`TaxAmount` = '6242' ,`TaxRate` = '2.8897' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928791' WHERE `Matrix_Unique_ID` = '213411400' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:36:41.937' ,`MLSNumber` = '61452585' ,`ListAgentFullName` = 'Christopher Jolibois' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Christopher Jolibois' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.513618' ,`Longitude` = '-95.208450' ,`PhotoCount` = '43' ,`PostalCode` = '77546' ,`RoomCount` = '20' ,`ListPrice` = '709900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Greenbriar' ,`StreetNumber` = '709' ,`StreetSuffix` = 'Avenue' ,`City` = 'Friendswood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3742' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Friendswood ISD, circular drive, beautiful landscaping, and curb appeal. One-acre lot with big shade trees in the front & a spacious backyard. Wraparound porch, double paned windows, plantation shutters, wrought iron arched doorway, large formal dining room w two entry closets, kitchen has abundant cabinet storage, granite counter tops, plenty of light, and walk-in pantry. Wood paneled family room, a gas log fireplace, and mirrored glass display. Private ensuite w large bathroom w dual vanities, separate shower, soaking tub, and huge walk-in closet. Two secondary bedrooms upstairs, private home office w double French doors and entertainment room. Oversized 3 car garage extra storage and garage apartment includes full bathroom, tankless water heater, and utility room. Fully fenced back yard w sparkling heated pool & spa, large covered verandas, gas grill and ample green space. Dog run w dog house and deck, raised bed garden, carport, and automatic gate w extra parking.\r\nNever flooded!!!' ,`Acres` = '1.0938' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 151 S MCKISSICK SUR LOT 1 BLK 1 GREENBRIAR SUB SEC 1 &' ,`LotDesciption` = 'Other' ,`LotSize` = '47647' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Greenbriar 1' ,`TaxAmount` = '9042' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928791' WHERE `Matrix_Unique_ID` = '213450545' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:01:31.263' ,`MLSNumber` = '98552240' ,`ListAgentFullName` = 'Sapana Patel' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.541776' ,`Longitude` = '-95.564899' ,`PhotoCount` = '32' ,`PostalCode` = '77479' ,`RoomCount` = '11' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Plum Point' ,`StreetNumber` = '5614' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Open Floor Plan in sought after Riverstone. Zoned to New Elementary opening Fall 2023. It\'s located in a private cul-de-sac at dead end street with no neighbors on one side. Large 4 Bedrooms and 4 Full Bathrooms ( 3br downstairs & 1 upstairs); Bay Window in Primary Bedroom, Sunroom, Updated extended patio with outdoor kitchen and grill, natural gas piped to both outdoor cooktop and grill. The primarry bedroom plus 2 bedrooms, formal dining, sun room, breakfast abd the study are on the first floor; all bedrooms have en suite bathroom. Second floor game room, a media room and fourth bedroom with a full bath and a walk in closet. Plantation shutters throughout the house. Hard Wood & Tile floors. (Zoned to Anne Sullivan Elementary School) A must see!' ,`Acres` = '0.247' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEKSTONE VILLAGE AT RIVERSTONE SEC 6 PHASE II, BLOCK 2, LO' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SULLIVAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'CreekStone Village at Riverstone' ,`TaxAmount` = '11339' ,`TaxRate` = '2.5104' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928791' WHERE `Matrix_Unique_ID` = '213466906' --> 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','213505772','1665928791','213505772','2022-10-15T23:51:25.173','20888318','David Wyatt','Wyatt Real Estate','','','29.397840','-94.912705','22','77590','7','198500.00','Active','14th','1221','Avenue','Texas City','2','0','4','1559','Single-Family','Move in Ready! Four bedroom two bathroom, kitchen, dining room, living room, completely remodeled. Home has many other updates including newer windows in 2015, hardi plank exterior walls, AC Unit 2 stage hi-eff 18 seer, new insulation, mostly rewired, new pex plumbing, new concrete double driveway, separate exterior 50 Amp breaker for R.V., room dimensions approximate. Levee protected.','0.2187','33','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Texas City','Central Gas','0','ABST 205 PAGE 2 LOT 77 SUNSET TERRACE','Subdivision Lot','9528','Appraisal District','','','0','','1','Gas Oven','0','','','Gas Range','','Composition','52 - Texas City','KOHFELDT ELEMENTARY SCHOOL','TEXAS CITY HIGH SCHOOL','BLOCKER MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Sunset Terrace','3808','2.5335','Public Sewer,Public Water','1968','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T23:24:05.430' ,`MLSNumber` = '51744977' ,`ListAgentFullName` = 'Laura Crisp' ,`ListOfficeName` = 'Bob Peltier & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.167391' ,`Longitude` = '-95.442284' ,`PhotoCount` = '23' ,`PostalCode` = '77385' ,`RoomCount` = '12' ,`ListPrice` = '474900.00' ,`Status` = 'Active' ,`StreetName` = 'Laura' ,`StreetNumber` = '422' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '5615' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor Special...Amazing property at incredible deal!!!! LOTS OF POSIBILITIES! Over 5600 Square feet! This wonderful home has downstairs behind garage 2-bedroom 1 bath apartment/mother-in-law quarters has its own, entrance from outside, large kitchen, dining area and living room! Main part of house has 4 bedrooms upstairs, Primary Bedroom is huge with used as sitting area/ home office etc. Extra large living room, den and formal dining room downstairs.\r\n2 extra large game rooms each could be easily turned into own bedroom. The one over apt has its own entrance, al beautiful full bathroom and is used as 2nd master...add a Kitchen could be its own apt. Close to Woodlands Mall. \r\nBeautiful Well Maintained Pool+.' ,`Acres` = '0.2439' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'OAK RIDGE NORTH 10, BLOCK 8, LOT 37' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`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' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Oak Ridge North 10' ,`TaxAmount` = '9050' ,`TaxRate` = '2.461' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928791' WHERE `Matrix_Unique_ID` = '213511963' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T23:58:52.407' ,`MLSNumber` = '73639157' ,`ListAgentFullName` = 'Mario Calad' ,`ListOfficeName` = 'Turn Key Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.531218' ,`Longitude` = '-95.728458' ,`PhotoCount` = '17' ,`PostalCode` = '77469' ,`RoomCount` = '7' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Henrico' ,`StreetNumber` = '8611' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1670' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy being CLOSE TO IT ALL! This SUPER CUTE 3-4 home offers a functional floor-plan that is sure to have something for everyone! Enjoy big, open living areas w/soaring ceilings that are perfect for entertaining & a private study/4th bedroom! Upgrades include hard flooring throughout living areas, Hardwood flooring in master bedroom, ss appliances, an amazing master shower that is sure to WOW you, custom cabinets on master bath, Washer Dryer and Refrigerator Included & a wonderful, backyard w/extended patio (and no back neighbors!) that is the ideal space for your outdoor living area!' ,`Acres` = '0.1493' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BONBROOK PLANTATION SOUTH SEC 1, BLOCK 1, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6504' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonbrook Plantation South Sec 1' ,`TaxAmount` = '5659' ,`TaxRate` = '2.6948' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928792' WHERE `Matrix_Unique_ID` = '213516143' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T23:12:01.800' ,`MLSNumber` = '63309385' ,`ListAgentFullName` = 'Patricia Fleming' ,`ListOfficeName` = 'Patricia Fleming Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.893108' ,`Longitude` = '-95.645272' ,`PhotoCount` = '40' ,`PostalCode` = '77095' ,`RoomCount` = '12' ,`ListPrice` = '418800.00' ,`Status` = 'Active' ,`StreetName` = 'Villa Palms' ,`StreetNumber` = '7803' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2954' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNRIVALED EXCELLANCE! YOU WILL FALL IN LOVE W THIS MASTERPIECE HOME SITUATED ON A LARGE CORNER LOT IN THE SOUGHT AFTER COMMUNITY OF SOUTHDOWN ESTATES! THIS EXQUISITE HOME FEATURES UPDATES INCL YOUR OWN OUTDOOR OASIS W HEATED POOL, SPILLOVER SPA,SUNSHELF & TROPICAL WATERFALL*OWNERS LOVINGLY INVESTED OVER $100K IN CUSTOM UPDATES INCL:PEX RE-PLUMBING($7,000)*NEW ROOF(2020) NEW HVAC(2022) POOL PUMPS(2021)TOTAL PRIMARY BATH REMODEL($40,000) INCL FRAMELESS SHOWER,CUSTOM CABINETRY,MARBLE COUNTERS & SHOWER*LARGE WHIRLPOOL TUB*FLOORING*CUSTOM LIGHTING & FIXTURES*FULL KITCHEN REMODEL W CUSTOM CABINETRY*DESIGNER GRANITE ON ISLAND & ALL COUNTERS*2 WALK IN CLOSETS*WONDERFUL OPEN PLAN W DRAMATIC HIGH CIELINGS AT ENTRY*EXTRA LONG DRIVE & SETBACK DETACHED GARAGE*LOCATED IN THE HIGHLY ACCLAIMED CY-FAIR SCHOOL DISTRICT*EASY ACCESS TO HWY 290, I-10 & HWY 99*EXCELLENT DINING & SHOPPING MINUTES AWAY AS WELL AS SEVERAL WALKING/BIKING TRAILS, POOLS & PARKS*YOU WILL NOT WANT TO MISS OUT ON THIS OPPORTUNITY!' ,`Acres` = '0.2145' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 46 BLK 26 COPPERFIELD SOUTHDOWN VILLAGE SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9345' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`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` = 'Leave Business Card,Lockbox Front,No Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Copperfield Southdown Village' ,`TaxAmount` = '6413' ,`TaxRate` = '2.3216' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928792' WHERE `Matrix_Unique_ID` = '213537020' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T22:16:36.803' ,`MLSNumber` = '28844591' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.896332' ,`Longitude` = '-95.408395' ,`PhotoCount` = '35' ,`PostalCode` = '77037' ,`RoomCount` = '2' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Sweetwater' ,`StreetNumber` = '9242' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1339' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully remodeled 2+ bedroom 1 1/2 bath home with a pool & 20x40 shop that has 3 phase power! This home is light and bright with painted cabinets, SS appliances, and granite counter tops. Tile flooring throughout the main areas of the home with an open concept living. The backyard is spacious with an inground pool and 20x40 shop that has 3 phase power!' ,`Acres` = '0.3099' ,`Area` = '' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 163 BLK 10 NORTHLINE TERRACE SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '13500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '' ,`SchoolElementary` = '' ,`SchoolHigh` = '' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northline Terrace' ,`TaxAmount` = '2812' ,`TaxRate` = '2.1528' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928792' WHERE `Matrix_Unique_ID` = '213689104' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-15T23:47:52.690' ,`MLSNumber` = '69743520' ,`ListAgentFullName` = 'Bruce Palmquist' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.601700' ,`Longitude` = '-95.741661' ,`PhotoCount` = '46' ,`PostalCode` = '77406' ,`RoomCount` = '12' ,`ListPrice` = '738000.00' ,`Status` = 'Active' ,`StreetName` = 'Shadow Grove' ,`StreetNumber` = '515' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4544' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***OPEN HOUSE (SUNDAY 10/16 from 12-3 pm)! Beautiful 4 bedroom 3 full baths & 2 half baths sitting on over 1/2 acre in highly sought after Shadow Grove Estates! LOW Tax Rate!!! Completely updated inside and out! This one has it all - plantation shutters, solar screens, wood floors, tile floors, designer paint throughout, granite countertops, stainless steel appliances, two staircases (1 wrought iron), hidden room above primary bedroom(could be used as office/gym/extra storage), soaring ceilings, huge walk in pantry, formal living and dining, oversized bedrooms and closets, backyard oasis includes a gorgeous pool (with beach pebble stone entry) and spa, covered outdoor fireplace, covered outdoor kitchen, outdoor bathroom, and more! Plenty of extra yard space separate from the pool for all your entertaining needs! To many updates to mention! Come see, this one won\'t last!' ,`Acres` = '0.6437' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW GROVE ESTATES SEC 1, BLOCK 1, LOT 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '28040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Grove Estates' ,`TaxAmount` = '6870' ,`TaxRate` = '1.6948' ,`WaterSewer` = 'Other Water/Sewer,Septic Tank' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665928792' WHERE `Matrix_Unique_ID` = '213725121' --> 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','213727179','1665928792','213727179','2022-10-15T22:39:12.087','87548806','Joe La Torre Palomino','Red Door Realty & Associates','','','30.118218','-95.202998','18','77357','3','200000.00','Active','Carpenter Bee','24006','Drive','New Caney','2','0','3','960','Single-Family','Buyer/buyer\'s agent to verify room dimensions\r\nGive sellers an hour notice before showing \r\nFor quicker response and any other inquiries text/email agent\r\nIf seller pays for title policy:\r\nPatriot Tittle-The Woodlands at 2219 Sawdust Rd STE 803, The Woodlands, TX 77380\r\nEscrow agent Trisha Matthiews-tmatthews@patriottitletx.com','0.747','40','','','','','Sellers Disclosure','1','','','Porter/New Caney East','Central Gas','0','S952703 - WHITE OAK CROSSING 03, BLOCK 4, LOT 13','Corner','32540','Appraisal District','','','0','','0','','0','','','','','Composition','39 - New Caney','OAKLEY ELEMENTARY SCHOOL','NEW CANEY HIGH SCHOOL','NEW CANEY MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','White Oak Crossing','','','Public Sewer,Public Water','2016','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','213729755','1665928792','213729755','2022-10-15T22:28:55.550','43600253','Diana Power','Texas Power Real Estate','','','29.469180','-95.906697','50','77471','12','599000.00','Active','Engeling','2120','Road','Rosenberg','3','0','4','3630','Single-Family','This is the perfect country property, but close enough to Hwy 59 to get into Houston easily. This 5 acre property is great for kid\'s projects. Bring your FFA or 4-H animals. This home includes a 900 sq. ft. shop with an office built in. There is also a fenced in area around the loafing shed. This home features, wood floors in most of the downstairs, an office that could also be a 5th bedroom, large family style kitchen w/silestone counters & tons of cabinet space, oversized laundry room w/sink & more storage. The primary bedroom/bath is huge. You will also love the sitting area in the primary bedroom. You will also enjoy the media room/game room w/large balcony. This room includes ae sink & room for a kitchenette - great space for family nights. The sellers have added extra concrete out back and great walkways in the yard. This property comes with a bonus hot tub on the back porch. There are beautiful oaks on the yard, but room to run horses. Come see what the country has to offer.','5','30','','','Electric Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','Freestanding,Wood Burning Fireplace','1','','Central Electric','0','0249 H AND TC RY, TRACT B, ACRES 5.00','Other,Wooded','217800','Appraisal District','','','0','','2','Freestanding Oven,Single Oven','0','','','Electric Range,Freestanding Range','','Composition','38 - Needville','NEEDVILLE ELEMENTARY SCHOOL','NEEDVILLE HIGH SCHOOL','NEEDVILLE JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Lockbox Left Side,Supra Keybox','Appraisal District','2','Traditional','Engeling Subdivision','8331','1.9957','Septic Tank,Well','2000','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','213732208','1665928793','213732208','2022-10-15T23:09:06.317','7688807','Dehong Marchtaler','RE/MAX Eastside','','','30.474620','-95.676147','28','77356','0','129999.00','Active','Oak','15736','Drive','Montgomery','1','0','2','648','Single-Family','Investor/handy man project at a peaceful beautiful community. House is walking distance to local lake. 2bd 1ba with a big well-built 40x40 shop that has power already. Some elbow grease and sweat can turn this gem to a making Airbnb (neighbor has Airbnb housings) or a nice county living house. Close to Lake Conroe and the city of Montgomery, perfect location for shopping dining and fishing! There are 3 brand new building were erected recently which will help to bring up this house\'s future market value. House is fenced up.','0.225','39','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','','','Lake Conroe Area','Central Electric','0','HIDDEN FOREST EST 01, LOT 147','Cleared,Corner','9800','Appraisal District','','','0','','0','','0','Gunite','','','','Composition','37 - Montgomery','LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Back,Vacant/Unoccupied','Appraisal District','1','Traditional','Hidden Forest Estate 01','873','1.8242','Public Sewer,Public Water','1960','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','213733321','1665928793','213733321','2022-10-15T22:47:15.150','69532479','Robert Findley','Realty Insight','','','30.191050','-95.153662','36','77372','7','264900.00','Active','Long Street','0','','Splendora','3','0','5','2001','Single-Family','Come see this very roomy 5 bed 3 bath 2001 square foot manufactured home on 0.9 of an acres in Splendora. Great location to raise a family. Minutes from Grand Parkway and Valley Ranch.','0.9183','40','CMH Homes, Inc.','','','','No Disclosures','','','','Porter/New Caney East','Central Electric','0','LAKELAND CLUB 03, BLOCK 1, LOT 39, ACRES 0.920','Subdivision Lot','40000','Appraisal District','','','1','To Be Built/Under Construction','0','','0','','','','','Composition','47 - Splendora','TIMBER LAKES ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Appointment Required,Lockbox Front','Builder','1','Traditional','Lakeland Club 03','317','2.3341','Public Water','2022','Builder'); --> New record created successfully