Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:33:45.833' ,`MLSNumber` = '70109884' ,`ListAgentFullName` = 'Lloyd Lee' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.789271' ,`Longitude` = '-95.372272' ,`PhotoCount` = '21' ,`PostalCode` = '77009' ,`RoomCount` = '3' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Houston' ,`StreetNumber` = '3419' ,`StreetSuffix` = 'Avenue' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1427' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1576' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 1 WOODLAND BAPTIST' ,`LotDesciption` = 'Other' ,`LotSize` = '6864' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Woodland Baptist' ,`TaxAmount` = '12451' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705540' WHERE `Matrix_Unique_ID` = '200481935' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:52:14.840' ,`MLSNumber` = '96162036' ,`ListAgentFullName` = 'Matthew Silva' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.338561' ,`Longitude` = '-95.057336' ,`PhotoCount` = '14' ,`PostalCode` = '77327' ,`RoomCount` = '7' ,`ListPrice` = '305900.00' ,`Status` = 'Active' ,`StreetName` = 'Kingstson Heath' ,`StreetNumber` = '30140' ,`StreetSuffix` = 'Drive' ,`City` = 'Cleveland' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2316' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to the Grand Oaks Reserve. This 4 bedroom, 3 bath home offers a spacious kitchen with granite countertops, 36\" shaker cabinets, Frigidaire stainless steel appliances (gas range, dishwasher & microwave). The primary bedroom features a tray ceiling and a luxurious bathroom with a modern modular tub & separate shower. Three well-proportioned secondary bedrooms, one with its own en-suite bathroom to complete this package. This home has a covered front porch as well as a large covered rear patio. Brick on all four sides, doubled pane low E windows, high-efficiency HVAC make this home energy efficient. You will also see that we offer beautiful 5 1/4\" baseboards throughout the home. This home comes with front landscaping and a fully sodded backyard. Schedule a tour of this beauty today.' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'Adams Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND OAKS RESERVE, SEC 2, BLOCK 3, LOT 8, ACRES .1711' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7454' ,`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` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Oaks Reserve' ,`TaxAmount` = '' ,`TaxRate` = '2.5613' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705540' WHERE `Matrix_Unique_ID` = '201353916' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:40:02.680' ,`MLSNumber` = '226465' ,`ListAgentFullName` = 'Penny Clissold' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.986688' ,`Longitude` = '-95.540641' ,`PhotoCount` = '30' ,`PostalCode` = '77069' ,`RoomCount` = '4' ,`ListPrice` = '306000.00' ,`Status` = 'Active' ,`StreetName` = 'Tournament' ,`StreetNumber` = '6819' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2067' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is one of the newest homes in Champions Creek. Built in 2009 it is 17 years NEWER than any others in the subdivision. You have great insulation (even over garage) and high ceilings. The kitchen is totally open to the den and dining. The home has a great location and is just steps from the park area that runs throughout this area. This home is just the perfect size. Upstairs you will find two bedrooms and a bathroom. Large master downstairs with a huge en-suite. Large walk in shower. Garden tub. Vanity area and two large walk in closets. This home is brick all the way around except in the back of home. Great floor plan and lots to love.' ,`Acres` = '0.0695' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 57 BLK 7 CHAMPIONS CREEK' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '3027' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Champions Creek' ,`TaxAmount` = '6366' ,`TaxRate` = '2.5156' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705540' WHERE `Matrix_Unique_ID` = '205231198' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:30:25.377' ,`MLSNumber` = '71327100' ,`ListAgentFullName` = 'April Wright' ,`ListOfficeName` = 'Crockett Springs Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.318571' ,`Longitude` = '-95.446353' ,`PhotoCount` = '27' ,`PostalCode` = '75835' ,`RoomCount` = '3' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'South 12th Street' ,`StreetNumber` = '100' ,`StreetSuffix` = '' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2230' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 3br 2.5 bath on 2 city lots in a low traffic neighborhood. This historic home is loaded with charm with features like built-in bookcases, china cabinets, glass doorknobs, refurbished wood floors, and a beautiful sunroom. The roof is brand new, gutters have just been installed, and all appliances convey! Behind the house is vacant land which creates a nice sense of privacy in the backyard.' ,`Acres` = '0.323' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TURNER TERRACE AND A E GOSSETT, LOT 11, AB 423, BEING .323 A' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '57 - Crockett' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (CROCKETT)' ,`SchoolHigh` = 'CROCKETT HIGH SCHOOL (CROCKETT)' ,`SchoolMiddle` = 'CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Turner Terrace' ,`TaxAmount` = '2508' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1925' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705540' WHERE `Matrix_Unique_ID` = '205408470' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:55:38.667' ,`MLSNumber` = '45490081' ,`ListAgentFullName` = 'Amy Ennis' ,`ListOfficeName` = 'Realty ONE Group, Experience' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.300783' ,`Longitude` = '-94.273455' ,`PhotoCount` = '28' ,`PostalCode` = '75929' ,`RoomCount` = '3' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 2558' ,`StreetNumber` = '213' ,`StreetSuffix` = '' ,`City` = 'Broaddus' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2405' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FISHERMAN\'S DREAM!! This charming home with oversized garage is the perfect place to retreat and enjoy the quiet life in the quaint town of Broaddus. It is a short 5 minute drive from Sam Rayburn Reservoir with easy boat launch access. The house sits on 2 full acres with a small pond at the back of the property. It features an open floorplan, covered patio and extra parking for guests. You don\'t want to miss out on seeing this beautiful property!!' ,`Acres` = '2' ,`Area` = '78' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 433 W GRAHAM & IMPROVEMENT' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '232 - Broaddus' ,`SchoolElementary` = 'BROADDUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BROADDUS HIGH SCHOOL' ,`SchoolMiddle` = 'BROADDUS HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'AB 433 W GRAHAM & IMPROVEMENT' ,`TaxAmount` = '2584' ,`TaxRate` = '1.4992' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705540' WHERE `Matrix_Unique_ID` = '205978586' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:29:57.250' ,`MLSNumber` = '86364355' ,`ListAgentFullName` = 'Regina Kirk' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.107533' ,`Longitude` = '-94.150457' ,`PhotoCount` = '40' ,`PostalCode` = '77706' ,`RoomCount` = '3' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Thomas' ,`StreetNumber` = '4425' ,`StreetSuffix` = 'Lane' ,`City` = 'Beaumont' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2661' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated one-story home in The Park on Thomas Road. Open living/dining area that is great for entertaining with a gas log fireplace. Large sliding glass patio doors, skylight, and high ceilings offer great natural lighting. Updated with modern Luxury Vinyl Flooring and LED lighting. Kitchen includes Stainless Apron Sink, Butcher Block Style Countertops, Quartz waterfall breakfast bar, and Jenn Air Electric Cooktop. Primary bedroom includes 2 updated primary bathrooms (one with jetted tub, one with walk-in shower) with walk-in closets in each. Two other bedrooms are located away from primary bedroom with updated shared bathroom in between. Laundry room with 1/2 bath and ample storage. Bar area with beverage cooler. Shutters throughout the home. HOA fees provide access to pool and tennis courts. Conveniently located to shopping and Interstate 10 access. Refrigerator, washer, and dryer included.' ,`Acres` = '0.1776' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE PARK ON THOMAS ROAD-2 L2 B6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7738' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'REGINAL-HOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park On Thomas Road' ,`TaxAmount` = '8134' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705540' WHERE `Matrix_Unique_ID` = '206386686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:41:53.377' ,`MLSNumber` = '37072468' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = 'Carlos Izquierdo' ,`SellingOfficeName` = 'Houston Homes Legacy Group LLC' ,`Latitude` = '29.623333' ,`Longitude` = '-95.419277' ,`PhotoCount` = '12' ,`PostalCode` = '77045' ,`RoomCount` = '11' ,`ListPrice` = '351047.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Painted Sunrise' ,`StreetNumber` = '2819' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1842' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to where the city meets the suburbs! Stunning Auburn home design features 4 bedrooms, 2 baths and 2 car garage. Convenient home office tucked off foyer. The kitchen offers sleek granite countertops with a lowered bar top. Huge walk-in closet, double sinks, separate tub and shower in owner\'s bath. \r\nBayou Oaks at West Orem is a beautiful, gated community conveniently located near the 610 Loop, Hwy 288, Alt 90 and is between Pearland and the Medical Center. Must see; call to schedule appointment to see this lovely home! Offered By: K. Hovnanian Houston Bayou Oaks at West Orem, LLC.' ,`Acres` = '' ,`Area` = '18' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '5/2/8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4968' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '610' ,`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` = 'PETERSEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bayou Oaks at West Orem' ,`TaxAmount` = '' ,`TaxRate` = '2.89' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705540' WHERE `Matrix_Unique_ID` = '206572248' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:46:12.317' ,`MLSNumber` = '54844671' ,`ListAgentFullName` = 'Destiny Winters' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812102' ,`Longitude` = '-95.353137' ,`PhotoCount` = '9' ,`PostalCode` = '77009' ,`RoomCount` = '3' ,`ListPrice` = '225900.00' ,`Status` = 'Active' ,`StreetName` = 'Euel' ,`StreetNumber` = '1509' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '852' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity for an investment property. This property is located right inside the 6-10 loop and is only 10 minutes from Downtown Houston. Lot is large enough for multiple townhomes. This area is developing rapidly, New business are opening within walking distance including a gym and eateries! This is a great opportunity for a builder / developer. ' ,`Acres` = '0.1435' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 205 RYON' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'JEFFERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Ryon' ,`TaxAmount` = '1895' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705541' WHERE `Matrix_Unique_ID` = '206809761' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:44:10.390' ,`MLSNumber` = '58784064' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.904444' ,`Longitude` = '-95.519510' ,`PhotoCount` = '23' ,`PostalCode` = '77064' ,`RoomCount` = '3' ,`ListPrice` = '249999.00' ,`Status` = 'Active' ,`StreetName` = 'Bova' ,`StreetNumber` = '8011' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1878' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two story home with 2 bedrooms, 2.5 bathrooms and a 2 car garage. This home has some great features like a lovely fireplace and fenced backyard. It currently features new interior/exterior paint, new light fixtures, and new carpet. This location offers you many shopping and dining locations, and provides you with quick access to TX-249. Give us a call today!' ,`Acres` = '0.1515' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 10 WESTBANK SEC 1 R/P' ,`LotDesciption` = 'Other' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FRAZIER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbank Sec 01 R/P' ,`TaxAmount` = '4055' ,`TaxRate` = '2.567' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705541' WHERE `Matrix_Unique_ID` = '207329724' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:51:31.397' ,`MLSNumber` = '25865283' ,`ListAgentFullName` = 'Amberly Savage' ,`ListOfficeName` = 'Ward Real Estate, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.968368' ,`Longitude` = '-95.960239' ,`PhotoCount` = '23' ,`PostalCode` = '77414' ,`RoomCount` = '4' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Lazy' ,`StreetNumber` = '2' ,`StreetSuffix` = 'Lane' ,`City` = 'Bay City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3127' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bed 3 bath home located on a large lot in desired neighborhood. Home features two large living rooms, formal dining, large bedrooms, storage and plenty of room to spread out. This home has so much potential and perfect for entertaining.' ,`Acres` = '0.694' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MARYMOUNT S/D LOT 2 & S 81\' LOT 3 BLK 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '30231' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = '' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marymount Sub' ,`TaxAmount` = '8333' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705541' WHERE `Matrix_Unique_ID` = '207596667' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:41:54.143' ,`MLSNumber` = '68774906' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.430928' ,`Longitude` = '-95.408983' ,`PhotoCount` = '50' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '441800.00' ,`Status` = 'Active' ,`StreetName` = 'Kinsey' ,`StreetNumber` = '4034' ,`StreetSuffix` = '' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2262' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 68774906 - Built by Highland Homes - November completion! ~ Model Home Plan! Designed with livability in mind. Home features secondary bedroom and full bathroom downstairs- perfect for guests! Soaring ceilings at the entry and family room make this home feel grand. The kitchen is a dream- complete with built-in stainless steel appliances, quartz countertops, and large kitchen island that can accommodate guest seating! Entertaining is easy & comfortable with this open layout. Owners suite features luxurious freestanding tub and large walk-in closet! Upstairs, you\'ll find 2 bedrooms and full bath, with a game room! Unwind on the extended covered patio and enjoy the tranquility of Meridiana. Located only 10 min from Pearland. Community features UNMATCHED amenities such as cafe, 24hr gym with heated lap pool, resort style pool & splashpad, lifestyle coordinator for weekly activities, and more! ONSITE SCHOOLS! Make an appointment to tour today!!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = '7/3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '0' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705541' WHERE `Matrix_Unique_ID` = '207731302' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:42:31.440' ,`MLSNumber` = '90800121' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.431609' ,`Longitude` = '-95.409198' ,`PhotoCount` = '50' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '453214.00' ,`Status` = 'Active' ,`StreetName` = 'Watson' ,`StreetNumber` = '4026' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2465' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 90800121 - Built by Highland Homes - November completion! ~ From the eye-catching exteriors featuring painted brick, to the soaring 19ft ceilings at the entry, this home will impress you! Eye-catching modern stair rails set this home apart. Enjoy entertaining in the gourmet kitchen complete with quartz countertops, built-in stainless steel appliances, & pendant lighting for a custom touch! Secondary bedroom with full bath downstairs' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = '19/2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '0' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705541' WHERE `Matrix_Unique_ID` = '207944628' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:37:27.527' ,`MLSNumber` = '26556166' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.444498' ,`Longitude` = '-95.400583' ,`PhotoCount` = '19' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '739829.00' ,`Status` = 'Active' ,`StreetName` = 'Coronado' ,`StreetNumber` = '4635' ,`StreetSuffix` = 'Court' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 26556166 - Built by Highland Homes - October completion! ~ Highland\'s signature soaring ceilings catch your eye as soon as you walk into this home! Off the entry is a spacious study, perfect for working from home. Secondary bedroom with en-suite bath is tucked away downstairs, ideal for a guest suite. You\'ll love to entertain in this kitchen with the huge kitchen island that can accommodate additional seating. Features upgrades galore such as built-in hutch, quartz countertops, marble backsplash, pendant lighting, and more! Gather around the fireplace in the family room, which features eye-catching tile extended to the ceiling. Sliding glass doors lead you to the covered patio where you can enjoy the tranquility of Meridiana. Owners suite is complete with luxurious freestanding tub and large walk-in closet! Host game/movie nights in your own entertainment room upstairs. EXPANDED secondary bedrooms upstairs both have ensuite baths! Make an appointment to tour today!!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 43 (A0286) (MANVEL) BLK 1 LOT 45' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '0' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705541' WHERE `Matrix_Unique_ID` = '207983500' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:41:29.230' ,`MLSNumber` = '34135793' ,`ListAgentFullName` = 'Erica Capistran' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.842441' ,`Longitude` = '-95.463961' ,`PhotoCount` = '17' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Creekmont' ,`StreetNumber` = '4944' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2360' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Rosslyn Heights! Neighboring the highly coveted Oak Forest, this new construction home’s modern finishes and spacious rooms are unparalleled. The home features a first floor bedroom and full bathroom making it a convenient space for guests or for a home office. Also on the first floor you’ll find open concept living with tons of natural light and a kitchen with island, stainless steel appliances, and a walk-in pantry. Space won’t be issue in your primary suite which includes a large bedroom with tray ceilings, spacious walk in shower, and a closet that goes on forever. Find two more generously sized bedrooms with walk-in closets on the second floor. Ready for a new owner by early Fall!\n*Photos of completed home are of a similar sold development on Creekmont' ,`Acres` = '0.0689' ,`Area` = '9' ,`BuilderName` = 'Better Place Texas' ,`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` = '0' ,`Legal` = 'LT 37 BLK 22 ROSSLYN HEIGHTS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`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` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Rosslyn Heights Sec 01' ,`TaxAmount` = '699' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705541' WHERE `Matrix_Unique_ID` = '207994483' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:18:46.757' ,`MLSNumber` = '47887515' ,`ListAgentFullName` = 'Susan Taylor' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.224976' ,`Longitude` = '-95.125047' ,`PhotoCount` = '22' ,`PostalCode` = '77372' ,`RoomCount` = '7' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'May' ,`StreetNumber` = '28357' ,`StreetSuffix` = 'Road' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1813' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on the market; buyers funding fell thru\r\nReady to leave the city? Nice 4/2 country home on almost 2 acres. Updates include:\r\n6/21 house was painted\r\n8/21 16 seer air conditioning system with 10 yr warranty installed\r\n9/21 new subfloor installed \r\n9/21 foundation and roofing inspected both passed\r\n10/21 new butcher block counter tops installed\r\n10/21 new kitchen sink \r\n10/21 garbage disposal replaced\r\n12/21 new carpet and upgraded padding installed \r\n12/21 lifeproof laminate flooring installed with lifetime warranty\r\n1/22 replaced all fence post and fencing \r\n2/22 replace water heater (50 gal) 7 yr warranty\r\n2/22 new back porch\r\n4/22 replaced flooring insulation \r\n6/22 replaced aerobic system pump' ,`Acres` = '1.956' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S870000 - SHADY DALE, LOT 16B-1, ACRES 1.956' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '85203' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'GREENLEAF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Shady Dale' ,`TaxAmount` = '3202' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705542' WHERE `Matrix_Unique_ID` = '208552254' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:10:30.507' ,`MLSNumber` = '86333039' ,`ListAgentFullName` = 'Gary Bisha' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.330058' ,`Longitude` = '-95.465199' ,`PhotoCount` = '37' ,`PostalCode` = '77583' ,`RoomCount` = '13' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Hill' ,`StreetNumber` = '17702' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4202' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 5 BR home with 3-car garage on 2 acres. A beautiful winding staircase greets you as you enter your new home. The chef\'s kitchen features stainless steel appliances, double ovens, gas cooktop, walk in pantry and breakfast area. Family room has soaring ceilings, a 20\' stone fireplace and wall of windows with great views of the expansive backyard. Large formal dining room and study. Luxurious master suite and bath features whirlpool tub accented by a TV and private gas log fireplace. Second bedroom downstairs with private bath. Three bedrooms upstairs plus a Jack and Jill bath. Exercise room plus a fantastic game/media room complete with kitchenette. Large mud/utility room. Easy access to 288. Come see today!' ,`Acres` = '2' ,`Area` = '5' ,`BuilderName` = 'Atlantis' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'SUNCREEK ESTATES SEC 1 (A0068 J W HALL), BLOCK 12, LOT 14, A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Suncreek Estates' ,`TaxAmount` = '11552' ,`TaxRate` = '2.3339' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705542' WHERE `Matrix_Unique_ID` = '208843647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:22:53.950' ,`MLSNumber` = '15816252' ,`ListAgentFullName` = 'W. Tony Chavez' ,`ListOfficeName` = 'Winhill Advisors - Kirby' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.496402' ,`Longitude` = '-95.128538' ,`PhotoCount` = '46' ,`PostalCode` = '77573' ,`RoomCount` = '8' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Branch' ,`StreetNumber` = '311' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2638' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic Home in the gorgeous Cedar Landing Subdivision! The 2 story, 4 bedrooms, and 2 1/2 bathrooms offer the perfect living areas to enjoy being home. The great formal dining welcomes you, followed by the kitchen that opens to the family room with high ceilings, large windows, and a fireplace. The spacious main bedroom features a large sized vanity, separate shower and tub, and a nice walk-in closet. Upstairs, the game room and 3 secondary bedrooms are the perfect areas to relax. Zoned to the well-recognized CCISD, easy commute to \r\nI-45 and close to shopping, dining, and entertaining, this Home is a gem!' ,`Acres` = '0.1616' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CEDAR LANDING SEC 1 (2000) ABST 9, BLOCK 4, LOT 2, ACRES 0.1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROSS ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Landing Sec 1 2000' ,`TaxAmount` = '6051' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705542' WHERE `Matrix_Unique_ID` = '209111702' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:41:18.340' ,`MLSNumber` = '76296430' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.430822' ,`Longitude` = '-95.409480' ,`PhotoCount` = '15' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '410872.00' ,`Status` = 'Active' ,`StreetName` = 'Kinsey' ,`StreetNumber` = '4018' ,`StreetSuffix` = '' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1959' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 76296430 - Built by Highland Homes - November completion! ~ This one story home features eye-catching upgraded exteriors complete with painted brick. Structure upgrades include spacious master bay window extension, extended covered patio, additional powder room for guests, built-in bookcase shelves in the lifestyle space- perfect for a home office, and luxurious freestanding tub in the master bathroom! 11ft ceilings throughout.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = '3/3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705542' WHERE `Matrix_Unique_ID` = '209556876' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:41:55.640' ,`MLSNumber` = '70935098' ,`ListAgentFullName` = 'Erica Capistran' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.842440' ,`Longitude` = '-95.464031' ,`PhotoCount` = '18' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Creekmont' ,`StreetNumber` = '4948' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2360' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Rosslyn Heights! Neighboring the highly coveted Oak Forest, this new construction home’s modern finishes and spacious rooms are unparalleled. The home features a first floor bedroom and full bathroom making it a convenient space for guests or for a home office. Also on the first floor you’ll find open concept living with tons of natural light and a kitchen with island, stainless steel appliances, and a walk-in pantry. Space won’t be issue in your primary suite which includes a large bedroom with tray ceilings, spacious walk in shower, and a closet that goes on forever. Find two more generously sized bedrooms with walk-in closets on the second floor. Ready for a new owner by early Fall!\n*Photos of completed home are of a similar sold development on Creekmont' ,`Acres` = '0.0689' ,`Area` = '9' ,`BuilderName` = 'Better Place Texas' ,`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` = '0' ,`Legal` = 'LT 38 BLK 22 ROSSLYN HEIGHTS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`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` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Rosslyn Heights' ,`TaxAmount` = '699' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705542' WHERE `Matrix_Unique_ID` = '209579776' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:29:09.310' ,`MLSNumber` = '72746607' ,`ListAgentFullName` = 'Joshua Weatherman' ,`ListOfficeName` = 'Ppmg of Texas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.370017' ,`Longitude` = '-95.421863' ,`PhotoCount` = '36' ,`PostalCode` = '77583' ,`RoomCount` = '11' ,`ListPrice` = '667999.00' ,`Status` = 'Active' ,`StreetName` = 'Park Cove' ,`StreetNumber` = '27910' ,`StreetSuffix` = 'Court' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful single story 4 bed, 3.5 bath, 2 car garage home! As you enter you are greeted by a bright, spacious foyer with gorgeous stone flooring & souring ceilings. Off the foyer there is an office & flex space that is currently being used as a gym. Down the hallway you will find 2 bedrooms that share a Jack & Jill bathroom along with a half bath for guests. In the heart of the home you have a massive kitchen overlooking the living room that features a prep-island & tons of bar height seating for the whole family. Off the kitchen is the game room that could also be utilized as a formal dining area. The Guest Suite has an attached bath with walk-in shower & direct access to the screened in porch. The Primary Bedroom is gigantic with direct access to the covered porch. Your spa like Primary Bathroom has separate vanities, deep soaking tub, a massive shower with multiple shower heads, and TWO spacious walk-in closest.' ,`Acres` = '0.6315' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PALM CREST (A0533 C M HAYS) BLK 1 LOT 18 ACRES 0.6315' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '27508' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Palm Crest' ,`TaxAmount` = '842' ,`TaxRate` = '2.2507' ,`WaterSewer` = 'Other Water/Sewer,Septic Tank,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705542' WHERE `Matrix_Unique_ID` = '209582883' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:34:00.610' ,`MLSNumber` = '45381606' ,`ListAgentFullName` = 'Anne Cummins' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.431313' ,`Longitude` = '-95.618773' ,`PhotoCount` = '35' ,`PostalCode` = '77356' ,`RoomCount` = '18' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Logansport' ,`StreetNumber` = '34' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3401' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Find luxury living at the water\'s edge. Move in ready with new carpet just installed 5/24/2022. Waterfront Reserve adjoins this special lot making the lakefront feel like your yard. Acclimated to take in the beautiful water scenes of Lake Conroe from its large-scale windows & grand living spaces. The Primary Retreat encompasses the 2nd Floor for an exceptional living experience. Includes phenomenal sized sleep & sitting areas, Study/Fitness Room, dual cedar lined closets, soaker bubbler tub & a private terrace. Enjoy Bentwater\'s fine resort amenities: world class golf, exhibition tennis, Country Club restaurant, spa, fitness center, plus 24 hour guard gated security. Elevator capable. Drop your kayak or go fishing steps from home. Blocks to the Marina. Whether its to be your forever home or a dream getaway, come experience the unparalleled atmosphere where a few miles takes you to a world away. New roof installed 1/18/2022. Temporary Boat Club membership may be included at no cost.' ,`Acres` = '0.137' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 16, BLOCK 2, LOT 11, 12' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Water View,Wooded' ,`LotSize` = '5967' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1091' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Controlled Access,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '6383' ,`TaxRate` = '2.1898' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705542' WHERE `Matrix_Unique_ID` = '209632250' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:03:17.507' ,`MLSNumber` = '24945517' ,`ListAgentFullName` = 'Nicole Curry' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.738738' ,`Longitude` = '-95.252872' ,`PhotoCount` = '6' ,`PostalCode` = '77547' ,`RoomCount` = '7' ,`ListPrice` = '155000.00' ,`Status` = 'Active' ,`StreetName` = '9th' ,`StreetNumber` = '2512' ,`StreetSuffix` = 'Street' ,`City` = 'Galena Park' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1458' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If large, spacious rooms are what you are looking for then look no further!!! Spacious 3 bedroom with huge converted garage. Garage conversion could be a 4th bedroom or a den/second family room. Laundry room in converted garage. Great sized, quiet backyard with nice shade.' ,`Acres` = '0.1389' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 7 GALENA MANOR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'GALENA PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GALENA PARK HIGH SCHOOL' ,`SchoolMiddle` = 'GALENA PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Galena Manor' ,`TaxAmount` = '2080' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705542' WHERE `Matrix_Unique_ID` = '209679417' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:19:45.317' ,`MLSNumber` = '57819777' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.861265' ,`Longitude` = '-95.398090' ,`PhotoCount` = '9' ,`PostalCode` = '77076' ,`RoomCount` = '2' ,`ListPrice` = '234999.00' ,`Status` = 'Active' ,`StreetName` = 'Riverwood' ,`StreetNumber` = '121' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1119' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brick home in North Houston that consists of 2 bedrooms and 1 bathroom! The home will soon feature new interior paint and cosmetic repairs! This property can flourish with the right person. Additionally, it\'s only 15 minutes away from downtown Houston which means you\'ll have many local shops, eateries and schools found in the area. Give us a call for more information!' ,`Acres` = '0.1443' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 191 BLK 8 GLEN OAKS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6285' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DURKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER' ,`SchoolMiddle` = 'FONVILLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glen Oaks' ,`TaxAmount` = '2680' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705543' WHERE `Matrix_Unique_ID` = '209833786' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:39:54.817' ,`MLSNumber` = '32701141' ,`ListAgentFullName` = 'Drue DaSilva' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.531430' ,`Longitude` = '-95.396389' ,`PhotoCount` = '46' ,`PostalCode` = '77578' ,`RoomCount` = '13' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Maple Oak' ,`StreetNumber` = '2811' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3019' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to this GORGEOUS, BARELY LIVED IN 1-STORY with 4 beds/3.5 baths/3-car garage in the master-planned community of Pomona. With great curb appeal & located on a tree-lined street, it is so close to the neighborhood’s many amenities. Built by Highland Homes, this open-concept floorplan is immaculate, move-in ready, spacious & inviting! It is so functional and includes a study with French doors, open formal dining & family room, flex room entertainment space perfect for a game room or media room & all of the spacious bedrooms are on 1 level. The primary retreat is fabulous & is a spa-like experience with soaking tub, separate shower & large custom closet with Elfa. The home features wood-look tile, ample natural light, high ceilings, blinds, neutral paint, covered patio & NO NEIGHBORS BEHIND. The GOURMET KITCHEN is spectacular with a large island, Benedettini Cabinetry and ample storage & counter space. With the great flow from room to room, this is an ENTERTAINER’S DREAM HOME.' ,`Acres` = '0.1865' ,`Area` = '5' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'POMONA SEC 2 (A0417 ACH&B & A0540 ACH&B) BLK 2 LOT 22' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8124' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1190' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'POMONA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pomona' ,`TaxAmount` = '14930' ,`TaxRate` = '3.6594' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705543' WHERE `Matrix_Unique_ID` = '209882288' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:41:10.197' ,`MLSNumber` = '45651850' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.097331' ,`Longitude` = '-95.602227' ,`PhotoCount` = '14' ,`PostalCode` = '77375' ,`RoomCount` = '3' ,`ListPrice` = '183500.00' ,`Status` = 'Active' ,`StreetName` = 'Blackshear' ,`StreetNumber` = '215' ,`StreetSuffix` = 'Street' ,`City` = 'Tomball' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Tomball area home in a great location! This property consists of 3 bedrooms and 1 bathroom. This home features new interior paint, an upgraded kitchen and bathroom, foundation repairs, and a new 30 year roof. Inside this home you will also find hardwood flooring in select areas and a nice backyard. If you\'re looking for a place to call home, this property is perfect for you and your family. You will love the quick access to TX-249, the closeness to grocery stores, schools, parks, a nearby mall and plenty of dining options. Call us today to schedule your tour!' ,`Acres` = '0.1545' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TR 6B ABST 629 J PRUITT' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6730' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jesse Pruitt Surv' ,`TaxAmount` = '666' ,`TaxRate` = '2.3717' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705543' WHERE `Matrix_Unique_ID` = '210115994' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:19:20.857' ,`MLSNumber` = '6594117' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.956092' ,`Longitude` = '-95.203556' ,`PhotoCount` = '14' ,`PostalCode` = '77346' ,`RoomCount` = '6' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Radura' ,`StreetNumber` = '11814' ,`StreetSuffix` = 'Road' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2180' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION - Extended entry with 12-foot ceiling leads to open kitchen dining area and family room with 10-foot ceilings throughout. Kitchen features walk-in pantry, generous counter space and inviting island with built-in seating space. Dining area features wall of windows. Family room features wall of windows. Primary suite with 10-foot ceiling and wall of windows. Double doors lead to primary bath with dual vanities, garden tub, separate glass-enclosed shower and large walk-in closet with access to utility room. A guest suite with private bath adds to this one-story design. Mud room off two-car garage. Covered backyard patio.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4_Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5749' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1128' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Groves' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705543' WHERE `Matrix_Unique_ID` = '210159021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:35:18.590' ,`MLSNumber` = '31662707' ,`ListAgentFullName` = 'Ozzie Ramirez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.662419' ,`Longitude` = '-95.055457' ,`PhotoCount` = '41' ,`PostalCode` = '77571' ,`RoomCount` = '10' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Winburn Tide' ,`StreetNumber` = '500' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2640' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 4/3 home is a NEWER CONSTRUCTION home and BARELY LIVED IN!! Located in the Morgan\'s Landing subdivision which features amenities such as a gym, pool, lake and trails! This home has rooms that flow nicely into each other for easy living and features lots of storage space! Step onto the beautiful neutral floors and make your way into the spacious kitchen which features Quartz counters, gas oven, breakfast sitting area around island and even has a water filtration system! Living area features high vaulted ceilings. Primary room includes generous size windows that allows all that natural light in. Primary bath encompasses double vanities and a walk-in closet! Charming curb appeal with landscape that\'s easy to maintain! This home also offers several energy features such as digital program thermostat and energy star CFL/LED lights. This home won\'t last so hurry and check it out for yourself!' ,`Acres` = '0.1529' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 3 MORGANS LANDING SEC 5' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6661' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'JENNIE REID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgans Landing' ,`TaxAmount` = '1509' ,`TaxRate` = '3.5108' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705543' WHERE `Matrix_Unique_ID` = '210164801' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:36:03.690' ,`MLSNumber` = '30593420' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.441851' ,`Longitude` = '-95.401737' ,`PhotoCount` = '47' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '688077.00' ,`Status` = 'Active' ,`StreetName` = 'Hudson' ,`StreetNumber` = '9822' ,`StreetSuffix` = 'Street' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2862' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 30593420 - Built by Highland Homes - December completion! ~ This home has light colored brick on a large lot with no back neighbors! Spacious entryway leads you to the kitchen with a hutch followed by sliding glass doors to the covered patio. Modern look with a mix of natural colored flooring, white cabinets, and black accents. Exposed stainless steel vent hood with the backsplash going to the ceiling. Upper glass cabinets!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 43 (A0286) (MANVEL) BLK 1 LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10746' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705543' WHERE `Matrix_Unique_ID` = '210228036' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:54:52.293' ,`MLSNumber` = '2546412' ,`ListAgentFullName` = 'Jessica Reyes' ,`ListOfficeName` = 'Jason Mitchell Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.998927' ,`Longitude` = '-95.547103' ,`PhotoCount` = '34' ,`PostalCode` = '77379' ,`RoomCount` = '4' ,`ListPrice` = '377000.00' ,`Status` = 'Active' ,`StreetName` = 'Hexham' ,`StreetNumber` = '16122' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2691' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to paradise! Go ahead and dive on over to this one! Come take a look at this beauty in the Champion Forest neighborhood. This 2 story home has so much to offer, take a look for yourself.' ,`Acres` = '0.2124' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 34A BLK 20 017*C2915074-003-020-034A CHAMPION FOREST SEC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9254' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BRILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Champion Forest Sec 03' ,`TaxAmount` = '6349' ,`TaxRate` = '2.3465' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705543' WHERE `Matrix_Unique_ID` = '210301232' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:45:58.077' ,`MLSNumber` = '79695906' ,`ListAgentFullName` = 'Elizabeth Coblentz' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.739638' ,`Longitude` = '-95.476581' ,`PhotoCount` = '20' ,`PostalCode` = '77056' ,`RoomCount` = '7' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Wickersham' ,`StreetNumber` = '5661' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1781' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable 3 bedroom home situated on a great lot in Briarcroft Subdivision. Conveniently located near shopping, public/private schools, a wide variety of restaurants offering cuisines from all over the World, plus much more.\r\nThis cozy home flows nicely from the kitchen/breakfast room, dining room, and living room, making it a great home for entertaining. The den is located directly off of the kitchen/dining/living rooms and is a perfect option for an office/workout room/game room/playroom. All bedrooms are located on the left side of the house and the living areas/kitchen on the right side of the house. This is great for privacy and quiet time. Don\'t miss the backyard with plenty of room to play, grill, relax, and enjoy the greenery with the privacy of a fenced-in backyard.' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 1 & 2A BLK 2 BRIARCROFT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '727' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarcroft' ,`TaxAmount` = '15128' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705544' WHERE `Matrix_Unique_ID` = '210359800' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:43:52.140' ,`MLSNumber` = '10050900' ,`ListAgentFullName` = 'Salvador Caballero' ,`ListOfficeName` = 'ListWithFreedom.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.117803' ,`Longitude` = '-95.459519' ,`PhotoCount` = '20' ,`PostalCode` = '77380' ,`RoomCount` = '7' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Wood Scent' ,`StreetNumber` = '53' ,`StreetSuffix` = 'Court' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1668' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 Bedroom, 2.5 bath home in located in The Woodlands, Grogan\'s Mill area. \r\n\r\nRemodeled in 2019: New a/c unit, new furnace, new R8 duct work. Kitchen remodel with Soft close Cabinets and drawers, Granite countertops, black stainless appliances, recessed lighting, and rolling kitchen island. Play room upstairs converted to a 4th bedroom.\r\n\r\nUnique fireplace complements the vaulted ceiling in the living room.' ,`Acres` = '0.1468' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL GROGANS ML 38, BLOCK 5, LOT 46' ,`LotDesciption` = 'Wooded' ,`LotSize` = '6395' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAM HAILEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Grogans Ml 38' ,`TaxAmount` = '4575' ,`TaxRate` = '2.1816' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705544' WHERE `Matrix_Unique_ID` = '210497720' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:33:02.920' ,`MLSNumber` = '28716352' ,`ListAgentFullName` = 'Toya Ohlrich' ,`ListOfficeName` = 'Berkshire Hathaway Home Svs.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733797' ,`Longitude` = '-98.180023' ,`PhotoCount` = '48' ,`PostalCode` = '78132' ,`RoomCount` = '10' ,`ListPrice` = '669000.00' ,`Status` = 'Active' ,`StreetName` = 'Lermann' ,`StreetNumber` = '2550' ,`StreetSuffix` = '' ,`City` = 'New Braunfels' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3369' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This magnificent 2-story home in Manor Creek has it all! Elegant spiral staircase and high ceiling. Downstairs master bedroom has private access to the back yard. Large master bath with separate vanity, garden tub and tile stand-up shower. The huge walk-in closet has access to the laundry room. Kitchen features gas cooktop, pot filler, double oven and built-in microwave. The granite countertops & large island are perfect for cooking and entertaining. Excellent outdoor living space with covered patio. This spacious home offers 4 bedrooms, 2 living areas, 2 dining plus an office and 3 car garage. All this on an oversized corner lot.' ,`Acres` = '0.34' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MANOR CREEK 5A, BLOCK 8, LOT 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '14810' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '195' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '142 - New Braunfels' ,`SchoolElementary` = '' ,`SchoolHigh` = 'NEW BRAUNFELS HIGH SCHOOL' ,`SchoolMiddle` = 'OAKRUN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Manor Creek 5a' ,`TaxAmount` = '12170' ,`TaxRate` = '2.0267' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705544' WHERE `Matrix_Unique_ID` = '210512937' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:31:49.307' ,`MLSNumber` = '85952072' ,`ListAgentFullName` = 'Carlene Johnson' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.341320' ,`Longitude` = '-95.085489' ,`PhotoCount` = '8' ,`PostalCode` = '77327' ,`RoomCount` = '3' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'ROAD 5740' ,`StreetNumber` = '1648' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Stop & Look* Modern, Steel Frame, Smart-Home ready to be built for the eco friendly and energy efficient buyer. Open concept design, energy saving technology and high end finishes are the standard for this builder. Home features include vinyl wood plank flooring, granite countertops, shaker style wood cabinets, energy star stainless steel appliances, energy efficient HVAC system, tankless water heater, and many more eco friendly features. This developing community has Grand Parkway access, additional schools, retail shops and a fire department coming soon/under construction. All in One Loan options are available. Don\'t hesitate - This builder offers multiple models with a build time of less than 90 Days - This Sustainable Smart-Home is ready for you!' ,`Acres` = '0.17' ,`Area` = '52' ,`BuilderName` = 'BOND Containers, Inc' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 9-A, BLOCK 185, LOT 9524, ACRES .17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7405' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'SANTA FE' ,`TaxAmount` = '' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663705544' WHERE `Matrix_Unique_ID` = '210616574' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:42:01.833' ,`MLSNumber` = '24903151' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.202611' ,`Longitude` = '-95.429108' ,`PhotoCount` = '38' ,`PostalCode` = '77385' ,`RoomCount` = '6' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Silverling' ,`StreetNumber` = '9903' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remarkable 4 bed 2 bath home located on a corner lot in the highly sought after master planned community of Harper\'s Preserve in Conroe! This home features 2,000 Sq Ft of living space and boasts the ultimate open concept floor plan. The galley-style kitchen flaunts stunning quartz countertops, pendant lighting, gas range stove, walk-in pantry, and a large island that opens up to the oversized family room & dining area. The primary bedroom is generously sized and features a private en-suite bath with dual sinks, a separate shower and soaking tub, and a walk-in closet. Exterior features include four-sided brick, gutters, landscaping, and a massive fenced-in backyard. This community offers something for everyone, such as a gated entrance, pools, playgrounds, walking trails, bowling, and SO much more! In Harper\'s Preserve you are located a short distance from Lake Conroe and the amenities offered in Conroe and The Woodlands. This home is priced to sell and won\'t last long!' ,`Acres` = '0.1649' ,`Area` = '15' ,`BuilderName` = 'MI Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S572722 - HARPER\'S PRESERVE 22-A, BLOCK 1, LOT 14' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '7184' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1127' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harpers Preserve' ,`TaxAmount` = '436' ,`TaxRate` = '3.0088' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705544' WHERE `Matrix_Unique_ID` = '210668735' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:31:15.203' ,`MLSNumber` = '78532246' ,`ListAgentFullName` = 'Carlene Johnson' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.341320' ,`Longitude` = '-95.085489' ,`PhotoCount` = '6' ,`PostalCode` = '77327' ,`RoomCount` = '2' ,`ListPrice` = '179900.00' ,`Status` = 'Active' ,`StreetName` = 'ROAD 5740' ,`StreetNumber` = '1644' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Stop & Look* Modern, Steel Frame, Smart-Home ready to be built for the eco friendly and energy efficient buyer. Open concept design, energy saving technology and high end finishes are the standard for this builder. Home features include vinyl wood plank flooring, granite countertops, shaker style wood cabinets, energy star stainless steel appliances, energy efficient HVAC system, tankless water heater, and many more eco friendly features. This developing community has Grand Parkway access, additional schools, retail shops and a fire department coming soon/under construction. All in One Loan options are available. Don\'t hesitate - This builder offers multiple models with a build time of less than 90 Days - This Sustainable Smart-Home is ready for you!' ,`Acres` = '0.17' ,`Area` = '52' ,`BuilderName` = 'BOND Containers, Inc' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 9-A, LOT 185, BLOCK 9523, ACRES .17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7405' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'SANTA FE' ,`TaxAmount` = '' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663705544' WHERE `Matrix_Unique_ID` = '210786214' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:29:55.567' ,`MLSNumber` = '29188686' ,`ListAgentFullName` = 'Carlene Johnson' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.341320' ,`Longitude` = '-95.085489' ,`PhotoCount` = '8' ,`PostalCode` = '77327' ,`RoomCount` = '5' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'ROAD 5740' ,`StreetNumber` = '1645' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Stop & Look* Modern, Steel Frame, Smart-Home ready to be built for the eco friendly and energy efficient buyer. Open concept design, energy saving technology and high end finishes are the standard for this builder. Home features include vinyl wood plank flooring, granite countertops, shaker style wood cabinets, energy star stainless steel appliances, energy efficient HVAC system, tankless water heater, and many more eco friendly features. This developing community has Grand Parkway access, additional schools, retail shops and a fire department coming soon/under construction. All in One Loan options are available. Don\'t hesitate - This builder offers multiple models with a build time of less than 90 Days - This Sustainable Smart-Home is ready for you!' ,`Acres` = '0.2' ,`Area` = '52' ,`BuilderName` = 'BOND Containers, Inc' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 9-A, BLOCK 184, LOT 9423, ACRES .2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8712' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'SANTA FE' ,`TaxAmount` = '' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705544' WHERE `Matrix_Unique_ID` = '210789755' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:29:22.153' ,`MLSNumber` = '95046565' ,`ListAgentFullName` = 'Carlene Johnson' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.341320' ,`Longitude` = '-95.085489' ,`PhotoCount` = '6' ,`PostalCode` = '77327' ,`RoomCount` = '3' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'ROAD 5740' ,`StreetNumber` = '1649' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Stop & Look* Modern, Steel Frame, Smart-Home ready to be built for the eco friendly and energy efficient buyer. Open concept design, energy saving technology and high end finishes are the standard for this builder. Home features include vinyl wood plank flooring, granite countertops, shaker style wood cabinets, energy star stainless steel appliances, energy efficient HVAC system, tankless water heater, and many more eco friendly features. This developing community has Grand Parkway access, additional schools, retail shops and a fire department coming soon/under construction. All in One Loan options are available. Don\'t hesitate - This builder offers multiple models with a build time of less than 90 Days - This Sustainable Smart-Home is ready for you!' ,`Acres` = '0.21' ,`Area` = '52' ,`BuilderName` = 'BOND Containers, Inc' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 9-A, BLOCK 184, LOT 9424, ACRES .21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9147' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'SANTA FE' ,`TaxAmount` = '' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663705545' WHERE `Matrix_Unique_ID` = '210789821' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:28:47.910' ,`MLSNumber` = '75362859' ,`ListAgentFullName` = 'Carlene Johnson' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.341320' ,`Longitude` = '-95.085489' ,`PhotoCount` = '6' ,`PostalCode` = '77327' ,`RoomCount` = '6' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'ROAD 5740' ,`StreetNumber` = '1653' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Stop & Look* Modern, Steel Frame, Smart-Home ready to be built for the eco friendly and energy efficient buyer. Open concept design, energy saving technology and high end finishes are the standard for this builder. Home features include vinyl wood plank flooring, granite countertops, shaker style wood cabinets, energy star stainless steel appliances, energy efficient HVAC system, tankless water heater, and many more eco friendly features. This developing community has Grand Parkway access, additional schools, retail shops and a fire department coming soon/under construction. All in One Loan options are available. Don\'t hesitate - This builder offers multiple models with a build time of less than 90 Days - This Sustainable Smart-Home is ready for you!' ,`Acres` = '0.21' ,`Area` = '52' ,`BuilderName` = 'BOND CONTAINERS, Inc' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 9-A, LOT 184, BLOCK 9425, ACRES .21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9147' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'SANTA FE' ,`TaxAmount` = '' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663705545' WHERE `Matrix_Unique_ID` = '210790424' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:10:40.530' ,`MLSNumber` = '30934835' ,`ListAgentFullName` = 'Amable Sosa' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.385769' ,`Longitude` = '-94.963510' ,`PhotoCount` = '22' ,`PostalCode` = '77591' ,`RoomCount` = '3' ,`ListPrice` = '189999.00' ,`Status` = 'Active' ,`StreetName` = 'Pecan' ,`StreetNumber` = '131' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make this beautiful home your vacation or retire home! 2BR 1Full Bath newly renovated. Only minutes from beautiful Texas City beach.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 639 PAGE 1 N 1/2 OF LOT 13 (13-2) BLK B KOHFELDTS SUB' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'SIMMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kohfeldt' ,`TaxAmount` = '747' ,`TaxRate` = '2.5333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705545' WHERE `Matrix_Unique_ID` = '210842546' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:12:05.870' ,`MLSNumber` = '76659361' ,`ListAgentFullName` = 'Billie Rea' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.541636' ,`Longitude` = '-95.199785' ,`PhotoCount` = '40' ,`PostalCode` = '77546' ,`RoomCount` = '9' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Cherry Tree Ln' ,`StreetNumber` = '131' ,`StreetSuffix` = 'Lane' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2626' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Highly sought-after Friendswood ISD home. 5 Bedroom beautiful home on a quiet street with mature trees and low traffic. Updated in recent years to include a new roof in 2020, windows, flooring, appliances, cabinets, granite countertops and Air Conditioner since 2018. New Furnace and ductwork in 2020. Foundation repairs with lifetime transferable warranty. No back neighbors! Lots of greenspace to the right and back of the property. Access to the walking trails behind the property. MOTIVATED SELLER! BRING YOUR OFFERS! (Realtor is a relative of the Seller).' ,`Acres` = '0.2259' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 20 PERRY & AUSTIN SUR LOT 12 ENCHANTED WOODS' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '9840' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '75' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Enchanted Woods' ,`TaxAmount` = '4422' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705545' WHERE `Matrix_Unique_ID` = '210998124' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:17:31.503' ,`MLSNumber` = '34930762' ,`ListAgentFullName` = 'Roxanna Plazas' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.876443' ,`Longitude` = '-95.733584' ,`PhotoCount` = '26' ,`PostalCode` = '77449' ,`RoomCount` = '7' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Southern Colony' ,`StreetNumber` = '21131' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1452' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 1 SETTLERS VILLAGE SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Settlers Village Sec 01 R/P' ,`TaxAmount` = '4531' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705545' WHERE `Matrix_Unique_ID` = '211014034' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:45:16.770' ,`MLSNumber` = '36429337' ,`ListAgentFullName` = 'William Onye' ,`ListOfficeName` = 'PRG, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809377' ,`Longitude` = '-95.390352' ,`PhotoCount` = '17' ,`PostalCode` = '77009' ,`RoomCount` = '4' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = 'Main' ,`StreetNumber` = '6511' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Craftsman bungalow style home in desirable Sunset Heights of Houston. This home sits on Heights Lots 13 & 14 Blk 48 available for your new construction. Nestled on fabulous pocket of the Heights Houston within walking distance to 19th Street and favorite Heights hotspots, such as Halbert Park, Johnny\'s Gold Brick, and Angela\'s Oven. Fantastic Opportunity for New Construction in the Heights with endless possibilities. Build SFR, Duplex or Triplex on this lot. Location provides easy access to I-45, 610 N Loop & Downtown No HOA. low tax rate. No flooding. info per seller. The property is being sold in present condition' ,`Acres` = '0.1538' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 13 & 14 BLK 48 SUNSET HEIGHTS' ,`LotDesciption` = 'Other' ,`LotSize` = '6700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Heights' ,`TaxAmount` = '8635' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705545' WHERE `Matrix_Unique_ID` = '211031495' --> 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','211194078','1663705545','211194078','2022-09-01T10:48:10.063','61087021','Virginia Alvarado','Vive Realty LLC','','','30.062678','-94.114780','10','77701','3','140000.00','Active','San Jacinto','2408','Street','Beaumont','2','0','3','1399','Single-Family','Renovated 3 bedroom 2 bath home sitting on oversized corner lot with detached garage!\r\nRenovated Home, New Roof, New Exterior/ Interior Paint, New vinyl and tile flooring, New HVAC, New Plumbing, New Electrical.','0.1722','51','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','','','','Central Electric','0','CARTWRIGHT L 12 B 11','Corner','7500','Appraisal District','','','0','','1','','0','','','Gas Range','','Composition','143 - Beaumont','CHARLTON-POLLARD ELEMENTARY SCHOOL','BEAUMONT UNITED HIGH SCHOOL','KING MIDDLE SCHOOL (BEAUMONT)','Accompany,Appointment Required,Lockbox Back,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Traditional','Cartwright 1','1126','2.645','Public Sewer','1962','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:44:00.360' ,`MLSNumber` = '92181295' ,`ListAgentFullName` = 'Maladie Slaughter' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.938108' ,`Longitude` = '-94.843823' ,`PhotoCount` = '10' ,`PostalCode` = '77535' ,`RoomCount` = '5' ,`ListPrice` = '175900.00' ,`Status` = 'Active' ,`StreetName` = 'R 440' ,`StreetNumber` = '337' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful property in a tranquil space awaits for you in Dayton! Over one acre of land and no HOA! Home features 3 bedrooms, 2 baths, living room, front porch, open kitchen with stainless steel appliances! Come take a look at this home and make it yours!' ,`Acres` = '1.342' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'THE RANCH, SEC 3, LOT 106, ACRES 1.342' ,`LotDesciption` = 'Cleared' ,`LotSize` = '58458' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'KIMMIE M. BROWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'The Ranch, Sec 3' ,`TaxAmount` = '1060' ,`TaxRate` = '1.7625' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705545' WHERE `Matrix_Unique_ID` = '211229433' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:15:26.047' ,`MLSNumber` = '98624868' ,`ListAgentFullName` = 'Deanna Kirksey' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = 'Yolanda Rocha' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.764141' ,`Longitude` = '-95.229818' ,`PhotoCount` = '39' ,`PostalCode` = '77029' ,`RoomCount` = '8' ,`ListPrice` = '264900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Munn' ,`StreetNumber` = '11423' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1774' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A MUST SEE!! This home is the cream of the crop in this neighborhood. So many updates including solid wood custom cabinetry, granite counter tops w/large island in kitchen w/soft close drawers. Updated bathrooms, with beautiful tile floors throughout. Garage area has been built out for small apartment with bedroom and bathroom. Great for Mother-in-law quarters.\r\nLots of storage space and rear covered parking. Large fenced back yard with nice sitting area between the house and garage for morning coffee or an evening beverage while relaxing from the day. This subdivision has great access to I-10 and minutes from Downtown Houston. Mid-Town, The Heights and The Galleria. \r\nSchedule your appointment today as this house will not last long!' ,`Acres` = '0.1722' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 178 BLK 11 MANGUM PLACE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'PYBURN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GALENA PARK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODLAND ACRES MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mangum Place Sec 03' ,`TaxAmount` = '2877' ,`TaxRate` = '2.993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705546' WHERE `Matrix_Unique_ID` = '211312940' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:34:26.317' ,`MLSNumber` = '76024028' ,`ListAgentFullName` = 'Ronal Martinez' ,`ListOfficeName` = 'Tower Perla Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.818088' ,`Longitude` = '-95.278467' ,`PhotoCount` = '25' ,`PostalCode` = '77028' ,`RoomCount` = '6' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Filltop' ,`StreetNumber` = '8118' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful fixer-upper oozing with potential in a tree-filled neighborhood, perfect for first-time homeowners, newly weds or an addition to your investment property portfolio. This property has a spacious lot with an additional living space detached from the primary property that can be turned in to a potential Rental property. Located in a highly desirable location with easy access to major Highways such as 610 and Highway 90 and only 15 minutes away from Downtown Houston- With the right amount of TLC this home will rise fast in value, with the potential of generating rental income. Plenty of room to create the living space you desire or ready to flip — you choose!' ,`Acres` = '0.1837' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 5 & 6 BLK R SETTEGAST HEIGHTS ANNEX U/R' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Settegast Heights Anx' ,`TaxAmount` = '950' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705546' WHERE `Matrix_Unique_ID` = '211382411' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:48:55.210' ,`MLSNumber` = '6903959' ,`ListAgentFullName` = 'Lina Chou' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.483568' ,`Longitude` = '-95.502766' ,`PhotoCount` = '16' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Texas Rose' ,`StreetNumber` = '10830' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2608' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL two-story, like new, 4b2.5b home located in Sienna Plantation. Close to HWY 6,shopping, HCC & library & Riverstone. EZ to access to HWY 6, FB tollway. Great schools and all are inside the community. Many amenities, pools, golf, lakes, parks, tennis courts, and fitness centers... walk to the recreation center. Great home at this price! Don\'t miss it! Never flooded! The popular floor plan is loaded with options and upgrades and features: high ceilings in the entry and family room, game room, open gourmet kitchen with a big island, tile flooring, and much more. The master suite has big closets. Amazing lot with NO BACK NEIGHBORS provides plenty of room for entertainment. Sienna Plantation is a landmark community that features resort-style amenities. Zoned top Fort Bend ISD schools.' ,`Acres` = '0.1325' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA PLANTATION SEC 23 FINAL PLAT, BLOCK 1, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5771' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas 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` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Plantation Sec 23 Final' ,`TaxAmount` = '8114' ,`TaxRate` = '3.1629' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705546' WHERE `Matrix_Unique_ID` = '211393671' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:23:06.087' ,`MLSNumber` = '57943921' ,`ListAgentFullName` = 'Paul Olascoaga' ,`ListOfficeName` = 'Vive Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.088625' ,`Longitude` = '-95.228258' ,`PhotoCount` = '6' ,`PostalCode` = '77365' ,`RoomCount` = '3' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Martin' ,`StreetNumber` = '22447' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Corner Lot! Two adjacent lots being sold together to make up 2.28 Acres. 2 Mobile homes currently on the property with city sewer and water. The mobile home at the corner is currently being rented out on a month to month term. The other mobile home, the white mobile home, is heavily damaged and can be removed if requested.' ,`Acres` = '1.28' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'S926002 - TIMBERLANE ACRES 02, BLOCK 1, LOT 9-A, SERIAL # 03' ,`LotDesciption` = 'Corner' ,`LotSize` = '55757' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'PORTER ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timberlane Acres 02' ,`TaxAmount` = '1003' ,`TaxRate` = '2.5431' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705546' WHERE `Matrix_Unique_ID` = '211421341' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:00:46.280' ,`MLSNumber` = '52431485' ,`ListAgentFullName` = 'Hung Pham' ,`ListOfficeName` = 'The Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.980951' ,`Longitude` = '-95.557376' ,`PhotoCount` = '19' ,`PostalCode` = '77070' ,`RoomCount` = '8' ,`ListPrice` = '298000.00' ,`Status` = 'Active' ,`StreetName` = 'Renmark' ,`StreetNumber` = '8114' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2554' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.2106' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 36 BLK 8 PRESTONWOOD FOREST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HANCOCK ELEMENTARY SCHOOL (CY-FAIR)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Prestonwood Forest Sec 02' ,`TaxAmount` = '5053' ,`TaxRate` = '2.5378' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705546' WHERE `Matrix_Unique_ID` = '211421472' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:01:08.840' ,`MLSNumber` = '5595147' ,`ListAgentFullName` = 'Hung Pham' ,`ListOfficeName` = 'The Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.956917' ,`Longitude` = '-95.576701' ,`PhotoCount` = '20' ,`PostalCode` = '77070' ,`RoomCount` = '7' ,`ListPrice` = '298000.00' ,`Status` = 'Active' ,`StreetName` = 'Duchess' ,`StreetNumber` = '12618' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2308' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1205' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 28 TALLOW WOOD SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MATZKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tallow Wood Sec 04' ,`TaxAmount` = '5415' ,`TaxRate` = '2.8108' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705546' WHERE `Matrix_Unique_ID` = '211421577' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:32:32.860' ,`MLSNumber` = '57034160' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.406507' ,`Longitude` = '-95.055583' ,`PhotoCount` = '23' ,`PostalCode` = '77568' ,`RoomCount` = '8' ,`ListPrice` = '512939.00' ,`Status` = 'Active' ,`StreetName` = 'Vanilla Sky' ,`StreetNumber` = '2733' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2697' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Highly sought after CastleRock \"San Marcos\" Silver Series floor plan in Gated Section of Lago Mar\'s Master Planned Community. Home of the largest Crystal Lagoon in Texas and Voted BEST Master Planned Community 2 years in a row. Upgrades include a large Covered Back Patio, Tile throughout all main living areas, a Beautiful Glass Entryway Door, White Stone Elevation with a front Patio and Cedar Beams. The kitchen is every cook\'s dream with plenty of Countertops, Cabinetry, and Pantry Space. This home also highlights a spectacular Butlers Pantry. High Ceiling throughout the home. Bonus Room with private full bath, study, and prewired entertainment package. Primary Bedroom has lots of brightness. Master Bath has a relaxing soaker tub and a separate shower. Large Utility room and 2 Car Garage. This home is on a highly sought-after Water Front street for Lake Lago.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mi/Lenders Approval,Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14, Block 3, Section 5-1' ,`LotDesciption` = 'Greenbelt,Other,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705546' WHERE `Matrix_Unique_ID` = '211470720' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:37:21.457' ,`MLSNumber` = '13901588' ,`ListAgentFullName` = 'Patricia Rodriguez' ,`ListOfficeName` = 'Ambassador Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.959682' ,`Longitude` = '-95.358315' ,`PhotoCount` = '13' ,`PostalCode` = '77541' ,`RoomCount` = '3' ,`ListPrice` = '164000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue C' ,`StreetNumber` = '211' ,`StreetSuffix` = '' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1104' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Clean & beautiful four bedroom, two bath home on nearly three lots with double driveway. Gorgeous flooring flows throughout the entire home. The living room has raised ceiling with accent piece, two fans and additional recessed lighting. Kitchen has a fresh updated look with plenty of counter& cabinet space. Front room could be used as fourth bedroom or home office with its private entry/ exit. The master bedroom is a great size with its own private bath. Out back is a huge covered patio, large storage building and a \"park like\" yard with privacy fence. Extra double gated entry on back fence is perfect for bringing in your larger toys.' ,`Acres` = '0.2148' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'VELASCO (FREEPORT) BLK 13 LOT 19-20-21' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '9357' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Velasco Freeport' ,`TaxAmount` = '2014' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705547' WHERE `Matrix_Unique_ID` = '211487196' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:21:38.197' ,`MLSNumber` = '88758883' ,`ListAgentFullName` = 'Kristen Orostieta' ,`ListOfficeName` = 'Oro Realty' ,`SellingAgentFullName` = 'Kristen Orostieta' ,`SellingOfficeName` = 'Oro Realty' ,`Latitude` = '30.445278' ,`Longitude` = '-96.557251' ,`PhotoCount` = '39' ,`PostalCode` = '77836' ,`RoomCount` = '3' ,`ListPrice` = '230000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Lake Ridge' ,`StreetNumber` = '2200' ,`StreetSuffix` = 'Drive' ,`City` = 'Caldwell' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2048' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this spacious home with over 2k square on an acre right outside of College Station in the Snook area. Country living with a local volunteer fire department and stocked ponds for fishing. This property backs right up to one of the subdivision green belts and ponds. Storage shed in backyard that is wired and small fenced in area around the back of the home. It\'s well kept and priced to go quickly!' ,`Acres` = '1.21' ,`Area` = '59' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S3450 BEAVER CREEK LOT 2/383 1.21 ACRES S# PH0519671A HUD#' ,`LotDesciption` = 'Other' ,`LotSize` = '52708' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '192 - Snook' ,`SchoolElementary` = 'SNOOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SNOOK SECONDARY SCHOOL' ,`SchoolMiddle` = 'SNOOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Beaver Creek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Well' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705547' WHERE `Matrix_Unique_ID` = '211560941' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:58:53.593' ,`MLSNumber` = '58092942' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.807164' ,`Longitude` = '-94.910291' ,`PhotoCount` = '19' ,`PostalCode` = '77521' ,`RoomCount` = '9' ,`ListPrice` = '360990.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Forest' ,`StreetNumber` = '9914' ,`StreetSuffix` = 'Court' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 bedrooms, 2.5 bathrooms, 2-story family room, integrated kitchen and breakfast area, study, 2nd floor game room.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2, Block 3, Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6050' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lynnwood' ,`TaxAmount` = '' ,`TaxRate` = '3.06' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705547' WHERE `Matrix_Unique_ID` = '211703492' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:00:33.097' ,`MLSNumber` = '57396964' ,`ListAgentFullName` = 'Shahin Naghavi' ,`ListOfficeName` = 'Madison Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768788' ,`Longitude` = '-95.211234' ,`PhotoCount` = '7' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Tolima Dove' ,`StreetNumber` = '117' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*LIMITED PRE-SALES AT THIS ENTRY PRICE FOR MARCH 2023* Welcome to your next home located in the premier residential development of Independence Heights! The development has two floorplans, and this is the largest! This home features first floor kitchen-living-dining and powder bath. First floor has 10-foot ceilings. Kitchen is open to great room featuring large island with breakfast bar seating. Marble-look quartz countertops, subway backsplash, apron front farmhouse sink, brushed gold pull-down faucet, 30-inch gas range and so much more! Primary suite is on the second floor. Primary bath has dual vanities, one with a makeup vanity! Oversized closet with dual areas. Separate water closet. Guest bedrooms have separate walk-in closets and Hollywood bath. Call now for more info and to reserve your lot!\r\nPhase I now pre-selling w/ expected completion March 2023! Visit design center to select finishes and upgrades now!\r\nTo find the site on the maps type 4924 Yale St, Houston, TX 77008.' ,`Acres` = '0.0439' ,`Area` = '2' ,`BuilderName` = 'Elite Townhomes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 2 INDEPENDENCE HEIGHTS HOMES' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '1914' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HARRIS R P ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FURR HIGH SCHOOL' ,`SchoolMiddle` = 'HOLLAND MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'INDEPENDENCE HEIGHTS HOMES' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705547' WHERE `Matrix_Unique_ID` = '211812592' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:44:21.000' ,`MLSNumber` = '72638780' ,`ListAgentFullName` = 'Geren Sims' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.716050' ,`Longitude` = '-95.364376' ,`PhotoCount` = '13' ,`PostalCode` = '77004' ,`RoomCount` = '6' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Palm' ,`StreetNumber` = '3319' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, location, location! This 1,650SF home is minutes away from the University of Houston, Texas Medical Center, and NRG park. Recently tenant occupied, this home is a perfect rental investment or starter home for someone who wants to live inside the loop for under $300k. NEVER FLOODED in any major/minor flooding event.' ,`Acres` = '0.1584' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 3 SOUTHWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwood' ,`TaxAmount` = '5622' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705547' WHERE `Matrix_Unique_ID` = '211861026' --> 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','211888639','1663705547','211888639','2022-09-01T10:30:08.920','64138308','Nimesh Dave','Keller Williams Realty -SW','','','29.523724','-95.758453','31','77469','9','298680.00','Active','Durango Ridge','6014','Court','Richmond','2','0','3','1904','Single-Family','Location meets value! Welcome to 6014 Durango Ridge Ct in Richmond/Rosenberg. Newley updated 3 BR / 2 Bath single story at 1904 sqft. Freshly painted light and bright with tile throughout. Updated kitchen with brand new quartz countertops and brand new Stainless Steel Appliances overlooking an open floor plan. New Lighting package with recessed lighting. Exterior has been power washed and newly painted. Enjoy this quaint neighborhood with easy access to 59 and other retail and entertainment! Come and get it, it won\'t last long!','0.1377','30','','','','','Mud,Sellers Disclosure','','','','Fort Bend South/Richmond','Central Gas','1','ROSE RANCH SEC 1, BLOCK 3, LOT 39','Subdivision Lot','6000','Appraisal District','','450','0','','2','','0','','','','','Composition','33 - Lamar Consolidated','ARREDONDO ELEMENTARY SCHOOL','RANDLE HIGH SCHOOL','WRIGHT JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Rose Ranch Sec 1','5680','2.9348','Public Sewer,Public Water,Water District','2007','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:57:20.823' ,`MLSNumber` = '31553720' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'RE/MAX Legends' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.981063' ,`Longitude` = '-95.150069' ,`PhotoCount` = '21' ,`PostalCode` = '77044' ,`RoomCount` = '9' ,`ListPrice` = '342500.00' ,`Status` = 'Active' ,`StreetName` = 'Svensson Slade' ,`StreetNumber` = '18019' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1962' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LIGHT & BRIGHT 2017 BUILT 1 STORY 4 BEDROOM GEM! Still Looks & Feels NEW! Beautiful Exterior with Covered Entry! Wonderful Kitchen: Granite Counters, Stainless Appliances (Including Five Burner Gas Range/Stove), 42\" White Cabinetry with Under Cabinet Lighting, Subway Tile Backsplash, & Big Walk-In Pantry! Side-by-Side Stainless Refrigerator Included! Spacious Vaulted Ceiling Dining Area! High Ceiling Family Room - Wood-Look Tile Flooring! King-Sized Master Suite - Versatile Sitting Area/Computer Niche! Luxurious Garden Bath with Separate Tub & Shower + Dual Sinks + Walk-In Closet! Spacious Secondary Bedrooms - All with Neutral Carpet & Paint! One with Built-In Shelving & Cabinetry - Use as Home Office/Study if Desired! Convenient Indoor Utility Room - Washer & Dryer Included! Large Extended Back Patio with Covered Area! Automatic Sprinkler System Adds to Ease of Maintenance! Great Community with Pool, Park, Trails, Clubhouse, & Access to Lake Houston! Easy Access to Beltway 8 & Hwy 59!' ,`Acres` = '0.1848' ,`Area` = '1' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 2 BRIDGES ON LAKE HOUSTON SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8049' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'LAKESHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridges on Lake Houston' ,`TaxAmount` = '7715' ,`TaxRate` = '3.303' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705547' WHERE `Matrix_Unique_ID` = '211944121' --> 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','211945170','1663705548','211945170','2022-09-01T11:16:03.177','28782295','Travis Wilson','Orchard Brokerage','','','30.168744','-95.196701','30','77357','9','430000.00','Active','Swansea Creek','18850','Drive','New Caney','3','1','4','3338','Single-Family','Gorgeous 4 bed/3.1 bath home located on a lot with no rear neighbors! Lovely, soaring ceilings & living spaces that burst with natural light. New roof 2021! Formal dining rooms, a study, plus a game room upstairs. Enjoy the fireplace in the living room on colder days! The sparkling kitchen will impress from the moment you enter with granite countertops, stainless steel appliances, & gourmet features such as a gas cooktop & wall oven. Escape to your primary suite that boasts a tray ceiling, bay windows, walk-in closet, soaking tub, & separate shower. Extended patio in the fenced backyard with a gorgeous, tree-lined view! Close to walking trails, tons of greenery, easy access to 59 , 99 & 242. Airport is 15-20 minutes away. Close to Planet Fitness & Valley Ranch Shopping district (Kroger , Cinemark & restaurants). R.B. Tullis Branch Library just 2 miles away. Walmart Supercenter 3 miles away. 30-40 min away from Woodland & Downtown. Click the Virtual Tour link to view the 3D walkthrough','0.1661','40','','','Washer Connections','','Mud,Sellers Disclosure','1','','1','Porter/New Caney East','Central Gas','1','S921103 - TAVOLA 03, BLOCK 1, LOT 5','Subdivision Lot','7234','Appraisal District','','725','0','','3','Gas Oven','0','','','Gas Range','','Composition','39 - New Caney','TAVOLA ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','KEEFER CROSSING MIDDLE SCHOOL','Lockbox Front','Appraisal District','2','Traditional','Tavola 03','9991','3.3731','Public Sewer,Water District','2014','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','211983414','1663705548','211983414','2022-09-01T10:59:18.707','63218661','Dionne Randle','MOD Realty, LLC','','','29.489774','-95.535030','48','77459','14','550000.00','Active','Grand Mesa','2910','Pass','Missouri City','3','1','4','3794','Single-Family','Beautifully kept home in the elite neighborhood Sienna! Open the doors to a grand foyer, winding staircase, study, formal dining, grand family room, a huge kitchen that is open to the family room that offers plenty of cabinets and counter space - with a walk-in pantry, breakfast bar, all stainless Jenn-Aire appliances, island, and wall oven. Shutters throughout the home, engineered wood flooring, crown molding in multiple areas, carpet only in the upstairs bedrooms. All secondary rooms are massive with walk-in closets, and the media room (with surround sound) can be a 5th bedroom if needed. The primary suite has engineered flooring, his and hers sinks with his and her closets, a walk-in shower with a bench, and a jetted bathtub. The first floor has all 9\' doors! This home is well kept and shows like a gem! The neighborhood has jogging trails, bike trails, water parks, a fitness center, fishing docks, sports field, golf course and great schools!','0.2181','38','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace,Wood Burning Fireplace','1','Sienna Area','Central Gas','1','SIENNA VILLAGE OF WATERS LAKE SEC 21-C, BLOCK 2, LOT 2','Subdivision Lot','9500','Appraisal District','','1307','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','SCANLAN OAKS ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','THORNTON MIDDLE SCHOOL (FORT BEND)','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','Sienna Village Of Waters Lake Sec 21-C','9326','2.6079','Water District','2005','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T11:11:07.563' ,`MLSNumber` = '95925849' ,`ListAgentFullName` = 'Shakeib Baradhi' ,`ListOfficeName` = 'Baradhi Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.042491' ,`Longitude` = '-95.423563' ,`PhotoCount` = '40' ,`PostalCode` = '77566' ,`RoomCount` = '3' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Waterlily' ,`StreetNumber` = '114' ,`StreetSuffix` = 'Street' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2001' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION LOCATION LOCATION!!! NO FLOOD RISK!!!BEAUTIFUL HOME ON 1/4 ACRE ACROSS FROM PECAN LAKE!!! DEAD-END STREET--NO TRAFFIC!!! NEW TRANE AC WITH 10YR WARRANTY!!! NEW REFRIGERATOR!!!VERY WELL KEPT WITH HIGH CEILINGS!! PLENTY STORAGE AND A VERY SPACIUOS KITCHEN!! UPDATED SPRINKLER SYSTEM!!! AMPLE LIVING ROOM SPACE WITH BRICK FIREPLACE, AND BEDROOMS WILL NOT DISSAPOINT!! PRIMARY BATH WITH CUSTOM TILED TUB AND SHOWER!!! MASSIVE SCREENED IN BACK PATIO AREA OVERLOOKING THE BACK YARD!! HUGE DISTANCE TO BACK NEIGHBORS!!! THIS HOME IS A MUST SEE!! CALL OR TEXT FOR YOUR SHOWING TODAY!!' ,`Acres` = '0.2431' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PECAN LAKE ESTATES (LAKE JACKSON), BLOCK 6, LOT 8 REPLAT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10589' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BEUTEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Pecan Lake Estates Lake Jacks' ,`TaxAmount` = '6238' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705548' WHERE `Matrix_Unique_ID` = '211985242' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T10:13:56.770' ,`MLSNumber` = '50494995' ,`ListAgentFullName` = 'Eva Markham' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.305045' ,`Longitude` = '-95.469059' ,`PhotoCount` = '10' ,`PostalCode` = '75835' ,`RoomCount` = '3' ,`ListPrice` = '69900.00' ,`Status` = 'Active' ,`StreetName` = 'Darius' ,`StreetNumber` = '102' ,`StreetSuffix` = 'Street' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1255' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTOR SPECIAL!!! 3 Bedroom, 2 Bath 4-sided Brick Home within walking distance to Crockett I.S.D. Property will need a complete remodel. Call for an appointment.' ,`Acres` = '0.265' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'REDWOOD ESTS LOT 2 SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11543' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '57 - Crockett' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (CROCKETT)' ,`SchoolHigh` = 'CROCKETT HIGH SCHOOL (CROCKETT)' ,`SchoolMiddle` = 'CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Redwood Estate' ,`TaxAmount` = '1528' ,`TaxRate` = '2.3627' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705548' WHERE `Matrix_Unique_ID` = '212012567' --> 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','212013630','1663705548','212013630','2022-09-01T11:22:34.827','97205259','Dennis Martinez','Alchemist Real Estate','','','30.154187','-95.398250','36','77385','5','799990.00','Active','Eagle Nest Lane','32043','','Conroe','4','1','5','5891','Single-Family','','','15','iBuild Texas','','','','Mud,Sellers Disclosure','','','','Spring Northeast','Central Gas','1','Meadows At Imperial Oaks 03, BLOCK 3, Lot 12','Subdivision Lot','12475','Appraisal District','','1000','0','','3','','0','','','','','Composition','11 - Conroe','KAUFMAN ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Appointment Required,Controlled Access,Leave Business Card,Request Online Appointment','Builder','2','Mediterranean','Meadows at Imperial Oaks 03 & 06','','','Water District','2018','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','212026074','1663705548','212026074','2022-09-01T10:52:03.953','88957613','Vivian Jones','JLA Realty','','','29.939850','-95.201694','29','77346','8','360000.00','Active','Misty Summer','15122','Lane','Humble','2','1','4','2429','Single-Family','','0.1382','1','','','Electric Dryer Connections','','Mud,Sellers Disclosure','1','','','Summerwood/Lakeshore','Central Gas','1','LT 76 BLK 1 SUNSET RIDGE SEC 8','Subdivision Lot','6020','Appraisal District','','500','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','29 - Humble','RIDGE CREEK ELEMENTARY SCHOOL','SUMMER CREEK HIGH SCHOOL','AUTUMN RIDGE MIDDLE SCHOOL','Accompany,Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','2','Contemporary/Modern','Sunset Rdg Sec 8','7861','3.0673','Public Sewer,Public Water','2019','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','212041918','1663705548','212041918','2022-09-01T10:17:40.063','48908969','Kelli Semar','JLA Realty','','','30.240727','-94.975458','22','77535','2','159000.00','Active','County Road 303','513','','Dayton','1','0','2','840','Single-Family','Beautiful 2ac lot in Tarkington ISD. This property has the unending potential to be a very nice homestead. It is in a notable location in the first curve on the road. The front half of the lot is covered in thick grass and the back it is dressed with mature trees for some very nice shade. Currently, there is a 2bed 2bath single wide on the property that is in good condition, despite its age. The property would be a great rental investment, make it a home or use it as a start to build your dream home. Come take a look.','2.23','52','','','','','Sellers Disclosure','','','','Cleveland Area','Central Electric','0','CARTER COUNTRY, LOT 33, ACRES 2.23, MH LABEL# TEX0100971','Cleared,Wooded','97139','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Aluminum','102 - Tarkington','TARKINGTON PRIMARY SCHOOL','TARKINGTON HIGH SCHOOL','TARKINGTON MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Ranch','Carter Country','875','1.5226','Public Water,Septic Tank','1997','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','212061984','1663705548','212061984','2022-09-01T10:48:46.240','8202273','Patrick McGrath','Meritage Homes Realty','','','30.195052','-95.439660','13','77385','7','651320.00','Active','Harper\'s','17628','Way','Conroe','3','1','4','3611','Single-Family','Brand NEW energy-efficient home ready January 2023! Classic White, 8\' Trim Door, Fireplace, Out door covered Patio, Sprinkler System, Gas Stub, Extended Flooring. Located a half hour north of downtown Houston off Hwy 242, Harper’s Preserve is a stunning gated master-planned community that features an on site local elementary school and grocery store, as well as nearby restaurants and shopping. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.','','15','Meritage Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','Freestanding','1','Spring Northeast','Central Electric,Heat Pump','1','SF 0134 Plan 5362C','Subdivision Lot','','','','1127','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','SUCHMA ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Harpers Preserve','','3.09','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','212066490','1663705548','212066490','2022-09-01T11:46:00.557','7117699','Hena Lavergne','Texas United Realty','','','29.657214','-95.192377','11','77504','0','275000.00','Active','Strawberry','3538','Road','Pasadena','0','1','0','736','Single-Family','Commercial property in a great location. Manufactured home/office used for Tailoring services. Easy access to \r\nHwy 225, beltway 8 and Gulf Frwy.','0.2367','6','','','','','Sellers Disclosure','','','','Pasadena','Space Heater','0','TR 155A ALTA VISTA ACRES SEC 3','Other','10310','Appraisal District','','','0','','0','','0','','','','','Aluminum','41 - Pasadena','JENSEN ELEMENTARY SCHOOL','SOUTH HOUSTON HIGH SCHOOL','PARKVIEW INTERMEDIATE SCHOOL','Appointment Required','Appraisal District','1','Other Style','Alta Vista Acres Sec 03','1408','2.6514','Water District','1990','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','212070452','1663705548','212070452','2022-09-01T10:38:31.763','70400692','John Brannen','Lawrence Realty','','','31.328704','-95.444935','25','75835','2','219000.00','Active','Woodland','223','Circle','Crockett','2','0','2','1444','Single-Family','This beautiful two bedroom, two bath home is conveniently located minutes from downtown Crockett, TX. Once you walk through the front door, you will notice new flooring and paint throughout. The living room and kitchen are open and spacious with great windows bringing in plenty of natural light and a stone, woodburning fireplace. The kitchen is outfitted with granite countertops and a granite kitchen island. Down the hall, you will find two bedrooms that share the hall bathroom. Inside the hallway bathroom, you will love the shower/tub combo with nice finishes and granite countertops. Just off the living room, you will find the laundry room which include the second full bathroom with a stand-up shower. This room has access to the two-car enclosed garage, as well as access to the backyard. In the backyard, you will find two large storage sheds with endless possibilities. These storage buildings can be used for yard maintenance storage, or one of them could be turned into a guest home.','0.401','41','','','','','Sellers Disclosure','1','Wood Burning Fireplace','1','Crockett Area','Central Electric','0','ROLLING ACRES LOT 39 SEC B','Subdivision Lot','17468','Appraisal District','','','0','','2','','0','','','','','Composition','57 - Crockett','CROCKETT ELEMENTARY SCHOOL (CROCKETT)','CROCKETT HIGH SCHOOL (CROCKETT)','CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)','Appointment Required','Appraisal District','1','Ranch','Rolling Acres Estates','2234','2.3627','Public Sewer,Public Water','1981','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','212071472','1663705548','212071472','2022-09-01T11:16:41.070','15508569','Johnny Schiro','Icon Realty Group, L.L.C.','','','30.093127','-95.450457','29','77389','11','525000.00','Active','Thorpe','10','Lane','Spring','3','0','3','2204','Single-Family','Coveted French Quarter urban-style LUXURY in Harper Woods at Springwoods Village - on a courtyard lot with an irresistible front porch & matching balcony - just steps from the new CityPlace urban/retail hotspot! At the intersection of 99, I-45, and the Hardy Toll Rd! 3 bedrooms up with a study or 4th bedroom downstairs (includes a closet and a full bath adjacent), magazine-cover island kitchen w/ white & pewter cabinetry, 5-star master suite w/ standalone tub, and a huge family room! Typical Sullivan Brothers luxury throughout: gorgeous hardwoods, elaborate trim work, quartz counter tops, spray-foam insulation, 8’ doors, and plenty more. Seconds from The Woodlands, 20 minutes from IAH and 30 minutes to Downtown, seconds to major employment centers like Exxon, HP, St Luke\'s, and walking distance to CityPlace! Home values here will absolutely SOAR as CityPlace is built out! Don\'t miss the chance - live THE LIFESTYLE OF LUXURY AND CONVENIENCE - get out here now!','','14','Sullivan Brothers','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Spring/Klein','Central Gas','1','LT 7 BLK 6 HARPER WOODS','Cul-De-Sac,Subdivision Lot','3510','Appraisal District','','1200','0','','2','Gas Oven','0','','','Gas Range','','Composition','48 - Spring','NORTHGATE ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','SPRINGWOODS VILLAGE MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Harper Woods Springwoods Village','','3.2','Water District','2021','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','212073728','1663705548','212073728','2022-09-01T11:13:15.730','79730031','Jane NgaDung Nguyen','Alpha, REALTORS','','','29.669251','-95.267000','23','77061','6','280000.00','Active','Hinman','8407','Street','Houston','2','0','3','2139','Single-Family','Wonderful home complete with Fresh Paint-Interior, No Carpet, Laminate & tile floors. A/C (6 yrs), No HOA. Easy access to I-45.','0.1641','3','','','Washer Connections','','Sellers Disclosure','','','','Hobby Area','Central Electric','0','LT 12 BLK 4 MEADOWBROOK FREEWAY','Cleared','7150','Appraisal District','','','0','','2','','0','','','','','Composition','41 - Pasadena','SOUTH HOUSTON ELEMENTARY SCHOOL','SOUTH HOUSTON HIGH SCHOOL','SOUTHHOUSTON INTERMEDIATE SCHOOL','Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Meadowbrook Fwy','4377','2.6863','Public Sewer,Public Water','1958','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212074731','1663705548','212074731','2022-09-01T11:22:22.393','44719272','Bradley Musick','Ideal Realty','','','29.963280','-95.571238','13','77070','9','259995.00','Active','Mills Run','10310','Drive','Houston','2','0','3','1578','Single-Family','Beautiful 3 bedroom, 2 bath home featuring ceramic tile floors in living and kitchen areas. Open floorplan, The kitchen features plenty of counter and cabinet space. Master bathroom has dual vanities and separate tub/shower. Convenient to 1960 and 249, and Willowbrook Mall. Make your appointment today!','','10','','','','','No Disclosures','1','Gas Connections','1','Willowbrook South','Central Gas','1','LOT 28 BLOCK 1 MILLS CROSSING AMEND','Subdivision Lot','5250','Appraisal District','','105','0','','2','Gas Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','MATZKE ELEMENTARY SCHOOL','CYPRESS CREEK HIGH SCHOOL','BLEYL MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','MILLS CROSSING','','','Water District','2004','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212075540','1663705548','212075540','2022-09-01T11:32:59.037','75293796','Johnny Schiro','Icon Realty Group, L.L.C.','','','30.094086','-95.451400','35','77389','7','519000.00','Active','Red Harper','22','Drive','Spring','2','0','3','1737','Single-Family','Luxury charm & charisma from Sullivan Brothers on a HUGE lot--in the absolute PREMIER convenience hotspot in North Houston: Harper Woods in Springwood Village. Rare opportunity for an interior lot location at Harper Woods with more than enough room for a pool. Just steps from Exxon, HP, ABS, and St Lukes, and adjacent to the new urban CityPlace hotspot--Market Street meets City Centre--located at the intersection of 99, I-45, and the Hardy, with a 20 min drive to IAH and just 30 mins to Downtown! Stunning open plan with 2 large bedrooms + study (or 3rd bed), reclaimed hardwoods throughout, spectacular island kitchen w/ 5-burner Bertazzoni range, plantation shutters, 6-inch baseboards & wood-encased windows, and solid-wood 8\' doors! 5-star master suite w/ oversized shower, luxurious finishes throughout, and a front porch that you simply can\'t find anywhere in North Houston. This is THE NEW LIFESTYLE OF LUXURY AND CONVENIENCE! Don\'t miss your opportunity. The time is NOW!','0.15','14','Sullivan Brothers','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Spring/Klein','Central Gas','1','LT 8 BLK 3 HARPER WOODS','Subdivision Lot','6343','Appraisal District','','1200','0','','2','Gas Oven','0','','','Gas Range','','Composition','48 - Spring','NORTHGATE ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','SPRINGWOODS VILLAGE MIDDLE SCHOOL','Appointment Required','Builder','1','Ranch,Traditional','Harper Woods Springwoods Village','','3.2','Water District','2014','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','212076107','1663705548','212076107','2022-09-01T11:49:49.280','71212949','Scott Miller','RE/MAX Signature Galleria','','','30.211783','-95.440350','11','77385','4','349900.00','Active','Great Oaks','16718','Drive','Conroe','2','1','4','1994','Single-Family','10\' ceilings in kitchen/Living, beautiful open concept. Spacious kitchen with 42\" upper cabinets with large island, granite tops. Bedrooms with huge walk-in closet. Great lighting and all LED! Samsung Stainless Steel appliance package including easy clean top range with electric oven, 3 rack dishwasher, and microwave. 1 year warranty on appliances from Samsung. Ask agent about preferred lender benefits.','0.2066','15','Starter Homes of TX','','Electric Dryer Connections','','No Disclosures','1','','','Conroe Southeast','Central Electric','1','TALL TIMBERS 01, BLOCK 1, LOT 3-B','Subdivision Lot','9000','Appraisal District','','108','1','To Be Built/Under Construction','2','Electric Oven','0','','','Freestanding Range','','Composition','11 - Conroe','OAK RIDGE ELEMENTARY SCHOOL (CONROE)','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card','Builder','2','Traditional','Tall Timbers 01','17','1.8488','Septic Tank,Well','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','212077682','1663705548','212077682','2022-09-01T11:57:37.293','85709245','Stephen Eaton','Eaton Realty','','','28.683049','-96.452570','16','77979','3','110000.00','Active','State Highway 172','24200','','Port Lavaca','1','0','2','980','Single-Family','2 bedroom 1 bath cottage on 1 Acre of land with own water well and septic. 3 miles from public boat ramp in Olivia and Port Alto. Great weekender or home for nearby worker. Needs some cosmetic upgrades but solid and huge potential. Being sold AS IS.','1','65','','','','','Sellers Disclosure','','','','','Other Heating','0','BLUEBONNET ACRES, BLOCK 1, LOT 3, ACRES 1.0','Other','43560','Appraisal District','','','0','','0','','0','','','','','Wood Shingle','169 - Calhoun County','HARRISON/JEFFERSON/MADISON eLEMENTARY SCHOOL','CALHOUN HIGH SCHOOL','TRAVIS MIDDLE SCHOOL (CALHOUN COUNTY)','Appointment Required','Appraisal District','1','Traditional','Bluebonnet Acres','902','1.7153','Septic Tank,Well','1962','Appraisal District'); --> New record created successfully