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-04T06:10:06.270' ,`MLSNumber` = '76288148' ,`ListAgentFullName` = 'Gary Bailey' ,`ListOfficeName` = 'Gary S. Bailey' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.004217' ,`Longitude` = '-95.478402' ,`PhotoCount` = '46' ,`PostalCode` = '77068' ,`RoomCount` = '11' ,`ListPrice` = '665000.00' ,`Status` = 'Active' ,`StreetName` = 'Villa Fontana Way' ,`StreetNumber` = '16139' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3732' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Superb Luxury Golf Course Patio Home on Large Lot with Excellent Water and Golf Course Views! Gated Entry. Two Bedrooms Downstairs, and Two Bedrooms Upstairs, each with full baths. Kitchen Open to the den for family gathering and entertaining. Breakfast Area with views of the Golf Course and ponds create the perfect setting for a relaxing morning breakfast. Raised Study on Stairway has privacy- easy access.Second Bedroom on First Floor is tucked away and has an entry from the outside and via the garage for a quite, private and easy access.Flooring is a combination of Travertine and beautiful Engineered Wood! Gameroom Upstairs has a covered Balcony and plenty of room outside to view the Golf Course and Distant Golfers trying to avoid the scenic Water Ponds. Back Yard Bar B Que with a sizeable play area and covered patio for outdoor grilling. Excellent home for relaxation and backyard enjoyment. Two New AC Units with 17 SEER Ratings! Room for swimming pool(All Measurements Not Exact).' ,`Acres` = '' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 19 Block 1 Northgate Forest Place' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Patio Lot,Subdivision Lot' ,`LotSize` = '9596' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3680' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Northgate Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894065' WHERE `Matrix_Unique_ID` = '206304508' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:36:32.417' ,`MLSNumber` = '5308940' ,`ListAgentFullName` = 'Elizabeth McCormick' ,`ListOfficeName` = 'Compass RE Texas, LLCHeights' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811415' ,`Longitude` = '-95.455424' ,`PhotoCount` = '22' ,`PostalCode` = '77092' ,`RoomCount` = '6' ,`ListPrice` = '439000.00' ,`Status` = 'Active' ,`StreetName` = 'Randwick' ,`StreetNumber` = '4411' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2057' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Light & Bright with fresh BEHR paint throughout & LED recessed lighting added. A beautifully updated 3 bedroom/2 bathroom home in Brook-Woods Estates sits on an oversized lot convenient to North 610 Loop, Downtown & Galleria. You enter the home from a covered porch to a foyer flanked by closets. The home is spacious & has a well planned out split floor plan. You\'ll enjoy entertaining in the open concept living/dining/kitchen. The island kitchen features saltillo tile, maple cabinets, under cabinet lights, Samsung appliances & granite countertops. The huge primary suite is a fabulous retreat w/views of the backyard through French doors & bay window. Also included is a gas fireplace & two skylights for plenty of natural light. The primary bathroom boasts a soaking tub, separate shower, dual sinks & walk-in closet. The backyard is great for relaxing, play or entertaining w/plenty of room for a pool. Did not flood during Allison & Harvey. Did not lose power during FREEZE *per seller.' ,`Acres` = '0.3017' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 59 BLK 3 BROOK-WOODS ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13141' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Brook-Woods Estates' ,`TaxAmount` = '7388' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894065' WHERE `Matrix_Unique_ID` = '208130608' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:00:28.847' ,`MLSNumber` = '70660959' ,`ListAgentFullName` = 'Christopher Phan' ,`ListOfficeName` = 'Truss Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.847938' ,`Longitude` = '-95.447964' ,`PhotoCount` = '31' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Paul Quinn' ,`StreetNumber` = '2625' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Oracle City Home\'s \"Paul Quinn\" project features 24 units in a privately gated community in one of Houston\'s hottest up-and-coming neighborhoods: Acres Homes. This is 1 of 2 distinct floorplans meticulously designed inside and out with stunning elevations and interior designs that redefine the standard for farmhouse modern homes. 1st floor has an additional office/flex space great for working from home or any new addition. The 2nd floor embodies an open floorplan and professional design with hand selected bold finishes to create stunning interior décor. The kitchen features a spacious island, complimented by beautiful cabinetry, generous back countertops, and grand backsplash. All bedrooms up 3rd floor, primary is set with shiplap wall, ensuite is dressed to impress with features such as oversized shower, his/her sinks, and walk-in closet. Welcome to Paul Quinn! RENDERS ARE NOT EXACT AND SOME MATERIALS ARE SUBJECT TO CHANGE DUE TO LACK OF INVENTORY UPON ORDERING.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Oracle City Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14, Blk 1, Northwest Landing' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1627' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Northwest Landing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664894065' WHERE `Matrix_Unique_ID` = '208186363' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:20:24.947' ,`MLSNumber` = '19260885' ,`ListAgentFullName` = 'Thomas Heilman' ,`ListOfficeName` = 'Zion Premier Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.791758' ,`Longitude` = '-95.096860' ,`PhotoCount` = '28' ,`PostalCode` = '77360' ,`RoomCount` = '5' ,`ListPrice` = '234000.00' ,`Status` = 'Active' ,`StreetName` = 'Brown' ,`StreetNumber` = '114' ,`StreetSuffix` = 'Avenue' ,`City` = 'Onalaska' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1188' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come take a look at this unique property on interior, corner lots just under 2/3 ac.& less than 1/4 mile from Lake Livingston. Subdivision is outside the city limits and neighborhood borders the lake. This is NOT a mobile home! Rustic/cabin feel with open living area, large 40 x 30 workshop/living area with full bathroom, sleeping quarters and kitchen, 10 x 16 screened porch, fenced back yard with an above ground pool. 15 x 11 screened in rear porch, 11 x 10 rear deck. Nearby boat launch. Virtual walk-through tour is available for you to walk through the property. Just click the movie reel and let your mouse be your feet! Please Note: Hot tub is not included with the sale.' ,`Acres` = '0.6483' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'STOWAWAY BAY LOT 18 & 19' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '28239' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Stowaway Bay' ,`TaxAmount` = '3293' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894066' WHERE `Matrix_Unique_ID` = '208434134' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:38:22.677' ,`MLSNumber` = '9165933' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.471021' ,`Longitude` = '-95.530345' ,`PhotoCount` = '22' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Waters Branch' ,`StreetNumber` = '1830' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2446' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Privacy important? Newmark Homes agrees so no back neighbors on this jewel, just big trees! This beauty has 2 bedrooms/bathrooms downstairs and 2 bedrooms up with a large game room and media room. Open stair railing, built in appliances and the open airy floor plan are a must see for your family. Tankless water heater, full gutters and irrigation are yours, as well.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 1 Sienna Section 29A' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '6335' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric 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' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Sienna 45\'' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664894066' WHERE `Matrix_Unique_ID` = '208741869' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:01:18.483' ,`MLSNumber` = '82846385' ,`ListAgentFullName` = 'Shara Hymowitz' ,`ListOfficeName` = 'Houston Home Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.723485' ,`Longitude` = '-95.381142' ,`PhotoCount` = '10' ,`PostalCode` = '77004' ,`RoomCount` = '6' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Chenevert' ,`StreetNumber` = '5305' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2353' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'From award-winning homebuilder, ROC Homes, this 2-story freestanding new construction features a rare \"1st Floor Lifestyle\" in the heart of the Museum District. The 1st floor features your kitchen, living and casual dining space, and all bedrooms are on the 2nd floor. \r\nGenerous oversized backyard (estimated 20\' deep x 30\' wide)\r\nHome is estimated to be complete by October 2022. Walking distance to great restaurants, bars, shops, great area to live!!' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = 'ROC Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'na' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Museum District' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664894066' WHERE `Matrix_Unique_ID` = '209013624' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T06:52:43.253' ,`MLSNumber` = '92409689' ,`ListAgentFullName` = 'Sonja Patterson' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.491279' ,`Longitude` = '-96.283339' ,`PhotoCount` = '49' ,`PostalCode` = '77845' ,`RoomCount` = '10' ,`ListPrice` = '1599000.00' ,`Status` = 'Active' ,`StreetName` = 'Saddle Creek' ,`StreetNumber` = '17899' ,`StreetSuffix` = 'Drive' ,`City` = 'College Station' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5302' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Builder\'s personal home! Quality built with upgrades galore and nestled on 4.25 acres! Foyer opens to the living’s 13’ ceilings, 5x7 windows and floor to ceiling stone fireplace. Alder cabinets finish the kitchen’s lg island, 2ovens, walk-in pantry, 2 dishwashers, instant hot H2O, and RO system! 4x7 windows and 8’ glass door allow spectacular views from dining rm. Back porch includes a dining area w stone fireplace. The primary BR has 5x7 windows, pop-ceiling, and private porch! Its bath boasts jacuzzi tub, a 5’x5’ shower with 4 heads, dual vanities, linen, and a large w-i-c. Study has w-i-c with structured wiring endpoint. A pair of lg bedrooms located near the kitchen share a full bath with stand-up shower. Each room has a wall of built-ins, window seat, desk, and TONS of storage. Guest rm has easy access to laundry and kitchen with private porch for guests to enjoy. HUGE insulated workshop for your projects and extra parking space! Plenty of space for your dream POOL and more!' ,`Acres` = '4.26' ,`Area` = '61' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SADDLE CREEK PH 6, BLOCK 6, LOT 149R1' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '185391' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '8' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '153 - College Station' ,`SchoolElementary` = 'GREEN PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'A & M CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WELLBORN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Saddle Creek Ph 6' ,`TaxAmount` = '15097' ,`TaxRate` = '1.7344' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894066' WHERE `Matrix_Unique_ID` = '209279293' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T06:38:29.943' ,`MLSNumber` = '74733744' ,`ListAgentFullName` = 'Alejandro Soules-Lara' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.674423' ,`Longitude` = '-95.532907' ,`PhotoCount` = '50' ,`PostalCode` = '77340' ,`RoomCount` = '10' ,`ListPrice` = '435000.00' ,`Status` = 'Active' ,`StreetName` = 'Hillcrest' ,`StreetNumber` = '639' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3072' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING 3 bedroom, 3 full-bath home sitting on nearly ½ of an acre lot in the highly sought-after Elkins Lake golf community, featuring 3,492 yards of golf field, designed by Texas Hall of Fame Member Ralph M Plummer. GREAT floor plan, high ceilings huge living room, breakfast room, formal dining, come sit by the fire. Wonderful primary bath and vanity, home/study in the house and an additional study/bedroom in garage. This house has a HUGE custom made 2-level deck with 1,587 SF built for special events with built-in grill and furniture inclued, a 175 SF covered porch also furniture included, sprinkler’s system, U-shaped driveway with 2-point access to the street with easy access to I 45, shopping, golf, lakes and hospitals. Roof is ONLY 2 years old.' ,`Acres` = '0.4642' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ELKINS LAKE - SEC 2, BLOCK 18, LOT 18 & 19' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '20220' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '198' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric 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,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elkins Lake' ,`TaxAmount` = '7367' ,`TaxRate` = '1.9609' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894066' WHERE `Matrix_Unique_ID` = '210332688' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:58:47.670' ,`MLSNumber` = '10471777' ,`ListAgentFullName` = 'Ivette Patino' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.707351' ,`Longitude` = '-95.749152' ,`PhotoCount` = '35' ,`PostalCode` = '77450' ,`RoomCount` = '6' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Field Manor' ,`StreetNumber` = '20942' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2089' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning one story home! Located in a quiet cul-de sac street, walking distance from neighborhood parks, Beautiful bamboo floors throughout home, completely remodeled kitchen (quartz counter tops, new appliances, chef\'s dream island) plantation shutters, open concept, sprinkler system, French drains, spacious secondary bedrooms, and much more!' ,`Acres` = '0.1515' ,`Area` = '36' ,`BuilderName` = 'PERRY' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND LAKES PHASE THREE SEC 9, BLOCK 1, LOT 7' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ALEXANDER ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Lakes Ph Three Sec 9' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894066' WHERE `Matrix_Unique_ID` = '210390854' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:41:29.110' ,`MLSNumber` = '42476076' ,`ListAgentFullName` = 'Gaye Hale' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.669197' ,`Longitude` = '-95.936844' ,`PhotoCount` = '43' ,`PostalCode` = '77441' ,`RoomCount` = '10' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Wentworth' ,`StreetNumber` = '4715' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3277' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 1 story home sits on the golf course and is perfect for entertaining. Large covered patio with views of golf holes #7 and #17. New carpet in all bedrooms & dining room. Spacious kitchen with large granite island. Has a study with a closet that can be used as a 4th bedroom. Large 3 car garage. Refrigerator stays with home.' ,`Acres` = '0.7014' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTON LAKES SEC 7, BLOCK 6, LOT 79 & 80' ,`LotDesciption` = 'Corner,In Golf Course Community,On Golf Course' ,`LotSize` = '30553' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MORGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Weston Lakes Sec 7' ,`TaxAmount` = '9325' ,`TaxRate` = '2.1698' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894067' WHERE `Matrix_Unique_ID` = '210651683' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:46:38.690' ,`MLSNumber` = '18449702' ,`ListAgentFullName` = 'Jennifer Arnold' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = 'Kaley Pogue' ,`SellingOfficeName` = 'Boom Real Estate' ,`Latitude` = '29.911990' ,`Longitude` = '-95.063309' ,`PhotoCount` = '32' ,`PostalCode` = '77532' ,`RoomCount` = '7' ,`ListPrice` = '229000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Runneburg' ,`StreetNumber` = '511' ,`StreetSuffix` = 'Road' ,`City` = 'Crosby' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '864' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Super cute home in Downtown Crosby. This 3 bed/1 bath home on four lots, would be a perfect starter home, rental, or investment. Home has been updated with fresh paint on exterior and all interiors. New carpet throughout. Kitchen updated with newly painted cabinets, replaced microwave and gas oven 2019, and refrigerator stays. Off the kitchen you will find a Mud room or extra room. House was leveled 4 years ago, AC newly serviced, and resurfaced bathtub. Outside you will find a fully insulated with Ac 10x14 She shed or laundry area that has new paint in/out. Detached 12x36 shop with 14x24 garage. Outside Bedroom/office 10x24 with full bath. Possibilities are endless. This property has so much to offer!! Location is everything, and this home has got it, with all that Crosby has to offer at the touch of your fingertips and Highway 90 just a minute away. No HOA. No flooding per the seller.' ,`Acres` = '0.1515' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 7 & 8, 9, and 10 BLK 12 BURRIS SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '13068' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Burris' ,`TaxAmount` = '1520' ,`TaxRate` = '2.5468' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894067' WHERE `Matrix_Unique_ID` = '210882468' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:08:29.977' ,`MLSNumber` = '88413794' ,`ListAgentFullName` = 'Shlomo Cohen' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Shelley Stone' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.682585' ,`Longitude` = '-95.433878' ,`PhotoCount` = '20' ,`PostalCode` = '77025' ,`RoomCount` = '7' ,`ListPrice` = '565000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Latma' ,`StreetNumber` = '3526' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1913' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully remodeled from A-Z! This gorgeous home is perfectly located inside the loop, zoned to Bellaire high school, and nearby multiple parks and bike trails. The open concept living room area and kitchen have stunningly high ceilings and plenty of natural light. The luxurious kitchen features a massive center island, quartz countertops, soft-close cabinets, and brand new state of the art appliances. Real hardwood floors throughout the house. Additional updates include NEW plumbing system - PVC sewer lines and PEX supply lines, NEW electrical wiring and panel box, tankless water heater, Low-E windows, outdoor pergola and more!' ,`Acres` = '0.1543' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Knollwood/Woodside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 BLK 12 WOODSIDE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LONGFELLOW ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodside Sec 02' ,`TaxAmount` = '9523' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894067' WHERE `Matrix_Unique_ID` = '211034425' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T06:22:16.560' ,`MLSNumber` = '94290045' ,`ListAgentFullName` = 'Jonna Stanley-Jones' ,`ListOfficeName` = 'Pinnacle Realty Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.841719' ,`Longitude` = '-95.380319' ,`PhotoCount` = '43' ,`PostalCode` = '77320' ,`RoomCount` = '8' ,`ListPrice` = '129900.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Wood' ,`StreetNumber` = '13' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1048' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICE REDUCTION INSPIRED BY RISING INTEREST RATE!!!! Cute 2/3 bedroom home in highly desirable home only Riverside Lakeland. 2 regular bedrooms downstairs and a 12x16 upstairs loft that could easily be a 3rd bedroom. House is on 3 lots (0.5 acres) & has tons of outside storage for all your Lake Toys. Metal Roof. All appliances (fridge, washer, dryer) remain. Very quiet street. 2 separate fenced in areas. Nice screened in front porch. Includes the following buildings: House (1048 sqft), main shed next to house (13x25), Double Bay Shed (20x20), Lean-to (14x14), pole barn (22x28), secondary garage/shed (18x40, which includes a 10x16 \"man cave\"/guest room), lean-to attached to secondary shed (40x26). Neighborhood boasts 2 private boat ramps off Bethy Creek. Main lake is large enough for all your boating plans, or easy access to the Trinity River, and if desired the main body of Lake Livingston. Perfect as a weekend lake house or your full time house. Seller will provide survey.' ,`Acres` = '0.5' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Riverside (Walker)' ,`HeatSystem` = 'Wall Heater' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERSIDE LAKELAND, Sec 6, Block 5, Lots 26,27,28' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '21780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SCOTT JOHNSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverside Lakeland' ,`TaxAmount` = '1579' ,`TaxRate` = '1.7134' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894067' WHERE `Matrix_Unique_ID` = '211183316' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:15:59.127' ,`MLSNumber` = '79176188' ,`ListAgentFullName` = 'Christopher Phan' ,`ListOfficeName` = 'Truss Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834939' ,`Longitude` = '-95.409721' ,`PhotoCount` = '22' ,`PostalCode` = '77018' ,`RoomCount` = '6' ,`ListPrice` = '429000.00' ,`Status` = 'Active' ,`StreetName` = 'Abbadean' ,`StreetNumber` = '4805' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Martin Court located in Independence Heights built by Oracle City Homes. This privately gated urban modern farmhouse community consists of 16 units total units with twelve 2 story homes and four 3 story homes that each come with a private yard. Each unit has been professionally designed interiors raising the bar with high end standard features that come with each home. First floor living with an oversized island countertop with seating of 3 that overlooks the living room that leads you to your own private backyard. The dining area is nestled in it\'s own private section with oversized windows along the adjoining walls giving plenty of natural lighting. The primary bedroom features 10 ft high ceilings and oversized windows that leads you to your own primary ensuite with separate his/her sinks along each wall that welcomes you into your own stand alone tub and walk in shower and closet. This community is a must see combining luxury and privacy!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Oracle City Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 1 Martin Court' ,`LotDesciption` = 'Other' ,`LotSize` = '1100' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Martin Court' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664894067' WHERE `Matrix_Unique_ID` = '211294448' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:20:59.877' ,`MLSNumber` = '42038421' ,`ListAgentFullName` = 'Myrna Lopez' ,`ListOfficeName` = 'Beyond Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.906465' ,`Longitude` = '-97.369509' ,`PhotoCount` = '40' ,`PostalCode` = '76131' ,`RoomCount` = '9' ,`ListPrice` = '405000.00' ,`Status` = 'Active' ,`StreetName` = 'Braewick' ,`StreetNumber` = '525' ,`StreetSuffix` = 'Drive' ,`City` = 'Fort Worth' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this GORGEOUS modern farmhouse that could be straight from a magazine cover! Amenities abound including inviting wood shiplap, modern lighting, beautiful chandeliers, archways and raised ceilings. Split bedroom floor plan with three bedrooms, two bathrooms, plus an OFFICE or FOURTH BEDROOM and a separate SITTING AREA perfect for a play or game room, media room, or workout equipment! Entertaining is a delight in the open kitchen with large island, eating bar, stainless appliances, black-lace granite counters, walk-in pantry, breakfast eating nook, plus separate formal dining room. Stunning white brick fireplace in the living room. The primary bathroom features a double sink vanity, walk in shower, separate soaking tub, and large walk in closet. Space and storage abound. Enjoy the outdoors on the covered patio. New HVAC and roof in 2021 and freshly painted exterior. This warm and inviting home is ready for you!' ,`Acres` = '0.1377' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'FOSSIL PARK ESTATES BLOCK 11 LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '364' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '486 - Eagle Mountain-Saginaw' ,`SchoolElementary` = 'COMANCHE SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAGINAW HIGH SCHOOL' ,`SchoolMiddle` = 'PRAIRIE VISTA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fossil Park Estates' ,`TaxAmount` = '6838' ,`TaxRate` = '2.8023' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894068' WHERE `Matrix_Unique_ID` = '211418717' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T06:21:59.383' ,`MLSNumber` = '42521465' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.450340' ,`Longitude` = '-95.397492' ,`PhotoCount` = '36' ,`PostalCode` = '77578' ,`RoomCount` = '7' ,`ListPrice` = '419975.00' ,`Status` = 'Active' ,`StreetName` = 'Bronte' ,`StreetNumber` = '9311' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2220' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Treat yourself to the captivating lifestyle experience of the elegant and effortless Woodworth dream home plan. Play host and get the most out of everyday life in your welcoming and beautiful open-concept living spaces. The modern kitchen features a large pantry, plenty of prep space, and a full-function island. Each guest suite and spare bedroom presents a wonderful place for individual styles to shine. Your bright and airy study is the perfect place for a productive home office, a music room, or a family movie theater. End each day and wake up refreshed in the luxurious Owner’s Retreat that includes a serene en suite bathroom and a spacious walk-in closet. Experience the LifeDesign? advantages of this new home plan.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8154' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664894068' WHERE `Matrix_Unique_ID` = '211628207' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:42:19.920' ,`MLSNumber` = '95782898' ,`ListAgentFullName` = 'Michelle Carruthers' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.466468' ,`Longitude` = '-95.568214' ,`PhotoCount` = '38' ,`PostalCode` = '77318' ,`RoomCount` = '4' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Carmel' ,`StreetNumber` = '15478' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2042' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One story home featuring 3 bedrooms with flex room, 2 1/2 baths & open concept living area with an abundance of natural light!\r\nWarm and rich hickory wood floors, high ceilings, and concrete wood burning fireplace. The gourmet kitchen has a functional island, granite countertops, SS appliances & walk in pantry. Generous primary bedroom with ensuite bath providing a spa like feel with double sinks, step-in rainfall shower, jetted soaking tub, and spacious walk-in closet.\r\nLarge back yard with covered patio for outdoor enjoyment or relax on the front porch and sip coffee in the morning. Plenty of room for a pool!\r\n\r\nThis Lake Conroe waterfront community offers pool, clubhouse, tennis courts, pickleball court, basketball court, boat launch, and lakefront green spaces throughout for residents to enjoy. Corinthian Point is a hidden gem on the north side of Lake Conroe. \r\nMinutes from The Woodlands and world class dining and medical facilities.' ,`Acres` = '0.2487' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CORINTHIAN POINT 02, BLOCK 16, LOT 244' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10832' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '81' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Corinthian Point 02' ,`TaxAmount` = '5271' ,`TaxRate` = '2.2463' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894068' WHERE `Matrix_Unique_ID` = '211678651' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:20:57.020' ,`MLSNumber` = '40439978' ,`ListAgentFullName` = 'Femi Adebola' ,`ListOfficeName` = 'Discovered Homes Inv. Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.614707' ,`Longitude` = '-95.528568' ,`PhotoCount` = '21' ,`PostalCode` = '77489' ,`RoomCount` = '6' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Crestmont Place Loop' ,`StreetNumber` = '1122' ,`StreetSuffix` = '' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2270' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained 4 bedroom, 2.5 bathroom, 2 car garage and a welcoming interior, comprises a good-sized living room in a great neighborhood! Kitchen boasts granite countertops and ample storage space! No backyard neighbors. Convenient location with easy access to highway 90 and Sam Houston Pkwy, Close proximity to grocery stores, restaurants and great shopping options' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Crestmont Place Sec 1, 2-3229' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'E A JONES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Crestmont Place Sec 3 2nd Amd' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894068' WHERE `Matrix_Unique_ID` = '211679595' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:14:47.070' ,`MLSNumber` = '22005781' ,`ListAgentFullName` = 'Jacquel Haywood' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.022572' ,`Longitude` = '-95.783257' ,`PhotoCount` = '26' ,`PostalCode` = '77447' ,`RoomCount` = '8' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Farm Pasture' ,`StreetNumber` = '17475' ,`StreetSuffix` = 'Trail' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1845' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this adorable one story home in Dellrose! This home boasts an extended driveway, high ceilings, open concept living, dining and kitchen and an office with french doors. A large island and breakfast bar to cater to family and friends. This home was upgraded with a water softener system and extended patio for entertaining. It is pre-wired for safety and security. It is close to HWY 290 and the tollroad with easy access in and out of the community. Enjoy community benefits such as the pool, clubhouse, splash pad, tennis courts, walking trails, parks and playgrounds. Schedule your tour today.' ,`Acres` = '0.1459' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 51 BLK 1 DELLROSE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6355' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Dellrose' ,`TaxAmount` = '9108' ,`TaxRate` = '3.5256' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894068' WHERE `Matrix_Unique_ID` = '211698028' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T06:57:23.817' ,`MLSNumber` = '44382882' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.675489' ,`Longitude` = '-95.902585' ,`PhotoCount` = '16' ,`PostalCode` = '77441' ,`RoomCount` = '4' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = 'Southern Dewberry' ,`StreetNumber` = '30710' ,`StreetSuffix` = 'Court' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2483' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'What a fantastic opportunity in Fulbrook on Fulshear Creek! This Highland Homes 4 bedroom, 3 bath 1-story is located on a cul-de-sac street! Loaded w/upgrades. Floor plan features a centrally located Living Room with 14 ft ceilings & fireplace that is open to the Kitchen, Formal Dining & Breakfast Nook. Kitchen features a huge island, quartz countertops, subway tile backsplash, & SS appliances. The split BR plan features 2 secondary BRs to the left of the Entry that share a full BA, plus another secondary BR and full BA off to the right. Primary BR is located at the back of the home & features a luxurious BA complete w/tiled shower, jetted tub and an extra long vanity w/dual sinks. Office could also be used as a guest BR. Sprinkler system & a water softener included. Great place to live with its mix of life in the country & small town charm. Easy access to FM 1093/Westpark Tollway. Residents have plenty to do with an activites, a pool, fitness center, lake and an amphitheater.' ,`Acres` = '0.1426' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FULBROOK ON FULSHEAR CREEK SEC 14, BLOCK 1, LOT 41' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6213' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fulbrook On Fulshear Creek' ,`TaxAmount` = '9561' ,`TaxRate` = '2.9978' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894069' WHERE `Matrix_Unique_ID` = '211846963' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:36:20.420' ,`MLSNumber` = '13628318' ,`ListAgentFullName` = 'Donna Morton' ,`ListOfficeName` = 'Gulf Coast, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.542511' ,`Longitude` = '-95.047432' ,`PhotoCount` = '25' ,`PostalCode` = '77565' ,`RoomCount` = '6' ,`ListPrice` = '249500.00' ,`Status` = 'Active' ,`StreetName` = 'Shasta' ,`StreetNumber` = '2013' ,`StreetSuffix` = 'Street' ,`City` = 'Kemah' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1649' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice brick home - no back neighbors - 4 bedrooms, 2 bathrooms and extra room could be 5th bedrooms. Did not flood. Quick trip to shopping, restaurants, Clear Lake and Boardwalk, League City and Kemah. Perfect home to add your own personal touch. Recent driveway, furnace, plumbing, electrical panel, landscaping and sprinklers. Glen Cove Park Subdivision has its own park by the water with a boat ramp into Clear Lake. Flood insurance $597per year. Recent paint and flooring - new pictures soon.' ,`Acres` = '0.2043' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 18 M MULDOON SUR E 64 FT OF LOT 50 (50-1) BLK C GLEN CO' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8898' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '12' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glen Cove Park' ,`TaxAmount` = '3369' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664894069' WHERE `Matrix_Unique_ID` = '212130089' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T06:47:03.990' ,`MLSNumber` = '50259209' ,`ListAgentFullName` = 'Ann Marie Gallagher' ,`ListOfficeName` = 'Tisona Real Estate Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.142210' ,`Longitude` = '-95.686800' ,`PhotoCount` = '42' ,`PostalCode` = '77355' ,`RoomCount` = '15' ,`ListPrice` = '950000.00' ,`Status` = 'Active' ,`StreetName` = 'Timberway' ,`StreetNumber` = '2215' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique Custom Built Home with wrap around porches. One of a kind 3 story home with a pool and huge yard with pecan trees. Property has 5 Bedrooms, all with private bathrooms and 2 1/2 baths. The first floor has a vast living room with huge custom kitchen, breakfast room, mud room, walk-in pantry, under stairs storage, 1/2 bath, formal dining room and home office/study. The second floor has a huge master bedroom with a private sitting room and private porch overlooking backyard and pool. There are also 2 bedrooms with private bathrooms and a media room as well as the utility room which has a sink. The 2nd Story connects to the bonus space above garage which also has a 1/2 bathroom, this room was used previously as an exercise room and has a private outside entrance and stairwell leading to it. The 3rd floor is custom and contains a game room, 2 bedrooms with custom built-ins each with their own bathroom and a cedar lined storage room.' ,`Acres` = '1.324' ,`Area` = '15' ,`BuilderName` = 'Jay Neatherly Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Probate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'TIMBERGREEN 04, BLOCK 2, LOT 11' ,`LotDesciption` = 'Corner,Cul-De-Sac,Wooded' ,`LotSize` = '57673' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Timbergreen 04' ,`TaxAmount` = '9069' ,`TaxRate` = '1.9215' ,`WaterSewer` = 'Aerobic,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894069' WHERE `Matrix_Unique_ID` = '212178151' --> 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','212186090','1664894069','212186090','2022-10-04T07:41:02.857','95975133','Johnathan Callery','REALM Real Estate Professional','','','29.303529','-94.777107','24','77550','26','1400000.00','Active','10th','1013','Street','Galveston','6','2','6','4110','Single-Family','Beautiful Luxury split floor plan design located in the upcoming highly desired neighborhood \"Palms Of Galveston\"! 1013 10th St. is the first home to be sold and is perfectly equipped to accommodate the entire family PLUS guest and friends within prime location on Galveston Island. A total of 6 BEDROOMS, 6.5 BATHROOMS, 2 Open Kitchen Concepts, Luxury Finishes, Balcony views of the Gulf of Mexico, and a abundance of parking to accommodate family and friends. Located within minutes of UTMB Medical District, The Beach, Strand District, and Highly Desired restaurants on the Island. Furthermore, Situated off the garage is a private patio space that was designed to be easily converted into a 1 bedroom, 1 bathroom additional living unit. PLEASE TAKE TIME TO VIEW THE VIRTUAL TOUR LINK ATTACHED TO THE LISTING.','','33','Al Hoda Enterprises','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures,Sellers Disclosure','1','','','East End','Central Electric,Central Gas','0','ABST 628 M B MENARD SUR LOTS 8 & 9 (8-100) BLK 130 GALVESTON','Other,Water View','4800','Appraisal District','','0','0','','4','','0','','','','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Accompany,Appointment Required,Controlled Access,No Supra Keybox,Temporarily No Showings','Appraisal District','2','Other Style','Galveston Townsite','8368','2.0662','Public Sewer,Public Water','2017','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:57:09.280' ,`MLSNumber` = '67329238' ,`ListAgentFullName` = 'Ronald Espinoza' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745335' ,`Longitude` = '-95.381690' ,`PhotoCount` = '33' ,`PostalCode` = '77006' ,`RoomCount` = '6' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Avondale' ,`StreetNumber` = '100' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2584' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom 3.5 bathroom home features large private lot with new professional landscaping, double pane double hung top down bottom up windows, ¾” hardwood flooring, gas log fireplace with wooden mantle, multiple balconies, and double crown molding. Oversized kitchen with island, granite countertops, raised cabinets with glass fronts and walk-in pantry. 3rd floor primary bedroom has covered balcony with views of Downtown, walk-in closet with built-in shelving, double sinks, shower with built-in bench and jetted tub. One bedroom and bathroom on 1st floor. All bedrooms have en-suite bathrooms. Large backyard with iron and wood fence, trellis, green space, spa and 17x12.10’ deck. Close proximity to Downtown, River Oaks Shopping Center, Buffalo Bayou Park, Whole Foods, parks, shops, restaurants, I-10, I-45 and 59.' ,`Acres` = '0.0939' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Electric,Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 AVONDALE GARDENS AMEND' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '4091' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GREGORY-LINCOLN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'GREGORY-LINCOLN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Avondale Gardens' ,`TaxAmount` = '13395' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894069' WHERE `Matrix_Unique_ID` = '212248970' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:00:39.750' ,`MLSNumber` = '87005514' ,`ListAgentFullName` = 'Shara Hymowitz' ,`ListOfficeName` = 'Houston Home Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.725798' ,`Longitude` = '-95.380343' ,`PhotoCount` = '10' ,`PostalCode` = '77004' ,`RoomCount` = '6' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Wichita' ,`StreetNumber` = '1728' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2353' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'From award-winning homebuilder, ROC Homes, this 2-story freestanding new construction features a rare \"1st Floor Lifestyle\" in the heart of the Museum District. The 1st floor features your kitchen, living and casual dining space, and all bedrooms are on the 2nd floor. Home has started construction and is estimated to be complete by October/November 2022. Walking distance to great restaurants, bars, shops, great area to live!!' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = 'ROC Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'na' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MACGREGOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Museum District' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664894069' WHERE `Matrix_Unique_ID` = '212335084' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T06:48:20.897' ,`MLSNumber` = '45490176' ,`ListAgentFullName` = 'Jamie Kastens' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.644773' ,`Longitude` = '-95.696546' ,`PhotoCount` = '50' ,`PostalCode` = '77407' ,`RoomCount` = '15' ,`ListPrice` = '1550000.00' ,`Status` = 'Active' ,`StreetName` = 'Westmoor' ,`StreetNumber` = '11534' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '7' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '5254' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ONE-OF-A-KIND J.Patrick LUXURY HOME w/ 6 BR & 7 full baths. Move-in ready, North-facing, w/ tons of amenities including a space for wine enthusiasts, a private home office, and a relaxing self-cleaning pool equipped with a jacuzzi, firepit, and heated for cooler Texas nights. Perfect for entertaining! There\'s no back neighbors, a gourmet outdoor kitchen w/ broiler, 2 ceiling fans, & travertine deck. The wide open floorplan has 2-story ceilings in the living room w/ plenty of natural light, motorized blinds, built-in shelves, & a stone-front fireplace. The modern chef\'s kitchen has a water softener, Quartz countertops, & sleek under-cabinet lighting. The opulent owner\'s suite is huge, with a bay window & sitting area. One room was converted into a huge walk-in closet or \"She Shed.\" There is a spacious game room and media room w/ projector, large screen, & 5-point surround sound. It\'s zoned to top A-rated schools in Fort Bend ISD. The 20,000+ sq. ft lot is among the largest in Aliana.' ,`Acres` = '0.473' ,`Area` = '37' ,`BuilderName` = 'JPatrick' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ALIANA SEC 51, BLOCK 2, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20603' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MALALA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Aliana Sec 51' ,`TaxAmount` = '19515' ,`TaxRate` = '3.0329' ,`WaterSewer` = 'Water District,Well' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894069' WHERE `Matrix_Unique_ID` = '212401772' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:59:40.303' ,`MLSNumber` = '23922863' ,`ListAgentFullName` = 'Roxana Alarcon' ,`ListOfficeName` = 'Energy Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.079266' ,`Longitude` = '-95.116714' ,`PhotoCount` = '50' ,`PostalCode` = '77336' ,`RoomCount` = '11' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'Vista Del Lago' ,`StreetNumber` = '1207' ,`StreetSuffix` = 'Drive' ,`City` = 'Huffman' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3497' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME to El CAMPANARIO Ranch. Truly one-of-a-kind, with incredible upgrades throughout the dual-home property! The mediterranean style home features five bedrooms, a sprawling living area, and a well-equipped island kitchen complete with granite countertops, home office, primary suite with rear-patio access, luxury wood flooring, and classic design elements. \r\nHorse stables, arena, and everything you need to keep your horses. \r\nThe manicure garden has some many different trees and plans through-out the property, own greenhouse, and more!!!!!!\r\n\r\nEnjoy all that The Commons has to offer from miles of nature & horse trails, lake access, fishing & boating with a private access boat ramp to Lake Houston, you will pride of owner-ship in this DELUXE COUNTRY Neighborhood with Easy access to SH 99, I-69, Beltway 8 & Bush Airport!' ,`Acres` = '2.0327' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 COMMONS OF LAKE HOUSTON SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '88544' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean,Split Level' ,`Subdivision` = 'Commons Lake Houston Sec 01' ,`TaxAmount` = '9135' ,`TaxRate` = '2.0083' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894070' WHERE `Matrix_Unique_ID` = '212449157' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:40:09.897' ,`MLSNumber` = '56186830' ,`ListAgentFullName` = 'Kathy Garrison' ,`ListOfficeName` = 'Real Living Karapasha Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.767927' ,`Longitude` = '-95.827100' ,`PhotoCount` = '42' ,`PostalCode` = '77494' ,`RoomCount` = '12' ,`ListPrice` = '1399000.00' ,`Status` = 'Active' ,`StreetName` = 'Kingsgate' ,`StreetNumber` = '1019' ,`StreetSuffix` = 'Circle' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5586' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'IMAGINE living at the PARK!! Rare opportunity for this type of property and this location! Spectacular and thoughtfully designed custom home features quality throughout with a focus on the outdoor paradise awaiting you. All rooms built to overlook the backyard oasis, with everything you could want: outdoor sitting area with fireplace, grilling area, dining area all nestled around the beautiful pool/spa. Looking beyond is the park like setting with so many trees you think you are at a private OASIS! Interior features include spacious rooms with open concept chefs style island kitchen looking into the living room as well as game room and bar area ready for entertaining. High ceilings with cedar beams, custom cabinets, executive appliances, travertine tile, wood floors and large picturesque windows glazing into the backyard treasure. A luxurious oversized primary suite features large his/her closets with lots of storage and plenty of privacy! Come see this beauty, it\'s FABULOUS!' ,`Acres` = '1.206' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WOODCREEK RESERVE SEC 5, BLOCK 1, LOT 5, ACRES 2.4298, PARTI' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '52533' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOODCREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodcreek Reserve Sec 5' ,`TaxAmount` = '22906' ,`TaxRate` = '2.8317' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894070' WHERE `Matrix_Unique_ID` = '212554106' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:26:57.237' ,`MLSNumber` = '40669618' ,`ListAgentFullName` = 'Melissa Shechter' ,`ListOfficeName` = 'Ironwood Realty' ,`SellingAgentFullName` = 'Cheryl Combs Young' ,`SellingOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`Latitude` = '29.686959' ,`Longitude` = '-95.138104' ,`PhotoCount` = '22' ,`PostalCode` = '77536' ,`RoomCount` = '7' ,`ListPrice` = '249000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Atlanta' ,`StreetNumber` = '1613' ,`StreetSuffix` = 'Street' ,`City` = 'Deer Park' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1592' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable 3/2/2 nestled in the heart of Deer Park. Deer Park ISD schools. Home is shaded under mature trees and offers front patio with covered back patio. Double sided carport. Tile throughout with middle bedroom having carpet. Bedrooms have walk-in closets with lots of additional storage closets. Spacious bedrooms. High ceiling in livingroom. Kitchen open to livingroom with corian countertops and tile backsplash. Breakfast bar. Amazing patio space with pavers in backyard canopied under a beautiful tree offers you your own private solace and great for entertaining. Home is not far from park, restaurants, schools, and retail.' ,`Acres` = '0.1779' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 39 BLK 3 DEER MEADOWS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'CARPENTER ELEMENTARY SCHOOL (DEER PARK)' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'BONNETTE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Meadows' ,`TaxAmount` = '5489' ,`TaxRate` = '2.8239' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894070' WHERE `Matrix_Unique_ID` = '212571475' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:34:51.470' ,`MLSNumber` = '65903401' ,`ListAgentFullName` = 'Ernest Escobedo' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.926051' ,`Longitude` = '-95.577133' ,`PhotoCount` = '31' ,`PostalCode` = '77064' ,`RoomCount` = '4' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Harvest' ,`StreetNumber` = '10807' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1609' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this completely remodeled gem! Just a few things in the remodel induce fully renovated kitchen and bathrooms with new QUARTZ countertops, a new 25 year roof, new windows, new water heater, new HVAC inside and out, new garage door and opener, and new PEX Plumbing throughout the entire house! So many more updates have been done as well! Did we mention, NO BACK NEIGHBORS! The location of this home is zoned to award wining Cy-Fair ISD schools and affords an easy commute to work, shopping and both casual and fine dining options just blocks away!' ,`Acres` = '0.1716' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 5 HARVEST BEND SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '407' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FRANCONE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harvest Bend Sec 03' ,`TaxAmount` = '4365' ,`TaxRate` = '2.5587' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894070' WHERE `Matrix_Unique_ID` = '212583681' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:35:11.470' ,`MLSNumber` = '89291055' ,`ListAgentFullName` = 'Daicel Prat' ,`ListOfficeName` = 'J.D. Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.873041' ,`Longitude` = '-95.474162' ,`PhotoCount` = '49' ,`PostalCode` = '77088' ,`RoomCount` = '11' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Antoine' ,`StreetNumber` = '7531' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2494' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunningly Renovated 4 Bedrooms, 2 1/2 Baths home overlooking the golf course in Inwood Forest! This beautiful home has received a Complete makeover for your enjoyment. Newly installed roof w/warranty & Newly installed HVAC system w/warranty. As soon as you walk in, the open-concept floor plan greets you to the beautiful golden fixtures/finishes. Just placed porcelain tile flooring on the 1st floor, newly installed carpet in bedrooms on the 2nd floor & laminate floor in Primary Suite. Entertain a family meal in the updated kitchen displaying Quartz countertops & new appliances. Recessed lights all throughout & white walls to indulge in the light-filled living area. Unwind under the rain shower in Primary Ensuite bathroom displaying newly installed tempered glass sliding shower glass doors. From recently placed Electrical Panel, new garage doors w/remote, toilets, & freshly painted interior/exterior.' ,`Acres` = '' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1, Block 1' ,`LotDesciption` = 'Cleared,Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '11543' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'SMITH ACADEMY' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'HOFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Inwood Frst Sec 7' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664894070' WHERE `Matrix_Unique_ID` = '212610885' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:45:58.257' ,`MLSNumber` = '61954990' ,`ListAgentFullName` = 'Jennifer Arnold' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.577398' ,`Longitude` = '-95.114090' ,`PhotoCount` = '50' ,`PostalCode` = '77062' ,`RoomCount` = '12' ,`ListPrice` = '439000.00' ,`Status` = 'Active' ,`StreetName` = 'Fairwind' ,`StreetNumber` = '2503' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2722' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated & well maintained 2-story home situated on a large lot in the desirable Bay Forest Community. You are within close walking distance to tennis courts, parks, and schools. Outside the home offers a manicured lawn w/ lush landscaping, mature trees, tons of fruit trees and plants, & a long driveway to a detached 2 car garage. This beautiful home boast of an abundance of natural light throughout, living area looking out into luscious back yard and pool that has been resurfaced 2022.. Updates include fresh paint throughout, new carpet, new roof 2018, new HVAC 2017/2018, rebuilt kitchen cabinets 2022, Updated kitchen with Quartz countertops, and all new appliances 2022, new double pane windows 2015, electrical whole house 2015, updated master and secondary bath, custom master closet 2018, sprinkler system 2015, extended deck and gazebo 2018, new garage door and opener 2018, carve stone pool deck 2019, replaced water connections whole house 2019, and much more! Upgrades galore!!!' ,`Acres` = '0.2173' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 51 BLK 2 BAY FOREST SEC 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '9464' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '720' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FALCON PASS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Forest Sec 02' ,`TaxAmount` = '7661' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894071' WHERE `Matrix_Unique_ID` = '212645021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T06:11:27.653' ,`MLSNumber` = '55459793' ,`ListAgentFullName` = 'Amy Hersey' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Chelsie Vallejo' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '30.277370' ,`Longitude` = '-95.544326' ,`PhotoCount` = '50' ,`PostalCode` = '77316' ,`RoomCount` = '8' ,`ListPrice` = '399000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bearkat' ,`StreetNumber` = '118' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2039' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Highly desired one story plan on a premium lot with wooded side reserve & no back neighbors. Charming brick & stone home with professional landscaping provides inviting curb appeal. Incredible floor plan that flows so well with light & bright finishes throughout this open concept plan. Entry boasts upgraded door, plantation shutter, & a great study for your home office or formal dining if needed. The stunning kitchen with oversized island, cabinet & counter space galore. The living room is open with walls of windows, gas fireplace, and upgraded tile leading to the back patio. The primary suite is tucked back with tile flooring & a beautiful primary bath. Another private hall leads to the two secondary bedrooms with a flex room in between that is made to fit your needs (kids playroom, reading room, study, or gameroom). Enjoy all the amenities that Woodforest has to offer with Harvest Market, shopping, restaurants, pharmacy, doctors, fitness, coffee shops, Pool, splash pad & more!' ,`Acres` = '0.174' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965269 - WOODFOREST 69, BLOCK 1, LOT 1' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '7579' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 69' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894071' WHERE `Matrix_Unique_ID` = '212648864' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:57:41.527' ,`MLSNumber` = '81806273' ,`ListAgentFullName` = 'Mary Kiesewetter' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Tracy Nguyen' ,`SellingOfficeName` = 'Walzel Properties' ,`Latitude` = '29.700781' ,`Longitude` = '-95.827955' ,`PhotoCount` = '40' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '515000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Juniper Stone' ,`StreetNumber` = '26015' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2969' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Simply gorgeous one story home in Cinco Ranch Southwest zoned to outstanding Katy ISD schools. This immaculate house boasts 2969 square feet of beautiful space including four bedrooms, three full bathrooms, spacious study/home office, sunroom, formal dining room and a totally open concept main living area. The kitchen is a chefs dream with stainless appliances, gas cooktop, center island and abundant storage. The laundry room is fantastic! There is loads of space and storage in there! The primary bedroom offers a peaceful retreat for the homeowner and features a bright, modern bathroom suite. The home is on a cul de sac and is minutes from major commuter routes, shopping, restaurants and community amenities such as water parks, swimming pools, tennis courts, numerous hiking/biking paths and soccer fields. The house was recently repainted (majority) and is fresh and ready for move in! The landscaping in both front and back yards is amazing. You will be impressed!' ,`Acres` = '0.1879' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH SOUTHWEST SEC 8, BLOCK 1, LOT 24' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8184' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'STANLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'SEVEN LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch Southwest' ,`TaxAmount` = '9190' ,`TaxRate` = '2.7845' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894071' WHERE `Matrix_Unique_ID` = '212681001' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T06:32:01.930' ,`MLSNumber` = '58557820' ,`ListAgentFullName` = 'Angela Pipes' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.919908' ,`Longitude` = '-95.181170' ,`PhotoCount` = '43' ,`PostalCode` = '77044' ,`RoomCount` = '16' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Hunters Lake' ,`StreetNumber` = '15818' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4318' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Trendmaker Home w/ a POOL backs to a nature reserve in Summerwood that offers trails, pools, tennis courts, playgrounds & access to SH Toll. Outside offers a manicured lawn, fresh landscaping, large shade trees, & a stylish stone elevation. Inside, find an open floorplan w/ soaring ceilings, wood floors, TONS of natural light & more! An office w/ French doors & the dining lead into the open & airy living w/ built-ins, fireplace, & stunning backyard views. The large gourmet kitchen boasts granite counters, SS double ovens, ample storage, an island & a butler\'s pantry. Next, find the perfect flex space for a 2nd home office, storage, or workout room before entering the primary that includes a double sink ensuite bath & a walk-in closet. Upstairs find an addl study nook, a HUGE game room w/ surround sound & 4 bedrooms that share 2 full baths. Don\'t forget about the sparkling pool & spa along w/ a covered patio featuring an outdoor fan & all the grass space you need!' ,`Acres` = '0.251' ,`Area` = '1' ,`BuilderName` = 'TRENDMAKER' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 2 SUMMERWOOD SEC 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10935' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '895' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SUMMERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Summerwood' ,`TaxAmount` = '12010' ,`TaxRate` = '2.7932' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894071' WHERE `Matrix_Unique_ID` = '212725049' --> 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','212770321','1664894071','212770321','2022-10-04T07:51:02.810','31954886','Julie Vann','Aaron Harris Realty','','','30.195204','-95.560202','37','77382','16','2999000.00','Active','Legato','3','Way','The Woodlands','7','2','6','10088','Single-Family','Robert Dame architectural designed Estate Home located on a sprawling 1.3 acre corner lot in Carlton Woods. This home has 6 bedrooms, 7 full baths and 2 half baths. A true entertainers dream with a large pool, swim up bar, two outdoor kitchens, fire pit, and rock waterfall with cave. Incredible Chefs kitchen with Wolf range, 2 dishwashers, and Subzero refrigerator. Luxurious owners retreat with vaulted wood beam ceilings and sitting area. Large primary bath complete with 6 nozzle shower, 2 private toilets, and his/her walk in closets. Secondary bedrooms have walk in closets and en suite bathrooms. Large game room down with views of pool, fire pit, and patio. Additional media room, game room, and poker room up equipped with wet bar. Bonus room up with wood floors, mirrors, and ballet bar perfect for a work out room equipped with a performers stage and stairs leading to a loft bed. This incredible home sits on a corner cul-de-sac lot on over 1.3 acres of tree lined majesty.','1.3667','15','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','The Woodlands','Central Gas','1','WDLNDS VIL OF CARLTON WOODS 09, BLOCK 1, LOT 5','Corner,Cul-De-Sac,In Golf Course Community','59535','Appraisal District','','3250','0','','3','Double Oven,Electric Oven','1','In Ground,Salt Water','','Gas Range,Grill','','Slate','11 - Conroe','TOUGH ELEMENTARY SCHOOL','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Appointment Required,Controlled Access,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','Wdlnds Village Of Carlton Woods 09','52206','2.1816','Water District','2006','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:12:47.780' ,`MLSNumber` = '32238498' ,`ListAgentFullName` = 'Veronica Vera' ,`ListOfficeName` = 'Logos Investment Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.570941' ,`Longitude` = '-95.433478' ,`PhotoCount` = '23' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '374900.00' ,`Status` = 'Active' ,`StreetName` = 'Evening Wind' ,`StreetNumber` = '13801' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2109' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Like new single story Perry Home in sought after Shadow Creek Ranch! Open concept living with 3 bedrooms and 2 bathrooms. Your new home features upgraded laminate floors, tile in wet areas, neutral paint, tall ceilings, granite countertops, dark luxurious cabinetry, 16 SEER Carrier A/C system, brick exterior, white stone on front elevation and more! Come enjoy the best of city living at your fingertips just minutes away from dinning, and popular shopping destinations such as Pearland Town Center or Silverlake Village. Meanwhile tucked within 150 sprawling nature themed acres within your new master planned community! You get a multitude of parks, miles of trails, 4 recreation centers, splash pads, and more! Your enchantment awaits in your new home. Come fall in love today!' ,`Acres` = '0.1858' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-61, BLOCK 2, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8095' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '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' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf-61' ,`TaxAmount` = '7915' ,`TaxRate` = '3.2123' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894071' WHERE `Matrix_Unique_ID` = '212819040' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:43:55.407' ,`MLSNumber` = '97054487' ,`ListAgentFullName` = 'Terri Mund' ,`ListOfficeName` = 'Hudgins-Groover Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.332649' ,`Longitude` = '-96.084011' ,`PhotoCount` = '40' ,`PostalCode` = '77488' ,`RoomCount` = '9' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Wayside' ,`StreetNumber` = '720' ,`StreetSuffix` = 'Avenue' ,`City` = 'Wharton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A rare find, this home sits on 4 city lots giving you over a 1/2 acre of land with mature oak trees to provide great shade across the property! Conveniently located within walking distance to Wharton County Jr. College, Wharton schools, & HEB. Everything is new inside this custom brick home including flooring, sheetrock, paint, lighting, cabinetry, countertops, fixtures, appliances, ceiling fans, HVAC system, hot water heater, & electric panel! Spacious rooms throughout allow for plenty of space for your family & friends. Enter to a large living area with a window wall that provides tons of natural light. Continue inside to the great room that opens into your dining/kitchen area. Large kitchen features new appliances, cabinetry and countertops. The primary bathroom has been updated with new toilet, vanity, fixtures, & large walk-in shower. The secondary bath includes new toilet, vanity, fixtures, & tub/shower combo. You\'ll enjoy outdoor living in the spacious screened-in back porch.' ,`Acres` = '0.6198' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'HAWES 5TH BLOCK 39 LOT 7,8,9,10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '26998' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hawes 5th' ,`TaxAmount` = '2474' ,`TaxRate` = '2.4334' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894072' WHERE `Matrix_Unique_ID` = '212848864' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T06:51:55.393' ,`MLSNumber` = '14412427' ,`ListAgentFullName` = 'Christa Burgess' ,`ListOfficeName` = 'RE/MAX Cinco Ranch' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.741637' ,`Longitude` = '-95.765144' ,`PhotoCount` = '49' ,`PostalCode` = '77450' ,`RoomCount` = '12' ,`ListPrice` = '825000.00' ,`Status` = 'Active' ,`StreetName` = 'Winding Shore' ,`StreetNumber` = '2911' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5626' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gated community, Custom home, 5 beds, 3.5 baths, 2 car garage, gated driveway, pool/spa, fitness room, media room with furniture and audio-video equipment to stay, large Gameroom, library/computer room, primary suite with study and double-sided fireplace, dual closets and sinks, separate shower and tub in primary bath. Two living areas with a double-sided gas log fireplace. Large open kitchen with double ovens, gas cooktop, lots of storage, mud room with built-in lockers, outdoor covered patio with area for dining and outdoor grill, pool and spa with fountain, volleyball net, pool basketball, storage building behind the home. LOW Taxes! No Flooding! Desirable South Lake Landing, gated community of award-winning community of Cinco Ranch. Zoned to Williams Elem/Beck Jr/Cinco Ranch HS, located on hike/bike trails, stocked ponds, tennis, golf, pools, sports fields, frisbee golf, near shopping and dining, and easy access to I-10 or Westpark Tollway and The Houston Energy Corridor.' ,`Acres` = '0.2265' ,`Area` = '36' ,`BuilderName` = 'Custom Classics' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH SOUTH LAKE VILLAGE SEC 2, BLOCK 1, LOT 45' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9867' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1565' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WILLIAMS ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch' ,`TaxAmount` = '13947' ,`TaxRate` = '2.4395' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664894072' WHERE `Matrix_Unique_ID` = '212956852' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:53:31.413' ,`MLSNumber` = '22655709' ,`ListAgentFullName` = 'Mia Cardenas' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.556807' ,`Longitude` = '-95.238820' ,`PhotoCount` = '43' ,`PostalCode` = '77581' ,`RoomCount` = '12' ,`ListPrice` = '357000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Cone' ,`StreetNumber` = '2704' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2249' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home nestled in the quiet, wooded community of Pine Shadows with 3 bedrooms and 2.5 baths. Large windows allow natural light to fill the home and highlight the spaciousness of each room. Step into the grand living room featuring cathedral ceilings and a stately brick fireplace. An open kitchen with granite counters and stainless appliances connects to the breakfast area. The formal dining room is located just off the front entry. A generously sized primary suite has cathedral ceilings and huge windows that overlook the private backyard full of beautiful trees. The primary bath offers double sinks with vanity, an oversized shower and 2 walk-in closets. Secondary bedrooms located upstairs are spacious. Upstairs also offers a large living area, study and full bath. A large gameroom was added downstairs, along with a half bath. Pine Shadows community is NOT managed by an HOA and no MUD tax! LOW tax rate!' ,`Acres` = '0.2101' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PINE SHADOWS (PEARLAND), BLOCK 2, LOT 10' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '9152' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SHADYCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Shadows Pearland' ,`TaxAmount` = '7232' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894072' WHERE `Matrix_Unique_ID` = '212965054' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:03:06.653' ,`MLSNumber` = '38487169' ,`ListAgentFullName` = 'Lauren Moyers' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.055581' ,`Longitude` = '-94.777405' ,`PhotoCount` = '33' ,`PostalCode` = '77575' ,`RoomCount` = '6' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Center' ,`StreetNumber` = '106' ,`StreetSuffix` = 'Street' ,`City` = 'Liberty' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1750' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully well maintained home in the heart of Liberty! As you enter the home you are greeted with a large living room with a nice electric fireplace. The spacious kitchen has beautiful granite countertops with a breakfast bar that opens to the living room. Past the kitchen is an extra room where the washer and dryer are located as well as a massive storage closet! The very spacious primary bedroom has its own en suite with double sinks, separate shower, and walk in closet! This home has a large screened in porch so that you can enjoy the fresh air. It also has a 2-car carport with plenty of space for all of your guests and room on the side for an RV! Low maintenance yard work with the ability to fence in the front and side yards. AC unit and all duct work were replaced in 2018.' ,`Acres` = '0.2066' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Liberty' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WHITTINGTON EXT-A, BLOCK 5, LOT 14, ACRES .2066' ,`LotDesciption` = 'Corner' ,`LotSize` = '8999' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '73 - Liberty' ,`SchoolElementary` = 'LIBERTY ELEMENTARY SCHOOL (LIBERTY)' ,`SchoolHigh` = 'LIBERTY HIGH SCHOOL (LIBERTY)' ,`SchoolMiddle` = 'LIBERTY MIDDLE SCHOOL (LIBERTY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Whittington Ext-A' ,`TaxAmount` = '5229' ,`TaxRate` = '2.6826' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894072' WHERE `Matrix_Unique_ID` = '212973213' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T06:22:00.913' ,`MLSNumber` = '57354182' ,`ListAgentFullName` = 'Betsy Russell' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.274361' ,`Longitude` = '-95.540463' ,`PhotoCount` = '41' ,`PostalCode` = '77316' ,`RoomCount` = '9' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Cliftons Curve' ,`StreetNumber` = '138' ,`StreetSuffix` = 'Way' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This amazing home is back and it is more beautiful than ever! The home sits on a large lot in an area where there is space between the homes and no rear neighbors. The lay-out is ideal with the master bedroom, both formals, a light, bright living room and a spacious gourmet kitchen on the first floor. Upstairs you will find the secondary bedrooms, two full bathrooms, a media room, game room - all laid out in a unique floor plan you have not seen over and over. Woodforest is a growing, thriving community of homes built by highly regarded builders, with amenities second to none. The community is located almost mid-way between The Woodlands and Lake Conroe. You will see residents in golf carts touring the neighborhood or visiting the vast array of restaurants and stores. With new businesses opening regularly, this town is luring residents from across the country. Great schools, friendly neighbors, and easy access to shopping and entertainment make it the perfect place to put down roots!' ,`Acres` = '0.1982' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965257 - WOODFOREST 57, BLOCK 1, LOT 30' ,`LotDesciption` = 'Greenbelt,In Golf Course Community' ,`LotSize` = '8635' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 57' ,`TaxAmount` = '10741' ,`TaxRate` = '2.6888' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894072' WHERE `Matrix_Unique_ID` = '212991438' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:47:00.950' ,`MLSNumber` = '84554148' ,`ListAgentFullName` = 'Pamela Berman' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Matthew Grubbs' ,`SellingOfficeName` = 'United Real Estate' ,`Latitude` = '30.132138' ,`Longitude` = '-95.374880' ,`PhotoCount` = '12' ,`PostalCode` = '77386' ,`RoomCount` = '6' ,`ListPrice` = '244900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Medina River' ,`StreetNumber` = '4283' ,`StreetSuffix` = 'Loop' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1312' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful move in ready home that has everything you have been searching for- 2 car garage, spacious backyard & great schools all at an excellent price...welcome home! Off the entry way, a large family room greets you as you enter into the heart of the home. The family room has vaulted ceilings, fresh neutral paint & is open to the kitchen/breakfast nook making entertaining a breeze. The kitchen has updated black appliances (including a space saving built in microwave), breakfast bar & plentiful amounts of cabinets & counter space. The primary bedroom has beautiful natural light & an ensuite bath complete with a huge walk in closet & separate shower + soaking tub. Two additional secondary bedrooms & updated guest bath wrap up the interior space of this lovely home. Backyard has a covered patio perfect for an additional outdoor living space as well as lots of grass that kids, pets & gardeners will adore. Perfect location minutes from shopping, dining, and 99/45/Hardy Toll- hurry!' ,`Acres` = '0.1267' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S352704 - CREEKSIDE VILLAGE 04, BLOCK 2, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BRADLEY ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekside Village 04' ,`TaxAmount` = '3084' ,`TaxRate` = '1.8487' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894073' WHERE `Matrix_Unique_ID` = '213009975' --> 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','213099081','1664894073','213099081','2022-10-04T07:55:21.970','25244665','Sara Nguyen','BHGRE Gary Greene','','','29.490157','-95.506640','46','77459','9','400000.00','Active','Five Oaks','2734','Drive','Missouri City','2','1','4','2724','Single-Family','Stately 2-story brick home w/a sparkling heated inground pool & spa, covered patio & no back neighbors! Open floorplan filled w/designer touches like arched doorways, lit art niches, Travertine tile floors, a gas-log fireplace, raised ceilings, fantastic natural light & more. Formal dining is ideal for entertaining. Updates to the island kitchen include granite countertops, tile backsplash, oven & cabinetry. Eat-in kitchen also has a large pantry & ample space for a breakfast table. Posh 1st-floor owner’s retreat offers plush carpet, neutral paint, a large walk-in closet & a beautiful ensuite bathroom w/updated walk-in shower, dual sink vanity & garden tub. It’s all fun & games upstairs w/a spacious game room, 3 bedrooms + a full bath. Backyard paradise w/a covered pool-side patio & heated inground pool & spa. Fabulous amenities: Golf, tennis, parks, playgrounds, resort-style pool & splash pads, fitness center, scenic lakeside trails & so much more.','0.1792','38','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Levee District,Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Sienna Area','Central Gas','1','SIENNA VILLAGE OF SHIPMANS LANDING SEC 9, BLOCK 2, LOT 4','In Golf Course Community,Subdivision Lot','7806','Appraisal District','','1307','0','','2','Electric Oven,Freestanding Oven,Single Oven','1','Heated,In Ground','','Electric Range,Freestanding Range','','Composition','19 - Fort Bend','LEONETTI ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','THORNTON MIDDLE SCHOOL (FORT BEND)','Appointment Required,Lockbox Front,Supra Keybox','Appraisal','2','Traditional','Sienna','7831','2.6079','Public Sewer,Public Water,Water District','2000','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213124087','1664894073','213124087','2022-10-04T06:57:22.210','61134832','Troy Duncan','CB&A, Realtors','','','30.220174','-95.450356','31','77385','7','299900.00','Active','Misty Canyon','18','Place','Conroe','2','0','4','2042','Single-Family','Charming one story on a quiet cul-de-sac street in sought after Harper\'s Landing. This four bedroom home has lots of open spaces, high ceilings, large primary suite, and covered back patio. Conveniently located at I-45 and Loop 242 you will be close to hospitals, shopping, restaurants and entertainment.','0.1767','15','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','The Woodlands','Central Gas','0','WDLNDS HARPER\'S LND COLLEGE PK 04, BLOCK 1, LOT 3','Subdivision Lot','7699','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Cooktop,Gas Range','','Composition','11 - Conroe','POWELL ELEMENTARY SCHOOL (CONROE)','THE WOODLANDS COLLEGE PARK HIGH SCHOOL','KNOX JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Wdlnds Harpers Lnd College Park','5397','2.2719','Public Sewer,Public Water','2004','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T06:45:00.703' ,`MLSNumber` = '62202098' ,`ListAgentFullName` = 'David Otis' ,`ListOfficeName` = 'Texas Shoreline Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.993875' ,`Longitude` = '-95.186002' ,`PhotoCount` = '22' ,`PostalCode` = '77346' ,`RoomCount` = '5' ,`ListPrice` = '229000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodmancote' ,`StreetNumber` = '5819' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1415' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom and 2 bath home with a 2 car garage, great starter home, in great condition. Upgrades include new windows, new blown-in attic insulation, new flooring in living room, entry way and hall way, 2 new attic access ladders, new lawn & landscaping, new air condenser and exterior has repainted. Must See!!!' ,`Acres` = '0.1566' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 6 ATASCOCITA TRAILS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita Trails' ,`TaxAmount` = '4092' ,`TaxRate` = '2.492' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894073' WHERE `Matrix_Unique_ID` = '213159808' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T06:51:44.380' ,`MLSNumber` = '25027689' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.638772' ,`Longitude` = '-95.763136' ,`PhotoCount` = '9' ,`PostalCode` = '77406' ,`RoomCount` = '13' ,`ListPrice` = '414990.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn Russet' ,`StreetNumber` = '3415' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 4 Bedroom, 2 ½ Bath, Primary Bedroom Down, Gameroom and Bonus Room Up, Dining/Study, Family Room, Breakfast Room, Extended Primary Closet, Separate Garden Tub and Shower in Primary Bath, Quartz Kitchen Countertops, Herringbone Tile Kitchen Backsplash, Stainless Steel Appliance Package, Recessed Kitchen Lights, 42” Upper Kitchen Cabinets, Upgraded Sink Faucet, Wrought Iron Stair Railing, Luxury Vinyl Plank in Entry, Dining/Study, Kitchen, Breakfast and Family Room, Tile in all Bathrooms, Upgraded Carpet and Pad, 2” Window Covers, Mahogany Front Door, Upgraded Light and Plumbing Packages, Covered Back Patio plus more...AVAILABLE NOVEMBER.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 13 BLK 1 SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6218' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'McCrary Meadows' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664894073' WHERE `Matrix_Unique_ID` = '213161841' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T06:10:52.897' ,`MLSNumber` = '91843177' ,`ListAgentFullName` = 'Jennifer Pareya' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.709466' ,`Longitude` = '-95.168202' ,`PhotoCount` = '22' ,`PostalCode` = '77503' ,`RoomCount` = '3' ,`ListPrice` = '139900.00' ,`Status` = 'Active' ,`StreetName` = 'Darling' ,`StreetNumber` = '3113' ,`StreetSuffix` = 'Avenue' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1310' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this Darling of a Deal! Add this 3/2/2 property to your portfolio. Handyman special with a possibility of adding value by turning the detached garage in an income producing property. \r\nThis property already has two driveways.' ,`Acres` = '0.1263' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'E 20 FT OF LT 183 & W 35 FT OF LT 184 DEEPWATER' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'DEEPWATER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'DEEPWATER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Deepwater' ,`TaxAmount` = '2934' ,`TaxRate` = '2.6198' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894073' WHERE `Matrix_Unique_ID` = '213209664' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-04T07:01:01.387' ,`MLSNumber` = '67539011' ,`ListAgentFullName` = 'Shannon Sudderth' ,`ListOfficeName` = 'ERA Legacy Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.270654' ,`Longitude` = '-94.843723' ,`PhotoCount` = '8' ,`PostalCode` = '77551' ,`RoomCount` = '3' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Jones' ,`StreetNumber` = '7308' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WILL RESUME SHOWINGS ON THE 16th AFTER CURRENT TENANTS MOVE OUT. Sellers will be replacing the floors and renovating both bathrooms. Come one come all... this GEM wont last! This beautiful home is located in a prime location in Galveston, less than 5 minutes away from the beach. You will find the open layout of this property inviting and full of possibilities. Over the past couple of years there have been many renovations on this property, such as; paint throughout, kitchen cabinets, back splash, countertops, light fixtures, as well as heavy duty wind storm windows were installed. If you are desiring a home with a relaxing courtyard in the back that you can kick off your shoes and relax in, well this is your opportunity to have your oasis!(Also for lease)' ,`Acres` = '0.1148' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Near West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 PAGE 78 LOT 5 MAGNOLIA HEIGHTS' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Magnolia Heights' ,`TaxAmount` = '3783' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664894073' WHERE `Matrix_Unique_ID` = '213211046' --> 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','213244934','1664894074','213244934','2022-10-04T07:49:45.827','14476114','Amalia Ohe','CB&A, Realtors','','','29.675879','-95.901787','44','77441','7','489000.00','Active','Parkside Passage','30623','Drive','Fulshear','3','1','4','2805','Single-Family','This is your chance to live in the highly sought after area of Fulbrook. This home has it all! With 4 bedrooms, 3 and a half baths, a game room upstairs, and an office with french doors, this home is perfect for any family. The primary bedroom features a luxurious ensuite with separate shower, large soaking tub, double sinks and walk in closet. You\'ll love the wood floors throughout the first floor main living area and the open floor plan between the living room and kitchen. The kitchen is an entertainers dream with stainless appliances, large island eat at island and walk in pantry. The covered back patio is perfect for enjoying outdoor time with friends and family. Don\'t miss out on this one! No showings until this Saturday for an open house.','0.1475','30','Newmark Homes','','Electric Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Fulshear/South Brookshire/Simonton','Central Electric','1','FULBROOK ON FULSHEAR CREEK SEC 14, BLOCK 1, LOT 23','Subdivision Lot','6427','Appraisal District','','1200','0','','3','Convection Oven,Gas Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','HUGGINS ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1.5','Contemporary/Modern','Fulbrook On Fulshear Creek Sec 14','10626','2.9978','Water District','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','213245414','1664894074','213245414','2022-10-04T07:02:12.507','7417812','Jill Seeley','Seeley Properties','','','30.153898','-95.381155','28','77386','13','369500.00','Active','Chapel Rock Lane','31846','','Spring','2','0','4','2160','Single-Family','Welcome to 31846 Chapel Rock Lane, a beautifully upgraded home located in highly sought after Falls at Imperial Oaks. This 1 story home has a fantastic open floor plan with 4 bedrooms and 2 bathrooms. The home has been gorgeously upgraded with 7.5\" white oak wood floors, custom millwork, all new ceiling fans, new lighting throughout, and luxurious wider baseboards. The kitchen features statuario marble and new subway backsplash. Both bathrooms have upgraded faucets, new shower and floor tile, as well as new mirrors and fixtures. This well-maintained home looks out on a backyard oasis. Welcome to your new home!','','15','','','Electric Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','','','Spring Northeast','Central Gas','1','S504210 - Falls At Imperial Oaks 10, BLOCK 1, Lot 33','Subdivision Lot','6088','Appraisal District','','650','0','','2','Gas Oven','0','','','Electric Range,Freestanding Range','','Composition','11 - Conroe','BIRNHAM WOODS ELEMENTARY SCHOOL','GRAND OAKS HIGH SCHOOL','YORK JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','Falls at Imperial Oaks','8703','3.0687','Water District','2014','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213257944','1664894074','213257944','2022-10-04T07:44:46.793','13635362','Tonya Kiliddjian','RE/MAX Associates Northeast','','','30.166995','-95.298218','32','77357','4','247000.00','Active','Woodpecker','18137','Trail','New Caney','2','0','3','1477','Single-Family','New! New! New! Smart-home in unbelievable location!\" Fantastic Newer Construction Home that has it all! Charming one story with designer details at every corner! Wonderful open floor plan! Spacious kitchen and living spaces! Other features include landscape package, full sprinkler system, granite in kitchen and EVPlank flooring in entry, kitchen and wet areas. The large master bathroom offers double sinks , separate tub and shower and a massive walk-in closet. The kitchen offers stainless appliances, spacious pantry. FRIDGE, WASHER AND DRYER included with the sale. Never run out of hot water with the homes energy efficient tankless water heater! Enjoy and relax rain or shine on your amazing covered patio. Porters Mill is a lovely community located 2 miles north from The Grand Parkway off FM1314 and Gene Campbell Rd.','0.1373','40','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Porter/New Caney West','Central Gas','1','S812700 - PORTERS MILL 01, BLOCK 1, LOT 12','Subdivision Lot','5980','Appraisal District','','700','0','','2','Gas Oven','0','','','Gas Range','','Composition','39 - New Caney','ROBERT CRIPPEN ELEMENTARY SCHOOL','PORTER HIGH SCHOOL (NEW CANEY)','WHITE OAK MIDDLE SCHOOL (NEW CANEY)','Appointment Required,Lockbox Front,Supra Keybox','Appraisal','1','Ranch,Traditional','Porters Mill 01','','','Water District','2019','Appraisal'); --> 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','213262378','1664894074','213262378','2022-10-04T06:49:07.803','95511473','Mike Schroeder','RE/MAX Preferred Homes','','','29.866056','-95.726316','0','77449','5','224900.00','Active','Young Meadows','20915','Way','Katy','2','0','3','1440','Single-Family','Now is your opportunity to live in the popular Lakeville community. This beautiful one-story home offers 3 bedrooms and 2 baths. The family room is generous in space and can be used to fit your needs. The lovely open kitchen includes granite counter tops, a large island and all appliances including the refrigerator. Washer and Dryer are also included. If you have pets or kids or both, you love the private fenced backyard!','0.0943','25','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','1','Bear Creek South','Central Gas','1','LT 16 BLK 5 LAKEVILLE SEC 1','Subdivision Lot','4107','Appraisal District','','600','0','','2','Gas Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','HEMMENWAY ELEMENTARY SCHOOL','CYPRESS PARK HIGH SCHOOL','ROWE MIDDLE SCHOOL','Lockbox Back,Supra Keybox','Appraisal District','1','Traditional','Lakeville Sec 01','4731','2.831','Public Sewer,Public Water','2003','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213271365','1664894074','213271365','2022-10-04T07:15:52.137','50077447','Arlene Simmons','Realty Associates','','','30.011197','-95.462198','18','77090','5','225000.00','Active','Sweet Lilac','2055','Drive','Houston','2','0','3','1300','Single-Family','Cozy one story!!! 3 bedrooms w/ 2 full baths. Five year old home in the Gated community of Sugar Pine Square. Open floor plan, good size rooms, nice fenced yard for you to enjoy. 42 inch cabinets, breakfast bar, refrigerator, and new dishwasher. Large living area with wood laminate floors. New Carpeting in bedrooms. Fresh paint throughout. Both bathrooms have tub shower combinations. Full 2 car garage. The gated entrance makes it very private. Convenient to the Woodlands, dining, shopping, Bush Airport and I45. Move in ready!','0.0834','13','LGI Homes','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','1960/Cypress Creek North','Central Electric','1','LT 58 BLK 1 SUGAR PINE SQUARE R/P','Cul-De-Sac,Subdivision Lot','3632','Appraisal District','','114','0','','2','Electric Oven,Single Oven','0','','','Electric Range','','Composition','48 - Spring','PONDEROSA ELEMENTARY SCHOOL','WESTFIELD HIGH SCHOOL','EDWIN M WELLS MIDDLE SCHOOL','Appointment Required,Lockbox Front,No Supra Keybox','Appraisal District','1','Traditional','Sugar Pine Square R/P','3820','2.3892','Public Sewer,Water District','2017','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','213271703','1664894074','213271703','2022-10-04T07:19:34.467','42223814','Joe Rothchild','Keller Williams Signature','','','29.638828','-95.762443','9','77406','14','434990.00','Active','Autumn Russet','3403','Trail','Richmond','3','1','5','2883','Single-Family','2 Story, 5 Bedroom, 3 1/2 Bath, Gameroom Up, Primary Bedroom Down, Dual Vanity at Primary Bath with Garden Tub and Separate Shower, Luxury Vinyl Plank at Entry, Dining Room, Living Room, Family Room, Kitchen and Breakfast Area, Carpet at Stairs, all Bedrooms and Gameroom, Granite Kitchen Countertops, 42\" Upper Kitchen Cabinets, Upgraded Trim, Brick Back of Home on 1st Floor, Full Gutters, Wrought Iron Spindles, Rocker Switches, Upgraded Plumbing and Light Fixtures, Stainless Steel Appliance Package, 2\" Window Covers, Garage Door Opener plus more...AVAILABLE NOW!','','37','Devon Street Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Fort Bend County North/Richmond','Central Gas','1','LOT 10 BLK 1 SEC 10','Cul-De-Sac,Subdivision Lot','6962','Appraisal District','','600','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','33 - Lamar Consolidated','FROST ELEMENTARY SCHOOL (LAMAR)','FOSTER HIGH SCHOOL','WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL','No Appointment Required','Builder','2','Traditional','McCrary Meadows','','','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213271852','1664894074','213271852','2022-10-04T07:45:47.850','58538151','Joe Rothchild','Keller Williams Signature','','','29.642696','-95.760740','8','77406','13','389990.00','Active','Aster Meadow','3319','Way','Richmond','3','1','4','2453','Single-Family','2 Story, 4 Bedroom, 3 1/2 Bath with Huge Yard, Kitchen, Breakfast, Family Room, Dining/Study, Gameroom Up, Primary Bedroom Down, Jetted Garden Tub with Separate Shower in Primary Bath, Luxury Vinyl Plank Flooring in Entry, Kitchen/Breakfast, Utility and all Baths, Carpet in Family Room, Gameroom and all Bedrooms, Mahogany Front Door, 42\" Upper Kitchen Cabinets, Laminate Pattern Kitchen Countertops with 2 Extra Coach Lights, Rocker Switches, Wrought Iron Stair Parts, Full Gutters, 2\" Window Covers, Garage Door Opener, plus more...AVAILABLE DECEMBER.','','37','Devon Street Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Fort Bend County North/Richmond','Central Gas','1','LOT 1 BLK 2 SEC 8','Subdivision Lot','11151','Appraisal District','','600','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','33 - Lamar Consolidated','FROST ELEMENTARY SCHOOL (LAMAR)','FOSTER HIGH SCHOOL','WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','McCrary Meadows','','','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213271900','1664894074','213271900','2022-10-04T07:49:40.583','41249102','Jennifer Arnold','Realty Associates','','','29.344051','-95.071827','34','77510','8','350000.00','Active','Avenue','7017','','Santa Fe','2','0','3','1513','Single-Family','Completely remodeled 3-bedroom 2-bath home in a quiet neighborhood and country living at its best!! .911 Acres. \r\n No HOA or restrictions and home has never flooded! Home sits on almost an acre. New electrical throughout. Whole house rewired and also ran underground to pole so you could put driveway on side. All new plex plumbing through and under home. New ceiling fans, security lights on outside of home, and no galvanized piping. New Aerobic septic system, new gutters, new 50-gallon water heater, New Ac (whole unit and in attic). New floors throughout. Completely updated kitchen with new appliances and fridge, new cabinets, quartz countertops, and huge walk-in pantry with an outlet. New roof 2017. This home is brand new!!! Schedule your showing today!','0.911','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Santa Fe','Central Electric','0','ABST 48 L CRAWFORD SUR LOT 7 GREENBRIAR UNRECORDED SUB SEC 3','Cleared,Other','39683','Appraisal District','','','0','','1','Electric Oven','0','','','Electric Range','','Composition','45 - Santa Fe','DAN J KUBACAK ELEMENTARY SCHOOL','SANTA FE HIGH SCHOOL','SANTA FE JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Back,Vacant/Unoccupied','Seller','1','Traditional','Greenbriar 3','3099','2.0881','Well','1972','Appraisal District'); --> New record created successfully