Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T06:04:19.973' ,`MLSNumber` = '914830' ,`ListAgentFullName` = 'Rocio Salas' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.924287' ,`Longitude` = '-95.485246' ,`PhotoCount` = '35' ,`PostalCode` = '77086' ,`RoomCount` = '7' ,`ListPrice` = '247500.00' ,`Status` = 'Active' ,`StreetName` = 'Northwest Park' ,`StreetNumber` = '10174' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1810' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful House in a well maintain subdivision, fully updated with a green new grass front and back of house, new stove and dishwasher, ready to move in. NEW... paint, doors, new windows, laminate floors, complete exterior siding and trim, complete plumbing and some electrical. House is ready to welcome you!' ,`Acres` = '' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 49 BLK 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARMICHAEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'SHOTWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Northwest Park' ,`TaxAmount` = '3162' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117899' WHERE `Matrix_Unique_ID` = '208597729' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T07:23:01.700' ,`MLSNumber` = '30204796' ,`ListAgentFullName` = 'Oscar Cruz' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.008184' ,`Longitude` = '-95.420220' ,`PhotoCount` = '20' ,`PostalCode` = '77073' ,`RoomCount` = '3' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Rock East' ,`StreetNumber` = '16539' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1470' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Freshly painted, two story home conveniently located close to schools, stores, restaurants and Interstate 45, Betway 8, FM 1960. Tiled floor downstairs in the Kitchen, dining and living rooms. Barely used Carpet upstairs installed 2021. New windows throughout entire home installed 2021. Covered patio in the back yard perfect for grilling on those hot summer days and year round hot weekends. Schedule a showing with your agent as this will not last long.' ,`Acres` = '0.1136' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 3 NORTH VIEW WEST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'North View West Sec 01' ,`TaxAmount` = '3881' ,`TaxRate` = '2.7292' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117899' WHERE `Matrix_Unique_ID` = '208664271' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T07:49:56.767' ,`MLSNumber` = '29989199' ,`ListAgentFullName` = 'Fariborz Shojai' ,`ListOfficeName` = 'F S Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750238' ,`Longitude` = '-95.489049' ,`PhotoCount` = '20' ,`PostalCode` = '77057' ,`RoomCount` = '3' ,`ListPrice` = '699987.00' ,`Status` = 'Active' ,`StreetName` = 'Potomac' ,`StreetNumber` = '1628' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3055' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FABULOUS PROPERTY FOR PRIMARY RESIDENCE --- URBAN LIVING, FREE STANDING PATIO HOME, INTERIOR LOT. SHARED DRIVEWAY WITH ADJACENT PROPERTY ONLY: Location, Location, Location. Galleria area. Briargrove Elementary school. First Floor Living with OFFICE. All bedrooms located on the second floor. Custom Cabinetry & Hardwood Floors Throughout. Open Floor Plan. Gourmet Kitchen, Floor to Ceiling Cabinets W Large Island & SS KitchenAid Appliances. JELD-WEN: French Doors & Windows make this beauty well insulated. Spacious Master BR & Master Closet. Walk-in Closet in secondary bedrooms. 3rd Floor with Separate AC unit and breathtaking Loft/Game Room with full bath & Rooftop make this stunning home great for living & entertaining. Lock & leave. ACCOMPANY.' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = 'CDI' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2509' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Other Style' ,`Subdivision` = 'Potomac Gardens' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667117899' WHERE `Matrix_Unique_ID` = '210129299' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T06:51:22.577' ,`MLSNumber` = '18126283' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.711917' ,`Longitude` = '-95.853727' ,`PhotoCount` = '22' ,`PostalCode` = '77441' ,`RoomCount` = '10' ,`ListPrice` = '584990.00' ,`Status` = 'Active' ,`StreetName` = 'Kenton Place' ,`StreetNumber` = '5222' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3433' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LIKE NEW... Stunning One Story home in the heart of Cross Creek Ranch Master Planned Community. Featuring 4 bedrooms, 3 bathrooms, Game Room, Private study, PLUS a 3 CAR GARAGE- this home will not disappoint. Formal entry with tall ceilings, tile flooring, and a home office with new double doors are just some of the details you will notice upon entering. This beautiful floorplan offers a spacious living area with tall ceilings and a gas fireplace. Well laid out open kitchen with butler pantry, stainless steel appliances, under cabinet lighting, and center island. Expansive primary retreat with en-suite bath featuring dual sinks, separate shower, and soaking tub. The home backs to green space and walking trails. Oversized back and side yard. ROOM FOR A POOL! Fresh paint throughout! Light and Bright! New flooring in all bedrooms. Cross Creek Ranch features miles of walking and biking trails, community pools, tennis courts, pickle ball courts and other amenities. Exemplary KISD!' ,`Acres` = '0.2502' ,`Area` = '36' ,`BuilderName` = 'Perry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEK BEND AT CROSS CREEK RANCH SEC 6, BLOCK 1, LOT 13' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '10897' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'JAMES E RANDOLPH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creek Bend At Cross Creek Ranch Sec 6' ,`TaxAmount` = '12411' ,`TaxRate` = '3.1375' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117900' WHERE `Matrix_Unique_ID` = '211194885' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T07:47:42.590' ,`MLSNumber` = '15221887' ,`ListAgentFullName` = 'Alfredo Sabal' ,`ListOfficeName` = 'Krueger Real Estate' ,`SellingAgentFullName` = 'Kimberly Cabrera' ,`SellingOfficeName` = 'Keller Williams Premier RealtyKaty' ,`Latitude` = '29.812366' ,`Longitude` = '-95.757305' ,`PhotoCount` = '19' ,`PostalCode` = '77449' ,`RoomCount` = '11' ,`ListPrice` = '299000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Hammerhead' ,`StreetNumber` = '22202' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2148' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice 3 Bedroom and 2 and 1/2 Bath home with wood floors on the first floor and carpet on the second floor. This home offers granite counter tops, two pantries, a mock fire place and a large family room that can be used as a home office.\r\n\r\n\r\n\r\nThe owner would need a two hour notice before showings.' ,`Acres` = '0.1652' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 LAKES AT MASON PARK SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7196' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MORTON RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MORTON RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lakes/Mason Park Sec 2 Amd' ,`TaxAmount` = '6363' ,`TaxRate` = '2.8233' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117900' WHERE `Matrix_Unique_ID` = '211504217' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T06:47:55.520' ,`MLSNumber` = '19022539' ,`ListAgentFullName` = 'Jason Wyche' ,`ListOfficeName` = 'Traditions Realty' ,`SellingAgentFullName` = 'Tolena Washington' ,`SellingOfficeName` = 'REAL Houston' ,`Latitude` = '29.483561' ,`Longitude` = '-95.524372' ,`PhotoCount` = '34' ,`PostalCode` = '77459' ,`RoomCount` = '7' ,`ListPrice` = '619900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Lazy Vine' ,`StreetNumber` = '2619' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3350' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Back on the Market Buyers Financing Fell Through** Spectacular 4/4/3 - 2 story Shea Home in Sienna. 4 bedrooms, 3 bathrooms and study down, media room (with wet bar & wine refrigerator) game room, & full bathroom up. Wood floors throughout first floor except bathrooms. Home sits on a 10,000 sq ft lot with no neighbors behind and on one side of the home. Gourmet kitchen with huge island able to seat 5 comfortably, custom cabinets, double ovens, 5 burner gas cooktop. Kitchen opens to family room with a fireplace, cathedral ceilings and wood beams. Gorgeous primary suite with walk-in rain shower and garden tub inside, large walk-in closet, his and her sinks with vanity sitting area. Very spacious secondary bedrooms. 3 car tandem garage. Spacious covered patio & front/back sprinkler system. Family room, patio, & kitchen are wired for surround sound, Gas connection ready for future outdoor kitchen.' ,`Acres` = '0.248' ,`Area` = '38' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA VILLAGE OF DESTREHAN SEC 5, BLOCK 1, LOT 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10801' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Village Of Destrehan' ,`TaxAmount` = '13759' ,`TaxRate` = '3.1629' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117900' WHERE `Matrix_Unique_ID` = '211757004' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T06:08:15.703' ,`MLSNumber` = '46408798' ,`ListAgentFullName` = 'Melissa Galloway' ,`ListOfficeName` = 'Hite Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.401791' ,`Longitude` = '-95.549895' ,`PhotoCount` = '25' ,`PostalCode` = '77318' ,`RoomCount` = '8' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Natalia' ,`StreetNumber` = '11417' ,`StreetSuffix` = 'Lane' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1802' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MUST SEE gorgeous single story 4/2/2 home in the community of Clear View Estates in Willis, TX! NO CARPET & MOVE IN READY! Energy efficient and features a brick and stone exterior, art niches in entry, large living open to kitchen, pretty white cabinets, GRANITE counter tops, gas cooktop, high ceilings, recessed lighting, ceiling fans and lots of natural light throughout. Luxury vinyl plank flooring throughout!! Large master bedroom with tray ceiling, large ensuite bath, separate tiled shower and soaking tub plus a large walk-in closet with built in shelving. Enjoy the back yard that also includes a covered back patio! FANTASTIC LOCATION! Nearby attractions include Lake Conroe, Sam Houston National Forest, Margaritaville Lake Resort and The Woodlands Mall! NEW HEB set to open up in Wills too! Zoned to the growing Willis ISD! LOW TAX RATE and convenient access to I-45! Schedule your showing today!' ,`Acres` = '0.1386' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S343400 - CLEAR VIEW ESTATES, BLOCK 5, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6038' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear View Estates' ,`TaxAmount` = '911' ,`TaxRate` = '2.5148' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117900' WHERE `Matrix_Unique_ID` = '212180042' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T07:48:50.950' ,`MLSNumber` = '71560351' ,`ListAgentFullName` = 'Jeff Deutschmann' ,`ListOfficeName` = 'Jeff Webb Real Estate ' ,`SellingAgentFullName` = 'Kyle Tweed' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '30.390314' ,`Longitude` = '-95.595735' ,`PhotoCount` = '44' ,`PostalCode` = '77356' ,`RoomCount` = '8' ,`ListPrice` = '395000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hunters' ,`StreetNumber` = '11122' ,`StreetSuffix` = 'Landing' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2298' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hunters Landing Beauty. This premier gated community is steps from the shores of Lake Conroe. This home comes with it\'s own boat slip with lift and cover, within walking distance. Wonderful curb appeal in this 3 bedroom home, 2.5 bath home. Stunning entry with tile flooring, high ceilings and a nice layout. Formal dining room to the right that opens to the kitchen with plenty of white cabinetry, granite counters and a breakfast bar and dining area. The family room has high ceilings with recessed lighting, crown molding, tile flooring and a gas fireplace. Primary bedroom is on the first level and has tiered ceilings with crown molding. The adjoining bath has double sinks, jetted tub, separate walk in shower and a huge closet. Nice sized laundry room on the first floor with built in cabinetry and a folding area. The half bath is nearby. Two bedrooms, full bath and a Texas basement on the 2nd level. Ultra private back yard with covered patio. Enjoy Lake Conroe boating and fishing!' ,`Acres` = '0.1585' ,`Area` = '39' ,`BuilderName` = 'Jerry Ward' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HUNTERS LANDING, BLOCK 3, LOT 26' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6903' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Landing' ,`TaxAmount` = '6009' ,`TaxRate` = '2.1392' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117900' WHERE `Matrix_Unique_ID` = '212191496' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T07:15:20.163' ,`MLSNumber` = '84337708' ,`ListAgentFullName` = 'Raelene Chastain' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.099424' ,`Longitude` = '-95.186695' ,`PhotoCount` = '35' ,`PostalCode` = '77365' ,`RoomCount` = '6' ,`ListPrice` = '344900.00' ,`Status` = 'Active' ,`StreetName` = 'Whitehaven Ridge' ,`StreetNumber` = '4519' ,`StreetSuffix` = 'Way' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2206' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wildflower Series-Larkspur by Lennar. Great 2 Story 4/2.5/2 Master down-Master Suite w/Garden Tub, Sep. Shower, Dual Sinks & Walk in Closet!. Island Kitchen w/Designer Cabinets, Granite Countertops & Stainless Steel Appliances. Open Concept w/ breakfast area and Spacious Family Rm! Seperate Formal Dining room or can be used as an office space. 3 Bedrooms up plus a large Game room upstairs! Tile Flooring and carpet. 2\'\'Faux Wood Blinds; Covered Patio; Sprinkler System; Fully fenced large Backyard. ** BONUS **Energy Efficient 16 SEER HVAC! Wifi Certified Home complete w/ Home Automation System! This Smart Home has the ability to open front door, turn on lights, allows a Ring alarm and window alarms all accessible through smart home apps. No neighbors on rt side. Quick access into Kingwood and Porter.' ,`Acres` = '0.1874' ,`Area` = '40' ,`BuilderName` = 'Village Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S349205 - COUNTRY COLONY 05, BLOCK 1, LOT 31' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8164' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'PORTER ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW CANEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Colony 05' ,`TaxAmount` = '6872' ,`TaxRate` = '3.2531' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117901' WHERE `Matrix_Unique_ID` = '212275743' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T06:43:35.407' ,`MLSNumber` = '47578778' ,`ListAgentFullName` = 'Marlana Mack' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.069978' ,`Longitude` = '-95.534789' ,`PhotoCount` = '8' ,`PostalCode` = '77379' ,`RoomCount` = '4' ,`ListPrice` = '387121.00' ,`Status` = 'Active' ,`StreetName` = 'Rose Crossing' ,`StreetNumber` = '20931' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful two-story, four-bedroom, two-and-a-half-bathroom home is located in the well-sought-after Windrose Community. You can take your pick of which community amenity you will enjoy first. Windrose offers miles of hiking and biking trails nearby, many local restaurants, award-winning Klein ISD schools, a golf course, 2 pools, a tennis court, and half a dozen playgrounds and is minutes away from HWY 99 and 249. Schedule your viewing before this home is sold! OCTOBER 2022 UPDATES: New flooring, Upgraded guest bathroom, New dishwasher, New microwave, Entire home repainted, some New light fixtures, and some New blinds. The home has been deep cleaned and will have a touch-up cleaning prior to closing.' ,`Acres` = '0.1607' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 39 BLK 1 WINDROSE WEST SEC 15 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6998' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BENIGNUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Windrose West Sec 15 Amd' ,`TaxAmount` = '7113' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117901' WHERE `Matrix_Unique_ID` = '212631630' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T07:56:25.047' ,`MLSNumber` = '58382953' ,`ListAgentFullName` = 'Kelly Andel' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.547039' ,`Longitude` = '-95.762629' ,`PhotoCount` = '46' ,`PostalCode` = '77471' ,`RoomCount` = '4' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Kent Valley' ,`StreetNumber` = '1531' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2442' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This lovely 4 bed 3 bath Chesmar home is ready for new owners! Recent roof! This spacious open floor plan is IDEAL! Large dining room and kitchen are open to the living area for ample entertaining space. The stone fireplace in the living room is a show piece and keeps you warm in the winter! In this split floor plan, the primary as well as 2 additional bedrooms are downstairs. Upstairs is an addition bedroom or use as a game room with its own bathroom and closet! You’re sure to love the HUGE walk-in pantry and oversized laundry room! Brick patio for relaxing outside and part of the fence between neighbors has been recently replaced. Back fence is maintained by HOA. Make your appt to see this beauty today! ASK ABOUT ASSUMING SELLER MTG RATE of 4 PCT!' ,`Acres` = '0.1748' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'THE RESERVE AT BRAZOS TOWN CENTER SEC 1, BLOCK 2, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7612' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Reserve At Brazos Town Center Sec 1' ,`TaxAmount` = '7040' ,`TaxRate` = '2.7148' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117901' WHERE `Matrix_Unique_ID` = '212681297' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T07:04:25.860' ,`MLSNumber` = '98998473' ,`ListAgentFullName` = 'Colleen Sherlock' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.763260' ,`Longitude` = '-95.477087' ,`PhotoCount` = '45' ,`PostalCode` = '77056' ,`RoomCount` = '29' ,`ListPrice` = '4650000.00' ,`Status` = 'Active' ,`StreetName` = 'Russett' ,`StreetNumber` = '5506' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '3' ,`BedsTotal` = '6' ,`SqFtTotal` = '10228' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled on a private cul-de-sac on over an acre & built by renowned Goodchild Builders, this French Chateau-style home is one-of-a-kind. Exquisite finishes & features including reclaimed hardwoods & limestone floors, cast-stone adorning all 5 fireplaces, elevator to 3rd floor, and covered parking for 5 vehicles + gated motor court for additional parking. Grand entertaining formals throughout 1st floor + gourmet kitchen opens to family & breakfast rooms. Home offers 6 bedrooms, 6 full +3 half baths including 1st floor bedroom. 2nd floor Primary suite w/ impressive custom closet, luxurious bath, adjoining office & French doors to covered balcony w/ curved staircase to pool. 5 beds+ en-suite baths, billiards room, utility & office complete the 2nd story.3rd floor movie theatre w/ 22 seats.Whole-home generator, resort-style heated pool & spa, sprawling grounds & professional outdoor lighting & landscaping.Centrally located with close proximity to Houston’s finest offerings.All per Seller' ,`Acres` = '1.014' ,`Area` = '22' ,`BuilderName` = 'Goodchild Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '5' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 15 TANGLEWOOD SEC 10' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '44170' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'French,Traditional' ,`Subdivision` = 'Tanglewood' ,`TaxAmount` = '107196' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117901' WHERE `Matrix_Unique_ID` = '212837113' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T07:48:40.590' ,`MLSNumber` = '79994597' ,`ListAgentFullName` = 'Kelli Parker' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801224' ,`Longitude` = '-94.826975' ,`PhotoCount` = '29' ,`PostalCode` = '77523' ,`RoomCount` = '3' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Tremont' ,`StreetNumber` = '5818' ,`StreetSuffix` = 'Drive' ,`City` = 'Cove' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Price Improvement***Buyers ready to make some sweat equity or investors, this homes potential will blow you away! A few minor cosmetic upgrades would not only bring value but add to the already beautiful location and strong bones this home has to offer. Sitting on over half an acre in the highly sought after Plantation Subdivision & Barbers Hill ISD. Beautiful hardwood flooring in the open & spacious family & dining rooms. Ceramic tile in kitchen & breakfast with stainless appliances. Spacious Primary bedroom with ensuite that has a separate shower & soaking tub. Side drive for boat, golf cart or rec vehicle. Storage shed. Private neighborhood park & *bonus* Boat ramp to access the Trinity Bay.' ,`Acres` = '0.6' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 PLANTATION ON C B SEC 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '26136' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation-Cotton Bayou Sec 11' ,`TaxAmount` = '5242' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117901' WHERE `Matrix_Unique_ID` = '213109914' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T07:48:40.780' ,`MLSNumber` = '8763311' ,`ListAgentFullName` = 'Edelmira Pena' ,`ListOfficeName` = 'TAS Realty Group' ,`SellingAgentFullName` = 'Maria Martinez' ,`SellingOfficeName` = 'Tevas Real Estate Group INC' ,`Latitude` = '29.925908' ,`Longitude` = '-95.172939' ,`PhotoCount` = '50' ,`PostalCode` = '77044' ,`RoomCount` = '8' ,`ListPrice` = '345000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Brighton Park' ,`StreetNumber` = '13806' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2487' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This home has 4 spacious bedrooms and 2 baths. Great kitchen that opens to the family area, kitchen island, breakfast area and a large formal dining room. High ceilings throughout the home along with plenty of natural light. A new AC unit was installed Sept. 2022! New interior and exterior paint. No back neighbors! This home is in the subdivision of Summerwood. Summerwood offers great amenities - 2 pools, a splash pad for kids, fitness center, club houses, tennis courts, and nice trails to lakes and Deussen Park all of which are less than 5 minutes away!' ,`Acres` = '0.167' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 1 SUMMERWOOD SEC 11' ,`LotDesciption` = 'Other' ,`LotSize` = '7273' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SUMMERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Summerwood Sec 11' ,`TaxAmount` = '6865' ,`TaxRate` = '2.733' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117902' WHERE `Matrix_Unique_ID` = '213173960' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T07:28:06.193' ,`MLSNumber` = '34954690' ,`ListAgentFullName` = 'Alex Rezende' ,`ListOfficeName` = 'AroundTown Properties Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.617490' ,`Longitude` = '-95.196651' ,`PhotoCount` = '38' ,`PostalCode` = '77034' ,`RoomCount` = '9' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Southpoint' ,`StreetNumber` = '13226' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1864' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 1 story home features 3 bedrooms & 2 full baths located in the highly sought after Southway Landing community! The front elevation paired with the red brick exterior & clean landscaping is sure to make a great first impression. Hardwood flooring throughout all living areas! Natural light pours into the open concept design making for a very bright & enjoyable space to share with the family. The kitchen features a breakfast bar, built-in appliances, a custom tile backsplash, popular white wood cabinets & TONS of counter and storage space. This home has both a dining area and breakfast area allowing for formal or quick & easy meals. The private study with French doors is a great place to WFH or can even be converted into a Media room. The large Primary bedroom easily fits king-sized furniture w/ additional room for a seating nook & a MUST SEE primary bath! Spend your weekends relaxing in this peaceful backyard w/ a covered patio & plenty of extra space for the kids to play.' ,`Acres` = '0.0972' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 SOUTHWAY SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4235' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '355' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'GENOA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PASADENA)' ,`SchoolMiddle` = 'BONDY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southway Landing' ,`TaxAmount` = '5662' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117902' WHERE `Matrix_Unique_ID` = '213279919' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T07:48:32.370' ,`MLSNumber` = '29274423' ,`ListAgentFullName` = 'Melissa Siems' ,`ListOfficeName` = 'Taylor Real Estate Group, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.556883' ,`Longitude` = '-95.436897' ,`PhotoCount` = '16' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '435000.00' ,`Status` = 'Active' ,`StreetName` = 'Pebble Falls' ,`StreetNumber` = '13920' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2635' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a Gorgeous home built Perry Homes. The home is all brick and very open concept with tons of storage. Nice study with double glass doors. Wide entry hallway with wall space for painting and or photos. 4 bedrooms with large walk closets. Open DR with tons of natural lighting. granite island kitchen w/ SS appliances, open to LR. Spacious Primary Bedroom with high Ceiling and faux wood blinds throughout home. Primary Bathroom has double sinks, shower with separate tub. Huge walk-in closet with built-ins- Yard has Irrigation system, backyard has extended covered patio with ceiling fans. \r\n2 car garage with epoxy coated floors. Home shows beautifully!' ,`Acres` = '0.1989' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-56 REPLAT NO 1, BLOCK 1, LOT 31' ,`LotDesciption` = 'Corner' ,`LotSize` = '8665' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf-56 Rep 1' ,`TaxAmount` = '9220' ,`TaxRate` = '3.2123' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117902' WHERE `Matrix_Unique_ID` = '213293118' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T07:52:52.107' ,`MLSNumber` = '98477174' ,`ListAgentFullName` = 'Kelly Andel' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.324228' ,`Longitude` = '-95.594298' ,`PhotoCount` = '47' ,`PostalCode` = '77430' ,`RoomCount` = '4' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Kings Oak' ,`StreetNumber` = '8702' ,`StreetSuffix` = 'Drive' ,`City` = 'Damon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wow! This showstopper is ready for new owners! Welcome to your gated home at 8702 Kings Oak. This beautiful acreage tract is adorned with oak trees providing a park like setting. Take a dip in the pool (replastered, new pool light and pump 2022) and relax by your outdoor fireplace or under the recent pergola. 3 decks off the home to enjoy the nature views including a pond. Shop outside to store your tools! Inside you’ll find 4 bedrooms with a living space on each floor. The primary bedroom is large with a gorgeous en suite bath. Enjoy the oversized tub and oversized walk-in shower. Entire interior has been recently painted. The garage has central AC/Heat and wainscot and can be used as game room or garage. Outside there is also a large carport for extra parking space. Lovely kitchen ready for the chef of the family. Laminate flooring throughout, no carpet! Call today to schedule a showing at this ideal country property!' ,`Acres` = '3.5' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0003 THOS ALLSBERRY TRACT 23F3A1-23F3B ACRES 3.5' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '152460' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Thos Allsberry' ,`TaxAmount` = '4514' ,`TaxRate` = '1.6563' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117902' WHERE `Matrix_Unique_ID` = '213372292' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T07:56:28.947' ,`MLSNumber` = '98433825' ,`ListAgentFullName` = 'Robert McWilliams' ,`ListOfficeName` = 'Priority One Real Estate' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '28.690743' ,`Longitude` = '-96.268060' ,`PhotoCount` = '31' ,`PostalCode` = '77465' ,`RoomCount` = '6' ,`ListPrice` = '445000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Jensen' ,`StreetNumber` = '424' ,`StreetSuffix` = 'Drive' ,`City` = 'Palacios' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME TO PARADISE! This is your chance to live the waterfront dream! This home is perfect for anyone who loves the outdoors and wants to enjoy fishing, boating, and kayaking right from their backyard. This one of a kind property is located on Turtle Bay with access to West Matagorda and Tres Palacios Bays. The 300 ft. private pier includes 2 LED Green Lights, fish cleaning table, dock for your boat and benches to watch the sunset. The 2020 pier was assembled with SS hardware. The Jensen’s Point boat/kayak launch are near the home. The home faces South so you can enjoy beautiful sunsets without having the sun shining in your eyes. There are 2 BR, 1 bath upstairs. Downstairs has 2 rooms ready to be finished which include a full bath. Two large lots across the street are included giving you a total of nearly an acre.' ,`Acres` = '' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'JENSEN POINT S/D, LOTS 35-36 BLK 3 & LOT 40 BLK 4' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '156 - Palacios' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (PALACIOS)' ,`SchoolHigh` = 'PALACIOS HIGH SCHOOL' ,`SchoolMiddle` = 'PALACIOS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Jensen Point' ,`TaxAmount` = '' ,`TaxRate` = '2.18' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117902' WHERE `Matrix_Unique_ID` = '213419190' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T06:54:13.707' ,`MLSNumber` = '79485686' ,`ListAgentFullName` = 'Kara Puente' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Jeannette Beasley' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '30.041838' ,`Longitude` = '-95.502261' ,`PhotoCount` = '42' ,`PostalCode` = '77379' ,`RoomCount` = '10' ,`ListPrice` = '450000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Mountain Spring' ,`StreetNumber` = '18803' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning custom home on a corner lot in beautiful Spring Creek Oaks with all the bells and whistles. Sprawling one story home has a game room up. Loaded with many updates and upgrades including both air conditioners. Kitchen updated with granite and stainless-steel appliances. Wood floors, designer interior paint, custom built-ins and millwork throughout. 4 bedrooms, 3 full bathrooms, one with access to backyard and pool. Primary bedroom offers a sitting area and access to back and gorgeous updates in primary bathroom. Backyard oasis with pool and spa and 3 car side by side garage complete this showstopper. Call today for an appointment!' ,`Acres` = '0.2108' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 4 SPRING CREEK OAKS SEC 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9184' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '991' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KUEHNLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Creek Oaks' ,`TaxAmount` = '10005' ,`TaxRate` = '2.5965' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117903' WHERE `Matrix_Unique_ID` = '213462225' --> 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','213727191','1667117903','213727191','2022-10-29T07:37:51.467','81388072','John Hoover','Hoover Lake Conroe Group','','','30.417765','-95.551242','34','77318','6','275500.00','Active','Sunshine Park','12831','Drive','Willis','2','0','3','1464','Single-Family','Investors only. Tenant occupied until July 2023.\r\n\r\nAlmost new lightly lived in three bedroom and two bath brick home in developing subdivision of Summerwood Trails. Built by Stylecraft builders this property has a fully fenced and sodded back yard. Property is near Lake Conroe and is part of rapidly growing Willis area. Short drive to new shopping, schools, and public boat ramp on Lake Conroe.','0.1421','39','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure,Tenant Occupied','1','','','Lake Conroe Area','Central Gas','1','S906900 - SUMMERWOOD TRAILS 01, BLOCK 5, LOT 8','Cleared,Subdivision Lot','6191','Appraisal District','','500','0','','2','','0','','','Gas Range','','Composition','56 - Willis','W. LLOYD MEADOR ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','ROBERT P. BRABHAM MIDDLE SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','Summerwood Trails 01','4813','2.2948','Public Sewer,Public Water','2020','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','213727291','1667117903','213727291','2022-10-29T07:33:30.543','18689941','John Hoover','Hoover Lake Conroe Group','Jessica Bohlmann','Hoover Lake Conroe Group','30.377491','-95.648376','33','77316','8','205000.00','Option Pending','Sunrise Pines','18487','Drive','Montgomery','2','0','3','1342','Single-Family','Lovely recently updated three bedroom two bath well maintained home. Stainless steel appliances, granite , updated wood look tile plank floors, screened patio, and lush landscaping make this property highly desirable. Award winning Montgomery School District zoned for new Lake Creek High School. Low annual HOA dues. Washer, dryer, and refrigerator included.\r\n\r\nProperty is currently rented for $1700/month with a month to month lease. Lease can be exited with thirty day prior month notice or renegotiated upon sale. Please do not disturb tenants without appointment.','0.1263','39','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Tenant Occupied','1','Gas Connections','1','Lake Conroe Area','Central Gas','1','S909204 - SUNRISE RANCH 04, BLOCK 1, LOT 70','Subdivision Lot','5500','Appraisal District','','200','0','','2','','0','','','Electric Range','','Composition','37 - Montgomery','STEWART CREEK ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Sunrise Ranch 04','2948','1.8242','Other Water/Sewer','2004','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213754981','1667117903','213754981','2022-10-29T06:45:35.650','67183483','Marlena Wyckoff','Clearstone Realty','','','29.691355','-95.537633','12','77036','6','225000.00','Active','La Roche Lane','7915','Lane','Houston','2','0','3','1700','Single-Family','HURRY, This best buy will not last long! Great floor plan with 3/2/2. A/C was replaced in 2019, new composition roof in 2016 and exterior painted May 2022. All 4 sides brick. Spacious kitchen with lots of counter space. Large breakfast area. Family huge family room. Front room can be used for formal dining, formal living, office space, or a game room the options are endless! Primary bedroom has his and her closets . Huge and beautiful back yard. Plenty of room for a pool. Premium location with easy access to I59 and Beltway 8. This home just needs some TLC. Be in your new home for the holidays !','0.1845','21','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Sharpstown Area','Central Gas','1','TRS 3A & 4 BLK 51 SHARPSTOWN COUNTRY CLUB TERRACE SEC 3','Subdivision Lot','8035','Appraisal District','','250','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','27 - Houston','WHITE ELEMENTARY SCHOOL','SHARPSTOWN HIGH SCHOOL','SUGAR GROVE MIDDLE SCHOOL','Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Sharpstown Country Club Terrac','4723','2.3307','Public Sewer,Public Water','1967','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','213817683','1667117903','213817683','2022-10-29T06:15:17.710','21827438','Sandra Sawyer','Walzel Properties','','','29.645732','-95.225982','17','77034','8','219999.00','Active','Edgebrook','531','Drive','Houston','2','0','3','1390','Single-Family','You’ve got to come see all the updates in this recently remodeled home! Windows, A/C, furnace, bathrooms, stainless appliances including double-oven, water heater, cabinets, lighting, flooring, all recently replaced. Vacant and ready to move in! Conveniently located to I-45 & Beltway 8 (Sam Houston tollway), you can zip to downtown, or all around Houston, or down to the beach! And no HOA for added freedoms with ownership!','0.1655','3','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','','','Hobby Area','Central Gas','0','LT 8 BLK 56 FREEWAY MANOR SEC 7','Subdivision Lot','7209','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','41 - Pasadena','FREEMAN ELEMENTARY SCHOOL (PASADENA)','SOUTH HOUSTON HIGH SCHOOL','MILLER INTERMEDIATE SCHOOL','Accompany,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern','Freeway Manor','3777','2.6863','Public Sewer,Public Water','1956','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T07:56:57.057' ,`MLSNumber` = '11370558' ,`ListAgentFullName` = 'Melissa Sumrall' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.818063' ,`Longitude` = '-94.995000' ,`PhotoCount` = '29' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Sprangletop' ,`StreetNumber` = '4318' ,`StreetSuffix` = 'Avenue' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1632' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED! LOW TAX RATE! This 1 Story 3 Bedroom 2 Bath home has been immaculately kept! Perfect size yard for a pool and storage building. Some of its features are granite countertops in the kitchen, stylish tile back-splash, walk-in soaking tub with separate shower in the primary bathroom, walk-in closet, designer cabinets, crown molding, private utility room, and a private covered patio in the perfect sized backyard. Enjoy preparing meals in this impressive kitchen equipped with ample cabinets and generous counter space, the kitchen is an open concept with a breakfast bar/eat in kitchen with pantry. Don\'t wait! Make this beautiful home yours today.' ,`Acres` = '0.1309' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 109 BAY RIVER COLONY SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Right Side,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay River Colony Sec 1' ,`TaxAmount` = '5043' ,`TaxRate` = '2.705' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117903' WHERE `Matrix_Unique_ID` = '213943046' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T07:15:45.840' ,`MLSNumber` = '38815610' ,`ListAgentFullName` = 'Charles Adams' ,`ListOfficeName` = 'Landmark Income Prop., Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.612011' ,`Longitude` = '-95.604373' ,`PhotoCount` = '43' ,`PostalCode` = '77478' ,`RoomCount` = '8' ,`ListPrice` = '490000.00' ,`Status` = 'Active' ,`StreetName` = 'COUNTRY CLUB' ,`StreetNumber` = '1921' ,`StreetSuffix` = '' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2625' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely remodeled and Ready for Move In! 2022: Brand New Pex Plumbing, Toilets, Bath and Kitchen Fixtures, Hot Water Heater, New Wood Plank Tile Floors (Carpet in the secondary bedrooms and Walk in Closets), New Can LED Lighting, Fans, Electrical Fixtures and Breaker Box. Under Cabinet Lighting in Kitchen, Completely remodeled Primary Bath and Secondary Bath and half bath. Brand new counter tops throughout. Completely scrubbed of Wallpaper and popcorn ceilings with fresh sheetrock and fresh new paint of the entire home. Updated stainless steel appliances in kitchen with brand new wifi enabled Double Oven. Stainless steel Samsung refrigerator stays with home; if needed. Utility Room has a space for a second refrigerator as well.' ,`Acres` = '0.2187' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUGAR CREEK SEC 24, BLOCK 3, LOT 40' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '9526' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'DULLES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Sugar Creek' ,`TaxAmount` = '7643' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117903' WHERE `Matrix_Unique_ID` = '213969480' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T07:44:47.983' ,`MLSNumber` = '89142027' ,`ListAgentFullName` = 'Fariborz Shojai' ,`ListOfficeName` = 'F S Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750769' ,`Longitude` = '-95.488896' ,`PhotoCount` = '26' ,`PostalCode` = '77057' ,`RoomCount` = '6' ,`ListPrice` = '899987.00' ,`Status` = 'Active' ,`StreetName` = 'Potomac' ,`StreetNumber` = '1632' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Potomac @ San Felipe, gated. Galleria area. Location. Location. Location. Open floor plan with custom finishes, custom cabinetry & hardwood floors throughout. First floor living with Study/Office. Gourmet Kitchen includes 48\" subzero Viking refrigerator, 48\'\' range, floor to ceiling cabinets, large island, walk-in pantry and mud room. All 4 Bedrooms located on the second floor. Spacious master BR, M Bath & M Closet. JELD-WEN: French doors & windows make this home very quiet & well insulated. Three (3) separate AC units (16 seer Trane) for each floor would reduce electricity consumptions. Breath taking 3rd floor with skyline view: Loft/ Game room, wet bar, full bath & rooftop make this stunning home great for living & entertaining. This beautiful home has it all: OFFICE, YARD, WET BAR, LOFT & ROOFTOP. Zoned to Briargrove elementary.' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 1 POTOMAC GARDENS' ,`LotDesciption` = 'Corner' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Other Style' ,`Subdivision` = 'Potomac Gardens Subdivision' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667117903' WHERE `Matrix_Unique_ID` = '213984832' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T06:51:28.113' ,`MLSNumber` = '54408628' ,`ListAgentFullName` = 'Claudette Callebs' ,`ListOfficeName` = 'Taylor Real Estate Group, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.085803' ,`Longitude` = '-95.189078' ,`PhotoCount` = '22' ,`PostalCode` = '77365' ,`RoomCount` = '8' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Willow Park Terrace' ,`StreetNumber` = '5803' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2603' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Village Builders \"Claremore\" floor plan in the livable forest. One of the best 1 story plans in the community. Well-appointed and very current finishes. Light and bright with dramatic 11ft ceilings. Designer touches throughout - custom blinds, lighting, counters and paint. Finishes are in line with current trends with white kitchen, light stone counters and light, neutral paint on the walls. Kitchen has upgraded SS appliances and 5 burner gas cooktop. Large island with sink, granite counters and pendant lighting. Large laundry room with storage space and room for an additional refrigerator. Covered patio in your private treelined back yard has been extended with pavers for additional outdoor entertaining space and outdoor speakers. Garage with additional storage systems, shelving, hanging and professionally finished flooring. Full sprinkler system. Wired for Christmas Lights under the eaves. Keyless front entry.' ,`Acres` = '0.1701' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 2 ROYAL BROOK AT KINGWOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7409' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ELM GROVE ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Royal Brook/Kingwood Sec 1' ,`TaxAmount` = '8245' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117904' WHERE `Matrix_Unique_ID` = '214074848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T06:22:54.863' ,`MLSNumber` = '52690214' ,`ListAgentFullName` = 'Pricilla Davidson' ,`ListOfficeName` = 'Executive Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.647423' ,`Longitude` = '-95.463535' ,`PhotoCount` = '21' ,`PostalCode` = '77340' ,`RoomCount` = '15' ,`ListPrice` = '649900.00' ,`Status` = 'Active' ,`StreetName` = 'Brandenburg' ,`StreetNumber` = '11' ,`StreetSuffix` = 'Lane' ,`City` = 'Huntsville' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3294' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning home is located in a nice small private subdivision in the country.A 2-story custom build on 2 acres of land. A 75-foot antenna for High-Speed internet,lg rooms, game room & theatre room. Theatre is equipped w/ 5.1 Dolby Digital Surround Sound, 110” screen and ceiling mounted projector.It has a 3-car garage. A beautiful 42-foot pool. The pool & patio are covered with cool deck,which lowers the temperature of the concrete, and the fenced in backyard can be enjoyed by your dogs with room to run. There is also a 10x12 pool shed for your storage needs.The primary bedroom has a spacious OVER-SIZED dual head shower, jacuzzi tub and walk-in closet.A second bedroom boasts large sleeping quarters with a full en-suite bathroom as well.Crown molding in all the main rooms accents the high ceilings.Upgrades include a 3-year-old roof,& 400 sq ft concrete metal building equipped w/ electricity/water.' ,`Acres` = '2' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HARRELL ESTATES, LOT 12, ACRES 2.0' ,`LotDesciption` = 'Cleared,Subdivision Lot,Wooded' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'ESTELLA STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrell Estates' ,`TaxAmount` = '7406' ,`TaxRate` = '1.5942' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117904' WHERE `Matrix_Unique_ID` = '214097348' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T07:23:19.997' ,`MLSNumber` = '60730846' ,`ListAgentFullName` = 'Luis Zelaya' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.827805' ,`Longitude` = '-95.781383' ,`PhotoCount` = '49' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '540000.00' ,`Status` = 'Active' ,`StreetName` = 'Kingsford Shadow' ,`StreetNumber` = '23522' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4098' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beauty offers attractive curb appeal and a lush green landscape. Discover a fantastic interior filled with so much natural light, a neutral palette, beautiful wood-look flooring, and high ceilings. His and her study greets you as soon as you enter! It makes this home so convenient as more work from home!! An ample formal dining room awaits your guests!! Continue onto the family room to find an impressive stone fireplace. The eat-in kitchen is a chef\'s dream! Built-in double ovens, S/S appliances, granite countertops, cabinets w/crown molding, a well-sized pantry, recessed & pendant lighting, a breakfast bar, and a center island. The spacious loft is ready to make it your own. Inside the primary bedroom, you\'ll find a lavish en suite with dual sinks, a garden tub, and walk-in closet. His and Her closet also are so much more convenient!! A huge backyard with a covered patio is perfect for your gatherings. Hurry come see it!' ,`Acres` = '0.1713' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 41 BLK 2 KATY TRAILS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7464' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Split Level' ,`Subdivision` = 'Katy Trls Sec 1' ,`TaxAmount` = '12329' ,`TaxRate` = '3.3333' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117904' WHERE `Matrix_Unique_ID` = '214135178' --> 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','214137350','1667117904','214137350','2022-10-29T06:45:07.133','46205709','Pricilla Davidson','Executive Real Estate','','','30.526010','-95.232479','22','77328','6','319000.00','Active','Major','450','Road','Cleveland','2','0','3','2046','Single-Family','Nestled in the heart of San Jacinto County, this home has stunning views. This newly remodeled 3/2 with a bonus room features a renovated kitchen, fresh paint throughout, new receptacles and covers, etc. The bonus room has the potential to add an additional bath / storage. Imagine sitting on the front porch listening to the serene noises of the birds chirping in the distance. Bring your RV and hook it up using the outside RV connections available. An additional 4-5 acres is available for purchase for an additional amount. This home is constructed with 2x6 walls. The roof was replaced one year ago and has a 30 year manufacturers warranty. Not to mention the decking is 5/8\" thick. Don\'t miss out on this opportunity to own your own piece of country living at it\'s finest.','1.178','64','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Coldspring/South San Jacinto County','Central Gas','0','A014 VITAL FLORES, TRACT 104.9, ACRES 1.178','Cleared,Corner,Wooded','51314','Appraisal District','','','0','','2','Gas Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','101 - Coldspring-Oakhurst Consolidated','JAMES STREET ELEMENTARY SCHOOL','COLDSPRING-OAKHURST HIGH SCHOOL','LINCOLN JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front','Appraisal District','1','Ranch','Unknown','3689','1.6254','Other Water/Sewer,Septic Tank','1991','Seller'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T06:33:23.830' ,`MLSNumber` = '55248782' ,`ListAgentFullName` = 'Brady Burnett' ,`ListOfficeName` = 'Burnett Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799074' ,`Longitude` = '-95.483070' ,`PhotoCount` = '29' ,`PostalCode` = '77055' ,`RoomCount` = '4' ,`ListPrice` = '889990.00' ,`Status` = 'Active' ,`StreetName` = 'Janak' ,`StreetNumber` = '7803' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3611' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction for December Move in. Beautiful home with designer finishes. Many upgraded features. Please call for appointment. Animated photos included as proposed design features.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'Dacasa Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 3 Blk 1 Melody Oaks Replat' ,`LotDesciption` = 'Corner' ,`LotSize` = '4202' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TREASURE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Melody Oaks Replat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667117904' WHERE `Matrix_Unique_ID` = '214165622' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T07:18:23.117' ,`MLSNumber` = '52767780' ,`ListAgentFullName` = 'Annie Hewitt' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.765029' ,`Longitude` = '-95.566514' ,`PhotoCount` = '42' ,`PostalCode` = '77079' ,`RoomCount` = '12' ,`ListPrice` = '1749000.00' ,`Status` = 'Active' ,`StreetName` = 'Hermitage' ,`StreetNumber` = '12954' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5487' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to get into the highly-coveted Memorial Glen neighborhood. The house is walking distance to Terry Hershey Park\'s 500+ acres of green space which includes a pathed running and biking trail. It is also an easy bike or golf cart ride to the neighborhood pool, home of the mighty Barracudas swim team! The house has a formal dining room, two offices, a beautiful family room with cathedral ceiling, a fabulous kitchen that was completely renovated in 2018 and a massive upstairs playroom. Very spacious primary suite is downstairs. Four secondary bedrooms are upstairs. Two of the secondary bedrooms have their own bathrooms, and the other two share. The playroom has a full bathroom and could be converted to an extra bedroom suite. Large laundry room is upstairs. There is also a stackable washer/dryer in the primary closet. Outdoor kitchen leaves enough room for green space and a small pool.' ,`Acres` = '0.202' ,`Area` = '23' ,`BuilderName` = 'Morgan Moore' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 3 MEMORIAL GLEN SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'RUMMEL CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Glen' ,`TaxAmount` = '44723' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117905' WHERE `Matrix_Unique_ID` = '214170584' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T06:37:04.540' ,`MLSNumber` = '69683936' ,`ListAgentFullName` = 'Dorothy Roberts' ,`ListOfficeName` = 'Creekwood Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.923598' ,`Longitude` = '-95.248226' ,`PhotoCount` = '22' ,`PostalCode` = '75862' ,`RoomCount` = '4' ,`ListPrice` = '149000.00' ,`Status` = 'Active' ,`StreetName` = 'Kingwood' ,`StreetNumber` = '530' ,`StreetSuffix` = 'Drive' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this unique 2 bedroom, 2 bath cabin located in a manned, gated community at Lake Livingston. Are you looking for a weekend retreat? Or possibly planning to retire? Or just starting out? This cute home can be the one for you. With nice, quiet neighbors you can enjoy the peace and quiet of Harbor Point designed to accommodate its residents. Take a look - you\'ll be glad you did!' ,`Acres` = '0.2837' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'HARBOR POINT SECTION I, LOT 074' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12357' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '59 - Groveton' ,`SchoolElementary` = 'GROVETON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GROVETON J H-H S' ,`SchoolMiddle` = 'GROVETON J H-H S' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Harbor Point Sec I' ,`TaxAmount` = '1674' ,`TaxRate` = '1.5582' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117905' WHERE `Matrix_Unique_ID` = '214177940' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-29T07:51:46.103' ,`MLSNumber` = '24211660' ,`ListAgentFullName` = 'Helen Nguyen' ,`ListOfficeName` = 'LV Realty & Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.970747' ,`Longitude` = '-95.615535' ,`PhotoCount` = '27' ,`PostalCode` = '77429' ,`RoomCount` = '10' ,`ListPrice` = '639000.00' ,`Status` = 'Active' ,`StreetName` = 'Lismore Lake' ,`StreetNumber` = '12131' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3659' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'It will your breath away at Lismore Lake Estate Year round at home vacation. Tranquility water view and gorgeous\r\nswimming pool. This 5 bed rooms, 3.5 baths home is situated on large corner lot and water front. Beautiful landscaping. Elegant entrance with wood flooring, wrought iron stair case. High ceiling in the living. Kitchen is open to the family room. Primary room and game room have back yard water view. Just relaxation!!! Enjoy a cup coffee\r\nat the balcony. New Roof 2020. Zoned to highly acclaimed CFISD schools. Ready to move in this Thanks Giving or Christmas' ,`Acres` = '0.2037' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 107 BLK 1 LISMORE LAKE ESTATES' ,`LotDesciption` = 'Corner,Waterfront' ,`LotSize` = '8874' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Left Side,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lismore Lake Estates' ,`TaxAmount` = '11072' ,`TaxRate` = '2.7587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667117905' WHERE `Matrix_Unique_ID` = '214195206' --> Updated record success