Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:00:31.403' ,`MLSNumber` = '33729100' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.436965' ,`Longitude` = '-95.671965' ,`PhotoCount` = '13' ,`PostalCode` = '77356' ,`RoomCount` = '2' ,`ListPrice` = '132999.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeway' ,`StreetNumber` = '20087' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '866' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this adorable one-story home located in Montgomery. 2 bedrooms and 1 bathroom perfect for you and your family. This home just received a new look and a new roof. The interior and exterior boasts fresh paint. As you walk in through the front door, you are greeted by new ceramic tile flooring throughout the living area. Lots of windows to let the outdoors in. Full bathroom with great updates. Spacious bedrooms with new carpet for you to relax in. Conveniently located by FM 149, close to the National Forest, with the recent opening of Margaritaville on Lake Conroe, the upcoming Yogi Bear\'s Jellystone Camp, Lake Conroe hot spots, and the Walden Golf Course there\'s no shortage of fun things to do!' ,`Acres` = '0.1343' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'No Heating,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'FOREST WOODS, BLOCK 4, LOT 154' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Woods' ,`TaxAmount` = '567' ,`TaxRate` = '1.9139' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705917' WHERE `Matrix_Unique_ID` = '189392767' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:19:34.933' ,`MLSNumber` = '7115605' ,`ListAgentFullName` = 'Heidi May' ,`ListOfficeName` = 'Leyco Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.760264' ,`Longitude` = '-96.658075' ,`PhotoCount` = '29' ,`PostalCode` = '78934' ,`RoomCount` = '9' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Shaws Bend' ,`StreetNumber` = '1396' ,`StreetSuffix` = 'Road' ,`City` = 'Columbus' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2424' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Classic Country Living in a beautiful custom home! Enter from the breezeway into your light and bright white kitchen with built-in breakfast table next to your over sized utility room with sink. Living room and dining room have country finishes and are wide open with sliding doors over looking covered porch, large backyard, and deer proofed garden. Office off the living room is a perfect place to work from home or turn into an additional bedroom. 2 Secondary bedrooms have built-in desks and oversized closets. Owners retreat has a large sitting room, with closet, bath with shower and nice sized closets. There are 4 with a possible 5 bedrooms and so many possibilities. On over 2 acres with creek access this home has it all!' ,`Acres` = '2.134' ,`Area` = '56' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A-29 W HUNT 2.000 AC HOUSE & GARAGE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '188 - Columbus' ,`SchoolElementary` = 'COLUMBUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLUMBUS HIGH SCHOOL' ,`SchoolMiddle` = 'COLUMBUS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Shaws Bend' ,`TaxAmount` = '3198' ,`TaxRate` = '1.5459' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705918' WHERE `Matrix_Unique_ID` = '205501507' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T11:00:35.683' ,`MLSNumber` = '8226162' ,`ListAgentFullName` = 'Pamela Lamoureux' ,`ListOfficeName` = 'Daybreak Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.020832' ,`Longitude` = '-98.010260' ,`PhotoCount` = '44' ,`PostalCode` = '78676' ,`RoomCount` = '6' ,`ListPrice` = '999999.00' ,`Status` = 'Active' ,`StreetName` = 'Windmill' ,`StreetNumber` = '1001' ,`StreetSuffix` = 'Run' ,`City` = 'Wimberley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2422' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COOL off in the shared private Blanco River Park, also new A/C installed June 2022. Coveted river Mountain Ranch, 5.34 acres,with many beautiful oaks, elms and other native hardwoods surrounding this custom home with abundant wildlife. AG EXEMPT for lower taxes. Home is secluded and private, over 300’ on circular driveway; high ceilings, dining, office, gourmet kitchen, sit around the bar visiting with the Chef. Primary on main with additional fireplace. Upstairs, 10’x15’ sitting loft, a bedroom suite with full bath plus a bonus/flex (“secret”) room that can be instantly made into another bedroom. Great outside spaces including: a covered porch with gas fire-pit and stained redwood deck; another natural fire-pit sitting area next to a 6 person Dimensions One spa surrounded by a stained redwood deck with another covered sitting area; a 12\'x24\' Kayak sports pool with aluminum decking and attached 3\' tall safety fence. Chicken coup/enclosed garden space behind the house. \r\nHorses Allowed.' ,`Acres` = '5.336' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'RIVER MOUNTAIN RANCH SEC 1, LOT 27, ACRES 5.336' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '47916' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '183' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '121 - Hays Consolidated' ,`SchoolElementary` = 'JACOB\'S WELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WIMBERLEY HIGH SCHOOL' ,`SchoolMiddle` = 'DANFORTH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'River Mountain Ranch Sec 1' ,`TaxAmount` = '5931' ,`TaxRate` = '1.668' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705918' WHERE `Matrix_Unique_ID` = '205766480' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:25:53.090' ,`MLSNumber` = '4002001' ,`ListAgentFullName` = 'Andrea Dadinis' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.815095' ,`Longitude` = '-95.521360' ,`PhotoCount` = '50' ,`PostalCode` = '77080' ,`RoomCount` = '9' ,`ListPrice` = '1995000.00' ,`Status` = 'Active' ,`StreetName` = 'Bauer' ,`StreetNumber` = '2316' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6588' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully renovated home in the heart of Spring Branch! No detail has been overlooked! This unique one of a kind home sits on an oversized 25,244 sq ft lot has 5 bedrooms and 4 1/2 baths. Custom cabinets throughout, solid wood interior doors, iron exterior doors, custom fence and so much more. This home is a car lovers dream with 2 air conditioned garages and 11 total spots including custom lifts. Second garage is over 5000 sq ft, with large storage room, half bath, gym, large built in safe with A/C, media room, and a 1 bedroom garage apartment with amazing covered patio. Enjoy your resort style backyard year round! Custom heated pool with slide, water feature, custom lighting, fire pots, and hot tub. Huge covered outdoor kitchen with built in grill, sink, fireplace, TV, AC and heat. Outdoor oasis also includes large wood burning fireplace, top of the line artificial grass, gas lanterns and paver driveway. 70 KW whole home Generac Generator. This home has it all!' ,`Acres` = '0.5795' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '5' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 27 & 28 BLK 5 SPRING BRANCH ESTATES SEC 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '25244' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '20' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '11' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'BUFFALO CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Branch Estates Sec 02' ,`TaxAmount` = '24415' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705918' WHERE `Matrix_Unique_ID` = '206958519' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:04:35.120' ,`MLSNumber` = '18471577' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = 'Arturo Arredondo' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.657253' ,`Longitude` = '-95.118145' ,`PhotoCount` = '39' ,`PostalCode` = '77505' ,`RoomCount` = '17' ,`ListPrice` = '599990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Leighton' ,`StreetNumber` = '7819' ,`StreetSuffix` = 'Trail' ,`City` = 'Pasadena' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3577' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready to move-in! Charming two-story Millie home with 4 bedrooms, 3.5 baths and 2 car attached garage with storage. Convenient home office and open dining room tucked off foyer. Beautiful maple cabinets, granite countertops and walk-in pantry in gourmet kitchen. From the sunroom, you can access the covered patio. Cozy stone fireplace with cedar mantel and raised hearth in great room. Owner\'s suite features a sitting room, perfect as an extra office space or workout area. Huge walk-in closet, dual vanity sinks, separate tub and shower in owner\'s bath. Upstairs, you\'ll find a media room with storage closet. All secondary bedrooms feature walk-in closets and connecting baths. Offered by: K. Hovnanian Houston Parkway Trails, LLC.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '5/3/4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8450' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkway Trails' ,`TaxAmount` = '' ,`TaxRate` = '2.6198' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705918' WHERE `Matrix_Unique_ID` = '207322327' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:55:22.220' ,`MLSNumber` = '87028097' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.836150' ,`Longitude` = '-95.863745' ,`PhotoCount` = '25' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '347750.00' ,`Status` = 'Active' ,`StreetName` = 'Marisol Bay' ,`StreetNumber` = '900' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1636' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 87028097 - Built by HistoryMaker Homes - Ready Now! ~ Light, bright, and open one-story with lots of energy-efficient windows and spacious, functional, combined kitchen/dining space. Large primary bedroom with spacious bath and large walk-in closet' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 47 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5715' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705918' WHERE `Matrix_Unique_ID` = '207612305' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:04:41.687' ,`MLSNumber` = '19730277' ,`ListAgentFullName` = 'Nathan Haley' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.681112' ,`Longitude` = '-95.255248' ,`PhotoCount` = '12' ,`PostalCode` = '77017' ,`RoomCount` = '6' ,`ListPrice` = '232000.00' ,`Status` = 'Active' ,`StreetName` = 'Elrod' ,`StreetNumber` = '8410' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '1890' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nicely remodeled duplex. New paint, flooring, ceiling fans, stainless-steel appliances, remodeled bathrooms, and all new fixtures throughout the home. Nice large backyard with new landscaping.' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 15 SAM HOUSTON GARDENS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BONNER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'CHAVEZ HIGH SCHOOL' ,`SchoolMiddle` = 'STEVENSON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sam Houston Gardens' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705918' WHERE `Matrix_Unique_ID` = '207785631' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:22:56.577' ,`MLSNumber` = '6823578' ,`ListAgentFullName` = 'Heidi May' ,`ListOfficeName` = 'Leyco Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838582' ,`Longitude` = '-96.704649' ,`PhotoCount` = '23' ,`PostalCode` = '78938' ,`RoomCount` = '3' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Fordtrandt' ,`StreetNumber` = '405' ,`StreetSuffix` = 'Street' ,`City` = 'Ellinger' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UPDATED PRICING! WITH A POOL Country home with covered porches on the front and back, has so much character with little bridge walk-way to the front door. Back porch overlooks stylish rectangle shaped pool with easy to maintain landscaping. Pool side has half bath for easy changing and pool parties. Stunning Country Cottage has old world feel with so many modern touches: Large pantry, built-in seating for dining, over-sized laundry room, large closets, primary bath with Tub and separate shower, beautiful wood floors, and so much more. House is built on the left side of the 5 lots and there is plenty of room to build another home/or guest house. Large workshop has French doors to oversized steel carport that could be a mancave or she-shack, or a guest quarters. Grounds have great pre-existing plants such as paper-shell pecan tree, grape vines, some fruit trees, and has had an amazing garden in the past. Lots of room to make it how you want it.' ,`Acres` = '0.4821' ,`Area` = '69' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ELLINGER (370) LOT 6,7,8,9,10 BLK 21 .4821 150 X 140 = 21,00' ,`LotDesciption` = 'Corner' ,`LotSize` = '21000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '205 - La Grange' ,`SchoolElementary` = 'HERMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA GRANGE HIGH SCHOOL' ,`SchoolMiddle` = 'LA GRANGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman,Traditional,Victorian' ,`Subdivision` = 'Ellinger 370' ,`TaxAmount` = '2661' ,`TaxRate` = '1.6209' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705918' WHERE `Matrix_Unique_ID` = '208192283' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:07:05.160' ,`MLSNumber` = '40001174' ,`ListAgentFullName` = 'Linda Hale' ,`ListOfficeName` = 'TX Lake & Land Re Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.238179' ,`Longitude` = '-96.017478' ,`PhotoCount` = '37' ,`PostalCode` = '75148' ,`RoomCount` = '5' ,`ListPrice` = '4700000.00' ,`Status` = 'Active' ,`StreetName` = 'Ridge' ,`StreetNumber` = '14150' ,`StreetSuffix` = 'Lane' ,`City` = 'Malakoff' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4856' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you are looking for a retreat with tons of privacy and lots of accommodations then this would be worth taking a look at. The main entrance is in a gated neighborhood with a gate at the entrance to the property as well. The driveway winds through the land left natural with lots of trees to provide the privacy. This property features a main house with 5 bedrooms and 4.5 baths, a guest house with 2 bedrooms and 1 bath and a bunk house with 2 bedrooms and 1 bath.This property is on 12 plus acres with access from 2 different streets. The main house has a wall of windows overlooking the pool and the lake. There is an abundance of outside entertaining areas with lots of porch space, an outdoor kitchen area, a pool with large deck space, a manmade creek with water from lake runs by the pool, outdoor fire pit by the water, as well as a boat house with a 2nd story party deck. The main house is separate from the other two structures. There are too many extras to list them all here.' ,`Acres` = '5.327' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ACRES: 5.327 LOT: TR 50B AB 133 T CARO SUR TR 50B (IDLEWOOD' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '232044' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '503 - Eustace' ,`SchoolElementary` = 'EUSTACE PRIMARY SCHOOL' ,`SchoolHigh` = 'EUSTACE HIGH SCHOOL' ,`SchoolMiddle` = 'EUSTACE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Idlewood Bay' ,`TaxAmount` = '19439' ,`TaxRate` = '1.8266' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705918' WHERE `Matrix_Unique_ID` = '208277374' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:05:30.640' ,`MLSNumber` = '56496262' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.492608' ,`Longitude` = '-95.386226' ,`PhotoCount` = '5' ,`PostalCode` = '77578' ,`RoomCount` = '10' ,`ListPrice` = '674990.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Creek' ,`StreetNumber` = '5610' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3651' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Shea Homes 5049 Plan. Beautiful 2-story stucco exterior, 3-car garage, with 5 bedrooms, 4 baths! 2 Bedrooms down. 19\' Ceiling at Dining and Great Room. Luxury vinyl plank flooring throughout, with plush carpet only in bedrooms and tile in the laundry room and bathrooms. The kitchen boasts a built-in oven and microwave tower, a 5-burner gas cooktop and an oversized island with granite countertop. Primary suite has a bay window, a very generous walk-in closet, double sinks, an oversized Baja shower. Study enclosed with French doors. And, saving the best for last, a stacking sliding door opens up your Dining and Great Room to the oversized outdoor living area that wraps around the home, with an entertainment bar featuring a pass through window! Upstairs has unbelievable, generously-sized bedrooms, 2 baths, game room and media room pre-wired for 7.1 SS. Come live the difference in this thriving community!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5, Block 1, Section 7' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '9533' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,French' ,`Subdivision` = 'Del Bello Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.73944' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705919' WHERE `Matrix_Unique_ID` = '209022902' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:04:28.117' ,`MLSNumber` = '81481438' ,`ListAgentFullName` = 'Alan Go' ,`ListOfficeName` = 'Midland Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.564423' ,`Longitude` = '-95.710903' ,`PhotoCount` = '27' ,`PostalCode` = '77469' ,`RoomCount` = '13' ,`ListPrice` = '438000.00' ,`Status` = 'Active' ,`StreetName` = 'Spur Canyon' ,`StreetNumber` = '2111' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4075' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous home in Riverpark features 5 bedrooms and 3.5 baths with a 3 car garage. Kitchen offers an open concept that opens into the living room and contains a large island. Master bedroom is located on the first floor with windows facing the backyard. The backyard contains a covered patio and your own in ground pool! The upstairs contains all your secondary bedrooms and a large media room! Home is located close to freeway 59 and 99! Come see this home today!' ,`Acres` = '0.1981' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERPARK WEST SEC 8, BLOCK 2, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8629' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUTCHISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverpark West Sec 8' ,`TaxAmount` = '9799' ,`TaxRate` = '2.8748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705919' WHERE `Matrix_Unique_ID` = '209954343' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:40:13.653' ,`MLSNumber` = '80879210' ,`ListAgentFullName` = 'Kelly Jackson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.600210' ,`Longitude` = '-95.693452' ,`PhotoCount` = '47' ,`PostalCode` = '77479' ,`RoomCount` = '10' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Margate' ,`StreetNumber` = '4223' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2599' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Handsome 2 Story on a tree lined street in New Territory! Fussy Buyers will love this spacious 5 Bedroom, 2.5 bath home. Conveniently located close to schools, expressways and shopping, this home is move in ready. Greet guests in the 2 story foyer with maintenance free wood laminate floors that extend throughout the home. The updated kitchen is perfect for the home chef with granite counters, stainless appliances, center island, pantry closet and sunlit breakfast area. The kitchen overlooks with spacious family room/den with fireplace. Formal living and dining areas, and laundry room complete the main level. Upstairs features and roomy owners suite with walk in closet and en suite bath. The secondary bedrooms are ample sized. Host private gatherings in the fenced yard with patio. This community has tons of amenities, including pool, clubhouse, walking trails and more.' ,`Acres` = '0.1326' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HIGH MEADOWS, BLOCK 1, LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BRAZOS BEND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'SARTARTIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'High Meadows' ,`TaxAmount` = '6335' ,`TaxRate` = '2.4394' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705919' WHERE `Matrix_Unique_ID` = '210057154' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:13:57.447' ,`MLSNumber` = '13153297' ,`ListAgentFullName` = 'Nolan Obey' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.352922' ,`Longitude` = '-94.177915' ,`PhotoCount` = '29' ,`PostalCode` = '77656' ,`RoomCount` = '2' ,`ListPrice` = '140000.00' ,`Status` = 'Active' ,`StreetName` = '6th' ,`StreetNumber` = '555' ,`StreetSuffix` = 'Street' ,`City` = 'Silsbee' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1152' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 bedrooms, 2 baths remodeled home in a great location! This home offers spacious rooms that are completely upgraded with new flooring, carpet, paint, fans and much more. This is a great starter home or the perfect property if you are looking to downsize. Schedule your showing today and make this property yours!' ,`Acres` = '0.18' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 14 & PART OF 13 BLK 79 SANTA FE TOWNSITE P# S47-79-7 I#' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7841' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '252 - Silsbee' ,`SchoolElementary` = 'SILSBEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SILSBEE HIGH SCHOOL' ,`SchoolMiddle` = 'EDWARDS-JOHNSON MEMORIAL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe Townsite' ,`TaxAmount` = '1513' ,`TaxRate` = '2.3756' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705919' WHERE `Matrix_Unique_ID` = '210059893' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:12:57.840' ,`MLSNumber` = '67958188' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800977' ,`Longitude` = '-95.850589' ,`PhotoCount` = '50' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '532000.00' ,`Status` = 'Active' ,`StreetName` = 'Cartesian' ,`StreetNumber` = '2306' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2691' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New 2-story David Weekley Home in Cane Island!.  Stunning exterior on this 2-story 4 bedroom, 3 ½ bath home.  The open kitchen features a large island white cabinets, cooktop and wall oven and overlooks the family room.  Enjoy family night by the family room fireplace with towering ceilings.  Enjoy family meals in the single dining area. Large outdoor living patio is great for family cookouts.  The Owner’s Retreat has plenty of space for your furniture and features a super shower and large walk-in closet.  Three additional bedrooms upstairs with two full baths.  Large retreat area for game or movie night.  Balcony overlooks the family room.  2-car garage with extra storage space.  2691 sq. ft.  Three year energy usage guarantee for heating and cooling with Environments for Living Diamond.  KISD schools.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 02 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.45' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705919' WHERE `Matrix_Unique_ID` = '210075032' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T11:47:11.873' ,`MLSNumber` = '46033646' ,`ListAgentFullName` = 'Mark Dimas' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.033275' ,`Longitude` = '-95.502363' ,`PhotoCount` = '50' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '324900.00' ,`Status` = 'Active' ,`StreetName` = 'Franklin Park' ,`StreetNumber` = '18302' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2481' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 2 story home in a cul-de-sac in a gated community! 3 bedrooms, 2 full baths, neutral paint, ceiling fans, attached 2-car garage, and tile, carpet & hardwood flooring! The 1st floor offers a formal dining room with chair rail moldings, living room with fireplace, in-house utility room, and half bath! The eat-in kitchen features solid surface countertops, tile backsplash, breakfast bar, and recessed lighting! The primary bedroom boasts crown molding and an en-suite bath with separate sinks, vanity, soaking tub, separate shower, and two separate walk-in closets! Upstairs opens to a gameroom, 2 secondary bedrooms, and a full bath! The backyard features a modest patio! This home is located in the Spring Creek Oaks subdivision near numerous parks and restaurants! Zoned to Klein ISD! Within proximity to I-45, Hwy-249, TX-99, & Beltway 8!' ,`Acres` = '0.1852' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 42 BLK 1 SPRING CREEK OAKS PATIO HOMES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8069' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KUEHNLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Creek Oaks Patio Homes' ,`TaxAmount` = '6338' ,`TaxRate` = '2.5965' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705919' WHERE `Matrix_Unique_ID` = '210211482' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:14:45.557' ,`MLSNumber` = '90117684' ,`ListAgentFullName` = 'Carla Melendez' ,`ListOfficeName` = 'The Yarborough Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.683866' ,`Longitude` = '-95.484997' ,`PhotoCount` = '21' ,`PostalCode` = '77096' ,`RoomCount` = '3' ,`ListPrice` = '332000.00' ,`Status` = 'Active' ,`StreetName` = 'Jason' ,`StreetNumber` = '5510' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1536' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this lovely home that has been renovated and has a completely new look! 3 Bedroom 2 Bath home that sits in a cul de sac. Home is minutes away from the Galleria, Downtown and the Texas Medical Center. Walking distance From Herod Elementary School. Home has been completely remodeled. List of some of the upgrades include.. New windows, New exterior and interior doors, New cabinets, New Air ducts, electric panel and rewiring of the home, new siding, appliances, attic insulation, Quartz countertops, New showers and much more. Home comes with a lifetime foundation warranty that is transferable. Schedule to see this lovely home today!' ,`Acres` = '0.1638' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 5 NORWOOD MEADOWS' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7137' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection 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` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Norwood Meadows' ,`TaxAmount` = '6407' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705919' WHERE `Matrix_Unique_ID` = '210229435' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:27:39.823' ,`MLSNumber` = '16650444' ,`ListAgentFullName` = 'Stephanie Neumann' ,`ListOfficeName` = 'O\'Hara & Company Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.058712' ,`Longitude` = '-95.723837' ,`PhotoCount` = '36' ,`PostalCode` = '77377' ,`RoomCount` = '6' ,`ListPrice` = '440000.00' ,`Status` = 'Active' ,`StreetName` = 'Pacers Gait' ,`StreetNumber` = '19414' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1984' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Beautiful 3 Bedroom, 2 Bathroom + Office/Study Home truly has it all! Recently installed Wood-like Tile Flooring throughout Entire Home. Open Concept Floor Plan, Granite Countertops in Kitchen with Cabinets to Ceiling and PLENTY of them! Covered Back Patio with Great-Sized Backyard including Front & Back Sprinkler System! Water Filtration System recently installed. Come take a look at this gorgeous home!!' ,`Acres` = '0.1343' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 AMIRA SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira Sec 4' ,`TaxAmount` = '5970' ,`TaxRate` = '3.4925' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705920' WHERE `Matrix_Unique_ID` = '210266720' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T11:00:54.607' ,`MLSNumber` = '71496069' ,`ListAgentFullName` = 'Sherry Hickman Wray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Karen Seale' ,`SellingOfficeName` = 'Etheredge Real Estate' ,`Latitude` = '29.394171' ,`Longitude` = '-94.894402' ,`PhotoCount` = '42' ,`PostalCode` = '77590' ,`RoomCount` = '8' ,`ListPrice` = '264900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = '10th' ,`StreetNumber` = '19' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Need Space? This 3 bed/3 bath beauty has 2800 sq feet of living space. Great location-just a few minute walk to Rainbow Park and scenic Skyline Drive. It is also only a few minute drive to the popular Texas City Dyke recreation area. Enter the front door to formal living on the right and formal dining on the left. Then into the kitchen with lots of counter and cabinet space. Next is the huge family room which could be used for almost anything! Currently used as the family room and additional dining next to the cozy fireplace. All bedrooms feature laminate wood-look floors. This home offers lots of storage space throughout. Not pictured in the photos is the enormous inside 20x6 storage room. It has drawers, shelves, hanging space and a work/desk area. Lots of parking space. The oversized garage has an extra storage room and there is also a front driveway. The back yard is fenced with covered patio. The front yard includes an additional open patio area to enjoy the lovely landscaping.' ,`Acres` = '0.251' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 205 J WELLS SUR LOTS 6 THRU 8 & E 1/2 LOT 5 BLK 348 TEX' ,`LotDesciption` = 'Cleared' ,`LotSize` = '10933' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'ROOSEVELT-WILSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Texas City' ,`TaxAmount` = '4300' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705920' WHERE `Matrix_Unique_ID` = '210340886' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T11:18:54.207' ,`MLSNumber` = '61493496' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.211148' ,`Longitude` = '-95.329843' ,`PhotoCount` = '9' ,`PostalCode` = '77302' ,`RoomCount` = '9' ,`ListPrice` = '389949.00' ,`Status` = 'Active' ,`StreetName` = 'Vino Vines' ,`StreetNumber` = '17423' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2041' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning home greets you with a stunning elevation. Featuring an open concept design, this home is ideal for entertaining. Entering through the foyer, you will be led into the casual dining area overlooking the gourmet kitchen featuring omega stone countertops. The chef of the family will enjoy preparing everyone’s favorite dishes in the kitchen equipped with a spacious island. Complete with a secondary bedroom with full bath situated on the first floor, this home has it all. Come see this spectacular home today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 10 BLOCK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5194' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705920' WHERE `Matrix_Unique_ID` = '210404079' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:02:43.630' ,`MLSNumber` = '21958593' ,`ListAgentFullName` = 'April Vera' ,`ListOfficeName` = 'Century 21 Olympian LakeJackson' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.065239' ,`Longitude` = '-95.415763' ,`PhotoCount` = '20' ,`PostalCode` = '77531' ,`RoomCount` = '5' ,`ListPrice` = '194500.00' ,`Status` = 'Active' ,`StreetName` = 'Wisteria' ,`StreetNumber` = '317' ,`StreetSuffix` = 'Street' ,`City` = 'Richwood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1759' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This updated brick home is in the heart of Richwood. Everyone could enjoy this home, with 4 bedrooms and 2 full bathrooms. There is laminate and tile flooring throughout, with no carpet. In the kitchen there are GE appliances, wood cabinetry with soft-close drawers and granite counter tops. There are two living areas and one has a brick fireplace and focal wall. Out the double back doors, you can enjoy the covered and screened-in patio. Perfect for family bar-b-ques. This home also has newer windows, a 2 car attached garage and a double wide driveway. Call for your private showing today!' ,`Acres` = '0.2011' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Real Estate Owned' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Richwood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'GLENWOOD BAYOU (A0066 J E GROCE)(RICHWOOD), BLOCK 16, LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'POLK ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Glenwood Bayou' ,`TaxAmount` = '3359' ,`TaxRate` = '2.6504' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705920' WHERE `Matrix_Unique_ID` = '210428250' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T11:25:15.500' ,`MLSNumber` = '19353935' ,`ListAgentFullName` = 'James Simpson' ,`ListOfficeName` = 'Jim Simpson Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.775394' ,`Longitude` = '-95.414583' ,`PhotoCount` = '14' ,`PostalCode` = '77007' ,`RoomCount` = '9' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Inker' ,`StreetNumber` = '5221 b' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2654' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 story with small fenced yard. No Maintanance fee..Freshly painted.Rice military area. Close to Downtown Easy to show.Showings Begin Wed.the 27th of July' ,`Acres` = '0.0617' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 124 COTTAGE GROVE SEC 1' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2688' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cottage Grove Sec 01' ,`TaxAmount` = '9436' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705920' WHERE `Matrix_Unique_ID` = '210653461' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T11:42:15.617' ,`MLSNumber` = '84215688' ,`ListAgentFullName` = 'Carol Drake' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = 'Melissa Cain' ,`SellingOfficeName` = 'Keller Williams Advtge Realty' ,`Latitude` = '30.297592' ,`Longitude` = '-95.794945' ,`PhotoCount` = '49' ,`PostalCode` = '77316' ,`RoomCount` = '9' ,`ListPrice` = '785000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Windermere' ,`StreetNumber` = '4401' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3132' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Picture perfect! Stunning ranch style hacienda, completely designed as a one of a kind home. Ideal design for a lifestyle of living indoors & out! Main house 3, 2 1/2 bath, Casita like no other, 1 bedroom w/ sitting area, full en-suite primary style bath & courtyard patio to enjoy. A gourmet cooks delight kitchen w/ 6 burner stove, double ovens & workspace perfect preparation space. Owner suite w/ warm cozy fireplace, private courtyard entrance to the courtyard & private outdoor fireplace. Courtyard living as a part of the lifestyle w/ wonderful outdoor living, landscaped w/ water feature & covered space to enjoy private time. Additional space for outdoor entertainment w/covered outdoor dining/entertaining area hosting a perfectly appointed outdoor kitchen, fire feature. Whole house & Casita Generac Generator. Kitchen & primary bath newly painted. New main house A/C 4/2022. New outdoor kitchen grill 5/2022. Whole house central vac.' ,`Acres` = '1.183' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S357400 - CROWN RANCH 01, BLOCK 2, LOT 25' ,`LotDesciption` = 'Corner' ,`LotSize` = '51531' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Spanish' ,`Subdivision` = 'Crown Ranch' ,`TaxAmount` = '8956' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705920' WHERE `Matrix_Unique_ID` = '210816713' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T11:53:18.737' ,`MLSNumber` = '44107096' ,`ListAgentFullName` = 'Arturo Pena' ,`ListOfficeName` = 'Hardee & Company Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.391281' ,`Longitude` = '-94.941347' ,`PhotoCount` = '35' ,`PostalCode` = '77327' ,`RoomCount` = '8' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2184' ,`StreetNumber` = '2069' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious Tarkington Barndo located on 7.3 high and dry acres. This home has a versatile, open floor plan with four dedicated bedrooms and a fifth room that could be a home office, gym, or another bedroom. The living, dining and kitchen are all open concept with recessed lighting and large windows for natural lighting and tile flooring for easy maintenance. The kitchen has many features including an island with an apron sink and quartz countertops, a backsplash that provides a pop of color and beautiful light fixtures. There is also a wet bar with a wine fridge located next to the large corner pantry. The primary bedroom is spacious with a huge primary bathroom including separate shower and tub. Venture outside and enjoy sitting amongst the trees on the large concrete patio. There is enough land to grow your own vegetables or fence for farm animals and chickens. If you have been looking to escape to the country and still be within 15 minutes of town, then this homestead is for you!' ,`Acres` = '7.3914' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000345 F J C SMILEY, TRACT 133, ACRES 7.3914, MH LABEL# TEX1' ,`LotDesciption` = 'Other' ,`LotSize` = '321969' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'TARKINGTON PRIMARY SCHOOL' ,`SchoolHigh` = 'TARKINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'TARKINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Barndominium' ,`Subdivision` = 'F J C Smiley' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705920' WHERE `Matrix_Unique_ID` = '210834833' --> 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','210917335','1663705921','210917335','2022-09-02T11:30:57.680','52984737','Aaron Jistel','Listing Spark','','','29.499704','-94.992051','3','77518','7','120000.00','Active','18th','4619','Street','Bacliff','1','0','3','934','Single-Family','Fixer upper sold in as-is condition.','0.0861','33','','','','','Sellers Disclosure','','','','Bacliff/San Leon','Central Electric','0','ABST 164 E PAYNE SUR SE 50 FT OF LOTS 13,14 & 15 (14-1) BLK','Other','3750','Appraisal District','','','0','','0','','0','','','','','Composition','17 - Dickinson','KENNETH E. LITTLE ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','DUNBAR MIDDLE SCHOOL (DICKINSON)','No Supra Keybox','Appraisal District','1','Traditional','Clifton By The Sea','2435','2.2342','Water District','2004','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T11:06:29.487' ,`MLSNumber` = '85076458' ,`ListAgentFullName` = 'Jack Lipar' ,`ListOfficeName` = 'LGI Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.441055' ,`Longitude` = '-95.751433' ,`PhotoCount` = '8' ,`PostalCode` = '77469' ,`RoomCount` = '9' ,`ListPrice` = '330900.00' ,`Status` = 'Active' ,`StreetName` = 'Tipton Meadow' ,`StreetNumber` = '7311' ,`StreetSuffix` = 'Way' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1957' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING AND SPACIOUS NEW HOME WITH UPGRADES INCLUDED! This two-story home features an open floor plan with three bedrooms two full bathrooms plus a powder bath. The chef-ready kitchen includes a full suite of appliances by Whirlpool, including a refrigerator and built-in microwave, granite countertops and espresso-stained wood cabinets topped with crown molding. Windows in the spacious family room and dining room overlook the back patio and fenced back yard. Owners will enjoy the luxuriously large owner’s suite upstairs with two walk-in closets and a spa-like bathroom with step-in shower, soaker tub, spacious vanity and linen storage. The two secondary bedrooms are generously sized and include desirable closet space, providing plenty of room for your family, work and hobbies. Tour this home and the incredible Vacek Country Meadows community today!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'LGI Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'VCM L2 BL4 Sec2 of Vacek Country Meadows' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Vacek Country Meadows' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705921' WHERE `Matrix_Unique_ID` = '210939800' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T11:20:33.500' ,`MLSNumber` = '78477606' ,`ListAgentFullName` = 'Margaret Lindow' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.208936' ,`Longitude` = '-93.725402' ,`PhotoCount` = '38' ,`PostalCode` = '75948' ,`RoomCount` = '8' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Front' ,`StreetNumber` = '348' ,`StreetSuffix` = 'Drive' ,`City` = 'Hemphill' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '1328' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A-Frame home on 4 large lots with a Cove that leads to Toledo Lake-in your Back Yard, 278’ of Waterfront- Leased back property. Boat shed, Storage Buildings, Outside Kitchen & Bath. Large 20 x 16 wooden Deck Upstairs, Native Trees everywhere you look. RV Spot w/ Utilities. Home sleeps 10. Full Kitchen. All Appliance remains. Nice size Dining; Sold completely furnished, Built Strong. Upstairs room has plenty of beds. The view is worth the trip to see. This property would make a great Investment Property. It’s a nice place to call Home. This property is on the Texas side of the Lake. Good Investment Property. Bring the RV.' ,`Acres` = '' ,`Area` = '79' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '0.584, LOT 23,24, 25, 26 BLK 22, SUBD: TOLEDO BEACH # 3' ,`LotDesciption` = 'Other,Subdivision Lot,Water View,Waterfront,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '217 - Hemphill' ,`SchoolElementary` = 'HEMPHILL ELEMENTARY SCHOOL (HEMPHILL)' ,`SchoolHigh` = 'HEMPHILL HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPHILL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Toledo Beach' ,`TaxAmount` = '1963' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705921' WHERE `Matrix_Unique_ID` = '210995335' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T11:44:33.740' ,`MLSNumber` = '18670529' ,`ListAgentFullName` = 'Sergio De La Llata Jr.' ,`ListOfficeName` = 'Sierra Vista Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.702725' ,`Longitude` = '-95.280155' ,`PhotoCount` = '40' ,`PostalCode` = '77012' ,`RoomCount` = '4' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Sarita' ,`StreetNumber` = '7910' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1452' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'In search for a new home? Come embrace this wonderful newly remodeled home just minutes away from I-610 South Loop. This house is accompanied by 1,480 of living space and 6,000 sq ft in total. Surrounded by a charming black fence, you will be getting security and privacy. Come schedule your private tour now!' ,`Acres` = '0.1377' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 9 & 10A BLK 2 BROADWAY COURT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MILBY HIGH SCHOOL' ,`SchoolMiddle` = 'DEADY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Broadway Court' ,`TaxAmount` = '2747' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705921' WHERE `Matrix_Unique_ID` = '211095793' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T11:17:59.937' ,`MLSNumber` = '60532334' ,`ListAgentFullName` = 'Tola Tiamiyu' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.661029' ,`Longitude` = '-95.466860' ,`PhotoCount` = '44' ,`PostalCode` = '77035' ,`RoomCount` = '10' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Redstart' ,`StreetNumber` = '5018' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2327' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fall in love at first sight! This recently updated 3 bedroom, 2 bath Houston home is ready for you to make your own. Offering warmth and elegance the moment your guests step inside! The formal living room features a bright open space with French doors leading into a cozy family room and another set leading to a bonus room that can easily be used as a home office, studio, hobby room, or game room. Inviting family room with access to the backyard and breakfast nook is the heartbeat of this home. The updated eat-in kitchen boasts built-in stainless steel appliances, sleek counters, a tiled backsplash, and a pantry. Serene primary suite with charming ensuite bathroom. You\'ll appreciate the small details throughout! Amazing backyard oasis with a shed and a large covered patio with a ceiling fan provides additional outdoor living and entertaining space. Don\'t miss your opportunity to call this versatile space your own! 3D tour is available online!' ,`Acres` = '0.1928' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 11 WESTBURY SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KOLTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbury' ,`TaxAmount` = '5762' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705921' WHERE `Matrix_Unique_ID` = '211102329' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T11:00:55.027' ,`MLSNumber` = '7531494' ,`ListAgentFullName` = 'Sherry Salazar' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.950349' ,`Longitude` = '-95.291057' ,`PhotoCount` = '43' ,`PostalCode` = '77541' ,`RoomCount` = '6' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Oyster' ,`StreetNumber` = '514' ,`StreetSuffix` = 'Street' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1312' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A must see beach house seated at the end of the road with a view of intracoastal waterway and wetlands on three sides. There is only one neighbor on the left side of home. This home includes a back deck, big backyard, double carport, additional parking, and a big storage area. This fully furnished home features 3 bedrooms, 2 bath with living/kitchen combo. Appliances include washer, dryer, refrigerator, stove, and microwave.\r\nMany beautiful views and beach access is only 3 block away.' ,`Acres` = '0.225' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SURFSIDE BLK 517 LOT 11 (W/2) - LOT 13 (A0051 F J CALVIT)' ,`LotDesciption` = 'Water View' ,`LotSize` = '9801' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Surfside' ,`TaxAmount` = '4272' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705921' WHERE `Matrix_Unique_ID` = '211249805' --> 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','211369444','1663705921','211369444','2022-09-02T10:59:55.747','17200282','Deborah Hughes','2011 AMERICAN REAL ESTATE CO.','','','30.083121','-93.769184','12','77630','6','129900.00','Active','Longhorn','1524','','Orange','1','0','3','1296','Single-Family','This Great Listing Has Recently Been Updated And Is Move In Ready With A Wonderful Floor Plan!!! The owners have been working tirelessly to make this home perfect for the new homeowner. The home features a nice size living area with dining combo, a second living area with knotty pine paneling, kitchen complete with stove and dishwasher, three spacious bedrooms, updated bath, a single car garage attached to the home and a large two car detached garage with back entrance from Western Avenue. This wonderful home is nestled in the cul-de-sac with easy access to local industry and shopping! Call today for your personal tour of this wonderful home!!','0.15','50','','','Electric Dryer Connections,Washer Connections','','Other Disclosures','1','','','','Central Electric','0','Lot 6 Blk 1 Fair Park','Other','','','','','0','','3','','0','','','Electric Cooktop','','Composition','270 - West Orange-Cove Consolidated','WEST ORANGE-STARK ELEMENTARY SCHOOL','WEST ORANGE-STARK HIGH SCHOOL','WEST ORANGE-STARK MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Fair Park','1946','','Public Sewer,Public Water','1956','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:54:06.873' ,`MLSNumber` = '76509494' ,`ListAgentFullName` = 'Carol Fusco Jukes' ,`ListOfficeName` = 'Realty Pros of Texas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.699169' ,`Longitude` = '-95.612844' ,`PhotoCount` = '50' ,`PostalCode` = '77072' ,`RoomCount` = '9' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Leaders Crossing' ,`StreetNumber` = '7023' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2717' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has it all! One-owner home has been extremely well kept and has awesome upgrades with amazing attention to detail. See Cool things about this house in the attachments for the details on the upgrades. It\'s move-in-ready. Downstairs features, family room, dining room, and breakfast area, guest bedroom and an island kitchen with tons of storage. Upstairs features 3 bedrooms (including primary) and 2 bathrooms with a game/flex room. How do you get upstairs you ask? Try the elevator!\r\nThe backyard should be featured in a magazine. it has an amazing pool with rock waterfall and a spacious covered patio. Upstairs off of the spacious game room is a 2nd floor balcony with a fantastic view of the backyard and a hot tub. You will not find these features in any other home in the area!!!! Close to shopping, schools and major highways. Call and make an appointment today!' ,`Acres` = '0.1489' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 46 BLK 3 LEADER CROSSING SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6488' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '295' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'MAHANAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'KILLOUGH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Leader Crossing Sec 01' ,`TaxAmount` = '5715' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705921' WHERE `Matrix_Unique_ID` = '211398899' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:55:56.320' ,`MLSNumber` = '813625' ,`ListAgentFullName` = 'Ruben Villarreal' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804076' ,`Longitude` = '-95.849685' ,`PhotoCount` = '42' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '799900.00' ,`Status` = 'Active' ,`StreetName` = 'Kinglet' ,`StreetNumber` = '7114' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3499' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INCREDIBLE Almost New One Story w/ 4 Car Garage on OVERSIZED LOT IN GATED SECTION! ! Executive Home in Beautiful Cane Island! FALL IN LOVE THE MOMENT YOU ENTER this Showplace! High Ceilings*Formal Dining*Dramatic entry Open to the STUNNING DEN with wall of Windows and Sliding Doors Open to patio * Upgraded Ceiling Beams*Two Story Fireplace! ! Kitchen is to die for! Stainless Appliances*Gas Cooking*Quartz Countertops*Built ins + Amazing Walk in Pantry ! Light Bright Breakfast Room w/ Custom Built ins* Primary Suite is great in Size + Incredible Bath w/ Freestanding Tub*Walk in Shower*Double Vanities + Large Walk in closet! Enjoy Movie Night in you Full Size Media Room! French Doors to Study! Great Room Sizes! Walk to Parks*Trails*Lakes! A MUST TO SEE!' ,`Acres` = '0.2976' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S422377 CANE ISLAND SECTION 17 BLK 1 LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '3067' ,`TaxRate` = '3.4077' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705921' WHERE `Matrix_Unique_ID` = '211621675' --> 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','211658668','1663705922','211658668','2022-09-02T11:39:40.947','59728832','Ty Robinson','Compass RE Texas, LLC','','','29.674540','-95.353083','37','77033','3','245000.00','Active','Edfield','4815','Street','Houston','2','0','3','1302','Single-Family','Nicely updated 3/2 with tile floors, spacious kitchen, tankless hot water heater, & large front and back yards. Close to 610 Loop and the Medical Center. Investors welcome!','0.1439','3','','','','','Sellers Disclosure','1','','','Medical Center South','Central Electric','0','W 32 FT OF LT 19 & E 25 FT OF LT 20 BLK 5 EAST SUNNYSIDE COU','Cleared,Subdivision Lot','6270','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','BASTIAN ELEMENTARY SCHOOL','WORTHING HIGH SCHOOL','ATTUCKS MIDDLE SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','East Sunnyside Court Sec 03','2494','2.3307','Public Sewer,Public Water','1955','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:17:18.403' ,`MLSNumber` = '69920105' ,`ListAgentFullName` = 'Angela Shaw' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = 'Azael Vega' ,`SellingOfficeName` = 'TDG Realty' ,`Latitude` = '29.811572' ,`Longitude` = '-95.524707' ,`PhotoCount` = '11' ,`PostalCode` = '77080' ,`RoomCount` = '3' ,`ListPrice` = '650000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Blalock' ,`StreetNumber` = '2131' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1617' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investors Special! Property being sold at lot value. 23,000 sf land, perfect for new complex of homes. Zoned to SBISD schools.' ,`Acres` = '0.5383' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 41 NEUEN MANOR' ,`LotDesciption` = 'Other' ,`LotSize` = '23448' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'BUFFALO CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Neuen Manor' ,`TaxAmount` = '8737' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705922' WHERE `Matrix_Unique_ID` = '211807049' --> 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','211858397','1663705922','211858397','2022-09-02T10:59:41.160','21964581','Dayna Gideon','Adams Homes Realty, INC','','','29.419680','-95.033000','19','77591','4','314900.00','Active','Harper','4221','Road','Texas City','2','0','3','1820','Single-Family','This beautiful home could be yours! This 4-bedroom, 2-bathroom home has an open flow into the dining room, kitchen, great room, and breakfast bar! It\'s conveniently located to 1-45 for easy commutes and has great Dickinson Schools! Since 1991 Adams homes has taken great pride in quality construction along with excellent utilization of space. This home has granite countertops, stainless steel appliances, brushed nickel finishes, FULLY SODDED yard, brick on ALL FOUR sides of the home and so much more! Come take a tour!','','33','Adams Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','','Texas City','Central Gas','1','LOT 24 COBBLESTONE SEC 2','Cleared','6504','Other','','450','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','17 - Dickinson','HUGHES ROAD ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','JOHN AND SHAMARION BARBER MIDDLE SCHOOL','Accompany,Appointment Required','Builder','1','Ranch,Traditional','Cobblestone','','3.36','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T11:47:40.657' ,`MLSNumber` = '4290283' ,`ListAgentFullName` = 'Elizabeth Boles' ,`ListOfficeName` = 'One10 Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.502290' ,`Longitude` = '-94.515122' ,`PhotoCount` = '45' ,`PostalCode` = '77617' ,`RoomCount` = '7' ,`ListPrice` = '1597000.00' ,`Status` = 'Active' ,`StreetName` = 'Baker' ,`StreetNumber` = '994' ,`StreetSuffix` = 'Lane' ,`City` = 'Gilchrist' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '7' ,`SqFtTotal` = '2760' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***BEACHFRONT ***NEW CONSTRUCTION*** 7/5*** AMAZING VIEW*** Open concept floor plan with LARGE GRANITE Kitchen Island, PERFECT FOR ENTERTAINING!! Featuresn7 bedrooms and 5 bathrooms. U[stairs greatroom/bedroom area. Builder had THE WATERFRONT views in mind with the great decks All the windows allow natural sunlight in and offers incredible views throughout. Great entertainment area downstairs and outdoor shower, large balcony with amazing beach and bay views! and the Gulf of Mexico right out your front door. Perfect location for permanent residence or vacation rentals. ****THIS GREAT FLOORPLAN SLEEPS 30!! - - RENTAL INCOME GENERATION!!! The pictures were taken from another finished same floor plan, may vary as built.' ,`Acres` = '0.1799' ,`Area` = '33' ,`BuilderName` = 'Michael A. Walz' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Caplen' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 64 E FRANKS SUR PT OF LOT 5 (5-1) WILLIAM CARR SUB AKA' ,`LotDesciption` = 'Cleared,Water View,Waterfront' ,`LotSize` = '7837' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '25 - High Island' ,`SchoolElementary` = 'HIGH ISLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HIGH ISLAND HIGH SCHOOL' ,`SchoolMiddle` = 'HIGH ISLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Carr Wm Sub' ,`TaxAmount` = '1078' ,`TaxRate` = '1.5543' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663705922' WHERE `Matrix_Unique_ID` = '211864977' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:19:19.427' ,`MLSNumber` = '74746297' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'M/I Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.213243' ,`Longitude` = '-95.728584' ,`PhotoCount` = '5' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '399990.00' ,`Status` = 'Active' ,`StreetName` = 'Temple Memorial' ,`StreetNumber` = '220' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2307' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'As you walk into the foyer, you are greeted by a bedroom with its own private en-suite bathroom and walk-in closet, perfect for the guests who want their own space to hang and interact. \r\n\r\nWalk further into the home and enter the large combination dining/family area, which opens directly into the kitchen. With the gorgeous countertops, beautiful cabinetry, and high-end appliances, the kitchen is equipped to meet the demand of your culinary adventures.\r\n\r\nThe owner\'s suite sits on the far corner, giving you maximum peace and privacy, as well as a spacious walk-in closet that is perfect for his and her storage. An upscale owner\'s bath boasts an enclosed shower, double sinks, and a separate toilet area.\r\n\r\n2 secondary bedrooms are divided by a spacious playroom. For your convenience, a full hallway bathroom is located nearby. \r\n\r\nEnjoy a covered patio and the fully fenced-in backyard. \r\n\r\nContact us today to learn more!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'M/I Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 3 Magnolia Ridge Section 5A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7112' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Ridge' ,`TaxAmount` = '' ,`TaxRate` = '3.3013' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705922' WHERE `Matrix_Unique_ID` = '211866589' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:24:35.747' ,`MLSNumber` = '76252067' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.169132' ,`Longitude` = '-95.023208' ,`PhotoCount` = '20' ,`PostalCode` = '77327' ,`RoomCount` = '5' ,`ListPrice` = '201271.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5501' ,`StreetNumber` = '1045' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1287' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.24' ,`Area` = '52' ,`BuilderName` = 'ASGi Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 5, BLOCK 28, LOT 1376, ACRES 0.2400' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '10454' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'PINE BURR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe Sec 5' ,`TaxAmount` = '723' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705922' WHERE `Matrix_Unique_ID` = '211872338' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:25:24.510' ,`MLSNumber` = '73451951' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.168799' ,`Longitude` = '-95.022242' ,`PhotoCount` = '17' ,`PostalCode` = '77327' ,`RoomCount` = '5' ,`ListPrice` = '208558.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5501' ,`StreetNumber` = '1065' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1298' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.23' ,`Area` = '52' ,`BuilderName` = 'ASGi Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 5, BLOCK 28, LOT 1374, ACRES 0.2400' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '10019' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'PINE BURR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe Sec 5' ,`TaxAmount` = '704' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705922' WHERE `Matrix_Unique_ID` = '211872490' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T11:03:58.980' ,`MLSNumber` = '9140219' ,`ListAgentFullName` = 'Jesus Lopez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.869014' ,`Longitude` = '-95.712207' ,`PhotoCount` = '19' ,`PostalCode` = '77449' ,`RoomCount` = '9' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Tahoka Springs' ,`StreetNumber` = '19461' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1350' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Newly remodeled 3 bedroom 2 Bath Home on a Prime location. Features include Neutral colors through-out, New interior paint, New tile floors, New carpet, New lighting fixtures, and New ceiling fans. The open concept kitchen has been totally updated boasting stainless stove, dishwasher, Quartz countertops in the kitchen with decorative tile backsplash and New nickel-plated fixtures. The Master bedroom can accommodate King size furniture and bathroom has been updated as well, featuring Quartz vanity and with Porcelain walls. Other improvements include a New roof, New AC digital thermostat, New baseboards, New blinds on windows plus the convenience of the short drive to Citycentre, Towne Lake, Downtown and major shopping centers. Zoned to a GREAT school district. Property includes beautiful backyard and two car garage and plenty of spaces for family and friends to park with lighting. HURRY THIS ONE WONT LAST! Schedule your appointment TODAY!' ,`Acres` = '0.1148' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 2 BEAR CREEK MEADOWS SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bear Creek Meadows Sec 02' ,`TaxAmount` = '4372' ,`TaxRate` = '2.671' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705922' WHERE `Matrix_Unique_ID` = '211903230' --> 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','211934652','1663705923','211934652','2022-09-02T11:49:29.637','64573530','Amy Lippincott','Keller Williams Platinum','','','30.015446','-95.762591','34','77433','7','500000.00','Active','Shimmering Lake','16523','Drive','Cypress','3','1','3','2787','Single-Family','Welcome Home to Shimmering Lake Dr. This 3 bedroom 3.5, 1.5 story home is ready to welcome you home. This home has been well loved and taken care of, HVAC updated in 2022, the roof has been inspected and sealed in 2022. The home is located in a gated section of Fairfield, brick elevation with a nice size front porch. From the moment you walk-in the door you will see engineered wood floors, upgraded Italian tile floors, and crown molding, to name a few nice touches that you will find throughout the home. In the back of the home you will find a nice enclosed patio, the master retreat with an ensuite that includes a Jacuzzi tub, dual sinks and shower. Upstairs has a game room/bedroom with a full size bathroom and a walk-in closet. Downstairs you will find a study, formal dining room and a secondary bedroom to complete the home. Breakfast area right off of the kitchen offers more room for great family time. Come and see this beautiful home in person to truly appreciate what it offers!','0.167','35','','','Electric Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Cypress North','Central Gas','1','LT 5 BLK 2 FAIRFIELD VILLAGE NORTH SEC 8','Subdivision Lot','7276','Appraisal District','','925','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','SWENKE ELEMENTARY SCHOOL','BRIDGELAND HIGH SCHOOL','SALYARDS MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1.5','Traditional','Fairfield','7357','2.611','Public Sewer,Water District','2007','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:13:33.783' ,`MLSNumber` = '7657659' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.407234' ,`Longitude` = '-95.051784' ,`PhotoCount` = '7' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '506000.00' ,`Status` = 'Active' ,`StreetName` = 'Ocean Key' ,`StreetNumber` = '2622' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2578' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Cameron floor plan is designed to impress. With its open concept family room on the main level, which flows seamlessly onto a covered patio, the opportunities for design are endless. A spacious owner’s suite is located towards the back of the home, fitted with a walk-in closet, luxurious ensuite and large walk-in closet. As you make your way up to the second floor, you’ll notice the central games room, perfect for families with children or for those who love to entertain. The 12-acre Lago Mar crystal clear lagoon is the largest in Texas and a unique staycation destination. Bay Area breezes will caress you while you lounge on white-sand beaches, swim in azure waters or dine lagoonside on our beach boardwalk. Only 20 minutes from Galveston. So much to see and do, right in your backway.' ,`Acres` = '0.1475' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 27 BLK 1 LAGO MAR POD 6 SEC 2 (2020) ABST 11' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6472' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705923' WHERE `Matrix_Unique_ID` = '211940590' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:04:38.007' ,`MLSNumber` = '3538570' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.410479' ,`Longitude` = '-95.057737' ,`PhotoCount` = '7' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '387000.00' ,`Status` = 'Active' ,`StreetName` = 'Cobalt Cove' ,`StreetNumber` = '13009' ,`StreetSuffix` = '' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1983' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Glenwood is a 3 bedroom, 2.5 bathroom, 1.5 story with an amazing bonus room upstairs. The open-concept floor plan makes the home feel much larger and features plenty of natural light and storage space. With a large granite kitchen island, GE slate series appliances, and expertly crafted kitchen cabinets, the kitchen is the heart of this home and definitely the perfect place to gather and entertain with friends and family. A large bonus room upstairs can be used as an additional flex space for a game room and media room. A large covered patio and easy access to the lagoon makes this one a popular choice among buyers!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 68, block 1, Section 3' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '4995' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705923' WHERE `Matrix_Unique_ID` = '211943001' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:14:03.937' ,`MLSNumber` = '86019050' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.407571' ,`Longitude` = '-95.052753' ,`PhotoCount` = '6' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '403000.00' ,`Status` = 'Active' ,`StreetName` = 'Arbor Edge' ,`StreetNumber` = '2510' ,`StreetSuffix` = 'Crossing' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1989' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 1 story homes welcomes you with a grand entrance and a very open concept floorplan. Offering 3\r\nbedrooms, 2 bathrooms ; there is plenty of space for everyone. Relax In the evening in the primary suite or take a dip in the soaking tub. You can also enjoy a nice evening on the covered patio as you relax in the comfort of your new home. Come see us in Lago Mar today to view this beautiful home. It won\'t last long.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25, block 5, Section 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6521' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705923' WHERE `Matrix_Unique_ID` = '211943977' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:13:06.390' ,`MLSNumber` = '68694089' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405942' ,`Longitude` = '-95.051474' ,`PhotoCount` = '7' ,`PostalCode` = '77568' ,`RoomCount` = '9' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayrose' ,`StreetNumber` = '2710' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2975' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to our gorgeous Baker floorplan. This home features two bedrooms down and three bedrooms up plus a spacious game room! The living room is a perfect blend of cozy and family-friendly styles. Designer selections throughout include 42” painted cabinetry and quartz countertops. Wind down in your spacious primary bedroom featuring semi-vaulted ceilings, a garden tub, and a stone mosaic mud set shower. This home is an entertainer\'s dream with its huge game room and oversized covered patio!' ,`Acres` = '0.1474' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 14 BLK 6 LAGO MAR POD 6 SEC 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6415' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705923' WHERE `Matrix_Unique_ID` = '211944866' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T10:15:18.597' ,`MLSNumber` = '56646216' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.444999' ,`Longitude` = '-95.397934' ,`PhotoCount` = '3' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '726427.00' ,`Status` = 'Active' ,`StreetName` = 'Sanger' ,`StreetNumber` = '9527' ,`StreetSuffix` = 'Way' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3342' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction by Shea Homes. Plan 6010. Est. Completion 1/2023. This inviting and spacious single-story home is the epidemy of comfort and versatility. This beautiful home offers 4 bedrooms, 3.5 bathrooms, and a 3-car tandem garage. Upon entering, the Great Room awaits at the end of the hall with 12\' ceilings, fireplace and stacked sliding doors that fill the space with natural light. An oversized Casual Dining Room leads out to the extended covered patio. Back inside, the gourmet Kitchen includes cabinets galore, double ovens, a 5-burner gas cooktop, large kitchen island and a huge walk-in pantry. The primary suite is the perfect place to relax featuring a bay window and spa like bathroom with dual vanities, shower with bench seat and freestanding tub. A Media Room w/wet bar will provide the perfect space to entertain family and friends. Come and Live the Difference in a Shea Home!\r\n\r\n\r\nCome live the difference in this gorgeous Shea home!' ,`Acres` = '0.2369' ,`Area` = '5' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 44 (A0282 & A0286) (MANVEL) BLK 2 LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12823' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '2044' ,`TaxRate` = '3.68' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705923' WHERE `Matrix_Unique_ID` = '211952628' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-02T11:24:16.373' ,`MLSNumber` = '17252010' ,`ListAgentFullName` = 'Jacqueline Booth' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.293999' ,`Longitude` = '-94.916722' ,`PhotoCount` = '41' ,`PostalCode` = '77554' ,`RoomCount` = '9' ,`ListPrice` = '957600.00' ,`Status` = 'Active' ,`StreetName` = 'Oahu' ,`StreetNumber` = '1330' ,`StreetSuffix` = 'Drive' ,`City` = 'Tiki Island' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2736' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning BAY VIEWS on an oversized lot! This 4 bedroom 3 bath home sits on an open canal with amazing views in both directions. The main floor boasts commercial grade wood grain tile and an open floor plan with lots of room for entertaining. The main floor deck and the primary bedroom deck were replaced in 2022. Upstairs you will find an enormous primary bedroom with a sitting area and a private deck with bay views. The primary bath and the main floor bath have both been updated. The third bedroom on the second floor has a private bath and plenty of closet space. New 5 ton A/C for main level - August 2022. There may be room for a pool as well. The lot has approximately 100 feet of bulkhead and a large boathouse. Call today to schedule your private showing!' ,`Acres` = '0.15' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S C BUNDICK SUR LOT 99 TIKI ISLAND SEC 3' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '6534' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Tiki Island' ,`TaxAmount` = '11723' ,`TaxRate` = '2.2119' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705923' WHERE `Matrix_Unique_ID` = '211996393' --> 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','212020197','1663705923','212020197','2022-09-02T11:37:27.427','95056776','Diane Kink','Keller Williams Woodlands','','','30.201562','-95.445309','40','77385','13','510000.00','Active','Threadtail','8129','Street','Conroe','4','0','5','4147','Single-Family','Spacious 5 bedroom Highland Home in Harpers Preserve featuring 2 bedrooms down. Stone & Wood façade welcomes you to the porch entry. Enter into the high ceiling foyer with wood floors. Large formal dining & family room featuring stone fireplace & is open to the island kitchen. The kitchen features ample cabinetry, stainless steel appliances & large eat-at granite island. French doors to study & separate bonus mothers desk/ children\'s study area. Huge primary bed with en-suite bath & walk-in closet with direct laundry room access. Second bedroom down & full bath. Three bedrooms up; including one with private bath, game room with bar niche, large media room & study nook with desks & shelving. Spacious back patio & yard with plenty of room for a pool. True 3 car garage with storage space, area for a workshop and built in shelving throughout. Enjoy the trails & clubhouse of Harper\'s Preserve. Gate is closed & manned in the evenings. Zoned to CISD.','0.1933','15','Highland Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Spring Northeast','Central Gas','1','S572700 - HARPER\'S PRESERVE 01, BLOCK 8, LOT 56','Cul-De-Sac,Subdivision Lot','8419','Appraisal District','','1127','0','','3','Freestanding Oven,Gas Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','SUCHMA ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal','2','Traditional','Harpers Preserve 01','12233','3.0088','Water District','2011','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','212067741','1663705923','212067741','2022-09-02T10:22:46.420','65255750','Roxanna Gross','RE/MAX Signature','','','30.388816','-95.618939','28','77356','8','399900.00','Active','Lake Island','3110','Drive','Montgomery','2','1','3','3205','Single-Family','Live mere steps from the shores of Lake Conroe in this stunning 3-bedroom, 2.5-bathroom home in Walden, boasting a brick exterior, tile flooring, crown molding, gas log fireplace, formal dining room, a study, and a covered patio in the spacious backyard. Entertain guests in the kitchen, complete with a walk-in pantry, electric cooktop, double oven, dining nook, and a breakfast bar. The spa-like primary suite features a walk-in closet, dual vanities, a jetted tub, and a separate shower. Community comforts include the Walden Yacht Club, a marina, an 18-hole golf course, 16-court tennis facility, fitness center, swimming pools, dog park, playgrounds, and hike & bike trails. There are multiple restaurants in the neighborhood, plus more just down the road at Montgomery Trace Center and the Margaritaville Lake Resort. Enjoy a round of golf on the golf course right behind this home! Zoned to Montgomery ISD.','0.2354','39','','','','','Owner/Agent','1','Gas Connections,Gaslog Fireplace','1','Lake Conroe Area','Central Gas','1','WALDEN 09, BLOCK 50, LOT 55','On Golf Course,Subdivision Lot','10255','Appraisal District','','1050','0','','3','Double Oven','0','','','Electric Cooktop','','Composition','37 - Montgomery','MADELEY RANCH ELEMENTARY SCHOOL','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Contemporary/Modern,Ranch,Traditional','Walden 09','5583','2.2242','Public Sewer,Public Water','1983','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','212103604','1663705924','212103604','2022-09-02T11:26:56.087','29787941','Rosalinda Frias','Manor, LLC','','','29.800139','-95.376531','7','77009','8','899900.00','Active','Walton','1003','','Houston','3','1','4','3000','Single-Family','Beautiful new construction in the heart of the highly-desired Brooke Smith. This 3,000 square foot home has everything including 4 bedrooms, an office on the first floor, open concept living, master bedroom on the first floor, large game room on the second floor and a large covered patio for outdoor entertaining. Home estimated to be completed January 2023.','','9','Greyden Building','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','0','Heights/Greater Heights','Central Gas','0','LT 8 BLK 102','Patio Lot','5000','Survey','','','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','BROWNING ELEMENTARY SCHOOL','HEIGHTS HIGH SCHOOL','HOGG MIDDLE SCHOOL (HOUSTON)','Appointment Required','Builder','2','Traditional','Brooke Smith','','','Public Sewer,Public Water','2023','Builder'); --> 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','212107093','1663705924','212107093','2022-09-02T11:28:33.133','60029500','Jaime Lazcano','eXp Realty, LLC','','','29.610138','-95.240031','37','77075','3','197000.00','Active','Carmalee','9906','Street','Houston','1','0','3','1289','Single-Family','This property is priced to sell! \r\n\r\nConveniently located in between 2 major highways. This 3 bedroom home has been tastefully spiced up to bring it into this century\'s style. Another decision that was taken on this renovation was to include the luxury vinyl through out the house to add to its cohesiveness. A side room has been strategically fixed so that you can have a large work office or a 4th (non official bedroom). \r\n\r\nPlease enjoy this tasteful home and nice neighborhood.','0.154','3','','','','','Owner/Agent','','','','Southbelt/Ellington','Central Electric,Central Gas','0','LT 8 & TR 9A BLK 9 ADJ 1 FT OF LT 9 EASTRIDGE TERRACE','Other','6710','Appraisal District','','','0','','0','','0','','','','','Composition','41 - Pasadena','ATKINSON ELEMENTARY SCHOOL','DOBIE HIGH SCHOOL','BEVERLYHILLS INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Eastridge Terrace','3065','2.6863','Public Sewer','1958','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','212116857','1663705924','212116857','2022-09-02T11:04:29.087','34395171','Barbara McIntyre','Lone Star Realty','','','30.341320','-95.085489','16','77327','6','45000.00','Active','Regusta Richard','603','Avenue','Cleveland','1','1','3','1008','Single-Family','This Country HAS TWO HOMES ON THE IT. 1.Three Bedroom 1Bathroom home on .1435 acres. Home need a lot of TLC, SECOND HOUSE could be a Great opportunities for a rental property, Second property on the lot need WORK.','0.1435','52','','','','','No Disclosures','','','','Cleveland Area','Window Unit','0','BLAGG-FENNER, BLOCK E, LOT 9, ACRES .1435','Subdivision Lot','6251','Appraisal District','','','0','','0','','0','','','','','Wood Shingle','100 - Cleveland','SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)','CLEVELAND HIGH SCHOOL','CLEVELAND MIDDLE SCHOOL','No Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern','Blagg-Fenner','1595','2.5563','Public Sewer,Public Water','1930','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','212117562','1663705924','212117562','2022-09-02T11:15:19.740','10485625','John Newsom','eXp Realty, LLC','','','29.801049','-95.888083','9','77493','12','899999.00','Active','Winding Canyon','1634','Court','Katy','3','1','5','4200','Single-Family','House is in the process of many updates and renovations, including granite replacement in kitchen, 2 new A/C units, paint inside and outside, upstairs and downstairs carpet being replaced, bathroom vanities being upgraded to quartz with new facuets. Kitchen cabinets to be painted. Now is the time to make your purchase you may have the opportunity to pick your colors.','1.4263','25','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace,Wood Burning Fireplace','1','Katy - Old Towne','Central Gas,Zoned','1','S733104 REMINGTON TRAILS 4 BLK 2 LOT 3 ACRES 1.4263','Cleared,Greenbelt,Subdivision Lot','62130','Appraisal District','','1100','0','','3','Electric Oven','0','','','Gas Cooktop','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','KATY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Temporarily No Showings','Appraisal District','2','Ranch','Remington Trails 4','10986','2.1293','Septic Tank,Well','2003','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','212118605','1663705924','212118605','2022-09-02T11:04:05.110','67285269','Teri Walter','K. Hovnanian of Houston II, LL','','','29.204075','-95.407261','13','77515','10','350343.00','Active','Prairie Rose','3631','Trail','Angleton','2','0','3','1660','Single-Family','This Fairbanks home design features 3 bedrooms, 2 baths and 2 car garage. Convenient home office tucked off foyer. Beautiful maple cabinets, quartz countertops with low bar top and farmhouse sink in kitchen. Huge walk-in closet in owner\'s suite. Double sinks, separate tub and shower in owner\'s bath. Covered patio in backyard, perfect for entertaining. This home is a must see, so schedule your appointment today to find out if this home is the best option for you and your family. \r\nWindrose Green in Angleton offers easy access to Hwy 288 and Hwy 35. Students will have access to a trail which will lead them to Angleton High School. Planned amenities include a neighborhood park with playground and splashpad plus walking trails. Offered by: K. Hovnanian of Houston II, L.L.C.','','5','K.Hovnanian','','Gas Dryer Connections,Washer Connections','','Mud','1','','0','Angleton','Central Gas','1','19/2/1','Cleared,Subdivision Lot','8489','Survey','','750','1','To Be Built/Under Construction','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','5 - Angleton','RANCHO ISABELLA ELEMENTARY SCHOOL','ANGLETON HIGH SCHOOL','ANGLETON MIDDLE SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Windrose Green','','3.527','Water District','2022','Builder'); --> 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','212119312','1663705924','212119312','2022-09-02T11:35:56.887','80643476','Alex Rezende','AroundTown Properties Inc','','','29.699541','-95.372298','21','77026','6','349888.00','Active','Linder','2012','Street','Houston','2','1','3','1611','Single-Family','This brand new smart home features 3 Bedrooms & 2.5 Baths a 2 car attached garage & a low maintenance backyard! Granite countertops & built-in stainless steel appliances in the open concept kitchen with tons of natural light. Tile flooring throughout the living areas/walkways and carpet in all bedrooms. Smart Home Features include LED lights, smart garage door opener, Smart thermostat, Smart lock, Smart doorbell, electric car outlet, low voltage panel, smart light switch, HVAC 16 SEER. Linder Landing is perfectly situated just North of Downtown Houston and only minuted from 610. The prime location provides convenient access to Downtown Houston and other major employment centers, fine dining, shopping & entertainment! This exclusive community is comprised of only five homes and features modern floor plans and high-end interior finishes. Quality construction by MTY Builders paired with the luxurious open concept design is sure to impress! 5 Units starting at $344,888.','','4','MTY Builders','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Corporate Listing','1','','','University Area','Central Gas','0','Lot 3 Blk 1 Linder Landing','Cleared','2516','Appraisal District','','','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','THOMPSON ELEMENTARY SCHOOL (HOUSTON)','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Accompany,Appointment Required','Builder','2','Contemporary/Modern','Linder Landing','','2.33','Public Sewer,Public Water','2021','Builder'); --> 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','212119520','1663705924','212119520','2022-09-02T11:02:59.403','37284000','Shakeel Ahmed','Equicap Brokerage LLC','','','28.948490','-95.286792','29','77541','4','800000.00','Active','Beach Drive','123','Drive','Surfside Beach','2','1','4','1500','Single-Family','','0.1451','5','','','','','Corporate Listing','','','','Surfside','Central Electric','1','SHANKS (A0051 F J CALVIT)(SURFSIDE), BLOCK 2, LOT 1 TR 1','Corner','6321','Appraisal District','','350','0','','0','','0','','','','','Composition','7 - Brazosport','VELASCO ELEMENTARY SCHOOL','BRAZOSPORT HIGH SCHOOL','FREEPORT INTERMEDIATE SCHOOL','Appointment Required','Seller','1','Traditional','Shanks','9094','2.333','Public Water','1997','Seller'); --> 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','212119707','1663705924','212119707','2022-09-02T11:47:45.523','79423952','Richard Hall','Vylla Home','','','30.903998','-97.756164','26','76527','8','1600000.00','Active','Indian Lake','1105','Road','Florence','2','0','4','2056','Single-Family','WOW, we bought a lake! Okay, full disclosure, it’s a wet weather lake, but it is on the map, Indian Lake, and according to seller when full it is approximately 10 feet at deepest point! The end of that drive is where the magic begins, and you find out how much more this 26 plus acre property has to offer. Home is a 4/2 single story with an open floorplan. Large country kitchen with center island and stainless-steel appliances. Beautiful wood floors, fireplace, huge master bedroom, his and hers closets, dual sinks. Covered back porch that spans from living room to dining room. The view, all you can say is WOW! an uninterrupted view of the magnificent hill country. It doesn’t stop there; this property has full RV hookup next to the 30x50 metal shop which is plumbed and has full electric. 10 sheep will convey with the property to continue the journey to ag exemption which was started 3 years ago by the sellers.','26.049','83','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','','Central Electric','0','A0490BC D J KEIGER, 1-7, ACRES 26.049','Other,Wooded','1134694','Unknown','','','0','','0','Convection Oven','0','','','Gas Range','','Composition','514 - Florence','FLORENCE ELEMENTARY SCHOOL (FLORENCE)','FLORENCE HIGH SCHOOL','FLORENCE MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Seller','1','Ranch','N/A','8207','1.5212','Public Water,Septic Tank,Well','2001','Seller'); --> 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','212121452','1663705924','212121452','2022-09-02T11:10:01.003','15182716','Dayna Gideon','Adams Homes Realty, INC','','','29.419680','-95.033000','19','77591','4','312900.00','Active','Chadwick','4301','Road','Texas City','2','0','3','1820','Single-Family','This beautiful home could be yours! This 4-bedroom, 2-bathroom home has an open flow into the dining room, kitchen, great room, and breakfast bar! It\'s conveniently located to 1-45 for easy commutes and has great Dickinson Schools! Since 1991 Adams homes has taken great pride in quality construction along with excellent utilization of space. This home has granite countertops, stainless steel appliances, brushed nickel finishes, FULLY SODDED yard, brick on ALL FOUR sides of the home and so much more! Come take a tour!','','33','Adams Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','','Texas City','Central Gas','1','LOT 40 COBBLESTONE SEC 2','Cleared','','Other','','450','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','17 - Dickinson','HUGHES ROAD ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','JOHN AND SHAMARION BARBER MIDDLE SCHOOL','Accompany,Appointment Required','Builder','1','Ranch,Traditional','Cobblestone','','3.36','Public Sewer,Public Water','2022','Builder'); --> 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','212122807','1663705924','212122807','2022-09-02T11:59:34.300','10756947','Alex Rezende','AroundTown Properties Inc','','','29.813696','-95.348430','29','77026','6','354888.00','Active','Batterson','6011','Street','Houston','3','1','3','1665','Single-Family','This brand new smart home features 3 Bedrooms & 2.5 Baths a 2 car attached garage & a low maintenance backyard! Granite countertops & built-in stainless steel appliances in the open concept kitchen with tons of natural light. Tile flooring throughout the living areas/walkways and carpet in all bedrooms. Smart Home Features include LED lights, smart garage door opener, Smart thermostat, Smart lock, Smart doorbell, electric car outlet, low voltage panel, smart light switch, HVAC 16 SEER. Linder Landing is perfectly situated just North of Downtown Houston and only minuted from 610. The prime location provides convenient access to Downtown Houston and other major employment centers, fine dining, shopping & entertainment! This exclusive community is comprised of only five homes and features modern floor plans and high-end interior finishes. Quality construction by MTY Builders paired with the luxurious open concept design is sure to impress! 5 Units starting at $344,888.','','9','MTY BUILDERS','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Corporate Listing','1','','','Northside','Central Electric','0','LOT 4 BLOCK 1 Linder Landing','Cleared,Subdivision Lot','2600','Survey','','','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','ROSS ELEMENTARY SCHOOL (HOUSTON)','NORTHSIDE HIGH SCHOOL','KEY MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front','Builder','2','Contemporary/Modern','Linder Landing','','2.33','Public Sewer,Public Water','2022','Builder'); --> New record created successfully