Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:11:18.670' ,`MLSNumber` = '52927945' ,`ListAgentFullName` = 'Mylene Th Pham' ,`ListOfficeName` = 'SOVRAN' ,`SellingAgentFullName` = 'Jennifer Nixon' ,`SellingOfficeName` = 'Meadows Property Group' ,`Latitude` = '29.730353' ,`Longitude` = '-95.482617' ,`PhotoCount` = '25' ,`PostalCode` = '77057' ,`RoomCount` = '3' ,`ListPrice` = '599990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Beverly Forest' ,`StreetNumber` = '3318' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2085' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction, never lived in, and READY FOR IMMEDIATE MOVE IN home! Centrally located in town close to major freeway and near the Galleria Mall, this house features an open floor-plan with high ceilings and wood flooring throughout living areas and bedrooms. The kitchen has a built in wine cooler as well as a built in desk area to the side. The sizable primary bedroom features a bathroom with double sinks, a soaking tub, and storage shelving galore! Rooftop terrace on the 4th floor, perfect for hosting and or entertaining. Come see this house today! It is also to be featured on a TV show airing soon!' ,`Acres` = '0.0345' ,`Area` = '22' ,`BuilderName` = 'Reginal Design Cons' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 GLENHAVEN ESTATES SEC 2 PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'GLENHAVEN ESTATES' ,`TaxAmount` = '2696' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946228' WHERE `Matrix_Unique_ID` = '206757148' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '52160740' ,`ListAgentFullName` = 'Norma Ramos' ,`ListOfficeName` = 'DLR Properties, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.808408' ,`Longitude` = '-94.896393' ,`PhotoCount` = '46' ,`PostalCode` = '77523' ,`RoomCount` = '8' ,`ListPrice` = '298500.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn Fall' ,`StreetNumber` = '7919' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2886' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready to move-in fully renovated home in 2022 conveniently located near Chambers Town Center only 30 minutes from downtown Houston and easy access to I-10 and SH 146. This beautiful four-bedroom house features an upgraded kitchen with quartz countertops, stove, microwave, and dishwasher. Experience an established neighborhood in a home with HVAC system installed 2022, updated restrooms, lighting, doorknobs and interior/exterior paint. The dining and living area include a cozy fireplace with access to the rear porch with an extended patio and storage shed. The primary bedroom features a spacious walk-in closet and private double sink bathroom. 3 secondary bedrooms with walk-in closets, and spacious game room with tile and carpet on the second floor. Must see to appreciate so call now to set up a private tour!' ,`Acres` = '0.155' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 HUNTERS CHASE SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6752' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`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,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Chase Sec 02' ,`TaxAmount` = '6917' ,`TaxRate` = '2.8882' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946228' WHERE `Matrix_Unique_ID` = '207456471' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '86961176' ,`ListAgentFullName` = 'Rene Sorola' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.805851' ,`Longitude` = '-94.907523' ,`PhotoCount` = '39' ,`PostalCode` = '77521' ,`RoomCount` = '5' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Wood Hollow' ,`StreetNumber` = '7815' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2531' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully maintained 5 bedroom home situated on a large lot with no back neighbors in the peaceful Lynnwood community. Impressive floor plan includes formal dining room with elegant chandelier and upstairs game room. Arched walkways, plush carpet and attractive tile flooring throughout. Designed for entertaining with open concept living, kitchen and dining areas. The living room is spacious and offers large windows allowing in plenty of natural light. Gourmet kitchen features granite counter tops, stainless steel appliances, tile back splash and under mount sink. First floor primary retreat is complete with walk in closet, dual sinks, garden tub and separate shower. The big back yard is perfect for outdoor entertaining with huge extended covered patio and sparkling swimming pool. Zoned to Goose Creek ISD. Local attractions are only minutes away including shopping, restaurants, and many outside recreational options. Schedule your showing to view this exceptional property today!' ,`Acres` = '0.132' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BK 2 LT 145 LYNNWOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`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,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'LYNNWOOD' ,`TaxAmount` = '6199' ,`TaxRate` = '2.9232' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946228' WHERE `Matrix_Unique_ID` = '210181017' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '55238890' ,`ListAgentFullName` = 'Lindi Braddock' ,`ListOfficeName` = 'Coldwell Banker PropertiesUnlimited' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.177071' ,`Longitude` = '-96.426269' ,`PhotoCount` = '30' ,`PostalCode` = '77833' ,`RoomCount` = '14' ,`ListPrice` = '439900.00' ,`Status` = 'Active' ,`StreetName` = 'Rootstock' ,`StreetNumber` = '1007' ,`StreetSuffix` = 'Road' ,`City` = 'Brenham' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2658' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This elegant, yet welcoming, two-story home located in the New Vintage Farms Subdivision is wonderfully designed with 4 bedrooms, 3.5 bathrooms and a spacious game room upstairs! This large home features lots of space and several upgrades like custom wood blinds throughout the home, updated light fixtures, elegant chandelier lighting fixtures, a larger covered porch, custom integral blinds and GE Energy Star certified stainless steel appliances, an ADT Security System with cameras, a Ring Doorbell and more.\r\nThe Entryway with 18-foot foyer window opens to the Formal Dining Room that leads into the large open Kitchen. A beautiful Breakfast Nook and spacious Living Room flow together seamlessly. Also off the Living Room is a hallway with a Half Bath, a spacious hall closet, and Laundry Room.\r\nBackyard Discovery Skyfort II Cedar Swing/Playset located in the huge backyard with snack stand, picnic table, 10’ wave slide, clubhouse fort, rock climbing wall, sandbox and monkey bars.' ,`Acres` = '0.152' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S5940 - VINTAGE FARM S/D # 1, BLOCK 2, LOT 38, ACRES 0.152' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6621' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Vintage Farms Sub' ,`TaxAmount` = '6052' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946228' WHERE `Matrix_Unique_ID` = '210445828' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '64785944' ,`ListAgentFullName` = 'Sharon Ballas' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.765584' ,`Longitude` = '-95.538800' ,`PhotoCount` = '42' ,`PostalCode` = '77024' ,`RoomCount` = '14' ,`ListPrice` = '2795000.00' ,`Status` = 'Active' ,`StreetName` = 'Surrey' ,`StreetNumber` = '12014' ,`StreetSuffix` = 'Lane' ,`City` = 'Bunker Hill Village' ,`BathsFull` = '5' ,`BathsHalf` = '3' ,`BedsTotal` = '5' ,`SqFtTotal` = '6494' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Incredible home w/ handsome stone façade, Whole house generator, Lutron lighting system, French white oak flooring, beamed ceilings, fabulous staircase & beautifully proportioned rooms. The dramatic entry opens to the dining room w/ temperature controlled wine room. The exceptional study w/ a wall of bookcases, abundant storage & French doors opens to backyard activities. The well-equipped kitchen features a large gathering island w/ breakfast bar, Wolf range, 3 ovens, SubZero refrigerator, warming drawer, walk-in pantry & breakfast room. Adjoining family room w/ fireplace & beamed ceiling opens to the pavilion & summer kitchen w/ half bath. Elegant primary suite features a sitting area overlooking the backyard & a beautiful bath w/ claw foot tub, spa shower, coffee bar & great closet! Wonderful secondary bedrooms w/ private baths. Gameroom & separate media room w/bar. Large light-filled utility room. Lockers. Circle drive. Porte cochere. Extra parking & gated drive. Cul-de-sac street.' ,`Acres` = '0.4369' ,`Area` = '23' ,`BuilderName` = 'Silverwood Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT G SURREY LANE PLACE' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '19035' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'FROSTWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bunker Hill Village' ,`TaxAmount` = '60358' ,`TaxRate` = '2.1656' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946228' WHERE `Matrix_Unique_ID` = '210671684' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:50:36.837' ,`MLSNumber` = '94084535' ,`ListAgentFullName` = 'Ahmad Adam' ,`ListOfficeName` = 'Adam Group Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.719617' ,`Longitude` = '-95.827936' ,`PhotoCount` = '49' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '644500.00' ,`Status` = 'Active' ,`StreetName` = 'Bell Mountain' ,`StreetNumber` = '4802' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3745' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Stunning home features the ultimate luxury privacy. No rear neighbors, a beautiful elevation with brick and stone, a gorgeous entryway with a tall ceiling, and a secluded and spacious master with a high ceiling and bay window that opens to a beautiful backyard; retreat highlights this Taylor Morrison home. This sought-after floor plan features soaring ceilings, a large media room with built-in speakers, a screen, a projector, and an elegant study with a custom build in bookshelf and desk millwork. Spacious Gameroom upstairs with lots of windows. A beautiful covered patio and a second-story balcony overlook Georges\'s backyard, green space, and water views. The kitchen features a butler\'s pantry, custom cabinets, under-counter lighting, stainless steel appliances, and exotic granite. Three-car garage. New water heaters, New Carpet throughout the upstairs, and fresh paint. Water softener, reverse osmosis with cold and hot water, Refrigerator, Never flooded. Great Katy schools.' ,`Acres` = '0.2054' ,`Area` = '36' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH SOUTHWEST SEC 27, BLOCK 1, LOT 9' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Water View' ,`LotSize` = '8946' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'TAYS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch Southwest Sec 27' ,`TaxAmount` = '11509' ,`TaxRate` = '2.7045' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946229' WHERE `Matrix_Unique_ID` = '211200036' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '18375488' ,`ListAgentFullName` = 'Edna Trevino' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811308' ,`Longitude` = '-94.928683' ,`PhotoCount` = '36' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Huntington' ,`StreetNumber` = '8319' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1776' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Chesmar Home! Lightly lived in breezy home and ready for new homeowners.\r\nStunning well maintained home features 3 bedrooms, 2 full bathrooms, STUDY with French doors, 2-Car garage, sprinkler irrigation system, COVERED PATIO with spacious fenced backyard, OPEN CONCEPT FLOOR PLAN with high ceilings. Excellent flow through-out the kitchen which is open to the breakfast area making it perfect for those who entertain. Beautiful tile flooring through-out the living, kitchen, breakfast area. Utility room situated near primary bedroom and kitchen for easy access. Primary bedroom with a large walking closet, soaking tub and separate shower. \r\nNo Flooding! Conveniently located and easy access to I-10 East Freeway. Schedule a showing today!' ,`Acres` = '0.162' ,`Area` = '2' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 HUNTERS CREEK SEC 1' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7056' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Crk Sec 01' ,`TaxAmount` = '1362' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946229' WHERE `Matrix_Unique_ID` = '211697754' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '83492311' ,`ListAgentFullName` = 'Raquel Bell' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.688417' ,`Longitude` = '-95.785614' ,`PhotoCount` = '46' ,`PostalCode` = '77406' ,`RoomCount` = '9' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Abriola' ,`StreetNumber` = '11506' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4168' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 2-story Trendmaker design in the highly-acclaimed Master Planned community of Lakes of Bella Terra. Boasts backyard paradise w/TX-sized covered patio, heated in-ground pool & spa, + lush resort landscape. Interior features hardwood floors, soaring 2-story ceilings, custom light fixtures, crown molding & more. >4,100sqft floor plan offers executive study behind French doors, & grand family room w/stately floor-to-ceiling fireplace, surround sound, & dazzling pool views. Chef\'s island kitchen boasts granite countertops & modern SS appliances; including double ovens, wine fridge & gas cooktop w/pot filler. 2 beds down, including Primary Suite w/spa-like en-suite bath; w/dual sinks, jetted tub + oversized shower & huge walk-in closet w/custom built-ins. Game room upstairs + \"secret room\" behind bookcase, 3 secondary beds & 2 full baths for sharing (1 Hollywood). Steps from world-class amenities including clubhouse, pool, sports courts, sparkling lakes w/walking trails & more.' ,`Acres` = '0.2618' ,`Area` = '37' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKES OF BELLA TERRA SEC 15, BLOCK 1, LOT 37' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11405' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUBENAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Lakes Of Bella Terra' ,`TaxAmount` = '15604' ,`TaxRate` = '3.24' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946229' WHERE `Matrix_Unique_ID` = '212119417' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:19:33.233' ,`MLSNumber` = '60945212' ,`ListAgentFullName` = 'Tirey Counts' ,`ListOfficeName` = 'Monarch Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.846585' ,`Longitude` = '-95.336360' ,`PhotoCount` = '23' ,`PostalCode` = '77093' ,`RoomCount` = '5' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Hurley' ,`StreetNumber` = '3225' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1237' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A perfect home for someone who needs lots of parking space. Very convenient location that is 1 minute from Hiway 69, and just 3 minutes from Loop 610. A 10 minute drive to downtown, restaurants, bank, pharmacy, grocery, home/ office depot, clothes, gas.... This house never flooded. Gated, corner lot, 1 story house , lots of parking spaces, large bricked back/side yard for activities, easy to maintain, lots of possibilities, no HOA/ restrictions area.' ,`Acres` = '0.1228' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 20B-1 ABST 329 J T HARRELL' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5349' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARCIA ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER' ,`SchoolMiddle` = 'PATRICK HENRY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'ABST 329 J T HARRELL' ,`TaxAmount` = '2536' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946229' WHERE `Matrix_Unique_ID` = '212174109' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '51914548' ,`ListAgentFullName` = 'Sabiha Rehmatulla' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747649' ,`Longitude` = '-95.513445' ,`PhotoCount` = '48' ,`PostalCode` = '77024' ,`RoomCount` = '14' ,`ListPrice` = '7990000.00' ,`Status` = 'Active' ,`StreetName` = 'Stillforest' ,`StreetNumber` = '40' ,`StreetSuffix` = 'Street' ,`City` = 'Piney Point Village' ,`BathsFull` = '7' ,`BathsHalf` = '3' ,`BedsTotal` = '6' ,`SqFtTotal` = '12617' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Piney Point custom designed estate by acclaimed architect Robert Dame offers a complete custom living experience with polished details carefully curated for a resort like lifestyle with exceptional amenities such as pool, theater, tennis court, outdoor kitchen with fireplace and gardening house. Situated on 1 sprawling acre of gorgeous grounds. 2-story library with built in shelvings. The formal dining with walk out patio is ideal for hosting formal dinners. Gourmet chef’s kitchen with a large island features custom designed cabinetry and a catering/prep kitchen. Covered outdoor includes kitchen with cabinetry & high-end appliances. Primary suite offers a fireplace, marble bathroom with dual walk in closets and its own private staircase t the gym & study. Additional bedrooms with ensuite bathrooms. This home offers astounding amenities (generator, elevator, Crestron home automation & mosquito control system). The neighborhood has its own security in addition to the Piney Point Police.' ,`Acres` = '0.995' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '5' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 20 STILL FOREST U/R ABST 72 J D TAYLOR' ,`LotDesciption` = 'Wooded' ,`LotSize` = '43342' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEMORIAL DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Still Forest #20' ,`TaxAmount` = '99528' ,`TaxRate` = '2.1721' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666946230' WHERE `Matrix_Unique_ID` = '212207361' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T00:42:53.813' ,`MLSNumber` = '59184652' ,`ListAgentFullName` = 'Kimbriana Nzeogu' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.467176' ,`Longitude` = '-95.529582' ,`PhotoCount` = '26' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '610000.00' ,`Status` = 'Active' ,`StreetName` = 'Morning Glow' ,`StreetNumber` = '8810' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3048' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury living in the highly desired Master Planned Community of Sienna with resort style amenities. This new construction, move-in ready Perry Home has NEVER been lived in. Meticulously crafted open-concept floor plan offers a 2-story family room and dining room with soaring 19\' ceilings, great for entertaining. With 5 bedrooms and 4.5 bathrooms, there is a bathroom for almost every room in the house. Home office with French doors is set at the 2-story entryway, very convenient for remote work. Chef\'s kitchen featuring engineered stone countertops overlooks the family room with a wall of windows. The massive primary suite does not disappoint with ensuite bathroom including 2 walk-in closets, double vanities, stand up shower, separate spa tub and private toilet room. As a bonus, there is a secondary bedroom with a full ensuite bathroom on the first floor. Custom shutters have been newly installed in each bedroom. Extended covered patio and oversized backyard complete this Smart Home.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sienna - Section 32A, LOT 23, BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7490' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666946230' WHERE `Matrix_Unique_ID` = '212276654' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:18:01.507' ,`MLSNumber` = '19000667' ,`ListAgentFullName` = 'Irene Rangel' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = 'Fernando Cruz' ,`SellingOfficeName` = 'Keller Williams Signature' ,`Latitude` = '29.828960' ,`Longitude` = '-95.708654' ,`PhotoCount` = '22' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '325000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Meadow Lilly Ln' ,`StreetNumber` = '3926' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2189' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The property is occupied, and the Tenant is on a month-to-month basis. This is a beautiful home in Westfield, it has an open Kitchen, spacious bedrooms, nice backyard and covered patio. Make it your home or your next investment property. Showings will start on October 1st, Please call for details and/or for an appointment. Irene Rangel, Realtor' ,`Acres` = '0.196' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 2 WESTFIELD SEC 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8557' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '437' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RHOADS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CARDIFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946230' WHERE `Matrix_Unique_ID` = '212331041' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '10254752' ,`ListAgentFullName` = 'Charlotte Oldbury' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.805594' ,`Longitude` = '-94.927010' ,`PhotoCount` = '33' ,`PostalCode` = '77521' ,`RoomCount` = '10' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Hunters Trace' ,`StreetNumber` = '6511' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2178' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 2-storied home with 4 bedrooms, 2.5 bathrooms, and almost 2200 square feet features an open floor plan with the primary suite downstairs. Granite countertops, stainless appliances with refrigerator included connect the kitchen to the breakfast area and overlook the living room. Conveniently located on the first floor are the study with custom barn door, utility room, and half bath. Upstairs are the gameroom and three additional bedrooms plus full bathroom. The backyard features a large patio and plenty of space for pets or entertaining. Never flooded and no burst pipes! Community amenities include a playground, splashpad, walking trails, pavilion, green space and dog park! Located close to IH-10, major highways, restaurants, shopping, and a half-hour to downtown Houston, schedule your private tour today!' ,`Acres` = '0.1389' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 3 HUNTERS CREEK SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Crk Sec 3' ,`TaxAmount` = '8279' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946230' WHERE `Matrix_Unique_ID` = '212366842' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:55:07.460' ,`MLSNumber` = '71699754' ,`ListAgentFullName` = 'Vera Mitrofanova' ,`ListOfficeName` = 'VAM Real Estate Solutions' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.483422' ,`Longitude` = '-95.499883' ,`PhotoCount` = '44' ,`PostalCode` = '77459' ,`RoomCount` = '11' ,`ListPrice` = '570000.00' ,`Status` = 'Active' ,`StreetName` = 'Magnolia Mist' ,`StreetNumber` = '2414' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3357' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sellers will contribute $10,000 towards buy-down points to reduce buyers’ interest rate. This beautiful pristine barely lived in house by Westin Homes features 4 bedrooms, 3 full bathrooms and 1 half bath. Gourmet kitchen with gorgeous large kitchen island, plethora of counter and cabinet space, dramatic ceilings throughout, abundance of light from energy efficient windows, spacious walk in closets, media room, game room, formal dining, office. Carpet upstairs and in the primary bedroom. Both AC units have been replaced in 2021. Nothing about this house is builder standard. Owners upgraded marble countertops in the bathrooms and floor tiles throughout the first floor worth of over 50K. Enjoy entertaining your friends and family at a covered patio with a spacious backyard. Master Planned community of Sienna Plantation with world class amenities including water parks, Siena golf club, grille, 100+ acres of parks, miles of walking trails and more. Fort Bend ISD. Schedule today!' ,`Acres` = '0.182' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA PLANTATION SEC 22, BLOCK 3, LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7928' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`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,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Plantation Sec 22' ,`TaxAmount` = '6274' ,`TaxRate` = '3.1629' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666946230' WHERE `Matrix_Unique_ID` = '212406622' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '65863238' ,`ListAgentFullName` = 'Meaghan Arceneaux' ,`ListOfficeName` = 'Mega Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.177254' ,`Longitude` = '-95.451859' ,`PhotoCount` = '44' ,`PostalCode` = '77515' ,`RoomCount` = '5' ,`ListPrice` = '585000.00' ,`Status` = 'Active' ,`StreetName` = 'Laurel' ,`StreetNumber` = '1264' ,`StreetSuffix` = 'Loop' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3028' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 1264 Laurel Loop, where elegance meets suburbs. This beautiful two story brick home will surely take you by surprise from the moment you arrive. Upon entry you’ll see no expense was spared- marble floors and beautiful stone work through out the main areas of the home give a one of kind feature like no other. Boasting over 3000sqft this home showcases 5 bedrooms, 3.5 bathrooms, a large formal dining area, and a kitchen fit for the finest chef. All wood cabinetry, marble backsplash, and large stainless sink are just a few upgrades worth mentioning. Great sizes bedrooms and no carpet make this desirable for most. As if you needed more convincing- have you seen the backyard? A true entertainers dream. Tons of concrete, covered outdoor kitchen, and best of all no back neighbors making this the ideal place for your next holiday or event. Call and schedule your private tour today!' ,`Acres` = '0.315' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HERITAGE COURT SD SEC 1 (A0380 J DE J VALDERAS) BLK 2 LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'HERITAGE COURT' ,`TaxAmount` = '9398' ,`TaxRate` = '2.610229' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946231' WHERE `Matrix_Unique_ID` = '212685570' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '71237850' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.039654' ,`Longitude` = '-95.405887' ,`PhotoCount` = '32' ,`PostalCode` = '77531' ,`RoomCount` = '6' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Jackson' ,`StreetNumber` = '506' ,`StreetSuffix` = 'Avenue' ,`City` = 'Clute' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2526' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to College Park Estates! This is a beautiful 4 bedroom, 2.5 bathroom with a 2 car attached garage! This is a split floor plan. The kitchen is a chef\'s dream with plenty of cabinet and counter space and it opens up to the living room. The countertops and backsplash have been updated. The primary bedroom is very spacious with an updated bathroom. Access the backyard oasis from the primary bedroom. There is a tiki bar and hot tub. The home has a beautiful lake view from the backyard. There is a screen patio, also great for entertaining! The home has solar panels and a generator. You don\'t want to miss out on this home, call today for your private showing!' ,`Acres` = '0.2938' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Clute' ,`HeatSystem` = 'Central Electric,Solar Assisted' ,`HOAMandatory` = '0' ,`Legal` = 'COLLEGE PARK ESTATES SEC 4 (A0066 J E GROCE) (CLUTE) BLK 2 L' ,`LotDesciption` = 'Cleared,Subdivision Lot,Waterfront' ,`LotSize` = '12798' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'GRIFFITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'College Park Estates' ,`TaxAmount` = '8904' ,`TaxRate` = '2.6231' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946231' WHERE `Matrix_Unique_ID` = '212700554' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '52101575' ,`ListAgentFullName` = 'Stephanie Delacruz' ,`ListOfficeName` = 'Metro Plus Realty PLLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.807819' ,`Longitude` = '-94.898849' ,`PhotoCount` = '26' ,`PostalCode` = '77523' ,`RoomCount` = '4' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar View' ,`StreetNumber` = '7915' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2886' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You\'ll love this stunning 4 bedroom home! The heart of this home, the kitchen with an adjoining family room makes it ideal for gatherings. Home features marble countertops, wood floors, upgraded bathrooms with a gorgeous stand up shower and tub in the master bath, a large master closet, new carpet upstairs, and a huge game room! Minutes from shopping, entertainment, and restaurants. The home is conveniently located at the end of the cul-de-sac. This property is beautiful, well-cared for, and ready for new owners. Welcome home!' ,`Acres` = '0.151' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 HUNTERS CHASE SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6578' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`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` = 'Accompany,Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Chase Sec 02' ,`TaxAmount` = '6764' ,`TaxRate` = '2.8882' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946231' WHERE `Matrix_Unique_ID` = '212714908' --> 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','212950761','1666946231','212950761','2022-10-27T00:20:59.810','17778755','Shean Manickchan','United Real Estate','','','29.940722','-95.503508','1','77066','4','304000.00','Active','Imperial Grove','5606','Drive','Houston','2','1','4','2348','Single-Family','Welcome Home to this newly renovated home nestled in the beautiful Ashcreek subdivision! This home features 4 spacious rooms, 2.5 baths, a family room, living room, dining room and gorgeous kitchen. The home has fresh paint in and out, new flooring in bedrooms, and a renovated kitchen. Don\'t miss this opportunity to own this gem. This home is conveniently located near major highways including beltway 8. Measurements are approximate. Home never flooded. Call today to schedule your private tour!','0.1543','13','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','1960/Cypress Creek South','Central Gas','1','LT 23 BLK 5 ASHCREEK','Subdivision Lot','6720','Appraisal District','','425','0','','2','Gas Oven','0','','','Gas Range','','Composition','32 - Klein','MCDOUGLE ELEMENTARY SCHOOL','KLEIN FOREST HIGH SCHOOL','WUNDERLICH INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Ashcreek','4850','2.6316','Water District','1998','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '20790885' ,`ListAgentFullName` = 'David Flory' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.744872' ,`Longitude` = '-95.345182' ,`PhotoCount` = '36' ,`PostalCode` = '77003' ,`RoomCount` = '15' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'McKinney' ,`StreetNumber` = '3216' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious 3,410 sqft, ELEVATOR capable home w/ French influences, GAME ROOM & ROOFTOP DECK in EaDo. GATED COMMUNITY w/ Guest Parking by InTown Homes. HIGH CEILINGS, natural light & high end finishes. Foyer w/ TRAVERTINE Tiles, ext. Baseboards & Crown Moulding. All Bed w/ EnSuite Baths. 1st floor Foyer, Bed/ Study & Access to SIDE YARD. Solid WOOD STAIR RISERS w/ Upgraded WROUGHT IRON Spindles lead to floor 2. OAK floors open to Kitchen w/ PANTRY, Granite Countertops, Gas Cooktop, & Stainless Steel Appliances. DINING, Living Room w/ Gas FIREPLACE & COVERED BALCONY overlooking entry courtyard. Well situated 1/2 BATH finishes the second floor. 3rd floor hosts the Primary Bedroom w/ 3 WALK IN CLOSETS, dual vanities, freestanding SOAKING TUB & separate shower. Bedroom 3 w/ 2 closets. 4th floor completes the home w/ Bed 4 w/ Walk in, Oversized GAME ROOM & ROOF TOP PATIO w/ Gas Connection. STUNNING views of Houston Skyline. Minutes from Downtown, MinuteMaid, UofH, Bike Trails, & Med Center.' ,`Acres` = '0.0367' ,`Area` = '4' ,`BuilderName` = 'InTown Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 MCKINNEY LANDING' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '1598' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1980' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LANTRIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'French,Traditional' ,`Subdivision` = 'McKinney Landing' ,`TaxAmount` = '13462' ,`TaxRate` = '2.4557' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946231' WHERE `Matrix_Unique_ID` = '212954613' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '21571682' ,`ListAgentFullName` = 'Michael Terry' ,`ListOfficeName` = 'Goldenlight Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768258' ,`Longitude` = '-95.727856' ,`PhotoCount` = '50' ,`PostalCode` = '77450' ,`RoomCount` = '11' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Shillington' ,`StreetNumber` = '1146' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2616' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Attractive frequently maintained home with a view to Mason Creek. Back gate opens to green space that adjoins to Harris County’s Mason Creek Hike & Bike Trail. The Kitchen includes a 36\" Thermador range, Viking double oven, LG refrigerator and a new Cummings natural gas emergency generator that powers the complete house and swimming pool. The detached garage has a large workshop area with built in shelves, work benches and storage in the floored garage attic. There is a screened outdoor patio with a cabinet and outdoor television that remains. The steel Bar B Que pit remains with the house. The very attractive swimming pool has pebble tec. The pool cleaner will remain. The window treatments will remain. The front windows have custom wood shutters. The house alarm, lights and sprinkler system are wifi controlled. Room sizes should be verified by the buyer. All doors and windows are double pane. Seller said no flooding during Harvey.The seller\'s Real Estate agent is related to the seller' ,`Acres` = '0.2014' ,`Area` = '36' ,`BuilderName` = 'Kickerillo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 21 NOTTINGHAM COUNTRY SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'NOTTINGHAM COUNTRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MEMORIAL PARKWAY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English' ,`Subdivision` = 'Nottingham Country Sec 07' ,`TaxAmount` = '7019' ,`TaxRate` = '2.3693' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946231' WHERE `Matrix_Unique_ID` = '213073796' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:11:50.730' ,`MLSNumber` = '7178200' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.596859' ,`Longitude` = '-95.537593' ,`PhotoCount` = '27' ,`PostalCode` = '77489' ,`RoomCount` = '3' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Village Park' ,`StreetNumber` = '2027' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2191' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautifully renovated two story home on a quiet street. The updated kitchen boasts professionally refinished cabinetry, stylish granite countertops and modern tile backsplash. With new flooring throughout, updated bathrooms, a new furnace and fresh paint inside and out, this home is truly move-in ready. Relax in your primary suite, complete with a new custom tiled shower. Enjoy your favorite drink on your patio in your fenced backyard. Don’t miss this incredible opportunity. This home has been virtually staged to illustrate its potential' ,`Acres` = '0.1123' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HUNTERS GREEN, BLOCK 4, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4890' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '354' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'EDGAR GLOVER JR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Green' ,`TaxAmount` = '4622' ,`TaxRate` = '2.5525' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666946232' WHERE `Matrix_Unique_ID` = '213076133' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:38:50.773' ,`MLSNumber` = '93784915' ,`ListAgentFullName` = 'Rose Cantu' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.643222' ,`Longitude` = '-95.425771' ,`PhotoCount` = '25' ,`PostalCode` = '77045' ,`RoomCount` = '4' ,`ListPrice` = '199000.00' ,`Status` = 'Active' ,`StreetName` = 'Angel' ,`StreetNumber` = '3322' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1104' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stop by to see this beautiful, well-maintained home located in the neighborly community of Village at Glen Iris! It is a beautiful and cozy 3 bedroom 1 bath home ready for move in! You won\'t want to miss this one! It\'s just a few minutes from the Medical Center and Downtown with easy access to Beltway 8, Hwy 90 and I-610. It is the perfect starter home with great space both inside and out. The interior features wood laminate flooring in the living room and bedrooms with tile flooring in the wet areas and NO carpet. The water heater and HVAC system are less than 5 years old. The front patio is a great place to drink your morning coffee, while the backyard features its own personal shed, a fenced garden and an oversized 10\'x32\' concrete patio perfect for grilling and entertaining. Schedule your showing today!' ,`Acres` = '0.1263' ,`Area` = '18' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 2 VILLAGE AT GLEN IRIS' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '420' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HOBBY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Village at Glen Iris' ,`TaxAmount` = '2594' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946232' WHERE `Matrix_Unique_ID` = '213130331' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T00:44:55.943' ,`MLSNumber` = '84783201' ,`ListAgentFullName` = 'Michael Slater' ,`ListOfficeName` = 'Crimson Realty LLC' ,`SellingAgentFullName` = 'Daisy Paredes' ,`SellingOfficeName` = 'Crimson Realty LLC' ,`Latitude` = '29.687287' ,`Longitude` = '-95.661811' ,`PhotoCount` = '25' ,`PostalCode` = '77083' ,`RoomCount` = '0' ,`ListPrice` = '220000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Schumann' ,`StreetNumber` = '15706' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1302' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1341' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MISSION GLEN SEC 2, BLOCK 1, LOT 1, (SLIDE #565B)' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5843' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '326' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MISSION GLEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'HODGES BEND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Mission Glen' ,`TaxAmount` = '2863' ,`TaxRate` = '2.2857' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946232' WHERE `Matrix_Unique_ID` = '213321886' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '48647807' ,`ListAgentFullName` = 'Ernestina Argueta' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.937019' ,`Longitude` = '-95.174531' ,`PhotoCount` = '47' ,`PostalCode` = '77044' ,`RoomCount` = '10' ,`ListPrice` = '529900.00' ,`Status` = 'Active' ,`StreetName` = 'Waterside View' ,`StreetNumber` = '14815' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3803' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BUILT BY TAYLOR MORRISON- Welcome to this beautiful hard to find home.\r\nThis stunning 2-story home in the highly acclaimed neighborhood of Stillwater in Lake Houston is a gated community backing up to Lake Houston, House located in a cul-de-sac street, Upon walking into the front door you will fall in love with the soaring ceilings that open up to this impressive home, the family room that offers a wall of windows opening up to the modern and extensive kitchen, Kitchen stove top including five burner, Kitchen cabinets including soft close, Butlers pantry with own wine refrigerator, The large primary bedroom located in the first floor creates a relaxing retreat, guest bedroom within own suite also located in the first floor, upstairs you will find 3 bedrooms plus a game and media room, plug connections located in the roof for easy christmas lights decoration, Did I mentioned the high efficiency HVAC,low E-windows and no back yard easement.' ,`Acres` = '0.1794' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 1 STILLWATER ON LAKE HOUSTON SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7816' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stillwater/Lk Houston' ,`TaxAmount` = '13672' ,`TaxRate` = '3.4539' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666946232' WHERE `Matrix_Unique_ID` = '213332152' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '8223328' ,`ListAgentFullName` = 'Dimas Gomez' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.497318' ,`Longitude` = '-95.766316' ,`PhotoCount` = '13' ,`PostalCode` = '77469' ,`RoomCount` = '3' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Orange Tree' ,`StreetNumber` = '7122' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1123' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautifully 3 bedrooms and 2 full bathrooms remodeled one-story home in Sunrise Meadow! New Carpet in all rooms, New Tile & Wood laminate flooring installed, New Granite counters in Kitchen, Fresh paint throughout the house, New Roof. All kitchen appliances stay with home. Upon entry you are welcomed by a very roomy living/dining room combo. The open design includes a kitchen with an island as well! Close to shopping and zoned to the highly acclaimed LCISD. Come take a look at this home that has a low tax rate and low HOA annual fees. Large covered patio for grilling/entertaining, & fenced backyard w/no direct back neighbors! Make an Appointment TODAY!' ,`Acres` = '0.157' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SUNRISE MEADOW SEC 3, BLOCK 2, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6838' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunrise Meadow Sec 3' ,`TaxAmount` = '4027' ,`TaxRate` = '2.8148' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946232' WHERE `Matrix_Unique_ID` = '213400298' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '70055519' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.038055' ,`Longitude` = '-95.405043' ,`PhotoCount` = '26' ,`PostalCode` = '77531' ,`RoomCount` = '6' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Hancock' ,`StreetNumber` = '202' ,`StreetSuffix` = 'Street' ,`City` = 'Clute' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1841' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come home to this beautifully updated 3 bedroom, 2 bath home in the lovely College Park subdivision. This home is conveniently located near schools, restaurants and the highway - giving you everything you could possibly need, nearby. The kitchen is a chef\'s dream with quartz countertops and a butcher-block island. Most of the appliances have been recently replaced, along with the A/C unit as well as flooring, paint updates and landscaping improvements. An attached generator will keep things running when needed. This home won\'t stay, so call today to make it yours!' ,`Acres` = '0.2166' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clute' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'COLLEGE PARK ESTATES SEC 5 (A0066 J E GROCE) (CLUTE) BLK 4 L' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9435' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'GRIFFITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'College Park Estates Sec 5' ,`TaxAmount` = '7207' ,`TaxRate` = '2.6231' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946233' WHERE `Matrix_Unique_ID` = '213412983' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '81892641' ,`ListAgentFullName` = 'Teri Smith' ,`ListOfficeName` = 'RE/MAX Real Estate Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.807565' ,`Longitude` = '-95.426192' ,`PhotoCount` = '23' ,`PostalCode` = '77008' ,`RoomCount` = '6' ,`ListPrice` = '479000.00' ,`Status` = 'Active' ,`StreetName` = '24th' ,`StreetNumber` = '1504' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2339' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful maple floors throughout, no carpeting. Modern spacious kitchen with large island quartz countertops and backsplash with stainless steel appliances beautiful 6 burner gas range. Fridge & wine fridge stays. Huge pantry. Dining room area with wine rack and wine fridge. Spacious primary bedroom with huge closet and beautiful bathroom. 2 secondary bedrooms with separate baths. All bedrooms have closets. First floor and 3rd floor bedroom closet behind bathroom door.Custom window treatments on all windows. Updated with security system, wifi enabled garage door and lots of other extras. White Oak Trail is within walking distance. Near many favorite eating spots-Lucha, Superica, Crisp.' ,`Acres` = '0.0387' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 COTTAGE HEIGHTS ONE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1685' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Cottage Heights 1' ,`TaxAmount` = '9113' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946233' WHERE `Matrix_Unique_ID` = '213415708' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T00:05:10.450' ,`MLSNumber` = '8324287' ,`ListAgentFullName` = 'Stephanie Phillips' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.235407' ,`Longitude` = '-95.565539' ,`PhotoCount` = '30' ,`PostalCode` = '77354' ,`RoomCount` = '11' ,`ListPrice` = '374000.00' ,`Status` = 'Active' ,`StreetName` = 'Weisinger' ,`StreetNumber` = '922' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2276' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your very own charming 4 bedroom, 3 1/2 bathroom log cabin home! You will fall in love from the circular drive to the large front porch with swing to the two primary bedrooms- all on almost a half-acre! The first floor offers a primary with en-suite bathroom plus a well-appointed cedar lined half bath. Enjoy the updated kitchen with eating area and views of the large backyard. The family room offers a beautiful stone mantel and standalone gas log fireplace. The second floor includes another primary bedroom with en-suite bathroom, two other secondary bedrooms, another full bath / utility room. The third level offers a loft which could be used as an office or game/flex room. Wyze doorbell camera and alarm stay with house. Fresh landscaping, 2 storage sheds and a workshop. Updated light fixtures, upgraded Waterproof Laminate Flooring, new counter tops...too many upgrades to list. Community pool, low HOA, no MUD and low taxes. Please see upgrade sheet.' ,`Acres` = '0.4591' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD 04, BLOCK 2, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '227' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Other Style,Ranch' ,`Subdivision` = 'Westwood 04' ,`TaxAmount` = '4882' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946233' WHERE `Matrix_Unique_ID` = '213490710' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '78301150' ,`ListAgentFullName` = 'Adam Stevenson' ,`ListOfficeName` = 'Rose Above Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.503583' ,`Longitude` = '-95.045023' ,`PhotoCount` = '37' ,`PostalCode` = '77573' ,`RoomCount` = '6' ,`ListPrice` = '309000.00' ,`Status` = 'Active' ,`StreetName` = 'Ocean Manor Lane' ,`StreetNumber` = '1309' ,`StreetSuffix` = '' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1543' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Lakes Of South Shore Harbour! A lovely one story home on a corner lot is waiting for you! This 3 bedroom 2 full bath home is well maintained, cozy and ready to move into. Large living room with separate dining open to the kitchen and breakfast area. Pergo Upgraded Laminate flooring recently installed 10/2022. Large primary suite with en suite bath, double sinks, separate tub and shower large walk in closet. Secondary bedrooms situated away from primary. Enjoy the nice sized backyard with privacy fence.' ,`Acres` = '0.1673' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTH SHORE HARBOUR SEC SF 60-1 (2002) ABST 18, BLOCK 2, LOT' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7286' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '580' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'HYDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Shore Harbour Sec Sf 60' ,`TaxAmount` = '5801' ,`TaxRate` = '2.4521' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946233' WHERE `Matrix_Unique_ID` = '213515663' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T00:54:31.563' ,`MLSNumber` = '44346005' ,`ListAgentFullName` = 'Mary Markwardt' ,`ListOfficeName` = 'HOUSTON TOP REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.504598' ,`Longitude` = '-95.435360' ,`PhotoCount` = '44' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Willowpeak' ,`StreetNumber` = '5505' ,`StreetSuffix` = 'Court' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'VACATION in your own backyard! This stately home is situated on a spacious cul-de-sac lot and offers 4 bedrooms, study, formal dining and a huge game room. Primary bedroom and living room are generous as well. Living room and formal dining have gorgeous engineered hard wood flooring. All new carpet in Sept. of 2022. An awesome covered back patio overlooks the pool & spa making it the perfect place to relax and unwind. Heated Pool & Spa is only two years old! There is also a gas connection on the patio for those gas grills. No flooding. Lakes of Savannah is a master planned community offering two pools, two club houses, splash pad, elementary school, parks, ponds & miles of sidewalks. Located near Hwy. 6 and Hwy. 288. Just minutes to Pearland Town Center. Community did NOT lose power during the big freeze of 2021! Don\'t Dream a Dream, Buy One!' ,`Acres` = '0.2264' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SAVANNAH LANDING SEC 1 (A0403 A C H & B), BLOCK 2, LOT 7, AC' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9862' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SAVANNAH LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes of Savannah' ,`TaxAmount` = '10265' ,`TaxRate` = '3.1908' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946233' WHERE `Matrix_Unique_ID` = '213609514' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '40252234' ,`ListAgentFullName` = 'Sandra Delmonico' ,`ListOfficeName` = 'Krisher-McKay, Inc., REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.791221' ,`Longitude` = '-94.910828' ,`PhotoCount` = '39' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Crystal' ,`StreetNumber` = '10022' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2142' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 4 Bedroom, 2.5 bath home sits on .23 acres and is located in the highly sought after and established subdivision of Tanglewilde in Chambers County. Several updates include wood tile flooring throughout the lower level, brand new carpet throughout the second floor and stairs, large cement back patio situated on an extra large lot with new landscaping and a beautiful gazebo that stays. All appliances come with this home and are brand new, including a smart fridge with a Family hub home screen and speaker to play music. Beautiful granite counter tops with an eat in kitchen and a formal dinning room off the kitchen for entertainment for the holidays. Some of its other features include a large master bedroom, jacuzzi soaking tub with a separate shower, custom built walk in closet, gas fireplace, and custom built drawers in the pantry. Never flooded and no damage from the recent freeze. This home is conveniently located close to shopping centers, schools, theater, and restaurants.' ,`Acres` = '0.23' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 TANGLEWILDE SEC 2 FC% APPRAISAL-EDWARDS' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '10019' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '260' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,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,Call Occupant,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tanglewilde Sec 02' ,`TaxAmount` = '5083' ,`TaxRate` = '2.9232' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946234' WHERE `Matrix_Unique_ID` = '213618106' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '34449471' ,`ListAgentFullName` = 'Elissa Kirkham' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = 'Kristin Tillman' ,`SellingOfficeName` = 'Greenwood King Properties' ,`Latitude` = '29.742645' ,`Longitude` = '-95.491380' ,`PhotoCount` = '24' ,`PostalCode` = '77057' ,`RoomCount` = '9' ,`ListPrice` = '950000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Burgoyne' ,`StreetNumber` = '6150' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This tastefully updated and rare 4/3 Briargrove ranch-style home offers a fantastic open floor plan, abundant natural light, 2-car garage, and an exceptional primary suite. The inviting entryway leads you to the dining and family rooms, highlighted by custom built-ins, gas-log fireplace, and open floor plan. Standout features include primary bedroom/bath addition with expansive bathroom and large walk-in closet, cheery entry with designer wallpaper, new flooring throughout (2019), new countertops and backsplash in kitchen (2019), farmhouse sink, gas range, stainless steel appliances, tankless water heater, turfed backyard with a charming back patio perfect for outdoor entertaining with fresh landscaping and a gated driveway. All info per Seller.' ,`Acres` = '0.1707' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 868 BLK 40 BRIARGROVE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7437' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1210' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`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` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briargrove' ,`TaxAmount` = '20158' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946234' WHERE `Matrix_Unique_ID` = '213645099' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '92882649' ,`ListAgentFullName` = 'Jamie McMartin' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = 'Chandrakasan Vythilingam' ,`SellingOfficeName` = 'Om Realty Group' ,`Latitude` = '29.734246' ,`Longitude` = '-95.865485' ,`PhotoCount` = '32' ,`PostalCode` = '77494' ,`RoomCount` = '8' ,`ListPrice` = '451990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Pottharst Park' ,`StreetNumber` = '3802' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2446' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Final Opportunities to purchase in Section 60 zoned to Katy ISD! D.R. Horton\'s perfect Colby model! 4 Bedrooms! 3 Full Baths! Guest Room with private full bath (perfect In-Law suite if needed)! You are going to love this kitchen, 42” cabinets, stainless steel appliances 5 burner gas range AND Double ovens! ATTACHMENTS SHOW COLOR PACKAGE. Gorgeous flooring, backyard with a covered patio and plumbed for gas! Included is everything you are looking for in a community- resort pool, splashpad, fitness center, sports fields, lakes & walking trails all included and ready for you! Please verify with sales agent options and upgrades. **PHOTOS ARE WHAT YOU CAN EXPECT FROM THE FLOORPLAN! THEY DO NOT SHOW ACTUAL PROPERTY***At this time the builder does not sell to Investors in this neighborhood*' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 128; Block 2; Section 60' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10021' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Tamarron' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666946234' WHERE `Matrix_Unique_ID` = '213686636' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T00:14:51.340' ,`MLSNumber` = '58042706' ,`ListAgentFullName` = 'Tania James' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.045326' ,`Longitude` = '-95.517205' ,`PhotoCount` = '30' ,`PostalCode` = '77379' ,`RoomCount` = '5' ,`ListPrice` = '499999.00' ,`Status` = 'Active' ,`StreetName` = 'St Marcella' ,`StreetNumber` = '6407' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this one of a kind, 6-bedroom, 3.5 full bathroom home in the heart of Klein, Texas! . The open concept home makes a great space for entertaining guests. Primary bedroom downstairs. Additional perks include quiet, friendly neighborhood, easement with easy access to the park, Front lake view, game room and media room upstairs. Schedule your showing as soon as possible, this home will sell fast!' ,`Acres` = '0.1584' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 4 CHANCEL' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '986' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KUEHNLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Chancel' ,`TaxAmount` = '9659' ,`TaxRate` = '2.5085' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946234' WHERE `Matrix_Unique_ID` = '213739588' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '14486134' ,`ListAgentFullName` = 'Christy Bulerez-Wyatt' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = 'LaQuinta Mills' ,`SellingOfficeName` = 'Sparrow Realty' ,`Latitude` = '29.565704' ,`Longitude` = '-95.417535' ,`PhotoCount` = '18' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '360000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Rusting Creek' ,`StreetNumber` = '2507' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2192' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning Taylor Morrison home is conveniently located in the heart of Shadow Creek Ranch with quick access to great schools, fine dining, shopping and many more amenities. This 3 bedroom, 2 bathroom home offers a formal dining room, large kitchen with breakfast nook, spacious bedrooms and an office or media room. All installed equipment and couch in the media room will stay with the home. Additional features include a beautiful gaslog fireplace with mantel, build in cabinetry, recessed lighting, a large covered patio with no back neighbors, gutters all the way around and a spacious utility room. A/C only 1 year old & water heater only 2 years old. Schedule your appointment today while this lovely home is still available. OPEN HOUSE THURSDAY, 10/20 FROM 4-7 PM!' ,`Acres` = '0.1653' ,`Area` = '5' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-38A (PEARLAND), BLOCK 1, LOT 27' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'YORK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MCNAIR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf1-Sf2-Sf3' ,`TaxAmount` = '10113' ,`TaxRate` = '3.5409' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946235' WHERE `Matrix_Unique_ID` = '213771159' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '3322709' ,`ListAgentFullName` = 'Kellie Geitner' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834139' ,`Longitude` = '-95.429907' ,`PhotoCount` = '29' ,`PostalCode` = '77018' ,`RoomCount` = '8' ,`ListPrice` = '549000.00' ,`Status` = 'Active' ,`StreetName` = 'Ella' ,`StreetNumber` = '4703' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come view this charming, traditional 3 bed and 2.1 bath home with a study on a corner lot in Oak Forest. Zoned to Oak Forest Elementary and conveniently located near Candlelight Park and Shepard Park Plaza, the home features a generator, updated windows, hardwood flooring, remodeled bathrooms with porcelain tile and quartz countertops, spacious kitchen and living areas, covered patio, and large turfed backyard. This home has an inviting open floor plan excellent for relaxation and/or entertaining. 2 car garage with driveway entry on Cheshire Lane. Never flooded per Seller and ready for immediate move in !' ,`Acres` = '0.23' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 29 BLK 32 OAK FOREST SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '10200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '40' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest' ,`TaxAmount` = '8730' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946235' WHERE `Matrix_Unique_ID` = '213792373' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '35638947' ,`ListAgentFullName` = 'Emmy Rhoades' ,`ListOfficeName` = 'Realty World Elite Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.007976' ,`Longitude` = '-95.632919' ,`PhotoCount` = '32' ,`PostalCode` = '77429' ,`RoomCount` = '15' ,`ListPrice` = '620000.00' ,`Status` = 'Active' ,`StreetName` = 'Brahman Valley' ,`StreetNumber` = '13746' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2993' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING SOLAR PANELED CUL-DE-SAC PERRY HOME in highly rated Tomball ISD!- 4 bedrooms 3.5 bathrooms. Library with French doors set at two-story entry. Open kitchen with under-cabinet lighting offers corner walk-in pantry and large island with built-in seating space. Two-story dining area opens to two-story family room four large windows and wood mantel fireplace. Ceramic tile floors flow throughout. Private master suite. Double doors lead to master bath with dual vanities, garden tub, separate glass-enclosed shower and walk-in closet. First-floor guest suite. Media room with French doors, game room, two secondary bedrooms and a full bath are on the second floor. Extended baseboards and abundant natural light add to this generous design. Covered backyard patio. Water softener. Security camera installed and sprinklers front and back! Mud room leads to three-car garage with 5-foot side extension and a single 16-foot overhead door.' ,`Acres` = '0.246' ,`Area` = '35' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 42 BLK 6 COPPER RIDGE AT INDIAN TRAILS SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10714' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1045' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'WILDWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Copper Rdg/Indian Trls Sec 1' ,`TaxAmount` = '10967' ,`TaxRate` = '2.7564' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946235' WHERE `Matrix_Unique_ID` = '213835912' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T01:22:00.887' ,`MLSNumber` = '62499642' ,`ListAgentFullName` = 'Walter Bering' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.755531' ,`Longitude` = '-95.533608' ,`PhotoCount` = '46' ,`PostalCode` = '77024' ,`RoomCount` = '18' ,`ListPrice` = '2149000.00' ,`Status` = 'Active' ,`StreetName` = 'Knipp' ,`StreetNumber` = '147' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4356' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Positioned on a corner lot, this superb home is nestled amid expanses of colorful landscaping, a colossal magnolia tree, and clusters of towering trees. This Sandalwood home is graced with a coveted lake front view, filled with distinctive details, and offers a rare single-story living floorplan. A well appointed primary suite enjoys its own wing of the home with an expansive marble-clad bath, two closets, and a private flex room. Open concept living and kitchen area boasts granite countertops, stone floors, views over the lake and professionally landscaped backyard, with an adjacent formal dining room and private study. Secondary bedrooms have en-suite bath access and a gameroom with full bath and patio with treetop views is located on the second story. One-of-a-kind backyard with lake views and private dock, a pool and spa, generous patio space, and vine covered pergola make for the ideal location for home entertainment. This gorgeous home in a prime location won\'t last long!' ,`Acres` = '0.3973' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 5A & 6A BLK 7 SANDALWOOD SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot,Waterfront' ,`LotSize` = '17305' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'FROSTWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sandalwood' ,`TaxAmount` = '50161' ,`TaxRate` = '2.44' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946235' WHERE `Matrix_Unique_ID` = '213838555' --> 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','213856991','1666946235','213856991','2022-10-27T00:00:44.207','75425526','Justin Dickey','Keller Williams Professionals','','','29.405789','-95.059789','24','77568','7','323365.00','Active','Villa Sola','13113','Drive','Texas City','3','0','4','1759','Single-Family','NEW COLINA HOME IN LAGO MAR - LAGOON COMMUNITY!\r\nColina Homes believes in building your dream 1-Story w/ 4 Bedrooms + 3 Full Baths + Covered Patio at a price you CAN afford! Come see this open-concept home with space in all the right places. This beautiful Kitchen features Dark 42” Shaker Cabinets + Luxury Granite + Decorative Tile Back splash + Stainless \"Farmhouse\" Single-Bowl Sink +Stainless Frigidaire Dishwasher, Vented Microwave & 5-BURNER GAS RANGE! TILE Flooring, Kitchen, Dining, Family Rm, Hallways, Utility & ALL Baths. Spacious Master Suite that boasts a HUGE walk-in Closet, 36\"-High Cabinets with Double Sinks, Large soaking Garden Tub with Arm Rests & Spacious Separate Shower with Shampoo Ledge! 3-Sides Acme Brick, 2” Faux Wood Blinds,16 SEER Lennox Air System & much more! This Energy Efficient home will SAVE you $$$! Excellent curb appeal on a Corner Lot! READY NOV - DEC 2022! \r\nPHOTOS ARE REPRESENTATIVE OF FLOOR PLAN.','','33','Colina Homes','','Electric Dryer Connections','','No Disclosures','1','','','Texas City','Central Gas','1','Lot 12 Block 2 Section 3','Subdivision Lot','5600','Survey','','1330','1','To Be Built/Under Construction','2','','0','','','Gas Range','','Composition','17 - Dickinson','LOBIT ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Accompany','Builder','1','Traditional','Lago Mar','0','3.55','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213857024','1666946235','213857024','2022-10-27T00:02:02.330','12042958','Justin Dickey','Keller Williams Professionals','','','30.072302','-95.768449','46','77447','10','391840.00','Active','Capri Shores','19838','Lane','Hockley','3','1','4','2365','Single-Family','COLINA HOMES PRE-SELLING CYPRESS GREEN 635 acre, idyllic lifestyle master-planned Land Tejas community. 365 DAY RATE LOCKS WITH FLOAT DOWN OPTION AVAILABLE. 50\' wide homesites with our popular plans. Just released. 2365SF, 4 Bed/ Gameroom, 3.5 Bath, great features with an unbeatable value. Besides the large country kitchen island that welcomes you home, the features you come to expect from Colina Homes are included: Extensive tile/vinyl planking in all the wet areas/entry and LIVING ROOM, All gas heat, granite in the kitchen, 42\" cabinets, stainless appliances to include our premium 5 burner range, 9\" farm sink, 2\" blinds, Garden Tub and separate shower, Pex Plumbing, Lennox 16- Seer A/C, Taexx Pest Control. All this included for you. Easy access from 2920 near 290, 249 and TX-99. Close to shopping, dining, parks and golf. Offsite sales office at Wedgewood Forest, 731 Wedgewood Park Ln, Conroe, TX 77304. PHOTOS ARE REPRESENTATIVE','','35','Colina Homes','','Electric Dryer Connections','','Mud','1','','','Hockley','Central Gas','1','Lot 21 Block 2 Sec 5','Subdivision Lot','6350','Survey','','800','1','To Be Built/Under Construction','2','','0','','','Freestanding Range,Gas Cooktop','','Composition','55 - Waller','EVELYN TURLINGTON ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','SCHULTZ JUNIOR HIGH SCHOOL','Accompany','Builder','2','Traditional','Cypress Green','','3.371348','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213857105','1666946235','213857105','2022-10-27T00:06:05.127','96832403','Justin Dickey','Keller Williams Professionals','','','30.072230','-95.768165','50','77447','6','357045.00','Active','Capri Shores','19914','Lane','Hockley','3','0','4','2121','Single-Family','COLINA HOMES PRE-SELLING CYPRESS GREEN 635 acre, idyllic lifestyle master-planned Land Tejas community. 365 DAY RATE LOCKS WITH FLOAT DOWN OPTION AVAILABLE. 50\' wide homesites with our popular plans. 3-sides brick w/ stone accent. Just released. 1816 SF, 4 Bed/3 Bath, great features with an unbeatable value. Besides the large country kitchen island that welcomes you home, the features you come to expect from Colina Homes are included: Extensive tile/vinyl planking in all the wet areas/entry and LIVING ROOM, All gas heat, granite in the kitchen, 42\" cabinets, stainless appliances to include our premium 5 burner range, 9\" farm sink, 2\" blinds, Garden Tub and separate shower, Pex Plumbing, Lennox 16- Seer A/C, Taexx Pest Control. All this included for you. Easy access from 2920 near 290, 249 and TX-99. Close to shopping, dining, parks and golf. Offsite sales office at Wedgewood Forest, 731 Wedgewood Park Ln, Conroe, TX 77304.','','35','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Hockley','Central Gas','1','Lot 14 Block 1 Sec 5','Subdivision Lot','6350','Survey','','500','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop','','Composition','55 - Waller','EVELYN TURLINGTON ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','SCHULTZ JUNIOR HIGH SCHOOL','Accompany','Builder','1','Traditional','Cypress Green','','3.713438','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','213857118','1666946235','213857118','2022-10-27T00:07:19.460','67086408','Justin Dickey','Keller Williams Professionals','','','30.072607','-95.768186','50','77447','5','311390.00','Active','Capri Shore','19906','Lane','Hockley','2','0','3','1500','Single-Family','COLINA HOMES PRE-SELLING CYPRESS GREEN 635 acre, idyllic lifestyle master-planned Land Tejas community. 365 DAY RATE LOCKS WITH FLOAT DOWN OPTION AVAILABLE. 50\' wide homesites with our popular plans. 3-sides brick with stone accent, Just released. 1816 SF, 4 Bed/3 Bath, great features with an unbeatable value. Besides the large country kitchen island that welcomes you home, the features you come to expect from Colina Homes are included: Extensive tile/vinyl planking in all the wet areas/entry and LIVING ROOM, All gas heat, granite in the kitchen, 42\" cabinets, stainless appliances to include our premium 5 burner range, 9\" farm sink, 2\" blinds, Garden Tub and separate shower, Pex Plumbing, Lennox 16- Seer A/C, Taexx Pest Control. All this included for you. Easy access from 2920 near 290, 249 and TX-99. Close to shopping, dining, parks and golf. Offsite sales office at Wedgewood Forest, 731 Wedgewood Park Ln, Conroe, TX 77304.','','35','Colina Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','','Hockley','Central Gas','1','Lot 16 Block 1 Sec 5','Greenbelt','6350','Survey','','500','1','To Be Built/Under Construction','2','','0','','','Freestanding Range,Gas Cooktop','','Composition','55 - Waller','EVELYN TURLINGTON ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','SCHULTZ JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Appointment Required','Builder','1','Ranch,Traditional','Cypress Green','','3.71438','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213857216','1666946235','213857216','2022-10-27T00:10:15.253','93700573','Justin Dickey','Keller Williams Professionals','','','30.072351','-95.768239','50','77447','8','344840.00','Active','Capri Shores','19830','Lane','Hockley','3','0','4','1816','Single-Family','COLINA HOMES PRE-SELLING CYPRESS GREEN 635 acre, idyllic lifestyle master-planned Land Tejas community. 365 DAY RATE LOCKS WITH FLOAT DOWN OPTION AVAILABLE. 50\' wide homesites with our popular plans. 3-sides brick w/ stone accent. Just released. 1816 SF, 4 Bed/3 Bath, great features with an unbeatable value. Besides the large country kitchen island that welcomes you home, the features you come to expect from Colina Homes are included: Extensive tile/vinyl planking in all the wet areas/entry and LIVING ROOM, All gas heat, granite in the kitchen, 42\" cabinets, stainless appliances to include our premium 5 burner range, 9\" farm sink, 2\" blinds, Garden Tub and separate shower, Pex Plumbing, Lennox 16- Seer A/C, Taexx Pest Control. All this included for you. Easy access from 2920 near 290, 249 and TX-99. Close to shopping, dining, parks and golf. Offsite sales office at Wedgewood Forest, 731 Wedgewood Park Ln, Conroe, TX 77304.','','35','Colina Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Hockley','Central Gas','1','Lot 19 Block 1 Sec 5','Subdivision Lot','6350','Other','','800','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','55 - Waller','EVELYN TURLINGTON ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','SCHULTZ JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Builder','1','Ranch,Traditional','Cypress Green','','3.713438','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213857316','1666946236','213857316','2022-10-27T00:11:57.340','83314754','Justin Dickey','Keller Williams Professionals','','','29.855698','-95.192330','26','77044','6','265290.00','Active','Lanrin','13215','Court','Houston','2','0','3','1357','Single-Family','COMPLETION JANUARY/FEBRUARY 2023 A beautiful Colina built show-case home, features brick front and cemplank fiber-cement 8” siding 9’ ceilings throughout . Kitchen features large walk-in pantry, 42” Expresso Cabinets, New Caledonia Granite , recessed can lighting, home 9” farmhouse sink stainless-steel sink and stainless-steel appliances to include our premium 5 burner range. Oversized master bedroom and bathroom with marble vanity sink, separate garden tub, glass shower and walk-in closet. 12x12 Twighlight Grey ceramic tile backsplash in all wet areas. Luxury vinyl planking in entry, living room, kitchen bathrooms and hallways. 2\" blinds, garden tub plus separate walk-in shower. Pex Plumbing, Lennox 16 seer A/C. Taexx Pest Control. All this included for you. Don\'t miss out on 365 day rate lock or $0 down no PMI. PHOTOS ARE REPRESENTATIVE.','','2','Colina Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','','North Channel','Central Gas','1','Lot 3 Block 5 Section 6','Greenbelt,Subdivision Lot','5500','Survey','','200','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','46 - Sheldon','SHELDON LAKEE ELEMENTARY SCHOOL','CE KING HIGH SCHOOL','C.E. KING MIDDLE SCHOOL','Accompany','Builder','1','Traditional','Tidwell Lakes','','3','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T00:00:31.260' ,`MLSNumber` = '48220223' ,`ListAgentFullName` = 'Anna Johnston' ,`ListOfficeName` = 'Country Pride Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.313941' ,`Longitude` = '-96.097928' ,`PhotoCount` = '48' ,`PostalCode` = '77488' ,`RoomCount` = '3' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Rusk' ,`StreetNumber` = '401' ,`StreetSuffix` = 'Street' ,`City` = 'Wharton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DID NOT FLOOD! beautiful well maintained 3 bedroom 2 bath home with separate studio/office, 3 car garage with workshop in the back, 19x23 two-story lower level storage and laundry room, second story living quarters. Another storage shed 12x16 in the back on a .67 acre corner lot, FFA projects yard and separate garden yard. Bring your boat and RV, plenty of parking, RV hook up can be converted to EV charger. So much space, storage and potential. wraparound porch, covered deck, custom fireplace, original wood floors, high ceilings, double pane double hung windows, large rooms. 2 hours from Austin, 1 hour from Houston, 1 hour from the bay, 2.5 hours from Corpus Christi, 1 mile to HEB and blocks to downtown shopping. Priced to sell. Room dimensions approximate buyer to confirm.' ,`Acres` = '0.6695' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WHARTON BLOCK 30 LOT 12' ,`LotDesciption` = 'Corner' ,`LotSize` = '29163' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Tile' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean,Spanish' ,`Subdivision` = 'Wharton' ,`TaxAmount` = '5208' ,`TaxRate` = '2.3512' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1927' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946236' WHERE `Matrix_Unique_ID` = '214067756' --> 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','214085771','1666946236','214085771','2022-10-27T00:52:04.033','72430555','Nicole Hudspeth','Keller Williams RealtyNortheast','','','30.016765','-95.284933','42','77338','11','314000.00','Active','Lookout Bend','20406','Drive','Humble','3','1','5','2810','Single-Family','Beautiful move in ready 2 story in the heart of Deerbrook Estates. This like new home with 5 bedrooms and 3.5 baths has NO back neighbors! The open floor concept between the living room and kitchen gives you ample space to entertain. Featuring granite counter tops, recessed lighting, stainless steel appliances, breakfast bar, and hardwood floors. Downstairs primary bedroom with en suite boasts dual sinks, large walk in closet, separate tub, and a separate shower! Upstairs space boasts 4 bedrooms, 2 full baths, laundry room, a large game room, and an additional media room! Wired for surround sound, this space was made for entertaining! Backyard features an extended concrete patio with pergola! Yard equipped with automatic sprinklers and french drains. NEVER FLOODED! Conveniently located within minutes of dining and shopping. Easy access to IAH, I-59, the Grand Parkway, and Beltway. Schedule your showing today!','0.156','12','Lennar','','Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','','','Humble Area West','Central Gas','1','LT 10 BLK 2 DEERBROOK ESTATES SEC 9','Subdivision Lot','6794','Appraisal District','','350','0','','2','Gas Oven','0','','','Gas Range','','Composition','1 - Aldine','JONES ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','JONES MIDDLE SCHOOL (ALDINE)','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Deerbrook Estates','7322','2.8863','Water District','2014','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T00:01:16.233' ,`MLSNumber` = '46290467' ,`ListAgentFullName` = 'Robert Kory' ,`ListOfficeName` = 'CENTURY 21 Western Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748640' ,`Longitude` = '-95.784127' ,`PhotoCount` = '44' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'High Desert' ,`StreetNumber` = '24803' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2194' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1 story, 4 Bedroom, Study, with backyard oasis in Falcon Ranch.' ,`Acres` = '0.2188' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FALCON RANCH SEC 5, BLOCK 7, LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9533' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '694' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RYLANDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'CINCO RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Falcon Ranch' ,`TaxAmount` = '7821' ,`TaxRate` = '2.9495' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946236' WHERE `Matrix_Unique_ID` = '214091467' --> Updated record success